62: --
63: hr_utility.set_location(l_proc,15);
64: if (csr_chk_bg_id%notfound) then
65: close csr_chk_bg_id;
66: fnd_message.set_name('PER','IRC_412661_INV_BG_ID');
67: fnd_message.raise_error;
68: end if;
69: --
70: close csr_chk_bg_id;
63: hr_utility.set_location(l_proc,15);
64: if (csr_chk_bg_id%notfound) then
65: close csr_chk_bg_id;
66: fnd_message.set_name('PER','IRC_412661_INV_BG_ID');
67: fnd_message.raise_error;
68: end if;
69: --
70: close csr_chk_bg_id;
71: --
131: --
132: hr_utility.set_location(l_proc,15);
133: if (csr_chk_country_code%notfound) then
134: close csr_chk_country_code;
135: fnd_message.set_name('PER','IRC_412662_INV_COUNTRY_CODE');
136: fnd_message.raise_error;
137: end if;
138: --
139: close csr_chk_country_code;
132: hr_utility.set_location(l_proc,15);
133: if (csr_chk_country_code%notfound) then
134: close csr_chk_country_code;
135: fnd_message.set_name('PER','IRC_412662_INV_COUNTRY_CODE');
136: fnd_message.raise_error;
137: end if;
138: --
139: close csr_chk_country_code;
140: --
200: --
201: hr_utility.set_location(l_proc,15);
202: if (csr_chk_loc_id%notfound) then
203: close csr_chk_loc_id;
204: fnd_message.set_name('PER','IRC_412663_INV_LOCATION_ID');
205: fnd_message.raise_error;
206: end if;
207: --
208: close csr_chk_loc_id;
201: hr_utility.set_location(l_proc,15);
202: if (csr_chk_loc_id%notfound) then
203: close csr_chk_loc_id;
204: fnd_message.set_name('PER','IRC_412663_INV_LOCATION_ID');
205: fnd_message.raise_error;
206: end if;
207: --
208: close csr_chk_loc_id;
209: --
275: --
276: hr_utility.set_location(l_proc,15);
277: if (csr_chk_duplicate_loc_pref%found) then
278: close csr_chk_duplicate_loc_pref;
279: fnd_message.set_name('PER','IRC_412664_DUP_LOC_PREFS');
280: fnd_message.raise_error;
281: end if;
282: --
283: close csr_chk_duplicate_loc_pref;
276: hr_utility.set_location(l_proc,15);
277: if (csr_chk_duplicate_loc_pref%found) then
278: close csr_chk_duplicate_loc_pref;
279: fnd_message.set_name('PER','IRC_412664_DUP_LOC_PREFS');
280: fnd_message.raise_error;
281: end if;
282: --
283: close csr_chk_duplicate_loc_pref;
284: --
514: IF NOT irc_ilp_shd.api_updating
515: (p_location_pref_id => p_rec.location_pref_id
516: ,p_object_version_number => p_rec.object_version_number
517: ) THEN
518: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE ', l_proc);
520: fnd_message.set_token('STEP ', '5');
521: fnd_message.raise_error;
522: END IF;
515: (p_location_pref_id => p_rec.location_pref_id
516: ,p_object_version_number => p_rec.object_version_number
517: ) THEN
518: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE ', l_proc);
520: fnd_message.set_token('STEP ', '5');
521: fnd_message.raise_error;
522: END IF;
523: --
516: ,p_object_version_number => p_rec.object_version_number
517: ) THEN
518: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE ', l_proc);
520: fnd_message.set_token('STEP ', '5');
521: fnd_message.raise_error;
522: END IF;
523: --
524: -- EDIT_HERE: Add checks to ensure non-updateable args have
517: ) THEN
518: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE ', l_proc);
520: fnd_message.set_token('STEP ', '5');
521: fnd_message.raise_error;
522: END IF;
523: --
524: -- EDIT_HERE: Add checks to ensure non-updateable args have
525: -- not been updated.