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.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: print_debug('p_grouping_rule_id = '||p_grouping_rule_id,'Inv_Pick_Release_PVT.assign_pick_slip_number');
379: END IF;
380: SAVEPOINT assign_pick_slip;
381:

Line 378: print_debug('p_grouping_rule_id = '||p_grouping_rule_id,'Inv_Pick_Release_PVT.assign_pick_slip_number');

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: print_debug('p_grouping_rule_id = '||p_grouping_rule_id,'Inv_Pick_Release_PVT.assign_pick_slip_number');
379: END IF;
380: SAVEPOINT assign_pick_slip;
381:
382: IF p_move_order_header_id = -1 THEN

Line 385: 'Inv_Pick_Release_PVT.assign_pick_slip_number');

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

Line 405: print_debug('l_get_header_rule = '||l_get_header_rule,'Inv_Pick_Release_PVT.assign_pick_slip_number');

401: l_get_header_rule := 1;
402: END IF;
403:
404: IF (l_debug = 1) THEN
405: print_debug('l_get_header_rule = '||l_get_header_rule,'Inv_Pick_Release_PVT.assign_pick_slip_number');
406: END IF;
407:
408: IF l_get_header_rule = 1 THEN
409: BEGIN

Line 425: 'Inv_Pick_Release_PVT.assign_pick_slip_number');

421: END;
422:
423: IF (l_debug = 1) THEN
424: print_debug('l_grouping_rule_id = '||l_grouping_rule_id||',l_organization_id = '||l_organization_id,
425: 'Inv_Pick_Release_PVT.assign_pick_slip_number');
426: END IF;
427:
428: -- If the header did not have a grouping rule ID, retrieve it from
429: -- the organization-level default.

Line 465: 'Inv_Pick_Release_Pvt.Process_Line');

461:
462: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
463: IF (l_debug = 1) THEN
464: print_debug('return error from WSH_INV_INTEGRATION.find_printer',
465: 'Inv_Pick_Release_Pvt.Process_Line');
466: END IF;
467: RAISE fnd_api.g_exc_unexpected_error;
468: END IF;
469:

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

481: WHERE header_id = p_move_order_header_id;
482: --AND organization_id = mmtt_line.organization_id; --bug 8829363
483:
484: IF (l_debug = 1) THEN
485: print_debug('organization_id '||mmtt_line.organization_id,'Inv_Pick_Release_PVT.assign_pick_slip_number');
486: END IF;
487: /*End of modifications for Bug # 6144354 */
488:
489: SELECT document_set_id

Line 520: inv_pick_release_pvt.get_pick_slip_number(

516:
517: ELSE
518: l_call_mode := NULL;
519: -- Bug 2666620: Inline branching to call either WSH or INV get_pick_slip_number
520: inv_pick_release_pvt.get_pick_slip_number(
521: p_ps_mode => p_ps_mode
522: , p_pick_grouping_rule_id => l_grouping_rule_id
523: , p_org_id => mmtt_line.organization_id
524: , p_header_id => mmtt_line.oe_header_id

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

542: , p_locator_id => mmtt_line.locator_id
543: , p_revision => mmtt_line.revision
544: );
545: IF (l_debug = 1) THEN
546: print_debug('l_call_mode'|| l_call_mode, 'Inv_Pick_Release_PVT.Process_Line');
547: END IF;
548:
549: IF l_api_return_status <> fnd_api.g_ret_sts_success
550: OR l_pick_slip_number = -1 THEN

Line 568: 'Inv_Pick_Release_Pvt.Process_Line');

564:
565: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
566: IF (l_debug = 1) THEN
567: print_debug('return error from WSH_INV_INTEGRATION.find_printer',
568: 'Inv_Pick_Release_Pvt.Process_Line');
569: END IF;
570: RAISE fnd_api.g_exc_unexpected_error;
571: END IF;
572:

Line 1290: print_debug('Tree id from Normal Create tree'||l_tree_id,'Inv_Pick_Release_PVT.Process_Line');

1286: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
1287: );
1288:
1289: If is_debug then
1290: print_debug('Tree id from Normal Create tree'||l_tree_id,'Inv_Pick_Release_PVT.Process_Line');
1291: End If;
1292:
1293: l_qtree_item_tbl(l_item_index).tree_id := l_tree_id;
1294:

Line 1352: print_debug('No data found-Transaction types','Inv_Pick_Release_PVT.Process_Line');

1348: exception
1349: when others then
1350: l_demand_source_type :=-9999;
1351: If is_debug then
1352: print_debug('No data found-Transaction types','Inv_Pick_Release_PVT.Process_Line');
1353: End If;
1354: END;
1355:
1356: inv_quantity_tree_pvt.create_tree

Line 1382: print_debug('Tree id from PJM Create tree'||l_tree_id,'Inv_Pick_Release_PVT.Process_Line');

1378: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
1379: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
1380: );
1381: If is_debug then
1382: print_debug('Tree id from PJM Create tree'||l_tree_id,'Inv_Pick_Release_PVT.Process_Line');
1383: End If;
1384:
1385: l_qtree_line_tbl(l_qtree_line_index).tree_id := l_tree_id;
1386:

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

1783: );
1784:
1785: -- Call the Pick Release Process_Line API on the current Move Order Line
1786: If is_debug then
1787: print_debug('calling INV_Pick_Release_PVT.process_line',
1788: 'Inv_Pick_Release_Pub.Pick_Release');
1789: End If;
1790:
1791: INV_Pick_Release_PVT.Process_Line(

Line 1791: INV_Pick_Release_PVT.Process_Line(

1787: print_debug('calling INV_Pick_Release_PVT.process_line',
1788: 'Inv_Pick_Release_Pub.Pick_Release');
1789: End If;
1790:
1791: INV_Pick_Release_PVT.Process_Line(
1792: p_api_version => 1.0
1793: ,p_init_msg_list => fnd_api.g_false
1794: ,p_commit => fnd_api.g_false
1795: ,x_return_status => l_api_return_status

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

1871:
1872: -- Get the tolerance set while allocating the line
1873: -- If quantity is within tolerance then do not backorder shipset
1874: --
1875: -- l_lower_tolerance := l_quantity * inv_pick_release_pvt.g_min_tolerance;
1876: -- Bug 5188796: g_min_tolerance is a qty, not a %, so use as is
1877: l_lower_tolerance := inv_pick_release_pvt.g_min_tolerance;
1878: l_lower_tolerance2 := inv_pick_release_pvt.g_min_tolerance2;
1879:

Line 1877: l_lower_tolerance := inv_pick_release_pvt.g_min_tolerance;

1873: -- If quantity is within tolerance then do not backorder shipset
1874: --
1875: -- l_lower_tolerance := l_quantity * inv_pick_release_pvt.g_min_tolerance;
1876: -- Bug 5188796: g_min_tolerance is a qty, not a %, so use as is
1877: l_lower_tolerance := inv_pick_release_pvt.g_min_tolerance;
1878: l_lower_tolerance2 := inv_pick_release_pvt.g_min_tolerance2;
1879:
1880: --MUOM Fulfillment Project
1881: inv_utilities.get_inv_fulfillment_base(

Line 1878: l_lower_tolerance2 := inv_pick_release_pvt.g_min_tolerance2;

1874: --
1875: -- l_lower_tolerance := l_quantity * inv_pick_release_pvt.g_min_tolerance;
1876: -- Bug 5188796: g_min_tolerance is a qty, not a %, so use as is
1877: l_lower_tolerance := inv_pick_release_pvt.g_min_tolerance;
1878: l_lower_tolerance2 := inv_pick_release_pvt.g_min_tolerance2;
1879:
1880: --MUOM Fulfillment Project
1881: inv_utilities.get_inv_fulfillment_base(
1882: p_source_line_id => l_mo_line.txn_source_line_id,

Line 3039: print_debug('after calling inv_pick_release_pvt',

3035: END IF;
3036: END LOOP;
3037:
3038: IF is_debug then
3039: print_debug('after calling inv_pick_release_pvt',
3040: 'Inv_Pick_Release_Pub.Pick_Release');
3041: END IF;
3042:
3043: -- To ensure that lock_flag should not get updated to Y unnecessarily i.e., only change needed only when high volume related code executes