APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on FND_CURRENCIES

Line 5894: -- currency_code is foreign key to fnd_currencies

5890: p_msg_level=>fnd_log.level_statement);
5891: END IF;
5892: END IF;
5893:
5894: -- currency_code is foreign key to fnd_currencies
5895: -- Since currency_code is mandatory and non-updateable,
5896: -- we only need to check FK during creation.
5897:
5898: IF p_create_update_flag = 'C' AND

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

5904: p_column_value => p_cust_profile_amt_rec.currency_code,
5905: x_return_status => x_return_status );
5906:
5907: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5908: hz_utility_v2pub.debug(p_message=>'currency_code is foreign key to fnd_currencies. ' ||
5909: 'x_return_status = ' || x_return_status,
5910: p_prefix =>l_debug_prefix,
5911: p_msg_level=>fnd_log.level_statement);
5912: END IF;

Line 10924: FROM FND_CURRENCIES

10920:
10921: BEGIN
10922: -- Bug Fix: 3877782
10923: SELECT 'Y' INTO l_dummy
10924: FROM FND_CURRENCIES
10925: WHERE CURRENCY_CODE = p_column_value
10926: AND CURRENCY_FLAG = 'Y'
10927: AND ENABLED_FLAG = 'Y'
10928: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE))

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

10932: WHEN NO_DATA_FOUND THEN
10933: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10934: FND_MESSAGE.SET_TOKEN( 'FK', 'currency_code' );
10935: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10936: FND_MESSAGE.SET_TOKEN( 'TABLE', 'fnd_currencies' );
10937: FND_MSG_PUB.ADD;
10938: x_return_status := FND_API.G_RET_STS_ERROR;
10939:
10940: END check_currency_fk;