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 357: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

353: AND rownum = 1;
354:
355: BEGIN
356: -- Debug info.
357: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
358: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (+)',
359: p_prefix=>l_debug_prefix,
360: p_msg_level=>fnd_log.level_procedure);
361: END IF;

Line 360: p_msg_level=>fnd_log.level_procedure);

356: -- Debug info.
357: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
358: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (+)',
359: p_prefix=>l_debug_prefix,
360: p_msg_level=>fnd_log.level_procedure);
361: END IF;
362:
363: IF p_contact_point_rec.contact_point_type = 'EDI' THEN
364: l_edi_rec := p_edi_rec;

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

466: -- but can not be both. If raw_phone_number does not have a value,
467: -- it will be set by phone_number and phone_area_code.
468:
469: -- Debug info.
470: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'contact_point_type = ' || p_contact_point_rec.contact_point_type,
472: p_prefix =>l_debug_prefix,
473: p_msg_level=>fnd_log.level_statement);
474: END IF;

Line 473: p_msg_level=>fnd_log.level_statement);

469: -- Debug info.
470: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'contact_point_type = ' || p_contact_point_rec.contact_point_type,
472: p_prefix =>l_debug_prefix,
473: p_msg_level=>fnd_log.level_statement);
474: END IF;
475:
476: --To get territory code to pass to phone_format, first check if country code
477: --was passed in else get it from hz_locations for owner_table_name HZ_PARTY_SITES

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

561: END IF;
562: END IF;
563:
564: -- Debug info.
565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||
567: 'raw_phone_number = ' || l_phone_rec.raw_phone_number,
568: p_prefix =>l_debug_prefix,
569: p_msg_level=>fnd_log.level_statement);

Line 569: p_msg_level=>fnd_log.level_statement);

565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||
567: 'raw_phone_number = ' || l_phone_rec.raw_phone_number,
568: p_prefix =>l_debug_prefix,
569: p_msg_level=>fnd_log.level_statement);
570: END IF;
571:
572: -- Populate transposed_phone_number
573: IF l_phone_rec.phone_country_code IS NOT NULL AND

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

587: l_transposed_phone_number := hz_phone_number_pkg.transpose(
588: l_transposed_phone_number || l_phone_rec.phone_number);
589:
590: -- Debug info.
591: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,
593: p_prefix =>l_debug_prefix,
594: p_msg_level=>fnd_log.level_statement);
595: END IF;

Line 594: p_msg_level=>fnd_log.level_statement);

590: -- Debug info.
591: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,
593: p_prefix =>l_debug_prefix,
594: p_msg_level=>fnd_log.level_statement);
595: END IF;
596: END IF;
597:
598: -- If this is the first active contact point for the combination of

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

719: end if;
720:
721:
722: -- Debug info.
723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
724: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (+)',
725: p_prefix=>l_debug_prefix,
726: p_msg_level=>fnd_log.level_procedure);
727: END IF;

Line 726: p_msg_level=>fnd_log.level_procedure);

722: -- Debug info.
723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
724: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (+)',
725: p_prefix=>l_debug_prefix,
726: p_msg_level=>fnd_log.level_procedure);
727: END IF;
728:
729: -- Call table-handler.
730: hz_contact_points_pkg.insert_row (

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

799: -- url is mandatory if contact_point_type = 'WEB'.
800: -- email_address is mandatory if contact_point_type = 'EMAIL'.
801:
802: -- Debug info.
803: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
804: hz_utility_v2pub.debug(p_message=>'primary_flag = ' || p_contact_point_rec.primary_flag || ' ' ||
805: 'owner_table_name = '||p_contact_point_rec.owner_table_name||' '||
806: 'contact_point_type = '||p_contact_point_rec.contact_point_type||' '||
807: 'actual_content_source = ' || p_contact_point_rec.actual_content_source,

Line 809: p_msg_level=>fnd_log.level_statement);

805: 'owner_table_name = '||p_contact_point_rec.owner_table_name||' '||
806: 'contact_point_type = '||p_contact_point_rec.contact_point_type||' '||
807: 'actual_content_source = ' || p_contact_point_rec.actual_content_source,
808: p_prefix =>l_debug_prefix,
809: p_msg_level=>fnd_log.level_statement);
810: END IF;
811:
812: -- Bug 2197181: commented out NOCOPY the data source checking. We will denormalize
813: -- to hz_parties as long as it's a primary contact point regardless of data

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

874: END IF;
875: --End of Bug No: 3131865.
876:
877: -- Debug info.
878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
879: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (-) ' ||
880: 'x_contact_point_id = ' ||p_contact_point_rec.contact_point_id,
881: p_prefix=>l_debug_prefix,
882: p_msg_level=>fnd_log.level_procedure);

Line 882: p_msg_level=>fnd_log.level_procedure);

878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
879: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (-) ' ||
880: 'x_contact_point_id = ' ||p_contact_point_rec.contact_point_id,
881: p_prefix=>l_debug_prefix,
882: p_msg_level=>fnd_log.level_procedure);
883: END IF;
884: --Bug13117445
885: --Added DQM Sync call
886: hz_dqm_sync.sync_contact_point(x_contact_point_id, 'C');

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

906: end if;
907:
908:
909: -- Debug info.
910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
911: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
912: p_prefix=>l_debug_prefix,
913: p_msg_level=>fnd_log.level_procedure);
914: END IF;

Line 913: p_msg_level=>fnd_log.level_procedure);

909: -- Debug info.
910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
911: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
912: p_prefix=>l_debug_prefix,
913: p_msg_level=>fnd_log.level_procedure);
914: END IF;
915:
916: END do_create_contact_point;
917:

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

1082: AND contact_point_id <> p_contact_point_id);
1083:
1084: BEGIN
1085: -- Debug info.
1086: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1087: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (+)',
1088: p_prefix=>l_debug_prefix,
1089: p_msg_level=>fnd_log.level_procedure);
1090: END IF;

Line 1089: p_msg_level=>fnd_log.level_procedure);

1085: -- Debug info.
1086: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1087: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (+)',
1088: p_prefix=>l_debug_prefix,
1089: p_msg_level=>fnd_log.level_procedure);
1090: END IF;
1091:
1092:
1093: -- Lock record.

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

1137: RAISE fnd_api.g_exc_error;
1138: END;
1139:
1140: -- Debug info.
1141: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1142: hz_utility_v2pub.debug(p_message=>'l_contact_point_type = ' || l_contact_point_type,
1143: p_prefix =>l_debug_prefix,
1144: p_msg_level=>fnd_log.level_statement);
1145: END IF;

Line 1144: p_msg_level=>fnd_log.level_statement);

1140: -- Debug info.
1141: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1142: hz_utility_v2pub.debug(p_message=>'l_contact_point_type = ' || l_contact_point_type,
1143: p_prefix =>l_debug_prefix,
1144: p_msg_level=>fnd_log.level_statement);
1145: END IF;
1146:
1147:
1148: IF l_contact_point_type = 'EDI' THEN

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

1377: END IF;
1378: END IF;
1379:
1380: -- Debug info.
1381: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||
1383: 'raw_phone_number = ' || l_phone_rec.raw_phone_number,
1384: p_prefix =>l_debug_prefix,
1385: p_msg_level=>fnd_log.level_statement);

Line 1385: p_msg_level=>fnd_log.level_statement);

1381: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||
1383: 'raw_phone_number = ' || l_phone_rec.raw_phone_number,
1384: p_prefix =>l_debug_prefix,
1385: p_msg_level=>fnd_log.level_statement);
1386: END IF;
1387:
1388:
1389: -- Populate transposed_phone_number

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

1406: hz_phone_number_pkg.transpose(l_transposed_phone_number);
1407: END IF;
1408:
1409: -- Debug info.
1410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1411: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,
1412: p_prefix =>l_debug_prefix,
1413: p_msg_level=>fnd_log.level_statement);
1414: END IF;

Line 1413: p_msg_level=>fnd_log.level_statement);

1409: -- Debug info.
1410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1411: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,
1412: p_prefix =>l_debug_prefix,
1413: p_msg_level=>fnd_log.level_statement);
1414: END IF;
1415:
1416: END IF;
1417:

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

1713: -- but we should not update existing osr, set it to null
1714: end if;
1715:
1716: -- Debug info.
1717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1718: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',
1719: p_prefix=>l_debug_prefix,
1720: p_msg_level=>fnd_log.level_procedure);
1721: END IF;

Line 1720: p_msg_level=>fnd_log.level_procedure);

1716: -- Debug info.
1717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1718: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',
1719: p_prefix=>l_debug_prefix,
1720: p_msg_level=>fnd_log.level_procedure);
1721: END IF;
1722:
1723: -- Bug 4693719 : pass NULL if the secure data is not updated
1724: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

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

1795: x_actual_content_source => l_acs
1796: );
1797:
1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Update_Row (-) ',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',

Line 1802: p_msg_level=>fnd_log.level_procedure);

1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Update_Row (-) ',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
1804: p_prefix=>l_debug_prefix,
1805: p_msg_level=>fnd_log.level_procedure);
1806: END IF;

Line 1805: p_msg_level=>fnd_log.level_procedure);

1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
1804: p_prefix=>l_debug_prefix,
1805: p_msg_level=>fnd_log.level_procedure);
1806: END IF;
1807:
1808: END do_update_contact_point;
1809:

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

1882:
1883: BEGIN
1884:
1885: -- Debug info.
1886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1887: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (+)',
1888: p_prefix=>l_debug_prefix,
1889: p_msg_level=>fnd_log.level_procedure);
1890: END IF;

Line 1889: p_msg_level=>fnd_log.level_procedure);

1885: -- Debug info.
1886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1887: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (+)',
1888: p_prefix=>l_debug_prefix,
1889: p_msg_level=>fnd_log.level_procedure);
1890: END IF;
1891:
1892: /* BEGIN
1893: OPEN c_contact_point;

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

1932:
1933: l_contact_point_rec.contact_point_id := l_contactpointidtab(i);
1934:
1935: -- Debug info.
1936: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1937: hz_utility_v2pub.debug(p_message=>'Raising Business Event for Contact Point Id : '||l_contact_point_rec.contact_point_id,
1938: p_prefix=>l_debug_prefix,
1939: p_msg_level=>fnd_log.level_procedure);
1940: END IF;

Line 1939: p_msg_level=>fnd_log.level_procedure);

1935: -- Debug info.
1936: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1937: hz_utility_v2pub.debug(p_message=>'Raising Business Event for Contact Point Id : '||l_contact_point_rec.contact_point_id,
1938: p_prefix=>l_debug_prefix,
1939: p_msg_level=>fnd_log.level_procedure);
1940: END IF;
1941:
1942: hz_business_event_v2pvt.update_contact_point_event (
1943: l_contact_point_rec,

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

1973:
1974:
1975:
1976: -- Debug info.
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (-)',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;

Line 1980: p_msg_level=>fnd_log.level_procedure);

1976: -- Debug info.
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (-)',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;
1982:
1983: END do_unset_prim_contact_point;
1984:

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

2029: ) IS
2030: l_debug_prefix VARCHAR2(30) := '';
2031: BEGIN
2032: -- Debug info.
2033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2034: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (+)',
2035: p_prefix=>l_debug_prefix,
2036: p_msg_level=>fnd_log.level_procedure);
2037: END IF;

Line 2036: p_msg_level=>fnd_log.level_procedure);

2032: -- Debug info.
2033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2034: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (+)',
2035: p_prefix=>l_debug_prefix,
2036: p_msg_level=>fnd_log.level_procedure);
2037: END IF;
2038: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2039: hz_utility_v2pub.debug(p_message=>'party_id = ' || p_party_id || ' ' ||
2040: 'contact_point_type = ' || p_contact_point_type || ' ' ||

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

2034: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (+)',
2035: p_prefix=>l_debug_prefix,
2036: p_msg_level=>fnd_log.level_procedure);
2037: END IF;
2038: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2039: hz_utility_v2pub.debug(p_message=>'party_id = ' || p_party_id || ' ' ||
2040: 'contact_point_type = ' || p_contact_point_type || ' ' ||
2041: 'url = ' || p_url || ' ' ||
2042: 'email_address = ' || p_email_address||

Line 2051: p_msg_level=>fnd_log.level_statement);

2047: 'primary_phone_area_code = ' || p_phone_area_code || ' ' ||
2048: 'primary_phone_number = ' || p_phone_number || ' ' ||
2049: 'primary_phone_extension = ' || p_phone_extension ,
2050: p_prefix =>l_debug_prefix,
2051: p_msg_level=>fnd_log.level_statement);
2052: END IF;
2053:
2054:
2055: IF p_contact_point_type = 'WEB' THEN

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

2094: WHERE party_id = p_party_id;
2095: END IF;
2096:
2097: -- Debug info.
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (-)',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;

Line 2101: p_msg_level=>fnd_log.level_procedure);

2097: -- Debug info.
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (-)',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;
2103:
2104: END do_denormalize_contact_point;
2105:

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

2163: I NUMBER;
2164: BEGIN
2165:
2166: -- Debug info.
2167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2168: hz_utility_v2pub.debug(p_message=>'do_unset_primary_by_purpose (+)',
2169: p_prefix=>l_debug_prefix,
2170: p_msg_level=>fnd_log.level_procedure);
2171: END IF;

Line 2170: p_msg_level=>fnd_log.level_procedure);

2166: -- Debug info.
2167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2168: hz_utility_v2pub.debug(p_message=>'do_unset_primary_by_purpose (+)',
2169: p_prefix=>l_debug_prefix,
2170: p_msg_level=>fnd_log.level_procedure);
2171: END IF;
2172:
2173: -- Check during insert.
2174: IF p_contact_point_id IS NULL THEN

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

2208:
2209: l_contact_point_rec.contact_point_id := l_contactpointidtab(i);
2210:
2211: -- Debug info.
2212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2213: hz_utility_v2pub.debug(p_message=>'Raising Business Event for Contact Point Id : '||l_contact_point_rec.contact_point_id,
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=>'Raising Business Event for Contact Point Id : '||l_contact_point_rec.contact_point_id,
2214: p_prefix=>l_debug_prefix,
2215: p_msg_level=>fnd_log.level_procedure);
2216: END IF;
2217:
2218: hz_business_event_v2pvt.update_contact_point_event (
2219: l_contact_point_rec,

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

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

Line 2245: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 2286: p_msg_level=>fnd_log.level_procedure);

2282: -- Debug info.
2283: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2284: hz_utility_v2pub.debug(p_message=>'filter_phone_number (+)',
2285: p_prefix=>l_debug_prefix,
2286: p_msg_level=>fnd_log.level_procedure);
2287: END IF;
2288:
2289: IF p_isformat = 0 THEN
2290: l_filtered_number := TRANSLATE (

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

2298: '9');
2299: END IF;
2300:
2301: -- Debug info.
2302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2303: hz_utility_v2pub.debug(p_message=>'filter_phone_number (-)',
2304: p_prefix=>l_debug_prefix,
2305: p_msg_level=>fnd_log.level_procedure);
2306: END IF;

Line 2305: p_msg_level=>fnd_log.level_procedure);

2301: -- Debug info.
2302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2303: hz_utility_v2pub.debug(p_message=>'filter_phone_number (-)',
2304: p_prefix=>l_debug_prefix,
2305: p_msg_level=>fnd_log.level_procedure);
2306: END IF;
2307:
2308: RETURN l_filtered_number;
2309:

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

2361:
2362: BEGIN
2363:
2364: -- Debug info.
2365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2366: hz_utility_v2pub.debug(p_message=>'get_phone_format (+)',
2367: p_prefix=>l_debug_prefix,
2368: p_msg_level=>fnd_log.level_procedure);
2369: END IF;

Line 2368: p_msg_level=>fnd_log.level_procedure);

2364: -- Debug info.
2365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2366: hz_utility_v2pub.debug(p_message=>'get_phone_format (+)',
2367: p_prefix=>l_debug_prefix,
2368: p_msg_level=>fnd_log.level_procedure);
2369: END IF;
2370:
2371: -- Initialize return variables
2372: x_phone_format_style := fnd_api.g_miss_char;

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

2431: x_msg := 'HZ_PHONE_FORMAT_NOT_DEFINED';
2432: END IF;
2433:
2434: -- Debug info.
2435: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2436: hz_utility_v2pub.debug(p_message=>'get_phone_format (-)',
2437: p_prefix=>l_debug_prefix,
2438: p_msg_level=>fnd_log.level_procedure);
2439: END IF;

Line 2438: p_msg_level=>fnd_log.level_procedure);

2434: -- Debug info.
2435: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2436: hz_utility_v2pub.debug(p_message=>'get_phone_format (-)',
2437: p_prefix=>l_debug_prefix,
2438: p_msg_level=>fnd_log.level_procedure);
2439: END IF;
2440:
2441: EXCEPTION
2442: WHEN OTHERS THEN

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

2487:
2488: BEGIN
2489:
2490: -- Debug info.
2491: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2492: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (+)',
2493: p_prefix=>l_debug_prefix,
2494: p_msg_level=>fnd_log.level_procedure);
2495: END IF;

Line 2494: p_msg_level=>fnd_log.level_procedure);

2490: -- Debug info.
2491: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2492: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (+)',
2493: p_prefix=>l_debug_prefix,
2494: p_msg_level=>fnd_log.level_procedure);
2495: END IF;
2496:
2497: l_format_length := LENGTHB(p_phone_format_style);
2498: x_formatted_phone_number := '';

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

2517: x_phone_area_code := SUBSTRB(p_raw_phone_number, 1, p_area_code_size);
2518: x_phone_number := SUBSTRB(p_raw_phone_number, p_area_code_size + 1);
2519:
2520: -- Debug info.
2521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2522: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (-)',
2523: p_prefix=>l_debug_prefix,
2524: p_msg_level=>fnd_log.level_procedure);
2525: END IF;

Line 2524: p_msg_level=>fnd_log.level_procedure);

2520: -- Debug info.
2521: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2522: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (-)',
2523: p_prefix=>l_debug_prefix,
2524: p_msg_level=>fnd_log.level_procedure);
2525: END IF;
2526:
2527: END translate_raw_phone_number;
2528:

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

2587: l_debug_prefix VARCHAR2(30) := '';
2588: BEGIN
2589: -- Debug info.
2590:
2591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2592: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (+)',
2593: p_prefix=>l_debug_prefix,
2594: p_msg_level=>fnd_log.level_procedure);
2595: END IF;

Line 2594: p_msg_level=>fnd_log.level_procedure);

2590:
2591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2592: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (+)',
2593: p_prefix=>l_debug_prefix,
2594: p_msg_level=>fnd_log.level_procedure);
2595: END IF;
2596:
2597: -- Initialize message list if p_init_msg_list is set to TRUE.
2598: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

2613:
2614: x_contact_point_rec.contact_point_id := p_contact_point_id;
2615:
2616: -- Debug info.
2617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2618: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Select_Row (+)',
2619: p_prefix=>l_debug_prefix,
2620: p_msg_level=>fnd_log.level_procedure);
2621: END IF;

Line 2620: p_msg_level=>fnd_log.level_procedure);

2616: -- Debug info.
2617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2618: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Select_Row (+)',
2619: p_prefix=>l_debug_prefix,
2620: p_msg_level=>fnd_log.level_procedure);
2621: END IF;
2622:
2623: -- Call table-handler
2624: hz_contact_points_pkg.select_row (

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

2685: x_actual_content_source => x_contact_point_rec.actual_content_source
2686: );
2687:
2688: -- Debug info.
2689: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2690: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Select_Row (-)',
2691: p_prefix=>l_debug_prefix,
2692: p_msg_level=>fnd_log.level_procedure);
2693: END IF;

Line 2692: p_msg_level=>fnd_log.level_procedure);

2688: -- Debug info.
2689: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2690: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Select_Row (-)',
2691: p_prefix=>l_debug_prefix,
2692: p_msg_level=>fnd_log.level_procedure);
2693: END IF;
2694:
2695: -- Standard call to get message count and if count is 1, get message info.
2696: fnd_msg_pub.count_and_get(

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

2699: p_data => x_msg_data);
2700:
2701: -- Debug info.
2702:
2703: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2704: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (-)',
2705: p_prefix=>l_debug_prefix,
2706: p_msg_level=>fnd_log.level_procedure);
2707: END IF;

Line 2706: p_msg_level=>fnd_log.level_procedure);

2702:
2703: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2704: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (-)',
2705: p_prefix=>l_debug_prefix,
2706: p_msg_level=>fnd_log.level_procedure);
2707: END IF;
2708: END get_contact_point_main;
2709:
2710: --

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

2780: l_debug_prefix VARCHAR2(30) := '';
2781:
2782: BEGIN
2783: -- Debug info.
2784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2785: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (+)',
2786: p_prefix=>l_debug_prefix,
2787: p_msg_level=>fnd_log.level_procedure);
2788: END IF;

Line 2787: p_msg_level=>fnd_log.level_procedure);

2783: -- Debug info.
2784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2785: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (+)',
2786: p_prefix=>l_debug_prefix,
2787: p_msg_level=>fnd_log.level_procedure);
2788: END IF;
2789:
2790: -- Initialize message list if p_init_msg_list is set to TRUE.
2791: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

2923: p_count => x_msg_count,
2924: p_data => x_msg_data);
2925:
2926: -- Debug info.
2927: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2928: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (-)',
2929: p_prefix=>l_debug_prefix,
2930: p_msg_level=>fnd_log.level_procedure);
2931: END IF;

Line 2930: p_msg_level=>fnd_log.level_procedure);

2926: -- Debug info.
2927: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2928: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (-)',
2929: p_prefix=>l_debug_prefix,
2930: p_msg_level=>fnd_log.level_procedure);
2931: END IF;
2932: END create_contact_point_main;
2933:
2934: --

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

3023: l_debug_prefix VARCHAR2(30) := '';
3024:
3025: BEGIN
3026: -- Debug info.
3027: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3028: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (+)',
3029: p_prefix=>l_debug_prefix,
3030: p_msg_level=>fnd_log.level_procedure);
3031: END IF;

Line 3030: p_msg_level=>fnd_log.level_procedure);

3026: -- Debug info.
3027: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3028: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (+)',
3029: p_prefix=>l_debug_prefix,
3030: p_msg_level=>fnd_log.level_procedure);
3031: END IF;
3032:
3033: -- Initialize message list if p_init_msg_list is set to TRUE.
3034: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

3254: p_count => x_msg_count,
3255: p_data => x_msg_data);
3256:
3257: -- Debug info.
3258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (-)',
3260: p_prefix=>l_debug_prefix,
3261: p_msg_level=>fnd_log.level_procedure);
3262: END IF;

Line 3261: p_msg_level=>fnd_log.level_procedure);

3257: -- Debug info.
3258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (-)',
3260: p_prefix=>l_debug_prefix,
3261: p_msg_level=>fnd_log.level_procedure);
3262: END IF;
3263: END update_contact_point_main;
3264:
3265: --------------------------------------

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

3329: -- Check if API is called in debug mode. If yes, enable debug.
3330: --enable_debug;
3331:
3332: -- Debug info.
3333: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3334: hz_utility_v2pub.debug(p_message=>'create_contact_point (+)',
3335: p_prefix=>l_debug_prefix,
3336: p_msg_level=>fnd_log.level_procedure);
3337: END IF;

Line 3336: p_msg_level=>fnd_log.level_procedure);

3332: -- Debug info.
3333: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3334: hz_utility_v2pub.debug(p_message=>'create_contact_point (+)',
3335: p_prefix=>l_debug_prefix,
3336: p_msg_level=>fnd_log.level_procedure);
3337: END IF;
3338:
3339: -- Call to the main business logic.
3340: create_contact_point_main(

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

3351: x_msg_data => x_msg_data
3352: );
3353:
3354: -- Debug info.
3355: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3356: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3357: p_msg_data=>x_msg_data,
3358: p_msg_type=>'WARNING',
3359: p_msg_level=>fnd_log.level_exception);

Line 3359: p_msg_level=>fnd_log.level_exception);

3355: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3356: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3357: p_msg_data=>x_msg_data,
3358: p_msg_type=>'WARNING',
3359: p_msg_level=>fnd_log.level_exception);
3360: END IF;
3361: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3362: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3363: p_prefix=>l_debug_prefix,

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

3357: p_msg_data=>x_msg_data,
3358: p_msg_type=>'WARNING',
3359: p_msg_level=>fnd_log.level_exception);
3360: END IF;
3361: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3362: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3363: p_prefix=>l_debug_prefix,
3364: p_msg_level=>fnd_log.level_procedure);
3365: END IF;

Line 3364: p_msg_level=>fnd_log.level_procedure);

3360: END IF;
3361: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3362: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3363: p_prefix=>l_debug_prefix,
3364: p_msg_level=>fnd_log.level_procedure);
3365: END IF;
3366:
3367: -- Check if API is called in debug mode. If yes, disable debug.
3368: --disable_debug;

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

3376: p_count => x_msg_count,
3377: p_data => x_msg_data);
3378:
3379: -- Debug info.
3380: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3381: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3382: p_msg_data=>x_msg_data,
3383: p_msg_type=>'ERROR',
3384: p_msg_level=>fnd_log.level_error);

Line 3384: p_msg_level=>fnd_log.level_error);

3380: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3381: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3382: p_msg_data=>x_msg_data,
3383: p_msg_type=>'ERROR',
3384: p_msg_level=>fnd_log.level_error);
3385: END IF;
3386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3387: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3388: p_prefix=>l_debug_prefix,

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

3382: p_msg_data=>x_msg_data,
3383: p_msg_type=>'ERROR',
3384: p_msg_level=>fnd_log.level_error);
3385: END IF;
3386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3387: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3388: p_prefix=>l_debug_prefix,
3389: p_msg_level=>fnd_log.level_procedure);
3390: END IF;

Line 3389: p_msg_level=>fnd_log.level_procedure);

3385: END IF;
3386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3387: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3388: p_prefix=>l_debug_prefix,
3389: p_msg_level=>fnd_log.level_procedure);
3390: END IF;
3391:
3392:
3393: -- Check if API is called in debug mode. If yes, disable debug.

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

3401: p_count => x_msg_count,
3402: p_data => x_msg_data);
3403:
3404: -- Debug info.
3405: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3407: p_msg_data=>x_msg_data,
3408: p_msg_type=>'UNEXPECTED ERROR',
3409: p_msg_level=>fnd_log.level_error);

Line 3409: p_msg_level=>fnd_log.level_error);

3405: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3407: p_msg_data=>x_msg_data,
3408: p_msg_type=>'UNEXPECTED ERROR',
3409: p_msg_level=>fnd_log.level_error);
3410: END IF;
3411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3412: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3413: p_prefix=>l_debug_prefix,

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

3407: p_msg_data=>x_msg_data,
3408: p_msg_type=>'UNEXPECTED ERROR',
3409: p_msg_level=>fnd_log.level_error);
3410: END IF;
3411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3412: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3413: p_prefix=>l_debug_prefix,
3414: p_msg_level=>fnd_log.level_procedure);
3415: END IF;

Line 3414: p_msg_level=>fnd_log.level_procedure);

3410: END IF;
3411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3412: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3413: p_prefix=>l_debug_prefix,
3414: p_msg_level=>fnd_log.level_procedure);
3415: END IF;
3416:
3417: -- Check if API is called in debug mode. If yes, disable debug.
3418: --disable_debug;

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

3429: p_count => x_msg_count,
3430: p_data => x_msg_data);
3431:
3432: -- Debug info.
3433: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3434: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3435: p_msg_data=>x_msg_data,
3436: p_msg_type=>'SQL ERROR',
3437: p_msg_level=>fnd_log.level_error);

Line 3437: p_msg_level=>fnd_log.level_error);

3433: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3434: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3435: p_msg_data=>x_msg_data,
3436: p_msg_type=>'SQL ERROR',
3437: p_msg_level=>fnd_log.level_error);
3438: END IF;
3439: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3440: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3441: p_prefix=>l_debug_prefix,

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

3435: p_msg_data=>x_msg_data,
3436: p_msg_type=>'SQL ERROR',
3437: p_msg_level=>fnd_log.level_error);
3438: END IF;
3439: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3440: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3441: p_prefix=>l_debug_prefix,
3442: p_msg_level=>fnd_log.level_procedure);
3443: END IF;

Line 3442: p_msg_level=>fnd_log.level_procedure);

3438: END IF;
3439: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3440: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',
3441: p_prefix=>l_debug_prefix,
3442: p_msg_level=>fnd_log.level_procedure);
3443: END IF;
3444:
3445: -- Check if API is called in debug mode. If yes, disable debug.
3446: --disable_debug;

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

3500: -- Check if API is called in debug mode. If yes, enable debug.
3501: --enable_debug;
3502:
3503: -- Debug info.
3504: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3505: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
3506: p_prefix=>l_debug_prefix,
3507: p_msg_level=>fnd_log.level_procedure);
3508: END IF;

Line 3507: p_msg_level=>fnd_log.level_procedure);

3503: -- Debug info.
3504: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3505: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
3506: p_prefix=>l_debug_prefix,
3507: p_msg_level=>fnd_log.level_procedure);
3508: END IF;
3509:
3510: -- Call to the main business logic.
3511: create_contact_point_main(

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

3518: x_msg_data => x_msg_data
3519: );
3520:
3521: -- Debug info.
3522: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3523: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3524: p_msg_data=>x_msg_data,
3525: p_msg_type=>'WARNING',
3526: p_msg_level=>fnd_log.level_exception);

Line 3526: p_msg_level=>fnd_log.level_exception);

3522: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3523: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3524: p_msg_data=>x_msg_data,
3525: p_msg_type=>'WARNING',
3526: p_msg_level=>fnd_log.level_exception);
3527: END IF;
3528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3529: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3530: p_prefix=>l_debug_prefix,

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

3524: p_msg_data=>x_msg_data,
3525: p_msg_type=>'WARNING',
3526: p_msg_level=>fnd_log.level_exception);
3527: END IF;
3528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3529: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3530: p_prefix=>l_debug_prefix,
3531: p_msg_level=>fnd_log.level_procedure);
3532: END IF;

Line 3531: p_msg_level=>fnd_log.level_procedure);

3527: END IF;
3528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3529: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3530: p_prefix=>l_debug_prefix,
3531: p_msg_level=>fnd_log.level_procedure);
3532: END IF;
3533:
3534: -- Check if API is called in debug mode. If yes, disable debug.
3535: --disable_debug;

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

3543: p_count => x_msg_count,
3544: p_data => x_msg_data);
3545:
3546: -- Debug info.
3547: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3548: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3549: p_msg_data=>x_msg_data,
3550: p_msg_type=>'ERROR',
3551: p_msg_level=>fnd_log.level_error);

Line 3551: p_msg_level=>fnd_log.level_error);

3547: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3548: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3549: p_msg_data=>x_msg_data,
3550: p_msg_type=>'ERROR',
3551: p_msg_level=>fnd_log.level_error);
3552: END IF;
3553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3554: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3555: p_prefix=>l_debug_prefix,

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

3549: p_msg_data=>x_msg_data,
3550: p_msg_type=>'ERROR',
3551: p_msg_level=>fnd_log.level_error);
3552: END IF;
3553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3554: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3555: p_prefix=>l_debug_prefix,
3556: p_msg_level=>fnd_log.level_procedure);
3557: END IF;

Line 3556: p_msg_level=>fnd_log.level_procedure);

3552: END IF;
3553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3554: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3555: p_prefix=>l_debug_prefix,
3556: p_msg_level=>fnd_log.level_procedure);
3557: END IF;
3558:
3559: -- Check if API is called in debug mode. If yes, disable debug.
3560: --disable_debug;

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

3567: p_count => x_msg_count,
3568: p_data => x_msg_data);
3569:
3570: -- Debug info.
3571: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3572: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3573: p_msg_data=>x_msg_data,
3574: p_msg_type=>'UNEXPECTED ERROR',
3575: p_msg_level=>fnd_log.level_error);

Line 3575: p_msg_level=>fnd_log.level_error);

3571: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3572: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3573: p_msg_data=>x_msg_data,
3574: p_msg_type=>'UNEXPECTED ERROR',
3575: p_msg_level=>fnd_log.level_error);
3576: END IF;
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3579: p_prefix=>l_debug_prefix,

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

3573: p_msg_data=>x_msg_data,
3574: p_msg_type=>'UNEXPECTED ERROR',
3575: p_msg_level=>fnd_log.level_error);
3576: END IF;
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3579: p_prefix=>l_debug_prefix,
3580: p_msg_level=>fnd_log.level_procedure);
3581: END IF;

Line 3580: p_msg_level=>fnd_log.level_procedure);

3576: END IF;
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3579: p_prefix=>l_debug_prefix,
3580: p_msg_level=>fnd_log.level_procedure);
3581: END IF;
3582:
3583: -- Check if API is called in debug mode. If yes, disable debug.
3584: --disable_debug;

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

3595: p_count => x_msg_count,
3596: p_data => x_msg_data);
3597:
3598: -- Debug info.
3599: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3601: p_msg_data=>x_msg_data,
3602: p_msg_type=>'SQL ERROR',
3603: p_msg_level=>fnd_log.level_error);

Line 3603: p_msg_level=>fnd_log.level_error);

3599: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3601: p_msg_data=>x_msg_data,
3602: p_msg_type=>'SQL ERROR',
3603: p_msg_level=>fnd_log.level_error);
3604: END IF;
3605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3606: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3607: p_prefix=>l_debug_prefix,

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

3601: p_msg_data=>x_msg_data,
3602: p_msg_type=>'SQL ERROR',
3603: p_msg_level=>fnd_log.level_error);
3604: END IF;
3605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3606: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3607: p_prefix=>l_debug_prefix,
3608: p_msg_level=>fnd_log.level_procedure);
3609: END IF;

Line 3608: p_msg_level=>fnd_log.level_procedure);

3604: END IF;
3605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3606: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
3607: p_prefix=>l_debug_prefix,
3608: p_msg_level=>fnd_log.level_procedure);
3609: END IF;
3610:
3611: -- Check if API is called in debug mode. If yes, disable debug.
3612: --disable_debug;

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

3666: -- Check if API is called in debug mode. If yes, enable debug.
3667: --enable_debug;
3668:
3669: -- Debug info.
3670: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3671: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
3672: p_prefix=>l_debug_prefix,
3673: p_msg_level=>fnd_log.level_procedure);
3674: END IF;

Line 3673: p_msg_level=>fnd_log.level_procedure);

3669: -- Debug info.
3670: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3671: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
3672: p_prefix=>l_debug_prefix,
3673: p_msg_level=>fnd_log.level_procedure);
3674: END IF;
3675:
3676: -- Call to the main business logic.
3677: create_contact_point_main(

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

3684: x_msg_data => x_msg_data
3685: );
3686:
3687: -- Debug info.
3688: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3689: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3690: p_msg_data=>x_msg_data,
3691: p_msg_type=>'WARNING',
3692: p_msg_level=>fnd_log.level_exception);

Line 3692: p_msg_level=>fnd_log.level_exception);

3688: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3689: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3690: p_msg_data=>x_msg_data,
3691: p_msg_type=>'WARNING',
3692: p_msg_level=>fnd_log.level_exception);
3693: END IF;
3694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3695: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3696: p_prefix=>l_debug_prefix,

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

3690: p_msg_data=>x_msg_data,
3691: p_msg_type=>'WARNING',
3692: p_msg_level=>fnd_log.level_exception);
3693: END IF;
3694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3695: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3696: p_prefix=>l_debug_prefix,
3697: p_msg_level=>fnd_log.level_procedure);
3698: END IF;

Line 3697: p_msg_level=>fnd_log.level_procedure);

3693: END IF;
3694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3695: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3696: p_prefix=>l_debug_prefix,
3697: p_msg_level=>fnd_log.level_procedure);
3698: END IF;
3699:
3700: -- Check if API is called in debug mode. If yes, disable debug.
3701: --disable_debug;

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

3709: p_count => x_msg_count,
3710: p_data => x_msg_data);
3711:
3712: -- Debug info.
3713: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3714: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3715: p_msg_data=>x_msg_data,
3716: p_msg_type=>'ERROR',
3717: p_msg_level=>fnd_log.level_error);

Line 3717: p_msg_level=>fnd_log.level_error);

3713: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3714: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3715: p_msg_data=>x_msg_data,
3716: p_msg_type=>'ERROR',
3717: p_msg_level=>fnd_log.level_error);
3718: END IF;
3719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3720: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3721: p_prefix=>l_debug_prefix,

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

3715: p_msg_data=>x_msg_data,
3716: p_msg_type=>'ERROR',
3717: p_msg_level=>fnd_log.level_error);
3718: END IF;
3719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3720: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3721: p_prefix=>l_debug_prefix,
3722: p_msg_level=>fnd_log.level_procedure);
3723: END IF;

Line 3722: p_msg_level=>fnd_log.level_procedure);

3718: END IF;
3719: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3720: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3721: p_prefix=>l_debug_prefix,
3722: p_msg_level=>fnd_log.level_procedure);
3723: END IF;
3724:
3725: -- Check if API is called in debug mode. If yes, disable debug.
3726: --disable_debug;

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

3733: p_count => x_msg_count,
3734: p_data => x_msg_data);
3735:
3736: -- Debug info.
3737: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3738: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3739: p_msg_data=>x_msg_data,
3740: p_msg_type=>'UNEXPECTED ERROR',
3741: p_msg_level=>fnd_log.level_error);

Line 3741: p_msg_level=>fnd_log.level_error);

3737: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3738: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3739: p_msg_data=>x_msg_data,
3740: p_msg_type=>'UNEXPECTED ERROR',
3741: p_msg_level=>fnd_log.level_error);
3742: END IF;
3743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3744: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3745: p_prefix=>l_debug_prefix,

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

3739: p_msg_data=>x_msg_data,
3740: p_msg_type=>'UNEXPECTED ERROR',
3741: p_msg_level=>fnd_log.level_error);
3742: END IF;
3743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3744: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3745: p_prefix=>l_debug_prefix,
3746: p_msg_level=>fnd_log.level_procedure);
3747: END IF;

Line 3746: p_msg_level=>fnd_log.level_procedure);

3742: END IF;
3743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3744: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3745: p_prefix=>l_debug_prefix,
3746: p_msg_level=>fnd_log.level_procedure);
3747: END IF;
3748:
3749: -- Check if API is called in debug mode. If yes, disable debug.
3750: --disable_debug;

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

3761: p_count => x_msg_count,
3762: p_data => x_msg_data);
3763:
3764: -- Debug info.
3765: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3766: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3767: p_msg_data=>x_msg_data,
3768: p_msg_type=>'SQL ERROR',
3769: p_msg_level=>fnd_log.level_error);

Line 3769: p_msg_level=>fnd_log.level_error);

3765: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3766: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3767: p_msg_data=>x_msg_data,
3768: p_msg_type=>'SQL ERROR',
3769: p_msg_level=>fnd_log.level_error);
3770: END IF;
3771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3772: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3773: p_prefix=>l_debug_prefix,

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

3767: p_msg_data=>x_msg_data,
3768: p_msg_type=>'SQL ERROR',
3769: p_msg_level=>fnd_log.level_error);
3770: END IF;
3771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3772: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3773: p_prefix=>l_debug_prefix,
3774: p_msg_level=>fnd_log.level_procedure);
3775: END IF;

Line 3774: p_msg_level=>fnd_log.level_procedure);

3770: END IF;
3771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3772: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
3773: p_prefix=>l_debug_prefix,
3774: p_msg_level=>fnd_log.level_procedure);
3775: END IF;
3776:
3777: -- Check if API is called in debug mode. If yes, disable debug.
3778: --disable_debug;

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

3834: -- Check if API is called in debug mode. If yes, enable debug.
3835: --enable_debug;
3836:
3837: -- Debug info.
3838: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3839: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
3840: p_prefix=>l_debug_prefix,
3841: p_msg_level=>fnd_log.level_procedure);
3842: END IF;

Line 3841: p_msg_level=>fnd_log.level_procedure);

3837: -- Debug info.
3838: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3839: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
3840: p_prefix=>l_debug_prefix,
3841: p_msg_level=>fnd_log.level_procedure);
3842: END IF;
3843:
3844: -- Call to the main business logic.
3845: create_contact_point_main(

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

3852: x_msg_data => x_msg_data
3853: );
3854:
3855: -- Debug info.
3856: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3857: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3858: p_msg_data=>x_msg_data,
3859: p_msg_type=>'WARNING',
3860: p_msg_level=>fnd_log.level_exception);

Line 3860: p_msg_level=>fnd_log.level_exception);

3856: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3857: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3858: p_msg_data=>x_msg_data,
3859: p_msg_type=>'WARNING',
3860: p_msg_level=>fnd_log.level_exception);
3861: END IF;
3862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3863: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3864: p_prefix=>l_debug_prefix,

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

3858: p_msg_data=>x_msg_data,
3859: p_msg_type=>'WARNING',
3860: p_msg_level=>fnd_log.level_exception);
3861: END IF;
3862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3863: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3864: p_prefix=>l_debug_prefix,
3865: p_msg_level=>fnd_log.level_procedure);
3866: END IF;

Line 3865: p_msg_level=>fnd_log.level_procedure);

3861: END IF;
3862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3863: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3864: p_prefix=>l_debug_prefix,
3865: p_msg_level=>fnd_log.level_procedure);
3866: END IF;
3867:
3868:
3869: -- Check if API is called in debug mode. If yes, disable debug.

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

3878: p_count => x_msg_count,
3879: p_data => x_msg_data);
3880:
3881: -- Debug info.
3882: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3883: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3884: p_msg_data=>x_msg_data,
3885: p_msg_type=>'ERROR',
3886: p_msg_level=>fnd_log.level_error);

Line 3886: p_msg_level=>fnd_log.level_error);

3882: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3883: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3884: p_msg_data=>x_msg_data,
3885: p_msg_type=>'ERROR',
3886: p_msg_level=>fnd_log.level_error);
3887: END IF;
3888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3889: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3890: p_prefix=>l_debug_prefix,

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

3884: p_msg_data=>x_msg_data,
3885: p_msg_type=>'ERROR',
3886: p_msg_level=>fnd_log.level_error);
3887: END IF;
3888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3889: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3890: p_prefix=>l_debug_prefix,
3891: p_msg_level=>fnd_log.level_procedure);
3892: END IF;

Line 3891: p_msg_level=>fnd_log.level_procedure);

3887: END IF;
3888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3889: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3890: p_prefix=>l_debug_prefix,
3891: p_msg_level=>fnd_log.level_procedure);
3892: END IF;
3893:
3894: -- Check if API is called in debug mode. If yes, disable debug.
3895: --disable_debug;

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

3902: p_count => x_msg_count,
3903: p_data => x_msg_data);
3904:
3905: -- Debug info.
3906: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3907: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3908: p_msg_data=>x_msg_data,
3909: p_msg_type=>'UNEXPECTED ERROR',
3910: p_msg_level=>fnd_log.level_error);

Line 3910: p_msg_level=>fnd_log.level_error);

3906: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3907: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3908: p_msg_data=>x_msg_data,
3909: p_msg_type=>'UNEXPECTED ERROR',
3910: p_msg_level=>fnd_log.level_error);
3911: END IF;
3912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3913: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3914: p_prefix=>l_debug_prefix,

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

3908: p_msg_data=>x_msg_data,
3909: p_msg_type=>'UNEXPECTED ERROR',
3910: p_msg_level=>fnd_log.level_error);
3911: END IF;
3912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3913: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3914: p_prefix=>l_debug_prefix,
3915: p_msg_level=>fnd_log.level_procedure);
3916: END IF;

Line 3915: p_msg_level=>fnd_log.level_procedure);

3911: END IF;
3912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3913: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3914: p_prefix=>l_debug_prefix,
3915: p_msg_level=>fnd_log.level_procedure);
3916: END IF;
3917:
3918: -- Check if API is called in debug mode. If yes, disable debug.
3919: --disable_debug;

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

3930: p_count => x_msg_count,
3931: p_data => x_msg_data);
3932:
3933: -- Debug info.
3934: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3936: p_msg_data=>x_msg_data,
3937: p_msg_type=>'SQL ERROR',
3938: p_msg_level=>fnd_log.level_error);

Line 3938: p_msg_level=>fnd_log.level_error);

3934: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3936: p_msg_data=>x_msg_data,
3937: p_msg_type=>'SQL ERROR',
3938: p_msg_level=>fnd_log.level_error);
3939: END IF;
3940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3941: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3942: p_prefix=>l_debug_prefix,

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

3936: p_msg_data=>x_msg_data,
3937: p_msg_type=>'SQL ERROR',
3938: p_msg_level=>fnd_log.level_error);
3939: END IF;
3940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3941: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3942: p_prefix=>l_debug_prefix,
3943: p_msg_level=>fnd_log.level_procedure);
3944: END IF;

Line 3943: p_msg_level=>fnd_log.level_procedure);

3939: END IF;
3940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3941: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
3942: p_prefix=>l_debug_prefix,
3943: p_msg_level=>fnd_log.level_procedure);
3944: END IF;
3945:
3946: -- Check if API is called in debug mode. If yes, disable debug.
3947: --disable_debug;

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

4001: -- Check if API is called in debug mode. If yes, enable debug.
4002: --enable_debug;
4003:
4004: -- Debug info.
4005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4006: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
4007: p_prefix=>l_debug_prefix,
4008: p_msg_level=>fnd_log.level_procedure);
4009: END IF;

Line 4008: p_msg_level=>fnd_log.level_procedure);

4004: -- Debug info.
4005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4006: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
4007: p_prefix=>l_debug_prefix,
4008: p_msg_level=>fnd_log.level_procedure);
4009: END IF;
4010:
4011:
4012: -- Call to the main business logic.

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

4020: x_msg_data => x_msg_data
4021: );
4022:
4023: -- Debug info.
4024: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4025: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4026: p_msg_data=>x_msg_data,
4027: p_msg_type=>'WARNING',
4028: p_msg_level=>fnd_log.level_exception);

Line 4028: p_msg_level=>fnd_log.level_exception);

4024: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4025: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4026: p_msg_data=>x_msg_data,
4027: p_msg_type=>'WARNING',
4028: p_msg_level=>fnd_log.level_exception);
4029: END IF;
4030: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4031: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4032: p_prefix=>l_debug_prefix,

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

4026: p_msg_data=>x_msg_data,
4027: p_msg_type=>'WARNING',
4028: p_msg_level=>fnd_log.level_exception);
4029: END IF;
4030: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4031: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4032: p_prefix=>l_debug_prefix,
4033: p_msg_level=>fnd_log.level_procedure);
4034: END IF;

Line 4033: p_msg_level=>fnd_log.level_procedure);

4029: END IF;
4030: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4031: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4032: p_prefix=>l_debug_prefix,
4033: p_msg_level=>fnd_log.level_procedure);
4034: END IF;
4035:
4036: -- Check if API is called in debug mode. If yes, disable debug.
4037: --disable_debug;

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

4045: p_count => x_msg_count,
4046: p_data => x_msg_data);
4047:
4048: -- Debug info.
4049: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4050: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4051: p_msg_data=>x_msg_data,
4052: p_msg_type=>'ERROR',
4053: p_msg_level=>fnd_log.level_error);

Line 4053: p_msg_level=>fnd_log.level_error);

4049: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4050: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4051: p_msg_data=>x_msg_data,
4052: p_msg_type=>'ERROR',
4053: p_msg_level=>fnd_log.level_error);
4054: END IF;
4055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4056: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4057: p_prefix=>l_debug_prefix,

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

4051: p_msg_data=>x_msg_data,
4052: p_msg_type=>'ERROR',
4053: p_msg_level=>fnd_log.level_error);
4054: END IF;
4055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4056: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4057: p_prefix=>l_debug_prefix,
4058: p_msg_level=>fnd_log.level_procedure);
4059: END IF;

Line 4058: p_msg_level=>fnd_log.level_procedure);

4054: END IF;
4055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4056: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4057: p_prefix=>l_debug_prefix,
4058: p_msg_level=>fnd_log.level_procedure);
4059: END IF;
4060:
4061: -- Check if API is called in debug mode. If yes, disable debug.
4062: --disable_debug;

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

4069: p_count => x_msg_count,
4070: p_data => x_msg_data);
4071:
4072: -- Debug info.
4073: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4074: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4075: p_msg_data=>x_msg_data,
4076: p_msg_type=>'UNEXPECTED ERROR',
4077: p_msg_level=>fnd_log.level_error);

Line 4077: p_msg_level=>fnd_log.level_error);

4073: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4074: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4075: p_msg_data=>x_msg_data,
4076: p_msg_type=>'UNEXPECTED ERROR',
4077: p_msg_level=>fnd_log.level_error);
4078: END IF;
4079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4080: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4081: p_prefix=>l_debug_prefix,

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

4075: p_msg_data=>x_msg_data,
4076: p_msg_type=>'UNEXPECTED ERROR',
4077: p_msg_level=>fnd_log.level_error);
4078: END IF;
4079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4080: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4081: p_prefix=>l_debug_prefix,
4082: p_msg_level=>fnd_log.level_procedure);
4083: END IF;

Line 4082: p_msg_level=>fnd_log.level_procedure);

4078: END IF;
4079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4080: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4081: p_prefix=>l_debug_prefix,
4082: p_msg_level=>fnd_log.level_procedure);
4083: END IF;
4084:
4085: -- Check if API is called in debug mode. If yes, disable debug.
4086: --disable_debug;

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

4097: p_count => x_msg_count,
4098: p_data => x_msg_data);
4099:
4100: -- Debug info.
4101: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4102: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4103: p_msg_data=>x_msg_data,
4104: p_msg_type=>'SQL ERROR',
4105: p_msg_level=>fnd_log.level_error);

Line 4105: p_msg_level=>fnd_log.level_error);

4101: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4102: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4103: p_msg_data=>x_msg_data,
4104: p_msg_type=>'SQL ERROR',
4105: p_msg_level=>fnd_log.level_error);
4106: END IF;
4107: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4108: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4109: p_prefix=>l_debug_prefix,

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

4103: p_msg_data=>x_msg_data,
4104: p_msg_type=>'SQL ERROR',
4105: p_msg_level=>fnd_log.level_error);
4106: END IF;
4107: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4108: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4109: p_prefix=>l_debug_prefix,
4110: p_msg_level=>fnd_log.level_procedure);
4111: END IF;

Line 4110: p_msg_level=>fnd_log.level_procedure);

4106: END IF;
4107: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4108: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
4109: p_prefix=>l_debug_prefix,
4110: p_msg_level=>fnd_log.level_procedure);
4111: END IF;
4112:
4113: -- Check if API is called in debug mode. If yes, disable debug.
4114: --disable_debug;

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

4168: -- Check if API is called in debug mode. If yes, enable debug.
4169: --enable_debug;
4170:
4171: -- Debug info.
4172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4173: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
4174: p_prefix=>l_debug_prefix,
4175: p_msg_level=>fnd_log.level_procedure);
4176: END IF;

Line 4175: p_msg_level=>fnd_log.level_procedure);

4171: -- Debug info.
4172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4173: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
4174: p_prefix=>l_debug_prefix,
4175: p_msg_level=>fnd_log.level_procedure);
4176: END IF;
4177:
4178: -- Call to the main business logic.
4179: create_contact_point_main(

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

4186: x_msg_data => x_msg_data
4187: );
4188:
4189: -- Debug info.
4190: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4191: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4192: p_msg_data=>x_msg_data,
4193: p_msg_type=>'WARNING',
4194: p_msg_level=>fnd_log.level_exception);

Line 4194: p_msg_level=>fnd_log.level_exception);

4190: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4191: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4192: p_msg_data=>x_msg_data,
4193: p_msg_type=>'WARNING',
4194: p_msg_level=>fnd_log.level_exception);
4195: END IF;
4196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4197: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4198: p_prefix=>l_debug_prefix,

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

4192: p_msg_data=>x_msg_data,
4193: p_msg_type=>'WARNING',
4194: p_msg_level=>fnd_log.level_exception);
4195: END IF;
4196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4197: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4198: p_prefix=>l_debug_prefix,
4199: p_msg_level=>fnd_log.level_procedure);
4200: END IF;

Line 4199: p_msg_level=>fnd_log.level_procedure);

4195: END IF;
4196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4197: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4198: p_prefix=>l_debug_prefix,
4199: p_msg_level=>fnd_log.level_procedure);
4200: END IF;
4201:
4202:
4203: -- Check if API is called in debug mode. If yes, disable debug.

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

4212: p_count => x_msg_count,
4213: p_data => x_msg_data);
4214:
4215: -- Debug info.
4216: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4217: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4218: p_msg_data=>x_msg_data,
4219: p_msg_type=>'ERROR',
4220: p_msg_level=>fnd_log.level_error);

Line 4220: p_msg_level=>fnd_log.level_error);

4216: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4217: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4218: p_msg_data=>x_msg_data,
4219: p_msg_type=>'ERROR',
4220: p_msg_level=>fnd_log.level_error);
4221: END IF;
4222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4223: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4224: p_prefix=>l_debug_prefix,

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

4218: p_msg_data=>x_msg_data,
4219: p_msg_type=>'ERROR',
4220: p_msg_level=>fnd_log.level_error);
4221: END IF;
4222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4223: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4224: p_prefix=>l_debug_prefix,
4225: p_msg_level=>fnd_log.level_procedure);
4226: END IF;

Line 4225: p_msg_level=>fnd_log.level_procedure);

4221: END IF;
4222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4223: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4224: p_prefix=>l_debug_prefix,
4225: p_msg_level=>fnd_log.level_procedure);
4226: END IF;
4227:
4228: -- Check if API is called in debug mode. If yes, disable debug.
4229: --disable_debug;

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

4236: p_count => x_msg_count,
4237: p_data => x_msg_data);
4238:
4239: -- Debug info.
4240: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4241: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4242: p_msg_data=>x_msg_data,
4243: p_msg_type=>'UNEXPECTED ERROR',
4244: p_msg_level=>fnd_log.level_error);

Line 4244: p_msg_level=>fnd_log.level_error);

4240: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4241: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4242: p_msg_data=>x_msg_data,
4243: p_msg_type=>'UNEXPECTED ERROR',
4244: p_msg_level=>fnd_log.level_error);
4245: END IF;
4246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4247: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4248: p_prefix=>l_debug_prefix,

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

4242: p_msg_data=>x_msg_data,
4243: p_msg_type=>'UNEXPECTED ERROR',
4244: p_msg_level=>fnd_log.level_error);
4245: END IF;
4246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4247: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4248: p_prefix=>l_debug_prefix,
4249: p_msg_level=>fnd_log.level_procedure);
4250: END IF;

Line 4249: p_msg_level=>fnd_log.level_procedure);

4245: END IF;
4246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4247: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4248: p_prefix=>l_debug_prefix,
4249: p_msg_level=>fnd_log.level_procedure);
4250: END IF;
4251:
4252: -- Check if API is called in debug mode. If yes, disable debug.
4253: --disable_debug;

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

4264: p_count => x_msg_count,
4265: p_data => x_msg_data);
4266:
4267: -- Debug info.
4268: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4269: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4270: p_msg_data=>x_msg_data,
4271: p_msg_type=>'SQL ERROR',
4272: p_msg_level=>fnd_log.level_error);

Line 4272: p_msg_level=>fnd_log.level_error);

4268: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4269: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4270: p_msg_data=>x_msg_data,
4271: p_msg_type=>'SQL ERROR',
4272: p_msg_level=>fnd_log.level_error);
4273: END IF;
4274: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4275: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4276: p_prefix=>l_debug_prefix,

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

4270: p_msg_data=>x_msg_data,
4271: p_msg_type=>'SQL ERROR',
4272: p_msg_level=>fnd_log.level_error);
4273: END IF;
4274: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4275: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4276: p_prefix=>l_debug_prefix,
4277: p_msg_level=>fnd_log.level_procedure);
4278: END IF;

Line 4277: p_msg_level=>fnd_log.level_procedure);

4273: END IF;
4274: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4275: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
4276: p_prefix=>l_debug_prefix,
4277: p_msg_level=>fnd_log.level_procedure);
4278: END IF;
4279:
4280: -- Check if API is called in debug mode. If yes, disable debug.
4281: --disable_debug;

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

4335: -- Check if API is called in debug mode. If yes, enable debug.
4336: --enable_debug;
4337:
4338: -- Debug info.
4339: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4340: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
4341: p_prefix=>l_debug_prefix,
4342: p_msg_level=>fnd_log.level_procedure);
4343: END IF;

Line 4342: p_msg_level=>fnd_log.level_procedure);

4338: -- Debug info.
4339: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4340: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
4341: p_prefix=>l_debug_prefix,
4342: p_msg_level=>fnd_log.level_procedure);
4343: END IF;
4344:
4345:
4346: -- Call to the main business logic.

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

4354: x_msg_data => x_msg_data
4355: );
4356:
4357: -- Debug info.
4358: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4360: p_msg_data=>x_msg_data,
4361: p_msg_type=>'WARNING',
4362: p_msg_level=>fnd_log.level_exception);

Line 4362: p_msg_level=>fnd_log.level_exception);

4358: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4360: p_msg_data=>x_msg_data,
4361: p_msg_type=>'WARNING',
4362: p_msg_level=>fnd_log.level_exception);
4363: END IF;
4364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4365: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4366: p_prefix=>l_debug_prefix,

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

4360: p_msg_data=>x_msg_data,
4361: p_msg_type=>'WARNING',
4362: p_msg_level=>fnd_log.level_exception);
4363: END IF;
4364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4365: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4366: p_prefix=>l_debug_prefix,
4367: p_msg_level=>fnd_log.level_procedure);
4368: END IF;

Line 4367: p_msg_level=>fnd_log.level_procedure);

4363: END IF;
4364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4365: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
4366: p_prefix=>l_debug_prefix,
4367: p_msg_level=>fnd_log.level_procedure);
4368: END IF;
4369:
4370: -- Check if API is called in debug mode. If yes, disable debug.
4371: --disable_debug;

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

4379: p_count => x_msg_count,
4380: p_data => x_msg_data);
4381:
4382: -- Debug info.
4383: IF fnd_log.level_error>=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=>'ERROR',
4387: p_msg_level=>fnd_log.level_error);

Line 4387: p_msg_level=>fnd_log.level_error);

4383: IF fnd_log.level_error>=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=>'ERROR',
4387: p_msg_level=>fnd_log.level_error);
4388: END IF;
4389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4390: hz_utility_v2pub.debug(p_message=>'create_email_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=>'ERROR',
4387: p_msg_level=>fnd_log.level_error);
4388: END IF;
4389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4390: hz_utility_v2pub.debug(p_message=>'create_email_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=>'create_email_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 4407: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 4411: p_msg_level=>fnd_log.level_error);

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

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

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

Line 4416: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 4439: p_msg_level=>fnd_log.level_error);

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

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

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

Line 4444: p_msg_level=>fnd_log.level_procedure);

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

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

4511: -- Check if API is called in debug mode. If yes, enable debug.
4512: --enable_debug;
4513:
4514: -- Debug info.
4515: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4516: hz_utility_v2pub.debug(p_message=>'update_contact_point (+)',
4517: p_prefix=>l_debug_prefix,
4518: p_msg_level=>fnd_log.level_procedure);
4519: END IF;

Line 4518: p_msg_level=>fnd_log.level_procedure);

4514: -- Debug info.
4515: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4516: hz_utility_v2pub.debug(p_message=>'update_contact_point (+)',
4517: p_prefix=>l_debug_prefix,
4518: p_msg_level=>fnd_log.level_procedure);
4519: END IF;
4520:
4521: -- call main business logic.
4522: update_contact_point_main(

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

4535:
4536: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4537:
4538: -- Debug info.
4539: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4540: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4541: p_msg_data=>x_msg_data,
4542: p_msg_type=>'WARNING',
4543: p_msg_level=>fnd_log.level_exception);

Line 4543: p_msg_level=>fnd_log.level_exception);

4539: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4540: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4541: p_msg_data=>x_msg_data,
4542: p_msg_type=>'WARNING',
4543: p_msg_level=>fnd_log.level_exception);
4544: END IF;
4545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4546: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4547: p_prefix=>l_debug_prefix,

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

4541: p_msg_data=>x_msg_data,
4542: p_msg_type=>'WARNING',
4543: p_msg_level=>fnd_log.level_exception);
4544: END IF;
4545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4546: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4547: p_prefix=>l_debug_prefix,
4548: p_msg_level=>fnd_log.level_procedure);
4549: END IF;

Line 4548: p_msg_level=>fnd_log.level_procedure);

4544: END IF;
4545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4546: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4547: p_prefix=>l_debug_prefix,
4548: p_msg_level=>fnd_log.level_procedure);
4549: END IF;
4550:
4551: -- Check if API is called in debug mode. If yes, disable debug.
4552: --disable_debug;

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

4561: p_count => x_msg_count,
4562: p_data => x_msg_data);
4563:
4564: -- Debug info.
4565: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4566: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4567: p_msg_data=>x_msg_data,
4568: p_msg_type=>'ERROR',
4569: p_msg_level=>fnd_log.level_error);

Line 4569: p_msg_level=>fnd_log.level_error);

4565: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4566: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4567: p_msg_data=>x_msg_data,
4568: p_msg_type=>'ERROR',
4569: p_msg_level=>fnd_log.level_error);
4570: END IF;
4571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4572: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4573: p_prefix=>l_debug_prefix,

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

4567: p_msg_data=>x_msg_data,
4568: p_msg_type=>'ERROR',
4569: p_msg_level=>fnd_log.level_error);
4570: END IF;
4571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4572: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4573: p_prefix=>l_debug_prefix,
4574: p_msg_level=>fnd_log.level_procedure);
4575: END IF;

Line 4574: p_msg_level=>fnd_log.level_procedure);

4570: END IF;
4571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4572: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4573: p_prefix=>l_debug_prefix,
4574: p_msg_level=>fnd_log.level_procedure);
4575: END IF;
4576:
4577: -- Check if API is called in debug mode. If yes, disable debug.
4578: --disable_debug;

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

4586: p_count => x_msg_count,
4587: p_data => x_msg_data);
4588:
4589: -- Debug info.
4590: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4591: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4592: p_msg_data=>x_msg_data,
4593: p_msg_type=>'UNEXPECTED ERROR',
4594: p_msg_level=>fnd_log.level_error);

Line 4594: p_msg_level=>fnd_log.level_error);

4590: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4591: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4592: p_msg_data=>x_msg_data,
4593: p_msg_type=>'UNEXPECTED ERROR',
4594: p_msg_level=>fnd_log.level_error);
4595: END IF;
4596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4597: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4598: p_prefix=>l_debug_prefix,

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

4592: p_msg_data=>x_msg_data,
4593: p_msg_type=>'UNEXPECTED ERROR',
4594: p_msg_level=>fnd_log.level_error);
4595: END IF;
4596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4597: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4598: p_prefix=>l_debug_prefix,
4599: p_msg_level=>fnd_log.level_procedure);
4600: END IF;

Line 4599: p_msg_level=>fnd_log.level_procedure);

4595: END IF;
4596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4597: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4598: p_prefix=>l_debug_prefix,
4599: p_msg_level=>fnd_log.level_procedure);
4600: END IF;
4601:
4602: -- Check if API is called in debug mode. If yes, disable debug.
4603: --disable_debug;

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

4615: p_count => x_msg_count,
4616: p_data => x_msg_data);
4617:
4618: -- Debug info.
4619: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4620: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4621: p_msg_data=>x_msg_data,
4622: p_msg_type=>'SQL ERROR',
4623: p_msg_level=>fnd_log.level_error);

Line 4623: p_msg_level=>fnd_log.level_error);

4619: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4620: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4621: p_msg_data=>x_msg_data,
4622: p_msg_type=>'SQL ERROR',
4623: p_msg_level=>fnd_log.level_error);
4624: END IF;
4625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4626: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4627: p_prefix=>l_debug_prefix,

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

4621: p_msg_data=>x_msg_data,
4622: p_msg_type=>'SQL ERROR',
4623: p_msg_level=>fnd_log.level_error);
4624: END IF;
4625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4626: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4627: p_prefix=>l_debug_prefix,
4628: p_msg_level=>fnd_log.level_procedure);
4629: END IF;

Line 4628: p_msg_level=>fnd_log.level_procedure);

4624: END IF;
4625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4626: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',
4627: p_prefix=>l_debug_prefix,
4628: p_msg_level=>fnd_log.level_procedure);
4629: END IF;
4630:
4631: -- Check if API is called in debug mode. If yes, disable debug.
4632: --disable_debug;

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

4685: -- Check if API is called in debug mode. If yes, enable debug.
4686: --enable_debug;
4687:
4688: -- Debug info.
4689: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4690: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
4691: p_prefix=>l_debug_prefix,
4692: p_msg_level=>fnd_log.level_procedure);
4693: END IF;

Line 4692: p_msg_level=>fnd_log.level_procedure);

4688: -- Debug info.
4689: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4690: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
4691: p_prefix=>l_debug_prefix,
4692: p_msg_level=>fnd_log.level_procedure);
4693: END IF;
4694:
4695: -- call main business logic.
4696: update_contact_point_main(

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

4703: x_msg_data => x_msg_data
4704: );
4705:
4706: -- Debug info.
4707: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4708: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4709: p_msg_data=>x_msg_data,
4710: p_msg_type=>'WARNING',
4711: p_msg_level=>fnd_log.level_exception);

Line 4711: p_msg_level=>fnd_log.level_exception);

4707: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4708: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4709: p_msg_data=>x_msg_data,
4710: p_msg_type=>'WARNING',
4711: p_msg_level=>fnd_log.level_exception);
4712: END IF;
4713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4714: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4715: p_prefix=>l_debug_prefix,

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

4709: p_msg_data=>x_msg_data,
4710: p_msg_type=>'WARNING',
4711: p_msg_level=>fnd_log.level_exception);
4712: END IF;
4713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4714: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4715: p_prefix=>l_debug_prefix,
4716: p_msg_level=>fnd_log.level_procedure);
4717: END IF;

Line 4716: p_msg_level=>fnd_log.level_procedure);

4712: END IF;
4713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4714: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4715: p_prefix=>l_debug_prefix,
4716: p_msg_level=>fnd_log.level_procedure);
4717: END IF;
4718:
4719: -- Check if API is called in debug mode. If yes, disable debug.
4720: --disable_debug;

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

4728: p_count => x_msg_count,
4729: p_data => x_msg_data);
4730:
4731: -- Debug info.
4732: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4734: p_msg_data=>x_msg_data,
4735: p_msg_type=>'ERROR',
4736: p_msg_level=>fnd_log.level_error);

Line 4736: p_msg_level=>fnd_log.level_error);

4732: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4734: p_msg_data=>x_msg_data,
4735: p_msg_type=>'ERROR',
4736: p_msg_level=>fnd_log.level_error);
4737: END IF;
4738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4739: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4740: p_prefix=>l_debug_prefix,

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

4734: p_msg_data=>x_msg_data,
4735: p_msg_type=>'ERROR',
4736: p_msg_level=>fnd_log.level_error);
4737: END IF;
4738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4739: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4740: p_prefix=>l_debug_prefix,
4741: p_msg_level=>fnd_log.level_procedure);
4742: END IF;

Line 4741: p_msg_level=>fnd_log.level_procedure);

4737: END IF;
4738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4739: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4740: p_prefix=>l_debug_prefix,
4741: p_msg_level=>fnd_log.level_procedure);
4742: END IF;
4743:
4744: -- Check if API is called in debug mode. If yes, disable debug.
4745: --disable_debug;

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

4752: p_count => x_msg_count,
4753: p_data => x_msg_data);
4754:
4755: -- Debug info.
4756: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4757: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4758: p_msg_data=>x_msg_data,
4759: p_msg_type=>'UNEXPECTED ERROR',
4760: p_msg_level=>fnd_log.level_error);

Line 4760: p_msg_level=>fnd_log.level_error);

4756: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4757: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4758: p_msg_data=>x_msg_data,
4759: p_msg_type=>'UNEXPECTED ERROR',
4760: p_msg_level=>fnd_log.level_error);
4761: END IF;
4762: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4763: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4764: p_prefix=>l_debug_prefix,

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

4758: p_msg_data=>x_msg_data,
4759: p_msg_type=>'UNEXPECTED ERROR',
4760: p_msg_level=>fnd_log.level_error);
4761: END IF;
4762: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4763: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4764: p_prefix=>l_debug_prefix,
4765: p_msg_level=>fnd_log.level_procedure);
4766: END IF;

Line 4765: p_msg_level=>fnd_log.level_procedure);

4761: END IF;
4762: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4763: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4764: p_prefix=>l_debug_prefix,
4765: p_msg_level=>fnd_log.level_procedure);
4766: END IF;
4767:
4768: -- Check if API is called in debug mode. If yes, disable debug.
4769: --disable_debug;

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

4780: p_count => x_msg_count,
4781: p_data => x_msg_data);
4782:
4783: -- Debug info.
4784: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4785: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4786: p_msg_data=>x_msg_data,
4787: p_msg_type=>'SQL ERROR',
4788: p_msg_level=>fnd_log.level_error);

Line 4788: p_msg_level=>fnd_log.level_error);

4784: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4785: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4786: p_msg_data=>x_msg_data,
4787: p_msg_type=>'SQL ERROR',
4788: p_msg_level=>fnd_log.level_error);
4789: END IF;
4790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4791: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4792: p_prefix=>l_debug_prefix,

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

4786: p_msg_data=>x_msg_data,
4787: p_msg_type=>'SQL ERROR',
4788: p_msg_level=>fnd_log.level_error);
4789: END IF;
4790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4791: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4792: p_prefix=>l_debug_prefix,
4793: p_msg_level=>fnd_log.level_procedure);
4794: END IF;

Line 4793: p_msg_level=>fnd_log.level_procedure);

4789: END IF;
4790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4791: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
4792: p_prefix=>l_debug_prefix,
4793: p_msg_level=>fnd_log.level_procedure);
4794: END IF;
4795:
4796: -- Check if API is called in debug mode. If yes, disable debug.
4797: --disable_debug;

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

4850: -- Check if API is called in debug mode. If yes, enable debug.
4851: --enable_debug;
4852:
4853: -- Debug info.
4854: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4855: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
4856: p_prefix=>l_debug_prefix,
4857: p_msg_level=>fnd_log.level_procedure);
4858: END IF;

Line 4857: p_msg_level=>fnd_log.level_procedure);

4853: -- Debug info.
4854: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4855: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
4856: p_prefix=>l_debug_prefix,
4857: p_msg_level=>fnd_log.level_procedure);
4858: END IF;
4859:
4860: -- call main business logic.
4861: update_contact_point_main(

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

4869: );
4870:
4871: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4872: -- Debug info.
4873: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4874: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4875: p_msg_data=>x_msg_data,
4876: p_msg_type=>'WARNING',
4877: p_msg_level=>fnd_log.level_exception);

Line 4877: p_msg_level=>fnd_log.level_exception);

4873: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4874: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4875: p_msg_data=>x_msg_data,
4876: p_msg_type=>'WARNING',
4877: p_msg_level=>fnd_log.level_exception);
4878: END IF;
4879: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4880: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4881: p_prefix=>l_debug_prefix,

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

4875: p_msg_data=>x_msg_data,
4876: p_msg_type=>'WARNING',
4877: p_msg_level=>fnd_log.level_exception);
4878: END IF;
4879: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4880: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4881: p_prefix=>l_debug_prefix,
4882: p_msg_level=>fnd_log.level_procedure);
4883: END IF;

Line 4882: p_msg_level=>fnd_log.level_procedure);

4878: END IF;
4879: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4880: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4881: p_prefix=>l_debug_prefix,
4882: p_msg_level=>fnd_log.level_procedure);
4883: END IF;
4884:
4885: -- Check if API is called in debug mode. If yes, disable debug.
4886: --disable_debug;

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

4895: p_count => x_msg_count,
4896: p_data => x_msg_data);
4897:
4898: -- Debug info.
4899: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4900: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4901: p_msg_data=>x_msg_data,
4902: p_msg_type=>'ERROR',
4903: p_msg_level=>fnd_log.level_error);

Line 4903: p_msg_level=>fnd_log.level_error);

4899: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4900: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4901: p_msg_data=>x_msg_data,
4902: p_msg_type=>'ERROR',
4903: p_msg_level=>fnd_log.level_error);
4904: END IF;
4905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4906: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4907: p_prefix=>l_debug_prefix,

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

4901: p_msg_data=>x_msg_data,
4902: p_msg_type=>'ERROR',
4903: p_msg_level=>fnd_log.level_error);
4904: END IF;
4905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4906: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4907: p_prefix=>l_debug_prefix,
4908: p_msg_level=>fnd_log.level_procedure);
4909: END IF;

Line 4908: p_msg_level=>fnd_log.level_procedure);

4904: END IF;
4905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4906: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4907: p_prefix=>l_debug_prefix,
4908: p_msg_level=>fnd_log.level_procedure);
4909: END IF;
4910:
4911: -- Check if API is called in debug mode. If yes, disable debug.
4912: --disable_debug;

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

4920: p_count => x_msg_count,
4921: p_data => x_msg_data);
4922:
4923: -- Debug info.
4924: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4925: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4926: p_msg_data=>x_msg_data,
4927: p_msg_type=>'UNEXPECTED ERROR',
4928: p_msg_level=>fnd_log.level_error);

Line 4928: p_msg_level=>fnd_log.level_error);

4924: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4925: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4926: p_msg_data=>x_msg_data,
4927: p_msg_type=>'UNEXPECTED ERROR',
4928: p_msg_level=>fnd_log.level_error);
4929: END IF;
4930: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4931: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4932: p_prefix=>l_debug_prefix,

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

4926: p_msg_data=>x_msg_data,
4927: p_msg_type=>'UNEXPECTED ERROR',
4928: p_msg_level=>fnd_log.level_error);
4929: END IF;
4930: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4931: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4932: p_prefix=>l_debug_prefix,
4933: p_msg_level=>fnd_log.level_procedure);
4934: END IF;

Line 4933: p_msg_level=>fnd_log.level_procedure);

4929: END IF;
4930: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4931: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4932: p_prefix=>l_debug_prefix,
4933: p_msg_level=>fnd_log.level_procedure);
4934: END IF;
4935:
4936:
4937: -- Check if API is called in debug mode. If yes, disable debug.

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

4950: p_count => x_msg_count,
4951: p_data => x_msg_data);
4952:
4953: -- Debug info.
4954: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4955: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4956: p_msg_data=>x_msg_data,
4957: p_msg_type=>'SQL ERROR',
4958: p_msg_level=>fnd_log.level_error);

Line 4958: p_msg_level=>fnd_log.level_error);

4954: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4955: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4956: p_msg_data=>x_msg_data,
4957: p_msg_type=>'SQL ERROR',
4958: p_msg_level=>fnd_log.level_error);
4959: END IF;
4960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4961: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4962: p_prefix=>l_debug_prefix,

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

4956: p_msg_data=>x_msg_data,
4957: p_msg_type=>'SQL ERROR',
4958: p_msg_level=>fnd_log.level_error);
4959: END IF;
4960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4961: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4962: p_prefix=>l_debug_prefix,
4963: p_msg_level=>fnd_log.level_procedure);
4964: END IF;

Line 4963: p_msg_level=>fnd_log.level_procedure);

4959: END IF;
4960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4961: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
4962: p_prefix=>l_debug_prefix,
4963: p_msg_level=>fnd_log.level_procedure);
4964: END IF;
4965:
4966: -- Check if API is called in debug mode. If yes, disable debug.
4967: --disable_debug;

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

5022: -- Check if API is called in debug mode. If yes, enable debug.
5023: --enable_debug;
5024:
5025: -- Debug info.
5026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5027: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
5028: p_prefix=>l_debug_prefix,
5029: p_msg_level=>fnd_log.level_procedure);
5030: END IF;

Line 5029: p_msg_level=>fnd_log.level_procedure);

5025: -- Debug info.
5026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5027: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
5028: p_prefix=>l_debug_prefix,
5029: p_msg_level=>fnd_log.level_procedure);
5030: END IF;
5031:
5032:
5033: -- call main business logic.

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

5041: x_msg_data => x_msg_data
5042: );
5043:
5044: -- Debug info.
5045: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5046: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5047: p_msg_data=>x_msg_data,
5048: p_msg_type=>'WARNING',
5049: p_msg_level=>fnd_log.level_exception);

Line 5049: p_msg_level=>fnd_log.level_exception);

5045: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5046: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5047: p_msg_data=>x_msg_data,
5048: p_msg_type=>'WARNING',
5049: p_msg_level=>fnd_log.level_exception);
5050: END IF;
5051: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5052: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5053: p_prefix=>l_debug_prefix,

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

5047: p_msg_data=>x_msg_data,
5048: p_msg_type=>'WARNING',
5049: p_msg_level=>fnd_log.level_exception);
5050: END IF;
5051: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5052: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5053: p_prefix=>l_debug_prefix,
5054: p_msg_level=>fnd_log.level_procedure);
5055: END IF;

Line 5054: p_msg_level=>fnd_log.level_procedure);

5050: END IF;
5051: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5052: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5053: p_prefix=>l_debug_prefix,
5054: p_msg_level=>fnd_log.level_procedure);
5055: END IF;
5056:
5057: -- Check if API is called in debug mode. If yes, disable debug.
5058: --disable_debug;

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

5066: p_count => x_msg_count,
5067: p_data => x_msg_data);
5068:
5069: -- Debug info.
5070: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5071: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5072: p_msg_data=>x_msg_data,
5073: p_msg_type=>'ERROR',
5074: p_msg_level=>fnd_log.level_error);

Line 5074: p_msg_level=>fnd_log.level_error);

5070: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5071: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5072: p_msg_data=>x_msg_data,
5073: p_msg_type=>'ERROR',
5074: p_msg_level=>fnd_log.level_error);
5075: END IF;
5076: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5077: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5078: p_prefix=>l_debug_prefix,

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

5072: p_msg_data=>x_msg_data,
5073: p_msg_type=>'ERROR',
5074: p_msg_level=>fnd_log.level_error);
5075: END IF;
5076: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5077: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5078: p_prefix=>l_debug_prefix,
5079: p_msg_level=>fnd_log.level_procedure);
5080: END IF;

Line 5079: p_msg_level=>fnd_log.level_procedure);

5075: END IF;
5076: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5077: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5078: p_prefix=>l_debug_prefix,
5079: p_msg_level=>fnd_log.level_procedure);
5080: END IF;
5081:
5082: -- Check if API is called in debug mode. If yes, disable debug.
5083: --disable_debug;

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

5090: p_count => x_msg_count,
5091: p_data => x_msg_data);
5092:
5093: -- Debug info.
5094: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5095: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5096: p_msg_data=>x_msg_data,
5097: p_msg_type=>'UNEXPECTED ERROR',
5098: p_msg_level=>fnd_log.level_error);

Line 5098: p_msg_level=>fnd_log.level_error);

5094: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5095: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5096: p_msg_data=>x_msg_data,
5097: p_msg_type=>'UNEXPECTED ERROR',
5098: p_msg_level=>fnd_log.level_error);
5099: END IF;
5100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5101: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5102: p_prefix=>l_debug_prefix,

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

5096: p_msg_data=>x_msg_data,
5097: p_msg_type=>'UNEXPECTED ERROR',
5098: p_msg_level=>fnd_log.level_error);
5099: END IF;
5100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5101: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5102: p_prefix=>l_debug_prefix,
5103: p_msg_level=>fnd_log.level_procedure);
5104: END IF;

Line 5103: p_msg_level=>fnd_log.level_procedure);

5099: END IF;
5100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5101: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5102: p_prefix=>l_debug_prefix,
5103: p_msg_level=>fnd_log.level_procedure);
5104: END IF;
5105:
5106: -- Check if API is called in debug mode. If yes, disable debug.
5107: --disable_debug;

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

5118: p_count => x_msg_count,
5119: p_data => x_msg_data);
5120:
5121: -- Debug info.
5122: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5123: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5124: p_msg_data=>x_msg_data,
5125: p_msg_type=>'SQL ERROR',
5126: p_msg_level=>fnd_log.level_error);

Line 5126: p_msg_level=>fnd_log.level_error);

5122: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5123: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5124: p_msg_data=>x_msg_data,
5125: p_msg_type=>'SQL ERROR',
5126: p_msg_level=>fnd_log.level_error);
5127: END IF;
5128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5129: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5130: p_prefix=>l_debug_prefix,

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

5124: p_msg_data=>x_msg_data,
5125: p_msg_type=>'SQL ERROR',
5126: p_msg_level=>fnd_log.level_error);
5127: END IF;
5128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5129: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5130: p_prefix=>l_debug_prefix,
5131: p_msg_level=>fnd_log.level_procedure);
5132: END IF;

Line 5131: p_msg_level=>fnd_log.level_procedure);

5127: END IF;
5128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5129: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5130: p_prefix=>l_debug_prefix,
5131: p_msg_level=>fnd_log.level_procedure);
5132: END IF;
5133:
5134:
5135: -- Check if API is called in debug mode. If yes, disable debug.

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

5189: -- Check if API is called in debug mode. If yes, enable debug.
5190: --enable_debug;
5191:
5192: -- Debug info.
5193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5194: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
5195: p_prefix=>l_debug_prefix,
5196: p_msg_level=>fnd_log.level_procedure);
5197: END IF;

Line 5196: p_msg_level=>fnd_log.level_procedure);

5192: -- Debug info.
5193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5194: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
5195: p_prefix=>l_debug_prefix,
5196: p_msg_level=>fnd_log.level_procedure);
5197: END IF;
5198:
5199: -- call main business logic.
5200: update_contact_point_main(

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

5208: );
5209:
5210: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5211: -- Debug info.
5212: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5213: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5214: p_msg_data=>x_msg_data,
5215: p_msg_type=>'WARNING',
5216: p_msg_level=>fnd_log.level_exception);

Line 5216: p_msg_level=>fnd_log.level_exception);

5212: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5213: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5214: p_msg_data=>x_msg_data,
5215: p_msg_type=>'WARNING',
5216: p_msg_level=>fnd_log.level_exception);
5217: END IF;
5218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5219: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5220: p_prefix=>l_debug_prefix,

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

5214: p_msg_data=>x_msg_data,
5215: p_msg_type=>'WARNING',
5216: p_msg_level=>fnd_log.level_exception);
5217: END IF;
5218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5219: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5220: p_prefix=>l_debug_prefix,
5221: p_msg_level=>fnd_log.level_procedure);
5222: END IF;

Line 5221: p_msg_level=>fnd_log.level_procedure);

5217: END IF;
5218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5219: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5220: p_prefix=>l_debug_prefix,
5221: p_msg_level=>fnd_log.level_procedure);
5222: END IF;
5223:
5224: -- Check if API is called in debug mode. If yes, disable debug.
5225: --disable_debug;

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

5234: p_count => x_msg_count,
5235: p_data => x_msg_data);
5236:
5237: -- Debug info.
5238: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5239: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5240: p_msg_data=>x_msg_data,
5241: p_msg_type=>'ERROR',
5242: p_msg_level=>fnd_log.level_error);

Line 5242: p_msg_level=>fnd_log.level_error);

5238: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5239: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5240: p_msg_data=>x_msg_data,
5241: p_msg_type=>'ERROR',
5242: p_msg_level=>fnd_log.level_error);
5243: END IF;
5244: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5245: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5246: p_prefix=>l_debug_prefix,

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

5240: p_msg_data=>x_msg_data,
5241: p_msg_type=>'ERROR',
5242: p_msg_level=>fnd_log.level_error);
5243: END IF;
5244: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5245: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5246: p_prefix=>l_debug_prefix,
5247: p_msg_level=>fnd_log.level_procedure);
5248: END IF;

Line 5247: p_msg_level=>fnd_log.level_procedure);

5243: END IF;
5244: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5245: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5246: p_prefix=>l_debug_prefix,
5247: p_msg_level=>fnd_log.level_procedure);
5248: END IF;
5249:
5250: -- Check if API is called in debug mode. If yes, disable debug.
5251: --disable_debug;

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

5259: p_count => x_msg_count,
5260: p_data => x_msg_data);
5261:
5262: -- Debug info.
5263: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5264: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5265: p_msg_data=>x_msg_data,
5266: p_msg_type=>'UNEXPECTED ERROR',
5267: p_msg_level=>fnd_log.level_error);

Line 5267: p_msg_level=>fnd_log.level_error);

5263: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5264: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5265: p_msg_data=>x_msg_data,
5266: p_msg_type=>'UNEXPECTED ERROR',
5267: p_msg_level=>fnd_log.level_error);
5268: END IF;
5269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5270: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5271: p_prefix=>l_debug_prefix,

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

5265: p_msg_data=>x_msg_data,
5266: p_msg_type=>'UNEXPECTED ERROR',
5267: p_msg_level=>fnd_log.level_error);
5268: END IF;
5269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5270: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5271: p_prefix=>l_debug_prefix,
5272: p_msg_level=>fnd_log.level_procedure);
5273: END IF;

Line 5272: p_msg_level=>fnd_log.level_procedure);

5268: END IF;
5269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5270: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5271: p_prefix=>l_debug_prefix,
5272: p_msg_level=>fnd_log.level_procedure);
5273: END IF;
5274:
5275: -- Check if API is called in debug mode. If yes, disable debug.
5276: --disable_debug;

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

5288: p_count => x_msg_count,
5289: p_data => x_msg_data);
5290:
5291: -- Debug info.
5292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5293: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5294: p_msg_data=>x_msg_data,
5295: p_msg_type=>'SQL ERROR',
5296: p_msg_level=>fnd_log.level_error);

Line 5296: p_msg_level=>fnd_log.level_error);

5292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5293: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5294: p_msg_data=>x_msg_data,
5295: p_msg_type=>'SQL ERROR',
5296: p_msg_level=>fnd_log.level_error);
5297: END IF;
5298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5299: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5300: p_prefix=>l_debug_prefix,

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

5294: p_msg_data=>x_msg_data,
5295: p_msg_type=>'SQL ERROR',
5296: p_msg_level=>fnd_log.level_error);
5297: END IF;
5298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5299: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5300: p_prefix=>l_debug_prefix,
5301: p_msg_level=>fnd_log.level_procedure);
5302: END IF;

Line 5301: p_msg_level=>fnd_log.level_procedure);

5297: END IF;
5298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5299: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
5300: p_prefix=>l_debug_prefix,
5301: p_msg_level=>fnd_log.level_procedure);
5302: END IF;
5303:
5304: -- Check if API is called in debug mode. If yes, disable debug.
5305: --disable_debug;

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

5358: -- Check if API is called in debug mode. If yes, enable debug.
5359: --enable_debug;
5360:
5361: -- Debug info.
5362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5363: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
5364: p_prefix=>l_debug_prefix,
5365: p_msg_level=>fnd_log.level_procedure);
5366: END IF;

Line 5365: p_msg_level=>fnd_log.level_procedure);

5361: -- Debug info.
5362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5363: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
5364: p_prefix=>l_debug_prefix,
5365: p_msg_level=>fnd_log.level_procedure);
5366: END IF;
5367:
5368: -- call main business logic.
5369: update_contact_point_main(

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

5377: );
5378:
5379: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5380: -- Debug info.
5381: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5383: p_msg_data=>x_msg_data,
5384: p_msg_type=>'WARNING',
5385: p_msg_level=>fnd_log.level_exception);

Line 5385: p_msg_level=>fnd_log.level_exception);

5381: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5383: p_msg_data=>x_msg_data,
5384: p_msg_type=>'WARNING',
5385: p_msg_level=>fnd_log.level_exception);
5386: END IF;
5387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5388: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5389: p_prefix=>l_debug_prefix,

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

5383: p_msg_data=>x_msg_data,
5384: p_msg_type=>'WARNING',
5385: p_msg_level=>fnd_log.level_exception);
5386: END IF;
5387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5388: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5389: p_prefix=>l_debug_prefix,
5390: p_msg_level=>fnd_log.level_procedure);
5391: END IF;

Line 5390: p_msg_level=>fnd_log.level_procedure);

5386: END IF;
5387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5388: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5389: p_prefix=>l_debug_prefix,
5390: p_msg_level=>fnd_log.level_procedure);
5391: END IF;
5392:
5393:
5394: -- Check if API is called in debug mode. If yes, disable debug.

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

5404: p_count => x_msg_count,
5405: p_data => x_msg_data);
5406:
5407: -- Debug info.
5408: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5409: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5410: p_msg_data=>x_msg_data,
5411: p_msg_type=>'ERROR',
5412: p_msg_level=>fnd_log.level_error);

Line 5412: p_msg_level=>fnd_log.level_error);

5408: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5409: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5410: p_msg_data=>x_msg_data,
5411: p_msg_type=>'ERROR',
5412: p_msg_level=>fnd_log.level_error);
5413: END IF;
5414: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5415: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5416: p_prefix=>l_debug_prefix,

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

5410: p_msg_data=>x_msg_data,
5411: p_msg_type=>'ERROR',
5412: p_msg_level=>fnd_log.level_error);
5413: END IF;
5414: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5415: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5416: p_prefix=>l_debug_prefix,
5417: p_msg_level=>fnd_log.level_procedure);
5418: END IF;

Line 5417: p_msg_level=>fnd_log.level_procedure);

5413: END IF;
5414: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5415: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5416: p_prefix=>l_debug_prefix,
5417: p_msg_level=>fnd_log.level_procedure);
5418: END IF;
5419:
5420:
5421:

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

5431: p_count => x_msg_count,
5432: p_data => x_msg_data);
5433:
5434: -- Debug info.
5435: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5437: p_msg_data=>x_msg_data,
5438: p_msg_type=>'UNEXPECTED ERROR',
5439: p_msg_level=>fnd_log.level_error);

Line 5439: p_msg_level=>fnd_log.level_error);

5435: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5437: p_msg_data=>x_msg_data,
5438: p_msg_type=>'UNEXPECTED ERROR',
5439: p_msg_level=>fnd_log.level_error);
5440: END IF;
5441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5442: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5443: p_prefix=>l_debug_prefix,

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

5437: p_msg_data=>x_msg_data,
5438: p_msg_type=>'UNEXPECTED ERROR',
5439: p_msg_level=>fnd_log.level_error);
5440: END IF;
5441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5442: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5443: p_prefix=>l_debug_prefix,
5444: p_msg_level=>fnd_log.level_procedure);
5445: END IF;

Line 5444: p_msg_level=>fnd_log.level_procedure);

5440: END IF;
5441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5442: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5443: p_prefix=>l_debug_prefix,
5444: p_msg_level=>fnd_log.level_procedure);
5445: END IF;
5446:
5447: -- Check if API is called in debug mode. If yes, disable debug.
5448: --disable_debug;

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

5460: p_count => x_msg_count,
5461: p_data => x_msg_data);
5462:
5463: -- Debug info.
5464: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5466: p_msg_data=>x_msg_data,
5467: p_msg_type=>'SQL ERROR',
5468: p_msg_level=>fnd_log.level_error);

Line 5468: p_msg_level=>fnd_log.level_error);

5464: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5466: p_msg_data=>x_msg_data,
5467: p_msg_type=>'SQL ERROR',
5468: p_msg_level=>fnd_log.level_error);
5469: END IF;
5470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5471: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5472: p_prefix=>l_debug_prefix,

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

5466: p_msg_data=>x_msg_data,
5467: p_msg_type=>'SQL ERROR',
5468: p_msg_level=>fnd_log.level_error);
5469: END IF;
5470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5471: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5472: p_prefix=>l_debug_prefix,
5473: p_msg_level=>fnd_log.level_procedure);
5474: END IF;

Line 5473: p_msg_level=>fnd_log.level_procedure);

5469: END IF;
5470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5471: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
5472: p_prefix=>l_debug_prefix,
5473: p_msg_level=>fnd_log.level_procedure);
5474: END IF;
5475:
5476: -- Check if API is called in debug mode. If yes, disable debug.
5477: --disable_debug;

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

5530: -- Check if API is called in debug mode. If yes, enable debug.
5531: --enable_debug;
5532:
5533: -- Debug info.
5534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5535: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
5536: p_prefix=>l_debug_prefix,
5537: p_msg_level=>fnd_log.level_procedure);
5538: END IF;

Line 5537: p_msg_level=>fnd_log.level_procedure);

5533: -- Debug info.
5534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5535: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
5536: p_prefix=>l_debug_prefix,
5537: p_msg_level=>fnd_log.level_procedure);
5538: END IF;
5539:
5540: -- call main business logic.
5541: update_contact_point_main(

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

5549: );
5550:
5551: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5552: -- Debug info.
5553: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5554: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5555: p_msg_data=>x_msg_data,
5556: p_msg_type=>'WARNING',
5557: p_msg_level=>fnd_log.level_exception);

Line 5557: p_msg_level=>fnd_log.level_exception);

5553: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5554: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5555: p_msg_data=>x_msg_data,
5556: p_msg_type=>'WARNING',
5557: p_msg_level=>fnd_log.level_exception);
5558: END IF;
5559: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5560: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5561: p_prefix=>l_debug_prefix,

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

5555: p_msg_data=>x_msg_data,
5556: p_msg_type=>'WARNING',
5557: p_msg_level=>fnd_log.level_exception);
5558: END IF;
5559: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5560: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5561: p_prefix=>l_debug_prefix,
5562: p_msg_level=>fnd_log.level_procedure);
5563: END IF;

Line 5562: p_msg_level=>fnd_log.level_procedure);

5558: END IF;
5559: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5560: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5561: p_prefix=>l_debug_prefix,
5562: p_msg_level=>fnd_log.level_procedure);
5563: END IF;
5564:
5565: -- Check if API is called in debug mode. If yes, disable debug.
5566: --disable_debug;

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

5575: p_count => x_msg_count,
5576: p_data => x_msg_data);
5577:
5578: -- Debug info.
5579: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5580: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5581: p_msg_data=>x_msg_data,
5582: p_msg_type=>'ERROR',
5583: p_msg_level=>fnd_log.level_error);

Line 5583: p_msg_level=>fnd_log.level_error);

5579: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5580: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5581: p_msg_data=>x_msg_data,
5582: p_msg_type=>'ERROR',
5583: p_msg_level=>fnd_log.level_error);
5584: END IF;
5585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5586: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5587: p_prefix=>l_debug_prefix,

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

5581: p_msg_data=>x_msg_data,
5582: p_msg_type=>'ERROR',
5583: p_msg_level=>fnd_log.level_error);
5584: END IF;
5585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5586: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5587: p_prefix=>l_debug_prefix,
5588: p_msg_level=>fnd_log.level_procedure);
5589: END IF;

Line 5588: p_msg_level=>fnd_log.level_procedure);

5584: END IF;
5585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5586: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5587: p_prefix=>l_debug_prefix,
5588: p_msg_level=>fnd_log.level_procedure);
5589: END IF;
5590:
5591: -- Check if API is called in debug mode. If yes, disable debug.
5592: --disable_debug;

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

5600: p_count => x_msg_count,
5601: p_data => x_msg_data);
5602:
5603: -- Debug info.
5604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5606: p_msg_data=>x_msg_data,
5607: p_msg_type=>'UNEXPECTED ERROR',
5608: p_msg_level=>fnd_log.level_error);

Line 5608: p_msg_level=>fnd_log.level_error);

5604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5606: p_msg_data=>x_msg_data,
5607: p_msg_type=>'UNEXPECTED ERROR',
5608: p_msg_level=>fnd_log.level_error);
5609: END IF;
5610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5611: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5612: p_prefix=>l_debug_prefix,

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

5606: p_msg_data=>x_msg_data,
5607: p_msg_type=>'UNEXPECTED ERROR',
5608: p_msg_level=>fnd_log.level_error);
5609: END IF;
5610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5611: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5612: p_prefix=>l_debug_prefix,
5613: p_msg_level=>fnd_log.level_procedure);
5614: END IF;

Line 5613: p_msg_level=>fnd_log.level_procedure);

5609: END IF;
5610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5611: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5612: p_prefix=>l_debug_prefix,
5613: p_msg_level=>fnd_log.level_procedure);
5614: END IF;
5615:
5616: -- Check if API is called in debug mode. If yes, disable debug.
5617: --disable_debug;

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

5629: p_count => x_msg_count,
5630: p_data => x_msg_data);
5631:
5632: -- Debug info.
5633: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5634: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5635: p_msg_data=>x_msg_data,
5636: p_msg_type=>'SQL ERROR',
5637: p_msg_level=>fnd_log.level_error);

Line 5637: p_msg_level=>fnd_log.level_error);

5633: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5634: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5635: p_msg_data=>x_msg_data,
5636: p_msg_type=>'SQL ERROR',
5637: p_msg_level=>fnd_log.level_error);
5638: END IF;
5639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5640: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5641: p_prefix=>l_debug_prefix,

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

5635: p_msg_data=>x_msg_data,
5636: p_msg_type=>'SQL ERROR',
5637: p_msg_level=>fnd_log.level_error);
5638: END IF;
5639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5640: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5641: p_prefix=>l_debug_prefix,
5642: p_msg_level=>fnd_log.level_procedure);
5643: END IF;

Line 5642: p_msg_level=>fnd_log.level_procedure);

5638: END IF;
5639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5640: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
5641: p_prefix=>l_debug_prefix,
5642: p_msg_level=>fnd_log.level_procedure);
5643: END IF;
5644:
5645: -- Check if API is called in debug mode. If yes, disable debug.
5646: --disable_debug;

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

5721: -- Check if API is called in debug mode. If yes, enable debug.
5722: --enable_debug;
5723:
5724: -- Debug info.
5725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5726: hz_utility_v2pub.debug(p_message=>'phone_format (+)',
5727: p_prefix=>l_debug_prefix,
5728: p_msg_level=>fnd_log.level_procedure);
5729: END IF;

Line 5728: p_msg_level=>fnd_log.level_procedure);

5724: -- Debug info.
5725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5726: hz_utility_v2pub.debug(p_message=>'phone_format (+)',
5727: p_prefix=>l_debug_prefix,
5728: p_msg_level=>fnd_log.level_procedure);
5729: END IF;
5730:
5731: -- Initialize message list if p_init_msg_list is set to TRUE.
5732: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

5881: p_count => x_msg_count,
5882: p_data => x_msg_data);
5883:
5884: -- Debug info.
5885: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5886: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5887: p_msg_data=>x_msg_data,
5888: p_msg_type=>'WARNING',
5889: p_msg_level=>fnd_log.level_exception);

Line 5889: p_msg_level=>fnd_log.level_exception);

5885: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5886: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5887: p_msg_data=>x_msg_data,
5888: p_msg_type=>'WARNING',
5889: p_msg_level=>fnd_log.level_exception);
5890: END IF;
5891: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5892: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5893: p_prefix=>l_debug_prefix,

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

5887: p_msg_data=>x_msg_data,
5888: p_msg_type=>'WARNING',
5889: p_msg_level=>fnd_log.level_exception);
5890: END IF;
5891: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5892: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5893: p_prefix=>l_debug_prefix,
5894: p_msg_level=>fnd_log.level_procedure);
5895: END IF;

Line 5894: p_msg_level=>fnd_log.level_procedure);

5890: END IF;
5891: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5892: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5893: p_prefix=>l_debug_prefix,
5894: p_msg_level=>fnd_log.level_procedure);
5895: END IF;
5896:
5897: -- Check if API is called in debug mode. If yes, disable debug.
5898: --disable_debug;

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

5905: p_count => x_msg_count,
5906: p_data => x_msg_data);
5907:
5908: -- Debug info.
5909: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5910: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5911: p_msg_data=>x_msg_data,
5912: p_msg_type=>'ERROR',
5913: p_msg_level=>fnd_log.level_error);

Line 5913: p_msg_level=>fnd_log.level_error);

5909: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5910: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5911: p_msg_data=>x_msg_data,
5912: p_msg_type=>'ERROR',
5913: p_msg_level=>fnd_log.level_error);
5914: END IF;
5915: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5916: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5917: p_prefix=>l_debug_prefix,

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

5911: p_msg_data=>x_msg_data,
5912: p_msg_type=>'ERROR',
5913: p_msg_level=>fnd_log.level_error);
5914: END IF;
5915: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5916: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5917: p_prefix=>l_debug_prefix,
5918: p_msg_level=>fnd_log.level_procedure);
5919: END IF;

Line 5918: p_msg_level=>fnd_log.level_procedure);

5914: END IF;
5915: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5916: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5917: p_prefix=>l_debug_prefix,
5918: p_msg_level=>fnd_log.level_procedure);
5919: END IF;
5920:
5921: -- Check if API is called in debug mode. If yes, disable debug.
5922: --disable_debug;

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

5928: p_count => x_msg_count,
5929: p_data => x_msg_data);
5930:
5931: -- Debug info.
5932: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5933: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5934: p_msg_data=>x_msg_data,
5935: p_msg_type=>'UNEXPECTED ERROR',
5936: p_msg_level=>fnd_log.level_error);

Line 5936: p_msg_level=>fnd_log.level_error);

5932: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5933: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5934: p_msg_data=>x_msg_data,
5935: p_msg_type=>'UNEXPECTED ERROR',
5936: p_msg_level=>fnd_log.level_error);
5937: END IF;
5938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5939: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5940: p_prefix=>l_debug_prefix,

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

5934: p_msg_data=>x_msg_data,
5935: p_msg_type=>'UNEXPECTED ERROR',
5936: p_msg_level=>fnd_log.level_error);
5937: END IF;
5938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5939: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5940: p_prefix=>l_debug_prefix,
5941: p_msg_level=>fnd_log.level_procedure);
5942: END IF;

Line 5941: p_msg_level=>fnd_log.level_procedure);

5937: END IF;
5938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5939: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5940: p_prefix=>l_debug_prefix,
5941: p_msg_level=>fnd_log.level_procedure);
5942: END IF;
5943:
5944: -- Check if API is called in debug mode. If yes, disable debug.
5945: --disable_debug;

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

5955: p_count => x_msg_count,
5956: p_data => x_msg_data);
5957:
5958: -- Debug info.
5959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5960: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5961: p_msg_data=>x_msg_data,
5962: p_msg_type=>'SQL ERROR',
5963: p_msg_level=>fnd_log.level_error);

Line 5963: p_msg_level=>fnd_log.level_error);

5959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5960: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5961: p_msg_data=>x_msg_data,
5962: p_msg_type=>'SQL ERROR',
5963: p_msg_level=>fnd_log.level_error);
5964: END IF;
5965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5966: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5967: p_prefix=>l_debug_prefix,

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

5961: p_msg_data=>x_msg_data,
5962: p_msg_type=>'SQL ERROR',
5963: p_msg_level=>fnd_log.level_error);
5964: END IF;
5965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5966: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5967: p_prefix=>l_debug_prefix,
5968: p_msg_level=>fnd_log.level_procedure);
5969: END IF;

Line 5968: p_msg_level=>fnd_log.level_procedure);

5964: END IF;
5965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5966: hz_utility_v2pub.debug(p_message=>'phone_format (-)',
5967: p_prefix=>l_debug_prefix,
5968: p_msg_level=>fnd_log.level_procedure);
5969: END IF;
5970:
5971: -- Check if API is called in debug mode. If yes, disable debug.
5972: --disable_debug;

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

6030: -- Check if API is called in debug mode. If yes, enable debug.
6031: --enable_debug;
6032:
6033: -- Debug info.
6034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6035: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (+)',
6036: p_prefix=>l_debug_prefix,
6037: p_msg_level=>fnd_log.level_procedure);
6038: END IF;

Line 6037: p_msg_level=>fnd_log.level_procedure);

6033: -- Debug info.
6034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6035: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (+)',
6036: p_prefix=>l_debug_prefix,
6037: p_msg_level=>fnd_log.level_procedure);
6038: END IF;
6039:
6040: -- Execute main procedure
6041: get_contact_point_main (

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

6053: x_msg_data => x_msg_data
6054: );
6055:
6056: -- Debug info.
6057: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6058: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6059: p_msg_data=>x_msg_data,
6060: p_msg_type=>'WARNING',
6061: p_msg_level=>fnd_log.level_exception);

Line 6061: p_msg_level=>fnd_log.level_exception);

6057: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6058: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6059: p_msg_data=>x_msg_data,
6060: p_msg_type=>'WARNING',
6061: p_msg_level=>fnd_log.level_exception);
6062: END IF;
6063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6064: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6065: p_prefix=>l_debug_prefix,

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

6059: p_msg_data=>x_msg_data,
6060: p_msg_type=>'WARNING',
6061: p_msg_level=>fnd_log.level_exception);
6062: END IF;
6063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6064: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6065: p_prefix=>l_debug_prefix,
6066: p_msg_level=>fnd_log.level_procedure);
6067: END IF;

Line 6066: p_msg_level=>fnd_log.level_procedure);

6062: END IF;
6063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6064: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6065: p_prefix=>l_debug_prefix,
6066: p_msg_level=>fnd_log.level_procedure);
6067: END IF;
6068:
6069: -- Check if API is called in debug mode. If yes, disable debug.
6070: --disable_debug;

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

6077: p_count => x_msg_count,
6078: p_data => x_msg_data);
6079:
6080: -- Debug info.
6081: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6082: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6083: p_msg_data=>x_msg_data,
6084: p_msg_type=>'ERROR',
6085: p_msg_level=>fnd_log.level_error);

Line 6085: p_msg_level=>fnd_log.level_error);

6081: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6082: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6083: p_msg_data=>x_msg_data,
6084: p_msg_type=>'ERROR',
6085: p_msg_level=>fnd_log.level_error);
6086: END IF;
6087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6088: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6089: p_prefix=>l_debug_prefix,

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

6083: p_msg_data=>x_msg_data,
6084: p_msg_type=>'ERROR',
6085: p_msg_level=>fnd_log.level_error);
6086: END IF;
6087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6088: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6089: p_prefix=>l_debug_prefix,
6090: p_msg_level=>fnd_log.level_procedure);
6091: END IF;

Line 6090: p_msg_level=>fnd_log.level_procedure);

6086: END IF;
6087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6088: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6089: p_prefix=>l_debug_prefix,
6090: p_msg_level=>fnd_log.level_procedure);
6091: END IF;
6092:
6093: -- Check if API is called in debug mode. If yes, disable debug.
6094: --disable_debug;

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

6100: p_count => x_msg_count,
6101: p_data => x_msg_data);
6102:
6103: -- Debug info.
6104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6106: p_msg_data=>x_msg_data,
6107: p_msg_type=>'UNEXPECTED ERROR',
6108: p_msg_level=>fnd_log.level_error);

Line 6108: p_msg_level=>fnd_log.level_error);

6104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6106: p_msg_data=>x_msg_data,
6107: p_msg_type=>'UNEXPECTED ERROR',
6108: p_msg_level=>fnd_log.level_error);
6109: END IF;
6110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6111: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6112: p_prefix=>l_debug_prefix,

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

6106: p_msg_data=>x_msg_data,
6107: p_msg_type=>'UNEXPECTED ERROR',
6108: p_msg_level=>fnd_log.level_error);
6109: END IF;
6110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6111: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6112: p_prefix=>l_debug_prefix,
6113: p_msg_level=>fnd_log.level_procedure);
6114: END IF;

Line 6113: p_msg_level=>fnd_log.level_procedure);

6109: END IF;
6110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6111: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6112: p_prefix=>l_debug_prefix,
6113: p_msg_level=>fnd_log.level_procedure);
6114: END IF;
6115:
6116: -- Check if API is called in debug mode. If yes, disable debug.
6117: --disable_debug;

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

6127: p_count => x_msg_count,
6128: p_data => x_msg_data);
6129:
6130: -- Debug info.
6131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6133: p_msg_data=>x_msg_data,
6134: p_msg_type=>'SQL ERROR',
6135: p_msg_level=>fnd_log.level_error);

Line 6135: p_msg_level=>fnd_log.level_error);

6131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6133: p_msg_data=>x_msg_data,
6134: p_msg_type=>'SQL ERROR',
6135: p_msg_level=>fnd_log.level_error);
6136: END IF;
6137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6138: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6139: p_prefix=>l_debug_prefix,

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

6133: p_msg_data=>x_msg_data,
6134: p_msg_type=>'SQL ERROR',
6135: p_msg_level=>fnd_log.level_error);
6136: END IF;
6137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6138: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6139: p_prefix=>l_debug_prefix,
6140: p_msg_level=>fnd_log.level_procedure);
6141: END IF;

Line 6140: p_msg_level=>fnd_log.level_procedure);

6136: END IF;
6137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6138: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',
6139: p_prefix=>l_debug_prefix,
6140: p_msg_level=>fnd_log.level_procedure);
6141: END IF;
6142:
6143: -- Check if API is called in debug mode. If yes, disable debug.
6144: --disable_debug;

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

6196: -- Check if API is called in debug mode. If yes, enable debug.
6197: --enable_debug;
6198:
6199: -- Debug info.
6200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6201: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (+)',
6202: p_prefix=>l_debug_prefix,
6203: p_msg_level=>fnd_log.level_procedure);
6204: END IF;

Line 6203: p_msg_level=>fnd_log.level_procedure);

6199: -- Debug info.
6200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6201: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (+)',
6202: p_prefix=>l_debug_prefix,
6203: p_msg_level=>fnd_log.level_procedure);
6204: END IF;
6205:
6206: -- Execute main procedure
6207: get_contact_point_main (

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

6219: x_msg_data => x_msg_data
6220: );
6221:
6222: -- Debug info.
6223: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6224: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6225: p_msg_data=>x_msg_data,
6226: p_msg_type=>'WARNING',
6227: p_msg_level=>fnd_log.level_exception);

Line 6227: p_msg_level=>fnd_log.level_exception);

6223: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6224: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6225: p_msg_data=>x_msg_data,
6226: p_msg_type=>'WARNING',
6227: p_msg_level=>fnd_log.level_exception);
6228: END IF;
6229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6230: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6231: p_prefix=>l_debug_prefix,

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

6225: p_msg_data=>x_msg_data,
6226: p_msg_type=>'WARNING',
6227: p_msg_level=>fnd_log.level_exception);
6228: END IF;
6229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6230: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6231: p_prefix=>l_debug_prefix,
6232: p_msg_level=>fnd_log.level_procedure);
6233: END IF;

Line 6232: p_msg_level=>fnd_log.level_procedure);

6228: END IF;
6229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6230: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6231: p_prefix=>l_debug_prefix,
6232: p_msg_level=>fnd_log.level_procedure);
6233: END IF;
6234:
6235: -- Check if API is called in debug mode. If yes, disable debug.
6236: --disable_debug;

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

6243: p_count => x_msg_count,
6244: p_data => x_msg_data);
6245:
6246: -- Debug info.
6247: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6248: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6249: p_msg_data=>x_msg_data,
6250: p_msg_type=>'ERROR',
6251: p_msg_level=>fnd_log.level_error);

Line 6251: p_msg_level=>fnd_log.level_error);

6247: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6248: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6249: p_msg_data=>x_msg_data,
6250: p_msg_type=>'ERROR',
6251: p_msg_level=>fnd_log.level_error);
6252: END IF;
6253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6254: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6255: p_prefix=>l_debug_prefix,

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

6249: p_msg_data=>x_msg_data,
6250: p_msg_type=>'ERROR',
6251: p_msg_level=>fnd_log.level_error);
6252: END IF;
6253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6254: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6255: p_prefix=>l_debug_prefix,
6256: p_msg_level=>fnd_log.level_procedure);
6257: END IF;

Line 6256: p_msg_level=>fnd_log.level_procedure);

6252: END IF;
6253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6254: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6255: p_prefix=>l_debug_prefix,
6256: p_msg_level=>fnd_log.level_procedure);
6257: END IF;
6258:
6259: -- Check if API is called in debug mode. If yes, disable debug.
6260: --disable_debug;

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

6266: p_count => x_msg_count,
6267: p_data => x_msg_data);
6268:
6269: -- Debug info.
6270: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6271: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6272: p_msg_data=>x_msg_data,
6273: p_msg_type=>'UNEXPECTED ERROR',
6274: p_msg_level=>fnd_log.level_error);

Line 6274: p_msg_level=>fnd_log.level_error);

6270: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6271: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6272: p_msg_data=>x_msg_data,
6273: p_msg_type=>'UNEXPECTED ERROR',
6274: p_msg_level=>fnd_log.level_error);
6275: END IF;
6276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6277: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6278: p_prefix=>l_debug_prefix,

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

6272: p_msg_data=>x_msg_data,
6273: p_msg_type=>'UNEXPECTED ERROR',
6274: p_msg_level=>fnd_log.level_error);
6275: END IF;
6276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6277: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6278: p_prefix=>l_debug_prefix,
6279: p_msg_level=>fnd_log.level_procedure);
6280: END IF;

Line 6279: p_msg_level=>fnd_log.level_procedure);

6275: END IF;
6276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6277: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6278: p_prefix=>l_debug_prefix,
6279: p_msg_level=>fnd_log.level_procedure);
6280: END IF;
6281:
6282: -- Check if API is called in debug mode. If yes, disable debug.
6283: --disable_debug;

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

6293: p_count => x_msg_count,
6294: p_data => x_msg_data);
6295:
6296: -- Debug info.
6297: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6298: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6299: p_msg_data=>x_msg_data,
6300: p_msg_type=>'SQL ERROR',
6301: p_msg_level=>fnd_log.level_error);

Line 6301: p_msg_level=>fnd_log.level_error);

6297: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6298: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6299: p_msg_data=>x_msg_data,
6300: p_msg_type=>'SQL ERROR',
6301: p_msg_level=>fnd_log.level_error);
6302: END IF;
6303: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6304: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6305: p_prefix=>l_debug_prefix,

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

6299: p_msg_data=>x_msg_data,
6300: p_msg_type=>'SQL ERROR',
6301: p_msg_level=>fnd_log.level_error);
6302: END IF;
6303: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6304: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6305: p_prefix=>l_debug_prefix,
6306: p_msg_level=>fnd_log.level_procedure);
6307: END IF;

Line 6306: p_msg_level=>fnd_log.level_procedure);

6302: END IF;
6303: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6304: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',
6305: p_prefix=>l_debug_prefix,
6306: p_msg_level=>fnd_log.level_procedure);
6307: END IF;
6308:
6309: -- Check if API is called in debug mode. If yes, disable debug.
6310: --disable_debug;

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

6362: -- Check if API is called in debug mode. If yes, enable debug.
6363: --enable_debug;
6364:
6365: -- Debug info.
6366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6367: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (+)',
6368: p_prefix=>l_debug_prefix,
6369: p_msg_level=>fnd_log.level_procedure);
6370: END IF;

Line 6369: p_msg_level=>fnd_log.level_procedure);

6365: -- Debug info.
6366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6367: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (+)',
6368: p_prefix=>l_debug_prefix,
6369: p_msg_level=>fnd_log.level_procedure);
6370: END IF;
6371:
6372: -- Execute main procedure
6373: get_contact_point_main (

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

6386: );
6387:
6388:
6389: -- Debug info.
6390: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6391: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6392: p_msg_data=>x_msg_data,
6393: p_msg_type=>'WARNING',
6394: p_msg_level=>fnd_log.level_exception);

Line 6394: p_msg_level=>fnd_log.level_exception);

6390: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6391: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6392: p_msg_data=>x_msg_data,
6393: p_msg_type=>'WARNING',
6394: p_msg_level=>fnd_log.level_exception);
6395: END IF;
6396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6397: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6398: p_prefix=>l_debug_prefix,

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

6392: p_msg_data=>x_msg_data,
6393: p_msg_type=>'WARNING',
6394: p_msg_level=>fnd_log.level_exception);
6395: END IF;
6396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6397: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6398: p_prefix=>l_debug_prefix,
6399: p_msg_level=>fnd_log.level_procedure);
6400: END IF;

Line 6399: p_msg_level=>fnd_log.level_procedure);

6395: END IF;
6396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6397: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6398: p_prefix=>l_debug_prefix,
6399: p_msg_level=>fnd_log.level_procedure);
6400: END IF;
6401:
6402: -- Check if API is called in debug mode. If yes, disable debug.
6403: --disable_debug;

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

6410: p_count => x_msg_count,
6411: p_data => x_msg_data);
6412:
6413: -- Debug info.
6414: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6415: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6416: p_msg_data=>x_msg_data,
6417: p_msg_type=>'ERROR',
6418: p_msg_level=>fnd_log.level_error);

Line 6418: p_msg_level=>fnd_log.level_error);

6414: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6415: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6416: p_msg_data=>x_msg_data,
6417: p_msg_type=>'ERROR',
6418: p_msg_level=>fnd_log.level_error);
6419: END IF;
6420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6421: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6422: p_prefix=>l_debug_prefix,

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

6416: p_msg_data=>x_msg_data,
6417: p_msg_type=>'ERROR',
6418: p_msg_level=>fnd_log.level_error);
6419: END IF;
6420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6421: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6422: p_prefix=>l_debug_prefix,
6423: p_msg_level=>fnd_log.level_procedure);
6424: END IF;

Line 6423: p_msg_level=>fnd_log.level_procedure);

6419: END IF;
6420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6421: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6422: p_prefix=>l_debug_prefix,
6423: p_msg_level=>fnd_log.level_procedure);
6424: END IF;
6425:
6426: -- Check if API is called in debug mode. If yes, disable debug.
6427: --disable_debug;

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

6433: p_count => x_msg_count,
6434: p_data => x_msg_data);
6435:
6436: -- Debug info.
6437: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6438: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6439: p_msg_data=>x_msg_data,
6440: p_msg_type=>'UNEXPECTED ERROR',
6441: p_msg_level=>fnd_log.level_error);

Line 6441: p_msg_level=>fnd_log.level_error);

6437: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6438: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6439: p_msg_data=>x_msg_data,
6440: p_msg_type=>'UNEXPECTED ERROR',
6441: p_msg_level=>fnd_log.level_error);
6442: END IF;
6443: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6444: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6445: p_prefix=>l_debug_prefix,

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

6439: p_msg_data=>x_msg_data,
6440: p_msg_type=>'UNEXPECTED ERROR',
6441: p_msg_level=>fnd_log.level_error);
6442: END IF;
6443: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6444: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6445: p_prefix=>l_debug_prefix,
6446: p_msg_level=>fnd_log.level_procedure);
6447: END IF;

Line 6446: p_msg_level=>fnd_log.level_procedure);

6442: END IF;
6443: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6444: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6445: p_prefix=>l_debug_prefix,
6446: p_msg_level=>fnd_log.level_procedure);
6447: END IF;
6448:
6449: -- Check if API is called in debug mode. If yes, disable debug.
6450: --disable_debug;

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

6460: p_count => x_msg_count,
6461: p_data => x_msg_data);
6462:
6463: -- Debug info.
6464: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6466: p_msg_data=>x_msg_data,
6467: p_msg_type=>'SQL ERROR',
6468: p_msg_level=>fnd_log.level_error);

Line 6468: p_msg_level=>fnd_log.level_error);

6464: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6466: p_msg_data=>x_msg_data,
6467: p_msg_type=>'SQL ERROR',
6468: p_msg_level=>fnd_log.level_error);
6469: END IF;
6470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6471: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6472: p_prefix=>l_debug_prefix,

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

6466: p_msg_data=>x_msg_data,
6467: p_msg_type=>'SQL ERROR',
6468: p_msg_level=>fnd_log.level_error);
6469: END IF;
6470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6471: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6472: p_prefix=>l_debug_prefix,
6473: p_msg_level=>fnd_log.level_procedure);
6474: END IF;

Line 6473: p_msg_level=>fnd_log.level_procedure);

6469: END IF;
6470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6471: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',
6472: p_prefix=>l_debug_prefix,
6473: p_msg_level=>fnd_log.level_procedure);
6474: END IF;
6475:
6476: -- Check if API is called in debug mode. If yes, disable debug.
6477: --disable_debug;

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

6530: -- Check if API is called in debug mode. If yes, enable debug.
6531: --enable_debug;
6532:
6533: -- Debug info.
6534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6535: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (+)',
6536: p_prefix=>l_debug_prefix,
6537: p_msg_level=>fnd_log.level_procedure);
6538: END IF;

Line 6537: p_msg_level=>fnd_log.level_procedure);

6533: -- Debug info.
6534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6535: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (+)',
6536: p_prefix=>l_debug_prefix,
6537: p_msg_level=>fnd_log.level_procedure);
6538: END IF;
6539:
6540: -- Execute main procedure
6541: get_contact_point_main (

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

6553: x_msg_data => x_msg_data
6554: );
6555:
6556: -- Debug info.
6557: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6558: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6559: p_msg_data=>x_msg_data,
6560: p_msg_type=>'WARNING',
6561: p_msg_level=>fnd_log.level_exception);

Line 6561: p_msg_level=>fnd_log.level_exception);

6557: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6558: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6559: p_msg_data=>x_msg_data,
6560: p_msg_type=>'WARNING',
6561: p_msg_level=>fnd_log.level_exception);
6562: END IF;
6563: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6564: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6565: p_prefix=>l_debug_prefix,

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

6559: p_msg_data=>x_msg_data,
6560: p_msg_type=>'WARNING',
6561: p_msg_level=>fnd_log.level_exception);
6562: END IF;
6563: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6564: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6565: p_prefix=>l_debug_prefix,
6566: p_msg_level=>fnd_log.level_procedure);
6567: END IF;

Line 6566: p_msg_level=>fnd_log.level_procedure);

6562: END IF;
6563: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6564: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6565: p_prefix=>l_debug_prefix,
6566: p_msg_level=>fnd_log.level_procedure);
6567: END IF;
6568:
6569: -- Check if API is called in debug mode. If yes, disable debug.
6570: --disable_debug;

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

6577: p_count => x_msg_count,
6578: p_data => x_msg_data);
6579:
6580: -- Debug info.
6581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6582: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6583: p_msg_data=>x_msg_data,
6584: p_msg_type=>'ERROR',
6585: p_msg_level=>fnd_log.level_error);

Line 6585: p_msg_level=>fnd_log.level_error);

6581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6582: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6583: p_msg_data=>x_msg_data,
6584: p_msg_type=>'ERROR',
6585: p_msg_level=>fnd_log.level_error);
6586: END IF;
6587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6588: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6589: p_prefix=>l_debug_prefix,

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

6583: p_msg_data=>x_msg_data,
6584: p_msg_type=>'ERROR',
6585: p_msg_level=>fnd_log.level_error);
6586: END IF;
6587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6588: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6589: p_prefix=>l_debug_prefix,
6590: p_msg_level=>fnd_log.level_procedure);
6591: END IF;

Line 6590: p_msg_level=>fnd_log.level_procedure);

6586: END IF;
6587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6588: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6589: p_prefix=>l_debug_prefix,
6590: p_msg_level=>fnd_log.level_procedure);
6591: END IF;
6592:
6593: -- Check if API is called in debug mode. If yes, disable debug.
6594: --disable_debug;

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

6600: p_count => x_msg_count,
6601: p_data => x_msg_data);
6602:
6603: -- Debug info.
6604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6606: p_msg_data=>x_msg_data,
6607: p_msg_type=>'UNEXPECTED ERROR',
6608: p_msg_level=>fnd_log.level_error);

Line 6608: p_msg_level=>fnd_log.level_error);

6604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6606: p_msg_data=>x_msg_data,
6607: p_msg_type=>'UNEXPECTED ERROR',
6608: p_msg_level=>fnd_log.level_error);
6609: END IF;
6610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6611: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6612: p_prefix=>l_debug_prefix,

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

6606: p_msg_data=>x_msg_data,
6607: p_msg_type=>'UNEXPECTED ERROR',
6608: p_msg_level=>fnd_log.level_error);
6609: END IF;
6610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6611: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6612: p_prefix=>l_debug_prefix,
6613: p_msg_level=>fnd_log.level_procedure);
6614: END IF;

Line 6613: p_msg_level=>fnd_log.level_procedure);

6609: END IF;
6610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6611: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6612: p_prefix=>l_debug_prefix,
6613: p_msg_level=>fnd_log.level_procedure);
6614: END IF;
6615:
6616:
6617: -- Check if API is called in debug mode. If yes, disable debug.

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

6628: p_count => x_msg_count,
6629: p_data => x_msg_data);
6630:
6631: -- Debug info.
6632: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6634: p_msg_data=>x_msg_data,
6635: p_msg_type=>'SQL ERROR',
6636: p_msg_level=>fnd_log.level_error);

Line 6636: p_msg_level=>fnd_log.level_error);

6632: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6634: p_msg_data=>x_msg_data,
6635: p_msg_type=>'SQL ERROR',
6636: p_msg_level=>fnd_log.level_error);
6637: END IF;
6638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6639: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6640: p_prefix=>l_debug_prefix,

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

6634: p_msg_data=>x_msg_data,
6635: p_msg_type=>'SQL ERROR',
6636: p_msg_level=>fnd_log.level_error);
6637: END IF;
6638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6639: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6640: p_prefix=>l_debug_prefix,
6641: p_msg_level=>fnd_log.level_procedure);
6642: END IF;

Line 6641: p_msg_level=>fnd_log.level_procedure);

6637: END IF;
6638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6639: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',
6640: p_prefix=>l_debug_prefix,
6641: p_msg_level=>fnd_log.level_procedure);
6642: END IF;
6643:
6644: -- Check if API is called in debug mode. If yes, disable debug.
6645: --disable_debug;

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

6697: -- Check if API is called in debug mode. If yes, enable debug.
6698: --enable_debug;
6699:
6700: -- Debug info.
6701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6702: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (+)',
6703: p_prefix=>l_debug_prefix,
6704: p_msg_level=>fnd_log.level_procedure);
6705: END IF;

Line 6704: p_msg_level=>fnd_log.level_procedure);

6700: -- Debug info.
6701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6702: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (+)',
6703: p_prefix=>l_debug_prefix,
6704: p_msg_level=>fnd_log.level_procedure);
6705: END IF;
6706:
6707: -- Execute main procedure
6708: get_contact_point_main (

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

6720: x_msg_data => x_msg_data
6721: );
6722:
6723: -- Debug info.
6724: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6725: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6726: p_msg_data=>x_msg_data,
6727: p_msg_type=>'WARNING',
6728: p_msg_level=>fnd_log.level_exception);

Line 6728: p_msg_level=>fnd_log.level_exception);

6724: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6725: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6726: p_msg_data=>x_msg_data,
6727: p_msg_type=>'WARNING',
6728: p_msg_level=>fnd_log.level_exception);
6729: END IF;
6730: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6731: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6732: p_prefix=>l_debug_prefix,

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

6726: p_msg_data=>x_msg_data,
6727: p_msg_type=>'WARNING',
6728: p_msg_level=>fnd_log.level_exception);
6729: END IF;
6730: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6731: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6732: p_prefix=>l_debug_prefix,
6733: p_msg_level=>fnd_log.level_procedure);
6734: END IF;

Line 6733: p_msg_level=>fnd_log.level_procedure);

6729: END IF;
6730: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6731: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6732: p_prefix=>l_debug_prefix,
6733: p_msg_level=>fnd_log.level_procedure);
6734: END IF;
6735:
6736: -- Check if API is called in debug mode. If yes, disable debug.
6737: --disable_debug;

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

6744: p_count => x_msg_count,
6745: p_data => x_msg_data);
6746:
6747: -- Debug info.
6748: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6749: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6750: p_msg_data=>x_msg_data,
6751: p_msg_type=>'ERROR',
6752: p_msg_level=>fnd_log.level_error);

Line 6752: p_msg_level=>fnd_log.level_error);

6748: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6749: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6750: p_msg_data=>x_msg_data,
6751: p_msg_type=>'ERROR',
6752: p_msg_level=>fnd_log.level_error);
6753: END IF;
6754: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6755: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6756: p_prefix=>l_debug_prefix,

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

6750: p_msg_data=>x_msg_data,
6751: p_msg_type=>'ERROR',
6752: p_msg_level=>fnd_log.level_error);
6753: END IF;
6754: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6755: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6756: p_prefix=>l_debug_prefix,
6757: p_msg_level=>fnd_log.level_procedure);
6758: END IF;

Line 6757: p_msg_level=>fnd_log.level_procedure);

6753: END IF;
6754: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6755: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6756: p_prefix=>l_debug_prefix,
6757: p_msg_level=>fnd_log.level_procedure);
6758: END IF;
6759:
6760: -- Check if API is called in debug mode. If yes, disable debug.
6761: --disable_debug;

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

6767: p_count => x_msg_count,
6768: p_data => x_msg_data);
6769:
6770: -- Debug info.
6771: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6772: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6773: p_msg_data=>x_msg_data,
6774: p_msg_type=>'UNEXPECTED ERROR',
6775: p_msg_level=>fnd_log.level_error);

Line 6775: p_msg_level=>fnd_log.level_error);

6771: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6772: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6773: p_msg_data=>x_msg_data,
6774: p_msg_type=>'UNEXPECTED ERROR',
6775: p_msg_level=>fnd_log.level_error);
6776: END IF;
6777: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6778: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6779: p_prefix=>l_debug_prefix,

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

6773: p_msg_data=>x_msg_data,
6774: p_msg_type=>'UNEXPECTED ERROR',
6775: p_msg_level=>fnd_log.level_error);
6776: END IF;
6777: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6778: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6779: p_prefix=>l_debug_prefix,
6780: p_msg_level=>fnd_log.level_procedure);
6781: END IF;

Line 6780: p_msg_level=>fnd_log.level_procedure);

6776: END IF;
6777: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6778: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6779: p_prefix=>l_debug_prefix,
6780: p_msg_level=>fnd_log.level_procedure);
6781: END IF;
6782:
6783: -- Check if API is called in debug mode. If yes, disable debug.
6784: --disable_debug;

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

6794: p_count => x_msg_count,
6795: p_data => x_msg_data);
6796:
6797: -- Debug info.
6798: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6799: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6800: p_msg_data=>x_msg_data,
6801: p_msg_type=>'SQL ERROR',
6802: p_msg_level=>fnd_log.level_error);

Line 6802: p_msg_level=>fnd_log.level_error);

6798: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6799: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6800: p_msg_data=>x_msg_data,
6801: p_msg_type=>'SQL ERROR',
6802: p_msg_level=>fnd_log.level_error);
6803: END IF;
6804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6805: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6806: p_prefix=>l_debug_prefix,

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

6800: p_msg_data=>x_msg_data,
6801: p_msg_type=>'SQL ERROR',
6802: p_msg_level=>fnd_log.level_error);
6803: END IF;
6804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6805: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6806: p_prefix=>l_debug_prefix,
6807: p_msg_level=>fnd_log.level_procedure);
6808: END IF;

Line 6807: p_msg_level=>fnd_log.level_procedure);

6803: END IF;
6804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6805: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',
6806: p_prefix=>l_debug_prefix,
6807: p_msg_level=>fnd_log.level_procedure);
6808: END IF;
6809:
6810: -- Check if API is called in debug mode. If yes, disable debug.
6811: --disable_debug;

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

6863: -- Check if API is called in debug mode. If yes, enable debug.
6864: --enable_debug;
6865:
6866: -- Debug info.
6867: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6868: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (+)',
6869: p_prefix=>l_debug_prefix,
6870: p_msg_level=>fnd_log.level_procedure);
6871: END IF;

Line 6870: p_msg_level=>fnd_log.level_procedure);

6866: -- Debug info.
6867: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6868: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (+)',
6869: p_prefix=>l_debug_prefix,
6870: p_msg_level=>fnd_log.level_procedure);
6871: END IF;
6872:
6873: -- Execute main procedure
6874: get_contact_point_main (

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

6886: x_msg_data => x_msg_data
6887: );
6888:
6889: -- Debug info.
6890: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6891: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6892: p_msg_data=>x_msg_data,
6893: p_msg_type=>'WARNING',
6894: p_msg_level=>fnd_log.level_exception);

Line 6894: p_msg_level=>fnd_log.level_exception);

6890: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6891: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6892: p_msg_data=>x_msg_data,
6893: p_msg_type=>'WARNING',
6894: p_msg_level=>fnd_log.level_exception);
6895: END IF;
6896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6897: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6898: p_prefix=>l_debug_prefix,

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

6892: p_msg_data=>x_msg_data,
6893: p_msg_type=>'WARNING',
6894: p_msg_level=>fnd_log.level_exception);
6895: END IF;
6896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6897: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6898: p_prefix=>l_debug_prefix,
6899: p_msg_level=>fnd_log.level_procedure);
6900: END IF;

Line 6899: p_msg_level=>fnd_log.level_procedure);

6895: END IF;
6896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6897: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6898: p_prefix=>l_debug_prefix,
6899: p_msg_level=>fnd_log.level_procedure);
6900: END IF;
6901:
6902: -- Check if API is called in debug mode. If yes, disable debug.
6903: --disable_debug;

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

6910: p_count => x_msg_count,
6911: p_data => x_msg_data);
6912:
6913: -- Debug info.
6914: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6915: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6916: p_msg_data=>x_msg_data,
6917: p_msg_type=>'ERROR',
6918: p_msg_level=>fnd_log.level_error);

Line 6918: p_msg_level=>fnd_log.level_error);

6914: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6915: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6916: p_msg_data=>x_msg_data,
6917: p_msg_type=>'ERROR',
6918: p_msg_level=>fnd_log.level_error);
6919: END IF;
6920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6921: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6922: p_prefix=>l_debug_prefix,

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

6916: p_msg_data=>x_msg_data,
6917: p_msg_type=>'ERROR',
6918: p_msg_level=>fnd_log.level_error);
6919: END IF;
6920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6921: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6922: p_prefix=>l_debug_prefix,
6923: p_msg_level=>fnd_log.level_procedure);
6924: END IF;

Line 6923: p_msg_level=>fnd_log.level_procedure);

6919: END IF;
6920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6921: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6922: p_prefix=>l_debug_prefix,
6923: p_msg_level=>fnd_log.level_procedure);
6924: END IF;
6925:
6926: -- Check if API is called in debug mode. If yes, disable debug.
6927: --disable_debug;

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

6933: p_count => x_msg_count,
6934: p_data => x_msg_data);
6935:
6936: -- Debug info.
6937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6939: p_msg_data=>x_msg_data,
6940: p_msg_type=>'UNEXPECTED ERROR',
6941: p_msg_level=>fnd_log.level_error);

Line 6941: p_msg_level=>fnd_log.level_error);

6937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6939: p_msg_data=>x_msg_data,
6940: p_msg_type=>'UNEXPECTED ERROR',
6941: p_msg_level=>fnd_log.level_error);
6942: END IF;
6943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6944: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6945: p_prefix=>l_debug_prefix,

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

6939: p_msg_data=>x_msg_data,
6940: p_msg_type=>'UNEXPECTED ERROR',
6941: p_msg_level=>fnd_log.level_error);
6942: END IF;
6943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6944: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6945: p_prefix=>l_debug_prefix,
6946: p_msg_level=>fnd_log.level_procedure);
6947: END IF;

Line 6946: p_msg_level=>fnd_log.level_procedure);

6942: END IF;
6943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6944: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6945: p_prefix=>l_debug_prefix,
6946: p_msg_level=>fnd_log.level_procedure);
6947: END IF;
6948:
6949: -- Check if API is called in debug mode. If yes, disable debug.
6950: --disable_debug;

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

6960: p_count => x_msg_count,
6961: p_data => x_msg_data);
6962:
6963: -- Debug info.
6964: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6965: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6966: p_msg_data=>x_msg_data,
6967: p_msg_type=>'SQL ERROR',
6968: p_msg_level=>fnd_log.level_error);

Line 6968: p_msg_level=>fnd_log.level_error);

6964: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6965: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6966: p_msg_data=>x_msg_data,
6967: p_msg_type=>'SQL ERROR',
6968: p_msg_level=>fnd_log.level_error);
6969: END IF;
6970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6971: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6972: p_prefix=>l_debug_prefix,

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

6966: p_msg_data=>x_msg_data,
6967: p_msg_type=>'SQL ERROR',
6968: p_msg_level=>fnd_log.level_error);
6969: END IF;
6970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6971: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6972: p_prefix=>l_debug_prefix,
6973: p_msg_level=>fnd_log.level_procedure);
6974: END IF;

Line 6973: p_msg_level=>fnd_log.level_procedure);

6969: END IF;
6970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6971: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',
6972: p_prefix=>l_debug_prefix,
6973: p_msg_level=>fnd_log.level_procedure);
6974: END IF;
6975:
6976: -- Check if API is called in debug mode. If yes, disable debug.
6977: --disable_debug;

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

7029: -- Check if API is called in debug mode. If yes, enable debug.
7030: --enable_debug;
7031:
7032: -- Debug info.
7033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7034: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (+)',
7035: p_prefix=>l_debug_prefix,
7036: p_msg_level=>fnd_log.level_procedure);
7037: END IF;

Line 7036: p_msg_level=>fnd_log.level_procedure);

7032: -- Debug info.
7033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7034: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (+)',
7035: p_prefix=>l_debug_prefix,
7036: p_msg_level=>fnd_log.level_procedure);
7037: END IF;
7038:
7039:
7040: -- Execute main procedure

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

7053: x_msg_data => x_msg_data
7054: );
7055:
7056: -- Debug info.
7057: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
7058: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7059: p_msg_data=>x_msg_data,
7060: p_msg_type=>'WARNING',
7061: p_msg_level=>fnd_log.level_exception);

Line 7061: p_msg_level=>fnd_log.level_exception);

7057: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
7058: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7059: p_msg_data=>x_msg_data,
7060: p_msg_type=>'WARNING',
7061: p_msg_level=>fnd_log.level_exception);
7062: END IF;
7063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7064: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7065: p_prefix=>l_debug_prefix,

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

7059: p_msg_data=>x_msg_data,
7060: p_msg_type=>'WARNING',
7061: p_msg_level=>fnd_log.level_exception);
7062: END IF;
7063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7064: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7065: p_prefix=>l_debug_prefix,
7066: p_msg_level=>fnd_log.level_procedure);
7067: END IF;

Line 7066: p_msg_level=>fnd_log.level_procedure);

7062: END IF;
7063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7064: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7065: p_prefix=>l_debug_prefix,
7066: p_msg_level=>fnd_log.level_procedure);
7067: END IF;
7068:
7069: -- Check if API is called in debug mode. If yes, disable debug.
7070: --disable_debug;

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

7077: p_count => x_msg_count,
7078: p_data => x_msg_data);
7079:
7080: -- Debug info.
7081: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7082: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7083: p_msg_data=>x_msg_data,
7084: p_msg_type=>'ERROR',
7085: p_msg_level=>fnd_log.level_error);

Line 7085: p_msg_level=>fnd_log.level_error);

7081: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7082: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7083: p_msg_data=>x_msg_data,
7084: p_msg_type=>'ERROR',
7085: p_msg_level=>fnd_log.level_error);
7086: END IF;
7087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7088: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7089: p_prefix=>l_debug_prefix,

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

7083: p_msg_data=>x_msg_data,
7084: p_msg_type=>'ERROR',
7085: p_msg_level=>fnd_log.level_error);
7086: END IF;
7087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7088: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7089: p_prefix=>l_debug_prefix,
7090: p_msg_level=>fnd_log.level_procedure);
7091: END IF;

Line 7090: p_msg_level=>fnd_log.level_procedure);

7086: END IF;
7087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7088: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7089: p_prefix=>l_debug_prefix,
7090: p_msg_level=>fnd_log.level_procedure);
7091: END IF;
7092:
7093: -- Check if API is called in debug mode. If yes, disable debug.
7094: --disable_debug;

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

7100: p_count => x_msg_count,
7101: p_data => x_msg_data);
7102:
7103: -- Debug info.
7104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7106: p_msg_data=>x_msg_data,
7107: p_msg_type=>'UNEXPECTED ERROR',
7108: p_msg_level=>fnd_log.level_error);

Line 7108: p_msg_level=>fnd_log.level_error);

7104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7106: p_msg_data=>x_msg_data,
7107: p_msg_type=>'UNEXPECTED ERROR',
7108: p_msg_level=>fnd_log.level_error);
7109: END IF;
7110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7111: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7112: p_prefix=>l_debug_prefix,

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

7106: p_msg_data=>x_msg_data,
7107: p_msg_type=>'UNEXPECTED ERROR',
7108: p_msg_level=>fnd_log.level_error);
7109: END IF;
7110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7111: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7112: p_prefix=>l_debug_prefix,
7113: p_msg_level=>fnd_log.level_procedure);
7114: END IF;

Line 7113: p_msg_level=>fnd_log.level_procedure);

7109: END IF;
7110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7111: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7112: p_prefix=>l_debug_prefix,
7113: p_msg_level=>fnd_log.level_procedure);
7114: END IF;
7115:
7116: -- Check if API is called in debug mode. If yes, disable debug.
7117: --disable_debug;

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

7127: p_count => x_msg_count,
7128: p_data => x_msg_data);
7129:
7130: -- Debug info.
7131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7133: p_msg_data=>x_msg_data,
7134: p_msg_type=>'SQL ERROR',
7135: p_msg_level=>fnd_log.level_error);

Line 7135: p_msg_level=>fnd_log.level_error);

7131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7133: p_msg_data=>x_msg_data,
7134: p_msg_type=>'SQL ERROR',
7135: p_msg_level=>fnd_log.level_error);
7136: END IF;
7137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7138: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7139: p_prefix=>l_debug_prefix,

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

7133: p_msg_data=>x_msg_data,
7134: p_msg_type=>'SQL ERROR',
7135: p_msg_level=>fnd_log.level_error);
7136: END IF;
7137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7138: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7139: p_prefix=>l_debug_prefix,
7140: p_msg_level=>fnd_log.level_procedure);
7141: END IF;

Line 7140: p_msg_level=>fnd_log.level_procedure);

7136: END IF;
7137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7138: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',
7139: p_prefix=>l_debug_prefix,
7140: p_msg_level=>fnd_log.level_procedure);
7141: END IF;
7142:
7143: -- Check if API is called in debug mode. If yes, disable debug.
7144: --disable_debug;