22: 16 Jun 98 T Guy 110.01 Removed other exception.
23: 27-Jul-98 T Guy 110.2 Changed stated salary cursor to
24: changed_date <= l_date and commented
25: out nocopy return statements and put in
26: fnd messages and exceptions.
27: 24-AUG-98 JMohapat 115.2 Added los and comb_age_los
28: Procedure to this Package.
29: 08-OCT-98 G Perry 115.3 Corrected error messages.
30: 25-OCT-98 G Perry 115.4 Added in benefits balance type
374: exception
375: --
376: when others then
377: --
378: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
379: fnd_message.set_token('PROC',l_package);
380: fnd_message.set_token('FORMULA',p_formula_id);
381: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
382: fnd_message.raise_error;
375: --
376: when others then
377: --
378: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
379: fnd_message.set_token('PROC',l_package);
380: fnd_message.set_token('FORMULA',p_formula_id);
381: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
382: fnd_message.raise_error;
383: --
376: when others then
377: --
378: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
379: fnd_message.set_token('PROC',l_package);
380: fnd_message.set_token('FORMULA',p_formula_id);
381: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
382: fnd_message.raise_error;
383: --
384: end;
377: --
378: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
379: fnd_message.set_token('PROC',l_package);
380: fnd_message.set_token('FORMULA',p_formula_id);
381: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
382: fnd_message.raise_error;
383: --
384: end;
385: --
378: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
379: fnd_message.set_token('PROC',l_package);
380: fnd_message.set_token('FORMULA',p_formula_id);
381: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
382: fnd_message.raise_error;
383: --
384: end;
385: --
386: elsif p_rule_type = 'DATE' then
394: exception
395: --
396: when others then
397: --
398: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
399: fnd_message.set_token('PROC',l_package);
400: fnd_message.set_token('FORMULA',p_formula_id);
401: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
402: fnd_message.raise_error;
395: --
396: when others then
397: --
398: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
399: fnd_message.set_token('PROC',l_package);
400: fnd_message.set_token('FORMULA',p_formula_id);
401: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
402: fnd_message.raise_error;
403: --
396: when others then
397: --
398: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
399: fnd_message.set_token('PROC',l_package);
400: fnd_message.set_token('FORMULA',p_formula_id);
401: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
402: fnd_message.raise_error;
403: --
404: end;
397: --
398: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
399: fnd_message.set_token('PROC',l_package);
400: fnd_message.set_token('FORMULA',p_formula_id);
401: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
402: fnd_message.raise_error;
403: --
404: end;
405: --
398: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
399: fnd_message.set_token('PROC',l_package);
400: fnd_message.set_token('FORMULA',p_formula_id);
401: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
402: fnd_message.raise_error;
403: --
404: end;
405: --
406: else
781: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
782: end if;
783: --
784: if p_effective_date is null then
785: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
786: fnd_message.set_token('PACKAGE',l_proc);
787: fnd_message.set_token('PARAM','p_effective_date');
788: fnd_message.set_token('PROC','Derived Factors');
789: fnd_message.raise_error;
782: end if;
783: --
784: if p_effective_date is null then
785: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
786: fnd_message.set_token('PACKAGE',l_proc);
787: fnd_message.set_token('PARAM','p_effective_date');
788: fnd_message.set_token('PROC','Derived Factors');
789: fnd_message.raise_error;
790: elsif p_person_id is null then
783: --
784: if p_effective_date is null then
785: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
786: fnd_message.set_token('PACKAGE',l_proc);
787: fnd_message.set_token('PARAM','p_effective_date');
788: fnd_message.set_token('PROC','Derived Factors');
789: fnd_message.raise_error;
790: elsif p_person_id is null then
791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
784: if p_effective_date is null then
785: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
786: fnd_message.set_token('PACKAGE',l_proc);
787: fnd_message.set_token('PARAM','p_effective_date');
788: fnd_message.set_token('PROC','Derived Factors');
789: fnd_message.raise_error;
790: elsif p_person_id is null then
791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
792: fnd_message.set_token('PACKAGE',l_proc);
785: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
786: fnd_message.set_token('PACKAGE',l_proc);
787: fnd_message.set_token('PARAM','p_effective_date');
788: fnd_message.set_token('PROC','Derived Factors');
789: fnd_message.raise_error;
790: elsif p_person_id is null then
791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('PARAM','p_person_id');
787: fnd_message.set_token('PARAM','p_effective_date');
788: fnd_message.set_token('PROC','Derived Factors');
789: fnd_message.raise_error;
790: elsif p_person_id is null then
791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('PARAM','p_person_id');
794: fnd_message.set_token('PROC','Derived Factors');
795: fnd_message.raise_error;
788: fnd_message.set_token('PROC','Derived Factors');
789: fnd_message.raise_error;
790: elsif p_person_id is null then
791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('PARAM','p_person_id');
794: fnd_message.set_token('PROC','Derived Factors');
795: fnd_message.raise_error;
796: elsif p_comp_lvl_fctr_id is null then
789: fnd_message.raise_error;
790: elsif p_person_id is null then
791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('PARAM','p_person_id');
794: fnd_message.set_token('PROC','Derived Factors');
795: fnd_message.raise_error;
796: elsif p_comp_lvl_fctr_id is null then
797: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
790: elsif p_person_id is null then
791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('PARAM','p_person_id');
794: fnd_message.set_token('PROC','Derived Factors');
795: fnd_message.raise_error;
796: elsif p_comp_lvl_fctr_id is null then
797: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
798: fnd_message.set_token('PACKAGE',l_proc);
791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('PARAM','p_person_id');
794: fnd_message.set_token('PROC','Derived Factors');
795: fnd_message.raise_error;
796: elsif p_comp_lvl_fctr_id is null then
797: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
798: fnd_message.set_token('PACKAGE',l_proc);
799: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
793: fnd_message.set_token('PARAM','p_person_id');
794: fnd_message.set_token('PROC','Derived Factors');
795: fnd_message.raise_error;
796: elsif p_comp_lvl_fctr_id is null then
797: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
798: fnd_message.set_token('PACKAGE',l_proc);
799: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
800: fnd_message.set_token('PROC','Derived Factors');
801: fnd_message.raise_error;
794: fnd_message.set_token('PROC','Derived Factors');
795: fnd_message.raise_error;
796: elsif p_comp_lvl_fctr_id is null then
797: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
798: fnd_message.set_token('PACKAGE',l_proc);
799: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
800: fnd_message.set_token('PROC','Derived Factors');
801: fnd_message.raise_error;
802: elsif p_business_group_id is null then
795: fnd_message.raise_error;
796: elsif p_comp_lvl_fctr_id is null then
797: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
798: fnd_message.set_token('PACKAGE',l_proc);
799: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
800: fnd_message.set_token('PROC','Derived Factors');
801: fnd_message.raise_error;
802: elsif p_business_group_id is null then
803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
796: elsif p_comp_lvl_fctr_id is null then
797: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
798: fnd_message.set_token('PACKAGE',l_proc);
799: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
800: fnd_message.set_token('PROC','Derived Factors');
801: fnd_message.raise_error;
802: elsif p_business_group_id is null then
803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
804: fnd_message.set_token('PACKAGE',l_proc);
797: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
798: fnd_message.set_token('PACKAGE',l_proc);
799: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
800: fnd_message.set_token('PROC','Derived Factors');
801: fnd_message.raise_error;
802: elsif p_business_group_id is null then
803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
804: fnd_message.set_token('PACKAGE',l_proc);
805: fnd_message.set_token('PARAM','p_business_group_id');
799: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
800: fnd_message.set_token('PROC','Derived Factors');
801: fnd_message.raise_error;
802: elsif p_business_group_id is null then
803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
804: fnd_message.set_token('PACKAGE',l_proc);
805: fnd_message.set_token('PARAM','p_business_group_id');
806: fnd_message.set_token('PROC','Derived Factors');
807: fnd_message.raise_error;
800: fnd_message.set_token('PROC','Derived Factors');
801: fnd_message.raise_error;
802: elsif p_business_group_id is null then
803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
804: fnd_message.set_token('PACKAGE',l_proc);
805: fnd_message.set_token('PARAM','p_business_group_id');
806: fnd_message.set_token('PROC','Derived Factors');
807: fnd_message.raise_error;
808: end if;
801: fnd_message.raise_error;
802: elsif p_business_group_id is null then
803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
804: fnd_message.set_token('PACKAGE',l_proc);
805: fnd_message.set_token('PARAM','p_business_group_id');
806: fnd_message.set_token('PROC','Derived Factors');
807: fnd_message.raise_error;
808: end if;
809: --
802: elsif p_business_group_id is null then
803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
804: fnd_message.set_token('PACKAGE',l_proc);
805: fnd_message.set_token('PARAM','p_business_group_id');
806: fnd_message.set_token('PROC','Derived Factors');
807: fnd_message.raise_error;
808: end if;
809: --
810: if (p_comp_obj_mode and
803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
804: fnd_message.set_token('PACKAGE',l_proc);
805: fnd_message.set_token('PARAM','p_business_group_id');
806: fnd_message.set_token('PROC','Derived Factors');
807: fnd_message.raise_error;
808: end if;
809: --
810: if (p_comp_obj_mode and
811: p_pl_id is null and
810: if (p_comp_obj_mode and
811: p_pl_id is null and
812: p_oipl_id is null and
813: p_pgm_id is null) then
814: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
815: fnd_message.set_token('PACKAGE',l_proc);
816: fnd_message.set_token('PERSON_ID',p_person_id);
817: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
818: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
811: p_pl_id is null and
812: p_oipl_id is null and
813: p_pgm_id is null) then
814: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
815: fnd_message.set_token('PACKAGE',l_proc);
816: fnd_message.set_token('PERSON_ID',p_person_id);
817: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
818: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
819: fnd_message.raise_error;
812: p_oipl_id is null and
813: p_pgm_id is null) then
814: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
815: fnd_message.set_token('PACKAGE',l_proc);
816: fnd_message.set_token('PERSON_ID',p_person_id);
817: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
818: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
819: fnd_message.raise_error;
820: end if;
813: p_pgm_id is null) then
814: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
815: fnd_message.set_token('PACKAGE',l_proc);
816: fnd_message.set_token('PERSON_ID',p_person_id);
817: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
818: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
819: fnd_message.raise_error;
820: end if;
821: --
814: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
815: fnd_message.set_token('PACKAGE',l_proc);
816: fnd_message.set_token('PERSON_ID',p_person_id);
817: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
818: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
819: fnd_message.raise_error;
820: end if;
821: --
822: -- FONM
815: fnd_message.set_token('PACKAGE',l_proc);
816: fnd_message.set_token('PERSON_ID',p_person_id);
817: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
818: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
819: fnd_message.raise_error;
820: end if;
821: --
822: -- FONM
823: --if ben_manage_life_events.fonm = 'Y' then
851: --
852: fetch c_clf into l_clf;
853: if c_clf%notfound then
854: close c_clf;
855: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
856: fnd_message.set_token('PACKAGE',l_proc);
857: fnd_message.set_token('CURSOR','c_clf');
858: fnd_message.raise_error;
859: end if;
852: fetch c_clf into l_clf;
853: if c_clf%notfound then
854: close c_clf;
855: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
856: fnd_message.set_token('PACKAGE',l_proc);
857: fnd_message.set_token('CURSOR','c_clf');
858: fnd_message.raise_error;
859: end if;
860: --
853: if c_clf%notfound then
854: close c_clf;
855: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
856: fnd_message.set_token('PACKAGE',l_proc);
857: fnd_message.set_token('CURSOR','c_clf');
858: fnd_message.raise_error;
859: end if;
860: --
861: close c_clf;
854: close c_clf;
855: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
856: fnd_message.set_token('PACKAGE',l_proc);
857: fnd_message.set_token('CURSOR','c_clf');
858: fnd_message.raise_error;
859: end if;
860: --
861: close c_clf;
862: --
994: --
995: hr_utility.set_location('l_value :'||l_value,1174);--Bug 14161081
996: if l_value is null or l_value < 0 then --Bug 14161081
997: --
998: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
999: fnd_message.set_token('DATE',l_date);
1000: benutils.write(p_text=> fnd_message.get);
1001: --Start AMN Bug 14161081
1002: ---if date code is
995: hr_utility.set_location('l_value :'||l_value,1174);--Bug 14161081
996: if l_value is null or l_value < 0 then --Bug 14161081
997: --
998: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
999: fnd_message.set_token('DATE',l_date);
1000: benutils.write(p_text=> fnd_message.get);
1001: --Start AMN Bug 14161081
1002: ---if date code is
1003: -- first of year,half year,quarter,month,semi month,previos oct 1
996: if l_value is null or l_value < 0 then --Bug 14161081
997: --
998: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
999: fnd_message.set_token('DATE',l_date);
1000: benutils.write(p_text=> fnd_message.get);
1001: --Start AMN Bug 14161081
1002: ---if date code is
1003: -- first of year,half year,quarter,month,semi month,previos oct 1
1004: -- then take the first salary
1033: --
1034: IF l_value IS NULL or l_value < 0 THEN--Bug 14161081
1035: p_value := 0;--Bug 14161081
1036: --
1037: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
1038: fnd_message.set_token('DATE',p_effective_date);
1039: benutils.write(p_text=> fnd_message.get);
1040: return;
1041: --
1034: IF l_value IS NULL or l_value < 0 THEN--Bug 14161081
1035: p_value := 0;--Bug 14161081
1036: --
1037: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
1038: fnd_message.set_token('DATE',p_effective_date);
1039: benutils.write(p_text=> fnd_message.get);
1040: return;
1041: --
1042: END IF;
1035: p_value := 0;--Bug 14161081
1036: --
1037: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
1038: fnd_message.set_token('DATE',p_effective_date);
1039: benutils.write(p_text=> fnd_message.get);
1040: return;
1041: --
1042: END IF;
1043: --
1052: l_start_date := to_date(l_clf.start_day_mo||nvl(l_clf.start_year,to_char(l_date,'YYYY')),'DDMMYYYY');
1053: l_end_date := to_date(l_clf.end_day_mo||nvl(l_clf.end_year,to_char(l_date,'YYYY')),'DDMMYYYY');
1054: exception
1055: when others then
1056: fnd_message.set_name('BEN','BEN_92603_INVALID_DATE');
1057: fnd_message.raise_error;
1058: end;
1059:
1060: if l_start_date > l_end_date then
1053: l_end_date := to_date(l_clf.end_day_mo||nvl(l_clf.end_year,to_char(l_date,'YYYY')),'DDMMYYYY');
1054: exception
1055: when others then
1056: fnd_message.set_name('BEN','BEN_92603_INVALID_DATE');
1057: fnd_message.raise_error;
1058: end;
1059:
1060: if l_start_date > l_end_date then
1061: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1057: fnd_message.raise_error;
1058: end;
1059:
1060: if l_start_date > l_end_date then
1061: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1062: fnd_message.set_token('PROC',l_proc);
1063: fnd_message.set_token('START_DT',l_start_date);
1064: fnd_message.set_token('END_DT',l_end_date);
1065: fnd_message.raise_error;
1058: end;
1059:
1060: if l_start_date > l_end_date then
1061: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1062: fnd_message.set_token('PROC',l_proc);
1063: fnd_message.set_token('START_DT',l_start_date);
1064: fnd_message.set_token('END_DT',l_end_date);
1065: fnd_message.raise_error;
1066: end if;
1059:
1060: if l_start_date > l_end_date then
1061: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1062: fnd_message.set_token('PROC',l_proc);
1063: fnd_message.set_token('START_DT',l_start_date);
1064: fnd_message.set_token('END_DT',l_end_date);
1065: fnd_message.raise_error;
1066: end if;
1067:
1060: if l_start_date > l_end_date then
1061: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1062: fnd_message.set_token('PROC',l_proc);
1063: fnd_message.set_token('START_DT',l_start_date);
1064: fnd_message.set_token('END_DT',l_end_date);
1065: fnd_message.raise_error;
1066: end if;
1067:
1068: -- 4500760
1061: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1062: fnd_message.set_token('PROC',l_proc);
1063: fnd_message.set_token('START_DT',l_start_date);
1064: fnd_message.set_token('END_DT',l_end_date);
1065: fnd_message.raise_error;
1066: end if;
1067:
1068: -- 4500760
1069: if l_clf.proration_flag = 'Y' then
1101: -- This is temp fix, once iic code is changed to handle no person data
1102: -- or setup not found cases then this error can be un commented again.
1103: --
1104: /*
1105: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');
1106: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
1107: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
1108: fnd_message.raise_error;
1109: */
1102: -- or setup not found cases then this error can be un commented again.
1103: --
1104: /*
1105: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');
1106: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
1107: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
1108: fnd_message.raise_error;
1109: */
1110: benutils.write(p_text=> substr(l_msg_data,1,100));
1103: --
1104: /*
1105: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');
1106: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
1107: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
1108: fnd_message.raise_error;
1109: */
1110: benutils.write(p_text=> substr(l_msg_data,1,100));
1111: l_comp_earned := 0;
1104: /*
1105: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');
1106: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
1107: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
1108: fnd_message.raise_error;
1109: */
1110: benutils.write(p_text=> substr(l_msg_data,1,100));
1111: l_comp_earned := 0;
1112: l_comp_paid := 0;
1233: if nvl(l_opt_typ_cd.opt_typ_cd, 'YYY') ='CWB' then
1234: l_value := 0;
1235: l_salary.proposed_salary := 0;
1236: else
1237: fnd_message.set_name('BEN','BEN_93298_SAL_NOT_DFND');
1238: --Bug 2519393 Message made more clear.
1239: -- start bug # 4185334 -- changed the tokens --
1240: fnd_message.set_token('PARMA','c_stated_salary');
1241: fnd_message.set_token('PARMB',l_proc);
1236: else
1237: fnd_message.set_name('BEN','BEN_93298_SAL_NOT_DFND');
1238: --Bug 2519393 Message made more clear.
1239: -- start bug # 4185334 -- changed the tokens --
1240: fnd_message.set_token('PARMA','c_stated_salary');
1241: fnd_message.set_token('PARMB',l_proc);
1242: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));
1243: fnd_message.set_token('PARM1',p_person_id);
1244: --- end bug # 4185334
1237: fnd_message.set_name('BEN','BEN_93298_SAL_NOT_DFND');
1238: --Bug 2519393 Message made more clear.
1239: -- start bug # 4185334 -- changed the tokens --
1240: fnd_message.set_token('PARMA','c_stated_salary');
1241: fnd_message.set_token('PARMB',l_proc);
1242: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));
1243: fnd_message.set_token('PARM1',p_person_id);
1244: --- end bug # 4185334
1245: /*
1238: --Bug 2519393 Message made more clear.
1239: -- start bug # 4185334 -- changed the tokens --
1240: fnd_message.set_token('PARMA','c_stated_salary');
1241: fnd_message.set_token('PARMB',l_proc);
1242: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));
1243: fnd_message.set_token('PARM1',p_person_id);
1244: --- end bug # 4185334
1245: /*
1246: fnd_message.raise_error;
1239: -- start bug # 4185334 -- changed the tokens --
1240: fnd_message.set_token('PARMA','c_stated_salary');
1241: fnd_message.set_token('PARMB',l_proc);
1242: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));
1243: fnd_message.set_token('PARM1',p_person_id);
1244: --- end bug # 4185334
1245: /*
1246: fnd_message.raise_error;
1247: */
1242: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));
1243: fnd_message.set_token('PARM1',p_person_id);
1244: --- end bug # 4185334
1245: /*
1246: fnd_message.raise_error;
1247: */
1248: --
1249: -- BUG 3315997
1250: --
1260: p_parmc => fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2),
1261: p_parm1 => p_person_id,
1262: p_person_id => p_person_id);
1263: -- end bug # 4185334
1264: benutils.write(p_text=> fnd_message.get);
1265: return;
1266: --
1267: end if;
1268: --
1327: l_value := i.proposed_salary + nvl(l_value,0);
1328: --
1329: else
1330: --
1331: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1332: fnd_message.set_token('PACKAGE',l_proc);
1333: fnd_message.set_token('PERSON_ID',p_person_id);
1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1328: --
1329: else
1330: --
1331: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1332: fnd_message.set_token('PACKAGE',l_proc);
1333: fnd_message.set_token('PERSON_ID',p_person_id);
1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1336: fnd_message.set_token('PGM_ID',p_pgm_id);
1329: else
1330: --
1331: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1332: fnd_message.set_token('PACKAGE',l_proc);
1333: fnd_message.set_token('PERSON_ID',p_person_id);
1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1336: fnd_message.set_token('PGM_ID',p_pgm_id);
1337: fnd_message.set_token('PL_ID',p_pl_id);
1330: --
1331: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1332: fnd_message.set_token('PACKAGE',l_proc);
1333: fnd_message.set_token('PERSON_ID',p_person_id);
1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1336: fnd_message.set_token('PGM_ID',p_pgm_id);
1337: fnd_message.set_token('PL_ID',p_pl_id);
1338: fnd_message.set_token('OIPL_ID',p_oipl_id);
1331: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1332: fnd_message.set_token('PACKAGE',l_proc);
1333: fnd_message.set_token('PERSON_ID',p_person_id);
1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1336: fnd_message.set_token('PGM_ID',p_pgm_id);
1337: fnd_message.set_token('PL_ID',p_pl_id);
1338: fnd_message.set_token('OIPL_ID',p_oipl_id);
1339: fnd_message.raise_error;
1332: fnd_message.set_token('PACKAGE',l_proc);
1333: fnd_message.set_token('PERSON_ID',p_person_id);
1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1336: fnd_message.set_token('PGM_ID',p_pgm_id);
1337: fnd_message.set_token('PL_ID',p_pl_id);
1338: fnd_message.set_token('OIPL_ID',p_oipl_id);
1339: fnd_message.raise_error;
1340: --
1333: fnd_message.set_token('PERSON_ID',p_person_id);
1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1336: fnd_message.set_token('PGM_ID',p_pgm_id);
1337: fnd_message.set_token('PL_ID',p_pl_id);
1338: fnd_message.set_token('OIPL_ID',p_oipl_id);
1339: fnd_message.raise_error;
1340: --
1341: end if;
1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1336: fnd_message.set_token('PGM_ID',p_pgm_id);
1337: fnd_message.set_token('PL_ID',p_pl_id);
1338: fnd_message.set_token('OIPL_ID',p_oipl_id);
1339: fnd_message.raise_error;
1340: --
1341: end if;
1342: --
1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1336: fnd_message.set_token('PGM_ID',p_pgm_id);
1337: fnd_message.set_token('PL_ID',p_pl_id);
1338: fnd_message.set_token('OIPL_ID',p_oipl_id);
1339: fnd_message.raise_error;
1340: --
1341: end if;
1342: --
1343: end if;
1431: --
1432: -- Unknown periodicity, Error out
1433: else
1434: --
1435: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1436: fnd_message.set_token('PACKAGE',l_proc);
1437: fnd_message.set_token('PERSON_ID',p_person_id);
1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1432: -- Unknown periodicity, Error out
1433: else
1434: --
1435: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1436: fnd_message.set_token('PACKAGE',l_proc);
1437: fnd_message.set_token('PERSON_ID',p_person_id);
1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1440: fnd_message.set_token('PGM_ID',p_pgm_id);
1433: else
1434: --
1435: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1436: fnd_message.set_token('PACKAGE',l_proc);
1437: fnd_message.set_token('PERSON_ID',p_person_id);
1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1440: fnd_message.set_token('PGM_ID',p_pgm_id);
1441: fnd_message.set_token('PL_ID',p_pl_id);
1434: --
1435: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1436: fnd_message.set_token('PACKAGE',l_proc);
1437: fnd_message.set_token('PERSON_ID',p_person_id);
1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1440: fnd_message.set_token('PGM_ID',p_pgm_id);
1441: fnd_message.set_token('PL_ID',p_pl_id);
1442: fnd_message.set_token('OIPL_ID',p_oipl_id);
1435: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1436: fnd_message.set_token('PACKAGE',l_proc);
1437: fnd_message.set_token('PERSON_ID',p_person_id);
1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1440: fnd_message.set_token('PGM_ID',p_pgm_id);
1441: fnd_message.set_token('PL_ID',p_pl_id);
1442: fnd_message.set_token('OIPL_ID',p_oipl_id);
1443: fnd_message.raise_error;
1436: fnd_message.set_token('PACKAGE',l_proc);
1437: fnd_message.set_token('PERSON_ID',p_person_id);
1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1440: fnd_message.set_token('PGM_ID',p_pgm_id);
1441: fnd_message.set_token('PL_ID',p_pl_id);
1442: fnd_message.set_token('OIPL_ID',p_oipl_id);
1443: fnd_message.raise_error;
1444: --
1437: fnd_message.set_token('PERSON_ID',p_person_id);
1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1440: fnd_message.set_token('PGM_ID',p_pgm_id);
1441: fnd_message.set_token('PL_ID',p_pl_id);
1442: fnd_message.set_token('OIPL_ID',p_oipl_id);
1443: fnd_message.raise_error;
1444: --
1445: end if;
1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1440: fnd_message.set_token('PGM_ID',p_pgm_id);
1441: fnd_message.set_token('PL_ID',p_pl_id);
1442: fnd_message.set_token('OIPL_ID',p_oipl_id);
1443: fnd_message.raise_error;
1444: --
1445: end if;
1446: --
1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1440: fnd_message.set_token('PGM_ID',p_pgm_id);
1441: fnd_message.set_token('PL_ID',p_pl_id);
1442: fnd_message.set_token('OIPL_ID',p_oipl_id);
1443: fnd_message.raise_error;
1444: --
1445: end if;
1446: --
1447: elsif l_clf.comp_src_cd = 'BALTYP' then
1494: --
1495: end if ;
1496:
1497: if l_value is null then
1498: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
1499: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));
1500: benutils.write(p_text=> fnd_message.get);
1501: return;
1502: end if;
1495: end if ;
1496:
1497: if l_value is null then
1498: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
1499: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));
1500: benutils.write(p_text=> fnd_message.get);
1501: return;
1502: end if;
1503:
1496:
1497: if l_value is null then
1498: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
1499: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));
1500: benutils.write(p_text=> fnd_message.get);
1501: return;
1502: end if;
1503:
1504: --
1569: -- Person does not have a balance, recheck if they have a balance
1570: -- as of the life event occurred date or effective date.
1571: -- Fix for bug 216.
1572: --
1573: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1574: fnd_message.set_token('DATE',l_date);
1575: benutils.write(p_text=> fnd_message.get);
1576: l_value :=
1577: pay_balance_pkg.get_value(l_clf.defined_balance_id,
1570: -- as of the life event occurred date or effective date.
1571: -- Fix for bug 216.
1572: --
1573: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1574: fnd_message.set_token('DATE',l_date);
1575: benutils.write(p_text=> fnd_message.get);
1576: l_value :=
1577: pay_balance_pkg.get_value(l_clf.defined_balance_id,
1578: l_assignment.assignment_id,
1571: -- Fix for bug 216.
1572: --
1573: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1574: fnd_message.set_token('DATE',l_date);
1575: benutils.write(p_text=> fnd_message.get);
1576: l_value :=
1577: pay_balance_pkg.get_value(l_clf.defined_balance_id,
1578: l_assignment.assignment_id,
1579: p_effective_date);
1579: p_effective_date);
1580: --
1581: IF l_value IS NULL THEN
1582: --
1583: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1584: fnd_message.set_token('DATE',p_effective_date);
1585: benutils.write(p_text=> fnd_message.get);
1586: RETURN;
1587: --
1580: --
1581: IF l_value IS NULL THEN
1582: --
1583: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1584: fnd_message.set_token('DATE',p_effective_date);
1585: benutils.write(p_text=> fnd_message.get);
1586: RETURN;
1587: --
1588: END IF;
1581: IF l_value IS NULL THEN
1582: --
1583: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1584: fnd_message.set_token('DATE',p_effective_date);
1585: benutils.write(p_text=> fnd_message.get);
1586: RETURN;
1587: --
1588: END IF;
1589: --
1590: END IF;
1591: --
1592: exception
1593: when others then
1594: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1595: fnd_message.set_token('DATE',p_effective_date);
1596: benutils.write(p_text=> fnd_message.get);
1597: RETURN;
1598: end ;
1591: --
1592: exception
1593: when others then
1594: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1595: fnd_message.set_token('DATE',p_effective_date);
1596: benutils.write(p_text=> fnd_message.get);
1597: RETURN;
1598: end ;
1599:
1592: exception
1593: when others then
1594: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1595: fnd_message.set_token('DATE',p_effective_date);
1596: benutils.write(p_text=> fnd_message.get);
1597: RETURN;
1598: end ;
1599:
1600: End If ; */
1674: --
1675: ben_person_object.get_object(p_bnfts_bal_id => l_clf.bnfts_bal_id,
1676: p_rec => l_bnb_rec);
1677: --
1678: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1679: fnd_message.set_token('NAME',l_bnb_rec.name);
1680: fnd_message.set_token('DATE',l_date);
1681: benutils.write(p_text=> fnd_message.get);
1682: --
1675: ben_person_object.get_object(p_bnfts_bal_id => l_clf.bnfts_bal_id,
1676: p_rec => l_bnb_rec);
1677: --
1678: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1679: fnd_message.set_token('NAME',l_bnb_rec.name);
1680: fnd_message.set_token('DATE',l_date);
1681: benutils.write(p_text=> fnd_message.get);
1682: --
1683: l_date := l_effective_date;
1676: p_rec => l_bnb_rec);
1677: --
1678: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1679: fnd_message.set_token('NAME',l_bnb_rec.name);
1680: fnd_message.set_token('DATE',l_date);
1681: benutils.write(p_text=> fnd_message.get);
1682: --
1683: l_date := l_effective_date;
1684: --
1677: --
1678: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1679: fnd_message.set_token('NAME',l_bnb_rec.name);
1680: fnd_message.set_token('DATE',l_date);
1681: benutils.write(p_text=> fnd_message.get);
1682: --
1683: l_date := l_effective_date;
1684: --
1685: open c_person_balance(l_date);
1699: if nvl(l_opt_typ_cd.opt_typ_cd, 'YYY') ='CWB' then
1700: l_value := 0;
1701: p_value := l_value;
1702: else
1703: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1704: fnd_message.set_token('NAME',l_bnb_rec.name);
1705: fnd_message.set_token('DATE',p_effective_date);
1706: benutils.write(p_text=> fnd_message.get);
1707: end if;
1700: l_value := 0;
1701: p_value := l_value;
1702: else
1703: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1704: fnd_message.set_token('NAME',l_bnb_rec.name);
1705: fnd_message.set_token('DATE',p_effective_date);
1706: benutils.write(p_text=> fnd_message.get);
1707: end if;
1708: RETURN;
1701: p_value := l_value;
1702: else
1703: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1704: fnd_message.set_token('NAME',l_bnb_rec.name);
1705: fnd_message.set_token('DATE',p_effective_date);
1706: benutils.write(p_text=> fnd_message.get);
1707: end if;
1708: RETURN;
1709: --
1702: else
1703: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1704: fnd_message.set_token('NAME',l_bnb_rec.name);
1705: fnd_message.set_token('DATE',p_effective_date);
1706: benutils.write(p_text=> fnd_message.get);
1707: end if;
1708: RETURN;
1709: --
1710: END IF;
1965: --
1966: l_per_dob := p_per_dob;
1967: --
1968: if p_effective_date is null then
1969: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1970: fnd_message.set_token('PACKAGE',l_proc);
1971: fnd_message.set_token('PARAM','p_effective_date');
1972: fnd_message.set_token('PROC','Derived Factors');
1973: fnd_message.raise_error;
1966: l_per_dob := p_per_dob;
1967: --
1968: if p_effective_date is null then
1969: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1970: fnd_message.set_token('PACKAGE',l_proc);
1971: fnd_message.set_token('PARAM','p_effective_date');
1972: fnd_message.set_token('PROC','Derived Factors');
1973: fnd_message.raise_error;
1974: elsif p_person_id is null then
1967: --
1968: if p_effective_date is null then
1969: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1970: fnd_message.set_token('PACKAGE',l_proc);
1971: fnd_message.set_token('PARAM','p_effective_date');
1972: fnd_message.set_token('PROC','Derived Factors');
1973: fnd_message.raise_error;
1974: elsif p_person_id is null then
1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1968: if p_effective_date is null then
1969: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1970: fnd_message.set_token('PACKAGE',l_proc);
1971: fnd_message.set_token('PARAM','p_effective_date');
1972: fnd_message.set_token('PROC','Derived Factors');
1973: fnd_message.raise_error;
1974: elsif p_person_id is null then
1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1976: fnd_message.set_token('PACKAGE',l_proc);
1969: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1970: fnd_message.set_token('PACKAGE',l_proc);
1971: fnd_message.set_token('PARAM','p_effective_date');
1972: fnd_message.set_token('PROC','Derived Factors');
1973: fnd_message.raise_error;
1974: elsif p_person_id is null then
1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1976: fnd_message.set_token('PACKAGE',l_proc);
1977: fnd_message.set_token('PARAM','p_person_id');
1971: fnd_message.set_token('PARAM','p_effective_date');
1972: fnd_message.set_token('PROC','Derived Factors');
1973: fnd_message.raise_error;
1974: elsif p_person_id is null then
1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1976: fnd_message.set_token('PACKAGE',l_proc);
1977: fnd_message.set_token('PARAM','p_person_id');
1978: fnd_message.set_token('PROC','Derived Factors');
1979: fnd_message.raise_error;
1972: fnd_message.set_token('PROC','Derived Factors');
1973: fnd_message.raise_error;
1974: elsif p_person_id is null then
1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1976: fnd_message.set_token('PACKAGE',l_proc);
1977: fnd_message.set_token('PARAM','p_person_id');
1978: fnd_message.set_token('PROC','Derived Factors');
1979: fnd_message.raise_error;
1980: elsif p_age_fctr_id is null then
1973: fnd_message.raise_error;
1974: elsif p_person_id is null then
1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1976: fnd_message.set_token('PACKAGE',l_proc);
1977: fnd_message.set_token('PARAM','p_person_id');
1978: fnd_message.set_token('PROC','Derived Factors');
1979: fnd_message.raise_error;
1980: elsif p_age_fctr_id is null then
1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1974: elsif p_person_id is null then
1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1976: fnd_message.set_token('PACKAGE',l_proc);
1977: fnd_message.set_token('PARAM','p_person_id');
1978: fnd_message.set_token('PROC','Derived Factors');
1979: fnd_message.raise_error;
1980: elsif p_age_fctr_id is null then
1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1982: fnd_message.set_token('PACKAGE',l_proc);
1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1976: fnd_message.set_token('PACKAGE',l_proc);
1977: fnd_message.set_token('PARAM','p_person_id');
1978: fnd_message.set_token('PROC','Derived Factors');
1979: fnd_message.raise_error;
1980: elsif p_age_fctr_id is null then
1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1982: fnd_message.set_token('PACKAGE',l_proc);
1983: fnd_message.set_token('PARAM','p_age_fctr_id');
1977: fnd_message.set_token('PARAM','p_person_id');
1978: fnd_message.set_token('PROC','Derived Factors');
1979: fnd_message.raise_error;
1980: elsif p_age_fctr_id is null then
1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1982: fnd_message.set_token('PACKAGE',l_proc);
1983: fnd_message.set_token('PARAM','p_age_fctr_id');
1984: fnd_message.set_token('PROC','Derived Factors');
1985: fnd_message.raise_error;
1978: fnd_message.set_token('PROC','Derived Factors');
1979: fnd_message.raise_error;
1980: elsif p_age_fctr_id is null then
1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1982: fnd_message.set_token('PACKAGE',l_proc);
1983: fnd_message.set_token('PARAM','p_age_fctr_id');
1984: fnd_message.set_token('PROC','Derived Factors');
1985: fnd_message.raise_error;
1986: elsif p_business_group_id is null then
1979: fnd_message.raise_error;
1980: elsif p_age_fctr_id is null then
1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1982: fnd_message.set_token('PACKAGE',l_proc);
1983: fnd_message.set_token('PARAM','p_age_fctr_id');
1984: fnd_message.set_token('PROC','Derived Factors');
1985: fnd_message.raise_error;
1986: elsif p_business_group_id is null then
1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1980: elsif p_age_fctr_id is null then
1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1982: fnd_message.set_token('PACKAGE',l_proc);
1983: fnd_message.set_token('PARAM','p_age_fctr_id');
1984: fnd_message.set_token('PROC','Derived Factors');
1985: fnd_message.raise_error;
1986: elsif p_business_group_id is null then
1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1988: fnd_message.set_token('PACKAGE',l_proc);
1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1982: fnd_message.set_token('PACKAGE',l_proc);
1983: fnd_message.set_token('PARAM','p_age_fctr_id');
1984: fnd_message.set_token('PROC','Derived Factors');
1985: fnd_message.raise_error;
1986: elsif p_business_group_id is null then
1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1988: fnd_message.set_token('PACKAGE',l_proc);
1989: fnd_message.set_token('PARAM','p_business_group_id');
1983: fnd_message.set_token('PARAM','p_age_fctr_id');
1984: fnd_message.set_token('PROC','Derived Factors');
1985: fnd_message.raise_error;
1986: elsif p_business_group_id is null then
1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1988: fnd_message.set_token('PACKAGE',l_proc);
1989: fnd_message.set_token('PARAM','p_business_group_id');
1990: fnd_message.set_token('PROC','Derived Factors');
1991: fnd_message.raise_error;
1984: fnd_message.set_token('PROC','Derived Factors');
1985: fnd_message.raise_error;
1986: elsif p_business_group_id is null then
1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1988: fnd_message.set_token('PACKAGE',l_proc);
1989: fnd_message.set_token('PARAM','p_business_group_id');
1990: fnd_message.set_token('PROC','Derived Factors');
1991: fnd_message.raise_error;
1992: end if;
1985: fnd_message.raise_error;
1986: elsif p_business_group_id is null then
1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1988: fnd_message.set_token('PACKAGE',l_proc);
1989: fnd_message.set_token('PARAM','p_business_group_id');
1990: fnd_message.set_token('PROC','Derived Factors');
1991: fnd_message.raise_error;
1992: end if;
1993: --
1986: elsif p_business_group_id is null then
1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1988: fnd_message.set_token('PACKAGE',l_proc);
1989: fnd_message.set_token('PARAM','p_business_group_id');
1990: fnd_message.set_token('PROC','Derived Factors');
1991: fnd_message.raise_error;
1992: end if;
1993: --
1994: /*
1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1988: fnd_message.set_token('PACKAGE',l_proc);
1989: fnd_message.set_token('PARAM','p_business_group_id');
1990: fnd_message.set_token('PROC','Derived Factors');
1991: fnd_message.raise_error;
1992: end if;
1993: --
1994: /*
1995: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1992: end if;
1993: --
1994: /*
1995: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1996: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1997: fnd_message.set_token('PACKAGE',l_proc);
1998: fnd_message.set_token('PERSON_ID',p_person_id);
1999: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2000: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
1993: --
1994: /*
1995: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1996: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1997: fnd_message.set_token('PACKAGE',l_proc);
1998: fnd_message.set_token('PERSON_ID',p_person_id);
1999: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2000: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2001: fnd_message.raise_error;
1994: /*
1995: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1996: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1997: fnd_message.set_token('PACKAGE',l_proc);
1998: fnd_message.set_token('PERSON_ID',p_person_id);
1999: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2000: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2001: fnd_message.raise_error;
2002: end if;
1995: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1996: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1997: fnd_message.set_token('PACKAGE',l_proc);
1998: fnd_message.set_token('PERSON_ID',p_person_id);
1999: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2000: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2001: fnd_message.raise_error;
2002: end if;
2003: */
1996: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1997: fnd_message.set_token('PACKAGE',l_proc);
1998: fnd_message.set_token('PERSON_ID',p_person_id);
1999: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2000: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2001: fnd_message.raise_error;
2002: end if;
2003: */
2004: --
1997: fnd_message.set_token('PACKAGE',l_proc);
1998: fnd_message.set_token('PERSON_ID',p_person_id);
1999: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2000: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2001: fnd_message.raise_error;
2002: end if;
2003: */
2004: --
2005: -- We need to drive off the correct person id when we are coming in from
2041: fetch c_agf into l_agf;
2042: --
2043: if c_agf%notfound then
2044: close c_agf;
2045: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2046: fnd_message.set_token('PACKAGE',l_proc);
2047: fnd_message.set_token('CURSOR','c_agf');
2048: fnd_message.raise_error;
2049: end if;
2042: --
2043: if c_agf%notfound then
2044: close c_agf;
2045: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2046: fnd_message.set_token('PACKAGE',l_proc);
2047: fnd_message.set_token('CURSOR','c_agf');
2048: fnd_message.raise_error;
2049: end if;
2050: close c_agf;
2043: if c_agf%notfound then
2044: close c_agf;
2045: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2046: fnd_message.set_token('PACKAGE',l_proc);
2047: fnd_message.set_token('CURSOR','c_agf');
2048: fnd_message.raise_error;
2049: end if;
2050: close c_agf;
2051: --
2044: close c_agf;
2045: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2046: fnd_message.set_token('PACKAGE',l_proc);
2047: fnd_message.set_token('CURSOR','c_agf');
2048: fnd_message.raise_error;
2049: end if;
2050: close c_agf;
2051: --
2052: -- hr_utility.set_location('l_agf.age_to_use_cd -> '||l_agf.age_to_use_cd,511);
2463: if p_effective_date is null then
2464: if g_debug then
2465: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2466: end if;
2467: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2468: fnd_message.set_token('PACKAGE',l_proc);
2469: fnd_message.set_token('PARAM','p_effective_date');
2470: fnd_message.set_token('PROC','Derived Factors');
2471: fnd_message.raise_error;
2464: if g_debug then
2465: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2466: end if;
2467: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2468: fnd_message.set_token('PACKAGE',l_proc);
2469: fnd_message.set_token('PARAM','p_effective_date');
2470: fnd_message.set_token('PROC','Derived Factors');
2471: fnd_message.raise_error;
2472: elsif p_person_id is null then
2465: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2466: end if;
2467: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2468: fnd_message.set_token('PACKAGE',l_proc);
2469: fnd_message.set_token('PARAM','p_effective_date');
2470: fnd_message.set_token('PROC','Derived Factors');
2471: fnd_message.raise_error;
2472: elsif p_person_id is null then
2473: if g_debug then
2466: end if;
2467: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2468: fnd_message.set_token('PACKAGE',l_proc);
2469: fnd_message.set_token('PARAM','p_effective_date');
2470: fnd_message.set_token('PROC','Derived Factors');
2471: fnd_message.raise_error;
2472: elsif p_person_id is null then
2473: if g_debug then
2474: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2467: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2468: fnd_message.set_token('PACKAGE',l_proc);
2469: fnd_message.set_token('PARAM','p_effective_date');
2470: fnd_message.set_token('PROC','Derived Factors');
2471: fnd_message.raise_error;
2472: elsif p_person_id is null then
2473: if g_debug then
2474: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2475: end if;
2472: elsif p_person_id is null then
2473: if g_debug then
2474: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2475: end if;
2476: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2477: fnd_message.set_token('PACKAGE',l_proc);
2478: fnd_message.set_token('PARAM','p_person_id');
2479: fnd_message.set_token('PROC','Derived Factors');
2480: fnd_message.raise_error;
2473: if g_debug then
2474: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2475: end if;
2476: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2477: fnd_message.set_token('PACKAGE',l_proc);
2478: fnd_message.set_token('PARAM','p_person_id');
2479: fnd_message.set_token('PROC','Derived Factors');
2480: fnd_message.raise_error;
2481: elsif p_los_fctr_id is null then
2474: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2475: end if;
2476: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2477: fnd_message.set_token('PACKAGE',l_proc);
2478: fnd_message.set_token('PARAM','p_person_id');
2479: fnd_message.set_token('PROC','Derived Factors');
2480: fnd_message.raise_error;
2481: elsif p_los_fctr_id is null then
2482: if g_debug then
2475: end if;
2476: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2477: fnd_message.set_token('PACKAGE',l_proc);
2478: fnd_message.set_token('PARAM','p_person_id');
2479: fnd_message.set_token('PROC','Derived Factors');
2480: fnd_message.raise_error;
2481: elsif p_los_fctr_id is null then
2482: if g_debug then
2483: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2476: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2477: fnd_message.set_token('PACKAGE',l_proc);
2478: fnd_message.set_token('PARAM','p_person_id');
2479: fnd_message.set_token('PROC','Derived Factors');
2480: fnd_message.raise_error;
2481: elsif p_los_fctr_id is null then
2482: if g_debug then
2483: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2484: end if;
2481: elsif p_los_fctr_id is null then
2482: if g_debug then
2483: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2484: end if;
2485: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2486: fnd_message.set_token('PACKAGE',l_proc);
2487: fnd_message.set_token('PARAM','p_los_fctr_id');
2488: fnd_message.set_token('PROC','Derived Factors');
2489: fnd_message.raise_error;
2482: if g_debug then
2483: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2484: end if;
2485: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2486: fnd_message.set_token('PACKAGE',l_proc);
2487: fnd_message.set_token('PARAM','p_los_fctr_id');
2488: fnd_message.set_token('PROC','Derived Factors');
2489: fnd_message.raise_error;
2490: elsif p_business_group_id is null then
2483: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2484: end if;
2485: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2486: fnd_message.set_token('PACKAGE',l_proc);
2487: fnd_message.set_token('PARAM','p_los_fctr_id');
2488: fnd_message.set_token('PROC','Derived Factors');
2489: fnd_message.raise_error;
2490: elsif p_business_group_id is null then
2491: if g_debug then
2484: end if;
2485: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2486: fnd_message.set_token('PACKAGE',l_proc);
2487: fnd_message.set_token('PARAM','p_los_fctr_id');
2488: fnd_message.set_token('PROC','Derived Factors');
2489: fnd_message.raise_error;
2490: elsif p_business_group_id is null then
2491: if g_debug then
2492: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2485: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2486: fnd_message.set_token('PACKAGE',l_proc);
2487: fnd_message.set_token('PARAM','p_los_fctr_id');
2488: fnd_message.set_token('PROC','Derived Factors');
2489: fnd_message.raise_error;
2490: elsif p_business_group_id is null then
2491: if g_debug then
2492: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2493: end if;
2490: elsif p_business_group_id is null then
2491: if g_debug then
2492: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2493: end if;
2494: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2495: fnd_message.set_token('PACKAGE',l_proc);
2496: fnd_message.set_token('PARAM','p_business_group_id');
2497: fnd_message.set_token('PROC','Derived Factors');
2498: fnd_message.raise_error;
2491: if g_debug then
2492: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2493: end if;
2494: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2495: fnd_message.set_token('PACKAGE',l_proc);
2496: fnd_message.set_token('PARAM','p_business_group_id');
2497: fnd_message.set_token('PROC','Derived Factors');
2498: fnd_message.raise_error;
2499: end if;
2492: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2493: end if;
2494: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2495: fnd_message.set_token('PACKAGE',l_proc);
2496: fnd_message.set_token('PARAM','p_business_group_id');
2497: fnd_message.set_token('PROC','Derived Factors');
2498: fnd_message.raise_error;
2499: end if;
2500: --
2493: end if;
2494: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2495: fnd_message.set_token('PACKAGE',l_proc);
2496: fnd_message.set_token('PARAM','p_business_group_id');
2497: fnd_message.set_token('PROC','Derived Factors');
2498: fnd_message.raise_error;
2499: end if;
2500: --
2501: /*
2494: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2495: fnd_message.set_token('PACKAGE',l_proc);
2496: fnd_message.set_token('PARAM','p_business_group_id');
2497: fnd_message.set_token('PROC','Derived Factors');
2498: fnd_message.raise_error;
2499: end if;
2500: --
2501: /*
2502: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
2502: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
2503: if g_debug then
2504: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);
2505: end if;
2506: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2507: fnd_message.set_token('PACKAGE',l_proc);
2508: fnd_message.set_token('PERSON_ID',p_person_id);
2509: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2510: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2503: if g_debug then
2504: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);
2505: end if;
2506: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2507: fnd_message.set_token('PACKAGE',l_proc);
2508: fnd_message.set_token('PERSON_ID',p_person_id);
2509: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2510: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2511: fnd_message.raise_error;
2504: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);
2505: end if;
2506: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2507: fnd_message.set_token('PACKAGE',l_proc);
2508: fnd_message.set_token('PERSON_ID',p_person_id);
2509: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2510: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2511: fnd_message.raise_error;
2512: end if;
2505: end if;
2506: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2507: fnd_message.set_token('PACKAGE',l_proc);
2508: fnd_message.set_token('PERSON_ID',p_person_id);
2509: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2510: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2511: fnd_message.raise_error;
2512: end if;
2513: */
2506: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2507: fnd_message.set_token('PACKAGE',l_proc);
2508: fnd_message.set_token('PERSON_ID',p_person_id);
2509: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2510: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2511: fnd_message.raise_error;
2512: end if;
2513: */
2514:
2507: fnd_message.set_token('PACKAGE',l_proc);
2508: fnd_message.set_token('PERSON_ID',p_person_id);
2509: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2510: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2511: fnd_message.raise_error;
2512: end if;
2513: */
2514:
2515:
2540: close c_lsf;
2541: if g_debug then
2542: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);
2543: end if;
2544: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2545: fnd_message.set_token('PACKAGE',l_proc);
2546: fnd_message.set_token('CURSOR','c_lsf');
2547: fnd_message.raise_error;
2548: end if;
2541: if g_debug then
2542: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);
2543: end if;
2544: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2545: fnd_message.set_token('PACKAGE',l_proc);
2546: fnd_message.set_token('CURSOR','c_lsf');
2547: fnd_message.raise_error;
2548: end if;
2549: close c_lsf;
2542: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);
2543: end if;
2544: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2545: fnd_message.set_token('PACKAGE',l_proc);
2546: fnd_message.set_token('CURSOR','c_lsf');
2547: fnd_message.raise_error;
2548: end if;
2549: close c_lsf;
2550:
2543: end if;
2544: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2545: fnd_message.set_token('PACKAGE',l_proc);
2546: fnd_message.set_token('CURSOR','c_lsf');
2547: fnd_message.raise_error;
2548: end if;
2549: close c_lsf;
2550:
2551: ben_determine_date.main
2574: close c_person;
2575: if g_debug then
2576: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);
2577: end if;
2578: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2579: fnd_message.set_token('PACKAGE',l_proc);
2580: fnd_message.set_token('CURSOR','c_person');
2581: fnd_message.raise_error;
2582: end if;
2575: if g_debug then
2576: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);
2577: end if;
2578: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2579: fnd_message.set_token('PACKAGE',l_proc);
2580: fnd_message.set_token('CURSOR','c_person');
2581: fnd_message.raise_error;
2582: end if;
2583: close c_person;
2576: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);
2577: end if;
2578: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2579: fnd_message.set_token('PACKAGE',l_proc);
2580: fnd_message.set_token('CURSOR','c_person');
2581: fnd_message.raise_error;
2582: end if;
2583: close c_person;
2584: --
2577: end if;
2578: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2579: fnd_message.set_token('PACKAGE',l_proc);
2580: fnd_message.set_token('CURSOR','c_person');
2581: fnd_message.raise_error;
2582: end if;
2583: close c_person;
2584: --
2585: open c_person_extra;
2687: else
2688: if g_debug then
2689: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);
2690: end if;
2691: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2692: fnd_message.set_token('PROC',l_proc);
2693: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);
2694: raise ben_manage_life_events.g_record_error;
2695: end if;
2688: if g_debug then
2689: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);
2690: end if;
2691: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2692: fnd_message.set_token('PROC',l_proc);
2693: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);
2694: raise ben_manage_life_events.g_record_error;
2695: end if;
2696:
2689: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);
2690: end if;
2691: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2692: fnd_message.set_token('PROC',l_proc);
2693: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);
2694: raise ben_manage_life_events.g_record_error;
2695: end if;
2696:
2697: p_start_date := l_start_date;
2805: fetch c_cla_elig1 into l_cla_elig1;
2806: if c_cla_elig1%notfound then
2807: --
2808: close c_cla_elig1;
2809: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2810: fnd_message.set_token('PACKAGE',l_proc);
2811: fnd_message.set_token('CURSOR','c_cla_elig1');
2812: fnd_message.raise_error;
2813: --
2806: if c_cla_elig1%notfound then
2807: --
2808: close c_cla_elig1;
2809: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2810: fnd_message.set_token('PACKAGE',l_proc);
2811: fnd_message.set_token('CURSOR','c_cla_elig1');
2812: fnd_message.raise_error;
2813: --
2814: end if;
2807: --
2808: close c_cla_elig1;
2809: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2810: fnd_message.set_token('PACKAGE',l_proc);
2811: fnd_message.set_token('CURSOR','c_cla_elig1');
2812: fnd_message.raise_error;
2813: --
2814: end if;
2815: --
2808: close c_cla_elig1;
2809: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2810: fnd_message.set_token('PACKAGE',l_proc);
2811: fnd_message.set_token('CURSOR','c_cla_elig1');
2812: fnd_message.raise_error;
2813: --
2814: end if;
2815: --
2816: close c_cla_elig1;
2954: fetch c_hwf into l_hwf;
2955: --
2956: if c_hwf%notfound then
2957: close c_hwf;
2958: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2959: fnd_message.set_token('PACKAGE',l_package);
2960: fnd_message.set_token('CURSOR','c_hwf');
2961: fnd_message.raise_error;
2962: end if;
2955: --
2956: if c_hwf%notfound then
2957: close c_hwf;
2958: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2959: fnd_message.set_token('PACKAGE',l_package);
2960: fnd_message.set_token('CURSOR','c_hwf');
2961: fnd_message.raise_error;
2962: end if;
2963: close c_hwf;
2956: if c_hwf%notfound then
2957: close c_hwf;
2958: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2959: fnd_message.set_token('PACKAGE',l_package);
2960: fnd_message.set_token('CURSOR','c_hwf');
2961: fnd_message.raise_error;
2962: end if;
2963: close c_hwf;
2964: --
2957: close c_hwf;
2958: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2959: fnd_message.set_token('PACKAGE',l_package);
2960: fnd_message.set_token('CURSOR','c_hwf');
2961: fnd_message.raise_error;
2962: end if;
2963: close c_hwf;
2964: --
2965: -- Steps to perform process
3049: --
3050: ben_person_object.get_object(p_bnfts_bal_id=> l_hwf.bnfts_bal_id
3051: ,p_rec => l_bnb_rec);
3052: --
3053: fnd_message.set_name('BEN'
3054: ,'BEN_92317_PER_BALANCE_NULL');
3055: fnd_message.set_token('NAME'
3056: ,l_bnb_rec.name);
3057: fnd_message.set_token('DATE'
3051: ,p_rec => l_bnb_rec);
3052: --
3053: fnd_message.set_name('BEN'
3054: ,'BEN_92317_PER_BALANCE_NULL');
3055: fnd_message.set_token('NAME'
3056: ,l_bnb_rec.name);
3057: fnd_message.set_token('DATE'
3058: ,l_start_date);
3059: benutils.write(p_text=> fnd_message.get);
3053: fnd_message.set_name('BEN'
3054: ,'BEN_92317_PER_BALANCE_NULL');
3055: fnd_message.set_token('NAME'
3056: ,l_bnb_rec.name);
3057: fnd_message.set_token('DATE'
3058: ,l_start_date);
3059: benutils.write(p_text=> fnd_message.get);
3060: --
3061: ben_person_object.get_object(p_person_id=> p_person_id
3055: fnd_message.set_token('NAME'
3056: ,l_bnb_rec.name);
3057: fnd_message.set_token('DATE'
3058: ,l_start_date);
3059: benutils.write(p_text=> fnd_message.get);
3060: --
3061: ben_person_object.get_object(p_person_id=> p_person_id
3062: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
3063: ,p_effective_date)
3070: end if;
3071: --
3072: IF l_result IS NULL THEN
3073: --
3074: fnd_message.set_name('BEN'
3075: ,'BEN_92317_PER_BALANCE_NULL');
3076: fnd_message.set_token('NAME'
3077: ,l_bnb_rec.name);
3078: fnd_message.set_token('DATE'
3072: IF l_result IS NULL THEN
3073: --
3074: fnd_message.set_name('BEN'
3075: ,'BEN_92317_PER_BALANCE_NULL');
3076: fnd_message.set_token('NAME'
3077: ,l_bnb_rec.name);
3078: fnd_message.set_token('DATE'
3079: ,NVL(p_lf_evt_ocrd_dt
3080: ,p_effective_date));
3074: fnd_message.set_name('BEN'
3075: ,'BEN_92317_PER_BALANCE_NULL');
3076: fnd_message.set_token('NAME'
3077: ,l_bnb_rec.name);
3078: fnd_message.set_token('DATE'
3079: ,NVL(p_lf_evt_ocrd_dt
3080: ,p_effective_date));
3081: benutils.write(p_text=> fnd_message.get);
3082: RETURN;
3077: ,l_bnb_rec.name);
3078: fnd_message.set_token('DATE'
3079: ,NVL(p_lf_evt_ocrd_dt
3080: ,p_effective_date));
3081: benutils.write(p_text=> fnd_message.get);
3082: RETURN;
3083: --
3084: END IF;
3085: --
3155: -- Person does not have a balance, recheck if they have a balance
3156: -- as of the life event occurred date or effective date.
3157: -- Fix for bug 216.
3158: --
3159: fnd_message.set_name('BEN'
3160: ,'BEN_92318_BEN_BALANCE_NULL');
3161: fnd_message.set_token('DATE'
3162: ,l_start_date);
3163: benutils.write(p_text=> fnd_message.get);
3157: -- Fix for bug 216.
3158: --
3159: fnd_message.set_name('BEN'
3160: ,'BEN_92318_BEN_BALANCE_NULL');
3161: fnd_message.set_token('DATE'
3162: ,l_start_date);
3163: benutils.write(p_text=> fnd_message.get);
3164: --
3165: l_result :=
3159: fnd_message.set_name('BEN'
3160: ,'BEN_92318_BEN_BALANCE_NULL');
3161: fnd_message.set_token('DATE'
3162: ,l_start_date);
3163: benutils.write(p_text=> fnd_message.get);
3164: --
3165: l_result :=
3166: pay_balance_pkg.get_value(l_hwf.defined_balance_id
3167: ,l_assignment.assignment_id
3169: );
3170: --
3171: IF l_result IS NULL THEN
3172: --
3173: fnd_message.set_name('BEN'
3174: ,'BEN_92318_BEN_BALANCE_NULL');
3175: fnd_message.set_token('DATE'
3176: , l_effective_date);
3177: benutils.write(p_text=> fnd_message.get);
3171: IF l_result IS NULL THEN
3172: --
3173: fnd_message.set_name('BEN'
3174: ,'BEN_92318_BEN_BALANCE_NULL');
3175: fnd_message.set_token('DATE'
3176: , l_effective_date);
3177: benutils.write(p_text=> fnd_message.get);
3178: RETURN ;
3179: --
3173: fnd_message.set_name('BEN'
3174: ,'BEN_92318_BEN_BALANCE_NULL');
3175: fnd_message.set_token('DATE'
3176: , l_effective_date);
3177: benutils.write(p_text=> fnd_message.get);
3178: RETURN ;
3179: --
3180: END IF;
3181: --
3262: fetch c_pff into l_pff;
3263: --
3264: if c_pff%notfound then
3265: close c_pff;
3266: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
3267: fnd_message.set_token('PACKAGE',l_package);
3268: fnd_message.set_token('CURSOR','c_pff');
3269: fnd_message.raise_error;
3270: end if;
3263: --
3264: if c_pff%notfound then
3265: close c_pff;
3266: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
3267: fnd_message.set_token('PACKAGE',l_package);
3268: fnd_message.set_token('CURSOR','c_pff');
3269: fnd_message.raise_error;
3270: end if;
3271: close c_pff;
3264: if c_pff%notfound then
3265: close c_pff;
3266: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
3267: fnd_message.set_token('PACKAGE',l_package);
3268: fnd_message.set_token('CURSOR','c_pff');
3269: fnd_message.raise_error;
3270: end if;
3271: close c_pff;
3272:
3265: close c_pff;
3266: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
3267: fnd_message.set_token('PACKAGE',l_package);
3268: fnd_message.set_token('CURSOR','c_pff');
3269: fnd_message.raise_error;
3270: end if;
3271: close c_pff;
3272:
3273: if p_assignment_id is null then