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_CONTACT_POINTS

Line 254: -- hz_contact_points_pkg.insert_row

250: -- hz_registry_validate_v2pub.validate_web_contact_point
251: -- hz_registry_validate_v2pub.validate_phone_contact_point
252: -- hz_registry_validate_v2pub.validate_telex_contact_point
253: -- hz_registry_validate_v2pub.validate_email_contact_point
254: -- hz_contact_points_pkg.insert_row
255: -- hz_phone_number_pkg.transpose
256: --
257: -- ARGUMENTS
258: -- IN/OUT:

Line 308: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

304: l_msg_data VARCHAR2(2000);
305:
306: l_formatted_phone_number VARCHAR2(100);
307: l_country_code hz_locations.country%TYPE;
308: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
309:
310: l_edi_rec edi_rec_type;
311: l_email_rec email_rec_type;
312: l_phone_rec phone_rec_type;

Line 346: FROM hz_contact_points

342: CURSOR c_cp (p_owner_table_name IN VARCHAR2,
343: p_owner_table_id IN NUMBER,
344: p_contact_point_type IN VARCHAR2) IS
345: SELECT 'Y'
346: FROM hz_contact_points
347: WHERE owner_table_name = p_owner_table_name
348: AND owner_table_id = p_owner_table_id
349: AND contact_point_type = p_contact_point_type
350: /* AND HZ_MIXNM_UTILITY.isDataSourceSelected (

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

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

Line 730: hz_contact_points_pkg.insert_row (

726: p_msg_level=>fnd_log.level_procedure);
727: END IF;
728:
729: -- Call table-handler.
730: hz_contact_points_pkg.insert_row (
731: x_contact_point_id => p_contact_point_rec.contact_point_id,
732: x_contact_point_type => p_contact_point_rec.contact_point_type,
733: x_status => p_contact_point_rec.status,
734: x_owner_table_name => p_contact_point_rec.owner_table_name,

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

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

Line 893: l_orig_sys_reference_rec.owner_table_name := 'HZ_CONTACT_POINTS';

889: and p_contact_point_rec.orig_system <>fnd_api.g_miss_char
890: then
891: l_orig_sys_reference_rec.orig_system := p_contact_point_rec.orig_system;
892: l_orig_sys_reference_rec.orig_system_reference := p_contact_point_rec.orig_system_reference;
893: l_orig_sys_reference_rec.owner_table_name := 'HZ_CONTACT_POINTS';
894: l_orig_sys_reference_rec.owner_table_id := p_contact_point_rec.contact_point_id;
895: l_orig_sys_reference_rec.created_by_module := p_contact_point_rec.created_by_module;
896:
897: hz_orig_system_ref_pub.create_orig_system_reference(

Line 932: -- hz_contact_points_pkg.update_row

928: -- hz_registry_validate_v2pub.validate_web_contact_point
929: -- hz_registry_validate_v2pub.validate_phone_contact_point
930: -- hz_registry_validate_v2pub.validate_telex_contact_point
931: -- hz_registry_validate_v2pub.validate_email_contact_point
932: -- hz_contact_points_pkg.update_row
933: -- hz_phone_number_pkg.transpose
934: --
935: -- ARGUMENTS
936: -- IN/OUT:

Line 995: l_owner_table_name hz_contact_points.owner_table_name%TYPE;

991: l_msg_data VARCHAR2(2000);
992:
993: l_formatted_phone_number VARCHAR2(100);
994: l_country_code hz_locations.country%TYPE;
995: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
996: l_owner_table_id NUMBER;
997: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
998: p_contact_point_rec.contact_point_type;
999: l_primary_flag hz_contact_points.primary_flag%TYPE;

Line 997: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=

993: l_formatted_phone_number VARCHAR2(100);
994: l_country_code hz_locations.country%TYPE;
995: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
996: l_owner_table_id NUMBER;
997: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
998: p_contact_point_rec.contact_point_type;
999: l_primary_flag hz_contact_points.primary_flag%TYPE;
1000: l_status hz_contact_points.status%TYPE;
1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;

Line 999: l_primary_flag hz_contact_points.primary_flag%TYPE;

995: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
996: l_owner_table_id NUMBER;
997: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
998: p_contact_point_rec.contact_point_type;
999: l_primary_flag hz_contact_points.primary_flag%TYPE;
1000: l_status hz_contact_points.status%TYPE;
1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1002: l_phone_number hz_contact_points.phone_number%TYPE;
1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;

Line 1000: l_status hz_contact_points.status%TYPE;

996: l_owner_table_id NUMBER;
997: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
998: p_contact_point_rec.contact_point_type;
999: l_primary_flag hz_contact_points.primary_flag%TYPE;
1000: l_status hz_contact_points.status%TYPE;
1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1002: l_phone_number hz_contact_points.phone_number%TYPE;
1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1004: l_url hz_contact_points.url%TYPE;

Line 1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;

997: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
998: p_contact_point_rec.contact_point_type;
999: l_primary_flag hz_contact_points.primary_flag%TYPE;
1000: l_status hz_contact_points.status%TYPE;
1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1002: l_phone_number hz_contact_points.phone_number%TYPE;
1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1004: l_url hz_contact_points.url%TYPE;
1005: l_email_address hz_contact_points.email_address%TYPE;

Line 1002: l_phone_number hz_contact_points.phone_number%TYPE;

998: p_contact_point_rec.contact_point_type;
999: l_primary_flag hz_contact_points.primary_flag%TYPE;
1000: l_status hz_contact_points.status%TYPE;
1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1002: l_phone_number hz_contact_points.phone_number%TYPE;
1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1004: l_url hz_contact_points.url%TYPE;
1005: l_email_address hz_contact_points.email_address%TYPE;
1006: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;

Line 1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;

999: l_primary_flag hz_contact_points.primary_flag%TYPE;
1000: l_status hz_contact_points.status%TYPE;
1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1002: l_phone_number hz_contact_points.phone_number%TYPE;
1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1004: l_url hz_contact_points.url%TYPE;
1005: l_email_address hz_contact_points.email_address%TYPE;
1006: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1007: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;

Line 1004: l_url hz_contact_points.url%TYPE;

1000: l_status hz_contact_points.status%TYPE;
1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1002: l_phone_number hz_contact_points.phone_number%TYPE;
1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1004: l_url hz_contact_points.url%TYPE;
1005: l_email_address hz_contact_points.email_address%TYPE;
1006: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1007: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1008: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

Line 1005: l_email_address hz_contact_points.email_address%TYPE;

1001: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1002: l_phone_number hz_contact_points.phone_number%TYPE;
1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1004: l_url hz_contact_points.url%TYPE;
1005: l_email_address hz_contact_points.email_address%TYPE;
1006: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1007: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1008: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
1009:

Line 1006: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;

1002: l_phone_number hz_contact_points.phone_number%TYPE;
1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1004: l_url hz_contact_points.url%TYPE;
1005: l_email_address hz_contact_points.email_address%TYPE;
1006: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1007: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1008: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
1009:
1010: --BugNo:1695595.Added local variables to hold denormalized column values----

Line 1007: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;

1003: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1004: l_url hz_contact_points.url%TYPE;
1005: l_email_address hz_contact_points.email_address%TYPE;
1006: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1007: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1008: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
1009:
1010: --BugNo:1695595.Added local variables to hold denormalized column values----
1011: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

Line 1008: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

1004: l_url hz_contact_points.url%TYPE;
1005: l_email_address hz_contact_points.email_address%TYPE;
1006: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1007: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1008: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
1009:
1010: --BugNo:1695595.Added local variables to hold denormalized column values----
1011: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
1012: l_phone_line_type hz_contact_points.phone_line_type%TYPE;

Line 1011: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

1007: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1008: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
1009:
1010: --BugNo:1695595.Added local variables to hold denormalized column values----
1011: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
1012: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1013: l_phone_extension hz_contact_points.phone_extension%TYPE;
1014: -----------------------------------------------------------------
1015: l_edi_rec edi_rec_type;

Line 1012: l_phone_line_type hz_contact_points.phone_line_type%TYPE;

1008: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
1009:
1010: --BugNo:1695595.Added local variables to hold denormalized column values----
1011: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
1012: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1013: l_phone_extension hz_contact_points.phone_extension%TYPE;
1014: -----------------------------------------------------------------
1015: l_edi_rec edi_rec_type;
1016: l_eft_rec eft_rec_type;

Line 1013: l_phone_extension hz_contact_points.phone_extension%TYPE;

1009:
1010: --BugNo:1695595.Added local variables to hold denormalized column values----
1011: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
1012: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1013: l_phone_extension hz_contact_points.phone_extension%TYPE;
1014: -----------------------------------------------------------------
1015: l_edi_rec edi_rec_type;
1016: l_eft_rec eft_rec_type;
1017: l_email_rec email_rec_type;

Line 1023: db_actual_content_source hz_contact_points.actual_content_source%TYPE;

1019: l_telex_rec telex_rec_type;
1020: l_web_rec web_rec_type;
1021:
1022: -- Bug 2197181: added for mix-n-match project.
1023: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1024: -- Bug 4693719 : Added for local assignment
1025: l_acs hz_contact_points.actual_content_source%TYPE;
1026:
1027: -- Bug 2117973: defined the following cursors for PL/SQL coding standards

Line 1025: l_acs hz_contact_points.actual_content_source%TYPE;

1021:
1022: -- Bug 2197181: added for mix-n-match project.
1023: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1024: -- Bug 4693719 : Added for local assignment
1025: l_acs hz_contact_points.actual_content_source%TYPE;
1026:
1027: -- Bug 2117973: defined the following cursors for PL/SQL coding standards
1028: -- compliance.
1029: CURSOR c_country (p_owner_table_id IN NUMBER) IS

Line 1051: FROM hz_contact_points

1047: p_owner_table_id IN NUMBER,
1048: p_contact_point_type IN VARCHAR2
1049: ) IS
1050: SELECT 'Y'
1051: FROM hz_contact_points
1052: WHERE owner_table_name = p_owner_table_name
1053: AND owner_table_id = p_owner_table_id
1054: AND contact_point_type = p_contact_point_type
1055: AND contact_point_id <> p_contact_point_rec.contact_point_id

Line 1072: FROM hz_contact_points

1068: p_contact_point_id IN NUMBER
1069: ) IS
1070: SELECT rowid, url, email_address,contact_point_id,contact_point_purpose,
1071: phone_line_type,phone_area_code,phone_country_code,phone_number,phone_extension
1072: FROM hz_contact_points
1073: WHERE contact_point_id = (
1074: SELECT MIN(contact_point_id)
1075: FROM hz_contact_points
1076: WHERE owner_table_name = p_owner_table_name

Line 1075: FROM hz_contact_points

1071: phone_line_type,phone_area_code,phone_country_code,phone_number,phone_extension
1072: FROM hz_contact_points
1073: WHERE contact_point_id = (
1074: SELECT MIN(contact_point_id)
1075: FROM hz_contact_points
1076: WHERE owner_table_name = p_owner_table_name
1077: AND owner_table_id = p_owner_table_id
1078: AND contact_point_type = p_contact_point_type
1079: /* AND HZ_MIXNM_UTILITY.isDataSourceSelected (

Line 1112: FROM hz_contact_points

1108: l_contact_point_type,l_phone_line_type,
1109: l_phone_country_code, l_phone_area_code, l_phone_number,l_phone_extension,
1110: l_primary_flag, l_status, l_contact_point_purpose,
1111: l_url, l_email_address, l_primary_by_purpose, db_actual_content_source
1112: FROM hz_contact_points
1113: WHERE contact_point_id = p_contact_point_rec.contact_point_id
1114: FOR UPDATE NOWAIT;
1115:
1116: IF NOT ((p_object_version_number IS NULL AND

Line 1123: fnd_message.set_token('TABLE', 'hz_contact_points');

1119: l_object_version_number IS NOT NULL AND
1120: p_object_version_number = l_object_version_number))
1121: THEN
1122: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1123: fnd_message.set_token('TABLE', 'hz_contact_points');
1124: fnd_msg_pub.add;
1125: RAISE fnd_api.g_exc_error;
1126: END IF;
1127:

Line 1620: UPDATE hz_contact_points

1616: l_phone_extension
1617: );
1618: END IF;
1619: ELSE
1620: UPDATE hz_contact_points
1621: SET primary_flag = 'Y'
1622: WHERE rowid = l_contact_point_rowid;
1623:
1624: -- De-normalize primary contact point to HZ_PARTIES.

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

1714: end if;
1715:
1716: -- Debug info.
1717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1718: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',
1719: p_prefix=>l_debug_prefix,
1720: p_msg_level=>fnd_log.level_procedure);
1721: END IF;
1722:

Line 1730: hz_contact_points_pkg.update_row (

1726: ELSE
1727: l_acs := NULL;
1728: END IF;
1729: -- Call table-handler.
1730: hz_contact_points_pkg.update_row (
1731: x_rowid => l_rowid,
1732: x_contact_point_id => p_contact_point_rec.contact_point_id,
1733: x_contact_point_type => p_contact_point_rec.contact_point_type,
1734: x_status => p_contact_point_rec.status,

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

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

Line 1849: FROM hz_contact_points CP

1845: /*
1846: --bug #5203798
1847: CURSOR c_contact_point IS
1848: SELECT contact_point_id
1849: FROM hz_contact_points CP
1850: WHERE CP.owner_table_name = p_owner_table_name
1851: AND CP.owner_table_id = p_owner_table_id
1852: AND CP.contact_point_type = p_contact_point_type
1853: AND CP.contact_point_id <> p_contact_point_id

Line 1879: TYPE contactpointidtab IS TABLE OF hz_contact_points.contact_point_id%TYPE;

1875: l_old_telex_rec telex_rec_type;
1876: l_old_web_rec web_rec_type;
1877: l_old_eft_rec eft_rec_type;
1878:
1879: TYPE contactpointidtab IS TABLE OF hz_contact_points.contact_point_id%TYPE;
1880: l_contactpointidtab contactpointidtab;
1881: I NUMBER;
1882:
1883: BEGIN

Line 1905: UPDATE hz_contact_points

1901: ELSE
1902: l_contact_point_id := p_contact_point_id;
1903: END IF;
1904:
1905: UPDATE hz_contact_points
1906: SET primary_flag = 'N',
1907: --Bug number 2914238 .Updated the who columns.
1908: last_update_date = hz_utility_v2pub.last_update_date,
1909: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 1961: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(

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

Line 2161: TYPE contactpointidtab IS TABLE OF hz_contact_points.contact_point_id%TYPE;

2157: l_old_telex_rec telex_rec_type;
2158: l_old_web_rec web_rec_type;
2159: l_old_eft_rec eft_rec_type;
2160:
2161: TYPE contactpointidtab IS TABLE OF hz_contact_points.contact_point_id%TYPE;
2162: l_contactpointidtab contactpointidtab;
2163: I NUMBER;
2164: BEGIN
2165:

Line 2181: UPDATE hz_contact_points

2177: l_contact_point_id := p_contact_point_id;
2178: END IF;
2179:
2180:
2181: UPDATE hz_contact_points
2182: SET primary_by_purpose = 'N',
2183: last_update_date = hz_utility_v2pub.last_update_date,
2184: last_updated_by = hz_utility_v2pub.last_updated_by,
2185: last_update_login = hz_utility_v2pub.last_update_login,

Line 2536: -- hz_contact_points_PKG.Select_Row

2532: -- DESCRIPTION
2533: -- Cets contact point record.
2534: --
2535: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2536: -- hz_contact_points_PKG.Select_Row
2537: --
2538: -- ARGUMENTS
2539: -- IN:
2540: -- p_init_msg_list Initialize message stack if it is set to

Line 2585: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

2581: x_msg_count OUT NOCOPY NUMBER,
2582: x_msg_data OUT NOCOPY VARCHAR2
2583: ) IS
2584:
2585: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
2586: l_contact_point_rec hz_contact_points%ROWTYPE;
2587: l_debug_prefix VARCHAR2(30) := '';
2588: BEGIN
2589: -- Debug info.

Line 2586: l_contact_point_rec hz_contact_points%ROWTYPE;

2582: x_msg_data OUT NOCOPY VARCHAR2
2583: ) IS
2584:
2585: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
2586: l_contact_point_rec hz_contact_points%ROWTYPE;
2587: l_debug_prefix VARCHAR2(30) := '';
2588: BEGIN
2589: -- Debug info.
2590:

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

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

Line 2624: hz_contact_points_pkg.select_row (

2620: p_msg_level=>fnd_log.level_procedure);
2621: END IF;
2622:
2623: -- Call table-handler
2624: hz_contact_points_pkg.select_row (
2625: x_contact_point_id => x_contact_point_rec.contact_point_id,
2626: x_contact_point_type => x_contact_point_rec.contact_point_type,
2627: x_status => x_contact_point_rec.status,
2628: x_owner_table_name => x_contact_point_rec.owner_table_name,

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

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

Line 2813: p_entity_name => 'HZ_CONTACT_POINTS',

2809: /*
2810: * SSM SST Integration and Extension
2811: * For non-profile entities, the concept of select/de-select data sources is obsoleted.
2812: HZ_MIXNM_UTILITY.LoadDataSources(
2813: p_entity_name => 'HZ_CONTACT_POINTS',
2814: p_entity_attr_id => g_cpt_entity_attr_id,
2815: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
2816: p_selected_datasources => g_cpt_selected_datasources );
2817: -- END IF;

Line 2820: p_entity_name => 'HZ_CONTACT_POINTS',

2816: p_selected_datasources => g_cpt_selected_datasources );
2817: -- END IF;
2818: */
2819: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
2820: p_entity_name => 'HZ_CONTACT_POINTS',
2821: p_entity_attr_id => g_cpt_entity_attr_id,
2822: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
2823: p_selected_datasources => g_cpt_selected_datasources,
2824: p_content_source_type => l_contact_point_rec.content_source_type,

Line 2854: p_db_object_name => 'HZ_CONTACT_POINTS',

2850: THEN
2851: l_test_security :=
2852: hz_dss_util_pub.test_instance(
2853: p_operation_code => 'INSERT',
2854: p_db_object_name => 'HZ_CONTACT_POINTS',
2855: p_instance_pk1_value => x_contact_point_id,
2856: p_user_name => fnd_global.user_name,
2857: x_return_status => dss_return_status,
2858: x_msg_count => dss_msg_count,

Line 2904: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(

2900: l_web_rec);
2901: END IF;
2902:
2903: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2904: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
2905: p_operation => 'I',
2906: p_contact_point_id => x_contact_point_id);
2907: END IF;
2908: -- Call to indicate contact point creation to DQM

Line 3008: l_phone_country_code HZ_CONTACT_POINTS.phone_country_code%type;

3004: l_old_phone_rec phone_rec_type;
3005: l_old_telex_rec telex_rec_type;
3006: l_old_web_rec web_rec_type;
3007: l_old_eft_rec eft_rec_type;
3008: l_phone_country_code HZ_CONTACT_POINTS.phone_country_code%type;
3009: l_phone_area_code HZ_CONTACT_POINTS.phone_area_code%type;
3010:
3011: l_data_source_from VARCHAR2(30);
3012:

