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.

[Home] [Help]

APPS.WIP_ATO_JOBS_PRIV dependencies on WIP_INTERFACE_ERRORS

Line 1037: DELETE FROM WIP_INTERFACE_ERRORS

1033: if (l_logLevel <= wip_constants.full_logging) then
1034:
1035: /* bugfix 4289455 : Remove the records from WIE since we are deleting WJSI record
1036: with process phase and process status COMPLETE else these may remain orphan */
1037: DELETE FROM WIP_INTERFACE_ERRORS
1038: WHERE INTERFACE_ID IN (
1039: SELECT INTERFACE_ID
1040: FROM WIP_JOB_SCHEDULE_INTERFACE
1041: WHERE GROUP_ID = wei_group_id

Line 1053: FROM WIP_INTERFACE_ERRORS E

1049:
1050: /* bugfix 4289455 : Remove the record from WJSI if process phase and
1051: process status is COMPLETE. If left as it is, we may encounter bug 2433627.
1052: AND 0 = (SELECT COUNT(*)
1053: FROM WIP_INTERFACE_ERRORS E
1054: WHERE E.INTERFACE_ID = I.INTERFACE_ID) ;
1055: */
1056:
1057: else

Line 1059: DELETE FROM WIP_INTERFACE_ERRORS

1055: */
1056:
1057: else
1058:
1059: DELETE FROM WIP_INTERFACE_ERRORS
1060: WHERE INTERFACE_ID IN
1061: (SELECT INTERFACE_ID
1062: FROM WIP_JOB_SCHEDULE_INTERFACE
1063: WHERE GROUP_ID = wei_group_id);

Line 1080: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);

1076:
1077: if(n_undeleted_records <> 0) THEN
1078: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1079: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1080: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1081: wip_logger.log('Dbg:for details.', l_returnStatus);
1082: END IF;
1083:
1084: wip_logger.log(