147: close c1;
148: --
149: -- raise error
150: --
151: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
152: fnd_message.raise_error;
153: --
154: end if;
155: --
148: --
149: -- raise error
150: --
151: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
152: fnd_message.raise_error;
153: --
154: end if;
155: --
156: close c1;
218: p_effective_date => p_effective_date) then
219: --
220: -- raise error as does not exist as lookup
221: --
222: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
223: fnd_message.raise_error;
224: --
225: end if;
226: --
219: --
220: -- raise error as does not exist as lookup
221: --
222: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
223: fnd_message.raise_error;
224: --
225: end if;
226: --
227: end if;
301: close c1;
302: --
303: -- raise error
304: --
305: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
306: fnd_message.raise_error;
307: --
308: end if;
309: --
302: --
303: -- raise error
304: --
305: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
306: fnd_message.raise_error;
307: --
308: end if;
309: --
310: close c1;
372: p_effective_date => p_effective_date) then
373: --
374: -- raise error as does not exist as lookup
375: --
376: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
377: fnd_message.raise_error;
378: --
379: end if;
380: --
373: --
374: -- raise error as does not exist as lookup
375: --
376: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
377: fnd_message.raise_error;
378: --
379: end if;
380: --
381: end if;
441: p_effective_date => p_effective_date) then
442: --
443: -- raise error as does not exist as lookup
444: --
445: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
446: fnd_message.raise_error;
447: --
448: end if;
449: --
442: --
443: -- raise error as does not exist as lookup
444: --
445: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
446: fnd_message.raise_error;
447: --
448: end if;
449: --
450: end if;
512: -- check dependency of Code and Rule.
513: --
514: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) <> 'RL' and
515: p_cvg_strt_rl is not null) then
516: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
517: fnd_message.raise_error;
518: end if;
519:
520: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
513: --
514: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) <> 'RL' and
515: p_cvg_strt_rl is not null) then
516: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
517: fnd_message.raise_error;
518: end if;
519:
520: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
521: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
517: fnd_message.raise_error;
518: end if;
519:
520: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
521: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
522: fnd_message.raise_error;
523: end if;
524: end if;
525:
518: end if;
519:
520: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
521: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
522: fnd_message.raise_error;
523: end if;
524: end if;
525:
526: --
589: -- check dependency of Code and Rule.
590: --
591: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) <> 'RL' and
592: p_cvg_thru_rl is not null) then
593: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
594: fnd_message.raise_error;
595: end if;
596:
597: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
590: --
591: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) <> 'RL' and
592: p_cvg_thru_rl is not null) then
593: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
594: fnd_message.raise_error;
595: end if;
596:
597: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
598: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
594: fnd_message.raise_error;
595: end if;
596:
597: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
598: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
599: fnd_message.raise_error;
600: end if;
601: end if;
602: --
595: end if;
596:
597: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
598: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
599: fnd_message.raise_error;
600: end if;
601: end if;
602: --
603: -- Leaving Procedure.
661: open c1;
662: fetch c1 into dummy;
663: if c1%found then
664: close c1;
665: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
666: fnd_message.raise_error;
667: end if;
668: close c1;
669: --
662: fetch c1 into dummy;
663: if c1%found then
664: close c1;
665: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
666: fnd_message.raise_error;
667: end if;
668: close c1;
669: --
670: hr_utility.set_location('Leaving:'||l_proc, 10);
764: --
765: -- An unhandled or unexpected error has occurred which
766: -- we must report
767: --
768: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
769: fnd_message.set_token('PROCEDURE', l_proc);
770: fnd_message.set_token('STEP','15');
771: fnd_message.raise_error;
772: End dt_update_validate;
765: -- An unhandled or unexpected error has occurred which
766: -- we must report
767: --
768: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
769: fnd_message.set_token('PROCEDURE', l_proc);
770: fnd_message.set_token('STEP','15');
771: fnd_message.raise_error;
772: End dt_update_validate;
773: --
766: -- we must report
767: --
768: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
769: fnd_message.set_token('PROCEDURE', l_proc);
770: fnd_message.set_token('STEP','15');
771: fnd_message.raise_error;
772: End dt_update_validate;
773: --
774: -- ----------------------------------------------------------------------------
767: --
768: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
769: fnd_message.set_token('PROCEDURE', l_proc);
770: fnd_message.set_token('STEP','15');
771: fnd_message.raise_error;
772: End dt_update_validate;
773: --
774: -- ----------------------------------------------------------------------------
775: -- |--------------------------< dt_delete_validate >--------------------------|
867: --
868: -- An unhandled or unexpected error has occurred which
869: -- we must report
870: --
871: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
872: fnd_message.set_token('PROCEDURE', l_proc);
873: fnd_message.set_token('STEP','15');
874: fnd_message.raise_error;
875: End dt_delete_validate;
868: -- An unhandled or unexpected error has occurred which
869: -- we must report
870: --
871: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
872: fnd_message.set_token('PROCEDURE', l_proc);
873: fnd_message.set_token('STEP','15');
874: fnd_message.raise_error;
875: End dt_delete_validate;
876: --
869: -- we must report
870: --
871: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
872: fnd_message.set_token('PROCEDURE', l_proc);
873: fnd_message.set_token('STEP','15');
874: fnd_message.raise_error;
875: End dt_delete_validate;
876: --
877: -- ----------------------------------------------------------------------------
870: --
871: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
872: fnd_message.set_token('PROCEDURE', l_proc);
873: fnd_message.set_token('STEP','15');
874: fnd_message.raise_error;
875: End dt_delete_validate;
876: --
877: -- ----------------------------------------------------------------------------
878: -- |---------------------------< insert_validate >----------------------------|
1101: close csr_leg_code;
1102: --
1103: -- The primary key is invalid therefore we must error
1104: --
1105: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1106: fnd_message.raise_error;
1107: --
1108: end if;
1109: --
1102: --
1103: -- The primary key is invalid therefore we must error
1104: --
1105: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1106: fnd_message.raise_error;
1107: --
1108: end if;
1109: --
1110: close csr_leg_code;