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 122: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);

118: lv_report_category VARCHAR2(30);
119: lv_leg_parameter VARCHAR2(300);
120:
121: BEGIN
122: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);
123:
124: open c_payroll_action(p_payroll_action_id);
125: fetch c_payroll_action into
126: ld_start_date, ld_end_date, ln_business_group_id,

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

126: ld_start_date, ld_end_date, ln_business_group_id,
127: lv_report_qualifier, lv_report_type,
128: lv_report_category, lv_leg_parameter;
129: if c_payroll_action%notfound then
130: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
131: hr_utility.raise_error;
132: end if;
133: close c_payroll_action;
134: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

Line 131: hr_utility.raise_error;

127: lv_report_qualifier, lv_report_type,
128: lv_report_category, lv_leg_parameter;
129: if c_payroll_action%notfound then
130: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
131: hr_utility.raise_error;
132: end if;
133: close c_payroll_action;
134: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
135:

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

130: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
131: hr_utility.raise_error;
132: end if;
133: close c_payroll_action;
134: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
135:
136:
137: hr_utility.set_location(gv_package || '.get_payroll_action_info', 60);
138: p_start_date := ld_start_date;

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

133: close c_payroll_action;
134: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
135:
136:
137: hr_utility.set_location(gv_package || '.get_payroll_action_info', 60);
138: p_start_date := ld_start_date;
139: p_end_date := ld_end_date;
140: p_report_qualifier := lv_report_qualifier;
141: p_report_type := lv_report_type;

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

141: p_report_type := lv_report_type;
142: p_report_category := lv_report_category;
143: p_business_group_id := ln_business_group_id;
144:
145: hr_utility.set_location(gv_package || '.get_payroll_action_info', 100);
146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: p_start_date := NULL;

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

176: ln_payroll_id NUMBER;
177: ln_consolidation_set_id NUMBER;
178:
179: BEGIN
180: hr_utility.set_location(gv_package || '.range_code', 10);
181: get_payroll_action_info (
182: p_payroll_action_id
183: ,ld_start_date
184: ,ld_end_date

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

185: ,lv_report_qualifier
186: ,lv_report_type
187: ,lv_report_category
188: ,ln_business_group_id);
189: hr_utility.set_location(gv_package || '.range_code', 20);
190:
191: lv_sql_string :=
192: 'select distinct paa.assignment_id
193: from pay_assignment_actions paa -- SQWL assignment action

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

203: order by paa.assignment_id
204: ';
205:
206: p_sql_string := lv_sql_string;
207: hr_utility.set_location(gv_package || '.range_code', 50);
208:
209: END range_cursor;
210:
211: /********************************************************

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

258:
259: ln_locking_action_id NUMBER;
260:
261: BEGIN
262: hr_utility.set_location(gv_package || '.action_creation', 10);
263: get_payroll_action_info (
264: p_payroll_action_id
265: ,ld_start_date
266: ,ld_end_date

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

268: ,lv_report_type
269: ,lv_report_category
270: ,ln_business_group_id);
271:
272: hr_utility.set_location(gv_package || '.action_creation', 20);
273: open c_get_mwr_asg( ln_business_group_id
274: ,ld_start_date
275: ,ld_end_date
276: ,p_start_assignment

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

275: ,ld_end_date
276: ,p_start_assignment
277: ,p_end_assignment);
278: loop
279: hr_utility.set_location(gv_package || '.action_creation', 30);
280: fetch c_get_mwr_asg into ln_assignment_id, ld_effective_date,
281: ln_emp_tax_unit_id, ln_assignment_action_id;
282: if c_get_mwr_asg%notfound then
283: hr_utility.set_location(gv_package || '.action_creation', 40);

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

279: hr_utility.set_location(gv_package || '.action_creation', 30);
280: fetch c_get_mwr_asg into ln_assignment_id, ld_effective_date,
281: ln_emp_tax_unit_id, ln_assignment_action_id;
282: if c_get_mwr_asg%notfound then
283: hr_utility.set_location(gv_package || '.action_creation', 40);
284: exit;
285: end if;
286:
287: hr_utility.set_location(gv_package || '.action_creation', 50);

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

283: hr_utility.set_location(gv_package || '.action_creation', 40);
284: exit;
285: end if;
286:
287: hr_utility.set_location(gv_package || '.action_creation', 50);
288: select pay_assignment_actions_s.nextval
289: into ln_locking_action_id
290: from dual;
291:

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

293:
294: -- insert into pay_assignment_actions.
295: hr_nonrun_asact.insact(ln_locking_action_id, ln_assignment_id,
296: p_payroll_action_id, p_chunk, ln_emp_tax_unit_id);
297: hr_utility.set_location(gv_package || '.action_creation', 60);
298:
299: -- insert an interlock to this action
300: hr_nonrun_asact.insint(ln_locking_action_id, ln_assignment_action_id);
301:

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

302: update pay_assignment_actions paa
303: set paa.serial_number = ln_assignment_action_id
304: where paa.assignment_action_id = ln_locking_action_id;
305:
306: hr_utility.set_location(gv_package || '.action_creation', 60);
307: end loop;
308: close c_get_mwr_asg;
309:
310: hr_utility.set_location(gv_package || '.action_creation', 60);

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

306: hr_utility.set_location(gv_package || '.action_creation', 60);
307: end loop;
308: close c_get_mwr_asg;
309:
310: hr_utility.set_location(gv_package || '.action_creation', 60);
311: END action_creation;
312:
313:
314:

Line 590: hr_utility.trace('Inside check_work_loc_change');

586: l_qtr_sui_state_count NUMBER := 0;
587:
588: BEGIN
589:
590: hr_utility.trace('Inside check_work_loc_change');
591:
592: OPEN emp_qtr_sui_state_count;
593:
594: FETCH emp_qtr_sui_state_count INTO l_qtr_sui_state_count;

Line 598: hr_utility.trace('Returning '||l_qtr_sui_state_count||' from check_sui_state_change');

594: FETCH emp_qtr_sui_state_count INTO l_qtr_sui_state_count;
595:
596: CLOSE emp_qtr_sui_state_count;
597:
598: hr_utility.trace('Returning '||l_qtr_sui_state_count||' from check_sui_state_change');
599:
600: return nvl(l_qtr_sui_state_count,0);
601:
602: EXCEPTION

Line 604: hr_utility.trace('Exception raised in check_sui_state_change');

600: return nvl(l_qtr_sui_state_count,0);
601:
602: EXCEPTION
603: WHEN OTHERS THEN
604: hr_utility.trace('Exception raised in check_sui_state_change');
605: hr_utility.raise_error;
606: END check_sui_state_change;
607: /* 11936382 Added this following procedure to derive tbe reporting
608: location under MWSR*/

Line 605: hr_utility.raise_error;

601:
602: EXCEPTION
603: WHEN OTHERS THEN
604: hr_utility.trace('Exception raised in check_sui_state_change');
605: hr_utility.raise_error;
606: END check_sui_state_change;
607: /* 11936382 Added this following procedure to derive tbe reporting
608: location under MWSR*/
609: FUNCTION get_location_id( p_assignment_id in number

Line 678: hr_utility.trace('Returing location_id as '||l_location_id||' from pay_us_mwr_reporting_pkg.get_location_id');

674:
675: END IF;
676:
677: CLOSE asg_with_action_loc_id;
678: hr_utility.trace('Returing location_id as '||l_location_id||' from pay_us_mwr_reporting_pkg.get_location_id');
679: RETURN l_location_id;
680:
681: EXCEPTION
682: WHEN OTHERS THEN

Line 683: hr_utility.trace('Exception raised in get_location_id');

679: RETURN l_location_id;
680:
681: EXCEPTION
682: WHEN OTHERS THEN
683: hr_utility.trace('Exception raised in get_location_id');
684: hr_utility.raise_error;
685: END get_location_id;
686: /* 11936382 end*/
687:

Line 684: hr_utility.raise_error;

680:
681: EXCEPTION
682: WHEN OTHERS THEN
683: hr_utility.trace('Exception raised in get_location_id');
684: hr_utility.raise_error;
685: END get_location_id;
686: /* 11936382 end*/
687:
688:

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

687:
688:
689: BEGIN
690:
691: hr_utility.set_location(gv_package || '.' || l_procedure , 10);
692:
693: --get the session id
694: SELECT userenv('sessionid')
695: INTO v_session_id

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

700: INTO l_ppa_legislative_parameters
701: FROM pay_payroll_actions ppa
702: where ppa.payroll_action_id = p_payroll_action_id;
703:
704: hr_utility.set_location(gv_package || '.' || l_procedure , 20);
705:
706: l_est_hierarchy_id :=
707: to_number(pay_mag_utils.get_parameter('TRANSFER_HIERARCHY_ID'
708: ,'TRANSFER_HIERARCHY_VERSION'

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

711: pay_mag_utils.get_parameter('TRANSFER_HIERARCHY_VERSION'
712: ,''
713: ,l_ppa_legislative_parameters);
714:
715: hr_utility.set_location(gv_package || '.' || l_procedure , 30);
716:
717: -- cusror loop.
718: OPEN get_pact_asg;
719:

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

719:
720: FETCH get_pact_asg into l_ass_id, l_tax_unit_id, l_sqwl_assact, l_business_group_id, l_effective_date;
721: WHILE get_pact_asg%FOUND LOOP
722:
723: hr_utility.set_location(gv_package || '.' || l_procedure , 40);
724:
725: FOR i IN 1 .. 4 LOOP
726: OPEN c_asg_loc_mon(l_sqwl_assact,
727: i);

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

735: CLOSE C_ASG_LOC_MON;
736: l_sit_exists := 'Y';
737: l_wage_jurisdiction_code := l_jurisdiction;
738:
739: hr_utility.set_location(gv_package || '.' || l_procedure , 50);
740:
741: -- get the sui ID for the SQWL assignment action
742: OPEN c_get_sui_code( l_tax_unit_id, l_jurisdiction );
743:

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

781: close c_get_sqwl_month_count;
782:
783: -- get the value for the A_SIT_GROSS_PER_JD_GRE_MON_* archive item.
784:
785: hr_utility.set_location(gv_package || '.' || l_procedure , 60);
786: OPEN c_get_sui_subject ( l_sqwl_assact
787: ,l_user_entity_id
788: ,l_tax_unit_id
789: ,l_jurisdiction);

Line 886: hr_utility.trace('l_work_at_home exception ');

882: WHERE paf.assignment_id = l_ass_id
883: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
884: EXCEPTION
885: WHEN OTHERS THEN
886: hr_utility.trace('l_work_at_home exception ');
887: NULL;
888: END;
889:
890: hr_utility.set_location('99999-1 assignment_id:assignment_action_id: '||l_ass_id||':'||l_sqwl_assact,99999);

Line 890: hr_utility.set_location('99999-1 assignment_id:assignment_action_id: '||l_ass_id||':'||l_sqwl_assact,99999);

886: hr_utility.trace('l_work_at_home exception ');
887: NULL;
888: END;
889:
890: hr_utility.set_location('99999-1 assignment_id:assignment_action_id: '||l_ass_id||':'||l_sqwl_assact,99999);
891: l_location_id := -99999;
892:
893: l_location_invalid := 0;
894:

Line 1021: hr_utility.trace('l_ma_resides find user entity');

1017: l_ma_resides_true := '0';
1018: END;
1019: IF l_ma_resides_true = '1' THEN
1020: -- get the user_entity_id for the 'A_SIT_GROSS_PER_JD_GRE_MON_*' DBI
1021: hr_utility.trace('l_ma_resides find user entity');
1022: SELECT ue.user_entity_id
1023: INTO l_user_entity_id
1024: FROM ff_user_entities ue
1025: WHERE ue.user_entity_name = 'A_SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD'

Line 1039: hr_utility.set_location('99999-11936382 MA employee Exiting Loop',99999);

1035: l_archive_value := 0;
1036: END IF;
1037: CLOSE c_get_sui_subject;
1038: IF l_archive_value = 0 THEN
1039: hr_utility.set_location('99999-11936382 MA employee Exiting Loop',99999);
1040: EXIT;
1041: END IF;
1042: END IF;
1043: END IF;

Line 1047: hr_utility.set_location('99999-2 assignment_id:assignment_action_id: '||l_ass_id||':'||l_sqwl_assact,99999);

1043: END IF;
1044: --# 11936382 end
1045:
1046: IF l_location_invalid = 1 THEN
1047: hr_utility.set_location('99999-2 assignment_id:assignment_action_id: '||l_ass_id||':'||l_sqwl_assact,99999);
1048: l_location_id := -99999;
1049: l_location_invalid := 0;
1050: END IF;
1051: END IF;

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

1080: END IF;
1081:
1082:
1083: -- derive the establishment
1084: hr_utility.set_location(gv_package || '.' || l_procedure , 70);
1085:
1086: IF l_location_id <> -99999 THEN
1087: OPEN c_derive_wksite_estab( l_hierarchy_ver_id,
1088: l_location_id);

Line 1093: hr_utility.set_location('99999-3 assignment_id:assignment_action_id: '||l_ass_id||':'||l_sqwl_assact,99999);

1089:
1090: FETCH c_derive_wksite_estab into l_worksite;
1091:
1092: IF c_derive_wksite_estab%NOTFOUND THEN
1093: hr_utility.set_location('99999-3 assignment_id:assignment_action_id: '||l_ass_id||':'||l_sqwl_assact,99999);
1094: l_worksite := -99999;
1095: END IF;
1096:
1097: CLOSE c_derive_wksite_estab;

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

1099: l_worksite := -99999;
1100: END IF;
1101:
1102: -- Write the us_rpt_totals record
1103: hr_utility.set_location(gv_package || '.' || l_procedure , 80);
1104:
1105: IF i = 1 THEN -- UPDATING / INSERTING into column value1
1106: hr_utility.set_location(gv_package || '.' || l_procedure , 90);
1107: UPDATE pay_us_rpt_totals prt

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

1102: -- Write the us_rpt_totals record
1103: hr_utility.set_location(gv_package || '.' || l_procedure , 80);
1104:
1105: IF i = 1 THEN -- UPDATING / INSERTING into column value1
1106: hr_utility.set_location(gv_package || '.' || l_procedure , 90);
1107: UPDATE pay_us_rpt_totals prt
1108: SET prt.value1 = NVL(prt.value1,0) + 1
1109: WHERE prt.session_id = v_session_id
1110: AND prt.organization_id = p_payroll_action_id

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

1114: and prt.attribute2 = l_sui_id
1115: and prt.attribute3 = l_fed_ein;
1116:
1117: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
1118: hr_utility.set_location(gv_package || '.' || l_procedure , 100);
1119:
1120: INSERT into pay_us_rpt_totals
1121: ( session_id
1122: ,organization_id

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

1136: ,l_fed_ein
1137: ,1);
1138: END IF;
1139: ELSIF i = 2 THEN -- UPDATING / INSERTING into Column value2
1140: hr_utility.set_location(gv_package || '.' || l_procedure , 110);
1141: UPDATE pay_us_rpt_totals prt
1142: SET prt.value2 = NVL(prt.value2,0) + 1
1143: WHERE prt.session_id = v_session_id
1144: AND prt.organization_id = p_payroll_action_id

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

1148: and prt.attribute2 = l_sui_id
1149: and prt.attribute3 = l_fed_ein;
1150:
1151: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
1152: hr_utility.set_location(gv_package || '.' || l_procedure , 120);
1153:
1154: INSERT into pay_us_rpt_totals
1155: ( session_id
1156: ,organization_id

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

1170: ,l_fed_ein
1171: ,1);
1172: END IF;
1173: ELSIF i = 3 THEN -- UPDATING / INSERTING into column value3
1174: hr_utility.set_location(gv_package || '.' || l_procedure , 130);
1175: UPDATE pay_us_rpt_totals prt
1176: SET prt.value3 = NVL(prt.value3,0) + 1
1177: WHERE prt.session_id = v_session_id
1178: AND prt.organization_id = p_payroll_action_id

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

1182: and prt.attribute2 = l_sui_id
1183: and prt.attribute3 = l_fed_ein;
1184:
1185: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
1186: hr_utility.set_location(gv_package || '.' || l_procedure , 140);
1187:
1188: INSERT into pay_us_rpt_totals
1189: ( session_id
1190: ,organization_id

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

1204: ,l_fed_ein
1205: ,1);
1206: END IF;
1207: ELSE -- UPDATING / INSERTING into column value4
1208: hr_utility.set_location(gv_package || '.' || l_procedure , 150);
1209:
1210: UPDATE pay_us_rpt_totals prt
1211: SET prt.value4 = NVL(prt.value4,0) + l_archive_value
1212: WHERE prt.session_id = v_session_id

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

1217: and prt.attribute2 = l_sui_id
1218: and prt.attribute3 = l_fed_ein;
1219:
1220: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
1221: hr_utility.set_location(gv_package || '.' || l_procedure , 160);
1222:
1223: INSERT into pay_us_rpt_totals
1224: ( session_id
1225: ,organization_id

Line 1248: hr_utility.set_location(gv_package || '.' || l_procedure , 180);

1244: END IF;
1245: END IF;
1246:
1247: END LOOP;
1248: hr_utility.set_location(gv_package || '.' || l_procedure , 180);
1249: FETCH get_pact_asg into l_ass_id, l_tax_unit_id, l_sqwl_assact, l_business_group_id, l_effective_date;
1250:
1251: END LOOP;
1252: