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 348: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (+)',

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

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

457: -- it will be set by phone_number and phone_area_code.
458:
459: -- Debug info.
460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug(p_message=>'contact_point_type = ' || p_contact_point_rec.contact_point_type,
462: p_prefix =>l_debug_prefix,
463: p_msg_level=>fnd_log.level_statement);
464: END IF;
465:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1696: end if;
1697:
1698: -- Debug info.
1699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',
1701: p_prefix=>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_procedure);
1703: END IF;
1704:

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

1702: p_msg_level=>fnd_log.level_procedure);
1703: END IF;
1704:
1705: -- Bug 4693719 : pass NULL if the secure data is not updated
1706: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN
1707: l_acs := nvl(p_contact_point_rec.actual_content_source, 'USER_ENTERED');
1708: ELSE
1709: l_acs := NULL;
1710: END IF;

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

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

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

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

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

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

Line 1867: last_update_date = hz_utility_v2pub.last_update_date,

1863:
1864: UPDATE hz_contact_points
1865: SET primary_flag = 'N',
1866: --Bug number 2914238 .Updated the who columns.
1867: last_update_date = hz_utility_v2pub.last_update_date,
1868: last_updated_by = hz_utility_v2pub.last_updated_by,
1869: last_update_login = hz_utility_v2pub.last_update_login,
1870: request_id = hz_utility_v2pub.request_id,
1871: program_id = hz_utility_v2pub.program_id,

Line 1868: last_updated_by = hz_utility_v2pub.last_updated_by,

1864: UPDATE hz_contact_points
1865: SET primary_flag = 'N',
1866: --Bug number 2914238 .Updated the who columns.
1867: last_update_date = hz_utility_v2pub.last_update_date,
1868: last_updated_by = hz_utility_v2pub.last_updated_by,
1869: last_update_login = hz_utility_v2pub.last_update_login,
1870: request_id = hz_utility_v2pub.request_id,
1871: program_id = hz_utility_v2pub.program_id,
1872: program_application_id = hz_utility_v2pub.program_application_id,

Line 1869: last_update_login = hz_utility_v2pub.last_update_login,

1865: SET primary_flag = 'N',
1866: --Bug number 2914238 .Updated the who columns.
1867: last_update_date = hz_utility_v2pub.last_update_date,
1868: last_updated_by = hz_utility_v2pub.last_updated_by,
1869: last_update_login = hz_utility_v2pub.last_update_login,
1870: request_id = hz_utility_v2pub.request_id,
1871: program_id = hz_utility_v2pub.program_id,
1872: program_application_id = hz_utility_v2pub.program_application_id,
1873: program_update_date = hz_utility_v2pub.program_update_date

Line 1870: request_id = hz_utility_v2pub.request_id,

1866: --Bug number 2914238 .Updated the who columns.
1867: last_update_date = hz_utility_v2pub.last_update_date,
1868: last_updated_by = hz_utility_v2pub.last_updated_by,
1869: last_update_login = hz_utility_v2pub.last_update_login,
1870: request_id = hz_utility_v2pub.request_id,
1871: program_id = hz_utility_v2pub.program_id,
1872: program_application_id = hz_utility_v2pub.program_application_id,
1873: program_update_date = hz_utility_v2pub.program_update_date
1874: WHERE owner_table_name = p_owner_table_name

Line 1871: program_id = hz_utility_v2pub.program_id,

1867: last_update_date = hz_utility_v2pub.last_update_date,
1868: last_updated_by = hz_utility_v2pub.last_updated_by,
1869: last_update_login = hz_utility_v2pub.last_update_login,
1870: request_id = hz_utility_v2pub.request_id,
1871: program_id = hz_utility_v2pub.program_id,
1872: program_application_id = hz_utility_v2pub.program_application_id,
1873: program_update_date = hz_utility_v2pub.program_update_date
1874: WHERE owner_table_name = p_owner_table_name
1875: AND owner_table_id = p_owner_table_id

Line 1872: program_application_id = hz_utility_v2pub.program_application_id,

1868: last_updated_by = hz_utility_v2pub.last_updated_by,
1869: last_update_login = hz_utility_v2pub.last_update_login,
1870: request_id = hz_utility_v2pub.request_id,
1871: program_id = hz_utility_v2pub.program_id,
1872: program_application_id = hz_utility_v2pub.program_application_id,
1873: program_update_date = hz_utility_v2pub.program_update_date
1874: WHERE owner_table_name = p_owner_table_name
1875: AND owner_table_id = p_owner_table_id
1876: AND contact_point_type = p_contact_point_type

Line 1873: program_update_date = hz_utility_v2pub.program_update_date

1869: last_update_login = hz_utility_v2pub.last_update_login,
1870: request_id = hz_utility_v2pub.request_id,
1871: program_id = hz_utility_v2pub.program_id,
1872: program_application_id = hz_utility_v2pub.program_application_id,
1873: program_update_date = hz_utility_v2pub.program_update_date
1874: WHERE owner_table_name = p_owner_table_name
1875: AND owner_table_id = p_owner_table_id
1876: AND contact_point_type = p_contact_point_type
1877: AND contact_point_id <> l_contact_point_id

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

1878: -- AND content_source_type = hz_party_v2pub.g_miss_content_source_type
1879: AND primary_flag = 'Y';
1880:
1881: --bug #5203798
1882: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1883: -- populate function for integration service
1884: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
1885: p_operation => p_mode,
1886: p_contact_point_id => l_unset_prim_contact_point_id);

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

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

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

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

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

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

Line 1971: last_update_date = hz_utility_v2pub.last_update_date,

1967:
1968: IF p_contact_point_type = 'WEB' THEN
1969: UPDATE hz_parties
1970: SET url = p_url,
1971: last_update_date = hz_utility_v2pub.last_update_date,
1972: last_updated_by = hz_utility_v2pub.last_updated_by,
1973: last_update_login = hz_utility_v2pub.last_update_login,
1974: request_id = hz_utility_v2pub.request_id,
1975: program_application_id = hz_utility_v2pub.program_application_id,

Line 1972: last_updated_by = hz_utility_v2pub.last_updated_by,

1968: IF p_contact_point_type = 'WEB' THEN
1969: UPDATE hz_parties
1970: SET url = p_url,
1971: last_update_date = hz_utility_v2pub.last_update_date,
1972: last_updated_by = hz_utility_v2pub.last_updated_by,
1973: last_update_login = hz_utility_v2pub.last_update_login,
1974: request_id = hz_utility_v2pub.request_id,
1975: program_application_id = hz_utility_v2pub.program_application_id,
1976: program_id = hz_utility_v2pub.program_id,

Line 1973: last_update_login = hz_utility_v2pub.last_update_login,

1969: UPDATE hz_parties
1970: SET url = p_url,
1971: last_update_date = hz_utility_v2pub.last_update_date,
1972: last_updated_by = hz_utility_v2pub.last_updated_by,
1973: last_update_login = hz_utility_v2pub.last_update_login,
1974: request_id = hz_utility_v2pub.request_id,
1975: program_application_id = hz_utility_v2pub.program_application_id,
1976: program_id = hz_utility_v2pub.program_id,
1977: program_update_date = sysdate

Line 1974: request_id = hz_utility_v2pub.request_id,

1970: SET url = p_url,
1971: last_update_date = hz_utility_v2pub.last_update_date,
1972: last_updated_by = hz_utility_v2pub.last_updated_by,
1973: last_update_login = hz_utility_v2pub.last_update_login,
1974: request_id = hz_utility_v2pub.request_id,
1975: program_application_id = hz_utility_v2pub.program_application_id,
1976: program_id = hz_utility_v2pub.program_id,
1977: program_update_date = sysdate
1978: WHERE party_id = p_party_id;

Line 1975: program_application_id = hz_utility_v2pub.program_application_id,

1971: last_update_date = hz_utility_v2pub.last_update_date,
1972: last_updated_by = hz_utility_v2pub.last_updated_by,
1973: last_update_login = hz_utility_v2pub.last_update_login,
1974: request_id = hz_utility_v2pub.request_id,
1975: program_application_id = hz_utility_v2pub.program_application_id,
1976: program_id = hz_utility_v2pub.program_id,
1977: program_update_date = sysdate
1978: WHERE party_id = p_party_id;
1979: ELSIF p_contact_point_type = 'EMAIL' THEN

Line 1976: program_id = hz_utility_v2pub.program_id,

1972: last_updated_by = hz_utility_v2pub.last_updated_by,
1973: last_update_login = hz_utility_v2pub.last_update_login,
1974: request_id = hz_utility_v2pub.request_id,
1975: program_application_id = hz_utility_v2pub.program_application_id,
1976: program_id = hz_utility_v2pub.program_id,
1977: program_update_date = sysdate
1978: WHERE party_id = p_party_id;
1979: ELSIF p_contact_point_type = 'EMAIL' THEN
1980: UPDATE hz_parties

Line 1983: last_update_date = hz_utility_v2pub.last_update_date,

1979: ELSIF p_contact_point_type = 'EMAIL' THEN
1980: UPDATE hz_parties
1981: /* Bug No : 4355133*/
1982: SET email_address = SUBSTRB(p_email_address,1,320),
1983: last_update_date = hz_utility_v2pub.last_update_date,
1984: last_updated_by = hz_utility_v2pub.last_updated_by,
1985: last_update_login = hz_utility_v2pub.last_update_login,
1986: request_id = hz_utility_v2pub.request_id,
1987: program_application_id = hz_utility_v2pub.program_application_id,

Line 1984: last_updated_by = hz_utility_v2pub.last_updated_by,

1980: UPDATE hz_parties
1981: /* Bug No : 4355133*/
1982: SET email_address = SUBSTRB(p_email_address,1,320),
1983: last_update_date = hz_utility_v2pub.last_update_date,
1984: last_updated_by = hz_utility_v2pub.last_updated_by,
1985: last_update_login = hz_utility_v2pub.last_update_login,
1986: request_id = hz_utility_v2pub.request_id,
1987: program_application_id = hz_utility_v2pub.program_application_id,
1988: program_id = hz_utility_v2pub.program_id,

Line 1985: last_update_login = hz_utility_v2pub.last_update_login,

1981: /* Bug No : 4355133*/
1982: SET email_address = SUBSTRB(p_email_address,1,320),
1983: last_update_date = hz_utility_v2pub.last_update_date,
1984: last_updated_by = hz_utility_v2pub.last_updated_by,
1985: last_update_login = hz_utility_v2pub.last_update_login,
1986: request_id = hz_utility_v2pub.request_id,
1987: program_application_id = hz_utility_v2pub.program_application_id,
1988: program_id = hz_utility_v2pub.program_id,
1989: program_update_date = sysdate

Line 1986: request_id = hz_utility_v2pub.request_id,

1982: SET email_address = SUBSTRB(p_email_address,1,320),
1983: last_update_date = hz_utility_v2pub.last_update_date,
1984: last_updated_by = hz_utility_v2pub.last_updated_by,
1985: last_update_login = hz_utility_v2pub.last_update_login,
1986: request_id = hz_utility_v2pub.request_id,
1987: program_application_id = hz_utility_v2pub.program_application_id,
1988: program_id = hz_utility_v2pub.program_id,
1989: program_update_date = sysdate
1990: WHERE party_id = p_party_id;

Line 1987: program_application_id = hz_utility_v2pub.program_application_id,

1983: last_update_date = hz_utility_v2pub.last_update_date,
1984: last_updated_by = hz_utility_v2pub.last_updated_by,
1985: last_update_login = hz_utility_v2pub.last_update_login,
1986: request_id = hz_utility_v2pub.request_id,
1987: program_application_id = hz_utility_v2pub.program_application_id,
1988: program_id = hz_utility_v2pub.program_id,
1989: program_update_date = sysdate
1990: WHERE party_id = p_party_id;
1991: ELSIF p_contact_point_type = 'PHONE' THEN

Line 1988: program_id = hz_utility_v2pub.program_id,

1984: last_updated_by = hz_utility_v2pub.last_updated_by,
1985: last_update_login = hz_utility_v2pub.last_update_login,
1986: request_id = hz_utility_v2pub.request_id,
1987: program_application_id = hz_utility_v2pub.program_application_id,
1988: program_id = hz_utility_v2pub.program_id,
1989: program_update_date = sysdate
1990: WHERE party_id = p_party_id;
1991: ELSIF p_contact_point_type = 'PHONE' THEN
1992: UPDATE hz_parties

Line 2000: last_update_date = hz_utility_v2pub.last_update_date,

1996: primary_phone_country_code = p_phone_country_code,
1997: primary_phone_area_code = p_phone_area_code,
1998: primary_phone_number = p_phone_number,
1999: primary_phone_extension = p_phone_extension,
2000: last_update_date = hz_utility_v2pub.last_update_date,
2001: last_updated_by = hz_utility_v2pub.last_updated_by,
2002: last_update_login = hz_utility_v2pub.last_update_login,
2003: request_id = hz_utility_v2pub.request_id,
2004: program_application_id = hz_utility_v2pub.program_application_id,

Line 2001: last_updated_by = hz_utility_v2pub.last_updated_by,

1997: primary_phone_area_code = p_phone_area_code,
1998: primary_phone_number = p_phone_number,
1999: primary_phone_extension = p_phone_extension,
2000: last_update_date = hz_utility_v2pub.last_update_date,
2001: last_updated_by = hz_utility_v2pub.last_updated_by,
2002: last_update_login = hz_utility_v2pub.last_update_login,
2003: request_id = hz_utility_v2pub.request_id,
2004: program_application_id = hz_utility_v2pub.program_application_id,
2005: program_id = hz_utility_v2pub.program_id,

Line 2002: last_update_login = hz_utility_v2pub.last_update_login,

1998: primary_phone_number = p_phone_number,
1999: primary_phone_extension = p_phone_extension,
2000: last_update_date = hz_utility_v2pub.last_update_date,
2001: last_updated_by = hz_utility_v2pub.last_updated_by,
2002: last_update_login = hz_utility_v2pub.last_update_login,
2003: request_id = hz_utility_v2pub.request_id,
2004: program_application_id = hz_utility_v2pub.program_application_id,
2005: program_id = hz_utility_v2pub.program_id,
2006: program_update_date = sysdate

Line 2003: request_id = hz_utility_v2pub.request_id,

1999: primary_phone_extension = p_phone_extension,
2000: last_update_date = hz_utility_v2pub.last_update_date,
2001: last_updated_by = hz_utility_v2pub.last_updated_by,
2002: last_update_login = hz_utility_v2pub.last_update_login,
2003: request_id = hz_utility_v2pub.request_id,
2004: program_application_id = hz_utility_v2pub.program_application_id,
2005: program_id = hz_utility_v2pub.program_id,
2006: program_update_date = sysdate
2007: WHERE party_id = p_party_id;

Line 2004: program_application_id = hz_utility_v2pub.program_application_id,

2000: last_update_date = hz_utility_v2pub.last_update_date,
2001: last_updated_by = hz_utility_v2pub.last_updated_by,
2002: last_update_login = hz_utility_v2pub.last_update_login,
2003: request_id = hz_utility_v2pub.request_id,
2004: program_application_id = hz_utility_v2pub.program_application_id,
2005: program_id = hz_utility_v2pub.program_id,
2006: program_update_date = sysdate
2007: WHERE party_id = p_party_id;
2008: END IF;

Line 2005: program_id = hz_utility_v2pub.program_id,

2001: last_updated_by = hz_utility_v2pub.last_updated_by,
2002: last_update_login = hz_utility_v2pub.last_update_login,
2003: request_id = hz_utility_v2pub.request_id,
2004: program_application_id = hz_utility_v2pub.program_application_id,
2005: program_id = hz_utility_v2pub.program_id,
2006: program_update_date = sysdate
2007: WHERE party_id = p_party_id;
2008: END IF;
2009:

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

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

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

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

Line 2073: last_update_date = hz_utility_v2pub.last_update_date,

2069: END IF;
2070:
2071: UPDATE hz_contact_points
2072: SET primary_by_purpose = 'N',
2073: last_update_date = hz_utility_v2pub.last_update_date,
2074: last_updated_by = hz_utility_v2pub.last_updated_by,
2075: last_update_login = hz_utility_v2pub.last_update_login,
2076: request_id = hz_utility_v2pub.request_id,
2077: program_id = hz_utility_v2pub.program_id,

Line 2074: last_updated_by = hz_utility_v2pub.last_updated_by,

2070:
2071: UPDATE hz_contact_points
2072: SET primary_by_purpose = 'N',
2073: last_update_date = hz_utility_v2pub.last_update_date,
2074: last_updated_by = hz_utility_v2pub.last_updated_by,
2075: last_update_login = hz_utility_v2pub.last_update_login,
2076: request_id = hz_utility_v2pub.request_id,
2077: program_id = hz_utility_v2pub.program_id,
2078: program_application_id = hz_utility_v2pub.program_application_id,

Line 2075: last_update_login = hz_utility_v2pub.last_update_login,

2071: UPDATE hz_contact_points
2072: SET primary_by_purpose = 'N',
2073: last_update_date = hz_utility_v2pub.last_update_date,
2074: last_updated_by = hz_utility_v2pub.last_updated_by,
2075: last_update_login = hz_utility_v2pub.last_update_login,
2076: request_id = hz_utility_v2pub.request_id,
2077: program_id = hz_utility_v2pub.program_id,
2078: program_application_id = hz_utility_v2pub.program_application_id,
2079: program_update_date = hz_utility_v2pub.program_update_date

Line 2076: request_id = hz_utility_v2pub.request_id,

2072: SET primary_by_purpose = 'N',
2073: last_update_date = hz_utility_v2pub.last_update_date,
2074: last_updated_by = hz_utility_v2pub.last_updated_by,
2075: last_update_login = hz_utility_v2pub.last_update_login,
2076: request_id = hz_utility_v2pub.request_id,
2077: program_id = hz_utility_v2pub.program_id,
2078: program_application_id = hz_utility_v2pub.program_application_id,
2079: program_update_date = hz_utility_v2pub.program_update_date
2080: WHERE owner_table_name = p_owner_table_name

Line 2077: program_id = hz_utility_v2pub.program_id,

2073: last_update_date = hz_utility_v2pub.last_update_date,
2074: last_updated_by = hz_utility_v2pub.last_updated_by,
2075: last_update_login = hz_utility_v2pub.last_update_login,
2076: request_id = hz_utility_v2pub.request_id,
2077: program_id = hz_utility_v2pub.program_id,
2078: program_application_id = hz_utility_v2pub.program_application_id,
2079: program_update_date = hz_utility_v2pub.program_update_date
2080: WHERE owner_table_name = p_owner_table_name
2081: AND owner_table_id = p_owner_table_id

Line 2078: program_application_id = hz_utility_v2pub.program_application_id,

2074: last_updated_by = hz_utility_v2pub.last_updated_by,
2075: last_update_login = hz_utility_v2pub.last_update_login,
2076: request_id = hz_utility_v2pub.request_id,
2077: program_id = hz_utility_v2pub.program_id,
2078: program_application_id = hz_utility_v2pub.program_application_id,
2079: program_update_date = hz_utility_v2pub.program_update_date
2080: WHERE owner_table_name = p_owner_table_name
2081: AND owner_table_id = p_owner_table_id
2082: AND contact_point_type = p_contact_point_type

Line 2079: program_update_date = hz_utility_v2pub.program_update_date

2075: last_update_login = hz_utility_v2pub.last_update_login,
2076: request_id = hz_utility_v2pub.request_id,
2077: program_id = hz_utility_v2pub.program_id,
2078: program_application_id = hz_utility_v2pub.program_application_id,
2079: program_update_date = hz_utility_v2pub.program_update_date
2080: WHERE owner_table_name = p_owner_table_name
2081: AND owner_table_id = p_owner_table_id
2082: AND contact_point_type = p_contact_point_type
2083: AND contact_point_purpose = p_contact_point_purpose

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2735: IF x_return_status = fnd_api.g_ret_sts_success /*AND
2736: -- Bug 2197181: Added below condition for Mix-n-Match
2737: g_cpt_is_datasource_selected = 'Y'*/
2738: THEN
2739: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2740: hz_business_event_v2pvt.create_contact_point_event(
2741: l_contact_point_rec,
2742: l_edi_rec,
2743: l_eft_rec,

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

2746: l_telex_rec,
2747: l_web_rec);
2748: END IF;
2749:
2750: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2751: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
2752: p_operation => 'I',
2753: p_contact_point_id => x_contact_point_id);
2754: END IF;

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

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

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

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

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

3063: -- Bug 2197181: Added below condition for Mix-n-Match
3064: g_cpt_is_datasource_selected = 'Y'*/
3065: THEN
3066: l_old_contact_point_rec.orig_system := p_contact_point_rec.orig_system;
3067: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3068: hz_business_event_v2pvt.update_contact_point_event (
3069: l_contact_point_rec,
3070: l_old_contact_point_rec,
3071: l_edi_rec,

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

3081: l_web_rec,
3082: l_old_web_rec);
3083: END IF;
3084:
3085: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3086: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
3087: p_operation => 'U',
3088: p_contact_point_id => l_contact_point_rec.contact_point_id);
3089: END IF;

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

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

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

3174: --enable_debug;
3175:
3176: -- Debug info.
3177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3178: hz_utility_v2pub.debug(p_message=>'create_contact_point (+)',
3179: p_prefix=>l_debug_prefix,
3180: p_msg_level=>fnd_log.level_procedure);
3181: END IF;
3182:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3345: --enable_debug;
3346:
3347: -- Debug info.
3348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3349: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
3350: p_prefix=>l_debug_prefix,
3351: p_msg_level=>fnd_log.level_procedure);
3352: END IF;
3353:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3511: --enable_debug;
3512:
3513: -- Debug info.
3514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3515: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
3516: p_prefix=>l_debug_prefix,
3517: p_msg_level=>fnd_log.level_procedure);
3518: END IF;
3519:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3679: --enable_debug;
3680:
3681: -- Debug info.
3682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3683: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
3684: p_prefix=>l_debug_prefix,
3685: p_msg_level=>fnd_log.level_procedure);
3686: END IF;
3687:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3846: --enable_debug;
3847:
3848: -- Debug info.
3849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3850: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
3851: p_prefix=>l_debug_prefix,
3852: p_msg_level=>fnd_log.level_procedure);
3853: END IF;
3854:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4013: --enable_debug;
4014:
4015: -- Debug info.
4016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4017: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
4018: p_prefix=>l_debug_prefix,
4019: p_msg_level=>fnd_log.level_procedure);
4020: END IF;
4021:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4180: --enable_debug;
4181:
4182: -- Debug info.
4183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4184: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
4185: p_prefix=>l_debug_prefix,
4186: p_msg_level=>fnd_log.level_procedure);
4187: END IF;
4188:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4356: --enable_debug;
4357:
4358: -- Debug info.
4359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4360: hz_utility_v2pub.debug(p_message=>'update_contact_point (+)',
4361: p_prefix=>l_debug_prefix,
4362: p_msg_level=>fnd_log.level_procedure);
4363: END IF;
4364:

Line 4380: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4376: x_msg_count => x_msg_count,
4377: x_msg_data => x_msg_data
4378: );
4379:
4380: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4381:
4382: -- Debug info.
4383: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4384: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

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

Line 4401: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4397:
4398: EXCEPTION
4399: WHEN fnd_api.g_exc_error THEN
4400: ROLLBACK TO update_contact_point;
4401: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4402: x_return_status := fnd_api.g_ret_sts_error;
4403:
4404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4405: p_count => x_msg_count,

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

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

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

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

Line 4426: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4422: --disable_debug;
4423:
4424: WHEN fnd_api.g_exc_unexpected_error THEN
4425: ROLLBACK TO update_contact_point;
4426: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4427: x_return_status := fnd_api.g_ret_sts_unexp_error;
4428:
4429: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4430: p_count => x_msg_count,

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

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

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

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

Line 4451: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4447: --disable_debug;
4448:
4449: WHEN OTHERS THEN
4450: ROLLBACK TO update_contact_point;
4451: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4452: x_return_status := fnd_api.g_ret_sts_unexp_error;
4453:
4454: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4455: fnd_message.set_token('ERROR' ,SQLERRM);

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

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

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

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

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

4530: --enable_debug;
4531:
4532: -- Debug info.
4533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4534: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
4535: p_prefix=>l_debug_prefix,
4536: p_msg_level=>fnd_log.level_procedure);
4537: END IF;
4538:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4695: --enable_debug;
4696:
4697: -- Debug info.
4698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4699: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
4700: p_prefix=>l_debug_prefix,
4701: p_msg_level=>fnd_log.level_procedure);
4702: END IF;
4703:

Line 4715: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

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

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

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

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

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

Line 4735: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4731:
4732: EXCEPTION
4733: WHEN fnd_api.g_exc_error THEN
4734: ROLLBACK TO update_web_contact_point;
4735: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4736: x_return_status := fnd_api.g_ret_sts_error;
4737:
4738: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4739: p_count => x_msg_count,

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

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

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

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

Line 4760: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4756: --disable_debug;
4757:
4758: WHEN fnd_api.g_exc_unexpected_error THEN
4759: ROLLBACK TO update_web_contact_point;
4760: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4761: x_return_status := fnd_api.g_ret_sts_unexp_error;
4762:
4763: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4764: p_count => x_msg_count,

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

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

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

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

Line 4786: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

4782: --disable_debug;
4783:
4784: WHEN OTHERS THEN
4785: ROLLBACK TO update_web_contact_point;
4786: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4787: x_return_status := fnd_api.g_ret_sts_unexp_error;
4788:
4789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4790: fnd_message.set_token('ERROR' ,SQLERRM);

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

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

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

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

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

4867: --enable_debug;
4868:
4869: -- Debug info.
4870: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4871: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
4872: p_prefix=>l_debug_prefix,
4873: p_msg_level=>fnd_log.level_procedure);
4874: END IF;
4875:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5034: --enable_debug;
5035:
5036: -- Debug info.
5037: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5038: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
5039: p_prefix=>l_debug_prefix,
5040: p_msg_level=>fnd_log.level_procedure);
5041: END IF;
5042:

Line 5054: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

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

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

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

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

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

Line 5074: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5070:
5071: EXCEPTION
5072: WHEN fnd_api.g_exc_error THEN
5073: ROLLBACK TO update_phone_contact_point;
5074: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5075: x_return_status := fnd_api.g_ret_sts_error;
5076:
5077: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5078: p_count => x_msg_count,

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

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

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

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

Line 5099: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5095: --disable_debug;
5096:
5097: WHEN fnd_api.g_exc_unexpected_error THEN
5098: ROLLBACK TO update_phone_contact_point;
5099: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5100: x_return_status := fnd_api.g_ret_sts_unexp_error;
5101:
5102: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5103: p_count => x_msg_count,

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

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

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

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

Line 5124: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5120: --disable_debug;
5121:
5122: WHEN OTHERS THEN
5123: ROLLBACK TO update_phone_contact_point;
5124: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5125: x_return_status := fnd_api.g_ret_sts_unexp_error;
5126:
5127: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5128: fnd_message.set_token('ERROR' ,SQLERRM);

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

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

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

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

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

5203: --enable_debug;
5204:
5205: -- Debug info.
5206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5207: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
5208: p_prefix=>l_debug_prefix,
5209: p_msg_level=>fnd_log.level_procedure);
5210: END IF;
5211:

Line 5223: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

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

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

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

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

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

Line 5244: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5240:
5241: EXCEPTION
5242: WHEN fnd_api.g_exc_error THEN
5243: ROLLBACK TO update_telex_contact_point;
5244: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5245: x_return_status := fnd_api.g_ret_sts_error;
5246:
5247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5248: p_count => x_msg_count,

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

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

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

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

Line 5271: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5267: --disable_debug;
5268:
5269: WHEN fnd_api.g_exc_unexpected_error THEN
5270: ROLLBACK TO update_telex_contact_point;
5271: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5272: x_return_status := fnd_api.g_ret_sts_unexp_error;
5273:
5274: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5275: p_count => x_msg_count,

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

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

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

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

Line 5296: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5292: --disable_debug;
5293:
5294: WHEN OTHERS THEN
5295: ROLLBACK TO update_telex_contact_point;
5296: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5297: x_return_status := fnd_api.g_ret_sts_unexp_error;
5298:
5299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5300: fnd_message.set_token('ERROR' ,SQLERRM);

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

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

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

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

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

5375: --enable_debug;
5376:
5377: -- Debug info.
5378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5379: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
5380: p_prefix=>l_debug_prefix,
5381: p_msg_level=>fnd_log.level_procedure);
5382: END IF;
5383:

Line 5395: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

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

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

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

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

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

Line 5415: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5411:
5412: EXCEPTION
5413: WHEN fnd_api.g_exc_error THEN
5414: ROLLBACK TO update_email_contact_point;
5415: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5416: x_return_status := fnd_api.g_ret_sts_error;
5417:
5418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5419: p_count => x_msg_count,

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

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

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

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

Line 5440: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5436: --disable_debug;
5437:
5438: WHEN fnd_api.g_exc_unexpected_error THEN
5439: ROLLBACK TO update_email_contact_point;
5440: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5441: x_return_status := fnd_api.g_ret_sts_unexp_error;
5442:
5443: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5444: p_count => x_msg_count,

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

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

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

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

Line 5465: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

5461: --disable_debug;
5462:
5463: WHEN OTHERS THEN
5464: ROLLBACK TO update_email_contact_point;
5465: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5466: x_return_status := fnd_api.g_ret_sts_unexp_error;
5467:
5468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5469: fnd_message.set_token('ERROR' ,SQLERRM);

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

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

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

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

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

5566: --enable_debug;
5567:
5568: -- Debug info.
5569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5570: hz_utility_v2pub.debug(p_message=>'phone_format (+)',
5571: p_prefix=>l_debug_prefix,
5572: p_msg_level=>fnd_log.level_procedure);
5573: END IF;
5574:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5875: --enable_debug;
5876:
5877: -- Debug info.
5878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5879: hz_utility_v2pub.debug(p_message=>'get_contact_point_rec (+)',
5880: p_prefix=>l_debug_prefix,
5881: p_msg_level=>fnd_log.level_procedure);
5882: END IF;
5883:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6041: --enable_debug;
6042:
6043: -- Debug info.
6044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6045: hz_utility_v2pub.debug(p_message=>'get_edi_contact_point (+)',
6046: p_prefix=>l_debug_prefix,
6047: p_msg_level=>fnd_log.level_procedure);
6048: END IF;
6049:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6207: --enable_debug;
6208:
6209: -- Debug info.
6210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6211: hz_utility_v2pub.debug(p_message=>'get_eft_contact_point (+)',
6212: p_prefix=>l_debug_prefix,
6213: p_msg_level=>fnd_log.level_procedure);
6214: END IF;
6215:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6375: --enable_debug;
6376:
6377: -- Debug info.
6378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6379: hz_utility_v2pub.debug(p_message=>'get_web_contact_point (+)',
6380: p_prefix=>l_debug_prefix,
6381: p_msg_level=>fnd_log.level_procedure);
6382: END IF;
6383:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6542: --enable_debug;
6543:
6544: -- Debug info.
6545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6546: hz_utility_v2pub.debug(p_message=>'get_phone_contact_point (+)',
6547: p_prefix=>l_debug_prefix,
6548: p_msg_level=>fnd_log.level_procedure);
6549: END IF;
6550:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6708: --enable_debug;
6709:
6710: -- Debug info.
6711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6712: hz_utility_v2pub.debug(p_message=>'get_telex_contact_point (+)',
6713: p_prefix=>l_debug_prefix,
6714: p_msg_level=>fnd_log.level_procedure);
6715: END IF;
6716:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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