[Home] [Help]
398: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
399: l_freight_percent number ;
400: l_computed_tax_percent number;
401: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
402: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
403: l_credited_trx_cm_type_id ra_cust_trx_types.credit_memo_type_id%TYPE ;
404: l_credited_trx_open_rec_flag ra_cust_trx_types.accounting_affect_flag%TYPE ;
405: --
406: l_default_bs_name varchar2(50);
709: --
710: BEGIN
711: SELECT *
712: INTO l_credited_trx_rec
713: FROM ra_customer_trx_cr_trx_v
714: WHERE customer_trx_id = p_prev_customer_trx_id ;
715: EXCEPTION
716: WHEN NO_DATA_FOUND THEN
717: --- TDEY 99/09/27 : Bug 913062
720: --- not exist in the system.
721: --- Proposed error message : AR_RAXTRX-1666 Your credit memo
722: --- transaction can only credit an invoice or a debit memo line
723: IF PG_DEBUG in ('Y', 'C') THEN
724: arp_util.debug('EXCEPTION: select from ra_customer_trx_cr_trx_v returns no data');
725: END IF;
726:
727: fnd_message.set_name( 'AR', 'AR_RAXTRX-1666');
728: l_message_name := 'AR_RAXTRX-1666' ;
1630: l_prev_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type ;
1631:
1632:
1633: l_rec_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1634: l_trx_rec ra_customer_trx_cr_trx_v%rowtype;
1635: l_batch_rec ra_batches%rowtype;
1636:
1637: l_cr CONSTANT char(1) := '
1638: ';
1697: l_form_version number := NULL;
1698:
1699: l_auto_trx_numbering_flag varchar2(1);
1700:
1701: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
1702: --
1703: l_line_orig number;
1704: l_tax_orig number;
1705: l_frt_orig number;
1880: --
1881: BEGIN
1882: SELECT *
1883: INTO l_credited_trx_rec
1884: FROM ra_customer_trx_cr_trx_v
1885: WHERE customer_trx_id = p_prev_customer_trx_id ;
1886: EXCEPTION
1887: WHEN NO_DATA_FOUND THEN
1888: --- TDEY 99/09/27 : Bug 913062