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_PICKING_PVT

Line 1: package body wip_picking_pvt as

1: package body wip_picking_pvt as
2: /* $Header: wippckvb.pls 120.18.12010000.4 2009/01/05 21:35:59 hliew ship $ */
3:
4: procedure explode(p_organization_id NUMBER,
5: p_bill_sequence_id NUMBER,

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 623: inv_wip_picking_pvt.update_mol_for_wip(p_move_order_line_id => l_lineID,

619: fetch c_repLines into l_lineID;
620: exit when c_repLines%NOTFOUND;
621: end if;
622:
623: inv_wip_picking_pvt.update_mol_for_wip(p_move_order_line_id => l_lineID,
624: p_op_seq_num => p_operation_seq_num,
625: x_msg_count => l_msgCount,
626: x_msg_data => x_msg_data,
627: x_return_status => x_return_status);

Line 894: x_MOLineErrTbl INV_WIP_Picking_Pvt.Trolin_ErrTbl_type;

890: l_dummy2 VARCHAR2(1);
891: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
892: l_opt_cnt NUMBER := 0;
893: l_include_yield NUMBER; /*Component Yield Enhancement(Bug 4369064)*/
894: x_MOLineErrTbl INV_WIP_Picking_Pvt.Trolin_ErrTbl_type;
895: l_include_comp_yield_factor NUMBER := 1 ;
896:
897:
898: CURSOR c_discJobs(v_wip_entity_id NUMBER ) IS

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 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 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 1300: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: invalid entity_type' );

1296:
1297: else -- if(p_wip_entity_type = l_disc)
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1300: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: invalid entity_type' );
1301: x_msg_data := fnd_message.get;
1302: return;
1303: end if;
1304:

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 1467: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,

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;
1467: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,
1468: p_mo_line_rec_tbl => l_linesTable,
1469: p_auto_detail_flag => nvl(p_auto_detail_flag,'T'),
1470: p_print_pick_slip => nvl(p_print_pick_slip,'F'),
1471: p_plan_tasks => nvl(p_plan_tasks,FALSE),

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 1497: WIP_PICKING_PVT.g_PickRelease_Failed := TRUE;

1493:
1494: if (nvl(fnd_global.CONC_REQUEST_ID, -1) <> -1) then
1495: if x_MOLineErrTbl.count > 0 then
1496:
1497: WIP_PICKING_PVT.g_PickRelease_Failed := TRUE;
1498: fnd_file.put_line(which => fnd_file.log, buff => 'The errored Records are as follows:');
1499:
1500: for i in x_MOLineErrTbl.FIRST..x_MOLineErrTbl.LAST
1501: loop

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 1575: -- 'N' could also result from l_lineCount = 0, and inv_wip_picking_pvt.release_pick_batch

1571: fnd_message.set_token('WIP_PICKING_MO_NUMBER', l_string1);
1572: fnd_message.set_token('WIP_PICKING_PRINT_SLIP', l_string2);
1573: x_msg_data := fnd_message.get;
1574: elsif (l_pickStatus = 'N') then
1575: -- 'N' could also result from l_lineCount = 0, and inv_wip_picking_pvt.release_pick_batch
1576: -- was never called
1577: x_return_status := 'N';
1578: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION');
1579: x_msg_data := fnd_message.get;

Line 1616: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);

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;
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);

Line 1772: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.get_HdrLinesRec: ' || SQLERRM);

1768: when others then
1769: ROLLBACK TO GET_HDR_LINES_START;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1772: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.get_HdrLinesRec: ' || SQLERRM);
1773: x_msg_data := fnd_message.get;
1774:
1775:
1776: end get_HdrLinesRec;

Line 1823: x_MOLineErrTbl INV_WIP_Picking_Pvt.Trolin_ErrTbl_type; --bugfix 4435437

1819: TYPE carton_tbl_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1820: carton_tbl carton_tbl_t;
1821: l_string1 VARCHAR2(200);
1822: l_string2 VARCHAR2(200);
1823: x_MOLineErrTbl INV_WIP_Picking_Pvt.Trolin_ErrTbl_type; --bugfix 4435437
1824: BEGIN
1825: SAVEPOINT WIP_ALLOCATE_COMP_PVT_START;
1826: x_msg_data := null;
1827:

Line 2080: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,

2076: end loop;
2077:
2078: if(l_lineCount > 0) then
2079: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;
2080: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,
2081: p_mo_line_rec_tbl => l_linesTable,
2082: p_auto_detail_flag => nvl(p_auto_detail_flag,'T'),
2083: p_print_pick_slip => nvl(p_print_pick_slip,'F'),
2084: p_plan_tasks => nvl(p_plan_tasks,FALSE),

Line 2116: -- 'N' could also result from l_lineCount = 0, and inv_wip_picking_pvt.release_pick_batch

2112: fnd_message.set_token('WIP_PICKING_MO_NUMBER', l_string1);
2113: fnd_message.set_token('WIP_PICKING_PRINT_SLIP', l_string2);
2114: x_msg_data := fnd_message.get;
2115: elsif (l_pickStatus = 'N') then
2116: -- 'N' could also result from l_lineCount = 0, and inv_wip_picking_pvt.release_pick_batch
2117: -- was never called
2118: x_return_status := 'N';
2119: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION');
2120: x_msg_data := fnd_message.get;

Line 2144: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);

2140: when others then
2141: ROLLBACK TO WIP_ALLOCATE_COMP_PVT_START;
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2143: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2144: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
2145: x_msg_data := fnd_message.get;
2146: end allocate_comp;
2147:
2148: --this version is used in the concurrent request

Line 2497: if (WIP_PICKING_PVT.g_PickRelease_Failed = TRUE) then

2493: || ';l_print_pickslips=' || l_print_pickslips );
2494: end if;
2495: end if;
2496: /*bugfix 4435437: set the process to warning if failed */
2497: if (WIP_PICKING_PVT.g_PickRelease_Failed = TRUE) then
2498: retcode := 1 ;
2499: end if;
2500: commit;
2501: exception

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 2763: end wip_picking_pvt;

2759: end if;
2760: End Post_Explosion_CleanUp;
2761:
2762:
2763: end wip_picking_pvt;