Business advisors Ernst & Young say the prospects for foreign investment in Ireland in the long and medium term are better than some people are portraying.