55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --
128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
189: IF NOT pay_peu_shd.api_updating
190: (p_event_update_id => p_rec.event_update_id
191: ,p_object_version_number => p_rec.object_version_number
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
194: fnd_message.set_token('PROCEDURE ', l_proc);
195: fnd_message.set_token('STEP ', '5');
196: fnd_message.raise_error;
197: END IF;
190: (p_event_update_id => p_rec.event_update_id
191: ,p_object_version_number => p_rec.object_version_number
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
194: fnd_message.set_token('PROCEDURE ', l_proc);
195: fnd_message.set_token('STEP ', '5');
196: fnd_message.raise_error;
197: END IF;
198: --
191: ,p_object_version_number => p_rec.object_version_number
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
194: fnd_message.set_token('PROCEDURE ', l_proc);
195: fnd_message.set_token('STEP ', '5');
196: fnd_message.raise_error;
197: END IF;
198: --
199: -- EDIT_HERE: Add checks to ensure non-updateable args have
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
194: fnd_message.set_token('PROCEDURE ', l_proc);
195: fnd_message.set_token('STEP ', '5');
196: fnd_message.raise_error;
197: END IF;
198: --
199: -- EDIT_HERE: Add checks to ensure non-updateable args have
200: -- not been updated.
272: ,p_lookup_code => p_rec.event_type) then
273: --
274: -- The event_type for this record is not recognised
275: --
276: fnd_message.set_name('PAY','HR_xxxx_INVALID_EVENT_TYPE');
277: fnd_message.raise_error;
278: end if;
279: hr_utility.set_location(l_proc,30);
280: --
273: --
274: -- The event_type for this record is not recognised
275: --
276: fnd_message.set_name('PAY','HR_xxxx_INVALID_EVENT_TYPE');
277: fnd_message.raise_error;
278: end if;
279: hr_utility.set_location(l_proc,30);
280: --
281: -- Set the global variables so the values are
303: ,p_lookup_code => p_rec.change_type) then
304: --
305: -- The change_type for this record is not recognised
306: --
307: fnd_message.set_name('PAY','HR_xxxx_INVALID_CHANGE_TYPE');
308: fnd_message.raise_error;
309: end if;
310: hr_utility.set_location(l_proc,30);
311: --
304: --
305: -- The change_type for this record is not recognised
306: --
307: fnd_message.set_name('PAY','HR_xxxx_INVALID_CHANGE_TYPE');
308: fnd_message.raise_error;
309: end if;
310: hr_utility.set_location(l_proc,30);
311: --
312: -- Set the global variables so the values are
380: Close csr_chk_column;
381: --
382: -- The column does not belong to the table therefore we must error
383: --
384: fnd_message.set_name('PAY', 'HR_xxxx_INVALID_COLUMN_NAME');
385:
386: fnd_message.raise_error;
387: End If;
388: Close csr_chk_column;
382: -- The column does not belong to the table therefore we must error
383: --
384: fnd_message.set_name('PAY', 'HR_xxxx_INVALID_COLUMN_NAME');
385:
386: fnd_message.raise_error;
387: End If;
388: Close csr_chk_column;
389: End If;
390: --
438: fetch c_duplicate_row into l_exists;
439: if c_duplicate_row%found then
440: --
441: close c_duplicate_row;
442: fnd_message.set_name('PAY', 'PAY_33272_ROW_EVENT_NOT_UNIQUE');
443: fnd_message.raise_error;
444: --
445: End If;
446: --
439: if c_duplicate_row%found then
440: --
441: close c_duplicate_row;
442: fnd_message.set_name('PAY', 'PAY_33272_ROW_EVENT_NOT_UNIQUE');
443: fnd_message.raise_error;
444: --
445: End If;
446: --
447: close c_duplicate_row;