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 1628: FND_MSG_PUB.Add;

1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1627: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1628: FND_MSG_PUB.Add;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: END IF;
1631: END IF;
1632:

Line 1644: FND_MSG_PUB.count_and_get (

1640: WHEN FND_API.g_exc_error THEN
1641: ROLLBACK TO CTeam_PartySite_Update_pub;
1642: x_return_status := FND_API.g_ret_sts_error;
1643:
1644: FND_MSG_PUB.count_and_get (
1645: p_encoded => FND_API.g_false
1646: ,p_count => x_msg_count
1647: ,p_data => x_msg_data
1648: );

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

1647: ,p_data => x_msg_data
1648: );
1649:
1650: -- Debug Message
1651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1652: hz_utility_v2pub.debug_return_messages (
1653: x_msg_count, x_msg_data, 'ERROR');
1654: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');
1655: END IF;

Line 1661: FND_MSG_PUB.count_and_get (

1657: WHEN FND_API.g_exc_unexpected_error THEN
1658: ROLLBACK TO CTeam_PartySite_Update_pub;
1659: x_return_status := FND_API.g_ret_sts_unexp_error ;
1660:
1661: FND_MSG_PUB.count_and_get (
1662: p_encoded => FND_API.g_false
1663: ,p_count => x_msg_count
1664: ,p_data => x_msg_data
1665: );

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

1663: ,p_count => x_msg_count
1664: ,p_data => x_msg_data
1665: );
1666: -- Debug Message
1667: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1668: hz_utility_v2pub.debug_return_messages (
1669: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1670: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');
1671: END IF;

Line 1677: FND_MSG_PUB.count_and_get(

1673: WHEN OTHERS THEN
1674: ROLLBACK TO Update_Channel_Team_pub;
1675: x_return_status := FND_API.g_ret_sts_unexp_error ;
1676:
1677: FND_MSG_PUB.count_and_get(
1678: p_encoded => FND_API.g_false
1679: ,p_count => x_msg_count
1680: ,p_data => x_msg_data
1681: );

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

1680: ,p_data => x_msg_data
1681: );
1682:
1683: -- Debug Message
1684: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1685: hz_utility_v2pub.debug_return_messages (
1686: x_msg_count, x_msg_data, 'SQL ERROR');
1687: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');
1688: END IF;

Line 1836: FND_MSG_PUB.Add;

1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1835: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1836: FND_MSG_PUB.Add;
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1838: END IF;
1839: END IF;
1840:

Line 1852: FND_MSG_PUB.count_and_get (

1848: WHEN FND_API.g_exc_error THEN
1849: ROLLBACK TO Update_Channel_Team_pub;
1850: x_return_status := FND_API.g_ret_sts_error;
1851:
1852: FND_MSG_PUB.count_and_get (
1853: p_encoded => FND_API.g_false
1854: ,p_count => x_msg_count
1855: ,p_data => x_msg_data
1856: );

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

1855: ,p_data => x_msg_data
1856: );
1857:
1858: -- Debug Message
1859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1860: hz_utility_v2pub.debug_return_messages (
1861: x_msg_count, x_msg_data, 'ERROR');
1862: hz_utility_v2pub.debug('CTeam_Location_Update (-)');
1863: END IF;

Line 1869: FND_MSG_PUB.count_and_get (

1865: WHEN FND_API.g_exc_unexpected_error THEN
1866: ROLLBACK TO Update_Channel_Team_pub;
1867: x_return_status := FND_API.g_ret_sts_unexp_error ;
1868:
1869: FND_MSG_PUB.count_and_get (
1870: p_encoded => FND_API.g_false
1871: ,p_count => x_msg_count
1872: ,p_data => x_msg_data
1873: );

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

1871: ,p_count => x_msg_count
1872: ,p_data => x_msg_data
1873: );
1874: -- Debug Message
1875: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1876: hz_utility_v2pub.debug_return_messages (
1877: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1878: hz_utility_v2pub.debug('CTeam_Location_Update (-)');
1879: END IF;

Line 1885: FND_MSG_PUB.count_and_get(

1881: WHEN OTHERS THEN
1882: ROLLBACK TO Update_Channel_Team_pub;
1883: x_return_status := FND_API.g_ret_sts_unexp_error ;
1884:
1885: FND_MSG_PUB.count_and_get(
1886: p_encoded => FND_API.g_false
1887: ,p_count => x_msg_count
1888: ,p_data => x_msg_data
1889: );

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

1888: ,p_data => x_msg_data
1889: );
1890:
1891: -- Debug Message
1892: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1893: hz_utility_v2pub.debug_return_messages (
1894: x_msg_count, x_msg_data, 'SQL ERROR');
1895: hz_utility_v2pub.debug('CTeam_Location_Update (-)');
1896: END IF;

Line 2067: FND_MSG_PUB.Add;

2063: RAISE FND_API.G_EXC_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2066: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2067: FND_MSG_PUB.Add;
2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2069: END IF;
2070: END IF;
2071:

Line 2085: FND_MSG_PUB.count_and_get (

2081: WHEN FND_API.g_exc_error THEN
2082: ROLLBACK TO Update_Channel_Team_pub;
2083: x_return_status := FND_API.g_ret_sts_error;
2084:
2085: FND_MSG_PUB.count_and_get (
2086: p_encoded => FND_API.g_false
2087: ,p_count => x_msg_count
2088: ,p_data => x_msg_data
2089: );

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

2088: ,p_data => x_msg_data
2089: );
2090:
2091: -- Debug Message
2092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2093: hz_utility_v2pub.debug_return_messages (
2094: x_msg_count, x_msg_data, 'ERROR');
2095: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');
2096: END IF;

Line 2102: FND_MSG_PUB.count_and_get (

2098: WHEN FND_API.g_exc_unexpected_error THEN
2099: ROLLBACK TO Update_Channel_Team_pub;
2100: x_return_status := FND_API.g_ret_sts_unexp_error ;
2101:
2102: FND_MSG_PUB.count_and_get (
2103: p_encoded => FND_API.g_false
2104: ,p_count => x_msg_count
2105: ,p_data => x_msg_data
2106: );

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

2104: ,p_count => x_msg_count
2105: ,p_data => x_msg_data
2106: );
2107: -- Debug Message
2108: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2109: hz_utility_v2pub.debug_return_messages (
2110: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2111: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');
2112: END IF;

Line 2118: FND_MSG_PUB.count_and_get(

2114: WHEN OTHERS THEN
2115: ROLLBACK TO Update_Channel_Team_pub;
2116: x_return_status := FND_API.g_ret_sts_unexp_error ;
2117:
2118: FND_MSG_PUB.count_and_get(
2119: p_encoded => FND_API.g_false
2120: ,p_count => x_msg_count
2121: ,p_data => x_msg_data
2122: );

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

2121: ,p_data => x_msg_data
2122: );
2123:
2124: -- Debug Message
2125: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2126: hz_utility_v2pub.debug_return_messages (
2127: x_msg_count, x_msg_data, 'SQL ERROR');
2128: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');
2129: END IF;

Line 2198: -- FND_MSG_PUB.initialize;

2194: IF x_return_status <> 'S' THEN
2195: RAISE EXC;
2196: END IF;
2197: END IF;
2198: -- FND_MSG_PUB.initialize;
2199: RETURN 'SUCCESS';
2200:
2201: EXCEPTION
2202: WHEN EXC THEN

Line 2278: -- FND_MSG_PUB.initialize;

2274: IF x_return_status <> 'S' THEN
2275: RAISE EXC;
2276: END IF;
2277: END IF;
2278: -- FND_MSG_PUB.initialize;
2279: RETURN 'SUCCESS';
2280:
2281: EXCEPTION
2282: WHEN EXC THEN

Line 2356: -- FND_MSG_PUB.initialize;

2352:
2353: IF x_return_status <> 'S' THEN
2354: RAISE EXC;
2355: END IF;
2356: -- FND_MSG_PUB.initialize;
2357: RETURN 'SUCCESS';
2358:
2359: EXCEPTION
2360: WHEN EXC THEN

Line 2423: -- FND_MSG_PUB.initialize;

2419:
2420: IF x_return_status <> 'S' THEN
2421: RAISE EXC;
2422: END IF;
2423: -- FND_MSG_PUB.initialize;
2424: RETURN 'SUCCESS';
2425:
2426: EXCEPTION
2427: WHEN EXC THEN