Unable to start a nested transaction for OLE DB provider "SQLNCLI11" for linked server
As the error message suggests, add the following to your stored procedure:

SET XACT_ABORT ON;


See Distributed Queries and Distributed Transactions