APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on FND_CURRENCIES

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

5420: ----------------------------------------
5421: -- validate maximum_credit_currency_code
5422: ----------------------------------------
5423:
5424: -- maximum_credit_currency_code is foreign key of fnd_currencies.currency_code
5425: IF p_organization_rec.maximum_credit_currency_code IS NOT NULL
5426: AND
5427: p_organization_rec.maximum_credit_currency_code <> fnd_api.g_miss_char
5428: THEN

Line 5432: FROM FND_CURRENCIES

5428: THEN
5429: BEGIN
5430: SELECT 'Y'
5431: INTO l_dummy
5432: FROM FND_CURRENCIES
5433: WHERE CURRENCY_CODE = p_organization_rec.maximum_credit_currency_code
5434: AND CURRENCY_FLAG = 'Y'
5435: AND ENABLED_FLAG in ('Y', 'N');
5436: EXCEPTION

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

5437: WHEN NO_DATA_FOUND THEN
5438: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5439: fnd_message.set_token('FK', 'maximum_credit_currency_code');
5440: fnd_message.set_token('COLUMN', 'currency_code');
5441: fnd_message.set_token('TABLE', 'fnd_currencies');
5442: fnd_msg_pub.add;
5443: x_return_status := fnd_api.g_ret_sts_error;
5444: END;
5445:

Line 5448: 'maximum_credit_currency_code is foreign key of fnd_currencies.currency_code. ' ||

5444: END;
5445:
5446: IF g_debug THEN
5447: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
5448: 'maximum_credit_currency_code is foreign key of fnd_currencies.currency_code. ' ||
5449: 'x_return_status = ' || x_return_status, l_debug_prefix);
5450: END IF;
5451:
5452: END IF;

Line 18433: -- maximum_credit_currency_code is foreign key to FND_CURRENCIES.CURRENCY_CODE

18429: ----------------------------------------------
18430: -- validation for maximum_credit_currency_code
18431: ----------------------------------------------
18432:
18433: -- maximum_credit_currency_code is foreign key to FND_CURRENCIES.CURRENCY_CODE
18434: IF p_create_update_flag = 'C'
18435: AND
18436: p_credit_rating_rec.maximum_credit_currency_code IS NOT NULL
18437: AND

Line 18446: FROM fnd_currencies f

18442: --has to be against active records
18443: --Bug 3877782. Added the condition to consider start_date_active and end_date_active.
18444: SELECT 'Y'
18445: INTO l_dummy
18446: FROM fnd_currencies f
18447: WHERE f.currency_code = p_credit_rating_rec.maximum_credit_currency_code
18448: AND currency_flag = 'Y'
18449: AND enabled_flag = 'Y'
18450: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))

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

18453: WHEN NO_DATA_FOUND THEN
18454: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
18455: fnd_message.set_token('FK', 'currency_code');
18456: fnd_message.set_token('COLUMN', 'maximum_credit_currency_code');
18457: fnd_message.set_token('TABLE', 'fnd_currencies');
18458: fnd_msg_pub.add;
18459: x_return_status := fnd_api.g_ret_sts_error;
18460: END;
18461:

Line 18464: 'maximum_credit_currency_code has foreign key fnd_currencies.currency_code. ' ||

18460: END;
18461:
18462: /*IF g_debug THEN
18463: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
18464: 'maximum_credit_currency_code has foreign key fnd_currencies.currency_code. ' ||
18465: 'x_return_status = ' || x_return_status, l_debug_prefix);
18466: END IF;
18467: */
18468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 18470: p_message=>'maximum_credit_currency_code has foreign key fnd_currencies.currency_code. ' ||

18466: END IF;
18467: */
18468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
18469: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
18470: p_message=>'maximum_credit_currency_code has foreign key fnd_currencies.currency_code. ' ||
18471: 'x_return_status = ' || x_return_status,
18472: p_msg_level=>fnd_log.level_statement);
18473: END IF;
18474: