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

Line 113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');

109: l_fin_year_end := to_date('30-06-' || p_financial_year_end, 'dd-mm-yyyy');
110:
111: l_asg_tab.delete;
112:
113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));

Line 114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');

110:
111: l_asg_tab.delete;
112:
113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');

Line 115: fnd_file.put_line(fnd_file.output, ' ');

111: l_asg_tab.delete;
112:
113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');

Line 116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||

112:
113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||

Line 118: fnd_file.put_line(fnd_file.output, ' ');

114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||

Line 119: fnd_file.put_line(fnd_file.output, 'Parameters : ');

115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||

Line 120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||

116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
124: to_char(l_fin_year_end, 'dd-MON-yyyy') );

Line 122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||

118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
124: to_char(l_fin_year_end, 'dd-MON-yyyy') );
125: fnd_file.put_line(fnd_file.output, ' ');
126: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');

Line 125: fnd_file.put_line(fnd_file.output, ' ');

121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
124: to_char(l_fin_year_end, 'dd-MON-yyyy') );
125: fnd_file.put_line(fnd_file.output, ' ');
126: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
127:
128: for asg_rec in c_select_assignments(p_business_group_id,
129: l_fin_year_start,

Line 126: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');

122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
124: to_char(l_fin_year_end, 'dd-MON-yyyy') );
125: fnd_file.put_line(fnd_file.output, ' ');
126: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
127:
128: for asg_rec in c_select_assignments(p_business_group_id,
129: l_fin_year_start,
130: l_fin_year_end)

Line 158: fnd_file.put_line(fnd_file.output, ' ');

154: l_prev_legal_emp := asg_rec.segment1;
155:
156: end loop;
157:
158: fnd_file.put_line(fnd_file.output, ' ');
159: fnd_file.put_line(fnd_file.output, 'Assignments that have changed legal employer in ' ||
160: 'financial year ' ||
161: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
162: to_char(l_fin_year_end, 'dd-MON-yyyy') );

Line 159: fnd_file.put_line(fnd_file.output, 'Assignments that have changed legal employer in ' ||

155:
156: end loop;
157:
158: fnd_file.put_line(fnd_file.output, ' ');
159: fnd_file.put_line(fnd_file.output, 'Assignments that have changed legal employer in ' ||
160: 'financial year ' ||
161: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
162: to_char(l_fin_year_end, 'dd-MON-yyyy') );
163: fnd_file.put_line(fnd_file.output, ' ');

Line 163: fnd_file.put_line(fnd_file.output, ' ');

159: fnd_file.put_line(fnd_file.output, 'Assignments that have changed legal employer in ' ||
160: 'financial year ' ||
161: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
162: to_char(l_fin_year_end, 'dd-MON-yyyy') );
163: fnd_file.put_line(fnd_file.output, ' ');
164:
165: if l_asg_tab.count > 0 then
166: fnd_file.put_line(fnd_file.output, ' Full Name Assignment Number Date of New LE New Legal Employer Previous Legal Employer');
167: fnd_file.put_line(fnd_file.output, ' ');

Line 166: fnd_file.put_line(fnd_file.output, ' Full Name Assignment Number Date of New LE New Legal Employer Previous Legal Employer');

162: to_char(l_fin_year_end, 'dd-MON-yyyy') );
163: fnd_file.put_line(fnd_file.output, ' ');
164:
165: if l_asg_tab.count > 0 then
166: fnd_file.put_line(fnd_file.output, ' Full Name Assignment Number Date of New LE New Legal Employer Previous Legal Employer');
167: fnd_file.put_line(fnd_file.output, ' ');
168: end if;
169:
170: if l_asg_tab.count > 0 then

Line 167: fnd_file.put_line(fnd_file.output, ' ');

163: fnd_file.put_line(fnd_file.output, ' ');
164:
165: if l_asg_tab.count > 0 then
166: fnd_file.put_line(fnd_file.output, ' Full Name Assignment Number Date of New LE New Legal Employer Previous Legal Employer');
167: fnd_file.put_line(fnd_file.output, ' ');
168: end if;
169:
170: if l_asg_tab.count > 0 then
171: for i in 1..l_asg_tab.last

Line 198: fnd_file.put_line(fnd_file.output,

194: and l_fin_year_end between per.effective_start_date and per.effective_end_date;
195:
196: -- Output the line.
197:
198: fnd_file.put_line(fnd_file.output,
199: ' ' || rpad(l_asg_tab(i).full_name, 30, ' ') ||
200: ' ' || rpad(l_asg_tab(i).assignment_number, 15, ' ') ||
201: ' ' || to_char(l_asg_tab(i).effective_start_date, 'dd-MON-yyyy') ||
202: ' ' || rpad(l_asg_tab(i).seg1_name, 30, ' ') ||

Line 207: fnd_file.put_line(fnd_file.output, 'No assignments have had a legal employer change in the specified financial year');

203: ' ' || rpad(l_asg_tab(i).seg1_prev_name, 30, ' ')
204: );
205: end loop;
206: else
207: fnd_file.put_line(fnd_file.output, 'No assignments have had a legal employer change in the specified financial year');
208: end if;
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');

Line 210: fnd_file.put_line(fnd_file.output, ' ');

206: else
207: fnd_file.put_line(fnd_file.output, 'No assignments have had a legal employer change in the specified financial year');
208: end if;
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');

Line 211: fnd_file.put_line(fnd_file.output, ' ');

207: fnd_file.put_line(fnd_file.output, 'No assignments have had a legal employer change in the specified financial year');
208: end if;
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
215:

Line 212: fnd_file.put_line(fnd_file.output, ' ');

208: end if;
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
215:
216: EXCEPTION

Line 213: fnd_file.put_line(fnd_file.output, ' ');

209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
215:
216: EXCEPTION
217: WHEN OTHERS THEN

Line 214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');

210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
215:
216: EXCEPTION
217: WHEN OTHERS THEN
218: hr_utility.trace('AU : Exception, Leaving: '|| l_proc_name);