64: close csr_sec_grp;
65: --
66: -- The primary key is invalid therefore we must error
67: --
68: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
69: hr_multi_message.add
70: (p_associated_column1
71: => nvl(p_associated_column1,'GAP_DURATION_SUMMARY_ID')
72: );
150: --
151: -- The primary key is invalid therefore we must error
152: --
153: close csr_leg_code;
154: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
155: fnd_message.raise_error;
156: end if;
157: hr_utility.set_location(l_proc,30);
158: --
151: -- The primary key is invalid therefore we must error
152: --
153: close csr_leg_code;
154: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
155: fnd_message.raise_error;
156: end if;
157: hr_utility.set_location(l_proc,30);
158: --
159: -- Set the global variables so the values are
208: IF NOT pqp_gds_shd.api_updating
209: (p_gap_duration_summary_id => p_rec.gap_duration_summary_id
210: ,p_object_version_number => p_rec.object_version_number
211: ) THEN
212: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE ', l_proc);
214: fnd_message.set_token('STEP ', '5');
215: fnd_message.raise_error;
216: END IF;
209: (p_gap_duration_summary_id => p_rec.gap_duration_summary_id
210: ,p_object_version_number => p_rec.object_version_number
211: ) THEN
212: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE ', l_proc);
214: fnd_message.set_token('STEP ', '5');
215: fnd_message.raise_error;
216: END IF;
217: --
210: ,p_object_version_number => p_rec.object_version_number
211: ) THEN
212: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE ', l_proc);
214: fnd_message.set_token('STEP ', '5');
215: fnd_message.raise_error;
216: END IF;
217: --
218: -- EDIT_HERE: Add checks to ensure non-updateable args have
211: ) THEN
212: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE ', l_proc);
214: fnd_message.set_token('STEP ', '5');
215: fnd_message.raise_error;
216: END IF;
217: --
218: -- EDIT_HERE: Add checks to ensure non-updateable args have
219: -- not been updated.