DBA Data[Home] [Help]

APPS.HZ_PAYMENT_METHOD_PUB dependencies on AR_RECEIPT_METHODS

Line 422: FROM AR_RECEIPT_METHODS

418: AND casu.site_use_id = l_casu_id;
419:
420: CURSOR check_receipt_method_id(l_rm_id NUMBER) IS
421: SELECT 'X'
422: FROM AR_RECEIPT_METHODS
423: WHERE receipt_method_id = l_rm_id
424: AND sysdate between start_date and nvl(end_date, sysdate);
425: BEGIN
426: -- check not null first

Line 494: FND_MESSAGE.SET_TOKEN('TABLE','AR_RECEIPT_METHODS');

490: CLOSE check_receipt_method_id;
491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
492: FND_MESSAGE.SET_TOKEN('FK','RECEIPT_METHOD_ID');
493: FND_MESSAGE.SET_TOKEN('COLUMN','RECEIPT_METHOD_ID');
494: FND_MESSAGE.SET_TOKEN('TABLE','AR_RECEIPT_METHODS');
495: FND_MSG_PUB.ADD;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: CLOSE check_receipt_method_id;