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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3273: fnd_message.raise_error;

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

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

4178: if l_inst_count > 0 then
4179: if p_ttl_prtt is null then
4180: -- there are variable profile criteria for total number of participants
4181: -- attached, but the process did not pass in a the number of prtts.
4182: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4183: fnd_message.set_token('L_PROC',l_proc);
4184: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4185: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4186: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4179: if p_ttl_prtt is null then
4180: -- there are variable profile criteria for total number of participants
4181: -- attached, but the process did not pass in a the number of prtts.
4182: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4183: fnd_message.set_token('L_PROC',l_proc);
4184: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4185: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4186: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4187: fnd_message.raise_error;

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

4180: -- there are variable profile criteria for total number of participants
4181: -- attached, but the process did not pass in a the number of prtts.
4182: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4183: fnd_message.set_token('L_PROC',l_proc);
4184: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4185: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4186: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4187: fnd_message.raise_error;
4188: end if;

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

4181: -- attached, but the process did not pass in a the number of prtts.
4182: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4183: fnd_message.set_token('L_PROC',l_proc);
4184: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4185: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4186: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4187: fnd_message.raise_error;
4188: end if;
4189: --

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

4182: fnd_message.set_name('BEN','BEN_92244_TTL_PRTT_REQUIRED');
4183: fnd_message.set_token('L_PROC',l_proc);
4184: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4185: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4186: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4187: fnd_message.raise_error;
4188: end if;
4189: --
4190: -- Data found. Loop through to see we match the total number of prtts.

Line 4187: fnd_message.raise_error;

4183: fnd_message.set_token('L_PROC',l_proc);
4184: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
4185: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
4186: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4187: fnd_message.raise_error;
4188: end if;
4189: --
4190: -- Data found. Loop through to see we match the total number of prtts.
4191: --

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

6506: if l_inst_count > 0 then
6507: if p_ttl_cvg is null then
6508: -- there are variable profile criteria for total coverage attached, but
6509: -- the process did not pass in a coverage volumn amount.
6510: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6511: fnd_message.set_token('L_PROC',l_proc);
6512: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6513: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6514: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

6507: if p_ttl_cvg is null then
6508: -- there are variable profile criteria for total coverage attached, but
6509: -- the process did not pass in a coverage volumn amount.
6510: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6511: fnd_message.set_token('L_PROC',l_proc);
6512: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6513: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6514: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6515: fnd_message.raise_error;

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

6508: -- there are variable profile criteria for total coverage attached, but
6509: -- the process did not pass in a coverage volumn amount.
6510: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6511: fnd_message.set_token('L_PROC',l_proc);
6512: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6513: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6514: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6515: fnd_message.raise_error;
6516: end if;

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

6509: -- the process did not pass in a coverage volumn amount.
6510: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6511: fnd_message.set_token('L_PROC',l_proc);
6512: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6513: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6514: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6515: fnd_message.raise_error;
6516: end if;
6517: --

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

6510: fnd_message.set_name('BEN','BEN_92245_TTL_CVG_REQUIRED');
6511: fnd_message.set_token('L_PROC',l_proc);
6512: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6513: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6514: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6515: fnd_message.raise_error;
6516: end if;
6517: --
6518: -- Data found. Loop through to see we match the total amount of cvg.

Line 6515: fnd_message.raise_error;

6511: fnd_message.set_token('L_PROC',l_proc);
6512: fnd_message.set_token('VRBL_RT_PRFL_ID',to_char(p_vrbl_rt_prfl_id));
6513: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
6514: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6515: fnd_message.raise_error;
6516: end if;
6517: --
6518: -- Data found. Loop through to see we match the total amount of cvg.
6519: --

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

7303: hr_utility.set_location('p_use_globals -> true',11);
7304: else hr_utility.set_location('p_use_globals -> false',11); end if;
7305:
7306: if p_person_id is NULL then
7307: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7308: fnd_message.set_token('PACKAGE',l_package);
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('PACKAGE',l_package);

7304: else hr_utility.set_location('p_use_globals -> false',11); end if;
7305:
7306: if p_person_id is NULL then
7307: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7308: fnd_message.set_token('PACKAGE',l_package);
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:
7306: if p_person_id is NULL then
7307: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7308: fnd_message.set_token('PACKAGE',l_package);
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: if p_person_id is NULL then
7307: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7308: fnd_message.set_token('PACKAGE',l_package);
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_name('BEN','BEN_91521_BERP_PERSON_ID');
7308: fnd_message.set_token('PACKAGE',l_package);
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('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);

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

7308: fnd_message.set_token('PACKAGE',l_package);
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('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7316: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7316: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7317: fnd_message.raise_error;

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('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7316: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7317: fnd_message.raise_error;
7318: elsif p_effective_date is NULL then

Line 7315: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_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('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7316: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7317: fnd_message.raise_error;
7318: elsif p_effective_date is NULL then
7319: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');

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

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('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7316: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7317: fnd_message.raise_error;
7318: elsif p_effective_date is NULL then
7319: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7320: fnd_message.set_token('PACKAGE',l_package);

Line 7317: fnd_message.raise_error;

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('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7316: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7317: fnd_message.raise_error;
7318: elsif p_effective_date is NULL then
7319: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7320: fnd_message.set_token('PACKAGE',l_package);
7321: fnd_message.set_token('PERSON_ID',p_person_id);

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

7315: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7316: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7317: fnd_message.raise_error;
7318: elsif p_effective_date is NULL then
7319: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7320: fnd_message.set_token('PACKAGE',l_package);
7321: fnd_message.set_token('PERSON_ID',p_person_id);
7322: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

7316: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7317: fnd_message.raise_error;
7318: elsif p_effective_date is NULL then
7319: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7320: fnd_message.set_token('PACKAGE',l_package);
7321: fnd_message.set_token('PERSON_ID',p_person_id);
7322: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7317: fnd_message.raise_error;
7318: elsif p_effective_date is NULL then
7319: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7320: fnd_message.set_token('PACKAGE',l_package);
7321: fnd_message.set_token('PERSON_ID',p_person_id);
7322: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7318: elsif p_effective_date is NULL then
7319: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7320: fnd_message.set_token('PACKAGE',l_package);
7321: fnd_message.set_token('PERSON_ID',p_person_id);
7322: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7326: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7319: fnd_message.set_name('BEN','BEN_91522_BERP_EFF_DATE');
7320: fnd_message.set_token('PACKAGE',l_package);
7321: fnd_message.set_token('PERSON_ID',p_person_id);
7322: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7326: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7327: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7320: fnd_message.set_token('PACKAGE',l_package);
7321: fnd_message.set_token('PERSON_ID',p_person_id);
7322: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7326: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7327: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7328: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);

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

7321: fnd_message.set_token('PERSON_ID',p_person_id);
7322: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7326: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7327: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7328: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7329: fnd_message.raise_error;

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

7322: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7326: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7327: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7328: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7329: fnd_message.raise_error;
7330: elsif p_elig_per_elctbl_chc_id is NULL and

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

7323: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7326: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7327: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7328: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7329: fnd_message.raise_error;
7330: elsif p_elig_per_elctbl_chc_id is NULL and
7331: p_calc_only_rt_val_flag = FALSE then

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

7324: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7326: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7327: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7328: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7329: fnd_message.raise_error;
7330: elsif p_elig_per_elctbl_chc_id is NULL and
7331: p_calc_only_rt_val_flag = FALSE then
7332: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');

Line 7329: fnd_message.raise_error;

7325: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7326: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7327: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7328: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7329: fnd_message.raise_error;
7330: elsif p_elig_per_elctbl_chc_id is NULL and
7331: p_calc_only_rt_val_flag = FALSE then
7332: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7333: fnd_message.set_token('PACKAGE',l_package);

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

7328: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
7329: fnd_message.raise_error;
7330: elsif p_elig_per_elctbl_chc_id is NULL and
7331: p_calc_only_rt_val_flag = FALSE then
7332: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7333: fnd_message.set_token('PACKAGE',l_package);
7334: fnd_message.set_token('PERSON_ID',p_person_id);
7335: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

7329: fnd_message.raise_error;
7330: elsif p_elig_per_elctbl_chc_id is NULL and
7331: p_calc_only_rt_val_flag = FALSE then
7332: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7333: fnd_message.set_token('PACKAGE',l_package);
7334: fnd_message.set_token('PERSON_ID',p_person_id);
7335: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7330: elsif p_elig_per_elctbl_chc_id is NULL and
7331: p_calc_only_rt_val_flag = FALSE then
7332: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7333: fnd_message.set_token('PACKAGE',l_package);
7334: fnd_message.set_token('PERSON_ID',p_person_id);
7335: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7331: p_calc_only_rt_val_flag = FALSE then
7332: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7333: fnd_message.set_token('PACKAGE',l_package);
7334: fnd_message.set_token('PERSON_ID',p_person_id);
7335: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7332: fnd_message.set_name('BEN','BEN_91523_BERP_ELECTBL_CHC');
7333: fnd_message.set_token('PACKAGE',l_package);
7334: fnd_message.set_token('PERSON_ID',p_person_id);
7335: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7340: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7333: fnd_message.set_token('PACKAGE',l_package);
7334: fnd_message.set_token('PERSON_ID',p_person_id);
7335: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7340: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7341: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

7334: fnd_message.set_token('PERSON_ID',p_person_id);
7335: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7340: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7341: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7342: fnd_message.raise_error;

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

7335: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7340: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7341: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7342: fnd_message.raise_error;
7343: elsif (p_acty_base_rt_id is NULL and

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

7336: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7340: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7341: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7342: fnd_message.raise_error;
7343: elsif (p_acty_base_rt_id is NULL and
7344: p_actl_prem_id is NULL and

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

7337: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7340: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7341: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7342: fnd_message.raise_error;
7343: elsif (p_acty_base_rt_id is NULL and
7344: p_actl_prem_id is NULL and
7345: p_cvg_amt_calc_mthd_id is NULL) then

Line 7342: fnd_message.raise_error;

7338: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7340: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7341: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7342: fnd_message.raise_error;
7343: elsif (p_acty_base_rt_id is NULL and
7344: p_actl_prem_id is NULL and
7345: p_cvg_amt_calc_mthd_id is NULL) then
7346: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');

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

7342: fnd_message.raise_error;
7343: elsif (p_acty_base_rt_id is NULL and
7344: p_actl_prem_id is NULL and
7345: p_cvg_amt_calc_mthd_id is NULL) then
7346: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7347: fnd_message.set_token('PACKAGE',l_package);
7348: fnd_message.set_token('PERSON_ID',p_person_id);
7349: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

7343: elsif (p_acty_base_rt_id is NULL and
7344: p_actl_prem_id is NULL and
7345: p_cvg_amt_calc_mthd_id is NULL) then
7346: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7347: fnd_message.set_token('PACKAGE',l_package);
7348: fnd_message.set_token('PERSON_ID',p_person_id);
7349: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7344: p_actl_prem_id is NULL and
7345: p_cvg_amt_calc_mthd_id is NULL) then
7346: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7347: fnd_message.set_token('PACKAGE',l_package);
7348: fnd_message.set_token('PERSON_ID',p_person_id);
7349: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7345: p_cvg_amt_calc_mthd_id is NULL) then
7346: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7347: fnd_message.set_token('PACKAGE',l_package);
7348: fnd_message.set_token('PERSON_ID',p_person_id);
7349: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7353: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7346: fnd_message.set_name('BEN','BEN_91524_BERP_MISS_PRFL_ID');
7347: fnd_message.set_token('PACKAGE',l_package);
7348: fnd_message.set_token('PERSON_ID',p_person_id);
7349: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7353: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7354: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7347: fnd_message.set_token('PACKAGE',l_package);
7348: fnd_message.set_token('PERSON_ID',p_person_id);
7349: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7353: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7354: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7355: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

7348: fnd_message.set_token('PERSON_ID',p_person_id);
7349: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7353: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7354: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7355: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7356: fnd_message.raise_error;

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

7349: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7353: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7354: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7355: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7356: fnd_message.raise_error;
7357: elsif (p_acty_base_rt_id is not NULL and

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

7350: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7353: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7354: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7355: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7356: fnd_message.raise_error;
7357: elsif (p_acty_base_rt_id is not NULL and
7358: p_actl_prem_id is not NULL) or

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

7351: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7353: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7354: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7355: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7356: fnd_message.raise_error;
7357: elsif (p_acty_base_rt_id is not NULL and
7358: p_actl_prem_id is not NULL) or
7359: (p_acty_base_rt_id is not NULL and

Line 7356: fnd_message.raise_error;

7352: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7353: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7354: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7355: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7356: fnd_message.raise_error;
7357: elsif (p_acty_base_rt_id is not NULL and
7358: p_actl_prem_id is not NULL) or
7359: (p_acty_base_rt_id is not NULL and
7360: p_cvg_amt_calc_mthd_id is not NULL) or

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

7359: (p_acty_base_rt_id is not NULL and
7360: p_cvg_amt_calc_mthd_id is not NULL) or
7361: (p_actl_prem_id is not NULL and
7362: p_cvg_amt_calc_mthd_id is not NULL) then
7363: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7364: fnd_message.set_token('PACKAGE',l_package);
7365: fnd_message.set_token('PERSON_ID',p_person_id);
7366: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

7360: p_cvg_amt_calc_mthd_id is not NULL) or
7361: (p_actl_prem_id is not NULL and
7362: p_cvg_amt_calc_mthd_id is not NULL) then
7363: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7364: fnd_message.set_token('PACKAGE',l_package);
7365: fnd_message.set_token('PERSON_ID',p_person_id);
7366: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

7361: (p_actl_prem_id is not NULL and
7362: p_cvg_amt_calc_mthd_id is not NULL) then
7363: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7364: fnd_message.set_token('PACKAGE',l_package);
7365: fnd_message.set_token('PERSON_ID',p_person_id);
7366: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

7362: p_cvg_amt_calc_mthd_id is not NULL) then
7363: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7364: fnd_message.set_token('PACKAGE',l_package);
7365: fnd_message.set_token('PERSON_ID',p_person_id);
7366: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7370: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

7363: fnd_message.set_name('BEN','BEN_91525_BERP_MULTI_PRFL_ID');
7364: fnd_message.set_token('PACKAGE',l_package);
7365: fnd_message.set_token('PERSON_ID',p_person_id);
7366: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7370: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7371: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

7364: fnd_message.set_token('PACKAGE',l_package);
7365: fnd_message.set_token('PERSON_ID',p_person_id);
7366: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7370: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7371: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7372: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

7365: fnd_message.set_token('PERSON_ID',p_person_id);
7366: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7370: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7371: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7372: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7373: fnd_message.raise_error;

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

7366: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7370: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7371: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7372: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7373: fnd_message.raise_error;
7374: end if;

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

7367: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7370: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7371: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7372: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7373: fnd_message.raise_error;
7374: end if;
7375:

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

7368: fnd_message.set_token('PL_ID',to_char(p_pl_id));
7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7370: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7371: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7372: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7373: fnd_message.raise_error;
7374: end if;
7375:
7376: if p_per_row.person_id is null then

Line 7373: fnd_message.raise_error;

7369: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
7370: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
7371: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
7372: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
7373: fnd_message.raise_error;
7374: end if;
7375:
7376: if p_per_row.person_id is null then
7377: --