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 478: hr_utility.trace(' create_eff --> supercede mode is not null, changing the exec string ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 894: 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 );

890:
891: -- fnd_file.put_line(fnd_file.log,' ===== IF p_supercede_mode is not null THEN ');
892:
893: IF p_supercede_mode is not null THEN
894: 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 );
895:
896: FORALL i in 1..effort_det_lines_rec.effort_report_detail_id.count
897: update psp_eff_report_details set effort_report_id =
898: (select effort_report_id from psp_eff_reports where

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

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

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

975: into person_rec.sum_tot, person_rec.array_effort_report_id, person_rec.array_assignment_id
976: from psp_eff_report_details where
977: effort_report_id > min_effort_report_id group by effort_report_id, assignment_id;
978:
979: hr_utility.trace('psp_create_eff_reports--> After getting sum');
980:
981: FORALL i in 1..person_rec.array_assignment_id.count
982: 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))
983: where effort_report_id = person_rec.array_effort_report_id(i)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1240: -- hr_utility.trace_off;

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

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

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

Line 1256: -- hr_utility.trace_off;

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