61: close csr_sec_grp;
62: --
63: -- The primary key is invalid therefore we must error
64: --
65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
66: hr_multi_message.add
67: (p_associated_column1
68: => nvl(p_associated_column1,'PROFILE_SNAPSHOT_ID')
69: );
144: --
145: -- The primary key is invalid therefore we must error
146: --
147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
145: -- The primary key is invalid therefore we must error
146: --
147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
153: -- Set the global variables so the values are
203: IF NOT irc_aps_shd.api_updating
204: (p_profile_snapshot_id => p_rec.profile_snapshot_id
205: ,p_object_version_number => p_rec.object_version_number
206: ) THEN
207: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
208: fnd_message.set_token('PROCEDURE ', l_proc);
209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;
204: (p_profile_snapshot_id => p_rec.profile_snapshot_id
205: ,p_object_version_number => p_rec.object_version_number
206: ) THEN
207: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
208: fnd_message.set_token('PROCEDURE ', l_proc);
209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;
212: --
205: ,p_object_version_number => p_rec.object_version_number
206: ) THEN
207: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
208: fnd_message.set_token('PROCEDURE ', l_proc);
209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;
212: --
213: -- EDIT_HERE: Add checks to ensure non-updateable args have
206: ) THEN
207: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
208: fnd_message.set_token('PROCEDURE ', l_proc);
209: fnd_message.set_token('STEP ', '5');
210: fnd_message.raise_error;
211: END IF;
212: --
213: -- EDIT_HERE: Add checks to ensure non-updateable args have
214: -- not been updated.
283: --
284: if person_exists%notfound then
285: close person_exists;
286: hr_utility.set_location(l_proc, 30);
287: fnd_message.set_name('PER', 'IRC_412233_INV_OTA_ATTEMPT');
288: fnd_message.raise_error;
289: else
290: close person_exists;
291: end if;
284: if person_exists%notfound then
285: close person_exists;
286: hr_utility.set_location(l_proc, 30);
287: fnd_message.set_name('PER', 'IRC_412233_INV_OTA_ATTEMPT');
288: fnd_message.raise_error;
289: else
290: close person_exists;
291: end if;
292: --