DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on WF_ENGINE

Line 609: wf_engine.CreateProcess(

605: ELSE
606: l_processName := 'CSM_AS_NFN_PROCESS';
607: END IF;
608:
609: wf_engine.CreateProcess(
610: itemtype => g_ItemType,
611: itemkey => l_item_key,
612: process => l_processName);
613:

Line 614: wf_engine.SetItemUserKey(

610: itemtype => g_ItemType,
611: itemkey => l_item_key,
612: process => l_processName);
613:
614: wf_engine.SetItemUserKey(
615: itemtype => g_ItemType,
616: itemkey => l_item_key,
617: userkey => l_item_key);
618:

Line 619: wf_engine.SetItemOwner(

615: itemtype => g_ItemType,
616: itemkey => l_item_key,
617: userkey => l_item_key);
618:
619: wf_engine.SetItemOwner(
620: itemtype => g_ItemType,
621: itemkey => l_item_key,
622: owner => l_item_owner);
623:

Line 624: wf_engine.SetItemAttrText(

620: itemtype => g_ItemType,
621: itemkey => l_item_key,
622: owner => l_item_owner);
623:
624: wf_engine.SetItemAttrText(
625: itemtype => g_ItemType,
626: itemkey => l_item_key,
627: aname => 'MESSAGE',
628: avalue => l_template);

Line 634: wf_engine.SetItemAttrText(

630: if l_template = 'DOWNLOAD_INIT_MSG'
631: then
632:
633: l_subject := p_wf_param.getValueForParameter('SUBJECT');
634: wf_engine.SetItemAttrText(
635: itemtype => g_ItemType,
636: itemkey => l_item_key,
637: aname => 'SUBJECT',
638: avalue => l_subject);

Line 641: wf_engine.SetItemAttrText(

637: aname => 'SUBJECT',
638: avalue => l_subject);
639:
640: l_body := p_wf_param.getValueForParameter('MESSAGE_BODY');
641: wf_engine.SetItemAttrText(
642: itemtype => g_ItemType,
643: itemkey => l_item_key,
644: aname => 'MESSAGE_BODY',
645: avalue => l_body);

Line 651: wf_engine.SetItemAttrText(

647: elsif l_template = 'FYI_MESSAGE'
648: then
649:
650: l_subject := p_wf_param.getValueForParameter('SUBJECT');
651: wf_engine.SetItemAttrText(
652: itemtype => g_ItemType,
653: itemkey => l_item_key,
654: aname => 'SUBJECT',
655: avalue => l_subject);

Line 658: wf_engine.SetItemAttrText(

654: aname => 'SUBJECT',
655: avalue => l_subject);
656:
657: l_body := p_wf_param.getValueForParameter('MESSAGE_BODY');
658: wf_engine.SetItemAttrText(
659: itemtype => g_ItemType,
660: itemkey => l_item_key,
661: aname => 'MESSAGE_BODY',
662: avalue => l_body);

Line 665: wf_engine.SetItemAttrText(

661: aname => 'MESSAGE_BODY',
662: avalue => l_body);
663:
664: l_client_id := p_wf_param.getValueForParameter('#FROM_ROLE');
665: wf_engine.SetItemAttrText(
666: itemtype => g_ItemType,
667: itemkey => l_item_key,
668: aname => '#FROM_ROLE',
669: avalue => l_client_id);

Line 675: wf_engine.SetItemAttrText(

671: elsif l_template = 'DEFERRED_ERROR_REPORT'
672: then
673:
674: l_client_id := p_wf_param.getValueForParameter('USER_NAME');
675: wf_engine.SetItemAttrText(
676: itemtype => g_ItemType,
677: itemkey => l_item_key,
678: aname => 'USER_NAME',
679: avalue => l_client_id);

Line 682: wf_engine.SetItemAttrNumber(

678: aname => 'USER_NAME',
679: avalue => l_client_id);
680:
681: l_tran_id := to_number(p_wf_param.getValueForParameter('TRAN_ID'));
682: wf_engine.SetItemAttrNumber(
683: itemtype => g_ItemType,
684: itemkey => l_item_key,
685: aname => 'TRAN_ID',
686: avalue => l_tran_id);

Line 689: wf_engine.SetItemAttrNumber(

685: aname => 'TRAN_ID',
686: avalue => l_tran_id);
687:
688: l_seq := to_number(p_wf_param.getValueForParameter('SEQUENCE'));
689: wf_engine.SetItemAttrNumber(
690: itemtype => g_ItemType,
691: itemkey => l_item_key,
692: aname => 'SEQUENCE',
693: avalue => l_seq);

Line 696: wf_engine.SetItemAttrText(

692: aname => 'SEQUENCE',
693: avalue => l_seq);
694:
695: l_dev_type := p_wf_param.getValueForParameter('DEVICE_TYPE');
696: wf_engine.SetItemAttrText(
697: itemtype => g_ItemType,
698: itemkey => l_item_key,
699: aname => 'DEVICE_TYPE',
700: avalue => l_dev_type);

Line 703: wf_engine.SetItemAttrText(

699: aname => 'DEVICE_TYPE',
700: avalue => l_dev_type);
701:
702: l_disp_name := p_wf_param.getValueForParameter('EMP_NAME');
703: wf_engine.SetItemAttrText(
704: itemtype => g_ItemType,
705: itemkey => l_item_key,
706: aname => 'EMP_NAME',
707: avalue => l_disp_name);

Line 710: wf_engine.SetItemAttrText(

706: aname => 'EMP_NAME',
707: avalue => l_disp_name);
708:
709: l_pub_name := p_wf_param.getValueForParameter('PUB_ITEM');
710: wf_engine.SetItemAttrText(
711: itemtype => g_ItemType,
712: itemkey => l_item_key,
713: aname => 'PUB_ITEM',
714: avalue => l_pub_name);

Line 717: wf_engine.SetItemAttrText(

713: aname => 'PUB_ITEM',
714: avalue => l_pub_name);
715:
716: l_pk_name := p_wf_param.getValueForParameter('PK_COLUMN');
717: wf_engine.SetItemAttrText(
718: itemtype => g_ItemType,
719: itemkey => l_item_key,
720: aname => 'PK_COLUMN',
721: avalue => l_pk_name);

Line 724: wf_engine.SetItemAttrText(

720: aname => 'PK_COLUMN',
721: avalue => l_pk_name);
722:
723: l_pk_value := p_wf_param.getValueForParameter('PK_VALUE');
724: wf_engine.SetItemAttrText(
725: itemtype => g_ItemType,
726: itemkey => l_item_key,
727: aname => 'PK_VALUE',
728: avalue => l_pk_value);

Line 731: wf_engine.SetItemAttrText(

727: aname => 'PK_VALUE',
728: avalue => l_pk_value);
729:
730: l_err_msg := p_wf_param.getValueForParameter('ERR_MSG');
731: wf_engine.SetItemAttrText(
732: itemtype => g_ItemType,
733: itemkey => l_item_key,
734: aname => 'ERR_MSG',
735: avalue => l_err_msg);

Line 738: wf_engine.SetItemAttrText(

734: aname => 'ERR_MSG',
735: avalue => l_err_msg);
736:
737: l_tran_date := p_wf_param.getValueForParameter('TRAN_DATE');
738: wf_engine.SetItemAttrText(
739: itemtype => g_ItemType,
740: itemkey => l_item_key,
741: aname => 'TRAN_DATE',
742: avalue => l_tran_date);

Line 748: wf_engine.SetItemAttrNumber(

744: elsif l_template = 'SYNC_ERROR_REPORT'
745: then
746:
747: l_session_id := to_number(p_wf_param.getValueForParameter('SESSION_ID'));
748: wf_engine.SetItemAttrNumber(
749: itemtype => g_ItemType,
750: itemkey => l_item_key,
751: aname => 'SESSION_ID',
752: avalue => l_session_id);

Line 755: wf_engine.SetItemAttrNumber(

751: aname => 'SESSION_ID',
752: avalue => l_session_id);
753:
754: l_tran_id := to_number(p_wf_param.getValueForParameter('TRAN_ID'));
755: wf_engine.SetItemAttrNumber(
756: itemtype => g_ItemType,
757: itemkey => l_item_key,
758: aname => 'TRAN_ID',
759: avalue => l_tran_id);

Line 762: wf_engine.SetItemAttrText(

758: aname => 'TRAN_ID',
759: avalue => l_tran_id);
760:
761: l_client_id := p_wf_param.getValueForParameter('USER_NAME');
762: wf_engine.SetItemAttrText(
763: itemtype => g_ItemType,
764: itemkey => l_item_key,
765: aname => 'USER_NAME',
766: avalue => l_client_id);

Line 769: wf_engine.SetItemAttrText(

765: aname => 'USER_NAME',
766: avalue => l_client_id);
767:
768: l_dev_type := p_wf_param.getValueForParameter('DEVICE_TYPE');
769: wf_engine.SetItemAttrText(
770: itemtype => g_ItemType,
771: itemkey => l_item_key,
772: aname => 'DEVICE_TYPE',
773: avalue => l_dev_type);

Line 776: wf_engine.SetItemAttrText(

772: aname => 'DEVICE_TYPE',
773: avalue => l_dev_type);
774:
775: l_dev_name := p_wf_param.getValueForParameter('DEVICE_NAME');
776: wf_engine.SetItemAttrText(
777: itemtype => g_ItemType,
778: itemkey => l_item_key,
779: aname => 'DEVICE_NAME',
780: avalue => l_dev_name);

Line 783: wf_engine.SetItemAttrText(

779: aname => 'DEVICE_NAME',
780: avalue => l_dev_name);
781:
782: l_err_msg := p_wf_param.getValueForParameter('ERROR_MSG');
783: wf_engine.SetItemAttrText(
784: itemtype => g_ItemType,
785: itemkey => l_item_key,
786: aname => 'ERROR_MSG',
787: avalue => l_err_msg);

Line 790: wf_engine.SetItemAttrText(

786: aname => 'ERROR_MSG',
787: avalue => l_err_msg);
788:
789: l_sync_date := p_wf_param.getValueForParameter('SYNC_DATE');
790: wf_engine.SetItemAttrText(
791: itemtype => g_ItemType,
792: itemkey => l_item_key,
793: aname => 'SYNC_DATE',
794: avalue => l_sync_date);

Line 798: wf_engine.SetItemAttrText(

794: avalue => l_sync_date);
795:
796: end if;
797:
798: wf_engine.SetItemAttrText(
799: itemtype => g_ItemType,
800: itemkey => l_item_key,
801: aname => 'RECIPIENT',
802: avalue => upper(p_recipient_role));

Line 804: wf_engine.StartProcess(

800: itemkey => l_item_key,
801: aname => 'RECIPIENT',
802: avalue => upper(p_recipient_role));
803:
804: wf_engine.StartProcess(
805: itemtype => g_ItemType,
806: itemkey => l_item_key);
807:
808:

Line 819: wf_engine.itemStatus(g_ItemType,l_item_key,l_status,l_result);

815: AND RECIPIENT_ROLE=p_recipient_role
816: AND ITEM_KEY = l_item_key;
817: EXCEPTION
818: WHEN OTHERS THEN
819: wf_engine.itemStatus(g_ItemType,l_item_key,l_status,l_result);
820: CSM_UTIL_PKG.LOG('Error in WF Process with item key:'||l_item_key ||' . Failed with status '||l_status
821: ||' , and result: '||l_result,'CSM_NOTIFICATION_EVENT_PKG.invoke_WF_NotifyProcess',FND_LOG.LEVEL_PROCEDURE);
822: return -1;
823: END;