55: IF NOT hr_htl_shd.api_updating
56: (p_hierarchy_id => p_rec.hierarchy_id,
57: p_language => p_rec.language
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
56: (p_hierarchy_id => p_rec.hierarchy_id,
57: p_language => p_rec.language
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64: --
57: p_language => p_rec.language
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64: --
65: -- EDIT_HERE: Add checks to ensure non-updateable args have
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64: --
65: -- EDIT_HERE: Add checks to ensure non-updateable args have
66: -- not been updated.
122: fetch csr_htl_parent into l_found;
123:
124: if csr_htl_parent%NOTFOUND then
125: close csr_htl_parent;
126: fnd_message.set_name('PER', 'PER_449920_HTL_HRC_ID_ABSENT');
127: fnd_message.raise_error;
128: end if;
129:
130: close csr_htl_parent;
123:
124: if csr_htl_parent%NOTFOUND then
125: close csr_htl_parent;
126: fnd_message.set_name('PER', 'PER_449920_HTL_HRC_ID_ABSENT');
127: fnd_message.raise_error;
128: end if;
129:
130: close csr_htl_parent;
131:
206: fetch csr_htl_name into l_found;
207:
208: if csr_htl_name%FOUND then
209: close csr_htl_name;
210: fnd_message.set_name('PER', 'PER_449921_HTL_NAME_DUPLICATE');
211: fnd_message.raise_error;
212: end if;
213:
214: close csr_htl_name;
207:
208: if csr_htl_name%FOUND then
209: close csr_htl_name;
210: fnd_message.set_name('PER', 'PER_449921_HTL_NAME_DUPLICATE');
211: fnd_message.raise_error;
212: end if;
213:
214: close csr_htl_name;
215: