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 ARP_STANDARD

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

181: arp_xla_events.Create_Events( l_xla_ev_rec );
182:
183:
184: IF PG_DEBUG in ('Y', 'C') THEN
185: arp_standard.debug('arp_confirmation.confirm()-');
186: END IF;
187:
188: EXCEPTION
189: WHEN OTHERS THEN

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

253:
254: BEGIN
255:
256: IF PG_DEBUG in ('Y', 'C') THEN
257: arp_standard.debug('arp_confirmation.unconfirm()+');
258: arp_standard.debug('confirm: ' || to_char(p_cr_id));
259: END IF;
260:
261: -- validate IN parameters:

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

254: BEGIN
255:
256: IF PG_DEBUG in ('Y', 'C') THEN
257: arp_standard.debug('arp_confirmation.unconfirm()+');
258: arp_standard.debug('confirm: ' || to_char(p_cr_id));
259: END IF;
260:
261: -- validate IN parameters:
262:

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

295: l_cr_rec.amount);
296: END IF;
297:
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
300: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
301: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
302: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
303: END IF;

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

296: END IF;
297:
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
300: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
301: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
302: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
303: END IF;
304:

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

297:
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
300: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
301: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
302: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
303: END IF;
304:
305: -- update the ar_cash_receipt_history_table with a new record for

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

298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_standard.debug('confirm: ' || '-- Accounted Amount calculated:');
300: arp_standard.debug('confirm: ' || '-- Exchange Rate: ' || to_char(l_cr_rec.exchange_rate));
301: arp_standard.debug('confirm: ' || '-- Receipt Amount: ' || to_char(l_cr_rec.amount));
302: arp_standard.debug('confirm: ' || '-- Acctd Amount: ' || to_char(l_acctd_amount));
303: END IF;
304:
305: -- update the ar_cash_receipt_history_table with a new record for
306: -- this receipt. This call will also create a new ar_distributions

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

326: l_acctd_amount,
327: l_batch_id);
328:
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug('arp_confirmation.unconfirm()-');
331: END IF;
332:
333: EXCEPTION
334: WHEN OTHERS THEN

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

402: l_cash_receipt_rec confirmCursor%ROWTYPE;
403:
404: BEGIN
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_standard.debug('arp_confirmation.confirm_batch()+');
407: END IF;
408:
409: FOR l_cash_receipt_rec IN confirmCursor(p_batch_id) LOOP
410: BEGIN

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

426:
427: EXCEPTION
428: WHEN OTHERS THEN
429: IF PG_DEBUG in ('Y', 'C') THEN
430: arp_standard.debug('Exception in arp_confirmation.confirm_batch');
431: END IF;
432: ROLLBACK TO ar_confirm_batch_sp;
433: l_num_rec_error := l_num_rec_error + 1;
434: END;

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

438: p_num_rec_confirmed := l_num_rec_confirmed;
439: p_num_rec_error := l_num_rec_error;
440:
441: IF PG_DEBUG in ('Y', 'C') THEN
442: arp_standard.debug('arp_confirmation.confirm_batch()-');
443: END IF;
444:
445: END confirm_batch;
446:

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

481: l_status VARCHAR2(30);
482: l_confirmed_flag VARCHAR2(2);
483: BEGIN
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_standard.debug('arp_confirmation.confirm_receipt()+');
486: arp_standard.debug('****** Begin Confirm Receipt ****** ');
487: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
488: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
489: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));

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

482: l_confirmed_flag VARCHAR2(2);
483: BEGIN
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_standard.debug('arp_confirmation.confirm_receipt()+');
486: arp_standard.debug('****** Begin Confirm Receipt ****** ');
487: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
488: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
489: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
490: END IF;

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

483: BEGIN
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_standard.debug('arp_confirmation.confirm_receipt()+');
486: arp_standard.debug('****** Begin Confirm Receipt ****** ');
487: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
488: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
489: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
490: END IF;
491:

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

484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_standard.debug('arp_confirmation.confirm_receipt()+');
486: arp_standard.debug('****** Begin Confirm Receipt ****** ');
487: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
488: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
489: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
490: END IF;
491:
492: IF arp_util.is_gl_date_valid(p_confirm_gl_date) THEN

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

485: arp_standard.debug('arp_confirmation.confirm_receipt()+');
486: arp_standard.debug('****** Begin Confirm Receipt ****** ');
487: arp_standard.debug('confirm: ' || '-- p_cr_id : ' || to_char(p_cr_id));
488: arp_standard.debug('-- p_confirm_gl_date: ' || to_char(p_confirm_gl_date));
489: arp_standard.debug('-- p_confirm_date : ' || to_char(p_confirm_date));
490: END IF;
491:
492: IF arp_util.is_gl_date_valid(p_confirm_gl_date) THEN
493:

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

509: p_confirm_date,
510: 'ARXRWMAI',
511: '1x');
512: IF PG_DEBUG in ('Y', 'C') THEN
513: arp_standard.debug('==> Receipt ' || to_char(p_cr_id) || ' confirmed');
514: END IF;
515:
516: END IF;
517: IF PG_DEBUG in ('Y', 'C') THEN

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

514: END IF;
515:
516: END IF;
517: IF PG_DEBUG in ('Y', 'C') THEN
518: arp_standard.debug('arp_confirmation.confirm_receipt: Invalid GL DATE ' || to_char(p_confirm_gl_date));
519: END IF;
520: END IF;
521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_standard.debug('arp_confirmation.confirm_receipt()-');

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

518: arp_standard.debug('arp_confirmation.confirm_receipt: Invalid GL DATE ' || to_char(p_confirm_gl_date));
519: END IF;
520: END IF;
521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_standard.debug('arp_confirmation.confirm_receipt()-');
523: END IF;
524:
525: EXCEPTION
526: WHEN OTHERS THEN

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

524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF PG_DEBUG in ('Y', 'C') THEN
528: arp_standard.debug('EXCEPTION: arp_confirmation.confirm_receipt');
529: END IF;
530: RAISE;
531: END confirm_receipt; -- confirm_receipt()
532: /* End Bug fix 872506 */

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

648: AND reversal_gl_date IS NULL;
649:
650: BEGIN
651:
652: arp_standard.debug('arp_confirmation.do_confirm()+');
653:
654: -- initialize l_max_dates:
655:
656: l_max_dates.max_trx_date := p_confirm_date;

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

669: -- let calc_acctd_amount calculate.
670:
671: l_acctd_app_amount_from := NULL;
672:
673: arp_standard.debug('-- Fetched ra record -- ra_id = '||
674: l_ra_rec.receivable_application_id);
675:
676: -- get payment schedule of invoice for this application. This
677: -- is required to update the 'selected_for_receipt_batch_id' column.

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

677: -- is required to update the 'selected_for_receipt_batch_id' column.
678:
679: arp_ps_pkg.fetch_p(l_ra_rec.applied_payment_schedule_id, l_inv_ps_rec);
680:
681: arp_standard.debug('-- Fetched invoice ps record. ps_id = '||
682: to_char(l_ra_rec.applied_payment_schedule_id));
683:
684: -- determine dates based on receivable_application and payment_schedule
685: -- record:

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

701: l_apply_date,
702: p_confirm_date,
703: p_confirm_gl_date);
704:
705: arp_standard.debug('-- determined max_dates');
706:
707: -- check for violation of application rules (over-application,
708: -- creation sign, natural application).
709:

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

711: l_ao_flag,
712: l_nao_flag,
713: l_creation_sign);
714:
715: arp_standard.debug('-- got application flags');
716:
717: /*@ check_application_rules(l_ra_rec); */ -- ?????????????????????????
718:
719: -- update invoice payment schedule to which this application record

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

752: l_charges_uediscounted,
753: l_rule_set_id,
754: l_inv_ps_rec);
755:
756: arp_standard.debug('-- invoice ps updated.');
757: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
758: to_char(l_acctd_app_amount_to));
759: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
760: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));

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

753: l_rule_set_id,
754: l_inv_ps_rec);
755:
756: arp_standard.debug('-- invoice ps updated.');
757: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
758: to_char(l_acctd_app_amount_to));
759: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
760: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
761: arp_standard.debug('-- l_freight_applied = ' ||

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

755:
756: arp_standard.debug('-- invoice ps updated.');
757: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
758: to_char(l_acctd_app_amount_to));
759: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
760: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
761: arp_standard.debug('-- l_freight_applied = ' ||
762: to_char(l_freight_applied));
763: arp_standard.debug('-- l_charges_applied = ' ||

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

756: arp_standard.debug('-- invoice ps updated.');
757: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
758: to_char(l_acctd_app_amount_to));
759: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
760: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
761: arp_standard.debug('-- l_freight_applied = ' ||
762: to_char(l_freight_applied));
763: arp_standard.debug('-- l_charges_applied = ' ||
764: to_char(l_charges_applied));

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

757: arp_standard.debug('-- l_acctd_app_amount_to = ' ||
758: to_char(l_acctd_app_amount_to));
759: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
760: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
761: arp_standard.debug('-- l_freight_applied = ' ||
762: to_char(l_freight_applied));
763: arp_standard.debug('-- l_charges_applied = ' ||
764: to_char(l_charges_applied));
765:

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

759: arp_standard.debug('-- l_line_applied = ' || to_char(l_line_applied));
760: arp_standard.debug('-- l_tax_applied = ' || to_char(l_tax_applied));
761: arp_standard.debug('-- l_freight_applied = ' ||
762: to_char(l_freight_applied));
763: arp_standard.debug('-- l_charges_applied = ' ||
764: to_char(l_charges_applied));
765:
766:
767: -- calculate accounted amount for application (receipt side):

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

777: l_dummy,
778: l_dummy,
779: l_dummy);
780:
781: arp_standard.debug('-- calculated acctd_app_amount_from = ' ||
782: to_char(l_acctd_app_amount_from));
783: arp_standard.debug('-- amount_applied for ra = '||
784: to_char(l_ra_rec.amount_applied));
785:

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

779: l_dummy);
780:
781: arp_standard.debug('-- calculated acctd_app_amount_from = ' ||
782: to_char(l_acctd_app_amount_from));
783: arp_standard.debug('-- amount_applied for ra = '||
784: to_char(l_ra_rec.amount_applied));
785:
786: -- Update receivable applications record. Use the return values
787: -- of the previous function call to fill the line, tax, freight,

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

811: last_updated_by = FND_GLOBAL.user_id
812: WHERE
813: receivable_application_id = l_ra_rec.receivable_application_id;
814:
815: arp_standard.debug('-- ra record updated.');
816:
817: -- call mrc to replicate the data
818: ar_mrc_engine3.confirm_ra_rec_update(
819: l_ra_rec.receivable_application_id);

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

817: -- call mrc to replicate the data
818: ar_mrc_engine3.confirm_ra_rec_update(
819: l_ra_rec.receivable_application_id);
820:
821: arp_standard.debug('-- MRC ra record updated if necessary');
822:
823: --
824: --Release 11.5 VAT changes, create the application accounting for
825: --confirmed APP record in ar_distributions. In this case we create

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

845: --
846: -- call revenue management engine's receipt analyzer for revenue related
847: -- impact of this application.
848:
849: arp_standard.debug( 'calling receipt_analyzer in application mode');
850:
851: -- RAM-C changes begin.
852: --
853: -- get the invoice currency and the exchange rate

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

871: p_line_applied => l_line_applied,
872: p_gl_date => l_max_dates.max_ra_gl_date
873: );
874:
875: arp_standard.debug( 'returned from receipt_analyzer');
876:
877: -- RAM-C changes end at this point.
878:
879: --apandit

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

877: -- RAM-C changes end at this point.
878:
879: --apandit
880: --Bug 2641517 rase CR apply business event upon confirmation
881: arp_standard.debug( 'before raising the business event : Raise_CR_Apply_Event');
882: AR_BUS_EVENT_COVER.Raise_CR_Apply_Event(
883: l_ra_rec.receivable_application_id);
884: END LOOP;
885:

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

906: -- as UNAPP records are paired with their APP records
907:
908: create_matching_unapp_records(p_cr_rec.cash_receipt_id, l_app_id);
909:
910: arp_standard.debug('arp_confirmation.do_confirm()-');
911:
912: EXCEPTION
913: WHEN NO_DATA_FOUND THEN
914: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');

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

1074:
1075: --
1076: BEGIN
1077:
1078: arp_standard.debug('arp_confirmation.update_cr_history_confirm()+');
1079:
1080: -- fetch current record from ar_cash_receipt_history
1081:
1082: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);

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

1080: -- fetch current record from ar_cash_receipt_history
1081:
1082: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);
1083:
1084: arp_standard.debug('-- current history record fetched. crh_id = '||
1085: to_char(l_crh_rec_old.cash_receipt_history_id));
1086:
1087: -- update columns in current record
1088:

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

1122: -- insert new current record into cash receipt history table
1123:
1124: arp_cr_history_pkg.insert_p(l_crh_rec_new, l_crh_id_new);
1125:
1126: arp_standard.debug('-- new crh record inserted. crh_id = ' ||
1127: to_char(l_crh_id_new));
1128:
1129: -- link new current record to previous current record and update the latter:
1130:

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

1130:
1131: l_crh_rec_old.reversal_cash_receipt_hist_id := l_crh_id_new;
1132: arp_cr_history_pkg.update_p(l_crh_rec_old);
1133:
1134: arp_standard.debug('-- previous record updated');
1135:
1136: -- create ar_distributions record for new history record:
1137:
1138: arp_standard.debug('-- ccid = ' || p_receipt_clearing_ccid);

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

1134: arp_standard.debug('-- previous record updated');
1135:
1136: -- create ar_distributions record for new history record:
1137:
1138: arp_standard.debug('-- ccid = ' || p_receipt_clearing_ccid);
1139: l_dist_rec.source_id := l_crh_id_new;
1140: l_dist_rec.source_table := 'CRH';
1141: l_dist_rec.source_type := 'CONFIRMATION';
1142: l_dist_rec.last_update_date := SYSDATE;

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

1182: p_mode => 'SINGLE',
1183: p_key_value => l_dist_line_id,
1184: p_row_info => l_dist_rec);
1185:
1186: arp_standard.debug('-- distribution record inserted. dist_line_id = '||
1187: to_char(l_dist_line_id));
1188:
1189: arp_standard.debug('update_cr_history_confirm()-');
1190:

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

1185:
1186: arp_standard.debug('-- distribution record inserted. dist_line_id = '||
1187: to_char(l_dist_line_id));
1188:
1189: arp_standard.debug('update_cr_history_confirm()-');
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: arp_util.debug('EXCEPTION: update_cr_history_confirm()');

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

1240: l_dummy NUMBER;
1241:
1242: BEGIN
1243:
1244: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()+');
1245: -- Fetch receipt's payment schedule record:
1246:
1247: SELECT *
1248: INTO l_receipt_ps_rec

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

1266: p_closed_gl_date,
1267: l_dummy,
1268: l_receipt_ps_rec);
1269:
1270: arp_standard.debug('arp_confirmation.confirm_update_ps_rec()-');
1271:
1272: EXCEPTION
1273: WHEN OTHERS THEN
1274: arp_util.debug('EXCEPTION: arp_confirmation.confirm_update_ps_rec()');

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

1339: AND app.application_rule IN ('97.0', '40.0');
1340:
1341: -- update record
1342:
1343: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');
1344:
1345: UPDATE ar_receivable_applications
1346: SET gl_date = p_confirm_gl_date,
1347: apply_date = p_confirm_date,

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

1371: l_ae_doc_rec.other_flag := '';
1372: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1373:
1374:
1375: arp_standard.debug('arp_confirmation.modify_update_ra_rec()+');
1376:
1377: EXCEPTION
1378: WHEN NO_DATA_FOUND THEN
1379: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.modify_update_ra_rec()');

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

1464: AND unapp.status||'' = 'UNAPP';
1465:
1466: BEGIN
1467:
1468: arp_standard.debug('arp_confirmation.create_matching_unapp_records()+');
1469:
1470:
1471: FOR l_unapp_rec in get_rec_records LOOP
1472:

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

1638: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1639:
1640: END LOOP;
1641:
1642: arp_standard.debug('arp_confirmation.create_matching_unapp_records()-');
1643:
1644: EXCEPTION
1645: WHEN NO_DATA_FOUND THEN
1646: arp_util.debug('EXCEPTION: NO DATA FOUND arp_confirmation.create_matching_unapp_records()');

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

1688: ) IS
1689:
1690: BEGIN
1691:
1692: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()+');
1693:
1694: SELECT rma.receipt_clearing_ccid
1695: INTO p_receipt_clearing_ccid
1696: FROM ar_receipt_method_accounts rma

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

1696: FROM ar_receipt_method_accounts rma
1697: WHERE rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1698: AND rma.receipt_method_id = p_cr_rec.receipt_method_id;
1699:
1700: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()-');
1701:
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: arp_util.debug('EXCEPTION: arp_confirmation.get_receipt_clearing_ccid');

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

1766: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1767:
1768: BEGIN
1769:
1770: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()+');
1771:
1772: -- fetch current record from ar_cash_receipt_history
1773:
1774: arp_cr_history_pkg.fetch_f_crid(p_cr_rec.cash_receipt_id, l_crh_rec_old);

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

1883:
1884: p_batch_id := l_batch_id;
1885: p_crh_id_rev := l_crh_id_rev;
1886:
1887: arp_standard.debug('arp_confirmation.update_cr_history_unconfirm()-');
1888:
1889:
1890: EXCEPTION
1891: WHEN OTHERS THEN

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

1936: l_ar_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1937:
1938: BEGIN
1939:
1940: arp_standard.debug('arp_confirmation.reverse_application_to_ps()+');
1941:
1942: UPDATE
1943: ar_payment_schedules ps
1944: SET (

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

2042: p_table_name => 'AR_PAYMENT_SCHEDULES',
2043: p_mode => 'BATCH',
2044: p_key_value_list => l_ar_ps_key_value_list);
2045:
2046: arp_standard.debug('arp_confirmation.reverse_application_to_ps()-');
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: arp_util.debug('EXCEPTION: arp_confirmation.reverse_application_to_ps()');

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

2105: n_new_con_data new_con_data; /* to store values retrieved from bulk collect */
2106:
2107: BEGIN
2108:
2109: arp_standard.debug('arp_confirmation.reverse_ra_recs()+');
2110:
2111: FOR l_app_rec IN get_app LOOP
2112:
2113: --retrieve sequence

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

2261: --apandit
2262: --Bug 2641517 rase business event for unapplication, we do not raise the
2263: --seperate unconfirm event as the unapplication takes care
2264: --of updating the summary tables.
2265: arp_standard.debug( 'before raising the business event : Raise_CR_UnApply_Event');
2266: AR_BUS_EVENT_COVER.Raise_CR_UnApply_Event( l_new_app_id);
2267:
2268:
2269: --

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

2615: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
2616: AND nvl(confirmed_flag,'Y') = 'Y'
2617: AND reversal_gl_date IS NULL;
2618:
2619: arp_standard.debug('arp_confirmation.reverse_ra_recs()-');
2620:
2621: EXCEPTION
2622: WHEN NO_DATA_FOUND THEN
2623: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.do_confirm()');

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

2673: l_dummy NUMBER;
2674:
2675: BEGIN
2676:
2677: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()+');
2678: -- Fetch receipt's payment schedule record:
2679:
2680: SELECT *
2681: INTO l_receipt_ps_rec

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

2697: p_closed_gl_date,
2698: l_dummy,
2699: l_receipt_ps_rec);
2700:
2701: arp_standard.debug('arp_confirmation.unconfirm_update_ps_rec()-');
2702:
2703: EXCEPTION
2704: WHEN NO_DATA_FOUND THEN
2705: arp_util.debug('EXCEPTION: NO DATA FOUND, arp_confirmation.unconfirm_update_ps_rec()');

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

2752: ) IS
2753:
2754: BEGIN
2755:
2756: arp_standard.debug('arp_confirmation.validate_in_parameters()+');
2757:
2758: -- make sure none of the arguments is NULL:
2759:
2760: IF (p_cr_id IS NULL) THEN

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

2757:
2758: -- make sure none of the arguments is NULL:
2759:
2760: IF (p_cr_id IS NULL) THEN
2761: arp_standard.debug('p_cr_id is NULL');
2762: FND_MESSAGE.set_name('AR','AR_ARGUEMENTS_FAIL');
2763: APP_EXCEPTION.raise_exception;
2764: END IF;
2765:

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

2763: APP_EXCEPTION.raise_exception;
2764: END IF;
2765:
2766: IF (p_confirm_gl_date IS NULL) THEN
2767: arp_standard.debug('p_confirm_gl_date is NULL');
2768: FND_MESSAGE.set_name('AR','AR_ARGUEMENTS_FAIL');
2769: APP_EXCEPTION.raise_exception;
2770: END IF;
2771:

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

2769: APP_EXCEPTION.raise_exception;
2770: END IF;
2771:
2772: IF (p_confirm_date IS NULL) THEN
2773: arp_standard.debug('p_confirm_date is NULL');
2774: FND_MESSAGE.set_name('AR','AR_ARGUEMENTS_FAIL');
2775: APP_EXCEPTION.raise_exception;
2776: END IF;
2777:

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

2776: END IF;
2777:
2778: -- ???? validate dates any further ????
2779:
2780: arp_standard.debug('arp_confirmation.validate_in_parameters()-');
2781:
2782: EXCEPTION
2783: WHEN OTHERS THEN
2784: arp_standard.debug('EXCEPTION: arp_confirmation.validate_in_parameters');

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

2780: arp_standard.debug('arp_confirmation.validate_in_parameters()-');
2781:
2782: EXCEPTION
2783: WHEN OTHERS THEN
2784: arp_standard.debug('EXCEPTION: arp_confirmation.validate_in_parameters');
2785: RAISE;
2786:
2787: END; -- validate_in_parameters()
2788: