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

Line 155: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

151: PROCEDURE local_error(p_procedure varchar2,
152: p_step number) IS
153: BEGIN
154: --
155: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
156: hr_utility.set_message_token('PROCEDURE',
157: 'pay_us_tax_bals_pkg.'||p_procedure);
158: hr_utility.set_message_token('STEP',p_step);
159: hr_utility.raise_error;

Line 156: hr_utility.set_message_token('PROCEDURE',

152: p_step number) IS
153: BEGIN
154: --
155: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
156: hr_utility.set_message_token('PROCEDURE',
157: 'pay_us_tax_bals_pkg.'||p_procedure);
158: hr_utility.set_message_token('STEP',p_step);
159: hr_utility.raise_error;
160: --

Line 158: hr_utility.set_message_token('STEP',p_step);

154: --
155: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
156: hr_utility.set_message_token('PROCEDURE',
157: 'pay_us_tax_bals_pkg.'||p_procedure);
158: hr_utility.set_message_token('STEP',p_step);
159: hr_utility.raise_error;
160: --
161: END local_error;
162: --

Line 159: hr_utility.raise_error;

155: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
156: hr_utility.set_message_token('PROCEDURE',
157: 'pay_us_tax_bals_pkg.'||p_procedure);
158: hr_utility.set_message_token('STEP',p_step);
159: hr_utility.raise_error;
160: --
161: END local_error;
162: --
163: --

Line 181: hr_utility.set_location('pay_us_tax_bals_pkg.get_asg_for_grp_lvl', 10);

177: l_found boolean;
178: begin
179: -- Look to see if the group level balance is in our cache.
180: --
181: hr_utility.set_location('pay_us_tax_bals_pkg.get_asg_for_grp_lvl', 10);
182: --
183: l_count := 0;
184: l_found := FALSE;
185: while ((l_count < g_nxt_free_dim) AND (l_found = FALSE)) loop

Line 187: hr_utility.set_location('pay_us_tax_bals_pkg.get_asg_for_grp_lvl', 20);

183: l_count := 0;
184: l_found := FALSE;
185: while ((l_count < g_nxt_free_dim) AND (l_found = FALSE)) loop
186: if (p_grp_dvl_dimension = g_dim_tbl_grp(l_count)) then
187: hr_utility.set_location('pay_us_tax_bals_pkg.get_asg_for_grp_lvl', 20);
188: --
189: p_asg_lvl_dimension := g_dim_tbl_asg(l_count);
190: p_asg_cursor := g_dim_tbl_crs(l_count);
191: p_asg_vdate_cursor := g_dim_tbl_vtd(l_count);

Line 206: hr_utility.set_location('pay_us_tax_bals_pkg.get_asg_for_grp_lvl', 30);

202: end if;
203: l_count := l_count + 1;
204: end loop;
205: --
206: hr_utility.set_location('pay_us_tax_bals_pkg.get_asg_for_grp_lvl', 30);
207: p_found := l_found;
208: --
209: end;
210: --

Line 220: hr_utility.set_location('pay_us_tax_bals_pkg.get_defined_balance', 10);

216: p_dimension_suffix varchar2) return number is
217: l_defined_balance_id number;
218: --
219: begin
220: hr_utility.set_location('pay_us_tax_bals_pkg.get_defined_balance', 10);
221: --
222:
223: SELECT creator_id
224: INTO l_defined_balance_id

Line 230: hr_utility.set_location('pay_us_tax_bals_pkg.get_defined_balance', 20);

226: WHERE user_entity_name like
227: translate(p_balance_name||'_'||p_dimension_suffix,' ','_')
228: AND legislation_code = 'US';
229: --
230: hr_utility.set_location('pay_us_tax_bals_pkg.get_defined_balance', 20);
231: return l_defined_balance_id;
232: end;
233: --
234: ------------------------------------------------------------------------------

Line 252: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date', 10);

248: begin
249: --
250: -- Is the assignment on a payroll.
251: --
252: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date', 10);
253: select ''
254: into l_dummy
255: from per_assignments_f paf
256: where paf.assignment_id = p_assignment_id

Line 262: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date', 20);

258: and paf.effective_end_date
259: and paf.payroll_id is not null;
260:
261: --
262: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date', 20);
263: return p_virtual_date;
264: exception
265: when no_data_found then
266: --

Line 273: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date',

269: declare
270: sql_cursor number;
271: l_rows number;
272: begin
273: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date',
274: 30);
275: sql_cursor := dbms_sql.open_cursor;
276: dbms_sql.parse(sql_cursor, p_asg_vdate_cursor, dbms_sql.v7);
277: dbms_sql.bind_variable (sql_cursor, 'ASSIGNMENT_ID',

Line 287: hr_utility.set_location(

283: dbms_sql.define_column (sql_cursor, 1, l_virtual_date);
284: l_rows := dbms_sql.execute(sql_cursor);
285: l_rows := dbms_sql.fetch_rows (sql_cursor);
286: if l_rows > 0 then
287: hr_utility.set_location(
288: 'pay_us_tax_bals_pkg.get_virtual_date', 40);
289: dbms_sql.column_value (sql_cursor, 1, l_virtual_date);
290: --
291: select max(ppf.effective_end_date)

Line 305: hr_utility.set_location(

301: -- Now work out which date is needed
302: --
303: if l_virtual_date is null then
304: if l_virtual_date2 is null then
305: hr_utility.set_location(
306: 'pay_us_tax_bals_pkg.get_virtual_date', 60);
307: local_error('get_virtual_date', 2);
308: else
309: hr_utility.set_location(

Line 309: hr_utility.set_location(

305: hr_utility.set_location(
306: 'pay_us_tax_bals_pkg.get_virtual_date', 60);
307: local_error('get_virtual_date', 2);
308: else
309: hr_utility.set_location(
310: 'pay_us_tax_bals_pkg.get_virtual_date', 70);
311: l_res_date := l_virtual_date2;
312: end if;
313: else

Line 315: hr_utility.set_location(

311: l_res_date := l_virtual_date2;
312: end if;
313: else
314: if l_virtual_date2 is null then
315: hr_utility.set_location(
316: 'pay_us_tax_bals_pkg.get_virtual_date', 80);
317: l_res_date := l_virtual_date;
318: else
319: hr_utility.set_location(

Line 319: hr_utility.set_location(

315: hr_utility.set_location(
316: 'pay_us_tax_bals_pkg.get_virtual_date', 80);
317: l_res_date := l_virtual_date;
318: else
319: hr_utility.set_location(
320: 'pay_us_tax_bals_pkg.get_virtual_date', 90);
321: l_res_date := least(l_virtual_date, l_virtual_date2);
322: end if;
323: end if;

Line 326: hr_utility.set_location(

322: end if;
323: end if;
324: --
325: else
326: hr_utility.set_location(
327: 'pay_us_tax_bals_pkg.get_virtual_date', 50);
328: local_error('get_virtual_date', 1);
329: end if;
330: --

Line 393: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 10);

389: l_run_route_bool := true;
390: END IF;
391:
392: l_balance_value := 0;
393: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 10);
394: --
395: -- Get the assignment level version.
396: --
397: get_asg_for_grp_lvl(p_database_suffix,

Line 409: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 20);

405: if l_grp_lat_exist then
406: --
407: -- Are there latest balances available.
408: --
409: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 20);
410: l_defined_balance_id := get_defined_balance(p_balance_name,
411: l_asg_data_suffix);
412: --
413: begin

Line 442: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 30);

438: --
439: -- OK, we can sum the values of the assignment balances to get the
440: -- group balance.
441: --
442: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 30);
443: begin
444: --
445: sql_cursor := dbms_sql.open_cursor;
446: dbms_sql.parse(sql_cursor, l_asg_data_cursor, dbms_sql.v7);

Line 477: hr_utility.set_location(

473: while (l_rows <> 0) loop
474: l_rows := dbms_sql.fetch_rows (sql_cursor);
475: cnt := cnt + 1;
476: if l_rows > 0 then
477: hr_utility.set_location(
478: 'pay_us_tax_bals_pkg.get_grp_asg_value', 40);
479: dbms_sql.column_value (sql_cursor, 1, l_asg_id);
480: --
481: l_virtual_date := get_virtual_date(l_asg_id, p_virtual_date,

Line 502: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 50);

498: else
499: --
500: -- No latets balances available. Run the route.
501: --
502: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 50);
503: l_defined_balance_id := get_defined_balance(p_balance_name,
504: p_database_suffix);
505: l_balance_value := pay_balance_pkg.get_value_lock
506: (l_defined_balance_id,

Line 518: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 60);

514: --
515: -- Can not sum the assignment level balances, thus run group
516: -- level route.
517: --
518: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 60);
519: l_defined_balance_id := get_defined_balance(p_balance_name,
520: p_database_suffix);
521: l_balance_value := pay_balance_pkg.get_value_lock
522: (l_defined_balance_id,

Line 530: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 70);

526: p_asg_lock
527: );
528: end if;
529: --
530: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 70);
531: return l_balance_value;
532: --
533: end;
534: --

Line 574: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_act_value', 10);

570: l_run_route_bool := true;
571: END IF;
572:
573: l_balance_value := 0;
574: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_act_value', 10);
575: --
576: l_defined_balance_id := get_defined_balance(p_balance_name,
577: p_database_suffix);
578: l_balance_value := pay_balance_pkg.get_value (l_defined_balance_id,

Line 584: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_act_value', 20);

580: l_run_route_bool,
581: FALSE
582: );
583: --
584: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_act_value', 20);
585: return l_balance_value;
586: --
587: end;
588: --

Line 602: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_value', 10);

598: p_assignment_action_id number default null,
599: p_asg_lock varchar2)
600: return number is
601: begin
602: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_value', 10);
603: if p_assignment_action_id is null then
604: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_value', 20);
605: return get_grp_asg_value(p_assignment_id,
606: p_virtual_date,

Line 604: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_value', 20);

600: return number is
601: begin
602: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_value', 10);
603: if p_assignment_action_id is null then
604: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_value', 20);
605: return get_grp_asg_value(p_assignment_id,
606: p_virtual_date,
607: p_balance_name,
608: p_database_suffix,

Line 613: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_value', 30);

609: p_gre_id,
610: p_jurisdiction_code,
611: p_asg_lock);
612: else
613: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_value', 30);
614: return get_grp_act_value(p_assignment_action_id,
615: p_virtual_date,
616: p_balance_name,
617: p_database_suffix,

Line 648: hr_utility.set_location('pay_us_tax_bals_pkg.balance_name'||p_balance_name, 9);

644: --
645: BEGIN
646: --
647:
648: hr_utility.set_location('pay_us_tax_bals_pkg.balance_name'||p_balance_name, 9);
649: hr_utility.trace('p_dimension_suffix = '||p_dimension_suffix);
650: hr_utility.trace('p_balance_name = '||p_balance_name);
651: hr_utility.trace('p_asg_type = '||p_asg_type);
652: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 10);

Line 649: hr_utility.trace('p_dimension_suffix = '||p_dimension_suffix);

645: BEGIN
646: --
647:
648: hr_utility.set_location('pay_us_tax_bals_pkg.balance_name'||p_balance_name, 9);
649: hr_utility.trace('p_dimension_suffix = '||p_dimension_suffix);
650: hr_utility.trace('p_balance_name = '||p_balance_name);
651: hr_utility.trace('p_asg_type = '||p_asg_type);
652: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 10);
653:

Line 650: hr_utility.trace('p_balance_name = '||p_balance_name);

646: --
647:
648: hr_utility.set_location('pay_us_tax_bals_pkg.balance_name'||p_balance_name, 9);
649: hr_utility.trace('p_dimension_suffix = '||p_dimension_suffix);
650: hr_utility.trace('p_balance_name = '||p_balance_name);
651: hr_utility.trace('p_asg_type = '||p_asg_type);
652: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 10);
653:
654: -- check for the 'RUN_ROUTE' parameter_name in the pay_action_parameters

Line 651: hr_utility.trace('p_asg_type = '||p_asg_type);

647:
648: hr_utility.set_location('pay_us_tax_bals_pkg.balance_name'||p_balance_name, 9);
649: hr_utility.trace('p_dimension_suffix = '||p_dimension_suffix);
650: hr_utility.trace('p_balance_name = '||p_balance_name);
651: hr_utility.trace('p_asg_type = '||p_asg_type);
652: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 10);
653:
654: -- check for the 'RUN_ROUTE' parameter_name in the pay_action_parameters
655: -- table to determine if we want to call the run_result route instead of

Line 652: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 10);

648: hr_utility.set_location('pay_us_tax_bals_pkg.balance_name'||p_balance_name, 9);
649: hr_utility.trace('p_dimension_suffix = '||p_dimension_suffix);
650: hr_utility.trace('p_balance_name = '||p_balance_name);
651: hr_utility.trace('p_asg_type = '||p_asg_type);
652: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 10);
653:
654: -- check for the 'RUN_ROUTE' parameter_name in the pay_action_parameters
655: -- table to determine if we want to call the run_result route instead of
656: -- the run_balance route.

Line 682: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',

678: /* commenting of the following code. From now on we will be using
679: the Balance Reporting Arch */
680: /*
681: if p_asg_type = 'GRE' then
682: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',
683: 20);
684: return get_grp_value(p_assignment_id,
685: p_virtual_date,
686: p_balance_name,

Line 698: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 30);

694: */
695: l_defined_balance_id := get_defined_balance(p_balance_name,
696: p_dimension_suffix);
697: IF p_dimension_suffix not like '%PAY%' THEN
698: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 30);
699: return pay_balance_pkg.get_value (l_defined_balance_id,
700: p_assignment_action_id,
701: l_run_route_bool,
702: FALSE

Line 705: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 40);

701: l_run_route_bool,
702: FALSE
703: );
704: ELSE /* If payments dimension then must execute DB item 395029 */
705: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 40);
706: return pay_balance_pkg.get_value (l_defined_balance_id,
707: p_assignment_action_id,
708: true );
709: -- END IF;

Line 718: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',

714: /* commenting of the following code. From now on we will be using
715: the Balance Reporting Arch */
716: /*
717: if p_asg_type = 'GRE' then
718: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',
719: 50);
720: return get_grp_value(p_assignment_id,
721: p_virtual_date,
722: p_balance_name,

Line 733: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',

729: else
730: */
731: l_defined_balance_id := get_defined_balance(p_balance_name,
732: p_dimension_suffix);
733: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',
734: 60);
735: return pay_balance_pkg.get_value_lock
736: (l_defined_balance_id,
737: p_assignment_id,

Line 995: hr_utility.trace('Year from Assignment Action ID: '||l_year);

991: OPEN get_year(p_assignment_action_id);
992: FETCH get_year INTO l_year;
993: CLOSE get_year;
994:
995: hr_utility.trace('Year from Assignment Action ID: '||l_year);
996:
997: ELSE
998:
999: l_year := TO_CHAR(p_virtual_date,'YYYY');

Line 1001: hr_utility.trace('Year from Virtual Date: '||l_year);

997: ELSE
998:
999: l_year := TO_CHAR(p_virtual_date,'YYYY');
1000:
1001: hr_utility.trace('Year from Virtual Date: '||l_year);
1002:
1003: END IF;
1004:
1005: l_direct_bal_year := NVL(fnd_profile.value('PAY_US_DIRECT_BALANCE_START_YEAR'),'0001');

Line 1013: hr_utility.trace('US Federal Balances will be fetched from Direct Values');

1009: l_direct_fed_bal_call := 'N';
1010:
1011: ELSE
1012:
1013: hr_utility.trace('US Federal Balances will be fetched from Direct Values');
1014:
1015: END IF;
1016:
1017: END IF;

Line 1032: hr_utility.trace('Error: Invalid tax balance category');

1028: WHERE lookup_type = 'US_TAX_BALANCE_CATEGORY'
1029: AND lookup_code = p_tax_balance_category;
1030: --
1031: IF l_valid = 0 THEN
1032: hr_utility.trace('Error: Invalid tax balance category');
1033: local_error('us_tax_balance',1);
1034: END IF;
1035: --
1036: SELECT count(0)

Line 1044: hr_utility.trace('Error: Invalid tax type');

1040: AND lookup_code = p_tax_type;
1041: --
1042: IF l_valid = 0 THEN
1043: IF instr(l_tax_type,'PSD') = 0 THEN -- #11926304 Added If to support PSD tax
1044: hr_utility.trace('Error: Invalid tax type');
1045: local_error('us_tax_balance',2);
1046: END IF; -- #11926304
1047: END IF;
1048: --

Line 1057: hr_utility.trace('Error: Invalid asg_type parameter');

1053: FROM dual
1054: WHERE p_asg_type in ('ASG','PER','GRE');
1055: --
1056: IF l_valid = 0 THEN
1057: hr_utility.trace('Error: Invalid asg_type parameter');
1058: local_error('us_tax_balance',3);
1059: END IF;
1060: --
1061: SELECT count(0)

Line 1067: hr_utility.trace('Error: Invalid time_type parameter');

1063: FROM dual
1064: WHERE p_time_type in ('RUN','PTD','MONTH','QTD','YTD', 'PAYMENTS', 'PYDATE');
1065: --
1066: IF l_valid = 0 THEN
1067: hr_utility.trace('Error: Invalid time_type parameter');
1068: local_error('us_tax_balance',4);
1069: END IF;
1070: --
1071: -- Set the contexts used in the bal user exit. Same throughout, so set

Line 1074: hr_utility.set_location('pay_tax_bals_pkg',30);

1070: --
1071: -- Set the contexts used in the bal user exit. Same throughout, so set
1072: -- them up front
1073: --
1074: hr_utility.set_location('pay_tax_bals_pkg',30);
1075: --
1076: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);
1077: IF p_jd_context IS NOT NULL THEN
1078: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN

Line 1086: hr_utility.set_location('pay_tax_bals_pkg',40);

1082: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);
1083: END IF;
1084: END IF;
1085: --
1086: hr_utility.set_location('pay_tax_bals_pkg',40);
1087: --
1088: l_assignment_id := p_assignment_id;
1089:
1090: l_group_rb_report := NVL(pay_us_balance_view_pkg.get_session_var('GROUP_RB_REPORT'),'NA');

Line 1133: hr_utility.set_location('pay_tax_bals_pkg',50);

1129: -- Check if assignment exists at l_virtual_date, if using date mode
1130: -- Changed date format to DD-MON-YYYY, bug 612696
1131: l_virtual_date :=fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_virtual_date));
1132: --
1133: hr_utility.set_location('pay_tax_bals_pkg',50);
1134: --
1135: IF (l_assignment_id is not null and l_virtual_date is not null) THEN
1136: --
1137: select count(0)

Line 1145: hr_utility.set_location('pay_tax_bals_pkg',60);

1141: and l_virtual_date between effective_start_date and effective_end_date;
1142: --
1143: -- if assignment doesn't exist ...
1144: --
1145: hr_utility.set_location('pay_tax_bals_pkg',60);
1146: --
1147: IF l_asg_exists = 0 THEN
1148: --
1149: -- get the termination date ...

Line 1158: hr_utility.set_location('pay_tax_bals_pkg',70);

1154: where assignment_id = l_assignment_id;
1155: --
1156: -- get the date of the start of the time period in question
1157: --
1158: hr_utility.set_location('pay_tax_bals_pkg',70);
1159: --
1160: IF p_time_type = 'QTD' THEN
1161: l_bal_start_date := trunc(l_virtual_date,'Q');
1162: ELSIF p_time_type = 'MONTH' THEN

Line 1180: hr_utility.trace('Assignment was terminated on : ' || l_max_date);

1176: --
1177: -- set the virtual date to termination date, or return 0 if terminated
1178: -- before the time period.
1179: --
1180: hr_utility.trace('Assignment was terminated on : ' || l_max_date);
1181: hr_utility.trace('Time period in question begins on : ' ||
1182: l_bal_start_date);
1183: --
1184: IF l_max_date < l_bal_start_date THEN

Line 1181: hr_utility.trace('Time period in question begins on : ' ||

1177: -- set the virtual date to termination date, or return 0 if terminated
1178: -- before the time period.
1179: --
1180: hr_utility.trace('Assignment was terminated on : ' || l_max_date);
1181: hr_utility.trace('Time period in question begins on : ' ||
1182: l_bal_start_date);
1183: --
1184: IF l_max_date < l_bal_start_date THEN
1185: return 0;

Line 1190: hr_utility.trace('Using new virtual date : ' || l_virtual_date);

1186: ELSE
1187: l_virtual_date := l_max_date;
1188: END IF;
1189: --
1190: hr_utility.trace('Using new virtual date : ' || l_virtual_date);
1191: --
1192: END IF;
1193: END IF;
1194: --

Line 1197: hr_utility.set_location('pay_tax_bals_pkg',80);

1193: END IF;
1194: --
1195: -- Convert "WITHHELD" to proper balance categories;
1196: --
1197: hr_utility.set_location('pay_tax_bals_pkg',80);
1198: --
1199: IF l_tax_balance_category = 'WITHHELD' THEN
1200: IF p_ee_or_er = 'ER' or l_tax_type = 'FUTA' THEN
1201: l_tax_balance_category := 'LIABILITY';

Line 1213: hr_utility.set_location('pay_tax_bals_pkg',90);

1209: END IF;
1210: --
1211: -- Check if illegal tax combo (FIT and TAXABLE, FUTA and SUBJ_NWHABLE, etc.)
1212: --
1213: hr_utility.set_location('pay_tax_bals_pkg',90);
1214: --
1215: IF (l_tax_type = 'FIT' or l_tax_type = 'SIT' or l_tax_type = 'COUNTY' or
1216: l_tax_type = 'CITY' or l_tax_type = 'EIC' or l_tax_type = 'HT' or
1217: l_tax_type = 'SCHOOL' or l_tax_type = 'STEIC' ) THEN -- income tax

Line 1220: hr_utility.trace('Error: Illegal tax category for tax type');

1216: l_tax_type = 'CITY' or l_tax_type = 'EIC' or l_tax_type = 'HT' or
1217: l_tax_type = 'SCHOOL' or l_tax_type = 'STEIC' ) THEN -- income tax
1218: IF (l_tax_balance_category = 'TAXABLE' or
1219: l_tax_balance_category = 'EXCESS') THEN
1220: hr_utility.trace('Error: Illegal tax category for tax type');
1221: local_error('us_tax_balance',5);
1222: END IF;
1223: --
1224: -- return 0 for currently unsupported EIC balances.

Line 1244: hr_utility.set_location('pay_tax_bals_pkg',100);

1240: return 0;
1241: END IF;
1242: END IF;
1243: --
1244: hr_utility.set_location('pay_tax_bals_pkg',100);
1245: --
1246: l_ee_or_er := ltrim(rtrim(p_ee_or_er));
1247: --
1248: --------------- Some Error Checking -------------

Line 1256: hr_utility.trace('Error: ER not allowed for tax type');

1252: l_tax_type = 'COUNTY' or l_tax_type = 'EIC' or l_tax_type = 'SCHOOL'
1253: or l_tax_type = 'HT' or l_tax_type = 'WC' or l_tax_type = 'WC2' or
1254: l_tax_type = 'STEIC' or instr(l_tax_type,'PSD') <> 0 ) THEN --#11926304
1255: if l_ee_or_er = 'ER' THEN
1256: hr_utility.trace('Error: ER not allowed for tax type');
1257: local_error('us_tax_balance',6);
1258: else
1259: l_ee_or_er := NULL;
1260: end if;

Line 1263: hr_utility.trace('Error: EE not allowed for tax type');

1259: l_ee_or_er := NULL;
1260: end if;
1261: elsif (l_tax_type = 'FUTA') THEN
1262: if l_ee_or_er = 'EE' THEN
1263: hr_utility.trace('Error: EE not allowed for tax type');
1264: local_error('us_tax_balance',7);
1265: else
1266: l_ee_or_er := NULL;
1267: end if;

Line 1271: hr_utility.trace('Error: EE or ER required for tax type');

1267: end if;
1268: elsif (l_tax_type = 'SS' or l_tax_type = 'MEDICARE' or l_tax_type = 'SDI' or
1269: l_tax_type = 'SUI' ) THEN
1270: if (l_ee_or_er <> 'EE' and l_ee_or_er <> 'ER') THEN
1271: hr_utility.trace('Error: EE or ER required for tax type');
1272: local_error('us_tax_balance',8);
1273: end if;
1274: elsif (l_tax_type = 'SUI1') or (l_tax_type = 'SDI1')THEN
1275: if (l_ee_or_er <> 'EE' ) THEN

Line 1276: hr_utility.trace('Error: EE required for tax type');

1272: local_error('us_tax_balance',8);
1273: end if;
1274: elsif (l_tax_type = 'SUI1') or (l_tax_type = 'SDI1')THEN
1275: if (l_ee_or_er <> 'EE' ) THEN
1276: hr_utility.trace('Error: EE required for tax type');
1277: local_error('us_tax_balance',9);
1278: end if;
1279: end if;
1280:

Line 1298: hr_utility.set_location('pay_tax_bals_pkg',110);

1294: return 0;
1295: END IF;
1296:
1297: --
1298: hr_utility.set_location('pay_tax_bals_pkg',110);
1299: --
1300: -- Force space at end of this parameter if necessary
1301: --
1302: hr_utility.set_location('pay_tax_bals_pkg',120);

Line 1302: hr_utility.set_location('pay_tax_bals_pkg',120);

1298: hr_utility.set_location('pay_tax_bals_pkg',110);
1299: --
1300: -- Force space at end of this parameter if necessary
1301: --
1302: hr_utility.set_location('pay_tax_bals_pkg',120);
1303: --
1304: IF l_ee_or_er IS NOT NULL THEN
1305: l_ee_or_er := rtrim(l_ee_or_er)||' ';
1306: END IF;

Line 1410: hr_utility.trace('Error: Failure to find defined balance');

1406: g_nxt_free_asgid := g_nxt_free_asgid + 1;
1407: --
1408: exception when no_data_found then
1409: begin
1410: hr_utility.trace('Error: Failure to find defined balance');
1411: local_error('us_tax_balance',1);
1412: --
1413: end;
1414: end;

Line 2003: hr_utility.trace('balance name sent = '||l_tax_type||'_'||

1999: END IF;
2000: --
2001: ELSIF l_tax_balance_category = 'TAXABLE' THEN
2002:
2003: hr_utility.trace('balance name sent = '||l_tax_type||'_'||
2004: l_ee_or_er||'TAXABLE');
2005: hr_utility.trace(' l_dimension_string = '||l_dimension_string);
2006:
2007: l_return_value := call_balance_user_exit (l_tax_type||'_'||

Line 2005: hr_utility.trace(' l_dimension_string = '||l_dimension_string);

2001: ELSIF l_tax_balance_category = 'TAXABLE' THEN
2002:
2003: hr_utility.trace('balance name sent = '||l_tax_type||'_'||
2004: l_ee_or_er||'TAXABLE');
2005: hr_utility.trace(' l_dimension_string = '||l_dimension_string);
2006:
2007: l_return_value := call_balance_user_exit (l_tax_type||'_'||
2008: l_ee_or_er||'TAXABLE',
2009: l_dimension_string,

Line 2075: hr_utility.trace ('The category is : '|| l_tax_balance_category);

2071: l_tax_type := 'WORKERS COMP2';
2072: END IF;
2073: --
2074:
2075: hr_utility.trace ('The category is : '|| l_tax_balance_category);
2076: if l_tax_balance_category = 'NONE' then
2077:
2078: l_return_value := call_balance_user_exit (
2079: l_tax_type,

Line 2355: hr_utility.trace('Returning : ' || l_return_value);

2351: l_virtual_date);
2352: END IF;
2353: END IF;
2354: --
2355: hr_utility.trace('Returning : ' || l_return_value);
2356: --
2357: return l_return_value;
2358: --
2359: END us_tax_balance;

Line 2479: -- hr_utility.trace_on(null,'tx');

2475: -- Set the next free cache space.
2476: g_nxt_free_dim := 4;
2477:
2478:
2479: -- hr_utility.trace_on(null,'tx');
2480: end pay_us_tax_bals_pkg;