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

APPS.BEN_SSPNDD_ENROLLMENT dependencies on FND_MESSAGE

Line 463: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');

459: --Start Interim Rule Enhancement
460: if l_return is NULL then
461: --Invalid Rule
462: hr_utility.set_location('BEN_94600_NULL_RETURNED',80);
463: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');
464: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
465: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));
466: fnd_message.raise_error;
467: --

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

460: if l_return is NULL then
461: --Invalid Rule
462: hr_utility.set_location('BEN_94600_NULL_RETURNED',80);
463: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');
464: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
465: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));
466: fnd_message.raise_error;
467: --
468: elsif instr('0123456789', substr(l_return,1,1) ) > 0 THEN

Line 465: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));

461: --Invalid Rule
462: hr_utility.set_location('BEN_94600_NULL_RETURNED',80);
463: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');
464: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
465: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));
466: fnd_message.raise_error;
467: --
468: elsif instr('0123456789', substr(l_return,1,1) ) > 0 THEN
469: --

Line 466: fnd_message.raise_error;

462: hr_utility.set_location('BEN_94600_NULL_RETURNED',80);
463: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');
464: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
465: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));
466: fnd_message.raise_error;
467: --
468: elsif instr('0123456789', substr(l_return,1,1) ) > 0 THEN
469: --
470: l_return := NULL;

Line 504: fnd_message.raise_error;

500: Exception
501: When others then
502: hr_utility.set_location ('Fail in '||l_proc|| ' step in '||
503: to_char(l_step),999);
504: fnd_message.raise_error;
505: End get_dflt_to_asn_pndg_ctfn_cd;
506: --
507: --
508: -- ==========================================================================

Line 636: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');

632: fetch c_epe into l_interim_epe ;
633: /* Bug 5225780 */
634: if c_epe%NOTFOUND or l_interim_epe.per_in_ler_id <> l_susp_epe.per_in_ler_id then
635: hr_utility.set_location('BEN_94628', 80);
636: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
637: fnd_message.set_token('PROC',l_proc);
638: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
639: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
640: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

633: /* Bug 5225780 */
634: if c_epe%NOTFOUND or l_interim_epe.per_in_ler_id <> l_susp_epe.per_in_ler_id then
635: hr_utility.set_location('BEN_94628', 80);
636: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
637: fnd_message.set_token('PROC',l_proc);
638: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
639: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
640: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
641: fnd_message.raise_error;

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

634: if c_epe%NOTFOUND or l_interim_epe.per_in_ler_id <> l_susp_epe.per_in_ler_id then
635: hr_utility.set_location('BEN_94628', 80);
636: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
637: fnd_message.set_token('PROC',l_proc);
638: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
639: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
640: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
641: fnd_message.raise_error;
642: end if;

Line 639: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

635: hr_utility.set_location('BEN_94628', 80);
636: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
637: fnd_message.set_token('PROC',l_proc);
638: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
639: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
640: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
641: fnd_message.raise_error;
642: end if;
643: /* End Bug 5225780 */

Line 640: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

636: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
637: fnd_message.set_token('PROC',l_proc);
638: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
639: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
640: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
641: fnd_message.raise_error;
642: end if;
643: /* End Bug 5225780 */
644: close c_epe;

Line 641: fnd_message.raise_error;

637: fnd_message.set_token('PROC',l_proc);
638: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
639: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
640: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
641: fnd_message.raise_error;
642: end if;
643: /* End Bug 5225780 */
644: close c_epe;
645: --

Line 651: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');

647: --
648: IF l_interim_epe.ptip_id <> l_susp_epe.ptip_id THEN
649: --
650: hr_utility.set_location('BEN_94601', 80);
651: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
652: fnd_message.set_token('PROC',l_proc);
653: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
654: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
655: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

648: IF l_interim_epe.ptip_id <> l_susp_epe.ptip_id THEN
649: --
650: hr_utility.set_location('BEN_94601', 80);
651: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
652: fnd_message.set_token('PROC',l_proc);
653: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
654: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
655: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
656: fnd_message.raise_error;

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

649: --
650: hr_utility.set_location('BEN_94601', 80);
651: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
652: fnd_message.set_token('PROC',l_proc);
653: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
654: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
655: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
656: fnd_message.raise_error;
657: --

Line 654: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

650: hr_utility.set_location('BEN_94601', 80);
651: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
652: fnd_message.set_token('PROC',l_proc);
653: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
654: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
655: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
656: fnd_message.raise_error;
657: --
658: END IF;

Line 655: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

651: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
652: fnd_message.set_token('PROC',l_proc);
653: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
654: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
655: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
656: fnd_message.raise_error;
657: --
658: END IF;
659: --

Line 656: fnd_message.raise_error;

652: fnd_message.set_token('PROC',l_proc);
653: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
654: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
655: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
656: fnd_message.raise_error;
657: --
658: END IF;
659: --
660: open c_enbcount(p_interim_elctbl_chc_id) ;

Line 669: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');

665: --
666: IF p_elig_per_elctbl_chc_id = p_interim_elctbl_chc_id THEN
667: --
668: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
669: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
670: fnd_message.set_token('PROC',l_proc);
671: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
672: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
673: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

666: IF p_elig_per_elctbl_chc_id = p_interim_elctbl_chc_id THEN
667: --
668: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
669: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
670: fnd_message.set_token('PROC',l_proc);
671: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
672: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
673: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
674: fnd_message.raise_error;

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

667: --
668: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
669: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
670: fnd_message.set_token('PROC',l_proc);
671: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
672: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
673: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
674: fnd_message.raise_error;
675: --

Line 672: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

668: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
669: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
670: fnd_message.set_token('PROC',l_proc);
671: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
672: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
673: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
674: fnd_message.raise_error;
675: --
676: END IF;

Line 673: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

669: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
670: fnd_message.set_token('PROC',l_proc);
671: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
672: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
673: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
674: fnd_message.raise_error;
675: --
676: END IF;
677: --

Line 674: fnd_message.raise_error;

670: fnd_message.set_token('PROC',l_proc);
671: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
672: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
673: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
674: fnd_message.raise_error;
675: --
676: END IF;
677: --
678: return;

Line 682: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');

678: return;
679: ELSIF l_enb_count = 0 AND p_interim_bnft_amt IS NOT NULL THEN
680: --
681: hr_utility.set_location('BEN_94603_WHY_ENB_ID', 80);
682: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
685: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
686: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

679: ELSIF l_enb_count = 0 AND p_interim_bnft_amt IS NOT NULL THEN
680: --
681: hr_utility.set_location('BEN_94603_WHY_ENB_ID', 80);
682: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
685: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
686: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
687: fnd_message.raise_error;

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

680: --
681: hr_utility.set_location('BEN_94603_WHY_ENB_ID', 80);
682: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
685: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
686: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
687: fnd_message.raise_error;
688: --

Line 685: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

681: hr_utility.set_location('BEN_94603_WHY_ENB_ID', 80);
682: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
685: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
686: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
687: fnd_message.raise_error;
688: --
689: ELSIF l_enb_count = 1 THEN

Line 686: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

682: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
685: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
686: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
687: fnd_message.raise_error;
688: --
689: ELSIF l_enb_count = 1 THEN
690: --

Line 687: fnd_message.raise_error;

683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
685: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
686: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
687: fnd_message.raise_error;
688: --
689: ELSIF l_enb_count = 1 THEN
690: --
691: open c_enb(p_interim_elctbl_chc_id);

Line 712: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');

708: --
709: IF nvl(l_interim_enb.val,-1) > nvl(l_enb.val,-1)
710: THEN
711: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
712: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
713: fnd_message.set_token('PROC',l_proc);
714: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
715: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
716: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

709: IF nvl(l_interim_enb.val,-1) > nvl(l_enb.val,-1)
710: THEN
711: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
712: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
713: fnd_message.set_token('PROC',l_proc);
714: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
715: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
716: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
717: fnd_message.raise_error;

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

710: THEN
711: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
712: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
713: fnd_message.set_token('PROC',l_proc);
714: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
715: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
716: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
717: fnd_message.raise_error;
718: END IF;

Line 715: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

711: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
712: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
713: fnd_message.set_token('PROC',l_proc);
714: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
715: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
716: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
717: fnd_message.raise_error;
718: END IF;
719: --

Line 716: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

712: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
713: fnd_message.set_token('PROC',l_proc);
714: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
715: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
716: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
717: fnd_message.raise_error;
718: END IF;
719: --
720: END IF;

Line 717: fnd_message.raise_error;

713: fnd_message.set_token('PROC',l_proc);
714: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
715: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
716: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
717: fnd_message.raise_error;
718: END IF;
719: --
720: END IF;
721: --

Line 727: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');

723: IF p_elig_per_elctbl_chc_id = p_interim_elctbl_chc_id AND
724: p_enrt_bnft_id = l_interim_enb.enrt_bnft_id THEN
725: --
726: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
727: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
728: fnd_message.set_token('PROC',l_proc);
729: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
730: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
731: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

724: p_enrt_bnft_id = l_interim_enb.enrt_bnft_id THEN
725: --
726: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
727: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
728: fnd_message.set_token('PROC',l_proc);
729: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
730: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
731: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
732: fnd_message.raise_error;

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

725: --
726: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
727: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
728: fnd_message.set_token('PROC',l_proc);
729: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
730: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
731: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
732: fnd_message.raise_error;
733: --

Line 730: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

726: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
727: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
728: fnd_message.set_token('PROC',l_proc);
729: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
730: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
731: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
732: fnd_message.raise_error;
733: --
734: END IF;

Line 731: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

727: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
728: fnd_message.set_token('PROC',l_proc);
729: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
730: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
731: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
732: fnd_message.raise_error;
733: --
734: END IF;
735: --

Line 732: fnd_message.raise_error;

728: fnd_message.set_token('PROC',l_proc);
729: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
730: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
731: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
732: fnd_message.raise_error;
733: --
734: END IF;
735: --
736: p_interim_enrt_bnft_id := l_interim_enb.enrt_bnft_id;

Line 743: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');

739: --
740: ELSIF l_enb_count > 1 AND p_interim_bnft_amt IS NULL THEN
741: --
742: hr_utility.set_location('BEN_94604_NO_ENB_ID', 80);
743: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
744: fnd_message.set_token('PROC',l_proc);
745: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
746: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
747: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

740: ELSIF l_enb_count > 1 AND p_interim_bnft_amt IS NULL THEN
741: --
742: hr_utility.set_location('BEN_94604_NO_ENB_ID', 80);
743: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
744: fnd_message.set_token('PROC',l_proc);
745: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
746: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
747: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
748: fnd_message.raise_error;

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

741: --
742: hr_utility.set_location('BEN_94604_NO_ENB_ID', 80);
743: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
744: fnd_message.set_token('PROC',l_proc);
745: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
746: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
747: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
748: fnd_message.raise_error;
749: --

Line 746: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

742: hr_utility.set_location('BEN_94604_NO_ENB_ID', 80);
743: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
744: fnd_message.set_token('PROC',l_proc);
745: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
746: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
747: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
748: fnd_message.raise_error;
749: --
750: ELSIF l_enb_count > 1 THEN

Line 747: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

743: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
744: fnd_message.set_token('PROC',l_proc);
745: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
746: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
747: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
748: fnd_message.raise_error;
749: --
750: ELSIF l_enb_count > 1 THEN
751: --

Line 748: fnd_message.raise_error;

744: fnd_message.set_token('PROC',l_proc);
745: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
746: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
747: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
748: fnd_message.raise_error;
749: --
750: ELSIF l_enb_count > 1 THEN
751: --
752: --Make sure the interim amount is less than or equal to the suspended coverage amount

Line 760: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');

756: --
757: IF p_interim_bnft_amt > l_pen.bnft_amt THEN
758: --
759: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
760: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
761: fnd_message.set_token('PROC',l_proc);
762: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
763: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
764: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

757: IF p_interim_bnft_amt > l_pen.bnft_amt THEN
758: --
759: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
760: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
761: fnd_message.set_token('PROC',l_proc);
762: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
763: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
764: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
765: fnd_message.raise_error;

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

