DBA Data[Home] [Help]

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 1847: l_header_id := wf_engine.GetItemAttrNumber(p_itemtype,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2250: l_transaction_type_test1 := wf_engine.GetItemAttrText( p_itemtype

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

Line 2255: l_transaction_type_test2 := wf_engine.GetItemAttrText( p_itemtype

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

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

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

Line 2285: l_header_id := wf_engine.GetItemAttrNumber( p_itemtype

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

Line 2322: l_xml_message_id := wf_engine.GetItemAttrText( p_itemtype

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

Line 2333: l_conc_request_id := wf_engine.GetItemAttrNumber(p_itemtype

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

Line 2348: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype

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

Line 2358: l_internal_control_number := wf_engine.GetItemAttrNumber( p_itemtype

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

Line 2365: l_conc_request_id := wf_engine.GetItemAttrNumber(p_itemtype

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

Line 2370: l_response_flag := wf_engine.GetItemAttrText(p_itemtype

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

Line 2383: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype

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

Line 2393: l_xml_message_id := wf_engine.GetItemAttrText( p_itemtype

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

Line 2407: l_org_id := wf_engine.GetItemAttrNumber ( p_itemtype

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

Line 2412: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype

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

Line 2416: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype

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

Line 2479: l_failure_ack_flag := wf_engine.GetItemAttrText( p_itemtype

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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