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

Line 186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '

182: l_conc_program_id := FND_GLOBAL.conc_program_id;
183:
184: l_stmt_num := 10;
185:
186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
187: ||to_char(l_request_id));
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
189: ||to_char(l_prog_app_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '

Line 188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '

184: l_stmt_num := 10;
185:
186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
187: ||to_char(l_request_id));
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
189: ||to_char(l_prog_app_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
191: ||to_char(l_user_id));
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '

Line 190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '

186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
187: ||to_char(l_request_id));
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
189: ||to_char(l_prog_app_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
191: ||to_char(l_user_id));
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
193: ||to_char(l_prog_id));
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '

Line 192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '

188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
189: ||to_char(l_prog_app_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
191: ||to_char(l_user_id));
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
193: ||to_char(l_prog_id));
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
195: ||to_char(l_login_id));
196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '

Line 194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '

190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
191: ||to_char(l_user_id));
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
193: ||to_char(l_prog_id));
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
195: ||to_char(l_login_id));
196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
197: ||to_char(l_conc_program_id));
198:

Line 196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '

192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
193: ||to_char(l_prog_id));
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
195: ||to_char(l_login_id));
196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
197: ||to_char(l_conc_program_id));
198:
199:
200: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
197: ||to_char(l_conc_program_id));
198:
199:
200: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
201:
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
203: ||TO_CHAR(p_org_id));
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Simulation Set: '

Line 202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '

198:
199:
200: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
201:
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
203: ||TO_CHAR(p_org_id));
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Simulation Set: '
205: ||p_simulation_set);
206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Run Option: '

Line 204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Simulation Set: '

200: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
201:
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
203: ||TO_CHAR(p_org_id));
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Simulation Set: '
205: ||p_simulation_set);
206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Run Option: '
207: ||TO_CHAR(p_run_option));
208: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Include Unreleased Order: '

Line 206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Run Option: '

202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
203: ||TO_CHAR(p_org_id));
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Simulation Set: '
205: ||p_simulation_set);
206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Run Option: '
207: ||TO_CHAR(p_run_option));
208: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Include Unreleased Order: '
209: ||TO_CHAR(p_include_unreleased));
210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Firm MaintenanceOder Only: '

Line 208: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Include Unreleased Order: '

204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Simulation Set: '
205: ||p_simulation_set);
206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Run Option: '
207: ||TO_CHAR(p_run_option));
208: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Include Unreleased Order: '
209: ||TO_CHAR(p_include_unreleased));
210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Firm MaintenanceOder Only: '
211: ||TO_CHAR(p_firm_order_only));
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Department: '

Line 210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Firm MaintenanceOder Only: '

206: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Run Option: '
207: ||TO_CHAR(p_run_option));
208: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Include Unreleased Order: '
209: ||TO_CHAR(p_include_unreleased));
210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Firm MaintenanceOder Only: '
211: ||TO_CHAR(p_firm_order_only));
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Department: '
213: ||TO_CHAR(p_department_id));
214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource: '

Line 212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Department: '

208: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Include Unreleased Order: '
209: ||TO_CHAR(p_include_unreleased));
210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Firm MaintenanceOder Only: '
211: ||TO_CHAR(p_firm_order_only));
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Department: '
213: ||TO_CHAR(p_department_id));
214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource: '
215: ||TO_CHAR(p_resource_id));
216:

Line 214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource: '

210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Firm MaintenanceOder Only: '
211: ||TO_CHAR(p_firm_order_only));
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Department: '
213: ||TO_CHAR(p_department_id));
214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource: '
215: ||TO_CHAR(p_resource_id));
216:
217:
218:

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Downtime Group Id: '

223: SELECT bom_resource_downtime_group_s.nextval
224: INTO l_downtime_group_id
225: FROM DUAL;
226: if G_DEBUG = 'Y' then
227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Downtime Group Id: '
228: ||TO_CHAR(l_downtime_group_id));
229: end if;
230:
231: IF p_run_option = 1 THEN

Line 286: FND_FILE.put_line(FND_FILE.log,l_err_msg);

282: l_err_msg :='EAM_Downtime_PUB.Process_Production_Downtime ('
283: || TO_CHAR(l_stmt_num)
284: || '):'
285: || l_err_code;
286: FND_FILE.put_line(FND_FILE.log,l_err_msg);
287:
288: conc_status := FND_CONCURRENT.set_completion_status('ERROR', l_err_msg);
289:
290: WHEN OTHERS THEN

Line 298: FND_FILE.put_line(FND_FILE.log,l_err_msg);

294: l_err_msg := SUBSTR('EAM_Downtime_PUB.Process_Production_Downtime ('
295: || TO_CHAR(l_stmt_num)
296: || '):'
297: || SQLERRM,1,240);
298: FND_FILE.put_line(FND_FILE.log,l_err_msg);
299:
300: conc_status := FND_CONCURRENT.set_completion_status('ERROR', l_err_msg);
301:
302: END Process_Production_Downtime;

Line 308: fnd_file.put_line(fnd_file.log, p_prompt||p_downtime.maint_org_id

304: procedure print_downtime(p_prompt in varchar2,
305: p_downtime in downtime_csr%rowtype) is
306: begin
307: IF G_DEBUG = 'Y' THEN
308: fnd_file.put_line(fnd_file.log, p_prompt||p_downtime.maint_org_id
309: || 'wip_entity_id:' ||p_downtime.wip_entity_id
310: || 'asset_group_id:' || p_downtime.asset_group_id
311: ||'asset_number:'||p_downtime.asset_number
312: ||'op_seq:'||p_downtime.op_seq

Line 347: fnd_file.put_line(fnd_file.log, 'Check if downtime overlaps shifts:p_from_date'||p_from_date||'p_from_time'||p_from_time||

343: from bom_shift_times
344: where calendar_code = p_calendar_code and shift_num = p_shift_num;
345:
346: IF G_DEBUG = 'Y' THEN
347: fnd_file.put_line(fnd_file.log, 'Check if downtime overlaps shifts:p_from_date'||p_from_date||'p_from_time'||p_from_time||
348: 'p_to_date:'||p_to_date||'p_to_time:'||p_to_time||'p_shift_num:'||p_shift_num||'l_from_time:'||l_from_time||
349: 'lto_time:'||l_to_time);
350: end if;
351:

Line 483: fnd_file.put_line(fnd_file.log,'In check_existence');

479: l_from_date_new date;
480: l_to_date_new date;
481: begin
482: IF G_DEBUG = 'Y' THEN
483: fnd_file.put_line(fnd_file.log,'In check_existence');
484: end if;
485:
486: p_out_to_update := FALSE;
487:

Line 520: fnd_file.put_line(fnd_file.log,'EXISTS');

516: and
517: (trunc(to_date)+(to_time/86400))));
518:
519: IF G_DEBUG = 'Y' THEN
520: fnd_file.put_line(fnd_file.log,'EXISTS');
521: end if;
522:
523: p_out_from_date := p_out_from_date_old;
524: p_out_from_time := p_out_from_time_old;

Line 538: fnd_file.put_line(fnd_file.log,'to be SKIPPED');

534: -- Both data time range is same.
535: -- hence no update and no insert is required.
536: p_out_to_update := FALSE; --to be skipped
537: IF G_DEBUG = 'Y' THEN
538: fnd_file.put_line(fnd_file.log,'to be SKIPPED');
539: end if;
540: return TRUE;
541: end if;
542:

Line 550: fnd_file.put_line(fnd_file.log,'Old from date : '||to_char(l_from_date_old,'DD-MON-YYYY HH24:MI:SS'));

546: p_out_from_date := p_from_date;
547: p_out_from_time := p_from_time;
548: p_out_to_update := TRUE;
549: IF G_DEBUG = 'Y' THEN
550: fnd_file.put_line(fnd_file.log,'Old from date : '||to_char(l_from_date_old,'DD-MON-YYYY HH24:MI:SS'));
551: fnd_file.put_line(fnd_file.log,'New from date : '||to_char(l_from_date_new,'DD-MON-YYYY HH24:MI:SS'));
552: end if;
553:
554: end if;

Line 551: fnd_file.put_line(fnd_file.log,'New from date : '||to_char(l_from_date_new,'DD-MON-YYYY HH24:MI:SS'));

547: p_out_from_time := p_from_time;
548: p_out_to_update := TRUE;
549: IF G_DEBUG = 'Y' THEN
550: fnd_file.put_line(fnd_file.log,'Old from date : '||to_char(l_from_date_old,'DD-MON-YYYY HH24:MI:SS'));
551: fnd_file.put_line(fnd_file.log,'New from date : '||to_char(l_from_date_new,'DD-MON-YYYY HH24:MI:SS'));
552: end if;
553:
554: end if;
555: if ( l_to_date_new > l_to_date_old ) then

Line 560: fnd_file.put_line(fnd_file.log,'Old to date : '||to_char(l_to_date_old,'DD-MON-YYYY HH24:MI:SS'));

556: p_out_to_date := p_to_date;
557: p_out_to_time := p_to_time;
558: p_out_to_update := TRUE;
559: IF G_DEBUG = 'Y' THEN
560: fnd_file.put_line(fnd_file.log,'Old to date : '||to_char(l_to_date_old,'DD-MON-YYYY HH24:MI:SS'));
561: fnd_file.put_line(fnd_file.log,'New to date : '||to_char(l_to_date_new,'DD-MON-YYYY HH24:MI:SS'));
562: end if;
563:
564: end if;

Line 561: fnd_file.put_line(fnd_file.log,'New to date : '||to_char(l_to_date_new,'DD-MON-YYYY HH24:MI:SS'));

557: p_out_to_time := p_to_time;
558: p_out_to_update := TRUE;
559: IF G_DEBUG = 'Y' THEN
560: fnd_file.put_line(fnd_file.log,'Old to date : '||to_char(l_to_date_old,'DD-MON-YYYY HH24:MI:SS'));
561: fnd_file.put_line(fnd_file.log,'New to date : '||to_char(l_to_date_new,'DD-MON-YYYY HH24:MI:SS'));
562: end if;
563:
564: end if;
565: return TRUE;

Line 569: fnd_file.put_line(fnd_file.log,'In check_existence : DOES NOT EXIST');

565: return TRUE;
566: exception
567: when no_data_found then
568: IF G_DEBUG = 'Y' THEN
569: fnd_file.put_line(fnd_file.log,'In check_existence : DOES NOT EXIST');
570: end if;
571: p_out_to_update := FALSE;
572: return FALSE;
573: end check_existence;

Line 641: fnd_file.put_line(fnd_file.log,'In break_and_insert ');

637: l_out_to_time_old number;
638:
639: begin
640: IF G_DEBUG = 'Y' THEN
641: fnd_file.put_line(fnd_file.log,'In break_and_insert ');
642: fnd_file.put_line(fnd_file.log,'p_from_date '||p_from_date);
643: fnd_file.put_line(fnd_file.log,'p_from_time '||p_from_time);
644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);
645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);

Line 642: fnd_file.put_line(fnd_file.log,'p_from_date '||p_from_date);

638:
639: begin
640: IF G_DEBUG = 'Y' THEN
641: fnd_file.put_line(fnd_file.log,'In break_and_insert ');
642: fnd_file.put_line(fnd_file.log,'p_from_date '||p_from_date);
643: fnd_file.put_line(fnd_file.log,'p_from_time '||p_from_time);
644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);
645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);
646: fnd_file.put_line(fnd_file.log,'p_shift_num '||p_shift_num);

Line 643: fnd_file.put_line(fnd_file.log,'p_from_time '||p_from_time);

639: begin
640: IF G_DEBUG = 'Y' THEN
641: fnd_file.put_line(fnd_file.log,'In break_and_insert ');
642: fnd_file.put_line(fnd_file.log,'p_from_date '||p_from_date);
643: fnd_file.put_line(fnd_file.log,'p_from_time '||p_from_time);
644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);
645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);
646: fnd_file.put_line(fnd_file.log,'p_shift_num '||p_shift_num);
647: fnd_file.put_line(fnd_file.log,'p_calendar_code '||p_calendar_code);

Line 644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);

640: IF G_DEBUG = 'Y' THEN
641: fnd_file.put_line(fnd_file.log,'In break_and_insert ');
642: fnd_file.put_line(fnd_file.log,'p_from_date '||p_from_date);
643: fnd_file.put_line(fnd_file.log,'p_from_time '||p_from_time);
644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);
645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);
646: fnd_file.put_line(fnd_file.log,'p_shift_num '||p_shift_num);
647: fnd_file.put_line(fnd_file.log,'p_calendar_code '||p_calendar_code);
648: fnd_file.put_line(fnd_file.log,'p_exception_set_id '||p_exception_set_id);

Line 645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);

641: fnd_file.put_line(fnd_file.log,'In break_and_insert ');
642: fnd_file.put_line(fnd_file.log,'p_from_date '||p_from_date);
643: fnd_file.put_line(fnd_file.log,'p_from_time '||p_from_time);
644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);
645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);
646: fnd_file.put_line(fnd_file.log,'p_shift_num '||p_shift_num);
647: fnd_file.put_line(fnd_file.log,'p_calendar_code '||p_calendar_code);
648: fnd_file.put_line(fnd_file.log,'p_exception_set_id '||p_exception_set_id);
649: END IF;

Line 646: fnd_file.put_line(fnd_file.log,'p_shift_num '||p_shift_num);

642: fnd_file.put_line(fnd_file.log,'p_from_date '||p_from_date);
643: fnd_file.put_line(fnd_file.log,'p_from_time '||p_from_time);
644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);
645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);
646: fnd_file.put_line(fnd_file.log,'p_shift_num '||p_shift_num);
647: fnd_file.put_line(fnd_file.log,'p_calendar_code '||p_calendar_code);
648: fnd_file.put_line(fnd_file.log,'p_exception_set_id '||p_exception_set_id);
649: END IF;
650:

Line 647: fnd_file.put_line(fnd_file.log,'p_calendar_code '||p_calendar_code);

643: fnd_file.put_line(fnd_file.log,'p_from_time '||p_from_time);
644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);
645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);
646: fnd_file.put_line(fnd_file.log,'p_shift_num '||p_shift_num);
647: fnd_file.put_line(fnd_file.log,'p_calendar_code '||p_calendar_code);
648: fnd_file.put_line(fnd_file.log,'p_exception_set_id '||p_exception_set_id);
649: END IF;
650:
651: for wd in c_wdays loop

Line 648: fnd_file.put_line(fnd_file.log,'p_exception_set_id '||p_exception_set_id);

644: fnd_file.put_line(fnd_file.log,'p_to_date '||p_to_date);
645: fnd_file.put_line(fnd_file.log,'p_to_time '||p_to_time);
646: fnd_file.put_line(fnd_file.log,'p_shift_num '||p_shift_num);
647: fnd_file.put_line(fnd_file.log,'p_calendar_code '||p_calendar_code);
648: fnd_file.put_line(fnd_file.log,'p_exception_set_id '||p_exception_set_id);
649: END IF;
650:
651: for wd in c_wdays loop
652:

Line 668: fnd_file.put_line(fnd_file.log,'p_from: '||to_char(p_from_date,'DD-MM-YYYY ')||to_char(to_date(p_from_time,'SSSSS'),'HH24:MI:SS'));

664: l_shift_from_time := wd.from_time;
665: l_shift_to_time := wd.to_time;
666:
667: IF G_DEBUG = 'Y' THEN
668: fnd_file.put_line(fnd_file.log,'p_from: '||to_char(p_from_date,'DD-MM-YYYY ')||to_char(to_date(p_from_time,'SSSSS'),'HH24:MI:SS'));
669: fnd_file.put_line(fnd_file.log,'l_from: '||to_char(l_shift_from_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_from_time,'SSSSS'),'HH24:MI:SS'));
670: fnd_file.put_line(fnd_file.log,'p_to: '||to_char(p_to_date,'DD-MM-YYYY ')||to_char(to_date(p_to_time,'SSSSS'),'HH24:MI:SS'));
671: fnd_file.put_line(fnd_file.log,'l_to: '||to_char(l_shift_to_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_to_time,'SSSSS'),'HH24:MI:SS'));
672: end if;

Line 669: fnd_file.put_line(fnd_file.log,'l_from: '||to_char(l_shift_from_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_from_time,'SSSSS'),'HH24:MI:SS'));

665: l_shift_to_time := wd.to_time;
666:
667: IF G_DEBUG = 'Y' THEN
668: fnd_file.put_line(fnd_file.log,'p_from: '||to_char(p_from_date,'DD-MM-YYYY ')||to_char(to_date(p_from_time,'SSSSS'),'HH24:MI:SS'));
669: fnd_file.put_line(fnd_file.log,'l_from: '||to_char(l_shift_from_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_from_time,'SSSSS'),'HH24:MI:SS'));
670: fnd_file.put_line(fnd_file.log,'p_to: '||to_char(p_to_date,'DD-MM-YYYY ')||to_char(to_date(p_to_time,'SSSSS'),'HH24:MI:SS'));
671: fnd_file.put_line(fnd_file.log,'l_to: '||to_char(l_shift_to_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_to_time,'SSSSS'),'HH24:MI:SS'));
672: end if;
673:

Line 670: fnd_file.put_line(fnd_file.log,'p_to: '||to_char(p_to_date,'DD-MM-YYYY ')||to_char(to_date(p_to_time,'SSSSS'),'HH24:MI:SS'));

666:
667: IF G_DEBUG = 'Y' THEN
668: fnd_file.put_line(fnd_file.log,'p_from: '||to_char(p_from_date,'DD-MM-YYYY ')||to_char(to_date(p_from_time,'SSSSS'),'HH24:MI:SS'));
669: fnd_file.put_line(fnd_file.log,'l_from: '||to_char(l_shift_from_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_from_time,'SSSSS'),'HH24:MI:SS'));
670: fnd_file.put_line(fnd_file.log,'p_to: '||to_char(p_to_date,'DD-MM-YYYY ')||to_char(to_date(p_to_time,'SSSSS'),'HH24:MI:SS'));
671: fnd_file.put_line(fnd_file.log,'l_to: '||to_char(l_shift_to_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_to_time,'SSSSS'),'HH24:MI:SS'));
672: end if;
673:
674: l_to_insert := FALSE;

Line 671: fnd_file.put_line(fnd_file.log,'l_to: '||to_char(l_shift_to_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_to_time,'SSSSS'),'HH24:MI:SS'));

667: IF G_DEBUG = 'Y' THEN
668: fnd_file.put_line(fnd_file.log,'p_from: '||to_char(p_from_date,'DD-MM-YYYY ')||to_char(to_date(p_from_time,'SSSSS'),'HH24:MI:SS'));
669: fnd_file.put_line(fnd_file.log,'l_from: '||to_char(l_shift_from_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_from_time,'SSSSS'),'HH24:MI:SS'));
670: fnd_file.put_line(fnd_file.log,'p_to: '||to_char(p_to_date,'DD-MM-YYYY ')||to_char(to_date(p_to_time,'SSSSS'),'HH24:MI:SS'));
671: fnd_file.put_line(fnd_file.log,'l_to: '||to_char(l_shift_to_date,'DD-MM-YYYY ')||to_char(to_date(l_shift_to_time,'SSSSS'),'HH24:MI:SS'));
672: end if;
673:
674: l_to_insert := FALSE;
675: l_out_to_update := FALSE;

Line 709: fnd_file.put_line(fnd_file.log,'Checking existence-'||'dept:'||p_downtime_row.department_id||', resc:'||p_downtime_row.resource_id||

705:
706:
707: -- Bug # 3787120 : Check if the record exists alread
708: IF G_DEBUG = 'Y' THEN
709: fnd_file.put_line(fnd_file.log,'Checking existence-'||'dept:'||p_downtime_row.department_id||', resc:'||p_downtime_row.resource_id||
710: ', shift num:'||p_shift_num||', sim set:'||p_simulation_set||', from:'||l_from_date||to_char(to_date(l_from_time,'SSSSS'),' HH24:MI:SS')||
711: ',to '||l_to_date||to_char(to_date(l_to_time,'SSSSS'),' HH24:MI:SS')||', instance id:'||p_downtime_row.instance_id||', serial no:'||p_downtime_row.eqp_serial_number);
712: END IF;
713:

Line 740: fnd_file.put_line(fnd_file.log,'To be inserted');

736: end if;
737:
738: if G_DEBUG = 'Y' THEN
739: if l_to_insert = TRUE then
740: fnd_file.put_line(fnd_file.log,'To be inserted');
741: end if;
742: if l_out_to_update = TRUE then
743: fnd_file.put_line(fnd_file.log,'To be updated');
744: end if;

Line 743: fnd_file.put_line(fnd_file.log,'To be updated');

739: if l_to_insert = TRUE then
740: fnd_file.put_line(fnd_file.log,'To be inserted');
741: end if;
742: if l_out_to_update = TRUE then
743: fnd_file.put_line(fnd_file.log,'To be updated');
744: end if;
745: end if;
746:
747: if ( l_to_insert = TRUE and l_out_to_update = FALSE ) then

Line 749: fnd_file.put_line(fnd_file.log,'Inserting from '||l_from_date||to_char(to_date(l_from_time,'SSSSS'),' HH24:MI:SS')||

745: end if;
746:
747: if ( l_to_insert = TRUE and l_out_to_update = FALSE ) then
748: if G_DEBUG = 'Y' THEN
749: fnd_file.put_line(fnd_file.log,'Inserting from '||l_from_date||to_char(to_date(l_from_time,'SSSSS'),' HH24:MI:SS')||
750: ' to '||l_to_date||to_char(to_date(l_to_time,'SSSSS'),' HH24:MI:SS'));
751: end if;
752:
753: insert into bom_res_instance_changes(

Line 832: fnd_file.put_line(fnd_file.log,'Updating...');

828: end if;
829:
830: if ( l_out_to_update = TRUE and l_to_insert = FALSE ) then
831: if G_DEBUG = 'Y' THEN
832: fnd_file.put_line(fnd_file.log,'Updating...');
833: end if;
834:
835: update bom_res_instance_changes
836: set from_date = l_out_from_date,

Line 897: fnd_file.put_line(fnd_file.log, 'Now:table in_len:'||p_in_len||'table out_len:'||l_out_len);

893: merge_table(p_in_downtime_tbl, p_in_len, l_out_downtime_tbl);
894: --now, processing data
895: l_out_len := l_out_downtime_tbl.count;
896: IF G_DEBUG = 'Y' THEN
897: fnd_file.put_line(fnd_file.log, 'Now:table in_len:'||p_in_len||'table out_len:'||l_out_len);
898: end if;
899: j := 0;
900: while j < l_out_len loop
901: print_downtime('out_table row', l_out_downtime_tbl(j));

Line 903: fnd_file.put_line(fnd_file.log,'p_calendar_code: '||p_calendar_code);

899: j := 0;
900: while j < l_out_len loop
901: print_downtime('out_table row', l_out_downtime_tbl(j));
902: IF G_DEBUG = 'Y' THEN
903: fnd_file.put_line(fnd_file.log,'p_calendar_code: '||p_calendar_code);
904: fnd_file.put_line(fnd_file.log,'p_exception_set_id: '||p_exception_set_id);
905: fnd_file.put_line(fnd_file.log,'department_id: '||l_out_downtime_tbl(j).department_id);
906: fnd_file.put_line(fnd_file.log,'resource_id: '||l_out_downtime_tbl(j).resource_id);
907: fnd_file.put_line(fnd_file.log,'from_date: '||l_out_downtime_tbl(j).from_date);

Line 904: fnd_file.put_line(fnd_file.log,'p_exception_set_id: '||p_exception_set_id);

900: while j < l_out_len loop
901: print_downtime('out_table row', l_out_downtime_tbl(j));
902: IF G_DEBUG = 'Y' THEN
903: fnd_file.put_line(fnd_file.log,'p_calendar_code: '||p_calendar_code);
904: fnd_file.put_line(fnd_file.log,'p_exception_set_id: '||p_exception_set_id);
905: fnd_file.put_line(fnd_file.log,'department_id: '||l_out_downtime_tbl(j).department_id);
906: fnd_file.put_line(fnd_file.log,'resource_id: '||l_out_downtime_tbl(j).resource_id);
907: fnd_file.put_line(fnd_file.log,'from_date: '||l_out_downtime_tbl(j).from_date);
908: fnd_file.put_line(fnd_file.log,'to_date: '||l_out_downtime_tbl(j).to_date);

Line 905: fnd_file.put_line(fnd_file.log,'department_id: '||l_out_downtime_tbl(j).department_id);

901: print_downtime('out_table row', l_out_downtime_tbl(j));
902: IF G_DEBUG = 'Y' THEN
903: fnd_file.put_line(fnd_file.log,'p_calendar_code: '||p_calendar_code);
904: fnd_file.put_line(fnd_file.log,'p_exception_set_id: '||p_exception_set_id);
905: fnd_file.put_line(fnd_file.log,'department_id: '||l_out_downtime_tbl(j).department_id);
906: fnd_file.put_line(fnd_file.log,'resource_id: '||l_out_downtime_tbl(j).resource_id);
907: fnd_file.put_line(fnd_file.log,'from_date: '||l_out_downtime_tbl(j).from_date);
908: fnd_file.put_line(fnd_file.log,'to_date: '||l_out_downtime_tbl(j).to_date);
909: end if;

Line 906: fnd_file.put_line(fnd_file.log,'resource_id: '||l_out_downtime_tbl(j).resource_id);

902: IF G_DEBUG = 'Y' THEN
903: fnd_file.put_line(fnd_file.log,'p_calendar_code: '||p_calendar_code);
904: fnd_file.put_line(fnd_file.log,'p_exception_set_id: '||p_exception_set_id);
905: fnd_file.put_line(fnd_file.log,'department_id: '||l_out_downtime_tbl(j).department_id);
906: fnd_file.put_line(fnd_file.log,'resource_id: '||l_out_downtime_tbl(j).resource_id);
907: fnd_file.put_line(fnd_file.log,'from_date: '||l_out_downtime_tbl(j).from_date);
908: fnd_file.put_line(fnd_file.log,'to_date: '||l_out_downtime_tbl(j).to_date);
909: end if;
910: for a_shift in shift_csr(l_out_downtime_tbl(j).department_id, l_out_downtime_tbl(j).resource_id,

Line 907: fnd_file.put_line(fnd_file.log,'from_date: '||l_out_downtime_tbl(j).from_date);

903: fnd_file.put_line(fnd_file.log,'p_calendar_code: '||p_calendar_code);
904: fnd_file.put_line(fnd_file.log,'p_exception_set_id: '||p_exception_set_id);
905: fnd_file.put_line(fnd_file.log,'department_id: '||l_out_downtime_tbl(j).department_id);
906: fnd_file.put_line(fnd_file.log,'resource_id: '||l_out_downtime_tbl(j).resource_id);
907: fnd_file.put_line(fnd_file.log,'from_date: '||l_out_downtime_tbl(j).from_date);
908: fnd_file.put_line(fnd_file.log,'to_date: '||l_out_downtime_tbl(j).to_date);
909: end if;
910: for a_shift in shift_csr(l_out_downtime_tbl(j).department_id, l_out_downtime_tbl(j).resource_id,
911: l_out_downtime_tbl(j).from_date, l_out_downtime_tbl(j).to_date) loop

Line 908: fnd_file.put_line(fnd_file.log,'to_date: '||l_out_downtime_tbl(j).to_date);

904: fnd_file.put_line(fnd_file.log,'p_exception_set_id: '||p_exception_set_id);
905: fnd_file.put_line(fnd_file.log,'department_id: '||l_out_downtime_tbl(j).department_id);
906: fnd_file.put_line(fnd_file.log,'resource_id: '||l_out_downtime_tbl(j).resource_id);
907: fnd_file.put_line(fnd_file.log,'from_date: '||l_out_downtime_tbl(j).from_date);
908: fnd_file.put_line(fnd_file.log,'to_date: '||l_out_downtime_tbl(j).to_date);
909: end if;
910: for a_shift in shift_csr(l_out_downtime_tbl(j).department_id, l_out_downtime_tbl(j).resource_id,
911: l_out_downtime_tbl(j).from_date, l_out_downtime_tbl(j).to_date) loop
912: -- start_date

Line 915: fnd_file.put_line(fnd_file.log, 'shift_num:'||a_shift.shift_num);

911: l_out_downtime_tbl(j).from_date, l_out_downtime_tbl(j).to_date) loop
912: -- start_date
913: -- start_seq is null->off date->move to next date, time=60
914: IF G_DEBUG = 'Y' THEN
915: fnd_file.put_line(fnd_file.log, 'shift_num:'||a_shift.shift_num);
916: end if;
917: if a_shift.start_seq is null then
918: l_from_date := a_shift.next_date;
919: l_from_time := 60;

Line 1009: FND_FILE.put_line(FND_FILE.log, i ||'-'||l_msg_data);

1005: IF(l_msg_count > 0) THEN
1006: FOR i in 1 ..l_msg_count
1007: LOOP
1008: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);
1009: FND_FILE.put_line(FND_FILE.log, i ||'-'||l_msg_data);
1010: END LOOP;
1011: END IF;
1012:
1013: EXCEPTION

Line 1016: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('

1012:
1013: EXCEPTION
1014: WHEN FND_API.g_exc_error THEN
1015: x_return_status := FND_API.g_ret_sts_error;
1016: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('
1017: || l_stmt_num
1018: || '): '
1019: || x_return_status
1020: || substr(SQLERRM,1,200));

Line 1023: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('

1019: || x_return_status
1020: || substr(SQLERRM,1,200));
1021: WHEN FND_API.g_exc_unexpected_error THEN
1022: x_return_status := FND_API.g_ret_sts_unexp_error;
1023: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('
1024: || l_stmt_num
1025: || '): '
1026: || x_return_status
1027: || substr(SQLERRM,1,200));

Line 1030: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('

1026: || x_return_status
1027: || substr(SQLERRM,1,200));
1028: WHEN others THEN
1029: x_return_status := FND_API.g_ret_sts_unexp_error;
1030: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('
1031: || l_stmt_num
1032: || '): '
1033: || x_return_status
1034: || substr(SQLERRM,1,200));

Line 1118: fnd_file.put_line(fnd_file.log, 'about to enter, p_department_id:'||p_department_id||'resource_id:'||p_resource_id||'p_group_id:'||p_downtime_group_id

1114:
1115:
1116: i := 0;
1117: IF G_DEBUG = 'Y' THEN
1118: fnd_file.put_line(fnd_file.log, 'about to enter, p_department_id:'||p_department_id||'resource_id:'||p_resource_id||'p_group_id:'||p_downtime_group_id
1119: ||'calendar_code:'||p_calendar_code||'exception_set_id:'||p_exception_set_id);
1120: fnd_file.put_line(fnd_file.log, 'organization' ||p_org_id);
1121: end if;
1122:

Line 1120: fnd_file.put_line(fnd_file.log, 'organization' ||p_org_id);

1116: i := 0;
1117: IF G_DEBUG = 'Y' THEN
1118: fnd_file.put_line(fnd_file.log, 'about to enter, p_department_id:'||p_department_id||'resource_id:'||p_resource_id||'p_group_id:'||p_downtime_group_id
1119: ||'calendar_code:'||p_calendar_code||'exception_set_id:'||p_exception_set_id);
1120: fnd_file.put_line(fnd_file.log, 'organization' ||p_org_id);
1121: end if;
1122:
1123: for a_downtime in downtime_csr(p_org_id, p_department_id, p_resource_id,
1124: p_include_unreleased, p_firm_order_only) loop

Line 1129: fnd_file.put_line(fnd_file.log,'wip_entity_id:' ||a_downtime.wip_entity_id

1125:
1126: -- do nothing
1127: -- Only called the first time entering the loop
1128: IF G_DEBUG = 'Y' THEN
1129: fnd_file.put_line(fnd_file.log,'wip_entity_id:' ||a_downtime.wip_entity_id
1130: || 'asset_group_id:' || a_downtime.asset_group_id
1131: ||'asset_number:'||a_downtime.asset_number
1132: ||'op_seq:'||a_downtime.op_seq
1133: ||'from_date:'||a_downtime.from_date

Line 1259: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('

1255: commit;
1256: EXCEPTION
1257: WHEN FND_API.g_exc_error THEN
1258: x_return_status := FND_API.g_ret_sts_error;
1259: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('
1260: || l_stmt_num
1261: || '): '
1262: || x_return_status
1263: || substr(SQLERRM,1,200));

Line 1267: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('

1263: || substr(SQLERRM,1,200));
1264: WHEN FND_API.g_exc_unexpected_error THEN
1265: Rollback to LoadDowntime_PUB; -- roll back data when unexpected errors happens
1266: x_return_status := FND_API.g_ret_sts_unexp_error;
1267: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('
1268: || l_stmt_num
1269: || '): '
1270: || x_return_status
1271: || substr(SQLERRM,1,200));

Line 1275: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('

1271: || substr(SQLERRM,1,200));
1272: WHEN others THEN
1273: Rollback to LoadDowntime_PUB; -- roll back data when unexpected errors happens
1274: x_return_status := FND_API.g_ret_sts_unexp_error;
1275: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('
1276: -- dbms_output.put_line('EAM_Downtime_PUB.LoadDowntime('
1277: || l_stmt_num
1278: || '): '
1279: || x_return_status

Line 1350: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('

1346: EXCEPTION
1347: WHEN FND_API.g_exc_error THEN
1348: ROLLBACK to purgedowntime_pub;
1349: x_return_status := FND_API.g_ret_sts_error;
1350: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('
1351: || l_stmt_num
1352: || '): '
1353: || x_return_status
1354: || substr(SQLERRM,1,200));

Line 1358: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('

1354: || substr(SQLERRM,1,200));
1355: WHEN FND_API.g_exc_unexpected_error THEN
1356: ROLLBACK to purgedowntime_pub;
1357: x_return_status := FND_API.g_ret_sts_unexp_error;
1358: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('
1359: || l_stmt_num
1360: || '): '
1361: || x_return_status
1362: || substr(SQLERRM,1,200));

Line 1366: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('

1362: || substr(SQLERRM,1,200));
1363: WHEN others THEN
1364: ROLLBACK to purgedowntime_pub;
1365: x_return_status := FND_API.g_ret_sts_unexp_error;
1366: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('
1367: || l_stmt_num
1368: || '): '
1369: || x_return_status
1370: || substr(SQLERRM,1,200));