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_ENROLLMENT_PROCESS dependencies on FND_MESSAGE

Line 178: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');

174: CLOSE c_pil;
175: if g_debug then
176: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
177: end if;
178: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
179: fnd_message.set_token('PROC',l_proc);
180: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
181: fnd_message.set_token('LER_ID',to_char(p_ler_id));
182: fnd_message.set_token('LE_DATE', p_life_event_date);

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

175: if g_debug then
176: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
177: end if;
178: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
179: fnd_message.set_token('PROC',l_proc);
180: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
181: fnd_message.set_token('LER_ID',to_char(p_ler_id));
182: fnd_message.set_token('LE_DATE', p_life_event_date);
183: fnd_message.raise_error;

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

176: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
177: end if;
178: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
179: fnd_message.set_token('PROC',l_proc);
180: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
181: fnd_message.set_token('LER_ID',to_char(p_ler_id));
182: fnd_message.set_token('LE_DATE', p_life_event_date);
183: fnd_message.raise_error;
184: --

Line 181: fnd_message.set_token('LER_ID',to_char(p_ler_id));

177: end if;
178: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
179: fnd_message.set_token('PROC',l_proc);
180: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
181: fnd_message.set_token('LER_ID',to_char(p_ler_id));
182: fnd_message.set_token('LE_DATE', p_life_event_date);
183: fnd_message.raise_error;
184: --
185: END IF;

Line 182: fnd_message.set_token('LE_DATE', p_life_event_date);

178: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
179: fnd_message.set_token('PROC',l_proc);
180: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
181: fnd_message.set_token('LER_ID',to_char(p_ler_id));
182: fnd_message.set_token('LE_DATE', p_life_event_date);
183: fnd_message.raise_error;
184: --
185: END IF;
186: CLOSE c_pil;

Line 183: fnd_message.raise_error;

179: fnd_message.set_token('PROC',l_proc);
180: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
181: fnd_message.set_token('LER_ID',to_char(p_ler_id));
182: fnd_message.set_token('LE_DATE', p_life_event_date);
183: fnd_message.raise_error;
184: --
185: END IF;
186: CLOSE c_pil;
187: --

Line 220: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');

216: CLOSE c_epe_oipl ;
217: if g_debug then
218: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);
219: end if;
220: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
221: fnd_message.set_token('PROC',l_proc);
222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
224: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

217: if g_debug then
218: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);
219: end if;
220: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
221: fnd_message.set_token('PROC',l_proc);
222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
224: fnd_message.set_token('PL_ID',to_char(p_pl_id));
225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

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

218: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);
219: end if;
220: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
221: fnd_message.set_token('PROC',l_proc);
222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
224: fnd_message.set_token('PL_ID',to_char(p_pl_id));
225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
226: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

219: end if;
220: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
221: fnd_message.set_token('PROC',l_proc);
222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
224: fnd_message.set_token('PL_ID',to_char(p_pl_id));
225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
226: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
227: fnd_message.set_token('LE_DATE',p_life_event_date);

Line 224: fnd_message.set_token('PL_ID',to_char(p_pl_id));

220: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
221: fnd_message.set_token('PROC',l_proc);
222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
224: fnd_message.set_token('PL_ID',to_char(p_pl_id));
225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
226: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
227: fnd_message.set_token('LE_DATE',p_life_event_date);
228: fnd_message.raise_error;

Line 225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

221: fnd_message.set_token('PROC',l_proc);
222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
224: fnd_message.set_token('PL_ID',to_char(p_pl_id));
225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
226: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
227: fnd_message.set_token('LE_DATE',p_life_event_date);
228: fnd_message.raise_error;
229: --

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

222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
224: fnd_message.set_token('PL_ID',to_char(p_pl_id));
225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
226: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
227: fnd_message.set_token('LE_DATE',p_life_event_date);
228: fnd_message.raise_error;
229: --
230: END IF;

Line 227: fnd_message.set_token('LE_DATE',p_life_event_date);

223: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
224: fnd_message.set_token('PL_ID',to_char(p_pl_id));
225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
226: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
227: fnd_message.set_token('LE_DATE',p_life_event_date);
228: fnd_message.raise_error;
229: --
230: END IF;
231: --

Line 228: fnd_message.raise_error;

224: fnd_message.set_token('PL_ID',to_char(p_pl_id));
225: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
226: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
227: fnd_message.set_token('LE_DATE',p_life_event_date);
228: fnd_message.raise_error;
229: --
230: END IF;
231: --
232: CLOSE c_epe_oipl ;

Line 245: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');

241: CLOSE c_epe_pl ;
242: if g_debug then
243: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);
244: end if;
245: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
246: fnd_message.set_token('PROC',l_proc);
247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
249: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

242: if g_debug then
243: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);
244: end if;
245: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
246: fnd_message.set_token('PROC',l_proc);
247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
249: fnd_message.set_token('PL_ID',to_char(p_pl_id));
250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

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

243: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);
244: end if;
245: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
246: fnd_message.set_token('PROC',l_proc);
247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
249: fnd_message.set_token('PL_ID',to_char(p_pl_id));
250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
251: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

244: end if;
245: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
246: fnd_message.set_token('PROC',l_proc);
247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
249: fnd_message.set_token('PL_ID',to_char(p_pl_id));
250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
251: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
252: fnd_message.set_token('LE_DATE',p_life_event_date);

Line 249: fnd_message.set_token('PL_ID',to_char(p_pl_id));

245: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
246: fnd_message.set_token('PROC',l_proc);
247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
249: fnd_message.set_token('PL_ID',to_char(p_pl_id));
250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
251: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
252: fnd_message.set_token('LE_DATE',p_life_event_date);
253: fnd_message.raise_error;

Line 250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

246: fnd_message.set_token('PROC',l_proc);
247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
249: fnd_message.set_token('PL_ID',to_char(p_pl_id));
250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
251: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
252: fnd_message.set_token('LE_DATE',p_life_event_date);
253: fnd_message.raise_error;
254: --

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

247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
249: fnd_message.set_token('PL_ID',to_char(p_pl_id));
250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
251: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
252: fnd_message.set_token('LE_DATE',p_life_event_date);
253: fnd_message.raise_error;
254: --
255: END IF;

Line 252: fnd_message.set_token('LE_DATE',p_life_event_date);

248: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
249: fnd_message.set_token('PL_ID',to_char(p_pl_id));
250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
251: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
252: fnd_message.set_token('LE_DATE',p_life_event_date);
253: fnd_message.raise_error;
254: --
255: END IF;
256: --

Line 253: fnd_message.raise_error;

249: fnd_message.set_token('PL_ID',to_char(p_pl_id));
250: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
251: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
252: fnd_message.set_token('LE_DATE',p_life_event_date);
253: fnd_message.raise_error;
254: --
255: END IF;
256: --
257: CLOSE c_epe_pl ;

Line 290: fnd_message.set_name('BEN','BEN_94616_DPNT_WRONG');

286: CLOSE c_egd ;
287: if g_debug then
288: hr_utility.set_location('BEN_94616_DPNT_WRONG',54);
289: end if;
290: fnd_message.set_name('BEN','BEN_94616_DPNT_WRONG');
291: fnd_message.set_token('PROC',l_proc);
292: fnd_message.raise_error;
293: --
294: END IF;

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

287: if g_debug then
288: hr_utility.set_location('BEN_94616_DPNT_WRONG',54);
289: end if;
290: fnd_message.set_name('BEN','BEN_94616_DPNT_WRONG');
291: fnd_message.set_token('PROC',l_proc);
292: fnd_message.raise_error;
293: --
294: END IF;
295: --

Line 292: fnd_message.raise_error;

288: hr_utility.set_location('BEN_94616_DPNT_WRONG',54);
289: end if;
290: fnd_message.set_name('BEN','BEN_94616_DPNT_WRONG');
291: fnd_message.set_token('PROC',l_proc);
292: fnd_message.raise_error;
293: --
294: END IF;
295: --
296: close c_egd ;

Line 328: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');

324: CLOSE c_pen ;
325: if g_debug then
326: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);
327: end if;
328: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');
329: fnd_message.set_token('PROC',l_proc);
330: fnd_message.raise_error;
331: --
332: END IF;

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

325: if g_debug then
326: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);
327: end if;
328: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');
329: fnd_message.set_token('PROC',l_proc);
330: fnd_message.raise_error;
331: --
332: END IF;
333: --

Line 330: fnd_message.raise_error;

326: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);
327: end if;
328: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');
329: fnd_message.set_token('PROC',l_proc);
330: fnd_message.raise_error;
331: --
332: END IF;
333: --
334: close c_pen ;

Line 340: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');

336: --
337: if g_debug then
338: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);
339: end if;
340: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');
341: fnd_message.set_token('PROC',l_proc);
342: fnd_message.raise_error;
343: --
344: END IF;

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

337: if g_debug then
338: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);
339: end if;
340: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');
341: fnd_message.set_token('PROC',l_proc);
342: fnd_message.raise_error;
343: --
344: END IF;
345: --

Line 342: fnd_message.raise_error;

338: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);
339: end if;
340: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');
341: fnd_message.set_token('PROC',l_proc);
342: fnd_message.raise_error;
343: --
344: END IF;
345: --
346: end check_pen ;

Line 366: fnd_message.set_name('BEN','BEN_94617_NO_BNF_PERSON');

362: --
363: if g_debug then
364: hr_utility.set_location('BEN_94617_NO_BNF_PERSON',54);
365: end if;
366: fnd_message.set_name('BEN','BEN_94617_NO_BNF_PERSON');
367: fnd_message.set_token('PROC',l_proc);
368: fnd_message.raise_error;
369: --
370: END IF;

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

363: if g_debug then
364: hr_utility.set_location('BEN_94617_NO_BNF_PERSON',54);
365: end if;
366: fnd_message.set_name('BEN','BEN_94617_NO_BNF_PERSON');
367: fnd_message.set_token('PROC',l_proc);
368: fnd_message.raise_error;
369: --
370: END IF;
371: --Get PIL

Line 368: fnd_message.raise_error;

364: hr_utility.set_location('BEN_94617_NO_BNF_PERSON',54);
365: end if;
366: fnd_message.set_name('BEN','BEN_94617_NO_BNF_PERSON');
367: fnd_message.set_token('PROC',l_proc);
368: fnd_message.raise_error;
369: --
370: END IF;
371: --Get PIL
372: IF p_organization_id IS NOT NULL THEN

Line 863: fnd_message.set_name('BEN','BEN_94552_NO_CVG_STRT_DT');

859: --Throw Error.. Coverage start date needs to be entered
860: if g_debug then
861: hr_utility.set_location('BEN_94552_NO_CVG_STRT_DT'|| to_char(p_person_id),54);
862: end if;
863: fnd_message.set_name('BEN','BEN_94552_NO_CVG_STRT_DT');
864: fnd_message.set_token('PACKAGE',l_proc);
865: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
866: fnd_message.set_token('LER_ID', to_char(p_ler_id));
867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 864: fnd_message.set_token('PACKAGE',l_proc);

860: if g_debug then
861: hr_utility.set_location('BEN_94552_NO_CVG_STRT_DT'|| to_char(p_person_id),54);
862: end if;
863: fnd_message.set_name('BEN','BEN_94552_NO_CVG_STRT_DT');
864: fnd_message.set_token('PACKAGE',l_proc);
865: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
866: fnd_message.set_token('LER_ID', to_char(p_ler_id));
867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
868: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

861: hr_utility.set_location('BEN_94552_NO_CVG_STRT_DT'|| to_char(p_person_id),54);
862: end if;
863: fnd_message.set_name('BEN','BEN_94552_NO_CVG_STRT_DT');
864: fnd_message.set_token('PACKAGE',l_proc);
865: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
866: fnd_message.set_token('LER_ID', to_char(p_ler_id));
867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
868: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
869: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 866: fnd_message.set_token('LER_ID', to_char(p_ler_id));

862: end if;
863: fnd_message.set_name('BEN','BEN_94552_NO_CVG_STRT_DT');
864: fnd_message.set_token('PACKAGE',l_proc);
865: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
866: fnd_message.set_token('LER_ID', to_char(p_ler_id));
867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
868: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
869: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
870: fnd_message.raise_error;

Line 867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

863: fnd_message.set_name('BEN','BEN_94552_NO_CVG_STRT_DT');
864: fnd_message.set_token('PACKAGE',l_proc);
865: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
866: fnd_message.set_token('LER_ID', to_char(p_ler_id));
867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
868: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
869: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
870: fnd_message.raise_error;
871: --

Line 868: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

864: fnd_message.set_token('PACKAGE',l_proc);
865: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
866: fnd_message.set_token('LER_ID', to_char(p_ler_id));
867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
868: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
869: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
870: fnd_message.raise_error;
871: --
872: END IF;

Line 869: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

865: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
866: fnd_message.set_token('LER_ID', to_char(p_ler_id));
867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
868: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
869: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
870: fnd_message.raise_error;
871: --
872: END IF;
873: --

Line 870: fnd_message.raise_error;

866: fnd_message.set_token('LER_ID', to_char(p_ler_id));
867: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
868: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
869: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
870: fnd_message.raise_error;
871: --
872: END IF;
873: --
874: ELSE

Line 900: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');

896: CLOSE c_enb_with_amt ;
897: if g_debug then
898: hr_utility.set_location('BEN_91561_BENVRBRT_ENB_NF'|| to_char(p_person_id),54);
899: end if;
900: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
901: fnd_message.set_token('PACKAGE',l_proc);
902: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
904: fnd_message.set_token('PL_ID', to_char(p_pl_id));

Line 901: fnd_message.set_token('PACKAGE',l_proc);

897: if g_debug then
898: hr_utility.set_location('BEN_91561_BENVRBRT_ENB_NF'|| to_char(p_person_id),54);
899: end if;
900: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
901: fnd_message.set_token('PACKAGE',l_proc);
902: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
904: fnd_message.set_token('PL_ID', to_char(p_pl_id));
905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

898: hr_utility.set_location('BEN_91561_BENVRBRT_ENB_NF'|| to_char(p_person_id),54);
899: end if;
900: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
901: fnd_message.set_token('PACKAGE',l_proc);
902: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
904: fnd_message.set_token('PL_ID', to_char(p_pl_id));
905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);

Line 903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

899: end if;
900: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
901: fnd_message.set_token('PACKAGE',l_proc);
902: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
904: fnd_message.set_token('PL_ID', to_char(p_pl_id));
905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);
907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 904: fnd_message.set_token('PL_ID', to_char(p_pl_id));

900: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
901: fnd_message.set_token('PACKAGE',l_proc);
902: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
904: fnd_message.set_token('PL_ID', to_char(p_pl_id));
905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);
907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
908: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));

Line 905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

901: fnd_message.set_token('PACKAGE',l_proc);
902: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
904: fnd_message.set_token('PL_ID', to_char(p_pl_id));
905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);
907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
908: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
909: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID', to_char(l_epe.elig_per_elctbl_chc_id));

Line 906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);

902: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
904: fnd_message.set_token('PL_ID', to_char(p_pl_id));
905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);
907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
908: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
909: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID', to_char(l_epe.elig_per_elctbl_chc_id));
910: fnd_message.raise_error;

Line 907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

903: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
904: fnd_message.set_token('PL_ID', to_char(p_pl_id));
905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);
907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
908: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
909: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID', to_char(l_epe.elig_per_elctbl_chc_id));
910: fnd_message.raise_error;
911: --

Line 908: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));

904: fnd_message.set_token('PL_ID', to_char(p_pl_id));
905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);
907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
908: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
909: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID', to_char(l_epe.elig_per_elctbl_chc_id));
910: fnd_message.raise_error;
911: --
912: ELSE

Line 909: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID', to_char(l_epe.elig_per_elctbl_chc_id));

905: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);
907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
908: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
909: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID', to_char(l_epe.elig_per_elctbl_chc_id));
910: fnd_message.raise_error;
911: --
912: ELSE
913: --

Line 910: fnd_message.raise_error;

906: fnd_message.set_token('LF_EVT_OCRD_DT',p_life_event_date);
907: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
908: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
909: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID', to_char(l_epe.elig_per_elctbl_chc_id));
910: fnd_message.raise_error;
911: --
912: ELSE
913: --
914: --Check check to see if the coverage calculation method requires the benefit amount.

Line 925: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');

921: CLOSE c_enb_with_amt ;
922: if g_debug then
923: hr_utility.set_location('BEN_94558_INVALID_BNFT_VAL'|| to_char(p_person_id),54);
924: end if;
925: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
926: fnd_message.set_token('PROC',l_proc);
927: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
928: fnd_message.set_token('LER_ID',to_char(p_ler_id));
929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

922: if g_debug then
923: hr_utility.set_location('BEN_94558_INVALID_BNFT_VAL'|| to_char(p_person_id),54);
924: end if;
925: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
926: fnd_message.set_token('PROC',l_proc);
927: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
928: fnd_message.set_token('LER_ID',to_char(p_ler_id));
929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
930: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

923: hr_utility.set_location('BEN_94558_INVALID_BNFT_VAL'|| to_char(p_person_id),54);
924: end if;
925: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
926: fnd_message.set_token('PROC',l_proc);
927: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
928: fnd_message.set_token('LER_ID',to_char(p_ler_id));
929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
930: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
931: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 928: fnd_message.set_token('LER_ID',to_char(p_ler_id));

924: end if;
925: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
926: fnd_message.set_token('PROC',l_proc);
927: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
928: fnd_message.set_token('LER_ID',to_char(p_ler_id));
929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
930: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
931: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
932: fnd_message.raise_error;

Line 929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

925: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
926: fnd_message.set_token('PROC',l_proc);
927: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
928: fnd_message.set_token('LER_ID',to_char(p_ler_id));
929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
930: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
931: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
932: fnd_message.raise_error;
933: --

Line 930: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

926: fnd_message.set_token('PROC',l_proc);
927: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
928: fnd_message.set_token('LER_ID',to_char(p_ler_id));
929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
930: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
931: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
932: fnd_message.raise_error;
933: --
934: END IF;

Line 931: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

927: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
928: fnd_message.set_token('LER_ID',to_char(p_ler_id));
929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
930: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
931: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
932: fnd_message.raise_error;
933: --
934: END IF;
935: --

Line 932: fnd_message.raise_error;

928: fnd_message.set_token('LER_ID',to_char(p_ler_id));
929: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
930: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
931: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
932: fnd_message.raise_error;
933: --
934: END IF;
935: --
936: END IF;

Line 954: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');

950: open c_pl_opt_name(l_epe.elig_per_elctbl_chc_id);
951: fetch c_pl_opt_name into l_pl_opt_name;
952: close c_pl_opt_name;
953: --
954: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
955: fnd_message.set_token('MINIMUM', l_enb.mn_val);
956: fnd_message.set_token('MAXIMUM', l_enb.mx_val);
957: fnd_message.set_token('PLAN', l_pl_opt_name);
958: fnd_message.raise_error;

Line 955: fnd_message.set_token('MINIMUM', l_enb.mn_val);

951: fetch c_pl_opt_name into l_pl_opt_name;
952: close c_pl_opt_name;
953: --
954: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
955: fnd_message.set_token('MINIMUM', l_enb.mn_val);
956: fnd_message.set_token('MAXIMUM', l_enb.mx_val);
957: fnd_message.set_token('PLAN', l_pl_opt_name);
958: fnd_message.raise_error;
959: --

Line 956: fnd_message.set_token('MAXIMUM', l_enb.mx_val);

952: close c_pl_opt_name;
953: --
954: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
955: fnd_message.set_token('MINIMUM', l_enb.mn_val);
956: fnd_message.set_token('MAXIMUM', l_enb.mx_val);
957: fnd_message.set_token('PLAN', l_pl_opt_name);
958: fnd_message.raise_error;
959: --
960: end if;

Line 957: fnd_message.set_token('PLAN', l_pl_opt_name);

953: --
954: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
955: fnd_message.set_token('MINIMUM', l_enb.mn_val);
956: fnd_message.set_token('MAXIMUM', l_enb.mx_val);
957: fnd_message.set_token('PLAN', l_pl_opt_name);
958: fnd_message.raise_error;
959: --
960: end if;
961: --

Line 958: fnd_message.raise_error;

954: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
955: fnd_message.set_token('MINIMUM', l_enb.mn_val);
956: fnd_message.set_token('MAXIMUM', l_enb.mx_val);
957: fnd_message.set_token('PLAN', l_pl_opt_name);
958: fnd_message.raise_error;
959: --
960: end if;
961: --
962: if l_enb.mn_val is not null and

Line 972: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');

968: open c_pl_opt_name(l_epe.elig_per_elctbl_chc_id);
969: fetch c_pl_opt_name into l_pl_opt_name;
970: close c_pl_opt_name;
971: --
972: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
973: fnd_message.set_token('INCREMENT', l_enb.incrmt_val);
974: fnd_message.set_token('PLAN', l_pl_opt_name);
975: fnd_message.raise_error;
976: --

Line 973: fnd_message.set_token('INCREMENT', l_enb.incrmt_val);

969: fetch c_pl_opt_name into l_pl_opt_name;
970: close c_pl_opt_name;
971: --
972: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
973: fnd_message.set_token('INCREMENT', l_enb.incrmt_val);
974: fnd_message.set_token('PLAN', l_pl_opt_name);
975: fnd_message.raise_error;
976: --
977: end if;

Line 974: fnd_message.set_token('PLAN', l_pl_opt_name);

970: close c_pl_opt_name;
971: --
972: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
973: fnd_message.set_token('INCREMENT', l_enb.incrmt_val);
974: fnd_message.set_token('PLAN', l_pl_opt_name);
975: fnd_message.raise_error;
976: --
977: end if;
978: --

Line 975: fnd_message.raise_error;

971: --
972: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
973: fnd_message.set_token('INCREMENT', l_enb.incrmt_val);
974: fnd_message.set_token('PLAN', l_pl_opt_name);
975: fnd_message.raise_error;
976: --
977: end if;
978: --
979: end if;

Line 993: fnd_message.set_name('BEN','BEN_94559_NO_BNFT_VAL');

989: if g_debug then
990: hr_utility.set_location('BEN_94559_NO_BNFT_VAL'|| to_char(p_person_id),54);
991: end if;
992: CLOSE c_enb ;
993: fnd_message.set_name('BEN','BEN_94559_NO_BNFT_VAL');
994: fnd_message.set_token('PROC',l_proc);
995: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
996: fnd_message.set_token('LER_ID',to_char(p_ler_id));
997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

990: hr_utility.set_location('BEN_94559_NO_BNFT_VAL'|| to_char(p_person_id),54);
991: end if;
992: CLOSE c_enb ;
993: fnd_message.set_name('BEN','BEN_94559_NO_BNFT_VAL');
994: fnd_message.set_token('PROC',l_proc);
995: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
996: fnd_message.set_token('LER_ID',to_char(p_ler_id));
997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
998: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

991: end if;
992: CLOSE c_enb ;
993: fnd_message.set_name('BEN','BEN_94559_NO_BNFT_VAL');
994: fnd_message.set_token('PROC',l_proc);
995: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
996: fnd_message.set_token('LER_ID',to_char(p_ler_id));
997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
998: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
999: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 996: fnd_message.set_token('LER_ID',to_char(p_ler_id));

992: CLOSE c_enb ;
993: fnd_message.set_name('BEN','BEN_94559_NO_BNFT_VAL');
994: fnd_message.set_token('PROC',l_proc);
995: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
996: fnd_message.set_token('LER_ID',to_char(p_ler_id));
997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
998: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
999: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1000: fnd_message.raise_error;

Line 997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

993: fnd_message.set_name('BEN','BEN_94559_NO_BNFT_VAL');
994: fnd_message.set_token('PROC',l_proc);
995: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
996: fnd_message.set_token('LER_ID',to_char(p_ler_id));
997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
998: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
999: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1000: fnd_message.raise_error;
1001: --

Line 998: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

994: fnd_message.set_token('PROC',l_proc);
995: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
996: fnd_message.set_token('LER_ID',to_char(p_ler_id));
997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
998: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
999: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1000: fnd_message.raise_error;
1001: --
1002: END IF;

Line 999: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

995: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
996: fnd_message.set_token('LER_ID',to_char(p_ler_id));
997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
998: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
999: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1000: fnd_message.raise_error;
1001: --
1002: END IF;
1003: CLOSE c_enb ;

Line 1000: fnd_message.raise_error;

996: fnd_message.set_token('LER_ID',to_char(p_ler_id));
997: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
998: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
999: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1000: fnd_message.raise_error;
1001: --
1002: END IF;
1003: CLOSE c_enb ;
1004: --

Line 1046: fnd_message.set_name('BEN','APP_94555_NO_RATE_VAL');

1042: --
1043: if g_debug then
1044: hr_utility.set_location('APP_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1045: end if;
1046: fnd_message.set_name('BEN','APP_94555_NO_RATE_VAL');
1047: fnd_message.set_token('PROC',l_proc);
1048: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

1043: if g_debug then
1044: hr_utility.set_location('APP_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1045: end if;
1046: fnd_message.set_name('BEN','APP_94555_NO_RATE_VAL');
1047: fnd_message.set_token('PROC',l_proc);
1048: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1051: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1044: hr_utility.set_location('APP_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1045: end if;
1046: fnd_message.set_name('BEN','APP_94555_NO_RATE_VAL');
1047: fnd_message.set_token('PROC',l_proc);
1048: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1051: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1052: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));

1045: end if;
1046: fnd_message.set_name('BEN','APP_94555_NO_RATE_VAL');
1047: fnd_message.set_token('PROC',l_proc);
1048: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1051: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1052: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1053: fnd_message.raise_error;

Line 1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1046: fnd_message.set_name('BEN','APP_94555_NO_RATE_VAL');
1047: fnd_message.set_token('PROC',l_proc);
1048: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1051: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1052: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1053: fnd_message.raise_error;
1054: --

Line 1051: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1047: fnd_message.set_token('PROC',l_proc);
1048: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1051: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1052: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1053: fnd_message.raise_error;
1054: --
1055: END IF;

Line 1052: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1048: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1051: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1052: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1053: fnd_message.raise_error;
1054: --
1055: END IF;
1056:

Line 1053: fnd_message.raise_error;

1049: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1050: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1051: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1052: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1053: fnd_message.raise_error;
1054: --
1055: END IF;
1056:
1057: END IF ;

Line 1074: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');

1070: CLOSE c_ecr_enb ;
1071: if g_debug then
1072: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1073: end if;
1074: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1075: fnd_message.set_token('PROC',l_proc);
1076: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1077: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1078: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));

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

1071: if g_debug then
1072: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1073: end if;
1074: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1075: fnd_message.set_token('PROC',l_proc);
1076: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1077: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1078: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1079: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));

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

1072: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1073: end if;
1074: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1075: fnd_message.set_token('PROC',l_proc);
1076: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1077: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1078: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1079: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1080: fnd_message.raise_error;

Line 1077: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));

1073: end if;
1074: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1075: fnd_message.set_token('PROC',l_proc);
1076: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1077: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1078: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1079: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1080: fnd_message.raise_error;
1081: --

Line 1078: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));

1074: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1075: fnd_message.set_token('PROC',l_proc);
1076: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1077: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1078: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1079: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1080: fnd_message.raise_error;
1081: --
1082: ELSE

Line 1079: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));

1075: fnd_message.set_token('PROC',l_proc);
1076: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1077: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1078: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1079: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1080: fnd_message.raise_error;
1081: --
1082: ELSE
1083: --

Line 1080: fnd_message.raise_error;

1076: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1077: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1078: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1079: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1080: fnd_message.raise_error;
1081: --
1082: ELSE
1083: --
1084: IF l_ecr1.rt_strt_dt_cd = 'ENTRBL' THEN

Line 1095: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');

1091: if g_debug then
1092: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1093: end if;
1094: CLOSE c_ecr_enb;
1095: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1096: fnd_message.set_token('PACKAGE',l_proc);
1097: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1096: fnd_message.set_token('PACKAGE',l_proc);

1092: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1093: end if;
1094: CLOSE c_ecr_enb;
1095: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1096: fnd_message.set_token('PACKAGE',l_proc);
1097: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1100: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1093: end if;
1094: CLOSE c_ecr_enb;
1095: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1096: fnd_message.set_token('PACKAGE',l_proc);
1097: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1100: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1101: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1094: CLOSE c_ecr_enb;
1095: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1096: fnd_message.set_token('PACKAGE',l_proc);
1097: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1100: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1101: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1102: fnd_message.raise_error;

Line 1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1095: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1096: fnd_message.set_token('PACKAGE',l_proc);
1097: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1100: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1101: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1102: fnd_message.raise_error;
1103: --

Line 1100: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1096: fnd_message.set_token('PACKAGE',l_proc);
1097: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1100: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1101: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1102: fnd_message.raise_error;
1103: --
1104: END IF;

Line 1101: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1097: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1100: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1101: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1102: fnd_message.raise_error;
1103: --
1104: END IF;
1105: END IF;

Line 1102: fnd_message.raise_error;

1098: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1099: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1100: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1101: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1102: fnd_message.raise_error;
1103: --
1104: END IF;
1105: END IF;
1106: --

Line 1118: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');

1114: if g_debug then
1115: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1116: end if;
1117: CLOSE c_ecr_enb;
1118: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1119: fnd_message.set_token('PACKAGE',l_proc);
1120: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1119: fnd_message.set_token('PACKAGE',l_proc);

1115: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1116: end if;
1117: CLOSE c_ecr_enb;
1118: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1119: fnd_message.set_token('PACKAGE',l_proc);
1120: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1123: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1116: end if;
1117: CLOSE c_ecr_enb;
1118: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1119: fnd_message.set_token('PACKAGE',l_proc);
1120: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1123: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1124: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1117: CLOSE c_ecr_enb;
1118: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1119: fnd_message.set_token('PACKAGE',l_proc);
1120: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1123: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1124: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1125: fnd_message.raise_error;

Line 1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1118: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1119: fnd_message.set_token('PACKAGE',l_proc);
1120: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1123: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1124: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1125: fnd_message.raise_error;
1126: --

Line 1123: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1119: fnd_message.set_token('PACKAGE',l_proc);
1120: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1123: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1124: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1125: fnd_message.raise_error;
1126: --
1127: END IF;

Line 1124: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1120: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1123: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1124: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1125: fnd_message.raise_error;
1126: --
1127: END IF;
1128: --

Line 1125: fnd_message.raise_error;

1121: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1122: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1123: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1124: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1125: fnd_message.raise_error;
1126: --
1127: END IF;
1128: --
1129: ELSE

Line 1145: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');

1141: CLOSE c_ecr ;
1142: if g_debug then
1143: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1144: end if;
1145: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1146: fnd_message.set_token('PROC',l_proc);
1147: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1148: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1149: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));

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

1142: if g_debug then
1143: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1144: end if;
1145: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1146: fnd_message.set_token('PROC',l_proc);
1147: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1148: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1149: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1150: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));

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

1143: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1144: end if;
1145: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1146: fnd_message.set_token('PROC',l_proc);
1147: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1148: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1149: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1150: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1151: fnd_message.raise_error;

Line 1148: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));

1144: end if;
1145: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1146: fnd_message.set_token('PROC',l_proc);
1147: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1148: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1149: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1150: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1151: fnd_message.raise_error;
1152: --

Line 1149: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));

1145: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1146: fnd_message.set_token('PROC',l_proc);
1147: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1148: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1149: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1150: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1151: fnd_message.raise_error;
1152: --
1153: ELSE

Line 1150: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));

1146: fnd_message.set_token('PROC',l_proc);
1147: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1148: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1149: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1150: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1151: fnd_message.raise_error;
1152: --
1153: ELSE
1154: --

Line 1151: fnd_message.raise_error;

1147: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1148: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id1));
1149: fnd_message.set_token('RT_VAL', to_char(p_rt_val1));
1150: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val1));
1151: fnd_message.raise_error;
1152: --
1153: ELSE
1154: --
1155: IF l_ecr1.rt_strt_dt_cd = 'ENTRBL' THEN

Line 1166: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');

1162: if g_debug then
1163: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1164: end if;
1165: CLOSE c_ecr;
1166: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1167: fnd_message.set_token('PACKAGE',l_proc);
1168: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1167: fnd_message.set_token('PACKAGE',l_proc);

1163: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1164: end if;
1165: CLOSE c_ecr;
1166: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1167: fnd_message.set_token('PACKAGE',l_proc);
1168: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1171: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1164: end if;
1165: CLOSE c_ecr;
1166: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1167: fnd_message.set_token('PACKAGE',l_proc);
1168: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1171: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1172: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1165: CLOSE c_ecr;
1166: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1167: fnd_message.set_token('PACKAGE',l_proc);
1168: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1171: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1172: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1173: fnd_message.raise_error;

Line 1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1166: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1167: fnd_message.set_token('PACKAGE',l_proc);
1168: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1171: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1172: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1173: fnd_message.raise_error;
1174: --

Line 1171: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1167: fnd_message.set_token('PACKAGE',l_proc);
1168: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1171: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1172: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1173: fnd_message.raise_error;
1174: --
1175: END IF;

Line 1172: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1168: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1171: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1172: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1173: fnd_message.raise_error;
1174: --
1175: END IF;
1176: END IF;

Line 1173: fnd_message.raise_error;

1169: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1170: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1171: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1172: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1173: fnd_message.raise_error;
1174: --
1175: END IF;
1176: END IF;
1177: --

Line 1189: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');

1185: if g_debug then
1186: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1187: end if;
1188: CLOSE c_ecr;
1189: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1190: fnd_message.set_token('PACKAGE',l_proc);
1191: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1190: fnd_message.set_token('PACKAGE',l_proc);

1186: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1187: end if;
1188: CLOSE c_ecr;
1189: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1190: fnd_message.set_token('PACKAGE',l_proc);
1191: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1194: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1187: end if;
1188: CLOSE c_ecr;
1189: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1190: fnd_message.set_token('PACKAGE',l_proc);
1191: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1194: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1195: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1188: CLOSE c_ecr;
1189: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1190: fnd_message.set_token('PACKAGE',l_proc);
1191: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1194: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1195: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1196: fnd_message.raise_error;

Line 1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1189: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1190: fnd_message.set_token('PACKAGE',l_proc);
1191: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1194: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1195: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1196: fnd_message.raise_error;
1197: --

Line 1194: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1190: fnd_message.set_token('PACKAGE',l_proc);
1191: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1194: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1195: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1196: fnd_message.raise_error;
1197: --
1198: END IF;

Line 1195: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1191: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1194: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1195: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1196: fnd_message.raise_error;
1197: --
1198: END IF;
1199: --

Line 1196: fnd_message.raise_error;

1192: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1193: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1194: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1195: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1196: fnd_message.raise_error;
1197: --
1198: END IF;
1199: --
1200: ELSE

Line 1224: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');

1220: CLOSE c_ecr_enb ;
1221: if g_debug then
1222: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1223: end if;
1224: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1225: fnd_message.set_token('PROC',l_proc);
1226: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1227: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1228: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));

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

1221: if g_debug then
1222: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1223: end if;
1224: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1225: fnd_message.set_token('PROC',l_proc);
1226: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1227: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1228: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1229: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));

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

1222: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1223: end if;
1224: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1225: fnd_message.set_token('PROC',l_proc);
1226: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1227: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1228: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1229: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1230: fnd_message.raise_error;

Line 1227: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));

1223: end if;
1224: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1225: fnd_message.set_token('PROC',l_proc);
1226: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1227: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1228: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1229: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1230: fnd_message.raise_error;
1231: --

Line 1228: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));

1224: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1225: fnd_message.set_token('PROC',l_proc);
1226: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1227: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1228: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1229: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1230: fnd_message.raise_error;
1231: --
1232: ELSE

Line 1229: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));

1225: fnd_message.set_token('PROC',l_proc);
1226: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1227: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1228: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1229: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1230: fnd_message.raise_error;
1231: --
1232: ELSE
1233: --

Line 1230: fnd_message.raise_error;

1226: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1227: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1228: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1229: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1230: fnd_message.raise_error;
1231: --
1232: ELSE
1233: --
1234: IF l_ecr2.rt_strt_dt_cd = 'ENTRBL' THEN

Line 1245: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');

1241: if g_debug then
1242: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1243: end if;
1244: CLOSE c_ecr_enb;
1245: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1246: fnd_message.set_token('PACKAGE',l_proc);
1247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1246: fnd_message.set_token('PACKAGE',l_proc);

1242: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1243: end if;
1244: CLOSE c_ecr_enb;
1245: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1246: fnd_message.set_token('PACKAGE',l_proc);
1247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1250: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1243: end if;
1244: CLOSE c_ecr_enb;
1245: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1246: fnd_message.set_token('PACKAGE',l_proc);
1247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1250: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1251: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1244: CLOSE c_ecr_enb;
1245: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1246: fnd_message.set_token('PACKAGE',l_proc);
1247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1250: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1251: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1252: fnd_message.raise_error;

Line 1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1245: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1246: fnd_message.set_token('PACKAGE',l_proc);
1247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1250: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1251: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1252: fnd_message.raise_error;
1253: --

Line 1250: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1246: fnd_message.set_token('PACKAGE',l_proc);
1247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1250: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1251: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1252: fnd_message.raise_error;
1253: --
1254: END IF;

Line 1251: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1250: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1251: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1252: fnd_message.raise_error;
1253: --
1254: END IF;
1255: END IF;

Line 1252: fnd_message.raise_error;

1248: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1249: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1250: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1251: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1252: fnd_message.raise_error;
1253: --
1254: END IF;
1255: END IF;
1256: --

Line 1268: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');

1264: if g_debug then
1265: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1266: end if;
1267: CLOSE c_ecr_enb;
1268: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1269: fnd_message.set_token('PACKAGE',l_proc);
1270: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1269: fnd_message.set_token('PACKAGE',l_proc);

1265: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1266: end if;
1267: CLOSE c_ecr_enb;
1268: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1269: fnd_message.set_token('PACKAGE',l_proc);
1270: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1273: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1266: end if;
1267: CLOSE c_ecr_enb;
1268: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1269: fnd_message.set_token('PACKAGE',l_proc);
1270: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1273: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1274: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1267: CLOSE c_ecr_enb;
1268: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1269: fnd_message.set_token('PACKAGE',l_proc);
1270: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1273: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1274: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1275: fnd_message.raise_error;

Line 1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1268: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1269: fnd_message.set_token('PACKAGE',l_proc);
1270: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1273: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1274: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1275: fnd_message.raise_error;
1276: --

Line 1273: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1269: fnd_message.set_token('PACKAGE',l_proc);
1270: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1273: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1274: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1275: fnd_message.raise_error;
1276: --
1277: END IF;

Line 1274: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1270: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1273: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1274: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1275: fnd_message.raise_error;
1276: --
1277: END IF;
1278: --

Line 1275: fnd_message.raise_error;

1271: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1272: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1273: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1274: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1275: fnd_message.raise_error;
1276: --
1277: END IF;
1278: --
1279: ELSE

Line 1295: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');

1291: CLOSE c_ecr ;
1292: if g_debug then
1293: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1294: end if;
1295: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1296: fnd_message.set_token('PROC',l_proc);
1297: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1298: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1299: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));

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

1292: if g_debug then
1293: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1294: end if;
1295: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1296: fnd_message.set_token('PROC',l_proc);
1297: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1298: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1299: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1300: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));

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

1293: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1294: end if;
1295: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1296: fnd_message.set_token('PROC',l_proc);
1297: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1298: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1299: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1300: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1301: fnd_message.raise_error;

Line 1298: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));

1294: end if;
1295: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1296: fnd_message.set_token('PROC',l_proc);
1297: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1298: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1299: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1300: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1301: fnd_message.raise_error;
1302: --

Line 1299: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));

1295: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1296: fnd_message.set_token('PROC',l_proc);
1297: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1298: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1299: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1300: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1301: fnd_message.raise_error;
1302: --
1303: ELSE

Line 1300: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));

1296: fnd_message.set_token('PROC',l_proc);
1297: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1298: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1299: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1300: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1301: fnd_message.raise_error;
1302: --
1303: ELSE
1304: --

Line 1301: fnd_message.raise_error;

1297: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1298: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id2));
1299: fnd_message.set_token('RT_VAL', to_char(p_rt_val2));
1300: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val2));
1301: fnd_message.raise_error;
1302: --
1303: ELSE
1304: --
1305: IF l_ecr2.rt_strt_dt_cd = 'ENTRBL' THEN

Line 1316: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');

1312: if g_debug then
1313: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1314: end if;
1315: CLOSE c_ecr;
1316: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1317: fnd_message.set_token('PACKAGE',l_proc);
1318: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1317: fnd_message.set_token('PACKAGE',l_proc);

1313: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1314: end if;
1315: CLOSE c_ecr;
1316: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1317: fnd_message.set_token('PACKAGE',l_proc);
1318: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1321: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1314: end if;
1315: CLOSE c_ecr;
1316: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1317: fnd_message.set_token('PACKAGE',l_proc);
1318: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1321: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1322: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1315: CLOSE c_ecr;
1316: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1317: fnd_message.set_token('PACKAGE',l_proc);
1318: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1321: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1322: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1323: fnd_message.raise_error;

Line 1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1316: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1317: fnd_message.set_token('PACKAGE',l_proc);
1318: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1321: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1322: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1323: fnd_message.raise_error;
1324: --

Line 1321: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1317: fnd_message.set_token('PACKAGE',l_proc);
1318: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1321: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1322: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1323: fnd_message.raise_error;
1324: --
1325: END IF;

Line 1322: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1318: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1321: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1322: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1323: fnd_message.raise_error;
1324: --
1325: END IF;
1326: END IF;

Line 1323: fnd_message.raise_error;

1319: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1320: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1321: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1322: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1323: fnd_message.raise_error;
1324: --
1325: END IF;
1326: END IF;
1327: --

Line 1339: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');

1335: if g_debug then
1336: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1337: end if;
1338: CLOSE c_ecr;
1339: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1340: fnd_message.set_token('PACKAGE',l_proc);
1341: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1340: fnd_message.set_token('PACKAGE',l_proc);

1336: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1337: end if;
1338: CLOSE c_ecr;
1339: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1340: fnd_message.set_token('PACKAGE',l_proc);
1341: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1344: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1337: end if;
1338: CLOSE c_ecr;
1339: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1340: fnd_message.set_token('PACKAGE',l_proc);
1341: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1344: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1345: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1338: CLOSE c_ecr;
1339: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1340: fnd_message.set_token('PACKAGE',l_proc);
1341: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1344: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1345: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1346: fnd_message.raise_error;

Line 1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1339: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1340: fnd_message.set_token('PACKAGE',l_proc);
1341: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1344: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1345: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1346: fnd_message.raise_error;
1347: --

Line 1344: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1340: fnd_message.set_token('PACKAGE',l_proc);
1341: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1344: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1345: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1346: fnd_message.raise_error;
1347: --
1348: END IF;

Line 1345: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1341: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1344: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1345: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1346: fnd_message.raise_error;
1347: --
1348: END IF;
1349: --

Line 1346: fnd_message.raise_error;

1342: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1343: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1344: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1345: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1346: fnd_message.raise_error;
1347: --
1348: END IF;
1349: --
1350: ELSE

Line 1374: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');

1370: CLOSE c_ecr_enb ;
1371: if g_debug then
1372: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1373: end if;
1374: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1375: fnd_message.set_token('PROC',l_proc);
1376: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1377: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1378: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));

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

1371: if g_debug then
1372: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1373: end if;
1374: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1375: fnd_message.set_token('PROC',l_proc);
1376: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1377: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1378: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1379: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));

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

1372: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1373: end if;
1374: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1375: fnd_message.set_token('PROC',l_proc);
1376: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1377: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1378: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1379: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1380: fnd_message.raise_error;

Line 1377: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));

1373: end if;
1374: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1375: fnd_message.set_token('PROC',l_proc);
1376: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1377: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1378: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1379: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1380: fnd_message.raise_error;
1381: --

Line 1378: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));

1374: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1375: fnd_message.set_token('PROC',l_proc);
1376: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1377: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1378: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1379: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1380: fnd_message.raise_error;
1381: --
1382: ELSE

Line 1379: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));

1375: fnd_message.set_token('PROC',l_proc);
1376: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1377: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1378: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1379: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1380: fnd_message.raise_error;
1381: --
1382: ELSE
1383: --

Line 1380: fnd_message.raise_error;

1376: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1377: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1378: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1379: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1380: fnd_message.raise_error;
1381: --
1382: ELSE
1383: --
1384: IF l_ecr3.rt_strt_dt_cd = 'ENTRBL' THEN

Line 1395: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');

1391: if g_debug then
1392: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1393: end if;
1394: CLOSE c_ecr_enb;
1395: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1396: fnd_message.set_token('PACKAGE',l_proc);
1397: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1396: fnd_message.set_token('PACKAGE',l_proc);

1392: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1393: end if;
1394: CLOSE c_ecr_enb;
1395: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1396: fnd_message.set_token('PACKAGE',l_proc);
1397: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1400: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1393: end if;
1394: CLOSE c_ecr_enb;
1395: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1396: fnd_message.set_token('PACKAGE',l_proc);
1397: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1400: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1401: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1394: CLOSE c_ecr_enb;
1395: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1396: fnd_message.set_token('PACKAGE',l_proc);
1397: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1400: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1401: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1402: fnd_message.raise_error;

Line 1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1395: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1396: fnd_message.set_token('PACKAGE',l_proc);
1397: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1400: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1401: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1402: fnd_message.raise_error;
1403: --

Line 1400: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1396: fnd_message.set_token('PACKAGE',l_proc);
1397: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1400: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1401: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1402: fnd_message.raise_error;
1403: --
1404: END IF;

Line 1401: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1397: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1400: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1401: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1402: fnd_message.raise_error;
1403: --
1404: END IF;
1405: END IF;

Line 1402: fnd_message.raise_error;

1398: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1399: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1400: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1401: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1402: fnd_message.raise_error;
1403: --
1404: END IF;
1405: END IF;
1406: --

Line 1418: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');

1414: if g_debug then
1415: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1416: end if;
1417: CLOSE c_ecr_enb;
1418: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1419: fnd_message.set_token('PACKAGE',l_proc);
1420: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1419: fnd_message.set_token('PACKAGE',l_proc);

1415: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1416: end if;
1417: CLOSE c_ecr_enb;
1418: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1419: fnd_message.set_token('PACKAGE',l_proc);
1420: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1423: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1416: end if;
1417: CLOSE c_ecr_enb;
1418: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1419: fnd_message.set_token('PACKAGE',l_proc);
1420: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1423: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1424: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1417: CLOSE c_ecr_enb;
1418: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1419: fnd_message.set_token('PACKAGE',l_proc);
1420: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1423: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1424: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1425: fnd_message.raise_error;

Line 1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1418: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1419: fnd_message.set_token('PACKAGE',l_proc);
1420: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1423: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1424: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1425: fnd_message.raise_error;
1426: --

Line 1423: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1419: fnd_message.set_token('PACKAGE',l_proc);
1420: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1423: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1424: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1425: fnd_message.raise_error;
1426: --
1427: END IF;

Line 1424: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1420: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1423: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1424: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1425: fnd_message.raise_error;
1426: --
1427: END IF;
1428: --

Line 1425: fnd_message.raise_error;

1421: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1422: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1423: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1424: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1425: fnd_message.raise_error;
1426: --
1427: END IF;
1428: --
1429: ELSE

Line 1445: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');

1441: CLOSE c_ecr ;
1442: if g_debug then
1443: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1444: end if;
1445: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1446: fnd_message.set_token('PROC',l_proc);
1447: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1448: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1449: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));

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

1442: if g_debug then
1443: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1444: end if;
1445: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1446: fnd_message.set_token('PROC',l_proc);
1447: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1448: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1449: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1450: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));

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

1443: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1444: end if;
1445: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1446: fnd_message.set_token('PROC',l_proc);
1447: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1448: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1449: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1450: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1451: fnd_message.raise_error;

Line 1448: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));

1444: end if;
1445: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1446: fnd_message.set_token('PROC',l_proc);
1447: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1448: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1449: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1450: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1451: fnd_message.raise_error;
1452: --

Line 1449: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));

1445: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1446: fnd_message.set_token('PROC',l_proc);
1447: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1448: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1449: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1450: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1451: fnd_message.raise_error;
1452: --
1453: ELSE

Line 1450: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));

1446: fnd_message.set_token('PROC',l_proc);
1447: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1448: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1449: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1450: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1451: fnd_message.raise_error;
1452: --
1453: ELSE
1454: --

Line 1451: fnd_message.raise_error;

1447: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1448: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id3));
1449: fnd_message.set_token('RT_VAL', to_char(p_rt_val3));
1450: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val3));
1451: fnd_message.raise_error;
1452: --
1453: ELSE
1454: --
1455: IF l_ecr3.rt_strt_dt_cd = 'ENTRBL' THEN

Line 1466: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');

1462: if g_debug then
1463: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1464: end if;
1465: CLOSE c_ecr;
1466: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1467: fnd_message.set_token('PACKAGE',l_proc);
1468: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1467: fnd_message.set_token('PACKAGE',l_proc);

1463: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1464: end if;
1465: CLOSE c_ecr;
1466: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1467: fnd_message.set_token('PACKAGE',l_proc);
1468: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1471: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1464: end if;
1465: CLOSE c_ecr;
1466: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1467: fnd_message.set_token('PACKAGE',l_proc);
1468: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1471: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1472: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1465: CLOSE c_ecr;
1466: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1467: fnd_message.set_token('PACKAGE',l_proc);
1468: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1471: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1472: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1473: fnd_message.raise_error;

Line 1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1466: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1467: fnd_message.set_token('PACKAGE',l_proc);
1468: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1471: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1472: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1473: fnd_message.raise_error;
1474: --

Line 1471: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1467: fnd_message.set_token('PACKAGE',l_proc);
1468: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1471: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1472: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1473: fnd_message.raise_error;
1474: --
1475: END IF;

Line 1472: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1468: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1471: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1472: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1473: fnd_message.raise_error;
1474: --
1475: END IF;
1476: END IF;

Line 1473: fnd_message.raise_error;

1469: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1470: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1471: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1472: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1473: fnd_message.raise_error;
1474: --
1475: END IF;
1476: END IF;
1477: --

Line 1489: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');

1485: if g_debug then
1486: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1487: end if;
1488: CLOSE c_ecr;
1489: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1490: fnd_message.set_token('PACKAGE',l_proc);
1491: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1490: fnd_message.set_token('PACKAGE',l_proc);

1486: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1487: end if;
1488: CLOSE c_ecr;
1489: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1490: fnd_message.set_token('PACKAGE',l_proc);
1491: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1494: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1487: end if;
1488: CLOSE c_ecr;
1489: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1490: fnd_message.set_token('PACKAGE',l_proc);
1491: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1494: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1495: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1488: CLOSE c_ecr;
1489: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1490: fnd_message.set_token('PACKAGE',l_proc);
1491: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1494: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1495: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1496: fnd_message.raise_error;

Line 1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1489: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1490: fnd_message.set_token('PACKAGE',l_proc);
1491: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1494: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1495: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1496: fnd_message.raise_error;
1497: --

Line 1494: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1490: fnd_message.set_token('PACKAGE',l_proc);
1491: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1494: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1495: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1496: fnd_message.raise_error;
1497: --
1498: END IF;

Line 1495: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1491: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1494: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1495: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1496: fnd_message.raise_error;
1497: --
1498: END IF;
1499: --

Line 1496: fnd_message.raise_error;

1492: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1493: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1494: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1495: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1496: fnd_message.raise_error;
1497: --
1498: END IF;
1499: --
1500: ELSE

Line 1524: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');

1520: CLOSE c_ecr_enb ;
1521: if g_debug then
1522: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1523: end if;
1524: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1525: fnd_message.set_token('PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1527: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1528: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));

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

1521: if g_debug then
1522: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1523: end if;
1524: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1525: fnd_message.set_token('PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1527: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1528: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1529: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));

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

1522: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1523: end if;
1524: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1525: fnd_message.set_token('PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1527: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1528: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1529: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1530: fnd_message.raise_error;

Line 1527: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));

1523: end if;
1524: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1525: fnd_message.set_token('PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1527: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1528: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1529: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1530: fnd_message.raise_error;
1531: --

Line 1528: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));

1524: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1525: fnd_message.set_token('PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1527: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1528: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1529: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1530: fnd_message.raise_error;
1531: --
1532: ELSE

Line 1529: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));

1525: fnd_message.set_token('PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1527: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1528: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1529: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1530: fnd_message.raise_error;
1531: --
1532: ELSE
1533: --

Line 1530: fnd_message.raise_error;

1526: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1527: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1528: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1529: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1530: fnd_message.raise_error;
1531: --
1532: ELSE
1533: --
1534: IF l_ecr4.rt_strt_dt_cd = 'ENTRBL' THEN

Line 1545: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');

1541: if g_debug then
1542: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1543: end if;
1544: CLOSE c_ecr_enb;
1545: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1546: fnd_message.set_token('PACKAGE',l_proc);
1547: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1546: fnd_message.set_token('PACKAGE',l_proc);

1542: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1543: end if;
1544: CLOSE c_ecr_enb;
1545: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1546: fnd_message.set_token('PACKAGE',l_proc);
1547: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1550: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1543: end if;
1544: CLOSE c_ecr_enb;
1545: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1546: fnd_message.set_token('PACKAGE',l_proc);
1547: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1550: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1551: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1544: CLOSE c_ecr_enb;
1545: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1546: fnd_message.set_token('PACKAGE',l_proc);
1547: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1550: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1551: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1552: fnd_message.raise_error;

Line 1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1545: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1546: fnd_message.set_token('PACKAGE',l_proc);
1547: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1550: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1551: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1552: fnd_message.raise_error;
1553: --

Line 1550: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1546: fnd_message.set_token('PACKAGE',l_proc);
1547: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1550: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1551: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1552: fnd_message.raise_error;
1553: --
1554: END IF;

Line 1551: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1547: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1550: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1551: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1552: fnd_message.raise_error;
1553: --
1554: END IF;
1555: END IF;

Line 1552: fnd_message.raise_error;

1548: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1549: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1550: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1551: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1552: fnd_message.raise_error;
1553: --
1554: END IF;
1555: END IF;
1556: --

Line 1568: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');

1564: if g_debug then
1565: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1566: end if;
1567: CLOSE c_ecr_enb;
1568: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1569: fnd_message.set_token('PACKAGE',l_proc);
1570: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1569: fnd_message.set_token('PACKAGE',l_proc);

1565: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1566: end if;
1567: CLOSE c_ecr_enb;
1568: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1569: fnd_message.set_token('PACKAGE',l_proc);
1570: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1573: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1566: end if;
1567: CLOSE c_ecr_enb;
1568: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1569: fnd_message.set_token('PACKAGE',l_proc);
1570: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1573: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1574: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1567: CLOSE c_ecr_enb;
1568: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1569: fnd_message.set_token('PACKAGE',l_proc);
1570: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1573: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1574: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1575: fnd_message.raise_error;

Line 1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1568: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1569: fnd_message.set_token('PACKAGE',l_proc);
1570: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1573: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1574: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1575: fnd_message.raise_error;
1576: --

Line 1573: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1569: fnd_message.set_token('PACKAGE',l_proc);
1570: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1573: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1574: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1575: fnd_message.raise_error;
1576: --
1577: END IF;

Line 1574: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1570: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1573: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1574: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1575: fnd_message.raise_error;
1576: --
1577: END IF;
1578: --

Line 1575: fnd_message.raise_error;

1571: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1572: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1573: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1574: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1575: fnd_message.raise_error;
1576: --
1577: END IF;
1578: --
1579: ELSE

Line 1595: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');

1591: CLOSE c_ecr ;
1592: if g_debug then
1593: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1594: end if;
1595: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1596: fnd_message.set_token('PROC',l_proc);
1597: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1598: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1599: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));

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

1592: if g_debug then
1593: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1594: end if;
1595: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1596: fnd_message.set_token('PROC',l_proc);
1597: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1598: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1599: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1600: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));

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

1593: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1594: end if;
1595: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1596: fnd_message.set_token('PROC',l_proc);
1597: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1598: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1599: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1600: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1601: fnd_message.raise_error;

Line 1598: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));

1594: end if;
1595: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1596: fnd_message.set_token('PROC',l_proc);
1597: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1598: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1599: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1600: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1601: fnd_message.raise_error;
1602: --

Line 1599: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));

1595: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1596: fnd_message.set_token('PROC',l_proc);
1597: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1598: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1599: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1600: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1601: fnd_message.raise_error;
1602: --
1603: ELSE

Line 1600: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));

1596: fnd_message.set_token('PROC',l_proc);
1597: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1598: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1599: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1600: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1601: fnd_message.raise_error;
1602: --
1603: ELSE
1604: --

Line 1601: fnd_message.raise_error;

1597: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
1598: fnd_message.set_token('ABR_ID', to_char(p_acty_base_rt_id4));
1599: fnd_message.set_token('RT_VAL', to_char(p_rt_val4));
1600: fnd_message.set_token('ANN_RT_VAL', to_char(p_ann_rt_val4));
1601: fnd_message.raise_error;
1602: --
1603: ELSE
1604: --
1605: IF l_ecr4.rt_strt_dt_cd = 'ENTRBL' THEN

Line 1616: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');

1612: if g_debug then
1613: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1614: end if;
1615: CLOSE c_ecr;
1616: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1617: fnd_message.set_token('PACKAGE',l_proc);
1618: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1617: fnd_message.set_token('PACKAGE',l_proc);

1613: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1614: end if;
1615: CLOSE c_ecr;
1616: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1617: fnd_message.set_token('PACKAGE',l_proc);
1618: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1621: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1614: end if;
1615: CLOSE c_ecr;
1616: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1617: fnd_message.set_token('PACKAGE',l_proc);
1618: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1621: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1622: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1615: CLOSE c_ecr;
1616: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1617: fnd_message.set_token('PACKAGE',l_proc);
1618: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1621: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1622: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1623: fnd_message.raise_error;

Line 1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1616: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1617: fnd_message.set_token('PACKAGE',l_proc);
1618: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1621: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1622: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1623: fnd_message.raise_error;
1624: --

Line 1621: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1617: fnd_message.set_token('PACKAGE',l_proc);
1618: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1621: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1622: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1623: fnd_message.raise_error;
1624: --
1625: END IF;

Line 1622: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1618: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1621: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1622: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1623: fnd_message.raise_error;
1624: --
1625: END IF;
1626: END IF;

Line 1623: fnd_message.raise_error;

1619: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1620: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1621: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1622: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1623: fnd_message.raise_error;
1624: --
1625: END IF;
1626: END IF;
1627: --

Line 1639: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');

1635: if g_debug then
1636: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1637: end if;
1638: CLOSE c_ecr;
1639: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1640: fnd_message.set_token('PACKAGE',l_proc);
1641: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 1640: fnd_message.set_token('PACKAGE',l_proc);

1636: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1637: end if;
1638: CLOSE c_ecr;
1639: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1640: fnd_message.set_token('PACKAGE',l_proc);
1641: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1644: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

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

1637: end if;
1638: CLOSE c_ecr;
1639: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1640: fnd_message.set_token('PACKAGE',l_proc);
1641: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1644: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1645: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

Line 1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));

1638: CLOSE c_ecr;
1639: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1640: fnd_message.set_token('PACKAGE',l_proc);
1641: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1644: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1645: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1646: fnd_message.raise_error;

Line 1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1639: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1640: fnd_message.set_token('PACKAGE',l_proc);
1641: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1644: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1645: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1646: fnd_message.raise_error;
1647: --

Line 1644: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));

1640: fnd_message.set_token('PACKAGE',l_proc);
1641: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1644: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1645: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1646: fnd_message.raise_error;
1647: --
1648: END IF;

Line 1645: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

1641: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1644: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1645: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1646: fnd_message.raise_error;
1647: --
1648: END IF;
1649: --

Line 1646: fnd_message.raise_error;

1642: fnd_message.set_token('LER_ID', to_char(p_ler_id));
1643: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1644: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1645: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
1646: fnd_message.raise_error;
1647: --
1648: END IF;
1649: --
1650: ELSE

Line 1760: fnd_message.set_name('BEN','BEN_94658_PLN_ALRDY_DE_ENRLD');

1756: if l_prtt_enrt_rslt_id is not null then
1757: --
1758: --Raise error saying that enrollment has already been ended.
1759: --
1760: fnd_message.set_name('BEN','BEN_94658_PLN_ALRDY_DE_ENRLD');
1761: fnd_message.set_token('PACKAGE',l_proc);
1762: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));

Line 1761: fnd_message.set_token('PACKAGE',l_proc);

1757: --
1758: --Raise error saying that enrollment has already been ended.
1759: --
1760: fnd_message.set_name('BEN','BEN_94658_PLN_ALRDY_DE_ENRLD');
1761: fnd_message.set_token('PACKAGE',l_proc);
1762: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));

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

1758: --Raise error saying that enrollment has already been ended.
1759: --
1760: fnd_message.set_name('BEN','BEN_94658_PLN_ALRDY_DE_ENRLD');
1761: fnd_message.set_token('PACKAGE',l_proc);
1762: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1766: fnd_message.set_token('PER_ENR_RSLT_ID',to_char(l_prtt_enrt_rslt_id));

Line 1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1759: --
1760: fnd_message.set_name('BEN','BEN_94658_PLN_ALRDY_DE_ENRLD');
1761: fnd_message.set_token('PACKAGE',l_proc);
1762: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1766: fnd_message.set_token('PER_ENR_RSLT_ID',to_char(l_prtt_enrt_rslt_id));
1767: fnd_message.set_token('LE_DATE', p_life_event_date);

Line 1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));

1760: fnd_message.set_name('BEN','BEN_94658_PLN_ALRDY_DE_ENRLD');
1761: fnd_message.set_token('PACKAGE',l_proc);
1762: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1766: fnd_message.set_token('PER_ENR_RSLT_ID',to_char(l_prtt_enrt_rslt_id));
1767: fnd_message.set_token('LE_DATE', p_life_event_date);
1768: fnd_message.raise_error;

Line 1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));

1761: fnd_message.set_token('PACKAGE',l_proc);
1762: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1766: fnd_message.set_token('PER_ENR_RSLT_ID',to_char(l_prtt_enrt_rslt_id));
1767: fnd_message.set_token('LE_DATE', p_life_event_date);
1768: fnd_message.raise_error;
1769: --

Line 1766: fnd_message.set_token('PER_ENR_RSLT_ID',to_char(l_prtt_enrt_rslt_id));

1762: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1766: fnd_message.set_token('PER_ENR_RSLT_ID',to_char(l_prtt_enrt_rslt_id));
1767: fnd_message.set_token('LE_DATE', p_life_event_date);
1768: fnd_message.raise_error;
1769: --
1770: else

Line 1767: fnd_message.set_token('LE_DATE', p_life_event_date);

1763: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1766: fnd_message.set_token('PER_ENR_RSLT_ID',to_char(l_prtt_enrt_rslt_id));
1767: fnd_message.set_token('LE_DATE', p_life_event_date);
1768: fnd_message.raise_error;
1769: --
1770: else
1771: --

Line 1768: fnd_message.raise_error;

1764: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1765: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1766: fnd_message.set_token('PER_ENR_RSLT_ID',to_char(l_prtt_enrt_rslt_id));
1767: fnd_message.set_token('LE_DATE', p_life_event_date);
1768: fnd_message.raise_error;
1769: --
1770: else
1771: --
1772: --No Enrollment open/ended were found. Invalid data entered. Raise error

Line 1774: fnd_message.set_name('BEN','BEN_94659_NO_PLN_FOR_DE_ENRL');

1770: else
1771: --
1772: --No Enrollment open/ended were found. Invalid data entered. Raise error
1773: --
1774: fnd_message.set_name('BEN','BEN_94659_NO_PLN_FOR_DE_ENRL');
1775: fnd_message.set_token('PACKAGE',l_proc);
1776: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));

Line 1775: fnd_message.set_token('PACKAGE',l_proc);

1771: --
1772: --No Enrollment open/ended were found. Invalid data entered. Raise error
1773: --
1774: fnd_message.set_name('BEN','BEN_94659_NO_PLN_FOR_DE_ENRL');
1775: fnd_message.set_token('PACKAGE',l_proc);
1776: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1779: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));

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

1772: --No Enrollment open/ended were found. Invalid data entered. Raise error
1773: --
1774: fnd_message.set_name('BEN','BEN_94659_NO_PLN_FOR_DE_ENRL');
1775: fnd_message.set_token('PACKAGE',l_proc);
1776: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1779: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1780: fnd_message.set_token('LE_DATE', p_life_event_date);

Line 1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

1773: --
1774: fnd_message.set_name('BEN','BEN_94659_NO_PLN_FOR_DE_ENRL');
1775: fnd_message.set_token('PACKAGE',l_proc);
1776: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1779: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1780: fnd_message.set_token('LE_DATE', p_life_event_date);
1781: fnd_message.raise_error;

Line 1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));

1774: fnd_message.set_name('BEN','BEN_94659_NO_PLN_FOR_DE_ENRL');
1775: fnd_message.set_token('PACKAGE',l_proc);
1776: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1779: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1780: fnd_message.set_token('LE_DATE', p_life_event_date);
1781: fnd_message.raise_error;
1782: --

Line 1779: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));

1775: fnd_message.set_token('PACKAGE',l_proc);
1776: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1779: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1780: fnd_message.set_token('LE_DATE', p_life_event_date);
1781: fnd_message.raise_error;
1782: --
1783: end if;

Line 1780: fnd_message.set_token('LE_DATE', p_life_event_date);

1776: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1779: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1780: fnd_message.set_token('LE_DATE', p_life_event_date);
1781: fnd_message.raise_error;
1782: --
1783: end if;
1784: --

Line 1781: fnd_message.raise_error;

1777: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1778: fnd_message.set_token('PL_ID', to_char(p_ended_pl_id));
1779: fnd_message.set_token('OPT_ID',to_char(p_ended_opt_id));
1780: fnd_message.set_token('LE_DATE', p_life_event_date);
1781: fnd_message.raise_error;
1782: --
1783: end if;
1784: --
1785: end if;

Line 1881: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');

1877: --
1878: if g_debug then
1879: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
1880: end if;
1881: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
1882: fnd_message.set_token('PROC',l_proc);
1883: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1884: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1885: fnd_message.set_token('LE_DATE', p_life_event_date);

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

1878: if g_debug then
1879: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
1880: end if;
1881: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
1882: fnd_message.set_token('PROC',l_proc);
1883: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1884: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1885: fnd_message.set_token('LE_DATE', p_life_event_date);
1886: fnd_message.raise_error;

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

1879: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
1880: end if;
1881: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
1882: fnd_message.set_token('PROC',l_proc);
1883: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1884: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1885: fnd_message.set_token('LE_DATE', p_life_event_date);
1886: fnd_message.raise_error;
1887: --

Line 1884: fnd_message.set_token('LER_ID',to_char(p_ler_id));

1880: end if;
1881: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
1882: fnd_message.set_token('PROC',l_proc);
1883: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1884: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1885: fnd_message.set_token('LE_DATE', p_life_event_date);
1886: fnd_message.raise_error;
1887: --
1888: END IF;

Line 1885: fnd_message.set_token('LE_DATE', p_life_event_date);

1881: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
1882: fnd_message.set_token('PROC',l_proc);
1883: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1884: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1885: fnd_message.set_token('LE_DATE', p_life_event_date);
1886: fnd_message.raise_error;
1887: --
1888: END IF;
1889: --

Line 1886: fnd_message.raise_error;

1882: fnd_message.set_token('PROC',l_proc);
1883: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1884: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1885: fnd_message.set_token('LE_DATE', p_life_event_date);
1886: fnd_message.raise_error;
1887: --
1888: END IF;
1889: --
1890: CLOSE c_pil;

Line 2096: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');

2092: --
2093: if g_debug then
2094: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2095: end if;
2096: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2097: fnd_message.set_token('PROC',l_proc);
2098: fnd_message.set_token('PERSON_ID',p_record_typ_cd);
2099: fnd_message.raise_error;
2100: --

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

2093: if g_debug then
2094: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2095: end if;
2096: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2097: fnd_message.set_token('PROC',l_proc);
2098: fnd_message.set_token('PERSON_ID',p_record_typ_cd);
2099: fnd_message.raise_error;
2100: --
2101: END IF;

Line 2098: fnd_message.set_token('PERSON_ID',p_record_typ_cd);

2094: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2095: end if;
2096: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2097: fnd_message.set_token('PROC',l_proc);
2098: fnd_message.set_token('PERSON_ID',p_record_typ_cd);
2099: fnd_message.raise_error;
2100: --
2101: END IF;
2102: --

Line 2099: fnd_message.raise_error;

2095: end if;
2096: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2097: fnd_message.set_token('PROC',l_proc);
2098: fnd_message.set_token('PERSON_ID',p_record_typ_cd);
2099: fnd_message.raise_error;
2100: --
2101: END IF;
2102: --
2103: exception when others then

Line 2431: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');

2427: --Throw Error invalid record type
2428: if g_debug then
2429: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2430: end if;
2431: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2432: fnd_message.set_token('PROC',l_proc);
2433: fnd_message.set_token('PERSON_ID',l_record_typ_cd);
2434: fnd_message.raise_error;
2435: --

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

2428: if g_debug then
2429: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2430: end if;
2431: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2432: fnd_message.set_token('PROC',l_proc);
2433: fnd_message.set_token('PERSON_ID',l_record_typ_cd);
2434: fnd_message.raise_error;
2435: --
2436: END IF;

Line 2433: fnd_message.set_token('PERSON_ID',l_record_typ_cd);

2429: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2430: end if;
2431: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2432: fnd_message.set_token('PROC',l_proc);
2433: fnd_message.set_token('PERSON_ID',l_record_typ_cd);
2434: fnd_message.raise_error;
2435: --
2436: END IF;
2437: --

Line 2434: fnd_message.raise_error;

2430: end if;
2431: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2432: fnd_message.set_token('PROC',l_proc);
2433: fnd_message.set_token('PERSON_ID',l_record_typ_cd);
2434: fnd_message.raise_error;
2435: --
2436: END IF;
2437: --
2438: END IF;

Line 2443: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');

2439: ELSE
2440: if g_debug then
2441: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2442: end if;
2443: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2444: fnd_message.set_token('PROC',l_proc);
2445: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2446: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2447: fnd_message.set_token('LE_DATE', p_life_event_date);

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

2440: if g_debug then
2441: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2442: end if;
2443: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2444: fnd_message.set_token('PROC',l_proc);
2445: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2446: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2447: fnd_message.set_token('LE_DATE', p_life_event_date);
2448: fnd_message.raise_error;

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

2441: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2442: end if;
2443: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2444: fnd_message.set_token('PROC',l_proc);
2445: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2446: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2447: fnd_message.set_token('LE_DATE', p_life_event_date);
2448: fnd_message.raise_error;
2449: --

Line 2446: fnd_message.set_token('LER_ID',to_char(p_ler_id));

2442: end if;
2443: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2444: fnd_message.set_token('PROC',l_proc);
2445: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2446: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2447: fnd_message.set_token('LE_DATE', p_life_event_date);
2448: fnd_message.raise_error;
2449: --
2450: END IF;

Line 2447: fnd_message.set_token('LE_DATE', p_life_event_date);

2443: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2444: fnd_message.set_token('PROC',l_proc);
2445: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2446: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2447: fnd_message.set_token('LE_DATE', p_life_event_date);
2448: fnd_message.raise_error;
2449: --
2450: END IF;
2451: --

Line 2448: fnd_message.raise_error;

2444: fnd_message.set_token('PROC',l_proc);
2445: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2446: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2447: fnd_message.set_token('LE_DATE', p_life_event_date);
2448: fnd_message.raise_error;
2449: --
2450: END IF;
2451: --
2452: exception when others then

Line 2629: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');

2625: );
2626: --
2627: IF l_prtt_enrt_rslt_id IS NULL THEN
2628: --
2629: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2630: fnd_message.set_token('PROC',l_proc);
2631: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

2626: --
2627: IF l_prtt_enrt_rslt_id IS NULL THEN
2628: --
2629: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2630: fnd_message.set_token('PROC',l_proc);
2631: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

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

2627: IF l_prtt_enrt_rslt_id IS NULL THEN
2628: --
2629: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2630: fnd_message.set_token('PROC',l_proc);
2631: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2635: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));

Line 2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

2628: --
2629: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2630: fnd_message.set_token('PROC',l_proc);
2631: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2635: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2636: fnd_message.set_token('LE_DATE',p_life_event_date);

Line 2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));

2629: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2630: fnd_message.set_token('PROC',l_proc);
2631: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2635: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2636: fnd_message.set_token('LE_DATE',p_life_event_date);
2637: fnd_message.raise_error;

Line 2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

2630: fnd_message.set_token('PROC',l_proc);
2631: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2635: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2636: fnd_message.set_token('LE_DATE',p_life_event_date);
2637: fnd_message.raise_error;
2638: --

Line 2635: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));

2631: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2635: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2636: fnd_message.set_token('LE_DATE',p_life_event_date);
2637: fnd_message.raise_error;
2638: --
2639: END IF;

Line 2636: fnd_message.set_token('LE_DATE',p_life_event_date);

2632: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2635: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2636: fnd_message.set_token('LE_DATE',p_life_event_date);
2637: fnd_message.raise_error;
2638: --
2639: END IF;
2640: --

Line 2637: fnd_message.raise_error;

2633: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2634: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2635: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2636: fnd_message.set_token('LE_DATE',p_life_event_date);
2637: fnd_message.raise_error;
2638: --
2639: END IF;
2640: --
2641: open get_rslt_ovn_c;

Line 2651: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');

2647: --
2648: if g_debug then
2649: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2650: end if;
2651: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2652: fnd_message.set_token('PROC',l_proc);
2653: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2654: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2655: fnd_message.set_token('LE_DATE', p_life_event_date);

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

2648: if g_debug then
2649: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2650: end if;
2651: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2652: fnd_message.set_token('PROC',l_proc);
2653: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2654: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2655: fnd_message.set_token('LE_DATE', p_life_event_date);
2656: fnd_message.raise_error;

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

2649: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2650: end if;
2651: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2652: fnd_message.set_token('PROC',l_proc);
2653: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2654: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2655: fnd_message.set_token('LE_DATE', p_life_event_date);
2656: fnd_message.raise_error;
2657: --

Line 2654: fnd_message.set_token('LER_ID',to_char(p_ler_id));

2650: end if;
2651: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2652: fnd_message.set_token('PROC',l_proc);
2653: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2654: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2655: fnd_message.set_token('LE_DATE', p_life_event_date);
2656: fnd_message.raise_error;
2657: --
2658: END IF ;

Line 2655: fnd_message.set_token('LE_DATE', p_life_event_date);

2651: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2652: fnd_message.set_token('PROC',l_proc);
2653: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2654: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2655: fnd_message.set_token('LE_DATE', p_life_event_date);
2656: fnd_message.raise_error;
2657: --
2658: END IF ;
2659: --

Line 2656: fnd_message.raise_error;

2652: fnd_message.set_token('PROC',l_proc);
2653: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2654: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2655: fnd_message.set_token('LE_DATE', p_life_event_date);
2656: fnd_message.raise_error;
2657: --
2658: END IF ;
2659: --
2660: get_pbn

Line 2769: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');

2765: --Bad case why are we here ???
2766: fnd_file.put_line
2767: (which => fnd_file.log,
2768: buff => 'Nothing happended... something wrong...');
2769: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2770: fnd_message.set_token('PROC',l_proc);
2771: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

2766: fnd_file.put_line
2767: (which => fnd_file.log,
2768: buff => 'Nothing happended... something wrong...');
2769: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2770: fnd_message.set_token('PROC',l_proc);
2771: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

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

2767: (which => fnd_file.log,
2768: buff => 'Nothing happended... something wrong...');
2769: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2770: fnd_message.set_token('PROC',l_proc);
2771: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2775: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));

Line 2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

2768: buff => 'Nothing happended... something wrong...');
2769: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2770: fnd_message.set_token('PROC',l_proc);
2771: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2775: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2776: fnd_message.set_token('LE_DATE',p_life_event_date);

Line 2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));

2769: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2770: fnd_message.set_token('PROC',l_proc);
2771: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2775: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2776: fnd_message.set_token('LE_DATE',p_life_event_date);
2777: fnd_message.raise_error;

Line 2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

2770: fnd_message.set_token('PROC',l_proc);
2771: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2775: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2776: fnd_message.set_token('LE_DATE',p_life_event_date);
2777: fnd_message.raise_error;
2778: --

Line 2775: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));

2771: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2775: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2776: fnd_message.set_token('LE_DATE',p_life_event_date);
2777: fnd_message.raise_error;
2778: --
2779: END IF;

Line 2776: fnd_message.set_token('LE_DATE',p_life_event_date);

2772: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2775: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2776: fnd_message.set_token('LE_DATE',p_life_event_date);
2777: fnd_message.raise_error;
2778: --
2779: END IF;
2780: --

Line 2777: fnd_message.raise_error;

2773: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2774: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2775: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2776: fnd_message.set_token('LE_DATE',p_life_event_date);
2777: fnd_message.raise_error;
2778: --
2779: END IF;
2780: --
2781: -- IF l_prtt_enrt_rslt_id IS NOT NULL THEN