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 HZ_UTILITY_V2PUB

Line 133: -- HZ_UTILITY_V2PUB.enable_debug

129: -- DESCRIPTION
130: -- Turn on debug mode.
131: --
132: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
133: -- HZ_UTILITY_V2PUB.enable_debug
134: --
135: -- MODIFICATION HISTORY
136: --
137: -- 07-23-2001 Jianying Huang o Created.

Line 149: hz_utility_v2pub.enable_debug;

145: IF g_debug_count = 1 THEN
146: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
147: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
148: THEN
149: hz_utility_v2pub.enable_debug;
150: g_debug := TRUE;
151: END IF;
152: END IF;
153: END enable_debug;

Line 163: -- HZ_UTILITY_V2PUB.disable_debug

159: -- DESCRIPTION
160: -- Turn off debug mode.
161: --
162: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
163: -- HZ_UTILITY_V2PUB.disable_debug
164: --
165: -- MODIFICATION HISTORY
166: --
167: -- 07-23-2001 Jianying Huang o Created.

Line 177: hz_utility_v2pub.disable_debug;

173: IF g_debug THEN
174: g_debug_count := g_debug_count - 1;
175:
176: IF g_debug_count = 0 THEN
177: hz_utility_v2pub.disable_debug;
178: g_debug := FALSE;
179: END IF;
180: END IF;
181: END disable_debug;

Line 358: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (+)',

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

Line 471: hz_utility_v2pub.debug(p_message=>'contact_point_type = ' || p_contact_point_rec.contact_point_type,

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

Line 566: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||

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

Line 592: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || l_transposed_phone_number,

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

Line 724: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (+)',

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

Line 804: hz_utility_v2pub.debug(p_message=>'primary_flag = ' || p_contact_point_rec.primary_flag || ' ' ||

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,
808: p_prefix =>l_debug_prefix,

Line 879: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (-) ' ||

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

Line 911: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',

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

Line 1087: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (+)',

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

Line 1142: hz_utility_v2pub.debug(p_message=>'l_contact_point_type = ' || l_contact_point_type,

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

Line 1382: hz_utility_v2pub.debug(p_message=>'phone_number = ' || l_phone_rec.phone_number || ' ' ||

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

Line 1411: hz_utility_v2pub.debug(p_message=>'transposed_phone_number = ' || 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;
1415:

Line 1718: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',

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

Line 1724: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

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
1725: l_acs := nvl(p_contact_point_rec.actual_content_source, 'USER_ENTERED');
1726: ELSE
1727: l_acs := NULL;
1728: END IF;

Line 1800: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Update_Row (-) ',

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 (-)',
1804: p_prefix=>l_debug_prefix,

Line 1803: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',

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

Line 1887: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (+)',

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

Line 1908: last_update_date = hz_utility_v2pub.last_update_date,

1904:
1905: UPDATE hz_contact_points
1906: SET primary_flag = 'N',
1907: --Bug number 2914238 .Updated the who columns.
1908: last_update_date = hz_utility_v2pub.last_update_date,
1909: last_updated_by = hz_utility_v2pub.last_updated_by,
1910: last_update_login = hz_utility_v2pub.last_update_login,
1911: request_id = hz_utility_v2pub.request_id,
1912: program_id = hz_utility_v2pub.program_id,

Line 1909: last_updated_by = hz_utility_v2pub.last_updated_by,

1905: UPDATE hz_contact_points
1906: SET primary_flag = 'N',
1907: --Bug number 2914238 .Updated the who columns.
1908: last_update_date = hz_utility_v2pub.last_update_date,
1909: last_updated_by = hz_utility_v2pub.last_updated_by,
1910: last_update_login = hz_utility_v2pub.last_update_login,
1911: request_id = hz_utility_v2pub.request_id,
1912: program_id = hz_utility_v2pub.program_id,
1913: program_application_id = hz_utility_v2pub.program_application_id,

Line 1910: last_update_login = hz_utility_v2pub.last_update_login,

1906: SET primary_flag = 'N',
1907: --Bug number 2914238 .Updated the who columns.
1908: last_update_date = hz_utility_v2pub.last_update_date,
1909: last_updated_by = hz_utility_v2pub.last_updated_by,
1910: last_update_login = hz_utility_v2pub.last_update_login,
1911: request_id = hz_utility_v2pub.request_id,
1912: program_id = hz_utility_v2pub.program_id,
1913: program_application_id = hz_utility_v2pub.program_application_id,
1914: program_update_date = hz_utility_v2pub.program_update_date

Line 1911: request_id = hz_utility_v2pub.request_id,

1907: --Bug number 2914238 .Updated the who columns.
1908: last_update_date = hz_utility_v2pub.last_update_date,
1909: last_updated_by = hz_utility_v2pub.last_updated_by,
1910: last_update_login = hz_utility_v2pub.last_update_login,
1911: request_id = hz_utility_v2pub.request_id,
1912: program_id = hz_utility_v2pub.program_id,
1913: program_application_id = hz_utility_v2pub.program_application_id,
1914: program_update_date = hz_utility_v2pub.program_update_date
1915: WHERE owner_table_name = p_owner_table_name

Line 1912: program_id = hz_utility_v2pub.program_id,

1908: last_update_date = hz_utility_v2pub.last_update_date,
1909: last_updated_by = hz_utility_v2pub.last_updated_by,
1910: last_update_login = hz_utility_v2pub.last_update_login,
1911: request_id = hz_utility_v2pub.request_id,
1912: program_id = hz_utility_v2pub.program_id,
1913: program_application_id = hz_utility_v2pub.program_application_id,
1914: program_update_date = hz_utility_v2pub.program_update_date
1915: WHERE owner_table_name = p_owner_table_name
1916: AND owner_table_id = p_owner_table_id

Line 1913: program_application_id = hz_utility_v2pub.program_application_id,

1909: last_updated_by = hz_utility_v2pub.last_updated_by,
1910: last_update_login = hz_utility_v2pub.last_update_login,
1911: request_id = hz_utility_v2pub.request_id,
1912: program_id = hz_utility_v2pub.program_id,
1913: program_application_id = hz_utility_v2pub.program_application_id,
1914: program_update_date = hz_utility_v2pub.program_update_date
1915: WHERE owner_table_name = p_owner_table_name
1916: AND owner_table_id = p_owner_table_id
1917: AND contact_point_type = p_contact_point_type

Line 1914: program_update_date = hz_utility_v2pub.program_update_date

1910: last_update_login = hz_utility_v2pub.last_update_login,
1911: request_id = hz_utility_v2pub.request_id,
1912: program_id = hz_utility_v2pub.program_id,
1913: program_application_id = hz_utility_v2pub.program_application_id,
1914: program_update_date = hz_utility_v2pub.program_update_date
1915: WHERE owner_table_name = p_owner_table_name
1916: AND owner_table_id = p_owner_table_id
1917: AND contact_point_type = p_contact_point_type
1918: AND contact_point_id <> l_contact_point_id

Line 1930: (HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

1926: --Direct Update is missing Business event call, added event call.
1927:
1928: I := 1;
1929: IF l_contactpointidtab.COUNT > 0 AND
1930: (HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1931: LOOP
1932:
1933: l_contact_point_rec.contact_point_id := l_contactpointidtab(i);
1934:

Line 1937: hz_utility_v2pub.debug(p_message=>'Raising Business Event for Contact Point Id : '||l_contact_point_rec.contact_point_id,

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

Line 1959: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1955: l_web_rec,
1956: l_old_web_rec);
1957:
1958: --bug #5203798
1959: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1960: -- populate function for integration service
1961: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
1962: p_operation => p_mode,
1963: p_contact_point_id => l_contactpointidtab(i));

Line 1978: hz_utility_v2pub.debug(p_message=>'do_unset_prim_contact_point (-)',

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

Line 2034: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (+)',

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;
2038: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2039: hz_utility_v2pub.debug(p_message=>'party_id = ' || p_party_id || ' ' ||

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||
2043: 'primary_phone_contact_pt_id = ' || p_phone_contact_pt_id || ' ' ||

Line 2058: last_update_date = hz_utility_v2pub.last_update_date,

2054:
2055: IF p_contact_point_type = 'WEB' THEN
2056: UPDATE hz_parties
2057: SET url = p_url,
2058: last_update_date = hz_utility_v2pub.last_update_date,
2059: last_updated_by = hz_utility_v2pub.last_updated_by,
2060: last_update_login = hz_utility_v2pub.last_update_login,
2061: request_id = hz_utility_v2pub.request_id,
2062: program_application_id = hz_utility_v2pub.program_application_id,

Line 2059: last_updated_by = hz_utility_v2pub.last_updated_by,

2055: IF p_contact_point_type = 'WEB' THEN
2056: UPDATE hz_parties
2057: SET url = p_url,
2058: last_update_date = hz_utility_v2pub.last_update_date,
2059: last_updated_by = hz_utility_v2pub.last_updated_by,
2060: last_update_login = hz_utility_v2pub.last_update_login,
2061: request_id = hz_utility_v2pub.request_id,
2062: program_application_id = hz_utility_v2pub.program_application_id,
2063: program_id = hz_utility_v2pub.program_id,

Line 2060: last_update_login = hz_utility_v2pub.last_update_login,

2056: UPDATE hz_parties
2057: SET url = p_url,
2058: last_update_date = hz_utility_v2pub.last_update_date,
2059: last_updated_by = hz_utility_v2pub.last_updated_by,
2060: last_update_login = hz_utility_v2pub.last_update_login,
2061: request_id = hz_utility_v2pub.request_id,
2062: program_application_id = hz_utility_v2pub.program_application_id,
2063: program_id = hz_utility_v2pub.program_id,
2064: program_update_date = sysdate

Line 2061: request_id = hz_utility_v2pub.request_id,

2057: SET url = p_url,
2058: last_update_date = hz_utility_v2pub.last_update_date,
2059: last_updated_by = hz_utility_v2pub.last_updated_by,
2060: last_update_login = hz_utility_v2pub.last_update_login,
2061: request_id = hz_utility_v2pub.request_id,
2062: program_application_id = hz_utility_v2pub.program_application_id,
2063: program_id = hz_utility_v2pub.program_id,
2064: program_update_date = sysdate
2065: WHERE party_id = p_party_id;

Line 2062: program_application_id = hz_utility_v2pub.program_application_id,

2058: last_update_date = hz_utility_v2pub.last_update_date,
2059: last_updated_by = hz_utility_v2pub.last_updated_by,
2060: last_update_login = hz_utility_v2pub.last_update_login,
2061: request_id = hz_utility_v2pub.request_id,
2062: program_application_id = hz_utility_v2pub.program_application_id,
2063: program_id = hz_utility_v2pub.program_id,
2064: program_update_date = sysdate
2065: WHERE party_id = p_party_id;
2066: ELSIF p_contact_point_type = 'EMAIL' THEN

Line 2063: program_id = hz_utility_v2pub.program_id,

2059: last_updated_by = hz_utility_v2pub.last_updated_by,
2060: last_update_login = hz_utility_v2pub.last_update_login,
2061: request_id = hz_utility_v2pub.request_id,
2062: program_application_id = hz_utility_v2pub.program_application_id,
2063: program_id = hz_utility_v2pub.program_id,
2064: program_update_date = sysdate
2065: WHERE party_id = p_party_id;
2066: ELSIF p_contact_point_type = 'EMAIL' THEN
2067: UPDATE hz_parties

Line 2070: last_update_date = hz_utility_v2pub.last_update_date,

2066: ELSIF p_contact_point_type = 'EMAIL' THEN
2067: UPDATE hz_parties
2068: /* Bug No : 4355133*/
2069: SET email_address = SUBSTRB(p_email_address,1,320),
2070: last_update_date = hz_utility_v2pub.last_update_date,
2071: last_updated_by = hz_utility_v2pub.last_updated_by,
2072: last_update_login = hz_utility_v2pub.last_update_login,
2073: request_id = hz_utility_v2pub.request_id,
2074: program_application_id = hz_utility_v2pub.program_application_id,

Line 2071: last_updated_by = hz_utility_v2pub.last_updated_by,

2067: UPDATE hz_parties
2068: /* Bug No : 4355133*/
2069: SET email_address = SUBSTRB(p_email_address,1,320),
2070: last_update_date = hz_utility_v2pub.last_update_date,
2071: last_updated_by = hz_utility_v2pub.last_updated_by,
2072: last_update_login = hz_utility_v2pub.last_update_login,
2073: request_id = hz_utility_v2pub.request_id,
2074: program_application_id = hz_utility_v2pub.program_application_id,
2075: program_id = hz_utility_v2pub.program_id,

Line 2072: last_update_login = hz_utility_v2pub.last_update_login,

2068: /* Bug No : 4355133*/
2069: SET email_address = SUBSTRB(p_email_address,1,320),
2070: last_update_date = hz_utility_v2pub.last_update_date,
2071: last_updated_by = hz_utility_v2pub.last_updated_by,
2072: last_update_login = hz_utility_v2pub.last_update_login,
2073: request_id = hz_utility_v2pub.request_id,
2074: program_application_id = hz_utility_v2pub.program_application_id,
2075: program_id = hz_utility_v2pub.program_id,
2076: program_update_date = sysdate

Line 2073: request_id = hz_utility_v2pub.request_id,

2069: SET email_address = SUBSTRB(p_email_address,1,320),
2070: last_update_date = hz_utility_v2pub.last_update_date,
2071: last_updated_by = hz_utility_v2pub.last_updated_by,
2072: last_update_login = hz_utility_v2pub.last_update_login,
2073: request_id = hz_utility_v2pub.request_id,
2074: program_application_id = hz_utility_v2pub.program_application_id,
2075: program_id = hz_utility_v2pub.program_id,
2076: program_update_date = sysdate
2077: WHERE party_id = p_party_id;

Line 2074: program_application_id = hz_utility_v2pub.program_application_id,

2070: last_update_date = hz_utility_v2pub.last_update_date,
2071: last_updated_by = hz_utility_v2pub.last_updated_by,
2072: last_update_login = hz_utility_v2pub.last_update_login,
2073: request_id = hz_utility_v2pub.request_id,
2074: program_application_id = hz_utility_v2pub.program_application_id,
2075: program_id = hz_utility_v2pub.program_id,
2076: program_update_date = sysdate
2077: WHERE party_id = p_party_id;
2078: ELSIF p_contact_point_type = 'PHONE' THEN

Line 2075: program_id = hz_utility_v2pub.program_id,

2071: last_updated_by = hz_utility_v2pub.last_updated_by,
2072: last_update_login = hz_utility_v2pub.last_update_login,
2073: request_id = hz_utility_v2pub.request_id,
2074: program_application_id = hz_utility_v2pub.program_application_id,
2075: program_id = hz_utility_v2pub.program_id,
2076: program_update_date = sysdate
2077: WHERE party_id = p_party_id;
2078: ELSIF p_contact_point_type = 'PHONE' THEN
2079: UPDATE hz_parties

Line 2087: last_update_date = hz_utility_v2pub.last_update_date,

2083: primary_phone_country_code = p_phone_country_code,
2084: primary_phone_area_code = p_phone_area_code,
2085: primary_phone_number = p_phone_number,
2086: primary_phone_extension = p_phone_extension,
2087: last_update_date = hz_utility_v2pub.last_update_date,
2088: last_updated_by = hz_utility_v2pub.last_updated_by,
2089: last_update_login = hz_utility_v2pub.last_update_login,
2090: request_id = hz_utility_v2pub.request_id,
2091: program_application_id = hz_utility_v2pub.program_application_id,

Line 2088: last_updated_by = hz_utility_v2pub.last_updated_by,

2084: primary_phone_area_code = p_phone_area_code,
2085: primary_phone_number = p_phone_number,
2086: primary_phone_extension = p_phone_extension,
2087: last_update_date = hz_utility_v2pub.last_update_date,
2088: last_updated_by = hz_utility_v2pub.last_updated_by,
2089: last_update_login = hz_utility_v2pub.last_update_login,
2090: request_id = hz_utility_v2pub.request_id,
2091: program_application_id = hz_utility_v2pub.program_application_id,
2092: program_id = hz_utility_v2pub.program_id,

Line 2089: last_update_login = hz_utility_v2pub.last_update_login,

2085: primary_phone_number = p_phone_number,
2086: primary_phone_extension = p_phone_extension,
2087: last_update_date = hz_utility_v2pub.last_update_date,
2088: last_updated_by = hz_utility_v2pub.last_updated_by,
2089: last_update_login = hz_utility_v2pub.last_update_login,
2090: request_id = hz_utility_v2pub.request_id,
2091: program_application_id = hz_utility_v2pub.program_application_id,
2092: program_id = hz_utility_v2pub.program_id,
2093: program_update_date = sysdate

Line 2090: request_id = hz_utility_v2pub.request_id,

2086: primary_phone_extension = p_phone_extension,
2087: last_update_date = hz_utility_v2pub.last_update_date,
2088: last_updated_by = hz_utility_v2pub.last_updated_by,
2089: last_update_login = hz_utility_v2pub.last_update_login,
2090: request_id = hz_utility_v2pub.request_id,
2091: program_application_id = hz_utility_v2pub.program_application_id,
2092: program_id = hz_utility_v2pub.program_id,
2093: program_update_date = sysdate
2094: WHERE party_id = p_party_id;

Line 2091: program_application_id = hz_utility_v2pub.program_application_id,

2087: last_update_date = hz_utility_v2pub.last_update_date,
2088: last_updated_by = hz_utility_v2pub.last_updated_by,
2089: last_update_login = hz_utility_v2pub.last_update_login,
2090: request_id = hz_utility_v2pub.request_id,
2091: program_application_id = hz_utility_v2pub.program_application_id,
2092: program_id = hz_utility_v2pub.program_id,
2093: program_update_date = sysdate
2094: WHERE party_id = p_party_id;
2095: END IF;

Line 2092: program_id = hz_utility_v2pub.program_id,

2088: last_updated_by = hz_utility_v2pub.last_updated_by,
2089: last_update_login = hz_utility_v2pub.last_update_login,
2090: request_id = hz_utility_v2pub.request_id,
2091: program_application_id = hz_utility_v2pub.program_application_id,
2092: program_id = hz_utility_v2pub.program_id,
2093: program_update_date = sysdate
2094: WHERE party_id = p_party_id;
2095: END IF;
2096:

Line 2099: hz_utility_v2pub.debug(p_message=>'do_denormalize_contact_point (-)',

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

Line 2168: hz_utility_v2pub.debug(p_message=>'do_unset_primary_by_purpose (+)',

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

Line 2183: last_update_date = hz_utility_v2pub.last_update_date,

2179:
2180:
2181: UPDATE hz_contact_points
2182: SET primary_by_purpose = 'N',
2183: last_update_date = hz_utility_v2pub.last_update_date,
2184: last_updated_by = hz_utility_v2pub.last_updated_by,
2185: last_update_login = hz_utility_v2pub.last_update_login,
2186: request_id = hz_utility_v2pub.request_id,
2187: program_id = hz_utility_v2pub.program_id,

Line 2184: last_updated_by = hz_utility_v2pub.last_updated_by,

2180:
2181: UPDATE hz_contact_points
2182: SET primary_by_purpose = 'N',
2183: last_update_date = hz_utility_v2pub.last_update_date,
2184: last_updated_by = hz_utility_v2pub.last_updated_by,
2185: last_update_login = hz_utility_v2pub.last_update_login,
2186: request_id = hz_utility_v2pub.request_id,
2187: program_id = hz_utility_v2pub.program_id,
2188: program_application_id = hz_utility_v2pub.program_application_id,

Line 2185: last_update_login = hz_utility_v2pub.last_update_login,

2181: UPDATE hz_contact_points
2182: SET primary_by_purpose = 'N',
2183: last_update_date = hz_utility_v2pub.last_update_date,
2184: last_updated_by = hz_utility_v2pub.last_updated_by,
2185: last_update_login = hz_utility_v2pub.last_update_login,
2186: request_id = hz_utility_v2pub.request_id,
2187: program_id = hz_utility_v2pub.program_id,
2188: program_application_id = hz_utility_v2pub.program_application_id,
2189: program_update_date = hz_utility_v2pub.program_update_date

Line 2186: request_id = hz_utility_v2pub.request_id,

2182: SET primary_by_purpose = 'N',
2183: last_update_date = hz_utility_v2pub.last_update_date,
2184: last_updated_by = hz_utility_v2pub.last_updated_by,
2185: last_update_login = hz_utility_v2pub.last_update_login,
2186: request_id = hz_utility_v2pub.request_id,
2187: program_id = hz_utility_v2pub.program_id,
2188: program_application_id = hz_utility_v2pub.program_application_id,
2189: program_update_date = hz_utility_v2pub.program_update_date
2190: WHERE owner_table_name = p_owner_table_name

Line 2187: program_id = hz_utility_v2pub.program_id,

2183: last_update_date = hz_utility_v2pub.last_update_date,
2184: last_updated_by = hz_utility_v2pub.last_updated_by,
2185: last_update_login = hz_utility_v2pub.last_update_login,
2186: request_id = hz_utility_v2pub.request_id,
2187: program_id = hz_utility_v2pub.program_id,
2188: program_application_id = hz_utility_v2pub.program_application_id,
2189: program_update_date = hz_utility_v2pub.program_update_date
2190: WHERE owner_table_name = p_owner_table_name
2191: AND owner_table_id = p_owner_table_id

Line 2188: program_application_id = hz_utility_v2pub.program_application_id,

2184: last_updated_by = hz_utility_v2pub.last_updated_by,
2185: last_update_login = hz_utility_v2pub.last_update_login,
2186: request_id = hz_utility_v2pub.request_id,
2187: program_id = hz_utility_v2pub.program_id,
2188: program_application_id = hz_utility_v2pub.program_application_id,
2189: program_update_date = hz_utility_v2pub.program_update_date
2190: WHERE owner_table_name = p_owner_table_name
2191: AND owner_table_id = p_owner_table_id
2192: AND contact_point_type = p_contact_point_type

Line 2189: program_update_date = hz_utility_v2pub.program_update_date

2185: last_update_login = hz_utility_v2pub.last_update_login,
2186: request_id = hz_utility_v2pub.request_id,
2187: program_id = hz_utility_v2pub.program_id,
2188: program_application_id = hz_utility_v2pub.program_application_id,
2189: program_update_date = hz_utility_v2pub.program_update_date
2190: WHERE owner_table_name = p_owner_table_name
2191: AND owner_table_id = p_owner_table_id
2192: AND contact_point_type = p_contact_point_type
2193: AND contact_point_purpose = p_contact_point_purpose

Line 2206: (HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

2202: --Direct Update is missing Business event call, added event call.
2203:
2204: I := 1;
2205: IF l_contactpointidtab.COUNT > 0 AND
2206: (HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2207: LOOP
2208:
2209: l_contact_point_rec.contact_point_id := l_contactpointidtab(i);
2210:

Line 2213: hz_utility_v2pub.debug(p_message=>'Raising Business Event for Contact Point Id : '||l_contact_point_rec.contact_point_id,

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

Line 2243: hz_utility_v2pub.debug(p_message=>'do_unset_primary_by_purpose (-)',

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

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

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

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

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

Line 2366: hz_utility_v2pub.debug(p_message=>'get_phone_format (+)',

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

Line 2436: hz_utility_v2pub.debug(p_message=>'get_phone_format (-)',

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

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

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

Line 2522: hz_utility_v2pub.debug(p_message=>'translate_raw_phone_number (-)',

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

Line 2592: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (+)',

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

Line 2618: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Select_Row (+)',

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

Line 2690: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Select_Row (-)',

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

Line 2704: hz_utility_v2pub.debug(p_message=>'get_contact_point_main (-)',

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;
2708: END get_contact_point_main;

Line 2785: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (+)',

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

Line 2892: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

2888: IF x_return_status = fnd_api.g_ret_sts_success /*AND
2889: -- Bug 2197181: Added below condition for Mix-n-Match
2890: g_cpt_is_datasource_selected = 'Y'*/
2891: THEN
2892: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2893: hz_business_event_v2pvt.create_contact_point_event(
2894: l_contact_point_rec,
2895: l_edi_rec,
2896: l_eft_rec,

Line 2903: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

2899: l_telex_rec,
2900: l_web_rec);
2901: END IF;
2902:
2903: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2904: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
2905: p_operation => 'I',
2906: p_contact_point_id => x_contact_point_id);
2907: END IF;

Line 2928: hz_utility_v2pub.debug(p_message=>'create_contact_point_main (-)',

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;
2932: END create_contact_point_main;

Line 3028: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (+)',

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

Line 3223: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

3219: -- Bug 2197181: Added below condition for Mix-n-Match
3220: g_cpt_is_datasource_selected = 'Y'*/
3221: THEN
3222: l_old_contact_point_rec.orig_system := p_contact_point_rec.orig_system;
3223: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3224: hz_business_event_v2pvt.update_contact_point_event (
3225: l_contact_point_rec,
3226: l_old_contact_point_rec,
3227: l_edi_rec,

Line 3241: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

3237: l_web_rec,
3238: l_old_web_rec);
3239: END IF;
3240:
3241: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3242: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
3243: p_operation => 'U',
3244: p_contact_point_id => l_contact_point_rec.contact_point_id);
3245: END IF;

Line 3259: hz_utility_v2pub.debug(p_message=>'update_contact_point_main (-)',

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;
3263: END update_contact_point_main;

Line 3334: hz_utility_v2pub.debug(p_message=>'create_contact_point (+)',

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

Line 3356: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 3362: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',

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

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

Line 3387: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',

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

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

Line 3412: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',

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

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

Line 3440: hz_utility_v2pub.debug(p_message=>'create_contact_point (-)',

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

Line 3505: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',

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

Line 3523: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 3529: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',

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

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

Line 3554: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',

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

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

Line 3578: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',

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

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

Line 3606: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',

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

Line 3671: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',

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

Line 3689: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 3695: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',

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

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

Line 3720: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',

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

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

Line 3744: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',

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

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

Line 3772: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',

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

Line 3839: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',

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

Line 3857: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 3863: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',

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

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

Line 3889: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',

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

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

Line 3913: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',

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

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

Line 3941: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',

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

Line 4006: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',

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

Line 4025: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 4031: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',

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

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

Line 4056: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',

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

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

Line 4080: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',

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

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

Line 4108: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',

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

Line 4173: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',

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

Line 4191: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 4197: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',

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

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

Line 4223: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',

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

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

Line 4247: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',

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

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

Line 4275: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',

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

Line 4340: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',

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

Line 4359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 4365: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',

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

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

Line 4390: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',

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

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

Line 4414: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',

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

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

Line 4442: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',

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

Line 4516: hz_utility_v2pub.debug(p_message=>'update_contact_point (+)',

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

Line 4536: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4532: x_msg_count => x_msg_count,
4533: x_msg_data => x_msg_data
4534: );
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,

Line 4540: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 4546: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',

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

Line 4557: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4553:
4554: EXCEPTION
4555: WHEN fnd_api.g_exc_error THEN
4556: ROLLBACK TO update_contact_point;
4557: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4558: x_return_status := fnd_api.g_ret_sts_error;
4559:
4560: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4561: p_count => x_msg_count,

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

Line 4572: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',

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

Line 4582: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4578: --disable_debug;
4579:
4580: WHEN fnd_api.g_exc_unexpected_error THEN
4581: ROLLBACK TO update_contact_point;
4582: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4583: x_return_status := fnd_api.g_ret_sts_unexp_error;
4584:
4585: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4586: p_count => x_msg_count,

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

Line 4597: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',

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

Line 4607: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4603: --disable_debug;
4604:
4605: WHEN OTHERS THEN
4606: ROLLBACK TO update_contact_point;
4607: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4608: x_return_status := fnd_api.g_ret_sts_unexp_error;
4609:
4610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4611: fnd_message.set_token('ERROR' ,SQLERRM);

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

Line 4626: hz_utility_v2pub.debug(p_message=>'update_contact_point (-)',

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

Line 4690: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',

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

Line 4708: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 4714: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',

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

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

Line 4739: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',

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

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

Line 4763: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',

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

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

Line 4791: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',

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

Line 4855: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',

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

Line 4871: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4867: x_msg_count => x_msg_count,
4868: x_msg_data => x_msg_data
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,

Line 4874: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 4880: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',

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

Line 4891: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4887:
4888: EXCEPTION
4889: WHEN fnd_api.g_exc_error THEN
4890: ROLLBACK TO update_web_contact_point;
4891: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4892: x_return_status := fnd_api.g_ret_sts_error;
4893:
4894: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4895: p_count => x_msg_count,

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

Line 4906: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',

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

Line 4916: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4912: --disable_debug;
4913:
4914: WHEN fnd_api.g_exc_unexpected_error THEN
4915: ROLLBACK TO update_web_contact_point;
4916: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4917: x_return_status := fnd_api.g_ret_sts_unexp_error;
4918:
4919: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4920: p_count => x_msg_count,

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

Line 4931: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',

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

Line 4942: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4938: --disable_debug;
4939:
4940: WHEN OTHERS THEN
4941: ROLLBACK TO update_web_contact_point;
4942: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4943: x_return_status := fnd_api.g_ret_sts_unexp_error;
4944:
4945: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4946: fnd_message.set_token('ERROR' ,SQLERRM);

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

Line 4961: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',

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

Line 5027: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',

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

Line 5046: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 5052: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',

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

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

Line 5077: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',

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

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

Line 5101: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',

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

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

Line 5129: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',

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

Line 5194: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',

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

Line 5210: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5206: x_msg_count => x_msg_count,
5207: x_msg_data => x_msg_data
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,

Line 5213: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 5219: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',

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

Line 5230: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5226:
5227: EXCEPTION
5228: WHEN fnd_api.g_exc_error THEN
5229: ROLLBACK TO update_phone_contact_point;
5230: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5231: x_return_status := fnd_api.g_ret_sts_error;
5232:
5233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5234: p_count => x_msg_count,

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

Line 5245: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',

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

Line 5255: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5251: --disable_debug;
5252:
5253: WHEN fnd_api.g_exc_unexpected_error THEN
5254: ROLLBACK TO update_phone_contact_point;
5255: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5256: x_return_status := fnd_api.g_ret_sts_unexp_error;
5257:
5258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5259: p_count => x_msg_count,

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

Line 5270: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',

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

Line 5280: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5276: --disable_debug;
5277:
5278: WHEN OTHERS THEN
5279: ROLLBACK TO update_phone_contact_point;
5280: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5281: x_return_status := fnd_api.g_ret_sts_unexp_error;
5282:
5283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5284: fnd_message.set_token('ERROR' ,SQLERRM);

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

Line 5299: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',

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

Line 5363: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',

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

Line 5379: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5375: x_msg_count => x_msg_count,
5376: x_msg_data => x_msg_data
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,

Line 5382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 5388: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',

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

Line 5400: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5396:
5397: EXCEPTION
5398: WHEN fnd_api.g_exc_error THEN
5399: ROLLBACK TO update_telex_contact_point;
5400: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5401: x_return_status := fnd_api.g_ret_sts_error;
5402:
5403: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5404: p_count => x_msg_count,

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

Line 5415: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',

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

Line 5427: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5423: --disable_debug;
5424:
5425: WHEN fnd_api.g_exc_unexpected_error THEN
5426: ROLLBACK TO update_telex_contact_point;
5427: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5428: x_return_status := fnd_api.g_ret_sts_unexp_error;
5429:
5430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5431: p_count => x_msg_count,

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

Line 5442: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',

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

Line 5452: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5448: --disable_debug;
5449:
5450: WHEN OTHERS THEN
5451: ROLLBACK TO update_telex_contact_point;
5452: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5453: x_return_status := fnd_api.g_ret_sts_unexp_error;
5454:
5455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5456: fnd_message.set_token('ERROR' ,SQLERRM);

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

Line 5471: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',

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

Line 5535: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',

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

Line 5551: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5547: x_msg_count => x_msg_count,
5548: x_msg_data => x_msg_data
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,

Line 5554: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 5560: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',

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

Line 5571: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5567:
5568: EXCEPTION
5569: WHEN fnd_api.g_exc_error THEN
5570: ROLLBACK TO update_email_contact_point;
5571: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5572: x_return_status := fnd_api.g_ret_sts_error;
5573:
5574: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5575: p_count => x_msg_count,

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

Line 5586: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',

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

Line 5596: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5592: --disable_debug;
5593:
5594: WHEN fnd_api.g_exc_unexpected_error THEN
5595: ROLLBACK TO update_email_contact_point;
5596: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5597: x_return_status := fnd_api.g_ret_sts_unexp_error;
5598:
5599: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5600: p_count => x_msg_count,

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

Line 5611: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',

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

Line 5621: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5617: --disable_debug;
5618:
5619: WHEN OTHERS THEN
5620: ROLLBACK TO update_email_contact_point;
5621: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5622: x_return_status := fnd_api.g_ret_sts_unexp_error;
5623:
5624: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5625: fnd_message.set_token('ERROR' ,SQLERRM);

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

Line 5640: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',

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

Line 5726: hz_utility_v2pub.debug(p_message=>'phone_format (+)',

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 6035: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (+)',

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

Line 6058: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 6064: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',

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

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

Line 6088: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',

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

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

Line 6111: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',

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

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

Line 6138: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (-)',

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

Line 6201: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (+)',

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

Line 6224: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 6230: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',

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

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

Line 6254: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',

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

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

Line 6277: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',

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

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

Line 6304: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (-)',

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

Line 6367: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (+)',

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

Line 6391: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 6397: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',

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

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

Line 6421: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',

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

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

Line 6444: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',

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

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

Line 6471: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (-)',

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

Line 6535: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (+)',

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

Line 6558: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 6564: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',

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

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

Line 6588: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',

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

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

Line 6611: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',

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

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

Line 6639: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (-)',

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

Line 6702: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (+)',

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

Line 6725: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 6731: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',

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

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

Line 6755: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',

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

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

Line 6778: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',

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

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

Line 6805: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (-)',

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

Line 6868: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (+)',

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

Line 6891: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 6897: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',

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

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

Line 6921: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',

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

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

Line 6944: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',

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

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

Line 6971: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (-)',

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

Line 7034: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (+)',

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

Line 7058: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 7064: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',

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

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

Line 7088: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',

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

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

Line 7111: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',

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

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

Line 7138: hz_utility_v2pub.debug(p_message=>'get_email_contact_point (-)',

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