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_CONFIRMATION dependencies on STANDARD

Line 78: arp_standard.debug('arp_confirmation.confirm()+');

74:
75: BEGIN
76:
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_standard.debug('arp_confirmation.confirm()+');
79: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
80: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
81: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
82: END IF;

Line 79: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));

75: BEGIN
76:
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_standard.debug('arp_confirmation.confirm()+');
79: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
80: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
81: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
82: END IF;
83:

Line 80: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));

76:
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_standard.debug('arp_confirmation.confirm()+');
79: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
80: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
81: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
82: END IF;
83:
84: -- validate IN parameters:

Line 81: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));

77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_standard.debug('arp_confirmation.confirm()+');
79: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
80: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
81: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
82: END IF;
83:
84: -- validate IN parameters:
85:

Line 92: arp_standard.debug('confirm: ' || '-- Parameters validated.');

88: p_confirm_date,
89: p_module_name);
90:
91: IF PG_DEBUG in ('Y', 'C') THEN
92: arp_standard.debug('confirm: ' || '-- Parameters validated.');
93: END IF;
94:
95: -- populate the ar_cash_receipts record from ar_cash_receipts table.
96: -- use ar_cash_receipt_id for selection.

Line 102: arp_standard.debug('confirm: ' || '-- Cash Receipt fetched');

98: l_cr_rec.cash_receipt_id := p_cr_id;
99: arp_cash_receipts_pkg.fetch_p(l_cr_rec);
100:
101: IF PG_DEBUG in ('Y', 'C') THEN
102: arp_standard.debug('confirm: ' || '-- Cash Receipt fetched');
103: END IF;
104:
105: -- get receipt clearing code combination id from ar_receipt_method_accounts
106:

Line 110: arp_standard.debug('confirm: ' || '-- Receipt Clearing code combination fetched');

106:
107: get_receipt_clearing_ccid(l_cr_rec, l_receipt_clearing_ccid);
108:
109: IF PG_DEBUG in ('Y', 'C') THEN
110: arp_standard.debug('confirm: ' || '-- Receipt Clearing code combination fetched');
111: arp_standard.debug('confirm: ' || '-- receipt_clearing_ccid = '|| l_receipt_clearing_ccid);
112: END IF;
113:
114: -- calculate accounted cash receipt amount

Line 111: arp_standard.debug('confirm: ' || '-- receipt_clearing_ccid = '|| l_receipt_clearing_ccid);

107: get_receipt_clearing_ccid(l_cr_rec, l_receipt_clearing_ccid);
108:
109: IF PG_DEBUG in ('Y', 'C') THEN
110: arp_standard.debug('confirm: ' || '-- Receipt Clearing code combination fetched');
111: arp_standard.debug('confirm: ' || '-- receipt_clearing_ccid = '|| l_receipt_clearing_ccid);
112: END IF;
113:
114: -- calculate accounted cash receipt amount
115: -- Changes for triangulation: If exchange rate type is not user, call

Line 139: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');

135: l_cr_rec.amount);
136: END IF;
137:
138: IF PG_DEBUG in ('Y', 'C') THEN
139: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
140: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
141: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
142: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
143: END IF;

Line 140: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));

136: END IF;
137:
138: IF PG_DEBUG in ('Y', 'C') THEN
139: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
140: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
141: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
142: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
143: END IF;
144:

Line 141: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));

137:
138: IF PG_DEBUG in ('Y', 'C') THEN
139: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
140: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
141: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
142: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
143: END IF;
144:
145: -- update the ar_cash_receipt_history_table with a new record for

Line 142: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));

138: IF PG_DEBUG in ('Y', 'C') THEN
139: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
140: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
141: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
142: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
143: END IF;
144:
145: -- update the ar_cash_receipt_history_table with a new record for
146: -- this receipt. This call will also create a new ar_distributions

Line 168: arp_standard.debug('arp_confirmation.confirm()-');

164: p_confirm_date,
165: l_acctd_amount);
166:
167: IF PG_DEBUG in ('Y', 'C') THEN
168: arp_standard.debug('arp_confirmation.confirm()-');
169: END IF;
170:
171: EXCEPTION
172: WHEN OTHERS THEN

Line 240: arp_standard.debug('arp_confirmation.unconfirm()+');

236:
237: BEGIN
238:
239: IF PG_DEBUG in ('Y', 'C') THEN
240: arp_standard.debug('arp_confirmation.unconfirm()+');
241: arp_standard.debug('confirm: ' || to_char(p_cr_id));
242: END IF;
243:
244: -- validate IN parameters:

Line 241: arp_standard.debug('confirm: ' || to_char(p_cr_id));

237: BEGIN
238:
239: IF PG_DEBUG in ('Y', 'C') THEN
240: arp_standard.debug('arp_confirmation.unconfirm()+');
241: arp_standard.debug('confirm: ' || to_char(p_cr_id));
242: END IF;
243:
244: -- validate IN parameters:
245:

Line 282: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');

278: l_cr_rec.amount);
279: END IF;
280:
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
283: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
284: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
285: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
286: END IF;

Line 283: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));

279: END IF;
280:
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
283: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
284: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
285: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
286: END IF;
287:

Line 284: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));

280:
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
283: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
284: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
285: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
286: END IF;
287:
288: -- update the ar_cash_receipt_history_table with a new record for

Line 285: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));

281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
283: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
284: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
285: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
286: END IF;
287:
288: -- update the ar_cash_receipt_history_table with a new record for
289: -- this receipt. This call will also create a new ar_distributions

Line 313: arp_standard.debug('arp_confirmation.unconfirm()-');

309: l_acctd_amount,
310: l_batch_id);
311:
312: IF PG_DEBUG in ('Y', 'C') THEN
313: arp_standard.debug('arp_confirmation.unconfirm()-');
314: END IF;
315:
316: EXCEPTION
317: WHEN OTHERS THEN

Line 389: arp_standard.debug('arp_confirmation.confirm_batch()+');

385: l_cash_receipt_rec confirmCursor%ROWTYPE;
386:
387: BEGIN
388: IF PG_DEBUG in ('Y', 'C') THEN
389: arp_standard.debug('arp_confirmation.confirm_batch()+');
390: END IF;
391:
392: FOR l_cash_receipt_rec IN confirmCursor(p_batch_id) LOOP
393: BEGIN

Line 413: arp_standard.debug('Exception in arp_confirmation.confirm_batch');

409:
410: EXCEPTION
411: WHEN OTHERS THEN
412: IF PG_DEBUG in ('Y', 'C') THEN
413: arp_standard.debug('Exception in arp_confirmation.confirm_batch');
414: END IF;
415: ROLLBACK TO ar_confirm_batch_sp;
416: l_num_rec_error := l_num_rec_error + 1;
417: END;

Line 425: arp_standard.debug('arp_confirmation.confirm_batch()-');

421: p_num_rec_confirmed := l_num_rec_confirmed;
422: p_num_rec_error := l_num_rec_error;
423:
424: IF PG_DEBUG in ('Y', 'C') THEN
425: arp_standard.debug('arp_confirmation.confirm_batch()-');
426: END IF;
427:
428: END confirm_batch;
429:

Line 468: arp_standard.debug('arp_confirmation.confirm_receipt()+');

464: l_status VARCHAR2(30);
465: l_confirmed_flag VARCHAR2(2);
466: BEGIN
467: IF PG_DEBUG in ('Y', 'C') THEN
468: arp_standard.debug('arp_confirmation.confirm_receipt()+');
469: arp_standard.debug('****** Begin Confirm Receipt ****** ');
470: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
471: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
472: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));

Line 469: arp_standard.debug(' Begin Confirm Receipt ');

465: l_confirmed_flag VARCHAR2(2);
466: BEGIN
467: IF PG_DEBUG in ('Y', 'C') THEN
468: arp_standard.debug('arp_confirmation.confirm_receipt()+');
469: arp_standard.debug('****** Begin Confirm Receipt ****** ');
470: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
471: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
472: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
473: END IF;

Line 470: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));

466: BEGIN
467: IF PG_DEBUG in ('Y', 'C') THEN
468: arp_standard.debug('arp_confirmation.confirm_receipt()+');
469: arp_standard.debug('****** Begin Confirm Receipt ****** ');
470: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
471: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
472: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
473: END IF;
474:

Line 471: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));

467: IF PG_DEBUG in ('Y', 'C') THEN
468: arp_standard.debug('arp_confirmation.confirm_receipt()+');
469: arp_standard.debug('****** Begin Confirm Receipt ****** ');
470: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
471: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
472: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
473: END IF;
474:
475: IF arp_util.is_gl_date_valid(p_confirm_gl_date) THEN

Line 472: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));

468: arp_standard.debug('arp_confirmation.confirm_receipt()+');
469: arp_standard.debug('****** Begin Confirm Receipt ****** ');
470: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
471: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
472: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
473: END IF;
474:
475: IF arp_util.is_gl_date_valid(p_confirm_gl_date) THEN
476:

Line 496: arp_standard.debug('==> Receipt ' || to_char(p_cr_id) || ' confirmed');

492: p_confirm_date,
493: 'ARXRWMAI',
494: '1x');
495: IF PG_DEBUG in ('Y', 'C') THEN
496: arp_standard.debug('==> Receipt ' || to_char(p_cr_id) || ' confirmed');
497: END IF;
498:
499: END IF;
500: IF PG_DEBUG in ('Y', 'C') THEN

Line 501: arp_standard.debug('arp_confirmation.confirm_receipt: Invalid GL DATE ' || to_char(p_confirm_gl_date));

497: END IF;
498:
499: END IF;
500: IF PG_DEBUG in ('Y', 'C') THEN
501: arp_standard.debug('arp_confirmation.confirm_receipt: Invalid GL DATE ' || to_char(p_confirm_gl_date));
502: END IF;
503: END IF;
504: IF PG_DEBUG in ('Y', 'C') THEN
505: arp_standard.debug('arp_confirmation.confirm_receipt()-');

Line 505: arp_standard.debug('arp_confirmation.confirm_receipt()-');

501: arp_standard.debug('arp_confirmation.confirm_receipt: Invalid GL DATE ' || to_char(p_confirm_gl_date));
502: END IF;
503: END IF;
504: IF PG_DEBUG in ('Y', 'C') THEN
505: arp_standard.debug('arp_confirmation.confirm_receipt()-');
506: END IF;
507:
508: EXCEPTION
509: WHEN OTHERS THEN

Line 511: arp_standard.debug('EXCEPTION: arp_confirmation.confirm_receipt');

507:
508: EXCEPTION
509: WHEN OTHERS THEN
510: IF PG_DEBUG in ('Y', 'C') THEN
511: arp_standard.debug('EXCEPTION: arp_confirmation.confirm_receipt');
512: END IF;
513: RAISE;
514: END confirm_receipt; -- confirm_receipt()
515: /* End Bug fix 872506 */

Line 635: arp_standard.debug('arp_confirmation.do_confirm()+');

631: AND reversal_gl_date IS NULL;
632:
633: BEGIN
634:
635: arp_standard.debug('arp_confirmation.do_confirm()+');
636:
637: -- initialize l_max_dates:
638:
639: l_max_dates.max_trx_date := p_confirm_date;

Line 656: arp_standard.debug('-- Fetched ra record -- ra_id = '||

652: -- let calc_acctd_amount calculate.
653:
654: l_acctd_app_amount_from := NULL;
655:
656: arp_standard.debug('-- Fetched ra record -- ra_id = '||
657: l_ra_rec.receivable_application_id);
658:
659: -- get payment schedule of invoice for this application. This
660: -- is required to update the 'selected_for_receipt_batch_id' column.

Line 664: arp_standard.debug('-- Fetched invoice ps record. ps_id = '||

660: -- is required to update the 'selected_for_receipt_batch_id' column.
661:
662: arp_ps_pkg.fetch_p(l_ra_rec.applied_payment_schedule_id, l_inv_ps_rec);
663:
664: arp_standard.debug('-- Fetched invoice ps record. ps_id = '||
665: to_char(l_ra_rec.applied_payment_schedule_id));
666:
667: -- determine dates based on receivable_application and payment_schedule
668: -- record:

Line 688: arp_standard.debug('-- determined max_dates');

684: l_apply_date,
685: p_confirm_date,
686: p_confirm_gl_date);
687:
688: arp_standard.debug('-- determined max_dates');
689:
690: -- check for violation of application rules (over-application,
691: -- creation sign, natural application).
692:

Line 698: arp_standard.debug('-- got application flags');

694: l_ao_flag,
695: l_nao_flag,
696: l_creation_sign);
697:
698: arp_standard.debug('-- got application flags');
699:
700: /*@ check_application_rules(l_ra_rec); */ -- ?????????????????????????
701:
702: -- update invoice payment schedule to which this application record

Line 739: arp_standard.debug('-- invoice ps updated.');

735: l_charges_uediscounted,
736: l_rule_set_id,
737: l_inv_ps_rec);
738:
739: arp_standard.debug('-- invoice ps updated.');
740: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
741: to_char(l_acctd_app_amount_to));
742: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
743: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));

Line 740: arp_standard.debug('-- l_acctd_app_amount_to = ' ||

736: l_rule_set_id,
737: l_inv_ps_rec);
738:
739: arp_standard.debug('-- invoice ps updated.');
740: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
741: to_char(l_acctd_app_amount_to));
742: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
743: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
744: arp_standard.debug('-- l_freight_applied = ' ||

Line 742: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));

738:
739: arp_standard.debug('-- invoice ps updated.');
740: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
741: to_char(l_acctd_app_amount_to));
742: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
743: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
744: arp_standard.debug('-- l_freight_applied = ' ||
745: to_char(l_freight_applied));
746: arp_standard.debug('-- l_charges_applied = ' ||

Line 743: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));

739: arp_standard.debug('-- invoice ps updated.');
740: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
741: to_char(l_acctd_app_amount_to));
742: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
743: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
744: arp_standard.debug('-- l_freight_applied = ' ||
745: to_char(l_freight_applied));
746: arp_standard.debug('-- l_charges_applied = ' ||
747: to_char(l_charges_applied));

Line 744: arp_standard.debug('-- l_freight_applied = ' ||

740: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
741: to_char(l_acctd_app_amount_to));
742: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
743: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
744: arp_standard.debug('-- l_freight_applied = ' ||
745: to_char(l_freight_applied));
746: arp_standard.debug('-- l_charges_applied = ' ||
747: to_char(l_charges_applied));
748:

Line 746: arp_standard.debug('-- l_charges_applied = ' ||

742: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
743: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
744: arp_standard.debug('-- l_freight_applied = ' ||
745: to_char(l_freight_applied));
746: arp_standard.debug('-- l_charges_applied = ' ||
747: to_char(l_charges_applied));
748:
749:
750: -- calculate accounted amount for application (receipt side):

Line 764: arp_standard.debug('-- calculated acctd_app_amount_from = ' ||

760: l_dummy,
761: l_dummy,
762: l_dummy);
763:
764: arp_standard.debug('-- calculated acctd_app_amount_from = ' ||
765: to_char(l_acctd_app_amount_from));
766: arp_standard.debug('-- amount_applied for ra = '||
767: to_char(l_ra_rec.amount_applied));
768:

Line 766: arp_standard.debug('-- amount_applied for ra = '||

762: l_dummy);
763:
764: arp_standard.debug('-- calculated acctd_app_amount_from = ' ||
765: to_char(l_acctd_app_amount_from));
766: arp_standard.debug('-- amount_applied for ra = '||
767: to_char(l_ra_rec.amount_applied));
768:
769: -- Update receivable applications record. Use the return values
770: -- of the previous function call to fill the line, tax, freight,

Line 798: arp_standard.debug('-- ra record updated.');

794: last_updated_by = FND_GLOBAL.user_id
795: WHERE
796: receivable_application_id = l_ra_rec.receivable_application_id;
797:
798: arp_standard.debug('-- ra record updated.');
799:
800: -- call mrc to replicate the data
801: ar_mrc_engine3.confirm_ra_rec_update(
802: l_ra_rec.receivable_application_id);

Line 804: arp_standard.debug('-- MRC ra record updated if necessary');

800: -- call mrc to replicate the data
801: ar_mrc_engine3.confirm_ra_rec_update(
802: l_ra_rec.receivable_application_id);
803:
804: arp_standard.debug('-- MRC ra record updated if necessary');
805:
806: --
807: --Release 11.5 VAT changes, create the application accounting for
808: --confirmed APP record in ar_distributions. In this case we create

Line 832: arp_standard.debug( 'calling receipt_analyzer in application mode');

828: --
829: -- call revenue management engine's receipt analyzer for revenue related
830: -- impact of this application.
831:
832: arp_standard.debug( 'calling receipt_analyzer in application mode');
833:
834: -- RAM-C changes begin.
835: --
836: -- get the invoice currency and the exchange rate

Line 858: arp_standard.debug( 'returned from receipt_analyzer');

854: p_line_applied => l_line_applied,
855: p_gl_date => l_max_dates.max_ra_gl_date
856: );
857:
858: arp_standard.debug( 'returned from receipt_analyzer');
859:
860: -- RAM-C changes end at this point.
861:
862: --apandit

Line 864: arp_standard.debug( 'before raising the business event : Raise_CR_Apply_Event');

860: -- RAM-C changes end at this point.
861:
862: --apandit
863: --Bug 2641517 rase CR apply business event upon confirmation
864: arp_standard.debug( 'before raising the business event : Raise_CR_Apply_Event');
865: AR_BUS_EVENT_COVER.Raise_CR_Apply_Event(
866: l_ra_rec.receivable_application_id);
867: END LOOP;
868:

Line 893: arp_standard.debug('arp_confirmation.do_confirm()-');

889: -- as UNAPP records are paired with their APP records
890:
891: create_matching_unapp_records(p_cr_rec.cash_receipt_id, l_app_id);
892:
893: arp_standard.debug('arp_confirmation.do_confirm()-');
894:
895: EXCEPTION
896: WHEN NO_DATA_FOUND THEN
897: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');

Line 1061: arp_standard.debug('arp_confirmation.update_cr_history_confirm()+');

1057:
1058: --
1059: BEGIN
1060:
1061: arp_standard.debug('arp_confirmation.update_cr_history_confirm()+');
1062:
1063: -- fetch current record from ar_cash_receipt_history
1064:
1065: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);

Line 1067: arp_standard.debug('-- current history record fetched. crh_id = '||

1063: -- fetch current record from ar_cash_receipt_history
1064:
1065: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);
1066:
1067: arp_standard.debug('-- current history record fetched. crh_id = '||
1068: to_char(l_crh_rec_old.cash_receipt_history_id));
1069:
1070: -- update columns in current record
1071:

Line 1109: arp_standard.debug('-- new crh record inserted. crh_id = ' ||

1105: -- insert new current record into cash receipt history table
1106:
1107: arp_cr_history_pkg.insert_p(l_crh_rec_new, l_crh_id_new);
1108:
1109: arp_standard.debug('-- new crh record inserted. crh_id = ' ||
1110: to_char(l_crh_id_new));
1111:
1112: -- link new current record to previous current record and update the latter:
1113:

Line 1117: arp_standard.debug('-- previous record updated');

1113:
1114: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_id_new;
1115: arp_cr_history_pkg.update_p(l_crh_rec_old);
1116:
1117: arp_standard.debug('-- previous record updated');
1118:
1119: -- create ar_distributions record for new history record:
1120:
1121: arp_standard.debug('-- ccid = ' || p_receipt_clearing_ccid);

Line 1121: arp_standard.debug('-- ccid = ' || p_receipt_clearing_ccid);

1117: arp_standard.debug('-- previous record updated');
1118:
1119: -- create ar_distributions record for new history record:
1120:
1121: arp_standard.debug('-- ccid = ' || p_receipt_clearing_ccid);
1122: l_dist_rec.source_id := l_crh_id_new;
1123: l_dist_rec.source_table := 'CRH';
1124: l_dist_rec.source_type := 'CONFIRMATION';
1125: l_dist_rec.last_update_date := SYSDATE;

Line 1169: arp_standard.debug('-- distribution record inserted. dist_line_id = '||

1165: p_mode => 'SINGLE',
1166: p_key_value => l_dist_line_id,
1167: p_row_info => l_dist_rec);
1168:
1169: arp_standard.debug('-- distribution record inserted. dist_line_id = '||
1170: to_char(l_dist_line_id));
1171:
1172: arp_standard.debug('update_cr_history_confirm()-');
1173:

Line 1172: arp_standard.debug('update_cr_history_confirm()-');

1168:
1169: arp_standard.debug('-- distribution record inserted. dist_line_id = '||
1170: to_char(l_dist_line_id));
1171:
1172: arp_standard.debug('update_cr_history_confirm()-');
1173:
1174: EXCEPTION
1175: WHEN OTHERS THEN
1176: arp_util.debug('EXCEPTION: update_cr_history_confirm()');

Line 1227: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()+');

1223: l_dummy NUMBER;
1224:
1225: BEGIN
1226:
1227: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()+');
1228: -- Fetch receipt's payment schedule record:
1229:
1230: SELECT *
1231: INTO l_receipt_ps_rec

Line 1253: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()-');

1249: p_closed_gl_date,
1250: l_dummy,
1251: l_receipt_ps_rec);
1252:
1253: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()-');
1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: arp_util.debug('EXCEPTION: arp_confirmation.confirm_update_ps_rec()');

Line 1326: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');

1322: AND app.application_rule IN ('97.0', '40.0');
1323:
1324: -- update record
1325:
1326: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');
1327:
1328: UPDATE ar_receivable_applications
1329: SET gl_date = p_confirm_gl_date,
1330: apply_date = p_confirm_date,

Line 1358: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');

1354: l_ae_doc_rec.other_flag := '';
1355: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1356:
1357:
1358: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');
1359:
1360: EXCEPTION
1361: WHEN NO_DATA_FOUND THEN
1362: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.modify_update_ra_rec()');

Line 1451: arp_standard.debug('arp_confirmation.create_matching_unapp_records()+');

1447: AND unapp.status||'' = 'UNAPP';
1448:
1449: BEGIN
1450:
1451: arp_standard.debug('arp_confirmation.create_matching_unapp_records()+');
1452:
1453:
1454: FOR l_unapp_rec in get_rec_records LOOP
1455:

Line 1625: arp_standard.debug('arp_confirmation.create_matching_unapp_records()-');

1621: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1622:
1623: END LOOP;
1624:
1625: arp_standard.debug('arp_confirmation.create_matching_unapp_records()-');
1626:
1627: EXCEPTION
1628: WHEN NO_DATA_FOUND THEN
1629: arp_util.debug('EXCEPTION: NO DATA FOUND arp_confirmation.create_matching_unapp_records()');

Line 1675: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()+');

1671: ) IS
1672:
1673: BEGIN
1674:
1675: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()+');
1676:
1677: SELECT rma.receipt_clearing_ccid
1678: INTO p_receipt_clearing_ccid
1679: FROM ar_receipt_method_accounts rma

Line 1683: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()-');

1679: FROM ar_receipt_method_accounts rma
1680: WHERE rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1681: AND rma.receipt_method_id = p_cr_rec.receipt_method_id;
1682:
1683: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()-');
1684:
1685: EXCEPTION
1686: WHEN OTHERS THEN
1687: arp_util.debug('EXCEPTION: arp_confirmation.get_receipt_clearing_ccid');

Line 1753: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');

1749: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1750:
1751: BEGIN
1752:
1753: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');
1754:
1755: -- fetch current record from ar_cash_receipt_history
1756:
1757: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);

Line 1870: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()-');

1866:
1867: p_batch_id := l_batch_id;
1868: p_crh_id_rev := l_crh_id_rev;
1869:
1870: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()-');
1871:
1872:
1873: EXCEPTION
1874: WHEN OTHERS THEN

Line 1923: arp_standard.debug('arp_confirmation.reverse_application_to_ps()+');

1919: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1920:
1921: BEGIN
1922:
1923: arp_standard.debug('arp_confirmation.reverse_application_to_ps()+');
1924:
1925: UPDATE
1926: ar_payment_schedules ps
1927: SET (

Line 2029: arp_standard.debug('arp_confirmation.reverse_application_to_ps()-');

2025: p_table_name => 'AR_PAYMENT_SCHEDULES',
2026: p_mode => 'BATCH',
2027: p_key_value_list => l_ar_ps_key_value_list);
2028:
2029: arp_standard.debug('arp_confirmation.reverse_application_to_ps()-');
2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: arp_util.debug('EXCEPTION: arp_confirmation.reverse_application_to_ps()');

Line 2092: arp_standard.debug('arp_confirmation.reverse_ra_recs()+');

2088: n_new_con_data new_con_data; /* to store values retrieved from bulk collect */
2089:
2090: BEGIN
2091:
2092: arp_standard.debug('arp_confirmation.reverse_ra_recs()+');
2093:
2094: FOR l_app_rec IN get_app LOOP
2095:
2096: --retrieve sequence

Line 2248: arp_standard.debug( 'before raising the business event : Raise_CR_UnApply_Event');

2244: --apandit
2245: --Bug 2641517 rase business event for unapplication, we do not raise the
2246: --seperate unconfirm event as the unapplication takes care
2247: --of updating the summary tables.
2248: arp_standard.debug( 'before raising the business event : Raise_CR_UnApply_Event');
2249: AR_BUS_EVENT_COVER.Raise_CR_UnApply_Event( l_new_app_id);
2250:
2251:
2252: --

Line 2602: arp_standard.debug('arp_confirmation.reverse_ra_recs()-');

2598: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
2599: AND nvl(confirmed_flag,'Y') = 'Y'
2600: AND reversal_gl_date IS NULL;
2601:
2602: arp_standard.debug('arp_confirmation.reverse_ra_recs()-');
2603:
2604: EXCEPTION
2605: WHEN NO_DATA_FOUND THEN
2606: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');

Line 2660: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()+');

2656: l_dummy NUMBER;
2657:
2658: BEGIN
2659:
2660: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()+');
2661: -- Fetch receipt's payment schedule record:
2662:
2663: SELECT *
2664: INTO l_receipt_ps_rec

Line 2684: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()-');

2680: p_closed_gl_date,
2681: l_dummy,
2682: l_receipt_ps_rec);
2683:
2684: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()-');
2685:
2686: EXCEPTION
2687: WHEN NO_DATA_FOUND THEN
2688: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.unconfirm_update_ps_rec()');

Line 2739: arp_standard.debug('arp_confirmation.validate_in_parameters()+');

2735: ) IS
2736:
2737: BEGIN
2738:
2739: arp_standard.debug('arp_confirmation.validate_in_parameters()+');
2740:
2741: -- make sure none of the arguments is NULL:
2742:
2743: IF (p_cr_id IS NULL) THEN

Line 2744: arp_standard.debug('p_cr_id is NULL');

2740:
2741: -- make sure none of the arguments is NULL:
2742:
2743: IF (p_cr_id IS NULL) THEN
2744: arp_standard.debug('p_cr_id is NULL');
2745: FND_MESSAGE.set_name('AR','AR_ARGUEMENTS_FAIL');
2746: APP_EXCEPTION.raise_exception;
2747: END IF;
2748:

Line 2750: arp_standard.debug('p_confirm_gl_date is NULL');

2746: APP_EXCEPTION.raise_exception;
2747: END IF;
2748:
2749: IF (p_confirm_gl_date IS NULL) THEN
2750: arp_standard.debug('p_confirm_gl_date is NULL');
2751: FND_MESSAGE.set_name('AR','AR_ARGUEMENTS_FAIL');
2752: APP_EXCEPTION.raise_exception;
2753: END IF;
2754:

Line 2756: arp_standard.debug('p_confirm_date is NULL');

2752: APP_EXCEPTION.raise_exception;
2753: END IF;
2754:
2755: IF (p_confirm_date IS NULL) THEN
2756: arp_standard.debug('p_confirm_date is NULL');
2757: FND_MESSAGE.set_name('AR','AR_ARGUEMENTS_FAIL');
2758: APP_EXCEPTION.raise_exception;
2759: END IF;
2760:

Line 2763: arp_standard.debug('arp_confirmation.validate_in_parameters()-');

2759: END IF;
2760:
2761: -- ???? validate dates any further ????
2762:
2763: arp_standard.debug('arp_confirmation.validate_in_parameters()-');
2764:
2765: EXCEPTION
2766: WHEN OTHERS THEN
2767: arp_standard.debug('EXCEPTION: arp_confirmation.validate_in_parameters');

Line 2767: arp_standard.debug('EXCEPTION: arp_confirmation.validate_in_parameters');

2763: arp_standard.debug('arp_confirmation.validate_in_parameters()-');
2764:
2765: EXCEPTION
2766: WHEN OTHERS THEN
2767: arp_standard.debug('EXCEPTION: arp_confirmation.validate_in_parameters');
2768: RAISE;
2769:
2770: END; -- validate_in_parameters()
2771: