APPS.INV_QUANTITY_TREE_UE dependencies on FND_PROFILE

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

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

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

146: l_available_conv_quantity NUMBER := NULL;
147: l_onhand_conv_quantity NUMBER := NULL;
148: l_primary_uom_code VARCHAR2(3) := NULL;
149:
150: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
151: l_demand_header_type NUMBER;
152: BEGIN
153:
154: IF (l_debug = 1) then

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

151: l_demand_header_type NUMBER;
152: BEGIN
153:
154: IF (l_debug = 1) then
155: print_debug('New profile value INV_MATERIAL_STATUS ='||NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),'x') );
156: print_debug('Create_tree Inputs Org:'||p_organization_id||'itm:'||p_inventory_item_id||
157: 'RevCtrl:'||p_revision_control||'LotCtrl:'||p_lot_control||
158: 'SerCtrl:'||p_serial_control||'LotAct:'||p_lot_active);
159: print_debug('DHdrId:'||p_demand_header_id||'DHdrTyp:'||p_demand_header_type||

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

661: l_transaction_quantity NUMBER := NULL;
662: l_transaction_quantity2 NUMBER := NULL; -- invConv change
663: l_transaction_conv_quantity NUMBER := NULL;
664: l_primary_uom_code VARCHAR2(3) := NULL;
665: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
666: l_transfer_locator_id NUMBER := NULL; --Bug 14516283
667:
668: l_lot_control NUMBER;
669: CURSOR get_item_details( org_id IN NUMBER

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

1233: l_transaction_quantity2 NUMBER := NULL;
1234: l_available_onhand2 NUMBER := NULL;
1235: l_available_quantity2 NUMBER := NULL;
1236: l_onhand_quantity2 NUMBER := NULL;
1237: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1238:
1239: BEGIN
1240: -- invConv change : callng the new signature xact_qty :
1241: IF (l_debug = 1) then

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

1374: l_process_type NUMBER := NULL;
1375: l_temp_trx_quantity NUMBER := NULL;
1376: l_temp_trx_quantity2 NUMBER := NULL;
1377:
1378: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1379:
1380: l_lot_control NUMBER;
1381: CURSOR get_item_details( org_id IN NUMBER
1382: , item_id IN NUMBER) IS