226: close c1;
227: --
228: -- raise error
229: --
230: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
231: fnd_message.raise_error;
232: --
233: end if;
234: --
227: --
228: -- raise error
229: --
230: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
231: fnd_message.raise_error;
232: --
233: end if;
234: --
235: close c1;
297: p_effective_date => p_effective_date) then
298: --
299: -- raise error as does not exist as lookup
300: --
301: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
302: fnd_message.raise_error;
303: --
304: end if;
305: --
298: --
299: -- raise error as does not exist as lookup
300: --
301: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
302: fnd_message.raise_error;
303: --
304: end if;
305: --
306: end if;
380: close c1;
381: --
382: -- raise error
383: --
384: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
385: fnd_message.raise_error;
386: --
387: end if;
388: --
381: --
382: -- raise error
383: --
384: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
385: fnd_message.raise_error;
386: --
387: end if;
388: --
389: close c1;
451: p_effective_date => p_effective_date) then
452: --
453: -- raise error as does not exist as lookup
454: --
455: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
456: fnd_message.raise_error;
457: --
458: end if;
459: --
452: --
453: -- raise error as does not exist as lookup
454: --
455: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
456: fnd_message.raise_error;
457: --
458: end if;
459: --
460: end if;
521: -- check dependency of Code and Rule.
522: --
523: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) <> 'RL' and
524: p_cvg_strt_rl is not null) then
525: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
526: fnd_message.raise_error;
527: end if;
528:
529: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
522: --
523: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) <> 'RL' and
524: p_cvg_strt_rl is not null) then
525: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
526: fnd_message.raise_error;
527: end if;
528:
529: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
530: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
526: fnd_message.raise_error;
527: end if;
528:
529: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
530: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
531: fnd_message.raise_error;
532: end if;
533: end if;
534:
527: end if;
528:
529: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
530: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
531: fnd_message.raise_error;
532: end if;
533: end if;
534:
535: --
598: -- check dependency of Code and Rule.
599: --
600: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) <> 'RL' and
601: p_cvg_thru_rl is not null) then
602: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
603: fnd_message.raise_error;
604: end if;
605:
606: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
599: --
600: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) <> 'RL' and
601: p_cvg_thru_rl is not null) then
602: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
603: fnd_message.raise_error;
604: end if;
605:
606: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
607: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
603: fnd_message.raise_error;
604: end if;
605:
606: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
607: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
608: fnd_message.raise_error;
609: end if;
610: end if;
611: --
604: end if;
605:
606: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
607: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
608: fnd_message.raise_error;
609: end if;
610: end if;
611: --
612: -- Leaving Procedure.
668: open c1;
669: fetch c1 into dummy;
670: if c1%found then
671: close c1;
672: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
673: fnd_message.raise_error;
674: end if;
675: close c1;
676: --
669: fetch c1 into dummy;
670: if c1%found then
671: close c1;
672: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
673: fnd_message.raise_error;
674: end if;
675: close c1;
676: --
677: hr_utility.set_location('Leaving:'||l_proc, 10);
773: --
774: -- An unhandled or unexpected error has occurred which
775: -- we must report
776: --
777: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
778: fnd_message.set_token('PROCEDURE', l_proc);
779: fnd_message.set_token('STEP','15');
780: fnd_message.raise_error;
781: End dt_update_validate;
774: -- An unhandled or unexpected error has occurred which
775: -- we must report
776: --
777: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
778: fnd_message.set_token('PROCEDURE', l_proc);
779: fnd_message.set_token('STEP','15');
780: fnd_message.raise_error;
781: End dt_update_validate;
782: --
775: -- we must report
776: --
777: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
778: fnd_message.set_token('PROCEDURE', l_proc);
779: fnd_message.set_token('STEP','15');
780: fnd_message.raise_error;
781: End dt_update_validate;
782: --
783: -- ----------------------------------------------------------------------------
776: --
777: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
778: fnd_message.set_token('PROCEDURE', l_proc);
779: fnd_message.set_token('STEP','15');
780: fnd_message.raise_error;
781: End dt_update_validate;
782: --
783: -- ----------------------------------------------------------------------------
784: -- |--------------------------< dt_delete_validate >--------------------------|
876: --
877: -- An unhandled or unexpected error has occurred which
878: -- we must report
879: --
880: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
881: fnd_message.set_token('PROCEDURE', l_proc);
882: fnd_message.set_token('STEP','15');
883: fnd_message.raise_error;
884: End dt_delete_validate;
877: -- An unhandled or unexpected error has occurred which
878: -- we must report
879: --
880: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
881: fnd_message.set_token('PROCEDURE', l_proc);
882: fnd_message.set_token('STEP','15');
883: fnd_message.raise_error;
884: End dt_delete_validate;
885: --
878: -- we must report
879: --
880: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
881: fnd_message.set_token('PROCEDURE', l_proc);
882: fnd_message.set_token('STEP','15');
883: fnd_message.raise_error;
884: End dt_delete_validate;
885: --
886: -- ----------------------------------------------------------------------------
879: --
880: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
881: fnd_message.set_token('PROCEDURE', l_proc);
882: fnd_message.set_token('STEP','15');
883: fnd_message.raise_error;
884: End dt_delete_validate;
885: --
886: -- ----------------------------------------------------------------------------
887: -- |---------------------------< insert_validate >----------------------------|
1117: close csr_leg_code;
1118: --
1119: -- The primary key is invalid therefore we must error
1120: --
1121: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1122: fnd_message.raise_error;
1123: --
1124: end if;
1125: --
1118: --
1119: -- The primary key is invalid therefore we must error
1120: --
1121: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1122: fnd_message.raise_error;
1123: --
1124: end if;
1125: --
1126: close csr_leg_code;