fnd_flex_validation_rules_t3
AFTER DELETE ON fnd_flex_validation_rules FOR EACH ROW
Type
AFTER EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
if(FND_FLEX_TRIGGER.update_cvr_stats(:old.application_id,
:old.id_flex_code, :old.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_t3() exception: '
|| SQLERRM);
FND_MESSAGE.RAISE_ERROR;
END IF;
END;