APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_HEADERS_INTERFACE

Line 906: FROM oe_headers_interface

902: -- ?? Should we add all the sold to address columns??
903: , sold_to_org_id , sold_to_org
904: , org_id , request_id
905: , xml_message_id , payment_term
906: FROM oe_headers_interface
907: WHERE order_source_id = p_order_source_id
908: AND orig_sys_document_ref = p_orig_sys_document_ref
909: AND decode(l_customer_key_profile, 'Y',
910: nvl(sold_to_org_id, -999), 1)

Line 1201: From oe_headers_interface

1197: -- We need to check here to make sure if the order is created or rejected
1198: Begin
1199: Select orig_sys_document_ref
1200: into l_orig_sys_document_ref
1201: From oe_headers_interface
1202: Where order_source_id = G_XML_ORDER_SOURCE_ID
1203: And orig_sys_document_ref = p_orig_sys_document_ref
1204: And decode(l_customer_key_profile, 'Y',
1205: nvl(sold_to_org_id, -999), 1)

Line 1228: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;

1224: l_reject_order := 'N';
1225: When OTHERS Then
1226: -- Code here to raise error as not able to find the orig_sys_document_ref
1227: IF l_debug_level > 0 THEN
1228: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1229: END IF;
1230: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1231: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1232: oe_msg_pub.add;

Line 1231: fnd_message.set_token ('TABLE', 'oe_headers_interface');

1227: IF l_debug_level > 0 THEN
1228: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1229: END IF;
1230: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1231: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1232: oe_msg_pub.add;
1233: End;
1234:
1235: