APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on FND_TERRITORIES

Line 1085: -- territory_code is foreign key of fnd_territories

1081: p_msg_level=>fnd_log.level_statement);
1082: END IF;
1083: END IF;
1084:
1085: -- territory_code is foreign key of fnd_territories
1086: -- Do not need to check during update because fnd_territories is
1087: -- non-updateable.
1088: IF p_create_update_flag = 'C'
1089: AND

Line 1086: -- Do not need to check during update because fnd_territories is

1082: END IF;
1083: END IF;
1084:
1085: -- territory_code is foreign key of fnd_territories
1086: -- Do not need to check during update because fnd_territories is
1087: -- non-updateable.
1088: IF p_create_update_flag = 'C'
1089: AND
1090: p_style_fmt_locale_rec.territory_code IS NOT NULL

Line 1097: FROM FND_TERRITORIES

1093: THEN
1094: BEGIN
1095: SELECT 'Y'
1096: INTO l_dummy
1097: FROM FND_TERRITORIES
1098: WHERE territory_code = p_style_fmt_locale_rec.territory_code;
1099: EXCEPTION
1100: WHEN NO_DATA_FOUND THEN
1101: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 1104: fnd_message.set_token('TABLE', 'fnd_territories');

1100: WHEN NO_DATA_FOUND THEN
1101: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1102: fnd_message.set_token('FK', 'territory_code');
1103: fnd_message.set_token('COLUMN', 'territory_code');
1104: fnd_message.set_token('TABLE', 'fnd_territories');
1105: fnd_msg_pub.add;
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: END;
1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1109: hz_utility_v2pub.debug(p_message=>'territory_code is foreign key of fnd_territories. ' ||

1105: fnd_msg_pub.add;
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: END;
1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1109: hz_utility_v2pub.debug(p_message=>'territory_code is foreign key of fnd_territories. ' ||
1110: 'x_return_status = ' || x_return_status,
1111: p_prefix =>l_debug_prefix,
1112: p_msg_level=>fnd_log.level_statement);
1113: END IF;