61: close csr_sec_grp;
62: --
63: -- The primary key is invalid therefore we must error
64: --
65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
66: fnd_message.raise_error;
67: --
68: end if;
69: close csr_sec_grp;
62: --
63: -- The primary key is invalid therefore we must error
64: --
65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
66: fnd_message.raise_error;
67: --
68: end if;
69: close csr_sec_grp;
70: --
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
448: IF NOT per_cai_shd.api_updating
449: (p_cagr_api_id => p_rec.cagr_api_id
450: ,p_object_version_number => p_rec.object_version_number
451: ) THEN
452: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE ', l_proc);
454: fnd_message.set_token('STEP ', '5');
455: fnd_message.raise_error;
456: END IF;
449: (p_cagr_api_id => p_rec.cagr_api_id
450: ,p_object_version_number => p_rec.object_version_number
451: ) THEN
452: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE ', l_proc);
454: fnd_message.set_token('STEP ', '5');
455: fnd_message.raise_error;
456: END IF;
457: --
450: ,p_object_version_number => p_rec.object_version_number
451: ) THEN
452: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE ', l_proc);
454: fnd_message.set_token('STEP ', '5');
455: fnd_message.raise_error;
456: END IF;
457: --
458: IF nvl(p_rec.api_name, hr_api.g_varchar2) <>
451: ) THEN
452: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE ', l_proc);
454: fnd_message.set_token('STEP ', '5');
455: fnd_message.raise_error;
456: END IF;
457: --
458: IF nvl(p_rec.api_name, hr_api.g_varchar2) <>
459: nvl(per_cai_shd.g_old_rec.api_name,hr_api.g_varchar2) THEN