45: l_error_code NUMBER;
46: l_error_msg VARCHAR2(2000);
47: l_tp_id NUMBER;
48: l_msg_text VARCHAR2(1000);
49: l_cln_ch_parameters wf_parameter_list_t;
50: l_event_key NUMBER;
51: l_entity_number VARCHAR2(30);
52: BEGIN
53: -- Sets the debug mode to be FILE
81: END IF;
82:
83: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
84:
85: l_cln_ch_parameters := wf_parameter_list_t();
86:
87: -- This query can never fail
88: SELECT ENTITY_NUMBER
89: INTO l_entity_number
175: l_debug_mode VARCHAR2(300);
176: l_error_code NUMBER;
177: l_error_msg VARCHAR2(2000);
178: l_msg_text VARCHAR2(2000);
179: l_cln_ch_parameters wf_parameter_list_t;
180: l_event_key NUMBER;
181: l_entity_number VARCHAR2(30);
182:
183: BEGIN
219: AND ROWNUM < 2;
220:
221: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
222:
223: l_cln_ch_parameters := wf_parameter_list_t();
224:
225: -- Set event parameters
226: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctrl_num, l_cln_ch_parameters);
227: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);