The season-ending MotoGP race at the Valencia Grand Prix has been cancelled by organisers because of the catastrophic Spanish floods.