Enhance sample pack deletion process with detailed logging and error handling

Commit notes

- Added logging for generation jobs and sample files during deletion to improve traceability. - Implemented error handling for database operations related to sample and generation job deletions. - Ensured that deletion of sample files and cover images is logged, even if the delete operation fails.