758: --
759: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
760: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
761: fnd_message.set_token('PROC',l_proc);
762: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
763: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
764: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
765: fnd_message.raise_error;
766: --

Line 763: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

759: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
760: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
761: fnd_message.set_token('PROC',l_proc);
762: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
763: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
764: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
765: fnd_message.raise_error;
766: --
767: END IF;

Line 764: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

760: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
761: fnd_message.set_token('PROC',l_proc);
762: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
763: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
764: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
765: fnd_message.raise_error;
766: --
767: END IF;
768: --

Line 765: fnd_message.raise_error;

761: fnd_message.set_token('PROC',l_proc);
762: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
763: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
764: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
765: fnd_message.raise_error;
766: --
767: END IF;
768: --
769: --Make sure enb_id returned by the rule belongs to the same epe

Line 783: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');

779: IF c_enb_rng%NOTFOUND THEN
780: --
781: close c_enb_rng;
782: hr_utility.set_location('BEN_94606_INVALID_ENB_RNG', 80);
783: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
784: fnd_message.set_token('PROC',l_proc);
785: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
786: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
787: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

780: --
781: close c_enb_rng;
782: hr_utility.set_location('BEN_94606_INVALID_ENB_RNG', 80);
783: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
784: fnd_message.set_token('PROC',l_proc);
785: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
786: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
787: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
788: fnd_message.raise_error;

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

781: close c_enb_rng;
782: hr_utility.set_location('BEN_94606_INVALID_ENB_RNG', 80);
783: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
784: fnd_message.set_token('PROC',l_proc);
785: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
786: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
787: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
788: fnd_message.raise_error;
789: --

Line 786: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

782: hr_utility.set_location('BEN_94606_INVALID_ENB_RNG', 80);
783: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
784: fnd_message.set_token('PROC',l_proc);
785: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
786: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
787: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
788: fnd_message.raise_error;
789: --
790: END IF;

Line 787: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

783: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
784: fnd_message.set_token('PROC',l_proc);
785: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
786: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
787: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
788: fnd_message.raise_error;
789: --
790: END IF;
791: close c_enb_rng;

Line 788: fnd_message.raise_error;

784: fnd_message.set_token('PROC',l_proc);
785: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
786: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
787: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
788: fnd_message.raise_error;
789: --
790: END IF;
791: close c_enb_rng;
792: --

Line 797: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');

793: IF l_interim_enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id AND
794: l_interim_enb.enrt_bnft_id = p_enrt_bnft_id THEN
795: --
796: hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
797: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
798: fnd_message.set_token('PROC',l_proc);
799: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
800: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
801: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

794: l_interim_enb.enrt_bnft_id = p_enrt_bnft_id THEN
795: --
796: hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
797: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
798: fnd_message.set_token('PROC',l_proc);
799: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
800: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
801: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
802: fnd_message.raise_error;

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

795: --
796: hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
797: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
798: fnd_message.set_token('PROC',l_proc);
799: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
800: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
801: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
802: fnd_message.raise_error;
803: --

Line 800: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

796: hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
797: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
798: fnd_message.set_token('PROC',l_proc);
799: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
800: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
801: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
802: fnd_message.raise_error;
803: --
804: END IF;

Line 801: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

797: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
798: fnd_message.set_token('PROC',l_proc);
799: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
800: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
801: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
802: fnd_message.raise_error;
803: --
804: END IF;
805: --

Line 802: fnd_message.raise_error;

798: fnd_message.set_token('PROC',l_proc);
799: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
800: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
801: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
802: fnd_message.raise_error;
803: --
804: END IF;
805: --
806: --

Line 820: -- fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');

816: --
817: IF p_interim_bnft_amt = l_pen.bnft_amt THEN
818: --
819: -- hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
820: -- fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
821: -- message changed for Bug 5148514
822: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
823: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
824: fnd_message.set_token('PROC',l_proc);

Line 823: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');

819: -- hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
820: -- fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
821: -- message changed for Bug 5148514
822: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
823: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
824: fnd_message.set_token('PROC',l_proc);
825: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
826: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
827: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

820: -- fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
821: -- message changed for Bug 5148514
822: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
823: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
824: fnd_message.set_token('PROC',l_proc);
825: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
826: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
827: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
828: fnd_message.raise_error;

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

821: -- message changed for Bug 5148514
822: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
823: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
824: fnd_message.set_token('PROC',l_proc);
825: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
826: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
827: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
828: fnd_message.raise_error;
829: --

Line 826: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));

822: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
823: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
824: fnd_message.set_token('PROC',l_proc);
825: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
826: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
827: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
828: fnd_message.raise_error;
829: --
830: END IF;

Line 827: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

823: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
824: fnd_message.set_token('PROC',l_proc);
825: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
826: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
827: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
828: fnd_message.raise_error;
829: --
830: END IF;
831: --

Line 828: fnd_message.raise_error;

824: fnd_message.set_token('PROC',l_proc);
825: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
826: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
827: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
828: fnd_message.raise_error;
829: --
830: END IF;
831: --
832: END IF;

Line 1937: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');

1933: fetch c_paf into l_assignment_id,l_organization_id;
1934: if (c_paf%notfound) then
1935: close c_paf;
1936: hr_utility.set_location('BEN_91698_NO_ASSIGNMENT_FND', 80);
1937: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
1938: fnd_message.set_token('ID' , to_char(p_person_id));
1939: fnd_message.raise_error;
1940: end if;
1941: close c_paf;

Line 1938: fnd_message.set_token('ID' , to_char(p_person_id));

1934: if (c_paf%notfound) then
1935: close c_paf;
1936: hr_utility.set_location('BEN_91698_NO_ASSIGNMENT_FND', 80);
1937: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
1938: fnd_message.set_token('ID' , to_char(p_person_id));
1939: fnd_message.raise_error;
1940: end if;
1941: close c_paf;
1942: hr_utility.set_location(l_proc, 90);

Line 1939: fnd_message.raise_error;

1935: close c_paf;
1936: hr_utility.set_location('BEN_91698_NO_ASSIGNMENT_FND', 80);
1937: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
1938: fnd_message.set_token('ID' , to_char(p_person_id));
1939: fnd_message.raise_error;
1940: end if;
1941: close c_paf;
1942: hr_utility.set_location(l_proc, 90);
1943:

Line 2485: fnd_message.raise_error;

2481: rpt_error (p_proc => l_proc, p_last_action => l_last_place);
2482: -- hr_utility.set_location('ERROR: '||sqlerrm,1);
2483: -- for nocopy changes
2484: p_interim_elctbl_chc_id := l_interim_elctbl_chc_id;
2485: fnd_message.raise_error;
2486: End Determine_interim;
2487: --
2488: -- ==========================================================================
2489: -- << Process_interim >>

Line 2584: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');

2580: If c_epe%notfound then
2581: close c_epe;
2582: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND id:'||
2583: to_char(p_elig_per_elctbl_chc_id), 10);
2584: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2585: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
2586: fnd_message.set_token('PROC', '1:'||l_proc);
2587: fnd_message.raise_error;
2588: End if;

Line 2585: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));

2581: close c_epe;
2582: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND id:'||
2583: to_char(p_elig_per_elctbl_chc_id), 10);
2584: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2585: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
2586: fnd_message.set_token('PROC', '1:'||l_proc);
2587: fnd_message.raise_error;
2588: End if;
2589: close c_epe;

Line 2586: fnd_message.set_token('PROC', '1:'||l_proc);

2582: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND id:'||
2583: to_char(p_elig_per_elctbl_chc_id), 10);
2584: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2585: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
2586: fnd_message.set_token('PROC', '1:'||l_proc);
2587: fnd_message.raise_error;
2588: End if;
2589: close c_epe;
2590: --

Line 2587: fnd_message.raise_error;

2583: to_char(p_elig_per_elctbl_chc_id), 10);
2584: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2585: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
2586: fnd_message.set_token('PROC', '1:'||l_proc);
2587: fnd_message.raise_error;
2588: End if;
2589: close c_epe;
2590: --
2591: -- Get Benefit ID and Benefit amount

Line 2705: fnd_message.raise_error;

