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

Line 1365: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');

1361: --
1362: hr_utility.set_location('COunt'||l_count,11);
1363: if l_inst_dets(l_count).formula_id is null then
1364: --
1365: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
1366: fnd_message.set_token('PROC',l_proc);
1367: fnd_message.set_token('VARIABLE_RT_PRFL_ID',to_char(p_VRBL_RT_PRFL_ID));
1368: fnd_message.raise_error;
1369: --

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

1362: hr_utility.set_location('COunt'||l_count,11);
1363: if l_inst_dets(l_count).formula_id is null then
1364: --
1365: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
1366: fnd_message.set_token('PROC',l_proc);
1367: fnd_message.set_token('VARIABLE_RT_PRFL_ID',to_char(p_VRBL_RT_PRFL_ID));
1368: fnd_message.raise_error;
1369: --
1370: end if;

Line 1367: fnd_message.set_token('VARIABLE_RT_PRFL_ID',to_char(p_VRBL_RT_PRFL_ID));

1363: if l_inst_dets(l_count).formula_id is null then
1364: --
1365: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
1366: fnd_message.set_token('PROC',l_proc);
1367: fnd_message.set_token('VARIABLE_RT_PRFL_ID',to_char(p_VRBL_RT_PRFL_ID));
1368: fnd_message.raise_error;
1369: --
1370: end if;
1371: --

Line 1368: fnd_message.raise_error;

1364: --
1365: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
1366: fnd_message.set_token('PROC',l_proc);
1367: fnd_message.set_token('VARIABLE_RT_PRFL_ID',to_char(p_VRBL_RT_PRFL_ID));
1368: fnd_message.raise_error;
1369: --
1370: end if;
1371: --
1372: hr_utility.set_location('Bef Formula',11);

Line 1394: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

1390: --
1391: -- Account for cases where formula returns an unknown
1392: -- variable name
1393: --
1394: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
1395: fnd_message.set_token('PROC',l_proc);
1396: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1397: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1398: fnd_message.raise_error;

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

1391: -- Account for cases where formula returns an unknown
1392: -- variable name
1393: --
1394: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
1395: fnd_message.set_token('PROC',l_proc);
1396: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1397: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1398: fnd_message.raise_error;
1399: --

Line 1396: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);

1392: -- variable name
1393: --
1394: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
1395: fnd_message.set_token('PROC',l_proc);
1396: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1397: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1398: fnd_message.raise_error;
1399: --
1400: end if;

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

1393: --
1394: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
1395: fnd_message.set_token('PROC',l_proc);
1396: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1397: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1398: fnd_message.raise_error;
1399: --
1400: end if;
1401: --

Line 1398: fnd_message.raise_error;

1394: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
1395: fnd_message.set_token('PROC',l_proc);
1396: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1397: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1398: fnd_message.raise_error;
1399: --
1400: end if;
1401: --
1402: -- Code for type casting errors from formula return variables

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

1404: exception
1405: --
1406: when others then
1407: --
1408: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1409: fnd_message.set_token('PROC',l_proc);
1410: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1411: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1412: fnd_message.raise_error;

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

1405: --
1406: when others then
1407: --
1408: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1409: fnd_message.set_token('PROC',l_proc);
1410: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1411: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1412: fnd_message.raise_error;
1413: --

Line 1410: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);

1406: when others then
1407: --
1408: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1409: fnd_message.set_token('PROC',l_proc);
1410: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1411: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1412: fnd_message.raise_error;
1413: --
1414: end;

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

1407: --
1408: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1409: fnd_message.set_token('PROC',l_proc);
1410: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1411: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1412: fnd_message.raise_error;
1413: --
1414: end;
1415: --

Line 1412: fnd_message.raise_error;

1408: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1409: fnd_message.set_token('PROC',l_proc);
1410: fnd_message.set_token('FORMULA',l_inst_dets(l_count).formula_id);
1411: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1412: fnd_message.raise_error;
1413: --
1414: end;
1415: --
1416: hr_utility.set_location('Include Flag '||l_include_flag,10);

Line 1452: fnd_message.set_name('BEN','BEN_92459_ASS_SET_PRFL_FAIL');

1448: --
1449: if l_rows_found and
1450: not l_ok then
1451: --
1452: fnd_message.set_name('BEN','BEN_92459_ASS_SET_PRFL_FAIL');
1453: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1454: raise g_criteria_failed;
1455: --
1456: end if;

Line 2490: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

2486: --
2487: -- Account for cases where formula returns an unknown
2488: -- variable name
2489: --
2490: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2491: fnd_message.set_token('PROC',l_package);
2492: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2493: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2494:

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

2487: -- Account for cases where formula returns an unknown
2488: -- variable name
2489: --
2490: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2491: fnd_message.set_token('PROC',l_package);
2492: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2493: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2494:
2495: -- Handling this particular exception seperately.

Line 2492: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);

2488: -- variable name
2489: --
2490: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2491: fnd_message.set_token('PROC',l_package);
2492: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2493: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2494:
2495: -- Handling this particular exception seperately.
2496: raise invalid_param;

Line 2493: fnd_message.set_token('PARAMETER',l_output(l_count).name);

2489: --
2490: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2491: fnd_message.set_token('PROC',l_package);
2492: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2493: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2494:
2495: -- Handling this particular exception seperately.
2496: raise invalid_param;
2497: --

Line 2506: fnd_message.raise_error;

2502: exception
2503: --
2504: -- Code appended for bug# 2620550
2505: when invalid_param then
2506: fnd_message.raise_error;
2507: when others then
2508: --
2509: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2510: fnd_message.set_token('PROC',l_package);

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

2505: when invalid_param then
2506: fnd_message.raise_error;
2507: when others then
2508: --
2509: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2510: fnd_message.set_token('PROC',l_package);
2511: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2512: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2513: fnd_message.raise_error;

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

2506: fnd_message.raise_error;
2507: when others then
2508: --
2509: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2510: fnd_message.set_token('PROC',l_package);
2511: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2512: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2513: fnd_message.raise_error;
2514: --

Line 2511: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);

2507: when others then
2508: --
2509: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2510: fnd_message.set_token('PROC',l_package);
2511: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2512: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2513: fnd_message.raise_error;
2514: --
2515: end;

Line 2512: fnd_message.set_token('PARAMETER',l_output(l_count).name);

2508: --
2509: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2510: fnd_message.set_token('PROC',l_package);
2511: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2512: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2513: fnd_message.raise_error;
2514: --
2515: end;
2516: end loop;

Line 2513: fnd_message.raise_error;

2509: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2510: fnd_message.set_token('PROC',l_package);
2511: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2512: fnd_message.set_token('PARAMETER',l_output(l_count).name);
2513: fnd_message.raise_error;
2514: --
2515: end;
2516: end loop;
2517: --

Line 2519: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

2515: end;
2516: end loop;
2517: --
2518: if l_min_hours is null and l_max_hours is null then
2519: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2520: fnd_message.set_token('PROC',l_package);
2521: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2522: fnd_message.set_token('PARAMETER','MIN_HOURS');
2523: fnd_message.raise_error;

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

2516: end loop;
2517: --
2518: if l_min_hours is null and l_max_hours is null then
2519: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2520: fnd_message.set_token('PROC',l_package);
2521: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2522: fnd_message.set_token('PARAMETER','MIN_HOURS');
2523: fnd_message.raise_error;
2524: end if;

Line 2521: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);

2517: --
2518: if l_min_hours is null and l_max_hours is null then
2519: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2520: fnd_message.set_token('PROC',l_package);
2521: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2522: fnd_message.set_token('PARAMETER','MIN_HOURS');
2523: fnd_message.raise_error;
2524: end if;
2525:

Line 2522: fnd_message.set_token('PARAMETER','MIN_HOURS');

2518: if l_min_hours is null and l_max_hours is null then
2519: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2520: fnd_message.set_token('PROC',l_package);
2521: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2522: fnd_message.set_token('PARAMETER','MIN_HOURS');
2523: fnd_message.raise_error;
2524: end if;
2525:
2526: if l_freq_cd is null then

Line 2523: fnd_message.raise_error;

2519: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2520: fnd_message.set_token('PROC',l_package);
2521: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2522: fnd_message.set_token('PARAMETER','MIN_HOURS');
2523: fnd_message.raise_error;
2524: end if;
2525:
2526: if l_freq_cd is null then
2527: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

Line 2527: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

2523: fnd_message.raise_error;
2524: end if;
2525:
2526: if l_freq_cd is null then
2527: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2528: fnd_message.set_token('PROC',l_package);
2529: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2530: fnd_message.set_token('PARAMETER','FREQUENCY');
2531: fnd_message.raise_error;

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

2524: end if;
2525:
2526: if l_freq_cd is null then
2527: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2528: fnd_message.set_token('PROC',l_package);
2529: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2530: fnd_message.set_token('PARAMETER','FREQUENCY');
2531: fnd_message.raise_error;
2532: end if;

Line 2529: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);

2525:
2526: if l_freq_cd is null then
2527: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2528: fnd_message.set_token('PROC',l_package);
2529: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2530: fnd_message.set_token('PARAMETER','FREQUENCY');
2531: fnd_message.raise_error;
2532: end if;
2533: else

Line 2530: fnd_message.set_token('PARAMETER','FREQUENCY');

2526: if l_freq_cd is null then
2527: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2528: fnd_message.set_token('PROC',l_package);
2529: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2530: fnd_message.set_token('PARAMETER','FREQUENCY');
2531: fnd_message.raise_error;
2532: end if;
2533: else
2534: l_min_hours := l_inst_set(i).hrs_num;

Line 2531: fnd_message.raise_error;

2527: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');
2528: fnd_message.set_token('PROC',l_package);
2529: fnd_message.set_token('FORMULA', l_inst_set(i).schedd_hrs_rl);
2530: fnd_message.set_token('PARAMETER','FREQUENCY');
2531: fnd_message.raise_error;
2532: end if;
2533: else
2534: l_min_hours := l_inst_set(i).hrs_num;
2535: l_max_hours := l_inst_set(i).max_hrs_num;

Line 2830: fnd_message.set_name('BEN','BEN_92225_SVC_AREA_PRFL_FAIL');

2826: l_ok := true;
2827: --
2828: ELSIF ( l_rows_found AND l_excld_flag = 'Y' ) then
2829: -- close get_elig_svc ;
2830: fnd_message.set_name('BEN','BEN_92225_SVC_AREA_PRFL_FAIL');
2831: -- raise g_criteria_failed;
2832: l_rows_found :=FALSE ;
2833: l_ok := false ;
2834: exit ;

Line 3061: fnd_message.set_name('BEN','BEN_91520_BERP_AGE_FCTR_ID');

3057: for i in l_inst_set.first..l_inst_set.last loop
3058: --
3059: if l_inst_set(i).age_fctr_id is null then
3060: --
3061: fnd_message.set_name('BEN','BEN_91520_BERP_AGE_FCTR_ID');
3062: fnd_message.set_token('L_PROC',l_proc);
3063: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 3062: fnd_message.set_token('L_PROC',l_proc);

3058: --
3059: if l_inst_set(i).age_fctr_id is null then
3060: --
3061: fnd_message.set_name('BEN','BEN_91520_BERP_AGE_FCTR_ID');
3062: fnd_message.set_token('L_PROC',l_proc);
3063: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

3059: if l_inst_set(i).age_fctr_id is null then
3060: --
3061: fnd_message.set_name('BEN','BEN_91520_BERP_AGE_FCTR_ID');
3062: fnd_message.set_token('L_PROC',l_proc);
3063: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

Line 3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));

3060: --
3061: fnd_message.set_name('BEN','BEN_91520_BERP_AGE_FCTR_ID');
3062: fnd_message.set_token('L_PROC',l_proc);
3063: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

3061: fnd_message.set_name('BEN','BEN_91520_BERP_AGE_FCTR_ID');
3062: fnd_message.set_token('L_PROC',l_proc);
3063: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3069: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

3062: fnd_message.set_token('L_PROC',l_proc);
3063: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3069: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3070: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

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

3063: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3069: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3070: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3071: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

3064: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3069: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3070: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3071: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3072: fnd_message.raise_error;

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

3065: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3069: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3070: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3071: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3072: fnd_message.raise_error;
3073: --

Line 3070: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

3066: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3069: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3070: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3071: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3072: fnd_message.raise_error;
3073: --
3074: end if;

Line 3071: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

3067: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3069: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3070: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3071: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3072: fnd_message.raise_error;
3073: --
3074: end if;
3075: --

Line 3072: fnd_message.raise_error;

3068: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3069: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3070: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3071: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3072: fnd_message.raise_error;
3073: --
3074: end if;
3075: --
3076: --RCHASE - v115.57 wrap l_prtn_ovridn_flag with NVL,

Line 3260: fnd_message.set_name('BEN','BEN_91526_BERP_CMP_LVL_FCTR_ID');

3256: for i in l_inst_set.first..l_inst_set.last loop
3257: --
3258: if l_inst_set(i).comp_lvl_fctr_id is null then
3259: --
3260: fnd_message.set_name('BEN','BEN_91526_BERP_CMP_LVL_FCTR_ID');
3261: fnd_message.set_token('L_PROC',l_proc);
3262: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

Line 3261: fnd_message.set_token('L_PROC',l_proc);

3257: --
3258: if l_inst_set(i).comp_lvl_fctr_id is null then
3259: --
3260: fnd_message.set_name('BEN','BEN_91526_BERP_CMP_LVL_FCTR_ID');
3261: fnd_message.set_token('L_PROC',l_proc);
3262: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

3258: if l_inst_set(i).comp_lvl_fctr_id is null then
3259: --
3260: fnd_message.set_name('BEN','BEN_91526_BERP_CMP_LVL_FCTR_ID');
3261: fnd_message.set_token('L_PROC',l_proc);
3262: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

Line 3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));

3259: --
3260: fnd_message.set_name('BEN','BEN_91526_BERP_CMP_LVL_FCTR_ID');
3261: fnd_message.set_token('L_PROC',l_proc);
3262: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

3260: fnd_message.set_name('BEN','BEN_91526_BERP_CMP_LVL_FCTR_ID');
3261: fnd_message.set_token('L_PROC',l_proc);
3262: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3268: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

3261: fnd_message.set_token('L_PROC',l_proc);
3262: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3268: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3269: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

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

3262: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3268: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3269: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3270: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

3263: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3268: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3269: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3270: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3271: fnd_message.raise_error;

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

3264: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3268: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3269: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3270: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3271: fnd_message.raise_error;
3272: --

Line 3269: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

3265: fnd_message.set_token('PL_ID',to_char(p_pl_id));
3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3268: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3269: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3270: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3271: fnd_message.raise_error;
3272: --
3273: end if;

Line 3270: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

3266: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3268: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3269: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3270: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3271: fnd_message.raise_error;
3272: --
3273: end if;
3274: --

Line 3271: fnd_message.raise_error;

3267: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
3268: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
3269: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
3270: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3271: fnd_message.raise_error;
3272: --
3273: end if;
3274: --
3275: ben_derive_factors.determine_compensation

Line 4129: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');

4125: if l_inst_count > 0 then
4126: if p_ttl_prtt is null then
4127: -- there are variable profile criteria for total number of participants
4128: -- attached, but the process did not pass in a the number of prtts.
4129: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4130: fnd_message.set_token('L_PROC',l_proc);
4131: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4132: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4133: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 4130: fnd_message.set_token('L_PROC',l_proc);

4126: if p_ttl_prtt is null then
4127: -- there are variable profile criteria for total number of participants
4128: -- attached, but the process did not pass in a the number of prtts.
4129: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4130: fnd_message.set_token('L_PROC',l_proc);
4131: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4132: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4133: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4134: fnd_message.raise_error;

Line 4131: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));

4127: -- there are variable profile criteria for total number of participants
4128: -- attached, but the process did not pass in a the number of prtts.
4129: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4130: fnd_message.set_token('L_PROC',l_proc);
4131: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4132: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4133: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4134: fnd_message.raise_error;
4135: end if;

Line 4132: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

4128: -- attached, but the process did not pass in a the number of prtts.
4129: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4130: fnd_message.set_token('L_PROC',l_proc);
4131: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4132: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4133: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4134: fnd_message.raise_error;
4135: end if;
4136: --

Line 4133: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

4129: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4130: fnd_message.set_token('L_PROC',l_proc);
4131: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4132: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4133: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4134: fnd_message.raise_error;
4135: end if;
4136: --
4137: -- Data found. Loop through to see we match the total number of prtts.

Line 4134: fnd_message.raise_error;

4130: fnd_message.set_token('L_PROC',l_proc);
4131: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4132: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4133: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4134: fnd_message.raise_error;
4135: end if;
4136: --
4137: -- Data found. Loop through to see we match the total number of prtts.
4138: --

Line 6453: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');

6449: if l_inst_count > 0 then
6450: if p_ttl_cvg is null then
6451: -- there are variable profile criteria for total coverage attached, but
6452: -- the process did not pass in a coverage volumn amount.
6453: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6454: fnd_message.set_token('L_PROC',l_proc);
6455: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6456: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6457: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 6454: fnd_message.set_token('L_PROC',l_proc);

6450: if p_ttl_cvg is null then
6451: -- there are variable profile criteria for total coverage attached, but
6452: -- the process did not pass in a coverage volumn amount.
6453: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6454: fnd_message.set_token('L_PROC',l_proc);
6455: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6456: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6457: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6458: fnd_message.raise_error;

Line 6455: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));

6451: -- there are variable profile criteria for total coverage attached, but
6452: -- the process did not pass in a coverage volumn amount.
6453: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6454: fnd_message.set_token('L_PROC',l_proc);
6455: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6456: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6457: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6458: fnd_message.raise_error;
6459: end if;

Line 6456: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

6452: -- the process did not pass in a coverage volumn amount.
6453: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6454: fnd_message.set_token('L_PROC',l_proc);
6455: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6456: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6457: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6458: fnd_message.raise_error;
6459: end if;
6460: --

Line 6457: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

6453: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6454: fnd_message.set_token('L_PROC',l_proc);
6455: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6456: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6457: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6458: fnd_message.raise_error;
6459: end if;
6460: --
6461: -- Data found. Loop through to see we match the total amount of cvg.

Line 6458: fnd_message.raise_error;

6454: fnd_message.set_token('L_PROC',l_proc);
6455: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6456: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6457: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6458: fnd_message.raise_error;
6459: end if;
6460: --
6461: -- Data found. Loop through to see we match the total amount of cvg.
6462: --

Line 7250: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');

7246: hr_utility.set_location('p_use_globals -> true',11);
7247: else hr_utility.set_location('p_use_globals -> false',11); end if;
7248:
7249: if p_person_id is NULL then
7250: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7251: fnd_message.set_token('PACKAGE',l_package);
7252: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7253: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7247: else hr_utility.set_location('p_use_globals -> false',11); end if;
7248:
7249: if p_person_id is NULL then
7250: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7251: fnd_message.set_token('PACKAGE',l_package);
7252: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7253: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7248:
7249: if p_person_id is NULL then
7250: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7251: fnd_message.set_token('PACKAGE',l_package);
7252: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7253: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7249: if p_person_id is NULL then
7250: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7251: fnd_message.set_token('PACKAGE',l_package);
7252: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7253: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7257: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7250: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7251: fnd_message.set_token('PACKAGE',l_package);
7252: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7253: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7257: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);

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

7251: fnd_message.set_token('PACKAGE',l_package);
7252: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7253: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7257: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

7252: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7253: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7257: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7260: fnd_message.raise_error;

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

7253: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7257: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7260: fnd_message.raise_error;
7261: elsif p_effective_date is NULL then

Line 7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);

7254: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7257: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7260: fnd_message.raise_error;
7261: elsif p_effective_date is NULL then
7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');

Line 7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

7255: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7257: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7260: fnd_message.raise_error;
7261: elsif p_effective_date is NULL then
7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7263: fnd_message.set_token('PACKAGE',l_package);

Line 7260: fnd_message.raise_error;

7256: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7257: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7260: fnd_message.raise_error;
7261: elsif p_effective_date is NULL then
7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7263: fnd_message.set_token('PACKAGE',l_package);
7264: fnd_message.set_token('PERSON_ID',p_person_id);

Line 7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');

7258: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7260: fnd_message.raise_error;
7261: elsif p_effective_date is NULL then
7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7263: fnd_message.set_token('PACKAGE',l_package);
7264: fnd_message.set_token('PERSON_ID',p_person_id);
7265: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

7259: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7260: fnd_message.raise_error;
7261: elsif p_effective_date is NULL then
7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7263: fnd_message.set_token('PACKAGE',l_package);
7264: fnd_message.set_token('PERSON_ID',p_person_id);
7265: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7260: fnd_message.raise_error;
7261: elsif p_effective_date is NULL then
7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7263: fnd_message.set_token('PACKAGE',l_package);
7264: fnd_message.set_token('PERSON_ID',p_person_id);
7265: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7261: elsif p_effective_date is NULL then
7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7263: fnd_message.set_token('PACKAGE',l_package);
7264: fnd_message.set_token('PERSON_ID',p_person_id);
7265: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7262: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7263: fnd_message.set_token('PACKAGE',l_package);
7264: fnd_message.set_token('PERSON_ID',p_person_id);
7265: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7270: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7263: fnd_message.set_token('PACKAGE',l_package);
7264: fnd_message.set_token('PERSON_ID',p_person_id);
7265: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7270: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7271: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);

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

7264: fnd_message.set_token('PERSON_ID',p_person_id);
7265: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7270: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7271: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7272: fnd_message.raise_error;

Line 7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

7265: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7270: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7271: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7272: fnd_message.raise_error;
7273: elsif p_elig_per_elctbl_chc_id is NULL and

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

7266: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7270: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7271: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7272: fnd_message.raise_error;
7273: elsif p_elig_per_elctbl_chc_id is NULL and
7274: p_calc_only_rt_val_flag = FALSE then

Line 7271: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);

7267: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7270: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7271: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7272: fnd_message.raise_error;
7273: elsif p_elig_per_elctbl_chc_id is NULL and
7274: p_calc_only_rt_val_flag = FALSE then
7275: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');

Line 7272: fnd_message.raise_error;

7268: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7269: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7270: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7271: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7272: fnd_message.raise_error;
7273: elsif p_elig_per_elctbl_chc_id is NULL and
7274: p_calc_only_rt_val_flag = FALSE then
7275: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7276: fnd_message.set_token('PACKAGE',l_package);

Line 7275: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');

7271: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7272: fnd_message.raise_error;
7273: elsif p_elig_per_elctbl_chc_id is NULL and
7274: p_calc_only_rt_val_flag = FALSE then
7275: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7276: fnd_message.set_token('PACKAGE',l_package);
7277: fnd_message.set_token('PERSON_ID',p_person_id);
7278: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

7272: fnd_message.raise_error;
7273: elsif p_elig_per_elctbl_chc_id is NULL and
7274: p_calc_only_rt_val_flag = FALSE then
7275: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7276: fnd_message.set_token('PACKAGE',l_package);
7277: fnd_message.set_token('PERSON_ID',p_person_id);
7278: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7273: elsif p_elig_per_elctbl_chc_id is NULL and
7274: p_calc_only_rt_val_flag = FALSE then
7275: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7276: fnd_message.set_token('PACKAGE',l_package);
7277: fnd_message.set_token('PERSON_ID',p_person_id);
7278: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7274: p_calc_only_rt_val_flag = FALSE then
7275: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7276: fnd_message.set_token('PACKAGE',l_package);
7277: fnd_message.set_token('PERSON_ID',p_person_id);
7278: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7275: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7276: fnd_message.set_token('PACKAGE',l_package);
7277: fnd_message.set_token('PERSON_ID',p_person_id);
7278: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7283: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7276: fnd_message.set_token('PACKAGE',l_package);
7277: fnd_message.set_token('PERSON_ID',p_person_id);
7278: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7283: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7284: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

7277: fnd_message.set_token('PERSON_ID',p_person_id);
7278: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7283: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7284: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7285: fnd_message.raise_error;

Line 7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

7278: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7283: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7284: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7285: fnd_message.raise_error;
7286: elsif (p_acty_base_rt_id is NULL and

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

7279: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7283: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7284: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7285: fnd_message.raise_error;
7286: elsif (p_acty_base_rt_id is NULL and
7287: p_actl_prem_id is NULL and

Line 7284: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

7280: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7283: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7284: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7285: fnd_message.raise_error;
7286: elsif (p_acty_base_rt_id is NULL and
7287: p_actl_prem_id is NULL and
7288: p_cvg_amt_calc_mthd_id is NULL) then

Line 7285: fnd_message.raise_error;

7281: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7282: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7283: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7284: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7285: fnd_message.raise_error;
7286: elsif (p_acty_base_rt_id is NULL and
7287: p_actl_prem_id is NULL and
7288: p_cvg_amt_calc_mthd_id is NULL) then
7289: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');

Line 7289: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');

7285: fnd_message.raise_error;
7286: elsif (p_acty_base_rt_id is NULL and
7287: p_actl_prem_id is NULL and
7288: p_cvg_amt_calc_mthd_id is NULL) then
7289: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7290: fnd_message.set_token('PACKAGE',l_package);
7291: fnd_message.set_token('PERSON_ID',p_person_id);
7292: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

7286: elsif (p_acty_base_rt_id is NULL and
7287: p_actl_prem_id is NULL and
7288: p_cvg_amt_calc_mthd_id is NULL) then
7289: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7290: fnd_message.set_token('PACKAGE',l_package);
7291: fnd_message.set_token('PERSON_ID',p_person_id);
7292: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7287: p_actl_prem_id is NULL and
7288: p_cvg_amt_calc_mthd_id is NULL) then
7289: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7290: fnd_message.set_token('PACKAGE',l_package);
7291: fnd_message.set_token('PERSON_ID',p_person_id);
7292: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7288: p_cvg_amt_calc_mthd_id is NULL) then
7289: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7290: fnd_message.set_token('PACKAGE',l_package);
7291: fnd_message.set_token('PERSON_ID',p_person_id);
7292: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7289: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7290: fnd_message.set_token('PACKAGE',l_package);
7291: fnd_message.set_token('PERSON_ID',p_person_id);
7292: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7297: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7290: fnd_message.set_token('PACKAGE',l_package);
7291: fnd_message.set_token('PERSON_ID',p_person_id);
7292: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7297: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7298: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

7291: fnd_message.set_token('PERSON_ID',p_person_id);
7292: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7297: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7298: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7299: fnd_message.raise_error;

Line 7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

7292: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7297: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7298: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7299: fnd_message.raise_error;
7300: elsif (p_acty_base_rt_id is not NULL and

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

7293: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7297: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7298: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7299: fnd_message.raise_error;
7300: elsif (p_acty_base_rt_id is not NULL and
7301: p_actl_prem_id is not NULL) or

Line 7298: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

7294: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7297: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7298: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7299: fnd_message.raise_error;
7300: elsif (p_acty_base_rt_id is not NULL and
7301: p_actl_prem_id is not NULL) or
7302: (p_acty_base_rt_id is not NULL and

Line 7299: fnd_message.raise_error;

7295: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7296: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7297: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7298: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7299: fnd_message.raise_error;
7300: elsif (p_acty_base_rt_id is not NULL and
7301: p_actl_prem_id is not NULL) or
7302: (p_acty_base_rt_id is not NULL and
7303: p_cvg_amt_calc_mthd_id is not NULL) or

Line 7306: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');

7302: (p_acty_base_rt_id is not NULL and
7303: p_cvg_amt_calc_mthd_id is not NULL) or
7304: (p_actl_prem_id is not NULL and
7305: p_cvg_amt_calc_mthd_id is not NULL) then
7306: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7307: fnd_message.set_token('PACKAGE',l_package);
7308: fnd_message.set_token('PERSON_ID',p_person_id);
7309: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

7303: p_cvg_amt_calc_mthd_id is not NULL) or
7304: (p_actl_prem_id is not NULL and
7305: p_cvg_amt_calc_mthd_id is not NULL) then
7306: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7307: fnd_message.set_token('PACKAGE',l_package);
7308: fnd_message.set_token('PERSON_ID',p_person_id);
7309: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7304: (p_actl_prem_id is not NULL and
7305: p_cvg_amt_calc_mthd_id is not NULL) then
7306: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7307: fnd_message.set_token('PACKAGE',l_package);
7308: fnd_message.set_token('PERSON_ID',p_person_id);
7309: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7305: p_cvg_amt_calc_mthd_id is not NULL) then
7306: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7307: fnd_message.set_token('PACKAGE',l_package);
7308: fnd_message.set_token('PERSON_ID',p_person_id);
7309: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7306: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7307: fnd_message.set_token('PACKAGE',l_package);
7308: fnd_message.set_token('PERSON_ID',p_person_id);
7309: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7314: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7307: fnd_message.set_token('PACKAGE',l_package);
7308: fnd_message.set_token('PERSON_ID',p_person_id);
7309: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7314: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7315: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

7308: fnd_message.set_token('PERSON_ID',p_person_id);
7309: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7314: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7315: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7316: fnd_message.raise_error;

Line 7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

7309: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7314: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7315: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7316: fnd_message.raise_error;
7317: end if;

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

7310: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7314: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7315: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7316: fnd_message.raise_error;
7317: end if;
7318:

Line 7315: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

7311: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7314: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7315: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7316: fnd_message.raise_error;
7317: end if;
7318:
7319: if p_per_row.person_id is null then

Line 7316: fnd_message.raise_error;

7312: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7313: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7314: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7315: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7316: fnd_message.raise_error;
7317: end if;
7318:
7319: if p_per_row.person_id is null then
7320: --