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;
219: p_effective_date => p_effective_date) then
220: --
221: -- raise error as does not exist as lookup
222: --
223: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
224: fnd_message.raise_error;
225: --
226: end if;
227: --
220: --
221: -- raise error as does not exist as lookup
222: --
223: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
224: fnd_message.raise_error;
225: --
226: end if;
227: --
228: open c3;
231: close c3;
232: --
233: -- raise error as this ctfn row already exists for this beneficiary
234: --
235: fnd_message.set_name('BEN', 'BEN_91655_DUP_BNF_CTFN');
236: fnd_message.raise_error;
237: --
238: end if;
239: close c3;
232: --
233: -- raise error as this ctfn row already exists for this beneficiary
234: --
235: fnd_message.set_name('BEN', 'BEN_91655_DUP_BNF_CTFN');
236: fnd_message.raise_error;
237: --
238: end if;
239: close c3;
240: --
341: --
342: -- A referential integrity check was violated therefore
343: -- we must error
344: --
345: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
346: fnd_message.set_token('TABLE_NAME', l_table_name);
347: fnd_message.raise_error;
348: When Others Then
349: --
342: -- A referential integrity check was violated therefore
343: -- we must error
344: --
345: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
346: fnd_message.set_token('TABLE_NAME', l_table_name);
347: fnd_message.raise_error;
348: When Others Then
349: --
350: -- An unhandled or unexpected error has occurred which
343: -- we must error
344: --
345: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
346: fnd_message.set_token('TABLE_NAME', l_table_name);
347: fnd_message.raise_error;
348: When Others Then
349: --
350: -- An unhandled or unexpected error has occurred which
351: -- we must report
349: --
350: -- An unhandled or unexpected error has occurred which
351: -- we must report
352: --
353: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
354: fnd_message.set_token('PROCEDURE', l_proc);
355: fnd_message.set_token('STEP','15');
356: fnd_message.raise_error;
357: End dt_update_validate;
350: -- An unhandled or unexpected error has occurred which
351: -- we must report
352: --
353: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
354: fnd_message.set_token('PROCEDURE', l_proc);
355: fnd_message.set_token('STEP','15');
356: fnd_message.raise_error;
357: End dt_update_validate;
358: --
351: -- we must report
352: --
353: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
354: fnd_message.set_token('PROCEDURE', l_proc);
355: fnd_message.set_token('STEP','15');
356: fnd_message.raise_error;
357: End dt_update_validate;
358: --
359: -- ----------------------------------------------------------------------------
352: --
353: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
354: fnd_message.set_token('PROCEDURE', l_proc);
355: fnd_message.set_token('STEP','15');
356: fnd_message.raise_error;
357: End dt_update_validate;
358: --
359: -- ----------------------------------------------------------------------------
360: -- |--------------------------< dt_delete_validate >--------------------------|
445: --
446: -- A referential integrity check was violated therefore
447: -- we must error
448: --
449: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
450: fnd_message.set_token('TABLE_NAME', l_table_name);
451: fnd_message.raise_error;
452: When Others Then
453: --
446: -- A referential integrity check was violated therefore
447: -- we must error
448: --
449: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
450: fnd_message.set_token('TABLE_NAME', l_table_name);
451: fnd_message.raise_error;
452: When Others Then
453: --
454: -- An unhandled or unexpected error has occurred which
447: -- we must error
448: --
449: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
450: fnd_message.set_token('TABLE_NAME', l_table_name);
451: fnd_message.raise_error;
452: When Others Then
453: --
454: -- An unhandled or unexpected error has occurred which
455: -- we must report
453: --
454: -- An unhandled or unexpected error has occurred which
455: -- we must report
456: --
457: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
458: fnd_message.set_token('PROCEDURE', l_proc);
459: fnd_message.set_token('STEP','15');
460: fnd_message.raise_error;
461: End dt_delete_validate;
454: -- An unhandled or unexpected error has occurred which
455: -- we must report
456: --
457: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
458: fnd_message.set_token('PROCEDURE', l_proc);
459: fnd_message.set_token('STEP','15');
460: fnd_message.raise_error;
461: End dt_delete_validate;
462: --
455: -- we must report
456: --
457: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
458: fnd_message.set_token('PROCEDURE', l_proc);
459: fnd_message.set_token('STEP','15');
460: fnd_message.raise_error;
461: End dt_delete_validate;
462: --
463: -- ----------------------------------------------------------------------------
456: --
457: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
458: fnd_message.set_token('PROCEDURE', l_proc);
459: fnd_message.set_token('STEP','15');
460: fnd_message.raise_error;
461: End dt_delete_validate;
462: --
463: -- ----------------------------------------------------------------------------
464: -- |---------------------------< insert_validate >----------------------------|
624: close csr_leg_code;
625: --
626: -- The primary key is invalid therefore we must error
627: --
628: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
629: fnd_message.raise_error;
630: --
631: end if;
632: --
625: --
626: -- The primary key is invalid therefore we must error
627: --
628: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
629: fnd_message.raise_error;
630: --
631: end if;
632: --
633: close csr_leg_code;