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)|
|[P_TRACE_LEVEL|TRACE_LEVEL]|Varchar(1)|A numeric value from 0 to 9, defaulted to "0", if left as NULL
|P_CONTEXT_1|Varchar(4000)|A text area to put any contextual information
|P_CONTEXT_2|Varchar(4000)|A text area to put any contextual information
|P_MESSAGE_CODE|Varchar(4000)|
|P_ERROR_LEVEL|Varchar(1)|Refers to te values found in [ERROR_LEVEL] - usually set to "0"
|P_RUN_LOG_TEXT|Varchar|This is the message that is shown in the [VMEX] grid or on the [UMEX] report