66: close csr_sec_grp;
67: --
68: -- The primary key is invalid therefore we must error
69: --
70: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
71: fnd_message.raise_error;
72: --
73: end if;
74: close csr_sec_grp;
67: --
68: -- The primary key is invalid therefore we must error
69: --
70: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
71: fnd_message.raise_error;
72: --
73: end if;
74: close csr_sec_grp;
75: --
153: --
154: -- The primary key is invalid therefore we must error
155: --
156: close csr_leg_code;
157: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: end if;
160: if g_debug then
161: hr_utility.set_location(l_proc,30);
154: -- The primary key is invalid therefore we must error
155: --
156: close csr_leg_code;
157: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: end if;
160: if g_debug then
161: hr_utility.set_location(l_proc,30);
162: end if;
218: IF NOT hxc_hrp_shd.api_updating
219: (p_recurring_period_id => p_rec.recurring_period_id
220: ,p_object_version_number => p_rec.object_version_number
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
219: (p_recurring_period_id => p_rec.recurring_period_id
220: ,p_object_version_number => p_rec.object_version_number
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --
220: ,p_object_version_number => p_rec.object_version_number
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --
228: -- EDIT_HERE: Add checks to ensure non-updateable args have
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --
228: -- EDIT_HERE: Add checks to ensure non-updateable args have
229: -- not been updated.
393: if g_debug then
394: hr_utility.set_location(l_proc, 15);
395: end if;
396: close c_period_type;
397: FND_MESSAGE.SET_NAME('HXC','HXC_0152_INVALID_PERIOD_TYPE');
398: FND_MESSAGE.RAISE_ERROR;
399: else
400: if g_debug then
401: hr_utility.set_location(l_proc, 20);
394: hr_utility.set_location(l_proc, 15);
395: end if;
396: close c_period_type;
397: FND_MESSAGE.SET_NAME('HXC','HXC_0152_INVALID_PERIOD_TYPE');
398: FND_MESSAGE.RAISE_ERROR;
399: else
400: if g_debug then
401: hr_utility.set_location(l_proc, 20);
402: end if;