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

1279: --
1280: -- Ensure relevant parameters have been populated with values
1281: --
1282: if p_acty_base_rt_id is null then
1283: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1284: fnd_message.set_token('PACKAGE',l_package);
1285: fnd_message.set_token('PROC','Standard Rates');
1286: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1287: fnd_message.raise_error;

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

1280: -- Ensure relevant parameters have been populated with values
1281: --
1282: if p_acty_base_rt_id is null then
1283: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1284: fnd_message.set_token('PACKAGE',l_package);
1285: fnd_message.set_token('PROC','Standard Rates');
1286: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1287: fnd_message.raise_error;
1288: elsif p_person_id is null then

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

1281: --
1282: if p_acty_base_rt_id is null then
1283: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1284: fnd_message.set_token('PACKAGE',l_package);
1285: fnd_message.set_token('PROC','Standard Rates');
1286: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1287: fnd_message.raise_error;
1288: elsif p_person_id is null then
1289: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

1282: if p_acty_base_rt_id is null then
1283: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1284: fnd_message.set_token('PACKAGE',l_package);
1285: fnd_message.set_token('PROC','Standard Rates');
1286: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1287: fnd_message.raise_error;
1288: elsif p_person_id is null then
1289: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1290: fnd_message.set_token('PACKAGE',l_package);

Line 1287: fnd_message.raise_error;

1283: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1284: fnd_message.set_token('PACKAGE',l_package);
1285: fnd_message.set_token('PROC','Standard Rates');
1286: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1287: fnd_message.raise_error;
1288: elsif p_person_id is null then
1289: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1290: fnd_message.set_token('PACKAGE',l_package);
1291: fnd_message.set_token('PROC','Standard Rates');

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

1285: fnd_message.set_token('PROC','Standard Rates');
1286: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1287: fnd_message.raise_error;
1288: elsif p_person_id is null then
1289: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1290: fnd_message.set_token('PACKAGE',l_package);
1291: fnd_message.set_token('PROC','Standard Rates');
1292: fnd_message.set_token('PARAM','p_person_id');
1293: fnd_message.raise_error;

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

1286: fnd_message.set_token('PARAM','p_acty_base_rt_id');
1287: fnd_message.raise_error;
1288: elsif p_person_id is null then
1289: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1290: fnd_message.set_token('PACKAGE',l_package);
1291: fnd_message.set_token('PROC','Standard Rates');
1292: fnd_message.set_token('PARAM','p_person_id');
1293: fnd_message.raise_error;
1294: elsif p_effective_date is null then

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

1287: fnd_message.raise_error;
1288: elsif p_person_id is null then
1289: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1290: fnd_message.set_token('PACKAGE',l_package);
1291: fnd_message.set_token('PROC','Standard Rates');
1292: fnd_message.set_token('PARAM','p_person_id');
1293: fnd_message.raise_error;
1294: elsif p_effective_date is null then
1295: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

1288: elsif p_person_id is null then
1289: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1290: fnd_message.set_token('PACKAGE',l_package);
1291: fnd_message.set_token('PROC','Standard Rates');
1292: fnd_message.set_token('PARAM','p_person_id');
1293: fnd_message.raise_error;
1294: elsif p_effective_date is null then
1295: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1296: fnd_message.set_token('PACKAGE',l_package);

Line 1293: fnd_message.raise_error;

1289: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1290: fnd_message.set_token('PACKAGE',l_package);
1291: fnd_message.set_token('PROC','Standard Rates');
1292: fnd_message.set_token('PARAM','p_person_id');
1293: fnd_message.raise_error;
1294: elsif p_effective_date is null then
1295: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1296: fnd_message.set_token('PACKAGE',l_package);
1297: fnd_message.set_token('PROC','Standard Rates');

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

1291: fnd_message.set_token('PROC','Standard Rates');
1292: fnd_message.set_token('PARAM','p_person_id');
1293: fnd_message.raise_error;
1294: elsif p_effective_date is null then
1295: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1296: fnd_message.set_token('PACKAGE',l_package);
1297: fnd_message.set_token('PROC','Standard Rates');
1298: fnd_message.set_token('PARAM','p_effective_date');
1299: fnd_message.raise_error;

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

1292: fnd_message.set_token('PARAM','p_person_id');
1293: fnd_message.raise_error;
1294: elsif p_effective_date is null then
1295: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1296: fnd_message.set_token('PACKAGE',l_package);
1297: fnd_message.set_token('PROC','Standard Rates');
1298: fnd_message.set_token('PARAM','p_effective_date');
1299: fnd_message.raise_error;
1300: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then

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

1293: fnd_message.raise_error;
1294: elsif p_effective_date is null then
1295: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1296: fnd_message.set_token('PACKAGE',l_package);
1297: fnd_message.set_token('PROC','Standard Rates');
1298: fnd_message.set_token('PARAM','p_effective_date');
1299: fnd_message.raise_error;
1300: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1301: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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

1294: elsif p_effective_date is null then
1295: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1296: fnd_message.set_token('PACKAGE',l_package);
1297: fnd_message.set_token('PROC','Standard Rates');
1298: fnd_message.set_token('PARAM','p_effective_date');
1299: fnd_message.raise_error;
1300: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1301: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1302: fnd_message.set_token('PACKAGE',l_package);

Line 1299: fnd_message.raise_error;

1295: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1296: fnd_message.set_token('PACKAGE',l_package);
1297: fnd_message.set_token('PROC','Standard Rates');
1298: fnd_message.set_token('PARAM','p_effective_date');
1299: fnd_message.raise_error;
1300: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1301: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1302: fnd_message.set_token('PACKAGE',l_package);
1303: fnd_message.set_token('PROC','Standard Rates');

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

1297: fnd_message.set_token('PROC','Standard Rates');
1298: fnd_message.set_token('PARAM','p_effective_date');
1299: fnd_message.raise_error;
1300: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1301: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1302: fnd_message.set_token('PACKAGE',l_package);
1303: fnd_message.set_token('PROC','Standard Rates');
1304: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1305: fnd_message.raise_error;

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

1298: fnd_message.set_token('PARAM','p_effective_date');
1299: fnd_message.raise_error;
1300: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1301: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1302: fnd_message.set_token('PACKAGE',l_package);
1303: fnd_message.set_token('PROC','Standard Rates');
1304: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1305: fnd_message.raise_error;
1306: end if;

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

1299: fnd_message.raise_error;
1300: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1301: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1302: fnd_message.set_token('PACKAGE',l_package);
1303: fnd_message.set_token('PROC','Standard Rates');
1304: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1305: fnd_message.raise_error;
1306: end if;
1307: hr_utility.set_location (' Checking Electable Choice ',20);

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

1300: elsif p_elig_per_elctbl_chc_id is null and not(p_calc_only_rt_val_flag) then
1301: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1302: fnd_message.set_token('PACKAGE',l_package);
1303: fnd_message.set_token('PROC','Standard Rates');
1304: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1305: fnd_message.raise_error;
1306: end if;
1307: hr_utility.set_location (' Checking Electable Choice ',20);
1308: --

Line 1305: fnd_message.raise_error;

1301: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
1302: fnd_message.set_token('PACKAGE',l_package);
1303: fnd_message.set_token('PROC','Standard Rates');
1304: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1305: fnd_message.raise_error;
1306: end if;
1307: hr_utility.set_location (' Checking Electable Choice ',20);
1308: --
1309: -- Populate electable choice information

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

1350: open c_epe;
1351: fetch c_epe into l_epe;
1352: if c_epe%notfound then
1353: close c_epe;
1354: fnd_message.set_name('BEN','BEN_92743_NO_ABR_EPE_EXISTS');
1355: fnd_message.raise_error;
1356: end if;
1357: close c_epe;
1358: end if;

Line 1355: fnd_message.raise_error;

1351: fetch c_epe into l_epe;
1352: if c_epe%notfound then
1353: close c_epe;
1354: fnd_message.set_name('BEN','BEN_92743_NO_ABR_EPE_EXISTS');
1355: fnd_message.raise_error;
1356: end if;
1357: close c_epe;
1358: end if;
1359: hr_utility.set_location ('Dn Pop EPE'||l_package,10);

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

1381: );
1382: fetch c_abr into l_abr;
1383: if c_abr%notfound then
1384: close c_abr;
1385: fnd_message.set_name('BEN','BEN_92738_NO_ABR_EXISTS');
1386: fnd_message.raise_error;
1387: end if;
1388: close c_abr;
1389: --

Line 1386: fnd_message.raise_error;

1382: fetch c_abr into l_abr;
1383: if c_abr%notfound then
1384: close c_abr;
1385: fnd_message.set_name('BEN','BEN_92738_NO_ABR_EXISTS');
1386: fnd_message.raise_error;
1387: end if;
1388: close c_abr;
1389: --
1390: if l_abr.acty_typ_cd in ('CWBWB','CWBDB') then

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

1510: --
1511: EXCEPTION
1512: WHEN OTHERS
1513: THEN
1514: fnd_message.set_name ('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
1515: fnd_message.set_token ('PROC', l_package);
1516: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1517: fnd_message.set_token ('PARAMETER',
1518: l_outputs (l_outputs.COUNT).NAME

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

1511: EXCEPTION
1512: WHEN OTHERS
1513: THEN
1514: fnd_message.set_name ('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
1515: fnd_message.set_token ('PROC', l_package);
1516: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1517: fnd_message.set_token ('PARAMETER',
1518: l_outputs (l_outputs.COUNT).NAME
1519: );

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

1512: WHEN OTHERS
1513: THEN
1514: fnd_message.set_name ('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
1515: fnd_message.set_token ('PROC', l_package);
1516: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1517: fnd_message.set_token ('PARAMETER',
1518: l_outputs (l_outputs.COUNT).NAME
1519: );
1520: fnd_message.raise_error;

Line 1517: fnd_message.set_token ('PARAMETER',

1513: THEN
1514: fnd_message.set_name ('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
1515: fnd_message.set_token ('PROC', l_package);
1516: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1517: fnd_message.set_token ('PARAMETER',
1518: l_outputs (l_outputs.COUNT).NAME
1519: );
1520: fnd_message.raise_error;
1521: END;

Line 1520: fnd_message.raise_error;

1516: fnd_message.set_token ('FORMULA', l_abr.input_va_calc_rl);
1517: fnd_message.set_token ('PARAMETER',
1518: l_outputs (l_outputs.COUNT).NAME
1519: );
1520: fnd_message.raise_error;
1521: END;
1522: --
1523: END IF;
1524:

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

2016: l_abr.dflt_val := fnd_number.canonical_to_number(l_outputs(l_count).value);
2017: end if;
2018: exception
2019: when others then
2020: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2021: fnd_message.set_token('PROC',l_package);
2022: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
2023: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2024: fnd_message.raise_error;

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

2017: end if;
2018: exception
2019: when others then
2020: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2021: fnd_message.set_token('PROC',l_package);
2022: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
2023: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2024: fnd_message.raise_error;
2025: end;

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

2018: exception
2019: when others then
2020: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2021: fnd_message.set_token('PROC',l_package);
2022: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
2023: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2024: fnd_message.raise_error;
2025: end;
2026: end loop;

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

2019: when others then
2020: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2021: fnd_message.set_token('PROC',l_package);
2022: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
2023: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2024: fnd_message.raise_error;
2025: end;
2026: end loop;
2027: else

Line 2024: fnd_message.raise_error;

2020: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2021: fnd_message.set_token('PROC',l_package);
2022: fnd_message.set_token('FORMULA',l_abr.mn_mx_elcn_rl);
2023: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2024: fnd_message.raise_error;
2025: end;
2026: end loop;
2027: else
2028: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');

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

2024: fnd_message.raise_error;
2025: end;
2026: end loop;
2027: else
2028: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');
2029: fnd_message.raise_error;
2030: end if;
2031: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
2032: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);

Line 2029: fnd_message.raise_error;

2025: end;
2026: end loop;
2027: else
2028: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');
2029: fnd_message.raise_error;
2030: end if;
2031: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
2032: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
2033: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);

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

2044: close c_state;
2045: */
2046: hr_utility.set_location (' Checking rate multiplier code ',40);
2047: if l_abr.rt_mlt_cd is null then
2048: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2049: fnd_message.set_token('COLUMN','rt_mlt_cd');
2050: fnd_message.set_token('PACKAGE',l_package);
2051: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2052: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

2045: */
2046: hr_utility.set_location (' Checking rate multiplier code ',40);
2047: if l_abr.rt_mlt_cd is null then
2048: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2049: fnd_message.set_token('COLUMN','rt_mlt_cd');
2050: fnd_message.set_token('PACKAGE',l_package);
2051: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2052: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2053: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2046: hr_utility.set_location (' Checking rate multiplier code ',40);
2047: if l_abr.rt_mlt_cd is null then
2048: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2049: fnd_message.set_token('COLUMN','rt_mlt_cd');
2050: fnd_message.set_token('PACKAGE',l_package);
2051: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2052: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2053: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2054: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2047: if l_abr.rt_mlt_cd is null then
2048: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2049: fnd_message.set_token('COLUMN','rt_mlt_cd');
2050: fnd_message.set_token('PACKAGE',l_package);
2051: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2052: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2053: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2054: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2055: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

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

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

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

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

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

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

2051: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2052: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2053: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2054: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2055: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2056: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2057: fnd_message.raise_error;
2058: end if;
2059: hr_utility.set_location (' Checking rate multiplier code others',50);

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

2052: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2053: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2054: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2055: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2056: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2057: fnd_message.raise_error;
2058: end if;
2059: hr_utility.set_location (' Checking rate multiplier code others',50);
2060: if l_abr.rt_mlt_cd in ('FLFX','CL','AP','CVG','PRNT','CLANDCVG',

Line 2057: fnd_message.raise_error;

2053: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2054: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2055: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2056: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2057: fnd_message.raise_error;
2058: end if;
2059: hr_utility.set_location (' Checking rate multiplier code others',50);
2060: if l_abr.rt_mlt_cd in ('FLFX','CL','AP','CVG','PRNT','CLANDCVG',
2061: 'APANDCVG','PRNTANDCVG') then

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

2060: if l_abr.rt_mlt_cd in ('FLFX','CL','AP','CVG','PRNT','CLANDCVG',
2061: 'APANDCVG','PRNTANDCVG') then
2062: if l_abr.val is null and l_abr.entr_val_at_enrt_flag = 'N' then
2063: --
2064: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2065: fnd_message.set_token('COLUMN','val');
2066: fnd_message.set_token('PACKAGE',l_package);
2067: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

2061: 'APANDCVG','PRNTANDCVG') then
2062: if l_abr.val is null and l_abr.entr_val_at_enrt_flag = 'N' then
2063: --
2064: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2065: fnd_message.set_token('COLUMN','val');
2066: fnd_message.set_token('PACKAGE',l_package);
2067: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2062: if l_abr.val is null and l_abr.entr_val_at_enrt_flag = 'N' then
2063: --
2064: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2065: fnd_message.set_token('COLUMN','val');
2066: fnd_message.set_token('PACKAGE',l_package);
2067: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2070: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2063: --
2064: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2065: fnd_message.set_token('COLUMN','val');
2066: fnd_message.set_token('PACKAGE',l_package);
2067: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2070: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2071: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

2064: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2065: fnd_message.set_token('COLUMN','val');
2066: fnd_message.set_token('PACKAGE',l_package);
2067: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2070: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2071: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2072: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

2065: fnd_message.set_token('COLUMN','val');
2066: fnd_message.set_token('PACKAGE',l_package);
2067: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2070: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2071: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2072: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2073: fnd_message.raise_error;

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

2066: fnd_message.set_token('PACKAGE',l_package);
2067: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2070: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2071: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2072: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2073: fnd_message.raise_error;
2074: end if;

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

2067: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2070: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2071: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2072: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2073: fnd_message.raise_error;
2074: end if;
2075: end if;

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

2068: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2070: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2071: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2072: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2073: fnd_message.raise_error;
2074: end if;
2075: end if;
2076: hr_utility.set_location (' Checking acty base rate values ',60);

Line 2073: fnd_message.raise_error;

2069: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2070: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2071: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2072: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2073: fnd_message.raise_error;
2074: end if;
2075: end if;
2076: hr_utility.set_location (' Checking acty base rate values ',60);
2077: --

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

2082: and nvl(l_env.mode_cd,'~') <> 'W' then
2083:
2084: if l_abr.mn_elcn_val is null then
2085: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2086: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2087: fnd_message.set_token('COLUMN','mn_elcn_val');
2088: fnd_message.set_token('PACKAGE',l_package);
2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

2083:
2084: if l_abr.mn_elcn_val is null then
2085: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2086: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2087: fnd_message.set_token('COLUMN','mn_elcn_val');
2088: fnd_message.set_token('PACKAGE',l_package);
2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2084: if l_abr.mn_elcn_val is null then
2085: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2086: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2087: fnd_message.set_token('COLUMN','mn_elcn_val');
2088: fnd_message.set_token('PACKAGE',l_package);
2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2092: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2085: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2086: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2087: fnd_message.set_token('COLUMN','mn_elcn_val');
2088: fnd_message.set_token('PACKAGE',l_package);
2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2092: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2093: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

2086: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2087: fnd_message.set_token('COLUMN','mn_elcn_val');
2088: fnd_message.set_token('PACKAGE',l_package);
2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2092: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2093: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2094: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

2087: fnd_message.set_token('COLUMN','mn_elcn_val');
2088: fnd_message.set_token('PACKAGE',l_package);
2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2092: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2093: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2094: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2095: fnd_message.raise_error;

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

2088: fnd_message.set_token('PACKAGE',l_package);
2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2092: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2093: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2094: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2095: fnd_message.raise_error;
2096:

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

2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2092: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2093: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2094: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2095: fnd_message.raise_error;
2096:
2097: elsif l_abr.mx_elcn_val is null then

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

2090: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2092: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2093: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2094: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2095: fnd_message.raise_error;
2096:
2097: elsif l_abr.mx_elcn_val is null then
2098: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);

Line 2095: fnd_message.raise_error;

2091: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2092: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2093: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2094: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2095: fnd_message.raise_error;
2096:
2097: elsif l_abr.mx_elcn_val is null then
2098: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2099: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

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

2095: fnd_message.raise_error;
2096:
2097: elsif l_abr.mx_elcn_val is null then
2098: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2099: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2100: fnd_message.set_token('COLUMN','mx_elcn_val');
2101: fnd_message.set_token('PACKAGE',l_package);
2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

2096:
2097: elsif l_abr.mx_elcn_val is null then
2098: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2099: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2100: fnd_message.set_token('COLUMN','mx_elcn_val');
2101: fnd_message.set_token('PACKAGE',l_package);
2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2097: elsif l_abr.mx_elcn_val is null then
2098: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2099: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2100: fnd_message.set_token('COLUMN','mx_elcn_val');
2101: fnd_message.set_token('PACKAGE',l_package);
2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2105: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2098: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2099: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2100: fnd_message.set_token('COLUMN','mx_elcn_val');
2101: fnd_message.set_token('PACKAGE',l_package);
2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2105: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2106: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

2099: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2100: fnd_message.set_token('COLUMN','mx_elcn_val');
2101: fnd_message.set_token('PACKAGE',l_package);
2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2105: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2106: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2107: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

2100: fnd_message.set_token('COLUMN','mx_elcn_val');
2101: fnd_message.set_token('PACKAGE',l_package);
2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2105: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2106: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2107: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2108: fnd_message.raise_error;

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

2101: fnd_message.set_token('PACKAGE',l_package);
2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2105: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2106: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2107: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2108: fnd_message.raise_error;
2109: elsif l_abr.incrmt_elcn_val is null then

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

2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2105: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2106: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2107: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2108: fnd_message.raise_error;
2109: elsif l_abr.incrmt_elcn_val is null then
2110: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);

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

2103: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2105: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2106: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2107: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2108: fnd_message.raise_error;
2109: elsif l_abr.incrmt_elcn_val is null then
2110: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2111: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');

Line 2108: fnd_message.raise_error;

2104: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2105: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2106: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2107: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2108: fnd_message.raise_error;
2109: elsif l_abr.incrmt_elcn_val is null then
2110: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2111: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2112: fnd_message.set_token('COLUMN','incrmt_elcn_val');

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

2107: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2108: fnd_message.raise_error;
2109: elsif l_abr.incrmt_elcn_val is null then
2110: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2111: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2112: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2113: fnd_message.set_token('PACKAGE',l_package);
2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

2108: fnd_message.raise_error;
2109: elsif l_abr.incrmt_elcn_val is null then
2110: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2111: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2112: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2113: fnd_message.set_token('PACKAGE',l_package);
2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

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

2109: elsif l_abr.incrmt_elcn_val is null then
2110: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2111: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2112: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2113: fnd_message.set_token('PACKAGE',l_package);
2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2117: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

2110: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2111: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2112: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2113: fnd_message.set_token('PACKAGE',l_package);
2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2117: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2118: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

2111: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2112: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2113: fnd_message.set_token('PACKAGE',l_package);
2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2117: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2118: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2119: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

2112: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2113: fnd_message.set_token('PACKAGE',l_package);
2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2117: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2118: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2119: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2120: fnd_message.raise_error;

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

2113: fnd_message.set_token('PACKAGE',l_package);
2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2117: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2118: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2119: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2120: fnd_message.raise_error;
2121: end if;

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

2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2117: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2118: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2119: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2120: fnd_message.raise_error;
2121: end if;
2122: end if;

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

2115: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2117: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2118: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2119: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2120: fnd_message.raise_error;
2121: end if;
2122: end if;
2123:

Line 2120: fnd_message.raise_error;

2116: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
2117: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
2118: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2119: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2120: fnd_message.raise_error;
2121: end if;
2122: end if;
2123:
2124: hr_utility.set_location(' checking if program or plan ',70);

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

2130: );
2131: fetch c_pgm into l_pgm;
2132: if c_pgm%notfound then
2133: close c_pgm;
2134: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
2135: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
2136: fnd_message.set_token('PACKAGE',l_package);
2137: fnd_message.raise_error;
2138: end if;

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

2131: fetch c_pgm into l_pgm;
2132: if c_pgm%notfound then
2133: close c_pgm;
2134: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
2135: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
2136: fnd_message.set_token('PACKAGE',l_package);
2137: fnd_message.raise_error;
2138: end if;
2139: close c_pgm;

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

2132: if c_pgm%notfound then
2133: close c_pgm;
2134: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
2135: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
2136: fnd_message.set_token('PACKAGE',l_package);
2137: fnd_message.raise_error;
2138: end if;
2139: close c_pgm;
2140: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;

Line 2137: fnd_message.raise_error;

2133: close c_pgm;
2134: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
2135: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
2136: fnd_message.set_token('PACKAGE',l_package);
2137: fnd_message.raise_error;
2138: end if;
2139: close c_pgm;
2140: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
2141: l_enrt_info_rt_freq_cd := l_pgm.enrt_info_rt_freq_cd;

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

2148: );
2149: fetch c_pln into l_pln;
2150: if c_pln%notfound then
2151: close c_pln;
2152: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
2153: fnd_message.set_token('ID',to_char(l_epe.pl_id));
2154: fnd_message.set_token('PACKAGE',l_package);
2155: fnd_message.raise_error;
2156: end if;

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

2149: fetch c_pln into l_pln;
2150: if c_pln%notfound then
2151: close c_pln;
2152: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
2153: fnd_message.set_token('ID',to_char(l_epe.pl_id));
2154: fnd_message.set_token('PACKAGE',l_package);
2155: fnd_message.raise_error;
2156: end if;
2157: close c_pln;

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

2150: if c_pln%notfound then
2151: close c_pln;
2152: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
2153: fnd_message.set_token('ID',to_char(l_epe.pl_id));
2154: fnd_message.set_token('PACKAGE',l_package);
2155: fnd_message.raise_error;
2156: end if;
2157: close c_pln;
2158: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;

Line 2155: fnd_message.raise_error;

2151: close c_pln;
2152: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
2153: fnd_message.set_token('ID',to_char(l_epe.pl_id));
2154: fnd_message.set_token('PACKAGE',l_package);
2155: fnd_message.raise_error;
2156: end if;
2157: close c_pln;
2158: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;
2159: l_enrt_info_rt_freq_cd := l_pln.nip_enrt_info_rt_freq_cd;

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

2213: end if;
2214: --
2215: if l_coverage_value is null then
2216: if l_enrt_bnft_id is null then
2217: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');
2218: fnd_message.set_token('PACKAGE',l_package);
2219: fnd_message.set_token('PARAM','p_enrt_bnft_id');
2220: fnd_message.raise_error;
2221: end if;

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

2214: --
2215: if l_coverage_value is null then
2216: if l_enrt_bnft_id is null then
2217: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');
2218: fnd_message.set_token('PACKAGE',l_package);
2219: fnd_message.set_token('PARAM','p_enrt_bnft_id');
2220: fnd_message.raise_error;
2221: end if;
2222: open c_enb(l_enrt_bnft_id);

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

2215: if l_coverage_value is null then
2216: if l_enrt_bnft_id is null then
2217: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');
2218: fnd_message.set_token('PACKAGE',l_package);
2219: fnd_message.set_token('PARAM','p_enrt_bnft_id');
2220: fnd_message.raise_error;
2221: end if;
2222: open c_enb(l_enrt_bnft_id);
2223: fetch c_enb into l_val, l_dflt_val;

Line 2220: fnd_message.raise_error;

2216: if l_enrt_bnft_id is null then
2217: fnd_message.set_name('BEN','BEN_92748_ABR_ENBID_NULL');
2218: fnd_message.set_token('PACKAGE',l_package);
2219: fnd_message.set_token('PARAM','p_enrt_bnft_id');
2220: fnd_message.raise_error;
2221: end if;
2222: open c_enb(l_enrt_bnft_id);
2223: fetch c_enb into l_val, l_dflt_val;
2224: if c_enb%notfound then

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

2222: open c_enb(l_enrt_bnft_id);
2223: fetch c_enb into l_val, l_dflt_val;
2224: if c_enb%notfound then
2225: close c_enb;
2226: fnd_message.set_name('BEN','BEN_92739_NO_ABR_ENB_EXISTS');
2227: fnd_message.raise_error;
2228: end if;
2229: close c_enb;
2230: --

Line 2227: fnd_message.raise_error;

2223: fetch c_enb into l_val, l_dflt_val;
2224: if c_enb%notfound then
2225: close c_enb;
2226: fnd_message.set_name('BEN','BEN_92739_NO_ABR_ENB_EXISTS');
2227: fnd_message.raise_error;
2228: end if;
2229: close c_enb;
2230: --
2231: l_coverage_value := nvl(l_val, l_dflt_val);

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

2237: );
2238: fetch c_cvg_oipl into l_cvg_calc_amt_mthd_id;
2239: if c_cvg_oipl%notfound then
2240: close c_cvg_oipl;
2241: fnd_message.set_name('BEN','BEN_92740_NO_OIPL_CCM_ATTACH');
2242: fnd_message.raise_error;
2243: end if;
2244: close c_cvg_oipl;
2245: elsif l_epe.pl_id is not NULL then

Line 2242: fnd_message.raise_error;

2238: fetch c_cvg_oipl into l_cvg_calc_amt_mthd_id;
2239: if c_cvg_oipl%notfound then
2240: close c_cvg_oipl;
2241: fnd_message.set_name('BEN','BEN_92740_NO_OIPL_CCM_ATTACH');
2242: fnd_message.raise_error;
2243: end if;
2244: close c_cvg_oipl;
2245: elsif l_epe.pl_id is not NULL then
2246: open c_cvg_pl

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

2248: );
2249: fetch c_cvg_pl into l_cvg_calc_amt_mthd_id;
2250: if c_cvg_pl%notfound then
2251: close c_cvg_pl;
2252: fnd_message.set_name('BEN','BEN_92741_NO_PLN_CCM_ATTACH');
2253: fnd_message.raise_error;
2254: end if;
2255: close c_cvg_pl;
2256: else

Line 2253: fnd_message.raise_error;

2249: fetch c_cvg_pl into l_cvg_calc_amt_mthd_id;
2250: if c_cvg_pl%notfound then
2251: close c_cvg_pl;
2252: fnd_message.set_name('BEN','BEN_92741_NO_PLN_CCM_ATTACH');
2253: fnd_message.raise_error;
2254: end if;
2255: close c_cvg_pl;
2256: else
2257: fnd_message.set_name('BEN','BEN_92744_ABR_ENB_NULL');

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

2253: fnd_message.raise_error;
2254: end if;
2255: close c_cvg_pl;
2256: else
2257: fnd_message.set_name('BEN','BEN_92744_ABR_ENB_NULL');
2258: fnd_message.raise_error;
2259: end if;
2260: p_cvg_calc_amt_mthd_id := l_cvg_calc_amt_mthd_id;
2261: end if;

Line 2258: fnd_message.raise_error;

2254: end if;
2255: close c_cvg_pl;
2256: else
2257: fnd_message.set_name('BEN','BEN_92744_ABR_ENB_NULL');
2258: fnd_message.raise_error;
2259: end if;
2260: p_cvg_calc_amt_mthd_id := l_cvg_calc_amt_mthd_id;
2261: end if;
2262: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);

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

2261: end if;
2262: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);
2263: if l_abr.rt_mlt_cd in ('CL','CLANDCVG') then
2264: if l_abr.comp_lvl_fctr_id is null then
2265: fnd_message.set_name('BEN','BEN_92745_NO_ABR_CLF_EXISTS');
2266: fnd_message.raise_error;
2267: end if;
2268: p_comp_lvl_fctr_id := l_abr.comp_lvl_fctr_id;
2269: ben_derive_factors.determine_compensation

Line 2266: fnd_message.raise_error;

2262: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);
2263: if l_abr.rt_mlt_cd in ('CL','CLANDCVG') then
2264: if l_abr.comp_lvl_fctr_id is null then
2265: fnd_message.set_name('BEN','BEN_92745_NO_ABR_CLF_EXISTS');
2266: fnd_message.raise_error;
2267: end if;
2268: p_comp_lvl_fctr_id := l_abr.comp_lvl_fctr_id;
2269: ben_derive_factors.determine_compensation
2270: (p_comp_lvl_fctr_id => l_abr.comp_lvl_fctr_id,

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

2283: p_fonm_rt_strt_dt => l_fonm_rt_strt_dt );
2284:
2285:
2286: if l_compensation_value is null then
2287: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');
2288: fnd_message.set_token('PACKAGE',l_package);
2289: fnd_message.set_token('VARIABLE','l_compensation_value');
2290: fnd_message.raise_error;
2291: end if;

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

2284:
2285:
2286: if l_compensation_value is null then
2287: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');
2288: fnd_message.set_token('PACKAGE',l_package);
2289: fnd_message.set_token('VARIABLE','l_compensation_value');
2290: fnd_message.raise_error;
2291: end if;
2292: end if;

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

2285:
2286: if l_compensation_value is null then
2287: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');
2288: fnd_message.set_token('PACKAGE',l_package);
2289: fnd_message.set_token('VARIABLE','l_compensation_value');
2290: fnd_message.raise_error;
2291: end if;
2292: end if;
2293: hr_utility.set_location ('ABR_RTMLTCD AP '||l_package,10);

Line 2290: fnd_message.raise_error;

2286: if l_compensation_value is null then
2287: fnd_message.set_name('BEN','BEN_92746_ABR_COMP_NULL');
2288: fnd_message.set_token('PACKAGE',l_package);
2289: fnd_message.set_token('VARIABLE','l_compensation_value');
2290: fnd_message.raise_error;
2291: end if;
2292: end if;
2293: hr_utility.set_location ('ABR_RTMLTCD AP '||l_package,10);
2294: if l_abr.rt_mlt_cd in ('AP','APANDCVG') then

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

2358: --
2359: end if;
2360:
2361: if l_actl_prem_value is null then
2362: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');
2363: hr_utility.set_location (' FNDMS_RE 1 ',130);
2364: fnd_message.raise_error;
2365: end if;
2366: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);

Line 2364: fnd_message.raise_error;

2360:
2361: if l_actl_prem_value is null then
2362: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');
2363: hr_utility.set_location (' FNDMS_RE 1 ',130);
2364: fnd_message.raise_error;
2365: end if;
2366: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);
2367: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);
2368: --

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

2390: --
2391: l_actl_prem_value := l_actl_prem_value * 12 / l_pay_annualization_factor;
2392: --
2393: else
2394: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2395: fnd_message.set_token('PROC',l_package);
2396: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2397: hr_utility.set_location (' FNDMS_RE 2 ',150);
2398: fnd_message.raise_error;

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

2391: l_actl_prem_value := l_actl_prem_value * 12 / l_pay_annualization_factor;
2392: --
2393: else
2394: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2395: fnd_message.set_token('PROC',l_package);
2396: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2397: hr_utility.set_location (' FNDMS_RE 2 ',150);
2398: fnd_message.raise_error;
2399: end if;

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

2392: --
2393: else
2394: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2395: fnd_message.set_token('PROC',l_package);
2396: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2397: hr_utility.set_location (' FNDMS_RE 2 ',150);
2398: fnd_message.raise_error;
2399: end if;
2400: end if; --'D'

Line 2398: fnd_message.raise_error;

2394: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2395: fnd_message.set_token('PROC',l_package);
2396: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2397: hr_utility.set_location (' FNDMS_RE 2 ',150);
2398: fnd_message.raise_error;
2399: end if;
2400: end if; --'D'
2401: end if;
2402: hr_utility.set_location ('ABR_RTMLTCD PRNT '||l_package,10);

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

2406: );
2407: fetch c_abr2 into l_acty_base_rt_id ,l_prnt_entr_val_at_enrt_flag;
2408: if c_abr2%notfound then
2409: close c_abr2;
2410: fnd_message.set_name('BEN','BEN_92742_NO_PRNT_ABR_EXISTS');
2411: fnd_message.raise_error;
2412: end if;
2413: close c_abr2;
2414: /*

Line 2411: fnd_message.raise_error;

2407: fetch c_abr2 into l_acty_base_rt_id ,l_prnt_entr_val_at_enrt_flag;
2408: if c_abr2%notfound then
2409: close c_abr2;
2410: fnd_message.set_name('BEN','BEN_92742_NO_PRNT_ABR_EXISTS');
2411: fnd_message.raise_error;
2412: end if;
2413: close c_abr2;
2414: /*
2415: --

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

2416: -- MH - removed this could never occur because BEN_92742_NO_PRNT_ABR_EXISTS
2417: -- would be raised
2418: --
2419: if l_acty_base_rt_id is null then
2420: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2421: fnd_message.set_token('PACKAGE',l_package);
2422: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2423: fnd_message.raise_error;
2424: end if;

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

2417: -- would be raised
2418: --
2419: if l_acty_base_rt_id is null then
2420: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2421: fnd_message.set_token('PACKAGE',l_package);
2422: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2423: fnd_message.raise_error;
2424: end if;
2425: */

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

2418: --
2419: if l_acty_base_rt_id is null then
2420: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2421: fnd_message.set_token('PACKAGE',l_package);
2422: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2423: fnd_message.raise_error;
2424: end if;
2425: */
2426: hr_utility.set_location ('St BDABR_MN Sub '||l_package,10);

Line 2423: fnd_message.raise_error;

2419: if l_acty_base_rt_id is null then
2420: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2421: fnd_message.set_token('PACKAGE',l_package);
2422: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2423: fnd_message.raise_error;
2424: end if;
2425: */
2426: hr_utility.set_location ('St BDABR_MN Sub '||l_package,10);
2427: if l_prnt_entr_val_at_enrt_flag = 'Y' then

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

2501: -- process
2502: if l_prnt_rt_value is null
2503: and nvl(l_prnt_entr_val_at_enrt_flag,'N') <> 'Y'
2504: then
2505: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2506: fnd_message.set_token('PACKAGE',l_package);
2507: fnd_message.set_token('VARIABLE','l_prnt_rt_value');
2508: fnd_message.raise_error;
2509: end if;

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

2502: if l_prnt_rt_value is null
2503: and nvl(l_prnt_entr_val_at_enrt_flag,'N') <> 'Y'
2504: then
2505: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2506: fnd_message.set_token('PACKAGE',l_package);
2507: fnd_message.set_token('VARIABLE','l_prnt_rt_value');
2508: fnd_message.raise_error;
2509: end if;
2510: --

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

2503: and nvl(l_prnt_entr_val_at_enrt_flag,'N') <> 'Y'
2504: then
2505: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2506: fnd_message.set_token('PACKAGE',l_package);
2507: fnd_message.set_token('VARIABLE','l_prnt_rt_value');
2508: fnd_message.raise_error;
2509: end if;
2510: --
2511: end if;

Line 2508: fnd_message.raise_error;

2504: then
2505: fnd_message.set_name('BEN','BEN_91835_VARIABLE_VALUE_NULL');
2506: fnd_message.set_token('PACKAGE',l_package);
2507: fnd_message.set_token('VARIABLE','l_prnt_rt_value');
2508: fnd_message.raise_error;
2509: end if;
2510: --
2511: end if;
2512:

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

2535: open c_pl_opt_name;
2536: fetch c_pl_opt_name into l_pl_opt_name;
2537: close c_pl_opt_name;
2538:
2539: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2540: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2541: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2542: fnd_message.set_token('PLOPT',l_pl_opt_name);
2543: fnd_message.raise_error;

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

2536: fetch c_pl_opt_name into l_pl_opt_name;
2537: close c_pl_opt_name;
2538:
2539: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2540: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2541: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2542: fnd_message.set_token('PLOPT',l_pl_opt_name);
2543: fnd_message.raise_error;
2544:

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

2537: close c_pl_opt_name;
2538:
2539: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2540: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2541: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2542: fnd_message.set_token('PLOPT',l_pl_opt_name);
2543: fnd_message.raise_error;
2544:
2545: elsif (mod(p_cal_val,nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val))

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

2538:
2539: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2540: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2541: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2542: fnd_message.set_token('PLOPT',l_pl_opt_name);
2543: fnd_message.raise_error;
2544:
2545: elsif (mod(p_cal_val,nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val))
2546: <>0) then

Line 2543: fnd_message.raise_error;

2539: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
2540: fnd_message.set_token('MIN',nvl(l_enrt_rt.mn_elcn_val,l_abr.mn_elcn_val));
2541: fnd_message.set_token('MAX',nvl(l_enrt_rt.mx_elcn_val,l_abr.mx_elcn_val));
2542: fnd_message.set_token('PLOPT',l_pl_opt_name);
2543: fnd_message.raise_error;
2544:
2545: elsif (mod(p_cal_val,nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val))
2546: <>0) then
2547: --

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

2553: fetch c_pl_opt_name into l_pl_opt_name;
2554: close c_pl_opt_name;
2555: -- end # 1699585
2556:
2557: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
2558: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));
2559: fnd_message.set_token('PLAN', l_pl_opt_name);
2560: fnd_message.raise_error;
2561:

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

2554: close c_pl_opt_name;
2555: -- end # 1699585
2556:
2557: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
2558: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));
2559: fnd_message.set_token('PLAN', l_pl_opt_name);
2560: fnd_message.raise_error;
2561:
2562: End if;

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

2555: -- end # 1699585
2556:
2557: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
2558: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));
2559: fnd_message.set_token('PLAN', l_pl_opt_name);
2560: fnd_message.raise_error;
2561:
2562: End if;
2563:

Line 2560: fnd_message.raise_error;

2556:
2557: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
2558: fnd_message.set_token('INCREMENT', nvl(l_enrt_rt.incrmt_elcn_val,l_abr.incrmt_elcn_val));
2559: fnd_message.set_token('PLAN', l_pl_opt_name);
2560: fnd_message.raise_error;
2561:
2562: End if;
2563:
2564:

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

2965: close c_pgr ;
2966: hr_utility.set_location('GSP value '|| l_val ,551) ;
2967:
2968: else
2969: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2970: fnd_message.set_token('PROC',l_package);
2971: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2972: fnd_message.raise_error;
2973: end if;

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

2966: hr_utility.set_location('GSP value '|| l_val ,551) ;
2967:
2968: else
2969: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2970: fnd_message.set_token('PROC',l_package);
2971: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2972: fnd_message.raise_error;
2973: end if;
2974: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);

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

2967:
2968: else
2969: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2970: fnd_message.set_token('PROC',l_package);
2971: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2972: fnd_message.raise_error;
2973: end if;
2974: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);
2975: --

Line 2972: fnd_message.raise_error;

2968: else
2969: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2970: fnd_message.set_token('PROC',l_package);
2971: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2972: fnd_message.raise_error;
2973: end if;
2974: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);
2975: --
2976: -- set some of the outputs