1555: -- ERROR out.
1556: --
1557: hr_utility.set_location(l_proc, 45);
1558: --
1559: fnd_message.set_name('BEN','BEN_92322_EGD_NOT_FOUND');
1560: fnd_message.raise_error;
1561: --
1562: elsif l_cvg_thru_dt <> hr_api.g_eot and not l_pdp_found then
1563: --
1556: --
1557: hr_utility.set_location(l_proc, 45);
1558: --
1559: fnd_message.set_name('BEN','BEN_92322_EGD_NOT_FOUND');
1560: fnd_message.raise_error;
1561: --
1562: elsif l_cvg_thru_dt <> hr_api.g_eot and not l_pdp_found then
1563: --
1564: -- The Coverage through date is not EOT, it means that the
1567: -- ERROR out.
1568: --
1569: hr_utility.set_location(l_proc, 50);
1570: --
1571: fnd_message.set_name('BEN','BEN_92323_CVG_CANNOT_BE_ENDED');
1572: fnd_message.raise_error;
1573: --
1574: elsif l_pdp_found and (l_cvg_thru_dt <> hr_api.g_eot
1575: or p_cvg_strt_dt is null) then
1568: --
1569: hr_utility.set_location(l_proc, 50);
1570: --
1571: fnd_message.set_name('BEN','BEN_92323_CVG_CANNOT_BE_ENDED');
1572: fnd_message.raise_error;
1573: --
1574: elsif l_pdp_found and (l_cvg_thru_dt <> hr_api.g_eot
1575: or p_cvg_strt_dt is null) then
1576: --
1974: -- A validation or unexpected error has occured
1975: --
1976: hr_utility.set_location(' Exception in :'||l_proc, 100);
1977: --Bug 4387247
1978: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1979: fnd_message.set_token('2',substr(sqlerrm,1,200));
1980: fnd_msg_pub.add; -- bug fix 4111762
1981: ROLLBACK TO process_dependent_w;
1982: /* Inserted for nocopy changes */
1975: --
1976: hr_utility.set_location(' Exception in :'||l_proc, 100);
1977: --Bug 4387247
1978: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1979: fnd_message.set_token('2',substr(sqlerrm,1,200));
1980: fnd_msg_pub.add; -- bug fix 4111762
1981: ROLLBACK TO process_dependent_w;
1982: /* Inserted for nocopy changes */
1983: p_elig_cvrd_dpnt_id := null;
2014: --
2015: -- An unexpected error has occured
2016: --
2017: hr_utility.set_location(' Exception in :'||l_proc, 100);
2018: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2019: fnd_message.set_token('2',substr(sqlerrm,1,200));
2020: fnd_msg_pub.add;
2021: end store_crt_ord_warning_ss;
2022: --
2015: -- An unexpected error has occured
2016: --
2017: hr_utility.set_location(' Exception in :'||l_proc, 100);
2018: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2019: fnd_message.set_token('2',substr(sqlerrm,1,200));
2020: fnd_msg_pub.add;
2021: end store_crt_ord_warning_ss;
2022: --
2023: -- Bug 4114970
2101: end if;
2102: end loop;
2103:
2104: if l_comp_obj_list is not null then
2105: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');
2106: fnd_message.set_token('PARAM', l_comp_obj_list);
2107:
2108: INSERT INTO ben_online_warnings(session_id, message_text)
2109: VALUES (p_person_id, fnd_message.get);
2102: end loop;
2103:
2104: if l_comp_obj_list is not null then
2105: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');
2106: fnd_message.set_token('PARAM', l_comp_obj_list);
2107:
2108: INSERT INTO ben_online_warnings(session_id, message_text)
2109: VALUES (p_person_id, fnd_message.get);
2110: end if;
2105: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');
2106: fnd_message.set_token('PARAM', l_comp_obj_list);
2107:
2108: INSERT INTO ben_online_warnings(session_id, message_text)
2109: VALUES (p_person_id, fnd_message.get);
2110: end if;
2111: --
2112: hr_utility.set_location('Leaving'|| l_proc, 20);
2113: exception
2115: --
2116: -- An unexpected error has occured
2117: --
2118: hr_utility.set_location(' Exception in :'||l_proc, 100);
2119: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2120: fnd_message.set_token('2',substr(sqlerrm,1,200));
2121: fnd_msg_pub.add;
2122: end store_crt_ord_warng_DDNA;
2123: --
2116: -- An unexpected error has occured
2117: --
2118: hr_utility.set_location(' Exception in :'||l_proc, 100);
2119: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2120: fnd_message.set_token('2',substr(sqlerrm,1,200));
2121: fnd_msg_pub.add;
2122: end store_crt_ord_warng_DDNA;
2123: --
2124: --