[Home] [Help]
397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
398: l_freight_percent number ;
399: l_computed_tax_percent number;
400: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
401: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
402: l_credited_trx_cm_type_id ra_cust_trx_types.credit_memo_type_id%TYPE ;
403: l_credited_trx_open_rec_flag ra_cust_trx_types.accounting_affect_flag%TYPE ;
404: --
405: l_default_bs_name varchar2(50);
699: --
700: BEGIN
701: SELECT *
702: INTO l_credited_trx_rec
703: FROM ra_customer_trx_cr_trx_v
704: WHERE customer_trx_id = p_prev_customer_trx_id ;
705: EXCEPTION
706: WHEN NO_DATA_FOUND THEN
707: --- TDEY 99/09/27 : Bug 913062
710: --- not exist in the system.
711: --- Proposed error message : AR_RAXTRX-1666 Your credit memo
712: --- transaction can only credit an invoice or a debit memo line
713: IF PG_DEBUG in ('Y', 'C') THEN
714: arp_util.debug('EXCEPTION: select from ra_customer_trx_cr_trx_v returns no data');
715: END IF;
716:
717: fnd_message.set_name( 'AR', 'AR_RAXTRX-1666');
718: l_message_name := 'AR_RAXTRX-1666' ;
1627: l_prev_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type ;
1628:
1629:
1630: l_rec_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1631: l_trx_rec ra_customer_trx_cr_trx_v%rowtype;
1632: l_batch_rec ra_batches%rowtype;
1633:
1634: l_cr CONSTANT char(1) := '
1635: ';
1694: p_form_version number := NULL;
1695:
1696: l_auto_trx_numbering_flag varchar2(1);
1697:
1698: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
1699: --
1700: l_line_orig number;
1701: l_tax_orig number;
1702: l_frt_orig number;
1877: --
1878: BEGIN
1879: SELECT *
1880: INTO l_credited_trx_rec
1881: FROM ra_customer_trx_cr_trx_v
1882: WHERE customer_trx_id = p_prev_customer_trx_id ;
1883: EXCEPTION
1884: WHEN NO_DATA_FOUND THEN
1885: --- TDEY 99/09/27 : Bug 913062