Hello Naveen Lotti,
This has probably to do with the subtransactions that mendix can do:
please see also this learning path:
https://academy.mendix.com/link/modules/172/Transaction-Characteristics
In there is this snippet:
In Mendix, sub transactions are applied on each:
Commit action (including a single or multiple objects)
Action having an error handling behavior Custom without rollback
Hope this helps,
Good luck!