eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on FND_LANGUAGES

Line 402: -- language_code must be FK to fnd_languages

398: x_return_status => x_return_status
399: );
400:
401:
402: -- language_code must be FK to fnd_languages
403: IF p_geo_identifier_rec.language_code IS NOT NULL THEN
404: SELECT count(*) INTO l_count
405: FROM fnd_languages
406: WHERE language_code = p_geo_identifier_rec.language_code

Line 405: FROM fnd_languages

401:
402: -- language_code must be FK to fnd_languages
403: IF p_geo_identifier_rec.language_code IS NOT NULL THEN
404: SELECT count(*) INTO l_count
405: FROM fnd_languages
406: WHERE language_code = p_geo_identifier_rec.language_code
407: AND rownum <2;
408:
409: IF l_count = 0 THEN

Line 413: fnd_message.set_token('TABLE','FND_LANGUAGES');

409: IF l_count = 0 THEN
410: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
411: fnd_message.set_token('FK','language_code');
412: fnd_message.set_token('COLUMN', 'language_code');
413: fnd_message.set_token('TABLE','FND_LANGUAGES');
414: fnd_msg_pub.add;
415: x_return_status := fnd_api.g_ret_sts_error;
416: END IF;
417: END IF;

Line 627: -- language_code must be FK to fnd_languages

623: x_return_status := fnd_api.g_ret_sts_error;
624: END IF;
625: END IF;
626:
627: -- language_code must be FK to fnd_languages
628: IF p_master_geography_rec.language_code IS NOT NULL THEN
629: SELECT count(*) INTO l_count
630: FROM fnd_languages
631: WHERE language_code = UPPER(p_master_geography_rec.language_code)

Line 630: FROM fnd_languages

626:
627: -- language_code must be FK to fnd_languages
628: IF p_master_geography_rec.language_code IS NOT NULL THEN
629: SELECT count(*) INTO l_count
630: FROM fnd_languages
631: WHERE language_code = UPPER(p_master_geography_rec.language_code)
632: AND rownum <2;
633: IF l_count = 0 THEN
634: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 637: fnd_message.set_token('TABLE','FND_LANGUAGES');

633: IF l_count = 0 THEN
634: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
635: fnd_message.set_token('FK', 'language_code');
636: fnd_message.set_token('COLUMN','language_code');
637: fnd_message.set_token('TABLE','FND_LANGUAGES');
638: fnd_msg_pub.add;
639: x_return_status := fnd_api.g_ret_sts_error;
640: END IF;
641: END IF;