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 1874: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

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

Line 1885: 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;

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

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

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

Line 1917: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

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

Line 2237: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID

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

Line 2260: If l_transaction_type_test1 = Oe_Acknowledgment_Pub.G_TRANSACTION_POA

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

Line 2261: OR l_transaction_type_test1 = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO Then

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

Line 2282: If l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO

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

Line 2283: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO

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

Line 2332: IF l_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_SSO THEN

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

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

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

Line 2344: (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) OR

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

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

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

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

Line 2432: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO OR

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

Line 2433: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO OR

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

Line 2434: ((l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI OR

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

Line 2435: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO OR

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

Line 2436: l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO)

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

Line 2449: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;

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

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

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

Line 2477: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA THEN

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

Line 2508: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;

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

Line 2543: If l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO

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

Line 2544: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO Then

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

Line 2547: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO

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

Line 2548: Or l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA Then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2693: Oe_Acknowledgment_Pub.Raise_Event_Xmlint

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

Line 2694: (p_order_source_id => OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID,

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

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

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