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',
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',
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',
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
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',
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',
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',
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',
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 --{
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
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:
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:
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',
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',
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',
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
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:
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',
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',
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:
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,
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',
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',
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,
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)
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',
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',
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',
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:
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,
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,
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