APPS.HZ_PARTY_INFO_VAL dependencies on FND_CURRENCIES

Line 1240: -- maximum_credit_currency_code is foreign key of fnd_currencies.currency_code

1236: ----------------------------------------
1237: -- validate maximum_credit_currency_code
1238: ----------------------------------------
1239:
1240: -- maximum_credit_currency_code is foreign key of fnd_currencies.currency_code
1241:
1242: IF p_credit_ratings_rec.maximum_credit_currency_code IS NOT NULL
1243: AND
1244: p_credit_ratings_rec.maximum_credit_currency_code <> fnd_api.g_miss_char

Line 1249: FROM FND_CURRENCIES

1245: THEN
1246: BEGIN
1247: SELECT 'Y'
1248: INTO l_dummy
1249: FROM FND_CURRENCIES
1250: WHERE CURRENCY_CODE = p_credit_ratings_rec.maximum_credit_currency_code
1251: AND CURRENCY_FLAG = 'Y'
1252: AND ENABLED_FLAG in ('Y', 'N');
1253: EXCEPTION

Line 1258: fnd_message.set_token('TABLE', 'fnd_currencies');

1254: WHEN NO_DATA_FOUND THEN
1255: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1256: fnd_message.set_token('FK', 'maximum_credit_currency_code');
1257: fnd_message.set_token('COLUMN', 'currency_code');
1258: fnd_message.set_token('TABLE', 'fnd_currencies');
1259: fnd_msg_pub.add;
1260: x_return_status := fnd_api.g_ret_sts_error;
1261: END;
1262:

Line 1264: hz_utility_v2pub.debug(p_message=>'maximum_credit_currency_code is foreign key of fnd_currencies.currency_code. ' ||

1260: x_return_status := fnd_api.g_ret_sts_error;
1261: END;
1262:
1263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1264: hz_utility_v2pub.debug(p_message=>'maximum_credit_currency_code is foreign key of fnd_currencies.currency_code. ' ||
1265: 'x_return_status = ' || x_return_status,
1266: p_prefix =>l_debug_prefix,
1267: p_msg_level=>fnd_log.level_statement);
1268: END IF;