[Home] [Help]
270: IF ( check_cb( p_cr_id ) = FALSE ) THEN
271: IF PG_DEBUG in ('Y', 'C') THEN
272: arp_standard.debug('validate_args: ' || 'Check CB Failed' );
273: END IF;
274: FND_MESSAGE.set_name('AR', 'AR_DEBIT_REVERSE');
275: APP_EXCEPTION.raise_exception;
276: END IF ;
277: --
278: --
676: --
677: IF ( p_cr_id is NULL OR p_reversal_category is NULL OR
678: p_reversal_gl_date is NULL OR p_reversal_date is NULL OR
679: p_reversal_reason_code is NULL ) THEN
680: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
681: APP_EXCEPTION.raise_exception;
682: END IF;
683: --
684: -- Validate gl date. If it is invalid, print an error message
686: IF ( arp_util.is_gl_date_valid( p_reversal_gl_date ) = FALSE ) THEN
687: IF PG_DEBUG in ('Y', 'C') THEN
688: arp_standard.debug('validate_args: ' || 'invalid gl date' );
689: END IF;
690: FND_MESSAGE.set_name ('AR', 'AR_INF_GL_DATE' );
691: APP_EXCEPTION.raise_exception;
692: END IF;
693: --
694: IF PG_DEBUG in ('Y', 'C') THEN
1709: IF ( arp_util.is_gl_date_valid( p_reversal_gl_date ) = FALSE ) THEN
1710: IF PG_DEBUG in ('Y', 'C') THEN
1711: arp_standard.debug('debit_memo_reversal: ' || 'invalid gl date' );
1712: END IF;
1713: FND_MESSAGE.set_name ('AR', 'AR_INF_GL_DATE' );
1714: APP_EXCEPTION.raise_exception;
1715: END IF;
1716: --
1717: -- Get receipt method name, currency code, exchange rate info and
1833: into l_term_end_date
1834: from ra_terms where term_id = 5;
1835:
1836: IF (NVL(l_term_end_date, to_date('31-12-4712','DD-MM-YYYY')) < p_reversal_date) THEN
1837: FND_MESSAGE.SET_NAME('AR','AR_RW_PAYMENT_TERM_END_DATED');
1838: fnd_msg_pub.Add;
1839: APP_EXCEPTION.raise_exception;
1840: END IF;
1841: /*5084781 End*/
1865: --
1866: -- If not even a single row is found, then error out NOCOPY
1867: --
1868: IF ( l_count = 0 ) THEN
1869: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1870: FND_MESSAGE.set_token( 'GENERIC_MESSAGE', SQLERRM );
1871: APP_EXCEPTION.raise_exception;
1872: END IF;
1873:
1866: -- If not even a single row is found, then error out NOCOPY
1867: --
1868: IF ( l_count = 0 ) THEN
1869: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1870: FND_MESSAGE.set_token( 'GENERIC_MESSAGE', SQLERRM );
1871: APP_EXCEPTION.raise_exception;
1872: END IF;
1873:
1874: l_ct_rec.ship_to_customer_id := NULL;
2168: --
2169: IF ( p_cr_id IS NULL OR p_cc_id IS NULL OR
2170: p_cust_trx_type_id IS NULL OR p_reversal_gl_date IS NULL OR
2171: p_reversal_date IS NULL OR p_reversal_reason_code IS NULL ) THEN
2172: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
2173: APP_EXCEPTION.raise_exception;
2174: END IF;
2175: --
2176: IF PG_DEBUG in ('Y', 'C') THEN
2485: p_amount_applied => c1.amount_applied,
2486: p_return_status => l_return_status);
2487: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2488: x_return_status := 'E';
2489: FND_MESSAGE.SET_NAME('AR','AR_RW_NET_RVSL_OVERDRAWS_RCT');
2490: FND_MSG_PUB.Add;
2491: EXIT;
2492: END IF;
2493: END LOOP;
2497: END IF;
2498:
2499: EXCEPTION
2500: WHEN others THEN
2501: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
2502: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
2503: FND_MSG_PUB.Add;
2504: x_return_status := FND_API.G_RET_STS_ERROR ;
2505: IF PG_DEBUG in ('Y', 'C') THEN
2498:
2499: EXCEPTION
2500: WHEN others THEN
2501: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
2502: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
2503: FND_MSG_PUB.Add;
2504: x_return_status := FND_API.G_RET_STS_ERROR ;
2505: IF PG_DEBUG in ('Y', 'C') THEN
2506: arp_util.debug('EXCEPTION :arp_revers_receipt.check_netted_receipts '||SQLERRM);