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_PROCESS_RETURNS dependencies on ARP_STANDARD

Line 161: arp_standard.fnd_message('AR_RID_MULTIPLE_PMT_TYPES');

157: l_total_unapp_acctd_amount NUMBER;
158: l_rec_in_doubt VARCHAR2(1):='N';
159: l_rid_reason VARCHAR2(2000):= null;
160: l_mult_pmt_types_msg VARCHAR2(2000):=
161: arp_standard.fnd_message('AR_RID_MULTIPLE_PMT_TYPES');
162: l_min_ref_amt_msg VARCHAR2(2000):=
163: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');
164: l_split_term_with_bal_msg VARCHAR2(2000):=
165: arp_standard.fnd_message('AR_RID_SPLIT_TERM_WITH_BAL');

Line 163: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');

159: l_rid_reason VARCHAR2(2000):= null;
160: l_mult_pmt_types_msg VARCHAR2(2000):=
161: arp_standard.fnd_message('AR_RID_MULTIPLE_PMT_TYPES');
162: l_min_ref_amt_msg VARCHAR2(2000):=
163: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');
164: l_split_term_with_bal_msg VARCHAR2(2000):=
165: arp_standard.fnd_message('AR_RID_SPLIT_TERM_WITH_BAL');
166: l_amt_lt_min_ref_amt_msg VARCHAR2(2000):=
167: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');

Line 165: arp_standard.fnd_message('AR_RID_SPLIT_TERM_WITH_BAL');

161: arp_standard.fnd_message('AR_RID_MULTIPLE_PMT_TYPES');
162: l_min_ref_amt_msg VARCHAR2(2000):=
163: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');
164: l_split_term_with_bal_msg VARCHAR2(2000):=
165: arp_standard.fnd_message('AR_RID_SPLIT_TERM_WITH_BAL');
166: l_amt_lt_min_ref_amt_msg VARCHAR2(2000):=
167: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');
168: i NUMBER(15):= 0;
169:

Line 167: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');

163: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');
164: l_split_term_with_bal_msg VARCHAR2(2000):=
165: arp_standard.fnd_message('AR_RID_SPLIT_TERM_WITH_BAL');
166: l_amt_lt_min_ref_amt_msg VARCHAR2(2000):=
167: arp_standard.fnd_message('AR_RID_OAPP_LT_MIN_REF_AMT');
168: i NUMBER(15):= 0;
169:
170: BEGIN
171: --

Line 173: arp_standard.debug('arp_process_returns.process_invoice_list()+ ');

169:
170: BEGIN
171: --
172: IF PG_DEBUG in ('Y', 'C') THEN
173: arp_standard.debug('arp_process_returns.process_invoice_list()+ ');
174: END IF;
175: --
176: -- Check if there are any Invoices to process in the list
177: --

Line 180: arp_standard.debug('No Invoice in the list to process..');

176: -- Check if there are any Invoices to process in the list
177: --
178: IF inv_info.COUNT = 0 THEN
179: IF PG_DEBUG in ('Y', 'C') THEN
180: arp_standard.debug('No Invoice in the list to process..');
181: END IF;
182: GOTO after_loop;
183: END IF;
184: --

Line 193: arp_standard.debug('INV Customer Trx ID [' || i || ']');

189: WHILE i IS NOT NULL
190: LOOP
191: --
192: IF PG_DEBUG in ('Y', 'C') THEN
193: arp_standard.debug('INV Customer Trx ID [' || i || ']');
194: END IF;
195: --
196: FOR c01_rec IN c01 (i) LOOP
197: --

Line 199: arp_standard.debug('CM count [' || inv_info(i).num_of_cms || ']');

195: --
196: FOR c01_rec IN c01 (i) LOOP
197: --
198: IF PG_DEBUG in ('Y', 'C') THEN
199: arp_standard.debug('CM count [' || inv_info(i).num_of_cms || ']');
200: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');
201: arp_standard.debug('PS count [' || c01_rec.ps_count || ']');
202: arp_standard.debug('Inv App Amount [' ||
203: c01_rec.inv_app_amount || ']');

Line 200: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');

196: FOR c01_rec IN c01 (i) LOOP
197: --
198: IF PG_DEBUG in ('Y', 'C') THEN
199: arp_standard.debug('CM count [' || inv_info(i).num_of_cms || ']');
200: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');
201: arp_standard.debug('PS count [' || c01_rec.ps_count || ']');
202: arp_standard.debug('Inv App Amount [' ||
203: c01_rec.inv_app_amount || ']');
204: arp_standard.debug('Commitment Adj amt [' ||

Line 201: arp_standard.debug('PS count [' || c01_rec.ps_count || ']');

197: --
198: IF PG_DEBUG in ('Y', 'C') THEN
199: arp_standard.debug('CM count [' || inv_info(i).num_of_cms || ']');
200: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');
201: arp_standard.debug('PS count [' || c01_rec.ps_count || ']');
202: arp_standard.debug('Inv App Amount [' ||
203: c01_rec.inv_app_amount || ']');
204: arp_standard.debug('Commitment Adj amt [' ||
205: c01_rec.cmt_adj_amount || ']');

Line 202: arp_standard.debug('Inv App Amount [' ||

198: IF PG_DEBUG in ('Y', 'C') THEN
199: arp_standard.debug('CM count [' || inv_info(i).num_of_cms || ']');
200: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');
201: arp_standard.debug('PS count [' || c01_rec.ps_count || ']');
202: arp_standard.debug('Inv App Amount [' ||
203: c01_rec.inv_app_amount || ']');
204: arp_standard.debug('Commitment Adj amt [' ||
205: c01_rec.cmt_adj_amount || ']');
206: arp_standard.debug('Adj amt [' || c01_rec.adj_amount || ']');

Line 204: arp_standard.debug('Commitment Adj amt [' ||

200: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');
201: arp_standard.debug('PS count [' || c01_rec.ps_count || ']');
202: arp_standard.debug('Inv App Amount [' ||
203: c01_rec.inv_app_amount || ']');
204: arp_standard.debug('Commitment Adj amt [' ||
205: c01_rec.cmt_adj_amount || ']');
206: arp_standard.debug('Adj amt [' || c01_rec.adj_amount || ']');
207: arp_standard.debug('CM amt [' || c01_rec.cm_amount || ']');
208: END IF;

Line 206: arp_standard.debug('Adj amt [' || c01_rec.adj_amount || ']');

202: arp_standard.debug('Inv App Amount [' ||
203: c01_rec.inv_app_amount || ']');
204: arp_standard.debug('Commitment Adj amt [' ||
205: c01_rec.cmt_adj_amount || ']');
206: arp_standard.debug('Adj amt [' || c01_rec.adj_amount || ']');
207: arp_standard.debug('CM amt [' || c01_rec.cm_amount || ']');
208: END IF;
209: --
210: -- If adjustment exists then raise exception ***/

Line 207: arp_standard.debug('CM amt [' || c01_rec.cm_amount || ']');

203: c01_rec.inv_app_amount || ']');
204: arp_standard.debug('Commitment Adj amt [' ||
205: c01_rec.cmt_adj_amount || ']');
206: arp_standard.debug('Adj amt [' || c01_rec.adj_amount || ']');
207: arp_standard.debug('CM amt [' || c01_rec.cm_amount || ']');
208: END IF;
209: --
210: -- If adjustment exists then raise exception ***/
211: --

Line 213: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||

209: --
210: -- If adjustment exists then raise exception ***/
211: --
212: IF c01_rec.adj_amount <> 0 THEN
213: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||
214: 'adj_EXCEPTION customer_trx_id <' || c01_rec.inv_customer_trx_id ||
215: '>');
216: RAISE adj_exception;
217: END IF;

Line 234: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||

230: --
231: -- If Total Unapp amount > Applied amount then raise exception
232: --
233: IF l_total_unapp_amount > (c01_rec.inv_app_amount) THEN
234: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||
235: 'overapp_EXCEPTION customer_trx_id <'
236: || c01_rec.inv_customer_trx_id || '>');
237: arp_standard.debug('Inv Balance : <' || c01_rec.inv_balance);
238: arp_standard.debug('Inv App Amount : <' || c01_rec.inv_app_amount);

Line 237: arp_standard.debug('Inv Balance : <' || c01_rec.inv_balance);

233: IF l_total_unapp_amount > (c01_rec.inv_app_amount) THEN
234: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||
235: 'overapp_EXCEPTION customer_trx_id <'
236: || c01_rec.inv_customer_trx_id || '>');
237: arp_standard.debug('Inv Balance : <' || c01_rec.inv_balance);
238: arp_standard.debug('Inv App Amount : <' || c01_rec.inv_app_amount);
239: arp_standard.debug('Cmt Adj Amount : <' || c01_rec.cmt_adj_amount);
240: arp_standard.debug('CM Amount : <' || c01_rec.cm_amount);
241: RAISE overapp_exception;

Line 238: arp_standard.debug('Inv App Amount : <' || c01_rec.inv_app_amount);

234: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||
235: 'overapp_EXCEPTION customer_trx_id <'
236: || c01_rec.inv_customer_trx_id || '>');
237: arp_standard.debug('Inv Balance : <' || c01_rec.inv_balance);
238: arp_standard.debug('Inv App Amount : <' || c01_rec.inv_app_amount);
239: arp_standard.debug('Cmt Adj Amount : <' || c01_rec.cmt_adj_amount);
240: arp_standard.debug('CM Amount : <' || c01_rec.cm_amount);
241: RAISE overapp_exception;
242: END IF;

