[Home] [Help]
165: -- set error tracking information
166: hr_utility.set_location('ffdict.will_clash_with_formula',1);
167: --
168: -- get startup_mode based on current business group and legislation
169: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
170: --
171: -- Ensure name does not clash with anywhere which will be able to 'see' the
172: -- formula being validated.
173: --
221: -- set error tracking information
222: hr_utility.set_location('ffdict.is_used_in_formula',1);
223: --
224: -- get startup_mode based on current business group and legislation
225: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
226: --
227: -- set error tracking information
228: hr_utility.set_location('ffdict.is_used_in_formula',2);
229: -- Check if there any rows in FDIU for this item but take into account
301: if g_debug then
302: hr_utility.set_location('ffdict.dbitl_used_in_formula',2);
303: end if;
304:
305: startup_mode := ffstup.get_mode(tmp_bg_id, tmp_leg_code);
306:
307: --
308: -- Check if there any rows in FDIU for this item but take into account
309: -- the business group of the formula
480: if (tmp_ue_id is null or tmp_ue_id <> p_user_entity_id) then
481: fetch_ue_details(p_user_entity_id);
482: end if;
483:
484: l_startup_mode := ffstup.get_mode(tmp_bg_id, tmp_leg_code);
485:
486: if g_debug then
487: hr_utility.set_location('ffdict.fetch_referencing_formulas',20);
488: hr_utility.trace('BG_ID: ' || tmp_bg_id || ' LEG_CODE: ' || tmp_leg_code);
561: if g_debug then
562: hr_utility.set_location('ffdict.dbi_used_in_formula',2);
563: end if;
564:
565: startup_mode := ffstup.get_mode(tmp_bg_id, tmp_leg_code);
566:
567: --
568: -- Check if there any rows in FDIU for this item but take into account
569: -- the business group of the formula
653: if g_debug then
654: hr_utility.set_location('ffdict.non_dbi_used_in_formula',1);
655: end if;
656:
657: startup_mode := ffstup.get_mode(p_bus_grp, p_leg_code);
658:
659: --
660: -- Check if there any rows in FDIU for this item but take into account
661: -- the business group of the formula.
736: -- set error tracking information
737: hr_utility.set_location('ffdict.will_clash_with_dbitem',1);
738: --
739: -- get startup_mode based on current business group and legislation
740: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
741:
742: --
743: -- Ensure name does not clash with anywhere which will be able to 'see' the
744: -- database item being validated.
867: --
868: -- Get startup_mode based on current business group and legislation.
869: --
870: startup_mode :=
871: ffstup.get_mode(p_business_group_id, p_legislation_code);
872:
873: begin
874: --
875: -- Check for clash with other FF_DATABASE_ITEMS rows.
996: -- set error tracking information
997: hr_utility.set_location('ffdict.will_clash_with_global',1);
998: --
999: -- get startup_mode based on current business group and legislation
1000: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
1001: --
1002: -- Ensure name does not clash with anywhere which will be able to 'see' the
1003: -- formula being validated.
1004: --
1103: hr_utility.set_location('ffdict.will_clash_with_global:2',1);
1104: end if;
1105: --
1106: -- get startup_mode based on current business group and legislation
1107: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
1108: --
1109: -- Ensure name does not clash with anywhere which will be able to 'see' the
1110: -- formula being validated.
1111: --
1214: -- set error tracking information
1215: hr_utility.set_location('ffdict.will_clash_with_entity',1);
1216: --
1217: -- get startup_mode based on current business group and legislation
1218: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
1219: --
1220: -- Ensure name does not clash with anywhere which will be able to 'see' the
1221: -- formula being validated.
1222: --
1284: -- set error tracking information
1285: hr_utility.set_location('ffdict.will_clash_with_function',1);
1286: --
1287: -- get startup_mode based on current business group and legislation
1288: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
1289: --
1290: -- Check for functions which have same name as p_item_name and class of 'U'
1291: -- or functions which have alias the same as p_item_name
1292: -- within the business group criteria
1511: --
1512: -- set error tracking information
1513: hr_utility.set_location('ffdict.validate_formula',2);
1514: --
1515: l_startup_mode := ffstup.get_mode(p_bus_grp,p_leg_code);
1516: --
1517: open csr_formula_clash(l_startup_mode);
1518: fetch csr_formula_clash into l_dummy;
1519: if csr_formula_clash%found then
2188: --
2189: -- set error tracking information
2190: hr_utility.set_location('ffdict.validate_rpv',2);
2191: -- get startup_mode based on current business group and legislation
2192: startup_mode := ffstup.get_mode (bg_id,leg_code);
2193: --
2194: -- set error tracking information
2195: hr_utility.set_location('ffdict.validate_rpv',3);
2196: -- Look for any compiled formulas which use database items based on this