APPS.HZ_GEOGRAPHY_PUB dependencies on FND_TIMEZONES_B

Line 2163: FROM FND_TIMEZONES_B

2159: -- validate timezone_code for FK to FND_TIMEZONES
2160: IF p_timezone_code IS NOT NULL THEN
2161:
2162: SELECT count(*) INTO l_count
2163: FROM FND_TIMEZONES_B
2164: WHERE timezone_code = p_timezone_code
2165: AND rownum <2;
2166:
2167: IF l_count = 0 THEN

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

2167: IF l_count = 0 THEN
2168: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2169: fnd_message.set_token('FK', 'timezone_code');
2170: fnd_message.set_token('COLUMN','timezone_code');
2171: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2172: fnd_msg_pub.add;
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2175: END IF;

Line 3010: -- timezone_code must be FK to fnd_timezones_b

3006: RAISE FND_API.G_EXC_ERROR;
3007: END IF;
3008:
3009:
3010: -- timezone_code must be FK to fnd_timezones_b
3011: IF p_timezone_code IS NOT NULL THEN
3012: SELECT count(*) INTO l_count
3013: FROM fnd_timezones_b
3014: WHERE timezone_code = p_timezone_code

Line 3013: FROM fnd_timezones_b

3009:
3010: -- timezone_code must be FK to fnd_timezones_b
3011: IF p_timezone_code IS NOT NULL THEN
3012: SELECT count(*) INTO l_count
3013: FROM fnd_timezones_b
3014: WHERE timezone_code = p_timezone_code
3015: AND rownum <2;
3016:
3017: IF l_count = 0 THEN

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

3017: IF l_count = 0 THEN
3018: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3019: fnd_message.set_token('FK', 'timezone_code');
3020: fnd_message.set_token('COLUMN','timezone_code');
3021: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3022: fnd_msg_pub.add;
3023: RAISE FND_API.G_EXC_ERROR;
3024: END IF;
3025: END IF;