eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_BALANCE_CHECK dependencies on ARP_STANDARD

Line 57: arp_standard.debug('ARP_BALANCE_CHK.Check_Transaction_Balance (+)' );

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:

Line 100: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));

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;

Line 101: arp_standard.debug('Net Amount :' || l_amount);

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:

Line 102: arp_standard.debug('Net Acctd Amount :' || l_acctd_amount);

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: --------------------------------------------------------

Line 122: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');

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:

Line 128: arp_standard.debug('ARP_BALANCE_CHK.Check_Transaction_Balance (-)' );

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

Line 134: arp_standard.debug('ARP_BALANCE_CHK.Check_Transaction_Balance - OUT_OF_BALANCE');

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

Line 141: arp_standard.debug( 'ARP_BALANCE_CHK.Check_Transaction_Balance - NO_DATA_FOUND' );

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);

Line 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:

Line 146: arp_standard.debug('last error:'||l_msg_data);

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

Line 152: arp_standard.debug( 'ARP_BALANCE_CHK.Check_Transaction_Balance - OTHERS' );

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;

Line 223: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_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:

Line 241: arp_standard.debug('GL_DATE : '||to_char(c2.gl_date,'DD-MON-YYYY'));

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);

Line 242: arp_standard.debug('Sum_amount_dr :' || c2.sum_amount_dr);

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);

Line 243: arp_standard.debug('Sum_amount_cr :' || c2.sum_amount_cr);

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;

Line 244: arp_standard.debug('Sum_acctd_amount_dr : '||c2.sum_acctd_amount_dr);

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;

Line 245: arp_standard.debug('Sum_acctd_amount_cr : '||c2.sum_acctd_amount_cr);

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:

Line 246: arp_standard.debug('CC_flag : '||c2.cc_flag);

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: --------------------------------------------------------

Line 268: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');

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:

Line 274: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE (-)');

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

Line 280: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OUT_OF_BALANCE');

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:

Line 287: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OTHERS');

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;

Line 324: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_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:

Line 386: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');

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

Line 391: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE (-)');

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

Line 397: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - NO_DATA_FOUND');

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

Line 402: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - OUT_OF_BALANCE');

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);

Line 403: arp_standard.debug('Adjustment_id = '||p_adj_id);

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);

Line 404: arp_standard.debug('Amount Debit = '||l_amt_dr);

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;

Line 405: arp_standard.debug('Amount Credit = '||l_amt_cr);

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');

Line 406: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);

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;

Line 407: arp_standard.debug('Acctd AmountCredit = '||l_acctd_amt_cr);

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:

Line 414: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE -AMOUNT_MISMATCH');

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;

Line 415: arp_standard.debug('Adjustment_id = '||p_adj_id);

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');

Line 416: arp_standard.debug('Amount = '||l_amount);

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;

Line 417: arp_standard.debug('Sum of Buckets = '||l_calc_amount);

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

Line 423: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OTHERS');

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;

Line 455: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_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:

Line 495: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');

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

Line 500: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE (-)');

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

Line 508: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - NO_DATA_FOUND');

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');

Line 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);

Line 513: arp_standard.debug('Receivable Application_id = '||p_receivable_application_id);

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);

Line 514: arp_standard.debug('Amount Debit = '||l_amt_dr);

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;

Line 515: arp_standard.debug('Amount Credit = '||l_amt_cr);

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');

Line 516: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);

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;

Line 517: arp_standard.debug('Acctd AmountCredit = '||l_acctd_amt_cr);

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

Line 523: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OTHERS');

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;

Line 558: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE (+) -> for Receipt Applications');

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:

Line 605: arp_standard.debug('Profile AR: Enable Journal Balance Check is disabled ');

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

Line 610: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE (-) -> for Receipt Applications');

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

Line 618: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - NO_DATA_FOUND');

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');

Line 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);

Line 623: arp_standard.debug('Receivable Application_id1 = '||p_receivable_application_id1);

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);

Line 624: arp_standard.debug('Receivable Application_id2 = '||p_receivable_application_id2);

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);

Line 625: arp_standard.debug('Amount Debit = '||l_amt_dr);

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;

Line 626: arp_standard.debug('Amount Credit = '||l_amt_cr);

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');

Line 627: arp_standard.debug('Acctd Amount Debit = '||l_acctd_amt_dr);

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;

Line 628: arp_standard.debug('Acctd AmountCredit = '||l_acctd_amt_cr);

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

Line 634: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OTHERS -> for Receipt Applications');

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;