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_PARTY_SITES

Line 322: FROM hz_party_sites

318: CURSOR c_country (p_site_id IN NUMBER) IS
319: SELECT country
320: FROM hz_locations
321: WHERE location_id = (SELECT location_id
322: FROM hz_party_sites
323: WHERE party_site_id = p_site_id);
324:
325: -- Bug 2197181: added for mix-n-match project: the contact point
326: -- must be visible.

Line 467: --was passed in else get it from hz_locations for owner_table_name HZ_PARTY_SITES

463: p_msg_level=>fnd_log.level_statement);
464: END IF;
465:
466: --To get territory code to pass to phone_format, first check if country code
467: --was passed in else get it from hz_locations for owner_table_name HZ_PARTY_SITES
468:
469: IF p_contact_point_rec.contact_point_type = 'PHONE' THEN
470: IF l_phone_rec.raw_phone_number IS NOT NULL AND
471: l_phone_rec.raw_phone_number <> fnd_api.g_miss_char

Line 485: ELSIF p_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' AND

481: EXCEPTION
482: WHEN NO_DATA_FOUND THEN
483: NULL;
484: END;
485: ELSIF p_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' AND
486: (l_phone_rec.phone_country_code IS NULL OR
487: l_phone_rec.phone_country_code = fnd_api.g_miss_char)
488: THEN
489: -- Bug 2117973: modified to conform to Applications PL/SQL standards.

Line 1020: FROM hz_party_sites

1016: CURSOR c_country (p_owner_table_id IN NUMBER) IS
1017: SELECT country
1018: FROM hz_locations
1019: WHERE location_id = (SELECT location_id
1020: FROM hz_party_sites
1021: WHERE party_site_id = p_owner_table_id);
1022:
1023: -- Bug 2197181: added for mix-n-match project: the contact point
1024: -- must be visible.

Line 1284: ELSIF l_owner_table_name = 'HZ_PARTY_SITES' AND

1280: EXCEPTION
1281: WHEN NO_DATA_FOUND THEN
1282: NULL;
1283: END;
1284: ELSIF l_owner_table_name = 'HZ_PARTY_SITES' AND
1285: l_phone_country_code IS NULL THEN
1286: OPEN c_country (l_owner_table_id);
1287: FETCH c_country INTO l_country_code;
1288:

Line 2696: l_contact_point_rec.owner_table_name IN ('HZ_PARTIES', 'HZ_PARTY_SITES')

2692: -- Bug 3818648: check dss profile before call test_instance
2693: -- Bug 3867562: check dss only in party context
2694:
2695: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
2696: l_contact_point_rec.owner_table_name IN ('HZ_PARTIES', 'HZ_PARTY_SITES')
2697: THEN
2698: l_test_security :=
2699: hz_dss_util_pub.test_instance(
2700: p_operation_code => 'INSERT',

Line 2720: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN

2716: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
2717: IF l_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2718: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2719: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2720: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2721: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2722: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2723: END IF;
2724: FND_MSG_PUB.ADD;

Line 2930: l_old_contact_point_rec.owner_table_name IN ('HZ_PARTIES', 'HZ_PARTY_SITES')

2926: -- Bug 3818648: check dss profile before call test_instance
2927: -- Bug 3867562: check dss only in party context
2928:
2929: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
2930: l_old_contact_point_rec.owner_table_name IN ('HZ_PARTIES', 'HZ_PARTY_SITES')
2931: THEN
2932: l_test_security :=
2933: hz_dss_util_pub.test_instance(
2934: p_operation_code => 'UPDATE',

Line 2954: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN

2950: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2951: IF l_old_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2953: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2954: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2955: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2956: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2957: END IF;
2958: FND_MSG_PUB.ADD;

Line 7039: FROM HZ_PARTY_SITES ps,

7035:
7036: ----(Site level contact point)
7037: CURSOR c_sl_cp(p_party_site_id NUMBER) IS
7038: SELECT ac.CUST_ACCT_SITE_ID
7039: FROM HZ_PARTY_SITES ps,
7040: HZ_CUST_ACCT_SITES_ALL ac
7041: WHERE ps.PARTY_SITE_ID=p_party_site_id
7042: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;
7043:

Line 7084: IF (l_owner_table_name='HZ_PARTY_SITES' AND l_contact_point_type NOT IN ('EDI', 'EMAIL', 'WEB'))

7080:
7081: l_owner_table_name := p_cp_rec.owner_table_name;
7082: l_contact_point_type := p_cp_rec.contact_point_type;
7083:
7084: IF (l_owner_table_name='HZ_PARTY_SITES' AND l_contact_point_type NOT IN ('EDI', 'EMAIL', 'WEB'))
7085: OR (l_owner_table_name='HZ_PARTIES' AND l_contact_point_type NOT IN ('EDI','WEB'))
7086: THEN
7087: IF( isModified( p_old_phone_rec.phone_number ,p_new_phone_rec.phone_number)
7088: OR isModified(p_old_phone_rec.phone_area_code ,p_new_phone_rec.phone_area_code)

Line 7092: IF l_owner_table_name ='HZ_PARTY_SITES'

7088: OR isModified(p_old_phone_rec.phone_area_code ,p_new_phone_rec.phone_area_code)
7089: OR isModified(p_old_phone_rec.phone_country_code ,p_new_phone_rec.phone_country_code)
7090: OR isModified(p_old_email_rec.email_address ,p_new_email_rec.email_address)
7091: ) THEN
7092: IF l_owner_table_name ='HZ_PARTY_SITES'
7093: THEN
7094: OPEN c_sl_cp(p_cp_rec.owner_table_id);
7095: FETCH c_sl_cp BULK COLLECT INTO l_siteidtab;
7096: CLOSE c_sl_cp;