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.MTL_CCEOI_PROCESS_PVT dependencies on STANDARD

Line 1793: -- Standard start of API savepoint

1789: l_return_status VARCHAR2(1);
1790: l_msg_count NUMBER;
1791: l_msg_data VARCHAR2(1000);
1792: BEGIN
1793: -- Standard start of API savepoint
1794: SAVEPOINT Calculate_Adjustment;
1795: --
1796: -- Standard Call to check for call compatibility
1797: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 1796: -- Standard Call to check for call compatibility

1792: BEGIN
1793: -- Standard start of API savepoint
1794: SAVEPOINT Calculate_Adjustment;
1795: --
1796: -- Standard Call to check for call compatibility
1797: IF NOT FND_API.Compatible_API_Call(l_api_version
1798: , p_api_version
1799: , l_api_name
1800: , G_PKG_NAME) THEN

Line 2116: -- Standard check of p_commit

2112: */
2113: --
2114: --
2115: -- END of API body
2116: -- Standard check of p_commit
2117: IF FND_API.to_Boolean(p_commit) THEN
2118: COMMIT;
2119: END IF;
2120: -- Standard call to get message count and if count is 1, get message info

Line 2120: -- Standard call to get message count and if count is 1, get message info

2116: -- Standard check of p_commit
2117: IF FND_API.to_Boolean(p_commit) THEN
2118: COMMIT;
2119: END IF;
2120: -- Standard call to get message count and if count is 1, get message info
2121: FND_MSG_PUB.Count_And_Get
2122: (p_count => x_msg_count
2123: , p_data => x_msg_data);
2124: EXCEPTION

Line 2467: SELECT STANDARD_OPERATION_ID INTO l_user_tt_id

2463: END IF;
2464:
2465: /*10268469- added code to populate user task type for cycle count*/
2466: BEGIN
2467: SELECT STANDARD_OPERATION_ID INTO l_user_tt_id
2468: FROM BOM_STANDARD_OPERATIONS
2469: WHERE WMS_TASK_TYPE = 3
2470: AND ORGANIZATION_ID = p_interface_rec.ORGANIZATION_ID
2471: AND ROWNUM = 1;

Line 2468: FROM BOM_STANDARD_OPERATIONS

2464:
2465: /*10268469- added code to populate user task type for cycle count*/
2466: BEGIN
2467: SELECT STANDARD_OPERATION_ID INTO l_user_tt_id
2468: FROM BOM_STANDARD_OPERATIONS
2469: WHERE WMS_TASK_TYPE = 3
2470: AND ORGANIZATION_ID = p_interface_rec.ORGANIZATION_ID
2471: AND ROWNUM = 1;
2472: EXCEPTION

Line 2574: , STANDARD_OPERATION_ID

2570: , SECONDARY_SYSTEM_QTY_CURRENT
2571: , SECONDARY_SYSTEM_QTY_PRIOR
2572: , SECONDARY_ADJUSTMENT_QUANTITY
2573: -- END INVCONV
2574: , STANDARD_OPERATION_ID
2575: )
2576: VALUES
2577: ( /* Bug 7517428-Passing the cost group id to insert in MCCE*/
2578: MTL_CCEOI_VAR_PVT.G_COST_GROUP_ID

Line 3352: -- Standard start of API savepoint

3348: DECLARE
3349: L_api_version CONSTANT NUMBER := 0.9;
3350: L_api_name CONSTANT VARCHAR2(30) := 'Set_CCExport';
3351: BEGIN
3352: -- Standard start of API savepoint
3353: SAVEPOINT Set_CCExport;
3354: --
3355: -- Standard Call to check for call compatibility
3356: IF (l_debug = 1) THEN

Line 3355: -- Standard Call to check for call compatibility

3351: BEGIN
3352: -- Standard start of API savepoint
3353: SAVEPOINT Set_CCExport;
3354: --
3355: -- Standard Call to check for call compatibility
3356: IF (l_debug = 1) THEN
3357: MDEBUG( 'SetCCExport : Before API');
3358: END IF;
3359: IF NOT FND_API.Compatible_API_Call(

Line 3415: -- Standard check of p_commit

3411: RAISE FND_API.G_EXC_ERROR;
3412: END IF;
3413: --
3414: -- END of API body
3415: -- Standard check of p_commit
3416: IF FND_API.to_Boolean(p_commit) THEN
3417: COMMIT;
3418: END IF;
3419: -- --

Line 3420: -- Standard call to get message count and if count is 1, get message info

3416: IF FND_API.to_Boolean(p_commit) THEN
3417: COMMIT;
3418: END IF;
3419: -- --
3420: -- Standard call to get message count and if count is 1, get message info
3421: FND_MSG_PUB.Count_And_Get
3422: (p_count => x_msg_count
3423: , p_data => x_msg_data);
3424: EXCEPTION

Line 3526: -- Standard start of API savepoint

3522: L_status NUMBER;
3523: L_delete NUMBER;
3524: BEGIN
3525:
3526: -- Standard start of API savepoint
3527: SAVEPOINT SET_CCEOIVALID;
3528: --
3529: -- Standard Call to check for call compatibility
3530: IF NOT FND_API.Compatible_API_Call(

Line 3529: -- Standard Call to check for call compatibility

3525:
3526: -- Standard start of API savepoint
3527: SAVEPOINT SET_CCEOIVALID;
3528: --
3529: -- Standard Call to check for call compatibility
3530: IF NOT FND_API.Compatible_API_Call(
3531: l_api_version, p_api_version
3532: , l_api_name
3533: , G_PKG_NAME) THEN

Line 3583: -- Standard check of p_commit

3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581: --
3582: -- END of API body
3583: -- Standard check of p_commit
3584: IF FND_API.to_Boolean(p_commit) THEN
3585: COMMIT;
3586: END IF;
3587: -- --

Line 3588: -- Standard call to get message count and if count is 1, get message info

3584: IF FND_API.to_Boolean(p_commit) THEN
3585: COMMIT;
3586: END IF;
3587: -- --
3588: -- Standard call to get message count and if count is 1, get message info
3589: FND_MSG_PUB.Count_And_Get
3590: (p_count => x_msg_count
3591: , p_data => x_msg_data);
3592: EXCEPTION

Line 3700: -- Standard start of API savepoint

3696: --
3697: L_api_version CONSTANT NUMBER := 0.9;
3698: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CHeader';
3699: BEGIN
3700: -- Standard start of API savepoint
3701: SAVEPOINT Validate_CHeader;
3702: --
3703: -- Standard Call to check for call compatibility
3704: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 3703: -- Standard Call to check for call compatibility

3699: BEGIN
3700: -- Standard start of API savepoint
3701: SAVEPOINT Validate_CHeader;
3702: --
3703: -- Standard Call to check for call compatibility
3704: IF NOT FND_API.Compatible_API_Call(l_api_version
3705: , p_api_version
3706: , l_api_name
3707: , G_PKG_NAME) THEN

Line 3778: -- Standard check of p_commit

3774: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.INVENTORY_ADJUSTMENT_ACCOUNT;
3775: END IF;
3776: --
3777: -- END of API body
3778: -- Standard check of p_commit
3779: IF FND_API.to_Boolean(p_commit) THEN
3780: COMMIT;
3781: END IF;
3782: -- Standard call to get message count and if count is 1, get message info

Line 3782: -- Standard call to get message count and if count is 1, get message info

3778: -- Standard check of p_commit
3779: IF FND_API.to_Boolean(p_commit) THEN
3780: COMMIT;
3781: END IF;
3782: -- Standard call to get message count and if count is 1, get message info
3783: FND_MSG_PUB.Count_And_Get
3784: (p_count => x_msg_count
3785: , p_data => x_msg_data);
3786: EXCEPTION

Line 3886: -- Standard start of API savepoint

3882: --
3883: L_api_version CONSTANT NUMBER := 0.9;
3884: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CountListSeq';
3885: BEGIN
3886: -- Standard start of API savepoint
3887: SAVEPOINT Validate_CountListSeq;
3888: --
3889: -- Standard Call to check for call compatibility
3890: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 3889: -- Standard Call to check for call compatibility

3885: BEGIN
3886: -- Standard start of API savepoint
3887: SAVEPOINT Validate_CountListSeq;
3888: --
3889: -- Standard Call to check for call compatibility
3890: IF NOT FND_API.Compatible_API_Call(l_api_version
3891: , p_api_version
3892: , l_api_name
3893: , G_PKG_NAME) THEN

Line 3963: -- Standard check of p_commit

3959: END IF;
3960: --
3961: --
3962: -- END of API body
3963: -- Standard check of p_commit
3964: IF FND_API.to_Boolean(p_commit) THEN
3965: COMMIT;
3966: END IF;
3967: -- Standard call to get message count and if count is 1, get message info

Line 3967: -- Standard call to get message count and if count is 1, get message info

3963: -- Standard check of p_commit
3964: IF FND_API.to_Boolean(p_commit) THEN
3965: COMMIT;
3966: END IF;
3967: -- Standard call to get message count and if count is 1, get message info
3968: FND_MSG_PUB.Count_And_Get
3969: (p_count => x_msg_count
3970: , p_data => x_msg_data);
3971: EXCEPTION

Line 4129: -- Standard start of API savepoint

4125: --
4126: L_api_version CONSTANT NUMBER := 0.9;
4127: L_api_name CONSTANT VARCHAR2(30) := 'Validate_ItemSKU';
4128: BEGIN
4129: -- Standard start of API savepoint
4130: SAVEPOINT Validate_ItemSKU;
4131: --
4132: -- Standard Call to check for call compatibility
4133: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 4132: -- Standard Call to check for call compatibility

4128: BEGIN
4129: -- Standard start of API savepoint
4130: SAVEPOINT Validate_ItemSKU;
4131: --
4132: -- Standard Call to check for call compatibility
4133: IF NOT FND_API.Compatible_API_Call(l_api_version
4134: , p_api_version
4135: , l_api_name
4136: , G_PKG_NAME) THEN

Line 4789: -- Standard check of p_commit

4785: IF (l_debug = 1) THEN
4786: MDEBUG( 'Process: In Validate_ItemSKU call-5 ');
4787: END IF;
4788: -- END of API body
4789: -- Standard check of p_commit
4790: IF FND_API.to_Boolean(p_commit) THEN
4791: COMMIT;
4792: END IF;
4793: IF (l_debug = 1) THEN

Line 4796: -- Standard call to get message count and if count is 1, get message info

4792: END IF;
4793: IF (l_debug = 1) THEN
4794: MDEBUG( 'Process: In Validate_ItemSKU call-6 ');
4795: END IF;
4796: -- Standard call to get message count and if count is 1, get message info
4797: FND_MSG_PUB.Count_And_Get
4798: (p_count => x_msg_count
4799: , p_data => x_msg_data);
4800: IF (l_debug = 1) THEN

Line 4957: -- Standard start of API savepoint

4953: --
4954: L_api_version CONSTANT NUMBER := 0.9;
4955: L_api_name CONSTANT VARCHAR2(30) := 'Validate_UOMQuantity';
4956: BEGIN
4957: -- Standard start of API savepoint
4958: SAVEPOINT Validate_UOMQuantity;
4959: --
4960: -- Standard Call to check for call compatibility
4961: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 4960: -- Standard Call to check for call compatibility

4956: BEGIN
4957: -- Standard start of API savepoint
4958: SAVEPOINT Validate_UOMQuantity;
4959: --
4960: -- Standard Call to check for call compatibility
4961: IF NOT FND_API.Compatible_API_Call(l_api_version
4962: , p_api_version
4963: , l_api_name
4964: , G_PKG_NAME) THEN

Line 5239: -- Standard check of p_commit

5235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5236: END IF;
5237: --
5238: -- END of API body
5239: -- Standard check of p_commit
5240: IF FND_API.to_Boolean(p_commit) THEN
5241: COMMIT;
5242: END IF;
5243: -- Standard call to get message count and if count is 1, get message info

Line 5243: -- Standard call to get message count and if count is 1, get message info

5239: -- Standard check of p_commit
5240: IF FND_API.to_Boolean(p_commit) THEN
5241: COMMIT;
5242: END IF;
5243: -- Standard call to get message count and if count is 1, get message info
5244: FND_MSG_PUB.Count_And_Get
5245: (p_count => x_msg_count
5246: , p_data => x_msg_data);
5247: EXCEPTION

Line 5348: -- Standard start of API savepoint

5344: L_emp_id NUMBER := p_employee_id;
5345: L_emp_name VARCHAR2(60) := p_employee_name;
5346: L_temp VARCHAR2(60);
5347: BEGIN
5348: -- Standard start of API savepoint
5349: SAVEPOINT Validate_CDate_Counter;
5350: --
5351: -- Standard Call to check for call compatibility
5352: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 5351: -- Standard Call to check for call compatibility

5347: BEGIN
5348: -- Standard start of API savepoint
5349: SAVEPOINT Validate_CDate_Counter;
5350: --
5351: -- Standard Call to check for call compatibility
5352: IF NOT FND_API.Compatible_API_Call(l_api_version
5353: , p_api_version
5354: , l_api_name
5355: , G_PKG_NAME) THEN

Line 5488: -- Standard check of p_commit

5484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5485: END IF;
5486: --
5487: -- END of API body
5488: -- Standard check of p_commit
5489: IF FND_API.to_Boolean(p_commit) THEN
5490: COMMIT;
5491: END IF;
5492: -- Standard call to get message count and if count is 1, get message info

Line 5492: -- Standard call to get message count and if count is 1, get message info

5488: -- Standard check of p_commit
5489: IF FND_API.to_Boolean(p_commit) THEN
5490: COMMIT;
5491: END IF;
5492: -- Standard call to get message count and if count is 1, get message info
5493: FND_MSG_PUB.Count_And_Get
5494: (p_count => x_msg_count
5495: , p_data => x_msg_data);
5496: EXCEPTION

Line 5793: -- Standard start of API savepoint

5789: MDEBUG( 'Process Data: Begin ');
5790: MDEBUG( 'Item-CC header -> '||to_char(MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID)|| ' - '||to_char(MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID));
5791: END IF;
5792:
5793: -- Standard start of API savepoint
5794: SAVEPOINT Process_Data;
5795: --
5796: -- Standard Call to check for call compatibility
5797: IF NOT FND_API.Compatible_API_Call(l_api_version

Line 5796: -- Standard Call to check for call compatibility

5792:
5793: -- Standard start of API savepoint
5794: SAVEPOINT Process_Data;
5795: --
5796: -- Standard Call to check for call compatibility
5797: IF NOT FND_API.Compatible_API_Call(l_api_version
5798: , p_api_version
5799: , l_api_name
5800: , G_PKG_NAME) THEN

Line 5996: -- Standard check of p_commit

5992: END IF;
5993: END IF;
5994: --
5995: -- END of API body
5996: -- Standard check of p_commit
5997: IF FND_API.to_Boolean(p_commit) THEN
5998: COMMIT;
5999: END IF;
6000: -- Standard call to get message count and if count is 1, get message info

Line 6000: -- Standard call to get message count and if count is 1, get message info

5996: -- Standard check of p_commit
5997: IF FND_API.to_Boolean(p_commit) THEN
5998: COMMIT;
5999: END IF;
6000: -- Standard call to get message count and if count is 1, get message info
6001: FND_MSG_PUB.Count_And_Get
6002: (p_count => x_msg_count
6003: , p_data => x_msg_data);
6004: EXCEPTION

Line 6580: -- Standard start of API savepoint

6576: l_table_name VARCHAR2 (100);
6577: l_column_name VARCHAR2 (100);
6578: l_message_name VARCHAR2 (30);
6579: BEGIN
6580: -- Standard start of API savepoint
6581: SAVEPOINT validate_uomquantity;
6582:
6583: -- Standard Call to check for call compatibility
6584: IF NOT fnd_api.compatible_api_call (l_api_version

Line 6583: -- Standard Call to check for call compatibility

6579: BEGIN
6580: -- Standard start of API savepoint
6581: SAVEPOINT validate_uomquantity;
6582:
6583: -- Standard Call to check for call compatibility
6584: IF NOT fnd_api.compatible_api_call (l_api_version
6585: , p_api_version
6586: , l_api_name
6587: , g_pkg_name) THEN

Line 6722: -- Standard check of p_commit

6718: , p_message_name => 'unexpected error');
6719: RAISE fnd_api.g_exc_unexpected_error;
6720: END IF; -- count type code
6721:
6722: -- Standard check of p_commit
6723: IF fnd_api.to_boolean (p_commit) THEN
6724: COMMIT;
6725: END IF;
6726:

Line 6727: -- Standard call to get message count and if count is 1, get message info

6723: IF fnd_api.to_boolean (p_commit) THEN
6724: COMMIT;
6725: END IF;
6726:
6727: -- Standard call to get message count and if count is 1, get message info
6728: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6729: EXCEPTION
6730: WHEN fnd_api.g_exc_error THEN
6731: ROLLBACK TO validate_secondarycountuom;