Revisit logging of date parsing errors

[ghukill]

Two immediate things come to mind when it comes to parsing / validating dates with validate_date, validate_date_range, etc.:

1. we are forced to pull the source_record_id to pass it to the function, such that it can maybe be used for logging
2. how helpful are the log messages themselves?

It has been discussed here and there, but probably worth revisiting these helper functions and think about how we can more seamlessly use them in code.