176: close c3;
177: --
178: -- raise error as this criteria already exists for this profile
179: --
180: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
181: fnd_message.raise_error;
182: --
183: end if;
184: close c3;
177: --
178: -- raise error as this criteria already exists for this profile
179: --
180: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
181: fnd_message.raise_error;
182: --
183: end if;
184: close c3;
185: --
247: p_effective_date => p_effective_date) then
248: --
249: -- raise error as does not exist as lookup
250: --
251: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
252: fnd_message.raise_error;
253: --
254: end if;
255: --
248: --
249: -- raise error as does not exist as lookup
250: --
251: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
252: fnd_message.raise_error;
253: --
254: end if;
255: --
256: end if;
309: open c1;
310: fetch c1 into l_dummy;
311: if c1%found then
312: close c1;
313: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
314: fnd_message.raise_error;
315: end if;
316: close c1;
317: --
310: fetch c1 into l_dummy;
311: if c1%found then
312: close c1;
313: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
314: fnd_message.raise_error;
315: end if;
316: close c1;
317: --
318: hr_utility.set_location('Leaving:'||l_proc, 15);
402: --
403: -- A referential integrity check was violated therefore
404: -- we must error
405: --
406: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
407: fnd_message.set_token('TABLE_NAME', l_table_name);
408: fnd_message.raise_error;
409: When Others Then
410: --
403: -- A referential integrity check was violated therefore
404: -- we must error
405: --
406: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
407: fnd_message.set_token('TABLE_NAME', l_table_name);
408: fnd_message.raise_error;
409: When Others Then
410: --
411: -- An unhandled or unexpected error has occurred which
404: -- we must error
405: --
406: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
407: fnd_message.set_token('TABLE_NAME', l_table_name);
408: fnd_message.raise_error;
409: When Others Then
410: --
411: -- An unhandled or unexpected error has occurred which
412: -- we must report
410: --
411: -- An unhandled or unexpected error has occurred which
412: -- we must report
413: --
414: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
415: fnd_message.set_token('PROCEDURE', l_proc);
416: fnd_message.set_token('STEP','15');
417: fnd_message.raise_error;
418: End dt_update_validate;
411: -- An unhandled or unexpected error has occurred which
412: -- we must report
413: --
414: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
415: fnd_message.set_token('PROCEDURE', l_proc);
416: fnd_message.set_token('STEP','15');
417: fnd_message.raise_error;
418: End dt_update_validate;
419: --
412: -- we must report
413: --
414: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
415: fnd_message.set_token('PROCEDURE', l_proc);
416: fnd_message.set_token('STEP','15');
417: fnd_message.raise_error;
418: End dt_update_validate;
419: --
420: -- ----------------------------------------------------------------------------
413: --
414: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
415: fnd_message.set_token('PROCEDURE', l_proc);
416: fnd_message.set_token('STEP','15');
417: fnd_message.raise_error;
418: End dt_update_validate;
419: --
420: -- ----------------------------------------------------------------------------
421: -- |--------------------------< dt_delete_validate >--------------------------|
506: --
507: -- A referential integrity check was violated therefore
508: -- we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
511: fnd_message.set_token('TABLE_NAME', l_table_name);
512: fnd_message.raise_error;
513: When Others Then
514: --
507: -- A referential integrity check was violated therefore
508: -- we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
511: fnd_message.set_token('TABLE_NAME', l_table_name);
512: fnd_message.raise_error;
513: When Others Then
514: --
515: -- An unhandled or unexpected error has occurred which
508: -- we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
511: fnd_message.set_token('TABLE_NAME', l_table_name);
512: fnd_message.raise_error;
513: When Others Then
514: --
515: -- An unhandled or unexpected error has occurred which
516: -- we must report
514: --
515: -- An unhandled or unexpected error has occurred which
516: -- we must report
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','15');
521: fnd_message.raise_error;
522: End dt_delete_validate;
515: -- An unhandled or unexpected error has occurred which
516: -- we must report
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','15');
521: fnd_message.raise_error;
522: End dt_delete_validate;
523: --
516: -- we must report
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','15');
521: fnd_message.raise_error;
522: End dt_delete_validate;
523: --
524: -- ----------------------------------------------------------------------------
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','15');
521: fnd_message.raise_error;
522: End dt_delete_validate;
523: --
524: -- ----------------------------------------------------------------------------
525: -- |---------------------------< insert_validate >----------------------------|
696: close csr_leg_code;
697: --
698: -- The primary key is invalid therefore we must error
699: --
700: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
701: fnd_message.raise_error;
702: --
703: end if;
704: --
697: --
698: -- The primary key is invalid therefore we must error
699: --
700: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
701: fnd_message.raise_error;
702: --
703: end if;
704: --
705: close csr_leg_code;