APPS.HZ_ORG_INFO_VALIDATE dependencies on FND_CURRENCIES

Line 100: -- security_currency_code to fnd_currencies.

96: END IF;
97:
98: -- validate foreign key: party_id to hz_parties,
99: -- stock_exchange_id to hz_stock_markets,
100: -- security_currency_code to fnd_currencies.
101:
102:
103: IF p_security_issued_rec.party_id is NOT NULL AND
104: p_security_issued_rec.party_id <> FND_API.G_MISS_NUM THEN

Line 146: FROM fnd_currencies

142: p_security_issued_rec.security_currency_code <> FND_API.G_MISS_CHAR THEN
143:
144: SELECT count(*)
145: INTO l_count
146: FROM fnd_currencies
147: WHERE currency_code = p_security_issued_rec.security_currency_code
148: AND currency_flag = 'Y'
149: AND enabled_flag in ('Y', 'N');
150:

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

151: if l_count = 0 then
152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
153: FND_MESSAGE.SET_TOKEN('FK', 'security_currency_code');
154: FND_MESSAGE.SET_TOKEN('COLUMN', 'currency_code');
155: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_currencies');
156: FND_MSG_PUB.ADD;
157: x_return_status := FND_API.G_RET_STS_ERROR;
158:
159: end if;