'Eye of Fire' in Mexican Waters Snuffed Out, National Oil Company Says