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 1478: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);

1474: x_msg_data => x_msg_data,
1475: x_msg_count => l_msgCount,
1476: p_init_msg_lst => fnd_api.g_true,
1477: x_mo_line_errrec_tbl => x_MOLineErrTbl);
1478: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);
1479:
1480: if (l_logLevel <= wip_constants.trace_logging) then
1481: wip_logger.log('returned status from call to inv_wip_picking_pvt.release_pick_batch() = ' || l_pickStatus || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1482: end if;

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

1494: if (nvl(fnd_global.CONC_REQUEST_ID, -1) <> -1) then
1495: if x_MOLineErrTbl.count > 0 then
1496:
1497: WIP_PICKING_PVT.g_PickRelease_Failed := TRUE;
1498: fnd_file.put_line(which => fnd_file.log, buff => 'The errored Records are as follows:');
1499:
1500: for i in x_MOLineErrTbl.FIRST..x_MOLineErrTbl.LAST
1501: loop
1502: if( x_MOLineErrTbl.exists(i) ) then

Line 1534: fnd_file.put_line(

1530: l_jobname := NULL;
1531: l_item := NULL;
1532: end;
1533:
1534: fnd_file.put_line(
1535: which => fnd_file.log,
1536: buff => 'Wip_Entity_Id:' || x_MOLineErrTbl(i).txn_source_id ||
1537: ' Job Name: ' || l_jobName || /* Bug 4917429 */
1538: ' OpSeqNum: ' || x_MOLineErrTbl(i).txn_source_line_id||

Line 1535: which => fnd_file.log,

1531: l_item := NULL;
1532: end;
1533:
1534: fnd_file.put_line(
1535: which => fnd_file.log,
1536: buff => 'Wip_Entity_Id:' || x_MOLineErrTbl(i).txn_source_id ||
1537: ' Job Name: ' || l_jobName || /* Bug 4917429 */
1538: ' OpSeqNum: ' || x_MOLineErrTbl(i).txn_source_line_id||
1539: ' Repetitve Schedule Id: ' || x_MOLineErrTbl(i).reference_id||

Line 1542: fnd_file.put_line(

1538: ' OpSeqNum: ' || x_MOLineErrTbl(i).txn_source_line_id||
1539: ' Repetitve Schedule Id: ' || x_MOLineErrTbl(i).reference_id||
1540: ' Inventory Item Id : ' || x_MOLineErrTbl(i).inventory_item_id||
1541: ' Item: ' || l_item /* Bug 4917429 */);
1542: fnd_file.put_line(
1543: which => fnd_file.log,
1544: buff => '==>Error:'||x_MOLineErrTbl(i).error_message);
1545: end if;
1546: end loop;

Line 1543: which => fnd_file.log,

1539: ' Repetitve Schedule Id: ' || x_MOLineErrTbl(i).reference_id||
1540: ' Inventory Item Id : ' || x_MOLineErrTbl(i).inventory_item_id||
1541: ' Item: ' || l_item /* Bug 4917429 */);
1542: fnd_file.put_line(
1543: which => fnd_file.log,
1544: buff => '==>Error:'||x_MOLineErrTbl(i).error_message);
1545: end if;
1546: end loop;
1547: end if;

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

2320: l_plan_tasks:= FALSE;
2321: end if;
2322:
2323: fnd_message.set_name('FND', 'CONC-PARAMETERS');
2324: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2325:
2326:
2327: select meaning
2328: into l_outBuffer

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

2330: where lookup_type = 'SYS_YES_NO'
2331: and lookup_code = p_use_pickset_indicator;
2332:
2333: fnd_message.set_name('WIP', 'WIP_PICKING_USE_PICKSETS');
2334: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2335: /* Added as part of Enhancement#2578514*/
2336: select meaning
2337: into l_outBuffer
2338: from mfg_lookups

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

2339: where lookup_type = 'SYS_YES_NO'
2340: and lookup_code = p_print_pickslips;
2341:
2342: fnd_message.set_name('WIP', 'WIP_PICKING_PRINT_PICKSLIPS');
2343: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2344: /* Added as part of Enhancement#2578514*/
2345: if(p_pick_grouping_rule_id IS NOT NULL) then
2346: select name
2347: into l_outBuffer

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

2348: from wsh_pick_grouping_rules
2349: where pick_grouping_rule_id = p_pick_grouping_rule_id;
2350:
2351: fnd_message.set_name('WIP', 'WIP_PICKING_PICK_GROUPING_RULE');
2352: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2353: end if;
2354:
2355: /* Added as part of Enhancement#2578514*/
2356: select meaning

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

2359: where lookup_type = 'SYS_YES_NO'
2360: and lookup_code = p_plan_tasks;
2361:
2362: fnd_message.set_name('WIP', 'WIP_PICKING_PLAN_TASKS');
2363: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2364:
2365: /* Fixed bug 4890898 Changed table from org_organization_definitions to MTL_PARAMETERS */
2366: select organization_code
2367: into l_outBuffer

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

2368: from MTL_PARAMETERS
2369: where organization_id = p_organization_id;
2370:
2371: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
2372: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2373:
2374: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
2375: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
2376:

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

2371: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
2372: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2373:
2374: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
2375: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
2376:
2377: select meaning
2378: into l_outBuffer
2379: from mfg_lookups

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

2380: where lookup_type = 'WIP_ENTITY'
2381: and lookup_code = p_wip_entity_type;
2382:
2383: fnd_message.set_name('WIP', 'WIP_PICKING_MFG_MODE');
2384: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2385:
2386: /* Bug 6046963: Added below if to print job type parameter in case of Discrete Job Comp Pick Release request only*/
2387: if(p_wip_entity_type = wip_constants.discrete) then
2388: /*Start - Bug 5932126 (FP of 5880558): Added following code to print new parameter for job type*/

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

2392: where lookup_type = 'WIP_ENTITIES'
2393: and lookup_code = p_job_type ;
2394:
2395: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');
2396: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2397: /*End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type*/
2398: end if;
2399:
2400: fnd_file.put_line(which => fnd_file.output, buff => '');

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

2396: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2397: /*End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type*/
2398: end if;
2399:
2400: fnd_file.put_line(which => fnd_file.output, buff => '');
2401: fnd_file.put_line(which => fnd_file.output, buff => '');
2402:
2403: LOOP
2404: if(p_wip_entity_type = wip_constants.discrete) then

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

2397: /*End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type*/
2398: end if;
2399:
2400: fnd_file.put_line(which => fnd_file.output, buff => '');
2401: fnd_file.put_line(which => fnd_file.output, buff => '');
2402:
2403: LOOP
2404: if(p_wip_entity_type = wip_constants.discrete) then
2405: fetch c_jobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;

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

2413: else
2414: fetch c_flow into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2415: exit when c_flow%NOTFOUND;
2416: end if;
2417: fnd_file.put_line(which => fnd_file.output, buff => l_outBuffer);
2418: i := i + 1;
2419: l_allocTbl(i).wip_entity_id := l_wipEntityID;
2420: l_allocTbl(i).repetitive_schedule_id := l_repSchedID;
2421: l_allocTbl(i).project_id := l_projectID;

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

2432: elsif(c_flow%ISOPEN) then
2433: close c_flow;
2434: end if;
2435:
2436: fnd_file.put_line(which => fnd_file.output, buff => 'Total job count: ' || i);
2437: if(i > 0) then
2438: allocate(p_alloc_tbl => l_allocTbl,
2439: p_days_to_alloc => p_days_to_alloc, --not null only for rep scheds
2440: p_cutoff_date => sysdate + p_days_forward,

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

2450:
2451: if(l_returnStatus = 'P') then
2452: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
2453: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
2454: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2455: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
2456: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2457: if(l_print_pickslips = 'T') then
2458: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');

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

2452: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
2453: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
2454: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2455: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
2456: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2457: if(l_print_pickslips = 'T') then
2458: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
2459: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2460: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

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

2456: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2457: if(l_print_pickslips = 'T') then
2458: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
2459: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2460: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2461: end if;
2462:
2463: elsif(l_returnStatus = 'S') then
2464: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');

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

2462:
2463: elsif(l_returnStatus = 'S') then
2464: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
2465: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
2466: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2467: if(l_print_pickslips = 'T') then
2468: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
2469: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2470: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

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

2466: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2467: if(l_print_pickslips = 'T') then
2468: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
2469: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2470: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2471: end if;
2472: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
2473: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2474:

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

2469: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
2470: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2471: end if;
2472: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
2473: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2474:
2475: elsif(l_returnStatus = 'N') then
2476: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
2477: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

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

2473: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2474:
2475: elsif(l_returnStatus = 'N') then
2476: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
2477: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2478:
2479: else
2480: fnd_file.put_line(which => fnd_file.output, buff => '');
2481: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');

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

2476: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
2477: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2478:
2479: else
2480: fnd_file.put_line(which => fnd_file.output, buff => '');
2481: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2482: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2483: fnd_file.put_line(which => fnd_file.output,
2484: buff => 'Returned status: ' || l_returnStatus);

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

2478:
2479: else
2480: fnd_file.put_line(which => fnd_file.output, buff => '');
2481: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2482: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2483: fnd_file.put_line(which => fnd_file.output,
2484: buff => 'Returned status: ' || l_returnStatus);
2485: fnd_file.put_line(which => fnd_file.output,
2486: buff => 'Returned message: ' || errbuf);

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

2479: else
2480: fnd_file.put_line(which => fnd_file.output, buff => '');
2481: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2482: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2483: fnd_file.put_line(which => fnd_file.output,
2484: buff => 'Returned status: ' || l_returnStatus);
2485: fnd_file.put_line(which => fnd_file.output,
2486: buff => 'Returned message: ' || errbuf);
2487: fnd_file.put_line(which => fnd_file.output,

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

2481: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2482: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2483: fnd_file.put_line(which => fnd_file.output,
2484: buff => 'Returned status: ' || l_returnStatus);
2485: fnd_file.put_line(which => fnd_file.output,
2486: buff => 'Returned message: ' || errbuf);
2487: fnd_file.put_line(which => fnd_file.output,
2488: buff => 'Parameters passed to allocate():');
2489: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||

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

2483: fnd_file.put_line(which => fnd_file.output,
2484: buff => 'Returned status: ' || l_returnStatus);
2485: fnd_file.put_line(which => fnd_file.output,
2486: buff => 'Returned message: ' || errbuf);
2487: fnd_file.put_line(which => fnd_file.output,
2488: buff => 'Parameters passed to allocate():');
2489: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||
2490: p_days_to_alloc || ';p_days_forward=' || p_days_forward ||
2491: ';p_wip_entity_type=' || p_wip_entity_type || ';p_organization_id=' ||

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

2485: fnd_file.put_line(which => fnd_file.output,
2486: buff => 'Returned message: ' || errbuf);
2487: fnd_file.put_line(which => fnd_file.output,
2488: buff => 'Parameters passed to allocate():');
2489: fnd_file.put_line(which => fnd_file.output, buff => 'p_days_to_alloc=' ||
2490: p_days_to_alloc || ';p_days_forward=' || p_days_forward ||
2491: ';p_wip_entity_type=' || p_wip_entity_type || ';p_organization_id=' ||
2492: p_organization_id || ';p_pick_grouping_rule_id=' || p_pick_grouping_rule_id
2493: || ';l_print_pickslips=' || l_print_pickslips );

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

2501: exception
2502: when others then
2503: errbuf := SQLERRM;
2504: retcode := 2;
2505: fnd_file.put_line(which => fnd_file.output, buff => '');
2506: fnd_file.put_line(which => fnd_file.output, buff => '');
2507: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2508: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2509: for i in 1..l_msgCount loop

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

2502: when others then
2503: errbuf := SQLERRM;
2504: retcode := 2;
2505: fnd_file.put_line(which => fnd_file.output, buff => '');
2506: fnd_file.put_line(which => fnd_file.output, buff => '');
2507: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2508: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2509: for i in 1..l_msgCount loop
2510: 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 2508: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

2504: retcode := 2;
2505: fnd_file.put_line(which => fnd_file.output, buff => '');
2506: fnd_file.put_line(which => fnd_file.output, buff => '');
2507: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2508: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2509: for i in 1..l_msgCount loop
2510: 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));
2511: end loop;
2512: rollback to wip_allocate_concurrent;

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

2506: fnd_file.put_line(which => fnd_file.output, buff => '');
2507: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
2508: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
2509: for i in 1..l_msgCount loop
2510: 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));
2511: end loop;
2512: rollback to wip_allocate_concurrent;
2513: end allocate;
2514: