20: l_trx_no ra_recur_interim.trx_number%type;
21:
22: Begin
23:
24: arp_util.debug('arp_recur_inv.insert_recur_cover()+');
25: l_rec_rec.customer_trx_id := p_customer_trx_id;
26: l_rec_rec.trx_number := p_trx_number;
27: l_rec_rec.trx_date := p_trx_date;
28: l_rec_rec.term_due_date := p_term_due_date;
41: l_trx_no );
42:
43: p_trx_no := l_trx_no;
44:
45: arp_util.debug('arp_process_recur_cover.trx_no is'||l_trx_no);
46: arp_util.debug('arp_process_recur_cover.document_sequence_value is'||l_trx_no);
47: arp_util.debug('arp_recur_inv.insert_recur_cover()-');
48:
49: EXCEPTION
42:
43: p_trx_no := l_trx_no;
44:
45: arp_util.debug('arp_process_recur_cover.trx_no is'||l_trx_no);
46: arp_util.debug('arp_process_recur_cover.document_sequence_value is'||l_trx_no);
47: arp_util.debug('arp_recur_inv.insert_recur_cover()-');
48:
49: EXCEPTION
50: WHEN OTHERS THEN
43: p_trx_no := l_trx_no;
44:
45: arp_util.debug('arp_process_recur_cover.trx_no is'||l_trx_no);
46: arp_util.debug('arp_process_recur_cover.document_sequence_value is'||l_trx_no);
47: arp_util.debug('arp_recur_inv.insert_recur_cover()-');
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: arp_util.debug('EXCEPTION : arp_recur_inv.insert_recur_cover');
47: arp_util.debug('arp_recur_inv.insert_recur_cover()-');
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: arp_util.debug('EXCEPTION : arp_recur_inv.insert_recur_cover');
52: arp_util.debug('p_form_name : '||p_form_name);
53: arp_util.debug('p_form_version : '||p_form_version);
54: arp_util.debug('p_trx_date : '||p_trx_date);
55: arp_util.debug('p_billing_date : '||p_billing_date);
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: arp_util.debug('EXCEPTION : arp_recur_inv.insert_recur_cover');
52: arp_util.debug('p_form_name : '||p_form_name);
53: arp_util.debug('p_form_version : '||p_form_version);
54: arp_util.debug('p_trx_date : '||p_trx_date);
55: arp_util.debug('p_billing_date : '||p_billing_date);
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
49: EXCEPTION
50: WHEN OTHERS THEN
51: arp_util.debug('EXCEPTION : arp_recur_inv.insert_recur_cover');
52: arp_util.debug('p_form_name : '||p_form_name);
53: arp_util.debug('p_form_version : '||p_form_version);
54: arp_util.debug('p_trx_date : '||p_trx_date);
55: arp_util.debug('p_billing_date : '||p_billing_date);
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
57: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
50: WHEN OTHERS THEN
51: arp_util.debug('EXCEPTION : arp_recur_inv.insert_recur_cover');
52: arp_util.debug('p_form_name : '||p_form_name);
53: arp_util.debug('p_form_version : '||p_form_version);
54: arp_util.debug('p_trx_date : '||p_trx_date);
55: arp_util.debug('p_billing_date : '||p_billing_date);
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
57: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
58: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
51: arp_util.debug('EXCEPTION : arp_recur_inv.insert_recur_cover');
52: arp_util.debug('p_form_name : '||p_form_name);
53: arp_util.debug('p_form_version : '||p_form_version);
54: arp_util.debug('p_trx_date : '||p_trx_date);
55: arp_util.debug('p_billing_date : '||p_billing_date);
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
57: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
58: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
59: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
52: arp_util.debug('p_form_name : '||p_form_name);
53: arp_util.debug('p_form_version : '||p_form_version);
54: arp_util.debug('p_trx_date : '||p_trx_date);
55: arp_util.debug('p_billing_date : '||p_billing_date);
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
57: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
58: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
59: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
60: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
53: arp_util.debug('p_form_version : '||p_form_version);
54: arp_util.debug('p_trx_date : '||p_trx_date);
55: arp_util.debug('p_billing_date : '||p_billing_date);
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
57: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
58: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
59: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
60: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
61:
54: arp_util.debug('p_trx_date : '||p_trx_date);
55: arp_util.debug('p_billing_date : '||p_billing_date);
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
57: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
58: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
59: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
60: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
61:
62: RAISE;
55: arp_util.debug('p_billing_date : '||p_billing_date);
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
57: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
58: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
59: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
60: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
61:
62: RAISE;
63:
56: arp_util.debug('p_term_due_date : '||p_term_due_date);
57: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
58: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
59: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
60: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
61:
62: RAISE;
63:
64: End;