APPS.ARP_LOCKBOX_PKG dependencies on ARP_LOCKBOX_PKG

Line 1: PACKAGE BODY ARP_LOCKBOX_PKG AS

1: PACKAGE BODY ARP_LOCKBOX_PKG AS
2: /* $Header: ARLBPIMB.pls 115.8 2003/10/10 14:24:51 mraymond ship $ */
3: --
4: /* Bugfix 2284014 */
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 145: arp_util.debug( 'arp_lockbox_pkg.lock_trans_data()+' );

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

Line 541: arp_util.debug( 'arp_lockbox_pkg.lock_trans_data()-' );

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

Line 546: arp_util.debug( 'EXCEPTION: arp_lockbox_pkg.lock_trans_data' );

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:

Line 685: arp_util.debug('arp_lockbox_pkg.update_trans_data()+');

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

Line 827: arp_util.debug('arp_lockbox_pkg.update_trans_data()-');

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

Line 834: 'EXCEPTION: arp_lockbox_pkg.update_trans_data when '||

830: EXCEPTION
831: WHEN OTHERS THEN
832: IF PG_DEBUG in ('Y', 'C') THEN
833: arp_standard.debug('update_trans_data: ' ||
834: 'EXCEPTION: arp_lockbox_pkg.update_trans_data when '||
835: l_break_point);
836: END IF;
837: END update_trans_data;
838: --

Line 847: arp_util.debug('arp_lockbox_pkg.delete_trans_data()+');

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

Line 864: arp_util.debug('arp_lockbox_pkg.delete_trans_data()-');

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

Line 871: 'EXCEPTION: arp_lockbox_pkg.delete_trans_data when '||

867: EXCEPTION
868: WHEN OTHERS THEN
869: IF PG_DEBUG in ('Y', 'C') THEN
870: arp_standard.debug('delete_trans_data: ' ||
871: 'EXCEPTION: arp_lockbox_pkg.delete_trans_data when '||
872: l_break_point);
873: END IF;
874: END delete_trans_data;
875: --

Line 985: END ARP_LOCKBOX_PKG;

981: return NULL;
982: --
983: END get_lb_num;
984: --
985: END ARP_LOCKBOX_PKG;