DBA Data[Home] [Help]

APPS.BEN_VEP_BUS dependencies on FND_MESSAGE

Line 207: fnd_message.set_name('BEN','BEN_93952_ONLY_ONE_ELPRO');

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 ;

Line 208: fnd_message.raise_error;

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: --

Line 272: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');

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 ;

Line 273: fnd_message.raise_error;

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: --

Line 510: fnd_message.set_name('BEN','BEN_93550_VAPRO_ELIG_PRFL');

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 ;

Line 511: fnd_message.raise_error;

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: --

Line 564: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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;

Line 565: fnd_message.raise_error;

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: --

Line 637: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 638: fnd_message.raise_error;

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

Line 879: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 880: fnd_message.set_token('PROCEDURE ', l_proc);

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: --

Line 881: fnd_message.set_token('STEP ', '5');

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

Line 882: fnd_message.raise_error;

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.

Line 958: fnd_message.set_name('BEN','BEN_92258_TTLPRTT_CVGVOL_EXCL1');

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;

Line 959: fnd_message.raise_error;

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: --

Line 970: fnd_message.set_name('BEN','BEN_92259_TTLPRTT_CVGVOL_EXCL2');

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;

Line 971: fnd_message.raise_error;

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: --

Line 1034: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');

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;

Line 1035: fnd_message.raise_error;

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: --

Line 1046: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');

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;

Line 1047: fnd_message.raise_error;

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: --

Line 1131: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 1132: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 1133: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 1134: fnd_message.raise_error;

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 >--------------------------|

Line 1230: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

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: --

Line 1231: fnd_message.set_token('TABLE_NAME', l_table_name);

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

Line 1232: fnd_message.raise_error;

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

Line 1238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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: --

Line 1239: fnd_message.set_token('PROCEDURE', l_proc);

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;

Line 1240: fnd_message.set_token('STEP','15');

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: --

Line 1241: fnd_message.raise_error;

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: -- ----------------------------------------------------------------------------