391: -- Generic attribute list for generic outbound workflow
392: l_genwf_cln_parameter_list := wf_parameter_list_t();
393:
394:
395: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
396: p_value => l_tr_partner_id,
397: p_parameterlist => l_genwf_cln_parameter_list);
398:
399: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
395: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
396: p_value => l_tr_partner_id,
397: p_parameterlist => l_genwf_cln_parameter_list);
398:
399: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
400: p_value => l_tr_partner_site,
401: p_parameterlist => l_genwf_cln_parameter_list);
402:
403: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
399: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
400: p_value => l_tr_partner_site,
401: p_parameterlist => l_genwf_cln_parameter_list);
402:
403: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
404: p_value => l_tr_partner_type,
405: p_parameterlist => l_genwf_cln_parameter_list);
406:
407: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
403: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
404: p_value => l_tr_partner_type,
405: p_parameterlist => l_genwf_cln_parameter_list);
406:
407: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
408: p_value => 'CLN',
409: p_parameterlist => l_genwf_cln_parameter_list);
410:
411: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
407: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
408: p_value => 'CLN',
409: p_parameterlist => l_genwf_cln_parameter_list);
410:
411: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
412: p_value => 'SYNCITEMO',
413: p_parameterlist => l_genwf_cln_parameter_list);
414:
415: wf_event.AddParameterToList(p_name => 'ECX_DELIVERY_CHECK_REQUIRED',
411: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
412: p_value => 'SYNCITEMO',
413: p_parameterlist => l_genwf_cln_parameter_list);
414:
415: wf_event.AddParameterToList(p_name => 'ECX_DELIVERY_CHECK_REQUIRED',
416: p_value => 'YES',
417: p_parameterlist => l_genwf_cln_parameter_list);
418:
419: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER1',
415: wf_event.AddParameterToList(p_name => 'ECX_DELIVERY_CHECK_REQUIRED',
416: p_value => 'YES',
417: p_parameterlist => l_genwf_cln_parameter_list);
418:
419: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER1',
420: p_value => p_inventory_org_id,
421: p_parameterlist => l_genwf_cln_parameter_list);
422:
423: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER2',
419: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER1',
420: p_value => p_inventory_org_id,
421: p_parameterlist => l_genwf_cln_parameter_list);
422:
423: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER2',
424: p_value => p_category_set_id,
425: p_parameterlist => l_genwf_cln_parameter_list);
426:
427: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER3',
423: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER2',
424: p_value => p_category_set_id,
425: p_parameterlist => l_genwf_cln_parameter_list);
426:
427: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER3',
428: p_value => p_category_id,
429: p_parameterlist => l_genwf_cln_parameter_list);
430:
431: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER4',
427: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER3',
428: p_value => p_category_id,
429: p_parameterlist => l_genwf_cln_parameter_list);
430:
431: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER4',
432: p_value => p_catalog_category_id,
433: p_parameterlist => l_genwf_cln_parameter_list);
434:
435: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER5',
431: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER4',
432: p_value => p_catalog_category_id,
433: p_parameterlist => l_genwf_cln_parameter_list);
434:
435: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER5',
436: p_value => p_item_status,
437: p_parameterlist => l_genwf_cln_parameter_list);
438:
439: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER6',
435: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER5',
436: p_value => p_item_status,
437: p_parameterlist => l_genwf_cln_parameter_list);
438:
439: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER6',
440: p_value => l_from_items,
441: p_parameterlist => l_genwf_cln_parameter_list);
442:
443: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER7',
439: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER6',
440: p_value => l_from_items,
441: p_parameterlist => l_genwf_cln_parameter_list);
442:
443: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER7',
444: p_value => l_to_items,
445: p_parameterlist => l_genwf_cln_parameter_list);
446:
447: wf_event.AddParameterToList(p_name => 'ORG_ID',
443: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER7',
444: p_value => l_to_items,
445: p_parameterlist => l_genwf_cln_parameter_list);
446:
447: wf_event.AddParameterToList(p_name => 'ORG_ID',
448: p_value => p_inventory_org_id,
449: p_parameterlist => l_genwf_cln_parameter_list);
450:
451: wf_event.AddParameterToList(p_name => 'DOCUMENT_CAREATION_DATE',
447: wf_event.AddParameterToList(p_name => 'ORG_ID',
448: p_value => p_inventory_org_id,
449: p_parameterlist => l_genwf_cln_parameter_list);
450:
451: wf_event.AddParameterToList(p_name => 'DOCUMENT_CAREATION_DATE',
452: p_value => l_canonical_date,
453: p_parameterlist => l_genwf_cln_parameter_list);
454:
455: wf_event.AddParameterToList(p_name => 'VALIDATION_REQUIRED_YN',
451: wf_event.AddParameterToList(p_name => 'DOCUMENT_CAREATION_DATE',
452: p_value => l_canonical_date,
453: p_parameterlist => l_genwf_cln_parameter_list);
454:
455: wf_event.AddParameterToList(p_name => 'VALIDATION_REQUIRED_YN',
456: p_value => 'N',
457: p_parameterlist => l_genwf_cln_parameter_list);
458:
459: wf_event.AddParameterToList(p_name => 'CH_MESSAGE_BEFORE_GENERATE_XML',
455: wf_event.AddParameterToList(p_name => 'VALIDATION_REQUIRED_YN',
456: p_value => 'N',
457: p_parameterlist => l_genwf_cln_parameter_list);
458:
459: wf_event.AddParameterToList(p_name => 'CH_MESSAGE_BEFORE_GENERATE_XML',
460: p_value => 'CLN_CH_COLLABORATION_CREATED',
461: p_parameterlist => l_genwf_cln_parameter_list);
462:
463: wf_event.AddParameterToList(p_name => 'CH_MESSAGE_AFTER_XML_SENT',
459: wf_event.AddParameterToList(p_name => 'CH_MESSAGE_BEFORE_GENERATE_XML',
460: p_value => 'CLN_CH_COLLABORATION_CREATED',
461: p_parameterlist => l_genwf_cln_parameter_list);
462:
463: wf_event.AddParameterToList(p_name => 'CH_MESSAGE_AFTER_XML_SENT',
464: p_value => 'CLN_SYNC_ITEM_XML_SENT',
465: p_parameterlist => l_genwf_cln_parameter_list);
466:
467: wf_event.AddParameterToList(p_name => 'COLLABORATION_STATUS_SET',
463: wf_event.AddParameterToList(p_name => 'CH_MESSAGE_AFTER_XML_SENT',
464: p_value => 'CLN_SYNC_ITEM_XML_SENT',
465: p_parameterlist => l_genwf_cln_parameter_list);
466:
467: wf_event.AddParameterToList(p_name => 'COLLABORATION_STATUS_SET',
468: p_value => 'Y',
469: p_parameterlist => l_genwf_cln_parameter_list);
470:
471: wf_event.AddParameterToList(p_name => 'CH_MESSAGE_NO_TP_SETUP',
467: wf_event.AddParameterToList(p_name => 'COLLABORATION_STATUS_SET',
468: p_value => 'Y',
469: p_parameterlist => l_genwf_cln_parameter_list);
470:
471: wf_event.AddParameterToList(p_name => 'CH_MESSAGE_NO_TP_SETUP',
472: p_value => 'CLN_CH_TP_SETUP_NOTFOUND',
473: p_parameterlist => l_genwf_cln_parameter_list);
474:
475:
487: IF (l_Debug_Level <= 1) THEN
488: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);
489: END IF;
490:
491: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
492: p_value => l_event_key,
493: p_parameterlist => l_genwf_cln_parameter_list);
494:
495: wf_event.AddParameterToList(p_name => 'XML_EVENT_KEY',
491: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
492: p_value => l_event_key,
493: p_parameterlist => l_genwf_cln_parameter_list);
494:
495: wf_event.AddParameterToList(p_name => 'XML_EVENT_KEY',
496: p_value => l_event_key,
497: p_parameterlist => l_genwf_cln_parameter_list);
498:
499: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
495: wf_event.AddParameterToList(p_name => 'XML_EVENT_KEY',
496: p_value => l_event_key,
497: p_parameterlist => l_genwf_cln_parameter_list);
498:
499: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
500: p_value => l_event_key,
501: p_parameterlist => l_genwf_cln_parameter_list);
502:
503: IF (l_Debug_Level <= 1) THEN
504: cln_debug_pub.Add('raising event as - oracle.apps.cln.common.xml.out',1);
505: END IF;
506:
507: -- raise event for send show shipment document
508: wf_event.raise(p_event_name => 'oracle.apps.cln.common.xml.out',
509: p_event_key => l_event_key,
510: p_parameters => l_genwf_cln_parameter_list);
511:
512:
567: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);
568: END IF;
569:
570: -- setting the generic workflow parameters
571: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER6',
572: p_value => l_from_items,
573: p_parameterlist => l_genwf_cln_parameter_list);
574:
575: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER7',
571: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER6',
572: p_value => l_from_items,
573: p_parameterlist => l_genwf_cln_parameter_list);
574:
575: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER7',
576: p_value => l_to_items,
577: p_parameterlist => l_genwf_cln_parameter_list);
578:
579: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
575: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER7',
576: p_value => l_to_items,
577: p_parameterlist => l_genwf_cln_parameter_list);
578:
579: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
580: p_value => l_event_key,
581: p_parameterlist => l_genwf_cln_parameter_list);
582:
583: wf_event.AddParameterToList(p_name => 'XML_EVENT_KEY',
579: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
580: p_value => l_event_key,
581: p_parameterlist => l_genwf_cln_parameter_list);
582:
583: wf_event.AddParameterToList(p_name => 'XML_EVENT_KEY',
584: p_value => l_event_key,
585: p_parameterlist => l_genwf_cln_parameter_list);
586:
587: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
583: wf_event.AddParameterToList(p_name => 'XML_EVENT_KEY',
584: p_value => l_event_key,
585: p_parameterlist => l_genwf_cln_parameter_list);
586:
587: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
588: p_value => l_event_key,
589: p_parameterlist => l_genwf_cln_parameter_list);
590:
591: IF (l_Debug_Level <= 1) THEN
592: cln_debug_pub.Add('raising event as - oracle.apps.cln.common.xml.out',1);
593: END IF;
594:
595: -- raise event for send show shipment document
596: wf_event.raise(p_event_name => 'oracle.apps.cln.common.xml.out',
597: p_event_key => l_event_key,
598: p_parameters => l_genwf_cln_parameter_list);
599:
600: IF (l_Debug_Level <= 1) THEN
798: cln_debug_pub.Add('Failure point ' || x_progress, 1);
799: end if;
800:
801: -- add parameters to list for create collaboration event
802: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
803: p_value => transaction_type,
804: p_parameterlist => l_create_cln_parameter_list);
805: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
806: p_value => transaction_subtype,
801: -- add parameters to list for create collaboration event
802: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
803: p_value => transaction_type,
804: p_parameterlist => l_create_cln_parameter_list);
805: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
806: p_value => transaction_subtype,
807: p_parameterlist => l_create_cln_parameter_list);
808: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
809: p_value => document_direction,
804: p_parameterlist => l_create_cln_parameter_list);
805: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
806: p_value => transaction_subtype,
807: p_parameterlist => l_create_cln_parameter_list);
808: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
809: p_value => document_direction,
810: p_parameterlist => l_create_cln_parameter_list);
811: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
812: p_value => l_event_key,
807: p_parameterlist => l_create_cln_parameter_list);
808: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
809: p_value => document_direction,
810: p_parameterlist => l_create_cln_parameter_list);
811: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
812: p_value => l_event_key,
813: p_parameterlist => l_create_cln_parameter_list);
814: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
815: p_value => party_id,
810: p_parameterlist => l_create_cln_parameter_list);
811: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
812: p_value => l_event_key,
813: p_parameterlist => l_create_cln_parameter_list);
814: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
815: p_value => party_id,
816: p_parameterlist => l_create_cln_parameter_list);
817: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
818: p_value => party_site_id,
813: p_parameterlist => l_create_cln_parameter_list);
814: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
815: p_value => party_id,
816: p_parameterlist => l_create_cln_parameter_list);
817: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
818: p_value => party_site_id,
819: p_parameterlist => l_create_cln_parameter_list);
820: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
821: p_value => party_type,
816: p_parameterlist => l_create_cln_parameter_list);
817: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
818: p_value => party_site_id,
819: p_parameterlist => l_create_cln_parameter_list);
820: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
821: p_value => party_type,
822: p_parameterlist => l_create_cln_parameter_list);
823: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
824: p_value => l_event_key,
819: p_parameterlist => l_create_cln_parameter_list);
820: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
821: p_value => party_type,
822: p_parameterlist => l_create_cln_parameter_list);
823: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
824: p_value => l_event_key,
825: p_parameterlist => l_create_cln_parameter_list);
826: wf_event.AddParameterToList(p_name => 'ORG_ID',
827: p_value => l_organization_id,
822: p_parameterlist => l_create_cln_parameter_list);
823: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
824: p_value => l_event_key,
825: p_parameterlist => l_create_cln_parameter_list);
826: wf_event.AddParameterToList(p_name => 'ORG_ID',
827: p_value => l_organization_id,
828: p_parameterlist => l_create_cln_parameter_list);
829: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
830: p_value => l_canonical_date,
825: p_parameterlist => l_create_cln_parameter_list);
826: wf_event.AddParameterToList(p_name => 'ORG_ID',
827: p_value => l_organization_id,
828: p_parameterlist => l_create_cln_parameter_list);
829: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
830: p_value => l_canonical_date,
831: p_parameterlist => l_create_cln_parameter_list);
832:
833: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Create Event Parameters Setup';
835: cln_debug_pub.Add('Failure point ' || x_progress, 1);
836: end if;
837:
838: -- raise create collaboration event
839: wf_event.raise(p_event_name => l_create_cln_event,
840: p_event_key => l_event_key,
841: p_parameters => l_create_cln_parameter_list);
842:
843: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Create Event Raised';
845: cln_debug_pub.Add('Failure point ' || x_progress, 1);
846: end if;
847:
848: -- add parameters to list for send sync item document
849: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
850: p_value => transaction_type,
851: p_parameterlist => l_send_syit_parameter_list);
852: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
853: p_value => transaction_subtype,
848: -- add parameters to list for send sync item document
849: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
850: p_value => transaction_type,
851: p_parameterlist => l_send_syit_parameter_list);
852: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
853: p_value => transaction_subtype,
854: p_parameterlist => l_send_syit_parameter_list);
855: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
856: p_value => transaction_type,
851: p_parameterlist => l_send_syit_parameter_list);
852: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
853: p_value => transaction_subtype,
854: p_parameterlist => l_send_syit_parameter_list);
855: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
856: p_value => transaction_type,
857: p_parameterlist => l_send_syit_parameter_list);
858: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
859: p_value => transaction_subtype,
854: p_parameterlist => l_send_syit_parameter_list);
855: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
856: p_value => transaction_type,
857: p_parameterlist => l_send_syit_parameter_list);
858: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
859: p_value => transaction_subtype,
860: p_parameterlist => l_send_syit_parameter_list);
861: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
862: p_value => document_direction,
857: p_parameterlist => l_send_syit_parameter_list);
858: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
859: p_value => transaction_subtype,
860: p_parameterlist => l_send_syit_parameter_list);
861: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
862: p_value => document_direction,
863: p_parameterlist => l_send_syit_parameter_list);
864: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
865: p_value => party_id,
860: p_parameterlist => l_send_syit_parameter_list);
861: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
862: p_value => document_direction,
863: p_parameterlist => l_send_syit_parameter_list);
864: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
865: p_value => party_id,
866: p_parameterlist => l_send_syit_parameter_list);
867: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
868: p_value => party_site_id,
863: p_parameterlist => l_send_syit_parameter_list);
864: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
865: p_value => party_id,
866: p_parameterlist => l_send_syit_parameter_list);
867: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
868: p_value => party_site_id,
869: p_parameterlist => l_send_syit_parameter_list);
870: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
871: p_value => party_type,
866: p_parameterlist => l_send_syit_parameter_list);
867: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
868: p_value => party_site_id,
869: p_parameterlist => l_send_syit_parameter_list);
870: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
871: p_value => party_type,
872: p_parameterlist => l_send_syit_parameter_list);
873: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
874: p_value => party_id,
869: p_parameterlist => l_send_syit_parameter_list);
870: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
871: p_value => party_type,
872: p_parameterlist => l_send_syit_parameter_list);
873: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
874: p_value => party_id,
875: p_parameterlist => l_send_syit_parameter_list);
876: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
877: p_value => party_site_id,
872: p_parameterlist => l_send_syit_parameter_list);
873: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
874: p_value => party_id,
875: p_parameterlist => l_send_syit_parameter_list);
876: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
877: p_value => party_site_id,
878: p_parameterlist => l_send_syit_parameter_list);
879: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
880: p_value => party_type,
875: p_parameterlist => l_send_syit_parameter_list);
876: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
877: p_value => party_site_id,
878: p_parameterlist => l_send_syit_parameter_list);
879: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
880: p_value => party_type,
881: p_parameterlist => l_send_syit_parameter_list);
882: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
883: p_value => l_event_key,
878: p_parameterlist => l_send_syit_parameter_list);
879: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
880: p_value => party_type,
881: p_parameterlist => l_send_syit_parameter_list);
882: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
883: p_value => l_event_key,
884: p_parameterlist => l_send_syit_parameter_list);
885: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
886: p_value => l_event_key,
881: p_parameterlist => l_send_syit_parameter_list);
882: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
883: p_value => l_event_key,
884: p_parameterlist => l_send_syit_parameter_list);
885: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
886: p_value => l_event_key,
887: p_parameterlist => l_send_syit_parameter_list);
888: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
889: p_value => l_event_key,
884: p_parameterlist => l_send_syit_parameter_list);
885: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
886: p_value => l_event_key,
887: p_parameterlist => l_send_syit_parameter_list);
888: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
889: p_value => l_event_key,
890: p_parameterlist => l_send_syit_parameter_list);
891: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
892: p_value => message_text,
887: p_parameterlist => l_send_syit_parameter_list);
888: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
889: p_value => l_event_key,
890: p_parameterlist => l_send_syit_parameter_list);
891: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
892: p_value => message_text,
893: p_parameterlist => l_send_syit_parameter_list);
894: wf_event.AddParameterToList(p_name => 'ORG_ID',
895: p_value => l_organization_id,
890: p_parameterlist => l_send_syit_parameter_list);
891: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
892: p_value => message_text,
893: p_parameterlist => l_send_syit_parameter_list);
894: wf_event.AddParameterToList(p_name => 'ORG_ID',
895: p_value => l_organization_id,
896: p_parameterlist => l_send_syit_parameter_list);
897: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
898: p_value => NULL,
893: p_parameterlist => l_send_syit_parameter_list);
894: wf_event.AddParameterToList(p_name => 'ORG_ID',
895: p_value => l_organization_id,
896: p_parameterlist => l_send_syit_parameter_list);
897: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
898: p_value => NULL,
899: p_parameterlist => l_send_syit_parameter_list);
900: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
901: p_value => NULL,
896: p_parameterlist => l_send_syit_parameter_list);
897: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
898: p_value => NULL,
899: p_parameterlist => l_send_syit_parameter_list);
900: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
901: p_value => NULL,
902: p_parameterlist => l_send_syit_parameter_list);
903: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
904: p_value => NULL,
899: p_parameterlist => l_send_syit_parameter_list);
900: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
901: p_value => NULL,
902: p_parameterlist => l_send_syit_parameter_list);
903: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
904: p_value => NULL,
905: p_parameterlist => l_send_syit_parameter_list);
906: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
907: p_value => NULL,
902: p_parameterlist => l_send_syit_parameter_list);
903: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
904: p_value => NULL,
905: p_parameterlist => l_send_syit_parameter_list);
906: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
907: p_value => NULL,
908: p_parameterlist => l_send_syit_parameter_list);
909: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
910: p_value => NULL,
905: p_parameterlist => l_send_syit_parameter_list);
906: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
907: p_value => NULL,
908: p_parameterlist => l_send_syit_parameter_list);
909: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
910: p_value => NULL,
911: p_parameterlist => l_send_syit_parameter_list);
912: wf_event.AddParameterToList(p_name => 'INVENTORY_ITEM_ID', -- may possibly need this
913: p_value => p_inventory_item_id,
908: p_parameterlist => l_send_syit_parameter_list);
909: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
910: p_value => NULL,
911: p_parameterlist => l_send_syit_parameter_list);
912: wf_event.AddParameterToList(p_name => 'INVENTORY_ITEM_ID', -- may possibly need this
913: p_value => p_inventory_item_id,
914: p_parameterlist => l_send_syit_parameter_list);
915: wf_event.AddParameterToList(p_name => 'ORGANIZATION_ID',
916: p_value => p_org_id,
911: p_parameterlist => l_send_syit_parameter_list);
912: wf_event.AddParameterToList(p_name => 'INVENTORY_ITEM_ID', -- may possibly need this
913: p_value => p_inventory_item_id,
914: p_parameterlist => l_send_syit_parameter_list);
915: wf_event.AddParameterToList(p_name => 'ORGANIZATION_ID',
916: p_value => p_org_id,
917: p_parameterlist => l_send_syit_parameter_list);
918: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
919: p_value => l_canonical_date,
914: p_parameterlist => l_send_syit_parameter_list);
915: wf_event.AddParameterToList(p_name => 'ORGANIZATION_ID',
916: p_value => p_org_id,
917: p_parameterlist => l_send_syit_parameter_list);
918: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
919: p_value => l_canonical_date,
920: p_parameterlist => l_send_syit_parameter_list);
921:
922: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Initialize Send Document Parameters';
924: cln_debug_pub.Add('Failure point ' || x_progress, 1);
925: end if;
926:
927: -- raise event for send show shipment document
928: wf_event.raise(p_event_name => l_send_shsp_event,
929: p_event_key => l_event_key,
930: p_parameters => l_send_syit_parameter_list);
931:
932: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Send Document Event Raised';