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 | Varchar(30) | |
| P_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 |
