181: close c3;
182: --
183: -- raise error as this job already exists for this profile
184: --
185: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
186: fnd_message.set_token('VAR1','Job criteria');
187: fnd_message.set_token('VAR2','Variable Rate Profile');
188: fnd_message.raise_error;
189: --
182: --
183: -- raise error as this job already exists for this profile
184: --
185: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
186: fnd_message.set_token('VAR1','Job criteria');
187: fnd_message.set_token('VAR2','Variable Rate Profile');
188: fnd_message.raise_error;
189: --
190: end if;
183: -- raise error as this job already exists for this profile
184: --
185: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
186: fnd_message.set_token('VAR1','Job criteria');
187: fnd_message.set_token('VAR2','Variable Rate Profile');
188: fnd_message.raise_error;
189: --
190: end if;
191: close c3;
184: --
185: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
186: fnd_message.set_token('VAR1','Job criteria');
187: fnd_message.set_token('VAR2','Variable Rate Profile');
188: fnd_message.raise_error;
189: --
190: end if;
191: close c3;
192: --
254: p_effective_date => p_effective_date) then
255: --
256: -- raise error as does not exist as lookup
257: --
258: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
259: fnd_message.raise_error;
260: --
261: end if;
262: --
255: --
256: -- raise error as does not exist as lookup
257: --
258: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
259: fnd_message.raise_error;
260: --
261: end if;
262: --
263: end if;
309: close csr_sec_grp;
310: --
311: -- The primary key is invalid therefore we must error
312: --
313: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
314: hr_multi_message.add
315: (p_associated_column1
316: => nvl(p_associated_column1,'JOB_RT_ID')
317: );
386: --
387: -- The primary key is invalid therefore we must error
388: --
389: close csr_leg_code;
390: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
391: fnd_message.raise_error;
392: end if;
393: hr_utility.set_location(l_proc,30);
394: --
387: -- The primary key is invalid therefore we must error
388: --
389: close csr_leg_code;
390: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
391: fnd_message.raise_error;
392: end if;
393: hr_utility.set_location(l_proc,30);
394: --
395: -- Set the global variables so the values are
623: (p_job_rt_id => p_rec.job_rt_id
624: ,p_effective_date => p_effective_date
625: ,p_object_version_number => p_rec.object_version_number
626: ) THEN
627: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
628: fnd_message.set_token('PROCEDURE ', l_proc);
629: fnd_message.set_token('STEP ', '5');
630: fnd_message.raise_error;
631: END IF;
624: ,p_effective_date => p_effective_date
625: ,p_object_version_number => p_rec.object_version_number
626: ) THEN
627: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
628: fnd_message.set_token('PROCEDURE ', l_proc);
629: fnd_message.set_token('STEP ', '5');
630: fnd_message.raise_error;
631: END IF;
632: --
625: ,p_object_version_number => p_rec.object_version_number
626: ) THEN
627: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
628: fnd_message.set_token('PROCEDURE ', l_proc);
629: fnd_message.set_token('STEP ', '5');
630: fnd_message.raise_error;
631: END IF;
632: --
633: -- EDIT_HERE: Add checks to ensure non-updateable args have
626: ) THEN
627: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
628: fnd_message.set_token('PROCEDURE ', l_proc);
629: fnd_message.set_token('STEP ', '5');
630: fnd_message.raise_error;
631: END IF;
632: --
633: -- EDIT_HERE: Add checks to ensure non-updateable args have
634: -- not been updated.
693: open c1;
694: fetch c1 into l_dummy;
695: --
696: if c1%found then
697: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
698: fnd_message.raise_error;
699: end if;
700: close c1;
701: --
694: fetch c1 into l_dummy;
695: --
696: if c1%found then
697: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
698: fnd_message.raise_error;
699: end if;
700: close c1;
701: --
702: hr_utility.set_location('Leaving:'||l_proc, 15);
774: ,p_base_key_column => 'VRBL_RT_PRFL_ID'
775: ,p_base_key_value => p_vrbl_rt_prfl_id
776: ,p_from_date => p_validation_start_date
777: ,p_to_date => p_validation_end_date))) Then
778: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
779: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
780: hr_multi_message.add
781: (p_associated_column1 => ben_jrt_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
782: End If;
775: ,p_base_key_value => p_vrbl_rt_prfl_id
776: ,p_from_date => p_validation_start_date
777: ,p_to_date => p_validation_end_date))) Then
778: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
779: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
780: hr_multi_message.add
781: (p_associated_column1 => ben_jrt_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
782: End If;
783: --
786: --
787: -- An unhandled or unexpected error has occurred which
788: -- we must report
789: --
790: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
791: fnd_message.set_token('PROCEDURE', l_proc);
792: fnd_message.set_token('STEP','15');
793: fnd_message.raise_error;
794: End dt_update_validate;
787: -- An unhandled or unexpected error has occurred which
788: -- we must report
789: --
790: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
791: fnd_message.set_token('PROCEDURE', l_proc);
792: fnd_message.set_token('STEP','15');
793: fnd_message.raise_error;
794: End dt_update_validate;
795: --
788: -- we must report
789: --
790: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
791: fnd_message.set_token('PROCEDURE', l_proc);
792: fnd_message.set_token('STEP','15');
793: fnd_message.raise_error;
794: End dt_update_validate;
795: --
796: -- ----------------------------------------------------------------------------
789: --
790: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
791: fnd_message.set_token('PROCEDURE', l_proc);
792: fnd_message.set_token('STEP','15');
793: fnd_message.raise_error;
794: End dt_update_validate;
795: --
796: -- ----------------------------------------------------------------------------
797: -- |--------------------------< dt_delete_validate >--------------------------|
883: --
884: -- An unhandled or unexpected error has occurred which
885: -- we must report
886: --
887: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
888: fnd_message.set_token('PROCEDURE', l_proc);
889: fnd_message.set_token('STEP','15');
890: fnd_message.raise_error;
891: --
884: -- An unhandled or unexpected error has occurred which
885: -- we must report
886: --
887: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
888: fnd_message.set_token('PROCEDURE', l_proc);
889: fnd_message.set_token('STEP','15');
890: fnd_message.raise_error;
891: --
892: End dt_delete_validate;
885: -- we must report
886: --
887: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
888: fnd_message.set_token('PROCEDURE', l_proc);
889: fnd_message.set_token('STEP','15');
890: fnd_message.raise_error;
891: --
892: End dt_delete_validate;
893: --
886: --
887: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
888: fnd_message.set_token('PROCEDURE', l_proc);
889: fnd_message.set_token('STEP','15');
890: fnd_message.raise_error;
891: --
892: End dt_delete_validate;
893: --
894: -- ----------------------------------------------------------------------------