3: ON "APPS"."FND_FLEX_VALIDATION_RULES" FOR EACH ROW
4: BEGIN
5: if(FND_FLEX_TRIGGER.update_cvr_stats(:new.application_id,
6: :new.id_flex_code, :new.id_flex_num, 0, 0, 0) = FALSE) then
7: FND_MESSAGE.RAISE_ERROR;
8: end if;
9: EXCEPTION
10: when OTHERS then
11: IF (SQLCODE = -20001) THEN
8: end if;
9: EXCEPTION
10: when OTHERS then
11: IF (SQLCODE = -20001) THEN
12: FND_MESSAGE.RAISE_ERROR;
13: ELSE
14: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
15: FND_MESSAGE.set_token('MSG', 'fnd_flex_validation_rules_t2() exception: '
16: || SQLERRM);
10: when OTHERS then
11: IF (SQLCODE = -20001) THEN
12: FND_MESSAGE.RAISE_ERROR;
13: ELSE
14: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
15: FND_MESSAGE.set_token('MSG', 'fnd_flex_validation_rules_t2() exception: '
16: || SQLERRM);
17: FND_MESSAGE.RAISE_ERROR;
18: END IF;
11: IF (SQLCODE = -20001) THEN
12: FND_MESSAGE.RAISE_ERROR;
13: ELSE
14: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
15: FND_MESSAGE.set_token('MSG', 'fnd_flex_validation_rules_t2() exception: '
16: || SQLERRM);
17: FND_MESSAGE.RAISE_ERROR;
18: END IF;
19: END;
13: ELSE
14: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
15: FND_MESSAGE.set_token('MSG', 'fnd_flex_validation_rules_t2() exception: '
16: || SQLERRM);
17: FND_MESSAGE.RAISE_ERROR;
18: END IF;
19: END;
20: