APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on FND_CURRENCIES

Line 5951: -- currency_code is foreign key to fnd_currencies

5947: p_msg_level=>fnd_log.level_statement);
5948: END IF;
5949: END IF;
5950:
5951: -- currency_code is foreign key to fnd_currencies
5952: -- Since currency_code is mandatory and non-updateable,
5953: -- we only need to check FK during creation.
5954:
5955: IF p_create_update_flag = 'C' AND

Line 5965: hz_utility_v2pub.debug(p_message=>'currency_code is foreign key to fnd_currencies. ' ||

5961: p_column_value => p_cust_profile_amt_rec.currency_code,
5962: x_return_status => x_return_status );
5963:
5964: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5965: hz_utility_v2pub.debug(p_message=>'currency_code is foreign key to fnd_currencies. ' ||
5966: 'x_return_status = ' || x_return_status,
5967: p_prefix =>l_debug_prefix,
5968: p_msg_level=>fnd_log.level_statement);
5969: END IF;

Line 11215: FROM FND_CURRENCIES

11211:
11212: BEGIN
11213: -- Bug Fix: 3877782
11214: SELECT 'Y' INTO l_dummy
11215: FROM FND_CURRENCIES
11216: WHERE CURRENCY_CODE = p_column_value
11217: AND CURRENCY_FLAG = 'Y'
11218: AND ENABLED_FLAG = 'Y'
11219: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE))

Line 11227: FND_MESSAGE.SET_TOKEN( 'TABLE', 'fnd_currencies' );

11223: WHEN NO_DATA_FOUND THEN
11224: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11225: FND_MESSAGE.SET_TOKEN( 'FK', 'currency_code' );
11226: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11227: FND_MESSAGE.SET_TOKEN( 'TABLE', 'fnd_currencies' );
11228: FND_MSG_PUB.ADD;
11229: x_return_status := FND_API.G_RET_STS_ERROR;
11230:
11231: END check_currency_fk;