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_PROCESS_BATCH dependencies on ARP_PROCESS_BATCH

Line 1: PACKAGE BODY ARP_PROCESS_BATCH AS

1: PACKAGE BODY ARP_PROCESS_BATCH AS
2: /* $Header: ARTEBATB.pls 115.5 2002/11/18 22:31:30 anukumar ship $ */
3:
4:
5: /*===========================================================================+

Line 44: arp_util.debug('arp_process_batch.check_dup_batch_name()+');

40: l_count number := 0;
41:
42: BEGIN
43:
44: arp_util.debug('arp_process_batch.check_dup_batch_name()+');
45:
46: /*Where clause is changed to solve bug 868793 : now batch name should be unique across batch sources */
47: SELECT count(*)
48: INTO l_count

Line 58: arp_util.debug('arp_process_batch.check_dup_batch_name()-');

54: THEN fnd_message.set_name('AR', 'AR_DUP_BATCH_NAME');
55: app_exception.raise_exception;
56: END IF;
57:
58: arp_util.debug('arp_process_batch.check_dup_batch_name()-');
59:
60: EXCEPTION
61: WHEN OTHERS THEN
62: arp_util.debug('EXCEPTION: arp_process_batch.check_dup_batch_name()');

Line 62: arp_util.debug('EXCEPTION: arp_process_batch.check_dup_batch_name()');

58: arp_util.debug('arp_process_batch.check_dup_batch_name()-');
59:
60: EXCEPTION
61: WHEN OTHERS THEN
62: arp_util.debug('EXCEPTION: arp_process_batch.check_dup_batch_name()');
63:
64: arp_util.debug('');
65: arp_util.debug('------ parameters for check_dup_batch_name() -------');
66:

Line 107: arp_util.debug('arp_process_batch.ar_empty_batch()+');

103: l_count number := 0;
104:
105: BEGIN
106:
107: arp_util.debug('arp_process_batch.ar_empty_batch()+');
108:
109: SELECT count(*)
110: INTO l_count
111: FROM ra_customer_trx

Line 120: arp_util.debug('arp_process_batch.ar_empty_batch()-');

116: THEN fnd_message.set_name('AR', 'AR_DELNA_TRANSACTION_EXISTS');
117: app_exception.raise_exception;
118: END IF;
119:
120: arp_util.debug('arp_process_batch.ar_empty_batch()-');
121:
122: EXCEPTION
123: WHEN OTHERS THEN
124:

Line 125: arp_util.debug('EXCEPTION: arp_process_batch.ar_empty_batch()');

121:
122: EXCEPTION
123: WHEN OTHERS THEN
124:
125: arp_util.debug('EXCEPTION: arp_process_batch.ar_empty_batch()');
126:
127: arp_util.debug('');
128: arp_util.debug('------ parameters for ar_empty_batch() -------');
129:

Line 168: arp_util.debug('arp_process_batch.val_insert_batch()+');

164:
165:
166: BEGIN
167:
168: arp_util.debug('arp_process_batch.val_insert_batch()+');
169:
170: arp_process_batch.check_dup_batch_name(p_batch_rec.name,
171: p_batch_rec.batch_source_id);
172:

Line 170: arp_process_batch.check_dup_batch_name(p_batch_rec.name,

166: BEGIN
167:
168: arp_util.debug('arp_process_batch.val_insert_batch()+');
169:
170: arp_process_batch.check_dup_batch_name(p_batch_rec.name,
171: p_batch_rec.batch_source_id);
172:
173: arp_util.debug('arp_process_batch.val_insert_batch()-');
174:

Line 173: arp_util.debug('arp_process_batch.val_insert_batch()-');

169:
170: arp_process_batch.check_dup_batch_name(p_batch_rec.name,
171: p_batch_rec.batch_source_id);
172:
173: arp_util.debug('arp_process_batch.val_insert_batch()-');
174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: arp_util.debug('EXCEPTION: arp_process_batch.val_insert_batch()');

Line 177: arp_util.debug('EXCEPTION: arp_process_batch.val_insert_batch()');

173: arp_util.debug('arp_process_batch.val_insert_batch()-');
174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: arp_util.debug('EXCEPTION: arp_process_batch.val_insert_batch()');
178:
179: arp_util.debug('');
180: arp_util.debug('------ parameters for val_insert_batch() -------');
181:

Line 220: arp_util.debug('arp_process_batchval_update_batch()+');

216:
217:
218: BEGIN
219:
220: arp_util.debug('arp_process_batchval_update_batch()+');
221:
222: arp_util.debug('arp_process_batch.val_update_batch()-');
223:
224: EXCEPTION

Line 222: arp_util.debug('arp_process_batch.val_update_batch()-');

218: BEGIN
219:
220: arp_util.debug('arp_process_batchval_update_batch()+');
221:
222: arp_util.debug('arp_process_batch.val_update_batch()-');
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: arp_util.debug('EXCEPTION: arp_process_batch.val_update_batch()');

Line 226: arp_util.debug('EXCEPTION: arp_process_batch.val_update_batch()');

222: arp_util.debug('arp_process_batch.val_update_batch()-');
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: arp_util.debug('EXCEPTION: arp_process_batch.val_update_batch()');
227:
228: arp_util.debug('');
229: arp_util.debug('------ parameters for val_update_batch() -------');
230:

Line 269: arp_util.debug('arp_process_batch.val_delete_batch()+');

265:
266:
267: BEGIN
268:
269: arp_util.debug('arp_process_batch.val_delete_batch()+');
270:
271: -- verify that the batch does not contain any transactions
272: arp_process_batch.ar_empty_batch(p_batch_rec.batch_id);
273:

Line 272: arp_process_batch.ar_empty_batch(p_batch_rec.batch_id);

268:
269: arp_util.debug('arp_process_batch.val_delete_batch()+');
270:
271: -- verify that the batch does not contain any transactions
272: arp_process_batch.ar_empty_batch(p_batch_rec.batch_id);
273:
274: arp_util.debug('arp_process_batch.val_delete_batch()-');
275:
276: EXCEPTION

Line 274: arp_util.debug('arp_process_batch.val_delete_batch()-');

270:
271: -- verify that the batch does not contain any transactions
272: arp_process_batch.ar_empty_batch(p_batch_rec.batch_id);
273:
274: arp_util.debug('arp_process_batch.val_delete_batch()-');
275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: arp_util.debug('EXCEPTION: arp_process_batch.val_delete_batch()');

Line 278: arp_util.debug('EXCEPTION: arp_process_batch.val_delete_batch()');

274: arp_util.debug('arp_process_batch.val_delete_batch()-');
275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: arp_util.debug('EXCEPTION: arp_process_batch.val_delete_batch()');
279:
280: arp_util.debug('');
281: arp_util.debug('------ parameters for val_delete_batch() -------');
282:

Line 330: arp_util.debug('arp_process_batch.insert_batch()+');

326: IS
327:
328: BEGIN
329:
330: arp_util.debug('arp_process_batch.insert_batch()+');
331:
332: /*----------------------------------------------+
333: | Check the form version to determine if it |
334: | is compatible with the entity handler. |

Line 343: arp_process_batch.val_insert_batch(p_batch_rec);

339: /*-------------------------+
340: | Do required validation |
341: +-------------------------*/
342:
343: arp_process_batch.val_insert_batch(p_batch_rec);
344:
345: /*---------------------------------------------+
346: | Call the table handler to insert the batch |
347: +---------------------------------------------*/

Line 353: arp_util.debug('arp_process_batch.insert_batch()-');

349: arp_tbat_pkg.insert_p( p_batch_rec,
350: p_batch_id,
351: p_name);
352:
353: arp_util.debug('arp_process_batch.insert_batch()-');
354:
355: EXCEPTION
356: WHEN OTHERS THEN
357:

Line 362: arp_util.debug('EXCEPTION: arp_process_batch.insert_batch()');

358: /*---------------------------------------------+
359: | Display parameters and raise the exception |
360: +---------------------------------------------*/
361:
362: arp_util.debug('EXCEPTION: arp_process_batch.insert_batch()');
363:
364: arp_util.debug('');
365: arp_util.debug('---------- parameters for insert_batch() ---------');
366:

Line 417: arp_util.debug('arp_process_batch.update_batch()+');

413:
414:
415: BEGIN
416:
417: arp_util.debug('arp_process_batch.update_batch()+');
418:
419: /*----------------------------------------------+
420: | Check the form version to determine if it |
421: | is compatible with the entity handler. |

Line 432: arp_process_batch.val_update_batch(p_batch_rec);

428: /*-------------------------+
429: | Do required validation |
430: +-------------------------*/
431:
432: arp_process_batch.val_update_batch(p_batch_rec);
433:
434:
435: /*-----------------------------------------------------+
436: | call the table-handler to update the batch record |

Line 442: arp_util.debug('arp_process_batch.update_batch()-');

438:
439: arp_tbat_pkg.update_p( p_batch_rec,
440: p_batch_id);
441:
442: arp_util.debug('arp_process_batch.update_batch()-');
443:
444: EXCEPTION
445: WHEN OTHERS THEN
446:

Line 451: arp_util.debug('EXCEPTION: arp_process_batch.update_batch()');

447: /*---------------------------------------------+
448: | Display parameters and raise the exception |
449: +---------------------------------------------*/
450:
451: arp_util.debug('EXCEPTION: arp_process_batch.update_batch()');
452:
453: arp_util.debug('');
454: arp_util.debug('---------- parameters for update_batch() ---------');
455:

Line 503: arp_util.debug('arp_process_batch.delete_batch()+');

499: p_batch_rec IN ra_batches%rowtype) IS
500:
501: BEGIN
502:
503: arp_util.debug('arp_process_batch.delete_batch()+');
504:
505: /*----------------------------------------------+
506: | Check the form version to determine if it |
507: | is compatible with the entity handler. |

Line 516: arp_process_batch.val_delete_batch(p_batch_rec);

512: /*-------------------------+
513: | Do required validation |
514: +-------------------------*/
515:
516: arp_process_batch.val_delete_batch(p_batch_rec);
517:
518: /*-----------------------------------------------------+
519: | call the table-handler to delete the batch record |
520: +-----------------------------------------------------*/

Line 524: arp_util.debug('arp_process_batch.delete_batch()-');

520: +-----------------------------------------------------*/
521:
522: arp_tbat_pkg.delete_p( p_batch_id );
523:
524: arp_util.debug('arp_process_batch.delete_batch()-');
525:
526: EXCEPTION
527: WHEN OTHERS THEN
528:

Line 533: arp_util.debug('EXCEPTION: arp_process_batch.delete_batch()');

529: /*---------------------------------------------+
530: | Display parameters and raise the exception |
531: +---------------------------------------------*/
532:
533: arp_util.debug('EXCEPTION: arp_process_batch.delete_batch()');
534:
535: arp_util.debug('');
536: arp_util.debug('---------- parameters for delete_batch() ---------');
537:

Line 634: arp_util.debug('arp_process_batch.insert_batch_cover()+');

630: l_batch_rec ra_batches%rowtype;
631: l_batch_id ra_batches.batch_id%type;
632: l_name ra_batches.name%type;
633: BEGIN
634: arp_util.debug('arp_process_batch.insert_batch_cover()+');
635:
636: l_batch_rec.batch_source_id := p_batch_source_id;
637: l_batch_rec.batch_date := p_batch_date;
638: l_batch_rec.gl_date := p_gl_date;

Line 668: arp_process_batch.insert_batch(p_form_name,

664: l_batch_rec.attribute14 := p_attribute14;
665: l_batch_rec.attribute15 := p_attribute15;
666: l_batch_rec.name := p_name;
667:
668: arp_process_batch.insert_batch(p_form_name,
669: p_form_version,
670: l_batch_rec,
671: l_batch_id,
672: l_name);

Line 677: arp_util.debug('arp_process_batch.insert_batch_cover()-');

673:
674: p_batch_id := l_batch_id;
675: p_name := l_name;
676:
677: arp_util.debug('arp_process_batch.insert_batch_cover()-');
678:
679: EXCEPTION
680: WHEN OTHERS THEN
681: arp_util.debug('EXCEPTION : arp_process_batch.insert_batch_cover');

Line 681: arp_util.debug('EXCEPTION : arp_process_batch.insert_batch_cover');

677: arp_util.debug('arp_process_batch.insert_batch_cover()-');
678:
679: EXCEPTION
680: WHEN OTHERS THEN
681: arp_util.debug('EXCEPTION : arp_process_batch.insert_batch_cover');
682: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
683: arp_util.debug('p_batch_date : '||p_batch_date);
684: arp_util.debug('p_gl_date : '||p_gl_date);
685: arp_util.debug('p_status : '||p_status);

Line 802: arp_util.debug('arp_process_batch.update_batch_cover()+');

798: IS
799: l_batch_rec ra_batches%rowtype;
800: BEGIN
801:
802: arp_util.debug('arp_process_batch.update_batch_cover()+');
803:
804: arp_tbat_pkg.set_to_dummy(l_batch_rec);
805:
806: l_batch_rec.batch_id := p_batch_id;

Line 839: arp_process_batch.update_batch(p_form_name,

835: l_batch_rec.attribute13 := p_attribute13;
836: l_batch_rec.attribute14 := p_attribute14;
837: l_batch_rec.attribute15 := p_attribute15;
838:
839: arp_process_batch.update_batch(p_form_name,
840: p_form_version,
841: p_batch_id,
842: l_batch_rec);
843:

Line 844: arp_util.debug('arp_process_batch.update_batch_cover()-');

840: p_form_version,
841: p_batch_id,
842: l_batch_rec);
843:
844: arp_util.debug('arp_process_batch.update_batch_cover()-');
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: arp_util.debug('EXCEPTION : arp_process_batch.update_batch_cover');

Line 848: arp_util.debug('EXCEPTION : arp_process_batch.update_batch_cover');

844: arp_util.debug('arp_process_batch.update_batch_cover()-');
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: arp_util.debug('EXCEPTION : arp_process_batch.update_batch_cover');
849: arp_util.debug('p_batch_id : '||p_batch_id);
850: arp_util.debug('p_name : '||p_name);
851: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
852: arp_util.debug('p_batch_date : '||p_batch_date);

Line 923: arp_util.debug('arp_process_batch.delete_batch_cover()+');

919: p_batch_id IN ra_batches.batch_id%type)
920: IS
921: l_batch_rec ra_batches%rowtype;
922: BEGIN
923: arp_util.debug('arp_process_batch.delete_batch_cover()+');
924:
925: arp_tbat_pkg.set_to_dummy(l_batch_rec);
926: l_batch_rec.batch_id := p_batch_id;
927:

Line 928: arp_process_batch.delete_batch(p_form_name,

924:
925: arp_tbat_pkg.set_to_dummy(l_batch_rec);
926: l_batch_rec.batch_id := p_batch_id;
927:
928: arp_process_batch.delete_batch(p_form_name,
929: p_form_version,
930: p_batch_id,
931: l_batch_rec);
932:

Line 933: arp_util.debug('arp_process_batch.delete_batch_cover()-');

929: p_form_version,
930: p_batch_id,
931: l_batch_rec);
932:
933: arp_util.debug('arp_process_batch.delete_batch_cover()-');
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: arp_util.debug('EXCEPTION : arp_process_batch.delete_batch_cover');

Line 937: arp_util.debug('EXCEPTION : arp_process_batch.delete_batch_cover');

933: arp_util.debug('arp_process_batch.delete_batch_cover()-');
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: arp_util.debug('EXCEPTION : arp_process_batch.delete_batch_cover');
938:
939: arp_util.debug('p_form_name : '||p_form_name);
940: arp_util.debug('p_form_version : '||p_form_version);
941: arp_util.debug('p_batch_id : '||p_batch_id);

Line 946: END ARP_PROCESS_BATCH;

942:
943: RAISE;
944: END;
945:
946: END ARP_PROCESS_BATCH;