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