Improve idp deletion error scenario for user defined federated authenticator

[Thisara-Welmilla]

Task issue:

• Provide API for the new custom authentication management #21216

The existing implementation deletes the associated action first and then deletes the Identity Provider (IDP) from the database. If an error occurs while deleting the IDP, a rollback mechanism adds the action back. However, the newly added action does not retain the original ID, causing inconsistencies.

To address this, we are changing the implementation to delete the IDP from the database first, followed by deleting the associated action. However, if an error occurs during the deletion of the action, it will result in a stale action remaining in the system. Added a warn for that.

[Thisara-Welmilla]

PRs:

• Improve idp deletion error scenario. carbon-identity-framework#6178