DBA Data[Home] [Help]

APPS.PV_TAP_BES_PKG dependencies on FND_MSG_PUB

Line 1431: FND_MSG_PUB.Add;

1427: RAISE FND_API.G_EXC_ERROR;
1428: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1429: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1430: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1431: FND_MSG_PUB.Add;
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1434: END IF;
1435:

Line 1448: FND_MSG_PUB.count_and_get (

1444: WHEN FND_API.g_exc_error THEN
1445: ROLLBACK TO Update_Channel_Team_pub;
1446: x_return_status := FND_API.g_ret_sts_error;
1447:
1448: FND_MSG_PUB.count_and_get (
1449: p_encoded => FND_API.g_false
1450: ,p_count => x_msg_count
1451: ,p_data => x_msg_data
1452: );

Line 1455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1451: ,p_data => x_msg_data
1452: );
1453:
1454: -- Debug Message
1455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1456: hz_utility_v2pub.debug_return_messages (
1457: x_msg_count, x_msg_data, 'ERROR');
1458: hz_utility_v2pub.debug('Update_Channel_Team (-)');
1459: END IF;

Line 1465: FND_MSG_PUB.count_and_get (

1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: ROLLBACK TO Update_Channel_Team_pub;
1463: x_return_status := FND_API.g_ret_sts_unexp_error ;
1464:
1465: FND_MSG_PUB.count_and_get (
1466: p_encoded => FND_API.g_false
1467: ,p_count => x_msg_count
1468: ,p_data => x_msg_data
1469: );

Line 1471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1467: ,p_count => x_msg_count
1468: ,p_data => x_msg_data
1469: );
1470: -- Debug Message
1471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1472: hz_utility_v2pub.debug_return_messages (
1473: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1474: hz_utility_v2pub.debug('Update_Channel_Team (-)');
1475: END IF;

Line 1481: FND_MSG_PUB.count_and_get(

1477: WHEN OTHERS THEN
1478: ROLLBACK TO Update_Channel_Team_pub;
1479: x_return_status := FND_API.g_ret_sts_unexp_error ;
1480:
1481: FND_MSG_PUB.count_and_get(
1482: p_encoded => FND_API.g_false
1483: ,p_count => x_msg_count
1484: ,p_data => x_msg_data
1485: );

Line 1488: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1484: ,p_data => x_msg_data
1485: );
1486:
1487: -- Debug Message
1488: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1489: hz_utility_v2pub.debug_return_messages (
1490: x_msg_count, x_msg_data, 'SQL ERROR');
1491: hz_utility_v2pub.debug('Update_Channel_Team (-)');
1492: END IF;

Line 1799: FND_MSG_PUB.Add;

1795: RAISE FND_API.G_EXC_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1798: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1799: FND_MSG_PUB.Add;
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: END IF;
1802: END IF;
1803:

Line 1815: FND_MSG_PUB.count_and_get (

1811: WHEN FND_API.g_exc_error THEN
1812: ROLLBACK TO CTeam_PartySite_Update_pub;
1813: x_return_status := FND_API.g_ret_sts_error;
1814:
1815: FND_MSG_PUB.count_and_get (
1816: p_encoded => FND_API.g_false
1817: ,p_count => x_msg_count
1818: ,p_data => x_msg_data
1819: );

Line 1822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1818: ,p_data => x_msg_data
1819: );
1820:
1821: -- Debug Message
1822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1823: hz_utility_v2pub.debug_return_messages (
1824: x_msg_count, x_msg_data, 'ERROR');
1825: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');
1826: END IF;

Line 1832: FND_MSG_PUB.count_and_get (

1828: WHEN FND_API.g_exc_unexpected_error THEN
1829: ROLLBACK TO CTeam_PartySite_Update_pub;
1830: x_return_status := FND_API.g_ret_sts_unexp_error ;
1831:
1832: FND_MSG_PUB.count_and_get (
1833: p_encoded => FND_API.g_false
1834: ,p_count => x_msg_count
1835: ,p_data => x_msg_data
1836: );

Line 1838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1834: ,p_count => x_msg_count
1835: ,p_data => x_msg_data
1836: );
1837: -- Debug Message
1838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1839: hz_utility_v2pub.debug_return_messages (
1840: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1841: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');
1842: END IF;

Line 1848: FND_MSG_PUB.count_and_get(

1844: WHEN OTHERS THEN
1845: ROLLBACK TO Update_Channel_Team_pub;
1846: x_return_status := FND_API.g_ret_sts_unexp_error ;
1847:
1848: FND_MSG_PUB.count_and_get(
1849: p_encoded => FND_API.g_false
1850: ,p_count => x_msg_count
1851: ,p_data => x_msg_data
1852: );

Line 1855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1851: ,p_data => x_msg_data
1852: );
1853:
1854: -- Debug Message
1855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1856: hz_utility_v2pub.debug_return_messages (
1857: x_msg_count, x_msg_data, 'SQL ERROR');
1858: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');
1859: END IF;

Line 2007: FND_MSG_PUB.Add;

2003: RAISE FND_API.G_EXC_ERROR;
2004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2005: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2006: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2007: FND_MSG_PUB.Add;
2008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2009: END IF;
2010: END IF;
2011:

Line 2023: FND_MSG_PUB.count_and_get (

2019: WHEN FND_API.g_exc_error THEN
2020: ROLLBACK TO Update_Channel_Team_pub;
2021: x_return_status := FND_API.g_ret_sts_error;
2022:
2023: FND_MSG_PUB.count_and_get (
2024: p_encoded => FND_API.g_false
2025: ,p_count => x_msg_count
2026: ,p_data => x_msg_data
2027: );

Line 2030: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2026: ,p_data => x_msg_data
2027: );
2028:
2029: -- Debug Message
2030: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2031: hz_utility_v2pub.debug_return_messages (
2032: x_msg_count, x_msg_data, 'ERROR');
2033: hz_utility_v2pub.debug('CTeam_Location_Update (-)');
2034: END IF;

Line 2040: FND_MSG_PUB.count_and_get (

2036: WHEN FND_API.g_exc_unexpected_error THEN
2037: ROLLBACK TO Update_Channel_Team_pub;
2038: x_return_status := FND_API.g_ret_sts_unexp_error ;
2039:
2040: FND_MSG_PUB.count_and_get (
2041: p_encoded => FND_API.g_false
2042: ,p_count => x_msg_count
2043: ,p_data => x_msg_data
2044: );

Line 2046: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2042: ,p_count => x_msg_count
2043: ,p_data => x_msg_data
2044: );
2045: -- Debug Message
2046: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2047: hz_utility_v2pub.debug_return_messages (
2048: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2049: hz_utility_v2pub.debug('CTeam_Location_Update (-)');
2050: END IF;

Line 2056: FND_MSG_PUB.count_and_get(

2052: WHEN OTHERS THEN
2053: ROLLBACK TO Update_Channel_Team_pub;
2054: x_return_status := FND_API.g_ret_sts_unexp_error ;
2055:
2056: FND_MSG_PUB.count_and_get(
2057: p_encoded => FND_API.g_false
2058: ,p_count => x_msg_count
2059: ,p_data => x_msg_data
2060: );

Line 2063: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2059: ,p_data => x_msg_data
2060: );
2061:
2062: -- Debug Message
2063: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2064: hz_utility_v2pub.debug_return_messages (
2065: x_msg_count, x_msg_data, 'SQL ERROR');
2066: hz_utility_v2pub.debug('CTeam_Location_Update (-)');
2067: END IF;

Line 2238: FND_MSG_PUB.Add;

2234: RAISE FND_API.G_EXC_ERROR;
2235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2237: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2238: FND_MSG_PUB.Add;
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241: END IF;
2242:

Line 2256: FND_MSG_PUB.count_and_get (

2252: WHEN FND_API.g_exc_error THEN
2253: ROLLBACK TO Update_Channel_Team_pub;
2254: x_return_status := FND_API.g_ret_sts_error;
2255:
2256: FND_MSG_PUB.count_and_get (
2257: p_encoded => FND_API.g_false
2258: ,p_count => x_msg_count
2259: ,p_data => x_msg_data
2260: );

Line 2263: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2259: ,p_data => x_msg_data
2260: );
2261:
2262: -- Debug Message
2263: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2264: hz_utility_v2pub.debug_return_messages (
2265: x_msg_count, x_msg_data, 'ERROR');
2266: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');
2267: END IF;

Line 2273: FND_MSG_PUB.count_and_get (

2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: ROLLBACK TO Update_Channel_Team_pub;
2271: x_return_status := FND_API.g_ret_sts_unexp_error ;
2272:
2273: FND_MSG_PUB.count_and_get (
2274: p_encoded => FND_API.g_false
2275: ,p_count => x_msg_count
2276: ,p_data => x_msg_data
2277: );

Line 2279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2275: ,p_count => x_msg_count
2276: ,p_data => x_msg_data
2277: );
2278: -- Debug Message
2279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2280: hz_utility_v2pub.debug_return_messages (
2281: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2282: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');
2283: END IF;

Line 2289: FND_MSG_PUB.count_and_get(

2285: WHEN OTHERS THEN
2286: ROLLBACK TO Update_Channel_Team_pub;
2287: x_return_status := FND_API.g_ret_sts_unexp_error ;
2288:
2289: FND_MSG_PUB.count_and_get(
2290: p_encoded => FND_API.g_false
2291: ,p_count => x_msg_count
2292: ,p_data => x_msg_data
2293: );

Line 2296: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2292: ,p_data => x_msg_data
2293: );
2294:
2295: -- Debug Message
2296: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2297: hz_utility_v2pub.debug_return_messages (
2298: x_msg_count, x_msg_data, 'SQL ERROR');
2299: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');
2300: END IF;

Line 2375: -- FND_MSG_PUB.initialize;

2371: IF x_return_status <> 'S' THEN
2372: RAISE EXC;
2373: END IF;
2374: END IF;
2375: -- FND_MSG_PUB.initialize;
2376: RETURN 'SUCCESS';
2377:
2378: EXCEPTION
2379: WHEN EXC THEN

Line 2455: -- FND_MSG_PUB.initialize;

2451: IF x_return_status <> 'S' THEN
2452: RAISE EXC;
2453: END IF;
2454: END IF;
2455: -- FND_MSG_PUB.initialize;
2456: RETURN 'SUCCESS';
2457:
2458: EXCEPTION
2459: WHEN EXC THEN

Line 2533: -- FND_MSG_PUB.initialize;

2529:
2530: IF x_return_status <> 'S' THEN
2531: RAISE EXC;
2532: END IF;
2533: -- FND_MSG_PUB.initialize;
2534: RETURN 'SUCCESS';
2535:
2536: EXCEPTION
2537: WHEN EXC THEN

Line 2600: -- FND_MSG_PUB.initialize;

2596:
2597: IF x_return_status <> 'S' THEN
2598: RAISE EXC;
2599: END IF;
2600: -- FND_MSG_PUB.initialize;
2601: RETURN 'SUCCESS';
2602:
2603: EXCEPTION
2604: WHEN EXC THEN