DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on FND_TIMEZONES_B

Line 614: FROM FND_TIMEZONES_B

610: -- validate timezone_code for FK to FND_TIMEZONES
611: IF p_master_geography_rec.timezone_code IS NOT NULL THEN
612:
613: SELECT count(*) INTO l_count
614: FROM FND_TIMEZONES_B
615: WHERE timezone_code = p_master_geography_rec.timezone_code;
616:
617: IF l_count = 0 THEN
618: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 621: fnd_message.set_token('TABLE','FND_TIMEZONES_B');

617: IF l_count = 0 THEN
618: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
619: fnd_message.set_token('FK', 'timezone_code');
620: fnd_message.set_token('COLUMN','timezone_code');
621: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
622: fnd_msg_pub.add;
623: x_return_status := fnd_api.g_ret_sts_error;
624: END IF;
625: END IF;