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_UTIL

Line 48: | arp_util.debug |

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: |

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 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 420: | arp_util.debug |

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 |

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 514: | arp_util.debug |

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: |

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 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 587: | arp_util.debug |

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: |

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 665: | arp_util.debug |

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: |

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 731: | arp_util.debug |

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 |

Line 844: | arp_util.debug |

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 |

Line 942: | arp_util.debug |

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: |

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 1006: | arp_util.debug |

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 |

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 1060: arp_util.debug('create_trh_for_receipt_act: ' || 'old_status = '||p_old_ps_rec.status);

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'

Line 1061: arp_util.debug('create_trh_for_receipt_act: ' || 'new_status = '||l_new_ps_rec.status);

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'

Line 1118: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.customer_trx_id = '||to_char(l_trh_rec.customer_trx_id));

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);

Line 1119: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_record_flag = '||l_trh_rec.current_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));

Line 1120: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.current_accounted_flag = '||l_trh_rec.current_accounted_flag);

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));

Line 1121: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.postable_flag = '||l_trh_rec.postable_flag);

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);

Line 1122: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.first_posted_record_flag = '||l_trh_rec.first_posted_record_flag);

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));

Line 1123: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.posting_control_id = '||to_char(l_trh_rec.posting_control_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));
1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));

Line 1124: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_posted_date = '||to_char(l_trh_rec.gl_posted_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);

Line 1125: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.created_from = '||l_trh_rec.created_from);

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));

Line 1126: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_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));

Line 1127: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.gl_date = '||to_char(l_trh_rec.gl_date));

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);

Line 1128: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.comments = '||l_trh_rec.comments);

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);

Line 1129: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.maturity_date = '||to_char(l_trh_rec.maturity_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);
1133: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));

Line 1130: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.batch_id = '||to_char(l_trh_rec.batch_id));

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;

Line 1131: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.status = '||l_trh_rec.status);

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:

Line 1132: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.event = '||l_trh_rec.event);

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);

Line 1133: arp_util.debug('create_trh_for_receipt_act: ' || 'l_trh_rec.trx_date = '||to_char(l_trh_rec.trx_date));

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:

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;