DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on INV_WIP_PICKING_PVT

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