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_PHY_INV_LOVS dependencies on FND_PROFILE

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

7: g_employee_id NUMBER :=0; --Bug 11881386
8:
9: PROCEDURE print_debug(p_err_msg VARCHAR2)
10: IS
11: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12: BEGIN
13:
14: IF (l_debug = 1) THEN
15: inv_mobile_helper_functions.tracelog

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

39: p_organization_id IN NUMBER)
40:
41: IS
42:
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44: BEGIN
45: OPEN x_phy_inv_lov FOR
46: SELECT physical_inventory_name,
47: physical_inventory_id,

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

98: IS
99: l_all_sub_flag NUMBER;
100: l_serial_sub VARCHAR2(10);
101:
102: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
103: BEGIN
104: IF (l_debug = 1) THEN
105: print_debug('***Calling get_serial_count_number***');
106: END IF;

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

262: l_current_number NUMBER;
263: l_adjustment_id NUMBER;
264: l_cost_group_id NUMBER;
265:
266: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
267: BEGIN
268: IF (l_debug = 1) THEN
269: print_debug('***Calling process_tag with the following parameters***');
270: print_debug('p_physical_inventory_id: ---> ' || p_physical_inventory_id);

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

807: l_padded_length NUMBER;
808: l_item_standard_uom VARCHAR2(3);
809: l_employee_id NUMBER;
810:
811: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
812: BEGIN
813: IF (l_debug = 1) THEN
814: print_debug('***insert_row***');
815: END IF;

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

1084: l_msg_data VARCHAR2(300);
1085: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
1086: l_employee_id NUMBER;
1087:
1088: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1089: BEGIN
1090: IF (l_debug = 1) THEN
1091: print_debug('***update_row***');
1092: END IF;

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

1236: l_return_status VARCHAR2(3000);
1237: l_msg_count NUMBER;
1238: l_msg_data VARCHAR2(3000);
1239:
1240: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1241: BEGIN
1242: IF (l_debug = 1) THEN
1243: print_debug('***update_adjustment***');
1244: END IF;

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

1401: l_approval_status NUMBER:= -1;
1402: l_lot_expiration_date Date; /* Added by 8199582 */
1403: l_process_enabled_flag VARCHAR2(1);
1404:
1405: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1406: BEGIN
1407: IF (l_debug = 1) THEN
1408: print_debug('***find_existing_adjustment***');
1409: END IF;

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

1691: SELECT *
1692: FROM MTL_SERIAL_NUMBERS
1693: WHERE lpn_id = l_current_lpn;
1694:
1695: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1696: BEGIN
1697: IF (l_debug = 1) THEN
1698: print_debug('***process_summary***');
1699: END IF;

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

1804: p_item_id IN NUMBER,
1805: x_status OUT NOCOPY NUMBER
1806: )
1807: IS
1808: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1809: BEGIN
1810: IF (l_debug = 1) THEN
1811: print_debug('***unmark_serials***');
1812: END IF;

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

1882: p_serial_number_type IN NUMBER
1883: )
1884: IS
1885: l_valid_serial NUMBER := 0;
1886: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1887: BEGIN
1888: x_status := 0;
1889: IF (l_debug = 1) THEN
1890: print_debug('Start Validating the serial for the current status');

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

2028: )
2029: IS
2030: l_adjustment_id NUMBER;
2031: l_new_tag VARCHAR2(1);
2032: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2033: /* Added below variables for bug 15926209, start */
2034: l_subinv MTL_PHYSICAL_ADJUSTMENTS.SUBINVENTORY_NAME%TYPE;
2035: l_locator NUMBER;
2036: l_update BOOLEAN;

Line 2309: l_debug NUMBER := Nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2305: l_transaction_temp_id NUMBER;
2306: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;
2307: l_uom_code mtl_system_items.primary_uom_code%TYPE;
2308: l_sec_uom_code mtl_system_items.secondary_uom_code%TYPE;
2309: l_debug NUMBER := Nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2310: l_proc_name VARCHAR2(20) := 'PHY_INV_SUB_XFER ';
2311:
2312: l_period_id NUMBER;
2313: l_open_past_period BOOLEAN := FALSE;

Line 2360: IF (fnd_profile.defined('TRANSACTION_DATE')) THEN

2356: mydebug('p_txn_date--------------------->>'||p_txn_date);
2357:
2358: x_proc_status := 0;
2359:
2360: IF (fnd_profile.defined('TRANSACTION_DATE')) THEN
2361: l_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));
2362:
2363: -- Profile value of:
2364: -- 1 = Any open period

Line 2361: l_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));

2357:
2358: x_proc_status := 0;
2359:
2360: IF (fnd_profile.defined('TRANSACTION_DATE')) THEN
2361: l_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));
2362:
2363: -- Profile value of:
2364: -- 1 = Any open period
2365: -- 2 = No past date