134: p_effective_date => p_effective_date) then
135: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
139: fnd_message.raise_error;
140: --
141: end if;
142: --
135: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
139: fnd_message.raise_error;
140: --
141: end if;
142: --
143: end if;
185: if psps%notfound then
186: close psps ;
187: -- raise error as does not exist as lookup
188: --
189: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
190: fnd_message.raise_error;
191: end if ;
192: close psps ;
193: --
186: close psps ;
187: -- raise error as does not exist as lookup
188: --
189: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
190: fnd_message.raise_error;
191: end if ;
192: close psps ;
193: --
194: --
301: --
302: -- An unhandled or unexpected error has occurred which
303: -- we must report
304: --
305: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
306: fnd_message.set_token('PROCEDURE', l_proc);
307: fnd_message.set_token('STEP','15');
308: fnd_message.raise_error;
309: End dt_update_validate;
302: -- An unhandled or unexpected error has occurred which
303: -- we must report
304: --
305: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
306: fnd_message.set_token('PROCEDURE', l_proc);
307: fnd_message.set_token('STEP','15');
308: fnd_message.raise_error;
309: End dt_update_validate;
310: --
303: -- we must report
304: --
305: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
306: fnd_message.set_token('PROCEDURE', l_proc);
307: fnd_message.set_token('STEP','15');
308: fnd_message.raise_error;
309: End dt_update_validate;
310: --
311: -- ----------------------------------------------------------------------------
304: --
305: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
306: fnd_message.set_token('PROCEDURE', l_proc);
307: fnd_message.set_token('STEP','15');
308: fnd_message.raise_error;
309: End dt_update_validate;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |--------------------------< dt_delete_validate >--------------------------|
403: --
404: -- An unhandled or unexpected error has occurred which
405: -- we must report
406: --
407: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE', l_proc);
409: fnd_message.set_token('STEP','15');
410: fnd_message.raise_error;
411: End dt_delete_validate;
404: -- An unhandled or unexpected error has occurred which
405: -- we must report
406: --
407: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE', l_proc);
409: fnd_message.set_token('STEP','15');
410: fnd_message.raise_error;
411: End dt_delete_validate;
412: --
405: -- we must report
406: --
407: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE', l_proc);
409: fnd_message.set_token('STEP','15');
410: fnd_message.raise_error;
411: End dt_delete_validate;
412: --
413: -- ----------------------------------------------------------------------------
406: --
407: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE', l_proc);
409: fnd_message.set_token('STEP','15');
410: fnd_message.raise_error;
411: End dt_delete_validate;
412: --
413: -- ----------------------------------------------------------------------------
414: -- |---------------------------< insert_validate >----------------------------|
565: close csr_leg_code;
566: --
567: -- The primary key is invalid therefore we must error
568: --
569: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
570: fnd_message.raise_error;
571: --
572: end if;
573: --
566: --
567: -- The primary key is invalid therefore we must error
568: --
569: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
570: fnd_message.raise_error;
571: --
572: end if;
573: --
574: close csr_leg_code;