53: IF NOT hr_tpc_shd.api_updating
54: (p_topic_id => p_rec.topic_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_topic_id => p_rec.topic_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.
130:
131: IF csr_tpc_key%FOUND then
132: hr_utility.set_location(' Topic Key already present:' || l_proc,20);
133: CLOSE csr_tpc_key;
134: fnd_message.set_name( 'PER','PER_449930_TPC_KEY_DUPLICATE');
135: fnd_message.raise_error;
136: END IF;
137:
138: CLOSE csr_tpc_key;
131: IF csr_tpc_key%FOUND then
132: hr_utility.set_location(' Topic Key already present:' || l_proc,20);
133: CLOSE csr_tpc_key;
134: fnd_message.set_name( 'PER','PER_449930_TPC_KEY_DUPLICATE');
135: fnd_message.raise_error;
136: END IF;
137:
138: CLOSE csr_tpc_key;
139:
268: fetch csr_hnm_id into l_found;
269:
270: if csr_hnm_id%FOUND then
271: close csr_hnm_id;
272: fnd_message.set_name( 'PER','PER_449931_TPC_NMAP_MAIN_EXIST');
273: fnd_message.raise_error;
274: end if;
275:
276: close csr_hnm_id;
269:
270: if csr_hnm_id%FOUND then
271: close csr_hnm_id;
272: fnd_message.set_name( 'PER','PER_449931_TPC_NMAP_MAIN_EXIST');
273: fnd_message.raise_error;
274: end if;
275:
276: close csr_hnm_id;
277:
279: fetch csr_tis_id into l_found;
280:
281: if csr_tis_id%FOUND then
282: close csr_tis_id;
283: fnd_message.set_name( 'PER','PER_449932_TPC_TPIN_MAIN_EXIST');
284: fnd_message.raise_error;
285: end if;
286:
287: close csr_tis_id;
280:
281: if csr_tis_id%FOUND then
282: close csr_tis_id;
283: fnd_message.set_name( 'PER','PER_449932_TPC_TPIN_MAIN_EXIST');
284: fnd_message.raise_error;
285: end if;
286:
287: close csr_tis_id;
288:
290: fetch csr_ttl_id into l_found;
291:
292: if csr_ttl_id%FOUND then
293: close csr_ttl_id;
294: fnd_message.set_name( 'PER','PER_449933_TPC_TPTL_MAIN_EXIST');
295: fnd_message.raise_error;
296: end if;
297:
298: close csr_ttl_id;
291:
292: if csr_ttl_id%FOUND then
293: close csr_ttl_id;
294: fnd_message.set_name( 'PER','PER_449933_TPC_TPTL_MAIN_EXIST');
295: fnd_message.raise_error;
296: end if;
297:
298: close csr_ttl_id;
299: