18: l_org_str varchar2(30);
19: l_trx_number ra_recur_interim.trx_number%type;
20: l_trx_str VARCHAR2(1000);
21: BEGIN
22: arp_util.debug('arp_process_recur.insert_p()+');
23: p_trx_number := '';
24: IF (p_rec_rec.trx_number is null)
25: THEN
26: SELECT MIN(org_id)
108: p_rec_rec.new_customer_trx_id);
109:
110: p_trx_number := l_trx_number;
111:
112: arp_util.debug('arp_process_recur.insert_p()-');
113:
114: EXCEPTION
115: WHEN OTHERS THEN
116: arp_util.debug('EXCEPTION: arp_process_recur.insert_p()');
112: arp_util.debug('arp_process_recur.insert_p()-');
113:
114: EXCEPTION
115: WHEN OTHERS THEN
116: arp_util.debug('EXCEPTION: arp_process_recur.insert_p()');
117: RAISE;
118:
119: END;
120: BEGIN