APPS.INV_MO_BACKORDER_PVT dependencies on FND_PROFILE

Line 7: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');

3:
4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MO_BACKORDER_PVT';
6: g_version_printed BOOLEAN := FALSE;
7: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
8:
9: PROCEDURE DEBUG(p_message IN VARCHAR2, p_module IN VARCHAR2) IS
10: BEGIN
11: IF NOT g_version_printed THEN

Line 40: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

36: WHERE move_order_line_id = p_mo_line_rec.line_id
37: AND move_order_line_id IS NOT NULL
38: AND released_status = 'S';
39:
40: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
41: BEGIN
42: x_return_status := fnd_api.g_ret_sts_success;
43: l_qty_to_backorder := NVL(p_mo_line_rec.quantity, 0) - NVL(p_mo_line_rec.quantity_delivered, 0);
44: DEBUG('l_qty_to_backorder' || l_qty_to_backorder, 'BACKORDER_SOURCE');

Line 193: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

189: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp t
190: WHERE t.parent_line_id = mmtt.transaction_temp_id)
191: FOR UPDATE NOWAIT;
192:
193: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
194: BEGIN
195: x_return_status := fnd_api.g_ret_sts_success;
196:
197: -- Set savepoint

Line 373: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

369: l_umconvert_trans_quantity NUMBER := 0;
370: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
371: l_primary_uom VARCHAR2(10);
372: l_ato_item NUMBER := 0;
373: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
374:
375: l_rsv_detailed_qty NUMBER;
376: l_rsv_secondary_detailed_qty NUMBER; -- INVCONV
377: l_rsv_reservation_qty NUMBER;