DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on FND_MESSAGE

Line 40: 'BEN' for fnd_message.set_name.

36: beta drop 2.
37: 18 Jan 98 G Perry 110.6 Added in real error messages
38: which are seeded in seed11.
39: 20 Jan 98 G Perry 110.7 Changed 805 application_id to use
40: 'BEN' for fnd_message.set_name.
41: 21 Jan 98 G Perry 110.8 Made caching more efficent such
42: that it doesn't bother recaching
43: when person hasn't changed.
44: 21 Jan 98 G Perry 110.9 Fixed calls to do_rounding so

Line 897: fnd_message.set_name('BEN'

893: EXCEPTION
894: --
895: WHEN OTHERS THEN
896: --
897: fnd_message.set_name('BEN'
898: ,'BEN_92311_FORMULA_VAL_PARAM');
899: fnd_message.set_token('PROC'
900: ,l_package);
901: fnd_message.set_token('FORMULA'

Line 899: fnd_message.set_token('PROC'

895: WHEN OTHERS THEN
896: --
897: fnd_message.set_name('BEN'
898: ,'BEN_92311_FORMULA_VAL_PARAM');
899: fnd_message.set_token('PROC'
900: ,l_package);
901: fnd_message.set_token('FORMULA'
902: ,p_formula_id);
903: fnd_message.set_token('PARAMETER'

Line 901: fnd_message.set_token('FORMULA'

897: fnd_message.set_name('BEN'
898: ,'BEN_92311_FORMULA_VAL_PARAM');
899: fnd_message.set_token('PROC'
900: ,l_package);
901: fnd_message.set_token('FORMULA'
902: ,p_formula_id);
903: fnd_message.set_token('PARAMETER'
904: ,l_outputs(l_outputs.FIRST).name);
905: fnd_message.raise_error;

Line 903: fnd_message.set_token('PARAMETER'

899: fnd_message.set_token('PROC'
900: ,l_package);
901: fnd_message.set_token('FORMULA'
902: ,p_formula_id);
903: fnd_message.set_token('PARAMETER'
904: ,l_outputs(l_outputs.FIRST).name);
905: fnd_message.raise_error;
906: --
907: END;

Line 905: fnd_message.raise_error;

901: fnd_message.set_token('FORMULA'
902: ,p_formula_id);
903: fnd_message.set_token('PARAMETER'
904: ,l_outputs(l_outputs.FIRST).name);
905: fnd_message.raise_error;
906: --
907: END;
908: --
909: ELSIF p_rule_type = 'DATE' THEN

Line 923: fnd_message.set_name('BEN'

919: EXCEPTION
920: --
921: WHEN OTHERS THEN
922: --
923: fnd_message.set_name('BEN'
924: ,'BEN_92311_FORMULA_VAL_PARAM');
925: fnd_message.set_token('PROC'
926: ,l_package);
927: fnd_message.set_token('FORMULA'

Line 925: fnd_message.set_token('PROC'

921: WHEN OTHERS THEN
922: --
923: fnd_message.set_name('BEN'
924: ,'BEN_92311_FORMULA_VAL_PARAM');
925: fnd_message.set_token('PROC'
926: ,l_package);
927: fnd_message.set_token('FORMULA'
928: ,p_formula_id);
929: fnd_message.set_token('PARAMETER'

Line 927: fnd_message.set_token('FORMULA'

923: fnd_message.set_name('BEN'
924: ,'BEN_92311_FORMULA_VAL_PARAM');
925: fnd_message.set_token('PROC'
926: ,l_package);
927: fnd_message.set_token('FORMULA'
928: ,p_formula_id);
929: fnd_message.set_token('PARAMETER'
930: ,l_outputs(l_outputs.FIRST).name);
931: fnd_message.raise_error;

Line 929: fnd_message.set_token('PARAMETER'

925: fnd_message.set_token('PROC'
926: ,l_package);
927: fnd_message.set_token('FORMULA'
928: ,p_formula_id);
929: fnd_message.set_token('PARAMETER'
930: ,l_outputs(l_outputs.FIRST).name);
931: fnd_message.raise_error;
932: --
933: END;

Line 931: fnd_message.raise_error;

927: fnd_message.set_token('FORMULA'
928: ,p_formula_id);
929: fnd_message.set_token('PARAMETER'
930: ,l_outputs(l_outputs.FIRST).name);
931: fnd_message.raise_error;
932: --
933: END;
934: --
935: ELSE

Line 1495: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');

1491: if nvl(l_opt_typ_cd.opt_typ_cd, 'YYY') ='CWB' then
1492: l_value := 0;
1493: l_salary.proposed_salary := 0;
1494: else
1495: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
1496: fnd_message.set_token('PACKAGE',l_proc);
1497: fnd_message.set_token('CURSOR','c_stated_salary');
1498: fnd_message.raise_error;
1499: end if;

Line 1496: fnd_message.set_token('PACKAGE',l_proc);

1492: l_value := 0;
1493: l_salary.proposed_salary := 0;
1494: else
1495: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
1496: fnd_message.set_token('PACKAGE',l_proc);
1497: fnd_message.set_token('CURSOR','c_stated_salary');
1498: fnd_message.raise_error;
1499: end if;
1500: */

Line 1497: fnd_message.set_token('CURSOR','c_stated_salary');

1493: l_salary.proposed_salary := 0;
1494: else
1495: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
1496: fnd_message.set_token('PACKAGE',l_proc);
1497: fnd_message.set_token('CURSOR','c_stated_salary');
1498: fnd_message.raise_error;
1499: end if;
1500: */
1501: return l_salary ;

Line 1498: fnd_message.raise_error;

1494: else
1495: fnd_message.set_name('BEN','BEN_91833_CURSOR_RETURN_NO_ROW');
1496: fnd_message.set_token('PACKAGE',l_proc);
1497: fnd_message.set_token('CURSOR','c_stated_salary');
1498: fnd_message.raise_error;
1499: end if;
1500: */
1501: return l_salary ;
1502: --

Line 1917: fnd_message.set_name('BEN'

1913: --
1914: -- We need to create a life event for the min max breach that
1915: -- has occured.
1916: --
1917: fnd_message.set_name('BEN'
1918: ,'BEN_91340_CREATE_PTNL_LER');
1919: fnd_message.set_token('LF_EVT'
1920: ,l_ler_name);
1921: benutils.write(p_text=> fnd_message.get);

Line 1919: fnd_message.set_token('LF_EVT'

1915: -- has occured.
1916: --
1917: fnd_message.set_name('BEN'
1918: ,'BEN_91340_CREATE_PTNL_LER');
1919: fnd_message.set_token('LF_EVT'
1920: ,l_ler_name);
1921: benutils.write(p_text=> fnd_message.get);
1922: --
1923: if not p_calculate_only_mode then

Line 1921: benutils.write(p_text=> fnd_message.get);

1917: fnd_message.set_name('BEN'
1918: ,'BEN_91340_CREATE_PTNL_LER');
1919: fnd_message.set_token('LF_EVT'
1920: ,l_ler_name);
1921: benutils.write(p_text=> fnd_message.get);
1922: --
1923: if not p_calculate_only_mode then
1924: --
1925: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf(p_validate=> FALSE

Line 2527: fnd_message.set_name('BEN'

2523: ,p_ret_val => l_dummy_num);
2524: --
2525: ELSE
2526: --
2527: fnd_message.set_name('BEN'
2528: ,'BEN_91342_UNKNOWN_CODE_1');
2529: fnd_message.set_token('PROC'
2530: ,l_package);
2531: fnd_message.set_token('CODE1'

Line 2529: fnd_message.set_token('PROC'

2525: ELSE
2526: --
2527: fnd_message.set_name('BEN'
2528: ,'BEN_91342_UNKNOWN_CODE_1');
2529: fnd_message.set_token('PROC'
2530: ,l_package);
2531: fnd_message.set_token('CODE1'
2532: ,p_rec.los_dt_to_use_cd);
2533: RAISE ben_manage_life_events.g_record_error;

Line 2531: fnd_message.set_token('CODE1'

2527: fnd_message.set_name('BEN'
2528: ,'BEN_91342_UNKNOWN_CODE_1');
2529: fnd_message.set_token('PROC'
2530: ,l_package);
2531: fnd_message.set_token('CODE1'
2532: ,p_rec.los_dt_to_use_cd);
2533: RAISE ben_manage_life_events.g_record_error;
2534: --
2535: END IF;

Line 3177: fnd_message.set_name('BEN'

3173: --
3174: ben_person_object.get_object(p_bnfts_bal_id=> p_rec.bnfts_bal_id
3175: ,p_rec => l_bnb_rec);
3176: --
3177: fnd_message.set_name('BEN'
3178: ,'BEN_92317_PER_BALANCE_NULL');
3179: fnd_message.set_token('NAME'
3180: ,l_bnb_rec.name);
3181: fnd_message.set_token('DATE'

Line 3179: fnd_message.set_token('NAME'

3175: ,p_rec => l_bnb_rec);
3176: --
3177: fnd_message.set_name('BEN'
3178: ,'BEN_92317_PER_BALANCE_NULL');
3179: fnd_message.set_token('NAME'
3180: ,l_bnb_rec.name);
3181: fnd_message.set_token('DATE'
3182: ,l_start_date);
3183: benutils.write(p_text=> fnd_message.get);

Line 3181: fnd_message.set_token('DATE'

3177: fnd_message.set_name('BEN'
3178: ,'BEN_92317_PER_BALANCE_NULL');
3179: fnd_message.set_token('NAME'
3180: ,l_bnb_rec.name);
3181: fnd_message.set_token('DATE'
3182: ,l_start_date);
3183: benutils.write(p_text=> fnd_message.get);
3184: --
3185: ben_person_object.get_object(p_person_id=> p_person_id

Line 3183: benutils.write(p_text=> fnd_message.get);

3179: fnd_message.set_token('NAME'
3180: ,l_bnb_rec.name);
3181: fnd_message.set_token('DATE'
3182: ,l_start_date);
3183: benutils.write(p_text=> fnd_message.get);
3184: --
3185: ben_person_object.get_object(p_person_id=> p_person_id
3186: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
3187: ,p_effective_date))

Line 3198: fnd_message.set_name('BEN'

3194: end if;
3195: --
3196: IF l_result IS NULL THEN
3197: --
3198: fnd_message.set_name('BEN'
3199: ,'BEN_92317_PER_BALANCE_NULL');
3200: fnd_message.set_token('NAME'
3201: ,l_bnb_rec.name);
3202: fnd_message.set_token('DATE'

Line 3200: fnd_message.set_token('NAME'

3196: IF l_result IS NULL THEN
3197: --
3198: fnd_message.set_name('BEN'
3199: ,'BEN_92317_PER_BALANCE_NULL');
3200: fnd_message.set_token('NAME'
3201: ,l_bnb_rec.name);
3202: fnd_message.set_token('DATE'
3203: ,NVL(p_lf_evt_ocrd_dt
3204: ,p_effective_date));

Line 3202: fnd_message.set_token('DATE'

3198: fnd_message.set_name('BEN'
3199: ,'BEN_92317_PER_BALANCE_NULL');
3200: fnd_message.set_token('NAME'
3201: ,l_bnb_rec.name);
3202: fnd_message.set_token('DATE'
3203: ,NVL(p_lf_evt_ocrd_dt
3204: ,p_effective_date));
3205: benutils.write(p_text=> fnd_message.get);
3206: RETURN NULL;

Line 3205: benutils.write(p_text=> fnd_message.get);

3201: ,l_bnb_rec.name);
3202: fnd_message.set_token('DATE'
3203: ,NVL(p_lf_evt_ocrd_dt
3204: ,p_effective_date));
3205: benutils.write(p_text=> fnd_message.get);
3206: RETURN NULL;
3207: --
3208: END IF;
3209: --

Line 3267: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');

3263: end ;
3264: --
3265: end if;
3266: if l_result is null then
3267: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
3268: fnd_message.set_token('DATE' ,l_start_date);
3269: benutils.write(p_text=> fnd_message.get);
3270: return null;
3271: end if;

Line 3268: fnd_message.set_token('DATE' ,l_start_date);

3264: --
3265: end if;
3266: if l_result is null then
3267: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
3268: fnd_message.set_token('DATE' ,l_start_date);
3269: benutils.write(p_text=> fnd_message.get);
3270: return null;
3271: end if;
3272:

Line 3269: benutils.write(p_text=> fnd_message.get);

3265: end if;
3266: if l_result is null then
3267: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
3268: fnd_message.set_token('DATE' ,l_start_date);
3269: benutils.write(p_text=> fnd_message.get);
3270: return null;
3271: end if;
3272:
3273: --

Line 3311: fnd_message.set_name('BEN'

3307: -- Person does not have a balance, recheck if they have a balance
3308: -- as of the life event occurred date or effective date.
3309: -- Fix for bug 216.
3310: --
3311: fnd_message.set_name('BEN'
3312: ,'BEN_92318_BEN_BALANCE_NULL');
3313: fnd_message.set_token('DATE'
3314: ,l_start_date);
3315: benutils.write(p_text=> fnd_message.get);

Line 3313: fnd_message.set_token('DATE'

3309: -- Fix for bug 216.
3310: --
3311: fnd_message.set_name('BEN'
3312: ,'BEN_92318_BEN_BALANCE_NULL');
3313: fnd_message.set_token('DATE'
3314: ,l_start_date);
3315: benutils.write(p_text=> fnd_message.get);
3316: --
3317: l_result :=

Line 3315: benutils.write(p_text=> fnd_message.get);

3311: fnd_message.set_name('BEN'
3312: ,'BEN_92318_BEN_BALANCE_NULL');
3313: fnd_message.set_token('DATE'
3314: ,l_start_date);
3315: benutils.write(p_text=> fnd_message.get);
3316: --
3317: l_result :=
3318: pay_balance_pkg.get_value(p_rec.defined_balance_id
3319: ,l_ass_rec.assignment_id

Line 3325: fnd_message.set_name('BEN'

3321: ,p_effective_date));
3322: --
3323: IF l_result IS NULL THEN
3324: --
3325: fnd_message.set_name('BEN'
3326: ,'BEN_92318_BEN_BALANCE_NULL');
3327: fnd_message.set_token('DATE'
3328: ,NVL(p_lf_evt_ocrd_dt
3329: ,p_effective_date));

Line 3327: fnd_message.set_token('DATE'

3323: IF l_result IS NULL THEN
3324: --
3325: fnd_message.set_name('BEN'
3326: ,'BEN_92318_BEN_BALANCE_NULL');
3327: fnd_message.set_token('DATE'
3328: ,NVL(p_lf_evt_ocrd_dt
3329: ,p_effective_date));
3330: benutils.write(p_text=> fnd_message.get);
3331: RETURN NULL;

Line 3330: benutils.write(p_text=> fnd_message.get);

3326: ,'BEN_92318_BEN_BALANCE_NULL');
3327: fnd_message.set_token('DATE'
3328: ,NVL(p_lf_evt_ocrd_dt
3329: ,p_effective_date));
3330: benutils.write(p_text=> fnd_message.get);
3331: RETURN NULL;
3332: --
3333: END IF;
3334: --

Line 3481: fnd_message.set_name('BEN'

3477: -- Person does not have a balance, recheck if they have a balance
3478: -- as of the life event occurred date or effective date.
3479: -- Fix for bug 216.
3480: --
3481: fnd_message.set_name('BEN'
3482: ,'BEN_92319_SAL_BALANCE_NULL');
3483: fnd_message.set_token('DATE'
3484: ,l_start_date);
3485: benutils.write(p_text=> fnd_message.get);

Line 3483: fnd_message.set_token('DATE'

3479: -- Fix for bug 216.
3480: --
3481: fnd_message.set_name('BEN'
3482: ,'BEN_92319_SAL_BALANCE_NULL');
3483: fnd_message.set_token('DATE'
3484: ,l_start_date);
3485: benutils.write(p_text=> fnd_message.get);
3486: ---if date code is
3487: -- first of year,half year,quarter,month,semi month,previos oct 1

Line 3485: benutils.write(p_text=> fnd_message.get);

3481: fnd_message.set_name('BEN'
3482: ,'BEN_92319_SAL_BALANCE_NULL');
3483: fnd_message.set_token('DATE'
3484: ,l_start_date);
3485: benutils.write(p_text=> fnd_message.get);
3486: ---if date code is
3487: -- first of year,half year,quarter,month,semi month,previos oct 1
3488: -- then take the firstist salary
3489: if p_rec.comp_lvl_det_cd in

Line 3523: fnd_message.set_name('BEN'

3519: ,p_effective_date));
3520: --
3521: IF l_result IS NULL THEN
3522: --
3523: fnd_message.set_name('BEN'
3524: ,'BEN_92319_SAL_BALANCE_NULL');
3525: fnd_message.set_token('DATE'
3526: ,NVL(p_lf_evt_ocrd_dt
3527: ,p_effective_date));

Line 3525: fnd_message.set_token('DATE'

3521: IF l_result IS NULL THEN
3522: --
3523: fnd_message.set_name('BEN'
3524: ,'BEN_92319_SAL_BALANCE_NULL');
3525: fnd_message.set_token('DATE'
3526: ,NVL(p_lf_evt_ocrd_dt
3527: ,p_effective_date));
3528: benutils.write(p_text=> fnd_message.get);
3529: RETURN NULL;

Line 3528: benutils.write(p_text=> fnd_message.get);

3524: ,'BEN_92319_SAL_BALANCE_NULL');
3525: fnd_message.set_token('DATE'
3526: ,NVL(p_lf_evt_ocrd_dt
3527: ,p_effective_date));
3528: benutils.write(p_text=> fnd_message.get);
3529: RETURN NULL;
3530: --
3531: END IF;
3532: --

Line 3588: fnd_message.set_name('BEN'

3584: --
3585: ben_person_object.get_object(p_bnfts_bal_id=> p_rec.bnfts_bal_id
3586: ,p_rec => l_bnb_rec);
3587: --
3588: fnd_message.set_name('BEN'
3589: ,'BEN_92317_PER_BALANCE_NULL');
3590: fnd_message.set_token('NAME'
3591: ,l_bnb_rec.name);
3592: fnd_message.set_token('DATE'

Line 3590: fnd_message.set_token('NAME'

3586: ,p_rec => l_bnb_rec);
3587: --
3588: fnd_message.set_name('BEN'
3589: ,'BEN_92317_PER_BALANCE_NULL');
3590: fnd_message.set_token('NAME'
3591: ,l_bnb_rec.name);
3592: fnd_message.set_token('DATE'
3593: ,l_start_date);
3594: benutils.write(p_text=> fnd_message.get);

Line 3592: fnd_message.set_token('DATE'

3588: fnd_message.set_name('BEN'
3589: ,'BEN_92317_PER_BALANCE_NULL');
3590: fnd_message.set_token('NAME'
3591: ,l_bnb_rec.name);
3592: fnd_message.set_token('DATE'
3593: ,l_start_date);
3594: benutils.write(p_text=> fnd_message.get);
3595: --
3596: ben_person_object.get_object(p_person_id=> p_person_id

Line 3594: benutils.write(p_text=> fnd_message.get);

3590: fnd_message.set_token('NAME'
3591: ,l_bnb_rec.name);
3592: fnd_message.set_token('DATE'
3593: ,l_start_date);
3594: benutils.write(p_text=> fnd_message.get);
3595: --
3596: ben_person_object.get_object(p_person_id=> p_person_id
3597: ,p_effective_date => p_effective_date
3598: ,p_bnfts_bal_id => p_rec.bnfts_bal_id

Line 3605: fnd_message.set_name('BEN'

3601: l_result := l_bal_rec.val;
3602: --
3603: IF l_result IS NULL THEN
3604: --
3605: fnd_message.set_name('BEN'
3606: ,'BEN_92317_PER_BALANCE_NULL');
3607: fnd_message.set_token('NAME'
3608: ,l_bnb_rec.name);
3609: fnd_message.set_token('DATE'

Line 3607: fnd_message.set_token('NAME'

3603: IF l_result IS NULL THEN
3604: --
3605: fnd_message.set_name('BEN'
3606: ,'BEN_92317_PER_BALANCE_NULL');
3607: fnd_message.set_token('NAME'
3608: ,l_bnb_rec.name);
3609: fnd_message.set_token('DATE'
3610: ,NVL(p_lf_evt_ocrd_dt
3611: ,p_effective_date));

Line 3609: fnd_message.set_token('DATE'

3605: fnd_message.set_name('BEN'
3606: ,'BEN_92317_PER_BALANCE_NULL');
3607: fnd_message.set_token('NAME'
3608: ,l_bnb_rec.name);
3609: fnd_message.set_token('DATE'
3610: ,NVL(p_lf_evt_ocrd_dt
3611: ,p_effective_date));
3612: benutils.write(p_text=> fnd_message.get);
3613: RETURN NULL;

Line 3612: benutils.write(p_text=> fnd_message.get);

3608: ,l_bnb_rec.name);
3609: fnd_message.set_token('DATE'
3610: ,NVL(p_lf_evt_ocrd_dt
3611: ,p_effective_date));
3612: benutils.write(p_text=> fnd_message.get);
3613: RETURN NULL;
3614: --
3615: END IF;
3616: --

Line 3676: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');

3672: --
3673: end if ;
3674:
3675: if l_result is null then
3676: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
3677: fnd_message.set_token('DATE' ,l_start_date);
3678: benutils.write(p_text=> fnd_message.get);
3679: return null;
3680: end if;

Line 3677: fnd_message.set_token('DATE' ,l_start_date);

3673: end if ;
3674:
3675: if l_result is null then
3676: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
3677: fnd_message.set_token('DATE' ,l_start_date);
3678: benutils.write(p_text=> fnd_message.get);
3679: return null;
3680: end if;
3681: --

Line 3678: benutils.write(p_text=> fnd_message.get);

3674:
3675: if l_result is null then
3676: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
3677: fnd_message.set_token('DATE' ,l_start_date);
3678: benutils.write(p_text=> fnd_message.get);
3679: return null;
3680: end if;
3681: --
3682: --

Line 3718: fnd_message.set_name('BEN'

3714: -- Person does not have a balance, recheck if they have a balance
3715: -- as of the life event occurred date or effective date.
3716: -- Fix for bug 216.
3717: --
3718: fnd_message.set_name('BEN'
3719: ,'BEN_92318_BEN_BALANCE_NULL');
3720: fnd_message.set_token('DATE'
3721: ,l_start_date);
3722: benutils.write(p_text=> fnd_message.get);

Line 3720: fnd_message.set_token('DATE'

3716: -- Fix for bug 216.
3717: --
3718: fnd_message.set_name('BEN'
3719: ,'BEN_92318_BEN_BALANCE_NULL');
3720: fnd_message.set_token('DATE'
3721: ,l_start_date);
3722: benutils.write(p_text=> fnd_message.get);
3723: l_result :=
3724: pay_balance_pkg.get_value(p_rec.defined_balance_id

Line 3722: benutils.write(p_text=> fnd_message.get);

3718: fnd_message.set_name('BEN'
3719: ,'BEN_92318_BEN_BALANCE_NULL');
3720: fnd_message.set_token('DATE'
3721: ,l_start_date);
3722: benutils.write(p_text=> fnd_message.get);
3723: l_result :=
3724: pay_balance_pkg.get_value(p_rec.defined_balance_id
3725: ,l_ass_rec.assignment_id
3726: ,NVL(p_lf_evt_ocrd_dt

Line 3731: fnd_message.set_name('BEN'

3727: ,p_effective_date));
3728: --
3729: IF l_result IS NULL THEN
3730: --
3731: fnd_message.set_name('BEN'
3732: ,'BEN_92318_BEN_BALANCE_NULL');
3733: fnd_message.set_token('DATE'
3734: ,NVL(p_lf_evt_ocrd_dt
3735: ,p_effective_date));

Line 3733: fnd_message.set_token('DATE'

3729: IF l_result IS NULL THEN
3730: --
3731: fnd_message.set_name('BEN'
3732: ,'BEN_92318_BEN_BALANCE_NULL');
3733: fnd_message.set_token('DATE'
3734: ,NVL(p_lf_evt_ocrd_dt
3735: ,p_effective_date));
3736: benutils.write(p_text=> fnd_message.get);
3737: RETURN NULL;

Line 3736: benutils.write(p_text=> fnd_message.get);

3732: ,'BEN_92318_BEN_BALANCE_NULL');
3733: fnd_message.set_token('DATE'
3734: ,NVL(p_lf_evt_ocrd_dt
3735: ,p_effective_date));
3736: benutils.write(p_text=> fnd_message.get);
3737: RETURN NULL;
3738: --
3739: END IF;
3740: --