1590: WHEN NO_DATA_FOUND THEN
1591: cep_standard.debug('Transaction Either Deleted OR Reconciled');
1592: CE_AUTO_BANK_MATCH.close_cursors;
1593: RAISE NO_DATA_FOUND;
1594: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1595: cep_standard.debug('Could not lock transactions');
1596: CE_AUTO_BANK_MATCH.close_cursors;
1597: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1598: END lock_transaction;
1593: RAISE NO_DATA_FOUND;
1594: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1595: cep_standard.debug('Could not lock transactions');
1596: CE_AUTO_BANK_MATCH.close_cursors;
1597: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1598: END lock_transaction;
1599:
1600: /* ---------------------------------------------------------------------
1601: | PRIVATE PROCEDURE |
3862: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3863: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3864: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3865: 'CE_TRX_RECONCILED');
3866: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3867: cep_standard.debug('ERROR#13: CE_TRX_BUSY');
3868: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3869: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3870: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6950: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_MATCH.match_engine-no_data_found');
6951: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6952: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6953: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_ABR_INFO_MISSING');
6954: WHEN app_exception.application_exception THEN
6955: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_MATCH.match_engine-application_exception');
6956: l_encoded_message := FND_MESSAGE.GET_ENCODED;
6957: IF (l_encoded_message IS NOT NULL)
6958: THEN
6998: cep_standard.debug('<
7000: RETURN(TRUE);
7001: EXCEPTION
7002: WHEN APP_EXCEPTIONS.record_lock_exception THEN
7003: return(FALSE);
7004: WHEN OTHERS THEN
7005: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_MATCH.lock_statement' );
7006: RAISE;
7064: cep_standard.debug('<
7066:
7067: EXCEPTION
7068: WHEN APP_EXCEPTIONS.record_lock_exception THEN
7069: return(FALSE);
7070: WHEN OTHERS THEN
7071: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_MATCH.lock_statement_line' );
7072: RAISE;