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;
205: p_effective_date => p_effective_date) then
206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
210: fnd_message.raise_error;
211: --
212: end if;
213: --
206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
210: fnd_message.raise_error;
211: --
212: end if;
213: --
214: end if;
309: --
310: -- An unhandled or unexpected error has occurred which
311: -- we must report
312: --
313: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
314: fnd_message.set_token('PROCEDURE', l_proc);
315: fnd_message.set_token('STEP','15');
316: fnd_message.raise_error;
317: End dt_update_validate;
310: -- An unhandled or unexpected error has occurred which
311: -- we must report
312: --
313: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
314: fnd_message.set_token('PROCEDURE', l_proc);
315: fnd_message.set_token('STEP','15');
316: fnd_message.raise_error;
317: End dt_update_validate;
318: --
311: -- we must report
312: --
313: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
314: fnd_message.set_token('PROCEDURE', l_proc);
315: fnd_message.set_token('STEP','15');
316: fnd_message.raise_error;
317: End dt_update_validate;
318: --
319: -- ----------------------------------------------------------------------------
312: --
313: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
314: fnd_message.set_token('PROCEDURE', l_proc);
315: fnd_message.set_token('STEP','15');
316: fnd_message.raise_error;
317: End dt_update_validate;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |--------------------------< dt_delete_validate >--------------------------|
411: --
412: -- An unhandled or unexpected error has occurred which
413: -- we must report
414: --
415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
416: fnd_message.set_token('PROCEDURE', l_proc);
417: fnd_message.set_token('STEP','15');
418: fnd_message.raise_error;
419: End dt_delete_validate;
412: -- An unhandled or unexpected error has occurred which
413: -- we must report
414: --
415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
416: fnd_message.set_token('PROCEDURE', l_proc);
417: fnd_message.set_token('STEP','15');
418: fnd_message.raise_error;
419: End dt_delete_validate;
420: --
413: -- we must report
414: --
415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
416: fnd_message.set_token('PROCEDURE', l_proc);
417: fnd_message.set_token('STEP','15');
418: fnd_message.raise_error;
419: End dt_delete_validate;
420: --
421: -- ----------------------------------------------------------------------------
414: --
415: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
416: fnd_message.set_token('PROCEDURE', l_proc);
417: fnd_message.set_token('STEP','15');
418: fnd_message.raise_error;
419: End dt_delete_validate;
420: --
421: -- ----------------------------------------------------------------------------
422: -- |---------------------------< insert_validate >----------------------------|
573: close csr_leg_code;
574: --
575: -- The primary key is invalid therefore we must error
576: --
577: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
578: fnd_message.raise_error;
579: --
580: end if;
581: --
574: --
575: -- The primary key is invalid therefore we must error
576: --
577: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
578: fnd_message.raise_error;
579: --
580: end if;
581: --
582: close csr_leg_code;