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

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

21: --
22: begin
23: if p_status = 'SUPERVISOR' then
24: begin
25: hr_utility.set_location(l_proc,10);
26: Select 'X'
27: into v_dummy
28: from sys.dual
29: where exists (select 'Assignments Exist'

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

42: return;
43: end;
44: elsif p_status = 'EVENT' then
45: begin
46: hr_utility.set_location(l_proc,30);
47: select 'X'
48: into v_dummy
49: from sys.dual
50: where exists ( select 'Events exist'

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

66: end;
67: end if;
68: if p_status = 'INTERVIEW' then
69: begin
70: hr_utility.set_location(l_proc,40);
71: select 'X'
72: into v_dummy
73: from sys.dual
74: where exists(select 'Interview rows exist'

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

98: end;
99: end if;
100: if p_status = 'REVIEW' then
101: begin
102: hr_utility.set_location(l_proc,50);
103: select 'X'
104: into v_dummy
105: from sys.dual
106: where exists ( select 'Perf Review rows exist'

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

116: end;
117: end if;
118: if p_status = 'RECRUITER' then
119: begin
120: hr_utility.set_location(l_proc,60);
121: select 'X'
122: into v_dummy
123: from sys.dual
124: where exists (select 'Recruiter for vacancy'

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

174: l_proc varchar2(100) := g_package||'.actual_termination_emp';
175:
176: begin
177:
178: hr_utility.set_location('Entering '||l_proc,10);
179:
180: if p_last_standard_process_date is null
181: then
182: /* No LSPD has been passed. To preserve the previous

Line 216: hr_utility.set_location('Leaving '||l_proc,40);

212: ,p_alu_change_warning => l_alu_change_warning);
213:
214: p_last_standard_process_date := l_last_std_process_date_out;
215:
216: hr_utility.set_location('Leaving '||l_proc,40);
217:
218: end actual_termination_emp;
219: --
220: -- 120.2 (END)

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

265: l_proc varchar2(100) := g_package||'.actual_termination_emp';
266:
267: begin
268:
269: hr_utility.set_location('Entering '||l_proc,10);
270:
271: if p_last_standard_process_date is null
272: then
273: /* No LSPD has been passed. To preserve the previous

Line 323: hr_utility.set_location('Leaving '||l_proc,40);

319: --
320:
321: p_last_standard_process_date := l_last_std_process_date_out;
322:
323: hr_utility.set_location('Leaving '||l_proc,40);
324:
325: end actual_termination_emp;
326:
327: --

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

760: --
761:
762: --
763: begin
764: hr_utility.set_location('Entering:'|| l_proc, 10);
765: --
766: -- Issue a savepoint.
767: --
768: savepoint actual_termination_emp;

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

777: l_actual_termination_date := trunc(p_actual_termination_date);
778: l_effective_date := trunc(p_effective_date);
779: l_applicant_number := hr_api.g_varchar2;
780: --
781: hr_utility.set_location(l_proc, 20);
782: --
783: -- Validation in addition to Table Handlers
784: --
785: -- Check period of service and get business group details for validation.

Line 802: hr_utility.set_location(' Check Actual termination date for Deceased Leaving Reason ' , 25);

798: --
799: -- Bug number 4900409 - validating actual termination date cannot be future date
800: -- if leaving reason is 'D' Deceased
801:
802: hr_utility.set_location(' Check Actual termination date for Deceased Leaving Reason ' , 25);
803: hr_utility.set_location( ' p_leaving_reason ' ||p_leaving_reason , 25);
804: hr_utility.set_location( ' p_actual_termination_date' ||p_leaving_reason , 25);
805:
806: IF p_leaving_reason = 'D' THEN

Line 803: hr_utility.set_location( ' p_leaving_reason ' ||p_leaving_reason , 25);

799: -- Bug number 4900409 - validating actual termination date cannot be future date
800: -- if leaving reason is 'D' Deceased
801:
802: hr_utility.set_location(' Check Actual termination date for Deceased Leaving Reason ' , 25);
803: hr_utility.set_location( ' p_leaving_reason ' ||p_leaving_reason , 25);
804: hr_utility.set_location( ' p_actual_termination_date' ||p_leaving_reason , 25);
805:
806: IF p_leaving_reason = 'D' THEN
807: IF p_actual_termination_date > SYSDATE THEN

Line 804: hr_utility.set_location( ' p_actual_termination_date' ||p_leaving_reason , 25);

800: -- if leaving reason is 'D' Deceased
801:
802: hr_utility.set_location(' Check Actual termination date for Deceased Leaving Reason ' , 25);
803: hr_utility.set_location( ' p_leaving_reason ' ||p_leaving_reason , 25);
804: hr_utility.set_location( ' p_actual_termination_date' ||p_leaving_reason , 25);
805:
806: IF p_leaving_reason = 'D' THEN
807: IF p_actual_termination_date > SYSDATE THEN
808:

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

811:
812: END IF;
813: END IF;
814:
815: hr_utility.set_location(l_proc, 30);
816: --
817: open csr_get_derived_details;
818: fetch csr_get_derived_details
819: into l_business_group_id

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

829: --
830: if csr_get_derived_details%NOTFOUND
831: then
832: --
833: hr_utility.set_location(l_proc, 40);
834: --
835: close csr_get_derived_details;
836: --
837: hr_utility.set_message(801,'HR_6537_EMP_DATE_START'); --Bug 3929991.

Line 837: hr_utility.set_message(801,'HR_6537_EMP_DATE_START'); --Bug 3929991.

833: hr_utility.set_location(l_proc, 40);
834: --
835: close csr_get_derived_details;
836: --
837: hr_utility.set_message(801,'HR_6537_EMP_DATE_START'); --Bug 3929991.
838: hr_utility.raise_error;
839: end if;
840: --
841: close csr_get_derived_details;

Line 838: hr_utility.raise_error;

834: --
835: close csr_get_derived_details;
836: --
837: hr_utility.set_message(801,'HR_6537_EMP_DATE_START'); --Bug 3929991.
838: hr_utility.raise_error;
839: end if;
840: --
841: close csr_get_derived_details;
842:

Line 854: hr_utility.set_message(800, 'HR_449770_GLD_SRC_BG');

850: /* and (p_actual_termination_date between l_src_bg_rec.START_DATE
851: and nvl(l_src_bg_rec.END_DATE,hr_api.g_eot))) */
852: then
853:
854: hr_utility.set_message(800, 'HR_449770_GLD_SRC_BG');
855: hr_utility.raise_error;
856:
857: end if;
858: end LOOP;

Line 855: hr_utility.raise_error;

851: and nvl(l_src_bg_rec.END_DATE,hr_api.g_eot))) */
852: then
853:
854: hr_utility.set_message(800, 'HR_449770_GLD_SRC_BG');
855: hr_utility.raise_error;
856:
857: end if;
858: end LOOP;
859:

Line 870: hr_utility.set_message(800, 'HR_449771_GLD_DEST_BG');

866: /* and (p_actual_termination_date between l_dest_bg_rec.START_DATE
867: and nvl(l_dest_bg_rec.END_DATE,hr_api.g_eot))) */
868: then
869:
870: hr_utility.set_message(800, 'HR_449771_GLD_DEST_BG');
871: hr_utility.raise_error;
872:
873: end if;
874: end LOOP;

Line 871: hr_utility.raise_error;

867: and nvl(l_dest_bg_rec.END_DATE,hr_api.g_eot))) */
868: then
869:
870: hr_utility.set_message(800, 'HR_449771_GLD_DEST_BG');
871: hr_utility.raise_error;
872:
873: end if;
874: end LOOP;
875:

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

963: end;
964: --
965: -- End of API User Hook for the before hook of actual_termination
966: --
967: hr_utility.set_location(l_proc, 50);
968: hr_utility.set_location('Saved ATD: '||l_saved_atd, 51);
969: hr_utility.set_location('Saved LSPD: '||l_saved_lspd, 51);
970: hr_utility.set_location('Passed LSPD: '||l_last_standard_process_date, 51);
971: --

Line 968: hr_utility.set_location('Saved ATD: '||l_saved_atd, 51);

964: --
965: -- End of API User Hook for the before hook of actual_termination
966: --
967: hr_utility.set_location(l_proc, 50);
968: hr_utility.set_location('Saved ATD: '||l_saved_atd, 51);
969: hr_utility.set_location('Saved LSPD: '||l_saved_lspd, 51);
970: hr_utility.set_location('Passed LSPD: '||l_last_standard_process_date, 51);
971: --
972: -- Determine if we are setting LSPD as a separate call to the API. i.e. ATD

Line 969: hr_utility.set_location('Saved LSPD: '||l_saved_lspd, 51);

965: -- End of API User Hook for the before hook of actual_termination
966: --
967: hr_utility.set_location(l_proc, 50);
968: hr_utility.set_location('Saved ATD: '||l_saved_atd, 51);
969: hr_utility.set_location('Saved LSPD: '||l_saved_lspd, 51);
970: hr_utility.set_location('Passed LSPD: '||l_last_standard_process_date, 51);
971: --
972: -- Determine if we are setting LSPD as a separate call to the API. i.e. ATD
973: -- has already been saved with a null LSPD,

Line 970: hr_utility.set_location('Passed LSPD: '||l_last_standard_process_date, 51);

966: --
967: hr_utility.set_location(l_proc, 50);
968: hr_utility.set_location('Saved ATD: '||l_saved_atd, 51);
969: hr_utility.set_location('Saved LSPD: '||l_saved_lspd, 51);
970: hr_utility.set_location('Passed LSPD: '||l_last_standard_process_date, 51);
971: --
972: -- Determine if we are setting LSPD as a separate call to the API. i.e. ATD
973: -- has already been saved with a null LSPD,
974: --

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

979: -- We are processing a save to LSPD as a separate call to this API.
980: --
981: if p_last_standard_process_date = hr_api.g_date
982: then
983: hr_utility.set_location(l_proc, 60);
984: --
985: -- Last standard process date is the default value i.e.
986: -- it was not passed to the API => derive it.
987: --

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

993: --
994: if csr_get_max_tpe_end_date%NOTFOUND
995: then
996: --
997: hr_utility.set_location(l_proc, 70);
998: --
999: close csr_get_max_tpe_end_date;
1000: --
1001: -- As the cursor should always return at least a null value, this

Line 1004: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1000: --
1001: -- As the cursor should always return at least a null value, this
1002: -- should never happen!
1003: --
1004: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1005: hr_utility.set_message_token('PROCEDURE', l_proc);
1006: hr_utility.set_message_token('STEP','175');
1007: hr_utility.raise_error;
1008: end if;

Line 1005: hr_utility.set_message_token('PROCEDURE', l_proc);

1001: -- As the cursor should always return at least a null value, this
1002: -- should never happen!
1003: --
1004: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1005: hr_utility.set_message_token('PROCEDURE', l_proc);
1006: hr_utility.set_message_token('STEP','175');
1007: hr_utility.raise_error;
1008: end if;
1009: --

Line 1006: hr_utility.set_message_token('STEP','175');

1002: -- should never happen!
1003: --
1004: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1005: hr_utility.set_message_token('PROCEDURE', l_proc);
1006: hr_utility.set_message_token('STEP','175');
1007: hr_utility.raise_error;
1008: end if;
1009: --
1010: close csr_get_max_tpe_end_date;

Line 1007: hr_utility.raise_error;

1003: --
1004: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1005: hr_utility.set_message_token('PROCEDURE', l_proc);
1006: hr_utility.set_message_token('STEP','175');
1007: hr_utility.raise_error;
1008: end if;
1009: --
1010: close csr_get_max_tpe_end_date;
1011: --

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

1008: end if;
1009: --
1010: close csr_get_max_tpe_end_date;
1011: --
1012: hr_utility.set_location(l_proc, 80);
1013: --
1014: if l_max_tpe_end_date is not null
1015: then
1016: --

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

1013: --
1014: if l_max_tpe_end_date is not null
1015: then
1016: --
1017: hr_utility.set_location(l_proc, 90);
1018: --
1019: -- A time period end date has been found, so set the last standard
1020: -- process date to that.
1021: --

Line 1025: hr_utility.set_location(l_proc, 100);

1021: --
1022: l_last_standard_process_date := l_max_tpe_end_date;
1023: else
1024: --
1025: hr_utility.set_location(l_proc, 100);
1026: --
1027: -- Either there was not an assignment assigned to a payroll, or
1028: -- there was no time period for that payroll as of the actual
1029: -- termination date. It doesn't matter which as we will default

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

1122: --
1123: if l_cr_entries_changed_warn = 'S' or
1124: l_entries_changed_warning = 'S' then
1125: --
1126: hr_utility.set_location(l_proc, 110);
1127: --
1128: l_entries_changed_warning := 'S';
1129: --
1130: elsif l_cr_entries_changed_warn = 'Y' or

Line 1133: hr_utility.set_location(l_proc, 120);

1129: --
1130: elsif l_cr_entries_changed_warn = 'Y' or
1131: l_entries_changed_warning = 'Y' then
1132: --
1133: hr_utility.set_location(l_proc, 120);
1134: --
1135: l_entries_changed_warning := 'Y';
1136:
1137: else

Line 1139: hr_utility.set_location(l_proc, 130);

1135: l_entries_changed_warning := 'Y';
1136:
1137: else
1138: --
1139: hr_utility.set_location(l_proc, 130);
1140: --
1141: l_entries_changed_warning := 'N';
1142:
1143: end if;

Line 1158: hr_utility.set_location(l_proc, 140);

1154: if l_system_person_type <> 'EMP' and
1155: l_system_person_type <> 'EMP_APL'
1156: then
1157: --
1158: hr_utility.set_location(l_proc, 140);
1159: --
1160: hr_utility.set_message(801,'HR_51005_ASG_INV_PER_TYPE');
1161: hr_utility.raise_error;
1162: end if;

Line 1160: hr_utility.set_message(801,'HR_51005_ASG_INV_PER_TYPE');

1156: then
1157: --
1158: hr_utility.set_location(l_proc, 140);
1159: --
1160: hr_utility.set_message(801,'HR_51005_ASG_INV_PER_TYPE');
1161: hr_utility.raise_error;
1162: end if;
1163: --
1164: -- PTU changes: must maintain default of correct "ex-emp" type on

Line 1161: hr_utility.raise_error;

1157: --
1158: hr_utility.set_location(l_proc, 140);
1159: --
1160: hr_utility.set_message(801,'HR_51005_ASG_INV_PER_TYPE');
1161: hr_utility.raise_error;
1162: end if;
1163: --
1164: -- PTU changes: must maintain default of correct "ex-emp" type on
1165: -- per_all_people_f

Line 1179: hr_utility.set_location(l_proc, 150);

1175: l_system_person_type1);
1176: --
1177: -- PTU : End of Changes
1178: --
1179: hr_utility.set_location(l_proc, 150);
1180: --
1181: -- Check that there are not any future changes to the person.
1182: --
1183: open csr_future_per_changes;

Line 1190: hr_utility.set_location(l_proc, 160);

1186: --
1187: if csr_future_per_changes%FOUND
1188: then
1189: --
1190: hr_utility.set_location(l_proc, 160);
1191: --
1192: close csr_future_per_changes;
1193: --
1194: hr_utility.set_message(801,'HR_7957_PDS_INV_ATT_FUTURE');

Line 1194: hr_utility.set_message(801,'HR_7957_PDS_INV_ATT_FUTURE');

1190: hr_utility.set_location(l_proc, 160);
1191: --
1192: close csr_future_per_changes;
1193: --
1194: hr_utility.set_message(801,'HR_7957_PDS_INV_ATT_FUTURE');
1195: hr_utility.raise_error;
1196: end if;
1197: --
1198: hr_utility.set_location(l_proc, 170);

Line 1195: hr_utility.raise_error;

1191: --
1192: close csr_future_per_changes;
1193: --
1194: hr_utility.set_message(801,'HR_7957_PDS_INV_ATT_FUTURE');
1195: hr_utility.raise_error;
1196: end if;
1197: --
1198: hr_utility.set_location(l_proc, 170);
1199: --

Line 1198: hr_utility.set_location(l_proc, 170);

1194: hr_utility.set_message(801,'HR_7957_PDS_INV_ATT_FUTURE');
1195: hr_utility.raise_error;
1196: end if;
1197: --
1198: hr_utility.set_location(l_proc, 170);
1199: --
1200: close csr_future_per_changes;
1201: --
1202: -- Process Logic

Line 1212: hr_utility.set_location(l_proc, 180);

1208: ,p_business_group_id => l_business_group_id
1209: ,p_expected_sys_type => 'EX_EMP'
1210: );
1211: --
1212: hr_utility.set_location(l_proc, 180);
1213: --
1214: -- If p_assignment_status_type_id is g_number then derive it's default value,
1215: -- otherwise validate it.
1216: --

Line 1217: hr_utility.set_location(l_proc||' asg stat type : '||l_assignment_status_type_id||' per bg id '||l_business_group_id||' leg code '||l_legislation_code,900);

1213: --
1214: -- If p_assignment_status_type_id is g_number then derive it's default value,
1215: -- otherwise validate it.
1216: --
1217: hr_utility.set_location(l_proc||' asg stat type : '||l_assignment_status_type_id||' per bg id '||l_business_group_id||' leg code '||l_legislation_code,900);
1218: --
1219: per_asg_bus1.chk_assignment_status_type
1220: (p_assignment_status_type_id => l_assignment_status_type_id
1221: ,p_business_group_id => l_business_group_id

Line 1226: hr_utility.set_location(l_proc, 190);

1222: ,p_legislation_code => l_legislation_code
1223: ,p_expected_system_status => 'TERM_ASSIGN'
1224: );
1225: --
1226: hr_utility.set_location(l_proc, 190);
1227: --
1228: -- Validate/derive the last standard process date.
1229: --
1230: --

Line 1231: hr_utility.set_location(l_proc, 200);

1227: --
1228: -- Validate/derive the last standard process date.
1229: --
1230: --
1231: hr_utility.set_location(l_proc, 200);
1232: --
1233: -- At the end of the following code we will either have a valid date
1234: -- for l_last_standard_process_date or it will be NULL. It can only be
1235: -- NULL if explicitly passed as such to the API.

Line 1241: hr_utility.set_location(l_proc, 210);

1237: if l_last_standard_process_date is not null and
1238: l_last_standard_process_date <> hr_api.g_date
1239: then
1240: --
1241: hr_utility.set_location(l_proc, 210);
1242: --
1243: -- Check that the last standard process date is on or after the actual
1244: -- termination date.
1245: --

Line 1249: hr_utility.set_location(l_proc, 220);

1245: --
1246: if not l_last_standard_process_date >= l_actual_termination_date
1247: then
1248: --
1249: hr_utility.set_location(l_proc, 220);
1250: --
1251: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
1252: hr_utility.raise_error;
1253: end if;

Line 1251: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');

1247: then
1248: --
1249: hr_utility.set_location(l_proc, 220);
1250: --
1251: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
1252: hr_utility.raise_error;
1253: end if;
1254: elsif l_last_standard_process_date = hr_api.g_date then
1255: --

Line 1252: hr_utility.raise_error;

1248: --
1249: hr_utility.set_location(l_proc, 220);
1250: --
1251: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
1252: hr_utility.raise_error;
1253: end if;
1254: elsif l_last_standard_process_date = hr_api.g_date then
1255: --
1256: hr_utility.set_location(l_proc, 230);

Line 1256: hr_utility.set_location(l_proc, 230);

1252: hr_utility.raise_error;
1253: end if;
1254: elsif l_last_standard_process_date = hr_api.g_date then
1255: --
1256: hr_utility.set_location(l_proc, 230);
1257: --
1258: -- Last standard process date is the default value i.e.
1259: -- it was not passed to the API => derive it.
1260: --

Line 1270: hr_utility.set_location(l_proc, 240);

1266: --
1267: if csr_get_max_tpe_end_date%NOTFOUND
1268: then
1269: --
1270: hr_utility.set_location(l_proc, 240);
1271: --
1272: close csr_get_max_tpe_end_date;
1273: --
1274: -- As the cursor should always return at least a null value, this

Line 1277: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1273: --
1274: -- As the cursor should always return at least a null value, this
1275: -- should never happen!
1276: --
1277: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1278: hr_utility.set_message_token('PROCEDURE', l_proc);
1279: hr_utility.set_message_token('STEP','175');
1280: hr_utility.raise_error;
1281: end if;

Line 1278: hr_utility.set_message_token('PROCEDURE', l_proc);

1274: -- As the cursor should always return at least a null value, this
1275: -- should never happen!
1276: --
1277: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1278: hr_utility.set_message_token('PROCEDURE', l_proc);
1279: hr_utility.set_message_token('STEP','175');
1280: hr_utility.raise_error;
1281: end if;
1282: --

Line 1279: hr_utility.set_message_token('STEP','175');

1275: -- should never happen!
1276: --
1277: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1278: hr_utility.set_message_token('PROCEDURE', l_proc);
1279: hr_utility.set_message_token('STEP','175');
1280: hr_utility.raise_error;
1281: end if;
1282: --
1283: close csr_get_max_tpe_end_date;

Line 1280: hr_utility.raise_error;

1276: --
1277: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1278: hr_utility.set_message_token('PROCEDURE', l_proc);
1279: hr_utility.set_message_token('STEP','175');
1280: hr_utility.raise_error;
1281: end if;
1282: --
1283: close csr_get_max_tpe_end_date;
1284: --

Line 1285: hr_utility.set_location(l_proc, 250);

1281: end if;
1282: --
1283: close csr_get_max_tpe_end_date;
1284: --
1285: hr_utility.set_location(l_proc, 250);
1286: --
1287: if l_max_tpe_end_date is not null
1288: then
1289: --

Line 1290: hr_utility.set_location(l_proc, 260);

1286: --
1287: if l_max_tpe_end_date is not null
1288: then
1289: --
1290: hr_utility.set_location(l_proc, 260);
1291: --
1292: -- A time period end date has been found, so set the last standard
1293: -- process date to that.
1294: --

Line 1298: hr_utility.set_location(l_proc, 270);

1294: --
1295: l_last_standard_process_date := l_max_tpe_end_date;
1296: else
1297: --
1298: hr_utility.set_location(l_proc, 270);
1299: --
1300: -- Either there was not an assignment assigned to a payroll, or
1301: -- there was no time period for that payroll as of the actual
1302: -- termination date. It doesn't matter which as we will default

Line 1325: hr_utility.set_message(800,'PER_449053_EMP_TERM_FUT_ERROR'); -- Modified from PER_289973 TO PER_449053

1321: -- Bug# 3086210 Modified the Warning message.
1322: --
1323: --
1324: IF l_action_chk = 'W' THEN
1325: hr_utility.set_message(800,'PER_449053_EMP_TERM_FUT_ERROR'); -- Modified from PER_289973 TO PER_449053
1326: hr_utility.set_warning;
1327: END IF;
1328: --
1329: --

Line 1326: hr_utility.set_warning;

1322: --
1323: --
1324: IF l_action_chk = 'W' THEN
1325: hr_utility.set_message(800,'PER_449053_EMP_TERM_FUT_ERROR'); -- Modified from PER_289973 TO PER_449053
1326: hr_utility.set_warning;
1327: END IF;
1328: --
1329: --
1330: --Bug# 2958006 End Here

Line 1333: hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');

1329: --
1330: --Bug# 2958006 End Here
1331: --
1332: if l_action_chk = 'Y' then
1333: hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');
1334: hr_utility.raise_error;
1335: end if;
1336: --
1337: hr_utility.set_location(l_proc, 280);

Line 1334: hr_utility.raise_error;

1330: --Bug# 2958006 End Here
1331: --
1332: if l_action_chk = 'Y' then
1333: hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');
1334: hr_utility.raise_error;
1335: end if;
1336: --
1337: hr_utility.set_location(l_proc, 280);
1338: --

Line 1337: hr_utility.set_location(l_proc, 280);

1333: hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');
1334: hr_utility.raise_error;
1335: end if;
1336: --
1337: hr_utility.set_location(l_proc, 280);
1338: --
1339: -- Lock the person record in PER_PEOPLE_F ready for UPDATE at a later point.
1340: -- (Note: This is necessary because calling the table handlers in locking
1341: -- ladder order invokes an error in per_pds_upd.upd due to the person

Line 1355: hr_utility.set_location(l_proc, 290);

1351: ,p_validation_start_date => l_validation_start_date
1352: ,p_validation_end_date => l_validation_end_date
1353: );
1354:
1355: hr_utility.set_location(l_proc, 290);
1356: --
1357: -- Update actual termination date and last standard process date in
1358: -- periods of service table.
1359:

Line 1435: hr_utility.set_location(l_proc, 300);

1431: close csr_date_of_death;
1432: end if;
1433: --
1434: if l_dod_warning = TRUE then
1435: hr_utility.set_location(l_proc, 300);
1436: else
1437: hr_utility.set_location(l_proc,310);
1438: end if;
1439: --

