Better message in exception when conversion from period to timestamp fai...

Fix to issue https://github.com/pydata/pandas/issues/6780