How to use RAISE and CRUD clauses in the same case trigger in SQLite

I recently had to build a trigger for the return management system for an eCommerce website. Essentially we had two tables: RETURN and RETURN_ITEM. I had to make a trigger on insert on RETURN_ITEM, which raises an error and deletes a RETURN entity. L...