90: hr_utility.set_location('Entering:'||l_proc, 5);
91: --
92: if p_pl_id is null then
93: --
94: fnd_message.set_name('BEN','BEN_93975_PL_OR_OIPL_NOT_BOTH');
95: fnd_message.raise_error;
96: --
97: end if;
98: --
91: --
92: if p_pl_id is null then
93: --
94: fnd_message.set_name('BEN','BEN_93975_PL_OR_OIPL_NOT_BOTH');
95: fnd_message.raise_error;
96: --
97: end if;
98: --
99: if p_plip_id is not null and p_oipl_id is not null then
97: end if;
98: --
99: if p_plip_id is not null and p_oipl_id is not null then
100: --
101: fnd_message.set_name('BEN','BEN_93975_PL_OR_OIPL_NOT_BOTH');
102: fnd_message.raise_error;
103: --
104: end if;
105: --
98: --
99: if p_plip_id is not null and p_oipl_id is not null then
100: --
101: fnd_message.set_name('BEN','BEN_93975_PL_OR_OIPL_NOT_BOTH');
102: fnd_message.raise_error;
103: --
104: end if;
105: --
106: hr_utility.set_location('Leaving:'||l_proc, 10);
168: fetch c1 into l_dummy;
169: if c1%found then
170: --
171: close c1;
172: fnd_message.set_name('BEN','BEN_93976_EXTRACT_CRIT_EXISTS');
173: fnd_message.raise_error;
174: --
175: end if;
176: close c1;
169: if c1%found then
170: --
171: close c1;
172: fnd_message.set_name('BEN','BEN_93976_EXTRACT_CRIT_EXISTS');
173: fnd_message.raise_error;
174: --
175: end if;
176: close c1;
177: --
237: p_effective_date => p_effective_date) then
238: --
239: -- raise error as does not exist as lookup
240: --
241: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
242: fnd_message.set_token('VALUE', p_home_state);
243: fnd_message.set_token('FIELD', 'Home State');
244: fnd_message.set_token('TYPE', 'US_STATE');
245: fnd_message.raise_error;
238: --
239: -- raise error as does not exist as lookup
240: --
241: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
242: fnd_message.set_token('VALUE', p_home_state);
243: fnd_message.set_token('FIELD', 'Home State');
244: fnd_message.set_token('TYPE', 'US_STATE');
245: fnd_message.raise_error;
246: --
239: -- raise error as does not exist as lookup
240: --
241: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
242: fnd_message.set_token('VALUE', p_home_state);
243: fnd_message.set_token('FIELD', 'Home State');
244: fnd_message.set_token('TYPE', 'US_STATE');
245: fnd_message.raise_error;
246: --
247: end if;
240: --
241: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
242: fnd_message.set_token('VALUE', p_home_state);
243: fnd_message.set_token('FIELD', 'Home State');
244: fnd_message.set_token('TYPE', 'US_STATE');
245: fnd_message.raise_error;
246: --
247: end if;
248: --
241: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
242: fnd_message.set_token('VALUE', p_home_state);
243: fnd_message.set_token('FIELD', 'Home State');
244: fnd_message.set_token('TYPE', 'US_STATE');
245: fnd_message.raise_error;
246: --
247: end if;
248: --
249: end if;
366: --
367: -- An unhandled or unexpected error has occurred which
368: -- we must report
369: --
370: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
371: fnd_message.set_token('PROCEDURE', l_proc);
372: fnd_message.set_token('STEP','15');
373: fnd_message.raise_error;
374: End dt_update_validate;
367: -- An unhandled or unexpected error has occurred which
368: -- we must report
369: --
370: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
371: fnd_message.set_token('PROCEDURE', l_proc);
372: fnd_message.set_token('STEP','15');
373: fnd_message.raise_error;
374: End dt_update_validate;
375: --
368: -- we must report
369: --
370: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
371: fnd_message.set_token('PROCEDURE', l_proc);
372: fnd_message.set_token('STEP','15');
373: fnd_message.raise_error;
374: End dt_update_validate;
375: --
376: -- ----------------------------------------------------------------------------
369: --
370: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
371: fnd_message.set_token('PROCEDURE', l_proc);
372: fnd_message.set_token('STEP','15');
373: fnd_message.raise_error;
374: End dt_update_validate;
375: --
376: -- ----------------------------------------------------------------------------
377: -- |--------------------------< dt_delete_validate >--------------------------|
467: --
468: -- An unhandled or unexpected error has occurred which
469: -- we must report
470: --
471: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
472: fnd_message.set_token('PROCEDURE', l_proc);
473: fnd_message.set_token('STEP','15');
474: fnd_message.raise_error;
475: End dt_delete_validate;
468: -- An unhandled or unexpected error has occurred which
469: -- we must report
470: --
471: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
472: fnd_message.set_token('PROCEDURE', l_proc);
473: fnd_message.set_token('STEP','15');
474: fnd_message.raise_error;
475: End dt_delete_validate;
476: --
469: -- we must report
470: --
471: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
472: fnd_message.set_token('PROCEDURE', l_proc);
473: fnd_message.set_token('STEP','15');
474: fnd_message.raise_error;
475: End dt_delete_validate;
476: --
477: -- ----------------------------------------------------------------------------
470: --
471: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
472: fnd_message.set_token('PROCEDURE', l_proc);
473: fnd_message.set_token('STEP','15');
474: fnd_message.raise_error;
475: End dt_delete_validate;
476: --
477: -- ----------------------------------------------------------------------------
478: -- |---------------------------< insert_validate >----------------------------|
642: close csr_leg_code;
643: --
644: -- The primary key is invalid therefore we must error
645: --
646: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
647: fnd_message.raise_error;
648: --
649: end if;
650: --
643: --
644: -- The primary key is invalid therefore we must error
645: --
646: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
647: fnd_message.raise_error;
648: --
649: end if;
650: --
651: close csr_leg_code;