2701: rpt_error (p_proc => l_proc, p_last_action => l_last_place);
2702: -- for nocopy changes
2703: p_prtt_enrt_rslt_id := l_prtt_enrt_rslt_id;
2704: g_interim_flag := 'N'; -- bug 5653168
2705: fnd_message.raise_error;
2706: End process_interim;
2707: --
2708: -- ==========================================================================
2709: -- << Update_sspndd_flag >>

Line 2853: fnd_message.raise_error;

2849: hr_utility.set_location('ERROR '||l_proc, 97);
2850: Rpt_error(p_proc => l_proc, p_last_action => l_last_place);
2851: -- for nocopy changes
2852: p_object_version_number := l_object_version_number ;
2853: fnd_message.raise_error;
2854: End update_sspndd_flag;
2855: --
2856: -- =======================================================================
2857: -- << Suspend_enrollment >>

Line 3146: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');

3142: Fetch Csr_prtt_enrt_rslt Into l_pen;
3143: If Csr_prtt_enrt_rslt%NOTFOUND Then
3144: Close Csr_prtt_enrt_rslt;
3145: hr_utility.set_location('BEN_91493_PEN_NOT_FOUND', 55);
3146: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');
3147: fnd_message.raise_error;
3148: End If;
3149: Close Csr_prtt_enrt_rslt;
3150: --bug#4172569 - if the comp object is already suspended then return

Line 3147: fnd_message.raise_error;

3143: If Csr_prtt_enrt_rslt%NOTFOUND Then
3144: Close Csr_prtt_enrt_rslt;
3145: hr_utility.set_location('BEN_91493_PEN_NOT_FOUND', 55);
3146: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');
3147: fnd_message.raise_error;
3148: End If;
3149: Close Csr_prtt_enrt_rslt;
3150: --bug#4172569 - if the comp object is already suspended then return
3151: --if more than one required action item then this procedure is called more

Line 3486: fnd_message.raise_error;

3482: hr_utility.set_location('ERROR '||l_proc, 96);
3483: rpt_error(p_proc => l_proc, p_last_action => l_last_place);
3484: -- for nocopy changes
3485: p_object_version_number := l_object_version_number ;
3486: fnd_message.raise_error;
3487: End suspend_enrollment;
3488: --
3489: --
3490: -- ==========================================================================+

Line 3871: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');

3867: Fetch Csr_prtt_enrt_rslt Into l_pen;
3868: If Csr_prtt_enrt_rslt%NOTFOUND Then
3869: Close Csr_prtt_enrt_rslt;
3870: hr_utility.set_location('BEN_91493_PEN_NOT_FOUND ID:'|| to_char(p_prtt_enrt_rslt_id), 65);
3871: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');
3872: fnd_message.raise_error;
3873: End If;
3874: Close Csr_prtt_enrt_rslt;
3875: --

Line 3872: fnd_message.raise_error;

3868: If Csr_prtt_enrt_rslt%NOTFOUND Then
3869: Close Csr_prtt_enrt_rslt;
3870: hr_utility.set_location('BEN_91493_PEN_NOT_FOUND ID:'|| to_char(p_prtt_enrt_rslt_id), 65);
3871: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');
3872: fnd_message.raise_error;
3873: End If;
3874: Close Csr_prtt_enrt_rslt;
3875: --
3876: if p_per_in_ler_id is not null then

Line 4006: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');

4002: if c_choice_info%notfound then
4003: --
4004: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4005: to_char(p_prtt_enrt_rslt_id), 75);
4006: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4007: fnd_message.set_token('ID', 'NA');
4008: fnd_message.set_token('PROC', '2:'||l_proc);
4009: fnd_message.raise_error;
4010: end if;

Line 4007: fnd_message.set_token('ID', 'NA');

4003: --
4004: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4005: to_char(p_prtt_enrt_rslt_id), 75);
4006: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4007: fnd_message.set_token('ID', 'NA');
4008: fnd_message.set_token('PROC', '2:'||l_proc);
4009: fnd_message.raise_error;
4010: end if;
4011: close c_choice_info;

Line 4008: fnd_message.set_token('PROC', '2:'||l_proc);

