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.EAM_WO_IMPORT_DS_PVT dependencies on FND_FILE

Line 86: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error .Structure failed while updating work order hierarchy with parent work order ' || p_top_wip_entity_id);

82: AND process_status =2);
83: END IF;
84:
85: IF p_validate_fail THEN
86: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error .Structure failed while updating work order hierarchy with parent work order ' || p_top_wip_entity_id);
87: fnd_file.put_line(FND_FILE.LOG,'Error Stack: ');
88: IF p_wo_relationship_exc_tbl.count > 0 THEN
89: FOR work_rel_counter IN p_wo_relationship_exc_tbl.FIRST..p_wo_relationship_exc_tbl.LAST LOOP
90: INSERT INTO EAM_WORK_ORDER_IMPORT_ERRORS(

Line 87: fnd_file.put_line(FND_FILE.LOG,'Error Stack: ');

83: END IF;
84:
85: IF p_validate_fail THEN
86: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error .Structure failed while updating work order hierarchy with parent work order ' || p_top_wip_entity_id);
87: fnd_file.put_line(FND_FILE.LOG,'Error Stack: ');
88: IF p_wo_relationship_exc_tbl.count > 0 THEN
89: FOR work_rel_counter IN p_wo_relationship_exc_tbl.FIRST..p_wo_relationship_exc_tbl.LAST LOOP
90: INSERT INTO EAM_WORK_ORDER_IMPORT_ERRORS(
91: header_id ,

Line 112: fnd_file.put_line(FND_FILE.LOG,p_wo_relationship_exc_tbl(work_rel_counter));

108: sysdate,
109: fnd_global.user_id,
110: fnd_global.login_id
111: );
112: fnd_file.put_line(FND_FILE.LOG,p_wo_relationship_exc_tbl(work_rel_counter));
113: END LOOP;
114: END IF;
115: fnd_file.put_line(FND_FILE.LOG,'Hence Marking following workorders under hierarchy as failed :');
116: FOR log_counter IN (SELECT wip_entity_id

Line 115: fnd_file.put_line(FND_FILE.LOG,'Hence Marking following workorders under hierarchy as failed :');

111: );
112: fnd_file.put_line(FND_FILE.LOG,p_wo_relationship_exc_tbl(work_rel_counter));
113: END LOOP;
114: END IF;
115: fnd_file.put_line(FND_FILE.LOG,'Hence Marking following workorders under hierarchy as failed :');
116: FOR log_counter IN (SELECT wip_entity_id
117: FROM EAM_WORK_ORDER_IMPORT
118: WHERE group_id = p_group_id
119: AND top_wip_entity_id=p_top_wip_entity_id

Line 122: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error for work order --' || log_counter.wip_entity_id);

118: WHERE group_id = p_group_id
119: AND top_wip_entity_id=p_top_wip_entity_id
120: )
121: LOOP
122: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error for work order --' || log_counter.wip_entity_id);
123: END LOOP;
124:
125: ELSE -- Validate structure has not failed.Error occured before calling validate structure
126:

Line 127: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error .Structure failed while updating the one of work order under the hierarchy with parent work order ' || p_top_wip_entity_id);

123: END LOOP;
124:
125: ELSE -- Validate structure has not failed.Error occured before calling validate structure
126:
127: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error .Structure failed while updating the one of work order under the hierarchy with parent work order ' || p_top_wip_entity_id);
128: fnd_file.put_line(FND_FILE.LOG,'Error Stack :' || temp_err_mesg);
129: fnd_file.put_line(FND_FILE.LOG,'Hence Marking following workorders under hierarchy as failed :');
130: FOR log_counter IN ( SELECT wip_entity_id
131: FROM EAM_WORK_ORDER_IMPORT

Line 128: fnd_file.put_line(FND_FILE.LOG,'Error Stack :' || temp_err_mesg);

124:
125: ELSE -- Validate structure has not failed.Error occured before calling validate structure
126:
127: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error .Structure failed while updating the one of work order under the hierarchy with parent work order ' || p_top_wip_entity_id);
128: fnd_file.put_line(FND_FILE.LOG,'Error Stack :' || temp_err_mesg);
129: fnd_file.put_line(FND_FILE.LOG,'Hence Marking following workorders under hierarchy as failed :');
130: FOR log_counter IN ( SELECT wip_entity_id
131: FROM EAM_WORK_ORDER_IMPORT
132: WHERE group_id = p_group_id

Line 129: fnd_file.put_line(FND_FILE.LOG,'Hence Marking following workorders under hierarchy as failed :');

125: ELSE -- Validate structure has not failed.Error occured before calling validate structure
126:
127: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error .Structure failed while updating the one of work order under the hierarchy with parent work order ' || p_top_wip_entity_id);
128: fnd_file.put_line(FND_FILE.LOG,'Error Stack :' || temp_err_mesg);
129: fnd_file.put_line(FND_FILE.LOG,'Hence Marking following workorders under hierarchy as failed :');
130: FOR log_counter IN ( SELECT wip_entity_id
131: FROM EAM_WORK_ORDER_IMPORT
132: WHERE group_id = p_group_id
133: AND top_wip_entity_id=p_top_wip_entity_id

Line 136: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error for work order --' || log_counter.wip_entity_id);

132: WHERE group_id = p_group_id
133: AND top_wip_entity_id=p_top_wip_entity_id
134: )
135: LOOP
136: fnd_file.put_line(FND_FILE.LOG,'Status Relationship Error for work order --' || log_counter.wip_entity_id);
137: END LOOP;
138: END IF;
139:
140: COMMIT;

Line 237: fnd_file.put_line(FND_FILE.LOG,'Status Error for work order --' || p_wo_rec.wip_entity_id);

233: );
234:
235: END LOOP;
236: END IF; -- end if for l_msg_count>0
237: fnd_file.put_line(FND_FILE.LOG,'Status Error for work order --' || p_wo_rec.wip_entity_id);
238: fnd_file.put_line(FND_FILE.LOG,'Error Stack --' || temp_err_mesg);
239:
240:
241: -- Following code loops through the out tables from work order API and updates the status

Line 238: fnd_file.put_line(FND_FILE.LOG,'Error Stack --' || temp_err_mesg);

234:
235: END LOOP;
236: END IF; -- end if for l_msg_count>0
237: fnd_file.put_line(FND_FILE.LOG,'Status Error for work order --' || p_wo_rec.wip_entity_id);
238: fnd_file.put_line(FND_FILE.LOG,'Error Stack --' || temp_err_mesg);
239:
240:
241: -- Following code loops through the out tables from work order API and updates the status
242: -- of corresponding import tables.It also updates the who columns

Line 437: fnd_file.put_line(FND_FILE.LOG,'-----------START OF WORK ORDER IMPORT CONCURRENT PROGRAM-----------');

433: AND erim.wip_entity_id = l_wip_entity_id;
434:
435: BEGIN
436:
437: fnd_file.put_line(FND_FILE.LOG,'-----------START OF WORK ORDER IMPORT CONCURRENT PROGRAM-----------');
438:
439: retcode:=0;
440: l_error_message :='No error message ';
441: l_group_id:= P_GROUP_ID;

Line 585: fnd_file.put_line(FND_FILE.LOG,'Status Sucess for work order --' || log_counter.wip_entity_id);

581: FOR log_counter IN ( SELECT wip_entity_id
582: FROM EAM_WORK_ORDER_IMPORT
583: WHERE group_id = l_group_id
584: AND top_wip_entity_id = l_old_top_wip_entity_id) LOOP
585: fnd_file.put_line(FND_FILE.LOG,'Status Sucess for work order --' || log_counter.wip_entity_id);
586: END LOOP;
587:
588: DELETE
589: FROM EAM_RESOURCE_INSTANCE_IMPORT

Line 1026: fnd_file.put_line(FND_FILE.LOG,'Status Sucess for work order --' || l_import_wo_record.wip_entity_id);

1022: IF (l_return_status = 'S' AND l_standalone = TRUE) THEN
1023: -- For stand alone workorders if work order API returns sucess then
1024: -- Purge all the data from import table and all associated child tables
1025:
1026: fnd_file.put_line(FND_FILE.LOG,'Status Sucess for work order --' || l_import_wo_record.wip_entity_id);
1027:
1028: DELETE
1029: FROM EAM_RESOURCE_INSTANCE_IMPORT
1030: WHERE group_id = l_group_id

Line 1066: fnd_file.put_line(FND_FILE.LOG,'Status Error.Unexpected error occured while processing work order ' || l_error_message);

1062: END IF; -- End if of error check
1063:
1064: EXCEPTION WHEN OTHERS THEN
1065: l_error_message := 'UNEXPECTED ERROR IN OUTER BLOCK: ' || SQLERRM;
1066: fnd_file.put_line(FND_FILE.LOG,'Status Error.Unexpected error occured while processing work order ' || l_error_message);
1067: END;
1068:
1069: END LOOP;
1070:

Line 1075: fnd_file.put_line(FND_FILE.LOG,'------------END OF WORK ORDER IMPORT CONCURRENT PROGRAM-----------');

1071: CLOSE l_import_wo;
1072: -- setting completion text for concurrent program
1073: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', l_error_message);
1074:
1075: fnd_file.put_line(FND_FILE.LOG,'------------END OF WORK ORDER IMPORT CONCURRENT PROGRAM-----------');
1076:
1077: END import_workorder;
1078: END EAM_WO_IMPORT_DS_PVT;