DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on INV_WIP_PICKING_PVT

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