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 1652: hz_utility_v2pub.debug_return_messages (

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

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

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;
1656:
1657: WHEN FND_API.g_exc_unexpected_error THEN
1658: ROLLBACK TO CTeam_PartySite_Update_pub;

Line 1668: hz_utility_v2pub.debug_return_messages (

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

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

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;
1672:
1673: WHEN OTHERS THEN
1674: ROLLBACK TO Update_Channel_Team_pub;

Line 1685: hz_utility_v2pub.debug_return_messages (

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

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

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;
1689: END CTeam_PartySite_Update;
1690:
1691: -- Start of Comments

Line 1860: hz_utility_v2pub.debug_return_messages (

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

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

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;
1864:
1865: WHEN FND_API.g_exc_unexpected_error THEN
1866: ROLLBACK TO Update_Channel_Team_pub;

Line 1876: hz_utility_v2pub.debug_return_messages (

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

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

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;
1880:
1881: WHEN OTHERS THEN
1882: ROLLBACK TO Update_Channel_Team_pub;

Line 1893: hz_utility_v2pub.debug_return_messages (

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

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

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;
1897: END CTeam_Location_Update;
1898:
1899: --

Line 2093: hz_utility_v2pub.debug_return_messages (

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

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

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;
2097:
2098: WHEN FND_API.g_exc_unexpected_error THEN
2099: ROLLBACK TO Update_Channel_Team_pub;

Line 2109: hz_utility_v2pub.debug_return_messages (

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

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

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;
2113:
2114: WHEN OTHERS THEN
2115: ROLLBACK TO Update_Channel_Team_pub;

Line 2126: hz_utility_v2pub.debug_return_messages (

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

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

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;
2130: END CTeam_ContPoint_Update;
2131:
2132: -- Start of Comments