134: p_effective_date => p_effective_date) then
135: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
139: fnd_message.set_token('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
135: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
139: fnd_message.set_token('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
139: fnd_message.set_token('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: --
144: end if;
137: --
138: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
139: fnd_message.set_token('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: --
144: end if;
145: --
377: close c1;
378: --
379: -- raise error as this pl already exists for this profile
380: --
381: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
382: fnd_message.raise_error;
383: --
384: end if;
385: close c1;
378: --
379: -- raise error as this pl already exists for this profile
380: --
381: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
382: fnd_message.raise_error;
383: --
384: end if;
385: close c1;
386: --
480: --
481: -- An unhandled or unexpected error has occurred which
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
481: -- An unhandled or unexpected error has occurred which
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
490: -- ----------------------------------------------------------------------------
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
490: -- ----------------------------------------------------------------------------
491: -- |--------------------------< dt_delete_validate >--------------------------|
576: --
577: -- A referential integrity check was violated therefore
578: -- we must error
579: --
580: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
581: fnd_message.set_token('TABLE_NAME', l_table_name);
582: fnd_message.raise_error;
583: When Others Then
584: --
577: -- A referential integrity check was violated therefore
578: -- we must error
579: --
580: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
581: fnd_message.set_token('TABLE_NAME', l_table_name);
582: fnd_message.raise_error;
583: When Others Then
584: --
585: -- An unhandled or unexpected error has occurred which
578: -- we must error
579: --
580: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
581: fnd_message.set_token('TABLE_NAME', l_table_name);
582: fnd_message.raise_error;
583: When Others Then
584: --
585: -- An unhandled or unexpected error has occurred which
586: -- we must report
584: --
585: -- An unhandled or unexpected error has occurred which
586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_delete_validate;
585: -- An unhandled or unexpected error has occurred which
586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_delete_validate;
593: --
586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_delete_validate;
593: --
594: -- ----------------------------------------------------------------------------
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_delete_validate;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |---------------------------< insert_validate >----------------------------|
781: close csr_leg_code;
782: --
783: -- The primary key is invalid therefore we must error
784: --
785: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
786: fnd_message.raise_error;
787: --
788: end if;
789: --
782: --
783: -- The primary key is invalid therefore we must error
784: --
785: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
786: fnd_message.raise_error;
787: --
788: end if;
789: --
790: close csr_leg_code;