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

Line 1248: fnd_file.put_line(fnd_file.log, '*API input parameters**');

1244:
1245: -- Initialize error message stack by default
1246: FND_MSG_PUB.Initialize;
1247:
1248: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1249: fnd_file.put_line(fnd_file.log, 'API inputs p_api_version -> '||p_api_version);
1250: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);
1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);
1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);

Line 1249: fnd_file.put_line(fnd_file.log, 'API inputs p_api_version -> '||p_api_version);

1245: -- Initialize error message stack by default
1246: FND_MSG_PUB.Initialize;
1247:
1248: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1249: fnd_file.put_line(fnd_file.log, 'API inputs p_api_version -> '||p_api_version);
1250: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);
1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);
1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);
1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);

Line 1250: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);

1246: FND_MSG_PUB.Initialize;
1247:
1248: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1249: fnd_file.put_line(fnd_file.log, 'API inputs p_api_version -> '||p_api_version);
1250: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);
1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);
1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);
1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);
1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);

Line 1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);

1247:
1248: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1249: fnd_file.put_line(fnd_file.log, 'API inputs p_api_version -> '||p_api_version);
1250: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);
1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);
1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);
1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);
1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);
1255: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_to -> '||p_sch_start_to);

Line 1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);

1248: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1249: fnd_file.put_line(fnd_file.log, 'API inputs p_api_version -> '||p_api_version);
1250: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);
1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);
1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);
1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);
1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);
1255: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_to -> '||p_sch_start_to);
1256: fnd_file.put_line(fnd_file.log, 'API inputs p_employee_id -> '||p_employee_id);

Line 1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);

1249: fnd_file.put_line(fnd_file.log, 'API inputs p_api_version -> '||p_api_version);
1250: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);
1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);
1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);
1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);
1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);
1255: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_to -> '||p_sch_start_to);
1256: fnd_file.put_line(fnd_file.log, 'API inputs p_employee_id -> '||p_employee_id);
1257: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');

Line 1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);

1250: fnd_file.put_line(fnd_file.log, 'API inputs p_visit_id -> '||p_visit_id);
1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);
1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);
1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);
1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);
1255: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_to -> '||p_sch_start_to);
1256: fnd_file.put_line(fnd_file.log, 'API inputs p_employee_id -> '||p_employee_id);
1257: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1258:

Line 1255: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_to -> '||p_sch_start_to);

1251: fnd_file.put_line(fnd_file.log, 'API inputs p_stage_id -> '||p_stage_id);
1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);
1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);
1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);
1255: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_to -> '||p_sch_start_to);
1256: fnd_file.put_line(fnd_file.log, 'API inputs p_employee_id -> '||p_employee_id);
1257: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1258:
1259: l_query_string := ' select

Line 1256: fnd_file.put_line(fnd_file.log, 'API inputs p_employee_id -> '||p_employee_id);

1252: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_from -> '||p_wo_no_from);
1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);
1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);
1255: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_to -> '||p_sch_start_to);
1256: fnd_file.put_line(fnd_file.log, 'API inputs p_employee_id -> '||p_employee_id);
1257: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1258:
1259: l_query_string := ' select
1260: wo.workorder_id

Line 1257: fnd_file.put_line(fnd_file.log, '*API input parameters**');

1253: fnd_file.put_line(fnd_file.log, 'API inputs p_wo_no_to -> '||p_wo_no_to);
1254: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_from -> '||p_sch_start_from);
1255: fnd_file.put_line(fnd_file.log, 'API inputs p_sch_start_to -> '||p_sch_start_to);
1256: fnd_file.put_line(fnd_file.log, 'API inputs p_employee_id -> '||p_employee_id);
1257: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1258:
1259: l_query_string := ' select
1260: wo.workorder_id
1261: from

Line 1308: fnd_file.put_line(fnd_file.log, l_query_string);

1304: l_bind_value_tbl(l_bind_index) := fnd_date.canonical_to_date(p_sch_start_to);
1305: l_bind_index := l_bind_index + 1;
1306: END IF;
1307:
1308: fnd_file.put_line(fnd_file.log, l_query_string);
1309:
1310: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_vst_wocard_csr, l_bind_value_tbl, l_query_string);
1311:
1312: i := 1;

Line 1323: fnd_file.put_line(fnd_file.log, 'No of workorders ->'||l_workorder_tbl.COUNT);

1319:
1320: CLOSE l_vst_wocard_csr;
1321:
1322:
1323: fnd_file.put_line(fnd_file.log, 'No of workorders ->'||l_workorder_tbl.COUNT);
1324:
1325: IF l_workorder_tbl.COUNT > 0
1326: THEN
1327: Gen_Wo_Xml(

Line 1350: fnd_file.put(fnd_file.log, dbms_lob.substr (l_clob, l_chunk_size, l_offset));

1346: l_chunk_size := 3000;
1347: l_clob_size := dbms_lob.getlength(l_clob);
1348:
1349: WHILE (l_clob_size > 0) LOOP
1350: fnd_file.put(fnd_file.log, dbms_lob.substr (l_clob, l_chunk_size, l_offset));
1351: l_clob_size := l_clob_size - l_chunk_size;
1352: l_offset := l_offset + l_chunk_size;
1353: END LOOP;
1354:

Line 1363: --fnd_file.put_line(fnd_file.output, dbms_lob.substr(l_clob, dbms_lob.getlength(l_clob), 1));

1359: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)
1360: THEN
1361: retcode := 1; -- warning based on return status + msg count
1362: ELSE
1363: --fnd_file.put_line(fnd_file.output, dbms_lob.substr(l_clob, dbms_lob.getlength(l_clob), 1));
1364:
1365: l_offset := 1;
1366: l_chunk_size := 3000;
1367: l_clob_size := dbms_lob.getlength(l_clob);

Line 1370: fnd_file.put(fnd_file.output, dbms_lob.substr (l_clob, l_chunk_size, l_offset));

1366: l_chunk_size := 3000;
1367: l_clob_size := dbms_lob.getlength(l_clob);
1368:
1369: WHILE (l_clob_size > 0) LOOP
1370: fnd_file.put(fnd_file.output, dbms_lob.substr (l_clob, l_chunk_size, l_offset));
1371: l_clob_size := l_clob_size - l_chunk_size;
1372: l_offset := l_offset + l_chunk_size;
1373: END LOOP;
1374: