APPS.WMS_XDOCK_EXCEPTION dependencies on WMS_XDOCK_PEGGING_PUB

Line 113: l_xdock_criteria_rec := wms_xdock_pegging_pub.get_crossdock_criteria(l_xdock_pegging_rec.crossdock_criteria_id);

109: END IF;
110:
111: l_progress := '004';
112: -- Get BT, OPT, CW by crossdock criteria ???
113: l_xdock_criteria_rec := wms_xdock_pegging_pub.get_crossdock_criteria(l_xdock_pegging_rec.crossdock_criteria_id);
114:
115: l_buffer_interval := numtodsinterval(Nvl(l_xdock_criteria_rec.buffer_interval,0),
116: Nvl(l_xdock_criteria_rec.buffer_uom,'HOUR'));
117: l_op_interval := numtodsinterval(Nvl(l_xdock_criteria_rec.processing_interval ,0),

Line 135: wms_xdock_pegging_pub.get_expected_time

131: --For reservations in RCV, the expected supply time will
132: --always be now
133: l_expected_supply_time := l_now;
134: ELSE
135: wms_xdock_pegging_pub.get_expected_time
136: ( p_source_type_id => l_xdock_pegging_rec.supply_source_type_id
137: ,p_source_header_id => l_xdock_pegging_rec.supply_source_header_id
138: ,p_source_line_id => l_xdock_pegging_rec.supply_source_line_id
139: ,p_source_line_detail_id => l_xdock_pegging_rec.supply_source_line_detail

Line 162: wms_xdock_pegging_pub.get_expected_time

158: END IF;
159:
160: -- Call get_expected_time to get the actual expected_demand_date
161: l_progress := '010';
162: wms_xdock_pegging_pub.get_expected_time
163: ( p_source_type_id => l_xdock_pegging_rec.demand_source_type_id
164: ,p_source_header_id => l_xdock_pegging_rec.demand_source_header_id
165: ,p_source_line_id => l_xdock_pegging_rec.demand_source_line_id
166: ,p_source_line_detail_id => l_xdock_pegging_rec.demand_source_line_detail

Line 331: l_status := wms_xdock_pegging_pub.clear_crossdock_cache;

327: l_num_exception_thrown := l_num_exception_thrown + 1;
328: END;
329: END LOOP;
330:
331: l_status := wms_xdock_pegging_pub.clear_crossdock_cache;
332:
333: IF (l_num_exception_thrown > 0) THEN
334: x_retcode := 1; --Return a warning
335: END IF;

Line 348: l_status := wms_xdock_pegging_pub.clear_crossdock_cache;

344: IF (l_debug = 1) THEN
345: print_debug('Exception occurred at progress: '||l_progress);
346: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM);
347: END IF;
348: l_status := wms_xdock_pegging_pub.clear_crossdock_cache;
349: x_errbuf := 'U';--????
350: x_retcode := 2; --Return an error
351: END find_exception;
352: END wms_xdock_exception;