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

Line 47: fnd_file.put_line(fnd_file.log, 'Launching SOP Fact Data Collect');

43: x_date_from varchar2(100);
44: x_date_to varchar2(100);
45:
46: BEGIN
47: fnd_file.put_line(fnd_file.log, 'Launching SOP Fact Data Collect');
48:
49: /* Bug # 4308790 ---- Always populate date range even though the range is null.
50: In case of null, we will use extremely small and large date
51: for the from date and to date ........... Amitku*/

Line 78: fnd_file.put_line(fnd_file.log, 'Booking Data Collect Launch Failed');

74:
75: COMMIT;
76:
77: IF l_request_id = 0 THEN
78: fnd_file.put_line(fnd_file.log, 'Booking Data Collect Launch Failed');
79: ELSE
80: fnd_file.put_line(fnd_file.log, 'Booking Data collect Request Id: '||l_request_id);
81: END IF;
82:

Line 80: fnd_file.put_line(fnd_file.log, 'Booking Data collect Request Id: '||l_request_id);

76:
77: IF l_request_id = 0 THEN
78: fnd_file.put_line(fnd_file.log, 'Booking Data Collect Launch Failed');
79: ELSE
80: fnd_file.put_line(fnd_file.log, 'Booking Data collect Request Id: '||l_request_id);
81: END IF;
82:
83: end if;
84:

Line 104: fnd_file.put_line(fnd_file.log, 'Shipment Data Collect Launch Failed');

100:
101: COMMIT;
102:
103: IF l_request_id = 0 THEN
104: fnd_file.put_line(fnd_file.log, 'Shipment Data Collect Launch Failed');
105: ELSE
106: fnd_file.put_line(fnd_file.log, 'Shipment Data collect Request Id: '||l_request_id);
107: END IF;
108:

Line 106: fnd_file.put_line(fnd_file.log, 'Shipment Data collect Request Id: '||l_request_id);

102:
103: IF l_request_id = 0 THEN
104: fnd_file.put_line(fnd_file.log, 'Shipment Data Collect Launch Failed');
105: ELSE
106: fnd_file.put_line(fnd_file.log, 'Shipment Data collect Request Id: '||l_request_id);
107: END IF;
108:
109: end if;
110:

Line 238: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Collect Launch Failed');

234:
235: COMMIT;
236:
237: IF l_request_id = 0 THEN
238: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Collect Launch Failed');
239: ELSE
240: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data collect Request Id: '||l_request_id);
241: END IF;
242:

Line 240: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data collect Request Id: '||l_request_id);

236:
237: IF l_request_id = 0 THEN
238: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Collect Launch Failed');
239: ELSE
240: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data collect Request Id: '||l_request_id);
241: END IF;
242:
243: end if;
244: end loop;

Line 249: fnd_file.put_line(fnd_file.log, 'Error in SOP Fact Data Collect Launch');

245: end if;
246:
247: EXCEPTION
248: WHEN OTHERS THEN
249: fnd_file.put_line(fnd_file.log, 'Error in SOP Fact Data Collect Launch');
250: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
251: retcode := -1;
252: raise;
253: end ;

Line 250: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

246:
247: EXCEPTION
248: WHEN OTHERS THEN
249: fnd_file.put_line(fnd_file.log, 'Error in SOP Fact Data Collect Launch');
250: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
251: retcode := -1;
252: raise;
253: end ;
254:

Line 278: fnd_file.put_line(fnd_file.log, 'Launching SOP Fact Data Pull');

274: l_request_id number;
275:
276: BEGIN
277: /* Pull SOP Fact data from staging table to fact table */
278: fnd_file.put_line(fnd_file.log, 'Launching SOP Fact Data Pull');
279:
280: /* Bug# 4867205 - Booking and Shipment Data will be collected separately
281:
282: -- Launch Booking Data Pull Process

Line 295: fnd_file.put_line(fnd_file.log, 'Booking Data Pull Launch Failed');

291: );
292: COMMIT;
293:
294: IF l_request_id = 0 THEN
295: fnd_file.put_line(fnd_file.log, 'Booking Data Pull Launch Failed');
296: ELSE
297: fnd_file.put_line(fnd_file.log, 'Booking Data Pull Request Id: '||l_request_id);
298: END IF;
299:

Line 297: fnd_file.put_line(fnd_file.log, 'Booking Data Pull Request Id: '||l_request_id);

293:
294: IF l_request_id = 0 THEN
295: fnd_file.put_line(fnd_file.log, 'Booking Data Pull Launch Failed');
296: ELSE
297: fnd_file.put_line(fnd_file.log, 'Booking Data Pull Request Id: '||l_request_id);
298: END IF;
299:
300: -- Launch Shipment Data Pull Process
301: l_request_id := 0;

Line 314: fnd_file.put_line(fnd_file.log, 'Shipment Data Pull Launch Failed');

310:
311: COMMIT;
312:
313: IF l_request_id = 0 THEN
314: fnd_file.put_line(fnd_file.log, 'Shipment Data Pull Launch Failed');
315: ELSE
316: fnd_file.put_line(fnd_file.log, 'Shipment Data Pull Request Id: '||l_request_id);
317: END IF;
318:

Line 316: fnd_file.put_line(fnd_file.log, 'Shipment Data Pull Request Id: '||l_request_id);

312:
313: IF l_request_id = 0 THEN
314: fnd_file.put_line(fnd_file.log, 'Shipment Data Pull Launch Failed');
315: ELSE
316: fnd_file.put_line(fnd_file.log, 'Shipment Data Pull Request Id: '||l_request_id);
317: END IF;
318:
319: */
320:

Line 343: -- fnd_file.put_line(fnd_file.log, 'CS Name: '||l_cs_name);

339: into l_cs_name_desc
340: from msd_cs_definitions
341: where cs_definition_id = l_cs_id(j).cs_definition_id;
342:
343: -- fnd_file.put_line(fnd_file.log, 'CS Name: '||l_cs_name);
344: -- fnd_file.put_line(fnd_file.log, 'CS Id: '||l_cs_id(j).cs_definition_id);
345:
346: select MSD_CS_COLL_REQUEST_S.nextval
347: into l_req_num

Line 344: -- fnd_file.put_line(fnd_file.log, 'CS Id: '||l_cs_id(j).cs_definition_id);

340: from msd_cs_definitions
341: where cs_definition_id = l_cs_id(j).cs_definition_id;
342:
343: -- fnd_file.put_line(fnd_file.log, 'CS Name: '||l_cs_name);
344: -- fnd_file.put_line(fnd_file.log, 'CS Id: '||l_cs_id(j).cs_definition_id);
345:
346: select MSD_CS_COLL_REQUEST_S.nextval
347: into l_req_num
348: from dual;

Line 373: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Pull Launch Failed');

369: NULL,
370: l_req_num );
371:
372: IF l_request_id = 0 THEN
373: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Pull Launch Failed');
374: ELSE
375: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Pull Request Id: '||l_request_id);
376: END IF;
377:

Line 375: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Pull Request Id: '||l_request_id);

371:
372: IF l_request_id = 0 THEN
373: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Pull Launch Failed');
374: ELSE
375: fnd_file.put_line(fnd_file.log, l_cs_name_desc||' Data Pull Request Id: '||l_request_id);
376: END IF;
377:
378: COMMIT;
379:

Line 386: fnd_file.put_line(fnd_file.log, 'Error in SOP Fact Data Pull Launch');

382: end if;
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: fnd_file.put_line(fnd_file.log, 'Error in SOP Fact Data Pull Launch');
387: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
388: retcode := -1;
389: raise;
390: end ;

Line 387: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: fnd_file.put_line(fnd_file.log, 'Error in SOP Fact Data Pull Launch');
387: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
388: retcode := -1;
389: raise;
390: end ;
391: