99: --
100: -- The primary key is invalid therefore we must error
101: --
102: close csr_leg_code;
103: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
104: fnd_message.raise_error;
105: end if;
106: hr_utility.set_location(l_proc,30);
107: --
100: -- The primary key is invalid therefore we must error
101: --
102: close csr_leg_code;
103: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
104: fnd_message.raise_error;
105: end if;
106: hr_utility.set_location(l_proc,30);
107: --
108: -- Set the global variables so the values are
158: IF NOT per_gdt_shd.api_updating
159: (p_grade_id => p_rec.grade_id
160: ,p_language => p_rec.language
161: ) THEN
162: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
163: fnd_message.set_token('PROCEDURE ', l_proc);
164: fnd_message.set_token('STEP ', '5');
165: fnd_message.raise_error;
166: END IF;
159: (p_grade_id => p_rec.grade_id
160: ,p_language => p_rec.language
161: ) THEN
162: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
163: fnd_message.set_token('PROCEDURE ', l_proc);
164: fnd_message.set_token('STEP ', '5');
165: fnd_message.raise_error;
166: END IF;
167: --
160: ,p_language => p_rec.language
161: ) THEN
162: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
163: fnd_message.set_token('PROCEDURE ', l_proc);
164: fnd_message.set_token('STEP ', '5');
165: fnd_message.raise_error;
166: END IF;
167: --
168: --
161: ) THEN
162: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
163: fnd_message.set_token('PROCEDURE ', l_proc);
164: fnd_message.set_token('STEP ', '5');
165: fnd_message.raise_error;
166: END IF;
167: --
168: --
169: --