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_REGISTRY_VALIDATE_V2PUB dependencies on FND_LANGUAGES

Line 6404: -- language has foreign key fnd_languages.language_code

6400: --------------------------
6401: -- validation for language
6402: --------------------------
6403:
6404: -- language has foreign key fnd_languages.language_code
6405: IF p_party_site_rec.language IS NOT NULL
6406: AND
6407: p_party_site_rec.language <> fnd_api.g_miss_char
6408: THEN

Line 6412: FROM FND_LANGUAGES

6408: THEN
6409: BEGIN
6410: SELECT 'Y'
6411: INTO l_dummy
6412: FROM FND_LANGUAGES
6413: WHERE LANGUAGE_CODE = p_party_site_rec.language
6414: AND INSTALLED_FLAG IN ('B', 'I');
6415: EXCEPTION
6416: WHEN NO_DATA_FOUND THEN

Line 6420: fnd_message.set_token('TABLE', 'fnd_languages(installed)');

6416: WHEN NO_DATA_FOUND THEN
6417: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6418: fnd_message.set_token('FK', 'language');
6419: fnd_message.set_token('COLUMN', 'language_code');
6420: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
6421: fnd_msg_pub.add;
6422: x_return_status := fnd_api.g_ret_sts_error;
6423: END;
6424:

Line 6427: -- 'language has foreign key fnd_languages.language_code. ' ||

6423: END;
6424:
6425: -- IF g_debug THEN
6426: -- hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
6427: -- 'language has foreign key fnd_languages.language_code. ' ||
6428: -- 'x_return_status = ' || x_return_status, l_debug_prefix);
6429: -- END IF;
6430:
6431: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 6433: p_message=>'language has foreign key fnd_languages.language_code. ' ||

6429: -- END IF;
6430:
6431: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6432: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
6433: p_message=>'language has foreign key fnd_languages.language_code. ' ||
6434: 'x_return_status = ' || x_return_status,
6435: p_msg_level=>fnd_log.level_statement);
6436: END IF;
6437:

Line 8040: -- language_name has foreign key fnd_languages.language_code

8036: END IF;
8037:
8038: END IF;
8039:
8040: -- language_name has foreign key fnd_languages.language_code
8041: IF p_person_language_rec.language_name IS NOT NULL
8042: AND
8043: p_person_language_rec.language_name <> fnd_api.g_miss_char
8044: THEN

Line 8048: FROM FND_LANGUAGES

8044: THEN
8045: BEGIN
8046: SELECT 'Y'
8047: INTO l_dummy
8048: FROM FND_LANGUAGES
8049: WHERE LANGUAGE_CODE = p_person_language_rec.language_name;
8050: EXCEPTION
8051: WHEN NO_DATA_FOUND THEN
8052: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 8055: fnd_message.set_token('TABLE', 'fnd_languages');

8051: WHEN NO_DATA_FOUND THEN
8052: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
8053: fnd_message.set_token('FK', 'language_name');
8054: fnd_message.set_token('COLUMN', 'language_code');
8055: fnd_message.set_token('TABLE', 'fnd_languages');
8056: fnd_msg_pub.add;
8057: x_return_status := fnd_api.g_ret_sts_error;
8058: END;
8059:

Line 8062: 'language_name has foreign key fnd_languages.language_code. ' ||

8058: END;
8059:
8060: /*IF g_debug THEN
8061: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
8062: 'language_name has foreign key fnd_languages.language_code. ' ||
8063: 'x_return_status = ' || x_return_status, l_debug_prefix);
8064: END IF;
8065: */
8066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 8068: p_message=>'language_name has foreign key fnd_languages.language_code. ' ||

8064: END IF;
8065: */
8066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8067: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
8068: p_message=>'language_name has foreign key fnd_languages.language_code. ' ||
8069: 'x_return_status = ' || x_return_status,
8070: p_msg_level=>fnd_log.level_statement);
8071: END IF;
8072:

Line 11408: -- language has foreign key fnd_languages.language_code

11404:
11405: --------------------------
11406: -- validation for language
11407: --------------------------
11408: -- language has foreign key fnd_languages.language_code
11409: IF p_location_rec.language IS NOT NULL
11410: AND
11411: p_location_rec.language <> fnd_api.g_miss_char
11412: THEN

Line 11416: FROM FND_LANGUAGES

11412: THEN
11413: BEGIN
11414: SELECT 'Y'
11415: INTO l_dummy
11416: FROM FND_LANGUAGES
11417: WHERE LANGUAGE_CODE = p_location_rec.language
11418: AND INSTALLED_FLAG IN ('B', 'I');
11419: EXCEPTION
11420: WHEN NO_DATA_FOUND THEN

Line 11424: fnd_message.set_token('TABLE', 'fnd_languages(installed)');

11420: WHEN NO_DATA_FOUND THEN
11421: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11422: fnd_message.set_token('FK', 'language');
11423: fnd_message.set_token('COLUMN', 'language_code');
11424: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
11425: fnd_msg_pub.add;
11426: x_return_status := fnd_api.g_ret_sts_error;
11427: END;
11428:

Line 11431: 'language has foreign key fnd_languages.language_code (installed). ' ||

11427: END;
11428:
11429: /*IF g_debug THEN
11430: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
11431: 'language has foreign key fnd_languages.language_code (installed). ' ||
11432: 'x_return_status = ' || x_return_status, l_debug_prefix);
11433: END IF;
11434: */
11435: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 11437: p_message=>'language has foreign key fnd_languages.language_code (installed). ' ||

11433: END IF;
11434: */
11435: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
11436: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
11437: p_message=>'language has foreign key fnd_languages.language_code (installed). ' ||
11438: 'x_return_status = ' || x_return_status,
11439: p_msg_level=>fnd_log.level_statement);
11440: END IF;
11441: END IF;