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

Line 105: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);

101: lv_report_category VARCHAR2(30);
102: lv_leg_parameter VARCHAR2(300);
103:
104: BEGIN
105: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);
106:
107: open c_payroll_action(p_payroll_action_id);
108: fetch c_payroll_action into
109: ld_start_date, ld_end_date, ln_business_group_id,

Line 113: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);

109: ld_start_date, ld_end_date, ln_business_group_id,
110: lv_report_qualifier, lv_report_type,
111: lv_report_category, lv_leg_parameter;
112: if c_payroll_action%notfound then
113: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
114: hr_utility.raise_error;
115: end if;
116: close c_payroll_action;
117: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

Line 114: hr_utility.raise_error;

110: lv_report_qualifier, lv_report_type,
111: lv_report_category, lv_leg_parameter;
112: if c_payroll_action%notfound then
113: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
114: hr_utility.raise_error;
115: end if;
116: close c_payroll_action;
117: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
118:

Line 117: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

113: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
114: hr_utility.raise_error;
115: end if;
116: close c_payroll_action;
117: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
118:
119:
120: hr_utility.set_location(gv_package || '.get_payroll_action_info', 60);
121: p_start_date := ld_start_date;

Line 120: hr_utility.set_location(gv_package || '.get_payroll_action_info', 60);

116: close c_payroll_action;
117: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
118:
119:
120: hr_utility.set_location(gv_package || '.get_payroll_action_info', 60);
121: p_start_date := ld_start_date;
122: p_end_date := ld_end_date;
123: p_report_qualifier := lv_report_qualifier;
124: p_report_type := lv_report_type;

Line 128: hr_utility.set_location(gv_package || '.get_payroll_action_info', 100);

124: p_report_type := lv_report_type;
125: p_report_category := lv_report_category;
126: p_business_group_id := ln_business_group_id;
127:
128: hr_utility.set_location(gv_package || '.get_payroll_action_info', 100);
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: p_start_date := NULL;

Line 163: hr_utility.set_location(gv_package || '.range_code', 10);

159: ln_payroll_id NUMBER;
160: ln_consolidation_set_id NUMBER;
161:
162: BEGIN
163: hr_utility.set_location(gv_package || '.range_code', 10);
164: get_payroll_action_info (
165: p_payroll_action_id
166: ,ld_start_date
167: ,ld_end_date

Line 172: hr_utility.set_location(gv_package || '.range_code', 20);

168: ,lv_report_qualifier
169: ,lv_report_type
170: ,lv_report_category
171: ,ln_business_group_id);
172: hr_utility.set_location(gv_package || '.range_code', 20);
173:
174: lv_sql_string :=
175: 'select distinct paa.assignment_id
176: from pay_assignment_actions paa -- SQWL assignment action

Line 190: hr_utility.set_location(gv_package || '.range_code', 50);

186: order by paa.assignment_id
187: ';
188:
189: p_sql_string := lv_sql_string;
190: hr_utility.set_location(gv_package || '.range_code', 50);
191:
192: END range_cursor;
193:
194: /********************************************************

Line 245: hr_utility.set_location(gv_package || '.action_creation', 10);

241:
242: ln_locking_action_id NUMBER;
243:
244: BEGIN
245: hr_utility.set_location(gv_package || '.action_creation', 10);
246: get_payroll_action_info (
247: p_payroll_action_id
248: ,ld_start_date
249: ,ld_end_date

Line 255: hr_utility.set_location(gv_package || '.action_creation', 20);

251: ,lv_report_type
252: ,lv_report_category
253: ,ln_business_group_id);
254:
255: hr_utility.set_location(gv_package || '.action_creation', 20);
256: open c_get_mwr_asg( ln_business_group_id
257: ,ld_start_date
258: ,ld_end_date
259: ,p_start_assignment

Line 262: hr_utility.set_location(gv_package || '.action_creation', 30);

258: ,ld_end_date
259: ,p_start_assignment
260: ,p_end_assignment);
261: loop
262: hr_utility.set_location(gv_package || '.action_creation', 30);
263: fetch c_get_mwr_asg into ln_assignment_id, ld_effective_date,
264: ln_emp_tax_unit_id, ln_assignment_action_id;
265: if c_get_mwr_asg%notfound then
266: hr_utility.set_location(gv_package || '.action_creation', 40);

Line 266: hr_utility.set_location(gv_package || '.action_creation', 40);

262: hr_utility.set_location(gv_package || '.action_creation', 30);
263: fetch c_get_mwr_asg into ln_assignment_id, ld_effective_date,
264: ln_emp_tax_unit_id, ln_assignment_action_id;
265: if c_get_mwr_asg%notfound then
266: hr_utility.set_location(gv_package || '.action_creation', 40);
267: exit;
268: end if;
269:
270: hr_utility.set_location(gv_package || '.action_creation', 50);

Line 270: hr_utility.set_location(gv_package || '.action_creation', 50);

266: hr_utility.set_location(gv_package || '.action_creation', 40);
267: exit;
268: end if;
269:
270: hr_utility.set_location(gv_package || '.action_creation', 50);
271: select pay_assignment_actions_s.nextval
272: into ln_locking_action_id
273: from dual;
274:

Line 280: hr_utility.set_location(gv_package || '.action_creation', 60);

276:
277: -- insert into pay_assignment_actions.
278: hr_nonrun_asact.insact(ln_locking_action_id, ln_assignment_id,
279: p_payroll_action_id, p_chunk, ln_emp_tax_unit_id);
280: hr_utility.set_location(gv_package || '.action_creation', 60);
281:
282: -- insert an interlock to this action
283: hr_nonrun_asact.insint(ln_locking_action_id, ln_assignment_action_id);
284:

Line 289: hr_utility.set_location(gv_package || '.action_creation', 60);

285: update pay_assignment_actions paa
286: set paa.serial_number = ln_assignment_action_id
287: where paa.assignment_action_id = ln_locking_action_id;
288:
289: hr_utility.set_location(gv_package || '.action_creation', 60);
290: end loop;
291: close c_get_mwr_asg;
292:
293: hr_utility.set_location(gv_package || '.action_creation', 60);

Line 293: hr_utility.set_location(gv_package || '.action_creation', 60);

289: hr_utility.set_location(gv_package || '.action_creation', 60);
290: end loop;
291: close c_get_mwr_asg;
292:
293: hr_utility.set_location(gv_package || '.action_creation', 60);
294: END action_creation;
295:
296:
297:

Line 536: hr_utility.set_location(gv_package || '.' || l_procedure , 10);

532:
533:
534: BEGIN
535:
536: hr_utility.set_location(gv_package || '.' || l_procedure , 10);
537:
538: --get the session id
539: SELECT userenv('sessionid')
540: INTO v_session_id

Line 549: hr_utility.set_location(gv_package || '.' || l_procedure , 20);

545: INTO l_ppa_legislative_parameters
546: FROM pay_payroll_actions ppa
547: where ppa.payroll_action_id = p_payroll_action_id;
548:
549: hr_utility.set_location(gv_package || '.' || l_procedure , 20);
550:
551: l_est_hierarchy_id :=
552: to_number(pay_mag_utils.get_parameter('TRANSFER_HIERARCHY_ID'
553: ,'TRANSFER_HIERARCHY_VERSION'

Line 560: hr_utility.set_location(gv_package || '.' || l_procedure , 30);

556: pay_mag_utils.get_parameter('TRANSFER_HIERARCHY_VERSION'
557: ,''
558: ,l_ppa_legislative_parameters);
559:
560: hr_utility.set_location(gv_package || '.' || l_procedure , 30);
561:
562: -- cusror loop.
563: OPEN get_pact_asg;
564:

Line 569: hr_utility.set_location(gv_package || '.' || l_procedure , 40);

565: FETCH get_pact_asg into l_ass_id, l_tax_unit_id, l_sqwl_assact, l_business_group_id;
566:
567: WHILE get_pact_asg%FOUND LOOP
568:
569: hr_utility.set_location(gv_package || '.' || l_procedure , 40);
570:
571: FOR i IN 1 .. 4 LOOP
572:
573: OPEN c_asg_loc_mon(l_sqwl_assact,

Line 586: hr_utility.set_location(gv_package || '.' || l_procedure , 50);

582: CLOSE C_ASG_LOC_MON;
583: l_sit_exists := 'Y';
584: l_wage_jurisdiction_code := l_jurisdiction;
585:
586: hr_utility.set_location(gv_package || '.' || l_procedure , 50);
587:
588: -- get the sui ID for the SQWL assignment action
589: OPEN c_get_sui_code( l_tax_unit_id, l_jurisdiction );
590:

Line 636: hr_utility.set_location(gv_package || '.' || l_procedure , 60);

632: close c_get_sqwl_month_count;
633:
634: -- get the value for the A_SIT_GROSS_PER_JD_GRE_MON_* archive item.
635:
636: hr_utility.set_location(gv_package || '.' || l_procedure , 60);
637: OPEN c_get_sui_subject ( l_sqwl_assact
638: ,l_user_entity_id
639: ,l_tax_unit_id
640: ,l_jurisdiction);

Line 798: hr_utility.set_location(gv_package || '.' || l_procedure , 70);

794: END IF;
795:
796:
797: -- derive the establishment
798: hr_utility.set_location(gv_package || '.' || l_procedure , 70);
799:
800: IF l_location_id <> -99999 THEN
801: OPEN c_derive_wksite_estab( l_hierarchy_ver_id,
802: l_location_id);

Line 816: hr_utility.set_location(gv_package || '.' || l_procedure , 80);

812: l_worksite := -99999;
813: END IF;
814:
815: -- Write the us_rpt_totals record
816: hr_utility.set_location(gv_package || '.' || l_procedure , 80);
817:
818: IF i = 1 THEN -- UPDATING / INSERTING into column value1
819: hr_utility.set_location(gv_package || '.' || l_procedure , 90);
820: UPDATE pay_us_rpt_totals prt

Line 819: hr_utility.set_location(gv_package || '.' || l_procedure , 90);

815: -- Write the us_rpt_totals record
816: hr_utility.set_location(gv_package || '.' || l_procedure , 80);
817:
818: IF i = 1 THEN -- UPDATING / INSERTING into column value1
819: hr_utility.set_location(gv_package || '.' || l_procedure , 90);
820: UPDATE pay_us_rpt_totals prt
821: SET prt.value1 = NVL(prt.value1,0) + 1
822: WHERE prt.session_id = v_session_id
823: AND prt.organization_id = p_payroll_action_id

Line 831: hr_utility.set_location(gv_package || '.' || l_procedure , 100);

827: and prt.attribute2 = l_sui_id
828: and prt.attribute3 = l_fed_ein;
829:
830: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
831: hr_utility.set_location(gv_package || '.' || l_procedure , 100);
832:
833: INSERT into pay_us_rpt_totals
834: ( session_id
835: ,organization_id

Line 853: hr_utility.set_location(gv_package || '.' || l_procedure , 110);

849: ,l_fed_ein
850: ,1);
851: END IF;
852: ELSIF i = 2 THEN -- UPDATING / INSERTING into Column value2
853: hr_utility.set_location(gv_package || '.' || l_procedure , 110);
854: UPDATE pay_us_rpt_totals prt
855: SET prt.value2 = NVL(prt.value2,0) + 1
856: WHERE prt.session_id = v_session_id
857: AND prt.organization_id = p_payroll_action_id

Line 865: hr_utility.set_location(gv_package || '.' || l_procedure , 120);

861: and prt.attribute2 = l_sui_id
862: and prt.attribute3 = l_fed_ein;
863:
864: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
865: hr_utility.set_location(gv_package || '.' || l_procedure , 120);
866:
867: INSERT into pay_us_rpt_totals
868: ( session_id
869: ,organization_id

Line 887: hr_utility.set_location(gv_package || '.' || l_procedure , 130);

883: ,l_fed_ein
884: ,1);
885: END IF;
886: ELSIF i = 3 THEN -- UPDATING / INSERTING into column value3
887: hr_utility.set_location(gv_package || '.' || l_procedure , 130);
888: UPDATE pay_us_rpt_totals prt
889: SET prt.value3 = NVL(prt.value3,0) + 1
890: WHERE prt.session_id = v_session_id
891: AND prt.organization_id = p_payroll_action_id

Line 899: hr_utility.set_location(gv_package || '.' || l_procedure , 140);

895: and prt.attribute2 = l_sui_id
896: and prt.attribute3 = l_fed_ein;
897:
898: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
899: hr_utility.set_location(gv_package || '.' || l_procedure , 140);
900:
901: INSERT into pay_us_rpt_totals
902: ( session_id
903: ,organization_id

Line 921: hr_utility.set_location(gv_package || '.' || l_procedure , 150);

917: ,l_fed_ein
918: ,1);
919: END IF;
920: ELSE -- UPDATING / INSERTING into column value4
921: hr_utility.set_location(gv_package || '.' || l_procedure , 150);
922:
923: UPDATE pay_us_rpt_totals prt
924: SET prt.value4 = NVL(prt.value4,0) + l_archive_value
925: WHERE prt.session_id = v_session_id

Line 934: hr_utility.set_location(gv_package || '.' || l_procedure , 160);

930: and prt.attribute2 = l_sui_id
931: and prt.attribute3 = l_fed_ein;
932:
933: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
934: hr_utility.set_location(gv_package || '.' || l_procedure , 160);
935:
936: INSERT into pay_us_rpt_totals
937: ( session_id
938: ,organization_id