DBA Data[Home] [Help]

APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on WF_EVENT

Line 487: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',

483:
484: IF ( l_Transaction_Code IN ('SSRO', 'SSAO', 'BSRO') ) THEN --{ --Fulfillment Batch XML Project (Added BSRO)
485: -- LSP PROJECT : For LSP mode send party type as 'C' (Customer)
486: IF (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL) THEN
487: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',
488: p_value => l_txn_hist_record.Trading_Partner_ID, -- LSP PROJECT Commented.
489: p_parameterlist => l_msg_parameter_list);
490: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
491: p_value => 'C',

Line 490: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',

486: IF (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL) THEN
487: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',
488: p_value => l_txn_hist_record.Trading_Partner_ID, -- LSP PROJECT Commented.
489: p_parameterlist => l_msg_parameter_list);
490: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
491: p_value => 'C',
492: p_parameterlist => l_msg_parameter_list);
493: ELSE
494: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',

Line 494: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',

490: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
491: p_value => 'C',
492: p_parameterlist => l_msg_parameter_list);
493: ELSE
494: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',
495: p_value => l_Party_Site_ID,
496: p_parameterlist => l_msg_parameter_list);
497: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
498: p_value => 'I',

Line 497: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',

493: ELSE
494: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_ID',
495: p_value => l_Party_Site_ID,
496: p_parameterlist => l_msg_parameter_list);
497: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
498: p_value => 'I',
499: p_parameterlist => l_msg_parameter_list);
500: END IF;
501: -- LSP PROJECT : end

Line 502: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_SITE_ID',

498: p_value => 'I',
499: p_parameterlist => l_msg_parameter_list);
500: END IF;
501: -- LSP PROJECT : end
502: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_SITE_ID',
503: p_value => l_Party_Site_ID,
504: p_parameterlist => l_msg_parameter_list);
505:
506: WF_EVENT.AddParameterToList (p_name => 'ECX_DOCUMENT_ID',

Line 506: WF_EVENT.AddParameterToList (p_name => 'ECX_DOCUMENT_ID',

502: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_SITE_ID',
503: p_value => l_Party_Site_ID,
504: p_parameterlist => l_msg_parameter_list);
505:
506: WF_EVENT.AddParameterToList (p_name => 'ECX_DOCUMENT_ID',
507: p_value => l_txn_hist_record.Document_Number,
508: p_parameterlist => l_msg_parameter_list);
509:
510: WF_EVENT.AddParameterToList (p_name => 'USER_ID',

Line 510: WF_EVENT.AddParameterToList (p_name => 'USER_ID',

506: WF_EVENT.AddParameterToList (p_name => 'ECX_DOCUMENT_ID',
507: p_value => l_txn_hist_record.Document_Number,
508: p_parameterlist => l_msg_parameter_list);
509:
510: WF_EVENT.AddParameterToList (p_name => 'USER_ID',
511: p_value => FND_GLOBAL.USER_ID,
512: p_parameterlist => l_msg_parameter_list);
513: --
514: WF_EVENT.AddParameterToList (p_name => 'APPLICATION_ID',

Line 514: WF_EVENT.AddParameterToList (p_name => 'APPLICATION_ID',

510: WF_EVENT.AddParameterToList (p_name => 'USER_ID',
511: p_value => FND_GLOBAL.USER_ID,
512: p_parameterlist => l_msg_parameter_list);
513: --
514: WF_EVENT.AddParameterToList (p_name => 'APPLICATION_ID',
515: p_value => FND_GLOBAL.RESP_APPL_ID,
516: p_parameterlist => l_msg_parameter_list);
517: --
518: WF_EVENT.AddParameterToList (p_name => 'RESPONSIBILITY_ID',

Line 518: WF_EVENT.AddParameterToList (p_name => 'RESPONSIBILITY_ID',

514: WF_EVENT.AddParameterToList (p_name => 'APPLICATION_ID',
515: p_value => FND_GLOBAL.RESP_APPL_ID,
516: p_parameterlist => l_msg_parameter_list);
517: --
518: WF_EVENT.AddParameterToList (p_name => 'RESPONSIBILITY_ID',
519: p_value => FND_GLOBAL.RESP_ID,
520: p_parameterlist => l_msg_parameter_list);
521:
522: IF ( l_txn_hist_record.document_type = 'SR' ) THEN --{

Line 523: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',

519: p_value => FND_GLOBAL.RESP_ID,
520: p_parameterlist => l_msg_parameter_list);
521:
522: IF ( l_txn_hist_record.document_type = 'SR' ) THEN --{
523: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',
524: p_value => 'FTE',
525: p_parameterlist => l_msg_parameter_list);
526:
527: --Notification change heali

Line 563: WF_EVENT.AddParameterToList (p_name => 'BODY_TEXT',

559: l_body_text := FND_MESSAGE.get;
560: /*IF l_debug_on THEN
561: wsh_debug_sv.log (l_module_name, 'l_body_text' , l_body_text);
562: END IF;*/
563: WF_EVENT.AddParameterToList (p_name => 'BODY_TEXT',
564: p_value => l_body_text,
565: p_parameterlist => l_msg_parameter_list);
566: END IF; --}
567:

Line 572: WF_EVENT.AddParameterToList (p_name => 'SUBJECT',

568: /*IF l_debug_on THEN
569: wsh_debug_sv.log (l_module_name, 'l_subject' , l_subject);
570: END IF;*/
571:
572: WF_EVENT.AddParameterToList (p_name => 'SUBJECT',
573: p_value => l_subject,
574: p_parameterlist => l_msg_parameter_list);
575:
576:

Line 598: WF_EVENT.AddParameterToList (p_name => 'DEL_NAME',

594: wsh_debug_sv.log (l_module_name, 'l_customer' ,l_customer );
595: wsh_debug_sv.log (l_module_name, 'l_st_location' ,l_st_location);
596: END IF;
597:
598: WF_EVENT.AddParameterToList (p_name => 'DEL_NAME',
599: p_value => l_del_name,
600: p_parameterlist => l_msg_parameter_list);
601:
602: WF_EVENT.AddParameterToList (p_name => 'SF_LOCATION',

Line 602: WF_EVENT.AddParameterToList (p_name => 'SF_LOCATION',

598: WF_EVENT.AddParameterToList (p_name => 'DEL_NAME',
599: p_value => l_del_name,
600: p_parameterlist => l_msg_parameter_list);
601:
602: WF_EVENT.AddParameterToList (p_name => 'SF_LOCATION',
603: p_value => l_sf_location,
604: p_parameterlist => l_msg_parameter_list);
605:
606: WF_EVENT.AddParameterToList (p_name => 'CUSTOMER',

Line 606: WF_EVENT.AddParameterToList (p_name => 'CUSTOMER',

602: WF_EVENT.AddParameterToList (p_name => 'SF_LOCATION',
603: p_value => l_sf_location,
604: p_parameterlist => l_msg_parameter_list);
605:
606: WF_EVENT.AddParameterToList (p_name => 'CUSTOMER',
607: p_value => l_customer,
608: p_parameterlist => l_msg_parameter_list);
609:
610: WF_EVENT.AddParameterToList (p_name => 'ST_LOCATION',

Line 610: WF_EVENT.AddParameterToList (p_name => 'ST_LOCATION',

606: WF_EVENT.AddParameterToList (p_name => 'CUSTOMER',
607: p_value => l_customer,
608: p_parameterlist => l_msg_parameter_list);
609:
610: WF_EVENT.AddParameterToList (p_name => 'ST_LOCATION',
611: p_value => l_st_location,
612: p_parameterlist => l_msg_parameter_list);
613: END IF; --}
614: --Notification change heali

Line 617: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',

613: END IF; --}
614: --Notification change heali
615:
616: ELSE --}{
617: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',
618: p_value => 'WSH',
619: p_parameterlist => l_msg_parameter_list);
620: END IF; --}
621:

Line 625: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',

621:
622: --R12.1.1 STANDALONE PROJECT
623: -- LSP PROJECT : For LSP pass transation sub type as SSNO-LSP
624: IF (l_wms_deployment_mode = 'L' AND l_client_id IS NOT NULL) THEN
625: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
626: p_value => 'SSNO-LSP',
627: p_parameterlist => l_msg_parameter_list);
628: ELSIF (l_wms_deployment_mode = 'D') THEN
629: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',

Line 629: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',

625: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
626: p_value => 'SSNO-LSP',
627: p_parameterlist => l_msg_parameter_list);
628: ELSIF (l_wms_deployment_mode = 'D') THEN
629: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
630: p_value => 'SSNO-STND',
631: p_parameterlist => l_msg_parameter_list);
632: ELSE
633: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',

Line 633: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',

629: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
630: p_value => 'SSNO-STND',
631: p_parameterlist => l_msg_parameter_list);
632: ELSE
633: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
634: p_value => 'SSNO',
635: p_parameterlist => l_msg_parameter_list);
636: END IF;
637:

Line 638: WF_EVENT.AddParameterToList (p_name => 'USER',

634: p_value => 'SSNO',
635: p_parameterlist => l_msg_parameter_list);
636: END IF;
637:
638: WF_EVENT.AddParameterToList (p_name => 'USER',
639: p_value => FND_GLOBAL.user_name,
640: p_parameterlist => l_msg_parameter_list);
641: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',
642: p_value => l_txn_hist_record.Action_Type,

Line 641: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',

637:
638: WF_EVENT.AddParameterToList (p_name => 'USER',
639: p_value => FND_GLOBAL.user_name,
640: p_parameterlist => l_msg_parameter_list);
641: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',
642: p_value => l_txn_hist_record.Action_Type,
643: p_parameterlist => l_msg_parameter_list);
644: ELSIF ( l_Transaction_Code = 'SCBOD' ) THEN --}
645: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',

Line 645: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',

641: WF_EVENT.AddParameterToList (p_name => 'ECX_PARAMETER1',
642: p_value => l_txn_hist_record.Action_Type,
643: p_parameterlist => l_msg_parameter_list);
644: ELSIF ( l_Transaction_Code = 'SCBOD' ) THEN --}
645: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',
646: p_value => 'ECX',
647: p_parameterlist => l_Cbod_parameter_list);
648: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
649: p_value => 'CBODO',

Line 648: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',

644: ELSIF ( l_Transaction_Code = 'SCBOD' ) THEN --}
645: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_TYPE',
646: p_value => 'ECX',
647: p_parameterlist => l_Cbod_parameter_list);
648: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
649: p_value => 'CBODO',
650: p_parameterlist => l_Cbod_parameter_list);
651: WF_EVENT.AddParameterToList (p_name => 'ECX_DOCUMENT_ID',
652: p_value => l_txn_hist_record.Internal_Control_Number,

Line 651: WF_EVENT.AddParameterToList (p_name => 'ECX_DOCUMENT_ID',

647: p_parameterlist => l_Cbod_parameter_list);
648: WF_EVENT.AddParameterToList (p_name => 'ECX_TRANSACTION_SUBTYPE',
649: p_value => 'CBODO',
650: p_parameterlist => l_Cbod_parameter_list);
651: WF_EVENT.AddParameterToList (p_name => 'ECX_DOCUMENT_ID',
652: p_value => l_txn_hist_record.Internal_Control_Number,
653: p_parameterlist => l_Cbod_parameter_list);
654:
655: -- LSP PROJECT : For LSP mode send party type as 'C' (Customer)

Line 657: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',

653: p_parameterlist => l_Cbod_parameter_list);
654:
655: -- LSP PROJECT : For LSP mode send party type as 'C' (Customer)
656: IF (l_wms_deployment_mode = 'L' OR l_txn_hist_record.client_code IS NOT NULL) THEN
657: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
658: p_value => 'C',
659: p_parameterlist => l_Cbod_parameter_list);
660: ELSE
661: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',

Line 661: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',

657: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
658: p_value => 'C',
659: p_parameterlist => l_Cbod_parameter_list);
660: ELSE
661: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
662: p_value => 'I',
663: p_parameterlist => l_Cbod_parameter_list);
664: END IF;
665: WF_EVENT.AddParameterToList (p_name => 'CONFIRM_STATUSLVL',

Line 665: WF_EVENT.AddParameterToList (p_name => 'CONFIRM_STATUSLVL',

661: WF_EVENT.AddParameterToList (p_name => 'ECX_PARTY_TYPE',
662: p_value => 'I',
663: p_parameterlist => l_Cbod_parameter_list);
664: END IF;
665: WF_EVENT.AddParameterToList (p_name => 'CONFIRM_STATUSLVL',
666: p_value => P_Cbod_Status,
667: p_parameterlist => l_Cbod_parameter_list);
668: ELSIF ( l_Transaction_Code = 'CONFIRM' ) THEN
669: WF_EVENT.AddParameterToList (p_name => 'PARAMETER6',

Line 669: WF_EVENT.AddParameterToList (p_name => 'PARAMETER6',

665: WF_EVENT.AddParameterToList (p_name => 'CONFIRM_STATUSLVL',
666: p_value => P_Cbod_Status,
667: p_parameterlist => l_Cbod_parameter_list);
668: ELSIF ( l_Transaction_Code = 'CONFIRM' ) THEN
669: WF_EVENT.AddParameterToList (p_name => 'PARAMETER6',
670: p_value => P_Cbod_Status,
671: p_parameterlist => l_Cbod_parameter_list);
672: END IF;
673:

Line 698: WF_EVENT.raise ( p_event_name => l_event_name,

694: wsh_debug_sv.log (l_module_name, 'Before Raising Event');
695: END IF;
696:
697: IF ( l_Transaction_Code IN ('SSRO', 'SSAO', 'BSRO') ) THEN --Fulfillment Batch XML Project (Added BSRO)
698: WF_EVENT.raise ( p_event_name => l_event_name,
699: p_event_key => l_Event_Key,
700: p_parameters => l_msg_parameter_list );
701: ELSIF ( l_Transaction_Code IN ('SCBOD', 'CONFIRM') ) THEN
702: WF_EVENT.raise ( p_event_name => l_event_name,

Line 702: WF_EVENT.raise ( p_event_name => l_event_name,

698: WF_EVENT.raise ( p_event_name => l_event_name,
699: p_event_key => l_Event_Key,
700: p_parameters => l_msg_parameter_list );
701: ELSIF ( l_Transaction_Code IN ('SCBOD', 'CONFIRM') ) THEN
702: WF_EVENT.raise ( p_event_name => l_event_name,
703: p_event_key => l_Event_Key,
704: p_parameters => l_Cbod_parameter_list );
705: ELSE
706: WF_EVENT.raise ( p_event_name => l_event_name,

Line 706: WF_EVENT.raise ( p_event_name => l_event_name,

702: WF_EVENT.raise ( p_event_name => l_event_name,
703: p_event_key => l_Event_Key,
704: p_parameters => l_Cbod_parameter_list );
705: ELSE
706: WF_EVENT.raise ( p_event_name => l_event_name,
707: p_event_key => l_Event_Key );
708: END IF;
709:
710: IF l_debug_on THEN