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_TRANSACTION_HISTORY dependencies on ARP_PROC_TRANSACTION_HISTORY

Line 1: PACKAGE BODY ARP_PROC_TRANSACTION_HISTORY AS

1: PACKAGE BODY ARP_PROC_TRANSACTION_HISTORY AS
2: /* $Header: ARTETRHB.pls 120.10.12010000.3 2008/08/03 08:23:09 vavenugo ship $ */
3:
4: /*--------------------------------------------------------+
5: | Dummy constants for use in update and lock operations |

Line 100: arp_util.debug( 'arp_proc_transaction_history.insert_transaction_history()+');

96:
97: BEGIN
98:
99: IF PG_DEBUG in ('Y', 'C') THEN
100: arp_util.debug( 'arp_proc_transaction_history.insert_transaction_history()+');
101: END IF;
102:
103: /*------------------------------------------------+
104: | All the validation and defaulting is done in |

Line 174: ARP_PROC_TRANSACTION_HISTORY.update_transaction_history(l_old_acctd_trh_rec,

170:
171: /*--------------------------------------+
172: | Update the previous accounted record |
173: +--------------------------------------*/
174: ARP_PROC_TRANSACTION_HISTORY.update_transaction_history(l_old_acctd_trh_rec,
175: l_prev_acctd_id);
176:
177: ELSE
178:

Line 203: ARP_PROC_TRANSACTION_HISTORY.update_transaction_history(l_old_trh_rec,

199:
200: /*-----------------------------+
201: | Update the previous record |
202: +-----------------------------*/
203: ARP_PROC_TRANSACTION_HISTORY.update_transaction_history(l_old_trh_rec,
204: l_old_trh_rec.transaction_history_id);
205:
206: END IF;
207:

Line 216: arp_proc_transaction_history.insert_BR_ps(p_trh_rec,l_ps_id);

212:
213: /*--------------------------+
214: | Create payment schedule |
215: +--------------------------*/
216: arp_proc_transaction_history.insert_BR_ps(p_trh_rec,l_ps_id);
217:
218: END IF;
219:
220: /*----------------------+

Line 236: -- ARP_PROC_TRANSACTION_HISTORY.insert_mrc_transaction_hist(p_trh_rec,

232: | table expects for the MRC row to exists |
233: +--------------------------------------------*/
234:
235: --{BUG#4301323
236: -- ARP_PROC_TRANSACTION_HISTORY.insert_mrc_transaction_hist(p_trh_rec,
237: -- p_transaction_history_id);
238: --}
239:
240: --Bug# 2750340

Line 329: ARP_PROC_TRANSACTION_HISTORY.update_transaction_history(l_old_acctd_trh_rec,

325:
326: /*--------------------------------------+
327: | Update the previous accounted record |
328: +--------------------------------------*/
329: ARP_PROC_TRANSACTION_HISTORY.update_transaction_history(l_old_acctd_trh_rec,
330: l_prev_acctd_id);
331:
332:
333: END IF;

Line 397: arp_util.debug( 'arp_proc_transaction_history.insert_transaction_history()-');

393:
394: /* End Bug 7299779 - vavenugo */
395:
396: IF PG_DEBUG in ('Y', 'C') THEN
397: arp_util.debug( 'arp_proc_transaction_history.insert_transaction_history()-');
398: END IF;
399:
400: EXCEPTION
401: WHEN OTHERS THEN

Line 403: arp_util.debug( 'EXCEPTION: arp_proc_transaction_history.insert_transaction_history()');

399:
400: EXCEPTION
401: WHEN OTHERS THEN
402: IF PG_DEBUG in ('Y', 'C') THEN
403: arp_util.debug( 'EXCEPTION: arp_proc_transaction_history.insert_transaction_history()');
404: END IF;
405: RAISE;
406:
407: END insert_transaction_history;

Line 448: arp_util.debug( 'arp_proc_transaction_history.update_transaction_history()+');

444: l_customer_trx_id ar_transaction_history.customer_trx_id%TYPE;
445: BEGIN
446:
447: IF PG_DEBUG in ('Y', 'C') THEN
448: arp_util.debug( 'arp_proc_transaction_history.update_transaction_history()+');
449: END IF;
450:
451: /*------------------------------------------------+
452: | All the validation and defaulting is done in |

Line 491: arp_util.debug( 'arp_proc_transaction_history.update_transaction_history()-');

487: | None of MRC columns can be updated |
488: +-------------------------------------*/
489:
490: IF PG_DEBUG in ('Y', 'C') THEN
491: arp_util.debug( 'arp_proc_transaction_history.update_transaction_history()-');
492: END IF;
493:
494: EXCEPTION
495: WHEN OTHERS THEN

Line 497: arp_util.debug( 'EXCEPTION: arp_proc_transaction_history.update_transaction_history()');

493:
494: EXCEPTION
495: WHEN OTHERS THEN
496: IF PG_DEBUG in ('Y', 'C') THEN
497: arp_util.debug( 'EXCEPTION: arp_proc_transaction_history.update_transaction_history()');
498: END IF;
499: RAISE;
500:
501: END update_transaction_history;

Line 533: arp_util.debug( 'arp_proc_transaction_history.delete_transaction_history()+');

529:
530: BEGIN
531:
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_util.debug( 'arp_proc_transaction_history.delete_transaction_history()+');
534: END IF;
535:
536: /*--------------------------------+
537: | lock history record |

Line 549: arp_proc_transaction_history.delete_transaction_hist_dist(p_transaction_history_id);

545:
546: /*---------------------------------------------------+
547: | Delete all accounting related to the history row |
548: +---------------------------------------------------*/
549: arp_proc_transaction_history.delete_transaction_hist_dist(p_transaction_history_id);
550:
551: /*------------------------------------------+
552: | Call MRC logic to delete MRC rows |
553: +------------------------------------------*/

Line 555: -- ARP_PROC_TRANSACTION_HISTORY.delete_mrc_transaction_hist(p_transaction_history_id);

551: /*------------------------------------------+
552: | Call MRC logic to delete MRC rows |
553: +------------------------------------------*/
554: --{BUG#4301323
555: -- ARP_PROC_TRANSACTION_HISTORY.delete_mrc_transaction_hist(p_transaction_history_id);
556: --}
557:
558: --Bug# 2750340
559: arp_xla_events.delete_event( p_document_id => p_transaction_history_id,

Line 564: arp_util.debug( 'arp_proc_transaction_history.delete_transaction_history()-');

560: p_doc_table => 'TRH');
561:
562:
563: IF PG_DEBUG in ('Y', 'C') THEN
564: arp_util.debug( 'arp_proc_transaction_history.delete_transaction_history()-');
565: END IF;
566:
567: EXCEPTION
568: WHEN OTHERS THEN

Line 570: arp_util.debug( 'EXCEPTION: arp_proc_transaction_history.delete_transaction_history()');

566:
567: EXCEPTION
568: WHEN OTHERS THEN
569: IF PG_DEBUG in ('Y', 'C') THEN
570: arp_util.debug( 'EXCEPTION: arp_proc_transaction_history.delete_transaction_history()');
571: END IF;
572: RAISE;
573:
574: END delete_transaction_history;

Line 624: arp_util.debug( 'arp_proc_transaction_history.delete_transaction_hist_dist()+');

620:
621: BEGIN
622:
623: IF PG_DEBUG in ('Y', 'C') THEN
624: arp_util.debug( 'arp_proc_transaction_history.delete_transaction_hist_dist()+');
625: END IF;
626:
627: /*----------------------------------------+
628: | Loop through all distribution records |

Line 642: arp_util.debug( 'arp_proc_transaction_history.delete_transaction_hist_dist()-');

638:
639: END LOOP;
640:
641: IF PG_DEBUG in ('Y', 'C') THEN
642: arp_util.debug( 'arp_proc_transaction_history.delete_transaction_hist_dist()-');
643: END IF;
644:
645: EXCEPTION
646: WHEN OTHERS THEN

Line 648: arp_util.debug( 'EXCEPTION: arp_proc_transaction_history.delete_transaction_hist_dist()');

644:
645: EXCEPTION
646: WHEN OTHERS THEN
647: IF PG_DEBUG in ('Y', 'C') THEN
648: arp_util.debug( 'EXCEPTION: arp_proc_transaction_history.delete_transaction_hist_dist()');
649: END IF;
650: RAISE;
651:
652: END delete_transaction_hist_dist;

Line 696: arp_util.debug('arp_proc_transaction_history.find_prev_accounted_id()+');

692:
693: BEGIN
694:
695: IF PG_DEBUG in ('Y', 'C') THEN
696: arp_util.debug('arp_proc_transaction_history.find_prev_accounted_id()+');
697: END IF;
698:
699: /*---------------------------------------------------+
700: | Fetch the previous accounted transaction history |

Line 709: arp_util.debug('arp_proc_transaction_history.find_prev_accounted_id()-');

705:
706: RETURN prev_acctd_trh_rec.transaction_history_id;
707:
708: IF PG_DEBUG in ('Y', 'C') THEN
709: arp_util.debug('arp_proc_transaction_history.find_prev_accounted_id()-');
710: END IF;
711:
712: EXCEPTION
713: WHEN OTHERS THEN

Line 715: arp_util.debug('EXCEPTION: arp_proc_transaction_history.find_prev_accounted_id()');

711:
712: EXCEPTION
713: WHEN OTHERS THEN
714: IF PG_DEBUG in ('Y', 'C') THEN
715: arp_util.debug('EXCEPTION: arp_proc_transaction_history.find_prev_accounted_id()');
716: END IF;
717: RAISE;
718:
719: END find_prev_accounted_id;

Line 758: arp_standard.debug('arp_proc_transaction_history.insert_BR_ps()+');

754:
755: BEGIN
756:
757: IF PG_DEBUG in ('Y', 'C') THEN
758: arp_standard.debug('arp_proc_transaction_history.insert_BR_ps()+');
759: END IF;
760:
761: /*------------------------------------+
762: | Fetch the transaction information |

Line 782: arp_proc_transaction_history.calculate_BR_amounts(

778: /*-------------------------------------------------------------------------+
779: | Calculate the payment schedule amount using shadow adjustment created |
780: | against the assignments. |
781: +-------------------------------------------------------------------------*/
782: arp_proc_transaction_history.calculate_BR_amounts(
783: l_trx_rec.customer_trx_id,
784: l_ps_rec.amount_due_original,
785: l_ps_rec.acctd_amount_due_remaining,
786: l_ps_rec.amount_line_items_original,

Line 821: arp_standard.debug('arp_proc_transaction_history.insert_BR_ps()-');

817:
818: p_ps_id := l_ps_id;
819:
820: IF PG_DEBUG in ('Y', 'C') THEN
821: arp_standard.debug('arp_proc_transaction_history.insert_BR_ps()-');
822: END IF;
823:
824: EXCEPTION
825: WHEN OTHERS THEN

Line 827: arp_standard.debug('EXCEPTION: arp_proc_transaction_history.insert_BR_ps()');

823:
824: EXCEPTION
825: WHEN OTHERS THEN
826: IF PG_DEBUG in ('Y', 'C') THEN
827: arp_standard.debug('EXCEPTION: arp_proc_transaction_history.insert_BR_ps()');
828: END IF;
829: RAISE;
830:
831: END insert_BR_ps;

Line 895: arp_standard.debug('arp_proc_transaction_history.calculate_BR_amounts()+');

891:
892: BEGIN
893:
894: IF PG_DEBUG in ('Y', 'C') THEN
895: arp_standard.debug('arp_proc_transaction_history.calculate_BR_amounts()+');
896: END IF;
897:
898: /*---------------------------------------+
899: | Fetch the totals on the adjustments |

Line 916: arp_standard.debug('arp_proc_transaction_history.calculate_BR_amounts()-');

912: p_freight_amount := -nvl(br_amounts_rec.total_freight,0);
913: p_charges_amount := -nvl(br_amounts_rec.total_charges,0);
914:
915: IF PG_DEBUG in ('Y', 'C') THEN
916: arp_standard.debug('arp_proc_transaction_history.calculate_BR_amounts()-');
917: END IF;
918:
919: EXCEPTION
920: WHEN OTHERS THEN

Line 922: arp_standard.debug('EXCEPTION: arp_proc_transaction_history.calculate_BR_amounts()');

918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF PG_DEBUG in ('Y', 'C') THEN
922: arp_standard.debug('EXCEPTION: arp_proc_transaction_history.calculate_BR_amounts()');
923: END IF;
924: RAISE;
925:
926: END calculate_BR_amounts;

Line 969: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.previous_history_exists()+');

965: previous_history_exists_rec previous_history_exists_cur%ROWTYPE;
966:
967: BEGIN
968: IF PG_DEBUG in ('Y', 'C') THEN
969: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.previous_history_exists()+');
970: END IF;
971:
972: OPEN previous_history_exists_cur;
973: FETCH previous_history_exists_cur INTO previous_history_exists_rec;

Line 983: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.previous_history_exists()-');

979:
980: CLOSE previous_history_exists_cur;
981:
982: IF PG_DEBUG in ('Y', 'C') THEN
983: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.previous_history_exists()-');
984: END IF;
985:
986: RETURN TRUE;
987:

Line 1033: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.create_trh_for_receipt_act()+');

1029: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1030:
1031: BEGIN
1032: IF PG_DEBUG in ('Y', 'C') THEN
1033: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.create_trh_for_receipt_act()+');
1034: END IF;
1035:
1036: /*--------------------------------------------+
1037: | Initialize the transaction history record |

Line 1136: ARP_PROC_TRANSACTION_HISTORY.insert_transaction_history(l_trh_rec, l_transaction_history_id);

1132: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.event = '||l_trh_rec.event);
1133: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1134: END IF;
1135:
1136: ARP_PROC_TRANSACTION_HISTORY.insert_transaction_history(l_trh_rec, l_transaction_history_id);
1137:
1138: END IF;
1139: IF PG_DEBUG in ('Y', 'C') THEN
1140: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.create_trh_for_receipt_act()+');

Line 1140: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.create_trh_for_receipt_act()+');

1136: ARP_PROC_TRANSACTION_HISTORY.insert_transaction_history(l_trh_rec, l_transaction_history_id);
1137:
1138: END IF;
1139: IF PG_DEBUG in ('Y', 'C') THEN
1140: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.create_trh_for_receipt_act()+');
1141: END IF;
1142:
1143: EXCEPTION
1144: WHEN OTHERS THEN

Line 1146: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.create_trh_for_receipt_act');

1142:
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: IF PG_DEBUG in ('Y', 'C') THEN
1146: arp_util.debug('ARP_PROC_TRANSACTION_HISTORY.create_trh_for_receipt_act');
1147: END IF;
1148: RAISE;
1149:
1150: END create_trh_for_receipt_act;

Line 1152: END ARP_PROC_TRANSACTION_HISTORY;

1148: RAISE;
1149:
1150: END create_trh_for_receipt_act;
1151:
1152: END ARP_PROC_TRANSACTION_HISTORY;