150: --
151: -- raise error as this Dependent Eligible for Another Plan Type in Program
152: -- criteria already exists for this profile
153: --
154: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
155: fnd_message.set_token('VAR1','Dependent Eligible for Another Plan Type in Program criteria',TRUE);
156: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
157: fnd_message.raise_error;
158: --
151: -- raise error as this Dependent Eligible for Another Plan Type in Program
152: -- criteria already exists for this profile
153: --
154: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
155: fnd_message.set_token('VAR1','Dependent Eligible for Another Plan Type in Program criteria',TRUE);
156: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
157: fnd_message.raise_error;
158: --
159: end if;
152: -- criteria already exists for this profile
153: --
154: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
155: fnd_message.set_token('VAR1','Dependent Eligible for Another Plan Type in Program criteria',TRUE);
156: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
157: fnd_message.raise_error;
158: --
159: end if;
160: close c_dup;
153: --
154: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
155: fnd_message.set_token('VAR1','Dependent Eligible for Another Plan Type in Program criteria',TRUE);
156: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
157: fnd_message.raise_error;
158: --
159: end if;
160: close c_dup;
161: --
222: p_effective_date => p_effective_date) then
223: --
224: -- raise error as does not exist as lookup
225: --
226: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
227: fnd_message.raise_error;
228: --
229: end if;
230: --
223: --
224: -- raise error as does not exist as lookup
225: --
226: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
227: fnd_message.raise_error;
228: --
229: end if;
230: --
231: end if;
293: open c1;
294: fetch c1 into l_dummy;
295: --
296: if c1%found then
297: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
294: fetch c1 into l_dummy;
295: --
296: if c1%found then
297: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
302: hr_utility.set_location('Leaving:'||l_proc, 15);
408: --
409: -- An unhandled or unexpected error has occurred which
410: -- we must report
411: --
412: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
413: fnd_message.set_token('PROCEDURE', l_proc);
414: fnd_message.set_token('STEP','15');
415: fnd_message.raise_error;
416: End dt_update_validate;
409: -- An unhandled or unexpected error has occurred which
410: -- we must report
411: --
412: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
413: fnd_message.set_token('PROCEDURE', l_proc);
414: fnd_message.set_token('STEP','15');
415: fnd_message.raise_error;
416: End dt_update_validate;
417: --
410: -- we must report
411: --
412: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
413: fnd_message.set_token('PROCEDURE', l_proc);
414: fnd_message.set_token('STEP','15');
415: fnd_message.raise_error;
416: End dt_update_validate;
417: --
418: -- ----------------------------------------------------------------------------
411: --
412: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
413: fnd_message.set_token('PROCEDURE', l_proc);
414: fnd_message.set_token('STEP','15');
415: fnd_message.raise_error;
416: End dt_update_validate;
417: --
418: -- ----------------------------------------------------------------------------
419: -- |--------------------------< dt_delete_validate >--------------------------|
510: --
511: -- An unhandled or unexpected error has occurred which
512: -- we must report
513: --
514: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
515: fnd_message.set_token('PROCEDURE', l_proc);
516: fnd_message.set_token('STEP','15');
517: fnd_message.raise_error;
518: End dt_delete_validate;
511: -- An unhandled or unexpected error has occurred which
512: -- we must report
513: --
514: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
515: fnd_message.set_token('PROCEDURE', l_proc);
516: fnd_message.set_token('STEP','15');
517: fnd_message.raise_error;
518: End dt_delete_validate;
519: --
512: -- we must report
513: --
514: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
515: fnd_message.set_token('PROCEDURE', l_proc);
516: fnd_message.set_token('STEP','15');
517: fnd_message.raise_error;
518: End dt_delete_validate;
519: --
520: -- ----------------------------------------------------------------------------
513: --
514: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
515: fnd_message.set_token('PROCEDURE', l_proc);
516: fnd_message.set_token('STEP','15');
517: fnd_message.raise_error;
518: End dt_delete_validate;
519: --
520: -- ----------------------------------------------------------------------------
521: -- |---------------------------< insert_validate >----------------------------|
700: close csr_leg_code;
701: --
702: -- The primary key is invalid therefore we must error
703: --
704: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
705: fnd_message.raise_error;
706: --
707: end if;
708: --
701: --
702: -- The primary key is invalid therefore we must error
703: --
704: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
705: fnd_message.raise_error;
706: --
707: end if;
708: --
709: close csr_leg_code;