301: END IF;
302: -- Moac End.
303:
304: -- Turning debug on for testing purpose.
305: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
306: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
307: p_order_number_low);
308: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
309: p_order_number_high);
302: -- Moac End.
303:
304: -- Turning debug on for testing purpose.
305: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
306: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
307: p_order_number_low);
308: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
309: p_order_number_high);
310: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
304: -- Turning debug on for testing purpose.
305: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
306: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
307: p_order_number_low);
308: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
309: p_order_number_high);
310: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
311: p_request_date_low);
312: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
306: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
307: p_order_number_low);
308: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
309: p_order_number_high);
310: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
311: p_request_date_low);
312: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
313: p_request_date_high);
314: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
308: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
309: p_order_number_high);
310: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
311: p_request_date_low);
312: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
313: p_request_date_high);
314: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
315: p_customer_po_number);
316: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
310: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
311: p_request_date_low);
312: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
313: p_request_date_high);
314: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
315: p_customer_po_number);
316: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
317: p_ship_to_location);
318: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
312: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
313: p_request_date_high);
314: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
315: p_customer_po_number);
316: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
317: p_ship_to_location);
318: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
319: p_order_type);
320: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
314: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||
315: p_customer_po_number);
316: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
317: p_ship_to_location);
318: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
319: p_order_type);
320: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
321: p_customer);
322: fnd_file.put_line(FND_FILE.LOG, ' item = '||
316: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||
317: p_ship_to_location);
318: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
319: p_order_type);
320: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
321: p_customer);
322: fnd_file.put_line(FND_FILE.LOG, ' item = '||
323: p_item);
324: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
318: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
319: p_order_type);
320: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
321: p_customer);
322: fnd_file.put_line(FND_FILE.LOG, ' item = '||
323: p_item);
324: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
325: p_ordered_date_low);
326: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
320: fnd_file.put_line(FND_FILE.LOG, ' customer = '||
321: p_customer);
322: fnd_file.put_line(FND_FILE.LOG, ' item = '||
323: p_item);
324: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
325: p_ordered_date_low);
326: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
327: p_ordered_date_high);
328: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
322: fnd_file.put_line(FND_FILE.LOG, ' item = '||
323: p_item);
324: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
325: p_ordered_date_low);
326: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
327: p_ordered_date_high);
328: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
329: p_warehouse);
330: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
324: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||
325: p_ordered_date_low);
326: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
327: p_ordered_date_high);
328: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
329: p_warehouse);
330: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
331: p_demand_class);
332: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
326: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||
327: p_ordered_date_high);
328: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
329: p_warehouse);
330: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
331: p_demand_class);
332: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
333: p_planning_priority);
334: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
328: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||
329: p_warehouse);
330: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
331: p_demand_class);
332: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
333: p_planning_priority);
334: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
335: p_shipment_priority);
336: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
330: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||
331: p_demand_class);
332: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
333: p_planning_priority);
334: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
335: p_shipment_priority);
336: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
337: p_line_type);
338: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
332: fnd_file.put_line(FND_FILE.LOG, ' planning_priority = ' ||
333: p_planning_priority);
334: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
335: p_shipment_priority);
336: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
337: p_line_type);
338: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
339: p_line_request_date_low);
340: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
334: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||
335: p_shipment_priority);
336: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
337: p_line_type);
338: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
339: p_line_request_date_low);
340: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
341: p_line_request_date_high);
342: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
336: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||
337: p_line_type);
338: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
339: p_line_request_date_low);
340: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
341: p_line_request_date_high);
342: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
343: p_line_ship_to_location);
344: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
338: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||
339: p_line_request_date_low);
340: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
341: p_line_request_date_high);
342: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
343: p_line_ship_to_location);
344: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
345: p_sch_ship_date_low);
346: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
340: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||
341: p_line_request_date_high);
342: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
343: p_line_ship_to_location);
344: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
345: p_sch_ship_date_low);
346: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
347: p_sch_ship_date_high);
348: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
342: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||
343: p_line_ship_to_location);
344: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
345: p_sch_ship_date_low);
346: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
347: p_sch_ship_date_high);
348: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
349: p_sch_arrival_date_low);
350: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
344: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_low = ' ||
345: p_sch_ship_date_low);
346: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
347: p_sch_ship_date_high);
348: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
349: p_sch_arrival_date_low);
350: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
351: p_sch_arrival_date_high);
352: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
346: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_date_high = ' ||
347: p_sch_ship_date_high);
348: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
349: p_sch_arrival_date_low);
350: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
351: p_sch_arrival_date_high);
352: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
353: p_booked);
354: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
348: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||
349: p_sch_arrival_date_low);
350: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
351: p_sch_arrival_date_high);
352: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
353: p_booked);
354: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
355: p_sch_mode);
356: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
350: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||
351: p_sch_arrival_date_high);
352: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
353: p_booked);
354: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
355: p_sch_mode);
356: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
357: p_dummy1);
358: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
352: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||
353: p_booked);
354: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
355: p_sch_mode);
356: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
357: p_dummy1);
358: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
359: p_apply_warehouse);
360: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
354: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||
355: p_sch_mode);
356: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
357: p_dummy1);
358: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
359: p_apply_warehouse);
360: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
361: p_apply_sch_date);
362: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||
356: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||
357: p_dummy1);
358: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
359: p_apply_warehouse);
360: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
361: p_apply_sch_date);
362: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||
363: p_order_by_first);
364: fnd_file.put_line(FND_FILE.LOG, ' order_by_sec = ' ||
358: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||
359: p_apply_warehouse);
360: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
361: p_apply_sch_date);
362: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||
363: p_order_by_first);
364: fnd_file.put_line(FND_FILE.LOG, ' order_by_sec = ' ||
365: p_order_by_sec);
366: --Bug 8813015: start
360: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||
361: p_apply_sch_date);
362: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||
363: p_order_by_first);
364: fnd_file.put_line(FND_FILE.LOG, ' order_by_sec = ' ||
365: p_order_by_sec);
366: --Bug 8813015: start
367: fnd_file.put_line(FND_FILE.LOG, ' picked = ' ||
368: p_picked);
363: p_order_by_first);
364: fnd_file.put_line(FND_FILE.LOG, ' order_by_sec = ' ||
365: p_order_by_sec);
366: --Bug 8813015: start
367: fnd_file.put_line(FND_FILE.LOG, ' picked = ' ||
368: p_picked);
369: --Bug 8813015: end
370: --12639770
371: fnd_file.put_line(FND_FILE.LOG, ' Threshold = ' ||
367: fnd_file.put_line(FND_FILE.LOG, ' picked = ' ||
368: p_picked);
369: --Bug 8813015: end
370: --12639770
371: fnd_file.put_line(FND_FILE.LOG, ' Threshold = ' ||
372: p_commit_threshold);
373:
374: FND_PROFILE.Get(NAME => 'CONC_REQUEST_ID',
375: VAL => l_request_id);
389: Oe_Msg_Pub.Add;
390: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
391: l_msg_data := Fnd_Message.get_string('ONT',
392: 'ONT_SCH_INVALID_MODE_ATTRB');
393: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
394: ERRBUF := 'ONT_SCH_INVALID_MODE_ATTRB';
395: IF l_debug_level > 0 THEN
396: OE_DEBUG_PUB.Add('Error : Schedule date supplied for wrong mode.',1);
397: END IF;
540: FOR I in 1..l_msg_count LOOP
541: l_msg_data := OE_MSG_PUB.Get(I,'F');
542:
543: -- Write Messages in the log file
544: fnd_file.put_line(FND_FILE.LOG, l_msg_data);
545:
546: END LOOP;
547: */
548: --5166476
973: FOR I in 1..l_msg_count LOOP
974: l_msg_data := OE_MSG_PUB.Get(I,'F');
975:
976: -- Write Messages in the log file
977: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
978:
979: END LOOP;
980: */
981: EXCEPTION
1630: l_rec_processed := l_rec_processed +1;
1631: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.NEXT(l_index);
1632: END LOOP;
1633:
1634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);
1635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);
1636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Successfully Processed : ' || l_rec_success);
1637:
1638: IF l_failure THEN
1631: l_index := OE_SCH_CONC_REQUESTS.oe_line_status_tbl.NEXT(l_index);
1632: END LOOP;
1633:
1634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);
1635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);
1636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Successfully Processed : ' || l_rec_success);
1637:
1638: IF l_failure THEN
1639: RETCODE := 1;
1632: END LOOP;
1633:
1634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);
1635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);
1636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Successfully Processed : ' || l_rec_success);
1637:
1638: IF l_failure THEN
1639: RETCODE := 1;
1640: END IF;
1640: END IF;
1641:
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: fnd_file.put_line(FND_FILE.LOG,
1645: 'Error executing Scheduling, Exception:G_EXC_ERROR');
1646:
1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1648: fnd_file.put_line(FND_FILE.LOG,
1644: fnd_file.put_line(FND_FILE.LOG,
1645: 'Error executing Scheduling, Exception:G_EXC_ERROR');
1646:
1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1648: fnd_file.put_line(FND_FILE.LOG,
1649: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1650:
1651: WHEN OTHERS THEN
1652: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1648: fnd_file.put_line(FND_FILE.LOG,
1649: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1650:
1651: WHEN OTHERS THEN
1652: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1653: fnd_file.put_line(FND_FILE.LOG, substr(sqlerrm, 1, 2000));
1654: DBMS_SQL.Close_Cursor(l_cursor_id);
1655:
1656: END Request;
1649: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1650:
1651: WHEN OTHERS THEN
1652: fnd_file.put_line(FND_FILE.LOG, 'Unexpected error in OE_SCH_CONC_REQUESTS.Request');
1653: fnd_file.put_line(FND_FILE.LOG, substr(sqlerrm, 1, 2000));
1654: DBMS_SQL.Close_Cursor(l_cursor_id);
1655:
1656: END Request;
1657: