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.HR_APPRAISALS_API dependencies on HR_UTILITY

Line 96: hr_utility.set_location('Entering:'|| l_proc, 5);

92: l_appraisal_id per_appraisals.appraisal_id%TYPE;
93: l_object_version_number per_appraisals.object_version_number%TYPE;
94:
95: begin
96: hr_utility.set_location('Entering:'|| l_proc, 5);
97: --
98: -- Issue a savepoint.
99: --
100: savepoint create_appraisal;

Line 101: hr_utility.set_location(l_proc, 6);

97: --
98: -- Issue a savepoint.
99: --
100: savepoint create_appraisal;
101: hr_utility.set_location(l_proc, 6);
102: --
103: -- Call Before Process User Hook
104: --
105: begin

Line 189: hr_utility.set_location(l_proc, 7);

185: -- End of Before Process User Hook call
186: --
187: -- Validation in addition to Table Handlers
188: --
189: hr_utility.set_location(l_proc, 7);
190: --
191: -- Process Logic
192: --
193: per_apr_ins.ins

Line 268: hr_utility.set_location(l_proc, 8);

264: p_retention_potential => p_retention_potential,
265: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
266: );
267: --
268: hr_utility.set_location(l_proc, 8);
269: --
270: -- Call After Process User Hook
271: --
272: begin

Line 366: hr_utility.set_location(' Leaving:'||l_proc, 11);

362: --
363: p_appraisal_id := l_appraisal_id;
364: p_object_version_number := l_object_version_number;
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 11);
367: exception
368: when hr_api.validate_enabled then
369: --
370: -- As the Validate_Enabled exception has been raised

Line 393: hr_utility.set_location(' Leaving:'||l_proc, 12);

389: raise;
390: --
391: -- End of fix.
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 12);
394: end create_appraisal;
395: --
396: --
397: -- ---------------------------------------------------------------------------

Line 471: if (hr_utility.debug_enabled) then

467: when others then
468: if (dynamic_ota_cursor%ISOPEN) then
469: close dynamic_ota_cursor;
470: end if;
471: if (hr_utility.debug_enabled) then
472: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpme_query' || sqlerrm, 1);
473: end if;
474: end;
475: end if;

Line 472: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpme_query' || sqlerrm, 1);

468: if (dynamic_ota_cursor%ISOPEN) then
469: close dynamic_ota_cursor;
470: end if;
471: if (hr_utility.debug_enabled) then
472: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpme_query' || sqlerrm, 1);
473: end if;
474: end;
475: end if;
476:

Line 494: if (hr_utility.debug_enabled) then

490: when others then
491: if (dynamic_ota_cursor%ISOPEN) then
492: close dynamic_ota_cursor;
493: end if;
494: if (hr_utility.debug_enabled) then
495: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpe_query' || sqlerrm, 1);
496: end if;
497: end;
498: end if;

Line 495: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpe_query' || sqlerrm, 1);

491: if (dynamic_ota_cursor%ISOPEN) then
492: close dynamic_ota_cursor;
493: end if;
494: if (hr_utility.debug_enabled) then
495: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpe_query' || sqlerrm, 1);
496: end if;
497: end;
498: end if;
499: end if;

Line 507: if (hr_utility.debug_enabled) then

503: if (dynamic_ota_cursor%ISOPEN) then
504: close dynamic_ota_cursor;
505: end if;
506: if ((l_ota_error_num= -904) or (l_ota_error_num = -6550) or (l_ota_error_num = -942)) then
507: if (hr_utility.debug_enabled) then
508: hr_utility.set_location('Oracle iLearning (OTA) is not installed. Contact your System Administrator', 1);
509: end if;
510: else
511: raise;

Line 508: hr_utility.set_location('Oracle iLearning (OTA) is not installed. Contact your System Administrator', 1);

504: close dynamic_ota_cursor;
505: end if;
506: if ((l_ota_error_num= -904) or (l_ota_error_num = -6550) or (l_ota_error_num = -942)) then
507: if (hr_utility.debug_enabled) then
508: hr_utility.set_location('Oracle iLearning (OTA) is not installed. Contact your System Administrator', 1);
509: end if;
510: else
511: raise;
512: end if;

Line 766: hr_utility.set_location('Entering:'|| l_proc, 5);

762: END Get_Old_Main_Appraiser_Id;
763:
764: --
765: begin
766: hr_utility.set_location('Entering:'|| l_proc, 5);
767: --
768: -- Issue a savepoint.
769: --
770: savepoint update_appraisal;

Line 771: hr_utility.set_location(l_proc, 6);

767: --
768: -- Issue a savepoint.
769: --
770: savepoint update_appraisal;
771: hr_utility.set_location(l_proc, 6);
772: --
773: --
774: -- Call Before Process User Hook
775: --

Line 857: hr_utility.set_location(l_proc, 7);

853: -- End of Before Process User Hook call
854: --
855: -- Validation in addition to Table Handlers
856: --
857: hr_utility.set_location(l_proc, 7);
858: --
859: -- Process Logic
860: --
861: open get_appraisee_person_id(p_appraisal_id);

Line 876: hr_utility.set_location('l_appraisee_person_id:'|| l_appraisee_person_id, 5);

872: l_old_mainap_id := get_old_main_appraiser_id (p_appraisal_id);
873: l_appraiser_person_id := p_appraiser_person_id;
874:
875:
876: hr_utility.set_location('l_appraisee_person_id:'|| l_appraisee_person_id, 5);
877: hr_utility.set_location('l_old_mainap_id:'|| l_old_mainap_id, 5);
878: hr_utility.set_location('l_appraiser_person_id:'|| l_appraiser_person_id, 5);
879: hr_utility.set_location('l_appraisal_sys_status:'|| l_appraisal_sys_status, 5);
880: hr_utility.set_location('p_main_appraiser_id:'|| p_main_appraiser_id, 5);

Line 877: hr_utility.set_location('l_old_mainap_id:'|| l_old_mainap_id, 5);

873: l_appraiser_person_id := p_appraiser_person_id;
874:
875:
876: hr_utility.set_location('l_appraisee_person_id:'|| l_appraisee_person_id, 5);
877: hr_utility.set_location('l_old_mainap_id:'|| l_old_mainap_id, 5);
878: hr_utility.set_location('l_appraiser_person_id:'|| l_appraiser_person_id, 5);
879: hr_utility.set_location('l_appraisal_sys_status:'|| l_appraisal_sys_status, 5);
880: hr_utility.set_location('p_main_appraiser_id:'|| p_main_appraiser_id, 5);
881:

Line 878: hr_utility.set_location('l_appraiser_person_id:'|| l_appraiser_person_id, 5);

874:
875:
876: hr_utility.set_location('l_appraisee_person_id:'|| l_appraisee_person_id, 5);
877: hr_utility.set_location('l_old_mainap_id:'|| l_old_mainap_id, 5);
878: hr_utility.set_location('l_appraiser_person_id:'|| l_appraiser_person_id, 5);
879: hr_utility.set_location('l_appraisal_sys_status:'|| l_appraisal_sys_status, 5);
880: hr_utility.set_location('p_main_appraiser_id:'|| p_main_appraiser_id, 5);
881:
882:

Line 879: hr_utility.set_location('l_appraisal_sys_status:'|| l_appraisal_sys_status, 5);

875:
876: hr_utility.set_location('l_appraisee_person_id:'|| l_appraisee_person_id, 5);
877: hr_utility.set_location('l_old_mainap_id:'|| l_old_mainap_id, 5);
878: hr_utility.set_location('l_appraiser_person_id:'|| l_appraiser_person_id, 5);
879: hr_utility.set_location('l_appraisal_sys_status:'|| l_appraisal_sys_status, 5);
880: hr_utility.set_location('p_main_appraiser_id:'|| p_main_appraiser_id, 5);
881:
882:
883: IF l_old_mainap_id IS NOT NULL

Line 880: hr_utility.set_location('p_main_appraiser_id:'|| p_main_appraiser_id, 5);

876: hr_utility.set_location('l_appraisee_person_id:'|| l_appraisee_person_id, 5);
877: hr_utility.set_location('l_old_mainap_id:'|| l_old_mainap_id, 5);
878: hr_utility.set_location('l_appraiser_person_id:'|| l_appraiser_person_id, 5);
879: hr_utility.set_location('l_appraisal_sys_status:'|| l_appraisal_sys_status, 5);
880: hr_utility.set_location('p_main_appraiser_id:'|| p_main_appraiser_id, 5);
881:
882:
883: IF l_old_mainap_id IS NOT NULL
884: AND p_main_appraiser_id <> hr_api.g_number THEN

Line 889: hr_utility.set_location('l_appraiser_person_id:'|| l_appraiser_person_id, 50);

885: IF l_old_mainap_id <> p_main_appraiser_id THEN
886: IF (l_appraisal_sys_status IN ('PLANNED','SAVED')
887: AND p_appraiser_person_id <> l_appraisee_person_id) THEN
888: l_appraiser_person_id := p_main_appraiser_id;
889: hr_utility.set_location('l_appraiser_person_id:'|| l_appraiser_person_id, 50);
890: END IF;
891:
892: Get_Participant_id(p_appraisal_id, l_old_mainap_id, l_participant_id_1, l_part_object_version_number_1);
893: -- if old MA is a Participant change his Type

Line 992: hr_utility.set_location(l_proc, 8);

988: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
989: );
990: --
991: --
992: hr_utility.set_location(l_proc, 8);
993: --
994: -- Update the assessment if necessary (as the appraisal_period_start_date and
995: -- appraisal_period_end_date may have changed which would affect an assessment
996: -- if there is one attached to this appraisal)

Line 1111: hr_utility.set_location(' Leaving:'||l_proc, 11);

1107: -- object version number as the update was successful
1108: --
1109: p_object_version_number := l_object_version_number;
1110: --
1111: hr_utility.set_location(' Leaving:'||l_proc, 11);
1112: exception
1113: when hr_api.validate_enabled then
1114: --
1115: -- As the Validate_Enabled exception has been raised

Line 1140: hr_utility.set_location(' Leaving:'||l_proc, 12);

1136: raise;
1137: --
1138: -- End of fix.
1139: --
1140: hr_utility.set_location(' Leaving:'||l_proc, 12);
1141: --
1142: end update_appraisal;
1143: --
1144: --

Line 1237: hr_utility.set_location('Entering:'|| l_proc, 5);

1233: l_ota_error_num NUMBER;
1234: l_ota_installed VARCHAR2(10);
1235:
1236: begin
1237: hr_utility.set_location('Entering:'|| l_proc, 5);
1238: --
1239: -- Issue a savepoint.
1240: --
1241: savepoint delete_appraisal;

Line 1242: hr_utility.set_location(l_proc, 6);

1238: --
1239: -- Issue a savepoint.
1240: --
1241: savepoint delete_appraisal;
1242: hr_utility.set_location(l_proc, 6);
1243: --
1244: --
1245: -- Call Before Process User Hook
1246: --

Line 1265: hr_utility.set_location(l_proc, 7);

1261: -- End of before process hook
1262: --
1263: -- Validation in addition to Table Handlers
1264: --
1265: hr_utility.set_location(l_proc, 7);
1266: --
1267: -- Process Logic
1268: --
1269:

Line 1402: hr_utility.set_location(l_proc, 8);

1398: ,p_appraisal_id => p_appraisal_id
1399: ,p_object_version_number => p_object_version_number
1400: );
1401: --
1402: hr_utility.set_location(l_proc, 8);
1403: --
1404: -- Call After Process User Hook
1405: --
1406: begin

Line 1427: hr_utility.set_location(' Leaving:'||l_proc, 11);

1423: if p_validate then
1424: raise hr_api.validate_enabled;
1425: end if;
1426: --
1427: hr_utility.set_location(' Leaving:'||l_proc, 11);
1428: exception
1429: when hr_api.validate_enabled then
1430: --
1431: -- As the Validate_Enabled exception has been raised

Line 1448: hr_utility.set_location(' Leaving:'||l_proc, 12);

1444: raise;
1445: --
1446: -- End of fix.
1447: --
1448: hr_utility.set_location(' Leaving:'||l_proc, 12);
1449: end delete_appraisal;
1450: --
1451: end hr_appraisals_api;