eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_RESERVE_CONC dependencies on FND_FILE

Line 414: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');

410: RETCODE := 0;
411:
412: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
413:
414: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
415: FND_FILE.Put_Line(FND_FILE.LOG, ' ORG_ID = '||
416: p_org_id);
417: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
418: p_use_reservation_time_fence);

Line 415: FND_FILE.Put_Line(FND_FILE.LOG, ' ORG_ID = '||

411:
412: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
413:
414: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
415: FND_FILE.Put_Line(FND_FILE.LOG, ' ORG_ID = '||
416: p_org_id);
417: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
418: p_use_reservation_time_fence);
419: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||

Line 417: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||

413:
414: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
415: FND_FILE.Put_Line(FND_FILE.LOG, ' ORG_ID = '||
416: p_org_id);
417: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
418: p_use_reservation_time_fence);
419: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
420: p_order_number_low);
421: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||

Line 419: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||

415: FND_FILE.Put_Line(FND_FILE.LOG, ' ORG_ID = '||
416: p_org_id);
417: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
418: p_use_reservation_time_fence);
419: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
420: p_order_number_low);
421: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
422: p_order_number_high);
423: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||

Line 421: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||

417: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
418: p_use_reservation_time_fence);
419: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
420: p_order_number_low);
421: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
422: p_order_number_high);
423: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
424: p_customer_id);
425: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||

Line 423: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||

419: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
420: p_order_number_low);
421: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
422: p_order_number_high);
423: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
424: p_customer_id);
425: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
426: p_order_type);
427: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||

Line 425: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||

421: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
422: p_order_number_high);
423: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
424: p_customer_id);
425: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
426: p_order_type);
427: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
428: p_Warehouse);
429: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||

Line 427: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||

423: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
424: p_customer_id);
425: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
426: p_order_type);
427: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
428: p_Warehouse);
429: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
430: p_request_date_low);
431: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||

Line 429: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||

425: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
426: p_order_type);
427: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
428: p_Warehouse);
429: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
430: p_request_date_low);
431: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
432: p_request_date_high);
433: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||

Line 431: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||

427: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
428: p_Warehouse);
429: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
430: p_request_date_low);
431: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
432: p_request_date_high);
433: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
434: p_schedule_ship_date_low);
435: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||

Line 433: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||

429: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
430: p_request_date_low);
431: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
432: p_request_date_high);
433: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
434: p_schedule_ship_date_low);
435: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
436: p_schedule_ship_date_high);
437: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||

Line 435: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||

431: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
432: p_request_date_high);
433: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
434: p_schedule_ship_date_low);
435: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
436: p_schedule_ship_date_high);
437: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
438: p_ordered_date_low);
439: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||

Line 437: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||

433: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
434: p_schedule_ship_date_low);
435: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
436: p_schedule_ship_date_high);
437: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
438: p_ordered_date_low);
439: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
440: p_ordered_date_high);
441: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||

Line 439: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||

435: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
436: p_schedule_ship_date_high);
437: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
438: p_ordered_date_low);
439: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
440: p_ordered_date_high);
441: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
442: p_demand_class_code);
443: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||

Line 441: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||

437: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
438: p_ordered_date_low);
439: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
440: p_ordered_date_high);
441: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
442: p_demand_class_code);
443: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
444: p_inventory_item_id);
445: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||

Line 443: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||

439: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
440: p_ordered_date_high);
441: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
442: p_demand_class_code);
443: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
444: p_inventory_item_id);
445: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
446: p_Planning_priority);
447: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||

Line 445: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||

441: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
442: p_demand_class_code);
443: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
444: p_inventory_item_id);
445: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
446: p_Planning_priority);
447: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
448: p_booked);
449: FND_FILE.Put_Line(FND_FILE.LOG, ' Line ID = '||

Line 447: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||

443: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
444: p_inventory_item_id);
445: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
446: p_Planning_priority);
447: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
448: p_booked);
449: FND_FILE.Put_Line(FND_FILE.LOG, ' Line ID = '||
450: p_line_id );
451:

Line 449: FND_FILE.Put_Line(FND_FILE.LOG, ' Line ID = '||

445: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
446: p_Planning_priority);
447: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
448: p_booked);
449: FND_FILE.Put_Line(FND_FILE.LOG, ' Line ID = '||
450: p_line_id );
451:
452: IF g_debug <= gme_debug.g_log_procedure THEN
453: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

Line 493: FND_FILE.Put_Line(FND_FILE.LOG, 'Starting syntax construction');

489: -- Start constructing retrieval syntax
490: IF g_debug <= gme_debug.g_log_procedure THEN
491: gme_debug.put_line('Start building retrieval syntax');
492: END IF;
493: FND_FILE.Put_Line(FND_FILE.LOG, 'Starting syntax construction');
494: l_stmt := 'SELECT Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi ';
495: l_stmt := l_stmt|| ' WHERE NVL(h.cancelled_flag,'||'''N'''||') <> ' ||'''Y'''||
496: ' AND h.header_id = l.header_id'||
497: ' AND h.open_flag = '||'''Y'''||

Line 536: FND_FILE.Put_Line(FND_FILE.LOG, 'GME Ordered date low here ');

532: IF p_order_type IS NOT NULL THEN
533: l_stmt := l_stmt ||' AND h.order_type_id =:order_type'; --p_order_type
534: END IF;
535: IF l_ordered_date_low IS NOT NULL THEN
536: FND_FILE.Put_Line(FND_FILE.LOG, 'GME Ordered date low here ');
537: l_stmt := l_stmt ||' AND h.ordered_date >=:ordered_date_low'; --l_ordered_date_low
538: END IF;
539: IF l_ordered_date_high IS NOT NULL THEN
540: l_stmt := l_stmt ||' AND h.ordered_date <=:ordered_date_high'; --l_ordered_date_high;

Line 598: FND_FILE.Put_Line(FND_FILE.LOG, ' Query Built = '||

594: gme_debug.put_line(substr(l_stmt,1,length(l_stmt)),1);
595: END IF;
596: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
597:
598: FND_FILE.Put_Line(FND_FILE.LOG, ' Query Built = '||
599: l_stmt );
600:
601: FND_FILE.Put_Line(FND_FILE.LOG, 'GME parse done now');
602: IF g_debug <= gme_debug.g_log_procedure THEN

Line 601: FND_FILE.Put_Line(FND_FILE.LOG, 'GME parse done now');

597:
598: FND_FILE.Put_Line(FND_FILE.LOG, ' Query Built = '||
599: l_stmt );
600:
601: FND_FILE.Put_Line(FND_FILE.LOG, 'GME parse done now');
602: IF g_debug <= gme_debug.g_log_procedure THEN
603: gme_debug.put_line('PARSE done ');
604: gme_debug.put_line('Start processing bind variables ');
605: END IF;

Line 677: FND_FILE.Put_Line(FND_FILE.LOG, 'EXECUTE data retrieval ');

673: -- ================= EXECUTE ==========================
674: IF g_debug <= gme_debug.g_log_procedure THEN
675: gme_debug.put_line(substr(l_stmt,1,length(l_stmt)),1);
676: END IF;
677: FND_FILE.Put_Line(FND_FILE.LOG, 'EXECUTE data retrieval ');
678:
679: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
680:
681: -- ================= PROCESS ORDER LINES ==================

Line 689: FND_FILE.Put_Line(FND_FILE.LOG, 'Zero order line rows to process so exit');

685: LOOP
686:
687:
688: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
689: FND_FILE.Put_Line(FND_FILE.LOG, 'Zero order line rows to process so exit');
690: EXIT;
691: END IF;
692: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
693:

Line 694: FND_FILE.Put_Line(FND_FILE.LOG, '* Processing Line id '|| l_line_id||' *');

690: EXIT;
691: END IF;
692: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
693:
694: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '|| l_line_id||' *****');
695: l_return_status := FND_API.G_RET_STS_SUCCESS;
696: OE_LINE_UTIL.Lock_Row
697: (p_line_id => l_Line_id,
698: p_x_line_rec => l_line_rec,

Line 768: FND_FILE.Put_Line(FND_FILE.LOG, '* order line DOES NOT qualify for MAKE to ORDER '|| l_line_id||' *');

764: GOTO NEXT_RECORD;
765: END IF;
766: END IF;
767: ELSE
768: FND_FILE.Put_Line(FND_FILE.LOG, '***** order line DOES NOT qualify for MAKE to ORDER '|| l_line_id||' *****');
769: END IF; -- End of Line Qualifies for MAKE to ORDER
770:
771: <>
772: NULL;

Line 776: FND_FILE.Put_Line(FND_FILE.LOG, 'End of processing for OPM Make to Order');

772: NULL;
773: END LOOP; -- End of lines_cur
774: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
775:
776: FND_FILE.Put_Line(FND_FILE.LOG, 'End of processing for OPM Make to Order');
777: COMMIT;
778:
779: <>
780: IF g_debug <= gme_debug.g_log_procedure THEN