DBA Data[Home] [Help]

APPS.BEN_ELIG_DPNT_API dependencies on FND_MESSAGE

Line 1560: fnd_message.set_name('BEN','BEN_92322_EGD_NOT_FOUND');

1556: -- ERROR out.
1557: --
1558: hr_utility.set_location(l_proc, 45);
1559: --
1560: fnd_message.set_name('BEN','BEN_92322_EGD_NOT_FOUND');
1561: fnd_message.raise_error;
1562: --
1563: elsif l_cvg_thru_dt <> hr_api.g_eot and not l_pdp_found then
1564: --

Line 1561: fnd_message.raise_error;

1557: --
1558: hr_utility.set_location(l_proc, 45);
1559: --
1560: fnd_message.set_name('BEN','BEN_92322_EGD_NOT_FOUND');
1561: fnd_message.raise_error;
1562: --
1563: elsif l_cvg_thru_dt <> hr_api.g_eot and not l_pdp_found then
1564: --
1565: -- The Coverage through date is not EOT, it means that the

Line 1572: fnd_message.set_name('BEN','BEN_92323_CVG_CANNOT_BE_ENDED');

1568: -- ERROR out.
1569: --
1570: hr_utility.set_location(l_proc, 50);
1571: --
1572: fnd_message.set_name('BEN','BEN_92323_CVG_CANNOT_BE_ENDED');
1573: fnd_message.raise_error;
1574: --
1575: elsif l_pdp_found and (l_cvg_thru_dt <> hr_api.g_eot
1576: or p_cvg_strt_dt is null) then

Line 1573: fnd_message.raise_error;

1569: --
1570: hr_utility.set_location(l_proc, 50);
1571: --
1572: fnd_message.set_name('BEN','BEN_92323_CVG_CANNOT_BE_ENDED');
1573: fnd_message.raise_error;
1574: --
1575: elsif l_pdp_found and (l_cvg_thru_dt <> hr_api.g_eot
1576: or p_cvg_strt_dt is null) then
1577: --

Line 1985: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');

1981: -- A validation or unexpected error has occured
1982: --
1983: hr_utility.set_location(' Exception in :'||l_proc, 100);
1984: --Bug 4387247
1985: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1986: fnd_message.set_token('2',substr(sqlerrm,1,200));
1987: fnd_msg_pub.add; -- bug fix 4111762
1988: ROLLBACK TO process_dependent_w;
1989: /* Inserted for nocopy changes */

Line 1986: fnd_message.set_token('2',substr(sqlerrm,1,200));

1982: --
1983: hr_utility.set_location(' Exception in :'||l_proc, 100);
1984: --Bug 4387247
1985: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1986: fnd_message.set_token('2',substr(sqlerrm,1,200));
1987: fnd_msg_pub.add; -- bug fix 4111762
1988: ROLLBACK TO process_dependent_w;
1989: /* Inserted for nocopy changes */
1990: p_elig_cvrd_dpnt_id := null;

Line 2025: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');

2021: --
2022: -- An unexpected error has occured
2023: --
2024: hr_utility.set_location(' Exception in :'||l_proc, 100);
2025: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2026: fnd_message.set_token('2',substr(sqlerrm,1,200));
2027: fnd_msg_pub.add;
2028: end store_crt_ord_warning_ss;
2029: --

Line 2026: fnd_message.set_token('2',substr(sqlerrm,1,200));

2022: -- An unexpected error has occured
2023: --
2024: hr_utility.set_location(' Exception in :'||l_proc, 100);
2025: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2026: fnd_message.set_token('2',substr(sqlerrm,1,200));
2027: fnd_msg_pub.add;
2028: end store_crt_ord_warning_ss;
2029: --
2030: -- Bug 4114970

Line 2112: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');

2108: end if;
2109: end loop;
2110:
2111: if l_comp_obj_list is not null then
2112: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');
2113: fnd_message.set_token('PARAM', l_comp_obj_list);
2114:
2115: INSERT INTO ben_online_warnings(session_id, message_text)
2116: VALUES (p_person_id, fnd_message.get);

Line 2113: fnd_message.set_token('PARAM', l_comp_obj_list);

2109: end loop;
2110:
2111: if l_comp_obj_list is not null then
2112: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');
2113: fnd_message.set_token('PARAM', l_comp_obj_list);
2114:
2115: INSERT INTO ben_online_warnings(session_id, message_text)
2116: VALUES (p_person_id, fnd_message.get);
2117: end if;

Line 2116: VALUES (p_person_id, fnd_message.get);

2112: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');
2113: fnd_message.set_token('PARAM', l_comp_obj_list);
2114:
2115: INSERT INTO ben_online_warnings(session_id, message_text)
2116: VALUES (p_person_id, fnd_message.get);
2117: end if;
2118: --
2119: hr_utility.set_location('Leaving'|| l_proc, 20);
2120: exception

Line 2126: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');

2122: --
2123: -- An unexpected error has occured
2124: --
2125: hr_utility.set_location(' Exception in :'||l_proc, 100);
2126: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2127: fnd_message.set_token('2',substr(sqlerrm,1,200));
2128: fnd_msg_pub.add;
2129: end store_crt_ord_warng_DDNA;
2130: --

Line 2127: fnd_message.set_token('2',substr(sqlerrm,1,200));

2123: -- An unexpected error has occured
2124: --
2125: hr_utility.set_location(' Exception in :'||l_proc, 100);
2126: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2127: fnd_message.set_token('2',substr(sqlerrm,1,200));
2128: fnd_msg_pub.add;
2129: end store_crt_ord_warng_DDNA;
2130: --
2131: --

Line 2709: fnd_message.set_name('BEN','BEN_94714_RELATION_TYP_UPD');

2705: open c_chk_enrt(l_dpnt_rltp_row.date_start,nvl(l_dpnt_rltp_row.date_end,hr_api.g_eot));
2706: fetch c_chk_enrt into l_flag;
2707: if(c_chk_enrt%found) then
2708: hr_utility.set_location('Enrollment Rec exists for Dep ', 10);
2709: fnd_message.set_name('BEN','BEN_94714_RELATION_TYP_UPD');
2710: fnd_message.raise_error;
2711: --raise error message;
2712: end if;
2713: close c_chk_enrt;

Line 2710: fnd_message.raise_error;

2706: fetch c_chk_enrt into l_flag;
2707: if(c_chk_enrt%found) then
2708: hr_utility.set_location('Enrollment Rec exists for Dep ', 10);
2709: fnd_message.set_name('BEN','BEN_94714_RELATION_TYP_UPD');
2710: fnd_message.raise_error;
2711: --raise error message;
2712: end if;
2713: close c_chk_enrt;
2714: end if;