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

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

168: (l_sid,sysdate);
169: end if;
170: end;
171:
172: hr_utility.set_location('Entering ' || l_proc,5);
173: savepoint create_sf52_for_mass_changes;
174:
175: l_pa_request_rec := p_pa_request_rec;
176: -- Bug#3718167 Getting the employee_full name into l_full_name to use in the Log Text

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

208: l_pa_request_rec.rpa_type := p_pa_request_rec.rpa_type;
209: l_pa_request_rec.mass_action_id := p_pa_request_rec.mass_action_id;
210:
211: If p_mass_action_type = 'MASS_SALARY_CHG' then
212: hr_utility.set_location(l_proc,10);
213: --7577249 commented hardcoding and added to fetch noa family code as
214: -- for SES employees noa code changes by changing the lac code
215:
216: open get_family_code(p_effective_date => l_pa_request_rec.effective_date);

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

221: l_pa_request_num_prefix := p_pa_request_rec.rpa_type;
222: -- l_pa_request_rec.noa_Family_Code := 'GHR_SAL_PAY_ADJ';
223: l_pa_request_rec.first_noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'894');
224: ElsIf p_mass_action_type = 'MASS_LOCALITY_CHG' then
225: hr_utility.set_location(l_proc,10);
226: if ghr_msl_pkg.g_first_noa_code is not null then
227: l_pa_request_rec.noa_family_code := 'GHR_SAL_PAY_ADJ';
228: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
229: else

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

231: l_pa_request_rec.first_noa_code := '895';
232: end if;
233: l_pa_request_num_prefix := 'MLC';
234: ElsIf p_mass_action_type = 'MASS_TABLE_CHG' then
235: hr_utility.set_location(l_proc,10);
236: if l_pa_request_rec.from_basic_pay = l_pa_request_rec.to_basic_pay
237: AND l_pa_request_rec.input_pay_rate_determinant <> l_pa_request_rec.pay_rate_determinant then
238: l_pa_request_rec.noa_family_code := 'CHG_DATA_ELEMENT';
239: l_pa_request_rec.first_noa_code := '800';

Line 257: hr_utility.set_location('In MASS_NOA_SEL '|| ghr_msl_pkg.g_first_noa_code,220);

253: Elsif p_mass_action_type = 'MASS_TRANSFER_IN' Then
254: l_pa_request_num_prefix := 'MTI';
255: --Begin Bug# 14055214
256: ELSIF p_mass_action_type = 'MASS_NOA_SEL' THEN
257: hr_utility.set_location('In MASS_NOA_SEL '|| ghr_msl_pkg.g_first_noa_code,220);
258: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
259: open get_family_code(p_effective_date => l_pa_request_rec.effective_date);
260: fetch get_family_code into l_pa_request_rec.noa_Family_Code;
261: close get_family_code;

Line 272: hr_utility.set_location(l_proc,35);

268: l_target_functional_class := l_pa_request_rec.functional_class;
269: --End Bug# 14055214
270: End if;
271:
272: hr_utility.set_location(l_proc,35);
273: ghr_mass_actions_pkg.get_noa_id_desc
274: (p_noa_code => l_pa_request_rec.first_noa_code,
275: p_effective_date => l_pa_request_rec.effective_date,
276: p_noa_id => l_pa_request_rec.first_noa_id,

Line 281: hr_utility.set_location ('Mass action type '|| p_mass_action_type,233);

277: p_noa_desc => l_pa_request_rec.first_noa_desc
278: );
279:
280: --Begin Bug# 14055214
281: hr_utility.set_location ('Mass action type '|| p_mass_action_type,233);
282: IF p_mass_action_type = 'MASS_NOA_SEL' AND l_pa_request_rec.first_noa_code IN ('460','472','772','773') THEN
283: ghr_mass_actions_pkg.replace_insertion_values
284: (p_desc => l_pa_request_rec.first_noa_desc,
285: p_information1 => to_char(fnd_date.canonical_to_date(l_pa_request_rec.first_noa_information1),'DD-MON-RRRR'),

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

301: );
302: l_pa_request_rec.first_noa_desc := l_desc_out;
303: END IF;
304:
305: hr_utility.set_location(l_proc,40);
306:
307:
308: -- For Mass Transfer IN we don't have to fetch any information
309: -- it is all passed in.

Line 325: hr_utility.set_location(l_proc,55);

321:
322:
323: IF p_mass_action_type <> 'MASS_TRANSFER_IN' THEN
324:
325: hr_utility.set_location(l_proc,55);
326:
327: ghr_api.sf52_from_data_elements
328: (p_person_id => l_pa_request_rec.person_id
329: ,p_assignment_id => l_pa_request_rec.employee_assignment_id

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

401: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
402: END IF;
403:
404:
405: hr_utility.set_location(l_proc,60);
406:
407: -- populate to side with the from side except for Mass Transfer OUT.
408:
409: IF p_mass_action_type not in ('MASS_TRANSFER_OUT') THEN

Line 556: hr_utility.set_location(l_proc,65);

552: -- Employee Data
553:
554: -- # Bug 711533 : Added the if condition
555: IF p_mass_action_type <> 'MASS_TRANSFER_IN' THEN
556: hr_utility.set_location(l_proc,65);
557: ghr_pa_requests_pkg.get_SF52_person_ddf_details
558: (p_person_id => l_pa_request_rec.person_id,
559: p_date_effective => l_pa_request_rec.effective_date,
560: p_citizenship => l_pa_request_rec.citizenship,

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

564: p_scd_leave => l_scd_leave
565: );
566:
567: -- populate service comp date
568: hr_utility.set_location(l_proc,70);
569:
570: ---l_pa_request_rec.service_comp_date := to_date(l_scd_leave, 'dd-mon-yyyy');
571: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
572:

Line 574: hr_utility.set_location(l_proc,75);

570: ---l_pa_request_rec.service_comp_date := to_date(l_scd_leave, 'dd-mon-yyyy');
571: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
572:
573: -- get education details
574: hr_utility.set_location(l_proc,75);
575: ghr_api.return_education_Details
576: (p_person_id => l_pa_request_rec.person_id,
577: p_effective_date => l_pa_request_rec.effective_date,
578: p_education_level => l_pa_request_rec.education_level,

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

579: p_academic_discipline => l_pa_request_rec.academic_discipline,
580: p_year_degree_attained => l_pa_request_rec.year_degree_attained
581: );
582:
583: hr_utility.set_location(l_proc,80);
584: End if;
585:
586: IF p_mass_action_type = 'MASS_TRANSFER_IN' THEN
587: l_position_id := l_pa_request_rec.to_position_id;

Line 991: hr_utility.set_location('After creation of PA REQUEST '||to_char(l_pa_request_rec.pa_request_id),10);

987:
988: p_pa_request_rec := l_pa_request_rec;
989:
990:
991: hr_utility.set_location('After creation of PA REQUEST '||to_char(l_pa_request_rec.pa_request_id),10);
992:
993: -- Update the request number with a prefix to indicate what mass action it is.
994: -- and concatenate it with the request id.
995:

Line 1159: hr_utility.set_location('Error occured in ' || l_proc , 1);

1155:
1156: Exception
1157: When groupbox_err then
1158: rollback to create_sf52_for_mass_changes;
1159: hr_utility.set_location('Error occured in ' || l_proc , 1);
1160:
1161: IF l_log_text is NULL THEN
1162: l_log_text := 'Error while create / Update the PA Request Rec. ';
1163: END IF;

Line 1169: hr_utility.set_location('before creating entry in log file',10);

1165: p_retcode := 1;
1166: -- For group box error, name and SSN are added before raising this error.
1167: l_log_text := substr(l_log_text,1,2000);
1168:
1169: hr_utility.set_location('before creating entry in log file',10);
1170: ghr_mto_int.log_message( p_procedure => 'While Creating SF52'
1171: ,p_message => l_log_text);
1172:
1173: hr_utility.set_location('created entry in log file',20);

Line 1173: hr_utility.set_location('created entry in log file',20);

1169: hr_utility.set_location('before creating entry in log file',10);
1170: ghr_mto_int.log_message( p_procedure => 'While Creating SF52'
1171: ,p_message => l_log_text);
1172:
1173: hr_utility.set_location('created entry in log file',20);
1174: COMMIT;
1175: WHEN others THEN
1176: p_pa_request_rec := l_pa_request_rec;
1177:

Line 1179: hr_utility.set_location('Error occured in ' || l_proc , 1);

1175: WHEN others THEN
1176: p_pa_request_rec := l_pa_request_rec;
1177:
1178: rollback to create_sf52_for_mass_changes;
1179: hr_utility.set_location('Error occured in ' || l_proc , 1);
1180:
1181: IF l_log_text is NULL THEN
1182: l_log_text := 'Error while create / Update the PA Request Rec. ';
1183: END IF;

Line 1191: hr_utility.set_location('before creating entry in log file',10);

1187: -- Bug#3718167 Added Full Name, SSN in the log text
1188: --Bug # 9329643 Modified SSN to Emp No
1189: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
1190:
1191: hr_utility.set_location('before creating entry in log file',10);
1192:
1193: ghr_mto_int.log_message(
1194: p_procedure => 'While Creating SF52'
1195: ,p_message => l_log_text);

Line 1198: hr_utility.set_location('created entry in log file',20);

1194: p_procedure => 'While Creating SF52'
1195: ,p_message => l_log_text);
1196:
1197:
1198: hr_utility.set_location('created entry in log file',20);
1199:
1200: commit;
1201:
1202: end create_sf52_for_mass_changes;

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

1224:
1225: begin
1226:
1227: -- get remark_id remark_desc, remark_code_information1, ...
1228: hr_utility.set_location('Entering ' || l_proc,5);
1229:
1230: ghr_mass_actions_pkg.get_remark_id_desc
1231: (p_remark_code => p_remark_code,
1232: p_effective_date => trunc(nvl(p_pa_request_rec.effective_date,sysdate)),

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

1232: p_effective_date => trunc(nvl(p_pa_request_rec.effective_date,sysdate)),
1233: p_remark_id => l_remark_id,
1234: p_remark_desc => l_description
1235: );
1236: hr_utility.set_location(l_proc,10);
1237: l_remark_code_information1 := Null;
1238: l_remark_code_information2 := Null;
1239: l_remark_code_information3 := Null;
1240: l_remark_code_information4 := Null;

Line 1244: hr_utility.set_location(l_proc,15);

1240: l_remark_code_information4 := Null;
1241: l_remark_code_information5 := Null;
1242:
1243: If p_remark_code = 'X44' then
1244: hr_utility.set_location(l_proc,15);
1245: -- if there are entries for insertion values then alter the description accordingly.
1246: l_retained_grade_rec := ghr_pc_basic_pay.get_retained_grade_details
1247: (p_person_id => p_pa_request_rec.person_id,
1248: p_effective_Date => trunc(nvl(p_pa_request_rec.effective_Date,sysdate))