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_CUST_ACCOUNT_ROLE_V2PUB dependencies on FND_LOG

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

164:
165: BEGIN
166:
167: -- Debug info.
168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
169: hz_utility_v2pub.debug(p_message=>'do_create_cust_account_role (+)',
170: p_prefix=>l_debug_prefix,
171: p_msg_level=>fnd_log.level_procedure);
172: END IF;

Line 171: p_msg_level=>fnd_log.level_procedure);

167: -- Debug info.
168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
169: hz_utility_v2pub.debug(p_message=>'do_create_cust_account_role (+)',
170: p_prefix=>l_debug_prefix,
171: p_msg_level=>fnd_log.level_procedure);
172: END IF;
173:
174: -- Validate cust account role record
175: HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_account_role (

Line 215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

211: -- party site has been created in the same address
212: -- as customer account address.
213:
214: -- Debug info.
215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'Need to create party site for account role party id ',
217: p_prefix =>l_debug_prefix,
218: p_msg_level=>fnd_log.level_statement);
219: END IF;

Line 218: p_msg_level=>fnd_log.level_statement);

214: -- Debug info.
215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'Need to create party site for account role party id ',
217: p_prefix =>l_debug_prefix,
218: p_msg_level=>fnd_log.level_statement);
219: END IF;
220:
221: l_party_site_rec.party_id := p_cust_account_role_rec.party_id;
222: l_party_site_rec.location_id := l_location_id;

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

254: END;
255: END IF;
256: */
257: -- Debug info.
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (+)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;

Line 261: p_msg_level=>fnd_log.level_procedure);

257: -- Debug info.
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (+)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263:
264: -- Call table-handler.
265: HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (

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

304: );
305:
306:
307: -- Debug info.
308: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
309: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (-) ' ||
310: 'x_cust_account_role_id = ' || p_cust_account_role_rec.cust_account_role_id,
311: p_prefix=>l_debug_prefix,
312: p_msg_level=>fnd_log.level_procedure);

Line 312: p_msg_level=>fnd_log.level_procedure);

308: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
309: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (-) ' ||
310: 'x_cust_account_role_id = ' || p_cust_account_role_rec.cust_account_role_id,
311: p_prefix=>l_debug_prefix,
312: p_msg_level=>fnd_log.level_procedure);
313: END IF;
314:
315: if (p_cust_account_role_rec.orig_system_reference is not null and p_cust_account_role_rec.orig_system_reference<>fnd_api.g_miss_char ) then
316: if (p_cust_account_role_rec.orig_system is null OR p_cust_account_role_rec.orig_system = fnd_api.g_miss_char) then

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

338: end if;
339: x_cust_account_role_id := p_cust_account_role_rec.cust_account_role_id;
340: -- Debug info.
341:
342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
343: hz_utility_v2pub.debug(p_message=>'do_create_cust_account_role (-)',
344: p_prefix=>l_debug_prefix,
345: p_msg_level=>fnd_log.level_procedure);
346: END IF;

Line 345: p_msg_level=>fnd_log.level_procedure);

341:
342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
343: hz_utility_v2pub.debug(p_message=>'do_create_cust_account_role (-)',
344: p_prefix=>l_debug_prefix,
345: p_msg_level=>fnd_log.level_procedure);
346: END IF;
347:
348: END do_create_cust_account_role;
349:

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

389:
390: BEGIN
391:
392: -- Debug info.
393: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
394: hz_utility_v2pub.debug(p_message=>'do_update_cust_account_role (+)',
395: p_prefix=>l_debug_prefix,
396: p_msg_level=>fnd_log.level_procedure);
397: END IF;

Line 396: p_msg_level=>fnd_log.level_procedure);

392: -- Debug info.
393: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
394: hz_utility_v2pub.debug(p_message=>'do_update_cust_account_role (+)',
395: p_prefix=>l_debug_prefix,
396: p_msg_level=>fnd_log.level_procedure);
397: END IF;
398:
399: -- Lock record.
400: BEGIN

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

449: -- but we should not update existing osr, set it to null
450: end if;
451:
452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (+)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;

Line 456: p_msg_level=>fnd_log.level_procedure);

452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (+)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:
459: -- Call table-handler.
460: HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (

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

499: X_APPLICATION_ID => p_cust_account_role_rec.application_id
500: );
501:
502: -- Debug info.
503: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (-)',
505: p_prefix=>l_debug_prefix,
506: p_msg_level=>fnd_log.level_procedure);
507: END IF;

Line 506: p_msg_level=>fnd_log.level_procedure);

502: -- Debug info.
503: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (-)',
505: p_prefix=>l_debug_prefix,
506: p_msg_level=>fnd_log.level_procedure);
507: END IF;
508:
509: END do_update_cust_account_role;
510:

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

546:
547: BEGIN
548:
549: -- Debug info.
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'do_create_role_responsibility (+)',
552: p_prefix=>l_debug_prefix,
553: p_msg_level=>fnd_log.level_procedure);
554: END IF;

Line 553: p_msg_level=>fnd_log.level_procedure);

549: -- Debug info.
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'do_create_role_responsibility (+)',
552: p_prefix=>l_debug_prefix,
553: p_msg_level=>fnd_log.level_procedure);
554: END IF;
555:
556: -- Validate role responsibility record
557: HZ_ACCOUNT_VALIDATE_V2PUB.validate_role_responsibility (

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

564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566:
567: -- Debug info.
568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Insert_Row (+)',
570: p_prefix=>l_debug_prefix,
571: p_msg_level=>fnd_log.level_procedure);
572: END IF;

Line 571: p_msg_level=>fnd_log.level_procedure);

567: -- Debug info.
568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Insert_Row (+)',
570: p_prefix=>l_debug_prefix,
571: p_msg_level=>fnd_log.level_procedure);
572: END IF;
573:
574: -- Call table-handler.
575: HZ_ROLE_RESPONSIBILITY_PKG.Insert_Row (

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

601:
602: x_responsibility_id := p_role_responsibility_rec.responsibility_id;
603:
604: -- Debug info.
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Insert_Row (-) ' ||
607: 'x_responsibility_id = ' || x_responsibility_id,
608: p_prefix=>l_debug_prefix,
609: p_msg_level=>fnd_log.level_procedure);

Line 609: p_msg_level=>fnd_log.level_procedure);

605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Insert_Row (-) ' ||
607: 'x_responsibility_id = ' || x_responsibility_id,
608: p_prefix=>l_debug_prefix,
609: p_msg_level=>fnd_log.level_procedure);
610: END IF;
611:
612: -- Debug info.
613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

609: p_msg_level=>fnd_log.level_procedure);
610: END IF;
611:
612: -- Debug info.
613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
614: hz_utility_v2pub.debug(p_message=>'do_create_role_responsibility (-)',
615: p_prefix=>l_debug_prefix,
616: p_msg_level=>fnd_log.level_procedure);
617: END IF;

Line 616: p_msg_level=>fnd_log.level_procedure);

612: -- Debug info.
613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
614: hz_utility_v2pub.debug(p_message=>'do_create_role_responsibility (-)',
615: p_prefix=>l_debug_prefix,
616: p_msg_level=>fnd_log.level_procedure);
617: END IF;
618:
619: END do_create_role_responsibility;
620:

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_role_responsibility (+)',
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_role_responsibility (+)',
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;
667:
668: -- Lock record.
669: BEGIN

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

708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710:
711: -- Debug info.
712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Update_Row (+)',
714: p_prefix=>l_debug_prefix,
715: p_msg_level=>fnd_log.level_procedure);
716: END IF;

Line 715: p_msg_level=>fnd_log.level_procedure);

711: -- Debug info.
712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Update_Row (+)',
714: p_prefix=>l_debug_prefix,
715: p_msg_level=>fnd_log.level_procedure);
716: END IF;
717:
718: -- Call table-handler.
719: HZ_ROLE_RESPONSIBILITY_PKG.Update_Row (

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

744: X_APPLICATION_ID => p_role_responsibility_rec.application_id
745: );
746:
747: -- Debug info.
748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
749: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Update_Row (-)',
750: p_prefix=>l_debug_prefix,
751: p_msg_level=>fnd_log.level_procedure);
752: END IF;

Line 751: p_msg_level=>fnd_log.level_procedure);

747: -- Debug info.
748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
749: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Update_Row (-)',
750: p_prefix=>l_debug_prefix,
751: p_msg_level=>fnd_log.level_procedure);
752: END IF;
753:
754: -- Debug info.
755: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

751: p_msg_level=>fnd_log.level_procedure);
752: END IF;
753:
754: -- Debug info.
755: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
756: hz_utility_v2pub.debug(p_message=>'do_update_role_responsibility (-)',
757: p_prefix=>l_debug_prefix,
758: p_msg_level=>fnd_log.level_procedure);
759: END IF;

Line 758: p_msg_level=>fnd_log.level_procedure);

754: -- Debug info.
755: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
756: hz_utility_v2pub.debug(p_message=>'do_update_role_responsibility (-)',
757: p_prefix=>l_debug_prefix,
758: p_msg_level=>fnd_log.level_procedure);
759: END IF;
760:
761: END do_update_role_responsibility;
762:

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

817: -- Check if API is called in debug mode. If yes, enable debug.
818: --enable_debug;
819:
820: -- Debug info.
821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
822: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (+)',
823: p_prefix=>l_debug_prefix,
824: p_msg_level=>fnd_log.level_procedure);
825: END IF;

Line 824: p_msg_level=>fnd_log.level_procedure);

820: -- Debug info.
821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
822: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (+)',
823: p_prefix=>l_debug_prefix,
824: p_msg_level=>fnd_log.level_procedure);
825: END IF;
826:
827: -- Initialize message list if p_init_msg_list is set to TRUE.
828: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

859: p_count => x_msg_count,
860: p_data => x_msg_data );
861:
862: -- Debug info.
863: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
865: p_msg_data=>x_msg_data,
866: p_msg_type=>'WARNING',
867: p_msg_level=>fnd_log.level_exception);

Line 867: p_msg_level=>fnd_log.level_exception);

863: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
865: p_msg_data=>x_msg_data,
866: p_msg_type=>'WARNING',
867: p_msg_level=>fnd_log.level_exception);
868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
871: p_prefix=>l_debug_prefix,

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

865: p_msg_data=>x_msg_data,
866: p_msg_type=>'WARNING',
867: p_msg_level=>fnd_log.level_exception);
868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;

Line 872: p_msg_level=>fnd_log.level_procedure);

868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874:
875: -- Check if API is called in debug mode. If yes, disable debug.
876: --disable_debug;

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

883: FND_MSG_PUB.Count_And_Get(
884: p_encoded => FND_API.G_FALSE,
885: p_count => x_msg_count,
886: p_data => x_msg_data );
887: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
888: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
889: p_msg_data=>x_msg_data,
890: p_msg_type=>'ERROR',
891: p_msg_level=>fnd_log.level_error);

Line 891: p_msg_level=>fnd_log.level_error);

887: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
888: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
889: p_msg_data=>x_msg_data,
890: p_msg_type=>'ERROR',
891: p_msg_level=>fnd_log.level_error);
892: END IF;
893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
894: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
895: p_prefix=>l_debug_prefix,

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

889: p_msg_data=>x_msg_data,
890: p_msg_type=>'ERROR',
891: p_msg_level=>fnd_log.level_error);
892: END IF;
893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
894: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
895: p_prefix=>l_debug_prefix,
896: p_msg_level=>fnd_log.level_procedure);
897: END IF;

Line 896: p_msg_level=>fnd_log.level_procedure);

892: END IF;
893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
894: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
895: p_prefix=>l_debug_prefix,
896: p_msg_level=>fnd_log.level_procedure);
897: END IF;
898:
899: -- Check if API is called in debug mode. If yes, disable debug.
900: --disable_debug;

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

907: p_encoded => FND_API.G_FALSE,
908: p_count => x_msg_count,
909: p_data => x_msg_data );
910:
911: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
913: p_msg_data=>x_msg_data,
914: p_msg_type=>'UNEXPECTED ERROR',
915: p_msg_level=>fnd_log.level_error);

Line 915: p_msg_level=>fnd_log.level_error);

911: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
913: p_msg_data=>x_msg_data,
914: p_msg_type=>'UNEXPECTED ERROR',
915: p_msg_level=>fnd_log.level_error);
916: END IF;
917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
918: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
919: p_prefix=>l_debug_prefix,

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

913: p_msg_data=>x_msg_data,
914: p_msg_type=>'UNEXPECTED ERROR',
915: p_msg_level=>fnd_log.level_error);
916: END IF;
917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
918: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
919: p_prefix=>l_debug_prefix,
920: p_msg_level=>fnd_log.level_procedure);
921: END IF;

Line 920: p_msg_level=>fnd_log.level_procedure);

916: END IF;
917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
918: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
919: p_prefix=>l_debug_prefix,
920: p_msg_level=>fnd_log.level_procedure);
921: END IF;
922:
923:
924: -- Check if API is called in debug mode. If yes, disable debug.

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

935: FND_MSG_PUB.Count_And_Get(
936: p_encoded => FND_API.G_FALSE,
937: p_count => x_msg_count,
938: p_data => x_msg_data );
939: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
940: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
941: p_msg_data=>x_msg_data,
942: p_msg_type=>'SQL ERROR',
943: p_msg_level=>fnd_log.level_error);

Line 943: p_msg_level=>fnd_log.level_error);

939: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
940: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
941: p_msg_data=>x_msg_data,
942: p_msg_type=>'SQL ERROR',
943: p_msg_level=>fnd_log.level_error);
944: END IF;
945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
946: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
947: p_prefix=>l_debug_prefix,

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

941: p_msg_data=>x_msg_data,
942: p_msg_type=>'SQL ERROR',
943: p_msg_level=>fnd_log.level_error);
944: END IF;
945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
946: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
947: p_prefix=>l_debug_prefix,
948: p_msg_level=>fnd_log.level_procedure);
949: END IF;

Line 948: p_msg_level=>fnd_log.level_procedure);

944: END IF;
945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
946: hz_utility_v2pub.debug(p_message=>'create_cust_account_role (-)',
947: p_prefix=>l_debug_prefix,
948: p_msg_level=>fnd_log.level_procedure);
949: END IF;
950:
951: -- Check if API is called in debug mode. If yes, disable debug.
952: --disable_debug;

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

1006: -- Check if API is called in debug mode. If yes, enable debug.
1007: --enable_debug;
1008:
1009: -- Debug info.
1010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1011: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (+)',
1012: p_prefix=>l_debug_prefix,
1013: p_msg_level=>fnd_log.level_procedure);
1014: END IF;

Line 1013: p_msg_level=>fnd_log.level_procedure);

1009: -- Debug info.
1010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1011: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (+)',
1012: p_prefix=>l_debug_prefix,
1013: p_msg_level=>fnd_log.level_procedure);
1014: END IF;
1015:
1016: -- Initialize message list if p_init_msg_list is set to TRUE.
1017: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1075: FND_MSG_PUB.Count_And_Get(
1076: p_encoded => FND_API.G_FALSE,
1077: p_count => x_msg_count,
1078: p_data => x_msg_data );
1079: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1081: p_msg_data=>x_msg_data,
1082: p_msg_type=>'WARNING',
1083: p_msg_level=>fnd_log.level_exception);

Line 1083: p_msg_level=>fnd_log.level_exception);

1079: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1081: p_msg_data=>x_msg_data,
1082: p_msg_type=>'WARNING',
1083: p_msg_level=>fnd_log.level_exception);
1084: END IF;
1085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1086: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1087: p_prefix=>l_debug_prefix,

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

1081: p_msg_data=>x_msg_data,
1082: p_msg_type=>'WARNING',
1083: p_msg_level=>fnd_log.level_exception);
1084: END IF;
1085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1086: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1087: p_prefix=>l_debug_prefix,
1088: p_msg_level=>fnd_log.level_procedure);
1089: END IF;

Line 1088: p_msg_level=>fnd_log.level_procedure);

1084: END IF;
1085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1086: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1087: p_prefix=>l_debug_prefix,
1088: p_msg_level=>fnd_log.level_procedure);
1089: END IF;
1090:
1091: -- Check if API is called in debug mode. If yes, disable debug.
1092: --disable_debug;

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

1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data );
1103:
1104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1106: p_msg_data=>x_msg_data,
1107: p_msg_type=>'ERROR',
1108: p_msg_level=>fnd_log.level_error);

Line 1108: p_msg_level=>fnd_log.level_error);

1104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1106: p_msg_data=>x_msg_data,
1107: p_msg_type=>'ERROR',
1108: p_msg_level=>fnd_log.level_error);
1109: END IF;
1110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1111: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1112: p_prefix=>l_debug_prefix,

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

1106: p_msg_data=>x_msg_data,
1107: p_msg_type=>'ERROR',
1108: p_msg_level=>fnd_log.level_error);
1109: END IF;
1110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1111: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1112: p_prefix=>l_debug_prefix,
1113: p_msg_level=>fnd_log.level_procedure);
1114: END IF;

Line 1113: p_msg_level=>fnd_log.level_procedure);

1109: END IF;
1110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1111: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1112: p_prefix=>l_debug_prefix,
1113: p_msg_level=>fnd_log.level_procedure);
1114: END IF;
1115:
1116: -- Check if API is called in debug mode. If yes, disable debug.
1117: --disable_debug;

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

1123: FND_MSG_PUB.Count_And_Get(
1124: p_encoded => FND_API.G_FALSE,
1125: p_count => x_msg_count,
1126: p_data => x_msg_data );
1127: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1128: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1129: p_msg_data=>x_msg_data,
1130: p_msg_type=>'UNEXPECTED ERROR',
1131: p_msg_level=>fnd_log.level_error);

Line 1131: p_msg_level=>fnd_log.level_error);

1127: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1128: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1129: p_msg_data=>x_msg_data,
1130: p_msg_type=>'UNEXPECTED ERROR',
1131: p_msg_level=>fnd_log.level_error);
1132: END IF;
1133: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1134: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1135: p_prefix=>l_debug_prefix,

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

1129: p_msg_data=>x_msg_data,
1130: p_msg_type=>'UNEXPECTED ERROR',
1131: p_msg_level=>fnd_log.level_error);
1132: END IF;
1133: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1134: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1135: p_prefix=>l_debug_prefix,
1136: p_msg_level=>fnd_log.level_procedure);
1137: END IF;

Line 1136: p_msg_level=>fnd_log.level_procedure);

1132: END IF;
1133: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1134: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1135: p_prefix=>l_debug_prefix,
1136: p_msg_level=>fnd_log.level_procedure);
1137: END IF;
1138:
1139: -- Check if API is called in debug mode. If yes, disable debug.
1140: --disable_debug;

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

1151: p_encoded => FND_API.G_FALSE,
1152: p_count => x_msg_count,
1153: p_data => x_msg_data );
1154:
1155: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1157: p_msg_data=>x_msg_data,
1158: p_msg_type=>'SQL ERROR',
1159: p_msg_level=>fnd_log.level_error);

Line 1159: p_msg_level=>fnd_log.level_error);

1155: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1157: p_msg_data=>x_msg_data,
1158: p_msg_type=>'SQL ERROR',
1159: p_msg_level=>fnd_log.level_error);
1160: END IF;
1161: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1162: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1163: p_prefix=>l_debug_prefix,

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

1157: p_msg_data=>x_msg_data,
1158: p_msg_type=>'SQL ERROR',
1159: p_msg_level=>fnd_log.level_error);
1160: END IF;
1161: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1162: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1163: p_prefix=>l_debug_prefix,
1164: p_msg_level=>fnd_log.level_procedure);
1165: END IF;

Line 1164: p_msg_level=>fnd_log.level_procedure);

1160: END IF;
1161: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1162: hz_utility_v2pub.debug(p_message=>'update_cust_account_role (-)',
1163: p_prefix=>l_debug_prefix,
1164: p_msg_level=>fnd_log.level_procedure);
1165: END IF;
1166:
1167: -- Check if API is called in debug mode. If yes, disable debug.
1168: --disable_debug;

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

1215: -- Check if API is called in debug mode. If yes, enable debug.
1216: --enable_debug;
1217:
1218: -- Debug info.
1219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1220: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (+)',
1221: p_prefix=>l_debug_prefix,
1222: p_msg_level=>fnd_log.level_procedure);
1223: END IF;

Line 1222: p_msg_level=>fnd_log.level_procedure);

1218: -- Debug info.
1219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1220: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (+)',
1221: p_prefix=>l_debug_prefix,
1222: p_msg_level=>fnd_log.level_procedure);
1223: END IF;
1224:
1225:
1226: -- Initialize message list if p_init_msg_list is set to TRUE.

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

1242:
1243: x_cust_account_role_rec.cust_account_role_id := p_cust_account_role_id;
1244:
1245: -- Debug info.
1246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1247: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (+)',
1248: p_prefix=>l_debug_prefix,
1249: p_msg_level=>fnd_log.level_procedure);
1250: END IF;

Line 1249: p_msg_level=>fnd_log.level_procedure);

1245: -- Debug info.
1246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1247: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (+)',
1248: p_prefix=>l_debug_prefix,
1249: p_msg_level=>fnd_log.level_procedure);
1250: END IF;
1251:
1252:
1253: -- Call table-handler.

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

1291: X_APPLICATION_ID => x_cust_account_role_rec.application_id
1292: );
1293:
1294: -- Debug info.
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (-)',
1297: p_prefix=>l_debug_prefix,
1298: p_msg_level=>fnd_log.level_procedure);
1299: END IF;

Line 1298: p_msg_level=>fnd_log.level_procedure);

1294: -- Debug info.
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (-)',
1297: p_prefix=>l_debug_prefix,
1298: p_msg_level=>fnd_log.level_procedure);
1299: END IF;
1300:
1301:
1302: -- Standard call to get message count and if count is 1, get message info.

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

1305: p_count => x_msg_count,
1306: p_data => x_msg_data );
1307:
1308: -- Debug info.
1309: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1311: p_msg_data=>x_msg_data,
1312: p_msg_type=>'WARNING',
1313: p_msg_level=>fnd_log.level_exception);

Line 1313: p_msg_level=>fnd_log.level_exception);

1309: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1311: p_msg_data=>x_msg_data,
1312: p_msg_type=>'WARNING',
1313: p_msg_level=>fnd_log.level_exception);
1314: END IF;
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1317: p_prefix=>l_debug_prefix,

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

1311: p_msg_data=>x_msg_data,
1312: p_msg_type=>'WARNING',
1313: p_msg_level=>fnd_log.level_exception);
1314: END IF;
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1317: p_prefix=>l_debug_prefix,
1318: p_msg_level=>fnd_log.level_procedure);
1319: END IF;

Line 1318: p_msg_level=>fnd_log.level_procedure);

1314: END IF;
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1317: p_prefix=>l_debug_prefix,
1318: p_msg_level=>fnd_log.level_procedure);
1319: END IF;
1320:
1321: -- Check if API is called in debug mode. If yes, disable debug.
1322: --disable_debug;

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

1330: p_count => x_msg_count,
1331: p_data => x_msg_data );
1332:
1333: -- Debug info.
1334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1335: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1336: p_msg_data=>x_msg_data,
1337: p_msg_type=>'ERROR',
1338: p_msg_level=>fnd_log.level_error);

Line 1338: p_msg_level=>fnd_log.level_error);

1334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1335: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1336: p_msg_data=>x_msg_data,
1337: p_msg_type=>'ERROR',
1338: p_msg_level=>fnd_log.level_error);
1339: END IF;
1340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1341: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1342: p_prefix=>l_debug_prefix,

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

1336: p_msg_data=>x_msg_data,
1337: p_msg_type=>'ERROR',
1338: p_msg_level=>fnd_log.level_error);
1339: END IF;
1340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1341: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1342: p_prefix=>l_debug_prefix,
1343: p_msg_level=>fnd_log.level_procedure);
1344: END IF;

Line 1343: p_msg_level=>fnd_log.level_procedure);

1339: END IF;
1340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1341: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1342: p_prefix=>l_debug_prefix,
1343: p_msg_level=>fnd_log.level_procedure);
1344: END IF;
1345:
1346: -- Check if API is called in debug mode. If yes, disable debug.
1347: --disable_debug;

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

1354: p_count => x_msg_count,
1355: p_data => x_msg_data );
1356:
1357: -- Debug info.
1358: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1360: p_msg_data=>x_msg_data,
1361: p_msg_type=>'UNEXPECTED ERROR',
1362: p_msg_level=>fnd_log.level_error);

Line 1362: p_msg_level=>fnd_log.level_error);

1358: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1360: p_msg_data=>x_msg_data,
1361: p_msg_type=>'UNEXPECTED ERROR',
1362: p_msg_level=>fnd_log.level_error);
1363: END IF;
1364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1366: p_prefix=>l_debug_prefix,

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

1360: p_msg_data=>x_msg_data,
1361: p_msg_type=>'UNEXPECTED ERROR',
1362: p_msg_level=>fnd_log.level_error);
1363: END IF;
1364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1366: p_prefix=>l_debug_prefix,
1367: p_msg_level=>fnd_log.level_procedure);
1368: END IF;

Line 1367: p_msg_level=>fnd_log.level_procedure);

1363: END IF;
1364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1366: p_prefix=>l_debug_prefix,
1367: p_msg_level=>fnd_log.level_procedure);
1368: END IF;
1369:
1370: -- Check if API is called in debug mode. If yes, disable debug.
1371: --disable_debug;

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

1382: p_count => x_msg_count,
1383: p_data => x_msg_data );
1384:
1385: -- Debug info.
1386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'SQL ERROR',
1390: p_msg_level=>fnd_log.level_error);

Line 1390: p_msg_level=>fnd_log.level_error);

1386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'SQL ERROR',
1390: p_msg_level=>fnd_log.level_error);
1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1394: p_prefix=>l_debug_prefix,

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

1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'SQL ERROR',
1390: p_msg_level=>fnd_log.level_error);
1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1394: p_prefix=>l_debug_prefix,
1395: p_msg_level=>fnd_log.level_procedure);
1396: END IF;

Line 1395: p_msg_level=>fnd_log.level_procedure);

1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(p_message=>'get_cust_account_role_rec (-)',
1394: p_prefix=>l_debug_prefix,
1395: p_msg_level=>fnd_log.level_procedure);
1396: END IF;
1397:
1398: -- Check if API is called in debug mode. If yes, disable debug.
1399: --disable_debug;

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

1451: -- Check if API is called in debug mode. If yes, enable debug.
1452: --enable_debug;
1453:
1454: -- Debug info.
1455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1456: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (+)',
1457: p_prefix=>l_debug_prefix,
1458: p_msg_level=>fnd_log.level_procedure);
1459: END IF;

Line 1458: p_msg_level=>fnd_log.level_procedure);

1454: -- Debug info.
1455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1456: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (+)',
1457: p_prefix=>l_debug_prefix,
1458: p_msg_level=>fnd_log.level_procedure);
1459: END IF;
1460:
1461: -- Initialize message list if p_init_msg_list is set to TRUE.
1462: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1492: p_count => x_msg_count,
1493: p_data => x_msg_data );
1494:
1495: -- Debug info.
1496: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1497: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1498: p_msg_data=>x_msg_data,
1499: p_msg_type=>'WARNING',
1500: p_msg_level=>fnd_log.level_exception);

Line 1500: p_msg_level=>fnd_log.level_exception);

1496: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1497: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1498: p_msg_data=>x_msg_data,
1499: p_msg_type=>'WARNING',
1500: p_msg_level=>fnd_log.level_exception);
1501: END IF;
1502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1503: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1504: p_prefix=>l_debug_prefix,

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

1498: p_msg_data=>x_msg_data,
1499: p_msg_type=>'WARNING',
1500: p_msg_level=>fnd_log.level_exception);
1501: END IF;
1502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1503: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1504: p_prefix=>l_debug_prefix,
1505: p_msg_level=>fnd_log.level_procedure);
1506: END IF;

Line 1505: p_msg_level=>fnd_log.level_procedure);

1501: END IF;
1502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1503: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1504: p_prefix=>l_debug_prefix,
1505: p_msg_level=>fnd_log.level_procedure);
1506: END IF;
1507:
1508: -- Check if API is called in debug mode. If yes, disable debug.
1509: --disable_debug;

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

1518: p_count => x_msg_count,
1519: p_data => x_msg_data );
1520:
1521: -- Debug info.
1522: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1523: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1524: p_msg_data=>x_msg_data,
1525: p_msg_type=>'ERROR',
1526: p_msg_level=>fnd_log.level_error);

Line 1526: p_msg_level=>fnd_log.level_error);

1522: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1523: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1524: p_msg_data=>x_msg_data,
1525: p_msg_type=>'ERROR',
1526: p_msg_level=>fnd_log.level_error);
1527: END IF;
1528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1529: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1530: p_prefix=>l_debug_prefix,

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

1524: p_msg_data=>x_msg_data,
1525: p_msg_type=>'ERROR',
1526: p_msg_level=>fnd_log.level_error);
1527: END IF;
1528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1529: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1530: p_prefix=>l_debug_prefix,
1531: p_msg_level=>fnd_log.level_procedure);
1532: END IF;

Line 1531: p_msg_level=>fnd_log.level_procedure);

1527: END IF;
1528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1529: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1530: p_prefix=>l_debug_prefix,
1531: p_msg_level=>fnd_log.level_procedure);
1532: END IF;
1533:
1534: -- Check if API is called in debug mode. If yes, disable debug.
1535: --disable_debug;

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

1543: p_count => x_msg_count,
1544: p_data => x_msg_data );
1545:
1546: -- Debug info.
1547: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1548: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1549: p_msg_data=>x_msg_data,
1550: p_msg_type=>'UNEXPECTED ERROR',
1551: p_msg_level=>fnd_log.level_error);

Line 1551: p_msg_level=>fnd_log.level_error);

1547: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1548: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1549: p_msg_data=>x_msg_data,
1550: p_msg_type=>'UNEXPECTED ERROR',
1551: p_msg_level=>fnd_log.level_error);
1552: END IF;
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1555: p_prefix=>l_debug_prefix,

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

1549: p_msg_data=>x_msg_data,
1550: p_msg_type=>'UNEXPECTED ERROR',
1551: p_msg_level=>fnd_log.level_error);
1552: END IF;
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;

Line 1556: p_msg_level=>fnd_log.level_procedure);

1552: END IF;
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;
1558:
1559: -- Check if API is called in debug mode. If yes, disable debug.
1560: --disable_debug;

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

1572: p_count => x_msg_count,
1573: p_data => x_msg_data );
1574:
1575: -- Debug info.
1576: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1577: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1578: p_msg_data=>x_msg_data,
1579: p_msg_type=>'SQL ERROR',
1580: p_msg_level=>fnd_log.level_error);

Line 1580: p_msg_level=>fnd_log.level_error);

1576: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1577: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1578: p_msg_data=>x_msg_data,
1579: p_msg_type=>'SQL ERROR',
1580: p_msg_level=>fnd_log.level_error);
1581: END IF;
1582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1583: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1584: p_prefix=>l_debug_prefix,

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

1578: p_msg_data=>x_msg_data,
1579: p_msg_type=>'SQL ERROR',
1580: p_msg_level=>fnd_log.level_error);
1581: END IF;
1582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1583: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1584: p_prefix=>l_debug_prefix,
1585: p_msg_level=>fnd_log.level_procedure);
1586: END IF;

Line 1585: p_msg_level=>fnd_log.level_procedure);

1581: END IF;
1582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1583: hz_utility_v2pub.debug(p_message=>'create_role_responsibility (-)',
1584: p_prefix=>l_debug_prefix,
1585: p_msg_level=>fnd_log.level_procedure);
1586: END IF;
1587:
1588: -- Check if API is called in debug mode. If yes, disable debug.
1589: --disable_debug;

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

1643: -- Check if API is called in debug mode. If yes, enable debug.
1644: --enable_debug;
1645:
1646: -- Debug info.
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (+)',
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;

Line 1650: p_msg_level=>fnd_log.level_procedure);

1646: -- Debug info.
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (+)',
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;
1652:
1653: -- Initialize message list if p_init_msg_list is set to TRUE.
1654: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1698: p_count => x_msg_count,
1699: p_data => x_msg_data );
1700:
1701: -- Debug info.
1702: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1704: p_msg_data=>x_msg_data,
1705: p_msg_type=>'WARNING',
1706: p_msg_level=>fnd_log.level_exception);

Line 1706: p_msg_level=>fnd_log.level_exception);

