112: fetch c_abp into l_dummy_var ;
113: if c_abp%found then
114: hr_utility.set_location('dupes:'||l_proc, 5);
115: close c_abp ;
116: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
117: fnd_message.set_token('VAR1', 'Application');
118: fnd_message.set_token('VAR2','Benefit Pool');
119: fnd_message.raise_error;
120: end if ;
113: if c_abp%found then
114: hr_utility.set_location('dupes:'||l_proc, 5);
115: close c_abp ;
116: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
117: fnd_message.set_token('VAR1', 'Application');
118: fnd_message.set_token('VAR2','Benefit Pool');
119: fnd_message.raise_error;
120: end if ;
121: close c_abp ;
114: hr_utility.set_location('dupes:'||l_proc, 5);
115: close c_abp ;
116: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
117: fnd_message.set_token('VAR1', 'Application');
118: fnd_message.set_token('VAR2','Benefit Pool');
119: fnd_message.raise_error;
120: end if ;
121: close c_abp ;
122:
115: close c_abp ;
116: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
117: fnd_message.set_token('VAR1', 'Application');
118: fnd_message.set_token('VAR2','Benefit Pool');
119: fnd_message.raise_error;
120: end if ;
121: close c_abp ;
122:
123: hr_utility.set_location('Leaving:'||l_proc, 10);
229: --
230: -- An unhandled or unexpected error has occurred which
231: -- we must report
232: --
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','15');
236: fnd_message.raise_error;
237: End dt_update_validate;
230: -- An unhandled or unexpected error has occurred which
231: -- we must report
232: --
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','15');
236: fnd_message.raise_error;
237: End dt_update_validate;
238: --
231: -- we must report
232: --
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','15');
236: fnd_message.raise_error;
237: End dt_update_validate;
238: --
239: -- ----------------------------------------------------------------------------
232: --
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','15');
236: fnd_message.raise_error;
237: End dt_update_validate;
238: --
239: -- ----------------------------------------------------------------------------
240: -- |--------------------------< dt_delete_validate >--------------------------|
332: --
333: -- An unhandled or unexpected error has occurred which
334: -- we must report
335: --
336: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
337: fnd_message.set_token('PROCEDURE', l_proc);
338: fnd_message.set_token('STEP','15');
339: fnd_message.raise_error;
340: End dt_delete_validate;
333: -- An unhandled or unexpected error has occurred which
334: -- we must report
335: --
336: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
337: fnd_message.set_token('PROCEDURE', l_proc);
338: fnd_message.set_token('STEP','15');
339: fnd_message.raise_error;
340: End dt_delete_validate;
341: --
334: -- we must report
335: --
336: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
337: fnd_message.set_token('PROCEDURE', l_proc);
338: fnd_message.set_token('STEP','15');
339: fnd_message.raise_error;
340: End dt_delete_validate;
341: --
342: -- ----------------------------------------------------------------------------
335: --
336: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
337: fnd_message.set_token('PROCEDURE', l_proc);
338: fnd_message.set_token('STEP','15');
339: fnd_message.raise_error;
340: End dt_delete_validate;
341: --
342: -- ----------------------------------------------------------------------------
343: -- |---------------------------< insert_validate >----------------------------|
487: close csr_leg_code;
488: --
489: -- The primary key is invalid therefore we must error
490: --
491: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
492: fnd_message.raise_error;
493: --
494: end if;
495: --
488: --
489: -- The primary key is invalid therefore we must error
490: --
491: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
492: fnd_message.raise_error;
493: --
494: end if;
495: --
496: close csr_leg_code;