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:

Line 11455: /* Bug 11874705 : Changed the validation from HZ_TIMEZONES to FND_TIMEZONES_VL

11451: AND
11452: p_location_rec.timezone_id <> fnd_api.g_miss_num
11453: THEN
11454: BEGIN
11455: /* Bug 11874705 : Changed the validation from HZ_TIMEZONES to FND_TIMEZONES_VL
11456: SELECT 'Y'
11457: INTO l_dummy
11458: FROM HZ_TIMEZONES
11459: WHERE TIMEZONE_ID = p_location_rec.timezone_id;

Line 11464: FROM FND_TIMEZONES_VL

11460: */
11461:
11462: SELECT 'Y'
11463: INTO l_dummy
11464: FROM FND_TIMEZONES_VL
11465: WHERE UPGRADE_TZ_ID = p_location_rec.timezone_id;
11466: EXCEPTION
11467: WHEN NO_DATA_FOUND THEN
11468: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

11467: WHEN NO_DATA_FOUND THEN
11468: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11469: fnd_message.set_token('FK', 'timezone_id');
11470: fnd_message.set_token('COLUMN', 'upgrade_tz_id');
11471: fnd_message.set_token('TABLE', 'fnd_timezones_vl');
11472: fnd_msg_pub.add;
11473: x_return_status := fnd_api.g_ret_sts_error;
11474: END;
11475: