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 935: hr_utility.set_location('Entering:'|| l_proc, 5);

931:
932:
933: BEGIN
934: --
935: hr_utility.set_location('Entering:'|| l_proc, 5);
936: hr_utility.set_location('Old FPD:'|| p_old_final_process_date, 6);
937: hr_utility.set_location('New FPD:'|| p_new_final_process_date, 7);
938: --
939: -- Issue a savepoint.

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

932:
933: BEGIN
934: --
935: hr_utility.set_location('Entering:'|| l_proc, 5);
936: hr_utility.set_location('Old FPD:'|| p_old_final_process_date, 6);
937: hr_utility.set_location('New FPD:'|| p_new_final_process_date, 7);
938: --
939: -- Issue a savepoint.
940: --

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

933: BEGIN
934: --
935: hr_utility.set_location('Entering:'|| l_proc, 5);
936: hr_utility.set_location('Old FPD:'|| p_old_final_process_date, 6);
937: hr_utility.set_location('New FPD:'|| p_new_final_process_date, 7);
938: --
939: -- Issue a savepoint.
940: --
941: SAVEPOINT move_term_assignments;

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

939: -- Issue a savepoint.
940: --
941: SAVEPOINT move_term_assignments;
942: --
943: hr_utility.set_location(l_proc, 10);
944: --
945: -- FPD is changing to an earlier value
946: --
947: IF p_new_final_process_date IS NOT NULL

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

948: AND p_old_final_process_date IS NOT NULL
949: AND p_new_final_process_date < p_old_final_process_date
950: THEN
951: --
952: hr_utility.set_location(l_proc, 20);
953: --
954: -- Check if for any Payroll actions existing after
955: -- the new FPD
956: --

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

957: OPEN csr_compl_pay_act;
958: FETCH csr_compl_pay_act INTO l_dummy;
959: IF csr_compl_pay_act%FOUND THEN
960: CLOSE csr_compl_pay_act;
961: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');
962: hr_utility.raise_error;
963: END IF;
964: CLOSE csr_compl_pay_act;
965: --

Line 962: hr_utility.raise_error;

958: FETCH csr_compl_pay_act INTO l_dummy;
959: IF csr_compl_pay_act%FOUND THEN
960: CLOSE csr_compl_pay_act;
961: hr_utility.set_message(800,'HR_449742_EMP_FPD_PAYACT');
962: hr_utility.raise_error;
963: END IF;
964: CLOSE csr_compl_pay_act;
965: --
966: hr_utility.set_location(l_proc, 30);

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

962: hr_utility.raise_error;
963: END IF;
964: CLOSE csr_compl_pay_act;
965: --
966: hr_utility.set_location(l_proc, 30);
967: --
968: -- For all assignments in the current PDS that ended on
969: -- the old FPD
970: --

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

970: --
971: OPEN csr_pds_asgs;
972: LOOP
973: --
974: hr_utility.set_location(l_proc, 40);
975: --
976: FETCH csr_pds_asgs INTO l_assignment_id
977: ,l_effective_start_date
978: ,l_effective_end_date

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

1008: ,p_asg_future_changes_warning => p_asg_future_changes_warning
1009: ,p_entries_changed_warning => p_entries_changed_warning
1010: );
1011: --
1012: hr_utility.set_location(l_proc, 45);
1013: --
1014: END LOOP;
1015: CLOSE csr_pds_asgs;
1016: --

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

