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_PERIODS_OF_SERVICE_API dependencies on HR_UTILITY

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

282:
283: -- Fix for Bug 5152193 Ends here
284:
285: begin
286: hr_utility.set_location('Entering:'|| l_proc, 5);
287: --
288: -- Issue a savepoint.
289: --
290: savepoint update_pds_details;

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

287: --
288: -- Issue a savepoint.
289: --
290: savepoint update_pds_details;
291: hr_utility.set_location(l_proc, 6);
292: --
293: -- Start of API User Hook for the before hook of final_process_emp.
294: --
295: begin

Line 473: hr_utility.set_location('Update_pds_details ',800);

469: then
470: --
471: -- Fix for bug 3882918. check with nvl for the leaving_reason.
472: --
473: hr_utility.set_location('Update_pds_details ',800);
474: --
475: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2)
476: <> nvl(p_leaving_reason,hr_api.g_varchar2)
477: then

Line 482: hr_utility.set_location('Update_pds_details ',810);

478: --
479: -- Fix for bug 3882918. If this proc is called without leaving_reason parameter
480: -- then no need to check further as it means, user doesn't want to change this value.
481: --
482: hr_utility.set_location('Update_pds_details ',810);
483:
484: --
485: -- Bug number 4900409 - validating actual termination date cannot be future date
486: -- if leaving reason is 'D' Deceased

Line 491: hr_utility.set_location('Update_pds_details ',812);

487:
488: IF nvl(p_leaving_reason,hr_api.g_varchar2)='D' AND
489: (per_pds_shd.g_old_rec.actual_termination_date > SYSDATE) THEN
490:
491: hr_utility.set_location('Update_pds_details ',812);
492: fnd_message.set_name('PER','PER_449766_NO_FUT_ACTUAL_TERM');
493: fnd_message.raise_error;
494:
495: END IF;

Line 497: hr_utility.set_location('Update_pds_details ',818);

493: fnd_message.raise_error;
494:
495: END IF;
496:
497: hr_utility.set_location('Update_pds_details ',818);
498:
499: -- End of changes for 4900409
500:
501: IF not (p_leaving_reason = hr_api.g_varchar2 and p_leaving_reason is not null) THEN

Line 503: hr_utility.set_location('Update_pds_details ',820);

499: -- End of changes for 4900409
500:
501: IF not (p_leaving_reason = hr_api.g_varchar2 and p_leaving_reason is not null) THEN
502: --
503: hr_utility.set_location('Update_pds_details ',820);
504: --
505: if (nvl(p_leaving_reason, hr_api.g_varchar2) = 'R' and
506: nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <> 'R' )
507: then

Line 509: hr_utility.set_location('Update_pds_details ',900);

505: if (nvl(p_leaving_reason, hr_api.g_varchar2) = 'R' and
506: nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <> 'R' )
507: then
508:
509: hr_utility.set_location('Update_pds_details ',900);
510:
511: hr_per_type_usage_internal.create_person_type_usage
512: (p_person_id => per_pds_shd.g_old_rec.person_id
513: ,p_person_type_id =>

Line 527: hr_utility.set_location('Update_pds_details ',910);

523: elsif (nvl(p_leaving_reason, hr_api.g_varchar2) <> 'R' and
524: nvl(per_pds_shd.g_old_rec.leaving_reason,hr_api.g_varchar2) = 'R' )
525: then
526:
527: hr_utility.set_location('Update_pds_details ',910);
528:
529: hr_per_type_usage_internal.maintain_person_type_usage
530: (p_effective_date => per_pds_shd.g_old_rec.actual_termination_date+1
531: ,p_person_id => per_pds_shd.g_old_rec.person_id

Line 557: hr_utility.set_location('Update PER Details ',920);

553:
554: -- per_per_upd.upd updates the Date of Death to Actual Termination Date(ATD)
555:
556: if (l_per_rec.date_of_death is null) then
557: hr_utility.set_location('Update PER Details ',920);
558: per_per_upd.upd
559: (p_person_id => l_pds_rec.person_id
560: ,p_effective_start_date => l_per_rec.effective_start_date
561: ,p_effective_end_date => l_per_rec.effective_end_date

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

590:
591: end if;
592:
593: --
594: hr_utility.set_location(l_proc, 7);
595: --
596: -- When in validation only mode raise the Validate_Enabled exception
597: --
598: --

Line 680: hr_utility.set_location(' Leaving:'||l_proc, 8);

676: if p_validate then
677: raise hr_api.validate_enabled;
678: end if;
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 8);
681: --
682: exception
683: when hr_api.validate_enabled then
684: --

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

906: FOR UPDATE NOWAIT;
907: --
908: BEGIN
909: --
910: hr_utility.set_location('Entering:'|| l_proc, 5);
911: hr_utility.set_location('Old FPD:'|| p_old_final_process_date, 6);
912: hr_utility.set_location('New FPD:'|| p_new_final_process_date, 7);
913: --
914: -- Issue a savepoint.

Line 911: hr_utility.set_location('Old FPD:'|| p_old_final_process_date, 6);

907: --
908: BEGIN
909: --
910: hr_utility.set_location('Entering:'|| l_proc, 5);
911: hr_utility.set_location('Old FPD:'|| p_old_final_process_date, 6);
912: hr_utility.set_location('New FPD:'|| p_new_final_process_date, 7);
913: --
914: -- Issue a savepoint.
915: --

Line 912: hr_utility.set_location('New FPD:'|| p_new_final_process_date, 7);

908: BEGIN
909: --
910: hr_utility.set_location('Entering:'|| l_proc, 5);
911: hr_utility.set_location('Old FPD:'|| p_old_final_process_date, 6);
912: hr_utility.set_location('New FPD:'|| p_new_final_process_date, 7);
913: --
914: -- Issue a savepoint.
915: --
916: SAVEPOINT move_term_assignments;

Line 918: hr_utility.set_location(l_proc, 10);

914: -- Issue a savepoint.
915: --
916: SAVEPOINT move_term_assignments;
917: --
918: hr_utility.set_location(l_proc, 10);
919: --
920: -- FPD is changing to an earlier value
921: --
922: IF p_new_final_process_date IS NOT NULL

Line 927: hr_utility.set_location(l_proc, 20);

923: AND p_old_final_process_date IS NOT NULL
924: AND p_new_final_process_date < p_old_final_process_date
925: THEN
926: --
927: hr_utility.set_location(l_proc, 20);
928: --
929: -- Check if for any Payroll actions existing after
930: -- the new FPD
931: --

Line 936: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');

932: OPEN csr_compl_pay_act;
933: FETCH csr_compl_pay_act INTO l_dummy;
934: IF csr_compl_pay_act%FOUND THEN
935: CLOSE csr_compl_pay_act;
936: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');
937: hr_utility.raise_error;
938: END IF;
939: CLOSE csr_compl_pay_act;
940: --

Line 937: hr_utility.raise_error;

933: FETCH csr_compl_pay_act INTO l_dummy;
934: IF csr_compl_pay_act%FOUND THEN
935: CLOSE csr_compl_pay_act;
936: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');
937: hr_utility.raise_error;
938: END IF;
939: CLOSE csr_compl_pay_act;
940: --
941: hr_utility.set_location(l_proc, 30);

Line 941: hr_utility.set_location(l_proc, 30);

937: hr_utility.raise_error;
938: END IF;
939: CLOSE csr_compl_pay_act;
940: --
941: hr_utility.set_location(l_proc, 30);
942: --
943: -- For all assignments in the current PDS that ended on
944: -- the old FPD
945: --

Line 949: hr_utility.set_location(l_proc, 40);

945: --
946: OPEN csr_pds_asgs;
947: LOOP
948: --
949: hr_utility.set_location(l_proc, 40);
950: --
951: FETCH csr_pds_asgs INTO l_assignment_id
952: ,l_effective_start_date
953: ,l_effective_end_date

Line 987: hr_utility.set_location(l_proc, 45);

983: ,p_asg_future_changes_warning => p_asg_future_changes_warning
984: ,p_entries_changed_warning => p_entries_changed_warning
985: );
986: --
987: hr_utility.set_location(l_proc, 45);
988: --
989: END LOOP;
990: CLOSE csr_pds_asgs;
991: --

Line 994: hr_utility.set_location(l_proc, 50);

990: CLOSE csr_pds_asgs;
991: --
992: END IF; -- new FPD < old FPD
993: --
994: hr_utility.set_location(l_proc, 50);
995: --
996: -- FPD is changing to a later value or FPD has been made null
997: --
998: IF (p_new_final_process_date IS NOT NULL

Line 1005: hr_utility.set_location(l_proc, 60);

1001: OR (p_new_final_process_date IS NULL
1002: AND p_old_final_process_date IS NOT NULL)
1003: THEN
1004: --
1005: hr_utility.set_location(l_proc, 60);
1006: --
1007: IF p_new_final_process_date IS NOT NULL
1008: AND p_old_final_process_date IS NOT NULL
1009: AND p_new_final_process_date > p_old_final_process_date

Line 1027: hr_utility.set_location(l_proc, 70);

1023: --
1024: OPEN csr_pds_asgs;
1025: LOOP
1026: --
1027: hr_utility.set_location(l_proc, 70);
1028: --
1029: FETCH csr_pds_asgs INTO l_assignment_id
1030: ,l_effective_start_date
1031: ,l_effective_end_date

Line 1036: hr_utility.set_location('RowCount:'||SQL%ROWCOUNT, 75);

1032: ,l_object_version_number
1033: ,l_actual_termination_date;
1034: EXIT WHEN csr_pds_asgs%NOTFOUND;
1035: --
1036: hr_utility.set_location('RowCount:'||SQL%ROWCOUNT, 75);
1037: --
1038: OPEN csr_lock_csa(l_assignment_id); -- Locking ladder step 970
1039: CLOSE csr_lock_csa;
1040: --

Line 1065: hr_utility.set_location(l_proc, 80);

1061: --
1062: OPEN csr_lock_sas(l_assignment_id); -- Locking ladder step 1590
1063: CLOSE csr_lock_sas;
1064: --
1065: hr_utility.set_location(l_proc, 80);
1066: --
1067: UPDATE per_assignments_f
1068: SET effective_end_date = l_new_final_process_date
1069: WHERE assignment_id = l_assignment_id

Line 1146: hr_utility.set_location(l_proc, 90);

1142: SET end_date = l_new_final_process_date
1143: WHERE assignment_id = l_assignment_id
1144: AND NVL(end_date,p_old_final_process_date) = p_old_final_process_date;
1145: --
1146: hr_utility.set_location(l_proc, 90);
1147: --
1148: END LOOP;
1149: CLOSE csr_pds_asgs;
1150: END IF; -- new FPD > old FPD

Line 1152: hr_utility.set_location('Leaving:'|| l_proc, 100);

1148: END LOOP;
1149: CLOSE csr_pds_asgs;
1150: END IF; -- new FPD > old FPD
1151: --
1152: hr_utility.set_location('Leaving:'|| l_proc, 100);
1153: --
1154: EXCEPTION
1155: --
1156: WHEN OTHERS THEN

Line 1160: hr_utility.set_location(l_proc, 9999);

1156: WHEN OTHERS THEN
1157: --
1158: -- An unexpected error has occurred
1159: --
1160: hr_utility.set_location(l_proc, 9999);
1161: ROLLBACK TO move_term_assignments;
1162: RAISE;
1163: --
1164: END move_term_assignments;