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_DETERMINE_ACTIVITY_BASE_RT dependencies on FND_MESSAGE

Line 333: 12-May-2005 ikasire 115.145 Moved the fnd_message binding into IF clause to avoid

329: benutils.formula
330: 17-Feb-2004 vvprabhu 115.144 Bug 4143012 : Changes in procedure main_w
331: to avoid value of cost1 being displayed for
332: cost2 when cost1 is 'SAREC'
333: 12-May-2005 ikasire 115.145 Moved the fnd_message binding into IF clause to avoid
334: misleading error message from SSBEN
335: 23-May-2005 lakrish 115.146 4235088, do fnd_number.canonical_to_number() to the
336: FF output before assigning to a number variable
337: 09-Jun-2005 nhunur 115.147 4383988, do fnd_number.canonical_to_number() to all

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

1219: --
1220: -- Ensure relevant parameters have been populated with values
1221: --
1222: if p_acty_base_rt_id is null then
1223: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1224: fnd_message.set_token('PACKAGE',l_package);
1225: fnd_message.set_token('PROC','Standard Rates');
1226: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1227: fnd_message.raise_error;

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

1220: -- Ensure relevant parameters have been populated with values
1221: --
1222: if p_acty_base_rt_id is null then
1223: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1224: fnd_message.set_token('PACKAGE',l_package);
1225: fnd_message.set_token('PROC','Standard Rates');
1226: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1227: fnd_message.raise_error;
1228: elsif p_person_id is null then

Line 1225: fnd_message.set_token('PROC','Standard Rates');

1221: --
1222: if p_acty_base_rt_id is null then
1223: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1224: fnd_message.set_token('PACKAGE',l_package);
1225: fnd_message.set_token('PROC','Standard Rates');
1226: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1227: fnd_message.raise_error;
1228: elsif p_person_id is null then
1229: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

Line 1226: fnd_message.set_token('PARAM','p_acty_base_rt_id');

1222: if p_acty_base_rt_id is null then
1223: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1224: fnd_message.set_token('PACKAGE',l_package);
1225: fnd_message.set_token('PROC','Standard Rates');
1226: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1227: fnd_message.raise_error;
1228: elsif p_person_id is null then
1229: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1230: fnd_message.set_token('PACKAGE',l_package);

Line 1227: fnd_message.raise_error;

1223: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1224: fnd_message.set_token('PACKAGE',l_package);
1225: fnd_message.set_token('PROC','Standard Rates');
1226: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1227: fnd_message.raise_error;
1228: elsif p_person_id is null then
1229: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1230: fnd_message.set_token('PACKAGE',l_package);
1231: fnd_message.set_token('PROC','Standard Rates');

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

1225: fnd_message.set_token('PROC','Standard Rates');
1226: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1227: fnd_message.raise_error;
1228: elsif p_person_id is null then
1229: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1230: fnd_message.set_token('PACKAGE',l_package);
1231: fnd_message.set_token('PROC','Standard Rates');
1232: fnd_message.set_token('PARAM','p_person_id');
1233: fnd_message.raise_error;

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

1226: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1227: fnd_message.raise_error;
1228: elsif p_person_id is null then
1229: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1230: fnd_message.set_token('PACKAGE',l_package);
1231: fnd_message.set_token('PROC','Standard Rates');
1232: fnd_message.set_token('PARAM','p_person_id');
1233: fnd_message.raise_error;
1234: elsif p_effective_date is null then

Line 1231: fnd_message.set_token('PROC','Standard Rates');

1227: fnd_message.raise_error;
1228: elsif p_person_id is null then
1229: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1230: fnd_message.set_token('PACKAGE',l_package);
1231: fnd_message.set_token('PROC','Standard Rates');
1232: fnd_message.set_token('PARAM','p_person_id');
1233: fnd_message.raise_error;
1234: elsif p_effective_date is null then
1235: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

1228: elsif p_person_id is null then
1229: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1230: fnd_message.set_token('PACKAGE',l_package);
1231: fnd_message.set_token('PROC','Standard Rates');
1232: fnd_message.set_token('PARAM','p_person_id');
1233: fnd_message.raise_error;
1234: elsif p_effective_date is null then
1235: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1236: fnd_message.set_token('PACKAGE',l_package);

Line 1233: fnd_message.raise_error;

1229: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1230: fnd_message.set_token('PACKAGE',l_package);
1231: fnd_message.set_token('PROC','Standard Rates');
1232: fnd_message.set_token('PARAM','p_person_id');
1233: fnd_message.raise_error;
1234: elsif p_effective_date is null then
1235: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1236: fnd_message.set_token('PACKAGE',l_package);
1237: fnd_message.set_token('PROC','Standard Rates');

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

1231: fnd_message.set_token('PROC','Standard Rates');
1232: fnd_message.set_token('PARAM','p_person_id');
1233: fnd_message.raise_error;
1234: elsif p_effective_date is null then
1235: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1236: fnd_message.set_token('PACKAGE',l_package);
1237: fnd_message.set_token('PROC','Standard Rates');
1238: fnd_message.set_token('PARAM','p_effective_date');
1239: fnd_message.raise_error;

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

1232: fnd_message.set_token('PARAM','p_person_id');
1233: fnd_message.raise_error;
1234: elsif p_effective_date is null then
1235: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1236: fnd_message.set_token('PACKAGE',l_package);
1237: fnd_message.set_token('PROC','Standard Rates');
1238: fnd_message.set_token('PARAM','p_effective_date');
1239: fnd_message.raise_error;
1240: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then

Line 1237: fnd_message.set_token('PROC','Standard Rates');

1233: fnd_message.raise_error;
1234: elsif p_effective_date is null then
1235: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1236: fnd_message.set_token('PACKAGE',l_package);
1237: fnd_message.set_token('PROC','Standard Rates');
1238: fnd_message.set_token('PARAM','p_effective_date');
1239: fnd_message.raise_error;
1240: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1241: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

1234: elsif p_effective_date is null then
1235: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1236: fnd_message.set_token('PACKAGE',l_package);
1237: fnd_message.set_token('PROC','Standard Rates');
1238: fnd_message.set_token('PARAM','p_effective_date');
1239: fnd_message.raise_error;
1240: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1241: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1242: fnd_message.set_token('PACKAGE',l_package);

Line 1239: fnd_message.raise_error;

1235: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1236: fnd_message.set_token('PACKAGE',l_package);
1237: fnd_message.set_token('PROC','Standard Rates');
1238: fnd_message.set_token('PARAM','p_effective_date');
1239: fnd_message.raise_error;
1240: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1241: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1242: fnd_message.set_token('PACKAGE',l_package);
1243: fnd_message.set_token('PROC','Standard Rates');

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

1237: fnd_message.set_token('PROC','Standard Rates');
1238: fnd_message.set_token('PARAM','p_effective_date');
1239: fnd_message.raise_error;
1240: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1241: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1242: fnd_message.set_token('PACKAGE',l_package);
1243: fnd_message.set_token('PROC','Standard Rates');
1244: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1245: fnd_message.raise_error;

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

1238: fnd_message.set_token('PARAM','p_effective_date');
1239: fnd_message.raise_error;
1240: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1241: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1242: fnd_message.set_token('PACKAGE',l_package);
1243: fnd_message.set_token('PROC','Standard Rates');
1244: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1245: fnd_message.raise_error;
1246: end if;

Line 1243: fnd_message.set_token('PROC','Standard Rates');

1239: fnd_message.raise_error;
1240: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1241: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1242: fnd_message.set_token('PACKAGE',l_package);
1243: fnd_message.set_token('PROC','Standard Rates');
1244: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1245: fnd_message.raise_error;
1246: end if;
1247: hr_utility.set_location (' Checking Electable Choice ',20);

Line 1244: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');

1240: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1241: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1242: fnd_message.set_token('PACKAGE',l_package);
1243: fnd_message.set_token('PROC','Standard Rates');
1244: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1245: fnd_message.raise_error;
1246: end if;
1247: hr_utility.set_location (' Checking Electable Choice ',20);
1248: --

Line 1245: fnd_message.raise_error;

1241: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1242: fnd_message.set_token('PACKAGE',l_package);
1243: fnd_message.set_token('PROC','Standard Rates');
1244: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1245: fnd_message.raise_error;
1246: end if;
1247: hr_utility.set_location (' Checking Electable Choice ',20);
1248: --
1249: -- Populate electable choice information

Line 1294: fnd_message.set_name('BEN','BEN_92743_NO_ABR_EPE_EXISTS');

1290: open c_epe;
1291: fetch c_epe into l_epe;
1292: if c_epe%notfound then
1293: close c_epe;
1294: fnd_message.set_name('BEN','BEN_92743_NO_ABR_EPE_EXISTS');
1295: fnd_message.raise_error;
1296: end if;
1297: close c_epe;
1298: end if;

Line 1295: fnd_message.raise_error;

1291: fetch c_epe into l_epe;
1292: if c_epe%notfound then
1293: close c_epe;
1294: fnd_message.set_name('BEN','BEN_92743_NO_ABR_EPE_EXISTS');
1295: fnd_message.raise_error;
1296: end if;
1297: close c_epe;
1298: end if;
1299: hr_utility.set_location ('Dn Pop EPE'||l_package,10);

Line 1325: fnd_message.set_name('BEN','BEN_92738_NO_ABR_EXISTS');

1321: );
1322: fetch c_abr into l_abr;
1323: if c_abr%notfound then
1324: close c_abr;
1325: fnd_message.set_name('BEN','BEN_92738_NO_ABR_EXISTS');
1326: fnd_message.raise_error;
1327: end if;
1328: close c_abr;
1329: --

Line 1326: fnd_message.raise_error;

1322: fetch c_abr into l_abr;
1323: if c_abr%notfound then
1324: close c_abr;
1325: fnd_message.set_name('BEN','BEN_92738_NO_ABR_EXISTS');
1326: fnd_message.raise_error;
1327: end if;
1328: close c_abr;
1329: --
1330: if l_abr.acty_typ_cd in ('CWBWB','CWBDB') then

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

1450: --
1451: EXCEPTION
1452: WHEN OTHERS
1453: THEN
1454: fnd_message.set_name ('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
1455: fnd_message.set_token ('PROC', l_package);
1456: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1457: fnd_message.set_token ('PARAMETER',
1458: l_outputs (l_outputs.COUNT).NAME

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

1451: EXCEPTION
1452: WHEN OTHERS
1453: THEN
1454: fnd_message.set_name ('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
1455: fnd_message.set_token ('PROC', l_package);
1456: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1457: fnd_message.set_token ('PARAMETER',
1458: l_outputs (l_outputs.COUNT).NAME
1459: );

Line 1456: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);

1452: WHEN OTHERS
1453: THEN
1454: fnd_message.set_name ('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
1455: fnd_message.set_token ('PROC', l_package);
1456: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1457: fnd_message.set_token ('PARAMETER',
1458: l_outputs (l_outputs.COUNT).NAME
1459: );
1460: fnd_message.raise_error;

Line 1457: fnd_message.set_token ('PARAMETER',

1453: THEN
1454: fnd_message.set_name ('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
1455: fnd_message.set_token ('PROC', l_package);
1456: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1457: fnd_message.set_token ('PARAMETER',
1458: l_outputs (l_outputs.COUNT).NAME
1459: );
1460: fnd_message.raise_error;
1461: END;

Line 1460: fnd_message.raise_error;

1456: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1457: fnd_message.set_token ('PARAMETER',
1458: l_outputs (l_outputs.COUNT).NAME
1459: );
1460: fnd_message.raise_error;
1461: END;
1462: --
1463: END IF;
1464:

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

1956: l_abr.dflt_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
1957: end if;
1958: exception
1959: when others then
1960: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1961: fnd_message.set_token('PROC',l_package);
1962: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
1963: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
1964: fnd_message.raise_error;

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

1957: end if;
1958: exception
1959: when others then
1960: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1961: fnd_message.set_token('PROC',l_package);
1962: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
1963: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
1964: fnd_message.raise_error;
1965: end;

Line 1962: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);

1958: exception
1959: when others then
1960: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1961: fnd_message.set_token('PROC',l_package);
1962: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
1963: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
1964: fnd_message.raise_error;
1965: end;
1966: end loop;

Line 1963: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);

1959: when others then
1960: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1961: fnd_message.set_token('PROC',l_package);
1962: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
1963: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
1964: fnd_message.raise_error;
1965: end;
1966: end loop;
1967: else

Line 1964: fnd_message.raise_error;

1960: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1961: fnd_message.set_token('PROC',l_package);
1962: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
1963: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
1964: fnd_message.raise_error;
1965: end;
1966: end loop;
1967: else
1968: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');

Line 1968: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');

1964: fnd_message.raise_error;
1965: end;
1966: end loop;
1967: else
1968: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');
1969: fnd_message.raise_error;
1970: end if;
1971: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
1972: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);

Line 1969: fnd_message.raise_error;

1965: end;
1966: end loop;
1967: else
1968: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');
1969: fnd_message.raise_error;
1970: end if;
1971: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
1972: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
1973: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);

Line 1988: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

1984: close c_state;
1985: */
1986: hr_utility.set_location (' Checking rate multiplier code ',40);
1987: if l_abr.rt_mlt_cd is null then
1988: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
1989: fnd_message.set_token('COLUMN','rt_mlt_cd');
1990: fnd_message.set_token('PACKAGE',l_package);
1991: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 1989: fnd_message.set_token('COLUMN','rt_mlt_cd');

1985: */
1986: hr_utility.set_location (' Checking rate multiplier code ',40);
1987: if l_abr.rt_mlt_cd is null then
1988: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
1989: fnd_message.set_token('COLUMN','rt_mlt_cd');
1990: fnd_message.set_token('PACKAGE',l_package);
1991: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

1986: hr_utility.set_location (' Checking rate multiplier code ',40);
1987: if l_abr.rt_mlt_cd is null then
1988: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
1989: fnd_message.set_token('COLUMN','rt_mlt_cd');
1990: fnd_message.set_token('PACKAGE',l_package);
1991: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

1987: if l_abr.rt_mlt_cd is null then
1988: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
1989: fnd_message.set_token('COLUMN','rt_mlt_cd');
1990: fnd_message.set_token('PACKAGE',l_package);
1991: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
1995: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

1988: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
1989: fnd_message.set_token('COLUMN','rt_mlt_cd');
1990: fnd_message.set_token('PACKAGE',l_package);
1991: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
1995: fnd_message.set_token('PL_ID',to_char(p_pl_id));
1996: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

1989: fnd_message.set_token('COLUMN','rt_mlt_cd');
1990: fnd_message.set_token('PACKAGE',l_package);
1991: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
1995: fnd_message.set_token('PL_ID',to_char(p_pl_id));
1996: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
1997: fnd_message.raise_error;

Line 1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

1990: fnd_message.set_token('PACKAGE',l_package);
1991: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
1995: fnd_message.set_token('PL_ID',to_char(p_pl_id));
1996: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
1997: fnd_message.raise_error;
1998: end if;

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

1991: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
1995: fnd_message.set_token('PL_ID',to_char(p_pl_id));
1996: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
1997: fnd_message.raise_error;
1998: end if;
1999: hr_utility.set_location (' Checking rate multiplier code others',50);

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

1992: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
1995: fnd_message.set_token('PL_ID',to_char(p_pl_id));
1996: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
1997: fnd_message.raise_error;
1998: end if;
1999: hr_utility.set_location (' Checking rate multiplier code others',50);
2000: if l_abr.rt_mlt_cd in ('FLFX','CL','AP','CVG','PRNT','CLANDCVG',

Line 1997: fnd_message.raise_error;

1993: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
1994: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
1995: fnd_message.set_token('PL_ID',to_char(p_pl_id));
1996: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
1997: fnd_message.raise_error;
1998: end if;
1999: hr_utility.set_location (' Checking rate multiplier code others',50);
2000: if l_abr.rt_mlt_cd in ('FLFX','CL','AP','CVG','PRNT','CLANDCVG',
2001: 'APANDCVG','PRNTANDCVG') then

Line 2004: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

2000: if l_abr.rt_mlt_cd in ('FLFX','CL','AP','CVG','PRNT','CLANDCVG',
2001: 'APANDCVG','PRNTANDCVG') then
2002: if l_abr.val is null and l_abr.entr_val_at_enrt_flag = 'N' then
2003: --
2004: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2005: fnd_message.set_token('COLUMN','val');
2006: fnd_message.set_token('PACKAGE',l_package);
2007: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 2005: fnd_message.set_token('COLUMN','val');

2001: 'APANDCVG','PRNTANDCVG') then
2002: if l_abr.val is null and l_abr.entr_val_at_enrt_flag = 'N' then
2003: --
2004: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2005: fnd_message.set_token('COLUMN','val');
2006: fnd_message.set_token('PACKAGE',l_package);
2007: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2002: if l_abr.val is null and l_abr.entr_val_at_enrt_flag = 'N' then
2003: --
2004: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2005: fnd_message.set_token('COLUMN','val');
2006: fnd_message.set_token('PACKAGE',l_package);
2007: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2003: --
2004: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2005: fnd_message.set_token('COLUMN','val');
2006: fnd_message.set_token('PACKAGE',l_package);
2007: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2011: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

2004: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2005: fnd_message.set_token('COLUMN','val');
2006: fnd_message.set_token('PACKAGE',l_package);
2007: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2011: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2012: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

2005: fnd_message.set_token('COLUMN','val');
2006: fnd_message.set_token('PACKAGE',l_package);
2007: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2011: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2012: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2013: fnd_message.raise_error;

Line 2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

2006: fnd_message.set_token('PACKAGE',l_package);
2007: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2011: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2012: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2013: fnd_message.raise_error;
2014: end if;

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

2007: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2011: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2012: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2013: fnd_message.raise_error;
2014: end if;
2015: end if;

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

2008: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2011: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2012: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2013: fnd_message.raise_error;
2014: end if;
2015: end if;
2016: hr_utility.set_location (' Checking acty base rate values ',60);

Line 2013: fnd_message.raise_error;

2009: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2010: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2011: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2012: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2013: fnd_message.raise_error;
2014: end if;
2015: end if;
2016: hr_utility.set_location (' Checking acty base rate values ',60);
2017: --

Line 2026: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

2022: and nvl(l_env.mode_cd,'~') <> 'W' then
2023:
2024: if l_abr.mn_elcn_val is null then
2025: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2026: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2027: fnd_message.set_token('COLUMN','mn_elcn_val');
2028: fnd_message.set_token('PACKAGE',l_package);
2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 2027: fnd_message.set_token('COLUMN','mn_elcn_val');

2023:
2024: if l_abr.mn_elcn_val is null then
2025: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2026: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2027: fnd_message.set_token('COLUMN','mn_elcn_val');
2028: fnd_message.set_token('PACKAGE',l_package);
2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2024: if l_abr.mn_elcn_val is null then
2025: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2026: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2027: fnd_message.set_token('COLUMN','mn_elcn_val');
2028: fnd_message.set_token('PACKAGE',l_package);
2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2025: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2026: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2027: fnd_message.set_token('COLUMN','mn_elcn_val');
2028: fnd_message.set_token('PACKAGE',l_package);
2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2033: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

2026: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2027: fnd_message.set_token('COLUMN','mn_elcn_val');
2028: fnd_message.set_token('PACKAGE',l_package);
2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2033: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2034: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

2027: fnd_message.set_token('COLUMN','mn_elcn_val');
2028: fnd_message.set_token('PACKAGE',l_package);
2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2033: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2034: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2035: fnd_message.raise_error;

Line 2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

2028: fnd_message.set_token('PACKAGE',l_package);
2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2033: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2034: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2035: fnd_message.raise_error;
2036:

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

2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2033: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2034: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2035: fnd_message.raise_error;
2036:
2037: elsif l_abr.mx_elcn_val is null then

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

2030: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2033: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2034: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2035: fnd_message.raise_error;
2036:
2037: elsif l_abr.mx_elcn_val is null then
2038: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);

Line 2035: fnd_message.raise_error;

2031: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2032: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2033: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2034: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2035: fnd_message.raise_error;
2036:
2037: elsif l_abr.mx_elcn_val is null then
2038: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2039: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

Line 2039: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

2035: fnd_message.raise_error;
2036:
2037: elsif l_abr.mx_elcn_val is null then
2038: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2039: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2040: fnd_message.set_token('COLUMN','mx_elcn_val');
2041: fnd_message.set_token('PACKAGE',l_package);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 2040: fnd_message.set_token('COLUMN','mx_elcn_val');

2036:
2037: elsif l_abr.mx_elcn_val is null then
2038: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2039: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2040: fnd_message.set_token('COLUMN','mx_elcn_val');
2041: fnd_message.set_token('PACKAGE',l_package);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2037: elsif l_abr.mx_elcn_val is null then
2038: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2039: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2040: fnd_message.set_token('COLUMN','mx_elcn_val');
2041: fnd_message.set_token('PACKAGE',l_package);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2038: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2039: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2040: fnd_message.set_token('COLUMN','mx_elcn_val');
2041: fnd_message.set_token('PACKAGE',l_package);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2046: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

2039: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2040: fnd_message.set_token('COLUMN','mx_elcn_val');
2041: fnd_message.set_token('PACKAGE',l_package);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2046: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2047: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

2040: fnd_message.set_token('COLUMN','mx_elcn_val');
2041: fnd_message.set_token('PACKAGE',l_package);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2046: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2047: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2048: fnd_message.raise_error;

Line 2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

2041: fnd_message.set_token('PACKAGE',l_package);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2046: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2047: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2048: fnd_message.raise_error;
2049: elsif l_abr.incrmt_elcn_val is null then

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

2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2046: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2047: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2048: fnd_message.raise_error;
2049: elsif l_abr.incrmt_elcn_val is null then
2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);

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

2043: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2046: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2047: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2048: fnd_message.raise_error;
2049: elsif l_abr.incrmt_elcn_val is null then
2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

Line 2048: fnd_message.raise_error;

2044: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2045: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2046: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2047: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2048: fnd_message.raise_error;
2049: elsif l_abr.incrmt_elcn_val is null then
2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');

Line 2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

2047: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2048: fnd_message.raise_error;
2049: elsif l_abr.incrmt_elcn_val is null then
2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2053: fnd_message.set_token('PACKAGE',l_package);
2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');

2048: fnd_message.raise_error;
2049: elsif l_abr.incrmt_elcn_val is null then
2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2053: fnd_message.set_token('PACKAGE',l_package);
2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2049: elsif l_abr.incrmt_elcn_val is null then
2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2053: fnd_message.set_token('PACKAGE',l_package);
2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2053: fnd_message.set_token('PACKAGE',l_package);
2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2058: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2053: fnd_message.set_token('PACKAGE',l_package);
2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2058: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2059: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2053: fnd_message.set_token('PACKAGE',l_package);
2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2058: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2059: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2060: fnd_message.raise_error;

Line 2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

2053: fnd_message.set_token('PACKAGE',l_package);
2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2058: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2059: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2060: fnd_message.raise_error;
2061: end if;

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

2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2058: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2059: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2060: fnd_message.raise_error;
2061: end if;
2062: end if;

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

2055: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2058: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2059: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2060: fnd_message.raise_error;
2061: end if;
2062: end if;
2063:

Line 2060: fnd_message.raise_error;

2056: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2057: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2058: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2059: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2060: fnd_message.raise_error;
2061: end if;
2062: end if;
2063:
2064: hr_utility.set_location(' checking if program or plan ',70);

Line 2074: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');

2070: );
2071: fetch c_pgm into l_pgm;
2072: if c_pgm%notfound then
2073: close c_pgm;
2074: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
2075: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
2076: fnd_message.set_token('PACKAGE',l_package);
2077: fnd_message.raise_error;
2078: end if;

Line 2075: fnd_message.set_token('ID',to_char(l_epe.pgm_id));

2071: fetch c_pgm into l_pgm;
2072: if c_pgm%notfound then
2073: close c_pgm;
2074: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
2075: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
2076: fnd_message.set_token('PACKAGE',l_package);
2077: fnd_message.raise_error;
2078: end if;
2079: close c_pgm;

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

2072: if c_pgm%notfound then
2073: close c_pgm;
2074: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
2075: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
2076: fnd_message.set_token('PACKAGE',l_package);
2077: fnd_message.raise_error;
2078: end if;
2079: close c_pgm;
2080: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;

Line 2077: fnd_message.raise_error;

2073: close c_pgm;
2074: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
2075: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
2076: fnd_message.set_token('PACKAGE',l_package);
2077: fnd_message.raise_error;
2078: end if;
2079: close c_pgm;
2080: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
2081: l_enrt_info_rt_freq_cd := l_pgm.enrt_info_rt_freq_cd;

Line 2092: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');

2088: );
2089: fetch c_pln into l_pln;
2090: if c_pln%notfound then
2091: close c_pln;
2092: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
2093: fnd_message.set_token('ID',to_char(l_epe.pl_id));
2094: fnd_message.set_token('PACKAGE',l_package);
2095: fnd_message.raise_error;
2096: end if;

Line 2093: fnd_message.set_token('ID',to_char(l_epe.pl_id));

2089: fetch c_pln into l_pln;
2090: if c_pln%notfound then
2091: close c_pln;
2092: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
2093: fnd_message.set_token('ID',to_char(l_epe.pl_id));
2094: fnd_message.set_token('PACKAGE',l_package);
2095: fnd_message.raise_error;
2096: end if;
2097: close c_pln;

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

2090: if c_pln%notfound then
2091: close c_pln;
2092: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
2093: fnd_message.set_token('ID',to_char(l_epe.pl_id));
2094: fnd_message.set_token('PACKAGE',l_package);
2095: fnd_message.raise_error;
2096: end if;
2097: close c_pln;
2098: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;

Line 2095: fnd_message.raise_error;

2091: close c_pln;
2092: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
2093: fnd_message.set_token('ID',to_char(l_epe.pl_id));
2094: fnd_message.set_token('PACKAGE',l_package);
2095: fnd_message.raise_error;
2096: end if;
2097: close c_pln;
2098: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;
2099: l_enrt_info_rt_freq_cd := l_pln.nip_enrt_info_rt_freq_cd;

Line 2157: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');

2153: end if;
2154: --
2155: if l_coverage_value is null then
2156: if l_enrt_bnft_id is null then
2157: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');
2158: fnd_message.set_token('PACKAGE',l_package);
2159: fnd_message.set_token('PARAM','p_enrt_bnft_id');
2160: fnd_message.raise_error;
2161: end if;

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

2154: --
2155: if l_coverage_value is null then
2156: if l_enrt_bnft_id is null then
2157: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');
2158: fnd_message.set_token('PACKAGE',l_package);
2159: fnd_message.set_token('PARAM','p_enrt_bnft_id');
2160: fnd_message.raise_error;
2161: end if;
2162: open c_enb(l_enrt_bnft_id);

Line 2159: fnd_message.set_token('PARAM','p_enrt_bnft_id');

2155: if l_coverage_value is null then
2156: if l_enrt_bnft_id is null then
2157: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');
2158: fnd_message.set_token('PACKAGE',l_package);
2159: fnd_message.set_token('PARAM','p_enrt_bnft_id');
2160: fnd_message.raise_error;
2161: end if;
2162: open c_enb(l_enrt_bnft_id);
2163: fetch c_enb into l_val, l_dflt_val;

Line 2160: fnd_message.raise_error;

2156: if l_enrt_bnft_id is null then
2157: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');
2158: fnd_message.set_token('PACKAGE',l_package);
2159: fnd_message.set_token('PARAM','p_enrt_bnft_id');
2160: fnd_message.raise_error;
2161: end if;
2162: open c_enb(l_enrt_bnft_id);
2163: fetch c_enb into l_val, l_dflt_val;
2164: if c_enb%notfound then

Line 2166: fnd_message.set_name('BEN','BEN_92739_NO_ABR_ENB_EXISTS');

2162: open c_enb(l_enrt_bnft_id);
2163: fetch c_enb into l_val, l_dflt_val;
2164: if c_enb%notfound then
2165: close c_enb;
2166: fnd_message.set_name('BEN','BEN_92739_NO_ABR_ENB_EXISTS');
2167: fnd_message.raise_error;
2168: end if;
2169: close c_enb;
2170: --

Line 2167: fnd_message.raise_error;

2163: fetch c_enb into l_val, l_dflt_val;
2164: if c_enb%notfound then
2165: close c_enb;
2166: fnd_message.set_name('BEN','BEN_92739_NO_ABR_ENB_EXISTS');
2167: fnd_message.raise_error;
2168: end if;
2169: close c_enb;
2170: --
2171: l_coverage_value := nvl(l_val, l_dflt_val);

Line 2181: fnd_message.set_name('BEN','BEN_92740_NO_OIPL_CCM_ATTACH');

2177: );
2178: fetch c_cvg_oipl into l_cvg_calc_amt_mthd_id;
2179: if c_cvg_oipl%notfound then
2180: close c_cvg_oipl;
2181: fnd_message.set_name('BEN','BEN_92740_NO_OIPL_CCM_ATTACH');
2182: fnd_message.raise_error;
2183: end if;
2184: close c_cvg_oipl;
2185: elsif l_epe.pl_id is not NULL then

Line 2182: fnd_message.raise_error;

2178: fetch c_cvg_oipl into l_cvg_calc_amt_mthd_id;
2179: if c_cvg_oipl%notfound then
2180: close c_cvg_oipl;
2181: fnd_message.set_name('BEN','BEN_92740_NO_OIPL_CCM_ATTACH');
2182: fnd_message.raise_error;
2183: end if;
2184: close c_cvg_oipl;
2185: elsif l_epe.pl_id is not NULL then
2186: open c_cvg_pl

Line 2192: fnd_message.set_name('BEN','BEN_92741_NO_PLN_CCM_ATTACH');

2188: );
2189: fetch c_cvg_pl into l_cvg_calc_amt_mthd_id;
2190: if c_cvg_pl%notfound then
2191: close c_cvg_pl;
2192: fnd_message.set_name('BEN','BEN_92741_NO_PLN_CCM_ATTACH');
2193: fnd_message.raise_error;
2194: end if;
2195: close c_cvg_pl;
2196: else

Line 2193: fnd_message.raise_error;

2189: fetch c_cvg_pl into l_cvg_calc_amt_mthd_id;
2190: if c_cvg_pl%notfound then
2191: close c_cvg_pl;
2192: fnd_message.set_name('BEN','BEN_92741_NO_PLN_CCM_ATTACH');
2193: fnd_message.raise_error;
2194: end if;
2195: close c_cvg_pl;
2196: else
2197: fnd_message.set_name('BEN','BEN_92744_ABR_ENB_NULL');

Line 2197: fnd_message.set_name('BEN','BEN_92744_ABR_ENB_NULL');

2193: fnd_message.raise_error;
2194: end if;
2195: close c_cvg_pl;
2196: else
2197: fnd_message.set_name('BEN','BEN_92744_ABR_ENB_NULL');
2198: fnd_message.raise_error;
2199: end if;
2200: p_cvg_calc_amt_mthd_id := l_cvg_calc_amt_mthd_id;
2201: end if;

Line 2198: fnd_message.raise_error;

2194: end if;
2195: close c_cvg_pl;
2196: else
2197: fnd_message.set_name('BEN','BEN_92744_ABR_ENB_NULL');
2198: fnd_message.raise_error;
2199: end if;
2200: p_cvg_calc_amt_mthd_id := l_cvg_calc_amt_mthd_id;
2201: end if;
2202: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);

Line 2205: fnd_message.set_name('BEN','BEN_92745_NO_ABR_CLF_EXISTS');

2201: end if;
2202: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);
2203: if l_abr.rt_mlt_cd in ('CL','CLANDCVG') then
2204: if l_abr.comp_lvl_fctr_id is null then
2205: fnd_message.set_name('BEN','BEN_92745_NO_ABR_CLF_EXISTS');
2206: fnd_message.raise_error;
2207: end if;
2208: p_comp_lvl_fctr_id := l_abr.comp_lvl_fctr_id;
2209: ben_derive_factors.determine_compensation

Line 2206: fnd_message.raise_error;

2202: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);
2203: if l_abr.rt_mlt_cd in ('CL','CLANDCVG') then
2204: if l_abr.comp_lvl_fctr_id is null then
2205: fnd_message.set_name('BEN','BEN_92745_NO_ABR_CLF_EXISTS');
2206: fnd_message.raise_error;
2207: end if;
2208: p_comp_lvl_fctr_id := l_abr.comp_lvl_fctr_id;
2209: ben_derive_factors.determine_compensation
2210: (p_comp_lvl_fctr_id => l_abr.comp_lvl_fctr_id,

Line 2227: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');

2223: p_fonm_rt_strt_dt => l_fonm_rt_strt_dt );
2224:
2225:
2226: if l_compensation_value is null then
2227: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');
2228: fnd_message.set_token('PACKAGE',l_package);
2229: fnd_message.set_token('VARIABLE','l_compensation_value');
2230: fnd_message.raise_error;
2231: end if;

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

2224:
2225:
2226: if l_compensation_value is null then
2227: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');
2228: fnd_message.set_token('PACKAGE',l_package);
2229: fnd_message.set_token('VARIABLE','l_compensation_value');
2230: fnd_message.raise_error;
2231: end if;
2232: end if;

Line 2229: fnd_message.set_token('VARIABLE','l_compensation_value');

2225:
2226: if l_compensation_value is null then
2227: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');
2228: fnd_message.set_token('PACKAGE',l_package);
2229: fnd_message.set_token('VARIABLE','l_compensation_value');
2230: fnd_message.raise_error;
2231: end if;
2232: end if;
2233: hr_utility.set_location ('ABR_RTMLTCD AP '||l_package,10);

Line 2230: fnd_message.raise_error;

2226: if l_compensation_value is null then
2227: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');
2228: fnd_message.set_token('PACKAGE',l_package);
2229: fnd_message.set_token('VARIABLE','l_compensation_value');
2230: fnd_message.raise_error;
2231: end if;
2232: end if;
2233: hr_utility.set_location ('ABR_RTMLTCD AP '||l_package,10);
2234: if l_abr.rt_mlt_cd in ('AP','APANDCVG') then

Line 2302: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');

2298: --
2299: end if;
2300:
2301: if l_actl_prem_value is null then
2302: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');
2303: hr_utility.set_location (' FNDMS_RE 1 ',130);
2304: fnd_message.raise_error;
2305: end if;
2306: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);

Line 2304: fnd_message.raise_error;

2300:
2301: if l_actl_prem_value is null then
2302: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');
2303: hr_utility.set_location (' FNDMS_RE 1 ',130);
2304: fnd_message.raise_error;
2305: end if;
2306: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);
2307: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);
2308: --

Line 2334: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');

2330: --
2331: l_actl_prem_value := l_actl_prem_value * 12 / l_pay_annualization_factor;
2332: --
2333: else
2334: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2335: fnd_message.set_token('PROC',l_package);
2336: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2337: hr_utility.set_location (' FNDMS_RE 2 ',150);
2338: fnd_message.raise_error;

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

2331: l_actl_prem_value := l_actl_prem_value * 12 / l_pay_annualization_factor;
2332: --
2333: else
2334: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2335: fnd_message.set_token('PROC',l_package);
2336: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2337: hr_utility.set_location (' FNDMS_RE 2 ',150);
2338: fnd_message.raise_error;
2339: end if;

Line 2336: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);

2332: --
2333: else
2334: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2335: fnd_message.set_token('PROC',l_package);
2336: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2337: hr_utility.set_location (' FNDMS_RE 2 ',150);
2338: fnd_message.raise_error;
2339: end if;
2340: end if; --'D'

Line 2338: fnd_message.raise_error;

2334: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2335: fnd_message.set_token('PROC',l_package);
2336: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2337: hr_utility.set_location (' FNDMS_RE 2 ',150);
2338: fnd_message.raise_error;
2339: end if;
2340: end if; --'D'
2341: end if;
2342: hr_utility.set_location ('ABR_RTMLTCD PRNT '||l_package,10);

Line 2350: fnd_message.set_name('BEN','BEN_92742_NO_PRNT_ABR_EXISTS');

2346: );
2347: fetch c_abr2 into l_acty_base_rt_id ,l_prnt_entr_val_at_enrt_flag;
2348: if c_abr2%notfound then
2349: close c_abr2;
2350: fnd_message.set_name('BEN','BEN_92742_NO_PRNT_ABR_EXISTS');
2351: fnd_message.raise_error;
2352: end if;
2353: close c_abr2;
2354: /*

Line 2351: fnd_message.raise_error;

2347: fetch c_abr2 into l_acty_base_rt_id ,l_prnt_entr_val_at_enrt_flag;
2348: if c_abr2%notfound then
2349: close c_abr2;
2350: fnd_message.set_name('BEN','BEN_92742_NO_PRNT_ABR_EXISTS');
2351: fnd_message.raise_error;
2352: end if;
2353: close c_abr2;
2354: /*
2355: --

Line 2360: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');

2356: -- MH - removed this could never occur because BEN_92742_NO_PRNT_ABR_EXISTS
2357: -- would be raised
2358: --
2359: if l_acty_base_rt_id is null then
2360: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2361: fnd_message.set_token('PACKAGE',l_package);
2362: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2363: fnd_message.raise_error;
2364: end if;

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

2357: -- would be raised
2358: --
2359: if l_acty_base_rt_id is null then
2360: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2361: fnd_message.set_token('PACKAGE',l_package);
2362: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2363: fnd_message.raise_error;
2364: end if;
2365: */

Line 2362: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');

2358: --
2359: if l_acty_base_rt_id is null then
2360: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2361: fnd_message.set_token('PACKAGE',l_package);
2362: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2363: fnd_message.raise_error;
2364: end if;
2365: */
2366: hr_utility.set_location ('St BDABR_MN Sub '||l_package,10);

Line 2363: fnd_message.raise_error;

2359: if l_acty_base_rt_id is null then
2360: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2361: fnd_message.set_token('PACKAGE',l_package);
2362: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2363: fnd_message.raise_error;
2364: end if;
2365: */
2366: hr_utility.set_location ('St BDABR_MN Sub '||l_package,10);
2367: if l_prnt_entr_val_at_enrt_flag = 'Y' then

Line 2445: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');

2441: -- process
2442: if l_prnt_rt_value is null
2443: and nvl(l_prnt_entr_val_at_enrt_flag,'N') <> 'Y'
2444: then
2445: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2446: fnd_message.set_token('PACKAGE',l_package);
2447: fnd_message.set_token('VARIABLE','l_prnt_rt_value');
2448: fnd_message.raise_error;
2449: end if;

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

2442: if l_prnt_rt_value is null
2443: and nvl(l_prnt_entr_val_at_enrt_flag,'N') <> 'Y'
2444: then
2445: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2446: fnd_message.set_token('PACKAGE',l_package);
2447: fnd_message.set_token('VARIABLE','l_prnt_rt_value');
2448: fnd_message.raise_error;
2449: end if;
2450: --

Line 2447: fnd_message.set_token('VARIABLE','l_prnt_rt_value');

2443: and nvl(l_prnt_entr_val_at_enrt_flag,'N') <> 'Y'
2444: then
2445: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2446: fnd_message.set_token('PACKAGE',l_package);
2447: fnd_message.set_token('VARIABLE','l_prnt_rt_value');
2448: fnd_message.raise_error;
2449: end if;
2450: --
2451: end if;

Line 2448: fnd_message.raise_error;

2444: then
2445: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2446: fnd_message.set_token('PACKAGE',l_package);
2447: fnd_message.set_token('VARIABLE','l_prnt_rt_value');
2448: fnd_message.raise_error;
2449: end if;
2450: --
2451: end if;
2452:

Line 2479: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');

2475: open c_pl_opt_name;
2476: fetch c_pl_opt_name into l_pl_opt_name;
2477: close c_pl_opt_name;
2478:
2479: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2480: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2481: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2482: fnd_message.set_token('PLOPT',l_pl_opt_name);
2483: fnd_message.raise_error;

Line 2480: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));

2476: fetch c_pl_opt_name into l_pl_opt_name;
2477: close c_pl_opt_name;
2478:
2479: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2480: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2481: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2482: fnd_message.set_token('PLOPT',l_pl_opt_name);
2483: fnd_message.raise_error;
2484:

Line 2481: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));

2477: close c_pl_opt_name;
2478:
2479: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2480: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2481: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2482: fnd_message.set_token('PLOPT',l_pl_opt_name);
2483: fnd_message.raise_error;
2484:
2485: elsif (mod(p_cal_val,nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val))

Line 2482: fnd_message.set_token('PLOPT',l_pl_opt_name);

2478:
2479: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2480: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2481: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2482: fnd_message.set_token('PLOPT',l_pl_opt_name);
2483: fnd_message.raise_error;
2484:
2485: elsif (mod(p_cal_val,nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val))
2486: <>0) then

Line 2483: fnd_message.raise_error;

2479: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2480: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2481: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2482: fnd_message.set_token('PLOPT',l_pl_opt_name);
2483: fnd_message.raise_error;
2484:
2485: elsif (mod(p_cal_val,nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val))
2486: <>0) then
2487: --

Line 2497: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');

2493: fetch c_pl_opt_name into l_pl_opt_name;
2494: close c_pl_opt_name;
2495: -- end # 1699585
2496:
2497: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
2498: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));
2499: fnd_message.set_token('PLAN', l_pl_opt_name);
2500: fnd_message.raise_error;
2501:

Line 2498: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));

2494: close c_pl_opt_name;
2495: -- end # 1699585
2496:
2497: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
2498: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));
2499: fnd_message.set_token('PLAN', l_pl_opt_name);
2500: fnd_message.raise_error;
2501:
2502: End if;

Line 2499: fnd_message.set_token('PLAN', l_pl_opt_name);

2495: -- end # 1699585
2496:
2497: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
2498: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));
2499: fnd_message.set_token('PLAN', l_pl_opt_name);
2500: fnd_message.raise_error;
2501:
2502: End if;
2503:

Line 2500: fnd_message.raise_error;

2496:
2497: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
2498: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));
2499: fnd_message.set_token('PLAN', l_pl_opt_name);
2500: fnd_message.raise_error;
2501:
2502: End if;
2503:
2504:

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

2870: close c_pgr ;
2871: hr_utility.set_location('GSP value '|| l_val ,551) ;
2872:
2873: else
2874: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2875: fnd_message.set_token('PROC',l_package);
2876: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2877: fnd_message.raise_error;
2878: end if;

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

2871: hr_utility.set_location('GSP value '|| l_val ,551) ;
2872:
2873: else
2874: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2875: fnd_message.set_token('PROC',l_package);
2876: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2877: fnd_message.raise_error;
2878: end if;
2879: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);

Line 2876: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);

2872:
2873: else
2874: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2875: fnd_message.set_token('PROC',l_package);
2876: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2877: fnd_message.raise_error;
2878: end if;
2879: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);
2880: --

Line 2877: fnd_message.raise_error;

2873: else
2874: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2875: fnd_message.set_token('PROC',l_package);
2876: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2877: fnd_message.raise_error;
2878: end if;
2879: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);
2880: --
2881: -- set some of the outputs