Document_source_writer in sharded enviromnent throws errors when the output collection is moved or dropped.

Based on the analysis from BF-34063, there seems to be an overlap in the error thrown for these two cases, however the two cases need different handling.

This ticket will ensure that the error handling is performed accordingly for each case, and introduce the corresponding tests.