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 396: fnd_message.set_name('BEN','BEN_93550_VAPRO_ELIG_PRFL');

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 ;

Line 397: fnd_message.raise_error;

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

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

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;

Line 451: fnd_message.raise_error;

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

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

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

Line 524: fnd_message.raise_error;

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

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

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;

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

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

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

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

Line 768: fnd_message.raise_error;

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.

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

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;

Line 845: fnd_message.raise_error;

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

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

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;

Line 857: fnd_message.raise_error;

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

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

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;

Line 921: fnd_message.raise_error;

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

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

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;

Line 933: fnd_message.raise_error;

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

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

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;

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

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

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

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

Line 1020: fnd_message.raise_error;

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

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

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

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

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

Line 1118: fnd_message.raise_error;

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

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

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

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

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;

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

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

Line 1127: fnd_message.raise_error;

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