[Home] [Help]
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 ,
92: group_id ,
93: row_id ,
94: error_message ,
142:
143: -- Start of comments
144: -- API name : log_error_messages
145: -- Type : Private.
146: -- Function : In EAM_WORK_ORDER_IMPORT_ERRORS, inserts a row for each error message retrieved from work order API
147: -- message stack. Update the column RETURN_STATUS of the import with the API return_status,
148: -- also update RETURN_STATUS in all child tables with the return status got from the output child
149: -- records such as the ones for operations, resources etc. Update the WHO columns like LAST_UPDATE_DATE,
150: -- LAST_UPDATED_BY, LAST_UPDATE_LOGIN whenever any update is done to any import table record
197: WHERE group_id = p_group_id
198: AND wip_entity_id = p_wo_rec.wip_entity_id;
199:
200: -- get the error messages from the work order api exception stack and insert
201: -- into EAM_WORK_ORDER_IMPORT_ERRORS
202:
203: l_msg_count := fnd_msg_pub.count_msg;
204: IF(l_msg_count>0) THEN
205: msg_index := l_msg_count;
208: p_encoded => 'F',
209: p_data => temp_err_mesg,
210: p_msg_index_out => msg_index);
211:
212: INSERT INTO EAM_WORK_ORDER_IMPORT_ERRORS(
213: header_id ,
214: group_id ,
215: row_id ,
216: error_message ,
446: WHERE group_id = l_group_id
447: AND process_status = 1 ;
448:
449: -- Clear out any previously errored rows which are resubmitted
450: DELETE EAM_WORK_ORDER_IMPORT_ERRORS
451: WHERE header_id IN (
452: SELECT wip_entity_id
453: FROM EAM_WORK_ORDER_IMPORT
454: WHERE group_id = l_group_id