1: PACKAGE BODY be_call_ff_pkg AS
2: -- $Header: pebeclff.pkb 115.6 2003/02/07 09:48:53 atrivedi noship $
3: --
4: --
5: -- Package constants
3: --
4: --
5: -- Package constants
6: --
7: c_pkg_name CONSTANT VARCHAR2(30) := 'be_call_ff_pkg';
8: --
9: --
10: -- Service routine to return information on the formula.
11: --
55: o_effective_start_date := l_rec.effective_start_date;
56: EXCEPTION
57: WHEN formula_missing THEN
58: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE', 'BE_CALL_FF_PKG.FORMULA_DETAILS');
60: hr_utility.set_message_token('STEP', '10');
61: hr_utility.raise_error;
62: END formula_details;
63: --
101: o_currency_code := l_rec.currency_code;
102: EXCEPTION
103: WHEN bg_missing THEN
104: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
105: hr_utility.set_message_token('PROCEDURE', 'BE_CALL_FF_PKG.BUSINESS_GROUP_DETAILS');
106: hr_utility.set_message_token('STEP', '10');
107: hr_utility.raise_error;
108: END business_group_details;
109: --
228: END LOOP;
229: EXCEPTION
230: WHEN wrong_input_params THEN
231: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
232: hr_utility.set_message_token('PROCEDURE', 'BE_CALL_FF_PKG.CALCULATE_NOTICE_PERIOD');
233: hr_utility.set_message_token('STEP', '10');
234: hr_utility.raise_error;
235: WHEN wrong_output_params THEN
236: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('STEP', '10');
234: hr_utility.raise_error;
235: WHEN wrong_output_params THEN
236: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
237: hr_utility.set_message_token('PROCEDURE', 'BE_CALL_FF_PKG.CALCULATE_NOTICE_PERIOD');
238: hr_utility.set_message_token('STEP', '20');
239: hr_utility.raise_error;
240: END calculate_notice_period;
241: --
339: RETURN l_return_value;
340: EXCEPTION
341: WHEN wrong_input_params THEN
342: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE', 'BE_CALL_FF_PKG.CHECK_NI');
344: hr_utility.set_message_token('STEP', '10');
345: hr_utility.raise_error;
346: WHEN wrong_output_params THEN
347: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
344: hr_utility.set_message_token('STEP', '10');
345: hr_utility.raise_error;
346: WHEN wrong_output_params THEN
347: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
348: hr_utility.set_message_token('PROCEDURE', 'BE_CALL_FF_PKG.CHECK_NI');
349: hr_utility.set_message_token('STEP', '20');
350: hr_utility.raise_error;
351: END check_ni;
352: --
349: hr_utility.set_message_token('STEP', '20');
350: hr_utility.raise_error;
351: END check_ni;
352: --
353: end be_call_ff_pkg;