eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_API_PUB dependencies on FND_PROFILE

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

49:
50:
51: PROCEDURE print_debug ( p_err_msg VARCHAR2, p_level NUMBER DEFAULT 1)
52: IS
53: --l_debug number := 1;--NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
54: BEGIN
55: IF (g_debug = 1) THEN
56: inv_mobile_helper_functions.tracelog (
57: p_err_msg => p_err_msg,

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

64: END print_debug;
65:
66: PROCEDURE set_firstscan ( p_firstscan BOOLEAN )
67: IS
68: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
69: BEGIN
70: g_firstscan := p_firstscan;
71: END;
72:

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

72:
73: PROCEDURE populateattributescolumn
74: IS
75: l_column_idx BINARY_INTEGER;
76: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
77: BEGIN
78: g_lot_attributes_tbl ( 1 ).column_name := 'VENDOR_ID';
79: g_lot_attributes_tbl ( 1 ).column_type := 'NUMBER';
80: g_lot_attributes_tbl ( 2 ).column_name := 'GRADE_CODE';

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

337: description
338: FROM mtl_transaction_lots_temp
339: WHERE lot_number = p_lot_number
340: AND transaction_temp_id = p_trx_temp_id;
341: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
342: BEGIN
343: IF (l_debug = 1) THEN
344: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside InsertLot API' , 'INV_LOT_API_PUB');
345: END IF;

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

1560: vendor_name
1561: FROM mtl_transaction_lots_temp
1562: WHERE lot_number = p_lot_number
1563: AND transaction_temp_id = p_trx_temp_id;
1564: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1565: BEGIN
1566: -- Standard Start of API savepoint
1567: SAVEPOINT apiinsertlot_apipub;
1568:

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

2333: SELECT lot_number
2334: FROM mtl_material_transactions_temp lot
2335: WHERE lot_number = p_auto_lot_number
2336: AND inventory_item_id <> p_inventory_item_id;
2337: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2338: BEGIN
2339: IF l_lot_uniqueness IS NULL
2340: THEN
2341: BEGIN

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

2429: p_lot_prefix IN VARCHAR2 -- Bug# 7298723
2430: )
2431: IS
2432: PRAGMA AUTONOMOUS_TRANSACTION;
2433: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2434: l_update_count number := 0; -- Bug# 7298723
2435: BEGIN
2436: x_return_status := fnd_api.g_ret_sts_success;
2437: IF (l_debug =1 ) THEN

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

2606: l_unique_lot BOOLEAN := FALSE;
2607: l_lotcount NUMBER;
2608: l_api_version CONSTANT NUMBER := 1.0;
2609: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
2610: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2611: -- The following 2 variables are added as a part of bug fix for: Bug #3330855
2612: v_org_code VARCHAR2 ( 3 );
2613: v_item_name VARCHAR2 ( 80 );
2614:

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

3502: SELECT lot_number
3503: FROM mtl_material_transactions_temp lot
3504: WHERE lot_number = p_auto_lot_number
3505: AND inventory_item_id = p_inventory_item_id;
3506: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3507: BEGIN
3508: IF l_lot_uniqueness IS NULL
3509: THEN
3510: BEGIN

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

3620: )
3621: IS
3622: temp_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3623: v_found BOOLEAN := FALSE;
3624: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3625: BEGIN
3626: IF (l_debug = 1) THEN
3627: print_debug ('Getting the WMS and NON WMS LOT Attributes From the Source LOT',4);
3628: END IF;

Line 3920: --g_debug NUMBER := 1 ;--NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);

3916: errors_received EXCEPTION;
3917: error_msg VARCHAR2(5000);
3918: s NUMBER;
3919: e NUMBER;
3920: --g_debug NUMBER := 1 ;--NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
3921: l_null_char_val VARCHAR2(1000);
3922: l_null_num_val NUMBER;
3923: l_null_date_val DATE;
3924: l_global_nsegments NUMBER := 0;

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

9696: l_unique_lot BOOLEAN := FALSE;
9697: l_lotcount NUMBER;
9698: l_api_version CONSTANT NUMBER := 1.0;
9699: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
9700: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9701: v_org_code VARCHAR2 ( 3 );
9702: v_item_name VARCHAR2 ( 40 );
9703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;
9704: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;

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

10228:
10229: BEGIN
10230:
10231: IF (l_debug is null) THEN
10232: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10233: END IF;
10234:
10235: IF (l_debug = 1) THEN
10236: inv_log_util.trace('validate_quantities: Start ', g_pkg_name, 9);