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 ARP_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 172: arp_standard.debug('arp_process_rct_util.insert_crh_rec()+');

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

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

242: l_xla_ev_rec.xla_call := 'B';
243: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
244: END IF;
245:
246: arp_standard.debug('arp_process_rct_util.insert_crh_rec()-');
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: arp_standard.debug('EXCEPTION: arp_process_rct_util.insert_crh_rec');

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

246: arp_standard.debug('arp_process_rct_util.insert_crh_rec()-');
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: arp_standard.debug('EXCEPTION: arp_process_rct_util.insert_crh_rec');
251: RAISE;
252:
253: END;
254:

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

317: l_xla_ev_rec arp_xla_events.xla_events_type;
318:
319: BEGIN
320:
321: arp_standard.debug('arp_process_rct_util.insert_ra_rec_cash()+');
322:
323: -- create new receivable applications record:
324:
325: l_ra_rec.amount_applied := p_amount;

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

354: l_ra_rec.code_combination_id := p_ccid;
355:
356: -- call table handler to insert record
357:
358: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
359: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
360: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
361: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));

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

355:
356: -- call table handler to insert record
357:
358: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
359: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
360: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
361: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
363: arp_standard.debug('display = ' || l_ra_rec.display);

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

356: -- call table handler to insert record
357:
358: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
359: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
360: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
361: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
363: arp_standard.debug('display = ' || l_ra_rec.display);
364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);

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

357:
358: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
359: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
360: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
361: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
363: arp_standard.debug('display = ' || l_ra_rec.display);
364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));

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

358: arp_standard.debug('amount_applied = ' || to_char(l_ra_rec.amount_applied));
359: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
360: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
361: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
363: arp_standard.debug('display = ' || l_ra_rec.display);
364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
366: arp_standard.debug('status = ' || l_ra_rec.status);

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

359: arp_standard.debug('acctd_amount_applied_from = ' || to_char(l_ra_rec.acctd_amount_applied_from));
360: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
361: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
363: arp_standard.debug('display = ' || l_ra_rec.display);
364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
366: arp_standard.debug('status = ' || l_ra_rec.status);
367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));

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

360: arp_standard.debug('cash_receipt_id = ' || to_char(l_ra_rec.cash_receipt_id));
361: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
363: arp_standard.debug('display = ' || l_ra_rec.display);
364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
366: arp_standard.debug('status = ' || l_ra_rec.status);
367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
368: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));

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

361: arp_standard.debug('gl_date = ' || to_char(l_ra_rec.gl_date));
362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
363: arp_standard.debug('display = ' || l_ra_rec.display);
364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
366: arp_standard.debug('status = ' || l_ra_rec.status);
367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
368: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
369: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));

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

362: arp_standard.debug('apply_date = ' || to_char(l_ra_rec.apply_date));
363: arp_standard.debug('display = ' || l_ra_rec.display);
364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
366: arp_standard.debug('status = ' || l_ra_rec.status);
367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
368: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
369: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
370: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));

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

363: arp_standard.debug('display = ' || l_ra_rec.display);
364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
366: arp_standard.debug('status = ' || l_ra_rec.status);
367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
368: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
369: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
370: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
371: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));

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

364: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
366: arp_standard.debug('status = ' || l_ra_rec.status);
367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
368: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
369: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
370: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
371: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
372: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);

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

365: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
366: arp_standard.debug('status = ' || l_ra_rec.status);
367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
368: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
369: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
370: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
371: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
372: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);
373:

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

366: arp_standard.debug('status = ' || l_ra_rec.status);
367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
368: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
369: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
370: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
371: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
372: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);
373:
374: p_ra_id := l_ra_id;

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

367: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
368: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
369: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
370: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
371: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
372: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);
373:
374: p_ra_id := l_ra_id;
375:

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

398: l_xla_ev_rec.xla_mode := 'O';
399: l_xla_ev_rec.xla_call := 'B';
400: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
401: END IF;
402: arp_standard.debug('arp_process_rct_util.insert_ra_rec_cash()-');
403:
404: END; -- insert_ra_rec_cash()
405:
406:

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

450: --bug#2750340
451: l_xla_ev_rec arp_xla_events.xla_events_type;
452:
453: BEGIN
454: arp_standard.debug('arp_process_rct_util.insert_dist_rec()+');
455:
456: arp_standard.debug('-- getting infomation from cash receipt --');
457:
458: -- Fetch the history record

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

452:
453: BEGIN
454: arp_standard.debug('arp_process_rct_util.insert_dist_rec()+');
455:
456: arp_standard.debug('-- getting infomation from cash receipt --');
457:
458: -- Fetch the history record
459: arp_cr_history_pkg.fetch_p( p_crh_id, l_crh_rec );
460:

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

525: l_xla_ev_rec.xla_call := 'B';
526: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
527: END IF;
528:
529: arp_standard.debug('arp_process_rct_util.insert_dist_rec()-');
530:
531: END; -- insert_dist_rec()
532:
533:

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

565:
566: BEGIN
567:
568: IF PG_DEBUG in ('Y', 'C') THEN
569: arp_standard.debug('arp_process_receipts.round_mcd_recs()+');
570: END IF;
571:
572: SELECT ROUND(100 - sum(mcd.percent),3)
573: INTO l_rounding_diff

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

578: -- rounding error must be added to first record so that percent
579: -- values add up to 100
580: --
581: IF PG_DEBUG in ('Y', 'C') THEN
582: arp_standard.debug('round_mcd_recs: ' || 'Rounding difference = ' || TO_CHAR(l_rounding_diff));
583: END IF;
584: --
585: /*----------------------------------+
586: | Added bulk collect of misc cash |

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

618: */
619: END IF;
620:
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('arp_process_receipts.round_mcd_recs()-');
623: END IF;
624:
625: END round_mcd_recs;
626:

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

700: l_crh_id NUMBER;
701:
702: BEGIN
703:
704: arp_standard.debug('arp_process_receipts.insert_misc_dist()+');
705:
706: arp_standard.debug('ussgl_trx code = ' || p_ussgl_trx_code);
707: -- delete existing distributions records
708:

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

702: BEGIN
703:
704: arp_standard.debug('arp_process_receipts.insert_misc_dist()+');
705:
706: arp_standard.debug('ussgl_trx code = ' || p_ussgl_trx_code);
707: -- delete existing distributions records
708:
709: /*----------------------------------+
710: | Added bulk collect of misc cash |

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

881: -------------------------------------------------------------
882: -- Commented out NOCOPY the above 'END IF' as part of bug fix 868448
883: --------------------------------------------------------------
884:
885: arp_standard.debug('arp_process_receipts.insert_misc_dist()-');
886:
887: END; -- arp_process_receipts.insert_misc_dist()
888:
889:

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

948: dummy varchar2(1); --Bug 6416611
949: BEGIN
950:
951: IF PG_DEBUG in ('Y', 'C') THEN
952: arp_standard.debug('arp_process_receipts.update_misc_dist()+');
953: END IF;
954:
955:
956: -- The following cases need to be distinguished with regard to

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

1052: WHERE ard.source_id = mcd.misc_cash_distribution_id
1053: AND ard.source_table = 'MCD');
1054:
1055: IF PG_DEBUG in ('Y', 'C') THEN
1056: arp_standard.debug('update_misc_dist: ' || ' l_count ' || TO_CHAR(l_count));
1057: END IF;
1058:
1059: IF (l_count > 0) THEN
1060: SELECT distinct posting_control_id

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

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

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

1178: arp_standard.debug('update_misc_dist: ' || 'l_new_recs_auto_flag = TRUE');
1179: END IF;
1180: ELSE
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_standard.debug('update_misc_dist: ' || 'l_new_recs_auto_flag = FALSE');
1183: END IF;
1184: END IF;
1185:
1186: IF (l_old_recs_auto_flag) THEN

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

1184: END IF;
1185:
1186: IF (l_old_recs_auto_flag) THEN
1187: IF PG_DEBUG in ('Y', 'C') THEN
1188: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = TRUE');
1189: END IF;
1190: ELSE
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = FALSE');

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

1188: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = TRUE');
1189: END IF;
1190: ELSE
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_standard.debug('update_misc_dist: ' || 'l_old_recs_auto_flag = FALSE');
1193: END IF;
1194: END IF;
1195:
1196: IF PG_DEBUG in ('Y', 'C') THEN

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

1193: END IF;
1194: END IF;
1195:
1196: IF PG_DEBUG in ('Y', 'C') THEN
1197: arp_standard.debug('update_misc_dist: ' || 'p_distribution_set_id = ' ||
1198: to_char(p_distribution_set_id));
1199: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||
1200: to_char(p_old_distribution_set_id));
1201: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||

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

1195:
1196: IF PG_DEBUG in ('Y', 'C') THEN
1197: arp_standard.debug('update_misc_dist: ' || 'p_distribution_set_id = ' ||
1198: to_char(p_distribution_set_id));
1199: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||
1200: to_char(p_old_distribution_set_id));
1201: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||
1202: to_char(l_trx_code_combination_id));
1203: arp_standard.debug('update_misc_dist: ' || 'l_old_trx_code_combination_id = ' ||

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

1197: arp_standard.debug('update_misc_dist: ' || 'p_distribution_set_id = ' ||
1198: to_char(p_distribution_set_id));
1199: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||
1200: to_char(p_old_distribution_set_id));
1201: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||
1202: to_char(l_trx_code_combination_id));
1203: arp_standard.debug('update_misc_dist: ' || 'l_old_trx_code_combination_id = ' ||
1204: to_char(l_old_trx_code_combination_id));
1205: END IF;

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

1199: arp_standard.debug('update_misc_dist: ' || 'p_old_distribution_set_id = ' ||
1200: to_char(p_old_distribution_set_id));
1201: arp_standard.debug('update_misc_dist: ' || 'l_trx_code_combination_id = ' ||
1202: to_char(l_trx_code_combination_id));
1203: arp_standard.debug('update_misc_dist: ' || 'l_old_trx_code_combination_id = ' ||
1204: to_char(l_old_trx_code_combination_id));
1205: END IF;
1206:
1207:

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

1310: IF (l_posted = -3) THEN
1311:
1312: -- Call accounting entry library begins
1313: IF PG_DEBUG in ('Y', 'C') THEN
1314: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () +');
1315: END IF;
1316: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1317: IF PG_DEBUG in ('Y', 'C') THEN
1318: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () -');

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

1314: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () +');
1315: END IF;
1316: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1317: IF PG_DEBUG in ('Y', 'C') THEN
1318: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () -');
1319: END IF;
1320: END IF;
1321: END IF;
1322:

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

1334: WHERE cash_receipt_id = p_cash_receipt_id
1335: AND current_record_flag = 'Y';
1336: IF (l_posted = -3) then
1337: IF PG_DEBUG in ('Y', 'C') THEN
1338: arp_standard.debug('update_misc_dist: ' || ' Create Acct Entry');
1339: END IF;
1340: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1341: END IF;
1342: --

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

1411: -- created, and new ones will created automatically based on the
1412: -- ccid or distribution set.
1413:
1414: IF PG_DEBUG in ('Y', 'C') THEN
1415: arp_standard.debug('update_misc_dist: ' || ' =====> CASE 4, 5, 6');
1416: END IF;
1417:
1418: SELECT count(mcd.misc_cash_distribution_id)
1419: INTO l_count

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

1426: WHERE ard.source_id = mcd.misc_cash_distribution_id
1427: AND ard.source_table = 'MCD');
1428:
1429: IF PG_DEBUG in ('Y', 'C') THEN
1430: arp_standard.debug('update_misc_dist: ' || ' l_count ' || TO_CHAR(l_count));
1431: END IF;
1432:
1433: l_ae_doc_rec.document_type := 'RECEIPT';
1434: l_ae_doc_rec.document_id := p_cash_receipt_id;

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

1449: IF (l_posted = -3) THEN
1450:
1451: -- Call accounting entry library begins
1452: IF PG_DEBUG in ('Y', 'C') THEN
1453: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () +');
1454: END IF;
1455:
1456: -- Calling accounting entry library
1457: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);

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

1455:
1456: -- Calling accounting entry library
1457: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1458: IF PG_DEBUG in ('Y', 'C') THEN
1459: arp_standard.debug('update_misc_dist: ' || 'Delete Misc Cash Receipt start () -');
1460: END IF;
1461: END IF;
1462: END IF;
1463:

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

1477: WHERE cash_receipt_id = p_cash_receipt_id
1478: AND current_record_flag = 'Y';
1479: IF (l_posted = -3) then
1480: IF PG_DEBUG in ('Y', 'C') THEN
1481: arp_standard.debug('update_misc_dist: ' || ' Create Acct Entry');
1482: END IF;
1483: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1484:
1485: END IF;

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

1486: --
1487: END IF;
1488:
1489: IF PG_DEBUG in ('Y', 'C') THEN
1490: arp_standard.debug('arp_process_receipts.update_misc_dist()-');
1491: END IF;
1492:
1493: END update_misc_dist;
1494:

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

1591: l_crh_id NUMBER;
1592:
1593: BEGIN
1594:
1595: arp_standard.debug('arp_process_receipts.create_mcd_recs()+');
1596:
1597: SELECT minimum_accountable_unit,precision
1598: INTO l_min_unit, l_precision
1599: FROM fnd_currencies

Line 1678: p_ussgl_trx_code, arp_standard.sysparm.org_id,

1674: arp_global.set_of_books_id,
1675: dist.acctd_amount,
1676: -3,
1677: 'ARRERCT',
1678: p_ussgl_trx_code, arp_standard.sysparm.org_id,
1679: l_crh_id);
1680:
1681:
1682: l_xla_ev_rec.xla_from_doc_id := p_cash_receipt_id;

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

1776: -- round percentages if necessary
1777:
1778: round_mcd_recs(p_cash_receipt_id);
1779:
1780: arp_standard.debug('arp_process_receipts.create_mcd_recs()-');
1781:
1782: END; -- create_mcd_recs()
1783:
1784:

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

1826: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1827:
1828: BEGIN
1829:
1830: arp_standard.debug('arp_process_receipts.update_manual_dist()+');
1831:
1832: SELECT minimum_accountable_unit,precision
1833: INTO l_min_unit, l_precision
1834: FROM fnd_currencies

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

1951: -- round percent columns if necessary
1952:
1953: round_mcd_recs(p_cash_receipt_id);
1954:
1955: arp_standard.debug('arp_process_receipts.update_manual_dist()-');
1956:
1957: END; -- update_manual_dist()
1958: --
1959:

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

2022: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2023:
2024: BEGIN
2025: IF PG_DEBUG in ('Y', 'C') THEN
2026: arp_standard.debug('arp_process_rct_util.rate_adjust()+');
2027: END IF;
2028:
2029: l_radj_rec.cash_receipt_id := p_cash_receipt_id;
2030: l_radj_rec.old_exchange_rate := p_old_exchange_rate;

Line 2069: arp_standard.profile.user_id,

2065: p_new_exchange_date,
2066: p_new_exchange_rate,
2067: p_new_exchange_rate_type,
2068: p_rate_adjust_gl_date,
2069: arp_standard.profile.user_id,
2070: sysdate,
2071: arp_standard.profile.user_id,
2072: sysdate,
2073: arp_standard.profile.last_update_login,

Line 2071: arp_standard.profile.user_id,

2067: p_new_exchange_rate_type,
2068: p_rate_adjust_gl_date,
2069: arp_standard.profile.user_id,
2070: sysdate,
2071: arp_standard.profile.user_id,
2072: sysdate,
2073: arp_standard.profile.last_update_login,
2074: TRUE,
2075: l_crh_id_out);

Line 2073: arp_standard.profile.last_update_login,

2069: arp_standard.profile.user_id,
2070: sysdate,
2071: arp_standard.profile.user_id,
2072: sysdate,
2073: arp_standard.profile.last_update_login,
2074: TRUE,
2075: l_crh_id_out);
2076:
2077: IF PG_DEBUG in ('Y', 'C') THEN

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

2074: TRUE,
2075: l_crh_id_out);
2076:
2077: IF PG_DEBUG in ('Y', 'C') THEN
2078: arp_standard.debug('arp_process_rct_util.rate_adjust()-');
2079: END IF;
2080:
2081: EXCEPTION
2082: WHEN OTHERS THEN

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

2080:
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: IF PG_DEBUG in ('Y', 'C') THEN
2084: arp_standard.debug('Exception in arp_process_rct_util.rate_adjust');
2085: END IF;
2086: RAISE;
2087:
2088: END rate_adjust;

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

2176:
2177: EXCEPTION
2178: WHEN OTHERS THEN
2179: IF PG_DEBUG in ('Y', 'C') THEN
2180: arp_standard.debug('EXCEPTION: arp_process_receipts.get_ccids');
2181: END IF;
2182: RAISE;
2183:
2184: END get_ccids;