67: close csr_sec_grp;
68: --
69: -- The primary key is invalid therefore we must error
70: --
71: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
72: hr_multi_message.add
73: (p_associated_column1
74: => nvl(p_associated_column1,'EFFORT_REPORT_DETAIL_ID')
75: );
155: --
156: -- The primary key is invalid therefore we must error
157: --
158: close csr_leg_code;
159: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
160: fnd_message.raise_error;
161: end if;
162: hr_utility.set_location(l_proc,30);
163: --
156: -- The primary key is invalid therefore we must error
157: --
158: close csr_leg_code;
159: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
160: fnd_message.raise_error;
161: end if;
162: hr_utility.set_location(l_proc,30);
163: --
164: -- Set the global variables so the values are
308: IF NOT psp_erd_shd.api_updating
309: (p_effort_report_detail_id => p_rec.effort_report_detail_id
310: ,p_object_version_number => p_rec.object_version_number
311: ) THEN
312: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE ', l_proc);
314: fnd_message.set_token('STEP ', '5');
315: fnd_message.raise_error;
316: END IF;
309: (p_effort_report_detail_id => p_rec.effort_report_detail_id
310: ,p_object_version_number => p_rec.object_version_number
311: ) THEN
312: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE ', l_proc);
314: fnd_message.set_token('STEP ', '5');
315: fnd_message.raise_error;
316: END IF;
317: --
310: ,p_object_version_number => p_rec.object_version_number
311: ) THEN
312: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE ', l_proc);
314: fnd_message.set_token('STEP ', '5');
315: fnd_message.raise_error;
316: END IF;
317: --
318: -- EDIT_HERE: Add checks to ensure non-updateable args have
311: ) THEN
312: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE ', l_proc);
314: fnd_message.set_token('STEP ', '5');
315: fnd_message.raise_error;
316: END IF;
317: --
318: -- EDIT_HERE: Add checks to ensure non-updateable args have
319: -- not been updated.