[Home] [Help]
1633: l_msg_data VARCHAR2(512);
1634:
1635:
1636: Begin
1637: -- Standard Start of API savepoint
1638: SAVEPOINT create_mass_edit_pub;
1639:
1640: csi_t_gen_utility_pvt.add('API Being Executed : CREATE_MASS_EDIT_BATCH_PUB');
1641: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1647:
1648: -- Initialize API return status to success
1649: x_return_status := FND_API.G_RET_STS_SUCCESS;
1650:
1651: -- Standard call to check for call compatibility.
1652: IF NOT
1653:
1654: FND_API.Compatible_API_Call (
1655: p_current_version_number => l_api_version,
1694: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1695: RAISE fnd_api.g_exc_error;
1696: END IF;
1697:
1698: -- Standard check of p_commit.
1699: IF FND_API.To_Boolean( p_commit ) THEN
1700: COMMIT WORK;
1701: END IF;
1702:
1699: IF FND_API.To_Boolean( p_commit ) THEN
1700: COMMIT WORK;
1701: END IF;
1702:
1703: -- Standard call to get message count and IF count is get message info.
1704: FND_MSG_PUB.Count_And_Get
1705: (p_count => x_msg_count,
1706: p_data => x_msg_data
1707: );
1798: l_return_status VARCHAR2(1);
1799: x_output varchar2(4000);
1800: BEGIN
1801:
1802: -- Standard Start of API savepoint
1803: SAVEPOINT update_mass_edit_pub;
1804:
1805: csi_t_gen_utility_pvt.add('API Being Executed : UPDATE_MASS_EDIT_BATCH_PUB');
1806: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1812:
1813: -- Initialize API return status to success
1814: x_return_status := FND_API.G_RET_STS_SUCCESS;
1815:
1816: -- Standard call to check for call compatibility.
1817: IF NOT
1818:
1819: FND_API.Compatible_API_Call (
1820: p_current_version_number => l_api_version,
1866: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1867: RAISE fnd_api.g_exc_error;
1868: END IF;
1869:
1870: -- Standard check of p_commit.
1871: IF FND_API.To_Boolean( p_commit ) THEN
1872: COMMIT WORK;
1873: END IF;
1874:
1926: l_return_status VARCHAR2(1);
1927:
1928: BEGIN
1929:
1930: -- Standard Start of API savepoint
1931: SAVEPOINT delete_mass_edit_batch;
1932:
1933: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCH');
1934: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1940:
1941: -- Initialize API return status to success
1942: x_return_status := FND_API.G_RET_STS_SUCCESS;
1943:
1944: -- Standard call to check for call compatibility.
1945: IF NOT
1946: FND_API.Compatible_API_Call (
1947: p_current_version_number => l_api_version,
1948: p_caller_version_number => p_api_version,
1983: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1984: RAISE fnd_api.g_exc_error;
1985: END IF;
1986:
1987: -- Standard check of p_commit.
1988: IF FND_API.To_Boolean( p_commit ) THEN
1989: COMMIT WORK;
1990: END IF;
1991:
1988: IF FND_API.To_Boolean( p_commit ) THEN
1989: COMMIT WORK;
1990: END IF;
1991:
1992: -- Standard call to get message count and IF count is get message info.
1993: FND_MSG_PUB.Count_And_Get
1994: (p_count => x_msg_count,
1995: p_data => x_msg_data
1996: );
2066: l_return_status VARCHAR2(1);
2067:
2068: BEGIN
2069:
2070: -- Standard Start of API savepoint
2071: SAVEPOINT delete_mass_edit_batches;
2072:
2073: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCHES');
2074: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2080:
2081: -- Initialize API return status to success
2082: x_return_status := FND_API.G_RET_STS_SUCCESS;
2083:
2084: -- Standard call to check for call compatibility.
2085: IF NOT
2086: FND_API.Compatible_API_Call (
2087: p_current_version_number => l_api_version,
2088: p_caller_version_number => p_api_version,
2127: END IF;
2128: END LOOP;
2129: END IF;
2130:
2131: -- Standard check of p_commit.
2132: IF FND_API.To_Boolean( p_commit ) THEN
2133: COMMIT WORK;
2134: END IF;
2135:
2132: IF FND_API.To_Boolean( p_commit ) THEN
2133: COMMIT WORK;
2134: END IF;
2135:
2136: -- Standard call to get message count and IF count is get message info.
2137: FND_MSG_PUB.Count_And_Get
2138: (p_count => x_msg_count,
2139: p_data => x_msg_data
2140: );
2214: l_return_status VARCHAR2(1);
2215:
2216: BEGIN
2217:
2218: -- Standard Start of API savepoint
2219: SAVEPOINT get_mass_edit_details;
2220:
2221: csi_t_gen_utility_pvt.add('API Being Executed : GET_MASS_EDIT_DETAILS');
2222: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2228:
2229: -- Initialize API return status to success
2230: x_return_status := FND_API.G_RET_STS_SUCCESS;
2231:
2232: -- Standard call to check for call compatibility.
2233: IF NOT
2234: FND_API.Compatible_API_Call (
2235: p_current_version_number => l_api_version,
2236: p_caller_version_number => p_api_version,
2278: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2279: RAISE fnd_api.g_exc_error;
2280: END IF;
2281:
2282: -- Standard check of p_commit.
2283: IF FND_API.To_Boolean( p_commit ) THEN
2284: COMMIT WORK;
2285: END IF;
2286:
2283: IF FND_API.To_Boolean( p_commit ) THEN
2284: COMMIT WORK;
2285: END IF;
2286:
2287: -- Standard call to get message count and IF count is get message info.
2288: FND_MSG_PUB.Count_And_Get
2289: (p_count => x_msg_count,
2290: p_data => x_msg_data
2291: );
2443: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2444:
2445: BEGIN
2446:
2447: -- Standard Start of API savepoint
2448: SAVEPOINT PROCESS_SYSTEM_MASS_UPDATE;
2449:
2450: debug('Inside PROCESS_SYSTEM_MASS_UPDATE');
2451:
2450: debug('Inside PROCESS_SYSTEM_MASS_UPDATE');
2451:
2452: csi_utility_grp.check_ib_active;
2453:
2454: -- Standard call to check for call compatibility.
2455: IF NOT FND_API.Compatible_API_Call (l_api_version,
2456: p_api_version,
2457: l_api_name ,
2458: G_PKG_NAME )