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

Line 768: l_org_id := wf_engine.GetItemAttrNumber( p_itemtype

764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;
766: END IF;
767:
768: l_org_id := wf_engine.GetItemAttrNumber( p_itemtype
769: , p_itemkey
770: , 'ORG_ID'
771: );
772:

Line 783: l_org_id := wf_engine.GetItemAttrNumber( p_itemtype

779: p_x_result := 'COMPLETE';
780:
781: ELSIF (p_funcmode = 'TEST_CTX') THEN
782:
783: l_org_id := wf_engine.GetItemAttrNumber( p_itemtype
784: , p_itemkey
785: , 'ORG_ID'
786: );
787:

Line 856: l_subscriber_list := wf_engine.GetItemAttrText( p_itemtype

852:
853:
854: -- for bug 3103495, we screen events based on the subscriber list
855: -- parameter. Null subscriber list is also consumed.
856: l_subscriber_list := wf_engine.GetItemAttrText( p_itemtype
857: , p_itemkey
858: , 'SUBSCRIBER_LIST');
859: IF l_subscriber_list IS NOT NULL AND INSTR(l_subscriber_list,'ONT') = 0 THEN
860: p_x_result := 'COMPLETE:COMPLETE';

Line 867: l_order_source_id := wf_engine.GetItemAttrNumber( p_itemtype

863:
864: -----------------------------------------------------------
865: -- KEY params for history
866: -----------------------------------------------------------
867: l_order_source_id := wf_engine.GetItemAttrNumber( p_itemtype
868: , p_itemkey
869: , 'ORDER_SOURCE_ID');
870:
871: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype

Line 871: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype

867: l_order_source_id := wf_engine.GetItemAttrNumber( p_itemtype
868: , p_itemkey
869: , 'ORDER_SOURCE_ID');
870:
871: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype
872: , p_itemkey
873: , 'SOLD_TO_ORG_ID');
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add('before partner document no');

Line 877: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype

873: , 'SOLD_TO_ORG_ID');
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add('before partner document no');
876: END IF;
877: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype
878: , p_itemkey
879: , 'PARTNER_DOCUMENT_NO');
880: IF l_debug_level > 0 THEN
881: oe_debug_pub.add('before trading partner id');

Line 883: l_transaction_type := wf_engine.GetItemAttrText( p_itemtype

879: , 'PARTNER_DOCUMENT_NO');
880: IF l_debug_level > 0 THEN
881: oe_debug_pub.add('before trading partner id');
882: END IF;
883: l_transaction_type := wf_engine.GetItemAttrText( p_itemtype
884: , p_itemkey
885: , 'XMLG_INTERNAL_TXN_SUBTYPE');
886:
887: IF l_transaction_type IN ('POA','CBODO', 'SSO','CSO', '855','865') THEN

Line 888: l_document_id := wf_engine.GetItemAttrNumber( p_itemtype

884: , p_itemkey
885: , 'XMLG_INTERNAL_TXN_SUBTYPE');
886:
887: IF l_transaction_type IN ('POA','CBODO', 'SSO','CSO', '855','865') THEN
888: l_document_id := wf_engine.GetItemAttrNumber( p_itemtype
889: , p_itemkey
890: , 'XMLG_DOCUMENT_ID');
891: ELSE
892: l_document_id := wf_engine.GetItemAttrNumber( p_itemtype

Line 892: l_document_id := wf_engine.GetItemAttrNumber( p_itemtype

888: l_document_id := wf_engine.GetItemAttrNumber( p_itemtype
889: , p_itemkey
890: , 'XMLG_DOCUMENT_ID');
891: ELSE
892: l_document_id := wf_engine.GetItemAttrNumber( p_itemtype
893: , p_itemkey
894: , 'XMLG_INTERNAL_CONTROL_NUMBER');
895: END IF;
896:

Line 900: l_wf_itemkey := wf_engine.GetItemAttrText ( p_itemtype

896:
897: -----------------------------------------------------------
898: -- NON-KEY params for history
899: -----------------------------------------------------------
900: l_wf_itemkey := wf_engine.GetItemAttrText ( p_itemtype
901: , p_itemkey
902: , 'WF_ITEM_KEY');
903: l_wf_itemtype := wf_engine.GetItemAttrText ( p_itemtype
904: , p_itemkey

Line 903: l_wf_itemtype := wf_engine.GetItemAttrText ( p_itemtype

899: -----------------------------------------------------------
900: l_wf_itemkey := wf_engine.GetItemAttrText ( p_itemtype
901: , p_itemkey
902: , 'WF_ITEM_KEY');
903: l_wf_itemtype := wf_engine.GetItemAttrText ( p_itemtype
904: , p_itemkey
905: , 'WF_ITEM_TYPE');
906:
907: l_org_id := wf_engine.GetItemAttrNumber ( p_itemtype

Line 907: l_org_id := wf_engine.GetItemAttrNumber ( p_itemtype

903: l_wf_itemtype := wf_engine.GetItemAttrText ( p_itemtype
904: , p_itemkey
905: , 'WF_ITEM_TYPE');
906:
907: l_org_id := wf_engine.GetItemAttrNumber ( p_itemtype
908: , p_itemkey
909: , 'ORG_ID');
910: IF l_debug_level > 0 THEN
911: oe_debug_pub.add('after org id');

Line 923: l_order_number := wf_engine.GetItemAttrNumber( p_itemtype

919: oe_debug_pub.add('set org to :'||l_org_id);
920: END IF;
921: END IF;
922:
923: l_order_number := wf_engine.GetItemAttrNumber( p_itemtype
924: , p_itemkey
925: , 'DOCUMENT_NO');
926: l_order_type_id := wf_engine.GetItemAttrNumber( p_itemtype
927: , p_itemkey

Line 926: l_order_type_id := wf_engine.GetItemAttrNumber( p_itemtype

922:
923: l_order_number := wf_engine.GetItemAttrNumber( p_itemtype
924: , p_itemkey
925: , 'DOCUMENT_NO');
926: l_order_type_id := wf_engine.GetItemAttrNumber( p_itemtype
927: , p_itemkey
928: , 'ORDER_TYPE_ID');
929:
930: IF l_order_number IS NULL THEN

Line 935: l_status := wf_engine.GetItemAttrText( p_itemtype

931: IF l_debug_level > 0 THEN
932: oe_debug_pub.add('order number is null');
933: END IF;
934: END IF;
935: l_status := wf_engine.GetItemAttrText( p_itemtype
936: , p_itemkey
937: , 'ONT_DOC_STATUS');
938: l_message_text := wf_engine.GetItemAttrText( p_itemtype
939: , p_itemkey

Line 938: l_message_text := wf_engine.GetItemAttrText( p_itemtype

934: END IF;
935: l_status := wf_engine.GetItemAttrText( p_itemtype
936: , p_itemkey
937: , 'ONT_DOC_STATUS');
938: l_message_text := wf_engine.GetItemAttrText( p_itemtype
939: , p_itemkey
940: , 'MESSAGE_TEXT');
941: l_processing := wf_engine.GetItemAttrText( p_itemtype
942: , p_itemkey

Line 941: l_processing := wf_engine.GetItemAttrText( p_itemtype

937: , 'ONT_DOC_STATUS');
938: l_message_text := wf_engine.GetItemAttrText( p_itemtype
939: , p_itemkey
940: , 'MESSAGE_TEXT');
941: l_processing := wf_engine.GetItemAttrText( p_itemtype
942: , p_itemkey
943: , 'PROCESSING_STAGE');
944: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype
945: , p_itemkey

Line 944: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype

940: , 'MESSAGE_TEXT');
941: l_processing := wf_engine.GetItemAttrText( p_itemtype
942: , p_itemkey
943: , 'PROCESSING_STAGE');
944: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype
945: , p_itemkey
946: , 'DOCUMENT_REVISION_NO');
947: l_request_id := wf_engine.GetItemAttrNumber( p_itemtype
948: , p_itemkey

Line 947: l_request_id := wf_engine.GetItemAttrNumber( p_itemtype

943: , 'PROCESSING_STAGE');
944: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype
945: , p_itemkey
946: , 'DOCUMENT_REVISION_NO');
947: l_request_id := wf_engine.GetItemAttrNumber( p_itemtype
948: , p_itemkey
949: , 'CONC_REQUEST_ID');
950: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype
951: , p_itemkey

Line 950: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype

946: , 'DOCUMENT_REVISION_NO');
947: l_request_id := wf_engine.GetItemAttrNumber( p_itemtype
948: , p_itemkey
949: , 'CONC_REQUEST_ID');
950: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype
951: , p_itemkey
952: , 'HEADER_ID');
953: l_response_flag := wf_engine.GetItemAttrText( p_itemtype
954: , p_itemkey

Line 953: l_response_flag := wf_engine.GetItemAttrText( p_itemtype

949: , 'CONC_REQUEST_ID');
950: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype
951: , p_itemkey
952: , 'HEADER_ID');
953: l_response_flag := wf_engine.GetItemAttrText( p_itemtype
954: , p_itemkey
955: , 'RESPONSE_FLAG');
956: l_order_processed_flag := wf_engine.GetItemAttrText (p_itemtype
957: , p_itemkey

Line 956: l_order_processed_flag := wf_engine.GetItemAttrText (p_itemtype

952: , 'HEADER_ID');
953: l_response_flag := wf_engine.GetItemAttrText( p_itemtype
954: , p_itemkey
955: , 'RESPONSE_FLAG');
956: l_order_processed_flag := wf_engine.GetItemAttrText (p_itemtype
957: , p_itemkey
958: , 'ORDER_PROCESSED_FLAG'
959: , true);
960: -- Bug 4179657

Line 1078: wf_engine.SetItemUserKey (p_itemtype,

1074: x_return_status => l_result
1075: );
1076: END IF;
1077: END IF;
1078: wf_engine.SetItemUserKey (p_itemtype,
1079: p_itemkey,
1080: l_order_source_id||','||l_sold_to_org_id||','||l_orig_sys_document_ref
1081: ||','||l_transaction_type||','||l_processing);
1082: