108: --------------------------------------------------------
109: IF l_no_balance = 'Y' THEN
110:
111: IF p_called_from_api = 'Y' THEN
112: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
113: fnd_msg_pub.Add;
114: END IF;
115:
116: RAISE out_of_balance;
132: WHEN out_of_balance THEN
133: IF PG_DEBUG in ('Y', 'C') THEN
134: arp_standard.debug('ARP_BALANCE_CHK.Check_Transaction_Balance - OUT_OF_BALANCE');
135: END IF;
136: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
137: app_exception.raise_exception;
138: WHEN NO_DATA_FOUND THEN
139: /* Case for invoice with rules */
140: IF PG_DEBUG in ('Y', 'C') THEN
252: --------------------------------------------------------
253: IF l_no_balance = 'Y' THEN
254:
255: IF p_called_from_api = 'Y' THEN
256: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
257: fnd_msg_pub.Add;
258: END IF;
259:
260: RAISE out_of_balance;
278: WHEN out_of_balance THEN
279: IF PG_DEBUG in ('Y', 'C') THEN
280: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OUT_OF_BALANCE');
281: END IF;
282: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
283: app_exception.raise_exception;
284:
285: WHEN OTHERS THEN
286: IF PG_DEBUG in ('Y', 'C') THEN
349: IF (l_amt_dr <> l_amt_cr) OR (l_acctd_amt_dr <> l_acctd_amt_cr) THEN
350:
351: IF p_called_from_api = 'Y' THEN
352:
353: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
354: fnd_msg_pub.Add;
355:
356: END IF;
357:
370:
371: IF l_amount <> l_calc_amount AND l_status = 'A' THEN
372: IF p_called_from_api = 'Y' THEN
373:
374: fnd_message.set_name('AR','AR_ADJ_AMT_NO_MATCH');
375: fnd_msg_pub.Add;
376:
377: END IF;
378:
405: arp_standard.debug('Amount Credit = '||l_amt_cr);
406: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);
407: arp_standard.debug('Acctd AmountCredit = '||l_acctd_amt_cr);
408: END IF;
409: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
410: app_exception.raise_exception;
411:
412: WHEN amount_mismatch THEN
413: IF PG_DEBUG in ('Y', 'C') THEN
415: arp_standard.debug('Adjustment_id = '||p_adj_id);
416: arp_standard.debug('Amount = '||l_amount);
417: arp_standard.debug('Sum of Buckets = '||l_calc_amount);
418: END IF;
419: fnd_message.set_name('AR','AR_ADJ_AMT_NO_MATCH');
420: app_exception.raise_exception;
421: WHEN OTHERS THEN
422: IF PG_DEBUG in ('Y', 'C') THEN
423: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OTHERS');
478: --------------------------------------------------------
479: IF (l_amt_dr <> l_amt_cr) OR (l_acctd_amt_dr <> l_acctd_amt_cr) THEN
480: IF p_called_from_api = 'Y' THEN
481:
482: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
483: fnd_msg_pub.Add;
484:
485: END IF;
486:
515: arp_standard.debug('Amount Credit = '||l_amt_cr);
516: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);
517: arp_standard.debug('Acctd AmountCredit = '||l_acctd_amt_cr);
518: END IF;
519: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
520: app_exception.raise_exception;
521: WHEN OTHERS THEN
522: IF PG_DEBUG in ('Y', 'C') THEN
523: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OTHERS');
588: IF (((l_amt_dr <> l_amt_cr) AND (l_cc_flag = 'N'))
589: OR (l_acctd_amt_dr <> l_acctd_amt_cr)) THEN
590: IF p_called_from_api = 'Y' THEN
591:
592: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
593: fnd_msg_pub.Add;
594:
595: END IF;
596:
626: arp_standard.debug('Amount Credit = '||l_amt_cr);
627: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);
628: arp_standard.debug('Acctd AmountCredit = '||l_acctd_amt_cr);
629: END IF;
630: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
631: app_exception.raise_exception;
632: WHEN OTHERS THEN
633: IF PG_DEBUG in ('Y', 'C') THEN
634: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OTHERS -> for Receipt Applications');