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 8043: -- language_name has foreign key fnd_languages.language_code

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

Line 8051: FROM FND_LANGUAGES

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

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

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

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

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

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

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

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

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

Line 11419: FROM FND_LANGUAGES

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

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

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

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

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

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

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