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

Line 47: IF NOT FND_API.Compatible_API_Call(

43: -- Standard Start of API savepoint
44: SAVEPOINT Populate_ItemList_PVT;
45:
46: -- Check for call compatibility
47: IF NOT FND_API.Compatible_API_Call(
48: p_current_version_number => l_api_version,
49: p_caller_version_number => p_api_version,
50: p_api_name => l_api_name,
51: p_pkg_name => G_PKG_NAME

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

50: p_api_name => l_api_name,
51: p_pkg_name => G_PKG_NAME
52: )
53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: -- Check for message level threshold
58: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 391: x_return_status := FND_API.G_RET_STS_SUCCESS;

387: END IF;
388:
389: END IF; -- end if p_cost_enabled_only = 1
390:
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO Populate_ItemList_PVT;

Line 394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

390:
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO Populate_ItemList_PVT;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: WHEN OTHERS THEN
398: ROLLBACK TO Populate_ItemList_PVT;

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO Populate_ItemList_PVT;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: WHEN OTHERS THEN
398: ROLLBACK TO Populate_ItemList_PVT;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: ROLLBACK TO Populate_ItemList_PVT;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: WHEN OTHERS THEN
398: ROLLBACK TO Populate_ItemList_PVT;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg(
403: p_pkg_name => G_PKG_NAME,

Line 428: IF NOT FND_API.Compatible_API_Call(

424: -- Standard Start of API savepoint
425: SAVEPOINT Populate_CostGroupList_PVT;
426:
427: -- Check for call compatibility
428: IF NOT FND_API.Compatible_API_Call(
429: p_current_version_number => l_api_version,
430: p_caller_version_number => p_api_version,
431: p_api_name => l_api_name,
432: p_pkg_name => G_PKG_NAME

Line 435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431: p_api_name => l_api_name,
432: p_pkg_name => G_PKG_NAME
433: )
434: THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: -- Check for message level threshold
439: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: );
547: END IF;
548: END IF;
549:
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: EXCEPTION
552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
553: ROLLBACK TO Populate_CostGroupList_PVT;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

548: END IF;
549:
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: EXCEPTION
552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
553: ROLLBACK TO Populate_CostGroupList_PVT;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: WHEN OTHERS THEN
556: ROLLBACK TO Populate_CostGroupList_PVT;

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: EXCEPTION
552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
553: ROLLBACK TO Populate_CostGroupList_PVT;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: WHEN OTHERS THEN
556: ROLLBACK TO Populate_CostGroupList_PVT;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

553: ROLLBACK TO Populate_CostGroupList_PVT;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: WHEN OTHERS THEN
556: ROLLBACK TO Populate_CostGroupList_PVT;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
559: THEN
560: FND_MSG_PUB.Add_Exc_Msg(
561: p_pkg_name => G_PKG_NAME,

Line 586: IF NOT FND_API.Compatible_API_Call(

582: -- Standard Start of API savepoint
583: SAVEPOINT Populate_SubinventoryList_PVT;
584:
585: -- Check for call compatibility
586: IF NOT FND_API.Compatible_API_Call(
587: p_current_version_number => l_api_version,
588: p_caller_version_number => p_api_version,
589: p_api_name => l_api_name,
590: p_pkg_name => G_PKG_NAME

Line 593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

589: p_api_name => l_api_name,
590: p_pkg_name => G_PKG_NAME
591: )
592: THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:
596: -- Check for message level threshold
597: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 647: x_return_status := FND_API.G_RET_STS_SUCCESS;

643: ' subinventories into CSLT'
644: );
645: END IF;
646:
647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: EXCEPTION
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Populate_SubinventoryList_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

645: END IF;
646:
647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: EXCEPTION
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Populate_SubinventoryList_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: WHEN OTHERS THEN
653: ROLLBACK TO Populate_SubinventoryList_PVT;

Line 651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: EXCEPTION
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Populate_SubinventoryList_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: WHEN OTHERS THEN
653: ROLLBACK TO Populate_SubinventoryList_PVT;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

650: ROLLBACK TO Populate_SubinventoryList_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: WHEN OTHERS THEN
653: ROLLBACK TO Populate_SubinventoryList_PVT;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
656: THEN
657: FND_MSG_PUB.Add_Exc_Msg(
658: p_pkg_name => G_PKG_NAME,

Line 684: IF NOT FND_API.Compatible_API_Call(

680: -- Standard Start of API savepoint
681: SAVEPOINT Calculate_OnhandQty_PVT;
682:
683: -- Check for call compatibility
684: IF NOT FND_API.Compatible_API_Call(
685: p_current_version_number => l_api_version,
686: p_caller_version_number => p_api_version,
687: p_api_name => l_api_name,
688: p_pkg_name => G_PKG_NAME

Line 691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

687: p_api_name => l_api_name,
688: p_pkg_name => G_PKG_NAME
689: )
690: THEN
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693:
694: -- Check for message level threshold
695: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 982: x_return_status := FND_API.G_RET_STS_SUCCESS;

978: );
979: END IF;
980: END IF;
981:
982: x_return_status := FND_API.G_RET_STS_SUCCESS;
983: EXCEPTION
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: ROLLBACK TO Calculate_OnhandQty_PVT;
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

980: END IF;
981:
982: x_return_status := FND_API.G_RET_STS_SUCCESS;
983: EXCEPTION
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: ROLLBACK TO Calculate_OnhandQty_PVT;
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: WHEN OTHERS THEN
988: ROLLBACK TO Calculate_OnhandQty_PVT;

Line 986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

982: x_return_status := FND_API.G_RET_STS_SUCCESS;
983: EXCEPTION
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: ROLLBACK TO Calculate_OnhandQty_PVT;
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: WHEN OTHERS THEN
988: ROLLBACK TO Calculate_OnhandQty_PVT;
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

985: ROLLBACK TO Calculate_OnhandQty_PVT;
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: WHEN OTHERS THEN
988: ROLLBACK TO Calculate_OnhandQty_PVT;
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
991: THEN
992: FND_MSG_PUB.Add_Exc_Msg(
993: p_pkg_name => G_PKG_NAME,

Line 1023: IF NOT FND_API.Compatible_API_Call(

1019: -- Standard Start of API savepoint
1020: SAVEPOINT Calculate_IntransitQty_PVT;
1021:
1022: -- Check for call compatibility
1023: IF NOT FND_API.Compatible_API_Call(
1024: p_current_version_number => l_api_version,
1025: p_caller_version_number => p_api_version,
1026: p_api_name => l_api_name,
1027: p_pkg_name => G_PKG_NAME

Line 1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1026: p_api_name => l_api_name,
1027: p_pkg_name => G_PKG_NAME
1028: )
1029: THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032:
1033: -- Check for message level threshold
1034: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 3077: x_return_status := FND_API.G_RET_STS_SUCCESS;

3073: END IF; -- p_valuation_date IS NOT NULL
3074: END IF; -- p_shipment = 1
3075: END IF; -- p_detail = 1
3076:
3077: x_return_status := FND_API.G_RET_STS_SUCCESS;
3078:
3079: EXCEPTION
3080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3081: ROLLBACK TO Calculate_IntransitQty_PVT;

Line 3080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3076:
3077: x_return_status := FND_API.G_RET_STS_SUCCESS;
3078:
3079: EXCEPTION
3080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3081: ROLLBACK TO Calculate_IntransitQty_PVT;
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3083: WHEN OTHERS THEN
3084: ROLLBACK TO Calculate_IntransitQty_PVT;

Line 3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3078:
3079: EXCEPTION
3080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3081: ROLLBACK TO Calculate_IntransitQty_PVT;
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3083: WHEN OTHERS THEN
3084: ROLLBACK TO Calculate_IntransitQty_PVT;
3085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3086: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3081: ROLLBACK TO Calculate_IntransitQty_PVT;
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3083: WHEN OTHERS THEN
3084: ROLLBACK TO Calculate_IntransitQty_PVT;
3085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3086: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3087: THEN
3088: FND_MSG_PUB.Add_Exc_Msg(
3089: p_pkg_name => G_PKG_NAME,

Line 3114: IF NOT FND_API.Compatible_API_Call(

3110: -- Standard Start of API savepoint
3111: SAVEPOINT Calculate_ReceivingQty_PVT;
3112:
3113: -- Check for call compatibility
3114: IF NOT FND_API.Compatible_API_Call(
3115: p_current_version_number => l_api_version,
3116: p_caller_version_number => p_api_version,
3117: p_api_name => l_api_name,
3118: p_pkg_name => G_PKG_NAME

Line 3121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3117: p_api_name => l_api_name,
3118: p_pkg_name => G_PKG_NAME
3119: )
3120: THEN
3121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3122: END IF;
3123:
3124: -- Check for message level threshold
3125: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 3351: x_return_status := FND_API.G_RET_STS_SUCCESS;

3347: END IF;
3348:
3349: END IF; /* end if p_valuation_date is not null */
3350:
3351: x_return_status := FND_API.G_RET_STS_SUCCESS;
3352: EXCEPTION
3353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3354: ROLLBACK TO Calculate_ReceivingQty_PVT;
3355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3349: END IF; /* end if p_valuation_date is not null */
3350:
3351: x_return_status := FND_API.G_RET_STS_SUCCESS;
3352: EXCEPTION
3353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3354: ROLLBACK TO Calculate_ReceivingQty_PVT;
3355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3356: WHEN OTHERS THEN
3357: ROLLBACK TO Calculate_ReceivingQty_PVT;

Line 3355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3351: x_return_status := FND_API.G_RET_STS_SUCCESS;
3352: EXCEPTION
3353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3354: ROLLBACK TO Calculate_ReceivingQty_PVT;
3355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3356: WHEN OTHERS THEN
3357: ROLLBACK TO Calculate_ReceivingQty_PVT;
3358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3359: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3354: ROLLBACK TO Calculate_ReceivingQty_PVT;
3355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3356: WHEN OTHERS THEN
3357: ROLLBACK TO Calculate_ReceivingQty_PVT;
3358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3359: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3360: THEN
3361: FND_MSG_PUB.Add_Exc_Msg(
3362: p_pkg_name => G_PKG_NAME,

Line 3554: IF NOT FND_API.Compatible_API_Call(

3550: -- Standard Start of API savepoint
3551: SAVEPOINT Calculate_InventoryCost_PVT;
3552:
3553: -- Check for call compatibility
3554: IF NOT FND_API.Compatible_API_Call(
3555: p_current_version_number => l_api_version,
3556: p_caller_version_number => p_api_version,
3557: p_api_name => l_api_name,
3558: p_pkg_name => G_PKG_NAME

Line 3561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3557: p_api_name => l_api_name,
3558: p_pkg_name => G_PKG_NAME
3559: )
3560: THEN
3561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3562: END IF;
3563:
3564: -- Check for message level threshold
3565: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 4677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4673: x_msg_count => l_msg_count,
4674: x_msg_data => l_msg_data
4675: );
4676:
4677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4678: THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: END IF;
4681:

Line 4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4675: );
4676:
4677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4678: THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: END IF;
4681:
4682: INSERT
4683: INTO cst_inv_cost_temp(

Line 4709: x_return_status := FND_API.G_RET_STS_SUCCESS;

4705: );
4706: END IF;
4707: CLOSE c_receiving;
4708:
4709: x_return_status := FND_API.G_RET_STS_SUCCESS;
4710: EXCEPTION
4711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4712: ROLLBACK TO Calculate_InventoryCost_PVT;
4713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4707: CLOSE c_receiving;
4708:
4709: x_return_status := FND_API.G_RET_STS_SUCCESS;
4710: EXCEPTION
4711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4712: ROLLBACK TO Calculate_InventoryCost_PVT;
4713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4714: WHEN OTHERS THEN
4715: ROLLBACK TO Calculate_InventoryCost_PVT;

Line 4713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4709: x_return_status := FND_API.G_RET_STS_SUCCESS;
4710: EXCEPTION
4711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4712: ROLLBACK TO Calculate_InventoryCost_PVT;
4713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4714: WHEN OTHERS THEN
4715: ROLLBACK TO Calculate_InventoryCost_PVT;
4716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4717: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4712: ROLLBACK TO Calculate_InventoryCost_PVT;
4713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4714: WHEN OTHERS THEN
4715: ROLLBACK TO Calculate_InventoryCost_PVT;
4716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4717: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4718: THEN
4719: FND_MSG_PUB.Add_Exc_Msg(
4720: p_pkg_name => G_PKG_NAME,