Transactions are automatically supported - if you have an error Aware IM will automatically rollback a transaction. If you write a Java plug-in using Aware IM API the plug-in will also integrate nicely into the Aware IM transaction framework, so you don't have to worry about transactions in your custom plug-in.
Yes, Aware IM business rules and processes will cover 100% of creating records, updating tables, checking fields etc.
You need to read a few documents about Aware IM - this will give you a much better idea. There is some good information about rules, processes and transactions in the User Guide. There is also the Configuration Case Study document that explains in detail how to configure applications using Aware IM.
