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 1117: -- l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

1113: -- l_msg_index := 1;
1114: -- l_Error_Message := l_Msg_Data;
1115: -- WHILE l_msg_count > 0
1116: -- LOOP
1117: -- l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1118: -- l_msg_index := l_msg_index + 1;
1119: -- l_Msg_Count := l_Msg_Count - 1;
1120: -- END LOOP;
1121: -- RAISE fnd_api.g_exc_error;

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

1135:
1136: l_warning_message := l_msg_data;
1137: WHILE l_msg_count > 0
1138: LOOP
1139: l_warning_message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1140: debug_out('Warning message '||l_msg_index||' from OKS API is :'||l_warning_message);
1141: l_msg_index := l_msg_index + 1;
1142: l_msg_count := l_msg_count - 1;
1143: END LOOP;

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

1232: l_msg_index := 1;
1233: l_Error_Message := l_Msg_Data;
1234: WHILE l_msg_count > 0
1235: LOOP
1236: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1237: l_msg_index := l_msg_index + 1;
1238: l_Msg_Count := l_Msg_Count - 1;
1239: END LOOP;
1240:

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

1394: l_msg_index := 1;
1395: l_Error_Message := l_Msg_Data;
1396: WHILE l_msg_count > 0
1397: LOOP
1398: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1399: l_msg_index := l_msg_index + 1;
1400: l_Msg_Count := l_Msg_Count - 1;
1401: END LOOP;
1402: RAISE fnd_api.g_exc_error;

Line 1530: FND_MSG_PUB.Initialize;

1526: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1527:
1528: -- Initialize message list if p_init_msg_list is set to TRUE.
1529: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1530: FND_MSG_PUB.Initialize;
1531: END IF;
1532:
1533: -- Initialize API return status to success
1534: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1589: FND_MSG_PUB.Count_And_Get

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

Line 1599: FND_MSG_PUB.Count_And_Get

1595: EXCEPTION
1596: WHEN FND_API.G_EXC_ERROR THEN
1597: ROLLBACK TO create_mass_edit_pub;
1598: x_return_status := FND_API.G_RET_STS_ERROR ;
1599: FND_MSG_PUB.Count_And_Get
1600: (p_count => x_msg_count,
1601: p_data => x_msg_data
1602: );
1603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1606: FND_MSG_PUB.Count_And_Get

1602: );
1603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1605: ROLLBACK TO create_mass_edit_pub;
1606: FND_MSG_PUB.Count_And_Get
1607: ( p_count => x_msg_count,
1608: p_data => x_msg_data
1609: );
1610: WHEN OTHERS THEN

Line 1613: IF FND_MSG_PUB.Check_Msg_Level

1609: );
1610: WHEN OTHERS THEN
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612: ROLLBACK TO create_mass_edit_pub;
1613: IF FND_MSG_PUB.Check_Msg_Level
1614: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Add_Exc_Msg
1617: (G_PKG_NAME ,

Line 1614: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1610: WHEN OTHERS THEN
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612: ROLLBACK TO create_mass_edit_pub;
1613: IF FND_MSG_PUB.Check_Msg_Level
1614: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Add_Exc_Msg
1617: (G_PKG_NAME ,
1618: l_api_name

Line 1616: FND_MSG_PUB.Add_Exc_Msg

1612: ROLLBACK TO create_mass_edit_pub;
1613: IF FND_MSG_PUB.Check_Msg_Level
1614: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Add_Exc_Msg
1617: (G_PKG_NAME ,
1618: l_api_name
1619: );
1620: END IF;

Line 1621: FND_MSG_PUB.Count_And_Get

1617: (G_PKG_NAME ,
1618: l_api_name
1619: );
1620: END IF;
1621: FND_MSG_PUB.Count_And_Get
1622: (p_count => x_msg_count,
1623: p_data => x_msg_data
1624: );
1625:

Line 1695: FND_MSG_PUB.Initialize;

1691: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1692:
1693: -- Initialize message list if p_init_msg_list is set to TRUE.
1694: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1695: FND_MSG_PUB.Initialize;
1696: END IF;
1697:
1698: -- Initialize API return status to success
1699: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1723: FND_MSG_PUB.add;

1719:
1720: IF x_output IS NOT NULL THEN
1721: FND_MESSAGE.set_name('CSI','CSI_MU_DUP_BATCH_INSTANCES');
1722: FND_MESSAGE.set_token('INST_NUM',x_output);
1723: FND_MSG_PUB.add;
1724: RAISE FND_API.g_exc_error;
1725: END IF;
1726:
1727: -- call API to run

Line 1765: FND_MSG_PUB.Count_And_Get

1761: EXCEPTION
1762: WHEN FND_API.G_EXC_ERROR THEN
1763: ROLLBACK TO update_mass_edit_pub;
1764: x_return_status := FND_API.G_RET_STS_ERROR ;
1765: FND_MSG_PUB.Count_And_Get
1766: (p_count => x_msg_count,
1767: p_data => x_msg_data
1768: );
1769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1772: FND_MSG_PUB.Count_And_Get

1768: );
1769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1771: ROLLBACK TO update_mass_edit_pub;
1772: FND_MSG_PUB.Count_And_Get
1773: ( p_count => x_msg_count,
1774: p_data => x_msg_data
1775: );
1776: WHEN OTHERS THEN

Line 1779: IF FND_MSG_PUB.Check_Msg_Level

1775: );
1776: WHEN OTHERS THEN
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1778: ROLLBACK TO update_mass_edit_pub;
1779: IF FND_MSG_PUB.Check_Msg_Level
1780: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1781: THEN
1782: FND_MSG_PUB.Add_Exc_Msg
1783: (G_PKG_NAME ,

Line 1780: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1776: WHEN OTHERS THEN
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1778: ROLLBACK TO update_mass_edit_pub;
1779: IF FND_MSG_PUB.Check_Msg_Level
1780: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1781: THEN
1782: FND_MSG_PUB.Add_Exc_Msg
1783: (G_PKG_NAME ,
1784: l_api_name

Line 1782: FND_MSG_PUB.Add_Exc_Msg

1778: ROLLBACK TO update_mass_edit_pub;
1779: IF FND_MSG_PUB.Check_Msg_Level
1780: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1781: THEN
1782: FND_MSG_PUB.Add_Exc_Msg
1783: (G_PKG_NAME ,
1784: l_api_name
1785: );
1786: END IF;

Line 1787: FND_MSG_PUB.Count_And_Get

1783: (G_PKG_NAME ,
1784: l_api_name
1785: );
1786: END IF;
1787: FND_MSG_PUB.Count_And_Get
1788: (p_count => x_msg_count,
1789: p_data => x_msg_data
1790: );
1791:

Line 1823: FND_MSG_PUB.Initialize;

1819: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1820:
1821: -- Initialize message list if p_init_msg_list is set to TRUE.
1822: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1823: FND_MSG_PUB.Initialize;
1824: END IF;
1825:
1826: -- Initialize API return status to success
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1853: FND_MSG_PUB.add;

1849:
1850: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1851: FND_MESSAGE.set_token('API_NAME',l_api_name);
1852: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1853: FND_MSG_PUB.add;
1854: RAISE FND_API.g_exc_error;
1855: END IF;
1856:
1857: csi_mass_edit_pvt.delete_mass_edit_batch (

Line 1878: FND_MSG_PUB.Count_And_Get

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

Line 1893: FND_MSG_PUB.Count_And_Get (

1889: WHEN FND_API.G_EXC_ERROR THEN
1890:
1891: ROLLBACK TO Delete_Mass_Edit_Batch;
1892: x_return_status := FND_API.G_RET_STS_ERROR ;
1893: FND_MSG_PUB.Count_And_Get (
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:
1897: csi_t_gen_utility_pvt.set_debug_off;

Line 1904: FND_MSG_PUB.Count_And_Get(

1900:
1901: ROLLBACK TO Delete_Mass_Edit_Batch;
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1903:
1904: FND_MSG_PUB.Count_And_Get(
1905: p_count => x_msg_count,
1906: p_data => x_msg_data);
1907:
1908: csi_t_gen_utility_pvt.set_debug_off;

Line 1915: IF FND_MSG_PUB.Check_Msg_Level(

1911:
1912: ROLLBACK TO Delete_Mass_Edit_Batch;
1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1914:
1915: IF FND_MSG_PUB.Check_Msg_Level(
1916: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1917:
1918: FND_MSG_PUB.Add_Exc_Msg(
1919: p_pkg_name => G_PKG_NAME,

Line 1916: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1912: ROLLBACK TO Delete_Mass_Edit_Batch;
1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1914:
1915: IF FND_MSG_PUB.Check_Msg_Level(
1916: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1917:
1918: FND_MSG_PUB.Add_Exc_Msg(
1919: p_pkg_name => G_PKG_NAME,
1920: p_procedure_name => l_api_name);

Line 1918: FND_MSG_PUB.Add_Exc_Msg(

1914:
1915: IF FND_MSG_PUB.Check_Msg_Level(
1916: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1917:
1918: FND_MSG_PUB.Add_Exc_Msg(
1919: p_pkg_name => G_PKG_NAME,
1920: p_procedure_name => l_api_name);
1921:
1922: END IF;

Line 1924: FND_MSG_PUB.Count_And_Get(

1920: p_procedure_name => l_api_name);
1921:
1922: END IF;
1923:
1924: FND_MSG_PUB.Count_And_Get(
1925: p_count => x_msg_count,
1926: p_data => x_msg_data);
1927:
1928: csi_t_gen_utility_pvt.set_debug_off;

Line 1963: FND_MSG_PUB.Initialize;

1959: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1960:
1961: -- Initialize message list if p_init_msg_list is set to TRUE.
1962: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1963: FND_MSG_PUB.Initialize;
1964: END IF;
1965:
1966: -- Initialize API return status to success
1967: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1995: FND_MSG_PUB.add;

1991:
1992: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1993: FND_MESSAGE.set_token('API_NAME',l_api_name);
1994: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1995: FND_MSG_PUB.add;
1996: RAISE FND_API.g_exc_error;
1997: END IF;
1998:
1999: csi_mass_edit_pvt.delete_mass_edit_batch (

Line 2022: FND_MSG_PUB.Count_And_Get

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

Line 2037: FND_MSG_PUB.Count_And_Get (

2033: WHEN FND_API.G_EXC_ERROR THEN
2034:
2035: ROLLBACK TO Delete_Mass_Edit_Batches;
2036: x_return_status := FND_API.G_RET_STS_ERROR ;
2037: FND_MSG_PUB.Count_And_Get (
2038: p_count => x_msg_count,
2039: p_data => x_msg_data);
2040:
2041: csi_t_gen_utility_pvt.set_debug_off;

Line 2048: FND_MSG_PUB.Count_And_Get(

2044:
2045: ROLLBACK TO Delete_Mass_Edit_Batches;
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2047:
2048: FND_MSG_PUB.Count_And_Get(
2049: p_count => x_msg_count,
2050: p_data => x_msg_data);
2051:
2052: csi_t_gen_utility_pvt.set_debug_off;

Line 2059: IF FND_MSG_PUB.Check_Msg_Level(

2055:
2056: ROLLBACK TO Delete_Mass_Edit_Batches;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2058:
2059: IF FND_MSG_PUB.Check_Msg_Level(
2060: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2061:
2062: FND_MSG_PUB.Add_Exc_Msg(
2063: p_pkg_name => G_PKG_NAME,

Line 2060: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2056: ROLLBACK TO Delete_Mass_Edit_Batches;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2058:
2059: IF FND_MSG_PUB.Check_Msg_Level(
2060: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2061:
2062: FND_MSG_PUB.Add_Exc_Msg(
2063: p_pkg_name => G_PKG_NAME,
2064: p_procedure_name => l_api_name);

Line 2062: FND_MSG_PUB.Add_Exc_Msg(

2058:
2059: IF FND_MSG_PUB.Check_Msg_Level(
2060: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2061:
2062: FND_MSG_PUB.Add_Exc_Msg(
2063: p_pkg_name => G_PKG_NAME,
2064: p_procedure_name => l_api_name);
2065: END IF;
2066:

Line 2067: FND_MSG_PUB.Count_And_Get(

2063: p_pkg_name => G_PKG_NAME,
2064: p_procedure_name => l_api_name);
2065: END IF;
2066:
2067: FND_MSG_PUB.Count_And_Get(
2068: p_count => x_msg_count,
2069: p_data => x_msg_data);
2070:
2071: csi_t_gen_utility_pvt.set_debug_off;

Line 2111: FND_MSG_PUB.Initialize;

2107: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2108:
2109: -- Initialize message list if p_init_msg_list is set to TRUE.
2110: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2111: FND_MSG_PUB.Initialize;
2112: END IF;
2113:
2114: -- Initialize API return status to success
2115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2144: FND_MSG_PUB.add;

2140: ) THEN
2141: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2142: FND_MESSAGE.set_token('API_NAME',l_api_name);
2143: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');
2144: FND_MSG_PUB.add;
2145: RAISE FND_API.g_exc_error;
2146: END IF;
2147:
2148: csi_mass_edit_pvt.get_mass_edit_details (

Line 2173: FND_MSG_PUB.Count_And_Get

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

Line 2188: FND_MSG_PUB.Count_And_Get (

2184: WHEN FND_API.G_EXC_ERROR THEN
2185:
2186: ROLLBACK TO Get_mass_edit_details;
2187: x_return_status := FND_API.G_RET_STS_ERROR ;
2188: FND_MSG_PUB.Count_And_Get (
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191:
2192: csi_t_gen_utility_pvt.set_debug_off;

Line 2199: FND_MSG_PUB.Count_And_Get(

2195:
2196: ROLLBACK TO Get_mass_edit_details;
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2198:
2199: FND_MSG_PUB.Count_And_Get(
2200: p_count => x_msg_count,
2201: p_data => x_msg_data);
2202:
2203: csi_t_gen_utility_pvt.set_debug_off;

Line 2210: IF FND_MSG_PUB.Check_Msg_Level(

2206:
2207: ROLLBACK TO Get_mass_edit_details;
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2209:
2210: IF FND_MSG_PUB.Check_Msg_Level(
2211: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2212:
2213: FND_MSG_PUB.Add_Exc_Msg(
2214: p_pkg_name => G_PKG_NAME,

Line 2211: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2207: ROLLBACK TO Get_mass_edit_details;
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2209:
2210: IF FND_MSG_PUB.Check_Msg_Level(
2211: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2212:
2213: FND_MSG_PUB.Add_Exc_Msg(
2214: p_pkg_name => G_PKG_NAME,
2215: p_procedure_name => l_api_name);

Line 2213: FND_MSG_PUB.Add_Exc_Msg(

2209:
2210: IF FND_MSG_PUB.Check_Msg_Level(
2211: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2212:
2213: FND_MSG_PUB.Add_Exc_Msg(
2214: p_pkg_name => G_PKG_NAME,
2215: p_procedure_name => l_api_name);
2216:
2217: END IF;

Line 2219: FND_MSG_PUB.Count_And_Get(

2215: p_procedure_name => l_api_name);
2216:
2217: END IF;
2218:
2219: FND_MSG_PUB.Count_And_Get(
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222:
2223: csi_t_gen_utility_pvt.set_debug_off;

Line 2428: fnd_msg_pub.add;

2424: WHEN NO_DATA_FOUND THEN
2425: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2426: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2427: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2428: fnd_msg_pub.add;
2429: RAISE FND_API.G_EXC_ERROR;
2430:
2431: WHEN TOO_MANY_ROWS THEN
2432: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');

Line 2435: fnd_msg_pub.add;

2431: WHEN TOO_MANY_ROWS THEN
2432: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2433: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2434: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2435: fnd_msg_pub.add;
2436: RAISE FND_API.G_EXC_ERROR;
2437: WHEN OTHERS THEN
2438: debug('In to Others Exception while finding customer id');
2439: RAISE FND_API.G_EXC_ERROR;

Line 2590: FND_MSG_PUB.Count_And_Get

2586: EXCEPTION
2587: WHEN FND_API.G_EXC_ERROR THEN
2588: ROLLBACK TO PROCESS_SYSTEM_MASS_UPDATE;
2589: x_return_status := FND_API.G_RET_STS_ERROR ;
2590: FND_MSG_PUB.Count_And_Get
2591: ( p_count => x_msg_count,
2592: p_data => x_msg_data
2593: );
2594:

Line 2598: FND_MSG_PUB.Count_And_Get

2594:
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596: ROLLBACK TO PROCESS_SYSTEM_MASS_UPDATE;
2597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2598: FND_MSG_PUB.Count_And_Get
2599: ( p_count => x_msg_count,
2600: p_data => x_msg_data
2601: );
2602:

Line 2606: IF FND_MSG_PUB.Check_Msg_Level

2602:
2603: WHEN OTHERS THEN
2604: ROLLBACK TO PROCESS_SYSTEM_MASS_UPDATE;
2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2606: IF FND_MSG_PUB.Check_Msg_Level
2607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2608: THEN
2609: FND_MSG_PUB.Add_Exc_Msg
2610: ( G_PKG_NAME ,

Line 2607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2603: WHEN OTHERS THEN
2604: ROLLBACK TO PROCESS_SYSTEM_MASS_UPDATE;
2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2606: IF FND_MSG_PUB.Check_Msg_Level
2607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2608: THEN
2609: FND_MSG_PUB.Add_Exc_Msg
2610: ( G_PKG_NAME ,
2611: l_api_name

Line 2609: FND_MSG_PUB.Add_Exc_Msg

2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2606: IF FND_MSG_PUB.Check_Msg_Level
2607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2608: THEN
2609: FND_MSG_PUB.Add_Exc_Msg
2610: ( G_PKG_NAME ,
2611: l_api_name
2612: );
2613: END IF;

Line 2614: FND_MSG_PUB.Count_And_Get

2610: ( G_PKG_NAME ,
2611: l_api_name
2612: );
2613: END IF;
2614: FND_MSG_PUB.Count_And_Get
2615: ( p_count => x_msg_count,
2616: p_data => x_msg_data
2617: );
2618: END PROCESS_SYSTEM_MASS_UPDATE; -- PROCESS_SYSTEM_MASS_UPDATE

Line 2770: fnd_msg_pub.add;

2766: WHEN NO_DATA_FOUND THEN
2767: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2768: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2769: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2770: fnd_msg_pub.add;
2771: RAISE FND_API.G_EXC_ERROR;
2772:
2773: WHEN TOO_MANY_ROWS THEN
2774: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');

Line 2777: fnd_msg_pub.add;

2773: WHEN TOO_MANY_ROWS THEN
2774: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2775: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2776: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2777: fnd_msg_pub.add;
2778: RAISE FND_API.G_EXC_ERROR;
2779: WHEN OTHERS THEN
2780: debug('In to Others Exception while finding customer id');
2781: RAISE FND_API.G_EXC_ERROR;