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: if p_party_site_rec.orig_system is not null
504: and p_party_site_rec.orig_system <>fnd_api.g_miss_char

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

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

Line 591: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 661: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 867: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 919: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 960: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1020: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1101: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1124: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1131: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1186: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1336: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1359: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1366: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1742: p_msg_level=>fnd_log.level_procedure);

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

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

1854: p_count => x_msg_count,
1855: p_data => x_msg_data);
1856:
1857: -- Debug info.
1858: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1859: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1860: p_msg_data=>x_msg_data,
1861: p_msg_type=>'WARNING',
1862: p_msg_level=>fnd_log.level_exception);

Line 1862: p_msg_level=>fnd_log.level_exception);

1858: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1859: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1860: p_msg_data=>x_msg_data,
1861: p_msg_type=>'WARNING',
1862: p_msg_level=>fnd_log.level_exception);
1863: END IF;
1864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1865: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1866: p_prefix=>l_debug_prefix,

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

1860: p_msg_data=>x_msg_data,
1861: p_msg_type=>'WARNING',
1862: p_msg_level=>fnd_log.level_exception);
1863: END IF;
1864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1865: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1866: p_prefix=>l_debug_prefix,
1867: p_msg_level=>fnd_log.level_procedure);
1868: END IF;

Line 1867: p_msg_level=>fnd_log.level_procedure);

1863: END IF;
1864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1865: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1866: p_prefix=>l_debug_prefix,
1867: p_msg_level=>fnd_log.level_procedure);
1868: END IF;
1869:
1870: -- Check if API is called in debug mode. If yes, disable debug.
1871: --disable_debug;

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

1879: p_count => x_msg_count,
1880: p_data => x_msg_data);
1881:
1882: -- Debug info.
1883: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1885: p_msg_data=>x_msg_data,
1886: p_msg_type=>'ERROR',
1887: p_msg_level=>fnd_log.level_error);

Line 1887: p_msg_level=>fnd_log.level_error);

1883: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1885: p_msg_data=>x_msg_data,
1886: p_msg_type=>'ERROR',
1887: p_msg_level=>fnd_log.level_error);
1888: END IF;
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1891: p_prefix=>l_debug_prefix,

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

1885: p_msg_data=>x_msg_data,
1886: p_msg_type=>'ERROR',
1887: p_msg_level=>fnd_log.level_error);
1888: END IF;
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1891: p_prefix=>l_debug_prefix,
1892: p_msg_level=>fnd_log.level_procedure);
1893: END IF;

Line 1892: p_msg_level=>fnd_log.level_procedure);

1888: END IF;
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1891: p_prefix=>l_debug_prefix,
1892: p_msg_level=>fnd_log.level_procedure);
1893: END IF;
1894:
1895: -- Check if API is called in debug mode. If yes, disable debug.
1896: --disable_debug;

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

1903: p_count => x_msg_count,
1904: p_data => x_msg_data);
1905:
1906: -- Debug info.
1907: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1908: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1909: p_msg_data=>x_msg_data,
1910: p_msg_type=>'UNEXPECTED ERROR',
1911: p_msg_level=>fnd_log.level_error);

Line 1911: p_msg_level=>fnd_log.level_error);

1907: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1908: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1909: p_msg_data=>x_msg_data,
1910: p_msg_type=>'UNEXPECTED ERROR',
1911: p_msg_level=>fnd_log.level_error);
1912: END IF;
1913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1914: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1915: p_prefix=>l_debug_prefix,

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

1909: p_msg_data=>x_msg_data,
1910: p_msg_type=>'UNEXPECTED ERROR',
1911: p_msg_level=>fnd_log.level_error);
1912: END IF;
1913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1914: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1915: p_prefix=>l_debug_prefix,
1916: p_msg_level=>fnd_log.level_procedure);
1917: END IF;

Line 1916: p_msg_level=>fnd_log.level_procedure);

1912: END IF;
1913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1914: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1915: p_prefix=>l_debug_prefix,
1916: p_msg_level=>fnd_log.level_procedure);
1917: END IF;
1918:
1919: -- Check if API is called in debug mode. If yes, disable debug.
1920: --disable_debug;

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

1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932:
1933: -- Debug info.
1934: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1936: p_msg_data=>x_msg_data,
1937: p_msg_type=>'SQL ERROR',
1938: p_msg_level=>fnd_log.level_error);

Line 1938: p_msg_level=>fnd_log.level_error);

1934: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1936: p_msg_data=>x_msg_data,
1937: p_msg_type=>'SQL ERROR',
1938: p_msg_level=>fnd_log.level_error);
1939: END IF;
1940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1942: p_prefix=>l_debug_prefix,

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

1936: p_msg_data=>x_msg_data,
1937: p_msg_type=>'SQL ERROR',
1938: p_msg_level=>fnd_log.level_error);
1939: END IF;
1940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1942: p_prefix=>l_debug_prefix,
1943: p_msg_level=>fnd_log.level_procedure);
1944: END IF;

Line 1943: p_msg_level=>fnd_log.level_procedure);

1939: END IF;
1940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1942: p_prefix=>l_debug_prefix,
1943: p_msg_level=>fnd_log.level_procedure);
1944: END IF;
1945:
1946: -- Check if API is called in debug mode. If yes, disable debug.
1947: --disable_debug;

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

2008: -- Check if API is called in debug mode. If yes, enable debug.
2009: --enable_debug;
2010:
2011: -- Debug info.
2012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2013: hz_utility_v2pub.debug(p_message=>'update_party_site (+)',
2014: p_prefix=>l_debug_prefix,
2015: p_msg_level=>fnd_log.level_procedure);
2016: END IF;

Line 2015: p_msg_level=>fnd_log.level_procedure);

2011: -- Debug info.
2012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2013: hz_utility_v2pub.debug(p_message=>'update_party_site (+)',
2014: p_prefix=>l_debug_prefix,
2015: p_msg_level=>fnd_log.level_procedure);
2016: END IF;
2017:
2018: -- initialize message list if p_init_msg_list is set to TRUE.
2019: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2195: p_data => x_msg_data);
2196:
2197:
2198: -- Debug info.
2199: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2201: p_msg_data=>x_msg_data,
2202: p_msg_type=>'WARNING',
2203: p_msg_level=>fnd_log.level_exception);

Line 2203: p_msg_level=>fnd_log.level_exception);

2199: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2201: p_msg_data=>x_msg_data,
2202: p_msg_type=>'WARNING',
2203: p_msg_level=>fnd_log.level_exception);
2204: END IF;
2205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2206: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2207: p_prefix=>l_debug_prefix,

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

2201: p_msg_data=>x_msg_data,
2202: p_msg_type=>'WARNING',
2203: p_msg_level=>fnd_log.level_exception);
2204: END IF;
2205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2206: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2207: p_prefix=>l_debug_prefix,
2208: p_msg_level=>fnd_log.level_procedure);
2209: END IF;

Line 2208: p_msg_level=>fnd_log.level_procedure);

2204: END IF;
2205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2206: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2207: p_prefix=>l_debug_prefix,
2208: p_msg_level=>fnd_log.level_procedure);
2209: END IF;
2210:
2211: -- Check if API is called in debug mode. If yes, disable debug.
2212: --disable_debug;

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

2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222:
2223: -- Debug info.
2224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2226: p_msg_data=>x_msg_data,
2227: p_msg_type=>'ERROR',
2228: p_msg_level=>fnd_log.level_error);

Line 2228: p_msg_level=>fnd_log.level_error);

2224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2226: p_msg_data=>x_msg_data,
2227: p_msg_type=>'ERROR',
2228: p_msg_level=>fnd_log.level_error);
2229: END IF;
2230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2231: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2232: p_prefix=>l_debug_prefix,

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

2226: p_msg_data=>x_msg_data,
2227: p_msg_type=>'ERROR',
2228: p_msg_level=>fnd_log.level_error);
2229: END IF;
2230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2231: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2232: p_prefix=>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_procedure);
2234: END IF;

Line 2233: p_msg_level=>fnd_log.level_procedure);

2229: END IF;
2230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2231: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2232: p_prefix=>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_procedure);
2234: END IF;
2235:
2236:
2237: -- Check if API is called in debug mode. If yes, disable debug.

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

2245: p_count => x_msg_count,
2246: p_data => x_msg_data);
2247:
2248: -- Debug info.
2249: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2250: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2251: p_msg_data=>x_msg_data,
2252: p_msg_type=>'UNEXPECTED ERROR',
2253: p_msg_level=>fnd_log.level_error);

Line 2253: p_msg_level=>fnd_log.level_error);

2249: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2250: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2251: p_msg_data=>x_msg_data,
2252: p_msg_type=>'UNEXPECTED ERROR',
2253: p_msg_level=>fnd_log.level_error);
2254: END IF;
2255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2256: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2257: p_prefix=>l_debug_prefix,

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

2251: p_msg_data=>x_msg_data,
2252: p_msg_type=>'UNEXPECTED ERROR',
2253: p_msg_level=>fnd_log.level_error);
2254: END IF;
2255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2256: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2257: p_prefix=>l_debug_prefix,
2258: p_msg_level=>fnd_log.level_procedure);
2259: END IF;

Line 2258: p_msg_level=>fnd_log.level_procedure);

2254: END IF;
2255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2256: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2257: p_prefix=>l_debug_prefix,
2258: p_msg_level=>fnd_log.level_procedure);
2259: END IF;
2260:
2261: -- Check if API is called in debug mode. If yes, disable debug.
2262: --disable_debug;

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

2272: p_count => x_msg_count,
2273: p_data => x_msg_data);
2274:
2275: -- Debug info.
2276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2277: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2278: p_msg_data=>x_msg_data,
2279: p_msg_type=>'SQL ERROR',
2280: p_msg_level=>fnd_log.level_error);

Line 2280: p_msg_level=>fnd_log.level_error);

2276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2277: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2278: p_msg_data=>x_msg_data,
2279: p_msg_type=>'SQL ERROR',
2280: p_msg_level=>fnd_log.level_error);
2281: END IF;
2282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2284: p_prefix=>l_debug_prefix,

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

2278: p_msg_data=>x_msg_data,
2279: p_msg_type=>'SQL ERROR',
2280: p_msg_level=>fnd_log.level_error);
2281: END IF;
2282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2284: p_prefix=>l_debug_prefix,
2285: p_msg_level=>fnd_log.level_procedure);
2286: END IF;

Line 2285: p_msg_level=>fnd_log.level_procedure);

2281: END IF;
2282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2284: p_prefix=>l_debug_prefix,
2285: p_msg_level=>fnd_log.level_procedure);
2286: END IF;
2287:
2288: -- Check if API is called in debug mode. If yes, disable debug.
2289: --disable_debug;

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

2342: -- Check if API is called in debug mode. If yes, enable debug.
2343: --enable_debug;
2344:
2345: -- Debug info.
2346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2347: hz_utility_v2pub.debug(p_message=>'create_party_site_use (+)',
2348: p_prefix=>l_debug_prefix,
2349: p_msg_level=>fnd_log.level_procedure);
2350: END IF;

Line 2349: p_msg_level=>fnd_log.level_procedure);

2345: -- Debug info.
2346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2347: hz_utility_v2pub.debug(p_message=>'create_party_site_use (+)',
2348: p_prefix=>l_debug_prefix,
2349: p_msg_level=>fnd_log.level_procedure);
2350: END IF;
2351:
2352:
2353: -- initialize message list if p_init_msg_list is set to TRUE.

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

2386: p_count => x_msg_count,
2387: p_data => x_msg_data);
2388:
2389: -- Debug info.
2390: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2391: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2392: p_msg_data=>x_msg_data,
2393: p_msg_type=>'WARNING',
2394: p_msg_level=>fnd_log.level_exception);

Line 2394: p_msg_level=>fnd_log.level_exception);

2390: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2391: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2392: p_msg_data=>x_msg_data,
2393: p_msg_type=>'WARNING',
2394: p_msg_level=>fnd_log.level_exception);
2395: END IF;
2396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2397: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2398: p_prefix=>l_debug_prefix,

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

2392: p_msg_data=>x_msg_data,
2393: p_msg_type=>'WARNING',
2394: p_msg_level=>fnd_log.level_exception);
2395: END IF;
2396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2397: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2398: p_prefix=>l_debug_prefix,
2399: p_msg_level=>fnd_log.level_procedure);
2400: END IF;

Line 2399: p_msg_level=>fnd_log.level_procedure);

2395: END IF;
2396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2397: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2398: p_prefix=>l_debug_prefix,
2399: p_msg_level=>fnd_log.level_procedure);
2400: END IF;
2401:
2402: -- Check if API is called in debug mode. If yes, disable debug.
2403: --disable_debug;

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

2411: p_count => x_msg_count,
2412: p_data => x_msg_data);
2413:
2414: -- Debug info.
2415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2417: p_msg_data=>x_msg_data,
2418: p_msg_type=>'ERROR',
2419: p_msg_level=>fnd_log.level_error);

Line 2419: p_msg_level=>fnd_log.level_error);

2415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2417: p_msg_data=>x_msg_data,
2418: p_msg_type=>'ERROR',
2419: p_msg_level=>fnd_log.level_error);
2420: END IF;
2421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2422: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2423: p_prefix=>l_debug_prefix,

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

2417: p_msg_data=>x_msg_data,
2418: p_msg_type=>'ERROR',
2419: p_msg_level=>fnd_log.level_error);
2420: END IF;
2421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2422: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2423: p_prefix=>l_debug_prefix,
2424: p_msg_level=>fnd_log.level_procedure);
2425: END IF;

Line 2424: p_msg_level=>fnd_log.level_procedure);

2420: END IF;
2421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2422: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2423: p_prefix=>l_debug_prefix,
2424: p_msg_level=>fnd_log.level_procedure);
2425: END IF;
2426:
2427: -- Check if API is called in debug mode. If yes, disable debug.
2428: --disable_debug;

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

2435: p_count => x_msg_count,
2436: p_data => x_msg_data);
2437:
2438: -- Debug info.
2439: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2440: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2441: p_msg_data=>x_msg_data,
2442: p_msg_type=>'UNEXPECTED ERROR',
2443: p_msg_level=>fnd_log.level_error);

Line 2443: p_msg_level=>fnd_log.level_error);

2439: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2440: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2441: p_msg_data=>x_msg_data,
2442: p_msg_type=>'UNEXPECTED ERROR',
2443: p_msg_level=>fnd_log.level_error);
2444: END IF;
2445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2446: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2447: p_prefix=>l_debug_prefix,

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

2441: p_msg_data=>x_msg_data,
2442: p_msg_type=>'UNEXPECTED ERROR',
2443: p_msg_level=>fnd_log.level_error);
2444: END IF;
2445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2446: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2447: p_prefix=>l_debug_prefix,
2448: p_msg_level=>fnd_log.level_procedure);
2449: END IF;

Line 2448: p_msg_level=>fnd_log.level_procedure);

2444: END IF;
2445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2446: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2447: p_prefix=>l_debug_prefix,
2448: p_msg_level=>fnd_log.level_procedure);
2449: END IF;
2450:
2451: -- Check if API is called in debug mode. If yes, disable debug.
2452: --disable_debug;

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

2462: p_count => x_msg_count,
2463: p_data => x_msg_data);
2464:
2465: -- Debug info.
2466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'SQL ERROR',
2470: p_msg_level=>fnd_log.level_error);

Line 2470: p_msg_level=>fnd_log.level_error);

2466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'SQL ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471: END IF;
2472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2473: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2474: p_prefix=>l_debug_prefix,

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

2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'SQL ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471: END IF;
2472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2473: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2474: p_prefix=>l_debug_prefix,
2475: p_msg_level=>fnd_log.level_procedure);
2476: END IF;

Line 2475: p_msg_level=>fnd_log.level_procedure);

2471: END IF;
2472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2473: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2474: p_prefix=>l_debug_prefix,
2475: p_msg_level=>fnd_log.level_procedure);
2476: END IF;
2477:
2478: -- Check if API is called in debug mode. If yes, disable debug.
2479: --disable_debug;

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

2531: -- Check if API is called in debug mode. If yes, enable debug.
2532: --enable_debug;
2533:
2534: -- Debug info.
2535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2536: hz_utility_v2pub.debug(p_message=>'update_party_site_use (+)',
2537: p_prefix=>l_debug_prefix,
2538: p_msg_level=>fnd_log.level_procedure);
2539: END IF;

Line 2538: p_msg_level=>fnd_log.level_procedure);

2534: -- Debug info.
2535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2536: hz_utility_v2pub.debug(p_message=>'update_party_site_use (+)',
2537: p_prefix=>l_debug_prefix,
2538: p_msg_level=>fnd_log.level_procedure);
2539: END IF;
2540:
2541: -- initialize message list if p_init_msg_list is set to TRUE.
2542: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

2588: p_count => x_msg_count,
2589: p_data => x_msg_data);
2590:
2591: -- Debug info.
2592: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2594: p_msg_data=>x_msg_data,
2595: p_msg_type=>'WARNING',
2596: p_msg_level=>fnd_log.level_exception);

Line 2596: p_msg_level=>fnd_log.level_exception);

2592: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2594: p_msg_data=>x_msg_data,
2595: p_msg_type=>'WARNING',
2596: p_msg_level=>fnd_log.level_exception);
2597: END IF;
2598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=> 'update_party_site_use (-)',
2600: p_prefix=>l_debug_prefix,

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

2594: p_msg_data=>x_msg_data,
2595: p_msg_type=>'WARNING',
2596: p_msg_level=>fnd_log.level_exception);
2597: END IF;
2598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=> 'update_party_site_use (-)',
2600: p_prefix=>l_debug_prefix,
2601: p_msg_level=>fnd_log.level_procedure);
2602: END IF;

Line 2601: p_msg_level=>fnd_log.level_procedure);

2597: END IF;
2598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=> 'update_party_site_use (-)',
2600: p_prefix=>l_debug_prefix,
2601: p_msg_level=>fnd_log.level_procedure);
2602: END IF;
2603:
2604: -- Check if API is called in debug mode. If yes, disable debug.
2605: --disable_debug;

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

2613: p_count => x_msg_count,
2614: p_data => x_msg_data);
2615:
2616: -- Debug info.
2617: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2618: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2619: p_msg_data=>x_msg_data,
2620: p_msg_type=>'ERROR',
2621: p_msg_level=>fnd_log.level_error);

Line 2621: p_msg_level=>fnd_log.level_error);

2617: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2618: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2619: p_msg_data=>x_msg_data,
2620: p_msg_type=>'ERROR',
2621: p_msg_level=>fnd_log.level_error);
2622: END IF;
2623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2624: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2625: p_prefix=>l_debug_prefix,

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

2619: p_msg_data=>x_msg_data,
2620: p_msg_type=>'ERROR',
2621: p_msg_level=>fnd_log.level_error);
2622: END IF;
2623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2624: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2625: p_prefix=>l_debug_prefix,
2626: p_msg_level=>fnd_log.level_procedure);
2627: END IF;

Line 2626: p_msg_level=>fnd_log.level_procedure);

2622: END IF;
2623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2624: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2625: p_prefix=>l_debug_prefix,
2626: p_msg_level=>fnd_log.level_procedure);
2627: END IF;
2628:
2629: -- Check if API is called in debug mode. If yes, disable debug.
2630: --disable_debug;

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

2637: p_count => x_msg_count,
2638: p_data => x_msg_data);
2639:
2640: -- Debug info.
2641: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2643: p_msg_data=>x_msg_data,
2644: p_msg_type=>'UNEXPECTED ERROR',
2645: p_msg_level=>fnd_log.level_error);

Line 2645: p_msg_level=>fnd_log.level_error);

2641: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2643: p_msg_data=>x_msg_data,
2644: p_msg_type=>'UNEXPECTED ERROR',
2645: p_msg_level=>fnd_log.level_error);
2646: END IF;
2647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2648: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2649: p_prefix=>l_debug_prefix,

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

2643: p_msg_data=>x_msg_data,
2644: p_msg_type=>'UNEXPECTED ERROR',
2645: p_msg_level=>fnd_log.level_error);
2646: END IF;
2647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2648: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2649: p_prefix=>l_debug_prefix,
2650: p_msg_level=>fnd_log.level_procedure);
2651: END IF;

Line 2650: p_msg_level=>fnd_log.level_procedure);

2646: END IF;
2647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2648: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2649: p_prefix=>l_debug_prefix,
2650: p_msg_level=>fnd_log.level_procedure);
2651: END IF;
2652:
2653: -- Check if API is called in debug mode. If yes, disable debug.
2654: --disable_debug;

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

2664: p_count => x_msg_count,
2665: p_data => x_msg_data);
2666:
2667: -- Debug info.
2668: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2669: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2670: p_msg_data=>x_msg_data,
2671: p_msg_type=>'SQL ERROR',
2672: p_msg_level=>fnd_log.level_error);

Line 2672: p_msg_level=>fnd_log.level_error);

2668: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2669: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2670: p_msg_data=>x_msg_data,
2671: p_msg_type=>'SQL ERROR',
2672: p_msg_level=>fnd_log.level_error);
2673: END IF;
2674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2675: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2676: p_prefix=>l_debug_prefix,

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

2670: p_msg_data=>x_msg_data,
2671: p_msg_type=>'SQL ERROR',
2672: p_msg_level=>fnd_log.level_error);
2673: END IF;
2674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2675: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2676: p_prefix=>l_debug_prefix,
2677: p_msg_level=>fnd_log.level_procedure);
2678: END IF;

Line 2677: p_msg_level=>fnd_log.level_procedure);

2673: END IF;
2674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2675: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2676: p_prefix=>l_debug_prefix,
2677: p_msg_level=>fnd_log.level_procedure);
2678: END IF;
2679:
2680: -- Check if API is called in debug mode. If yes, disable debug.
2681: --disable_debug;

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

2974:
2975: BEGIN
2976:
2977: -- Debug info.
2978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2979: hz_utility_v2pub.debug(p_message=> 'update_acct_sites_status (+)',
2980: p_prefix=>l_debug_prefix,
2981: p_msg_level=>fnd_log.level_procedure);
2982: END IF;

Line 2981: p_msg_level=>fnd_log.level_procedure);

2977: -- Debug info.
2978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2979: hz_utility_v2pub.debug(p_message=> 'update_acct_sites_status (+)',
2980: p_prefix=>l_debug_prefix,
2981: p_msg_level=>fnd_log.level_procedure);
2982: END IF;
2983:
2984: -- check whether record has been updated by another user. If not, lock it.
2985: BEGIN

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

3006: RAISE FND_API.G_EXC_ERROR;
3007: END;
3008:
3009: -- Debug info.
3010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3011: hz_utility_v2pub.debug(p_message=>'update_acct_sites_status (-)',
3012: p_prefix=>l_debug_prefix,
3013: p_msg_level=>fnd_log.level_procedure);
3014: END IF;

Line 3013: p_msg_level=>fnd_log.level_procedure);

3009: -- Debug info.
3010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3011: hz_utility_v2pub.debug(p_message=>'update_acct_sites_status (-)',
3012: p_prefix=>l_debug_prefix,
3013: p_msg_level=>fnd_log.level_procedure);
3014: END IF;
3015:
3016: END update_acct_sites_status;
3017:

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

3062: and party_site_id = p_party_site_id;
3063: BEGIN
3064:
3065: -- Debug info.
3066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3067: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (+)',
3068: p_prefix=>l_debug_prefix,
3069: p_msg_level=>fnd_log.level_procedure);
3070: END IF;

Line 3069: p_msg_level=>fnd_log.level_procedure);

3065: -- Debug info.
3066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3067: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (+)',
3068: p_prefix=>l_debug_prefix,
3069: p_msg_level=>fnd_log.level_procedure);
3070: END IF;
3071:
3072: -- check whether record has been updated by another user. If not, lock it.
3073: BEGIN

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

3113: RAISE FND_API.G_EXC_ERROR;
3114: END;
3115:
3116: -- Debug info.
3117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3118: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (-)',
3119: p_prefix=>l_debug_prefix,
3120: p_msg_level=>fnd_log.level_procedure);
3121: END IF;

Line 3120: p_msg_level=>fnd_log.level_procedure);

3116: -- Debug info.
3117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3118: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (-)',
3119: p_prefix=>l_debug_prefix,
3120: p_msg_level=>fnd_log.level_procedure);
3121: END IF;
3122:
3123: END inactivate_party_site_uses;
3124:

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

3156:
3157: BEGIN
3158:
3159: -- Debug info.
3160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3161: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
3162: p_prefix=>l_debug_prefix,
3163: p_msg_level=>fnd_log.level_procedure);
3164: END IF;

Line 3163: p_msg_level=>fnd_log.level_procedure);

3159: -- Debug info.
3160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3161: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
3162: p_prefix=>l_debug_prefix,
3163: p_msg_level=>fnd_log.level_procedure);
3164: END IF;
3165:
3166: UPDATE HZ_CUST_SITE_USES_ALL
3167: SET PRIMARY_FLAG = 'Y',

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

3216:
3217: END IF;
3218:
3219: -- Debug info.
3220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3221: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
3222: p_prefix=>l_debug_prefix,
3223: p_msg_level=>fnd_log.level_procedure);
3224: END IF;

Line 3223: p_msg_level=>fnd_log.level_procedure);

3219: -- Debug info.
3220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3221: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
3222: p_prefix=>l_debug_prefix,
3223: p_msg_level=>fnd_log.level_procedure);
3224: END IF;
3225:
3226: END update_denorm_prim_flag;
3227:

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

3286:
3287: BEGIN
3288:
3289: -- Debug info.
3290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3291: hz_utility_v2pub.debug(p_message=> 'inactivate_account_site_uses (+)',
3292: p_prefix=>l_debug_prefix,
3293: p_msg_level=>fnd_log.level_procedure);
3294: END IF;

Line 3293: p_msg_level=>fnd_log.level_procedure);

3289: -- Debug info.
3290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3291: hz_utility_v2pub.debug(p_message=> 'inactivate_account_site_uses (+)',
3292: p_prefix=>l_debug_prefix,
3293: p_msg_level=>fnd_log.level_procedure);
3294: END IF;
3295:
3296: -- check whether record has been updated by another user. If not, lock it.
3297: BEGIN

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

3326: RAISE FND_API.G_EXC_ERROR;
3327: END;
3328:
3329: -- Debug info.
3330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3331: hz_utility_v2pub.debug(p_message=>'inactivate_account_site_uses (-)',
3332: p_prefix=>l_debug_prefix,
3333: p_msg_level=>fnd_log.level_procedure);
3334: END IF;

Line 3333: p_msg_level=>fnd_log.level_procedure);

3329: -- Debug info.
3330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3331: hz_utility_v2pub.debug(p_message=>'inactivate_account_site_uses (-)',
3332: p_prefix=>l_debug_prefix,
3333: p_msg_level=>fnd_log.level_procedure);
3334: END IF;
3335:
3336: END inactivate_account_site_uses;
3337:

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

3378:
3379: BEGIN
3380:
3381: -- Debug info.
3382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3383: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (+)',
3384: p_prefix=>l_debug_prefix,
3385: p_msg_level=>fnd_log.level_procedure);
3386: END IF;

Line 3385: p_msg_level=>fnd_log.level_procedure);

3381: -- Debug info.
3382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3383: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (+)',
3384: p_prefix=>l_debug_prefix,
3385: p_msg_level=>fnd_log.level_procedure);
3386: END IF;
3387:
3388: --
3389: --- Call update_acct_sites_status procedure

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

3407: inactivate_account_site_uses(p_party_site_id,p_new_status,x_return_status);
3408: END IF;
3409: END IF;
3410: -- Debug info.
3411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3412: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (-)',
3413: p_prefix=>l_debug_prefix,
3414: p_msg_level=>fnd_log.level_procedure);
3415: END IF;

Line 3414: p_msg_level=>fnd_log.level_procedure);

3410: -- Debug info.
3411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3412: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (-)',
3413: p_prefix=>l_debug_prefix,
3414: p_msg_level=>fnd_log.level_procedure);
3415: END IF;
3416: EXCEPTION
3417: WHEN FND_API.G_EXC_ERROR THEN
3418: x_return_status := FND_API.G_RET_STS_ERROR;