DBA Data[Home] [Help]

APPS.ARP_BR_REMIT_BATCHES dependencies on ARP_UTIL

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 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 260: arp_util.validate_gl_date(p_batch_rec.gl_date, NULL, NULL);

256: NULL,
257: NULL);
258:
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:

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 431: arp_util.debug('validate_receipt_method: ' || 'the flag l_receipt_inherit_inv_num_flag is Y');

427:
428: -- IS the receipt method flag receipt_inherit_inv_num_flag set to 'Y' ?
429: IF (l_receipt_inherit_inv_num_flag = 'Y') THEN
430: IF PG_DEBUG in ('Y', 'C') THEN
431: arp_util.debug('validate_receipt_method: ' || 'the flag l_receipt_inherit_inv_num_flag is Y');
432: END IF;
433: return;
434: END IF;
435:

Line 454: arp_util.debug('validate_receipt_method: ' || 'Return status :'||l_doc_seq_ret_stat||' for the receipt method '||l_receipt_name);

450: suppress_error=>'N' ,
451: suppress_warn=>'Y');
452:
453: IF PG_DEBUG in ('Y', 'C') THEN
454: arp_util.debug('validate_receipt_method: ' || 'Return status :'||l_doc_seq_ret_stat||' for the receipt method '||l_receipt_name);
455: END IF;
456:
457: /* If the function returns 'partially used but not assigned' return the exception
458: AR_RAPI_DOC_SEQ_NOT_EXIST_P

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 488: arp_util.debug('validate_receipt_method: ' || 'Return status :'||l_doc_seq_ret_stat||' for the receipt method '||l_receipt_name);

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
492: CLOSE Receipt_method;

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 787: arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (+)');

783:
784: BEGIN
785:
786: IF PG_DEBUG in ('Y', 'C') THEN
787: arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (+)');
788: END IF;
789:
790: SAVEPOINT update_remit_PVT;
791:

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

832: ------------------------------------------
833: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
834:
835: IF PG_DEBUG in ('Y', 'C') THEN
836: arp_util.debug('ARP_BR_REMIT_BATCHES.update_remit (-)');
837: END IF;
838:
839: EXCEPTION
840:

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

839: EXCEPTION
840:
841: WHEN FND_API.G_EXC_ERROR THEN
842: IF PG_DEBUG in ('Y', 'C') THEN
843: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
844: END IF;
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: ROLLBACK TO update_remit_PVT;
847:

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

846: ROLLBACK TO update_remit_PVT;
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: ROLLBACK TO update_remit_PVT;
854:

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

853: ROLLBACK TO update_remit_PVT;
854:
855: WHEN OTHERS THEN
856: IF PG_DEBUG in ('Y', 'C') THEN
857: arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.update_remit');
858: arp_util.debug('update_remit: ' || SQLERRM);
859: END IF;
860: ROLLBACK TO update_remit_PVT;
861: IF (SQLCODE = -20001) THEN

Line 858: arp_util.debug('update_remit: ' || SQLERRM);

854:
855: WHEN OTHERS THEN
856: IF PG_DEBUG in ('Y', 'C') THEN
857: arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.update_remit');
858: arp_util.debug('update_remit: ' || SQLERRM);
859: END IF;
860: ROLLBACK TO update_remit_PVT;
861: IF (SQLCODE = -20001) THEN
862: x_return_status := FND_API.G_RET_STS_ERROR;

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

898:
899: BEGIN
900:
901: IF PG_DEBUG in ('Y', 'C') THEN
902: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (+)');
903: END IF;
904:
905: -- Check that the main columns are filled
906: IF (p_batch_rec.type IS NULL) THEN

Line 932: arp_util.validate_gl_date(p_batch_rec.gl_date, NULL, NULL);

928: APP_EXCEPTION.raise_exception;
929: END IF;
930:
931: -- Check that the gl date is valid
932: arp_util.validate_gl_date(p_batch_rec.gl_date, NULL, NULL);
933:
934: -- Check that the currency is valid
935: arp_br_remit_batches.validate_currency_code(p_batch_rec.currency_code,p_batch_rec.batch_date);
936:

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

949: -- Check that the format program is a type 'REMIT_TRANSMIT' program
950: arp_br_remit_batches.validate_auto_program(p_batch_rec.auto_trans_program_id);
951:
952: IF PG_DEBUG in ('Y', 'C') THEN
953: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_args_update_remit (-)');
954: END IF;
955:
956: EXCEPTION
957: WHEN OTHERS THEN

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

955:
956: EXCEPTION
957: WHEN OTHERS THEN
958: IF PG_DEBUG in ('Y', 'C') THEN
959: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.validate_args_update_remit');
960: END IF;
961: RAISE;
962:
963: END validate_args_update_remit;

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

1002:
1003: BEGIN
1004:
1005: IF PG_DEBUG in ('Y', 'C') THEN
1006: arp_util.debug('ARP_BR_REMIT_BATCHES.cancel_remit (+)');
1007: END IF;
1008:
1009: -- fetch and lock of the batch row
1010: l_batch_rec.batch_id := p_batch_id;

Line 1020: arp_util.debug('cancel_remit: ' || 'BR '|| l_ps_id ||' removed from the remittance '||p_batch_id);

1016: LOOP
1017: FETCH cur_br INTO l_ps_id;
1018: EXIT WHEN cur_br%NOTFOUND;
1019: IF PG_DEBUG in ('Y', 'C') THEN
1020: arp_util.debug('cancel_remit: ' || 'BR '|| l_ps_id ||' removed from the remittance '||p_batch_id);
1021: END IF;
1022: AR_BILLS_MAINTAIN_PUB.Deselect_BR_Remit(l_ps_id,l_new_status);
1023: END LOOP;
1024:

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

1035:
1036: p_batch_applied_status := l_batch_rec.batch_applied_status;
1037:
1038: IF PG_DEBUG in ('Y', 'C') THEN
1039: arp_util.debug('ARP_BR_REMIT_BATCHES.cancel_remit (-)');
1040: END IF;
1041:
1042: EXCEPTION
1043: WHEN OTHERS THEN

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

1041:
1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: IF PG_DEBUG in ('Y', 'C') THEN
1045: arp_util.debug('EXCEPTION OTHERS: ARP_BR_REMIT_BATCHES.cancel_remit');
1046: END IF;
1047:
1048: IF cur_br%ISOPEN THEN
1049: CLOSE cur_br;

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

1123:
1124: BEGIN
1125:
1126: IF PG_DEBUG in ('Y', 'C') THEN
1127: arp_util.debug('ARP_BR_REMIT_BATCHES.lock_remit (+)');
1128: END IF;
1129:
1130: SAVEPOINT lock_remit_PVT;
1131:

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

1212: l_batch_rec.bank_deposit_number);
1213:
1214:
1215: IF PG_DEBUG in ('Y', 'C') THEN
1216: arp_util.debug('ARP_BR_REMIT_BATCHES.lock_remit (-)');
1217: END IF;
1218:
1219: EXCEPTION
1220:

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

1219: EXCEPTION
1220:
1221: WHEN FND_API.G_EXC_ERROR THEN
1222: IF PG_DEBUG in ('Y', 'C') THEN
1223: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: ROLLBACK TO lock_remit_PVT;
1227:

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

1226: ROLLBACK TO lock_remit_PVT;
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: IF PG_DEBUG in ('Y', 'C') THEN
1230: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1231: END IF;
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: ROLLBACK TO lock_remit_PVT;
1234:

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

1233: ROLLBACK TO lock_remit_PVT;
1234:
1235: WHEN OTHERS THEN
1236: IF PG_DEBUG in ('Y', 'C') THEN
1237: arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.lock_remit');
1238: arp_util.debug('lock_remit: ' || SQLERRM);
1239: END IF;
1240: ROLLBACK TO lock_remit_PVT;
1241: IF (SQLCODE = -20001) THEN

Line 1238: arp_util.debug('lock_remit: ' || SQLERRM);

1234:
1235: WHEN OTHERS THEN
1236: IF PG_DEBUG in ('Y', 'C') THEN
1237: arp_util.debug('EXCEPTION OTHERS:ARP_BR_REMIT_BATCHES.lock_remit');
1238: arp_util.debug('lock_remit: ' || SQLERRM);
1239: END IF;
1240: ROLLBACK TO lock_remit_PVT;
1241: IF (SQLCODE = -20001) THEN
1242: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1263: | arp_util.debug |

1259: | |
1260: | SCOPE - PUBLIC |
1261: | |
1262: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1263: | arp_util.debug |
1264: | |
1265: | ARGUMENTS : IN: p_cr_id Cash receipt id of the receipt to be updated |
1266: | p_batch_id Value to be updated |
1267: | OUT: |

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

1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: IF PG_DEBUG in ('Y', 'C') THEN
1347: arp_util.debug('EXCEPTION: arp_br_remit_batches.update_br_remit_batch_to_crh');
1348: END IF;
1349:
1350: IF receipt_cur%ISOPEN THEN
1351: CLOSE receipt_cur;