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.

[Home] [Help]

APPS.GHR_MASS_CHANGES dependencies on HR_UTILITY

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

155: (l_sid,sysdate);
156: end if;
157: end;
158:
159: hr_utility.set_location('Entering ' || l_proc,5);
160: savepoint create_sf52_for_mass_changes;
161:
162: l_pa_request_rec := p_pa_request_rec;
163: -- Bug#3718167 Getting the employee_full name into l_full_name to use in the Log Text

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

190: l_pa_request_rec.rpa_type := p_pa_request_rec.rpa_type;
191: l_pa_request_rec.mass_action_id := p_pa_request_rec.mass_action_id;
192:
193: If p_mass_action_type = 'MASS_SALARY_CHG' then
194: hr_utility.set_location(l_proc,10);
195: --7577249 commented hardcoding and added to fetch noa family code as
196: -- for SES employees noa code changes by changing the lac code
197:
198: open get_family_code(p_effective_date => l_pa_request_rec.effective_date);

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

203: l_pa_request_num_prefix := p_pa_request_rec.rpa_type;
204: -- l_pa_request_rec.noa_Family_Code := 'GHR_SAL_PAY_ADJ';
205: l_pa_request_rec.first_noa_code := nvl(ghr_msl_pkg.g_first_noa_code,'894');
206: ElsIf p_mass_action_type = 'MASS_LOCALITY_CHG' then
207: hr_utility.set_location(l_proc,10);
208: if ghr_msl_pkg.g_first_noa_code is not null then
209: l_pa_request_rec.noa_family_code := 'GHR_SAL_PAY_ADJ';
210: l_pa_request_rec.first_noa_code := ghr_msl_pkg.g_first_noa_code;
211: else

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

213: l_pa_request_rec.first_noa_code := '895';
214: end if;
215: l_pa_request_num_prefix := 'MLC';
216: ElsIf p_mass_action_type = 'MASS_TABLE_CHG' then
217: hr_utility.set_location(l_proc,10);
218: if l_pa_request_rec.from_basic_pay = l_pa_request_rec.to_basic_pay
219: AND l_pa_request_rec.input_pay_rate_determinant <> l_pa_request_rec.pay_rate_determinant then
220: l_pa_request_rec.noa_family_code := 'CHG_DATA_ELEMENT';
221: l_pa_request_rec.first_noa_code := '800';

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

235: Elsif p_mass_action_type = 'MASS_TRANSFER_IN' Then
236: l_pa_request_num_prefix := 'MTI';
237: End if;
238:
239: hr_utility.set_location(l_proc,35);
240: ghr_mass_actions_pkg.get_noa_id_desc
241: (p_noa_code => l_pa_request_rec.first_noa_code,
242: p_effective_date => l_pa_request_rec.effective_date,
243: p_noa_id => l_pa_request_rec.first_noa_id,

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

258: );
259: l_pa_request_rec.first_noa_desc := l_desc_out;
260: END IF;
261:
262: hr_utility.set_location(l_proc,40);
263:
264:
265: -- For Mass Transfer IN we don't have to fetch any information
266: -- it is all passed in.

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

278:
279:
280: IF p_mass_action_type <> 'MASS_TRANSFER_IN' THEN
281:
282: hr_utility.set_location(l_proc,55);
283:
284: ghr_api.sf52_from_data_elements
285: (p_person_id => l_pa_request_rec.person_id
286: ,p_assignment_id => l_pa_request_rec.employee_assignment_id

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

358: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
359: END IF;
360:
361:
362: hr_utility.set_location(l_proc,60);
363:
364: -- populate to side with the from side except for Mass Transfer OUT.
365:
366: IF p_mass_action_type not in ('MASS_TRANSFER_OUT') THEN

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

438: -- Employee Data
439:
440: -- # Bug 711533 : Added the if condition
441: IF p_mass_action_type <> 'MASS_TRANSFER_IN' THEN
442: hr_utility.set_location(l_proc,65);
443: ghr_pa_requests_pkg.get_SF52_person_ddf_details
444: (p_person_id => l_pa_request_rec.person_id,
445: p_date_effective => l_pa_request_rec.effective_date,
446: p_citizenship => l_pa_request_rec.citizenship,

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

450: p_scd_leave => l_scd_leave
451: );
452:
453: -- populate service comp date
454: hr_utility.set_location(l_proc,70);
455:
456: ---l_pa_request_rec.service_comp_date := to_date(l_scd_leave, 'dd-mon-yyyy');
457: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
458:

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

456: ---l_pa_request_rec.service_comp_date := to_date(l_scd_leave, 'dd-mon-yyyy');
457: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
458:
459: -- get education details
460: hr_utility.set_location(l_proc,75);
461: ghr_api.return_education_Details
462: (p_person_id => l_pa_request_rec.person_id,
463: p_effective_date => l_pa_request_rec.effective_date,
464: p_education_level => l_pa_request_rec.education_level,

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

465: p_academic_discipline => l_pa_request_rec.academic_discipline,
466: p_year_degree_attained => l_pa_request_rec.year_degree_attained
467: );
468:
469: hr_utility.set_location(l_proc,80);
470: End if;
471:
472: IF p_mass_action_type = 'MASS_TRANSFER_IN' THEN
473: l_position_id := l_pa_request_rec.to_position_id;

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

874:
875: p_pa_request_rec := l_pa_request_rec;
876:
877:
878: hr_utility.set_location('After creation of PA REQUEST '||to_char(l_pa_request_rec.pa_request_id),10);
879:
880: -- Update the request number with a prefix to indicate what mass action it is.
881: -- and concatenate it with the request id.
882:

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

989:
990: Exception
991: When groupbox_err then
992: rollback to create_sf52_for_mass_changes;
993: hr_utility.set_location('Error occured in ' || l_proc , 1);
994:
995: IF l_log_text is NULL THEN
996: l_log_text := 'Error while create / Update the PA Request Rec. ';
997: END IF;

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

999: p_retcode := 1;
1000: -- For group box error, name and SSN are added before raising this error.
1001: l_log_text := substr(l_log_text,1,2000);
1002:
1003: hr_utility.set_location('before creating entry in log file',10);
1004: ghr_mto_int.log_message( p_procedure => 'While Creating SF52'
1005: ,p_message => l_log_text);
1006:
1007: hr_utility.set_location('created entry in log file',20);

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

1003: hr_utility.set_location('before creating entry in log file',10);
1004: ghr_mto_int.log_message( p_procedure => 'While Creating SF52'
1005: ,p_message => l_log_text);
1006:
1007: hr_utility.set_location('created entry in log file',20);
1008: COMMIT;
1009: WHEN others THEN
1010: p_pa_request_rec := l_pa_request_rec;
1011:

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

1009: WHEN others THEN
1010: p_pa_request_rec := l_pa_request_rec;
1011:
1012: rollback to create_sf52_for_mass_changes;
1013: hr_utility.set_location('Error occured in ' || l_proc , 1);
1014:
1015: IF l_log_text is NULL THEN
1016: l_log_text := 'Error while create / Update the PA Request Rec. ';
1017: END IF;

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

1020:
1021: -- Bug#3718167 Added Full Name, SSN in the log text
1022: l_log_text := l_log_text ||' for '||l_full_name||' SSN: '||l_ssn||' Sql error : '||sqlerrm(sqlcode);
1023:
1024: hr_utility.set_location('before creating entry in log file',10);
1025:
1026: ghr_mto_int.log_message(
1027: p_procedure => 'While Creating SF52'
1028: ,p_message => l_log_text);

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

1027: p_procedure => 'While Creating SF52'
1028: ,p_message => l_log_text);
1029:
1030:
1031: hr_utility.set_location('created entry in log file',20);
1032:
1033: commit;
1034:
1035: end create_sf52_for_mass_changes;

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

1057:
1058: begin
1059:
1060: -- get remark_id remark_desc, remark_code_information1, ...
1061: hr_utility.set_location('Entering ' || l_proc,5);
1062:
1063: ghr_mass_actions_pkg.get_remark_id_desc
1064: (p_remark_code => p_remark_code,
1065: p_effective_date => trunc(nvl(p_pa_request_rec.effective_date,sysdate)),

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

1065: p_effective_date => trunc(nvl(p_pa_request_rec.effective_date,sysdate)),
1066: p_remark_id => l_remark_id,
1067: p_remark_desc => l_description
1068: );
1069: hr_utility.set_location(l_proc,10);
1070: l_remark_code_information1 := Null;
1071: l_remark_code_information2 := Null;
1072: l_remark_code_information3 := Null;
1073: l_remark_code_information4 := Null;

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

1073: l_remark_code_information4 := Null;
1074: l_remark_code_information5 := Null;
1075:
1076: If p_remark_code = 'X44' then
1077: hr_utility.set_location(l_proc,15);
1078: -- if there are entries for insertion values then alter the description accordingly.
1079: l_retained_grade_rec := ghr_pc_basic_pay.get_retained_grade_details
1080: (p_person_id => p_pa_request_rec.person_id,
1081: p_effective_Date => trunc(nvl(p_pa_request_rec.effective_Date,sysdate))