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.CSI_MASS_EDIT_PUB dependencies on FND_MSG_PUB

Line 1231: -- l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

1227: -- l_msg_index := 1;
1228: -- l_Error_Message := l_Msg_Data;
1229: -- WHILE l_msg_count > 0
1230: -- LOOP
1231: -- l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1232: -- l_msg_index := l_msg_index + 1;
1233: -- l_Msg_Count := l_Msg_Count - 1;
1234: -- END LOOP;
1235: -- RAISE fnd_api.g_exc_error;

Line 1253: l_warning_message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

1249:
1250: l_warning_message := l_msg_data;
1251: WHILE l_msg_count > 0
1252: LOOP
1253: l_warning_message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1254: debug_out('Warning message '||l_msg_index||' from OKS API is :'||l_warning_message);
1255: l_msg_index := l_msg_index + 1;
1256: l_msg_count := l_msg_count - 1;
1257: END LOOP;

Line 1350: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

1346: l_msg_index := 1;
1347: l_Error_Message := l_Msg_Data;
1348: WHILE l_msg_count > 0
1349: LOOP
1350: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1351: l_msg_index := l_msg_index + 1;
1352: l_Msg_Count := l_Msg_Count - 1;
1353: END LOOP;
1354:

Line 1512: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

1508: l_msg_index := 1;
1509: l_Error_Message := l_Msg_Data;
1510: WHILE l_msg_count > 0
1511: LOOP
1512: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1513: --debug_out(' ');
1514: l_msg_index := l_msg_index + 1;
1515: l_Msg_Count := l_Msg_Count - 1;
1516: END LOOP;

Line 1645: FND_MSG_PUB.Initialize;

1641: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1642:
1643: -- Initialize message list if p_init_msg_list is set to TRUE.
1644: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1645: FND_MSG_PUB.Initialize;
1646: END IF;
1647:
1648: -- Initialize API return status to success
1649: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1704: FND_MSG_PUB.Count_And_Get

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: );
1708:

Line 1714: FND_MSG_PUB.Count_And_Get

1710: EXCEPTION
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: ROLLBACK TO create_mass_edit_pub;
1713: x_return_status := FND_API.G_RET_STS_ERROR ;
1714: FND_MSG_PUB.Count_And_Get
1715: (p_count => x_msg_count,
1716: p_data => x_msg_data
1717: );
1718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1721: FND_MSG_PUB.Count_And_Get

1717: );
1718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1720: ROLLBACK TO create_mass_edit_pub;
1721: FND_MSG_PUB.Count_And_Get
1722: ( p_count => x_msg_count,
1723: p_data => x_msg_data
1724: );
1725: WHEN OTHERS THEN

Line 1728: IF FND_MSG_PUB.Check_Msg_Level

1724: );
1725: WHEN OTHERS THEN
1726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1727: ROLLBACK TO create_mass_edit_pub;
1728: IF FND_MSG_PUB.Check_Msg_Level
1729: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1730: THEN
1731: FND_MSG_PUB.Add_Exc_Msg
1732: (G_PKG_NAME ,

Line 1729: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1725: WHEN OTHERS THEN
1726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1727: ROLLBACK TO create_mass_edit_pub;
1728: IF FND_MSG_PUB.Check_Msg_Level
1729: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1730: THEN
1731: FND_MSG_PUB.Add_Exc_Msg
1732: (G_PKG_NAME ,
1733: l_api_name

Line 1731: FND_MSG_PUB.Add_Exc_Msg

1727: ROLLBACK TO create_mass_edit_pub;
1728: IF FND_MSG_PUB.Check_Msg_Level
1729: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1730: THEN
1731: FND_MSG_PUB.Add_Exc_Msg
1732: (G_PKG_NAME ,
1733: l_api_name
1734: );
1735: END IF;

Line 1736: FND_MSG_PUB.Count_And_Get

1732: (G_PKG_NAME ,
1733: l_api_name
1734: );
1735: END IF;
1736: FND_MSG_PUB.Count_And_Get
1737: (p_count => x_msg_count,
1738: p_data => x_msg_data
1739: );
1740:

Line 1810: FND_MSG_PUB.Initialize;

1806: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1807:
1808: -- Initialize message list if p_init_msg_list is set to TRUE.
1809: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1810: FND_MSG_PUB.Initialize;
1811: END IF;
1812:
1813: -- Initialize API return status to success
1814: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1838: FND_MSG_PUB.add;

1834:
1835: IF x_output IS NOT NULL THEN
1836: FND_MESSAGE.set_name('CSI','CSI_MU_DUP_BATCH_INSTANCES');
1837: FND_MESSAGE.set_token('INST_NUM',x_output);
1838: FND_MSG_PUB.add;
1839: RAISE FND_API.g_exc_error;
1840: END IF;
1841:
1842: -- call API to run

Line 1880: FND_MSG_PUB.Count_And_Get

1876: EXCEPTION
1877: WHEN FND_API.G_EXC_ERROR THEN
1878: ROLLBACK TO update_mass_edit_pub;
1879: x_return_status := FND_API.G_RET_STS_ERROR ;
1880: FND_MSG_PUB.Count_And_Get
1881: (p_count => x_msg_count,
1882: p_data => x_msg_data
1883: );
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1887: FND_MSG_PUB.Count_And_Get

1883: );
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1886: ROLLBACK TO update_mass_edit_pub;
1887: FND_MSG_PUB.Count_And_Get
1888: ( p_count => x_msg_count,
1889: p_data => x_msg_data
1890: );
1891: WHEN OTHERS THEN

Line 1894: IF FND_MSG_PUB.Check_Msg_Level

1890: );
1891: WHEN OTHERS THEN
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1893: ROLLBACK TO update_mass_edit_pub;
1894: IF FND_MSG_PUB.Check_Msg_Level
1895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1896: THEN
1897: FND_MSG_PUB.Add_Exc_Msg
1898: (G_PKG_NAME ,

Line 1895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1891: WHEN OTHERS THEN
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1893: ROLLBACK TO update_mass_edit_pub;
1894: IF FND_MSG_PUB.Check_Msg_Level
1895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1896: THEN
1897: FND_MSG_PUB.Add_Exc_Msg
1898: (G_PKG_NAME ,
1899: l_api_name

Line 1897: FND_MSG_PUB.Add_Exc_Msg

1893: ROLLBACK TO update_mass_edit_pub;
1894: IF FND_MSG_PUB.Check_Msg_Level
1895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1896: THEN
1897: FND_MSG_PUB.Add_Exc_Msg
1898: (G_PKG_NAME ,
1899: l_api_name
1900: );
1901: END IF;

Line 1902: FND_MSG_PUB.Count_And_Get

1898: (G_PKG_NAME ,
1899: l_api_name
1900: );
1901: END IF;
1902: FND_MSG_PUB.Count_And_Get
1903: (p_count => x_msg_count,
1904: p_data => x_msg_data
1905: );
1906:

Line 1938: FND_MSG_PUB.Initialize;

1934: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1935:
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1938: FND_MSG_PUB.Initialize;
1939: END IF;
1940:
1941: -- Initialize API return status to success
1942: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1968: FND_MSG_PUB.add;

1964:
1965: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1966: FND_MESSAGE.set_token('API_NAME',l_api_name);
1967: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1968: FND_MSG_PUB.add;
1969: RAISE FND_API.g_exc_error;
1970: END IF;
1971:
1972: csi_mass_edit_pvt.delete_mass_edit_batch (

Line 1993: FND_MSG_PUB.Count_And_Get

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: );
1997:

Line 2008: FND_MSG_PUB.Count_And_Get (

2004: WHEN FND_API.G_EXC_ERROR THEN
2005:
2006: ROLLBACK TO Delete_Mass_Edit_Batch;
2007: x_return_status := FND_API.G_RET_STS_ERROR ;
2008: FND_MSG_PUB.Count_And_Get (
2009: p_count => x_msg_count,
2010: p_data => x_msg_data);
2011:
2012: csi_t_gen_utility_pvt.set_debug_off;

Line 2019: FND_MSG_PUB.Count_And_Get(

2015:
2016: ROLLBACK TO Delete_Mass_Edit_Batch;
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2018:
2019: FND_MSG_PUB.Count_And_Get(
2020: p_count => x_msg_count,
2021: p_data => x_msg_data);
2022:
2023: csi_t_gen_utility_pvt.set_debug_off;

Line 2030: IF FND_MSG_PUB.Check_Msg_Level(

2026:
2027: ROLLBACK TO Delete_Mass_Edit_Batch;
2028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2029:
2030: IF FND_MSG_PUB.Check_Msg_Level(
2031: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2032:
2033: FND_MSG_PUB.Add_Exc_Msg(
2034: p_pkg_name => G_PKG_NAME,

Line 2031: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2027: ROLLBACK TO Delete_Mass_Edit_Batch;
2028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2029:
2030: IF FND_MSG_PUB.Check_Msg_Level(
2031: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2032:
2033: FND_MSG_PUB.Add_Exc_Msg(
2034: p_pkg_name => G_PKG_NAME,
2035: p_procedure_name => l_api_name);

Line 2033: FND_MSG_PUB.Add_Exc_Msg(

2029:
2030: IF FND_MSG_PUB.Check_Msg_Level(
2031: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2032:
2033: FND_MSG_PUB.Add_Exc_Msg(
2034: p_pkg_name => G_PKG_NAME,
2035: p_procedure_name => l_api_name);
2036:
2037: END IF;

Line 2039: FND_MSG_PUB.Count_And_Get(

2035: p_procedure_name => l_api_name);
2036:
2037: END IF;
2038:
2039: FND_MSG_PUB.Count_And_Get(
2040: p_count => x_msg_count,
2041: p_data => x_msg_data);
2042:
2043: csi_t_gen_utility_pvt.set_debug_off;

Line 2078: FND_MSG_PUB.Initialize;

2074: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2075:
2076: -- Initialize message list if p_init_msg_list is set to TRUE.
2077: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2078: FND_MSG_PUB.Initialize;
2079: END IF;
2080:
2081: -- Initialize API return status to success
2082: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2110: FND_MSG_PUB.add;

2106:
2107: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2108: FND_MESSAGE.set_token('API_NAME',l_api_name);
2109: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
2110: FND_MSG_PUB.add;
2111: RAISE FND_API.g_exc_error;
2112: END IF;
2113:
2114: csi_mass_edit_pvt.delete_mass_edit_batch (

Line 2137: FND_MSG_PUB.Count_And_Get

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: );
2141:

Line 2152: FND_MSG_PUB.Count_And_Get (

2148: WHEN FND_API.G_EXC_ERROR THEN
2149:
2150: ROLLBACK TO Delete_Mass_Edit_Batches;
2151: x_return_status := FND_API.G_RET_STS_ERROR ;
2152: FND_MSG_PUB.Count_And_Get (
2153: p_count => x_msg_count,
2154: p_data => x_msg_data);
2155:
2156: csi_t_gen_utility_pvt.set_debug_off;

Line 2163: FND_MSG_PUB.Count_And_Get(

2159:
2160: ROLLBACK TO Delete_Mass_Edit_Batches;
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162:
2163: FND_MSG_PUB.Count_And_Get(
2164: p_count => x_msg_count,
2165: p_data => x_msg_data);
2166:
2167: csi_t_gen_utility_pvt.set_debug_off;

Line 2174: IF FND_MSG_PUB.Check_Msg_Level(

2170:
2171: ROLLBACK TO Delete_Mass_Edit_Batches;
2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2173:
2174: IF FND_MSG_PUB.Check_Msg_Level(
2175: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2176:
2177: FND_MSG_PUB.Add_Exc_Msg(
2178: p_pkg_name => G_PKG_NAME,

Line 2175: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2171: ROLLBACK TO Delete_Mass_Edit_Batches;
2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2173:
2174: IF FND_MSG_PUB.Check_Msg_Level(
2175: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2176:
2177: FND_MSG_PUB.Add_Exc_Msg(
2178: p_pkg_name => G_PKG_NAME,
2179: p_procedure_name => l_api_name);

Line 2177: FND_MSG_PUB.Add_Exc_Msg(

2173:
2174: IF FND_MSG_PUB.Check_Msg_Level(
2175: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2176:
2177: FND_MSG_PUB.Add_Exc_Msg(
2178: p_pkg_name => G_PKG_NAME,
2179: p_procedure_name => l_api_name);
2180: END IF;
2181:

Line 2182: FND_MSG_PUB.Count_And_Get(

2178: p_pkg_name => G_PKG_NAME,
2179: p_procedure_name => l_api_name);
2180: END IF;
2181:
2182: FND_MSG_PUB.Count_And_Get(
2183: p_count => x_msg_count,
2184: p_data => x_msg_data);
2185:
2186: csi_t_gen_utility_pvt.set_debug_off;

Line 2226: FND_MSG_PUB.Initialize;

2222: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2223:
2224: -- Initialize message list if p_init_msg_list is set to TRUE.
2225: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2226: FND_MSG_PUB.Initialize;
2227: END IF;
2228:
2229: -- Initialize API return status to success
2230: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2259: FND_MSG_PUB.add;

2255: ) THEN
2256: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2257: FND_MESSAGE.set_token('API_NAME',l_api_name);
2258: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');
2259: FND_MSG_PUB.add;
2260: RAISE FND_API.g_exc_error;
2261: END IF;
2262:
2263: csi_mass_edit_pvt.get_mass_edit_details (

Line 2288: FND_MSG_PUB.Count_And_Get

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: );
2292:

Line 2303: FND_MSG_PUB.Count_And_Get (

2299: WHEN FND_API.G_EXC_ERROR THEN
2300:
2301: ROLLBACK TO Get_mass_edit_details;
2302: x_return_status := FND_API.G_RET_STS_ERROR ;
2303: FND_MSG_PUB.Count_And_Get (
2304: p_count => x_msg_count,
2305: p_data => x_msg_data);
2306:
2307: csi_t_gen_utility_pvt.set_debug_off;

Line 2314: FND_MSG_PUB.Count_And_Get(

2310:
2311: ROLLBACK TO Get_mass_edit_details;
2312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2313:
2314: FND_MSG_PUB.Count_And_Get(
2315: p_count => x_msg_count,
2316: p_data => x_msg_data);
2317:
2318: csi_t_gen_utility_pvt.set_debug_off;

Line 2325: IF FND_MSG_PUB.Check_Msg_Level(

2321:
2322: ROLLBACK TO Get_mass_edit_details;
2323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2324:
2325: IF FND_MSG_PUB.Check_Msg_Level(
2326: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2327:
2328: FND_MSG_PUB.Add_Exc_Msg(
2329: p_pkg_name => G_PKG_NAME,

Line 2326: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2322: ROLLBACK TO Get_mass_edit_details;
2323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2324:
2325: IF FND_MSG_PUB.Check_Msg_Level(
2326: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2327:
2328: FND_MSG_PUB.Add_Exc_Msg(
2329: p_pkg_name => G_PKG_NAME,
2330: p_procedure_name => l_api_name);

Line 2328: FND_MSG_PUB.Add_Exc_Msg(

2324:
2325: IF FND_MSG_PUB.Check_Msg_Level(
2326: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2327:
2328: FND_MSG_PUB.Add_Exc_Msg(
2329: p_pkg_name => G_PKG_NAME,
2330: p_procedure_name => l_api_name);
2331:
2332: END IF;

Line 2334: FND_MSG_PUB.Count_And_Get(

2330: p_procedure_name => l_api_name);
2331:
2332: END IF;
2333:
2334: FND_MSG_PUB.Count_And_Get(
2335: p_count => x_msg_count,
2336: p_data => x_msg_data);
2337:
2338: csi_t_gen_utility_pvt.set_debug_off;

Line 2543: fnd_msg_pub.add;

2539: WHEN NO_DATA_FOUND THEN
2540: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2541: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2542: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2543: fnd_msg_pub.add;
2544: RAISE FND_API.G_EXC_ERROR;
2545:
2546: WHEN TOO_MANY_ROWS THEN
2547: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');

Line 2550: fnd_msg_pub.add;

2546: WHEN TOO_MANY_ROWS THEN
2547: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2548: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2549: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2550: fnd_msg_pub.add;
2551: RAISE FND_API.G_EXC_ERROR;
2552: WHEN OTHERS THEN
2553: debug('In to Others Exception while finding customer id');
2554: RAISE FND_API.G_EXC_ERROR;

Line 2705: FND_MSG_PUB.Count_And_Get

2701: EXCEPTION
2702: WHEN FND_API.G_EXC_ERROR THEN
2703: ROLLBACK TO PROCESS_SYSTEM_MASS_UPDATE;
2704: x_return_status := FND_API.G_RET_STS_ERROR ;
2705: FND_MSG_PUB.Count_And_Get
2706: ( p_count => x_msg_count,
2707: p_data => x_msg_data
2708: );
2709:

Line 2713: FND_MSG_PUB.Count_And_Get

2709:
2710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2711: ROLLBACK TO PROCESS_SYSTEM_MASS_UPDATE;
2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2713: FND_MSG_PUB.Count_And_Get
2714: ( p_count => x_msg_count,
2715: p_data => x_msg_data
2716: );
2717:

Line 2721: IF FND_MSG_PUB.Check_Msg_Level

2717:
2718: WHEN OTHERS THEN
2719: ROLLBACK TO PROCESS_SYSTEM_MASS_UPDATE;
2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2721: IF FND_MSG_PUB.Check_Msg_Level
2722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2723: THEN
2724: FND_MSG_PUB.Add_Exc_Msg
2725: ( G_PKG_NAME ,

Line 2722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2718: WHEN OTHERS THEN
2719: ROLLBACK TO PROCESS_SYSTEM_MASS_UPDATE;
2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2721: IF FND_MSG_PUB.Check_Msg_Level
2722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2723: THEN
2724: FND_MSG_PUB.Add_Exc_Msg
2725: ( G_PKG_NAME ,
2726: l_api_name

Line 2724: FND_MSG_PUB.Add_Exc_Msg

2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2721: IF FND_MSG_PUB.Check_Msg_Level
2722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2723: THEN
2724: FND_MSG_PUB.Add_Exc_Msg
2725: ( G_PKG_NAME ,
2726: l_api_name
2727: );
2728: END IF;

Line 2729: FND_MSG_PUB.Count_And_Get

2725: ( G_PKG_NAME ,
2726: l_api_name
2727: );
2728: END IF;
2729: FND_MSG_PUB.Count_And_Get
2730: ( p_count => x_msg_count,
2731: p_data => x_msg_data
2732: );
2733: END PROCESS_SYSTEM_MASS_UPDATE; -- PROCESS_SYSTEM_MASS_UPDATE

Line 2885: fnd_msg_pub.add;

2881: WHEN NO_DATA_FOUND THEN
2882: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2883: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2884: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2885: fnd_msg_pub.add;
2886: RAISE FND_API.G_EXC_ERROR;
2887:
2888: WHEN TOO_MANY_ROWS THEN
2889: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');

Line 2892: fnd_msg_pub.add;

2888: WHEN TOO_MANY_ROWS THEN
2889: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2890: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2891: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2892: fnd_msg_pub.add;
2893: RAISE FND_API.G_EXC_ERROR;
2894: WHEN OTHERS THEN
2895: debug('In to Others Exception while finding customer id');
2896: RAISE FND_API.G_EXC_ERROR;

Line 3098: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3094: debug('Call to csi_transactions_pvt.create_transaction not successful');
3095: l_msg_index := 1;
3096: l_Error_Message := l_msg_data;
3097: WHILE l_msg_count > 0 LOOP
3098: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3099: l_msg_index := l_msg_index + 1;
3100: l_msg_count := l_msg_count - 1;
3101: debug_out('Error: ' || l_Error_Message);
3102: END LOOP;

Line 4089: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

4085: l_falied_count := l_falied_count + c_instance_tbl.count;
4086: l_msg_index := 1;
4087: l_Error_Message := l_Msg_Data;
4088: WHILE l_msg_count > 0 LOOP
4089: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
4090: l_msg_index := l_msg_index + 1;
4091: l_msg_count := l_msg_count - 1;
4092: debug('Error: ' || l_Error_Message);
4093: END LOOP;

Line 4213: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

4209: l_msg_index := 1;
4210: l_Error_Message := l_msg_data;
4211: WHILE l_msg_count > 0
4212: LOOP
4213: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
4214: l_msg_index := l_msg_index + 1;
4215: l_msg_count := l_msg_count - 1;
4216: debug('Error: ' || l_Error_Message);
4217: END LOOP;

Line 4262: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

4258: debug('Call to create_relationship while Create is not successful');
4259: l_msg_index := 1;
4260: l_Error_Message := l_Msg_Data;
4261: WHILE l_msg_count > 0 LOOP
4262: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
4263: l_msg_index := l_msg_index + 1;
4264: l_msg_count := l_msg_count - 1;
4265: debug('Error: ' || l_Error_Message);
4266: END LOOP;

Line 4355: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

4351:
4352: l_msg_index := 1;
4353: l_Error_Message := l_msg_data;
4354: WHILE l_msg_count > 0 LOOP
4355: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
4356: l_msg_index := l_msg_index + 1;
4357: l_msg_count := l_msg_count - 1;
4358: debug('Error: ' || l_Error_Message);
4359: END LOOP;

Line 5724: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

5720: debug_out('Update of the instances not successful, please check the request log for further details.');
5721: l_msg_index := 1;
5722: l_Error_Message := l_msg_Data;
5723: WHILE l_msg_count > 0 LOOP
5724: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
5725: l_msg_index := l_msg_index + 1;
5726: l_msg_count := l_msg_count - 1;
5727: debug('Error: ' || l_Error_Message);
5728: END LOOP;

Line 5780: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

5776: l_msg_index := 1;
5777: l_Error_Message := l_msg_data;
5778: WHILE l_msg_count > 0
5779: LOOP
5780: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
5781: l_msg_index := l_msg_index + 1;
5782: l_msg_count := l_msg_count - 1;
5783: debug('Error: ' || l_Error_Message);
5784: END LOOP;

Line 5857: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

5853: debug('Call to csi_ii_relationships_pub.expire_relationship falied.');
5854: l_msg_index := 1;
5855: l_Error_Message := l_Msg_Data;
5856: WHILE l_msg_count > 0 LOOP
5857: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
5858: l_msg_index := l_msg_index + 1;
5859: l_msg_count := l_msg_count - 1;
5860: debug('Error: ' || l_Error_Message);
5861: END LOOP;

Line 5891: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

5887: debug('Call to csi_ii_relationships_pub.create_relationship not successful');
5888: l_msg_index := 1;
5889: l_Error_Message := l_Msg_Data;
5890: WHILE l_msg_count > 0 LOOP
5891: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
5892: l_msg_index := l_msg_index + 1;
5893: l_msg_count := l_msg_count - 1;
5894: debug('Error: ' || l_Error_Message);
5895: END LOOP;

Line 5951: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

5947: l_split_inst_num_tbl(inst_tab_row) );
5948: l_msg_index := 1;
5949: l_Error_Message := l_Msg_Data;
5950: WHILE l_msg_count > 0 LOOP
5951: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
5952: l_msg_index := l_msg_index + 1;
5953: l_msg_count := l_msg_count - 1;
5954: debug('Error: ' || l_Error_Message);
5955: END LOOP;

Line 6035: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

6031: debug('Error: ');
6032: l_msg_index := 1;
6033: l_Error_Message := l_msg_data;
6034: WHILE l_msg_count > 0 LOOP
6035: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
6036: l_msg_index := l_msg_index + 1;
6037: l_msg_count := l_msg_count - 1;
6038: debug('Error: ' || l_Error_Message);
6039: END LOOP;

Line 6082: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

6078: l_instance_number);
6079: l_msg_index := 1;
6080: l_Error_Message := l_msg_data;
6081: WHILE l_msg_count > 0 LOOP
6082: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
6083: l_msg_index := l_msg_index + 1;
6084: l_msg_count := l_msg_count - 1;
6085: debug('Error: ' || l_Error_Message);
6086: END LOOP;

Line 6174: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

6170: debug('Call to CREATE_MASS_EDIT_BATCH for new re-upload batch not successful');
6171: l_msg_index := 1;
6172: l_Error_Message := l_Msg_Data;
6173: WHILE l_msg_count > 0 LOOP
6174: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
6175: l_msg_index := l_msg_index + 1;
6176: l_msg_count := l_msg_count - 1;
6177: debug('Error: ' || l_Error_Message);
6178: END LOOP;