44: | |
45: | SCOPE - PUBLIC |
46: | |
47: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
48: | arp_util.debug |
49: | |
50: | ARGUMENTS : IN: p_trh_rec |
51: | OUT: p_transaction_history_id |
52: | IN/ OUT: |
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 |
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
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;
416: | |
417: | SCOPE - PUBLIC |
418: | |
419: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
420: | arp_util.debug |
421: | |
422: | ARGUMENTS : IN: |
423: | OUT: |
424: | IN/ OUT: p_trx_rec |
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 |
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
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;
510: | |
511: | SCOPE - PUBLIC |
512: | |
513: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
514: | arp_util.debug |
515: | |
516: | ARGUMENTS : IN: p_transaction_history_id |
517: | OUT: |
518: | IN/ OUT: |
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 |
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
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;
583: | |
584: | SCOPE - PUBLIC |
585: | |
586: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
587: | arp_util.debug |
588: | |
589: | ARGUMENTS : IN: p_transaction_history_id |
590: | OUT: |
591: | IN/ OUT: |
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 |
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
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;
661: | |
662: | SCOPE - PUBLIC |
663: | |
664: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
665: | arp_util.debug |
666: | |
667: | ARGUMENTS : IN: p_customer_trx_id |
668: | OUT: |
669: | IN/ OUT: |
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 |
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
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;
727: | |
728: | SCOPE - PUBLIC |
729: | |
730: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
731: | arp_util.debug |
732: | |
733: | ARGUMENTS : IN: p_trh_rec - Record containing the transaction history |
734: | recor being created. |
735: | OUT: p_ps_id - PS id of the record created |
840: | |
841: | SCOPE - PUBLIC |
842: | |
843: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
844: | arp_util.debug |
845: | |
846: | ARGUMENTS : IN: p_customer_trx_id - Transaction ID |
847: | |
848: | OUT: p_amount - Sum of adjustments |
938: | |
939: | SCOPE - PUBLIC |
940: | |
941: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
942: | arp_util.debug |
943: | |
944: | ARGUMENTS : IN: p_customer_trx_id |
945: | OUT: |
946: | IN/ OUT: |
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;
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:
1002: | |
1003: | SCOPE - PUBLIC |
1004: | |
1005: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1006: | arp_util.debug |
1007: | |
1008: | ARGUMENTS : IN: l_old_ps_rec Image of the payment schedule before |
1009: | receipt impacted it. |
1010: | p_app_rec The APP record which impacted BR trx |
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 |
1056: +--------------------------------------------------*/
1057: arp_ps_pkg.fetch_p( p_old_ps_rec.payment_schedule_id, l_new_ps_rec );
1058:
1059: IF PG_DEBUG in ('Y', 'C') THEN
1060: arp_util.debug('create_trh_for_receipt_act: ' || 'old_status = '||p_old_ps_rec.status);
1061: arp_util.debug('create_trh_for_receipt_act: ' || 'new_status = '||l_new_ps_rec.status);
1062: END IF;
1063:
1064: IF NVL(p_old_ps_rec.status,'OP') = 'OP' AND NVL(l_new_ps_rec.status,'OP') = 'CL'
1057: arp_ps_pkg.fetch_p( p_old_ps_rec.payment_schedule_id, l_new_ps_rec );
1058:
1059: IF PG_DEBUG in ('Y', 'C') THEN
1060: arp_util.debug('create_trh_for_receipt_act: ' || 'old_status = '||p_old_ps_rec.status);
1061: arp_util.debug('create_trh_for_receipt_act: ' || 'new_status = '||l_new_ps_rec.status);
1062: END IF;
1063:
1064: IF NVL(p_old_ps_rec.status,'OP') = 'OP' AND NVL(l_new_ps_rec.status,'OP') = 'CL'
1065: OR NVL(p_old_ps_rec.status,'OP') = 'CL' AND NVL(l_new_ps_rec.status,'OP') = 'OP'
1114: /*-------------------------------------------+
1115: | Call entity handler to create the record |
1116: +-------------------------------------------*/
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.customer_trx_id = '||to_char(l_trh_rec.customer_trx_id));
1119: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_record_flag = '||l_trh_rec.current_record_flag);
1120: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_accounted_flag = '||l_trh_rec.current_accounted_flag);
1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1115: | Call entity handler to create the record |
1116: +-------------------------------------------*/
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.customer_trx_id = '||to_char(l_trh_rec.customer_trx_id));
1119: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_record_flag = '||l_trh_rec.current_record_flag);
1120: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_accounted_flag = '||l_trh_rec.current_accounted_flag);
1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1116: +-------------------------------------------*/
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.customer_trx_id = '||to_char(l_trh_rec.customer_trx_id));
1119: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_record_flag = '||l_trh_rec.current_record_flag);
1120: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_accounted_flag = '||l_trh_rec.current_accounted_flag);
1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.customer_trx_id = '||to_char(l_trh_rec.customer_trx_id));
1119: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_record_flag = '||l_trh_rec.current_record_flag);
1120: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_accounted_flag = '||l_trh_rec.current_accounted_flag);
1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1118: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.customer_trx_id = '||to_char(l_trh_rec.customer_trx_id));
1119: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_record_flag = '||l_trh_rec.current_record_flag);
1120: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_accounted_flag = '||l_trh_rec.current_accounted_flag);
1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1119: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_record_flag = '||l_trh_rec.current_record_flag);
1120: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_accounted_flag = '||l_trh_rec.current_accounted_flag);
1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1120: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_accounted_flag = '||l_trh_rec.current_accounted_flag);
1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));
1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_id));
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));
1131: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.status = '||l_trh_rec.status);
1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_date));
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));
1131: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.status = '||l_trh_rec.status);
1132: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.event = '||l_trh_rec.event);
1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));
1131: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.status = '||l_trh_rec.status);
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));
1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));
1131: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.status = '||l_trh_rec.status);
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;
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));
1131: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.status = '||l_trh_rec.status);
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:
1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));
1131: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.status = '||l_trh_rec.status);
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);
1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_date));
1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));
1131: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.status = '||l_trh_rec.status);
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:
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
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;