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: --
144: --
145: -- The primary key is invalid therefore we must error
146: --
147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
145: -- The primary key is invalid therefore we must error
146: --
147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
153: -- Set the global variables so the values are
205: IF NOT pay_rtt_shd.api_updating
206: (p_run_type_id => p_rec.run_type_id
207: ,p_language => p_rec.language
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
206: (p_run_type_id => p_rec.run_type_id
207: ,p_language => p_rec.language
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214: --
207: ,p_language => p_rec.language
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214: --
215: -- RET 12-DEC-2001 making run_type_name non-updateable as is the key
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214: --
215: -- RET 12-DEC-2001 making run_type_name non-updateable as is the key
216: -- for uploading ldts.