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

Line 38: hr_utility.trace('Entering the print_report_address');

34: select userenv('sessionid')
35: into l_session_id
36: from dual;
37:
38: hr_utility.trace('Entering the print_report_address');
39:
40: req_id:=fnd_profile.value('CONC_REQUEST_ID');
41: print_buffer:= 'N'; /*can be retrieved from fnd_profile.value('CONC_PRINT_TOGETHER'), if
42: set to 'Y' then will print the report only if all the processes are

Line 75: hr_utility.trace(' Error While Indiana Year Begin Address Report' );

71: l_rep_req_id := fnd_request.submit_request(application => 'PAY',
72: program => 'PYUSINRP');
73:
74: IF(l_rep_req_id = 0) THEN
75: hr_utility.trace(' Error While Indiana Year Begin Address Report' );
76: hr_utility.raise_error;
77: ELSE
78: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
79: ||to_char(l_rep_req_id));

Line 76: hr_utility.raise_error;

72: program => 'PYUSINRP');
73:
74: IF(l_rep_req_id = 0) THEN
75: hr_utility.trace(' Error While Indiana Year Begin Address Report' );
76: hr_utility.raise_error;
77: ELSE
78: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
79: ||to_char(l_rep_req_id));
80: END IF; /* if l_rep_req_id */

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

74: IF(l_rep_req_id = 0) THEN
75: hr_utility.trace(' Error While Indiana Year Begin Address Report' );
76: hr_utility.raise_error;
77: ELSE
78: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
79: ||to_char(l_rep_req_id));
80: END IF; /* if l_rep_req_id */
81:
82: COMMIT;

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

81:
82: COMMIT;
83:
84: /* Wait for report request completion */
85: hr_utility.trace('Waiting for the application to get completed ');
86:
87: /* Check for Report Request Status */
88:
89: l6_wait := fnd_concurrent.wait_for_request

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

94: ,dev_phase => l6_dev_phase
95: ,dev_status => l6_dev_status
96: ,message => l6_message);
97:
98: hr_utility.trace('Wait completed,Printing output based on the result');
99:
100: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
101: hr_utility.trace('SQL Report - Indiana Address Exited with error') ;
102: retcode := 2;

Line 101: hr_utility.trace('SQL Report - Indiana Address Exited with error') ;

97:
98: hr_utility.trace('Wait completed,Printing output based on the result');
99:
100: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
101: hr_utility.trace('SQL Report - Indiana Address Exited with error') ;
102: retcode := 2;
103: ELSE
104: hr_utility.trace('SQL Report - Indiana Address Successful');
105: END IF; /* l6_dev_phase */

Line 104: hr_utility.trace('SQL Report - Indiana Address Successful');

100: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
101: hr_utility.trace('SQL Report - Indiana Address Exited with error') ;
102: retcode := 2;
103: ELSE
104: hr_utility.trace('SQL Report - Indiana Address Successful');
105: END IF; /* l6_dev_phase */
106:
107:
108: DELETE

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

113: COMMIT;
114:
115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN
117: hr_utility.trace('Exception : No data Found');
118: --
119: -- Set up error message and error return code.
120: --
121:

Line 122: errbuf := hr_utility.get_message;

118: --
119: -- Set up error message and error return code.
120: --
121:
122: errbuf := hr_utility.get_message;
123: retcode := 2;
124: WHEN OTHERS THEN
125: hr_utility.trace('Excption : When Others');
126: --

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

121:
122: errbuf := hr_utility.get_message;
123: retcode := 2;
124: WHEN OTHERS THEN
125: hr_utility.trace('Excption : When Others');
126: --
127: -- Set up error message and error return code.
128: --
129:

Line 130: errbuf := hr_utility.get_message;

126: --
127: -- Set up error message and error return code.
128: --
129:
130: errbuf := hr_utility.get_message;
131: retcode := 2;
132: END print_report_address;
133:
134:

Line 159: hr_utility.trace('Entering the print_report_address');

155: BEGIN
156: -- initialise variables - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
157: retcode := 0;
158:
159: hr_utility.trace('Entering the print_report_address');
160:
161: req_id:=fnd_profile.value('CONC_REQUEST_ID');
162: print_buffer:= 'N'; /*can be retrieved from fnd_profile.value('CONC_PRINT_TOGETHER'), if
163: set to 'Y' then will print the report only if all the processes are

Line 198: hr_utility.trace(' Error While Indiana Year Begin Address Report' );

194: argument1 => p_business_group,
195: argument2 => p_curr_year);
196:
197: IF(l_rep_req_id = 0) THEN
198: hr_utility.trace(' Error While Indiana Year Begin Address Report' );
199: hr_utility.raise_error;
200: ELSE
201: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
202: ||to_char(l_rep_req_id));

Line 199: hr_utility.raise_error;

195: argument2 => p_curr_year);
196:
197: IF(l_rep_req_id = 0) THEN
198: hr_utility.trace(' Error While Indiana Year Begin Address Report' );
199: hr_utility.raise_error;
200: ELSE
201: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
202: ||to_char(l_rep_req_id));
203: END IF; /* if l_rep_req_id */

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

197: IF(l_rep_req_id = 0) THEN
198: hr_utility.trace(' Error While Indiana Year Begin Address Report' );
199: hr_utility.raise_error;
200: ELSE
201: hr_utility.trace(' Concurrent Request Id (Report Spool Request) : '
202: ||to_char(l_rep_req_id));
203: END IF; /* if l_rep_req_id */
204:
205: COMMIT;

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

204:
205: COMMIT;
206:
207: /* Wait for report request completion */
208: hr_utility.trace('Waiting for the application to get completed ');
209:
210: /* Check for Report Request Status */
211:
212: l6_wait := fnd_concurrent.wait_for_request

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

217: ,dev_phase => l6_dev_phase
218: ,dev_status => l6_dev_status
219: ,message => l6_message);
220:
221: hr_utility.trace('Wait completed,Printing output based on the result');
222:
223: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
224: hr_utility.trace('SQL Report Override Location Exited with error') ;
225: retcode := 2;

Line 224: hr_utility.trace('SQL Report Override Location Exited with error') ;

220:
221: hr_utility.trace('Wait completed,Printing output based on the result');
222:
223: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
224: hr_utility.trace('SQL Report Override Location Exited with error') ;
225: retcode := 2;
226: ELSE
227: hr_utility.trace('SQL Report Override Loaction Successful');
228: END IF; /* l6_dev_phase */

Line 227: hr_utility.trace('SQL Report Override Loaction Successful');

223: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
224: hr_utility.trace('SQL Report Override Location Exited with error') ;
225: retcode := 2;
226: ELSE
227: hr_utility.trace('SQL Report Override Loaction Successful');
228: END IF; /* l6_dev_phase */
229:
230:
231: EXCEPTION

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

229:
230:
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN
233: hr_utility.trace('Exception : No data Found');
234: --
235: -- Set up error message and error return code.
236: --
237:

Line 238: errbuf := hr_utility.get_message;

234: --
235: -- Set up error message and error return code.
236: --
237:
238: errbuf := hr_utility.get_message;
239: retcode := 2;
240: WHEN OTHERS THEN
241: hr_utility.trace('Exception : When Others');
242: --

Line 241: hr_utility.trace('Exception : When Others');

237:
238: errbuf := hr_utility.get_message;
239: retcode := 2;
240: WHEN OTHERS THEN
241: hr_utility.trace('Exception : When Others');
242: --
243: -- Set up error message and error return code.
244: --
245:

Line 246: errbuf := hr_utility.get_message;

242: --
243: -- Set up error message and error return code.
244: --
245:
246: errbuf := hr_utility.get_message;
247: retcode := 2;
248: END print_override_location;
249:
250:

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

281:
282: l_proc_name varchar2(50) := 'get_insert_value';
283:
284: BEGIN
285: hr_utility.trace('In proc : get_insert_values');
286: -- hr_utility.trace('Person Id : ' || to_char(p_person_id));
287: --hr_utility.trace('Location Id : ' || to_char(p_location_id));
288:
289: IF p_proc_name = 'INDIANA_YEAR_BEGIN_ADDRESS' THEN

Line 286: -- hr_utility.trace('Person Id : ' || to_char(p_person_id));

282: l_proc_name varchar2(50) := 'get_insert_value';
283:
284: BEGIN
285: hr_utility.trace('In proc : get_insert_values');
286: -- hr_utility.trace('Person Id : ' || to_char(p_person_id));
287: --hr_utility.trace('Location Id : ' || to_char(p_location_id));
288:
289: IF p_proc_name = 'INDIANA_YEAR_BEGIN_ADDRESS' THEN
290:

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

283:
284: BEGIN
285: hr_utility.trace('In proc : get_insert_values');
286: -- hr_utility.trace('Person Id : ' || to_char(p_person_id));
287: --hr_utility.trace('Location Id : ' || to_char(p_location_id));
288:
289: IF p_proc_name = 'INDIANA_YEAR_BEGIN_ADDRESS' THEN
290:
291: hr_utility.trace('Entering : ' || l_proc_name);

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

287: --hr_utility.trace('Location Id : ' || to_char(p_location_id));
288:
289: IF p_proc_name = 'INDIANA_YEAR_BEGIN_ADDRESS' THEN
290:
291: hr_utility.trace('Entering : ' || l_proc_name);
292:
293: /* get the detail of the person */
294:
295: OPEN csr_person_details;

Line 302: hr_utility.trace('csr_person_details failed');

298: INTO p_full_name,
299: p_employee_number;
300:
301: IF csr_person_details%NOTFOUND THEN
302: hr_utility.trace('csr_person_details failed');
303: END IF;
304:
305:
306: CLOSE csr_person_details;

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

315:
316: CLOSE cst_get_gre_name;
317:
318: END IF;
319: hr_utility.trace('GRE NAME : ' || p_gre_name);
320: hr_utility.trace('Full NAME : ' || p_full_name);
321: hr_utility.trace('Employee Number: ' || p_employee_number);
322:
323: hr_utility.trace('Leaving : ' || l_proc_name);

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

316: CLOSE cst_get_gre_name;
317:
318: END IF;
319: hr_utility.trace('GRE NAME : ' || p_gre_name);
320: hr_utility.trace('Full NAME : ' || p_full_name);
321: hr_utility.trace('Employee Number: ' || p_employee_number);
322:
323: hr_utility.trace('Leaving : ' || l_proc_name);
324: EXCEPTION

Line 321: hr_utility.trace('Employee Number: ' || p_employee_number);

317:
318: END IF;
319: hr_utility.trace('GRE NAME : ' || p_gre_name);
320: hr_utility.trace('Full NAME : ' || p_full_name);
321: hr_utility.trace('Employee Number: ' || p_employee_number);
322:
323: hr_utility.trace('Leaving : ' || l_proc_name);
324: EXCEPTION
325: WHEN OTHERS THEN

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

319: hr_utility.trace('GRE NAME : ' || p_gre_name);
320: hr_utility.trace('Full NAME : ' || p_full_name);
321: hr_utility.trace('Employee Number: ' || p_employee_number);
322:
323: hr_utility.trace('Leaving : ' || l_proc_name);
324: EXCEPTION
325: WHEN OTHERS THEN
326: hr_utility.trace('Leaving : ' || l_proc_name || ' With Erorr' );
327:

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

322:
323: hr_utility.trace('Leaving : ' || l_proc_name);
324: EXCEPTION
325: WHEN OTHERS THEN
326: hr_utility.trace('Leaving : ' || l_proc_name || ' With Erorr' );
327:
328: END get_insert_values ;
329:
330:

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

365: l_proc_name varchar2(50) := 'put_into_temp_table';
366: l_session_id number;
367:
368: BEGIN
369: hr_utility.trace('Entering :' || l_proc_name);
370:
371: select userenv('sessionid')
372: into l_session_id
373: from dual;

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

408: p_error,
409: p_mesg);
410:
411:
412: hr_utility.trace('Leaving : ' || l_proc_name);
413: EXCEPTION
414:
415: WHEN others THEN
416: hr_utility.trace('Error in the Instertion into temporary Table');

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

412: hr_utility.trace('Leaving : ' || l_proc_name);
413: EXCEPTION
414:
415: WHEN others THEN
416: hr_utility.trace('Error in the Instertion into temporary Table');
417: END put_into_temp_table;
418:
419:
420: procedure update_address(errbuf OUT NOCOPY VARCHAR2,

Line 467: -- hr_utility.trace_on(null,'oracle');

463: l_ovr_add_rec csr_get_add%rowtype;
464:
465: begin
466:
467: -- hr_utility.trace_on(null,'oracle');
468: /* Get the addresses which has an tax override address of Indiana prior to
469: or as of 1-JAN-2001 */
470:
471: l_last_year := p_curr_year - 1;

Line 476: hr_utility.trace('Updating the Per_Addresses for the esisting records...');

472: l_last_day := to_date('31-DEC-'||l_last_year,'DD/MM/YYYY');
473:
474: open csr_get_add ;
475:
476: hr_utility.trace('Updating the Per_Addresses for the esisting records...');
477:
478: loop
479:
480: fetch csr_get_add into l_add_rec;

Line 491: hr_utility.trace('Updated Addresses : ' || to_char(l_add_rec.address_id));

487: update PER_ADDRESSES
488: set date_to = l_last_day
489: where address_id = l_add_rec.address_id;
490:
491: hr_utility.trace('Updated Addresses : ' || to_char(l_add_rec.address_id));
492:
493: insert into PER_ADDRESSES
494: (ADDRESS_ID,
495: BUSINESS_GROUP_ID,

Line 619: -- hr_utility.trace('Updated Addresses : ' ||

615: l_add_rec.ADD_INFORMATION15,
616: l_add_rec.ADD_INFORMATION16
617: ) ;
618:
619: -- hr_utility.trace('Updated Addresses : ' ||
620: -- to_char(l_add_rec.address_id));
621:
622: get_insert_values(
623: 'INDIANA_YEAR_BEGIN_ADDRESS',

Line 652: hr_utility.trace('Getting addresses where the priomary state is IN and Override is not IN...');

648: close csr_get_add;
649:
650: open csr_get_ovr_add ;
651:
652: hr_utility.trace('Getting addresses where the priomary state is IN and Override is not IN...');
653:
654: loop
655:
656: fetch csr_get_ovr_add into l_ovr_add_rec;