APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on FND_LANGUAGES

Line 1031: -- language_code is foreign key of fnd_languages

1027: p_msg_level=>fnd_log.level_statement);
1028: END IF;
1029: END IF;
1030:
1031: -- language_code is foreign key of fnd_languages
1032: -- Do not need to check during update because fnd_languages is
1033: -- non-updateable.
1034: IF p_create_update_flag = 'C'
1035: AND

Line 1032: -- Do not need to check during update because fnd_languages is

1028: END IF;
1029: END IF;
1030:
1031: -- language_code is foreign key of fnd_languages
1032: -- Do not need to check during update because fnd_languages is
1033: -- non-updateable.
1034: IF p_create_update_flag = 'C'
1035: AND
1036: p_style_fmt_locale_rec.language_code IS NOT NULL

Line 1043: FROM FND_LANGUAGES

1039: THEN
1040: BEGIN
1041: SELECT 'Y'
1042: INTO l_dummy
1043: FROM FND_LANGUAGES
1044: WHERE language_code = p_style_fmt_locale_rec.language_code;
1045: EXCEPTION
1046: WHEN NO_DATA_FOUND THEN
1047: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

1046: WHEN NO_DATA_FOUND THEN
1047: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1048: fnd_message.set_token('FK', 'language_code');
1049: fnd_message.set_token('COLUMN', 'language_code');
1050: fnd_message.set_token('TABLE', 'fnd_languages');
1051: fnd_msg_pub.add;
1052: x_return_status := fnd_api.g_ret_sts_error;
1053: END;
1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1055: hz_utility_v2pub.debug(p_message=>'language_code is foreign key of fnd_languages. ' ||

1051: fnd_msg_pub.add;
1052: x_return_status := fnd_api.g_ret_sts_error;
1053: END;
1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'language_code is foreign key of fnd_languages. ' ||
1056: 'x_return_status = ' || x_return_status,
1057: p_prefix =>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_statement);
1059: END IF;