APPS.INV_LOT_SERIAL_UPGRADE dependencies on FND_PROFILE

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

6: **************************/
7:
8: /* Debug */
9: PROCEDURE trace(p_msg IN VARCHAR2, p_level IN NUMBER DEFAULT 4) IS
10: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11: BEGIN
12: IF (l_debug = 1) THEN
13: inv_trx_util_pub.trace(p_msg, 'UPGRADE_LOT_SER', 1);
14: END IF;

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

44: l_previous_item_id NUMBER := -1;
45: l_previous_org_id NUMBER := -1;
46:
47:
48: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
49: BEGIN
50: IF (l_debug = 1) THEN
51: trace('Upgrading Lot numbers, org ='|| p_organization_id);
52: END IF;

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

169: l_previous_item_id NUMBER := -1;
170: l_previous_org_id NUMBER := -1;
171:
172:
173: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
174: BEGIN
175: --trace('Upgrading Serial numbers, org, item='|| p_organization_id
176: -- || ',' || p_inventory_item_id);
177:

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

289: l_update_cur INTEGER;
290: l_update_stmt VARCHAR2(1000);
291: i BINARY_INTEGER;
292: l_rowupdated NUMBER;
293: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
294: BEGIN
295: --trace('In UPDATE_LOT_SERIAL, lot/ser option, org, item, lot/ser, p_attr_count ');
296: --trace(' ' || p_lot_serial_option || ',' || p_organization_id
297: -- ||','|| p_inventory_item_id || ',' || p_lot_serial_number

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

381: l_return_status VARCHAR2(100);
382: l_msg_count NUMBER;
383: l_msg_data VARCHAR2(2000);
384: l_upgrade_count NUMBER := 0;
385: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
386: BEGIN
387: IF (l_debug = 1) THEN
388: trace('**** Upgrade Lot and Serial('||
389: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')||') ****');