Tabular Forms - Expert Oracle Application Express - page 180

apex application.g f04 (i),
apex application.g f05 (i),
apex application.g f06 (i),
apex application.g f07 (i),
apex application.g f08 (i),
apex application.g f09 (i)
);
v ins count := v ins count + 1;
END IF;
EXCEPTION
WHEN OTHERS
THEN
p message := p message || SQLERRM;
END;
END LOOP;
IF v ins count > 0 OR v upd count > 0
THEN
p message :=
p message
|| v ins count
|| ' row(s) inserted. '
|| v upd count
|| ' row(s) updated.';
END IF;
EXCEPTION
WHEN OTHERS
THEN
p message := SQLERRM;
END save emp custom;
FUNCTION validate emp comm
RETURN VARCHAR2
IS
v message VARCHAR2 (4000);
BEGIN
FOR i IN 1 .. apex application.g f02.COUNT
LOOP
IF apex application.g f09 (i) <> 30
AND apex application.g f08 (i) IS NOT NULL
THEN
v message :=
v message
|| '<br/>'
|| 'Commission is allowed for the sales department only.'
|| ' (Row '
|| i
|| ')';
END IF;
END LOOP;