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_INV_VALIDATE_GRP dependencies on STANDARD

Line 17: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

13: null;
14: --inv_debug.message(msg);
15: end;
16: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data
17: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
18: procedure Get_Offset_Date(
19: p_api_version IN NUMBER ,
20: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 97: -- Standard start of API savepoint

93:
94:
95: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
96: begin
97: -- Standard start of API savepoint
98: SAVEPOINT Get_Offset_Date;
99: --
100: -- Standard Call to check for call compatibility
101: IF NOT FND_API.Compatible_API_Call(l_api_version

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

96: begin
97: -- Standard start of API savepoint
98: SAVEPOINT Get_Offset_Date;
99: --
100: -- Standard Call to check for call compatibility
101: IF NOT FND_API.Compatible_API_Call(l_api_version
102: , p_api_version
103: , l_api_name
104: , G_PKG_NAME) THEN

Line 130: -- Standard check of p_commit

126: end if;
127:
128: --
129: -- END of API body
130: -- Standard check of p_commit
131: IF FND_API.to_Boolean(p_commit) THEN
132: COMMIT;
133: END IF;
134: -- Standard call to get message count and if count is 1, get message info

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

130: -- Standard check of p_commit
131: IF FND_API.to_Boolean(p_commit) THEN
132: COMMIT;
133: END IF;
134: -- Standard call to get message count and if count is 1, get message info
135: FND_MSG_PUB.Count_And_Get
136: (p_count => x_msg_count
137: , p_data => x_msg_data);
138:

Line 261: -- 1 - item specific, 2 - standard, 3 - both standard and item spec

257: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
258: c_rec.SERIAL_NUMBER_CONTROL_CODE;
259:
260: -- allowed unit of measure conversion type
261: -- 1 - item specific, 2 - standard, 3 - both standard and item spec
262: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=
263: c_rec.ALLOWED_UNITS_LOOKUP_CODE;
264: --
265: END LOOP;

Line 312: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

308: END;
309: --
310: -- Validates the adjustment account
311: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data
312: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
313: PROCEDURE Validate_AdjustAccount(
314: p_api_version IN NUMBER ,
315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 444: -- Standard start of API savepoint

440: L_counter integer := 0;
441: L_api_version CONSTANT NUMBER := 0.9;
442: L_api_name CONSTANT VARCHAR2(30) := 'Validate_AdjustAccount';
443: BEGIN
444: -- Standard start of API savepoint
445: SAVEPOINT Validate_AdjustAccount;
446: --
447: -- Standard Call to check for call compatibility
448: IF NOT FND_API.Compatible_API_Call(l_api_version

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

443: BEGIN
444: -- Standard start of API savepoint
445: SAVEPOINT Validate_AdjustAccount;
446: --
447: -- Standard Call to check for call compatibility
448: IF NOT FND_API.Compatible_API_Call(l_api_version
449: , p_api_version
450: , l_api_name
451: , G_PKG_NAME) THEN

Line 535: -- Standard check of p_commit

531: RAISE FND_API.G_EXC_ERROR;
532: END IF;
533: --
534: -- END of API body
535: -- Standard check of p_commit
536: IF FND_API.to_Boolean(p_commit) THEN
537: COMMIT;
538: END IF;
539: -- Standard call to get message count and if count is 1, get message info

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

535: -- Standard check of p_commit
536: IF FND_API.to_Boolean(p_commit) THEN
537: COMMIT;
538: END IF;
539: -- Standard call to get message count and if count is 1, get message info
540: FND_MSG_PUB.Count_And_Get
541: (p_count => x_msg_count
542: , p_data => x_msg_data);
543: EXCEPTION

Line 579: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

575: END;
576: --
577: -- Validates the count date (good for any date)
578: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
579: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
580: PROCEDURE Validate_CountDate(
581: p_api_version IN NUMBER ,
582: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
583: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 641: -- Standard start of API savepoint

637: --
638: L_api_version CONSTANT NUMBER := 0.9;
639: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CountDate';
640: BEGIN
641: -- Standard start of API savepoint
642: SAVEPOINT Validate_CountDate;
643: --
644: -- Standard Call to check for call compatibility
645: IF NOT FND_API.Compatible_API_Call(l_api_version

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

640: BEGIN
641: -- Standard start of API savepoint
642: SAVEPOINT Validate_CountDate;
643: --
644: -- Standard Call to check for call compatibility
645: IF NOT FND_API.Compatible_API_Call(l_api_version
646: , p_api_version
647: , l_api_name
648: , G_PKG_NAME) THEN

Line 740: -- Standard check of p_commit

736: -- if we're here then the validation went ok so we can store the date
737: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := p_count_date;
738: --
739: -- END of API body
740: -- Standard check of p_commit
741: IF FND_API.to_Boolean(p_commit) THEN
742: COMMIT;
743: END IF;
744: -- Standard call to get message count and if count is 1, get message info

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

740: -- Standard check of p_commit
741: IF FND_API.to_Boolean(p_commit) THEN
742: COMMIT;
743: END IF;
744: -- Standard call to get message count and if count is 1, get message info
745: FND_MSG_PUB.Count_And_Get
746: (p_count => x_msg_count
747: , p_data => x_msg_data);
748: EXCEPTION

Line 786: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

782: END;
783: --
784: -- Validate count header
785: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
786: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
787: PROCEDURE Validate_CountHeader(
788: p_api_version IN NUMBER ,
789: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
790: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 867: -- Standard start of API savepoint

863: --
864: L_api_version CONSTANT NUMBER := 0.9;
865: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CountHeader';
866: BEGIN
867: -- Standard start of API savepoint
868: SAVEPOINT Validate_CountHeader;
869: --
870: -- Standard Call to check for call compatibility
871: IF NOT FND_API.Compatible_API_Call(l_api_version

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

866: BEGIN
867: -- Standard start of API savepoint
868: SAVEPOINT Validate_CountHeader;
869: --
870: -- Standard Call to check for call compatibility
871: IF NOT FND_API.Compatible_API_Call(l_api_version
872: , p_api_version
873: , l_api_name
874: , G_PKG_NAME) THEN

Line 944: -- Standard check of p_commit

940: END IF;
941: --
942: --
943: -- END of API body
944: -- Standard check of p_commit
945: IF FND_API.to_Boolean(p_commit) THEN
946: COMMIT;
947: END IF;
948: -- Standard call to get message count and if count is 1, get message info

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

944: -- Standard check of p_commit
945: IF FND_API.to_Boolean(p_commit) THEN
946: COMMIT;
947: END IF;
948: -- Standard call to get message count and if count is 1, get message info
949: FND_MSG_PUB.Count_And_Get
950: (p_count => x_msg_count
951: , p_data => x_msg_data);
952: EXCEPTION

Line 990: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

986: END;
987: --
988: -- Validate count_list_sequence
989: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
990: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
991: PROCEDURE Validate_CountListSequence(
992: p_api_version NUMBER ,
993: p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,
994: p_commit VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1077: -- Standard start of API savepoint

1073: --
1074: L_api_version CONSTANT NUMBER := 0.9;
1075: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CountListSequence';
1076: BEGIN
1077: -- Standard start of API savepoint
1078: SAVEPOINT Validate_CountListSequence;
1079: --
1080: -- Standard Call to check for call compatibility
1081: IF NOT FND_API.Compatible_API_Call(l_api_version

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

1076: BEGIN
1077: -- Standard start of API savepoint
1078: SAVEPOINT Validate_CountListSequence;
1079: --
1080: -- Standard Call to check for call compatibility
1081: IF NOT FND_API.Compatible_API_Call(l_api_version
1082: , p_api_version
1083: , l_api_name
1084: , G_PKG_NAME) THEN

Line 1159: -- Standard check of p_commit

1155: END IF;
1156: --
1157: --
1158: -- END of API body
1159: -- Standard check of p_commit
1160: IF FND_API.to_Boolean(p_commit) THEN
1161: COMMIT;
1162: END IF;
1163: -- Standard call to get message count and if count is 1, get message info

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

1159: -- Standard check of p_commit
1160: IF FND_API.to_Boolean(p_commit) THEN
1161: COMMIT;
1162: END IF;
1163: -- Standard call to get message count and if count is 1, get message info
1164: FND_MSG_PUB.Count_And_Get
1165: (p_count => x_msg_count
1166: , p_data => x_msg_data);
1167: EXCEPTION

Line 1205: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

1201: END;
1202: --
1203: -- Validate the count quantity (if negative)
1204: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
1205: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
1206: PROCEDURE Validate_CountQuantity(
1207: p_api_version IN NUMBER ,
1208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1264: -- Standard start of API savepoint

1260: --
1261: L_api_version CONSTANT NUMBER := 0.9;
1262: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CountQuantity';
1263: BEGIN
1264: -- Standard start of API savepoint
1265: SAVEPOINT Validate_CountQuantity;
1266: --
1267: -- Standard Call to check for call compatibility
1268: IF NOT FND_API.Compatible_API_Call(l_api_version

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

1263: BEGIN
1264: -- Standard start of API savepoint
1265: SAVEPOINT Validate_CountQuantity;
1266: --
1267: -- Standard Call to check for call compatibility
1268: IF NOT FND_API.Compatible_API_Call(l_api_version
1269: , p_api_version
1270: , l_api_name
1271: , G_PKG_NAME) THEN

Line 1327: -- Standard check of p_commit

1323: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := p_count_quantity;
1324: END IF;
1325: --
1326: -- END of API body
1327: -- Standard check of p_commit
1328: IF FND_API.to_Boolean(p_commit) THEN
1329: COMMIT;
1330: END IF;
1331: -- Standard call to get message count and if count is 1, get message info

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

1327: -- Standard check of p_commit
1328: IF FND_API.to_Boolean(p_commit) THEN
1329: COMMIT;
1330: END IF;
1331: -- Standard call to get message count and if count is 1, get message info
1332: FND_MSG_PUB.Count_And_Get
1333: (p_count => x_msg_count
1334: , p_data => x_msg_data);
1335: EXCEPTION

Line 1376: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

1372: END;
1373: --
1374: -- Validates Control information this item
1375: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
1376: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
1377: PROCEDURE Validate_Ctrol(
1378: p_api_version IN NUMBER ,
1379: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1380: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1480: -- Standard start of API savepoint

1476: --
1477: L_api_version CONSTANT NUMBER := 0.9;
1478: L_api_name CONSTANT VARCHAR2(30) := 'Validate_Ctrol';
1479: BEGIN
1480: -- Standard start of API savepoint
1481: SAVEPOINT Validate_Ctrol;
1482: --
1483: -- Standard Call to check for call compatibility
1484: IF NOT FND_API.Compatible_API_Call(l_api_version

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

1479: BEGIN
1480: -- Standard start of API savepoint
1481: SAVEPOINT Validate_Ctrol;
1482: --
1483: -- Standard Call to check for call compatibility
1484: IF NOT FND_API.Compatible_API_Call(l_api_version
1485: , p_api_version
1486: , l_api_name
1487: , G_PKG_NAME) THEN

Line 1658: -- Standard check of p_commit

1654: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := NULL;
1655: END IF;
1656: --
1657: -- END of API body
1658: -- Standard check of p_commit
1659: IF FND_API.to_Boolean(p_commit) THEN
1660: COMMIT;
1661: END IF;
1662: -- Standard call to get message count and if count is 1, get message info

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

1658: -- Standard check of p_commit
1659: IF FND_API.to_Boolean(p_commit) THEN
1660: COMMIT;
1661: END IF;
1662: -- Standard call to get message count and if count is 1, get message info
1663: FND_MSG_PUB.Count_And_Get
1664: (p_count => x_msg_count
1665: , p_data => x_msg_data);
1666: EXCEPTION

Line 1704: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

1700: END;
1701: --
1702: -- Validates Count UOM or/and Unit of Measure (not specific to cc)
1703: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
1704: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
1705: PROCEDURE Validate_CountUOM(
1706: p_api_version IN NUMBER ,
1707: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1708: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1794: -- Standard start of API savepoint

1790: --
1791: L_api_version CONSTANT NUMBER := 0.9;
1792: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CountUOM';
1793: BEGIN
1794: -- Standard start of API savepoint
1795: SAVEPOINT Validate_CountUOM;
1796: --
1797: -- Standard Call to check for call compatibility
1798: IF NOT FND_API.Compatible_API_Call(l_api_version

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

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

Line 1856: -- Standard check of p_commit

1852: RAISE FND_API.G_EXC_ERROR;
1853: END IF;
1854: --
1855: -- END of API body
1856: -- Standard check of p_commit
1857: IF FND_API.to_Boolean(p_commit) THEN
1858: COMMIT;
1859: END IF;
1860: -- Standard call to get message count and if count is 1, get message info

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

1856: -- Standard check of p_commit
1857: IF FND_API.to_Boolean(p_commit) THEN
1858: COMMIT;
1859: END IF;
1860: -- Standard call to get message count and if count is 1, get message info
1861: FND_MSG_PUB.Count_And_Get
1862: (p_count => x_msg_count
1863: , p_data => x_msg_data);
1864: EXCEPTION

Line 1902: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

1898: END;
1899: --
1900: -- Validates Item information
1901: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
1902: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
1903: PROCEDURE Validate_Item(
1904: p_api_version IN NUMBER ,
1905: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1906: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1988: -- Standard start of API savepoint

1984: --
1985: L_api_version CONSTANT NUMBER := 0.9;
1986: L_api_name CONSTANT VARCHAR2(30) := 'Validate_Item';
1987: BEGIN
1988: -- Standard start of API savepoint
1989: SAVEPOINT Validate_Item;
1990: --
1991: -- Standard Call to check for call compatibility
1992: IF NOT FND_API.Compatible_API_Call(l_api_version

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

1987: BEGIN
1988: -- Standard start of API savepoint
1989: SAVEPOINT Validate_Item;
1990: --
1991: -- Standard Call to check for call compatibility
1992: IF NOT FND_API.Compatible_API_Call(l_api_version
1993: , p_api_version
1994: , l_api_name
1995: , G_PKG_NAME) THEN

Line 2105: -- Standard check of p_commit

2101: end if;
2102: END IF;
2103: --
2104: -- END of API body
2105: -- Standard check of p_commit
2106: IF FND_API.to_Boolean(p_commit) THEN
2107: COMMIT;
2108: END IF;
2109: -- Standard call to get message count and if count is 1, get message info

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

2105: -- Standard check of p_commit
2106: IF FND_API.to_Boolean(p_commit) THEN
2107: COMMIT;
2108: END IF;
2109: -- Standard call to get message count and if count is 1, get message info
2110: FND_MSG_PUB.Count_And_Get
2111: (p_count => x_msg_count
2112: , p_data => x_msg_data);
2113: EXCEPTION

Line 2151: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

2147: END;
2148: --
2149: -- Validates locator information
2150: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
2151: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
2152: PROCEDURE Validate_Locator(
2153: p_api_version IN NUMBER ,
2154: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2155: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 2243: -- Standard start of API savepoint

2239: --
2240: L_api_version CONSTANT NUMBER := 0.9;
2241: L_api_name CONSTANT VARCHAR2(30) := 'Validate_Locator';
2242: BEGIN
2243: -- Standard start of API savepoint
2244: SAVEPOINT Validate_Locator;
2245: --
2246: -- Standard Call to check for call compatibility
2247: IF NOT FND_API.Compatible_API_Call(l_api_version

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

2242: BEGIN
2243: -- Standard start of API savepoint
2244: SAVEPOINT Validate_Locator;
2245: --
2246: -- Standard Call to check for call compatibility
2247: IF NOT FND_API.Compatible_API_Call(l_api_version
2248: , p_api_version
2249: , l_api_name
2250: , G_PKG_NAME) THEN

Line 2379: -- Standard check of p_commit

2375: x_errorcode := 0;
2376: END IF;
2377: --
2378: -- END of API body
2379: -- Standard check of p_commit
2380: IF FND_API.to_Boolean(p_commit) THEN
2381: COMMIT;
2382: END IF;
2383: -- Standard call to get message count and if count is 1, get message info

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

2379: -- Standard check of p_commit
2380: IF FND_API.to_Boolean(p_commit) THEN
2381: COMMIT;
2382: END IF;
2383: -- Standard call to get message count and if count is 1, get message info
2384: FND_MSG_PUB.Count_And_Get
2385: (p_count => x_msg_count
2386: , p_data => x_msg_data);
2387: EXCEPTION

Line 2425: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

2421: END;
2422: --
2423: -- Validate the primary uom quantity
2424: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
2425: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
2426: PROCEDURE Validate_PrimaryUomQuantity(
2427: p_api_version IN NUMBER ,
2428: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2429: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 2491: -- Standard start of API savepoint

2487: --
2488: L_api_version CONSTANT NUMBER := 0.9;
2489: L_api_name CONSTANT VARCHAR2(30) := 'Validate_PrimaryUomQuantity';
2490: BEGIN
2491: -- Standard start of API savepoint
2492: SAVEPOINT Validate_PrimaryUomQuantity;
2493: --
2494: -- Standard Call to check for call compatibility
2495: IF NOT FND_API.Compatible_API_Call(l_api_version

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

2490: BEGIN
2491: -- Standard start of API savepoint
2492: SAVEPOINT Validate_PrimaryUomQuantity;
2493: --
2494: -- Standard Call to check for call compatibility
2495: IF NOT FND_API.Compatible_API_Call(l_api_version
2496: , p_api_version
2497: , l_api_name
2498: , G_PKG_NAME) THEN

Line 2534: -- Standard check of p_commit

2530: END IF;
2531:
2532: --
2533: -- END of API body
2534: -- Standard check of p_commit
2535: IF FND_API.to_Boolean(p_commit) THEN
2536: COMMIT;
2537: END IF;
2538: -- Standard call to get message count and if count is 1, get message info

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

2534: -- Standard check of p_commit
2535: IF FND_API.to_Boolean(p_commit) THEN
2536: COMMIT;
2537: END IF;
2538: -- Standard call to get message count and if count is 1, get message info
2539: FND_MSG_PUB.Count_And_Get
2540: (p_count => x_msg_count
2541: , p_data => x_msg_data);
2542: EXCEPTION

Line 2580: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

2576: END;
2577: --
2578: -- Validates subinventory
2579: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
2580: --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
2581: PROCEDURE Validate_Subinv(
2582: p_api_version IN NUMBER ,
2583: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2584: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 2668: -- Standard start of API savepoint

2664: --
2665: L_api_version CONSTANT NUMBER := 0.9;
2666: L_api_name CONSTANT VARCHAR2(30) := 'Validate_SubInv';
2667: BEGIN
2668: -- Standard start of API savepoint
2669: SAVEPOINT Validate_SubInv;
2670: --
2671: -- Standard Call to check for call compatibility
2672: IF NOT FND_API.Compatible_API_Call(l_api_version

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

2667: BEGIN
2668: -- Standard start of API savepoint
2669: SAVEPOINT Validate_SubInv;
2670: --
2671: -- Standard Call to check for call compatibility
2672: IF NOT FND_API.Compatible_API_Call(l_api_version
2673: , p_api_version
2674: , l_api_name
2675: , G_PKG_NAME) THEN

Line 2748: -- Standard check of p_commit

2744: mtl_cceoi_var_pvt.G_SUBINVENTORY := p_subinventory;
2745: --
2746: --
2747: -- END of API body
2748: -- Standard check of p_commit
2749: IF FND_API.to_Boolean(p_commit) THEN
2750: COMMIT;
2751: END IF;
2752: -- Standard call to get message count and if count is 1, get message info

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

2748: -- Standard check of p_commit
2749: IF FND_API.to_Boolean(p_commit) THEN
2750: COMMIT;
2751: END IF;
2752: -- Standard call to get message count and if count is 1, get message info
2753: FND_MSG_PUB.Count_And_Get
2754: (p_count => x_msg_count
2755: , p_data => x_msg_data);
2756: EXCEPTION

Line 2801: --standard. Bug:4410902

2797:
2798: -- Is the item under Locator control
2799: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data
2800: --x_locator_control,x_level OUT parameters to comply with GSCC File.Sql.39
2801: --standard. Bug:4410902
2802: PROCEDURE Locator_Control(
2803: p_api_version IN NUMBER ,
2804: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2805: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 2890: -- Standard start of API savepoint

2886: --
2887: L_api_version CONSTANT NUMBER := 0.9;
2888: L_api_name CONSTANT VARCHAR2(30) := 'Locator_Control';
2889: BEGIN
2890: -- Standard start of API savepoint
2891: SAVEPOINT Locator_Control;
2892: --
2893: -- Standard Call to check for call compatibility
2894: IF NOT FND_API.Compatible_API_Call(l_api_version

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

2889: BEGIN
2890: -- Standard start of API savepoint
2891: SAVEPOINT Locator_Control;
2892: --
2893: -- Standard Call to check for call compatibility
2894: IF NOT FND_API.Compatible_API_Call(l_api_version
2895: , p_api_version
2896: , l_api_name
2897: , G_PKG_NAME) THEN

Line 3005: -- Standard check of p_commit

3001: mdebug('2.LOCATOR control (locator control) '||x_return_status);
3002: END IF;
3003: --
3004: -- END of API body
3005: -- Standard check of p_commit
3006: IF FND_API.to_Boolean(p_commit) THEN
3007: COMMIT;
3008: END IF;
3009: -- Standard call to get message count and if count is 1, get message info

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

3005: -- Standard check of p_commit
3006: IF FND_API.to_Boolean(p_commit) THEN
3007: COMMIT;
3008: END IF;
3009: -- Standard call to get message count and if count is 1, get message info
3010: FND_MSG_PUB.Count_And_Get
3011: (p_count => x_msg_count
3012: , p_data => x_msg_data);
3013: EXCEPTION

Line 3093: --P_Location_id OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902

3089: END;
3090: --
3091: --
3092: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data,x_errorcode
3093: --P_Location_id OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
3094: PROCEDURE Inv_Dlocator_Create(
3095: P_Api_Version IN NUMBER ,
3096: P_Init_Msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3097: P_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 3199: -- Standard start of API savepoint

3195: L_key_flex_code,
3196: L_structure_number);
3197: BEGIN
3198:
3199: -- Standard start of API savepoint
3200: SAVEPOINT Inv_Dlocator_Create;
3201: --
3202: -- for Testing marked by suresh
3203: -- Standard Call to check for call compatibility

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

3199: -- Standard start of API savepoint
3200: SAVEPOINT Inv_Dlocator_Create;
3201: --
3202: -- for Testing marked by suresh
3203: -- Standard Call to check for call compatibility
3204: IF NOT FND_API.Compatible_API_Call(l_api_version
3205: , p_api_version
3206: , l_api_name
3207: , G_PKG_NAME) THEN

Line 3350: -- Standard check of p_commit

3346: end if;
3347: P_Location_Id := L_new_ccid ;
3348: --
3349: -- END of API body
3350: -- Standard check of p_commit
3351: IF FND_API.to_Boolean(p_commit) THEN
3352: COMMIT;
3353: END IF;
3354: -- Standard call to get message count and if count is 1, get message info

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

3350: -- Standard check of p_commit
3351: IF FND_API.to_Boolean(p_commit) THEN
3352: COMMIT;
3353: END IF;
3354: -- Standard call to get message count and if count is 1, get message info
3355: FND_MSG_PUB.Count_And_Get
3356: (p_count => x_msg_count
3357: , p_data => x_msg_data);
3358: EXCEPTION

Line 3428: -- Standard start of API savepoint

3424: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_SecondaryCountUOM';
3425: l_secondary_unit_of_measure mtl_item_uoms_view.unit_of_measure%TYPE;
3426: l_secondary_uom mtl_item_uoms_view.uom_code%TYPE;
3427: BEGIN
3428: -- Standard start of API savepoint
3429: SAVEPOINT validate_secondarycountuom;
3430:
3431: --
3432: -- Standard Call to check for call compatibility

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

3428: -- Standard start of API savepoint
3429: SAVEPOINT validate_secondarycountuom;
3430:
3431: --
3432: -- Standard Call to check for call compatibility
3433: IF NOT fnd_api.compatible_api_call (l_api_version
3434: , p_api_version
3435: , l_api_name
3436: , g_pkg_name) THEN

Line 3534: -- Standard start of API savepoint

3530: l_converted_qty NUMBER;
3531: l_error_message VARCHAR2(2000);
3532:
3533: BEGIN
3534: -- Standard start of API savepoint
3535: SAVEPOINT validate_secondarycountqty;
3536:
3537: -- Standard Call to check for call compatibility
3538: IF NOT fnd_api.compatible_api_call (l_api_version

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

3533: BEGIN
3534: -- Standard start of API savepoint
3535: SAVEPOINT validate_secondarycountqty;
3536:
3537: -- Standard Call to check for call compatibility
3538: IF NOT fnd_api.compatible_api_call (l_api_version
3539: , p_api_version
3540: , l_api_name
3541: , g_pkg_name) THEN