DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on APP_EXCEPTIONS

Line 1579: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

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;

Line 1582: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;

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 |

Line 3746: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

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

Line 6807: RAISE APP_EXCEPTIONS.record_lock_exception;

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('< 6810: RETURN(TRUE);
6811: EXCEPTION

Line 6812: WHEN APP_EXCEPTIONS.record_lock_exception THEN

6808: END IF;
6809: cep_standard.debug('< 6810: RETURN(TRUE);
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;

Line 6879: WHEN APP_EXCEPTIONS.record_lock_exception THEN

6875: cep_standard.debug('< 6876: RETURN(TRUE);
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;