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 FND_FILE

Line 23: --fnd_file.put_line(fnd_file.log,'ST===='||stperson||'--END='||endperson);

19: (select request_id from pay_payroll_actions where payroll_action_id= p_pactid);
20:
21: begin
22:
23: --fnd_file.put_line(fnd_file.log,'ST===='||stperson||'--END='||endperson);
24:
25:
26: open c_person_actions(p_pactid, stperson, endperson);
27:

Line 77: -- fnd_file.put_line(fnd_file.log, 'start date i s '||g_psp_effort_start);

73: g_psp_effort_end:= trunc(fnd_date.canonical_to_date(psp_template_selection.get_parameter_value('END_DATE', param_string)));
74:
75:
76:
77: -- fnd_file.put_line(fnd_file.log, 'start date i s '||g_psp_effort_start);
78: -- fnd_file.put_line(fnd_file.log, 'end date is '||g_psp_effort_end);
79:
80:
81: /* insert record in psp_report_templates_h */

Line 78: -- fnd_file.put_line(fnd_file.log, 'end date is '||g_psp_effort_end);

74:
75:
76:
77: -- fnd_file.put_line(fnd_file.log, 'start date i s '||g_psp_effort_start);
78: -- fnd_file.put_line(fnd_file.log, 'end date is '||g_psp_effort_end);
79:
80:
81: /* insert record in psp_report_templates_h */
82:

Line 99: --fnd_file.put_line(fnd_file.log,' inside archiver' );

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);
102:
103: end;

Line 100: --fnd_file.put_line(fnd_file.log,' chunk is '||chunk_number );

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);
102:
103: end;
104:

Line 303: -- fnd_file.put_line(fnd_file.log, 'g_psp_request_id is '||g_psp_request_id);

299: */
300:
301:
302:
303: -- fnd_file.put_line(fnd_file.log, 'g_psp_request_id is '||g_psp_request_id);
304: -- fnd_file.put_line(fnd_file.log, 'l_request__id '||l_request_id);
305: -- fnd_file.put_line(fnd_file.log, ' before starting l_retry_request__id '||l_retry_request_id);
306:
307: IF g_psp_request_id = l_request_id then

Line 304: -- fnd_file.put_line(fnd_file.log, 'l_request__id '||l_request_id);

300:
301:
302:
303: -- fnd_file.put_line(fnd_file.log, 'g_psp_request_id is '||g_psp_request_id);
304: -- fnd_file.put_line(fnd_file.log, 'l_request__id '||l_request_id);
305: -- fnd_file.put_line(fnd_file.log, ' before starting l_retry_request__id '||l_retry_request_id);
306:
307: IF g_psp_request_id = l_request_id then
308: l_retry_request_id := NULL;

Line 305: -- fnd_file.put_line(fnd_file.log, ' before starting l_retry_request__id '||l_retry_request_id);

301:
302:
303: -- fnd_file.put_line(fnd_file.log, 'g_psp_request_id is '||g_psp_request_id);
304: -- fnd_file.put_line(fnd_file.log, 'l_request__id '||l_request_id);
305: -- fnd_file.put_line(fnd_file.log, ' before starting l_retry_request__id '||l_retry_request_id);
306:
307: IF g_psp_request_id = l_request_id then
308: l_retry_request_id := NULL;
309: ELSE

Line 315: -- fnd_file.put_line(fnd_file.log, 'request i dis '|| p_request_id);

311: END IF;
312:
313:
314:
315: -- fnd_file.put_line(fnd_file.log, 'request i dis '|| p_request_id);
316: -- fnd_file.put_line(fnd_file.log, ' retry request i dis ' || l_retry_request_id);
317:
318:
319:

Line 316: -- fnd_file.put_line(fnd_file.log, ' retry request i dis ' || l_retry_request_id);

312:
313:
314:
315: -- fnd_file.put_line(fnd_file.log, 'request i dis '|| p_request_id);
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);

Line 323: -- fnd_file.put_line(fnd_file.log,' retry_Request_id = '||l_retry_request_id );

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
325: psp_report_templates_h where request_id = l_request_id;
326:
327: select criteria_value1 into l_element_set_id from psp_report_template_details_h where

Line 336: --fnd_file.put_line(fnd_file.log,' chunk num = *** '||p_chunk_num||'start_end= '||l_Start_person ||' '||l_end_person );

332: and action_status<> 'C';
333:
334: */
335:
336: --fnd_file.put_line(fnd_file.log,' chunk num = *** '||p_chunk_num||'start_end= '||l_Start_person ||' '||l_end_person );
337: ---- Warning: any change in this string will impact superceding,
338: ----- change here needs to sync up with query for superceding.
339: g_exec_string := '
340: SELECT

Line 477: ---fnd_file.put_line(fnd_file.log,' supercede mode is not null, changing the exec string ');

473: /*psl.person_id */
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)

Line 618: --fnd_file.put_line(fnd_file.log,' dyn sql = '||g_exec_string);

614:
615: -- g_exec_string := replace(g_exec_string, ' group by psl.person_id ' , ' group by person_id'||l_grp_string);
616:
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:

Line 619: --fnd_file.put_line(fnd_file.log,' dyn sql = '||l_grp_string);

615: -- g_exec_string := replace(g_exec_string, ' group by psl.person_id ' , ' group by person_id'||l_grp_string);
616:
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: /*

Line 678: -- fnd_file.put_line(fnd_file.log,' =====after dyn sql '||i);

674: OUT det_schedule_end_date,
675: IN l_request_id, l_start_person, l_end_person, l_profile_sob_id, l_profile_bg_id, l_element_set_id, p_effort_start, p_effort_end --Added for Bug 11923895
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:

Line 702: -- fnd_file.put_line(fnd_file.log,' after bulk fetch ');

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:
706:

Line 704: -- fnd_file.put_line(fnd_file.log, 'count is '||effort_det_lines_rec.person_id.count);

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:
706:
707: /*
708: IF effort_det_lines_rec.person_id.count > 0 then

Line 715: -- fnd_file.put_line(fnd_file.log, 'count person is '||det_person_id.count);

711:
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;

Line 720: -- fnd_file.put_line(fnd_file.log,' before inserting into psp_eff_reports ');

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 ');
721:
722: -- fnd_file.put_line(fnd_file.log,' =====inserting in psp_eff_reports ');
723:
724: FORALL i IN 1..person_rec.array_person_id.count

Line 722: -- fnd_file.put_line(fnd_file.log,' =====inserting in psp_eff_reports ');

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 ');
721:
722: -- fnd_file.put_line(fnd_file.log,' =====inserting in psp_eff_reports ');
723:
724: FORALL i IN 1..person_rec.array_person_id.count
725: insert into psp_eff_reports(
726: effort_report_id,

Line 764: -- fnd_file.put_line(fnd_file.log , 'after insert into eff '||person_rec.array_effort_report_id.count);

760: l_profile_sob_id) returning effort_report_id bulk collect into person_rec.array_effort_report_id;
761:
762: end if;
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: /*

Line 775: -- fnd_file.put_line(fnd_file.log,' before inserting into psp_report_details ');

771:
772:
773:
774:
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 ');

Line 777: -- fnd_file.put_line(fnd_file.log,' =====inserting in psp_eff_report_details ');

773:
774:
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

Line 884: -- fnd_file.put_line(fnd_file.log,'==== after det '|| effort_det_lines_rec.effort_report_detail_id.count);

880: sysdate
881: ) returning to_number(det_person_id(i)), effort_report_detail_id bulk collect into effort_det_lines_rec.person_id, effort_det_lines_rec.effort_report_detail_id;
882:
883:
884: -- fnd_file.put_line(fnd_file.log,'==== after det '|| effort_det_lines_rec.effort_report_detail_id.count);
885:
886:
887:
888:

Line 889: -- fnd_file.put_line(fnd_file.log,' after deatils ');

885:
886:
887:
888:
889: -- fnd_file.put_line(fnd_file.log,' after deatils ');
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

Line 891: -- fnd_file.put_line(fnd_file.log,' ===== IF p_supercede_mode is not null THEN ');

887:
888:
889: -- fnd_file.put_line(fnd_file.log,' after deatils ');
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:

Line 915: -- fnd_file.put_line(fnd_file.log,' after update of effort report details ');

911: END IF;
912:
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;

Line 970: -- fnd_file.put_line(fnd_file.log,' ===== IF l_HUNDRED_PCENT_EFF_AT_PER_ASG');

966:
967: -- OHSU Changes
968:
969:
970: -- fnd_file.put_line(fnd_file.log,' ===== IF l_HUNDRED_PCENT_EFF_AT_PER_ASG');
971:
972: IF l_HUNDRED_PCENT_EFF_AT_PER_ASG = 'A' then
973:
974: select sum(actual_salary_amt), effort_report_id, assignment_id bulk collect

Line 1016: --- fnd_file.put_line(fnd_file.log,' after getting sum ');

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
1019: -- update psp_Eff_report_details set payroll_percent = round(actual_salary_amt/person_rec.sum_tot(i),2)*100 where effort_report_id =
1020: -- person_rec.array_effort_report_id(i);

Line 1040: -- fnd_file.put_line(fnd_file.log,' after getting sum ');

1036: effort_report_detail_id in (select max(effort_report_detail_id) from psp_eff_report_details where
1037: effort_report_id = person_rec.array_effort_report_id(i) and person_rec.payroll_percent_tot(i)<>0) ;
1038: END IF;
1039:
1040: -- fnd_file.put_line(fnd_file.log,' after getting sum ');
1041:
1042:
1043: /*
1044: should be person or assignment depending on whether assignment is used as a summarization criteria

Line 1057: -- fnd_file.put_line(fnd_file.log,' after details update ');

1053:
1054: /* to update the last line in the case it exceeds 100 */
1055:
1056:
1057: -- fnd_file.put_line(fnd_file.log,' after details update ');
1058:
1059:
1060:
1061: -- OHSU Changes

Line 1088: -- fnd_file.put_line(fnd_file.log,' after delete of orphan record ');

1084: delete from psp_eff_reports per where effort_report_id > min_effort_report_id and
1085: not exists (select 1 from psp_eff_report_details perd where
1086: perd.effort_report_id = per.effort_report_id);
1087:
1088: -- fnd_file.put_line(fnd_file.log,' after delete of orphan record ');
1089:
1090:
1091: /* added this call just to see how retry works
1092:

Line 1104: -- fnd_file.put_line(fnd_file.log,' before return ');

1100:
1101: if p_supercede_mode is not null then
1102:
1103:
1104: -- fnd_file.put_line(fnd_file.log,' before return ');
1105: retcode := 0;
1106: return;
1107: end if;
1108:

Line 1119: -- fnd_file.put_line(fnd_file.log,' ===== Populate_error_table');

1115: -- psp_eff_report_details_api.update_eff_report_details(l_request_id);
1116:
1117: --psp_eff_report_details_api.update_eff_report_details(p_validate , l_request_id, p_warning );
1118: /* for Bug fix 4089645 Added Person id check */
1119: -- fnd_file.put_line(fnd_file.log,' ===== Populate_error_table');
1120:
1121:
1122: Populate_error_table( l_request_id, l_start_person, l_end_person, min_effort_report_id, l_retry_request_id, null, null);
1123:

Line 1139: psp_message_s.print_error(p_mode=>FND_FILE.log,

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);
1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1142:
1143: END IF;

Line 1152: -- fnd_file.put_line(fnd_file.log,' ===== psp_xmlgen.update_er_details');

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 ,
1156: l_request_id,

Line 1162: psp_message_s.print_error(p_mode=>FND_FILE.log,

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;
1165:
1166: END IF;

Line 1167: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');

1163: p_print_header=>FND_API.G_TRUE);
1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165:
1166: END IF;
1167: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');
1168:
1169:
1170: psp_xmlgen.update_grouping_category(l_start_person, l_end_person, l_request_id, l_return_status) ;
1171:

Line 1174: psp_message_s.print_error(p_mode=>FND_FILE.log,

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;
1177: END IF;
1178:

Line 1179: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');

1175: p_print_header=>FND_API.G_TRUE);
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');
1180:
1181: psp_eff_report_details_api.update_eff_report_details(p_validate , l_request_id,l_start_person, l_end_person, p_warning );
1182:
1183: -- Check weather Project, Task, Award, Exp Org are valid or not

Line 1191: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate');

1187: p_request_id => l_request_id,
1188: p_retry_request_id => l_retry_request_id,
1189: p_return_status => l_return_status) ;
1190:
1191: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate');
1192:
1193: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status = fnd_api.g_ret_sts_error) then
1194: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate in side error');
1195:

Line 1194: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate in side error');

1190:
1191: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate');
1192:
1193: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status = fnd_api.g_ret_sts_error) then
1194: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate in side error');
1195:
1196: psp_message_s.print_error(p_mode=>FND_FILE.log,
1197: p_print_header=>FND_API.G_TRUE);
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1196: psp_message_s.print_error(p_mode=>FND_FILE.log,

1192:
1193: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status = fnd_api.g_ret_sts_error) then
1194: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate in side error');
1195:
1196: psp_message_s.print_error(p_mode=>FND_FILE.log,
1197: p_print_header=>FND_API.G_TRUE);
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200:

Line 1201: -- fnd_file.put_line(fnd_file.log,' ===== psp_er_ame.get_first_approvers');

1197: p_print_header=>FND_API.G_TRUE);
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200:
1201: -- fnd_file.put_line(fnd_file.log,' ===== psp_er_ame.get_first_approvers');
1202:
1203: psp_er_ame.get_first_approvers(l_request_id ,
1204: l_start_person,
1205: l_end_person ,

Line 1215: psp_message_s.print_error(p_mode=>FND_FILE.log,

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
1215: psp_message_s.print_error(p_mode=>FND_FILE.log,
1216: p_print_header=>FND_API.G_TRUE);
1217:
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219:

Line 1222: -- fnd_file.put_line(fnd_file.log,' ===== psp_xmlgen.update_er_person_xml');

1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219:
1220: END IF;
1221:
1222: -- fnd_file.put_line(fnd_file.log,' ===== psp_xmlgen.update_er_person_xml');
1223:
1224: psp_xmlgen.update_er_person_xml(l_start_person ,
1225: l_end_person ,
1226: l_request_id,

Line 1233: psp_message_s.print_error(p_mode=>FND_FILE.log,

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);
1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1236:
1237: END IF;

Line 1248: fnd_file.put_line(fnd_file.log,' Unhandled exception raised '||sqlerrm);

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);
1252: psp_general.add_report_error(l_request_id, 'E',null, l_retry_request_id, null, l_sqlerrm,l_return_status);

Line 1328: -- fnd_file.put_line(fnd_file.log,'orig is '||p_request_id||'--RETRY '||l_retry_request_id);

1324:
1325:
1326: */
1327:
1328: -- fnd_file.put_line(fnd_file.log,'orig is '||p_request_id||'--RETRY '||l_retry_request_id);
1329: if p_mode = 'PRE-POPULATE' then
1330:
1331: /* A pending or Approved Effort Report already exists */
1332: