133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
142: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
142: --
143: end if;
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
142: --
143: end if;
144: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
142: --
143: end if;
144: --
145: end if;
219: close c1;
220: --
221: -- raise error
222: --
223: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
224: fnd_message.raise_error;
225: --
226: end if;
227: --
220: --
221: -- raise error
222: --
223: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
224: fnd_message.raise_error;
225: --
226: end if;
227: --
228: close c1;
290: p_effective_date => p_effective_date) then
291: --
292: -- raise error as does not exist as lookup
293: --
294: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
295: fnd_message.raise_error;
296: --
297: end if;
298: --
291: --
292: -- raise error as does not exist as lookup
293: --
294: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
295: fnd_message.raise_error;
296: --
297: end if;
298: --
299: end if;
359: p_effective_date => p_effective_date) then
360: --
361: -- raise error as does not exist as lookup
362: --
363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
360: --
361: -- raise error as does not exist as lookup
362: --
363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
368: end if;
428: p_effective_date => p_effective_date) then
429: --
430: -- raise error as does not exist as lookup
431: --
432: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
433: fnd_message.raise_error;
434: --
435: end if;
436: --
429: --
430: -- raise error as does not exist as lookup
431: --
432: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
433: fnd_message.raise_error;
434: --
435: end if;
436: --
437: end if;
497: p_effective_date => p_effective_date) then
498: --
499: -- raise error as does not exist as lookup
500: --
501: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
502: fnd_message.raise_error;
503: --
504: end if;
505: --
498: --
499: -- raise error as does not exist as lookup
500: --
501: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
502: fnd_message.raise_error;
503: --
504: end if;
505: --
506: end if;
562: -- raise error if max value not greater than min value
563: --
564: if p_mx_poe_num <= p_mn_poe_num then
565: --
566: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
567: fnd_message.raise_error;
568: --
569: end if;
570: --
563: --
564: if p_mx_poe_num <= p_mn_poe_num then
565: --
566: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
567: fnd_message.raise_error;
568: --
569: end if;
570: --
571: end if;
575: --
576: if p_no_mn_poe_flag = 'Y' and
577: p_mn_poe_num is not null then
578: --
579: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
580: fnd_message.raise_error;
581: --
582: elsif p_no_mn_poe_flag = 'N' and
583: p_mn_poe_num is null then
576: if p_no_mn_poe_flag = 'Y' and
577: p_mn_poe_num is not null then
578: --
579: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
580: fnd_message.raise_error;
581: --
582: elsif p_no_mn_poe_flag = 'N' and
583: p_mn_poe_num is null then
584: --
581: --
582: elsif p_no_mn_poe_flag = 'N' and
583: p_mn_poe_num is null then
584: --
585: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
586: fnd_message.raise_error;
587: --
588: end if;
589: --
582: elsif p_no_mn_poe_flag = 'N' and
583: p_mn_poe_num is null then
584: --
585: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
586: fnd_message.raise_error;
587: --
588: end if;
589: --
590: -- If No Maximum poe flag set to "on" (Y),
592: --
593: if p_no_mx_poe_flag = 'Y' and
594: p_mx_poe_num is not null then
595: --
596: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
597: fnd_message.raise_error;
598: --
599: elsif p_no_mx_poe_flag = 'N' and
600: p_mx_poe_num is null then
593: if p_no_mx_poe_flag = 'Y' and
594: p_mx_poe_num is not null then
595: --
596: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
597: fnd_message.raise_error;
598: --
599: elsif p_no_mx_poe_flag = 'N' and
600: p_mx_poe_num is null then
601: --
598: --
599: elsif p_no_mx_poe_flag = 'N' and
600: p_mx_poe_num is null then
601: --
602: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
603: fnd_message.raise_error;
604: --
605: end if;
606: --
599: elsif p_no_mx_poe_flag = 'N' and
600: p_mx_poe_num is null then
601: --
602: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
603: fnd_message.raise_error;
604: --
605: end if;
606: --
607: hr_utility.set_location('Leaving:'||l_proc,10);
699: --
700: -- An unhandled or unexpected error has occurred which
701: -- we must report
702: --
703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
704: fnd_message.set_token('PROCEDURE', l_proc);
705: fnd_message.set_token('STEP','15');
706: fnd_message.raise_error;
707: End dt_update_validate;
700: -- An unhandled or unexpected error has occurred which
701: -- we must report
702: --
703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
704: fnd_message.set_token('PROCEDURE', l_proc);
705: fnd_message.set_token('STEP','15');
706: fnd_message.raise_error;
707: End dt_update_validate;
708: --
701: -- we must report
702: --
703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
704: fnd_message.set_token('PROCEDURE', l_proc);
705: fnd_message.set_token('STEP','15');
706: fnd_message.raise_error;
707: End dt_update_validate;
708: --
709: -- ----------------------------------------------------------------------------
702: --
703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
704: fnd_message.set_token('PROCEDURE', l_proc);
705: fnd_message.set_token('STEP','15');
706: fnd_message.raise_error;
707: End dt_update_validate;
708: --
709: -- ----------------------------------------------------------------------------
710: -- |--------------------------< dt_delete_validate >--------------------------|
795: --
796: -- A referential integrity check was violated therefore
797: -- we must error
798: --
799: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
800: fnd_message.set_token('TABLE_NAME', l_table_name);
801: fnd_message.raise_error;
802: When Others Then
803: --
796: -- A referential integrity check was violated therefore
797: -- we must error
798: --
799: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
800: fnd_message.set_token('TABLE_NAME', l_table_name);
801: fnd_message.raise_error;
802: When Others Then
803: --
804: -- An unhandled or unexpected error has occurred which
797: -- we must error
798: --
799: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
800: fnd_message.set_token('TABLE_NAME', l_table_name);
801: fnd_message.raise_error;
802: When Others Then
803: --
804: -- An unhandled or unexpected error has occurred which
805: -- we must report
803: --
804: -- An unhandled or unexpected error has occurred which
805: -- we must report
806: --
807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
808: fnd_message.set_token('PROCEDURE', l_proc);
809: fnd_message.set_token('STEP','15');
810: fnd_message.raise_error;
811: End dt_delete_validate;
804: -- An unhandled or unexpected error has occurred which
805: -- we must report
806: --
807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
808: fnd_message.set_token('PROCEDURE', l_proc);
809: fnd_message.set_token('STEP','15');
810: fnd_message.raise_error;
811: End dt_delete_validate;
812: --
805: -- we must report
806: --
807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
808: fnd_message.set_token('PROCEDURE', l_proc);
809: fnd_message.set_token('STEP','15');
810: fnd_message.raise_error;
811: End dt_delete_validate;
812: --
813: -- ----------------------------------------------------------------------------
806: --
807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
808: fnd_message.set_token('PROCEDURE', l_proc);
809: fnd_message.set_token('STEP','15');
810: fnd_message.raise_error;
811: End dt_delete_validate;
812: --
813: -- ----------------------------------------------------------------------------
814: -- |---------------------------< insert_validate >----------------------------|
1027: close csr_leg_code;
1028: --
1029: -- The primary key is invalid therefore we must error
1030: --
1031: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1032: fnd_message.raise_error;
1033: --
1034: end if;
1035: --
1028: --
1029: -- The primary key is invalid therefore we must error
1030: --
1031: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1032: fnd_message.raise_error;
1033: --
1034: end if;
1035: --
1036: close csr_leg_code;