APPS.HZ_GEOGRAPHY_PUB dependencies on FND_TIMEZONES_B

Line 2176: FROM FND_TIMEZONES_B

2172: -- validate timezone_code for FK to FND_TIMEZONES
2173: IF p_timezone_code IS NOT NULL THEN
2174:
2175: SELECT count(*) INTO l_count
2176: FROM FND_TIMEZONES_B
2177: WHERE timezone_code = p_timezone_code
2178: AND rownum <2;
2179:
2180: IF l_count = 0 THEN

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

2180: IF l_count = 0 THEN
2181: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2182: fnd_message.set_token('FK', 'timezone_code');
2183: fnd_message.set_token('COLUMN','timezone_code');
2184: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2185: fnd_msg_pub.add;
2186: RAISE FND_API.G_EXC_ERROR;
2187: END IF;
2188: END IF;

Line 3023: -- timezone_code must be FK to fnd_timezones_b

3019: RAISE FND_API.G_EXC_ERROR;
3020: END IF;
3021:
3022:
3023: -- timezone_code must be FK to fnd_timezones_b
3024: IF p_timezone_code IS NOT NULL THEN
3025: SELECT count(*) INTO l_count
3026: FROM fnd_timezones_b
3027: WHERE timezone_code = p_timezone_code

Line 3026: FROM fnd_timezones_b

3022:
3023: -- timezone_code must be FK to fnd_timezones_b
3024: IF p_timezone_code IS NOT NULL THEN
3025: SELECT count(*) INTO l_count
3026: FROM fnd_timezones_b
3027: WHERE timezone_code = p_timezone_code
3028: AND rownum <2;
3029:
3030: IF l_count = 0 THEN

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

3030: IF l_count = 0 THEN
3031: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3032: fnd_message.set_token('FK', 'timezone_code');
3033: fnd_message.set_token('COLUMN','timezone_code');
3034: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3035: fnd_msg_pub.add;
3036: RAISE FND_API.G_EXC_ERROR;
3037: END IF;
3038: END IF;