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.PO_ASL_API_PUB dependencies on FND_API

Line 177: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

173: x_return_status => x_return_status,
174: x_return_msg => x_return_msg
175: );
176:
177: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
178: THEN
179: RAISE unexp_err_pasl;
180: END IF;
181: -- if return status is expected error raise exception fnd_api.G_EXC_ERROR

Line 181: -- if return status is expected error raise exception fnd_api.G_EXC_ERROR

177: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
178: THEN
179: RAISE unexp_err_pasl;
180: END IF;
181: -- if return status is expected error raise exception fnd_api.G_EXC_ERROR
182: IF x_return_status = FND_API.G_RET_STS_ERROR
183: THEN
184: RAISE duplicate_keys;
185: END IF;

Line 182: IF x_return_status = FND_API.G_RET_STS_ERROR

178: THEN
179: RAISE unexp_err_pasl;
180: END IF;
181: -- if return status is expected error raise exception fnd_api.G_EXC_ERROR
182: IF x_return_status = FND_API.G_RET_STS_ERROR
183: THEN
184: RAISE duplicate_keys;
185: END IF;
186:

Line 195: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

191: p_asl_attr_rec => p_asl_attr_rec,
192: x_return_status => x_return_status,
193: x_return_msg => x_return_msg
194: );
195: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
196: THEN
197: RAISE unexp_err_paa;
198: END IF;
199: END IF;

Line 223: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

219: p_asl_doc_rec => p_asl_doc_rec,
220: x_return_status => x_return_status,
221: x_return_msg => x_return_msg
222: );
223: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
224: THEN
225: RAISE unexp_err_pad;
226: END IF;
227: END IF;

Line 251: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

247: p_chv_auth_rec => p_chv_auth_rec,
248: x_return_status => x_return_status,
249: x_return_msg => x_return_msg
250: );
251: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
252: THEN
253: RAISE unexp_err_chv;
254: END IF;
255: END IF;

Line 279: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

275: p_capacity_rec => p_capacity_rec,
276: x_return_status => x_return_status,
277: x_return_msg => x_return_msg
278: );
279: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
280: THEN
281: RAISE unexp_err_psic;
282: END IF;
283: END IF;

Line 307: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

303: p_tolerance_rec => p_tolerance_rec,
304: x_return_status => x_return_status,
305: x_return_msg => x_return_msg
306: );
307: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
308: THEN
309: RAISE unexp_err_psit;
310: END IF;
311: END IF;

Line 342: Nvl(x_return_status,' ') NOT IN (FND_API.G_RET_STS_ERROR,

338: THEN
339: po_asl_api_pvt.log('x_return_status is null');
340: END IF;
341: IF (p_commit = 'Y' AND
342: Nvl(x_return_status,' ') NOT IN (FND_API.G_RET_STS_ERROR,
343: FND_API.G_RET_STS_UNEXP_ERROR)
344: )
345: THEN
346: COMMIT;

Line 343: FND_API.G_RET_STS_UNEXP_ERROR)

339: po_asl_api_pvt.log('x_return_status is null');
340: END IF;
341: IF (p_commit = 'Y' AND
342: Nvl(x_return_status,' ') NOT IN (FND_API.G_RET_STS_ERROR,
343: FND_API.G_RET_STS_UNEXP_ERROR)
344: )
345: THEN
346: COMMIT;
347: po_asl_api_pvt.log('Transaction committed');

Line 354: x_return_status := FND_API.G_RET_STS_SUCCESS;

350: l_progress := 100;
351:
352: IF x_return_status IS NULL
353: THEN
354: x_return_status := FND_API.G_RET_STS_SUCCESS;
355: END IF;
356: po_asl_api_pvt.log('END ::: PROCEDURE create_update_asl ');
357:
358: EXCEPTION

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: EXCEPTION
359: WHEN duplicate_keys THEN
360: po_asl_api_pvt.log('create_update_asl : Existing the process
361: due to duplicate user_keys');
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: x_return_msg := 'Existing the process due to duplicate user_keys';
364:
365: WHEN parent_key_not_found THEN
366: po_asl_api_pvt.log('create_update_asl : Parent user_key not found');

Line 367: x_return_status := FND_API.G_RET_STS_ERROR;

363: x_return_msg := 'Existing the process due to duplicate user_keys';
364:
365: WHEN parent_key_not_found THEN
366: po_asl_api_pvt.log('create_update_asl : Parent user_key not found');
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: x_return_msg := 'Parent user_key not found';
369:
370: WHEN unexp_err_pasl THEN
371: po_asl_api_pvt.log('Unexpected while dumping to po_approved_supplier_list_gt');

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368: x_return_msg := 'Parent user_key not found';
369:
370: WHEN unexp_err_pasl THEN
371: po_asl_api_pvt.log('Unexpected while dumping to po_approved_supplier_list_gt');
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: x_return_msg := 'Unexpected while dumping to po_approved_supplier_list_gt';
374:
375: WHEN unexp_err_paa THEN
376: po_asl_api_pvt.log('Unexpected while dumping to po_asl_attributes_gt');

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

373: x_return_msg := 'Unexpected while dumping to po_approved_supplier_list_gt';
374:
375: WHEN unexp_err_paa THEN
376: po_asl_api_pvt.log('Unexpected while dumping to po_asl_attributes_gt');
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: x_return_msg := 'Unexpected while dumping to po_asl_attributes_gt';
379:
380: WHEN unexp_err_pad THEN
381: po_asl_api_pvt.log('Unexpected while dumping to po_asl_documents_gt');

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

378: x_return_msg := 'Unexpected while dumping to po_asl_attributes_gt';
379:
380: WHEN unexp_err_pad THEN
381: po_asl_api_pvt.log('Unexpected while dumping to po_asl_documents_gt');
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: x_return_msg := 'Unexpected while dumping to po_asl_documents_gt';
384:
385: WHEN unexp_err_chv THEN
386: po_asl_api_pvt.log('Unexpected while dumping to chv_authorizations_gt');

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

383: x_return_msg := 'Unexpected while dumping to po_asl_documents_gt';
384:
385: WHEN unexp_err_chv THEN
386: po_asl_api_pvt.log('Unexpected while dumping to chv_authorizations_gt');
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: x_return_msg := 'Unexpected while dumping to chv_authorizations_gt';
389:
390: WHEN unexp_err_psic THEN
391: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_capacity_gt');

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

388: x_return_msg := 'Unexpected while dumping to chv_authorizations_gt';
389:
390: WHEN unexp_err_psic THEN
391: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_capacity_gt');
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: x_return_msg := 'Unexpected while dumping to po_supplier_item_capacity_gt';
394:
395: WHEN unexp_err_psit THEN
396: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_tolerance_gt');

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

393: x_return_msg := 'Unexpected while dumping to po_supplier_item_capacity_gt';
394:
395: WHEN unexp_err_psit THEN
396: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_tolerance_gt');
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: x_return_msg := 'Unexpected while dumping to po_supplier_item_tolerance_gt';
399:
400: WHEN OTHERS THEN
401: po_asl_api_pvt.log('create_update_asl : when others exception at '

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

399:
400: WHEN OTHERS THEN
401: po_asl_api_pvt.log('create_update_asl : when others exception at '
402: || l_progress || ';' || SQLERRM );
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_return_msg := SQLERRM;
405:
406: END create_update_asl;
407:

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: WHEN OTHERS THEN
518:
519: po_asl_api_pvt.log('po_asl_api_pub.process : when others exception at '
520: || l_progress || ';' || SQLERRM );
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: x_return_msg := SQLERRM;
523: END process;
524:
525:

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670: HAVING Count(*) > 1);
671:
672: IF counter > 0
673: THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: ELSE
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677: END IF;
678:

Line 676: x_return_status := FND_API.G_RET_STS_SUCCESS;

672: IF counter > 0
673: THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: ELSE
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677: END IF;
678:
679: po_asl_api_pvt.log('END ::: dump_to_asl_gtt');
680: EXCEPTION

Line 684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

680: EXCEPTION
681: WHEN OTHERS THEN
682:
683: po_asl_api_pvt.log('dump_to_asl_gtt : when others exception ' || SQLERRM );
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: x_return_msg := SQLERRM;
686:
687: END dump_to_asl_gtt;
688:

Line 878: x_return_status := FND_API.G_RET_STS_SUCCESS;

874: p_asl_attr_rec.forecast_horizon_dsp(l_index)
875: );
876:
877: po_asl_api_pvt.log('dump_to_asl_attr_gtt : rowcount :' || SQL%ROWCOUNT);
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879:
880: po_asl_api_pvt.log('END ::: dump_to_asl_attr_gtt');
881: EXCEPTION
882:

Line 886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

882:
883: WHEN OTHERS THEN
884:
885: po_asl_api_pvt.log('dump_to_asl_attr_gtt-when others exception ' || SQLERRM);
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: x_return_msg := SQLERRM;
888:
889: END dump_to_asl_attr_gtt;
890:

Line 998: x_return_status := FND_API.G_RET_STS_SUCCESS;

994: p_asl_doc_rec.org_id(l_index)
995: );
996:
997: po_asl_api_pvt.log('dump_to_asl_doc_gtt : rowcount :' || SQL%ROWCOUNT);
998: x_return_status := FND_API.G_RET_STS_SUCCESS;
999:
1000: po_asl_api_pvt.log('END ::: dump_to_asl_doc_gtt');
1001: EXCEPTION
1002:

Line 1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1002:
1003: WHEN OTHERS THEN
1004:
1005: po_asl_api_pvt.log('dump_to_asl_doc_gtt: when others exception ' || SQLERRM);
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: x_return_msg := SQLERRM;
1008:
1009: END dump_to_asl_doc_gtt;
1010:

Line 1112: x_return_status := FND_API.G_RET_STS_SUCCESS;

1108: p_chv_auth_rec.using_organization_dsp(l_index)
1109: );
1110:
1111: po_asl_api_pvt.log('dump_to_chv_auth_gtt : rowcount :' || SQL%ROWCOUNT);
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;
1113:
1114: po_asl_api_pvt.log('END ::: dump_to_chv_auth_gtt');
1115: EXCEPTION
1116:

Line 1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1116:
1117: WHEN OTHERS THEN
1118:
1119: po_asl_api_pvt.log('dump_to_chv_auth_gtt-when others exception ' || SQLERRM);
1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121: x_return_msg := SQLERRM;
1122:
1123: END dump_to_chv_auth_gtt;
1124:

Line 1227: x_return_status := FND_API.G_RET_STS_SUCCESS;

1223: p_capacity_rec.program_update_date(l_index)
1224: );
1225:
1226: po_asl_api_pvt.log('dump_to_capacity_gtt : rowcount :' || SQL%ROWCOUNT);
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1228:
1229: po_asl_api_pvt.log('END ::: dump_to_capacity_gtt');
1230: EXCEPTION
1231:

Line 1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1231:
1232: WHEN OTHERS THEN
1233:
1234: po_asl_api_pvt.log('dump_to_capacity_gtt-when others exception ' || SQLERRM);
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: x_return_msg := SQLERRM;
1237:
1238: END dump_to_capacity_gtt;
1239:

Line 1336: x_return_status := FND_API.G_RET_STS_SUCCESS;

1332: p_tolerance_rec.program_update_date(l_index)
1333: );
1334:
1335: po_asl_api_pvt.log('dump_to_tolerance_gtt : rowcount :' || SQL%ROWCOUNT);
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337:
1338: po_asl_api_pvt.log('END ::: dump_to_tolerance_gtt');
1339: EXCEPTION
1340:

Line 1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1340:
1341: WHEN OTHERS THEN
1342:
1343: po_asl_api_pvt.log('dump_to_tolerance_gtt-when others exception ' || SQLERRM);
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: x_return_msg := SQLERRM;
1346:
1347: END dump_to_tolerance_gtt;
1348:

Line 1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1484: WHEN OTHERS THEN
1485:
1486: po_asl_api_pvt.log('derive_ids_past when others exception '
1487: || l_progress || ';' || SQLERRM);
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489: x_return_msg := SQLERRM;
1490:
1491: END derive_ids_past;
1492:

Line 1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1562: WHEN OTHERS THEN
1563:
1564: po_asl_api_pvt.log('derive_ids_podoc when others exception '
1565: || l_progress || ';' || SQLERRM);
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567: x_return_msg := SQLERRM;
1568:
1569: END derive_ids_podoc;
1570:

Line 1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1624: WHEN OTHERS THEN
1625:
1626: po_asl_api_pvt.log('derive_ids_ch_auth when others exception '
1627: || l_progress || ';' || SQLERRM);
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629: x_return_msg := SQLERRM;
1630:
1631: END derive_ids_ch_auth;
1632:

Line 1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1792:
1793: WHEN OTHERS THEN
1794:
1795: po_asl_api_pvt.log('derive_ids_asl_attr when others exception ' || SQLERRM);
1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797: x_return_msg := SQLERRM;
1798:
1799: END derive_ids_asl_attr;
1800:

Line 1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1841:
1842: WHEN OTHERS THEN
1843:
1844: po_asl_api_pvt.log('derive_ids_sup_cap when others exception ' || SQLERRM);
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846: x_return_msg := SQLERRM;
1847:
1848: END derive_ids_sup_cap;
1849:

Line 1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1890:
1891: WHEN OTHERS THEN
1892:
1893: po_asl_api_pvt.log('derive_ids_sup_tol when others exception ' || SQLERRM);
1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1895: x_return_msg := SQLERRM;
1896:
1897: END derive_ids_sup_tol;
1898:

Line 2046: x_return_status := FND_API.G_RET_STS_SUCCESS;

2042: x_return_msg => x_return_msg
2043: );
2044: END IF;
2045: l_progress := 100;
2046: x_return_status := FND_API.G_RET_STS_SUCCESS;
2047: po_asl_api_pvt.log('END ::: collect_invalids_in_asl_gt');
2048: EXCEPTION
2049:
2050: WHEN OTHERS THEN

Line 2054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2050: WHEN OTHERS THEN
2051:
2052: po_asl_api_pvt.log('collect_invalids_in_asl_gt when others exception '
2053: || l_progress || ';' || SQLERRM);
2054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2055: x_return_msg := SQLERRM;
2056:
2057: END collect_invalids_in_asl_gt;
2058:

Line 2278: x_return_status := FND_API.G_RET_STS_SUCCESS;

2274: x_return_msg => x_return_msg
2275: );
2276: END IF;
2277: l_progress := 100;
2278: x_return_status := FND_API.G_RET_STS_SUCCESS;
2279: po_asl_api_pvt.log('END ::: collect_invalids_in_aslattr_gt');
2280: EXCEPTION
2281:
2282: WHEN OTHERS THEN

Line 2286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2282: WHEN OTHERS THEN
2283:
2284: po_asl_api_pvt.log('collect_invalids_in_aslattr_gt when others exception '
2285: || l_progress || ';' || SQLERRM);
2286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2287: x_return_msg := SQLERRM;
2288:
2289: END collect_invalids_in_aslattr_gt;
2290:

Line 2568: x_return_status := FND_API.G_RET_STS_SUCCESS;

2564: x_return_msg => x_return_msg
2565: );
2566: END IF;
2567: l_progress := 100;
2568: x_return_status := FND_API.G_RET_STS_SUCCESS;
2569: po_asl_api_pvt.log('END ::: collect_invalids_in_other_gt');
2570: EXCEPTION
2571:
2572: WHEN OTHERS THEN

Line 2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2572: WHEN OTHERS THEN
2573:
2574: po_asl_api_pvt.log('collect_invalids_in_other_gt when others exception '
2575: || l_progress || ';' || SQLERRM);
2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2577: x_return_msg := SQLERRM;
2578:
2579: END collect_invalids_in_other_gt;
2580: