133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
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('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;
195: open c1;
196: fetch c1 into l_dummy;
197: if c1%found then
198: close c1;
199: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
200: fnd_message.raise_error;
201: end if;
202: close c1;
203: --
196: fetch c1 into l_dummy;
197: if c1%found then
198: close c1;
199: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
200: fnd_message.raise_error;
201: end if;
202: close c1;
203: --
204: hr_utility.set_location('Leaving:'||l_proc, 15);
306: --
307: -- An unhandled or unexpected error has occurred which
308: -- we must report
309: --
310: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
311: fnd_message.set_token('PROCEDURE', l_proc);
312: fnd_message.set_token('STEP','15');
313: fnd_message.raise_error;
314: End dt_update_validate;
307: -- An unhandled or unexpected error has occurred which
308: -- we must report
309: --
310: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
311: fnd_message.set_token('PROCEDURE', l_proc);
312: fnd_message.set_token('STEP','15');
313: fnd_message.raise_error;
314: End dt_update_validate;
315: --
308: -- we must report
309: --
310: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
311: fnd_message.set_token('PROCEDURE', l_proc);
312: fnd_message.set_token('STEP','15');
313: fnd_message.raise_error;
314: End dt_update_validate;
315: --
316: -- ----------------------------------------------------------------------------
309: --
310: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
311: fnd_message.set_token('PROCEDURE', l_proc);
312: fnd_message.set_token('STEP','15');
313: fnd_message.raise_error;
314: End dt_update_validate;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |--------------------------< dt_delete_validate >--------------------------|
408: --
409: -- An unhandled or unexpected error has occurred which
410: -- we must report
411: --
412: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
413: fnd_message.set_token('PROCEDURE', l_proc);
414: fnd_message.set_token('STEP','15');
415: fnd_message.raise_error;
416: End dt_delete_validate;
409: -- An unhandled or unexpected error has occurred which
410: -- we must report
411: --
412: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
413: fnd_message.set_token('PROCEDURE', l_proc);
414: fnd_message.set_token('STEP','15');
415: fnd_message.raise_error;
416: End dt_delete_validate;
417: --
410: -- we must report
411: --
412: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
413: fnd_message.set_token('PROCEDURE', l_proc);
414: fnd_message.set_token('STEP','15');
415: fnd_message.raise_error;
416: End dt_delete_validate;
417: --
418: -- ----------------------------------------------------------------------------
411: --
412: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
413: fnd_message.set_token('PROCEDURE', l_proc);
414: fnd_message.set_token('STEP','15');
415: fnd_message.raise_error;
416: End dt_delete_validate;
417: --
418: -- ----------------------------------------------------------------------------
419: -- |---------------------------< insert_validate >----------------------------|
570: close csr_leg_code;
571: --
572: -- The primary key is invalid therefore we must error
573: --
574: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
571: --
572: -- The primary key is invalid therefore we must error
573: --
574: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
579: close csr_leg_code;