199: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,
200: release_on_commit );
201: IF (lock_status <> 0) THEN
202: lock_status := dbms_lock.release(lockhandle);
203: RAISE APP_EXCEPTIONS.record_lock_exception;
204: END IF;
205: cep_standard.debug('<
207: EXCEPTION
204: END IF;
205: cep_standard.debug('<
207: EXCEPTION
208: WHEN APP_EXCEPTIONS.record_lock_exception THEN
209: return(FALSE);
210: WHEN OTHERS THEN
211: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement' );
212: RAISE;
261: cep_standard.debug('<
263:
264: EXCEPTION
265: WHEN APP_EXCEPTIONS.record_lock_exception THEN
266: return(FALSE);
267: WHEN OTHERS THEN
268: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement_line' );
269: RAISE;