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_PERSON_TITLE_UPDATE dependencies on FND_FILE

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

61: FETCH csr_business_group into l_business_group_name;
62: CLOSE csr_business_group;
63:
64: hr_utility.set_location('Leaving: ' || g_package, 20);
65: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
66: fnd_file.put_line(FND_FILE.OUTPUT,' Title Changes For Employees in : '||rpad(l_business_group_name,30));
67: fnd_file.put_line(FND_FILE.OUTPUT,' ');
68: fnd_file.put_line(FND_FILE.OUTPUT,' Title '||rpad(p_title,30)||'updated for the following records');
69: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');

Line 66: fnd_file.put_line(FND_FILE.OUTPUT,' Title Changes For Employees in : '||rpad(l_business_group_name,30));

62: CLOSE csr_business_group;
63:
64: hr_utility.set_location('Leaving: ' || g_package, 20);
65: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
66: fnd_file.put_line(FND_FILE.OUTPUT,' Title Changes For Employees in : '||rpad(l_business_group_name,30));
67: fnd_file.put_line(FND_FILE.OUTPUT,' ');
68: fnd_file.put_line(FND_FILE.OUTPUT,' Title '||rpad(p_title,30)||'updated for the following records');
69: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
70: fnd_file.put_line(FND_FILE.OUTPUT,' ');

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

63:
64: hr_utility.set_location('Leaving: ' || g_package, 20);
65: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
66: fnd_file.put_line(FND_FILE.OUTPUT,' Title Changes For Employees in : '||rpad(l_business_group_name,30));
67: fnd_file.put_line(FND_FILE.OUTPUT,' ');
68: fnd_file.put_line(FND_FILE.OUTPUT,' Title '||rpad(p_title,30)||'updated for the following records');
69: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
70: fnd_file.put_line(FND_FILE.OUTPUT,' ');
71: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',20)||' '||rpad('National Identifier',20)||' '||rpad('Effective Start Date',20)||' '||

Line 68: fnd_file.put_line(FND_FILE.OUTPUT,' Title '||rpad(p_title,30)||'updated for the following records');

64: hr_utility.set_location('Leaving: ' || g_package, 20);
65: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
66: fnd_file.put_line(FND_FILE.OUTPUT,' Title Changes For Employees in : '||rpad(l_business_group_name,30));
67: fnd_file.put_line(FND_FILE.OUTPUT,' ');
68: fnd_file.put_line(FND_FILE.OUTPUT,' Title '||rpad(p_title,30)||'updated for the following records');
69: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
70: fnd_file.put_line(FND_FILE.OUTPUT,' ');
71: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',20)||' '||rpad('National Identifier',20)||' '||rpad('Effective Start Date',20)||' '||
72: rpad('Effective End Date ',20)||' '||rpad('Initial Employee Name',75)||' '||rpad('Final Employee name',75));

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

65: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
66: fnd_file.put_line(FND_FILE.OUTPUT,' Title Changes For Employees in : '||rpad(l_business_group_name,30));
67: fnd_file.put_line(FND_FILE.OUTPUT,' ');
68: fnd_file.put_line(FND_FILE.OUTPUT,' Title '||rpad(p_title,30)||'updated for the following records');
69: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
70: fnd_file.put_line(FND_FILE.OUTPUT,' ');
71: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',20)||' '||rpad('National Identifier',20)||' '||rpad('Effective Start Date',20)||' '||
72: rpad('Effective End Date ',20)||' '||rpad('Initial Employee Name',75)||' '||rpad('Final Employee name',75));
73: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');

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

66: fnd_file.put_line(FND_FILE.OUTPUT,' Title Changes For Employees in : '||rpad(l_business_group_name,30));
67: fnd_file.put_line(FND_FILE.OUTPUT,' ');
68: fnd_file.put_line(FND_FILE.OUTPUT,' Title '||rpad(p_title,30)||'updated for the following records');
69: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
70: fnd_file.put_line(FND_FILE.OUTPUT,' ');
71: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',20)||' '||rpad('National Identifier',20)||' '||rpad('Effective Start Date',20)||' '||
72: rpad('Effective End Date ',20)||' '||rpad('Initial Employee Name',75)||' '||rpad('Final Employee name',75));
73: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
74:

Line 71: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',20)||' '||rpad('National Identifier',20)||' '||rpad('Effective Start Date',20)||' '||

67: fnd_file.put_line(FND_FILE.OUTPUT,' ');
68: fnd_file.put_line(FND_FILE.OUTPUT,' Title '||rpad(p_title,30)||'updated for the following records');
69: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
70: fnd_file.put_line(FND_FILE.OUTPUT,' ');
71: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',20)||' '||rpad('National Identifier',20)||' '||rpad('Effective Start Date',20)||' '||
72: rpad('Effective End Date ',20)||' '||rpad('Initial Employee Name',75)||' '||rpad('Final Employee name',75));
73: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
74:
75:

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

69: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
70: fnd_file.put_line(FND_FILE.OUTPUT,' ');
71: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',20)||' '||rpad('National Identifier',20)||' '||rpad('Effective Start Date',20)||' '||
72: rpad('Effective End Date ',20)||' '||rpad('Initial Employee Name',75)||' '||rpad('Final Employee name',75));
73: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------');
74:
75:
76: for v_csr_person in csr_person_det
77: loop

Line 101: fnd_file.put_line(FND_FILE.OUTPUT,rpad(v_csr_person.person_id,20)||' '||rpad(v_csr_person.national_identifier,20)||' '||rpad(v_csr_person.effective_start_date,20)||' '||

97: ,p_assign_payroll_warning => l_assign_payroll_warning
98: ,p_orig_hire_warning => l_orig_hire_warning);
99:
100:
101: fnd_file.put_line(FND_FILE.OUTPUT,rpad(v_csr_person.person_id,20)||' '||rpad(v_csr_person.national_identifier,20)||' '||rpad(v_csr_person.effective_start_date,20)||' '||
102: rpad(v_csr_person.effective_end_date,20)||' '||rpad(v_csr_person.full_name,75)||' '||rpad(l_full_name,75));
103:
104: end loop;
105:

Line 107: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------No Person record with HU_PROF title, So no records updated---------------------------------');

103:
104: end loop;
105:
106: if l_no_data_found = 'Y' THEN
107: fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------No Person record with HU_PROF title, So no records updated---------------------------------');
108: end if;
109:
110: --
111: EXCEPTION

Line 114: fnd_file.put_line(FND_FILE.OUTPUT,SQLERRM);

110: --
111: EXCEPTION
112: WHEN OTHERS THEN
113: ROLLBACK;
114: fnd_file.put_line(FND_FILE.OUTPUT,SQLERRM);
115: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
116:
117: END run;
118: --