FuelPHP uses exceptions to signal errors, so if there is an error, an exception of a specific type is thrown.
In case of ORM most exceptions will come from the underlying DB classes. In case of a database error, \Database_Exception will be thrown, which will include both the message and the SQL engine error code.