eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LP_MEMBER_API dependencies on HR_UTILITY

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

52: l_object_version_number number;
53: l_effective_date date;
54:
55: begin
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint create_learning_path_member;

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

202: --
203: p_learning_path_member_id := l_learning_path_member_id;
204: p_object_version_number := l_object_version_number;
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 70);
207: exception
208: when hr_api.validate_enabled then
209: --
210: -- As the Validate_Enabled exception has been raised

Line 221: hr_utility.set_location(' Leaving:'||l_proc, 80);

217: -- when validation only mode is being used.)
218: --
219: p_learning_path_member_id := null;
220: p_object_version_number := null;
221: hr_utility.set_location(' Leaving:'||l_proc, 80);
222: when others then
223: --
224: -- A validation or unexpected error has occured
225: --

Line 229: hr_utility.set_location(' Leaving:'||l_proc, 90);

225: --
226: rollback to create_learning_path_member;
227: p_learning_path_member_id := null;
228: p_object_version_number := null;
229: hr_utility.set_location(' Leaving:'||l_proc, 90);
230: raise;
231: end create_learning_path_member;
232: -- ----------------------------------------------------------------------------
233: -- |-------------------------< update_learning_path_member >-------------------|

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

272: l_object_version_number number := p_object_version_number;
273: l_effective_date date;
274:
275: begin
276: hr_utility.set_location('Entering:'|| l_proc, 10);
277: --
278: -- Issue a savepoint
279: --
280: savepoint update_learning_path_member;

Line 419: hr_utility.set_location(' Leaving:'||l_proc, 70);

415: -- Set all output arguments
416: --
417: p_object_version_number := l_object_version_number;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 70);
420: exception
421: when hr_api.validate_enabled then
422: --
423: -- As the Validate_Enabled exception has been raised

Line 433: hr_utility.set_location(' Leaving:'||l_proc, 80);

429: -- (Any key or derived arguments must be set to null
430: -- when validation only mode is being used.)
431: --
432: p_object_version_number := null;
433: hr_utility.set_location(' Leaving:'||l_proc, 80);
434: when others then
435: --
436: -- A validation or unexpected error has occured
437: --

Line 439: hr_utility.set_location(' Leaving:'||l_proc, 90);

435: --
436: -- A validation or unexpected error has occured
437: --
438: rollback to update_learning_path_member;
439: hr_utility.set_location(' Leaving:'||l_proc, 90);
440: p_object_version_number := l_object_version_number;
441: raise;
442: end update_learning_path_member;
443:

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

466: l_lpm_rec get_lpms%ROWTYPE;
467: l_sequence ota_learning_path_members.course_sequence%TYPE;
468: l_proc varchar2(72) := g_package||' order course sequence';
469: BEGIN
470: hr_utility.set_location('Entering:'|| l_proc, 10);
471: OPEN csr_get_lpm_sequence;
472: FETCH csr_get_lpm_sequence INTO l_course_sequence,l_learning_path_id;
473: CLOSE csr_get_lpm_sequence;
474:

Line 487: hr_utility.set_location('Leaving:'|| l_proc, 10);

483: ,p_effective_date => trunc(sysdate)
484: ,p_course_sequence => l_sequence);
485: l_sequence := l_sequence + 1;
486: END LOOP;
487: hr_utility.set_location('Leaving:'|| l_proc, 10);
488: END order_course_sequence;
489: --
490: -- ----------------------------------------------------------------------------
491: -- |-------------------------< delete_learning_path_member >------------------|

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

501: --
502: l_proc varchar2(72) := g_package||' Delete Learning Path Member';
503: --
504: begin
505: hr_utility.set_location('Entering:'|| l_proc, 10);
506: --
507: -- Issue a savepoint
508: --
509: savepoint delete_learning_path_member;

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

559: --
560: -- Set all output arguments
561: --
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 170);
564: exception
565: when hr_api.validate_enabled then
566: --
567: -- As the Validate_Enabled exception has been raised

Line 576: hr_utility.set_location(' Leaving:'||l_proc, 180);

572: -- Only set output warning arguments
573: -- (Any key or derived arguments must be set to null
574: -- when validation only mode is being used.)
575: --
576: hr_utility.set_location(' Leaving:'||l_proc, 180);
577: when others then
578: --
579: -- A validation or unexpected error has occured
580: --

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

578: --
579: -- A validation or unexpected error has occured
580: --
581: rollback to delete_learning_path_member;
582: hr_utility.set_location(' Leaving:'||l_proc, 190);
583: raise;
584: end delete_learning_path_member;
585: --
586: end ota_lp_member_api;