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 73: FND_FILE.PUT_LINE(FND_FILE.LOG,'starting ...');

69: last_po_header_id number;
70:
71: BEGIN
72:
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'starting ...');
74: p_batch_id := p_po_header_id;
75: p_instance_id := p_po_line_id;
76: p_dblink := p_po_number;
77:

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

87: else
88: p_dblink := '@'||p_dblink;
89: end if;
90:
91: 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:
93:
94: if p_allow_release = 1 THEN
95: mo_global.INIT('PO');

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

225: last_po_header_id := v_po_header_id(i);
226: last_po_number := v_po_number(i);
227: end if; -- if v_action = 2 then
228:
229: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
230: END LOOP; -- FOR i in 1..nvl(v_po_line_id.LAST, 0) LOOP
231:
232: if a <> 0 then
233: p_result := reschedule_po(X_need_by_dates_old,

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

243: end if;
244: end if; -- if a <> 0
245:
246: else -- not allow release
247: FND_FILE.PUT_LINE(FND_FILE.LOG, 'instance '||p_instance_code||' does not allow release ');
248: end if; -- if p_allow_release = 1 then
249: sql_stmt:= ' delete from msc_purchase_order_interface'||p_dblink||
250: ' where sr_instance_id = :p_instance_id '||
251: ' and batch_id = :p_batch_id ';

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

297:
298: PROCEDURE show_po_details IS
299: BEGIN
300: for i in 1..nvl(X_po_line_ids.last, 0) loop
301: FND_FILE.PUT_LINE(FND_FILE.LOG,'old date in planner workbench: '||
302: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
304: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
305: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);

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

299: BEGIN
300: for i in 1..nvl(X_po_line_ids.last, 0) loop
301: FND_FILE.PUT_LINE(FND_FILE.LOG,'old date in planner workbench: '||
302: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
304: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
305: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
306: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
307: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);

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

301: FND_FILE.PUT_LINE(FND_FILE.LOG,'old date in planner workbench: '||
302: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
304: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
305: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
306: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
307: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
308: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));
309: end loop;

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

302: to_char(x_old_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
304: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
305: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
306: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
307: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
308: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));
309: end loop;
310: END show_po_details;

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

303: FND_FILE.PUT_LINE(FND_FILE.LOG,'new date: '||
304: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
305: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
306: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
307: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
308: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));
309: end loop;
310: END show_po_details;
311:

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

304: to_char(x_new_need_by_dates(i),'MM/DD/RR HH24:MI:SS'));
305: FND_FILE.PUT_LINE(FND_FILE.LOG,'header: '||x_po_header_id);
306: FND_FILE.PUT_LINE(FND_FILE.LOG,'line: '||x_po_line_ids(i));
307: FND_FILE.PUT_LINE(FND_FILE.LOG,'po number: '||x_po_number);
308: FND_FILE.PUT_LINE(FND_FILE.LOG,'shipment no: '||X_shipment_nums(i));
309: end loop;
310: END show_po_details;
311:
312: BEGIN

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

336: X_ship_methods);
337: Mo_Global.Set_Policy_Context (p_access_mode => l_access_mode,
338: p_org_id => l_current_org_id);
339: exception when others then
340: FND_FILE.PUT_LINE(FND_FILE.LOG,' error while calling po_reschedule_pkg.reschedule '||sqlerrm);
341: Mo_Global.Set_Policy_Context (p_access_mode => l_access_mode,
342: p_org_id => l_current_org_id);
343: show_po_details;
344: end;

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

343: show_po_details;
344: end;
345:
346: if p_result is null then
347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'the call to po_reschedule_pkg.reschedule return null value');
348: end if;
349:
350: p_result := nvl(p_result, false);
351:

Line 374: 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')||

370: 'MM/DD/RRRR HH24:MI') =
371: to_date(to_char(v_date, 'MM/DD/RRRR HH24:MI'),
372: 'MM/DD/RRRR HH24:MI') then
373: if x_old_need_by_dates(i) <> v_date then
374: 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')||
375: ' to '||to_char(v_date, 'MM/DD/RRRR HH24:MI:SS'));
376: v_old_need_by_dates(i) := v_date;
377: v_date_changed := true;
378: end if;

Line 403: FND_FILE.PUT_LINE(FND_FILE.LOG,'reschedule succeeds');

399: p_result := nvl(p_result, false);
400:
401: if p_result then
402: if p_show_msg = 'Y' then
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'reschedule succeeds');
404: end if;
405: else
406: FND_FILE.PUT_LINE(FND_FILE.LOG,'reschedule fails');
407: end if;

Line 406: FND_FILE.PUT_LINE(FND_FILE.LOG,'reschedule fails');

402: if p_show_msg = 'Y' then
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'reschedule succeeds');
404: end if;
405: else
406: FND_FILE.PUT_LINE(FND_FILE.LOG,'reschedule fails');
407: end if;
408:
409: if (p_result and p_show_msg = 'Y') or
410: not(p_result) then

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

412: end if;
413:
414: return p_result;
415: exception when others then
416: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in reschedule_po, error is: '||sqlerrm);
417: show_po_details;
418: return false;
419: END reschedule_po;
420: