APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_ORDER_LINES

Line 69: From oe_order_lines

65: Where header_id = p_header_id;
66: Else
67: Select orig_sys_document_ref
68: Into l_orig_sys_document_ref
69: From oe_order_lines
70: Where line_id = p_line_id;
71: End If;
72:
73: Return l_orig_sys_document_ref;

Line 135: From oe_order_lines

131: oe_debug_pub.add( 'P_LINE_ID IS NOT NULL' ) ;
132: END IF;
133: Select header_id
134: Into l_header_id
135: From oe_order_lines
136: Where line_id = p_line_id
137: And order_source_id = G_XML_ORDER_SOURCE_ID
138: And rownum = 1;
139: IF l_debug_level > 0 THEN

Line 1140: From oe_order_lines

1136: nvl(p_sold_to_org_id, -999), 1);
1137:
1138: Cursor Cancel_Line_Ack_Cur Is
1139: Select Line_Id
1140: From oe_order_lines
1141: Where request_id = l_request_id
1142: And header_id = l_header_id
1143: And decode(l_customer_key_profile, 'Y',
1144: nvl(sold_to_org_id, -999), 1)

Line 1361: -- OE_ORDER_LINES_ALL table

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

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

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

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

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

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

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

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

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

Line 4061: SELECT 'X' INTO temp FROM oe_order_lines_all WHERE line_id=p_line_id;

4057: IS
4058: PRAGMA AUTONOMOUS_TRANSACTION;
4059: temp VARCHAR2(1);
4060: BEGIN
4061: SELECT 'X' INTO temp FROM oe_order_lines_all WHERE line_id=p_line_id;
4062: x_exists_flag :='Y';
4063: COMMIT;
4064: EXCEPTION
4065: WHEN OTHERS THEN