With regard to procurement legislation, does the mandatory exclusion apply to convictions for all offences?

No, mandatory exclusion only relates to serious financial offences. The crimes to which mandatory exclusion applies are listed in paragraph 1 of EC Regulation 23.