APPS.AR_CUST_PROF_CLASS_AMT_PKG dependencies on FND_CURRENCIES

Line 224: FROM fnd_currencies

220: x_return_status IN OUT NOCOPY VARCHAR2)
221: IS
222: CURSOR curr IS
223: SELECT NULL
224: FROM fnd_currencies
225: WHERE currency_code = p_currency_code;
226: l_code VARCHAR2(30);
227: BEGIN
228: arp_standard.debug('validate_prof_class_amt +');

Line 241: arp_standard.debug(p_currency_code||' should be a in fnd_currencies');

237:
238: OPEN curr;
239: FETCH curr INTO l_code;
240: IF curr%NOTFOUND THEN
241: arp_standard.debug(p_currency_code||' should be a in fnd_currencies');
242: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
243: FND_MESSAGE.SET_TOKEN('FK', 'hz_cust_prof_class_amts');
244: FND_MESSAGE.SET_TOKEN('COLUMN', 'CURRENCY_CODE');
245: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_currencies');

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

241: arp_standard.debug(p_currency_code||' should be a in fnd_currencies');
242: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
243: FND_MESSAGE.SET_TOKEN('FK', 'hz_cust_prof_class_amts');
244: FND_MESSAGE.SET_TOKEN('COLUMN', 'CURRENCY_CODE');
245: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_currencies');
246: FND_MSG_PUB.ADD;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: END IF;
249: CLOSE curr;