eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_COBRA_REQUIREMENTS dependencies on FND_MESSAGE

Line 155: 115.47 04-jan-2005 ssarkar Bug# 3630753 : commented fnd_message.set_token('PROC',l_proc).

151: that costed values get assigned using the
152: Costing Hierarchy.
153: 115.46 27-Sep-2004 tjesumic new param p_cvrd_today added in chk_enrld_or_cvrd # 3843549
154: coerage validation changes as per the param
155: 115.47 04-jan-2005 ssarkar Bug# 3630753 : commented fnd_message.set_token('PROC',l_proc).
156: 115.48 08-Sep-2005 stee If eligibility period end date is 01/01/0001, then
157: set the quald_bnf_flag = 'N' and leave the eligibility
158: period end date as is. Bug 4486609.
159: 115.49 28-dec-2005 stee Only terminate cobra eligibility in chk_cobra_eligibility

Line 637: fnd_message.set_name('BEN','BEN_92426_CVG_THRU_DT_NOT_FND');

633: --
634: -- Problem with eligibility setup. The person has to be
635: -- previously enrolled to be eligible for the COBRA program.
636: --
637: fnd_message.set_name('BEN','BEN_92426_CVG_THRU_DT_NOT_FND');
638: fnd_message.set_token('PROC',l_proc);
639: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
640: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
641: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 638: fnd_message.set_token('PROC',l_proc);

634: -- Problem with eligibility setup. The person has to be
635: -- previously enrolled to be eligible for the COBRA program.
636: --
637: fnd_message.set_name('BEN','BEN_92426_CVG_THRU_DT_NOT_FND');
638: fnd_message.set_token('PROC',l_proc);
639: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
640: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
641: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
642: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 639: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

635: -- previously enrolled to be eligible for the COBRA program.
636: --
637: fnd_message.set_name('BEN','BEN_92426_CVG_THRU_DT_NOT_FND');
638: fnd_message.set_token('PROC',l_proc);
639: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
640: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
641: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
642: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
643: fnd_message.raise_error;

Line 640: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

636: --
637: fnd_message.set_name('BEN','BEN_92426_CVG_THRU_DT_NOT_FND');
638: fnd_message.set_token('PROC',l_proc);
639: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
640: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
641: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
642: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
643: fnd_message.raise_error;
644: else

Line 641: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

637: fnd_message.set_name('BEN','BEN_92426_CVG_THRU_DT_NOT_FND');
638: fnd_message.set_token('PROC',l_proc);
639: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
640: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
641: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
642: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
643: fnd_message.raise_error;
644: else
645: close c_get_enrt_cvg_strt_dt;

Line 642: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

638: fnd_message.set_token('PROC',l_proc);
639: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
640: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
641: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
642: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
643: fnd_message.raise_error;
644: else
645: close c_get_enrt_cvg_strt_dt;
646: p_cbr_elig_perd_strt_dt := l_enrt_cvg_strt_dt;

Line 643: fnd_message.raise_error;

639: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
640: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
641: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
642: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
643: fnd_message.raise_error;
644: else
645: close c_get_enrt_cvg_strt_dt;
646: p_cbr_elig_perd_strt_dt := l_enrt_cvg_strt_dt;
647: hr_utility.set_location('l_enrt_cvg_strt_dt prtn:'|| l_enrt_cvg_strt_dt, 10);

Line 957: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');

953: --
954: -- Person was not disabled at the time of the qualifying
955: -- event so the end of disabity event is not valid.
956: --
957: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
958: fnd_message.set_token('PROC',l_proc);
959: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
960: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
961: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

Line 958: fnd_message.set_token('PROC',l_proc);

954: -- Person was not disabled at the time of the qualifying
955: -- event so the end of disabity event is not valid.
956: --
957: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
958: fnd_message.set_token('PROC',l_proc);
959: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
960: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
961: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
962: if fnd_global.conc_request_id <> -1 then

Line 959: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

955: -- event so the end of disabity event is not valid.
956: --
957: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
958: fnd_message.set_token('PROC',l_proc);
959: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
960: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
961: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
962: if fnd_global.conc_request_id <> -1 then
963: benutils.write(fnd_message.get);

Line 960: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

956: --
957: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
958: fnd_message.set_token('PROC',l_proc);
959: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
960: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
961: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
962: if fnd_global.conc_request_id <> -1 then
963: benutils.write(fnd_message.get);
964: end if;

Line 961: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

957: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
958: fnd_message.set_token('PROC',l_proc);
959: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
960: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
961: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
962: if fnd_global.conc_request_id <> -1 then
963: benutils.write(fnd_message.get);
964: end if;
965: end if;

Line 963: benutils.write(fnd_message.get);

959: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
960: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
961: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
962: if fnd_global.conc_request_id <> -1 then
963: benutils.write(fnd_message.get);
964: end if;
965: end if;
966: --
967: else

Line 974: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');

970: p_old_cbr_elig_perd_end_dt := null;
971: p_cbr_quald_bnf_id := null;
972: p_cqb_object_version_number := null;
973: p_cvrd_emp_person_id := null;
974: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
975: fnd_message.set_token('PROC',l_proc);
976: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
977: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
978: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

Line 975: fnd_message.set_token('PROC',l_proc);

971: p_cbr_quald_bnf_id := null;
972: p_cqb_object_version_number := null;
973: p_cvrd_emp_person_id := null;
974: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
975: fnd_message.set_token('PROC',l_proc);
976: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
977: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
978: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
979: if fnd_global.conc_request_id <> -1 then

Line 976: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

972: p_cqb_object_version_number := null;
973: p_cvrd_emp_person_id := null;
974: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
975: fnd_message.set_token('PROC',l_proc);
976: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
977: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
978: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
979: if fnd_global.conc_request_id <> -1 then
980: benutils.write(fnd_message.get);

Line 977: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

973: p_cvrd_emp_person_id := null;
974: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
975: fnd_message.set_token('PROC',l_proc);
976: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
977: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
978: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
979: if fnd_global.conc_request_id <> -1 then
980: benutils.write(fnd_message.get);
981: end if;

Line 978: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

974: fnd_message.set_name('BEN','BEN_92970_CBR_PER_NOT_DSBLD');
975: fnd_message.set_token('PROC',l_proc);
976: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
977: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
978: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
979: if fnd_global.conc_request_id <> -1 then
980: benutils.write(fnd_message.get);
981: end if;
982: end if;

Line 980: benutils.write(fnd_message.get);

976: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
977: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
978: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
979: if fnd_global.conc_request_id <> -1 then
980: benutils.write(fnd_message.get);
981: end if;
982: end if;
983: close c_get_init_ler;
984: --

Line 1447: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');

1443: ,p_validate => p_validate
1444: );
1445: else
1446: --
1447: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1448: fnd_message.set_token('PROC',l_proc);
1449: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1450: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1451: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

Line 1448: fnd_message.set_token('PROC',l_proc);

1444: );
1445: else
1446: --
1447: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1448: fnd_message.set_token('PROC',l_proc);
1449: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1450: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1451: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1452: if fnd_global.conc_request_id <> -1 then

Line 1449: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1445: else
1446: --
1447: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1448: fnd_message.set_token('PROC',l_proc);
1449: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1450: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1451: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1452: if fnd_global.conc_request_id <> -1 then
1453: benutils.write(fnd_message.get);

Line 1450: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

1446: --
1447: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1448: fnd_message.set_token('PROC',l_proc);
1449: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1450: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1451: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1452: if fnd_global.conc_request_id <> -1 then
1453: benutils.write(fnd_message.get);
1454: end if;

Line 1451: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

1447: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1448: fnd_message.set_token('PROC',l_proc);
1449: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1450: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1451: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1452: if fnd_global.conc_request_id <> -1 then
1453: benutils.write(fnd_message.get);
1454: end if;
1455: --

Line 1453: benutils.write(fnd_message.get);

1449: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1450: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1451: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1452: if fnd_global.conc_request_id <> -1 then
1453: benutils.write(fnd_message.get);
1454: end if;
1455: --
1456: end if;
1457: l_pgm_id := l_epe_rec.pgm_id;

Line 1519: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');

1515: );
1516: --
1517: else
1518: --
1519: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1520: fnd_message.set_token('PROC',l_proc);
1521: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1522: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1523: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

Line 1520: fnd_message.set_token('PROC',l_proc);

1516: --
1517: else
1518: --
1519: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1520: fnd_message.set_token('PROC',l_proc);
1521: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1522: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1523: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1524: --

Line 1521: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1517: else
1518: --
1519: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1520: fnd_message.set_token('PROC',l_proc);
1521: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1522: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1523: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1524: --
1525: if fnd_global.conc_request_id <> -1 then

Line 1522: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

1518: --
1519: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1520: fnd_message.set_token('PROC',l_proc);
1521: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1522: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1523: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1524: --
1525: if fnd_global.conc_request_id <> -1 then
1526: benutils.write(fnd_message.get);

Line 1523: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

1519: fnd_message.set_name('BEN','BEN_92428_CBR_DATES_NOT_FOUND');
1520: fnd_message.set_token('PROC',l_proc);
1521: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1522: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1523: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1524: --
1525: if fnd_global.conc_request_id <> -1 then
1526: benutils.write(fnd_message.get);
1527: end if;

Line 1526: benutils.write(fnd_message.get);

1522: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1523: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1524: --
1525: if fnd_global.conc_request_id <> -1 then
1526: benutils.write(fnd_message.get);
1527: end if;
1528: end if;
1529: --
1530: l_ptip_id := l_epe_rec.ptip_id;

Line 1891: fnd_message.set_name('BEN','BEN_92429_CVRD_EMP_NOT_FOUND');

1887: if c_get_cvrd_emp_person_id%notfound then
1888: --
1889: close c_get_cvrd_emp_person_id;
1890: --
1891: fnd_message.set_name('BEN','BEN_92429_CVRD_EMP_NOT_FOUND');
1892: --fnd_message.set_token('PROC',l_proc);
1893: fnd_message.raise_error;
1894: else
1895: close c_get_cvrd_emp_person_id;

Line 1892: --fnd_message.set_token('PROC',l_proc);

1888: --
1889: close c_get_cvrd_emp_person_id;
1890: --
1891: fnd_message.set_name('BEN','BEN_92429_CVRD_EMP_NOT_FOUND');
1892: --fnd_message.set_token('PROC',l_proc);
1893: fnd_message.raise_error;
1894: else
1895: close c_get_cvrd_emp_person_id;
1896: end if;

Line 1893: fnd_message.raise_error;

1889: close c_get_cvrd_emp_person_id;
1890: --
1891: fnd_message.set_name('BEN','BEN_92429_CVRD_EMP_NOT_FOUND');
1892: --fnd_message.set_token('PROC',l_proc);
1893: fnd_message.raise_error;
1894: else
1895: close c_get_cvrd_emp_person_id;
1896: end if;
1897: --

Line 2077: fnd_message.set_name('BEN','BEN_92429_CVRD_EMP_NOT_FOUND');

2073: if c_get_cvrd_emp_person_id%notfound then
2074: --
2075: close c_get_cvrd_emp_person_id;
2076: --
2077: fnd_message.set_name('BEN','BEN_92429_CVRD_EMP_NOT_FOUND');
2078: --fnd_message.set_token('PROC',l_proc);
2079: fnd_message.raise_error;
2080: else
2081: close c_get_cvrd_emp_person_id;

Line 2078: --fnd_message.set_token('PROC',l_proc);

2074: --
2075: close c_get_cvrd_emp_person_id;
2076: --
2077: fnd_message.set_name('BEN','BEN_92429_CVRD_EMP_NOT_FOUND');
2078: --fnd_message.set_token('PROC',l_proc);
2079: fnd_message.raise_error;
2080: else
2081: close c_get_cvrd_emp_person_id;
2082: end if;

Line 2079: fnd_message.raise_error;

2075: close c_get_cvrd_emp_person_id;
2076: --
2077: fnd_message.set_name('BEN','BEN_92429_CVRD_EMP_NOT_FOUND');
2078: --fnd_message.set_token('PROC',l_proc);
2079: fnd_message.raise_error;
2080: else
2081: close c_get_cvrd_emp_person_id;
2082: end if;
2083: --