APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_HEADERS_INTERFACE

Line 901: FROM oe_headers_interface

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

Line 1196: From oe_headers_interface

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

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

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

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

1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1224: END IF;
1225: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1226: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1227: oe_msg_pub.add;
1228: End;
1229:
1230: