DBA Data[Home] [Help]

APPS.ARP_CR_HISTORY_PKG dependencies on ARP_UTIL

Line 985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');

981: p_crh_rec IN ar_cash_receipt_history%ROWTYPE) IS
982: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
983: BEGIN
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);

Line 986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));

982: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
983: BEGIN
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));

Line 987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));

983: BEGIN
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
991: END IF;

Line 988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));

984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
991: END IF;
992: /*4354354 included nvl(factor_discount_amount,0) in the existing amount condition*/

Line 989: arp_util.debug('Status ='||p_crh_rec.status);

985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
991: END IF;
992: /*4354354 included nvl(factor_discount_amount,0) in the existing amount condition*/
993: SELECT *

Line 990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));

986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
991: END IF;
992: /*4354354 included nvl(factor_discount_amount,0) in the existing amount condition*/
993: SELECT *
994: INTO

Line 1026: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()-');

1022: AR_NUMBER_DUMMY
1023: )
1024: AND NVL(crh.current_record_flag,AR_FLAG_DUMMY) = 'Y'
1025: FOR UPDATE NOWAIT;
1026: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()-');
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF PG_DEBUG in ('Y', 'C') THEN
1030: arp_util.debug('EXCEPTION: arp_cr_history_pkg.lock_hist_compare_p()');

Line 1030: arp_util.debug('EXCEPTION: arp_cr_history_pkg.lock_hist_compare_p()');

1026: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()-');
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF PG_DEBUG in ('Y', 'C') THEN
1030: arp_util.debug('EXCEPTION: arp_cr_history_pkg.lock_hist_compare_p()');
1031: END IF;
1032: RAISE;
1033: END lock_hist_compare_p;
1034: /* End bug fix 2742388 */