Line 1437: hr_utility.set_location(l_proc,310);

1433: --
1434: if l_dod_warning = TRUE then
1435: hr_utility.set_location(l_proc, 300);
1436: else
1437: hr_utility.set_location(l_proc,310);
1438: end if;
1439: --
1440: -- Update person type in person table.
1441: --

Line 1442: hr_utility.set_location(l_proc, 320);

1438: end if;
1439: --
1440: -- Update person type in person table.
1441: --
1442: hr_utility.set_location(l_proc, 320);
1443: per_per_upd.upd
1444: (p_person_id => l_person_id
1445: ,p_effective_start_date => l_effective_start_date
1446: ,p_effective_end_date => l_effective_end_date

Line 1466: hr_utility.set_location(l_proc, 330);

1462: ,p_orig_hire_warning => l_orig_hire_warning
1463: ,p_npw_number => l_npw_number
1464: );
1465: --
1466: hr_utility.set_location(l_proc, 330);
1467: --
1468: -- Fix for 4371218 starts here (Terminate contracts)
1469: --
1470: /* for ctc_rec in l_ctc_cur

Line 1492: hr_utility.set_location(l_proc, 335);

1488: ,p_object_version_number => l_ctc_ovn
1489: ,p_datetrack_mode => 'UPDATE'
1490: );
1491: end loop;*/
1492: hr_utility.set_location(l_proc, 335);
1493: --
1494: -- end of contracts termination
1495: --
1496: --

Line 1506: hr_utility.set_location(l_proc, 340);

1502: --
1503: for csr_rec in csr_get_asgs_to_terminate
1504: loop
1505: --
1506: hr_utility.set_location(l_proc, 340);
1507: --
1508: hr_assignment_internal.actual_term_emp_asg_sup
1509: (p_assignment_id => csr_rec.assignment_id
1510: ,p_object_version_number => csr_rec.object_version_number

Line 1528: hr_utility.set_location(l_proc, 350);

1524: -- 120.2 (END)
1525: --
1526: );
1527: --
1528: hr_utility.set_location(l_proc, 350);
1529: --
1530: -- Set entries changed warning using the precedence of 'S', then 'Y', then
1531: -- 'N'.
1532: --

Line 1536: hr_utility.set_location(l_proc, 360);

1532: --
1533: if l_cr_entries_changed_warn = 'S' or
1534: l_entries_changed_warning = 'S' then
1535: --
1536: hr_utility.set_location(l_proc, 360);
1537: --
1538: l_entries_changed_warning := 'S';
1539: --
1540: elsif l_cr_entries_changed_warn = 'Y' or

Line 1543: hr_utility.set_location(l_proc, 370);

1539: --
1540: elsif l_cr_entries_changed_warn = 'Y' or
1541: l_entries_changed_warning = 'Y' then
1542: --
1543: hr_utility.set_location(l_proc, 370);
1544: --
1545: l_entries_changed_warning := 'Y';
1546:
1547: else

Line 1549: hr_utility.set_location(l_proc, 380);

1545: l_entries_changed_warning := 'Y';
1546:
1547: else
1548: --
1549: hr_utility.set_location(l_proc, 380);
1550: --
1551: l_entries_changed_warning := 'N';
1552:
1553: end if;

Line 1555: hr_utility.set_location(l_proc, 390);

1551: l_entries_changed_warning := 'N';
1552:
1553: end if;
1554: --
1555: hr_utility.set_location(l_proc, 390);
1556: --
1557: -- Set future changes warning.
1558: --
1559: if l_cr_asg_future_changes_warn or l_asg_future_changes_warning

Line 1562: hr_utility.set_location(l_proc, 400);

1558: --
1559: if l_cr_asg_future_changes_warn or l_asg_future_changes_warning
1560: then
1561: --
1562: hr_utility.set_location(l_proc, 400);
1563: --
1564: l_asg_future_changes_warning := TRUE;
1565:
1566: end if;

Line 1570: hr_utility.set_location(l_proc, 410);

1566: end if;
1567:
1568: end loop;
1569: --
1570: hr_utility.set_location(l_proc, 410);
1571: --
1572: -- Added code to support the following Out warning parameters.
1573: --
1574: l_status := 'SUPERVISOR';

Line 1647: hr_utility.set_location('actual_termination_emp',420);

1643: --
1644: if p_leaving_reason = 'R'
1645: then
1646:
1647: hr_utility.set_location('actual_termination_emp',420);
1648:
1649: hr_per_type_usage_internal.create_person_type_usage
1650: (p_person_id => l_person_id
1651: ,p_person_type_id =>

Line 1661: hr_utility.set_location('actual_termination_emp',430);

1657: ,p_object_version_number=> l_ptu_object_version_number
1658: ,p_effective_start_date => l_effective_start_date
1659: ,p_effective_end_date => l_effective_end_date);
1660:
1661: hr_utility.set_location('actual_termination_emp',430);
1662:
1663: end if;
1664:
1665: end if;

Line 1669: hr_utility.set_location('actual_termination_emp',435);

1665: end if;
1666: --
1667: -- Fix for bug 3829474 starts here.
1668: --
1669: hr_utility.set_location('actual_termination_emp',435);
1670: --
1671:
1672: /* Bug 5504659
1673: open l_pds_cur;

Line 1683: hr_utility.set_location('actual_termination_emp',440);

1679: p_action => 'TERMINATION');
1680: Note : added p_date_start to test, earlier code does not work*/
1681:
1682: --
1683: hr_utility.set_location('actual_termination_emp',440);
1684: --
1685: -- Fix for bug 3829474 ends here.
1686: --
1687: -- Start of API User Hook for the after hook of actual_termination

Line 1799: hr_utility.set_location(' Leaving:'||l_proc, 440);

1795: p_last_std_process_date_out := l_last_standard_process_date;
1796: p_object_version_number := l_pds_object_version_number;
1797: --
1798: --
1799: hr_utility.set_location(' Leaving:'||l_proc, 440);
1800: exception
1801: when hr_api.validate_enabled then
1802: --
1803: -- As the Validate_Enabled exception has been raised

Line 1947: hr_utility.set_location('Entering:'|| l_proc, 1);

1943: --
1944: -- Fix for bug 3829474 ends here.
1945: --
1946: begin
1947: hr_utility.set_location('Entering:'|| l_proc, 1);
1948: --
1949: -- l_pds_object_version_number := p_object_version_number;
1950: l_final_process_date := trunc(p_final_process_date);
1951: --

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

1968: p_hook_type => 'BP'
1969: );
1970: end;
1971: --
1972: hr_utility.set_location(l_proc, 10);
1973: --
1974: -- Validation in addition to Table Handlers
1975: --
1976: -- Check period of service.

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

1988: ,p_argument => 'object_version_number'
1989: ,p_argument_value => p_object_version_number
1990: );
1991: --
1992: hr_utility.set_location(l_proc, 20);
1993: --
1994: open csr_get_derived_details;
1995: fetch csr_get_derived_details
1996: into l_legislation_code

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

2001: --
2002: if csr_get_derived_details%NOTFOUND
2003: then
2004: --
2005: hr_utility.set_location(l_proc, 30);
2006: --
2007: close csr_get_derived_details;
2008: --
2009: hr_utility.set_message(801,'HR_7391_ASG_INV_PERIOD_OF_SERV');

Line 2009: hr_utility.set_message(801,'HR_7391_ASG_INV_PERIOD_OF_SERV');

2005: hr_utility.set_location(l_proc, 30);
2006: --
2007: close csr_get_derived_details;
2008: --
2009: hr_utility.set_message(801,'HR_7391_ASG_INV_PERIOD_OF_SERV');
2010: hr_utility.raise_error;
2011: end if;
2012: --
2013: close csr_get_derived_details;

Line 2010: hr_utility.raise_error;

2006: --
2007: close csr_get_derived_details;
2008: --
2009: hr_utility.set_message(801,'HR_7391_ASG_INV_PERIOD_OF_SERV');
2010: hr_utility.raise_error;
2011: end if;
2012: --
2013: close csr_get_derived_details;
2014: --

Line 2020: hr_utility.set_message(801,'HR_7155_OBJECT_INVALID');

2016:
2017: if l_object_version_number <> p_object_version_number
2018: then
2019:
2020: hr_utility.set_message(801,'HR_7155_OBJECT_INVALID');
2021: hr_utility.raise_error;
2022: end if;
2023:
2024: hr_utility.set_location(l_proc, 40);

Line 2021: hr_utility.raise_error;

2017: if l_object_version_number <> p_object_version_number
2018: then
2019:
2020: hr_utility.set_message(801,'HR_7155_OBJECT_INVALID');
2021: hr_utility.raise_error;
2022: end if;
2023:
2024: hr_utility.set_location(l_proc, 40);
2025: --

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

2020: hr_utility.set_message(801,'HR_7155_OBJECT_INVALID');
2021: hr_utility.raise_error;
2022: end if;
2023:
2024: hr_utility.set_location(l_proc, 40);
2025: --
2026: -- Check that the actual termination date has already been set.
2027: --
2028: if l_actual_termination_date is null

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

2027: --
2028: if l_actual_termination_date is null
2029: then
2030: --
2031: hr_utility.set_location(l_proc, 50);
2032: --
2033: hr_utility.set_message(801,'HR_51007_ASG_INV_NOT_ACT_TERM');
2034: hr_utility.raise_error;
2035: end if;

Line 2033: hr_utility.set_message(801,'HR_51007_ASG_INV_NOT_ACT_TERM');

2029: then
2030: --
2031: hr_utility.set_location(l_proc, 50);
2032: --
2033: hr_utility.set_message(801,'HR_51007_ASG_INV_NOT_ACT_TERM');
2034: hr_utility.raise_error;
2035: end if;
2036: --
2037: -- Check if the final process date is set

Line 2034: hr_utility.raise_error;

2030: --
2031: hr_utility.set_location(l_proc, 50);
2032: --
2033: hr_utility.set_message(801,'HR_51007_ASG_INV_NOT_ACT_TERM');
2034: hr_utility.raise_error;
2035: end if;
2036: --
2037: -- Check if the final process date is set
2038: --

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

2089: l_exemppet_eff_date := p_final_process_date;
2090: --
2091: end if;
2092: --
2093: hr_utility.set_location(l_proc, 90);
2094: --
2095: -- Check that the corresponding person is of EX_EMP system person type.
2096: --
2097: open csr_valid_ex_emp;

Line 2104: hr_utility.set_location(l_proc, 100);

2100: --
2101: if csr_valid_ex_emp%NOTFOUND
2102: then
2103: --
2104: hr_utility.set_location(l_proc, 100);
2105: --
2106: close csr_valid_ex_emp;
2107: --
2108: hr_utility.set_message(801,'HR_51008_ASG_INV_EX_EMP_TYPE');

Line 2108: hr_utility.set_message(801,'HR_51008_ASG_INV_EX_EMP_TYPE');

2104: hr_utility.set_location(l_proc, 100);
2105: --
2106: close csr_valid_ex_emp;
2107: --
2108: hr_utility.set_message(801,'HR_51008_ASG_INV_EX_EMP_TYPE');
2109: hr_utility.raise_error;
2110: --
2111: end if;
2112: --

Line 2109: hr_utility.raise_error;

2105: --
2106: close csr_valid_ex_emp;
2107: --
2108: hr_utility.set_message(801,'HR_51008_ASG_INV_EX_EMP_TYPE');
2109: hr_utility.raise_error;
2110: --
2111: end if;
2112: --
2113: hr_utility.set_location(l_proc, 110);

Line 2113: hr_utility.set_location(l_proc, 110);

2109: hr_utility.raise_error;
2110: --
2111: end if;
2112: --
2113: hr_utility.set_location(l_proc, 110);
2114: --
2115: close csr_valid_ex_emp;
2116: --
2117: --2478758 implement check for payroll actions

Line 2128: hr_utility.clear_warning;

2124: );
2125: --
2126: IF l_action_chk = 'N' THEN
2127: --if this check suceeds, erase any possible warning from ATD check.
2128: hr_utility.clear_warning;
2129: END IF;
2130: IF l_action_chk = 'W' THEN
2131: --
2132: -- Fix for bug 3100620 starts here. changed the warning message.

Line 2134: --hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');

2130: IF l_action_chk = 'W' THEN
2131: --
2132: -- Fix for bug 3100620 starts here. changed the warning message.
2133: --
2134: --hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');
2135: hr_utility.set_message(800,'PER_449053_EMP_TERM_FUT_ERROR');
2136: --
2137: -- Fix for bug 3100620 ends here.
2138: --

Line 2135: hr_utility.set_message(800,'PER_449053_EMP_TERM_FUT_ERROR');

2131: --
2132: -- Fix for bug 3100620 starts here. changed the warning message.
2133: --
2134: --hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');
2135: hr_utility.set_message(800,'PER_449053_EMP_TERM_FUT_ERROR');
2136: --
2137: -- Fix for bug 3100620 ends here.
2138: --
2139: hr_utility.set_warning;

Line 2139: hr_utility.set_warning;

2135: hr_utility.set_message(800,'PER_449053_EMP_TERM_FUT_ERROR');
2136: --
2137: -- Fix for bug 3100620 ends here.
2138: --
2139: hr_utility.set_warning;
2140: END IF;
2141: --
2142: if l_action_chk = 'Y' then
2143: hr_utility.set_message(801,'HR_6517_EMP_FPD_ACTIONS_EXIST');

Line 2143: hr_utility.set_message(801,'HR_6517_EMP_FPD_ACTIONS_EXIST');

2139: hr_utility.set_warning;
2140: END IF;
2141: --
2142: if l_action_chk = 'Y' then
2143: hr_utility.set_message(801,'HR_6517_EMP_FPD_ACTIONS_EXIST');
2144: hr_utility.raise_error;
2145: end if;
2146: --
2147: -- Check that there are no COBRA benefits after the final process date.

Line 2144: hr_utility.raise_error;

2140: END IF;
2141: --
2142: if l_action_chk = 'Y' then
2143: hr_utility.set_message(801,'HR_6517_EMP_FPD_ACTIONS_EXIST');
2144: hr_utility.raise_error;
2145: end if;
2146: --
2147: -- Check that there are no COBRA benefits after the final process date.
2148: --

Line 2162: hr_utility.set_location(l_proc, 120);

2158: ,p_validate => p_validate
2159: );
2160:
2161: --
2162: hr_utility.set_location(l_proc, 120);
2163: --
2164: -- Final process the assignments, ensuring that the non-primaries are
2165: -- processed before the primary (implemented via 'order by primary_flag'
2166: -- clause in cursor declaration).

Line 2175: hr_utility.set_location(l_proc, 130);

2171:
2172: for csr_rec in csr_get_asgs_to_final_proc
2173: loop
2174: --
2175: hr_utility.set_location(l_proc, 130);
2176: hr_utility.set_location('assignment_id '||to_char(csr_rec.assignment_id),131);
2177: --
2178: hr_assignment_internal.final_process_emp_asg_sup
2179: (p_assignment_id => csr_rec.assignment_id

Line 2176: hr_utility.set_location('assignment_id '||to_char(csr_rec.assignment_id),131);

2172: for csr_rec in csr_get_asgs_to_final_proc
2173: loop
2174: --
2175: hr_utility.set_location(l_proc, 130);
2176: hr_utility.set_location('assignment_id '||to_char(csr_rec.assignment_id),131);
2177: --
2178: hr_assignment_internal.final_process_emp_asg_sup
2179: (p_assignment_id => csr_rec.assignment_id
2180: ,p_object_version_number => csr_rec.object_version_number

Line 2190: hr_utility.set_location(l_proc, 140);

2186: ,p_asg_future_changes_warning => l_cr_asg_future_changes_warn
2187: ,p_entries_changed_warning => l_cr_entries_changed_warn
2188: );
2189: --
2190: hr_utility.set_location(l_proc, 140);
2191: --
2192: -- Set entries changed warning using the precedence of 'S', then 'Y', then
2193: -- 'N'.
2194: --

Line 2199: hr_utility.set_location(l_proc, 150);

2195: if l_cr_entries_changed_warn = 'S'
2196: or l_entries_changed_warning = 'S'
2197: then
2198: --
2199: hr_utility.set_location(l_proc, 150);
2200: --
2201: l_entries_changed_warning := 'S';
2202: --
2203: elsif l_cr_entries_changed_warn = 'Y'

Line 2207: hr_utility.set_location(l_proc, 160);

2203: elsif l_cr_entries_changed_warn = 'Y'
2204: or l_entries_changed_warning = 'Y'
2205: then
2206: --
2207: hr_utility.set_location(l_proc, 160);
2208: --
2209: l_entries_changed_warning := 'Y';
2210: --
2211: else

Line 2213: hr_utility.set_location(l_proc, 165);

2209: l_entries_changed_warning := 'Y';
2210: --
2211: else
2212: --
2213: hr_utility.set_location(l_proc, 165);
2214: --
2215: l_entries_changed_warning := 'N';
2216: --
2217: end if;

Line 2219: hr_utility.set_location(l_proc, 170);

2215: l_entries_changed_warning := 'N';
2216: --
2217: end if;
2218: --
2219: hr_utility.set_location(l_proc, 170);
2220: --
2221: -- Set future changes warning.
2222: --
2223: if l_cr_asg_future_changes_warn

Line 2226: hr_utility.set_location(l_proc, 180);

2222: --
2223: if l_cr_asg_future_changes_warn
2224: then
2225: --
2226: hr_utility.set_location(l_proc, 180);
2227: --
2228: l_asg_future_changes_warning := TRUE;
2229: end if;
2230: --

Line 2236: hr_utility.set_location(l_proc, 190);

2232: --
2233: if l_cr_org_now_no_manager_warn
2234: then
2235: --
2236: hr_utility.set_location(l_proc, 190);
2237: --
2238: l_org_now_no_manager_warning := TRUE;
2239: end if;
2240: end loop;

Line 2242: hr_utility.set_location(l_proc, 195);

2238: l_org_now_no_manager_warning := TRUE;
2239: end if;
2240: end loop;
2241: --
2242: hr_utility.set_location(l_proc, 195);
2243: --
2244: -- Fix for bug 3829474 starts here.
2245: --
2246:

Line 2261: hr_utility.set_location(l_proc, 200);

2257:
2258: --
2259: -- Fix for bug 3829474 ends here.
2260: --
2261: hr_utility.set_location(l_proc, 200);
2262: --
2263: -- Start of API User Hook for the after hook of final_process_emp.
2264: --
2265: begin

Line 2299: hr_utility.set_location(' Leaving:'||l_proc, 400);

2295: p_entries_changed_warning := l_entries_changed_warning;
2296: p_object_version_number := l_object_version_number;
2297: p_org_now_no_manager_warning := l_org_now_no_manager_warning;
2298: --
2299: hr_utility.set_location(' Leaving:'||l_proc, 400);
2300: exception
2301: when hr_api.validate_enabled then
2302: --
2303: -- As the Validate_Enabled exception has been raised

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

2361: number := p_object_version_number;
2362: l_ovn number := p_object_version_number;
2363: l_validate boolean := false;
2364: begin
2365: hr_utility.set_location('Entering:'|| l_proc, 5);
2366: --
2367: -- Issue a savepoint.
2368: --
2369: savepoint update_term_details_emp;

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

2366: --
2367: -- Issue a savepoint.
2368: --
2369: savepoint update_term_details_emp;
2370: hr_utility.set_location(l_proc, 6);
2371: --
2372: --
2373: -- Start of API User Hook for the before hook of final_process_emp.
2374: --

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

2406: ,p_effective_date => p_effective_date
2407: ,p_validate => l_validate
2408: );
2409: --
2410: hr_utility.set_location(l_proc, 7);
2411: --
2412: -- When in validation only mode raise the Validate_Enabled exception
2413: --
2414: --

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

2437: if p_validate then
2438: raise hr_api.validate_enabled;
2439: end if;
2440: --
2441: hr_utility.set_location(' Leaving:'||l_proc, 8);
2442: --
2443: exception
2444: when hr_api.validate_enabled then
2445: --

Line 2488: hr_utility.trace('Entered check_for_compl_actions for '||p_person_id);

2484: l_action_date DATE;
2485: --
2486: l_proc varchar2(72):=g_package||'check_for_compl_actions';
2487: begin
2488: hr_utility.trace('Entered check_for_compl_actions for '||p_person_id);
2489: hr_utility.trace('ATD: '||p_act_date);
2490: hr_utility.trace('LSP: '||p_lsp_date);
2491: hr_utility.trace('FPD: '||p_fpr_date);
2492: --

Line 2489: hr_utility.trace('ATD: '||p_act_date);

2485: --
2486: l_proc varchar2(72):=g_package||'check_for_compl_actions';
2487: begin
2488: hr_utility.trace('Entered check_for_compl_actions for '||p_person_id);
2489: hr_utility.trace('ATD: '||p_act_date);
2490: hr_utility.trace('LSP: '||p_lsp_date);
2491: hr_utility.trace('FPD: '||p_fpr_date);
2492: --
2493: IF p_lsp_date IS NOT NULL THEN

Line 2490: hr_utility.trace('LSP: '||p_lsp_date);

2486: l_proc varchar2(72):=g_package||'check_for_compl_actions';
2487: begin
2488: hr_utility.trace('Entered check_for_compl_actions for '||p_person_id);
2489: hr_utility.trace('ATD: '||p_act_date);
2490: hr_utility.trace('LSP: '||p_lsp_date);
2491: hr_utility.trace('FPD: '||p_fpr_date);
2492: --
2493: IF p_lsp_date IS NOT NULL THEN
2494: IF p_act_date IS NOT NULL AND p_lsp_date >= p_act_date THEN

Line 2491: hr_utility.trace('FPD: '||p_fpr_date);

2487: begin
2488: hr_utility.trace('Entered check_for_compl_actions for '||p_person_id);
2489: hr_utility.trace('ATD: '||p_act_date);
2490: hr_utility.trace('LSP: '||p_lsp_date);
2491: hr_utility.trace('FPD: '||p_fpr_date);
2492: --
2493: IF p_lsp_date IS NOT NULL THEN
2494: IF p_act_date IS NOT NULL AND p_lsp_date >= p_act_date THEN
2495: l_action_date := p_lsp_date;

Line 2502: hr_utility.set_location(l_proc,1);

2498: END IF;
2499: ELSE
2500: l_action_date := p_act_date;
2501: END IF;
2502: hr_utility.set_location(l_proc,1);
2503: BEGIN
2504: SELECT 'Y'
2505: INTO l_action_chk
2506: FROM dual

Line 2521: hr_utility.set_location(l_proc,5);

2517: EXCEPTION
2518: when NO_DATA_FOUND then null;
2519: END;
2520: --
2521: hr_utility.set_location(l_proc,5);
2522: IF l_action_chk = 'N' THEN
2523: BEGIN
2524: SELECT 'W'
2525: INTO l_action_chk

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

2539: OR (p_fpr_date is not null
2540: AND (pac.effective_date >= l_action_date
2541: AND pac.effective_date <= p_fpr_date))));
2542: --
2543: hr_utility.set_location(l_proc,7);
2544: EXCEPTION
2545: when NO_DATA_FOUND then null;
2546: END;
2547: END IF;

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

2562: --
2563:
2564: l_proc varchar2(72) := g_package||'reverse_terminate_employee';
2565: begin
2566: hr_utility.set_location('Entering:'|| l_proc, 5);
2567: --
2568: -- Issue a savepoint.
2569: --
2570: savepoint reverse_terminate_employee;

Line 2592: hr_utility.set_location('Before:hr_ex_employee_internal.reverse_terminate_employee'|| l_proc, 10);

2588: end;
2589: --
2590: -- Process Logic
2591: --
2592: hr_utility.set_location('Before:hr_ex_employee_internal.reverse_terminate_employee'|| l_proc, 10);
2593: hr_ex_employee_internal.reverse_terminate_employee
2594: (p_person_id
2595: ,p_actual_termination_date
2596: ,p_clear_details);

Line 2598: hr_utility.set_location('After:hr_ex_employee_internal.reverse_terminate_employee'|| l_proc, 15);

2594: (p_person_id
2595: ,p_actual_termination_date
2596: ,p_clear_details);
2597: --
2598: hr_utility.set_location('After:hr_ex_employee_internal.reverse_terminate_employee'|| l_proc, 15);
2599: -- When in validation only mode raise the Validate_Enabled exception
2600: --
2601: --
2602: -- Start of API User Hook for the after hook of reverse_terminate_employee.

Line 2622: hr_utility.set_location(' Leaving:'||l_proc, 20);

2618: if p_validate then
2619: raise hr_api.validate_enabled;
2620: end if;
2621: --
2622: hr_utility.set_location(' Leaving:'||l_proc, 20);
2623: --
2624: exception
2625: when hr_api.validate_enabled then
2626: --