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