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 58: | arp_util.debug - debug procedure |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 231: arp_util.validate_gl_date( l_batch_rec.gl_date,

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

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

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

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

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

Line 275: | arp_util.debug - debug procedure |

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

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

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

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

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

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

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

Line 364: | arp_util.debug - debug procedure |

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 535: arp_util.validate_gl_date( l_batch_rec.gl_date,

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

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

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

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

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

Line 703: | arp_util.debug - debug procedure |

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

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

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

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

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

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

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

Line 789: | arp_util.debug - debug procedure |

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

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

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

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

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

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

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

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

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

Line 1031: arp_util.validate_gl_date( l_batch_rec.gl_date,

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

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

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

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

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

Line 1164: | arp_util.debug - debug procedure |

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

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

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

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

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

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

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