APPS.INV_PHY_INV_LOVS dependencies on FND_PROFILE

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

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_PHY_INV_LOVS';
6:
7: PROCEDURE print_debug(p_err_msg VARCHAR2)
8: IS
9: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10: BEGIN
11:
12: IF (l_debug = 1) THEN
13: inv_mobile_helper_functions.tracelog

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

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

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

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

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

236: l_current_number NUMBER;
237: l_adjustment_id NUMBER;
238: l_cost_group_id NUMBER;
239:
240: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
241: BEGIN
242: IF (l_debug = 1) THEN
243: print_debug('***Calling process_tag with the following parameters***');
244: print_debug('p_physical_inventory_id: ---> ' || p_physical_inventory_id);

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

697: l_padded_length NUMBER;
698: l_item_standard_uom VARCHAR2(3);
699: l_employee_id NUMBER;
700:
701: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
702: BEGIN
703: IF (l_debug = 1) THEN
704: print_debug('***insert_row***');
705: END IF;

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

938: l_msg_data VARCHAR2(300);
939: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
940: l_employee_id NUMBER;
941:
942: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
943: BEGIN
944: IF (l_debug = 1) THEN
945: print_debug('***update_row***');
946: END IF;

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

1073: l_return_status VARCHAR2(3000);
1074: l_msg_count NUMBER;
1075: l_msg_data VARCHAR2(3000);
1076:
1077: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1078: BEGIN
1079: IF (l_debug = 1) THEN
1080: print_debug('***update_adjustment***');
1081: END IF;

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

1226: l_msg_data VARCHAR2(300);
1227: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
1228: l_approval_status NUMBER:= -1;
1229:
1230: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1231: BEGIN
1232: IF (l_debug = 1) THEN
1233: print_debug('***find_existing_adjustment***');
1234: END IF;

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

1463: SELECT *
1464: FROM MTL_SERIAL_NUMBERS
1465: WHERE lpn_id = l_current_lpn;
1466:
1467: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1468: BEGIN
1469: IF (l_debug = 1) THEN
1470: print_debug('***process_summary***');
1471: END IF;

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

1574: p_item_id IN NUMBER,
1575: x_status OUT NOCOPY NUMBER
1576: )
1577: IS
1578: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1579: BEGIN
1580: IF (l_debug = 1) THEN
1581: print_debug('***unmark_serials***');
1582: END IF;

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

1652: p_serial_number_type IN NUMBER
1653: )
1654: IS
1655: l_valid_serial NUMBER := 0;
1656: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1657: BEGIN
1658: x_status := 0;
1659: IF (l_debug = 1) THEN
1660: print_debug('Start Validating the serial for the current status');