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

Line 1503: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);

1499: x_msg_data => x_msg_data,
1500: x_msg_count => l_msgCount,
1501: p_init_msg_lst => fnd_api.g_true,
1502: x_mo_line_errrec_tbl => x_MOLineErrTbl);
1503: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);
1504:
1505: if (l_logLevel <= wip_constants.trace_logging) then
1506: wip_logger.log('returned status from call to inv_wip_picking_pvt.release_pick_batch() = ' || l_pickStatus || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1507: end if;

Line 1518: fnd_file.put_line(which => fnd_file.log, buff => 'The errored Records are as follows:');

1514: if (nvl(fnd_global.CONC_REQUEST_ID, -1) <> -1) then
1515: if x_MOLineErrTbl.count > 0 then
1516:
1517: WIP_PICKING_PVT.g_PickRelease_Failed := TRUE;
1518: fnd_file.put_line(which => fnd_file.log, buff => 'The errored Records are as follows:');
1519:
1520: for i in x_MOLineErrTbl.FIRST..x_MOLineErrTbl.LAST
1521: loop
1522: if( x_MOLineErrTbl.exists(i) ) then

Line 1554: fnd_file.put_line(

1550: l_jobname := NULL;
1551: l_item := NULL;
1552: end;
1553:
1554: fnd_file.put_line(
1555: which => fnd_file.log,
1556: buff => 'Wip_Entity_Id:' || x_MOLineErrTbl(i).txn_source_id ||
1557: ' Job Name: ' || l_jobName || /* Bug 4917429 */
1558: ' OpSeqNum: ' || x_MOLineErrTbl(i).txn_source_line_id||

Line 1555: which => fnd_file.log,

1551: l_item := NULL;
1552: end;
1553:
1554: fnd_file.put_line(
1555: which => fnd_file.log,
1556: buff => 'Wip_Entity_Id:' || x_MOLineErrTbl(i).txn_source_id ||
1557: ' Job Name: ' || l_jobName || /* Bug 4917429 */
1558: ' OpSeqNum: ' || x_MOLineErrTbl(i).txn_source_line_id||
1559: ' Repetitve Schedule Id: ' || x_MOLineErrTbl(i).reference_id||

Line 1562: fnd_file.put_line(

1558: ' OpSeqNum: ' || x_MOLineErrTbl(i).txn_source_line_id||
1559: ' Repetitve Schedule Id: ' || x_MOLineErrTbl(i).reference_id||
1560: ' Inventory Item Id : ' || x_MOLineErrTbl(i).inventory_item_id||
1561: ' Item: ' || l_item /* Bug 4917429 */);
1562: fnd_file.put_line(
1563: which => fnd_file.log,
1564: buff => '==>Error:'||x_MOLineErrTbl(i).error_message);
1565: end if;
1566: end loop;

Line 1563: which => fnd_file.log,

1559: ' Repetitve Schedule Id: ' || x_MOLineErrTbl(i).reference_id||
1560: ' Inventory Item Id : ' || x_MOLineErrTbl(i).inventory_item_id||
1561: ' Item: ' || l_item /* Bug 4917429 */);
1562: fnd_file.put_line(
1563: which => fnd_file.log,
1564: buff => '==>Error:'||x_MOLineErrTbl(i).error_message);
1565: end if;
1566: end loop;
1567: end if;

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

2416: l_plan_tasks:= FALSE;
2417: end if;
2418:
2419: fnd_message.set_name('FND', 'CONC-PARAMETERS');
2420: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2421:
2422:
2423: select meaning
2424: into l_outBuffer

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

2426: where lookup_type = 'SYS_YES_NO'
2427: and lookup_code = p_use_pickset_indicator;
2428:
2429: fnd_message.set_name('WIP', 'WIP_PICKING_USE_PICKSETS');
2430: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2431: /* Added as part of Enhancement#2578514*/
2432: select meaning
2433: into l_outBuffer
2434: from mfg_lookups

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

2435: where lookup_type = 'SYS_YES_NO'
2436: and lookup_code = p_print_pickslips;
2437:
2438: fnd_message.set_name('WIP', 'WIP_PICKING_PRINT_PICKSLIPS');
2439: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2440: /* Added as part of Enhancement#2578514*/
2441: if(p_pick_grouping_rule_id IS NOT NULL) then
2442: select name
2443: into l_outBuffer

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

2444: from wsh_pick_grouping_rules
2445: where pick_grouping_rule_id = p_pick_grouping_rule_id;
2446:
2447: fnd_message.set_name('WIP', 'WIP_PICKING_PICK_GROUPING_RULE');
2448: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2449: end if;
2450:
2451: /* Added as part of Enhancement#2578514*/
2452: select meaning

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

2455: where lookup_type = 'SYS_YES_NO'
2456: and lookup_code = p_plan_tasks;
2457:
2458: fnd_message.set_name('WIP', 'WIP_PICKING_PLAN_TASKS');
2459: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2460:
2461: /* Fixed bug 4890898 Changed table from org_organization_definitions to MTL_PARAMETERS */
2462: select organization_code
2463: into l_outBuffer

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

2464: from MTL_PARAMETERS
2465: where organization_id = p_organization_id;
2466:
2467: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
2468: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2469:
2470: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
2471: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
2472:

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

2467: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
2468: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2469:
2470: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
2471: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
2472:
2473: select meaning
2474: into l_outBuffer
2475: from mfg_lookups

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

2476: where lookup_type = 'WIP_ENTITY'
2477: and lookup_code = p_wip_entity_type;
2478:
2479: fnd_message.set_name('WIP', 'WIP_PICKING_MFG_MODE');
2480: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2481:
2482: /* Bug 6046963: Added below if to print job type parameter in case of Discrete Job Comp Pick Release request only*/
2483: if(p_wip_entity_type = wip_constants.discrete) then
2484: /*Start - Bug 5932126 (FP of 5880558): Added following code to print new parameter for job type*/

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

2488: where lookup_type = 'WIP_ENTITIES'
2489: and lookup_code = p_job_type ;
2490:
2491: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');
2492: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2493: /*End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type*/
2494: end if;
2495:
2496: fnd_file.put_line(which => fnd_file.output, buff => '');

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

2492: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2493: /*End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type*/
2494: end if;
2495:
2496: fnd_file.put_line(which => fnd_file.output, buff => '');
2497: fnd_file.put_line(which => fnd_file.output, buff => '');
2498:
2499: LOOP
2500: if(p_wip_entity_type = wip_constants.discrete) then

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

2493: /*End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type*/
2494: end if;
2495:
2496: fnd_file.put_line(which => fnd_file.output, buff => '');
2497: fnd_file.put_line(which => fnd_file.output, buff => '');
2498:
2499: LOOP
2500: if(p_wip_entity_type = wip_constants.discrete) then
2501: fetch c_jobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;

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

2513: else
2514: fetch c_flow into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2515: exit when c_flow%NOTFOUND;
2516: end if;
2517: fnd_file.put_line(which => fnd_file.output, buff => l_outBuffer);
2518: i := i + 1;
2519: l_allocTbl(i).wip_entity_id := l_wipEntityID;
2520: l_allocTbl(i).repetitive_schedule_id := l_repSchedID;
2521: l_allocTbl(i).project_id := l_projectID;

Line 2541: fnd_file.put_line(which => fnd_file.output, buff => 'Total job count: ' || i);

2537: end if;
2538:
2539:
2540:
2541: fnd_file.put_line(which => fnd_file.output, buff => 'Total job count: ' || i);
2542: if(i > 0) then
2543: allocate(p_alloc_tbl => l_allocTbl,
2544: p_days_to_alloc => p_days_to_alloc, --not null only for rep scheds
2545: p_cutoff_date => sysdate + p_days_forward,

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

2555:
2556: if(l_returnStatus = 'P') then
2557: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
2558: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
2559: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2560: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
2561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2562: if(l_print_pickslips = 'T') then
2563: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');

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

2557: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
2558: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
2559: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2560: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
2561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2562: if(l_print_pickslips = 'T') then
2563: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
2564: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2565: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

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

2561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2562: if(l_print_pickslips = 'T') then
2563: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
2564: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2565: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2566: end if;
2567:
2568: elsif(l_returnStatus = 'S') then
2569: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');

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

2567:
2568: elsif(l_returnStatus = 'S') then
2569: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
2570: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
2571: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2572: if(l_print_pickslips = 'T') then
2573: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
2574: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2575: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

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

2571: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2572: if(l_print_pickslips = 'T') then
2573: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
2574: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2575: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2576: end if;
2577: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
2578: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2579:

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

2574: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2575: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2576: end if;
2577: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
2578: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2579:
2580: elsif(l_returnStatus = 'N') then
2581: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
2582: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

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

2578: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2579:
2580: elsif(l_returnStatus = 'N') then
2581: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
2582: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2583:
2584: else
2585: fnd_file.put_line(which => fnd_file.output, buff => '');
2586: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');

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

2581: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
2582: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2583:
2584: else
2585: fnd_file.put_line(which => fnd_file.output, buff => '');
2586: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2587: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2588: fnd_file.put_line(which => fnd_file.output,
2589: buff => 'Returned status: ' || l_returnStatus);

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

2583:
2584: else
2585: fnd_file.put_line(which => fnd_file.output, buff => '');
2586: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2587: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2588: fnd_file.put_line(which => fnd_file.output,
2589: buff => 'Returned status: ' || l_returnStatus);
2590: fnd_file.put_line(which => fnd_file.output,
2591: buff => 'Returned message: ' || errbuf);

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

2584: else
2585: fnd_file.put_line(which => fnd_file.output, buff => '');
2586: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2587: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2588: fnd_file.put_line(which => fnd_file.output,
2589: buff => 'Returned status: ' || l_returnStatus);
2590: fnd_file.put_line(which => fnd_file.output,
2591: buff => 'Returned message: ' || errbuf);
2592: fnd_file.put_line(which => fnd_file.output,

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

2586: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2587: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2588: fnd_file.put_line(which => fnd_file.output,
2589: buff => 'Returned status: ' || l_returnStatus);
2590: fnd_file.put_line(which => fnd_file.output,
2591: buff => 'Returned message: ' || errbuf);
2592: fnd_file.put_line(which => fnd_file.output,
2593: buff => 'Parameters passed to allocate():');
2594: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||

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

2588: fnd_file.put_line(which => fnd_file.output,
2589: buff => 'Returned status: ' || l_returnStatus);
2590: fnd_file.put_line(which => fnd_file.output,
2591: buff => 'Returned message: ' || errbuf);
2592: fnd_file.put_line(which => fnd_file.output,
2593: buff => 'Parameters passed to allocate():');
2594: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||
2595: p_days_to_alloc || ';p_days_forward=' || p_days_forward ||
2596: ';p_wip_entity_type=' || p_wip_entity_type || ';p_organization_id=' ||

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

2590: fnd_file.put_line(which => fnd_file.output,
2591: buff => 'Returned message: ' || errbuf);
2592: fnd_file.put_line(which => fnd_file.output,
2593: buff => 'Parameters passed to allocate():');
2594: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||
2595: p_days_to_alloc || ';p_days_forward=' || p_days_forward ||
2596: ';p_wip_entity_type=' || p_wip_entity_type || ';p_organization_id=' ||
2597: p_organization_id || ';p_pick_grouping_rule_id=' || p_pick_grouping_rule_id
2598: || ';l_print_pickslips=' || l_print_pickslips );

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

2606: exception
2607: when others then
2608: errbuf := SQLERRM;
2609: retcode := 2;
2610: fnd_file.put_line(which => fnd_file.output, buff => '');
2611: fnd_file.put_line(which => fnd_file.output, buff => '');
2612: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2613: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2614: for i in 1..l_msgCount loop

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

2607: when others then
2608: errbuf := SQLERRM;
2609: retcode := 2;
2610: fnd_file.put_line(which => fnd_file.output, buff => '');
2611: fnd_file.put_line(which => fnd_file.output, buff => '');
2612: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2613: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2614: for i in 1..l_msgCount loop
2615: 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 2613: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

2609: retcode := 2;
2610: fnd_file.put_line(which => fnd_file.output, buff => '');
2611: fnd_file.put_line(which => fnd_file.output, buff => '');
2612: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2613: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2614: for i in 1..l_msgCount loop
2615: 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));
2616: end loop;
2617: rollback to wip_allocate_concurrent;

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

2611: fnd_file.put_line(which => fnd_file.output, buff => '');
2612: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2613: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2614: for i in 1..l_msgCount loop
2615: 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));
2616: end loop;
2617: rollback to wip_allocate_concurrent;
2618: end allocate;
2619: