eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_TERR_ASSIGN_PUB dependencies on HZ_UTILITY_V2PUB

Line 1007: hz_utility_v2pub.debug_return_messages (

1003: );
1004:
1005: -- Debug Message
1006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1007: hz_utility_v2pub.debug_return_messages (
1008: x_msg_count, x_msg_data, 'ERROR');
1009: hz_utility_v2pub.debug('Create_Channel_Team (-)');
1010: END IF;
1011:

Line 1009: hz_utility_v2pub.debug('Create_Channel_Team (-)');

1005: -- Debug Message
1006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1007: hz_utility_v2pub.debug_return_messages (
1008: x_msg_count, x_msg_data, 'ERROR');
1009: hz_utility_v2pub.debug('Create_Channel_Team (-)');
1010: END IF;
1011:
1012: WHEN FND_API.g_exc_unexpected_error THEN
1013: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1021: hz_utility_v2pub.debug_return_messages (

1017: ,p_data => x_msg_data
1018: );
1019: -- Debug Message
1020: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1021: hz_utility_v2pub.debug_return_messages (
1022: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1023: hz_utility_v2pub.debug('Create_Channel_Team (-)');
1024: END IF;
1025:

Line 1023: hz_utility_v2pub.debug('Create_Channel_Team (-)');

1019: -- Debug Message
1020: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1021: hz_utility_v2pub.debug_return_messages (
1022: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1023: hz_utility_v2pub.debug('Create_Channel_Team (-)');
1024: END IF;
1025:
1026: WHEN OTHERS THEN
1027: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1037: hz_utility_v2pub.debug_return_messages (

1033: );
1034:
1035: -- Debug Message
1036: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1037: hz_utility_v2pub.debug_return_messages (
1038: x_msg_count, x_msg_data, 'SQL ERROR');
1039: hz_utility_v2pub.debug('Create_Channel_Team (-)');
1040: END IF;
1041: END Chk_To_Create_Access_Rec;

Line 1039: hz_utility_v2pub.debug('Create_Channel_Team (-)');

1035: -- Debug Message
1036: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1037: hz_utility_v2pub.debug_return_messages (
1038: x_msg_count, x_msg_data, 'SQL ERROR');
1039: hz_utility_v2pub.debug('Create_Channel_Team (-)');
1040: END IF;
1041: END Chk_To_Create_Access_Rec;
1042:
1043: -- Start of Comments

Line 1181: hz_utility_v2pub.debug_return_messages (

1177: );
1178:
1179: -- Debug Message
1180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1181: hz_utility_v2pub.debug_return_messages (
1182: x_msg_count, x_msg_data, 'ERROR');
1183: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');
1184: END IF;
1185:

Line 1183: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');

1179: -- Debug Message
1180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1181: hz_utility_v2pub.debug_return_messages (
1182: x_msg_count, x_msg_data, 'ERROR');
1183: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');
1184: END IF;
1185:
1186: WHEN FND_API.g_exc_unexpected_error THEN
1187: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1195: hz_utility_v2pub.debug_return_messages (

1191: ,p_data => x_msg_data
1192: );
1193: -- Debug Message
1194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1195: hz_utility_v2pub.debug_return_messages (
1196: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1197: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');
1198: END IF;
1199:

Line 1197: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');

1193: -- Debug Message
1194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1195: hz_utility_v2pub.debug_return_messages (
1196: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1197: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');
1198: END IF;
1199:
1200: WHEN OTHERS THEN
1201: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1211: hz_utility_v2pub.debug_return_messages (

1207: );
1208:
1209: -- Debug Message
1210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1211: hz_utility_v2pub.debug_return_messages (
1212: x_msg_count, x_msg_data, 'SQL ERROR');
1213: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');
1214: END IF;
1215: END Cr_Login_User_Access_Rec;

Line 1213: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');

1209: -- Debug Message
1210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1211: hz_utility_v2pub.debug_return_messages (
1212: x_msg_count, x_msg_data, 'SQL ERROR');
1213: hz_utility_v2pub.debug('Cr_Login_User_Access_Rec(-)');
1214: END IF;
1215: END Cr_Login_User_Access_Rec;
1216:
1217: -- Start of Comments

Line 1444: hz_utility_v2pub.debug_return_messages (

1440: );
1441:
1442: -- Debug Message
1443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1444: hz_utility_v2pub.debug_return_messages (
1445: x_msg_count, x_msg_data, 'ERROR');
1446: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');
1447: END IF;
1448:

Line 1446: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');

1442: -- Debug Message
1443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1444: hz_utility_v2pub.debug_return_messages (
1445: x_msg_count, x_msg_data, 'ERROR');
1446: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');
1447: END IF;
1448:
1449: WHEN FND_API.g_exc_unexpected_error THEN
1450: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1458: hz_utility_v2pub.debug_return_messages (

1454: ,p_data => x_msg_data
1455: );
1456: -- Debug Message
1457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1458: hz_utility_v2pub.debug_return_messages (
1459: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1460: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');
1461: END IF;
1462:

Line 1460: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');

1456: -- Debug Message
1457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1458: hz_utility_v2pub.debug_return_messages (
1459: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1460: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');
1461: END IF;
1462:
1463: WHEN OTHERS THEN
1464: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1474: hz_utility_v2pub.debug_return_messages (

1470: );
1471:
1472: -- Debug Message
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1474: hz_utility_v2pub.debug_return_messages (
1475: x_msg_count, x_msg_data, 'SQL ERROR');
1476: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');
1477: END IF;
1478:

Line 1476: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');

1472: -- Debug Message
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1474: hz_utility_v2pub.debug_return_messages (
1475: x_msg_count, x_msg_data, 'SQL ERROR');
1476: hz_utility_v2pub.debug('TAP_Get_Channel_Team(-)');
1477: END IF;
1478:
1479: END TAP_Get_Channel_Team;
1480:

Line 1744: hz_utility_v2pub.debug_return_messages (

1740: );
1741:
1742: -- Debug Message
1743: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1744: hz_utility_v2pub.debug_return_messages (
1745: x_msg_count, x_msg_data, 'ERROR');
1746: hz_utility_v2pub.debug('Process_TAP_Resources (-)');
1747: END IF;
1748:

Line 1746: hz_utility_v2pub.debug('Process_TAP_Resources (-)');

1742: -- Debug Message
1743: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1744: hz_utility_v2pub.debug_return_messages (
1745: x_msg_count, x_msg_data, 'ERROR');
1746: hz_utility_v2pub.debug('Process_TAP_Resources (-)');
1747: END IF;
1748:
1749: WHEN FND_API.g_exc_unexpected_error THEN
1750: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1759: hz_utility_v2pub.debug_return_messages (

1755: );
1756:
1757: -- Debug Message
1758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1759: hz_utility_v2pub.debug_return_messages (
1760: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1761: hz_utility_v2pub.debug('Process_TAP_Resources (-)');
1762: END IF;
1763:

Line 1761: hz_utility_v2pub.debug('Process_TAP_Resources (-)');

1757: -- Debug Message
1758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1759: hz_utility_v2pub.debug_return_messages (
1760: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1761: hz_utility_v2pub.debug('Process_TAP_Resources (-)');
1762: END IF;
1763:
1764: WHEN OTHERS THEN
1765: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1779: hz_utility_v2pub.debug_return_messages (

1775: );
1776:
1777: -- Debug Message
1778: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1779: hz_utility_v2pub.debug_return_messages (
1780: x_msg_count, x_msg_data, 'SQL ERROR');
1781: hz_utility_v2pub.debug('Process_TAP_Resources (-)');
1782: END IF;
1783: END Process_TAP_Resources;

Line 1781: hz_utility_v2pub.debug('Process_TAP_Resources (-)');

1777: -- Debug Message
1778: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1779: hz_utility_v2pub.debug_return_messages (
1780: x_msg_count, x_msg_data, 'SQL ERROR');
1781: hz_utility_v2pub.debug('Process_TAP_Resources (-)');
1782: END IF;
1783: END Process_TAP_Resources;
1784:
1785: -- Start of Comments

Line 1966: hz_utility_v2pub.debug_return_messages (

1962: );
1963:
1964: -- Debug Message
1965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1966: hz_utility_v2pub.debug_return_messages (
1967: x_msg_count, x_msg_data, 'ERROR');
1968: hz_utility_v2pub.debug('get_partner_details (-)');
1969: END IF;
1970:

Line 1968: hz_utility_v2pub.debug('get_partner_details (-)');

1964: -- Debug Message
1965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1966: hz_utility_v2pub.debug_return_messages (
1967: x_msg_count, x_msg_data, 'ERROR');
1968: hz_utility_v2pub.debug('get_partner_details (-)');
1969: END IF;
1970:
1971: WHEN FND_API.g_exc_unexpected_error THEN
1972: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1983: hz_utility_v2pub.debug_return_messages (

1979: ,p_data => x_msg_data
1980: );
1981: -- Debug Message
1982: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1983: hz_utility_v2pub.debug_return_messages (
1984: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1985: hz_utility_v2pub.debug('get_partner_details (-)');
1986: END IF;
1987:

Line 1985: hz_utility_v2pub.debug('get_partner_details (-)');

1981: -- Debug Message
1982: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1983: hz_utility_v2pub.debug_return_messages (
1984: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
1985: hz_utility_v2pub.debug('get_partner_details (-)');
1986: END IF;
1987:
1988: WHEN OTHERS THEN
1989: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 2003: hz_utility_v2pub.debug_return_messages (

1999: );
2000:
2001: -- Debug Message
2002: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2003: hz_utility_v2pub.debug_return_messages (
2004: x_msg_count, x_msg_data, 'SQL ERROR');
2005: hz_utility_v2pub.debug('get_partner_details (-)');
2006: END IF;
2007:

Line 2005: hz_utility_v2pub.debug('get_partner_details (-)');

2001: -- Debug Message
2002: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2003: hz_utility_v2pub.debug_return_messages (
2004: x_msg_count, x_msg_data, 'SQL ERROR');
2005: hz_utility_v2pub.debug('get_partner_details (-)');
2006: END IF;
2007:
2008: END get_partner_details;
2009:

Line 2163: hz_utility_v2pub.debug_return_messages (

2159: );
2160:
2161: -- Debug Message
2162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2163: hz_utility_v2pub.debug_return_messages (
2164: x_msg_count, x_msg_data, 'ERROR');
2165: hz_utility_v2pub.debug('Delete_Channel_Team (-)');
2166: END IF;
2167:

Line 2165: hz_utility_v2pub.debug('Delete_Channel_Team (-)');

2161: -- Debug Message
2162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2163: hz_utility_v2pub.debug_return_messages (
2164: x_msg_count, x_msg_data, 'ERROR');
2165: hz_utility_v2pub.debug('Delete_Channel_Team (-)');
2166: END IF;
2167:
2168: WHEN FND_API.g_exc_unexpected_error THEN
2169: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 2177: hz_utility_v2pub.debug_return_messages (

2173: ,p_data => x_msg_data
2174: );
2175: -- Debug Message
2176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2177: hz_utility_v2pub.debug_return_messages (
2178: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2179: hz_utility_v2pub.debug('Delete_Channel_Team (-)');
2180: END IF;
2181:

Line 2179: hz_utility_v2pub.debug('Delete_Channel_Team (-)');

2175: -- Debug Message
2176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2177: hz_utility_v2pub.debug_return_messages (
2178: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2179: hz_utility_v2pub.debug('Delete_Channel_Team (-)');
2180: END IF;
2181:
2182: WHEN OTHERS THEN
2183: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 2198: hz_utility_v2pub.debug_return_messages (

2194: );
2195:
2196: -- Debug Message
2197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2198: hz_utility_v2pub.debug_return_messages (
2199: x_msg_count, x_msg_data, 'SQL ERROR');
2200: hz_utility_v2pub.debug('Delete_Channel_Team (-)');
2201: END IF;
2202:

Line 2200: hz_utility_v2pub.debug('Delete_Channel_Team (-)');

2196: -- Debug Message
2197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2198: hz_utility_v2pub.debug_return_messages (
2199: x_msg_count, x_msg_data, 'SQL ERROR');
2200: hz_utility_v2pub.debug('Delete_Channel_Team (-)');
2201: END IF;
2202:
2203: END Delete_Channel_Team;
2204:

Line 2517: hz_utility_v2pub.debug_return_messages (

2513: );
2514:
2515: -- Debug Message
2516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2517: hz_utility_v2pub.debug_return_messages (
2518: x_msg_count, x_msg_data, 'ERROR');
2519: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');
2520: END IF;
2521:

Line 2519: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');

2515: -- Debug Message
2516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2517: hz_utility_v2pub.debug_return_messages (
2518: x_msg_count, x_msg_data, 'ERROR');
2519: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');
2520: END IF;
2521:
2522: WHEN FND_API.g_exc_unexpected_error THEN
2523:

Line 2532: hz_utility_v2pub.debug_return_messages (

2528: ,p_data => x_msg_data
2529: );
2530: -- Debug Message
2531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2532: hz_utility_v2pub.debug_return_messages (
2533: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2534: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');
2535: END IF;
2536:

Line 2534: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');

2530: -- Debug Message
2531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2532: hz_utility_v2pub.debug_return_messages (
2533: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2534: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');
2535: END IF;
2536:
2537: WHEN OTHERS THEN
2538:

Line 2554: hz_utility_v2pub.debug_return_messages (

2550: );
2551:
2552: -- Debug Message
2553: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2554: hz_utility_v2pub.debug_return_messages (
2555: x_msg_count, x_msg_data, 'SQL ERROR');
2556: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');
2557: END IF;
2558:

Line 2556: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');

2552: -- Debug Message
2553: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2554: hz_utility_v2pub.debug_return_messages (
2555: x_msg_count, x_msg_data, 'SQL ERROR');
2556: hz_utility_v2pub.debug('Create_Terr_Channel_Team (-)');
2557: END IF;
2558:
2559:
2560: end Create_Terr_Channel_Team;

Line 2869: hz_utility_v2pub.debug_return_messages (

2865: );
2866:
2867: -- Debug Message
2868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2869: hz_utility_v2pub.debug_return_messages (
2870: x_msg_count, x_msg_data, 'ERROR');
2871: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');
2872: END IF;
2873:

Line 2871: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');

2867: -- Debug Message
2868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2869: hz_utility_v2pub.debug_return_messages (
2870: x_msg_count, x_msg_data, 'ERROR');
2871: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');
2872: END IF;
2873:
2874: WHEN FND_API.g_exc_unexpected_error THEN
2875:

Line 2884: hz_utility_v2pub.debug_return_messages (

2880: ,p_data => x_msg_data
2881: );
2882: -- Debug Message
2883: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2884: hz_utility_v2pub.debug_return_messages (
2885: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2886: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');
2887: END IF;
2888:

Line 2886: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');

2882: -- Debug Message
2883: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2884: hz_utility_v2pub.debug_return_messages (
2885: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
2886: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');
2887: END IF;
2888:
2889: WHEN OTHERS THEN
2890:

Line 2906: hz_utility_v2pub.debug_return_messages (

2902: );
2903:
2904: -- Debug Message
2905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2906: hz_utility_v2pub.debug_return_messages (
2907: x_msg_count, x_msg_data, 'SQL ERROR');
2908: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');
2909: END IF;
2910:

Line 2908: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');

2904: -- Debug Message
2905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2906: hz_utility_v2pub.debug_return_messages (
2907: x_msg_count, x_msg_data, 'SQL ERROR');
2908: hz_utility_v2pub.debug('Create_User_Channel_Team (-)');
2909: END IF;
2910:
2911:
2912: end Create_User_Channel_Team;

Line 3243: hz_utility_v2pub.debug_return_messages (

3239: );
3240:
3241: -- Debug Message
3242: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3243: hz_utility_v2pub.debug_return_messages (
3244: x_msg_count, x_msg_data, 'ERROR');
3245: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3246: END IF;
3247:

Line 3245: hz_utility_v2pub.debug('Create_Channel_Team (-)');

3241: -- Debug Message
3242: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3243: hz_utility_v2pub.debug_return_messages (
3244: x_msg_count, x_msg_data, 'ERROR');
3245: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3246: END IF;
3247:
3248: WHEN FND_API.g_exc_unexpected_error THEN
3249: ROLLBACK TO create_channel_team_pub;

Line 3258: hz_utility_v2pub.debug_return_messages (

3254: ,p_data => x_msg_data
3255: );
3256: -- Debug Message
3257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3258: hz_utility_v2pub.debug_return_messages (
3259: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
3260: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3261: END IF;
3262:

Line 3260: hz_utility_v2pub.debug('Create_Channel_Team (-)');

3256: -- Debug Message
3257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3258: hz_utility_v2pub.debug_return_messages (
3259: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
3260: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3261: END IF;
3262:
3263: WHEN OTHERS THEN
3264: ROLLBACK TO create_channel_team_pub;

Line 3280: hz_utility_v2pub.debug_return_messages (

3276: );
3277:
3278: -- Debug Message
3279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3280: hz_utility_v2pub.debug_return_messages (
3281: x_msg_count, x_msg_data, 'SQL ERROR');
3282: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3283: END IF;
3284:

Line 3282: hz_utility_v2pub.debug('Create_Channel_Team (-)');

3278: -- Debug Message
3279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3280: hz_utility_v2pub.debug_return_messages (
3281: x_msg_count, x_msg_data, 'SQL ERROR');
3282: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3283: END IF;
3284:
3285: END Do_Create_Channel_Team;
3286:

Line 3449: hz_utility_v2pub.debug_return_messages (

3445: );
3446:
3447: -- Debug Message
3448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3449: hz_utility_v2pub.debug_return_messages (
3450: x_msg_count, x_msg_data, 'ERROR');
3451: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3452: END IF;
3453:

Line 3451: hz_utility_v2pub.debug('Create_Channel_Team (-)');

3447: -- Debug Message
3448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3449: hz_utility_v2pub.debug_return_messages (
3450: x_msg_count, x_msg_data, 'ERROR');
3451: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3452: END IF;
3453:
3454: WHEN FND_API.g_exc_unexpected_error THEN
3455: ROLLBACK TO create_channel_team_pub;

Line 3464: hz_utility_v2pub.debug_return_messages (

3460: ,p_data => x_msg_data
3461: );
3462: -- Debug Message
3463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3464: hz_utility_v2pub.debug_return_messages (
3465: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
3466: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3467: END IF;
3468:

Line 3466: hz_utility_v2pub.debug('Create_Channel_Team (-)');

3462: -- Debug Message
3463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3464: hz_utility_v2pub.debug_return_messages (
3465: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
3466: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3467: END IF;
3468:
3469: WHEN OTHERS THEN
3470: ROLLBACK TO create_channel_team_pub;

Line 3486: hz_utility_v2pub.debug_return_messages (

3482: );
3483:
3484: -- Debug Message
3485: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3486: hz_utility_v2pub.debug_return_messages (
3487: x_msg_count, x_msg_data, 'SQL ERROR');
3488: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3489: END IF;
3490:

Line 3488: hz_utility_v2pub.debug('Create_Channel_Team (-)');

3484: -- Debug Message
3485: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3486: hz_utility_v2pub.debug_return_messages (
3487: x_msg_count, x_msg_data, 'SQL ERROR');
3488: hz_utility_v2pub.debug('Create_Channel_Team (-)');
3489: END IF;
3490:
3491: END Create_Channel_Team;
3492:

Line 3971: hz_utility_v2pub.debug_return_messages (

3967: );
3968:
3969: -- Debug Message
3970: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3971: hz_utility_v2pub.debug_return_messages (
3972: x_msg_count, x_msg_data, 'ERROR');
3973: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
3974: END IF;
3975:

Line 3973: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');

3969: -- Debug Message
3970: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3971: hz_utility_v2pub.debug_return_messages (
3972: x_msg_count, x_msg_data, 'ERROR');
3973: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
3974: END IF;
3975:
3976: WHEN FND_API.g_exc_unexpected_error THEN
3977:

Line 3986: hz_utility_v2pub.debug_return_messages (

3982: ,p_data => x_msg_data
3983: );
3984: -- Debug Message
3985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3986: hz_utility_v2pub.debug_return_messages (
3987: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
3988: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
3989: END IF;
3990:

Line 3988: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');

3984: -- Debug Message
3985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3986: hz_utility_v2pub.debug_return_messages (
3987: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
3988: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
3989: END IF;
3990:
3991: WHEN OTHERS THEN
3992:

Line 4008: hz_utility_v2pub.debug_return_messages (

4004: );
4005:
4006: -- Debug Message
4007: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4008: hz_utility_v2pub.debug_return_messages (
4009: x_msg_count, x_msg_data, 'SQL ERROR');
4010: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
4011: END IF;
4012: */

Line 4010: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');

4006: -- Debug Message
4007: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4008: hz_utility_v2pub.debug_return_messages (
4009: x_msg_count, x_msg_data, 'SQL ERROR');
4010: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
4011: END IF;
4012: */
4013:
4014: end Do_Cr_Online_Chnl_Team;

Line 4523: hz_utility_v2pub.debug_return_messages (

4519: );
4520:
4521: -- Debug Message
4522: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4523: hz_utility_v2pub.debug_return_messages (
4524: x_msg_count, x_msg_data, 'ERROR');
4525: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
4526: END IF;
4527:

Line 4525: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');

4521: -- Debug Message
4522: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4523: hz_utility_v2pub.debug_return_messages (
4524: x_msg_count, x_msg_data, 'ERROR');
4525: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
4526: END IF;
4527:
4528: WHEN FND_API.g_exc_unexpected_error THEN
4529:

Line 4538: hz_utility_v2pub.debug_return_messages (

4534: ,p_data => x_msg_data
4535: );
4536: -- Debug Message
4537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4538: hz_utility_v2pub.debug_return_messages (
4539: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
4540: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
4541: END IF;
4542:

Line 4540: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');

4536: -- Debug Message
4537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4538: hz_utility_v2pub.debug_return_messages (
4539: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
4540: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
4541: END IF;
4542:
4543: WHEN OTHERS THEN
4544:

Line 4560: hz_utility_v2pub.debug_return_messages (

4556: );
4557:
4558: -- Debug Message
4559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4560: hz_utility_v2pub.debug_return_messages (
4561: x_msg_count, x_msg_data, 'SQL ERROR');
4562: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
4563: END IF;
4564: */

Line 4562: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');

4558: -- Debug Message
4559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4560: hz_utility_v2pub.debug_return_messages (
4561: x_msg_count, x_msg_data, 'SQL ERROR');
4562: hz_utility_v2pub.debug('Create_Online_Channel_Team (-)');
4563: END IF;
4564: */
4565: END Create_Online_Channel_Team;
4566:

Line 4837: hz_utility_v2pub.debug_return_messages (

4833: );
4834:
4835: -- Debug Message
4836: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4837: hz_utility_v2pub.debug_return_messages (
4838: x_msg_count, x_msg_data, 'ERROR');
4839: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');
4840: END IF;
4841:

Line 4839: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');

4835: -- Debug Message
4836: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4837: hz_utility_v2pub.debug_return_messages (
4838: x_msg_count, x_msg_data, 'ERROR');
4839: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');
4840: END IF;
4841:
4842: WHEN FND_API.g_exc_unexpected_error THEN
4843: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 4856: hz_utility_v2pub.debug_return_messages (

4852: ,p_data => x_msg_data
4853: );
4854: -- Debug Message
4855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4856: hz_utility_v2pub.debug_return_messages (
4857: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
4858: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');
4859: END IF;
4860:

Line 4858: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');

4854: -- Debug Message
4855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4856: hz_utility_v2pub.debug_return_messages (
4857: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
4858: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');
4859: END IF;
4860:
4861: WHEN OTHERS THEN
4862: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 4881: hz_utility_v2pub.debug_return_messages (

4877: );
4878:
4879: -- Debug Message
4880: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4881: hz_utility_v2pub.debug_return_messages (
4882: x_msg_count, x_msg_data, 'SQL ERROR');
4883: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');
4884: END IF;
4885: END Create_VAD_Channel_Team;

Line 4883: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');

4879: -- Debug Message
4880: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4881: hz_utility_v2pub.debug_return_messages (
4882: x_msg_count, x_msg_data, 'SQL ERROR');
4883: hz_utility_v2pub.debug('Create_VAD_Channel_Team (-)');
4884: END IF;
4885: END Create_VAD_Channel_Team;
4886:
4887: -- Start of Comments

Line 5087: hz_utility_v2pub.debug_return_messages (

5083: );
5084:
5085: -- Debug Message
5086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5087: hz_utility_v2pub.debug_return_messages (
5088: x_msg_count, x_msg_data, 'ERROR');
5089: hz_utility_v2pub.debug('Update_Channel_Team (-)');
5090: END IF;
5091:

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

5085: -- Debug Message
5086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5087: hz_utility_v2pub.debug_return_messages (
5088: x_msg_count, x_msg_data, 'ERROR');
5089: hz_utility_v2pub.debug('Update_Channel_Team (-)');
5090: END IF;
5091:
5092: WHEN FND_API.g_exc_unexpected_error THEN
5093: ROLLBACK TO Update_Channel_Team_pub;

Line 5103: hz_utility_v2pub.debug_return_messages (

5099: ,p_data => x_msg_data
5100: );
5101: -- Debug Message
5102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5103: hz_utility_v2pub.debug_return_messages (
5104: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5105: hz_utility_v2pub.debug('Update_Channel_Team (-)');
5106: END IF;
5107:

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

5101: -- Debug Message
5102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5103: hz_utility_v2pub.debug_return_messages (
5104: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5105: hz_utility_v2pub.debug('Update_Channel_Team (-)');
5106: END IF;
5107:
5108: WHEN OTHERS THEN
5109: ROLLBACK TO Update_Channel_Team_pub;

Line 5120: hz_utility_v2pub.debug_return_messages (

5116: );
5117:
5118: -- Debug Message
5119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5120: hz_utility_v2pub.debug_return_messages (
5121: x_msg_count, x_msg_data, 'SQL ERROR');
5122: hz_utility_v2pub.debug('Update_Channel_Team (-)');
5123: END IF;
5124: END Update_Channel_Team;

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

5118: -- Debug Message
5119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5120: hz_utility_v2pub.debug_return_messages (
5121: x_msg_count, x_msg_data, 'SQL ERROR');
5122: hz_utility_v2pub.debug('Update_Channel_Team (-)');
5123: END IF;
5124: END Update_Channel_Team;
5125:
5126: -- Start of Comments

Line 5318: hz_utility_v2pub.debug_return_messages (

5314: );
5315:
5316: -- Debug Message
5317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5318: hz_utility_v2pub.debug_return_messages (
5319: x_msg_count, x_msg_data, 'ERROR');
5320:
5321: hz_utility_v2pub.debug('Process_Channel_Team (-)');
5322: END IF;

Line 5321: hz_utility_v2pub.debug('Process_Channel_Team (-)');

5317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5318: hz_utility_v2pub.debug_return_messages (
5319: x_msg_count, x_msg_data, 'ERROR');
5320:
5321: hz_utility_v2pub.debug('Process_Channel_Team (-)');
5322: END IF;
5323:
5324: WHEN FND_API.g_exc_unexpected_error THEN
5325: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 5334: hz_utility_v2pub.debug_return_messages (

5330: );
5331:
5332: -- Debug Message
5333: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5334: hz_utility_v2pub.debug_return_messages (
5335: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5336: hz_utility_v2pub.debug('Process_Channel_Team (-)');
5337: END IF;
5338:

Line 5336: hz_utility_v2pub.debug('Process_Channel_Team (-)');

5332: -- Debug Message
5333: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5334: hz_utility_v2pub.debug_return_messages (
5335: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5336: hz_utility_v2pub.debug('Process_Channel_Team (-)');
5337: END IF;
5338:
5339: WHEN OTHERS THEN
5340: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 5349: hz_utility_v2pub.debug_return_messages (

5345: );
5346:
5347: -- Debug Message
5348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5349: hz_utility_v2pub.debug_return_messages (
5350: x_msg_count, x_msg_data, 'SQL ERROR');
5351: hz_utility_v2pub.debug('Process_Channel_Team (-)');
5352: END IF;
5353: END Process_Channel_Team;

Line 5351: hz_utility_v2pub.debug('Process_Channel_Team (-)');

5347: -- Debug Message
5348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5349: hz_utility_v2pub.debug_return_messages (
5350: x_msg_count, x_msg_data, 'SQL ERROR');
5351: hz_utility_v2pub.debug('Process_Channel_Team (-)');
5352: END IF;
5353: END Process_Channel_Team;
5354: -- Start of Comments
5355: --