Line 239: arp_standard.debug('Cmt Adj Amount : <' || c01_rec.cmt_adj_amount);

235: 'overapp_EXCEPTION customer_trx_id <'
236: || c01_rec.inv_customer_trx_id || '>');
237: arp_standard.debug('Inv Balance : <' || c01_rec.inv_balance);
238: arp_standard.debug('Inv App Amount : <' || c01_rec.inv_app_amount);
239: arp_standard.debug('Cmt Adj Amount : <' || c01_rec.cmt_adj_amount);
240: arp_standard.debug('CM Amount : <' || c01_rec.cm_amount);
241: RAISE overapp_exception;
242: END IF;
243:

Line 240: arp_standard.debug('CM Amount : <' || c01_rec.cm_amount);

236: || c01_rec.inv_customer_trx_id || '>');
237: arp_standard.debug('Inv Balance : <' || c01_rec.inv_balance);
238: arp_standard.debug('Inv App Amount : <' || c01_rec.inv_app_amount);
239: arp_standard.debug('Cmt Adj Amount : <' || c01_rec.cmt_adj_amount);
240: arp_standard.debug('CM Amount : <' || c01_rec.cm_amount);
241: RAISE overapp_exception;
242: END IF;
243:
244: --

Line 323: arp_standard.debug('Calling unapply_receipts...');

319:
320: END IF; -- receipt_handling option
321: --
322: IF PG_DEBUG in ('Y', 'C') THEN
323: arp_standard.debug('Calling unapply_receipts...');
324: arp_standard.debug('Inv Customer Trx ID [' ||
325: c01_rec.inv_customer_trx_id || ']');
326: arp_standard.debug('RecHandOption [' ||
327: c01_rec.receipt_handling_option || ']');

Line 324: arp_standard.debug('Inv Customer Trx ID [' ||

320: END IF; -- receipt_handling option
321: --
322: IF PG_DEBUG in ('Y', 'C') THEN
323: arp_standard.debug('Calling unapply_receipts...');
324: arp_standard.debug('Inv Customer Trx ID [' ||
325: c01_rec.inv_customer_trx_id || ']');
326: arp_standard.debug('RecHandOption [' ||
327: c01_rec.receipt_handling_option || ']');
328: arp_standard.debug('Unapp amount [' || l_total_unapp_amount || ']');

Line 326: arp_standard.debug('RecHandOption [' ||

322: IF PG_DEBUG in ('Y', 'C') THEN
323: arp_standard.debug('Calling unapply_receipts...');
324: arp_standard.debug('Inv Customer Trx ID [' ||
325: c01_rec.inv_customer_trx_id || ']');
326: arp_standard.debug('RecHandOption [' ||
327: c01_rec.receipt_handling_option || ']');
328: arp_standard.debug('Unapp amount [' || l_total_unapp_amount || ']');
329: arp_standard.debug('RID Reason [' || inv_info(i).rid_reason || ']');
330: IF inv_info(i).all_recs_in_doubt THEN

Line 328: arp_standard.debug('Unapp amount [' || l_total_unapp_amount || ']');

324: arp_standard.debug('Inv Customer Trx ID [' ||
325: c01_rec.inv_customer_trx_id || ']');
326: arp_standard.debug('RecHandOption [' ||
327: c01_rec.receipt_handling_option || ']');
328: arp_standard.debug('Unapp amount [' || l_total_unapp_amount || ']');
329: arp_standard.debug('RID Reason [' || inv_info(i).rid_reason || ']');
330: IF inv_info(i).all_recs_in_doubt THEN
331: arp_standard.debug('Rec In doubt ');
332: ELSE

Line 329: arp_standard.debug('RID Reason [' || inv_info(i).rid_reason || ']');

325: c01_rec.inv_customer_trx_id || ']');
326: arp_standard.debug('RecHandOption [' ||
327: c01_rec.receipt_handling_option || ']');
328: arp_standard.debug('Unapp amount [' || l_total_unapp_amount || ']');
329: arp_standard.debug('RID Reason [' || inv_info(i).rid_reason || ']');
330: IF inv_info(i).all_recs_in_doubt THEN
331: arp_standard.debug('Rec In doubt ');
332: ELSE
333: arp_standard.debug('Rec NOT In doubt ');

Line 331: arp_standard.debug('Rec In doubt ');

327: c01_rec.receipt_handling_option || ']');
328: arp_standard.debug('Unapp amount [' || l_total_unapp_amount || ']');
329: arp_standard.debug('RID Reason [' || inv_info(i).rid_reason || ']');
330: IF inv_info(i).all_recs_in_doubt THEN
331: arp_standard.debug('Rec In doubt ');
332: ELSE
333: arp_standard.debug('Rec NOT In doubt ');
334: END IF;
335: END IF;

Line 333: arp_standard.debug('Rec NOT In doubt ');

329: arp_standard.debug('RID Reason [' || inv_info(i).rid_reason || ']');
330: IF inv_info(i).all_recs_in_doubt THEN
331: arp_standard.debug('Rec In doubt ');
332: ELSE
333: arp_standard.debug('Rec NOT In doubt ');
334: END IF;
335: END IF;
336:
337: --

Line 355: arp_standard.debug('arp_process_RETURNS.process_invoice_list()- ');

351: --
352: <>
353: --
354: IF PG_DEBUG in ('Y', 'C') THEN
355: arp_standard.debug('arp_process_RETURNS.process_invoice_list()- ');
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: arp_standard.debug('EXCEPTION : arp_process_returns.process_invoice_list : ' || SQLERRM(SQLCODE));

Line 359: arp_standard.debug('EXCEPTION : arp_process_returns.process_invoice_list : ' || SQLERRM(SQLCODE));

355: arp_standard.debug('arp_process_RETURNS.process_invoice_list()- ');
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: arp_standard.debug('EXCEPTION : arp_process_returns.process_invoice_list : ' || SQLERRM(SQLCODE));
360: RAISE;
361: END process_invoice_list;
362:
363: /*========================================================================

Line 429: arp_standard.fnd_message('AR_RID_PROCESSED_AS_PER_REQ');

425: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
426: l_msg_count NUMBER;
427: l_msg_data VARCHAR2(2000);
428: l_app_comments ar_receivable_applications.comments%type :=
429: arp_standard.fnd_message('AR_RID_PROCESSED_AS_PER_REQ');
430: l_application_ref_type ar_receivable_applications.application_ref_type%type;
431: l_application_ref_id ar_receivable_applications.application_ref_id%type;
432: l_application_ref_num ar_receivable_applications.application_ref_num%type;
433: l_receivable_application_id ar_receivable_applications.receivable_application_id%type;

Line 441: arp_standard.debug('arp_process_returns.process_application_list()+ ');

437: l_dff_rec ar_receipt_api_pub.attribute_rec_type;
438: l_party_id hz_parties.party_id%type;
439: BEGIN
440: IF PG_DEBUG in ('Y', 'C') THEN
441: arp_standard.debug('arp_process_returns.process_application_list()+ ');
442: END IF;
443: --
444: -- Check if there are any applications to process in the list
445: --

Line 448: arp_standard.debug('No Application in the list to process..');

444: -- Check if there are any applications to process in the list
445: --
446: IF app_info.COUNT = 0 THEN
447: IF PG_DEBUG in ('Y', 'C') THEN
448: arp_standard.debug('No Application in the list to process..');
449: END IF;
450: GOTO after_loop;
451: END IF;
452: --

Line 461: arp_standard.debug('INV Customer Trx ID [' ||

457: --
458: --
459: --
460: IF PG_DEBUG in ('Y', 'C') THEN
461: arp_standard.debug('INV Customer Trx ID [' ||
462: app_tab(i).applied_customer_trx_id || ']');
463: arp_standard.debug('rec_proc_option [' ||
464: app_info(i).rec_proc_option || ']');
465: arp_standard.debug('rec_in_doubt [' ||

Line 463: arp_standard.debug('rec_proc_option [' ||

459: --
460: IF PG_DEBUG in ('Y', 'C') THEN
461: arp_standard.debug('INV Customer Trx ID [' ||
462: app_tab(i).applied_customer_trx_id || ']');
463: arp_standard.debug('rec_proc_option [' ||
464: app_info(i).rec_proc_option || ']');
465: arp_standard.debug('rec_in_doubt [' ||
466: app_info(i).rec_in_doubt || ']');
467: arp_standard.debug('rec_currency_code [' ||

Line 465: arp_standard.debug('rec_in_doubt [' ||

461: arp_standard.debug('INV Customer Trx ID [' ||
462: app_tab(i).applied_customer_trx_id || ']');
463: arp_standard.debug('rec_proc_option [' ||
464: app_info(i).rec_proc_option || ']');
465: arp_standard.debug('rec_in_doubt [' ||
466: app_info(i).rec_in_doubt || ']');
467: arp_standard.debug('rec_currency_code [' ||
468: app_info(i).rec_currency_code || ']');
469: arp_standard.debug('inv_currency_code [' ||

Line 467: arp_standard.debug('rec_currency_code [' ||

463: arp_standard.debug('rec_proc_option [' ||
464: app_info(i).rec_proc_option || ']');
465: arp_standard.debug('rec_in_doubt [' ||
466: app_info(i).rec_in_doubt || ']');
467: arp_standard.debug('rec_currency_code [' ||
468: app_info(i).rec_currency_code || ']');
469: arp_standard.debug('inv_currency_code [' ||
470: app_info(i).inv_currency_code || ']');
471: arp_standard.debug('rid_reason [' ||

Line 469: arp_standard.debug('inv_currency_code [' ||

465: arp_standard.debug('rec_in_doubt [' ||
466: app_info(i).rec_in_doubt || ']');
467: arp_standard.debug('rec_currency_code [' ||
468: app_info(i).rec_currency_code || ']');
469: arp_standard.debug('inv_currency_code [' ||
470: app_info(i).inv_currency_code || ']');
471: arp_standard.debug('rid_reason [' ||
472: app_info(i).rid_reason || ']');
473: arp_standard.debug('trx_number [' ||

Line 471: arp_standard.debug('rid_reason [' ||

467: arp_standard.debug('rec_currency_code [' ||
468: app_info(i).rec_currency_code || ']');
469: arp_standard.debug('inv_currency_code [' ||
470: app_info(i).inv_currency_code || ']');
471: arp_standard.debug('rid_reason [' ||
472: app_info(i).rid_reason || ']');
473: arp_standard.debug('trx_number [' ||
474: app_info(i).trx_number || ']');
475: END IF;

Line 473: arp_standard.debug('trx_number [' ||

469: arp_standard.debug('inv_currency_code [' ||
470: app_info(i).inv_currency_code || ']');
471: arp_standard.debug('rid_reason [' ||
472: app_info(i).rid_reason || ']');
473: arp_standard.debug('trx_number [' ||
474: app_info(i).trx_number || ']');
475: END IF;
476: --
477: FOR c01_rec IN c01 (app_tab(i).applied_payment_schedule_id)

Line 481: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');

477: FOR c01_rec IN c01 (app_tab(i).applied_payment_schedule_id)
478: LOOP
479: --
480: IF PG_DEBUG in ('Y', 'C') THEN
481: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');
482: arp_standard.debug('Inv Customer Trx Id [' || c01_rec.inv_customer_trx_id || ']');
483: END IF;
484: --
485: -- Compute reapply amount ** 1 **

Line 482: arp_standard.debug('Inv Customer Trx Id [' || c01_rec.inv_customer_trx_id || ']');

478: LOOP
479: --
480: IF PG_DEBUG in ('Y', 'C') THEN
481: arp_standard.debug('Inv Balance [' || c01_rec.inv_balance || ']');
482: arp_standard.debug('Inv Customer Trx Id [' || c01_rec.inv_customer_trx_id || ']');
483: END IF;
484: --
485: -- Compute reapply amount ** 1 **
486: --

Line 493: arp_standard.debug(' l_reapply_amount [' || l_reapply_amount || ']');

489:
490:
491:
492: IF PG_DEBUG in ('Y', 'C') THEN
493: arp_standard.debug(' l_reapply_amount [' || l_reapply_amount || ']');
494: END IF;
495:
496: IF l_reapply_amount > 0 THEN
497: --

Line 513: arp_standard.debug(' l_new_apply_amount [' || l_new_apply_amount || ']');

509: --
510: END IF;
511:
512: IF PG_DEBUG in ('Y', 'C') THEN
513: arp_standard.debug(' l_new_apply_amount [' || l_new_apply_amount || ']');
514: END IF;
515:
516:
517: --

Line 530: arp_standard.debug('Re-apply back to invoice ps[' ||

526: --
527: -- Re-apply to the application to the same invoice
528: --
529: IF PG_DEBUG in ('Y', 'C') THEN
530: arp_standard.debug('Re-apply back to invoice ps[' ||
531: app_tab(i).applied_payment_schedule_id ||'] : <' ||
532: l_reapply_amount|| '>');
533: END IF;
534: --

Line 563: arp_standard.debug('Apply: ' || l_MSG_DATA);

559:
560: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
561:
562: IF (l_msg_count = 1) THEN
563: arp_standard.debug('Apply: ' || l_MSG_DATA);
564: ELSIF(l_MSG_COUNT>1)THEN
565: LOOP
566: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
567: IF (l_MSG_DATA IS NULL)THEN

Line 570: arp_standard.debug('Apply : ' || l_MSG_DATA);

566: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
567: IF (l_MSG_DATA IS NULL)THEN
568: EXIT;
569: END IF;
570: arp_standard.debug('Apply : ' || l_MSG_DATA);
571: END LOOP;
572: END IF;
573:
574: arp_standard.debug('Apply failed');

Line 574: arp_standard.debug('Apply failed');

570: arp_standard.debug('Apply : ' || l_MSG_DATA);
571: END LOOP;
572: END IF;
573:
574: arp_standard.debug('Apply failed');
575:
576: RAISE l_apply_failed;
577:
578: END IF;

Line 601: arp_standard.debug('Cross Currency');

597: --
598: IF app_info(i).cross_currency THEN
599: --
600: IF PG_DEBUG in ('Y', 'C') THEN
601: arp_standard.debug('Cross Currency');
602: arp_standard.debug('Re-apply Amount :' || l_reapply_amount);
603: arp_standard.debug('New-apply Amount :' || l_new_apply_amount);
604: arp_standard.debug('T->R Rate :' ||
605: app_tab(i).trans_to_receipt_rate);

Line 602: arp_standard.debug('Re-apply Amount :' || l_reapply_amount);

598: IF app_info(i).cross_currency THEN
599: --
600: IF PG_DEBUG in ('Y', 'C') THEN
601: arp_standard.debug('Cross Currency');
602: arp_standard.debug('Re-apply Amount :' || l_reapply_amount);
603: arp_standard.debug('New-apply Amount :' || l_new_apply_amount);
604: arp_standard.debug('T->R Rate :' ||
605: app_tab(i).trans_to_receipt_rate);
606: arp_standard.debug('Currency REC :' ||

Line 603: arp_standard.debug('New-apply Amount :' || l_new_apply_amount);

599: --
600: IF PG_DEBUG in ('Y', 'C') THEN
601: arp_standard.debug('Cross Currency');
602: arp_standard.debug('Re-apply Amount :' || l_reapply_amount);
603: arp_standard.debug('New-apply Amount :' || l_new_apply_amount);
604: arp_standard.debug('T->R Rate :' ||
605: app_tab(i).trans_to_receipt_rate);
606: arp_standard.debug('Currency REC :' ||
607: app_info(i).rec_currency_code);

Line 604: arp_standard.debug('T->R Rate :' ||

600: IF PG_DEBUG in ('Y', 'C') THEN
601: arp_standard.debug('Cross Currency');
602: arp_standard.debug('Re-apply Amount :' || l_reapply_amount);
603: arp_standard.debug('New-apply Amount :' || l_new_apply_amount);
604: arp_standard.debug('T->R Rate :' ||
605: app_tab(i).trans_to_receipt_rate);
606: arp_standard.debug('Currency REC :' ||
607: app_info(i).rec_currency_code);
608: END IF;

Line 606: arp_standard.debug('Currency REC :' ||

602: arp_standard.debug('Re-apply Amount :' || l_reapply_amount);
603: arp_standard.debug('New-apply Amount :' || l_new_apply_amount);
604: arp_standard.debug('T->R Rate :' ||
605: app_tab(i).trans_to_receipt_rate);
606: arp_standard.debug('Currency REC :' ||
607: app_info(i).rec_currency_code);
608: END IF;
609: --
610: /***

Line 624: arp_standard.debug('Not Cross Currency');

620: l_new_apply_amount_fr;
621: --
622: ELSE
623: IF PG_DEBUG in ('Y', 'C') THEN
624: arp_standard.debug('Not Cross Currency');
625: arp_standard.debug('Old Amount Applied :' ||
626: app_tab(i).amount_applied );
627: arp_standard.debug('New Amount Applied :' ||
628: l_new_apply_amount);

Line 625: arp_standard.debug('Old Amount Applied :' ||

621: --
622: ELSE
623: IF PG_DEBUG in ('Y', 'C') THEN
624: arp_standard.debug('Not Cross Currency');
625: arp_standard.debug('Old Amount Applied :' ||
626: app_tab(i).amount_applied );
627: arp_standard.debug('New Amount Applied :' ||
628: l_new_apply_amount);
629: END IF;

Line 627: arp_standard.debug('New Amount Applied :' ||

623: IF PG_DEBUG in ('Y', 'C') THEN
624: arp_standard.debug('Not Cross Currency');
625: arp_standard.debug('Old Amount Applied :' ||
626: app_tab(i).amount_applied );
627: arp_standard.debug('New Amount Applied :' ||
628: l_new_apply_amount);
629: END IF;
630: l_ch_apply_amount_fr := app_tab(i).amount_applied -
631: l_new_apply_amount;

Line 635: arp_standard.debug('Change in App amount [' ||

631: l_new_apply_amount;
632: END IF;
633: --
634: IF PG_DEBUG in ('Y', 'C') THEN
635: arp_standard.debug('Change in App amount [' ||
636: app_tab(i).applied_payment_schedule_id ||'] : <' ||
637: l_ch_apply_amount_fr || '>');
638: END IF;
639: --

Line 656: arp_standard.debug('Refunding...');

652: --
653: l_refunding := TRUE;
654: --
655: IF PG_DEBUG in ('Y', 'C') THEN
656: arp_standard.debug('Refunding...');
657: END IF;
658: --
659: -- Get receipt amount and old refund amounts from the receipt
660: --

Line 668: arp_standard.debug('Cash Receipt Id ' ||

664: x_refund_amount=>l_old_refund_amount,
665: x_rec_proc_option=> app_info(i).rec_proc_option);
666: --
667: IF PG_DEBUG in ('Y', 'C') THEN
668: arp_standard.debug('Cash Receipt Id ' ||
669: app_tab(i).cash_receipt_id ||'] : RecAmt<' ||
670: l_receipt_amount|| '>' );
671: arp_standard.debug('Old Refund Amount :[' ||
672: l_old_refund_amount ||']');

Line 671: arp_standard.debug('Old Refund Amount :[' ||

667: IF PG_DEBUG in ('Y', 'C') THEN
668: arp_standard.debug('Cash Receipt Id ' ||
669: app_tab(i).cash_receipt_id ||'] : RecAmt<' ||
670: l_receipt_amount|| '>' );
671: arp_standard.debug('Old Refund Amount :[' ||
672: l_old_refund_amount ||']');
673: END IF;
674: --
675: --

Line 687: arp_standard.debug('New Refund Amount [' || l_refund_amount || ']');

683: l_refund_amount := 0;
684: END IF;
685: --
686: IF PG_DEBUG in ('Y', 'C') THEN
687: arp_standard.debug('New Refund Amount [' || l_refund_amount || ']');
688: END IF;
689:
690: --GGADHAMS Added for Payment Refund
691: IF app_info(i).rec_in_doubt = 'N' AND

Line 697: arp_standard.debug('Payment Refunding...');

693: --
694: l_refunding := TRUE;
695: --
696: IF PG_DEBUG in ('Y', 'C') THEN
697: arp_standard.debug('Payment Refunding...');
698: END IF;
699: --
700: -- Get receipt amount and old refund amounts from the receipt
701: --

Line 709: arp_standard.debug('Cash Receipt Id ' ||

705: x_refund_amount=>l_old_refund_amount,
706: x_rec_proc_option=> app_info(i).rec_proc_option);
707: --
708: IF PG_DEBUG in ('Y', 'C') THEN
709: arp_standard.debug('Cash Receipt Id ' ||
710: app_tab(i).cash_receipt_id ||'] : RecAmt<' ||
711: l_receipt_amount|| '>' );
712: arp_standard.debug('Old Refund Amount :[' ||
713: l_old_refund_amount ||']');

Line 712: arp_standard.debug('Old Refund Amount :[' ||

708: IF PG_DEBUG in ('Y', 'C') THEN
709: arp_standard.debug('Cash Receipt Id ' ||
710: app_tab(i).cash_receipt_id ||'] : RecAmt<' ||
711: l_receipt_amount|| '>' );
712: arp_standard.debug('Old Refund Amount :[' ||
713: l_old_refund_amount ||']');
714: END IF;
715: --
716: --

Line 728: arp_standard.debug('New Payment Refund Amount [' || l_pay_refund_amount || ']');

724: l_pay_refund_amount := 0;
725: END IF;
726: --
727: IF PG_DEBUG in ('Y', 'C') THEN
728: arp_standard.debug('New Payment Refund Amount [' || l_pay_refund_amount || ']');
729: END IF;
730: --Added till here for Payment Refund
731: --
732:

Line 740: arp_standard.debug('On Account Amount [' ||

736: --
737: l_on_account_amount := l_ch_apply_amount_fr - l_refund_amount - l_pay_refund_amount;
738: --
739: IF PG_DEBUG in ('Y', 'C') THEN
740: arp_standard.debug('On Account Amount [' ||
741: l_on_account_amount|| ']');
742: END IF;
743: --
744: --

Line 750: arp_standard.debug('Creating CCR application..');

746: --
747: IF l_refund_amount > 0 THEN
748: -- Apply to CCR
749: IF PG_DEBUG in ('Y', 'C') THEN
750: arp_standard.debug('Creating CCR application..');
751: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');
752: END IF;
753: --
754: -- Initialize IN-OUT variables

Line 751: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');

747: IF l_refund_amount > 0 THEN
748: -- Apply to CCR
749: IF PG_DEBUG in ('Y', 'C') THEN
750: arp_standard.debug('Creating CCR application..');
751: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');
752: END IF;
753: --
754: -- Initialize IN-OUT variables
755: --

Line 795: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);

791:
792: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793:
794: IF (l_msg_count = 1) THEN
795: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);
796: ELSIF(l_MSG_COUNT>1)THEN
797: LOOP
798: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
799: IF (l_MSG_DATA IS NULL)THEN

Line 802: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);

798: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
799: IF (l_MSG_DATA IS NULL)THEN
800: EXIT;
801: END IF;
802: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);
803: END LOOP;
804: END IF;
805:
806: arp_standard.debug('ActivityApp failed');

Line 806: arp_standard.debug('ActivityApp failed');

802: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);
803: END LOOP;
804: END IF;
805:
806: arp_standard.debug('ActivityApp failed');
807:
808: RAISE l_activity_app_failed;
809: END IF; -- Handle API errors
810: --

Line 819: arp_standard.debug('Creating ON-ACCOUNT application..');

815: IF l_on_account_amount > 0 THEN
816: --
817: -- Apply to ON-ACCOUNT
818: IF PG_DEBUG in ('Y', 'C') THEN
819: arp_standard.debug('Creating ON-ACCOUNT application..');
820: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');
821: arp_standard.debug('l_app_comments NVL:[' ||
822: NVL(app_info(i).rid_reason, l_app_comments) ||']');
823: END IF;

Line 820: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');

816: --
817: -- Apply to ON-ACCOUNT
818: IF PG_DEBUG in ('Y', 'C') THEN
819: arp_standard.debug('Creating ON-ACCOUNT application..');
820: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');
821: arp_standard.debug('l_app_comments NVL:[' ||
822: NVL(app_info(i).rid_reason, l_app_comments) ||']');
823: END IF;
824: --

Line 821: arp_standard.debug('l_app_comments NVL:[' ||

817: -- Apply to ON-ACCOUNT
818: IF PG_DEBUG in ('Y', 'C') THEN
819: arp_standard.debug('Creating ON-ACCOUNT application..');
820: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');
821: arp_standard.debug('l_app_comments NVL:[' ||
822: NVL(app_info(i).rid_reason, l_app_comments) ||']');
823: END IF;
824: --
825: --

Line 827: l_app_comments := arp_standard.fnd_message('AR_RID_TOTAL_REFUND_LIMIT');

823: END IF;
824: --
825: --
826: IF l_refunding THEN
827: l_app_comments := arp_standard.fnd_message('AR_RID_TOTAL_REFUND_LIMIT');
828: END IF;
829: ar_receipt_api_pub.Apply_on_account(
830: p_api_version => 1.0,
831: x_return_status => l_return_status,

Line 848: arp_standard.debug('OnaccountApp: ' || l_MSG_DATA);

844: );
845: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
846:
847: IF (l_msg_count = 1) THEN
848: arp_standard.debug('OnaccountApp: ' || l_MSG_DATA);
849: ELSIF(l_MSG_COUNT>1)THEN
850: LOOP
851: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
852: IF (l_MSG_DATA IS NULL)THEN

Line 855: arp_standard.debug('OnaccountApp : ' || l_MSG_DATA);

851: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
852: IF (l_MSG_DATA IS NULL)THEN
853: EXIT;
854: END IF;
855: arp_standard.debug('OnaccountApp : ' || l_MSG_DATA);
856: END LOOP;
857: END IF;
858:
859: arp_standard.debug('OnaccountApp failed');

Line 859: arp_standard.debug('OnaccountApp failed');

855: arp_standard.debug('OnaccountApp : ' || l_MSG_DATA);
856: END LOOP;
857: END IF;
858:
859: arp_standard.debug('OnaccountApp failed');
860:
861: RAISE l_on_account_app_failed;
862:
863: END IF;

Line 882: arp_standard.debug('Creating Payment Refund application..');

878: l_application_ref_num := null;
879:
880: -- Apply to PAYMENT REFUND
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_standard.debug('Creating Payment Refund application..');
883: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');
884: arp_standard.debug('l_app_comments NVL:[' ||
885: NVL(app_info(i).rid_reason, l_app_comments) ||']');
886: END IF;

Line 883: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');

879:
880: -- Apply to PAYMENT REFUND
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_standard.debug('Creating Payment Refund application..');
883: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');
884: arp_standard.debug('l_app_comments NVL:[' ||
885: NVL(app_info(i).rid_reason, l_app_comments) ||']');
886: END IF;
887: --

Line 884: arp_standard.debug('l_app_comments NVL:[' ||

880: -- Apply to PAYMENT REFUND
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_standard.debug('Creating Payment Refund application..');
883: arp_standard.debug('l_app_comments :[' || l_app_comments ||']');
884: arp_standard.debug('l_app_comments NVL:[' ||
885: NVL(app_info(i).rid_reason, l_app_comments) ||']');
886: END IF;
887: --
888: ar_receipt_api_pub.activity_application(

Line 914: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);

910: );
911: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912:
913: IF (l_msg_count = 1) THEN
914: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);
915: ELSIF(l_MSG_COUNT>1)THEN
916: LOOP
917: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
918: IF (l_MSG_DATA IS NULL)THEN

Line 921: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);

917: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
918: IF (l_MSG_DATA IS NULL)THEN
919: EXIT;
920: END IF;
921: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);
922: END LOOP;
923: END IF;
924:
925: arp_standard.debug('ActivityApp failed');

Line 925: arp_standard.debug('ActivityApp failed');

921: arp_standard.debug('ActivityApp: ' || l_MSG_DATA);
922: END LOOP;
923: END IF;
924:
925: arp_standard.debug('ActivityApp failed');
926:
927: RAISE l_activity_app_failed;
928: END IF; -- Handle API errors
929: --

Line 943: arp_standard.debug('arp_process_RETURNS.process_application_list()- ');

939: --
940: <>
941: --
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_standard.debug('arp_process_RETURNS.process_application_list()- ');
944: END IF;
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_standard.debug('EXCEPTION : arp_process_returns.process_application_list : ' || SQLERRM(SQLCODE));

Line 947: arp_standard.debug('EXCEPTION : arp_process_returns.process_application_list : ' || SQLERRM(SQLCODE));

943: arp_standard.debug('arp_process_RETURNS.process_application_list()- ');
944: END IF;
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_standard.debug('EXCEPTION : arp_process_returns.process_application_list : ' || SQLERRM(SQLCODE));
948: RAISE;
949: END process_application_list;
950:
951: /*========================================================================

Line 1063: arp_standard.debug('arp_process_RETURNS.unapply_receipts()+ ');

1059: l_ra_info app_info_type;
1060: l_rec_in_doubt VARCHAR2(1):='N';
1061: BEGIN
1062: IF PG_DEBUG in ('Y', 'C') THEN
1063: arp_standard.debug('arp_process_RETURNS.unapply_receipts()+ ');
1064: arp_standard.debug('p_inv_customer_trx_id :<' || p_inv_customer_trx_id ||'>');
1065: arp_standard.debug('rec_hand_option :<' || p_receipt_handling_option ||'>');
1066: END IF;
1067: --

Line 1064: arp_standard.debug('p_inv_customer_trx_id :<' || p_inv_customer_trx_id ||'>');

1060: l_rec_in_doubt VARCHAR2(1):='N';
1061: BEGIN
1062: IF PG_DEBUG in ('Y', 'C') THEN
1063: arp_standard.debug('arp_process_RETURNS.unapply_receipts()+ ');
1064: arp_standard.debug('p_inv_customer_trx_id :<' || p_inv_customer_trx_id ||'>');
1065: arp_standard.debug('rec_hand_option :<' || p_receipt_handling_option ||'>');
1066: END IF;
1067: --
1068: --

Line 1065: arp_standard.debug('rec_hand_option :<' || p_receipt_handling_option ||'>');

1061: BEGIN
1062: IF PG_DEBUG in ('Y', 'C') THEN
1063: arp_standard.debug('arp_process_RETURNS.unapply_receipts()+ ');
1064: arp_standard.debug('p_inv_customer_trx_id :<' || p_inv_customer_trx_id ||'>');
1065: arp_standard.debug('rec_hand_option :<' || p_receipt_handling_option ||'>');
1066: END IF;
1067: --
1068: --
1069: --

Line 1084: arp_standard.debug('CC receipt with refund request ');

1080: -- Need to add check receipt in doubt for PAY_REFUND
1081: IF c02_rec.rec_proc_option = 'REFUND' THEN
1082: --
1083: IF PG_DEBUG in ('Y', 'C') THEN
1084: arp_standard.debug('CC receipt with refund request ');
1085: END IF;
1086: --
1087: IF inv_info(p_inv_customer_trx_id).all_recs_in_doubt THEN
1088: --

Line 1093: arp_standard.debug('All recs in doubt :<' || l_rid_reason ||'>');

1089: l_rec_in_doubt := 'Y';
1090: l_rid_reason := inv_info(p_inv_customer_trx_id).rid_reason;
1091: --
1092: IF PG_DEBUG in ('Y', 'C') THEN
1093: arp_standard.debug('All recs in doubt :<' || l_rid_reason ||'>');
1094: END IF;
1095: --
1096: ELSE
1097: --

Line 1105: arp_standard.debug('After RID chk :<' || l_rid_reason ||'>');

1101: x_rec_proc_option => c02_rec.rec_proc_option);
1102: --
1103: --
1104: IF PG_DEBUG in ('Y', 'C') THEN
1105: arp_standard.debug('After RID chk :<' || l_rid_reason ||'>');
1106: END IF;
1107: --
1108: END IF;
1109: --

Line 1117: arp_standard.debug('Non CC receipt with refund request ');

1113:
1114: IF c02_rec.rec_proc_option = 'PAY_REFUND' THEN
1115: --
1116: IF PG_DEBUG in ('Y', 'C') THEN
1117: arp_standard.debug('Non CC receipt with refund request ');
1118: END IF;
1119: --
1120: IF inv_info(p_inv_customer_trx_id).all_recs_in_doubt THEN
1121: --

Line 1126: arp_standard.debug('All recs in doubt :<' || l_rid_reason ||'>');

1122: l_rec_in_doubt := 'Y';
1123: l_rid_reason := inv_info(p_inv_customer_trx_id).rid_reason;
1124: --
1125: IF PG_DEBUG in ('Y', 'C') THEN
1126: arp_standard.debug('All recs in doubt :<' || l_rid_reason ||'>');
1127: END IF;
1128: --
1129: ELSE
1130: --

Line 1138: arp_standard.debug('After Non CC RID chk :<' || l_rid_reason ||'>');

1134: x_rec_proc_option=> c02_rec.rec_proc_option);
1135: --
1136: --
1137: IF PG_DEBUG in ('Y', 'C') THEN
1138: arp_standard.debug('After Non CC RID chk :<' || l_rid_reason ||'>');
1139: END IF;
1140: --
1141: END IF;
1142: --

Line 1164: arp_standard.debug('Call to fetch_gl_date : '||to_char(l_ra_rec.reversal_gl_date));

1160: -- and re-app to old transaction
1161: --
1162: /* Bug 8686218 */
1163: IF PG_DEBUG in ('Y', 'C') THEN
1164: arp_standard.debug('Call to fetch_gl_date : '||to_char(l_ra_rec.reversal_gl_date));
1165: END IF;
1166:
1167: fetch_gl_date(p_ra_rec => l_ra_rec,
1168: p_gl_date => l_ra_rec.reversal_gl_date);

Line 1171: arp_standard.debug('Defaulted gl date via fetch_gl_date : '||to_char(l_ra_rec.reversal_gl_date));

1167: fetch_gl_date(p_ra_rec => l_ra_rec,
1168: p_gl_date => l_ra_rec.reversal_gl_date);
1169:
1170: IF PG_DEBUG in ('Y', 'C') THEN
1171: arp_standard.debug('Defaulted gl date via fetch_gl_date : '||to_char(l_ra_rec.reversal_gl_date));
1172: END IF;
1173:
1174: l_ra_info.rec_proc_option := c02_rec.rec_proc_option;
1175: l_ra_info.rec_in_doubt := l_rec_in_doubt;

Line 1193: arp_standard.debug('rec_app_id :<' ||

1189: --
1190: add_ra_to_list(p_ra_info=>l_ra_info, p_ra_rec=>l_ra_rec);
1191: --
1192: IF PG_DEBUG in ('Y', 'C') THEN
1193: arp_standard.debug('rec_app_id :<' ||
1194: c02_rec.receivable_application_id ||'>');
1195: arp_standard.debug('rec_in_doubt :<' || l_rec_in_doubt ||'>');
1196: arp_standard.debug('rec_in_doubt_reason :<' ||
1197: l_rid_reason ||'>');

Line 1195: arp_standard.debug('rec_in_doubt :<' || l_rec_in_doubt ||'>');

1191: --
1192: IF PG_DEBUG in ('Y', 'C') THEN
1193: arp_standard.debug('rec_app_id :<' ||
1194: c02_rec.receivable_application_id ||'>');
1195: arp_standard.debug('rec_in_doubt :<' || l_rec_in_doubt ||'>');
1196: arp_standard.debug('rec_in_doubt_reason :<' ||
1197: l_rid_reason ||'>');
1198: arp_standard.debug('rec_proc_option :<' ||
1199: c02_rec.rec_proc_option ||'>');

Line 1196: arp_standard.debug('rec_in_doubt_reason :<' ||

1192: IF PG_DEBUG in ('Y', 'C') THEN
1193: arp_standard.debug('rec_app_id :<' ||
1194: c02_rec.receivable_application_id ||'>');
1195: arp_standard.debug('rec_in_doubt :<' || l_rec_in_doubt ||'>');
1196: arp_standard.debug('rec_in_doubt_reason :<' ||
1197: l_rid_reason ||'>');
1198: arp_standard.debug('rec_proc_option :<' ||
1199: c02_rec.rec_proc_option ||'>');
1200: END IF;

Line 1198: arp_standard.debug('rec_proc_option :<' ||

1194: c02_rec.receivable_application_id ||'>');
1195: arp_standard.debug('rec_in_doubt :<' || l_rec_in_doubt ||'>');
1196: arp_standard.debug('rec_in_doubt_reason :<' ||
1197: l_rid_reason ||'>');
1198: arp_standard.debug('rec_proc_option :<' ||
1199: c02_rec.rec_proc_option ||'>');
1200: END IF;
1201: --
1202: -- Unapply the application

Line 1216: arp_standard.debug('Unapply: ' || l_MSG_DATA);

1212:
1213: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1214:
1215: IF (l_msg_count = 1) THEN
1216: arp_standard.debug('Unapply: ' || l_MSG_DATA);
1217: ELSIF(l_MSG_COUNT>1)THEN
1218: LOOP
1219: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
1220: IF (l_MSG_DATA IS NULL)THEN

Line 1223: arp_standard.debug('UNapply: ' || l_MSG_DATA);

1219: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
1220: IF (l_MSG_DATA IS NULL)THEN
1221: EXIT;
1222: END IF;
1223: arp_standard.debug('UNapply: ' || l_MSG_DATA);
1224: END LOOP;
1225: END IF;
1226:
1227: arp_standard.debug('Unapplication failed');

Line 1227: arp_standard.debug('Unapplication failed');

1223: arp_standard.debug('UNapply: ' || l_MSG_DATA);
1224: END LOOP;
1225: END IF;
1226:
1227: arp_standard.debug('Unapplication failed');
1228: RAISE l_unapply_failed;
1229: END IF;
1230:
1231: END LOOP;

Line 1234: arp_standard.debug('arp_process_RETURNS.unapply_receipts()- ');

1230:
1231: END LOOP;
1232:
1233: IF PG_DEBUG in ('Y', 'C') THEN
1234: arp_standard.debug('arp_process_RETURNS.unapply_receipts()- ');
1235: END IF;
1236: EXCEPTION
1237: WHEN OTHERS THEN
1238: arp_standard.debug('arp_process_returns.unapply_receipts : '

Line 1238: arp_standard.debug('arp_process_returns.unapply_receipts : '

1234: arp_standard.debug('arp_process_RETURNS.unapply_receipts()- ');
1235: END IF;
1236: EXCEPTION
1237: WHEN OTHERS THEN
1238: arp_standard.debug('arp_process_returns.unapply_receipts : '
1239: || SQLERRM(SQLCODE));
1240: RAISE;
1241:
1242: END unapply_receipts;

Line 1251: arp_standard.debug('arp_process_RETURNS.add_invoice()+ ');

1247:
1248: PROCEDURE add_invoice (p_customer_trx_id IN NUMBER) IS
1249: BEGIN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_standard.debug('arp_process_RETURNS.add_invoice()+ ');
1252: arp_standard.debug('p_customer_trx_id :<' || p_customer_trx_id ||'>');
1253: END IF;
1254:
1255: IF inv_info.EXISTS(p_customer_trx_id) THEN

Line 1252: arp_standard.debug('p_customer_trx_id :<' || p_customer_trx_id ||'>');

1248: PROCEDURE add_invoice (p_customer_trx_id IN NUMBER) IS
1249: BEGIN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_standard.debug('arp_process_RETURNS.add_invoice()+ ');
1252: arp_standard.debug('p_customer_trx_id :<' || p_customer_trx_id ||'>');
1253: END IF;
1254:
1255: IF inv_info.EXISTS(p_customer_trx_id) THEN
1256: inv_info(p_customer_trx_id).num_of_cms :=

Line 1263: arp_standard.debug('arp_process_RETURNS.add_invoice()- ');

1259: inv_info(p_customer_trx_id).num_of_cms := 1;
1260: END IF;
1261:
1262: IF PG_DEBUG in ('Y', 'C') THEN
1263: arp_standard.debug('arp_process_RETURNS.add_invoice()- ');
1264: END IF;
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: arp_standard.debug('arp_process_returns.add_invoice : ' ||

Line 1267: arp_standard.debug('arp_process_returns.add_invoice : ' ||

1263: arp_standard.debug('arp_process_RETURNS.add_invoice()- ');
1264: END IF;
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: arp_standard.debug('arp_process_returns.add_invoice : ' ||
1268: SQLERRM(SQLCODE));
1269: RAISE;
1270: END;
1271:

Line 1283: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()+ ');

1279: l_cnt NUMBER := app_info.COUNT;
1280: BEGIN
1281: --
1282: IF PG_DEBUG in ('Y', 'C') THEN
1283: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()+ ');
1284: arp_standard.debug('count :<' || l_cnt ||'>');
1285: END IF;
1286: --
1287: l_cnt := l_cnt + 1;

Line 1284: arp_standard.debug('count :<' || l_cnt ||'>');

1280: BEGIN
1281: --
1282: IF PG_DEBUG in ('Y', 'C') THEN
1283: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()+ ');
1284: arp_standard.debug('count :<' || l_cnt ||'>');
1285: END IF;
1286: --
1287: l_cnt := l_cnt + 1;
1288: app_info(l_cnt) := p_ra_info;

Line 1292: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()- ');

1288: app_info(l_cnt) := p_ra_info;
1289: app_tab(l_cnt) := p_ra_rec;
1290: --
1291: IF PG_DEBUG in ('Y', 'C') THEN
1292: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()- ');
1293: END IF;
1294: --
1295: EXCEPTION
1296: WHEN OTHERS THEN

Line 1297: arp_standard.debug('arp_process_returns.add_ra_to_list : ' ||

1293: END IF;
1294: --
1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: arp_standard.debug('arp_process_returns.add_ra_to_list : ' ||
1298: SQLERRM(SQLCODE));
1299: RAISE;
1300: END;
1301: --

Line 1312: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()+ ');

1308:
1309: BEGIN
1310: --
1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()+ ');
1313: arp_standard.debug('p_inv_customer_trx_id :<'
1314: || p_inv_customer_trx_id ||'>');
1315: END IF;
1316: --

Line 1313: arp_standard.debug('p_inv_customer_trx_id :<'

1309: BEGIN
1310: --
1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()+ ');
1313: arp_standard.debug('p_inv_customer_trx_id :<'
1314: || p_inv_customer_trx_id ||'>');
1315: END IF;
1316: --
1317: SELECT NVL(SUM(extended_amount) , 0)

Line 1324: arp_standard.debug('l_total_cm_amount :<'

1320: WHERE previous_customer_trx_id = p_inv_customer_trx_id
1321: AND request_id = p_request_id;
1322: --
1323: IF PG_DEBUG in ('Y', 'C') THEN
1324: arp_standard.debug('l_total_cm_amount :<'
1325: || l_total_cm_amount ||'>');
1326: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()- ');
1327: END IF;
1328: --

Line 1326: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()- ');

1322: --
1323: IF PG_DEBUG in ('Y', 'C') THEN
1324: arp_standard.debug('l_total_cm_amount :<'
1325: || l_total_cm_amount ||'>');
1326: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()- ');
1327: END IF;
1328: --
1329:
1330: RETURN l_total_cm_amount;

Line 1333: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_cm_amount : '

1329:
1330: RETURN l_total_cm_amount;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_cm_amount : '
1334: || SQLERRM(SQLCODE));
1335: RAISE;
1336:
1337: END get_total_cm_amount;

Line 1353: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()+ ');

1349:
1350: BEGIN
1351: --
1352: IF PG_DEBUG in ('Y', 'C') THEN
1353: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()+ ');
1354: arp_standard.debug('p_inv_customer_trx_id :<'
1355: || p_inv_customer_trx_id ||'>');
1356: END IF;
1357: --

Line 1354: arp_standard.debug('p_inv_customer_trx_id :<'

1350: BEGIN
1351: --
1352: IF PG_DEBUG in ('Y', 'C') THEN
1353: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()+ ');
1354: arp_standard.debug('p_inv_customer_trx_id :<'
1355: || p_inv_customer_trx_id ||'>');
1356: END IF;
1357: --
1358: SELECT

Line 1378: arp_standard.debug('l_total_payment_types :<'

1374: l_total_payment_types := 0;
1375: END IF;
1376: --
1377: IF PG_DEBUG in ('Y', 'C') THEN
1378: arp_standard.debug('l_total_payment_types :<'
1379: || l_total_payment_types ||'>');
1380: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()- ');
1381: END IF;
1382: --

Line 1380: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()- ');

1376: --
1377: IF PG_DEBUG in ('Y', 'C') THEN
1378: arp_standard.debug('l_total_payment_types :<'
1379: || l_total_payment_types ||'>');
1380: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()- ');
1381: END IF;
1382: --
1383: RETURN l_total_payment_types;
1384: --

Line 1387: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_payment_types : '

1383: RETURN l_total_payment_types;
1384: --
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_payment_types : '
1388: || SQLERRM(SQLCODE));
1389: RAISE;
1390:
1391: END get_total_payment_types;

Line 1405: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()+ ');

1401:
1402: BEGIN
1403: --
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()+ ');
1406: arp_standard.debug('p_cash_receipt_id :<'
1407: || p_cash_receipt_id ||'>');
1408: END IF;
1409: --

Line 1406: arp_standard.debug('p_cash_receipt_id :<'

1402: BEGIN
1403: --
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()+ ');
1406: arp_standard.debug('p_cash_receipt_id :<'
1407: || p_cash_receipt_id ||'>');
1408: END IF;
1409: --
1410: x_receipt_amount := 0;

Line 1438: arp_standard.debug('x_receipt_amount :<'

1434: END IF;
1435:
1436: --
1437: IF PG_DEBUG in ('Y', 'C') THEN
1438: arp_standard.debug('x_receipt_amount :<'
1439: || x_receipt_amount ||'>');
1440: arp_standard.debug('x_refund_amount :<'
1441: || x_refund_amount ||'>');
1442: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()- ');

Line 1440: arp_standard.debug('x_refund_amount :<'

1436: --
1437: IF PG_DEBUG in ('Y', 'C') THEN
1438: arp_standard.debug('x_receipt_amount :<'
1439: || x_receipt_amount ||'>');
1440: arp_standard.debug('x_refund_amount :<'
1441: || x_refund_amount ||'>');
1442: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()- ');
1443: END IF;
1444: --

Line 1442: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()- ');

1438: arp_standard.debug('x_receipt_amount :<'
1439: || x_receipt_amount ||'>');
1440: arp_standard.debug('x_refund_amount :<'
1441: || x_refund_amount ||'>');
1442: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()- ');
1443: END IF;
1444: --
1445:
1446: EXCEPTION

Line 1450: arp_standard.debug('EXCEPTION:arp_process_returns.get_receipt_amounts : '

1446: EXCEPTION
1447: WHEN NO_DATA_FOUND THEN
1448: NULL;
1449: WHEN OTHERS THEN
1450: arp_standard.debug('EXCEPTION:arp_process_returns.get_receipt_amounts : '
1451: || SQLERRM(SQLCODE));
1452: RAISE;
1453: END;
1454:

Line 1488: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()+ ');

1484: x_rec_proc_option IN VARCHAR2) IS
1485: BEGIN
1486: ---
1487: IF PG_DEBUG in ('Y', 'C') THEN
1488: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()+ ');
1489: END IF;
1490: ---
1491: x_rec_in_doubt := 'N';
1492: x_rid_reason := null;

Line 1498: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_REMITTED_OR_CLEARED')

1494: --- For CC receipts, receipt should be remitted
1495: ---
1496: IF x_rec_proc_option = 'REFUND' THEN
1497: BEGIN
1498: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_REMITTED_OR_CLEARED')
1499: INTO x_rec_in_doubt, x_rid_reason
1500: FROM dual
1501: WHERE
1502: (

Line 1515: arp_standard.debug('Unexpected error '||sqlerrm||

1511: EXCEPTION
1512: WHEN NO_DATA_FOUND THEN
1513: NULL;
1514: WHEN OTHERS THEN
1515: arp_standard.debug('Unexpected error '||sqlerrm||
1516: ' occurred in arp_process_returns.check_rec_in_doubt');
1517: RAISE;
1518: END;
1519:

Line 1522: arp_standard.debug('After REFUND x_rec_in_doubt[x_rid_reason]: ' || x_rec_in_doubt ||

1518: END;
1519:
1520: ---
1521: IF PG_DEBUG in ('Y', 'C') THEN
1522: arp_standard.debug('After REFUND x_rec_in_doubt[x_rid_reason]: ' || x_rec_in_doubt ||
1523: '[' || x_rid_reason || ']');
1524: END IF;
1525:
1526: ELSIF x_rec_proc_option = 'PAY_REFUND' THEN

Line 1531: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_CLEARED')

1527: ---
1528: --- For Non CC Receipts , receipt should be cleared
1529: ---
1530: BEGIN
1531: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_CLEARED')
1532: INTO x_rec_in_doubt, x_rid_reason
1533: FROM dual
1534: WHERE
1535: (

Line 1548: arp_standard.debug('Unexpected error '||sqlerrm||

1544: EXCEPTION
1545: WHEN NO_DATA_FOUND THEN
1546: NULL;
1547: WHEN OTHERS THEN
1548: arp_standard.debug('Unexpected error '||sqlerrm||
1549: ' occurred in arp_process_returns.check_rec_in_doubt');
1550: RAISE;
1551: END;
1552:

Line 1555: arp_standard.debug('After Non CC REFUND x_rec_in_doubt[x_rid_reason]: ' || x_rec_in_doubt ||

1551: END;
1552:
1553: ---
1554: IF PG_DEBUG in ('Y', 'C') THEN
1555: arp_standard.debug('After Non CC REFUND x_rec_in_doubt[x_rid_reason]: ' || x_rec_in_doubt ||
1556: '[' || x_rid_reason || ']');
1557: END IF;
1558: END IF;
1559:

Line 1566: SELECT 'Y', arp_standard.fnd_message('AR_RID_CLAIM_OR_CB_APP_EXISTS')

1562: ---
1563: --- There should not be any Claims Investigation or CB special application
1564: ---
1565: BEGIN
1566: SELECT 'Y', arp_standard.fnd_message('AR_RID_CLAIM_OR_CB_APP_EXISTS')
1567: INTO x_rec_in_doubt, x_rid_reason
1568: FROM dual
1569: WHERE
1570: EXISTS

Line 1582: arp_standard.debug('Unexpected error '||sqlerrm||

1578: EXCEPTION
1579: WHEN NO_DATA_FOUND THEN
1580: NULL;
1581: WHEN OTHERS THEN
1582: arp_standard.debug('Unexpected error '||sqlerrm||
1583: ' occurred in arp_process_returns.check_rec_in_doubt');
1584: RAISE;
1585: END;
1586:

Line 1589: arp_standard.debug('After CLAIMS x_rec_in_doubt[x_rid_reason]: ' ||

1585: END;
1586:
1587: ---
1588: IF PG_DEBUG in ('Y', 'C') THEN
1589: arp_standard.debug('After CLAIMS x_rec_in_doubt[x_rid_reason]: ' ||
1590: x_rec_in_doubt || '[' || x_rid_reason || ']');
1591: END IF;
1592: ---
1593: ---

Line 1597: SELECT 'Y', arp_standard.fnd_message('AR_RID_RECEIPT_REVERSED')

1593: ---
1594: --- Receipt should not be reversed
1595: ---
1596: BEGIN
1597: SELECT 'Y', arp_standard.fnd_message('AR_RID_RECEIPT_REVERSED')
1598: INTO x_rec_in_doubt, x_rid_reason
1599: FROM dual
1600: WHERE
1601: EXISTS

Line 1612: arp_standard.debug('Unexpected error '||sqlerrm||

1608: EXCEPTION
1609: WHEN NO_DATA_FOUND THEN
1610: NULL;
1611: WHEN OTHERS THEN
1612: arp_standard.debug('Unexpected error '||sqlerrm||
1613: ' occurred in arp_process_returns.check_rec_in_doubt');
1614: RAISE;
1615: END;
1616:

Line 1619: arp_standard.debug('After DM reverse x_rec_in_doubt[x_rid_reason]: ' ||

1615: END;
1616:
1617: ---
1618: IF PG_DEBUG in ('Y', 'C') THEN
1619: arp_standard.debug('After DM reverse x_rec_in_doubt[x_rid_reason]: ' ||
1620: x_rec_in_doubt || '[' || x_rid_reason || ']');
1621: END IF;
1622: ---
1623: <>

Line 1626: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()- ');

1622: ---
1623: <>
1624: ---
1625: IF PG_DEBUG in ('Y', 'C') THEN
1626: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()- ');
1627: END IF;
1628: ---
1629: EXCEPTION
1630: WHEN OTHERS THEN

Line 1631: arp_standard.debug('Unexpected error '||sqlerrm||

1627: END IF;
1628: ---
1629: EXCEPTION
1630: WHEN OTHERS THEN
1631: arp_standard.debug('Unexpected error '||sqlerrm||
1632: ' occurred in arp_process_returns.check_rec_in_doubt');
1633: RAISE;
1634: END check_rec_in_doubt;
1635:

Line 1663: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()+ ');

1659: l_count NUMBER;
1660: BEGIN
1661: ---
1662: IF PG_DEBUG in ('Y', 'C') THEN
1663: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()+ ');
1664: arp_standard.debug('p_customer_trx_id :<'
1665: || p_customer_trx_id ||'>');
1666: END IF;
1667: ---

Line 1664: arp_standard.debug('p_customer_trx_id :<'

1660: BEGIN
1661: ---
1662: IF PG_DEBUG in ('Y', 'C') THEN
1663: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()+ ');
1664: arp_standard.debug('p_customer_trx_id :<'
1665: || p_customer_trx_id ||'>');
1666: END IF;
1667: ---
1668: select count(*)

Line 1680: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()- ');

1676: and app.customer_trx_id = oncm.customer_trx_id
1677: and oncm.previous_customer_trx_id IS NULL;
1678: ---
1679: IF PG_DEBUG in ('Y', 'C') THEN
1680: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()- ');
1681: END IF;
1682: ---
1683: RETURN l_count;
1684:

Line 1687: arp_standard.debug('Unexpected error '||sqlerrm||

1683: RETURN l_count;
1684:
1685: EXCEPTION
1686: WHEN OTHERS THEN
1687: arp_standard.debug('Unexpected error '||sqlerrm||
1688: ' occurred in arp_process_returns.get_on_acct_cm_apps');
1689: RAISE;
1690: END get_on_acct_cm_apps;
1691:

Line 1719: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()+ ');

1715: l_count NUMBER;
1716: BEGIN
1717: ---
1718: IF PG_DEBUG in ('Y', 'C') THEN
1719: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()+ ');
1720: arp_standard.debug('p_customer_trx_id :<'
1721: || p_customer_trx_id ||'>');
1722: END IF;
1723: ---

Line 1720: arp_standard.debug('p_customer_trx_id :<'

1716: BEGIN
1717: ---
1718: IF PG_DEBUG in ('Y', 'C') THEN
1719: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()+ ');
1720: arp_standard.debug('p_customer_trx_id :<'
1721: || p_customer_trx_id ||'>');
1722: END IF;
1723: ---
1724: select count(*)

Line 1734: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()- ');

1730: and app.display = 'Y'
1731: and app.amount_applied < 0;
1732: ---
1733: IF PG_DEBUG in ('Y', 'C') THEN
1734: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()- ');
1735: END IF;
1736: ---
1737: RETURN l_count;
1738:

Line 1741: arp_standard.debug('Unexpected error '||sqlerrm||

1737: RETURN l_count;
1738:
1739: EXCEPTION
1740: WHEN OTHERS THEN
1741: arp_standard.debug('Unexpected error '||sqlerrm||
1742: ' occurred in arp_process_returns.get_neg_inv_apps');
1743: RAISE;
1744: END get_neg_inv_apps;
1745:

Line 1773: arp_standard.debug('arp_process_RETURNS.get_llca_apps()+ ');

1769: l_count NUMBER;
1770: BEGIN
1771: ---
1772: IF PG_DEBUG in ('Y', 'C') THEN
1773: arp_standard.debug('arp_process_RETURNS.get_llca_apps()+ ');
1774: arp_standard.debug('p_customer_trx_id :<'
1775: || p_customer_trx_id ||'>');
1776: END IF;
1777: ---

Line 1774: arp_standard.debug('p_customer_trx_id :<'

1770: BEGIN
1771: ---
1772: IF PG_DEBUG in ('Y', 'C') THEN
1773: arp_standard.debug('arp_process_RETURNS.get_llca_apps()+ ');
1774: arp_standard.debug('p_customer_trx_id :<'
1775: || p_customer_trx_id ||'>');
1776: END IF;
1777: ---
1778: select count(*)

Line 1789: arp_standard.debug('arp_process_RETURNS.get_llca_apps()- ');

1785: and aad.customer_trx_line_id = lines.customer_trx_line_id;
1786:
1787: ---
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_standard.debug('arp_process_RETURNS.get_llca_apps()- ');
1790: END IF;
1791: ---
1792: RETURN l_count;
1793:

Line 1796: arp_standard.debug('Unexpected error '||sqlerrm||

1792: RETURN l_count;
1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: arp_standard.debug('Unexpected error '||sqlerrm||
1797: ' occurred in arp_process_returns.get_llca_apps');
1798: RAISE;
1799: END get_llca_apps;
1800:

Line 1834: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()+ ');

1830: AS
1831: BEGIN
1832: ---
1833: IF PG_DEBUG in ('Y', 'C') THEN
1834: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()+ ');
1835: END IF;
1836: ---
1837: x_dff_rec.attribute_category:=p_ra_rec.attribute_category;
1838: x_dff_rec.attribute1 :=p_ra_rec.attribute1;

Line 1879: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()- ');

1875: x_gdf_rec.global_attribute20 :=p_ra_rec.global_attribute20;
1876: ---
1877: ---
1878: IF PG_DEBUG in ('Y', 'C') THEN
1879: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()- ');
1880: END IF;
1881: ---
1882: EXCEPTION
1883: WHEN OTHERS THEN

Line 1884: arp_standard.debug('Unexpected error '||sqlerrm||

1880: END IF;
1881: ---
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: arp_standard.debug('Unexpected error '||sqlerrm||
1885: ' occurred in arp_process_returns.populate_dff_and_gdf');
1886: RAISE;
1887: END populate_dff_and_gdf;
1888:

Line 1928: arp_standard.debug('arp_process_RETURNS.get_amount_applied()+ ');

1924:
1925: BEGIN
1926: ---
1927: IF PG_DEBUG in ('Y', 'C') THEN
1928: arp_standard.debug('arp_process_RETURNS.get_amount_applied()+ ');
1929: arp_standard.debug('Customer Trx Id : ' || p_customer_trx_id);
1930: arp_standard.debug('p_line_type : ' || p_line_type);
1931: END IF;
1932: --

Line 1929: arp_standard.debug('Customer Trx Id : ' || p_customer_trx_id);

1925: BEGIN
1926: ---
1927: IF PG_DEBUG in ('Y', 'C') THEN
1928: arp_standard.debug('arp_process_RETURNS.get_amount_applied()+ ');
1929: arp_standard.debug('Customer Trx Id : ' || p_customer_trx_id);
1930: arp_standard.debug('p_line_type : ' || p_line_type);
1931: END IF;
1932: --
1933: -- Adjust amount applied iff invoice is in the list created during validation

Line 1930: arp_standard.debug('p_line_type : ' || p_line_type);

1926: ---
1927: IF PG_DEBUG in ('Y', 'C') THEN
1928: arp_standard.debug('arp_process_RETURNS.get_amount_applied()+ ');
1929: arp_standard.debug('Customer Trx Id : ' || p_customer_trx_id);
1930: arp_standard.debug('p_line_type : ' || p_line_type);
1931: END IF;
1932: --
1933: -- Adjust amount applied iff invoice is in the list created during validation
1934: --

Line 1940: arp_standard.debug('Cache Hit...');

1936: --
1937: IF amt_app_tab.EXISTS(p_customer_trx_id) THEN
1938: --
1939: IF PG_DEBUG in ('Y', 'C') THEN
1940: arp_standard.debug('Cache Hit...');
1941: END IF;
1942: --
1943: null;
1944: --

Line 1948: arp_standard.debug('Database Hit...');

1944: --
1945: ELSE
1946: --
1947: IF PG_DEBUG in ('Y', 'C') THEN
1948: arp_standard.debug('Database Hit...');
1949: END IF;
1950: --
1951: --
1952: --

Line 2000: arp_standard.debug('Total Amount : ' || l_total_amount);

1996: l_total_amount := 0;
1997: END IF;
1998: ---
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_standard.debug('Total Amount : ' || l_total_amount);
2001: arp_standard.debug('arp_process_RETURNS.get_amount_applied()- ');
2002: END IF;
2003: --
2004:

Line 2001: arp_standard.debug('arp_process_RETURNS.get_amount_applied()- ');

1997: END IF;
1998: ---
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_standard.debug('Total Amount : ' || l_total_amount);
2001: arp_standard.debug('arp_process_RETURNS.get_amount_applied()- ');
2002: END IF;
2003: --
2004:
2005: RETURN l_total_amount;

Line 2009: arp_standard.debug('Unexpected error '||sqlerrm||

2005: RETURN l_total_amount;
2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: arp_standard.debug('Unexpected error '||sqlerrm||
2010: ' occurred in arp_process_returns.get_amount_applied');
2011: RAISE;
2012: END get_amount_applied;
2013:

Line 2025: arp_standard.debug('arp_process_returns.fetch_gl_date()+ ');

2021: l_default_gl_date DATE;
2022: BEGIN
2023:
2024: IF PG_DEBUG in ('Y', 'C') THEN
2025: arp_standard.debug('arp_process_returns.fetch_gl_date()+ ');
2026: END IF;
2027:
2028: l_profile_appln_gl_date_def := NVL(fnd_profile.value('AR_APPLICATION_GL_DATE_DEFAULT')
2029: , 'INV_REC_DT');

Line 2032: arp_standard.debug('Profile Value : '||l_profile_appln_gl_date_def);

2028: l_profile_appln_gl_date_def := NVL(fnd_profile.value('AR_APPLICATION_GL_DATE_DEFAULT')
2029: , 'INV_REC_DT');
2030:
2031: IF PG_DEBUG in ('Y', 'C') THEN
2032: arp_standard.debug('Profile Value : '||l_profile_appln_gl_date_def);
2033: END IF;
2034:
2035: BEGIN
2036: SELECT gl_date

Line 2059: arp_standard.debug('TRX DATE Value : '||to_char(l_trx_gl_date));

2055: l_rec_gl_date := NULL;
2056: END;
2057:
2058: IF PG_DEBUG in ('Y', 'C') THEN
2059: arp_standard.debug('TRX DATE Value : '||to_char(l_trx_gl_date));
2060: arp_standard.debug('REC DATE Value : '||to_char(l_rec_gl_date));
2061: END IF;
2062:
2063: IF l_profile_appln_gl_date_def = 'INV_REC_SYS_DT' THEN

Line 2060: arp_standard.debug('REC DATE Value : '||to_char(l_rec_gl_date));

2056: END;
2057:
2058: IF PG_DEBUG in ('Y', 'C') THEN
2059: arp_standard.debug('TRX DATE Value : '||to_char(l_trx_gl_date));
2060: arp_standard.debug('REC DATE Value : '||to_char(l_rec_gl_date));
2061: END IF;
2062:
2063: IF l_profile_appln_gl_date_def = 'INV_REC_SYS_DT' THEN
2064: p_gl_date := GREATEST(NVL(l_trx_gl_date, trunc(SYSDATE))

Line 2073: arp_standard.debug('GL DATE Before Defaulting Value : '||to_char(p_gl_date));

2069: p_gl_date := GREATEST(l_trx_gl_date, l_rec_gl_date);
2070: END IF;
2071:
2072: IF PG_DEBUG in ('Y', 'C') THEN
2073: arp_standard.debug('GL DATE Before Defaulting Value : '||to_char(p_gl_date));
2074: END IF;
2075:
2076: IF p_gl_date IS NOT NULL THEN
2077: IF ( arp_util.validate_and_default_gl_date(

Line 2098: arp_standard.debug('GL DATE OUT : '||to_char(p_gl_date));

2094: END IF;
2095: END IF;
2096:
2097: IF PG_DEBUG in ('Y', 'C') THEN
2098: arp_standard.debug('GL DATE OUT : '||to_char(p_gl_date));
2099: arp_standard.debug('arp_process_returns.fetch_gl_date()-');
2100: END IF;
2101:
2102: EXCEPTION

Line 2099: arp_standard.debug('arp_process_returns.fetch_gl_date()-');

2095: END IF;
2096:
2097: IF PG_DEBUG in ('Y', 'C') THEN
2098: arp_standard.debug('GL DATE OUT : '||to_char(p_gl_date));
2099: arp_standard.debug('arp_process_returns.fetch_gl_date()-');
2100: END IF;
2101:
2102: EXCEPTION
2103: WHEN OTHERS THEN

Line 2105: arp_standard.debug('Exception -- arp_process_returns');

2101:
2102: EXCEPTION
2103: WHEN OTHERS THEN
2104: IF PG_DEBUG in ('Y', 'C') THEN
2105: arp_standard.debug('Exception -- arp_process_returns');
2106: END IF;
2107: p_gl_date := NULL;
2108:
2109: END fetch_gl_date;