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.HZ_PARTY_SITE_V2PUB dependencies on FND_LOG

Line 236: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

232:
233: BEGIN
234:
235: -- Debug info.
236: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
237: hz_utility_v2pub.debug(p_message=>'do_create_party_site (+)',
238: p_prefix=>l_debug_prefix,
239: p_msg_level=>fnd_log.level_procedure);
240: END IF;

Line 239: p_msg_level=>fnd_log.level_procedure);

235: -- Debug info.
236: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
237: hz_utility_v2pub.debug(p_message=>'do_create_party_site (+)',
238: p_prefix=>l_debug_prefix,
239: p_msg_level=>fnd_log.level_procedure);
240: END IF;
241:
242: -- if primary key value is passed, check for uniqueness.
243: IF l_party_site_id IS NOT NULL AND

Line 445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

441: END IF;
442:
443:
444: -- Debug info.
445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
446: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (+)',
447: p_prefix=>l_debug_prefix,
448: p_msg_level=>fnd_log.level_procedure);
449: END IF;

Line 448: p_msg_level=>fnd_log.level_procedure);

444: -- Debug info.
445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
446: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (+)',
447: p_prefix=>l_debug_prefix,
448: p_msg_level=>fnd_log.level_procedure);
449: END IF;
450:
451: -- call table-handler.
452: HZ_PARTY_SITES_PKG.Insert_Row (

Line 496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

492: );
493:
494:
495: -- Debug info.
496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
497: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (-) ' ||
498: 'x_party_site_id = ' || p_party_site_rec.party_site_id,
499: p_prefix=>l_debug_prefix,
500: p_msg_level=>fnd_log.level_procedure);

Line 500: p_msg_level=>fnd_log.level_procedure);

496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
497: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (-) ' ||
498: 'x_party_site_id = ' || p_party_site_rec.party_site_id,
499: p_prefix=>l_debug_prefix,
500: p_msg_level=>fnd_log.level_procedure);
501: END IF;
502:
503: --Bug13117445
504: --Added DQM Sync call

Line 592: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590:
591: -- Debug info.
592: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
593: hz_utility_v2pub.debug(p_message=>'do_create_party_site (-)',
594: p_prefix=>l_debug_prefix,
595: p_msg_level=>fnd_log.level_procedure);
596: END IF;

Line 595: p_msg_level=>fnd_log.level_procedure);

591: -- Debug info.
592: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
593: hz_utility_v2pub.debug(p_message=>'do_create_party_site (-)',
594: p_prefix=>l_debug_prefix,
595: p_msg_level=>fnd_log.level_procedure);
596: END IF;
597:
598: END do_create_party_site;
599:

Line 662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

658:
659: BEGIN
660:
661: -- Debug info.
662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'do_update_party_site (+)',
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;

Line 665: p_msg_level=>fnd_log.level_procedure);

661: -- Debug info.
662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'do_update_party_site (+)',
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;
667:
668:
669: -- check whether record has been updated by another user. If not, lock it.

Line 868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

864: -- but we should not update existing osr, set it to null
865: end if;
866:
867: -- Debug info.
868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (+) ',
870: p_prefix=>l_debug_prefix,
871: p_msg_level=>fnd_log.level_procedure);
872: END IF;

Line 871: p_msg_level=>fnd_log.level_procedure);

867: -- Debug info.
868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (+) ',
870: p_prefix=>l_debug_prefix,
871: p_msg_level=>fnd_log.level_procedure);
872: END IF;
873:
874: --Call to table-handler
875: HZ_PARTY_SITES_PKG.Update_Row (

Line 920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

916: X_DUNS_NUMBER_C => p_party_site_rec.duns_number_c
917: );
918:
919: -- Debug info.
920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
921: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (-) ',
922: p_prefix=>l_debug_prefix,
923: p_msg_level=>fnd_log.level_procedure);
924: END IF;

Line 923: p_msg_level=>fnd_log.level_procedure);

919: -- Debug info.
920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
921: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (-) ',
922: p_prefix=>l_debug_prefix,
923: p_msg_level=>fnd_log.level_procedure);
924: END IF;
925: --
926: --- If old and new statuses are different, then call
927: --- the cascade_site_status_changes procedure to synch

Line 961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

957: RAISE FND_API.G_EXC_ERROR;
958: END IF;
959:
960: -- Debug info.
961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
962: hz_utility_v2pub.debug(p_message=> 'do_update_party_site (-)',
963: p_prefix=>l_debug_prefix,
964: p_msg_level=>fnd_log.level_procedure);
965: END IF;

Line 964: p_msg_level=>fnd_log.level_procedure);

960: -- Debug info.
961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
962: hz_utility_v2pub.debug(p_message=> 'do_update_party_site (-)',
963: p_prefix=>l_debug_prefix,
964: p_msg_level=>fnd_log.level_procedure);
965: END IF;
966:
967: END do_update_party_site;
968:

Line 1021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1017:
1018: BEGIN
1019:
1020: -- Debug info.
1021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1022: hz_utility_v2pub.debug(p_message=>'do_create_party_site_use (+)',
1023: p_prefix=>l_debug_prefix,
1024: p_msg_level=>fnd_log.level_procedure);
1025: END IF;

Line 1024: p_msg_level=>fnd_log.level_procedure);

1020: -- Debug info.
1021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1022: hz_utility_v2pub.debug(p_message=>'do_create_party_site_use (+)',
1023: p_prefix=>l_debug_prefix,
1024: p_msg_level=>fnd_log.level_procedure);
1025: END IF;
1026:
1027: -- if primary key value is passed, check for uniqueness.
1028: IF l_party_site_use_id IS NOT NULL AND

Line 1102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1098: -- p_party_site_use_rec.primary_per_type := l_primary_per_type;--Bug 2065191.
1099: END IF;-- end if corresponding to if added for bug 2065191.
1100:
1101: -- Debug info.
1102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1103: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (+)',
1104: p_prefix=>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_procedure);
1106: END IF;

Line 1105: p_msg_level=>fnd_log.level_procedure);

1101: -- Debug info.
1102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1103: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (+)',
1104: p_prefix=>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_procedure);
1106: END IF;
1107:
1108: -- call table-handler.
1109: HZ_PARTY_SITE_USES_PKG.Insert_Row (

Line 1124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1120:
1121: x_party_site_use_id := p_party_site_use_rec.party_site_use_id;
1122:
1123: -- Debug info.
1124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1125: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (-) ' ||
1126: 'x_party_site_use_id = ' || x_party_site_use_id,
1127: p_prefix=>l_debug_prefix,
1128: p_msg_level=>fnd_log.level_procedure);

Line 1128: p_msg_level=>fnd_log.level_procedure);

1124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1125: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (-) ' ||
1126: 'x_party_site_use_id = ' || x_party_site_use_id,
1127: p_prefix=>l_debug_prefix,
1128: p_msg_level=>fnd_log.level_procedure);
1129: END IF;
1130:
1131: -- Debug info.
1132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1128: p_msg_level=>fnd_log.level_procedure);
1129: END IF;
1130:
1131: -- Debug info.
1132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug(p_message=>'do_create_party_site_use (-)',
1134: p_prefix=>l_debug_prefix,
1135: p_msg_level=>fnd_log.level_procedure);
1136: END IF;

Line 1135: p_msg_level=>fnd_log.level_procedure);

1131: -- Debug info.
1132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug(p_message=>'do_create_party_site_use (-)',
1134: p_prefix=>l_debug_prefix,
1135: p_msg_level=>fnd_log.level_procedure);
1136: END IF;
1137:
1138: END do_create_party_site_use;
1139:

Line 1187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1183:
1184: BEGIN
1185:
1186: -- Debug info.
1187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1188: hz_utility_v2pub.debug(p_message=>'do_update_party_site_use (+)',
1189: p_prefix=>l_debug_prefix,
1190: p_msg_level=>fnd_log.level_procedure);
1191: END IF;

Line 1190: p_msg_level=>fnd_log.level_procedure);

1186: -- Debug info.
1187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1188: hz_utility_v2pub.debug(p_message=>'do_update_party_site_use (+)',
1189: p_prefix=>l_debug_prefix,
1190: p_msg_level=>fnd_log.level_procedure);
1191: END IF;
1192:
1193: -- check whether record has been updated by another user. If not, lock it.
1194: BEGIN

Line 1337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;
1335:
1336: -- Debug info.
1337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1338: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (+) ',
1339: p_prefix=>l_debug_prefix,
1340: p_msg_level=>fnd_log.level_procedure);
1341: END IF;

Line 1340: p_msg_level=>fnd_log.level_procedure);

1336: -- Debug info.
1337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1338: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (+) ',
1339: p_prefix=>l_debug_prefix,
1340: p_msg_level=>fnd_log.level_procedure);
1341: END IF;
1342:
1343:
1344:

Line 1360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1356: X_APPLICATION_ID => p_party_site_use_rec.application_id
1357: );
1358:
1359: -- Debug info.
1360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1361: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (-) ',
1362: p_prefix=>l_debug_prefix,
1363: p_msg_level=>fnd_log.level_procedure);
1364: END IF;

Line 1363: p_msg_level=>fnd_log.level_procedure);

1359: -- Debug info.
1360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1361: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (-) ',
1362: p_prefix=>l_debug_prefix,
1363: p_msg_level=>fnd_log.level_procedure);
1364: END IF;
1365:
1366: -- Debug info.
1367: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1367: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1363: p_msg_level=>fnd_log.level_procedure);
1364: END IF;
1365:
1366: -- Debug info.
1367: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1368: hz_utility_v2pub.debug(p_message=>'do_update_party_site_use (-)',
1369: p_prefix=>l_debug_prefix,
1370: p_msg_level=>fnd_log.level_procedure);
1371: END IF;

Line 1370: p_msg_level=>fnd_log.level_procedure);

