371: close c1;
372: --
373: -- raise error
374: --
375: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
376: fnd_message.set_token('ID',p_mtchg_rt_calc_rl);
377: fnd_message.set_token('TYPE_ID',-160);
378: fnd_message.raise_error;
379: --
372: --
373: -- raise error
374: --
375: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
376: fnd_message.set_token('ID',p_mtchg_rt_calc_rl);
377: fnd_message.set_token('TYPE_ID',-160);
378: fnd_message.raise_error;
379: --
380: end if;
373: -- raise error
374: --
375: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
376: fnd_message.set_token('ID',p_mtchg_rt_calc_rl);
377: fnd_message.set_token('TYPE_ID',-160);
378: fnd_message.raise_error;
379: --
380: end if;
381: --
374: --
375: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
376: fnd_message.set_token('ID',p_mtchg_rt_calc_rl);
377: fnd_message.set_token('TYPE_ID',-160);
378: fnd_message.raise_error;
379: --
380: end if;
381: --
382: close c1;
576: --
577: -- If no_mx_pct_of_py_num_flag is "on", then mx_pct_of_py_num
578: -- must be null.
579: If p_no_mx_pct_of_py_num_flag = 'Y' and p_mx_pct_of_py_num is not null then
580: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSU_MX_PCT_FLG');
581: fnd_message.raise_error;
582: end if;
583: If p_no_mx_pct_of_py_num_flag = 'N' and p_mx_pct_of_py_num is null then
584: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSU_MX_PCT_FLG');
577: -- If no_mx_pct_of_py_num_flag is "on", then mx_pct_of_py_num
578: -- must be null.
579: If p_no_mx_pct_of_py_num_flag = 'Y' and p_mx_pct_of_py_num is not null then
580: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSU_MX_PCT_FLG');
581: fnd_message.raise_error;
582: end if;
583: If p_no_mx_pct_of_py_num_flag = 'N' and p_mx_pct_of_py_num is null then
584: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSU_MX_PCT_FLG');
585: fnd_message.raise_error;
580: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSU_MX_PCT_FLG');
581: fnd_message.raise_error;
582: end if;
583: If p_no_mx_pct_of_py_num_flag = 'N' and p_mx_pct_of_py_num is null then
584: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSU_MX_PCT_FLG');
585: fnd_message.raise_error;
586: end if;
587:
588: --
581: fnd_message.raise_error;
582: end if;
583: If p_no_mx_pct_of_py_num_flag = 'N' and p_mx_pct_of_py_num is null then
584: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSU_MX_PCT_FLG');
585: fnd_message.raise_error;
586: end if;
587:
588: --
589: --
644: --
645: -- If no_mx_amt_of_py_num_flag is "on", then mx_amt_of_py_num
646: -- must be null.
647: If p_no_mx_amt_of_py_num_flag = 'Y' and p_mx_amt_of_py_num is not null then
648: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
649: fnd_message.raise_error;
650: end if;
651: If p_no_mx_amt_of_py_num_flag = 'N' and p_mx_amt_of_py_num is null then
652: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
645: -- If no_mx_amt_of_py_num_flag is "on", then mx_amt_of_py_num
646: -- must be null.
647: If p_no_mx_amt_of_py_num_flag = 'Y' and p_mx_amt_of_py_num is not null then
648: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
649: fnd_message.raise_error;
650: end if;
651: If p_no_mx_amt_of_py_num_flag = 'N' and p_mx_amt_of_py_num is null then
652: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
653: fnd_message.raise_error;
648: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
649: fnd_message.raise_error;
650: end if;
651: If p_no_mx_amt_of_py_num_flag = 'N' and p_mx_amt_of_py_num is null then
652: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
653: fnd_message.raise_error;
654: end if;
655:
656: --
649: fnd_message.raise_error;
650: end if;
651: If p_no_mx_amt_of_py_num_flag = 'N' and p_mx_amt_of_py_num is null then
652: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
653: fnd_message.raise_error;
654: end if;
655:
656: --
657: --
699: --
700: -- raise error if maximum amount is not null and the No Maximum Amount
701: -- flag is checked
702: --
703: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
704: fnd_message.raise_error;
705: --
706: end if;
707: --
700: -- raise error if maximum amount is not null and the No Maximum Amount
701: -- flag is checked
702: --
703: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
704: fnd_message.raise_error;
705: --
706: end if;
707: --
708: If (p_no_mx_mtch_amt_flag = 'N' and p_mx_mtch_amt is null) then
709: --
710: -- raise error if maximum amount is null and the No Maximum Amount
711: -- flag is not checked
712: --
713: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
714: fnd_message.raise_error;
715: --
716: end if;
717: --
710: -- raise error if maximum amount is null and the No Maximum Amount
711: -- flag is not checked
712: --
713: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
714: fnd_message.raise_error;
715: --
716: end if;
717: --
718: hr_utility.set_location('Leaving:'||l_proc, 10);
756: --
757: If (p_mx_mtch_amt is not null and p_mn_mtch_amt is not null) and
758: (p_mx_mtch_amt < p_mn_mtch_amt) then
759:
760: fnd_message.set_name('BEN','BEN_92506_MAX_MIN_AMT_CHK');
761: fnd_message.raise_error;
762: end if;
763: --
764: hr_utility.set_location('Leaving:'||l_proc, 10);
757: If (p_mx_mtch_amt is not null and p_mn_mtch_amt is not null) and
758: (p_mx_mtch_amt < p_mn_mtch_amt) then
759:
760: fnd_message.set_name('BEN','BEN_92506_MAX_MIN_AMT_CHK');
761: fnd_message.raise_error;
762: end if;
763: --
764: hr_utility.set_location('Leaving:'||l_proc, 10);
765: --