4: BEGIN
5: if(FND_FLEX_TRIGGER.delete_rule_line(:old.rule_line_id,
6: :old.application_id, :old.id_flex_code, :old.id_flex_num,
7: :old.include_exclude_indicator) = FALSE) then
8: FND_MESSAGE.RAISE_ERROR;
9: end if;
10:
11: EXCEPTION
12: when OTHERS then
10:
11: EXCEPTION
12: when OTHERS then
13: IF (SQLCODE = -20001) THEN
14: FND_MESSAGE.RAISE_ERROR;
15: ELSE
16: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
17: FND_MESSAGE.set_token('MSG', 'fnd_flex_val_rule_lines_t4() exception: '
18: || SQLERRM);
12: when OTHERS then
13: IF (SQLCODE = -20001) THEN
14: FND_MESSAGE.RAISE_ERROR;
15: ELSE
16: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
17: FND_MESSAGE.set_token('MSG', 'fnd_flex_val_rule_lines_t4() exception: '
18: || SQLERRM);
19: FND_MESSAGE.RAISE_ERROR;
20: END IF;
13: IF (SQLCODE = -20001) THEN
14: FND_MESSAGE.RAISE_ERROR;
15: ELSE
16: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
17: FND_MESSAGE.set_token('MSG', 'fnd_flex_val_rule_lines_t4() exception: '
18: || SQLERRM);
19: FND_MESSAGE.RAISE_ERROR;
20: END IF;
21: END;
15: ELSE
16: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
17: FND_MESSAGE.set_token('MSG', 'fnd_flex_val_rule_lines_t4() exception: '
18: || SQLERRM);
19: FND_MESSAGE.RAISE_ERROR;
20: END IF;
21: END;
22: