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_PICKING_PVT dependencies on WIP_LOGGER

Line 302: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);

298: SAVEPOINT WIP_CANCEL_COMP_ALLOCS_START;
299: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
300:
301: if (l_logLevel <= wip_constants.trace_logging) then
302: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
303: end if;
304: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
305: open c_discLines;
306: elsif(p_wip_entity_type = wip_constants.repetitive) then

Line 310: wip_logger.log('Invalid entity type passed to wip_picking_pvt.cancel_comp_allocations:'

306: elsif(p_wip_entity_type = wip_constants.repetitive) then
307: open c_repLines;
308: else
309: if (l_logLevel <= wip_constants.trace_logging) then
310: wip_logger.log('Invalid entity type passed to wip_picking_pvt.cancel_comp_allocations:'
311: || p_wip_entity_type, l_dummy);
312: end if;
313: end if;
314:

Line 325: wip_logger.log('line ID:' || l_lineID || ',Open Qty:' || l_openQty || ',WRO RowID:'

321: exit when c_repLines%NOTFOUND;
322: end if;
323:
324: if (l_logLevel <= wip_constants.trace_logging) then
325: wip_logger.log('line ID:' || l_lineID || ',Open Qty:' || l_openQty || ',WRO RowID:'
326: || l_wroRowID || ',p_wip_entity_type:' || p_wip_entity_type, l_dummy);
327: end if;
328:
329: cancel_MO_line(p_lineId =>l_lineID ,

Line 1103: wip_logger.log('wip_picking_pvt.allocate => job count in table passed into allocate(): '

1099: into l_include_yield
1100: from wip_parameters
1101: where organization_id = p_organization_id;
1102: if (l_logLevel <= wip_constants.trace_logging) then
1103: wip_logger.log('wip_picking_pvt.allocate => job count in table passed into allocate(): '
1104: || p_alloc_tbl.COUNT, l_dummy2);
1105: wip_logger.log('p_days_to_alloc=' || p_days_to_alloc || ',p_auto_detail_flag=' || p_auto_detail_flag ||
1106: ',p_start_date=' || p_start_date || ',p_cutoff_date=' || p_cutoff_date ||
1107: ',p_wip_entity_type=' || p_wip_entity_type || ',p_organization_id=' || p_organization_id ||

Line 1105: wip_logger.log('p_days_to_alloc=' || p_days_to_alloc || ',p_auto_detail_flag=' || p_auto_detail_flag ||

1101: where organization_id = p_organization_id;
1102: if (l_logLevel <= wip_constants.trace_logging) then
1103: wip_logger.log('wip_picking_pvt.allocate => job count in table passed into allocate(): '
1104: || p_alloc_tbl.COUNT, l_dummy2);
1105: wip_logger.log('p_days_to_alloc=' || p_days_to_alloc || ',p_auto_detail_flag=' || p_auto_detail_flag ||
1106: ',p_start_date=' || p_start_date || ',p_cutoff_date=' || p_cutoff_date ||
1107: ',p_wip_entity_type=' || p_wip_entity_type || ',p_organization_id=' || p_organization_id ||
1108: ',p_operation_seq_num_low=' || p_operation_seq_num_low ||
1109: ',p_operation_seq_num_high=' || p_operation_seq_num_high ||

Line 1112: wip_logger.log('wip_picking_pvt.allocate => add comp:', l_dummy2);

1108: ',p_operation_seq_num_low=' || p_operation_seq_num_low ||
1109: ',p_operation_seq_num_high=' || p_operation_seq_num_high ||
1110: ',p_pick_grouping_rule_id=' || p_pick_grouping_rule_id || ',p_print_pick_slip=' ||
1111: p_print_pick_slip, l_dummy2);
1112: wip_logger.log('wip_picking_pvt.allocate => add comp:', l_dummy2);
1113: end if;
1114:
1115: for i in 1..p_alloc_tbl.COUNT LOOP
1116:

Line 1128: wip_logger.log('wip_picking_pvt.allocate => processing job: (wei)'

1124: open c_rep(p_alloc_tbl(i).repetitive_schedule_id);
1125: elsif(p_wip_entity_type = wip_constants.flow) then --flow
1126:
1127: if (l_logLevel <= wip_constants.trace_logging) then
1128: wip_logger.log('wip_picking_pvt.allocate => processing job: (wei)'
1129: || p_alloc_tbl(i).wip_entity_id
1130: || ';job counter=' || i || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1131: end if;
1132:

Line 1165: wip_logger.log('wip_picking_pvt.allocate => ' ||

1161: )
1162: for update of wfs.allocated_flag nowait;
1163: exception
1164: when NO_DATA_FOUND then
1165: wip_logger.log('wip_picking_pvt.allocate => ' ||
1166: 'no BOM found for wip_entity_id:' ||
1167: p_alloc_tbl(i).wip_entity_id, l_dummy2 );
1168: GOTO END_OF_FOR_LOOP;
1169: end;

Line 1192: /* BugFix 6964780: Corrected the wip_logger.log API call */

1188: );
1189:
1190: exception
1191: when NO_DATA_FOUND then
1192: /* BugFix 6964780: Corrected the wip_logger.log API call */
1193: wip_logger.log('wip_picking_pvt.allocate => no routing found for wip_entity_id:'|| p_alloc_tbl(i).wip_entity_id, l_dummy2 );
1194: end;
1195:
1196: -- bug#3409239 Begin: Improve Flow picking performance by grouping

Line 1193: wip_logger.log('wip_picking_pvt.allocate => no routing found for wip_entity_id:'|| p_alloc_tbl(i).wip_entity_id, l_dummy2 );

1189:
1190: exception
1191: when NO_DATA_FOUND then
1192: /* BugFix 6964780: Corrected the wip_logger.log API call */
1193: wip_logger.log('wip_picking_pvt.allocate => no routing found for wip_entity_id:'|| p_alloc_tbl(i).wip_entity_id, l_dummy2 );
1194: end;
1195:
1196: -- bug#3409239 Begin: Improve Flow picking performance by grouping
1197: -- if 0, then this schedule is not grouped with the schedule

Line 1209: wip_logger.log('wip_picking_pvt.allocate => ' ||

1205: p_req_date => p_alloc_tbl(i).required_date,
1206: x_opt_total => l_opt_cnt);
1207:
1208: if (l_logLevel <= wip_constants.trace_logging) then
1209: wip_logger.log('wip_picking_pvt.allocate => ' ||
1210: 'flow optimal group total: ' || l_opt_cnt, l_dummy2);
1211: end if;
1212: -- no flow sched can be grouped together
1213: if (l_opt_cnt < 3) then

Line 1261: wip_logger.log('wip_picking_pvt.allocate => ' ||

1257: -- reset counter, and proceed as normal(one record at a time)
1258: l_opt_cnt := 0;
1259:
1260: if (l_logLevel <= wip_constants.trace_logging) then
1261: wip_logger.log('wip_picking_pvt.allocate => ' ||
1262: 'flow optimal group NOT optimzable', l_dummy2);
1263: end if;
1264: else
1265: -- can be optimized, do nothing here, it will be processed

Line 1268: wip_logger.log('wip_picking_pvt.allocate => ' ||

1264: else
1265: -- can be optimized, do nothing here, it will be processed
1266: -- as a whole right before passing to INV
1267: if (l_logLevel <= wip_constants.trace_logging) then
1268: wip_logger.log('wip_picking_pvt.allocate => ' ||
1269: 'flow optimal group IS optimzable', l_dummy2);
1270: end if;
1271: end if;
1272: end if;

Line 1278: wip_logger.log('wip_picking_pvt.allocate => ' ||

1274: -- in the middle of an optimized flow sched group, jump to the end
1275: -- of the jobs loop, since this whole group has been added to
1276: -- l_linesTable to pass to INV
1277: if (l_logLevel <= wip_constants.trace_logging) then
1278: wip_logger.log('wip_picking_pvt.allocate => ' ||
1279: 'processing flow optimal group..', l_dummy2);
1280: end if;
1281: l_opt_cnt := l_opt_cnt-1;
1282: GOTO END_OF_FOR_LOOP;

Line 1361: wip_logger.log(' op_seq_num=' || l_operationSeqNum || ',item_id=' || l_itemID || ',open qty=' || l_openQty

1357: l_supplyType := wip_constants.ASSY_PULL; --although defined as push, flow allocations always behave as pull components
1358: end if;
1359:
1360: if (l_logLevel <= wip_constants.trace_logging) then
1361: wip_logger.log(' op_seq_num=' || l_operationSeqNum || ',item_id=' || l_itemID || ',open qty=' || l_openQty
1362: || ',subinv=' || l_subinv || ',loc=' || l_locator || ',supplyType=' || l_supplyType
1363: || ',reqDate=' || l_reqDate, l_dummy2);
1364: end if;
1365:

Line 1462: wip_logger.log('wip_picking_pvt.allocate => line count passed to inv_wip_picking_pvt.release_pick_batch: '

1458: null;
1459: end loop; --end per entity loop
1460:
1461: if (l_logLevel <= wip_constants.trace_logging) then
1462: wip_logger.log('wip_picking_pvt.allocate => line count passed to inv_wip_picking_pvt.release_pick_batch: '
1463: || l_lineCount || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1464: end if;
1465: if(l_lineCount > 0) then
1466: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;

Line 1481: wip_logger.log('returned status from call to inv_wip_picking_pvt.release_pick_batch() = ' || l_pickStatus || ';total=' || p_alloc_tbl.COUNT, l_dummy2);

1477: x_mo_line_errrec_tbl => x_MOLineErrTbl);
1478: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);
1479:
1480: if (l_logLevel <= wip_constants.trace_logging) then
1481: wip_logger.log('returned status from call to inv_wip_picking_pvt.release_pick_batch() = ' || l_pickStatus || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1482: end if;
1483:
1484: if(l_pickStatus not in ('P','N', FND_API.G_RET_STS_SUCCESS)) then
1485: x_return_status := l_pickStatus;

Line 1552: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_status='

1548: end if; /* end of conc_req_id <> -1 condition */
1549: end if; /* end of l_lineCount > 0 */
1550:
1551: if (l_logLevel <= wip_constants.trace_logging) then
1552: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_status='
1553: || l_pickStatus, l_dummy2);
1554: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_msg='
1555: || x_msg_data, l_dummy2);
1556: end if;

Line 1554: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_msg='

1550:
1551: if (l_logLevel <= wip_constants.trace_logging) then
1552: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_status='
1553: || l_pickStatus, l_dummy2);
1554: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_msg='
1555: || x_msg_data, l_dummy2);
1556: end if;
1557:
1558: if(nvl(p_print_pick_slip,'T') = 'T') then

Line 1593: wip_logger.cleanup(l_dummy2);

1589: end if;
1590: x_mo_req_number := l_hdrRec.request_number; /* Added as part of enhancement 2478446 */
1591:
1592: if (l_logLevel <= wip_constants.trace_logging) then
1593: wip_logger.cleanup(l_dummy2);
1594: end if;
1595:
1596: exception
1597: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls

Line 1600: wip_logger.log(x_msg_data, l_dummy2);

1596: exception
1597: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls
1598: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1599: if (l_logLevel <= wip_constants.trace_logging) then
1600: wip_logger.log(x_msg_data, l_dummy2);
1601: wip_logger.cleanup(l_dummy2);
1602: end if;
1603: when RECORDS_LOCKED then
1604: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138

Line 1601: wip_logger.cleanup(l_dummy2);

1597: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls
1598: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1599: if (l_logLevel <= wip_constants.trace_logging) then
1600: wip_logger.log(x_msg_data, l_dummy2);
1601: wip_logger.cleanup(l_dummy2);
1602: end if;
1603: when RECORDS_LOCKED then
1604: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1605: x_return_status := 'L';

Line 1609: wip_logger.log(x_msg_data, l_dummy2);

1605: x_return_status := 'L';
1606: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
1607: x_msg_data := fnd_message.get;
1608: if (l_logLevel <= wip_constants.trace_logging) then
1609: wip_logger.log(x_msg_data, l_dummy2);
1610: wip_logger.cleanup(l_dummy2);
1611: end if;
1612: when others then
1613: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138

Line 1610: wip_logger.cleanup(l_dummy2);

1606: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
1607: x_msg_data := fnd_message.get;
1608: if (l_logLevel <= wip_constants.trace_logging) then
1609: wip_logger.log(x_msg_data, l_dummy2);
1610: wip_logger.cleanup(l_dummy2);
1611: end if;
1612: when others then
1613: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1619: wip_logger.log(x_msg_data, l_dummy2);

1615: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1616: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
1617: x_msg_data := fnd_message.get;
1618: if (l_logLevel <= wip_constants.trace_logging) then
1619: wip_logger.log(x_msg_data, l_dummy2);
1620: wip_logger.cleanup(l_dummy2);
1621: end if;
1622: end allocate;
1623:

Line 1620: wip_logger.cleanup(l_dummy2);

1616: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
1617: x_msg_data := fnd_message.get;
1618: if (l_logLevel <= wip_constants.trace_logging) then
1619: wip_logger.log(x_msg_data, l_dummy2);
1620: wip_logger.cleanup(l_dummy2);
1621: end if;
1622: end allocate;
1623:
1624:

Line 2624: wip_logger.log('In wip_picking_pvt.Post_Explosion_CleanUp():'

2620: x_return_status := FND_API.G_RET_STS_SUCCESS;
2621:
2622: l_logLevel := fnd_log.g_current_runtime_level;
2623: if (l_logLevel <= wip_constants.trace_logging) then
2624: wip_logger.log('In wip_picking_pvt.Post_Explosion_CleanUp():'
2625: || p_wip_entity_id || ':' || p_org_id
2626: || ':' || p_repetitive_schedule_id, l_dummy2);
2627: end if;
2628:

Line 2678: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||

2674: x_msg_data => x_msg_data);
2675:
2676: if (x_return_status <> fnd_api.g_ret_sts_success) then
2677: if (l_logLevel <= wip_constants.trace_logging) then
2678: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2679: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2680: end if;
2681: Return;
2682: End if;

Line 2725: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||

2721: x_msg_data => x_msg_data);
2722:
2723: if (x_return_status <> fnd_api.g_ret_sts_success) then
2724: if (l_logLevel <= wip_constants.trace_logging) then
2725: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2726: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2727: end if;
2728: Return;
2729: End if;

Line 2747: wip_logger.log( x_msg_data, l_dummy2);

2743: x_return_status := 'L';
2744: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
2745: x_msg_data := fnd_message.get;
2746: if (l_logLevel <= wip_constants.trace_logging) then
2747: wip_logger.log( x_msg_data, l_dummy2);
2748: wip_logger.cleanup(l_dummy2);
2749: end if;
2750: when others then
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2748: wip_logger.cleanup(l_dummy2);

2744: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
2745: x_msg_data := fnd_message.get;
2746: if (l_logLevel <= wip_constants.trace_logging) then
2747: wip_logger.log( x_msg_data, l_dummy2);
2748: wip_logger.cleanup(l_dummy2);
2749: end if;
2750: when others then
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2752: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');

Line 2757: wip_logger.log( x_msg_data, l_dummy2);

2753: fnd_message.set_token('ERROR_TEXT', 'WIP_EXPLODER_UTITLITIES.Post_Explosion_CleanUp:'
2754: || SQLERRM);
2755: x_msg_data := fnd_message.get;
2756: if (l_logLevel <= wip_constants.trace_logging) then
2757: wip_logger.log( x_msg_data, l_dummy2);
2758: wip_logger.cleanup(l_dummy2);
2759: end if;
2760: End Post_Explosion_CleanUp;
2761:

Line 2758: wip_logger.cleanup(l_dummy2);

2754: || SQLERRM);
2755: x_msg_data := fnd_message.get;
2756: if (l_logLevel <= wip_constants.trace_logging) then
2757: wip_logger.log( x_msg_data, l_dummy2);
2758: wip_logger.cleanup(l_dummy2);
2759: end if;
2760: End Post_Explosion_CleanUp;
2761:
2762: