This will loop through the records in column 4 and check the amount. If it is greater than 100, an error message is generated displaying the row with the error. This will stop the process on the first error. If there are no errors NULL is returned which indicates that the validation test has passed.
BEGIN FOR i IN 1..APEX_APPLICATION.G_F01.COUNT LOOP IF TO_NUMBER(APEX_APPLICATION.G_F04(i)) > 100 THEN RETURN 'Item ' || TO_CHAR(i) || ' - DEPTSAL must not be greater than 100'; END IF; END LOOP; RETURN NULL; END;