DBA Data[Home] [Help]

APPS.OE_SCH_CONC_REQUESTS dependencies on FND_FILE

Line 305: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');

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);

Line 306: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||

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 = '||

Line 308: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||

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 = '||

Line 310: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||

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 = '||

Line 312: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||

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 = '||

Line 314: fnd_file.put_line(FND_FILE.LOG, ' customer_po_number = '||

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 = '||

Line 316: fnd_file.put_line(FND_FILE.LOG, ' ship_to_location = '||

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 = '||

Line 318: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||

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 = '||

Line 320: fnd_file.put_line(FND_FILE.LOG, ' customer = '||

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 = ' ||

Line 322: fnd_file.put_line(FND_FILE.LOG, ' item = '||

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 = ' ||

Line 324: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_low = ' ||

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 = ' ||

Line 326: fnd_file.put_line(FND_FILE.LOG, ' ordered_date_high = ' ||

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 = ' ||

Line 328: fnd_file.put_line(FND_FILE.LOG, ' warehouse = ' ||

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 = ' ||

Line 330: fnd_file.put_line(FND_FILE.LOG, ' demand_class = ' ||

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 = ' ||

Line 332: fnd_file.put_line(FND_FILE.LOG, ' planning_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 = ' ||

Line 334: fnd_file.put_line(FND_FILE.LOG, ' shipment_priority = ' ||

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 = ' ||

Line 336: fnd_file.put_line(FND_FILE.LOG, ' line_type = ' ||

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 = ' ||

Line 338: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_low = ' ||

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 = ' ||

Line 340: fnd_file.put_line(FND_FILE.LOG, ' line_request_date_high = ' ||

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 = ' ||

Line 342: fnd_file.put_line(FND_FILE.LOG, ' line_ship_to_location = ' ||

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 = ' ||

Line 344: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_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 = ' ||
347: p_sch_ship_date_high);
348: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||

Line 346: fnd_file.put_line(FND_FILE.LOG, ' sch_ship_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 = ' ||
349: p_sch_arrival_date_low);
350: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||

Line 348: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_low = ' ||

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 = ' ||

Line 350: fnd_file.put_line(FND_FILE.LOG, ' sch_arrival_date_high = ' ||

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 = ' ||

Line 352: fnd_file.put_line(FND_FILE.LOG, ' booked = ' ||

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 = ' ||

Line 354: fnd_file.put_line(FND_FILE.LOG, ' sch_mode = ' ||

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 = ' ||

Line 356: fnd_file.put_line(FND_FILE.LOG, ' dummy1 = ' ||

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 = ' ||

Line 358: fnd_file.put_line(FND_FILE.LOG, ' apply_warehouse = ' ||

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 = ' ||

Line 360: fnd_file.put_line(FND_FILE.LOG, ' apply_sch_date = ' ||

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 = ' ||

Line 362: fnd_file.put_line(FND_FILE.LOG, ' order_by_first = ' ||

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

Line 364: fnd_file.put_line(FND_FILE.LOG, ' order_by_sec = ' ||

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);

Line 367: fnd_file.put_line(FND_FILE.LOG, ' 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 = ' ||

Line 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);

Line 393: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

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;

Line 544: fnd_file.put_line(FND_FILE.LOG, l_msg_data);

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

Line 977: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

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

Line 1634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Lines Selected : ' || l_rec_processed);

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

Line 1635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Failed : ' || l_rec_failure);

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;

Line 1636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lines Successfully Processed : ' || l_rec_success);

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;

Line 1644: fnd_file.put_line(FND_FILE.LOG,

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,

Line 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');

Line 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;

Line 1653: fnd_file.put_line(FND_FILE.LOG, substr(sqlerrm, 1, 2000));

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: