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

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

343: AND rownum = 1;
344:
345: BEGIN
346: -- Debug info.
347: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (+)',
349: p_prefix=>l_debug_prefix,
350: p_msg_level=>fnd_log.level_procedure);
351: END IF;

Line 350: p_msg_level=>fnd_log.level_procedure);

346: -- Debug info.
347: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (+)',
349: p_prefix=>l_debug_prefix,
350: p_msg_level=>fnd_log.level_procedure);
351: END IF;
352:
353: IF p_contact_point_rec.contact_point_type = 'EDI' THEN
354: l_edi_rec := p_edi_rec;

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

456: -- but can not be both. If raw_phone_number does not have a value,
457: -- it will be set by phone_number and phone_area_code.
458:
459: -- Debug info.
460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug(p_message=>'contact_point_type = ' || p_contact_point_rec.contact_point_type,
462: p_prefix =>l_debug_prefix,
463: p_msg_level=>fnd_log.level_statement);
464: END IF;

Line 463: p_msg_level=>fnd_log.level_statement);

459: -- Debug info.
460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug(p_message=>'contact_point_type = ' || p_contact_point_rec.contact_point_type,
462: p_prefix =>l_debug_prefix,
463: p_msg_level=>fnd_log.level_statement);
464: END IF;
465:
466: --To get territory code to pass to phone_format, first check if country code
467: --was passed in else get it from hz_locations for owner_table_name HZ_PARTY_SITES

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

551: END IF;
552: END IF;
553:
554: -- Debug info.
555: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
556: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||
557: 'raw_phone_number = ' || l_phone_rec.raw_phone_number,
558: p_prefix =>l_debug_prefix,
559: p_msg_level=>fnd_log.level_statement);

Line 559: p_msg_level=>fnd_log.level_statement);

555: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
556: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||
557: 'raw_phone_number = ' || l_phone_rec.raw_phone_number,
558: p_prefix =>l_debug_prefix,
559: p_msg_level=>fnd_log.level_statement);
560: END IF;
561:
562: -- Populate transposed_phone_number
563: IF l_phone_rec.phone_country_code IS NOT NULL AND

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

577: l_transposed_phone_number := hz_phone_number_pkg.transpose(
578: l_transposed_phone_number || l_phone_rec.phone_number);
579:
580: -- Debug info.
581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,
583: p_prefix =>l_debug_prefix,
584: p_msg_level=>fnd_log.level_statement);
585: END IF;

Line 584: p_msg_level=>fnd_log.level_statement);

580: -- Debug info.
581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,
583: p_prefix =>l_debug_prefix,
584: p_msg_level=>fnd_log.level_statement);
585: END IF;
586: END IF;
587:
588: -- If this is the first active contact point for the combination of

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

709: end if;
710:
711:
712: -- Debug info.
713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
714: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (+)',
715: p_prefix=>l_debug_prefix,
716: p_msg_level=>fnd_log.level_procedure);
717: END IF;

Line 716: p_msg_level=>fnd_log.level_procedure);

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

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

789: -- url is mandatory if contact_point_type = 'WEB'.
790: -- email_address is mandatory if contact_point_type = 'EMAIL'.
791:
792: -- Debug info.
793: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
794: hz_utility_v2pub.debug(p_message=>'primary_flag = ' || p_contact_point_rec.primary_flag || ' ' ||
795: 'owner_table_name = '||p_contact_point_rec.owner_table_name||' '||
796: 'contact_point_type = '||p_contact_point_rec.contact_point_type||' '||
797: 'actual_content_source = ' || p_contact_point_rec.actual_content_source,

Line 799: p_msg_level=>fnd_log.level_statement);

795: 'owner_table_name = '||p_contact_point_rec.owner_table_name||' '||
796: 'contact_point_type = '||p_contact_point_rec.contact_point_type||' '||
797: 'actual_content_source = ' || p_contact_point_rec.actual_content_source,
798: p_prefix =>l_debug_prefix,
799: p_msg_level=>fnd_log.level_statement);
800: END IF;
801:
802: -- Bug 2197181: commented out NOCOPY the data source checking. We will denormalize
803: -- to hz_parties as long as it's a primary contact point regardless of data

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

864: END IF;
865: --End of Bug No: 3131865.
866:
867: -- Debug info.
868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (-) ' ||
870: 'x_contact_point_id = ' ||p_contact_point_rec.contact_point_id,
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);

Line 872: p_msg_level=>fnd_log.level_procedure);

868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (-) ' ||
870: 'x_contact_point_id = ' ||p_contact_point_rec.contact_point_id,
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874:
875: if p_contact_point_rec.orig_system is not null
876: and p_contact_point_rec.orig_system <>fnd_api.g_miss_char

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

893: end if;
894:
895:
896: -- Debug info.
897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
898: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
899: p_prefix=>l_debug_prefix,
900: p_msg_level=>fnd_log.level_procedure);
901: END IF;

Line 900: p_msg_level=>fnd_log.level_procedure);

896: -- Debug info.
897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
898: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
899: p_prefix=>l_debug_prefix,
900: p_msg_level=>fnd_log.level_procedure);
901: END IF;
902:
903: END do_create_contact_point;
904:

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

1069: AND contact_point_id <> p_contact_point_id);
1070:
1071: BEGIN
1072: -- Debug info.
1073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1074: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (+)',
1075: p_prefix=>l_debug_prefix,
1076: p_msg_level=>fnd_log.level_procedure);
1077: END IF;

Line 1076: p_msg_level=>fnd_log.level_procedure);

1072: -- Debug info.
1073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1074: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (+)',
1075: p_prefix=>l_debug_prefix,
1076: p_msg_level=>fnd_log.level_procedure);
1077: END IF;
1078:
1079:
1080: -- Lock record.

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

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

Line 1131: p_msg_level=>fnd_log.level_statement);

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

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

1364: END IF;
1365: END IF;
1366:
1367: -- Debug info.
1368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1369: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||
1370: 'raw_phone_number = ' || l_phone_rec.raw_phone_number,
1371: p_prefix =>l_debug_prefix,
1372: p_msg_level=>fnd_log.level_statement);

Line 1372: p_msg_level=>fnd_log.level_statement);

1368: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1369: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||
1370: 'raw_phone_number = ' || l_phone_rec.raw_phone_number,
1371: p_prefix =>l_debug_prefix,
1372: p_msg_level=>fnd_log.level_statement);
1373: END IF;
1374:
1375:
1376: -- Populate transposed_phone_number

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

1393: hz_phone_number_pkg.transpose(l_transposed_phone_number);
1394: END IF;
1395:
1396: -- Debug info.
1397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1398: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,
1399: p_prefix =>l_debug_prefix,
1400: p_msg_level=>fnd_log.level_statement);
1401: END IF;

Line 1400: p_msg_level=>fnd_log.level_statement);

1396: -- Debug info.
1397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1398: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,
1399: p_prefix =>l_debug_prefix,
1400: p_msg_level=>fnd_log.level_statement);
1401: END IF;
1402:
1403: END IF;
1404:

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

1695: -- but we should not update existing osr, set it to null
1696: end if;
1697:
1698: -- Debug info.
1699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',
1701: p_prefix=>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_procedure);
1703: END IF;

Line 1702: p_msg_level=>fnd_log.level_procedure);

1698: -- Debug info.
1699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',
1701: p_prefix=>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_procedure);
1703: END IF;
1704:
1705: -- Bug 4693719 : pass NULL if the secure data is not updated
1706: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

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

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

Line 1784: p_msg_level=>fnd_log.level_procedure);

1780: -- Debug info.
1781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1782: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Update_Row (-) ',
1783: p_prefix=>l_debug_prefix,
1784: p_msg_level=>fnd_log.level_procedure);
1785: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
1786: p_prefix=>l_debug_prefix,
1787: p_msg_level=>fnd_log.level_procedure);
1788: END IF;

Line 1787: p_msg_level=>fnd_log.level_procedure);

1783: p_prefix=>l_debug_prefix,
1784: p_msg_level=>fnd_log.level_procedure);
1785: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
1786: p_prefix=>l_debug_prefix,
1787: p_msg_level=>fnd_log.level_procedure);
1788: END IF;
1789:
1790: END do_update_contact_point;
1791:

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

1841:
1842: BEGIN
1843:
1844: -- Debug info.
1845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1846: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (+)',
1847: p_prefix=>l_debug_prefix,
1848: p_msg_level=>fnd_log.level_procedure);
1849: END IF;

Line 1848: p_msg_level=>fnd_log.level_procedure);

1844: -- Debug info.
1845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1846: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (+)',
1847: p_prefix=>l_debug_prefix,
1848: p_msg_level=>fnd_log.level_procedure);
1849: END IF;
1850:
1851: BEGIN
1852: OPEN c_contact_point;

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

1886: p_contact_point_id => l_unset_prim_contact_point_id);
1887: END IF;
1888:
1889: -- Debug info.
1890: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (-)',
1892: p_prefix=>l_debug_prefix,
1893: p_msg_level=>fnd_log.level_procedure);
1894: END IF;

Line 1893: p_msg_level=>fnd_log.level_procedure);

1889: -- Debug info.
1890: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (-)',
1892: p_prefix=>l_debug_prefix,
1893: p_msg_level=>fnd_log.level_procedure);
1894: END IF;
1895:
1896: END do_unset_prim_contact_point;
1897:

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

1942: ) IS
1943: l_debug_prefix VARCHAR2(30) := '';
1944: BEGIN
1945: -- Debug info.
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (+)',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;

Line 1949: p_msg_level=>fnd_log.level_procedure);

1945: -- Debug info.
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (+)',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;
1951: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1952: hz_utility_v2pub.debug(p_message=>'party_id = ' || p_party_id || ' ' ||
1953: 'contact_point_type = ' || p_contact_point_type || ' ' ||

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

1947: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (+)',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;
1951: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1952: hz_utility_v2pub.debug(p_message=>'party_id = ' || p_party_id || ' ' ||
1953: 'contact_point_type = ' || p_contact_point_type || ' ' ||
1954: 'url = ' || p_url || ' ' ||
1955: 'email_address = ' || p_email_address||

Line 1964: p_msg_level=>fnd_log.level_statement);

1960: 'primary_phone_area_code = ' || p_phone_area_code || ' ' ||
1961: 'primary_phone_number = ' || p_phone_number || ' ' ||
1962: 'primary_phone_extension = ' || p_phone_extension ,
1963: p_prefix =>l_debug_prefix,
1964: p_msg_level=>fnd_log.level_statement);
1965: END IF;
1966:
1967:
1968: IF p_contact_point_type = 'WEB' THEN

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

2007: WHERE party_id = p_party_id;
2008: END IF;
2009:
2010: -- Debug info.
2011: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2012: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (-)',
2013: p_prefix=>l_debug_prefix,
2014: p_msg_level=>fnd_log.level_procedure);
2015: END IF;

Line 2014: p_msg_level=>fnd_log.level_procedure);

2010: -- Debug info.
2011: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2012: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (-)',
2013: p_prefix=>l_debug_prefix,
2014: p_msg_level=>fnd_log.level_procedure);
2015: END IF;
2016:
2017: END do_denormalize_contact_point;
2018:

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

2054: l_debug_prefix VARCHAR2(30) := '';
2055: BEGIN
2056:
2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'do_unset_primary_by_purpose (+)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;

Line 2061: p_msg_level=>fnd_log.level_procedure);

2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'do_unset_primary_by_purpose (+)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;
2063:
2064: -- Check during insert.
2065: IF p_contact_point_id IS NULL THEN

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

2085: -- AND content_source_type = hz_party_v2pub.g_miss_content_source_type
2086: AND primary_by_purpose = 'Y';
2087:
2088: -- Debug info.
2089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2090: hz_utility_v2pub.debug(p_message=>'do_unset_primary_by_purpose (-)',
2091: p_prefix=>l_debug_prefix,
2092: p_msg_level=>fnd_log.level_procedure);
2093: END IF;

Line 2092: p_msg_level=>fnd_log.level_procedure);

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

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

2126:
2127: BEGIN
2128:
2129: -- Debug info.
2130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2131: hz_utility_v2pub.debug(p_message=>'filter_phone_number (+)',
2132: p_prefix=>l_debug_prefix,
2133: p_msg_level=>fnd_log.level_procedure);
2134: END IF;

Line 2133: p_msg_level=>fnd_log.level_procedure);

2129: -- Debug info.
2130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2131: hz_utility_v2pub.debug(p_message=>'filter_phone_number (+)',
2132: p_prefix=>l_debug_prefix,
2133: p_msg_level=>fnd_log.level_procedure);
2134: END IF;
2135:
2136: IF p_isformat = 0 THEN
2137: l_filtered_number := TRANSLATE (

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

2145: '9');
2146: END IF;
2147:
2148: -- Debug info.
2149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'filter_phone_number (-)',
2151: p_prefix=>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_procedure);
2153: END IF;

Line 2152: p_msg_level=>fnd_log.level_procedure);

2148: -- Debug info.
2149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'filter_phone_number (-)',
2151: p_prefix=>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_procedure);
2153: END IF;
2154:
2155: RETURN l_filtered_number;
2156:

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

2208:
2209: BEGIN
2210:
2211: -- Debug info.
2212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2213: hz_utility_v2pub.debug(p_message=>'get_phone_format (+)',
2214: p_prefix=>l_debug_prefix,
2215: p_msg_level=>fnd_log.level_procedure);
2216: END IF;

Line 2215: p_msg_level=>fnd_log.level_procedure);

2211: -- Debug info.
2212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2213: hz_utility_v2pub.debug(p_message=>'get_phone_format (+)',
2214: p_prefix=>l_debug_prefix,
2215: p_msg_level=>fnd_log.level_procedure);
2216: END IF;
2217:
2218: -- Initialize return variables
2219: x_phone_format_style := fnd_api.g_miss_char;

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

2278: x_msg := 'HZ_PHONE_FORMAT_NOT_DEFINED';
2279: END IF;
2280:
2281: -- Debug info.
2282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug(p_message=>'get_phone_format (-)',
2284: p_prefix=>l_debug_prefix,
2285: p_msg_level=>fnd_log.level_procedure);
2286: END IF;

Line 2285: p_msg_level=>fnd_log.level_procedure);

2281: -- Debug info.
2282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug(p_message=>'get_phone_format (-)',
2284: p_prefix=>l_debug_prefix,
2285: p_msg_level=>fnd_log.level_procedure);
2286: END IF;
2287:
2288: EXCEPTION
2289: WHEN OTHERS THEN

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

2334:
2335: BEGIN
2336:
2337: -- Debug info.
2338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2339: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (+)',
2340: p_prefix=>l_debug_prefix,
2341: p_msg_level=>fnd_log.level_procedure);
2342: END IF;

Line 2341: p_msg_level=>fnd_log.level_procedure);

2337: -- Debug info.
2338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2339: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (+)',
2340: p_prefix=>l_debug_prefix,
2341: p_msg_level=>fnd_log.level_procedure);
2342: END IF;
2343:
2344: l_format_length := LENGTHB(p_phone_format_style);
2345: x_formatted_phone_number := '';

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

2364: x_phone_area_code := SUBSTRB(p_raw_phone_number, 1, p_area_code_size);
2365: x_phone_number := SUBSTRB(p_raw_phone_number, p_area_code_size + 1);
2366:
2367: -- Debug info.
2368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2369: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (-)',
2370: p_prefix=>l_debug_prefix,
2371: p_msg_level=>fnd_log.level_procedure);
2372: END IF;

Line 2371: p_msg_level=>fnd_log.level_procedure);

2367: -- Debug info.
2368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2369: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (-)',
2370: p_prefix=>l_debug_prefix,
2371: p_msg_level=>fnd_log.level_procedure);
2372: END IF;
2373:
2374: END translate_raw_phone_number;
2375:

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

2434: l_debug_prefix VARCHAR2(30) := '';
2435: BEGIN
2436: -- Debug info.
2437:
2438: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2439: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (+)',
2440: p_prefix=>l_debug_prefix,
2441: p_msg_level=>fnd_log.level_procedure);
2442: END IF;

Line 2441: p_msg_level=>fnd_log.level_procedure);

2437:
2438: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2439: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (+)',
2440: p_prefix=>l_debug_prefix,
2441: p_msg_level=>fnd_log.level_procedure);
2442: END IF;
2443:
2444: -- Initialize message list if p_init_msg_list is set to TRUE.
2445: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

2460:
2461: x_contact_point_rec.contact_point_id := p_contact_point_id;
2462:
2463: -- Debug info.
2464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Select_Row (+)',
2466: p_prefix=>l_debug_prefix,
2467: p_msg_level=>fnd_log.level_procedure);
2468: END IF;

Line 2467: p_msg_level=>fnd_log.level_procedure);

2463: -- Debug info.
2464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Select_Row (+)',
2466: p_prefix=>l_debug_prefix,
2467: p_msg_level=>fnd_log.level_procedure);
2468: END IF;
2469:
2470: -- Call table-handler
2471: hz_contact_points_pkg.select_row (

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

2532: x_actual_content_source => x_contact_point_rec.actual_content_source
2533: );
2534:
2535: -- Debug info.
2536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2537: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Select_Row (-)',
2538: p_prefix=>l_debug_prefix,
2539: p_msg_level=>fnd_log.level_procedure);
2540: END IF;

Line 2539: p_msg_level=>fnd_log.level_procedure);

2535: -- Debug info.
2536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2537: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Select_Row (-)',
2538: p_prefix=>l_debug_prefix,
2539: p_msg_level=>fnd_log.level_procedure);
2540: END IF;
2541:
2542: -- Standard call to get message count and if count is 1, get message info.
2543: fnd_msg_pub.count_and_get(

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

2546: p_data => x_msg_data);
2547:
2548: -- Debug info.
2549:
2550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2551: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (-)',
2552: p_prefix=>l_debug_prefix,
2553: p_msg_level=>fnd_log.level_procedure);
2554: END IF;

Line 2553: p_msg_level=>fnd_log.level_procedure);

2549:
2550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2551: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (-)',
2552: p_prefix=>l_debug_prefix,
2553: p_msg_level=>fnd_log.level_procedure);
2554: END IF;
2555: END get_contact_point_main;
2556:
2557: --

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

2627: l_debug_prefix VARCHAR2(30) := '';
2628:
2629: BEGIN
2630: -- Debug info.
2631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2632: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (+)',
2633: p_prefix=>l_debug_prefix,
2634: p_msg_level=>fnd_log.level_procedure);
2635: END IF;

Line 2634: p_msg_level=>fnd_log.level_procedure);

2630: -- Debug info.
2631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2632: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (+)',
2633: p_prefix=>l_debug_prefix,
2634: p_msg_level=>fnd_log.level_procedure);
2635: END IF;
2636:
2637: -- Initialize message list if p_init_msg_list is set to TRUE.
2638: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

2767: p_count => x_msg_count,
2768: p_data => x_msg_data);
2769:
2770: -- Debug info.
2771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2772: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (-)',
2773: p_prefix=>l_debug_prefix,
2774: p_msg_level=>fnd_log.level_procedure);
2775: END IF;

Line 2774: p_msg_level=>fnd_log.level_procedure);

2770: -- Debug info.
2771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2772: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (-)',
2773: p_prefix=>l_debug_prefix,
2774: p_msg_level=>fnd_log.level_procedure);
2775: END IF;
2776: END create_contact_point_main;
2777:
2778: --

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

2867: l_debug_prefix VARCHAR2(30) := '';
2868:
2869: BEGIN
2870: -- Debug info.
2871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2872: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (+)',
2873: p_prefix=>l_debug_prefix,
2874: p_msg_level=>fnd_log.level_procedure);
2875: END IF;

Line 2874: p_msg_level=>fnd_log.level_procedure);

2870: -- Debug info.
2871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2872: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (+)',
2873: p_prefix=>l_debug_prefix,
2874: p_msg_level=>fnd_log.level_procedure);
2875: END IF;
2876:
2877: -- Initialize message list if p_init_msg_list is set to TRUE.
2878: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

3098: p_count => x_msg_count,
3099: p_data => x_msg_data);
3100:
3101: -- Debug info.
3102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3103: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (-)',
3104: p_prefix=>l_debug_prefix,
3105: p_msg_level=>fnd_log.level_procedure);
3106: END IF;

Line 3105: p_msg_level=>fnd_log.level_procedure);

3101: -- Debug info.
3102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3103: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (-)',
3104: p_prefix=>l_debug_prefix,
3105: p_msg_level=>fnd_log.level_procedure);
3106: END IF;
3107: END update_contact_point_main;
3108:
3109: --------------------------------------

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

3173: -- Check if API is called in debug mode. If yes, enable debug.
3174: --enable_debug;
3175:
3176: -- Debug info.
3177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3178: hz_utility_v2pub.debug(p_message=>'create_contact_point (+)',
3179: p_prefix=>l_debug_prefix,
3180: p_msg_level=>fnd_log.level_procedure);
3181: END IF;

Line 3180: p_msg_level=>fnd_log.level_procedure);

3176: -- Debug info.
3177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3178: hz_utility_v2pub.debug(p_message=>'create_contact_point (+)',
3179: p_prefix=>l_debug_prefix,
3180: p_msg_level=>fnd_log.level_procedure);
3181: END IF;
3182:
3183: -- Call to the main business logic.
3184: create_contact_point_main(

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

3195: x_msg_data => x_msg_data
3196: );
3197:
3198: -- Debug info.
3199: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3200: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3201: p_msg_data=>x_msg_data,
3202: p_msg_type=>'WARNING',
3203: p_msg_level=>fnd_log.level_exception);

Line 3203: p_msg_level=>fnd_log.level_exception);

3199: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3200: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3201: p_msg_data=>x_msg_data,
3202: p_msg_type=>'WARNING',
3203: p_msg_level=>fnd_log.level_exception);
3204: END IF;
3205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3206: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3207: p_prefix=>l_debug_prefix,

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

3201: p_msg_data=>x_msg_data,
3202: p_msg_type=>'WARNING',
3203: p_msg_level=>fnd_log.level_exception);
3204: END IF;
3205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3206: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3207: p_prefix=>l_debug_prefix,
3208: p_msg_level=>fnd_log.level_procedure);
3209: END IF;

Line 3208: p_msg_level=>fnd_log.level_procedure);

3204: END IF;
3205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3206: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3207: p_prefix=>l_debug_prefix,
3208: p_msg_level=>fnd_log.level_procedure);
3209: END IF;
3210:
3211: -- Check if API is called in debug mode. If yes, disable debug.
3212: --disable_debug;

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

3220: p_count => x_msg_count,
3221: p_data => x_msg_data);
3222:
3223: -- Debug info.
3224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3226: p_msg_data=>x_msg_data,
3227: p_msg_type=>'ERROR',
3228: p_msg_level=>fnd_log.level_error);

Line 3228: p_msg_level=>fnd_log.level_error);

3224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3226: p_msg_data=>x_msg_data,
3227: p_msg_type=>'ERROR',
3228: p_msg_level=>fnd_log.level_error);
3229: END IF;
3230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3231: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3232: p_prefix=>l_debug_prefix,

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

3226: p_msg_data=>x_msg_data,
3227: p_msg_type=>'ERROR',
3228: p_msg_level=>fnd_log.level_error);
3229: END IF;
3230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3231: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3232: p_prefix=>l_debug_prefix,
3233: p_msg_level=>fnd_log.level_procedure);
3234: END IF;

Line 3233: p_msg_level=>fnd_log.level_procedure);

3229: END IF;
3230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3231: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3232: p_prefix=>l_debug_prefix,
3233: p_msg_level=>fnd_log.level_procedure);
3234: END IF;
3235:
3236:
3237: -- Check if API is called in debug mode. If yes, disable debug.

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

3245: p_count => x_msg_count,
3246: p_data => x_msg_data);
3247:
3248: -- Debug info.
3249: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3250: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3251: p_msg_data=>x_msg_data,
3252: p_msg_type=>'UNEXPECTED ERROR',
3253: p_msg_level=>fnd_log.level_error);

Line 3253: p_msg_level=>fnd_log.level_error);

3249: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3250: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3251: p_msg_data=>x_msg_data,
3252: p_msg_type=>'UNEXPECTED ERROR',
3253: p_msg_level=>fnd_log.level_error);
3254: END IF;
3255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3256: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3257: p_prefix=>l_debug_prefix,

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

3251: p_msg_data=>x_msg_data,
3252: p_msg_type=>'UNEXPECTED ERROR',
3253: p_msg_level=>fnd_log.level_error);
3254: END IF;
3255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3256: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3257: p_prefix=>l_debug_prefix,
3258: p_msg_level=>fnd_log.level_procedure);
3259: END IF;

Line 3258: p_msg_level=>fnd_log.level_procedure);

3254: END IF;
3255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3256: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3257: p_prefix=>l_debug_prefix,
3258: p_msg_level=>fnd_log.level_procedure);
3259: END IF;
3260:
3261: -- Check if API is called in debug mode. If yes, disable debug.
3262: --disable_debug;

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

3273: p_count => x_msg_count,
3274: p_data => x_msg_data);
3275:
3276: -- Debug info.
3277: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3278: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3279: p_msg_data=>x_msg_data,
3280: p_msg_type=>'SQL ERROR',
3281: p_msg_level=>fnd_log.level_error);

Line 3281: p_msg_level=>fnd_log.level_error);

3277: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3278: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3279: p_msg_data=>x_msg_data,
3280: p_msg_type=>'SQL ERROR',
3281: p_msg_level=>fnd_log.level_error);
3282: END IF;
3283: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3284: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3285: p_prefix=>l_debug_prefix,

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

3279: p_msg_data=>x_msg_data,
3280: p_msg_type=>'SQL ERROR',
3281: p_msg_level=>fnd_log.level_error);
3282: END IF;
3283: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3284: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3285: p_prefix=>l_debug_prefix,
3286: p_msg_level=>fnd_log.level_procedure);
3287: END IF;

Line 3286: p_msg_level=>fnd_log.level_procedure);

3282: END IF;
3283: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3284: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3285: p_prefix=>l_debug_prefix,
3286: p_msg_level=>fnd_log.level_procedure);
3287: END IF;
3288:
3289: -- Check if API is called in debug mode. If yes, disable debug.
3290: --disable_debug;

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

3344: -- Check if API is called in debug mode. If yes, enable debug.
3345: --enable_debug;
3346:
3347: -- Debug info.
3348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3349: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
3350: p_prefix=>l_debug_prefix,
3351: p_msg_level=>fnd_log.level_procedure);
3352: END IF;

Line 3351: p_msg_level=>fnd_log.level_procedure);

3347: -- Debug info.
3348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3349: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
3350: p_prefix=>l_debug_prefix,
3351: p_msg_level=>fnd_log.level_procedure);
3352: END IF;
3353:
3354: -- Call to the main business logic.
3355: create_contact_point_main(

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

3362: x_msg_data => x_msg_data
3363: );
3364:
3365: -- Debug info.
3366: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3367: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3368: p_msg_data=>x_msg_data,
3369: p_msg_type=>'WARNING',
3370: p_msg_level=>fnd_log.level_exception);

Line 3370: p_msg_level=>fnd_log.level_exception);

3366: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3367: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3368: p_msg_data=>x_msg_data,
3369: p_msg_type=>'WARNING',
3370: p_msg_level=>fnd_log.level_exception);
3371: END IF;
3372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3373: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3374: p_prefix=>l_debug_prefix,

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

3368: p_msg_data=>x_msg_data,
3369: p_msg_type=>'WARNING',
3370: p_msg_level=>fnd_log.level_exception);
3371: END IF;
3372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3373: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3374: p_prefix=>l_debug_prefix,
3375: p_msg_level=>fnd_log.level_procedure);
3376: END IF;

Line 3375: p_msg_level=>fnd_log.level_procedure);

3371: END IF;
3372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3373: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3374: p_prefix=>l_debug_prefix,
3375: p_msg_level=>fnd_log.level_procedure);
3376: END IF;
3377:
3378: -- Check if API is called in debug mode. If yes, disable debug.
3379: --disable_debug;

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

3387: p_count => x_msg_count,
3388: p_data => x_msg_data);
3389:
3390: -- Debug info.
3391: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3392: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3393: p_msg_data=>x_msg_data,
3394: p_msg_type=>'ERROR',
3395: p_msg_level=>fnd_log.level_error);

Line 3395: p_msg_level=>fnd_log.level_error);

3391: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3392: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3393: p_msg_data=>x_msg_data,
3394: p_msg_type=>'ERROR',
3395: p_msg_level=>fnd_log.level_error);
3396: END IF;
3397: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3398: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3399: p_prefix=>l_debug_prefix,

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

3393: p_msg_data=>x_msg_data,
3394: p_msg_type=>'ERROR',
3395: p_msg_level=>fnd_log.level_error);
3396: END IF;
3397: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3398: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3399: p_prefix=>l_debug_prefix,
3400: p_msg_level=>fnd_log.level_procedure);
3401: END IF;

Line 3400: p_msg_level=>fnd_log.level_procedure);

3396: END IF;
3397: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3398: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3399: p_prefix=>l_debug_prefix,
3400: p_msg_level=>fnd_log.level_procedure);
3401: END IF;
3402:
3403: -- Check if API is called in debug mode. If yes, disable debug.
3404: --disable_debug;

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

3411: p_count => x_msg_count,
3412: p_data => x_msg_data);
3413:
3414: -- Debug info.
3415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3417: p_msg_data=>x_msg_data,
3418: p_msg_type=>'UNEXPECTED ERROR',
3419: p_msg_level=>fnd_log.level_error);

Line 3419: p_msg_level=>fnd_log.level_error);

3415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3417: p_msg_data=>x_msg_data,
3418: p_msg_type=>'UNEXPECTED ERROR',
3419: p_msg_level=>fnd_log.level_error);
3420: END IF;
3421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3422: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3423: p_prefix=>l_debug_prefix,

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

3417: p_msg_data=>x_msg_data,
3418: p_msg_type=>'UNEXPECTED ERROR',
3419: p_msg_level=>fnd_log.level_error);
3420: END IF;
3421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3422: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3423: p_prefix=>l_debug_prefix,
3424: p_msg_level=>fnd_log.level_procedure);
3425: END IF;

Line 3424: p_msg_level=>fnd_log.level_procedure);

3420: END IF;
3421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3422: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3423: p_prefix=>l_debug_prefix,
3424: p_msg_level=>fnd_log.level_procedure);
3425: END IF;
3426:
3427: -- Check if API is called in debug mode. If yes, disable debug.
3428: --disable_debug;

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

3439: p_count => x_msg_count,
3440: p_data => x_msg_data);
3441:
3442: -- Debug info.
3443: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3444: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3445: p_msg_data=>x_msg_data,
3446: p_msg_type=>'SQL ERROR',
3447: p_msg_level=>fnd_log.level_error);

Line 3447: p_msg_level=>fnd_log.level_error);

3443: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3444: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3445: p_msg_data=>x_msg_data,
3446: p_msg_type=>'SQL ERROR',
3447: p_msg_level=>fnd_log.level_error);
3448: END IF;
3449: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3450: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3451: p_prefix=>l_debug_prefix,

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

3445: p_msg_data=>x_msg_data,
3446: p_msg_type=>'SQL ERROR',
3447: p_msg_level=>fnd_log.level_error);
3448: END IF;
3449: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3450: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3451: p_prefix=>l_debug_prefix,
3452: p_msg_level=>fnd_log.level_procedure);
3453: END IF;

Line 3452: p_msg_level=>fnd_log.level_procedure);

3448: END IF;
3449: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3450: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3451: p_prefix=>l_debug_prefix,
3452: p_msg_level=>fnd_log.level_procedure);
3453: END IF;
3454:
3455: -- Check if API is called in debug mode. If yes, disable debug.
3456: --disable_debug;

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

3510: -- Check if API is called in debug mode. If yes, enable debug.
3511: --enable_debug;
3512:
3513: -- Debug info.
3514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3515: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
3516: p_prefix=>l_debug_prefix,
3517: p_msg_level=>fnd_log.level_procedure);
3518: END IF;

Line 3517: p_msg_level=>fnd_log.level_procedure);

3513: -- Debug info.
3514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3515: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
3516: p_prefix=>l_debug_prefix,
3517: p_msg_level=>fnd_log.level_procedure);
3518: END IF;
3519:
3520: -- Call to the main business logic.
3521: create_contact_point_main(

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

3528: x_msg_data => x_msg_data
3529: );
3530:
3531: -- Debug info.
3532: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3533: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3534: p_msg_data=>x_msg_data,
3535: p_msg_type=>'WARNING',
3536: p_msg_level=>fnd_log.level_exception);

Line 3536: p_msg_level=>fnd_log.level_exception);

3532: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3533: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3534: p_msg_data=>x_msg_data,
3535: p_msg_type=>'WARNING',
3536: p_msg_level=>fnd_log.level_exception);
3537: END IF;
3538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3539: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3540: p_prefix=>l_debug_prefix,

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

3534: p_msg_data=>x_msg_data,
3535: p_msg_type=>'WARNING',
3536: p_msg_level=>fnd_log.level_exception);
3537: END IF;
3538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3539: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3540: p_prefix=>l_debug_prefix,
3541: p_msg_level=>fnd_log.level_procedure);
3542: END IF;

Line 3541: p_msg_level=>fnd_log.level_procedure);

3537: END IF;
3538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3539: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3540: p_prefix=>l_debug_prefix,
3541: p_msg_level=>fnd_log.level_procedure);
3542: END IF;
3543:
3544: -- Check if API is called in debug mode. If yes, disable debug.
3545: --disable_debug;

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

3553: p_count => x_msg_count,
3554: p_data => x_msg_data);
3555:
3556: -- Debug info.
3557: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3558: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3559: p_msg_data=>x_msg_data,
3560: p_msg_type=>'ERROR',
3561: p_msg_level=>fnd_log.level_error);

Line 3561: p_msg_level=>fnd_log.level_error);

3557: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3558: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3559: p_msg_data=>x_msg_data,
3560: p_msg_type=>'ERROR',
3561: p_msg_level=>fnd_log.level_error);
3562: END IF;
3563: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3564: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3565: p_prefix=>l_debug_prefix,

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

3559: p_msg_data=>x_msg_data,
3560: p_msg_type=>'ERROR',
3561: p_msg_level=>fnd_log.level_error);
3562: END IF;
3563: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3564: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3565: p_prefix=>l_debug_prefix,
3566: p_msg_level=>fnd_log.level_procedure);
3567: END IF;

Line 3566: p_msg_level=>fnd_log.level_procedure);

3562: END IF;
3563: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3564: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3565: p_prefix=>l_debug_prefix,
3566: p_msg_level=>fnd_log.level_procedure);
3567: END IF;
3568:
3569: -- Check if API is called in debug mode. If yes, disable debug.
3570: --disable_debug;

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

3577: p_count => x_msg_count,
3578: p_data => x_msg_data);
3579:
3580: -- Debug info.
3581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3582: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3583: p_msg_data=>x_msg_data,
3584: p_msg_type=>'UNEXPECTED ERROR',
3585: p_msg_level=>fnd_log.level_error);

Line 3585: p_msg_level=>fnd_log.level_error);

3581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3582: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3583: p_msg_data=>x_msg_data,
3584: p_msg_type=>'UNEXPECTED ERROR',
3585: p_msg_level=>fnd_log.level_error);
3586: END IF;
3587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3588: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3589: p_prefix=>l_debug_prefix,

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

3583: p_msg_data=>x_msg_data,
3584: p_msg_type=>'UNEXPECTED ERROR',
3585: p_msg_level=>fnd_log.level_error);
3586: END IF;
3587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3588: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3589: p_prefix=>l_debug_prefix,
3590: p_msg_level=>fnd_log.level_procedure);
3591: END IF;

Line 3590: p_msg_level=>fnd_log.level_procedure);

3586: END IF;
3587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3588: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3589: p_prefix=>l_debug_prefix,
3590: p_msg_level=>fnd_log.level_procedure);
3591: END IF;
3592:
3593: -- Check if API is called in debug mode. If yes, disable debug.
3594: --disable_debug;

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

3605: p_count => x_msg_count,
3606: p_data => x_msg_data);
3607:
3608: -- Debug info.
3609: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3610: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3611: p_msg_data=>x_msg_data,
3612: p_msg_type=>'SQL ERROR',
3613: p_msg_level=>fnd_log.level_error);

Line 3613: p_msg_level=>fnd_log.level_error);

3609: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3610: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3611: p_msg_data=>x_msg_data,
3612: p_msg_type=>'SQL ERROR',
3613: p_msg_level=>fnd_log.level_error);
3614: END IF;
3615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3616: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3617: p_prefix=>l_debug_prefix,

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

3611: p_msg_data=>x_msg_data,
3612: p_msg_type=>'SQL ERROR',
3613: p_msg_level=>fnd_log.level_error);
3614: END IF;
3615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3616: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3617: p_prefix=>l_debug_prefix,
3618: p_msg_level=>fnd_log.level_procedure);
3619: END IF;

Line 3618: p_msg_level=>fnd_log.level_procedure);

3614: END IF;
3615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3616: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3617: p_prefix=>l_debug_prefix,
3618: p_msg_level=>fnd_log.level_procedure);
3619: END IF;
3620:
3621: -- Check if API is called in debug mode. If yes, disable debug.
3622: --disable_debug;

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

3678: -- Check if API is called in debug mode. If yes, enable debug.
3679: --enable_debug;
3680:
3681: -- Debug info.
3682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3683: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
3684: p_prefix=>l_debug_prefix,
3685: p_msg_level=>fnd_log.level_procedure);
3686: END IF;

Line 3685: p_msg_level=>fnd_log.level_procedure);

3681: -- Debug info.
3682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3683: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
3684: p_prefix=>l_debug_prefix,
3685: p_msg_level=>fnd_log.level_procedure);
3686: END IF;
3687:
3688: -- Call to the main business logic.
3689: create_contact_point_main(

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

3696: x_msg_data => x_msg_data
3697: );
3698:
3699: -- Debug info.
3700: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3701: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3702: p_msg_data=>x_msg_data,
3703: p_msg_type=>'WARNING',
3704: p_msg_level=>fnd_log.level_exception);

Line 3704: p_msg_level=>fnd_log.level_exception);

3700: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3701: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3702: p_msg_data=>x_msg_data,
3703: p_msg_type=>'WARNING',
3704: p_msg_level=>fnd_log.level_exception);
3705: END IF;
3706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3707: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3708: p_prefix=>l_debug_prefix,

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

3702: p_msg_data=>x_msg_data,
3703: p_msg_type=>'WARNING',
3704: p_msg_level=>fnd_log.level_exception);
3705: END IF;
3706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3707: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3708: p_prefix=>l_debug_prefix,
3709: p_msg_level=>fnd_log.level_procedure);
3710: END IF;

Line 3709: p_msg_level=>fnd_log.level_procedure);

3705: END IF;
3706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3707: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3708: p_prefix=>l_debug_prefix,
3709: p_msg_level=>fnd_log.level_procedure);
3710: END IF;
3711:
3712:
3713: -- Check if API is called in debug mode. If yes, disable debug.

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

3722: p_count => x_msg_count,
3723: p_data => x_msg_data);
3724:
3725: -- Debug info.
3726: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3727: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3728: p_msg_data=>x_msg_data,
3729: p_msg_type=>'ERROR',
3730: p_msg_level=>fnd_log.level_error);

Line 3730: p_msg_level=>fnd_log.level_error);

3726: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3727: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3728: p_msg_data=>x_msg_data,
3729: p_msg_type=>'ERROR',
3730: p_msg_level=>fnd_log.level_error);
3731: END IF;
3732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3733: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3734: p_prefix=>l_debug_prefix,

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

3728: p_msg_data=>x_msg_data,
3729: p_msg_type=>'ERROR',
3730: p_msg_level=>fnd_log.level_error);
3731: END IF;
3732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3733: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3734: p_prefix=>l_debug_prefix,
3735: p_msg_level=>fnd_log.level_procedure);
3736: END IF;

Line 3735: p_msg_level=>fnd_log.level_procedure);

3731: END IF;
3732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3733: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3734: p_prefix=>l_debug_prefix,
3735: p_msg_level=>fnd_log.level_procedure);
3736: END IF;
3737:
3738: -- Check if API is called in debug mode. If yes, disable debug.
3739: --disable_debug;

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

3746: p_count => x_msg_count,
3747: p_data => x_msg_data);
3748:
3749: -- Debug info.
3750: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3751: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3752: p_msg_data=>x_msg_data,
3753: p_msg_type=>'UNEXPECTED ERROR',
3754: p_msg_level=>fnd_log.level_error);

Line 3754: p_msg_level=>fnd_log.level_error);

3750: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3751: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3752: p_msg_data=>x_msg_data,
3753: p_msg_type=>'UNEXPECTED ERROR',
3754: p_msg_level=>fnd_log.level_error);
3755: END IF;
3756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3757: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3758: p_prefix=>l_debug_prefix,

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

3752: p_msg_data=>x_msg_data,
3753: p_msg_type=>'UNEXPECTED ERROR',
3754: p_msg_level=>fnd_log.level_error);
3755: END IF;
3756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3757: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3758: p_prefix=>l_debug_prefix,
3759: p_msg_level=>fnd_log.level_procedure);
3760: END IF;

Line 3759: p_msg_level=>fnd_log.level_procedure);

3755: END IF;
3756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3757: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3758: p_prefix=>l_debug_prefix,
3759: p_msg_level=>fnd_log.level_procedure);
3760: END IF;
3761:
3762: -- Check if API is called in debug mode. If yes, disable debug.
3763: --disable_debug;

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

3774: p_count => x_msg_count,
3775: p_data => x_msg_data);
3776:
3777: -- Debug info.
3778: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3779: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3780: p_msg_data=>x_msg_data,
3781: p_msg_type=>'SQL ERROR',
3782: p_msg_level=>fnd_log.level_error);

Line 3782: p_msg_level=>fnd_log.level_error);

3778: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3779: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3780: p_msg_data=>x_msg_data,
3781: p_msg_type=>'SQL ERROR',
3782: p_msg_level=>fnd_log.level_error);
3783: END IF;
3784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3785: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3786: p_prefix=>l_debug_prefix,

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

3780: p_msg_data=>x_msg_data,
3781: p_msg_type=>'SQL ERROR',
3782: p_msg_level=>fnd_log.level_error);
3783: END IF;
3784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3785: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3786: p_prefix=>l_debug_prefix,
3787: p_msg_level=>fnd_log.level_procedure);
3788: END IF;

Line 3787: p_msg_level=>fnd_log.level_procedure);

3783: END IF;
3784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3785: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3786: p_prefix=>l_debug_prefix,
3787: p_msg_level=>fnd_log.level_procedure);
3788: END IF;
3789:
3790: -- Check if API is called in debug mode. If yes, disable debug.
3791: --disable_debug;

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

3845: -- Check if API is called in debug mode. If yes, enable debug.
3846: --enable_debug;
3847:
3848: -- Debug info.
3849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3850: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
3851: p_prefix=>l_debug_prefix,
3852: p_msg_level=>fnd_log.level_procedure);
3853: END IF;

Line 3852: p_msg_level=>fnd_log.level_procedure);

3848: -- Debug info.
3849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3850: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
3851: p_prefix=>l_debug_prefix,
3852: p_msg_level=>fnd_log.level_procedure);
3853: END IF;
3854:
3855:
3856: -- Call to the main business logic.

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

3864: x_msg_data => x_msg_data
3865: );
3866:
3867: -- Debug info.
3868: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3870: p_msg_data=>x_msg_data,
3871: p_msg_type=>'WARNING',
3872: p_msg_level=>fnd_log.level_exception);

Line 3872: p_msg_level=>fnd_log.level_exception);

3868: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3870: p_msg_data=>x_msg_data,
3871: p_msg_type=>'WARNING',
3872: p_msg_level=>fnd_log.level_exception);
3873: END IF;
3874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3875: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3876: p_prefix=>l_debug_prefix,

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

3870: p_msg_data=>x_msg_data,
3871: p_msg_type=>'WARNING',
3872: p_msg_level=>fnd_log.level_exception);
3873: END IF;
3874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3875: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3876: p_prefix=>l_debug_prefix,
3877: p_msg_level=>fnd_log.level_procedure);
3878: END IF;

Line 3877: p_msg_level=>fnd_log.level_procedure);

3873: END IF;
3874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3875: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3876: p_prefix=>l_debug_prefix,
3877: p_msg_level=>fnd_log.level_procedure);
3878: END IF;
3879:
3880: -- Check if API is called in debug mode. If yes, disable debug.
3881: --disable_debug;

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

3889: p_count => x_msg_count,
3890: p_data => x_msg_data);
3891:
3892: -- Debug info.
3893: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3894: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3895: p_msg_data=>x_msg_data,
3896: p_msg_type=>'ERROR',
3897: p_msg_level=>fnd_log.level_error);

Line 3897: p_msg_level=>fnd_log.level_error);

3893: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3894: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3895: p_msg_data=>x_msg_data,
3896: p_msg_type=>'ERROR',
3897: p_msg_level=>fnd_log.level_error);
3898: END IF;
3899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3900: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3901: p_prefix=>l_debug_prefix,

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

3895: p_msg_data=>x_msg_data,
3896: p_msg_type=>'ERROR',
3897: p_msg_level=>fnd_log.level_error);
3898: END IF;
3899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3900: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3901: p_prefix=>l_debug_prefix,
3902: p_msg_level=>fnd_log.level_procedure);
3903: END IF;

Line 3902: p_msg_level=>fnd_log.level_procedure);

3898: END IF;
3899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3900: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3901: p_prefix=>l_debug_prefix,
3902: p_msg_level=>fnd_log.level_procedure);
3903: END IF;
3904:
3905: -- Check if API is called in debug mode. If yes, disable debug.
3906: --disable_debug;

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

3913: p_count => x_msg_count,
3914: p_data => x_msg_data);
3915:
3916: -- Debug info.
3917: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3919: p_msg_data=>x_msg_data,
3920: p_msg_type=>'UNEXPECTED ERROR',
3921: p_msg_level=>fnd_log.level_error);

Line 3921: p_msg_level=>fnd_log.level_error);

3917: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3919: p_msg_data=>x_msg_data,
3920: p_msg_type=>'UNEXPECTED ERROR',
3921: p_msg_level=>fnd_log.level_error);
3922: END IF;
3923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3924: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3925: p_prefix=>l_debug_prefix,

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

3919: p_msg_data=>x_msg_data,
3920: p_msg_type=>'UNEXPECTED ERROR',
3921: p_msg_level=>fnd_log.level_error);
3922: END IF;
3923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3924: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3925: p_prefix=>l_debug_prefix,
3926: p_msg_level=>fnd_log.level_procedure);
3927: END IF;

Line 3926: p_msg_level=>fnd_log.level_procedure);

3922: END IF;
3923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3924: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3925: p_prefix=>l_debug_prefix,
3926: p_msg_level=>fnd_log.level_procedure);
3927: END IF;
3928:
3929: -- Check if API is called in debug mode. If yes, disable debug.
3930: --disable_debug;

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

3941: p_count => x_msg_count,
3942: p_data => x_msg_data);
3943:
3944: -- Debug info.
3945: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3947: p_msg_data=>x_msg_data,
3948: p_msg_type=>'SQL ERROR',
3949: p_msg_level=>fnd_log.level_error);

Line 3949: p_msg_level=>fnd_log.level_error);

3945: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3947: p_msg_data=>x_msg_data,
3948: p_msg_type=>'SQL ERROR',
3949: p_msg_level=>fnd_log.level_error);
3950: END IF;
3951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3952: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3953: p_prefix=>l_debug_prefix,

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

3947: p_msg_data=>x_msg_data,
3948: p_msg_type=>'SQL ERROR',
3949: p_msg_level=>fnd_log.level_error);
3950: END IF;
3951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3952: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3953: p_prefix=>l_debug_prefix,
3954: p_msg_level=>fnd_log.level_procedure);
3955: END IF;

Line 3954: p_msg_level=>fnd_log.level_procedure);

3950: END IF;
3951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3952: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
3953: p_prefix=>l_debug_prefix,
3954: p_msg_level=>fnd_log.level_procedure);
3955: END IF;
3956:
3957: -- Check if API is called in debug mode. If yes, disable debug.
3958: --disable_debug;

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

4012: -- Check if API is called in debug mode. If yes, enable debug.
4013: --enable_debug;
4014:
4015: -- Debug info.
4016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4017: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
4018: p_prefix=>l_debug_prefix,
4019: p_msg_level=>fnd_log.level_procedure);
4020: END IF;

Line 4019: p_msg_level=>fnd_log.level_procedure);

4015: -- Debug info.
4016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4017: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
4018: p_prefix=>l_debug_prefix,
4019: p_msg_level=>fnd_log.level_procedure);
4020: END IF;
4021:
4022: -- Call to the main business logic.
4023: create_contact_point_main(

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

4030: x_msg_data => x_msg_data
4031: );
4032:
4033: -- Debug info.
4034: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4035: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4036: p_msg_data=>x_msg_data,
4037: p_msg_type=>'WARNING',
4038: p_msg_level=>fnd_log.level_exception);

Line 4038: p_msg_level=>fnd_log.level_exception);

4034: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4035: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4036: p_msg_data=>x_msg_data,
4037: p_msg_type=>'WARNING',
4038: p_msg_level=>fnd_log.level_exception);
4039: END IF;
4040: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4041: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4042: p_prefix=>l_debug_prefix,

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

4036: p_msg_data=>x_msg_data,
4037: p_msg_type=>'WARNING',
4038: p_msg_level=>fnd_log.level_exception);
4039: END IF;
4040: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4041: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4042: p_prefix=>l_debug_prefix,
4043: p_msg_level=>fnd_log.level_procedure);
4044: END IF;

Line 4043: p_msg_level=>fnd_log.level_procedure);

4039: END IF;
4040: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4041: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4042: p_prefix=>l_debug_prefix,
4043: p_msg_level=>fnd_log.level_procedure);
4044: END IF;
4045:
4046:
4047: -- Check if API is called in debug mode. If yes, disable debug.

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

4056: p_count => x_msg_count,
4057: p_data => x_msg_data);
4058:
4059: -- Debug info.
4060: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4061: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4062: p_msg_data=>x_msg_data,
4063: p_msg_type=>'ERROR',
4064: p_msg_level=>fnd_log.level_error);

Line 4064: p_msg_level=>fnd_log.level_error);

4060: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4061: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4062: p_msg_data=>x_msg_data,
4063: p_msg_type=>'ERROR',
4064: p_msg_level=>fnd_log.level_error);
4065: END IF;
4066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4067: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4068: p_prefix=>l_debug_prefix,

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

4062: p_msg_data=>x_msg_data,
4063: p_msg_type=>'ERROR',
4064: p_msg_level=>fnd_log.level_error);
4065: END IF;
4066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4067: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4068: p_prefix=>l_debug_prefix,
4069: p_msg_level=>fnd_log.level_procedure);
4070: END IF;

Line 4069: p_msg_level=>fnd_log.level_procedure);

4065: END IF;
4066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4067: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4068: p_prefix=>l_debug_prefix,
4069: p_msg_level=>fnd_log.level_procedure);
4070: END IF;
4071:
4072: -- Check if API is called in debug mode. If yes, disable debug.
4073: --disable_debug;

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

4080: p_count => x_msg_count,
4081: p_data => x_msg_data);
4082:
4083: -- Debug info.
4084: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4085: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4086: p_msg_data=>x_msg_data,
4087: p_msg_type=>'UNEXPECTED ERROR',
4088: p_msg_level=>fnd_log.level_error);

Line 4088: p_msg_level=>fnd_log.level_error);

4084: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4085: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4086: p_msg_data=>x_msg_data,
4087: p_msg_type=>'UNEXPECTED ERROR',
4088: p_msg_level=>fnd_log.level_error);
4089: END IF;
4090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4091: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4092: p_prefix=>l_debug_prefix,

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

4086: p_msg_data=>x_msg_data,
4087: p_msg_type=>'UNEXPECTED ERROR',
4088: p_msg_level=>fnd_log.level_error);
4089: END IF;
4090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4091: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4092: p_prefix=>l_debug_prefix,
4093: p_msg_level=>fnd_log.level_procedure);
4094: END IF;

Line 4093: p_msg_level=>fnd_log.level_procedure);

4089: END IF;
4090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4091: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4092: p_prefix=>l_debug_prefix,
4093: p_msg_level=>fnd_log.level_procedure);
4094: END IF;
4095:
4096: -- Check if API is called in debug mode. If yes, disable debug.
4097: --disable_debug;

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

4108: p_count => x_msg_count,
4109: p_data => x_msg_data);
4110:
4111: -- Debug info.
4112: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4113: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4114: p_msg_data=>x_msg_data,
4115: p_msg_type=>'SQL ERROR',
4116: p_msg_level=>fnd_log.level_error);

Line 4116: p_msg_level=>fnd_log.level_error);

4112: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4113: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4114: p_msg_data=>x_msg_data,
4115: p_msg_type=>'SQL ERROR',
4116: p_msg_level=>fnd_log.level_error);
4117: END IF;
4118: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4119: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4120: p_prefix=>l_debug_prefix,

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

4114: p_msg_data=>x_msg_data,
4115: p_msg_type=>'SQL ERROR',
4116: p_msg_level=>fnd_log.level_error);
4117: END IF;
4118: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4119: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4120: p_prefix=>l_debug_prefix,
4121: p_msg_level=>fnd_log.level_procedure);
4122: END IF;

Line 4121: p_msg_level=>fnd_log.level_procedure);

4117: END IF;
4118: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4119: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4120: p_prefix=>l_debug_prefix,
4121: p_msg_level=>fnd_log.level_procedure);
4122: END IF;
4123:
4124: -- Check if API is called in debug mode. If yes, disable debug.
4125: --disable_debug;

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

4179: -- Check if API is called in debug mode. If yes, enable debug.
4180: --enable_debug;
4181:
4182: -- Debug info.
4183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4184: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
4185: p_prefix=>l_debug_prefix,
4186: p_msg_level=>fnd_log.level_procedure);
4187: END IF;

Line 4186: p_msg_level=>fnd_log.level_procedure);

4182: -- Debug info.
4183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4184: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
4185: p_prefix=>l_debug_prefix,
4186: p_msg_level=>fnd_log.level_procedure);
4187: END IF;
4188:
4189:
4190: -- Call to the main business logic.

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

4198: x_msg_data => x_msg_data
4199: );
4200:
4201: -- Debug info.
4202: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4203: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4204: p_msg_data=>x_msg_data,
4205: p_msg_type=>'WARNING',
4206: p_msg_level=>fnd_log.level_exception);

Line 4206: p_msg_level=>fnd_log.level_exception);

4202: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4203: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4204: p_msg_data=>x_msg_data,
4205: p_msg_type=>'WARNING',
4206: p_msg_level=>fnd_log.level_exception);
4207: END IF;
4208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4209: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4210: p_prefix=>l_debug_prefix,

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

4204: p_msg_data=>x_msg_data,
4205: p_msg_type=>'WARNING',
4206: p_msg_level=>fnd_log.level_exception);
4207: END IF;
4208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4209: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4210: p_prefix=>l_debug_prefix,
4211: p_msg_level=>fnd_log.level_procedure);
4212: END IF;

Line 4211: p_msg_level=>fnd_log.level_procedure);

4207: END IF;
4208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4209: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4210: p_prefix=>l_debug_prefix,
4211: p_msg_level=>fnd_log.level_procedure);
4212: END IF;
4213:
4214: -- Check if API is called in debug mode. If yes, disable debug.
4215: --disable_debug;

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

4223: p_count => x_msg_count,
4224: p_data => x_msg_data);
4225:
4226: -- Debug info.
4227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4229: p_msg_data=>x_msg_data,
4230: p_msg_type=>'ERROR',
4231: p_msg_level=>fnd_log.level_error);

Line 4231: p_msg_level=>fnd_log.level_error);

4227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4229: p_msg_data=>x_msg_data,
4230: p_msg_type=>'ERROR',
4231: p_msg_level=>fnd_log.level_error);
4232: END IF;
4233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4234: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4235: p_prefix=>l_debug_prefix,

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

4229: p_msg_data=>x_msg_data,
4230: p_msg_type=>'ERROR',
4231: p_msg_level=>fnd_log.level_error);
4232: END IF;
4233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4234: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4235: p_prefix=>l_debug_prefix,
4236: p_msg_level=>fnd_log.level_procedure);
4237: END IF;

Line 4236: p_msg_level=>fnd_log.level_procedure);

4232: END IF;
4233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4234: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4235: p_prefix=>l_debug_prefix,
4236: p_msg_level=>fnd_log.level_procedure);
4237: END IF;
4238:
4239: -- Check if API is called in debug mode. If yes, disable debug.
4240: --disable_debug;

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

4247: p_count => x_msg_count,
4248: p_data => x_msg_data);
4249:
4250: -- Debug info.
4251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4253: p_msg_data=>x_msg_data,
4254: p_msg_type=>'UNEXPECTED ERROR',
4255: p_msg_level=>fnd_log.level_error);

Line 4255: p_msg_level=>fnd_log.level_error);

4251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4253: p_msg_data=>x_msg_data,
4254: p_msg_type=>'UNEXPECTED ERROR',
4255: p_msg_level=>fnd_log.level_error);
4256: END IF;
4257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4258: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4259: p_prefix=>l_debug_prefix,

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

4253: p_msg_data=>x_msg_data,
4254: p_msg_type=>'UNEXPECTED ERROR',
4255: p_msg_level=>fnd_log.level_error);
4256: END IF;
4257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4258: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4259: p_prefix=>l_debug_prefix,
4260: p_msg_level=>fnd_log.level_procedure);
4261: END IF;

Line 4260: p_msg_level=>fnd_log.level_procedure);

4256: END IF;
4257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4258: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4259: p_prefix=>l_debug_prefix,
4260: p_msg_level=>fnd_log.level_procedure);
4261: END IF;
4262:
4263: -- Check if API is called in debug mode. If yes, disable debug.
4264: --disable_debug;

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

4275: p_count => x_msg_count,
4276: p_data => x_msg_data);
4277:
4278: -- Debug info.
4279: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4280: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4281: p_msg_data=>x_msg_data,
4282: p_msg_type=>'SQL ERROR',
4283: p_msg_level=>fnd_log.level_error);

Line 4283: p_msg_level=>fnd_log.level_error);

4279: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4280: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4281: p_msg_data=>x_msg_data,
4282: p_msg_type=>'SQL ERROR',
4283: p_msg_level=>fnd_log.level_error);
4284: END IF;
4285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4286: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4287: p_prefix=>l_debug_prefix,

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

4281: p_msg_data=>x_msg_data,
4282: p_msg_type=>'SQL ERROR',
4283: p_msg_level=>fnd_log.level_error);
4284: END IF;
4285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4286: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4287: p_prefix=>l_debug_prefix,
4288: p_msg_level=>fnd_log.level_procedure);
4289: END IF;

Line 4288: p_msg_level=>fnd_log.level_procedure);

4284: END IF;
4285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4286: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4287: p_prefix=>l_debug_prefix,
4288: p_msg_level=>fnd_log.level_procedure);
4289: END IF;
4290:
4291: -- Check if API is called in debug mode. If yes, disable debug.
4292: --disable_debug;

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

4355: -- Check if API is called in debug mode. If yes, enable debug.
4356: --enable_debug;
4357:
4358: -- Debug info.
4359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4360: hz_utility_v2pub.debug(p_message=>'update_contact_point (+)',
4361: p_prefix=>l_debug_prefix,
4362: p_msg_level=>fnd_log.level_procedure);
4363: END IF;

Line 4362: p_msg_level=>fnd_log.level_procedure);

4358: -- Debug info.
4359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4360: hz_utility_v2pub.debug(p_message=>'update_contact_point (+)',
4361: p_prefix=>l_debug_prefix,
4362: p_msg_level=>fnd_log.level_procedure);
4363: END IF;
4364:
4365: -- call main business logic.
4366: update_contact_point_main(

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

4379:
4380: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4381:
4382: -- Debug info.
4383: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4384: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4385: p_msg_data=>x_msg_data,
4386: p_msg_type=>'WARNING',
4387: p_msg_level=>fnd_log.level_exception);

Line 4387: p_msg_level=>fnd_log.level_exception);

4383: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4384: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4385: p_msg_data=>x_msg_data,
4386: p_msg_type=>'WARNING',
4387: p_msg_level=>fnd_log.level_exception);
4388: END IF;
4389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4390: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4391: p_prefix=>l_debug_prefix,

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

4385: p_msg_data=>x_msg_data,
4386: p_msg_type=>'WARNING',
4387: p_msg_level=>fnd_log.level_exception);
4388: END IF;
4389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4390: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4391: p_prefix=>l_debug_prefix,
4392: p_msg_level=>fnd_log.level_procedure);
4393: END IF;

Line 4392: p_msg_level=>fnd_log.level_procedure);

4388: END IF;
4389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4390: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4391: p_prefix=>l_debug_prefix,
4392: p_msg_level=>fnd_log.level_procedure);
4393: END IF;
4394:
4395: -- Check if API is called in debug mode. If yes, disable debug.
4396: --disable_debug;

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

4405: p_count => x_msg_count,
4406: p_data => x_msg_data);
4407:
4408: -- Debug info.
4409: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4410: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4411: p_msg_data=>x_msg_data,
4412: p_msg_type=>'ERROR',
4413: p_msg_level=>fnd_log.level_error);

Line 4413: p_msg_level=>fnd_log.level_error);

4409: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4410: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4411: p_msg_data=>x_msg_data,
4412: p_msg_type=>'ERROR',
4413: p_msg_level=>fnd_log.level_error);
4414: END IF;
4415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4416: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4417: p_prefix=>l_debug_prefix,

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

4411: p_msg_data=>x_msg_data,
4412: p_msg_type=>'ERROR',
4413: p_msg_level=>fnd_log.level_error);
4414: END IF;
4415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4416: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4417: p_prefix=>l_debug_prefix,
4418: p_msg_level=>fnd_log.level_procedure);
4419: END IF;

Line 4418: p_msg_level=>fnd_log.level_procedure);

4414: END IF;
4415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4416: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4417: p_prefix=>l_debug_prefix,
4418: p_msg_level=>fnd_log.level_procedure);
4419: END IF;
4420:
4421: -- Check if API is called in debug mode. If yes, disable debug.
4422: --disable_debug;

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

4430: p_count => x_msg_count,
4431: p_data => x_msg_data);
4432:
4433: -- Debug info.
4434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4436: p_msg_data=>x_msg_data,
4437: p_msg_type=>'UNEXPECTED ERROR',
4438: p_msg_level=>fnd_log.level_error);

Line 4438: p_msg_level=>fnd_log.level_error);

4434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4436: p_msg_data=>x_msg_data,
4437: p_msg_type=>'UNEXPECTED ERROR',
4438: p_msg_level=>fnd_log.level_error);
4439: END IF;
4440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4441: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4442: p_prefix=>l_debug_prefix,

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

4436: p_msg_data=>x_msg_data,
4437: p_msg_type=>'UNEXPECTED ERROR',
4438: p_msg_level=>fnd_log.level_error);
4439: END IF;
4440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4441: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4442: p_prefix=>l_debug_prefix,
4443: p_msg_level=>fnd_log.level_procedure);
4444: END IF;

Line 4443: p_msg_level=>fnd_log.level_procedure);

4439: END IF;
4440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4441: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4442: p_prefix=>l_debug_prefix,
4443: p_msg_level=>fnd_log.level_procedure);
4444: END IF;
4445:
4446: -- Check if API is called in debug mode. If yes, disable debug.
4447: --disable_debug;

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

4459: p_count => x_msg_count,
4460: p_data => x_msg_data);
4461:
4462: -- Debug info.
4463: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4464: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4465: p_msg_data=>x_msg_data,
4466: p_msg_type=>'SQL ERROR',
4467: p_msg_level=>fnd_log.level_error);

Line 4467: p_msg_level=>fnd_log.level_error);

4463: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4464: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4465: p_msg_data=>x_msg_data,
4466: p_msg_type=>'SQL ERROR',
4467: p_msg_level=>fnd_log.level_error);
4468: END IF;
4469: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4470: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4471: p_prefix=>l_debug_prefix,

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

4465: p_msg_data=>x_msg_data,
4466: p_msg_type=>'SQL ERROR',
4467: p_msg_level=>fnd_log.level_error);
4468: END IF;
4469: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4470: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4471: p_prefix=>l_debug_prefix,
4472: p_msg_level=>fnd_log.level_procedure);
4473: END IF;

Line 4472: p_msg_level=>fnd_log.level_procedure);

4468: END IF;
4469: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4470: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4471: p_prefix=>l_debug_prefix,
4472: p_msg_level=>fnd_log.level_procedure);
4473: END IF;
4474:
4475: -- Check if API is called in debug mode. If yes, disable debug.
4476: --disable_debug;

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

4529: -- Check if API is called in debug mode. If yes, enable debug.
4530: --enable_debug;
4531:
4532: -- Debug info.
4533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4534: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
4535: p_prefix=>l_debug_prefix,
4536: p_msg_level=>fnd_log.level_procedure);
4537: END IF;

Line 4536: p_msg_level=>fnd_log.level_procedure);

4532: -- Debug info.
4533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4534: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
4535: p_prefix=>l_debug_prefix,
4536: p_msg_level=>fnd_log.level_procedure);
4537: END IF;
4538:
4539: -- call main business logic.
4540: update_contact_point_main(

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

4547: x_msg_data => x_msg_data
4548: );
4549:
4550: -- Debug info.
4551: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4552: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4553: p_msg_data=>x_msg_data,
4554: p_msg_type=>'WARNING',
4555: p_msg_level=>fnd_log.level_exception);

Line 4555: p_msg_level=>fnd_log.level_exception);

4551: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4552: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4553: p_msg_data=>x_msg_data,
4554: p_msg_type=>'WARNING',
4555: p_msg_level=>fnd_log.level_exception);
4556: END IF;
4557: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4558: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4559: p_prefix=>l_debug_prefix,

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

4553: p_msg_data=>x_msg_data,
4554: p_msg_type=>'WARNING',
4555: p_msg_level=>fnd_log.level_exception);
4556: END IF;
4557: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4558: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4559: p_prefix=>l_debug_prefix,
4560: p_msg_level=>fnd_log.level_procedure);
4561: END IF;

Line 4560: p_msg_level=>fnd_log.level_procedure);

4556: END IF;
4557: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4558: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4559: p_prefix=>l_debug_prefix,
4560: p_msg_level=>fnd_log.level_procedure);
4561: END IF;
4562:
4563: -- Check if API is called in debug mode. If yes, disable debug.
4564: --disable_debug;

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

4572: p_count => x_msg_count,
4573: p_data => x_msg_data);
4574:
4575: -- Debug info.
4576: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4577: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4578: p_msg_data=>x_msg_data,
4579: p_msg_type=>'ERROR',
4580: p_msg_level=>fnd_log.level_error);

Line 4580: p_msg_level=>fnd_log.level_error);

4576: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4577: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4578: p_msg_data=>x_msg_data,
4579: p_msg_type=>'ERROR',
4580: p_msg_level=>fnd_log.level_error);
4581: END IF;
4582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4583: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4584: p_prefix=>l_debug_prefix,

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

4578: p_msg_data=>x_msg_data,
4579: p_msg_type=>'ERROR',
4580: p_msg_level=>fnd_log.level_error);
4581: END IF;
4582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4583: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4584: p_prefix=>l_debug_prefix,
4585: p_msg_level=>fnd_log.level_procedure);
4586: END IF;

Line 4585: p_msg_level=>fnd_log.level_procedure);

4581: END IF;
4582: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4583: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4584: p_prefix=>l_debug_prefix,
4585: p_msg_level=>fnd_log.level_procedure);
4586: END IF;
4587:
4588: -- Check if API is called in debug mode. If yes, disable debug.
4589: --disable_debug;

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

4596: p_count => x_msg_count,
4597: p_data => x_msg_data);
4598:
4599: -- Debug info.
4600: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4601: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4602: p_msg_data=>x_msg_data,
4603: p_msg_type=>'UNEXPECTED ERROR',
4604: p_msg_level=>fnd_log.level_error);

Line 4604: p_msg_level=>fnd_log.level_error);

4600: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4601: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4602: p_msg_data=>x_msg_data,
4603: p_msg_type=>'UNEXPECTED ERROR',
4604: p_msg_level=>fnd_log.level_error);
4605: END IF;
4606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4607: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4608: p_prefix=>l_debug_prefix,

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

4602: p_msg_data=>x_msg_data,
4603: p_msg_type=>'UNEXPECTED ERROR',
4604: p_msg_level=>fnd_log.level_error);
4605: END IF;
4606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4607: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4608: p_prefix=>l_debug_prefix,
4609: p_msg_level=>fnd_log.level_procedure);
4610: END IF;

Line 4609: p_msg_level=>fnd_log.level_procedure);

4605: END IF;
4606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4607: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4608: p_prefix=>l_debug_prefix,
4609: p_msg_level=>fnd_log.level_procedure);
4610: END IF;
4611:
4612: -- Check if API is called in debug mode. If yes, disable debug.
4613: --disable_debug;

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

4624: p_count => x_msg_count,
4625: p_data => x_msg_data);
4626:
4627: -- Debug info.
4628: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4629: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4630: p_msg_data=>x_msg_data,
4631: p_msg_type=>'SQL ERROR',
4632: p_msg_level=>fnd_log.level_error);

Line 4632: p_msg_level=>fnd_log.level_error);

4628: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4629: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4630: p_msg_data=>x_msg_data,
4631: p_msg_type=>'SQL ERROR',
4632: p_msg_level=>fnd_log.level_error);
4633: END IF;
4634: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4635: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4636: p_prefix=>l_debug_prefix,

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

4630: p_msg_data=>x_msg_data,
4631: p_msg_type=>'SQL ERROR',
4632: p_msg_level=>fnd_log.level_error);
4633: END IF;
4634: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4635: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4636: p_prefix=>l_debug_prefix,
4637: p_msg_level=>fnd_log.level_procedure);
4638: END IF;

Line 4637: p_msg_level=>fnd_log.level_procedure);

4633: END IF;
4634: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4635: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4636: p_prefix=>l_debug_prefix,
4637: p_msg_level=>fnd_log.level_procedure);
4638: END IF;
4639:
4640: -- Check if API is called in debug mode. If yes, disable debug.
4641: --disable_debug;

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

4694: -- Check if API is called in debug mode. If yes, enable debug.
4695: --enable_debug;
4696:
4697: -- Debug info.
4698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4699: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
4700: p_prefix=>l_debug_prefix,
4701: p_msg_level=>fnd_log.level_procedure);
4702: END IF;

Line 4701: p_msg_level=>fnd_log.level_procedure);

4697: -- Debug info.
4698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4699: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
4700: p_prefix=>l_debug_prefix,
4701: p_msg_level=>fnd_log.level_procedure);
4702: END IF;
4703:
4704: -- call main business logic.
4705: update_contact_point_main(

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

4713: );
4714:
4715: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4716: -- Debug info.
4717: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4718: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4719: p_msg_data=>x_msg_data,
4720: p_msg_type=>'WARNING',
4721: p_msg_level=>fnd_log.level_exception);

Line 4721: p_msg_level=>fnd_log.level_exception);

4717: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4718: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4719: p_msg_data=>x_msg_data,
4720: p_msg_type=>'WARNING',
4721: p_msg_level=>fnd_log.level_exception);
4722: END IF;
4723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4724: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4725: p_prefix=>l_debug_prefix,

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

4719: p_msg_data=>x_msg_data,
4720: p_msg_type=>'WARNING',
4721: p_msg_level=>fnd_log.level_exception);
4722: END IF;
4723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4724: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4725: p_prefix=>l_debug_prefix,
4726: p_msg_level=>fnd_log.level_procedure);
4727: END IF;

Line 4726: p_msg_level=>fnd_log.level_procedure);

4722: END IF;
4723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4724: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4725: p_prefix=>l_debug_prefix,
4726: p_msg_level=>fnd_log.level_procedure);
4727: END IF;
4728:
4729: -- Check if API is called in debug mode. If yes, disable debug.
4730: --disable_debug;

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

4739: p_count => x_msg_count,
4740: p_data => x_msg_data);
4741:
4742: -- Debug info.
4743: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4744: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4745: p_msg_data=>x_msg_data,
4746: p_msg_type=>'ERROR',
4747: p_msg_level=>fnd_log.level_error);

Line 4747: p_msg_level=>fnd_log.level_error);

4743: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4744: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4745: p_msg_data=>x_msg_data,
4746: p_msg_type=>'ERROR',
4747: p_msg_level=>fnd_log.level_error);
4748: END IF;
4749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4750: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4751: p_prefix=>l_debug_prefix,

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

4745: p_msg_data=>x_msg_data,
4746: p_msg_type=>'ERROR',
4747: p_msg_level=>fnd_log.level_error);
4748: END IF;
4749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4750: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4751: p_prefix=>l_debug_prefix,
4752: p_msg_level=>fnd_log.level_procedure);
4753: END IF;

Line 4752: p_msg_level=>fnd_log.level_procedure);

4748: END IF;
4749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4750: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4751: p_prefix=>l_debug_prefix,
4752: p_msg_level=>fnd_log.level_procedure);
4753: END IF;
4754:
4755: -- Check if API is called in debug mode. If yes, disable debug.
4756: --disable_debug;

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

4764: p_count => x_msg_count,
4765: p_data => x_msg_data);
4766:
4767: -- Debug info.
4768: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4769: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4770: p_msg_data=>x_msg_data,
4771: p_msg_type=>'UNEXPECTED ERROR',
4772: p_msg_level=>fnd_log.level_error);

Line 4772: p_msg_level=>fnd_log.level_error);

4768: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4769: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4770: p_msg_data=>x_msg_data,
4771: p_msg_type=>'UNEXPECTED ERROR',
4772: p_msg_level=>fnd_log.level_error);
4773: END IF;
4774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4775: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4776: p_prefix=>l_debug_prefix,

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

4770: p_msg_data=>x_msg_data,
4771: p_msg_type=>'UNEXPECTED ERROR',
4772: p_msg_level=>fnd_log.level_error);
4773: END IF;
4774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4775: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4776: p_prefix=>l_debug_prefix,
4777: p_msg_level=>fnd_log.level_procedure);
4778: END IF;

Line 4777: p_msg_level=>fnd_log.level_procedure);

4773: END IF;
4774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4775: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4776: p_prefix=>l_debug_prefix,
4777: p_msg_level=>fnd_log.level_procedure);
4778: END IF;
4779:
4780:
4781: -- Check if API is called in debug mode. If yes, disable debug.

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

4794: p_count => x_msg_count,
4795: p_data => x_msg_data);
4796:
4797: -- Debug info.
4798: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4799: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4800: p_msg_data=>x_msg_data,
4801: p_msg_type=>'SQL ERROR',
4802: p_msg_level=>fnd_log.level_error);

Line 4802: p_msg_level=>fnd_log.level_error);

4798: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4799: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4800: p_msg_data=>x_msg_data,
4801: p_msg_type=>'SQL ERROR',
4802: p_msg_level=>fnd_log.level_error);
4803: END IF;
4804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4805: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4806: p_prefix=>l_debug_prefix,

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

4800: p_msg_data=>x_msg_data,
4801: p_msg_type=>'SQL ERROR',
4802: p_msg_level=>fnd_log.level_error);
4803: END IF;
4804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4805: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4806: p_prefix=>l_debug_prefix,
4807: p_msg_level=>fnd_log.level_procedure);
4808: END IF;

Line 4807: p_msg_level=>fnd_log.level_procedure);

4803: END IF;
4804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4805: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4806: p_prefix=>l_debug_prefix,
4807: p_msg_level=>fnd_log.level_procedure);
4808: END IF;
4809:
4810: -- Check if API is called in debug mode. If yes, disable debug.
4811: --disable_debug;

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

4866: -- Check if API is called in debug mode. If yes, enable debug.
4867: --enable_debug;
4868:
4869: -- Debug info.
4870: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4871: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
4872: p_prefix=>l_debug_prefix,
4873: p_msg_level=>fnd_log.level_procedure);
4874: END IF;

Line 4873: p_msg_level=>fnd_log.level_procedure);

4869: -- Debug info.
4870: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4871: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
4872: p_prefix=>l_debug_prefix,
4873: p_msg_level=>fnd_log.level_procedure);
4874: END IF;
4875:
4876:
4877: -- call main business logic.

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

4885: x_msg_data => x_msg_data
4886: );
4887:
4888: -- Debug info.
4889: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4890: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4891: p_msg_data=>x_msg_data,
4892: p_msg_type=>'WARNING',
4893: p_msg_level=>fnd_log.level_exception);

Line 4893: p_msg_level=>fnd_log.level_exception);

4889: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4890: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4891: p_msg_data=>x_msg_data,
4892: p_msg_type=>'WARNING',
4893: p_msg_level=>fnd_log.level_exception);
4894: END IF;
4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4896: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4897: p_prefix=>l_debug_prefix,

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

4891: p_msg_data=>x_msg_data,
4892: p_msg_type=>'WARNING',
4893: p_msg_level=>fnd_log.level_exception);
4894: END IF;
4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4896: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4897: p_prefix=>l_debug_prefix,
4898: p_msg_level=>fnd_log.level_procedure);
4899: END IF;

Line 4898: p_msg_level=>fnd_log.level_procedure);

4894: END IF;
4895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4896: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4897: p_prefix=>l_debug_prefix,
4898: p_msg_level=>fnd_log.level_procedure);
4899: END IF;
4900:
4901: -- Check if API is called in debug mode. If yes, disable debug.
4902: --disable_debug;

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

4910: p_count => x_msg_count,
4911: p_data => x_msg_data);
4912:
4913: -- Debug info.
4914: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4915: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4916: p_msg_data=>x_msg_data,
4917: p_msg_type=>'ERROR',
4918: p_msg_level=>fnd_log.level_error);

Line 4918: p_msg_level=>fnd_log.level_error);

4914: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4915: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4916: p_msg_data=>x_msg_data,
4917: p_msg_type=>'ERROR',
4918: p_msg_level=>fnd_log.level_error);
4919: END IF;
4920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4921: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4922: p_prefix=>l_debug_prefix,

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

4916: p_msg_data=>x_msg_data,
4917: p_msg_type=>'ERROR',
4918: p_msg_level=>fnd_log.level_error);
4919: END IF;
4920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4921: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4922: p_prefix=>l_debug_prefix,
4923: p_msg_level=>fnd_log.level_procedure);
4924: END IF;

Line 4923: p_msg_level=>fnd_log.level_procedure);

4919: END IF;
4920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4921: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4922: p_prefix=>l_debug_prefix,
4923: p_msg_level=>fnd_log.level_procedure);
4924: END IF;
4925:
4926: -- Check if API is called in debug mode. If yes, disable debug.
4927: --disable_debug;

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

4934: p_count => x_msg_count,
4935: p_data => x_msg_data);
4936:
4937: -- Debug info.
4938: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4939: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4940: p_msg_data=>x_msg_data,
4941: p_msg_type=>'UNEXPECTED ERROR',
4942: p_msg_level=>fnd_log.level_error);

Line 4942: p_msg_level=>fnd_log.level_error);

4938: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4939: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4940: p_msg_data=>x_msg_data,
4941: p_msg_type=>'UNEXPECTED ERROR',
4942: p_msg_level=>fnd_log.level_error);
4943: END IF;
4944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4945: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4946: p_prefix=>l_debug_prefix,

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

4940: p_msg_data=>x_msg_data,
4941: p_msg_type=>'UNEXPECTED ERROR',
4942: p_msg_level=>fnd_log.level_error);
4943: END IF;
4944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4945: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4946: p_prefix=>l_debug_prefix,
4947: p_msg_level=>fnd_log.level_procedure);
4948: END IF;

Line 4947: p_msg_level=>fnd_log.level_procedure);

4943: END IF;
4944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4945: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4946: p_prefix=>l_debug_prefix,
4947: p_msg_level=>fnd_log.level_procedure);
4948: END IF;
4949:
4950: -- Check if API is called in debug mode. If yes, disable debug.
4951: --disable_debug;

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

4962: p_count => x_msg_count,
4963: p_data => x_msg_data);
4964:
4965: -- Debug info.
4966: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4967: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4968: p_msg_data=>x_msg_data,
4969: p_msg_type=>'SQL ERROR',
4970: p_msg_level=>fnd_log.level_error);

Line 4970: p_msg_level=>fnd_log.level_error);

4966: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4967: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4968: p_msg_data=>x_msg_data,
4969: p_msg_type=>'SQL ERROR',
4970: p_msg_level=>fnd_log.level_error);
4971: END IF;
4972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4973: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4974: p_prefix=>l_debug_prefix,

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

4968: p_msg_data=>x_msg_data,
4969: p_msg_type=>'SQL ERROR',
4970: p_msg_level=>fnd_log.level_error);
4971: END IF;
4972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4973: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4974: p_prefix=>l_debug_prefix,
4975: p_msg_level=>fnd_log.level_procedure);
4976: END IF;

Line 4975: p_msg_level=>fnd_log.level_procedure);

4971: END IF;
4972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4973: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
4974: p_prefix=>l_debug_prefix,
4975: p_msg_level=>fnd_log.level_procedure);
4976: END IF;
4977:
4978:
4979: -- Check if API is called in debug mode. If yes, disable debug.

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

5033: -- Check if API is called in debug mode. If yes, enable debug.
5034: --enable_debug;
5035:
5036: -- Debug info.
5037: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5038: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
5039: p_prefix=>l_debug_prefix,
5040: p_msg_level=>fnd_log.level_procedure);
5041: END IF;

Line 5040: p_msg_level=>fnd_log.level_procedure);

5036: -- Debug info.
5037: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5038: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
5039: p_prefix=>l_debug_prefix,
5040: p_msg_level=>fnd_log.level_procedure);
5041: END IF;
5042:
5043: -- call main business logic.
5044: update_contact_point_main(

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

5052: );
5053:
5054: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5055: -- Debug info.
5056: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5057: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5058: p_msg_data=>x_msg_data,
5059: p_msg_type=>'WARNING',
5060: p_msg_level=>fnd_log.level_exception);

Line 5060: p_msg_level=>fnd_log.level_exception);

5056: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5057: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5058: p_msg_data=>x_msg_data,
5059: p_msg_type=>'WARNING',
5060: p_msg_level=>fnd_log.level_exception);
5061: END IF;
5062: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5063: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5064: p_prefix=>l_debug_prefix,

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

5058: p_msg_data=>x_msg_data,
5059: p_msg_type=>'WARNING',
5060: p_msg_level=>fnd_log.level_exception);
5061: END IF;
5062: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5063: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5064: p_prefix=>l_debug_prefix,
5065: p_msg_level=>fnd_log.level_procedure);
5066: END IF;

Line 5065: p_msg_level=>fnd_log.level_procedure);

5061: END IF;
5062: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5063: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5064: p_prefix=>l_debug_prefix,
5065: p_msg_level=>fnd_log.level_procedure);
5066: END IF;
5067:
5068: -- Check if API is called in debug mode. If yes, disable debug.
5069: --disable_debug;

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

5078: p_count => x_msg_count,
5079: p_data => x_msg_data);
5080:
5081: -- Debug info.
5082: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5083: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5084: p_msg_data=>x_msg_data,
5085: p_msg_type=>'ERROR',
5086: p_msg_level=>fnd_log.level_error);

Line 5086: p_msg_level=>fnd_log.level_error);

5082: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5083: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5084: p_msg_data=>x_msg_data,
5085: p_msg_type=>'ERROR',
5086: p_msg_level=>fnd_log.level_error);
5087: END IF;
5088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5089: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5090: p_prefix=>l_debug_prefix,

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

5084: p_msg_data=>x_msg_data,
5085: p_msg_type=>'ERROR',
5086: p_msg_level=>fnd_log.level_error);
5087: END IF;
5088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5089: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5090: p_prefix=>l_debug_prefix,
5091: p_msg_level=>fnd_log.level_procedure);
5092: END IF;

Line 5091: p_msg_level=>fnd_log.level_procedure);

5087: END IF;
5088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5089: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5090: p_prefix=>l_debug_prefix,
5091: p_msg_level=>fnd_log.level_procedure);
5092: END IF;
5093:
5094: -- Check if API is called in debug mode. If yes, disable debug.
5095: --disable_debug;

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

5103: p_count => x_msg_count,
5104: p_data => x_msg_data);
5105:
5106: -- Debug info.
5107: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5108: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5109: p_msg_data=>x_msg_data,
5110: p_msg_type=>'UNEXPECTED ERROR',
5111: p_msg_level=>fnd_log.level_error);

Line 5111: p_msg_level=>fnd_log.level_error);

5107: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5108: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5109: p_msg_data=>x_msg_data,
5110: p_msg_type=>'UNEXPECTED ERROR',
5111: p_msg_level=>fnd_log.level_error);
5112: END IF;
5113: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5114: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5115: p_prefix=>l_debug_prefix,

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

5109: p_msg_data=>x_msg_data,
5110: p_msg_type=>'UNEXPECTED ERROR',
5111: p_msg_level=>fnd_log.level_error);
5112: END IF;
5113: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5114: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5115: p_prefix=>l_debug_prefix,
5116: p_msg_level=>fnd_log.level_procedure);
5117: END IF;

Line 5116: p_msg_level=>fnd_log.level_procedure);

5112: END IF;
5113: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5114: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5115: p_prefix=>l_debug_prefix,
5116: p_msg_level=>fnd_log.level_procedure);
5117: END IF;
5118:
5119: -- Check if API is called in debug mode. If yes, disable debug.
5120: --disable_debug;

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

5132: p_count => x_msg_count,
5133: p_data => x_msg_data);
5134:
5135: -- Debug info.
5136: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5137: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5138: p_msg_data=>x_msg_data,
5139: p_msg_type=>'SQL ERROR',
5140: p_msg_level=>fnd_log.level_error);

Line 5140: p_msg_level=>fnd_log.level_error);

5136: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5137: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5138: p_msg_data=>x_msg_data,
5139: p_msg_type=>'SQL ERROR',
5140: p_msg_level=>fnd_log.level_error);
5141: END IF;
5142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5143: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5144: p_prefix=>l_debug_prefix,

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

5138: p_msg_data=>x_msg_data,
5139: p_msg_type=>'SQL ERROR',
5140: p_msg_level=>fnd_log.level_error);
5141: END IF;
5142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5143: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5144: p_prefix=>l_debug_prefix,
5145: p_msg_level=>fnd_log.level_procedure);
5146: END IF;

Line 5145: p_msg_level=>fnd_log.level_procedure);

5141: END IF;
5142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5143: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5144: p_prefix=>l_debug_prefix,
5145: p_msg_level=>fnd_log.level_procedure);
5146: END IF;
5147:
5148: -- Check if API is called in debug mode. If yes, disable debug.
5149: --disable_debug;

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

5202: -- Check if API is called in debug mode. If yes, enable debug.
5203: --enable_debug;
5204:
5205: -- Debug info.
5206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5207: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
5208: p_prefix=>l_debug_prefix,
5209: p_msg_level=>fnd_log.level_procedure);
5210: END IF;

Line 5209: p_msg_level=>fnd_log.level_procedure);

5205: -- Debug info.
5206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5207: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
5208: p_prefix=>l_debug_prefix,
5209: p_msg_level=>fnd_log.level_procedure);
5210: END IF;
5211:
5212: -- call main business logic.
5213: update_contact_point_main(

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

5221: );
5222:
5223: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5224: -- Debug info.
5225: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5226: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5227: p_msg_data=>x_msg_data,
5228: p_msg_type=>'WARNING',
5229: p_msg_level=>fnd_log.level_exception);

Line 5229: p_msg_level=>fnd_log.level_exception);

5225: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5226: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5227: p_msg_data=>x_msg_data,
5228: p_msg_type=>'WARNING',
5229: p_msg_level=>fnd_log.level_exception);
5230: END IF;
5231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5232: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5233: p_prefix=>l_debug_prefix,

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

5227: p_msg_data=>x_msg_data,
5228: p_msg_type=>'WARNING',
5229: p_msg_level=>fnd_log.level_exception);
5230: END IF;
5231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5232: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5233: p_prefix=>l_debug_prefix,
5234: p_msg_level=>fnd_log.level_procedure);
5235: END IF;

Line 5234: p_msg_level=>fnd_log.level_procedure);

5230: END IF;
5231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5232: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5233: p_prefix=>l_debug_prefix,
5234: p_msg_level=>fnd_log.level_procedure);
5235: END IF;
5236:
5237:
5238: -- Check if API is called in debug mode. If yes, disable debug.

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

5248: p_count => x_msg_count,
5249: p_data => x_msg_data);
5250:
5251: -- Debug info.
5252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5254: p_msg_data=>x_msg_data,
5255: p_msg_type=>'ERROR',
5256: p_msg_level=>fnd_log.level_error);

Line 5256: p_msg_level=>fnd_log.level_error);

5252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5254: p_msg_data=>x_msg_data,
5255: p_msg_type=>'ERROR',
5256: p_msg_level=>fnd_log.level_error);
5257: END IF;
5258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5259: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5260: p_prefix=>l_debug_prefix,

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

5254: p_msg_data=>x_msg_data,
5255: p_msg_type=>'ERROR',
5256: p_msg_level=>fnd_log.level_error);
5257: END IF;
5258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5259: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5260: p_prefix=>l_debug_prefix,
5261: p_msg_level=>fnd_log.level_procedure);
5262: END IF;

Line 5261: p_msg_level=>fnd_log.level_procedure);

5257: END IF;
5258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5259: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5260: p_prefix=>l_debug_prefix,
5261: p_msg_level=>fnd_log.level_procedure);
5262: END IF;
5263:
5264:
5265:

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

5275: p_count => x_msg_count,
5276: p_data => x_msg_data);
5277:
5278: -- Debug info.
5279: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5280: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5281: p_msg_data=>x_msg_data,
5282: p_msg_type=>'UNEXPECTED ERROR',
5283: p_msg_level=>fnd_log.level_error);

Line 5283: p_msg_level=>fnd_log.level_error);

5279: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5280: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5281: p_msg_data=>x_msg_data,
5282: p_msg_type=>'UNEXPECTED ERROR',
5283: p_msg_level=>fnd_log.level_error);
5284: END IF;
5285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5286: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5287: p_prefix=>l_debug_prefix,

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

5281: p_msg_data=>x_msg_data,
5282: p_msg_type=>'UNEXPECTED ERROR',
5283: p_msg_level=>fnd_log.level_error);
5284: END IF;
5285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5286: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5287: p_prefix=>l_debug_prefix,
5288: p_msg_level=>fnd_log.level_procedure);
5289: END IF;

Line 5288: p_msg_level=>fnd_log.level_procedure);

5284: END IF;
5285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5286: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5287: p_prefix=>l_debug_prefix,
5288: p_msg_level=>fnd_log.level_procedure);
5289: END IF;
5290:
5291: -- Check if API is called in debug mode. If yes, disable debug.
5292: --disable_debug;

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

5304: p_count => x_msg_count,
5305: p_data => x_msg_data);
5306:
5307: -- Debug info.
5308: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5310: p_msg_data=>x_msg_data,
5311: p_msg_type=>'SQL ERROR',
5312: p_msg_level=>fnd_log.level_error);

Line 5312: p_msg_level=>fnd_log.level_error);

5308: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5310: p_msg_data=>x_msg_data,
5311: p_msg_type=>'SQL ERROR',
5312: p_msg_level=>fnd_log.level_error);
5313: END IF;
5314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5315: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5316: p_prefix=>l_debug_prefix,

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

5310: p_msg_data=>x_msg_data,
5311: p_msg_type=>'SQL ERROR',
5312: p_msg_level=>fnd_log.level_error);
5313: END IF;
5314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5315: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5316: p_prefix=>l_debug_prefix,
5317: p_msg_level=>fnd_log.level_procedure);
5318: END IF;

Line 5317: p_msg_level=>fnd_log.level_procedure);

5313: END IF;
5314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5315: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5316: p_prefix=>l_debug_prefix,
5317: p_msg_level=>fnd_log.level_procedure);
5318: END IF;
5319:
5320: -- Check if API is called in debug mode. If yes, disable debug.
5321: --disable_debug;

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

5374: -- Check if API is called in debug mode. If yes, enable debug.
5375: --enable_debug;
5376:
5377: -- Debug info.
5378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5379: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
5380: p_prefix=>l_debug_prefix,
5381: p_msg_level=>fnd_log.level_procedure);
5382: END IF;

Line 5381: p_msg_level=>fnd_log.level_procedure);

5377: -- Debug info.
5378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5379: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
5380: p_prefix=>l_debug_prefix,
5381: p_msg_level=>fnd_log.level_procedure);
5382: END IF;
5383:
5384: -- call main business logic.
5385: update_contact_point_main(

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

5393: );
5394:
5395: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5396: -- Debug info.
5397: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5399: p_msg_data=>x_msg_data,
5400: p_msg_type=>'WARNING',
5401: p_msg_level=>fnd_log.level_exception);

Line 5401: p_msg_level=>fnd_log.level_exception);

5397: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5399: p_msg_data=>x_msg_data,
5400: p_msg_type=>'WARNING',
5401: p_msg_level=>fnd_log.level_exception);
5402: END IF;
5403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5404: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5405: p_prefix=>l_debug_prefix,

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

5399: p_msg_data=>x_msg_data,
5400: p_msg_type=>'WARNING',
5401: p_msg_level=>fnd_log.level_exception);
5402: END IF;
5403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5404: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5405: p_prefix=>l_debug_prefix,
5406: p_msg_level=>fnd_log.level_procedure);
5407: END IF;

Line 5406: p_msg_level=>fnd_log.level_procedure);

5402: END IF;
5403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5404: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5405: p_prefix=>l_debug_prefix,
5406: p_msg_level=>fnd_log.level_procedure);
5407: END IF;
5408:
5409: -- Check if API is called in debug mode. If yes, disable debug.
5410: --disable_debug;

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

5419: p_count => x_msg_count,
5420: p_data => x_msg_data);
5421:
5422: -- Debug info.
5423: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5424: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5425: p_msg_data=>x_msg_data,
5426: p_msg_type=>'ERROR',
5427: p_msg_level=>fnd_log.level_error);

Line 5427: p_msg_level=>fnd_log.level_error);

5423: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5424: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5425: p_msg_data=>x_msg_data,
5426: p_msg_type=>'ERROR',
5427: p_msg_level=>fnd_log.level_error);
5428: END IF;
5429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5430: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5431: p_prefix=>l_debug_prefix,

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

5425: p_msg_data=>x_msg_data,
5426: p_msg_type=>'ERROR',
5427: p_msg_level=>fnd_log.level_error);
5428: END IF;
5429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5430: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5431: p_prefix=>l_debug_prefix,
5432: p_msg_level=>fnd_log.level_procedure);
5433: END IF;

Line 5432: p_msg_level=>fnd_log.level_procedure);

5428: END IF;
5429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5430: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5431: p_prefix=>l_debug_prefix,
5432: p_msg_level=>fnd_log.level_procedure);
5433: END IF;
5434:
5435: -- Check if API is called in debug mode. If yes, disable debug.
5436: --disable_debug;

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

5444: p_count => x_msg_count,
5445: p_data => x_msg_data);
5446:
5447: -- Debug info.
5448: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5449: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5450: p_msg_data=>x_msg_data,
5451: p_msg_type=>'UNEXPECTED ERROR',
5452: p_msg_level=>fnd_log.level_error);

Line 5452: p_msg_level=>fnd_log.level_error);

5448: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5449: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5450: p_msg_data=>x_msg_data,
5451: p_msg_type=>'UNEXPECTED ERROR',
5452: p_msg_level=>fnd_log.level_error);
5453: END IF;
5454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5455: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5456: p_prefix=>l_debug_prefix,

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

5450: p_msg_data=>x_msg_data,
5451: p_msg_type=>'UNEXPECTED ERROR',
5452: p_msg_level=>fnd_log.level_error);
5453: END IF;
5454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5455: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5456: p_prefix=>l_debug_prefix,
5457: p_msg_level=>fnd_log.level_procedure);
5458: END IF;

Line 5457: p_msg_level=>fnd_log.level_procedure);

5453: END IF;
5454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5455: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5456: p_prefix=>l_debug_prefix,
5457: p_msg_level=>fnd_log.level_procedure);
5458: END IF;
5459:
5460: -- Check if API is called in debug mode. If yes, disable debug.
5461: --disable_debug;

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

5473: p_count => x_msg_count,
5474: p_data => x_msg_data);
5475:
5476: -- Debug info.
5477: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5478: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5479: p_msg_data=>x_msg_data,
5480: p_msg_type=>'SQL ERROR',
5481: p_msg_level=>fnd_log.level_error);

Line 5481: p_msg_level=>fnd_log.level_error);

5477: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5478: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5479: p_msg_data=>x_msg_data,
5480: p_msg_type=>'SQL ERROR',
5481: p_msg_level=>fnd_log.level_error);
5482: END IF;
5483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5484: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5485: p_prefix=>l_debug_prefix,

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

5479: p_msg_data=>x_msg_data,
5480: p_msg_type=>'SQL ERROR',
5481: p_msg_level=>fnd_log.level_error);
5482: END IF;
5483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5484: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5485: p_prefix=>l_debug_prefix,
5486: p_msg_level=>fnd_log.level_procedure);
5487: END IF;

Line 5486: p_msg_level=>fnd_log.level_procedure);

5482: END IF;
5483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5484: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5485: p_prefix=>l_debug_prefix,
5486: p_msg_level=>fnd_log.level_procedure);
5487: END IF;
5488:
5489: -- Check if API is called in debug mode. If yes, disable debug.
5490: --disable_debug;

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

5565: -- Check if API is called in debug mode. If yes, enable debug.
5566: --enable_debug;
5567:
5568: -- Debug info.
5569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5570: hz_utility_v2pub.debug(p_message=>'phone_format (+)',
5571: p_prefix=>l_debug_prefix,
5572: p_msg_level=>fnd_log.level_procedure);
5573: END IF;

Line 5572: p_msg_level=>fnd_log.level_procedure);

5568: -- Debug info.
5569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5570: hz_utility_v2pub.debug(p_message=>'phone_format (+)',
5571: p_prefix=>l_debug_prefix,
5572: p_msg_level=>fnd_log.level_procedure);
5573: END IF;
5574:
5575: -- Initialize message list if p_init_msg_list is set to TRUE.
5576: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

5725: p_count => x_msg_count,
5726: p_data => x_msg_data);
5727:
5728: -- Debug info.
5729: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5730: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5731: p_msg_data=>x_msg_data,
5732: p_msg_type=>'WARNING',
5733: p_msg_level=>fnd_log.level_exception);

Line 5733: p_msg_level=>fnd_log.level_exception);

5729: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5730: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5731: p_msg_data=>x_msg_data,
5732: p_msg_type=>'WARNING',
5733: p_msg_level=>fnd_log.level_exception);
5734: END IF;
5735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5736: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5737: p_prefix=>l_debug_prefix,

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

5731: p_msg_data=>x_msg_data,
5732: p_msg_type=>'WARNING',
5733: p_msg_level=>fnd_log.level_exception);
5734: END IF;
5735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5736: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5737: p_prefix=>l_debug_prefix,
5738: p_msg_level=>fnd_log.level_procedure);
5739: END IF;

Line 5738: p_msg_level=>fnd_log.level_procedure);

5734: END IF;
5735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5736: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5737: p_prefix=>l_debug_prefix,
5738: p_msg_level=>fnd_log.level_procedure);
5739: END IF;
5740:
5741: -- Check if API is called in debug mode. If yes, disable debug.
5742: --disable_debug;

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

5749: p_count => x_msg_count,
5750: p_data => x_msg_data);
5751:
5752: -- Debug info.
5753: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5754: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5755: p_msg_data=>x_msg_data,
5756: p_msg_type=>'ERROR',
5757: p_msg_level=>fnd_log.level_error);

Line 5757: p_msg_level=>fnd_log.level_error);

5753: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5754: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5755: p_msg_data=>x_msg_data,
5756: p_msg_type=>'ERROR',
5757: p_msg_level=>fnd_log.level_error);
5758: END IF;
5759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5760: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5761: p_prefix=>l_debug_prefix,

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

5755: p_msg_data=>x_msg_data,
5756: p_msg_type=>'ERROR',
5757: p_msg_level=>fnd_log.level_error);
5758: END IF;
5759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5760: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5761: p_prefix=>l_debug_prefix,
5762: p_msg_level=>fnd_log.level_procedure);
5763: END IF;

Line 5762: p_msg_level=>fnd_log.level_procedure);

5758: END IF;
5759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5760: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5761: p_prefix=>l_debug_prefix,
5762: p_msg_level=>fnd_log.level_procedure);
5763: END IF;
5764:
5765: -- Check if API is called in debug mode. If yes, disable debug.
5766: --disable_debug;

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

5772: p_count => x_msg_count,
5773: p_data => x_msg_data);
5774:
5775: -- Debug info.
5776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5778: p_msg_data=>x_msg_data,
5779: p_msg_type=>'UNEXPECTED ERROR',
5780: p_msg_level=>fnd_log.level_error);

Line 5780: p_msg_level=>fnd_log.level_error);

5776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5778: p_msg_data=>x_msg_data,
5779: p_msg_type=>'UNEXPECTED ERROR',
5780: p_msg_level=>fnd_log.level_error);
5781: END IF;
5782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5783: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5784: p_prefix=>l_debug_prefix,

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

5778: p_msg_data=>x_msg_data,
5779: p_msg_type=>'UNEXPECTED ERROR',
5780: p_msg_level=>fnd_log.level_error);
5781: END IF;
5782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5783: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5784: p_prefix=>l_debug_prefix,
5785: p_msg_level=>fnd_log.level_procedure);
5786: END IF;

Line 5785: p_msg_level=>fnd_log.level_procedure);

5781: END IF;
5782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5783: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5784: p_prefix=>l_debug_prefix,
5785: p_msg_level=>fnd_log.level_procedure);
5786: END IF;
5787:
5788: -- Check if API is called in debug mode. If yes, disable debug.
5789: --disable_debug;

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

5799: p_count => x_msg_count,
5800: p_data => x_msg_data);
5801:
5802: -- Debug info.
5803: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5804: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5805: p_msg_data=>x_msg_data,
5806: p_msg_type=>'SQL ERROR',
5807: p_msg_level=>fnd_log.level_error);

Line 5807: p_msg_level=>fnd_log.level_error);

5803: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5804: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5805: p_msg_data=>x_msg_data,
5806: p_msg_type=>'SQL ERROR',
5807: p_msg_level=>fnd_log.level_error);
5808: END IF;
5809: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5810: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5811: p_prefix=>l_debug_prefix,

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

5805: p_msg_data=>x_msg_data,
5806: p_msg_type=>'SQL ERROR',
5807: p_msg_level=>fnd_log.level_error);
5808: END IF;
5809: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5810: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5811: p_prefix=>l_debug_prefix,
5812: p_msg_level=>fnd_log.level_procedure);
5813: END IF;

Line 5812: p_msg_level=>fnd_log.level_procedure);

5808: END IF;
5809: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5810: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5811: p_prefix=>l_debug_prefix,
5812: p_msg_level=>fnd_log.level_procedure);
5813: END IF;
5814:
5815: -- Check if API is called in debug mode. If yes, disable debug.
5816: --disable_debug;

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

5874: -- Check if API is called in debug mode. If yes, enable debug.
5875: --enable_debug;
5876:
5877: -- Debug info.
5878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5879: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (+)',
5880: p_prefix=>l_debug_prefix,
5881: p_msg_level=>fnd_log.level_procedure);
5882: END IF;

Line 5881: p_msg_level=>fnd_log.level_procedure);

5877: -- Debug info.
5878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5879: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (+)',
5880: p_prefix=>l_debug_prefix,
5881: p_msg_level=>fnd_log.level_procedure);
5882: END IF;
5883:
5884: -- Execute main procedure
5885: get_contact_point_main (

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

5897: x_msg_data => x_msg_data
5898: );
5899:
5900: -- Debug info.
5901: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5902: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5903: p_msg_data=>x_msg_data,
5904: p_msg_type=>'WARNING',
5905: p_msg_level=>fnd_log.level_exception);

Line 5905: p_msg_level=>fnd_log.level_exception);

5901: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5902: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5903: p_msg_data=>x_msg_data,
5904: p_msg_type=>'WARNING',
5905: p_msg_level=>fnd_log.level_exception);
5906: END IF;
5907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5908: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5909: p_prefix=>l_debug_prefix,

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

5903: p_msg_data=>x_msg_data,
5904: p_msg_type=>'WARNING',
5905: p_msg_level=>fnd_log.level_exception);
5906: END IF;
5907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5908: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5909: p_prefix=>l_debug_prefix,
5910: p_msg_level=>fnd_log.level_procedure);
5911: END IF;

Line 5910: p_msg_level=>fnd_log.level_procedure);

5906: END IF;
5907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5908: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5909: p_prefix=>l_debug_prefix,
5910: p_msg_level=>fnd_log.level_procedure);
5911: END IF;
5912:
5913: -- Check if API is called in debug mode. If yes, disable debug.
5914: --disable_debug;

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

5921: p_count => x_msg_count,
5922: p_data => x_msg_data);
5923:
5924: -- Debug info.
5925: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5926: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5927: p_msg_data=>x_msg_data,
5928: p_msg_type=>'ERROR',
5929: p_msg_level=>fnd_log.level_error);

Line 5929: p_msg_level=>fnd_log.level_error);

5925: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5926: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5927: p_msg_data=>x_msg_data,
5928: p_msg_type=>'ERROR',
5929: p_msg_level=>fnd_log.level_error);
5930: END IF;
5931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5932: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5933: p_prefix=>l_debug_prefix,

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

5927: p_msg_data=>x_msg_data,
5928: p_msg_type=>'ERROR',
5929: p_msg_level=>fnd_log.level_error);
5930: END IF;
5931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5932: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5933: p_prefix=>l_debug_prefix,
5934: p_msg_level=>fnd_log.level_procedure);
5935: END IF;

Line 5934: p_msg_level=>fnd_log.level_procedure);

5930: END IF;
5931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5932: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5933: p_prefix=>l_debug_prefix,
5934: p_msg_level=>fnd_log.level_procedure);
5935: END IF;
5936:
5937: -- Check if API is called in debug mode. If yes, disable debug.
5938: --disable_debug;

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

5944: p_count => x_msg_count,
5945: p_data => x_msg_data);
5946:
5947: -- Debug info.
5948: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5949: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5950: p_msg_data=>x_msg_data,
5951: p_msg_type=>'UNEXPECTED ERROR',
5952: p_msg_level=>fnd_log.level_error);

Line 5952: p_msg_level=>fnd_log.level_error);

5948: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5949: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5950: p_msg_data=>x_msg_data,
5951: p_msg_type=>'UNEXPECTED ERROR',
5952: p_msg_level=>fnd_log.level_error);
5953: END IF;
5954: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5955: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5956: p_prefix=>l_debug_prefix,

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

5950: p_msg_data=>x_msg_data,
5951: p_msg_type=>'UNEXPECTED ERROR',
5952: p_msg_level=>fnd_log.level_error);
5953: END IF;
5954: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5955: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5956: p_prefix=>l_debug_prefix,
5957: p_msg_level=>fnd_log.level_procedure);
5958: END IF;

Line 5957: p_msg_level=>fnd_log.level_procedure);

5953: END IF;
5954: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5955: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5956: p_prefix=>l_debug_prefix,
5957: p_msg_level=>fnd_log.level_procedure);
5958: END IF;
5959:
5960: -- Check if API is called in debug mode. If yes, disable debug.
5961: --disable_debug;

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

5971: p_count => x_msg_count,
5972: p_data => x_msg_data);
5973:
5974: -- Debug info.
5975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5977: p_msg_data=>x_msg_data,
5978: p_msg_type=>'SQL ERROR',
5979: p_msg_level=>fnd_log.level_error);

Line 5979: p_msg_level=>fnd_log.level_error);

5975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5977: p_msg_data=>x_msg_data,
5978: p_msg_type=>'SQL ERROR',
5979: p_msg_level=>fnd_log.level_error);
5980: END IF;
5981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5982: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5983: p_prefix=>l_debug_prefix,

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

5977: p_msg_data=>x_msg_data,
5978: p_msg_type=>'SQL ERROR',
5979: p_msg_level=>fnd_log.level_error);
5980: END IF;
5981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5982: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5983: p_prefix=>l_debug_prefix,
5984: p_msg_level=>fnd_log.level_procedure);
5985: END IF;

Line 5984: p_msg_level=>fnd_log.level_procedure);

5980: END IF;
5981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5982: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
5983: p_prefix=>l_debug_prefix,
5984: p_msg_level=>fnd_log.level_procedure);
5985: END IF;
5986:
5987: -- Check if API is called in debug mode. If yes, disable debug.
5988: --disable_debug;

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

6040: -- Check if API is called in debug mode. If yes, enable debug.
6041: --enable_debug;
6042:
6043: -- Debug info.
6044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6045: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (+)',
6046: p_prefix=>l_debug_prefix,
6047: p_msg_level=>fnd_log.level_procedure);
6048: END IF;

Line 6047: p_msg_level=>fnd_log.level_procedure);

6043: -- Debug info.
6044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6045: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (+)',
6046: p_prefix=>l_debug_prefix,
6047: p_msg_level=>fnd_log.level_procedure);
6048: END IF;
6049:
6050: -- Execute main procedure
6051: get_contact_point_main (

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

6063: x_msg_data => x_msg_data
6064: );
6065:
6066: -- Debug info.
6067: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6068: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6069: p_msg_data=>x_msg_data,
6070: p_msg_type=>'WARNING',
6071: p_msg_level=>fnd_log.level_exception);

Line 6071: p_msg_level=>fnd_log.level_exception);

6067: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6068: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6069: p_msg_data=>x_msg_data,
6070: p_msg_type=>'WARNING',
6071: p_msg_level=>fnd_log.level_exception);
6072: END IF;
6073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6074: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6075: p_prefix=>l_debug_prefix,

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

6069: p_msg_data=>x_msg_data,
6070: p_msg_type=>'WARNING',
6071: p_msg_level=>fnd_log.level_exception);
6072: END IF;
6073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6074: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6075: p_prefix=>l_debug_prefix,
6076: p_msg_level=>fnd_log.level_procedure);
6077: END IF;

Line 6076: p_msg_level=>fnd_log.level_procedure);

6072: END IF;
6073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6074: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6075: p_prefix=>l_debug_prefix,
6076: p_msg_level=>fnd_log.level_procedure);
6077: END IF;
6078:
6079: -- Check if API is called in debug mode. If yes, disable debug.
6080: --disable_debug;

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

6087: p_count => x_msg_count,
6088: p_data => x_msg_data);
6089:
6090: -- Debug info.
6091: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6092: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6093: p_msg_data=>x_msg_data,
6094: p_msg_type=>'ERROR',
6095: p_msg_level=>fnd_log.level_error);

Line 6095: p_msg_level=>fnd_log.level_error);

6091: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6092: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6093: p_msg_data=>x_msg_data,
6094: p_msg_type=>'ERROR',
6095: p_msg_level=>fnd_log.level_error);
6096: END IF;
6097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6098: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6099: p_prefix=>l_debug_prefix,

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

6093: p_msg_data=>x_msg_data,
6094: p_msg_type=>'ERROR',
6095: p_msg_level=>fnd_log.level_error);
6096: END IF;
6097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6098: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6099: p_prefix=>l_debug_prefix,
6100: p_msg_level=>fnd_log.level_procedure);
6101: END IF;

Line 6100: p_msg_level=>fnd_log.level_procedure);

6096: END IF;
6097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6098: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6099: p_prefix=>l_debug_prefix,
6100: p_msg_level=>fnd_log.level_procedure);
6101: END IF;
6102:
6103: -- Check if API is called in debug mode. If yes, disable debug.
6104: --disable_debug;

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

6110: p_count => x_msg_count,
6111: p_data => x_msg_data);
6112:
6113: -- Debug info.
6114: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6115: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6116: p_msg_data=>x_msg_data,
6117: p_msg_type=>'UNEXPECTED ERROR',
6118: p_msg_level=>fnd_log.level_error);

Line 6118: p_msg_level=>fnd_log.level_error);

6114: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6115: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6116: p_msg_data=>x_msg_data,
6117: p_msg_type=>'UNEXPECTED ERROR',
6118: p_msg_level=>fnd_log.level_error);
6119: END IF;
6120: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6121: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6122: p_prefix=>l_debug_prefix,

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

6116: p_msg_data=>x_msg_data,
6117: p_msg_type=>'UNEXPECTED ERROR',
6118: p_msg_level=>fnd_log.level_error);
6119: END IF;
6120: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6121: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6122: p_prefix=>l_debug_prefix,
6123: p_msg_level=>fnd_log.level_procedure);
6124: END IF;

Line 6123: p_msg_level=>fnd_log.level_procedure);

6119: END IF;
6120: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6121: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6122: p_prefix=>l_debug_prefix,
6123: p_msg_level=>fnd_log.level_procedure);
6124: END IF;
6125:
6126: -- Check if API is called in debug mode. If yes, disable debug.
6127: --disable_debug;

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

6137: p_count => x_msg_count,
6138: p_data => x_msg_data);
6139:
6140: -- Debug info.
6141: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6143: p_msg_data=>x_msg_data,
6144: p_msg_type=>'SQL ERROR',
6145: p_msg_level=>fnd_log.level_error);

Line 6145: p_msg_level=>fnd_log.level_error);

6141: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6143: p_msg_data=>x_msg_data,
6144: p_msg_type=>'SQL ERROR',
6145: p_msg_level=>fnd_log.level_error);
6146: END IF;
6147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6148: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6149: p_prefix=>l_debug_prefix,

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

6143: p_msg_data=>x_msg_data,
6144: p_msg_type=>'SQL ERROR',
6145: p_msg_level=>fnd_log.level_error);
6146: END IF;
6147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6148: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6149: p_prefix=>l_debug_prefix,
6150: p_msg_level=>fnd_log.level_procedure);
6151: END IF;

Line 6150: p_msg_level=>fnd_log.level_procedure);

6146: END IF;
6147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6148: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6149: p_prefix=>l_debug_prefix,
6150: p_msg_level=>fnd_log.level_procedure);
6151: END IF;
6152:
6153: -- Check if API is called in debug mode. If yes, disable debug.
6154: --disable_debug;

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

6206: -- Check if API is called in debug mode. If yes, enable debug.
6207: --enable_debug;
6208:
6209: -- Debug info.
6210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6211: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (+)',
6212: p_prefix=>l_debug_prefix,
6213: p_msg_level=>fnd_log.level_procedure);
6214: END IF;

Line 6213: p_msg_level=>fnd_log.level_procedure);

6209: -- Debug info.
6210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6211: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (+)',
6212: p_prefix=>l_debug_prefix,
6213: p_msg_level=>fnd_log.level_procedure);
6214: END IF;
6215:
6216: -- Execute main procedure
6217: get_contact_point_main (

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

6230: );
6231:
6232:
6233: -- Debug info.
6234: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6235: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6236: p_msg_data=>x_msg_data,
6237: p_msg_type=>'WARNING',
6238: p_msg_level=>fnd_log.level_exception);

Line 6238: p_msg_level=>fnd_log.level_exception);

6234: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6235: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6236: p_msg_data=>x_msg_data,
6237: p_msg_type=>'WARNING',
6238: p_msg_level=>fnd_log.level_exception);
6239: END IF;
6240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6241: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6242: p_prefix=>l_debug_prefix,

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

6236: p_msg_data=>x_msg_data,
6237: p_msg_type=>'WARNING',
6238: p_msg_level=>fnd_log.level_exception);
6239: END IF;
6240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6241: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6242: p_prefix=>l_debug_prefix,
6243: p_msg_level=>fnd_log.level_procedure);
6244: END IF;

Line 6243: p_msg_level=>fnd_log.level_procedure);

6239: END IF;
6240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6241: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6242: p_prefix=>l_debug_prefix,
6243: p_msg_level=>fnd_log.level_procedure);
6244: END IF;
6245:
6246: -- Check if API is called in debug mode. If yes, disable debug.
6247: --disable_debug;

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

6254: p_count => x_msg_count,
6255: p_data => x_msg_data);
6256:
6257: -- Debug info.
6258: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6259: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6260: p_msg_data=>x_msg_data,
6261: p_msg_type=>'ERROR',
6262: p_msg_level=>fnd_log.level_error);

Line 6262: p_msg_level=>fnd_log.level_error);

6258: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6259: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6260: p_msg_data=>x_msg_data,
6261: p_msg_type=>'ERROR',
6262: p_msg_level=>fnd_log.level_error);
6263: END IF;
6264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6265: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6266: p_prefix=>l_debug_prefix,

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

6260: p_msg_data=>x_msg_data,
6261: p_msg_type=>'ERROR',
6262: p_msg_level=>fnd_log.level_error);
6263: END IF;
6264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6265: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6266: p_prefix=>l_debug_prefix,
6267: p_msg_level=>fnd_log.level_procedure);
6268: END IF;

Line 6267: p_msg_level=>fnd_log.level_procedure);

6263: END IF;
6264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6265: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6266: p_prefix=>l_debug_prefix,
6267: p_msg_level=>fnd_log.level_procedure);
6268: END IF;
6269:
6270: -- Check if API is called in debug mode. If yes, disable debug.
6271: --disable_debug;

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

6277: p_count => x_msg_count,
6278: p_data => x_msg_data);
6279:
6280: -- Debug info.
6281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6283: p_msg_data=>x_msg_data,
6284: p_msg_type=>'UNEXPECTED ERROR',
6285: p_msg_level=>fnd_log.level_error);

Line 6285: p_msg_level=>fnd_log.level_error);

6281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6283: p_msg_data=>x_msg_data,
6284: p_msg_type=>'UNEXPECTED ERROR',
6285: p_msg_level=>fnd_log.level_error);
6286: END IF;
6287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6288: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6289: p_prefix=>l_debug_prefix,

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

6283: p_msg_data=>x_msg_data,
6284: p_msg_type=>'UNEXPECTED ERROR',
6285: p_msg_level=>fnd_log.level_error);
6286: END IF;
6287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6288: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6289: p_prefix=>l_debug_prefix,
6290: p_msg_level=>fnd_log.level_procedure);
6291: END IF;

Line 6290: p_msg_level=>fnd_log.level_procedure);

6286: END IF;
6287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6288: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6289: p_prefix=>l_debug_prefix,
6290: p_msg_level=>fnd_log.level_procedure);
6291: END IF;
6292:
6293: -- Check if API is called in debug mode. If yes, disable debug.
6294: --disable_debug;

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

6304: p_count => x_msg_count,
6305: p_data => x_msg_data);
6306:
6307: -- Debug info.
6308: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6310: p_msg_data=>x_msg_data,
6311: p_msg_type=>'SQL ERROR',
6312: p_msg_level=>fnd_log.level_error);

Line 6312: p_msg_level=>fnd_log.level_error);

6308: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6310: p_msg_data=>x_msg_data,
6311: p_msg_type=>'SQL ERROR',
6312: p_msg_level=>fnd_log.level_error);
6313: END IF;
6314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6315: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6316: p_prefix=>l_debug_prefix,

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

6310: p_msg_data=>x_msg_data,
6311: p_msg_type=>'SQL ERROR',
6312: p_msg_level=>fnd_log.level_error);
6313: END IF;
6314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6315: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6316: p_prefix=>l_debug_prefix,
6317: p_msg_level=>fnd_log.level_procedure);
6318: END IF;

Line 6317: p_msg_level=>fnd_log.level_procedure);

6313: END IF;
6314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6315: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6316: p_prefix=>l_debug_prefix,
6317: p_msg_level=>fnd_log.level_procedure);
6318: END IF;
6319:
6320: -- Check if API is called in debug mode. If yes, disable debug.
6321: --disable_debug;

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

6374: -- Check if API is called in debug mode. If yes, enable debug.
6375: --enable_debug;
6376:
6377: -- Debug info.
6378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6379: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (+)',
6380: p_prefix=>l_debug_prefix,
6381: p_msg_level=>fnd_log.level_procedure);
6382: END IF;

Line 6381: p_msg_level=>fnd_log.level_procedure);

6377: -- Debug info.
6378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6379: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (+)',
6380: p_prefix=>l_debug_prefix,
6381: p_msg_level=>fnd_log.level_procedure);
6382: END IF;
6383:
6384: -- Execute main procedure
6385: get_contact_point_main (

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

6397: x_msg_data => x_msg_data
6398: );
6399:
6400: -- Debug info.
6401: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6402: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6403: p_msg_data=>x_msg_data,
6404: p_msg_type=>'WARNING',
6405: p_msg_level=>fnd_log.level_exception);

Line 6405: p_msg_level=>fnd_log.level_exception);

6401: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6402: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6403: p_msg_data=>x_msg_data,
6404: p_msg_type=>'WARNING',
6405: p_msg_level=>fnd_log.level_exception);
6406: END IF;
6407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6408: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6409: p_prefix=>l_debug_prefix,

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

6403: p_msg_data=>x_msg_data,
6404: p_msg_type=>'WARNING',
6405: p_msg_level=>fnd_log.level_exception);
6406: END IF;
6407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6408: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6409: p_prefix=>l_debug_prefix,
6410: p_msg_level=>fnd_log.level_procedure);
6411: END IF;

Line 6410: p_msg_level=>fnd_log.level_procedure);

6406: END IF;
6407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6408: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6409: p_prefix=>l_debug_prefix,
6410: p_msg_level=>fnd_log.level_procedure);
6411: END IF;
6412:
6413: -- Check if API is called in debug mode. If yes, disable debug.
6414: --disable_debug;

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

6421: p_count => x_msg_count,
6422: p_data => x_msg_data);
6423:
6424: -- Debug info.
6425: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6426: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6427: p_msg_data=>x_msg_data,
6428: p_msg_type=>'ERROR',
6429: p_msg_level=>fnd_log.level_error);

Line 6429: p_msg_level=>fnd_log.level_error);

6425: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6426: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6427: p_msg_data=>x_msg_data,
6428: p_msg_type=>'ERROR',
6429: p_msg_level=>fnd_log.level_error);
6430: END IF;
6431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6432: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6433: p_prefix=>l_debug_prefix,

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

6427: p_msg_data=>x_msg_data,
6428: p_msg_type=>'ERROR',
6429: p_msg_level=>fnd_log.level_error);
6430: END IF;
6431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6432: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6433: p_prefix=>l_debug_prefix,
6434: p_msg_level=>fnd_log.level_procedure);
6435: END IF;

Line 6434: p_msg_level=>fnd_log.level_procedure);

6430: END IF;
6431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6432: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6433: p_prefix=>l_debug_prefix,
6434: p_msg_level=>fnd_log.level_procedure);
6435: END IF;
6436:
6437: -- Check if API is called in debug mode. If yes, disable debug.
6438: --disable_debug;

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

6444: p_count => x_msg_count,
6445: p_data => x_msg_data);
6446:
6447: -- Debug info.
6448: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6449: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6450: p_msg_data=>x_msg_data,
6451: p_msg_type=>'UNEXPECTED ERROR',
6452: p_msg_level=>fnd_log.level_error);

Line 6452: p_msg_level=>fnd_log.level_error);

6448: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6449: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6450: p_msg_data=>x_msg_data,
6451: p_msg_type=>'UNEXPECTED ERROR',
6452: p_msg_level=>fnd_log.level_error);
6453: END IF;
6454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6455: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6456: p_prefix=>l_debug_prefix,

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

6450: p_msg_data=>x_msg_data,
6451: p_msg_type=>'UNEXPECTED ERROR',
6452: p_msg_level=>fnd_log.level_error);
6453: END IF;
6454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6455: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6456: p_prefix=>l_debug_prefix,
6457: p_msg_level=>fnd_log.level_procedure);
6458: END IF;

Line 6457: p_msg_level=>fnd_log.level_procedure);

6453: END IF;
6454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6455: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6456: p_prefix=>l_debug_prefix,
6457: p_msg_level=>fnd_log.level_procedure);
6458: END IF;
6459:
6460:
6461: -- Check if API is called in debug mode. If yes, disable debug.

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

6472: p_count => x_msg_count,
6473: p_data => x_msg_data);
6474:
6475: -- Debug info.
6476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6478: p_msg_data=>x_msg_data,
6479: p_msg_type=>'SQL ERROR',
6480: p_msg_level=>fnd_log.level_error);

Line 6480: p_msg_level=>fnd_log.level_error);

6476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6478: p_msg_data=>x_msg_data,
6479: p_msg_type=>'SQL ERROR',
6480: p_msg_level=>fnd_log.level_error);
6481: END IF;
6482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6483: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6484: p_prefix=>l_debug_prefix,

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

6478: p_msg_data=>x_msg_data,
6479: p_msg_type=>'SQL ERROR',
6480: p_msg_level=>fnd_log.level_error);
6481: END IF;
6482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6483: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6484: p_prefix=>l_debug_prefix,
6485: p_msg_level=>fnd_log.level_procedure);
6486: END IF;

Line 6485: p_msg_level=>fnd_log.level_procedure);

6481: END IF;
6482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6483: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6484: p_prefix=>l_debug_prefix,
6485: p_msg_level=>fnd_log.level_procedure);
6486: END IF;
6487:
6488: -- Check if API is called in debug mode. If yes, disable debug.
6489: --disable_debug;

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

6541: -- Check if API is called in debug mode. If yes, enable debug.
6542: --enable_debug;
6543:
6544: -- Debug info.
6545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6546: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (+)',
6547: p_prefix=>l_debug_prefix,
6548: p_msg_level=>fnd_log.level_procedure);
6549: END IF;

Line 6548: p_msg_level=>fnd_log.level_procedure);

6544: -- Debug info.
6545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6546: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (+)',
6547: p_prefix=>l_debug_prefix,
6548: p_msg_level=>fnd_log.level_procedure);
6549: END IF;
6550:
6551: -- Execute main procedure
6552: get_contact_point_main (

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

6564: x_msg_data => x_msg_data
6565: );
6566:
6567: -- Debug info.
6568: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6569: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6570: p_msg_data=>x_msg_data,
6571: p_msg_type=>'WARNING',
6572: p_msg_level=>fnd_log.level_exception);

Line 6572: p_msg_level=>fnd_log.level_exception);

6568: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6569: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6570: p_msg_data=>x_msg_data,
6571: p_msg_type=>'WARNING',
6572: p_msg_level=>fnd_log.level_exception);
6573: END IF;
6574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6575: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6576: p_prefix=>l_debug_prefix,

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

6570: p_msg_data=>x_msg_data,
6571: p_msg_type=>'WARNING',
6572: p_msg_level=>fnd_log.level_exception);
6573: END IF;
6574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6575: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6576: p_prefix=>l_debug_prefix,
6577: p_msg_level=>fnd_log.level_procedure);
6578: END IF;

Line 6577: p_msg_level=>fnd_log.level_procedure);

6573: END IF;
6574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6575: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6576: p_prefix=>l_debug_prefix,
6577: p_msg_level=>fnd_log.level_procedure);
6578: END IF;
6579:
6580: -- Check if API is called in debug mode. If yes, disable debug.
6581: --disable_debug;

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

6588: p_count => x_msg_count,
6589: p_data => x_msg_data);
6590:
6591: -- Debug info.
6592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6594: p_msg_data=>x_msg_data,
6595: p_msg_type=>'ERROR',
6596: p_msg_level=>fnd_log.level_error);

Line 6596: p_msg_level=>fnd_log.level_error);

6592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6594: p_msg_data=>x_msg_data,
6595: p_msg_type=>'ERROR',
6596: p_msg_level=>fnd_log.level_error);
6597: END IF;
6598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6599: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6600: p_prefix=>l_debug_prefix,

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

6594: p_msg_data=>x_msg_data,
6595: p_msg_type=>'ERROR',
6596: p_msg_level=>fnd_log.level_error);
6597: END IF;
6598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6599: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6600: p_prefix=>l_debug_prefix,
6601: p_msg_level=>fnd_log.level_procedure);
6602: END IF;

Line 6601: p_msg_level=>fnd_log.level_procedure);

6597: END IF;
6598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6599: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6600: p_prefix=>l_debug_prefix,
6601: p_msg_level=>fnd_log.level_procedure);
6602: END IF;
6603:
6604: -- Check if API is called in debug mode. If yes, disable debug.
6605: --disable_debug;

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

6611: p_count => x_msg_count,
6612: p_data => x_msg_data);
6613:
6614: -- Debug info.
6615: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6617: p_msg_data=>x_msg_data,
6618: p_msg_type=>'UNEXPECTED ERROR',
6619: p_msg_level=>fnd_log.level_error);

Line 6619: p_msg_level=>fnd_log.level_error);

6615: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6617: p_msg_data=>x_msg_data,
6618: p_msg_type=>'UNEXPECTED ERROR',
6619: p_msg_level=>fnd_log.level_error);
6620: END IF;
6621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6622: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6623: p_prefix=>l_debug_prefix,

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

6617: p_msg_data=>x_msg_data,
6618: p_msg_type=>'UNEXPECTED ERROR',
6619: p_msg_level=>fnd_log.level_error);
6620: END IF;
6621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6622: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6623: p_prefix=>l_debug_prefix,
6624: p_msg_level=>fnd_log.level_procedure);
6625: END IF;

Line 6624: p_msg_level=>fnd_log.level_procedure);

6620: END IF;
6621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6622: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6623: p_prefix=>l_debug_prefix,
6624: p_msg_level=>fnd_log.level_procedure);
6625: END IF;
6626:
6627: -- Check if API is called in debug mode. If yes, disable debug.
6628: --disable_debug;

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

6638: p_count => x_msg_count,
6639: p_data => x_msg_data);
6640:
6641: -- Debug info.
6642: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6643: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6644: p_msg_data=>x_msg_data,
6645: p_msg_type=>'SQL ERROR',
6646: p_msg_level=>fnd_log.level_error);

Line 6646: p_msg_level=>fnd_log.level_error);

6642: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6643: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6644: p_msg_data=>x_msg_data,
6645: p_msg_type=>'SQL ERROR',
6646: p_msg_level=>fnd_log.level_error);
6647: END IF;
6648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6649: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6650: p_prefix=>l_debug_prefix,

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

6644: p_msg_data=>x_msg_data,
6645: p_msg_type=>'SQL ERROR',
6646: p_msg_level=>fnd_log.level_error);
6647: END IF;
6648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6649: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6650: p_prefix=>l_debug_prefix,
6651: p_msg_level=>fnd_log.level_procedure);
6652: END IF;

Line 6651: p_msg_level=>fnd_log.level_procedure);

6647: END IF;
6648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6649: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6650: p_prefix=>l_debug_prefix,
6651: p_msg_level=>fnd_log.level_procedure);
6652: END IF;
6653:
6654: -- Check if API is called in debug mode. If yes, disable debug.
6655: --disable_debug;

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

6707: -- Check if API is called in debug mode. If yes, enable debug.
6708: --enable_debug;
6709:
6710: -- Debug info.
6711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6712: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (+)',
6713: p_prefix=>l_debug_prefix,
6714: p_msg_level=>fnd_log.level_procedure);
6715: END IF;

Line 6714: p_msg_level=>fnd_log.level_procedure);

6710: -- Debug info.
6711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6712: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (+)',
6713: p_prefix=>l_debug_prefix,
6714: p_msg_level=>fnd_log.level_procedure);
6715: END IF;
6716:
6717: -- Execute main procedure
6718: get_contact_point_main (

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

6730: x_msg_data => x_msg_data
6731: );
6732:
6733: -- Debug info.
6734: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6735: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6736: p_msg_data=>x_msg_data,
6737: p_msg_type=>'WARNING',
6738: p_msg_level=>fnd_log.level_exception);

Line 6738: p_msg_level=>fnd_log.level_exception);

6734: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6735: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6736: p_msg_data=>x_msg_data,
6737: p_msg_type=>'WARNING',
6738: p_msg_level=>fnd_log.level_exception);
6739: END IF;
6740: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6741: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6742: p_prefix=>l_debug_prefix,

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

6736: p_msg_data=>x_msg_data,
6737: p_msg_type=>'WARNING',
6738: p_msg_level=>fnd_log.level_exception);
6739: END IF;
6740: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6741: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6742: p_prefix=>l_debug_prefix,
6743: p_msg_level=>fnd_log.level_procedure);
6744: END IF;

Line 6743: p_msg_level=>fnd_log.level_procedure);

6739: END IF;
6740: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6741: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6742: p_prefix=>l_debug_prefix,
6743: p_msg_level=>fnd_log.level_procedure);
6744: END IF;
6745:
6746: -- Check if API is called in debug mode. If yes, disable debug.
6747: --disable_debug;

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

6754: p_count => x_msg_count,
6755: p_data => x_msg_data);
6756:
6757: -- Debug info.
6758: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6759: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6760: p_msg_data=>x_msg_data,
6761: p_msg_type=>'ERROR',
6762: p_msg_level=>fnd_log.level_error);

Line 6762: p_msg_level=>fnd_log.level_error);

6758: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6759: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6760: p_msg_data=>x_msg_data,
6761: p_msg_type=>'ERROR',
6762: p_msg_level=>fnd_log.level_error);
6763: END IF;
6764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6765: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6766: p_prefix=>l_debug_prefix,

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

6760: p_msg_data=>x_msg_data,
6761: p_msg_type=>'ERROR',
6762: p_msg_level=>fnd_log.level_error);
6763: END IF;
6764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6765: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6766: p_prefix=>l_debug_prefix,
6767: p_msg_level=>fnd_log.level_procedure);
6768: END IF;

Line 6767: p_msg_level=>fnd_log.level_procedure);

6763: END IF;
6764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6765: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6766: p_prefix=>l_debug_prefix,
6767: p_msg_level=>fnd_log.level_procedure);
6768: END IF;
6769:
6770: -- Check if API is called in debug mode. If yes, disable debug.
6771: --disable_debug;

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

6777: p_count => x_msg_count,
6778: p_data => x_msg_data);
6779:
6780: -- Debug info.
6781: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6782: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6783: p_msg_data=>x_msg_data,
6784: p_msg_type=>'UNEXPECTED ERROR',
6785: p_msg_level=>fnd_log.level_error);

Line 6785: p_msg_level=>fnd_log.level_error);

6781: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6782: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6783: p_msg_data=>x_msg_data,
6784: p_msg_type=>'UNEXPECTED ERROR',
6785: p_msg_level=>fnd_log.level_error);
6786: END IF;
6787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6788: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6789: p_prefix=>l_debug_prefix,

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

6783: p_msg_data=>x_msg_data,
6784: p_msg_type=>'UNEXPECTED ERROR',
6785: p_msg_level=>fnd_log.level_error);
6786: END IF;
6787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6788: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6789: p_prefix=>l_debug_prefix,
6790: p_msg_level=>fnd_log.level_procedure);
6791: END IF;

Line 6790: p_msg_level=>fnd_log.level_procedure);

6786: END IF;
6787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6788: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6789: p_prefix=>l_debug_prefix,
6790: p_msg_level=>fnd_log.level_procedure);
6791: END IF;
6792:
6793: -- Check if API is called in debug mode. If yes, disable debug.
6794: --disable_debug;

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

6804: p_count => x_msg_count,
6805: p_data => x_msg_data);
6806:
6807: -- Debug info.
6808: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6809: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6810: p_msg_data=>x_msg_data,
6811: p_msg_type=>'SQL ERROR',
6812: p_msg_level=>fnd_log.level_error);

Line 6812: p_msg_level=>fnd_log.level_error);

6808: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6809: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6810: p_msg_data=>x_msg_data,
6811: p_msg_type=>'SQL ERROR',
6812: p_msg_level=>fnd_log.level_error);
6813: END IF;
6814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6815: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6816: p_prefix=>l_debug_prefix,

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

6810: p_msg_data=>x_msg_data,
6811: p_msg_type=>'SQL ERROR',
6812: p_msg_level=>fnd_log.level_error);
6813: END IF;
6814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6815: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6816: p_prefix=>l_debug_prefix,
6817: p_msg_level=>fnd_log.level_procedure);
6818: END IF;

Line 6817: p_msg_level=>fnd_log.level_procedure);

6813: END IF;
6814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6815: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6816: p_prefix=>l_debug_prefix,
6817: p_msg_level=>fnd_log.level_procedure);
6818: END IF;
6819:
6820: -- Check if API is called in debug mode. If yes, disable debug.
6821: --disable_debug;

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

6873: -- Check if API is called in debug mode. If yes, enable debug.
6874: --enable_debug;
6875:
6876: -- Debug info.
6877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6878: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (+)',
6879: p_prefix=>l_debug_prefix,
6880: p_msg_level=>fnd_log.level_procedure);
6881: END IF;

Line 6880: p_msg_level=>fnd_log.level_procedure);

6876: -- Debug info.
6877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6878: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (+)',
6879: p_prefix=>l_debug_prefix,
6880: p_msg_level=>fnd_log.level_procedure);
6881: END IF;
6882:
6883:
6884: -- Execute main procedure

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

6897: x_msg_data => x_msg_data
6898: );
6899:
6900: -- Debug info.
6901: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6902: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6903: p_msg_data=>x_msg_data,
6904: p_msg_type=>'WARNING',
6905: p_msg_level=>fnd_log.level_exception);

Line 6905: p_msg_level=>fnd_log.level_exception);

6901: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6902: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6903: p_msg_data=>x_msg_data,
6904: p_msg_type=>'WARNING',
6905: p_msg_level=>fnd_log.level_exception);
6906: END IF;
6907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6908: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6909: p_prefix=>l_debug_prefix,

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

6903: p_msg_data=>x_msg_data,
6904: p_msg_type=>'WARNING',
6905: p_msg_level=>fnd_log.level_exception);
6906: END IF;
6907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6908: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6909: p_prefix=>l_debug_prefix,
6910: p_msg_level=>fnd_log.level_procedure);
6911: END IF;

Line 6910: p_msg_level=>fnd_log.level_procedure);

6906: END IF;
6907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6908: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6909: p_prefix=>l_debug_prefix,
6910: p_msg_level=>fnd_log.level_procedure);
6911: END IF;
6912:
6913: -- Check if API is called in debug mode. If yes, disable debug.
6914: --disable_debug;

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

6921: p_count => x_msg_count,
6922: p_data => x_msg_data);
6923:
6924: -- Debug info.
6925: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6926: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6927: p_msg_data=>x_msg_data,
6928: p_msg_type=>'ERROR',
6929: p_msg_level=>fnd_log.level_error);

Line 6929: p_msg_level=>fnd_log.level_error);

6925: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6926: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6927: p_msg_data=>x_msg_data,
6928: p_msg_type=>'ERROR',
6929: p_msg_level=>fnd_log.level_error);
6930: END IF;
6931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6932: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6933: p_prefix=>l_debug_prefix,

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

6927: p_msg_data=>x_msg_data,
6928: p_msg_type=>'ERROR',
6929: p_msg_level=>fnd_log.level_error);
6930: END IF;
6931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6932: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6933: p_prefix=>l_debug_prefix,
6934: p_msg_level=>fnd_log.level_procedure);
6935: END IF;

Line 6934: p_msg_level=>fnd_log.level_procedure);

6930: END IF;
6931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6932: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6933: p_prefix=>l_debug_prefix,
6934: p_msg_level=>fnd_log.level_procedure);
6935: END IF;
6936:
6937: -- Check if API is called in debug mode. If yes, disable debug.
6938: --disable_debug;

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

6944: p_count => x_msg_count,
6945: p_data => x_msg_data);
6946:
6947: -- Debug info.
6948: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6949: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6950: p_msg_data=>x_msg_data,
6951: p_msg_type=>'UNEXPECTED ERROR',
6952: p_msg_level=>fnd_log.level_error);

Line 6952: p_msg_level=>fnd_log.level_error);

6948: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6949: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6950: p_msg_data=>x_msg_data,
6951: p_msg_type=>'UNEXPECTED ERROR',
6952: p_msg_level=>fnd_log.level_error);
6953: END IF;
6954: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6955: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6956: p_prefix=>l_debug_prefix,

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

6950: p_msg_data=>x_msg_data,
6951: p_msg_type=>'UNEXPECTED ERROR',
6952: p_msg_level=>fnd_log.level_error);
6953: END IF;
6954: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6955: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6956: p_prefix=>l_debug_prefix,
6957: p_msg_level=>fnd_log.level_procedure);
6958: END IF;

Line 6957: p_msg_level=>fnd_log.level_procedure);

6953: END IF;
6954: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6955: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6956: p_prefix=>l_debug_prefix,
6957: p_msg_level=>fnd_log.level_procedure);
6958: END IF;
6959:
6960: -- Check if API is called in debug mode. If yes, disable debug.
6961: --disable_debug;

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

6971: p_count => x_msg_count,
6972: p_data => x_msg_data);
6973:
6974: -- Debug info.
6975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6977: p_msg_data=>x_msg_data,
6978: p_msg_type=>'SQL ERROR',
6979: p_msg_level=>fnd_log.level_error);

Line 6979: p_msg_level=>fnd_log.level_error);

6975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6977: p_msg_data=>x_msg_data,
6978: p_msg_type=>'SQL ERROR',
6979: p_msg_level=>fnd_log.level_error);
6980: END IF;
6981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6982: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6983: p_prefix=>l_debug_prefix,

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

6977: p_msg_data=>x_msg_data,
6978: p_msg_type=>'SQL ERROR',
6979: p_msg_level=>fnd_log.level_error);
6980: END IF;
6981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6982: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6983: p_prefix=>l_debug_prefix,
6984: p_msg_level=>fnd_log.level_procedure);
6985: END IF;

Line 6984: p_msg_level=>fnd_log.level_procedure);

6980: END IF;
6981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6982: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
6983: p_prefix=>l_debug_prefix,
6984: p_msg_level=>fnd_log.level_procedure);
6985: END IF;
6986:
6987: -- Check if API is called in debug mode. If yes, disable debug.
6988: --disable_debug;