55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --
128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
325: IF NOT per_evt_shd.api_updating
326: (p_event_id => p_rec.event_id
327: ,p_object_version_number => p_rec.object_version_number
328: ) THEN
329: fnd_message.set_name('PER', 'HR_289323_EVENT_NOT_FOUND');
330: fnd_message.set_token('PROCEDURE ', l_proc);
331: fnd_message.set_token('STEP ', '5');
332: fnd_message.raise_error;
333: END IF;
326: (p_event_id => p_rec.event_id
327: ,p_object_version_number => p_rec.object_version_number
328: ) THEN
329: fnd_message.set_name('PER', 'HR_289323_EVENT_NOT_FOUND');
330: fnd_message.set_token('PROCEDURE ', l_proc);
331: fnd_message.set_token('STEP ', '5');
332: fnd_message.raise_error;
333: END IF;
334: --
327: ,p_object_version_number => p_rec.object_version_number
328: ) THEN
329: fnd_message.set_name('PER', 'HR_289323_EVENT_NOT_FOUND');
330: fnd_message.set_token('PROCEDURE ', l_proc);
331: fnd_message.set_token('STEP ', '5');
332: fnd_message.raise_error;
333: END IF;
334: --
335: if p_rec.business_group_id <> per_evt_shd.g_old_rec.business_group_id then
328: ) THEN
329: fnd_message.set_name('PER', 'HR_289323_EVENT_NOT_FOUND');
330: fnd_message.set_token('PROCEDURE ', l_proc);
331: fnd_message.set_token('STEP ', '5');
332: fnd_message.raise_error;
333: END IF;
334: --
335: if p_rec.business_group_id <> per_evt_shd.g_old_rec.business_group_id then
336: l_argument := 'business_group_id';