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

Line 135: fnd_file.put_line(fnd_file.log, rpad(l_name, 40)||' '||to_char(l_xrs.eff_dt)||' '

131: ,p_object_version_number => l_object_version_number
132: ,p_effective_date => l_xrs.eff_dt
133: ) ;
134: l_file_count := l_file_count + 1 ;
135: fnd_file.put_line(fnd_file.log, rpad(l_name, 40)||' '||to_char(l_xrs.eff_dt)||' '
136: || lpad(to_char(l_rcd_count),7) ) ;
137:
138: --- for performance commit every single extrct result when the mode is not rollbak
139:

Line 164: fnd_file.put_line(fnd_file.log, fnd_message.get);

160: end if;
161:
162: -- write to logfile a successful completion message
163: fnd_message.set_name('BEN','BEN_91877_GENERAL_JOB_SUCCESS');
164: fnd_file.put_line(fnd_file.log, fnd_message.get);
165:
166:
167: -- write to logfile the record count
168: fnd_file.put_line(fnd_file.log, to_char(l_file_count) ||' '||'Results are purged') ;

Line 168: fnd_file.put_line(fnd_file.log, to_char(l_file_count) ||' '||'Results are purged') ;

164: fnd_file.put_line(fnd_file.log, fnd_message.get);
165:
166:
167: -- write to logfile the record count
168: fnd_file.put_line(fnd_file.log, to_char(l_file_count) ||' '||'Results are purged') ;
169:
170: commit;
171: hr_utility.set_location('Exiting'||l_proc, 15);
172: --

Line 180: fnd_file.put_line(fnd_file.log, fnd_message.get);

176:
177: WHEN others THEN
178: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
179: fnd_message.set_token('2',substr(sqlerrm,1,200));
180: fnd_file.put_line(fnd_file.log, fnd_message.get);
181: fnd_message.raise_error;
182: --
183: END main;
184: --

Line 242: fnd_file.put_line(fnd_file.log,'Either Effective date or Actual date must be entered');

238:
239: if p_effective_date is null and p_actual_date is null then
240: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
241: fnd_message.set_token('2' , 'Either Effective date or Actual date must be entered' );
242: fnd_file.put_line(fnd_file.log,'Either Effective date or Actual date must be entered');
243: fnd_message.raise_error;
244:
245: end if ;
246:

Line 269: fnd_file.put_line(fnd_file.log, rpad(l_person_name,45) ||' '||lpad(l_person_count,6)) ;

265: -- first time dont print , whne the second porson is in the loop
266: -- first time , print for the first person
267: if l_person_name is not null then
268: -- write to logfile the record count
269: fnd_file.put_line(fnd_file.log, rpad(l_person_name,45) ||' '||lpad(l_person_count,6)) ;
270: hr_utility.set_location(rpad(l_person_name,45) ||' '||lpad(l_person_count,6),99 ) ;
271: end if ;
272: l_person_count := 0 ;
273: l_prv_person_id := l_person_id ;

Line 308: fnd_file.put_line(fnd_file.log, rpad(l_person_name,45) ||' '||lpad(l_person_count,6)) ;

304: fetch c_name into l_person_name ;
305: close c_name ;
306:
307: if l_person_name is not null then
308: fnd_file.put_line(fnd_file.log, rpad(l_person_name,45) ||' '||lpad(l_person_count,6)) ;
309: end if;
310: hr_utility.set_location(rpad(l_person_name,45) ||' '||lpad(l_person_count,6),99 ) ;
311: fnd_file.put_line(fnd_file.log, rpad(' ',45) ||' '||'------') ;
312: fnd_file.put_line(fnd_file.log, rpad(' ',45) ||' '||lpad(l_log_count,6)) ;

Line 311: fnd_file.put_line(fnd_file.log, rpad(' ',45) ||' '||'------') ;

307: if l_person_name is not null then
308: fnd_file.put_line(fnd_file.log, rpad(l_person_name,45) ||' '||lpad(l_person_count,6)) ;
309: end if;
310: hr_utility.set_location(rpad(l_person_name,45) ||' '||lpad(l_person_count,6),99 ) ;
311: fnd_file.put_line(fnd_file.log, rpad(' ',45) ||' '||'------') ;
312: fnd_file.put_line(fnd_file.log, rpad(' ',45) ||' '||lpad(l_log_count,6)) ;
313: hr_utility.set_location(lpad(l_log_count,6),99 ) ;
314: end if ;
315: close c_chg_log ;

Line 312: fnd_file.put_line(fnd_file.log, rpad(' ',45) ||' '||lpad(l_log_count,6)) ;

308: fnd_file.put_line(fnd_file.log, rpad(l_person_name,45) ||' '||lpad(l_person_count,6)) ;
309: end if;
310: hr_utility.set_location(rpad(l_person_name,45) ||' '||lpad(l_person_count,6),99 ) ;
311: fnd_file.put_line(fnd_file.log, rpad(' ',45) ||' '||'------') ;
312: fnd_file.put_line(fnd_file.log, rpad(' ',45) ||' '||lpad(l_log_count,6)) ;
313: hr_utility.set_location(lpad(l_log_count,6),99 ) ;
314: end if ;
315: close c_chg_log ;
316:

Line 330: fnd_file.put_line(fnd_file.log, fnd_message.get);

326: end if;
327:
328: -- write to logfile a successful completion message
329: fnd_message.set_name('BEN','BEN_91877_GENERAL_JOB_SUCCESS');
330: fnd_file.put_line(fnd_file.log, fnd_message.get);
331: commit;
332: hr_utility.set_location('Exiting'||l_proc, 15);
333: --
334: --

Line 340: fnd_file.put_line(fnd_file.log, fnd_message.get);

336: --
337: WHEN others THEN
338: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
339: fnd_message.set_token('2',substr(sqlerrm,1,200));
340: fnd_file.put_line(fnd_file.log, fnd_message.get);
341: fnd_message.raise_error;
342:
343: End chg_log_purge ;
344: