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:
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 |
1354: | Current cash receipt history record cannot be |
1355: | found, raise an error. |
1356: +------------------------------------------------*/
1357: IF PG_DEBUG in ('Y', 'C') THEN
1358: arp_standard.debug('update_br_remit_batch_to_crh: ' || 'current receipt history record cannot be found cr_id = '||to_char(p_cr_id));
1359: END IF;
1360: CLOSE receipt_cur;
1361: APP_EXCEPTION.raise_exception;
1362:
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