Why don't you, instead of programming, just set that item's "Required" property to "Yes"?

hi
please update the code as

IF :REASON_CODE IS NULL THEN
MESSAGE ("Please enter a reason code!");
raise form_trigger_failure
else
null;
end if;

/* hope it will work*/

@LF - it's not a database item - different rules apply.

@reaz62 - it's not firing because non-database items start life with a valid property of true and this won't change until a value is entered. Database items in a new record start with a valid property of false.

The check needs to go somewhere else entirely. How are these non-db items being used in the form?

You can always use set_item_instance_property.
However - why is the item not a db item if you're inserting the value into the db?

   set_item_property('REASON',ITEM_IS_VALID,PROPERTY_FALSE) ;

   IF :REASON IS NULL then 
   Message ("reason code cannot be null!");
   END IF; 

Well, this field is basically a text field, where you input data to be inserted into another table, so its not really a db field.

This item has multiple records on the form, and I was reading that using the set_item_property should work for multiple records, instead of the set_item_instance_property. I used the below in the When-validate-item trigger of the REASONCODE item.

   set_item_property('REASON',ITEM_IS_VALID,PROPERTY_FALSE) ;

   IF :REASON IS NULL then 
   Message ("reason code cannot be null!");
   END IF; 

but this didn't work.
Did I put the trigger in the correct place?

Thanks