53: IF NOT hr_ucx_shd.api_updating
54: (p_ui_context_id => p_rec.ui_context_id
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
54: (p_ui_context_id => p_rec.ui_context_id
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62: --
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62: --
63: -- EDIT_HERE: Add checks to ensure non-updateable args have
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62: --
63: -- EDIT_HERE: Add checks to ensure non-updateable args have
64: -- not been updated.
131: fetch csr_key into l_key;
132: if (csr_key%found)
133: then
134: close csr_key;
135: fnd_message.set_name('PER','PER_449945_UCX_UI_KEY_DUP');
136: fnd_message.raise_error;
137: end if;
138: close csr_key;
139:
132: if (csr_key%found)
133: then
134: close csr_key;
135: fnd_message.set_name('PER','PER_449945_UCX_UI_KEY_DUP');
136: fnd_message.raise_error;
137: end if;
138: close csr_key;
139:
140: hr_utility.set_location(' Leaving:'||l_proc,40);
206: fetch csr_int into l_key;
207: hr_utility.set_location('After fetching :'||l_proc,30);
208: if (csr_int%notfound) then
209: close csr_int;
210: fnd_message.set_name('PER','PER_449569_UCX_UI_ID_ABSENT');
211: fnd_message.raise_error;
212: end if;
213: close csr_int;
214:
207: hr_utility.set_location('After fetching :'||l_proc,30);
208: if (csr_int%notfound) then
209: close csr_int;
210: fnd_message.set_name('PER','PER_449569_UCX_UI_ID_ABSENT');
211: fnd_message.raise_error;
212: end if;
213: close csr_int;
214:
215: hr_utility.set_location(' Leaving:'||l_proc,40);