I don't understand much of French, but I can tell you that what you are trying to do is 99% possible to achieve in a single insert statement without any loop.

Error clearly tells you, that one of the string value you generating cannot be converted to datetime.

If you could provide requirements of what you are trying to do in your proc, we might be able to help you better.