APPS.INV_MO_CANCEL_PVT dependencies on FND_PROFILE

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

195: l_total_wdd_req_qty := -1;
196: l_extra_rsv_quantity := 0;
197: l_extra_rsv_quantity2 := 0;
198: l_total_rsv_quantity2 := 0;
199: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
200:
201: IF p_line_id IS NOT NULL
202: THEN
203: -- {

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

1334: || ', p_delivery_detail_id: ' || to_char(p_delivery_detail_id)
1335: ,'Reduce_Move_Order_Quantity');
1336: END IF;
1337:
1338: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1339:
1340: IF p_reduction_quantity <= 0 THEN
1341: RETURN;
1342: END IF;

Line 2279: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N'); --Bug 7190635

2275: l_deleted_quantity NUMBER;
2276: l_return_status VARCHAR2(1);
2277: l_error_code NUMBER;
2278: l_ato_serial_pick VARCHAR2(1); -- Bug 7190635
2279: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N'); --Bug 7190635
2280:
2281: CURSOR c_primary_uom IS
2282: SELECT primary_uom_code
2283: FROM mtl_system_items

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

2283: FROM mtl_system_items
2284: WHERE organization_id = l_organization_id
2285: AND inventory_item_id = l_inventory_item_id;
2286:
2287: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2288: BEGIN
2289: IF (l_debug = 1) THEN
2290: DEBUG('Setting Savepoint', 'reduce_rsv_allocation');
2291: END IF;

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

2561: DEBUG('carton group id: ' || p_carton_grouping_id, 'update_mol_carton_group');
2562: DEBUG('before update statement...', 'update_mol_carton_group');
2563: END IF;
2564:
2565: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2566: x_return_status := fnd_api.g_ret_sts_success;
2567:
2568: -- {{
2569: -- BEGIN update_mol_carton_group }}