Add logging to snippet create/update services

What does this MR do?

This MR adds logging when an error is raised during the service execution

Does this MR meet the acceptance criteria?

Conformity

• [ ] Changelog entry
• [ ] Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content