133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91197_INVLD_PYMT_SCHED_CD');
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('BEN','BEN_91197_INVLD_PYMT_SCHED_CD');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;
224: close c1;
225: --
226: -- raise error
227: --
228: fnd_message.set_name('BEN','BEN_91198_INVLD_PYMT_SCHED_RL');
229: fnd_message.raise_error;
230: --
231: end if;
232: --
225: --
226: -- raise error
227: --
228: fnd_message.set_name('BEN','BEN_91198_INVLD_PYMT_SCHED_RL');
229: fnd_message.raise_error;
230: --
231: end if;
232: --
233: close c1;
386: --
387: -- A referential integrity check was violated therefore
388: -- we must error
389: --
390: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
391: -- fnd_message.set_token('TABLE_NAME', l_table_name);
392: -- fnd_message.raise_error;
393: ben_utility.parent_integrity_error(p_table_name => l_table_name);
394: When Others Then
387: -- A referential integrity check was violated therefore
388: -- we must error
389: --
390: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
391: -- fnd_message.set_token('TABLE_NAME', l_table_name);
392: -- fnd_message.raise_error;
393: ben_utility.parent_integrity_error(p_table_name => l_table_name);
394: When Others Then
395: --
388: -- we must error
389: --
390: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
391: -- fnd_message.set_token('TABLE_NAME', l_table_name);
392: -- fnd_message.raise_error;
393: ben_utility.parent_integrity_error(p_table_name => l_table_name);
394: When Others Then
395: --
396: -- An unhandled or unexpected error has occurred which
395: --
396: -- An unhandled or unexpected error has occurred which
397: -- we must report
398: --
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
400: fnd_message.set_token('PROCEDURE', l_proc);
401: fnd_message.set_token('STEP','15');
402: fnd_message.raise_error;
403: End dt_update_validate;
396: -- An unhandled or unexpected error has occurred which
397: -- we must report
398: --
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
400: fnd_message.set_token('PROCEDURE', l_proc);
401: fnd_message.set_token('STEP','15');
402: fnd_message.raise_error;
403: End dt_update_validate;
404: --
397: -- we must report
398: --
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
400: fnd_message.set_token('PROCEDURE', l_proc);
401: fnd_message.set_token('STEP','15');
402: fnd_message.raise_error;
403: End dt_update_validate;
404: --
405: -- ----------------------------------------------------------------------------
398: --
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
400: fnd_message.set_token('PROCEDURE', l_proc);
401: fnd_message.set_token('STEP','15');
402: fnd_message.raise_error;
403: End dt_update_validate;
404: --
405: -- ----------------------------------------------------------------------------
406: -- |--------------------------< dt_delete_validate >--------------------------|
495: --
496: -- A referential integrity check was violated therefore
497: -- we must error
498: --
499: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
500: fnd_message.set_token('TABLE_NAME', l_table_name);
501: fnd_message.raise_error; */
502: ben_utility.child_exists_error(p_table_name => l_table_name);
503: When Others Then
496: -- A referential integrity check was violated therefore
497: -- we must error
498: --
499: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
500: fnd_message.set_token('TABLE_NAME', l_table_name);
501: fnd_message.raise_error; */
502: ben_utility.child_exists_error(p_table_name => l_table_name);
503: When Others Then
504: --
497: -- we must error
498: --
499: /* fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
500: fnd_message.set_token('TABLE_NAME', l_table_name);
501: fnd_message.raise_error; */
502: ben_utility.child_exists_error(p_table_name => l_table_name);
503: When Others Then
504: --
505: -- An unhandled or unexpected error has occurred which
504: --
505: -- An unhandled or unexpected error has occurred which
506: -- we must report
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
505: -- An unhandled or unexpected error has occurred which
506: -- we must report
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
513: --
506: -- we must report
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
513: --
514: -- ----------------------------------------------------------------------------
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
513: --
514: -- ----------------------------------------------------------------------------
515: -- |---------------------------< insert_validate >----------------------------|
668: close csr_leg_code;
669: --
670: -- The primary key is invalid therefore we must error
671: --
672: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
673: fnd_message.raise_error;
674: --
675: end if;
676: --
669: --
670: -- The primary key is invalid therefore we must error
671: --
672: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
673: fnd_message.raise_error;
674: --
675: end if;
676: --
677: close csr_leg_code;