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_FR_MIGRATE_TIME_ANALYSIS dependencies on HR_UTILITY

Line 135: hr_utility.set_location('Getting all assignments',22);

131: FND_FILE.PUT_LINE(FND_FILE.LOG, '=====================================================================================================');
132: --
133: -- Get all assignments and persons for the business group
134: -- and loop through them
135: hr_utility.set_location('Getting all assignments',22);
136: FOR asg_person_rec IN csr_get_all_asg LOOP
137: --
138: l_count_asg :=0;
139: -- get the date track changes for each assignment

Line 140: hr_utility.set_location('getting date track data for assignments', 22);

136: FOR asg_person_rec IN csr_get_all_asg LOOP
137: --
138: l_count_asg :=0;
139: -- get the date track changes for each assignment
140: hr_utility.set_location('getting date track data for assignments', 22);
141: FOR asg_mod_rec IN csr_get_asg_datetrk(asg_person_rec.assignment_id) LOOP
142: --
143: hr_utility.set_location('Name is :'||asg_mod_rec.full_name, 22);
144: --

Line 143: hr_utility.set_location('Name is :'||asg_mod_rec.full_name, 22);

139: -- get the date track changes for each assignment
140: hr_utility.set_location('getting date track data for assignments', 22);
141: FOR asg_mod_rec IN csr_get_asg_datetrk(asg_person_rec.assignment_id) LOOP
142: --
143: hr_utility.set_location('Name is :'||asg_mod_rec.full_name, 22);
144: --
145: l_count_asg := l_count_asg +1;
146: -- if it is the first row for the assignment
147: hr_utility.set_location('l_count_asg is'||l_count_asg, 22);

Line 147: hr_utility.set_location('l_count_asg is'||l_count_asg, 22);

143: hr_utility.set_location('Name is :'||asg_mod_rec.full_name, 22);
144: --
145: l_count_asg := l_count_asg +1;
146: -- if it is the first row for the assignment
147: hr_utility.set_location('l_count_asg is'||l_count_asg, 22);
148: IF l_count_asg =1
149: -- or the changes are for time
150: OR (l_prev_work_days <> to_number(asg_mod_rec.work_days) OR
151: l_prev_frequency <> asg_mod_rec.frequency OR

Line 154: hr_utility.set_location('Assigning values to variables from asg data',22);

150: OR (l_prev_work_days <> to_number(asg_mod_rec.work_days) OR
151: l_prev_frequency <> asg_mod_rec.frequency OR
152: l_prev_num_hours <> asg_mod_rec.normal_hours)THEN
153: -- Assign values to variables according to data
154: hr_utility.set_location('Assigning values to variables from asg data',22);
155: If asg_mod_rec.Work_days Is Null Then
156: If asg_mod_rec.Normal_hours Is Null then
157: l_fixed_time := 'N';
158: l_frequency := 'NA';

Line 185: hr_utility.set_location('getting all contracts for the person', 22);

181: l_units := 'DAY';
182: l_amount_time := to_number(asg_mod_rec.work_days);
183: End if;
184: -- For all the contracts of this person
185: hr_utility.set_location('getting all contracts for the person', 22);
186: -- convert the value to canonical format(NLS issue)
187: l_disp_canon_amt := fnd_number.number_to_canonical(l_amount_time);
188: FOR person_contr_rec IN csr_get_all_contr(asg_mod_rec.person_id) LOOP
189: l_count_contr_date :=0;

Line 195: hr_utility.set_location('asg_mod_rec.effective_start_date is: '||asg_mod_rec.effective_start_date,22);

191: -- Initialize the previous end date as start of time
192: l_prev_end_date := hr_general.start_of_time;
193: --
194: -- Loop thru' all rows
195: hr_utility.set_location('asg_mod_rec.effective_start_date is: '||asg_mod_rec.effective_start_date,22);
196: hr_utility.set_location('getting date tracked data for contracts', 22);
197: hr_utility.set_location('person_contr_rec.contract_id is: '||person_contr_rec.contract_id,22);
198: hr_utility.set_location('l_prev_end_date is: '||l_prev_end_date, 22);
199: --

Line 196: hr_utility.set_location('getting date tracked data for contracts', 22);

192: l_prev_end_date := hr_general.start_of_time;
193: --
194: -- Loop thru' all rows
195: hr_utility.set_location('asg_mod_rec.effective_start_date is: '||asg_mod_rec.effective_start_date,22);
196: hr_utility.set_location('getting date tracked data for contracts', 22);
197: hr_utility.set_location('person_contr_rec.contract_id is: '||person_contr_rec.contract_id,22);
198: hr_utility.set_location('l_prev_end_date is: '||l_prev_end_date, 22);
199: --
200: FOR contr_date_rec IN csr_all_contr_date(person_contr_rec.contract_id,

Line 197: hr_utility.set_location('person_contr_rec.contract_id is: '||person_contr_rec.contract_id,22);

193: --
194: -- Loop thru' all rows
195: hr_utility.set_location('asg_mod_rec.effective_start_date is: '||asg_mod_rec.effective_start_date,22);
196: hr_utility.set_location('getting date tracked data for contracts', 22);
197: hr_utility.set_location('person_contr_rec.contract_id is: '||person_contr_rec.contract_id,22);
198: hr_utility.set_location('l_prev_end_date is: '||l_prev_end_date, 22);
199: --
200: FOR contr_date_rec IN csr_all_contr_date(person_contr_rec.contract_id,
201: l_prev_end_date,

Line 198: hr_utility.set_location('l_prev_end_date is: '||l_prev_end_date, 22);

194: -- Loop thru' all rows
195: hr_utility.set_location('asg_mod_rec.effective_start_date is: '||asg_mod_rec.effective_start_date,22);
196: hr_utility.set_location('getting date tracked data for contracts', 22);
197: hr_utility.set_location('person_contr_rec.contract_id is: '||person_contr_rec.contract_id,22);
198: hr_utility.set_location('l_prev_end_date is: '||l_prev_end_date, 22);
199: --
200: FOR contr_date_rec IN csr_all_contr_date(person_contr_rec.contract_id,
201: l_prev_end_date,
202: asg_mod_rec.effective_start_date) LOOP

Line 207: hr_utility.set_location('l_count_contr_date is :'||l_count_contr_date,22);

203: --
204: l_count_contr_date := l_count_contr_date +1;
205: l_obj_version_number := contr_date_rec.object_version_number;
206: --
207: hr_utility.set_location('l_count_contr_date is :'||l_count_contr_date,22);
208: hr_utility.set_location('contr_date_rec.effective_start_date is: '||contr_date_rec.effective_start_date,22);
209: --
210: -- Check for matching effective dates for the first contract row
211: IF l_count_contr_date = 1

Line 208: hr_utility.set_location('contr_date_rec.effective_start_date is: '||contr_date_rec.effective_start_date,22);

204: l_count_contr_date := l_count_contr_date +1;
205: l_obj_version_number := contr_date_rec.object_version_number;
206: --
207: hr_utility.set_location('l_count_contr_date is :'||l_count_contr_date,22);
208: hr_utility.set_location('contr_date_rec.effective_start_date is: '||contr_date_rec.effective_start_date,22);
209: --
210: -- Check for matching effective dates for the first contract row
211: IF l_count_contr_date = 1
212: OR asg_mod_rec.effective_start_date = contr_date_rec.effective_start_date

Line 214: hr_utility.set_location('Updating in correction mode',22);

210: -- Check for matching effective dates for the first contract row
211: IF l_count_contr_date = 1
212: OR asg_mod_rec.effective_start_date = contr_date_rec.effective_start_date
213: THEN
214: hr_utility.set_location('Updating in correction mode',22);
215: -- update in 'CORRECTION' mode
216: hr_contract_api.update_contract
217: (P_VALIDATE => false,
218: P_CONTRACT_ID => contr_date_rec.contract_id,

Line 238: hr_utility.set_location('Inserting a row in correction mode',22);

234: l_ctr_ref := contr_date_rec.reference;
235: --
236: ELSE
237: -- insert a row in 'UPDATE' mode
238: hr_utility.set_location('Inserting a row in correction mode',22);
239: hr_contract_api.update_contract
240: (P_VALIDATE => false,
241: P_CONTRACT_ID => contr_date_rec.contract_id,
242: P_EFFECTIVE_START_DATE => l_effective_start_date,

Line 260: hr_utility.set_location('End of if for contr-asg date match',22);

256: l_prev_end_date := l_effective_end_date;
257: l_ctr_ref := contr_date_rec.reference;
258: --
259: END IF;
260: hr_utility.set_location('End of if for contr-asg date match',22);
261: END LOOP;-- end loop for within date contracts
262: --
263: hr_utility.set_location('l_count_contr_date before the row check'||l_count_contr_date,22);
264: -- If rows are not present

Line 263: hr_utility.set_location('l_count_contr_date before the row check'||l_count_contr_date,22);

259: END IF;
260: hr_utility.set_location('End of if for contr-asg date match',22);
261: END LOOP;-- end loop for within date contracts
262: --
263: hr_utility.set_location('l_count_contr_date before the row check'||l_count_contr_date,22);
264: -- If rows are not present
265: IF l_count_contr_date =0 THEN
266: -- insert a row in 'UPDATE' mode
267: hr_utility.set_location('Before the before date loop start', 22);

Line 267: hr_utility.set_location('Before the before date loop start', 22);

263: hr_utility.set_location('l_count_contr_date before the row check'||l_count_contr_date,22);
264: -- If rows are not present
265: IF l_count_contr_date =0 THEN
266: -- insert a row in 'UPDATE' mode
267: hr_utility.set_location('Before the before date loop start', 22);
268: -- With some values the same as the previous datetracked row
269: FOR contr_befdate_rec IN csr_all_contr_date(person_contr_rec.contract_id,
270: l_prev_start_date,
271: l_prev_end_date) LOOP

Line 275: hr_utility.set_location('Inserting a row where none exist', 22);

271: l_prev_end_date) LOOP
272: --
273: l_count_contr_date := l_count_contr_date +1;
274: l_obj_version_number := contr_befdate_rec.object_version_number;
275: hr_utility.set_location('Inserting a row where none exist', 22);
276: --
277: hr_contract_api.update_contract
278: (P_VALIDATE => false,
279: P_CONTRACT_ID => contr_befdate_rec.contract_id,

Line 303: hr_utility.set_location('Exiting loop for before date contracts',22);

299: END IF;
300: --
301: END LOOP;
302: -- end loop for before date contracts
303: hr_utility.set_location('Exiting loop for before date contracts',22);
304: END IF;
305: -- End if for count rows
306: -- Assigning values for writing into log files
307: l_disp_start_date := fnd_date.date_to_displaydt(DATEVAL=> l_effective_start_date);

Line 319: hr_utility.set_location('Written into log file, exiting loop for contracts',22);

315: FND_FILE.PUT(FND_FILE.LOG, ' '||l_disp_fixed_time||' '||l_disp_canon_amt||' '||l_disp_units||' '||l_disp_frequency);
316: FND_FILE.PUT(FND_FILE.LOG, ' '||asg_mod_rec.work_days||' '||to_char(asg_mod_rec.normal_hours)||' '||asg_mod_rec.frequency);
317: FND_FILE.NEW_LINE(FND_FILE.LOG,2);
318: --
319: hr_utility.set_location('Written into log file, exiting loop for contracts',22);
320: END LOOP; --end of loop for contracts
321: END IF;-- end of if for asg changes
322: -- Assign values to variables
323: l_prev_frequency := asg_mod_rec.frequency;

Line 352: hr_utility.set_location('Error:PAY_FR_MIGRATE_TIME_ANALYSIS.migrate',9999);

348: CLOSE csr_migr_script_run;
349: --
350: Exception
351: When others then
352: hr_utility.set_location('Error:PAY_FR_MIGRATE_TIME_ANALYSIS.migrate',9999);
353: Raise;
354: End Migrate;
355: End PAY_FR_MIGRATE_TIME_ANALYSIS;