Something some where is trying to put a value like ABC into a column which will only take a value like 123.

With such a large procedure, take it a chunk at a time and run it until you find the faulting part then fix the problem with the data.