141:
142: Recinfo C%ROWTYPE;
143: BEGIN
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_util.debug( 'arp_lockbox_pkg.lock_trans_data()+' );
146: END IF;
147: OPEN C;
148: FETCH C INTO Recinfo;
149: if (C%NOTFOUND) then
537: APP_EXCEPTION.Raise_Exception;
538: end if;
539:
540: IF PG_DEBUG in ('Y', 'C') THEN
541: arp_util.debug( 'arp_lockbox_pkg.lock_trans_data()-' );
542: END IF;
543: EXCEPTION
544: WHEN OTHERS THEN
545: IF PG_DEBUG in ('Y', 'C') THEN
542: END IF;
543: EXCEPTION
544: WHEN OTHERS THEN
545: IF PG_DEBUG in ('Y', 'C') THEN
546: arp_util.debug( 'EXCEPTION: arp_lockbox_pkg.lock_trans_data' );
547: END IF;
548: RAISE;
549: END lock_trans_data;
550:
681: l_dummy NUMBER;
682: l_break_point VARCHAR2(30);
683: BEGIN
684: IF PG_DEBUG in ('Y', 'C') THEN
685: arp_util.debug('arp_lockbox_pkg.update_trans_data()+');
686: END IF;
687: --
688: /* Bugfix 2284014. Commented the foll. code that earlier
689: locked the record
823: ussgl_transaction_code8 = p_ussgl_transaction_code8
824: WHERE transmission_record_id = p_transmission_record_id;
825: --
826: IF PG_DEBUG in ('Y', 'C') THEN
827: arp_util.debug('arp_lockbox_pkg.update_trans_data()-');
828: END IF;
829: --
830: EXCEPTION
831: WHEN OTHERS THEN
843: l_dummy NUMBER;
844: l_break_point VARCHAR2(30);
845: BEGIN
846: IF PG_DEBUG in ('Y', 'C') THEN
847: arp_util.debug('arp_lockbox_pkg.delete_trans_data()+');
848: END IF;
849: --
850: /* Bugfix 2284014. Commented the foll. code that earlier
851: locked the record
860: DELETE ar_payments_interface
861: WHERE transmission_record_id = p_transmission_record_id;
862: --
863: IF PG_DEBUG in ('Y', 'C') THEN
864: arp_util.debug('arp_lockbox_pkg.delete_trans_data()-');
865: END IF;
866: --
867: EXCEPTION
868: WHEN OTHERS THEN