68: close csr_sec_grp;
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: close csr_sec_grp;
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: close csr_sec_grp;
77: --
156: --
157: -- The primary key is invalid therefore we must error
158: --
159: close csr_leg_code;
160: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: end if;
163: if g_debug then
164: hr_utility.set_location(l_proc,30);
157: -- The primary key is invalid therefore we must error
158: --
159: close csr_leg_code;
160: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: end if;
163: if g_debug then
164: hr_utility.set_location(l_proc,30);
165: end if;
221: IF NOT hxc_rtr_shd.api_updating
222: (p_retrieval_rule_id => p_rec.retrieval_rule_id
223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
222: (p_retrieval_rule_id => p_rec.retrieval_rule_id
223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --
223: ,p_object_version_number => p_rec.object_version_number
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --
231: -- EDIT_HERE: Add checks to ensure non-updateable args have
224: ) THEN
225: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
226: fnd_message.set_token('PROCEDURE ', l_proc);
227: fnd_message.set_token('STEP ', '5');
228: fnd_message.raise_error;
229: END IF;
230: --
231: -- EDIT_HERE: Add checks to ensure non-updateable args have
232: -- not been updated.