2143: IF (lock_csr%ISOPEN) THEN
2144: CLOSE lock_csr;
2145: END IF;
2146: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
2147: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
2148: END;
2149:
2150: IF ( l_row_notfound ) THEN
2151: OPEN lchk_csr(p_xpi_rec);
2243: IF (lock_csr%ISOPEN) THEN
2244: CLOSE lock_csr;
2245: END IF;
2246: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
2247: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
2248: END;
2249:
2250: IF ( l_row_notfound ) THEN
2251: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);