106: close csr_sec_grp;
107: --
108: -- The primary key is invalid therefore we must error
109: --
110: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
111: fnd_message.raise_error;
112: --
113: end if;
114: close csr_sec_grp;
107: --
108: -- The primary key is invalid therefore we must error
109: --
110: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
111: fnd_message.raise_error;
112: --
113: end if;
114: close csr_sec_grp;
115: --
180: --
181: -- The primary key is invalid therefore we must error
182: --
183: close csr_leg_code;
184: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
185: fnd_message.raise_error;
186: end if;
187: hr_utility.set_location(l_proc,0);
188: --
181: -- The primary key is invalid therefore we must error
182: --
183: close csr_leg_code;
184: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
185: fnd_message.raise_error;
186: end if;
187: hr_utility.set_location(l_proc,0);
188: --
189: -- Set the global variables so the values are
241: IF NOT pqh_rls_shd.api_updating
242: (p_role_id => p_rec.role_id
243: ,p_object_version_number => p_rec.object_version_number
244: ) THEN
245: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE ',l_proc);
247: fnd_message.set_token('STEP ','5');
248: fnd_message.raise_error;
249: END IF;
242: (p_role_id => p_rec.role_id
243: ,p_object_version_number => p_rec.object_version_number
244: ) THEN
245: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE ',l_proc);
247: fnd_message.set_token('STEP ','5');
248: fnd_message.raise_error;
249: END IF;
250: --
243: ,p_object_version_number => p_rec.object_version_number
244: ) THEN
245: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE ',l_proc);
247: fnd_message.set_token('STEP ','5');
248: fnd_message.raise_error;
249: END IF;
250: --
251: -- EDIT_HERE: Add checks to ensure non-updateable args have
244: ) THEN
245: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE ',l_proc);
247: fnd_message.set_token('STEP ','5');
248: fnd_message.raise_error;
249: END IF;
250: --
251: -- EDIT_HERE: Add checks to ensure non-updateable args have
252: -- not been updated.