SQL Server insert statement runs successfully but values are not added to table even though row is created

I have an insert statement as below. I am able to debug my stored procedure and step through my code to verify that my code runs, but a funny thing happens. I have an insert statement as below. I am able