90: l_appraisal_id per_appraisals.appraisal_id%TYPE;
91: l_object_version_number per_appraisals.object_version_number%TYPE;
92:
93: begin
94: hr_utility.set_location('Entering:'|| l_proc, 5);
95: --
96: -- Issue a savepoint.
97: --
98: savepoint create_appraisal;
95: --
96: -- Issue a savepoint.
97: --
98: savepoint create_appraisal;
99: hr_utility.set_location(l_proc, 6);
100: --
101: -- Call Before Process User Hook
102: --
103: begin
181: -- End of Before Process User Hook call
182: --
183: -- Validation in addition to Table Handlers
184: --
185: hr_utility.set_location(l_proc, 7);
186: --
187: -- Process Logic
188: --
189: per_apr_ins.ins
258: p_plan_id => p_plan_id,
259: p_offline_status => p_offline_status
260: );
261: --
262: hr_utility.set_location(l_proc, 8);
263: --
264: -- Call After Process User Hook
265: --
266: begin
354: --
355: p_appraisal_id := l_appraisal_id;
356: p_object_version_number := l_object_version_number;
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 11);
359: exception
360: when hr_api.validate_enabled then
361: --
362: -- As the Validate_Enabled exception has been raised
381: raise;
382: --
383: -- End of fix.
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 12);
386: end create_appraisal;
387: --
388: --
389: -- ---------------------------------------------------------------------------
459: when others then
460: if (dynamic_ota_cursor%ISOPEN) then
461: close dynamic_ota_cursor;
462: end if;
463: if (hr_utility.debug_enabled) then
464: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpme_query' || sqlerrm, 1);
465: end if;
466: end;
467: end if;
460: if (dynamic_ota_cursor%ISOPEN) then
461: close dynamic_ota_cursor;
462: end if;
463: if (hr_utility.debug_enabled) then
464: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpme_query' || sqlerrm, 1);
465: end if;
466: end;
467: end if;
468:
482: when others then
483: if (dynamic_ota_cursor%ISOPEN) then
484: close dynamic_ota_cursor;
485: end if;
486: if (hr_utility.debug_enabled) then
487: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpe_query' || sqlerrm, 1);
488: end if;
489: end;
490: end if;
483: if (dynamic_ota_cursor%ISOPEN) then
484: close dynamic_ota_cursor;
485: end if;
486: if (hr_utility.debug_enabled) then
487: hr_utility.set_location('Exception raised in update_learning_path while executing dynamic sql dynamic_ota_lpe_query' || sqlerrm, 1);
488: end if;
489: end;
490: end if;
491: end if;
495: if (dynamic_ota_cursor%ISOPEN) then
496: close dynamic_ota_cursor;
497: end if;
498: if ((l_ota_error_num= -904) or (l_ota_error_num = -6550) or (l_ota_error_num = -942)) then
499: if (hr_utility.debug_enabled) then
500: hr_utility.set_location('Oracle iLearning (OTA) is not installed. Contact your System Administrator', 1);
501: end if;
502: else
503: raise;
496: close dynamic_ota_cursor;
497: end if;
498: if ((l_ota_error_num= -904) or (l_ota_error_num = -6550) or (l_ota_error_num = -942)) then
499: if (hr_utility.debug_enabled) then
500: hr_utility.set_location('Oracle iLearning (OTA) is not installed. Contact your System Administrator', 1);
501: end if;
502: else
503: raise;
504: end if;
744: END IF;
745: END Get_Old_Main_Appraiser_Id;
746: --
747: begin
748: hr_utility.set_location('Entering:'|| l_proc, 5);
749: --
750: -- Issue a savepoint.
751: --
752: savepoint update_appraisal;
749: --
750: -- Issue a savepoint.
751: --
752: savepoint update_appraisal;
753: hr_utility.set_location(l_proc, 6);
754: --
755: --
756: -- Call Before Process User Hook
757: --
833: -- End of Before Process User Hook call
834: --
835: -- Validation in addition to Table Handlers
836: --
837: hr_utility.set_location(l_proc, 7);
838: --
839: -- Process Logic
840: --
841: l_object_version_number := p_object_version_number;
919: p_offline_status => p_offline_status
920: );
921: --
922: --
923: hr_utility.set_location(l_proc, 8);
924: --
925: -- Update the assessment if necessary (as the appraisal_period_start_date and
926: -- appraisal_period_end_date may have changed which would affect an assessment
927: -- if there is one attached to this appraisal)
1059: -- object version number as the update was successful
1060: --
1061: p_object_version_number := l_object_version_number;
1062: --
1063: hr_utility.set_location(' Leaving:'||l_proc, 11);
1064: exception
1065: when hr_api.validate_enabled then
1066: --
1067: -- As the Validate_Enabled exception has been raised
1088: raise;
1089: --
1090: -- End of fix.
1091: --
1092: hr_utility.set_location(' Leaving:'||l_proc, 12);
1093: --
1094: end update_appraisal;
1095: --
1096: --
1185: l_ota_error_num NUMBER;
1186: l_ota_installed VARCHAR2(10);
1187:
1188: begin
1189: hr_utility.set_location('Entering:'|| l_proc, 5);
1190: --
1191: -- Issue a savepoint.
1192: --
1193: savepoint delete_appraisal;
1190: --
1191: -- Issue a savepoint.
1192: --
1193: savepoint delete_appraisal;
1194: hr_utility.set_location(l_proc, 6);
1195: --
1196: --
1197: -- Call Before Process User Hook
1198: --
1213: -- End of before process hook
1214: --
1215: -- Validation in addition to Table Handlers
1216: --
1217: hr_utility.set_location(l_proc, 7);
1218: --
1219: -- Process Logic
1220: --
1221:
1350: ,p_appraisal_id => p_appraisal_id
1351: ,p_object_version_number => p_object_version_number
1352: );
1353: --
1354: hr_utility.set_location(l_proc, 8);
1355: --
1356: -- Call After Process User Hook
1357: --
1358: begin
1375: if p_validate then
1376: raise hr_api.validate_enabled;
1377: end if;
1378: --
1379: hr_utility.set_location(' Leaving:'||l_proc, 11);
1380: exception
1381: when hr_api.validate_enabled then
1382: --
1383: -- As the Validate_Enabled exception has been raised
1396: raise;
1397: --
1398: -- End of fix.
1399: --
1400: hr_utility.set_location(' Leaving:'||l_proc, 12);
1401: end delete_appraisal;
1402: --
1403: end hr_appraisals_api;