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

Line 67: arp_standard.debug('arp_process_rct_util.insert_ps_rec_cash()+');

63: l_status ar_cash_receipt_history.status%TYPE;
64: BEGIN
65:
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_standard.debug('arp_process_rct_util.insert_ps_rec_cash()+');
68: END IF;
69:
70: -- fill record columns with data from cash receipt:
71:

Line 113: arp_standard.debug('arp_process_rct_util.insert_ps_rec_cash()-');

109:
110: p_ps_id := l_ps_id;
111:
112: IF PG_DEBUG in ('Y', 'C') THEN
113: arp_standard.debug('arp_process_rct_util.insert_ps_rec_cash()-');
114: END IF;
115:
116: EXCEPTION
117: WHEN OTHERS THEN

Line 119: arp_standard.debug('EXCEPTION: arp_process_rct_util.insert_ps_rec_cash()');

115:
116: EXCEPTION
117: WHEN OTHERS THEN
118: IF PG_DEBUG in ('Y', 'C') THEN
119: arp_standard.debug('EXCEPTION: arp_process_rct_util.insert_ps_rec_cash()');
120: END IF;
121: RAISE;
122:
123: END insert_ps_rec_cash;

Line 171: arp_standard.debug('arp_process_rct_util.insert_crh_rec()+');

167: --Bug#2750340
168: l_xla_ev_rec arp_xla_events.xla_events_type;
169:
170: BEGIN
171: arp_standard.debug('arp_process_rct_util.insert_crh_rec()+');
172:
173: -- fill record columns with data from cash receipt:
174:
175: l_crh_rec.amount := p_crh_amount;

Line 237: arp_standard.debug('arp_process_rct_util.insert_crh_rec()-');

233: l_xla_ev_rec.xla_mode := 'O';
234: l_xla_ev_rec.xla_call := 'B';
235: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
236:
237: arp_standard.debug('arp_process_rct_util.insert_crh_rec()-');
238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: arp_standard.debug('EXCEPTION: arp_process_rct_util.insert_crh_rec');

Line 241: arp_standard.debug('EXCEPTION: arp_process_rct_util.insert_crh_rec');

237: arp_standard.debug('arp_process_rct_util.insert_crh_rec()-');
238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: arp_standard.debug('EXCEPTION: arp_process_rct_util.insert_crh_rec');
242: RAISE;
243:
244: END;
245:

Line 312: arp_standard.debug('arp_process_rct_util.insert_ra_rec_cash()+');

308: l_xla_ev_rec arp_xla_events.xla_events_type;
309:
310: BEGIN
311:
312: arp_standard.debug('arp_process_rct_util.insert_ra_rec_cash()+');
313:
314: -- create new receivable applications record:
315:
316: l_ra_rec.amount_applied := p_amount;

Line 349: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));

345: l_ra_rec.code_combination_id := p_ccid;
346:
347: -- call table handler to insert record
348:
349: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
350: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
351: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));

Line 350: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));

346:
347: -- call table handler to insert record
348:
349: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
350: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
351: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
354: arp_standard.debug('display = ' || l_ra_rec.display);

Line 351: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));

347: -- call table handler to insert record
348:
349: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
350: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
351: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
354: arp_standard.debug('display = ' || l_ra_rec.display);
355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);

Line 352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));

348:
349: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
350: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
351: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
354: arp_standard.debug('display = ' || l_ra_rec.display);
355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));

Line 353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));

349: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
350: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
351: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
354: arp_standard.debug('display = ' || l_ra_rec.display);
355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);

Line 354: arp_standard.debug('display = ' || l_ra_rec.display);

350: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
351: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
354: arp_standard.debug('display = ' || l_ra_rec.display);
355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));

Line 355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);

351: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
354: arp_standard.debug('display = ' || l_ra_rec.display);
355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));

Line 356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));

352: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
354: arp_standard.debug('display = ' || l_ra_rec.display);
355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));

Line 357: arp_standard.debug('status = ' || l_ra_rec.status);

353: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
354: arp_standard.debug('display = ' || l_ra_rec.display);
355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
361: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));

Line 358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));

354: arp_standard.debug('display = ' || l_ra_rec.display);
355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
361: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
362: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));

Line 359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));

355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
361: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
362: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
363: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);

Line 360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));

356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
361: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
362: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
363: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);
364:

Line 361: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));

357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
361: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
362: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
363: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);
364:
365: p_ra_id := l_ra_id;

Line 362: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));

358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
361: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
362: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
363: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);
364:
365: p_ra_id := l_ra_id;
366:

Line 391: arp_standard.debug('arp_process_rct_util.insert_ra_rec_cash()-');

387: l_xla_ev_rec.xla_mode := 'O';
388: l_xla_ev_rec.xla_call := 'B';
389: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
390:
391: arp_standard.debug('arp_process_rct_util.insert_ra_rec_cash()-');
392:
393: END; -- insert_ra_rec_cash()
394:
395:

Line 442: arp_standard.debug('arp_process_rct_util.insert_dist_rec()+');

438: --bug#2750340
439: l_xla_ev_rec arp_xla_events.xla_events_type;
440:
441: BEGIN
442: arp_standard.debug('arp_process_rct_util.insert_dist_rec()+');
443:
444: arp_standard.debug('-- getting infomation from cash receipt --');
445:
446: -- Fetch the history record

Line 444: arp_standard.debug('-- getting infomation from cash receipt --');

440:
441: BEGIN
442: arp_standard.debug('arp_process_rct_util.insert_dist_rec()+');
443:
444: arp_standard.debug('-- getting infomation from cash receipt --');
445:
446: -- Fetch the history record
447: arp_cr_history_pkg.fetch_p( p_crh_id, l_crh_rec );
448:

Line 514: arp_standard.debug('arp_process_rct_util.insert_dist_rec()-');

510: l_xla_ev_rec.xla_mode := 'O';
511: l_xla_ev_rec.xla_call := 'B';
512: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
513:
514: arp_standard.debug('arp_process_rct_util.insert_dist_rec()-');
515:
516: END; -- insert_dist_rec()
517:
518:

Line 554: arp_standard.debug('arp_process_receipts.round_mcd_recs()+');

550:
551: BEGIN
552:
553: IF PG_DEBUG in ('Y', 'C') THEN
554: arp_standard.debug('arp_process_receipts.round_mcd_recs()+');
555: END IF;
556:
557: SELECT ROUND(100 - sum(mcd.percent),3)
558: INTO l_rounding_diff

Line 567: arp_standard.debug('round_mcd_recs: ' || 'Rounding difference = ' || TO_CHAR(l_rounding_diff));

563: -- rounding error must be added to first record so that percent
564: -- values add up to 100
565: --
566: IF PG_DEBUG in ('Y', 'C') THEN
567: arp_standard.debug('round_mcd_recs: ' || 'Rounding difference = ' || TO_CHAR(l_rounding_diff));
568: END IF;
569: --
570: /*----------------------------------+
571: | Added bulk collect of misc cash |

Line 607: arp_standard.debug('arp_process_receipts.round_mcd_recs()-');

603: */
604: END IF;
605:
606: IF PG_DEBUG in ('Y', 'C') THEN
607: arp_standard.debug('arp_process_receipts.round_mcd_recs()-');
608: END IF;
609:
610: END round_mcd_recs;
611:

Line 689: arp_standard.debug('arp_process_receipts.insert_misc_dist()+');

685: l_crh_id NUMBER;
686:
687: BEGIN
688:
689: arp_standard.debug('arp_process_receipts.insert_misc_dist()+');
690:
691: arp_standard.debug('ussgl_trx code = ' || p_ussgl_trx_code);
692: -- delete existing distributions records
693:

Line 691: arp_standard.debug('ussgl_trx code = ' || p_ussgl_trx_code);

687: BEGIN
688:
689: arp_standard.debug('arp_process_receipts.insert_misc_dist()+');
690:
691: arp_standard.debug('ussgl_trx code = ' || p_ussgl_trx_code);
692: -- delete existing distributions records
693:
694: /*----------------------------------+
695: | Added bulk collect of misc cash |

Line 870: arp_standard.debug('arp_process_receipts.insert_misc_dist()-');

866: -------------------------------------------------------------
867: -- Commented out NOCOPY the above 'END IF' as part of bug fix 868448
868: --------------------------------------------------------------
869:
870: arp_standard.debug('arp_process_receipts.insert_misc_dist()-');
871:
872: END; -- arp_process_receipts.insert_misc_dist()
873:
874:

Line 937: arp_standard.debug('arp_process_receipts.update_misc_dist()+');

933: dummy varchar2(1); --Bug 6416611
934: BEGIN
935:
936: IF PG_DEBUG in ('Y', 'C') THEN
937: arp_standard.debug('arp_process_receipts.update_misc_dist()+');
938: END IF;
939:
940:
941: -- The following cases need to be distinguished with regard to

Line 1041: arp_standard.debug('update_misc_dist: ' || ' l_count ' || TO_CHAR(l_count));

1037: WHERE ard.source_id = mcd.misc_cash_distribution_id
1038: AND ard.source_table = 'MCD');
1039:
1040: IF PG_DEBUG in ('Y', 'C') THEN
1041: arp_standard.debug('update_misc_dist: ' || ' l_count ' || TO_CHAR(l_count));
1042: END IF;
1043:
1044: IF (l_count > 0) THEN
1045: SELECT distinct posting_control_id

Line 1163: arp_standard.debug('update_misc_dist: ' || 'l_new_recs_auto_flag = TRUE');

1159: END IF;
1160:
1161: IF (l_new_recs_auto_flag) THEN
1162: IF PG_DEBUG in ('Y', 'C') THEN
1163: arp_standard.debug('update_misc_dist: ' || 'l_new_recs_auto_flag = TRUE');
1164: END IF;
1165: ELSE
1166: IF PG_DEBUG in ('Y', 'C') THEN
1167: arp_standard.debug('update_misc_dist: ' || 'l_new_recs_auto_flag = FALSE');

Line 1167: arp_standard.debug('update_misc_dist: ' || 'l_new_recs_auto_flag = FALSE');

1163: arp_standard.debug('update_misc_dist: ' || 'l_new_recs_auto_flag = TRUE');
1164: END IF;
1165: ELSE
1166: IF PG_DEBUG in ('Y', 'C') THEN
1167: arp_standard.debug('update_misc_dist: ' || 'l_new_recs_auto_flag = FALSE');
1168: END IF;
1169: END IF;
1170:
1171: IF (l_old_recs_auto_flag) THEN

Line 1173: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = TRUE');

1169: END IF;
1170:
1171: IF (l_old_recs_auto_flag) THEN
1172: IF PG_DEBUG in ('Y', 'C') THEN
1173: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = TRUE');
1174: END IF;
1175: ELSE
1176: IF PG_DEBUG in ('Y', 'C') THEN
1177: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = FALSE');

Line 1177: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = FALSE');

1173: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = TRUE');
1174: END IF;
1175: ELSE
1176: IF PG_DEBUG in ('Y', 'C') THEN
1177: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = FALSE');
1178: END IF;
1179: END IF;
1180:
1181: IF PG_DEBUG in ('Y', 'C') THEN

Line 1182: arp_standard.debug('update_misc_dist: ' || 'p_distribution_set_id = ' ||

1178: END IF;
1179: END IF;
1180:
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_standard.debug('update_misc_dist: ' || 'p_distribution_set_id = ' ||
1183: to_char(p_distribution_set_id));
1184: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||
1185: to_char(p_old_distribution_set_id));
1186: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||

Line 1184: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||

1180:
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_standard.debug('update_misc_dist: ' || 'p_distribution_set_id = ' ||
1183: to_char(p_distribution_set_id));
1184: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||
1185: to_char(p_old_distribution_set_id));
1186: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||
1187: to_char(l_trx_code_combination_id));
1188: arp_standard.debug('update_misc_dist: ' || 'l_old_trx_code_combination_id = ' ||

Line 1186: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||

1182: arp_standard.debug('update_misc_dist: ' || 'p_distribution_set_id = ' ||
1183: to_char(p_distribution_set_id));
1184: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||
1185: to_char(p_old_distribution_set_id));
1186: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||
1187: to_char(l_trx_code_combination_id));
1188: arp_standard.debug('update_misc_dist: ' || 'l_old_trx_code_combination_id = ' ||
1189: to_char(l_old_trx_code_combination_id));
1190: END IF;

Line 1188: arp_standard.debug('update_misc_dist: ' || 'l_old_trx_code_combination_id = ' ||

1184: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||
1185: to_char(p_old_distribution_set_id));
1186: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||
1187: to_char(l_trx_code_combination_id));
1188: arp_standard.debug('update_misc_dist: ' || 'l_old_trx_code_combination_id = ' ||
1189: to_char(l_old_trx_code_combination_id));
1190: END IF;
1191:
1192:

Line 1299: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () +');

1295: IF (l_posted = -3) THEN
1296:
1297: -- Call accounting entry library begins
1298: IF PG_DEBUG in ('Y', 'C') THEN
1299: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () +');
1300: END IF;
1301: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1302: IF PG_DEBUG in ('Y', 'C') THEN
1303: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () -');

Line 1303: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () -');

1299: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () +');
1300: END IF;
1301: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1302: IF PG_DEBUG in ('Y', 'C') THEN
1303: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () -');
1304: END IF;
1305: END IF;
1306: END IF;
1307:

Line 1323: arp_standard.debug('update_misc_dist: ' || ' Create Acct Entry');

1319: WHERE cash_receipt_id = p_cash_receipt_id
1320: AND current_record_flag = 'Y';
1321: IF (l_posted = -3) then
1322: IF PG_DEBUG in ('Y', 'C') THEN
1323: arp_standard.debug('update_misc_dist: ' || ' Create Acct Entry');
1324: END IF;
1325: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1326: END IF;
1327: --

Line 1400: arp_standard.debug('update_misc_dist: ' || ' =====> CASE 4, 5, 6');

1396: -- created, and new ones will created automatically based on the
1397: -- ccid or distribution set.
1398:
1399: IF PG_DEBUG in ('Y', 'C') THEN
1400: arp_standard.debug('update_misc_dist: ' || ' =====> CASE 4, 5, 6');
1401: END IF;
1402:
1403: SELECT count(mcd.misc_cash_distribution_id)
1404: INTO l_count

Line 1415: arp_standard.debug('update_misc_dist: ' || ' l_count ' || TO_CHAR(l_count));

1411: WHERE ard.source_id = mcd.misc_cash_distribution_id
1412: AND ard.source_table = 'MCD');
1413:
1414: IF PG_DEBUG in ('Y', 'C') THEN
1415: arp_standard.debug('update_misc_dist: ' || ' l_count ' || TO_CHAR(l_count));
1416: END IF;
1417:
1418: l_ae_doc_rec.document_type := 'RECEIPT';
1419: l_ae_doc_rec.document_id := p_cash_receipt_id;

Line 1438: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () +');

1434: IF (l_posted = -3) THEN
1435:
1436: -- Call accounting entry library begins
1437: IF PG_DEBUG in ('Y', 'C') THEN
1438: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () +');
1439: END IF;
1440:
1441: -- Calling accounting entry library
1442: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);

Line 1444: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () -');

1440:
1441: -- Calling accounting entry library
1442: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1443: IF PG_DEBUG in ('Y', 'C') THEN
1444: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () -');
1445: END IF;
1446: END IF;
1447: END IF;
1448:

Line 1466: arp_standard.debug('update_misc_dist: ' || ' Create Acct Entry');

1462: WHERE cash_receipt_id = p_cash_receipt_id
1463: AND current_record_flag = 'Y';
1464: IF (l_posted = -3) then
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_standard.debug('update_misc_dist: ' || ' Create Acct Entry');
1467: END IF;
1468: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1469:
1470: END IF;

Line 1475: arp_standard.debug('arp_process_receipts.update_misc_dist()-');

1471: --
1472: END IF;
1473:
1474: IF PG_DEBUG in ('Y', 'C') THEN
1475: arp_standard.debug('arp_process_receipts.update_misc_dist()-');
1476: END IF;
1477:
1478: END update_misc_dist;
1479:

Line 1580: arp_standard.debug('arp_process_receipts.create_mcd_recs()+');

1576: l_crh_id NUMBER;
1577:
1578: BEGIN
1579:
1580: arp_standard.debug('arp_process_receipts.create_mcd_recs()+');
1581:
1582: SELECT minimum_accountable_unit,precision
1583: INTO l_min_unit, l_precision
1584: FROM fnd_currencies

Line 1663: p_ussgl_trx_code, arp_standard.sysparm.org_id,

1659: arp_global.set_of_books_id,
1660: dist.acctd_amount,
1661: -3,
1662: 'ARRERCT',
1663: p_ussgl_trx_code, arp_standard.sysparm.org_id,
1664: l_crh_id);
1665:
1666:
1667: l_xla_ev_rec.xla_from_doc_id := p_cash_receipt_id;

Line 1765: arp_standard.debug('arp_process_receipts.create_mcd_recs()-');

1761: -- round percentages if necessary
1762:
1763: round_mcd_recs(p_cash_receipt_id);
1764:
1765: arp_standard.debug('arp_process_receipts.create_mcd_recs()-');
1766:
1767: END; -- create_mcd_recs()
1768:
1769:

Line 1815: arp_standard.debug('arp_process_receipts.update_manual_dist()+');

1811: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1812:
1813: BEGIN
1814:
1815: arp_standard.debug('arp_process_receipts.update_manual_dist()+');
1816:
1817: SELECT minimum_accountable_unit,precision
1818: INTO l_min_unit, l_precision
1819: FROM fnd_currencies

Line 1940: arp_standard.debug('arp_process_receipts.update_manual_dist()-');

1936: -- round percent columns if necessary
1937:
1938: round_mcd_recs(p_cash_receipt_id);
1939:
1940: arp_standard.debug('arp_process_receipts.update_manual_dist()-');
1941:
1942: END; -- update_manual_dist()
1943: --
1944:

Line 2011: arp_standard.debug('arp_process_rct_util.rate_adjust()+');

2007: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2008:
2009: BEGIN
2010: IF PG_DEBUG in ('Y', 'C') THEN
2011: arp_standard.debug('arp_process_rct_util.rate_adjust()+');
2012: END IF;
2013:
2014: l_radj_rec.cash_receipt_id := p_cash_receipt_id;
2015: l_radj_rec.old_exchange_rate := p_old_exchange_rate;

Line 2054: arp_standard.profile.user_id,

2050: p_new_exchange_date,
2051: p_new_exchange_rate,
2052: p_new_exchange_rate_type,
2053: p_rate_adjust_gl_date,
2054: arp_standard.profile.user_id,
2055: sysdate,
2056: arp_standard.profile.user_id,
2057: sysdate,
2058: arp_standard.profile.last_update_login,

Line 2056: arp_standard.profile.user_id,

2052: p_new_exchange_rate_type,
2053: p_rate_adjust_gl_date,
2054: arp_standard.profile.user_id,
2055: sysdate,
2056: arp_standard.profile.user_id,
2057: sysdate,
2058: arp_standard.profile.last_update_login,
2059: TRUE,
2060: l_crh_id_out);

Line 2058: arp_standard.profile.last_update_login,

2054: arp_standard.profile.user_id,
2055: sysdate,
2056: arp_standard.profile.user_id,
2057: sysdate,
2058: arp_standard.profile.last_update_login,
2059: TRUE,
2060: l_crh_id_out);
2061:
2062: IF PG_DEBUG in ('Y', 'C') THEN

Line 2063: arp_standard.debug('arp_process_rct_util.rate_adjust()-');

2059: TRUE,
2060: l_crh_id_out);
2061:
2062: IF PG_DEBUG in ('Y', 'C') THEN
2063: arp_standard.debug('arp_process_rct_util.rate_adjust()-');
2064: END IF;
2065:
2066: EXCEPTION
2067: WHEN OTHERS THEN

Line 2069: arp_standard.debug('Exception in arp_process_rct_util.rate_adjust');

2065:
2066: EXCEPTION
2067: WHEN OTHERS THEN
2068: IF PG_DEBUG in ('Y', 'C') THEN
2069: arp_standard.debug('Exception in arp_process_rct_util.rate_adjust');
2070: END IF;
2071: RAISE;
2072:
2073: END rate_adjust;

Line 2165: arp_standard.debug('EXCEPTION: arp_process_receipts.get_ccids');

2161:
2162: EXCEPTION
2163: WHEN OTHERS THEN
2164: IF PG_DEBUG in ('Y', 'C') THEN
2165: arp_standard.debug('EXCEPTION: arp_process_receipts.get_ccids');
2166: END IF;
2167: RAISE;
2168:
2169: END get_ccids;