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

Line 358: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

354: FETCH csr_date into l_date;
355: CLOSE csr_date;
356:
357: hr_utility.set_location('Leaving: ' || l_proc, 20);
358: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
359: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
360: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
362: fnd_file.put_line(FND_FILE.OUTPUT,' ');

Line 359: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));

355: CLOSE csr_date;
356:
357: hr_utility.set_location('Leaving: ' || l_proc, 20);
358: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
359: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
360: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
362: fnd_file.put_line(FND_FILE.OUTPUT,' ');
363: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Payroll Name',20)||' '||rpad('Employee Name',20)||' '||rpad('National Identifier',20)||' '||rpad(lpad('Initial Debt',12),12)||' '||

Line 360: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);

356:
357: hr_utility.set_location('Leaving: ' || l_proc, 20);
358: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
359: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
360: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
362: fnd_file.put_line(FND_FILE.OUTPUT,' ');
363: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Payroll Name',20)||' '||rpad('Employee Name',20)||' '||rpad('National Identifier',20)||' '||rpad(lpad('Initial Debt',12),12)||' '||
364: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));

Line 361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

357: hr_utility.set_location('Leaving: ' || l_proc, 20);
358: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
359: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
360: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
362: fnd_file.put_line(FND_FILE.OUTPUT,' ');
363: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Payroll Name',20)||' '||rpad('Employee Name',20)||' '||rpad('National Identifier',20)||' '||rpad(lpad('Initial Debt',12),12)||' '||
364: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));
365: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

Line 362: fnd_file.put_line(FND_FILE.OUTPUT,' ');

358: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
359: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
360: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
362: fnd_file.put_line(FND_FILE.OUTPUT,' ');
363: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Payroll Name',20)||' '||rpad('Employee Name',20)||' '||rpad('National Identifier',20)||' '||rpad(lpad('Initial Debt',12),12)||' '||
364: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));
365: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
366:

Line 363: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Payroll Name',20)||' '||rpad('Employee Name',20)||' '||rpad('National Identifier',20)||' '||rpad(lpad('Initial Debt',12),12)||' '||

359: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
360: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
362: fnd_file.put_line(FND_FILE.OUTPUT,' ');
363: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Payroll Name',20)||' '||rpad('Employee Name',20)||' '||rpad('National Identifier',20)||' '||rpad(lpad('Initial Debt',12),12)||' '||
364: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));
365: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
366:
367:

Line 365: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
362: fnd_file.put_line(FND_FILE.OUTPUT,' ');
363: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Payroll Name',20)||' '||rpad('Employee Name',20)||' '||rpad('National Identifier',20)||' '||rpad(lpad('Initial Debt',12),12)||' '||
364: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));
365: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
366:
367:
368: OPEN csr_defined_balance_id;
369: FETCH csr_defined_balance_id into l_defined_balance_id;

Line 396: fnd_file.put_line(FND_FILE.OUTPUT,rpad(v_payroll,20)||' '||rpad(v_csr_person.full_name,20)||' '||rpad(v_csr_person.national_identifier,20)||' '||

392: /* To print only over paid employees*/
393: if nvl(v_csr_actions.paid_value,'0') > nvl(v_initial_det.result_value,'0') then
394: if csr_asg_actions%rowcount = 1 then
395:
396: fnd_file.put_line(FND_FILE.OUTPUT,rpad(v_payroll,20)||' '||rpad(v_csr_person.full_name,20)||' '||rpad(v_csr_person.national_identifier,20)||' '||
397: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
398: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15, ' ')||' '||l_overpaid_flag);
399: else
400: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||

Line 400: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||

396: fnd_file.put_line(FND_FILE.OUTPUT,rpad(v_payroll,20)||' '||rpad(v_csr_person.full_name,20)||' '||rpad(v_csr_person.national_identifier,20)||' '||
397: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
398: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15, ' ')||' '||l_overpaid_flag);
399: else
400: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||
401: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
402: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15,' ')||' '||l_overpaid_flag);
403: end if;
404: end if;

Line 408: fnd_file.put_line(FND_FILE.OUTPUT,rpad(v_payroll,20)||' '||rpad(v_csr_person.full_name,20)||' '||rpad(v_csr_person.national_identifier,20)||' '||

404: end if;
405: ELSE
406: if csr_asg_actions%rowcount = 1 then
407:
408: fnd_file.put_line(FND_FILE.OUTPUT,rpad(v_payroll,20)||' '||rpad(v_csr_person.full_name,20)||' '||rpad(v_csr_person.national_identifier,20)||' '||
409: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
410: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15,' ')||' '||l_overpaid_flag);
411: else
412: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||

Line 412: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||

408: fnd_file.put_line(FND_FILE.OUTPUT,rpad(v_payroll,20)||' '||rpad(v_csr_person.full_name,20)||' '||rpad(v_csr_person.national_identifier,20)||' '||
409: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
410: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15,' ')||' '||l_overpaid_flag);
411: else
412: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||
413: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
414: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15, ' ')||' '||l_overpaid_flag);
415: end if;
416: END IF;

Line 421: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------No Data Found --------------------------------------------------------------');

417: end loop;
418: end loop;
419:
420: if l_no_data_found = 'Y' THEN
421: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------------------------------No Data Found --------------------------------------------------------------');
422: end if;
423:
424: --
425: EXCEPTION