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_DELREC_PVT dependencies on FND_API

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: -- Standard Start of API savepoint
190: SAVEPOINT create_update_delrec;
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195:
196: x_progress:='000';
197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 201: IF NOT FND_API.Compatible_API_Call

197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check API Call Compatibility');
199: END IF;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.Compatible_API_Call
202: (
203: p_current_version_number => l_api_version,
204: p_caller_version_number => p_api_version,
205: p_api_name => l_api_name,

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

205: p_api_name => l_api_name,
206: p_pkg_name => 'PO_DELREC_PVT'
207: )
208: THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: --: Call OTM if installed. Otherwise, execute
213: --old FTE integration

Line 272: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: l_action_rec.action_code := 'RECEIPT_ADD';
269: ELSIF (p_action = 'RECEIPT_HEADER_UPD') THEN
270: l_action_rec.action_code := 'RECEIPT_HEADER_UPD';
271: ELSE
272: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: -- : changed exception to log and early
274: -- return. Previously, calls to create_update_delrec were
275: -- filtered for the action, but OTM responds to a different
276: -- set of actions, so the filters have been removed.

Line 396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

392: p_line_location_id => p_line_location_id,
393: x_fte_rec => l_fte_rec
394: );
395: ELSE
396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
397: END IF; -- IF (l_action_rec.action_code = 'APPROVE_PO')
398:
399: x_progress:='020';
400: -- Bug 3581992 START

Line 420: p_init_msg_list => FND_API.G_FALSE,

416:
417: WSH_BULK_PROCESS_GRP.create_update_delivery_details
418: (
419: p_api_version_number => l_api_version,
420: p_init_msg_list => FND_API.G_FALSE,
421: p_commit => FND_API.G_FALSE,
422: p_action_prms => l_action_rec,
423: p_line_rec => l_fte_rec,
424: x_Out_Rec => l_fte_out_rec,

Line 421: p_commit => FND_API.G_FALSE,

417: WSH_BULK_PROCESS_GRP.create_update_delivery_details
418: (
419: p_api_version_number => l_api_version,
420: p_init_msg_list => FND_API.G_FALSE,
421: p_commit => FND_API.G_FALSE,
422: p_action_prms => l_action_rec,
423: p_line_rec => l_fte_rec,
424: x_Out_Rec => l_fte_out_rec,
425: x_return_status => x_return_status,

Line 492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

488: p_line_location_id => p_line_location_id,
489: x_fte_rec => l_fte_rec
490: );
491: ELSE
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF; -- IF (l_action_rec.action_code = 'APPROVE_PO')
494:
495: X_progress:='020';
496: -- Bug 3581992 START

Line 513: p_init_msg_list => FND_API.G_FALSE,

509:
510: WSH_BULK_PROCESS_GRP.create_update_delivery_details
511: (
512: p_api_version_number => l_api_version,
513: p_init_msg_list => FND_API.G_FALSE,
514: p_commit => FND_API.G_FALSE,
515: p_action_prms => l_action_rec,
516: p_line_rec => l_fte_rec,
517: x_Out_Rec => l_fte_out_rec,

Line 514: p_commit => FND_API.G_FALSE,

510: WSH_BULK_PROCESS_GRP.create_update_delivery_details
511: (
512: p_api_version_number => l_api_version,
513: p_init_msg_list => FND_API.G_FALSE,
514: p_commit => FND_API.G_FALSE,
515: p_action_prms => l_action_rec,
516: p_line_rec => l_fte_rec,
517: x_Out_Rec => l_fte_out_rec,
518: x_return_status => x_return_status,

Line 535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

531: -- Bug 3602512 END
532:
533: END IF; -- IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' )
534:
535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: FOR i IN 1..x_msg_count LOOP
537: x_msg_data := SUBSTR(x_msg_data || FND_MSG_PUB.Get(p_msg_index=>i, p_encoded =>'F' ), 1, 2000);
538: END LOOP;
539: RAISE FND_API.G_EXC_ERROR;

Line 539: RAISE FND_API.G_EXC_ERROR;

535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: FOR i IN 1..x_msg_count LOOP
537: x_msg_data := SUBSTR(x_msg_data || FND_MSG_PUB.Get(p_msg_index=>i, p_encoded =>'F' ), 1, 2000);
538: END LOOP;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: END IF; --IF (PO_OTM_INTEGRATION_PVT.is_otm_installed()) THEN
542: --
543:

Line 545: WHEN FND_API.G_EXC_ERROR THEN

541: END IF; --IF (PO_OTM_INTEGRATION_PVT.is_otm_installed()) THEN
542: --
543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: ROLLBACK TO create_update_delrec;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: IF g_fnd_debug = 'Y' THEN
549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: ROLLBACK TO create_update_delrec;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: IF g_fnd_debug = 'Y' THEN
549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||x_msg_data);
551: END IF;

Line 553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||x_msg_data);
551: END IF;
552: END IF;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO create_update_delrec;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF g_fnd_debug = 'Y' THEN
557: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

551: END IF;
552: END IF;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO create_update_delrec;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF g_fnd_debug = 'Y' THEN
557: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
558: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||sqlcode);
559: END IF;

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559: END IF;
560: END IF;
561: WHEN OTHERS THEN
562: ROLLBACK TO create_update_delrec;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF g_fnd_debug = 'Y' THEN
565: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
566: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||sqlcode);
567: END IF;

Line 1224: p_init_msg_list => FND_API.G_FALSE,

1220:
1221: WSH_BULK_PROCESS_GRP.create_update_delivery_details
1222: (
1223: p_api_version_number => p_api_version,
1224: p_init_msg_list => FND_API.G_FALSE,
1225: p_commit => FND_API.G_FALSE,
1226: p_action_prms => p_action_rec,
1227: p_line_rec => x_fte_rec,
1228: x_Out_Rec => l_fte_out_rec,

Line 1225: p_commit => FND_API.G_FALSE,

1221: WSH_BULK_PROCESS_GRP.create_update_delivery_details
1222: (
1223: p_api_version_number => p_api_version,
1224: p_init_msg_list => FND_API.G_FALSE,
1225: p_commit => FND_API.G_FALSE,
1226: p_action_prms => p_action_rec,
1227: p_line_rec => x_fte_rec,
1228: x_Out_Rec => l_fte_out_rec,
1229: x_return_status => x_return_status,

Line 1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1237: EXCEPTION
1238: WHEN NO_DATA_FOUND THEN
1239: NULL;
1240: WHEN OTHERS THEN
1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_msg_data := 'Errm ' || sqlerrm;
1243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1244: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', l_msg_data);
1245: END IF;

Line 1297: IF NOT FND_API.Compatible_API_Call

1293: l_api_version CONSTANT NUMBER := 1.0;
1294:
1295: BEGIN
1296: -- Standard call to check for call compatibility.
1297: IF NOT FND_API.Compatible_API_Call
1298: (
1299: p_current_version_number => l_api_version,
1300: p_caller_version_number => p_api_version,
1301: p_api_name => l_api_name,

Line 1305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1301: p_api_name => l_api_name,
1302: p_pkg_name => 'PO_DELREC_PVT'
1303: )
1304: THEN
1305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1306: END IF;
1307:
1308: -- The following is for query data for delivery record from:
1309: -- Approved Standard PO, Standard PO referencing GA or Contract

Line 1468: x_return_status := FND_API.G_RET_STS_ERROR;

1464: EXCEPTION
1465: WHEN NO_DATA_FOUND THEN
1466: NULL;
1467: WHEN OTHERS THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: END;
1470:
1471:
1472:

Line 1519: IF NOT FND_API.Compatible_API_Call

1515: l_api_version CONSTANT NUMBER := 1.0;
1516:
1517: BEGIN
1518: -- Standard call to check for call compatibility.
1519: IF NOT FND_API.Compatible_API_Call
1520: (
1521: p_current_version_number => l_api_version,
1522: p_caller_version_number => p_api_version,
1523: p_api_name => l_api_name,

Line 1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1523: p_api_name => l_api_name,
1524: p_pkg_name => 'PO_DELREC_PVT'
1525: )
1526: THEN
1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1528: END IF;
1529:
1530: -- The following is for query data for delivery record from:
1531: -- Cancelled Standard PO, Standard PO referencing GA or Contract

Line 1689: x_return_status := FND_API.G_RET_STS_ERROR;

1685: EXCEPTION
1686: WHEN NO_DATA_FOUND THEN
1687: NULL;
1688: WHEN OTHERS THEN
1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: END;
1691:
1692:
1693:

Line 1740: IF NOT FND_API.Compatible_API_Call

1736: l_api_version CONSTANT NUMBER := 1.0;
1737:
1738: BEGIN
1739: -- Standard call to check for call compatibility.
1740: IF NOT FND_API.Compatible_API_Call
1741: (
1742: p_current_version_number => l_api_version,
1743: p_caller_version_number => p_api_version,
1744: p_api_name => l_api_name,

Line 1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1744: p_api_name => l_api_name,
1745: p_pkg_name => 'PO_DELREC_PVT'
1746: )
1747: THEN
1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749: END IF;
1750:
1751: -- The following is for query data for delivery record from:
1752: -- Opened Standard PO, Standard PO referencing GA or Contract

Line 1911: x_return_status := FND_API.G_RET_STS_ERROR;

1907: EXCEPTION
1908: WHEN NO_DATA_FOUND THEN
1909: NULL;
1910: WHEN OTHERS THEN
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: END;
1913:
1914:
1915:

Line 1962: IF NOT FND_API.Compatible_API_Call

1958: l_api_version CONSTANT NUMBER := 1.0;
1959:
1960: BEGIN
1961: -- Standard call to check for call compatibility.
1962: IF NOT FND_API.Compatible_API_Call
1963: (
1964: p_current_version_number => l_api_version,
1965: p_caller_version_number => p_api_version,
1966: p_api_name => l_api_name,

Line 1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1966: p_api_name => l_api_name,
1967: p_pkg_name => 'PO_DELREC_PVT'
1968: )
1969: THEN
1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1971: END IF;
1972:
1973: -- The following is for query data for delivery record from:
1974: -- Closed Standard PO, Standard PO referencing GA or Contract

Line 2133: x_return_status := FND_API.G_RET_STS_ERROR;

2129: EXCEPTION
2130: WHEN NO_DATA_FOUND THEN
2131: NULL;
2132: WHEN OTHERS THEN
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134: END;
2135:
2136:
2137:

Line 2184: IF NOT FND_API.Compatible_API_Call

2180: l_api_version CONSTANT NUMBER := 1.0;
2181:
2182: BEGIN
2183: -- Standard call to check for call compatibility.
2184: IF NOT FND_API.Compatible_API_Call
2185: (
2186: p_current_version_number => l_api_version,
2187: p_caller_version_number => p_api_version,
2188: p_api_name => l_api_name,

Line 2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2188: p_api_name => l_api_name,
2189: p_pkg_name => 'PO_DELREC_PVT'
2190: )
2191: THEN
2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2193: END IF;
2194:
2195: -- The following is for query data for delivery record from:
2196: -- Finally Closed Standard PO, Standard PO referencing GA or Contract

Line 2354: x_return_status := FND_API.G_RET_STS_ERROR;

2350: EXCEPTION
2351: WHEN NO_DATA_FOUND THEN
2352: NULL;
2353: WHEN OTHERS THEN
2354: x_return_status := FND_API.G_RET_STS_ERROR;
2355: END;
2356:
2357:
2358:

Line 2402: IF NOT FND_API.Compatible_API_Call

2398: l_api_version CONSTANT NUMBER := 1.0;
2399:
2400: BEGIN
2401: -- Standard call to check for call compatibility.
2402: IF NOT FND_API.Compatible_API_Call
2403: (
2404: p_current_version_number => l_api_version,
2405: p_caller_version_number => p_api_version,
2406: p_api_name => l_api_name,

Line 2410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2406: p_api_name => l_api_name,
2407: p_pkg_name => 'PO_DELREC_PVT'
2408: )
2409: THEN
2410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2411: END IF;
2412:
2413: -- The following is for query data for delivery record from:
2414: -- Approved Blanket Release

Line 2581: x_return_status := FND_API.G_RET_STS_ERROR;

2577: EXCEPTION
2578: WHEN NO_DATA_FOUND THEN
2579: NULL;
2580: WHEN OTHERS THEN
2581: x_return_status := FND_API.G_RET_STS_ERROR;
2582: END;
2583:
2584:
2585:

Line 2630: IF NOT FND_API.Compatible_API_Call

2626: l_api_version CONSTANT NUMBER := 1.0;
2627:
2628: BEGIN
2629: -- Standard call to check for call compatibility.
2630: IF NOT FND_API.Compatible_API_Call
2631: (
2632: p_current_version_number => l_api_version,
2633: p_caller_version_number => p_api_version,
2634: p_api_name => l_api_name,

Line 2638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2634: p_api_name => l_api_name,
2635: p_pkg_name => 'PO_DELREC_PVT'
2636: )
2637: THEN
2638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2639: END IF;
2640:
2641: -- The following is for query data for delivery record from:
2642: -- Cancelled Blanket Release

Line 2808: x_return_status := FND_API.G_RET_STS_ERROR;

2804: EXCEPTION
2805: WHEN NO_DATA_FOUND THEN
2806: NULL;
2807: WHEN OTHERS THEN
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: END;
2810:
2811:
2812:

Line 2856: IF NOT FND_API.Compatible_API_Call

2852: l_api_version CONSTANT NUMBER := 1.0;
2853:
2854: BEGIN
2855: -- Standard call to check for call compatibility.
2856: IF NOT FND_API.Compatible_API_Call
2857: (
2858: p_current_version_number => l_api_version,
2859: p_caller_version_number => p_api_version,
2860: p_api_name => l_api_name,

Line 2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2860: p_api_name => l_api_name,
2861: p_pkg_name => 'PO_DELREC_PVT'
2862: )
2863: THEN
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: END IF;
2866:
2867: -- The following is for query data for delivery record from:
2868: -- Opened Blanket Release

Line 3035: x_return_status := FND_API.G_RET_STS_ERROR;

3031: EXCEPTION
3032: WHEN NO_DATA_FOUND THEN
3033: NULL;
3034: WHEN OTHERS THEN
3035: x_return_status := FND_API.G_RET_STS_ERROR;
3036: END;
3037:
3038:
3039:

Line 3083: IF NOT FND_API.Compatible_API_Call

3079: l_api_version CONSTANT NUMBER := 1.0;
3080:
3081: BEGIN
3082: -- Standard call to check for call compatibility.
3083: IF NOT FND_API.Compatible_API_Call
3084: (
3085: p_current_version_number => l_api_version,
3086: p_caller_version_number => p_api_version,
3087: p_api_name => l_api_name,

Line 3091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3087: p_api_name => l_api_name,
3088: p_pkg_name => 'PO_DELREC_PVT'
3089: )
3090: THEN
3091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3092: END IF;
3093:
3094: -- The following is for query data for delivery record from:
3095: -- Closed Blanket Release

Line 3262: x_return_status := FND_API.G_RET_STS_ERROR;

3258: EXCEPTION
3259: WHEN NO_DATA_FOUND THEN
3260: NULL;
3261: WHEN OTHERS THEN
3262: x_return_status := FND_API.G_RET_STS_ERROR;
3263: END;
3264:
3265:
3266:

Line 3312: IF NOT FND_API.Compatible_API_Call

3308: l_api_version CONSTANT NUMBER := 1.0;
3309:
3310: BEGIN
3311: -- Standard call to check for call compatibility.
3312: IF NOT FND_API.Compatible_API_Call
3313: (
3314: p_current_version_number => l_api_version,
3315: p_caller_version_number => p_api_version,
3316: p_api_name => l_api_name,

Line 3320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3316: p_api_name => l_api_name,
3317: p_pkg_name => 'PO_DELREC_PVT'
3318: )
3319: THEN
3320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3321: END IF;
3322:
3323: -- The following is for query data for delivery record from:
3324: --Finally Closed Blanket Release

Line 3490: x_return_status := FND_API.G_RET_STS_ERROR;

3486: EXCEPTION
3487: WHEN NO_DATA_FOUND THEN
3488: NULL;
3489: WHEN OTHERS THEN
3490: x_return_status := FND_API.G_RET_STS_ERROR;
3491: END;
3492:
3493: -- Bug 3581992 START
3494: -------------------------------------------------------------------------------