[Home] [Help]
1518: l_msg_data VARCHAR2(512);
1519:
1520:
1521: Begin
1522: -- Standard Start of API savepoint
1523: SAVEPOINT create_mass_edit_pub;
1524:
1525: csi_t_gen_utility_pvt.add('API Being Executed : CREATE_MASS_EDIT_BATCH_PUB');
1526: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1532:
1533: -- Initialize API return status to success
1534: x_return_status := FND_API.G_RET_STS_SUCCESS;
1535:
1536: -- Standard call to check for call compatibility.
1537: IF NOT
1538:
1539: FND_API.Compatible_API_Call (
1540: p_current_version_number => l_api_version,
1579: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1580: RAISE fnd_api.g_exc_error;
1581: END IF;
1582:
1583: -- Standard check of p_commit.
1584: IF FND_API.To_Boolean( p_commit ) THEN
1585: COMMIT WORK;
1586: END IF;
1587:
1584: IF FND_API.To_Boolean( p_commit ) THEN
1585: COMMIT WORK;
1586: END IF;
1587:
1588: -- Standard call to get message count and IF count is get message info.
1589: FND_MSG_PUB.Count_And_Get
1590: (p_count => x_msg_count,
1591: p_data => x_msg_data
1592: );
1683: l_return_status VARCHAR2(1);
1684: x_output varchar2(4000);
1685: BEGIN
1686:
1687: -- Standard Start of API savepoint
1688: SAVEPOINT update_mass_edit_pub;
1689:
1690: csi_t_gen_utility_pvt.add('API Being Executed : UPDATE_MASS_EDIT_BATCH_PUB');
1691: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1697:
1698: -- Initialize API return status to success
1699: x_return_status := FND_API.G_RET_STS_SUCCESS;
1700:
1701: -- Standard call to check for call compatibility.
1702: IF NOT
1703:
1704: FND_API.Compatible_API_Call (
1705: p_current_version_number => l_api_version,
1751: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1752: RAISE fnd_api.g_exc_error;
1753: END IF;
1754:
1755: -- Standard check of p_commit.
1756: IF FND_API.To_Boolean( p_commit ) THEN
1757: COMMIT WORK;
1758: END IF;
1759:
1811: l_return_status VARCHAR2(1);
1812:
1813: BEGIN
1814:
1815: -- Standard Start of API savepoint
1816: SAVEPOINT delete_mass_edit_batch;
1817:
1818: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCH');
1819: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1825:
1826: -- Initialize API return status to success
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;
1828:
1829: -- Standard call to check for call compatibility.
1830: IF NOT
1831: FND_API.Compatible_API_Call (
1832: p_current_version_number => l_api_version,
1833: p_caller_version_number => p_api_version,
1868: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1869: RAISE fnd_api.g_exc_error;
1870: END IF;
1871:
1872: -- Standard check of p_commit.
1873: IF FND_API.To_Boolean( p_commit ) THEN
1874: COMMIT WORK;
1875: END IF;
1876:
1873: IF FND_API.To_Boolean( p_commit ) THEN
1874: COMMIT WORK;
1875: END IF;
1876:
1877: -- Standard call to get message count and IF count is get message info.
1878: FND_MSG_PUB.Count_And_Get
1879: (p_count => x_msg_count,
1880: p_data => x_msg_data
1881: );
1951: l_return_status VARCHAR2(1);
1952:
1953: BEGIN
1954:
1955: -- Standard Start of API savepoint
1956: SAVEPOINT delete_mass_edit_batches;
1957:
1958: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCHES');
1959: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1965:
1966: -- Initialize API return status to success
1967: x_return_status := FND_API.G_RET_STS_SUCCESS;
1968:
1969: -- Standard call to check for call compatibility.
1970: IF NOT
1971: FND_API.Compatible_API_Call (
1972: p_current_version_number => l_api_version,
1973: p_caller_version_number => p_api_version,
2012: END IF;
2013: END LOOP;
2014: END IF;
2015:
2016: -- Standard check of p_commit.
2017: IF FND_API.To_Boolean( p_commit ) THEN
2018: COMMIT WORK;
2019: END IF;
2020:
2017: IF FND_API.To_Boolean( p_commit ) THEN
2018: COMMIT WORK;
2019: END IF;
2020:
2021: -- Standard call to get message count and IF count is get message info.
2022: FND_MSG_PUB.Count_And_Get
2023: (p_count => x_msg_count,
2024: p_data => x_msg_data
2025: );
2099: l_return_status VARCHAR2(1);
2100:
2101: BEGIN
2102:
2103: -- Standard Start of API savepoint
2104: SAVEPOINT get_mass_edit_details;
2105:
2106: csi_t_gen_utility_pvt.add('API Being Executed : GET_MASS_EDIT_DETAILS');
2107: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2113:
2114: -- Initialize API return status to success
2115: x_return_status := FND_API.G_RET_STS_SUCCESS;
2116:
2117: -- Standard call to check for call compatibility.
2118: IF NOT
2119: FND_API.Compatible_API_Call (
2120: p_current_version_number => l_api_version,
2121: p_caller_version_number => p_api_version,
2163: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2164: RAISE fnd_api.g_exc_error;
2165: END IF;
2166:
2167: -- Standard check of p_commit.
2168: IF FND_API.To_Boolean( p_commit ) THEN
2169: COMMIT WORK;
2170: END IF;
2171:
2168: IF FND_API.To_Boolean( p_commit ) THEN
2169: COMMIT WORK;
2170: END IF;
2171:
2172: -- Standard call to get message count and IF count is get message info.
2173: FND_MSG_PUB.Count_And_Get
2174: (p_count => x_msg_count,
2175: p_data => x_msg_data
2176: );
2328: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2329:
2330: BEGIN
2331:
2332: -- Standard Start of API savepoint
2333: SAVEPOINT PROCESS_SYSTEM_MASS_UPDATE;
2334:
2335: debug('Inside PROCESS_SYSTEM_MASS_UPDATE');
2336:
2335: debug('Inside PROCESS_SYSTEM_MASS_UPDATE');
2336:
2337: csi_utility_grp.check_ib_active;
2338:
2339: -- Standard call to check for call compatibility.
2340: IF NOT FND_API.Compatible_API_Call (l_api_version,
2341: p_api_version,
2342: l_api_name ,
2343: G_PKG_NAME )