241: END IF;
242: -- Moac End.
243:
244: -- Turning debug on for testing purpose.
245: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
246: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
247: p_order_number_low);
248: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
249: p_order_number_high);
242: -- Moac End.
243:
244: -- Turning debug on for testing purpose.
245: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
246: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
247: p_order_number_low);
248: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
249: p_order_number_high);
250: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
244: -- Turning debug on for testing purpose.
245: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
246: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
247: p_order_number_low);
248: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
249: p_order_number_high);
250: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
251: p_request_date_low);
252: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
246: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
247: p_order_number_low);
248: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
249: p_order_number_high);
250: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
251: p_request_date_low);
252: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
253: p_request_date_high);
254: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
248: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
249: p_order_number_high);
250: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
251: p_request_date_low);
252: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
253: p_request_date_high);
254: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
255: p_customer_po_number);
256: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
250: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
251: p_request_date_low);
252: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
253: p_request_date_high);
254: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
255: p_customer_po_number);
256: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
257: p_ship_to_location);
258: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
252: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
253: p_request_date_high);
254: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
255: p_customer_po_number);
256: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
257: p_ship_to_location);
258: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
259: p_order_type);
260: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
254: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
255: p_customer_po_number);
256: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
257: p_ship_to_location);
258: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
259: p_order_type);
260: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
261: p_customer);
262: fnd_file.put_line(FND_FILE.LOG, ' item = '||
256: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
257: p_ship_to_location);
258: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
259: p_order_type);
260: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
261: p_customer);
262: fnd_file.put_line(FND_FILE.LOG, ' item = '||
263: p_item);
264: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
258: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
259: p_order_type);
260: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
261: p_customer);
262: fnd_file.put_line(FND_FILE.LOG, ' item = '||
263: p_item);
264: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
265: p_ordered_date_low);
266: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
260: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
261: p_customer);
262: fnd_file.put_line(FND_FILE.LOG, ' item = '||
263: p_item);
264: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
265: p_ordered_date_low);
266: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
267: p_ordered_date_high);
268: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
262: fnd_file.put_line(FND_FILE.LOG, ' item = '||
263: p_item);
264: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
265: p_ordered_date_low);
266: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
267: p_ordered_date_high);
268: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
269: p_warehouse);
270: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
264: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
265: p_ordered_date_low);
266: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
267: p_ordered_date_high);
268: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
269: p_warehouse);
270: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
271: p_demand_class);
272: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
266: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
267: p_ordered_date_high);
268: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
269: p_warehouse);
270: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
271: p_demand_class);
272: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
273: p_planning_priority);
274: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
268: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
269: p_warehouse);
270: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
271: p_demand_class);
272: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
273: p_planning_priority);
274: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
275: p_shipment_priority);
276: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
270: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
271: p_demand_class);
272: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
273: p_planning_priority);
274: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
275: p_shipment_priority);
276: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
277: p_line_type);
278: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
272: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
273: p_planning_priority);
274: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
275: p_shipment_priority);
276: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
277: p_line_type);
278: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
279: p_line_request_date_low);
280: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
274: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
275: p_shipment_priority);
276: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
277: p_line_type);
278: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
279: p_line_request_date_low);
280: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
281: p_line_request_date_high);
282: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
276: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
277: p_line_type);
278: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
279: p_line_request_date_low);
280: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
281: p_line_request_date_high);
282: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
283: p_line_ship_to_location);
284: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
278: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
279: p_line_request_date_low);
280: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
281: p_line_request_date_high);
282: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
283: p_line_ship_to_location);
284: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
285: p_sch_ship_date_low);
286: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
280: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
281: p_line_request_date_high);
282: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
283: p_line_ship_to_location);
284: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
285: p_sch_ship_date_low);
286: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
287: p_sch_ship_date_high);
288: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
282: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
283: p_line_ship_to_location);
284: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
285: p_sch_ship_date_low);
286: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
287: p_sch_ship_date_high);
288: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
289: p_sch_arrival_date_low);
290: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
284: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
285: p_sch_ship_date_low);
286: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
287: p_sch_ship_date_high);
288: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
289: p_sch_arrival_date_low);
290: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
291: p_sch_arrival_date_high);
292: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
286: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
287: p_sch_ship_date_high);
288: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
289: p_sch_arrival_date_low);
290: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
291: p_sch_arrival_date_high);
292: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
293: p_booked);
294: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
288: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
289: p_sch_arrival_date_low);
290: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
291: p_sch_arrival_date_high);
292: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
293: p_booked);
294: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
295: p_sch_mode);
296: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
290: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
291: p_sch_arrival_date_high);
292: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
293: p_booked);
294: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
295: p_sch_mode);
296: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
297: p_dummy1);
298: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
292: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
293: p_booked);
294: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
295: p_sch_mode);
296: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
297: p_dummy1);
298: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
299: p_apply_warehouse);
300: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
294: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
295: p_sch_mode);
296: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
297: p_dummy1);
298: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
299: p_apply_warehouse);
300: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
301: p_apply_sch_date);
302: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||
296: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
297: p_dummy1);
298: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
299: p_apply_warehouse);
300: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
301: p_apply_sch_date);
302: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||
303: p_order_by_first);
304: fnd_file.put_line(FND_FILE.LOG, ' order_by_sec = ' ||
298: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
299: p_apply_warehouse);
300: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
301: p_apply_sch_date);
302: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||
303: p_order_by_first);
304: fnd_file.put_line(FND_FILE.LOG, ' order_by_sec = ' ||
305: p_order_by_sec);
306:
300: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
301: p_apply_sch_date);
302: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||
303: p_order_by_first);
304: fnd_file.put_line(FND_FILE.LOG, ' order_by_sec = ' ||
305: p_order_by_sec);
306:
307: FND_PROFILE.Get(NAME => 'CONC_REQUEST_ID',
308: VAL => l_request_id);
316: Oe_Msg_Pub.Add;
317: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
318: l_msg_data := Fnd_Message.get_string('ONT',
319: 'ONT_SCH_INVALID_MODE_ATTRB');
320: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
321: ERRBUF := 'ONT_SCH_INVALID_MODE_ATTRB';
322: IF l_debug_level > 0 THEN
323: OE_DEBUG_PUB.Add('Error : Schedule date supplied for wrong mode.',1);
324: END IF;
428: FOR I in 1..l_msg_count LOOP
429: l_msg_data := OE_MSG_PUB.Get(I,'F');
430:
431: -- Write Messages in the log file
432: fnd_file.put_line(FND_FILE.LOG, l_msg_data);
433:
434: END LOOP;
435: --5166476
436:
806: FOR I in 1..l_msg_count LOOP
807: l_msg_data := OE_MSG_PUB.Get(I,'F');
808:
809: -- Write Messages in the log file
810: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
811:
812: END LOOP;
813: --5166476
814:
1403: l_rec_processed := l_rec_processed +1;
1404: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.NEXT(l_index);
1405: END LOOP;
1406:
1407: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Successfully Processed : ' || l_rec_success);
1410:
1411: IF l_failure THEN
1404: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.NEXT(l_index);
1405: END LOOP;
1406:
1407: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Successfully Processed : ' || l_rec_success);
1410:
1411: IF l_failure THEN
1412: RETCODE := 1;
1405: END LOOP;
1406:
1407: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Successfully Processed : ' || l_rec_success);
1410:
1411: IF l_failure THEN
1412: RETCODE := 1;
1413: END IF;
1413: END IF;
1414:
1415: EXCEPTION
1416: WHEN FND_API.G_EXC_ERROR THEN
1417: fnd_file.put_line(FND_FILE.LOG,
1418: 'Error executing Scheduling, Exception:G_EXC_ERROR');
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: fnd_file.put_line(FND_FILE.LOG,
1417: fnd_file.put_line(FND_FILE.LOG,
1418: 'Error executing Scheduling, Exception:G_EXC_ERROR');
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: fnd_file.put_line(FND_FILE.LOG,
1422: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1423:
1424: WHEN OTHERS THEN
1425: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1421: fnd_file.put_line(FND_FILE.LOG,
1422: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1423:
1424: WHEN OTHERS THEN
1425: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1426: fnd_file.put_line(FND_FILE.LOG, substr(sqlerrm, 1, 2000));
1427: DBMS_SQL.Close_Cursor(l_cursor_id);
1428:
1429: END Request;
1422: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1423:
1424: WHEN OTHERS THEN
1425: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1426: fnd_file.put_line(FND_FILE.LOG, substr(sqlerrm, 1, 2000));
1427: DBMS_SQL.Close_Cursor(l_cursor_id);
1428:
1429: END Request;
1430: