833: p_prtn_eff_strt_dt := fnd_date.canonical_to_date
834: (l_outputs(l_outputs.first).value);
835: exception
836: when others then
837: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
838: fnd_message.set_token('RL','prtn_eff_strt_dt_rl');
839: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
840: raise ben_manage_life_events.g_record_error;
841: end;
834: (l_outputs(l_outputs.first).value);
835: exception
836: when others then
837: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
838: fnd_message.set_token('RL','prtn_eff_strt_dt_rl');
839: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
840: raise ben_manage_life_events.g_record_error;
841: end;
842: else
835: exception
836: when others then
837: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
838: fnd_message.set_token('RL','prtn_eff_strt_dt_rl');
839: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
840: raise ben_manage_life_events.g_record_error;
841: end;
842: else
843: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
839: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
840: raise ben_manage_life_events.g_record_error;
841: end;
842: else
843: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
844: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
845: fnd_message.set_token('CODE1',l_prtn_eff_strt_dt_cd);
846: raise ben_manage_life_events.g_record_error ;
847: end if;
840: raise ben_manage_life_events.g_record_error;
841: end;
842: else
843: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
844: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
845: fnd_message.set_token('CODE1',l_prtn_eff_strt_dt_cd);
846: raise ben_manage_life_events.g_record_error ;
847: end if;
848:
841: end;
842: else
843: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
844: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
845: fnd_message.set_token('CODE1',l_prtn_eff_strt_dt_cd);
846: raise ben_manage_life_events.g_record_error ;
847: end if;
848:
849: elsif p_start_or_end = 'E' then
1042: p_prtn_eff_end_dt := fnd_date.canonical_to_date
1043: (l_outputs(l_outputs.first).value);
1044: exception
1045: when others then
1046: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1047: fnd_message.set_token('RL','prtn_eff_end_dt_rl');
1048: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1049: raise ben_manage_life_events.g_record_error;
1050: end;
1043: (l_outputs(l_outputs.first).value);
1044: exception
1045: when others then
1046: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1047: fnd_message.set_token('RL','prtn_eff_end_dt_rl');
1048: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1049: raise ben_manage_life_events.g_record_error;
1050: end;
1051:
1044: exception
1045: when others then
1046: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1047: fnd_message.set_token('RL','prtn_eff_end_dt_rl');
1048: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1049: raise ben_manage_life_events.g_record_error;
1050: end;
1051:
1052: else
1049: raise ben_manage_life_events.g_record_error;
1050: end;
1051:
1052: else
1053: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
1054: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1055: fnd_message.set_token('CODE1',l_prtn_eff_end_dt_cd);
1056: raise ben_manage_life_events.g_record_error;
1057: end if;
1050: end;
1051:
1052: else
1053: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
1054: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1055: fnd_message.set_token('CODE1',l_prtn_eff_end_dt_cd);
1056: raise ben_manage_life_events.g_record_error;
1057: end if;
1058: else
1051:
1052: else
1053: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
1054: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1055: fnd_message.set_token('CODE1',l_prtn_eff_end_dt_cd);
1056: raise ben_manage_life_events.g_record_error;
1057: end if;
1058: else
1059: fnd_message.set_name('BEN','BEN_91393_STRT_END_ERROR');
1055: fnd_message.set_token('CODE1',l_prtn_eff_end_dt_cd);
1056: raise ben_manage_life_events.g_record_error;
1057: end if;
1058: else
1059: fnd_message.set_name('BEN','BEN_91393_STRT_END_ERROR');
1060: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1061: raise ben_manage_life_events.g_record_error;
1062: end if;
1063: -- hr_utility.set_location('Leaving ben_determine_eligibility2.get_start_end_dates',10);
1056: raise ben_manage_life_events.g_record_error;
1057: end if;
1058: else
1059: fnd_message.set_name('BEN','BEN_91393_STRT_END_ERROR');
1060: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1061: raise ben_manage_life_events.g_record_error;
1062: end if;
1063: -- hr_utility.set_location('Leaving ben_determine_eligibility2.get_start_end_dates',10);
1064:
1538: if c_ptnl_le%found
1539: and l_benmngle_parm_rec.mode_cd <> 'I' --iRec:Do not raise the error when BENMNGLE processed in iRecruitment mode
1540: then
1541: close c_ptnl_le;
1542: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1543: hr_utility.set_location('PTNL LE FOUND ben_determine_eligibility2.check_prev_elig', 10);
1544: ben_manage_life_events.g_output_string :=
1545: ben_manage_life_events.g_output_string||
1546: 'Elg: Yes '||-- 3597303
1543: hr_utility.set_location('PTNL LE FOUND ben_determine_eligibility2.check_prev_elig', 10);
1544: ben_manage_life_events.g_output_string :=
1545: ben_manage_life_events.g_output_string||
1546: 'Elg: Yes '||-- 3597303
1547: 'Warning:'||fnd_message.get;
1548: --
1549: -- DDW change, set object ineligible
1550: --
1551: p_elig_flag := true;---false; -- bug 3597303
1591: if c_ptnl_le%found
1592: and l_benmngle_parm_rec.mode_cd <> 'I' --iRec:Do not raise the error when BENMNGLE processed in iRecruitment mode
1593: then
1594: close c_ptnl_le;
1595: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1596: ben_manage_life_events.g_output_string :=
1597: ben_manage_life_events.g_output_string||
1598: 'Elg: Yes '||-- 3597303
1599: 'Warning:'||fnd_message.get;
1595: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1596: ben_manage_life_events.g_output_string :=
1597: ben_manage_life_events.g_output_string||
1598: 'Elg: Yes '||-- 3597303
1599: 'Warning:'||fnd_message.get;
1600: --
1601: -- DDW change, set object ineligible
1602: --
1603: p_elig_flag := true; -- 3597303
1772: --
1773: hr_utility.set_location ('oipl first elig',121);
1774: l_first_elig := true;
1775: l_start_or_end := 'S';
1776: fnd_message.set_name ('BEN','BEN_91385_FIRST_ELIG');
1777: benutils.write(p_text => fnd_message.get);
1778: --
1779: else
1780: --
1773: hr_utility.set_location ('oipl first elig',121);
1774: l_first_elig := true;
1775: l_start_or_end := 'S';
1776: fnd_message.set_name ('BEN','BEN_91385_FIRST_ELIG');
1777: benutils.write(p_text => fnd_message.get);
1778: --
1779: else
1780: --
1781: fnd_message.set_name ('BEN','BEN_92533_FIRST_INELIG2');
1777: benutils.write(p_text => fnd_message.get);
1778: --
1779: else
1780: --
1781: fnd_message.set_name ('BEN','BEN_92533_FIRST_INELIG2');
1782: benutils.write(p_text => fnd_message.get);
1783: -- only continue with program and call of api if we want to track
1784: -- inelig people.
1785: l_trk_inelig_per_flag := l_oipl_rec.trk_inelig_per_flag;
1778: --
1779: else
1780: --
1781: fnd_message.set_name ('BEN','BEN_92533_FIRST_INELIG2');
1782: benutils.write(p_text => fnd_message.get);
1783: -- only continue with program and call of api if we want to track
1784: -- inelig people.
1785: l_trk_inelig_per_flag := l_oipl_rec.trk_inelig_per_flag;
1786: --
1817: then--b
1818: --
1819: if l_opt_elig_flag = 'Y' and p_elig_flag then --d
1820: -- Person still eligible, do nothing.
1821: fnd_message.set_name ('BEN','BEN_91345_ELIG_PREV_ELIG');
1822: benutils.write(p_text => fnd_message.get);
1823: --
1824: if instr(ben_manage_life_events.g_output_string,
1825: 'Elg:') = 0 then
1818: --
1819: if l_opt_elig_flag = 'Y' and p_elig_flag then --d
1820: -- Person still eligible, do nothing.
1821: fnd_message.set_name ('BEN','BEN_91345_ELIG_PREV_ELIG');
1822: benutils.write(p_text => fnd_message.get);
1823: --
1824: if instr(ben_manage_life_events.g_output_string,
1825: 'Elg:') = 0 then
1826: --
1841: -- person is newly inelig
1842: hr_utility.set_location ('newly inelig',121);
1843: l_newly_inelig := true;
1844: l_start_or_end := 'E';
1845: fnd_message.set_name('BEN','BEN_91347_NOT_ELIG_PREV_ELIG');
1846: benutils.write(p_text => fnd_message.get);
1847: --
1848: elsif l_opt_elig_flag = 'N' and p_elig_flag = false then --d
1849: -- person is still inelig, do nothing.
1842: hr_utility.set_location ('newly inelig',121);
1843: l_newly_inelig := true;
1844: l_start_or_end := 'E';
1845: fnd_message.set_name('BEN','BEN_91347_NOT_ELIG_PREV_ELIG');
1846: benutils.write(p_text => fnd_message.get);
1847: --
1848: elsif l_opt_elig_flag = 'N' and p_elig_flag = false then --d
1849: -- person is still inelig, do nothing.
1850: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');
1846: benutils.write(p_text => fnd_message.get);
1847: --
1848: elsif l_opt_elig_flag = 'N' and p_elig_flag = false then --d
1849: -- person is still inelig, do nothing.
1850: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');
1851: benutils.write(p_text => fnd_message.get);
1852: --
1853: -- Set transition state for processing only. Elig
1854: -- per is not written
1847: --
1848: elsif l_opt_elig_flag = 'N' and p_elig_flag = false then --d
1849: -- person is still inelig, do nothing.
1850: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');
1851: benutils.write(p_text => fnd_message.get);
1852: --
1853: -- Set transition state for processing only. Elig
1854: -- per is not written
1855: --
2081: -- person is newly elig
2082: hr_utility.set_location('new elig',23);
2083: l_newly_elig := true;
2084: l_start_or_end := 'S';
2085: fnd_message.set_name('BEN','BEN_91346_ELIG_PREV_NOT_ELIG');
2086: benutils.write(p_text => fnd_message.get);
2087: --
2088: else
2089: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
2082: hr_utility.set_location('new elig',23);
2083: l_newly_elig := true;
2084: l_start_or_end := 'S';
2085: fnd_message.set_name('BEN','BEN_91346_ELIG_PREV_NOT_ELIG');
2086: benutils.write(p_text => fnd_message.get);
2087: --
2088: else
2089: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
2090: fnd_message.set_token('FLAG','epo.elig_flag');
2085: fnd_message.set_name('BEN','BEN_91346_ELIG_PREV_NOT_ELIG');
2086: benutils.write(p_text => fnd_message.get);
2087: --
2088: else
2089: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
2090: fnd_message.set_token('FLAG','epo.elig_flag');
2091: fnd_message.set_token('PROC','ben_determine_eligibility2.check_prev_elig');
2092: raise ben_manage_life_events.g_record_error;
2093: --
2086: benutils.write(p_text => fnd_message.get);
2087: --
2088: else
2089: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
2090: fnd_message.set_token('FLAG','epo.elig_flag');
2091: fnd_message.set_token('PROC','ben_determine_eligibility2.check_prev_elig');
2092: raise ben_manage_life_events.g_record_error;
2093: --
2094: end if; --d
2087: --
2088: else
2089: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
2090: fnd_message.set_token('FLAG','epo.elig_flag');
2091: fnd_message.set_token('PROC','ben_determine_eligibility2.check_prev_elig');
2092: raise ben_manage_life_events.g_record_error;
2093: --
2094: end if; --d
2095: --
2164: --
2165: if l_plnpep_dets.elig_per_id is null
2166: then
2167: --
2168: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
2169: raise ben_manage_life_events.g_record_error;
2170: --
2171: else
2172: --
3285: --
3286: if l_plnpep_dets.elig_per_id is null
3287: then
3288: --
3289: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
3290: raise ben_manage_life_events.g_record_error;
3291: --
3292: else
3293: --
3479: ,p_elig_per_opt_id => l_elig_per_opt_id);
3480: end if;
3481: else
3482: --
3483: fnd_message.set_name('BEN','BEN_91392_ELIG_FLAG_ERROR');
3484: raise ben_manage_life_events.g_record_error;
3485: --
3486: end if; --n
3487: --
3548: --
3549: -- Bug 3111613
3550: -- if cache reeturns a null here, raise an error
3551: if l_prev_oiplip_elig_check.elig_per_id is null then
3552: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
3553: raise ben_manage_life_events.g_record_error;
3554: end if;
3555:
3556:
4018: end if;
4019: l_first_elig := true;
4020: hr_utility.set_location ('first elig',121);
4021: l_start_or_end := 'S';
4022: fnd_message.set_name ('BEN','BEN_91385_FIRST_ELIG');
4023: benutils.write(p_text => fnd_message.get);
4024: --
4025: else
4026: --
4019: l_first_elig := true;
4020: hr_utility.set_location ('first elig',121);
4021: l_start_or_end := 'S';
4022: fnd_message.set_name ('BEN','BEN_91385_FIRST_ELIG');
4023: benutils.write(p_text => fnd_message.get);
4024: --
4025: else
4026: --
4027: hr_utility.set_location('elig is false ben_determine_eligibility2.check_prev_elig', 10);
4024: --
4025: else
4026: --
4027: hr_utility.set_location('elig is false ben_determine_eligibility2.check_prev_elig', 10);
4028: fnd_message.set_name ('BEN','BEN_92533_FIRST_INELIG2');
4029: benutils.write(p_text => fnd_message.get);
4030: --
4031: -- only continue with program and call of api if we want to track
4032: -- inelig people.
4025: else
4026: --
4027: hr_utility.set_location('elig is false ben_determine_eligibility2.check_prev_elig', 10);
4028: fnd_message.set_name ('BEN','BEN_92533_FIRST_INELIG2');
4029: benutils.write(p_text => fnd_message.get);
4030: --
4031: -- only continue with program and call of api if we want to track
4032: -- inelig people.
4033: --
4111: --
4112: hr_utility.set_location ('still elig',121);
4113: -- Person still eligible, do nothing.
4114: --
4115: fnd_message.set_name ('BEN','BEN_91345_ELIG_PREV_ELIG');
4116: benutils.write(p_text => fnd_message.get);
4117: l_start_or_end := 'S';
4118: l_still_elig := true;
4119: --
4112: hr_utility.set_location ('still elig',121);
4113: -- Person still eligible, do nothing.
4114: --
4115: fnd_message.set_name ('BEN','BEN_91345_ELIG_PREV_ELIG');
4116: benutils.write(p_text => fnd_message.get);
4117: l_start_or_end := 'S';
4118: l_still_elig := true;
4119: --
4120: --return;
4123: -- person is newly inelig
4124: hr_utility.set_location ('newly inelig',121);
4125: l_newly_inelig := true;
4126: l_start_or_end := 'E';
4127: fnd_message.set_name('BEN','BEN_91347_NOT_ELIG_PREV_ELIG');
4128: benutils.write(p_text => fnd_message.get);
4129: --
4130: elsif l_elig_per_elig_flag = 'N' and p_elig_flag = false then --d
4131: -- person is still inelig, do nothing.
4124: hr_utility.set_location ('newly inelig',121);
4125: l_newly_inelig := true;
4126: l_start_or_end := 'E';
4127: fnd_message.set_name('BEN','BEN_91347_NOT_ELIG_PREV_ELIG');
4128: benutils.write(p_text => fnd_message.get);
4129: --
4130: elsif l_elig_per_elig_flag = 'N' and p_elig_flag = false then --d
4131: -- person is still inelig, do nothing.
4132: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');
4128: benutils.write(p_text => fnd_message.get);
4129: --
4130: elsif l_elig_per_elig_flag = 'N' and p_elig_flag = false then --d
4131: -- person is still inelig, do nothing.
4132: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');
4133: benutils.write(p_text => fnd_message.get);
4134: --
4135: -- Set transition state for processing only. Elig
4136: -- per is not written
4129: --
4130: elsif l_elig_per_elig_flag = 'N' and p_elig_flag = false then --d
4131: -- person is still inelig, do nothing.
4132: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');
4133: benutils.write(p_text => fnd_message.get);
4134: --
4135: -- Set transition state for processing only. Elig
4136: -- per is not written
4137: --
4464: -- person is newly elig
4465: hr_utility.set_location('new elig',23);
4466: l_newly_elig := true;
4467: l_start_or_end := 'S';
4468: fnd_message.set_name('BEN','BEN_91346_ELIG_PREV_NOT_ELIG');
4469: benutils.write(p_text => fnd_message.get);
4470: --
4471: else
4472: --
4465: hr_utility.set_location('new elig',23);
4466: l_newly_elig := true;
4467: l_start_or_end := 'S';
4468: fnd_message.set_name('BEN','BEN_91346_ELIG_PREV_NOT_ELIG');
4469: benutils.write(p_text => fnd_message.get);
4470: --
4471: else
4472: --
4473: fnd_message.set_name('BEN','BEN_91392_ELIG_FLAG_ERROR');
4469: benutils.write(p_text => fnd_message.get);
4470: --
4471: else
4472: --
4473: fnd_message.set_name('BEN','BEN_91392_ELIG_FLAG_ERROR');
4474: raise ben_manage_life_events.g_record_error;
4475: --
4476: end if; --d
4477: --