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_MATERIAL_REQUEST_PVT dependencies on FND_FILE

Line 378: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

374: l_plan_tasks:= FALSE;
375: end if;
376:
377: fnd_message.set_name('FND', 'CONC-PARAMETERS');
378: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
379:
380: select meaning
381: into l_outBuffer
382: from mfg_lookups

Line 387: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

383: where lookup_type = 'SYS_YES_NO'
384: and lookup_code = p_use_pickset_indicator;
385:
386: fnd_message.set_name('WIP', 'WIP_PICKING_USE_PICKSETS');
387: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
388: /* Added as part of Enhancement#2578514*/
389: select meaning
390: into l_outBuffer
391: from mfg_lookups

Line 396: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

392: where lookup_type = 'SYS_YES_NO'
393: and lookup_code = p_print_pickslips;
394:
395: fnd_message.set_name('WIP', 'WIP_PICKING_PRINT_PICKSLIPS');
396: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
397: /* Added as part of Enhancement#2578514*/
398: if(p_pick_grouping_rule_id IS NOT NULL) then
399: select name
400: into l_outBuffer

Line 405: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

401: from wsh_pick_grouping_rules
402: where pick_grouping_rule_id = p_pick_grouping_rule_id;
403:
404: fnd_message.set_name('WIP', 'WIP_PICKING_PICK_GROUPING_RULE');
405: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
406: end if;
407:
408: /* Added as part of Enhancement#2578514*/
409: select meaning

Line 416: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

412: where lookup_type = 'SYS_YES_NO'
413: and lookup_code = p_plan_tasks;
414:
415: fnd_message.set_name('WIP', 'WIP_PICKING_PLAN_TASKS');
416: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
417:
418: select organization_code
419: into l_outBuffer
420: from MTL_PARAMETERS

Line 424: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

420: from MTL_PARAMETERS
421: where organization_id = p_organization_id;
422:
423: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
424: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
425:
426: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
427: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
428:

Line 427: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);

423: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
424: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
425:
426: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
427: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
428:
429: select meaning
430: into l_outBuffer
431: from mfg_lookups

Line 436: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

432: where lookup_type = 'WIP_ENTITY'
433: and lookup_code = p_wip_entity_type;
434:
435: fnd_message.set_name('WIP', 'WIP_PICKING_MFG_MODE');
436: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
437:
438:
439: /* Bug 6046963: Added below if to print job type parameter in case of Discrete Job Comp Pick Release request only*/
440:

Line 450: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

446: where lookup_type = 'WIP_ENTITIES'
447: and lookup_code = p_job_type ;
448:
449: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');
450: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
451: --End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type
452: end if;
453:
454: fnd_file.put_line(which => fnd_file.output, buff => '');

Line 454: fnd_file.put_line(which => fnd_file.output, buff => '');

450: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
451: --End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type
452: end if;
453:
454: fnd_file.put_line(which => fnd_file.output, buff => '');
455: fnd_file.put_line(which => fnd_file.output, buff => '');
456:
457: LOOP
458:

Line 455: fnd_file.put_line(which => fnd_file.output, buff => '');

451: --End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type
452: end if;
453:
454: fnd_file.put_line(which => fnd_file.output, buff => '');
455: fnd_file.put_line(which => fnd_file.output, buff => '');
456:
457: LOOP
458:
459: IF(p_wip_entity_type = wip_constants.eam) THEN

Line 465: fnd_file.put_line(which => fnd_file.output, buff => l_outBuffer);

461: fetch c_eam_jobs into l_wipEntityID, l_outBuffer,l_op_seq,l_inv_item_id, l_projectID, l_taskID, l_eam_wro_date_req, l_requested_qty;
462: exit when c_eam_jobs%NOTFOUND;
463: end if;
464:
465: fnd_file.put_line(which => fnd_file.output, buff => l_outBuffer);
466: --Added for eAM Enhancement 13608137
467: if(p_wip_entity_type = wip_constants.eam) THEN
468: eam_i := eam_i + 1;
469: l_alloc_comp_tbl_t(eam_i).wip_entity_id := l_wipEntityID;

Line 507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

503:
504: if(l_returnStatus = 'P') then
505: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
506: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');

Line 509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

505: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
506: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
512: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

Line 513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
512: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
514: end if;
515:
516: elsif(l_returnStatus = 'S') then
517: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');

Line 519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

515:
516: elsif(l_returnStatus = 'S') then
517: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
518: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
520: if(l_print_pickslips = 'T') then
521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

Line 523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
520: if(l_print_pickslips = 'T') then
521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
524: end if;
525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
527:

Line 526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
524: end if;
525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
527:
528: elsif(l_returnStatus = 'N') then
529: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

Line 530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
527:
528: elsif(l_returnStatus = 'N') then
529: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
531:
532: else
533: fnd_file.put_line(which => fnd_file.output, buff => '');
534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');

Line 533: fnd_file.put_line(which => fnd_file.output, buff => '');

529: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
531:
532: else
533: fnd_file.put_line(which => fnd_file.output, buff => '');
534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
535: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
536: fnd_file.put_line(which => fnd_file.output,
537: buff => 'Returned status: ' || l_returnStatus);

Line 535: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

531:
532: else
533: fnd_file.put_line(which => fnd_file.output, buff => '');
534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
535: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
536: fnd_file.put_line(which => fnd_file.output,
537: buff => 'Returned status: ' || l_returnStatus);
538: fnd_file.put_line(which => fnd_file.output,
539: buff => 'Returned message: ' || errbuf);

Line 536: fnd_file.put_line(which => fnd_file.output,

532: else
533: fnd_file.put_line(which => fnd_file.output, buff => '');
534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
535: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
536: fnd_file.put_line(which => fnd_file.output,
537: buff => 'Returned status: ' || l_returnStatus);
538: fnd_file.put_line(which => fnd_file.output,
539: buff => 'Returned message: ' || errbuf);
540: fnd_file.put_line(which => fnd_file.output,

Line 538: fnd_file.put_line(which => fnd_file.output,

534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
535: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
536: fnd_file.put_line(which => fnd_file.output,
537: buff => 'Returned status: ' || l_returnStatus);
538: fnd_file.put_line(which => fnd_file.output,
539: buff => 'Returned message: ' || errbuf);
540: fnd_file.put_line(which => fnd_file.output,
541: buff => 'Parameters passed to allocate():');
542: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||

Line 540: fnd_file.put_line(which => fnd_file.output,

536: fnd_file.put_line(which => fnd_file.output,
537: buff => 'Returned status: ' || l_returnStatus);
538: fnd_file.put_line(which => fnd_file.output,
539: buff => 'Returned message: ' || errbuf);
540: fnd_file.put_line(which => fnd_file.output,
541: buff => 'Parameters passed to allocate():');
542: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||
543: p_days_to_alloc || ';p_days_forward=' || p_days_forward ||
544: ';p_wip_entity_type=' || p_wip_entity_type || ';p_organization_id=' ||

Line 542: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||

538: fnd_file.put_line(which => fnd_file.output,
539: buff => 'Returned message: ' || errbuf);
540: fnd_file.put_line(which => fnd_file.output,
541: buff => 'Parameters passed to allocate():');
542: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||
543: p_days_to_alloc || ';p_days_forward=' || p_days_forward ||
544: ';p_wip_entity_type=' || p_wip_entity_type || ';p_organization_id=' ||
545: p_organization_id || ';p_pick_grouping_rule_id=' || p_pick_grouping_rule_id
546: || ';l_print_pickslips=' || l_print_pickslips );

Line 558: fnd_file.put_line(which => fnd_file.output, buff => '');

554: exception
555: when others then
556: errbuf := SQLERRM;
557: retcode := 2;
558: fnd_file.put_line(which => fnd_file.output, buff => '');
559: fnd_file.put_line(which => fnd_file.output, buff => '');
560: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
562: for i in 1..l_msgCount loop

Line 559: fnd_file.put_line(which => fnd_file.output, buff => '');

555: when others then
556: errbuf := SQLERRM;
557: retcode := 2;
558: fnd_file.put_line(which => fnd_file.output, buff => '');
559: fnd_file.put_line(which => fnd_file.output, buff => '');
560: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
562: for i in 1..l_msgCount loop
563: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));

Line 561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

557: retcode := 2;
558: fnd_file.put_line(which => fnd_file.output, buff => '');
559: fnd_file.put_line(which => fnd_file.output, buff => '');
560: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
562: for i in 1..l_msgCount loop
563: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));
564: end loop;
565: rollback to eam_allocate_concurrent;

Line 563: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));

559: fnd_file.put_line(which => fnd_file.output, buff => '');
560: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
562: for i in 1..l_msgCount loop
563: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));
564: end loop;
565: rollback to eam_allocate_concurrent;
566: end allocate_comp_mat;
567: