DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on FND_MESSAGE

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

770: ,l_pil_stat_cd;
771: --
772: if c_pil%notfound then
773: close c_pil;
774: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
775: fnd_message.set_token('PROC',l_proc);
776: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
777: fnd_message.set_token('PERSON_ID',null);
778: fnd_message.set_token('LER_ID',null);

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

771: --
772: if c_pil%notfound then
773: close c_pil;
774: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
775: fnd_message.set_token('PROC',l_proc);
776: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
777: fnd_message.set_token('PERSON_ID',null);
778: fnd_message.set_token('LER_ID',null);
779: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

772: if c_pil%notfound then
773: close c_pil;
774: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
775: fnd_message.set_token('PROC',l_proc);
776: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
777: fnd_message.set_token('PERSON_ID',null);
778: fnd_message.set_token('LER_ID',null);
779: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
780: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

773: close c_pil;
774: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
775: fnd_message.set_token('PROC',l_proc);
776: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
777: fnd_message.set_token('PERSON_ID',null);
778: fnd_message.set_token('LER_ID',null);
779: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
780: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
781: fnd_message.raise_error;

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

774: fnd_message.set_name('BEN','BEN_91272_PER_IN_LER_MISSING');
775: fnd_message.set_token('PROC',l_proc);
776: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
777: fnd_message.set_token('PERSON_ID',null);
778: fnd_message.set_token('LER_ID',null);
779: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
780: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
781: fnd_message.raise_error;
782: end if;

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

775: fnd_message.set_token('PROC',l_proc);
776: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
777: fnd_message.set_token('PERSON_ID',null);
778: fnd_message.set_token('LER_ID',null);
779: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
780: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
781: fnd_message.raise_error;
782: end if;
783: --

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

776: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
777: fnd_message.set_token('PERSON_ID',null);
778: fnd_message.set_token('LER_ID',null);
779: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
780: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
781: fnd_message.raise_error;
782: end if;
783: --
784: close c_pil;

Line 781: fnd_message.raise_error;

777: fnd_message.set_token('PERSON_ID',null);
778: fnd_message.set_token('LER_ID',null);
779: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
780: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
781: fnd_message.raise_error;
782: end if;
783: --
784: close c_pil;
785: --

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

807: close c_min_max_enrt_dt ;
808:
809: if l_min_enrt_perd_strt_dt is not null and l_max_enrt_perd_end_dt is not null then
810: if not p_effective_date between l_min_enrt_perd_strt_dt and l_max_enrt_perd_end_dt then
811: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
812: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
813: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
814: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
815: fnd_message.raise_error;

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

808:
809: if l_min_enrt_perd_strt_dt is not null and l_max_enrt_perd_end_dt is not null then
810: if not p_effective_date between l_min_enrt_perd_strt_dt and l_max_enrt_perd_end_dt then
811: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
812: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
813: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
814: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
815: fnd_message.raise_error;
816: end if ;

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

809: if l_min_enrt_perd_strt_dt is not null and l_max_enrt_perd_end_dt is not null then
810: if not p_effective_date between l_min_enrt_perd_strt_dt and l_max_enrt_perd_end_dt then
811: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
812: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
813: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
814: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
815: fnd_message.raise_error;
816: end if ;
817: end if ;

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

810: if not p_effective_date between l_min_enrt_perd_strt_dt and l_max_enrt_perd_end_dt then
811: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
812: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
813: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
814: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
815: fnd_message.raise_error;
816: end if ;
817: end if ;
818: */

Line 815: fnd_message.raise_error;

811: fnd_message.set_name('BEN','BEN_93111_ENRT_PERD_CLS_DT');
812: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
813: fnd_message.set_token('ENRT_PERD_STRT_DT',l_min_enrt_perd_strt_dt);
814: fnd_message.set_token('ENRT_PERD_END_DT',l_max_enrt_perd_end_dt);
815: fnd_message.raise_error;
816: end if ;
817: end if ;
818: */
819:

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

1009: elsif l_rec.enrt_perd_end_dt is NULL then
1010: --
1011: hr_utility.set_location('enrt_perd_end date is NULL', 10);
1012: --
1013: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
1014: fnd_message.set_token('PROC',l_proc);
1015: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1016: to_char(l_rec.pil_elctbl_chc_popl_id));
1017: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

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

1010: --
1011: hr_utility.set_location('enrt_perd_end date is NULL', 10);
1012: --
1013: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
1014: fnd_message.set_token('PROC',l_proc);
1015: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1016: to_char(l_rec.pil_elctbl_chc_popl_id));
1017: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1018: fnd_message.set_token('LER_ID',to_char(l_ler_id));

Line 1015: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

1011: hr_utility.set_location('enrt_perd_end date is NULL', 10);
1012: --
1013: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
1014: fnd_message.set_token('PROC',l_proc);
1015: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1016: to_char(l_rec.pil_elctbl_chc_popl_id));
1017: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1018: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1019: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

1013: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
1014: fnd_message.set_token('PROC',l_proc);
1015: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1016: to_char(l_rec.pil_elctbl_chc_popl_id));
1017: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1018: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1019: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1020: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1021: fnd_message.raise_error;

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

1014: fnd_message.set_token('PROC',l_proc);
1015: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1016: to_char(l_rec.pil_elctbl_chc_popl_id));
1017: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1018: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1019: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1020: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1021: fnd_message.raise_error;
1022: --

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

1015: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1016: to_char(l_rec.pil_elctbl_chc_popl_id));
1017: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1018: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1019: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1020: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1021: fnd_message.raise_error;
1022: --
1023: end if;

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

1016: to_char(l_rec.pil_elctbl_chc_popl_id));
1017: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1018: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1019: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1020: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1021: fnd_message.raise_error;
1022: --
1023: end if;
1024: --

Line 1021: fnd_message.raise_error;

1017: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1018: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1019: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1020: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1021: fnd_message.raise_error;
1022: --
1023: end if;
1024: --
1025: elsif l_rec.cls_enrt_dt_to_use_cd = 'PROCGEND' then

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

1061: elsif l_rec.procg_end_dt is null then
1062: --
1063: hr_utility.set_location('Processing end date is null', 10);
1064: --
1065: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1066: fnd_message.set_token('PROC',l_proc);
1067: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1068: to_char(l_rec.pil_elctbl_chc_popl_id));
1069: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

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

1062: --
1063: hr_utility.set_location('Processing end date is null', 10);
1064: --
1065: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1066: fnd_message.set_token('PROC',l_proc);
1067: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1068: to_char(l_rec.pil_elctbl_chc_popl_id));
1069: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1070: fnd_message.set_token('LER_ID',to_char(l_ler_id));

Line 1067: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

1063: hr_utility.set_location('Processing end date is null', 10);
1064: --
1065: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1066: fnd_message.set_token('PROC',l_proc);
1067: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1068: to_char(l_rec.pil_elctbl_chc_popl_id));
1069: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1070: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1071: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

1065: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1066: fnd_message.set_token('PROC',l_proc);
1067: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1068: to_char(l_rec.pil_elctbl_chc_popl_id));
1069: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1070: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1071: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1072: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1073: fnd_message.raise_error;

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

1066: fnd_message.set_token('PROC',l_proc);
1067: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1068: to_char(l_rec.pil_elctbl_chc_popl_id));
1069: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1070: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1071: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1072: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1073: fnd_message.raise_error;
1074: --

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

1067: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1068: to_char(l_rec.pil_elctbl_chc_popl_id));
1069: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1070: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1071: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1072: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1073: fnd_message.raise_error;
1074: --
1075: end if;

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

1068: to_char(l_rec.pil_elctbl_chc_popl_id));
1069: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1070: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1071: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1072: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1073: fnd_message.raise_error;
1074: --
1075: end if;
1076: --

Line 1073: fnd_message.raise_error;

1069: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
1070: fnd_message.set_token('LER_ID',to_char(l_ler_id));
1071: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1072: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1073: fnd_message.raise_error;
1074: --
1075: end if;
1076: --
1077: else

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

1077: else
1078: --
1079: hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
1080: --
1081: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1082: fnd_message.set_token('PROC',l_proc);
1083: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1084: l_rec.cls_enrt_dt_to_use_cd);
1085: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

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

1078: --
1079: hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
1080: --
1081: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1082: fnd_message.set_token('PROC',l_proc);
1083: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1084: l_rec.cls_enrt_dt_to_use_cd);
1085: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1086: to_char(l_rec.pil_elctbl_chc_popl_id));

Line 1083: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',

1079: hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
1080: --
1081: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1082: fnd_message.set_token('PROC',l_proc);
1083: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1084: l_rec.cls_enrt_dt_to_use_cd);
1085: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1086: to_char(l_rec.pil_elctbl_chc_popl_id));
1087: fnd_message.raise_error;

Line 1085: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

1081: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1082: fnd_message.set_token('PROC',l_proc);
1083: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1084: l_rec.cls_enrt_dt_to_use_cd);
1085: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1086: to_char(l_rec.pil_elctbl_chc_popl_id));
1087: fnd_message.raise_error;
1088: --
1089: end if;

Line 1087: fnd_message.raise_error;

1083: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',
1084: l_rec.cls_enrt_dt_to_use_cd);
1085: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',
1086: to_char(l_rec.pil_elctbl_chc_popl_id));
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --
1091: if l_set_pel_stat_cd = TRUE then

Line 1483: fnd_message.raise_error;

1479: --
1480: raise ben_batch_utils.g_record_error;
1481: --
1482: else
1483: fnd_message.raise_error;
1484: end if;
1485: --
1486: end close_single_enrollment;
1487: --

Line 1730: l_encoded_message := fnd_message.get_encoded;

1726: ben_env_object.get(p_rec => l_env);
1727: ben_person_object.get_object(p_person_id => g_cache_per_proc(l_cnt).person_id,
1728: p_rec => l_per_rec);
1729: --
1730: l_encoded_message := fnd_message.get_encoded;
1731: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1732: app_short_name => l_app_short_name,
1733: message_name => l_message_name);
1734:

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

1727: ben_person_object.get_object(p_person_id => g_cache_per_proc(l_cnt).person_id,
1728: p_rec => l_per_rec);
1729: --
1730: l_encoded_message := fnd_message.get_encoded;
1731: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1732: app_short_name => l_app_short_name,
1733: message_name => l_message_name);
1734:
1735: fnd_message.set_encoded(encoded_message => l_encoded_message);

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

1731: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1732: app_short_name => l_app_short_name,
1733: message_name => l_message_name);
1734:
1735: fnd_message.set_encoded(encoded_message => l_encoded_message);
1736: --
1737: g_rec.text := fnd_message.get ;
1738: --
1739: g_rec.error_message_code := nvl(l_message_name , nvl(g_rec.error_message_code,sqlcode));

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

1733: message_name => l_message_name);
1734:
1735: fnd_message.set_encoded(encoded_message => l_encoded_message);
1736: --
1737: g_rec.text := fnd_message.get ;
1738: --
1739: g_rec.error_message_code := nvl(l_message_name , nvl(g_rec.error_message_code,sqlcode));
1740: g_rec.text := nvl(g_rec.text , nvl(g_rec.text,substr(sqlerrm,1,400)) );
1741: g_rec.rep_typ_cd := 'ERROR';

Line 1757: fnd_message.raise_error;

1753: --
1754: -- end bug 3079317
1755: --
1756: if g_persons_errored > g_max_person_err then
1757: fnd_message.raise_error;
1758: end if;
1759: --
1760: end;
1761: --

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

1766: hr_utility.set_location('No records found. Erroring out.', 10);
1767: --
1768: l_actn := 'Reporting error since there is no record found';
1769: --
1770: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1771: fnd_message.set_token('PROC',l_proc);
1772: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1773: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1774: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1767: --
1768: l_actn := 'Reporting error since there is no record found';
1769: --
1770: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1771: fnd_message.set_token('PROC',l_proc);
1772: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1773: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1774: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1775: fnd_message.raise_error;

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

1768: l_actn := 'Reporting error since there is no record found';
1769: --
1770: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1771: fnd_message.set_token('PROC',l_proc);
1772: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1773: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1774: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1775: fnd_message.raise_error;
1776: --

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

1769: --
1770: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1771: fnd_message.set_token('PROC',l_proc);
1772: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1773: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1774: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1775: fnd_message.raise_error;
1776: --
1777: end if;

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

1770: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1771: fnd_message.set_token('PROC',l_proc);
1772: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1773: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1774: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1775: fnd_message.raise_error;
1776: --
1777: end if;
1778: --

Line 1775: fnd_message.raise_error;

1771: fnd_message.set_token('PROC',l_proc);
1772: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1773: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1774: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1775: fnd_message.raise_error;
1776: --
1777: end if;
1778: --
1779: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

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

1810: ,p_num_pers_errored => g_persons_errored);
1811: --
1812: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1813: --
1814: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1815: fnd_message.set_token('PROCEDURE', l_proc);
1816: fnd_message.set_token('STEP',l_actn );
1817: fnd_message.raise_error;
1818: --

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

1811: --
1812: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1813: --
1814: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1815: fnd_message.set_token('PROCEDURE', l_proc);
1816: fnd_message.set_token('STEP',l_actn );
1817: fnd_message.raise_error;
1818: --
1819: end do_multithread;

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

1812: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1813: --
1814: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1815: fnd_message.set_token('PROCEDURE', l_proc);
1816: fnd_message.set_token('STEP',l_actn );
1817: fnd_message.raise_error;
1818: --
1819: end do_multithread;
1820: --

Line 1817: fnd_message.raise_error;

1813: --
1814: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1815: fnd_message.set_token('PROCEDURE', l_proc);
1816: fnd_message.set_token('STEP',l_actn );
1817: fnd_message.raise_error;
1818: --
1819: end do_multithread;
1820: --
1821: -- -----------------------------------------------------------------------------

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

1873: --
1874: if c_parameters%notfound then
1875: --
1876: close c_parameters;
1877: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1878: fnd_message.set_token('PROC',l_proc);
1879: fnd_message.raise_error;
1880: --
1881: end if;

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

1874: if c_parameters%notfound then
1875: --
1876: close c_parameters;
1877: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1878: fnd_message.set_token('PROC',l_proc);
1879: fnd_message.raise_error;
1880: --
1881: end if;
1882: --

Line 1879: fnd_message.raise_error;

1875: --
1876: close c_parameters;
1877: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1878: fnd_message.set_token('PROC',l_proc);
1879: fnd_message.raise_error;
1880: --
1881: end if;
1882: --
1883: close c_parameters;

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

2107: -- p_pgm_id and Pl_nip are mutually exclusive
2108: --
2109: if p_pgm_id is not null and p_pl_nip_id is not null then
2110: --
2111: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2114: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2115: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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

2108: --
2109: if p_pgm_id is not null and p_pl_nip_id is not null then
2110: --
2111: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2114: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2115: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2116: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

2109: if p_pgm_id is not null and p_pl_nip_id is not null then
2110: --
2111: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2114: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2115: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2116: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2117: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

2110: --
2111: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2114: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2115: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2116: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2117: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2118: fnd_message.raise_error;

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

2111: fnd_message.set_name('BEN', 'BEN_91907_PGM_PL_MUTUAL_EXCL');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2114: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2115: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2116: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2117: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2118: fnd_message.raise_error;
2119: --

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

2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2114: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2115: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2116: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2117: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2118: fnd_message.raise_error;
2119: --
2120: end if;

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

2113: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2114: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2115: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2116: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2117: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2118: fnd_message.raise_error;
2119: --
2120: end if;
2121: --

Line 2118: fnd_message.raise_error;

2114: fnd_message.set_token('PL_NIP_ID',to_char(p_pl_nip_id));
2115: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2116: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2117: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2118: fnd_message.raise_error;
2119: --
2120: end if;
2121: --
2122: -- Initialize the batch process.

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

2390: --
2391: ben_batch_utils.write(p_text =>
2392: 'No person got selected with above selection criteria.');
2393: --
2394: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2395: fnd_message.set_token('PROC',l_proc);
2396: fnd_message.raise_error;
2397: --
2398: end if;

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

2391: ben_batch_utils.write(p_text =>
2392: 'No person got selected with above selection criteria.');
2393: --
2394: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2395: fnd_message.set_token('PROC',l_proc);
2396: fnd_message.raise_error;
2397: --
2398: end if;
2399: --

Line 2396: fnd_message.raise_error;

2392: 'No person got selected with above selection criteria.');
2393: --
2394: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2395: fnd_message.set_token('PROC',l_proc);
2396: fnd_message.raise_error;
2397: --
2398: end if;
2399: --
2400: -- Carry on with the master. This will ensure that the master finishes last.

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

2435: ben_batch_utils.rpt_error(p_proc => l_proc
2436: ,p_last_actn => l_actn
2437: ,p_rpt_flag => TRUE);
2438: --
2439: benutils.write(p_text => fnd_message.get);
2440: benutils.write(p_text => sqlerrm);
2441: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
2442: --
2443: if l_num_ranges > 0 then

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

2451: submit_all_reports(p_audit_log => p_audit_log);
2452: --
2453: end if;
2454: --
2455: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2456: fnd_message.set_token('PROCEDURE', l_proc);
2457: fnd_message.set_token('STEP', l_actn );
2458: fnd_message.raise_error;
2459: --

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

2452: --
2453: end if;
2454: --
2455: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2456: fnd_message.set_token('PROCEDURE', l_proc);
2457: fnd_message.set_token('STEP', l_actn );
2458: fnd_message.raise_error;
2459: --
2460: end process;

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

2453: end if;
2454: --
2455: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2456: fnd_message.set_token('PROCEDURE', l_proc);
2457: fnd_message.set_token('STEP', l_actn );
2458: fnd_message.raise_error;
2459: --
2460: end process;
2461: --

Line 2458: fnd_message.raise_error;

2454: --
2455: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2456: fnd_message.set_token('PROCEDURE', l_proc);
2457: fnd_message.set_token('STEP', l_actn );
2458: fnd_message.raise_error;
2459: --
2460: end process;
2461: --
2462: -- Bug : 1700853 : reopen the closed life event.

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

2581: close c_chk_reopen_lf_event;
2582:
2583: --
2584: 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
2585: fnd_message.set_name('BEN', 'BEN_93044_REOPEN_LF_EVNT');
2586: fnd_message.raise_error;
2587: end if;
2588: --
2589:

Line 2586: fnd_message.raise_error;

2582:
2583: --
2584: 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
2585: fnd_message.set_name('BEN', 'BEN_93044_REOPEN_LF_EVNT');
2586: fnd_message.raise_error;
2587: end if;
2588: --
2589:
2590: --

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

2600: fetch c_get_future_per_in_ler into l_exists;
2601:
2602: if c_get_future_per_in_ler%found then
2603: close c_get_future_per_in_ler;
2604: fnd_message.set_name('BEN', 'BEN_92711_LIFE_EVENT_EXISTS');
2605: fnd_message.raise_error;
2606: else
2607: close c_get_future_per_in_ler;
2608: end if;

Line 2605: fnd_message.raise_error;

2601:
2602: if c_get_future_per_in_ler%found then
2603: close c_get_future_per_in_ler;
2604: fnd_message.set_name('BEN', 'BEN_92711_LIFE_EVENT_EXISTS');
2605: fnd_message.raise_error;
2606: else
2607: close c_get_future_per_in_ler;
2608: end if;
2609: end if;

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

2746: --
2747: commit;
2748: exception
2749: when others then
2750: fnd_message.set_name('BEN', 'BEN_92988_CANT_CLS_ENRT');
2751: --
2752: end close_single_enrollment_ss;
2753: --
2754: procedure close_enrt_n_run_benmngle_ss