APPS.INV_MO_LINE_DETAIL_UTIL dependencies on FND_PROFILE

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

624: , p_mo_line_detail_rec IN g_mmtt_rec
625: , x_mo_line_detail_rec OUT NOCOPY g_mmtt_rec
626: ) IS
627: l_mmtt_rec g_mmtt_rec;
628: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
629: BEGIN
630: SELECT transaction_header_id
631: , transaction_temp_id
632: , source_code

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

1653: , secondary_uom_code -- INVCONV change
1654: FROM mtl_material_transactions_temp
1655: WHERE transaction_temp_id = p_line_detail_id;
1656:
1657: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1658: BEGIN
1659: IF (p_line_id IS NOT NULL AND p_line_id <> fnd_api.g_miss_num)
1660: AND(p_line_detail_id IS NOT NULL AND p_line_detail_id <> fnd_api.g_miss_num) THEN
1661: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

2138: || ' where move_order_line_id = :b_move_order_line_id) ';
2139: l_del_mmtt LONG
2140: := 'DELETE mtl_material_transactions_temp ' || ' where move_order_line_id = :b_move_order_line_id ';
2141: l_current_table VARCHAR2(30);
2142: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2143: BEGIN
2144: SAVEPOINT update_qty;
2145: x_return_status := fnd_api.g_ret_sts_success;
2146:

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

2597: , ROWID
2598: FROM mtl_serial_numbers_temp
2599: WHERE transaction_temp_id = l_serial_transaction_temp_id;
2600:
2601: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2602: BEGIN
2603: SAVEPOINT reduce_sp;
2604:
2605: IF p_quantity IS NULL

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

2764: FROM mtl_transaction_lots_temp mtlt
2765: WHERE mtlt.transaction_temp_id = p_transaction_temp_id;
2766:
2767: l_lot_quantity NUMBER := 0;
2768: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2769: BEGIN
2770: OPEN lot_records;
2771: FETCH lot_records INTO l_lot_quantity;
2772: CLOSE lot_records;

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

2808: FROM mtl_serial_numbers_temp msnt
2809: WHERE msnt.transaction_temp_id = p_transaction_temp_id;
2810:
2811: l_serial_quantity NUMBER := 0;
2812: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2813: BEGIN
2814: OPEN serial_records;
2815: FETCH serial_records INTO l_serial_quantity;
2816: CLOSE serial_records;

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

2877: l_msg_count NUMBER := 0;
2878: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2879: l_lot_expiration_date DATE;
2880: l_transaction_date DATE;
2881: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2882: BEGIN
2883: OPEN item_properties(p_transaction_temp_id);
2884: FETCH item_properties INTO l_lot_control_code
2885: , l_serial_number_control_code

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

3028: l_msg_count NUMBER;
3029: l_msg_data VARCHAR2(1000);
3030: l_detail_records_exist BOOLEAN := FALSE;
3031: l_transaction_temp_id NUMBER;
3032: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3033: BEGIN
3034: OPEN mmtt_records;
3035:
3036: LOOP