122: l_effective_start_date := p_effective_start_date;
123: l_effective_end_date := p_effective_end_date;
124: --
125: -- Enable multi-messaging
126: hr_multi_message.enable_message_list;
127: --
128: ffdict.validate_formula(
129: p_formula_name => l_formula_name,
130: p_formula_type_id => l_formula_type_id,
142: hr_utility.set_location('Leaving ff_formula_webui_pkg.validate_formula_name',20);
143: end if;
144: --
145: -- Get the return status and disable multi-messaging
146: p_return_status := hr_multi_message.get_return_status_disable;
147: --
148: exception
149: --
150: when hr_multi_message.error_message_exist then
146: p_return_status := hr_multi_message.get_return_status_disable;
147: --
148: exception
149: --
150: when hr_multi_message.error_message_exist then
151: p_return_status := hr_multi_message.get_return_status_disable;
152: --
153: when others then
154: hr_multi_message.add;
147: --
148: exception
149: --
150: when hr_multi_message.error_message_exist then
151: p_return_status := hr_multi_message.get_return_status_disable;
152: --
153: when others then
154: hr_multi_message.add;
155: p_return_status := hr_multi_message.get_return_status_disable;
150: when hr_multi_message.error_message_exist then
151: p_return_status := hr_multi_message.get_return_status_disable;
152: --
153: when others then
154: hr_multi_message.add;
155: p_return_status := hr_multi_message.get_return_status_disable;
156: --
157: end validate_formula_name;
158: --
151: p_return_status := hr_multi_message.get_return_status_disable;
152: --
153: when others then
154: hr_multi_message.add;
155: p_return_status := hr_multi_message.get_return_status_disable;
156: --
157: end validate_formula_name;
158: --
159: procedure insert_formula(
179: hr_utility.set_location('Entering ff_formula_webui_pkg.insert_formula',10);
180: end if;
181: --
182: -- Enable multi-messaging
183: hr_multi_message.enable_message_list;
184: --
185: ff_formulas_f_pkg.insert_row(
186: x_rowid => p_rowid,
187: x_formula_id => p_formula_id,
203: hr_utility.set_location('Leaving ff_formula_webui_pkg.insert_formula',20);
204: end if;
205: --
206: -- Get the return status and disable multi-messaging
207: p_return_status := hr_multi_message.get_return_status_disable;
208: --
209: exception
210: --
211: when hr_multi_message.error_message_exist then
207: p_return_status := hr_multi_message.get_return_status_disable;
208: --
209: exception
210: --
211: when hr_multi_message.error_message_exist then
212: p_return_status := hr_multi_message.get_return_status_disable;
213: --
214: when others then
215: hr_multi_message.add;
208: --
209: exception
210: --
211: when hr_multi_message.error_message_exist then
212: p_return_status := hr_multi_message.get_return_status_disable;
213: --
214: when others then
215: hr_multi_message.add;
216: p_return_status := hr_multi_message.get_return_status_disable;
211: when hr_multi_message.error_message_exist then
212: p_return_status := hr_multi_message.get_return_status_disable;
213: --
214: when others then
215: hr_multi_message.add;
216: p_return_status := hr_multi_message.get_return_status_disable;
217: --
218: end insert_formula;
219: --
212: p_return_status := hr_multi_message.get_return_status_disable;
213: --
214: when others then
215: hr_multi_message.add;
216: p_return_status := hr_multi_message.get_return_status_disable;
217: --
218: end insert_formula;
219: --
220: procedure update_formula(
240: hr_utility.set_location('Entering ff_formula_webui_pkg.update_formula',10);
241: end if;
242: --
243: -- Enable multi-messaging
244: hr_multi_message.enable_message_list;
245: --
246: ff_formulas_f_pkg.update_row(
247: x_rowid => p_rowid,
248: x_formula_id => p_formula_id,
263: hr_utility.set_location('Leaving ff_formula_webui_pkg.update_formula',20);
264: end if;
265: --
266: -- Get the return status and disable multi-messaging
267: p_return_status := hr_multi_message.get_return_status_disable;
268: --
269: exception
270: --
271: when hr_multi_message.error_message_exist then
267: p_return_status := hr_multi_message.get_return_status_disable;
268: --
269: exception
270: --
271: when hr_multi_message.error_message_exist then
272: p_return_status := hr_multi_message.get_return_status_disable;
273: --
274: when others then
275: hr_multi_message.add;
268: --
269: exception
270: --
271: when hr_multi_message.error_message_exist then
272: p_return_status := hr_multi_message.get_return_status_disable;
273: --
274: when others then
275: hr_multi_message.add;
276: p_return_status := hr_multi_message.get_return_status_disable;
271: when hr_multi_message.error_message_exist then
272: p_return_status := hr_multi_message.get_return_status_disable;
273: --
274: when others then
275: hr_multi_message.add;
276: p_return_status := hr_multi_message.get_return_status_disable;
277: --
278: end update_formula;
279: --
272: p_return_status := hr_multi_message.get_return_status_disable;
273: --
274: when others then
275: hr_multi_message.add;
276: p_return_status := hr_multi_message.get_return_status_disable;
277: --
278: end update_formula;
279: --
280: procedure delete_formula(
293: hr_utility.set_location('Entering ff_formula_webui_pkg.delete_formula',10);
294: end if;
295: --
296: -- Enable multi-messaging
297: hr_multi_message.enable_message_list;
298: --
299: ff_formulas_f_pkg.delete_row(
300: x_rowid => p_rowid,
301: x_formula_id => p_formula_id,
309: hr_utility.set_location('Leaving ff_formula_webui_pkg.delete_formula',20);
310: end if;
311: --
312: -- Get the return status and disable multi-messaging
313: p_return_status := hr_multi_message.get_return_status_disable;
314: --
315: exception
316: --
317: when hr_multi_message.error_message_exist then
313: p_return_status := hr_multi_message.get_return_status_disable;
314: --
315: exception
316: --
317: when hr_multi_message.error_message_exist then
318: p_return_status := hr_multi_message.get_return_status_disable;
319: --
320: when others then
321: hr_multi_message.add;
314: --
315: exception
316: --
317: when hr_multi_message.error_message_exist then
318: p_return_status := hr_multi_message.get_return_status_disable;
319: --
320: when others then
321: hr_multi_message.add;
322: p_return_status := hr_multi_message.get_return_status_disable;
317: when hr_multi_message.error_message_exist then
318: p_return_status := hr_multi_message.get_return_status_disable;
319: --
320: when others then
321: hr_multi_message.add;
322: p_return_status := hr_multi_message.get_return_status_disable;
323: --
324: end delete_formula;
325: --
318: p_return_status := hr_multi_message.get_return_status_disable;
319: --
320: when others then
321: hr_multi_message.add;
322: p_return_status := hr_multi_message.get_return_status_disable;
323: --
324: end delete_formula;
325: --
326: procedure lock_formula(
335: hr_utility.set_location('Entering ff_formula_webui_pkg.lock_formula',10);
336: end if;
337: --
338: -- Enable multi-messaging
339: hr_multi_message.enable_message_list;
340: --
341: ff_formulas_f_pkg.lock_row(
342: x_rowid => p_rowid,
343: x_last_update_date => p_last_update_date
347: hr_utility.set_location('Leaving ff_formula_webui_pkg.lock_formula',20);
348: end if;
349: --
350: -- Get the return status and disable multi-messaging
351: p_return_status := hr_multi_message.get_return_status_disable;
352: --
353: exception
354: --
355: when hr_multi_message.error_message_exist then
351: p_return_status := hr_multi_message.get_return_status_disable;
352: --
353: exception
354: --
355: when hr_multi_message.error_message_exist then
356: p_return_status := hr_multi_message.get_return_status_disable;
357: --
358: when others then
359: hr_multi_message.add;
352: --
353: exception
354: --
355: when hr_multi_message.error_message_exist then
356: p_return_status := hr_multi_message.get_return_status_disable;
357: --
358: when others then
359: hr_multi_message.add;
360: p_return_status := hr_multi_message.get_return_status_disable;
355: when hr_multi_message.error_message_exist then
356: p_return_status := hr_multi_message.get_return_status_disable;
357: --
358: when others then
359: hr_multi_message.add;
360: p_return_status := hr_multi_message.get_return_status_disable;
361: --
362: end lock_formula;
363: --
356: p_return_status := hr_multi_message.get_return_status_disable;
357: --
358: when others then
359: hr_multi_message.add;
360: p_return_status := hr_multi_message.get_return_status_disable;
361: --
362: end lock_formula;
363: --
364: procedure compile_formula(
543: end if;
544:
545: --
546: -- Enable multi-messaging
547: hr_multi_message.enable_message_list;
548: --
549: -- Generate a unique formula name for this formula type, business group
550: -- and legislation
551: generate_unique_formula_name(
587: hr_utility.set_location('Leaving ff_formula_webui_pkg.compile_formula_autonomously',20);
588: end if;
589: --
590: -- Get the return status and disable multi-messaging
591: p_return_status := hr_multi_message.get_return_status_disable;
592: --
593: exception
594: --
595: when hr_multi_message.error_message_exist then
591: p_return_status := hr_multi_message.get_return_status_disable;
592: --
593: exception
594: --
595: when hr_multi_message.error_message_exist then
596: p_return_status := hr_multi_message.get_return_status_disable;
597: --
598: when others then raise;
599: --hr_multi_message.add;
592: --
593: exception
594: --
595: when hr_multi_message.error_message_exist then
596: p_return_status := hr_multi_message.get_return_status_disable;
597: --
598: when others then raise;
599: --hr_multi_message.add;
600: --p_return_status := hr_multi_message.get_return_status_disable;
595: when hr_multi_message.error_message_exist then
596: p_return_status := hr_multi_message.get_return_status_disable;
597: --
598: when others then raise;
599: --hr_multi_message.add;
600: --p_return_status := hr_multi_message.get_return_status_disable;
601: --
602: end compile_formula_autonomously;
603: --
596: p_return_status := hr_multi_message.get_return_status_disable;
597: --
598: when others then raise;
599: --hr_multi_message.add;
600: --p_return_status := hr_multi_message.get_return_status_disable;
601: --
602: end compile_formula_autonomously;
603: --
604: procedure run_formula(
738: hr_utility.set_location('Entering ff_formula_webui_pkg.run_formula',10);
739: end if;
740: --
741: -- Enable multi-messaging
742: hr_multi_message.enable_message_list;
743: --
744: ff_exec.init_formula(p_formula_id, p_session_date, v_inputs, v_outputs);
745: --
746: -- Check to see if any errors occurred, if so the
743: --
744: ff_exec.init_formula(p_formula_id, p_session_date, v_inputs, v_outputs);
745: --
746: -- Check to see if any errors occurred, if so the
747: -- hr_multi_message.error_message_exist exception will be raised
748: hr_multi_message.end_validation_set;
749: --
750: -- Set up the inputs and contexts to formula.
751: for i in v_inputs.first..v_inputs.last loop
744: ff_exec.init_formula(p_formula_id, p_session_date, v_inputs, v_outputs);
745: --
746: -- Check to see if any errors occurred, if so the
747: -- hr_multi_message.error_message_exist exception will be raised
748: hr_multi_message.end_validation_set;
749: --
750: -- Set up the inputs and contexts to formula.
751: for i in v_inputs.first..v_inputs.last loop
752: --
815: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
816: hr_utility.set_message_token('PROCEDURE',
817: 'FF_FORMULA_WEBUI_PKG.run_formula');
818: hr_utility.set_message_token('STEP','10');
819: if hr_multi_message.exception_add then
820: hr_utility.raise_error;
821: end if;
822: end if;
823: --
895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
896: hr_utility.set_message_token('PROCEDURE',
897: 'FF_FORMULA_WEBUI_PKG.run_formula');
898: hr_utility.set_message_token('STEP','20');
899: if hr_multi_message.exception_add then
900: hr_utility.raise_error;
901: end if;
902: end if;
903: --
907: hr_utility.set_location('Leaving ff_formula_webui_pkg.run_formula',20);
908: end if;
909: --
910: -- Get the return status and disable multi-messaging
911: p_return_status := hr_multi_message.get_return_status_disable;
912: --
913: exception
914: --
915: when hr_multi_message.error_message_exist then
911: p_return_status := hr_multi_message.get_return_status_disable;
912: --
913: exception
914: --
915: when hr_multi_message.error_message_exist then
916: ff_exec.reset_caches;
917: p_return_status := hr_multi_message.get_return_status_disable;
918: --
919: when others then
913: exception
914: --
915: when hr_multi_message.error_message_exist then
916: ff_exec.reset_caches;
917: p_return_status := hr_multi_message.get_return_status_disable;
918: --
919: when others then
920: ff_exec.reset_caches;
921: hr_multi_message.add;
917: p_return_status := hr_multi_message.get_return_status_disable;
918: --
919: when others then
920: ff_exec.reset_caches;
921: hr_multi_message.add;
922: p_return_status := hr_multi_message.get_return_status_disable;
923: --
924: end run_formula;
925: --
918: --
919: when others then
920: ff_exec.reset_caches;
921: hr_multi_message.add;
922: p_return_status := hr_multi_message.get_return_status_disable;
923: --
924: end run_formula;
925: --
926: function isFormulaCompiled(