DBA Data[Home] [Help]

APPS.OTA_LP_MEMBER_SWI dependencies on HR_UTILITY

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

52: --
53: -- Other variables
54: l_learning_path_member_id number;
55: l_proc varchar2(72) := g_package ||'create_learning_path_member'; Begin
56: hr_utility.set_location(' Entering:' || l_proc,10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint create_lpm_swi;

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

140: -- messages of any type exist in the Multiple Message List.
141: -- Also disable Multiple Message Detection.
142: --
143: p_return_status := hr_multi_message.get_return_status_disable;
144: hr_utility.set_location(' Leaving:' || l_proc,20);
145: --
146: exception
147: when hr_multi_message.error_message_exist then
148: --

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

155: -- Reset IN OUT parameters and set OUT parameters
156: --
157: p_object_version_number := null;
158: p_return_status := hr_multi_message.get_return_status_disable;
159: hr_utility.set_location(' Leaving:' || l_proc, 30);
160: when others then
161: --
162: -- When Multiple Message Detection is enabled catch
163: -- any Application specific or other unexpected

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

166: -- error.
167: --
168: rollback to create_lpm_swi;
169: if hr_multi_message.unexpected_error_add(l_proc) then
170: hr_utility.set_location(' Leaving:' || l_proc,40);
171: raise;
172: end if;
173: --
174: -- Reset IN OUT and set OUT parameters

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

174: -- Reset IN OUT and set OUT parameters
175: --
176: p_object_version_number := null;
177: p_return_status := hr_multi_message.get_return_status_disable;
178: hr_utility.set_location(' Leaving:' || l_proc,50);
179: end create_learning_path_member;
180: -- ----------------------------------------------------------------------------
181: -- |----------------------< delete_learning_path_member >---------------------|
182: -- ----------------------------------------------------------------------------

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

194: --
195: -- Other variables
196: l_proc varchar2(72) := g_package ||'delete_learning_path_member';
197: Begin
198: hr_utility.set_location(' Entering:' || l_proc,10);
199: --
200: -- Issue a savepoint
201: --
202: savepoint delete_lpm_swi;

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

236: -- messages of any type exist in the Multiple Message List.
237: -- Also disable Multiple Message Detection.
238: --
239: p_return_status := hr_multi_message.get_return_status_disable;
240: hr_utility.set_location(' Leaving:' || l_proc,20);
241: --
242: exception
243: when hr_multi_message.error_message_exist then
244: --

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

250: --
251: -- Reset IN OUT parameters and set OUT parameters
252: --
253: p_return_status := hr_multi_message.get_return_status_disable;
254: hr_utility.set_location(' Leaving:' || l_proc, 30);
255: when others then
256: --
257: -- When Multiple Message Detection is enabled catch
258: -- any Application specific or other unexpected

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

261: -- error.
262: --
263: rollback to delete_lpm_swi;
264: if hr_multi_message.unexpected_error_add(l_proc) then
265: hr_utility.set_location(' Leaving:' || l_proc,40);
266: raise;
267: end if;
268: --
269: -- Reset IN OUT and set OUT parameters

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

268: --
269: -- Reset IN OUT and set OUT parameters
270: --
271: p_return_status := hr_multi_message.get_return_status_disable;
272: hr_utility.set_location(' Leaving:' || l_proc,50);
273: end delete_learning_path_member;
274: -- ----------------------------------------------------------------------------
275: -- |----------------------< update_learning_path_member >---------------------|
276: -- ----------------------------------------------------------------------------

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

316: --
317: -- Other variables
318: l_proc varchar2(72) := g_package ||'update_learning_path_member';
319: Begin
320: hr_utility.set_location(' Entering:' || l_proc,10);
321: --
322: -- Issue a savepoint
323: --
324: savepoint update_lpm_swi;

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

386: -- messages of any type exist in the Multiple Message List.
387: -- Also disable Multiple Message Detection.
388: --
389: p_return_status := hr_multi_message.get_return_status_disable;
390: hr_utility.set_location(' Leaving:' || l_proc,20);
391: --
392: exception
393: when hr_multi_message.error_message_exist then
394: --

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

401: -- Reset IN OUT parameters and set OUT parameters
402: --
403: p_object_version_number := l_object_version_number;
404: p_return_status := hr_multi_message.get_return_status_disable;
405: hr_utility.set_location(' Leaving:' || l_proc, 30);
406: when others then
407: --
408: -- When Multiple Message Detection is enabled catch
409: -- any Application specific or other unexpected

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

412: -- error.
413: --
414: rollback to update_lpm_swi;
415: if hr_multi_message.unexpected_error_add(l_proc) then
416: hr_utility.set_location(' Leaving:' || l_proc,40);
417: raise;
418: end if;
419: --
420: -- Reset IN OUT and set OUT parameters

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

420: -- Reset IN OUT and set OUT parameters
421: --
422: p_object_version_number := l_object_version_number;
423: p_return_status := hr_multi_message.get_return_status_disable;
424: hr_utility.set_location(' Leaving:' || l_proc,50);
425: end update_learning_path_member;
426:
427:
428: FUNCTION check_course_exists

Line 498: hr_utility.set_location(' Step:'|| l_proc, 10);

494: l_return_status VARCHAR2(30);
495: l_max_duration NUMBER;
496: l_proc VARCHAR2(72) := g_package|| 'check_lpm_duration';
497: BEGIN
498: hr_utility.set_location(' Step:'|| l_proc, 10);
499: ota_lp_member_swi.check_all_duration(
500: p_learning_path_id => p_learning_path_id
501: ,p_return_status => l_return_status
502: ,p_max_duration => l_max_duration

Line 504: hr_utility.set_location(' Step:'|| l_proc, 20);

500: p_learning_path_id => p_learning_path_id
501: ,p_return_status => l_return_status
502: ,p_max_duration => l_max_duration
503: );
504: hr_utility.set_location(' Step:'|| l_proc, 20);
505: IF l_return_status = 'E' THEN
506: hr_utility.set_location(' Step:'|| l_proc, 30);
507: fnd_message.set_name('OTA', 'OTA_443100_LPM_DURATION_ERROR');
508: fnd_message.raise_error;

Line 506: hr_utility.set_location(' Step:'|| l_proc, 30);

502: ,p_max_duration => l_max_duration
503: );
504: hr_utility.set_location(' Step:'|| l_proc, 20);
505: IF l_return_status = 'E' THEN
506: hr_utility.set_location(' Step:'|| l_proc, 30);
507: fnd_message.set_name('OTA', 'OTA_443100_LPM_DURATION_ERROR');
508: fnd_message.raise_error;
509: END IF;
510: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

506: hr_utility.set_location(' Step:'|| l_proc, 30);
507: fnd_message.set_name('OTA', 'OTA_443100_LPM_DURATION_ERROR');
508: fnd_message.raise_error;
509: END IF;
510: hr_utility.set_location(' Leaving:'||l_proc, 40);
511: EXCEPTION
512:
513: WHEN app_exception.application_exception THEN
514:

Line 518: hr_utility.set_location(' Leaving:'||l_proc, 42);

514:
515: IF hr_multi_message.exception_add
516: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION') THEN
517:
518: hr_utility.set_location(' Leaving:'||l_proc, 42);
519: RAISE;
520:
521: END IF;
522:

Line 523: hr_utility.set_location(' Leaving:'||l_proc, 44);

519: RAISE;
520:
521: END IF;
522:
523: hr_utility.set_location(' Leaving:'||l_proc, 44);
524: END check_lpm_duration;
525: */
526: end ota_lp_member_swi;