[Home] [Help]
11: if hr_general.g_data_migrator_mode <> 'Y' then
12: -- if context used in a formula, fail
13: -- Pass null bus grp and leg code so all formulae are considered
14: if (ffdict.is_used_in_formula(:OLD.context_name, null,null)) then
15: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
16: hr_utility.set_message_token('1',:OLD.context_name);
17: hr_utility.raise_error;
18: end if;
19: -- All other context usages picked up by referential constraints
12: -- if context used in a formula, fail
13: -- Pass null bus grp and leg code so all formulae are considered
14: if (ffdict.is_used_in_formula(:OLD.context_name, null,null)) then
15: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
16: hr_utility.set_message_token('1',:OLD.context_name);
17: hr_utility.raise_error;
18: end if;
19: -- All other context usages picked up by referential constraints
20: end if;
13: -- Pass null bus grp and leg code so all formulae are considered
14: if (ffdict.is_used_in_formula(:OLD.context_name, null,null)) then
15: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
16: hr_utility.set_message_token('1',:OLD.context_name);
17: hr_utility.raise_error;
18: end if;
19: -- All other context usages picked up by referential constraints
20: end if;
21: end ff_contexts_brd;