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 475: ---fnd_file.put_line(fnd_file.log,' supercede mode is not null, changing the exec string ');

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

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

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

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

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

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

672: OUT det_schedule_end_date,
673: IN l_request_id, l_start_person, l_end_person, l_element_set_id, p_effort_start, p_effort_end
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:

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

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

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

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

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

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

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

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

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

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

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

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

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

769:
770:
771:
772:
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 ');

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

771:
772:
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

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

878: sysdate
879: ) 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;
880:
881:
882: -- fnd_file.put_line(fnd_file.log,'==== after det '|| effort_det_lines_rec.effort_report_detail_id.count);
883:
884:
885:
886:

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

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

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

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

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

909: END IF;
910:
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
1163:
1164: END IF;

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

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

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

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;
1175: END IF;
1176:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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