65: close csr_sec_grp;
66: --
67: -- The primary key is invalid therefore we must error
68: --
69: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
70: fnd_message.raise_error;
71: --
72: end if;
73: close csr_sec_grp;
66: --
67: -- The primary key is invalid therefore we must error
68: --
69: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
70: fnd_message.raise_error;
71: --
72: end if;
73: close csr_sec_grp;
74: --
152: --
153: -- The primary key is invalid therefore we must error
154: --
155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: if g_debug then
160: hr_utility.set_location(l_proc,30);
153: -- The primary key is invalid therefore we must error
154: --
155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: if g_debug then
160: hr_utility.set_location(l_proc,30);
161: end if;
217: IF NOT hxc_dru_shd.api_updating
218: (p_data_app_rule_usage_id => p_rec.data_app_rule_usage_id
219: ,p_object_version_number => p_rec.object_version_number
220: ) THEN
221: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
222: fnd_message.set_token('PROCEDURE ', l_proc);
223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
218: (p_data_app_rule_usage_id => p_rec.data_app_rule_usage_id
219: ,p_object_version_number => p_rec.object_version_number
220: ) THEN
221: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
222: fnd_message.set_token('PROCEDURE ', l_proc);
223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
226: --
219: ,p_object_version_number => p_rec.object_version_number
220: ) THEN
221: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
222: fnd_message.set_token('PROCEDURE ', l_proc);
223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
226: --
227: -- EDIT_HERE: Add checks to ensure non-updateable args have
220: ) THEN
221: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
222: fnd_message.set_token('PROCEDURE ', l_proc);
223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
226: --
227: -- EDIT_HERE: Add checks to ensure non-updateable args have
228: -- not been updated.