258: --
259: -- The element classification was not found.
260: --
261: if p_rec.legislation_code = 'US' THEN
262: fnd_message.set_name('PER','HR_75272_INV_ELE_CLASS');
263: fnd_message.raise_error;
264: elsif p_rec.legislation_code = 'CA' THEN
265: fnd_message.set_name('PER','HR_74028_INV_ELE_CLASS');
266: fnd_message.raise_error;
259: -- The element classification was not found.
260: --
261: if p_rec.legislation_code = 'US' THEN
262: fnd_message.set_name('PER','HR_75272_INV_ELE_CLASS');
263: fnd_message.raise_error;
264: elsif p_rec.legislation_code = 'CA' THEN
265: fnd_message.set_name('PER','HR_74028_INV_ELE_CLASS');
266: fnd_message.raise_error;
267: end if;
261: if p_rec.legislation_code = 'US' THEN
262: fnd_message.set_name('PER','HR_75272_INV_ELE_CLASS');
263: fnd_message.raise_error;
264: elsif p_rec.legislation_code = 'CA' THEN
265: fnd_message.set_name('PER','HR_74028_INV_ELE_CLASS');
266: fnd_message.raise_error;
267: end if;
268: End If;
269: Close c_ele_class_validation;
262: fnd_message.set_name('PER','HR_75272_INV_ELE_CLASS');
263: fnd_message.raise_error;
264: elsif p_rec.legislation_code = 'CA' THEN
265: fnd_message.set_name('PER','HR_74028_INV_ELE_CLASS');
266: fnd_message.raise_error;
267: end if;
268: End If;
269: Close c_ele_class_validation;
270:
279: --
280: -- The secondary element classification was not found.
281: --
282: if p_rec.legislation_code = 'US' THEN
283: fnd_message.set_name('PER','HR_75272_INV_ELE_CLASS');
284: fnd_message.raise_error;
285: elsif p_rec.legislation_code = 'CA' THEN
286: fnd_message.set_name('PER','HR_74028_INV_ELE_CLASS');
287: fnd_message.raise_error;
280: -- The secondary element classification was not found.
281: --
282: if p_rec.legislation_code = 'US' THEN
283: fnd_message.set_name('PER','HR_75272_INV_ELE_CLASS');
284: fnd_message.raise_error;
285: elsif p_rec.legislation_code = 'CA' THEN
286: fnd_message.set_name('PER','HR_74028_INV_ELE_CLASS');
287: fnd_message.raise_error;
288: end if;
282: if p_rec.legislation_code = 'US' THEN
283: fnd_message.set_name('PER','HR_75272_INV_ELE_CLASS');
284: fnd_message.raise_error;
285: elsif p_rec.legislation_code = 'CA' THEN
286: fnd_message.set_name('PER','HR_74028_INV_ELE_CLASS');
287: fnd_message.raise_error;
288: end if;
289: End If;
290: Close c_sec_ele_class_validation;
283: fnd_message.set_name('PER','HR_75272_INV_ELE_CLASS');
284: fnd_message.raise_error;
285: elsif p_rec.legislation_code = 'CA' THEN
286: fnd_message.set_name('PER','HR_74028_INV_ELE_CLASS');
287: fnd_message.raise_error;
288: end if;
289: End If;
290: Close c_sec_ele_class_validation;
291: END IF;
305: Close C_Sel2;
306: --
307: -- The primary key values are already in use.
308: --
309: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
310: fnd_message.set_token('TABLE_NAME','pay_taxability_rules');
311: fnd_message.raise_error;
312: End If;
313: Close C_Sel2;
306: --
307: -- The primary key values are already in use.
308: --
309: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
310: fnd_message.set_token('TABLE_NAME','pay_taxability_rules');
311: fnd_message.raise_error;
312: End If;
313: Close C_Sel2;
314: --
307: -- The primary key values are already in use.
308: --
309: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
310: fnd_message.set_token('TABLE_NAME','pay_taxability_rules');
311: fnd_message.raise_error;
312: End If;
313: Close C_Sel2;
314: --
315: -- Use registered key values and clear globals