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_RW_BATCHES_PKG dependencies on ARP_UTIL

Line 59: | arp_util.debug - debug procedure |

55: | |
56: | SCOPE - PUBLIC |
57: | |
58: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
59: | arp_util.debug - debug procedure |
60: | |
61: | ARGUMENTS : IN: |
62: | p_row_id - Row ID |
63: | p_batch_source_id - Batch Source Id |

Line 127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );

123: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
124: --
125: BEGIN
126: IF PG_DEBUG in ('Y', 'C') THEN
127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );
128: arp_util.debug('validate_args_insert_manual: ' || 'Row Id : '||p_row_id );
129: arp_util.debug('validate_args_insert_manual: ' || 'Batch Id : '||p_batch_id );
130: arp_util.debug('validate_args_insert_manual: ' || 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
131: arp_util.debug('validate_args_insert_manual: ' || 'Batch Name : '||p_name );

Line 128: arp_util.debug('validate_args_insert_manual: ' || 'Row Id : '||p_row_id );

124: --
125: BEGIN
126: IF PG_DEBUG in ('Y', 'C') THEN
127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );
128: arp_util.debug('validate_args_insert_manual: ' || 'Row Id : '||p_row_id );
129: arp_util.debug('validate_args_insert_manual: ' || 'Batch Id : '||p_batch_id );
130: arp_util.debug('validate_args_insert_manual: ' || 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
131: arp_util.debug('validate_args_insert_manual: ' || 'Batch Name : '||p_name );
132: arp_util.debug('validate_args_insert_manual: ' || 'GL Date : '||p_gl_date );

Line 129: arp_util.debug('validate_args_insert_manual: ' || 'Batch Id : '||p_batch_id );

125: BEGIN
126: IF PG_DEBUG in ('Y', 'C') THEN
127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );
128: arp_util.debug('validate_args_insert_manual: ' || 'Row Id : '||p_row_id );
129: arp_util.debug('validate_args_insert_manual: ' || 'Batch Id : '||p_batch_id );
130: arp_util.debug('validate_args_insert_manual: ' || 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
131: arp_util.debug('validate_args_insert_manual: ' || 'Batch Name : '||p_name );
132: arp_util.debug('validate_args_insert_manual: ' || 'GL Date : '||p_gl_date );
133: END IF;

Line 130: arp_util.debug('validate_args_insert_manual: ' || 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );

126: IF PG_DEBUG in ('Y', 'C') THEN
127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );
128: arp_util.debug('validate_args_insert_manual: ' || 'Row Id : '||p_row_id );
129: arp_util.debug('validate_args_insert_manual: ' || 'Batch Id : '||p_batch_id );
130: arp_util.debug('validate_args_insert_manual: ' || 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
131: arp_util.debug('validate_args_insert_manual: ' || 'Batch Name : '||p_name );
132: arp_util.debug('validate_args_insert_manual: ' || 'GL Date : '||p_gl_date );
133: END IF;
134: --

Line 131: arp_util.debug('validate_args_insert_manual: ' || 'Batch Name : '||p_name );

127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );
128: arp_util.debug('validate_args_insert_manual: ' || 'Row Id : '||p_row_id );
129: arp_util.debug('validate_args_insert_manual: ' || 'Batch Id : '||p_batch_id );
130: arp_util.debug('validate_args_insert_manual: ' || 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
131: arp_util.debug('validate_args_insert_manual: ' || 'Batch Name : '||p_name );
132: arp_util.debug('validate_args_insert_manual: ' || 'GL Date : '||p_gl_date );
133: END IF;
134: --
135: -- Populate local batch record to be passed onto insert table handler

Line 132: arp_util.debug('validate_args_insert_manual: ' || 'GL Date : '||p_gl_date );

128: arp_util.debug('validate_args_insert_manual: ' || 'Row Id : '||p_row_id );
129: arp_util.debug('validate_args_insert_manual: ' || 'Batch Id : '||p_batch_id );
130: arp_util.debug('validate_args_insert_manual: ' || 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
131: arp_util.debug('validate_args_insert_manual: ' || 'Batch Name : '||p_name );
132: arp_util.debug('validate_args_insert_manual: ' || 'GL Date : '||p_gl_date );
133: END IF;
134: --
135: -- Populate local batch record to be passed onto insert table handler
136: --

Line 188: arp_util.debug('validate_args_insert_manual: ' || 'Auto Batch Num : '||l_auto_batch_numbering );

184: FROM ar_batch_sources
185: WHERE batch_source_id = l_batch_rec.batch_source_id;
186: --
187: IF PG_DEBUG in ('Y', 'C') THEN
188: arp_util.debug('validate_args_insert_manual: ' || 'Auto Batch Num : '||l_auto_batch_numbering );
189: END IF;
190: --
191: -- Make sure that the row_id is null and a batch type is passed in
192: --

Line 232: arp_util.validate_gl_date( l_batch_rec.gl_date,

228: END IF;
229: --
230: -- Check for valid GL date
231: --
232: arp_util.validate_gl_date( l_batch_rec.gl_date,
233: NULL, NULL );
234: --
235: --
236: -- Call Check Unique Batch Name is unique for a given batch source id

Line 255: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()-' );

251: --
252: p_batch_applied_status := l_batch_rec.batch_applied_status;
253: --
254: IF PG_DEBUG in ('Y', 'C') THEN
255: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()-' );
256: END IF;
257: --
258: EXCEPTION
259: WHEN OTHERS THEN

Line 261: arp_util.debug('validate_args_insert_manual: ' || 'EXCEPTION: arp_rw_batches_pkg.insert_manual_batch' );

257: --
258: EXCEPTION
259: WHEN OTHERS THEN
260: IF PG_DEBUG in ('Y', 'C') THEN
261: arp_util.debug('validate_args_insert_manual: ' || 'EXCEPTION: arp_rw_batches_pkg.insert_manual_batch' );
262: END IF;
263: RAISE;
264: END insert_manual_batch;
265: --

Line 276: | arp_util.debug - debug procedure |

272: | |
273: | SCOPE - PRIVATE |
274: | |
275: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
276: | arp_util.debug - debug procedure |
277: | |
278: | ARGUMENTS : IN: |
279: | p_type - Batch Type |
280: | OUT: |

Line 304: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()+' );

300: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE) IS
301: l_field VARCHAR2(30);
302: BEGIN
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()+' );
305: END IF;
306: --
307: IF ( p_row_id IS NOT NULL ) THEN
308: l_field := 'ROW_ID';

Line 341: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()-' );

337: APP_EXCEPTION.raise_exception;
338: END IF;
339: --
340: IF PG_DEBUG in ('Y', 'C') THEN
341: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()-' );
342: END IF;
343: --
344: EXCEPTION
345: WHEN OTHERS THEN

Line 347: arp_util.debug('validate_args_insert_manual: ' ||

343: --
344: EXCEPTION
345: WHEN OTHERS THEN
346: IF PG_DEBUG in ('Y', 'C') THEN
347: arp_util.debug('validate_args_insert_manual: ' ||
348: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_manual' );
349: END IF;
350: RAISE;
351: END validate_args_insert_manual;

Line 365: | arp_util.debug - debug procedure |

361: | |
362: | SCOPE - PUBLIC |
363: | |
364: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
365: | arp_util.debug - debug procedure |
366: | |
367: | ARGUMENTS : IN: |
368: | p_row_id - Row ID |
369: | p_batch_source_id - Batch Source Id |

Line 464: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()+' );

460: l_func_curr_code VARCHAR2(15);
461:
462: BEGIN
463: IF PG_DEBUG in ('Y', 'C') THEN
464: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()+' );
465: arp_util.debug('insert_auto_batch: ' || 'Row Id : '||p_row_id );
466: arp_util.debug('insert_auto_batch: ' || 'Batch Id : '||p_batch_id );
467: arp_util.debug('insert_auto_batch: ' || 'GL Date : '||p_gl_date );
468: arp_util.debug('insert_auto_batch: ' || 'Bank_account_low : '||p_bank_account_low );

Line 465: arp_util.debug('insert_auto_batch: ' || 'Row Id : '||p_row_id );

461:
462: BEGIN
463: IF PG_DEBUG in ('Y', 'C') THEN
464: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()+' );
465: arp_util.debug('insert_auto_batch: ' || 'Row Id : '||p_row_id );
466: arp_util.debug('insert_auto_batch: ' || 'Batch Id : '||p_batch_id );
467: arp_util.debug('insert_auto_batch: ' || 'GL Date : '||p_gl_date );
468: arp_util.debug('insert_auto_batch: ' || 'Bank_account_low : '||p_bank_account_low );
469: arp_util.debug('insert_auto_batch: ' || 'Bank_account_high : '||p_bank_account_high );

Line 466: arp_util.debug('insert_auto_batch: ' || 'Batch Id : '||p_batch_id );

462: BEGIN
463: IF PG_DEBUG in ('Y', 'C') THEN
464: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()+' );
465: arp_util.debug('insert_auto_batch: ' || 'Row Id : '||p_row_id );
466: arp_util.debug('insert_auto_batch: ' || 'Batch Id : '||p_batch_id );
467: arp_util.debug('insert_auto_batch: ' || 'GL Date : '||p_gl_date );
468: arp_util.debug('insert_auto_batch: ' || 'Bank_account_low : '||p_bank_account_low );
469: arp_util.debug('insert_auto_batch: ' || 'Bank_account_high : '||p_bank_account_high );
470: END IF;

Line 467: arp_util.debug('insert_auto_batch: ' || 'GL Date : '||p_gl_date );

463: IF PG_DEBUG in ('Y', 'C') THEN
464: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()+' );
465: arp_util.debug('insert_auto_batch: ' || 'Row Id : '||p_row_id );
466: arp_util.debug('insert_auto_batch: ' || 'Batch Id : '||p_batch_id );
467: arp_util.debug('insert_auto_batch: ' || 'GL Date : '||p_gl_date );
468: arp_util.debug('insert_auto_batch: ' || 'Bank_account_low : '||p_bank_account_low );
469: arp_util.debug('insert_auto_batch: ' || 'Bank_account_high : '||p_bank_account_high );
470: END IF;
471:

Line 468: arp_util.debug('insert_auto_batch: ' || 'Bank_account_low : '||p_bank_account_low );

464: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()+' );
465: arp_util.debug('insert_auto_batch: ' || 'Row Id : '||p_row_id );
466: arp_util.debug('insert_auto_batch: ' || 'Batch Id : '||p_batch_id );
467: arp_util.debug('insert_auto_batch: ' || 'GL Date : '||p_gl_date );
468: arp_util.debug('insert_auto_batch: ' || 'Bank_account_low : '||p_bank_account_low );
469: arp_util.debug('insert_auto_batch: ' || 'Bank_account_high : '||p_bank_account_high );
470: END IF;
471:
472: --

Line 469: arp_util.debug('insert_auto_batch: ' || 'Bank_account_high : '||p_bank_account_high );

465: arp_util.debug('insert_auto_batch: ' || 'Row Id : '||p_row_id );
466: arp_util.debug('insert_auto_batch: ' || 'Batch Id : '||p_batch_id );
467: arp_util.debug('insert_auto_batch: ' || 'GL Date : '||p_gl_date );
468: arp_util.debug('insert_auto_batch: ' || 'Bank_account_low : '||p_bank_account_low );
469: arp_util.debug('insert_auto_batch: ' || 'Bank_account_high : '||p_bank_account_high );
470: END IF;
471:
472: --
473: -- Populate local batch record to be passed onto insert table handler

Line 536: arp_util.validate_gl_date( l_batch_rec.gl_date,

532: l_batch_rec.gl_date := null;
533: ELSE
534: -- Check for valid GL date
535: --
536: arp_util.validate_gl_date( l_batch_rec.gl_date,
537: NULL, NULL );
538: END IF;
539:
540: -- check Receipt Class ID is valid

Line 683: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()-' );

679: --
680: p_batch_applied_status := l_batch_applied_status;
681: --
682: IF PG_DEBUG in ('Y', 'C') THEN
683: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()-' );
684: END IF;
685: --
686: EXCEPTION
687: WHEN OTHERS THEN

Line 689: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.insert_auto_batch' );

685: --
686: EXCEPTION
687: WHEN OTHERS THEN
688: IF PG_DEBUG in ('Y', 'C') THEN
689: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.insert_auto_batch' );
690: END IF;
691: RAISE;
692: END insert_auto_batch;
693: --

Line 704: | arp_util.debug - debug procedure |

700: | |
701: | SCOPE - PRIVATE |
702: | |
703: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
704: | arp_util.debug - debug procedure |
705: | |
706: | ARGUMENTS : IN: |
707: | p_type - Batch Type |
708: | OUT: |

Line 733: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()+' );

729: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
730: l_field VARCHAR2(30);
731: BEGIN
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()+' );
734: END IF;
735: --
736: IF ( p_row_id IS NOT NULL ) THEN
737: l_field := 'ROW_ID';

Line 766: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()-' );

762: APP_EXCEPTION.raise_exception;
763: END IF;
764: --
765: IF PG_DEBUG in ('Y', 'C') THEN
766: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()-' );
767: END IF;
768: --
769: EXCEPTION
770: WHEN OTHERS THEN

Line 772: arp_util.debug('validate_args_insert_auto: ' ||

768: --
769: EXCEPTION
770: WHEN OTHERS THEN
771: IF PG_DEBUG in ('Y', 'C') THEN
772: arp_util.debug('validate_args_insert_auto: ' ||
773: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_auto' );
774: END IF;
775: RAISE;
776: END validate_args_insert_auto;

Line 790: | arp_util.debug - debug procedure |

786: | |
787: | SCOPE - PUBLIC |
788: | |
789: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
790: | arp_util.debug - debug procedure |
791: | |
792: | ARGUMENTS : IN: |
793: | p_row_id - Row ID |
794: | p_batch_name - Batch Name |

Line 946: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()+' );

942: l_valid NUMBER;
943:
944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()+' );
947: arp_util.debug('insert_remit_batch: ' || 'Row Id : '||p_row_id );
948: arp_util.debug('insert_remit_batch: ' || 'Batch Id : '||p_batch_id );
949: arp_util.debug('insert_remit_batch: ' || 'GL Date : '||p_gl_date );
950: END IF;

Line 947: arp_util.debug('insert_remit_batch: ' || 'Row Id : '||p_row_id );

943:
944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()+' );
947: arp_util.debug('insert_remit_batch: ' || 'Row Id : '||p_row_id );
948: arp_util.debug('insert_remit_batch: ' || 'Batch Id : '||p_batch_id );
949: arp_util.debug('insert_remit_batch: ' || 'GL Date : '||p_gl_date );
950: END IF;
951: --

Line 948: arp_util.debug('insert_remit_batch: ' || 'Batch Id : '||p_batch_id );

944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()+' );
947: arp_util.debug('insert_remit_batch: ' || 'Row Id : '||p_row_id );
948: arp_util.debug('insert_remit_batch: ' || 'Batch Id : '||p_batch_id );
949: arp_util.debug('insert_remit_batch: ' || 'GL Date : '||p_gl_date );
950: END IF;
951: --
952: -- Populate local batch record to be passed onto insert table handler

Line 949: arp_util.debug('insert_remit_batch: ' || 'GL Date : '||p_gl_date );

945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()+' );
947: arp_util.debug('insert_remit_batch: ' || 'Row Id : '||p_row_id );
948: arp_util.debug('insert_remit_batch: ' || 'Batch Id : '||p_batch_id );
949: arp_util.debug('insert_remit_batch: ' || 'GL Date : '||p_gl_date );
950: END IF;
951: --
952: -- Populate local batch record to be passed onto insert table handler
953: --

Line 1032: arp_util.validate_gl_date( l_batch_rec.gl_date,

1028: APP_EXCEPTION.raise_exception;
1029: END IF;
1030: -- Check for valid GL date
1031: --
1032: arp_util.validate_gl_date( l_batch_rec.gl_date,
1033: NULL, NULL );
1034:
1035:
1036: -- check Receipt Class ID is valid

Line 1144: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()-' );

1140: p_batch_id );
1141: --
1142: --
1143: IF PG_DEBUG in ('Y', 'C') THEN
1144: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()-' );
1145: END IF;
1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN

Line 1150: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.insert_remit_batch' );

1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: IF PG_DEBUG in ('Y', 'C') THEN
1150: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.insert_remit_batch' );
1151: END IF;
1152: RAISE;
1153: END insert_remit_batch;
1154: --

Line 1165: | arp_util.debug - debug procedure |

1161: | |
1162: | SCOPE - PRIVATE |
1163: | |
1164: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1165: | arp_util.debug - debug procedure |
1166: | |
1167: | ARGUMENTS : IN: |
1168: | p_type - Batch Type |
1169: | OUT: |

Line 1193: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()+' );

1189: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
1190: l_field VARCHAR2(30);
1191: BEGIN
1192: IF PG_DEBUG in ('Y', 'C') THEN
1193: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()+' );
1194: END IF;
1195: --
1196: IF ( p_row_id IS NOT NULL ) THEN
1197: l_field := 'ROW_ID';

Line 1232: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()-' );

1228: APP_EXCEPTION.raise_exception;
1229: END IF;
1230: --
1231: IF PG_DEBUG in ('Y', 'C') THEN
1232: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()-' );
1233: END IF;
1234: --
1235: EXCEPTION
1236: WHEN OTHERS THEN

Line 1238: arp_util.debug('validate_args_insert_remit: ' ||

1234: --
1235: EXCEPTION
1236: WHEN OTHERS THEN
1237: IF PG_DEBUG in ('Y', 'C') THEN
1238: arp_util.debug('validate_args_insert_remit: ' ||
1239: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_remit' );
1240: END IF;
1241: RAISE;
1242: END validate_args_insert_remit;