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

Line 23: hr_utility.trace('Entering the cnt_print_report');

19:
20: l_session_id number;
21:
22: BEGIN
23: hr_utility.trace('Entering the cnt_print_report');
24: l_rep_req_id := fnd_request.submit_request(application => 'PAY',
25: program => 'LOCCHNREP');
26:
27: select userenv('sessionid')

Line 32: hr_utility.trace(' Error While Location change Report' );

28: into l_session_id
29: from dual;
30:
31: IF(l_rep_req_id = 0) THEN
32: hr_utility.trace(' Error While Location change Report' );
33: hr_utility.raise_error;
34: ELSE
35: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
36: ||to_char(l_rep_req_id));

Line 33: hr_utility.raise_error;

29: from dual;
30:
31: IF(l_rep_req_id = 0) THEN
32: hr_utility.trace(' Error While Location change Report' );
33: hr_utility.raise_error;
34: ELSE
35: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
36: ||to_char(l_rep_req_id));
37: END IF; /* if l_rep_req_id */

Line 35: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '

31: IF(l_rep_req_id = 0) THEN
32: hr_utility.trace(' Error While Location change Report' );
33: hr_utility.raise_error;
34: ELSE
35: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
36: ||to_char(l_rep_req_id));
37: END IF; /* if l_rep_req_id */
38:
39: COMMIT;

Line 42: hr_utility.trace('Waiting for the application to get completed ');

38:
39: COMMIT;
40:
41: /* Wait for report request completion */
42: hr_utility.trace('Waiting for the application to get completed ');
43:
44: /* Check for Report Request Status */
45:
46: l6_wait := fnd_concurrent.wait_for_request

Line 55: hr_utility.trace('Wait completed,Printing output based on the result');

51: ,dev_phase => l6_dev_phase
52: ,dev_status => l6_dev_status
53: ,message => l6_message);
54:
55: hr_utility.trace('Wait completed,Printing output based on the result');
56:
57: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
58: hr_utility.trace('SQL Report Exited with error') ;
59: ELSE

Line 58: hr_utility.trace('SQL Report Exited with error') ;

54:
55: hr_utility.trace('Wait completed,Printing output based on the result');
56:
57: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
58: hr_utility.trace('SQL Report Exited with error') ;
59: ELSE
60: hr_utility.trace('SQL Report Successful');
61: END IF; /* l6_dev_phase */
62:

Line 60: hr_utility.trace('SQL Report Successful');

56:
57: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
58: hr_utility.trace('SQL Report Exited with error') ;
59: ELSE
60: hr_utility.trace('SQL Report Successful');
61: END IF; /* l6_dev_phase */
62:
63:
64: DELETE

Line 72: hr_utility.trace('Exception : No data Found');

68:
69: COMMIT;
70: EXCEPTION
71: WHEN NO_DATA_FOUND THEN
72: hr_utility.trace('Exception : No data Found');
73: WHEN OTHERS THEN
74: hr_utility.trace('Excption : When Others');
75: END cnt_print_report;
76:

Line 74: hr_utility.trace('Excption : When Others');

70: EXCEPTION
71: WHEN NO_DATA_FOUND THEN
72: hr_utility.trace('Exception : No data Found');
73: WHEN OTHERS THEN
74: hr_utility.trace('Excption : When Others');
75: END cnt_print_report;
76:
77:
78:

Line 120: hr_utility.trace('In proc : get_insert_values');

116:
117: l_proc_name varchar2(50) := 'get_insert_value';
118:
119: BEGIN
120: hr_utility.trace('In proc : get_insert_values');
121: hr_utility.trace('Assignment Id : ' || to_char(p_assignment_id));
122: hr_utility.trace('Location Id : ' || to_char(p_location_id));
123:
124: IF p_proc_name = 'LOCATION_CHANGE' THEN

Line 121: hr_utility.trace('Assignment Id : ' || to_char(p_assignment_id));

117: l_proc_name varchar2(50) := 'get_insert_value';
118:
119: BEGIN
120: hr_utility.trace('In proc : get_insert_values');
121: hr_utility.trace('Assignment Id : ' || to_char(p_assignment_id));
122: hr_utility.trace('Location Id : ' || to_char(p_location_id));
123:
124: IF p_proc_name = 'LOCATION_CHANGE' THEN
125:

Line 122: hr_utility.trace('Location Id : ' || to_char(p_location_id));

118:
119: BEGIN
120: hr_utility.trace('In proc : get_insert_values');
121: hr_utility.trace('Assignment Id : ' || to_char(p_assignment_id));
122: hr_utility.trace('Location Id : ' || to_char(p_location_id));
123:
124: IF p_proc_name = 'LOCATION_CHANGE' THEN
125:
126: hr_utility.trace('Entering : ' || l_proc_name);

Line 126: hr_utility.trace('Entering : ' || l_proc_name);

122: hr_utility.trace('Location Id : ' || to_char(p_location_id));
123:
124: IF p_proc_name = 'LOCATION_CHANGE' THEN
125:
126: hr_utility.trace('Entering : ' || l_proc_name);
127:
128: /* get the detail of the person */
129:
130: OPEN csr_assignment_tax_detail;

Line 138: hr_utility.trace('csr_assignment_tax_datail_failed');

134: p_full_name,
135: p_assignment_number;
136:
137: IF csr_assignment_tax_detail%NOTFOUND THEN
138: hr_utility.trace('csr_assignment_tax_datail_failed');
139: END IF;
140:
141:
142: CLOSE csr_assignment_tax_detail;

Line 154: hr_utility.trace('GRE NAME : ' || p_gre_name);

150: INTO p_location_code;
151:
152:
153: END IF;
154: hr_utility.trace('GRE NAME : ' || p_gre_name);
155: hr_utility.trace('Full NAME : ' || p_full_name);
156: hr_utility.trace('Assignment Number: ' || p_assignment_number);
157: hr_utility.trace('Location Code : ' || p_location_code);
158:

Line 155: hr_utility.trace('Full NAME : ' || p_full_name);

151:
152:
153: END IF;
154: hr_utility.trace('GRE NAME : ' || p_gre_name);
155: hr_utility.trace('Full NAME : ' || p_full_name);
156: hr_utility.trace('Assignment Number: ' || p_assignment_number);
157: hr_utility.trace('Location Code : ' || p_location_code);
158:
159: hr_utility.trace('Leaving : ' || l_proc_name);

Line 156: hr_utility.trace('Assignment Number: ' || p_assignment_number);

152:
153: END IF;
154: hr_utility.trace('GRE NAME : ' || p_gre_name);
155: hr_utility.trace('Full NAME : ' || p_full_name);
156: hr_utility.trace('Assignment Number: ' || p_assignment_number);
157: hr_utility.trace('Location Code : ' || p_location_code);
158:
159: hr_utility.trace('Leaving : ' || l_proc_name);
160: EXCEPTION

Line 157: hr_utility.trace('Location Code : ' || p_location_code);

153: END IF;
154: hr_utility.trace('GRE NAME : ' || p_gre_name);
155: hr_utility.trace('Full NAME : ' || p_full_name);
156: hr_utility.trace('Assignment Number: ' || p_assignment_number);
157: hr_utility.trace('Location Code : ' || p_location_code);
158:
159: hr_utility.trace('Leaving : ' || l_proc_name);
160: EXCEPTION
161: WHEN OTHERS THEN

Line 159: hr_utility.trace('Leaving : ' || l_proc_name);

155: hr_utility.trace('Full NAME : ' || p_full_name);
156: hr_utility.trace('Assignment Number: ' || p_assignment_number);
157: hr_utility.trace('Location Code : ' || p_location_code);
158:
159: hr_utility.trace('Leaving : ' || l_proc_name);
160: EXCEPTION
161: WHEN OTHERS THEN
162: hr_utility.trace('Leaving : ' || l_proc_name || ' With Erorr' );
163:

Line 162: hr_utility.trace('Leaving : ' || l_proc_name || ' With Erorr' );

158:
159: hr_utility.trace('Leaving : ' || l_proc_name);
160: EXCEPTION
161: WHEN OTHERS THEN
162: hr_utility.trace('Leaving : ' || l_proc_name || ' With Erorr' );
163:
164: END get_insert_values ;
165:
166:

Line 192: hr_utility.trace('Entering :' || l_proc_name);

188: l_proc_name varchar2(50) := 'put_into_temp_table';
189: l_session_id number;
190:
191: BEGIN
192: hr_utility.trace('Entering :' || l_proc_name);
193:
194: select userenv('sessionid')
195: into l_session_id
196: from dual;

Line 223: hr_utility.trace('Leaving : ' || l_proc_name);

219: p_error,
220: 'LOCATION_CHANGE');
221:
222:
223: hr_utility.trace('Leaving : ' || l_proc_name);
224: EXCEPTION
225:
226: WHEN others THEN
227: hr_utility.trace('Error in the Instertion into temporary Table');

Line 227: hr_utility.trace('Error in the Instertion into temporary Table');

223: hr_utility.trace('Leaving : ' || l_proc_name);
224: EXCEPTION
225:
226: WHEN others THEN
227: hr_utility.trace('Error in the Instertion into temporary Table');
228: END put_into_temp_table;
229:
230:
231: procedure update_tax(errbuf OUT NOCOPY VARCHAR2,

Line 296: --hr_utility.trace_on(NULL,'PYLC');

292: and effective_start_date >= p_def_date
293: order by effective_start_date;
294:
295: begin
296: --hr_utility.trace_on(NULL,'PYLC');
297: hr_utility.trace('In Proc. UPDATE_TAX');
298:
299: for emp_rec in csr_get_employee(p_location_id) loop
300: l_error := ' '; --bug 3265603

Line 297: hr_utility.trace('In Proc. UPDATE_TAX');

293: order by effective_start_date;
294:
295: begin
296: --hr_utility.trace_on(NULL,'PYLC');
297: hr_utility.trace('In Proc. UPDATE_TAX');
298:
299: for emp_rec in csr_get_employee(p_location_id) loop
300: l_error := ' '; --bug 3265603
301:

Line 304: HR_UTILITY.TRACE('THE ASSIGNMENT TYPE IS '||emp_rec.assignment_type);

300: l_error := ' '; --bug 3265603
301:
302: /* Rmonge 18-JAN-2002 BUG 2110744 */
303:
304: HR_UTILITY.TRACE('THE ASSIGNMENT TYPE IS '||emp_rec.assignment_type);
305: if emp_rec.assignment_type <> 'B' Then
306:
307: HR_UTILITY.TRACE('Assignment Type is not B');
308:

Line 307: HR_UTILITY.TRACE('Assignment Type is not B');

303:
304: HR_UTILITY.TRACE('THE ASSIGNMENT TYPE IS '||emp_rec.assignment_type);
305: if emp_rec.assignment_type <> 'B' Then
306:
307: HR_UTILITY.TRACE('Assignment Type is not B');
308:
309: l_tmp_location_id := null;
310: l_tbl_location_id := null;
311: l_tbl_start_date := null;

Line 337: hr_utility.set_location('update_tax', 55);

333: l_tbl_start_date := cur_start_date;
334: l_tbl_end_date := cur_end_date;
335: While csr_assignment_locations%FOUND loop
336: --
337: hr_utility.set_location('update_tax', 55);
338: --
339: --
340: -- Store all assignment records.
341: --

Line 349: hr_utility.trace('Assignment location found ');

345: cur_start_date,
346: cur_end_date;
347:
348: if csr_assignment_locations%FOUND then
349: hr_utility.trace('Assignment location found ');
350: hr_utility.trace('Cur location id is ' || to_char(cur_location_id));
351: hr_utility.trace('P_location_id is ' || to_char(p_location_id));
352: hr_utility.trace('cur_ovr_location_id is '||to_char(cur_ovr_location_id));
353:

Line 350: hr_utility.trace('Cur location id is ' || to_char(cur_location_id));

346: cur_end_date;
347:
348: if csr_assignment_locations%FOUND then
349: hr_utility.trace('Assignment location found ');
350: hr_utility.trace('Cur location id is ' || to_char(cur_location_id));
351: hr_utility.trace('P_location_id is ' || to_char(p_location_id));
352: hr_utility.trace('cur_ovr_location_id is '||to_char(cur_ovr_location_id));
353:
354: if cur_location_id = p_location_id or cur_ovr_location_id = p_location_id then

Line 351: hr_utility.trace('P_location_id is ' || to_char(p_location_id));

347:
348: if csr_assignment_locations%FOUND then
349: hr_utility.trace('Assignment location found ');
350: hr_utility.trace('Cur location id is ' || to_char(cur_location_id));
351: hr_utility.trace('P_location_id is ' || to_char(p_location_id));
352: hr_utility.trace('cur_ovr_location_id is '||to_char(cur_ovr_location_id));
353:
354: if cur_location_id = p_location_id or cur_ovr_location_id = p_location_id then
355: l_tmp_location_id := p_location_id;

Line 352: hr_utility.trace('cur_ovr_location_id is '||to_char(cur_ovr_location_id));

348: if csr_assignment_locations%FOUND then
349: hr_utility.trace('Assignment location found ');
350: hr_utility.trace('Cur location id is ' || to_char(cur_location_id));
351: hr_utility.trace('P_location_id is ' || to_char(p_location_id));
352: hr_utility.trace('cur_ovr_location_id is '||to_char(cur_ovr_location_id));
353:
354: if cur_location_id = p_location_id or cur_ovr_location_id = p_location_id then
355: l_tmp_location_id := p_location_id;
356: else

Line 359: hr_utility.trace('l_tbl_location_id is '|| to_char(l_tbl_location_id));

355: l_tmp_location_id := p_location_id;
356: else
357: l_tmp_location_id := cur_location_id;
358: end if;
359: hr_utility.trace('l_tbl_location_id is '|| to_char(l_tbl_location_id));
360:
361: if l_tbl_location_id <> l_tmp_location_id then
362: hr_utility.trace('l_tbl_location_id <> l_tmp_location id ');
363:

Line 362: hr_utility.trace('l_tbl_location_id <> l_tmp_location id ');

358: end if;
359: hr_utility.trace('l_tbl_location_id is '|| to_char(l_tbl_location_id));
360:
361: if l_tbl_location_id <> l_tmp_location_id then
362: hr_utility.trace('l_tbl_location_id <> l_tmp_location id ');
363:
364: if l_tbl_location_id = p_location_id then
365: hr_utility.trace('l_tbl_location_id = p_location_id ');
366: begin

Line 365: hr_utility.trace('l_tbl_location_id = p_location_id ');

361: if l_tbl_location_id <> l_tmp_location_id then
362: hr_utility.trace('l_tbl_location_id <> l_tmp_location id ');
363:
364: if l_tbl_location_id = p_location_id then
365: hr_utility.trace('l_tbl_location_id = p_location_id ');
366: begin
367:
368: pay_us_emp_dt_tax_rules.default_tax_with_validation(
369: p_assignment_id => emp_rec.assignment_id,

Line 395: hr_utility.trace('l_tbl_location_id = p_location_id');

391: else
392: l_tbl_end_date := cur_end_date;
393: end if;
394: else
395: hr_utility.trace('l_tbl_location_id = p_location_id');
396:
397: if l_tbl_location_id = p_location_id then
398: begin
399: pay_us_emp_dt_tax_rules.default_tax_with_validation(