eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.M4U_EGOEVNT_HANDLER dependencies on CLN_DEBUG_PUB

Line 97: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');

93:
94: BEGIN
95:
96: -- Sets the debug mode to be FILE
97: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
98:
99: IF (l_Debug_Level <= 2) THEN
100: cln_debug_pub.Add('==========ENTERING EGO_EVENT_SUB ===========', 2);
101: END IF;

Line 100: cln_debug_pub.Add('==========ENTERING EGO_EVENT_SUB ===========', 2);

96: -- Sets the debug mode to be FILE
97: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
98:
99: IF (l_Debug_Level <= 2) THEN
100: cln_debug_pub.Add('==========ENTERING EGO_EVENT_SUB ===========', 2);
101: END IF;
102:
103: l_m4u_parameters := p_event.getParameterList();
104:

Line 107: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);

103: l_m4u_parameters := p_event.getParameterList();
104:
105: -- parameters obtained with the ego event.
106: IF (l_Debug_Level <= 1) THEN
107: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);
108: END IF;
109:
110: l_ego_batch_id := WF_EVENT.getValueForParameter('ECX_DOCUMENT_ID',l_m4u_parameters);
111: IF (l_Debug_Level <= 1) THEN

Line 112: cln_debug_pub.Add('ECX DOCUMENT ID -EGO BATCH ID ----'||l_ego_batch_id, 1);

108: END IF;
109:
110: l_ego_batch_id := WF_EVENT.getValueForParameter('ECX_DOCUMENT_ID',l_m4u_parameters);
111: IF (l_Debug_Level <= 1) THEN
112: cln_debug_pub.Add('ECX DOCUMENT ID -EGO BATCH ID ----'||l_ego_batch_id, 1);
113: END IF;
114:
115: l_ego_subbatch_id := WF_EVENT.getValueForParameter('ECX_PARAMETER1',l_m4u_parameters);
116: IF (l_Debug_Level <= 1) THEN

Line 117: cln_debug_pub.Add('ECX Param1 -EGO SUB BATCH ID ----'||l_ego_subbatch_id, 1);

113: END IF;
114:
115: l_ego_subbatch_id := WF_EVENT.getValueForParameter('ECX_PARAMETER1',l_m4u_parameters);
116: IF (l_Debug_Level <= 1) THEN
117: cln_debug_pub.Add('ECX Param1 -EGO SUB BATCH ID ----'||l_ego_subbatch_id, 1);
118: END IF;
119:
120: IF (l_Debug_Level <= 1) THEN
121: cln_debug_pub.Add('------------------------------------------', 1);

Line 121: cln_debug_pub.Add('------------------------------------------', 1);

117: cln_debug_pub.Add('ECX Param1 -EGO SUB BATCH ID ----'||l_ego_subbatch_id, 1);
118: END IF;
119:
120: IF (l_Debug_Level <= 1) THEN
121: cln_debug_pub.Add('------------------------------------------', 1);
122: END IF;
123:
124: -- default values
125: l_xmlg_transaction_type := 'M4U';

Line 134: cln_debug_pub.Add('ECX document id ----'|| l_xmlg_document_id, 1);

130: l_create_msg_text := 'M4U_REGISTRATION_INITIATED';
131: l_batch_mode := 'N';
132: l_xmlg_document_id := l_ego_batch_id || ':' || l_ego_subbatch_id;
133: IF (l_Debug_Level <= 1) THEN
134: cln_debug_pub.Add('ECX document id ----'|| l_xmlg_document_id, 1);
135: END IF;
136:
137: -- obtain a unique event-id
138: SELECT m4u_wlqid_s.NEXTVAL

Line 144: cln_debug_pub.Add('XML EVENT KEY ----'||l_xml_event_key,1);

140: FROM dual;
141:
142: l_xml_event_key := 'M4U_EGOEVT_'|| l_xml_event_key;
143: IF (l_Debug_Level <= 1) THEN
144: cln_debug_pub.Add('XML EVENT KEY ----'||l_xml_event_key,1);
145: END IF;
146:
147: /* get count of events, in case of REGISTRATION */
148: /* if count > 1, we use RCIR in Batch mode for Registering the items */

Line 159: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);

155: AND gtin = top_gtin
156: group by event_type;
157:
158: IF (l_Debug_Level <= 1) THEN
159: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);
160: cln_debug_pub.Add('Row Count -- '||l_gtin_count, 1);
161: cln_debug_pub.Add('Event Type -- '||l_event_type, 1);
162: END IF;
163:

Line 160: cln_debug_pub.Add('Row Count -- '||l_gtin_count, 1);

156: group by event_type;
157:
158: IF (l_Debug_Level <= 1) THEN
159: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);
160: cln_debug_pub.Add('Row Count -- '||l_gtin_count, 1);
161: cln_debug_pub.Add('Event Type -- '||l_event_type, 1);
162: END IF;
163:
164: IF (l_event_type = 'REGISTRATION') THEN

Line 161: cln_debug_pub.Add('Event Type -- '||l_event_type, 1);

157:
158: IF (l_Debug_Level <= 1) THEN
159: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);
160: cln_debug_pub.Add('Row Count -- '||l_gtin_count, 1);
161: cln_debug_pub.Add('Event Type -- '||l_event_type, 1);
162: END IF;
163:
164: IF (l_event_type = 'REGISTRATION') THEN
165: l_xmlg_transaction_type := 'M4U';

Line 179: cln_debug_pub.Add('ECX_PARAMETER5 - '||l_ecx_parameter5,1);

175: p_name => 'ECX_PARAMETER5',
176: p_value => l_ecx_parameter5,
177: p_parameterlist => l_m4u_parameters );
178: IF (l_Debug_Level <= 1) THEN
179: cln_debug_pub.Add('ECX_PARAMETER5 - '||l_ecx_parameter5,1);
180: END IF;
181: END IF;
182: ELSIF (l_event_type = 'PUBLICATION') THEN
183: l_xmlg_transaction_type := 'M4U';

Line 191: cln_debug_pub.Add('Gtin count = 1, Querying the table for more attributes...>> ', 1);

187:
188:
189: IF (l_gtin_count = 1) THEN
190: IF (l_Debug_Level <= 1) THEN
191: cln_debug_pub.Add('Gtin count = 1, Querying the table for more attributes...>> ', 1);
192: END IF;
193:
194: SELECT e.event_action, e.gtin, e.top_gtin,
195: e.last_updated_by,e.target_market, e.tp_gln,

Line 212: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);

208: AND e.ORGANIZATION_ID = mtlkfv.ORGANIZATION_ID
209: AND e.last_updated_by = f.user_id(+);
210:
211: IF (l_Debug_Level <= 1) THEN
212: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);
213: cln_debug_pub.Add('Event Action - '||l_event_action, 1);
214: cln_debug_pub.Add('Gtin - '||l_gtin, 1);
215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);
216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);

Line 213: cln_debug_pub.Add('Event Action - '||l_event_action, 1);

209: AND e.last_updated_by = f.user_id(+);
210:
211: IF (l_Debug_Level <= 1) THEN
212: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);
213: cln_debug_pub.Add('Event Action - '||l_event_action, 1);
214: cln_debug_pub.Add('Gtin - '||l_gtin, 1);
215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);
216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);
217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);

Line 214: cln_debug_pub.Add('Gtin - '||l_gtin, 1);

210:
211: IF (l_Debug_Level <= 1) THEN
212: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);
213: cln_debug_pub.Add('Event Action - '||l_event_action, 1);
214: cln_debug_pub.Add('Gtin - '||l_gtin, 1);
215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);
216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);
217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);
218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);

Line 215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);

211: IF (l_Debug_Level <= 1) THEN
212: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);
213: cln_debug_pub.Add('Event Action - '||l_event_action, 1);
214: cln_debug_pub.Add('Gtin - '||l_gtin, 1);
215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);
216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);
217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);
218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);
219: cln_debug_pub.Add('ORG ID - '||l_org_id, 1);

Line 216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);

212: cln_debug_pub.Add('Returned from SELECT query ..>>> ', 1);
213: cln_debug_pub.Add('Event Action - '||l_event_action, 1);
214: cln_debug_pub.Add('Gtin - '||l_gtin, 1);
215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);
216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);
217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);
218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);
219: cln_debug_pub.Add('ORG ID - '||l_org_id, 1);
220: cln_debug_pub.Add('Owner Role - '||l_owner_role, 1);

Line 217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);

213: cln_debug_pub.Add('Event Action - '||l_event_action, 1);
214: cln_debug_pub.Add('Gtin - '||l_gtin, 1);
215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);
216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);
217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);
218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);
219: cln_debug_pub.Add('ORG ID - '||l_org_id, 1);
220: cln_debug_pub.Add('Owner Role - '||l_owner_role, 1);
221: cln_debug_pub.Add('Item Number - '||l_item_number, 1);

Line 218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);

214: cln_debug_pub.Add('Gtin - '||l_gtin, 1);
215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);
216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);
217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);
218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);
219: cln_debug_pub.Add('ORG ID - '||l_org_id, 1);
220: cln_debug_pub.Add('Owner Role - '||l_owner_role, 1);
221: cln_debug_pub.Add('Item Number - '||l_item_number, 1);
222: END IF;

Line 219: cln_debug_pub.Add('ORG ID - '||l_org_id, 1);

215: cln_debug_pub.Add('Top GTIN - '||l_top_gtin, 1);
216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);
217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);
218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);
219: cln_debug_pub.Add('ORG ID - '||l_org_id, 1);
220: cln_debug_pub.Add('Owner Role - '||l_owner_role, 1);
221: cln_debug_pub.Add('Item Number - '||l_item_number, 1);
222: END IF;
223:

Line 220: cln_debug_pub.Add('Owner Role - '||l_owner_role, 1);

216: cln_debug_pub.Add('Doc Owner - '||l_doc_owner, 1);
217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);
218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);
219: cln_debug_pub.Add('ORG ID - '||l_org_id, 1);
220: cln_debug_pub.Add('Owner Role - '||l_owner_role, 1);
221: cln_debug_pub.Add('Item Number - '||l_item_number, 1);
222: END IF;
223:
224: -- setting the values for the attributes of the generic workflow

Line 221: cln_debug_pub.Add('Item Number - '||l_item_number, 1);

217: cln_debug_pub.Add('Target Market - '||l_target_market, 1);
218: cln_debug_pub.Add('TP GLN - '||l_tp_gln, 1);
219: cln_debug_pub.Add('ORG ID - '||l_org_id, 1);
220: cln_debug_pub.Add('Owner Role - '||l_owner_role, 1);
221: cln_debug_pub.Add('Item Number - '||l_item_number, 1);
222: END IF;
223:
224: -- setting the values for the attributes of the generic workflow
225: l_coll_type := l_doc_type||'_'||l_event_action;

Line 233: cln_debug_pub.Add('M4U_DOC_NO - '||l_gtin,1);

229: p_value => l_gtin,
230: p_parameterlist => l_m4u_parameters );
231:
232: IF (l_Debug_Level <= 1) THEN
233: cln_debug_pub.Add('M4U_DOC_NO - '||l_gtin,1);
234: END IF;
235:
236: wf_event.AddParameterToList(
237: p_name => 'M4U_PARTNER_DOC_NO',

Line 242: cln_debug_pub.Add('M4U_PARTNER_DOC_NO - '||l_item_number,1);

238: p_value => l_item_number,
239: p_parameterlist => l_m4u_parameters );
240:
241: IF (l_Debug_Level <= 1) THEN
242: cln_debug_pub.Add('M4U_PARTNER_DOC_NO - '||l_item_number,1);
243: END IF;
244:
245: wf_event.AddParameterToList(
246: p_name => 'M4U_DOC_OWNER',

Line 251: cln_debug_pub.Add('M4U_DOC_OWNER - '||l_doc_owner,1);

247: p_value => l_doc_owner,
248: p_parameterlist => l_m4u_parameters );
249:
250: IF (l_Debug_Level <= 1) THEN
251: cln_debug_pub.Add('M4U_DOC_OWNER - '||l_doc_owner,1);
252: END IF;
253:
254: wf_event.AddParameterToList(
255: p_name => 'M4U_OWNER_ROLE',

Line 260: cln_debug_pub.Add('M4U_OWNER_ROLE - '||l_owner_role,1);

256: p_value => l_owner_role,
257: p_parameterlist => l_m4u_parameters );
258:
259: IF (l_Debug_Level <= 1) THEN
260: cln_debug_pub.Add('M4U_OWNER_ROLE - '||l_owner_role,1);
261: END IF;
262: END IF;
263:
264:

Line 275: cln_debug_pub.Add('ECX_EVENT_KEY - '||l_xml_event_key,1);

271: p_value => l_xml_event_key,
272: p_parameterlist => l_m4u_parameters );
273:
274: IF (l_Debug_Level <= 1) THEN
275: cln_debug_pub.Add('ECX_EVENT_KEY - '||l_xml_event_key,1);
276: END IF;
277:
278: wf_event.AddParameterToList(
279: p_name => 'ECX_TRANSACTION_TYPE',

Line 283: cln_debug_pub.Add('ECX_TRANSACTION_TYPE - '||l_xmlg_transaction_type,1);

279: p_name => 'ECX_TRANSACTION_TYPE',
280: p_value => l_xmlg_transaction_type,
281: p_parameterlist => l_m4u_parameters );
282: IF (l_Debug_Level <= 1) THEN
283: cln_debug_pub.Add('ECX_TRANSACTION_TYPE - '||l_xmlg_transaction_type,1);
284: END IF;
285:
286: wf_event.AddParameterToList(
287: p_name => 'ECX_TRANSACTION_SUBTYPE',

Line 291: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE - '||l_xmlg_transaction_subtype,1);

287: p_name => 'ECX_TRANSACTION_SUBTYPE',
288: p_value => l_xmlg_transaction_subtype,
289: p_parameterlist => l_m4u_parameters );
290: IF (l_Debug_Level <= 1) THEN
291: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE - '||l_xmlg_transaction_subtype,1);
292: END IF;
293:
294: wf_event.AddParameterToList(
295: p_name => 'M4U_CLN_COLL_TYPE',

Line 299: cln_debug_pub.Add('M4U_CLN_COLL_TYPE - '||l_coll_type,1);

295: p_name => 'M4U_CLN_COLL_TYPE',
296: p_value => l_coll_type,
297: p_parameterlist => l_m4u_parameters );
298: IF (l_Debug_Level <= 1) THEN
299: cln_debug_pub.Add('M4U_CLN_COLL_TYPE - '||l_coll_type,1);
300: END IF;
301:
302: wf_event.AddParameterToList(
303: p_name => 'M4U_CLN_DOC_TYPE',

Line 307: cln_debug_pub.Add('M4U_CLN_DOC_TYPE - '||l_doc_type,1);

303: p_name => 'M4U_CLN_DOC_TYPE',
304: p_value => l_doc_type,
305: p_parameterlist => l_m4u_parameters );
306: IF (l_Debug_Level <= 1) THEN
307: cln_debug_pub.Add('M4U_CLN_DOC_TYPE - '||l_doc_type,1);
308: END IF;
309:
310:
311: wf_event.AddParameterToList(

Line 316: cln_debug_pub.Add('ECX_PARAMETER4 - '||l_ego_subbatch_id,1);

312: p_name => 'ECX_PARAMETER4',
313: p_value => l_ego_subbatch_id,
314: p_parameterlist => l_m4u_parameters );
315: IF (l_Debug_Level <= 1) THEN
316: cln_debug_pub.Add('ECX_PARAMETER4 - '||l_ego_subbatch_id,1);
317: END IF;
318:
319: wf_event.AddParameterToList(
320: p_name => 'ECX_PARAMETER2',

Line 324: cln_debug_pub.Add('ECX_PARAMETER2 - '||l_ego_batch_id,1);

320: p_name => 'ECX_PARAMETER2',
321: p_value => l_ego_batch_id,
322: p_parameterlist => l_m4u_parameters );
323: IF (l_Debug_Level <= 1) THEN
324: cln_debug_pub.Add('ECX_PARAMETER2 - '||l_ego_batch_id,1);
325: END IF;
326:
327: wf_event.AddParameterToList(
328: p_name => 'ECX_PARAMETER3',

Line 332: cln_debug_pub.Add('ECX_PARAMETER3 - '||l_event_type,1);

328: p_name => 'ECX_PARAMETER3',
329: p_value => l_event_type,
330: p_parameterlist => l_m4u_parameters );
331: IF (l_Debug_Level <= 1) THEN
332: cln_debug_pub.Add('ECX_PARAMETER3 - '||l_event_type,1);
333: END IF;
334:
335:
336: wf_event.AddParameterToList(

Line 341: cln_debug_pub.Add('ECX_DOCUMENT_ID - '||l_xmlg_document_id,1);

337: p_name => 'ECX_DOCUMENT_ID',
338: p_value => l_xmlg_document_id,
339: p_parameterlist => l_m4u_parameters );
340: IF (l_Debug_Level <= 1) THEN
341: cln_debug_pub.Add('ECX_DOCUMENT_ID - '||l_xmlg_document_id,1);
342: END IF;
343:
344: wf_event.AddParameterToList(
345: p_name => 'MESSAGE_TEXT',

Line 349: cln_debug_pub.Add('MESSAGE_TEXT - '||l_create_msg_text,1);

345: p_name => 'MESSAGE_TEXT',
346: p_value => l_create_msg_text,
347: p_parameterlist => l_m4u_parameters );
348: IF (l_Debug_Level <= 1) THEN
349: cln_debug_pub.Add('MESSAGE_TEXT - '||l_create_msg_text,1);
350: END IF;
351:
352: wf_event.AddParameterToList(
353: p_name => 'ATTRIBUTE1',

Line 357: cln_debug_pub.Add('ATTRIBUTE1 - '||m4u_ucc_utils.g_host_gln,1);

353: p_name => 'ATTRIBUTE1',
354: p_value => m4u_ucc_utils.g_host_gln,
355: p_parameterlist => l_m4u_parameters );
356: IF (l_Debug_Level <= 1) THEN
357: cln_debug_pub.Add('ATTRIBUTE1 - '||m4u_ucc_utils.g_host_gln,1);
358: END IF;
359:
360: wf_event.AddParameterToList(
361: p_name => 'ATTRIBUTE2',

Line 365: cln_debug_pub.Add('ATTRIBUTE2 - '||l_target_market,1);

361: p_name => 'ATTRIBUTE2',
362: p_value => l_target_market,
363: p_parameterlist => l_m4u_parameters );
364: IF (l_Debug_Level <= 1) THEN
365: cln_debug_pub.Add('ATTRIBUTE2 - '||l_target_market,1);
366: END IF;
367:
368: wf_event.AddParameterToList(
369: p_name => 'ATTRIBUTE3',

Line 373: cln_debug_pub.Add('ATTRIBUTE3 - '||l_ego_batch_id,1);

369: p_name => 'ATTRIBUTE3',
370: p_value => l_ego_batch_id,
371: p_parameterlist => l_m4u_parameters );
372: IF (l_Debug_Level <= 1) THEN
373: cln_debug_pub.Add('ATTRIBUTE3 - '||l_ego_batch_id,1);
374: END IF;
375:
376: wf_event.AddParameterToList(
377: p_name => 'ATTRIBUTE4',

Line 381: cln_debug_pub.Add('ATTRIBUTE4 - '||l_ego_subbatch_id,1);

377: p_name => 'ATTRIBUTE4',
378: p_value => l_ego_subbatch_id,
379: p_parameterlist => l_m4u_parameters );
380: IF (l_Debug_Level <= 1) THEN
381: cln_debug_pub.Add('ATTRIBUTE4 - '||l_ego_subbatch_id,1);
382: END IF;
383:
384: wf_event.AddParameterToList(
385: p_name => 'ATTRIBUTE5',

Line 389: cln_debug_pub.Add('ATTRIBUTE5 - '||m4u_ucc_utils.g_supp_gln,1);

385: p_name => 'ATTRIBUTE5',
386: p_value => m4u_ucc_utils.g_supp_gln,
387: p_parameterlist => l_m4u_parameters );
388: IF (l_Debug_Level <= 1) THEN
389: cln_debug_pub.Add('ATTRIBUTE5 - '||m4u_ucc_utils.g_supp_gln,1);
390: END IF;
391:
392: wf_event.AddParameterToList(
393: p_name => 'ATTRIBUTE6',

Line 397: cln_debug_pub.Add('ATTRIBUTE6 - '||l_tp_gln,1);

393: p_name => 'ATTRIBUTE6',
394: p_value => l_tp_gln,
395: p_parameterlist => l_m4u_parameters );
396: IF (l_Debug_Level <= 1) THEN
397: cln_debug_pub.Add('ATTRIBUTE6 - '||l_tp_gln,1);
398: END IF;
399:
400: wf_event.AddParameterToList(
401: p_name => 'ATTRIBUTE12',

Line 405: cln_debug_pub.Add('ATTRIBUTE12 - '||l_xmlg_document_id,1);

401: p_name => 'ATTRIBUTE12',
402: p_value => l_xmlg_document_id,
403: p_parameterlist => l_m4u_parameters );
404: IF (l_Debug_Level <= 1) THEN
405: cln_debug_pub.Add('ATTRIBUTE12 - '||l_xmlg_document_id,1);
406: END IF;
407:
408: wf_event.AddParameterToList(
409: p_name => 'M4U_BATCH_MODE',

Line 413: cln_debug_pub.Add('M4U_BATCH_MODE - '||l_batch_mode,1);

409: p_name => 'M4U_BATCH_MODE',
410: p_value => l_batch_mode,
411: p_parameterlist => l_m4u_parameters );
412: IF (l_Debug_Level <= 1) THEN
413: cln_debug_pub.Add('M4U_BATCH_MODE - '||l_batch_mode,1);
414: END IF;
415:
416: -- set event parameters, end
417: IF (l_Debug_Level <= 1) THEN

Line 418: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);

414: END IF;
415:
416: -- set event parameters, end
417: IF (l_Debug_Level <= 1) THEN
418: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);
419: cln_debug_pub.Add('p_event_key - '||l_xml_event_key ,1);
420: END IF;
421:
422: -- raise event to trigger outbound wlq generation WF

Line 419: cln_debug_pub.Add('p_event_key - '||l_xml_event_key ,1);

415:
416: -- set event parameters, end
417: IF (l_Debug_Level <= 1) THEN
418: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);
419: cln_debug_pub.Add('p_event_key - '||l_xml_event_key ,1);
420: END IF;
421:
422: -- raise event to trigger outbound wlq generation WF
423: wf_event.raise(

Line 431: cln_debug_pub.Add('============EXITING EGO_EVENT_SUB============', 2);

427: );
428:
429: -- check the message
430: IF (l_Debug_Level <= 2) THEN
431: cln_debug_pub.Add('============EXITING EGO_EVENT_SUB============', 2);
432: END IF;
433:
434: RETURN 'SUCCESS' ;
435:

Line 441: cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);

437: WHEN OTHERS THEN
438: l_error_code := SQLCODE;
439: l_error_msg := SQLERRM;
440: IF (l_Debug_Level <= 5) THEN
441: cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);
442: cln_debug_pub.Add('============EXITING EGO_EVENT_SUB============', 2);
443: END IF;
444:
445: RETURN 'SUCCESS';

Line 442: cln_debug_pub.Add('============EXITING EGO_EVENT_SUB============', 2);

438: l_error_code := SQLCODE;
439: l_error_msg := SQLERRM;
440: IF (l_Debug_Level <= 5) THEN
441: cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);
442: cln_debug_pub.Add('============EXITING EGO_EVENT_SUB============', 2);
443: END IF;
444:
445: RETURN 'SUCCESS';
446: