DBA Data[Home] [Help]

APPS.BEN_DERIVE_FACTORS dependencies on FND_MESSAGE

Line 26: fnd messages and exceptions.

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

Line 378: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

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;

Line 379: fnd_message.set_token('PROC',l_package);

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: --

Line 380: fnd_message.set_token('FORMULA',p_formula_id);

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;

Line 381: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);

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: --

Line 382: fnd_message.raise_error;

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

Line 398: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

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;

Line 399: fnd_message.set_token('PROC',l_package);

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: --

Line 400: fnd_message.set_token('FORMULA',p_formula_id);

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;

Line 401: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);

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: --

Line 402: fnd_message.raise_error;

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

Line 785: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 786: fnd_message.set_token('PACKAGE',l_proc);

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

Line 787: fnd_message.set_token('PARAM','p_effective_date');

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');

Line 788: fnd_message.set_token('PROC','Derived Factors');

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);

Line 789: fnd_message.raise_error;

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');

Line 791: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 792: fnd_message.set_token('PACKAGE',l_proc);

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

Line 793: fnd_message.set_token('PARAM','p_person_id');

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');

Line 794: fnd_message.set_token('PROC','Derived Factors');

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);

Line 795: fnd_message.raise_error;

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');

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

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;

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

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

Line 799: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');

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');

Line 800: fnd_message.set_token('PROC','Derived Factors');

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);

Line 801: fnd_message.raise_error;

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');

Line 803: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 804: fnd_message.set_token('PACKAGE',l_proc);

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;

Line 805: fnd_message.set_token('PARAM','p_business_group_id');

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: --

Line 806: fnd_message.set_token('PROC','Derived Factors');

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

Line 807: fnd_message.raise_error;

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

Line 814: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');

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);

Line 815: fnd_message.set_token('PACKAGE',l_proc);

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;

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

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;

Line 817: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);

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: --

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

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

Line 819: fnd_message.raise_error;

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

Line 855: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');

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;

Line 856: fnd_message.set_token('PACKAGE',l_proc);

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: --

Line 857: fnd_message.set_token('CURSOR','c_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: --
861: close c_clf;

Line 858: fnd_message.raise_error;

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: --

Line 998: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');

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

Line 999: fnd_message.set_token('DATE',l_date);

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

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

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

Line 1037: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');

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: --

Line 1038: fnd_message.set_token('DATE',p_effective_date);

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;

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

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: --

Line 1056: fnd_message.set_name('BEN','BEN_92603_INVALID_DATE');

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

Line 1057: fnd_message.raise_error;

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');

Line 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;

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

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;

Line 1063: fnd_message.set_token('START_DT',l_start_date);

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:

Line 1064: fnd_message.set_token('END_DT',l_end_date);

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

Line 1065: fnd_message.raise_error;

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

Line 1105: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');

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: */

Line 1106: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');

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));

Line 1107: fnd_message.set_token('MESSAGE',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;

Line 1108: fnd_message.raise_error;

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;

Line 1237: fnd_message.set_name('BEN','BEN_93298_SAL_NOT_DFND');

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);

Line 1240: fnd_message.set_token('PARMA','c_stated_salary');

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

Line 1241: fnd_message.set_token('PARMB',l_proc);

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: /*

Line 1242: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));

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;

Line 1243: fnd_message.set_token('PARM1',p_person_id);

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: */

Line 1246: fnd_message.raise_error;

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: --

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

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: --

Line 1331: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');

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);

Line 1332: fnd_message.set_token('PACKAGE',l_proc);

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);

Line 1333: fnd_message.set_token('PERSON_ID',p_person_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);

Line 1334: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_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);

Line 1335: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_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;

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

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: --

Line 1337: fnd_message.set_token('PL_ID',p_pl_id);

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;

Line 1338: fnd_message.set_token('OIPL_ID',p_oipl_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;
1342: --

Line 1339: fnd_message.raise_error;

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;

Line 1435: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');

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);

Line 1436: fnd_message.set_token('PACKAGE',l_proc);

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);

Line 1437: fnd_message.set_token('PERSON_ID',p_person_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);

Line 1438: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_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);

Line 1439: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_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;

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

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: --

Line 1441: fnd_message.set_token('PL_ID',p_pl_id);

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;

Line 1442: fnd_message.set_token('OIPL_ID',p_oipl_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;
1446: --

Line 1443: fnd_message.raise_error;

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

Line 1498: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');

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;

Line 1499: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));

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:

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

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: --

Line 1573: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');

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,

Line 1574: fnd_message.set_token('DATE',l_date);

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,

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

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);

Line 1583: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');

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: --

Line 1584: fnd_message.set_token('DATE',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: --
1588: END IF;

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

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: --

Line 1594: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');

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 ;

Line 1595: fnd_message.set_token('DATE',p_effective_date);

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:

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

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 ; */

Line 1678: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');

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: --

Line 1679: fnd_message.set_token('NAME',l_bnb_rec.name);

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;

Line 1680: fnd_message.set_token('DATE',l_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: --

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

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);

Line 1703: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');

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;

Line 1704: fnd_message.set_token('NAME',l_bnb_rec.name);

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;

Line 1705: fnd_message.set_token('DATE',p_effective_date);

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: --

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

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;

Line 1969: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 1970: fnd_message.set_token('PACKAGE',l_proc);

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

Line 1971: fnd_message.set_token('PARAM','p_effective_date');

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');

Line 1972: fnd_message.set_token('PROC','Derived Factors');

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);

Line 1973: fnd_message.raise_error;

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');

Line 1975: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 1976: fnd_message.set_token('PACKAGE',l_proc);

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

Line 1977: fnd_message.set_token('PARAM','p_person_id');

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');

Line 1978: fnd_message.set_token('PROC','Derived Factors');

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);

Line 1979: fnd_message.raise_error;

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');

Line 1981: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 1982: fnd_message.set_token('PACKAGE',l_proc);

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

Line 1983: fnd_message.set_token('PARAM','p_age_fctr_id');

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');

Line 1984: fnd_message.set_token('PROC','Derived Factors');

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);

Line 1985: fnd_message.raise_error;

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');

Line 1987: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 1988: fnd_message.set_token('PACKAGE',l_proc);

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;

Line 1989: fnd_message.set_token('PARAM','p_business_group_id');

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: --

Line 1990: fnd_message.set_token('PROC','Derived Factors');

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: /*

Line 1991: fnd_message.raise_error;

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

Line 1996: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');

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);

Line 1997: fnd_message.set_token('PACKAGE',l_proc);

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;

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

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;

Line 1999: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);

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: */

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

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: --

Line 2001: fnd_message.raise_error;

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

Line 2045: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');

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;

Line 2046: fnd_message.set_token('PACKAGE',l_proc);

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;

Line 2047: fnd_message.set_token('CURSOR','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: --

Line 2048: fnd_message.raise_error;

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);

Line 2467: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 2468: fnd_message.set_token('PACKAGE',l_proc);

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

Line 2469: fnd_message.set_token('PARAM','p_effective_date');

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

Line 2470: fnd_message.set_token('PROC','Derived Factors');

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);

Line 2471: fnd_message.raise_error;

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;

Line 2476: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 2477: fnd_message.set_token('PACKAGE',l_proc);

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

Line 2478: fnd_message.set_token('PARAM','p_person_id');

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

Line 2479: fnd_message.set_token('PROC','Derived Factors');

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);

Line 2480: fnd_message.raise_error;

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;

Line 2485: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 2486: fnd_message.set_token('PACKAGE',l_proc);

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

Line 2487: fnd_message.set_token('PARAM','p_los_fctr_id');

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

Line 2488: fnd_message.set_token('PROC','Derived Factors');

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);

Line 2489: fnd_message.raise_error;

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;

Line 2494: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 2495: fnd_message.set_token('PACKAGE',l_proc);

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;

Line 2496: fnd_message.set_token('PARAM','p_business_group_id');

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: --

Line 2497: fnd_message.set_token('PROC','Derived Factors');

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: /*

Line 2498: fnd_message.raise_error;

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

Line 2506: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');

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);

Line 2507: fnd_message.set_token('PACKAGE',l_proc);

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;

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

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;

Line 2509: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);

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: */

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

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:

Line 2511: fnd_message.raise_error;

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:

Line 2544: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');

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;

Line 2545: fnd_message.set_token('PACKAGE',l_proc);

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;

Line 2546: fnd_message.set_token('CURSOR','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:

Line 2547: fnd_message.raise_error;

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

Line 2578: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');

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;

Line 2579: fnd_message.set_token('PACKAGE',l_proc);

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;

Line 2580: fnd_message.set_token('CURSOR','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: --

Line 2581: fnd_message.raise_error;

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;

Line 2691: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');

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;

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

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:

Line 2693: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);

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;

Line 2809: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');

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: --

Line 2810: fnd_message.set_token('PACKAGE',l_proc);

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;

Line 2811: fnd_message.set_token('CURSOR','c_cla_elig1');

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: --

Line 2812: fnd_message.raise_error;

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;

Line 2958: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');

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;

Line 2959: fnd_message.set_token('PACKAGE',l_package);

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;

Line 2960: fnd_message.set_token('CURSOR','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: --

Line 2961: fnd_message.raise_error;

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

Line 3053: fnd_message.set_name('BEN'

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'

Line 3055: fnd_message.set_token('NAME'

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);

Line 3057: fnd_message.set_token('DATE'

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

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

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)

Line 3074: fnd_message.set_name('BEN'

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'

Line 3076: fnd_message.set_token('NAME'

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));

Line 3078: fnd_message.set_token('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;

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

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: --

Line 3159: fnd_message.set_name('BEN'

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);

Line 3161: fnd_message.set_token('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);
3164: --
3165: l_result :=

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

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

Line 3173: fnd_message.set_name('BEN'

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);

Line 3175: fnd_message.set_token('DATE'

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: --

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

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: --

Line 3266: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');

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;

Line 3267: fnd_message.set_token('PACKAGE',l_package);

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;

Line 3268: fnd_message.set_token('CURSOR','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:

Line 3269: fnd_message.raise_error;

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