4004: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4005: to_char(p_prtt_enrt_rslt_id), 75);
4006: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4007: fnd_message.set_token('ID', 'NA');
4008: fnd_message.set_token('PROC', '2:'||l_proc);
4009: fnd_message.raise_error;
4010: end if;
4011: close c_choice_info;
4012: --

Line 4009: fnd_message.raise_error;

4005: to_char(p_prtt_enrt_rslt_id), 75);
4006: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4007: fnd_message.set_token('ID', 'NA');
4008: fnd_message.set_token('PROC', '2:'||l_proc);
4009: fnd_message.raise_error;
4010: end if;
4011: close c_choice_info;
4012: --
4013: If l_unsspnd_enrt_cd = 'ACD' then

Line 4186: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');

4182: -- error
4183: --
4184: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4185: to_char(p_prtt_enrt_rslt_id), 75);
4186: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4187: fnd_message.set_token('ID', 'NA');
4188: fnd_message.set_token('PROC', '2:'||l_proc);
4189: fnd_message.raise_error;
4190: end if;

Line 4187: fnd_message.set_token('ID', 'NA');

4183: --
4184: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4185: to_char(p_prtt_enrt_rslt_id), 75);
4186: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4187: fnd_message.set_token('ID', 'NA');
4188: fnd_message.set_token('PROC', '2:'||l_proc);
4189: fnd_message.raise_error;
4190: end if;
4191: close c_choice_info;

Line 4188: fnd_message.set_token('PROC', '2:'||l_proc);

4184: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4185: to_char(p_prtt_enrt_rslt_id), 75);
4186: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4187: fnd_message.set_token('ID', 'NA');
4188: fnd_message.set_token('PROC', '2:'||l_proc);
4189: fnd_message.raise_error;
4190: end if;
4191: close c_choice_info;
4192: hr_utility.set_location('past c_choice_info', 10);

Line 4189: fnd_message.raise_error;

4185: to_char(p_prtt_enrt_rslt_id), 75);
4186: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4187: fnd_message.set_token('ID', 'NA');
4188: fnd_message.set_token('PROC', '2:'||l_proc);
4189: fnd_message.raise_error;
4190: end if;
4191: close c_choice_info;
4192: hr_utility.set_location('past c_choice_info', 10);
4193: --

Line 4482: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');

4478: l_epe_object_version_number;
4479: if c_choice_info%notfound then
4480: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4481: to_char(p_prtt_enrt_rslt_id), 75);
4482: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4483: fnd_message.set_token('ID', 'NA');
4484: fnd_message.set_token('PROC', '2:'||l_proc);
4485: fnd_message.raise_error;
4486: end if;

Line 4483: fnd_message.set_token('ID', 'NA');

4479: if c_choice_info%notfound then
4480: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4481: to_char(p_prtt_enrt_rslt_id), 75);
4482: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4483: fnd_message.set_token('ID', 'NA');
4484: fnd_message.set_token('PROC', '2:'||l_proc);
4485: fnd_message.raise_error;
4486: end if;
4487: close c_choice_info;

Line 4484: fnd_message.set_token('PROC', '2:'||l_proc);

4480: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4481: to_char(p_prtt_enrt_rslt_id), 75);
4482: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4483: fnd_message.set_token('ID', 'NA');
4484: fnd_message.set_token('PROC', '2:'||l_proc);
4485: fnd_message.raise_error;
4486: end if;
4487: close c_choice_info;
4488: --

Line 4485: fnd_message.raise_error;

4481: to_char(p_prtt_enrt_rslt_id), 75);
4482: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4483: fnd_message.set_token('ID', 'NA');
4484: fnd_message.set_token('PROC', '2:'||l_proc);
4485: fnd_message.raise_error;
4486: end if;
4487: close c_choice_info;
4488: --
4489: hr_utility.set_location('got the latest epe info', 10);

Line 4692: fnd_message.raise_error;

4688: hr_utility.set_location('ERROR '||l_proc, 95);
4689: rpt_error(l_proc, l_last_place);
4690: -- for nocopy changes
4691: p_object_version_number := l_object_version_number ;
4692: fnd_message.raise_error;
4693: End unsuspend_enrollment;
4694: --
4695: end ben_sspndd_enrollment;