1575: WHEN NO_DATA_FOUND THEN
1576: cep_standard.debug('Transaction Either Deleted OR Reconciled');
1577: CE_AUTO_BANK_MATCH.close_cursors;
1578: RAISE NO_DATA_FOUND;
1579: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1580: cep_standard.debug('Could not lock transactions');
1581: CE_AUTO_BANK_MATCH.close_cursors;
1582: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1583: END lock_transaction;
1578: RAISE NO_DATA_FOUND;
1579: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1580: cep_standard.debug('Could not lock transactions');
1581: CE_AUTO_BANK_MATCH.close_cursors;
1582: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1583: END lock_transaction;
1584:
1585: /* ---------------------------------------------------------------------
1586: | PRIVATE PROCEDURE |
3742: WHEN NO_DATA_FOUND THEN
3743: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3744: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3745: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TRX_RECONCILED');
3746: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3747: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3748: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3749: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TRX_BUSY');
3750: WHEN OTHERS THEN
6803: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,
6804: release_on_commit );
6805: IF (lock_status <> 0) THEN
6806: lock_status := dbms_lock.release(lockhandle);
6807: RAISE APP_EXCEPTIONS.record_lock_exception;
6808: END IF;
6809: cep_standard.debug('<
6811: EXCEPTION
6808: END IF;
6809: cep_standard.debug('<
6811: EXCEPTION
6812: WHEN APP_EXCEPTIONS.record_lock_exception THEN
6813: return(FALSE);
6814: WHEN OTHERS THEN
6815: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_MATCH.lock_statement' );
6816: RAISE;
6875: cep_standard.debug('<
6877:
6878: EXCEPTION
6879: WHEN APP_EXCEPTIONS.record_lock_exception THEN
6880: return(FALSE);
6881: WHEN OTHERS THEN
6882: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_MATCH.lock_statement_line' );
6883: RAISE;