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 374: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

370: l_umconvert_trans_quantity NUMBER := 0;
371: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
372: l_primary_uom VARCHAR2(10);
373: l_ato_item NUMBER := 0;
374: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
375:
376: --bugfix 16778046
377: CURSOR c_fullfill_base IS
378: SELECT nvl(fulfillment_base,'P')