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 HZ_UTILITY_V2PUB

Line 210: hz_utility_v2pub.debug(p_message=>'phone_parse (+)',

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;
214:

Line 442: hz_utility_v2pub.debug_return_messages(p_msg_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);
446: END IF;

Line 448: hz_utility_v2pub.debug(p_message=>'phone_format (-)',

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;
452:

Line 466: hz_utility_v2pub.debug_return_messages(p_msg_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);
470: END IF;

Line 472: hz_utility_v2pub.debug(p_message=>'phone_format (-)',

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;
476:

Line 489: hz_utility_v2pub.debug_return_messages(p_msg_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);
493: END IF;

Line 495: hz_utility_v2pub.debug(p_message=>'phone_format (-)',

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;
499:

Line 516: hz_utility_v2pub.debug_return_messages(p_msg_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);
520: END IF;

Line 522: hz_utility_v2pub.debug(p_message=>'phone_format (-)',

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;
526:

Line 632: hz_utility_v2pub.debug(p_message=>'phone_display (+)',

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;
636:

Line 859: hz_utility_v2pub.debug_return_messages(p_msg_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);
863: END IF;

Line 865: hz_utility_v2pub.debug(p_message=>'phone_display (-)',

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;
869:

Line 884: hz_utility_v2pub.debug_return_messages(p_msg_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);
888: END IF;

Line 890: hz_utility_v2pub.debug(p_message=>'phone_display (-)',

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;
894:

Line 907: hz_utility_v2pub.debug_return_messages(p_msg_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);
911: END IF;

Line 913: hz_utility_v2pub.debug(p_message=>'phone_display (-)',

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;
917:

Line 935: hz_utility_v2pub.debug_return_messages(p_msg_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);
939: END IF;

Line 941: hz_utility_v2pub.debug(p_message=>'phone_display (-)',

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;
945: -- Check if API is called in debug mode. If yes, disable debug.

Line 1037: hz_utility_v2pub.debug(

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);
1041: END IF;

Line 1230: hz_utility_v2pub.debug_return_messages(

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',
1234: p_msg_level => fnd_log.level_error);

Line 1237: hz_utility_v2pub.debug(

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);
1241: END IF;

Line 1253: hz_utility_v2pub.debug_return_messages(

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',
1257: p_msg_level => fnd_log.level_error);

Line 1260: hz_utility_v2pub.debug(

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);
1264: END IF;

Line 1276: hz_utility_v2pub.debug_return_messages(

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',
1280: p_msg_level => fnd_log.level_error);

Line 1283: hz_utility_v2pub.debug(

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);
1287: END IF;

Line 1303: hz_utility_v2pub.debug_return_messages(

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',
1307: p_msg_level => fnd_log.level_error);

Line 1310: hz_utility_v2pub.debug(

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);
1314: END IF;

Line 1379: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (+)',

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;
1383:

Line 1454: hz_utility_v2pub.debug_return_messages(p_msg_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);
1458: END IF;

Line 1460: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',

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;
1464:

Line 1478: hz_utility_v2pub.debug_return_messages(p_msg_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);
1482: END IF;

Line 1484: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',

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;
1488:

Line 1501: hz_utility_v2pub.debug_return_messages(p_msg_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);
1505: END IF;

Line 1507: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',

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;
1511:

Line 1529: hz_utility_v2pub.debug_return_messages(p_msg_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);
1533: END IF;

Line 1535: hz_utility_v2pub.debug(p_message=>'check_mobile_phone (-)',

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;
1539:

Line 1734: hz_utility_v2pub.debug(p_message=>'parse_intl_prefix (+)',

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;
1738:

Line 1779: hz_utility_v2pub.debug(p_message=>'parse_intl_prefix (-)',

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;
1783:

Line 1816: hz_utility_v2pub.debug(p_message=>'parse_trunk_prefix (+)',

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;
1820:

Line 1863: hz_utility_v2pub.debug(p_message=>'parse_trunk_prefix (-)',

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;
1867:

Line 1896: hz_utility_v2pub.debug(p_message=>'parse_country_code (+)',

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;
1900:

Line 1939: hz_utility_v2pub.debug(p_message=>'parse_country_code (-)',

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;
1943:

Line 1973: hz_utility_v2pub.debug(p_message=>'parse_area_code (+)',

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;
1977:

Line 2067: hz_utility_v2pub.debug(p_message=>'parse_area_code (-)',

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;
2071:

Line 2092: hz_utility_v2pub.debug(p_message=>'filter_phone_number (+)',

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;
2096:

Line 2111: hz_utility_v2pub.debug(p_message=>'filter_phone_number (-)',

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;
2115:

Line 2151: hz_utility_v2pub.debug(

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);
2155: END IF;

Line 2217: hz_utility_v2pub.debug(

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);
2221: END IF;

Line 2243: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (+)',

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;
2247:

Line 2268: hz_utility_v2pub.debug(p_message=>'translate_raw_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;
2272:

Line 2307: SELECT phone_extension, hz_utility_v2pub.get_lookupmeaning('AR_LOOKUPS', 'PHONE_LINE_TYPE', phone_line_type)

2303: x_return_status,
2304: x_msg_count,
2305: x_msg_data);
2306:
2307: SELECT phone_extension, hz_utility_v2pub.get_lookupmeaning('AR_LOOKUPS', 'PHONE_LINE_TYPE', phone_line_type)
2308: INTO x_phone_extension, x_phone_line_type
2309: FROM hz_contact_points
2310: WHERE contact_point_id = p_contact_point_id;
2311:

Line 2391: hz_utility_v2pub.get_lookupmeaning('AR_LOOKUPS', 'PHONE_LINE_TYPE', p_phone_line_type);

2387: AND p_phone_line_type<>fnd_api.g_miss_char
2388: AND l_display_purpose = fnd_api.g_true
2389: THEN
2390: l_phone_line_meaning :=
2391: hz_utility_v2pub.get_lookupmeaning('AR_LOOKUPS', 'PHONE_LINE_TYPE', p_phone_line_type);
2392:
2393: x_formatted_phone_number :=
2394: x_formatted_phone_number || ' (' || l_phone_line_meaning || ')';
2395: END IF;