184: close c3;
185: --
186: -- raise error as this job already exists for this profile
187: --
188: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
189: fnd_message.set_token('VAR1','Competency criteria');
190: fnd_message.set_token('VAR2','Variable Rate Profile');
191: fnd_message.raise_error;
192: --
185: --
186: -- raise error as this job already exists for this profile
187: --
188: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
189: fnd_message.set_token('VAR1','Competency criteria');
190: fnd_message.set_token('VAR2','Variable Rate Profile');
191: fnd_message.raise_error;
192: --
193: end if;
186: -- raise error as this job already exists for this profile
187: --
188: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
189: fnd_message.set_token('VAR1','Competency criteria');
190: fnd_message.set_token('VAR2','Variable Rate Profile');
191: fnd_message.raise_error;
192: --
193: end if;
194: close c3;
187: --
188: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
189: fnd_message.set_token('VAR1','Competency criteria');
190: fnd_message.set_token('VAR2','Variable Rate Profile');
191: fnd_message.raise_error;
192: --
193: end if;
194: close c3;
195: --
310: close c3;
311: --
312: -- raise error as this competnecy already exists for this profile
313: --
314: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
315: fnd_message.set_token('VAR1','Competency criteria');
316: fnd_message.set_token('VAR2','Variable Rate Profile');
317: fnd_message.raise_error;
318: --
311: --
312: -- raise error as this competnecy already exists for this profile
313: --
314: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
315: fnd_message.set_token('VAR1','Competency criteria');
316: fnd_message.set_token('VAR2','Variable Rate Profile');
317: fnd_message.raise_error;
318: --
319: end if;
312: -- raise error as this competnecy already exists for this profile
313: --
314: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
315: fnd_message.set_token('VAR1','Competency criteria');
316: fnd_message.set_token('VAR2','Variable Rate Profile');
317: fnd_message.raise_error;
318: --
319: end if;
320: close c3;
313: --
314: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
315: fnd_message.set_token('VAR1','Competency criteria');
316: fnd_message.set_token('VAR2','Variable Rate Profile');
317: fnd_message.raise_error;
318: --
319: end if;
320: close c3;
321: --
385: p_effective_date => p_effective_date) then
386: --
387: -- raise error as does not exist as lookup
388: --
389: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
390: fnd_message.raise_error;
391: --
392: end if;
393: --
386: --
387: -- raise error as does not exist as lookup
388: --
389: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
390: fnd_message.raise_error;
391: --
392: end if;
393: --
394: end if;
455: open c1;
456: fetch c1 into l_dummy;
457: --
458: if c1%found then
459: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
460: fnd_message.raise_error;
461: end if;
462: close c1;
463: --
456: fetch c1 into l_dummy;
457: --
458: if c1%found then
459: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
460: fnd_message.raise_error;
461: end if;
462: close c1;
463: --
464: hr_utility.set_location('Leaving:'||l_proc, 15);
508: close csr_sec_grp;
509: --
510: -- The primary key is invalid therefore we must error
511: --
512: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
513: hr_multi_message.add
514: (p_associated_column1
515: => nvl(p_associated_column1,'comptncy_rt_ID')
516: );
585: --
586: -- The primary key is invalid therefore we must error
587: --
588: close csr_leg_code;
589: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
590: fnd_message.raise_error;
591: end if;
592: hr_utility.set_location(l_proc,30);
593: --
586: -- The primary key is invalid therefore we must error
587: --
588: close csr_leg_code;
589: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
590: fnd_message.raise_error;
591: end if;
592: hr_utility.set_location(l_proc,30);
593: --
594: -- Set the global variables so the values are
822: (p_comptncy_rt_id => p_rec.comptncy_rt_id
823: ,p_effective_date => p_effective_date
824: ,p_object_version_number => p_rec.object_version_number
825: ) THEN
826: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE ', l_proc);
828: fnd_message.set_token('STEP ', '5');
829: fnd_message.raise_error;
830: END IF;
823: ,p_effective_date => p_effective_date
824: ,p_object_version_number => p_rec.object_version_number
825: ) THEN
826: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE ', l_proc);
828: fnd_message.set_token('STEP ', '5');
829: fnd_message.raise_error;
830: END IF;
831: --
824: ,p_object_version_number => p_rec.object_version_number
825: ) THEN
826: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE ', l_proc);
828: fnd_message.set_token('STEP ', '5');
829: fnd_message.raise_error;
830: END IF;
831: --
832: -- EDIT_HERE: Add checks to ensure non-updateable args have
825: ) THEN
826: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE ', l_proc);
828: fnd_message.set_token('STEP ', '5');
829: fnd_message.raise_error;
830: END IF;
831: --
832: -- EDIT_HERE: Add checks to ensure non-updateable args have
833: -- not been updated.
904: ,p_base_key_column => 'VRBL_RT_PRFL_ID'
905: ,p_base_key_value => p_vrbl_rt_prfl_id
906: ,p_from_date => p_validation_start_date
907: ,p_to_date => p_validation_end_date))) Then
908: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
909: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
910: hr_multi_message.add
911: (p_associated_column1 => ben_cty_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
912: End If;
905: ,p_base_key_value => p_vrbl_rt_prfl_id
906: ,p_from_date => p_validation_start_date
907: ,p_to_date => p_validation_end_date))) Then
908: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
909: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
910: hr_multi_message.add
911: (p_associated_column1 => ben_cty_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
912: End If;
913: --
916: --
917: -- An unhandled or unexpected error has occurred which
918: -- we must report
919: --
920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
921: fnd_message.set_token('PROCEDURE', l_proc);
922: fnd_message.set_token('STEP','15');
923: fnd_message.raise_error;
924: End dt_update_validate;
917: -- An unhandled or unexpected error has occurred which
918: -- we must report
919: --
920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
921: fnd_message.set_token('PROCEDURE', l_proc);
922: fnd_message.set_token('STEP','15');
923: fnd_message.raise_error;
924: End dt_update_validate;
925: --
918: -- we must report
919: --
920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
921: fnd_message.set_token('PROCEDURE', l_proc);
922: fnd_message.set_token('STEP','15');
923: fnd_message.raise_error;
924: End dt_update_validate;
925: --
926: -- ----------------------------------------------------------------------------
919: --
920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
921: fnd_message.set_token('PROCEDURE', l_proc);
922: fnd_message.set_token('STEP','15');
923: fnd_message.raise_error;
924: End dt_update_validate;
925: --
926: -- ----------------------------------------------------------------------------
927: -- |--------------------------< dt_delete_validate >--------------------------|
1013: --
1014: -- An unhandled or unexpected error has occurred which
1015: -- we must report
1016: --
1017: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1018: fnd_message.set_token('PROCEDURE', l_proc);
1019: fnd_message.set_token('STEP','15');
1020: fnd_message.raise_error;
1021: --
1014: -- An unhandled or unexpected error has occurred which
1015: -- we must report
1016: --
1017: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1018: fnd_message.set_token('PROCEDURE', l_proc);
1019: fnd_message.set_token('STEP','15');
1020: fnd_message.raise_error;
1021: --
1022: End dt_delete_validate;
1015: -- we must report
1016: --
1017: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1018: fnd_message.set_token('PROCEDURE', l_proc);
1019: fnd_message.set_token('STEP','15');
1020: fnd_message.raise_error;
1021: --
1022: End dt_delete_validate;
1023: --
1016: --
1017: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1018: fnd_message.set_token('PROCEDURE', l_proc);
1019: fnd_message.set_token('STEP','15');
1020: fnd_message.raise_error;
1021: --
1022: End dt_delete_validate;
1023: --
1024: -- ----------------------------------------------------------------------------