eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_MISC_CASH_DIST_PKG dependencies on ARP_MISC_CASH_DIST_PKG

Line 1: PACKAGE BODY ARP_MISC_CASH_DIST_PKG AS

1: PACKAGE BODY ARP_MISC_CASH_DIST_PKG AS
2: /*$Header: ARRIMCDB.pls 120.7 2006/06/09 16:25:49 hyu ship $*/
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 21: arp_standard.debug( 'arp_misc_cash_dist_pkg.insert_p()+' );

17:
18:
19: BEGIN
20: IF PG_DEBUG in ('Y', 'C') THEN
21: arp_standard.debug( 'arp_misc_cash_dist_pkg.insert_p()+' );
22: END IF;
23:
24: SELECT ar_misc_cash_distributions_s.nextval
25: INTO l_mcd_id

Line 150: arp_standard.debug( 'arp_misc_cash_dist_pkg.insert_p()-' );

146: END IF;
147:
148:
149: IF PG_DEBUG in ('Y', 'C') THEN
150: arp_standard.debug( 'arp_misc_cash_dist_pkg.insert_p()-' );
151: END IF;
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF PG_DEBUG in ('Y', 'C') THEN

Line 155: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.insert_p' );

151: END IF;
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF PG_DEBUG in ('Y', 'C') THEN
155: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.insert_p' );
156: END IF;
157: RAISE;
158: END insert_p;
159: --

Line 170: arp_standard.debug( 'arp_misc_cash_dist_pkg.update_p()+' );

166: AND current_record_flag = 'Y';
167: l_crh_id NUMBER;
168: BEGIN
169: IF PG_DEBUG in ('Y', 'C') THEN
170: arp_standard.debug( 'arp_misc_cash_dist_pkg.update_p()+' );
171: END IF;
172:
173: --5201086
174: IF p_mcd_rec.cash_receipt_history_id IS NULL AND

Line 238: arp_standard.debug( 'arp_misc_cash_dist_pkg.update_p()-' );

234: ,cash_receipt_history_id = l_crh_id
235: WHERE misc_cash_distribution_id = p_mcd_rec.misc_cash_distribution_id;
236:
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug( 'arp_misc_cash_dist_pkg.update_p()-' );
239: END IF;
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF PG_DEBUG in ('Y', 'C') THEN

Line 243: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.update_p' );

239: END IF;
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF PG_DEBUG in ('Y', 'C') THEN
243: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.update_p' );
244: END IF;
245: RAISE;
246: END update_p;
247: --

Line 252: arp_standard.debug( 'arp_misc_cash_dist_pkg.delete_p()+' );

248: PROCEDURE delete_p(
249: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS
250: BEGIN
251: IF PG_DEBUG in ('Y', 'C') THEN
252: arp_standard.debug( 'arp_misc_cash_dist_pkg.delete_p()+' );
253: END IF;
254: --
255: DELETE FROM ar_misc_cash_distributions
256: WHERE misc_cash_distribution_id = p_mcd_id;

Line 259: arp_standard.debug( 'arp_misc_cash_dist_pkg.delete_p()-' );

255: DELETE FROM ar_misc_cash_distributions
256: WHERE misc_cash_distribution_id = p_mcd_id;
257:
258: IF PG_DEBUG in ('Y', 'C') THEN
259: arp_standard.debug( 'arp_misc_cash_dist_pkg.delete_p()-' );
260: END IF;
261: EXCEPTION
262: WHEN OTHERS THEN
263: IF PG_DEBUG in ('Y', 'C') THEN

Line 264: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.delete_p' );

260: END IF;
261: EXCEPTION
262: WHEN OTHERS THEN
263: IF PG_DEBUG in ('Y', 'C') THEN
264: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.delete_p' );
265: END IF;
266: RAISE;
267: END delete_p;
268:

Line 274: arp_standard.debug( 'arp_misc_cash_dist_pkg.lock_p()+' );

270: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS
271: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
272: BEGIN
273: IF PG_DEBUG in ('Y', 'C') THEN
274: arp_standard.debug( 'arp_misc_cash_dist_pkg.lock_p()+' );
275: END IF;
276: --
277: SELECT misc_cash_distribution_id
278: INTO l_mcd_id

Line 284: arp_standard.debug( 'arp_misc_cash_dist_pkg.lock_p()-' );

280: WHERE misc_cash_distribution_id = p_mcd_id
281: FOR UPDATE OF amount NOWAIT ;
282: --
283: IF PG_DEBUG in ('Y', 'C') THEN
284: arp_standard.debug( 'arp_misc_cash_dist_pkg.lock_p()-' );
285: END IF;
286: EXCEPTION
287: WHEN OTHERS THEN
288: IF PG_DEBUG in ('Y', 'C') THEN

Line 289: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.lock_p' );

285: END IF;
286: EXCEPTION
287: WHEN OTHERS THEN
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.lock_p' );
290: END IF;
291: RAISE;
292: END lock_p;
293:

Line 299: arp_standard.debug( 'arp_misc_cash_dist_pkg.fetch_p()+' );

295: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
296: p_mcd_rec OUT NOCOPY ar_misc_cash_distributions%ROWTYPE ) IS
297: BEGIN
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_standard.debug( 'arp_misc_cash_dist_pkg.fetch_p()+' );
300: END IF;
301: --
302: SELECT *
303: INTO p_mcd_rec

Line 308: arp_standard.debug( 'arp_misc_cash_dist_pkg.fetch_p()-' );

304: FROM ar_misc_cash_distributions
305: WHERE misc_cash_distribution_id = p_mcd_id;
306: --
307: IF PG_DEBUG in ('Y', 'C') THEN
308: arp_standard.debug( 'arp_misc_cash_dist_pkg.fetch_p()-' );
309: END IF;
310: EXCEPTION
311: --
312: WHEN OTHERS THEN

Line 314: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.fetch_p' );

310: EXCEPTION
311: --
312: WHEN OTHERS THEN
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.fetch_p' );
315: END IF;
316: RAISE;
317: END fetch_p;
318:

Line 324: arp_standard.debug( 'arp_misc_cash_dist_pkg.nowaitlock_fetch_p()+' );

320: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
321: p_mcd_rec OUT NOCOPY ar_misc_cash_distributions%ROWTYPE ) IS
322: BEGIN
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_standard.debug( 'arp_misc_cash_dist_pkg.nowaitlock_fetch_p()+' );
325: END IF;
326: --
327: SELECT *
328: INTO p_mcd_rec

Line 334: arp_standard.debug( 'arp_misc_cash_dist_pkg.nowaitlock_fetch_p()-' );

330: WHERE misc_cash_distribution_id = p_mcd_id
331: FOR UPDATE OF amount NOWAIT;
332: --
333: IF PG_DEBUG in ('Y', 'C') THEN
334: arp_standard.debug( 'arp_misc_cash_dist_pkg.nowaitlock_fetch_p()-' );
335: END IF;
336: EXCEPTION
337: --
338: WHEN OTHERS THEN

Line 340: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.nowaitlock_fetch_p' );

336: EXCEPTION
337: --
338: WHEN OTHERS THEN
339: IF PG_DEBUG in ('Y', 'C') THEN
340: arp_standard.debug( 'EXCEPTION: arp_misc_cash_dist_pkg.nowaitlock_fetch_p' );
341: END IF;
342: RAISE;
343: END nowaitlock_fetch_p;
344: --

Line 345: END ARP_MISC_CASH_DIST_PKG;

341: END IF;
342: RAISE;
343: END nowaitlock_fetch_p;
344: --
345: END ARP_MISC_CASH_DIST_PKG;