142: --
143: hr_utility.set_location('Entering:'||l_proc, 5);
144: --
145: if p_formula_id is null then
146: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
147: fnd_message.raise_error;
148: end if;
149: --
150: l_api_updating := ben_erl_shd.api_updating
143: hr_utility.set_location('Entering:'||l_proc, 5);
144: --
145: if p_formula_id is null then
146: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
147: fnd_message.raise_error;
148: end if;
149: --
150: l_api_updating := ben_erl_shd.api_updating
151: (p_eligy_prfl_rl_id => p_eligy_prfl_rl_id,
165: fetch c1 into l_dummy;
166: if c1%notfound then
167: close c1;
168: -- raise error
169: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
170: fnd_message.raise_error;
171: end if;
172: close c1;
173: --
166: if c1%notfound then
167: close c1;
168: -- raise error
169: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
170: fnd_message.raise_error;
171: end if;
172: close c1;
173: --
174: --
177: fetch c3 into l_dummy;
178: if c3%found then
179: close c3;
180: -- raise error
181: fnd_message.set_name('BEN','BEN_91018_RULE_NOT_UNIQUE');
182: fnd_message.raise_error;
183: end if;
184: close c3;
185: end if;
178: if c3%found then
179: close c3;
180: -- raise error
181: fnd_message.set_name('BEN','BEN_91018_RULE_NOT_UNIQUE');
182: fnd_message.raise_error;
183: end if;
184: close c3;
185: end if;
186: --
272: fetch l_csr_rl into l_db_rl_row;
273: if l_csr_rl%found then
274: close l_csr_rl;
275: --
276: fnd_message.set_name('BEN', 'BEN_91001_SEQ_NOT_UNIQUE');
277: fnd_message.raise_error;
278: end if;
279: close l_csr_rl;
280:
273: if l_csr_rl%found then
274: close l_csr_rl;
275: --
276: fnd_message.set_name('BEN', 'BEN_91001_SEQ_NOT_UNIQUE');
277: fnd_message.raise_error;
278: end if;
279: close l_csr_rl;
280:
281: end if;
389: --
390: -- An unhandled or unexpected error has occurred which
391: -- we must report
392: --
393: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
394: fnd_message.set_token('PROCEDURE', l_proc);
395: fnd_message.set_token('STEP','15');
396: fnd_message.raise_error;
397: End dt_update_validate;
390: -- An unhandled or unexpected error has occurred which
391: -- we must report
392: --
393: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
394: fnd_message.set_token('PROCEDURE', l_proc);
395: fnd_message.set_token('STEP','15');
396: fnd_message.raise_error;
397: End dt_update_validate;
398: --
391: -- we must report
392: --
393: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
394: fnd_message.set_token('PROCEDURE', l_proc);
395: fnd_message.set_token('STEP','15');
396: fnd_message.raise_error;
397: End dt_update_validate;
398: --
399: -- ----------------------------------------------------------------------------
392: --
393: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
394: fnd_message.set_token('PROCEDURE', l_proc);
395: fnd_message.set_token('STEP','15');
396: fnd_message.raise_error;
397: End dt_update_validate;
398: --
399: -- ----------------------------------------------------------------------------
400: -- |--------------------------< dt_delete_validate >--------------------------|
500: --
501: -- An unhandled or unexpected error has occurred which
502: -- we must report
503: --
504: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
505: fnd_message.set_token('PROCEDURE', l_proc);
506: fnd_message.set_token('STEP','15');
507: fnd_message.raise_error;
508: End dt_delete_validate;
501: -- An unhandled or unexpected error has occurred which
502: -- we must report
503: --
504: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
505: fnd_message.set_token('PROCEDURE', l_proc);
506: fnd_message.set_token('STEP','15');
507: fnd_message.raise_error;
508: End dt_delete_validate;
509: --
502: -- we must report
503: --
504: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
505: fnd_message.set_token('PROCEDURE', l_proc);
506: fnd_message.set_token('STEP','15');
507: fnd_message.raise_error;
508: End dt_delete_validate;
509: --
510: -- ----------------------------------------------------------------------------
503: --
504: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
505: fnd_message.set_token('PROCEDURE', l_proc);
506: fnd_message.set_token('STEP','15');
507: fnd_message.raise_error;
508: End dt_delete_validate;
509: --
510: -- ----------------------------------------------------------------------------
511: -- |---------------------------< insert_validate >----------------------------|
683: close csr_leg_code;
684: --
685: -- The primary key is invalid therefore we must error
686: --
687: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
688: fnd_message.raise_error;
689: --
690: end if;
691: --
684: --
685: -- The primary key is invalid therefore we must error
686: --
687: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
688: fnd_message.raise_error;
689: --
690: end if;
691: --
692: close csr_leg_code;