1366: -- Debug info.
1367: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1368: hz_utility_v2pub.debug(p_message=>'do_update_party_site_use (-)',
1369: p_prefix=>l_debug_prefix,
1370: p_msg_level=>fnd_log.level_procedure);
1371: END IF;
1372:
1373: END do_update_party_site_use;
1374:

Line 1743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1739: -- Check if API is called in debug mode. If yes, enable debug.
1740: --enable_debug;
1741:
1742: -- Debug info.
1743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1744: hz_utility_v2pub.debug(p_message=>'create_party_site (+)',
1745: p_prefix=>l_debug_prefix,
1746: p_msg_level=>fnd_log.level_procedure);
1747: END IF;

Line 1746: p_msg_level=>fnd_log.level_procedure);

1742: -- Debug info.
1743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1744: hz_utility_v2pub.debug(p_message=>'create_party_site (+)',
1745: p_prefix=>l_debug_prefix,
1746: p_msg_level=>fnd_log.level_procedure);
1747: END IF;
1748:
1749: -- initialize message list if p_init_msg_list is set to TRUE.
1750: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1865: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1861: p_count => x_msg_count,
1862: p_data => x_msg_data);
1863:
1864: -- Debug info.
1865: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1866: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1867: p_msg_data=>x_msg_data,
1868: p_msg_type=>'WARNING',
1869: p_msg_level=>fnd_log.level_exception);

Line 1869: p_msg_level=>fnd_log.level_exception);

1865: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1866: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1867: p_msg_data=>x_msg_data,
1868: p_msg_type=>'WARNING',
1869: p_msg_level=>fnd_log.level_exception);
1870: END IF;
1871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1873: p_prefix=>l_debug_prefix,

Line 1871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1867: p_msg_data=>x_msg_data,
1868: p_msg_type=>'WARNING',
1869: p_msg_level=>fnd_log.level_exception);
1870: END IF;
1871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1873: p_prefix=>l_debug_prefix,
1874: p_msg_level=>fnd_log.level_procedure);
1875: END IF;

Line 1874: p_msg_level=>fnd_log.level_procedure);

1870: END IF;
1871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1873: p_prefix=>l_debug_prefix,
1874: p_msg_level=>fnd_log.level_procedure);
1875: END IF;
1876:
1877: -- Check if API is called in debug mode. If yes, disable debug.
1878: --disable_debug;

Line 1890: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1886: p_count => x_msg_count,
1887: p_data => x_msg_data);
1888:
1889: -- Debug info.
1890: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1892: p_msg_data=>x_msg_data,
1893: p_msg_type=>'ERROR',
1894: p_msg_level=>fnd_log.level_error);

Line 1894: p_msg_level=>fnd_log.level_error);

1890: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1892: p_msg_data=>x_msg_data,
1893: p_msg_type=>'ERROR',
1894: p_msg_level=>fnd_log.level_error);
1895: END IF;
1896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1898: p_prefix=>l_debug_prefix,

Line 1896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1892: p_msg_data=>x_msg_data,
1893: p_msg_type=>'ERROR',
1894: p_msg_level=>fnd_log.level_error);
1895: END IF;
1896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1898: p_prefix=>l_debug_prefix,
1899: p_msg_level=>fnd_log.level_procedure);
1900: END IF;

Line 1899: p_msg_level=>fnd_log.level_procedure);

1895: END IF;
1896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1898: p_prefix=>l_debug_prefix,
1899: p_msg_level=>fnd_log.level_procedure);
1900: END IF;
1901:
1902: -- Check if API is called in debug mode. If yes, disable debug.
1903: --disable_debug;

Line 1914: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1910: p_count => x_msg_count,
1911: p_data => x_msg_data);
1912:
1913: -- Debug info.
1914: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1915: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1916: p_msg_data=>x_msg_data,
1917: p_msg_type=>'UNEXPECTED ERROR',
1918: p_msg_level=>fnd_log.level_error);

Line 1918: p_msg_level=>fnd_log.level_error);

1914: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1915: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1916: p_msg_data=>x_msg_data,
1917: p_msg_type=>'UNEXPECTED ERROR',
1918: p_msg_level=>fnd_log.level_error);
1919: END IF;
1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1922: p_prefix=>l_debug_prefix,

Line 1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1916: p_msg_data=>x_msg_data,
1917: p_msg_type=>'UNEXPECTED ERROR',
1918: p_msg_level=>fnd_log.level_error);
1919: END IF;
1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1922: p_prefix=>l_debug_prefix,
1923: p_msg_level=>fnd_log.level_procedure);
1924: END IF;

Line 1923: p_msg_level=>fnd_log.level_procedure);

1919: END IF;
1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1922: p_prefix=>l_debug_prefix,
1923: p_msg_level=>fnd_log.level_procedure);
1924: END IF;
1925:
1926: -- Check if API is called in debug mode. If yes, disable debug.
1927: --disable_debug;

Line 1941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1937: p_count => x_msg_count,
1938: p_data => x_msg_data);
1939:
1940: -- Debug info.
1941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1943: p_msg_data=>x_msg_data,
1944: p_msg_type=>'SQL ERROR',
1945: p_msg_level=>fnd_log.level_error);

Line 1945: p_msg_level=>fnd_log.level_error);

1941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1943: p_msg_data=>x_msg_data,
1944: p_msg_type=>'SQL ERROR',
1945: p_msg_level=>fnd_log.level_error);
1946: END IF;
1947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1948: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1949: p_prefix=>l_debug_prefix,

Line 1947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1943: p_msg_data=>x_msg_data,
1944: p_msg_type=>'SQL ERROR',
1945: p_msg_level=>fnd_log.level_error);
1946: END IF;
1947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1948: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1949: p_prefix=>l_debug_prefix,
1950: p_msg_level=>fnd_log.level_procedure);
1951: END IF;

Line 1950: p_msg_level=>fnd_log.level_procedure);

1946: END IF;
1947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1948: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1949: p_prefix=>l_debug_prefix,
1950: p_msg_level=>fnd_log.level_procedure);
1951: END IF;
1952:
1953: -- Check if API is called in debug mode. If yes, disable debug.
1954: --disable_debug;

Line 2019: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2015: -- Check if API is called in debug mode. If yes, enable debug.
2016: --enable_debug;
2017:
2018: -- Debug info.
2019: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2020: hz_utility_v2pub.debug(p_message=>'update_party_site (+)',
2021: p_prefix=>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_procedure);
2023: END IF;

Line 2022: p_msg_level=>fnd_log.level_procedure);

2018: -- Debug info.
2019: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2020: hz_utility_v2pub.debug(p_message=>'update_party_site (+)',
2021: p_prefix=>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_procedure);
2023: END IF;
2024:
2025: -- initialize message list if p_init_msg_list is set to TRUE.
2026: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2206: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2202: p_data => x_msg_data);
2203:
2204:
2205: -- Debug info.
2206: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2207: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2208: p_msg_data=>x_msg_data,
2209: p_msg_type=>'WARNING',
2210: p_msg_level=>fnd_log.level_exception);

Line 2210: p_msg_level=>fnd_log.level_exception);

2206: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2207: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2208: p_msg_data=>x_msg_data,
2209: p_msg_type=>'WARNING',
2210: p_msg_level=>fnd_log.level_exception);
2211: END IF;
2212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2213: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2214: p_prefix=>l_debug_prefix,

Line 2212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2208: p_msg_data=>x_msg_data,
2209: p_msg_type=>'WARNING',
2210: p_msg_level=>fnd_log.level_exception);
2211: END IF;
2212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2213: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2214: p_prefix=>l_debug_prefix,
2215: p_msg_level=>fnd_log.level_procedure);
2216: END IF;

Line 2215: p_msg_level=>fnd_log.level_procedure);

2211: END IF;
2212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2213: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2214: p_prefix=>l_debug_prefix,
2215: p_msg_level=>fnd_log.level_procedure);
2216: END IF;
2217:
2218: -- Check if API is called in debug mode. If yes, disable debug.
2219: --disable_debug;

Line 2231: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2227: p_count => x_msg_count,
2228: p_data => x_msg_data);
2229:
2230: -- Debug info.
2231: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2233: p_msg_data=>x_msg_data,
2234: p_msg_type=>'ERROR',
2235: p_msg_level=>fnd_log.level_error);

Line 2235: p_msg_level=>fnd_log.level_error);

2231: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2233: p_msg_data=>x_msg_data,
2234: p_msg_type=>'ERROR',
2235: p_msg_level=>fnd_log.level_error);
2236: END IF;
2237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2238: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2239: p_prefix=>l_debug_prefix,

Line 2237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2233: p_msg_data=>x_msg_data,
2234: p_msg_type=>'ERROR',
2235: p_msg_level=>fnd_log.level_error);
2236: END IF;
2237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2238: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2239: p_prefix=>l_debug_prefix,
2240: p_msg_level=>fnd_log.level_procedure);
2241: END IF;

Line 2240: p_msg_level=>fnd_log.level_procedure);

2236: END IF;
2237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2238: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2239: p_prefix=>l_debug_prefix,
2240: p_msg_level=>fnd_log.level_procedure);
2241: END IF;
2242:
2243:
2244: -- Check if API is called in debug mode. If yes, disable debug.

Line 2256: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2252: p_count => x_msg_count,
2253: p_data => x_msg_data);
2254:
2255: -- Debug info.
2256: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2258: p_msg_data=>x_msg_data,
2259: p_msg_type=>'UNEXPECTED ERROR',
2260: p_msg_level=>fnd_log.level_error);

Line 2260: p_msg_level=>fnd_log.level_error);

2256: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2258: p_msg_data=>x_msg_data,
2259: p_msg_type=>'UNEXPECTED ERROR',
2260: p_msg_level=>fnd_log.level_error);
2261: END IF;
2262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2263: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2264: p_prefix=>l_debug_prefix,

Line 2262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2258: p_msg_data=>x_msg_data,
2259: p_msg_type=>'UNEXPECTED ERROR',
2260: p_msg_level=>fnd_log.level_error);
2261: END IF;
2262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2263: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2264: p_prefix=>l_debug_prefix,
2265: p_msg_level=>fnd_log.level_procedure);
2266: END IF;

Line 2265: p_msg_level=>fnd_log.level_procedure);

2261: END IF;
2262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2263: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2264: p_prefix=>l_debug_prefix,
2265: p_msg_level=>fnd_log.level_procedure);
2266: END IF;
2267:
2268: -- Check if API is called in debug mode. If yes, disable debug.
2269: --disable_debug;

Line 2283: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281:
2282: -- Debug info.
2283: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2284: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2285: p_msg_data=>x_msg_data,
2286: p_msg_type=>'SQL ERROR',
2287: p_msg_level=>fnd_log.level_error);

Line 2287: p_msg_level=>fnd_log.level_error);

2283: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2284: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2285: p_msg_data=>x_msg_data,
2286: p_msg_type=>'SQL ERROR',
2287: p_msg_level=>fnd_log.level_error);
2288: END IF;
2289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2290: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2291: p_prefix=>l_debug_prefix,

Line 2289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2285: p_msg_data=>x_msg_data,
2286: p_msg_type=>'SQL ERROR',
2287: p_msg_level=>fnd_log.level_error);
2288: END IF;
2289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2290: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2291: p_prefix=>l_debug_prefix,
2292: p_msg_level=>fnd_log.level_procedure);
2293: END IF;

Line 2292: p_msg_level=>fnd_log.level_procedure);

2288: END IF;
2289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2290: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2291: p_prefix=>l_debug_prefix,
2292: p_msg_level=>fnd_log.level_procedure);
2293: END IF;
2294:
2295: -- Check if API is called in debug mode. If yes, disable debug.
2296: --disable_debug;

Line 2353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2349: -- Check if API is called in debug mode. If yes, enable debug.
2350: --enable_debug;
2351:
2352: -- Debug info.
2353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2354: hz_utility_v2pub.debug(p_message=>'create_party_site_use (+)',
2355: p_prefix=>l_debug_prefix,
2356: p_msg_level=>fnd_log.level_procedure);
2357: END IF;

Line 2356: p_msg_level=>fnd_log.level_procedure);

2352: -- Debug info.
2353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2354: hz_utility_v2pub.debug(p_message=>'create_party_site_use (+)',
2355: p_prefix=>l_debug_prefix,
2356: p_msg_level=>fnd_log.level_procedure);
2357: END IF;
2358:
2359:
2360: -- initialize message list if p_init_msg_list is set to TRUE.

Line 2397: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2393: p_count => x_msg_count,
2394: p_data => x_msg_data);
2395:
2396: -- Debug info.
2397: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2399: p_msg_data=>x_msg_data,
2400: p_msg_type=>'WARNING',
2401: p_msg_level=>fnd_log.level_exception);

Line 2401: p_msg_level=>fnd_log.level_exception);

2397: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2399: p_msg_data=>x_msg_data,
2400: p_msg_type=>'WARNING',
2401: p_msg_level=>fnd_log.level_exception);
2402: END IF;
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2404: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2405: p_prefix=>l_debug_prefix,

Line 2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2399: p_msg_data=>x_msg_data,
2400: p_msg_type=>'WARNING',
2401: p_msg_level=>fnd_log.level_exception);
2402: END IF;
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2404: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2405: p_prefix=>l_debug_prefix,
2406: p_msg_level=>fnd_log.level_procedure);
2407: END IF;

Line 2406: p_msg_level=>fnd_log.level_procedure);

2402: END IF;
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2404: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2405: p_prefix=>l_debug_prefix,
2406: p_msg_level=>fnd_log.level_procedure);
2407: END IF;
2408:
2409: -- Check if API is called in debug mode. If yes, disable debug.
2410: --disable_debug;

Line 2422: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2418: p_count => x_msg_count,
2419: p_data => x_msg_data);
2420:
2421: -- Debug info.
2422: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2423: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2424: p_msg_data=>x_msg_data,
2425: p_msg_type=>'ERROR',
2426: p_msg_level=>fnd_log.level_error);

Line 2426: p_msg_level=>fnd_log.level_error);

2422: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2423: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2424: p_msg_data=>x_msg_data,
2425: p_msg_type=>'ERROR',
2426: p_msg_level=>fnd_log.level_error);
2427: END IF;
2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2429: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2430: p_prefix=>l_debug_prefix,

Line 2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2424: p_msg_data=>x_msg_data,
2425: p_msg_type=>'ERROR',
2426: p_msg_level=>fnd_log.level_error);
2427: END IF;
2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2429: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2430: p_prefix=>l_debug_prefix,
2431: p_msg_level=>fnd_log.level_procedure);
2432: END IF;

Line 2431: p_msg_level=>fnd_log.level_procedure);

2427: END IF;
2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2429: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2430: p_prefix=>l_debug_prefix,
2431: p_msg_level=>fnd_log.level_procedure);
2432: END IF;
2433:
2434: -- Check if API is called in debug mode. If yes, disable debug.
2435: --disable_debug;

Line 2446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2442: p_count => x_msg_count,
2443: p_data => x_msg_data);
2444:
2445: -- Debug info.
2446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2448: p_msg_data=>x_msg_data,
2449: p_msg_type=>'UNEXPECTED ERROR',
2450: p_msg_level=>fnd_log.level_error);

Line 2450: p_msg_level=>fnd_log.level_error);

2446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2448: p_msg_data=>x_msg_data,
2449: p_msg_type=>'UNEXPECTED ERROR',
2450: p_msg_level=>fnd_log.level_error);
2451: END IF;
2452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2454: p_prefix=>l_debug_prefix,

Line 2452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2448: p_msg_data=>x_msg_data,
2449: p_msg_type=>'UNEXPECTED ERROR',
2450: p_msg_level=>fnd_log.level_error);
2451: END IF;
2452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2454: p_prefix=>l_debug_prefix,
2455: p_msg_level=>fnd_log.level_procedure);
2456: END IF;

Line 2455: p_msg_level=>fnd_log.level_procedure);

2451: END IF;
2452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2454: p_prefix=>l_debug_prefix,
2455: p_msg_level=>fnd_log.level_procedure);
2456: END IF;
2457:
2458: -- Check if API is called in debug mode. If yes, disable debug.
2459: --disable_debug;

Line 2473: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2469: p_count => x_msg_count,
2470: p_data => x_msg_data);
2471:
2472: -- Debug info.
2473: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2475: p_msg_data=>x_msg_data,
2476: p_msg_type=>'SQL ERROR',
2477: p_msg_level=>fnd_log.level_error);

Line 2477: p_msg_level=>fnd_log.level_error);

2473: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2475: p_msg_data=>x_msg_data,
2476: p_msg_type=>'SQL ERROR',
2477: p_msg_level=>fnd_log.level_error);
2478: END IF;
2479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2480: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2481: p_prefix=>l_debug_prefix,

Line 2479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2475: p_msg_data=>x_msg_data,
2476: p_msg_type=>'SQL ERROR',
2477: p_msg_level=>fnd_log.level_error);
2478: END IF;
2479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2480: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2481: p_prefix=>l_debug_prefix,
2482: p_msg_level=>fnd_log.level_procedure);
2483: END IF;

Line 2482: p_msg_level=>fnd_log.level_procedure);

2478: END IF;
2479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2480: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2481: p_prefix=>l_debug_prefix,
2482: p_msg_level=>fnd_log.level_procedure);
2483: END IF;
2484:
2485: -- Check if API is called in debug mode. If yes, disable debug.
2486: --disable_debug;

Line 2542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2538: -- Check if API is called in debug mode. If yes, enable debug.
2539: --enable_debug;
2540:
2541: -- Debug info.
2542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2543: hz_utility_v2pub.debug(p_message=>'update_party_site_use (+)',
2544: p_prefix=>l_debug_prefix,
2545: p_msg_level=>fnd_log.level_procedure);
2546: END IF;

Line 2545: p_msg_level=>fnd_log.level_procedure);

2541: -- Debug info.
2542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2543: hz_utility_v2pub.debug(p_message=>'update_party_site_use (+)',
2544: p_prefix=>l_debug_prefix,
2545: p_msg_level=>fnd_log.level_procedure);
2546: END IF;
2547:
2548: -- initialize message list if p_init_msg_list is set to TRUE.
2549: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2599: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2595: p_count => x_msg_count,
2596: p_data => x_msg_data);
2597:
2598: -- Debug info.
2599: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2601: p_msg_data=>x_msg_data,
2602: p_msg_type=>'WARNING',
2603: p_msg_level=>fnd_log.level_exception);

Line 2603: p_msg_level=>fnd_log.level_exception);

2599: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2601: p_msg_data=>x_msg_data,
2602: p_msg_type=>'WARNING',
2603: p_msg_level=>fnd_log.level_exception);
2604: END IF;
2605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2606: hz_utility_v2pub.debug(p_message=> 'update_party_site_use (-)',
2607: p_prefix=>l_debug_prefix,

Line 2605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2601: p_msg_data=>x_msg_data,
2602: p_msg_type=>'WARNING',
2603: p_msg_level=>fnd_log.level_exception);
2604: END IF;
2605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2606: hz_utility_v2pub.debug(p_message=> 'update_party_site_use (-)',
2607: p_prefix=>l_debug_prefix,
2608: p_msg_level=>fnd_log.level_procedure);
2609: END IF;

Line 2608: p_msg_level=>fnd_log.level_procedure);

2604: END IF;
2605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2606: hz_utility_v2pub.debug(p_message=> 'update_party_site_use (-)',
2607: p_prefix=>l_debug_prefix,
2608: p_msg_level=>fnd_log.level_procedure);
2609: END IF;
2610:
2611: -- Check if API is called in debug mode. If yes, disable debug.
2612: --disable_debug;

Line 2624: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2620: p_count => x_msg_count,
2621: p_data => x_msg_data);
2622:
2623: -- Debug info.
2624: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2625: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2626: p_msg_data=>x_msg_data,
2627: p_msg_type=>'ERROR',
2628: p_msg_level=>fnd_log.level_error);

Line 2628: p_msg_level=>fnd_log.level_error);

2624: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2625: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2626: p_msg_data=>x_msg_data,
2627: p_msg_type=>'ERROR',
2628: p_msg_level=>fnd_log.level_error);
2629: END IF;
2630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2631: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2632: p_prefix=>l_debug_prefix,

Line 2630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2626: p_msg_data=>x_msg_data,
2627: p_msg_type=>'ERROR',
2628: p_msg_level=>fnd_log.level_error);
2629: END IF;
2630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2631: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2632: p_prefix=>l_debug_prefix,
2633: p_msg_level=>fnd_log.level_procedure);
2634: END IF;

Line 2633: p_msg_level=>fnd_log.level_procedure);

2629: END IF;
2630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2631: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2632: p_prefix=>l_debug_prefix,
2633: p_msg_level=>fnd_log.level_procedure);
2634: END IF;
2635:
2636: -- Check if API is called in debug mode. If yes, disable debug.
2637: --disable_debug;

Line 2648: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2644: p_count => x_msg_count,
2645: p_data => x_msg_data);
2646:
2647: -- Debug info.
2648: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2649: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2650: p_msg_data=>x_msg_data,
2651: p_msg_type=>'UNEXPECTED ERROR',
2652: p_msg_level=>fnd_log.level_error);

Line 2652: p_msg_level=>fnd_log.level_error);

2648: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2649: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2650: p_msg_data=>x_msg_data,
2651: p_msg_type=>'UNEXPECTED ERROR',
2652: p_msg_level=>fnd_log.level_error);
2653: END IF;
2654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2655: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2656: p_prefix=>l_debug_prefix,

Line 2654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2650: p_msg_data=>x_msg_data,
2651: p_msg_type=>'UNEXPECTED ERROR',
2652: p_msg_level=>fnd_log.level_error);
2653: END IF;
2654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2655: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2656: p_prefix=>l_debug_prefix,
2657: p_msg_level=>fnd_log.level_procedure);
2658: END IF;

Line 2657: p_msg_level=>fnd_log.level_procedure);

2653: END IF;
2654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2655: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2656: p_prefix=>l_debug_prefix,
2657: p_msg_level=>fnd_log.level_procedure);
2658: END IF;
2659:
2660: -- Check if API is called in debug mode. If yes, disable debug.
2661: --disable_debug;

Line 2675: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2671: p_count => x_msg_count,
2672: p_data => x_msg_data);
2673:
2674: -- Debug info.
2675: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2677: p_msg_data=>x_msg_data,
2678: p_msg_type=>'SQL ERROR',
2679: p_msg_level=>fnd_log.level_error);

Line 2679: p_msg_level=>fnd_log.level_error);

2675: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2677: p_msg_data=>x_msg_data,
2678: p_msg_type=>'SQL ERROR',
2679: p_msg_level=>fnd_log.level_error);
2680: END IF;
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2683: p_prefix=>l_debug_prefix,

Line 2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2677: p_msg_data=>x_msg_data,
2678: p_msg_type=>'SQL ERROR',
2679: p_msg_level=>fnd_log.level_error);
2680: END IF;
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2683: p_prefix=>l_debug_prefix,
2684: p_msg_level=>fnd_log.level_procedure);
2685: END IF;

Line 2684: p_msg_level=>fnd_log.level_procedure);

2680: END IF;
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2683: p_prefix=>l_debug_prefix,
2684: p_msg_level=>fnd_log.level_procedure);
2685: END IF;
2686:
2687: -- Check if API is called in debug mode. If yes, disable debug.
2688: --disable_debug;

Line 2985: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2981:
2982: BEGIN
2983:
2984: -- Debug info.
2985: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug(p_message=> 'update_acct_sites_status (+)',
2987: p_prefix=>l_debug_prefix,
2988: p_msg_level=>fnd_log.level_procedure);
2989: END IF;

Line 2988: p_msg_level=>fnd_log.level_procedure);

2984: -- Debug info.
2985: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug(p_message=> 'update_acct_sites_status (+)',
2987: p_prefix=>l_debug_prefix,
2988: p_msg_level=>fnd_log.level_procedure);
2989: END IF;
2990:
2991: -- check whether record has been updated by another user. If not, lock it.
2992: BEGIN

Line 3017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3013: RAISE FND_API.G_EXC_ERROR;
3014: END;
3015:
3016: -- Debug info.
3017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3018: hz_utility_v2pub.debug(p_message=>'update_acct_sites_status (-)',
3019: p_prefix=>l_debug_prefix,
3020: p_msg_level=>fnd_log.level_procedure);
3021: END IF;

Line 3020: p_msg_level=>fnd_log.level_procedure);

3016: -- Debug info.
3017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3018: hz_utility_v2pub.debug(p_message=>'update_acct_sites_status (-)',
3019: p_prefix=>l_debug_prefix,
3020: p_msg_level=>fnd_log.level_procedure);
3021: END IF;
3022:
3023: END update_acct_sites_status;
3024:

Line 3073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3069: and party_site_id = p_party_site_id;
3070: BEGIN
3071:
3072: -- Debug info.
3073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3074: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (+)',
3075: p_prefix=>l_debug_prefix,
3076: p_msg_level=>fnd_log.level_procedure);
3077: END IF;

Line 3076: p_msg_level=>fnd_log.level_procedure);

3072: -- Debug info.
3073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3074: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (+)',
3075: p_prefix=>l_debug_prefix,
3076: p_msg_level=>fnd_log.level_procedure);
3077: END IF;
3078:
3079: -- check whether record has been updated by another user. If not, lock it.
3080: BEGIN

Line 3124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3120: RAISE FND_API.G_EXC_ERROR;
3121: END;
3122:
3123: -- Debug info.
3124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3125: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (-)',
3126: p_prefix=>l_debug_prefix,
3127: p_msg_level=>fnd_log.level_procedure);
3128: END IF;

Line 3127: p_msg_level=>fnd_log.level_procedure);

3123: -- Debug info.
3124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3125: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (-)',
3126: p_prefix=>l_debug_prefix,
3127: p_msg_level=>fnd_log.level_procedure);
3128: END IF;
3129:
3130: END inactivate_party_site_uses;
3131:

Line 3167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3163:
3164: BEGIN
3165:
3166: -- Debug info.
3167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3168: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
3169: p_prefix=>l_debug_prefix,
3170: p_msg_level=>fnd_log.level_procedure);
3171: END IF;

Line 3170: p_msg_level=>fnd_log.level_procedure);

3166: -- Debug info.
3167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3168: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
3169: p_prefix=>l_debug_prefix,
3170: p_msg_level=>fnd_log.level_procedure);
3171: END IF;
3172:
3173: UPDATE HZ_CUST_SITE_USES_ALL
3174: SET PRIMARY_FLAG = 'Y',

Line 3227: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3223:
3224: END IF;
3225:
3226: -- Debug info.
3227: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3228: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
3229: p_prefix=>l_debug_prefix,
3230: p_msg_level=>fnd_log.level_procedure);
3231: END IF;

Line 3230: p_msg_level=>fnd_log.level_procedure);

3226: -- Debug info.
3227: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3228: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
3229: p_prefix=>l_debug_prefix,
3230: p_msg_level=>fnd_log.level_procedure);
3231: END IF;
3232:
3233: END update_denorm_prim_flag;
3234:

Line 3297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3293:
3294: BEGIN
3295:
3296: -- Debug info.
3297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3298: hz_utility_v2pub.debug(p_message=> 'inactivate_account_site_uses (+)',
3299: p_prefix=>l_debug_prefix,
3300: p_msg_level=>fnd_log.level_procedure);
3301: END IF;

Line 3300: p_msg_level=>fnd_log.level_procedure);

3296: -- Debug info.
3297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3298: hz_utility_v2pub.debug(p_message=> 'inactivate_account_site_uses (+)',
3299: p_prefix=>l_debug_prefix,
3300: p_msg_level=>fnd_log.level_procedure);
3301: END IF;
3302:
3303: -- check whether record has been updated by another user. If not, lock it.
3304: BEGIN

Line 3337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3333: RAISE FND_API.G_EXC_ERROR;
3334: END;
3335:
3336: -- Debug info.
3337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3338: hz_utility_v2pub.debug(p_message=>'inactivate_account_site_uses (-)',
3339: p_prefix=>l_debug_prefix,
3340: p_msg_level=>fnd_log.level_procedure);
3341: END IF;

Line 3340: p_msg_level=>fnd_log.level_procedure);

3336: -- Debug info.
3337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3338: hz_utility_v2pub.debug(p_message=>'inactivate_account_site_uses (-)',
3339: p_prefix=>l_debug_prefix,
3340: p_msg_level=>fnd_log.level_procedure);
3341: END IF;
3342:
3343: END inactivate_account_site_uses;
3344:

Line 3389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3385:
3386: BEGIN
3387:
3388: -- Debug info.
3389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3390: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (+)',
3391: p_prefix=>l_debug_prefix,
3392: p_msg_level=>fnd_log.level_procedure);
3393: END IF;

Line 3392: p_msg_level=>fnd_log.level_procedure);

3388: -- Debug info.
3389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3390: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (+)',
3391: p_prefix=>l_debug_prefix,
3392: p_msg_level=>fnd_log.level_procedure);
3393: END IF;
3394:
3395: --
3396: --- Call update_acct_sites_status procedure

Line 3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3414: inactivate_account_site_uses(p_party_site_id,p_new_status,x_return_status);
3415: END IF;
3416: END IF;
3417: -- Debug info.
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;

Line 3421: p_msg_level=>fnd_log.level_procedure);

3417: -- Debug info.
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;
3423: EXCEPTION
3424: WHEN FND_API.G_EXC_ERROR THEN
3425: x_return_status := FND_API.G_RET_STS_ERROR;