APPS.CLN_CH_EVENT_SUBSCRIPTION_PKG dependencies on WF_EVENT

Line 51: p_event IN OUT NOCOPY WF_EVENT_T

47: -- Notes
48: -- No specific notes.
49:
50: FUNCTION GET_REFERENCE_ID(
51: p_event IN OUT NOCOPY WF_EVENT_T
52: ) RETURN VARCHAR2
53: IS
54: l_evt_parameters wf_parameter_list_t;
55: l_ref_id VARCHAR2(250);

Line 59: l_ecx_msg_event wf_event_t;

55: l_ref_id VARCHAR2(250);
56: l_context VARCHAR2(500);
57: l_wf_item_type VARCHAR2(250);
58: l_wf_item_key VARCHAR2(250);
59: l_ecx_msg_event wf_event_t;
60: l_from_system VARCHAR2(250);
61:
62: BEGIN
63: IF (l_Debug_Level <= 2) THEN

Line 68: l_context := WF_EVENT.getValueForParameter('#CONTEXT',l_evt_parameters);

64: ecx_cln_debug_pub.Add('============ENTERING GET_REFERENCE_ID===============', 2);
65: END IF;
66:
67: l_evt_parameters := p_event.getParameterList();
68: l_context := WF_EVENT.getValueForParameter('#CONTEXT',l_evt_parameters);
69: IF (l_context IS NULL) THEN
70: IF (l_Debug_Level <= 1) THEN
71: ecx_cln_debug_pub.Add('context is null', 1);
72: END IF;

Line 96: l_from_system := wf_event.local_system_name;

92: if l_ecx_msg_event.from_agent is not null
93: then
94: l_from_system := l_ecx_msg_event.from_agent.system;
95: else
96: l_from_system := wf_event.local_system_name;
97: end if;
98:
99: IF (l_Debug_Level <= 1) THEN
100: ecx_cln_debug_pub.Add('System name : ' || l_from_system, 1);

Line 150: p_event IN OUT NOCOPY WF_EVENT_T

146: -- No specific notes.
147:
148: FUNCTION CREATE_EVENT_SUB(
149: p_subscription_guid IN RAW,
150: p_event IN OUT NOCOPY WF_EVENT_T
151: ) RETURN VARCHAR2
152: IS
153: l_cln_ch_parameters wf_parameter_list_t;
154:

Line 246: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);

242: ecx_cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);
243: END IF;
244:
245:
246: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);
247: IF (l_Debug_Level <= 1) THEN
248: ecx_cln_debug_pub.Add('Subscriber List ----'||l_subscriber_list, 1);
249: END IF;
250:

Line 259: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);

255: RETURN 'SUCCESS'; -- No need to consume this event
256: END IF;
257:
258:
259: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);
260: l_xmlg_msg_id := replace(l_xmlg_msg_id,'.',''); -- There is an issue with Workflow
261: IF (l_Debug_Level <= 1) THEN
262: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
263: END IF;

Line 266: l_xmlg_internal_control_number:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);

262: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
263: END IF;
264:
265:
266: l_xmlg_internal_control_number:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);
267: IF (l_Debug_Level <= 1) THEN
268: ecx_cln_debug_pub.Add('XMLG Internal Control Number ----'||l_xmlg_internal_control_number, 1);
269: END IF;
270:

Line 272: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);

268: ecx_cln_debug_pub.Add('XMLG Internal Control Number ----'||l_xmlg_internal_control_number, 1);
269: END IF;
270:
271:
272: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);
273: IF (l_Debug_Level <= 1) THEN
274: ecx_cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
275: END IF;
276:

Line 278: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);

274: ecx_cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
275: END IF;
276:
277:
278: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);
279: IF (l_Debug_Level <= 1) THEN
280: ecx_cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
281: END IF;
282:

Line 284: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);

280: ecx_cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
281: END IF;
282:
283:
284: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);
285: IF (l_Debug_Level <= 1) THEN
286: ecx_cln_debug_pub.Add('XMLG Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
287: END IF;
288:

Line 290: l_xmlg_int_transaction_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);

286: ecx_cln_debug_pub.Add('XMLG Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
287: END IF;
288:
289:
290: l_xmlg_int_transaction_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);
291: IF (l_Debug_Level <= 1) THEN
292: ecx_cln_debug_pub.Add('XMLG Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
293: END IF;
294:

Line 296: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);

292: ecx_cln_debug_pub.Add('XMLG Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
293: END IF;
294:
295:
296: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);
297: IF (l_Debug_Level <= 1) THEN
298: ecx_cln_debug_pub.Add('XMLG Document ID ----'||l_xmlg_document_id, 1);
299: END IF;
300:

Line 302: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);

298: ecx_cln_debug_pub.Add('XMLG Document ID ----'||l_xmlg_document_id, 1);
299: END IF;
300:
301:
302: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);
303: IF (l_Debug_Level <= 1) THEN
304: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
305: END IF;
306:

Line 308: l_tr_partner_type := WF_EVENT.getValueForParameter('TRADING_PARTNER_TYPE',l_cln_ch_parameters);

304: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
305: END IF;
306:
307:
308: l_tr_partner_type := WF_EVENT.getValueForParameter('TRADING_PARTNER_TYPE',l_cln_ch_parameters);
309: IF (l_Debug_Level <= 1) THEN
310: ecx_cln_debug_pub.Add('Trading Partner Type ----'||l_tr_partner_type, 1);
311: END IF;
312:

Line 314: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_cln_ch_parameters);

310: ecx_cln_debug_pub.Add('Trading Partner Type ----'||l_tr_partner_type, 1);
311: END IF;
312:
313:
314: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_cln_ch_parameters);
315: IF (l_Debug_Level <= 1) THEN
316: ecx_cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
317: END IF;
318:

Line 320: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_cln_ch_parameters);

316: ecx_cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
317: END IF;
318:
319:
320: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_cln_ch_parameters);
321: IF (l_Debug_Level <= 1) THEN
322: ecx_cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
323: END IF;
324:

Line 326: l_sender_protocol := WF_EVENT.getValueForParameter('SENDER_COMPONENT',l_cln_ch_parameters);

322: ecx_cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
323: END IF;
324:
325:
326: l_sender_protocol := WF_EVENT.getValueForParameter('SENDER_COMPONENT',l_cln_ch_parameters);
327: IF (l_Debug_Level <= 1) THEN
328: ecx_cln_debug_pub.Add('Sender Protocol ----'||l_sender_protocol, 1);
329: END IF;
330:

Line 332: l_ref_id := WF_EVENT.getValueForParameter('REFERENCE_ID',l_cln_ch_parameters);

328: ecx_cln_debug_pub.Add('Sender Protocol ----'||l_sender_protocol, 1);
329: END IF;
330:
331:
332: l_ref_id := WF_EVENT.getValueForParameter('REFERENCE_ID',l_cln_ch_parameters);
333: IF (l_Debug_Level <= 1) THEN
334: ecx_cln_debug_pub.Add('Reference ID ----'||l_ref_id, 1);
335: END IF;
336:

Line 338: l_doc_no := WF_EVENT.getValueForParameter('DOCUMENT_NO',l_cln_ch_parameters);

334: ecx_cln_debug_pub.Add('Reference ID ----'||l_ref_id, 1);
335: END IF;
336:
337:
338: l_doc_no := WF_EVENT.getValueForParameter('DOCUMENT_NO',l_cln_ch_parameters);
339: IF (l_Debug_Level <= 1) THEN
340: ecx_cln_debug_pub.Add('Document Number ----'||l_doc_no, 1);
341: END IF;
342:

Line 344: l_org_id := To_Number(WF_EVENT.getValueForParameter('ORG_ID',l_cln_ch_parameters));

340: ecx_cln_debug_pub.Add('Document Number ----'||l_doc_no, 1);
341: END IF;
342:
343:
344: l_org_id := To_Number(WF_EVENT.getValueForParameter('ORG_ID',l_cln_ch_parameters));
345: IF (l_Debug_Level <= 1) THEN
346: ecx_cln_debug_pub.Add('Org ID ----'||l_org_id, 1);
347: END IF;
348:

Line 350: l_rel_no := WF_EVENT.getValueForParameter('RELEASE_NO',l_cln_ch_parameters);

346: ecx_cln_debug_pub.Add('Org ID ----'||l_org_id, 1);
347: END IF;
348:
349:
350: l_rel_no := WF_EVENT.getValueForParameter('RELEASE_NO',l_cln_ch_parameters);
351: IF (l_Debug_Level <= 1) THEN
352: ecx_cln_debug_pub.Add('Release Number ----'||l_rel_no, 1);
353: END IF;
354:

Line 356: l_doc_rev_no := WF_EVENT.getValueForParameter('DOCUMENT_REVISION_NO',l_cln_ch_parameters);

352: ecx_cln_debug_pub.Add('Release Number ----'||l_rel_no, 1);
353: END IF;
354:
355:
356: l_doc_rev_no := WF_EVENT.getValueForParameter('DOCUMENT_REVISION_NO',l_cln_ch_parameters);
357: IF (l_Debug_Level <= 1) THEN
358: ecx_cln_debug_pub.Add('Document Revision Number ----'||l_doc_rev_no, 1);
359: END IF;
360:

Line 362: l_partner_doc_no := WF_EVENT.getValueForParameter('PARTNER_DOCUMENT_NO',l_cln_ch_parameters);

358: ecx_cln_debug_pub.Add('Document Revision Number ----'||l_doc_rev_no, 1);
359: END IF;
360:
361:
362: l_partner_doc_no := WF_EVENT.getValueForParameter('PARTNER_DOCUMENT_NO',l_cln_ch_parameters);
363: IF (l_Debug_Level <= 1) THEN
364: ecx_cln_debug_pub.Add('Partner Document No ----'||l_partner_doc_no, 1);
365: END IF;
366:

Line 368: l_resend_count := To_Number(WF_EVENT.getValueForParameter('RESEND_COUNT',l_cln_ch_parameters));

364: ecx_cln_debug_pub.Add('Partner Document No ----'||l_partner_doc_no, 1);
365: END IF;
366:
367:
368: l_resend_count := To_Number(WF_EVENT.getValueForParameter('RESEND_COUNT',l_cln_ch_parameters));
369: IF (l_Debug_Level <= 1) THEN
370: ecx_cln_debug_pub.Add('Resend Count ----'||l_resend_count, 1);
371: END IF;
372:

Line 374: l_doc_creation_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_CREATION_DATE',l_cln_ch_parameters));

370: ecx_cln_debug_pub.Add('Resend Count ----'||l_resend_count, 1);
371: END IF;
372:
373:
374: l_doc_creation_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_CREATION_DATE',l_cln_ch_parameters));
375: IF (l_Debug_Level <= 1) THEN
376: ecx_cln_debug_pub.Add('Document Creation Date ----'||l_doc_creation_date, 1);
377: END IF;
378:

Line 380: l_doc_revision_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_REVISION_DATE',l_cln_ch_parameters));

376: ecx_cln_debug_pub.Add('Document Creation Date ----'||l_doc_creation_date, 1);
377: END IF;
378:
379:
380: l_doc_revision_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_REVISION_DATE',l_cln_ch_parameters));
381: IF (l_Debug_Level <= 1) THEN
382: ecx_cln_debug_pub.Add('Document Revision Date ----'||l_doc_revision_date, 1);
383: END IF;
384:

Line 386: l_coll_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);

382: ecx_cln_debug_pub.Add('Document Revision Date ----'||l_doc_revision_date, 1);
383: END IF;
384:
385:
386: l_coll_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);
387: IF (l_Debug_Level <= 1) THEN
388: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_coll_pt, 1);
389: END IF;
390:

Line 392: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);

388: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_coll_pt, 1);
389: END IF;
390:
391:
392: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);
393: IF (l_Debug_Level <= 1) THEN
394: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
395: END IF;
396:

Line 398: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);

394: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
395: END IF;
396:
397:
398: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);
399: IF (l_Debug_Level <= 1) THEN
400: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
401: END IF;
402:

Line 403: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);

399: IF (l_Debug_Level <= 1) THEN
400: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
401: END IF;
402:
403: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);
404: IF (l_Debug_Level <= 1) THEN
405: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
406: END IF;
407:

Line 408: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);

404: IF (l_Debug_Level <= 1) THEN
405: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
406: END IF;
407:
408: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);
409: IF (l_Debug_Level <= 1) THEN
410: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
411: END IF;
412:

Line 413: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);

409: IF (l_Debug_Level <= 1) THEN
410: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
411: END IF;
412:
413: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);
414: IF (l_Debug_Level <= 1) THEN
415: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
416: END IF;
417:

Line 418: l_rosettanet_check_required := WF_EVENT.getValueForParameter('ROSETTANET_CHECK_REQUIRED',l_cln_ch_parameters);

414: IF (l_Debug_Level <= 1) THEN
415: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
416: END IF;
417:
418: l_rosettanet_check_required := WF_EVENT.getValueForParameter('ROSETTANET_CHECK_REQUIRED',l_cln_ch_parameters);
419: IF (l_Debug_Level <= 1) THEN
420: ecx_cln_debug_pub.Add('Rosettanet Check Required ----'||l_rosettanet_check_required, 1);
421: END IF;
422:

Line 423: l_doc_owner := To_Number(WF_EVENT.getValueForParameter('DOCUMENT_OWNER',l_cln_ch_parameters));

419: IF (l_Debug_Level <= 1) THEN
420: ecx_cln_debug_pub.Add('Rosettanet Check Required ----'||l_rosettanet_check_required, 1);
421: END IF;
422:
423: l_doc_owner := To_Number(WF_EVENT.getValueForParameter('DOCUMENT_OWNER',l_cln_ch_parameters));
424: IF (l_Debug_Level <= 1) THEN
425: ecx_cln_debug_pub.Add('Document Owner ----'||l_doc_owner, 1);
426: END IF;
427:

Line 428: l_owner_role := WF_EVENT.getValueForParameter('OWNER_ROLE',l_cln_ch_parameters);

424: IF (l_Debug_Level <= 1) THEN
425: ecx_cln_debug_pub.Add('Document Owner ----'||l_doc_owner, 1);
426: END IF;
427:
428: l_owner_role := WF_EVENT.getValueForParameter('OWNER_ROLE',l_cln_ch_parameters);
429: IF (l_Debug_Level <= 1) THEN
430: ecx_cln_debug_pub.Add('Owner Role ----'||l_owner_role, 1);
431: END IF;
432:

Line 433: l_msg_text := WF_EVENT.getValueForParameter('MESSAGE_TEXT',l_cln_ch_parameters);

429: IF (l_Debug_Level <= 1) THEN
430: ecx_cln_debug_pub.Add('Owner Role ----'||l_owner_role, 1);
431: END IF;
432:
433: l_msg_text := WF_EVENT.getValueForParameter('MESSAGE_TEXT',l_cln_ch_parameters);
434: IF (l_Debug_Level <= 1) THEN
435: ecx_cln_debug_pub.Add('Message Text ----'||l_msg_text, 1);
436: END IF;
437:

Line 438: l_collaboration_standard := WF_EVENT.getValueForParameter('COLLABORATION_STANDARD',l_cln_ch_parameters);

434: IF (l_Debug_Level <= 1) THEN
435: ecx_cln_debug_pub.Add('Message Text ----'||l_msg_text, 1);
436: END IF;
437:
438: l_collaboration_standard := WF_EVENT.getValueForParameter('COLLABORATION_STANDARD',l_cln_ch_parameters);
439: IF (l_Debug_Level <= 1) THEN
440: ecx_cln_debug_pub.Add('Collaboration Standard ----'||l_collaboration_standard, 1);
441: END IF;
442:

Line 443: l_xml_event_key := WF_EVENT.getValueForParameter('XML_EVENT_KEY',l_cln_ch_parameters);

439: IF (l_Debug_Level <= 1) THEN
440: ecx_cln_debug_pub.Add('Collaboration Standard ----'||l_collaboration_standard, 1);
441: END IF;
442:
443: l_xml_event_key := WF_EVENT.getValueForParameter('XML_EVENT_KEY',l_cln_ch_parameters);
444: IF (l_Debug_Level <= 1) THEN
445: ecx_cln_debug_pub.Add('XMLG Event Key ----'||l_xml_event_key, 1);
446: END IF;
447:

Line 448: l_app_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);

444: IF (l_Debug_Level <= 1) THEN
445: ecx_cln_debug_pub.Add('XMLG Event Key ----'||l_xml_event_key, 1);
446: END IF;
447:
448: l_app_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);
449: IF (l_Debug_Level <= 1) THEN
450: ecx_cln_debug_pub.Add('Application ID ----'||l_app_id, 1);
451: END IF;
452:

Line 453: l_coll_type := WF_EVENT.getValueForParameter('COLLABORATION_TYPE',l_cln_ch_parameters);

449: IF (l_Debug_Level <= 1) THEN
450: ecx_cln_debug_pub.Add('Application ID ----'||l_app_id, 1);
451: END IF;
452:
453: l_coll_type := WF_EVENT.getValueForParameter('COLLABORATION_TYPE',l_cln_ch_parameters);
454: IF (l_Debug_Level <= 1) THEN
455: ecx_cln_debug_pub.Add('Collaboration Type ----'||l_coll_type, 1);
456: END IF;
457:

Line 458: l_doc_type := WF_EVENT.getValueForParameter('DOCUMENT_TYPE',l_cln_ch_parameters);

454: IF (l_Debug_Level <= 1) THEN
455: ecx_cln_debug_pub.Add('Collaboration Type ----'||l_coll_type, 1);
456: END IF;
457:
458: l_doc_type := WF_EVENT.getValueForParameter('DOCUMENT_TYPE',l_cln_ch_parameters);
459: IF (l_Debug_Level <= 1) THEN
460: ecx_cln_debug_pub.Add('Document Type ----'||l_doc_type, 1);
461: END IF;
462:

Line 463: l_init_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('COLLABORATION_INITIATION_DATE',l_cln_ch_parameters));

459: IF (l_Debug_Level <= 1) THEN
460: ecx_cln_debug_pub.Add('Document Type ----'||l_doc_type, 1);
461: END IF;
462:
463: l_init_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('COLLABORATION_INITIATION_DATE',l_cln_ch_parameters));
464: IF (l_Debug_Level <= 1) THEN
465: ecx_cln_debug_pub.Add('Initiation Date ----'||l_init_date, 1);
466: END IF;
467:

Line 468: l_attribute1 := WF_EVENT.getValueForParameter('ATTRIBUTE1',l_cln_ch_parameters);

464: IF (l_Debug_Level <= 1) THEN
465: ecx_cln_debug_pub.Add('Initiation Date ----'||l_init_date, 1);
466: END IF;
467:
468: l_attribute1 := WF_EVENT.getValueForParameter('ATTRIBUTE1',l_cln_ch_parameters);
469: IF (l_Debug_Level <= 1) THEN
470: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
471: END IF;
472:

Line 473: l_attribute2 := WF_EVENT.getValueForParameter('ATTRIBUTE2',l_cln_ch_parameters);

469: IF (l_Debug_Level <= 1) THEN
470: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
471: END IF;
472:
473: l_attribute2 := WF_EVENT.getValueForParameter('ATTRIBUTE2',l_cln_ch_parameters);
474: IF (l_Debug_Level <= 1) THEN
475: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
476: END IF;
477:

Line 478: l_attribute3 := WF_EVENT.getValueForParameter('ATTRIBUTE3',l_cln_ch_parameters);

474: IF (l_Debug_Level <= 1) THEN
475: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
476: END IF;
477:
478: l_attribute3 := WF_EVENT.getValueForParameter('ATTRIBUTE3',l_cln_ch_parameters);
479: IF (l_Debug_Level <= 1) THEN
480: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
481: END IF;
482:

Line 483: l_attribute4 := WF_EVENT.getValueForParameter('ATTRIBUTE4',l_cln_ch_parameters);

479: IF (l_Debug_Level <= 1) THEN
480: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
481: END IF;
482:
483: l_attribute4 := WF_EVENT.getValueForParameter('ATTRIBUTE4',l_cln_ch_parameters);
484: IF (l_Debug_Level <= 1) THEN
485: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
486: END IF;
487:

Line 488: l_attribute5 := WF_EVENT.getValueForParameter('ATTRIBUTE5',l_cln_ch_parameters);

484: IF (l_Debug_Level <= 1) THEN
485: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
486: END IF;
487:
488: l_attribute5 := WF_EVENT.getValueForParameter('ATTRIBUTE5',l_cln_ch_parameters);
489: IF (l_Debug_Level <= 1) THEN
490: ecx_cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
491: END IF;
492:

Line 493: l_attribute6 := WF_EVENT.getValueForParameter('ATTRIBUTE6',l_cln_ch_parameters);

489: IF (l_Debug_Level <= 1) THEN
490: ecx_cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
491: END IF;
492:
493: l_attribute6 := WF_EVENT.getValueForParameter('ATTRIBUTE6',l_cln_ch_parameters);
494: IF (l_Debug_Level <= 1) THEN
495: ecx_cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
496: END IF;
497:

Line 498: l_attribute7 := WF_EVENT.getValueForParameter('ATTRIBUTE7',l_cln_ch_parameters);

494: IF (l_Debug_Level <= 1) THEN
495: ecx_cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
496: END IF;
497:
498: l_attribute7 := WF_EVENT.getValueForParameter('ATTRIBUTE7',l_cln_ch_parameters);
499: IF (l_Debug_Level <= 1) THEN
500: ecx_cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
501: END IF;
502:

Line 503: l_attribute8 := WF_EVENT.getValueForParameter('ATTRIBUTE8',l_cln_ch_parameters);

499: IF (l_Debug_Level <= 1) THEN
500: ecx_cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
501: END IF;
502:
503: l_attribute8 := WF_EVENT.getValueForParameter('ATTRIBUTE8',l_cln_ch_parameters);
504: IF (l_Debug_Level <= 1) THEN
505: ecx_cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
506: END IF;
507:

Line 508: l_attribute9 := WF_EVENT.getValueForParameter('ATTRIBUTE9',l_cln_ch_parameters);

504: IF (l_Debug_Level <= 1) THEN
505: ecx_cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
506: END IF;
507:
508: l_attribute9 := WF_EVENT.getValueForParameter('ATTRIBUTE9',l_cln_ch_parameters);
509: IF (l_Debug_Level <= 1) THEN
510: ecx_cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
511: END IF;
512:

Line 513: l_attribute10 := WF_EVENT.getValueForParameter('ATTRIBUTE10',l_cln_ch_parameters);

509: IF (l_Debug_Level <= 1) THEN
510: ecx_cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
511: END IF;
512:
513: l_attribute10 := WF_EVENT.getValueForParameter('ATTRIBUTE10',l_cln_ch_parameters);
514: IF (l_Debug_Level <= 1) THEN
515: ecx_cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
516: END IF;
517:

Line 518: l_attribute11 := WF_EVENT.getValueForParameter('ATTRIBUTE11',l_cln_ch_parameters);

514: IF (l_Debug_Level <= 1) THEN
515: ecx_cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
516: END IF;
517:
518: l_attribute11 := WF_EVENT.getValueForParameter('ATTRIBUTE11',l_cln_ch_parameters);
519: IF (l_Debug_Level <= 1) THEN
520: ecx_cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
521: END IF;
522:

Line 523: l_attribute12 := WF_EVENT.getValueForParameter('ATTRIBUTE12',l_cln_ch_parameters);

519: IF (l_Debug_Level <= 1) THEN
520: ecx_cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
521: END IF;
522:
523: l_attribute12 := WF_EVENT.getValueForParameter('ATTRIBUTE12',l_cln_ch_parameters);
524: IF (l_Debug_Level <= 1) THEN
525: ecx_cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
526: END IF;
527:

Line 528: l_attribute13 := WF_EVENT.getValueForParameter('ATTRIBUTE13',l_cln_ch_parameters);

524: IF (l_Debug_Level <= 1) THEN
525: ecx_cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
526: END IF;
527:
528: l_attribute13 := WF_EVENT.getValueForParameter('ATTRIBUTE13',l_cln_ch_parameters);
529: IF (l_Debug_Level <= 1) THEN
530: ecx_cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
531: END IF;
532:

Line 533: l_attribute14 := WF_EVENT.getValueForParameter('ATTRIBUTE14',l_cln_ch_parameters);

529: IF (l_Debug_Level <= 1) THEN
530: ecx_cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
531: END IF;
532:
533: l_attribute14 := WF_EVENT.getValueForParameter('ATTRIBUTE14',l_cln_ch_parameters);
534: IF (l_Debug_Level <= 1) THEN
535: ecx_cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
536: END IF;
537:

Line 538: l_attribute15 := WF_EVENT.getValueForParameter('ATTRIBUTE15',l_cln_ch_parameters);

534: IF (l_Debug_Level <= 1) THEN
535: ecx_cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
536: END IF;
537:
538: l_attribute15 := WF_EVENT.getValueForParameter('ATTRIBUTE15',l_cln_ch_parameters);
539: IF (l_Debug_Level <= 1) THEN
540: ecx_cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
541: END IF;
542:

Line 543: l_dattribute1 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE1',l_cln_ch_parameters));

539: IF (l_Debug_Level <= 1) THEN
540: ecx_cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
541: END IF;
542:
543: l_dattribute1 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE1',l_cln_ch_parameters));
544: IF (l_Debug_Level <= 1) THEN
545: ecx_cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
546: END IF;
547:

Line 548: l_dattribute2 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE2',l_cln_ch_parameters));

544: IF (l_Debug_Level <= 1) THEN
545: ecx_cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
546: END IF;
547:
548: l_dattribute2 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE2',l_cln_ch_parameters));
549: IF (l_Debug_Level <= 1) THEN
550: ecx_cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
551: END IF;
552:

Line 553: l_dattribute3 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE3',l_cln_ch_parameters));

549: IF (l_Debug_Level <= 1) THEN
550: ecx_cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
551: END IF;
552:
553: l_dattribute3 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE3',l_cln_ch_parameters));
554: IF (l_Debug_Level <= 1) THEN
555: ecx_cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
556: END IF;
557:

Line 558: l_dattribute4 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE4',l_cln_ch_parameters));

554: IF (l_Debug_Level <= 1) THEN
555: ecx_cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
556: END IF;
557:
558: l_dattribute4 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE4',l_cln_ch_parameters));
559: IF (l_Debug_Level <= 1) THEN
560: ecx_cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
561: END IF;
562:

Line 563: l_dattribute5 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE5',l_cln_ch_parameters));

559: IF (l_Debug_Level <= 1) THEN
560: ecx_cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
561: END IF;
562:
563: l_dattribute5 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE5',l_cln_ch_parameters));
564: IF (l_Debug_Level <= 1) THEN
565: ecx_cln_debug_pub.Add('DATTRIBUTE5 ----'||l_dattribute5, 1);
566: END IF;
567:

Line 713: p_event IN OUT NOCOPY WF_EVENT_T

709: -- No specific notes.
710:
711: FUNCTION UPDATE_EVENT_SUB(
712: p_subscription_guid IN RAW,
713: p_event IN OUT NOCOPY WF_EVENT_T
714:
715: ) RETURN VARCHAR2
716: IS
717: l_cln_ch_parameters wf_parameter_list_t;

Line 818: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);

814: IF (l_Debug_Level <= 1) THEN
815: ecx_cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);
816: END IF;
817:
818: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);
819: IF (l_Debug_Level <= 1) THEN
820: ecx_cln_debug_pub.Add('Subscriber List ----'||l_subscriber_list, 1);
821: END IF;
822:

Line 831: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);

827: RETURN 'SUCCESS'; -- No need to consume this event
828: END IF;
829:
830:
831: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);
832: l_xmlg_msg_id := replace(l_xmlg_msg_id,'.',''); -- There is an issue with Workflow
833: IF (l_Debug_Level <= 1) THEN
834: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
835: END IF;

Line 838: l_xmlg_internal_control_number:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);

834: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
835: END IF;
836:
837:
838: l_xmlg_internal_control_number:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);
839: IF (l_Debug_Level <= 1) THEN
840: ecx_cln_debug_pub.Add('XMLG Internal Control Number ----'||l_xmlg_internal_control_number, 1);
841: END IF;
842:

Line 844: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);

840: ecx_cln_debug_pub.Add('XMLG Internal Control Number ----'||l_xmlg_internal_control_number, 1);
841: END IF;
842:
843:
844: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);
845: IF (l_Debug_Level <= 1) THEN
846: ecx_cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
847: END IF;
848:

Line 850: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);

846: ecx_cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
847: END IF;
848:
849:
850: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);
851: IF (l_Debug_Level <= 1) THEN
852: ecx_cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
853: END IF;
854:

Line 856: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);

852: ecx_cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
853: END IF;
854:
855:
856: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);
857: IF (l_Debug_Level <= 1) THEN
858: ecx_cln_debug_pub.Add('XMLG Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
859: END IF;
860:

Line 862: l_xmlg_int_transaction_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);

858: ecx_cln_debug_pub.Add('XMLG Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
859: END IF;
860:
861:
862: l_xmlg_int_transaction_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);
863: IF (l_Debug_Level <= 1) THEN
864: ecx_cln_debug_pub.Add('XMLG Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
865: END IF;
866:

Line 868: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);

864: ecx_cln_debug_pub.Add('XMLG Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
865: END IF;
866:
867:
868: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);
869: IF (l_Debug_Level <= 1) THEN
870: ecx_cln_debug_pub.Add('XMLG Document ID ----'||l_xmlg_document_id, 1);
871: END IF;
872:

Line 874: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);

870: ecx_cln_debug_pub.Add('XMLG Document ID ----'||l_xmlg_document_id, 1);
871: END IF;
872:
873:
874: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);
875: IF (l_Debug_Level <= 1) THEN
876: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
877: END IF;
878:

Line 880: l_tr_partner_type := WF_EVENT.getValueForParameter('TRADING_PARTNER_TYPE',l_cln_ch_parameters);

876: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
877: END IF;
878:
879:
880: l_tr_partner_type := WF_EVENT.getValueForParameter('TRADING_PARTNER_TYPE',l_cln_ch_parameters);
881: IF (l_Debug_Level <= 1) THEN
882: ecx_cln_debug_pub.Add('Trading Partner Type ----'||l_tr_partner_type, 1);
883: END IF;
884:

Line 886: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_cln_ch_parameters);

882: ecx_cln_debug_pub.Add('Trading Partner Type ----'||l_tr_partner_type, 1);
883: END IF;
884:
885:
886: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_cln_ch_parameters);
887: IF (l_Debug_Level <= 1) THEN
888: ecx_cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
889: END IF;
890:

Line 892: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_cln_ch_parameters);

888: ecx_cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
889: END IF;
890:
891:
892: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_cln_ch_parameters);
893: IF (l_Debug_Level <= 1) THEN
894: ecx_cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
895: END IF;
896:

Line 898: l_sender_protocol := WF_EVENT.getValueForParameter('SENDER_COMPONENT',l_cln_ch_parameters);

894: ecx_cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
895: END IF;
896:
897:
898: l_sender_protocol := WF_EVENT.getValueForParameter('SENDER_COMPONENT',l_cln_ch_parameters);
899: IF (l_Debug_Level <= 1) THEN
900: ecx_cln_debug_pub.Add('Sender Protocol ----'||l_sender_protocol, 1);
901: END IF;
902:

Line 904: l_ref_id := WF_EVENT.getValueForParameter('REFERENCE_ID',l_cln_ch_parameters);

900: ecx_cln_debug_pub.Add('Sender Protocol ----'||l_sender_protocol, 1);
901: END IF;
902:
903:
904: l_ref_id := WF_EVENT.getValueForParameter('REFERENCE_ID',l_cln_ch_parameters);
905: IF (l_Debug_Level <= 1) THEN
906: ecx_cln_debug_pub.Add('Reference ID ----'||l_ref_id, 1);
907: END IF;
908:

Line 910: l_doc_no := WF_EVENT.getValueForParameter('DOCUMENT_NO',l_cln_ch_parameters);

906: ecx_cln_debug_pub.Add('Reference ID ----'||l_ref_id, 1);
907: END IF;
908:
909:
910: l_doc_no := WF_EVENT.getValueForParameter('DOCUMENT_NO',l_cln_ch_parameters);
911: IF (l_Debug_Level <= 1) THEN
912: ecx_cln_debug_pub.Add('Document Number ----'||l_doc_no, 1);
913: END IF;
914:

Line 916: l_org_id := To_Number(WF_EVENT.getValueForParameter('ORG_ID',l_cln_ch_parameters));

912: ecx_cln_debug_pub.Add('Document Number ----'||l_doc_no, 1);
913: END IF;
914:
915:
916: l_org_id := To_Number(WF_EVENT.getValueForParameter('ORG_ID',l_cln_ch_parameters));
917: IF (l_Debug_Level <= 1) THEN
918: ecx_cln_debug_pub.Add('Org ID ----'||l_org_id, 1);
919: END IF;
920:

Line 922: l_rel_no := WF_EVENT.getValueForParameter('RELEASE_NO',l_cln_ch_parameters);

918: ecx_cln_debug_pub.Add('Org ID ----'||l_org_id, 1);
919: END IF;
920:
921:
922: l_rel_no := WF_EVENT.getValueForParameter('RELEASE_NO',l_cln_ch_parameters);
923: IF (l_Debug_Level <= 1) THEN
924: ecx_cln_debug_pub.Add('Release Number ----'||l_rel_no, 1);
925: END IF;
926:

Line 928: l_doc_rev_no := WF_EVENT.getValueForParameter('DOCUMENT_REVISION_NO',l_cln_ch_parameters);

924: ecx_cln_debug_pub.Add('Release Number ----'||l_rel_no, 1);
925: END IF;
926:
927:
928: l_doc_rev_no := WF_EVENT.getValueForParameter('DOCUMENT_REVISION_NO',l_cln_ch_parameters);
929: IF (l_Debug_Level <= 1) THEN
930: ecx_cln_debug_pub.Add('Document Revision Number ----'||l_doc_rev_no, 1);
931: END IF;
932:

Line 934: l_partner_doc_no := WF_EVENT.getValueForParameter('PARTNER_DOCUMENT_NO',l_cln_ch_parameters);

930: ecx_cln_debug_pub.Add('Document Revision Number ----'||l_doc_rev_no, 1);
931: END IF;
932:
933:
934: l_partner_doc_no := WF_EVENT.getValueForParameter('PARTNER_DOCUMENT_NO',l_cln_ch_parameters);
935: IF (l_Debug_Level <= 1) THEN
936: ecx_cln_debug_pub.Add('Partner Document No ----'||l_partner_doc_no, 1);
937: END IF;
938:

Line 940: l_resend_count := To_Number(WF_EVENT.getValueForParameter('RESEND_COUNT',l_cln_ch_parameters));

936: ecx_cln_debug_pub.Add('Partner Document No ----'||l_partner_doc_no, 1);
937: END IF;
938:
939:
940: l_resend_count := To_Number(WF_EVENT.getValueForParameter('RESEND_COUNT',l_cln_ch_parameters));
941: IF (l_Debug_Level <= 1) THEN
942: ecx_cln_debug_pub.Add('Resend Count ----'||l_resend_count, 1);
943: END IF;
944:

Line 946: l_doc_creation_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_CREATION_DATE',l_cln_ch_parameters));

942: ecx_cln_debug_pub.Add('Resend Count ----'||l_resend_count, 1);
943: END IF;
944:
945:
946: l_doc_creation_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_CREATION_DATE',l_cln_ch_parameters));
947: IF (l_Debug_Level <= 1) THEN
948: ecx_cln_debug_pub.Add('Document Creation Date ----'||l_doc_creation_date, 1);
949: END IF;
950:

Line 952: l_doc_revision_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_REVISION_DATE',l_cln_ch_parameters));

948: ecx_cln_debug_pub.Add('Document Creation Date ----'||l_doc_creation_date, 1);
949: END IF;
950:
951:
952: l_doc_revision_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_REVISION_DATE',l_cln_ch_parameters));
953: IF (l_Debug_Level <= 1) THEN
954: ecx_cln_debug_pub.Add('Document Revision Date ----'||l_doc_revision_date, 1);
955: END IF;
956:

Line 958: l_coll_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);

954: ecx_cln_debug_pub.Add('Document Revision Date ----'||l_doc_revision_date, 1);
955: END IF;
956:
957:
958: l_coll_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);
959: IF (l_Debug_Level <= 1) THEN
960: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_coll_pt, 1);
961: END IF;
962:

Line 964: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);

960: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_coll_pt, 1);
961: END IF;
962:
963:
964: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);
965: IF (l_Debug_Level <= 1) THEN
966: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
967: END IF;
968:

Line 970: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);

966: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
967: END IF;
968:
969:
970: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);
971: IF (l_Debug_Level <= 1) THEN
972: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
973: END IF;
974:

Line 976: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);

972: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
973: END IF;
974:
975:
976: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);
977: IF (l_Debug_Level <= 1) THEN
978: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
979: END IF;
980:

Line 982: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);

978: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
979: END IF;
980:
981:
982: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);
983: IF (l_Debug_Level <= 1) THEN
984: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
985: END IF;
986:

Line 988: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);

984: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
985: END IF;
986:
987:
988: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);
989: IF (l_Debug_Level <= 1) THEN
990: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
991: END IF;
992:

Line 994: l_rosettanet_check_required := WF_EVENT.getValueForParameter('ROSETTANET_CHECK_REQUIRED',l_cln_ch_parameters);

990: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
991: END IF;
992:
993:
994: l_rosettanet_check_required := WF_EVENT.getValueForParameter('ROSETTANET_CHECK_REQUIRED',l_cln_ch_parameters);
995: IF (l_Debug_Level <= 1) THEN
996: ecx_cln_debug_pub.Add('Rosettanet Check Required ----'||l_rosettanet_check_required, 1);
997: END IF;
998:

Line 1000: l_doc_owner := To_Number(WF_EVENT.getValueForParameter('DOCUMENT_OWNER',l_cln_ch_parameters));

996: ecx_cln_debug_pub.Add('Rosettanet Check Required ----'||l_rosettanet_check_required, 1);
997: END IF;
998:
999:
1000: l_doc_owner := To_Number(WF_EVENT.getValueForParameter('DOCUMENT_OWNER',l_cln_ch_parameters));
1001: IF (l_Debug_Level <= 1) THEN
1002: ecx_cln_debug_pub.Add('Document Owner ----'||l_doc_owner, 1);
1003: END IF;
1004:

Line 1005: l_owner_role := WF_EVENT.getValueForParameter('OWNER_ROLE',l_cln_ch_parameters);

1001: IF (l_Debug_Level <= 1) THEN
1002: ecx_cln_debug_pub.Add('Document Owner ----'||l_doc_owner, 1);
1003: END IF;
1004:
1005: l_owner_role := WF_EVENT.getValueForParameter('OWNER_ROLE',l_cln_ch_parameters);
1006: IF (l_Debug_Level <= 1) THEN
1007: ecx_cln_debug_pub.Add('Owner Role ----'||l_owner_role, 1);
1008: END IF;
1009:

Line 1012: l_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_ID',l_cln_ch_parameters));

1008: END IF;
1009:
1010:
1011:
1012: l_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_ID',l_cln_ch_parameters));
1013: IF (l_Debug_Level <= 1) THEN
1014: ecx_cln_debug_pub.Add('Collaboration ID ----'||l_coll_id, 1);
1015: END IF;
1016:

Line 1018: l_disposition := WF_EVENT.getValueForParameter('DISPOSITION',l_cln_ch_parameters);

1014: ecx_cln_debug_pub.Add('Collaboration ID ----'||l_coll_id, 1);
1015: END IF;
1016:
1017:
1018: l_disposition := WF_EVENT.getValueForParameter('DISPOSITION',l_cln_ch_parameters);
1019: IF (l_Debug_Level <= 1) THEN
1020: ecx_cln_debug_pub.Add('Disposition ----'||l_disposition, 1);
1021: END IF;
1022:

Line 1024: l_org_ref := WF_EVENT.getValueForParameter('ORIGINATOR_REFERENCE',l_cln_ch_parameters);

1020: ecx_cln_debug_pub.Add('Disposition ----'||l_disposition, 1);
1021: END IF;
1022:
1023:
1024: l_org_ref := WF_EVENT.getValueForParameter('ORIGINATOR_REFERENCE',l_cln_ch_parameters);
1025: IF (l_Debug_Level <= 1) THEN
1026: ecx_cln_debug_pub.Add('Originator Reference ----'||l_org_ref, 1);
1027: END IF;
1028:

Line 1030: l_doc_status := WF_EVENT.getValueForParameter('DOCUMENT_STATUS',l_cln_ch_parameters);

1026: ecx_cln_debug_pub.Add('Originator Reference ----'||l_org_ref, 1);
1027: END IF;
1028:
1029:
1030: l_doc_status := WF_EVENT.getValueForParameter('DOCUMENT_STATUS',l_cln_ch_parameters);
1031: IF (l_Debug_Level <= 1) THEN
1032: ecx_cln_debug_pub.Add('Document Status ----'||l_doc_status, 1);
1033: END IF;
1034:

Line 1036: l_msg_text := WF_EVENT.getValueForParameter('MESSAGE_TEXT',l_cln_ch_parameters);

1032: ecx_cln_debug_pub.Add('Document Status ----'||l_doc_status, 1);
1033: END IF;
1034:
1035:
1036: l_msg_text := WF_EVENT.getValueForParameter('MESSAGE_TEXT',l_cln_ch_parameters);
1037: IF (l_Debug_Level <= 1) THEN
1038: ecx_cln_debug_pub.Add('Message Text ----'||l_msg_text, 1);
1039: END IF;
1040:

Line 1041: l_collaboration_standard := WF_EVENT.getValueForParameter('COLLABORATION_STANDARD',l_cln_ch_parameters);

1037: IF (l_Debug_Level <= 1) THEN
1038: ecx_cln_debug_pub.Add('Message Text ----'||l_msg_text, 1);
1039: END IF;
1040:
1041: l_collaboration_standard := WF_EVENT.getValueForParameter('COLLABORATION_STANDARD',l_cln_ch_parameters);
1042: IF (l_Debug_Level <= 1) THEN
1043: ecx_cln_debug_pub.Add('Collaboration Standard ----'||l_collaboration_standard, 1);
1044: END IF;
1045:

Line 1047: l_xml_event_key := WF_EVENT.getValueForParameter('XML_EVENT_KEY',l_cln_ch_parameters);

1043: ecx_cln_debug_pub.Add('Collaboration Standard ----'||l_collaboration_standard, 1);
1044: END IF;
1045:
1046:
1047: l_xml_event_key := WF_EVENT.getValueForParameter('XML_EVENT_KEY',l_cln_ch_parameters);
1048: IF (l_Debug_Level <= 1) THEN
1049: ecx_cln_debug_pub.Add('XMLG Event Key ----'||l_xml_event_key, 1);
1050: END IF;
1051:

Line 1053: l_app_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);

1049: ecx_cln_debug_pub.Add('XMLG Event Key ----'||l_xml_event_key, 1);
1050: END IF;
1051:
1052:
1053: l_app_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);
1054: IF (l_Debug_Level <= 1) THEN
1055: ecx_cln_debug_pub.Add('Application ID ----'||l_app_id, 1);
1056: END IF;
1057:

Line 1058: l_coll_status := WF_EVENT.getValueForParameter('COLLABORATION_STATUS',l_cln_ch_parameters);

1054: IF (l_Debug_Level <= 1) THEN
1055: ecx_cln_debug_pub.Add('Application ID ----'||l_app_id, 1);
1056: END IF;
1057:
1058: l_coll_status := WF_EVENT.getValueForParameter('COLLABORATION_STATUS',l_cln_ch_parameters);
1059: IF (l_Debug_Level <= 1) THEN
1060: ecx_cln_debug_pub.Add('Collaboration Status ----'||l_coll_status, 1);
1061: END IF;
1062:

Line 1063: l_doc_type := WF_EVENT.getValueForParameter('DOCUMENT_TYPE',l_cln_ch_parameters);

1059: IF (l_Debug_Level <= 1) THEN
1060: ecx_cln_debug_pub.Add('Collaboration Status ----'||l_coll_status, 1);
1061: END IF;
1062:
1063: l_doc_type := WF_EVENT.getValueForParameter('DOCUMENT_TYPE',l_cln_ch_parameters);
1064: IF (l_Debug_Level <= 1) THEN
1065: ecx_cln_debug_pub.Add('Document Type ----'||l_doc_type, 1);
1066: END IF;
1067:

Line 1068: l_attribute1 := WF_EVENT.getValueForParameter('ATTRIBUTE1',l_cln_ch_parameters);

1064: IF (l_Debug_Level <= 1) THEN
1065: ecx_cln_debug_pub.Add('Document Type ----'||l_doc_type, 1);
1066: END IF;
1067:
1068: l_attribute1 := WF_EVENT.getValueForParameter('ATTRIBUTE1',l_cln_ch_parameters);
1069: IF (l_Debug_Level <= 1) THEN
1070: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
1071: END IF;
1072:

Line 1073: l_attribute2 := WF_EVENT.getValueForParameter('ATTRIBUTE2',l_cln_ch_parameters);

1069: IF (l_Debug_Level <= 1) THEN
1070: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
1071: END IF;
1072:
1073: l_attribute2 := WF_EVENT.getValueForParameter('ATTRIBUTE2',l_cln_ch_parameters);
1074: IF (l_Debug_Level <= 1) THEN
1075: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
1076: END IF;
1077:

Line 1078: l_attribute3 := WF_EVENT.getValueForParameter('ATTRIBUTE3',l_cln_ch_parameters);

1074: IF (l_Debug_Level <= 1) THEN
1075: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
1076: END IF;
1077:
1078: l_attribute3 := WF_EVENT.getValueForParameter('ATTRIBUTE3',l_cln_ch_parameters);
1079: IF (l_Debug_Level <= 1) THEN
1080: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
1081: END IF;
1082:

Line 1083: l_attribute4 := WF_EVENT.getValueForParameter('ATTRIBUTE4',l_cln_ch_parameters);

1079: IF (l_Debug_Level <= 1) THEN
1080: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
1081: END IF;
1082:
1083: l_attribute4 := WF_EVENT.getValueForParameter('ATTRIBUTE4',l_cln_ch_parameters);
1084: IF (l_Debug_Level <= 1) THEN
1085: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
1086: END IF;
1087:

Line 1088: l_attribute5 := WF_EVENT.getValueForParameter('ATTRIBUTE5',l_cln_ch_parameters);

1084: IF (l_Debug_Level <= 1) THEN
1085: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
1086: END IF;
1087:
1088: l_attribute5 := WF_EVENT.getValueForParameter('ATTRIBUTE5',l_cln_ch_parameters);
1089: IF (l_Debug_Level <= 1) THEN
1090: ecx_cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
1091: END IF;
1092:

Line 1093: l_attribute6 := WF_EVENT.getValueForParameter('ATTRIBUTE6',l_cln_ch_parameters);

1089: IF (l_Debug_Level <= 1) THEN
1090: ecx_cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
1091: END IF;
1092:
1093: l_attribute6 := WF_EVENT.getValueForParameter('ATTRIBUTE6',l_cln_ch_parameters);
1094: IF (l_Debug_Level <= 1) THEN
1095: ecx_cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
1096: END IF;
1097:

Line 1098: l_attribute7 := WF_EVENT.getValueForParameter('ATTRIBUTE7',l_cln_ch_parameters);

1094: IF (l_Debug_Level <= 1) THEN
1095: ecx_cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
1096: END IF;
1097:
1098: l_attribute7 := WF_EVENT.getValueForParameter('ATTRIBUTE7',l_cln_ch_parameters);
1099: IF (l_Debug_Level <= 1) THEN
1100: ecx_cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
1101: END IF;
1102:

Line 1103: l_attribute8 := WF_EVENT.getValueForParameter('ATTRIBUTE8',l_cln_ch_parameters);

1099: IF (l_Debug_Level <= 1) THEN
1100: ecx_cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
1101: END IF;
1102:
1103: l_attribute8 := WF_EVENT.getValueForParameter('ATTRIBUTE8',l_cln_ch_parameters);
1104: IF (l_Debug_Level <= 1) THEN
1105: ecx_cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
1106: END IF;
1107:

Line 1108: l_attribute9 := WF_EVENT.getValueForParameter('ATTRIBUTE9',l_cln_ch_parameters);

1104: IF (l_Debug_Level <= 1) THEN
1105: ecx_cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
1106: END IF;
1107:
1108: l_attribute9 := WF_EVENT.getValueForParameter('ATTRIBUTE9',l_cln_ch_parameters);
1109: IF (l_Debug_Level <= 1) THEN
1110: ecx_cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
1111: END IF;
1112:

Line 1113: l_attribute10 := WF_EVENT.getValueForParameter('ATTRIBUTE10',l_cln_ch_parameters);

1109: IF (l_Debug_Level <= 1) THEN
1110: ecx_cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
1111: END IF;
1112:
1113: l_attribute10 := WF_EVENT.getValueForParameter('ATTRIBUTE10',l_cln_ch_parameters);
1114: IF (l_Debug_Level <= 1) THEN
1115: ecx_cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
1116: END IF;
1117:

Line 1118: l_attribute11 := WF_EVENT.getValueForParameter('ATTRIBUTE11',l_cln_ch_parameters);

1114: IF (l_Debug_Level <= 1) THEN
1115: ecx_cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
1116: END IF;
1117:
1118: l_attribute11 := WF_EVENT.getValueForParameter('ATTRIBUTE11',l_cln_ch_parameters);
1119: IF (l_Debug_Level <= 1) THEN
1120: ecx_cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
1121: END IF;
1122:

Line 1123: l_attribute12 := WF_EVENT.getValueForParameter('ATTRIBUTE12',l_cln_ch_parameters);

1119: IF (l_Debug_Level <= 1) THEN
1120: ecx_cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
1121: END IF;
1122:
1123: l_attribute12 := WF_EVENT.getValueForParameter('ATTRIBUTE12',l_cln_ch_parameters);
1124: IF (l_Debug_Level <= 1) THEN
1125: ecx_cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
1126: END IF;
1127:

Line 1128: l_attribute13 := WF_EVENT.getValueForParameter('ATTRIBUTE13',l_cln_ch_parameters);

1124: IF (l_Debug_Level <= 1) THEN
1125: ecx_cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
1126: END IF;
1127:
1128: l_attribute13 := WF_EVENT.getValueForParameter('ATTRIBUTE13',l_cln_ch_parameters);
1129: IF (l_Debug_Level <= 1) THEN
1130: ecx_cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
1131: END IF;
1132:

Line 1133: l_attribute14 := WF_EVENT.getValueForParameter('ATTRIBUTE14',l_cln_ch_parameters);

1129: IF (l_Debug_Level <= 1) THEN
1130: ecx_cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
1131: END IF;
1132:
1133: l_attribute14 := WF_EVENT.getValueForParameter('ATTRIBUTE14',l_cln_ch_parameters);
1134: IF (l_Debug_Level <= 1) THEN
1135: ecx_cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
1136: END IF;
1137:

Line 1138: l_attribute15 := WF_EVENT.getValueForParameter('ATTRIBUTE15',l_cln_ch_parameters);

1134: IF (l_Debug_Level <= 1) THEN
1135: ecx_cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
1136: END IF;
1137:
1138: l_attribute15 := WF_EVENT.getValueForParameter('ATTRIBUTE15',l_cln_ch_parameters);
1139: IF (l_Debug_Level <= 1) THEN
1140: ecx_cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
1141: END IF;
1142:

Line 1143: l_dattribute1 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE1',l_cln_ch_parameters));

1139: IF (l_Debug_Level <= 1) THEN
1140: ecx_cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
1141: END IF;
1142:
1143: l_dattribute1 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE1',l_cln_ch_parameters));
1144: IF (l_Debug_Level <= 1) THEN
1145: ecx_cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
1146: END IF;
1147:

Line 1148: l_dattribute2 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE2',l_cln_ch_parameters));

1144: IF (l_Debug_Level <= 1) THEN
1145: ecx_cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
1146: END IF;
1147:
1148: l_dattribute2 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE2',l_cln_ch_parameters));
1149: IF (l_Debug_Level <= 1) THEN
1150: ecx_cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
1151: END IF;
1152:

Line 1153: l_dattribute3 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE3',l_cln_ch_parameters));

1149: IF (l_Debug_Level <= 1) THEN
1150: ecx_cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
1151: END IF;
1152:
1153: l_dattribute3 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE3',l_cln_ch_parameters));
1154: IF (l_Debug_Level <= 1) THEN
1155: ecx_cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
1156: END IF;
1157:

Line 1158: l_dattribute4 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE4',l_cln_ch_parameters));

1154: IF (l_Debug_Level <= 1) THEN
1155: ecx_cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
1156: END IF;
1157:
1158: l_dattribute4 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE4',l_cln_ch_parameters));
1159: IF (l_Debug_Level <= 1) THEN
1160: ecx_cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
1161: END IF;
1162:

Line 1163: l_dattribute5 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE5',l_cln_ch_parameters));

1159: IF (l_Debug_Level <= 1) THEN
1160: ecx_cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
1161: END IF;
1162:
1163: l_dattribute5 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE5',l_cln_ch_parameters));
1164: IF (l_Debug_Level <= 1) THEN
1165: ecx_cln_debug_pub.Add('DATTRIBUTE5 ----'||l_dattribute5, 1);
1166: END IF;
1167:

Line 1329: p_event IN OUT NOCOPY WF_EVENT_T

1325:
1326:
1327: FUNCTION ADD_MESSAGES_EVENT_SUB(
1328: p_subscription_guid IN RAW,
1329: p_event IN OUT NOCOPY WF_EVENT_T
1330:
1331: ) RETURN VARCHAR2
1332: IS
1333: l_cln_ch_parameters wf_parameter_list_t;

Line 1388: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);

1384: IF (l_Debug_Level <= 1) THEN
1385: ecx_cln_debug_pub.Add('----------- PARAMETERS OBTAINED FROM EVENT ----------', 1);
1386: END IF;
1387:
1388: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);
1389: IF (l_Debug_Level <= 1) THEN
1390: ecx_cln_debug_pub.Add('Subscriber List ----'||l_subscriber_list, 1);
1391: END IF;
1392:

Line 1402: l_dtl_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_DETAIL_ID',l_cln_ch_parameters));

1398: END IF;
1399:
1400:
1401:
1402: l_dtl_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_DETAIL_ID',l_cln_ch_parameters));
1403: IF (l_Debug_Level <= 1) THEN
1404: ecx_cln_debug_pub.Add('Collaboration Detail ID ----'||l_dtl_coll_id, 1);
1405: END IF;
1406:

Line 1408: l_ref1 := WF_EVENT.getValueForParameter('REFERENCE_ID1',l_cln_ch_parameters);

1404: ecx_cln_debug_pub.Add('Collaboration Detail ID ----'||l_dtl_coll_id, 1);
1405: END IF;
1406:
1407:
1408: l_ref1 := WF_EVENT.getValueForParameter('REFERENCE_ID1',l_cln_ch_parameters);
1409: IF (l_Debug_Level <= 1) THEN
1410: ecx_cln_debug_pub.Add('Reference 1 ----'||l_ref1, 1);
1411: END IF;
1412:

Line 1414: l_ref2 := WF_EVENT.getValueForParameter('REFERENCE_ID2',l_cln_ch_parameters);

1410: ecx_cln_debug_pub.Add('Reference 1 ----'||l_ref1, 1);
1411: END IF;
1412:
1413:
1414: l_ref2 := WF_EVENT.getValueForParameter('REFERENCE_ID2',l_cln_ch_parameters);
1415: IF (l_Debug_Level <= 1) THEN
1416: ecx_cln_debug_pub.Add('Reference 2 ----'||l_ref2, 1);
1417: END IF;
1418:

Line 1420: l_ref3 := WF_EVENT.getValueForParameter('REFERENCE_ID3',l_cln_ch_parameters);

1416: ecx_cln_debug_pub.Add('Reference 2 ----'||l_ref2, 1);
1417: END IF;
1418:
1419:
1420: l_ref3 := WF_EVENT.getValueForParameter('REFERENCE_ID3',l_cln_ch_parameters);
1421: IF (l_Debug_Level <= 1) THEN
1422: ecx_cln_debug_pub.Add('Reference 3 ----'||l_ref3, 1);
1423: END IF;
1424:

Line 1426: l_ref4 := WF_EVENT.getValueForParameter('REFERENCE_ID4',l_cln_ch_parameters);

1422: ecx_cln_debug_pub.Add('Reference 3 ----'||l_ref3, 1);
1423: END IF;
1424:
1425:
1426: l_ref4 := WF_EVENT.getValueForParameter('REFERENCE_ID4',l_cln_ch_parameters);
1427: IF (l_Debug_Level <= 1) THEN
1428: ecx_cln_debug_pub.Add('Reference 4 ----'||l_ref4, 1);
1429: END IF;
1430:

Line 1432: l_ref5 := WF_EVENT.getValueForParameter('REFERENCE_ID5',l_cln_ch_parameters);

1428: ecx_cln_debug_pub.Add('Reference 4 ----'||l_ref4, 1);
1429: END IF;
1430:
1431:
1432: l_ref5 := WF_EVENT.getValueForParameter('REFERENCE_ID5',l_cln_ch_parameters);
1433: IF (l_Debug_Level <= 1) THEN
1434: ecx_cln_debug_pub.Add('Reference 5 ----'||l_ref5, 1);
1435: END IF;
1436:

Line 1438: l_msg_text := WF_EVENT.getValueForParameter('DETAIL_MESSAGE',l_cln_ch_parameters);

1434: ecx_cln_debug_pub.Add('Reference 5 ----'||l_ref5, 1);
1435: END IF;
1436:
1437:
1438: l_msg_text := WF_EVENT.getValueForParameter('DETAIL_MESSAGE',l_cln_ch_parameters);
1439: IF (l_Debug_Level <= 1) THEN
1440: ecx_cln_debug_pub.Add('Detail Message ----'||l_msg_text, 1);
1441: END IF;
1442:

Line 1444: l_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_ID',l_cln_ch_parameters));

1440: ecx_cln_debug_pub.Add('Detail Message ----'||l_msg_text, 1);
1441: END IF;
1442:
1443:
1444: l_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_ID',l_cln_ch_parameters));
1445: IF (l_Debug_Level <= 1) THEN
1446: ecx_cln_debug_pub.Add('Collaboration ID ----'||l_coll_id, 1);
1447: END IF;
1448:

Line 1450: l_doc_type := WF_EVENT.getValueForParameter('DOCUMENT_TYPE',l_cln_ch_parameters);

1446: ecx_cln_debug_pub.Add('Collaboration ID ----'||l_coll_id, 1);
1447: END IF;
1448:
1449:
1450: l_doc_type := WF_EVENT.getValueForParameter('DOCUMENT_TYPE',l_cln_ch_parameters);
1451: IF (l_Debug_Level <= 1) THEN
1452: ecx_cln_debug_pub.Add('Document Type ----'||l_doc_type, 1);
1453: END IF;
1454:

Line 1456: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);

1452: ecx_cln_debug_pub.Add('Document Type ----'||l_doc_type, 1);
1453: END IF;
1454:
1455:
1456: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);
1457: IF (l_Debug_Level <= 1) THEN
1458: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
1459: END IF;
1460:

Line 1462: l_coll_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);

1458: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
1459: END IF;
1460:
1461:
1462: l_coll_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);
1463: IF (l_Debug_Level <= 1) THEN
1464: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_coll_pt, 1);
1465: END IF;
1466:

Line 1468: l_xmlg_internal_control_number := WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);

1464: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_coll_pt, 1);
1465: END IF;
1466:
1467:
1468: l_xmlg_internal_control_number := WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);
1469: IF (l_Debug_Level <= 1) THEN
1470: ecx_cln_debug_pub.Add('Xmlg Internal Control Number ----'||l_xmlg_internal_control_number, 1);
1471: END IF;
1472:

Line 1474: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);

1470: ecx_cln_debug_pub.Add('Xmlg Internal Control Number ----'||l_xmlg_internal_control_number, 1);
1471: END IF;
1472:
1473:
1474: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);
1475: IF (l_Debug_Level <= 1) THEN
1476: ecx_cln_debug_pub.Add('Xmlg Transaction Type ----'||l_xmlg_transaction_type,1);
1477: END IF;
1478:

Line 1480: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);

1476: ecx_cln_debug_pub.Add('Xmlg Transaction Type ----'||l_xmlg_transaction_type,1);
1477: END IF;
1478:
1479:
1480: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);
1481: IF (l_Debug_Level <= 1) THEN
1482: ecx_cln_debug_pub.Add('Xmlg Transaction SubType ----'||l_xmlg_transaction_subtype,1);
1483: END IF;
1484:

Line 1486: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);

1482: ecx_cln_debug_pub.Add('Xmlg Transaction SubType ----'||l_xmlg_transaction_subtype,1);
1483: END IF;
1484:
1485:
1486: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);
1487: IF (l_Debug_Level <= 1) THEN
1488: ecx_cln_debug_pub.Add('Xmlg Document ID ----'||l_xmlg_document_id,1);
1489: END IF;
1490:

Line 1492: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);

1488: ecx_cln_debug_pub.Add('Xmlg Document ID ----'||l_xmlg_document_id,1);
1489: END IF;
1490:
1491:
1492: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);
1493: IF (l_Debug_Level <= 1) THEN
1494: ecx_cln_debug_pub.Add('Xmlg Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
1495: END IF;
1496:

Line 1499: l_xmlg_int_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);

1495: END IF;
1496:
1497:
1498:
1499: l_xmlg_int_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);
1500: IF (l_Debug_Level <= 1) THEN
1501: ecx_cln_debug_pub.Add('Xmlg Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
1502: END IF;
1503:

Line 1505: l_xml_event_key := WF_EVENT.getValueForParameter('XML_EVENT_KEY',l_cln_ch_parameters);

1501: ecx_cln_debug_pub.Add('Xmlg Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
1502: END IF;
1503:
1504:
1505: l_xml_event_key := WF_EVENT.getValueForParameter('XML_EVENT_KEY',l_cln_ch_parameters);
1506: IF (l_Debug_Level <= 1) THEN
1507: ecx_cln_debug_pub.Add('XMLG Event Key ----'||l_xml_event_key, 1);
1508: END IF;
1509:

Line 1511: l_app_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);

1507: ecx_cln_debug_pub.Add('XMLG Event Key ----'||l_xml_event_key, 1);
1508: END IF;
1509:
1510:
1511: l_app_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);
1512: IF (l_Debug_Level <= 1) THEN
1513: ecx_cln_debug_pub.Add('Application ID ----'||l_app_id, 1);
1514: END IF;
1515:

Line 1516: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);

1512: IF (l_Debug_Level <= 1) THEN
1513: ecx_cln_debug_pub.Add('Application ID ----'||l_app_id, 1);
1514: END IF;
1515:
1516: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);
1517: IF (l_Debug_Level <= 1) THEN
1518: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
1519: END IF;
1520:

Line 1521: l_ref_id := WF_EVENT.getValueForParameter('REFERENCE_ID',l_cln_ch_parameters);

1517: IF (l_Debug_Level <= 1) THEN
1518: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
1519: END IF;
1520:
1521: l_ref_id := WF_EVENT.getValueForParameter('REFERENCE_ID',l_cln_ch_parameters);
1522: IF (l_Debug_Level <= 1) THEN
1523: ecx_cln_debug_pub.Add('Reference ID ----'||l_ref_id, 1);
1524: END IF;
1525:

Line 1526: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);

1522: IF (l_Debug_Level <= 1) THEN
1523: ecx_cln_debug_pub.Add('Reference ID ----'||l_ref_id, 1);
1524: END IF;
1525:
1526: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);
1527: IF (l_Debug_Level <= 1) THEN
1528: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
1529: END IF;
1530:

Line 1532: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);

1528: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
1529: END IF;
1530:
1531:
1532: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);
1533: IF (l_Debug_Level <= 1) THEN
1534: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
1535: END IF;
1536:

Line 1538: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);

1534: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
1535: END IF;
1536:
1537:
1538: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);
1539: IF (l_Debug_Level <= 1) THEN
1540: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
1541: END IF;
1542:

Line 1544: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);

1540: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
1541: END IF;
1542:
1543:
1544: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);
1545: IF (l_Debug_Level <= 1) THEN
1546: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
1547: END IF;
1548:

Line 1550: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);

1546: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
1547: END IF;
1548:
1549:
1550: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);
1551: IF (l_Debug_Level <= 1) THEN
1552: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
1553: END IF;
1554:

Line 1650: p_event IN OUT NOCOPY WF_EVENT_T

1646: -- No specific notes.
1647:
1648: FUNCTION ADD_COLLABORATION_EVENT_SUB(
1649: p_subscription_guid IN RAW,
1650: p_event IN OUT NOCOPY WF_EVENT_T
1651:
1652: ) RETURN VARCHAR2
1653: IS
1654: l_cln_ch_parameters wf_parameter_list_t;

Line 1753: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);

1749: IF (l_Debug_Level <= 1) THEN
1750: ecx_cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);
1751: END IF;
1752:
1753: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);
1754: IF (l_Debug_Level <= 1) THEN
1755: ecx_cln_debug_pub.Add('Subscriber List ----'||l_subscriber_list, 1);
1756: END IF;
1757:

Line 1766: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);

1762: RETURN 'SUCCESS'; -- No need to consume this event
1763: END IF;
1764:
1765:
1766: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);
1767: l_xmlg_msg_id := replace(l_xmlg_msg_id,'.',''); -- There is an issue with Workflow
1768: IF (l_Debug_Level <= 1) THEN
1769: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
1770: END IF;

Line 1773: l_xmlg_internal_control_number:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);

1769: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
1770: END IF;
1771:
1772:
1773: l_xmlg_internal_control_number:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);
1774: IF (l_Debug_Level <= 1) THEN
1775: ecx_cln_debug_pub.Add('XMLG Internal Control Number ----'||l_xmlg_internal_control_number, 1);
1776: END IF;
1777:

Line 1779: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);

1775: ecx_cln_debug_pub.Add('XMLG Internal Control Number ----'||l_xmlg_internal_control_number, 1);
1776: END IF;
1777:
1778:
1779: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);
1780: IF (l_Debug_Level <= 1) THEN
1781: ecx_cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
1782: END IF;
1783:

Line 1785: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);

1781: ecx_cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
1782: END IF;
1783:
1784:
1785: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);
1786: IF (l_Debug_Level <= 1) THEN
1787: ecx_cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
1788: END IF;
1789:

Line 1791: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);

1787: ecx_cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
1788: END IF;
1789:
1790:
1791: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);
1792: IF (l_Debug_Level <= 1) THEN
1793: ecx_cln_debug_pub.Add('XMLG Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
1794: END IF;
1795:

Line 1797: l_xmlg_int_transaction_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);

1793: ecx_cln_debug_pub.Add('XMLG Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
1794: END IF;
1795:
1796:
1797: l_xmlg_int_transaction_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);
1798: IF (l_Debug_Level <= 1) THEN
1799: ecx_cln_debug_pub.Add('XMLG Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
1800: END IF;
1801:

Line 1803: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);

1799: ecx_cln_debug_pub.Add('XMLG Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
1800: END IF;
1801:
1802:
1803: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);
1804: IF (l_Debug_Level <= 1) THEN
1805: ecx_cln_debug_pub.Add('XMLG Document ID ----'||l_xmlg_document_id, 1);
1806: END IF;
1807:

Line 1809: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);

1805: ecx_cln_debug_pub.Add('XMLG Document ID ----'||l_xmlg_document_id, 1);
1806: END IF;
1807:
1808:
1809: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);
1810: IF (l_Debug_Level <= 1) THEN
1811: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
1812: END IF;
1813:

Line 1815: l_tr_partner_type := WF_EVENT.getValueForParameter('TRADING_PARTNER_TYPE',l_cln_ch_parameters);

1811: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
1812: END IF;
1813:
1814:
1815: l_tr_partner_type := WF_EVENT.getValueForParameter('TRADING_PARTNER_TYPE',l_cln_ch_parameters);
1816: IF (l_Debug_Level <= 1) THEN
1817: ecx_cln_debug_pub.Add('Trading Partner Type ----'||l_tr_partner_type, 1);
1818: END IF;
1819:

Line 1821: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_cln_ch_parameters);

1817: ecx_cln_debug_pub.Add('Trading Partner Type ----'||l_tr_partner_type, 1);
1818: END IF;
1819:
1820:
1821: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_cln_ch_parameters);
1822: IF (l_Debug_Level <= 1) THEN
1823: ecx_cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
1824: END IF;
1825:

Line 1827: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_cln_ch_parameters);

1823: ecx_cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
1824: END IF;
1825:
1826:
1827: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_cln_ch_parameters);
1828: IF (l_Debug_Level <= 1) THEN
1829: ecx_cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
1830: END IF;
1831:

Line 1833: l_sender_protocol := WF_EVENT.getValueForParameter('SENDER_COMPONENT',l_cln_ch_parameters);

1829: ecx_cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
1830: END IF;
1831:
1832:
1833: l_sender_protocol := WF_EVENT.getValueForParameter('SENDER_COMPONENT',l_cln_ch_parameters);
1834: IF (l_Debug_Level <= 1) THEN
1835: ecx_cln_debug_pub.Add('Sender Protocol ----'||l_sender_protocol, 1);
1836: END IF;
1837:

Line 1839: l_ref_id := WF_EVENT.getValueForParameter('REFERENCE_ID',l_cln_ch_parameters);

1835: ecx_cln_debug_pub.Add('Sender Protocol ----'||l_sender_protocol, 1);
1836: END IF;
1837:
1838:
1839: l_ref_id := WF_EVENT.getValueForParameter('REFERENCE_ID',l_cln_ch_parameters);
1840: IF (l_Debug_Level <= 1) THEN
1841: ecx_cln_debug_pub.Add('Reference ID ----'||l_ref_id, 1);
1842: END IF;
1843:

Line 1845: l_doc_no := WF_EVENT.getValueForParameter('DOCUMENT_NO',l_cln_ch_parameters);

1841: ecx_cln_debug_pub.Add('Reference ID ----'||l_ref_id, 1);
1842: END IF;
1843:
1844:
1845: l_doc_no := WF_EVENT.getValueForParameter('DOCUMENT_NO',l_cln_ch_parameters);
1846: IF (l_Debug_Level <= 1) THEN
1847: ecx_cln_debug_pub.Add('Document Number ----'||l_doc_no, 1);
1848: END IF;
1849:

Line 1851: l_org_id := To_Number(WF_EVENT.getValueForParameter('ORG_ID',l_cln_ch_parameters));

1847: ecx_cln_debug_pub.Add('Document Number ----'||l_doc_no, 1);
1848: END IF;
1849:
1850:
1851: l_org_id := To_Number(WF_EVENT.getValueForParameter('ORG_ID',l_cln_ch_parameters));
1852: IF (l_Debug_Level <= 1) THEN
1853: ecx_cln_debug_pub.Add('Org ID ----'||l_org_id, 1);
1854: END IF;
1855:

Line 1857: l_rel_no := WF_EVENT.getValueForParameter('RELEASE_NO',l_cln_ch_parameters);

1853: ecx_cln_debug_pub.Add('Org ID ----'||l_org_id, 1);
1854: END IF;
1855:
1856:
1857: l_rel_no := WF_EVENT.getValueForParameter('RELEASE_NO',l_cln_ch_parameters);
1858: IF (l_Debug_Level <= 1) THEN
1859: ecx_cln_debug_pub.Add('Release Number ----'||l_rel_no, 1);
1860: END IF;
1861:

Line 1863: l_doc_rev_no := WF_EVENT.getValueForParameter('DOCUMENT_REVISION_NO',l_cln_ch_parameters);

1859: ecx_cln_debug_pub.Add('Release Number ----'||l_rel_no, 1);
1860: END IF;
1861:
1862:
1863: l_doc_rev_no := WF_EVENT.getValueForParameter('DOCUMENT_REVISION_NO',l_cln_ch_parameters);
1864: IF (l_Debug_Level <= 1) THEN
1865: ecx_cln_debug_pub.Add('Document Revision Number ----'||l_doc_rev_no, 1);
1866: END IF;
1867:

Line 1869: l_partner_doc_no := WF_EVENT.getValueForParameter('PARTNER_DOCUMENT_NO',l_cln_ch_parameters);

1865: ecx_cln_debug_pub.Add('Document Revision Number ----'||l_doc_rev_no, 1);
1866: END IF;
1867:
1868:
1869: l_partner_doc_no := WF_EVENT.getValueForParameter('PARTNER_DOCUMENT_NO',l_cln_ch_parameters);
1870: IF (l_Debug_Level <= 1) THEN
1871: ecx_cln_debug_pub.Add('Partner Document No ----'||l_partner_doc_no, 1);
1872: END IF;
1873:

Line 1875: l_resend_count := To_Number(WF_EVENT.getValueForParameter('RESEND_COUNT',l_cln_ch_parameters));

1871: ecx_cln_debug_pub.Add('Partner Document No ----'||l_partner_doc_no, 1);
1872: END IF;
1873:
1874:
1875: l_resend_count := To_Number(WF_EVENT.getValueForParameter('RESEND_COUNT',l_cln_ch_parameters));
1876: IF (l_Debug_Level <= 1) THEN
1877: ecx_cln_debug_pub.Add('Resend Count ----'||l_resend_count, 1);
1878: END IF;
1879:

Line 1881: l_doc_creation_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_CREATION_DATE',l_cln_ch_parameters));

1877: ecx_cln_debug_pub.Add('Resend Count ----'||l_resend_count, 1);
1878: END IF;
1879:
1880:
1881: l_doc_creation_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_CREATION_DATE',l_cln_ch_parameters));
1882: IF (l_Debug_Level <= 1) THEN
1883: ecx_cln_debug_pub.Add('Document Creation Date ----'||l_doc_creation_date, 1);
1884: END IF;
1885:

Line 1887: l_doc_revision_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_REVISION_DATE',l_cln_ch_parameters));

1883: ecx_cln_debug_pub.Add('Document Creation Date ----'||l_doc_creation_date, 1);
1884: END IF;
1885:
1886:
1887: l_doc_revision_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DOCUMENT_REVISION_DATE',l_cln_ch_parameters));
1888: IF (l_Debug_Level <= 1) THEN
1889: ecx_cln_debug_pub.Add('Document Revision Date ----'||l_doc_revision_date, 1);
1890: END IF;
1891:

Line 1893: l_coll_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);

1889: ecx_cln_debug_pub.Add('Document Revision Date ----'||l_doc_revision_date, 1);
1890: END IF;
1891:
1892:
1893: l_coll_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);
1894: IF (l_Debug_Level <= 1) THEN
1895: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_coll_pt, 1);
1896: END IF;
1897:

Line 1899: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);

1895: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_coll_pt, 1);
1896: END IF;
1897:
1898:
1899: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);
1900: IF (l_Debug_Level <= 1) THEN
1901: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
1902: END IF;
1903:

Line 1905: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);

1901: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
1902: END IF;
1903:
1904:
1905: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);
1906: IF (l_Debug_Level <= 1) THEN
1907: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
1908: END IF;
1909:

Line 1911: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);

1907: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
1908: END IF;
1909:
1910:
1911: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);
1912: IF (l_Debug_Level <= 1) THEN
1913: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
1914: END IF;
1915:

Line 1917: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);

1913: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
1914: END IF;
1915:
1916:
1917: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);
1918: IF (l_Debug_Level <= 1) THEN
1919: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
1920: END IF;
1921:

Line 1923: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);

1919: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
1920: END IF;
1921:
1922:
1923: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);
1924: IF (l_Debug_Level <= 1) THEN
1925: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
1926: END IF;
1927:

Line 1929: l_rosettanet_check_required := WF_EVENT.getValueForParameter('ROSETTANET_CHECK_REQUIRED',l_cln_ch_parameters);

1925: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
1926: END IF;
1927:
1928:
1929: l_rosettanet_check_required := WF_EVENT.getValueForParameter('ROSETTANET_CHECK_REQUIRED',l_cln_ch_parameters);
1930: IF (l_Debug_Level <= 1) THEN
1931: ecx_cln_debug_pub.Add('Rosettanet Check Required ----'||l_rosettanet_check_required, 1);
1932: END IF;
1933:

Line 1935: l_doc_owner := To_Number(WF_EVENT.getValueForParameter('DOCUMENT_OWNER',l_cln_ch_parameters));

1931: ecx_cln_debug_pub.Add('Rosettanet Check Required ----'||l_rosettanet_check_required, 1);
1932: END IF;
1933:
1934:
1935: l_doc_owner := To_Number(WF_EVENT.getValueForParameter('DOCUMENT_OWNER',l_cln_ch_parameters));
1936: IF (l_Debug_Level <= 1) THEN
1937: ecx_cln_debug_pub.Add('Document Owner ----'||l_doc_owner, 1);
1938: END IF;
1939:

Line 1940: l_owner_role := WF_EVENT.getValueForParameter('OWNER_ROLE',l_cln_ch_parameters);

1936: IF (l_Debug_Level <= 1) THEN
1937: ecx_cln_debug_pub.Add('Document Owner ----'||l_doc_owner, 1);
1938: END IF;
1939:
1940: l_owner_role := WF_EVENT.getValueForParameter('OWNER_ROLE',l_cln_ch_parameters);
1941: IF (l_Debug_Level <= 1) THEN
1942: ecx_cln_debug_pub.Add('Owner Role ----'||l_owner_role, 1);
1943: END IF;
1944:

Line 1946: l_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_ID',l_cln_ch_parameters));

1942: ecx_cln_debug_pub.Add('Owner Role ----'||l_owner_role, 1);
1943: END IF;
1944:
1945:
1946: l_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_ID',l_cln_ch_parameters));
1947: IF (l_Debug_Level <= 1) THEN
1948: ecx_cln_debug_pub.Add('Collaboration ID ----'||l_coll_id, 1);
1949: END IF;
1950:

Line 1952: l_disposition := WF_EVENT.getValueForParameter('DISPOSITION',l_cln_ch_parameters);

1948: ecx_cln_debug_pub.Add('Collaboration ID ----'||l_coll_id, 1);
1949: END IF;
1950:
1951:
1952: l_disposition := WF_EVENT.getValueForParameter('DISPOSITION',l_cln_ch_parameters);
1953: IF (l_Debug_Level <= 1) THEN
1954: ecx_cln_debug_pub.Add('Disposition ----'||l_disposition, 1);
1955: END IF;
1956:

Line 1958: l_org_ref := WF_EVENT.getValueForParameter('ORIGINATOR_REFERENCE',l_cln_ch_parameters);

1954: ecx_cln_debug_pub.Add('Disposition ----'||l_disposition, 1);
1955: END IF;
1956:
1957:
1958: l_org_ref := WF_EVENT.getValueForParameter('ORIGINATOR_REFERENCE',l_cln_ch_parameters);
1959: IF (l_Debug_Level <= 1) THEN
1960: ecx_cln_debug_pub.Add('Originator Reference ----'||l_org_ref, 1);
1961: END IF;
1962:

Line 1964: l_doc_status := WF_EVENT.getValueForParameter('DOCUMENT_STATUS',l_cln_ch_parameters);

1960: ecx_cln_debug_pub.Add('Originator Reference ----'||l_org_ref, 1);
1961: END IF;
1962:
1963:
1964: l_doc_status := WF_EVENT.getValueForParameter('DOCUMENT_STATUS',l_cln_ch_parameters);
1965: IF (l_Debug_Level <= 1) THEN
1966: ecx_cln_debug_pub.Add('Document Status ----'||l_doc_status, 1);
1967: END IF;
1968:

Line 1970: l_msg_text := WF_EVENT.getValueForParameter('MESSAGE_TEXT',l_cln_ch_parameters);

1966: ecx_cln_debug_pub.Add('Document Status ----'||l_doc_status, 1);
1967: END IF;
1968:
1969:
1970: l_msg_text := WF_EVENT.getValueForParameter('MESSAGE_TEXT',l_cln_ch_parameters);
1971: IF (l_Debug_Level <= 1) THEN
1972: ecx_cln_debug_pub.Add('Message Text ----'||l_msg_text, 1);
1973: END IF;
1974:

Line 1975: l_collaboration_standard := WF_EVENT.getValueForParameter('COLLABORATION_STANDARD',l_cln_ch_parameters);

1971: IF (l_Debug_Level <= 1) THEN
1972: ecx_cln_debug_pub.Add('Message Text ----'||l_msg_text, 1);
1973: END IF;
1974:
1975: l_collaboration_standard := WF_EVENT.getValueForParameter('COLLABORATION_STANDARD',l_cln_ch_parameters);
1976: IF (l_Debug_Level <= 1) THEN
1977: ecx_cln_debug_pub.Add('Collaboration Standard ----'||l_collaboration_standard, 1);
1978: END IF;
1979:

Line 1981: l_xml_event_key := WF_EVENT.getValueForParameter('XML_EVENT_KEY',l_cln_ch_parameters);

1977: ecx_cln_debug_pub.Add('Collaboration Standard ----'||l_collaboration_standard, 1);
1978: END IF;
1979:
1980:
1981: l_xml_event_key := WF_EVENT.getValueForParameter('XML_EVENT_KEY',l_cln_ch_parameters);
1982: IF (l_Debug_Level <= 1) THEN
1983: ecx_cln_debug_pub.Add('XMLG Event Key ----'||l_xml_event_key, 1);
1984: END IF;
1985:

Line 1987: l_app_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);

1983: ecx_cln_debug_pub.Add('XMLG Event Key ----'||l_xml_event_key, 1);
1984: END IF;
1985:
1986:
1987: l_app_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);
1988: IF (l_Debug_Level <= 1) THEN
1989: ecx_cln_debug_pub.Add('Application ID ----'||l_app_id, 1);
1990: END IF;
1991:

Line 1992: l_coll_type := WF_EVENT.getValueForParameter('COLLABORATION_TYPE',l_cln_ch_parameters);

1988: IF (l_Debug_Level <= 1) THEN
1989: ecx_cln_debug_pub.Add('Application ID ----'||l_app_id, 1);
1990: END IF;
1991:
1992: l_coll_type := WF_EVENT.getValueForParameter('COLLABORATION_TYPE',l_cln_ch_parameters);
1993: IF (l_Debug_Level <= 1) THEN
1994: ecx_cln_debug_pub.Add('Collaboration Type ----'||l_coll_type, 1);
1995: END IF;
1996:

Line 1997: l_doc_type := WF_EVENT.getValueForParameter('DOCUMENT_TYPE',l_cln_ch_parameters);

1993: IF (l_Debug_Level <= 1) THEN
1994: ecx_cln_debug_pub.Add('Collaboration Type ----'||l_coll_type, 1);
1995: END IF;
1996:
1997: l_doc_type := WF_EVENT.getValueForParameter('DOCUMENT_TYPE',l_cln_ch_parameters);
1998: IF (l_Debug_Level <= 1) THEN
1999: ecx_cln_debug_pub.Add('Document Type ----'||l_doc_type, 1);
2000: END IF;
2001:

Line 2002: l_init_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('COLLABORATION_INITIATION_DATE',l_cln_ch_parameters));

1998: IF (l_Debug_Level <= 1) THEN
1999: ecx_cln_debug_pub.Add('Document Type ----'||l_doc_type, 1);
2000: END IF;
2001:
2002: l_init_date := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('COLLABORATION_INITIATION_DATE',l_cln_ch_parameters));
2003: IF (l_Debug_Level <= 1) THEN
2004: ecx_cln_debug_pub.Add('Initiation Date ----'||l_init_date, 1);
2005: END IF;
2006:

Line 2007: l_coll_status := WF_EVENT.getValueForParameter('COLLABORATION_STATUS',l_cln_ch_parameters);

2003: IF (l_Debug_Level <= 1) THEN
2004: ecx_cln_debug_pub.Add('Initiation Date ----'||l_init_date, 1);
2005: END IF;
2006:
2007: l_coll_status := WF_EVENT.getValueForParameter('COLLABORATION_STATUS',l_cln_ch_parameters);
2008: IF (l_Debug_Level <= 1) THEN
2009: ecx_cln_debug_pub.Add('Collaboration Status ----'||l_coll_status, 1);
2010: END IF;
2011:

Line 2012: l_attribute1 := WF_EVENT.getValueForParameter('ATTRIBUTE1',l_cln_ch_parameters);

2008: IF (l_Debug_Level <= 1) THEN
2009: ecx_cln_debug_pub.Add('Collaboration Status ----'||l_coll_status, 1);
2010: END IF;
2011:
2012: l_attribute1 := WF_EVENT.getValueForParameter('ATTRIBUTE1',l_cln_ch_parameters);
2013: IF (l_Debug_Level <= 1) THEN
2014: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
2015: END IF;
2016:

Line 2017: l_attribute2 := WF_EVENT.getValueForParameter('ATTRIBUTE2',l_cln_ch_parameters);

2013: IF (l_Debug_Level <= 1) THEN
2014: ecx_cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
2015: END IF;
2016:
2017: l_attribute2 := WF_EVENT.getValueForParameter('ATTRIBUTE2',l_cln_ch_parameters);
2018: IF (l_Debug_Level <= 1) THEN
2019: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
2020: END IF;
2021:

Line 2022: l_attribute3 := WF_EVENT.getValueForParameter('ATTRIBUTE3',l_cln_ch_parameters);

2018: IF (l_Debug_Level <= 1) THEN
2019: ecx_cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
2020: END IF;
2021:
2022: l_attribute3 := WF_EVENT.getValueForParameter('ATTRIBUTE3',l_cln_ch_parameters);
2023: IF (l_Debug_Level <= 1) THEN
2024: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
2025: END IF;
2026:

Line 2027: l_attribute4 := WF_EVENT.getValueForParameter('ATTRIBUTE4',l_cln_ch_parameters);

2023: IF (l_Debug_Level <= 1) THEN
2024: ecx_cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
2025: END IF;
2026:
2027: l_attribute4 := WF_EVENT.getValueForParameter('ATTRIBUTE4',l_cln_ch_parameters);
2028: IF (l_Debug_Level <= 1) THEN
2029: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
2030: END IF;
2031:

Line 2032: l_attribute5 := WF_EVENT.getValueForParameter('ATTRIBUTE5',l_cln_ch_parameters);

2028: IF (l_Debug_Level <= 1) THEN
2029: ecx_cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
2030: END IF;
2031:
2032: l_attribute5 := WF_EVENT.getValueForParameter('ATTRIBUTE5',l_cln_ch_parameters);
2033: IF (l_Debug_Level <= 1) THEN
2034: ecx_cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
2035: END IF;
2036:

Line 2037: l_attribute6 := WF_EVENT.getValueForParameter('ATTRIBUTE6',l_cln_ch_parameters);

2033: IF (l_Debug_Level <= 1) THEN
2034: ecx_cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
2035: END IF;
2036:
2037: l_attribute6 := WF_EVENT.getValueForParameter('ATTRIBUTE6',l_cln_ch_parameters);
2038: IF (l_Debug_Level <= 1) THEN
2039: ecx_cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
2040: END IF;
2041:

Line 2042: l_attribute7 := WF_EVENT.getValueForParameter('ATTRIBUTE7',l_cln_ch_parameters);

2038: IF (l_Debug_Level <= 1) THEN
2039: ecx_cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
2040: END IF;
2041:
2042: l_attribute7 := WF_EVENT.getValueForParameter('ATTRIBUTE7',l_cln_ch_parameters);
2043: IF (l_Debug_Level <= 1) THEN
2044: ecx_cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
2045: END IF;
2046:

Line 2047: l_attribute8 := WF_EVENT.getValueForParameter('ATTRIBUTE8',l_cln_ch_parameters);

2043: IF (l_Debug_Level <= 1) THEN
2044: ecx_cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
2045: END IF;
2046:
2047: l_attribute8 := WF_EVENT.getValueForParameter('ATTRIBUTE8',l_cln_ch_parameters);
2048: IF (l_Debug_Level <= 1) THEN
2049: ecx_cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
2050: END IF;
2051:

Line 2052: l_attribute9 := WF_EVENT.getValueForParameter('ATTRIBUTE9',l_cln_ch_parameters);

2048: IF (l_Debug_Level <= 1) THEN
2049: ecx_cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
2050: END IF;
2051:
2052: l_attribute9 := WF_EVENT.getValueForParameter('ATTRIBUTE9',l_cln_ch_parameters);
2053: IF (l_Debug_Level <= 1) THEN
2054: ecx_cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
2055: END IF;
2056:

Line 2057: l_attribute10 := WF_EVENT.getValueForParameter('ATTRIBUTE10',l_cln_ch_parameters);

2053: IF (l_Debug_Level <= 1) THEN
2054: ecx_cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
2055: END IF;
2056:
2057: l_attribute10 := WF_EVENT.getValueForParameter('ATTRIBUTE10',l_cln_ch_parameters);
2058: IF (l_Debug_Level <= 1) THEN
2059: ecx_cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
2060: END IF;
2061:

Line 2062: l_attribute11 := WF_EVENT.getValueForParameter('ATTRIBUTE11',l_cln_ch_parameters);

2058: IF (l_Debug_Level <= 1) THEN
2059: ecx_cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
2060: END IF;
2061:
2062: l_attribute11 := WF_EVENT.getValueForParameter('ATTRIBUTE11',l_cln_ch_parameters);
2063: IF (l_Debug_Level <= 1) THEN
2064: ecx_cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
2065: END IF;
2066:

Line 2067: l_attribute12 := WF_EVENT.getValueForParameter('ATTRIBUTE12',l_cln_ch_parameters);

2063: IF (l_Debug_Level <= 1) THEN
2064: ecx_cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
2065: END IF;
2066:
2067: l_attribute12 := WF_EVENT.getValueForParameter('ATTRIBUTE12',l_cln_ch_parameters);
2068: IF (l_Debug_Level <= 1) THEN
2069: ecx_cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
2070: END IF;
2071:

Line 2072: l_attribute13 := WF_EVENT.getValueForParameter('ATTRIBUTE13',l_cln_ch_parameters);

2068: IF (l_Debug_Level <= 1) THEN
2069: ecx_cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
2070: END IF;
2071:
2072: l_attribute13 := WF_EVENT.getValueForParameter('ATTRIBUTE13',l_cln_ch_parameters);
2073: IF (l_Debug_Level <= 1) THEN
2074: ecx_cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
2075: END IF;
2076:

Line 2077: l_attribute14 := WF_EVENT.getValueForParameter('ATTRIBUTE14',l_cln_ch_parameters);

2073: IF (l_Debug_Level <= 1) THEN
2074: ecx_cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
2075: END IF;
2076:
2077: l_attribute14 := WF_EVENT.getValueForParameter('ATTRIBUTE14',l_cln_ch_parameters);
2078: IF (l_Debug_Level <= 1) THEN
2079: ecx_cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
2080: END IF;
2081:

Line 2082: l_attribute15 := WF_EVENT.getValueForParameter('ATTRIBUTE15',l_cln_ch_parameters);

2078: IF (l_Debug_Level <= 1) THEN
2079: ecx_cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
2080: END IF;
2081:
2082: l_attribute15 := WF_EVENT.getValueForParameter('ATTRIBUTE15',l_cln_ch_parameters);
2083: IF (l_Debug_Level <= 1) THEN
2084: ecx_cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
2085: END IF;
2086:

Line 2087: l_dattribute1 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE1',l_cln_ch_parameters));

2083: IF (l_Debug_Level <= 1) THEN
2084: ecx_cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
2085: END IF;
2086:
2087: l_dattribute1 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE1',l_cln_ch_parameters));
2088: IF (l_Debug_Level <= 1) THEN
2089: ecx_cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
2090: END IF;
2091:

Line 2092: l_dattribute2 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE2',l_cln_ch_parameters));

2088: IF (l_Debug_Level <= 1) THEN
2089: ecx_cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
2090: END IF;
2091:
2092: l_dattribute2 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE2',l_cln_ch_parameters));
2093: IF (l_Debug_Level <= 1) THEN
2094: ecx_cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
2095: END IF;
2096:

Line 2097: l_dattribute3 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE3',l_cln_ch_parameters));

2093: IF (l_Debug_Level <= 1) THEN
2094: ecx_cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
2095: END IF;
2096:
2097: l_dattribute3 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE3',l_cln_ch_parameters));
2098: IF (l_Debug_Level <= 1) THEN
2099: ecx_cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
2100: END IF;
2101:

Line 2102: l_dattribute4 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE4',l_cln_ch_parameters));

2098: IF (l_Debug_Level <= 1) THEN
2099: ecx_cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
2100: END IF;
2101:
2102: l_dattribute4 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE4',l_cln_ch_parameters));
2103: IF (l_Debug_Level <= 1) THEN
2104: ecx_cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
2105: END IF;
2106:

Line 2107: l_dattribute5 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE5',l_cln_ch_parameters));

2103: IF (l_Debug_Level <= 1) THEN
2104: ecx_cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
2105: END IF;
2106:
2107: l_dattribute5 := CONVERT_TO_DATE(WF_EVENT.getValueForParameter('DATTRIBUTE5',l_cln_ch_parameters));
2108: IF (l_Debug_Level <= 1) THEN
2109: ecx_cln_debug_pub.Add('DATTRIBUTE5 ----'||l_dattribute5, 1);
2110: END IF;
2111:

Line 2279: p_event IN OUT NOCOPY WF_EVENT_T

2275: -- No specific notes.
2276:
2277: FUNCTION NOTIFICATION_EVENT_SUB(
2278: p_subscription_guid IN RAW,
2279: p_event IN OUT NOCOPY WF_EVENT_T
2280: ) RETURN VARCHAR2
2281: IS
2282: l_cln_ch_parameters wf_parameter_list_t;
2283: l_subscriber_list VARCHAR2(1000);

Line 2349: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);

2345: ecx_cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);
2346: END IF;
2347:
2348:
2349: l_subscriber_list:= WF_EVENT.getValueForParameter('SUBSCRIBER_LIST',l_cln_ch_parameters);
2350: IF (l_Debug_Level <= 1) THEN
2351: ecx_cln_debug_pub.Add('Subscriber List ----'||l_subscriber_list, 1);
2352: END IF;
2353:

Line 2362: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);

2358: RETURN 'SUCCESS'; -- No need to consume this event
2359: END IF;
2360:
2361:
2362: l_xmlg_msg_id := WF_EVENT.getValueForParameter('XMLG_MESSAGE_ID',l_cln_ch_parameters);
2363: l_xmlg_msg_id := replace(l_xmlg_msg_id,'.',''); -- There is an issue with Workflow
2364: IF (l_Debug_Level <= 1) THEN
2365: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
2366: END IF;

Line 2369: l_xmlg_internal_control_number:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);

2365: ecx_cln_debug_pub.Add('XMLG Message ID ----'||l_xmlg_msg_id, 1);
2366: END IF;
2367:
2368:
2369: l_xmlg_internal_control_number:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_CONTROL_NUMBER',l_cln_ch_parameters);
2370: IF (l_Debug_Level <= 1) THEN
2371: ecx_cln_debug_pub.Add('XMLG Internal Control Number ----'||l_xmlg_internal_control_number, 1);
2372: END IF;
2373:

Line 2375: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);

2371: ecx_cln_debug_pub.Add('XMLG Internal Control Number ----'||l_xmlg_internal_control_number, 1);
2372: END IF;
2373:
2374:
2375: l_xmlg_transaction_type := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_TYPE',l_cln_ch_parameters);
2376: IF (l_Debug_Level <= 1) THEN
2377: ecx_cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
2378: END IF;
2379:

Line 2381: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);

2377: ecx_cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
2378: END IF;
2379:
2380:
2381: l_xmlg_transaction_subtype := WF_EVENT.getValueForParameter('XMLG_TRANSACTION_SUBTYPE',l_cln_ch_parameters);
2382: IF (l_Debug_Level <= 1) THEN
2383: ecx_cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
2384: END IF;
2385:

Line 2387: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);

2383: ecx_cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
2384: END IF;
2385:
2386:
2387: l_xmlg_int_transaction_type := WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_cln_ch_parameters);
2388: IF (l_Debug_Level <= 1) THEN
2389: ecx_cln_debug_pub.Add('XMLG Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
2390: END IF;
2391:

Line 2393: l_xmlg_int_transaction_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);

2389: ecx_cln_debug_pub.Add('XMLG Int Transaction Type ----'||l_xmlg_int_transaction_type, 1);
2390: END IF;
2391:
2392:
2393: l_xmlg_int_transaction_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_cln_ch_parameters);
2394: IF (l_Debug_Level <= 1) THEN
2395: ecx_cln_debug_pub.Add('XMLG Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
2396: END IF;
2397:

Line 2399: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);

2395: ecx_cln_debug_pub.Add('XMLG Int Transaction Sub Type ----'||l_xmlg_int_transaction_subtype, 1);
2396: END IF;
2397:
2398:
2399: l_xmlg_document_id := WF_EVENT.getValueForParameter('XMLG_DOCUMENT_ID',l_cln_ch_parameters);
2400: IF (l_Debug_Level <= 1) THEN
2401: ecx_cln_debug_pub.Add('XMLG Document ID ----'||l_xmlg_document_id, 1);
2402: END IF;
2403:

Line 2405: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);

2401: ecx_cln_debug_pub.Add('XMLG Document ID ----'||l_xmlg_document_id, 1);
2402: END IF;
2403:
2404:
2405: l_doc_dir := WF_EVENT.getValueForParameter('DOCUMENT_DIRECTION',l_cln_ch_parameters);
2406: IF (l_Debug_Level <= 1) THEN
2407: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
2408: END IF;
2409:

Line 2411: l_tr_partner_type := WF_EVENT.getValueForParameter('TRADING_PARTNER_TYPE',l_cln_ch_parameters);

2407: ecx_cln_debug_pub.Add('Document Direction ----'||l_doc_dir, 1);
2408: END IF;
2409:
2410:
2411: l_tr_partner_type := WF_EVENT.getValueForParameter('TRADING_PARTNER_TYPE',l_cln_ch_parameters);
2412: IF (l_Debug_Level <= 1) THEN
2413: ecx_cln_debug_pub.Add('Trading Partner Type ----'||l_tr_partner_type, 1);
2414: END IF;
2415:

Line 2417: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_cln_ch_parameters);

2413: ecx_cln_debug_pub.Add('Trading Partner Type ----'||l_tr_partner_type, 1);
2414: END IF;
2415:
2416:
2417: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_cln_ch_parameters);
2418: IF (l_Debug_Level <= 1) THEN
2419: ecx_cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
2420: END IF;
2421:

Line 2423: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_cln_ch_parameters);

2419: ecx_cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
2420: END IF;
2421:
2422:
2423: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_cln_ch_parameters);
2424: IF (l_Debug_Level <= 1) THEN
2425: ecx_cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
2426: END IF;
2427:

Line 2429: l_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_ID',l_cln_ch_parameters));

2425: ecx_cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
2426: END IF;
2427:
2428:
2429: l_coll_id := To_Number(WF_EVENT.getValueForParameter('COLLABORATION_ID',l_cln_ch_parameters));
2430: IF (l_Debug_Level <= 1) THEN
2431: ecx_cln_debug_pub.Add('Collaboration ID ----'||l_coll_id, 1);
2432: END IF;
2433:

Line 2436: l_collaboration_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);

2432: END IF;
2433:
2434:
2435:
2436: l_collaboration_pt := WF_EVENT.getValueForParameter('COLLABORATION_POINT',l_cln_ch_parameters);
2437: IF (l_Debug_Level <= 1) THEN
2438: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_collaboration_pt, 1);
2439: END IF;
2440:

Line 2442: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);

2438: ecx_cln_debug_pub.Add('Collaboration Point ----'||l_collaboration_pt, 1);
2439: END IF;
2440:
2441:
2442: l_unique1 := WF_EVENT.getValueForParameter('UNIQUE_ID1',l_cln_ch_parameters);
2443: IF (l_Debug_Level <= 1) THEN
2444: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
2445: END IF;
2446:

Line 2448: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);

2444: ecx_cln_debug_pub.Add('Unique ID1 ----'||l_unique1, 1);
2445: END IF;
2446:
2447:
2448: l_unique2 := WF_EVENT.getValueForParameter('UNIQUE_ID2',l_cln_ch_parameters);
2449: IF (l_Debug_Level <= 1) THEN
2450: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
2451: END IF;
2452:

Line 2453: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);

2449: IF (l_Debug_Level <= 1) THEN
2450: ecx_cln_debug_pub.Add('Unique ID2 ----'||l_unique2, 1);
2451: END IF;
2452:
2453: l_unique3 := WF_EVENT.getValueForParameter('UNIQUE_ID3',l_cln_ch_parameters);
2454: IF (l_Debug_Level <= 1) THEN
2455: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
2456: END IF;
2457:

Line 2458: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);

2454: IF (l_Debug_Level <= 1) THEN
2455: ecx_cln_debug_pub.Add('Unique ID3 ----'||l_unique3, 1);
2456: END IF;
2457:
2458: l_unique4 := WF_EVENT.getValueForParameter('UNIQUE_ID4',l_cln_ch_parameters);
2459: IF (l_Debug_Level <= 1) THEN
2460: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
2461: END IF;
2462:

Line 2463: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);

2459: IF (l_Debug_Level <= 1) THEN
2460: ecx_cln_debug_pub.Add('Unique ID4 ----'||l_unique4, 1);
2461: END IF;
2462:
2463: l_unique5 := WF_EVENT.getValueForParameter('UNIQUE_ID5',l_cln_ch_parameters);
2464: IF (l_Debug_Level <= 1) THEN
2465: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
2466: END IF;
2467:

Line 2468: l_application_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);

2464: IF (l_Debug_Level <= 1) THEN
2465: ecx_cln_debug_pub.Add('Unique ID5 ----'||l_unique5, 1);
2466: END IF;
2467:
2468: l_application_id := WF_EVENT.getValueForParameter('APPLICATION_ID',l_cln_ch_parameters);
2469: IF (l_Debug_Level <= 1) THEN
2470: ecx_cln_debug_pub.Add('Application ID ----'||l_application_id, 1);
2471: END IF;
2472:

Line 2473: l_notification_code := WF_EVENT.getValueForParameter('NOTIFICATION_CODE',l_cln_ch_parameters);

2469: IF (l_Debug_Level <= 1) THEN
2470: ecx_cln_debug_pub.Add('Application ID ----'||l_application_id, 1);
2471: END IF;
2472:
2473: l_notification_code := WF_EVENT.getValueForParameter('NOTIFICATION_CODE',l_cln_ch_parameters);
2474: IF (l_Debug_Level <= 1) THEN
2475: ecx_cln_debug_pub.Add('NOTIFICATION_CODE ----'||l_notification_code, 1);
2476: END IF;
2477:

Line 2478: l_notification_desc := WF_EVENT.getValueForParameter('NOTIFICATION_DESC',l_cln_ch_parameters);

2474: IF (l_Debug_Level <= 1) THEN
2475: ecx_cln_debug_pub.Add('NOTIFICATION_CODE ----'||l_notification_code, 1);
2476: END IF;
2477:
2478: l_notification_desc := WF_EVENT.getValueForParameter('NOTIFICATION_DESC',l_cln_ch_parameters);
2479: IF (l_Debug_Level <= 1) THEN
2480: ecx_cln_debug_pub.Add('NOTIFICATION_DESC ----'||l_notification_desc, 1);
2481: END IF;
2482:

Line 2483: l_notification_status := WF_EVENT.getValueForParameter('NOTIFICATION_STATUS',l_cln_ch_parameters);

2479: IF (l_Debug_Level <= 1) THEN
2480: ecx_cln_debug_pub.Add('NOTIFICATION_DESC ----'||l_notification_desc, 1);
2481: END IF;
2482:
2483: l_notification_status := WF_EVENT.getValueForParameter('NOTIFICATION_STATUS',l_cln_ch_parameters);
2484: IF (l_Debug_Level <= 1) THEN
2485: ecx_cln_debug_pub.Add('NOTIFICATION_STATUS ----'||l_notification_status, 1);
2486: END IF;
2487:

Line 2490: l_attribute_name := WF_EVENT.getValueForParameter('ATTRIBUTE_NAME',l_cln_ch_parameters);

2486: END IF;
2487:
2488: ---------- For Batch Mode -----------
2489:
2490: l_attribute_name := WF_EVENT.getValueForParameter('ATTRIBUTE_NAME',l_cln_ch_parameters);
2491: IF (l_Debug_Level <= 1) THEN
2492: ecx_cln_debug_pub.Add('ATTRIBUTE_NAME ----'||l_attribute_name, 1);
2493: END IF;
2494:

Line 2495: l_attribute_value := WF_EVENT.getValueForParameter('ATTRIBUTE_VALUE',l_cln_ch_parameters);

2491: IF (l_Debug_Level <= 1) THEN
2492: ecx_cln_debug_pub.Add('ATTRIBUTE_NAME ----'||l_attribute_name, 1);
2493: END IF;
2494:
2495: l_attribute_value := WF_EVENT.getValueForParameter('ATTRIBUTE_VALUE',l_cln_ch_parameters);
2496: IF (l_Debug_Level <= 1) THEN
2497: ecx_cln_debug_pub.Add('ATTRIBUTE_VALUE ----'||l_attribute_value, 1);
2498: END IF;
2499:

Line 2500: l_batch_mode := WF_EVENT.getValueForParameter('BATCH_MODE_REQD',l_cln_ch_parameters);

2496: IF (l_Debug_Level <= 1) THEN
2497: ecx_cln_debug_pub.Add('ATTRIBUTE_VALUE ----'||l_attribute_value, 1);
2498: END IF;
2499:
2500: l_batch_mode := WF_EVENT.getValueForParameter('BATCH_MODE_REQD',l_cln_ch_parameters);
2501: IF (l_Debug_Level <= 1) THEN
2502: ecx_cln_debug_pub.Add('BATCH_MODE_REQD ----'||l_batch_mode, 1);
2503: END IF;
2504:

Line 2505: l_notif_receiver_role := WF_EVENT.getValueForParameter('NOTIFICATION_RECEIVER_ROLE',l_cln_ch_parameters);

2501: IF (l_Debug_Level <= 1) THEN
2502: ecx_cln_debug_pub.Add('BATCH_MODE_REQD ----'||l_batch_mode, 1);
2503: END IF;
2504:
2505: l_notif_receiver_role := WF_EVENT.getValueForParameter('NOTIFICATION_RECEIVER_ROLE',l_cln_ch_parameters);
2506: IF (l_Debug_Level <= 1) THEN
2507: ecx_cln_debug_pub.Add('NOTIFICATION_RECEIVER_ROLE ----'||l_notif_receiver_role, 1);
2508: END IF;
2509:

Line 2510: l_collaboration_std := WF_EVENT.getValueForParameter('COLLABORATION_STANDARD',l_cln_ch_parameters);

2506: IF (l_Debug_Level <= 1) THEN
2507: ecx_cln_debug_pub.Add('NOTIFICATION_RECEIVER_ROLE ----'||l_notif_receiver_role, 1);
2508: END IF;
2509:
2510: l_collaboration_std := WF_EVENT.getValueForParameter('COLLABORATION_STANDARD',l_cln_ch_parameters);
2511: IF (l_Debug_Level <= 1) THEN
2512: ecx_cln_debug_pub.Add('COLLABORATION_STANDARD ----'||l_collaboration_std, 1);
2513: END IF;
2514:

Line 2515: l_collaboration_type := WF_EVENT.getValueForParameter('COLLABORATION_TYPE',l_cln_ch_parameters);

2511: IF (l_Debug_Level <= 1) THEN
2512: ecx_cln_debug_pub.Add('COLLABORATION_STANDARD ----'||l_collaboration_std, 1);
2513: END IF;
2514:
2515: l_collaboration_type := WF_EVENT.getValueForParameter('COLLABORATION_TYPE',l_cln_ch_parameters);
2516: IF (l_Debug_Level <= 1) THEN
2517: ecx_cln_debug_pub.Add('COLLABORATION_TYPE ----'||l_collaboration_type, 1);
2518: END IF;
2519: