60: close csr_sec_grp;
61: --
62: -- The primary key is invalid therefore we must error
63: --
64: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
65: hr_multi_message.add
66: (p_associated_column1
67: => nvl(p_associated_column1,'SETUP_SUB_TASK_CODE')
68: );
142: --
143: -- The primary key is invalid therefore we must error
144: --
145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: end if;
149: hr_utility.set_location(l_proc,30);
150: --
143: -- The primary key is invalid therefore we must error
144: --
145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: end if;
149: hr_utility.set_location(l_proc,30);
150: --
151: -- Set the global variables so the values are
201: IF NOT per_ssb_shd.api_updating
202: (p_setup_sub_task_code => p_rec.setup_sub_task_code
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
202: (p_setup_sub_task_code => p_rec.setup_sub_task_code
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: -- EDIT_HERE: Add checks to ensure non-updateable args have
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: -- EDIT_HERE: Add checks to ensure non-updateable args have
212: -- not been updated.
267: (p_effective_date => p_effective_date
268: ,p_lookup_type => 'PER_RI_SUB_TASK_TYPE'
269: ,p_lookup_code => p_setup_sub_task_type
270: ) Then
271: fnd_message.set_name('PER', 'HR_52966_INVALID_LOOKUP');
272: fnd_message.set_token('COLUMN ', p_setup_sub_task_type);
273: fnd_message.set_token('LOOKUP_TYPE ', 'PER_RI_SUB_TASK_TYPE');
274: fnd_message.set_token('STEP ', '5');
275: fnd_message.raise_error;
268: ,p_lookup_type => 'PER_RI_SUB_TASK_TYPE'
269: ,p_lookup_code => p_setup_sub_task_type
270: ) Then
271: fnd_message.set_name('PER', 'HR_52966_INVALID_LOOKUP');
272: fnd_message.set_token('COLUMN ', p_setup_sub_task_type);
273: fnd_message.set_token('LOOKUP_TYPE ', 'PER_RI_SUB_TASK_TYPE');
274: fnd_message.set_token('STEP ', '5');
275: fnd_message.raise_error;
276: End If;
269: ,p_lookup_code => p_setup_sub_task_type
270: ) Then
271: fnd_message.set_name('PER', 'HR_52966_INVALID_LOOKUP');
272: fnd_message.set_token('COLUMN ', p_setup_sub_task_type);
273: fnd_message.set_token('LOOKUP_TYPE ', 'PER_RI_SUB_TASK_TYPE');
274: fnd_message.set_token('STEP ', '5');
275: fnd_message.raise_error;
276: End If;
277:
270: ) Then
271: fnd_message.set_name('PER', 'HR_52966_INVALID_LOOKUP');
272: fnd_message.set_token('COLUMN ', p_setup_sub_task_type);
273: fnd_message.set_token('LOOKUP_TYPE ', 'PER_RI_SUB_TASK_TYPE');
274: fnd_message.set_token('STEP ', '5');
275: fnd_message.raise_error;
276: End If;
277:
278: End If;
271: fnd_message.set_name('PER', 'HR_52966_INVALID_LOOKUP');
272: fnd_message.set_token('COLUMN ', p_setup_sub_task_type);
273: fnd_message.set_token('LOOKUP_TYPE ', 'PER_RI_SUB_TASK_TYPE');
274: fnd_message.set_token('STEP ', '5');
275: fnd_message.raise_error;
276: End If;
277:
278: End If;
279: