APPS.ARP_RW_ICR_REMIT_PKG dependencies on ARP_RW_ICR_REMIT_PKG

Line 1: PACKAGE BODY ARP_RW_ICR_REMIT_PKG AS

1: PACKAGE BODY ARP_RW_ICR_REMIT_PKG AS
2: /* $Header: ARICRRLB.pls 120.0.12010000.3 2009/04/29 14:55:07 mpsingh noship $ */
3: --
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 63: arp_util.debug( 'arp_rw_icr_remit_pkg.update_row()+' );

59: --
60: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
61: BEGIN
62: IF PG_DEBUG in ('Y', 'C') THEN
63: arp_util.debug( 'arp_rw_icr_remit_pkg.update_row()+' );
64: END IF;
65:
66: UPDATE AR_CASH_REMIT_REFS_ALL
67: SET

Line 105: arp_util.debug( 'arp_rw_icr_remit_pkg.update_row(-)' );

101: WHERE REMIT_REFERENCE_ID = P_REMIT_REFERENCE_ID;
102:
103:
104: IF PG_DEBUG in ('Y', 'C') THEN
105: arp_util.debug( 'arp_rw_icr_remit_pkg.update_row(-)' );
106: END IF;
107: --
108: EXCEPTION
109: WHEN OTHERS THEN

Line 170: arp_util.debug( 'arp_rw_icr_remit_pkg.insert_row()+' );

166: l_line_num NUMBER;
167:
168: BEGIN
169: IF PG_DEBUG in ('Y', 'C') THEN
170: arp_util.debug( 'arp_rw_icr_remit_pkg.insert_row()+' );
171: END IF;
172:
173: SELECT AR_CASH_REMIT_REFS_S.nextval
174: INTO l_rr_id

Line 264: arp_util.debug( 'arp_rw_icr_remit_pkg.insert_row(-)' );

260: );
261:
262:
263: IF PG_DEBUG in ('Y', 'C') THEN
264: arp_util.debug( 'arp_rw_icr_remit_pkg.insert_row(-)' );
265: END IF;
266: --
267: EXCEPTION
268: WHEN OTHERS THEN

Line 270: arp_util.debug( 'EXCEPTION: arp_rw_icr_remit_pkg.insert_row' );

266: --
267: EXCEPTION
268: WHEN OTHERS THEN
269: IF PG_DEBUG in ('Y', 'C') THEN
270: arp_util.debug( 'EXCEPTION: arp_rw_icr_remit_pkg.insert_row' );
271: END IF;
272: RAISE;
273: END insert_row;
274: --

Line 297: arp_util.debug( 'arp_rw_icr_remit_pkg.delete_row()+' );

293: p_rr_id IN ar_cash_remit_refs_all.remit_reference_id%TYPE
294: ) IS
295: BEGIN
296: IF PG_DEBUG in ('Y', 'C') THEN
297: arp_util.debug( 'arp_rw_icr_remit_pkg.delete_row()+' );
298: END IF;
299: --
300: IF ( p_rr_id is NULL ) THEN
301: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 309: arp_util.debug( 'arp_rw_icr_remit_pkg.delete_row(-)' );

305: DELETE FROM ar_cash_remit_refs_all
306: WHERE remit_reference_id = p_rr_id;
307:
308: IF PG_DEBUG in ('Y', 'C') THEN
309: arp_util.debug( 'arp_rw_icr_remit_pkg.delete_row(-)' );
310: END IF;
311: --
312: EXCEPTION
313: WHEN OTHERS THEN

Line 316: 'EXCEPTION: arp_rw_icr_remit_pkg.delete_row' );

312: EXCEPTION
313: WHEN OTHERS THEN
314: IF PG_DEBUG in ('Y', 'C') THEN
315: arp_util.debug('delete_row: ' ||
316: 'EXCEPTION: arp_rw_icr_remit_pkg.delete_row' );
317: END IF;
318: RAISE;
319: END delete_row;
320: --

Line 422: END ARP_RW_ICR_REMIT_PKG;

418: APP_EXCEPTION.Raise_Exception;
419: end if;
420: END lock_row;
421: --
422: END ARP_RW_ICR_REMIT_PKG;