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.

[Home] [Help]

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 185: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

181:
182: PROCEDURE populateattributescolumn
183: IS
184: l_column_idx BINARY_INTEGER;
185: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
186: BEGIN
187: g_lot_attributes_tbl ( 1 ).column_name := 'VENDOR_ID';
188: g_lot_attributes_tbl ( 1 ).column_type := 'NUMBER';
189: g_lot_attributes_tbl ( 2 ).column_name := 'GRADE_CODE';

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

448: description
449: FROM mtl_transaction_lots_temp
450: WHERE lot_number = p_lot_number
451: AND transaction_temp_id = p_trx_temp_id;
452: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
453: BEGIN
454: IF (l_debug = 1) THEN
455: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside InsertLot API' , 'INV_LOT_API_PUB');
456: END IF;

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

1679: vendor_name
1680: FROM mtl_transaction_lots_temp
1681: WHERE lot_number = p_lot_number
1682: AND transaction_temp_id = p_trx_temp_id;
1683: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1684: BEGIN
1685: -- Standard Start of API savepoint
1686: SAVEPOINT apiinsertlot_apipub;
1687:

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

2452: SELECT lot_number
2453: FROM mtl_material_transactions_temp lot
2454: WHERE lot_number = p_auto_lot_number
2455: AND inventory_item_id <> p_inventory_item_id;
2456: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2457: BEGIN
2458: IF l_lot_uniqueness IS NULL
2459: THEN
2460: BEGIN

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

2548: p_lot_prefix IN VARCHAR2 -- Bug# 7298723
2549: )
2550: IS
2551: PRAGMA AUTONOMOUS_TRANSACTION;
2552: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2553: l_update_count number := 0; -- Bug# 7298723
2554:
2555: /* Added for bug 8428348 */
2556: l_return_status VARCHAR2(1) := NULL;

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

2753: l_unique_lot BOOLEAN := FALSE;
2754: l_lotcount NUMBER;
2755: l_api_version CONSTANT NUMBER := 1.0;
2756: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
2757: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2758: -- The following 2 variables are added as a part of bug fix for: Bug #3330855
2759: v_org_code VARCHAR2 ( 3 );
2760: v_item_name VARCHAR2 ( 80 );
2761:

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

3661: SELECT lot_number
3662: FROM mtl_material_transactions_temp lot
3663: WHERE lot_number = p_auto_lot_number
3664: AND inventory_item_id = p_inventory_item_id;
3665: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3666: BEGIN
3667: IF l_lot_uniqueness IS NULL
3668: THEN
3669: BEGIN

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

3779: )
3780: IS
3781: temp_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3782: v_found BOOLEAN := FALSE;
3783: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3784: BEGIN
3785: IF (l_debug = 1) THEN
3786: print_debug ('Getting the WMS and NON WMS LOT Attributes From the Source LOT',4);
3787: END IF;

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

4075: errors_received EXCEPTION;
4076: error_msg VARCHAR2(5000);
4077: s NUMBER;
4078: e NUMBER;
4079: --g_debug NUMBER := 1 ;--NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
4080: l_null_char_val VARCHAR2(1000);
4081: l_null_num_val NUMBER;
4082: l_null_date_val DATE;
4083: l_global_nsegments NUMBER := 0;

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

10171: l_unique_lot BOOLEAN := FALSE;
10172: l_lotcount NUMBER;
10173: l_api_version CONSTANT NUMBER := 1.0;
10174: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
10175: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10176: v_org_code VARCHAR2 ( 3 );
10177: v_item_name VARCHAR2 ( 40 );
10178: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;
10179: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;

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

10705:
10706: BEGIN
10707:
10708: IF (l_debug is null) THEN
10709: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10710: END IF;
10711:
10712: IF (l_debug = 1) THEN
10713: inv_log_util.trace('validate_quantities: Start ', g_pkg_name, 9);