[Home] [Help]
60:
61: If p_header_id Is Not Null Then
62: Select orig_sys_document_ref
63: Into l_orig_sys_document_ref
64: From oe_order_headers
65: Where header_id = p_header_id;
66: Else
67: Select orig_sys_document_ref
68: Into l_orig_sys_document_ref
114: oe_debug_pub.add( 'P_ORIG_SYS_DOCUMENT_REF IS NOT NULL'||P_ORIG_SYS_DOCUMENT_REF ) ;
115: END IF;
116: Select header_id
117: Into l_header_id
118: From oe_order_headers
119: Where order_source_id = G_XML_ORDER_SOURCE_ID
120: And orig_sys_document_ref = p_orig_sys_document_ref
121: AND decode(l_customer_key_profile, 'Y',
122: nvl(sold_to_org_id, -999), 1)
1251:
1252: Begin
1253: Select header_id
1254: into l_header_id
1255: From oe_order_headers
1256: Where order_source_id = G_XML_ORDER_SOURCE_ID
1257: And orig_sys_document_ref = p_orig_sys_document_ref
1258: And decode(l_customer_key_profile, 'Y',
1259: nvl(sold_to_org_id, -999), 1)
1276: Exception
1277: When OTHERS Then
1278: -- Code here to raise error as not able to find the header id
1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1281: END IF;
1282: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1283: fnd_message.set_token ('TABLE', 'oe_order_headers');
1284: oe_msg_pub.add;
1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1281: END IF;
1282: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1283: fnd_message.set_token ('TABLE', 'oe_order_headers');
1284: oe_msg_pub.add;
1285: End;
1286:
1287: End If;
1297: l_header_id := p_header_id;
1298: end if;
1299:
1300: --{Call Query Row procedure to get the Header Data from Base
1301: -- OE_ORDER_HEADERS_ALL table
1302: Begin
1303: oe_header_util.query_row ( p_header_id => l_header_id,
1304: x_header_rec => l_header_rec);
1305:
1346: Exception
1347: When Others Then
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1351: END IF;
1352: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1353: fnd_message.set_token ('TABLE', 'oe_order_headers');
1354: oe_msg_pub.add;
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1351: END IF;
1352: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1353: fnd_message.set_token ('TABLE', 'oe_order_headers');
1354: oe_msg_pub.add;
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: --RETURN;
1357: End;
1412: END IF;
1413: Begin
1414: Select cancelled_flag
1415: Into l_cancelled_flag
1416: From oe_order_headers
1417: Where header_id = l_header_id;
1418: IF l_debug_level > 0 THEN
1419: oe_debug_pub.add( 'HEADER_ID: ' || L_HEADER_ID ) ;
1420: END IF;
2900:
2901: -- { Start of cursor definition for the Order Selection
2902: CURSOR c_order_for_customer IS
2903: SELECT header_id, sold_to_org_id, order_number, orig_sys_document_ref, order_source_id, change_sequence,org_id
2904: FROM oe_order_headers
2905: WHERE sold_to_org_id = p_customer_id
2906: -- AND open_flag = 'Y' -- only open orders are supported currently
2907: AND open_flag IN ('Y', l_open_flag)
2908: AND order_source_id = G_XML_ORDER_SOURCE_ID
3249:
3250: Begin
3251: Select order_number, order_type_id, header_id
3252: Into l_document_num, l_order_type_id, l_header_id
3253: From oe_order_headers
3254: Where orig_sys_document_ref = p_partner_document_num
3255: And order_source_id = 20
3256: And decode(l_customer_key_profile, 'Y',
3257: nvl(sold_to_org_id, -999), 1)