Fast Formula

m.calore

Hello,

I am looking for a FF that allow to check if a specific field is empty (in my case the field is Impianti). If this field is empty I would like to get an error

/********************************************************

FAST FORMULA

***********************************************************/

default for PJC_PROJECT_ID is 0

default for Impianti is 'Plant'

INPUTS ARE 

 PJC_PROJECT_ID (number),

Impianti (text)

ffs_id = GET_CONTEXT(HWM_FFS_ID, 0)

rule_id = GET_CONTEXT(HWM_RULE_ID, 0)

l_status = add_rlog (ffs_id , rule_id , 'XXCAP_VERIFY_PLANTS -VERSIONE 001.00001 ' )

l_msg = get_rvalue_text (rule_id ,'MESSAGE_CODE', 'XXCAP_IMPIANTO_OBBLIGATORIO')

pProjectId = get_rvalue_number (rule_id ,'PROGETTO', 0)

 l_status = add_rlog (ffs_id , rule_id , '(input: ' ||

 ' , l_msg =' || l_msg|| 

 ' ) ' )

IF ISNULL(Impianti)= 'Y' /*this condition doesn't work so I have inserted if Impianti<> 'plant' but if I don't populate the field in the timecard nothing happens*/

THEN ( l_msg = l_msg

OUT_MSG = get_output_msg ('FND' ,l_msg)

)

RETURN OUT_MSG

Do you have any advice?

Thank you

Mattia