Line 3009: l_phone_area_code HZ_CONTACT_POINTS.phone_area_code%type;

3005: l_old_telex_rec telex_rec_type;
3006: l_old_web_rec web_rec_type;
3007: l_old_eft_rec eft_rec_type;
3008: l_phone_country_code HZ_CONTACT_POINTS.phone_country_code%type;
3009: l_phone_area_code HZ_CONTACT_POINTS.phone_area_code%type;
3010:
3011: l_data_source_from VARCHAR2(30);
3012:
3013: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3052: p_owner_table_name => 'HZ_CONTACT_POINTS',

3048: and (p_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or p_contact_point_rec.contact_point_id is null) THEN
3049: hz_orig_system_ref_pub.get_owner_table_id
3050: (p_orig_system => p_contact_point_rec.orig_system,
3051: p_orig_system_reference => p_contact_point_rec.orig_system_reference,
3052: p_owner_table_name => 'HZ_CONTACT_POINTS',
3053: x_owner_table_id => l_contact_point_rec.contact_point_id,
3054: x_return_status => x_return_status);
3055: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3056: RAISE FND_API.G_EXC_ERROR;

Line 3091: p_db_object_name => 'HZ_CONTACT_POINTS',

3087: THEN
3088: l_test_security :=
3089: hz_dss_util_pub.test_instance(
3090: p_operation_code => 'UPDATE',
3091: p_db_object_name => 'HZ_CONTACT_POINTS',
3092: p_instance_pk1_value => l_contact_point_rec.contact_point_id,
3093: p_user_name => fnd_global.user_name,
3094: x_return_status => dss_return_status,
3095: x_msg_count => dss_msg_count,

Line 3130: p_entity_name => 'HZ_CONTACT_POINTS',

3126: * There is no need to check if the data-source is selected.
3127:
3128: -- IF g_cpt_mixnmatch_enabled IS NULL THEN
3129: HZ_MIXNM_UTILITY.LoadDataSources(
3130: p_entity_name => 'HZ_CONTACT_POINTS',
3131: p_entity_attr_id => g_cpt_entity_attr_id,
3132: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
3133: p_selected_datasources => g_cpt_selected_datasources );
3134: -- END IF;

Line 3242: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(

3238: l_old_web_rec);
3239: END IF;
3240:
3241: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3242: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
3243: p_operation => 'U',
3244: p_contact_point_id => l_contact_point_rec.contact_point_id);
3245: END IF;
3246: -- Call to indicate contact point update to DQM

Line 7229: l_owner_table_name HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;

7225: SELECT party_type
7226: FROM HZ_PARTIES
7227: WHERE party_id=p_party_id;
7228:
7229: l_owner_table_name HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
7230: l_contact_point_type HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
7231: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
7232: l_siteidtab siteidtab;
7233: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

Line 7230: l_contact_point_type HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;

7226: FROM HZ_PARTIES
7227: WHERE party_id=p_party_id;
7228:
7229: l_owner_table_name HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
7230: l_contact_point_type HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
7231: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
7232: l_siteidtab siteidtab;
7233: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
7234: BEGIN