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: --
506: if c_vrbl_rt_flags%found then
507: --
508:
509: close c_vrbl_rt_flags ;
510: fnd_message.set_name('BEN','BEN_93550_VAPRO_ELIG_PRFL');
511: fnd_message.raise_error;
512: --
513: end if;
514: close c_vrbl_rt_flags ;
507: --
508:
509: close c_vrbl_rt_flags ;
510: fnd_message.set_name('BEN','BEN_93550_VAPRO_ELIG_PRFL');
511: fnd_message.raise_error;
512: --
513: end if;
514: close c_vrbl_rt_flags ;
515: --
560: close csr_sec_grp;
561: --
562: -- The primary key is invalid therefore we must error
563: --
564: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
565: fnd_message.raise_error;
566: --
567: end if;
568: close csr_sec_grp;
561: --
562: -- The primary key is invalid therefore we must error
563: --
564: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
565: fnd_message.raise_error;
566: --
567: end if;
568: close csr_sec_grp;
569: --
633: --
634: -- The primary key is invalid therefore we must error
635: --
636: close csr_leg_code;
637: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
638: fnd_message.raise_error;
639: end if;
640: hr_utility.set_location(l_proc,30);
641: --
634: -- The primary key is invalid therefore we must error
635: --
636: close csr_leg_code;
637: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
638: fnd_message.raise_error;
639: end if;
640: hr_utility.set_location(l_proc,30);
641: --
642: -- Set the global variables so the values are
875: (p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id
876: ,p_effective_date => p_effective_date
877: ,p_object_version_number => p_rec.object_version_number
878: ) THEN
879: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE ', l_proc);
881: fnd_message.set_token('STEP ', '5');
882: fnd_message.raise_error;
883: END IF;
876: ,p_effective_date => p_effective_date
877: ,p_object_version_number => p_rec.object_version_number
878: ) THEN
879: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE ', l_proc);
881: fnd_message.set_token('STEP ', '5');
882: fnd_message.raise_error;
883: END IF;
884: --
877: ,p_object_version_number => p_rec.object_version_number
878: ) THEN
879: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE ', l_proc);
881: fnd_message.set_token('STEP ', '5');
882: fnd_message.raise_error;
883: END IF;
884: --
885: -- EDIT_HERE: Add checks to ensure non-updateable args have
878: ) THEN
879: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE ', l_proc);
881: fnd_message.set_token('STEP ', '5');
882: fnd_message.raise_error;
883: END IF;
884: --
885: -- EDIT_HERE: Add checks to ensure non-updateable args have
886: -- not been updated.
954: fetch c1 into l_dummy;
955: --
956: if c1%found then
957: close c1;
958: fnd_message.set_name('BEN','BEN_92258_TTLPRTT_CVGVOL_EXCL1');
959: fnd_message.raise_error;
960: end if;
961: --
962: close c1;
955: --
956: if c1%found then
957: close c1;
958: fnd_message.set_name('BEN','BEN_92258_TTLPRTT_CVGVOL_EXCL1');
959: fnd_message.raise_error;
960: end if;
961: --
962: close c1;
963: --
966: fetch c2 into l_dummy;
967: --
968: if c2%found then
969: close c2;
970: fnd_message.set_name('BEN','BEN_92259_TTLPRTT_CVGVOL_EXCL2');
971: fnd_message.raise_error;
972: end if;
973: --
974: close c2;
967: --
968: if c2%found then
969: close c2;
970: fnd_message.set_name('BEN','BEN_92259_TTLPRTT_CVGVOL_EXCL2');
971: fnd_message.raise_error;
972: end if;
973: --
974: close c2;
975: --
1030: fetch c2 into l_dummy;
1031: if c2%found then
1032: if l_vrbl_usg_cd = 'ACP' and l_mlt_cd <> 'TTLPRTT' then
1033: close c2;
1034: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
1035: fnd_message.raise_error;
1036: end if;
1037: end if;
1038: close c2;
1031: if c2%found then
1032: if l_vrbl_usg_cd = 'ACP' and l_mlt_cd <> 'TTLPRTT' then
1033: close c2;
1034: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
1035: fnd_message.raise_error;
1036: end if;
1037: end if;
1038: close c2;
1039: --
1042: fetch c3 into l_dummy;
1043: if c3%found then
1044: if l_vrbl_usg_cd = 'ACP' and l_mlt_cd <> 'TTLCVG' then
1045: close c3;
1046: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
1047: fnd_message.raise_error;
1048: end if;
1049: end if;
1050: close c3;
1043: if c3%found then
1044: if l_vrbl_usg_cd = 'ACP' and l_mlt_cd <> 'TTLCVG' then
1045: close c3;
1046: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
1047: fnd_message.raise_error;
1048: end if;
1049: end if;
1050: close c3;
1051: --
1127: --
1128: -- An unhandled or unexpected error has occurred which
1129: -- we must report
1130: --
1131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1132: fnd_message.set_token('PROCEDURE', l_proc);
1133: fnd_message.set_token('STEP','15');
1134: fnd_message.raise_error;
1135: End dt_update_validate;
1128: -- An unhandled or unexpected error has occurred which
1129: -- we must report
1130: --
1131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1132: fnd_message.set_token('PROCEDURE', l_proc);
1133: fnd_message.set_token('STEP','15');
1134: fnd_message.raise_error;
1135: End dt_update_validate;
1136: --
1129: -- we must report
1130: --
1131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1132: fnd_message.set_token('PROCEDURE', l_proc);
1133: fnd_message.set_token('STEP','15');
1134: fnd_message.raise_error;
1135: End dt_update_validate;
1136: --
1137: -- ----------------------------------------------------------------------------
1130: --
1131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1132: fnd_message.set_token('PROCEDURE', l_proc);
1133: fnd_message.set_token('STEP','15');
1134: fnd_message.raise_error;
1135: End dt_update_validate;
1136: --
1137: -- ----------------------------------------------------------------------------
1138: -- |--------------------------< dt_delete_validate >--------------------------|
1226: --
1227: -- A referential integrity check was violated therefore
1228: -- we must error
1229: --
1230: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1231: fnd_message.set_token('TABLE_NAME', l_table_name);
1232: fnd_message.raise_error;
1233: When Others Then
1234: --
1227: -- A referential integrity check was violated therefore
1228: -- we must error
1229: --
1230: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1231: fnd_message.set_token('TABLE_NAME', l_table_name);
1232: fnd_message.raise_error;
1233: When Others Then
1234: --
1235: -- An unhandled or unexpected error has occurred which
1228: -- we must error
1229: --
1230: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1231: fnd_message.set_token('TABLE_NAME', l_table_name);
1232: fnd_message.raise_error;
1233: When Others Then
1234: --
1235: -- An unhandled or unexpected error has occurred which
1236: -- we must report
1234: --
1235: -- An unhandled or unexpected error has occurred which
1236: -- we must report
1237: --
1238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1239: fnd_message.set_token('PROCEDURE', l_proc);
1240: fnd_message.set_token('STEP','15');
1241: fnd_message.raise_error;
1242: --
1235: -- An unhandled or unexpected error has occurred which
1236: -- we must report
1237: --
1238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1239: fnd_message.set_token('PROCEDURE', l_proc);
1240: fnd_message.set_token('STEP','15');
1241: fnd_message.raise_error;
1242: --
1243: End dt_delete_validate;
1236: -- we must report
1237: --
1238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1239: fnd_message.set_token('PROCEDURE', l_proc);
1240: fnd_message.set_token('STEP','15');
1241: fnd_message.raise_error;
1242: --
1243: End dt_delete_validate;
1244: --
1237: --
1238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1239: fnd_message.set_token('PROCEDURE', l_proc);
1240: fnd_message.set_token('STEP','15');
1241: fnd_message.raise_error;
1242: --
1243: End dt_delete_validate;
1244: --
1245: -- ----------------------------------------------------------------------------