DBA Data[Home] [Help]

APPS.OTA_TPS_SWI dependencies on HR_UTILITY

Line 83: hr_utility.set_location(' Entering:' || l_proc,10);

79: hr_dflex_utility.l_ignore_dfcode_varray();
80:
81:
82: BEGIN
83: hr_utility.set_location(' Entering:' || l_proc,10);
84: --
85: -- Issue a savepoint
86: --
87: SAVEPOINT create_training_plan_swi;

Line 190: hr_utility.set_location(' Leaving:' || l_proc,20);

186: -- messages of any type exist in the Multiple Message List.
187: -- Also disable Multiple Message Detection.
188: --
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving:' || l_proc,20);
191: --
192:
193: EXCEPTION
194: WHEN hr_multi_message.error_message_exist THEN

Line 206: hr_utility.set_location(' Leaving:' || l_proc, 30);

202: -- Reset IN OUT parameters and set OUT parameters
203: --
204: p_object_version_number := NULL;
205: p_return_status := hr_multi_message.get_return_status_disable;
206: hr_utility.set_location(' Leaving:' || l_proc, 30);
207:
208: WHEN others THEN
209: --
210: -- When Multiple Message Detection is enabled catch

Line 218: hr_utility.set_location(' Leaving:' || l_proc,40);

214: -- error.
215: --
216: ROLLBACK TO create_training_plan_swi;
217: IF hr_multi_message.unexpected_error_add(l_proc) THEN
218: hr_utility.set_location(' Leaving:' || l_proc,40);
219: RAISE;
220: END IF;
221: --
222: -- Reset IN OUT and set OUT parameters

Line 226: hr_utility.set_location(' Leaving:' || l_proc,50);

222: -- Reset IN OUT and set OUT parameters
223: --
224: p_object_version_number := NULL;
225: p_return_status := hr_multi_message.get_return_status_disable;
226: hr_utility.set_location(' Leaving:' || l_proc,50);
227:
228: END create_training_plan;
229: -- ----------------------------------------------------------------------------
230: -- |-------------------------< delete_training_plan >-------------------------|

Line 246: hr_utility.set_location(' Entering:' || l_proc,10);

242: -- Other variables
243: l_proc VARCHAR2(72) := g_package ||'delete_training_plan';
244:
245: BEGIN
246: hr_utility.set_location(' Entering:' || l_proc,10);
247: --
248: -- Issue a savepoint
249: --
250: SAVEPOINT delete_training_plan_swi;

Line 288: hr_utility.set_location(' Leaving:' || l_proc,20);

284: -- messages of any type exist in the Multiple Message List.
285: -- Also disable Multiple Message Detection.
286: --
287: p_return_status := hr_multi_message.get_return_status_disable;
288: hr_utility.set_location(' Leaving:' || l_proc,20);
289: --
290: EXCEPTION
291: WHEN hr_multi_message.error_message_exist THEN
292: --

Line 302: hr_utility.set_location(' Leaving:' || l_proc, 30);

298: --
299: -- Reset IN OUT parameters and set OUT parameters
300: --
301: p_return_status := hr_multi_message.get_return_status_disable;
302: hr_utility.set_location(' Leaving:' || l_proc, 30);
303:
304: WHEN others THEN
305: --
306: -- When Multiple Message Detection is enabled catch

Line 314: hr_utility.set_location(' Leaving:' || l_proc,40);

310: -- error.
311: --
312: ROLLBACK TO delete_training_plan_swi;
313: IF hr_multi_message.unexpected_error_add(l_proc) THEN
314: hr_utility.set_location(' Leaving:' || l_proc,40);
315: RAISE;
316: END IF;
317: --
318: -- Reset IN OUT and set OUT parameters

Line 321: hr_utility.set_location(' Leaving:' || l_proc,50);

317: --
318: -- Reset IN OUT and set OUT parameters
319: --
320: p_return_status := hr_multi_message.get_return_status_disable;
321: hr_utility.set_location(' Leaving:' || l_proc,50);
322: END delete_training_plan;
323: -- ----------------------------------------------------------------------------
324: -- |-------------------------< update_training_plan >-------------------------|
325: -- ----------------------------------------------------------------------------

Line 387: hr_utility.set_location(' Entering:' || l_proc,10);

383: -- Other variables
384: l_proc VARCHAR2(72) := g_package ||'update_training_plan';
385:
386: BEGIN
387: hr_utility.set_location(' Entering:' || l_proc,10);
388: --
389: -- Issue a savepoint
390: --
391: SAVEPOINT update_training_plan_swi;

Line 474: hr_utility.set_location(' Leaving:' || l_proc,20);

470: -- messages of any type exist in the Multiple Message List.
471: -- Also disable Multiple Message Detection.
472: --
473: p_return_status := hr_multi_message.get_return_status_disable;
474: hr_utility.set_location(' Leaving:' || l_proc,20);
475: --
476: EXCEPTION
477: WHEN hr_multi_message.error_message_exist THEN
478: --

Line 489: hr_utility.set_location(' Leaving:' || l_proc, 30);

485: -- Reset IN OUT parameters and set OUT parameters
486: --
487: p_object_version_NUMBER := l_object_version_number;
488: p_return_status := hr_multi_message.get_return_status_disable;
489: hr_utility.set_location(' Leaving:' || l_proc, 30);
490: WHEN others THEN
491: --
492: -- When Multiple Message Detection is enabled catch
493: -- any Application specific or other unexpected

Line 500: hr_utility.set_location(' Leaving:' || l_proc,40);

496: -- error.
497: --
498: ROLLBACK TO update_training_plan_swi;
499: IF hr_multi_message.unexpected_error_add(l_proc) THEN
500: hr_utility.set_location(' Leaving:' || l_proc,40);
501: RAISE;
502: END IF;
503: --
504: -- Reset IN OUT and set OUT parameters

Line 508: hr_utility.set_location(' Leaving:' || l_proc,50);

504: -- Reset IN OUT and set OUT parameters
505: --
506: p_object_version_NUMBER := l_object_version_number;
507: p_return_status := hr_multi_message.get_return_status_disable;
508: hr_utility.set_location(' Leaving:' || l_proc,50);
509: END update_training_plan;
510: END ota_tps_swi;