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_91006_INVALID_FLAG');
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_91006_INVALID_FLAG');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;
216: hr_utility.set_location(l_proc, 7);
217: --
218: -- raise error as duplicate criteria has been entered
219: --
220: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
221: fnd_message.raise_error;
222: --
223: end if;
224: --
217: --
218: -- raise error as duplicate criteria has been entered
219: --
220: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
221: fnd_message.raise_error;
222: --
223: end if;
224: --
225: close c_elig_svc_area_prte;
280: open c1;
281: fetch c1 into l_dummy;
282: if c1%found then
283: close c1;
284: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
285: fnd_message.raise_error;
286: end if;
287: close c1;
288: --
281: fetch c1 into l_dummy;
282: if c1%found then
283: close c1;
284: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
285: fnd_message.raise_error;
286: end if;
287: close c1;
288: --
289: hr_utility.set_location('Leaving:'||l_proc, 15);
393: --
394: -- An unhandled or unexpected error has occurred which
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
394: -- An unhandled or unexpected error has occurred which
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
403: -- ----------------------------------------------------------------------------
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
403: -- ----------------------------------------------------------------------------
404: -- |--------------------------< dt_delete_validate >--------------------------|
496: --
497: -- An unhandled or unexpected error has occurred which
498: -- we must report
499: --
500: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
501: fnd_message.set_token('PROCEDURE', l_proc);
502: fnd_message.set_token('STEP','15');
503: fnd_message.raise_error;
504: End dt_delete_validate;
497: -- An unhandled or unexpected error has occurred which
498: -- we must report
499: --
500: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
501: fnd_message.set_token('PROCEDURE', l_proc);
502: fnd_message.set_token('STEP','15');
503: fnd_message.raise_error;
504: End dt_delete_validate;
505: --
498: -- we must report
499: --
500: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
501: fnd_message.set_token('PROCEDURE', l_proc);
502: fnd_message.set_token('STEP','15');
503: fnd_message.raise_error;
504: End dt_delete_validate;
505: --
506: -- ----------------------------------------------------------------------------
499: --
500: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
501: fnd_message.set_token('PROCEDURE', l_proc);
502: fnd_message.set_token('STEP','15');
503: fnd_message.raise_error;
504: End dt_delete_validate;
505: --
506: -- ----------------------------------------------------------------------------
507: -- |---------------------------< insert_validate >----------------------------|
681: close csr_leg_code;
682: --
683: -- The primary key is invalid therefore we must error
684: --
685: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
686: fnd_message.raise_error;
687: --
688: end if;
689: --
682: --
683: -- The primary key is invalid therefore we must error
684: --
685: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
686: fnd_message.raise_error;
687: --
688: end if;
689: --
690: close csr_leg_code;