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 OE_ACKNOWLEDGMENT_PUB

Line 563: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

559: p_entity_code => 'ELECMSG_'||p_itemtype
560: ,p_entity_id => p_itemkey
561: ,p_header_id => null
562: ,p_line_id => null
563: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
564: ,p_orig_sys_document_ref => l_orig_sys_document_ref
565: ,p_orig_sys_document_line_ref => null
566: ,p_orig_sys_shipment_ref => null
567: ,p_change_sequence => l_change_sequence

Line 748: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

744: ,p_entity_ref => null
745: ,p_entity_id => p_itemkey
746: ,p_header_id => null
747: ,p_line_id => null
748: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
749: ,p_orig_sys_document_ref => l_orig_sys_document_ref
750: ,p_change_sequence => l_change_sequence
751: ,p_orig_sys_document_line_ref => null
752: ,p_orig_sys_shipment_ref => null

Line 807: l_header_id := Oe_Acknowledgment_Pub.get_header_id

803: l_order_imported = G_WFR_COMPLETE Then
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'START FROM FLOW IS OEOI AND IMPORT COMPLETE' ) ;
806: END IF;
807: l_header_id := Oe_Acknowledgment_Pub.get_header_id
808: ( p_orig_sys_document_ref => l_orig_sys_document_ref,
809: p_line_id => Null,
810: p_sold_to_org_id => l_sold_to_org_id);
811: End If;

Line 821: l_header_id := Oe_Acknowledgment_Pub.get_header_id

817: If l_start_from_flow = Oe_Globals.G_WFI_LIN Then
818: IF l_debug_level > 0 THEN
819: oe_debug_pub.add( 'ELSIF L_START_FROM_FLOW = '|| L_START_FROM_FLOW ) ;
820: END IF;
821: l_header_id := Oe_Acknowledgment_Pub.get_header_id
822: ( p_orig_sys_document_ref => Null,
823: p_line_id => p_itemkey,
824: p_sold_to_org_id => l_sold_to_org_id);
825: Elsif l_start_from_flow IN (G_WFI_PROC, G_WFI_CONC_PGM) Then

Line 862: l_header_id := Oe_Acknowledgment_Pub.get_header_id

858:
859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'START FROM FLOW IS OEXVIMPB.PLS' ) ;
861: END IF;
862: l_header_id := Oe_Acknowledgment_Pub.get_header_id
863: ( p_orig_sys_document_ref => l_orig_sys_document_ref,
864: p_line_id => Null,
865: p_sold_to_org_id => l_sold_to_org_id);
866: Else

Line 900: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;

896: from oe_headers_interface
897: where orig_sys_document_ref = l_orig_sys_document_ref
898: And xml_transaction_type_code = l_xml_transaction_type_code
899: And request_id = l_request_id
900: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add( 'SOLD_TO_ORG_ID IN IF => ' || L_PARTY_ID ) ;
903: END IF;
904: Else

Line 912: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;

908: Select header_id, sold_to_org_id
909: Into l_header_id, l_party_id
910: From oe_order_headers
911: Where header_id = l_header_id
912: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
913: IF l_debug_level > 0 THEN
914: oe_debug_pub.add( 'HEADER_ID IN ELSIF =>' || L_HEADER_ID ) ;
915:
916: oe_debug_pub.add( 'XML_MESSAGE_ID IN ELSIF =>' || L_DOCUMENT_ID ) ;

Line 971: l_transaction_type := Oe_Acknowledgment_Pub.G_TRANSACTION_TYPE;

967:
968: IF l_debug_level > 0 THEN
969: oe_debug_pub.add( 'AFTER SELECT FOR THE ACCOUNT SITE AND PARTY ID AND PARTY_SITE_ID' || L_CUST_ACCT_SITE_ID || ' & ' || L_PARTY_ID || ' & ' || L_PARTY_SITE_ID ) ;
970: END IF;
971: l_transaction_type := Oe_Acknowledgment_Pub.G_TRANSACTION_TYPE;
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add( 'L_TRANSACTION_TYPE = '||L_TRANSACTION_TYPE ) ;
974: END IF;
975:

Line 977: l_transaction_subtype := l_original_transaction_type; --Oe_Acknowledgment_Pub.G_TRANSACTION_SSO;

973: oe_debug_pub.add( 'L_TRANSACTION_TYPE = '||L_TRANSACTION_TYPE ) ;
974: END IF;
975:
976: If p_itemtype = G_WFI_SHOW_SO Then
977: l_transaction_subtype := l_original_transaction_type; --Oe_Acknowledgment_Pub.G_TRANSACTION_SSO;
978: Elsif p_itemtype = G_WFI_ORDER_ACK Then
979: l_transaction_subtype := Oe_Acknowledgment_Pub.G_TRANSACTION_POA;
980: End If;
981: IF l_debug_level > 0 THEN

Line 979: l_transaction_subtype := Oe_Acknowledgment_Pub.G_TRANSACTION_POA;

975:
976: If p_itemtype = G_WFI_SHOW_SO Then
977: l_transaction_subtype := l_original_transaction_type; --Oe_Acknowledgment_Pub.G_TRANSACTION_SSO;
978: Elsif p_itemtype = G_WFI_ORDER_ACK Then
979: l_transaction_subtype := Oe_Acknowledgment_Pub.G_TRANSACTION_POA;
980: End If;
981: IF l_debug_level > 0 THEN
982: oe_debug_pub.add( 'L_TRANSACTION_SUBTYPE = '||L_TRANSACTION_SUBTYPE ) ;
983: END IF;

Line 1208: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

1204: ,p_entity_ref => null
1205: ,p_entity_id => p_itemkey
1206: ,p_header_id => null
1207: ,p_line_id => null
1208: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
1209: ,p_orig_sys_document_ref => l_orig_sys_document_ref
1210: ,p_change_sequence => l_change_sequence
1211: ,p_orig_sys_document_line_ref => null
1212: ,p_orig_sys_shipment_ref => null

Line 1239: Where order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID

1235:
1236: Select header_id, xml_message_id, sold_to_org_id, ship_to_org_id
1237: Into l_header_id, l_document_id, l_party_id, l_party_site_id
1238: From oe_order_headers
1239: Where order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
1240: And orig_sys_document_ref = l_orig_sys_document_ref
1241: And decode(l_customer_key_profile, 'Y',
1242: nvl(sold_to_org_id, -999), 1)
1243: = decode(l_customer_key_profile, 'Y',

Line 1251: where order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID

1247: -- check the usage of the ship_to_org_id
1248: Select xml_message_id, sold_to_org_id, ship_to_org_id
1249: into l_document_id, l_party_id, l_party_site_id
1250: from oe_headers_interface
1251: where order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
1252: And orig_sys_document_ref = l_orig_sys_document_ref
1253: And decode(l_customer_key_profile, 'Y',
1254: nvl(sold_to_org_id, -999), 1)
1255: = decode(l_customer_key_profile, 'Y',

Line 1269: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;

1265: Select header_id, xml_message_id, sold_to_org_id, ship_to_org_id
1266: Into l_header_id, l_document_id, l_party_id, l_party_site_id
1267: From oe_order_headers
1268: Where header_id = p_itemkey
1269: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
1270: End If;
1271:
1272: -- start exception management
1273: If l_header_id is not null then

Line 1285: OE_Acknowledgment_Pub.Is_Delivery_Required

1281: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1282: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1283: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1284: END IF;
1285: OE_Acknowledgment_Pub.Is_Delivery_Required
1286: (
1287: p_customer_id => l_party_id,
1288: p_transaction_type => l_transaction_type,
1289: p_transaction_subtype => l_transaction_subtype,

Line 1464: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

1460: ,p_entity_ref => null
1461: ,p_entity_id => p_itemkey
1462: ,p_header_id => l_header_id
1463: ,p_line_id => null
1464: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
1465: ,p_orig_sys_document_ref => l_orig_sys_document_ref
1466: ,p_change_sequence => l_change_sequence
1467: ,p_orig_sys_document_line_ref => null
1468: ,p_orig_sys_shipment_ref => null

Line 1483: OE_Acknowledgment_Pub.Process_Xml_Acknowledgment(

1479: oe_debug_pub.add( 'OEXWFOIB: RETRIEVING HEADER_ID....HEADER_ID IS '||L_HEADER_ID ) ;
1480: END IF;
1481:
1482:
1483: OE_Acknowledgment_Pub.Process_Xml_Acknowledgment(
1484: p_orig_sys_document_ref => p_itemkey,
1485: p_itemtype => p_itemtype,
1486: p_start_from_flow => l_start_from_flow,
1487: p_transaction_type => l_transaction_type,

Line 1528: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

1524: ,p_entity_ref => null
1525: ,p_entity_id => p_itemkey
1526: ,p_header_id => null
1527: ,p_line_id => null
1528: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
1529: ,p_orig_sys_document_ref => l_orig_sys_document_ref
1530: ,p_change_sequence => l_change_sequence
1531: ,p_orig_sys_document_line_ref => null
1532: ,p_orig_sys_shipment_ref => null

Line 1541: OE_Acknowledgment_Pub.Process_Xml_Acknowledgment(

1537: ,p_constraint_id => null
1538: );
1539: -- end bug 3688227
1540:
1541: OE_Acknowledgment_Pub.Process_Xml_Acknowledgment(
1542: p_orig_sys_document_ref => l_orig_sys_document_ref,
1543: p_itemtype => p_itemtype,
1544: p_start_from_flow => l_start_from_flow,
1545: p_transaction_type => l_transaction_type,

Line 1712: OE_Acknowledgment_Pub.Raise_Event_XMLInt (

1708: ,p_constraint_id => null
1709: );
1710: -- end bug 3688227
1711:
1712: OE_Acknowledgment_Pub.Raise_Event_XMLInt (
1713: p_order_source_id => l_order_source_id,
1714: p_partner_document_num => l_orig_sys_document_ref,
1715: p_sold_to_org_id => l_sold_to_org_id,
1716: p_itemtype => NULL,

Line 1729: IF l_order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID THEN

1725: p_subscriber_list => 'DEFAULT',
1726: p_line_ids => 'ALL',
1727: x_return_status => l_return_status);
1728:
1729: IF l_order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID THEN
1730: OE_Acknowledgment_Pub.Is_Delivery_Required
1731: (
1732: p_customer_id => l_sold_to_org_id,
1733: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,

Line 1730: OE_Acknowledgment_Pub.Is_Delivery_Required

1726: p_line_ids => 'ALL',
1727: x_return_status => l_return_status);
1728:
1729: IF l_order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID THEN
1730: OE_Acknowledgment_Pub.Is_Delivery_Required
1731: (
1732: p_customer_id => l_sold_to_org_id,
1733: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
1734: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

Line 1733: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,

1729: IF l_order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID THEN
1730: OE_Acknowledgment_Pub.Is_Delivery_Required
1731: (
1732: p_customer_id => l_sold_to_org_id,
1733: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
1734: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,
1735: x_party_id => l_party_id,
1736: x_party_site_id => l_party_site_id,
1737: x_is_delivery_required => l_is_delivery_reqd,

Line 1734: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

1730: OE_Acknowledgment_Pub.Is_Delivery_Required
1731: (
1732: p_customer_id => l_sold_to_org_id,
1733: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
1734: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,
1735: x_party_id => l_party_id,
1736: x_party_site_id => l_party_site_id,
1737: x_is_delivery_required => l_is_delivery_reqd,
1738: x_return_status => l_return_status

Line 1742: Oe_Acknowledgment_Pub.Raise_Event_Showso

1738: x_return_status => l_return_status
1739: );
1740: IF l_is_delivery_reqd = 'Y' THEN
1741:
1742: Oe_Acknowledgment_Pub.Raise_Event_Showso
1743: (p_header_id => p_itemkey,
1744: p_line_id => Null,
1745: p_customer_id => l_sold_to_org_id,
1746: p_orig_sys_document_ref => l_orig_sys_document_ref,

Line 1760: Oe_Acknowledgment_Pub.Raise_Event_Showso

1756: ELSE
1757: l_return_status := fnd_api.g_ret_sts_success;
1758: END IF;
1759: Elsif p_itemtype = Oe_Globals.G_WFI_LIN Then
1760: Oe_Acknowledgment_Pub.Raise_Event_Showso
1761: (p_header_id => Null,
1762: p_line_id => p_itemkey,
1763: p_customer_id => Null,
1764: p_orig_sys_document_ref => Null,

Line 1873: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

1869: p_entity_code => 'ELECMSG_'||p_itemtype
1870: ,p_entity_id => to_number(p_itemkey)
1871: ,p_header_id => l_header_id
1872: ,p_line_id => null
1873: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
1874: ,p_orig_sys_document_ref => l_orig_sys_document_ref
1875: ,p_orig_sys_document_line_ref => null
1876: ,p_orig_sys_shipment_ref => null
1877: ,p_change_sequence => l_change_sequence

Line 1884: l_user_key := l_orig_sys_document_ref || ',' || to_char(l_customer_number) || ',' || l_change_sequence || ',' || l_transaction_type; --OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO;

1880: ,p_source_document_line_id => null );
1881: -- end exception management
1882:
1883: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1884: l_user_key := l_orig_sys_document_ref || ',' || to_char(l_customer_number) || ',' || l_change_sequence || ',' || l_transaction_type; --OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO;
1885: Else
1886: l_user_key := l_orig_sys_document_ref || ',' || to_char(l_customer_number) || ',' || l_transaction_type; --OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO;
1887: End If;
1888: IF l_debug_level > 0 THEN

Line 1886: l_user_key := l_orig_sys_document_ref || ',' || to_char(l_customer_number) || ',' || l_transaction_type; --OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO;

1882:
1883: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1884: l_user_key := l_orig_sys_document_ref || ',' || to_char(l_customer_number) || ',' || l_change_sequence || ',' || l_transaction_type; --OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO;
1885: Else
1886: l_user_key := l_orig_sys_document_ref || ',' || to_char(l_customer_number) || ',' || l_transaction_type; --OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO;
1887: End If;
1888: IF l_debug_level > 0 THEN
1889: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;
1890: END IF;

Line 1916: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

1912: p_entity_code => 'ELECMSG_'||p_itemtype
1913: ,p_entity_id => p_itemkey
1914: ,p_header_id => null
1915: ,p_line_id => null
1916: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
1917: ,p_orig_sys_document_ref => l_orig_sys_document_ref
1918: ,p_orig_sys_document_line_ref => null
1919: ,p_orig_sys_shipment_ref => null
1920: ,p_change_sequence => l_change_sequence

Line 2236: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

2232: -- this is all the info we have at this point
2233: OE_MSG_PUB.set_msg_context(
2234: p_entity_code => 'ELECMSG_'||p_itemtype
2235: ,p_entity_id => p_itemkey
2236: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
2237: );
2238: -- end bug 3688227
2239:
2240: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then

Line 2259: If l_transaction_type_test1 = Oe_Acknowledgment_Pub.G_TRANSACTION_POA

2255: , p_itemkey
2256: , 'PARAMETER3'
2257: );
2258:
2259: If l_transaction_type_test1 = Oe_Acknowledgment_Pub.G_TRANSACTION_POA
2260: OR l_transaction_type_test1 = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO Then
2261: --POA
2262: l_transaction_type := l_transaction_type_test1;
2263: Else

Line 2260: OR l_transaction_type_test1 = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO Then

2256: , 'PARAMETER3'
2257: );
2258:
2259: If l_transaction_type_test1 = Oe_Acknowledgment_Pub.G_TRANSACTION_POA
2260: OR l_transaction_type_test1 = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO Then
2261: --POA
2262: l_transaction_type := l_transaction_type_test1;
2263: Else
2264: --POI, CPO, or SSO

Line 2281: If l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO

2277: 'PROCESSING_STAGE',
2278: TRUE);
2279:
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

Line 2282: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO

2278: TRUE);
2279:
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'

Line 2331: IF l_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_SSO THEN

2327: IF OE_Code_Control.Get_Code_Release_Level >= '110510' THEN
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);

Line 2342: Elsif ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR

2338:
2339: IF OE_Code_Control.Get_Code_Release_Level < '110510' THEN
2340: l_processing_stage := 'OUTBOUND_SENT';
2341: END IF;
2342: Elsif ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
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:

Line 2343: (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR

2339: IF OE_Code_Control.Get_Code_Release_Level < '110510' THEN
2340: l_processing_stage := 'OUTBOUND_SENT';
2341: END IF;
2342: Elsif ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
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

Line 2344: (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)) Then

2340: l_processing_stage := 'OUTBOUND_SENT';
2341: END IF;
2342: Elsif ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) OR
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

Line 2368: IF l_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_CHO 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
2369: l_response_flag := wf_engine.GetItemAttrText(p_itemtype
2370: , p_itemkey
2371: , 'PARAMETER10'
2372: , TRUE);

Line 2431: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO OR

2427: -- we fetch it from the base table, only in the case when order import succeeded for an Inbound
2428: -- or if it is an SSO/CSO
2429: -- POA is handled separately
2430:
2431: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO OR
2432: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO OR
2433: ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI OR
2434: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO OR
2435: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)

Line 2432: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO OR

2428: -- or if it is an SSO/CSO
2429: -- POA is handled separately
2430:
2431: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO OR
2432: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO OR
2433: ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI OR
2434: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO OR
2435: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)
2436: AND l_processing_stage IN ('IMPORT_SUCCESS'))) Then

Line 2433: ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI OR

2429: -- POA is handled separately
2430:
2431: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO OR
2432: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO OR
2433: ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI OR
2434: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO OR
2435: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)
2436: AND l_processing_stage IN ('IMPORT_SUCCESS'))) Then
2437:

Line 2434: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO OR

2430:
2431: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO OR
2432: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO OR
2433: ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI OR
2434: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO OR
2435: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)
2436: AND l_processing_stage IN ('IMPORT_SUCCESS'))) Then
2437:
2438:

Line 2435: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)

2431: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO OR
2432: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO OR
2433: ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI OR
2434: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO OR
2435: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)
2436: AND l_processing_stage IN ('IMPORT_SUCCESS'))) Then
2437:
2438:
2439: Begin

Line 2448: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;

2444: And decode(l_customer_key_profile, 'Y',
2445: nvl(sold_to_org_id, -999), 1)
2446: = decode(l_customer_key_profile, 'Y',
2447: nvl(l_sold_to_org_id, -999), 1)
2448: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
2449:
2450:
2451: -- start bug 4195533
2452: OE_MSG_PUB.update_msg_context(

Line 2473: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO THEN --do nothing, just trap

2469: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER FOR ' || P_ITEMTYPE ) ;
2470: END IF;
2471: End;
2472:
2473: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO THEN --do nothing, just trap
2474: null;
2475:
2476: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA THEN
2477:

Line 2476: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA THEN

2472:
2473: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO THEN --do nothing, just trap
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'

Line 2507: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;

2503: And decode(l_customer_key_profile, 'Y',
2504: nvl(sold_to_org_id, -999), 1)
2505: = decode(l_customer_key_profile, 'Y',
2506: nvl(l_sold_to_org_id, -999), 1)
2507: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
2508:
2509: -- start bug 4195533
2510: IF l_failure_ack_flag = 'N' THEN
2511: OE_MSG_PUB.update_msg_context(

Line 2542: If l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO

2538: --Done Setting Document Number
2539:
2540: IF OE_Code_Control.Get_Code_Release_Level >= '110510' THEN
2541: --Setting Document Id for outbound transactions
2542: If l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO
2543: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO Then
2544: l_document_id := p_itemkey;
2545: l_document_direction := 'OUT';
2546: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO

Line 2543: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO Then

2539:
2540: IF OE_Code_Control.Get_Code_Release_Level >= '110510' THEN
2541: --Setting Document Id for outbound transactions
2542: If l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO
2543: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO Then
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

Line 2546: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO

2542: If l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO
2543: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO Then
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');

Line 2547: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA Then

2543: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO Then
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';

Line 2575: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');

2571:
2572: IF l_processing_stage = 'INBOUND_IFACE' THEN
2573: fnd_message.set_name('ONT', 'OE_OI_IFACE');
2574:
2575: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2576: l_message_text := fnd_message.get;
2577: l_doc_status := 'ACTIVE';
2578: ELSIF l_processing_stage = 'PRE_IMPORT' THEN
2579:

Line 2586: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');

2582: Elsif l_import_mode = 'SYNCHRONOUS' Then
2583: fnd_message.set_name('ONT', 'OE_OI_IMPORT_MODE_SYNC');
2584: End If;
2585:
2586: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2587:
2588: l_message_text := fnd_message.get;
2589: l_doc_status := 'ACTIVE';
2590:

Line 2592: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) Then

2588: l_message_text := fnd_message.get;
2589: l_doc_status := 'ACTIVE';
2590:
2591: ELSIF l_processing_stage = 'IMPORT_SUCCESS' THEN
2592: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) Then
2593: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL');
2594:
2595: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) Then
2596: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CPO');

Line 2595: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) Then

2591: ELSIF l_processing_stage = 'IMPORT_SUCCESS' THEN
2592: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) Then
2593: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL');
2594:
2595: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) Then
2596: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CPO');
2597:
2598: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) Then
2599: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CHO');

Line 2598: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) Then

2594:
2595: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) Then
2596: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CPO');
2597:
2598: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) Then
2599: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CHO');
2600: End if;
2601: l_doc_status := 'SUCCESS';
2602: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN

Line 2604: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');

2600: End if;
2601: l_doc_status := 'SUCCESS';
2602: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
2603: fnd_message.set_name('ONT', 'OE_OI_IMPORT_FAILURE');
2604: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2605:
2606: l_message_text := fnd_message.get;
2607: l_doc_status := 'ERROR';
2608: ELSIF l_processing_stage = 'OUTBOUND_SENT' THEN

Line 2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then

2625: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2626: fnd_message.set_token ('TRANSACTION', l_standard_desc);
2627: l_message_text := fnd_message.get;
2628: Else
2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then
2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2632:
2633: l_message_text := fnd_message.get;

Line 2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

2627: l_message_text := fnd_message.get;
2628: Else
2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then
2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2632:
2633: l_message_text := fnd_message.get;
2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO
2635:

Line 2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO

2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2632:
2633: l_message_text := fnd_message.get;
2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO
2635:
2636: l_message_text := fnd_message.get_string('ONT', 'OE_SO_SHOW_SO_SENT');
2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO
2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

Line 2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO

2633: l_message_text := fnd_message.get;
2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO
2635:
2636: l_message_text := fnd_message.get_string('ONT', 'OE_SO_SHOW_SO_SENT');
2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO
2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2640:
2641: l_message_text := fnd_message.get;

Line 2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

2635:
2636: l_message_text := fnd_message.get_string('ONT', 'OE_SO_SHOW_SO_SENT');
2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO
2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2640:
2641: l_message_text := fnd_message.get;
2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO
2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

Line 2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO

2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2640:
2641: l_message_text := fnd_message.get;
2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO
2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2644: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2645:
2646: l_message_text := fnd_message.get;

Line 2644: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

2640:
2641: l_message_text := fnd_message.get;
2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO
2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2644: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2645:
2646: l_message_text := fnd_message.get;
2647: End If;
2648: End If;

Line 2664: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');

2660: ELSIF l_setup_status = 'ERROR' THEN
2661: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_SETUP_ERR');
2662: l_doc_status := 'ERROR';
2663: END IF;
2664: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2665:
2666: l_message_text := fnd_message.get;
2667:
2668: ELSIF l_processing_stage = 'OUTBOUND_TRIGGERED' THEN

Line 2670: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

2666: l_message_text := fnd_message.get;
2667:
2668: ELSIF l_processing_stage = 'OUTBOUND_TRIGGERED' THEN
2669: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_TRIGGERED');
2670: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2671:
2672: l_message_text := fnd_message.get;
2673:
2674: l_doc_status := 'ACTIVE';

Line 2692: Oe_Acknowledgment_Pub.Raise_Event_Xmlint

2688:
2689:
2690: -- Orig Sys Document Ref is passed in for Partner Document Number
2691:
2692: Oe_Acknowledgment_Pub.Raise_Event_Xmlint
2693: (p_order_source_id => OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID,
2694: p_partner_document_num => l_orig_sys_document_ref,
2695: p_message_text => l_message_text,
2696: p_document_num => l_document_num,

Line 2693: (p_order_source_id => OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID,

2689:
2690: -- Orig Sys Document Ref is passed in for Partner Document Number
2691:
2692: Oe_Acknowledgment_Pub.Raise_Event_Xmlint
2693: (p_order_source_id => OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID,
2694: p_partner_document_num => l_orig_sys_document_ref,
2695: p_message_text => l_message_text,
2696: p_document_num => l_document_num,
2697: p_order_type_id => l_order_type_id,

Line 2700: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE, --'ONT'

2696: p_document_num => l_document_num,
2697: p_order_type_id => l_order_type_id,
2698: p_itemtype => p_itemtype,
2699: p_itemkey => p_itemkey,
2700: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE, --'ONT'
2701: p_transaction_subtype => l_transaction_type,
2702: p_doc_status => l_doc_status,
2703: p_org_id => l_org_id,
2704: p_sold_to_org_id => l_sold_to_org_id,