206: p_effective_date => p_effective_date) then
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');
212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');
213: fnd_message.raise_error;
214: --
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');
212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');
213: fnd_message.raise_error;
214: --
215: end if;
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');
212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');
212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: end if;
279: p_effective_date => p_effective_date) then
280: --
281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rndg_rl);
285: fnd_message.set_token('TYPE_ID',-169);
286: fnd_message.raise_error;
287: --
280: --
281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rndg_rl);
285: fnd_message.set_token('TYPE_ID',-169);
286: fnd_message.raise_error;
287: --
288: end if;
281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rndg_rl);
285: fnd_message.set_token('TYPE_ID',-169);
286: fnd_message.raise_error;
287: --
288: end if;
289: --
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rndg_rl);
285: fnd_message.set_token('TYPE_ID',-169);
286: fnd_message.raise_error;
287: --
288: end if;
289: --
290: end if;
292: -- Bug No 4242978
293: -- Unless Rounding Code = Rule, Rounding rule must be blank.
294: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
295: --
296: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
297: fnd_message.raise_error;
298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --
293: -- Unless Rounding Code = Rule, Rounding rule must be blank.
294: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
295: --
296: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
297: fnd_message.raise_error;
298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --
301: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
297: fnd_message.raise_error;
298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --
301: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
302: fnd_message.raise_error;
303: --
304: end if;
305: --
298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --
301: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
302: fnd_message.raise_error;
303: --
304: end if;
305: --
306: hr_utility.set_location('Leaving:'||l_proc,10);
365: p_effective_date => p_effective_date) then
366: --
367: -- raise error
368: --
369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
370: fnd_message.set_token('ID',p_age_calc_rl);
371: fnd_message.set_token('TYPE_ID',-169);
372: fnd_message.raise_error;
373: --
366: --
367: -- raise error
368: --
369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
370: fnd_message.set_token('ID',p_age_calc_rl);
371: fnd_message.set_token('TYPE_ID',-169);
372: fnd_message.raise_error;
373: --
374: end if;
367: -- raise error
368: --
369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
370: fnd_message.set_token('ID',p_age_calc_rl);
371: fnd_message.set_token('TYPE_ID',-169);
372: fnd_message.raise_error;
373: --
374: end if;
375: --
368: --
369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
370: fnd_message.set_token('ID',p_age_calc_rl);
371: fnd_message.set_token('TYPE_ID',-169);
372: fnd_message.raise_error;
373: --
374: end if;
375: --
376: end if;
417: p_age_calc_rl is not null then
418: --
419: -- raise error
420: --
421: fnd_message.set_name('BEN','BEN_92557_CODE_AGE_RULE');
422: fnd_message.raise_error;
423: --
424: end if;
425: --
418: --
419: -- raise error
420: --
421: fnd_message.set_name('BEN','BEN_92557_CODE_AGE_RULE');
422: fnd_message.raise_error;
423: --
424: end if;
425: --
426: hr_utility.set_location('Leaving:'||l_proc,10);
482: p_effective_date => p_effective_date) then
483: --
484: -- raise error as does not exist as lookup
485: --
486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
487: fnd_message.set_token('FIELD', 'p_rndg_cd');
488: fnd_message.set_token('TYPE', 'BEN_RNDG');
489: fnd_message.raise_error;
490: --
483: --
484: -- raise error as does not exist as lookup
485: --
486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
487: fnd_message.set_token('FIELD', 'p_rndg_cd');
488: fnd_message.set_token('TYPE', 'BEN_RNDG');
489: fnd_message.raise_error;
490: --
491: end if;
484: -- raise error as does not exist as lookup
485: --
486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
487: fnd_message.set_token('FIELD', 'p_rndg_cd');
488: fnd_message.set_token('TYPE', 'BEN_RNDG');
489: fnd_message.raise_error;
490: --
491: end if;
492: --
485: --
486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
487: fnd_message.set_token('FIELD', 'p_rndg_cd');
488: fnd_message.set_token('TYPE', 'BEN_RNDG');
489: fnd_message.raise_error;
490: --
491: end if;
492: --
493: end if;
556: p_effective_date => p_effective_date) then
557: --
558: -- raise error
559: --
560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
561: fnd_message.set_token('ID',p_age_det_rl);
562: fnd_message.set_token('TYPE_ID',-145);
563: fnd_message.raise_error;
564: --
557: --
558: -- raise error
559: --
560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
561: fnd_message.set_token('ID',p_age_det_rl);
562: fnd_message.set_token('TYPE_ID',-145);
563: fnd_message.raise_error;
564: --
565: end if;
558: -- raise error
559: --
560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
561: fnd_message.set_token('ID',p_age_det_rl);
562: fnd_message.set_token('TYPE_ID',-145);
563: fnd_message.raise_error;
564: --
565: end if;
566: --
559: --
560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
561: fnd_message.set_token('ID',p_age_det_rl);
562: fnd_message.set_token('TYPE_ID',-145);
563: fnd_message.raise_error;
564: --
565: end if;
566: --
567: end if;
571: --
572: -- Unless AGE determination Code = Rule, AGE determination rule must be blank.
573: if nvl(p_age_det_cd,hr_api.g_varchar2) <> 'RL' and p_age_det_rl is not null then
574: --
575: fnd_message.set_name('BEN', 'BEN_91046_AGE_DET_RL_NOT_NULL');
576: fnd_message.raise_error;
577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --
572: -- Unless AGE determination Code = Rule, AGE determination rule must be blank.
573: if nvl(p_age_det_cd,hr_api.g_varchar2) <> 'RL' and p_age_det_rl is not null then
574: --
575: fnd_message.set_name('BEN', 'BEN_91046_AGE_DET_RL_NOT_NULL');
576: fnd_message.raise_error;
577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --
580: fnd_message.set_name('BEN', 'BEN_91096_AGE_DET_RL_NULL');
576: fnd_message.raise_error;
577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --
580: fnd_message.set_name('BEN', 'BEN_91096_AGE_DET_RL_NULL');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --
580: fnd_message.set_name('BEN', 'BEN_91096_AGE_DET_RL_NULL');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
585: hr_utility.set_location('Leaving:'||l_proc,10);
642: p_effective_date => p_effective_date) then
643: --
644: -- raise error as does not exist as lookup
645: --
646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
647: fnd_message.set_token('FIELD', 'p_age_det_cd');
648: fnd_message.set_token('TYPE', 'AGE_DET');
649: fnd_message.raise_error;
650: --
643: --
644: -- raise error as does not exist as lookup
645: --
646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
647: fnd_message.set_token('FIELD', 'p_age_det_cd');
648: fnd_message.set_token('TYPE', 'AGE_DET');
649: fnd_message.raise_error;
650: --
651: end if;
644: -- raise error as does not exist as lookup
645: --
646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
647: fnd_message.set_token('FIELD', 'p_age_det_cd');
648: fnd_message.set_token('TYPE', 'AGE_DET');
649: fnd_message.raise_error;
650: --
651: end if;
652: --
645: --
646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
647: fnd_message.set_token('FIELD', 'p_age_det_cd');
648: fnd_message.set_token('TYPE', 'AGE_DET');
649: fnd_message.raise_error;
650: --
651: end if;
652: --
653: end if;
712: p_effective_date => p_effective_date) then
713: --
714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');
718: fnd_message.set_token('TYPE', 'YES_NO');
719: fnd_message.raise_error;
720: --
713: --
714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');
718: fnd_message.set_token('TYPE', 'YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;
714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');
718: fnd_message.set_token('TYPE', 'YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;
722: --
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');
718: fnd_message.set_token('TYPE', 'YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;
722: --
723: end if;
782: p_effective_date => p_effective_date) then
783: --
784: -- raise error as does not exist as lookup
785: --
786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');
788: fnd_message.set_token('TYPE', 'YES_NO');
789: fnd_message.raise_error;
790: --
783: --
784: -- raise error as does not exist as lookup
785: --
786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');
788: fnd_message.set_token('TYPE', 'YES_NO');
789: fnd_message.raise_error;
790: --
791: end if;
784: -- raise error as does not exist as lookup
785: --
786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');
788: fnd_message.set_token('TYPE', 'YES_NO');
789: fnd_message.raise_error;
790: --
791: end if;
792: --
785: --
786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');
788: fnd_message.set_token('TYPE', 'YES_NO');
789: fnd_message.raise_error;
790: --
791: end if;
792: --
793: end if;
852: p_effective_date => p_effective_date) then
853: --
854: -- raise error as does not exist as lookup
855: --
856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
857: fnd_message.set_token('FIELD', 'p_age_uom');
858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
859: fnd_message.raise_error;
860: --
853: --
854: -- raise error as does not exist as lookup
855: --
856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
857: fnd_message.set_token('FIELD', 'p_age_uom');
858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
859: fnd_message.raise_error;
860: --
861: end if;
854: -- raise error as does not exist as lookup
855: --
856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
857: fnd_message.set_token('FIELD', 'p_age_uom');
858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
859: fnd_message.raise_error;
860: --
861: end if;
862: --
855: --
856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
857: fnd_message.set_token('FIELD', 'p_age_uom');
858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
859: fnd_message.raise_error;
860: --
861: end if;
862: --
863: end if;
923: --
924: -- if (p_mx_age_num <= p_mn_age_num) then
925: if (p_mx_age_num < p_mn_age_num) then
926: -- end of fix 1873685
927: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
928: fnd_message.raise_error;
929: end if;
930: --
931: --
924: -- if (p_mx_age_num <= p_mn_age_num) then
925: if (p_mx_age_num < p_mn_age_num) then
926: -- end of fix 1873685
927: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
928: fnd_message.raise_error;
929: end if;
930: --
931: --
932: end if;
936: --
937: if nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'Y'
938: and p_mn_age_num is not null
939: then
940: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
941: fnd_message.raise_error;
942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then
937: if nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'Y'
938: and p_mn_age_num is not null
939: then
940: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
941: fnd_message.raise_error;
942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then
945: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
941: fnd_message.raise_error;
942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then
945: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
946: fnd_message.raise_error;
947: end if;
948: --
949: -- If No Maximum age flag set to "on" (Y),
942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then
945: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
946: fnd_message.raise_error;
947: end if;
948: --
949: -- If No Maximum age flag set to "on" (Y),
950: -- then maximum age number must be blank.
951: --
952: if nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'Y'
953: and p_mx_age_num is not null
954: then
955: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
956: fnd_message.raise_error;
957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then
952: if nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'Y'
953: and p_mx_age_num is not null
954: then
955: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
956: fnd_message.raise_error;
957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then
960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
956: fnd_message.raise_error;
957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then
960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
961: fnd_message.raise_error;
962: end if;
963: --
964: hr_utility.set_location('Leaving:'||l_proc,10);
957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then
960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
961: fnd_message.raise_error;
962: end if;
963: --
964: hr_utility.set_location('Leaving:'||l_proc,10);
965: --
1036: close c1;
1037: --
1038: -- raise error
1039: --
1040: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1041: fnd_message.raise_error;
1042: --
1043: end if;
1044: --
1037: --
1038: -- raise error
1039: --
1040: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1041: fnd_message.raise_error;
1042: --
1043: end if;
1044: --
1045: close c1;
1099: close chk_cmbn_age_los_fctr;
1100: --
1101: -- raise error
1102: --
1103: fnd_message.set_name('BEN','BEN_91738_AGE_CHLD_RCD_EXISTS');
1104: fnd_message.raise_error;
1105: --
1106: end if;
1107: --
1100: --
1101: -- raise error
1102: --
1103: fnd_message.set_name('BEN','BEN_91738_AGE_CHLD_RCD_EXISTS');
1104: fnd_message.raise_error;
1105: --
1106: end if;
1107: --
1108: close chk_cmbn_age_los_fctr;*/ --Bug 2978945 used the common function rows_exist