The United Nations Security Council condemned North Korea's firing of a ballistic missile over Japan on Tuesday as an "outrageous" threat.