eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_EXTN_IMPORT_PVT dependencies on FND_API

Line 62: RAISE FND_API.G_EXC_ERROR;

58: fnd_profile.get('DEFAULT_ORG_ID', l_org_id);
59: FND_FILE.PUT_LINE( FND_FILE.LOG, 'DEFAULT ORG ID = '||l_org_id ) ;
60: IF l_org_id IS NULL THEN
61: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Unable to derive org_id from MO: Default Operating Unit. Please set the profile value.');
62: RAISE FND_API.G_EXC_ERROR;
63: END IF;
64:
65: END IF;
66:

Line 77: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

73: FROM oe_order_headers_all
74: WHERE order_source_id = i.order_source_id
75: AND orig_sys_document_ref = i.orig_sys_document_ref
76: AND org_id = Nvl(i.org_id,l_org_id)
77: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
78: = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
79: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_header_id : ' || l_header_id);
80: EXCEPTION
81: WHEN NO_DATA_FOUND THEN

Line 78: = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));

74: WHERE order_source_id = i.order_source_id
75: AND orig_sys_document_ref = i.orig_sys_document_ref
76: AND org_id = Nvl(i.org_id,l_org_id)
77: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
78: = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
79: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_header_id : ' || l_header_id);
80: EXCEPTION
81: WHEN NO_DATA_FOUND THEN
82: l_header_id :=NULL;

Line 94: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

90: WHERE data_set_id = l_data_set_id
91: AND PROCESS_STATUS = 1
92: AND order_source_id = i.order_source_id
93: AND orig_sys_document_ref = i.orig_sys_document_ref
94: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
95: = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
96:
97: END IF;
98: ELSE

Line 95: = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));

91: AND PROCESS_STATUS = 1
92: AND order_source_id = i.order_source_id
93: AND orig_sys_document_ref = i.orig_sys_document_ref
94: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
95: = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
96:
97: END IF;
98: ELSE
99: UPDATE OE_HEADERS_EXT_IFACE_ALL

Line 151: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

147: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_err_code : '||l_err_code);
148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_err_text : '||l_err_text);
149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_msg_count : '||l_msg_count);
150:
151: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
152: retcode := 0;
153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Sucessfully imported OE_HEADERS_EXT_IFACE_ALL data');
154: ELSIF l_return_status = 'W' THEN
155: retcode := 1;

Line 169: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR l_return_status = 'W' THEN

165: ,p_write_err_to_conclog => 'Y'
166: ,p_write_err_to_debugfile => 'N'
167: );
168:
169: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR l_return_status = 'W' THEN
170: DELETE FROM OE_HEADERS_EXT_IFACE_ALL
171: WHERE data_set_id = l_data_set_id
172: AND PROCESS_STATUS = 2;
173: COMMIT;

Line 187: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)

183: FROM oe_order_lines_all
184: WHERE order_source_id = i.order_source_id
185: AND orig_sys_document_ref = i.orig_sys_document_ref
186: AND orig_sys_line_ref = i.orig_sys_line_ref
187: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)
188: AND org_id = Nvl(i.org_id,l_org_id)
189: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
190: = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
191:

Line 189: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

185: AND orig_sys_document_ref = i.orig_sys_document_ref
186: AND orig_sys_line_ref = i.orig_sys_line_ref
187: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)
188: AND org_id = Nvl(i.org_id,l_org_id)
189: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
190: = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
191:
192: EXCEPTION
193: WHEN NO_DATA_FOUND THEN

Line 190: = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));

186: AND orig_sys_line_ref = i.orig_sys_line_ref
187: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)
188: AND org_id = Nvl(i.org_id,l_org_id)
189: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
190: = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
191:
192: EXCEPTION
193: WHEN NO_DATA_FOUND THEN
194: l_line_id :=NULL;

Line 208: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)

204: WHERE data_set_id = l_data_set_id
205: AND PROCESS_STATUS = 1
206: AND order_source_id = i.order_source_id
207: AND orig_sys_line_ref = i.orig_sys_line_ref
208: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)
209: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
210: = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
211: END IF;
212: ELSE

Line 209: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

205: AND PROCESS_STATUS = 1
206: AND order_source_id = i.order_source_id
207: AND orig_sys_line_ref = i.orig_sys_line_ref
208: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)
209: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
210: = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
211: END IF;
212: ELSE
213: UPDATE OE_LINES_EXT_IFACE_ALL

Line 210: = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));

206: AND order_source_id = i.order_source_id
207: AND orig_sys_line_ref = i.orig_sys_line_ref
208: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)
209: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
210: = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
211: END IF;
212: ELSE
213: UPDATE OE_LINES_EXT_IFACE_ALL
214: SET PROCESS_STATUS = 2

Line 265: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

261: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_err_code : '||l_err_code);
262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_err_text : '||l_err_text);
263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_msg_count : '||l_msg_count);
264:
265: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
266: retcode := 0;
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Sucessfully imported OE_LINES_EXT_IFACE_ALL data');
268: ELSIF l_return_status = 'W' THEN
269: retcode := 1;

Line 283: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR l_return_status = 'W' THEN

279: ,p_write_err_to_conclog => 'Y'
280: ,p_write_err_to_debugfile => 'N'
281: );
282:
283: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR l_return_status = 'W' THEN
284: DELETE FROM OE_LINES_EXT_IFACE_ALL
285: WHERE data_set_id = l_data_set_id
286: AND PROCESS_STATUS = 2;
287: COMMIT;

Line 293: WHEN FND_API.G_EXC_ERROR THEN

289: END IF;
290: -- All the errors will be mtl_interface_errors with process_status <> 2 and the transaction_id will be marked..
291: -- we can get the details of the error by joining with transcation_id
292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: retcode := 2;
295: errbuf := 'Please fix the error in the log file';
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please fix the errors in this log file and re-run the concurrent program.');
297: