826: , p_leaving_reason => l_leaving_reason
827: , p_service_band => l_service_band );
828: --
829: if (l_leaving_reason is null) then
830: l_leaving_reason_meaning := fnd_message.get_string('HRI','HR_BIS_UNKNOWN');
831: elsif
832: (l_leaving_reason = 'NOTSEPARATED') then
833: --
834: l_leaving_reason_meaning := 'NotSeparated';
872:
873: l_service_band := substr(l_service_band,1,1);
874: --
875: if(l_service_band = '<') then
876: l_service_band := fnd_message.get_string('HRI','HR_BIS_LESS_THAN_1_YEAR');
877: elsif(l_service_band = '1') then
878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');
879: elsif(l_service_band = '3') then
880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');
874: --
875: if(l_service_band = '<') then
876: l_service_band := fnd_message.get_string('HRI','HR_BIS_LESS_THAN_1_YEAR');
877: elsif(l_service_band = '1') then
878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');
879: elsif(l_service_band = '3') then
880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');
881: elsif(l_service_band = '5') then
882: l_service_band := fnd_message.get_string('HRI','HR_BIS_5_YEARS+');
876: l_service_band := fnd_message.get_string('HRI','HR_BIS_LESS_THAN_1_YEAR');
877: elsif(l_service_band = '1') then
878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');
879: elsif(l_service_band = '3') then
880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');
881: elsif(l_service_band = '5') then
882: l_service_band := fnd_message.get_string('HRI','HR_BIS_5_YEARS+');
883: end if;
884: --
878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');
879: elsif(l_service_band = '3') then
880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');
881: elsif(l_service_band = '5') then
882: l_service_band := fnd_message.get_string('HRI','HR_BIS_5_YEARS+');
883: end if;
884: --
885: RETURN (l_service_band);
886: --
2038: PROCEDURE Raise_FF_Not_Exist
2039: ( p_bgttyp in VarChar2 )
2040: IS
2041: BEGIN
2042: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_EXIST');
2043:
2044: -- Removed tokens in version 115.15
2045: -- Fnd_Message.Set_Token('BUDGET_FORMULA', 'BUDGET_'||p_bgttyp, FALSE);
2046: -- Fnd_Message.Set_Token('TEMPLATE_FORMULA', 'TEMPLATE_'||p_bgttyp, FALSE);
2041: BEGIN
2042: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_EXIST');
2043:
2044: -- Removed tokens in version 115.15
2045: -- Fnd_Message.Set_Token('BUDGET_FORMULA', 'BUDGET_'||p_bgttyp, FALSE);
2046: -- Fnd_Message.Set_Token('TEMPLATE_FORMULA', 'TEMPLATE_'||p_bgttyp, FALSE);
2047:
2048: raise ff_not_exist;
2049: END Raise_FF_Not_Exist;
2042: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_EXIST');
2043:
2044: -- Removed tokens in version 115.15
2045: -- Fnd_Message.Set_Token('BUDGET_FORMULA', 'BUDGET_'||p_bgttyp, FALSE);
2046: -- Fnd_Message.Set_Token('TEMPLATE_FORMULA', 'TEMPLATE_'||p_bgttyp, FALSE);
2047:
2048: raise ff_not_exist;
2049: END Raise_FF_Not_Exist;
2050:
2063: open fast_formula_csr;
2064: fetch fast_formula_csr into l_formula_name;
2065: close fast_formula_csr;
2066:
2067: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_COMPILED');
2068: Fnd_Message.Set_Token('FORMULA', l_formula_name, FALSE);
2069:
2070: raise ff_not_compiled;
2071: END Raise_FF_Not_Compiled;
2064: fetch fast_formula_csr into l_formula_name;
2065: close fast_formula_csr;
2066:
2067: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_COMPILED');
2068: Fnd_Message.Set_Token('FORMULA', l_formula_name, FALSE);
2069:
2070: raise ff_not_compiled;
2071: END Raise_FF_Not_Compiled;
2072: