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_REPLENISH_DETAIL_PUB dependencies on INV_REPLENISH_DETAIL_PUB

Line 1: PACKAGE BODY inv_replenish_detail_pub AS

1: PACKAGE BODY inv_replenish_detail_pub AS
2: /* $Header: INVTOTXB.pls 120.17.12020000.5 2013/04/18 06:44:36 vipratap ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Replenish_Detail_PUB';

2: /* $Header: INVTOTXB.pls 120.17.12020000.5 2013/04/18 06:44:36 vipratap ship $ */
3:
4: -- Global constant holding the package name
5:
6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Replenish_Detail_PUB';
7: is_debug BOOLEAN := TRUE;
8: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
9:
10: -- Start of Comments

Line 442: inv_replenish_detail_pub.delete_details(

438: print_debug('calling delete details');
439: END IF;
440:
441: -- HW INVCONV - Pass secondary_qty
442: inv_replenish_detail_pub.delete_details(
443: p_transaction_temp_id => l_mold_tbl_temp(l_index).transaction_temp_id
444: , p_move_order_line_id => l_mold_tbl_temp(l_index).move_order_line_id
445: , p_reservation_id => l_mold_tbl_temp(l_index).reservation_id
446: , p_transaction_quantity => l_mold_tbl_temp(l_index).transaction_quantity

Line 2304: print_debug('OVPK: Calling inv_replenish_detail_pub.check_shipping_tolerances');

2300: IF (l_debug = 1) THEN
2301: print_debug('OVPK: l_all_alloc = ' || l_all_alloc);
2302: print_debug('OVPK: l_other_alloc = l_all_alloc - l_this_alloc = ' || l_other_alloc);
2303: print_debug('OVPK: l_other_alloc2 = l_all_alloc2 - l_this_alloc2 = ' || l_other_alloc2);
2304: print_debug('OVPK: Calling inv_replenish_detail_pub.check_shipping_tolerances');
2305: print_debug('OVPK: With the following params');
2306: print_debug('OVPK: l_mo_line_id = ' || l_mo_line_id);
2307: print_debug('OVPK: p_new_qty = ' || l_new_qty);
2308: print_debug('OVPK: l_new_qty2 = ' || l_new_qty2);

Line 2313: inv_replenish_detail_pub.check_shipping_tolerances(

2309: END IF;
2310:
2311: -- Call the shipping API to get l_max_quantity_allowed for this particular SO Line
2312: IF l_trx_source_line_id IS NOT NULL THEN
2313: inv_replenish_detail_pub.check_shipping_tolerances(
2314: x_return_status => l_return_status
2315: , x_msg_count => l_msg_count
2316: , x_msg_data => l_msg_data
2317: , x_allowed => l_allowed_flag

Line 2527: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty

2523: print_debug('OVPK: p_overpicked_qty = ' || p_overpicked_qty);
2524: print_debug('OVPK: p_overpicked_qty2 = ' || p_overpicked_qty2);
2525: END IF;
2526:
2527: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty
2528: --to find out if overpicking is allowed
2529: --and if allowed,to what extent
2530: inv_replenish_detail_pub.get_overpick_qty(
2531: p_transaction_temp_id => p_transaction_temp_id

Line 2530: inv_replenish_detail_pub.get_overpick_qty(

2526:
2527: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty
2528: --to find out if overpicking is allowed
2529: --and if allowed,to what extent
2530: inv_replenish_detail_pub.get_overpick_qty(
2531: p_transaction_temp_id => p_transaction_temp_id
2532: , p_overpicked_qty => p_overpicked_qty
2533: , p_overpicked_qty2 => p_overpicked_qty2
2534: , x_ovpk_allowed => l_ovpk_allowed

Line 2885: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty

2881: print_debug('OVPK: p_transaction_temp_id = ' || p_transaction_temp_id);
2882: print_debug('OVPK: p_overpicked_qty = ' || p_overpicked_qty);
2883: END IF;
2884:
2885: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty
2886: --to find out if overpicking is allowed
2887: --and if allowed,to what extent
2888: inv_replenish_detail_pub.get_overpick_qty(
2889: p_transaction_temp_id => p_transaction_temp_id

Line 2888: inv_replenish_detail_pub.get_overpick_qty(

2884:
2885: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty
2886: --to find out if overpicking is allowed
2887: --and if allowed,to what extent
2888: inv_replenish_detail_pub.get_overpick_qty(
2889: p_transaction_temp_id => p_transaction_temp_id
2890: , p_overpicked_qty => p_overpicked_qty
2891: , x_ovpk_allowed => l_ovpk_allowed
2892: , x_max_qty_allowed => l_max_qty_allowed

Line 3315: print_debug('OVPK: Calling inv_replenish_detail_pub.check_shipping_tolerances');

3311: print_debug('OVPK: l_all_alloc = ' || l_all_alloc);
3312: print_debug('OVPK: l_all_alloc2 = ' || l_all_alloc2);
3313: print_debug('OVPK: l_other_alloc = l_all_alloc - l_this_alloc = ' || l_other_alloc);
3314: print_debug('OVPK: l_other_alloc2 = l_all_alloc2 - l_this_alloc2 = ' || l_other_alloc2);
3315: print_debug('OVPK: Calling inv_replenish_detail_pub.check_shipping_tolerances');
3316: print_debug('OVPK: With the following params');
3317: print_debug('OVPK: l_mo_line_id = ' || l_mo_line_id);
3318: print_debug('OVPK: p_new_qty = ' || l_new_qty);
3319: print_debug('OVPK: p_new_qty2 = ' || l_new_qty2);

Line 3324: inv_replenish_detail_pub.check_shipping_tolerances(

3320: END IF;
3321:
3322: -- Call the shipping API to get l_max_quantity_allowed for this particular SO Line
3323: IF l_trx_source_line_id IS NOT NULL THEN
3324: inv_replenish_detail_pub.check_shipping_tolerances(
3325: x_return_status => l_return_status
3326: , x_msg_count => l_msg_count
3327: , x_msg_data => l_msg_data
3328: , x_allowed => l_allowed_flag

Line 3581: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty_Lot

3577: print_debug('OVPK: p_overpicked_qty = ' || p_overpicked_qty);
3578: print_debug('OVPK: p_lot_num = ' || p_lot_num);
3579: END IF;
3580:
3581: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty_Lot
3582: --to find out if overpicking is allowed
3583: --and if allowed,to what extent
3584: inv_replenish_detail_pub.get_overpick_qty_lot(
3585: p_transaction_temp_id => p_transaction_temp_id

Line 3584: inv_replenish_detail_pub.get_overpick_qty_lot(

3580:
3581: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty_Lot
3582: --to find out if overpicking is allowed
3583: --and if allowed,to what extent
3584: inv_replenish_detail_pub.get_overpick_qty_lot(
3585: p_transaction_temp_id => p_transaction_temp_id
3586: , p_overpicked_qty => p_overpicked_qty
3587: , p_overpicked_qty2 => p_overpicked_qty2
3588: , p_lot_num => p_lot_num

Line 3819: END inv_replenish_detail_pub;

3815: );
3816: END check_overpick_lot;
3817:
3818: ---------------------------------------------------
3819: END inv_replenish_detail_pub;