eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 363: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

359: exception
360: --
361: when others then
362: --
363: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
364: fnd_message.set_token('PROC',l_package);
365: fnd_message.set_token('FORMULA',p_formula_id);
366: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
367: fnd_message.raise_error;

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

360: --
361: when others then
362: --
363: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
364: fnd_message.set_token('PROC',l_package);
365: fnd_message.set_token('FORMULA',p_formula_id);
366: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
367: fnd_message.raise_error;
368: --

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

361: when others then
362: --
363: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
364: fnd_message.set_token('PROC',l_package);
365: fnd_message.set_token('FORMULA',p_formula_id);
366: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
367: fnd_message.raise_error;
368: --
369: end;

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

362: --
363: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
364: fnd_message.set_token('PROC',l_package);
365: fnd_message.set_token('FORMULA',p_formula_id);
366: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
367: fnd_message.raise_error;
368: --
369: end;
370: --

Line 367: fnd_message.raise_error;

363: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
364: fnd_message.set_token('PROC',l_package);
365: fnd_message.set_token('FORMULA',p_formula_id);
366: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
367: fnd_message.raise_error;
368: --
369: end;
370: --
371: elsif p_rule_type = 'DATE' then

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

379: exception
380: --
381: when others then
382: --
383: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
384: fnd_message.set_token('PROC',l_package);
385: fnd_message.set_token('FORMULA',p_formula_id);
386: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
387: fnd_message.raise_error;

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

380: --
381: when others then
382: --
383: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
384: fnd_message.set_token('PROC',l_package);
385: fnd_message.set_token('FORMULA',p_formula_id);
386: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
387: fnd_message.raise_error;
388: --

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

381: when others then
382: --
383: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
384: fnd_message.set_token('PROC',l_package);
385: fnd_message.set_token('FORMULA',p_formula_id);
386: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
387: fnd_message.raise_error;
388: --
389: end;

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

382: --
383: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
384: fnd_message.set_token('PROC',l_package);
385: fnd_message.set_token('FORMULA',p_formula_id);
386: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
387: fnd_message.raise_error;
388: --
389: end;
390: --

Line 387: fnd_message.raise_error;

383: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
384: fnd_message.set_token('PROC',l_package);
385: fnd_message.set_token('FORMULA',p_formula_id);
386: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
387: fnd_message.raise_error;
388: --
389: end;
390: --
391: else

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

717: hr_utility.set_location('fonm_rt :'||p_fonm_cvg_strt_dt,10);
718: end if;
719: --
720: if p_effective_date is null then
721: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
722: fnd_message.set_token('PACKAGE',l_proc);
723: fnd_message.set_token('PARAM','p_effective_date');
724: fnd_message.set_token('PROC','Derived Factors');
725: fnd_message.raise_error;

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

718: end if;
719: --
720: if p_effective_date is null then
721: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
722: fnd_message.set_token('PACKAGE',l_proc);
723: fnd_message.set_token('PARAM','p_effective_date');
724: fnd_message.set_token('PROC','Derived Factors');
725: fnd_message.raise_error;
726: elsif p_person_id is null then

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

719: --
720: if p_effective_date is null then
721: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
722: fnd_message.set_token('PACKAGE',l_proc);
723: fnd_message.set_token('PARAM','p_effective_date');
724: fnd_message.set_token('PROC','Derived Factors');
725: fnd_message.raise_error;
726: elsif p_person_id is null then
727: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

720: if p_effective_date is null then
721: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
722: fnd_message.set_token('PACKAGE',l_proc);
723: fnd_message.set_token('PARAM','p_effective_date');
724: fnd_message.set_token('PROC','Derived Factors');
725: fnd_message.raise_error;
726: elsif p_person_id is null then
727: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
728: fnd_message.set_token('PACKAGE',l_proc);

Line 725: fnd_message.raise_error;

721: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
722: fnd_message.set_token('PACKAGE',l_proc);
723: fnd_message.set_token('PARAM','p_effective_date');
724: fnd_message.set_token('PROC','Derived Factors');
725: fnd_message.raise_error;
726: elsif p_person_id is null then
727: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
728: fnd_message.set_token('PACKAGE',l_proc);
729: fnd_message.set_token('PARAM','p_person_id');

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

723: fnd_message.set_token('PARAM','p_effective_date');
724: fnd_message.set_token('PROC','Derived Factors');
725: fnd_message.raise_error;
726: elsif p_person_id is null then
727: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
728: fnd_message.set_token('PACKAGE',l_proc);
729: fnd_message.set_token('PARAM','p_person_id');
730: fnd_message.set_token('PROC','Derived Factors');
731: fnd_message.raise_error;

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

724: fnd_message.set_token('PROC','Derived Factors');
725: fnd_message.raise_error;
726: elsif p_person_id is null then
727: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
728: fnd_message.set_token('PACKAGE',l_proc);
729: fnd_message.set_token('PARAM','p_person_id');
730: fnd_message.set_token('PROC','Derived Factors');
731: fnd_message.raise_error;
732: elsif p_comp_lvl_fctr_id is null then

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

725: fnd_message.raise_error;
726: elsif p_person_id is null then
727: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
728: fnd_message.set_token('PACKAGE',l_proc);
729: fnd_message.set_token('PARAM','p_person_id');
730: fnd_message.set_token('PROC','Derived Factors');
731: fnd_message.raise_error;
732: elsif p_comp_lvl_fctr_id is null then
733: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

726: elsif p_person_id is null then
727: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
728: fnd_message.set_token('PACKAGE',l_proc);
729: fnd_message.set_token('PARAM','p_person_id');
730: fnd_message.set_token('PROC','Derived Factors');
731: fnd_message.raise_error;
732: elsif p_comp_lvl_fctr_id is null then
733: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
734: fnd_message.set_token('PACKAGE',l_proc);

Line 731: fnd_message.raise_error;

727: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
728: fnd_message.set_token('PACKAGE',l_proc);
729: fnd_message.set_token('PARAM','p_person_id');
730: fnd_message.set_token('PROC','Derived Factors');
731: fnd_message.raise_error;
732: elsif p_comp_lvl_fctr_id is null then
733: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
734: fnd_message.set_token('PACKAGE',l_proc);
735: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');

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

729: fnd_message.set_token('PARAM','p_person_id');
730: fnd_message.set_token('PROC','Derived Factors');
731: fnd_message.raise_error;
732: elsif p_comp_lvl_fctr_id is null then
733: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
734: fnd_message.set_token('PACKAGE',l_proc);
735: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
736: fnd_message.set_token('PROC','Derived Factors');
737: fnd_message.raise_error;

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

730: fnd_message.set_token('PROC','Derived Factors');
731: fnd_message.raise_error;
732: elsif p_comp_lvl_fctr_id is null then
733: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
734: fnd_message.set_token('PACKAGE',l_proc);
735: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
736: fnd_message.set_token('PROC','Derived Factors');
737: fnd_message.raise_error;
738: elsif p_business_group_id is null then

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

731: fnd_message.raise_error;
732: elsif p_comp_lvl_fctr_id is null then
733: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
734: fnd_message.set_token('PACKAGE',l_proc);
735: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
736: fnd_message.set_token('PROC','Derived Factors');
737: fnd_message.raise_error;
738: elsif p_business_group_id is null then
739: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

732: elsif p_comp_lvl_fctr_id is null then
733: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
734: fnd_message.set_token('PACKAGE',l_proc);
735: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
736: fnd_message.set_token('PROC','Derived Factors');
737: fnd_message.raise_error;
738: elsif p_business_group_id is null then
739: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
740: fnd_message.set_token('PACKAGE',l_proc);

Line 737: fnd_message.raise_error;

733: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
734: fnd_message.set_token('PACKAGE',l_proc);
735: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
736: fnd_message.set_token('PROC','Derived Factors');
737: fnd_message.raise_error;
738: elsif p_business_group_id is null then
739: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
740: fnd_message.set_token('PACKAGE',l_proc);
741: fnd_message.set_token('PARAM','p_business_group_id');

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

735: fnd_message.set_token('PARAM','p_comp_lvl_fctr_id');
736: fnd_message.set_token('PROC','Derived Factors');
737: fnd_message.raise_error;
738: elsif p_business_group_id is null then
739: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
740: fnd_message.set_token('PACKAGE',l_proc);
741: fnd_message.set_token('PARAM','p_business_group_id');
742: fnd_message.set_token('PROC','Derived Factors');
743: fnd_message.raise_error;

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

736: fnd_message.set_token('PROC','Derived Factors');
737: fnd_message.raise_error;
738: elsif p_business_group_id is null then
739: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
740: fnd_message.set_token('PACKAGE',l_proc);
741: fnd_message.set_token('PARAM','p_business_group_id');
742: fnd_message.set_token('PROC','Derived Factors');
743: fnd_message.raise_error;
744: end if;

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

737: fnd_message.raise_error;
738: elsif p_business_group_id is null then
739: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
740: fnd_message.set_token('PACKAGE',l_proc);
741: fnd_message.set_token('PARAM','p_business_group_id');
742: fnd_message.set_token('PROC','Derived Factors');
743: fnd_message.raise_error;
744: end if;
745: --

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

738: elsif p_business_group_id is null then
739: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
740: fnd_message.set_token('PACKAGE',l_proc);
741: fnd_message.set_token('PARAM','p_business_group_id');
742: fnd_message.set_token('PROC','Derived Factors');
743: fnd_message.raise_error;
744: end if;
745: --
746: if (p_comp_obj_mode and

Line 743: fnd_message.raise_error;

739: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
740: fnd_message.set_token('PACKAGE',l_proc);
741: fnd_message.set_token('PARAM','p_business_group_id');
742: fnd_message.set_token('PROC','Derived Factors');
743: fnd_message.raise_error;
744: end if;
745: --
746: if (p_comp_obj_mode and
747: p_pl_id is null and

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

746: if (p_comp_obj_mode and
747: p_pl_id is null and
748: p_oipl_id is null and
749: p_pgm_id is null) then
750: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
751: fnd_message.set_token('PACKAGE',l_proc);
752: fnd_message.set_token('PERSON_ID',p_person_id);
753: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
754: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);

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

747: p_pl_id is null and
748: p_oipl_id is null and
749: p_pgm_id is null) then
750: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
751: fnd_message.set_token('PACKAGE',l_proc);
752: fnd_message.set_token('PERSON_ID',p_person_id);
753: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
754: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
755: fnd_message.raise_error;

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

748: p_oipl_id is null and
749: p_pgm_id is null) then
750: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
751: fnd_message.set_token('PACKAGE',l_proc);
752: fnd_message.set_token('PERSON_ID',p_person_id);
753: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
754: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
755: fnd_message.raise_error;
756: end if;

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

749: p_pgm_id is null) then
750: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
751: fnd_message.set_token('PACKAGE',l_proc);
752: fnd_message.set_token('PERSON_ID',p_person_id);
753: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
754: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
755: fnd_message.raise_error;
756: end if;
757: --

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

750: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
751: fnd_message.set_token('PACKAGE',l_proc);
752: fnd_message.set_token('PERSON_ID',p_person_id);
753: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
754: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
755: fnd_message.raise_error;
756: end if;
757: --
758: -- FONM

Line 755: fnd_message.raise_error;

751: fnd_message.set_token('PACKAGE',l_proc);
752: fnd_message.set_token('PERSON_ID',p_person_id);
753: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
754: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
755: fnd_message.raise_error;
756: end if;
757: --
758: -- FONM
759: --if ben_manage_life_events.fonm = 'Y' then

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

787: --
788: fetch c_clf into l_clf;
789: if c_clf%notfound then
790: close c_clf;
791: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('CURSOR','c_clf');
794: fnd_message.raise_error;
795: end if;

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

788: fetch c_clf into l_clf;
789: if c_clf%notfound then
790: close c_clf;
791: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('CURSOR','c_clf');
794: fnd_message.raise_error;
795: end if;
796: --

Line 793: fnd_message.set_token('CURSOR','c_clf');

789: if c_clf%notfound then
790: close c_clf;
791: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('CURSOR','c_clf');
794: fnd_message.raise_error;
795: end if;
796: --
797: close c_clf;

Line 794: fnd_message.raise_error;

790: close c_clf;
791: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
792: fnd_message.set_token('PACKAGE',l_proc);
793: fnd_message.set_token('CURSOR','c_clf');
794: fnd_message.raise_error;
795: end if;
796: --
797: close c_clf;
798: --

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

889: l_value := p_value;
890: --
891: if l_value is null then
892: --
893: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
894: fnd_message.set_token('DATE',l_date);
895: benutils.write(p_text=> fnd_message.get);
896: --
897: -- try with todays date

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

890: --
891: if l_value is null then
892: --
893: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
894: fnd_message.set_token('DATE',l_date);
895: benutils.write(p_text=> fnd_message.get);
896: --
897: -- try with todays date
898: --

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

891: if l_value is null then
892: --
893: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
894: fnd_message.set_token('DATE',l_date);
895: benutils.write(p_text=> fnd_message.get);
896: --
897: -- try with todays date
898: --
899: run_rule

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

915: l_value := p_value;
916: --
917: IF l_value IS NULL THEN
918: --
919: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
920: fnd_message.set_token('DATE',p_effective_date);
921: benutils.write(p_text=> fnd_message.get);
922: return;
923: --

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

916: --
917: IF l_value IS NULL THEN
918: --
919: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
920: fnd_message.set_token('DATE',p_effective_date);
921: benutils.write(p_text=> fnd_message.get);
922: return;
923: --
924: END IF;

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

917: IF l_value IS NULL THEN
918: --
919: fnd_message.set_name('BEN','BEN_92319_SAL_BALANCE_NULL');
920: fnd_message.set_token('DATE',p_effective_date);
921: benutils.write(p_text=> fnd_message.get);
922: return;
923: --
924: END IF;
925: --

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

934: l_start_date := to_date(l_clf.start_day_mo||nvl(l_clf.start_year,to_char(l_date,'YYYY')),'DDMMYYYY');
935: l_end_date := to_date(l_clf.end_day_mo||nvl(l_clf.end_year,to_char(l_date,'YYYY')),'DDMMYYYY');
936: exception
937: when others then
938: fnd_message.set_name('BEN','BEN_92603_INVALID_DATE');
939: fnd_message.raise_error;
940: end;
941:
942: if l_start_date > l_end_date then

Line 939: fnd_message.raise_error;

935: l_end_date := to_date(l_clf.end_day_mo||nvl(l_clf.end_year,to_char(l_date,'YYYY')),'DDMMYYYY');
936: exception
937: when others then
938: fnd_message.set_name('BEN','BEN_92603_INVALID_DATE');
939: fnd_message.raise_error;
940: end;
941:
942: if l_start_date > l_end_date then
943: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');

Line 943: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');

939: fnd_message.raise_error;
940: end;
941:
942: if l_start_date > l_end_date then
943: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
944: fnd_message.set_token('PROC',l_proc);
945: fnd_message.set_token('START_DT',l_start_date);
946: fnd_message.set_token('END_DT',l_end_date);
947: fnd_message.raise_error;

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

940: end;
941:
942: if l_start_date > l_end_date then
943: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
944: fnd_message.set_token('PROC',l_proc);
945: fnd_message.set_token('START_DT',l_start_date);
946: fnd_message.set_token('END_DT',l_end_date);
947: fnd_message.raise_error;
948: end if;

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

941:
942: if l_start_date > l_end_date then
943: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
944: fnd_message.set_token('PROC',l_proc);
945: fnd_message.set_token('START_DT',l_start_date);
946: fnd_message.set_token('END_DT',l_end_date);
947: fnd_message.raise_error;
948: end if;
949:

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

942: if l_start_date > l_end_date then
943: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
944: fnd_message.set_token('PROC',l_proc);
945: fnd_message.set_token('START_DT',l_start_date);
946: fnd_message.set_token('END_DT',l_end_date);
947: fnd_message.raise_error;
948: end if;
949:
950: -- 4500760

Line 947: fnd_message.raise_error;

943: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
944: fnd_message.set_token('PROC',l_proc);
945: fnd_message.set_token('START_DT',l_start_date);
946: fnd_message.set_token('END_DT',l_end_date);
947: fnd_message.raise_error;
948: end if;
949:
950: -- 4500760
951: if l_clf.proration_flag = 'Y' then

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

983: -- This is temp fix, once iic code is changed to handle no person data
984: -- or setup not found cases then this error can be un commented again.
985: --
986: /*
987: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');
988: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
989: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
990: fnd_message.raise_error;
991: */

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

984: -- or setup not found cases then this error can be un commented again.
985: --
986: /*
987: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');
988: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
989: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
990: fnd_message.raise_error;
991: */
992: benutils.write(p_text=> substr(l_msg_data,1,100));

Line 989: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));

985: --
986: /*
987: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');
988: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
989: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
990: fnd_message.raise_error;
991: */
992: benutils.write(p_text=> substr(l_msg_data,1,100));
993: l_comp_earned := 0;

Line 990: fnd_message.raise_error;

986: /*
987: fnd_message.set_name('BEN','BEN_93934_CWB_EMP_SAVE_API_ERR');
988: fnd_message.set_token('NAME','CN_GET_COMM_PMT_PAID_GRP');
989: fnd_message.set_token('MESSAGE',substr(l_msg_data,1,100));
990: fnd_message.raise_error;
991: */
992: benutils.write(p_text=> substr(l_msg_data,1,100));
993: l_comp_earned := 0;
994: l_comp_paid := 0;

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

1115: if nvl(l_opt_typ_cd.opt_typ_cd, 'YYY') ='CWB' then
1116: l_value := 0;
1117: l_salary.proposed_salary := 0;
1118: else
1119: fnd_message.set_name('BEN','BEN_93298_SAL_NOT_DFND');
1120: --Bug 2519393 Message made more clear.
1121: -- start bug # 4185334 -- changed the tokens --
1122: fnd_message.set_token('PARMA','c_stated_salary');
1123: fnd_message.set_token('PARMB',l_proc);

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

1118: else
1119: fnd_message.set_name('BEN','BEN_93298_SAL_NOT_DFND');
1120: --Bug 2519393 Message made more clear.
1121: -- start bug # 4185334 -- changed the tokens --
1122: fnd_message.set_token('PARMA','c_stated_salary');
1123: fnd_message.set_token('PARMB',l_proc);
1124: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date));
1125: fnd_message.set_token('PARM1',p_person_id);
1126: --- end bug # 4185334

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

1119: fnd_message.set_name('BEN','BEN_93298_SAL_NOT_DFND');
1120: --Bug 2519393 Message made more clear.
1121: -- start bug # 4185334 -- changed the tokens --
1122: fnd_message.set_token('PARMA','c_stated_salary');
1123: fnd_message.set_token('PARMB',l_proc);
1124: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date));
1125: fnd_message.set_token('PARM1',p_person_id);
1126: --- end bug # 4185334
1127: /*

Line 1124: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date));

1120: --Bug 2519393 Message made more clear.
1121: -- start bug # 4185334 -- changed the tokens --
1122: fnd_message.set_token('PARMA','c_stated_salary');
1123: fnd_message.set_token('PARMB',l_proc);
1124: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date));
1125: fnd_message.set_token('PARM1',p_person_id);
1126: --- end bug # 4185334
1127: /*
1128: fnd_message.raise_error;

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

1121: -- start bug # 4185334 -- changed the tokens --
1122: fnd_message.set_token('PARMA','c_stated_salary');
1123: fnd_message.set_token('PARMB',l_proc);
1124: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date));
1125: fnd_message.set_token('PARM1',p_person_id);
1126: --- end bug # 4185334
1127: /*
1128: fnd_message.raise_error;
1129: */

Line 1128: fnd_message.raise_error;

1124: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_effective_date));
1125: fnd_message.set_token('PARM1',p_person_id);
1126: --- end bug # 4185334
1127: /*
1128: fnd_message.raise_error;
1129: */
1130: --
1131: -- BUG 3315997
1132: --

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

1142: p_parmc => fnd_date.date_to_displaydate(p_effective_date),
1143: p_parm1 => p_person_id,
1144: p_person_id => p_person_id);
1145: -- end bug # 4185334
1146: benutils.write(p_text=> fnd_message.get);
1147: return;
1148: --
1149: end if;
1150: --

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

1209: l_value := i.proposed_salary + nvl(l_value,0);
1210: --
1211: else
1212: --
1213: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1214: fnd_message.set_token('PACKAGE',l_proc);
1215: fnd_message.set_token('PERSON_ID',p_person_id);
1216: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);

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

1210: --
1211: else
1212: --
1213: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1214: fnd_message.set_token('PACKAGE',l_proc);
1215: fnd_message.set_token('PERSON_ID',p_person_id);
1216: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1218: fnd_message.set_token('PGM_ID',p_pgm_id);

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

1211: else
1212: --
1213: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1214: fnd_message.set_token('PACKAGE',l_proc);
1215: fnd_message.set_token('PERSON_ID',p_person_id);
1216: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1218: fnd_message.set_token('PGM_ID',p_pgm_id);
1219: fnd_message.set_token('PL_ID',p_pl_id);

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

1212: --
1213: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1214: fnd_message.set_token('PACKAGE',l_proc);
1215: fnd_message.set_token('PERSON_ID',p_person_id);
1216: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1218: fnd_message.set_token('PGM_ID',p_pgm_id);
1219: fnd_message.set_token('PL_ID',p_pl_id);
1220: fnd_message.set_token('OIPL_ID',p_oipl_id);

Line 1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);

1213: fnd_message.set_name('BEN','BEN_92463_INVALID_FREQUENCY');
1214: fnd_message.set_token('PACKAGE',l_proc);
1215: fnd_message.set_token('PERSON_ID',p_person_id);
1216: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1218: fnd_message.set_token('PGM_ID',p_pgm_id);
1219: fnd_message.set_token('PL_ID',p_pl_id);
1220: fnd_message.set_token('OIPL_ID',p_oipl_id);
1221: fnd_message.raise_error;

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

1214: fnd_message.set_token('PACKAGE',l_proc);
1215: fnd_message.set_token('PERSON_ID',p_person_id);
1216: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1218: fnd_message.set_token('PGM_ID',p_pgm_id);
1219: fnd_message.set_token('PL_ID',p_pl_id);
1220: fnd_message.set_token('OIPL_ID',p_oipl_id);
1221: fnd_message.raise_error;
1222: --

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

1215: fnd_message.set_token('PERSON_ID',p_person_id);
1216: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1218: fnd_message.set_token('PGM_ID',p_pgm_id);
1219: fnd_message.set_token('PL_ID',p_pl_id);
1220: fnd_message.set_token('OIPL_ID',p_oipl_id);
1221: fnd_message.raise_error;
1222: --
1223: end if;

Line 1220: fnd_message.set_token('OIPL_ID',p_oipl_id);

1216: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1218: fnd_message.set_token('PGM_ID',p_pgm_id);
1219: fnd_message.set_token('PL_ID',p_pl_id);
1220: fnd_message.set_token('OIPL_ID',p_oipl_id);
1221: fnd_message.raise_error;
1222: --
1223: end if;
1224: --

Line 1221: fnd_message.raise_error;

1217: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1218: fnd_message.set_token('PGM_ID',p_pgm_id);
1219: fnd_message.set_token('PL_ID',p_pl_id);
1220: fnd_message.set_token('OIPL_ID',p_oipl_id);
1221: fnd_message.raise_error;
1222: --
1223: end if;
1224: --
1225: end if;

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

1313: --
1314: -- Unknown periodicity, Error out
1315: else
1316: --
1317: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1318: fnd_message.set_token('PACKAGE',l_proc);
1319: fnd_message.set_token('PERSON_ID',p_person_id);
1320: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);

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

1314: -- Unknown periodicity, Error out
1315: else
1316: --
1317: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1318: fnd_message.set_token('PACKAGE',l_proc);
1319: fnd_message.set_token('PERSON_ID',p_person_id);
1320: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1322: fnd_message.set_token('PGM_ID',p_pgm_id);

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

1315: else
1316: --
1317: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1318: fnd_message.set_token('PACKAGE',l_proc);
1319: fnd_message.set_token('PERSON_ID',p_person_id);
1320: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1322: fnd_message.set_token('PGM_ID',p_pgm_id);
1323: fnd_message.set_token('PL_ID',p_pl_id);

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

1316: --
1317: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1318: fnd_message.set_token('PACKAGE',l_proc);
1319: fnd_message.set_token('PERSON_ID',p_person_id);
1320: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1322: fnd_message.set_token('PGM_ID',p_pgm_id);
1323: fnd_message.set_token('PL_ID',p_pl_id);
1324: fnd_message.set_token('OIPL_ID',p_oipl_id);

Line 1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);

1317: fnd_message.set_name('BEN','BEN_92465_INVALID_PRDCTY_CD');
1318: fnd_message.set_token('PACKAGE',l_proc);
1319: fnd_message.set_token('PERSON_ID',p_person_id);
1320: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1322: fnd_message.set_token('PGM_ID',p_pgm_id);
1323: fnd_message.set_token('PL_ID',p_pl_id);
1324: fnd_message.set_token('OIPL_ID',p_oipl_id);
1325: fnd_message.raise_error;

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

1318: fnd_message.set_token('PACKAGE',l_proc);
1319: fnd_message.set_token('PERSON_ID',p_person_id);
1320: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1322: fnd_message.set_token('PGM_ID',p_pgm_id);
1323: fnd_message.set_token('PL_ID',p_pl_id);
1324: fnd_message.set_token('OIPL_ID',p_oipl_id);
1325: fnd_message.raise_error;
1326: --

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

1319: fnd_message.set_token('PERSON_ID',p_person_id);
1320: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1322: fnd_message.set_token('PGM_ID',p_pgm_id);
1323: fnd_message.set_token('PL_ID',p_pl_id);
1324: fnd_message.set_token('OIPL_ID',p_oipl_id);
1325: fnd_message.raise_error;
1326: --
1327: end if;

Line 1324: fnd_message.set_token('OIPL_ID',p_oipl_id);

1320: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1322: fnd_message.set_token('PGM_ID',p_pgm_id);
1323: fnd_message.set_token('PL_ID',p_pl_id);
1324: fnd_message.set_token('OIPL_ID',p_oipl_id);
1325: fnd_message.raise_error;
1326: --
1327: end if;
1328: --

Line 1325: fnd_message.raise_error;

1321: fnd_message.set_token('COMP_LVL_FCTR_ID',p_comp_lvl_fctr_id);
1322: fnd_message.set_token('PGM_ID',p_pgm_id);
1323: fnd_message.set_token('PL_ID',p_pl_id);
1324: fnd_message.set_token('OIPL_ID',p_oipl_id);
1325: fnd_message.raise_error;
1326: --
1327: end if;
1328: --
1329: elsif l_clf.comp_src_cd = 'BALTYP' then

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

1376: --
1377: end if ;
1378:
1379: if l_value is null then
1380: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
1381: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));
1382: benutils.write(p_text=> fnd_message.get);
1383: return;
1384: end if;

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

1377: end if ;
1378:
1379: if l_value is null then
1380: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
1381: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));
1382: benutils.write(p_text=> fnd_message.get);
1383: return;
1384: end if;
1385:

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

1378:
1379: if l_value is null then
1380: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
1381: fnd_message.set_token('DATE' ,nvl(p_calc_bal_to_date,l_date));
1382: benutils.write(p_text=> fnd_message.get);
1383: return;
1384: end if;
1385:
1386: --

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

1451: -- Person does not have a balance, recheck if they have a balance
1452: -- as of the life event occurred date or effective date.
1453: -- Fix for bug 216.
1454: --
1455: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1456: fnd_message.set_token('DATE',l_date);
1457: benutils.write(p_text=> fnd_message.get);
1458: l_value :=
1459: pay_balance_pkg.get_value(l_clf.defined_balance_id,

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

1452: -- as of the life event occurred date or effective date.
1453: -- Fix for bug 216.
1454: --
1455: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1456: fnd_message.set_token('DATE',l_date);
1457: benutils.write(p_text=> fnd_message.get);
1458: l_value :=
1459: pay_balance_pkg.get_value(l_clf.defined_balance_id,
1460: l_assignment.assignment_id,

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

1453: -- Fix for bug 216.
1454: --
1455: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1456: fnd_message.set_token('DATE',l_date);
1457: benutils.write(p_text=> fnd_message.get);
1458: l_value :=
1459: pay_balance_pkg.get_value(l_clf.defined_balance_id,
1460: l_assignment.assignment_id,
1461: p_effective_date);

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

1461: p_effective_date);
1462: --
1463: IF l_value IS NULL THEN
1464: --
1465: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1466: fnd_message.set_token('DATE',p_effective_date);
1467: benutils.write(p_text=> fnd_message.get);
1468: RETURN;
1469: --

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

1462: --
1463: IF l_value IS NULL THEN
1464: --
1465: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1466: fnd_message.set_token('DATE',p_effective_date);
1467: benutils.write(p_text=> fnd_message.get);
1468: RETURN;
1469: --
1470: END IF;

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

1463: IF l_value IS NULL THEN
1464: --
1465: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1466: fnd_message.set_token('DATE',p_effective_date);
1467: benutils.write(p_text=> fnd_message.get);
1468: RETURN;
1469: --
1470: END IF;
1471: --

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

1472: END IF;
1473: --
1474: exception
1475: when others then
1476: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1477: fnd_message.set_token('DATE',p_effective_date);
1478: benutils.write(p_text=> fnd_message.get);
1479: RETURN;
1480: end ;

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

1473: --
1474: exception
1475: when others then
1476: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1477: fnd_message.set_token('DATE',p_effective_date);
1478: benutils.write(p_text=> fnd_message.get);
1479: RETURN;
1480: end ;
1481:

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

1474: exception
1475: when others then
1476: fnd_message.set_name('BEN','BEN_92318_BEN_BALANCE_NULL');
1477: fnd_message.set_token('DATE',p_effective_date);
1478: benutils.write(p_text=> fnd_message.get);
1479: RETURN;
1480: end ;
1481:
1482: End If ; */

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

1556: --
1557: ben_person_object.get_object(p_bnfts_bal_id => l_clf.bnfts_bal_id,
1558: p_rec => l_bnb_rec);
1559: --
1560: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1561: fnd_message.set_token('NAME',l_bnb_rec.name);
1562: fnd_message.set_token('DATE',l_date);
1563: benutils.write(p_text=> fnd_message.get);
1564: --

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

1557: ben_person_object.get_object(p_bnfts_bal_id => l_clf.bnfts_bal_id,
1558: p_rec => l_bnb_rec);
1559: --
1560: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1561: fnd_message.set_token('NAME',l_bnb_rec.name);
1562: fnd_message.set_token('DATE',l_date);
1563: benutils.write(p_text=> fnd_message.get);
1564: --
1565: l_date := l_effective_date;

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

1558: p_rec => l_bnb_rec);
1559: --
1560: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1561: fnd_message.set_token('NAME',l_bnb_rec.name);
1562: fnd_message.set_token('DATE',l_date);
1563: benutils.write(p_text=> fnd_message.get);
1564: --
1565: l_date := l_effective_date;
1566: --

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

1559: --
1560: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1561: fnd_message.set_token('NAME',l_bnb_rec.name);
1562: fnd_message.set_token('DATE',l_date);
1563: benutils.write(p_text=> fnd_message.get);
1564: --
1565: l_date := l_effective_date;
1566: --
1567: open c_person_balance(l_date);

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

1581: if nvl(l_opt_typ_cd.opt_typ_cd, 'YYY') ='CWB' then
1582: l_value := 0;
1583: p_value := l_value;
1584: else
1585: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1586: fnd_message.set_token('NAME',l_bnb_rec.name);
1587: fnd_message.set_token('DATE',p_effective_date);
1588: benutils.write(p_text=> fnd_message.get);
1589: end if;

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

1582: l_value := 0;
1583: p_value := l_value;
1584: else
1585: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1586: fnd_message.set_token('NAME',l_bnb_rec.name);
1587: fnd_message.set_token('DATE',p_effective_date);
1588: benutils.write(p_text=> fnd_message.get);
1589: end if;
1590: RETURN;

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

1583: p_value := l_value;
1584: else
1585: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1586: fnd_message.set_token('NAME',l_bnb_rec.name);
1587: fnd_message.set_token('DATE',p_effective_date);
1588: benutils.write(p_text=> fnd_message.get);
1589: end if;
1590: RETURN;
1591: --

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

1584: else
1585: fnd_message.set_name('BEN','BEN_92317_PER_BALANCE_NULL');
1586: fnd_message.set_token('NAME',l_bnb_rec.name);
1587: fnd_message.set_token('DATE',p_effective_date);
1588: benutils.write(p_text=> fnd_message.get);
1589: end if;
1590: RETURN;
1591: --
1592: END IF;

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

1847: --
1848: l_per_dob := p_per_dob;
1849: --
1850: if p_effective_date is null then
1851: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1852: fnd_message.set_token('PACKAGE',l_proc);
1853: fnd_message.set_token('PARAM','p_effective_date');
1854: fnd_message.set_token('PROC','Derived Factors');
1855: fnd_message.raise_error;

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

1848: l_per_dob := p_per_dob;
1849: --
1850: if p_effective_date is null then
1851: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1852: fnd_message.set_token('PACKAGE',l_proc);
1853: fnd_message.set_token('PARAM','p_effective_date');
1854: fnd_message.set_token('PROC','Derived Factors');
1855: fnd_message.raise_error;
1856: elsif p_person_id is null then

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

1849: --
1850: if p_effective_date is null then
1851: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1852: fnd_message.set_token('PACKAGE',l_proc);
1853: fnd_message.set_token('PARAM','p_effective_date');
1854: fnd_message.set_token('PROC','Derived Factors');
1855: fnd_message.raise_error;
1856: elsif p_person_id is null then
1857: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

1850: if p_effective_date is null then
1851: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1852: fnd_message.set_token('PACKAGE',l_proc);
1853: fnd_message.set_token('PARAM','p_effective_date');
1854: fnd_message.set_token('PROC','Derived Factors');
1855: fnd_message.raise_error;
1856: elsif p_person_id is null then
1857: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1858: fnd_message.set_token('PACKAGE',l_proc);

Line 1855: fnd_message.raise_error;

1851: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1852: fnd_message.set_token('PACKAGE',l_proc);
1853: fnd_message.set_token('PARAM','p_effective_date');
1854: fnd_message.set_token('PROC','Derived Factors');
1855: fnd_message.raise_error;
1856: elsif p_person_id is null then
1857: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1858: fnd_message.set_token('PACKAGE',l_proc);
1859: fnd_message.set_token('PARAM','p_person_id');

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

1853: fnd_message.set_token('PARAM','p_effective_date');
1854: fnd_message.set_token('PROC','Derived Factors');
1855: fnd_message.raise_error;
1856: elsif p_person_id is null then
1857: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1858: fnd_message.set_token('PACKAGE',l_proc);
1859: fnd_message.set_token('PARAM','p_person_id');
1860: fnd_message.set_token('PROC','Derived Factors');
1861: fnd_message.raise_error;

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

1854: fnd_message.set_token('PROC','Derived Factors');
1855: fnd_message.raise_error;
1856: elsif p_person_id is null then
1857: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1858: fnd_message.set_token('PACKAGE',l_proc);
1859: fnd_message.set_token('PARAM','p_person_id');
1860: fnd_message.set_token('PROC','Derived Factors');
1861: fnd_message.raise_error;
1862: elsif p_age_fctr_id is null then

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

1855: fnd_message.raise_error;
1856: elsif p_person_id is null then
1857: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1858: fnd_message.set_token('PACKAGE',l_proc);
1859: fnd_message.set_token('PARAM','p_person_id');
1860: fnd_message.set_token('PROC','Derived Factors');
1861: fnd_message.raise_error;
1862: elsif p_age_fctr_id is null then
1863: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

1856: elsif p_person_id is null then
1857: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1858: fnd_message.set_token('PACKAGE',l_proc);
1859: fnd_message.set_token('PARAM','p_person_id');
1860: fnd_message.set_token('PROC','Derived Factors');
1861: fnd_message.raise_error;
1862: elsif p_age_fctr_id is null then
1863: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1864: fnd_message.set_token('PACKAGE',l_proc);

Line 1861: fnd_message.raise_error;

1857: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1858: fnd_message.set_token('PACKAGE',l_proc);
1859: fnd_message.set_token('PARAM','p_person_id');
1860: fnd_message.set_token('PROC','Derived Factors');
1861: fnd_message.raise_error;
1862: elsif p_age_fctr_id is null then
1863: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1864: fnd_message.set_token('PACKAGE',l_proc);
1865: fnd_message.set_token('PARAM','p_age_fctr_id');

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

1859: fnd_message.set_token('PARAM','p_person_id');
1860: fnd_message.set_token('PROC','Derived Factors');
1861: fnd_message.raise_error;
1862: elsif p_age_fctr_id is null then
1863: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1864: fnd_message.set_token('PACKAGE',l_proc);
1865: fnd_message.set_token('PARAM','p_age_fctr_id');
1866: fnd_message.set_token('PROC','Derived Factors');
1867: fnd_message.raise_error;

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

1860: fnd_message.set_token('PROC','Derived Factors');
1861: fnd_message.raise_error;
1862: elsif p_age_fctr_id is null then
1863: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1864: fnd_message.set_token('PACKAGE',l_proc);
1865: fnd_message.set_token('PARAM','p_age_fctr_id');
1866: fnd_message.set_token('PROC','Derived Factors');
1867: fnd_message.raise_error;
1868: elsif p_business_group_id is null then

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

1861: fnd_message.raise_error;
1862: elsif p_age_fctr_id is null then
1863: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1864: fnd_message.set_token('PACKAGE',l_proc);
1865: fnd_message.set_token('PARAM','p_age_fctr_id');
1866: fnd_message.set_token('PROC','Derived Factors');
1867: fnd_message.raise_error;
1868: elsif p_business_group_id is null then
1869: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

1862: elsif p_age_fctr_id is null then
1863: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1864: fnd_message.set_token('PACKAGE',l_proc);
1865: fnd_message.set_token('PARAM','p_age_fctr_id');
1866: fnd_message.set_token('PROC','Derived Factors');
1867: fnd_message.raise_error;
1868: elsif p_business_group_id is null then
1869: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1870: fnd_message.set_token('PACKAGE',l_proc);

Line 1867: fnd_message.raise_error;

1863: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1864: fnd_message.set_token('PACKAGE',l_proc);
1865: fnd_message.set_token('PARAM','p_age_fctr_id');
1866: fnd_message.set_token('PROC','Derived Factors');
1867: fnd_message.raise_error;
1868: elsif p_business_group_id is null then
1869: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1870: fnd_message.set_token('PACKAGE',l_proc);
1871: fnd_message.set_token('PARAM','p_business_group_id');

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

1865: fnd_message.set_token('PARAM','p_age_fctr_id');
1866: fnd_message.set_token('PROC','Derived Factors');
1867: fnd_message.raise_error;
1868: elsif p_business_group_id is null then
1869: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1870: fnd_message.set_token('PACKAGE',l_proc);
1871: fnd_message.set_token('PARAM','p_business_group_id');
1872: fnd_message.set_token('PROC','Derived Factors');
1873: fnd_message.raise_error;

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

1866: fnd_message.set_token('PROC','Derived Factors');
1867: fnd_message.raise_error;
1868: elsif p_business_group_id is null then
1869: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1870: fnd_message.set_token('PACKAGE',l_proc);
1871: fnd_message.set_token('PARAM','p_business_group_id');
1872: fnd_message.set_token('PROC','Derived Factors');
1873: fnd_message.raise_error;
1874: end if;

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

1867: fnd_message.raise_error;
1868: elsif p_business_group_id is null then
1869: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1870: fnd_message.set_token('PACKAGE',l_proc);
1871: fnd_message.set_token('PARAM','p_business_group_id');
1872: fnd_message.set_token('PROC','Derived Factors');
1873: fnd_message.raise_error;
1874: end if;
1875: --

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

1868: elsif p_business_group_id is null then
1869: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1870: fnd_message.set_token('PACKAGE',l_proc);
1871: fnd_message.set_token('PARAM','p_business_group_id');
1872: fnd_message.set_token('PROC','Derived Factors');
1873: fnd_message.raise_error;
1874: end if;
1875: --
1876: /*

Line 1873: fnd_message.raise_error;

1869: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1870: fnd_message.set_token('PACKAGE',l_proc);
1871: fnd_message.set_token('PARAM','p_business_group_id');
1872: fnd_message.set_token('PROC','Derived Factors');
1873: fnd_message.raise_error;
1874: end if;
1875: --
1876: /*
1877: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then

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

1874: end if;
1875: --
1876: /*
1877: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1878: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1879: fnd_message.set_token('PACKAGE',l_proc);
1880: fnd_message.set_token('PERSON_ID',p_person_id);
1881: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1882: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);

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

1875: --
1876: /*
1877: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1878: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1879: fnd_message.set_token('PACKAGE',l_proc);
1880: fnd_message.set_token('PERSON_ID',p_person_id);
1881: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1882: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
1883: fnd_message.raise_error;

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

1876: /*
1877: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1878: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1879: fnd_message.set_token('PACKAGE',l_proc);
1880: fnd_message.set_token('PERSON_ID',p_person_id);
1881: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1882: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
1883: fnd_message.raise_error;
1884: end if;

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

1877: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
1878: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1879: fnd_message.set_token('PACKAGE',l_proc);
1880: fnd_message.set_token('PERSON_ID',p_person_id);
1881: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1882: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
1883: fnd_message.raise_error;
1884: end if;
1885: */

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

1878: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
1879: fnd_message.set_token('PACKAGE',l_proc);
1880: fnd_message.set_token('PERSON_ID',p_person_id);
1881: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1882: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
1883: fnd_message.raise_error;
1884: end if;
1885: */
1886: --

Line 1883: fnd_message.raise_error;

1879: fnd_message.set_token('PACKAGE',l_proc);
1880: fnd_message.set_token('PERSON_ID',p_person_id);
1881: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1882: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
1883: fnd_message.raise_error;
1884: end if;
1885: */
1886: --
1887: -- We need to drive off the correct person id when we are coming in from

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

1921: fetch c_agf into l_agf;
1922: --
1923: if c_agf%notfound then
1924: close c_agf;
1925: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
1926: fnd_message.set_token('PACKAGE',l_proc);
1927: fnd_message.set_token('CURSOR','c_agf');
1928: fnd_message.raise_error;
1929: end if;

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

1922: --
1923: if c_agf%notfound then
1924: close c_agf;
1925: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
1926: fnd_message.set_token('PACKAGE',l_proc);
1927: fnd_message.set_token('CURSOR','c_agf');
1928: fnd_message.raise_error;
1929: end if;
1930: close c_agf;

Line 1927: fnd_message.set_token('CURSOR','c_agf');

1923: if c_agf%notfound then
1924: close c_agf;
1925: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
1926: fnd_message.set_token('PACKAGE',l_proc);
1927: fnd_message.set_token('CURSOR','c_agf');
1928: fnd_message.raise_error;
1929: end if;
1930: close c_agf;
1931: --

Line 1928: fnd_message.raise_error;

1924: close c_agf;
1925: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
1926: fnd_message.set_token('PACKAGE',l_proc);
1927: fnd_message.set_token('CURSOR','c_agf');
1928: fnd_message.raise_error;
1929: end if;
1930: close c_agf;
1931: --
1932: -- hr_utility.set_location('l_agf.age_to_use_cd -> '||l_agf.age_to_use_cd,511);

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

2343: if p_effective_date is null then
2344: if g_debug then
2345: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2346: end if;
2347: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2348: fnd_message.set_token('PACKAGE',l_proc);
2349: fnd_message.set_token('PARAM','p_effective_date');
2350: fnd_message.set_token('PROC','Derived Factors');
2351: fnd_message.raise_error;

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

2344: if g_debug then
2345: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2346: end if;
2347: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2348: fnd_message.set_token('PACKAGE',l_proc);
2349: fnd_message.set_token('PARAM','p_effective_date');
2350: fnd_message.set_token('PROC','Derived Factors');
2351: fnd_message.raise_error;
2352: elsif p_person_id is null then

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

2345: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2346: end if;
2347: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2348: fnd_message.set_token('PACKAGE',l_proc);
2349: fnd_message.set_token('PARAM','p_effective_date');
2350: fnd_message.set_token('PROC','Derived Factors');
2351: fnd_message.raise_error;
2352: elsif p_person_id is null then
2353: if g_debug then

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

2346: end if;
2347: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2348: fnd_message.set_token('PACKAGE',l_proc);
2349: fnd_message.set_token('PARAM','p_effective_date');
2350: fnd_message.set_token('PROC','Derived Factors');
2351: fnd_message.raise_error;
2352: elsif p_person_id is null then
2353: if g_debug then
2354: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);

Line 2351: fnd_message.raise_error;

2347: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2348: fnd_message.set_token('PACKAGE',l_proc);
2349: fnd_message.set_token('PARAM','p_effective_date');
2350: fnd_message.set_token('PROC','Derived Factors');
2351: fnd_message.raise_error;
2352: elsif p_person_id is null then
2353: if g_debug then
2354: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2355: end if;

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

2352: elsif p_person_id is null then
2353: if g_debug then
2354: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2355: end if;
2356: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2357: fnd_message.set_token('PACKAGE',l_proc);
2358: fnd_message.set_token('PARAM','p_person_id');
2359: fnd_message.set_token('PROC','Derived Factors');
2360: fnd_message.raise_error;

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

2353: if g_debug then
2354: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2355: end if;
2356: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2357: fnd_message.set_token('PACKAGE',l_proc);
2358: fnd_message.set_token('PARAM','p_person_id');
2359: fnd_message.set_token('PROC','Derived Factors');
2360: fnd_message.raise_error;
2361: elsif p_los_fctr_id is null then

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

2354: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2355: end if;
2356: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2357: fnd_message.set_token('PACKAGE',l_proc);
2358: fnd_message.set_token('PARAM','p_person_id');
2359: fnd_message.set_token('PROC','Derived Factors');
2360: fnd_message.raise_error;
2361: elsif p_los_fctr_id is null then
2362: if g_debug then

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

2355: end if;
2356: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2357: fnd_message.set_token('PACKAGE',l_proc);
2358: fnd_message.set_token('PARAM','p_person_id');
2359: fnd_message.set_token('PROC','Derived Factors');
2360: fnd_message.raise_error;
2361: elsif p_los_fctr_id is null then
2362: if g_debug then
2363: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);

Line 2360: fnd_message.raise_error;

2356: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2357: fnd_message.set_token('PACKAGE',l_proc);
2358: fnd_message.set_token('PARAM','p_person_id');
2359: fnd_message.set_token('PROC','Derived Factors');
2360: fnd_message.raise_error;
2361: elsif p_los_fctr_id is null then
2362: if g_debug then
2363: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2364: end if;

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

2361: elsif p_los_fctr_id is null then
2362: if g_debug then
2363: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2364: end if;
2365: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2366: fnd_message.set_token('PACKAGE',l_proc);
2367: fnd_message.set_token('PARAM','p_los_fctr_id');
2368: fnd_message.set_token('PROC','Derived Factors');
2369: fnd_message.raise_error;

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

2362: if g_debug then
2363: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2364: end if;
2365: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2366: fnd_message.set_token('PACKAGE',l_proc);
2367: fnd_message.set_token('PARAM','p_los_fctr_id');
2368: fnd_message.set_token('PROC','Derived Factors');
2369: fnd_message.raise_error;
2370: elsif p_business_group_id is null then

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

2363: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2364: end if;
2365: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2366: fnd_message.set_token('PACKAGE',l_proc);
2367: fnd_message.set_token('PARAM','p_los_fctr_id');
2368: fnd_message.set_token('PROC','Derived Factors');
2369: fnd_message.raise_error;
2370: elsif p_business_group_id is null then
2371: if g_debug then

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

2364: end if;
2365: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2366: fnd_message.set_token('PACKAGE',l_proc);
2367: fnd_message.set_token('PARAM','p_los_fctr_id');
2368: fnd_message.set_token('PROC','Derived Factors');
2369: fnd_message.raise_error;
2370: elsif p_business_group_id is null then
2371: if g_debug then
2372: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);

Line 2369: fnd_message.raise_error;

2365: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2366: fnd_message.set_token('PACKAGE',l_proc);
2367: fnd_message.set_token('PARAM','p_los_fctr_id');
2368: fnd_message.set_token('PROC','Derived Factors');
2369: fnd_message.raise_error;
2370: elsif p_business_group_id is null then
2371: if g_debug then
2372: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2373: end if;

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

2370: elsif p_business_group_id is null then
2371: if g_debug then
2372: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2373: end if;
2374: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2375: fnd_message.set_token('PACKAGE',l_proc);
2376: fnd_message.set_token('PARAM','p_business_group_id');
2377: fnd_message.set_token('PROC','Derived Factors');
2378: fnd_message.raise_error;

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

2371: if g_debug then
2372: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2373: end if;
2374: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2375: fnd_message.set_token('PACKAGE',l_proc);
2376: fnd_message.set_token('PARAM','p_business_group_id');
2377: fnd_message.set_token('PROC','Derived Factors');
2378: fnd_message.raise_error;
2379: end if;

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

2372: hr_utility.set_location('BEN_91832_PACKAGE_PARAM_NULL',10);
2373: end if;
2374: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2375: fnd_message.set_token('PACKAGE',l_proc);
2376: fnd_message.set_token('PARAM','p_business_group_id');
2377: fnd_message.set_token('PROC','Derived Factors');
2378: fnd_message.raise_error;
2379: end if;
2380: --

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

2373: end if;
2374: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2375: fnd_message.set_token('PACKAGE',l_proc);
2376: fnd_message.set_token('PARAM','p_business_group_id');
2377: fnd_message.set_token('PROC','Derived Factors');
2378: fnd_message.raise_error;
2379: end if;
2380: --
2381: /*

Line 2378: fnd_message.raise_error;

2374: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
2375: fnd_message.set_token('PACKAGE',l_proc);
2376: fnd_message.set_token('PARAM','p_business_group_id');
2377: fnd_message.set_token('PROC','Derived Factors');
2378: fnd_message.raise_error;
2379: end if;
2380: --
2381: /*
2382: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then

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

2382: if (p_pl_id is null and p_oipl_id is null and p_pgm_id is null) then
2383: if g_debug then
2384: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);
2385: end if;
2386: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2387: fnd_message.set_token('PACKAGE',l_proc);
2388: fnd_message.set_token('PERSON_ID',p_person_id);
2389: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2390: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);

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

2383: if g_debug then
2384: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);
2385: end if;
2386: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2387: fnd_message.set_token('PACKAGE',l_proc);
2388: fnd_message.set_token('PERSON_ID',p_person_id);
2389: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2390: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2391: fnd_message.raise_error;

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

2384: hr_utility.set_location('BEN_91849_COMP_OBJECT_VAL_NULL',10);
2385: end if;
2386: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2387: fnd_message.set_token('PACKAGE',l_proc);
2388: fnd_message.set_token('PERSON_ID',p_person_id);
2389: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2390: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2391: fnd_message.raise_error;
2392: end if;

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

2385: end if;
2386: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2387: fnd_message.set_token('PACKAGE',l_proc);
2388: fnd_message.set_token('PERSON_ID',p_person_id);
2389: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2390: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2391: fnd_message.raise_error;
2392: end if;
2393: */

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

2386: fnd_message.set_name('BEN','BEN_91849_COMP_OBJECT_VAL_NULL');
2387: fnd_message.set_token('PACKAGE',l_proc);
2388: fnd_message.set_token('PERSON_ID',p_person_id);
2389: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2390: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2391: fnd_message.raise_error;
2392: end if;
2393: */
2394:

Line 2391: fnd_message.raise_error;

2387: fnd_message.set_token('PACKAGE',l_proc);
2388: fnd_message.set_token('PERSON_ID',p_person_id);
2389: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2390: fnd_message.set_token('PER_IN_LER_ID',p_per_in_ler_id);
2391: fnd_message.raise_error;
2392: end if;
2393: */
2394:
2395:

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

2419: close c_lsf;
2420: if g_debug then
2421: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);
2422: end if;
2423: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2424: fnd_message.set_token('PACKAGE',l_proc);
2425: fnd_message.set_token('CURSOR','c_lsf');
2426: fnd_message.raise_error;
2427: end if;

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

2420: if g_debug then
2421: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);
2422: end if;
2423: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2424: fnd_message.set_token('PACKAGE',l_proc);
2425: fnd_message.set_token('CURSOR','c_lsf');
2426: fnd_message.raise_error;
2427: end if;
2428: close c_lsf;

Line 2425: fnd_message.set_token('CURSOR','c_lsf');

2421: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',10);
2422: end if;
2423: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2424: fnd_message.set_token('PACKAGE',l_proc);
2425: fnd_message.set_token('CURSOR','c_lsf');
2426: fnd_message.raise_error;
2427: end if;
2428: close c_lsf;
2429:

Line 2426: fnd_message.raise_error;

2422: end if;
2423: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2424: fnd_message.set_token('PACKAGE',l_proc);
2425: fnd_message.set_token('CURSOR','c_lsf');
2426: fnd_message.raise_error;
2427: end if;
2428: close c_lsf;
2429:
2430: ben_determine_date.main

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

2453: close c_person;
2454: if g_debug then
2455: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);
2456: end if;
2457: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2458: fnd_message.set_token('PACKAGE',l_proc);
2459: fnd_message.set_token('CURSOR','c_person');
2460: fnd_message.raise_error;
2461: end if;

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

2454: if g_debug then
2455: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);
2456: end if;
2457: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2458: fnd_message.set_token('PACKAGE',l_proc);
2459: fnd_message.set_token('CURSOR','c_person');
2460: fnd_message.raise_error;
2461: end if;
2462: close c_person;

Line 2459: fnd_message.set_token('CURSOR','c_person');

2455: hr_utility.set_location('BEN_91833_CURSOR_RETURN_NO_ROW',20);
2456: end if;
2457: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2458: fnd_message.set_token('PACKAGE',l_proc);
2459: fnd_message.set_token('CURSOR','c_person');
2460: fnd_message.raise_error;
2461: end if;
2462: close c_person;
2463: --

Line 2460: fnd_message.raise_error;

2456: end if;
2457: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2458: fnd_message.set_token('PACKAGE',l_proc);
2459: fnd_message.set_token('CURSOR','c_person');
2460: fnd_message.raise_error;
2461: end if;
2462: close c_person;
2463: --
2464: open c_person_extra;

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

2566: else
2567: if g_debug then
2568: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);
2569: end if;
2570: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2571: fnd_message.set_token('PROC',l_proc);
2572: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);
2573: raise ben_manage_life_events.g_record_error;
2574: end if;

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

2567: if g_debug then
2568: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);
2569: end if;
2570: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2571: fnd_message.set_token('PROC',l_proc);
2572: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);
2573: raise ben_manage_life_events.g_record_error;
2574: end if;
2575:

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

2568: hr_utility.set_location('BEN_91342_UNKNOWN_CODE_1',20);
2569: end if;
2570: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2571: fnd_message.set_token('PROC',l_proc);
2572: fnd_message.set_token('CODE1',l_lsf.los_dt_to_use_cd);
2573: raise ben_manage_life_events.g_record_error;
2574: end if;
2575:
2576: p_start_date := l_start_date;

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

2684: fetch c_cla_elig1 into l_cla_elig1;
2685: if c_cla_elig1%notfound then
2686: --
2687: close c_cla_elig1;
2688: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2689: fnd_message.set_token('PACKAGE',l_proc);
2690: fnd_message.set_token('CURSOR','c_cla_elig1');
2691: fnd_message.raise_error;
2692: --

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

2685: if c_cla_elig1%notfound then
2686: --
2687: close c_cla_elig1;
2688: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2689: fnd_message.set_token('PACKAGE',l_proc);
2690: fnd_message.set_token('CURSOR','c_cla_elig1');
2691: fnd_message.raise_error;
2692: --
2693: end if;

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

2686: --
2687: close c_cla_elig1;
2688: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2689: fnd_message.set_token('PACKAGE',l_proc);
2690: fnd_message.set_token('CURSOR','c_cla_elig1');
2691: fnd_message.raise_error;
2692: --
2693: end if;
2694: --

Line 2691: fnd_message.raise_error;

2687: close c_cla_elig1;
2688: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2689: fnd_message.set_token('PACKAGE',l_proc);
2690: fnd_message.set_token('CURSOR','c_cla_elig1');
2691: fnd_message.raise_error;
2692: --
2693: end if;
2694: --
2695: close c_cla_elig1;

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

2833: fetch c_hwf into l_hwf;
2834: --
2835: if c_hwf%notfound then
2836: close c_hwf;
2837: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2838: fnd_message.set_token('PACKAGE',l_package);
2839: fnd_message.set_token('CURSOR','c_hwf');
2840: fnd_message.raise_error;
2841: end if;

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

2834: --
2835: if c_hwf%notfound then
2836: close c_hwf;
2837: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2838: fnd_message.set_token('PACKAGE',l_package);
2839: fnd_message.set_token('CURSOR','c_hwf');
2840: fnd_message.raise_error;
2841: end if;
2842: close c_hwf;

Line 2839: fnd_message.set_token('CURSOR','c_hwf');

2835: if c_hwf%notfound then
2836: close c_hwf;
2837: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2838: fnd_message.set_token('PACKAGE',l_package);
2839: fnd_message.set_token('CURSOR','c_hwf');
2840: fnd_message.raise_error;
2841: end if;
2842: close c_hwf;
2843: --

Line 2840: fnd_message.raise_error;

2836: close c_hwf;
2837: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
2838: fnd_message.set_token('PACKAGE',l_package);
2839: fnd_message.set_token('CURSOR','c_hwf');
2840: fnd_message.raise_error;
2841: end if;
2842: close c_hwf;
2843: --
2844: -- Steps to perform process

Line 2932: fnd_message.set_name('BEN'

2928: --
2929: ben_person_object.get_object(p_bnfts_bal_id=> l_hwf.bnfts_bal_id
2930: ,p_rec => l_bnb_rec);
2931: --
2932: fnd_message.set_name('BEN'
2933: ,'BEN_92317_PER_BALANCE_NULL');
2934: fnd_message.set_token('NAME'
2935: ,l_bnb_rec.name);
2936: fnd_message.set_token('DATE'

Line 2934: fnd_message.set_token('NAME'

2930: ,p_rec => l_bnb_rec);
2931: --
2932: fnd_message.set_name('BEN'
2933: ,'BEN_92317_PER_BALANCE_NULL');
2934: fnd_message.set_token('NAME'
2935: ,l_bnb_rec.name);
2936: fnd_message.set_token('DATE'
2937: ,l_start_date);
2938: benutils.write(p_text=> fnd_message.get);

Line 2936: fnd_message.set_token('DATE'

2932: fnd_message.set_name('BEN'
2933: ,'BEN_92317_PER_BALANCE_NULL');
2934: fnd_message.set_token('NAME'
2935: ,l_bnb_rec.name);
2936: fnd_message.set_token('DATE'
2937: ,l_start_date);
2938: benutils.write(p_text=> fnd_message.get);
2939: --
2940: ben_person_object.get_object(p_person_id=> p_person_id

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

2934: fnd_message.set_token('NAME'
2935: ,l_bnb_rec.name);
2936: fnd_message.set_token('DATE'
2937: ,l_start_date);
2938: benutils.write(p_text=> fnd_message.get);
2939: --
2940: ben_person_object.get_object(p_person_id=> p_person_id
2941: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
2942: ,p_effective_date)

Line 2953: fnd_message.set_name('BEN'

2949: end if;
2950: --
2951: IF l_result IS NULL THEN
2952: --
2953: fnd_message.set_name('BEN'
2954: ,'BEN_92317_PER_BALANCE_NULL');
2955: fnd_message.set_token('NAME'
2956: ,l_bnb_rec.name);
2957: fnd_message.set_token('DATE'

Line 2955: fnd_message.set_token('NAME'

2951: IF l_result IS NULL THEN
2952: --
2953: fnd_message.set_name('BEN'
2954: ,'BEN_92317_PER_BALANCE_NULL');
2955: fnd_message.set_token('NAME'
2956: ,l_bnb_rec.name);
2957: fnd_message.set_token('DATE'
2958: ,NVL(p_lf_evt_ocrd_dt
2959: ,p_effective_date));

Line 2957: fnd_message.set_token('DATE'

2953: fnd_message.set_name('BEN'
2954: ,'BEN_92317_PER_BALANCE_NULL');
2955: fnd_message.set_token('NAME'
2956: ,l_bnb_rec.name);
2957: fnd_message.set_token('DATE'
2958: ,NVL(p_lf_evt_ocrd_dt
2959: ,p_effective_date));
2960: benutils.write(p_text=> fnd_message.get);
2961: RETURN;

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

2956: ,l_bnb_rec.name);
2957: fnd_message.set_token('DATE'
2958: ,NVL(p_lf_evt_ocrd_dt
2959: ,p_effective_date));
2960: benutils.write(p_text=> fnd_message.get);
2961: RETURN;
2962: --
2963: END IF;
2964: --

Line 3038: fnd_message.set_name('BEN'

3034: -- Person does not have a balance, recheck if they have a balance
3035: -- as of the life event occurred date or effective date.
3036: -- Fix for bug 216.
3037: --
3038: fnd_message.set_name('BEN'
3039: ,'BEN_92318_BEN_BALANCE_NULL');
3040: fnd_message.set_token('DATE'
3041: ,l_start_date);
3042: benutils.write(p_text=> fnd_message.get);

Line 3040: fnd_message.set_token('DATE'

3036: -- Fix for bug 216.
3037: --
3038: fnd_message.set_name('BEN'
3039: ,'BEN_92318_BEN_BALANCE_NULL');
3040: fnd_message.set_token('DATE'
3041: ,l_start_date);
3042: benutils.write(p_text=> fnd_message.get);
3043: --
3044: l_result :=

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

3038: fnd_message.set_name('BEN'
3039: ,'BEN_92318_BEN_BALANCE_NULL');
3040: fnd_message.set_token('DATE'
3041: ,l_start_date);
3042: benutils.write(p_text=> fnd_message.get);
3043: --
3044: l_result :=
3045: pay_balance_pkg.get_value(l_hwf.defined_balance_id
3046: ,l_assignment.assignment_id

Line 3052: fnd_message.set_name('BEN'

3048: );
3049: --
3050: IF l_result IS NULL THEN
3051: --
3052: fnd_message.set_name('BEN'
3053: ,'BEN_92318_BEN_BALANCE_NULL');
3054: fnd_message.set_token('DATE'
3055: , l_effective_date);
3056: benutils.write(p_text=> fnd_message.get);

Line 3054: fnd_message.set_token('DATE'

3050: IF l_result IS NULL THEN
3051: --
3052: fnd_message.set_name('BEN'
3053: ,'BEN_92318_BEN_BALANCE_NULL');
3054: fnd_message.set_token('DATE'
3055: , l_effective_date);
3056: benutils.write(p_text=> fnd_message.get);
3057: RETURN ;
3058: --

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

3052: fnd_message.set_name('BEN'
3053: ,'BEN_92318_BEN_BALANCE_NULL');
3054: fnd_message.set_token('DATE'
3055: , l_effective_date);
3056: benutils.write(p_text=> fnd_message.get);
3057: RETURN ;
3058: --
3059: END IF;
3060: --

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

3141: fetch c_pff into l_pff;
3142: --
3143: if c_pff%notfound then
3144: close c_pff;
3145: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
3146: fnd_message.set_token('PACKAGE',l_package);
3147: fnd_message.set_token('CURSOR','c_pff');
3148: fnd_message.raise_error;
3149: end if;

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

3142: --
3143: if c_pff%notfound then
3144: close c_pff;
3145: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
3146: fnd_message.set_token('PACKAGE',l_package);
3147: fnd_message.set_token('CURSOR','c_pff');
3148: fnd_message.raise_error;
3149: end if;
3150: close c_pff;

Line 3147: fnd_message.set_token('CURSOR','c_pff');

3143: if c_pff%notfound then
3144: close c_pff;
3145: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
3146: fnd_message.set_token('PACKAGE',l_package);
3147: fnd_message.set_token('CURSOR','c_pff');
3148: fnd_message.raise_error;
3149: end if;
3150: close c_pff;
3151:

Line 3148: fnd_message.raise_error;

3144: close c_pff;
3145: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
3146: fnd_message.set_token('PACKAGE',l_package);
3147: fnd_message.set_token('CURSOR','c_pff');
3148: fnd_message.raise_error;
3149: end if;
3150: close c_pff;
3151:
3152: if p_assignment_id is null then