APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_ORDER_LINES

Line 64: From oe_order_lines

60: Where header_id = p_header_id;
61: Else
62: Select orig_sys_document_ref
63: Into l_orig_sys_document_ref
64: From oe_order_lines
65: Where line_id = p_line_id;
66: End If;
67:
68: Return l_orig_sys_document_ref;

Line 130: From oe_order_lines

126: oe_debug_pub.add( 'P_LINE_ID IS NOT NULL' ) ;
127: END IF;
128: Select header_id
129: Into l_header_id
130: From oe_order_lines
131: Where line_id = p_line_id
132: And order_source_id = G_XML_ORDER_SOURCE_ID
133: And rownum = 1;
134: IF l_debug_level > 0 THEN

Line 1135: From oe_order_lines

1131: nvl(p_sold_to_org_id, -999), 1);
1132:
1133: Cursor Cancel_Line_Ack_Cur Is
1134: Select Line_Id
1135: From oe_order_lines
1136: Where request_id = l_request_id
1137: And header_id = l_header_id
1138: And decode(l_customer_key_profile, 'Y',
1139: nvl(sold_to_org_id, -999), 1)

Line 1356: -- OE_ORDER_LINES_ALL table

1352: End;
1353: -- End Header query}
1354:
1355: --{Call Query Row procedure to get the Line Data from Base
1356: -- OE_ORDER_LINES_ALL table
1357:
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;
1360: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;

Line 1441: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;

1437: Exception
1438: When Others Then
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --FND_API.G_RET_STS_SUCCESS;
1440: IF l_debug_level > 0 THEN
1441: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1442: END IF;
1443: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1444: fnd_message.set_token ('TABLE', 'oe_order_lines');
1445: oe_msg_pub.add;

Line 1444: fnd_message.set_token ('TABLE', 'oe_order_lines');

1440: IF l_debug_level > 0 THEN
1441: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1442: END IF;
1443: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1444: fnd_message.set_token ('TABLE', 'oe_order_lines');
1445: oe_msg_pub.add;
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: --RETURN;
1448: End;

Line 1503: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;

1499: Exception
1500: When Others Then
1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1502: IF l_debug_level > 0 THEN
1503: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1504: END IF;
1505: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1506: fnd_message.set_token ('TABLE', 'oe_order_lines');
1507: oe_msg_pub.add;

Line 1506: fnd_message.set_token ('TABLE', 'oe_order_lines');

1502: IF l_debug_level > 0 THEN
1503: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1504: END IF;
1505: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1506: fnd_message.set_token ('TABLE', 'oe_order_lines');
1507: oe_msg_pub.add;
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509: --RETURN;
1510: End;