761: xtr_risk_debug_pkg.dpop('xtr_replicate_bank_accounts_P: '||'Modify_Bank_Accounts');
762: END IF;
763:
764: EXCEPTION
765: When app_exceptions.RECORD_LOCK_EXCEPTION then -- If the record is locked
766: if C_CHK_LOCK%ISOPEN then
767: close c_CHK_LOCK;
768: end if;
769: LOG_ERR_MSG('CHK_LOCK');
767: close c_CHK_LOCK;
768: end if;
769: LOG_ERR_MSG('CHK_LOCK');
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: --app_exceptions.RECORD_LOCK_EXCEPTION;
772: WHEN DUP_VAL_ON_INDEX then -- bug 4870353
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: LOG_ERR_MSG('XTR_UNIQUE_ACCOUNT');
775: WHEN others THEN
1048: ( p_count => x_msg_count ,
1049: p_data => x_msg_data
1050: );
1051: EXCEPTION
1052: When app_exceptions.RECORD_LOCK_EXCEPTION then -- If the record is locked
1053: if C_CHK_LOCK_INTEREST%ISOPEN then
1054: close c_CHK_LOCK_INTEREST;
1055: end if;
1056: LOG_ERR_MSG('CHK_LOCK');
1058: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1059: ( p_count => x_msg_count ,
1060: p_data => x_msg_data
1061: );
1062: --app_exceptions.RECORD_LOCK_EXCEPTION;
1063: WHEN others THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
1066: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error