Cannot insert the value NULL into column
I didn't take a really hard look at this but you're defining the DBName, UserName, and LoginType columns in @DB_USers as sysname. The type sysname is defined as NOT NULL.

What is SYSNAME data type in SQL Server? 

As to why you're getting a NULL value you're going to have to check the dataset you're running against.