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.15.12020000.3 2013/01/29 18:50:00 avrose 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 892: inv_log_util.TRACE('WMS enabled? : '||l_is_wms_enabled , 'INV_UTILITIES', 9);

888:
889: IF (inv_cache.set_org_rec(p_org_id)) THEN
890: l_is_wms_enabled := inv_cache.org_rec.WMS_ENABLED_FLAG;
891: IF (l_debug = 1) THEN
892: inv_log_util.TRACE('WMS enabled? : '||l_is_wms_enabled , 'INV_UTILITIES', 9);
893: END IF;
894: END IF;
895:
896: IF l_is_wms_enabled = 'Y' THEN

Line 900: inv_log_util.TRACE('The fulfillment Base: '||x_fulfillment_base , 'INV_UTILITIES', 9);

896: IF l_is_wms_enabled = 'Y' THEN
897: IF p_demand_source_type_id IN (2,8) THEN
898: x_fulfillment_base := Nvl(OE_DUAL_UOM_UTIL.get_fulfillment_base(p_source_line_id), 'P');
899: IF (l_debug = 1) THEN
900: inv_log_util.TRACE('The fulfillment Base: '||x_fulfillment_base , 'INV_UTILITIES', 9);
901: END IF;
902: ELSE
903: x_fulfillment_base := 'P';
904: END IF;

Line 910: END inv_utilities;

906: x_fulfillment_base := 'P';
907: END IF;
908: END get_inv_fulfillment_base;
909:
910: END inv_utilities;