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

Line 86: hr_utility.trace('Entering pay_us_fs_upd_pkg.update_filing_status');

82: BEGIN
83:
84: l_bug_no := 2735805 ;
85:
86: hr_utility.trace('Entering pay_us_fs_upd_pkg.update_filing_status');
87:
88: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_start));
89: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_end));
90:

Line 88: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_start));

84: l_bug_no := 2735805 ;
85:
86: hr_utility.trace('Entering pay_us_fs_upd_pkg.update_filing_status');
87:
88: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_start));
89: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_end));
90:
91: select userenv('sessionid')
92: into l_session_id

Line 89: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_end));

85:
86: hr_utility.trace('Entering pay_us_fs_upd_pkg.update_filing_status');
87:
88: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_start));
89: hr_utility.trace('The start tax rule id is: '||to_char(p_tax_rule_id_end));
90:
91: select userenv('sessionid')
92: into l_session_id
93: from dual;

Line 101: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',1);

97: LOOP
98: FETCH filing_status_cur into filing_status_rec;
99: EXIT WHEN filing_status_cur%NOTFOUND;
100:
101: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',1);
102:
103:
104: IF filing_status_rec.state_code = '03' and
105: filing_status_rec.filing_status_code in ( '04', '03', '02' )

Line 107: hr_utility.set_location('Arizona',2);

103:
104: IF filing_status_rec.state_code = '03' and
105: filing_status_rec.filing_status_code in ( '04', '03', '02' )
106: THEN
107: hr_utility.set_location('Arizona',2);
108:
109:
110: update_report_fs_rec (
111: p_pest_state_code =>

Line 125: hr_utility.set_location('Arkansas',3);

121:
122: /* ELSIF filing_status_rec.state_code = '04' and
123: filing_status_rec.filing_status_code = '03'
124: THEN
125: hr_utility.set_location('Arkansas',3);
126:
127: update_report_fs_rec (
128: p_pest_state_code =>
129: filing_status_rec.state_code,

Line 141: hr_utility.set_location('California',4);

137:
138: ELSIF filing_status_rec.state_code = '05' and
139: filing_status_rec.filing_status_code = '03'
140: THEN
141: hr_utility.set_location('California',4);
142:
143:
144: update_report_fs_rec (
145: p_pest_state_code =>

Line 159: hr_utility.set_location('Colorado ',5);

155:
156: ELSIF filing_status_rec.state_code = '06' and
157: filing_status_rec.filing_status_code = '03'
158: THEN
159: hr_utility.set_location('Colorado ',5);
160:
161: update_report_fs_rec (
162: p_pest_state_code =>
163: filing_status_rec.state_code,

Line 177: hr_utility.set_location('Connecticut',6);

173:
174: ELSIF filing_status_rec.state_code = '07' and
175: filing_status_rec.filing_status_code = '03'
176: THEN
177: hr_utility.set_location('Connecticut',6);
178:
179: update_report_fs_rec (
180: p_pest_state_code =>
181: filing_status_rec.state_code,

Line 194: hr_utility.set_location('Delaware',7);

190:
191: ELSIF filing_status_rec.state_code = '08' and
192: filing_status_rec.filing_status_code = '03'
193: THEN
194: hr_utility.set_location('Delaware',7);
195:
196: update_report_fs_rec (
197: p_pest_state_code =>
198: filing_status_rec.state_code,

Line 210: hr_utility.set_location('Georgia',8);

206:
207: ELSIF filing_status_rec.state_code = '11' and
208: filing_status_rec.filing_status_code = '04'
209: THEN
210: hr_utility.set_location('Georgia',8);
211:
212: update_report_fs_rec (
213: p_pest_state_code =>
214: filing_status_rec.state_code,

Line 226: hr_utility.set_location('Hawaii',9);

222:
223: ELSIF filing_status_rec.state_code = '12' and
224: filing_status_rec.filing_status_code = '03'
225: THEN
226: hr_utility.set_location('Hawaii',9);
227:
228: update_report_fs_rec (
229: p_pest_state_code =>
230: filing_status_rec.state_code,

Line 242: hr_utility.set_location('Idaho',10);

238:
239: ELSIF filing_status_rec.state_code = '13' and
240: filing_status_rec.filing_status_code = '03'
241: THEN
242: hr_utility.set_location('Idaho',10);
243:
244: update_report_fs_rec (
245: p_pest_state_code =>
246: filing_status_rec.state_code,

Line 258: hr_utility.set_location('Illinois',11);

254:
255: ELSIF filing_status_rec.state_code = '14' and
256: filing_status_rec.filing_status_code in ( '03', '02')
257: THEN
258: hr_utility.set_location('Illinois',11);
259:
260: update_report_fs_rec (
261: p_pest_state_code =>
262: filing_status_rec.state_code,

Line 274: hr_utility.set_location('Indiana',12);

270:
271: ELSIF filing_status_rec.state_code = '15' and
272: filing_status_rec.filing_status_code in ( '03', '02')
273: THEN
274: hr_utility.set_location('Indiana',12);
275:
276: update_report_fs_rec (
277: p_pest_state_code =>
278: filing_status_rec.state_code,

Line 290: hr_utility.set_location('Iowa',13);

286:
287: ELSIF filing_status_rec.state_code = '16' and
288: filing_status_rec.filing_status_code in ('03', '04')
289: THEN
290: hr_utility.set_location('Iowa',13);
291:
292: update_report_fs_rec (
293: p_pest_state_code =>
294: filing_status_rec.state_code,

Line 306: hr_utility.set_location('Kansas',14);

302:
303: ELSIF filing_status_rec.state_code = '17' and
304: filing_status_rec.filing_status_code = '03'
305: THEN
306: hr_utility.set_location('Kansas',14);
307:
308: update_report_fs_rec (
309: p_pest_state_code =>
310: filing_status_rec.state_code,

Line 322: hr_utility.set_location('Kentucky',15);

318:
319: ELSIF filing_status_rec.state_code = '18' and
320: filing_status_rec.filing_status_code in ( '04', '03','02')
321: THEN
322: hr_utility.set_location('Kentucky',15);
323:
324: update_report_fs_rec (
325: p_pest_state_code =>
326: filing_status_rec.state_code,

Line 338: hr_utility.set_location('Louisiana',16);

334:
335: ELSIF filing_status_rec.state_code = '19' and
336: filing_status_rec.filing_status_code in ( '04', '03', '02' )
337: THEN
338: hr_utility.set_location('Louisiana',16);
339:
340:
341: update_report_fs_rec (
342: p_pest_state_code =>

Line 355: hr_utility.set_location('Maine',17);

351:
352: ELSIF filing_status_rec.state_code = '20' and
353: filing_status_rec.filing_status_code = '03'
354: THEN
355: hr_utility.set_location('Maine',17);
356:
357: update_report_fs_rec (
358: p_pest_state_code =>
359: filing_status_rec.state_code,

Line 371: hr_utility.set_location('Maryland',18);

367:
368: ELSIF filing_status_rec.state_code = '21' and
369: filing_status_rec.filing_status_code in ( '03', '02')
370: THEN
371: hr_utility.set_location('Maryland',18);
372:
373: update_report_fs_rec (
374: p_pest_state_code =>
375: filing_status_rec.state_code,

Line 387: hr_utility.set_location('Massachusetts',19);

383:
384: ELSIF filing_status_rec.state_code = '22' and
385: filing_status_rec.filing_status_code in ( '02', '04')
386: THEN
387: hr_utility.set_location('Massachusetts',19);
388:
389: update_report_fs_rec (
390: p_pest_state_code =>
391: filing_status_rec.state_code,

Line 403: hr_utility.set_location('Michigan',20);

399:
400: ELSIF filing_status_rec.state_code = '23' and
401: filing_status_rec.filing_status_code in ( '03', '02')
402: THEN
403: hr_utility.set_location('Michigan',20);
404:
405: update_report_fs_rec (
406: p_pest_state_code =>
407: filing_status_rec.state_code,

Line 419: hr_utility.set_location('Minnesota',22);

415:
416: ELSIF filing_status_rec.state_code = '24' and
417: filing_status_rec.filing_status_code = '03'
418: THEN
419: hr_utility.set_location('Minnesota',22);
420:
421: update_report_fs_rec (
422: p_pest_state_code =>
423: filing_status_rec.state_code,

Line 438: hr_utility.set_location('Missouri',23);

434: /*
435: ELSIF filing_status_rec.state_code = '26' and
436: filing_status_rec.filing_status_code = '03'
437: THEN
438: hr_utility.set_location('Missouri',23);
439:
440: update_report_fs_rec (
441: p_pest_state_code =>
442: filing_status_rec.state_code,

Line 455: hr_utility.set_location('Montana',24);

451:
452: ELSIF filing_status_rec.state_code = '27' and
453: filing_status_rec.filing_status_code IN ( '03' )
454: THEN
455: hr_utility.set_location('Montana',24);
456:
457: update_report_fs_rec (
458: p_pest_state_code =>
459: filing_status_rec.state_code,

Line 471: hr_utility.set_location('Nebraska',25);

467:
468: ELSIF filing_status_rec.state_code = '28' and
469: filing_status_rec.filing_status_code = '03'
470: THEN
471: hr_utility.set_location('Nebraska',25);
472:
473: update_report_fs_rec (
474: p_pest_state_code =>
475: filing_status_rec.state_code,

Line 487: hr_utility.set_location('New Jersey',26);

483: /*
484: ELSIF filing_status_rec.state_code = '31' and
485: filing_status_rec.filing_status_code = '03'
486: THEN
487: hr_utility.set_location('New Jersey',26);
488:
489: update_report_fs_rec (
490: p_pest_state_code =>
491: filing_status_rec.state_code,

Line 504: hr_utility.set_location('New Mexico',27);

500:
501: ELSIF filing_status_rec.state_code = '32' and
502: filing_status_rec.filing_status_code = '03'
503: THEN
504: hr_utility.set_location('New Mexico',27);
505:
506: update_report_fs_rec (
507: p_pest_state_code =>
508: filing_status_rec.state_code,

Line 520: hr_utility.set_location('New York',28);

516:
517: ELSIF filing_status_rec.state_code = '33' and
518: filing_status_rec.filing_status_code = '03'
519: THEN
520: hr_utility.set_location('New York',28);
521:
522: update_report_fs_rec (
523: p_pest_state_code =>
524: filing_status_rec.state_code,

Line 538: hr_utility.set_location('New York',28);

534:
535: ELSIF filing_status_rec.state_code = '33' and
536: filing_status_rec.filing_status_code = '05' --Qualifying Widower
537: THEN
538: hr_utility.set_location('New York',28);
539:
540: update_report_fs_rec (
541: p_pest_state_code =>
542: filing_status_rec.state_code,

Line 558: hr_utility.set_location('North Carolina',29);

554: /*
555: ELSIF filing_status_rec.state_code = '34' and
556: filing_status_rec.filing_status_code = '03'
557: THEN
558: hr_utility.set_location('North Carolina',29);
559:
560: update_report_fs_rec (
561: p_pest_state_code =>
562: filing_status_rec.state_code,

Line 575: hr_utility.set_location('North Dakota',30);

571:
572: ELSIF filing_status_rec.state_code = '35' and
573: filing_status_rec.filing_status_code = '03'
574: THEN
575: hr_utility.set_location('North Dakota',30);
576:
577: update_report_fs_rec (
578: p_pest_state_code =>
579: filing_status_rec.state_code,

Line 591: hr_utility.set_location('Ohio',31);

587:
588: ELSIF filing_status_rec.state_code = '36' and
589: filing_status_rec.filing_status_code in ( '03', '02')
590: THEN
591: hr_utility.set_location('Ohio',31);
592:
593: update_report_fs_rec (
594: p_pest_state_code =>
595: filing_status_rec.state_code,

Line 607: hr_utility.set_location('Oklahoma',32);

603:
604: ELSIF filing_status_rec.state_code = '37' and
605: filing_status_rec.filing_status_code = '03'
606: THEN
607: hr_utility.set_location('Oklahoma',32);
608:
609: update_report_fs_rec (
610: p_pest_state_code =>
611: filing_status_rec.state_code,

Line 623: hr_utility.set_location('Oklahoma',32.1);

619:
620: ELSIF filing_status_rec.state_code = '37' and
621: filing_status_rec.filing_status_code = '04'
622: THEN
623: hr_utility.set_location('Oklahoma',32.1);
624:
625: update_report_fs_rec (
626: p_pest_state_code =>
627: filing_status_rec.state_code,

Line 639: hr_utility.set_location('Pennsylvania',33);

635:
636: ELSIF filing_status_rec.state_code = '39' and
637: filing_status_rec.filing_status_code in ( '03', '02')
638: THEN
639: hr_utility.set_location('Pennsylvania',33);
640:
641: update_report_fs_rec (
642: p_pest_state_code =>
643: filing_status_rec.state_code,

Line 655: hr_utility.set_location('Rhode Island',34);

651:
652: ELSIF filing_status_rec.state_code = '40' and
653: filing_status_rec.filing_status_code = '03'
654: THEN
655: hr_utility.set_location('Rhode Island',34);
656:
657: update_report_fs_rec (
658: p_pest_state_code =>
659: filing_status_rec.state_code,

Line 671: hr_utility.set_location('South Carolina',35);

667:
668: ELSIF filing_status_rec.state_code = '41' and
669: filing_status_rec.filing_status_code in ( '03' )
670: THEN
671: hr_utility.set_location('South Carolina',35);
672:
673: update_report_fs_rec (
674: p_pest_state_code =>
675: filing_status_rec.state_code,

Line 687: hr_utility.set_location('Vermont',36);

683:
684: ELSIF filing_status_rec.state_code = '46' and
685: filing_status_rec.filing_status_code = '03'
686: THEN
687: hr_utility.set_location('Vermont',36);
688:
689: update_report_fs_rec (
690: p_pest_state_code =>
691: filing_status_rec.state_code,

Line 703: hr_utility.set_location('Virginia',37);

699:
700: ELSIF filing_status_rec.state_code = '47' and
701: filing_status_rec.filing_status_code in ( '03', '02')
702: THEN
703: hr_utility.set_location('Virginia',37);
704:
705: update_report_fs_rec (
706: p_pest_state_code =>
707: filing_status_rec.state_code,

Line 719: hr_utility.set_location('West Virginia',38);

715:
716: ELSIF filing_status_rec.state_code = '49' and
717: filing_status_rec.filing_status_code in ( '02', '03' )
718: THEN
719: hr_utility.set_location('West Virginia',38);
720:
721: update_report_fs_rec (
722: p_pest_state_code =>
723: filing_status_rec.state_code,

Line 735: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',40);

731:
732: END IF;
733: commit;
734:
735: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',40);
736:
737: END LOOP ;
738: CLOSE filing_status_cur ;
739:

Line 740: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',45);

736:
737: END LOOP ;
738: CLOSE filing_status_cur ;
739:
740: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',45);
741:
742: EXCEPTION
743: WHEN OTHERS THEN
744: l_error_message_text := to_char(SQLCODE)||SQLERRM||

Line 748: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',50);

744: l_error_message_text := to_char(SQLCODE)||SQLERRM||
745: ' Program error contact support';
746: rollback;
747:
748: hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',50);
749: raise_application_error(-20001,l_error_message_text);
750:
751: --
752: --