APPS.BEN_SSPNDD_ENROLLMENT dependencies on FND_MESSAGE

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

496: --Start Interim Rule Enhancement
497: if l_return is NULL then
498: --Invalid Rule
499: hr_utility.set_location('BEN_94600_NULL_RETURNED',80);
500: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');
501: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
502: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));
503: fnd_message.raise_error;
504: --

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

497: if l_return is NULL then
498: --Invalid Rule
499: hr_utility.set_location('BEN_94600_NULL_RETURNED',80);
500: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');
501: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
502: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));
503: fnd_message.raise_error;
504: --
505: elsif instr('0123456789', substr(l_return,1,1) ) > 0 THEN

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

498: --Invalid Rule
499: hr_utility.set_location('BEN_94600_NULL_RETURNED',80);
500: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');
501: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
502: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));
503: fnd_message.raise_error;
504: --
505: elsif instr('0123456789', substr(l_return,1,1) ) > 0 THEN
506: --

Line 503: fnd_message.raise_error;

499: hr_utility.set_location('BEN_94600_NULL_RETURNED',80);
500: fnd_message.set_name('BEN','BEN_94600_NULL_RETURNED');
501: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
502: fnd_message.set_token('EPE_ID',to_char(p_elig_per_elctbl_chc_id));
503: fnd_message.raise_error;
504: --
505: elsif instr('0123456789', substr(l_return,1,1) ) > 0 THEN
506: --
507: l_return := NULL;

Line 541: fnd_message.raise_error;

537: Exception
538: When others then
539: hr_utility.set_location ('Fail in '||l_proc|| ' step in '||
540: to_char(l_step),999);
541: fnd_message.raise_error;
542: End get_dflt_to_asn_pndg_ctfn_cd;
543: --
544: --
545: -- ==========================================================================

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

669: fetch c_epe into l_interim_epe ;
670: /* Bug 5225780 */
671: if c_epe%NOTFOUND or l_interim_epe.per_in_ler_id <> l_susp_epe.per_in_ler_id then
672: hr_utility.set_location('BEN_94628', 80);
673: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
674: fnd_message.set_token('PROC',l_proc);
675: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
676: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
677: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

670: /* Bug 5225780 */
671: if c_epe%NOTFOUND or l_interim_epe.per_in_ler_id <> l_susp_epe.per_in_ler_id then
672: hr_utility.set_location('BEN_94628', 80);
673: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
674: fnd_message.set_token('PROC',l_proc);
675: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
676: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
677: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
678: fnd_message.raise_error;

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

671: if c_epe%NOTFOUND or l_interim_epe.per_in_ler_id <> l_susp_epe.per_in_ler_id then
672: hr_utility.set_location('BEN_94628', 80);
673: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
674: fnd_message.set_token('PROC',l_proc);
675: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
676: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
677: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
678: fnd_message.raise_error;
679: end if;

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

672: hr_utility.set_location('BEN_94628', 80);
673: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
674: fnd_message.set_token('PROC',l_proc);
675: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
676: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
677: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
678: fnd_message.raise_error;
679: end if;
680: /* End Bug 5225780 */

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

673: fnd_message.set_name('BEN','BEN_94628_EPE_NOTIN_PIL');
674: fnd_message.set_token('PROC',l_proc);
675: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
676: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
677: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
678: fnd_message.raise_error;
679: end if;
680: /* End Bug 5225780 */
681: close c_epe;

Line 678: fnd_message.raise_error;

674: fnd_message.set_token('PROC',l_proc);
675: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
676: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
677: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
678: fnd_message.raise_error;
679: end if;
680: /* End Bug 5225780 */
681: close c_epe;
682: --

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

684: --
685: IF l_interim_epe.ptip_id <> l_susp_epe.ptip_id THEN
686: --
687: hr_utility.set_location('BEN_94601', 80);
688: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
689: fnd_message.set_token('PROC',l_proc);
690: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
691: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
692: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

685: IF l_interim_epe.ptip_id <> l_susp_epe.ptip_id THEN
686: --
687: hr_utility.set_location('BEN_94601', 80);
688: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
689: fnd_message.set_token('PROC',l_proc);
690: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
691: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
692: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
693: fnd_message.raise_error;

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

686: --
687: hr_utility.set_location('BEN_94601', 80);
688: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
689: fnd_message.set_token('PROC',l_proc);
690: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
691: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
692: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
693: fnd_message.raise_error;
694: --

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

687: hr_utility.set_location('BEN_94601', 80);
688: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
689: fnd_message.set_token('PROC',l_proc);
690: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
691: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
692: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
693: fnd_message.raise_error;
694: --
695: END IF;

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

688: fnd_message.set_name('BEN','BEN_94601_EPE_NOTIN_PTIP');
689: fnd_message.set_token('PROC',l_proc);
690: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
691: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
692: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
693: fnd_message.raise_error;
694: --
695: END IF;
696: --

Line 693: fnd_message.raise_error;

689: fnd_message.set_token('PROC',l_proc);
690: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
691: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
692: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
693: fnd_message.raise_error;
694: --
695: END IF;
696: --
697: open c_enbcount(p_interim_elctbl_chc_id) ;

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

702: --
703: IF p_elig_per_elctbl_chc_id = p_interim_elctbl_chc_id THEN
704: --
705: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
706: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
707: fnd_message.set_token('PROC',l_proc);
708: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
709: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
710: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

703: IF p_elig_per_elctbl_chc_id = p_interim_elctbl_chc_id THEN
704: --
705: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
706: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
707: fnd_message.set_token('PROC',l_proc);
708: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
709: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
710: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
711: fnd_message.raise_error;

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

704: --
705: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
706: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
707: fnd_message.set_token('PROC',l_proc);
708: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
709: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
710: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
711: fnd_message.raise_error;
712: --

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

705: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
706: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
707: fnd_message.set_token('PROC',l_proc);
708: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
709: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
710: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
711: fnd_message.raise_error;
712: --
713: END IF;

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

706: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
707: fnd_message.set_token('PROC',l_proc);
708: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
709: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
710: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
711: fnd_message.raise_error;
712: --
713: END IF;
714: --

Line 711: fnd_message.raise_error;

707: fnd_message.set_token('PROC',l_proc);
708: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
709: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
710: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
711: fnd_message.raise_error;
712: --
713: END IF;
714: --
715: return;

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

715: return;
716: ELSIF l_enb_count = 0 AND p_interim_bnft_amt IS NOT NULL THEN
717: --
718: hr_utility.set_location('BEN_94603_WHY_ENB_ID', 80);
719: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
720: fnd_message.set_token('PROC',l_proc);
721: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
722: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
723: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

716: ELSIF l_enb_count = 0 AND p_interim_bnft_amt IS NOT NULL THEN
717: --
718: hr_utility.set_location('BEN_94603_WHY_ENB_ID', 80);
719: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
720: fnd_message.set_token('PROC',l_proc);
721: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
722: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
723: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
724: fnd_message.raise_error;

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

717: --
718: hr_utility.set_location('BEN_94603_WHY_ENB_ID', 80);
719: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
720: fnd_message.set_token('PROC',l_proc);
721: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
722: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
723: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
724: fnd_message.raise_error;
725: --

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

718: hr_utility.set_location('BEN_94603_WHY_ENB_ID', 80);
719: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
720: fnd_message.set_token('PROC',l_proc);
721: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
722: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
723: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
724: fnd_message.raise_error;
725: --
726: ELSIF l_enb_count = 1 THEN

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

719: fnd_message.set_name('BEN','BEN_94603_WHY_ENB_ID');
720: fnd_message.set_token('PROC',l_proc);
721: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
722: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
723: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
724: fnd_message.raise_error;
725: --
726: ELSIF l_enb_count = 1 THEN
727: --

Line 724: fnd_message.raise_error;

720: fnd_message.set_token('PROC',l_proc);
721: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
722: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
723: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
724: fnd_message.raise_error;
725: --
726: ELSIF l_enb_count = 1 THEN
727: --
728: open c_enb(p_interim_elctbl_chc_id);

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

753: hr_utility.set_location('p_interim_bnft_amt '||p_interim_bnft_amt, 80);
754: IF nvl(nvl(p_interim_bnft_amt,l_interim_enb.val),-1) > nvl(l_pen.bnft_amt,-1)
755: THEN
756: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
757: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
758: fnd_message.set_token('PROC',l_proc);
759: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
760: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
761: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

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

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

755: THEN
756: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
757: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
758: fnd_message.set_token('PROC',l_proc);
759: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
760: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
761: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
762: fnd_message.raise_error;
763: END IF;

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

756: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
757: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
758: fnd_message.set_token('PROC',l_proc);
759: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
760: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
761: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
762: fnd_message.raise_error;
763: END IF;
764: elsIF nvl(nvl(p_interim_bnft_amt,l_interim_enb.val),-1) > nvl(l_enb.val,-1)

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

757: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
758: fnd_message.set_token('PROC',l_proc);
759: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
760: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
761: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
762: fnd_message.raise_error;
763: END IF;
764: elsIF nvl(nvl(p_interim_bnft_amt,l_interim_enb.val),-1) > nvl(l_enb.val,-1)
765: THEN

Line 762: fnd_message.raise_error;

758: fnd_message.set_token('PROC',l_proc);
759: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
760: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
761: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
762: fnd_message.raise_error;
763: END IF;
764: elsIF nvl(nvl(p_interim_bnft_amt,l_interim_enb.val),-1) > nvl(l_enb.val,-1)
765: THEN
766: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);

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

763: END IF;
764: elsIF nvl(nvl(p_interim_bnft_amt,l_interim_enb.val),-1) > nvl(l_enb.val,-1)
765: THEN
766: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
767: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
768: fnd_message.set_token('PROC',l_proc);
769: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
770: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
771: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

764: elsIF nvl(nvl(p_interim_bnft_amt,l_interim_enb.val),-1) > nvl(l_enb.val,-1)
765: THEN
766: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
767: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
768: fnd_message.set_token('PROC',l_proc);
769: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
770: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
771: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
772: fnd_message.raise_error;

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

765: THEN
766: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
767: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
768: fnd_message.set_token('PROC',l_proc);
769: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
770: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
771: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
772: fnd_message.raise_error;
773: END IF;

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

766: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
767: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
768: fnd_message.set_token('PROC',l_proc);
769: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
770: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
771: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
772: fnd_message.raise_error;
773: END IF;
774: --

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

767: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
768: fnd_message.set_token('PROC',l_proc);
769: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
770: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
771: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
772: fnd_message.raise_error;
773: END IF;
774: --
775: END IF;

Line 772: fnd_message.raise_error;

768: fnd_message.set_token('PROC',l_proc);
769: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
770: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
771: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
772: fnd_message.raise_error;
773: END IF;
774: --
775: END IF;
776: --

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

778: IF p_elig_per_elctbl_chc_id = p_interim_elctbl_chc_id AND
779: p_enrt_bnft_id = l_interim_enb.enrt_bnft_id THEN
780: --
781: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
782: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
783: fnd_message.set_token('PROC',l_proc);
784: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
785: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
786: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

779: p_enrt_bnft_id = l_interim_enb.enrt_bnft_id THEN
780: --
781: hr_utility.set_location('BEN_94602_SM_AS_SSPND', 80);
782: fnd_message.set_name('BEN','BEN_94602_SM_AS_SSPND');
783: fnd_message.set_token('PROC',l_proc);
784: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
785: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
786: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
787: fnd_message.raise_error;

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

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

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

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

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

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

Line 787: fnd_message.raise_error;

783: fnd_message.set_token('PROC',l_proc);
784: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
785: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
786: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
787: fnd_message.raise_error;
788: --
789: END IF;
790: --
791: p_interim_enrt_bnft_id := l_interim_enb.enrt_bnft_id;

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

794: --
795: ELSIF l_enb_count > 1 AND p_interim_bnft_amt IS NULL THEN
796: --
797: hr_utility.set_location('BEN_94604_NO_ENB_ID', 80);
798: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
799: fnd_message.set_token('PROC',l_proc);
800: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
801: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
802: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

795: ELSIF l_enb_count > 1 AND p_interim_bnft_amt IS NULL THEN
796: --
797: hr_utility.set_location('BEN_94604_NO_ENB_ID', 80);
798: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
799: fnd_message.set_token('PROC',l_proc);
800: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
801: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
802: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
803: fnd_message.raise_error;

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

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

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

797: hr_utility.set_location('BEN_94604_NO_ENB_ID', 80);
798: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
799: fnd_message.set_token('PROC',l_proc);
800: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
801: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
802: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
803: fnd_message.raise_error;
804: --
805: ELSIF l_enb_count > 1 THEN

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

798: fnd_message.set_name('BEN','BEN_94604_NO_ENB_ID');
799: fnd_message.set_token('PROC',l_proc);
800: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
801: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
802: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
803: fnd_message.raise_error;
804: --
805: ELSIF l_enb_count > 1 THEN
806: --

Line 803: fnd_message.raise_error;

799: fnd_message.set_token('PROC',l_proc);
800: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
801: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
802: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
803: fnd_message.raise_error;
804: --
805: ELSIF l_enb_count > 1 THEN
806: --
807: --Make sure the interim amount is less than or equal to the suspended coverage amount

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

811: --
812: IF p_interim_bnft_amt > l_pen.bnft_amt THEN
813: --
814: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
815: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
816: fnd_message.set_token('PROC',l_proc);
817: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
818: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
819: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

812: IF p_interim_bnft_amt > l_pen.bnft_amt THEN
813: --
814: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
815: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
816: fnd_message.set_token('PROC',l_proc);
817: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
818: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
819: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
820: fnd_message.raise_error;

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

813: --
814: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
815: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
816: fnd_message.set_token('PROC',l_proc);
817: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
818: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
819: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
820: fnd_message.raise_error;
821: --

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

814: hr_utility.set_location('BEN_94607_MORE_THAN_SSPND', 80);
815: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
816: fnd_message.set_token('PROC',l_proc);
817: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
818: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
819: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
820: fnd_message.raise_error;
821: --
822: END IF;

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

815: fnd_message.set_name('BEN','BEN_94607_MORE_THAN_SSPND');
816: fnd_message.set_token('PROC',l_proc);
817: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
818: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
819: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
820: fnd_message.raise_error;
821: --
822: END IF;
823: --

Line 820: fnd_message.raise_error;

816: fnd_message.set_token('PROC',l_proc);
817: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
818: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
819: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
820: fnd_message.raise_error;
821: --
822: END IF;
823: --
824: --Make sure enb_id returned by the rule belongs to the same epe

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

834: IF c_enb_rng%NOTFOUND THEN
835: --
836: close c_enb_rng;
837: hr_utility.set_location('BEN_94606_INVALID_ENB_RNG', 80);
838: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
839: fnd_message.set_token('PROC',l_proc);
840: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
841: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
842: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

835: --
836: close c_enb_rng;
837: hr_utility.set_location('BEN_94606_INVALID_ENB_RNG', 80);
838: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
839: fnd_message.set_token('PROC',l_proc);
840: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
841: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
842: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
843: fnd_message.raise_error;

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

836: close c_enb_rng;
837: hr_utility.set_location('BEN_94606_INVALID_ENB_RNG', 80);
838: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
839: fnd_message.set_token('PROC',l_proc);
840: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
841: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
842: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
843: fnd_message.raise_error;
844: --

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

837: hr_utility.set_location('BEN_94606_INVALID_ENB_RNG', 80);
838: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
839: fnd_message.set_token('PROC',l_proc);
840: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
841: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
842: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
843: fnd_message.raise_error;
844: --
845: END IF;

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

838: fnd_message.set_name('BEN','BEN_94606_INVALID_ENB_RNG');
839: fnd_message.set_token('PROC',l_proc);
840: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
841: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
842: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
843: fnd_message.raise_error;
844: --
845: END IF;
846: close c_enb_rng;

Line 843: fnd_message.raise_error;

839: fnd_message.set_token('PROC',l_proc);
840: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
841: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
842: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
843: fnd_message.raise_error;
844: --
845: END IF;
846: close c_enb_rng;
847: --

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

848: IF l_interim_enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id AND
849: l_interim_enb.enrt_bnft_id = p_enrt_bnft_id THEN
850: --
851: hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
852: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
853: fnd_message.set_token('PROC',l_proc);
854: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
855: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
856: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

849: l_interim_enb.enrt_bnft_id = p_enrt_bnft_id THEN
850: --
851: hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
852: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
853: fnd_message.set_token('PROC',l_proc);
854: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
855: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
856: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
857: fnd_message.raise_error;

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

850: --
851: hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
852: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
853: fnd_message.set_token('PROC',l_proc);
854: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
855: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
856: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
857: fnd_message.raise_error;
858: --

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

851: hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
852: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
853: fnd_message.set_token('PROC',l_proc);
854: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
855: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
856: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
857: fnd_message.raise_error;
858: --
859: END IF;

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

852: fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
853: fnd_message.set_token('PROC',l_proc);
854: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
855: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
856: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
857: fnd_message.raise_error;
858: --
859: END IF;
860: --

Line 857: fnd_message.raise_error;

853: fnd_message.set_token('PROC',l_proc);
854: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
855: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
856: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
857: fnd_message.raise_error;
858: --
859: END IF;
860: --
861: --

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

871: --
872: IF p_interim_bnft_amt = l_pen.bnft_amt THEN
873: --
874: -- hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
875: -- fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
876: -- message changed for Bug 5148514
877: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
878: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
879: fnd_message.set_token('PROC',l_proc);

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

874: -- hr_utility.set_location('BEN_99602_SM_AS_SSPND', 80);
875: -- fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
876: -- message changed for Bug 5148514
877: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
878: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
879: fnd_message.set_token('PROC',l_proc);
880: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
881: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
882: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));

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

875: -- fnd_message.set_name('BEN','BEN_99602_SM_AS_SSPND');
876: -- message changed for Bug 5148514
877: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
878: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
879: fnd_message.set_token('PROC',l_proc);
880: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
881: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
882: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
883: fnd_message.raise_error;

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

876: -- message changed for Bug 5148514
877: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
878: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
879: fnd_message.set_token('PROC',l_proc);
880: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
881: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
882: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
883: fnd_message.raise_error;
884: --

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

877: hr_utility.set_location('BEN_94624_AMT_SM_SSPND', 80);
878: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
879: fnd_message.set_token('PROC',l_proc);
880: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
881: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
882: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
883: fnd_message.raise_error;
884: --
885: END IF;

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

878: fnd_message.set_name('BEN','BEN_94624_AMT_SM_SSPND');
879: fnd_message.set_token('PROC',l_proc);
880: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
881: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
882: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
883: fnd_message.raise_error;
884: --
885: END IF;
886: --

Line 883: fnd_message.raise_error;

879: fnd_message.set_token('PROC',l_proc);
880: fnd_message.set_token('PERSON_ID' , to_char(p_person_id));
881: fnd_message.set_token('INT_EPE_ID',to_char(p_interim_elctbl_chc_id));
882: fnd_message.set_token('SSP_EPE_ID',to_char(p_elig_per_elctbl_chc_id));
883: fnd_message.raise_error;
884: --
885: END IF;
886: --
887: END IF;

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

2063: fetch c_paf into l_assignment_id,l_organization_id;
2064: if (c_paf%notfound) then
2065: close c_paf;
2066: hr_utility.set_location('BEN_91698_NO_ASSIGNMENT_FND', 80);
2067: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2068: fnd_message.set_token('ID' , to_char(p_person_id));
2069: fnd_message.raise_error;
2070: end if;
2071: close c_paf;

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

2064: if (c_paf%notfound) then
2065: close c_paf;
2066: hr_utility.set_location('BEN_91698_NO_ASSIGNMENT_FND', 80);
2067: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2068: fnd_message.set_token('ID' , to_char(p_person_id));
2069: fnd_message.raise_error;
2070: end if;
2071: close c_paf;
2072: hr_utility.set_location(l_proc, 90);

Line 2069: fnd_message.raise_error;

2065: close c_paf;
2066: hr_utility.set_location('BEN_91698_NO_ASSIGNMENT_FND', 80);
2067: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2068: fnd_message.set_token('ID' , to_char(p_person_id));
2069: fnd_message.raise_error;
2070: end if;
2071: close c_paf;
2072: hr_utility.set_location(l_proc, 90);
2073:

Line 2631: fnd_message.raise_error;

2627: rpt_error (p_proc => l_proc, p_last_action => l_last_place);
2628: -- hr_utility.set_location('ERROR: '||sqlerrm,1);
2629: -- for nocopy changes
2630: p_interim_elctbl_chc_id := l_interim_elctbl_chc_id;
2631: fnd_message.raise_error;
2632: End Determine_interim;
2633: --
2634: -- ==========================================================================
2635: -- << Process_interim >>

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

2726: If c_epe%notfound then
2727: close c_epe;
2728: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND id:'||
2729: to_char(p_elig_per_elctbl_chc_id), 10);
2730: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2731: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
2732: fnd_message.set_token('PROC', '1:'||l_proc);
2733: fnd_message.raise_error;
2734: End if;

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

2727: close c_epe;
2728: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND id:'||
2729: to_char(p_elig_per_elctbl_chc_id), 10);
2730: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2731: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
2732: fnd_message.set_token('PROC', '1:'||l_proc);
2733: fnd_message.raise_error;
2734: End if;
2735: close c_epe;

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

2728: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND id:'||
2729: to_char(p_elig_per_elctbl_chc_id), 10);
2730: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2731: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
2732: fnd_message.set_token('PROC', '1:'||l_proc);
2733: fnd_message.raise_error;
2734: End if;
2735: close c_epe;
2736: --

Line 2733: fnd_message.raise_error;

2729: to_char(p_elig_per_elctbl_chc_id), 10);
2730: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2731: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
2732: fnd_message.set_token('PROC', '1:'||l_proc);
2733: fnd_message.raise_error;
2734: End if;
2735: close c_epe;
2736: --
2737: -- Get Benefit ID and Benefit amount

Line 2851: fnd_message.raise_error;

2847: rpt_error (p_proc => l_proc, p_last_action => l_last_place);
2848: -- for nocopy changes
2849: p_prtt_enrt_rslt_id := l_prtt_enrt_rslt_id;
2850: g_interim_flag := 'N'; -- bug 5653168
2851: fnd_message.raise_error;
2852: End process_interim;
2853: --
2854: -- ==========================================================================
2855: -- << Update_sspndd_flag >>

Line 2999: fnd_message.raise_error;

2995: hr_utility.set_location('ERROR '||l_proc, 97);
2996: Rpt_error(p_proc => l_proc, p_last_action => l_last_place);
2997: -- for nocopy changes
2998: p_object_version_number := l_object_version_number ;
2999: fnd_message.raise_error;
3000: End update_sspndd_flag;
3001: --
3002: -- =======================================================================
3003: -- << Suspend_enrollment >>

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

3288: Fetch Csr_prtt_enrt_rslt Into l_pen;
3289: If Csr_prtt_enrt_rslt%NOTFOUND Then
3290: Close Csr_prtt_enrt_rslt;
3291: hr_utility.set_location('BEN_91493_PEN_NOT_FOUND', 55);
3292: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');
3293: fnd_message.raise_error;
3294: End If;
3295: Close Csr_prtt_enrt_rslt;
3296: --bug#4172569 - if the comp object is already suspended then return

Line 3293: fnd_message.raise_error;

3289: If Csr_prtt_enrt_rslt%NOTFOUND Then
3290: Close Csr_prtt_enrt_rslt;
3291: hr_utility.set_location('BEN_91493_PEN_NOT_FOUND', 55);
3292: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');
3293: fnd_message.raise_error;
3294: End If;
3295: Close Csr_prtt_enrt_rslt;
3296: --bug#4172569 - if the comp object is already suspended then return
3297: --if more than one required action item then this procedure is called more

Line 3632: fnd_message.raise_error;

3628: hr_utility.set_location('ERROR '||l_proc, 96);
3629: rpt_error(p_proc => l_proc, p_last_action => l_last_place);
3630: -- for nocopy changes
3631: p_object_version_number := l_object_version_number ;
3632: fnd_message.raise_error;
3633: End suspend_enrollment;
3634: --
3635: --
3636: -- ==========================================================================+

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

4036: Fetch Csr_prtt_enrt_rslt Into l_pen;
4037: If Csr_prtt_enrt_rslt%NOTFOUND Then
4038: Close Csr_prtt_enrt_rslt;
4039: hr_utility.set_location('BEN_91493_PEN_NOT_FOUND ID:'|| to_char(p_prtt_enrt_rslt_id), 65);
4040: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');
4041: fnd_message.raise_error;
4042: End If;
4043: Close Csr_prtt_enrt_rslt;
4044: --

Line 4041: fnd_message.raise_error;

4037: If Csr_prtt_enrt_rslt%NOTFOUND Then
4038: Close Csr_prtt_enrt_rslt;
4039: hr_utility.set_location('BEN_91493_PEN_NOT_FOUND ID:'|| to_char(p_prtt_enrt_rslt_id), 65);
4040: fnd_message.set_name('BEN','BEN_91493_PEN_NOT_FOUND');
4041: fnd_message.raise_error;
4042: End If;
4043: Close Csr_prtt_enrt_rslt;
4044: --
4045: if p_per_in_ler_id is not null then

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

4173: if c_choice_info%notfound then
4174: --
4175: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4176: to_char(p_prtt_enrt_rslt_id), 75);
4177: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4178: fnd_message.set_token('ID', 'NA');
4179: fnd_message.set_token('PROC', '2:'||l_proc);
4180: fnd_message.raise_error;
4181: end if;

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

4174: --
4175: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4176: to_char(p_prtt_enrt_rslt_id), 75);
4177: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4178: fnd_message.set_token('ID', 'NA');
4179: fnd_message.set_token('PROC', '2:'||l_proc);
4180: fnd_message.raise_error;
4181: end if;
4182: close c_choice_info;

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

4175: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4176: to_char(p_prtt_enrt_rslt_id), 75);
4177: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4178: fnd_message.set_token('ID', 'NA');
4179: fnd_message.set_token('PROC', '2:'||l_proc);
4180: fnd_message.raise_error;
4181: end if;
4182: close c_choice_info;
4183: --

Line 4180: fnd_message.raise_error;

4176: to_char(p_prtt_enrt_rslt_id), 75);
4177: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4178: fnd_message.set_token('ID', 'NA');
4179: fnd_message.set_token('PROC', '2:'||l_proc);
4180: fnd_message.raise_error;
4181: end if;
4182: close c_choice_info;
4183: --
4184: If l_unsspnd_enrt_cd = 'ACD' then

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

4387: -- error
4388: --
4389: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4390: to_char(p_prtt_enrt_rslt_id), 75);
4391: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4392: fnd_message.set_token('ID', 'NA');
4393: fnd_message.set_token('PROC', '2:'||l_proc);
4394: fnd_message.raise_error;
4395: end if;

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

4388: --
4389: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4390: to_char(p_prtt_enrt_rslt_id), 75);
4391: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4392: fnd_message.set_token('ID', 'NA');
4393: fnd_message.set_token('PROC', '2:'||l_proc);
4394: fnd_message.raise_error;
4395: end if;
4396: close c_choice_info;

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

4389: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4390: to_char(p_prtt_enrt_rslt_id), 75);
4391: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4392: fnd_message.set_token('ID', 'NA');
4393: fnd_message.set_token('PROC', '2:'||l_proc);
4394: fnd_message.raise_error;
4395: end if;
4396: close c_choice_info;
4397: hr_utility.set_location('past c_choice_info', 10);

Line 4394: fnd_message.raise_error;

4390: to_char(p_prtt_enrt_rslt_id), 75);
4391: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4392: fnd_message.set_token('ID', 'NA');
4393: fnd_message.set_token('PROC', '2:'||l_proc);
4394: fnd_message.raise_error;
4395: end if;
4396: close c_choice_info;
4397: hr_utility.set_location('past c_choice_info', 10);
4398: --

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

4684: l_epe_object_version_number;
4685: if c_choice_info%notfound then
4686: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4687: to_char(p_prtt_enrt_rslt_id), 75);
4688: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4689: fnd_message.set_token('ID', 'NA');
4690: fnd_message.set_token('PROC', '2:'||l_proc);
4691: fnd_message.raise_error;
4692: end if;

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

4685: if c_choice_info%notfound then
4686: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4687: to_char(p_prtt_enrt_rslt_id), 75);
4688: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4689: fnd_message.set_token('ID', 'NA');
4690: fnd_message.set_token('PROC', '2:'||l_proc);
4691: fnd_message.raise_error;
4692: end if;
4693: close c_choice_info;

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

4686: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND rslt id:'||
4687: to_char(p_prtt_enrt_rslt_id), 75);
4688: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4689: fnd_message.set_token('ID', 'NA');
4690: fnd_message.set_token('PROC', '2:'||l_proc);
4691: fnd_message.raise_error;
4692: end if;
4693: close c_choice_info;
4694: --

Line 4691: fnd_message.raise_error;

4687: to_char(p_prtt_enrt_rslt_id), 75);
4688: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4689: fnd_message.set_token('ID', 'NA');
4690: fnd_message.set_token('PROC', '2:'||l_proc);
4691: fnd_message.raise_error;
4692: end if;
4693: close c_choice_info;
4694: --
4695: hr_utility.set_location('got the latest epe info', 10);

Line 4902: fnd_message.raise_error;

4898: hr_utility.set_location('ERROR '||l_proc, 95);
4899: rpt_error(l_proc, l_last_place);
4900: -- for nocopy changes
4901: p_object_version_number := l_object_version_number ;
4902: fnd_message.raise_error;
4903: End unsuspend_enrollment;
4904: --
4905: end ben_sspndd_enrollment;