fnd_flex_validation_rules_t1
AFTER INSERT ON fnd_flex_validation_rules FOR EACH ROW
Type
AFTER EACH ROW
Event
INSERT
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
if(FND_FLEX_TRIGGER.update_cvr_stats(:new.application_id,
:new.id_flex_code, :new.id_flex_num, 1, 0, 0) = FALSE) then
FND_MESSAGE.RAISE_ERROR;
end if;
EXCEPTION
when OTHERS then
IF (SQLCODE = -20001) THEN
FND_MESSAGE.RAISE_ERROR;
ELSE
FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
FND_MESSAGE.set_token('MSG', 'fnd_flex_validation_rules_t1() exception: '
|| SQLERRM);
FND_MESSAGE.RAISE_ERROR;
END IF;
END;