Are you sure you read that error correctly and it wasn't complaining about the organization CD being null?
I would just run the SELECT underlying the INSERT, so that you can check. I suspect something is failing one of the constraints.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?