59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: fnd_message.raise_error;
65: --
66: end if;
67: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: fnd_message.raise_error;
65: --
66: end if;
67: close csr_sec_grp;
68: --
136: --
137: -- The primary key is invalid therefore we must error
138: --
139: close csr_leg_code;
140: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: end if;
143: hr_utility.set_location(l_proc,30);
144: --
137: -- The primary key is invalid therefore we must error
138: --
139: close csr_leg_code;
140: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: end if;
143: hr_utility.set_location(l_proc,30);
144: --
145: -- Set the global variables so the values are
1036: IF NOT per_cpa_shd.api_updating
1037: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1038: ,p_object_version_number => p_rec.object_version_number
1039: ) THEN
1040: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1041: fnd_message.set_token('PROCEDURE ', l_proc);
1042: fnd_message.set_token('STEP ', '5');
1043: fnd_message.raise_error;
1044: END IF;
1037: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1038: ,p_object_version_number => p_rec.object_version_number
1039: ) THEN
1040: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1041: fnd_message.set_token('PROCEDURE ', l_proc);
1042: fnd_message.set_token('STEP ', '5');
1043: fnd_message.raise_error;
1044: END IF;
1045: --
1038: ,p_object_version_number => p_rec.object_version_number
1039: ) THEN
1040: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1041: fnd_message.set_token('PROCEDURE ', l_proc);
1042: fnd_message.set_token('STEP ', '5');
1043: fnd_message.raise_error;
1044: END IF;
1045: --
1046: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>
1039: ) THEN
1040: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1041: fnd_message.set_token('PROCEDURE ', l_proc);
1042: fnd_message.set_token('STEP ', '5');
1043: fnd_message.raise_error;
1044: END IF;
1045: --
1046: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>
1047: nvl(per_cpa_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN