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_ORDER_IMPORT_WF dependencies on WF_ENGINE

Line 47: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_IMPORT

43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;
45: END IF;
46:
47: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_IMPORT
48: , p_itemkey
49: , 'ORG_ID'
50: );
51:

Line 62: l_org_id := wf_engine.GetItemAttrNumber

58:
59: ELSIF (p_funcmode = 'TEST_CTX') THEN
60:
61: /* Delete Following before check
62: l_org_id := wf_engine.GetItemAttrNumber
63: (itemtype => p_itemtype,
64: itemkey => p_itemkey,
65: aname => 'ORG_ID');
66: If l_org_id is Null Then

Line 84: l_parameter1 := wf_engine.GetItemAttrNumber

80:
81:
82:
83: If p_itemtype = G_WFI_ORDER_IMPORT Then
84: l_parameter1 := wf_engine.GetItemAttrNumber
85: (itemtype => p_itemtype,
86: itemkey => p_itemkey,
87: aname => 'PARAMETER1');
88: End If;

Line 93: wf_engine.SetItemAttrText (itemtype => p_itemtype,

89:
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;
92: END IF;
93: wf_engine.SetItemAttrText (itemtype => p_itemtype,
94: itemkey => p_itemkey,
95: aname => 'ORG_ID',
96: avalue => l_parameter1);
97:

Line 165: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO

161:
162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;
164: END IF;
165: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO
166: , p_itemkey
167: , 'ORG_ID'
168: );
169:

Line 183: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO

179: IF l_debug_level > 0 THEN
180: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;
181: END IF;
182:
183: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO
184: , p_itemkey
185: , 'ORG_ID'
186: );
187: IF l_debug_level > 0 THEN

Line 252: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_ACK

248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;
250: END IF;
251:
252: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_ACK
253: , p_itemkey
254: , 'ORG_ID'
255: );
256:

Line 269: l_parameter1 := wf_engine.GetItemAttrNumber

265: ELSIF (p_funcmode = 'TEST_CTX') THEN
266: -- don't need this code because the org id is either passed from the
267: -- OEOI flow or set directly in the function call
268: /*If p_itemtype = G_WFI_ORDER_ACK Then
269: l_parameter1 := wf_engine.GetItemAttrNumber
270: (itemtype => p_itemtype,
271: itemkey => p_itemkey,
272: aname => 'ORG_ID');
273: End If;

Line 278: wf_engine.SetItemAttrText (itemtype => p_itemtype,

274:
275: IF l_debug_level > 0 THEN
276: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;
277: END IF;
278: wf_engine.SetItemAttrText (itemtype => p_itemtype,
279: itemkey => p_itemkey,
280: aname => 'ORG_ID',
281: avalue => l_parameter1);
282: */

Line 283: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_ACK

279: itemkey => p_itemkey,
280: aname => 'ORG_ID',
281: avalue => l_parameter1);
282: */
283: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_ACK
284: , p_itemkey
285: , 'ORG_ID'
286: );
287: IF l_debug_level > 0 THEN

Line 397: wf_engine.SetItemAttrText (itemtype => p_itemtype,

393: End If;
394:
395: p_x_result := G_WFR_COMPLETE;
396:
397: wf_engine.SetItemAttrText (itemtype => p_itemtype,
398: itemkey => p_itemkey,
399: aname => 'OM_DEBUG_LEVEL',
400: avalue => l_debug_level);
401: -- }

Line 505: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype

501: oe_debug_pub.add( 'L_ACTIVITY_ID IS ' || L_ACTIVITY_ID ) ;
502:
503: oe_debug_pub.add( 'L_REQUEST_ID IS ' || L_REQUEST_ID ) ;
504: END IF;
505: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype
506: , itemkey => p_itemkey
507: , aname => 'REQ_ID'
508: );
509: IF l_debug_level > 0 THEN

Line 518: wf_engine.SetItemAttrNumber (itemtype => p_itemtype,

514: Into l_request_id
515: From fnd_concurrent_requests
516: Where parent_request_id = l_request_id;
517:
518: wf_engine.SetItemAttrNumber (itemtype => p_itemtype,
519: itemkey => p_itemkey,
520: aname => 'REQ_ID',
521: avalue => l_request_id);
522: Exception

Line 530: l_orig_sys_document_ref := wf_engine.GetItemAttrText( itemtype => p_itemtype,

526: END IF;
527: l_request_id := Null;
528: End;
529:
530: l_orig_sys_document_ref := wf_engine.GetItemAttrText( itemtype => p_itemtype,
531: itemkey => p_itemkey,
532: aname => 'PARAMETER2'
533: );
534: l_xml_transaction_type_code := wf_engine.GetItemAttrText( itemtype => p_itemtype,

Line 534: l_xml_transaction_type_code := wf_engine.GetItemAttrText( itemtype => p_itemtype,

530: l_orig_sys_document_ref := wf_engine.GetItemAttrText( itemtype => p_itemtype,
531: itemkey => p_itemkey,
532: aname => 'PARAMETER2'
533: );
534: l_xml_transaction_type_code := wf_engine.GetItemAttrText( itemtype => p_itemtype,
535: itemkey => p_itemkey,
536: aname => 'PARAMETER3'
537: );
538:

Line 540: l_sold_to_org_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype,

536: aname => 'PARAMETER3'
537: );
538:
539: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
540: l_sold_to_org_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype,
541: itemkey => p_itemkey,
542: aname => 'PARAMETER4'
543: );
544:

Line 545: l_change_sequence := wf_engine.GetItemAttrText( itemtype => p_itemtype,

541: itemkey => p_itemkey,
542: aname => 'PARAMETER4'
543: );
544:
545: l_change_sequence := wf_engine.GetItemAttrText( itemtype => p_itemtype,
546: itemkey => p_itemkey,
547: aname => 'PARAMETER7'
548: );
549: End If;

Line 599: wf_engine.SetItemAttrText (itemtype => p_itemtype,

595: When OTHERS Then
596: p_x_result := G_WFR_NOT_ELIGIBLE;
597: End;
598:
599: wf_engine.SetItemAttrText (itemtype => p_itemtype,
600: itemkey => p_itemkey,
601: aname => 'ORDER_IMPORTED',
602: avalue => p_x_result);
603:

Line 605: wf_engine.SetItemAttrNumber (itemtype => p_itemtype,

601: aname => 'ORDER_IMPORTED',
602: avalue => p_x_result);
603:
604: If p_x_result = G_WFR_INCOMPLETE Then
605: wf_engine.SetItemAttrNumber (itemtype => p_itemtype,
606: itemkey => p_itemkey,
607: aname => 'REQ_ID',
608: avalue => l_request_id);
609: End If;

Line 640: wf_engine.SetItemAttrText (itemtype => p_itemtype,

636: EXCEPTION
637:
638: WHEN OTHERS THEN
639: p_x_result := G_WFR_NOT_ELIGIBLE;
640: wf_engine.SetItemAttrText (itemtype => p_itemtype,
641: itemkey => p_itemkey,
642: aname => 'ORDER_IMPORTED',
643: avalue => p_x_result);
644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 704: l_start_from_flow := wf_engine.GetItemAttrText( p_itemtype

700: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;
701: END IF;
702: --ecx_debug.g_debug_level := 3;
703: OE_STANDARD_WF.Set_Msg_Context(p_actid);
704: l_start_from_flow := wf_engine.GetItemAttrText( p_itemtype
705: , p_itemkey
706: , 'START_FROM_FLOW'
707: );
708:

Line 709: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype

705: , p_itemkey
706: , 'START_FROM_FLOW'
707: );
708:
709: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype
710: , p_itemkey
711: , 'ORIG_SYS_DOCUMENT_REF'
712: );
713: l_original_transaction_type := wf_engine.GetItemAttrText( p_itemtype

Line 713: l_original_transaction_type := wf_engine.GetItemAttrText( p_itemtype

709: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype
710: , p_itemkey
711: , 'ORIG_SYS_DOCUMENT_REF'
712: );
713: l_original_transaction_type := wf_engine.GetItemAttrText( p_itemtype
714: , p_itemkey
715: , 'PARAMETER3'
716: );
717: -- bug 3561088

Line 721: l_document_id := wf_engine.GetItemAttrNumber( p_itemtype

717: -- bug 3561088
718: -- Note: for OESO, the document id is the item key and this
719: -- assignment is done directly in the workflow
720: If p_itemtype = G_WFI_ORDER_ACK Then
721: l_document_id := wf_engine.GetItemAttrNumber( p_itemtype
722: , p_itemkey
723: , 'PARAMETER5'
724: , TRUE);
725: End If;

Line 729: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype

725: End If;
726: -- end bug 3561088
727:
728: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
729: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype
730: , p_itemkey
731: , 'PARAMETER4'
732: );
733: /* added for the message context setting */

Line 734: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype

730: , p_itemkey
731: , 'PARAMETER4'
732: );
733: /* added for the message context setting */
734: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype
735: , p_itemkey
736: , 'PARAMETER7'
737: , TRUE
738: );

Line 762: l_request_id := wf_engine.GetItemAttrNumber( p_itemtype

758: );
759: -- end bug 3688227
760:
761: If (l_start_from_flow = G_WFI_IMPORT_PGM) Then
762: l_request_id := wf_engine.GetItemAttrNumber( p_itemtype
763: , p_itemkey
764: , 'REQ_ID'
765: );
766: Elsif (l_start_from_flow = G_WFI_ORDER_IMPORT) Then

Line 767: l_request_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_IMPORT

763: , p_itemkey
764: , 'REQ_ID'
765: );
766: Elsif (l_start_from_flow = G_WFI_ORDER_IMPORT) Then
767: l_request_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_IMPORT
768: , p_itemkey
769: , 'REQ_ID'
770: );
771: End If;

Line 798: l_order_imported := wf_engine.GetItemAttrText( G_WFI_ORDER_IMPORT

794: If l_start_from_flow = G_WFI_ORDER_IMPORT Then
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'START FROM FLOW = '|| L_START_FROM_FLOW ) ;
797: END IF;
798: l_order_imported := wf_engine.GetItemAttrText( G_WFI_ORDER_IMPORT
799: , p_itemkey
800: , 'ORDER_IMPORTED'
801: );
802: If l_start_from_flow = G_WFI_ORDER_IMPORT And

Line 829: l_header_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO

825: Elsif l_start_from_flow IN (G_WFI_PROC, G_WFI_CONC_PGM) Then
826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add( 'ELSIF L_START_FROM_FLOW = '|| L_START_FROM_FLOW ) ;
828: END IF;
829: l_header_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO
830: , p_itemkey
831: , 'HEADER_ID'
832: );
833: Elsif l_start_from_flow = Oe_Globals.G_WFI_HDR Then

Line 852: l_order_imported := wf_engine.GetItemAttrText( p_itemtype

848: END IF;
849: l_header_id := p_itemkey;
850: Elsif l_start_from_flow in (G_WFI_IMPORT_PGM, G_WFI_PROC) Then
851: --check if the order is imported.
852: l_order_imported := wf_engine.GetItemAttrText( p_itemtype
853: , p_itemkey
854: , 'ORDER_IMPORTED'
855: );
856: If l_order_imported = 'Y' Then

Line 985: wf_engine.SetItemAttrText (itemtype => p_itemtype,

981: IF l_debug_level > 0 THEN
982: oe_debug_pub.add( 'L_TRANSACTION_SUBTYPE = '||L_TRANSACTION_SUBTYPE ) ;
983: END IF;
984:
985: wf_engine.SetItemAttrText (itemtype => p_itemtype,
986: itemkey => p_itemkey,
987: aname => 'ECX_TRANSACTION_TYPE',
988: avalue => l_transaction_type);
989:

Line 990: wf_engine.SetItemAttrText (itemtype => p_itemtype,

986: itemkey => p_itemkey,
987: aname => 'ECX_TRANSACTION_TYPE',
988: avalue => l_transaction_type);
989:
990: wf_engine.SetItemAttrText (itemtype => p_itemtype,
991: itemkey => p_itemkey,
992: aname => 'ECX_TRANSACTION_SUBTYPE',
993: avalue => l_transaction_subtype);
994:

Line 995: wf_engine.SetItemAttrText (itemtype => p_itemtype,

991: itemkey => p_itemkey,
992: aname => 'ECX_TRANSACTION_SUBTYPE',
993: avalue => l_transaction_subtype);
994:
995: wf_engine.SetItemAttrText (itemtype => p_itemtype,
996: itemkey => p_itemkey,
997: aname => 'ECX_PARTY_ID',
998: avalue => to_char(l_party_id));
999:

Line 1000: wf_engine.SetItemAttrText (itemtype => p_itemtype,

996: itemkey => p_itemkey,
997: aname => 'ECX_PARTY_ID',
998: avalue => to_char(l_party_id));
999:
1000: wf_engine.SetItemAttrText (itemtype => p_itemtype,
1001: itemkey => p_itemkey,
1002: aname => 'ECX_PARTY_SITE_ID',
1003: avalue => to_char(l_party_site_id));
1004:

Line 1006: wf_engine.SetItemAttrText (itemtype => p_itemtype,

1002: aname => 'ECX_PARTY_SITE_ID',
1003: avalue => to_char(l_party_site_id));
1004:
1005:
1006: wf_engine.SetItemAttrText (itemtype => p_itemtype,
1007: itemkey => p_itemkey,
1008: aname => 'ECX_DOCUMENT_ID',
1009: avalue => to_char(l_document_id));
1010:

Line 1011: wf_engine.SetItemAttrText (itemtype => p_itemtype,

1007: itemkey => p_itemkey,
1008: aname => 'ECX_DOCUMENT_ID',
1009: avalue => to_char(l_document_id));
1010:
1011: wf_engine.SetItemAttrText (itemtype => p_itemtype,
1012: itemkey => p_itemkey,
1013: aname => 'ECX_PARAMETER1',
1014: avalue => l_orig_sys_document_ref);
1015:

Line 1016: wf_engine.SetItemAttrText (itemtype => p_itemtype,

1012: itemkey => p_itemkey,
1013: aname => 'ECX_PARAMETER1',
1014: avalue => l_orig_sys_document_ref);
1015:
1016: wf_engine.SetItemAttrText (itemtype => p_itemtype,
1017: itemkey => p_itemkey,
1018: aname => 'ECX_PARAMETER3',
1019: avalue => l_original_transaction_type);
1020:

Line 1023: wf_engine.SetItemAttrText (itemtype => p_itemtype,

1019: avalue => l_original_transaction_type);
1020:
1021:
1022: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1023: wf_engine.SetItemAttrText (itemtype => p_itemtype,
1024: itemkey => p_itemkey,
1025: aname => 'ECX_PARAMETER4',
1026: avalue => to_char(l_sold_to_org_id));
1027:

Line 1030: wf_engine.SetItemAttrText (itemtype => p_itemtype,

1026: avalue => to_char(l_sold_to_org_id));
1027:
1028: --setting putting sequence value in workflow for 3a6/3a7
1029: If p_itemtype = G_WFI_SHOW_SO then
1030: wf_engine.SetItemAttrText (itemtype => p_itemtype,
1031: itemkey => p_itemkey,
1032: aname => 'ECX_PARAMETER5',
1033: avalue => p_itemkey);
1034: End If;

Line 1039: wf_engine.SetItemAttrText (itemtype => p_itemtype,

1035: Else
1036:
1037: --setting putting sequence value in workflow for 3a6/3a7
1038: If p_itemtype = G_WFI_SHOW_SO then
1039: wf_engine.SetItemAttrText (itemtype => p_itemtype,
1040: itemkey => p_itemkey,
1041: aname => 'ECX_PARAMETER4',
1042: avalue => p_itemkey);
1043: End If;

Line 1048: l_parameter2 := wf_engine.GetItemAttrNumber

1044: End If;
1045:
1046: If p_itemtype = G_WFI_ORDER_ACK Then
1047: If (l_start_from_flow = G_WFI_ORDER_IMPORT) Then
1048: l_parameter2 := wf_engine.GetItemAttrNumber
1049: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1050: itemkey => p_itemkey,
1051: aname => 'REQ_ID');
1052: Elsif (l_start_from_flow = G_WFI_IMPORT_PGM) Then

Line 1053: l_parameter2 := wf_engine.GetItemAttrNumber

1049: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1050: itemkey => p_itemkey,
1051: aname => 'REQ_ID');
1052: Elsif (l_start_from_flow = G_WFI_IMPORT_PGM) Then
1053: l_parameter2 := wf_engine.GetItemAttrNumber
1054: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,
1055: itemkey => p_itemkey,
1056: aname => 'REQ_ID');
1057: End If;

Line 1059: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1055: itemkey => p_itemkey,
1056: aname => 'REQ_ID');
1057: End If;
1058:
1059: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1060: itemkey => p_itemkey,
1061: aname => 'ECX_PARAMETER2',
1062: avalue => l_parameter2);
1063:

Line 1170: l_order_imported := wf_engine.GetItemAttrText

1166: End If;
1167:
1168: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1169: If p_itemtype = G_WFI_ORDER_IMPORT Then
1170: l_order_imported := wf_engine.GetItemAttrText
1171: (itemtype => p_itemtype,
1172: itemkey => p_itemkey,
1173: aname => 'ORDER_IMPORTED');
1174:

Line 1179: l_orig_sys_document_ref := wf_engine.GetItemAttrText

1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.add( 'L_ORDER_IMPORTED ' || L_ORDER_IMPORTED ) ;
1177: END IF;
1178:
1179: l_orig_sys_document_ref := wf_engine.GetItemAttrText
1180: (itemtype => p_itemtype,
1181: itemkey => p_itemkey,
1182: aname => 'PARAMETER2');
1183:

Line 1184: l_xml_transaction_type_code := wf_engine.GetItemAttrText

1180: (itemtype => p_itemtype,
1181: itemkey => p_itemkey,
1182: aname => 'PARAMETER2');
1183:
1184: l_xml_transaction_type_code := wf_engine.GetItemAttrText
1185: (itemtype => p_itemtype,
1186: itemkey => p_itemkey,
1187: aname => 'PARAMETER3');
1188:

Line 1190: l_sold_to_org_id := wf_engine.GetItemAttrNumber

1186: itemkey => p_itemkey,
1187: aname => 'PARAMETER3');
1188:
1189: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1190: l_sold_to_org_id := wf_engine.GetItemAttrNumber
1191: (itemtype => p_itemtype,
1192: itemkey => p_itemkey,
1193: aname => 'PARAMETER4');
1194:

Line 1195: l_change_sequence := wf_engine.GetItemAttrText

1191: (itemtype => p_itemtype,
1192: itemkey => p_itemkey,
1193: aname => 'PARAMETER4');
1194:
1195: l_change_sequence := wf_engine.GetItemAttrText
1196: (itemtype => p_itemtype,
1197: itemkey => p_itemkey,
1198: aname => 'PARAMETER7');
1199: End If;

Line 1227: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype

1223: oe_debug_pub.add( 'L_XML_TRANSACTION_TYPE_CODE ' || L_XML_TRANSACTION_TYPE_CODE ) ;
1224: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ' || L_SOLD_TO_ORG_ID ) ;
1225: oe_debug_pub.add( 'L_CHANGE_SEQUENCE ' || L_CHANGE_SEQUENCE ) ;
1226: END IF;
1227: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype
1228: , itemkey => p_itemkey
1229: , aname => 'REQ_ID'
1230: );
1231: IF l_debug_level > 0 THEN

Line 1299: wf_engine.SetItemAttrText (p_itemtype,

1295: IF l_debug_level > 0 THEN
1296: oe_debug_pub.add( 'AFTER CALL TO ISDELIVERY REQ' ) ;
1297: END IF;
1298: IF OE_Code_Control.Get_Code_Release_Level >= '110510' THEN
1299: wf_engine.SetItemAttrText (p_itemtype,
1300: p_itemkey,
1301: 'ECX_PARTY_ID',
1302: l_party_id);
1303: wf_engine.SetItemAttrText (p_itemtype,

Line 1303: wf_engine.SetItemAttrText (p_itemtype,

1299: wf_engine.SetItemAttrText (p_itemtype,
1300: p_itemkey,
1301: 'ECX_PARTY_ID',
1302: l_party_id);
1303: wf_engine.SetItemAttrText (p_itemtype,
1304: p_itemkey,
1305: 'ECX_PARTY_SITE_ID',
1306: l_party_site_id);
1307: END IF;

Line 1395: l_start_from_flow := wf_engine.GetItemAttrText( p_itemtype

1391: oe_debug_pub.add( 'ENTERING OEXWFOI.PROCESS_XML_ACKNOWLEDGMENT_WF' ) ;
1392: END IF;
1393: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1394:
1395: l_start_from_flow := wf_engine.GetItemAttrText( p_itemtype
1396: , p_itemkey
1397: , 'START_FROM_FLOW'
1398: );
1399: IF l_debug_level > 0 THEN

Line 1402: l_transaction_type := wf_engine.GetItemAttrText( p_itemtype

1398: );
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add( 'BEFORE PARAMETER3' ) ;
1401: END IF;
1402: l_transaction_type := wf_engine.GetItemAttrText( p_itemtype
1403: , p_itemkey
1404: , 'PARAMETER3'
1405: );
1406: IF l_debug_level > 0 THEN

Line 1412: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype

1408: END IF;
1409:
1410:
1411: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1412: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype
1413: , p_itemkey
1414: , 'PARAMETER4'
1415: );
1416:

Line 1423: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype

1419: oe_debug_pub.add( 'SOLD_TO_ORG_ID ='|| L_SOLD_TO_ORG_ID ) ;
1420: END IF;
1421:
1422:
1423: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype
1424: , p_itemkey
1425: , 'PARAMETER7'
1426: );
1427:

Line 1442: l_line_id := wf_engine.GetItemAttrNumber( p_itemtype

1438:
1439: oe_debug_pub.add( 'OEXWFOI: P_ITEMKEY IS '||P_ITEMKEY ) ;
1440: END IF;
1441:
1442: l_line_id := wf_engine.GetItemAttrNumber( p_itemtype
1443: , p_itemkey
1444: , 'LINE_ID'
1445: );
1446: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype

Line 1446: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype

1442: l_line_id := wf_engine.GetItemAttrNumber( p_itemtype
1443: , p_itemkey
1444: , 'LINE_ID'
1445: );
1446: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype
1447: , p_itemkey
1448: , 'HEADER_ID'
1449: );
1450:

Line 1452: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype

1448: , 'HEADER_ID'
1449: );
1450:
1451: -- exception management
1452: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype
1453: , p_itemkey
1454: , 'ORIG_SYS_DOCUMENT_REF'
1455: );
1456: -- end exception management

Line 1497: l_request_id := wf_engine.GetItemAttrNumber

1493: x_return_status => l_return_status);
1494: Else
1495:
1496: If l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT then
1497: l_request_id := wf_engine.GetItemAttrNumber
1498: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1499: itemkey => p_itemkey,
1500: aname => 'REQ_ID');
1501: Elsif l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then

Line 1502: l_request_id := wf_engine.GetItemAttrNumber

1498: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1499: itemkey => p_itemkey,
1500: aname => 'REQ_ID');
1501: Elsif l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then
1502: l_request_id := wf_engine.GetItemAttrNumber
1503: (itemtype => p_itemtype,
1504: itemkey => p_itemkey,
1505: aname => 'REQ_ID');
1506: End if;

Line 1513: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype

1509: oe_debug_pub.add( 'REQUEST_ID IN ELSE ='||L_REQUEST_ID ) ;
1510:
1511: oe_debug_pub.add( 'OEXWFOI: P_ITEMTYPE IS '||P_ITEMTYPE ) ;
1512: END IF;
1513: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype
1514: , p_itemkey
1515: , 'ORIG_SYS_DOCUMENT_REF'
1516: );
1517: IF l_debug_level > 0 THEN

Line 1846: l_header_id := wf_engine.GetItemAttrNumber(p_itemtype,

1842: oe_debug_pub.add( 'ENTERING SET_USER_KEY' ) ;
1843: END IF;
1844:
1845: if (p_itemtype = OE_ORDER_IMPORT_WF.G_WFI_SHOW_SO) then
1846: l_header_id := wf_engine.GetItemAttrNumber(p_itemtype,
1847: p_itemkey,
1848: 'HEADER_ID'
1849: );
1850: l_transaction_type := wf_engine.GetItemAttrText(p_itemtype,

Line 1850: l_transaction_type := wf_engine.GetItemAttrText(p_itemtype,

1846: l_header_id := wf_engine.GetItemAttrNumber(p_itemtype,
1847: p_itemkey,
1848: 'HEADER_ID'
1849: );
1850: l_transaction_type := wf_engine.GetItemAttrText(p_itemtype,
1851: p_itemkey,
1852: 'PARAMETER3'
1853: );
1854: begin

Line 1892: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype,

1888: IF l_debug_level > 0 THEN
1889: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;
1890: END IF;
1891: elsif (p_itemtype = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT) then
1892: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype,
1893: p_itemkey,
1894: 'PARAMETER2'
1895: );
1896: l_customer_number := wf_engine.GetItemAttrNumber(p_itemtype,

Line 1896: l_customer_number := wf_engine.GetItemAttrNumber(p_itemtype,

1892: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype,
1893: p_itemkey,
1894: 'PARAMETER2'
1895: );
1896: l_customer_number := wf_engine.GetItemAttrNumber(p_itemtype,
1897: p_itemkey,
1898: 'PARAMETER4'
1899: );
1900: l_transaction_type := wf_engine.GetItemAttrText(p_itemtype,

Line 1900: l_transaction_type := wf_engine.GetItemAttrText(p_itemtype,

1896: l_customer_number := wf_engine.GetItemAttrNumber(p_itemtype,
1897: p_itemkey,
1898: 'PARAMETER4'
1899: );
1900: l_transaction_type := wf_engine.GetItemAttrText(p_itemtype,
1901: p_itemkey,
1902: 'PARAMETER3'
1903: );
1904:

Line 1906: l_change_sequence := wf_engine.GetItemAttrText(p_itemtype,

1902: 'PARAMETER3'
1903: );
1904:
1905: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1906: l_change_sequence := wf_engine.GetItemAttrText(p_itemtype,
1907: p_itemkey,
1908: 'PARAMETER7'
1909: );
1910: -- start exception management

Line 1932: wf_engine.SetItemAttrText (itemtype => p_itemtype,

1928: l_user_key := l_orig_sys_document_ref || ',' || to_char(l_customer_number) || ',' || l_transaction_type;
1929: End If;
1930:
1931:
1932: wf_engine.SetItemAttrText (itemtype => p_itemtype,
1933: itemkey => p_itemkey,
1934: aname => 'USER_KEY',
1935: avalue => l_user_key);
1936:

Line 1942: l_user_key := wf_engine.GetItemAttrText(p_itemtype,

1938: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;
1939: END IF;
1940: else -- now we will just assume that it is always passed in at this point
1941: -- TODO: we may need another else if to handle the ack being called from the conc_pgm or other workflow.
1942: l_user_key := wf_engine.GetItemAttrText(p_itemtype,
1943: p_itemkey,
1944: 'USER_KEY'
1945: );
1946: IF l_debug_level > 0 THEN

Line 1951: wf_engine.SetItemUserKey(itemtype => p_itemtype,

1947: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;
1948: END IF;
1949:
1950: end if;
1951: wf_engine.SetItemUserKey(itemtype => p_itemtype,
1952: itemkey => p_itemkey,
1953: userkey => l_user_key);
1954:
1955:

Line 2017: l_message_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

2013: IF l_debug_level > 0 THEN
2014: oe_debug_pub.add( 'ENTERING IS_CBOD_OUT_REQD' ) ;
2015: END IF;
2016: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2017: l_message_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2018: itemkey => p_itemkey,
2019: aname => 'PARAMETER5');
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add( 'L_MESSAGE_ID : '|| L_MESSAGE_ID ) ;

Line 2126: /* l_event_key_num := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

2122: --
2123: Begin
2124:
2125: IF p_funcmode = 'RUN' THEN
2126: /* l_event_key_num := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2127: itemkey => p_itemkey,
2128: aname => 'PARAMETER5');
2129: */
2130: OE_STANDARD_WF.Set_Msg_Context(p_actid);

Line 2135: wf_engine.SetItemAttrText (itemtype => p_itemtype,

2131: select oe_xml_message_seq_s.nextval
2132: into l_event_key_num
2133: from dual;
2134:
2135: wf_engine.SetItemAttrText (itemtype => p_itemtype,
2136: itemkey => p_itemkey,
2137: aname => 'CBOD_EVENT_KEY',
2138: avalue => to_char(l_event_key_num));
2139: p_x_result := to_char(l_event_key_num);

Line 2249: l_transaction_type_test1 := wf_engine.GetItemAttrText( p_itemtype

2245: END IF;
2246: End If;
2247:
2248:
2249: l_transaction_type_test1 := wf_engine.GetItemAttrText( p_itemtype
2250: , p_itemkey
2251: , 'ECX_TRANSACTION_SUBTYPE'
2252: );
2253:

Line 2254: l_transaction_type_test2 := wf_engine.GetItemAttrText( p_itemtype

2250: , p_itemkey
2251: , 'ECX_TRANSACTION_SUBTYPE'
2252: );
2253:
2254: l_transaction_type_test2 := wf_engine.GetItemAttrText( p_itemtype
2255: , p_itemkey
2256: , 'PARAMETER3'
2257: );
2258:

Line 2274: l_processing_stage := wf_engine.GetActivityAttrText (p_itemtype,

2270: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST1 => ' || L_TRANSACTION_TYPE_TEST1 ) ;
2271: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST2 => ' || L_TRANSACTION_TYPE_TEST2 ) ;
2272: END IF;
2273:
2274: l_processing_stage := wf_engine.GetActivityAttrText (p_itemtype,
2275: p_itemkey,
2276: p_actid,
2277: 'PROCESSING_STAGE',
2278: TRUE);

Line 2284: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype

2280: --setting Orig Sys Document Ref (Partner Document Number) for SSO
2281: If l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO
2282: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO
2283: Then
2284: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype
2285: , p_itemkey
2286: , 'HEADER_ID'
2287: );
2288: -- start bug 3688227

Line 2321: l_xml_message_id := wf_engine.GetItemAttrText( p_itemtype

2317: -- OE_STANDARD_WF.Clear_Msg_Context;
2318: -- end data fix project
2319: End;
2320:
2321: l_xml_message_id := wf_engine.GetItemAttrText( p_itemtype
2322: , p_itemkey
2323: , 'ECX_MSGID_ATTR'
2324: , TRUE
2325: );

Line 2332: l_conc_request_id := wf_engine.GetItemAttrNumber(p_itemtype

2328: -- also get the request id for 3A6 Conc Pgm,
2329: -- don't check for Start From Flow Item Attr because it is
2330: -- unnecessary, request id will be null for non-conc pgm cases
2331: IF l_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_SSO THEN
2332: l_conc_request_id := wf_engine.GetItemAttrNumber(p_itemtype
2333: , p_itemkey
2334: , 'REQ_ID'
2335: , TRUE);
2336: END IF;

Line 2347: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype

2343: (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR
2344: (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)) Then
2345: --setting Orig Sys Document Ref for POI or CPO
2346:
2347: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype
2348: , p_itemkey
2349: , 'PARAMETER2'
2350: );
2351: -- start bug 3688227

Line 2357: l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype

2353: p_orig_sys_document_ref => l_orig_sys_document_ref
2354: );
2355: -- end bug 3688227
2356:
2357: l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype
2358: , p_itemkey
2359: , 'PARAMETER5'
2360: );
2361:

Line 2364: l_conc_request_id := wf_engine.GetItemAttrNumber(p_itemtype

2360: );
2361:
2362: --also get the request id for OI
2363: IF OE_Code_Control.Get_Code_Release_Level >= '110510' THEN
2364: l_conc_request_id := wf_engine.GetItemAttrNumber(p_itemtype
2365: , p_itemkey
2366: , 'REQ_ID'
2367: , TRUE);
2368: IF l_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_CHO THEN

Line 2369: l_response_flag := wf_engine.GetItemAttrText(p_itemtype

2365: , p_itemkey
2366: , 'REQ_ID'
2367: , TRUE);
2368: IF l_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_CHO THEN
2369: l_response_flag := wf_engine.GetItemAttrText(p_itemtype
2370: , p_itemkey
2371: , 'PARAMETER10'
2372: , TRUE);
2373: END IF;

Line 2382: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype

2378: END IF;
2379: Else
2380:
2381: --setting Orig Sys Document Ref for POA and CBODO
2382: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype
2383: , p_itemkey
2384: , 'ORIG_SYS_DOCUMENT_REF'
2385: );
2386: -- start bug 3688227

Line 2392: l_xml_message_id := wf_engine.GetItemAttrText( p_itemtype

2388: p_orig_sys_document_ref => l_orig_sys_document_ref
2389: );
2390: -- end bug 3688227
2391:
2392: l_xml_message_id := wf_engine.GetItemAttrText( p_itemtype
2393: , p_itemkey
2394: , 'ECX_MSGID_ATTR'
2395: , TRUE
2396: );

Line 2406: l_org_id := wf_engine.GetItemAttrNumber ( p_itemtype

2402:
2403:
2404:
2405: IF OE_Code_Control.Get_Code_Release_Level >= '110510' THEN
2406: l_org_id := wf_engine.GetItemAttrNumber ( p_itemtype
2407: , p_itemkey
2408: , 'ORG_ID'
2409: , TRUE
2410: );

Line 2411: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype

2407: , p_itemkey
2408: , 'ORG_ID'
2409: , TRUE
2410: );
2411: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype
2412: , p_itemkey
2413: , 'PARAMETER4'
2414: , TRUE);
2415: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype

Line 2415: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype

2411: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype
2412: , p_itemkey
2413: , 'PARAMETER4'
2414: , TRUE);
2415: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype
2416: , p_itemkey
2417: , 'PARAMETER7'
2418: , TRUE);
2419: -- start bug 3688227

Line 2478: l_failure_ack_flag := wf_engine.GetItemAttrText( p_itemtype

2474: null;
2475:
2476: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA THEN
2477:
2478: l_failure_ack_flag := wf_engine.GetItemAttrText( p_itemtype
2479: , p_itemkey
2480: , 'ORDER_IMPORTED'
2481: );
2482:

Line 2548: l_document_id := wf_engine.GetItemAttrNumber (p_itemtype,

2544: l_document_id := p_itemkey;
2545: l_document_direction := 'OUT';
2546: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO
2547: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA Then
2548: l_document_id := wf_engine.GetItemAttrNumber (p_itemtype,
2549: p_itemkey,
2550: 'PARAMETER5');
2551: l_document_direction := 'OUT';
2552: End If;

Line 2554: l_party_id := to_number(wf_engine.GetItemAttrText (p_itemtype,

2550: 'PARAMETER5');
2551: l_document_direction := 'OUT';
2552: End If;
2553: If l_document_direction = 'OUT' Then
2554: l_party_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2555: p_itemkey,
2556: 'ECX_PARTY_ID'));
2557: l_party_site_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2558: p_itemkey,

Line 2557: l_party_site_id := to_number(wf_engine.GetItemAttrText (p_itemtype,

2553: If l_document_direction = 'OUT' Then
2554: l_party_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2555: p_itemkey,
2556: 'ECX_PARTY_ID'));
2557: l_party_site_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2558: p_itemkey,
2559: 'ECX_PARTY_SITE_ID'));
2560: End If;
2561: END IF;

Line 2565: l_import_mode := wf_engine.GetActivityAttrText (p_itemtype,

2561: END IF;
2562:
2563: --Setting Message Text based on what stage of the inbound/outbound processing we are
2564:
2565: l_import_mode := wf_engine.GetActivityAttrText (p_itemtype,
2566: p_itemkey,
2567: p_actid,
2568: 'IMPORT_MODE',
2569: TRUE);

Line 2610: l_setup_status := wf_engine.GetActivityAttrText (p_itemtype,

2606: l_message_text := fnd_message.get;
2607: l_doc_status := 'ERROR';
2608: ELSIF l_processing_stage = 'OUTBOUND_SENT' THEN
2609:
2610: l_setup_status := wf_engine.GetActivityAttrText (p_itemtype,
2611: p_itemkey,
2612: p_actid,
2613: 'PROCESSING_STATUS',
2614: TRUE);

Line 2652: l_setup_status := wf_engine.GetActivityAttrText (p_itemtype,

2648: End If;
2649: l_doc_status := 'SUCCESS';
2650: ELSIF l_processing_stage = 'OUTBOUND_SETUP' THEN
2651:
2652: l_setup_status := wf_engine.GetActivityAttrText (p_itemtype,
2653: p_itemkey,
2654: p_actid,
2655: 'PROCESSING_STATUS',
2656: TRUE);

Line 2808: l_party_id := to_number(wf_engine.GetItemAttrText (p_itemtype,

2804: -- End of CLN debugs
2805:
2806:
2807:
2808: l_party_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2809: p_itemkey,
2810: 'ECX_PARTY_ID'));
2811: l_party_site_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2812: p_itemkey,

Line 2811: l_party_site_id := to_number(wf_engine.GetItemAttrText (p_itemtype,

2807:
2808: l_party_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2809: p_itemkey,
2810: 'ECX_PARTY_ID'));
2811: l_party_site_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2812: p_itemkey,
2813: 'ECX_PARTY_SITE_ID'));
2814:
2815: SELECT standard_code