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

APPS.CLN_SYNC_ITEM_PKG dependencies on WF_EVENT

Line 318: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_cln_ch_parameters);

314: IF (l_Debug_Level <= 1) THEN
315: cln_debug_pub.Add('-------- SETTING EVENT PARAMETERS -----------', 1);
316: END IF;
317:
318: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_cln_ch_parameters);
319: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
320: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_CH_SYNC_ITEMS_CONSUMED', l_cln_ch_parameters);
321: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
322: WF_EVENT.AddParameterToList('DOCUMENT_NO',l_document_number,l_cln_ch_parameters);

Line 319: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);

315: cln_debug_pub.Add('-------- SETTING EVENT PARAMETERS -----------', 1);
316: END IF;
317:
318: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_cln_ch_parameters);
319: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
320: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_CH_SYNC_ITEMS_CONSUMED', l_cln_ch_parameters);
321: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
322: WF_EVENT.AddParameterToList('DOCUMENT_NO',l_document_number,l_cln_ch_parameters);
323: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),l_cln_ch_parameters);

Line 320: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_CH_SYNC_ITEMS_CONSUMED', l_cln_ch_parameters);

316: END IF;
317:
318: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_cln_ch_parameters);
319: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
320: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_CH_SYNC_ITEMS_CONSUMED', l_cln_ch_parameters);
321: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
322: WF_EVENT.AddParameterToList('DOCUMENT_NO',l_document_number,l_cln_ch_parameters);
323: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),l_cln_ch_parameters);
324: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

Line 321: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

317:
318: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_cln_ch_parameters);
319: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
320: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_CH_SYNC_ITEMS_CONSUMED', l_cln_ch_parameters);
321: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
322: WF_EVENT.AddParameterToList('DOCUMENT_NO',l_document_number,l_cln_ch_parameters);
323: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),l_cln_ch_parameters);
324: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
325:

Line 322: WF_EVENT.AddParameterToList('DOCUMENT_NO',l_document_number,l_cln_ch_parameters);

318: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'SUCCESS', l_cln_ch_parameters);
319: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
320: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_CH_SYNC_ITEMS_CONSUMED', l_cln_ch_parameters);
321: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
322: WF_EVENT.AddParameterToList('DOCUMENT_NO',l_document_number,l_cln_ch_parameters);
323: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),l_cln_ch_parameters);
324: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
325:
326: IF (l_Debug_Level <= 1) THEN

Line 323: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),l_cln_ch_parameters);

319: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
320: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_CH_SYNC_ITEMS_CONSUMED', l_cln_ch_parameters);
321: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
322: WF_EVENT.AddParameterToList('DOCUMENT_NO',l_document_number,l_cln_ch_parameters);
323: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),l_cln_ch_parameters);
324: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
325:
326: IF (l_Debug_Level <= 1) THEN
327: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);

Line 324: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

320: WF_EVENT.AddParameterToList('MESSAGE_TEXT', 'CLN_CH_SYNC_ITEMS_CONSUMED', l_cln_ch_parameters);
321: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
322: WF_EVENT.AddParameterToList('DOCUMENT_NO',l_document_number,l_cln_ch_parameters);
323: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE',to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),l_cln_ch_parameters);
324: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
325:
326: IF (l_Debug_Level <= 1) THEN
327: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
328: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);

Line 331: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);

327: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
328: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
329: END IF;
330:
331: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
332:
333:
334: IF (l_Debug_Level <= 1) THEN
335: cln_debug_pub.Add(l_msg_data,1);

Line 488: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);

484: IF (l_Debug_Level <= 1) THEN
485: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS FOR INCORRECT SYNC IND---------', 1);
486: END IF;
487:
488: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
489: WF_EVENT.AddParameterToList('REFERENCE_ID2','-',l_cln_ch_parameters);
490: WF_EVENT.AddParameterToList('REFERENCE_ID3','-',l_cln_ch_parameters);
491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);
492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

Line 489: WF_EVENT.AddParameterToList('REFERENCE_ID2','-',l_cln_ch_parameters);

485: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS FOR INCORRECT SYNC IND---------', 1);
486: END IF;
487:
488: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
489: WF_EVENT.AddParameterToList('REFERENCE_ID2','-',l_cln_ch_parameters);
490: WF_EVENT.AddParameterToList('REFERENCE_ID3','-',l_cln_ch_parameters);
491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);
492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
493: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

Line 490: WF_EVENT.AddParameterToList('REFERENCE_ID3','-',l_cln_ch_parameters);

486: END IF;
487:
488: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
489: WF_EVENT.AddParameterToList('REFERENCE_ID2','-',l_cln_ch_parameters);
490: WF_EVENT.AddParameterToList('REFERENCE_ID3','-',l_cln_ch_parameters);
491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);
492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
493: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
494: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

Line 491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);

487:
488: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
489: WF_EVENT.AddParameterToList('REFERENCE_ID2','-',l_cln_ch_parameters);
490: WF_EVENT.AddParameterToList('REFERENCE_ID3','-',l_cln_ch_parameters);
491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);
492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
493: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
494: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
495: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

Line 492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

488: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
489: WF_EVENT.AddParameterToList('REFERENCE_ID2','-',l_cln_ch_parameters);
490: WF_EVENT.AddParameterToList('REFERENCE_ID3','-',l_cln_ch_parameters);
491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);
492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
493: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
494: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
495: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
496:

Line 493: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

489: WF_EVENT.AddParameterToList('REFERENCE_ID2','-',l_cln_ch_parameters);
490: WF_EVENT.AddParameterToList('REFERENCE_ID3','-',l_cln_ch_parameters);
491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);
492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
493: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
494: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
495: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
496:
497: IF (l_Debug_Level <= 1) THEN

Line 494: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

490: WF_EVENT.AddParameterToList('REFERENCE_ID3','-',l_cln_ch_parameters);
491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);
492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
493: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
494: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
495: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
496:
497: IF (l_Debug_Level <= 1) THEN
498: cln_debug_pub.Add('----------------------------------------------', 1);

Line 495: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

491: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',x_msg_data,l_cln_ch_parameters);
492: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
493: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
494: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
495: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
496:
497: IF (l_Debug_Level <= 1) THEN
498: cln_debug_pub.Add('----------------------------------------------', 1);
499: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);

Line 502: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);

498: cln_debug_pub.Add('----------------------------------------------', 1);
499: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);
500: END IF;
501:
502: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);
503:
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:

Line 611: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);

607: IF (l_Debug_Level <= 1) THEN
608: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
609: END IF;
610:
611: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
612: --WF_EVENT.AddParameterToList('REFERENCE_ID2','Suplier:'||p_supplier_name,l_cln_ch_parameters);
613: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Buyer:'||p_buyer_part_number,l_cln_ch_parameters);
614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);

Line 612: --WF_EVENT.AddParameterToList('REFERENCE_ID2','Suplier:'||p_supplier_name,l_cln_ch_parameters);

608: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
609: END IF;
610:
611: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
612: --WF_EVENT.AddParameterToList('REFERENCE_ID2','Suplier:'||p_supplier_name,l_cln_ch_parameters);
613: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Buyer:'||p_buyer_part_number,l_cln_ch_parameters);
614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);

Line 613: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Buyer:'||p_buyer_part_number,l_cln_ch_parameters);

609: END IF;
610:
611: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
612: --WF_EVENT.AddParameterToList('REFERENCE_ID2','Suplier:'||p_supplier_name,l_cln_ch_parameters);
613: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Buyer:'||p_buyer_part_number,l_cln_ch_parameters);
614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

Line 614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);

610:
611: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
612: --WF_EVENT.AddParameterToList('REFERENCE_ID2','Suplier:'||p_supplier_name,l_cln_ch_parameters);
613: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Buyer:'||p_buyer_part_number,l_cln_ch_parameters);
614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
618: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

Line 615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);

611: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
612: --WF_EVENT.AddParameterToList('REFERENCE_ID2','Suplier:'||p_supplier_name,l_cln_ch_parameters);
613: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Buyer:'||p_buyer_part_number,l_cln_ch_parameters);
614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
618: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
619: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

Line 616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);

612: --WF_EVENT.AddParameterToList('REFERENCE_ID2','Suplier:'||p_supplier_name,l_cln_ch_parameters);
613: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Buyer:'||p_buyer_part_number,l_cln_ch_parameters);
614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
618: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
619: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
620: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

Line 617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

613: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Buyer:'||p_buyer_part_number,l_cln_ch_parameters);
614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
618: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
619: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
620: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
621:

Line 618: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

614: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
618: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
619: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
620: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
621:
622: IF (l_Debug_Level <= 1) THEN

Line 619: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

615: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
618: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
619: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
620: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
621:
622: IF (l_Debug_Level <= 1) THEN
623: cln_debug_pub.Add('----------------------------------------------', 1);

Line 620: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

616: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
617: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
618: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
619: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
620: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
621:
622: IF (l_Debug_Level <= 1) THEN
623: cln_debug_pub.Add('----------------------------------------------', 1);
624: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);

Line 627: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);

623: cln_debug_pub.Add('----------------------------------------------', 1);
624: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);
625: END IF;
626:
627: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);
628:
629: IF (l_Debug_Level <= 1) THEN
630: cln_debug_pub.Add(l_msg_data,1);
631: END IF;

Line 798: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);

794: IF (l_Debug_Level <= 1) THEN
795: cln_debug_pub.Add('---- SETTING EVENT PARAMETERS FOR UPDATE COLLABORATION ----', 1);
796: END IF;
797:
798: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
799: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_org_ref, l_cln_ch_parameters);
800: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
801: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
802: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

Line 799: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_org_ref, l_cln_ch_parameters);

795: cln_debug_pub.Add('---- SETTING EVENT PARAMETERS FOR UPDATE COLLABORATION ----', 1);
796: END IF;
797:
798: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
799: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_org_ref, l_cln_ch_parameters);
800: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
801: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
802: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
803:

Line 800: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);

796: END IF;
797:
798: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
799: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_org_ref, l_cln_ch_parameters);
800: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
801: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
802: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
803:
804: IF (l_Debug_Level <= 1) THEN

Line 801: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

797:
798: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
799: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_org_ref, l_cln_ch_parameters);
800: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
801: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
802: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
803:
804: IF (l_Debug_Level <= 1) THEN
805: cln_debug_pub.Add('------------------- EVENT PARAMETERS SET -------------------', 1);

Line 802: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

798: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
799: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_org_ref, l_cln_ch_parameters);
800: WF_EVENT.AddParameterToList('MESSAGE_TEXT', x_msg_data, l_cln_ch_parameters);
801: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
802: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
803:
804: IF (l_Debug_Level <= 1) THEN
805: cln_debug_pub.Add('------------------- EVENT PARAMETERS SET -------------------', 1);
806: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);

Line 809: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);

805: cln_debug_pub.Add('------------------- EVENT PARAMETERS SET -------------------', 1);
806: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
807: END IF;
808:
809: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
810:
811: IF (l_Debug_Level <= 1) THEN
812: cln_debug_pub.Add(l_msg_data,1);
813: END IF;

Line 1304: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);

1300: END IF;
1301:
1302:
1303: l_cln_ch_parameters := wf_parameter_list_t();
1304: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
1305: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1306: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
1307: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1308: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

Line 1305: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);

1301:
1302:
1303: l_cln_ch_parameters := wf_parameter_list_t();
1304: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
1305: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1306: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
1307: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1308: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1309:

Line 1306: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);

1302:
1303: l_cln_ch_parameters := wf_parameter_list_t();
1304: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
1305: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1306: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
1307: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1308: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1309:
1310:

Line 1307: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

1303: l_cln_ch_parameters := wf_parameter_list_t();
1304: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
1305: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1306: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
1307: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1308: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1309:
1310:
1311: IF (l_Debug_Level <= 1) THEN

Line 1308: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

1304: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
1305: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1306: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
1307: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1308: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1309:
1310:
1311: IF (l_Debug_Level <= 1) THEN
1312: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);

Line 1316: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);

1312: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
1313: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
1314: END IF;
1315:
1316: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
1317:
1318: IF (l_process_each_row_for_errors = 'TRUE') THEN
1319:
1320: sql_statement_error_msg := ' SELECT ERROR_MESSAGE, TRANSACTION_ID, TABLE_NAME'

Line 1375: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);

1371: -- generate an event key which is also passed as event key for add collaboration event.
1372: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1373:
1374:
1375: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
1376: IF (l_Debug_Level <= 1) THEN
1377: cln_debug_pub.Add('---------- 1---------', 1);
1378: END IF;
1379: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID:'||l_master_organization_id,l_cln_ch_parameters);

Line 1379: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID:'||l_master_organization_id,l_cln_ch_parameters);

1375: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
1376: IF (l_Debug_Level <= 1) THEN
1377: cln_debug_pub.Add('---------- 1---------', 1);
1378: END IF;
1379: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID:'||l_master_organization_id,l_cln_ch_parameters);
1380: IF (l_Debug_Level <= 1) THEN
1381: cln_debug_pub.Add('---------- 2---------', 1);
1382: END IF;
1383: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Supplier:'||l_supplier_name,l_cln_ch_parameters);

Line 1383: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Supplier:'||l_supplier_name,l_cln_ch_parameters);

1379: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID:'||l_master_organization_id,l_cln_ch_parameters);
1380: IF (l_Debug_Level <= 1) THEN
1381: cln_debug_pub.Add('---------- 2---------', 1);
1382: END IF;
1383: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Supplier:'||l_supplier_name,l_cln_ch_parameters);
1384: --IF (l_Debug_Level <= 1) THEN
1385: -- cln_debug_pub.Add('---------- 3---------', 1);
1386: --END IF;
1387: WF_EVENT.AddParameterToList('REFERENCE_ID3',l_reference1,l_cln_ch_parameters);

Line 1387: WF_EVENT.AddParameterToList('REFERENCE_ID3',l_reference1,l_cln_ch_parameters);

1383: --WF_EVENT.AddParameterToList('REFERENCE_ID3','Supplier:'||l_supplier_name,l_cln_ch_parameters);
1384: --IF (l_Debug_Level <= 1) THEN
1385: -- cln_debug_pub.Add('---------- 3---------', 1);
1386: --END IF;
1387: WF_EVENT.AddParameterToList('REFERENCE_ID3',l_reference1,l_cln_ch_parameters);
1388: IF (l_Debug_Level <= 1) THEN
1389: cln_debug_pub.Add('---------- 3---------', 1);
1390: END IF;
1391: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);

Line 1391: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);

1387: WF_EVENT.AddParameterToList('REFERENCE_ID3',l_reference1,l_cln_ch_parameters);
1388: IF (l_Debug_Level <= 1) THEN
1389: cln_debug_pub.Add('---------- 3---------', 1);
1390: END IF;
1391: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
1392: IF (l_Debug_Level <= 1) THEN
1393: cln_debug_pub.Add('---------- 4---------', 1);
1394: END IF;
1395: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

Line 1395: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

1391: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
1392: IF (l_Debug_Level <= 1) THEN
1393: cln_debug_pub.Add('---------- 4---------', 1);
1394: END IF;
1395: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
1396: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
1397: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
1398: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1399:

Line 1396: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

1392: IF (l_Debug_Level <= 1) THEN
1393: cln_debug_pub.Add('---------- 4---------', 1);
1394: END IF;
1395: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
1396: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
1397: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
1398: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1399:
1400: IF (l_Debug_Level <= 1) THEN

Line 1397: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

1393: cln_debug_pub.Add('---------- 4---------', 1);
1394: END IF;
1395: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
1396: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
1397: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
1398: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1399:
1400: IF (l_Debug_Level <= 1) THEN
1401: cln_debug_pub.Add('----------------------------------------------', 1);

Line 1398: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

1394: END IF;
1395: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
1396: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
1397: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
1398: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1399:
1400: IF (l_Debug_Level <= 1) THEN
1401: cln_debug_pub.Add('----------------------------------------------', 1);
1402: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage : Key '||l_event_key, 1);

Line 1405: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);

1401: cln_debug_pub.Add('----------------------------------------------', 1);
1402: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage : Key '||l_event_key, 1);
1403: END IF;
1404:
1405: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);
1406:
1407: IF (l_Debug_Level <= 1) THEN
1408: cln_debug_pub.Add('Moving out of Cursor .....', 1);
1409: END IF;

Line 1635: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);

1631: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);
1632: END IF;
1633:
1634: l_cln_ch_parameters := wf_parameter_list_t();
1635: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1636: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1637: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
1638: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1639: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

Line 1636: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);

1632: END IF;
1633:
1634: l_cln_ch_parameters := wf_parameter_list_t();
1635: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1636: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1637: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
1638: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1639: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1640:

Line 1637: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);

1633:
1634: l_cln_ch_parameters := wf_parameter_list_t();
1635: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1636: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1637: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
1638: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1639: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1640:
1641:

Line 1638: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

1634: l_cln_ch_parameters := wf_parameter_list_t();
1635: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1636: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1637: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
1638: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1639: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1640:
1641:
1642: IF (l_Debug_Level <= 1) THEN

Line 1639: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

1635: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1636: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1637: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
1638: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
1639: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
1640:
1641:
1642: IF (l_Debug_Level <= 1) THEN
1643: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);

Line 1649: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);

1645: END IF;
1646:
1647: x_resultout := 'COMPLETE:'||'FALSE';
1648:
1649: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
1650:
1651: IF (l_Debug_Level <= 6) THEN
1652: cln_debug_pub.Add('------- ERROR:Exiting SETUP_CST_INTERFACE_TABLE API --------- ',6);
1653: END IF;

Line 2139: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);

2135: END IF;
2136:
2137: -- set the parameter list for the workflow
2138: l_cln_ch_parameters := wf_parameter_list_t();
2139: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2140: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2141: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2142: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2143: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

Line 2140: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);

2136:
2137: -- set the parameter list for the workflow
2138: l_cln_ch_parameters := wf_parameter_list_t();
2139: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2140: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2141: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2142: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2143: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2144:

Line 2141: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);

2137: -- set the parameter list for the workflow
2138: l_cln_ch_parameters := wf_parameter_list_t();
2139: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2140: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2141: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2142: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2143: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2144:
2145:

Line 2142: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

2138: l_cln_ch_parameters := wf_parameter_list_t();
2139: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2140: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2141: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2142: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2143: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2144:
2145:
2146: IF (l_Debug_Level <= 1) THEN

Line 2143: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

2139: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2140: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2141: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2142: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2143: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2144:
2145:
2146: IF (l_Debug_Level <= 1) THEN
2147: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);

Line 2151: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);

2147: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
2148: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
2149: END IF;
2150:
2151: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
2152:
2153: IF (l_return_status_tp = '99') THEN
2154: IF (l_Debug_Level <= 1) THEN
2155: cln_debug_pub.Add('Message for the trading partner : '||l_update_coll_msg, 1);

Line 2229: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);

2225: -- generate an event key which is also passed as event key for add collaboration event.
2226: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2227:
2228:
2229: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
2230: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID : '||l_master_organization_id,l_cln_ch_parameters);
2231: WF_EVENT.AddParameterToList('REFERENCE_ID3','Item No -'||l_item_number,l_cln_ch_parameters);
2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);
2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);

Line 2230: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID : '||l_master_organization_id,l_cln_ch_parameters);

2226: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2227:
2228:
2229: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
2230: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID : '||l_master_organization_id,l_cln_ch_parameters);
2231: WF_EVENT.AddParameterToList('REFERENCE_ID3','Item No -'||l_item_number,l_cln_ch_parameters);
2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);
2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

Line 2231: WF_EVENT.AddParameterToList('REFERENCE_ID3','Item No -'||l_item_number,l_cln_ch_parameters);

2227:
2228:
2229: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
2230: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID : '||l_master_organization_id,l_cln_ch_parameters);
2231: WF_EVENT.AddParameterToList('REFERENCE_ID3','Item No -'||l_item_number,l_cln_ch_parameters);
2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);
2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2235: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

Line 2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);

2228:
2229: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
2230: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID : '||l_master_organization_id,l_cln_ch_parameters);
2231: WF_EVENT.AddParameterToList('REFERENCE_ID3','Item No -'||l_item_number,l_cln_ch_parameters);
2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);
2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2235: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2236: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

Line 2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);

2229: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
2230: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID : '||l_master_organization_id,l_cln_ch_parameters);
2231: WF_EVENT.AddParameterToList('REFERENCE_ID3','Item No -'||l_item_number,l_cln_ch_parameters);
2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);
2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2235: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2236: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2237: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

Line 2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

2230: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID : '||l_master_organization_id,l_cln_ch_parameters);
2231: WF_EVENT.AddParameterToList('REFERENCE_ID3','Item No -'||l_item_number,l_cln_ch_parameters);
2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);
2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2235: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2236: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2237: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2238:

Line 2235: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

2231: WF_EVENT.AddParameterToList('REFERENCE_ID3','Item No -'||l_item_number,l_cln_ch_parameters);
2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);
2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2235: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2236: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2237: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2238:
2239: IF (l_Debug_Level <= 1) THEN

Line 2236: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

2232: --WF_EVENT.AddParameterToList('REFERENCE_ID4',,l_cln_ch_parameters);
2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2235: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2236: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2237: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2238:
2239: IF (l_Debug_Level <= 1) THEN
2240: cln_debug_pub.Add('----------------------------------------------', 1);

Line 2237: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

2233: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_error_msg,l_cln_ch_parameters);
2234: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2235: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2236: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2237: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2238:
2239: IF (l_Debug_Level <= 1) THEN
2240: cln_debug_pub.Add('----------------------------------------------', 1);
2241: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);

Line 2244: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);

2240: cln_debug_pub.Add('----------------------------------------------', 1);
2241: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);
2242: END IF;
2243:
2244: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);
2245:
2246: IF (l_Debug_Level <= 1) THEN
2247: cln_debug_pub.Add('Moving out of Cursor to find error message.....', 1);
2248: END IF;

Line 2292: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);

2288: cln_debug_pub.Add('Message for the trading partner = '||l_return_desc_tp, 1);
2289: END IF;
2290:
2291: l_cln_ch_parameters := wf_parameter_list_t();
2292: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
2293: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2294: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
2295: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2296: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

Line 2293: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);

2289: END IF;
2290:
2291: l_cln_ch_parameters := wf_parameter_list_t();
2292: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
2293: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2294: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
2295: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2296: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2297:

Line 2294: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);

2290:
2291: l_cln_ch_parameters := wf_parameter_list_t();
2292: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
2293: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2294: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
2295: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2296: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2297:
2298:

Line 2295: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

2291: l_cln_ch_parameters := wf_parameter_list_t();
2292: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
2293: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2294: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
2295: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2296: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2297:
2298:
2299: IF (l_Debug_Level <= 1) THEN

Line 2296: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

2292: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
2293: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2294: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
2295: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2296: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2297:
2298:
2299: IF (l_Debug_Level <= 1) THEN
2300: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);

Line 2304: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);

2300: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
2301: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
2302: END IF;
2303:
2304: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
2305:
2306: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2307: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2308: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );

Line 2563: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);

2559: END IF;
2560:
2561:
2562: l_cln_ch_parameters := wf_parameter_list_t();
2563: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2564: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2565: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2566: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2567: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

Line 2564: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);

2560:
2561:
2562: l_cln_ch_parameters := wf_parameter_list_t();
2563: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2564: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2565: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2566: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2567: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2568:

Line 2565: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);

2561:
2562: l_cln_ch_parameters := wf_parameter_list_t();
2563: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2564: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2565: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2566: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2567: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2568:
2569:

Line 2566: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

2562: l_cln_ch_parameters := wf_parameter_list_t();
2563: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2564: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2565: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2566: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2567: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2568:
2569:
2570: IF (l_Debug_Level <= 1) THEN

Line 2567: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

2563: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2564: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2565: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2566: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);
2567: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2568:
2569:
2570: IF (l_Debug_Level <= 1) THEN
2571: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);

Line 2575: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);

2571: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
2572: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
2573: END IF;
2574:
2575: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
2576:
2577: IF (l_Debug_Level <= 1) THEN
2578: cln_debug_pub.Add('Message for the trading partner : '||l_update_coll_msg, 1);
2579: END IF;

Line 2757: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);

2753: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);
2754: END IF;
2755:
2756: l_cln_ch_parameters := wf_parameter_list_t();
2757: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2758: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2759: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2760: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2761: WF_EVENT.AddParameterToList('COLLABORATION_STATUS',l_completed_status,l_cln_ch_parameters);

Line 2758: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);

2754: END IF;
2755:
2756: l_cln_ch_parameters := wf_parameter_list_t();
2757: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2758: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2759: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2760: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2761: WF_EVENT.AddParameterToList('COLLABORATION_STATUS',l_completed_status,l_cln_ch_parameters);
2762:

Line 2759: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);

2755:
2756: l_cln_ch_parameters := wf_parameter_list_t();
2757: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2758: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2759: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2760: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2761: WF_EVENT.AddParameterToList('COLLABORATION_STATUS',l_completed_status,l_cln_ch_parameters);
2762:
2763: IF (l_Debug_Level <= 1) THEN

Line 2760: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

2756: l_cln_ch_parameters := wf_parameter_list_t();
2757: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2758: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2759: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2760: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2761: WF_EVENT.AddParameterToList('COLLABORATION_STATUS',l_completed_status,l_cln_ch_parameters);
2762:
2763: IF (l_Debug_Level <= 1) THEN
2764: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);

Line 2761: WF_EVENT.AddParameterToList('COLLABORATION_STATUS',l_completed_status,l_cln_ch_parameters);

2757: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2758: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2759: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2760: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);
2761: WF_EVENT.AddParameterToList('COLLABORATION_STATUS',l_completed_status,l_cln_ch_parameters);
2762:
2763: IF (l_Debug_Level <= 1) THEN
2764: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
2765: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);

Line 2768: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);

2764: cln_debug_pub.Add('-------- EVENT PARAMETERS SET-----------', 1);
2765: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update', 1);
2766: END IF;
2767:
2768: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
2769:
2770: IF (l_Debug_Level <= 1) THEN
2771: cln_debug_pub.Add(l_msg_data,1);
2772: END IF;

Line 2900: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);

2896: IF (l_Debug_Level <= 1) THEN
2897: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
2898: END IF;
2899:
2900: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
2901: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
2902: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

Line 2901: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);

2897: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
2898: END IF;
2899:
2900: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
2901: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
2902: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2905: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

Line 2902: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);

2898: END IF;
2899:
2900: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
2901: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
2902: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2905: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2906: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

Line 2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);

2899:
2900: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
2901: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
2902: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2905: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2906: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2907: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

Line 2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);

2900: WF_EVENT.AddParameterToList('REFERENCE_ID1',l_reference1,l_cln_ch_parameters);
2901: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
2902: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2905: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2906: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2907: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
2908:

Line 2905: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);

2901: WF_EVENT.AddParameterToList('REFERENCE_ID2','Sup PartNo -'||p_supplier_part_number,l_cln_ch_parameters);
2902: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2905: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2906: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2907: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
2908:
2909: IF (l_Debug_Level <= 1) THEN

Line 2906: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);

2902: WF_EVENT.AddParameterToList('REFERENCE_ID3','ItemNo:'||p_item_number,l_cln_ch_parameters);
2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2905: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2906: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2907: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
2908:
2909: IF (l_Debug_Level <= 1) THEN
2910: cln_debug_pub.Add('----------------------------------------------', 1);

Line 2907: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);

2903: WF_EVENT.AddParameterToList('DETAIL_MESSAGE',l_dtl_msg,l_cln_ch_parameters);
2904: WF_EVENT.AddParameterToList('DOCUMENT_TYPE', 'SYNC_ITEM', l_cln_ch_parameters);
2905: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'IN', l_cln_ch_parameters);
2906: WF_EVENT.AddParameterToList('COLLABORATION_POINT', 'APPS', l_cln_ch_parameters);
2907: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',p_internal_control_number,l_cln_ch_parameters);
2908:
2909: IF (l_Debug_Level <= 1) THEN
2910: cln_debug_pub.Add('----------------------------------------------', 1);
2911: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);

Line 2914: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);

2910: cln_debug_pub.Add('----------------------------------------------', 1);
2911: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);
2912: END IF;
2913:
2914: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);
2915:
2916: IF (l_Debug_Level <= 1) THEN
2917: cln_debug_pub.Add(l_msg_data,1);
2918: END IF;