This page (revision-5) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
5 26-Nov-2021 10:22 1 KB RForbes to previous
4 26-Nov-2021 10:22 1 KB RForbes to previous | to last
3 26-Nov-2021 10:22 1 KB RForbes to previous | to last
2 26-Nov-2021 10:22 1 KB RForbes to previous | to last
1 26-Nov-2021 10:22 1000 bytes RForbes to last

Page References

Incoming links Outgoing links
P 2 K_SMERL...nobody
P2K_SMERL

Version management

Difference between version and

At line 1 added 3 lines
!!!P2K_SMERL
!Functionality
At line 7 changed one line
|[P_MODULE_NAME|MODULE_NAME]|Varchar(30)|
|[P_MODULE_NAME|MODULE_NAME]|Varchar(30)|Shown on UMEX in the second column
At line 9 changed 5 lines
|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
|[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
At line 18 added 3 lines
!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
At line 22 added 8 lines
!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);}}
----
![Notes|Edit:Internal.P2K_SMERL]
[{InsertPage page='Internal.P2K_SMERL' default='Click to create a new notes page'}]
This page (revision-5) was last changed on 26-Nov-2021 10:22 by RForbesTop