145: close c1;
146: --
147: -- raise an error as this actl_prem_id has been assigned to rule(s).
148: --
149: fnd_message.set_name('BEN','BEN_91613_VRR_VRP_EXCL2');
150: fnd_message.raise_error;
151: --
152: end if;
153: --
146: --
147: -- raise an error as this actl_prem_id has been assigned to rule(s).
148: --
149: fnd_message.set_name('BEN','BEN_91613_VRR_VRP_EXCL2');
150: fnd_message.raise_error;
151: --
152: end if;
153: --
154: close c1;
207: open c1;
208: fetch c1 into l_dummy;
209: if c1%found then
210: close c1;
211: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
212: fnd_message.raise_error;
213: end if;
214: --
215: hr_utility.set_location('Leaving:'||l_proc, 15);
208: fetch c1 into l_dummy;
209: if c1%found then
210: close c1;
211: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
212: fnd_message.raise_error;
213: end if;
214: --
215: hr_utility.set_location('Leaving:'||l_proc, 15);
216: End chk_ordr_num_unique;
317: --
318: -- An unhandled or unexpected error has occurred which
319: -- we must report
320: --
321: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
322: fnd_message.set_token('PROCEDURE', l_proc);
323: fnd_message.set_token('STEP','15');
324: fnd_message.raise_error;
325: End dt_update_validate;
318: -- An unhandled or unexpected error has occurred which
319: -- we must report
320: --
321: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
322: fnd_message.set_token('PROCEDURE', l_proc);
323: fnd_message.set_token('STEP','15');
324: fnd_message.raise_error;
325: End dt_update_validate;
326: --
319: -- we must report
320: --
321: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
322: fnd_message.set_token('PROCEDURE', l_proc);
323: fnd_message.set_token('STEP','15');
324: fnd_message.raise_error;
325: End dt_update_validate;
326: --
327: -- ----------------------------------------------------------------------------
320: --
321: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
322: fnd_message.set_token('PROCEDURE', l_proc);
323: fnd_message.set_token('STEP','15');
324: fnd_message.raise_error;
325: End dt_update_validate;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |--------------------------< dt_delete_validate >--------------------------|
419: --
420: -- An unhandled or unexpected error has occurred which
421: -- we must report
422: --
423: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
424: fnd_message.set_token('PROCEDURE', l_proc);
425: fnd_message.set_token('STEP','15');
426: fnd_message.raise_error;
427: End dt_delete_validate;
420: -- An unhandled or unexpected error has occurred which
421: -- we must report
422: --
423: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
424: fnd_message.set_token('PROCEDURE', l_proc);
425: fnd_message.set_token('STEP','15');
426: fnd_message.raise_error;
427: End dt_delete_validate;
428: --
421: -- we must report
422: --
423: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
424: fnd_message.set_token('PROCEDURE', l_proc);
425: fnd_message.set_token('STEP','15');
426: fnd_message.raise_error;
427: End dt_delete_validate;
428: --
429: -- ----------------------------------------------------------------------------
422: --
423: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
424: fnd_message.set_token('PROCEDURE', l_proc);
425: fnd_message.set_token('STEP','15');
426: fnd_message.raise_error;
427: End dt_delete_validate;
428: --
429: -- ----------------------------------------------------------------------------
430: -- |---------------------------< insert_validate >----------------------------|
584: close csr_leg_code;
585: --
586: -- The primary key is invalid therefore we must error
587: --
588: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
589: fnd_message.raise_error;
590: --
591: end if;
592: --
585: --
586: -- The primary key is invalid therefore we must error
587: --
588: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
589: fnd_message.raise_error;
590: --
591: end if;
592: --
593: close csr_leg_code;