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.

[Home] [Help]

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: END ghr_benefits_eit;