151: --
152: -- raise error as UK1 is violated
153: --
154: --Bug 2960193 Created message and updated message name in call to set_name
155: fnd_message.set_name('BEN','BEN_93794_FUTURE_LE_PLAN_EXIST');
156: fnd_message.raise_error;
157: --Bug 2960193
158: --
159: end if;
152: -- raise error as UK1 is violated
153: --
154: --Bug 2960193 Created message and updated message name in call to set_name
155: fnd_message.set_name('BEN','BEN_93794_FUTURE_LE_PLAN_EXIST');
156: fnd_message.raise_error;
157: --Bug 2960193
158: --
159: end if;
160: --
224: p_effective_date => p_effective_date) then
225: --
226: -- raise error as does not exist as lookup
227: --
228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
229: fnd_message.set_token('FIELD', 'p_enrt_cd');
230: fnd_message.set_token('TYPE', 'BEN_ENRT');
231: fnd_message.raise_error;
232: --
225: --
226: -- raise error as does not exist as lookup
227: --
228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
229: fnd_message.set_token('FIELD', 'p_enrt_cd');
230: fnd_message.set_token('TYPE', 'BEN_ENRT');
231: fnd_message.raise_error;
232: --
233: end if;
226: -- raise error as does not exist as lookup
227: --
228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
229: fnd_message.set_token('FIELD', 'p_enrt_cd');
230: fnd_message.set_token('TYPE', 'BEN_ENRT');
231: fnd_message.raise_error;
232: --
233: end if;
234: --
227: --
228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
229: fnd_message.set_token('FIELD', 'p_enrt_cd');
230: fnd_message.set_token('TYPE', 'BEN_ENRT');
231: fnd_message.raise_error;
232: --
233: end if;
234: --
235: end if;
295: p_effective_date => p_effective_date) then
296: --
297: -- raise error as does not exist as lookup
298: --
299: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
300: fnd_message.set_token('FIELD', 'p_stl_elig_cant_chg_flag');
301: fnd_message.set_token('TYPE', 'YES_NO');
302: fnd_message.raise_error;
303: --
296: --
297: -- raise error as does not exist as lookup
298: --
299: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
300: fnd_message.set_token('FIELD', 'p_stl_elig_cant_chg_flag');
301: fnd_message.set_token('TYPE', 'YES_NO');
302: fnd_message.raise_error;
303: --
304: end if;
297: -- raise error as does not exist as lookup
298: --
299: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
300: fnd_message.set_token('FIELD', 'p_stl_elig_cant_chg_flag');
301: fnd_message.set_token('TYPE', 'YES_NO');
302: fnd_message.raise_error;
303: --
304: end if;
305: --
298: --
299: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
300: fnd_message.set_token('FIELD', 'p_stl_elig_cant_chg_flag');
301: fnd_message.set_token('TYPE', 'YES_NO');
302: fnd_message.raise_error;
303: --
304: end if;
305: --
306: end if;
366: p_effective_date => p_effective_date) then
367: --
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
372: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
373: fnd_message.raise_error;
374: --
367: --
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
372: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
373: fnd_message.raise_error;
374: --
375: end if;
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
372: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
373: fnd_message.raise_error;
374: --
375: end if;
376: --
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
372: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
373: fnd_message.raise_error;
374: --
375: end if;
376: --
377: end if;
437: p_effective_date => p_effective_date) then
438: --
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', 'p_dflt_enrt_cd');
443: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
444: fnd_message.raise_error;
445: --
438: --
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', 'p_dflt_enrt_cd');
443: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
444: fnd_message.raise_error;
445: --
446: end if;
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', 'p_dflt_enrt_cd');
443: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
444: fnd_message.raise_error;
445: --
446: end if;
447: --
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', 'p_dflt_enrt_cd');
443: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
444: fnd_message.raise_error;
445: --
446: end if;
447: --
448: end if;
530: close c1;
531: --
532: -- raise error
533: --
534: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
535: fnd_message.set_token('ID',p_enrt_rl);
536: fnd_message.set_token('TYPE_ID',-393);
537: fnd_message.raise_error;
538: --
531: --
532: -- raise error
533: --
534: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
535: fnd_message.set_token('ID',p_enrt_rl);
536: fnd_message.set_token('TYPE_ID',-393);
537: fnd_message.raise_error;
538: --
539: end if;
532: -- raise error
533: --
534: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
535: fnd_message.set_token('ID',p_enrt_rl);
536: fnd_message.set_token('TYPE_ID',-393);
537: fnd_message.raise_error;
538: --
539: end if;
540: --
533: --
534: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
535: fnd_message.set_token('ID',p_enrt_rl);
536: fnd_message.set_token('TYPE_ID',-393);
537: fnd_message.raise_error;
538: --
539: end if;
540: --
541: close c1;
625: close c1;
626: --
627: -- raise error
628: --
629: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
630: fnd_message.set_token('ID',p_dflt_enrt_rl);
631: fnd_message.set_token('TYPE_ID',-32);
632: fnd_message.raise_error;
633: --
626: --
627: -- raise error
628: --
629: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
630: fnd_message.set_token('ID',p_dflt_enrt_rl);
631: fnd_message.set_token('TYPE_ID',-32);
632: fnd_message.raise_error;
633: --
634: end if;
627: -- raise error
628: --
629: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
630: fnd_message.set_token('ID',p_dflt_enrt_rl);
631: fnd_message.set_token('TYPE_ID',-32);
632: fnd_message.raise_error;
633: --
634: end if;
635: --
628: --
629: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
630: fnd_message.set_token('ID',p_dflt_enrt_rl);
631: fnd_message.set_token('TYPE_ID',-32);
632: fnd_message.raise_error;
633: --
634: end if;
635: --
636: close c1;
718: p_effective_date => p_effective_date) then
719: --
720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('FIELD', 'p_dflt_flag');
724: fnd_message.set_token('TYPE', 'YES_NO');
725: fnd_message.raise_error;
726: --
719: --
720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('FIELD', 'p_dflt_flag');
724: fnd_message.set_token('TYPE', 'YES_NO');
725: fnd_message.raise_error;
726: --
727: end if;
720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('FIELD', 'p_dflt_flag');
724: fnd_message.set_token('TYPE', 'YES_NO');
725: fnd_message.raise_error;
726: --
727: end if;
728: --
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('FIELD', 'p_dflt_flag');
724: fnd_message.set_token('TYPE', 'YES_NO');
725: fnd_message.raise_error;
726: --
727: end if;
728: --
729: -- COMMENTING OUT PER BUG# 849
735: -- close chk_unique;
736: -- --
737: -- -- raise error as UK1 is violated
738: -- --
739: -- fnd_message.set_name('PAY','ONLY_ONE_DEFAULT');
740: -- fnd_message.raise_error;
741: -- --
742: -- end if;
743: -- --
736: -- --
737: -- -- raise error as UK1 is violated
738: -- --
739: -- fnd_message.set_name('PAY','ONLY_ONE_DEFAULT');
740: -- fnd_message.raise_error;
741: -- --
742: -- end if;
743: -- --
744: -- close chk_unique;
807: p_effective_date => p_effective_date) then
808: --
809: -- raise error as does not exist as lookup
810: --
811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
812: fnd_message.set_token('FIELD', 'p_crnt_enrt_prclds_chg_flag');
813: fnd_message.set_token('TYPE', 'YES_NO');
814: fnd_message.raise_error;
815: --
808: --
809: -- raise error as does not exist as lookup
810: --
811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
812: fnd_message.set_token('FIELD', 'p_crnt_enrt_prclds_chg_flag');
813: fnd_message.set_token('TYPE', 'YES_NO');
814: fnd_message.raise_error;
815: --
816: end if;
809: -- raise error as does not exist as lookup
810: --
811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
812: fnd_message.set_token('FIELD', 'p_crnt_enrt_prclds_chg_flag');
813: fnd_message.set_token('TYPE', 'YES_NO');
814: fnd_message.raise_error;
815: --
816: end if;
817: --
810: --
811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
812: fnd_message.set_token('FIELD', 'p_crnt_enrt_prclds_chg_flag');
813: fnd_message.set_token('TYPE', 'YES_NO');
814: fnd_message.raise_error;
815: --
816: end if;
817: --
818: end if;
879: p_effective_date => p_effective_date) then
880: --
881: -- raise error as does not exist as lookup
882: --
883: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
884: fnd_message.set_token('FIELD', 'p_tco_chg_enrt_cd');
885: fnd_message.set_token('TYPE', 'BEN_TCO_CHG_ENRT');
886: fnd_message.raise_error;
887: --
880: --
881: -- raise error as does not exist as lookup
882: --
883: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
884: fnd_message.set_token('FIELD', 'p_tco_chg_enrt_cd');
885: fnd_message.set_token('TYPE', 'BEN_TCO_CHG_ENRT');
886: fnd_message.raise_error;
887: --
888: end if;
881: -- raise error as does not exist as lookup
882: --
883: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
884: fnd_message.set_token('FIELD', 'p_tco_chg_enrt_cd');
885: fnd_message.set_token('TYPE', 'BEN_TCO_CHG_ENRT');
886: fnd_message.raise_error;
887: --
888: end if;
889: --
882: --
883: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
884: fnd_message.set_token('FIELD', 'p_tco_chg_enrt_cd');
885: fnd_message.set_token('TYPE', 'BEN_TCO_CHG_ENRT');
886: fnd_message.raise_error;
887: --
888: end if;
889: --
890: end if;
972: close c1;
973: --
974: -- raise error
975: --
976: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
977: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
978: fnd_message.set_token('TYPE_ID',-146);
979: fnd_message.raise_error;
980: --
973: --
974: -- raise error
975: --
976: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
977: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
978: fnd_message.set_token('TYPE_ID',-146);
979: fnd_message.raise_error;
980: --
981: end if;
974: -- raise error
975: --
976: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
977: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
978: fnd_message.set_token('TYPE_ID',-146);
979: fnd_message.raise_error;
980: --
981: end if;
982: --
975: --
976: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
977: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
978: fnd_message.set_token('TYPE_ID',-146);
979: fnd_message.raise_error;
980: --
981: end if;
982: --
983: close c1;
1090: --
1091: -- An unhandled or unexpected error has occurred which
1092: -- we must report
1093: --
1094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1095: fnd_message.set_token('PROCEDURE', l_proc);
1096: fnd_message.set_token('STEP','15');
1097: fnd_message.raise_error;
1098: End dt_update_validate;
1091: -- An unhandled or unexpected error has occurred which
1092: -- we must report
1093: --
1094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1095: fnd_message.set_token('PROCEDURE', l_proc);
1096: fnd_message.set_token('STEP','15');
1097: fnd_message.raise_error;
1098: End dt_update_validate;
1099: --
1092: -- we must report
1093: --
1094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1095: fnd_message.set_token('PROCEDURE', l_proc);
1096: fnd_message.set_token('STEP','15');
1097: fnd_message.raise_error;
1098: End dt_update_validate;
1099: --
1100: -- ----------------------------------------------------------------------------
1093: --
1094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1095: fnd_message.set_token('PROCEDURE', l_proc);
1096: fnd_message.set_token('STEP','15');
1097: fnd_message.raise_error;
1098: End dt_update_validate;
1099: --
1100: -- ----------------------------------------------------------------------------
1101: -- |--------------------------< dt_delete_validate >--------------------------|
1200: --
1201: -- An unhandled or unexpected error has occurred which
1202: -- we must report
1203: --
1204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1205: fnd_message.set_token('PROCEDURE', l_proc);
1206: fnd_message.set_token('STEP','15');
1207: fnd_message.raise_error;
1208: End dt_delete_validate;
1201: -- An unhandled or unexpected error has occurred which
1202: -- we must report
1203: --
1204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1205: fnd_message.set_token('PROCEDURE', l_proc);
1206: fnd_message.set_token('STEP','15');
1207: fnd_message.raise_error;
1208: End dt_delete_validate;
1209: --
1202: -- we must report
1203: --
1204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1205: fnd_message.set_token('PROCEDURE', l_proc);
1206: fnd_message.set_token('STEP','15');
1207: fnd_message.raise_error;
1208: End dt_delete_validate;
1209: --
1210: -- ----------------------------------------------------------------------------
1203: --
1204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1205: fnd_message.set_token('PROCEDURE', l_proc);
1206: fnd_message.set_token('STEP','15');
1207: fnd_message.raise_error;
1208: End dt_delete_validate;
1209: --
1210: -- ----------------------------------------------------------------------------
1211: -- |---------------------------< insert_validate >----------------------------|
1493: close csr_leg_code;
1494: --
1495: -- The primary key is invalid therefore we must error
1496: --
1497: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1498: fnd_message.raise_error;
1499: --
1500: end if;
1501: --
1494: --
1495: -- The primary key is invalid therefore we must error
1496: --
1497: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1498: fnd_message.raise_error;
1499: --
1500: end if;
1501: --
1502: close csr_leg_code;