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

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

190: END;
191:
192: EXCEPTION
193: WHEN fegli_null_error then
194: hr_utility.set_location('Error occured in ' || l_proc , 1);
195: IF l_log_text is NULL THEN
196: l_log_text := 'Cannot Create/Update SS Fegli RPA';
197: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
198: END IF;

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

198: END IF;
199:
200: l_log_text := substr(l_log_text,1,2000);
201:
202: hr_utility.set_location('before creating entry in log file',10);
203: ghr_mto_int.log_message( p_procedure => 'Create/Upd SS Fegli RPA'
204: ,p_message => l_log_text);
205:
206: hr_utility.set_location('created entry in log file',20);

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

202: hr_utility.set_location('before creating entry in log file',10);
203: ghr_mto_int.log_message( p_procedure => 'Create/Upd SS Fegli RPA'
204: ,p_message => l_log_text);
205:
206: hr_utility.set_location('created entry in log file',20);
207:
208: WHEN fegli_upd_error then
209: hr_utility.set_location('Error occured in ' || l_proc , 1);
210: IF l_log_text is NULL THEN

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

205:
206: hr_utility.set_location('created entry in log file',20);
207:
208: WHEN fegli_upd_error then
209: hr_utility.set_location('Error occured in ' || l_proc , 1);
210: IF l_log_text is NULL THEN
211: l_log_text := 'Error while Updating the PA Request Rec. ';
212: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
213: END IF;

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

213: END IF;
214:
215: l_log_text := substr(l_log_text,1,2000);
216:
217: hr_utility.set_location('before creating entry in log file',10);
218: ghr_mto_int.log_message( p_procedure => 'While Updating FEGLI RPA'
219: ,p_message => l_log_text);
220:
221: WHEN fegli_ei_error then

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

218: ghr_mto_int.log_message( p_procedure => 'While Updating FEGLI RPA'
219: ,p_message => l_log_text);
220:
221: WHEN fegli_ei_error then
222: hr_utility.set_location('Error occured in ' || l_proc , 1);
223: IF l_log_text is NULL THEN
224: l_log_text := 'Error while Creating PA Request Extra Information ';
225: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
226: END IF;

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

226: END IF;
227:
228: l_log_text := substr(l_log_text,1,2000);
229:
230: hr_utility.set_location('before creating entry in log file',10);
231: ghr_mto_int.log_message( p_procedure => 'While Creating Extra Info'
232: ,p_message => l_log_text);
233:
234: hr_utility.set_location('created entry in log file',20);

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

230: hr_utility.set_location('before creating entry in log file',10);
231: ghr_mto_int.log_message( p_procedure => 'While Creating Extra Info'
232: ,p_message => l_log_text);
233:
234: hr_utility.set_location('created entry in log file',20);
235:
236:
237:
238: END CREATE_SF52_FEGLI;

Line 336: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

332: l_sf52_rec.work_schedule,
333: l_sf52_rec.part_time_hours);
334: EXCEPTION
335: WHEN OTHERS THEN
336: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
337: 'Err is '||sqlerrm(sqlcode),20);
338: l_log_text := 'Error in get_sf52_asgddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
339: || '; SQL Error: '|| sqlerrm(sqlcode);
340: raise fegli_error;

Line 370: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_pos_ddf_details'

366: ,p_office_symbol => l_sf52_rec.from_office_symbol
367: ,p_part_time_hours => l_sf52_rec.part_time_hours);
368: EXCEPTION
369: WHEN OTHERS THEN
370: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_pos_ddf_details'
371: || 'Err is' ||sqlerrm(sqlcode),20);
372: l_log_text := 'Error in get_SF52_pos_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
373: || '; SQL Error: '|| sqlerrm(sqlcode);
374: raise fegli_error;

Line 427: hr_utility.set_location('Error in ghr_api.sf52_from_data_elements'||

423: ,p_work_schedule => l_dummy_char
424: );
425: EXCEPTION
426: WHEN OTHERS THEN
427: hr_utility.set_location('Error in ghr_api.sf52_from_data_elements'||
428: 'Err is'||sqlerrm(sqlcode),20);
429: l_log_text := 'Error in sf52_from_data_elements for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
430: || '; SQL Error: '|| sqlerrm(sqlcode);
431: raise fegli_error;

Line 462: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_loc_ddf_details'||

458: (p_location_id => l_sf52_rec.duty_station_location_id
459: ,p_duty_station_id => l_sf52_rec.duty_station_id);
460: EXCEPTION
461: WHEN OTHERS THEN
462: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_SF52_loc_ddf_details'||
463: 'Err is'||sqlerrm(sqlcode),20);
464: l_log_text := 'Error in get_SF52_loc_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
465: || '; SQL Error: '||sqlerrm(sqlcode);
466: raise fegli_error;

Line 477: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_duty_station_details'||

473: ,p_duty_station_code => l_sf52_rec.duty_station_code
474: ,p_duty_station_desc => l_sf52_rec.duty_station_desc);
475: EXCEPTION
476: WHEN OTHERS THEN
477: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_duty_station_details'||
478: 'Err is '||sqlerrm(sqlcode),20);
479: l_log_text := 'Error in get_duty_station_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
480: || '; SQL Error: '|| sqlerrm(sqlcode);
481: raise fegli_error;

Line 494: hr_utility.set_location('Error in ghr_api.return_education_Details'||

490: p_year_degree_attained => l_sf52_rec.year_degree_attained
491: );
492: EXCEPTION
493: WHEN OTHERS THEN
494: hr_utility.set_location('Error in ghr_api.return_education_Details'||
495: 'Err is '||sqlerrm(sqlcode),20);
496: l_log_text := 'Error in return_education_Details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
497: || '; SQL Error:'|| sqlerrm(sqlcode);
498: raise fegli_error;

Line 513: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_SF52_person_ddf_details'||

509: p_scd_leave => l_scd_leave
510: );
511: EXCEPTION
512: WHEN OTHERS THEN
513: hr_utility.set_location('Error in ghr_pa_requests_pkg.get_SF52_person_ddf_details'||
514: 'Err is '||sqlerrm(sqlcode),20);
515: l_log_text := 'Error in get_SF52_person_ddf_details for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
516: || '; SQL Error:'|| sqlerrm(sqlcode);
517: raise fegli_error;

Line 562: hr_utility.set_location('Error in ghr_mass_actions_pkg.get_personnel_officer_name'||

558: p_person_full_name => l_personnel_officer_name,
559: p_approving_off_work_title => l_approving_off_work_title);
560: EXCEPTION
561: WHEN OTHERS THEN
562: hr_utility.set_location('Error in ghr_mass_actions_pkg.get_personnel_officer_name'||
563: 'Err is '||sqlerrm(sqlcode),20);
564: l_log_text := 'Error in get_personnel_officer_name for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
565: || '; SQL Error:'|| sqlerrm(sqlcode);
566: raise fegli_error;

Line 608: hr_utility.set_location('Error in ghr_mass_actions_pkg.get_noa_id_desc'||

604: p_noa_desc => l_sf52_rec.first_noa_desc
605: );
606: EXCEPTION
607: WHEN OTHERS THEN
608: hr_utility.set_location('Error in ghr_mass_actions_pkg.get_noa_id_desc'||
609: 'Err is '||sqlerrm(sqlcode),20);
610: l_log_text := 'Error in get_noa_id_desc for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
611: || '; SQL Error:'|| sqlerrm(sqlcode);
612: raise fegli_error;

Line 790: hr_utility.set_location('Error in ghr_sf52_api.create_sf52'||

786: p_input_pay_rate_determinant => l_sf52_rec.input_pay_rate_determinant
787: );
788: EXCEPTION
789: WHEN OTHERS THEN
790: hr_utility.set_location('Error in ghr_sf52_api.create_sf52'||
791: 'Err is '||sqlerrm(sqlcode),20);
792: l_log_text := 'Error in create sf52 for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
793: || '; SQL Error: '|| sqlerrm(sqlcode);
794: raise fegli_error;

Line 799: hr_utility.set_location('p_pa_request_id'||p_pa_request_id,1000);

795: END;
796:
797: p_pa_request_id := l_sf52_rec.pa_request_id;
798:
799: hr_utility.set_location('p_pa_request_id'||p_pa_request_id,1000);
800:
801:
802:
803:

Line 827: hr_utility.set_location('l_sf52_rec.fegli'||l_sf52_rec.fegli,1000);

823: p_pa_request_id => l_sf52_rec.pa_request_id,
824: p_routing_group_id => l_routing_group_id,
825: p_object_version_number => l_sf52_rec.object_version_number);
826:
827: hr_utility.set_location('l_sf52_rec.fegli'||l_sf52_rec.fegli,1000);
828: BEGIN
829: --Fetching the actual Fegli code from Element Entry
830: ghr_api.retrieve_element_entry_value
831: (p_element_name => 'FEGLI',

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

914: );
915:
916: EXCEPTION
917: When fegli_error then
918: hr_utility.set_location('Error occured in ' || l_proc , 1);
919: IF l_log_text is NULL THEN
920: l_log_text := 'Error while create / Update the PA Request Rec. ';
921: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
922: END IF;

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

922: END IF;
923:
924: l_log_text := substr(l_log_text,1,2000);
925:
926: hr_utility.set_location('before creating entry in log file',10);
927: ghr_mto_int.log_message( p_procedure => 'While Creating FEGLI RPA'
928: ,p_message => l_log_text);
929:
930: hr_utility.set_location('created entry in log file',20);

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

926: hr_utility.set_location('before creating entry in log file',10);
927: ghr_mto_int.log_message( p_procedure => 'While Creating FEGLI RPA'
928: ,p_message => l_log_text);
929:
930: hr_utility.set_location('created entry in log file',20);
931: WHEN others THEN
932:
933: IF l_log_text is NULL THEN
934: l_log_text := 'Error while create / Update the PA Request Rec. ';

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

934: l_log_text := 'Error while create / Update the PA Request Rec. ';
935: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
936: END IF;
937:
938: hr_utility.set_location('before creating entry in log file',10);
939:
940: ghr_mto_int.log_message(p_procedure => 'While Creating FEGLI RPA'
941: ,p_message => l_log_text);
942: hr_utility.set_location('created entry in log file',20);

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

938: hr_utility.set_location('before creating entry in log file',10);
939:
940: ghr_mto_int.log_message(p_procedure => 'While Creating FEGLI RPA'
941: ,p_message => l_log_text);
942: hr_utility.set_location('created entry in log file',20);
943:
944: END CREATE_SF52_FEGLI_RPA;
945:
946:

Line 1211: hr_utility.set_location('after updation',10);

1207: p_i_pa_routing_history_id => l_pa_routing_history_id,
1208: p_i_prh_object_version_number => l_iprh_object_version_number
1209: );
1210:
1211: hr_utility.set_location('after updation',10);
1212: hr_utility.set_location('to_position_id'||l_sf52_rec.to_position_id,10);
1213: hr_utility.set_location('l_sf52_rec.effective_date'||l_sf52_rec.effective_date,10);
1214:
1215:

Line 1212: hr_utility.set_location('to_position_id'||l_sf52_rec.to_position_id,10);

1208: p_i_prh_object_version_number => l_iprh_object_version_number
1209: );
1210:
1211: hr_utility.set_location('after updation',10);
1212: hr_utility.set_location('to_position_id'||l_sf52_rec.to_position_id,10);
1213: hr_utility.set_location('l_sf52_rec.effective_date'||l_sf52_rec.effective_date,10);
1214:
1215:
1216: BEGIN

Line 1213: hr_utility.set_location('l_sf52_rec.effective_date'||l_sf52_rec.effective_date,10);

1209: );
1210:
1211: hr_utility.set_location('after updation',10);
1212: hr_utility.set_location('to_position_id'||l_sf52_rec.to_position_id,10);
1213: hr_utility.set_location('l_sf52_rec.effective_date'||l_sf52_rec.effective_date,10);
1214:
1215:
1216: BEGIN
1217: ghr_mass_actions_pkg.get_personnel_off_groupbox(l_sf52_rec.to_position_id,

Line 1229: --hr_utility.trace_on(null,'mani');

1225: || '; Error: '||sqlerrm(sqlcode);
1226: RAISE fegli_upd_error;
1227: END;
1228:
1229: --hr_utility.trace_on(null,'mani');
1230: FOR routing_history_id in c_routing_history(p_pa_request_id => l_sf52_rec.pa_request_id)
1231: LOOP
1232: l_pa_routing_history_id := routing_history_id.pa_routing_history_id;
1233: l_object_version_number := routing_history_id.object_version_number;

Line 1235: hr_utility.set_location('before updating routing'||l_pa_routing_history_id,1000);

1231: LOOP
1232: l_pa_routing_history_id := routing_history_id.pa_routing_history_id;
1233: l_object_version_number := routing_history_id.object_version_number;
1234: -- EXIT;
1235: hr_utility.set_location('before updating routing'||l_pa_routing_history_id,1000);
1236: hr_utility.set_location('before updating routing'||l_groupbox_id,1002);
1237: END LOOP;
1238:
1239: ghr_prh_upd.upd(

Line 1236: hr_utility.set_location('before updating routing'||l_groupbox_id,1002);

1232: l_pa_routing_history_id := routing_history_id.pa_routing_history_id;
1233: l_object_version_number := routing_history_id.object_version_number;
1234: -- EXIT;
1235: hr_utility.set_location('before updating routing'||l_pa_routing_history_id,1000);
1236: hr_utility.set_location('before updating routing'||l_groupbox_id,1002);
1237: END LOOP;
1238:
1239: ghr_prh_upd.upd(
1240: p_pa_routing_history_id => l_pa_routing_history_id,

Line 1244: hr_utility.set_location('before updating par'||l_routing_group_id,1005);

1240: p_pa_routing_history_id => l_pa_routing_history_id,
1241: p_groupbox_id => l_groupbox_id,
1242: p_object_version_number => l_object_version_number,
1243: p_action_taken => 'FUTURE_ACTION');
1244: hr_utility.set_location('before updating par'||l_routing_group_id,1005);
1245: hr_utility.set_location('before updating par'||l_sf52_rec.object_version_number,1006);
1246: --hr_utility.trace_off;
1247: ghr_par_upd.upd(
1248: p_pa_request_id => l_sf52_rec.pa_request_id,

Line 1245: hr_utility.set_location('before updating par'||l_sf52_rec.object_version_number,1006);

1241: p_groupbox_id => l_groupbox_id,
1242: p_object_version_number => l_object_version_number,
1243: p_action_taken => 'FUTURE_ACTION');
1244: hr_utility.set_location('before updating par'||l_routing_group_id,1005);
1245: hr_utility.set_location('before updating par'||l_sf52_rec.object_version_number,1006);
1246: --hr_utility.trace_off;
1247: ghr_par_upd.upd(
1248: p_pa_request_id => l_sf52_rec.pa_request_id,
1249: p_routing_group_id => l_routing_group_id,

Line 1246: --hr_utility.trace_off;

1242: p_object_version_number => l_object_version_number,
1243: p_action_taken => 'FUTURE_ACTION');
1244: hr_utility.set_location('before updating par'||l_routing_group_id,1005);
1245: hr_utility.set_location('before updating par'||l_sf52_rec.object_version_number,1006);
1246: --hr_utility.trace_off;
1247: ghr_par_upd.upd(
1248: p_pa_request_id => l_sf52_rec.pa_request_id,
1249: p_routing_group_id => l_routing_group_id,
1250: p_object_version_number => l_sf52_rec.object_version_number);

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

1326:
1327:
1328: EXCEPTION
1329: When fegli_upd_error then
1330: hr_utility.set_location('Error occured in ' || l_proc , 1);
1331: IF l_log_text is NULL THEN
1332: l_log_text := 'Error while Update the PA Request Rec. ';
1333: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
1334: END IF;

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

1334: END IF;
1335:
1336: l_log_text := substr(l_log_text,1,2000);
1337:
1338: hr_utility.set_location('before creating entry in log file',10);
1339: ghr_mto_int.log_message( p_procedure => 'While Updating FEGLI RPA'
1340: ,p_message => l_log_text);
1341:
1342: hr_utility.set_location('created entry in log file',20);

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

1338: hr_utility.set_location('before creating entry in log file',10);
1339: ghr_mto_int.log_message( p_procedure => 'While Updating FEGLI RPA'
1340: ,p_message => l_log_text);
1341:
1342: hr_utility.set_location('created entry in log file',20);
1343: WHEN others THEN
1344:
1345: IF l_log_text is NULL THEN
1346: l_log_text := 'Error while Update the PA Request Rec. ';

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

1346: l_log_text := 'Error while Update the PA Request Rec. ';
1347: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
1348: END IF;
1349:
1350: hr_utility.set_location('before creating entry in log file',10);
1351:
1352: ghr_mto_int.log_message(p_procedure => 'While Updating FEGLI RPA'
1353: ,p_message => l_log_text);
1354: hr_utility.set_location('created entry in log file',20);

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

1350: hr_utility.set_location('before creating entry in log file',10);
1351:
1352: ghr_mto_int.log_message(p_procedure => 'While Updating FEGLI RPA'
1353: ,p_message => l_log_text);
1354: hr_utility.set_location('created entry in log file',20);
1355:
1356:
1357:
1358: END UPDATE_SF52_FEGLI_RPA;

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

1385:
1386: begin
1387:
1388: -- get remark_id remark_desc, remark_code_information1, ...
1389: hr_utility.set_location('Entering ' || l_proc,5);
1390:
1391: ghr_mass_actions_pkg.get_remark_id_desc
1392: (p_remark_code => p_remark_code,
1393: p_effective_date => trunc(nvl(p_effective_date,sysdate)),

Line 1626: hr_utility.set_location('bef upd of shad ' || 'ovn ' || l_object_version_number,2);

1622: p_rei_information28 => p_attribute28,
1623: p_rei_information29 => p_attribute29,
1624: p_rei_information30 => p_attribute30
1625: );
1626: hr_utility.set_location('bef upd of shad ' || 'ovn ' || l_object_version_number,2);
1627:
1628: update ghr_pa_request_ei_shadow set
1629: rei_information1 = p_attribute1,
1630: rei_information2 = p_attribute2,