!!!P2K_SMGETUDF

!Functionality
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

!Errors:
*[TRACE_LEVEL] lexicon values are checked for validity.  If invalid, an ORA-20000 error is raised and the trace level is set to 1
*Any data base errors are output and an ORA-20000 error is raised

!Examples:

;From [UVASSIGNMENTS]:{{p2k_smerl(v_mex_id, v_function,'0',r_crs1.entity_code, 'P2K_CM_ENTITIES','CV#-10001#1ENTITY_CODE#2' ||r_crs1.entity_code ||'#3P2K_CM_ENTITIES','2', NULL);}}
;Minimal call:{{p2k_smerl(v_mex_id, NULL,'0',NULL, NULL,'My Message for UMEX',NULL, NULL);}}

[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.P2K_SMERL] 	
[{InsertPage page='Internal.P2K_SMERL' default='Click to create a new discussion page'}] 	

}]