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

58: p_cycle_count IN VARCHAR2,
59: p_organization_id IN NUMBER
60: )
61: IS
62: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
63: BEGIN
64: OPEN x_cyc_lov FOR
65: SELECT cycle_count_header_name,
66: cycle_count_header_id,

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

116: PROCEDURE print_debug (
117: p_err_msg VARCHAR2
118: )
119: IS
120: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
121: BEGIN
122: IF ( l_debug = 1 ) THEN
123: inv_mobile_helper_functions.tracelog ( p_err_msg => p_err_msg,
124: p_module => 'INV_CYC_LOVS',

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

139: )
140: IS
141: PRAGMA AUTONOMOUS_TRANSACTION;
142: l_count_list_sequence NUMBER;
143: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
144: BEGIN
145: -- Calculate the next value for the count list sequence
146: SELECT NVL ( MAX ( count_list_sequence ), 0 ) + 1
147: INTO l_count_list_sequence

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

269: l_cost_group_id NUMBER;
270: l_dispatched_count NUMBER;
271: l_dispatched_task NUMBER;
272: e_Task_Dispatched EXCEPTION;
273: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
274:
275: /* Bug 4891916-Added the following local variables for the call to label printing */
276: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);
277: l_business_flow_code NUMBER := 8;

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

272: e_Task_Dispatched EXCEPTION;
273: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
274:
275: /* Bug 4891916-Added the following local variables for the call to label printing */
276: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);
277: l_business_flow_code NUMBER := 8;
278: l_label_status VARCHAR2 ( 300 ) := NULL;
279: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
280: l_return_result NUMBER := 2; -- Bug 13992956

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

924: p_cost_group_id IN NUMBER )
925:
926: IS
927: l_cycle_count_entry_id NUMBER;
928: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
929:
930: CURSOR cc_entry_cursor
931: IS
932: SELECT cycle_count_entry_id

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

1021: l_return_status VARCHAR2 ( 300 );
1022: l_msg_count NUMBER;
1023: l_msg_data VARCHAR2 ( 300 );
1024: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
1025: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1026: l_current_quantity number; --10318308
1027: l_current_quantity_prim number; --10318308
1028: l_adjustment_quantity number; --10318308
1029: l_adjustment_quantity_prim number; --10318308

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

1357: l_return_status VARCHAR2 ( 300 );
1358: l_msg_count NUMBER;
1359: l_msg_data VARCHAR2 ( 300 );
1360: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
1361: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1362: --bug 10298222
1363: l_temp_cc_id NUMBER;
1364: BEGIN
1365: IF ( l_debug = 1 ) THEN

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

1517: END update_row;
1518:
1519: PROCEDURE current_to_prior
1520: IS
1521: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1522: -- added for bug 14843592 start
1523: l_system_quantity NUMBER;
1524: l_sec_system_quantity NUMBER;
1525: l_adjustment_quantity NUMBER;

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

1566: END current_to_prior;
1567:
1568: PROCEDURE current_to_first
1569: IS
1570: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1571: BEGIN
1572: IF ( l_debug = 1 ) THEN
1573: print_debug ( '***current_to_first***' );
1574: END IF;

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

1599: p_primary_uom_quantity IN NUMBER,
1600: p_sec_system_quantity IN NUMBER DEFAULT NULL -- nsinghi Bug#6052831 Added this parameter.
1601: )
1602: IS
1603: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1604: BEGIN
1605: IF ( l_debug = 1 ) THEN
1606: print_debug ( '***entry_to_current***' );
1607: END IF;

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

1624: PROCEDURE zero_count_logic
1625: IS
1626: l_primary_uom_quantity NUMBER;
1627: l_primary_uom VARCHAR2 ( 3 );
1628: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1629: BEGIN
1630: IF ( l_debug = 1 ) THEN
1631: print_debug ( '***zero_count_logic***' );
1632: END IF;

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

1693: l_inventory_item_id NUMBER;
1694: l_organization_id NUMBER;
1695: l_cycle_count_header_id NUMBER;
1696: l_abc_class_id NUMBER;
1697: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1698: BEGIN
1699: IF ( l_debug = 1 ) THEN
1700: print_debug ( '***get_tolerances***' );
1701: END IF;

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

1841: p_cost_tolerance_positive IN NUMBER,
1842: p_cost_tolerance_negative IN NUMBER
1843: )
1844: IS
1845: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1846: BEGIN
1847: IF ( l_debug = 1 ) THEN
1848: print_debug ( '***recount_logic***' );
1849: END IF;

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

1884: l_container_enabled_flag NUMBER;
1885: l_container_adjustment_option NUMBER;
1886: l_container_discrepancy_option NUMBER;
1887: l_primary_uom VARCHAR2 ( 3 );
1888: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1889: BEGIN
1890: IF ( l_debug = 1 ) THEN
1891: print_debug ( '***tolerance_logic***' );
1892: END IF;

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

2114: END tolerance_logic;
2115:
2116: PROCEDURE valids
2117: IS
2118: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2119: BEGIN
2120: IF ( l_debug = 1 ) THEN
2121: print_debug ( '***valids***' );
2122: END IF;

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

2130: l_parent_lpn_id NUMBER;
2131: l_container_enabled_flag NUMBER;
2132: l_container_adjustment_option NUMBER;
2133: l_container_discrepancy_option NUMBER;
2134: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2135: BEGIN
2136: IF ( l_debug = 1 ) THEN
2137: print_debug ( '***in_tolerance***' );
2138: END IF;

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

2185: l_container_enabled_flag NUMBER;
2186: l_container_adjustment_option NUMBER;
2187: l_container_discrepancy_option NUMBER;
2188: l_days_until_late NUMBER;
2189: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2190:
2191: l_serial_count_option NUMBER; --Bug 5186993
2192: l_serial_number_ctrl_code NUMBER; --Bug 5186993
2193:

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

2275: END out_tolerance;
2276:
2277: PROCEDURE no_adj_req
2278: IS
2279: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2280: BEGIN
2281: IF ( l_debug = 1 ) THEN
2282: print_debug ( '***no_adj_req***' );
2283: END IF;

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

2316: l_primary_uom VARCHAR2 ( 3 );
2317: l_adjustment_quantity NUMBER := 0;
2318: l_sec_adjustment_quantity NUMBER := 0; -- nsinghi Bug#6052831
2319: l_adjustment_value NUMBER := 0;
2320: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2321: BEGIN
2322: IF ( l_debug = 1 ) THEN
2323: print_debug ( '***pre_insert***' );
2324: END IF;

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

2645: l_system_quantity NUMBER;
2646: l_sec_system_quantity NUMBER; -- nsinghi bug#6052831
2647: l_primary_uom_quantity NUMBER;
2648: l_primary_uom VARCHAR2 ( 3 );
2649: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2650:
2651:
2652: /* Bug 4495880 -Added the local variables for the lpn details from wlpn*/
2653:

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

3128: l_msg_count NUMBER;
3129: l_msg_data VARCHAR2 ( 2000 );
3130: l_parent_lpn_id NUMBER;
3131: l_neg_inv_rcpt_code NUMBER;
3132: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
3133: l_allow_neg_onhand_prof_val NUMBER;-- 4870490
3134: l_sec_uom VARCHAR2(3) := g_count_secondary_uom ; -- INVCONV,NSRIVAST
3135: l_sec_qty NUMBER := g_count_secondary_quantity ; -- INVCONV,NSRIVAST
3136: -- nsinghi bug#6052831

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

3191: FROM mtl_parameters
3192: WHERE organization_id = l_org_id;
3193:
3194: --4870490
3195: l_allow_neg_onhand_prof_val := NVL(FND_PROFILE.VALUE('INV_ALLOW_CC_TXNS_ONHAND_NEG'),2);
3196:
3197: print_debug ( 'l_neg_inv_rcpt_mode '||l_neg_inv_rcpt_code );
3198: print_debug ( 'l_allow_neg_onhand_prof_val '||l_allow_neg_onhand_prof_val );
3199:

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

4099: l_return_status VARCHAR2 ( 1 );
4100: l_msg_count NUMBER;
4101: l_msg_data VARCHAR2 ( 240 );
4102: lmsg VARCHAR2 ( 2000 );
4103: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4104:
4105: l_lpn_subinv VARCHAR2 ( 10 ); --Bug 6401621
4106: l_lpn_locator_id NUMBER; --Bug 6401621
4107: BEGIN

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

4193: l_lot VARCHAR2 ( 80 ) := g_cc_entry.lot_number; --Bug 6120140 Increased lot size to 80
4194: l_org_id NUMBER := g_cc_entry.organization_id;
4195: l_cc_header_id NUMBER := g_cc_entry.cycle_count_header_id;
4196: l_cc_serial_number VARCHAR2 ( 30 ) := g_cc_entry.serial_number;
4197: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4198: l_lpn_id NUMBER := g_cc_entry.parent_lpn_id;
4199:
4200: BEGIN
4201: IF ( l_debug = 1 ) THEN

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

4264: -- Variables needed for calling the label printing API
4265: l_label_status VARCHAR2 ( 300 ) := NULL;
4266: l_business_flow_code NUMBER := 8;
4267: l_temp_count NUMBER;
4268: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4269: BEGIN
4270: IF ( l_debug = 1 ) THEN
4271: print_debug ( '***post_commit***' );
4272: print_debug ( 'Commit status flag: => ' || g_commit_status_flag );

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

4547: x_msg_count NUMBER := 0;
4548: x_msg_data VARCHAR2 ( 240 );
4549: l_serial_number_control_code NUMBER;
4550: l_serial_count_option NUMBER;
4551: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4552: /* Bug 4886188 -Added the local variables for the lpn details from wlpn*/
4553:
4554: l_lpn_subinv VARCHAR2(10) ;
4555: l_lpn_locator_id NUMBER ;

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

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

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

4943: IS
4944: x_return_status VARCHAR2 ( 1 );
4945: x_msg_count NUMBER;
4946: x_msg_data VARCHAR2 ( 240 );
4947: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4948: BEGIN
4949: IF ( l_debug = 1 ) THEN
4950: print_debug ( '***wms_is_installed***' );
4951: END IF;

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

4970: IS
4971: l_item_cost NUMBER;
4972: l_locator_id NUMBER := in_locator_id;
4973: l_cost_group_id NUMBER := g_cc_entry.cost_group_id;
4974: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
4975:
4976: --Begin Bug 9650524
4977: l_process_enabled_flag VARCHAR2(1) := 'N';
4978: l_result_code VARCHAR2(30);

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

5135: RETURN NUMBER
5136: IS
5137: l_serial_count NUMBER;
5138: l_lot_control_code NUMBER;
5139: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
5140: BEGIN
5141: IF p_organization_id IS NOT NULL
5142: AND p_serial_number IS NOT NULL
5143: AND p_inventory_item_id IS NOT NULL THEN

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

5268: l_item_id NUMBER := g_cc_entry.inventory_item_id;
5269: l_org_id NUMBER := g_cc_entry.organization_id;
5270: l_system_quantity NUMBER;
5271: l_serial_number_control_code NUMBER;
5272: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
5273: BEGIN
5274: IF ( l_debug = 1 ) THEN
5275: print_debug ( '***is_serial_entered***' );
5276: END IF;

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

5387: l_approval_tolerance_positive NUMBER;
5388: l_approval_tolerance_negative NUMBER;
5389: l_cost_tolerance_positive NUMBER;
5390: l_cost_tolerance_negative NUMBER;
5391: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
5392:
5393: --Bug 5186993
5394: l_automatic_recount_flag NUMBER;
5395: l_maximum_auto_recounts NUMBER;

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

5634: l_approval_tolerance_positive NUMBER;
5635: l_approval_tolerance_negative NUMBER;
5636: l_cost_tolerance_positive NUMBER;
5637: l_cost_tolerance_negative NUMBER;
5638: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
5639: --Bug 5186993
5640: l_automatic_recount_flag NUMBER;
5641: l_maximum_auto_recounts NUMBER;
5642: l_days_until_late NUMBER;

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

6187: l_prefix VARCHAR2 ( 240 );
6188: -- Variables used for serial discrepancies
6189: l_msn_subinv VARCHAR2 ( 10 );
6190: l_msn_locator_id NUMBER;
6191: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
6192: BEGIN
6193: IF ( l_debug = 1 ) THEN
6194: print_debug ( '***check_serial_number_location***' );
6195: END IF;

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

6492: l_msg_count NUMBER;
6493: l_msg_data VARCHAR2 ( 2000 );
6494: l_parent_lpn_id NUMBER;
6495: l_neg_inv_rcpt_code NUMBER;
6496: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
6497: l_allow_neg_onhand_prof_val NUMBER; -- 4870490
6498: BEGIN
6499: IF ( l_debug = 1 ) THEN
6500: print_debug ( '***perform_serial_adj_txn***' );

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

6599: FROM mtl_parameters
6600: WHERE organization_id = l_org_id;
6601:
6602: --4870490
6603: l_allow_neg_onhand_prof_val := NVL(FND_PROFILE.VALUE('INV_ALLOW_CC_TXNS_ONHAND_NEG'),2);
6604:
6605:
6606: -- Bug number 4469742 commented the IF clause here AS per the discussion WITH the PM
6607: -- for the complete opinion from the PM please refer to the update in the bug

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

7010: PROCEDURE count_entry_status_code
7011: IS
7012: l_count_esc NUMBER := g_count_entry_status_code;
7013: l_serial_esc NUMBER := g_serial_entry_status_code;
7014: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7015: BEGIN
7016: IF ( l_debug = 1 ) THEN
7017: print_debug ( '***count_entry_status_code***' );
7018: print_debug ( 'Count Entry Status: ' || l_count_esc );

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

7030: END count_entry_status_code;
7031:
7032: PROCEDURE update_serial_row
7033: IS
7034: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7035: BEGIN
7036: IF ( l_debug = 1 ) THEN
7037: print_debug ( '***update_serial_row***' );
7038: END IF;

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

7076: g7 NUMBER;
7077: success NUMBER := 1;
7078: l_serial_number_ctrl_code NUMBER;
7079: l_serial_count_option NUMBER;
7080: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7081: BEGIN
7082: IF ( l_debug = 1 ) THEN
7083: print_debug ( '***mark***' );
7084: END IF;

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

7181: l_serial_number_ctrl_code NUMBER;
7182: l_serial_count_option NUMBER;
7183: l_current_serial VARCHAR2 ( 30 );
7184: l_current_item NUMBER;
7185: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7186: BEGIN
7187: IF ( l_debug = 1 ) THEN
7188: print_debug ( '***unmark***' );
7189: END IF;

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

7276: v_user_id NUMBER;
7277: v_login_id NUMBER;
7278: profile_name VARCHAR2 ( 60 );
7279: profile_val VARCHAR2 ( 80 );
7280: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7281: BEGIN
7282: IF ( l_debug = 1 ) THEN
7283: print_debug ( '***get_profiles***' );
7284: END IF;

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

7286: v_login_id := fnd_global.login_id;
7287: g_login_id := v_login_id;
7288: -- Get profile option for transaction date validation
7289: profile_name := 'TRANSACTION_PROCESS_MODE';
7290: profile_val := FND_PROFILE.VALUE ( profile_name );
7291:
7292: IF ( profile_val = 4 ) THEN
7293: -- Get form level profile
7294: profile_name := 'CYCLE_COUNT_ENTRIES_TXN';

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

7291:
7292: IF ( profile_val = 4 ) THEN
7293: -- Get form level profile
7294: profile_name := 'CYCLE_COUNT_ENTRIES_TXN';
7295: profile_val := FND_PROFILE.VALUE ( profile_name );
7296: END IF;
7297:
7298: g_txn_proc_mode := profile_val;
7299: END get_profiles;

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

7305: l_employee_id NUMBER;
7306: l_employee_full_name VARCHAR2 ( 240 );
7307: l_user_id NUMBER := g_user_id;
7308: l_org_id NUMBER := p_organization_id;
7309: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7310: BEGIN
7311: IF ( l_debug = 1 ) THEN
7312: print_debug ( '***get_employee***' );
7313: END IF;

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

7400:
7401:
7402: l_serial_count_option NUMBER;
7403: l_temp_count NUMBER;
7404: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7405: l_lpn_loaded_qty NUMBER; --Bug#4891370
7406: l_cnt_qty NUMBER; --Added for bug#4886188
7407: l_lpn_context NUMBER; --Added for bug#4886188
7408:

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

7749: L_from_length NUMBER;
7750: L_to_length NUMBER;
7751: L_f_ser_num VARCHAR2 ( 30 );
7752: L_t_ser_num VARCHAR2 ( 30 );
7753: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7754: BEGIN
7755: IF ( l_debug = 1 ) THEN
7756: print_debug ( '***inv_serial_info***' );
7757: END IF;

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

7891: x_out OUT NOCOPY NUMBER
7892: )
7893: IS
7894: l_default_cost_group_id NUMBER;
7895: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7896: BEGIN
7897: IF ( l_debug = 1 ) THEN
7898: print_debug ( '***get_default_cost_group_id***' );
7899: END IF;

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

7933: x_out OUT NOCOPY NUMBER
7934: )
7935: IS
7936: l_cost_group_id NUMBER;
7937: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
7938: BEGIN
7939: IF ( l_debug = 1 ) THEN
7940: print_debug ( '***get_cost_group_id***' );
7941: END IF;

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

8024: l_cost_tolerance_negative NUMBER;
8025: l_number_of_counts NUMBER;
8026: l_unit_status NUMBER;
8027: l_num_counts NUMBER := g_cc_entry.number_of_counts;
8028: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8029: --Bug 5186993
8030: l_automatic_recount_flag NUMBER;
8031: l_maximum_auto_recounts NUMBER;
8032: l_days_until_late NUMBER;

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

8382: l_system_quantity NUMBER;
8383: l_adjustment_value NUMBER;
8384: l_approval_option_code NUMBER;
8385: l_item_cost NUMBER;
8386: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8387: BEGIN
8388: IF ( l_debug = 1 ) THEN
8389: print_debug ( '***serial_tolerance_logic***' );
8390: END IF;

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

8488:
8489: PROCEDURE get_final_count_info
8490: IS
8491: l_entry_status_code NUMBER;
8492: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8493: BEGIN
8494: IF ( l_debug = 1 ) THEN
8495: print_debug ( '***get_final_count_info***' );
8496: END IF;

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

8508: p_cycle_count_header_id IN NUMBER,
8509: x_count OUT NOCOPY NUMBER
8510: )
8511: IS
8512: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8513: BEGIN
8514: IF ( l_debug = 1 ) THEN
8515: print_debug ( '***get_scheduled_entry***' );
8516: END IF;

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

8545: x_msg_count OUT NOCOPY NUMBER,
8546: x_msg_data OUT NOCOPY VARCHAR2
8547: )
8548: IS
8549: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8550: BEGIN
8551: -- Initialize the return status
8552: x_return_status := FND_API.G_RET_STS_SUCCESS;
8553:

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

8649: l_serial_num_length NUMBER;
8650: l_prefix_length NUMBER;
8651: l_progress VARCHAR2 ( 10 );
8652: l_success NUMBER;
8653: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8654: BEGIN
8655: IF ( l_debug = 1 ) THEN
8656: print_debug ( 'Enter update_serial_status: 10:'
8657: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )

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

8832: IS
8833: l_object_id NUMBER;
8834: l_success NUMBER;
8835: l_progress VARCHAR2 ( 10 );
8836: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8837: BEGIN
8838: IF ( l_debug = 1 ) THEN
8839: print_debug ( 'Enter insert_range_serial: 10:'
8840: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )

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

9014: l_serial_number_control_code NUMBER;
9015: l_progress VARCHAR2 ( 10 );
9016: l_converted_quantity NUMBER;
9017: l_loaded_sys_qty NUMBER; -- bug 2640378
9018: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
9019:
9020: /* Bug 4886188 -Added the local variables for the lpn details from wlpn*/
9021: l_lpn_subinv VARCHAR2(10) ;
9022: l_lpn_locator_id NUMBER ;

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

9449: WHERE entry_status_code in (1,3)
9450: AND NVL(export_flag,2) = 2
9451: AND cycle_count_entry_id = wdt.transaction_temp_id );--bug 12614348
9452:
9453: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
9454: BEGIN
9455: IF ( l_debug = 1 ) THEN
9456: print_debug ( '***Calling clean_up_tasks***' );
9457: END IF;

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

9655:
9656: l_temp_exists VARCHAR2(1) := 'N';
9657: l_cc_id NUMBER;
9658: l_parent_lpn_id NUMBER;
9659: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9660: BEGIN
9661:
9662: x_result_out := 'S';
9663:

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

9879: IS
9880: l_status VARCHAR2(1);
9881: l_msgcnt NUMBER;
9882: l_msgdata VARCHAR2(240);
9883: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
9884: BEGIN
9885:
9886: IF ( l_debug = 1 ) THEN
9887: print_debug ( '***Inside call_pack_unpack_container ***' );

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

10347: l_sec_system_quantity NUMBER;
10348: l_count_present_qty NUMBER;
10349: l_lpn_subinventory WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;
10350: l_lpn_loc_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
10351: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
10352: BEGIN
10353: IF l_debug = 1 THEN
10354: print_debug('*** process_multiple_qty_only ***');
10355: END IF;