How to determine if insert or update
Since it's only UPDATE,INSERT you can say:

IF EXISTS (SELECT 1 FROM deleted)
  -- update
ELSE
  -- insert


You have a bigger problem, though. There is no such thing as new.Id, and an insert or update can affect multiple rows (in some platforms, triggers fire per row; in SQL Server, they fire per operation). So you need to either:


Use a loop to call the stored procedure for all of the RecordId values in inserted.
Stop using a stored procedure for this and perform whatever logic it does inside the trigger, as a set-based operation.