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 359: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

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

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

356: CLOSE csr_date;
357:
358: hr_utility.set_location('Leaving: ' || l_proc, 20);
359: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
360: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
361: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
362: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
363: fnd_file.put_line(FND_FILE.OUTPUT,' ');
364: 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 361: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);

357:
358: hr_utility.set_location('Leaving: ' || l_proc, 20);
359: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
360: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
361: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
362: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
363: fnd_file.put_line(FND_FILE.OUTPUT,' ');
364: 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)||' '||
365: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));

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

358: hr_utility.set_location('Leaving: ' || l_proc, 20);
359: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
360: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
361: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
362: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
363: fnd_file.put_line(FND_FILE.OUTPUT,' ');
364: 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)||' '||
365: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));
366: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');

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

359: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
360: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
361: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
362: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
363: fnd_file.put_line(FND_FILE.OUTPUT,' ');
364: 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)||' '||
365: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));
366: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
367:

Line 364: 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)||' '||

360: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
361: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
362: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
363: fnd_file.put_line(FND_FILE.OUTPUT,' ');
364: 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)||' '||
365: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));
366: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
367:
368:

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

362: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
363: fnd_file.put_line(FND_FILE.OUTPUT,' ');
364: 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)||' '||
365: rpad('Reference',20)||' '||rpad(lpad('Paid to Date',15), 15)||' '||rpad('Overpaid',8));
366: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
367:
368:
369: OPEN csr_defined_balance_id;
370: FETCH csr_defined_balance_id into l_defined_balance_id;

Line 397: 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)||' '||

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

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

397: 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)||' '||
398: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
399: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15, ' ')||' '||l_overpaid_flag);
400: else
401: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||
402: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
403: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15,' ')||' '||l_overpaid_flag);
404: end if;
405: end if;

Line 409: 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)||' '||

405: end if;
406: ELSE
407: if csr_asg_actions%rowcount = 1 then
408:
409: 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)||' '||
410: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
411: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15,' ')||' '||l_overpaid_flag);
412: else
413: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||

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

409: 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)||' '||
410: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
411: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15,' ')||' '||l_overpaid_flag);
412: else
413: fnd_file.put_line(FND_FILE.OUTPUT,rpad(' ',20)||' '||rpad(' ',20)||' '||rpad(' ',20)||' '||
414: rpad(lpad(to_char(to_number(v_initial_det.result_value),'FM999999990D00'),12),12,' ')||' '||
415: rpad(v_csr_actions.context_value,20)||' '||rpad(lpad(to_char(to_number(v_csr_actions.paid_value),'FM999999999990D00'),15),15, ' ')||' '||l_overpaid_flag);
416: end if;
417: END IF;

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

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