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;
180: p_effective_date => p_effective_date) then
181: --
182: -- raise error as does not exist as lookup
183: --
184: fnd_message.set_name('PAY','HR_LOOKUP_MARITAL_STATUS_DOES_NOT_EXIST');
185: fnd_message.raise_error;
186: --
187: end if;
188: --
181: --
182: -- raise error as does not exist as lookup
183: --
184: fnd_message.set_name('PAY','HR_LOOKUP_MARITAL_STATUS_DOES_NOT_EXIST');
185: fnd_message.raise_error;
186: --
187: end if;
188: --
189: end if;
284: --
285: -- An unhandled or unexpected error has occurred which
286: -- we must report
287: --
288: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
289: fnd_message.set_token('PROCEDURE', l_proc);
290: fnd_message.set_token('STEP','15');
291: fnd_message.raise_error;
292: End dt_update_validate;
285: -- An unhandled or unexpected error has occurred which
286: -- we must report
287: --
288: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
289: fnd_message.set_token('PROCEDURE', l_proc);
290: fnd_message.set_token('STEP','15');
291: fnd_message.raise_error;
292: End dt_update_validate;
293: --
286: -- we must report
287: --
288: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
289: fnd_message.set_token('PROCEDURE', l_proc);
290: fnd_message.set_token('STEP','15');
291: fnd_message.raise_error;
292: End dt_update_validate;
293: --
294: -- ----------------------------------------------------------------------------
287: --
288: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
289: fnd_message.set_token('PROCEDURE', l_proc);
290: fnd_message.set_token('STEP','15');
291: fnd_message.raise_error;
292: End dt_update_validate;
293: --
294: -- ----------------------------------------------------------------------------
295: -- |--------------------------< dt_delete_validate >--------------------------|
386: --
387: -- An unhandled or unexpected error has occurred which
388: -- we must report
389: --
390: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
391: fnd_message.set_token('PROCEDURE', l_proc);
392: fnd_message.set_token('STEP','15');
393: fnd_message.raise_error;
394: End dt_delete_validate;
387: -- An unhandled or unexpected error has occurred which
388: -- we must report
389: --
390: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
391: fnd_message.set_token('PROCEDURE', l_proc);
392: fnd_message.set_token('STEP','15');
393: fnd_message.raise_error;
394: End dt_delete_validate;
395: --
388: -- we must report
389: --
390: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
391: fnd_message.set_token('PROCEDURE', l_proc);
392: fnd_message.set_token('STEP','15');
393: fnd_message.raise_error;
394: End dt_delete_validate;
395: --
396: -- ----------------------------------------------------------------------------
389: --
390: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
391: fnd_message.set_token('PROCEDURE', l_proc);
392: fnd_message.set_token('STEP','15');
393: fnd_message.raise_error;
394: End dt_delete_validate;
395: --
396: -- ----------------------------------------------------------------------------
397: -- |---------------------------< insert_validate >----------------------------|
549: close csr_leg_code;
550: --
551: -- The primary key is invalid therefore we must error
552: --
553: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
554: fnd_message.raise_error;
555: --
556: end if;
557: --
550: --
551: -- The primary key is invalid therefore we must error
552: --
553: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
554: fnd_message.raise_error;
555: --
556: end if;
557: --
558: close csr_leg_code;