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.HR_GL_COST_CENTERS dependencies on UTL_FILE

Line 16: g_log_file utl_file.file_type;

12: g_newline varchar2(10) := fnd_global.newline;
13: g_tab varchar2(30) := fnd_global.tab;
14:
15:
16: g_log_file utl_file.file_type;
17: g_application_short_name VARCHAR2(50) := 'PER';
18: g_bgid NUMBER := 0;
19: g_retcode NUMBER := 0;
20: g_ccid NUMBER := 0;

Line 246: Procedure writeHeaderFileHeader(p_file in utl_file.file_type

242: hr_utility.set_location('Leaving : '||l_proc,20);
243: return l_schema;
244: END;
245:
246: Procedure writeHeaderFileHeader(p_file in utl_file.file_type
247: ,p_bgid in NUMBER
248: ,p_datfile in VARCHAR2) IS
249: l_bg_name per_business_groups.name%type := null;
250: l_proc varchar2(50) := g_package||'.writeHeaderFileHeader';

Line 259: utl_file.put_line(P_FILE, 'Header'||l_tab||'Start');

255: SELECT name INTO l_bg_name
256: from PER_BUSINESS_GROUPS
257: WHERE business_group_id = p_bgid;
258:
259: utl_file.put_line(P_FILE, 'Header'||l_tab||'Start');
260: utl_file.put_line(P_FILE, 'Batch Name'||l_tab||
261: substr(l_bg_name||'-'||to_char(sysdate, 'YYYY/MM/DD'), 1, 70));
262: utl_file.put_line(P_FILE, 'Date'||l_tab||to_char(sysdate, 'YYYY/MM/DD'));
263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');

Line 260: utl_file.put_line(P_FILE, 'Batch Name'||l_tab||

256: from PER_BUSINESS_GROUPS
257: WHERE business_group_id = p_bgid;
258:
259: utl_file.put_line(P_FILE, 'Header'||l_tab||'Start');
260: utl_file.put_line(P_FILE, 'Batch Name'||l_tab||
261: substr(l_bg_name||'-'||to_char(sysdate, 'YYYY/MM/DD'), 1, 70));
262: utl_file.put_line(P_FILE, 'Date'||l_tab||to_char(sysdate, 'YYYY/MM/DD'));
263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');
264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');

Line 262: utl_file.put_line(P_FILE, 'Date'||l_tab||to_char(sysdate, 'YYYY/MM/DD'));

258:
259: utl_file.put_line(P_FILE, 'Header'||l_tab||'Start');
260: utl_file.put_line(P_FILE, 'Batch Name'||l_tab||
261: substr(l_bg_name||'-'||to_char(sysdate, 'YYYY/MM/DD'), 1, 70));
262: utl_file.put_line(P_FILE, 'Date'||l_tab||to_char(sysdate, 'YYYY/MM/DD'));
263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');
264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');
265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');
266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');

Line 263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');

259: utl_file.put_line(P_FILE, 'Header'||l_tab||'Start');
260: utl_file.put_line(P_FILE, 'Batch Name'||l_tab||
261: substr(l_bg_name||'-'||to_char(sysdate, 'YYYY/MM/DD'), 1, 70));
262: utl_file.put_line(P_FILE, 'Date'||l_tab||to_char(sysdate, 'YYYY/MM/DD'));
263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');
264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');
265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');
266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');
267: utl_file.put_line(P_FILE, 'Files'||l_tab||'Start');

Line 264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');

260: utl_file.put_line(P_FILE, 'Batch Name'||l_tab||
261: substr(l_bg_name||'-'||to_char(sysdate, 'YYYY/MM/DD'), 1, 70));
262: utl_file.put_line(P_FILE, 'Date'||l_tab||to_char(sysdate, 'YYYY/MM/DD'));
263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');
264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');
265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');
266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');
267: utl_file.put_line(P_FILE, 'Files'||l_tab||'Start');
268: utl_file.put_line(P_FILE, 'create_company_cost_center'||l_tab||p_datfile);

Line 265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');

261: substr(l_bg_name||'-'||to_char(sysdate, 'YYYY/MM/DD'), 1, 70));
262: utl_file.put_line(P_FILE, 'Date'||l_tab||to_char(sysdate, 'YYYY/MM/DD'));
263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');
264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');
265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');
266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');
267: utl_file.put_line(P_FILE, 'Files'||l_tab||'Start');
268: utl_file.put_line(P_FILE, 'create_company_cost_center'||l_tab||p_datfile);
269: utl_file.put_line(P_FILE, 'Files'||l_tab||'End');

Line 266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');

262: utl_file.put_line(P_FILE, 'Date'||l_tab||to_char(sysdate, 'YYYY/MM/DD'));
263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');
264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');
265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');
266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');
267: utl_file.put_line(P_FILE, 'Files'||l_tab||'Start');
268: utl_file.put_line(P_FILE, 'create_company_cost_center'||l_tab||p_datfile);
269: utl_file.put_line(P_FILE, 'Files'||l_tab||'End');
270:

Line 267: utl_file.put_line(P_FILE, 'Files'||l_tab||'Start');

263: utl_file.put_line(P_FILE, 'Version'||l_tab||'1.0');
264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');
265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');
266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');
267: utl_file.put_line(P_FILE, 'Files'||l_tab||'Start');
268: utl_file.put_line(P_FILE, 'create_company_cost_center'||l_tab||p_datfile);
269: utl_file.put_line(P_FILE, 'Files'||l_tab||'End');
270:
271: Exception

Line 268: utl_file.put_line(P_FILE, 'create_company_cost_center'||l_tab||p_datfile);

264: utl_file.put_line(P_FILE, 'Date Format'||l_tab||'YYYY/MM/DD');
265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');
266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');
267: utl_file.put_line(P_FILE, 'Files'||l_tab||'Start');
268: utl_file.put_line(P_FILE, 'create_company_cost_center'||l_tab||p_datfile);
269: utl_file.put_line(P_FILE, 'Files'||l_tab||'End');
270:
271: Exception
272: When no_data_found then

Line 269: utl_file.put_line(P_FILE, 'Files'||l_tab||'End');

265: utl_file.put_line(P_FILE, 'Number Format'||l_tab||'999999999999999');
266: utl_file.put_line(P_FILE, 'Header'||l_tab||'End');
267: utl_file.put_line(P_FILE, 'Files'||l_tab||'Start');
268: utl_file.put_line(P_FILE, 'create_company_cost_center'||l_tab||p_datfile);
269: utl_file.put_line(P_FILE, 'Files'||l_tab||'End');
270:
271: Exception
272: When no_data_found then
273: writelog('Error in writeHeaderFile for business group id : '||p_bgId

Line 279: Procedure writeDataFileHeader(p_file IN utl_file.file_type) IS

275: END;
276: hr_utility.set_location('Leaving : '||l_proc,20);
277: END;
278:
279: Procedure writeDataFileHeader(p_file IN utl_file.file_type) IS
280: l_proc varchar2(50) := g_package||'.writeDataFileHeader';
281: l_tab varchar2(5) := fnd_global.tab;
282: BEGIN
283: hr_utility.set_location('Entering : '||l_proc,10);

Line 285: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'Start');

281: l_tab varchar2(5) := fnd_global.tab;
282: BEGIN
283: hr_utility.set_location('Entering : '||l_proc,10);
284:
285: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'Start');
286: utl_file.put_line(P_FILE, 'API'||l_tab||'create_company_cost_center');
287: utl_file.put_line(P_FILE, 'Title'||l_tab||'create company cost center');
288: utl_file.put_line(P_FILE, 'Process Order'||l_tab||'10');
289: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'End');

Line 286: utl_file.put_line(P_FILE, 'API'||l_tab||'create_company_cost_center');

282: BEGIN
283: hr_utility.set_location('Entering : '||l_proc,10);
284:
285: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'Start');
286: utl_file.put_line(P_FILE, 'API'||l_tab||'create_company_cost_center');
287: utl_file.put_line(P_FILE, 'Title'||l_tab||'create company cost center');
288: utl_file.put_line(P_FILE, 'Process Order'||l_tab||'10');
289: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'End');
290: utl_file.put_line(P_FILE, 'Data'||l_tab||'Start');

Line 287: utl_file.put_line(P_FILE, 'Title'||l_tab||'create company cost center');

283: hr_utility.set_location('Entering : '||l_proc,10);
284:
285: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'Start');
286: utl_file.put_line(P_FILE, 'API'||l_tab||'create_company_cost_center');
287: utl_file.put_line(P_FILE, 'Title'||l_tab||'create company cost center');
288: utl_file.put_line(P_FILE, 'Process Order'||l_tab||'10');
289: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'End');
290: utl_file.put_line(P_FILE, 'Data'||l_tab||'Start');
291:

Line 288: utl_file.put_line(P_FILE, 'Process Order'||l_tab||'10');

284:
285: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'Start');
286: utl_file.put_line(P_FILE, 'API'||l_tab||'create_company_cost_center');
287: utl_file.put_line(P_FILE, 'Title'||l_tab||'create company cost center');
288: utl_file.put_line(P_FILE, 'Process Order'||l_tab||'10');
289: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'End');
290: utl_file.put_line(P_FILE, 'Data'||l_tab||'Start');
291:
292: utl_file.put_line(P_FILE, 'ID'||l_tab||'organization_name'||l_tab||

Line 289: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'End');

285: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'Start');
286: utl_file.put_line(P_FILE, 'API'||l_tab||'create_company_cost_center');
287: utl_file.put_line(P_FILE, 'Title'||l_tab||'create company cost center');
288: utl_file.put_line(P_FILE, 'Process Order'||l_tab||'10');
289: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'End');
290: utl_file.put_line(P_FILE, 'Data'||l_tab||'Start');
291:
292: utl_file.put_line(P_FILE, 'ID'||l_tab||'organization_name'||l_tab||
293: 'costcenter_id'||l_tab||'costcenter_name'||l_tab||

Line 290: utl_file.put_line(P_FILE, 'Data'||l_tab||'Start');

286: utl_file.put_line(P_FILE, 'API'||l_tab||'create_company_cost_center');
287: utl_file.put_line(P_FILE, 'Title'||l_tab||'create company cost center');
288: utl_file.put_line(P_FILE, 'Process Order'||l_tab||'10');
289: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'End');
290: utl_file.put_line(P_FILE, 'Data'||l_tab||'Start');
291:
292: utl_file.put_line(P_FILE, 'ID'||l_tab||'organization_name'||l_tab||
293: 'costcenter_id'||l_tab||'costcenter_name'||l_tab||
294: 'company_id'||l_tab||'company_name'||l_tab||

Line 292: utl_file.put_line(P_FILE, 'ID'||l_tab||'organization_name'||l_tab||

288: utl_file.put_line(P_FILE, 'Process Order'||l_tab||'10');
289: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'End');
290: utl_file.put_line(P_FILE, 'Data'||l_tab||'Start');
291:
292: utl_file.put_line(P_FILE, 'ID'||l_tab||'organization_name'||l_tab||
293: 'costcenter_id'||l_tab||'costcenter_name'||l_tab||
294: 'company_id'||l_tab||'company_name'||l_tab||
295: 'costcenter_valueset_name'||l_tab||'company_valueset_name'||
296: l_tab||'start_date'||l_tab||'language_code');

Line 326: l_hdr_file utl_file.file_type;

322: l_bg_name hr_all_organization_units_tl.name%type := null;
323: l_dir VARCHAR2(300) := null;
324: l_org_start_date date ; -- Added by FS
325:
326: l_hdr_file utl_file.file_type;
327: l_dat_file utl_file.file_type;
328: l_header_file varchar2(80);
329: l_data_file varchar2(80);
330: l_stmt VARCHAR2(3000) := null;

Line 327: l_dat_file utl_file.file_type;

323: l_dir VARCHAR2(300) := null;
324: l_org_start_date date ; -- Added by FS
325:
326: l_hdr_file utl_file.file_type;
327: l_dat_file utl_file.file_type;
328: l_header_file varchar2(80);
329: l_data_file varchar2(80);
330: l_stmt VARCHAR2(3000) := null;
331: l_retcode NUMBER;

Line 364: l_hdr_file := utl_file.fopen(l_dir,l_header_file,'w');

360: writelog('Data file name '||l_data_file,'D');
361:
362: begin
363: hr_utility.set_location(l_proc,50);
364: l_hdr_file := utl_file.fopen(l_dir,l_header_file,'w');
365: Exception
366: when others then
367: hr_utility.set_message(801,'HR_289426_INV_EXC_DIR');
368: writelog(fnd_message.get_string('PER','HR_289426_INV_EXC_DIR'),'E');

Line 375: utl_file.fclose(l_hdr_file);

371: hr_utility.set_location(l_proc,60);
372: writeHeaderFileHeader(l_hdr_file
373: ,l_bg_id
374: ,l_data_file);
375: utl_file.fclose(l_hdr_file);
376: hr_utility.set_location(l_proc,70);
377:
378: l_dat_file := utl_file.fopen(l_dir, l_data_file,'w');
379:

Line 378: l_dat_file := utl_file.fopen(l_dir, l_data_file,'w');

374: ,l_data_file);
375: utl_file.fclose(l_hdr_file);
376: hr_utility.set_location(l_proc,70);
377:
378: l_dat_file := utl_file.fopen(l_dir, l_data_file,'w');
379:
380: writeDataFileHeader(l_dat_file);
381:
382: l_stmt :=

Line 430: utl_file.put_line(l_dat_file,

426:
427: exit when c_list%notfound;
428:
429: -- Now Print it to the output file
430: utl_file.put_line(l_dat_file,
431: l_data_line_counter||l_tab|| -- ID Column
432: l_org_name||l_tab|| -- Org Name
433: l_cost_center_id||l_tab|| -- Cost Center ID
434: l_cost_center_name||l_tab|| -- Cost Center Name

Line 446: utl_file.put_line(l_dat_file, 'Data'||l_tab||'End');

442:
443: l_data_line_counter := l_data_line_counter + 1;
444: end loop;
445: hr_utility.set_location(l_proc,90);
446: utl_file.put_line(l_dat_file, 'Data'||l_tab||'End');
447: utl_file.fclose(l_dat_file);
448: writelog('Spooled '||l_data_line_counter||' lines in the data file','D');
449: l_data_line_counter := 1;
450: l_counter := l_counter +1;

Line 447: utl_file.fclose(l_dat_file);

443: l_data_line_counter := l_data_line_counter + 1;
444: end loop;
445: hr_utility.set_location(l_proc,90);
446: utl_file.put_line(l_dat_file, 'Data'||l_tab||'End');
447: utl_file.fclose(l_dat_file);
448: writelog('Spooled '||l_data_line_counter||' lines in the data file','D');
449: l_data_line_counter := 1;
450: l_counter := l_counter +1;
451: close c_list;