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.

[Home] [Help]

APPS.ECX_STANDARD dependencies on WF_ENGINE

Line 29: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ECX_ERROR_TYPE',ecx_utils.error_type);

25: )
26: is
27: begin
28: begin
29: wf_engine.SetItemAttrNumber(itemtype,itemkey,'ECX_ERROR_TYPE',ecx_utils.error_type);
30: exception
31: when others then
32:
33: -- If item attribute does not exist then create it;

Line 36: wf_engine.AddItemAttr(itemtype,itemkey,'ECX_ERROR_TYPE',null,ecx_utils.error_type,null);

32:
33: -- If item attribute does not exist then create it;
34:
35: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
36: wf_engine.AddItemAttr(itemtype,itemkey,'ECX_ERROR_TYPE',null,ecx_utils.error_type,null);
37: else
38: raise;
39: end if;
40: end;

Line 43: wf_engine.SetItemAttrText(itemtype,itemkey,'ECX_LOG_FILE',ecx_utils.g_logfile);

39: end if;
40: end;
41:
42: begin
43: wf_engine.SetItemAttrText(itemtype,itemkey,'ECX_LOG_FILE',ecx_utils.g_logfile);
44: exception
45: when others then
46:
47: -- If item attribute does not exist then create it;

Line 50: wf_engine.AddItemAttr(itemtype,itemkey,'ECX_LOG_FILE',ecx_utils.g_logfile,null,null);

46:
47: -- If item attribute does not exist then create it;
48:
49: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
50: wf_engine.AddItemAttr(itemtype,itemkey,'ECX_LOG_FILE',ecx_utils.g_logfile,null,null);
51: else
52: raise;
53: end if;
54: end;

Line 80: i_ws_soapaction := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'SOAPACTION', true);

76: if (p_event is not null) then
77: i_parameterList := wf_event_t.getParameterList(p_event);
78:
79: -- Retrieve or default Web Services related event parameters if exists
80: i_ws_soapaction := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'SOAPACTION', true);
81: if (i_ws_soapaction is null) then
82: i_ws_soapaction := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'SOAPACTION', true);
83: if (i_ws_soapaction is null) and (i_parameterList is not null) then
84: i_ws_soapaction := wf_event.getValueForParameter('SOAPACTION', i_parameterList);

Line 82: i_ws_soapaction := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'SOAPACTION', true);

78:
79: -- Retrieve or default Web Services related event parameters if exists
80: i_ws_soapaction := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'SOAPACTION', true);
81: if (i_ws_soapaction is null) then
82: i_ws_soapaction := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'SOAPACTION', true);
83: if (i_ws_soapaction is null) and (i_parameterList is not null) then
84: i_ws_soapaction := wf_event.getValueForParameter('SOAPACTION', i_parameterList);
85: end if;
86: end if;

Line 91: i_ws_svc_namespace := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_SERVICE_NAMESPACE', true);

87: if (i_ws_soapaction is null) then
88: i_ws_soapaction := ' '; -- defaulting
89: end if;
90:
91: i_ws_svc_namespace := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_SERVICE_NAMESPACE', true);
92: if (i_ws_svc_namespace is null) then
93: i_ws_svc_namespace := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_SERVICE_NAMESPACE', true);
94: if (i_ws_svc_namespace is null) and (i_parameterList is not null) then
95: i_ws_svc_namespace := wf_event.getValueForParameter('WS_SERVICE_NAMESPACE', i_parameterList);

Line 93: i_ws_svc_namespace := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_SERVICE_NAMESPACE', true);

89: end if;
90:
91: i_ws_svc_namespace := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_SERVICE_NAMESPACE', true);
92: if (i_ws_svc_namespace is null) then
93: i_ws_svc_namespace := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_SERVICE_NAMESPACE', true);
94: if (i_ws_svc_namespace is null) and (i_parameterList is not null) then
95: i_ws_svc_namespace := wf_event.getValueForParameter('WS_SERVICE_NAMESPACE', i_parameterList);
96: end if;
97: end if;

Line 102: i_ws_port_operation := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_PORT_OPERATION', true);

98: if (i_ws_svc_namespace is null) then
99: i_ws_svc_namespace := 'http://xmlns.oracle.com/apps/fnd/XMLGateway'; -- defaulting
100: end if;
101:
102: i_ws_port_operation := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_PORT_OPERATION', true);
103: if (i_ws_port_operation is null) then
104: i_ws_port_operation := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_PORT_OPERATION', true);
105: if (i_ws_port_operation is null) and (i_parameterList is not null) then
106: i_ws_port_operation := wf_event.getValueForParameter('WS_PORT_OPERATION', i_parameterList);

Line 104: i_ws_port_operation := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_PORT_OPERATION', true);

100: end if;
101:
102: i_ws_port_operation := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_PORT_OPERATION', true);
103: if (i_ws_port_operation is null) then
104: i_ws_port_operation := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_PORT_OPERATION', true);
105: if (i_ws_port_operation is null) and (i_parameterList is not null) then
106: i_ws_port_operation := wf_event.getValueForParameter('WS_PORT_OPERATION', i_parameterList);
107: end if;
108: end if;

Line 113: i_ws_hdr_impl_class := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_HEADER_IMPL_CLASS', true);

109: if (i_ws_port_operation is null) then
110: i_ws_port_operation := 'ReceiveDocument'; -- defaulting
111: end if;
112:
113: i_ws_hdr_impl_class := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_HEADER_IMPL_CLASS', true);
114: if (i_ws_hdr_impl_class is null) then
115: i_ws_hdr_impl_class := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_HEADER_IMPL_CLASS', true);
116: if (i_ws_hdr_impl_class is null) and (i_parameterList is not null) then
117: i_ws_hdr_impl_class := wf_event.getValueForParameter('WS_HEADER_IMPL_CLASS', i_parameterList);

Line 115: i_ws_hdr_impl_class := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_HEADER_IMPL_CLASS', true);

111: end if;
112:
113: i_ws_hdr_impl_class := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_HEADER_IMPL_CLASS', true);
114: if (i_ws_hdr_impl_class is null) then
115: i_ws_hdr_impl_class := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_HEADER_IMPL_CLASS', true);
116: if (i_ws_hdr_impl_class is null) and (i_parameterList is not null) then
117: i_ws_hdr_impl_class := wf_event.getValueForParameter('WS_HEADER_IMPL_CLASS', i_parameterList);
118: end if;
119: end if;

Line 124: i_ws_res_impl_class := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_RESPONSE_IMPL_CLASS', true);

120: if (i_ws_hdr_impl_class is null) then
121: i_ws_hdr_impl_class := 'oracle.apps.fnd.wf.ws.client.DefaultHeaderGenerator'; -- defaulting
122: end if;
123:
124: i_ws_res_impl_class := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_RESPONSE_IMPL_CLASS', true);
125: if (i_ws_res_impl_class is null) then
126: i_ws_res_impl_class := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_RESPONSE_IMPL_CLASS', true);
127: if (i_ws_res_impl_class is null) and (i_parameterList is not null) then
128: i_ws_res_impl_class := wf_event.getValueForParameter('WS_RESPONSE_IMPL_CLASS', i_parameterList);

Line 126: i_ws_res_impl_class := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_RESPONSE_IMPL_CLASS', true);

122: end if;
123:
124: i_ws_res_impl_class := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_RESPONSE_IMPL_CLASS', true);
125: if (i_ws_res_impl_class is null) then
126: i_ws_res_impl_class := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_RESPONSE_IMPL_CLASS', true);
127: if (i_ws_res_impl_class is null) and (i_parameterList is not null) then
128: i_ws_res_impl_class := wf_event.getValueForParameter('WS_RESPONSE_IMPL_CLASS', i_parameterList);
129: end if;
130: end if;

Line 135: i_ws_consumer := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_CONSUMER', true);

131: if (i_ws_res_impl_class is null) then
132: i_ws_res_impl_class := 'oracle.apps.fnd.wf.ws.client.WfWsResponse'; -- defaulting
133: end if;
134:
135: i_ws_consumer := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_CONSUMER', true);
136: if (i_ws_consumer is null) then
137: i_ws_consumer := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_CONSUMER', true);
138: if (i_ws_consumer is null) and (i_parameterList is not null) then
139: i_ws_consumer := wf_event.getValueForParameter('WS_CONSUMER', i_parameterList);

Line 137: i_ws_consumer := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_CONSUMER', true);

133: end if;
134:
135: i_ws_consumer := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'WS_CONSUMER', true);
136: if (i_ws_consumer is null) then
137: i_ws_consumer := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'WS_CONSUMER', true);
138: if (i_ws_consumer is null) and (i_parameterList is not null) then
139: i_ws_consumer := wf_event.getValueForParameter('WS_CONSUMER', i_parameterList);
140: end if;
141: end if;

Line 634: if (funcmode <> wf_engine.eng_run) then

630: ecx_utils.g_item_key := itemkey;
631: ecx_utils.g_activity_id := actid;
632:
633: -- Do nothing in cancel or timeout mode
634: if (funcmode <> wf_engine.eng_run) then
635: resultout := wf_engine.eng_null;
636: return;
637: end if;
638:

Line 635: resultout := wf_engine.eng_null;

631: ecx_utils.g_activity_id := actid;
632:
633: -- Do nothing in cancel or timeout mode
634: if (funcmode <> wf_engine.eng_run) then
635: resultout := wf_engine.eng_null;
636: return;
637: end if;
638:
639: -- Get ecx map code

Line 641: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');

637: end if;
638:
639: -- Get ecx map code
640:
641: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
642: if (i_map_code is null ) then
643: wf_core.token('ECX_MAP_CODE','NULL');
644: wf_core.raise('WFSQL_ARGS');
645: end if;

Line 649: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);

645: end if;
646:
647:
648:
649: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);
650:
651:
652: -- Verify that the attr type = EVENT
653:

Line 654: i_inevent := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_IN');

650:
651:
652: -- Verify that the attr type = EVENT
653:
654: i_inevent := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_IN');
655: if (i_inevent is null ) then
656: wf_core.token('ECX_EVENT_MESSAGE_IN','NULL');
657: wf_core.raise('WFSQL_ARGS');
658: end if;

Line 660: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');

656: wf_core.token('ECX_EVENT_MESSAGE_IN','NULL');
657: wf_core.raise('WFSQL_ARGS');
658: end if;
659:
660: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE_OUT');
661: if ( aname is null ) then
662: wf_core.token('ECX_EVENT_MESSAGE_OUT','NULL');
663: wf_core.raise('WFSQL_ARGS');
664: end if;

Line 666: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);

662: wf_core.token('ECX_EVENT_MESSAGE_OUT','NULL');
663: wf_core.raise('WFSQL_ARGS');
664: end if;
665:
666: --Wf_Engine.GetItemAttrInfo(itemtype, aname ,atype, asubtype, aformat);
667: --if (atype <> 'EVENT' ) then
668: --wf_core.token('VTYPE',atype);
669: --wf_core.raise('WFXXXV_VTYPE');
670: --end if;

Line 672: i_outevent := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, aname);

668: --wf_core.token('VTYPE',atype);
669: --wf_core.raise('WFXXXV_VTYPE');
670: --end if;
671:
672: i_outevent := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, aname);
673:
674: -- extract payload and pass to ECX
675:
676: XMLtoXMLCover

Line 685: wf_engine.SetItemAttrEvent(itemtype,itemkey,aname,i_outevent);

681: i_debug_level
682: );
683:
684: addItemAttributes(itemtype,itemkey);
685: wf_engine.SetItemAttrEvent(itemtype,itemkey,aname,i_outevent);
686:
687: resultout := 'COMPLETE:';
688: exception
689: when others then

Line 720: if (funcmode <> wf_engine.eng_run) then

716: ecx_utils.g_item_key := itemkey;
717: ecx_utils.g_activity_id := actid;
718:
719: -- Do nothing in cancel or timeout mode
720: if (funcmode <> wf_engine.eng_run) then
721: resultout := wf_engine.eng_null;
722: return;
723: end if;
724:

Line 721: resultout := wf_engine.eng_null;

717: ecx_utils.g_activity_id := actid;
718:
719: -- Do nothing in cancel or timeout mode
720: if (funcmode <> wf_engine.eng_run) then
721: resultout := wf_engine.eng_null;
722: return;
723: end if;
724:
725: -- Get ecx map code

Line 727: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');

723: end if;
724:
725: -- Get ecx map code
726:
727: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
728: if (i_map_code is null ) then
729: wf_core.token('ECX_MAP_CODE','NULL');
730: wf_core.raise('WFSQL_ARGS');
731: end if;

Line 735: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);

731: end if;
732:
733:
734:
735: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);
736: i_event := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
737: if (i_event is null ) then
738: wf_core.token('ECX_EVENT_MESSAGE','NULL');
739: wf_core.raise('WFSQL_ARGS');

Line 736: i_event := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');

732:
733:
734:
735: i_debug_level := nvl(wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DEBUG_LEVEL',true),0);
736: i_event := Wf_Engine.GetActivityAttrEvent(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
737: if (i_event is null ) then
738: wf_core.token('ECX_EVENT_MESSAGE','NULL');
739: wf_core.raise('WFSQL_ARGS');
740: end if;

Line 802: if (funcmode <> wf_engine.eng_run) then

798: ecx_utils.g_activity_id := actid;
799:
800: -- Do nothing in cancel or timeout mode
801:
802: if (funcmode <> wf_engine.eng_run) then
803: resultout := wf_engine.eng_null;
804: return;
805: end if;
806:

Line 803: resultout := wf_engine.eng_null;

799:
800: -- Do nothing in cancel or timeout mode
801:
802: if (funcmode <> wf_engine.eng_run) then
803: resultout := wf_engine.eng_null;
804: return;
805: end if;
806:
807: -- Retreive Activity Attributes

Line 809: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');

805: end if;
806:
807: -- Retreive Activity Attributes
808:
809: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
810: if ( transaction_type is null ) then
811: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
812: wf_core.raise('WFSQL_ARGS');
813: end if;

Line 815: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');

811: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
812: wf_core.raise('WFSQL_ARGS');
813: end if;
814:
815: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
816: if ( transaction_subtype is null ) then
817: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
818: wf_core.raise('WFSQL_ARGS');
819: end if;

Line 821: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');

817: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
818: wf_core.raise('WFSQL_ARGS');
819: end if;
820:
821: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
822: if ( party_site_id is null ) then
823: wf_core.token('ECX_PARTY_SITE_ID','NULL');
824: wf_core.raise('WFSQL_ARGS');
825: end if;

Line 829: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');

825: end if;
826:
827: -- party_id is optional. Only party_site_id is required
828:
829: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
830: /* Start of bug #2183619 */
831: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);
832: /* End of bug #2183619*/
833:

Line 831: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);

827: -- party_id is optional. Only party_site_id is required
828:
829: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
830: /* Start of bug #2183619 */
831: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);
832: /* End of bug #2183619*/
833:
834: /* Start of changes for Bug #2215677*/
835: -- Get confirmation status of the trading partner.

Line 836: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

832: /* End of bug #2183619*/
833:
834: /* Start of changes for Bug #2215677*/
835: -- Get confirmation status of the trading partner.
836: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
837: 'ECX_CONFIRMATION_FLAG', ignore_notfound => true);
838: if (aname is not null) then
839: ecx_document.getConfirmationStatus(
840: i_transaction_type => transaction_type,

Line 847: wf_engine.SetItemAttrText ( itemtype => itemtype,

843: i_party_site_id => party_site_id,
844: i_party_type => party_type,
845: o_confirmation => i_confirmation
846: );
847: wf_engine.SetItemAttrText ( itemtype => itemtype,
848: itemkey => itemkey,
849: aname => aname,
850: avalue => i_confirmation);
851: end if;

Line 961: if (funcmode <> wf_engine.eng_run) then

957: ecx_utils.g_item_key := itemkey;
958: ecx_utils.g_activity_id := actid;
959:
960: -- Do nothing in cancel or timeout mode
961: if (funcmode <> wf_engine.eng_run) then
962: resultout := wf_engine.eng_null;
963: return;
964: end if;
965:

Line 962: resultout := wf_engine.eng_null;

958: ecx_utils.g_activity_id := actid;
959:
960: -- Do nothing in cancel or timeout mode
961: if (funcmode <> wf_engine.eng_run) then
962: resultout := wf_engine.eng_null;
963: return;
964: end if;
965:
966: -- We need to determine which parameters are required and which are optional

Line 968: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');

964: end if;
965:
966: -- We need to determine which parameters are required and which are optional
967:
968: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
969: if ( transaction_type is null ) then
970: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
971: wf_core.raise('WFSQL_ARGS');
972: end if;

Line 974: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');

970: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
971: wf_core.raise('WFSQL_ARGS');
972: end if;
973:
974: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
975: if ( transaction_subtype is null ) then
976: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
977: wf_core.raise('WFSQL_ARGS');
978: end if;

Line 980: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');

976: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
977: wf_core.raise('WFSQL_ARGS');
978: end if;
979:
980: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
981: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
982: then
983: if ( party_site_id is null )
984: then

Line 992: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');

988: end if;
989:
990: -- party_id is optional. Only party_site_id is required
991:
992: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
993: /* Start of bug #2183619 */
994: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', ignore_notfound => true);
995:
996: /* End of bug #2183619 */

Line 994: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', ignore_notfound => true);

990: -- party_id is optional. Only party_site_id is required
991:
992: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
993: /* Start of bug #2183619 */
994: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', ignore_notfound => true);
995:
996: /* End of bug #2183619 */
997:
998: -- It is an optional Field

Line 999: document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');

995:
996: /* End of bug #2183619 */
997:
998: -- It is an optional Field
999: document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1000: /**
1001: if ( document_id is null ) then
1002: wf_core.token('ECX_DOCUMENT_ID','NULL');
1003: wf_core.raise('WFSQL_ARGS');

Line 1007: debug_mode := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);

1003: wf_core.raise('WFSQL_ARGS');
1004: end if;
1005: **/
1006:
1007: debug_mode := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1008:
1009: /** Check for the Item Attribute of type ECX_EVENT_MESSAGE. If found , then use that to initialize the
1010: global variable for ecx_utils.g_event or create a local instance.
1011: **/

Line 1015: ecx_utils.g_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey,'ECX_EVENT_MESSAGE');

1011: **/
1012: begin
1013: -- Initialize the Event before using it.
1014: wf_event_t.initialize(ecx_utils.g_event);
1015: ecx_utils.g_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey,'ECX_EVENT_MESSAGE');
1016: exception
1017: when others then
1018: if ecx_utils.g_event is null
1019: then

Line 1026: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');

1022: end;
1023:
1024:
1025: /* Start of changes for bug 2120165 */
1026: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1027: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1028: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1029: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1030: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

Line 1027: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');

1023:
1024:
1025: /* Start of changes for bug 2120165 */
1026: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1027: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1028: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1029: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1030: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1031: /* End of changes for bug 2120165*/

Line 1028: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');

1024:
1025: /* Start of changes for bug 2120165 */
1026: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1027: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1028: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1029: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1030: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1031: /* End of changes for bug 2120165*/
1032:

Line 1029: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');

1025: /* Start of changes for bug 2120165 */
1026: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1027: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1028: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1029: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1030: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1031: /* End of changes for bug 2120165*/
1032:
1033: -- Add the above Parameters to the Global Event Message Object

Line 1030: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

1026: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1027: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1028: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1029: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1030: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1031: /* End of changes for bug 2120165*/
1032:
1033: -- Add the above Parameters to the Global Event Message Object
1034: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.

Line 1042: send_mode := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_SEND_MODE');

1038: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1039: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1040:
1041:
1042: send_mode := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_SEND_MODE');
1043:
1044: wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);
1045:
1046: -- KH comment: There is a more efficient way of doing this. The execution test

Line 1049: if (result = wf_engine.eng_null)

1045:
1046: -- KH comment: There is a more efficient way of doing this. The execution test
1047: -- Should come before any attributes are retrived
1048:
1049: if (result = wf_engine.eng_null)
1050: then
1051: -- Second execution.
1052: -- Wait is completed, return complete result.
1053: -- Call the XML gateway Outbound Engine

Line 1067: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');

1063: debug_mode => debug_mode,
1064: i_msgid => msgid
1065: );
1066:
1067: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');
1068: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1069:
1070: addItemAttributes(itemtype,itemkey);
1071:

Line 1068: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);

1064: i_msgid => msgid
1065: );
1066:
1067: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');
1068: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1069:
1070: addItemAttributes(itemtype,itemkey);
1071:
1072: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

Line 1072: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

1068: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1069:
1070: addItemAttributes(itemtype,itemkey);
1071:
1072: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1073: else
1074: -- First execution.
1075: -- Check for A-synch or Synch Mode
1076: if ( send_mode = 'ASYNCH')

Line 1079: resultout := wf_engine.eng_deferred;

1075: -- Check for A-synch or Synch Mode
1076: if ( send_mode = 'ASYNCH')
1077: then
1078: -- If Async , deffer the executio
1079: resultout := wf_engine.eng_deferred;
1080: elsif ( ( send_mode is null ) or ( send_mode = 'SYNCH' ) )
1081: then
1082: -- Call the XML gateway Outbound Engine
1083: -- added party_type with bug #2183619

Line 1096: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');

1092: debug_mode => debug_mode,
1093: i_msgid => msgid
1094: );
1095:
1096: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');
1097: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1098:
1099: addItemAttributes(itemtype,itemkey);
1100:

Line 1097: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);

1093: i_msgid => msgid
1094: );
1095:
1096: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');
1097: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1098:
1099: addItemAttributes(itemtype,itemkey);
1100:
1101: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

Line 1101: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

1097: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1098:
1099: addItemAttributes(itemtype,itemkey);
1100:
1101: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1102: end if;
1103: end if;
1104:
1105: exception

Line 1197: if (funcmode <> wf_engine.eng_run) then

1193: ecx_utils.g_item_key := itemkey;
1194: ecx_utils.g_activity_id := actid;
1195:
1196: -- Do nothing in cancel or timeout mode
1197: if (funcmode <> wf_engine.eng_run) then
1198: resultout := wf_engine.eng_null;
1199: return;
1200: end if;
1201:

Line 1198: resultout := wf_engine.eng_null;

1194: ecx_utils.g_activity_id := actid;
1195:
1196: -- Do nothing in cancel or timeout mode
1197: if (funcmode <> wf_engine.eng_run) then
1198: resultout := wf_engine.eng_null;
1199: return;
1200: end if;
1201:
1202:

Line 1203: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);

1199: return;
1200: end if;
1201:
1202:
1203: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1204:
1205:
1206: -- Retreive Activity Attributes
1207:

Line 1208: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');

1204:
1205:
1206: -- Retreive Activity Attributes
1207:
1208: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
1209: if ( transaction_type is null ) then
1210: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
1211: wf_core.raise('WFSQL_ARGS');
1212: end if;

Line 1214: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');

1210: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
1211: wf_core.raise('WFSQL_ARGS');
1212: end if;
1213:
1214: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1215: if ( transaction_subtype is null ) then
1216: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
1217: wf_core.raise('WFSQL_ARGS');
1218: end if;

Line 1220: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');

1216: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
1217: wf_core.raise('WFSQL_ARGS');
1218: end if;
1219:
1220: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
1221:
1222: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
1223: then
1224: if ( party_site_id is null ) then

Line 1232: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');

1228: end if;
1229:
1230: -- party_id is optional. Only party_site_id is required
1231:
1232: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
1233:
1234: /* Start of bug #2183619 */
1235:
1236: p_party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);

Line 1236: p_party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);

1232: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
1233:
1234: /* Start of bug #2183619 */
1235:
1236: p_party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);
1237:
1238: /* End of bug #2183619*/
1239:
1240: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');

Line 1240: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');

1236: p_party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);
1237:
1238: /* End of bug #2183619*/
1239:
1240: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1241:
1242:
1243: -- Verify that the attr type = EVENT
1244:

Line 1245: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');

1241:
1242:
1243: -- Verify that the attr type = EVENT
1244:
1245: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1246: if ( evt_name is null ) then
1247: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1248: wf_core.raise('WFSQL_ARGS');
1249: end if;

Line 1251: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);

1247: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1248: wf_core.raise('WFSQL_ARGS');
1249: end if;
1250:
1251: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1252: if (atype <> 'EVENT' ) then
1253: wf_core.token('VTYPE',atype);
1254: wf_core.raise('WFXXXV_VTYPE');
1255: end if;

Line 1257: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);

1253: wf_core.token('VTYPE',atype);
1254: wf_core.raise('WFXXXV_VTYPE');
1255: end if;
1256:
1257: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1258: /**
1259: Populate the Parameters in the original event Object being passed. if it is null , initialize and create
1260: a new Instance and populate the variables
1261: if i_event is null

Line 1276: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');

1272: then
1273: ecx_utils.g_event := i_event;
1274: End If;
1275:
1276: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1277: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1278: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1279: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1280: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

Line 1277: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');

1273: ecx_utils.g_event := i_event;
1274: End If;
1275:
1276: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1277: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1278: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1279: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1280: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1281: -- Add the above Parameters to the Global Event Message Object

Line 1278: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');

1274: End If;
1275:
1276: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1277: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1278: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1279: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1280: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1281: -- Add the above Parameters to the Global Event Message Object
1282: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.

Line 1279: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');

1275:
1276: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1277: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1278: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1279: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1280: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1281: -- Add the above Parameters to the Global Event Message Object
1282: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1283: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);

Line 1280: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

1276: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1277: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1278: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1279: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1280: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1281: -- Add the above Parameters to the Global Event Message Object
1282: -- For backward compatability , we are passing ECX_PARAMETER1 -> PARAMETER1 on the Engine.
1283: ecx_utils.g_event.addparametertolist('PARAMETER1',parameter1);
1284: ecx_utils.g_event.addparametertolist('PARAMETER2',parameter2);

Line 1419: wf_engine.SetItemAttrEvent(itemtype, itemkey, evt_name, ecx_utils.g_event);

1415: i_event.SetEventKey(event_key);
1416: end if;
1417:
1418: -- set the event data back
1419: wf_engine.SetItemAttrEvent(itemtype, itemkey, evt_name, ecx_utils.g_event);
1420:
1421: addItemAttributes(itemtype,itemkey);
1422:
1423: resultout := 'COMPLETE:';

Line 1599: if (funcmode <> wf_engine.eng_run) then

1595: ecx_utils.g_item_key := itemkey;
1596: ecx_utils.g_activity_id := actid;
1597:
1598: -- Do nothing in cancel or timeout mode
1599: if (funcmode <> wf_engine.eng_run) then
1600: resultout := wf_engine.eng_null;
1601: return;
1602: end if;
1603: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');

Line 1600: resultout := wf_engine.eng_null;

1596: ecx_utils.g_activity_id := actid;
1597:
1598: -- Do nothing in cancel or timeout mode
1599: if (funcmode <> wf_engine.eng_run) then
1600: resultout := wf_engine.eng_null;
1601: return;
1602: end if;
1603: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
1604: if (i_map_code is null ) then

Line 1603: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');

1599: if (funcmode <> wf_engine.eng_run) then
1600: resultout := wf_engine.eng_null;
1601: return;
1602: end if;
1603: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
1604: if (i_map_code is null ) then
1605: wf_core.token('ECX_MAP_CODE','NULL');
1606: wf_core.raise('WFSQL_ARGS');
1607: end if;

Line 1610: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');

1606: wf_core.raise('WFSQL_ARGS');
1607: end if;
1608:
1609:
1610: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1611: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1612: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1613: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1614:

Line 1611: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);

1607: end if;
1608:
1609:
1610: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1611: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1612: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1613: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1614:
1615: /* Start changes for bug Bug 2120165 */

Line 1612: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');

1608:
1609:
1610: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1611: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1612: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1613: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1614:
1615: /* Start changes for bug Bug 2120165 */
1616: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');

Line 1613: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');

1609:
1610: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1611: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1612: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1613: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1614:
1615: /* Start changes for bug Bug 2120165 */
1616: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1617: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');

Line 1616: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');

1612: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1613: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1614:
1615: /* Start changes for bug Bug 2120165 */
1616: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1617: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1618: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1619: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1620: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

Line 1617: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');

1613: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1614:
1615: /* Start changes for bug Bug 2120165 */
1616: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1617: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1618: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1619: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1620: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1621:

Line 1618: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');

1614:
1615: /* Start changes for bug Bug 2120165 */
1616: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1617: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1618: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1619: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1620: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1621:
1622: -- Verify that the attr type = EVENT

Line 1619: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');

1615: /* Start changes for bug Bug 2120165 */
1616: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1617: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1618: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1619: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1620: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1621:
1622: -- Verify that the attr type = EVENT
1623:

Line 1620: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

1616: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1617: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1618: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1619: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1620: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1621:
1622: -- Verify that the attr type = EVENT
1623:
1624: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');

Line 1624: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');

1620: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1621:
1622: -- Verify that the attr type = EVENT
1623:
1624: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1625: if ( evt_name is null ) then
1626: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1627: wf_core.raise('WFSQL_ARGS');
1628: end if;

Line 1630: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);

1626: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1627: wf_core.raise('WFSQL_ARGS');
1628: end if;
1629:
1630: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1631: if (atype <> 'EVENT' ) then
1632: wf_core.token('VTYPE',atype);
1633: wf_core.raise('WFXXXV_VTYPE');
1634: end if;

Line 1636: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);

1632: wf_core.token('VTYPE',atype);
1633: wf_core.raise('WFXXXV_VTYPE');
1634: end if;
1635:
1636: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1637:
1638: /**
1639: Populate the Parameters in the original event Object being passed. if it is null , initialize and create
1640: a new Instance and populate the variables

Line 1689: wf_engine.SetItemAttrEvent(itemtype, itemkey, evt_name, ecx_utils.g_event);

1685: i_event.SetEventKey(event_key);
1686: end if;
1687:
1688: -- set the event data back
1689: wf_engine.SetItemAttrEvent(itemtype, itemkey, evt_name, ecx_utils.g_event);
1690:
1691: addItemAttributes(itemtype,itemkey);
1692:
1693: resultout := 'COMPLETE:';

Line 1734: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');

1730: -- RUN mode - normal process execution
1731:
1732: if (funcmode = 'RUN') then
1733:
1734: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');
1735: debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey,'ECX_DEBUG_LEVEL',true),0);
1736:
1737: ecx_inbound_trig.reprocess
1738: (

Line 1735: debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey,'ECX_DEBUG_LEVEL',true),0);

1731:
1732: if (funcmode = 'RUN') then
1733:
1734: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');
1735: debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey,'ECX_DEBUG_LEVEL',true),0);
1736:
1737: ecx_inbound_trig.reprocess
1738: (
1739: i_msgid => message_id,

Line 1746: aname_trigger_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRIGGER_ID',true);

1742: i_retcode => retcode,
1743: i_errbuf => errmsg
1744: );
1745:
1746: aname_trigger_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRIGGER_ID',true);
1747:
1748: if aname_trigger_id is not null
1749: then
1750: wf_engine.SetItemAttrNumber(itemtype,itemkey,aname_trigger_id,trigger_id);

Line 1750: wf_engine.SetItemAttrNumber(itemtype,itemkey,aname_trigger_id,trigger_id);

1746: aname_trigger_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRIGGER_ID',true);
1747:
1748: if aname_trigger_id is not null
1749: then
1750: wf_engine.SetItemAttrNumber(itemtype,itemkey,aname_trigger_id,trigger_id);
1751: end if;
1752:
1753:
1754: addItemAttributes(itemtype,itemkey);

Line 1853: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');

1849: -- RUN mode - normal process execution
1850:
1851: if (funcmode = 'RUN') then
1852:
1853: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');
1854:
1855: ecx_document.resend
1856: (
1857: i_msgid => message_id,