133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_auto_enrt_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_auto_enrt_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_auto_enrt_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_auto_enrt_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
204: p_effective_date => p_effective_date) then
205: --
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
209: fnd_message.raise_error;
210: --
211: end if;
212: --
205: --
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
209: fnd_message.raise_error;
210: --
211: end if;
212: --
213: end if;
273: p_effective_date => p_effective_date) then
274: --
275: -- raise error as does not exist as lookup
276: --
277: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
278: fnd_message.raise_error;
279: --
280: end if;
281: --
274: --
275: -- raise error as does not exist as lookup
276: --
277: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
278: fnd_message.raise_error;
279: --
280: end if;
281: --
282: end if;
342: p_effective_date => p_effective_date) then
343: --
344: -- raise error as does not exist as lookup
345: --
346: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
347: fnd_message.raise_error;
348: --
349: end if;
350: --
343: --
344: -- raise error as does not exist as lookup
345: --
346: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
347: fnd_message.raise_error;
348: --
349: end if;
350: --
351: end if;
434: close c1;
435: --
436: -- raise error
437: --
438: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
439: fnd_message.set_token('ID',p_dflt_enrt_rl);
440: fnd_message.set_token('TYPE_ID',-32);
441: fnd_message.raise_error;
442: --
435: --
436: -- raise error
437: --
438: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
439: fnd_message.set_token('ID',p_dflt_enrt_rl);
440: fnd_message.set_token('TYPE_ID',-32);
441: fnd_message.raise_error;
442: --
443: end if;
436: -- raise error
437: --
438: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
439: fnd_message.set_token('ID',p_dflt_enrt_rl);
440: fnd_message.set_token('TYPE_ID',-32);
441: fnd_message.raise_error;
442: --
443: end if;
444: --
437: --
438: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
439: fnd_message.set_token('ID',p_dflt_enrt_rl);
440: fnd_message.set_token('TYPE_ID',-32);
441: fnd_message.raise_error;
442: --
443: end if;
444: --
445: close c1;
507: p_effective_date => p_effective_date) then
508: --
509: -- raise error as does not exist as lookup
510: --
511: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
512: fnd_message.raise_error;
513: --
514: end if;
515: --
508: --
509: -- raise error as does not exist as lookup
510: --
511: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
512: fnd_message.raise_error;
513: --
514: end if;
515: --
516: end if;
599: close c1;
600: --
601: -- raise error
602: --
603: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
604: fnd_message.set_token('ID',p_enrt_rl);
605: fnd_message.set_token('TYPE_ID',-393);
606: fnd_message.raise_error;
607: --
600: --
601: -- raise error
602: --
603: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
604: fnd_message.set_token('ID',p_enrt_rl);
605: fnd_message.set_token('TYPE_ID',-393);
606: fnd_message.raise_error;
607: --
608: end if;
601: -- raise error
602: --
603: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
604: fnd_message.set_token('ID',p_enrt_rl);
605: fnd_message.set_token('TYPE_ID',-393);
606: fnd_message.raise_error;
607: --
608: end if;
609: --
602: --
603: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
604: fnd_message.set_token('ID',p_enrt_rl);
605: fnd_message.set_token('TYPE_ID',-393);
606: fnd_message.raise_error;
607: --
608: end if;
609: --
610: close c1;
695: close c1;
696: --
697: -- raise error
698: --
699: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
700: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
701: fnd_message.set_token('TYPE_ID',-146);
702: fnd_message.raise_error;
703: --
696: --
697: -- raise error
698: --
699: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
700: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
701: fnd_message.set_token('TYPE_ID',-146);
702: fnd_message.raise_error;
703: --
704: end if;
697: -- raise error
698: --
699: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
700: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
701: fnd_message.set_token('TYPE_ID',-146);
702: fnd_message.raise_error;
703: --
704: end if;
705: --
698: --
699: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
700: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
701: fnd_message.set_token('TYPE_ID',-146);
702: fnd_message.raise_error;
703: --
704: end if;
705: --
706: close c1;
770: p_effective_date => p_effective_date) then
771: --
772: -- raise error as does not exist as lookup
773: --
774: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
775: fnd_message.raise_error;
776: --
777: end if;
778: --
771: --
772: -- raise error as does not exist as lookup
773: --
774: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
775: fnd_message.raise_error;
776: --
777: end if;
778: --
779: end if;
843: p_effective_date => p_effective_date) then
844: --
845: -- raise error as does not exist as lookup
846: --
847: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
848: fnd_message.raise_error;
849: --
850: end if;
851: --
844: --
845: -- raise error as does not exist as lookup
846: --
847: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
848: fnd_message.raise_error;
849: --
850: end if;
851: --
852: end if;
915: p_effective_date => p_effective_date) then
916: --
917: -- raise error as does not exist as lookup
918: --
919: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
920: fnd_message.raise_error;
921: --
922: end if;
923: --
916: --
917: -- raise error as does not exist as lookup
918: --
919: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
920: fnd_message.raise_error;
921: --
922: end if;
923: --
924: end if;
985: p_effective_date => p_effective_date) then
986: --
987: -- raise error as does not exist as lookup
988: --
989: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
990: fnd_message.raise_error;
991: --
992: end if;
993: --
986: --
987: -- raise error as does not exist as lookup
988: --
989: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
990: fnd_message.raise_error;
991: --
992: end if;
993: --
994: end if;
1100: --
1101: -- An unhandled or unexpected error has occurred which
1102: -- we must report
1103: --
1104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1105: fnd_message.set_token('PROCEDURE', l_proc);
1106: fnd_message.set_token('STEP','15');
1107: fnd_message.raise_error;
1108: End dt_update_validate;
1101: -- An unhandled or unexpected error has occurred which
1102: -- we must report
1103: --
1104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1105: fnd_message.set_token('PROCEDURE', l_proc);
1106: fnd_message.set_token('STEP','15');
1107: fnd_message.raise_error;
1108: End dt_update_validate;
1109: --
1102: -- we must report
1103: --
1104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1105: fnd_message.set_token('PROCEDURE', l_proc);
1106: fnd_message.set_token('STEP','15');
1107: fnd_message.raise_error;
1108: End dt_update_validate;
1109: --
1110: -- ----------------------------------------------------------------------------
1103: --
1104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1105: fnd_message.set_token('PROCEDURE', l_proc);
1106: fnd_message.set_token('STEP','15');
1107: fnd_message.raise_error;
1108: End dt_update_validate;
1109: --
1110: -- ----------------------------------------------------------------------------
1111: -- |--------------------------< dt_delete_validate >--------------------------|
1211: --
1212: -- An unhandled or unexpected error has occurred which
1213: -- we must report
1214: --
1215: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1216: fnd_message.set_token('PROCEDURE', l_proc);
1217: fnd_message.set_token('STEP','15');
1218: fnd_message.raise_error;
1219: End dt_delete_validate;
1212: -- An unhandled or unexpected error has occurred which
1213: -- we must report
1214: --
1215: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1216: fnd_message.set_token('PROCEDURE', l_proc);
1217: fnd_message.set_token('STEP','15');
1218: fnd_message.raise_error;
1219: End dt_delete_validate;
1220: --
1213: -- we must report
1214: --
1215: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1216: fnd_message.set_token('PROCEDURE', l_proc);
1217: fnd_message.set_token('STEP','15');
1218: fnd_message.raise_error;
1219: End dt_delete_validate;
1220: --
1221: -- ----------------------------------------------------------------------------
1214: --
1215: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1216: fnd_message.set_token('PROCEDURE', l_proc);
1217: fnd_message.set_token('STEP','15');
1218: fnd_message.raise_error;
1219: End dt_delete_validate;
1220: --
1221: -- ----------------------------------------------------------------------------
1222: -- |---------------------------< insert_validate >----------------------------|
1507: close csr_leg_code;
1508: --
1509: -- The primary key is invalid therefore we must error
1510: --
1511: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1512: fnd_message.raise_error;
1513: --
1514: end if;
1515: --
1508: --
1509: -- The primary key is invalid therefore we must error
1510: --
1511: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1512: fnd_message.raise_error;
1513: --
1514: end if;
1515: --
1516: close csr_leg_code;