APPS.INV_UTILITIES dependencies on INV_UTILITIES

Line 1: PACKAGE BODY inv_utilities AS

1: PACKAGE BODY inv_utilities AS
2: /* $Header: INVUTILB.pls 120.6.12010000.5 2009/01/15 09:04:17 hjogleka ship $ */
3: PROCEDURE do_sql(p_sql_stmt IN VARCHAR2) IS
4: cursor_id INTEGER;
5: return_val INTEGER;

Line 153: inv_log_util.TRACE('max batch: ' || l_max_batch, 'INV_UTILITIES', 9);

149:
150: l_max_batch := TO_NUMBER(fnd_profile.VALUE('INV_PICK_SLIP_BATCH_SIZE'));
151:
152: IF (l_debug = 1) THEN
153: inv_log_util.TRACE('max batch: ' || l_max_batch, 'INV_UTILITIES', 9);
154: END IF;
155:
156: IF l_max_batch IS NULL
157: OR l_max_batch <= 0 THEN

Line 161: inv_log_util.TRACE('using default batch size', 'INV_UTILITIES', 9);

157: OR l_max_batch <= 0 THEN
158: l_max_batch := 20;
159:
160: IF (l_debug = 1) THEN
161: inv_log_util.TRACE('using default batch size', 'INV_UTILITIES', 9);
162: END IF;
163: END IF;
164:
165: l_batch_size := 0;

Line 168: inv_log_util.TRACE('Pick Slip Grouping Rule Id ' || TO_CHAR(p_pick_slip_group_rule_id), 'INV_UTILITIES', 9);

164:
165: l_batch_size := 0;
166:
167: IF (l_debug = 1) THEN
168: inv_log_util.TRACE('Pick Slip Grouping Rule Id ' || TO_CHAR(p_pick_slip_group_rule_id), 'INV_UTILITIES', 9);
169: END IF;
170:
171: --device integration starts
172: IF (inv_install.adv_inv_installed(p_org_id) = TRUE) THEN --for WMS org

Line 196: inv_log_util.TRACE('Updating MTRH Id ' || TO_CHAR(mtrh_header_change_track), 'INV_UTILITIES', 9);

192: AND p_pick_slip_group_rule_id IS NOT NULL THEN
193: mtrh_header_change_track := move_ord_rec.header_id;
194:
195: IF (l_debug = 1) THEN
196: inv_log_util.TRACE('Updating MTRH Id ' || TO_CHAR(mtrh_header_change_track), 'INV_UTILITIES', 9);
197: END IF;
198:
199: UPDATE mtl_txn_request_headers
200: SET grouping_rule_id = p_pick_slip_group_rule_id

Line 299: inv_log_util.TRACE('commit', 'INV_UTILITIES', 9);

295: IF l_batch_size >= l_max_batch THEN
296: COMMIT;
297:
298: IF (l_debug = 1) THEN
299: inv_log_util.TRACE('commit', 'INV_UTILITIES', 9);
300: END IF;
301:
302: l_batch_size := 0;
303: END IF;

Line 329: inv_log_util.TRACE('Device_API: return stat:'||v_return_status, 'INV_UTILITIES', 9);

325: x_msg_data => v_msg
326: );
327:
328: IF (l_debug = 1) THEN
329: inv_log_util.TRACE('Device_API: return stat:'||v_return_status, 'INV_UTILITIES', 9);
330: END IF;
331:
332: end if;
333:

Line 706: END inv_utilities;

702: p_source_id := fnd_flex_keyval.combination_id;
703: END IF;
704: END get_sales_order_id ;
705:
706: END inv_utilities;