68: close csr_leg_code;
69: --
70: -- The primary key is invalid therefore we must error
71: --
72: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
73: fnd_message.raise_error;
74: --
75: end if;
76: --
69: --
70: -- The primary key is invalid therefore we must error
71: --
72: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
73: fnd_message.raise_error;
74: --
75: end if;
76: --
77: close csr_leg_code;
280: p_effective_date => p_effective_date) then
281: --
282: -- raise error as does not exist as lookup
283: --
284: fnd_message.set_name('BEN','BEN_91438_LOOKUP_VALUE_INVALID');
285: fnd_message.set_token('FIELD','ACTION_STATUS_CD');
286: fnd_message.set_token('TYPE','BEN_ACTN_STAT');
287: fnd_message.raise_error;
288: --
281: --
282: -- raise error as does not exist as lookup
283: --
284: fnd_message.set_name('BEN','BEN_91438_LOOKUP_VALUE_INVALID');
285: fnd_message.set_token('FIELD','ACTION_STATUS_CD');
286: fnd_message.set_token('TYPE','BEN_ACTN_STAT');
287: fnd_message.raise_error;
288: --
289: end if;
282: -- raise error as does not exist as lookup
283: --
284: fnd_message.set_name('BEN','BEN_91438_LOOKUP_VALUE_INVALID');
285: fnd_message.set_token('FIELD','ACTION_STATUS_CD');
286: fnd_message.set_token('TYPE','BEN_ACTN_STAT');
287: fnd_message.raise_error;
288: --
289: end if;
290: --
283: --
284: fnd_message.set_name('BEN','BEN_91438_LOOKUP_VALUE_INVALID');
285: fnd_message.set_token('FIELD','ACTION_STATUS_CD');
286: fnd_message.set_token('TYPE','BEN_ACTN_STAT');
287: fnd_message.raise_error;
288: --
289: end if;
290: --
291: end if;