53:
54: BEGIN
55:
56: IF PG_DEBUG in ('Y', 'C') THEN
57: arp_standard.debug('ARP_BALANCE_CHK.Check_Transaction_Balance (+)' );
58: END IF;
59:
60: IF p_customer_trx_id IS NOT NULL THEN
61:
96: print the debug messages */
97: l_no_balance := 'Y' ;
98: END IF;
99: IF PG_DEBUG in ('Y', 'C') THEN
100: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));
101: arp_standard.debug('Net Amount :' || l_amount);
102: arp_standard.debug('Net Acctd Amount :' || l_acctd_amount);
103: END IF;
104: END LOOP;
97: l_no_balance := 'Y' ;
98: END IF;
99: IF PG_DEBUG in ('Y', 'C') THEN
100: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));
101: arp_standard.debug('Net Amount :' || l_amount);
102: arp_standard.debug('Net Acctd Amount :' || l_acctd_amount);
103: END IF;
104: END LOOP;
105:
98: END IF;
99: IF PG_DEBUG in ('Y', 'C') THEN
100: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));
101: arp_standard.debug('Net Amount :' || l_amount);
102: arp_standard.debug('Net Acctd Amount :' || l_acctd_amount);
103: END IF;
104: END LOOP;
105:
106: --------------------------------------------------------
118: END IF;
119:
120: ELSE
121: IF PG_DEBUG in ('Y', 'C') THEN
122: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');
123: END IF;
124: END IF;
125: END IF; -- p_customer_trx_id is not null , bug6762463
126:
124: END IF;
125: END IF; -- p_customer_trx_id is not null , bug6762463
126:
127: IF PG_DEBUG in ('Y', 'C') THEN
128: arp_standard.debug('ARP_BALANCE_CHK.Check_Transaction_Balance (-)' );
129: END IF;
130:
131: EXCEPTION
132: WHEN out_of_balance THEN
130:
131: EXCEPTION
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
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
141: arp_standard.debug( 'ARP_BALANCE_CHK.Check_Transaction_Balance - NO_DATA_FOUND' );
142: END IF;
143: WHEN excep_set_org_rem_amt_r12 THEN --LLCA
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_standard.debug('EXCEPTION_set_original_rem_amt_r12 error count:'||l_msg_count);
141: arp_standard.debug( 'ARP_BALANCE_CHK.Check_Transaction_Balance - NO_DATA_FOUND' );
142: END IF;
143: WHEN excep_set_org_rem_amt_r12 THEN --LLCA
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_standard.debug('EXCEPTION_set_original_rem_amt_r12 error count:'||l_msg_count);
146: arp_standard.debug('last error:'||l_msg_data);
147: END IF;
148: RAISE;
149:
142: END IF;
143: WHEN excep_set_org_rem_amt_r12 THEN --LLCA
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_standard.debug('EXCEPTION_set_original_rem_amt_r12 error count:'||l_msg_count);
146: arp_standard.debug('last error:'||l_msg_data);
147: END IF;
148: RAISE;
149:
150: WHEN OTHERS THEN
148: RAISE;
149:
150: WHEN OTHERS THEN
151: IF PG_DEBUG in ('Y', 'C') THEN
152: arp_standard.debug( 'ARP_BALANCE_CHK.Check_Transaction_Balance - OTHERS' );
153: END IF;
154: RAISE;
155:
156: END CHECK_TRANSACTION_BALANCE;
219:
220: BEGIN
221:
222: IF PG_DEBUG in ('Y', 'C') THEN
223: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE (+)');
224: END IF;
225:
226: IF PG_BAL_CHECK_ENABLED = 'Y' THEN
227:
237: l_no_balance := 'Y' ;
238: END IF;
239:
240: IF PG_DEBUG in ('Y', 'C') THEN
241: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));
242: arp_standard.debug('Sum_amount_dr :' || c2.sum_amount_dr);
243: arp_standard.debug('Sum_amount_cr :' || c2.sum_amount_cr);
244: arp_standard.debug('Sum_acctd_amount_dr : '||c2.sum_acctd_amount_dr);
245: arp_standard.debug('Sum_acctd_amount_cr : '||c2.sum_acctd_amount_cr);
238: END IF;
239:
240: IF PG_DEBUG in ('Y', 'C') THEN
241: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));
242: arp_standard.debug('Sum_amount_dr :' || c2.sum_amount_dr);
243: arp_standard.debug('Sum_amount_cr :' || c2.sum_amount_cr);
244: arp_standard.debug('Sum_acctd_amount_dr : '||c2.sum_acctd_amount_dr);
245: arp_standard.debug('Sum_acctd_amount_cr : '||c2.sum_acctd_amount_cr);
246: arp_standard.debug('CC_flag : '||c2.cc_flag);
239:
240: IF PG_DEBUG in ('Y', 'C') THEN
241: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));
242: arp_standard.debug('Sum_amount_dr :' || c2.sum_amount_dr);
243: arp_standard.debug('Sum_amount_cr :' || c2.sum_amount_cr);
244: arp_standard.debug('Sum_acctd_amount_dr : '||c2.sum_acctd_amount_dr);
245: arp_standard.debug('Sum_acctd_amount_cr : '||c2.sum_acctd_amount_cr);
246: arp_standard.debug('CC_flag : '||c2.cc_flag);
247: END IF;
240: IF PG_DEBUG in ('Y', 'C') THEN
241: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));
242: arp_standard.debug('Sum_amount_dr :' || c2.sum_amount_dr);
243: arp_standard.debug('Sum_amount_cr :' || c2.sum_amount_cr);
244: arp_standard.debug('Sum_acctd_amount_dr : '||c2.sum_acctd_amount_dr);
245: arp_standard.debug('Sum_acctd_amount_cr : '||c2.sum_acctd_amount_cr);
246: arp_standard.debug('CC_flag : '||c2.cc_flag);
247: END IF;
248: END LOOP;
241: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));
242: arp_standard.debug('Sum_amount_dr :' || c2.sum_amount_dr);
243: arp_standard.debug('Sum_amount_cr :' || c2.sum_amount_cr);
244: arp_standard.debug('Sum_acctd_amount_dr : '||c2.sum_acctd_amount_dr);
245: arp_standard.debug('Sum_acctd_amount_cr : '||c2.sum_acctd_amount_cr);
246: arp_standard.debug('CC_flag : '||c2.cc_flag);
247: END IF;
248: END LOOP;
249:
242: arp_standard.debug('Sum_amount_dr :' || c2.sum_amount_dr);
243: arp_standard.debug('Sum_amount_cr :' || c2.sum_amount_cr);
244: arp_standard.debug('Sum_acctd_amount_dr : '||c2.sum_acctd_amount_dr);
245: arp_standard.debug('Sum_acctd_amount_cr : '||c2.sum_acctd_amount_cr);
246: arp_standard.debug('CC_flag : '||c2.cc_flag);
247: END IF;
248: END LOOP;
249:
250: --------------------------------------------------------
264: END IF; --p_receipt id is NOT NULL
265:
266: ELSE
267: IF PG_DEBUG in ('Y', 'C') THEN
268: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');
269: END IF;
270: END IF;
271:
272:
270: END IF;
271:
272:
273: IF PG_DEBUG in ('Y', 'C') THEN
274: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE (-)');
275: END IF;
276:
277: EXCEPTION
278: WHEN out_of_balance THEN
276:
277: EXCEPTION
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:
283: app_exception.raise_exception;
284:
285: WHEN OTHERS THEN
286: IF PG_DEBUG in ('Y', 'C') THEN
287: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OTHERS');
288: END IF;
289: RAISE;
290:
291: END CHECK_RECP_BALANCE;
320: l_status VARCHAR2(1); /*5017553*/
321:
322: BEGIN
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE (+)');
325: END IF;
326:
327: IF PG_BAL_CHECK_ENABLED = 'Y' THEN
328:
382: END IF; --adjustment id is not null
383:
384: ELSE
385: IF PG_DEBUG in ('Y', 'C') THEN
386: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');
387: END IF;
388: END IF;
389:
390: IF PG_DEBUG in ('Y', 'C') THEN
387: END IF;
388: END IF;
389:
390: IF PG_DEBUG in ('Y', 'C') THEN
391: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE (-)');
392: END IF;
393:
394: EXCEPTION
395: WHEN NO_DATA_FOUND THEN
393:
394: EXCEPTION
395: WHEN NO_DATA_FOUND THEN
396: IF PG_DEBUG in ('Y', 'C') THEN
397: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - NO_DATA_FOUND');
398: END IF;
399: RAISE;
400: WHEN out_of_balance THEN
401: IF PG_DEBUG in ('Y', 'C') THEN
398: END IF;
399: RAISE;
400: WHEN out_of_balance THEN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - OUT_OF_BALANCE');
403: arp_standard.debug('Adjustment_id = '||p_adj_id);
404: arp_standard.debug('Amount Debit = '||l_amt_dr);
405: arp_standard.debug('Amount Credit = '||l_amt_cr);
406: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);
399: RAISE;
400: WHEN out_of_balance THEN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - OUT_OF_BALANCE');
403: arp_standard.debug('Adjustment_id = '||p_adj_id);
404: arp_standard.debug('Amount Debit = '||l_amt_dr);
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);
400: WHEN out_of_balance THEN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - OUT_OF_BALANCE');
403: arp_standard.debug('Adjustment_id = '||p_adj_id);
404: arp_standard.debug('Amount Debit = '||l_amt_dr);
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;
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - OUT_OF_BALANCE');
403: arp_standard.debug('Adjustment_id = '||p_adj_id);
404: arp_standard.debug('Amount Debit = '||l_amt_dr);
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');
402: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - OUT_OF_BALANCE');
403: arp_standard.debug('Adjustment_id = '||p_adj_id);
404: arp_standard.debug('Amount Debit = '||l_amt_dr);
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;
403: arp_standard.debug('Adjustment_id = '||p_adj_id);
404: arp_standard.debug('Amount Debit = '||l_amt_dr);
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:
410: app_exception.raise_exception;
411:
412: WHEN amount_mismatch THEN
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE -AMOUNT_MISMATCH');
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;
411:
412: WHEN amount_mismatch THEN
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE -AMOUNT_MISMATCH');
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');
412: WHEN amount_mismatch THEN
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE -AMOUNT_MISMATCH');
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;
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE -AMOUNT_MISMATCH');
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
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');
424: END IF;
425: RAISE;
426:
427: END CHECK_ADJ_BALANCE;
451:
452: BEGIN
453:
454: IF PG_DEBUG in ('Y', 'C') THEN
455: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE (+)');
456: END IF;
457:
458: IF PG_BAL_CHECK_ENABLED = 'Y' THEN
459:
491: END IF; --receivable application id is not null
492:
493: ELSE
494: IF PG_DEBUG in ('Y', 'C') THEN
495: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');
496: END IF;
497: END IF;
498:
499: IF PG_DEBUG in ('Y', 'C') THEN
496: END IF;
497: END IF;
498:
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE (-)');
501: END IF;
502:
503: EXCEPTION
504: WHEN NO_DATA_FOUND THEN
504: WHEN NO_DATA_FOUND THEN
505: /* Exception need not be raised as this can happen when the Application
506: is non postable */
507: IF PG_DEBUG in ('Y', 'C') THEN
508: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - NO_DATA_FOUND');
509: END IF;
510: WHEN out_of_balance THEN
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
508: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - NO_DATA_FOUND');
509: END IF;
510: WHEN out_of_balance THEN
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
513: arp_standard.debug('Receivable Application_id = '||p_receivable_application_id);
514: arp_standard.debug('Amount Debit = '||l_amt_dr);
515: arp_standard.debug('Amount Credit = '||l_amt_cr);
516: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);
509: END IF;
510: WHEN out_of_balance THEN
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
513: arp_standard.debug('Receivable Application_id = '||p_receivable_application_id);
514: arp_standard.debug('Amount Debit = '||l_amt_dr);
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);
510: WHEN out_of_balance THEN
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
513: arp_standard.debug('Receivable Application_id = '||p_receivable_application_id);
514: arp_standard.debug('Amount Debit = '||l_amt_dr);
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;
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
513: arp_standard.debug('Receivable Application_id = '||p_receivable_application_id);
514: arp_standard.debug('Amount Debit = '||l_amt_dr);
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');
512: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
513: arp_standard.debug('Receivable Application_id = '||p_receivable_application_id);
514: arp_standard.debug('Amount Debit = '||l_amt_dr);
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;
513: arp_standard.debug('Receivable Application_id = '||p_receivable_application_id);
514: arp_standard.debug('Amount Debit = '||l_amt_dr);
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
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');
524: END IF;
525: RAISE;
526:
527: END CHECK_APPLN_BALANCE;
554:
555: BEGIN
556:
557: IF PG_DEBUG in ('Y', 'C') THEN
558: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE (+) -> for Receipt Applications');
559: END IF;
560:
561: IF PG_BAL_CHECK_ENABLED = 'Y' THEN
562:
601: END IF; --receivable application ids are not null
602:
603: ELSE
604: IF PG_DEBUG in ('Y', 'C') THEN
605: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');
606: END IF;
607: END IF;
608:
609: IF PG_DEBUG in ('Y', 'C') THEN
606: END IF;
607: END IF;
608:
609: IF PG_DEBUG in ('Y', 'C') THEN
610: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE (-) -> for Receipt Applications');
611: END IF;
612:
613: EXCEPTION
614: WHEN NO_DATA_FOUND THEN
614: WHEN NO_DATA_FOUND THEN
615: /* Exception need not be raised as this can happen when the Application
616: is non postable */
617: IF PG_DEBUG in ('Y', 'C') THEN
618: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - NO_DATA_FOUND');
619: END IF;
620: WHEN out_of_balance THEN
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
618: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - NO_DATA_FOUND');
619: END IF;
620: WHEN out_of_balance THEN
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
623: arp_standard.debug('Receivable Application_id1 = '||p_receivable_application_id1);
624: arp_standard.debug('Receivable Application_id2 = '||p_receivable_application_id2);
625: arp_standard.debug('Amount Debit = '||l_amt_dr);
626: arp_standard.debug('Amount Credit = '||l_amt_cr);
619: END IF;
620: WHEN out_of_balance THEN
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
623: arp_standard.debug('Receivable Application_id1 = '||p_receivable_application_id1);
624: arp_standard.debug('Receivable Application_id2 = '||p_receivable_application_id2);
625: arp_standard.debug('Amount Debit = '||l_amt_dr);
626: arp_standard.debug('Amount Credit = '||l_amt_cr);
627: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);
620: WHEN out_of_balance THEN
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
623: arp_standard.debug('Receivable Application_id1 = '||p_receivable_application_id1);
624: arp_standard.debug('Receivable Application_id2 = '||p_receivable_application_id2);
625: arp_standard.debug('Amount Debit = '||l_amt_dr);
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);
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
623: arp_standard.debug('Receivable Application_id1 = '||p_receivable_application_id1);
624: arp_standard.debug('Receivable Application_id2 = '||p_receivable_application_id2);
625: arp_standard.debug('Amount Debit = '||l_amt_dr);
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;
622: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OUT_OF_BALANCE');
623: arp_standard.debug('Receivable Application_id1 = '||p_receivable_application_id1);
624: arp_standard.debug('Receivable Application_id2 = '||p_receivable_application_id2);
625: arp_standard.debug('Amount Debit = '||l_amt_dr);
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');
623: arp_standard.debug('Receivable Application_id1 = '||p_receivable_application_id1);
624: arp_standard.debug('Receivable Application_id2 = '||p_receivable_application_id2);
625: arp_standard.debug('Amount Debit = '||l_amt_dr);
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;
624: arp_standard.debug('Receivable Application_id2 = '||p_receivable_application_id2);
625: arp_standard.debug('Amount Debit = '||l_amt_dr);
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
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');
635: END IF;
636: RAISE;
637:
638: END CHECK_APPLN_BALANCE;