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 332: FROM hz_party_sites

328: CURSOR c_country (p_site_id IN NUMBER) IS
329: SELECT country
330: FROM hz_locations
331: WHERE location_id = (SELECT location_id
332: FROM hz_party_sites
333: WHERE party_site_id = p_site_id);
334:
335: -- Bug 2197181: added for mix-n-match project: the contact point
336: -- must be visible.

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

473: p_msg_level=>fnd_log.level_statement);
474: END IF;
475:
476: --To get territory code to pass to phone_format, first check if country code
477: --was passed in else get it from hz_locations for owner_table_name HZ_PARTY_SITES
478:
479: IF p_contact_point_rec.contact_point_type = 'PHONE' THEN
480: IF l_phone_rec.raw_phone_number IS NOT NULL AND
481: l_phone_rec.raw_phone_number <> fnd_api.g_miss_char

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

491: EXCEPTION
492: WHEN NO_DATA_FOUND THEN
493: NULL;
494: END;
495: ELSIF p_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' AND
496: (l_phone_rec.phone_country_code IS NULL OR
497: l_phone_rec.phone_country_code = fnd_api.g_miss_char)
498: THEN
499: -- Bug 2117973: modified to conform to Applications PL/SQL standards.

Line 1033: FROM hz_party_sites

1029: CURSOR c_country (p_owner_table_id IN NUMBER) IS
1030: SELECT country
1031: FROM hz_locations
1032: WHERE location_id = (SELECT location_id
1033: FROM hz_party_sites
1034: WHERE party_site_id = p_owner_table_id);
1035:
1036: -- Bug 2197181: added for mix-n-match project: the contact point
1037: -- must be visible.

Line 1297: ELSIF l_owner_table_name = 'HZ_PARTY_SITES' AND

1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN
1295: NULL;
1296: END;
1297: ELSIF l_owner_table_name = 'HZ_PARTY_SITES' AND
1298: l_phone_country_code IS NULL THEN
1299: OPEN c_country (l_owner_table_id);
1300: FETCH c_country INTO l_country_code;
1301:

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

2845: -- Bug 3818648: check dss profile before call test_instance
2846: -- Bug 3867562: check dss only in party context
2847:
2848: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
2849: l_contact_point_rec.owner_table_name IN ('HZ_PARTIES', 'HZ_PARTY_SITES')
2850: THEN
2851: l_test_security :=
2852: hz_dss_util_pub.test_instance(
2853: p_operation_code => 'INSERT',

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

2869: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
2870: IF l_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2871: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2872: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2873: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2874: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2875: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2876: END IF;
2877: FND_MSG_PUB.ADD;

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

3082: -- Bug 3818648: check dss profile before call test_instance
3083: -- Bug 3867562: check dss only in party context
3084:
3085: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3086: l_old_contact_point_rec.owner_table_name IN ('HZ_PARTIES', 'HZ_PARTY_SITES')
3087: THEN
3088: l_test_security :=
3089: hz_dss_util_pub.test_instance(
3090: p_operation_code => 'UPDATE',

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

3106: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
3107: IF l_old_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
3108: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3109: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
3110: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
3111: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3112: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
3113: END IF;
3114: FND_MSG_PUB.ADD;

Line 7195: FROM HZ_PARTY_SITES ps,

7191:
7192: ----(Site level contact point)
7193: CURSOR c_sl_cp(p_party_site_id NUMBER) IS
7194: SELECT ac.CUST_ACCT_SITE_ID
7195: FROM HZ_PARTY_SITES ps,
7196: HZ_CUST_ACCT_SITES_ALL ac
7197: WHERE ps.PARTY_SITE_ID=p_party_site_id
7198: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;
7199:

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

7236:
7237: l_owner_table_name := p_cp_rec.owner_table_name;
7238: l_contact_point_type := p_cp_rec.contact_point_type;
7239:
7240: IF (l_owner_table_name='HZ_PARTY_SITES' AND l_contact_point_type NOT IN ('EDI', 'EMAIL', 'WEB'))
7241: OR (l_owner_table_name='HZ_PARTIES' AND l_contact_point_type NOT IN ('EDI','WEB'))
7242: THEN
7243: IF( isModified( p_old_phone_rec.phone_number ,p_new_phone_rec.phone_number)
7244: OR isModified(p_old_phone_rec.phone_area_code ,p_new_phone_rec.phone_area_code)

Line 7248: IF l_owner_table_name ='HZ_PARTY_SITES'

7244: OR isModified(p_old_phone_rec.phone_area_code ,p_new_phone_rec.phone_area_code)
7245: OR isModified(p_old_phone_rec.phone_country_code ,p_new_phone_rec.phone_country_code)
7246: OR isModified(p_old_email_rec.email_address ,p_new_email_rec.email_address)
7247: ) THEN
7248: IF l_owner_table_name ='HZ_PARTY_SITES'
7249: THEN
7250: OPEN c_sl_cp(p_cp_rec.owner_table_id);
7251: FETCH c_sl_cp BULK COLLECT INTO l_siteidtab;
7252: CLOSE c_sl_cp;