DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on FND_MESSAGE

Line 752: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');

748: ,l_pil_stat_cd;
749: --
750: if c_pil%notfound then
751: close c_pil;
752: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
753: fnd_message.set_token('PROC',l_proc);
754: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
755: fnd_message.set_token('PERSON_ID',null);
756: fnd_message.set_token('LER_ID',null);

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

749: --
750: if c_pil%notfound then
751: close c_pil;
752: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
753: fnd_message.set_token('PROC',l_proc);
754: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
755: fnd_message.set_token('PERSON_ID',null);
756: fnd_message.set_token('LER_ID',null);
757: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

750: if c_pil%notfound then
751: close c_pil;
752: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
753: fnd_message.set_token('PROC',l_proc);
754: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
755: fnd_message.set_token('PERSON_ID',null);
756: fnd_message.set_token('LER_ID',null);
757: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
758: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 755: fnd_message.set_token('PERSON_ID',null);

751: close c_pil;
752: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
753: fnd_message.set_token('PROC',l_proc);
754: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
755: fnd_message.set_token('PERSON_ID',null);
756: fnd_message.set_token('LER_ID',null);
757: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
758: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
759: fnd_message.raise_error;

Line 756: fnd_message.set_token('LER_ID',null);

752: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
753: fnd_message.set_token('PROC',l_proc);
754: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
755: fnd_message.set_token('PERSON_ID',null);
756: fnd_message.set_token('LER_ID',null);
757: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
758: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
759: fnd_message.raise_error;
760: end if;

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

753: fnd_message.set_token('PROC',l_proc);
754: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
755: fnd_message.set_token('PERSON_ID',null);
756: fnd_message.set_token('LER_ID',null);
757: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
758: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
759: fnd_message.raise_error;
760: end if;
761: --

Line 758: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

754: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
755: fnd_message.set_token('PERSON_ID',null);
756: fnd_message.set_token('LER_ID',null);
757: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
758: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
759: fnd_message.raise_error;
760: end if;
761: --
762: close c_pil;

Line 759: fnd_message.raise_error;

755: fnd_message.set_token('PERSON_ID',null);
756: fnd_message.set_token('LER_ID',null);
757: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
758: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
759: fnd_message.raise_error;
760: end if;
761: --
762: close c_pil;
763: --

Line 789: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');

785: close c_min_max_enrt_dt ;
786:
787: if l_min_enrt_perd_strt_dt is not null and l_max_enrt_perd_end_dt is not null then
788: if not p_effective_date between l_min_enrt_perd_strt_dt and l_max_enrt_perd_end_dt then
789: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
790: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
791: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
792: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
793: fnd_message.raise_error;

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

786:
787: if l_min_enrt_perd_strt_dt is not null and l_max_enrt_perd_end_dt is not null then
788: if not p_effective_date between l_min_enrt_perd_strt_dt and l_max_enrt_perd_end_dt then
789: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
790: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
791: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
792: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
793: fnd_message.raise_error;
794: end if ;

Line 791: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);

787: if l_min_enrt_perd_strt_dt is not null and l_max_enrt_perd_end_dt is not null then
788: if not p_effective_date between l_min_enrt_perd_strt_dt and l_max_enrt_perd_end_dt then
789: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
790: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
791: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
792: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
793: fnd_message.raise_error;
794: end if ;
795: end if ;

Line 792: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);

788: if not p_effective_date between l_min_enrt_perd_strt_dt and l_max_enrt_perd_end_dt then
789: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
790: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
791: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
792: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
793: fnd_message.raise_error;
794: end if ;
795: end if ;
796: */

Line 793: fnd_message.raise_error;

789: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
790: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
791: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
792: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
793: fnd_message.raise_error;
794: end if ;
795: end if ;
796: */
797:

Line 973: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');

969: elsif l_rec.enrt_perd_end_dt is NULL then
970: --
971: hr_utility.set_location('enrt_perd_end date is NULL', 10);
972: --
973: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
974: fnd_message.set_token('PROC',l_proc);
975: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
976: to_char(l_rec.pil_elctbl_chc_popl_id));
977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

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

970: --
971: hr_utility.set_location('enrt_perd_end date is NULL', 10);
972: --
973: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
974: fnd_message.set_token('PROC',l_proc);
975: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
976: to_char(l_rec.pil_elctbl_chc_popl_id));
977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
978: fnd_message.set_token('LER_ID',to_char(l_ler_id));

Line 975: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

971: hr_utility.set_location('enrt_perd_end date is NULL', 10);
972: --
973: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
974: fnd_message.set_token('PROC',l_proc);
975: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
976: to_char(l_rec.pil_elctbl_chc_popl_id));
977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
978: fnd_message.set_token('LER_ID',to_char(l_ler_id));
979: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

973: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
974: fnd_message.set_token('PROC',l_proc);
975: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
976: to_char(l_rec.pil_elctbl_chc_popl_id));
977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
978: fnd_message.set_token('LER_ID',to_char(l_ler_id));
979: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
980: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
981: fnd_message.raise_error;

Line 978: fnd_message.set_token('LER_ID',to_char(l_ler_id));

974: fnd_message.set_token('PROC',l_proc);
975: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
976: to_char(l_rec.pil_elctbl_chc_popl_id));
977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
978: fnd_message.set_token('LER_ID',to_char(l_ler_id));
979: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
980: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
981: fnd_message.raise_error;
982: --

Line 979: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

975: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
976: to_char(l_rec.pil_elctbl_chc_popl_id));
977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
978: fnd_message.set_token('LER_ID',to_char(l_ler_id));
979: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
980: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
981: fnd_message.raise_error;
982: --
983: end if;

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

976: to_char(l_rec.pil_elctbl_chc_popl_id));
977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
978: fnd_message.set_token('LER_ID',to_char(l_ler_id));
979: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
980: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
981: fnd_message.raise_error;
982: --
983: end if;
984: --

Line 981: fnd_message.raise_error;

977: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
978: fnd_message.set_token('LER_ID',to_char(l_ler_id));
979: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
980: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
981: fnd_message.raise_error;
982: --
983: end if;
984: --
985: elsif l_rec.cls_enrt_dt_to_use_cd = 'PROCGEND' then

Line 1025: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');

1021: elsif l_rec.procg_end_dt is null then
1022: --
1023: hr_utility.set_location('Processing end date is null', 10);
1024: --
1025: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1026: fnd_message.set_token('PROC',l_proc);
1027: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1028: to_char(l_rec.pil_elctbl_chc_popl_id));
1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

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

1022: --
1023: hr_utility.set_location('Processing end date is null', 10);
1024: --
1025: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1026: fnd_message.set_token('PROC',l_proc);
1027: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1028: to_char(l_rec.pil_elctbl_chc_popl_id));
1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1030: fnd_message.set_token('LER_ID',to_char(l_ler_id));

Line 1027: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

1023: hr_utility.set_location('Processing end date is null', 10);
1024: --
1025: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1026: fnd_message.set_token('PROC',l_proc);
1027: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1028: to_char(l_rec.pil_elctbl_chc_popl_id));
1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1030: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1031: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

1025: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1026: fnd_message.set_token('PROC',l_proc);
1027: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1028: to_char(l_rec.pil_elctbl_chc_popl_id));
1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1030: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1031: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1033: fnd_message.raise_error;

Line 1030: fnd_message.set_token('LER_ID',to_char(l_ler_id));

1026: fnd_message.set_token('PROC',l_proc);
1027: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1028: to_char(l_rec.pil_elctbl_chc_popl_id));
1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1030: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1031: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1033: fnd_message.raise_error;
1034: --

Line 1031: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

1027: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1028: to_char(l_rec.pil_elctbl_chc_popl_id));
1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1030: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1031: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1033: fnd_message.raise_error;
1034: --
1035: end if;

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

1028: to_char(l_rec.pil_elctbl_chc_popl_id));
1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1030: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1031: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1033: fnd_message.raise_error;
1034: --
1035: end if;
1036: --

Line 1033: fnd_message.raise_error;

1029: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1030: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1031: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1033: fnd_message.raise_error;
1034: --
1035: end if;
1036: --
1037: else

Line 1041: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');

1037: else
1038: --
1039: hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
1040: --
1041: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1042: fnd_message.set_token('PROC',l_proc);
1043: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1044: l_rec.cls_enrt_dt_to_use_cd);
1045: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

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

1038: --
1039: hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
1040: --
1041: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1042: fnd_message.set_token('PROC',l_proc);
1043: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1044: l_rec.cls_enrt_dt_to_use_cd);
1045: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1046: to_char(l_rec.pil_elctbl_chc_popl_id));

Line 1043: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',

1039: hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
1040: --
1041: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1042: fnd_message.set_token('PROC',l_proc);
1043: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1044: l_rec.cls_enrt_dt_to_use_cd);
1045: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1046: to_char(l_rec.pil_elctbl_chc_popl_id));
1047: fnd_message.raise_error;

Line 1045: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

1041: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1042: fnd_message.set_token('PROC',l_proc);
1043: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1044: l_rec.cls_enrt_dt_to_use_cd);
1045: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1046: to_char(l_rec.pil_elctbl_chc_popl_id));
1047: fnd_message.raise_error;
1048: --
1049: end if;

Line 1047: fnd_message.raise_error;

1043: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1044: l_rec.cls_enrt_dt_to_use_cd);
1045: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1046: to_char(l_rec.pil_elctbl_chc_popl_id));
1047: fnd_message.raise_error;
1048: --
1049: end if;
1050: --
1051: if l_set_pel_stat_cd = TRUE then

Line 1443: fnd_message.raise_error;

1439: --
1440: raise ben_batch_utils.g_record_error;
1441: --
1442: else
1443: fnd_message.raise_error;
1444: end if;
1445: --
1446: end close_single_enrollment;
1447: --

Line 1690: l_encoded_message := fnd_message.get_encoded;

1686: ben_env_object.get(p_rec => l_env);
1687: ben_person_object.get_object(p_person_id => g_cache_per_proc(l_cnt).person_id,
1688: p_rec => l_per_rec);
1689: --
1690: l_encoded_message := fnd_message.get_encoded;
1691: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1692: app_short_name => l_app_short_name,
1693: message_name => l_message_name);
1694:

Line 1691: fnd_message.parse_encoded(encoded_message => l_encoded_message,

1687: ben_person_object.get_object(p_person_id => g_cache_per_proc(l_cnt).person_id,
1688: p_rec => l_per_rec);
1689: --
1690: l_encoded_message := fnd_message.get_encoded;
1691: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1692: app_short_name => l_app_short_name,
1693: message_name => l_message_name);
1694:
1695: fnd_message.set_encoded(encoded_message => l_encoded_message);

Line 1695: fnd_message.set_encoded(encoded_message => l_encoded_message);

1691: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1692: app_short_name => l_app_short_name,
1693: message_name => l_message_name);
1694:
1695: fnd_message.set_encoded(encoded_message => l_encoded_message);
1696: --
1697: g_rec.text := fnd_message.get ;
1698: --
1699: g_rec.error_message_code := nvl(l_message_name , nvl(g_rec.error_message_code,sqlcode));

Line 1697: g_rec.text := fnd_message.get ;

1693: message_name => l_message_name);
1694:
1695: fnd_message.set_encoded(encoded_message => l_encoded_message);
1696: --
1697: g_rec.text := fnd_message.get ;
1698: --
1699: g_rec.error_message_code := nvl(l_message_name , nvl(g_rec.error_message_code,sqlcode));
1700: g_rec.text := nvl(g_rec.text , nvl(g_rec.text,substr(sqlerrm,1,400)) );
1701: g_rec.rep_typ_cd := 'ERROR';

Line 1717: fnd_message.raise_error;

1713: --
1714: -- end bug 3079317
1715: --
1716: if g_persons_errored > g_max_person_err then
1717: fnd_message.raise_error;
1718: end if;
1719: --
1720: end;
1721: --

Line 1730: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');

1726: hr_utility.set_location('No records found. Erroring out.', 10);
1727: --
1728: l_actn := 'Reporting error since there is no record found';
1729: --
1730: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1731: fnd_message.set_token('PROC',l_proc);
1732: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1733: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1734: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1727: --
1728: l_actn := 'Reporting error since there is no record found';
1729: --
1730: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1731: fnd_message.set_token('PROC',l_proc);
1732: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1733: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1734: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1735: fnd_message.raise_error;

Line 1732: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));

1728: l_actn := 'Reporting error since there is no record found';
1729: --
1730: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1731: fnd_message.set_token('PROC',l_proc);
1732: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1733: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1734: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1735: fnd_message.raise_error;
1736: --

Line 1733: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

1729: --
1730: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1731: fnd_message.set_token('PROC',l_proc);
1732: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1733: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1734: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1735: fnd_message.raise_error;
1736: --
1737: end if;

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

1730: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1731: fnd_message.set_token('PROC',l_proc);
1732: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1733: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1734: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1735: fnd_message.raise_error;
1736: --
1737: end if;
1738: --

Line 1735: fnd_message.raise_error;

1731: fnd_message.set_token('PROC',l_proc);
1732: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1733: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1734: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1735: fnd_message.raise_error;
1736: --
1737: end if;
1738: --
1739: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

Line 1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1770: ,p_num_pers_errored => g_persons_errored);
1771: --
1772: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1773: --
1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1775: fnd_message.set_token('PROCEDURE', l_proc);
1776: fnd_message.set_token('STEP',l_actn );
1777: fnd_message.raise_error;
1778: --

Line 1775: fnd_message.set_token('PROCEDURE', l_proc);

1771: --
1772: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1773: --
1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1775: fnd_message.set_token('PROCEDURE', l_proc);
1776: fnd_message.set_token('STEP',l_actn );
1777: fnd_message.raise_error;
1778: --
1779: end do_multithread;

Line 1776: fnd_message.set_token('STEP',l_actn );

1772: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1773: --
1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1775: fnd_message.set_token('PROCEDURE', l_proc);
1776: fnd_message.set_token('STEP',l_actn );
1777: fnd_message.raise_error;
1778: --
1779: end do_multithread;
1780: --

Line 1777: fnd_message.raise_error;

1773: --
1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1775: fnd_message.set_token('PROCEDURE', l_proc);
1776: fnd_message.set_token('STEP',l_actn );
1777: fnd_message.raise_error;
1778: --
1779: end do_multithread;
1780: --
1781: -- -----------------------------------------------------------------------------

Line 1837: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');

1833: --
1834: if c_parameters%notfound then
1835: --
1836: close c_parameters;
1837: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1838: fnd_message.set_token('PROC',l_proc);
1839: fnd_message.raise_error;
1840: --
1841: end if;

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

1834: if c_parameters%notfound then
1835: --
1836: close c_parameters;
1837: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1838: fnd_message.set_token('PROC',l_proc);
1839: fnd_message.raise_error;
1840: --
1841: end if;
1842: --

Line 1839: fnd_message.raise_error;

1835: --
1836: close c_parameters;
1837: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1838: fnd_message.set_token('PROC',l_proc);
1839: fnd_message.raise_error;
1840: --
1841: end if;
1842: --
1843: close c_parameters;

Line 2071: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');

2067: -- p_pgm_id and Pl_nip are mutually exclusive
2068: --
2069: if p_pgm_id is not null and p_pl_nip_id is not null then
2070: --
2071: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2072: fnd_message.set_token('PROC',l_proc);
2073: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2075: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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

2068: --
2069: if p_pgm_id is not null and p_pl_nip_id is not null then
2070: --
2071: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2072: fnd_message.set_token('PROC',l_proc);
2073: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2075: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2076: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

2069: if p_pgm_id is not null and p_pl_nip_id is not null then
2070: --
2071: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2072: fnd_message.set_token('PROC',l_proc);
2073: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2075: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2076: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2077: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));

2070: --
2071: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2072: fnd_message.set_token('PROC',l_proc);
2073: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2075: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2076: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2077: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2078: fnd_message.raise_error;

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

2071: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2072: fnd_message.set_token('PROC',l_proc);
2073: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2075: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2076: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2077: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2078: fnd_message.raise_error;
2079: --

Line 2076: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

2072: fnd_message.set_token('PROC',l_proc);
2073: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2075: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2076: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2077: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2078: fnd_message.raise_error;
2079: --
2080: end if;

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

2073: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2075: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2076: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2077: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2078: fnd_message.raise_error;
2079: --
2080: end if;
2081: --

Line 2078: fnd_message.raise_error;

2074: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2075: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2076: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2077: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2078: fnd_message.raise_error;
2079: --
2080: end if;
2081: --
2082: -- Initialize the batch process.

Line 2354: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');

2350: --
2351: ben_batch_utils.write(p_text =>
2352: 'No person got selected with above selection criteria.');
2353: --
2354: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2355: fnd_message.set_token('PROC',l_proc);
2356: fnd_message.raise_error;
2357: --
2358: end if;

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

2351: ben_batch_utils.write(p_text =>
2352: 'No person got selected with above selection criteria.');
2353: --
2354: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2355: fnd_message.set_token('PROC',l_proc);
2356: fnd_message.raise_error;
2357: --
2358: end if;
2359: --

Line 2356: fnd_message.raise_error;

2352: 'No person got selected with above selection criteria.');
2353: --
2354: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2355: fnd_message.set_token('PROC',l_proc);
2356: fnd_message.raise_error;
2357: --
2358: end if;
2359: --
2360: -- Carry on with the master. This will ensure that the master finishes last.

Line 2399: benutils.write(p_text => fnd_message.get);

2395: ben_batch_utils.rpt_error(p_proc => l_proc
2396: ,p_last_actn => l_actn
2397: ,p_rpt_flag => TRUE);
2398: --
2399: benutils.write(p_text => fnd_message.get);
2400: benutils.write(p_text => sqlerrm);
2401: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
2402: --
2403: if l_num_ranges > 0 then

Line 2415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2411: submit_all_reports(p_audit_log => p_audit_log);
2412: --
2413: end if;
2414: --
2415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2416: fnd_message.set_token('PROCEDURE', l_proc);
2417: fnd_message.set_token('STEP', l_actn );
2418: fnd_message.raise_error;
2419: --

Line 2416: fnd_message.set_token('PROCEDURE', l_proc);

2412: --
2413: end if;
2414: --
2415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2416: fnd_message.set_token('PROCEDURE', l_proc);
2417: fnd_message.set_token('STEP', l_actn );
2418: fnd_message.raise_error;
2419: --
2420: end process;

Line 2417: fnd_message.set_token('STEP', l_actn );

2413: end if;
2414: --
2415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2416: fnd_message.set_token('PROCEDURE', l_proc);
2417: fnd_message.set_token('STEP', l_actn );
2418: fnd_message.raise_error;
2419: --
2420: end process;
2421: --

Line 2418: fnd_message.raise_error;

2414: --
2415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2416: fnd_message.set_token('PROCEDURE', l_proc);
2417: fnd_message.set_token('STEP', l_actn );
2418: fnd_message.raise_error;
2419: --
2420: end process;
2421: --
2422: -- Bug : 1700853 : reopen the closed life event.

Line 2545: fnd_message.set_name('BEN', 'BEN_93044_REOPEN_LF_EVNT');

2541: close c_chk_reopen_lf_event;
2542:
2543: --
2544: if(l_chk_reopen_lf_event.ELIG_PER_ELCTBL_CHC_ID is NULL and p_source = 'reopen') then --Bug 5929635 : Do not raise error message if the call is in backout routine
2545: fnd_message.set_name('BEN', 'BEN_93044_REOPEN_LF_EVNT');
2546: fnd_message.raise_error;
2547: end if;
2548: --
2549:

Line 2546: fnd_message.raise_error;

2542:
2543: --
2544: if(l_chk_reopen_lf_event.ELIG_PER_ELCTBL_CHC_ID is NULL and p_source = 'reopen') then --Bug 5929635 : Do not raise error message if the call is in backout routine
2545: fnd_message.set_name('BEN', 'BEN_93044_REOPEN_LF_EVNT');
2546: fnd_message.raise_error;
2547: end if;
2548: --
2549:
2550: --

Line 2559: fnd_message.set_name('BEN', 'BEN_92711_LIFE_EVENT_EXISTS');

2555: fetch c_get_future_per_in_ler into l_exists;
2556:
2557: if c_get_future_per_in_ler%found then
2558: close c_get_future_per_in_ler;
2559: fnd_message.set_name('BEN', 'BEN_92711_LIFE_EVENT_EXISTS');
2560: fnd_message.raise_error;
2561: else
2562: close c_get_future_per_in_ler;
2563: end if;

Line 2560: fnd_message.raise_error;

2556:
2557: if c_get_future_per_in_ler%found then
2558: close c_get_future_per_in_ler;
2559: fnd_message.set_name('BEN', 'BEN_92711_LIFE_EVENT_EXISTS');
2560: fnd_message.raise_error;
2561: else
2562: close c_get_future_per_in_ler;
2563: end if;
2564: --

Line 2697: fnd_message.set_name('BEN', 'BEN_92988_CANT_CLS_ENRT');

2693: --
2694: commit;
2695: exception
2696: when others then
2697: fnd_message.set_name('BEN', 'BEN_92988_CANT_CLS_ENRT');
2698: --
2699: end close_single_enrollment_ss;
2700: --
2701: procedure close_enrt_n_run_benmngle_ss