133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;
202: p_effective_date => p_effective_date) then
203: --
204: -- raise error as does not exist as lookup
205: --
206: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
207: fnd_message.raise_error;
208: --
209: end if;
210: --
203: --
204: -- raise error as does not exist as lookup
205: --
206: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
207: fnd_message.raise_error;
208: --
209: end if;
210: --
211: end if;
271: p_effective_date => p_effective_date) then
272: --
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
276: fnd_message.raise_error;
277: --
278: end if;
279: --
272: --
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
276: fnd_message.raise_error;
277: --
278: end if;
279: --
280: end if;
366: --
367: -- Raise error : as there is plan associated with the plan type being updated - which
368: -- is also associated to iRecruitment Reporting Group
369: --
370: fnd_message.set_name('BEN','BEN_93922_PTP_PL_RPTG_GRP_IREC');
371: fnd_message.raise_error;
372: --
373: end if;
374: --
367: -- Raise error : as there is plan associated with the plan type being updated - which
368: -- is also associated to iRecruitment Reporting Group
369: --
370: fnd_message.set_name('BEN','BEN_93922_PTP_PL_RPTG_GRP_IREC');
371: fnd_message.raise_error;
372: --
373: end if;
374: --
375: close c1;
440: p_effective_date => p_effective_date) then
441: --
442: -- raise error as does not exist as lookup
443: --
444: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
445: fnd_message.raise_error;
446: --
447: end if;
448:
441: --
442: -- raise error as does not exist as lookup
443: --
444: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
445: fnd_message.raise_error;
446: --
447: end if;
448:
449: --iRec
460: then
461: --
462: -- Raise error as Self Service Display code does not match Option Type code
463: --
464: fnd_message.set_name('BEN','BEN_93923_OPTYP_SSDISP_INVALID');
465: fnd_message.raise_error;
466: --
467: end if;
468: */
461: --
462: -- Raise error as Self Service Display code does not match Option Type code
463: --
464: fnd_message.set_name('BEN','BEN_93923_OPTYP_SSDISP_INVALID');
465: fnd_message.raise_error;
466: --
467: end if;
468: */
469: --
533: p_effective_date => p_effective_date) then
534: --
535: -- raise error as does not exist as lookup
536: --
537: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
538: fnd_message.raise_error;
539: --
540: end if;
541: --
534: --
535: -- raise error as does not exist as lookup
536: --
537: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
538: fnd_message.raise_error;
539: --
540: end if;
541: --
542: end if;
602: p_effective_date => p_effective_date) then
603: --
604: -- raise error as does not exist as lookup
605: --
606: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
607: fnd_message.raise_error;
608: --
609: end if;
610: --
603: --
604: -- raise error as does not exist as lookup
605: --
606: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
607: fnd_message.raise_error;
608: --
609: end if;
610: --
611: end if;
693: close csr_name;
694: --
695: -- raise error as UK1 is violated
696: --
697: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
698: fnd_message.raise_error;
699: -- ben_reg_shd.constraint_error('BEN_PL_TYP_F_UK1');
700: --
701: end if;
694: --
695: -- raise error as UK1 is violated
696: --
697: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
698: fnd_message.raise_error;
699: -- ben_reg_shd.constraint_error('BEN_PL_TYP_F_UK1');
700: --
701: end if;
702: --
765: --
766: -- raise error if max value not greater than or equal to min value
767: --
768: if (p_mx_enrl_alwd_num < p_mn_enrl_rqd_num) then
769: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
770: fnd_message.raise_error;
771: end if;
772: --
773: --
766: -- raise error if max value not greater than or equal to min value
767: --
768: if (p_mx_enrl_alwd_num < p_mn_enrl_rqd_num) then
769: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
770: fnd_message.raise_error;
771: end if;
772: --
773: --
774: end if;
777: -- then maximum enroll allowed number must be 0.
778: --
779: if nvl( p_no_mx_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
780: and (nvl(p_mx_enrl_alwd_num, 0) <> 0) then
781: fnd_message.set_name('BEN','BEN_91056_MIN_VAL_NOT_NULL');
782: fnd_message.raise_error;
783: end if;
784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
778: --
779: if nvl( p_no_mx_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
780: and (nvl(p_mx_enrl_alwd_num, 0) <> 0) then
781: fnd_message.set_name('BEN','BEN_91056_MIN_VAL_NOT_NULL');
782: fnd_message.raise_error;
783: end if;
784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
786: and (nvl(p_mn_enrl_rqd_num, 0) <> 0) then
783: end if;
784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
786: and (nvl(p_mn_enrl_rqd_num, 0) <> 0) then
787: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
788: fnd_message.raise_error;
789: end if;
790: --
791: --
784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
786: and (nvl(p_mn_enrl_rqd_num, 0) <> 0) then
787: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
788: fnd_message.raise_error;
789: end if;
790: --
791: --
792: hr_utility.set_location('Leaving:'||l_proc,10);
872: close c_opt_typ_cd;
873: --
874: -- raise error there's already a GSP pln type
875: --
876: --fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
877: fnd_message.set_name('BEN', 'BEN_93528_GSP_PLN_TYP');
878: fnd_message.raise_error;
879: --
880: end if;
873: --
874: -- raise error there's already a GSP pln type
875: --
876: --fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
877: fnd_message.set_name('BEN', 'BEN_93528_GSP_PLN_TYP');
878: fnd_message.raise_error;
879: --
880: end if;
881: --
874: -- raise error there's already a GSP pln type
875: --
876: --fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
877: fnd_message.set_name('BEN', 'BEN_93528_GSP_PLN_TYP');
878: fnd_message.raise_error;
879: --
880: end if;
881: --
882: close c_opt_typ_cd;
965: --
966: -- A referential integrity check was violated therefore
967: -- we must error
968: --
969: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
970: fnd_message.set_token('TABLE_NAME', l_table_name);
971: fnd_message.raise_error;
972: When Others Then
973: --
966: -- A referential integrity check was violated therefore
967: -- we must error
968: --
969: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
970: fnd_message.set_token('TABLE_NAME', l_table_name);
971: fnd_message.raise_error;
972: When Others Then
973: --
974: -- An unhandled or unexpected error has occurred which
967: -- we must error
968: --
969: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
970: fnd_message.set_token('TABLE_NAME', l_table_name);
971: fnd_message.raise_error;
972: When Others Then
973: --
974: -- An unhandled or unexpected error has occurred which
975: -- we must report
973: --
974: -- An unhandled or unexpected error has occurred which
975: -- we must report
976: --
977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
978: fnd_message.set_token('PROCEDURE', l_proc);
979: fnd_message.set_token('STEP','15');
980: fnd_message.raise_error;
981: End dt_update_validate;
974: -- An unhandled or unexpected error has occurred which
975: -- we must report
976: --
977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
978: fnd_message.set_token('PROCEDURE', l_proc);
979: fnd_message.set_token('STEP','15');
980: fnd_message.raise_error;
981: End dt_update_validate;
982: --
975: -- we must report
976: --
977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
978: fnd_message.set_token('PROCEDURE', l_proc);
979: fnd_message.set_token('STEP','15');
980: fnd_message.raise_error;
981: End dt_update_validate;
982: --
983: -- ----------------------------------------------------------------------------
976: --
977: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
978: fnd_message.set_token('PROCEDURE', l_proc);
979: fnd_message.set_token('STEP','15');
980: fnd_message.raise_error;
981: End dt_update_validate;
982: --
983: -- ----------------------------------------------------------------------------
984: -- |--------------------------< dt_delete_validate >--------------------------|
1104: --
1105: -- An unhandled or unexpected error has occurred which
1106: -- we must report
1107: --
1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1109: fnd_message.set_token('PROCEDURE', l_proc);
1110: fnd_message.set_token('STEP','15');
1111: fnd_message.raise_error;
1112: End dt_delete_validate;
1105: -- An unhandled or unexpected error has occurred which
1106: -- we must report
1107: --
1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1109: fnd_message.set_token('PROCEDURE', l_proc);
1110: fnd_message.set_token('STEP','15');
1111: fnd_message.raise_error;
1112: End dt_delete_validate;
1113: --
1106: -- we must report
1107: --
1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1109: fnd_message.set_token('PROCEDURE', l_proc);
1110: fnd_message.set_token('STEP','15');
1111: fnd_message.raise_error;
1112: End dt_delete_validate;
1113: --
1114: -- ----------------------------------------------------------------------------
1107: --
1108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1109: fnd_message.set_token('PROCEDURE', l_proc);
1110: fnd_message.set_token('STEP','15');
1111: fnd_message.raise_error;
1112: End dt_delete_validate;
1113: --
1114: -- ----------------------------------------------------------------------------
1115: -- |---------------------------< insert_validate >----------------------------|
1382: close csr_leg_code;
1383: --
1384: -- The primary key is invalid therefore we must error
1385: --
1386: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1387: fnd_message.raise_error;
1388: --
1389: end if;
1390: --
1383: --
1384: -- The primary key is invalid therefore we must error
1385: --
1386: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1387: fnd_message.raise_error;
1388: --
1389: end if;
1390: --
1391: close csr_leg_code;