66: IF NOT irc_iss_shd.api_updating
67: (p_saved_search_criteria_id => p_rec.saved_search_criteria_id
68: ,p_object_version_number => p_rec.object_version_number
69: ) THEN
70: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
71: fnd_message.set_token('PROCEDURE ', l_proc);
72: fnd_message.set_token('STEP ', '5');
73: fnd_message.raise_error;
74: END IF;
67: (p_saved_search_criteria_id => p_rec.saved_search_criteria_id
68: ,p_object_version_number => p_rec.object_version_number
69: ) THEN
70: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
71: fnd_message.set_token('PROCEDURE ', l_proc);
72: fnd_message.set_token('STEP ', '5');
73: fnd_message.raise_error;
74: END IF;
75: --
68: ,p_object_version_number => p_rec.object_version_number
69: ) THEN
70: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
71: fnd_message.set_token('PROCEDURE ', l_proc);
72: fnd_message.set_token('STEP ', '5');
73: fnd_message.raise_error;
74: END IF;
75: --
76: if p_rec.saved_search_criteria_id <> irc_iss_shd.g_old_rec.saved_search_criteria_id
69: ) THEN
70: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
71: fnd_message.set_token('PROCEDURE ', l_proc);
72: fnd_message.set_token('STEP ', '5');
73: fnd_message.raise_error;
74: END IF;
75: --
76: if p_rec.saved_search_criteria_id <> irc_iss_shd.g_old_rec.saved_search_criteria_id
77: then
150: --
151: if vacancy_exists%notfound then
152: close vacancy_exists;
153: hr_utility.set_location(l_proc, 30);
154: fnd_message.set_name('PER', 'HR_52591_CEL_INVL_VAC_ID ');
155: fnd_message.raise_error;
156: else
157: close vacancy_exists;
158: end if;
151: if vacancy_exists%notfound then
152: close vacancy_exists;
153: hr_utility.set_location(l_proc, 30);
154: fnd_message.set_name('PER', 'HR_52591_CEL_INVL_VAC_ID ');
155: fnd_message.raise_error;
156: else
157: close vacancy_exists;
158: end if;
159: --