[Home] [Help]
55:
56: If p_header_id Is Not Null Then
57: Select orig_sys_document_ref
58: Into l_orig_sys_document_ref
59: From oe_order_headers
60: Where header_id = p_header_id;
61: Else
62: Select orig_sys_document_ref
63: Into l_orig_sys_document_ref
109: oe_debug_pub.add( 'P_ORIG_SYS_DOCUMENT_REF IS NOT NULL'||P_ORIG_SYS_DOCUMENT_REF ) ;
110: END IF;
111: Select header_id
112: Into l_header_id
113: From oe_order_headers
114: Where order_source_id = G_XML_ORDER_SOURCE_ID
115: And orig_sys_document_ref = p_orig_sys_document_ref
116: AND decode(l_customer_key_profile, 'Y',
117: nvl(sold_to_org_id, -999), 1)
1246:
1247: Begin
1248: Select header_id
1249: into l_header_id
1250: From oe_order_headers
1251: Where order_source_id = G_XML_ORDER_SOURCE_ID
1252: And orig_sys_document_ref = p_orig_sys_document_ref
1253: And decode(l_customer_key_profile, 'Y',
1254: nvl(sold_to_org_id, -999), 1)
1271: Exception
1272: When OTHERS Then
1273: -- Code here to raise error as not able to find the header id
1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1276: END IF;
1277: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1278: fnd_message.set_token ('TABLE', 'oe_order_headers');
1279: oe_msg_pub.add;
1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1276: END IF;
1277: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1278: fnd_message.set_token ('TABLE', 'oe_order_headers');
1279: oe_msg_pub.add;
1280: End;
1281:
1282: End If;
1292: l_header_id := p_header_id;
1293: end if;
1294:
1295: --{Call Query Row procedure to get the Header Data from Base
1296: -- OE_ORDER_HEADERS_ALL table
1297: Begin
1298: oe_header_util.query_row ( p_header_id => l_header_id,
1299: x_header_rec => l_header_rec);
1300:
1341: Exception
1342: When Others Then
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1344: IF l_debug_level > 0 THEN
1345: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1346: END IF;
1347: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1348: fnd_message.set_token ('TABLE', 'oe_order_headers');
1349: oe_msg_pub.add;
1344: IF l_debug_level > 0 THEN
1345: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1346: END IF;
1347: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1348: fnd_message.set_token ('TABLE', 'oe_order_headers');
1349: oe_msg_pub.add;
1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1351: --RETURN;
1352: End;
1407: END IF;
1408: Begin
1409: Select cancelled_flag
1410: Into l_cancelled_flag
1411: From oe_order_headers
1412: Where header_id = l_header_id;
1413: IF l_debug_level > 0 THEN
1414: oe_debug_pub.add( 'HEADER_ID: ' || L_HEADER_ID ) ;
1415: END IF;
2784:
2785: -- { Start of cursor definition for the Order Selection
2786: CURSOR c_order_for_customer IS
2787: SELECT header_id, sold_to_org_id, order_number, orig_sys_document_ref, order_source_id, change_sequence,org_id
2788: FROM oe_order_headers
2789: WHERE sold_to_org_id = p_customer_id
2790: -- AND open_flag = 'Y' -- only open orders are supported currently
2791: AND open_flag IN ('Y', l_open_flag)
2792: AND order_source_id = G_XML_ORDER_SOURCE_ID
3133:
3134: Begin
3135: Select order_number, order_type_id, header_id
3136: Into l_document_num, l_order_type_id, l_header_id
3137: From oe_order_headers
3138: Where orig_sys_document_ref = p_partner_document_num
3139: And order_source_id = 20
3140: And decode(l_customer_key_profile, 'Y',
3141: nvl(sold_to_org_id, -999), 1)