113: l_found varchar2(10);
114:
115: Begin
116:
117: hr_utility.set_location(' Entering:' || l_proc,10);
118:
119: hr_api.mandatory_arg_error
120: (p_api_name => l_proc
121: ,p_argument => 'TOPIC_ID'
132: end if;
133:
134: close csr_ttl_parent;
135:
136: hr_utility.set_location(' Leaving:' || l_proc,20);
137:
138: Exception
139: when app_exception.application_exception then
140: IF hr_multi_message.exception_add
139: when app_exception.application_exception then
140: IF hr_multi_message.exception_add
141: (p_associated_column1 => 'HR_KI_TOPICS_TL.TOPIC_ID'
142: ) THEN
143: hr_utility.set_location(' Leaving:'|| l_proc,30);
144: raise;
145: END IF;
146:
147: hr_utility.set_location(' Leaving:'|| l_proc,40);
143: hr_utility.set_location(' Leaving:'|| l_proc,30);
144: raise;
145: END IF;
146:
147: hr_utility.set_location(' Leaving:'|| l_proc,40);
148: --
149: End chk_topic_id;
150:
151: -- ----------------------------------------------------------------------------
199: l_found varchar2(10);
200:
201: Begin
202:
203: hr_utility.set_location(' Entering:' || l_proc,10);
204:
205: hr_api.mandatory_arg_error
206: (p_api_name => l_proc
207: ,p_argument => 'NAME'
218: end if;
219:
220: close csr_ttl_name;
221:
222: hr_utility.set_location(' Leaving:' || l_proc,20);
223:
224: Exception
225: when app_exception.application_exception then
226: IF hr_multi_message.exception_add
225: when app_exception.application_exception then
226: IF hr_multi_message.exception_add
227: (p_associated_column1 => 'HR_KI_TOPICS_TL.NAME'
228: ) THEN
229: hr_utility.set_location(' Leaving:'|| l_proc,30);
230: raise;
231: END IF;
232:
233: hr_utility.set_location(' Leaving:'|| l_proc,40);
229: hr_utility.set_location(' Leaving:'|| l_proc,30);
230: raise;
231: END IF;
232:
233: hr_utility.set_location(' Leaving:'|| l_proc,40);
234: --
235: End chk_name;
236:
237: --
245: --
246: l_proc varchar2(72) := g_package||'insert_validate';
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- Call all supporting business operations
252: --
253: --
257: chk_topic_id(p_topic_id);
258: chk_name(p_rec.language,p_rec.name,p_topic_id);
259: --
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: End insert_validate;
263: --
264: -- ----------------------------------------------------------------------------
265: -- |---------------------------< update_validate >----------------------------|
270: --
271: l_proc varchar2(72) := g_package||'update_validate';
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- Call all supporting business operations
277: --
278: --
284:
285: chk_name(p_rec.language,p_rec.name,p_rec.topic_id);
286: --
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 10);
289: End update_validate;
290: --
291: -- ----------------------------------------------------------------------------
292: -- |---------------------------< delete_validate >----------------------------|
297: --
298: l_proc varchar2(72) := g_package||'delete_validate';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Call all supporting business operations
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Call all supporting business operations
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: End delete_validate;
307: --
308: end hr_ttl_bus;