IF V_ASSIGNMENT_TYPE IS NULL OR
V_ASSIGNMENT_CODE IS NULL OR
V_ASSIGNMENT_START_DATE IS NULL OR
V_ASSIGNMENT_STATUS IS NULL THEN
v_error := TRUE;
While these fields may not be mandatory, they are required for the record to be processed.