203: if c_vrbl_rt_elig_prfl%found then
204: --
205: hr_utility.set_location('Only one Profile is allowed ', 8 ) ;
206: close c_vrbl_rt_elig_prfl ;
207: fnd_message.set_name('BEN','BEN_93952_ONLY_ONE_ELPRO');
208: fnd_message.raise_error;
209: --
210: end if;
211: close c_vrbl_rt_elig_prfl ;
204: --
205: hr_utility.set_location('Only one Profile is allowed ', 8 ) ;
206: close c_vrbl_rt_elig_prfl ;
207: fnd_message.set_name('BEN','BEN_93952_ONLY_ONE_ELPRO');
208: fnd_message.raise_error;
209: --
210: end if;
211: close c_vrbl_rt_elig_prfl ;
212: --
268: if c_uniq_vrbl_rt_elig_prfl%found then
269: --
270: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;
271: close c_uniq_vrbl_rt_elig_prfl ;
272: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');
273: fnd_message.raise_error;
274: --
275: end if;
276: close c_uniq_vrbl_rt_elig_prfl ;
269: --
270: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;
271: close c_uniq_vrbl_rt_elig_prfl ;
272: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');
273: fnd_message.raise_error;
274: --
275: end if;
276: close c_uniq_vrbl_rt_elig_prfl ;
277: --
392: if c_vrbl_rt_flags%found then
393: --
394:
395: close c_vrbl_rt_flags ;
396: fnd_message.set_name('BEN','BEN_93550_VAPRO_ELIG_PRFL');
397: fnd_message.raise_error;
398: --
399: end if;
400: close c_vrbl_rt_flags ;
393: --
394:
395: close c_vrbl_rt_flags ;
396: fnd_message.set_name('BEN','BEN_93550_VAPRO_ELIG_PRFL');
397: fnd_message.raise_error;
398: --
399: end if;
400: close c_vrbl_rt_flags ;
401: --
446: close csr_sec_grp;
447: --
448: -- The primary key is invalid therefore we must error
449: --
450: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
451: fnd_message.raise_error;
452: --
453: end if;
454: close csr_sec_grp;
447: --
448: -- The primary key is invalid therefore we must error
449: --
450: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
451: fnd_message.raise_error;
452: --
453: end if;
454: close csr_sec_grp;
455: --
519: --
520: -- The primary key is invalid therefore we must error
521: --
522: close csr_leg_code;
523: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
524: fnd_message.raise_error;
525: end if;
526: hr_utility.set_location(l_proc,30);
527: --
520: -- The primary key is invalid therefore we must error
521: --
522: close csr_leg_code;
523: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
524: fnd_message.raise_error;
525: end if;
526: hr_utility.set_location(l_proc,30);
527: --
528: -- Set the global variables so the values are
761: (p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id
762: ,p_effective_date => p_effective_date
763: ,p_object_version_number => p_rec.object_version_number
764: ) THEN
765: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
766: fnd_message.set_token('PROCEDURE ', l_proc);
767: fnd_message.set_token('STEP ', '5');
768: fnd_message.raise_error;
769: END IF;
762: ,p_effective_date => p_effective_date
763: ,p_object_version_number => p_rec.object_version_number
764: ) THEN
765: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
766: fnd_message.set_token('PROCEDURE ', l_proc);
767: fnd_message.set_token('STEP ', '5');
768: fnd_message.raise_error;
769: END IF;
770: --
763: ,p_object_version_number => p_rec.object_version_number
764: ) THEN
765: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
766: fnd_message.set_token('PROCEDURE ', l_proc);
767: fnd_message.set_token('STEP ', '5');
768: fnd_message.raise_error;
769: END IF;
770: --
771: -- EDIT_HERE: Add checks to ensure non-updateable args have
764: ) THEN
765: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
766: fnd_message.set_token('PROCEDURE ', l_proc);
767: fnd_message.set_token('STEP ', '5');
768: fnd_message.raise_error;
769: END IF;
770: --
771: -- EDIT_HERE: Add checks to ensure non-updateable args have
772: -- not been updated.
840: fetch c1 into l_dummy;
841: --
842: if c1%found then
843: close c1;
844: fnd_message.set_name('BEN','BEN_92258_TTLPRTT_CVGVOL_EXCL1');
845: fnd_message.raise_error;
846: end if;
847: --
848: close c1;
841: --
842: if c1%found then
843: close c1;
844: fnd_message.set_name('BEN','BEN_92258_TTLPRTT_CVGVOL_EXCL1');
845: fnd_message.raise_error;
846: end if;
847: --
848: close c1;
849: --
852: fetch c2 into l_dummy;
853: --
854: if c2%found then
855: close c2;
856: fnd_message.set_name('BEN','BEN_92259_TTLPRTT_CVGVOL_EXCL2');
857: fnd_message.raise_error;
858: end if;
859: --
860: close c2;
853: --
854: if c2%found then
855: close c2;
856: fnd_message.set_name('BEN','BEN_92259_TTLPRTT_CVGVOL_EXCL2');
857: fnd_message.raise_error;
858: end if;
859: --
860: close c2;
861: --
916: fetch c2 into l_dummy;
917: if c2%found then
918: if l_vrbl_usg_cd = 'ACP' and l_mlt_cd <> 'TTLPRTT' then
919: close c2;
920: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
921: fnd_message.raise_error;
922: end if;
923: end if;
924: close c2;
917: if c2%found then
918: if l_vrbl_usg_cd = 'ACP' and l_mlt_cd <> 'TTLPRTT' then
919: close c2;
920: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
921: fnd_message.raise_error;
922: end if;
923: end if;
924: close c2;
925: --
928: fetch c3 into l_dummy;
929: if c3%found then
930: if l_vrbl_usg_cd = 'ACP' and l_mlt_cd <> 'TTLCVG' then
931: close c3;
932: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
933: fnd_message.raise_error;
934: end if;
935: end if;
936: close c3;
929: if c3%found then
930: if l_vrbl_usg_cd = 'ACP' and l_mlt_cd <> 'TTLCVG' then
931: close c3;
932: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
933: fnd_message.raise_error;
934: end if;
935: end if;
936: close c3;
937: --
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: End dt_update_validate;
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: End dt_update_validate;
1022: --
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: End dt_update_validate;
1022: --
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: End dt_update_validate;
1022: --
1023: -- ----------------------------------------------------------------------------
1024: -- |--------------------------< dt_delete_validate >--------------------------|
1112: --
1113: -- A referential integrity check was violated therefore
1114: -- we must error
1115: --
1116: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1117: fnd_message.set_token('TABLE_NAME', l_table_name);
1118: fnd_message.raise_error;
1119: When Others Then
1120: --
1113: -- A referential integrity check was violated therefore
1114: -- we must error
1115: --
1116: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1117: fnd_message.set_token('TABLE_NAME', l_table_name);
1118: fnd_message.raise_error;
1119: When Others Then
1120: --
1121: -- An unhandled or unexpected error has occurred which
1114: -- we must error
1115: --
1116: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1117: fnd_message.set_token('TABLE_NAME', l_table_name);
1118: fnd_message.raise_error;
1119: When Others Then
1120: --
1121: -- An unhandled or unexpected error has occurred which
1122: -- we must report
1120: --
1121: -- An unhandled or unexpected error has occurred which
1122: -- we must report
1123: --
1124: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1125: fnd_message.set_token('PROCEDURE', l_proc);
1126: fnd_message.set_token('STEP','15');
1127: fnd_message.raise_error;
1128: --
1121: -- An unhandled or unexpected error has occurred which
1122: -- we must report
1123: --
1124: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1125: fnd_message.set_token('PROCEDURE', l_proc);
1126: fnd_message.set_token('STEP','15');
1127: fnd_message.raise_error;
1128: --
1129: End dt_delete_validate;
1122: -- we must report
1123: --
1124: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1125: fnd_message.set_token('PROCEDURE', l_proc);
1126: fnd_message.set_token('STEP','15');
1127: fnd_message.raise_error;
1128: --
1129: End dt_delete_validate;
1130: --
1123: --
1124: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1125: fnd_message.set_token('PROCEDURE', l_proc);
1126: fnd_message.set_token('STEP','15');
1127: fnd_message.raise_error;
1128: --
1129: End dt_delete_validate;
1130: --
1131: -- ----------------------------------------------------------------------------