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(
524: hr_utility.set_location('Entering ff_formula_webui_pkg.compile_formula_autonomously',10);
525: end if;
526: --
527: -- Enable multi-messaging
528: hr_multi_message.enable_message_list;
529: --
530: -- Generate a unique formula name for this formula type, business group
531: -- and legislation
532: generate_unique_formula_name(
568: hr_utility.set_location('Leaving ff_formula_webui_pkg.compile_formula_autonomously',20);
569: end if;
570: --
571: -- Get the return status and disable multi-messaging
572: p_return_status := hr_multi_message.get_return_status_disable;
573: --
574: exception
575: --
576: when hr_multi_message.error_message_exist then
572: p_return_status := hr_multi_message.get_return_status_disable;
573: --
574: exception
575: --
576: when hr_multi_message.error_message_exist then
577: p_return_status := hr_multi_message.get_return_status_disable;
578: --
579: when others then raise;
580: --hr_multi_message.add;
573: --
574: exception
575: --
576: when hr_multi_message.error_message_exist then
577: p_return_status := hr_multi_message.get_return_status_disable;
578: --
579: when others then raise;
580: --hr_multi_message.add;
581: --p_return_status := hr_multi_message.get_return_status_disable;
576: when hr_multi_message.error_message_exist then
577: p_return_status := hr_multi_message.get_return_status_disable;
578: --
579: when others then raise;
580: --hr_multi_message.add;
581: --p_return_status := hr_multi_message.get_return_status_disable;
582: --
583: end compile_formula_autonomously;
584: --
577: p_return_status := hr_multi_message.get_return_status_disable;
578: --
579: when others then raise;
580: --hr_multi_message.add;
581: --p_return_status := hr_multi_message.get_return_status_disable;
582: --
583: end compile_formula_autonomously;
584: --
585: procedure run_formula(
719: hr_utility.set_location('Entering ff_formula_webui_pkg.run_formula',10);
720: end if;
721: --
722: -- Enable multi-messaging
723: hr_multi_message.enable_message_list;
724: --
725: ff_exec.init_formula(p_formula_id, p_session_date, v_inputs, v_outputs);
726: --
727: -- Check to see if any errors occurred, if so the
724: --
725: ff_exec.init_formula(p_formula_id, p_session_date, v_inputs, v_outputs);
726: --
727: -- Check to see if any errors occurred, if so the
728: -- hr_multi_message.error_message_exist exception will be raised
729: hr_multi_message.end_validation_set;
730: --
731: -- Set up the inputs and contexts to formula.
732: for i in v_inputs.first..v_inputs.last loop
725: ff_exec.init_formula(p_formula_id, p_session_date, v_inputs, v_outputs);
726: --
727: -- Check to see if any errors occurred, if so the
728: -- hr_multi_message.error_message_exist exception will be raised
729: hr_multi_message.end_validation_set;
730: --
731: -- Set up the inputs and contexts to formula.
732: for i in v_inputs.first..v_inputs.last loop
733: --
796: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
797: hr_utility.set_message_token('PROCEDURE',
798: 'FF_FORMULA_WEBUI_PKG.run_formula');
799: hr_utility.set_message_token('STEP','10');
800: if hr_multi_message.exception_add then
801: hr_utility.raise_error;
802: end if;
803: end if;
804: --
876: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
877: hr_utility.set_message_token('PROCEDURE',
878: 'FF_FORMULA_WEBUI_PKG.run_formula');
879: hr_utility.set_message_token('STEP','20');
880: if hr_multi_message.exception_add then
881: hr_utility.raise_error;
882: end if;
883: end if;
884: --
888: hr_utility.set_location('Leaving ff_formula_webui_pkg.run_formula',20);
889: end if;
890: --
891: -- Get the return status and disable multi-messaging
892: p_return_status := hr_multi_message.get_return_status_disable;
893: --
894: exception
895: --
896: when hr_multi_message.error_message_exist then
892: p_return_status := hr_multi_message.get_return_status_disable;
893: --
894: exception
895: --
896: when hr_multi_message.error_message_exist then
897: ff_exec.reset_caches;
898: p_return_status := hr_multi_message.get_return_status_disable;
899: --
900: when others then
894: exception
895: --
896: when hr_multi_message.error_message_exist then
897: ff_exec.reset_caches;
898: p_return_status := hr_multi_message.get_return_status_disable;
899: --
900: when others then
901: ff_exec.reset_caches;
902: hr_multi_message.add;
898: p_return_status := hr_multi_message.get_return_status_disable;
899: --
900: when others then
901: ff_exec.reset_caches;
902: hr_multi_message.add;
903: p_return_status := hr_multi_message.get_return_status_disable;
904: --
905: end run_formula;
906: --
899: --
900: when others then
901: ff_exec.reset_caches;
902: hr_multi_message.add;
903: p_return_status := hr_multi_message.get_return_status_disable;
904: --
905: end run_formula;
906: --
907: function isFormulaCompiled(