1015: CLOSE csr_pds_asgs;
1016: --
1017: END IF; -- new FPD < old FPD
1018: --
1019: hr_utility.set_location(l_proc, 50);
1020: --
1021: -- FPD is changing to a later value or FPD has been made null
1022: --
1023: IF (p_new_final_process_date IS NOT NULL

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

1026: OR (p_new_final_process_date IS NULL
1027: AND p_old_final_process_date IS NOT NULL)
1028: THEN
1029: --
1030: hr_utility.set_location(l_proc, 60);
1031: --
1032: IF p_new_final_process_date IS NOT NULL
1033: AND p_old_final_process_date IS NOT NULL
1034: AND p_new_final_process_date > p_old_final_process_date

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

1048: --
1049: OPEN csr_pds_asgs;
1050: LOOP
1051: --
1052: hr_utility.set_location(l_proc, 70);
1053: --
1054: FETCH csr_pds_asgs INTO l_assignment_id
1055: ,l_effective_start_date
1056: ,l_effective_end_date

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

1057: ,l_object_version_number
1058: ,l_actual_termination_date;
1059: EXIT WHEN csr_pds_asgs%NOTFOUND;
1060: --
1061: hr_utility.set_location('RowCount:'||SQL%ROWCOUNT, 75);
1062: --
1063: OPEN csr_lock_csa(l_assignment_id); -- Locking ladder step 970
1064: CLOSE csr_lock_csa;
1065: --

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

1086: --
1087: OPEN csr_lock_sas(l_assignment_id); -- Locking ladder step 1590
1088: CLOSE csr_lock_sas;
1089: --
1090: hr_utility.set_location(l_proc, 80);
1091: --
1092:
1093: OPEN csr_get_ast_status_details(l_assignment_id);
1094: FETCH csr_get_ast_status_details INTO l_system_status;

Line 1097: hr_utility.set_location(l_proc, 81);

1093: OPEN csr_get_ast_status_details(l_assignment_id);
1094: FETCH csr_get_ast_status_details INTO l_system_status;
1095: IF csr_get_ast_status_details%FOUND THEN
1096:
1097: hr_utility.set_location(l_proc, 81);
1098:
1099: UPDATE per_assignments_f
1100: SET effective_end_date = l_new_final_process_date
1101: WHERE assignment_id = l_assignment_id

Line 1107: hr_utility.set_location(l_proc, 82);

1103: AND effective_end_date = l_effective_end_date
1104: AND object_version_number = l_object_version_number;
1105:
1106: else
1107: hr_utility.set_location(l_proc, 82);
1108:
1109: l_created_by := fnd_global.user_id;
1110: l_creation_date := sysdate;
1111: l_last_update_date := sysdate;

Line 1120: hr_utility.set_location(l_proc, 83);

1116: OPEN assgn_rec(l_assignment_id);
1117: FETCH assgn_rec INTO l_rec;
1118: CLOSE assgn_rec;
1119:
1120: hr_utility.set_location(l_proc, 83);
1121:
1122: SELECT legislation_code INTO l_legislation_code
1123: FROM per_business_groups
1124: WHERE business_group_id=l_rec.business_group_id;

Line 1126: hr_utility.set_location(l_proc, 84);

1122: SELECT legislation_code INTO l_legislation_code
1123: FROM per_business_groups
1124: WHERE business_group_id=l_rec.business_group_id;
1125:
1126: hr_utility.set_location(l_proc, 84);
1127:
1128: per_people3_pkg.get_default_person_type
1129: (p_required_type => 'TERM_ASSIGN'
1130: ,p_business_group_id => l_rec.business_group_id

Line 1134: hr_utility.set_location(l_proc, 85);

1130: ,p_business_group_id => l_rec.business_group_id
1131: ,p_legislation_code => l_legislation_code
1132: ,p_person_type => l_assignment_status_type_id);
1133:
1134: hr_utility.set_location(l_proc, 85);
1135:
1136: INSERT INTO per_all_assignments_f
1137: ( assignment_id,
1138: effective_start_date,

Line 1373: hr_utility.set_location(l_proc, 86);

1369: l_rec.po_line_id,
1370: l_rec.projected_assignment_end
1371: );
1372:
1373: hr_utility.set_location(l_proc, 86);
1374:
1375: END IF;
1376:
1377: hr_utility.set_location(l_proc, 87);

Line 1377: hr_utility.set_location(l_proc, 87);

1373: hr_utility.set_location(l_proc, 86);
1374:
1375: END IF;
1376:
1377: hr_utility.set_location(l_proc, 87);
1378:
1379: CLOSE csr_get_ast_status_details;
1380:
1381: hr_utility.set_location(l_proc, 88);

Line 1381: hr_utility.set_location(l_proc, 88);

1377: hr_utility.set_location(l_proc, 87);
1378:
1379: CLOSE csr_get_ast_status_details;
1380:
1381: hr_utility.set_location(l_proc, 88);
1382: --
1383: UPDATE pay_cost_allocations_f
1384: SET effective_end_date = l_new_final_process_date
1385: WHERE assignment_id = l_assignment_id

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

1452: SET end_date = l_new_final_process_date
1453: WHERE assignment_id = l_assignment_id
1454: AND NVL(end_date,p_old_final_process_date) = p_old_final_process_date;
1455: --
1456: hr_utility.set_location(l_proc, 90);
1457: --
1458: END LOOP;
1459: CLOSE csr_pds_asgs;
1460: END IF; -- new FPD > old FPD

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

1458: END LOOP;
1459: CLOSE csr_pds_asgs;
1460: END IF; -- new FPD > old FPD
1461: --
1462: hr_utility.set_location('Leaving:'|| l_proc, 100);
1463: --
1464: EXCEPTION
1465: --
1466: WHEN OTHERS THEN

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

1466: WHEN OTHERS THEN
1467: --
1468: -- An unexpected error has occurred
1469: --
1470: hr_utility.set_location(l_proc, 9999);
1471: ROLLBACK TO move_term_assignments;
1472: RAISE;
1473: --
1474: END move_term_assignments;