129: p_effective_date => p_effective_date) then
130: --
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
134: fnd_message.raise_error;
135: --
136: end if;
137: --
130: --
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
134: fnd_message.raise_error;
135: --
136: end if;
137: --
138: end if;
197: p_effective_date => p_effective_date) then
198: --
199: -- raise error as does not exist as lookup
200: --
201: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
202: fnd_message.raise_error;
203: --
204: end if;
205: --
198: --
199: -- raise error as does not exist as lookup
200: --
201: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
202: fnd_message.raise_error;
203: --
204: end if;
205: --
206: end if;
336: close csr_leg_code;
337: --
338: -- The primary key is invalid therefore we must error
339: --
340: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
341: fnd_message.raise_error;
342: --
343: end if;
344: --
337: --
338: -- The primary key is invalid therefore we must error
339: --
340: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
341: fnd_message.raise_error;
342: --
343: end if;
344: --
345: close csr_leg_code;