DBA Data[Home] [Help]

APPS.BEN_LSF_BUS dependencies on FND_MESSAGE

Line 214: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');

210: p_effective_date => p_effective_date) then
211: --
212: -- raise error as does not exist as lookup
213: --
214: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
215: fnd_message.raise_error;
216: --
217: end if;
218: --

Line 215: fnd_message.raise_error;

211: --
212: -- raise error as does not exist as lookup
213: --
214: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
215: fnd_message.raise_error;
216: --
217: end if;
218: --
219: end if;

Line 307: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

303: close c1;
304: --
305: -- raise error
306: --
307: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
308: fnd_message.set_token('ID',p_los_calc_rl);
309: fnd_message.set_token('TYPE_ID',-510);
310: fnd_message.raise_error;
311: --

Line 308: fnd_message.set_token('ID',p_los_calc_rl);

304: --
305: -- raise error
306: --
307: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
308: fnd_message.set_token('ID',p_los_calc_rl);
309: fnd_message.set_token('TYPE_ID',-510);
310: fnd_message.raise_error;
311: --
312: end if;

Line 309: fnd_message.set_token('TYPE_ID',-510);

305: -- raise error
306: --
307: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
308: fnd_message.set_token('ID',p_los_calc_rl);
309: fnd_message.set_token('TYPE_ID',-510);
310: fnd_message.raise_error;
311: --
312: end if;
313: --

Line 310: fnd_message.raise_error;

306: --
307: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
308: fnd_message.set_token('ID',p_los_calc_rl);
309: fnd_message.set_token('TYPE_ID',-510);
310: fnd_message.raise_error;
311: --
312: end if;
313: --
314: close c1;

Line 379: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

375: p_effective_date => p_effective_date) then
376: --
377: -- raise error as does not exist as lookup
378: --
379: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
380: fnd_message.set_token('FIELD', 'p_los_alt_val_to_use_cd');
381: fnd_message.set_token('TYPE', 'BEN_LOS_ALT_VAL_TO_USE');
382: fnd_message.raise_error;
383: --

Line 380: fnd_message.set_token('FIELD', 'p_los_alt_val_to_use_cd');

376: --
377: -- raise error as does not exist as lookup
378: --
379: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
380: fnd_message.set_token('FIELD', 'p_los_alt_val_to_use_cd');
381: fnd_message.set_token('TYPE', 'BEN_LOS_ALT_VAL_TO_USE');
382: fnd_message.raise_error;
383: --
384: end if;

Line 381: fnd_message.set_token('TYPE', 'BEN_LOS_ALT_VAL_TO_USE');

377: -- raise error as does not exist as lookup
378: --
379: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
380: fnd_message.set_token('FIELD', 'p_los_alt_val_to_use_cd');
381: fnd_message.set_token('TYPE', 'BEN_LOS_ALT_VAL_TO_USE');
382: fnd_message.raise_error;
383: --
384: end if;
385: --

Line 382: fnd_message.raise_error;

378: --
379: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
380: fnd_message.set_token('FIELD', 'p_los_alt_val_to_use_cd');
381: fnd_message.set_token('TYPE', 'BEN_LOS_ALT_VAL_TO_USE');
382: fnd_message.raise_error;
383: --
384: end if;
385: --
386: end if;

Line 449: fnd_message.set_name('BEN','BEN_91063_INVLD_LOS_DT_USE_CD');

445: p_effective_date => p_effective_date) then
446: --
447: -- raise error as does not exist as lookup
448: --
449: fnd_message.set_name('BEN','BEN_91063_INVLD_LOS_DT_USE_CD');
450: fnd_message.raise_error;
451: --
452: end if;
453: --

Line 450: fnd_message.raise_error;

446: --
447: -- raise error as does not exist as lookup
448: --
449: fnd_message.set_name('BEN','BEN_91063_INVLD_LOS_DT_USE_CD');
450: fnd_message.raise_error;
451: --
452: end if;
453: --
454: end if;

Line 517: fnd_message.set_name('BEN','BEN_91041_INVALID_RNDG_CD');

513: p_effective_date => p_effective_date) then
514: --
515: -- raise error as does not exist as lookup
516: --
517: fnd_message.set_name('BEN','BEN_91041_INVALID_RNDG_CD');
518: fnd_message.raise_error;
519: --
520: end if;
521: --

Line 518: fnd_message.raise_error;

514: --
515: -- raise error as does not exist as lookup
516: --
517: fnd_message.set_name('BEN','BEN_91041_INVALID_RNDG_CD');
518: fnd_message.raise_error;
519: --
520: end if;
521: --
522: end if;

Line 585: fnd_message.set_name('BEN','BEN_91065_INVLD_LOS_DET_CD');

581: p_effective_date => p_effective_date) then
582: --
583: -- raise error as does not exist as lookup
584: --
585: fnd_message.set_name('BEN','BEN_91065_INVLD_LOS_DET_CD');
586: fnd_message.raise_error;
587: --
588: end if;
589: --

Line 586: fnd_message.raise_error;

582: --
583: -- raise error as does not exist as lookup
584: --
585: fnd_message.set_name('BEN','BEN_91065_INVLD_LOS_DET_CD');
586: fnd_message.raise_error;
587: --
588: end if;
589: --
590: end if;

Line 629: fnd_message.set_name('BEN','BEN_91051_INVALID_MIN_FLAG');

625: p_effective_date => p_effective_date) then
626: --
627: -- raise error as does not exist as lookup
628: --
629: fnd_message.set_name('BEN','BEN_91051_INVALID_MIN_FLAG');
630: fnd_message.raise_error;
631: --
632: end if;
633: --

Line 630: fnd_message.raise_error;

626: --
627: -- raise error as does not exist as lookup
628: --
629: fnd_message.set_name('BEN','BEN_91051_INVALID_MIN_FLAG');
630: fnd_message.raise_error;
631: --
632: end if;
633: --
634: end if;

Line 674: fnd_message.set_name('BEN','BEN_91052_INVALID_MAX_FLAG');

670: p_effective_date => p_effective_date) then
671: --
672: -- raise error as does not exist as lookup
673: --
674: fnd_message.set_name('BEN','BEN_91052_INVALID_MAX_FLAG');
675: fnd_message.raise_error;
676: --
677: end if;
678: --

Line 675: fnd_message.raise_error;

671: --
672: -- raise error as does not exist as lookup
673: --
674: fnd_message.set_name('BEN','BEN_91052_INVALID_MAX_FLAG');
675: fnd_message.raise_error;
676: --
677: end if;
678: --
679: end if;

Line 772: fnd_message.set_name('BEN','BEN_91066_INVLD_LOS_DET_RL');

768: close c1;
769: --
770: -- raise error
771: --
772: fnd_message.set_name('BEN','BEN_91066_INVLD_LOS_DET_RL');
773: fnd_message.raise_error;
774: --
775: end if;
776: --

Line 773: fnd_message.raise_error;

769: --
770: -- raise error
771: --
772: fnd_message.set_name('BEN','BEN_91066_INVLD_LOS_DET_RL');
773: fnd_message.raise_error;
774: --
775: end if;
776: --
777: close c1;

Line 787: fnd_message.set_name('BEN', 'BEN_91071_LOS_DET_RL_NOT_NULL');

783: --
784: -- Unless LOS determination Code = Rule, LOS determination rule must be blank.
785: if nvl(p_los_det_cd,hr_api.g_varchar2) <> 'RL' and p_los_det_rl is not null then
786: --
787: fnd_message.set_name('BEN', 'BEN_91071_LOS_DET_RL_NOT_NULL');
788: fnd_message.raise_error;
789: --
790: elsif nvl(p_los_det_cd,hr_api.g_varchar2) = 'RL' and p_los_det_rl is null then
791: --

Line 788: fnd_message.raise_error;

784: -- Unless LOS determination Code = Rule, LOS determination rule must be blank.
785: if nvl(p_los_det_cd,hr_api.g_varchar2) <> 'RL' and p_los_det_rl is not null then
786: --
787: fnd_message.set_name('BEN', 'BEN_91071_LOS_DET_RL_NOT_NULL');
788: fnd_message.raise_error;
789: --
790: elsif nvl(p_los_det_cd,hr_api.g_varchar2) = 'RL' and p_los_det_rl is null then
791: --
792: fnd_message.set_name('BEN', 'BEN_91098_LOS_DET_RL_NULL');

Line 792: fnd_message.set_name('BEN', 'BEN_91098_LOS_DET_RL_NULL');

788: fnd_message.raise_error;
789: --
790: elsif nvl(p_los_det_cd,hr_api.g_varchar2) = 'RL' and p_los_det_rl is null then
791: --
792: fnd_message.set_name('BEN', 'BEN_91098_LOS_DET_RL_NULL');
793: fnd_message.raise_error;
794: --
795: end if;
796: --

Line 793: fnd_message.raise_error;

789: --
790: elsif nvl(p_los_det_cd,hr_api.g_varchar2) = 'RL' and p_los_det_rl is null then
791: --
792: fnd_message.set_name('BEN', 'BEN_91098_LOS_DET_RL_NULL');
793: fnd_message.raise_error;
794: --
795: end if;
796: --
797: hr_utility.set_location('Leaving:'||l_proc,10);

Line 888: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');

884: close c1;
885: --
886: -- raise error
887: --
888: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');
889: fnd_message.raise_error;
890: --
891: end if;
892: --

Line 889: fnd_message.raise_error;

885: --
886: -- raise error
887: --
888: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');
889: fnd_message.raise_error;
890: --
891: end if;
892: --
893: close c1;

Line 900: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');

896: --
897: -- Unless Rounding Code = Rule, Rounding rule must be blank.
898: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
899: --
900: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
901: fnd_message.raise_error;
902: --
903: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
904: --

Line 901: fnd_message.raise_error;

897: -- Unless Rounding Code = Rule, Rounding rule must be blank.
898: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
899: --
900: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
901: fnd_message.raise_error;
902: --
903: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
904: --
905: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');

Line 905: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');

901: fnd_message.raise_error;
902: --
903: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
904: --
905: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
906: fnd_message.raise_error;
907: --
908: end if;
909: --

Line 906: fnd_message.raise_error;

902: --
903: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
904: --
905: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
906: fnd_message.raise_error;
907: --
908: end if;
909: --
910: --

Line 1002: fnd_message.set_name('BEN','BEN_91064_INVLD_LOS_DT_USE_RL');

998: close c1;
999: --
1000: -- raise error
1001: --
1002: fnd_message.set_name('BEN','BEN_91064_INVLD_LOS_DT_USE_RL');
1003: fnd_message.raise_error;
1004: --
1005: end if;
1006: --

Line 1003: fnd_message.raise_error;

999: --
1000: -- raise error
1001: --
1002: fnd_message.set_name('BEN','BEN_91064_INVLD_LOS_DT_USE_RL');
1003: fnd_message.raise_error;
1004: --
1005: end if;
1006: --
1007: close c1;

Line 1015: fnd_message.set_name('BEN', 'BEN_91072_LOS_DT_RL_NOT_NULL');

1011: --
1012: -- Unless los_dt_to_use Code = Rule, los_dt_to_use rule must be blank.
1013: if nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) <> 'RL' and p_los_dt_to_use_rl is not null then
1014: --
1015: fnd_message.set_name('BEN', 'BEN_91072_LOS_DT_RL_NOT_NULL');
1016: fnd_message.raise_error;
1017: --
1018: elsif nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) = 'RL' and p_los_dt_to_use_rl is null then
1019: --

Line 1016: fnd_message.raise_error;

1012: -- Unless los_dt_to_use Code = Rule, los_dt_to_use rule must be blank.
1013: if nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) <> 'RL' and p_los_dt_to_use_rl is not null then
1014: --
1015: fnd_message.set_name('BEN', 'BEN_91072_LOS_DT_RL_NOT_NULL');
1016: fnd_message.raise_error;
1017: --
1018: elsif nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) = 'RL' and p_los_dt_to_use_rl is null then
1019: --
1020: fnd_message.set_name('BEN', 'BEN_91099_LOS_DT_RL_NULL');

Line 1020: fnd_message.set_name('BEN', 'BEN_91099_LOS_DT_RL_NULL');

1016: fnd_message.raise_error;
1017: --
1018: elsif nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) = 'RL' and p_los_dt_to_use_rl is null then
1019: --
1020: fnd_message.set_name('BEN', 'BEN_91099_LOS_DT_RL_NULL');
1021: fnd_message.raise_error;
1022: --
1023: end if;
1024: --

Line 1021: fnd_message.raise_error;

1017: --
1018: elsif nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) = 'RL' and p_los_dt_to_use_rl is null then
1019: --
1020: fnd_message.set_name('BEN', 'BEN_91099_LOS_DT_RL_NULL');
1021: fnd_message.raise_error;
1022: --
1023: end if;
1024: --
1025: hr_utility.set_location('Leaving:'||l_proc,10);

Line 1103: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

1099: close c1;
1100: --
1101: -- raise error
1102: --
1103: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1104: fnd_message.raise_error;
1105: --
1106: end if;
1107: --

Line 1104: fnd_message.raise_error;

1100: --
1101: -- raise error
1102: --
1103: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1104: fnd_message.raise_error;
1105: --
1106: end if;
1107: --
1108: close c1;

Line 1173: fnd_message.set_name('BEN','BEN_9XXXX_INV_CALC_RL_N_CDS');

1169: ( p_los_calc_rl is null and (p_los_det_cd is null or
1170: p_los_dt_to_use_cd is null))
1171: then
1172: --
1173: fnd_message.set_name('BEN','BEN_9XXXX_INV_CALC_RL_N_CDS');
1174: fnd_message.raise_error;
1175: --
1176: end if;
1177: -- */

Line 1174: fnd_message.raise_error;

1170: p_los_dt_to_use_cd is null))
1171: then
1172: --
1173: fnd_message.set_name('BEN','BEN_9XXXX_INV_CALC_RL_N_CDS');
1174: fnd_message.raise_error;
1175: --
1176: end if;
1177: -- */
1178: if p_mn_los_num is not null and p_mx_los_num is not null then

Line 1186: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');

1182: -- Bug Fix 1873685
1183: if (p_mx_los_num < p_mn_los_num) then
1184: -- if (p_mx_los_num <= p_mn_los_num) then
1185: -- End fix 1873685
1186: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
1187: fnd_message.raise_error;
1188: end if;
1189: --
1190: --

Line 1187: fnd_message.raise_error;

1183: if (p_mx_los_num < p_mn_los_num) then
1184: -- if (p_mx_los_num <= p_mn_los_num) then
1185: -- End fix 1873685
1186: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
1187: fnd_message.raise_error;
1188: end if;
1189: --
1190: --
1191: end if;

Line 1199: fnd_message.set_name('BEN','BEN_92350_MIN_VAL_RULE');

1195: --
1196: if nvl( p_no_mn_los_num_apls_flag, hr_api.g_varchar2) = 'Y'
1197: and (p_mn_los_num is not null /*or p_los_calc_rl is not null*/) then
1198: --
1199: fnd_message.set_name('BEN','BEN_92350_MIN_VAL_RULE');
1200: fnd_message.raise_error;
1201: --
1202: end if;
1203: --

Line 1200: fnd_message.raise_error;

1196: if nvl( p_no_mn_los_num_apls_flag, hr_api.g_varchar2) = 'Y'
1197: and (p_mn_los_num is not null /*or p_los_calc_rl is not null*/) then
1198: --
1199: fnd_message.set_name('BEN','BEN_92350_MIN_VAL_RULE');
1200: fnd_message.raise_error;
1201: --
1202: end if;
1203: --
1204: if nvl( p_no_mn_los_num_apls_flag, hr_api.g_varchar2) = 'N' and

Line 1209: fnd_message.set_name('BEN','BEN_92300_MIN_VAL_OR_RULE_REQ');

1205: nvl(p_no_mx_los_num_apls_flag, hr_api.g_varchar2) = 'N' and
1206: p_mn_los_num is null and p_mx_los_num is null /* and
1207: p_los_calc_rl is null*/ then
1208: --
1209: fnd_message.set_name('BEN','BEN_92300_MIN_VAL_OR_RULE_REQ');
1210: fnd_message.raise_error;
1211: --
1212: end if;
1213: --

Line 1210: fnd_message.raise_error;

1206: p_mn_los_num is null and p_mx_los_num is null /* and
1207: p_los_calc_rl is null*/ then
1208: --
1209: fnd_message.set_name('BEN','BEN_92300_MIN_VAL_OR_RULE_REQ');
1210: fnd_message.raise_error;
1211: --
1212: end if;
1213: --
1214: -- If No Maximum Percent value flag set to "on" (Y),

Line 1220: fnd_message.set_name('BEN','BEN_92301_MAX_VAL_RULE');

1216: --
1217: if nvl( p_no_mx_los_num_apls_flag, hr_api.g_varchar2) = 'Y'
1218: and (p_mx_los_num is not null /* or p_los_calc_rl is not null */) then
1219: --
1220: fnd_message.set_name('BEN','BEN_92301_MAX_VAL_RULE');
1221: fnd_message.raise_error;
1222: --
1223: end if;
1224: --

Line 1221: fnd_message.raise_error;

1217: if nvl( p_no_mx_los_num_apls_flag, hr_api.g_varchar2) = 'Y'
1218: and (p_mx_los_num is not null /* or p_los_calc_rl is not null */) then
1219: --
1220: fnd_message.set_name('BEN','BEN_92301_MAX_VAL_RULE');
1221: fnd_message.raise_error;
1222: --
1223: end if;
1224: --
1225: -- if p_los_calc_rl is null then

Line 1230: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');

1226: if p_no_mn_los_num_apls_flag = 'Y' or p_mn_los_num is not null then
1227: --
1228: if p_no_mx_los_num_apls_flag = 'N' and p_mx_los_num is null then
1229: --
1230: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
1231: fnd_message.raise_error;
1232: --
1233: end if;
1234: elsif p_no_mx_los_num_apls_flag = 'Y' or p_mx_los_num is not null then

Line 1231: fnd_message.raise_error;

1227: --
1228: if p_no_mx_los_num_apls_flag = 'N' and p_mx_los_num is null then
1229: --
1230: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
1231: fnd_message.raise_error;
1232: --
1233: end if;
1234: elsif p_no_mx_los_num_apls_flag = 'Y' or p_mx_los_num is not null then
1235: --

Line 1238: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');

1234: elsif p_no_mx_los_num_apls_flag = 'Y' or p_mx_los_num is not null then
1235: --
1236: if p_no_mn_los_num_apls_flag = 'N' and p_mn_los_num is null then
1237: --
1238: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
1239: fnd_message.raise_error;
1240: --
1241: end if;
1242: end if;

Line 1239: fnd_message.raise_error;

1235: --
1236: if p_no_mn_los_num_apls_flag = 'N' and p_mn_los_num is null then
1237: --
1238: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
1239: fnd_message.raise_error;
1240: --
1241: end if;
1242: end if;
1243: -- end if;

Line 1299: fnd_message.set_name('BEN','BEN_91739_LOS_CHLD_RCD_EXISTS');

1295: close chk_cmbn_age_los_fctr;
1296: --
1297: -- raise error
1298: --
1299: fnd_message.set_name('BEN','BEN_91739_LOS_CHLD_RCD_EXISTS');
1300: fnd_message.raise_error;
1301: --
1302: end if;
1303: --

Line 1300: fnd_message.raise_error;

1296: --
1297: -- raise error
1298: --
1299: fnd_message.set_name('BEN','BEN_91739_LOS_CHLD_RCD_EXISTS');
1300: fnd_message.raise_error;
1301: --
1302: end if;
1303: --
1304: close chk_cmbn_age_los_fctr;*/ --Bug 2978945 Used the common function instead of cursor

Line 1636: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1632: close csr_leg_code;
1633: --
1634: -- The primary key is invalid therefore we must error
1635: --
1636: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1637: fnd_message.raise_error;
1638: --
1639: end if;
1640: --

Line 1637: fnd_message.raise_error;

1633: --
1634: -- The primary key is invalid therefore we must error
1635: --
1636: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1637: fnd_message.raise_error;
1638: --
1639: end if;
1640: --
1641: close csr_leg_code;