APPS.INV_QUANTITY_TREE_UE dependencies on FND_PROFILE

Line 8: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4: g_debug NUMBER := NULL;
5: PROCEDURE print_debug(p_message IN VARCHAR2, p_level IN NUMBER DEFAULT 14) IS
6: BEGIN
7: IF g_debug IS NULL THEN
8: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9: END IF;
10:
11: IF (g_debug = 1) THEN
12: inv_log_util.trace(p_message, 'INV_QUANTITY_TREE_UE', p_level);

Line 141: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

137: l_available_conv_quantity NUMBER := NULL;
138: l_onhand_conv_quantity NUMBER := NULL;
139: l_primary_uom_code VARCHAR2(3) := NULL;
140:
141: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
142: l_demand_header_type NUMBER;
143: BEGIN
144:
145: IF (l_debug = 1) then

Line 146: print_debug('New profile value INV_MATERIAL_STATUS ='||NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),'x') );

142: l_demand_header_type NUMBER;
143: BEGIN
144:
145: IF (l_debug = 1) then
146: print_debug('New profile value INV_MATERIAL_STATUS ='||NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),'x') );
147: print_debug('Create_tree Inputs Org:'||p_organization_id||'itm:'||p_inventory_item_id||
148: 'RevCtrl:'||p_revision_control||'LotCtrl:'||p_lot_control||
149: 'SerCtrl:'||p_serial_control||'LotAct:'||p_lot_active);
150: print_debug('DHdrId:'||p_demand_header_id||'DHdrTyp:'||p_demand_header_type||

Line 638: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

634: l_transaction_quantity NUMBER := NULL;
635: l_transaction_quantity2 NUMBER := NULL; -- invConv change
636: l_transaction_conv_quantity NUMBER := NULL;
637: l_primary_uom_code VARCHAR2(3) := NULL;
638: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
639:
640: l_lot_control NUMBER;
641: CURSOR get_item_details( org_id IN NUMBER
642: , item_id IN NUMBER) IS

Line 1181: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1177: l_transaction_quantity2 NUMBER := NULL;
1178: l_available_onhand2 NUMBER := NULL;
1179: l_available_quantity2 NUMBER := NULL;
1180: l_onhand_quantity2 NUMBER := NULL;
1181: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1182:
1183: BEGIN
1184: -- invConv change : callng the new signature xact_qty :
1185: IF (l_debug = 1) then

Line 1314: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1310: l_process_type NUMBER := NULL;
1311: l_temp_trx_quantity NUMBER := NULL;
1312: l_temp_trx_quantity2 NUMBER := NULL;
1313:
1314: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1315:
1316: l_lot_control NUMBER;
1317: CURSOR get_item_details( org_id IN NUMBER
1318: , item_id IN NUMBER) IS