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.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_LOGGER

Line 1157: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_po_qty_delivered: '||l_total_po_qty_delivered,l_returnStatus);

1153: END IF;
1154: /*Changes done SQL for performance bug 9888616. */
1155:
1156: IF (l_logLevel <= wip_constants.full_logging) THEN
1157: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_po_qty_delivered: '||l_total_po_qty_delivered,l_returnStatus);
1158: END IF ;
1159:
1160: begin
1161: SELECT wor.usage_rate_or_amount

Line 1255: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_pri_qty_delivered: '||l_total_pri_qty_delivered,l_returnStatus);

1251: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from MSI');
1252: end;
1253:
1254: IF (l_logLevel <= wip_constants.full_logging) THEN
1255: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_pri_qty_delivered: '||l_total_pri_qty_delivered,l_returnStatus);
1256: END IF;
1257:
1258: begin
1259:

Line 1306: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);

1302:
1303: l_total_qty := l_quantity_in_queue + l_quantity_running + l_quantity_completed ;
1304:
1305: IF (l_logLevel <= wip_constants.full_logging) THEN
1306: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1307: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1308: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1309: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);
1310: END IF;

Line 1307: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);

1303: l_total_qty := l_quantity_in_queue + l_quantity_running + l_quantity_completed ;
1304:
1305: IF (l_logLevel <= wip_constants.full_logging) THEN
1306: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1307: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1308: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1309: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);
1310: END IF;
1311:

Line 1308: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);

1304:
1305: IF (l_logLevel <= wip_constants.full_logging) THEN
1306: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1307: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1308: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1309: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);
1310: END IF;
1311:
1312: --Bug 16099295 (FP 13526041): Noticed that if there are consecutive OSP operations and they are

Line 1309: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);

1305: IF (l_logLevel <= wip_constants.full_logging) THEN
1306: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1307: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1308: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1309: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);
1310: END IF;
1311:
1312: --Bug 16099295 (FP 13526041): Noticed that if there are consecutive OSP operations and they are
1313: --received at the same time, then total_qty for the second one will be 0, and hence it will show

Line 1319: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty 2: '||l_total_qty,l_returnStatus);

1315: --avoid that.
1316: if (l_total_qty = 0) then
1317: l_total_qty := l_scheduled_quantity;
1318: IF (l_logLevel <= wip_constants.full_logging) THEN
1319: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty 2: '||l_total_qty,l_returnStatus);
1320: END IF;
1321: end if;
1322:
1323: exception

Line 1333: wip_logger.log('Get_Overcpl_Primary_Qty: l_curr_qty_delivered: '||l_curr_qty_delivered,l_returnStatus);

1329: l_curr_qty_delivered := nvl(g_ShopFloorMove_rec.primary_quantity,0);
1330: l_total_prev_qty_delivered := l_total_pri_qty_delivered - l_curr_qty_delivered;
1331:
1332: IF (l_logLevel <= wip_constants.full_logging) THEN
1333: wip_logger.log('Get_Overcpl_Primary_Qty: l_curr_qty_delivered: '||l_curr_qty_delivered,l_returnStatus);
1334: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_prev_qty_delivered: '||l_total_prev_qty_delivered,l_returnStatus);
1335: END IF;
1336:
1337: /* Fix for Bug#5020591. OverCompletion quantity should be completed only when Current delivered Qty

Line 1334: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_prev_qty_delivered: '||l_total_prev_qty_delivered,l_returnStatus);

1330: l_total_prev_qty_delivered := l_total_pri_qty_delivered - l_curr_qty_delivered;
1331:
1332: IF (l_logLevel <= wip_constants.full_logging) THEN
1333: wip_logger.log('Get_Overcpl_Primary_Qty: l_curr_qty_delivered: '||l_curr_qty_delivered,l_returnStatus);
1334: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_prev_qty_delivered: '||l_total_prev_qty_delivered,l_returnStatus);
1335: END IF;
1336:
1337: /* Fix for Bug#5020591. OverCompletion quantity should be completed only when Current delivered Qty
1338: is more than remaining quantity to be completed on Operation. Greatest condition is added

Line 1351: wip_logger.log('Get_Overcpl_Primary_Qty: l_remaining_qty: '||l_remaining_qty,l_returnStatus);

1347: --l_remaining_qty := greatest(l_scheduled_quantity, l_quantity_in_queue) - l_total_prev_qty_delivered ; -- Open Qty
1348: l_remaining_qty := l_total_qty - l_total_prev_qty_delivered ; -- Open Qty
1349:
1350: IF (l_logLevel <= wip_constants.full_logging) THEN
1351: wip_logger.log('Get_Overcpl_Primary_Qty: l_remaining_qty: '||l_remaining_qty,l_returnStatus);
1352: END IF;
1353:
1354: /* Modified calculation logic for bug 6649174 */
1355: if l_curr_qty_delivered > l_remaining_qty then -- Current Qty is going to overcomplete an Op.

Line 1360: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty1: '||l_overcpl_primary_qty,l_returnStatus);

1356:
1357: If ( l_total_prev_qty_delivered >= l_total_qty ) then -- You delivered more quantity last time
1358: l_overcpl_primary_qty := l_curr_qty_delivered;
1359: IF (l_logLevel <= wip_constants.full_logging) THEN
1360: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty1: '||l_overcpl_primary_qty,l_returnStatus);
1361: END IF;
1362: elsif (l_total_pri_qty_delivered > l_total_qty) then -- You are over receiving this time
1363: l_overcpl_primary_qty := l_total_pri_qty_delivered - l_total_qty;
1364: IF (l_logLevel <= wip_constants.full_logging) THEN

Line 1365: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty2: '||l_overcpl_primary_qty,l_returnStatus);

1361: END IF;
1362: elsif (l_total_pri_qty_delivered > l_total_qty) then -- You are over receiving this time
1363: l_overcpl_primary_qty := l_total_pri_qty_delivered - l_total_qty;
1364: IF (l_logLevel <= wip_constants.full_logging) THEN
1365: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty2: '||l_overcpl_primary_qty,l_returnStatus);
1366: END IF;
1367: end if;
1368:
1369: end if ;

Line 1376: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty3: '||l_overcpl_primary_qty,l_returnStatus);

1372: END IF;
1373: END IF;
1374:
1375: IF (l_logLevel <= wip_constants.full_logging) THEN
1376: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty3: '||l_overcpl_primary_qty,l_returnStatus);
1377: END IF;
1378:
1379: RETURN l_overcpl_primary_qty;
1380: