139: --
140: -- raise error as does not exist as lookup
141: --
142: close c1;
143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
144: fnd_message.set_token('FIELD', 'std_prem_uom '||p_std_prem_uom );
145: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
146: fnd_message.raise_error;
147: end if;
140: -- raise error as does not exist as lookup
141: --
142: close c1;
143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
144: fnd_message.set_token('FIELD', 'std_prem_uom '||p_std_prem_uom );
145: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
146: fnd_message.raise_error;
147: end if;
148: close c1;
141: --
142: close c1;
143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
144: fnd_message.set_token('FIELD', 'std_prem_uom '||p_std_prem_uom );
145: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
146: fnd_message.raise_error;
147: end if;
148: close c1;
149: --
142: close c1;
143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
144: fnd_message.set_token('FIELD', 'std_prem_uom '||p_std_prem_uom );
145: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
146: fnd_message.raise_error;
147: end if;
148: close c1;
149: --
150: end if;
148: close c1;
149: --
150: end if;
151: if p_std_prem_uom is null then
152: fnd_message.set_name('BEN','BEN_92237_UOM_REQUIRED');
153: fnd_message.raise_error;
154: end if;
155: --
156: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: end if;
151: if p_std_prem_uom is null then
152: fnd_message.set_name('BEN','BEN_92237_UOM_REQUIRED');
153: fnd_message.raise_error;
154: end if;
155: --
156: hr_utility.set_location('Leaving:'||l_proc,10);
157: --
266: --
267: -- An unhandled or unexpected error has occurred which
268: -- we must report
269: --
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
271: fnd_message.set_token('PROCEDURE', l_proc);
272: fnd_message.set_token('STEP','15');
273: fnd_message.raise_error;
274: End dt_update_validate;
267: -- An unhandled or unexpected error has occurred which
268: -- we must report
269: --
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
271: fnd_message.set_token('PROCEDURE', l_proc);
272: fnd_message.set_token('STEP','15');
273: fnd_message.raise_error;
274: End dt_update_validate;
275: --
268: -- we must report
269: --
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
271: fnd_message.set_token('PROCEDURE', l_proc);
272: fnd_message.set_token('STEP','15');
273: fnd_message.raise_error;
274: End dt_update_validate;
275: --
276: -- ----------------------------------------------------------------------------
269: --
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
271: fnd_message.set_token('PROCEDURE', l_proc);
272: fnd_message.set_token('STEP','15');
273: fnd_message.raise_error;
274: End dt_update_validate;
275: --
276: -- ----------------------------------------------------------------------------
277: -- |--------------------------< dt_delete_validate >--------------------------|
368: --
369: -- An unhandled or unexpected error has occurred which
370: -- we must report
371: --
372: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
373: fnd_message.set_token('PROCEDURE', l_proc);
374: fnd_message.set_token('STEP','15');
375: fnd_message.raise_error;
376: End dt_delete_validate;
369: -- An unhandled or unexpected error has occurred which
370: -- we must report
371: --
372: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
373: fnd_message.set_token('PROCEDURE', l_proc);
374: fnd_message.set_token('STEP','15');
375: fnd_message.raise_error;
376: End dt_delete_validate;
377: --
370: -- we must report
371: --
372: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
373: fnd_message.set_token('PROCEDURE', l_proc);
374: fnd_message.set_token('STEP','15');
375: fnd_message.raise_error;
376: End dt_delete_validate;
377: --
378: -- ----------------------------------------------------------------------------
371: --
372: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
373: fnd_message.set_token('PROCEDURE', l_proc);
374: fnd_message.set_token('STEP','15');
375: fnd_message.raise_error;
376: End dt_delete_validate;
377: --
378: -- ----------------------------------------------------------------------------
379: -- |---------------------------< insert_validate >----------------------------|
535: close csr_leg_code;
536: --
537: -- The primary key is invalid therefore we must error
538: --
539: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
540: fnd_message.raise_error;
541: --
542: end if;
543: --
536: --
537: -- The primary key is invalid therefore we must error
538: --
539: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
540: fnd_message.raise_error;
541: --
542: end if;
543: --
544: close csr_leg_code;