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_91622_INVALID_BAL_USG_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_91622_INVALID_BAL_USG_CD');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;
201: p_effective_date => p_effective_date) then
202: --
203: -- raise error as does not exist as lookup
204: --
205: fnd_message.set_name('BEN','BEN_91786_INVALID_NNMNTRY_UOM');
206: fnd_message.raise_error;
207: --
208: end if;
209: --
202: --
203: -- raise error as does not exist as lookup
204: --
205: fnd_message.set_name('BEN','BEN_91786_INVALID_NNMNTRY_UOM');
206: fnd_message.raise_error;
207: --
208: end if;
209: --
210: end if;
278: -- p_effective_date => p_effective_date) then
279: --
280: -- raise error as does not exist as lookup
281: --
282: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
283: fnd_message.raise_error;
284: --
285: -- end if;
286: end if;
279: --
280: -- raise error as does not exist as lookup
281: --
282: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
283: fnd_message.raise_error;
284: --
285: -- end if;
286: end if;
287: close c1;
336: open c1;
337: fetch c1 into l_dummy;
338: if c1%found then
339: close c1;
340: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
341: fnd_message.raise_error;
342: end if;
343: --
344: hr_utility.set_location('Leaving:'||l_proc, 15);
337: fetch c1 into l_dummy;
338: if c1%found then
339: close c1;
340: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
341: fnd_message.raise_error;
342: end if;
343: --
344: hr_utility.set_location('Leaving:'||l_proc, 15);
345: End chk_name_unique;
426: --
427: -- An unhandled or unexpected error has occurred which
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: End dt_update_validate;
427: -- An unhandled or unexpected error has occurred which
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: End dt_update_validate;
435: --
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: End dt_update_validate;
435: --
436: -- ----------------------------------------------------------------------------
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: End dt_update_validate;
435: --
436: -- ----------------------------------------------------------------------------
437: -- |--------------------------< dt_delete_validate >--------------------------|
536: --
537: -- An unhandled or unexpected error has occurred which
538: -- we must report
539: --
540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE', l_proc);
542: fnd_message.set_token('STEP','15');
543: fnd_message.raise_error;
544: End dt_delete_validate;
537: -- An unhandled or unexpected error has occurred which
538: -- we must report
539: --
540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE', l_proc);
542: fnd_message.set_token('STEP','15');
543: fnd_message.raise_error;
544: End dt_delete_validate;
545: --
538: -- we must report
539: --
540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE', l_proc);
542: fnd_message.set_token('STEP','15');
543: fnd_message.raise_error;
544: End dt_delete_validate;
545: --
546: -- ----------------------------------------------------------------------------
539: --
540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE', l_proc);
542: fnd_message.set_token('STEP','15');
543: fnd_message.raise_error;
544: End dt_delete_validate;
545: --
546: -- ----------------------------------------------------------------------------
547: -- |---------------------------< insert_validate >----------------------------|
724: close csr_leg_code;
725: --
726: -- The primary key is invalid therefore we must error
727: --
728: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
729: fnd_message.raise_error;
730: --
731: end if;
732: --
725: --
726: -- The primary key is invalid therefore we must error
727: --
728: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
729: fnd_message.raise_error;
730: --
731: end if;
732: --
733: close csr_leg_code;