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 84: IF NOT FND_API.Compatible_API_Call(

80: -- Standard Start of API savepoint
81: SAVEPOINT Populate_ItemList_PVT;
82:
83: -- Check for call compatibility
84: IF NOT FND_API.Compatible_API_Call(
85: p_current_version_number => l_api_version,
86: p_caller_version_number => p_api_version,
87: p_api_name => l_api_name,
88: p_pkg_name => G_PKG_NAME

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: p_api_name => l_api_name,
88: p_pkg_name => G_PKG_NAME
89: )
90: THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: -- Check for message level threshold
95: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 429: x_return_status := FND_API.G_RET_STS_SUCCESS;

425: END IF;
426:
427: END IF; -- end if p_cost_enabled_only = 1
428:
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO Populate_ItemList_PVT;

Line 432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

428:
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO Populate_ItemList_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: WHEN OTHERS THEN
436: ROLLBACK TO Populate_ItemList_PVT;

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO Populate_ItemList_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: WHEN OTHERS THEN
436: ROLLBACK TO Populate_ItemList_PVT;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

433: ROLLBACK TO Populate_ItemList_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: WHEN OTHERS THEN
436: ROLLBACK TO Populate_ItemList_PVT;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
439: THEN
440: FND_MSG_PUB.Add_Exc_Msg(
441: p_pkg_name => G_PKG_NAME,

Line 466: IF NOT FND_API.Compatible_API_Call(

462: -- Standard Start of API savepoint
463: SAVEPOINT Populate_CostGroupList_PVT;
464:
465: -- Check for call compatibility
466: IF NOT FND_API.Compatible_API_Call(
467: p_current_version_number => l_api_version,
468: p_caller_version_number => p_api_version,
469: p_api_name => l_api_name,
470: p_pkg_name => G_PKG_NAME

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: p_api_name => l_api_name,
470: p_pkg_name => G_PKG_NAME
471: )
472: THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476: -- Check for message level threshold
477: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 610: x_return_status := FND_API.G_RET_STS_SUCCESS;

606: );
607: END IF;
608: END IF;
609:
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: EXCEPTION
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: ROLLBACK TO Populate_CostGroupList_PVT;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

608: END IF;
609:
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: EXCEPTION
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: ROLLBACK TO Populate_CostGroupList_PVT;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: WHEN OTHERS THEN
616: ROLLBACK TO Populate_CostGroupList_PVT;

Line 614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: EXCEPTION
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: ROLLBACK TO Populate_CostGroupList_PVT;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: WHEN OTHERS THEN
616: ROLLBACK TO Populate_CostGroupList_PVT;
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

613: ROLLBACK TO Populate_CostGroupList_PVT;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: WHEN OTHERS THEN
616: ROLLBACK TO Populate_CostGroupList_PVT;
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
619: THEN
620: FND_MSG_PUB.Add_Exc_Msg(
621: p_pkg_name => G_PKG_NAME,

Line 646: IF NOT FND_API.Compatible_API_Call(

642: -- Standard Start of API savepoint
643: SAVEPOINT Populate_SubinventoryList_PVT;
644:
645: -- Check for call compatibility
646: IF NOT FND_API.Compatible_API_Call(
647: p_current_version_number => l_api_version,
648: p_caller_version_number => p_api_version,
649: p_api_name => l_api_name,
650: p_pkg_name => G_PKG_NAME

Line 653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

649: p_api_name => l_api_name,
650: p_pkg_name => G_PKG_NAME
651: )
652: THEN
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END IF;
655:
656: -- Check for message level threshold
657: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 707: x_return_status := FND_API.G_RET_STS_SUCCESS;

703: ' subinventories into CSLT'
704: );
705: END IF;
706:
707: x_return_status := FND_API.G_RET_STS_SUCCESS;
708: EXCEPTION
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: ROLLBACK TO Populate_SubinventoryList_PVT;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

705: END IF;
706:
707: x_return_status := FND_API.G_RET_STS_SUCCESS;
708: EXCEPTION
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: ROLLBACK TO Populate_SubinventoryList_PVT;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: WHEN OTHERS THEN
713: ROLLBACK TO Populate_SubinventoryList_PVT;

Line 711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

707: x_return_status := FND_API.G_RET_STS_SUCCESS;
708: EXCEPTION
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: ROLLBACK TO Populate_SubinventoryList_PVT;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: WHEN OTHERS THEN
713: ROLLBACK TO Populate_SubinventoryList_PVT;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

710: ROLLBACK TO Populate_SubinventoryList_PVT;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: WHEN OTHERS THEN
713: ROLLBACK TO Populate_SubinventoryList_PVT;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
716: THEN
717: FND_MSG_PUB.Add_Exc_Msg(
718: p_pkg_name => G_PKG_NAME,

Line 745: IF NOT FND_API.Compatible_API_Call(

741: -- Standard Start of API savepoint
742: SAVEPOINT Calculate_OnhandQty_PVT;
743:
744: -- Check for call compatibility
745: IF NOT FND_API.Compatible_API_Call(
746: p_current_version_number => l_api_version,
747: p_caller_version_number => p_api_version,
748: p_api_name => l_api_name,
749: p_pkg_name => G_PKG_NAME

Line 752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

748: p_api_name => l_api_name,
749: p_pkg_name => G_PKG_NAME
750: )
751: THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754:
755: -- Check for message level threshold
756: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 1057: x_return_status := FND_API.G_RET_STS_SUCCESS;

1053: );
1054: END IF;
1055: END IF;
1056:
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO Calculate_OnhandQty_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1055: END IF;
1056:
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO Calculate_OnhandQty_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: WHEN OTHERS THEN
1063: ROLLBACK TO Calculate_OnhandQty_PVT;

Line 1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO Calculate_OnhandQty_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: WHEN OTHERS THEN
1063: ROLLBACK TO Calculate_OnhandQty_PVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1060: ROLLBACK TO Calculate_OnhandQty_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: WHEN OTHERS THEN
1063: ROLLBACK TO Calculate_OnhandQty_PVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1066: THEN
1067: FND_MSG_PUB.Add_Exc_Msg(
1068: p_pkg_name => G_PKG_NAME,

Line 1098: IF NOT FND_API.Compatible_API_Call(

1094: -- Standard Start of API savepoint
1095: SAVEPOINT Calculate_IntransitQty_PVT;
1096:
1097: -- Check for call compatibility
1098: IF NOT FND_API.Compatible_API_Call(
1099: p_current_version_number => l_api_version,
1100: p_caller_version_number => p_api_version,
1101: p_api_name => l_api_name,
1102: p_pkg_name => G_PKG_NAME

Line 1105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1101: p_api_name => l_api_name,
1102: p_pkg_name => G_PKG_NAME
1103: )
1104: THEN
1105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1106: END IF;
1107:
1108: -- Check for message level threshold
1109: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 3170: x_return_status := FND_API.G_RET_STS_SUCCESS;

3166: END IF; -- p_valuation_date IS NOT NULL
3167: END IF; -- p_shipment = 1
3168: END IF; -- p_detail = 1
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171:
3172: EXCEPTION
3173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3174: ROLLBACK TO Calculate_IntransitQty_PVT;

Line 3173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171:
3172: EXCEPTION
3173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3174: ROLLBACK TO Calculate_IntransitQty_PVT;
3175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3176: WHEN OTHERS THEN
3177: ROLLBACK TO Calculate_IntransitQty_PVT;

Line 3175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3171:
3172: EXCEPTION
3173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3174: ROLLBACK TO Calculate_IntransitQty_PVT;
3175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3176: WHEN OTHERS THEN
3177: ROLLBACK TO Calculate_IntransitQty_PVT;
3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3179: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3174: ROLLBACK TO Calculate_IntransitQty_PVT;
3175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3176: WHEN OTHERS THEN
3177: ROLLBACK TO Calculate_IntransitQty_PVT;
3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3179: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3180: THEN
3181: FND_MSG_PUB.Add_Exc_Msg(
3182: p_pkg_name => G_PKG_NAME,

Line 3207: IF NOT FND_API.Compatible_API_Call(

3203: -- Standard Start of API savepoint
3204: SAVEPOINT Calculate_ReceivingQty_PVT;
3205:
3206: -- Check for call compatibility
3207: IF NOT FND_API.Compatible_API_Call(
3208: p_current_version_number => l_api_version,
3209: p_caller_version_number => p_api_version,
3210: p_api_name => l_api_name,
3211: p_pkg_name => G_PKG_NAME

Line 3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3210: p_api_name => l_api_name,
3211: p_pkg_name => G_PKG_NAME
3212: )
3213: THEN
3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3215: END IF;
3216:
3217: -- Check for message level threshold
3218: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 3448: x_return_status := FND_API.G_RET_STS_SUCCESS;

3444: END IF;
3445:
3446: END IF; /* end if p_valuation_date is not null */
3447:
3448: x_return_status := FND_API.G_RET_STS_SUCCESS;
3449: EXCEPTION
3450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3451: ROLLBACK TO Calculate_ReceivingQty_PVT;
3452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3446: END IF; /* end if p_valuation_date is not null */
3447:
3448: x_return_status := FND_API.G_RET_STS_SUCCESS;
3449: EXCEPTION
3450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3451: ROLLBACK TO Calculate_ReceivingQty_PVT;
3452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3453: WHEN OTHERS THEN
3454: ROLLBACK TO Calculate_ReceivingQty_PVT;

Line 3452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3448: x_return_status := FND_API.G_RET_STS_SUCCESS;
3449: EXCEPTION
3450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3451: ROLLBACK TO Calculate_ReceivingQty_PVT;
3452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3453: WHEN OTHERS THEN
3454: ROLLBACK TO Calculate_ReceivingQty_PVT;
3455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3456: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 3455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3451: ROLLBACK TO Calculate_ReceivingQty_PVT;
3452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3453: WHEN OTHERS THEN
3454: ROLLBACK TO Calculate_ReceivingQty_PVT;
3455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3456: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3457: THEN
3458: FND_MSG_PUB.Add_Exc_Msg(
3459: p_pkg_name => G_PKG_NAME,

Line 3733: IF NOT FND_API.Compatible_API_Call(

3729: -- Standard Start of API savepoint
3730: SAVEPOINT Calculate_InventoryCost_PVT;
3731:
3732: -- Check for call compatibility
3733: IF NOT FND_API.Compatible_API_Call(
3734: p_current_version_number => l_api_version,
3735: p_caller_version_number => p_api_version,
3736: p_api_name => l_api_name,
3737: p_pkg_name => G_PKG_NAME

Line 3740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3736: p_api_name => l_api_name,
3737: p_pkg_name => G_PKG_NAME
3738: )
3739: THEN
3740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3741: END IF;
3742:
3743: -- Check for message level threshold
3744: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 4705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4701: x_msg_count => l_msg_count,
4702: x_msg_data => l_msg_data
4703: );
4704:
4705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4706: THEN
4707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4708: END IF;
4709:

Line 4707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4703: );
4704:
4705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4706: THEN
4707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4708: END IF;
4709:
4710: INSERT
4711: INTO cst_inv_cost_temp(

Line 4737: x_return_status := FND_API.G_RET_STS_SUCCESS;

4733: );
4734: END IF;
4735: CLOSE c_receiving;
4736:
4737: x_return_status := FND_API.G_RET_STS_SUCCESS;
4738: EXCEPTION
4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4740: ROLLBACK TO Calculate_InventoryCost_PVT;
4741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4735: CLOSE c_receiving;
4736:
4737: x_return_status := FND_API.G_RET_STS_SUCCESS;
4738: EXCEPTION
4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4740: ROLLBACK TO Calculate_InventoryCost_PVT;
4741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4742: WHEN OTHERS THEN
4743: ROLLBACK TO Calculate_InventoryCost_PVT;

Line 4741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4737: x_return_status := FND_API.G_RET_STS_SUCCESS;
4738: EXCEPTION
4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4740: ROLLBACK TO Calculate_InventoryCost_PVT;
4741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4742: WHEN OTHERS THEN
4743: ROLLBACK TO Calculate_InventoryCost_PVT;
4744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4745: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 4744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4740: ROLLBACK TO Calculate_InventoryCost_PVT;
4741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4742: WHEN OTHERS THEN
4743: ROLLBACK TO Calculate_InventoryCost_PVT;
4744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4745: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4746: THEN
4747: FND_MSG_PUB.Add_Exc_Msg(
4748: p_pkg_name => G_PKG_NAME,