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.12 2005/06/02 22:52:16 hyu 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 161: arp_standard.debug( 'arp_distributions_pkg.insert_p()-' );

157: --
158: p_line_id := l_line_id;
159: --
160: IF PG_DEBUG in ('Y', 'C') THEN
161: arp_standard.debug( 'arp_distributions_pkg.insert_p()-' );
162: END IF;
163: EXCEPTION
164: WHEN exp_null_insert THEN
165: FND_MESSAGE.SET_NAME('AR','AR_INS_NULL_INTO_NOTNULL');

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

165: FND_MESSAGE.SET_NAME('AR','AR_INS_NULL_INTO_NOTNULL');
166: APP_EXCEPTION.RAISE_EXCEPTION;
167: WHEN OTHERS THEN
168: IF PG_DEBUG in ('Y', 'C') THEN
169: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.insert_p' );
170: END IF;
171: RAISE;
172: END insert_p;
173: --

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

174: PROCEDURE update_p(
175: p_dist_rec IN ar_distributions%ROWTYPE ) IS
176: BEGIN
177: IF PG_DEBUG in ('Y', 'C') THEN
178: arp_standard.debug( 'arp_distributions_pkg.update_p()+' );
179: END IF;
180: --
181: UPDATE ar_distributions SET
182: source_id = p_dist_rec.source_id,

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

224: --}
225: WHERE line_id = p_dist_rec.line_id;
226: --
227: IF PG_DEBUG in ('Y', 'C') THEN
228: arp_standard.debug( 'arp_distributions_pkg.update_p()-' );
229: END IF;
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF PG_DEBUG in ('Y', 'C') THEN

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

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

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

238: PROCEDURE delete_p(
239: p_line_id IN ar_distributions.line_id%TYPE ) IS
240: BEGIN
241: IF PG_DEBUG in ('Y', 'C') THEN
242: arp_standard.debug( 'arp_distributions_pkg.delete_p()+' );
243: END IF;
244: --
245: DELETE FROM ar_distributions
246: WHERE line_id = p_line_id;

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

245: DELETE FROM ar_distributions
246: WHERE line_id = p_line_id;
247: --
248: IF PG_DEBUG in ('Y', 'C') THEN
249: arp_standard.debug( 'arp_distributions_pkg.delete_p()-' );
250: END IF;
251: EXCEPTION
252: WHEN OTHERS THEN
253: IF PG_DEBUG in ('Y', 'C') THEN

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

250: END IF;
251: EXCEPTION
252: WHEN OTHERS THEN
253: IF PG_DEBUG in ('Y', 'C') THEN
254: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.delete_p' );
255: END IF;
256: RAISE;
257: END delete_p;
258: --

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

260: p_line_id IN ar_distributions.line_id%TYPE ) IS
261: l_line_id ar_distributions.line_id%TYPE;
262: BEGIN
263: IF PG_DEBUG in ('Y', 'C') THEN
264: arp_standard.debug( 'arp_distributions_pkg.lock_p()+' );
265: END IF;
266: SELECT line_id
267: INTO l_line_id
268: FROM ar_distributions

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

269: WHERE line_id = p_line_id
270: FOR UPDATE OF line_id;
271: --
272: IF PG_DEBUG in ('Y', 'C') THEN
273: arp_standard.debug( 'arp_distributions_pkg.lock_p()-' );
274: END IF;
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF PG_DEBUG in ('Y', 'C') THEN

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

274: END IF;
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF PG_DEBUG in ('Y', 'C') THEN
278: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_p' );
279: END IF;
280: RAISE;
281: END lock_p;
282: --

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

284: p_line_id IN ar_distributions.line_id%TYPE,
285: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
286: BEGIN
287: IF PG_DEBUG in ('Y', 'C') THEN
288: arp_standard.debug( 'arp_distributions_pkg.fetch_p()+' );
289: END IF;
290: SELECT *
291: INTO p_dist_rec
292: FROM ar_distributions

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

291: INTO p_dist_rec
292: FROM ar_distributions
293: WHERE line_id = p_line_id;
294: IF PG_DEBUG in ('Y', 'C') THEN
295: arp_standard.debug( 'arp_distributions_pkg.fetch_p()-' );
296: END IF;
297: --
298: EXCEPTION
299: --

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

298: EXCEPTION
299: --
300: WHEN OTHERS THEN
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_p' );
303: END IF;
304: RAISE;
305: END fetch_p;
306: --

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

310: p_source_type IN ar_distributions.source_type%TYPE,
311: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
312: BEGIN
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()+' );
315: END IF;
316: SELECT *
317: INTO p_dist_rec
318: FROM ar_distributions

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

319: WHERE source_id = p_source_id
320: AND source_table = p_source_table
321: AND source_type = p_source_type;
322: IF PG_DEBUG in ('Y', 'C') THEN
323: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()-' );
324: END IF;
325: --
326: EXCEPTION
327: --

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

326: EXCEPTION
327: --
328: WHEN OTHERS THEN
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_pk' );
331: END IF;
332: RAISE;
333: END fetch_pk;
334: --

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

338: p_source_type IN ar_distributions.source_type%TYPE,
339: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
340: BEGIN
341: IF PG_DEBUG in ('Y', 'C') THEN
342: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()+' );
343: END IF;
344: SELECT *
345: INTO p_dist_rec
346: FROM ar_distributions

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

349: AND source_type = p_source_type
350: FOR UPDATE OF line_id;
351:
352: IF PG_DEBUG in ('Y', 'C') THEN
353: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()-' );
354: END IF;
355: --
356: EXCEPTION
357: --

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

356: EXCEPTION
357: --
358: WHEN OTHERS THEN
359: IF PG_DEBUG in ('Y', 'C') THEN
360: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_fetch_pk' );
361: END IF;
362: RAISE;
363: END lock_fetch_pk;
364: --

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

368: p_source_type IN ar_distributions.source_type%TYPE,
369: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
370: BEGIN
371: IF PG_DEBUG in ('Y', 'C') THEN
372: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()+' );
373: END IF;
374: SELECT *
375: INTO p_dist_rec
376: FROM ar_distributions

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

379: AND source_type = p_source_type
380: FOR UPDATE OF line_id NOWAIT;
381:
382: IF PG_DEBUG in ('Y', 'C') THEN
383: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()-' );
384: END IF;
385: --
386: EXCEPTION
387: --

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

386: EXCEPTION
387: --
388: WHEN OTHERS THEN
389: IF PG_DEBUG in ('Y', 'C') THEN
390: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.nowaitlock_fetch_pk' );
391: END IF;
392: RAISE;
393: END nowaitlock_fetch_pk;
394: --

Line 395: END ARP_DISTRIBUTIONS_PKG;

391: END IF;
392: RAISE;
393: END nowaitlock_fetch_pk;
394: --
395: END ARP_DISTRIBUTIONS_PKG;