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

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

53: p_cycle_count IN VARCHAR2,
54: p_organization_id IN NUMBER
55: )
56: IS
57: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
58: BEGIN
59: OPEN x_cyc_lov FOR
60: SELECT cycle_count_header_name,
61: cycle_count_header_id,

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

101: PROCEDURE print_debug (
102: p_err_msg VARCHAR2
103: )
104: IS
105: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
106: BEGIN
107: IF ( l_debug = 1 ) THEN
108: inv_mobile_helper_functions.tracelog ( p_err_msg => p_err_msg,
109: p_module => 'INV_CYC_LOVS',

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

124: )
125: IS
126: PRAGMA AUTONOMOUS_TRANSACTION;
127: l_count_list_sequence NUMBER;
128: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
129: BEGIN
130: -- Calculate the next value for the count list sequence
131: SELECT NVL ( MAX ( count_list_sequence ), 0 ) + 1
132: INTO l_count_list_sequence

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

254: l_cost_group_id NUMBER;
255: l_dispatched_count NUMBER;
256: l_dispatched_task NUMBER;
257: e_Task_Dispatched EXCEPTION;
258: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
259:
260: /* Bug 4891916-Added the following local variables for the call to label printing */
261: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);
262: l_business_flow_code NUMBER := 8;

Line 261: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);

257: e_Task_Dispatched EXCEPTION;
258: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
259:
260: /* Bug 4891916-Added the following local variables for the call to label printing */
261: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);
262: l_business_flow_code NUMBER := 8;
263: l_label_status VARCHAR2 ( 300 ) := NULL;
264: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
265: l_msg_count NUMBER;

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

834: p_cost_group_id IN NUMBER )
835:
836: IS
837: l_cycle_count_entry_id NUMBER;
838: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
839:
840: CURSOR cc_entry_cursor
841: IS
842: SELECT cycle_count_entry_id

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

931: l_return_status VARCHAR2 ( 300 );
932: l_msg_count NUMBER;
933: l_msg_data VARCHAR2 ( 300 );
934: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
935: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
936: BEGIN
937: IF ( l_debug = 1 ) THEN
938: print_debug ( '***insert_row***' );
939: END IF;

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

1163: l_return_status VARCHAR2 ( 300 );
1164: l_msg_count NUMBER;
1165: l_msg_data VARCHAR2 ( 300 );
1166: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
1167: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1168: BEGIN
1169: IF ( l_debug = 1 ) THEN
1170: print_debug ( '***update_row***' );
1171: END IF;

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

1305: END update_row;
1306:
1307: PROCEDURE current_to_prior
1308: IS
1309: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1310: BEGIN
1311: IF ( l_debug = 1 ) THEN
1312: print_debug ( '***current_to_prior***' );
1313: END IF;

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

1330: END current_to_prior;
1331:
1332: PROCEDURE current_to_first
1333: IS
1334: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1335: BEGIN
1336: IF ( l_debug = 1 ) THEN
1337: print_debug ( '***current_to_first***' );
1338: END IF;

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

1363: p_primary_uom_quantity IN NUMBER,
1364: p_sec_system_quantity IN NUMBER DEFAULT NULL -- nsinghi Bug#6052831 Added this parameter.
1365: )
1366: IS
1367: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1368: BEGIN
1369: IF ( l_debug = 1 ) THEN
1370: print_debug ( '***entry_to_current***' );
1371: END IF;

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

1388: PROCEDURE zero_count_logic
1389: IS
1390: l_primary_uom_quantity NUMBER;
1391: l_primary_uom VARCHAR2 ( 3 );
1392: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1393: BEGIN
1394: IF ( l_debug = 1 ) THEN
1395: print_debug ( '***zero_count_logic***' );
1396: END IF;

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

1457: l_inventory_item_id NUMBER;
1458: l_organization_id NUMBER;
1459: l_cycle_count_header_id NUMBER;
1460: l_abc_class_id NUMBER;
1461: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1462: BEGIN
1463: IF ( l_debug = 1 ) THEN
1464: print_debug ( '***get_tolerances***' );
1465: END IF;

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

1605: p_cost_tolerance_positive IN NUMBER,
1606: p_cost_tolerance_negative IN NUMBER
1607: )
1608: IS
1609: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1610: BEGIN
1611: IF ( l_debug = 1 ) THEN
1612: print_debug ( '***recount_logic***' );
1613: END IF;

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

1648: l_container_enabled_flag NUMBER;
1649: l_container_adjustment_option NUMBER;
1650: l_container_discrepancy_option NUMBER;
1651: l_primary_uom VARCHAR2 ( 3 );
1652: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1653: BEGIN
1654: IF ( l_debug = 1 ) THEN
1655: print_debug ( '***tolerance_logic***' );
1656: END IF;

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

1878: END tolerance_logic;
1879:
1880: PROCEDURE valids
1881: IS
1882: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1883: BEGIN
1884: IF ( l_debug = 1 ) THEN
1885: print_debug ( '***valids***' );
1886: END IF;

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

1894: l_parent_lpn_id NUMBER;
1895: l_container_enabled_flag NUMBER;
1896: l_container_adjustment_option NUMBER;
1897: l_container_discrepancy_option NUMBER;
1898: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1899: BEGIN
1900: IF ( l_debug = 1 ) THEN
1901: print_debug ( '***in_tolerance***' );
1902: END IF;

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

1949: l_container_enabled_flag NUMBER;
1950: l_container_adjustment_option NUMBER;
1951: l_container_discrepancy_option NUMBER;
1952: l_days_until_late NUMBER;
1953: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1954:
1955: l_serial_count_option NUMBER; --Bug 5186993
1956: l_serial_number_ctrl_code NUMBER; --Bug 5186993
1957:

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

2039: END out_tolerance;
2040:
2041: PROCEDURE no_adj_req
2042: IS
2043: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2044: BEGIN
2045: IF ( l_debug = 1 ) THEN
2046: print_debug ( '***no_adj_req***' );
2047: END IF;

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

2080: l_primary_uom VARCHAR2 ( 3 );
2081: l_adjustment_quantity NUMBER := 0;
2082: l_sec_adjustment_quantity NUMBER := 0; -- nsinghi Bug#6052831
2083: l_adjustment_value NUMBER := 0;
2084: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2085: BEGIN
2086: IF ( l_debug = 1 ) THEN
2087: print_debug ( '***pre_insert***' );
2088: END IF;

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

2398: l_system_quantity NUMBER;
2399: l_sec_system_quantity NUMBER; -- nsinghi bug#6052831
2400: l_primary_uom_quantity NUMBER;
2401: l_primary_uom VARCHAR2 ( 3 );
2402: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2403:
2404:
2405: /* Bug 4495880 -Added the local variables for the lpn details from wlpn*/
2406:

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

2879: l_msg_count NUMBER;
2880: l_msg_data VARCHAR2 ( 2000 );
2881: l_parent_lpn_id NUMBER;
2882: l_neg_inv_rcpt_code NUMBER;
2883: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2884: l_allow_neg_onhand_prof_val NUMBER;-- 4870490
2885: l_sec_uom VARCHAR2(3) := g_count_secondary_uom ; -- INVCONV,NSRIVAST
2886: l_sec_qty NUMBER := g_count_secondary_quantity ; -- INVCONV,NSRIVAST
2887: -- nsinghi bug#6052831

Line 2944: l_allow_neg_onhand_prof_val := NVL(FND_PROFILE.VALUE('INV_ALLOW_CC_TXNS_ONHAND_NEG'),2);

2940: FROM mtl_parameters
2941: WHERE organization_id = l_org_id;
2942:
2943: --4870490
2944: l_allow_neg_onhand_prof_val := NVL(FND_PROFILE.VALUE('INV_ALLOW_CC_TXNS_ONHAND_NEG'),2);
2945:
2946: print_debug ( 'l_neg_inv_rcpt_mode '||l_neg_inv_rcpt_code );
2947: print_debug ( 'l_allow_neg_onhand_prof_val '||l_allow_neg_onhand_prof_val );
2948:

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

3786: l_return_status VARCHAR2 ( 1 );
3787: l_msg_count NUMBER;
3788: l_msg_data VARCHAR2 ( 240 );
3789: lmsg VARCHAR2 ( 2000 );
3790: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
3791:
3792: l_lpn_subinv VARCHAR2 ( 10 ); --Bug 6401621
3793: l_lpn_locator_id NUMBER; --Bug 6401621
3794: BEGIN

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

3880: l_lot VARCHAR2 ( 30 ) := g_cc_entry.lot_number;
3881: l_org_id NUMBER := g_cc_entry.organization_id;
3882: l_cc_header_id NUMBER := g_cc_entry.cycle_count_header_id;
3883: l_cc_serial_number VARCHAR2 ( 30 ) := g_cc_entry.serial_number;
3884: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
3885: l_lpn_id NUMBER := g_cc_entry.parent_lpn_id;
3886:
3887: BEGIN
3888: IF ( l_debug = 1 ) THEN

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

3951: -- Variables needed for calling the label printing API
3952: l_label_status VARCHAR2 ( 300 ) := NULL;
3953: l_business_flow_code NUMBER := 8;
3954: l_temp_count NUMBER;
3955: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
3956: BEGIN
3957: IF ( l_debug = 1 ) THEN
3958: print_debug ( '***post_commit***' );
3959: print_debug ( 'Commit status flag: => ' || g_commit_status_flag );

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

4219: x_msg_count NUMBER := 0;
4220: x_msg_data VARCHAR2 ( 240 );
4221: l_serial_number_control_code NUMBER;
4222: l_serial_count_option NUMBER;
4223: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4224: -- Bug 4886188 -Added the local variables for the lpn details from wlpn
4225:
4226: l_lpn_subinv VARCHAR2(10) ;
4227: l_lpn_locator_id NUMBER ;

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

4554: x_msg_count NUMBER := 0;
4555: x_msg_data VARCHAR2 ( 240 );
4556: l_serial_number_control_code NUMBER;
4557: l_serial_count_option NUMBER;
4558: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4559: /* Bug 4886188 -Added the local variables for the lpn details from wlpn*/
4560:
4561: l_lpn_subinv VARCHAR2(10) ;
4562: l_lpn_locator_id NUMBER ;

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

4875: l_conversion_qty NUMBER;
4876: l_from_uom VARCHAR2 ( 3 ) := g_count_uom;
4877: l_to_uom VARCHAR2 ( 3 );
4878: l_adj_qty NUMBER;
4879: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4880: BEGIN
4881: IF ( l_debug = 1 ) THEN
4882: print_debug ( '***value_variance***' );
4883: END IF;

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

4933: IS
4934: x_return_status VARCHAR2 ( 1 );
4935: x_msg_count NUMBER;
4936: x_msg_data VARCHAR2 ( 240 );
4937: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4938: BEGIN
4939: IF ( l_debug = 1 ) THEN
4940: print_debug ( '***wms_is_installed***' );
4941: END IF;

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

4960: IS
4961: l_item_cost NUMBER;
4962: l_locator_id NUMBER := in_locator_id;
4963: l_cost_group_id NUMBER := g_cc_entry.cost_group_id;
4964: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4965: BEGIN
4966: IF ( l_debug = 1 ) THEN
4967: print_debug ( '***get_item_cost***' );
4968: END IF;

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

5062: RETURN NUMBER
5063: IS
5064: l_serial_count NUMBER;
5065: l_lot_control_code NUMBER;
5066: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
5067: BEGIN
5068: IF p_organization_id IS NOT NULL
5069: AND p_serial_number IS NOT NULL
5070: AND p_inventory_item_id IS NOT NULL THEN

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

5169: l_item_id NUMBER := g_cc_entry.inventory_item_id;
5170: l_org_id NUMBER := g_cc_entry.organization_id;
5171: l_system_quantity NUMBER;
5172: l_serial_number_control_code NUMBER;
5173: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
5174: BEGIN
5175: IF ( l_debug = 1 ) THEN
5176: print_debug ( '***is_serial_entered***' );
5177: END IF;

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

5288: l_approval_tolerance_positive NUMBER;
5289: l_approval_tolerance_negative NUMBER;
5290: l_cost_tolerance_positive NUMBER;
5291: l_cost_tolerance_negative NUMBER;
5292: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
5293:
5294: --Bug 5186993
5295: l_automatic_recount_flag NUMBER;
5296: l_maximum_auto_recounts NUMBER;

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

5535: l_approval_tolerance_positive NUMBER;
5536: l_approval_tolerance_negative NUMBER;
5537: l_cost_tolerance_positive NUMBER;
5538: l_cost_tolerance_negative NUMBER;
5539: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
5540: --Bug 5186993
5541: l_automatic_recount_flag NUMBER;
5542: l_maximum_auto_recounts NUMBER;
5543: l_days_until_late NUMBER;

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

6081: l_prefix VARCHAR2 ( 240 );
6082: -- Variables used for serial discrepancies
6083: l_msn_subinv VARCHAR2 ( 10 );
6084: l_msn_locator_id NUMBER;
6085: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
6086: BEGIN
6087: IF ( l_debug = 1 ) THEN
6088: print_debug ( '***check_serial_number_location***' );
6089: END IF;

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

6386: l_msg_count NUMBER;
6387: l_msg_data VARCHAR2 ( 2000 );
6388: l_parent_lpn_id NUMBER;
6389: l_neg_inv_rcpt_code NUMBER;
6390: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
6391: l_allow_neg_onhand_prof_val NUMBER; -- 4870490
6392: BEGIN
6393: IF ( l_debug = 1 ) THEN
6394: print_debug ( '***perform_serial_adj_txn***' );

Line 6497: l_allow_neg_onhand_prof_val := NVL(FND_PROFILE.VALUE('INV_ALLOW_CC_TXNS_ONHAND_NEG'),2);

6493: FROM mtl_parameters
6494: WHERE organization_id = l_org_id;
6495:
6496: --4870490
6497: l_allow_neg_onhand_prof_val := NVL(FND_PROFILE.VALUE('INV_ALLOW_CC_TXNS_ONHAND_NEG'),2);
6498:
6499:
6500: -- Bug number 4469742 commented the IF clause here AS per the discussion WITH the PM
6501: -- for the complete opinion from the PM please refer to the update in the bug

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

6901: PROCEDURE count_entry_status_code
6902: IS
6903: l_count_esc NUMBER := g_count_entry_status_code;
6904: l_serial_esc NUMBER := g_serial_entry_status_code;
6905: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
6906: BEGIN
6907: IF ( l_debug = 1 ) THEN
6908: print_debug ( '***count_entry_status_code***' );
6909: print_debug ( 'Count Entry Status: ' || l_count_esc );

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

6921: END count_entry_status_code;
6922:
6923: PROCEDURE update_serial_row
6924: IS
6925: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
6926: BEGIN
6927: IF ( l_debug = 1 ) THEN
6928: print_debug ( '***update_serial_row***' );
6929: END IF;

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

6967: g7 NUMBER;
6968: success NUMBER := 1;
6969: l_serial_number_ctrl_code NUMBER;
6970: l_serial_count_option NUMBER;
6971: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
6972: BEGIN
6973: IF ( l_debug = 1 ) THEN
6974: print_debug ( '***mark***' );
6975: END IF;

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

7072: l_serial_number_ctrl_code NUMBER;
7073: l_serial_count_option NUMBER;
7074: l_current_serial VARCHAR2 ( 30 );
7075: l_current_item NUMBER;
7076: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7077: BEGIN
7078: IF ( l_debug = 1 ) THEN
7079: print_debug ( '***unmark***' );
7080: END IF;

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

7167: v_user_id NUMBER;
7168: v_login_id NUMBER;
7169: profile_name VARCHAR2 ( 60 );
7170: profile_val VARCHAR2 ( 80 );
7171: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7172: BEGIN
7173: IF ( l_debug = 1 ) THEN
7174: print_debug ( '***get_profiles***' );
7175: END IF;

Line 7181: profile_val := FND_PROFILE.VALUE ( profile_name );

7177: v_login_id := fnd_global.login_id;
7178: g_login_id := v_login_id;
7179: -- Get profile option for transaction date validation
7180: profile_name := 'TRANSACTION_PROCESS_MODE';
7181: profile_val := FND_PROFILE.VALUE ( profile_name );
7182:
7183: IF ( profile_val = 4 ) THEN
7184: -- Get form level profile
7185: profile_name := 'CYCLE_COUNT_ENTRIES_TXN';

Line 7186: profile_val := FND_PROFILE.VALUE ( profile_name );

7182:
7183: IF ( profile_val = 4 ) THEN
7184: -- Get form level profile
7185: profile_name := 'CYCLE_COUNT_ENTRIES_TXN';
7186: profile_val := FND_PROFILE.VALUE ( profile_name );
7187: END IF;
7188:
7189: g_txn_proc_mode := profile_val;
7190: END get_profiles;

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

7196: l_employee_id NUMBER;
7197: l_employee_full_name VARCHAR2 ( 240 );
7198: l_user_id NUMBER := g_user_id;
7199: l_org_id NUMBER := p_organization_id;
7200: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7201: BEGIN
7202: IF ( l_debug = 1 ) THEN
7203: print_debug ( '***get_employee***' );
7204: END IF;

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

7284:
7285:
7286: l_serial_count_option NUMBER;
7287: l_temp_count NUMBER;
7288: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7289: l_lpn_loaded_qty NUMBER; --Bug#4891370
7290: l_cnt_qty NUMBER; --Added for bug#4886188
7291: l_lpn_context NUMBER; --Added for bug#4886188
7292:

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

7553: L_from_length NUMBER;
7554: L_to_length NUMBER;
7555: L_f_ser_num VARCHAR2 ( 30 );
7556: L_t_ser_num VARCHAR2 ( 30 );
7557: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7558: BEGIN
7559: IF ( l_debug = 1 ) THEN
7560: print_debug ( '***inv_serial_info***' );
7561: END IF;

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

7695: x_out OUT NOCOPY NUMBER
7696: )
7697: IS
7698: l_default_cost_group_id NUMBER;
7699: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7700: BEGIN
7701: IF ( l_debug = 1 ) THEN
7702: print_debug ( '***get_default_cost_group_id***' );
7703: END IF;

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

7737: x_out OUT NOCOPY NUMBER
7738: )
7739: IS
7740: l_cost_group_id NUMBER;
7741: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7742: BEGIN
7743: IF ( l_debug = 1 ) THEN
7744: print_debug ( '***get_cost_group_id***' );
7745: END IF;

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

7828: l_cost_tolerance_negative NUMBER;
7829: l_number_of_counts NUMBER;
7830: l_unit_status NUMBER;
7831: l_num_counts NUMBER := g_cc_entry.number_of_counts;
7832: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7833: --Bug 5186993
7834: l_automatic_recount_flag NUMBER;
7835: l_maximum_auto_recounts NUMBER;
7836: l_days_until_late NUMBER;

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

8163: l_system_quantity NUMBER;
8164: l_adjustment_value NUMBER;
8165: l_approval_option_code NUMBER;
8166: l_item_cost NUMBER;
8167: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8168: BEGIN
8169: IF ( l_debug = 1 ) THEN
8170: print_debug ( '***serial_tolerance_logic***' );
8171: END IF;

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

8269:
8270: PROCEDURE get_final_count_info
8271: IS
8272: l_entry_status_code NUMBER;
8273: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8274: BEGIN
8275: IF ( l_debug = 1 ) THEN
8276: print_debug ( '***get_final_count_info***' );
8277: END IF;

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

8289: p_cycle_count_header_id IN NUMBER,
8290: x_count OUT NOCOPY NUMBER
8291: )
8292: IS
8293: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8294: BEGIN
8295: IF ( l_debug = 1 ) THEN
8296: print_debug ( '***get_scheduled_entry***' );
8297: END IF;

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

8326: x_msg_count OUT NOCOPY NUMBER,
8327: x_msg_data OUT NOCOPY VARCHAR2
8328: )
8329: IS
8330: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8331: BEGIN
8332: -- Initialize the return status
8333: x_return_status := FND_API.G_RET_STS_SUCCESS;
8334:

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

8430: l_serial_num_length NUMBER;
8431: l_prefix_length NUMBER;
8432: l_progress VARCHAR2 ( 10 );
8433: l_success NUMBER;
8434: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8435: BEGIN
8436: IF ( l_debug = 1 ) THEN
8437: print_debug ( 'Enter update_serial_status: 10:'
8438: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )

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

8613: IS
8614: l_object_id NUMBER;
8615: l_success NUMBER;
8616: l_progress VARCHAR2 ( 10 );
8617: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8618: BEGIN
8619: IF ( l_debug = 1 ) THEN
8620: print_debug ( 'Enter insert_range_serial: 10:'
8621: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )

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

8795: l_serial_number_control_code NUMBER;
8796: l_progress VARCHAR2 ( 10 );
8797: l_converted_quantity NUMBER;
8798: l_loaded_sys_qty NUMBER; -- bug 2640378
8799: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8800:
8801: /* Bug 4886188 -Added the local variables for the lpn details from wlpn*/
8802: l_lpn_subinv VARCHAR2(10) ;
8803: l_lpn_locator_id NUMBER ;

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

9064: FROM wms_dispatchable_tasks_v
9065: WHERE wms_task_type_id = 3
9066: AND task_id = wdt.transaction_temp_id );
9067:
9068: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
9069: BEGIN
9070: IF ( l_debug = 1 ) THEN
9071: print_debug ( '***Calling clean_up_tasks***' );
9072: END IF;