139: open c1;
140: fetch c1 into l_dummy;
141: if c1%found then
142: close c1;
143: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
144: fnd_message.raise_error;
145: end if;
146: end if;
147: --
140: fetch c1 into l_dummy;
141: if c1%found then
142: close c1;
143: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
144: fnd_message.raise_error;
145: end if;
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc, 15);
293: --
294: -- raise error as FK does not relate to PK in pay_balance_types
295: -- table.
296: --
297: fnd_message.set_name('BEN','BEN_91770_BAL_TYPE_NOT_EXIST');
298: fnd_message.raise_error;
299: --
300: end if;
301: --
294: -- raise error as FK does not relate to PK in pay_balance_types
295: -- table.
296: --
297: fnd_message.set_name('BEN','BEN_91770_BAL_TYPE_NOT_EXIST');
298: fnd_message.raise_error;
299: --
300: end if;
301: --
302: close c1;
364: p_effective_date => p_effective_date) then
365: --
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_lmt_det_cd');
370: fnd_message.set_token('TYPE','BEN_LMT_DET');
371: fnd_message.raise_error;
372: --
365: --
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_lmt_det_cd');
370: fnd_message.set_token('TYPE','BEN_LMT_DET');
371: fnd_message.raise_error;
372: --
373: end if;
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_lmt_det_cd');
370: fnd_message.set_token('TYPE','BEN_LMT_DET');
371: fnd_message.raise_error;
372: --
373: end if;
374: --
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_lmt_det_cd');
370: fnd_message.set_token('TYPE','BEN_LMT_DET');
371: fnd_message.raise_error;
372: --
373: end if;
374: --
375: end if;
457: close c1;
458: --
459: -- raise error
460: --
461: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);
463: fnd_message.set_token('TYPE_ID',-167);
464: fnd_message.raise_error;
465: --
458: --
459: -- raise error
460: --
461: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);
463: fnd_message.set_token('TYPE_ID',-167);
464: fnd_message.raise_error;
465: --
466: end if;
459: -- raise error
460: --
461: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);
463: fnd_message.set_token('TYPE_ID',-167);
464: fnd_message.raise_error;
465: --
466: end if;
467: --
460: --
461: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);
463: fnd_message.set_token('TYPE_ID',-167);
464: fnd_message.raise_error;
465: --
466: end if;
467: --
468: close c1;
556: --
557: -- An unhandled or unexpected error has occurred which
558: -- we must report
559: --
560: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
561: fnd_message.set_token('PROCEDURE', l_proc);
562: fnd_message.set_token('STEP','15');
563: fnd_message.raise_error;
564: End dt_update_validate;
557: -- An unhandled or unexpected error has occurred which
558: -- we must report
559: --
560: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
561: fnd_message.set_token('PROCEDURE', l_proc);
562: fnd_message.set_token('STEP','15');
563: fnd_message.raise_error;
564: End dt_update_validate;
565: --
558: -- we must report
559: --
560: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
561: fnd_message.set_token('PROCEDURE', l_proc);
562: fnd_message.set_token('STEP','15');
563: fnd_message.raise_error;
564: End dt_update_validate;
565: --
566: -- ----------------------------------------------------------------------------
559: --
560: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
561: fnd_message.set_token('PROCEDURE', l_proc);
562: fnd_message.set_token('STEP','15');
563: fnd_message.raise_error;
564: End dt_update_validate;
565: --
566: -- ----------------------------------------------------------------------------
567: -- |--------------------------< dt_delete_validate >--------------------------|
667: --
668: -- An unhandled or unexpected error has occurred which
669: -- we must report
670: --
671: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
672: fnd_message.set_token('PROCEDURE', l_proc);
673: fnd_message.set_token('STEP','15');
674: fnd_message.raise_error;
675: End dt_delete_validate;
668: -- An unhandled or unexpected error has occurred which
669: -- we must report
670: --
671: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
672: fnd_message.set_token('PROCEDURE', l_proc);
673: fnd_message.set_token('STEP','15');
674: fnd_message.raise_error;
675: End dt_delete_validate;
676: --
669: -- we must report
670: --
671: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
672: fnd_message.set_token('PROCEDURE', l_proc);
673: fnd_message.set_token('STEP','15');
674: fnd_message.raise_error;
675: End dt_delete_validate;
676: --
677: -- ----------------------------------------------------------------------------
670: --
671: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
672: fnd_message.set_token('PROCEDURE', l_proc);
673: fnd_message.set_token('STEP','15');
674: fnd_message.raise_error;
675: End dt_delete_validate;
676: --
677: -- ----------------------------------------------------------------------------
678: -- |---------------------------< insert_validate >----------------------------|
865: close csr_leg_code;
866: --
867: -- The primary key is invalid therefore we must error
868: --
869: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
870: fnd_message.raise_error;
871: --
872: end if;
873: --
866: --
867: -- The primary key is invalid therefore we must error
868: --
869: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
870: fnd_message.raise_error;
871: --
872: end if;
873: --
874: close csr_leg_code;