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