DBA Data[Home] [Help]

APPS.MTL_CCEOI_ACTION_PVT dependencies on STANDARD

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

10: --dbms_output.put_line(msg);
11: null;
12: end;
13: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
14: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
15: PROCEDURE Process_Error(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 33: -- Standard start of API savepoint

29: L_api_name CONSTANT VARCHAR2(30) := 'Process_Error';
30: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
31: BEGIN
32:
33: -- Standard start of API savepoint
34: SAVEPOINT Process_Error;
35: --
36: -- Standard Call to check for call compatibility
37: IF NOT FND_API.Compatible_API_Call(l_api_version

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

32:
33: -- Standard start of API savepoint
34: SAVEPOINT Process_Error;
35: --
36: -- Standard Call to check for call compatibility
37: IF NOT FND_API.Compatible_API_Call(l_api_version
38: , p_api_version
39: , l_api_name
40: , G_PKG_NAME) THEN

Line 100: -- Standard check of p_commit

96: --
97: -- END of API body
98: --
99:
100: -- Standard check of p_commit
101: IF FND_API.to_Boolean(p_commit) THEN
102: COMMIT;
103: END IF;
104:

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

143:
144: --
145: -- Insert the given row into the interface table.
146: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
147: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
148: PROCEDURE Export_CountRequest(
149: p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
151: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 203: -- Standard start of API savepoint

199: -- FOR this API PROCEDURE
200: L_api_version CONSTANT NUMBER := 0.9;
201: L_api_name CONSTANT VARCHAR2(30) := 'Export_CountRequest';
202: BEGIN
203: -- Standard start of API savepoint
204: SAVEPOINT Export_CountRequest_PVT;
205: --
206: -- Standard Call to check for call compatibility
207: IF NOT FND_API.Compatible_API_Call(l_api_version

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

202: BEGIN
203: -- Standard start of API savepoint
204: SAVEPOINT Export_CountRequest_PVT;
205: --
206: -- Standard Call to check for call compatibility
207: IF NOT FND_API.Compatible_API_Call(l_api_version
208: , p_api_version
209: , l_api_name
210: , G_PKG_NAME) THEN

Line 248: -- Standard check of p_commit

244: x_msg_data := L_msg_data;
245: x_return_status := L_return_status;
246: --
247: -- END of API body
248: -- Standard check of p_commit
249: IF FND_API.to_Boolean(p_commit) THEN
250: COMMIT;
251: END IF;
252: -- Standard call to get message count and if count is 1, get message info

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

248: -- Standard check of p_commit
249: IF FND_API.to_Boolean(p_commit) THEN
250: COMMIT;
251: END IF;
252: -- Standard call to get message count and if count is 1, get message info
253: FND_MSG_PUB.Count_And_Get
254: (p_count => x_msg_count
255: , p_data => x_msg_data);
256: EXCEPTION

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

289:
290: --
291: -- Create unscheduled count requests
292: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
293: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
294: PROCEDURE Create_CountRequest(
295: p_api_version IN NUMBER ,
296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 364: -- Standard start of API savepoint

360: -- L_return_status VARCHAR2(1);
361: -- L_msg_count NUMBER;
362: -- L_msg_data VARCHAR2(240);
363:
364: -- Standard start of API savepoint
365: SAVEPOINT Create_CountRequest;
366: --
367: -- Standard Call to check for call compatibility
368: IF NOT FND_API.Compatible_API_Call(l_api_version

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

363:
364: -- Standard start of API savepoint
365: SAVEPOINT Create_CountRequest;
366: --
367: -- Standard Call to check for call compatibility
368: IF NOT FND_API.Compatible_API_Call(l_api_version
369: , p_api_version
370: , l_api_name
371: , G_PKG_NAME) THEN

Line 540: -- Standard check of p_commit

536: END IF;
537:
538: --
539: -- END of API body
540: -- Standard check of p_commit
541: IF FND_API.to_Boolean(p_commit) THEN
542: COMMIT;
543: END IF;
544: -- Standard call to get message count and if count is 1, get message info

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

540: -- Standard check of p_commit
541: IF FND_API.to_Boolean(p_commit) THEN
542: COMMIT;
543: END IF;
544: -- Standard call to get message count and if count is 1, get message info
545: FND_MSG_PUB.Count_And_Get
546: (p_count => x_msg_count
547: , p_data => x_msg_data);
548:

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

584:
585: --
586: -- processed count request from the interface table
587: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
588: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
589: PROCEDURE Process_CountRequest
590: (
591: p_api_version IN NUMBER ,
592: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 653: -- Standard start of API savepoint

649: -- Notes : Note text
650: -- END OF comments
651:
652: --MDEBUG( 'Process: CCEId '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID));
653: -- Standard start of API savepoint
654: SAVEPOINT Process_CountRequest;
655: --
656: -- Standard Call to check for call compatibility
657: IF NOT FND_API.Compatible_API_Call(l_api_version

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

652: --MDEBUG( 'Process: CCEId '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID));
653: -- Standard start of API savepoint
654: SAVEPOINT Process_CountRequest;
655: --
656: -- Standard Call to check for call compatibility
657: IF NOT FND_API.Compatible_API_Call(l_api_version
658: , p_api_version
659: , l_api_name
660: , G_PKG_NAME) THEN

Line 884: -- Standard check of p_commit

880: END IF; -- validation's return status
881:
882: --
883: -- END of API body
884: -- Standard check of p_commit
885: IF FND_API.to_Boolean(p_commit) THEN
886: COMMIT;
887: END IF;
888: -- Standard call to get message count and if count is 1, get message info

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

884: -- Standard check of p_commit
885: IF FND_API.to_Boolean(p_commit) THEN
886: COMMIT;
887: END IF;
888: -- Standard call to get message count and if count is 1, get message info
889: FND_MSG_PUB.Count_And_Get
890: (p_count => x_msg_count
891: , p_data => x_msg_data);
892:

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

931: END Process_CountRequest;
932:
933: -- Validate the records in the interface table
934: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
935: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
936: PROCEDURE Validate_CountRequest(
937: p_api_version IN NUMBER ,
938: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
939: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1026: -- Standard start of API savepoint

1022: AND msi.inventory_item_id = cp_inventory_item_id;
1023: -- END INVCONV
1024:
1025: BEGIN
1026: -- Standard start of API savepoint
1027: SAVEPOINT Validate_CountRequest;
1028: --
1029: -- Standard Call to check for call compatibility
1030: IF NOT FND_API.Compatible_API_Call(l_api_version

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

1025: BEGIN
1026: -- Standard start of API savepoint
1027: SAVEPOINT Validate_CountRequest;
1028: --
1029: -- Standard Call to check for call compatibility
1030: IF NOT FND_API.Compatible_API_Call(l_api_version
1031: , p_api_version
1032: , l_api_name
1033: , G_PKG_NAME) THEN

Line 1524: -- Standard check of p_commit

1520: -- the flag means errors, processed with errors, not valid
1521: END IF;
1522: --
1523: -- END of API body
1524: -- Standard check of p_commit
1525: IF FND_API.to_Boolean(p_commit) THEN
1526: COMMIT;
1527: END IF;
1528: -- Standard call to get message count and if count is 1, get message info

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

1524: -- Standard check of p_commit
1525: IF FND_API.to_Boolean(p_commit) THEN
1526: COMMIT;
1527: END IF;
1528: -- Standard call to get message count and if count is 1, get message info
1529: FND_MSG_PUB.Count_And_Get
1530: (p_count => x_msg_count
1531: , p_data => x_msg_data);
1532: EXCEPTION

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

1570: END;
1571: --
1572: -- validates and simulates records from interface table
1573: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
1574: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1575: Procedure ValSim_CountRequest(
1576: p_api_version IN NUMBER ,
1577: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1578: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1627: -- Standard start of API savepoint

1623: --
1624: L_api_version CONSTANT NUMBER := 0.9;
1625: L_api_name CONSTANT VARCHAR2(30) := 'ValSim_CountRequest';
1626: BEGIN
1627: -- Standard start of API savepoint
1628: SAVEPOINT ValSim_CountRequest;
1629: --
1630: -- Standard Call to check for call compatibility
1631: IF NOT FND_API.Compatible_API_Call(l_api_version

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

1626: BEGIN
1627: -- Standard start of API savepoint
1628: SAVEPOINT ValSim_CountRequest;
1629: --
1630: -- Standard Call to check for call compatibility
1631: IF NOT FND_API.Compatible_API_Call(l_api_version
1632: , p_api_version
1633: , l_api_name
1634: , G_PKG_NAME) THEN

Line 1698: -- Standard check of p_commit

1694: --
1695: x_return_status := L_return_status;
1696: --
1697: -- END of API body
1698: -- Standard check of p_commit
1699: IF FND_API.to_Boolean(p_commit) THEN
1700: COMMIT;
1701: END IF;
1702: -- Standard call to get message count and if count is 1, get message info

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

1698: -- Standard check of p_commit
1699: IF FND_API.to_Boolean(p_commit) THEN
1700: COMMIT;
1701: END IF;
1702: -- Standard call to get message count and if count is 1, get message info
1703: FND_MSG_PUB.Count_And_Get
1704: (p_count => x_msg_count
1705: , p_data => x_msg_data);
1706: EXCEPTION

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

1738: END;
1739: --
1740: -- Updated or inserted the interface record table
1741: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
1742: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1743: PROCEDURE Update_Insert_CountRequest(
1744: p_api_version IN NUMBER ,
1745: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1746: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1804: -- Standard start of API savepoint

1800: --
1801: L_api_version CONSTANT NUMBER := 0.9;
1802: L_api_name CONSTANT VARCHAR2(30) := 'UpdateInsert_CountRequest';
1803: BEGIN
1804: -- Standard start of API savepoint
1805: SAVEPOINT UpdateInsert_CountRequest;
1806: --
1807: -- Standard Call to check for call compatibility
1808: IF NOT FND_API.Compatible_API_Call(l_api_version

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

1803: BEGIN
1804: -- Standard start of API savepoint
1805: SAVEPOINT UpdateInsert_CountRequest;
1806: --
1807: -- Standard Call to check for call compatibility
1808: IF NOT FND_API.Compatible_API_Call(l_api_version
1809: , p_api_version
1810: , l_api_name
1811: , G_PKG_NAME) THEN

Line 1878: -- Standard check of p_commit

1874: --
1875: x_return_status := L_return_status;
1876: --
1877: -- END of API body
1878: -- Standard check of p_commit
1879: IF FND_API.to_Boolean(p_commit) THEN
1880: COMMIT;
1881: END IF;
1882: -- Standard call to get message count and if count is 1, get message info

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

1878: -- Standard check of p_commit
1879: IF FND_API.to_Boolean(p_commit) THEN
1880: COMMIT;
1881: END IF;
1882: -- Standard call to get message count and if count is 1, get message info
1883: FND_MSG_PUB.Count_And_Get
1884: (p_count => x_msg_count
1885: , p_data => x_msg_data);
1886: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN