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

APPS.GHR_BENEFITS_EIT dependencies on HR_UTILITY

Line 290: hr_utility.set_location('Program ID ' || l_pgm_id,1234);

286: l_pgm_id := pgm_rec.pgm_id;
287: EXIT;
288: END LOOP;
289:
290: hr_utility.set_location('Program ID ' || l_pgm_id,1234);
291: If l_pgm_id is null Then
292: -- Raise Error message
293: hr_utility.set_message_token('PROGRAM','Federal Employee Health Benefits program');
294: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');

Line 293: hr_utility.set_message_token('PROGRAM','Federal Employee Health Benefits program');

289:
290: hr_utility.set_location('Program ID ' || l_pgm_id,1234);
291: If l_pgm_id is null Then
292: -- Raise Error message
293: hr_utility.set_message_token('PROGRAM','Federal Employee Health Benefits program');
294: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
295: hr_utility.raise_error;
296: End If;
297:

Line 294: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');

290: hr_utility.set_location('Program ID ' || l_pgm_id,1234);
291: If l_pgm_id is null Then
292: -- Raise Error message
293: hr_utility.set_message_token('PROGRAM','Federal Employee Health Benefits program');
294: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
295: hr_utility.raise_error;
296: End If;
297:
298: -- Check if Person is already enrolled

Line 295: hr_utility.raise_error;

291: If l_pgm_id is null Then
292: -- Raise Error message
293: hr_utility.set_message_token('PROGRAM','Federal Employee Health Benefits program');
294: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
295: hr_utility.raise_error;
296: End If;
297:
298: -- Check if Person is already enrolled
299: /* l_exists := FALSE;

Line 326: hr_utility.set_location('person_id is ' || p_person_id,1235);

322:
323: End Loop;
324:
325:
326: hr_utility.set_location('person_id is ' || p_person_id,1235);
327: hr_utility.set_location('l_effective_date is ' || p_effective_date,1236);
328: hr_utility.set_location('business_group_id is ' || p_business_group_id,1237);
329:
330: --Check if person is having more than one life event

Line 327: hr_utility.set_location('l_effective_date is ' || p_effective_date,1236);

323: End Loop;
324:
325:
326: hr_utility.set_location('person_id is ' || p_person_id,1235);
327: hr_utility.set_location('l_effective_date is ' || p_effective_date,1236);
328: hr_utility.set_location('business_group_id is ' || p_business_group_id,1237);
329:
330: --Check if person is having more than one life event
331: -- in unprocessed status. If any other life event

Line 328: hr_utility.set_location('business_group_id is ' || p_business_group_id,1237);

324:
325:
326: hr_utility.set_location('person_id is ' || p_person_id,1235);
327: hr_utility.set_location('l_effective_date is ' || p_effective_date,1236);
328: hr_utility.set_location('business_group_id is ' || p_business_group_id,1237);
329:
330: --Check if person is having more than one life event
331: -- in unprocessed status. If any other life event
332: -- which is unprocessed need to be processed or voided

Line 337: hr_utility.set_message(8301,'GHR_38519_UNPRC_LF_EVT');

333: -- for processing the current life event
334: -- Unprocessed Life Event Exists
335: For unproc_lf_evt in c_get_unproc_lf_evt
336: Loop
337: hr_utility.set_message(8301,'GHR_38519_UNPRC_LF_EVT');
338: hr_utility.raise_error;
339: End Loop;
340:
341: For ler_rec in c_get_ler_id loop

Line 338: hr_utility.raise_error;

334: -- Unprocessed Life Event Exists
335: For unproc_lf_evt in c_get_unproc_lf_evt
336: Loop
337: hr_utility.set_message(8301,'GHR_38519_UNPRC_LF_EVT');
338: hr_utility.raise_error;
339: End Loop;
340:
341: For ler_rec in c_get_ler_id loop
342: l_ler_id := ler_rec.ler_id;

Line 346: hr_utility.set_message(8301,'GHR_38520_NO_LFEVT_EXISTS');

342: l_ler_id := ler_rec.ler_id;
343: End Loop;
344:
345: /* If l_ler_id is null then
346: hr_utility.set_message(8301,'GHR_38520_NO_LFEVT_EXISTS');
347: hr_utility.raise_error;
348: End If; */
349: IF l_ler_id is not null THEN
350: hr_utility.set_location('Life event ID ' || l_ler_id,1234);

Line 347: hr_utility.raise_error;

343: End Loop;
344:
345: /* If l_ler_id is null then
346: hr_utility.set_message(8301,'GHR_38520_NO_LFEVT_EXISTS');
347: hr_utility.raise_error;
348: End If; */
349: IF l_ler_id is not null THEN
350: hr_utility.set_location('Life event ID ' || l_ler_id,1234);
351:

Line 350: hr_utility.set_location('Life event ID ' || l_ler_id,1234);

346: hr_utility.set_message(8301,'GHR_38520_NO_LFEVT_EXISTS');
347: hr_utility.raise_error;
348: End If; */
349: IF l_ler_id is not null THEN
350: hr_utility.set_location('Life event ID ' || l_ler_id,1234);
351:
352: -- Calling BENMNGLE
353:
354: ben_on_line_lf_evt.p_evt_lf_evts_from_benauthe(

Line 392: hr_utility.set_location('Plan type ID ' || l_pl_typ_id,1234);

388: Loop
389: l_pl_typ_id := plt_rec.pl_typ_id;
390: exit;
391: End Loop;
392: hr_utility.set_location('Plan type ID ' || l_pl_typ_id,1234);
393:
394: -- Get Plan type in Program ID
395: For ptip_rec in get_ptip_id(l_pl_typ_id,l_pgm_id,l_effective_date) loop
396: l_ptip_id := ptip_rec.ptip_id;

Line 398: hr_utility.set_location('Plan type in Prog ID ' || l_ptip_id,1234);

394: -- Get Plan type in Program ID
395: For ptip_rec in get_ptip_id(l_pl_typ_id,l_pgm_id,l_effective_date) loop
396: l_ptip_id := ptip_rec.ptip_id;
397: End Loop;
398: hr_utility.set_location('Plan type in Prog ID ' || l_ptip_id,1234);
399:
400: -- Get Plan ID
401: For pl_rec in get_pl_id(l_pl_code, l_business_group_id, l_effective_date) loop
402: l_pl_id := pl_rec.pl_id;

Line 405: hr_utility.set_location('Plan ID ' || l_pl_id,1234);

401: For pl_rec in get_pl_id(l_pl_code, l_business_group_id, l_effective_date) loop
402: l_pl_id := pl_rec.pl_id;
403: End Loop;
404:
405: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
406:
407: IF l_pl_id IS NULL THEN
408: hr_utility.set_message_token('PLAN','Federal Employee Health Benefits plan ' || l_pl_code);
409: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

Line 408: hr_utility.set_message_token('PLAN','Federal Employee Health Benefits plan ' || l_pl_code);

404:
405: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
406:
407: IF l_pl_id IS NULL THEN
408: hr_utility.set_message_token('PLAN','Federal Employee Health Benefits plan ' || l_pl_code);
409: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
410: hr_utility.raise_error;
411: END IF;
412:

Line 409: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

405: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
406:
407: IF l_pl_id IS NULL THEN
408: hr_utility.set_message_token('PLAN','Federal Employee Health Benefits plan ' || l_pl_code);
409: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
410: hr_utility.raise_error;
411: END IF;
412:
413:

Line 410: hr_utility.raise_error;

406:
407: IF l_pl_id IS NULL THEN
408: hr_utility.set_message_token('PLAN','Federal Employee Health Benefits plan ' || l_pl_code);
409: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
410: hr_utility.raise_error;
411: END IF;
412:
413:
414: -- Get Options ID

Line 430: hr_utility.set_location('Option ID ' || l_opt_id,1234);

426: Loop
427: l_opt_id := opt_rec.opt_id;
428: End Loop;
429:
430: hr_utility.set_location('Option ID ' || l_opt_id,1234);
431: If l_opt_id IS NULL then
432: hr_utility.set_location ('NO option found ',1234);
433: hr_utility.set_message_token('OPTION','FEHB Option ' || l_opt_code);
434: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

Line 432: hr_utility.set_location ('NO option found ',1234);

428: End Loop;
429:
430: hr_utility.set_location('Option ID ' || l_opt_id,1234);
431: If l_opt_id IS NULL then
432: hr_utility.set_location ('NO option found ',1234);
433: hr_utility.set_message_token('OPTION','FEHB Option ' || l_opt_code);
434: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
435: hr_utility.raise_error;
436: END IF;

Line 433: hr_utility.set_message_token('OPTION','FEHB Option ' || l_opt_code);

429:
430: hr_utility.set_location('Option ID ' || l_opt_id,1234);
431: If l_opt_id IS NULL then
432: hr_utility.set_location ('NO option found ',1234);
433: hr_utility.set_message_token('OPTION','FEHB Option ' || l_opt_code);
434: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
435: hr_utility.raise_error;
436: END IF;
437: END IF;

Line 434: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

430: hr_utility.set_location('Option ID ' || l_opt_id,1234);
431: If l_opt_id IS NULL then
432: hr_utility.set_location ('NO option found ',1234);
433: hr_utility.set_message_token('OPTION','FEHB Option ' || l_opt_code);
434: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
435: hr_utility.raise_error;
436: END IF;
437: END IF;
438:

Line 435: hr_utility.raise_error;

431: If l_opt_id IS NULL then
432: hr_utility.set_location ('NO option found ',1234);
433: hr_utility.set_message_token('OPTION','FEHB Option ' || l_opt_code);
434: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
435: hr_utility.raise_error;
436: END IF;
437: END IF;
438:
439: -- Get Plan in Program ID

Line 444: hr_utility.set_location('Plan in prog ID ' || l_plip_id,1234);

440: FOR plip_id_rec in get_plip_id(l_pl_id, l_pgm_id, l_business_group_id, l_effective_date) loop
441: l_plip_id := plip_id_rec.plip_id;
442: END LOOP;
443:
444: hr_utility.set_location('Plan in prog ID ' || l_plip_id,1234);
445: -- get oipl_id
446: IF l_opt_id IS NOT NULL THEN
447: FOR oipl_id_rec in get_oipl_id(l_pl_id,l_opt_id ,l_business_group_id ,l_effective_date ) loop
448: l_oipl_id := oipl_id_rec.oipl_id;

Line 451: hr_utility.set_message_token('PROGRAM ','FEHB');

447: FOR oipl_id_rec in get_oipl_id(l_pl_id,l_opt_id ,l_business_group_id ,l_effective_date ) loop
448: l_oipl_id := oipl_id_rec.oipl_id;
449: END LOOP;
450: IF l_oipl_id IS NULL THEN
451: hr_utility.set_message_token('PROGRAM ','FEHB');
452: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);
453: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
454: hr_utility.raise_error;
455: END IF;

Line 452: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);

448: l_oipl_id := oipl_id_rec.oipl_id;
449: END LOOP;
450: IF l_oipl_id IS NULL THEN
451: hr_utility.set_message_token('PROGRAM ','FEHB');
452: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);
453: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
454: hr_utility.raise_error;
455: END IF;
456: ELSE

Line 453: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');

449: END LOOP;
450: IF l_oipl_id IS NULL THEN
451: hr_utility.set_message_token('PROGRAM ','FEHB');
452: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);
453: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
454: hr_utility.raise_error;
455: END IF;
456: ELSE
457: l_oipl_id := null;

Line 454: hr_utility.raise_error;

450: IF l_oipl_id IS NULL THEN
451: hr_utility.set_message_token('PROGRAM ','FEHB');
452: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);
453: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
454: hr_utility.raise_error;
455: END IF;
456: ELSE
457: l_oipl_id := null;
458: END IF;

Line 460: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);

456: ELSE
457: l_oipl_id := null;
458: END IF;
459:
460: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);
461:
462: -- Create Potential Life event
463: -- No need for this now... Need
464: /*

Line 477: --hr_utility.trace_off;

473: l_ler_id := ler_rec.ler_id;
474: end loop;
475: */
476:
477: --hr_utility.trace_off;
478:
479: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
480: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);

Line 479: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);

475: */
476:
477: --hr_utility.trace_off;
478:
479: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
480: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);

Line 480: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);

476:
477: --hr_utility.trace_off;
478:
479: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
480: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
484: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);

Line 481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);

477: --hr_utility.trace_off;
478:
479: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
480: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
484: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
485: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);

Line 482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);

478:
479: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
480: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
484: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
485: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
486: hr_utility.set_location('l_person_id ' || l_person_id,1235);

Line 483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);

479: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
480: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
484: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
485: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
486: hr_utility.set_location('l_person_id ' || l_person_id,1235);
487: If l_oipl_id is not null Then

Line 484: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);

480: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
484: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
485: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
486: hr_utility.set_location('l_person_id ' || l_person_id,1235);
487: If l_oipl_id is not null Then
488: open get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,

Line 485: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);

481: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
484: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
485: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
486: hr_utility.set_location('l_person_id ' || l_person_id,1235);
487: If l_oipl_id is not null Then
488: open get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
489: l_ptip_id , l_oipl_id , l_ler_id , l_person_id) ;

Line 486: hr_utility.set_location('l_person_id ' || l_person_id,1235);

482: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
483: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
484: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
485: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
486: hr_utility.set_location('l_person_id ' || l_person_id,1235);
487: If l_oipl_id is not null Then
488: open get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
489: l_ptip_id , l_oipl_id , l_ler_id , l_person_id) ;
490: fetch get_elig_chc_id_opt into l_elig_per_elctbl_chc_id,l_per_in_ler_id,l_prtt_enrt_rslt_id;

Line 492: hr_utility.set_message_token('PLAN_OPT', l_pl_code || '/' || l_opt_code);

488: open get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
489: l_ptip_id , l_oipl_id , l_ler_id , l_person_id) ;
490: fetch get_elig_chc_id_opt into l_elig_per_elctbl_chc_id,l_per_in_ler_id,l_prtt_enrt_rslt_id;
491: If get_elig_chc_id_opt%NOTFOUND then
492: hr_utility.set_message_token('PLAN_OPT', l_pl_code || '/' || l_opt_code);
493: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
494: hr_utility.raise_error;
495: End If;
496: Else

Line 493: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');

489: l_ptip_id , l_oipl_id , l_ler_id , l_person_id) ;
490: fetch get_elig_chc_id_opt into l_elig_per_elctbl_chc_id,l_per_in_ler_id,l_prtt_enrt_rslt_id;
491: If get_elig_chc_id_opt%NOTFOUND then
492: hr_utility.set_message_token('PLAN_OPT', l_pl_code || '/' || l_opt_code);
493: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
494: hr_utility.raise_error;
495: End If;
496: Else
497: open get_elig_chc_id(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,

Line 494: hr_utility.raise_error;

490: fetch get_elig_chc_id_opt into l_elig_per_elctbl_chc_id,l_per_in_ler_id,l_prtt_enrt_rslt_id;
491: If get_elig_chc_id_opt%NOTFOUND then
492: hr_utility.set_message_token('PLAN_OPT', l_pl_code || '/' || l_opt_code);
493: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
494: hr_utility.raise_error;
495: End If;
496: Else
497: open get_elig_chc_id(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
498: l_ptip_id , l_ler_id , l_person_id) ;

Line 501: hr_utility.set_message_token('PLAN_OPT', l_pl_code);

497: open get_elig_chc_id(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
498: l_ptip_id , l_ler_id , l_person_id) ;
499: fetch get_elig_chc_id into l_elig_per_elctbl_chc_id,l_per_in_ler_id,l_prtt_enrt_rslt_id;
500: If get_elig_chc_id%NOTFOUND then
501: hr_utility.set_message_token('PLAN_OPT', l_pl_code);
502: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
503: hr_utility.raise_error;
504: End If;
505: End If;

Line 502: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');

498: l_ptip_id , l_ler_id , l_person_id) ;
499: fetch get_elig_chc_id into l_elig_per_elctbl_chc_id,l_per_in_ler_id,l_prtt_enrt_rslt_id;
500: If get_elig_chc_id%NOTFOUND then
501: hr_utility.set_message_token('PLAN_OPT', l_pl_code);
502: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
503: hr_utility.raise_error;
504: End If;
505: End If;
506:

Line 503: hr_utility.raise_error;

499: fetch get_elig_chc_id into l_elig_per_elctbl_chc_id,l_per_in_ler_id,l_prtt_enrt_rslt_id;
500: If get_elig_chc_id%NOTFOUND then
501: hr_utility.set_message_token('PLAN_OPT', l_pl_code);
502: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
503: hr_utility.raise_error;
504: End If;
505: End If;
506:
507:

Line 553: hr_utility.set_location('p_assignment_id'||p_assignment_id,1000);

549: ,p_cls_enrt_flag => 'N'
550: ,p_business_group_id => l_business_group_id
551: ,p_effective_date => l_effective_date);
552:
553: hr_utility.set_location('p_assignment_id'||p_assignment_id,1000);
554: hr_utility.set_location('l_business_group_id'||l_business_group_id,1001);
555: hr_utility.set_location('l_effective_date'||l_effective_date,1002);
556:
557: for cur_cvrg_st_dt in c_get_cvg_st_dt

Line 554: hr_utility.set_location('l_business_group_id'||l_business_group_id,1001);

550: ,p_business_group_id => l_business_group_id
551: ,p_effective_date => l_effective_date);
552:
553: hr_utility.set_location('p_assignment_id'||p_assignment_id,1000);
554: hr_utility.set_location('l_business_group_id'||l_business_group_id,1001);
555: hr_utility.set_location('l_effective_date'||l_effective_date,1002);
556:
557: for cur_cvrg_st_dt in c_get_cvg_st_dt
558: loop

Line 555: hr_utility.set_location('l_effective_date'||l_effective_date,1002);

551: ,p_effective_date => l_effective_date);
552:
553: hr_utility.set_location('p_assignment_id'||p_assignment_id,1000);
554: hr_utility.set_location('l_business_group_id'||l_business_group_id,1001);
555: hr_utility.set_location('l_effective_date'||l_effective_date,1002);
556:
557: for cur_cvrg_st_dt in c_get_cvg_st_dt
558: loop
559: l_cvrg_st_dt := cur_cvrg_st_dt.enrt_cvg_strt_dt;

Line 593: hr_utility.set_location('Error tsp: ' || l_err_msg,1234);

589: errbuf := 'Enrollment already exists';
590: retcode := 2;
591: WHEN Nothing_to_do THEN
592: errbuf := l_err_msg;
593: hr_utility.set_location('Error tsp: ' || l_err_msg,1234);
594: retcode := 2;
595: WHEN OTHERS THEN
596: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
597: hr_utility.set_location('Error tsp: ' || sqlerrm,1234);

Line 597: hr_utility.set_location('Error tsp: ' || sqlerrm,1234);

593: hr_utility.set_location('Error tsp: ' || l_err_msg,1234);
594: retcode := 2;
595: WHEN OTHERS THEN
596: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
597: hr_utility.set_location('Error tsp: ' || sqlerrm,1234);
598: retcode := 2;
599: hr_utility.raise_error;
600: END ghr_benefits_fehb;
601:

Line 599: hr_utility.raise_error;

595: WHEN OTHERS THEN
596: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
597: hr_utility.set_location('Error tsp: ' || sqlerrm,1234);
598: retcode := 2;
599: hr_utility.raise_error;
600: END ghr_benefits_fehb;
601:
602:
603: PROCEDURE ghr_benefits_tsp

Line 773: -- hr_utility.trace_on(null,'sundar');

769: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
770: l_business_group_id := p_business_group_id;
771: l_opt_name := p_opt_name;
772:
773: -- hr_utility.trace_on(null,'sundar');
774:
775: dt_fndate.change_ses_date (p_ses_date => TRUNC (SYSDATE),
776: p_commit => l_commit
777: );

Line 789: hr_utility.set_location('Program ID ' || l_pgm_id,1234);

785: l_pgm_id := pgm_rec.pgm_id;
786: EXIT;
787: END LOOP;
788:
789: hr_utility.set_location('Program ID ' || l_pgm_id,1234);
790:
791: If l_pgm_id is null Then
792: -- Raise Error message
793: hr_utility.set_message_token('PROGRAM','Federal Thrift Savings Plan (TSP) program');

Line 793: hr_utility.set_message_token('PROGRAM','Federal Thrift Savings Plan (TSP) program');

789: hr_utility.set_location('Program ID ' || l_pgm_id,1234);
790:
791: If l_pgm_id is null Then
792: -- Raise Error message
793: hr_utility.set_message_token('PROGRAM','Federal Thrift Savings Plan (TSP) program');
794: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
795: hr_utility.raise_error;
796: End If;
797:

Line 794: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');

790:
791: If l_pgm_id is null Then
792: -- Raise Error message
793: hr_utility.set_message_token('PROGRAM','Federal Thrift Savings Plan (TSP) program');
794: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
795: hr_utility.raise_error;
796: End If;
797:
798: -- Check if Person is already enrolled

Line 795: hr_utility.raise_error;

791: If l_pgm_id is null Then
792: -- Raise Error message
793: hr_utility.set_message_token('PROGRAM','Federal Thrift Savings Plan (TSP) program');
794: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
795: hr_utility.raise_error;
796: End If;
797:
798: -- Check if Person is already enrolled
799: /* l_exists := FALSE;

Line 814: hr_utility.set_location('Plan type ID ' || l_pl_typ_id,1234);

810: FOR plt_rec in c_get_pl_typ_id('Savings Plan', l_business_group_id, l_effective_date) loop
811: l_pl_typ_id := plt_rec.pl_typ_id;
812: EXIT;
813: END LOOP;
814: hr_utility.set_location('Plan type ID ' || l_pl_typ_id,1234);
815:
816: -- Get Plan type in Program ID
817: FOR ptip_rec in get_ptip_id(l_pl_typ_id,l_pgm_id,l_effective_date) loop
818: l_ptip_id := ptip_rec.ptip_id;

Line 820: hr_utility.set_location('Plan type in Prog ID ' || l_ptip_id,1234);

816: -- Get Plan type in Program ID
817: FOR ptip_rec in get_ptip_id(l_pl_typ_id,l_pgm_id,l_effective_date) loop
818: l_ptip_id := ptip_rec.ptip_id;
819: END LOOP;
820: hr_utility.set_location('Plan type in Prog ID ' || l_ptip_id,1234);
821:
822: -- Get Plan ID
823: FOR pl_rec in get_pl_id('TSP', l_business_group_id, l_effective_date) loop
824: l_pl_id := pl_rec.pl_id;

Line 826: hr_utility.set_location('Plan ID ' || l_pl_id,1234);

822: -- Get Plan ID
823: FOR pl_rec in get_pl_id('TSP', l_business_group_id, l_effective_date) loop
824: l_pl_id := pl_rec.pl_id;
825: END LOOP;
826: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
827:
828: IF l_pl_id IS NULL THEN
829: hr_utility.set_message_token('PLAN','Federal Thrift Savings Plan (TSP)');
830: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

Line 829: hr_utility.set_message_token('PLAN','Federal Thrift Savings Plan (TSP)');

825: END LOOP;
826: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
827:
828: IF l_pl_id IS NULL THEN
829: hr_utility.set_message_token('PLAN','Federal Thrift Savings Plan (TSP)');
830: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
831: hr_utility.raise_error;
832: END IF;
833:

Line 830: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

826: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
827:
828: IF l_pl_id IS NULL THEN
829: hr_utility.set_message_token('PLAN','Federal Thrift Savings Plan (TSP)');
830: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
831: hr_utility.raise_error;
832: END IF;
833:
834: ben_on_line_lf_evt.p_manage_life_events(

Line 831: hr_utility.raise_error;

827:
828: IF l_pl_id IS NULL THEN
829: hr_utility.set_message_token('PLAN','Federal Thrift Savings Plan (TSP)');
830: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
831: hr_utility.raise_error;
832: END IF;
833:
834: ben_on_line_lf_evt.p_manage_life_events(
835: p_person_id => l_person_id

Line 861: hr_utility.set_location('Option ID ' || l_opt_id,1234);

857: FOR opt_rec in get_opt_id(l_opt_name, l_business_group_id, l_effective_date) loop
858: l_opt_id := opt_rec.opt_id;
859: END LOOP;
860:
861: hr_utility.set_location('Option ID ' || l_opt_id,1234);
862: IF l_opt_id IS NULL THEN
863: hr_utility.set_location ('NO option found ',1234);
864: hr_utility.set_message_token('OPTION','TSP Option ' || l_opt_name);
865: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

Line 863: hr_utility.set_location ('NO option found ',1234);

859: END LOOP;
860:
861: hr_utility.set_location('Option ID ' || l_opt_id,1234);
862: IF l_opt_id IS NULL THEN
863: hr_utility.set_location ('NO option found ',1234);
864: hr_utility.set_message_token('OPTION','TSP Option ' || l_opt_name);
865: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
866: hr_utility.raise_error;
867: End If;

Line 864: hr_utility.set_message_token('OPTION','TSP Option ' || l_opt_name);

860:
861: hr_utility.set_location('Option ID ' || l_opt_id,1234);
862: IF l_opt_id IS NULL THEN
863: hr_utility.set_location ('NO option found ',1234);
864: hr_utility.set_message_token('OPTION','TSP Option ' || l_opt_name);
865: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
866: hr_utility.raise_error;
867: End If;
868:

Line 865: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

861: hr_utility.set_location('Option ID ' || l_opt_id,1234);
862: IF l_opt_id IS NULL THEN
863: hr_utility.set_location ('NO option found ',1234);
864: hr_utility.set_message_token('OPTION','TSP Option ' || l_opt_name);
865: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
866: hr_utility.raise_error;
867: End If;
868:
869: -- Get Plan in Program ID

Line 866: hr_utility.raise_error;

862: IF l_opt_id IS NULL THEN
863: hr_utility.set_location ('NO option found ',1234);
864: hr_utility.set_message_token('OPTION','TSP Option ' || l_opt_name);
865: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
866: hr_utility.raise_error;
867: End If;
868:
869: -- Get Plan in Program ID
870: FOR plip_id_rec in get_plip_id(l_pl_id, l_pgm_id, l_business_group_id, l_effective_date) loop

Line 874: hr_utility.set_location('Plan in prog ID ' || l_plip_id,1234);

870: FOR plip_id_rec in get_plip_id(l_pl_id, l_pgm_id, l_business_group_id, l_effective_date) loop
871: l_plip_id := plip_id_rec.plip_id;
872: END LOOP;
873:
874: hr_utility.set_location('Plan in prog ID ' || l_plip_id,1234);
875: -- get oipl_id
876: FOR oipl_id_rec in get_oipl_id(l_pl_id,l_opt_id ,l_business_group_id ,l_effective_date ) loop
877: l_oipl_id := oipl_id_rec.oipl_id;
878: END LOOP;

Line 880: hr_utility.set_message_token('PROGRAM ','TSP');

876: FOR oipl_id_rec in get_oipl_id(l_pl_id,l_opt_id ,l_business_group_id ,l_effective_date ) loop
877: l_oipl_id := oipl_id_rec.oipl_id;
878: END LOOP;
879: IF l_oipl_id IS NULL THEN
880: hr_utility.set_message_token('PROGRAM ','TSP');
881: hr_utility.set_message_token('PLAN_OPTION', 'TSP' || '/' || l_opt_name);
882: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
883: hr_utility.raise_error;
884: END IF;

Line 881: hr_utility.set_message_token('PLAN_OPTION', 'TSP' || '/' || l_opt_name);

877: l_oipl_id := oipl_id_rec.oipl_id;
878: END LOOP;
879: IF l_oipl_id IS NULL THEN
880: hr_utility.set_message_token('PROGRAM ','TSP');
881: hr_utility.set_message_token('PLAN_OPTION', 'TSP' || '/' || l_opt_name);
882: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
883: hr_utility.raise_error;
884: END IF;
885:

Line 882: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');

878: END LOOP;
879: IF l_oipl_id IS NULL THEN
880: hr_utility.set_message_token('PROGRAM ','TSP');
881: hr_utility.set_message_token('PLAN_OPTION', 'TSP' || '/' || l_opt_name);
882: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
883: hr_utility.raise_error;
884: END IF;
885:
886: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);

Line 883: hr_utility.raise_error;

879: IF l_oipl_id IS NULL THEN
880: hr_utility.set_message_token('PROGRAM ','TSP');
881: hr_utility.set_message_token('PLAN_OPTION', 'TSP' || '/' || l_opt_name);
882: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
883: hr_utility.raise_error;
884: END IF;
885:
886: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);
887:

Line 886: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);

882: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
883: hr_utility.raise_error;
884: END IF;
885:
886: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);
887:
888: /*(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
889: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
890: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,

Line 892: hr_utility.set_location('p_manage_life_events done' ,1234);

888: /*(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
889: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
890: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
891: c_person_id per_all_people_f.person_id%type) */
892: hr_utility.set_location('p_manage_life_events done' ,1234);
893: for get_elig_chc_id in get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
894: l_ptip_id , l_oipl_id , l_person_id) loop
895: l_elig_per_elctbl_chc_id := get_elig_chc_id.elig_per_elctbl_chc_id;
896: l_per_in_ler_id := get_elig_chc_id.per_in_ler_id;

Line 899: hr_utility.set_location('l_elig_per_elctbl_chc_id ' || l_elig_per_elctbl_chc_id ,1234);

895: l_elig_per_elctbl_chc_id := get_elig_chc_id.elig_per_elctbl_chc_id;
896: l_per_in_ler_id := get_elig_chc_id.per_in_ler_id;
897: exit;
898: End Loop;
899: hr_utility.set_location('l_elig_per_elctbl_chc_id ' || l_elig_per_elctbl_chc_id ,1234);
900:
901: If l_elig_per_elctbl_chc_id is null Then
902: hr_utility.set_message(8301,'GHR_38971_BEN_TSP_INELIG');
903: hr_utility.raise_error;

Line 902: hr_utility.set_message(8301,'GHR_38971_BEN_TSP_INELIG');

898: End Loop;
899: hr_utility.set_location('l_elig_per_elctbl_chc_id ' || l_elig_per_elctbl_chc_id ,1234);
900:
901: If l_elig_per_elctbl_chc_id is null Then
902: hr_utility.set_message(8301,'GHR_38971_BEN_TSP_INELIG');
903: hr_utility.raise_error;
904: End If;
905:
906: for get_enrt_rt_id in c_get_enrt_rt_id(l_elig_per_elctbl_chc_id) loop

Line 903: hr_utility.raise_error;

899: hr_utility.set_location('l_elig_per_elctbl_chc_id ' || l_elig_per_elctbl_chc_id ,1234);
900:
901: If l_elig_per_elctbl_chc_id is null Then
902: hr_utility.set_message(8301,'GHR_38971_BEN_TSP_INELIG');
903: hr_utility.raise_error;
904: End If;
905:
906: for get_enrt_rt_id in c_get_enrt_rt_id(l_elig_per_elctbl_chc_id) loop
907: l_enrt_rt_id := get_enrt_rt_id.enrt_rt_id;

Line 948: -- hr_utility.trace_off;

944: );
945:
946: END IF;
947:
948: -- hr_utility.trace_off;
949: EXCEPTION
950: WHEN ben_enrt_exists THEN
951: null;
952: WHEN Nothing_to_do THEN

Line 953: hr_utility.set_location('Error tsp: ' || l_err_msg,1234);

949: EXCEPTION
950: WHEN ben_enrt_exists THEN
951: null;
952: WHEN Nothing_to_do THEN
953: hr_utility.set_location('Error tsp: ' || l_err_msg,1234);
954: rollback;
955: WHEN OTHERS THEN
956: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
957: hr_utility.set_location('Error tsp: ' || sqlerrm,1234);

Line 957: hr_utility.set_location('Error tsp: ' || sqlerrm,1234);

953: hr_utility.set_location('Error tsp: ' || l_err_msg,1234);
954: rollback;
955: WHEN OTHERS THEN
956: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
957: hr_utility.set_location('Error tsp: ' || sqlerrm,1234);
958: retcode := 2;
959: hr_utility.raise_error;
960: END ghr_benefits_tsp;
961:

Line 959: hr_utility.raise_error;

955: WHEN OTHERS THEN
956: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
957: hr_utility.set_location('Error tsp: ' || sqlerrm,1234);
958: retcode := 2;
959: hr_utility.raise_error;
960: END ghr_benefits_tsp;
961:
962:
963: --Bug # 4122470 FEGLI

Line 1190: hr_utility.set_location('person_id is ' || p_person_id,1235);

1186: l_business_group_id := p_business_group_id;
1187: l_pl_code := p_pl_code;
1188: l_opt_code := p_opt_code;
1189:
1190: hr_utility.set_location('person_id is ' || p_person_id,1235);
1191: hr_utility.set_location('l_effective_date is ' || p_effective_date,1236);
1192: hr_utility.set_location('business_group_id is ' || p_business_group_id,1237);
1193:
1194: --Changing the session date to todays date

Line 1191: hr_utility.set_location('l_effective_date is ' || p_effective_date,1236);

1187: l_pl_code := p_pl_code;
1188: l_opt_code := p_opt_code;
1189:
1190: hr_utility.set_location('person_id is ' || p_person_id,1235);
1191: hr_utility.set_location('l_effective_date is ' || p_effective_date,1236);
1192: hr_utility.set_location('business_group_id is ' || p_business_group_id,1237);
1193:
1194: --Changing the session date to todays date
1195: dt_fndate.change_ses_date (p_ses_date => TRUNC(SYSDATE),

Line 1192: hr_utility.set_location('business_group_id is ' || p_business_group_id,1237);

1188: l_opt_code := p_opt_code;
1189:
1190: hr_utility.set_location('person_id is ' || p_person_id,1235);
1191: hr_utility.set_location('l_effective_date is ' || p_effective_date,1236);
1192: hr_utility.set_location('business_group_id is ' || p_business_group_id,1237);
1193:
1194: --Changing the session date to todays date
1195: dt_fndate.change_ses_date (p_ses_date => TRUNC(SYSDATE),
1196: p_commit => l_commit

Line 1206: hr_utility.set_location('Program ID ' || l_pgm_id,1234);

1202: l_pgm_id := pgm_rec.pgm_id;
1203: EXIT;
1204: END LOOP;
1205:
1206: hr_utility.set_location('Program ID ' || l_pgm_id,1234);
1207: If l_pgm_id is null Then
1208: -- Raise Error message
1209: hr_utility.set_message_token('PROGRAM','Federal Employee Group Life Insurance program');
1210: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');

Line 1209: hr_utility.set_message_token('PROGRAM','Federal Employee Group Life Insurance program');

1205:
1206: hr_utility.set_location('Program ID ' || l_pgm_id,1234);
1207: If l_pgm_id is null Then
1208: -- Raise Error message
1209: hr_utility.set_message_token('PROGRAM','Federal Employee Group Life Insurance program');
1210: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
1211:
1212: hr_utility.raise_error;
1213:

Line 1210: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');

1206: hr_utility.set_location('Program ID ' || l_pgm_id,1234);
1207: If l_pgm_id is null Then
1208: -- Raise Error message
1209: hr_utility.set_message_token('PROGRAM','Federal Employee Group Life Insurance program');
1210: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
1211:
1212: hr_utility.raise_error;
1213:
1214: End If;

Line 1212: hr_utility.raise_error;

1208: -- Raise Error message
1209: hr_utility.set_message_token('PROGRAM','Federal Employee Group Life Insurance program');
1210: hr_utility.set_message(8301,'GHR_38966_BEN_PRG_INVALID');
1211:
1212: hr_utility.raise_error;
1213:
1214: End If;
1215:
1216:

Line 1221: hr_utility.set_location('Life event ID ' || l_ler_id,1234);

1217: --Bug # 12399570
1218: for ler_rec in c_get_ler_id(l_effective_date) loop
1219: l_ler_id := ler_rec.ler_id;
1220: end loop;
1221: hr_utility.set_location('Life event ID ' || l_ler_id,1234);
1222:
1223:
1224: open c_chk_le_exists(p_pgm_id => l_pgm_id,
1225: p_ler_id => l_ler_id);

Line 1230: hr_utility.set_location('le found',110);

1226: fetch c_chk_le_exists into l_le_exists;
1227: if c_chk_le_exists%found then
1228:
1229:
1230: hr_utility.set_location('le found',110);
1231:
1232: -- Get Plan type
1233: FOR plt_rec in c_get_pl_typ_id('FEGLI', l_business_group_id, l_effective_date)
1234: LOOP

Line 1238: hr_utility.set_location('Plan type ID ' || l_pl_typ_id,1234);

1234: LOOP
1235: l_pl_typ_id := plt_rec.pl_typ_id;
1236: EXIT;
1237: END LOOP;
1238: hr_utility.set_location('Plan type ID ' || l_pl_typ_id,1234);
1239:
1240: -- Get Plan type in Program ID
1241: FOR ptip_rec in get_ptip_id(l_pl_typ_id,l_pgm_id,l_effective_date)
1242: LOOP

Line 1246: hr_utility.set_location('Plan type in Prog ID ' || l_ptip_id,1234);

1242: LOOP
1243: l_ptip_id := ptip_rec.ptip_id;
1244: EXIT;
1245: END LOOP;
1246: hr_utility.set_location('Plan type in Prog ID ' || l_ptip_id,1234);
1247:
1248: -- Get Plan ID
1249: FOR pl_rec in get_pl_id(l_pl_code, l_business_group_id, l_effective_date) loop
1250: l_pl_id := pl_rec.pl_id;

Line 1252: hr_utility.set_location('Plan ID ' || l_pl_id,1234);

1248: -- Get Plan ID
1249: FOR pl_rec in get_pl_id(l_pl_code, l_business_group_id, l_effective_date) loop
1250: l_pl_id := pl_rec.pl_id;
1251: END LOOP;
1252: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
1253:
1254: IF l_pl_id IS NULL THEN
1255: hr_utility.set_message_token('PLAN','Federal Employee Group Life Insurance Plan ' || l_pl_code);
1256: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

Line 1255: hr_utility.set_message_token('PLAN','Federal Employee Group Life Insurance Plan ' || l_pl_code);

1251: END LOOP;
1252: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
1253:
1254: IF l_pl_id IS NULL THEN
1255: hr_utility.set_message_token('PLAN','Federal Employee Group Life Insurance Plan ' || l_pl_code);
1256: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
1257: hr_utility.raise_error;
1258: END IF;
1259:

Line 1256: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

1252: hr_utility.set_location('Plan ID ' || l_pl_id,1234);
1253:
1254: IF l_pl_id IS NULL THEN
1255: hr_utility.set_message_token('PLAN','Federal Employee Group Life Insurance Plan ' || l_pl_code);
1256: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
1257: hr_utility.raise_error;
1258: END IF;
1259:
1260: -- Get Plan in Program ID

Line 1257: hr_utility.raise_error;

1253:
1254: IF l_pl_id IS NULL THEN
1255: hr_utility.set_message_token('PLAN','Federal Employee Group Life Insurance Plan ' || l_pl_code);
1256: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
1257: hr_utility.raise_error;
1258: END IF;
1259:
1260: -- Get Plan in Program ID
1261: FOR plip_id_rec in get_plip_id(l_pl_id, l_pgm_id, l_business_group_id, l_effective_date) loop

Line 1264: hr_utility.set_location('Plan in prog ID ' || l_plip_id,1234);

1260: -- Get Plan in Program ID
1261: FOR plip_id_rec in get_plip_id(l_pl_id, l_pgm_id, l_business_group_id, l_effective_date) loop
1262: l_plip_id := plip_id_rec.plip_id;
1263: END LOOP;
1264: hr_utility.set_location('Plan in prog ID ' || l_plip_id,1234);
1265:
1266: -- Get Options ID
1267: IF p_opt_code IS NOT NULL THEN
1268: FOR opt_rec in get_opt_id(l_opt_code, l_business_group_id, l_effective_date)

Line 1272: hr_utility.set_location('Option ID ' || l_opt_id,1234);

1268: FOR opt_rec in get_opt_id(l_opt_code, l_business_group_id, l_effective_date)
1269: LOOP
1270: l_opt_id := opt_rec.opt_id;
1271: END LOOP;
1272: hr_utility.set_location('Option ID ' || l_opt_id,1234);
1273:
1274: IF l_opt_id IS NULL THEN
1275: hr_utility.set_location ('NO option found ',1234);
1276: hr_utility.set_message_token('OPTION','FEGLI Option ' || l_opt_code);

Line 1275: hr_utility.set_location ('NO option found ',1234);

1271: END LOOP;
1272: hr_utility.set_location('Option ID ' || l_opt_id,1234);
1273:
1274: IF l_opt_id IS NULL THEN
1275: hr_utility.set_location ('NO option found ',1234);
1276: hr_utility.set_message_token('OPTION','FEGLI Option ' || l_opt_code);
1277: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
1278: hr_utility.raise_error;
1279: END IF;

Line 1276: hr_utility.set_message_token('OPTION','FEGLI Option ' || l_opt_code);

1272: hr_utility.set_location('Option ID ' || l_opt_id,1234);
1273:
1274: IF l_opt_id IS NULL THEN
1275: hr_utility.set_location ('NO option found ',1234);
1276: hr_utility.set_message_token('OPTION','FEGLI Option ' || l_opt_code);
1277: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
1278: hr_utility.raise_error;
1279: END IF;
1280: END IF;

Line 1277: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');

1273:
1274: IF l_opt_id IS NULL THEN
1275: hr_utility.set_location ('NO option found ',1234);
1276: hr_utility.set_message_token('OPTION','FEGLI Option ' || l_opt_code);
1277: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
1278: hr_utility.raise_error;
1279: END IF;
1280: END IF;
1281:

Line 1278: hr_utility.raise_error;

1274: IF l_opt_id IS NULL THEN
1275: hr_utility.set_location ('NO option found ',1234);
1276: hr_utility.set_message_token('OPTION','FEGLI Option ' || l_opt_code);
1277: hr_utility.set_message(8301,'GHR_38967_BEN_PLAN_INVALID');
1278: hr_utility.raise_error;
1279: END IF;
1280: END IF;
1281:
1282: -- get option in plan

Line 1288: hr_utility.set_message_token('PROGRAM ','FEHB');

1284: FOR oipl_id_rec in get_oipl_id(l_pl_id,l_opt_id ,l_business_group_id ,l_effective_date ) loop
1285: l_oipl_id := oipl_id_rec.oipl_id;
1286: END LOOP;
1287: IF l_oipl_id IS NULL THEN
1288: hr_utility.set_message_token('PROGRAM ','FEHB');
1289: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);
1290: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
1291: hr_utility.raise_error;
1292: END IF;

Line 1289: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);

1285: l_oipl_id := oipl_id_rec.oipl_id;
1286: END LOOP;
1287: IF l_oipl_id IS NULL THEN
1288: hr_utility.set_message_token('PROGRAM ','FEHB');
1289: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);
1290: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
1291: hr_utility.raise_error;
1292: END IF;
1293: ELSE

Line 1290: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');

1286: END LOOP;
1287: IF l_oipl_id IS NULL THEN
1288: hr_utility.set_message_token('PROGRAM ','FEHB');
1289: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);
1290: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
1291: hr_utility.raise_error;
1292: END IF;
1293: ELSE
1294: l_oipl_id := null;

Line 1291: hr_utility.raise_error;

1287: IF l_oipl_id IS NULL THEN
1288: hr_utility.set_message_token('PROGRAM ','FEHB');
1289: hr_utility.set_message_token('PLAN_OPTION', l_pl_code || '/' || l_opt_code);
1290: hr_utility.set_message(8301,'GHR_38969_BEN_PLAN_OPT_INVALID');
1291: hr_utility.raise_error;
1292: END IF;
1293: ELSE
1294: l_oipl_id := null;
1295: END IF;

Line 1297: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);

1293: ELSE
1294: l_oipl_id := null;
1295: END IF;
1296:
1297: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);
1298:
1299:
1300:
1301: -- Calling BENMNGLE

Line 1302: --hr_utility.trace_on(null,'sundar');

1298:
1299:
1300:
1301: -- Calling BENMNGLE
1302: --hr_utility.trace_on(null,'sundar');
1303: ben_on_line_lf_evt.p_evt_lf_evts_from_benauthe(
1304: p_person_id => l_person_id
1305: ,p_effective_date => l_effective_date
1306: ,p_business_group_id => l_business_group_id

Line 1333: --hr_utility.trace_off;

1329: ,p_benefit_action_id => l_benefit_action_id
1330: ,p_errbuf => l_errbuf
1331: ,p_retcode => l_retcode);
1332:
1333: --hr_utility.trace_off;
1334:
1335: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
1336: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);

Line 1335: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);

1331: ,p_retcode => l_retcode);
1332:
1333: --hr_utility.trace_off;
1334:
1335: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
1336: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);

Line 1336: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);

1332:
1333: --hr_utility.trace_off;
1334:
1335: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
1336: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
1340: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);

Line 1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);

1333: --hr_utility.trace_off;
1334:
1335: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
1336: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
1340: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
1341: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);

Line 1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);

1334:
1335: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
1336: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
1340: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
1341: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
1342: hr_utility.set_location('l_person_id ' || l_person_id,1235);

Line 1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);

1335: hr_utility.set_location('l_ler_id ' || l_ler_id,1235);
1336: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
1340: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
1341: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
1342: hr_utility.set_location('l_person_id ' || l_person_id,1235);
1343:

Line 1340: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);

1336: hr_utility.set_location('l_pgm_id ' || l_pgm_id,1235);
1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
1340: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
1341: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
1342: hr_utility.set_location('l_person_id ' || l_person_id,1235);
1343:
1344: If l_oipl_id is not null Then

Line 1341: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);

1337: hr_utility.set_location('l_pl_typ_id ' || l_pl_typ_id,1235);
1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
1340: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
1341: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
1342: hr_utility.set_location('l_person_id ' || l_person_id,1235);
1343:
1344: If l_oipl_id is not null Then
1345: open get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,

Line 1342: hr_utility.set_location('l_person_id ' || l_person_id,1235);

1338: hr_utility.set_location('l_pl_id ' || l_pl_id,1235);
1339: hr_utility.set_location('l_plip_id ' || l_plip_id,1235);
1340: hr_utility.set_location('l_ptip_id ' || l_ptip_id,1235);
1341: hr_utility.set_location('l_oipl_id ' || l_oipl_id,1235);
1342: hr_utility.set_location('l_person_id ' || l_person_id,1235);
1343:
1344: If l_oipl_id is not null Then
1345: open get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
1346: l_ptip_id , l_oipl_id , l_ler_id , l_person_id) ;

Line 1349: hr_utility.set_message_token('PLAN_OPT', l_pl_code || '/' || l_opt_code);

1345: open get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
1346: l_ptip_id , l_oipl_id , l_ler_id , l_person_id) ;
1347: fetch get_elig_chc_id_opt into l_elig_per_elctbl_chc_id,l_per_in_ler_id;
1348: If get_elig_chc_id_opt%NOTFOUND then
1349: hr_utility.set_message_token('PLAN_OPT', l_pl_code || '/' || l_opt_code);
1350: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
1351: hr_utility.raise_error;
1352: End If;
1353: Else

Line 1350: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');

1346: l_ptip_id , l_oipl_id , l_ler_id , l_person_id) ;
1347: fetch get_elig_chc_id_opt into l_elig_per_elctbl_chc_id,l_per_in_ler_id;
1348: If get_elig_chc_id_opt%NOTFOUND then
1349: hr_utility.set_message_token('PLAN_OPT', l_pl_code || '/' || l_opt_code);
1350: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
1351: hr_utility.raise_error;
1352: End If;
1353: Else
1354: open get_elig_chc_id(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,

Line 1351: hr_utility.raise_error;

1347: fetch get_elig_chc_id_opt into l_elig_per_elctbl_chc_id,l_per_in_ler_id;
1348: If get_elig_chc_id_opt%NOTFOUND then
1349: hr_utility.set_message_token('PLAN_OPT', l_pl_code || '/' || l_opt_code);
1350: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
1351: hr_utility.raise_error;
1352: End If;
1353: Else
1354: open get_elig_chc_id(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
1355: l_ptip_id , l_ler_id , l_person_id) ;

Line 1358: hr_utility.set_message_token('PLAN_OPT', l_pl_code);

1354: open get_elig_chc_id(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,
1355: l_ptip_id , l_ler_id , l_person_id) ;
1356: fetch get_elig_chc_id into l_elig_per_elctbl_chc_id,l_per_in_ler_id;
1357: If get_elig_chc_id%NOTFOUND then
1358: hr_utility.set_message_token('PLAN_OPT', l_pl_code);
1359: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
1360: hr_utility.raise_error;
1361: End If;
1362: End If;

Line 1359: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');

1355: l_ptip_id , l_ler_id , l_person_id) ;
1356: fetch get_elig_chc_id into l_elig_per_elctbl_chc_id,l_per_in_ler_id;
1357: If get_elig_chc_id%NOTFOUND then
1358: hr_utility.set_message_token('PLAN_OPT', l_pl_code);
1359: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
1360: hr_utility.raise_error;
1361: End If;
1362: End If;
1363:

Line 1360: hr_utility.raise_error;

1356: fetch get_elig_chc_id into l_elig_per_elctbl_chc_id,l_per_in_ler_id;
1357: If get_elig_chc_id%NOTFOUND then
1358: hr_utility.set_message_token('PLAN_OPT', l_pl_code);
1359: hr_utility.set_message(8301,'GHR_38970_BEN_PLAN_INELIG');
1360: hr_utility.raise_error;
1361: End If;
1362: End If;
1363:
1364: -- Enrolling a person

Line 1418: hr_utility.set_location('Error Fegli Enrollment: ' || l_err_msg,1234);

1414: errbuf := 'Enrollment already exists';
1415: retcode := 2;
1416: WHEN Nothing_to_do THEN
1417: errbuf := l_err_msg;
1418: hr_utility.set_location('Error Fegli Enrollment: ' || l_err_msg,1234);
1419: retcode := 2;
1420: WHEN OTHERS THEN
1421: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
1422: hr_utility.set_location('Error Fegli Enrollment: ' || sqlerrm,1234);

Line 1422: hr_utility.set_location('Error Fegli Enrollment: ' || sqlerrm,1234);

1418: hr_utility.set_location('Error Fegli Enrollment: ' || l_err_msg,1234);
1419: retcode := 2;
1420: WHEN OTHERS THEN
1421: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
1422: hr_utility.set_location('Error Fegli Enrollment: ' || sqlerrm,1234);
1423: retcode := 2;
1424: hr_utility.raise_error;
1425: END ghr_benefits_fegli;
1426:

Line 1424: hr_utility.raise_error;

1420: WHEN OTHERS THEN
1421: errbuf := 'Err' || sqlcode || ' : ' || sqlerrm;
1422: hr_utility.set_location('Error Fegli Enrollment: ' || sqlerrm,1234);
1423: retcode := 2;
1424: hr_utility.raise_error;
1425: END ghr_benefits_fegli;
1426:
1427:
1428: END ghr_benefits_eit;