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_DISTRIBUTIONS_PKG dependencies on ARP_DISTRIBUTIONS_PKG

Line 1: PACKAGE BODY ARP_DISTRIBUTIONS_PKG AS

1: PACKAGE BODY ARP_DISTRIBUTIONS_PKG AS
2: /* $Header: ARJIDSTB.pls 120.13 2010/07/23 03:01:14 nemani ship $*/
3: --
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 14: arp_standard.debug( 'arp_distributions_pkg.insert_p()+' );

10: exp_null_insert exception;
11: pragma exception_init(exp_null_insert, -1400);
12: BEGIN
13: IF PG_DEBUG in ('Y', 'C') THEN
14: arp_standard.debug( 'arp_distributions_pkg.insert_p()+' );
15: END IF;
16: --
17: SELECT ar_distributions_s.nextval
18: INTO l_line_id

Line 166: arp_standard.debug( 'arp_distributions_pkg.insert_p()-' );

162: --
163: p_line_id := l_line_id;
164: --
165: IF PG_DEBUG in ('Y', 'C') THEN
166: arp_standard.debug( 'arp_distributions_pkg.insert_p()-' );
167: END IF;
168: EXCEPTION
169: WHEN exp_null_insert THEN
170: FND_MESSAGE.SET_NAME('AR','AR_INS_NULL_INTO_NOTNULL');

Line 174: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.insert_p' );

170: FND_MESSAGE.SET_NAME('AR','AR_INS_NULL_INTO_NOTNULL');
171: APP_EXCEPTION.RAISE_EXCEPTION;
172: WHEN OTHERS THEN
173: IF PG_DEBUG in ('Y', 'C') THEN
174: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.insert_p' );
175: END IF;
176: RAISE;
177: END insert_p;
178: --

Line 183: arp_standard.debug( 'arp_distributions_pkg.update_p()+' );

179: PROCEDURE update_p(
180: p_dist_rec IN ar_distributions%ROWTYPE ) IS
181: BEGIN
182: IF PG_DEBUG in ('Y', 'C') THEN
183: arp_standard.debug( 'arp_distributions_pkg.update_p()+' );
184: END IF;
185: --
186: UPDATE ar_distributions SET
187: source_id = p_dist_rec.source_id,

Line 233: arp_standard.debug( 'arp_distributions_pkg.update_p()-' );

229: --}
230: WHERE line_id = p_dist_rec.line_id;
231: --
232: IF PG_DEBUG in ('Y', 'C') THEN
233: arp_standard.debug( 'arp_distributions_pkg.update_p()-' );
234: END IF;
235: EXCEPTION
236: WHEN OTHERS THEN
237: IF PG_DEBUG in ('Y', 'C') THEN

Line 238: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.update_p' );

234: END IF;
235: EXCEPTION
236: WHEN OTHERS THEN
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.update_p' );
239: END IF;
240: RAISE;
241: END update_p;
242: --

Line 247: arp_standard.debug( 'arp_distributions_pkg.delete_p()+' );

243: PROCEDURE delete_p(
244: p_line_id IN ar_distributions.line_id%TYPE ) IS
245: BEGIN
246: IF PG_DEBUG in ('Y', 'C') THEN
247: arp_standard.debug( 'arp_distributions_pkg.delete_p()+' );
248: END IF;
249: --
250: DELETE FROM ar_distributions
251: WHERE line_id = p_line_id;

Line 254: arp_standard.debug( 'arp_distributions_pkg.delete_p()-' );

250: DELETE FROM ar_distributions
251: WHERE line_id = p_line_id;
252: --
253: IF PG_DEBUG in ('Y', 'C') THEN
254: arp_standard.debug( 'arp_distributions_pkg.delete_p()-' );
255: END IF;
256: EXCEPTION
257: WHEN OTHERS THEN
258: IF PG_DEBUG in ('Y', 'C') THEN

Line 259: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.delete_p' );

255: END IF;
256: EXCEPTION
257: WHEN OTHERS THEN
258: IF PG_DEBUG in ('Y', 'C') THEN
259: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.delete_p' );
260: END IF;
261: RAISE;
262: END delete_p;
263: --

Line 269: arp_standard.debug( 'arp_distributions_pkg.lock_p()+' );

265: p_line_id IN ar_distributions.line_id%TYPE ) IS
266: l_line_id ar_distributions.line_id%TYPE;
267: BEGIN
268: IF PG_DEBUG in ('Y', 'C') THEN
269: arp_standard.debug( 'arp_distributions_pkg.lock_p()+' );
270: END IF;
271: SELECT line_id
272: INTO l_line_id
273: FROM ar_distributions

Line 278: arp_standard.debug( 'arp_distributions_pkg.lock_p()-' );

274: WHERE line_id = p_line_id
275: FOR UPDATE OF line_id;
276: --
277: IF PG_DEBUG in ('Y', 'C') THEN
278: arp_standard.debug( 'arp_distributions_pkg.lock_p()-' );
279: END IF;
280: EXCEPTION
281: WHEN OTHERS THEN
282: IF PG_DEBUG in ('Y', 'C') THEN

Line 283: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_p' );

279: END IF;
280: EXCEPTION
281: WHEN OTHERS THEN
282: IF PG_DEBUG in ('Y', 'C') THEN
283: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_p' );
284: END IF;
285: RAISE;
286: END lock_p;
287: --

Line 293: arp_standard.debug( 'arp_distributions_pkg.fetch_p()+' );

289: p_line_id IN ar_distributions.line_id%TYPE,
290: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
291: BEGIN
292: IF PG_DEBUG in ('Y', 'C') THEN
293: arp_standard.debug( 'arp_distributions_pkg.fetch_p()+' );
294: END IF;
295: SELECT *
296: INTO p_dist_rec
297: FROM ar_distributions

Line 300: arp_standard.debug( 'arp_distributions_pkg.fetch_p()-' );

296: INTO p_dist_rec
297: FROM ar_distributions
298: WHERE line_id = p_line_id;
299: IF PG_DEBUG in ('Y', 'C') THEN
300: arp_standard.debug( 'arp_distributions_pkg.fetch_p()-' );
301: END IF;
302: --
303: EXCEPTION
304: --

Line 307: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_p' );

303: EXCEPTION
304: --
305: WHEN OTHERS THEN
306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_p' );
308: END IF;
309: RAISE;
310: END fetch_p;
311: --

Line 319: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()+' );

315: p_source_type IN ar_distributions.source_type%TYPE,
316: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
317: BEGIN
318: IF PG_DEBUG in ('Y', 'C') THEN
319: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()+' );
320: END IF;
321: SELECT *
322: INTO p_dist_rec
323: FROM ar_distributions

Line 328: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()-' );

324: WHERE source_id = p_source_id
325: AND source_table = p_source_table
326: AND source_type = p_source_type;
327: IF PG_DEBUG in ('Y', 'C') THEN
328: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()-' );
329: END IF;
330: --
331: EXCEPTION
332: --

Line 335: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_pk' );

331: EXCEPTION
332: --
333: WHEN OTHERS THEN
334: IF PG_DEBUG in ('Y', 'C') THEN
335: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_pk' );
336: END IF;
337: RAISE;
338: END fetch_pk;
339: --

Line 347: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()+' );

343: p_source_type IN ar_distributions.source_type%TYPE,
344: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
345: BEGIN
346: IF PG_DEBUG in ('Y', 'C') THEN
347: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()+' );
348: END IF;
349: SELECT *
350: INTO p_dist_rec
351: FROM ar_distributions

Line 358: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()-' );

354: AND source_type = p_source_type
355: FOR UPDATE OF line_id;
356:
357: IF PG_DEBUG in ('Y', 'C') THEN
358: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()-' );
359: END IF;
360: --
361: EXCEPTION
362: --

Line 365: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_fetch_pk' );

361: EXCEPTION
362: --
363: WHEN OTHERS THEN
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_fetch_pk' );
366: END IF;
367: RAISE;
368: END lock_fetch_pk;
369: --

Line 377: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()+' );

373: p_source_type IN ar_distributions.source_type%TYPE,
374: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
375: BEGIN
376: IF PG_DEBUG in ('Y', 'C') THEN
377: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()+' );
378: END IF;
379: SELECT *
380: INTO p_dist_rec
381: FROM ar_distributions

Line 388: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()-' );

384: AND source_type = p_source_type
385: FOR UPDATE OF line_id NOWAIT;
386:
387: IF PG_DEBUG in ('Y', 'C') THEN
388: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()-' );
389: END IF;
390: --
391: EXCEPTION
392: --

Line 395: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.nowaitlock_fetch_pk' );

391: EXCEPTION
392: --
393: WHEN OTHERS THEN
394: IF PG_DEBUG in ('Y', 'C') THEN
395: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.nowaitlock_fetch_pk' );
396: END IF;
397: RAISE;
398: END nowaitlock_fetch_pk;
399: --

Line 400: END ARP_DISTRIBUTIONS_PKG;

396: END IF;
397: RAISE;
398: END nowaitlock_fetch_pk;
399: --
400: END ARP_DISTRIBUTIONS_PKG;