[Home] [Help]
1188: --from the interface table.
1189:
1190: /* bugfix 4289455 : Remove the records from WIE since we are deleting WJSI record
1191: with process phase and process status COMPLETE else these may remain orphan */
1192: DELETE FROM WIP_INTERFACE_ERRORS
1193: WHERE INTERFACE_ID IN (
1194: SELECT INTERFACE_ID
1195: FROM WIP_JOB_SCHEDULE_INTERFACE
1196: WHERE GROUP_ID = wei_group_id
1208:
1209: /* bugfix 4289455 : Remove the record from WJSI if process phase and
1210: process status is COMPLETE. If left as it is, we may encounter bug 2433627.
1211: AND 0 = (SELECT COUNT(*)
1212: FROM WIP_INTERFACE_ERRORS E
1213: WHERE E.INTERFACE_ID = I.INTERFACE_ID) ;
1214: */
1215:
1216: else
1216: else
1217: --Bugfix 10636184: If MRP: Debug is ON, do not remove any records from the interface table.
1218: fnd_file.put_line(which => fnd_file.log, buff => 'MRP debug is ON. Not deleting anything.');
1219: /*
1220: DELETE FROM WIP_INTERFACE_ERRORS
1221: WHERE INTERFACE_ID IN
1222: (SELECT INTERFACE_ID
1223: FROM WIP_JOB_SCHEDULE_INTERFACE
1224: WHERE GROUP_ID = wei_group_id);
1239:
1240: if(n_undeleted_records <> 0) THEN
1241: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1242: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1243: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1244: wip_logger.log('Dbg:for details.', l_returnStatus);
1245: END IF;
1246:
1247: wip_logger.log(