Never.
Once you decide on a course of war, all of the AI players are going to hate your guts for at least 50 turns. Once you reconcile yourself to that fact, it's not much of a deterrent. Realistically, do you even care what a computer opponent "thinks" ?