DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_LOGGER

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

1109: and rt.wip_resource_seq_num = g_OSP_rec.resource_seq_num
1110: and rt.transaction_type = 'DELIVER'
1111: and rt.po_distribution_id is not null) ;
1112: IF (l_logLevel <= wip_constants.full_logging) THEN
1113: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_po_qty_delivered: '||l_total_po_qty_delivered,l_returnStatus);
1114: END IF ;
1115:
1116: begin
1117: SELECT wor.usage_rate_or_amount

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

1205: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from MSI');
1206: end;
1207:
1208: IF (l_logLevel <= wip_constants.full_logging) THEN
1209: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_pri_qty_delivered: '||l_total_pri_qty_delivered,l_returnStatus);
1210: END IF;
1211:
1212: begin
1213:

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

1254:
1255: l_total_qty := l_quantity_in_queue + l_quantity_running + l_quantity_completed ;
1256:
1257: IF (l_logLevel <= wip_constants.full_logging) THEN
1258: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1259: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1260: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1261: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);
1262: END IF;

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

1255: l_total_qty := l_quantity_in_queue + l_quantity_running + l_quantity_completed ;
1256:
1257: IF (l_logLevel <= wip_constants.full_logging) THEN
1258: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1259: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1260: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1261: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);
1262: END IF;
1263:

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

1256:
1257: IF (l_logLevel <= wip_constants.full_logging) THEN
1258: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1259: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1260: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1261: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);
1262: END IF;
1263:
1264: exception

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

1257: IF (l_logLevel <= wip_constants.full_logging) THEN
1258: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1259: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1260: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1261: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);
1262: END IF;
1263:
1264: exception
1265: when others then

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

1270: l_curr_qty_delivered := nvl(g_ShopFloorMove_rec.primary_quantity,0);
1271: l_total_prev_qty_delivered := l_total_pri_qty_delivered - l_curr_qty_delivered;
1272:
1273: IF (l_logLevel <= wip_constants.full_logging) THEN
1274: wip_logger.log('Get_Overcpl_Primary_Qty: l_curr_qty_delivered: '||l_curr_qty_delivered,l_returnStatus);
1275: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_prev_qty_delivered: '||l_total_prev_qty_delivered,l_returnStatus);
1276: END IF;
1277:
1278: /* Fix for Bug#5020591. OverCompletion quantity should be completed only when Current delivered Qty

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

1271: l_total_prev_qty_delivered := l_total_pri_qty_delivered - l_curr_qty_delivered;
1272:
1273: IF (l_logLevel <= wip_constants.full_logging) THEN
1274: wip_logger.log('Get_Overcpl_Primary_Qty: l_curr_qty_delivered: '||l_curr_qty_delivered,l_returnStatus);
1275: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_prev_qty_delivered: '||l_total_prev_qty_delivered,l_returnStatus);
1276: END IF;
1277:
1278: /* Fix for Bug#5020591. OverCompletion quantity should be completed only when Current delivered Qty
1279: is more than remaining quantity to be completed on Operation. Greatest condition is added

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

1288: --l_remaining_qty := greatest(l_scheduled_quantity, l_quantity_in_queue) - l_total_prev_qty_delivered ; -- Open Qty
1289: l_remaining_qty := l_total_qty - l_total_prev_qty_delivered ; -- Open Qty
1290:
1291: IF (l_logLevel <= wip_constants.full_logging) THEN
1292: wip_logger.log('Get_Overcpl_Primary_Qty: l_remaining_qty: '||l_remaining_qty,l_returnStatus);
1293: END IF;
1294:
1295: /* Modified calculation logic for bug 6649174 */
1296: if l_curr_qty_delivered > l_remaining_qty then -- Current Qty is going to overcomplete an Op.

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

1297:
1298: If ( l_total_prev_qty_delivered >= l_total_qty ) then -- You delivered more quantity last time
1299: l_overcpl_primary_qty := l_curr_qty_delivered;
1300: IF (l_logLevel <= wip_constants.full_logging) THEN
1301: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty1: '||l_overcpl_primary_qty,l_returnStatus);
1302: END IF;
1303: elsif (l_total_pri_qty_delivered > l_total_qty) then -- You are over receiving this time
1304: l_overcpl_primary_qty := l_total_pri_qty_delivered - l_total_qty;
1305: IF (l_logLevel <= wip_constants.full_logging) THEN

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

1302: END IF;
1303: elsif (l_total_pri_qty_delivered > l_total_qty) then -- You are over receiving this time
1304: l_overcpl_primary_qty := l_total_pri_qty_delivered - l_total_qty;
1305: IF (l_logLevel <= wip_constants.full_logging) THEN
1306: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty2: '||l_overcpl_primary_qty,l_returnStatus);
1307: END IF;
1308: end if;
1309:
1310: end if ;

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

1313: END IF;
1314: END IF;
1315:
1316: IF (l_logLevel <= wip_constants.full_logging) THEN
1317: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty3: '||l_overcpl_primary_qty,l_returnStatus);
1318: END IF;
1319:
1320: RETURN l_overcpl_primary_qty;
1321: