P2K_SMERL is a utility procedure that is called from a variety of PL/SQL procedures, packages and functions.  Its purpose is to write a message out to the [P2K_AM_EXECUTION_RUN_LOGS] table, for reporting or any other purpose.

This routine is used for issuing trace messaging, as well as for outputting messages that will then be reported using the generic report template [UMEX].

!Parameters
|P_MEX_ID|Number|The Execution ID that the run logs will be written against
|[P_MODULE_NAME|MODULE_NAME]|Varchar(30)|Shown on UMEX in the second column
|[P_TRACE_LEVEL|TRACE_LEVEL]|Varchar(1)|A numeric value from 0 to 9, defaulted to "0", if left as NULL
|[P_CONTEXT_1|CONTEXT_1]|Varchar(4000)|A text area to put any contextual information.  Shown on UMEX in the third column
|[P_CONTEXT_2|CONTEXT_2]|Varchar(4000)|A text area to put any contextual information.  Shown on UMEX in the third column
|[P_MESSAGE_CODE|MESSAGE_CODE]|Varchar(4000)|If you provide a message code from [IMMS] this will be shown on the [UMEX] report
|[P_ERROR_LEVEL|ERROR_LEVEL]|Varchar(1)|Usually set to "0"
|[P_RUN_LOG_TEXT|RUN_LOG_TEXT]|Varchar|This is the message that is shown in the [VMEX] grid or on the [UMEX] report, if you have not specified a MESSAGE_CODE