206: p_effective_date => p_effective_date) then
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
215: end if;
274: p_effective_date => p_effective_date) then
275: --
276: -- raise error as does not exist as lookup
277: --
278: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
279: fnd_message.raise_error;
280: --
281: end if;
282: --
275: --
276: -- raise error as does not exist as lookup
277: --
278: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
279: fnd_message.raise_error;
280: --
281: end if;
282: --
283: end if;
316: p_effective_date => p_effective_date) then
317: --
318: -- raise error as does not exist as lookup
319: --
320: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
321: fnd_message.raise_error;
322: --
323: end if;
324: --
317: --
318: -- raise error as does not exist as lookup
319: --
320: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
321: fnd_message.raise_error;
322: --
323: end if;
324: --
325: end if;
359: p_effective_date => p_effective_date) then
360: --
361: -- raise error as does not exist as lookup
362: --
363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
360: --
361: -- raise error as does not exist as lookup
362: --
363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
368: end if;
534: close csr_leg_code;
535: --
536: -- The primary key is invalid therefore we must error
537: --
538: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
539: fnd_message.raise_error;
540: --
541: end if;
542: --
535: --
536: -- The primary key is invalid therefore we must error
537: --
538: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
539: fnd_message.raise_error;
540: --
541: end if;
542: --
543: close csr_leg_code;