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.MRP_RESCHEDULE_PO dependencies on FND_FILE

Line 78: FND_FILE.PUT_LINE(FND_FILE.LOG,'starting ...');

74: p_result_warning boolean := false;
75:
76: BEGIN
77:
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'starting ...');
79: p_batch_id := p_po_header_id;
80: p_instance_id := p_po_line_id;
81: p_dblink := p_po_number;
82:

Line 96: FND_FILE.PUT_LINE(FND_FILE.LOG, 'instance_code:'||p_instance_code||' dblink: '|| p_po_number ||', instance_id='||p_instance_id||', batch_id='||p_batch_id||',allow_release_flag ='||p_allow_release);

92: else
93: p_dblink := '@'||p_dblink;
94: end if;
95:
96: FND_FILE.PUT_LINE(FND_FILE.LOG, 'instance_code:'||p_instance_code||' dblink: '|| p_po_number ||', instance_id='||p_instance_id||', batch_id='||p_batch_id||',allow_release_flag ='||p_allow_release);
97:
98:
99: if p_allow_release = 1 THEN
100: mo_global.INIT('PO');

Line 239: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

235: last_po_header_id := v_po_header_id(i);
236: last_po_number := v_po_number(i);
237: end if; -- if v_action = 2 then
238:
239: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
240: END LOOP; -- FOR i in 1..nvl(v_po_line_id.LAST, 0) LOOP
241:
242: if a <> 0 then
243: p_result := reschedule_po(X_need_by_dates_old,

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'instance '||p_instance_code||' does not allow release ');

282: retcode := 2; -- error
283: end if;
284:
285: else -- not allow release
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'instance '||p_instance_code||' does not allow release ');
287: end if; -- if p_allow_release = 1 then
288: sql_stmt:= ' delete from msc_purchase_order_interface'||p_dblink||
289: ' where sr_instance_id = :p_instance_id '||
290: ' and batch_id = :p_batch_id ';

Line 395: FND_FILE.PUT_LINE(FND_FILE.LOG, '* PO line details *');

391: for i in 1..nvl(X_po_line_ids.last, 0) loop
392: open po_details(x_po_line_ids(i));
393: fetch po_details into l_po_line_number;
394: close po_details;
395: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** PO line details *****');
396: FND_FILE.PUT_LINE(FND_FILE.LOG,'old date in planner workbench: '||
397: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
398: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
399: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));

Line 396: FND_FILE.PUT_LINE(FND_FILE.LOG,'old date in planner workbench: '||

392: open po_details(x_po_line_ids(i));
393: fetch po_details into l_po_line_number;
394: close po_details;
395: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** PO line details *****');
396: FND_FILE.PUT_LINE(FND_FILE.LOG,'old date in planner workbench: '||
397: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
398: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
399: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);

Line 398: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||

394: close po_details;
395: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** PO line details *****');
396: FND_FILE.PUT_LINE(FND_FILE.LOG,'old date in planner workbench: '||
397: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
398: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
399: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
401: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'line number : ' || l_po_line_number);

Line 400: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);

396: FND_FILE.PUT_LINE(FND_FILE.LOG,'old date in planner workbench: '||
397: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
398: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
399: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
401: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'line number : ' || l_po_line_number);
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));

Line 401: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));

397: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
398: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
399: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
401: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'line number : ' || l_po_line_number);
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));
405: end loop;

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG,'line number : ' || l_po_line_number);

398: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
399: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
401: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'line number : ' || l_po_line_number);
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));
405: end loop;
406: END show_po_details;

Line 403: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);

399: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
401: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'line number : ' || l_po_line_number);
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));
405: end loop;
406: END show_po_details;
407:

Line 404: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));

400: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
401: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'line number : ' || l_po_line_number);
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));
405: end loop;
406: END show_po_details;
407:
408: BEGIN

Line 437: FND_FILE.PUT_LINE(FND_FILE.LOG,' error while calling po_reschedule_pkg.reschedule '||sqlerrm);

433: x_error_messages);
434: Mo_Global.Set_Policy_Context (p_access_mode => l_access_mode,
435: p_org_id => l_current_org_id);
436: exception when others then
437: FND_FILE.PUT_LINE(FND_FILE.LOG,' error while calling po_reschedule_pkg.reschedule '||sqlerrm);
438: Mo_Global.Set_Policy_Context (p_access_mode => l_access_mode,
439: p_org_id => l_current_org_id);
440: show_po_details;
441: end;

Line 444: FND_FILE.PUT_LINE(FND_FILE.LOG, 'the call to po_reschedule_pkg.reschedule return null value');

440: show_po_details;
441: end;
442:
443: if p_result is null then
444: FND_FILE.PUT_LINE(FND_FILE.LOG, 'the call to po_reschedule_pkg.reschedule return null value');
445: end if;
446:
447: p_result := nvl(p_result, false);
448:

Line 471: FND_FILE.PUT_LINE(FND_FILE.LOG,' call reschedule again by modifying old_need_by_date from '||to_char(x_old_need_by_dates(i), 'MM/DD/RRRR HH24:MI:SS')||

467: 'MM/DD/RRRR HH24:MI') =
468: to_date(to_char(v_date, 'MM/DD/RRRR HH24:MI'),
469: 'MM/DD/RRRR HH24:MI') then
470: if x_old_need_by_dates(i) <> v_date then
471: FND_FILE.PUT_LINE(FND_FILE.LOG,' call reschedule again by modifying old_need_by_date from '||to_char(x_old_need_by_dates(i), 'MM/DD/RRRR HH24:MI:SS')||
472: ' to '||to_char(v_date, 'MM/DD/RRRR HH24:MI:SS'));
473: v_old_need_by_dates(i) := v_date;
474: v_date_changed := true;
475: end if;

Line 504: FND_FILE.PUT_LINE(FND_FILE.LOG,'ASCP call to PO API was successful for PO header id ' || X_po_header_id );

500: -- set l_derived_status correctly.
501: -- PO can return success , even if one of the line failed
502: l_derived_status := get_request_status(x_error_messages);
503: if p_show_msg = 'Y' then
504: FND_FILE.PUT_LINE(FND_FILE.LOG,'ASCP call to PO API was successful for PO header id ' || X_po_header_id );
505: end if;
506:
507: for i in 1..x_error_messages.count loop
508: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error returned from PO api : ' || x_error_messages(i));

Line 508: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error returned from PO api : ' || x_error_messages(i));

504: FND_FILE.PUT_LINE(FND_FILE.LOG,'ASCP call to PO API was successful for PO header id ' || X_po_header_id );
505: end if;
506:
507: for i in 1..x_error_messages.count loop
508: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error returned from PO api : ' || x_error_messages(i));
509: end loop;
510: else
511: l_derived_status := 2;
512: if p_show_msg = 'Y' then

Line 513: FND_FILE.PUT_LINE(FND_FILE.LOG,'ASCP call to PO API encountered an error for PO header ID' || X_po_header_id) ;

509: end loop;
510: else
511: l_derived_status := 2;
512: if p_show_msg = 'Y' then
513: FND_FILE.PUT_LINE(FND_FILE.LOG,'ASCP call to PO API encountered an error for PO header ID' || X_po_header_id) ;
514: end if;
515:
516: for i in 1..x_error_messages.count loop
517: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error returned from PO api : ' || x_error_messages(i));

Line 517: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error returned from PO api : ' || x_error_messages(i));

513: FND_FILE.PUT_LINE(FND_FILE.LOG,'ASCP call to PO API encountered an error for PO header ID' || X_po_header_id) ;
514: end if;
515:
516: for i in 1..x_error_messages.count loop
517: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error returned from PO api : ' || x_error_messages(i));
518: end loop;
519:
520: end if;
521:

Line 529: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in reschedule_po, error is: '||sqlerrm);

525: end if;
526:
527: return p_result;
528: exception when others then
529: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in reschedule_po, error is: '||sqlerrm);
530: show_po_details;
531: l_derived_status := 2;
532: return false;
533: END reschedule_po;