APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on FND_TIMEZONES_VL

Line 1099: -- timezone from fnd_timezones_vl view.

1095: -- 10-SEP-2007 Neeraj Shinde o Bug 6367289 : Added Validation - EFT type of
1096: -- contact point can only
1097: -- be assigned to Parties of type Organization.
1098: -- 18-JUL-2008 Ajai Singh o Bug 7046491 : Updated curser to compare the
1099: -- timezone from fnd_timezones_vl view.
1100:
1101: PROCEDURE validate_contact_point_main (
1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

Line 1201: FROM fnd_timezones_vl ftl

1197: WHERE hps.party_site_id = p_owner_table_id;
1198:
1199: CURSOR c_timezone (p_timezone_id IN NUMBER) IS--updated against bug 7046491
1200: SELECT 'Y'
1201: FROM fnd_timezones_vl ftl
1202: WHERE ftl.upgrade_tz_id = p_timezone_id;
1203:
1204: CURSOR c_countrycode (p_phone_country_code IN VARCHAR2) IS
1205: SELECT 'Y'

Line 2454: fnd_message.set_token('TABLE', 'fnd_timezones_vl');

2450: IF c_timezone%NOTFOUND THEN--updated against bug 7046491
2451: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2452: fnd_message.set_token('FK', 'upgrade_tz_id');
2453: fnd_message.set_token('COLUMN', 'upgrade_tz_id');
2454: fnd_message.set_token('TABLE', 'fnd_timezones_vl');
2455: fnd_msg_pub.add;
2456: x_return_status := fnd_api.g_ret_sts_error;
2457: END IF;
2458: