DBA Data[Home] [Help]

APPS.PV_TAP_BES_PKG dependencies on HZ_UTILITY_V2PUB

Line 1456: hz_utility_v2pub.debug_return_messages (

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;
1460:

Line 1458: hz_utility_v2pub.debug('Update_Channel_Team (-)');

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;
1460:
1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: ROLLBACK TO Update_Channel_Team_pub;

Line 1472: hz_utility_v2pub.debug_return_messages (

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;
1476:

Line 1474: hz_utility_v2pub.debug('Update_Channel_Team (-)');

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;
1476:
1477: WHEN OTHERS THEN
1478: ROLLBACK TO Update_Channel_Team_pub;

Line 1489: hz_utility_v2pub.debug_return_messages (

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;
1493: END CTeam_Org_Update;

Line 1491: hz_utility_v2pub.debug('Update_Channel_Team (-)');

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;
1493: END CTeam_Org_Update;
1494:
1495: -- Start of Comments

Line 1823: hz_utility_v2pub.debug_return_messages (

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;
1827:

Line 1825: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');

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;
1827:
1828: WHEN FND_API.g_exc_unexpected_error THEN
1829: ROLLBACK TO CTeam_PartySite_Update_pub;

Line 1839: hz_utility_v2pub.debug_return_messages (

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;
1843:

Line 1841: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');

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;
1843:
1844: WHEN OTHERS THEN
1845: ROLLBACK TO Update_Channel_Team_pub;

Line 1856: hz_utility_v2pub.debug_return_messages (

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;
1860: END CTeam_PartySite_Update;

Line 1858: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');

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;
1860: END CTeam_PartySite_Update;
1861:
1862: -- Start of Comments

Line 2031: hz_utility_v2pub.debug_return_messages (

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;
2035:

Line 2033: hz_utility_v2pub.debug('CTeam_Location_Update (-)');

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;
2035:
2036: WHEN FND_API.g_exc_unexpected_error THEN
2037: ROLLBACK TO Update_Channel_Team_pub;

Line 2047: hz_utility_v2pub.debug_return_messages (

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;
2051:

Line 2049: hz_utility_v2pub.debug('CTeam_Location_Update (-)');

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;
2051:
2052: WHEN OTHERS THEN
2053: ROLLBACK TO Update_Channel_Team_pub;

Line 2064: hz_utility_v2pub.debug_return_messages (

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;
2068: END CTeam_Location_Update;

Line 2066: hz_utility_v2pub.debug('CTeam_Location_Update (-)');

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;
2068: END CTeam_Location_Update;
2069:
2070: --

Line 2264: hz_utility_v2pub.debug_return_messages (

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;
2268:

Line 2266: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');

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;
2268:
2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: ROLLBACK TO Update_Channel_Team_pub;

Line 2280: hz_utility_v2pub.debug_return_messages (

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;
2284:

Line 2282: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');

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;
2284:
2285: WHEN OTHERS THEN
2286: ROLLBACK TO Update_Channel_Team_pub;

Line 2297: hz_utility_v2pub.debug_return_messages (

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;
2301: END CTeam_ContPoint_Update;

Line 2299: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');

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;
2301: END CTeam_ContPoint_Update;
2302:
2303: -- Start of Comments