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

Line 97: --hr_utility.trace_on('Y','ORACLE');

93:
94: begin
95:
96:
97: --hr_utility.trace_on('Y','ORACLE');
98:
99: --fnd_file.put_line(fnd_file.log,' inside archiver' );
100: --fnd_file.put_line(fnd_file.log,' chunk is '||chunk_number );
101: create_effort_reports(errBuf, retcode, payroll_action_id, g_psp_request_id, chunk_number);

Line 241: ---hr_utility.trace(' COUNT of supercede persons_gt ='|| l_gt_Count);

237: l_gt_count integer;
238: BEGIN
239:
240: ---select count(*) into l_gt_count from psp_supercede_persons_gt ;
241: ---hr_utility.trace(' COUNT of supercede persons_gt ='|| l_gt_Count);
242:
243: l_profile_sob_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
244: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
245: l_bg_currency_code := psp_general.get_currency_code(l_profile_bg_id);

Line 320: hr_utility.trace('psp_create_eff_reports--> request_id, retry_request_id, st_person, end_person = '|| p_request_id||' '||l_retry_request_id ||' '|| l_start_person||' '|| l_end_person);

316: -- fnd_file.put_line(fnd_file.log, ' retry request i dis ' || l_retry_request_id);
317:
318:
319:
320: hr_utility.trace('psp_create_eff_reports--> request_id, retry_request_id, st_person, end_person = '|| p_request_id||' '||l_retry_request_id ||' '|| l_start_person||' '|| l_end_person);
321:
322:
323: -- fnd_file.put_line(fnd_file.log,' retry_Request_id = '||l_retry_request_id );
324: select parameter_value_2, parameter_value_3 into p_effort_start, p_effort_end from

Line 476: hr_utility.trace(' create_eff --> supercede mode is not null, changing the exec string ');

472: ';
473:
474: if p_supercede_mode is not null then
475: ---fnd_file.put_line(fnd_file.log,' supercede mode is not null, changing the exec string ');
476: hr_utility.trace(' create_eff --> supercede mode is not null, changing the exec string ');
477: --- added for uva issues (assignment matching only)
478: -- rows inserted thru supercede will have -ve request_id and will be rolled
479: --- back immediately by summarize_transfer process (transient)
480:

Line 619: --- hr_utility.trace(' dyn sql = '||g_exec_string);

615:
616: --fnd_file.put_line(fnd_file.log,' dyn sql = '||g_exec_string);
617: --fnd_file.put_line(fnd_file.log,' dyn sql = '||l_grp_string);
618:
619: --- hr_utility.trace(' dyn sql = '||g_exec_string);
620:
621: /*
622: det_string := '
623: effort_det_lines_rec.person_id,

Line 678: hr_utility.trace('psp_create_eff_reports--> After dyn sql');

674: ;
675:
676: -- fnd_file.put_line(fnd_file.log,' =====after dyn sql '||i);
677:
678: hr_utility.trace('psp_create_eff_reports--> After dyn sql');
679:
680:
681:
682:

Line 694: hr_utility.trace(' psp_create_eff_reports--> get_supercede_persons Count = '|| person_rec.array_person_id.count);

690: g_summarization_criteria := l_grp_string;
691: OPEN get_supercede_persons;
692: FETCH get_supercede_persons bulk collect into person_rec.array_person_id;
693: CLOSE get_supercede_persons;
694: hr_utility.trace(' psp_create_eff_reports--> get_supercede_persons Count = '|| person_rec.array_person_id.count);
695: end if;
696:
697:
698:

Line 699: hr_utility.trace('psp_create_eff_reports--> After bulk fetch');

695: end if;
696:
697:
698:
699: hr_utility.trace('psp_create_eff_reports--> After bulk fetch');
700: -- fnd_file.put_line(fnd_file.log,' after bulk fetch ');
701:
702: -- fnd_file.put_line(fnd_file.log, 'count is '||effort_det_lines_rec.person_id.count);
703:

Line 714: hr_utility.trace ('count person is '||det_person_id.count);

710:
711: */
712:
713: -- fnd_file.put_line(fnd_file.log, 'count person is '||det_person_id.count);
714: hr_utility.trace ('count person is '||det_person_id.count);
715:
716: IF det_person_id.count >0 then
717: l_loop_count := l_loop_count + det_person_id.count;
718: -- fnd_file.put_line(fnd_file.log,' before inserting into psp_eff_reports ');

Line 765: hr_utility.trace('psp_create_eff_reports--> After insert into eff '||person_rec.array_effort_report_id.count);

761:
762: -- fnd_file.put_line(fnd_file.log , 'after insert into eff '||person_rec.array_effort_report_id.count);
763:
764:
765: hr_utility.trace('psp_create_eff_reports--> After insert into eff '||person_rec.array_effort_report_id.count);
766: /*
767:
768: */
769:

Line 777: hr_utility.trace('psp_create_eff_reports--> before inserting into details ');

773: -- fnd_file.put_line(fnd_file.log,' before inserting into psp_report_details ');
774:
775: -- fnd_file.put_line(fnd_file.log,' =====inserting in psp_eff_report_details ');
776:
777: hr_utility.trace('psp_create_eff_reports--> before inserting into details ');
778:
779: FORALL i in 1..det_person_id.count
780: insert into psp_eff_report_details(
781: effort_report_detail_id,

Line 892: hr_utility.trace(' psp_create_eff_reports--> updating erd count ='|| effort_det_lines_rec.effort_report_detail_id.count ||' min_effort_Report_id = '||min_effort_report_id );

888:
889: -- fnd_file.put_line(fnd_file.log,' ===== IF p_supercede_mode is not null THEN ');
890:
891: IF p_supercede_mode is not null THEN
892: hr_utility.trace(' psp_create_eff_reports--> updating erd count ='|| effort_det_lines_rec.effort_report_detail_id.count ||' min_effort_Report_id = '||min_effort_report_id );
893:
894: FORALL i in 1..effort_det_lines_rec.effort_report_detail_id.count
895: update psp_eff_report_details set effort_report_id =
896: (select effort_report_id from psp_eff_reports where

Line 915: hr_utility.trace('psp_create_eff_reports--> After update of psp_eff_report_detail ');

911:
912:
913: -- fnd_file.put_line(fnd_file.log,' after update of effort report details ');
914:
915: hr_utility.trace('psp_create_eff_reports--> After update of psp_eff_report_detail ');
916:
917: effort_Det_lines_rec.effort_report_detail_id.delete;
918: effort_det_lines_rec.person_id.delete;
919:

Line 977: hr_utility.trace('psp_create_eff_reports--> After getting sum');

973: into person_rec.sum_tot, person_rec.array_effort_report_id, person_rec.array_assignment_id
974: from psp_eff_report_details where
975: effort_report_id > min_effort_report_id group by effort_report_id, assignment_id;
976:
977: hr_utility.trace('psp_create_eff_reports--> After getting sum');
978:
979: FORALL i in 1..person_rec.array_assignment_id.count
980: update psp_Eff_report_details set payroll_percent = decode(person_rec.sum_tot(i),0,0,round( ((actual_salary_amt * 100) / person_rec.sum_tot(i)),2))
981: where effort_report_id = person_rec.array_effort_report_id(i)

Line 995: hr_utility.trace('psp_create_eff_reports--> After sum payroll percent');

991: into person_rec.payroll_percent_tot, person_rec.array_effort_report_id, person_rec.array_assignment_id
992: from psp_eff_report_details where effort_report_id > min_effort_report_id group by effort_report_id , assignment_id;
993:
994:
995: hr_utility.trace('psp_create_eff_reports--> After sum payroll percent');
996:
997: FORALL i in 1..person_rec.array_assignment_id.count
998: update psp_eff_report_details set payroll_percent = payroll_percent + (100.00 - person_rec.payroll_percent_tot(i))
999: where effort_report_detail_id in (

Line 1012: hr_utility.trace('psp_create_eff_reports--> After getting sum');

1008: select sum(actual_salary_amt), effort_report_id bulk collect into person_rec.sum_tot, person_rec.array_effort_report_id
1009: from psp_eff_report_details where
1010: effort_report_id > min_effort_report_id group by effort_report_id ;
1011:
1012: hr_utility.trace('psp_create_eff_reports--> After getting sum');
1013:
1014: --- fnd_file.put_line(fnd_file.log,' after getting sum ');
1015:
1016: FORALL i in 1..person_rec.array_effort_report_id.count

Line 1134: hr_utility.trace('psp_create_eff_reports--> After xmlgen.copy_ptaoe_from_gl_segments');

1130: l_request_id,
1131: l_retry_request_id,
1132: l_profile_bg_id,
1133: l_return_status) ;
1134: hr_utility.trace('psp_create_eff_reports--> After xmlgen.copy_ptaoe_from_gl_segments');
1135:
1136: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1137: psp_message_s.print_error(p_mode=>FND_FILE.log,
1138: p_print_header=>FND_API.G_TRUE);

Line 1149: hr_utility.trace('psp_create_eff_reports--> After costs share API');

1145: if p_warning = true then
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: end if;
1148:
1149: hr_utility.trace('psp_create_eff_reports--> After costs share API');
1150: -- fnd_file.put_line(fnd_file.log,' ===== psp_xmlgen.update_er_details');
1151:
1152: psp_xmlgen.update_er_details(l_start_person ,
1153: l_end_person ,

Line 1158: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_details');

1154: l_request_id,
1155: l_retry_request_id,
1156: l_return_status) ;
1157:
1158: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_details');
1159: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1160: psp_message_s.print_error(p_mode=>FND_FILE.log,
1161: p_print_header=>FND_API.G_TRUE);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1170: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_grouping_category');

1166:
1167:
1168: psp_xmlgen.update_grouping_category(l_start_person, l_end_person, l_request_id, l_return_status) ;
1169:
1170: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_grouping_category');
1171: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1172: psp_message_s.print_error(p_mode=>FND_FILE.log,
1173: p_print_header=>FND_API.G_TRUE);
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1208: hr_utility.trace('psp_create_eff_reports--> After psp_er_ame.get_first_approvers');

1204: l_return_status,
1205: l_retry_request_id );
1206:
1207:
1208: hr_utility.trace('psp_create_eff_reports--> After psp_er_ame.get_first_approvers');
1209:
1210:
1211:
1212: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status=fnd_api.g_ret_sts_error) then

Line 1228: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_person_xml');

1224: l_request_id,
1225: l_retry_request_id,
1226: l_return_status) ;
1227:
1228: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_person_xml');
1229:
1230: If (l_return_status = fnd_api.g_ret_sts_error ) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1231: psp_message_s.print_error(p_mode=>FND_FILE.log,
1232: p_print_header=>FND_API.G_TRUE);

Line 1238: -- hr_utility.trace_off;

1234:
1235: END IF;
1236:
1237: END IF;
1238: -- hr_utility.trace_off;
1239:
1240: EXCEPTION
1241: when FND_API.G_EXC_UNEXPECTED_ERROR then
1242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1245: -- hr_utility.trace('psp_create_eff_reports--> Exception '||sqlerrm);

1241: when FND_API.G_EXC_UNEXPECTED_ERROR then
1242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1243: when others then
1244: BEGIN
1245: -- hr_utility.trace('psp_create_eff_reports--> Exception '||sqlerrm);
1246: fnd_file.put_line(fnd_file.log,' Unhandled exception raised '||sqlerrm);
1247: fnd_message.set_name('PSP','PSP_ER_CREATE_UNEXPECTED_ERROR');
1248: l_err_mesg := substr(fnd_message.get,1,2000);
1249: l_sqlerrm := l_err_mesg || substr(sqlerrm,1,200);

Line 1254: -- hr_utility.trace_off;

1250: psp_general.add_report_error(l_request_id, 'E',null, l_retry_request_id, null, l_sqlerrm,l_return_status);
1251:
1252: /* Below lines added for supercedence requirement
1253: */
1254: -- hr_utility.trace_off;
1255:
1256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1257: END;
1258: