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.ECX_STANDARD dependencies on WF_ENGINE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 637: resultout := wf_engine.eng_null;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 723: resultout := wf_engine.eng_null;

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

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

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

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

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

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

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

Line 758: resultout := wf_engine.eng_notified;

754:
755: /*bug16442475: Returning status to notified and will set to complete from java*/
756: if ECX_UTIL_API.isInJavaProcessEnabled then
757: ecx_utils.g_from_processxml := false;
758: resultout := wf_engine.eng_notified;
759: else
760: addItemAttributes(itemtype,itemkey);
761: resultout := 'COMPLETE:';
762: end if;

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

804: ecx_utils.g_activity_id := actid;
805:
806: -- Do nothing in cancel or timeout mode
807:
808: if (funcmode <> wf_engine.eng_run) then
809: resultout := wf_engine.eng_null;
810: return;
811: end if;
812:

Line 809: resultout := wf_engine.eng_null;

805:
806: -- Do nothing in cancel or timeout mode
807:
808: if (funcmode <> wf_engine.eng_run) then
809: resultout := wf_engine.eng_null;
810: return;
811: end if;
812:
813: -- Retreive Activity Attributes

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

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

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

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

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

823: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
824: wf_core.raise('WFSQL_ARGS');
825: end if;
826:
827: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
828: if ( party_site_id is null ) then
829: wf_core.token('ECX_PARTY_SITE_ID','NULL');
830: wf_core.raise('WFSQL_ARGS');
831: end if;

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

831: end if;
832:
833: -- party_id is optional. Only party_site_id is required
834:
835: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
836: /* Start of bug #2183619 */
837: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);
838: /* End of bug #2183619*/
839:

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

833: -- party_id is optional. Only party_site_id is required
834:
835: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
836: /* Start of bug #2183619 */
837: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);
838: /* End of bug #2183619*/
839:
840: /* Start of changes for Bug #2215677*/
841: -- Get confirmation status of the trading partner.

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

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

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

849: i_party_site_id => party_site_id,
850: i_party_type => party_type,
851: o_confirmation => i_confirmation
852: );
853: wf_engine.SetItemAttrText ( itemtype => itemtype,
854: itemkey => itemkey,
855: aname => aname,
856: avalue => i_confirmation);
857: end if;

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

963: ecx_utils.g_item_key := itemkey;
964: ecx_utils.g_activity_id := actid;
965:
966: -- Do nothing in cancel or timeout mode
967: if (funcmode <> wf_engine.eng_run) then
968: resultout := wf_engine.eng_null;
969: return;
970: end if;
971:

Line 968: resultout := wf_engine.eng_null;

964: ecx_utils.g_activity_id := actid;
965:
966: -- Do nothing in cancel or timeout mode
967: if (funcmode <> wf_engine.eng_run) then
968: resultout := wf_engine.eng_null;
969: return;
970: end if;
971:
972: -- We need to determine which parameters are required and which are optional

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

970: end if;
971:
972: -- We need to determine which parameters are required and which are optional
973:
974: transaction_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_TYPE');
975: if ( transaction_type is null ) then
976: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
977: wf_core.raise('WFSQL_ARGS');
978: end if;

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

976: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
977: wf_core.raise('WFSQL_ARGS');
978: end if;
979:
980: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
981: if ( transaction_subtype is null ) then
982: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
983: wf_core.raise('WFSQL_ARGS');
984: end if;

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

982: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
983: wf_core.raise('WFSQL_ARGS');
984: end if;
985:
986: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
987: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
988: then
989: if ( party_site_id is null )
990: then

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

994: end if;
995:
996: -- party_id is optional. Only party_site_id is required
997:
998: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
999: /* Start of bug #2183619 */
1000: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', ignore_notfound => true);
1001:
1002: /* End of bug #2183619 */

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

996: -- party_id is optional. Only party_site_id is required
997:
998: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
999: /* Start of bug #2183619 */
1000: party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', ignore_notfound => true);
1001:
1002: /* End of bug #2183619 */
1003:
1004: -- It is an optional Field

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

1001:
1002: /* End of bug #2183619 */
1003:
1004: -- It is an optional Field
1005: document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1006: /**
1007: if ( document_id is null ) then
1008: wf_core.token('ECX_DOCUMENT_ID','NULL');
1009: wf_core.raise('WFSQL_ARGS');

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

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

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

1017: **/
1018: begin
1019: -- Initialize the Event before using it.
1020: wf_event_t.initialize(ecx_utils.g_event);
1021: ecx_utils.g_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey,'ECX_EVENT_MESSAGE');
1022: exception
1023: when others then
1024: if ecx_utils.g_event is null
1025: then

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

1028: end;
1029:
1030:
1031: /* Start of changes for bug 2120165 */
1032: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1033: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1034: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1035: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1036: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

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

1029:
1030:
1031: /* Start of changes for bug 2120165 */
1032: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1033: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1034: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1035: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1036: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1037: /* End of changes for bug 2120165*/

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

1030:
1031: /* Start of changes for bug 2120165 */
1032: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1033: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1034: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1035: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1036: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1037: /* End of changes for bug 2120165*/
1038:

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

1031: /* Start of changes for bug 2120165 */
1032: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1033: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1034: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1035: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1036: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1037: /* End of changes for bug 2120165*/
1038:
1039: -- Add the above Parameters to the Global Event Message Object

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

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

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

1044: ecx_utils.g_event.addparametertolist('PARAMETER4',parameter4);
1045: ecx_utils.g_event.addparametertolist('PARAMETER5',parameter5);
1046:
1047:
1048: send_mode := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_SEND_MODE');
1049:
1050: wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);
1051:
1052: -- KH comment: There is a more efficient way of doing this. The execution test

Line 1055: if (result = wf_engine.eng_null)

1051:
1052: -- KH comment: There is a more efficient way of doing this. The execution test
1053: -- Should come before any attributes are retrived
1054:
1055: if (result = wf_engine.eng_null)
1056: then
1057: -- Second execution.
1058: -- Wait is completed, return complete result.
1059: -- Call the XML gateway Outbound Engine

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

1069: debug_mode => debug_mode,
1070: i_msgid => msgid
1071: );
1072:
1073: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');
1074: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1075:
1076: addItemAttributes(itemtype,itemkey);
1077:

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

1070: i_msgid => msgid
1071: );
1072:
1073: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');
1074: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1075:
1076: addItemAttributes(itemtype,itemkey);
1077:
1078: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

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

1074: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1075:
1076: addItemAttributes(itemtype,itemkey);
1077:
1078: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1079: else
1080: -- First execution.
1081: -- Check for A-synch or Synch Mode
1082: if ( send_mode = 'ASYNCH')

Line 1085: resultout := wf_engine.eng_deferred;

1081: -- Check for A-synch or Synch Mode
1082: if ( send_mode = 'ASYNCH')
1083: then
1084: -- If Async , deffer the executio
1085: resultout := wf_engine.eng_deferred;
1086: elsif ( ( send_mode is null ) or ( send_mode = 'SYNCH' ) )
1087: then
1088: -- Call the XML gateway Outbound Engine
1089: -- added party_type with bug #2183619

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

1098: debug_mode => debug_mode,
1099: i_msgid => msgid
1100: );
1101:
1102: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');
1103: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1104:
1105: addItemAttributes(itemtype,itemkey);
1106:

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

1099: i_msgid => msgid
1100: );
1101:
1102: aname := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID_ATTR');
1103: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1104:
1105: addItemAttributes(itemtype,itemkey);
1106:
1107: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

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

1103: wf_engine.SetItemAttrText(itemtype,itemkey,aname,msgid);
1104:
1105: addItemAttributes(itemtype,itemkey);
1106:
1107: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1108: end if;
1109: end if;
1110:
1111: exception

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

1199: ecx_utils.g_item_key := itemkey;
1200: ecx_utils.g_activity_id := actid;
1201:
1202: -- Do nothing in cancel or timeout mode
1203: if (funcmode <> wf_engine.eng_run) then
1204: resultout := wf_engine.eng_null;
1205: return;
1206: end if;
1207:

Line 1204: resultout := wf_engine.eng_null;

1200: ecx_utils.g_activity_id := actid;
1201:
1202: -- Do nothing in cancel or timeout mode
1203: if (funcmode <> wf_engine.eng_run) then
1204: resultout := wf_engine.eng_null;
1205: return;
1206: end if;
1207:
1208:

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

1205: return;
1206: end if;
1207:
1208:
1209: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1210:
1211:
1212: -- Retreive Activity Attributes
1213:

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

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

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

1216: wf_core.token('ECX_TRANSACTION_TYPE','NULL');
1217: wf_core.raise('WFSQL_ARGS');
1218: end if;
1219:
1220: transaction_subtype := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_TRANSACTION_SUBTYPE');
1221: if ( transaction_subtype is null ) then
1222: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
1223: wf_core.raise('WFSQL_ARGS');
1224: end if;

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

1222: wf_core.token('ECX_TRANSACTION_SUBTYPE','NULL');
1223: wf_core.raise('WFSQL_ARGS');
1224: end if;
1225:
1226: party_site_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_SITE_ID');
1227:
1228: if ( transaction_type <> 'ECX' and transaction_subtype <> 'CBODO' )
1229: then
1230: if ( party_site_id is null ) then

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

1234: end if;
1235:
1236: -- party_id is optional. Only party_site_id is required
1237:
1238: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
1239:
1240: /* Start of bug #2183619 */
1241:
1242: p_party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);

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

1238: party_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_PARTY_ID');
1239:
1240: /* Start of bug #2183619 */
1241:
1242: p_party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);
1243:
1244: /* End of bug #2183619*/
1245:
1246: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');

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

1242: p_party_type := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARTY_TYPE', true);
1243:
1244: /* End of bug #2183619*/
1245:
1246: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1247:
1248:
1249: -- Verify that the attr type = EVENT
1250:

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

1247:
1248:
1249: -- Verify that the attr type = EVENT
1250:
1251: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1252: if ( evt_name is null ) then
1253: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1254: wf_core.raise('WFSQL_ARGS');
1255: end if;

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

1253: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1254: wf_core.raise('WFSQL_ARGS');
1255: end if;
1256:
1257: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1258: if (atype <> 'EVENT' ) then
1259: wf_core.token('VTYPE',atype);
1260: wf_core.raise('WFXXXV_VTYPE');
1261: end if;

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

1259: wf_core.token('VTYPE',atype);
1260: wf_core.raise('WFXXXV_VTYPE');
1261: end if;
1262:
1263: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1264: /**
1265: Populate the Parameters in the original event Object being passed. if it is null , initialize and create
1266: a new Instance and populate the variables
1267: if i_event is null

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

1278: then
1279: ecx_utils.g_event := i_event;
1280: End If;
1281:
1282: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1283: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1284: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1285: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1286: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

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

1279: ecx_utils.g_event := i_event;
1280: End If;
1281:
1282: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1283: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1284: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1285: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1286: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1287: -- Add the above Parameters to the Global Event Message Object

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

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

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

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

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

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

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

1421: i_event.SetEventKey(event_key);
1422: end if;
1423:
1424: -- set the event data back
1425: wf_engine.SetItemAttrEvent(itemtype, itemkey, evt_name, ecx_utils.g_event);
1426:
1427: addItemAttributes(itemtype,itemkey);
1428:
1429: resultout := 'COMPLETE:';

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

1601: ecx_utils.g_item_key := itemkey;
1602: ecx_utils.g_activity_id := actid;
1603:
1604: -- Do nothing in cancel or timeout mode
1605: if (funcmode <> wf_engine.eng_run) then
1606: resultout := wf_engine.eng_null;
1607: return;
1608: end if;
1609: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');

Line 1606: resultout := wf_engine.eng_null;

1602: ecx_utils.g_activity_id := actid;
1603:
1604: -- Do nothing in cancel or timeout mode
1605: if (funcmode <> wf_engine.eng_run) then
1606: resultout := wf_engine.eng_null;
1607: return;
1608: end if;
1609: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
1610: if (i_map_code is null ) then

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

1605: if (funcmode <> wf_engine.eng_run) then
1606: resultout := wf_engine.eng_null;
1607: return;
1608: end if;
1609: i_map_code := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MAP_CODE');
1610: if (i_map_code is null ) then
1611: wf_core.token('ECX_MAP_CODE','NULL');
1612: wf_core.raise('WFSQL_ARGS');
1613: end if;

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

1612: wf_core.raise('WFSQL_ARGS');
1613: end if;
1614:
1615:
1616: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1617: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1618: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1619: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1620:

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

1613: end if;
1614:
1615:
1616: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1617: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1618: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1619: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1620:
1621: /* Start changes for bug Bug 2120165 */

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

1614:
1615:
1616: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1617: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1618: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1619: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1620:
1621: /* Start changes for bug Bug 2120165 */
1622: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');

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

1615:
1616: document_id := Wf_Engine.GetActivityAttrTEXT(itemtype, itemkey, actid, 'ECX_DOCUMENT_ID');
1617: i_debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey, 'ECX_DEBUG_LEVEL',true),0);
1618: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1619: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1620:
1621: /* Start changes for bug Bug 2120165 */
1622: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1623: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');

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

1618: event_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_NAME');
1619: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1620:
1621: /* Start changes for bug Bug 2120165 */
1622: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1623: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1624: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1625: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1626: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');

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

1619: event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_EVENT_KEY');
1620:
1621: /* Start changes for bug Bug 2120165 */
1622: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1623: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1624: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1625: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1626: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1627:

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

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

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

1621: /* Start changes for bug Bug 2120165 */
1622: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1623: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1624: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1625: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1626: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1627:
1628: -- Verify that the attr type = EVENT
1629:

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

1622: parameter1 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER1');
1623: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER2');
1624: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER3');
1625: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER4');
1626: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1627:
1628: -- Verify that the attr type = EVENT
1629:
1630: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');

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

1626: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'ECX_PARAMETER5');
1627:
1628: -- Verify that the attr type = EVENT
1629:
1630: evt_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_EVENT_MESSAGE');
1631: if ( evt_name is null ) then
1632: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1633: wf_core.raise('WFSQL_ARGS');
1634: end if;

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

1632: wf_core.token('ECX_EVENT_MESSAGE','NULL');
1633: wf_core.raise('WFSQL_ARGS');
1634: end if;
1635:
1636: Wf_Engine.GetItemAttrInfo(itemtype, evt_name ,atype, asubtype, aformat);
1637: if (atype <> 'EVENT' ) then
1638: wf_core.token('VTYPE',atype);
1639: wf_core.raise('WFXXXV_VTYPE');
1640: end if;

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

1638: wf_core.token('VTYPE',atype);
1639: wf_core.raise('WFXXXV_VTYPE');
1640: end if;
1641:
1642: i_event := Wf_Engine.GetItemAttrEvent(itemtype, itemkey, evt_name);
1643:
1644: /**
1645: Populate the Parameters in the original event Object being passed. if it is null , initialize and create
1646: a new Instance and populate the variables

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

1691: i_event.SetEventKey(event_key);
1692: end if;
1693:
1694: -- set the event data back
1695: wf_engine.SetItemAttrEvent(itemtype, itemkey, evt_name, ecx_utils.g_event);
1696:
1697: addItemAttributes(itemtype,itemkey);
1698:
1699: resultout := 'COMPLETE:';

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

1736: -- RUN mode - normal process execution
1737:
1738: if (funcmode = 'RUN') then
1739:
1740: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');
1741: debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey,'ECX_DEBUG_LEVEL',true),0);
1742:
1743: ecx_inbound_trig.reprocess
1744: (

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

1737:
1738: if (funcmode = 'RUN') then
1739:
1740: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');
1741: debug_level := nvl(Wf_Engine.GetItemAttrText(itemtype, itemkey,'ECX_DEBUG_LEVEL',true),0);
1742:
1743: ecx_inbound_trig.reprocess
1744: (
1745: i_msgid => message_id,

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

1748: i_retcode => retcode,
1749: i_errbuf => errmsg
1750: );
1751:
1752: aname_trigger_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRIGGER_ID',true);
1753:
1754: if aname_trigger_id is not null
1755: then
1756: wf_engine.SetItemAttrNumber(itemtype,itemkey,aname_trigger_id,trigger_id);

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

1752: aname_trigger_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRIGGER_ID',true);
1753:
1754: if aname_trigger_id is not null
1755: then
1756: wf_engine.SetItemAttrNumber(itemtype,itemkey,aname_trigger_id,trigger_id);
1757: end if;
1758:
1759:
1760: addItemAttributes(itemtype,itemkey);

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

1855: -- RUN mode - normal process execution
1856:
1857: if (funcmode = 'RUN') then
1858:
1859: message_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'ECX_MSGID');
1860:
1861: ecx_document.resend
1862: (
1863: i_msgid => message_id,