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.25.12020000.6 2013/03/01 07:33:28 akuppa ship $ */
3:
4: procedure explode(p_organization_id NUMBER,
5: p_bill_sequence_id NUMBER,

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

312: SAVEPOINT WIP_CANCEL_COMP_ALLOCS_START;
313: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
314:
315: if (l_logLevel <= wip_constants.trace_logging) then
316: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
317: end if;
318: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
319: open c_discLines;
320: elsif(p_wip_entity_type = wip_constants.repetitive) then

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

320: elsif(p_wip_entity_type = wip_constants.repetitive) then
321: open c_repLines;
322: else
323: if (l_logLevel <= wip_constants.trace_logging) then
324: wip_logger.log('Invalid entity type passed to wip_picking_pvt.cancel_comp_allocations:'
325: || p_wip_entity_type, l_dummy);
326: end if;
327: end if;
328:

Line 645: inv_wip_picking_pvt.update_mol_for_wip(p_move_order_line_id => l_lineID,

641: fetch c_repLines into l_lineID;
642: exit when c_repLines%NOTFOUND;
643: end if;
644:
645: inv_wip_picking_pvt.update_mol_for_wip(p_move_order_line_id => l_lineID,
646: p_op_seq_num => p_operation_seq_num,
647: x_msg_count => l_msgCount,
648: x_msg_data => x_msg_data,
649: x_return_status => x_return_status);

Line 916: x_MOLineErrTbl INV_WIP_Picking_Pvt.Trolin_ErrTbl_type;

912: l_dummy2 VARCHAR2(1);
913: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
914: l_opt_cnt NUMBER := 0;
915: l_include_yield NUMBER; /*Component Yield Enhancement(Bug 4369064)*/
916: x_MOLineErrTbl INV_WIP_Picking_Pvt.Trolin_ErrTbl_type;
917: l_include_comp_yield_factor NUMBER := 1 ;
918:
919:
920: CURSOR c_discJobs(v_wip_entity_id NUMBER ) IS

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

1124: into l_include_yield
1125: from wip_parameters
1126: where organization_id = p_organization_id;
1127: if (l_logLevel <= wip_constants.trace_logging) then
1128: wip_logger.log('wip_picking_pvt.allocate => job count in table passed into allocate(): '
1129: || p_alloc_tbl.COUNT, l_dummy2);
1130: wip_logger.log('p_days_to_alloc=' || p_days_to_alloc || ',p_auto_detail_flag=' || p_auto_detail_flag ||
1131: ',p_start_date=' || p_start_date || ',p_cutoff_date=' || p_cutoff_date ||
1132: ',p_wip_entity_type=' || p_wip_entity_type || ',p_organization_id=' || p_organization_id ||

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

1133: ',p_operation_seq_num_low=' || p_operation_seq_num_low ||
1134: ',p_operation_seq_num_high=' || p_operation_seq_num_high ||
1135: ',p_pick_grouping_rule_id=' || p_pick_grouping_rule_id || ',p_print_pick_slip=' ||
1136: p_print_pick_slip, l_dummy2);
1137: wip_logger.log('wip_picking_pvt.allocate => add comp:', l_dummy2);
1138: end if;
1139:
1140: for i in 1..p_alloc_tbl.COUNT LOOP
1141:

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

1149: open c_rep(p_alloc_tbl(i).repetitive_schedule_id);
1150: elsif(p_wip_entity_type = wip_constants.flow) then --flow
1151:
1152: if (l_logLevel <= wip_constants.trace_logging) then
1153: wip_logger.log('wip_picking_pvt.allocate => processing job: (wei)'
1154: || p_alloc_tbl(i).wip_entity_id
1155: || ';job counter=' || i || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1156: end if;
1157:

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

1186: )
1187: for update of wfs.allocated_flag nowait;
1188: exception
1189: when NO_DATA_FOUND then
1190: wip_logger.log('wip_picking_pvt.allocate => ' ||
1191: 'no BOM found for wip_entity_id:' ||
1192: p_alloc_tbl(i).wip_entity_id, l_dummy2 );
1193: GOTO END_OF_FOR_LOOP;
1194: end;

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

1214:
1215: exception
1216: when NO_DATA_FOUND then
1217: /* BugFix 6964780: Corrected the wip_logger.log API call */
1218: wip_logger.log('wip_picking_pvt.allocate => no routing found for wip_entity_id:'|| p_alloc_tbl(i).wip_entity_id, l_dummy2 );
1219: end;
1220:
1221: -- bug#3409239 Begin: Improve Flow picking performance by grouping
1222: -- if 0, then this schedule is not grouped with the schedule

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

1230: p_req_date => p_alloc_tbl(i).required_date,
1231: x_opt_total => l_opt_cnt);
1232:
1233: if (l_logLevel <= wip_constants.trace_logging) then
1234: wip_logger.log('wip_picking_pvt.allocate => ' ||
1235: 'flow optimal group total: ' || l_opt_cnt, l_dummy2);
1236: end if;
1237: -- no flow sched can be grouped together
1238: if (l_opt_cnt < 3) then

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

1282: -- reset counter, and proceed as normal(one record at a time)
1283: l_opt_cnt := 0;
1284:
1285: if (l_logLevel <= wip_constants.trace_logging) then
1286: wip_logger.log('wip_picking_pvt.allocate => ' ||
1287: 'flow optimal group NOT optimzable', l_dummy2);
1288: end if;
1289: else
1290: -- can be optimized, do nothing here, it will be processed

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

1289: else
1290: -- can be optimized, do nothing here, it will be processed
1291: -- as a whole right before passing to INV
1292: if (l_logLevel <= wip_constants.trace_logging) then
1293: wip_logger.log('wip_picking_pvt.allocate => ' ||
1294: 'flow optimal group IS optimzable', l_dummy2);
1295: end if;
1296: end if;
1297: end if;

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

1299: -- in the middle of an optimized flow sched group, jump to the end
1300: -- of the jobs loop, since this whole group has been added to
1301: -- l_linesTable to pass to INV
1302: if (l_logLevel <= wip_constants.trace_logging) then
1303: wip_logger.log('wip_picking_pvt.allocate => ' ||
1304: 'processing flow optimal group..', l_dummy2);
1305: end if;
1306: l_opt_cnt := l_opt_cnt-1;
1307: GOTO END_OF_FOR_LOOP;

Line 1325: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: invalid entity_type' );

1321:
1322: else -- if(p_wip_entity_type = l_disc)
1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1325: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: invalid entity_type' );
1326: x_msg_data := fnd_message.get;
1327: return;
1328: end if;
1329:

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

1483: null;
1484: end loop; --end per entity loop
1485:
1486: if (l_logLevel <= wip_constants.trace_logging) then
1487: wip_logger.log('wip_picking_pvt.allocate => line count passed to inv_wip_picking_pvt.release_pick_batch: '
1488: || l_lineCount || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1489: end if;
1490: if(l_lineCount > 0) then
1491: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;

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

1488: || l_lineCount || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1489: end if;
1490: if(l_lineCount > 0) then
1491: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;
1492: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,
1493: p_mo_line_rec_tbl => l_linesTable,
1494: p_auto_detail_flag => nvl(p_auto_detail_flag,'T'),
1495: p_print_pick_slip => nvl(p_print_pick_slip,'F'),
1496: p_plan_tasks => nvl(p_plan_tasks,FALSE),

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

1502: x_mo_line_errrec_tbl => x_MOLineErrTbl);
1503: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);
1504:
1505: if (l_logLevel <= wip_constants.trace_logging) then
1506: wip_logger.log('returned status from call to inv_wip_picking_pvt.release_pick_batch() = ' || l_pickStatus || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1507: end if;
1508:
1509: --bugfix 4435437
1510: /* if thru srs, print the records that errored out and set the global variable so that we can

Line 1517: WIP_PICKING_PVT.g_PickRelease_Failed := TRUE;

1513:
1514: if (nvl(fnd_global.CONC_REQUEST_ID, -1) <> -1) then
1515: if x_MOLineErrTbl.count > 0 then
1516:
1517: WIP_PICKING_PVT.g_PickRelease_Failed := TRUE;
1518: fnd_file.put_line(which => fnd_file.log, buff => 'The errored Records are as follows:');
1519:
1520: for i in x_MOLineErrTbl.FIRST..x_MOLineErrTbl.LAST
1521: loop

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

1573: end if;
1574: end if; /* end of l_lineCount > 0 */
1575:
1576: if (l_logLevel <= wip_constants.trace_logging) then
1577: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_status='
1578: || l_pickStatus, l_dummy2);
1579: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_msg='
1580: || x_msg_data, l_dummy2);
1581: end if;

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

1575:
1576: if (l_logLevel <= wip_constants.trace_logging) then
1577: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_status='
1578: || l_pickStatus, l_dummy2);
1579: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_msg='
1580: || x_msg_data, l_dummy2);
1581: end if;
1582:
1583: if(nvl(p_print_pick_slip,'T') = 'T') then

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

1596: fnd_message.set_token('WIP_PICKING_MO_NUMBER', l_string1);
1597: fnd_message.set_token('WIP_PICKING_PRINT_SLIP', l_string2);
1598: x_msg_data := fnd_message.get;
1599: elsif (l_pickStatus = 'N') then
1600: -- 'N' could also result from l_lineCount = 0, and inv_wip_picking_pvt.release_pick_batch
1601: -- was never called
1602: x_return_status := 'N';
1603: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION');
1604: x_msg_data := fnd_message.get;

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

1637: when others then
1638: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1640: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1641: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
1642: x_msg_data := fnd_message.get;
1643: if (l_logLevel <= wip_constants.trace_logging) then
1644: wip_logger.log(x_msg_data, l_dummy2);
1645: wip_logger.cleanup(l_dummy2);

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

1806: when others then
1807: ROLLBACK TO GET_HDR_LINES_START;
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1810: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.get_HdrLinesRec: ' || SQLERRM);
1811: x_msg_data := fnd_message.get;
1812:
1813:
1814: end get_HdrLinesRec;

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

1857: TYPE carton_tbl_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1858: carton_tbl carton_tbl_t;
1859: l_string1 VARCHAR2(200);
1860: l_string2 VARCHAR2(200);
1861: x_MOLineErrTbl INV_WIP_Picking_Pvt.Trolin_ErrTbl_type; --bugfix 4435437
1862: BEGIN
1863: SAVEPOINT WIP_ALLOCATE_COMP_PVT_START;
1864: x_msg_data := null;
1865:

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

2114: end loop;
2115:
2116: if(l_lineCount > 0) then
2117: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;
2118: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,
2119: p_mo_line_rec_tbl => l_linesTable,
2120: p_auto_detail_flag => nvl(p_auto_detail_flag,'T'),
2121: p_print_pick_slip => nvl(p_print_pick_slip,'F'),
2122: p_plan_tasks => nvl(p_plan_tasks,FALSE),

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

2150: fnd_message.set_token('WIP_PICKING_MO_NUMBER', l_string1);
2151: fnd_message.set_token('WIP_PICKING_PRINT_SLIP', l_string2);
2152: x_msg_data := fnd_message.get;
2153: elsif (l_pickStatus = 'N') then
2154: -- 'N' could also result from l_lineCount = 0, and inv_wip_picking_pvt.release_pick_batch
2155: -- was never called
2156: x_return_status := 'N';
2157: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION');
2158: x_msg_data := fnd_message.get;

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

2178: when others then
2179: ROLLBACK TO WIP_ALLOCATE_COMP_PVT_START;
2180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2181: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2182: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
2183: x_msg_data := fnd_message.get;
2184: end allocate_comp;
2185:
2186: --this version is used in the concurrent request

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

2598: || ';l_print_pickslips=' || l_print_pickslips );
2599: end if;
2600: end if;
2601: /*bugfix 4435437: set the process to warning if failed */
2602: if (WIP_PICKING_PVT.g_PickRelease_Failed = TRUE) then
2603: retcode := 1 ;
2604: end if;
2605: commit;
2606: exception

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

2725: x_return_status := FND_API.G_RET_STS_SUCCESS;
2726:
2727: l_logLevel := fnd_log.g_current_runtime_level;
2728: if (l_logLevel <= wip_constants.trace_logging) then
2729: wip_logger.log('In wip_picking_pvt.Post_Explosion_CleanUp():'
2730: || p_wip_entity_id || ':' || p_org_id
2731: || ':' || p_repetitive_schedule_id, l_dummy2);
2732: end if;
2733:

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

2779: x_msg_data => x_msg_data);
2780:
2781: if (x_return_status <> fnd_api.g_ret_sts_success) then
2782: if (l_logLevel <= wip_constants.trace_logging) then
2783: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2784: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2785: end if;
2786: Return;
2787: End if;

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

2826: x_msg_data => x_msg_data);
2827:
2828: if (x_return_status <> fnd_api.g_ret_sts_success) then
2829: if (l_logLevel <= wip_constants.trace_logging) then
2830: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2831: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2832: end if;
2833: Return;
2834: End if;

Line 2868: end wip_picking_pvt;

2864: end if;
2865: End Post_Explosion_CleanUp;
2866:
2867:
2868: end wip_picking_pvt;