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

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

205: -- Check if API is called in debug mode. If yes, enable debug.
206: --enable_debug;
207:
208: -- Debug info.
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'phone_parse (+)',
211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;

Line 212: p_msg_level=>fnd_log.level_procedure);

208: -- Debug info.
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'phone_parse (+)',
211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;
214:
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

437: p_count => x_msg_count,
438: p_data => x_msg_data);
439:
440: -- Debug info.
441: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
443: p_msg_data=>x_msg_data,
444: p_msg_type=>'WARNING',
445: p_msg_level=>fnd_log.level_exception);

Line 445: p_msg_level=>fnd_log.level_exception);

441: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
443: p_msg_data=>x_msg_data,
444: p_msg_type=>'WARNING',
445: p_msg_level=>fnd_log.level_exception);
446: END IF;
447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
448: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
449: p_prefix=>l_debug_prefix,

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

443: p_msg_data=>x_msg_data,
444: p_msg_type=>'WARNING',
445: p_msg_level=>fnd_log.level_exception);
446: END IF;
447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
448: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
449: p_prefix=>l_debug_prefix,
450: p_msg_level=>fnd_log.level_procedure);
451: END IF;

Line 450: p_msg_level=>fnd_log.level_procedure);

446: END IF;
447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
448: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
449: p_prefix=>l_debug_prefix,
450: p_msg_level=>fnd_log.level_procedure);
451: END IF;
452:
453: -- Check if API is called in debug mode. If yes, disable debug.
454: --disable_debug;

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

461: p_count => x_msg_count,
462: p_data => x_msg_data);
463:
464: -- Debug info.
465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
467: p_msg_data=>x_msg_data,
468: p_msg_type=>'ERROR',
469: p_msg_level=>fnd_log.level_error);

Line 469: p_msg_level=>fnd_log.level_error);

465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
467: p_msg_data=>x_msg_data,
468: p_msg_type=>'ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
473: p_prefix=>l_debug_prefix,

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

467: p_msg_data=>x_msg_data,
468: p_msg_type=>'ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;

Line 474: p_msg_level=>fnd_log.level_procedure);

470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;
476:
477: -- Check if API is called in debug mode. If yes, disable debug.
478: --disable_debug;

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

484: p_count => x_msg_count,
485: p_data => x_msg_data);
486:
487: -- Debug info.
488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
490: p_msg_data=>x_msg_data,
491: p_msg_type=>'UNEXPECTED ERROR',
492: p_msg_level=>fnd_log.level_error);

Line 492: p_msg_level=>fnd_log.level_error);

488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
490: p_msg_data=>x_msg_data,
491: p_msg_type=>'UNEXPECTED ERROR',
492: p_msg_level=>fnd_log.level_error);
493: END IF;
494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
495: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
496: p_prefix=>l_debug_prefix,

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

490: p_msg_data=>x_msg_data,
491: p_msg_type=>'UNEXPECTED ERROR',
492: p_msg_level=>fnd_log.level_error);
493: END IF;
494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
495: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
496: p_prefix=>l_debug_prefix,
497: p_msg_level=>fnd_log.level_procedure);
498: END IF;

Line 497: p_msg_level=>fnd_log.level_procedure);

493: END IF;
494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
495: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
496: p_prefix=>l_debug_prefix,
497: p_msg_level=>fnd_log.level_procedure);
498: END IF;
499:
500: -- Check if API is called in debug mode. If yes, disable debug.
501: --disable_debug;

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

511: p_count => x_msg_count,
512: p_data => x_msg_data);
513:
514: -- Debug info.
515: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
516: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
517: p_msg_data=>x_msg_data,
518: p_msg_type=>'SQL ERROR',
519: p_msg_level=>fnd_log.level_error);

Line 519: p_msg_level=>fnd_log.level_error);

515: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
516: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
517: p_msg_data=>x_msg_data,
518: p_msg_type=>'SQL ERROR',
519: p_msg_level=>fnd_log.level_error);
520: END IF;
521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
522: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
523: p_prefix=>l_debug_prefix,

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

517: p_msg_data=>x_msg_data,
518: p_msg_type=>'SQL ERROR',
519: p_msg_level=>fnd_log.level_error);
520: END IF;
521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
522: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
523: p_prefix=>l_debug_prefix,
524: p_msg_level=>fnd_log.level_procedure);
525: END IF;

Line 524: p_msg_level=>fnd_log.level_procedure);

520: END IF;
521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
522: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
523: p_prefix=>l_debug_prefix,
524: p_msg_level=>fnd_log.level_procedure);
525: END IF;
526:
527: -- Check if API is called in debug mode. If yes, disable debug.
528: --disable_debug;

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

627: -- Check if API is called in debug mode. If yes, enable debug.
628: --enable_debug;
629:
630: -- Debug info.
631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
632: hz_utility_v2pub.debug(p_message=>'phone_display (+)',
633: p_prefix=>l_debug_prefix,
634: p_msg_level=>fnd_log.level_procedure);
635: END IF;

Line 634: p_msg_level=>fnd_log.level_procedure);

630: -- Debug info.
631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
632: hz_utility_v2pub.debug(p_message=>'phone_display (+)',
633: p_prefix=>l_debug_prefix,
634: p_msg_level=>fnd_log.level_procedure);
635: END IF;
636:
637: -- initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

854: p_count => x_msg_count,
855: p_data => x_msg_data);
856:
857: -- Debug info.
858: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
859: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
860: p_msg_data=>x_msg_data,
861: p_msg_type=>'WARNING',
862: p_msg_level=>fnd_log.level_exception);

Line 862: p_msg_level=>fnd_log.level_exception);

858: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
859: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
860: p_msg_data=>x_msg_data,
861: p_msg_type=>'WARNING',
862: p_msg_level=>fnd_log.level_exception);
863: END IF;
864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
865: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
866: p_prefix=>l_debug_prefix,

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

860: p_msg_data=>x_msg_data,
861: p_msg_type=>'WARNING',
862: p_msg_level=>fnd_log.level_exception);
863: END IF;
864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
865: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
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: END IF;
864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
865: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
866: p_prefix=>l_debug_prefix,
867: p_msg_level=>fnd_log.level_procedure);
868: END IF;
869:
870: -- Check if API is called in debug mode. If yes, disable debug.
871: --disable_debug;

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

879: p_count => x_msg_count,
880: p_data => x_msg_data);
881:
882: -- Debug info.
883: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
885: p_msg_data=>x_msg_data,
886: p_msg_type=>'ERROR',
887: p_msg_level=>fnd_log.level_error);

Line 887: p_msg_level=>fnd_log.level_error);

883: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
885: p_msg_data=>x_msg_data,
886: p_msg_type=>'ERROR',
887: p_msg_level=>fnd_log.level_error);
888: END IF;
889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
890: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
891: p_prefix=>l_debug_prefix,

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

885: p_msg_data=>x_msg_data,
886: p_msg_type=>'ERROR',
887: p_msg_level=>fnd_log.level_error);
888: END IF;
889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
890: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
891: p_prefix=>l_debug_prefix,
892: p_msg_level=>fnd_log.level_procedure);
893: END IF;

Line 892: p_msg_level=>fnd_log.level_procedure);

888: END IF;
889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
890: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
891: p_prefix=>l_debug_prefix,
892: p_msg_level=>fnd_log.level_procedure);
893: END IF;
894:
895: -- Check if API is called in debug mode. If yes, disable debug.
896: --disable_debug;

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

902: p_count => x_msg_count,
903: p_data => x_msg_data);
904:
905: -- Debug info.
906: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
908: p_msg_data=>x_msg_data,
909: p_msg_type=>'UNEXPECTED ERROR',
910: p_msg_level=>fnd_log.level_error);

Line 910: p_msg_level=>fnd_log.level_error);

906: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
908: p_msg_data=>x_msg_data,
909: p_msg_type=>'UNEXPECTED ERROR',
910: p_msg_level=>fnd_log.level_error);
911: END IF;
912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
914: p_prefix=>l_debug_prefix,

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

908: p_msg_data=>x_msg_data,
909: p_msg_type=>'UNEXPECTED ERROR',
910: p_msg_level=>fnd_log.level_error);
911: END IF;
912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
914: p_prefix=>l_debug_prefix,
915: p_msg_level=>fnd_log.level_procedure);
916: END IF;

Line 915: p_msg_level=>fnd_log.level_procedure);

911: END IF;
912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
914: p_prefix=>l_debug_prefix,
915: p_msg_level=>fnd_log.level_procedure);
916: END IF;
917:
918:
919: -- Check if API is called in debug mode. If yes, disable debug.

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

930: p_count => x_msg_count,
931: p_data => x_msg_data);
932:
933: -- Debug info.
934: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
936: p_msg_data=>x_msg_data,
937: p_msg_type=>'SQL ERROR',
938: p_msg_level=>fnd_log.level_error);

Line 938: p_msg_level=>fnd_log.level_error);

934: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
936: p_msg_data=>x_msg_data,
937: p_msg_type=>'SQL ERROR',
938: p_msg_level=>fnd_log.level_error);
939: END IF;
940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
941: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
942: p_prefix=>l_debug_prefix,

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

936: p_msg_data=>x_msg_data,
937: p_msg_type=>'SQL ERROR',
938: p_msg_level=>fnd_log.level_error);
939: END IF;
940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
941: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
942: p_prefix=>l_debug_prefix,
943: p_msg_level=>fnd_log.level_procedure);
944: END IF;

Line 943: p_msg_level=>fnd_log.level_procedure);

939: END IF;
940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
941: hz_utility_v2pub.debug(p_message=>'phone_display (-)',
942: p_prefix=>l_debug_prefix,
943: p_msg_level=>fnd_log.level_procedure);
944: END IF;
945: -- Check if API is called in debug mode. If yes, disable debug.
946: --disable_debug;
947:

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

1032:
1033: BEGIN
1034:
1035: -- Debug info.
1036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1037: hz_utility_v2pub.debug(
1038: p_message => 'phone_display (+)',
1039: p_prefix => l_debug_prefix,
1040: p_msg_level => fnd_log.level_procedure);

Line 1040: p_msg_level => fnd_log.level_procedure);

1036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1037: hz_utility_v2pub.debug(
1038: p_message => 'phone_display (+)',
1039: p_prefix => l_debug_prefix,
1040: p_msg_level => fnd_log.level_procedure);
1041: END IF;
1042:
1043: -- initialize message list if p_init_msg_list is set to TRUE.
1044: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1225: p_count => x_msg_count,
1226: p_data => x_msg_data);
1227:
1228: -- Debug info.
1229: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1230: hz_utility_v2pub.debug_return_messages(
1231: p_msg_count => x_msg_count,
1232: p_msg_data => x_msg_data,
1233: p_msg_type => 'WARNING',

Line 1234: p_msg_level => fnd_log.level_error);

1230: hz_utility_v2pub.debug_return_messages(
1231: p_msg_count => x_msg_count,
1232: p_msg_data => x_msg_data,
1233: p_msg_type => 'WARNING',
1234: p_msg_level => fnd_log.level_error);
1235: END IF;
1236: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1237: hz_utility_v2pub.debug(
1238: p_message => 'phone_display (-)',

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

1232: p_msg_data => x_msg_data,
1233: p_msg_type => 'WARNING',
1234: p_msg_level => fnd_log.level_error);
1235: END IF;
1236: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1237: hz_utility_v2pub.debug(
1238: p_message => 'phone_display (-)',
1239: p_prefix => l_debug_prefix,
1240: p_msg_level => fnd_log.level_procedure);

Line 1240: p_msg_level => fnd_log.level_procedure);

1236: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1237: hz_utility_v2pub.debug(
1238: p_message => 'phone_display (-)',
1239: p_prefix => l_debug_prefix,
1240: p_msg_level => fnd_log.level_procedure);
1241: END IF;
1242:
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN

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

1248: p_count => x_msg_count,
1249: p_data => x_msg_data);
1250:
1251: -- Debug info.
1252: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1253: hz_utility_v2pub.debug_return_messages(
1254: p_msg_count => x_msg_count,
1255: p_msg_data => x_msg_data,
1256: p_msg_type => 'ERROR',

Line 1257: p_msg_level => fnd_log.level_error);

1253: hz_utility_v2pub.debug_return_messages(
1254: p_msg_count => x_msg_count,
1255: p_msg_data => x_msg_data,
1256: p_msg_type => 'ERROR',
1257: p_msg_level => fnd_log.level_error);
1258: END IF;
1259: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1260: hz_utility_v2pub.debug(
1261: p_message => 'phone_display (-)',

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

1255: p_msg_data => x_msg_data,
1256: p_msg_type => 'ERROR',
1257: p_msg_level => fnd_log.level_error);
1258: END IF;
1259: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1260: hz_utility_v2pub.debug(
1261: p_message => 'phone_display (-)',
1262: p_prefix => l_debug_prefix,
1263: p_msg_level => fnd_log.level_procedure);

Line 1263: p_msg_level => fnd_log.level_procedure);

1259: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1260: hz_utility_v2pub.debug(
1261: p_message => 'phone_display (-)',
1262: p_prefix => l_debug_prefix,
1263: p_msg_level => fnd_log.level_procedure);
1264: END IF;
1265:
1266:
1267: WHEN fnd_api.g_exc_unexpected_error THEN

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

1271: p_count => x_msg_count,
1272: p_data => x_msg_data);
1273:
1274: -- Debug info.
1275: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1276: hz_utility_v2pub.debug_return_messages(
1277: p_msg_count => x_msg_count,
1278: p_msg_data => x_msg_data,
1279: p_msg_type => 'UNEXPECTED ERROR',

Line 1280: p_msg_level => fnd_log.level_error);

1276: hz_utility_v2pub.debug_return_messages(
1277: p_msg_count => x_msg_count,
1278: p_msg_data => x_msg_data,
1279: p_msg_type => 'UNEXPECTED ERROR',
1280: p_msg_level => fnd_log.level_error);
1281: END IF;
1282: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(
1284: p_message => 'phone_display (-)',

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

1278: p_msg_data => x_msg_data,
1279: p_msg_type => 'UNEXPECTED ERROR',
1280: p_msg_level => fnd_log.level_error);
1281: END IF;
1282: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(
1284: p_message => 'phone_display (-)',
1285: p_prefix => l_debug_prefix,
1286: p_msg_level => fnd_log.level_procedure);

Line 1286: p_msg_level => fnd_log.level_procedure);

1282: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1283: hz_utility_v2pub.debug(
1284: p_message => 'phone_display (-)',
1285: p_prefix => l_debug_prefix,
1286: p_msg_level => fnd_log.level_procedure);
1287: END IF;
1288:
1289: WHEN OTHERS THEN
1290: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300:
1301: -- Debug info.
1302: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1303: hz_utility_v2pub.debug_return_messages(
1304: p_msg_count => x_msg_count,
1305: p_msg_data => x_msg_data,
1306: p_msg_type => 'SQL ERROR',

Line 1307: p_msg_level => fnd_log.level_error);

1303: hz_utility_v2pub.debug_return_messages(
1304: p_msg_count => x_msg_count,
1305: p_msg_data => x_msg_data,
1306: p_msg_type => 'SQL ERROR',
1307: p_msg_level => fnd_log.level_error);
1308: END IF;
1309: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug(
1311: p_message => 'phone_display (-)',

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

1305: p_msg_data => x_msg_data,
1306: p_msg_type => 'SQL ERROR',
1307: p_msg_level => fnd_log.level_error);
1308: END IF;
1309: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug(
1311: p_message => 'phone_display (-)',
1312: p_prefix => l_debug_prefix,
1313: p_msg_level => fnd_log.level_procedure);

Line 1313: p_msg_level => fnd_log.level_procedure);

1309: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug(
1311: p_message => 'phone_display (-)',
1312: p_prefix => l_debug_prefix,
1313: p_msg_level => fnd_log.level_procedure);
1314: END IF;
1315:
1316: END Phone_display;
1317:

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

1374: -- Check if API is called in debug mode. If yes, enable debug.
1375: --enable_debug;
1376:
1377: -- Debug info.
1378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1379: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (+)',
1380: p_prefix=>l_debug_prefix,
1381: p_msg_level=>fnd_log.level_procedure);
1382: END IF;

Line 1381: p_msg_level=>fnd_log.level_procedure);

1377: -- Debug info.
1378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1379: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (+)',
1380: p_prefix=>l_debug_prefix,
1381: p_msg_level=>fnd_log.level_procedure);
1382: END IF;
1383:
1384: -- initialize message list if p_init_msg_list is set to TRUE.
1385: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1449: p_count => x_msg_count,
1450: p_data => x_msg_data);
1451:
1452: -- Debug info.
1453: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1454: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1455: p_msg_data=>x_msg_data,
1456: p_msg_type=>'WARNING',
1457: p_msg_level=>fnd_log.level_exception);

Line 1457: p_msg_level=>fnd_log.level_exception);

1453: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1454: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1455: p_msg_data=>x_msg_data,
1456: p_msg_type=>'WARNING',
1457: p_msg_level=>fnd_log.level_exception);
1458: END IF;
1459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1460: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1461: p_prefix=>l_debug_prefix,

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

1455: p_msg_data=>x_msg_data,
1456: p_msg_type=>'WARNING',
1457: p_msg_level=>fnd_log.level_exception);
1458: END IF;
1459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1460: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1461: p_prefix=>l_debug_prefix,
1462: p_msg_level=>fnd_log.level_procedure);
1463: END IF;

Line 1462: p_msg_level=>fnd_log.level_procedure);

1458: END IF;
1459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1460: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1461: p_prefix=>l_debug_prefix,
1462: p_msg_level=>fnd_log.level_procedure);
1463: END IF;
1464:
1465: -- Check if API is called in debug mode. If yes, disable debug.
1466: --disable_debug;

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

1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1475:
1476: -- Debug info.
1477: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1479: p_msg_data=>x_msg_data,
1480: p_msg_type=>'ERROR',
1481: p_msg_level=>fnd_log.level_error);

Line 1481: p_msg_level=>fnd_log.level_error);

1477: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1479: p_msg_data=>x_msg_data,
1480: p_msg_type=>'ERROR',
1481: p_msg_level=>fnd_log.level_error);
1482: END IF;
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1485: p_prefix=>l_debug_prefix,

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

1479: p_msg_data=>x_msg_data,
1480: p_msg_type=>'ERROR',
1481: p_msg_level=>fnd_log.level_error);
1482: END IF;
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1485: p_prefix=>l_debug_prefix,
1486: p_msg_level=>fnd_log.level_procedure);
1487: END IF;

Line 1486: p_msg_level=>fnd_log.level_procedure);

1482: END IF;
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1485: p_prefix=>l_debug_prefix,
1486: p_msg_level=>fnd_log.level_procedure);
1487: END IF;
1488:
1489: -- Check if API is called in debug mode. If yes, disable debug.
1490: --disable_debug;

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

1496: p_count => x_msg_count,
1497: p_data => x_msg_data);
1498:
1499: -- Debug info.
1500: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1501: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1502: p_msg_data=>x_msg_data,
1503: p_msg_type=>'UNEXPECTED ERROR',
1504: p_msg_level=>fnd_log.level_error);

Line 1504: p_msg_level=>fnd_log.level_error);

1500: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1501: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1502: p_msg_data=>x_msg_data,
1503: p_msg_type=>'UNEXPECTED ERROR',
1504: p_msg_level=>fnd_log.level_error);
1505: END IF;
1506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1507: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1508: p_prefix=>l_debug_prefix,

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

1502: p_msg_data=>x_msg_data,
1503: p_msg_type=>'UNEXPECTED ERROR',
1504: p_msg_level=>fnd_log.level_error);
1505: END IF;
1506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1507: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1508: p_prefix=>l_debug_prefix,
1509: p_msg_level=>fnd_log.level_procedure);
1510: END IF;

Line 1509: p_msg_level=>fnd_log.level_procedure);

1505: END IF;
1506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1507: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1508: p_prefix=>l_debug_prefix,
1509: p_msg_level=>fnd_log.level_procedure);
1510: END IF;
1511:
1512:
1513: -- Check if API is called in debug mode. If yes, disable debug.

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

1524: p_count => x_msg_count,
1525: p_data => x_msg_data);
1526:
1527: -- Debug info.
1528: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1530: p_msg_data=>x_msg_data,
1531: p_msg_type=>'SQL ERROR',
1532: p_msg_level=>fnd_log.level_error);

Line 1532: p_msg_level=>fnd_log.level_error);

1528: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1530: p_msg_data=>x_msg_data,
1531: p_msg_type=>'SQL ERROR',
1532: p_msg_level=>fnd_log.level_error);
1533: END IF;
1534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1535: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1536: p_prefix=>l_debug_prefix,

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

1530: p_msg_data=>x_msg_data,
1531: p_msg_type=>'SQL ERROR',
1532: p_msg_level=>fnd_log.level_error);
1533: END IF;
1534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1535: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1536: p_prefix=>l_debug_prefix,
1537: p_msg_level=>fnd_log.level_procedure);
1538: END IF;

Line 1537: p_msg_level=>fnd_log.level_procedure);

1533: END IF;
1534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1535: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',
1536: p_prefix=>l_debug_prefix,
1537: p_msg_level=>fnd_log.level_procedure);
1538: END IF;
1539:
1540: -- Check if API is called in debug mode. If yes, disable debug.
1541: --disable_debug;

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

1729: l_debug_prefix VARCHAR2(30) := '';
1730: BEGIN
1731:
1732: -- Debug info.
1733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1734: hz_utility_v2pub.debug(p_message=>'parse_intl_prefix (+)',
1735: p_prefix=>l_debug_prefix,
1736: p_msg_level=>fnd_log.level_procedure);
1737: END IF;

Line 1736: p_msg_level=>fnd_log.level_procedure);

1732: -- Debug info.
1733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1734: hz_utility_v2pub.debug(p_message=>'parse_intl_prefix (+)',
1735: p_prefix=>l_debug_prefix,
1736: p_msg_level=>fnd_log.level_procedure);
1737: END IF;
1738:
1739: l_with_iprefix := p_with_iprefix;
1740:

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

1774: x_intl_prefix := l_prefix_check;
1775: x_without_iprefix := l_without_iprefix;
1776:
1777: -- Debug info.
1778: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1779: hz_utility_v2pub.debug(p_message=>'parse_intl_prefix (-)',
1780: p_prefix=>l_debug_prefix,
1781: p_msg_level=>fnd_log.level_procedure);
1782: END IF;

Line 1781: p_msg_level=>fnd_log.level_procedure);

1777: -- Debug info.
1778: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1779: hz_utility_v2pub.debug(p_message=>'parse_intl_prefix (-)',
1780: p_prefix=>l_debug_prefix,
1781: p_msg_level=>fnd_log.level_procedure);
1782: END IF;
1783:
1784: EXCEPTION
1785:

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

1811:
1812: BEGIN
1813:
1814: -- Debug info.
1815: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1816: hz_utility_v2pub.debug(p_message=>'parse_trunk_prefix (+)',
1817: p_prefix=>l_debug_prefix,
1818: p_msg_level=>fnd_log.level_procedure);
1819: END IF;

Line 1818: p_msg_level=>fnd_log.level_procedure);

1814: -- Debug info.
1815: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1816: hz_utility_v2pub.debug(p_message=>'parse_trunk_prefix (+)',
1817: p_prefix=>l_debug_prefix,
1818: p_msg_level=>fnd_log.level_procedure);
1819: END IF;
1820:
1821: l_with_tprefix := p_with_tprefix;
1822:

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

1858: x_trunk_prefix := l_tprefix_check;
1859: x_without_tprefix := l_without_tprefix;
1860:
1861: -- Debug info.
1862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1863: hz_utility_v2pub.debug(p_message=>'parse_trunk_prefix (-)',
1864: p_prefix=>l_debug_prefix,
1865: p_msg_level=>fnd_log.level_procedure);
1866: END IF;

Line 1865: p_msg_level=>fnd_log.level_procedure);

1861: -- Debug info.
1862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1863: hz_utility_v2pub.debug(p_message=>'parse_trunk_prefix (-)',
1864: p_prefix=>l_debug_prefix,
1865: p_msg_level=>fnd_log.level_procedure);
1866: END IF;
1867:
1868: EXCEPTION
1869: WHEN NO_DATA_FOUND THEN

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

1891: l_debug_prefix VARCHAR2(30) := '';
1892: BEGIN
1893:
1894: -- Debug info.
1895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug(p_message=>'parse_country_code (+)',
1897: p_prefix=>l_debug_prefix,
1898: p_msg_level=>fnd_log.level_procedure);
1899: END IF;

Line 1898: p_msg_level=>fnd_log.level_procedure);

1894: -- Debug info.
1895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug(p_message=>'parse_country_code (+)',
1897: p_prefix=>l_debug_prefix,
1898: p_msg_level=>fnd_log.level_procedure);
1899: END IF;
1900:
1901: l_with_country_code := p_with_country_code ;
1902: l_length_ccode := LENGTH(l_with_country_code);

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

1934: x_parsed_country_code := l_country_code_check;
1935: x_without_country_code := l_without_country_code;
1936:
1937: -- Debug info.
1938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1939: hz_utility_v2pub.debug(p_message=>'parse_country_code (-)',
1940: p_prefix=>l_debug_prefix,
1941: p_msg_level=>fnd_log.level_procedure);
1942: END IF;

Line 1941: p_msg_level=>fnd_log.level_procedure);

1937: -- Debug info.
1938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1939: hz_utility_v2pub.debug(p_message=>'parse_country_code (-)',
1940: p_prefix=>l_debug_prefix,
1941: p_msg_level=>fnd_log.level_procedure);
1942: END IF;
1943:
1944: EXCEPTION
1945: WHEN OTHERS THEN

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

1968:
1969: BEGIN
1970:
1971: -- Debug info.
1972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1973: hz_utility_v2pub.debug(p_message=>'parse_area_code (+)',
1974: p_prefix=>l_debug_prefix,
1975: p_msg_level=>fnd_log.level_procedure);
1976: END IF;

Line 1975: p_msg_level=>fnd_log.level_procedure);

1971: -- Debug info.
1972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1973: hz_utility_v2pub.debug(p_message=>'parse_area_code (+)',
1974: p_prefix=>l_debug_prefix,
1975: p_msg_level=>fnd_log.level_procedure);
1976: END IF;
1977:
1978: l_with_area_code := p_with_area_code ;
1979: l_length_with_code := LENGTH(l_with_area_code);

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

2062: x_parsed_area_code := l_area_code_check;
2063: x_parsed_phone_number := l_without_area_code;
2064:
2065: -- Debug info.
2066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2067: hz_utility_v2pub.debug(p_message=>'parse_area_code (-)',
2068: p_prefix=>l_debug_prefix,
2069: p_msg_level=>fnd_log.level_procedure);
2070: END IF;

Line 2069: p_msg_level=>fnd_log.level_procedure);

2065: -- Debug info.
2066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2067: hz_utility_v2pub.debug(p_message=>'parse_area_code (-)',
2068: p_prefix=>l_debug_prefix,
2069: p_msg_level=>fnd_log.level_procedure);
2070: END IF;
2071:
2072: exception
2073: when no_data_found then

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

2087:
2088: BEGIN
2089:
2090: -- Debug info.
2091: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2092: hz_utility_v2pub.debug(p_message=>'filter_phone_number (+)',
2093: p_prefix=>l_debug_prefix,
2094: p_msg_level=>fnd_log.level_procedure);
2095: END IF;

Line 2094: p_msg_level=>fnd_log.level_procedure);

2090: -- Debug info.
2091: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2092: hz_utility_v2pub.debug(p_message=>'filter_phone_number (+)',
2093: p_prefix=>l_debug_prefix,
2094: p_msg_level=>fnd_log.level_procedure);
2095: END IF;
2096:
2097: IF p_isformat = 0 THEN
2098: l_filtered_number := TRANSLATE (

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

2106: '9');
2107: END IF;
2108:
2109: -- Debug info.
2110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2111: hz_utility_v2pub.debug(p_message=>'filter_phone_number (-)',
2112: p_prefix=>l_debug_prefix,
2113: p_msg_level=>fnd_log.level_procedure);
2114: END IF;

Line 2113: p_msg_level=>fnd_log.level_procedure);

2109: -- Debug info.
2110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2111: hz_utility_v2pub.debug(p_message=>'filter_phone_number (-)',
2112: p_prefix=>l_debug_prefix,
2113: p_msg_level=>fnd_log.level_procedure);
2114: END IF;
2115:
2116: RETURN l_filtered_number;
2117:

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

2146:
2147: BEGIN
2148:
2149: -- Debug info.
2150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2151: hz_utility_v2pub.debug(
2152: p_message => 'get_phone_format (+)',
2153: p_prefix => l_debug_prefix,
2154: p_msg_level => fnd_log.level_procedure);

Line 2154: p_msg_level => fnd_log.level_procedure);

2150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2151: hz_utility_v2pub.debug(
2152: p_message => 'get_phone_format (+)',
2153: p_prefix => l_debug_prefix,
2154: p_msg_level => fnd_log.level_procedure);
2155: END IF;
2156:
2157: -- cache phone formats
2158:

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

2212: END IF;
2213: END LOOP;
2214:
2215: -- Debug info.
2216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2217: hz_utility_v2pub.debug(
2218: p_message => 'get_phone_format (-)',
2219: p_prefix => l_debug_prefix,
2220: p_msg_level => fnd_log.level_procedure);

Line 2220: p_msg_level => fnd_log.level_procedure);

2216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2217: hz_utility_v2pub.debug(
2218: p_message => 'get_phone_format (-)',
2219: p_prefix => l_debug_prefix,
2220: p_msg_level => fnd_log.level_procedure);
2221: END IF;
2222:
2223: END get_phone_format;
2224:

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

2238:
2239: BEGIN
2240:
2241: -- Debug info.
2242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2243: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (+)',
2244: p_prefix=>l_debug_prefix,
2245: p_msg_level=>fnd_log.level_procedure);
2246: END IF;

Line 2245: p_msg_level=>fnd_log.level_procedure);

2241: -- Debug info.
2242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2243: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (+)',
2244: p_prefix=>l_debug_prefix,
2245: p_msg_level=>fnd_log.level_procedure);
2246: END IF;
2247:
2248: l_format_length := LENGTH(p_phone_format_style);
2249: x_formatted_phone_number := '';

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

2263: x_formatted_phone_number := x_formatted_phone_number ||
2264: l_format_char;
2265: END IF;
2266: END LOOP;
2267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2268: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (-)',
2269: p_prefix=>l_debug_prefix,
2270: p_msg_level=>fnd_log.level_procedure);
2271: END IF;

Line 2270: p_msg_level=>fnd_log.level_procedure);

2266: END LOOP;
2267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2268: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (-)',
2269: p_prefix=>l_debug_prefix,
2270: p_msg_level=>fnd_log.level_procedure);
2271: END IF;
2272:
2273: END translate_raw_phone_number;
2274: