APPS.BEN_ENROLLMENT_PROCESS dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

Line 186: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 231: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 256: fnd_message.raise_error;

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

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

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

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

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

Line 295: fnd_message.raise_error;

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

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

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

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

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

Line 333: fnd_message.raise_error;

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

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

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

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

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

Line 345: fnd_message.raise_error;

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

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

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

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

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

Line 371: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 873: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 913: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 935: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 961: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 978: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1003: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1056: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1083: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1105: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1128: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1154: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1176: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1199: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1233: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1255: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1278: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1304: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1326: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1349: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1383: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1405: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1428: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1454: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1476: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1499: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1533: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1555: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1578: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1604: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1626: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1649: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1771: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1784: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 1889: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 2102: fnd_message.raise_error;

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

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

2460: --Throw Error invalid record type
2461: if g_debug then
2462: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2463: end if;
2464: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('PERSON_ID',l_record_typ_cd);
2467: fnd_message.raise_error;
2468: --

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

2461: if g_debug then
2462: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2463: end if;
2464: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('PERSON_ID',l_record_typ_cd);
2467: fnd_message.raise_error;
2468: --
2469: END IF;

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

2462: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2463: end if;
2464: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('PERSON_ID',l_record_typ_cd);
2467: fnd_message.raise_error;
2468: --
2469: END IF;
2470: --

Line 2467: fnd_message.raise_error;

2463: end if;
2464: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('PERSON_ID',l_record_typ_cd);
2467: fnd_message.raise_error;
2468: --
2469: END IF;
2470: --
2471: END IF;

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

2472: ELSE
2473: if g_debug then
2474: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2475: end if;
2476: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2477: fnd_message.set_token('PROC',l_proc);
2478: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2479: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2480: fnd_message.set_token('LE_DATE', p_life_event_date);

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

2473: if g_debug then
2474: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2475: end if;
2476: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2477: fnd_message.set_token('PROC',l_proc);
2478: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2479: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2480: fnd_message.set_token('LE_DATE', p_life_event_date);
2481: fnd_message.raise_error;

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

2474: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2475: end if;
2476: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2477: fnd_message.set_token('PROC',l_proc);
2478: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2479: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2480: fnd_message.set_token('LE_DATE', p_life_event_date);
2481: fnd_message.raise_error;
2482: --

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

2475: end if;
2476: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2477: fnd_message.set_token('PROC',l_proc);
2478: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2479: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2480: fnd_message.set_token('LE_DATE', p_life_event_date);
2481: fnd_message.raise_error;
2482: --
2483: END IF;

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

2476: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2477: fnd_message.set_token('PROC',l_proc);
2478: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2479: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2480: fnd_message.set_token('LE_DATE', p_life_event_date);
2481: fnd_message.raise_error;
2482: --
2483: END IF;
2484: --

Line 2481: fnd_message.raise_error;

2477: fnd_message.set_token('PROC',l_proc);
2478: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2479: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2480: fnd_message.set_token('LE_DATE', p_life_event_date);
2481: fnd_message.raise_error;
2482: --
2483: END IF;
2484: --
2485: exception when others then

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

2658: );
2659: --
2660: IF l_prtt_enrt_rslt_id IS NULL THEN
2661: --
2662: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2663: fnd_message.set_token('PROC',l_proc);
2664: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2665: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

2659: --
2660: IF l_prtt_enrt_rslt_id IS NULL THEN
2661: --
2662: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2663: fnd_message.set_token('PROC',l_proc);
2664: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2665: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2667: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

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

2660: IF l_prtt_enrt_rslt_id IS NULL THEN
2661: --
2662: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2663: fnd_message.set_token('PROC',l_proc);
2664: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2665: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2667: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2668: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));

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

2661: --
2662: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2663: fnd_message.set_token('PROC',l_proc);
2664: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2665: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2667: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2668: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2669: fnd_message.set_token('LE_DATE',p_life_event_date);

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

2662: fnd_message.set_name('BEN','BEN_94614_NO_PEN_FOR_BNF');
2663: fnd_message.set_token('PROC',l_proc);
2664: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2665: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2667: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2668: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2669: fnd_message.set_token('LE_DATE',p_life_event_date);
2670: fnd_message.raise_error;

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

2663: fnd_message.set_token('PROC',l_proc);
2664: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2665: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2667: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2668: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2669: fnd_message.set_token('LE_DATE',p_life_event_date);
2670: fnd_message.raise_error;
2671: --

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

2664: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2665: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2667: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2668: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2669: fnd_message.set_token('LE_DATE',p_life_event_date);
2670: fnd_message.raise_error;
2671: --
2672: END IF;

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

2665: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2667: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2668: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2669: fnd_message.set_token('LE_DATE',p_life_event_date);
2670: fnd_message.raise_error;
2671: --
2672: END IF;
2673: --

Line 2670: fnd_message.raise_error;

2666: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2667: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2668: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2669: fnd_message.set_token('LE_DATE',p_life_event_date);
2670: fnd_message.raise_error;
2671: --
2672: END IF;
2673: --
2674: open get_rslt_ovn_c;

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

2680: --
2681: if g_debug then
2682: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2683: end if;
2684: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2685: fnd_message.set_token('PROC',l_proc);
2686: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2687: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2688: fnd_message.set_token('LE_DATE', p_life_event_date);

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

2681: if g_debug then
2682: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2683: end if;
2684: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2685: fnd_message.set_token('PROC',l_proc);
2686: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2687: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2688: fnd_message.set_token('LE_DATE', p_life_event_date);
2689: fnd_message.raise_error;

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

2682: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2683: end if;
2684: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2685: fnd_message.set_token('PROC',l_proc);
2686: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2687: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2688: fnd_message.set_token('LE_DATE', p_life_event_date);
2689: fnd_message.raise_error;
2690: --

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

2683: end if;
2684: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2685: fnd_message.set_token('PROC',l_proc);
2686: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2687: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2688: fnd_message.set_token('LE_DATE', p_life_event_date);
2689: fnd_message.raise_error;
2690: --
2691: END IF ;

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

2684: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2685: fnd_message.set_token('PROC',l_proc);
2686: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2687: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2688: fnd_message.set_token('LE_DATE', p_life_event_date);
2689: fnd_message.raise_error;
2690: --
2691: END IF ;
2692: --

Line 2689: fnd_message.raise_error;

2685: fnd_message.set_token('PROC',l_proc);
2686: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2687: fnd_message.set_token('LER_ID',to_char(p_ler_id));
2688: fnd_message.set_token('LE_DATE', p_life_event_date);
2689: fnd_message.raise_error;
2690: --
2691: END IF ;
2692: --
2693: get_pbn

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

2798: --Bad case why are we here ???
2799: fnd_file.put_line
2800: (which => fnd_file.log,
2801: buff => 'Nothing happended... something wrong...');
2802: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2803: fnd_message.set_token('PROC',l_proc);
2804: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2805: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

2799: fnd_file.put_line
2800: (which => fnd_file.log,
2801: buff => 'Nothing happended... something wrong...');
2802: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2803: fnd_message.set_token('PROC',l_proc);
2804: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2805: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2807: fnd_message.set_token('OPT_ID',to_char(p_opt_id));

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

2800: (which => fnd_file.log,
2801: buff => 'Nothing happended... something wrong...');
2802: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2803: fnd_message.set_token('PROC',l_proc);
2804: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2805: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2807: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2808: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));

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

2801: buff => 'Nothing happended... something wrong...');
2802: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2803: fnd_message.set_token('PROC',l_proc);
2804: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2805: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2807: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2808: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2809: fnd_message.set_token('LE_DATE',p_life_event_date);

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

2802: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2803: fnd_message.set_token('PROC',l_proc);
2804: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2805: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2807: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2808: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2809: fnd_message.set_token('LE_DATE',p_life_event_date);
2810: fnd_message.raise_error;

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

2803: fnd_message.set_token('PROC',l_proc);
2804: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2805: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2807: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2808: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2809: fnd_message.set_token('LE_DATE',p_life_event_date);
2810: fnd_message.raise_error;
2811: --

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

2804: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2805: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2807: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2808: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2809: fnd_message.set_token('LE_DATE',p_life_event_date);
2810: fnd_message.raise_error;
2811: --
2812: END IF;

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

2805: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2807: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2808: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2809: fnd_message.set_token('LE_DATE',p_life_event_date);
2810: fnd_message.raise_error;
2811: --
2812: END IF;
2813: --

Line 2810: fnd_message.raise_error;

2806: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2807: fnd_message.set_token('OPT_ID',to_char(p_opt_id));
2808: fnd_message.set_token('PER_IN_LER_ID',to_char(l_pil.per_in_ler_id));
2809: fnd_message.set_token('LE_DATE',p_life_event_date);
2810: fnd_message.raise_error;
2811: --
2812: END IF;
2813: --
2814: -- IF l_prtt_enrt_rslt_id IS NOT NULL THEN