APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_TIMEZONES

Line 2443: -- timezone_id is foreign key of hz_timezones

2439: --------------------------------------
2440: -- validate timezone_id
2441: --------------------------------------
2442:
2443: -- timezone_id is foreign key of hz_timezones
2444: IF p_phone_rec.timezone_id IS NOT NULL AND
2445: p_phone_rec.timezone_id <> fnd_api.g_miss_num
2446: THEN
2447: OPEN c_timezone(p_phone_rec.timezone_id);

Line 2463: 'PHONE : timezone_id is foreign key of hz_timezones. ' ||

2459: CLOSE c_timezone;
2460:
2461: /*IF g_debug THEN
2462: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
2463: 'PHONE : timezone_id is foreign key of hz_timezones. ' ||
2464: 'x_return_status = ' || x_return_status, l_debug_prefix);
2465: END IF;
2466: */
2467: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2469: p_message=>'PHONE : timezone_id is foreign key of hz_timezones. ' ||

2465: END IF;
2466: */
2467: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2468: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
2469: p_message=>'PHONE : timezone_id is foreign key of hz_timezones. ' ||
2470: 'x_return_status = ' || x_return_status,
2471: p_msg_level=>fnd_log.level_statement);
2472: END IF;
2473:

Line 11446: -- timezone_id has foreign key hz_timezones.timezone_id

11442:
11443: -----------------------------
11444: -- validation for timezone_id
11445: -----------------------------
11446: -- timezone_id has foreign key hz_timezones.timezone_id
11447: IF p_location_rec.timezone_id IS NOT NULL
11448: AND
11449: p_location_rec.timezone_id <> fnd_api.g_miss_num
11450: THEN

Line 11454: FROM HZ_TIMEZONES

11450: THEN
11451: BEGIN
11452: SELECT 'Y'
11453: INTO l_dummy
11454: FROM HZ_TIMEZONES
11455: WHERE TIMEZONE_ID = p_location_rec.timezone_id;
11456: EXCEPTION
11457: WHEN NO_DATA_FOUND THEN
11458: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 11461: fnd_message.set_token('TABLE', 'hz_timezones');

11457: WHEN NO_DATA_FOUND THEN
11458: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11459: fnd_message.set_token('FK', 'timezone_id');
11460: fnd_message.set_token('COLUMN', 'timezone_id');
11461: fnd_message.set_token('TABLE', 'hz_timezones');
11462: fnd_msg_pub.add;
11463: x_return_status := fnd_api.g_ret_sts_error;
11464: END;
11465:

Line 11468: 'timezone_id has foreign key hz_timezones.timezone_id. ' ||

11464: END;
11465:
11466: /*IF g_debug THEN
11467: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
11468: 'timezone_id has foreign key hz_timezones.timezone_id. ' ||
11469: 'x_return_status = ' || x_return_status, l_debug_prefix);
11470: END IF;
11471: */
11472: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 11474: p_message=>'timezone_id has foreign key hz_timezones.timezone_id. ' ||

11470: END IF;
11471: */
11472: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
11473: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
11474: p_message=>'timezone_id has foreign key hz_timezones.timezone_id. ' ||
11475: 'x_return_status = ' || x_return_status,
11476: p_msg_level=>fnd_log.level_statement);
11477: END IF;
11478: END IF;