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_91609_INVALID_RT_TRMT_CD');
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('BEN','BEN_91609_INVALID_RT_TRMT_CD');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;
223: close c1;
224: --
225: -- raise error
226: --
227: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
228: fnd_message.set_token('ID',p_formula_id);
229: fnd_message.set_token('TYPE_ID',-507);
230: fnd_message.raise_error;
231: --
224: --
225: -- raise error
226: --
227: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
228: fnd_message.set_token('ID',p_formula_id);
229: fnd_message.set_token('TYPE_ID',-507);
230: fnd_message.raise_error;
231: --
232: end if;
225: -- raise error
226: --
227: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
228: fnd_message.set_token('ID',p_formula_id);
229: fnd_message.set_token('TYPE_ID',-507);
230: fnd_message.raise_error;
231: --
232: end if;
233: --
226: --
227: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
228: fnd_message.set_token('ID',p_formula_id);
229: fnd_message.set_token('TYPE_ID',-507);
230: fnd_message.raise_error;
231: --
232: end if;
233: --
234: close c1;
309: close c1;
310: --
311: -- raise an error as this actl_prem_id has been assigned to profile(s).
312: --
313: fnd_message.set_name('BEN','BEN_91612_VRR_VRP_EXCL1');
314: fnd_message.raise_error;
315: --
316: end if;
317: --
310: --
311: -- raise an error as this actl_prem_id has been assigned to profile(s).
312: --
313: fnd_message.set_name('BEN','BEN_91612_VRR_VRP_EXCL1');
314: fnd_message.raise_error;
315: --
316: end if;
317: --
318: close c1;
371: open c1;
372: fetch c1 into l_dummy;
373: if c1%found then
374: close c1;
375: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
376: fnd_message.raise_error;
377: end if;
378: --
379: hr_utility.set_location('Leaving:'||l_proc, 15);
372: fetch c1 into l_dummy;
373: if c1%found then
374: close c1;
375: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
376: fnd_message.raise_error;
377: end if;
378: --
379: hr_utility.set_location('Leaving:'||l_proc, 15);
380: End chk_ordr_to_aply_num_unique;
470: --
471: -- An unhandled or unexpected error has occurred which
472: -- we must report
473: --
474: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
475: fnd_message.set_token('PROCEDURE', l_proc);
476: fnd_message.set_token('STEP','15');
477: fnd_message.raise_error;
478: End dt_update_validate;
471: -- An unhandled or unexpected error has occurred which
472: -- we must report
473: --
474: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
475: fnd_message.set_token('PROCEDURE', l_proc);
476: fnd_message.set_token('STEP','15');
477: fnd_message.raise_error;
478: End dt_update_validate;
479: --
472: -- we must report
473: --
474: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
475: fnd_message.set_token('PROCEDURE', l_proc);
476: fnd_message.set_token('STEP','15');
477: fnd_message.raise_error;
478: End dt_update_validate;
479: --
480: -- ----------------------------------------------------------------------------
473: --
474: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
475: fnd_message.set_token('PROCEDURE', l_proc);
476: fnd_message.set_token('STEP','15');
477: fnd_message.raise_error;
478: End dt_update_validate;
479: --
480: -- ----------------------------------------------------------------------------
481: -- |--------------------------< dt_delete_validate >--------------------------|
572: --
573: -- An unhandled or unexpected error has occurred which
574: -- we must report
575: --
576: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
577: fnd_message.set_token('PROCEDURE', l_proc);
578: fnd_message.set_token('STEP','15');
579: fnd_message.raise_error;
580: End dt_delete_validate;
573: -- An unhandled or unexpected error has occurred which
574: -- we must report
575: --
576: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
577: fnd_message.set_token('PROCEDURE', l_proc);
578: fnd_message.set_token('STEP','15');
579: fnd_message.raise_error;
580: End dt_delete_validate;
581: --
574: -- we must report
575: --
576: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
577: fnd_message.set_token('PROCEDURE', l_proc);
578: fnd_message.set_token('STEP','15');
579: fnd_message.raise_error;
580: End dt_delete_validate;
581: --
582: -- ----------------------------------------------------------------------------
575: --
576: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
577: fnd_message.set_token('PROCEDURE', l_proc);
578: fnd_message.set_token('STEP','15');
579: fnd_message.raise_error;
580: End dt_delete_validate;
581: --
582: -- ----------------------------------------------------------------------------
583: -- |---------------------------< insert_validate >----------------------------|
762: close csr_leg_code;
763: --
764: -- The primary key is invalid therefore we must error
765: --
766: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
767: fnd_message.raise_error;
768: --
769: end if;
770: --
763: --
764: -- The primary key is invalid therefore we must error
765: --
766: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
767: fnd_message.raise_error;
768: --
769: end if;
770: --
771: close csr_leg_code;