1702: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1704: p_msg_data=>x_msg_data,
1705: p_msg_type=>'WARNING',
1706: p_msg_level=>fnd_log.level_exception);
1707: END IF;
1708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1710: p_prefix=>l_debug_prefix,

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

1704: p_msg_data=>x_msg_data,
1705: p_msg_type=>'WARNING',
1706: p_msg_level=>fnd_log.level_exception);
1707: END IF;
1708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1710: p_prefix=>l_debug_prefix,
1711: p_msg_level=>fnd_log.level_procedure);
1712: END IF;

Line 1711: p_msg_level=>fnd_log.level_procedure);

1707: END IF;
1708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1710: p_prefix=>l_debug_prefix,
1711: p_msg_level=>fnd_log.level_procedure);
1712: END IF;
1713:
1714: -- Check if API is called in debug mode. If yes, disable debug.
1715: --disable_debug;

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

1724: p_count => x_msg_count,
1725: p_data => x_msg_data );
1726:
1727: -- Debug info.
1728: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1729: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1730: p_msg_data=>x_msg_data,
1731: p_msg_type=>'ERROR',
1732: p_msg_level=>fnd_log.level_error);

Line 1732: p_msg_level=>fnd_log.level_error);

1728: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1729: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1730: p_msg_data=>x_msg_data,
1731: p_msg_type=>'ERROR',
1732: p_msg_level=>fnd_log.level_error);
1733: END IF;
1734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1735: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1736: p_prefix=>l_debug_prefix,

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

1730: p_msg_data=>x_msg_data,
1731: p_msg_type=>'ERROR',
1732: p_msg_level=>fnd_log.level_error);
1733: END IF;
1734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1735: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1736: p_prefix=>l_debug_prefix,
1737: p_msg_level=>fnd_log.level_procedure);
1738: END IF;

Line 1737: p_msg_level=>fnd_log.level_procedure);

1733: END IF;
1734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1735: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1736: p_prefix=>l_debug_prefix,
1737: p_msg_level=>fnd_log.level_procedure);
1738: END IF;
1739:
1740: -- Check if API is called in debug mode. If yes, disable debug.
1741: --disable_debug;

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

1749: p_count => x_msg_count,
1750: p_data => x_msg_data );
1751:
1752: -- Debug info.
1753: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1754: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1755: p_msg_data=>x_msg_data,
1756: p_msg_type=>'UNEXPECTED ERROR',
1757: p_msg_level=>fnd_log.level_error);

Line 1757: p_msg_level=>fnd_log.level_error);

1753: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1754: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1755: p_msg_data=>x_msg_data,
1756: p_msg_type=>'UNEXPECTED ERROR',
1757: p_msg_level=>fnd_log.level_error);
1758: END IF;
1759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1761: p_prefix=>l_debug_prefix,

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

1755: p_msg_data=>x_msg_data,
1756: p_msg_type=>'UNEXPECTED ERROR',
1757: p_msg_level=>fnd_log.level_error);
1758: END IF;
1759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1761: p_prefix=>l_debug_prefix,
1762: p_msg_level=>fnd_log.level_procedure);
1763: END IF;

Line 1762: p_msg_level=>fnd_log.level_procedure);

1758: END IF;
1759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1761: p_prefix=>l_debug_prefix,
1762: p_msg_level=>fnd_log.level_procedure);
1763: END IF;
1764:
1765: -- Check if API is called in debug mode. If yes, disable debug.
1766: --disable_debug;

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

1778: p_count => x_msg_count,
1779: p_data => x_msg_data );
1780:
1781: -- Debug info.
1782: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1784: p_msg_data=>x_msg_data,
1785: p_msg_type=>'SQL ERROR',
1786: p_msg_level=>fnd_log.level_error);

Line 1786: p_msg_level=>fnd_log.level_error);

1782: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1784: p_msg_data=>x_msg_data,
1785: p_msg_type=>'SQL ERROR',
1786: p_msg_level=>fnd_log.level_error);
1787: END IF;
1788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1789: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1790: p_prefix=>l_debug_prefix,

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

1784: p_msg_data=>x_msg_data,
1785: p_msg_type=>'SQL ERROR',
1786: p_msg_level=>fnd_log.level_error);
1787: END IF;
1788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1789: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1790: p_prefix=>l_debug_prefix,
1791: p_msg_level=>fnd_log.level_procedure);
1792: END IF;

Line 1791: p_msg_level=>fnd_log.level_procedure);

1787: END IF;
1788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1789: hz_utility_v2pub.debug(p_message=>'update_role_responsibility (-)',
1790: p_prefix=>l_debug_prefix,
1791: p_msg_level=>fnd_log.level_procedure);
1792: END IF;
1793:
1794: -- Check if API is called in debug mode. If yes, disable debug.
1795: --disable_debug;

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

1842: -- Check if API is called in debug mode. If yes, enable debug.
1843: --enable_debug;
1844:
1845: -- Debug info.
1846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1847: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (+)',
1848: p_prefix=>l_debug_prefix,
1849: p_msg_level=>fnd_log.level_procedure);
1850: END IF;

Line 1849: p_msg_level=>fnd_log.level_procedure);

1845: -- Debug info.
1846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1847: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (+)',
1848: p_prefix=>l_debug_prefix,
1849: p_msg_level=>fnd_log.level_procedure);
1850: END IF;
1851:
1852: -- Initialize message list if p_init_msg_list is set to TRUE.
1853: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1868:
1869: x_role_responsibility_rec.responsibility_id := p_responsibility_id;
1870:
1871: -- Debug info.
1872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Select_Row (+)',
1874: p_prefix=>l_debug_prefix,
1875: p_msg_level=>fnd_log.level_procedure);
1876: END IF;

Line 1875: p_msg_level=>fnd_log.level_procedure);

1871: -- Debug info.
1872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Select_Row (+)',
1874: p_prefix=>l_debug_prefix,
1875: p_msg_level=>fnd_log.level_procedure);
1876: END IF;
1877:
1878: -- Call table-handler.
1879: HZ_ROLE_RESPONSIBILITY_PKG.Select_Row (

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

1902: X_APPLICATION_ID => x_role_responsibility_rec.application_id
1903: );
1904:
1905: -- Debug info.
1906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1907: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Select_Row (-)',
1908: p_prefix=>l_debug_prefix,
1909: p_msg_level=>fnd_log.level_procedure);
1910: END IF;

Line 1909: p_msg_level=>fnd_log.level_procedure);

1905: -- Debug info.
1906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1907: hz_utility_v2pub.debug(p_message=>'HZ_ROLE_RESPONSIBILITY_PKG.Select_Row (-)',
1908: p_prefix=>l_debug_prefix,
1909: p_msg_level=>fnd_log.level_procedure);
1910: END IF;
1911:
1912: -- Standard call to get message count and if count is 1, get message info.
1913: FND_MSG_PUB.Count_And_Get(

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

1915: p_count => x_msg_count,
1916: p_data => x_msg_data );
1917:
1918: -- Debug info.
1919: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1921: p_msg_data=>x_msg_data,
1922: p_msg_type=>'WARNING',
1923: p_msg_level=>fnd_log.level_exception);

Line 1923: p_msg_level=>fnd_log.level_exception);

1919: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1921: p_msg_data=>x_msg_data,
1922: p_msg_type=>'WARNING',
1923: p_msg_level=>fnd_log.level_exception);
1924: END IF;
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
1927: p_prefix=>l_debug_prefix,

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

1921: p_msg_data=>x_msg_data,
1922: p_msg_type=>'WARNING',
1923: p_msg_level=>fnd_log.level_exception);
1924: END IF;
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
1927: p_prefix=>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_procedure);
1929: END IF;

Line 1928: p_msg_level=>fnd_log.level_procedure);

1924: END IF;
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
1927: p_prefix=>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_procedure);
1929: END IF;
1930:
1931: -- Check if API is called in debug mode. If yes, disable debug.
1932: --disable_debug;

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

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

Line 1948: p_msg_level=>fnd_log.level_error);

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

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

1946: p_msg_data=>x_msg_data,
1947: p_msg_type=>'ERROR',
1948: p_msg_level=>fnd_log.level_error);
1949: END IF;
1950: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1951: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
1952: p_prefix=>l_debug_prefix,
1953: p_msg_level=>fnd_log.level_procedure);
1954: END IF;

Line 1953: p_msg_level=>fnd_log.level_procedure);

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

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

1964: p_count => x_msg_count,
1965: p_data => x_msg_data );
1966:
1967: -- Debug info.
1968: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1969: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1970: p_msg_data=>x_msg_data,
1971: p_msg_type=>'UNEXPECTED ERROR',
1972: p_msg_level=>fnd_log.level_error);

Line 1972: p_msg_level=>fnd_log.level_error);

1968: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1969: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1970: p_msg_data=>x_msg_data,
1971: p_msg_type=>'UNEXPECTED ERROR',
1972: p_msg_level=>fnd_log.level_error);
1973: END IF;
1974: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1975: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
1976: p_prefix=>l_debug_prefix,

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

1970: p_msg_data=>x_msg_data,
1971: p_msg_type=>'UNEXPECTED ERROR',
1972: p_msg_level=>fnd_log.level_error);
1973: END IF;
1974: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1975: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
1976: p_prefix=>l_debug_prefix,
1977: p_msg_level=>fnd_log.level_procedure);
1978: END IF;

Line 1977: p_msg_level=>fnd_log.level_procedure);

1973: END IF;
1974: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1975: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
1976: p_prefix=>l_debug_prefix,
1977: p_msg_level=>fnd_log.level_procedure);
1978: END IF;
1979:
1980: -- Check if API is called in debug mode. If yes, disable debug.
1981: --disable_debug;

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

1992: p_count => x_msg_count,
1993: p_data => x_msg_data );
1994:
1995: -- Debug info.
1996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1998: p_msg_data=>x_msg_data,
1999: p_msg_type=>'SQL ERROR',
2000: p_msg_level=>fnd_log.level_error);

Line 2000: p_msg_level=>fnd_log.level_error);

1996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1998: p_msg_data=>x_msg_data,
1999: p_msg_type=>'SQL ERROR',
2000: p_msg_level=>fnd_log.level_error);
2001: END IF;
2002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2003: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
2004: p_prefix=>l_debug_prefix,

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

1998: p_msg_data=>x_msg_data,
1999: p_msg_type=>'SQL ERROR',
2000: p_msg_level=>fnd_log.level_error);
2001: END IF;
2002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2003: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
2004: p_prefix=>l_debug_prefix,
2005: p_msg_level=>fnd_log.level_procedure);
2006: END IF;

Line 2005: p_msg_level=>fnd_log.level_procedure);

2001: END IF;
2002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2003: hz_utility_v2pub.debug(p_message=>'get_role_responsibility_rec (-)',
2004: p_prefix=>l_debug_prefix,
2005: p_msg_level=>fnd_log.level_procedure);
2006: END IF;
2007:
2008: -- Check if API is called in debug mode. If yes, disable debug.
2009: --disable_debug;