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.

[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on STANDARD

Line 1696: -- Standard start of API savepoint

1692: l_return_status VARCHAR2(1);
1693: l_msg_count NUMBER;
1694: l_msg_data VARCHAR2(1000);
1695: BEGIN
1696: -- Standard start of API savepoint
1697: SAVEPOINT Calculate_Adjustment;
1698: --
1699: -- Standard Call to check for call compatibility
1700: IF NOT FND_API.Compatible_API_Call(l_api_version

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

1695: BEGIN
1696: -- Standard start of API savepoint
1697: SAVEPOINT Calculate_Adjustment;
1698: --
1699: -- Standard Call to check for call compatibility
1700: IF NOT FND_API.Compatible_API_Call(l_api_version
1701: , p_api_version
1702: , l_api_name
1703: , G_PKG_NAME) THEN

Line 1998: -- Standard check of p_commit

1994: */
1995: --
1996: --
1997: -- END of API body
1998: -- Standard check of p_commit
1999: IF FND_API.to_Boolean(p_commit) THEN
2000: COMMIT;
2001: END IF;
2002: -- Standard call to get message count and if count is 1, get message info

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

1998: -- Standard check of p_commit
1999: IF FND_API.to_Boolean(p_commit) THEN
2000: COMMIT;
2001: END IF;
2002: -- Standard call to get message count and if count is 1, get message info
2003: FND_MSG_PUB.Count_And_Get
2004: (p_count => x_msg_count
2005: , p_data => x_msg_data);
2006: EXCEPTION

Line 3214: -- Standard start of API savepoint

3210: DECLARE
3211: L_api_version CONSTANT NUMBER := 0.9;
3212: L_api_name CONSTANT VARCHAR2(30) := 'Set_CCExport';
3213: BEGIN
3214: -- Standard start of API savepoint
3215: SAVEPOINT Set_CCExport;
3216: --
3217: -- Standard Call to check for call compatibility
3218: IF (l_debug = 1) THEN

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

3213: BEGIN
3214: -- Standard start of API savepoint
3215: SAVEPOINT Set_CCExport;
3216: --
3217: -- Standard Call to check for call compatibility
3218: IF (l_debug = 1) THEN
3219: MDEBUG( 'SetCCExport : Before API');
3220: END IF;
3221: IF NOT FND_API.Compatible_API_Call(

Line 3274: -- Standard check of p_commit

3270: RAISE FND_API.G_EXC_ERROR;
3271: END IF;
3272: --
3273: -- END of API body
3274: -- Standard check of p_commit
3275: IF FND_API.to_Boolean(p_commit) THEN
3276: COMMIT;
3277: END IF;
3278: -- --

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

3275: IF FND_API.to_Boolean(p_commit) THEN
3276: COMMIT;
3277: END IF;
3278: -- --
3279: -- Standard call to get message count and if count is 1, get message info
3280: FND_MSG_PUB.Count_And_Get
3281: (p_count => x_msg_count
3282: , p_data => x_msg_data);
3283: EXCEPTION

Line 3385: -- Standard start of API savepoint

3381: L_status NUMBER;
3382: L_delete NUMBER;
3383: BEGIN
3384:
3385: -- Standard start of API savepoint
3386: SAVEPOINT SET_CCEOIVALID;
3387: --
3388: -- Standard Call to check for call compatibility
3389: IF NOT FND_API.Compatible_API_Call(

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

3384:
3385: -- Standard start of API savepoint
3386: SAVEPOINT SET_CCEOIVALID;
3387: --
3388: -- Standard Call to check for call compatibility
3389: IF NOT FND_API.Compatible_API_Call(
3390: l_api_version, p_api_version
3391: , l_api_name
3392: , G_PKG_NAME) THEN

Line 3442: -- Standard check of p_commit

3438: RAISE FND_API.G_EXC_ERROR;
3439: END IF;
3440: --
3441: -- END of API body
3442: -- Standard check of p_commit
3443: IF FND_API.to_Boolean(p_commit) THEN
3444: COMMIT;
3445: END IF;
3446: -- --

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

3443: IF FND_API.to_Boolean(p_commit) THEN
3444: COMMIT;
3445: END IF;
3446: -- --
3447: -- Standard call to get message count and if count is 1, get message info
3448: FND_MSG_PUB.Count_And_Get
3449: (p_count => x_msg_count
3450: , p_data => x_msg_data);
3451: EXCEPTION

Line 3559: -- Standard start of API savepoint

3555: --
3556: L_api_version CONSTANT NUMBER := 0.9;
3557: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CHeader';
3558: BEGIN
3559: -- Standard start of API savepoint
3560: SAVEPOINT Validate_CHeader;
3561: --
3562: -- Standard Call to check for call compatibility
3563: IF NOT FND_API.Compatible_API_Call(l_api_version

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

3558: BEGIN
3559: -- Standard start of API savepoint
3560: SAVEPOINT Validate_CHeader;
3561: --
3562: -- Standard Call to check for call compatibility
3563: IF NOT FND_API.Compatible_API_Call(l_api_version
3564: , p_api_version
3565: , l_api_name
3566: , G_PKG_NAME) THEN

Line 3637: -- Standard check of p_commit

3633: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.INVENTORY_ADJUSTMENT_ACCOUNT;
3634: END IF;
3635: --
3636: -- END of API body
3637: -- Standard check of p_commit
3638: IF FND_API.to_Boolean(p_commit) THEN
3639: COMMIT;
3640: END IF;
3641: -- Standard call to get message count and if count is 1, get message info

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

3637: -- Standard check of p_commit
3638: IF FND_API.to_Boolean(p_commit) THEN
3639: COMMIT;
3640: END IF;
3641: -- Standard call to get message count and if count is 1, get message info
3642: FND_MSG_PUB.Count_And_Get
3643: (p_count => x_msg_count
3644: , p_data => x_msg_data);
3645: EXCEPTION

Line 3745: -- Standard start of API savepoint

3741: --
3742: L_api_version CONSTANT NUMBER := 0.9;
3743: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CountListSeq';
3744: BEGIN
3745: -- Standard start of API savepoint
3746: SAVEPOINT Validate_CountListSeq;
3747: --
3748: -- Standard Call to check for call compatibility
3749: IF NOT FND_API.Compatible_API_Call(l_api_version

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

3744: BEGIN
3745: -- Standard start of API savepoint
3746: SAVEPOINT Validate_CountListSeq;
3747: --
3748: -- Standard Call to check for call compatibility
3749: IF NOT FND_API.Compatible_API_Call(l_api_version
3750: , p_api_version
3751: , l_api_name
3752: , G_PKG_NAME) THEN

Line 3822: -- Standard check of p_commit

3818: END IF;
3819: --
3820: --
3821: -- END of API body
3822: -- Standard check of p_commit
3823: IF FND_API.to_Boolean(p_commit) THEN
3824: COMMIT;
3825: END IF;
3826: -- Standard call to get message count and if count is 1, get message info

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

3822: -- Standard check of p_commit
3823: IF FND_API.to_Boolean(p_commit) THEN
3824: COMMIT;
3825: END IF;
3826: -- Standard call to get message count and if count is 1, get message info
3827: FND_MSG_PUB.Count_And_Get
3828: (p_count => x_msg_count
3829: , p_data => x_msg_data);
3830: EXCEPTION

Line 3987: -- Standard start of API savepoint

3983: --
3984: L_api_version CONSTANT NUMBER := 0.9;
3985: L_api_name CONSTANT VARCHAR2(30) := 'Validate_ItemSKU';
3986: BEGIN
3987: -- Standard start of API savepoint
3988: SAVEPOINT Validate_ItemSKU;
3989: --
3990: -- Standard Call to check for call compatibility
3991: IF NOT FND_API.Compatible_API_Call(l_api_version

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

3986: BEGIN
3987: -- Standard start of API savepoint
3988: SAVEPOINT Validate_ItemSKU;
3989: --
3990: -- Standard Call to check for call compatibility
3991: IF NOT FND_API.Compatible_API_Call(l_api_version
3992: , p_api_version
3993: , l_api_name
3994: , G_PKG_NAME) THEN

Line 4618: -- Standard check of p_commit

4614: IF (l_debug = 1) THEN
4615: MDEBUG( 'Process: In Validate_ItemSKU call-5 ');
4616: END IF;
4617: -- END of API body
4618: -- Standard check of p_commit
4619: IF FND_API.to_Boolean(p_commit) THEN
4620: COMMIT;
4621: END IF;
4622: IF (l_debug = 1) THEN

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

4621: END IF;
4622: IF (l_debug = 1) THEN
4623: MDEBUG( 'Process: In Validate_ItemSKU call-6 ');
4624: END IF;
4625: -- Standard call to get message count and if count is 1, get message info
4626: FND_MSG_PUB.Count_And_Get
4627: (p_count => x_msg_count
4628: , p_data => x_msg_data);
4629: IF (l_debug = 1) THEN

Line 4786: -- Standard start of API savepoint

4782: --
4783: L_api_version CONSTANT NUMBER := 0.9;
4784: L_api_name CONSTANT VARCHAR2(30) := 'Validate_UOMQuantity';
4785: BEGIN
4786: -- Standard start of API savepoint
4787: SAVEPOINT Validate_UOMQuantity;
4788: --
4789: -- Standard Call to check for call compatibility
4790: IF NOT FND_API.Compatible_API_Call(l_api_version

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

4785: BEGIN
4786: -- Standard start of API savepoint
4787: SAVEPOINT Validate_UOMQuantity;
4788: --
4789: -- Standard Call to check for call compatibility
4790: IF NOT FND_API.Compatible_API_Call(l_api_version
4791: , p_api_version
4792: , l_api_name
4793: , G_PKG_NAME) THEN

Line 5068: -- Standard check of p_commit

5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5065: END IF;
5066: --
5067: -- END of API body
5068: -- Standard check of p_commit
5069: IF FND_API.to_Boolean(p_commit) THEN
5070: COMMIT;
5071: END IF;
5072: -- Standard call to get message count and if count is 1, get message info

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

5068: -- Standard check of p_commit
5069: IF FND_API.to_Boolean(p_commit) THEN
5070: COMMIT;
5071: END IF;
5072: -- Standard call to get message count and if count is 1, get message info
5073: FND_MSG_PUB.Count_And_Get
5074: (p_count => x_msg_count
5075: , p_data => x_msg_data);
5076: EXCEPTION

Line 5176: -- Standard start of API savepoint

5172: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CDate_Counter';
5173: L_emp_id NUMBER := p_employee_id;
5174: L_emp_name VARCHAR2(60) := p_employee_name;
5175: BEGIN
5176: -- Standard start of API savepoint
5177: SAVEPOINT Validate_CDate_Counter;
5178: --
5179: -- Standard Call to check for call compatibility
5180: IF NOT FND_API.Compatible_API_Call(l_api_version

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

5175: BEGIN
5176: -- Standard start of API savepoint
5177: SAVEPOINT Validate_CDate_Counter;
5178: --
5179: -- Standard Call to check for call compatibility
5180: IF NOT FND_API.Compatible_API_Call(l_api_version
5181: , p_api_version
5182: , l_api_name
5183: , G_PKG_NAME) THEN

Line 5313: -- Standard check of p_commit

5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: END IF;
5311: --
5312: -- END of API body
5313: -- Standard check of p_commit
5314: IF FND_API.to_Boolean(p_commit) THEN
5315: COMMIT;
5316: END IF;
5317: -- Standard call to get message count and if count is 1, get message info

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

5313: -- Standard check of p_commit
5314: IF FND_API.to_Boolean(p_commit) THEN
5315: COMMIT;
5316: END IF;
5317: -- Standard call to get message count and if count is 1, get message info
5318: FND_MSG_PUB.Count_And_Get
5319: (p_count => x_msg_count
5320: , p_data => x_msg_data);
5321: EXCEPTION

Line 5618: -- Standard start of API savepoint

5614: MDEBUG( 'Process Data: Begin ');
5615: MDEBUG( 'Item-CC header -> '||to_char(MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID)|| ' - '||to_char(MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID));
5616: END IF;
5617:
5618: -- Standard start of API savepoint
5619: SAVEPOINT Process_Data;
5620: --
5621: -- Standard Call to check for call compatibility
5622: IF NOT FND_API.Compatible_API_Call(l_api_version

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

5617:
5618: -- Standard start of API savepoint
5619: SAVEPOINT Process_Data;
5620: --
5621: -- Standard Call to check for call compatibility
5622: IF NOT FND_API.Compatible_API_Call(l_api_version
5623: , p_api_version
5624: , l_api_name
5625: , G_PKG_NAME) THEN

Line 5821: -- Standard check of p_commit

5817: END IF;
5818: END IF;
5819: --
5820: -- END of API body
5821: -- Standard check of p_commit
5822: IF FND_API.to_Boolean(p_commit) THEN
5823: COMMIT;
5824: END IF;
5825: -- Standard call to get message count and if count is 1, get message info

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

5821: -- Standard check of p_commit
5822: IF FND_API.to_Boolean(p_commit) THEN
5823: COMMIT;
5824: END IF;
5825: -- Standard call to get message count and if count is 1, get message info
5826: FND_MSG_PUB.Count_And_Get
5827: (p_count => x_msg_count
5828: , p_data => x_msg_data);
5829: EXCEPTION

Line 6405: -- Standard start of API savepoint

6401: l_table_name VARCHAR2 (100);
6402: l_column_name VARCHAR2 (100);
6403: l_message_name VARCHAR2 (30);
6404: BEGIN
6405: -- Standard start of API savepoint
6406: SAVEPOINT validate_uomquantity;
6407:
6408: -- Standard Call to check for call compatibility
6409: IF NOT fnd_api.compatible_api_call (l_api_version

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

6404: BEGIN
6405: -- Standard start of API savepoint
6406: SAVEPOINT validate_uomquantity;
6407:
6408: -- Standard Call to check for call compatibility
6409: IF NOT fnd_api.compatible_api_call (l_api_version
6410: , p_api_version
6411: , l_api_name
6412: , g_pkg_name) THEN

Line 6547: -- Standard check of p_commit

6543: , p_message_name => 'unexpected error');
6544: RAISE fnd_api.g_exc_unexpected_error;
6545: END IF; -- count type code
6546:
6547: -- Standard check of p_commit
6548: IF fnd_api.to_boolean (p_commit) THEN
6549: COMMIT;
6550: END IF;
6551:

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

6548: IF fnd_api.to_boolean (p_commit) THEN
6549: COMMIT;
6550: END IF;
6551:
6552: -- Standard call to get message count and if count is 1, get message info
6553: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6554: EXCEPTION
6555: WHEN fnd_api.g_exc_error THEN
6556: ROLLBACK TO validate_secondarycountuom;