Merger talks between Honda and Nissan have collapsed after the firms failed to agree on a multi-billion dollar tie-up deal.