DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on INV_PICK_RELEASE_PVT

Line 377: 'Inv_Pick_Release_PVT.assign_pick_slip_number');

373:
374: BEGIN
375: IF (l_debug = 1) THEN
376: print_debug('get pick slip number for move order header '||p_move_order_header_id,
377: 'Inv_Pick_Release_PVT.assign_pick_slip_number');
378: END IF;
379: SAVEPOINT assign_pick_slip;
380:
381: IF p_move_order_header_id = -1 THEN

Line 384: 'Inv_Pick_Release_PVT.assign_pick_slip_number');

380:
381: IF p_move_order_header_id = -1 THEN
382: IF (l_debug = 1) THEN
383: print_debug('calling from concurrent program ',
384: 'Inv_Pick_Release_PVT.assign_pick_slip_number');
385: END IF;
386: For mmtt_line in l_mold_crs_con LOOP
387: UPDATE mtl_material_transactions_temp
388: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval

Line 455: 'Inv_Pick_Release_Pvt.Process_Line');

451:
452: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
453: IF (l_debug = 1) THEN
454: print_debug('return error from WSH_INV_INTEGRATION.find_printer',
455: 'Inv_Pick_Release_Pvt.Process_Line');
456: END IF;
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;
459:

Line 475: print_debug('organization_id '||mmtt_line.organization_id,'Inv_Pick_Release_PVT.assign_pick_slip_number');

471: WHERE header_id = p_move_order_header_id
472: AND organization_id = mmtt_line.organization_id;
473:
474: IF (l_debug = 1) THEN
475: print_debug('organization_id '||mmtt_line.organization_id,'Inv_Pick_Release_PVT.assign_pick_slip_number');
476: END IF;
477: /*End of modifications for Bug # 6144354 */
478:
479: SELECT document_set_id

Line 510: inv_pick_release_pvt.get_pick_slip_number(

506:
507: ELSE
508: l_call_mode := NULL;
509: -- Bug 2666620: Inline branching to call either WSH or INV get_pick_slip_number
510: inv_pick_release_pvt.get_pick_slip_number(
511: p_ps_mode => p_ps_mode
512: , p_pick_grouping_rule_id => l_grouping_rule_id
513: , p_org_id => mmtt_line.organization_id
514: , p_header_id => mmtt_line.oe_header_id

Line 536: print_debug('l_call_mode'|| l_call_mode, 'Inv_Pick_Release_PVT.Process_Line');

532: , p_locator_id => mmtt_line.locator_id
533: , p_revision => mmtt_line.revision
534: );
535: IF (l_debug = 1) THEN
536: print_debug('l_call_mode'|| l_call_mode, 'Inv_Pick_Release_PVT.Process_Line');
537: END IF;
538:
539: IF l_api_return_status <> fnd_api.g_ret_sts_success
540: OR l_pick_slip_number = -1 THEN

Line 558: 'Inv_Pick_Release_Pvt.Process_Line');

554:
555: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
556: IF (l_debug = 1) THEN
557: print_debug('return error from WSH_INV_INTEGRATION.find_printer',
558: 'Inv_Pick_Release_Pvt.Process_Line');
559: END IF;
560: RAISE fnd_api.g_exc_unexpected_error;
561: END IF;
562:

Line 1255: 'Inv_Pick_Release_PVT.Process_Line');

1251: );
1252:
1253: If is_debug then
1254: print_debug('Tree id from Normal Create tree'||l_tree_id,
1255: 'Inv_Pick_Release_PVT.Process_Line');
1256: End If;
1257:
1258: l_qtree_item_tbl(l_item_index).tree_id := l_tree_id;
1259:

Line 1319: 'Inv_Pick_Release_PVT.Process_Line');

1315: when others then
1316: l_demand_source_type :=-9999;
1317: If is_debug then
1318: print_debug('No data found-Transaction types',
1319: 'Inv_Pick_Release_PVT.Process_Line');
1320: End If;
1321: END;
1322:
1323: inv_quantity_tree_pvt.create_tree

Line 1350: 'Inv_Pick_Release_PVT.Process_Line');

1346: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
1347: );
1348: If is_debug then
1349: print_debug('Tree id from PJM Create tree'||l_tree_id,
1350: 'Inv_Pick_Release_PVT.Process_Line');
1351: End If;
1352:
1353: l_qtree_line_tbl(l_qtree_line_index).tree_id := l_tree_id;
1354:

Line 1737: print_debug('calling INV_Pick_Release_PVT.process_line',

1733: END IF;
1734:
1735: -- Call the Pick Release Process_Line API on the current Move Order Line
1736: If is_debug then
1737: print_debug('calling INV_Pick_Release_PVT.process_line',
1738: 'Inv_Pick_Release_Pub.Pick_Release');
1739: End If;
1740:
1741: INV_Pick_Release_PVT.Process_Line(

Line 1741: INV_Pick_Release_PVT.Process_Line(

1737: print_debug('calling INV_Pick_Release_PVT.process_line',
1738: 'Inv_Pick_Release_Pub.Pick_Release');
1739: End If;
1740:
1741: INV_Pick_Release_PVT.Process_Line(
1742: p_api_version => 1.0
1743: ,p_init_msg_list => fnd_api.g_false
1744: ,p_commit => fnd_api.g_false
1745: ,x_return_status => l_api_return_status

Line 1809: -- l_lower_tolerance := l_quantity * inv_pick_release_pvt.g_min_tolerance;

1805:
1806: -- Get the tolerance set while allocating the line
1807: -- If quantity is within tolerance then do not backorder shipset
1808: --
1809: -- l_lower_tolerance := l_quantity * inv_pick_release_pvt.g_min_tolerance;
1810: -- Bug 5188796: g_min_tolerance is a qty, not a %, so use as is
1811: l_lower_tolerance := inv_pick_release_pvt.g_min_tolerance;
1812:
1813: -- Bug #2748751

Line 1811: l_lower_tolerance := inv_pick_release_pvt.g_min_tolerance;

1807: -- If quantity is within tolerance then do not backorder shipset
1808: --
1809: -- l_lower_tolerance := l_quantity * inv_pick_release_pvt.g_min_tolerance;
1810: -- Bug 5188796: g_min_tolerance is a qty, not a %, so use as is
1811: l_lower_tolerance := inv_pick_release_pvt.g_min_tolerance;
1812:
1813: -- Bug #2748751
1814: -- If move order is partially transacted and the allocations are split
1815: -- again, the allocated quantity will be lesser than move order quantity

Line 2889: print_debug('after calling inv_pick_release_pvt',

2885: END IF;
2886: END LOOP;
2887:
2888: IF is_debug then
2889: print_debug('after calling inv_pick_release_pvt',
2890: 'Inv_Pick_Release_Pub.Pick_Release');
2891: END IF;
2892:
2893: -- Bug 4349602: Deleting Move Order Lines which are not allocated