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_BR_REMIT_BATCHES dependencies on ARP_BR_REMIT_BATCHES

Line 1: PACKAGE BODY ARP_BR_REMIT_BATCHES AS

1: PACKAGE BODY ARP_BR_REMIT_BATCHES AS
2: /* $Header: ARBRRM1B.pls 120.4.12010000.6 2009/12/22 13:07:42 pbapna ship $*/
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_BR_REMIT_BATCHES';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_BR_REMIT_BATCHES';

1: PACKAGE BODY ARP_BR_REMIT_BATCHES AS
2: /* $Header: ARBRRM1B.pls 120.4.12010000.6 2009/12/22 13:07:42 pbapna ship $*/
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_BR_REMIT_BATCHES';
5:
6: TYPE CUR_TYP IS REF CURSOR;
7:
8: /*-------------- Private procedures used by the package --------------------*/

Line 103: arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit (+)');

99:
100: BEGIN
101:
102: IF PG_DEBUG in ('Y', 'C') THEN
103: arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit (+)');
104: END IF;
105:
106: l_batch_rec.batch_date := p_batch_date;
107: l_batch_rec.gl_date := p_gl_date;

Line 161: arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit ... last_batch_num:'||l_batch_rec.name);

157: FROM ar_batch_sources
158: WHERE batch_source_id = l_batch_rec.batch_source_id;
159:
160: IF PG_DEBUG in ('Y', 'C') THEN
161: arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit ... last_batch_num:'||l_batch_rec.name);
162: END IF;
163:
164:
165: ------------------------------------------

Line 168: arp_br_remit_batches.validate_args_insert_remit(l_batch_rec);

164:
165: ------------------------------------------
166: -- Validation
167: ------------------------------------------
168: arp_br_remit_batches.validate_args_insert_remit(l_batch_rec);
169:
170: ------------------------------------------
171: -- Call insert table handler
172: ------------------------------------------

Line 179: arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit (-)');

175: p_batch_name := l_batch_rec.name;
176: p_batch_applied_status := l_batch_rec.batch_applied_status;
177:
178: IF PG_DEBUG in ('Y', 'C') THEN
179: arp_util.debug( 'ARP_BR_REMIT_BATCHES.insert_remit (-)');
180: END IF;
181:
182:
183: EXCEPTION

Line 186: arp_util.debug( 'EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.insert_remit');

182:
183: EXCEPTION
184: WHEN OTHERS THEN
185: IF PG_DEBUG in ('Y', 'C') THEN
186: arp_util.debug( 'EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.insert_remit');
187: END IF;
188: RAISE;
189:
190: END insert_remit;

Line 223: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_insert_remit (+)');

219:
220: BEGIN
221:
222: IF PG_DEBUG in ('Y', 'C') THEN
223: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_insert_remit (+)');
224: END IF;
225:
226: -- Check that the main columns are filled
227: IF (p_batch_rec.type IS NULL) THEN

Line 263: arp_br_remit_batches.validate_currency_code(p_batch_rec.currency_code,p_batch_rec.batch_date);

259: -- Check that the gl date is valid
260: arp_util.validate_gl_date(p_batch_rec.gl_date, NULL, NULL);
261:
262: -- Check that the currency is valid
263: arp_br_remit_batches.validate_currency_code(p_batch_rec.currency_code,p_batch_rec.batch_date);
264:
265: -- Check that the receipt method is valid
266: arp_br_remit_batches.validate_receipt_method(p_batch_rec.receipt_method_id, p_batch_rec.batch_date);
267:

Line 266: arp_br_remit_batches.validate_receipt_method(p_batch_rec.receipt_method_id, p_batch_rec.batch_date);

262: -- Check that the currency is valid
263: arp_br_remit_batches.validate_currency_code(p_batch_rec.currency_code,p_batch_rec.batch_date);
264:
265: -- Check that the receipt method is valid
266: arp_br_remit_batches.validate_receipt_method(p_batch_rec.receipt_method_id, p_batch_rec.batch_date);
267:
268: -- Check that the remittance bank branch is valid
269: arp_br_remit_batches.validate_remit_bank_branch(p_batch_rec.remittance_bank_branch_id,p_batch_rec.batch_date);
270:

Line 269: arp_br_remit_batches.validate_remit_bank_branch(p_batch_rec.remittance_bank_branch_id,p_batch_rec.batch_date);

265: -- Check that the receipt method is valid
266: arp_br_remit_batches.validate_receipt_method(p_batch_rec.receipt_method_id, p_batch_rec.batch_date);
267:
268: -- Check that the remittance bank branch is valid
269: arp_br_remit_batches.validate_remit_bank_branch(p_batch_rec.remittance_bank_branch_id,p_batch_rec.batch_date);
270:
271: -- Check that the remittance account is valid
272: arp_br_remit_batches.validate_remit_bank_account(p_batch_rec.remit_bank_acct_use_id,p_batch_rec.batch_date);
273:

Line 272: arp_br_remit_batches.validate_remit_bank_account(p_batch_rec.remit_bank_acct_use_id,p_batch_rec.batch_date);

268: -- Check that the remittance bank branch is valid
269: arp_br_remit_batches.validate_remit_bank_branch(p_batch_rec.remittance_bank_branch_id,p_batch_rec.batch_date);
270:
271: -- Check that the remittance account is valid
272: arp_br_remit_batches.validate_remit_bank_account(p_batch_rec.remit_bank_acct_use_id,p_batch_rec.batch_date);
273:
274: -- Check that the remittance method and the flag with_recouse are consistent
275: arp_br_remit_batches.validate_remit_method_code(p_batch_rec.remit_method_code,p_batch_rec.with_recourse_flag);
276:

Line 275: arp_br_remit_batches.validate_remit_method_code(p_batch_rec.remit_method_code,p_batch_rec.with_recourse_flag);

271: -- Check that the remittance account is valid
272: arp_br_remit_batches.validate_remit_bank_account(p_batch_rec.remit_bank_acct_use_id,p_batch_rec.batch_date);
273:
274: -- Check that the remittance method and the flag with_recouse are consistent
275: arp_br_remit_batches.validate_remit_method_code(p_batch_rec.remit_method_code,p_batch_rec.with_recourse_flag);
276:
277: -- Check that the format program is a type 'REMIT_TRANSMIT' program
278: arp_br_remit_batches.validate_auto_program(p_batch_rec.auto_trans_program_id);
279:

Line 278: arp_br_remit_batches.validate_auto_program(p_batch_rec.auto_trans_program_id);

274: -- Check that the remittance method and the flag with_recouse are consistent
275: arp_br_remit_batches.validate_remit_method_code(p_batch_rec.remit_method_code,p_batch_rec.with_recourse_flag);
276:
277: -- Check that the format program is a type 'REMIT_TRANSMIT' program
278: arp_br_remit_batches.validate_auto_program(p_batch_rec.auto_trans_program_id);
279:
280: -- IF media reference is filled, Check that it is unique
281: IF (p_batch_rec.media_reference IS NOT NULL) THEN
282: arp_rw_batches_check_pkg.check_unique_media_ref(l_row_id,

Line 289: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_insert_remit (-)');

285: NULL);
286: END IF;
287:
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_insert_remit (-)');
290: END IF;
291:
292: EXCEPTION
293: WHEN OTHERS THEN

Line 295: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_args_insert_remit');

291:
292: EXCEPTION
293: WHEN OTHERS THEN
294: IF PG_DEBUG in ('Y', 'C') THEN
295: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_args_insert_remit');
296: END IF;
297: RAISE;
298:
299: END validate_args_insert_remit;

Line 331: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_currency_code (+)');

327:
328: BEGIN
329:
330: IF PG_DEBUG in ('Y', 'C') THEN
331: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_currency_code (+)');
332: END IF;
333:
334: SELECT COUNT(*)
335: INTO NB

Line 346: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_currency_code (-)');

342: APP_EXCEPTION.raise_exception;
343: END IF;
344:
345: IF PG_DEBUG in ('Y', 'C') THEN
346: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_currency_code (-)');
347: END IF;
348:
349: EXCEPTION
350: WHEN OTHERS THEN

Line 352: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_currency_code');

348:
349: EXCEPTION
350: WHEN OTHERS THEN
351: IF PG_DEBUG in ('Y', 'C') THEN
352: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_currency_code');
353: END IF;
354: RAISE;
355:
356: END validate_currency_code;

Line 415: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_receipt_method (+)');

411:
412: BEGIN
413:
414: IF PG_DEBUG in ('Y', 'C') THEN
415: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_receipt_method (+)');
416: END IF;
417:
418: OPEN Receipt_method;
419: FETCH Receipt_method INTO l_receipt_inherit_inv_num_flag, l_receipt_name;

Line 468: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_receipt_method (-)');

464: APP_EXCEPTION.raise_exception;
465: END IF;
466:
467: IF PG_DEBUG in ('Y', 'C') THEN
468: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_receipt_method (-)');
469: END IF;
470:
471: EXCEPTION
472:

Line 475: arp_util.debug('exception NO_DATA_FOUND in ARP_BR_REMIT_BATCHES.validate_receipt_method');

471: EXCEPTION
472:
473: WHEN NO_DATA_FOUND THEN
474: IF PG_DEBUG in ('Y', 'C') THEN
475: arp_util.debug('exception NO_DATA_FOUND in ARP_BR_REMIT_BATCHES.validate_receipt_method');
476: END IF;
477: FND_MESSAGE.set_name('AR','AR_BR_INVALID_RECEIPT_METHOD');
478:
479: IF Receipt_method%ISOPEN THEN

Line 487: arp_util.debug('Unhandled exception in ARP_BR_REMIT_BATCHES.validate_receipt_method');

483: RAISE;
484:
485: WHEN OTHERS THEN
486: IF PG_DEBUG in ('Y', 'C') THEN
487: arp_util.debug('Unhandled exception in ARP_BR_REMIT_BATCHES.validate_receipt_method');
488: arp_util.debug('validate_receipt_method: ' || 'Return status :'||l_doc_seq_ret_stat||' for the receipt method '||l_receipt_name);
489: END IF;
490:
491: IF Receipt_method%ISOPEN THEN

Line 529: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_branch (+)');

525:
526: BEGIN
527:
528: IF PG_DEBUG in ('Y', 'C') THEN
529: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_branch (+)');
530: END IF;
531:
532: SELECT COUNT(*)
533: INTO NB

Line 544: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_branch (-)');

540: APP_EXCEPTION.raise_exception;
541: END IF;
542:
543: IF PG_DEBUG in ('Y', 'C') THEN
544: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_branch (-)');
545: END IF;
546:
547: EXCEPTION
548: WHEN OTHERS THEN

Line 550: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_remit_bank_branch');

546:
547: EXCEPTION
548: WHEN OTHERS THEN
549: IF PG_DEBUG in ('Y', 'C') THEN
550: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_remit_bank_branch');
551: END IF;
552: RAISE;
553:
554: END validate_remit_bank_branch;

Line 595: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_account (+)');

591:
592: BEGIN
593:
594: IF PG_DEBUG in ('Y', 'C') THEN
595: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_account (+)');
596: END IF;
597:
598: OPEN accounts(p_remittance_bank_account_id, p_batch_date);
599: FETCH accounts INTO nb;

Line 608: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_account (-)');

604: APP_EXCEPTION.raise_exception;
605: END IF;
606:
607: IF PG_DEBUG in ('Y', 'C') THEN
608: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_account (-)');
609: END IF;
610:
611: EXCEPTION
612: WHEN OTHERS THEN

Line 614: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_remit_bank_account');

610:
611: EXCEPTION
612: WHEN OTHERS THEN
613: IF PG_DEBUG in ('Y', 'C') THEN
614: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_remit_bank_account');
615: END IF;
616: RAISE;
617:
618: END validate_remit_bank_account;

Line 649: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_method_code (+)');

645:
646: BEGIN
647:
648: IF PG_DEBUG in ('Y', 'C') THEN
649: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_method_code (+)');
650: END IF;
651:
652: -- the with recourse flag must be 'N' with the remittance method Standard
653: IF (p_remit_method_code = 'STANDARD' AND p_with_recourse_flag = 'Y') THEN

Line 659: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_method_code (-)');

655: APP_EXCEPTION.raise_exception;
656: END IF;
657:
658: IF PG_DEBUG in ('Y', 'C') THEN
659: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_method_code (-)');
660: END IF;
661:
662: EXCEPTION
663: WHEN OTHERS THEN

Line 665: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_remit_method_code');

661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: IF PG_DEBUG in ('Y', 'C') THEN
665: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_remit_method_code');
666: END IF;
667: RAISE;
668:
669: END validate_remit_method_code;

Line 701: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_auto_program (+)');

697:
698: BEGIN
699:
700: IF PG_DEBUG in ('Y', 'C') THEN
701: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_auto_program (+)');
702: END IF;
703:
704: IF p_auto_trans_program_id IS NOT NULL THEN
705:

Line 720: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_auto_program (-)');

716:
717: END IF;
718:
719: IF PG_DEBUG in ('Y', 'C') THEN
720: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_auto_program (-)');
721: END IF;
722:
723: EXCEPTION
724: WHEN OTHERS THEN

Line 726: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_auto_program');

722:
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF PG_DEBUG in ('Y', 'C') THEN
726: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_auto_program');
727: END IF;
728: RAISE;
729:
730: END validate_auto_program;

Line 770: arp_standard.debug('EXCEPTION: ARP_BR_REMIT_BATCHES.delete_remit');

766:
767: EXCEPTION
768: WHEN OTHERS THEN
769: IF PG_DEBUG in ('Y', 'C') THEN
770: arp_standard.debug('EXCEPTION: ARP_BR_REMIT_BATCHES.delete_remit');
771: END IF;
772: RAISE;
773: END delete_remit;
774:

Line 829: arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (+)');

825:
826: BEGIN
827:
828: IF PG_DEBUG in ('Y', 'C') THEN
829: arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (+)');
830: END IF;
831:
832: SAVEPOINT update_remit_PVT;
833:

Line 870: arp_br_remit_batches.validate_args_update_remit(l_batch_rec);

866:
867: ------------------------------------------
868: -- Validation
869: ------------------------------------------
870: arp_br_remit_batches.validate_args_update_remit(l_batch_rec);
871:
872: ------------------------------------------
873: -- Call update table handler
874: ------------------------------------------

Line 878: arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (-)');

874: ------------------------------------------
875: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
876:
877: IF PG_DEBUG in ('Y', 'C') THEN
878: arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (-)');
879: END IF;
880:
881: EXCEPTION
882:

Line 885: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.update_remit');

881: EXCEPTION
882:
883: WHEN FND_API.G_EXC_ERROR THEN
884: IF PG_DEBUG in ('Y', 'C') THEN
885: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
886: END IF;
887: x_return_status := FND_API.G_RET_STS_ERROR;
888: ROLLBACK TO update_remit_PVT;
889:

Line 892: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.update_remit');

888: ROLLBACK TO update_remit_PVT;
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: IF PG_DEBUG in ('Y', 'C') THEN
892: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
893: END IF;
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: ROLLBACK TO update_remit_PVT;
896:

Line 899: arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.update_remit');

895: ROLLBACK TO update_remit_PVT;
896:
897: WHEN OTHERS THEN
898: IF PG_DEBUG in ('Y', 'C') THEN
899: arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.update_remit');
900: arp_util.debug('update_remit: ' || SQLERRM);
901: END IF;
902: ROLLBACK TO update_remit_PVT;
903: IF (SQLCODE = -20001) THEN

Line 944: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (+)');

940:
941: BEGIN
942:
943: IF PG_DEBUG in ('Y', 'C') THEN
944: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (+)');
945: END IF;
946:
947: -- Check that the main columns are filled
948: IF (p_batch_rec.type IS NULL) THEN

Line 977: arp_br_remit_batches.validate_currency_code(p_batch_rec.currency_code,p_batch_rec.batch_date);

973: -- Check that the gl date is valid
974: arp_util.validate_gl_date(p_batch_rec.gl_date, NULL, NULL);
975:
976: -- Check that the currency is valid
977: arp_br_remit_batches.validate_currency_code(p_batch_rec.currency_code,p_batch_rec.batch_date);
978:
979: -- Check that the receipt method is valid
980: arp_br_remit_batches.validate_receipt_method(p_batch_rec.receipt_method_id, p_batch_rec.batch_date);
981:

Line 980: arp_br_remit_batches.validate_receipt_method(p_batch_rec.receipt_method_id, p_batch_rec.batch_date);

976: -- Check that the currency is valid
977: arp_br_remit_batches.validate_currency_code(p_batch_rec.currency_code,p_batch_rec.batch_date);
978:
979: -- Check that the receipt method is valid
980: arp_br_remit_batches.validate_receipt_method(p_batch_rec.receipt_method_id, p_batch_rec.batch_date);
981:
982: -- Check that the remittance bank branch is valid
983: arp_br_remit_batches.validate_remit_bank_branch(p_batch_rec.remittance_bank_branch_id,p_batch_rec.batch_date);
984:

Line 983: arp_br_remit_batches.validate_remit_bank_branch(p_batch_rec.remittance_bank_branch_id,p_batch_rec.batch_date);

979: -- Check that the receipt method is valid
980: arp_br_remit_batches.validate_receipt_method(p_batch_rec.receipt_method_id, p_batch_rec.batch_date);
981:
982: -- Check that the remittance bank branch is valid
983: arp_br_remit_batches.validate_remit_bank_branch(p_batch_rec.remittance_bank_branch_id,p_batch_rec.batch_date);
984:
985: -- Check that the remittance account is valid
986: arp_br_remit_batches.validate_remit_bank_account(p_batch_rec.remit_bank_acct_use_id,p_batch_rec.batch_date);
987:

Line 986: arp_br_remit_batches.validate_remit_bank_account(p_batch_rec.remit_bank_acct_use_id,p_batch_rec.batch_date);

982: -- Check that the remittance bank branch is valid
983: arp_br_remit_batches.validate_remit_bank_branch(p_batch_rec.remittance_bank_branch_id,p_batch_rec.batch_date);
984:
985: -- Check that the remittance account is valid
986: arp_br_remit_batches.validate_remit_bank_account(p_batch_rec.remit_bank_acct_use_id,p_batch_rec.batch_date);
987:
988: -- Check that the remittance method and the flag with_recouse are consistent
989: arp_br_remit_batches.validate_remit_method_code(p_batch_rec.remit_method_code,p_batch_rec.with_recourse_flag);
990:

Line 989: arp_br_remit_batches.validate_remit_method_code(p_batch_rec.remit_method_code,p_batch_rec.with_recourse_flag);

985: -- Check that the remittance account is valid
986: arp_br_remit_batches.validate_remit_bank_account(p_batch_rec.remit_bank_acct_use_id,p_batch_rec.batch_date);
987:
988: -- Check that the remittance method and the flag with_recouse are consistent
989: arp_br_remit_batches.validate_remit_method_code(p_batch_rec.remit_method_code,p_batch_rec.with_recourse_flag);
990:
991: -- Check that the format program is a type 'REMIT_TRANSMIT' program
992: arp_br_remit_batches.validate_auto_program(p_batch_rec.auto_trans_program_id);
993:

Line 992: arp_br_remit_batches.validate_auto_program(p_batch_rec.auto_trans_program_id);

988: -- Check that the remittance method and the flag with_recouse are consistent
989: arp_br_remit_batches.validate_remit_method_code(p_batch_rec.remit_method_code,p_batch_rec.with_recourse_flag);
990:
991: -- Check that the format program is a type 'REMIT_TRANSMIT' program
992: arp_br_remit_batches.validate_auto_program(p_batch_rec.auto_trans_program_id);
993:
994: IF PG_DEBUG in ('Y', 'C') THEN
995: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (-)');
996: END IF;

Line 995: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (-)');

991: -- Check that the format program is a type 'REMIT_TRANSMIT' program
992: arp_br_remit_batches.validate_auto_program(p_batch_rec.auto_trans_program_id);
993:
994: IF PG_DEBUG in ('Y', 'C') THEN
995: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (-)');
996: END IF;
997:
998: EXCEPTION
999: WHEN OTHERS THEN

Line 1001: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_args_update_remit');

997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: IF PG_DEBUG in ('Y', 'C') THEN
1001: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_args_update_remit');
1002: END IF;
1003: RAISE;
1004:
1005: END validate_args_update_remit;

Line 1048: arp_util.debug('ARP_BR_REMIT_BATCHES.cancel_remit (+)');

1044:
1045: BEGIN
1046:
1047: IF PG_DEBUG in ('Y', 'C') THEN
1048: arp_util.debug('ARP_BR_REMIT_BATCHES.cancel_remit (+)');
1049: END IF;
1050:
1051: -- fetch and lock of the batch row
1052: l_batch_rec.batch_id := p_batch_id;

Line 1081: arp_util.debug('ARP_BR_REMIT_BATCHES.cancel_remit (-)');

1077:
1078: p_batch_applied_status := l_batch_rec.batch_applied_status;
1079:
1080: IF PG_DEBUG in ('Y', 'C') THEN
1081: arp_util.debug('ARP_BR_REMIT_BATCHES.cancel_remit (-)');
1082: END IF;
1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN

Line 1087: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.cancel_remit');

1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: IF PG_DEBUG in ('Y', 'C') THEN
1087: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.cancel_remit');
1088: END IF;
1089:
1090: IF cur_br%ISOPEN THEN
1091: CLOSE cur_br;

Line 1169: arp_util.debug('ARP_BR_REMIT_BATCHES.lock_remit (+)');

1165:
1166: BEGIN
1167:
1168: IF PG_DEBUG in ('Y', 'C') THEN
1169: arp_util.debug('ARP_BR_REMIT_BATCHES.lock_remit (+)');
1170: END IF;
1171:
1172: SAVEPOINT lock_remit_PVT;
1173:

Line 1258: arp_util.debug('ARP_BR_REMIT_BATCHES.lock_remit (-)');

1254: l_batch_rec.bank_deposit_number);
1255:
1256:
1257: IF PG_DEBUG in ('Y', 'C') THEN
1258: arp_util.debug('ARP_BR_REMIT_BATCHES.lock_remit (-)');
1259: END IF;
1260:
1261: EXCEPTION
1262:

Line 1265: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');

1261: EXCEPTION
1262:
1263: WHEN FND_API.G_EXC_ERROR THEN
1264: IF PG_DEBUG in ('Y', 'C') THEN
1265: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1266: END IF;
1267: x_return_status := FND_API.G_RET_STS_ERROR;
1268: ROLLBACK TO lock_remit_PVT;
1269:

Line 1272: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');

1268: ROLLBACK TO lock_remit_PVT;
1269:
1270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1271: IF PG_DEBUG in ('Y', 'C') THEN
1272: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1273: END IF;
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1275: ROLLBACK TO lock_remit_PVT;
1276:

Line 1279: arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.lock_remit');

1275: ROLLBACK TO lock_remit_PVT;
1276:
1277: WHEN OTHERS THEN
1278: IF PG_DEBUG in ('Y', 'C') THEN
1279: arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.lock_remit');
1280: arp_util.debug('lock_remit: ' || SQLERRM);
1281: END IF;
1282: ROLLBACK TO lock_remit_PVT;
1283: IF (SQLCODE = -20001) THEN

Line 1336: arp_standard.debug('arp_br_remit_batches.update_br_remit_batch_to_crh()+');

1332: l_crh_id ar_cash_receipt_history.cash_Receipt_history_id%TYPE;
1333:
1334: BEGIN
1335: IF PG_DEBUG in ('Y', 'C') THEN
1336: arp_standard.debug('arp_br_remit_batches.update_br_remit_batch_to_crh()+');
1337: END IF;
1338:
1339: /*--------------------------------------------+
1340: | If either of the parameters is null, skip |

Line 1383: arp_standard.debug('arp_br_remit_batches.update_br_remit_batch_to_crh()-');

1379: receipt_rec.cash_receipt_history_id);
1380: END IF;
1381:
1382: IF PG_DEBUG in ('Y', 'C') THEN
1383: arp_standard.debug('arp_br_remit_batches.update_br_remit_batch_to_crh()-');
1384: END IF;
1385:
1386: EXCEPTION
1387: WHEN OTHERS THEN

Line 1389: arp_util.debug('EXCEPTION: arp_br_remit_batches.update_br_remit_batch_to_crh');

1385:
1386: EXCEPTION
1387: WHEN OTHERS THEN
1388: IF PG_DEBUG in ('Y', 'C') THEN
1389: arp_util.debug('EXCEPTION: arp_br_remit_batches.update_br_remit_batch_to_crh');
1390: END IF;
1391:
1392: IF receipt_cur%ISOPEN THEN
1393: CLOSE receipt_cur;

Line 1423: END ARP_BR_REMIT_BATCHES;

1419: --
1420:
1421:
1422:
1423: END ARP_BR_REMIT_BATCHES;
1424: --