60: close csr_sec_grp;
61: --
62: -- The primary key is invalid therefore we must error
63: --
64: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
65: fnd_message.raise_error;
66: --
67: end if;
68: close csr_sec_grp;
61: --
62: -- The primary key is invalid therefore we must error
63: --
64: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
65: fnd_message.raise_error;
66: --
67: end if;
68: close csr_sec_grp;
69: END IF;
139: --
140: -- The primary key is invalid therefore we must error
141: --
142: close csr_leg_code;
143: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: end if;
146: hr_utility.set_location(l_proc,30);
147: --
140: -- The primary key is invalid therefore we must error
141: --
142: close csr_leg_code;
143: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: end if;
146: hr_utility.set_location(l_proc,30);
147: --
148: -- Set the global variables so the values are
200: IF NOT pqp_ert_shd.api_updating
201: (p_exception_report_id => p_rec.exception_report_id
202: ,p_language => p_rec.language
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
201: (p_exception_report_id => p_rec.exception_report_id
202: ,p_language => p_rec.language
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
202: ,p_language => p_rec.language
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
210: --
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
210: --
211: EXCEPTION