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

Line 288: hr_utility.set_location(c_proc, 10);

284: l_jurisdiction_code VARCHAR2(11);
285: l_county_sch_dsts VARCHAR2(10) := 'N';
286:
287: BEGIN
288: hr_utility.set_location(c_proc, 10);
289:
290: OPEN csr_inputs (p_element_type_id, p_input_name);
291: FETCH csr_inputs INTO l_input_value_id;
292: CLOSE csr_inputs;

Line 295: hr_utility.set_location(c_proc, 20);

291: FETCH csr_inputs INTO l_input_value_id;
292: CLOSE csr_inputs;
293:
294: IF (l_input_value_id IS NULL) THEN
295: hr_utility.set_location(c_proc, 20);
296: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
297: hr_utility.raise_error;
298: END IF;
299:

Line 296: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');

292: CLOSE csr_inputs;
293:
294: IF (l_input_value_id IS NULL) THEN
295: hr_utility.set_location(c_proc, 20);
296: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
297: hr_utility.raise_error;
298: END IF;
299:
300: -- check taxability of the tax balance element

Line 297: hr_utility.raise_error;

293:
294: IF (l_input_value_id IS NULL) THEN
295: hr_utility.set_location(c_proc, 20);
296: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
297: hr_utility.raise_error;
298: END IF;
299:
300: -- check taxability of the tax balance element
301: hr_utility.set_location(c_proc, 30);

Line 301: hr_utility.set_location(c_proc, 30);

297: hr_utility.raise_error;
298: END IF;
299:
300: -- check taxability of the tax balance element
301: hr_utility.set_location(c_proc, 30);
302:
303: IF (g_classification IN ('Imputed Earnings', 'Supplemental Earnings')) THEN
304:
305: /** sbilling **/

Line 316: hr_utility.set_location(c_proc, 40);

312: ** causing the taxable amount to appear in Excess,
313: */
314: IF (p_input_name = 'Subj Whable' OR p_input_name = 'TAXABLE') THEN
315:
316: hr_utility.set_location(c_proc, 40);
317:
318: IF (p_element_type IN ('SUI_EE', 'SUI_SUBJECT_EE',
319: 'SUI_ER', 'SUI_SUBJECT_ER')) THEN
320: hr_utility.set_location(c_proc, 41);

Line 320: hr_utility.set_location(c_proc, 41);

316: hr_utility.set_location(c_proc, 40);
317:
318: IF (p_element_type IN ('SUI_EE', 'SUI_SUBJECT_EE',
319: 'SUI_ER', 'SUI_SUBJECT_ER')) THEN
320: hr_utility.set_location(c_proc, 41);
321: OPEN csr_chk_taxability ('SUI', g_state_jd );
322: FETCH csr_chk_taxability INTO l_taxable;
323: CLOSE csr_chk_taxability;
324:

Line 326: hr_utility.set_location(c_proc, 42);

322: FETCH csr_chk_taxability INTO l_taxable;
323: CLOSE csr_chk_taxability;
324:
325: ELSIF (p_element_type IN ('Medicare_EE', 'Medicare_ER')) THEN
326: hr_utility.set_location(c_proc, 42);
327: OPEN csr_chk_fed_taxability ('MEDICARE');
328: FETCH csr_chk_fed_taxability INTO l_taxable;
329: CLOSE csr_chk_fed_taxability;
330:

Line 332: hr_utility.set_location(c_proc, 43);

328: FETCH csr_chk_fed_taxability INTO l_taxable;
329: CLOSE csr_chk_fed_taxability;
330:
331: ELSIF (p_element_type IN ('SS_EE', 'SS_ER')) THEN
332: hr_utility.set_location(c_proc, 43);
333: OPEN csr_chk_fed_taxability ('SS');
334: FETCH csr_chk_fed_taxability INTO l_taxable;
335: CLOSE csr_chk_fed_taxability;
336:

Line 338: hr_utility.set_location(c_proc, 43);

334: FETCH csr_chk_fed_taxability INTO l_taxable;
335: CLOSE csr_chk_fed_taxability;
336:
337: ELSIF (p_element_type IN ('FUTA')) THEN
338: hr_utility.set_location(c_proc, 43);
339: OPEN csr_chk_fed_taxability ('FUTA');
340: FETCH csr_chk_fed_taxability INTO l_taxable;
341: CLOSE csr_chk_fed_taxability;
342:

Line 345: hr_utility.set_location(c_proc, 42);

341: CLOSE csr_chk_fed_taxability;
342:
343: ELSIF (p_element_type IN ('SDI_EE', 'SDI_SUBJECT_EE',
344: 'SDI_ER', 'SDI_SUBJECT_ER')) THEN
345: hr_utility.set_location(c_proc, 42);
346: OPEN csr_chk_taxability ('SDI', g_state_jd );
347: FETCH csr_chk_taxability INTO l_taxable;
348: CLOSE csr_chk_taxability;
349:

Line 351: hr_utility.set_location(c_proc, 43);

347: FETCH csr_chk_taxability INTO l_taxable;
348: CLOSE csr_chk_taxability;
349:
350: ELSIF (p_element_type = ('SIT_SUBJECT_WK') ) THEN
351: hr_utility.set_location(c_proc, 43);
352: OPEN csr_chk_taxability ('SIT', g_state_jd );
353: FETCH csr_chk_taxability INTO l_taxable;
354: CLOSE csr_chk_taxability;
355:

Line 357: hr_utility.set_location(c_proc, 44);

353: FETCH csr_chk_taxability INTO l_taxable;
354: CLOSE csr_chk_taxability;
355:
356: ELSIF (p_element_type = ('City_SUBJECT_WK') ) THEN
357: hr_utility.set_location(c_proc, 44);
358: l_jurisdiction_code := substr(g_city_jd,1,3) || '000' || substr(g_city_jd,7,5);
359: OPEN csr_chk_taxability ('CITY', l_jurisdiction_code);
360: FETCH csr_chk_taxability INTO l_taxable;
361: -- If the above query returns no rows then check the state level taxablility rule

Line 491: hr_utility.set_location(c_proc, 45);

487:
488: /* End of code for school district taxes. */
489:
490: ELSIF (p_element_type IN ('County_SUBJECT_WK')) THEN
491: hr_utility.set_location(c_proc, 45);
492: OPEN csr_chk_taxability ('COUNTY', g_county_jd);
493: FETCH csr_chk_taxability INTO l_taxable;
494: -- If the above query returns no rows then check the state level taxablility rule
495: -- as we are checking for SUBJ whable here. If we don't find a row for locality

Line 530: hr_utility.set_location(c_proc, 50);

526:
527: END IF;
528:
529: ELSIF (p_input_name = 'Subj NWhable') THEN
530: hr_utility.set_location(c_proc, 50);
531:
532: IF (p_element_type = ('SIT_SUBJECT_WK') ) THEN
533: hr_utility.set_location(c_proc, 51);
534: OPEN csr_chk_taxability ('NW_SIT', g_state_jd);

Line 533: hr_utility.set_location(c_proc, 51);

529: ELSIF (p_input_name = 'Subj NWhable') THEN
530: hr_utility.set_location(c_proc, 50);
531:
532: IF (p_element_type = ('SIT_SUBJECT_WK') ) THEN
533: hr_utility.set_location(c_proc, 51);
534: OPEN csr_chk_taxability ('NW_SIT', g_state_jd);
535: FETCH csr_chk_taxability INTO l_taxable;
536: CLOSE csr_chk_taxability;
537:

Line 539: hr_utility.set_location(c_proc, 52);

535: FETCH csr_chk_taxability INTO l_taxable;
536: CLOSE csr_chk_taxability;
537:
538: ELSIF (p_element_type = ('City_SUBJECT_WK') ) THEN
539: hr_utility.set_location(c_proc, 52);
540: l_jurisdiction_code := substr(g_city_jd,1,3) || '000' || substr(g_city_jd,7,5);
541: OPEN csr_chk_taxability ('NW_CITY', l_jurisdiction_code);
542: FETCH csr_chk_taxability INTO l_taxable;
543: -- If the above query returns no rows then check the state level taxablility rule

Line 577: hr_utility.set_location(c_proc, 53);

573: CLOSE csr_chk_taxability;
574: END IF;
575:
576: ELSIF (p_element_type IN ('County_SUBJECT_WK')) THEN
577: hr_utility.set_location(c_proc, 53);
578: OPEN csr_chk_taxability ('NW_COUNTY', g_county_jd);
579: FETCH csr_chk_taxability INTO l_taxable;
580: -- If the above query returns no rows then check the state level taxablility rule
581: -- as we are checking for SUBJ Nwhable here. If we don't find a row for locality

Line 713: hr_utility.set_location(c_proc, 60);

709:
710: END IF;
711:
712: ELSE
713: hr_utility.set_location(c_proc, 60);
714: -- otherwise we do not need to check taxability_rules
715: -- in order to set the value of the input value,
716: -- NB. that this step gets executed for tax elements like FIT, Medicare
717: -- as well as Tax balance elements like SUI_SUBJECT_EE

Line 723: hr_utility.set_location(c_proc, 70);

719: END IF;
720:
721: ELSE
722: -- an Earnings Element so no taxability rules
723: hr_utility.set_location(c_proc, 70);
724:
725: l_taxable := 'Y';
726:
727: END IF;

Line 731: hr_utility.set_location (c_proc, 200);

727: END IF;
728:
729:
730: IF (l_taxable = 'Y') THEN
731: hr_utility.set_location (c_proc, 200);
732:
733: p_iv_tbl(p_row) := l_input_value_id;
734: p_iv_names_tbl(p_row) := p_input_name;
735: p_ev_tbl(p_row) := p_entry_value;

Line 826: hr_utility.set_location(c_proc, 10);

822: /** stub - find an apppriate error message **/
823: IF (l_futa_wage_limit IS NULL OR
824: l_ss_ee_wage_limit IS NULL OR
825: l_ss_er_wage_limit IS NULL) THEN
826: hr_utility.set_location(c_proc, 10);
827: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
828: hr_utility.raise_error;
829: END IF;
830:

Line 827: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');

823: IF (l_futa_wage_limit IS NULL OR
824: l_ss_ee_wage_limit IS NULL OR
825: l_ss_er_wage_limit IS NULL) THEN
826: hr_utility.set_location(c_proc, 10);
827: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
828: hr_utility.raise_error;
829: END IF;
830:
831:

Line 828: hr_utility.raise_error;

824: l_ss_ee_wage_limit IS NULL OR
825: l_ss_er_wage_limit IS NULL) THEN
826: hr_utility.set_location(c_proc, 10);
827: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
828: hr_utility.raise_error;
829: END IF;
830:
831:
832: /*

Line 1083: hr_utility.set_location(c_proc, 10);

1079: p_assignment_id => p_assignment_id,
1080: p_virtual_date => l_virtual_adjustment_date); --Bug3697701
1081: ELSE
1082: /** stub - find appropriate message **/
1083: hr_utility.set_location(c_proc, 10);
1084: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
1085: hr_utility.raise_error;
1086:
1087: END IF;

Line 1084: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');

1080: p_virtual_date => l_virtual_adjustment_date); --Bug3697701
1081: ELSE
1082: /** stub - find appropriate message **/
1083: hr_utility.set_location(c_proc, 10);
1084: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
1085: hr_utility.raise_error;
1086:
1087: END IF;
1088:

Line 1085: hr_utility.raise_error;

1081: ELSE
1082: /** stub - find appropriate message **/
1083: hr_utility.set_location(c_proc, 10);
1084: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
1085: hr_utility.raise_error;
1086:
1087: END IF;
1088:
1089:

Line 1095: hr_utility.trace('P_earn_amount='||to_char(p_earn_amount));

1091: ** generic block, applies to all limit processing
1092: ** Excess is never passed or adjusted as it is a derived balance
1093: */
1094:
1095: hr_utility.trace('P_earn_amount='||to_char(p_earn_amount));
1096: hr_utility.trace('subject balance = ' || to_char(l_limit_subject_bal));
1097:
1098: IF ((l_old_taxable_bal + p_earn_amount) <= l_limit) THEN
1099:

Line 1096: hr_utility.trace('subject balance = ' || to_char(l_limit_subject_bal));

1092: ** Excess is never passed or adjusted as it is a derived balance
1093: */
1094:
1095: hr_utility.trace('P_earn_amount='||to_char(p_earn_amount));
1096: hr_utility.trace('subject balance = ' || to_char(l_limit_subject_bal));
1097:
1098: IF ((l_old_taxable_bal + p_earn_amount) <= l_limit) THEN
1099:
1100: /*

Line 1209: hr_utility.trace('in the elsif l_old_tax_amount + p_earn_amount > 0');

1205: ** EV amount of TAXABLE IV will cause limit to be exceeded,
1206: ** set EV amount up to limit
1207: */
1208:
1209: hr_utility.trace('in the elsif l_old_tax_amount + p_earn_amount > 0');
1210:
1211: l_adj_amt := l_limit - l_old_taxable_bal;
1212: hr_utility.trace('l_adj_amt = '||to_char(l_adj_amt));
1213:

Line 1212: hr_utility.trace('l_adj_amt = '||to_char(l_adj_amt));

1208:
1209: hr_utility.trace('in the elsif l_old_tax_amount + p_earn_amount > 0');
1210:
1211: l_adj_amt := l_limit - l_old_taxable_bal;
1212: hr_utility.trace('l_adj_amt = '||to_char(l_adj_amt));
1213:
1214: l_excess := (p_earn_amount + l_old_taxable_bal) - l_limit;
1215: hr_utility.trace('l_excess ='|| to_char(l_excess));
1216: /*

Line 1215: hr_utility.trace('l_excess ='|| to_char(l_excess));

1211: l_adj_amt := l_limit - l_old_taxable_bal;
1212: hr_utility.trace('l_adj_amt = '||to_char(l_adj_amt));
1213:
1214: l_excess := (p_earn_amount + l_old_taxable_bal) - l_limit;
1215: hr_utility.trace('l_excess ='|| to_char(l_excess));
1216: /*
1217: ** modify EV amount of TAXABLE IV before BA processing,
1218: ** set EV amount up to limit, remainder goes INTO excess
1219: */

Line 1313: hr_utility.trace('IN Process_element Element_type ='||p_element_type);

1309: l_payroll_action_id NUMBER;
1310:
1311: BEGIN
1312:
1313: hr_utility.trace('IN Process_element Element_type ='||p_element_type);
1314: HR_Utility.trace('Abbrev Element Type ='||p_abbrev_element_type);
1315:
1316: hr_utility.set_location(c_proc, 10);
1317: OPEN csr_element;

Line 1314: HR_Utility.trace('Abbrev Element Type ='||p_abbrev_element_type);

1310:
1311: BEGIN
1312:
1313: hr_utility.trace('IN Process_element Element_type ='||p_element_type);
1314: HR_Utility.trace('Abbrev Element Type ='||p_abbrev_element_type);
1315:
1316: hr_utility.set_location(c_proc, 10);
1317: OPEN csr_element;
1318: FETCH csr_element INTO l_element;

Line 1316: hr_utility.set_location(c_proc, 10);

1312:
1313: hr_utility.trace('IN Process_element Element_type ='||p_element_type);
1314: HR_Utility.trace('Abbrev Element Type ='||p_abbrev_element_type);
1315:
1316: hr_utility.set_location(c_proc, 10);
1317: OPEN csr_element;
1318: FETCH csr_element INTO l_element;
1319: CLOSE csr_element;
1320:

Line 1322: hr_utility.set_location(c_proc, 20);

1318: FETCH csr_element INTO l_element;
1319: CLOSE csr_element;
1320:
1321: IF (l_element.element_type_id IS NULL) THEN
1322: hr_utility.set_location(c_proc, 20);
1323: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
1324: hr_utility.raise_error;
1325: END IF;
1326:

Line 1323: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');

1319: CLOSE csr_element;
1320:
1321: IF (l_element.element_type_id IS NULL) THEN
1322: hr_utility.set_location(c_proc, 20);
1323: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
1324: hr_utility.raise_error;
1325: END IF;
1326:
1327: hr_utility.set_location(c_proc, 30);

Line 1324: hr_utility.raise_error;

1320:
1321: IF (l_element.element_type_id IS NULL) THEN
1322: hr_utility.set_location(c_proc, 20);
1323: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
1324: hr_utility.raise_error;
1325: END IF;
1326:
1327: hr_utility.set_location(c_proc, 30);
1328: l_ele_link_id := hr_entry_api.get_link(

Line 1327: hr_utility.set_location(c_proc, 30);

1323: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
1324: hr_utility.raise_error;
1325: END IF;
1326:
1327: hr_utility.set_location(c_proc, 30);
1328: l_ele_link_id := hr_entry_api.get_link(
1329: p_assignment_id => p_assignment_id,
1330: p_element_type_id => l_element.element_type_id,
1331: p_session_date => p_adjustment_date);

Line 1334: hr_utility.set_location(c_proc, 40);

1330: p_element_type_id => l_element.element_type_id,
1331: p_session_date => p_adjustment_date);
1332:
1333: IF (l_ele_link_id IS NULL) THEN
1334: hr_utility.set_location(c_proc, 40);
1335: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1336: hr_utility.set_message_token ('ELEMENT', p_element_type);
1337: hr_utility.raise_error;
1338: END IF;

Line 1335: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');

1331: p_session_date => p_adjustment_date);
1332:
1333: IF (l_ele_link_id IS NULL) THEN
1334: hr_utility.set_location(c_proc, 40);
1335: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1336: hr_utility.set_message_token ('ELEMENT', p_element_type);
1337: hr_utility.raise_error;
1338: END IF;
1339:

Line 1336: hr_utility.set_message_token ('ELEMENT', p_element_type);

1332:
1333: IF (l_ele_link_id IS NULL) THEN
1334: hr_utility.set_location(c_proc, 40);
1335: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1336: hr_utility.set_message_token ('ELEMENT', p_element_type);
1337: hr_utility.raise_error;
1338: END IF;
1339:
1340: -- initialize tables

Line 1337: hr_utility.raise_error;

1333: IF (l_ele_link_id IS NULL) THEN
1334: hr_utility.set_location(c_proc, 40);
1335: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1336: hr_utility.set_message_token ('ELEMENT', p_element_type);
1337: hr_utility.raise_error;
1338: END IF;
1339:
1340: -- initialize tables
1341: l_iv_names_tbl := g_dummy_varchar_tbl;

Line 1349: hr_utility.set_location(c_proc, 50);

1345:
1346: -- explicitly set the various input values,
1347: -- this clearly identifies which input values are expected and will cause failure
1348: -- if the input value has been deleted somehow
1349: hr_utility.set_location(c_proc, 50);
1350:
1351: IF (l_element.classification_name IN ('Earnings', 'Imputed Earnings',
1352: 'Supplemental Earnings')) THEN
1353: -- element is an Earnings element,

Line 1366: hr_utility.set_location (c_proc, 60);

1362: p_bg_id, p_adjustment_date,
1363: 'Pay Value', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1364:
1365: ELSIF (p_element_type IN ('FIT')) THEN
1366: hr_utility.set_location (c_proc, 60);
1367: process_input(p_element_type, l_element.element_type_id,
1368: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1369: p_bg_id, p_adjustment_date,
1370: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);

Line 1380: hr_utility.set_location (c_proc, 62);

1376: 'Supp Tax', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1377: END IF;
1378: -- 4188782
1379: ELSIF (p_element_type IN ('FSP_SUBJECT')) THEN
1380: hr_utility.set_location (c_proc, 62);
1381: process_input(p_element_type, l_element.element_type_id,
1382: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1383: p_bg_id, p_adjustment_date,
1384: 'Reduced Subj Whable',

Line 1388: hr_utility.set_location (c_proc, 65);

1384: 'Reduced Subj Whable',
1385: fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1386:
1387: ELSIF (p_element_type IN ('FIT 3rd Party')) THEN
1388: hr_utility.set_location (c_proc, 65);
1389: process_input(p_element_type, l_element.element_type_id,
1390: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1391: p_bg_id, p_adjustment_date,
1392: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);

Line 1395: hr_utility.set_location(c_proc, 71);

1391: p_bg_id, p_adjustment_date,
1392: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1393:
1394: ELSIF (p_element_type IN ('SS_EE', 'Medicare_EE')) THEN
1395: hr_utility.set_location(c_proc, 71);
1396: IF (p_adj_amount <> 0) THEN
1397: process_input(p_element_type, l_element.element_type_id,
1398: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1399: p_bg_id, p_adjustment_date,

Line 1403: hr_utility.set_location(c_proc, 72);

1399: p_bg_id, p_adjustment_date,
1400: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1401: END IF;
1402:
1403: hr_utility.set_location(c_proc, 72);
1404: process_input(p_element_type, l_element.element_type_id,
1405: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1406: p_bg_id, p_adjustment_date,
1407: 'TAXABLE', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);

Line 1452: hr_utility.set_location(c_proc, 81);

1448: p_jurisdiction,p_tax_unit_id,p_adjustment_date);
1449: END IF;
1450:
1451: ELSIF (p_element_type IN ('SIT_WK')) THEN
1452: hr_utility.set_location(c_proc, 81);
1453:
1454: process_input(p_element_type, l_element.element_type_id,
1455: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1456: p_bg_id, p_adjustment_date,

Line 1458: hr_utility.set_location(c_proc, 82);

1454: process_input(p_element_type, l_element.element_type_id,
1455: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1456: p_bg_id, p_adjustment_date,
1457: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1458: hr_utility.set_location(c_proc, 82);
1459:
1460: process_input(p_element_type, l_element.element_type_id,
1461: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1462: p_bg_id, p_adjustment_date,

Line 1477: hr_utility.set_location(c_proc, 81);

1473: /*
1474: ** new tax element to be processed, use SIT_WK as a template
1475: */
1476: ELSIF (p_element_type IN ('County_SC_WK')) THEN
1477: hr_utility.set_location(c_proc, 81);
1478:
1479: process_input(p_element_type, l_element.element_type_id,
1480: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1481: p_bg_id, p_adjustment_date,

Line 1483: hr_utility.set_location(c_proc, 82);

1479: process_input(p_element_type, l_element.element_type_id,
1480: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1481: p_bg_id, p_adjustment_date,
1482: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1483: hr_utility.set_location(c_proc, 82);
1484:
1485:
1486: /*
1487: ** can't put the Gross for the BA INTO the Gross for the school district tax,

Line 1496: hr_utility.set_location(c_proc, 91);

1492: p_bg_id, p_adjustment_date,
1493: 'Jurisdiction', p_jurisdiction, l_num_ev);
1494:
1495: ELSIF (p_element_type IN ('SUI_EE', 'SDI_EE')) THEN
1496: hr_utility.set_location(c_proc, 91);
1497:
1498: IF (p_adj_amount <> 0) THEN
1499: process_input(p_element_type, l_element.element_type_id,
1500: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,

Line 1503: hr_utility.set_location(c_proc, 915);

1499: process_input(p_element_type, l_element.element_type_id,
1500: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1501: p_bg_id, p_adjustment_date,
1502: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1503: hr_utility.set_location(c_proc, 915);
1504: END IF;
1505:
1506: hr_utility.set_location(c_proc, 92);
1507:

Line 1506: hr_utility.set_location(c_proc, 92);

1502: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1503: hr_utility.set_location(c_proc, 915);
1504: END IF;
1505:
1506: hr_utility.set_location(c_proc, 92);
1507:
1508: process_input(p_element_type, l_element.element_type_id,
1509: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1510: p_bg_id, p_adjustment_date,

Line 1512: hr_utility.set_location(c_proc, 93);

1508: process_input(p_element_type, l_element.element_type_id,
1509: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1510: p_bg_id, p_adjustment_date,
1511: 'TAXABLE', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1512: hr_utility.set_location(c_proc, 93);
1513:
1514: process_input(p_element_type, l_element.element_type_id,
1515: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1516: p_bg_id, p_adjustment_date,

Line 1527: hr_utility.set_location(c_proc, 101);

1523: l_iv_names_tbl, l_ev_tbl, l_num_ev,p_assignment_id,
1524: p_jurisdiction,p_tax_unit_id,p_adjustment_date);
1525:
1526: ELSIF (p_element_type IN ('City_WK', 'County_WK')) THEN
1527: hr_utility.set_location(c_proc, 101);
1528:
1529: process_input(p_element_type, l_element.element_type_id,
1530: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1531: p_bg_id, p_adjustment_date,

Line 1533: hr_utility.set_location(c_proc, 102);

1529: process_input(p_element_type, l_element.element_type_id,
1530: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1531: p_bg_id, p_adjustment_date,
1532: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1533: hr_utility.set_location(c_proc, 102);
1534:
1535: process_input(p_element_type, l_element.element_type_id,
1536: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1537: p_bg_id, p_adjustment_date,

Line 1542: hr_utility.set_location(c_proc, 111);

1538: 'Jurisdiction', p_jurisdiction, l_num_ev);
1539:
1540: ELSIF (p_element_type IN ('SIT_SUBJECT_WK', 'City_SUBJECT_WK',
1541: 'County_SUBJECT_WK', 'School_SUBJECT_WK')) THEN
1542: hr_utility.set_location(c_proc, 111);
1543:
1544: process_input(p_element_type, l_element.element_type_id,
1545: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1546: p_bg_id, p_adjustment_date,

Line 1548: hr_utility.set_location(c_proc, 112);

1544: process_input(p_element_type, l_element.element_type_id,
1545: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1546: p_bg_id, p_adjustment_date,
1547: 'Jurisdiction', p_jurisdiction, l_num_ev);
1548: hr_utility.set_location(c_proc, 112);
1549:
1550: process_input(p_element_type, l_element.element_type_id,
1551: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1552: p_bg_id, p_adjustment_date,

Line 1554: hr_utility.set_location(c_proc, 113);

1550: process_input(p_element_type, l_element.element_type_id,
1551: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1552: p_bg_id, p_adjustment_date,
1553: 'Gross', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1554: hr_utility.set_location(c_proc, 113);
1555:
1556: process_input(p_element_type, l_element.element_type_id,
1557: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1558: p_bg_id, p_adjustment_date,

Line 1560: hr_utility.set_location(c_proc, 114);

1556: process_input(p_element_type, l_element.element_type_id,
1557: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1558: p_bg_id, p_adjustment_date,
1559: 'Subj Whable', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1560: hr_utility.set_location(c_proc, 114);
1561:
1562: IF (g_classification IN ('Imputed Earnings',
1563: 'Supplemental Earnings')) THEN
1564: hr_utility.set_location(c_proc, 115);

Line 1564: hr_utility.set_location(c_proc, 115);

1560: hr_utility.set_location(c_proc, 114);
1561:
1562: IF (g_classification IN ('Imputed Earnings',
1563: 'Supplemental Earnings')) THEN
1564: hr_utility.set_location(c_proc, 115);
1565:
1566: process_input (p_element_type, l_element.element_type_id,
1567: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1568: p_bg_id, p_adjustment_date,

Line 1574: hr_utility.set_location(c_proc, 121);

1570: END IF;
1571:
1572: ELSIF (p_element_type IN ('SDI_SUBJECT_EE', 'SDI_SUBJECT_ER',
1573: 'SUI_SUBJECT_EE', 'SUI_SUBJECT_ER')) THEN
1574: hr_utility.set_location(c_proc, 121);
1575:
1576: process_input(p_element_type, l_element.element_type_id,
1577: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1578: p_bg_id, p_adjustment_date,

Line 1580: hr_utility.set_location(c_proc, 122);

1576: process_input(p_element_type, l_element.element_type_id,
1577: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1578: p_bg_id, p_adjustment_date,
1579: 'Jurisdiction', p_jurisdiction, l_num_ev);
1580: hr_utility.set_location(c_proc, 122);
1581:
1582: process_input(p_element_type, l_element.element_type_id,
1583: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1584: p_bg_id, p_adjustment_date,

Line 1586: hr_utility.set_location(c_proc, 123);

1582: process_input(p_element_type, l_element.element_type_id,
1583: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1584: p_bg_id, p_adjustment_date,
1585: 'Gross', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1586: hr_utility.set_location(c_proc, 123);
1587:
1588: process_input(p_element_type, l_element.element_type_id,
1589: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1590: p_bg_id, p_adjustment_date,

Line 1594: hr_utility.set_location (c_proc, 124);

1590: p_bg_id, p_adjustment_date,
1591: 'Subj Whable', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1592:
1593: ELSIF (p_element_type IN ('SUI_ER', 'SDI_ER')) THEN
1594: hr_utility.set_location (c_proc, 124);
1595:
1596:
1597: /** sbilling **/
1598: /*

Line 1633: hr_utility.set_location(c_proc, 130);

1629:
1630:
1631: -- set mandatory input values,
1632: -- cannot set these to NULL, core package expects mandatory values to be entered
1633: hr_utility.set_location(c_proc, 130);
1634:
1635: FOR l_req_input IN csr_set_mandatory_inputs (l_element.element_type_id) LOOP
1636: -- first, check if the mandatory input value was explicitly
1637: -- set above, do nothing in this case

Line 1638: hr_utility.set_location(c_proc, 140);

1634:
1635: FOR l_req_input IN csr_set_mandatory_inputs (l_element.element_type_id) LOOP
1636: -- first, check if the mandatory input value was explicitly
1637: -- set above, do nothing in this case
1638: hr_utility.set_location(c_proc, 140);
1639:
1640: FOR l_counter IN 1..l_num_ev LOOP
1641:
1642: IF (l_req_input.input_name = l_iv_names_tbl(l_counter)) THEN

Line 1647: hr_utility.set_location(c_proc, 150);

1643: NULL;
1644: ELSE
1645: -- then the input value was not previously set by one of the
1646: -- process_inputs called in process_elements
1647: hr_utility.set_location(c_proc, 150);
1648: l_num_ev := l_num_ev + 1;
1649:
1650: l_iv_tbl(l_num_ev) := l_req_input.input_value_id;
1651: l_iv_names_tbl(l_num_ev) := l_req_input.input_name;

Line 1658: hr_utility.set_location(c_proc, 160);

1654:
1655: END LOOP;
1656: END LOOP;
1657:
1658: hr_utility.set_location(c_proc, 160);
1659:
1660: pay_bal_adjust.adjust_balance(p_batch_id => p_payroll_action_id,
1661: p_assignment_id => p_assignment_id,
1662: p_element_link_id => l_ele_link_id,

Line 1729: hr_utility.set_location(c_proc, 10);

1725:
1726: BEGIN
1727:
1728: IF (p_city_name IS NOT NULL AND p_zip_code IS NOT NULL) THEN
1729: hr_utility.set_location(c_proc, 10);
1730: l_geocode := hr_us_ff_udfs.addr_val(
1731: p_state_abbrev => p_state_abbrev,
1732: p_county_name => p_county_name,
1733: p_city_name => p_city_name,

Line 1741: hr_utility.set_location(c_proc, 15);

1737: FETCH csr_chk_local INTO l_valid_for_asg;
1738: CLOSE csr_chk_local;
1739:
1740: IF (l_valid_for_asg = 'FAIL') THEN
1741: hr_utility.set_location(c_proc, 15);
1742: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1743: hr_utility.raise_error;
1744: END IF;
1745:

Line 1742: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');

1738: CLOSE csr_chk_local;
1739:
1740: IF (l_valid_for_asg = 'FAIL') THEN
1741: hr_utility.set_location(c_proc, 15);
1742: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1743: hr_utility.raise_error;
1744: END IF;
1745:
1746: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN

Line 1743: hr_utility.raise_error;

1739:
1740: IF (l_valid_for_asg = 'FAIL') THEN
1741: hr_utility.set_location(c_proc, 15);
1742: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1743: hr_utility.raise_error;
1744: END IF;
1745:
1746: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN
1747: hr_utility.set_location(c_proc, 20);

Line 1747: hr_utility.set_location(c_proc, 20);

1743: hr_utility.raise_error;
1744: END IF;
1745:
1746: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN
1747: hr_utility.set_location(c_proc, 20);
1748: OPEN csr_county_code;
1749: FETCH csr_county_code INTO l_state_code, l_county_code;
1750: CLOSE csr_county_code;
1751: l_geocode := l_state_code||'-'||l_county_code||'-0000';

Line 1758: hr_utility.set_location(c_proc, 25);

1754: FETCH csr_chk_local INTO l_valid_for_asg;
1755: CLOSE csr_chk_local;
1756:
1757: IF (l_valid_for_asg = 'FAIL') THEN
1758: hr_utility.set_location(c_proc, 25);
1759: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1760: hr_utility.raise_error;
1761: END IF;
1762:

Line 1759: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');

1755: CLOSE csr_chk_local;
1756:
1757: IF (l_valid_for_asg = 'FAIL') THEN
1758: hr_utility.set_location(c_proc, 25);
1759: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1760: hr_utility.raise_error;
1761: END IF;
1762:
1763: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN

Line 1760: hr_utility.raise_error;

1756:
1757: IF (l_valid_for_asg = 'FAIL') THEN
1758: hr_utility.set_location(c_proc, 25);
1759: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1760: hr_utility.raise_error;
1761: END IF;
1762:
1763: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN
1764: hr_utility.set_location(c_proc, 30);

Line 1764: hr_utility.set_location(c_proc, 30);

1760: hr_utility.raise_error;
1761: END IF;
1762:
1763: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN
1764: hr_utility.set_location(c_proc, 30);
1765: OPEN csr_state_code;
1766: FETCH csr_state_code INTO l_state_code;
1767: CLOSE csr_state_code;
1768: l_geocode := l_state_code||'-000-0000';

Line 1775: hr_utility.set_location(c_proc, 25);

1771: FETCH csr_chk_state INTO l_valid_for_asg;
1772: CLOSE csr_chk_state;
1773:
1774: IF (l_valid_for_asg = 'FAIL') THEN
1775: hr_utility.set_location(c_proc, 25);
1776: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1777: hr_utility.raise_error;
1778: END IF;
1779:

Line 1776: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');

1772: CLOSE csr_chk_state;
1773:
1774: IF (l_valid_for_asg = 'FAIL') THEN
1775: hr_utility.set_location(c_proc, 25);
1776: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1777: hr_utility.raise_error;
1778: END IF;
1779:
1780: ELSE

Line 1777: hr_utility.raise_error;

1773:
1774: IF (l_valid_for_asg = 'FAIL') THEN
1775: hr_utility.set_location(c_proc, 25);
1776: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
1777: hr_utility.raise_error;
1778: END IF;
1779:
1780: ELSE
1781: l_geocode := '00-000-0000';

Line 2239: hr_utility.set_location(c_proc, 5);

2235:
2236: -- get assignment_id and business_group_id based on assignment number
2237: -- and business group name.
2238: BEGIN
2239: hr_utility.set_location(c_proc, 5);
2240: SELECT a.assignment_id,
2241: a.business_group_id,
2242: a.payroll_id
2243: INTO l_assignment_id,

Line 2256: hr_utility.set_message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');

2252: a.effective_start_date AND a.effective_end_date
2253: ;
2254: EXCEPTION
2255: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
2256: hr_utility.set_message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');
2257: hr_utility.raise_error;
2258: END;
2259:
2260: -- get assignment derived jurisdiction geocode for state,county,city,zip code

Line 2257: hr_utility.raise_error;

2253: ;
2254: EXCEPTION
2255: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
2256: hr_utility.set_message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');
2257: hr_utility.raise_error;
2258: END;
2259:
2260: -- get assignment derived jurisdiction geocode for state,county,city,zip code
2261: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,

Line 2343: hr_utility.set_message(801, 'PY_51134_TXADJ_TAX_NET_TOT');

2339: l_sui_ee + l_sdi_ee + l_county + l_city +
2340: l_sch_dist_wh_ee;
2341:
2342: IF (l_gross_amount <> l_net_amount + l_total_taxes_withheld) THEN
2343: hr_utility.set_message(801, 'PY_51134_TXADJ_TAX_NET_TOT');
2344: hr_utility.raise_error;
2345: END IF;
2346:
2347: END IF;

Line 2344: hr_utility.raise_error;

2340: l_sch_dist_wh_ee;
2341:
2342: IF (l_gross_amount <> l_net_amount + l_total_taxes_withheld) THEN
2343: hr_utility.set_message(801, 'PY_51134_TXADJ_TAX_NET_TOT');
2344: hr_utility.raise_error;
2345: END IF;
2346:
2347: END IF;
2348:

Line 2353: hr_utility.set_message(801, 'PY_51140_TXADJ_EARN_ELE_REQ');

2349:
2350: -- 2. check that if an earnings element is provided if Gross is non-zero
2351:
2352: IF (l_gross_amount <> 0 AND p_earning_element_type IS NULL) THEN
2353: hr_utility.set_message(801, 'PY_51140_TXADJ_EARN_ELE_REQ');
2354: hr_utility.raise_error;
2355: END IF;
2356:
2357:

Line 2354: hr_utility.raise_error;

2350: -- 2. check that if an earnings element is provided if Gross is non-zero
2351:
2352: IF (l_gross_amount <> 0 AND p_earning_element_type IS NULL) THEN
2353: hr_utility.set_message(801, 'PY_51140_TXADJ_EARN_ELE_REQ');
2354: hr_utility.raise_error;
2355: END IF;
2356:
2357:
2358: -- 3. check that SIT = 0 for Alaska, Florida, Nevada, New Hampshire, South Dakota,

Line 2363: hr_utility.set_message(801, 'PY_51141_TXADJ_SIT_EXEMPT');

2359: -- Tennessee, Texas, Washington, Wyoming, and the Virgin Islands
2360:
2361: IF ((l_sit <> 0) AND
2362: (tax_exists(l_jd_entered, 'SIT', p_adjustment_date) = 'N')) THEN
2363: hr_utility.set_message(801, 'PY_51141_TXADJ_SIT_EXEMPT');
2364: hr_utility.raise_error;
2365: END IF;
2366:
2367: /* bug 1608907 */

Line 2364: hr_utility.raise_error;

2360:
2361: IF ((l_sit <> 0) AND
2362: (tax_exists(l_jd_entered, 'SIT', p_adjustment_date) = 'N')) THEN
2363: hr_utility.set_message(801, 'PY_51141_TXADJ_SIT_EXEMPT');
2364: hr_utility.raise_error;
2365: END IF;
2366:
2367: /* bug 1608907 */
2368: IF ((l_county <> 0) AND

Line 2370: hr_utility.set_message(801, 'PY_50980_TXADJ_COUNTY_EXEMPT');

2366:
2367: /* bug 1608907 */
2368: IF ((l_county <> 0) AND
2369: (tax_exists(l_jd_entered, 'COUNTY', p_adjustment_date) = 'N')) THEN
2370: hr_utility.set_message(801, 'PY_50980_TXADJ_COUNTY_EXEMPT');
2371: hr_utility.raise_error;
2372: END IF;
2373:
2374: IF ((l_city <> 0) AND

Line 2371: hr_utility.raise_error;

2367: /* bug 1608907 */
2368: IF ((l_county <> 0) AND
2369: (tax_exists(l_jd_entered, 'COUNTY', p_adjustment_date) = 'N')) THEN
2370: hr_utility.set_message(801, 'PY_50980_TXADJ_COUNTY_EXEMPT');
2371: hr_utility.raise_error;
2372: END IF;
2373:
2374: IF ((l_city <> 0) AND
2375: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date) = 'N')) THEN

Line 2376: hr_utility.set_message(801, 'PY_50981_TAXADJ_CITY_EXEMPT');

2372: END IF;
2373:
2374: IF ((l_city <> 0) AND
2375: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date) = 'N')) THEN
2376: hr_utility.set_message(801, 'PY_50981_TAXADJ_CITY_EXEMPT');
2377: hr_utility.raise_error;
2378: END IF;
2379:
2380: /* bug 1608907 */

Line 2377: hr_utility.raise_error;

2373:
2374: IF ((l_city <> 0) AND
2375: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date) = 'N')) THEN
2376: hr_utility.set_message(801, 'PY_50981_TAXADJ_CITY_EXEMPT');
2377: hr_utility.raise_error;
2378: END IF;
2379:
2380: /* bug 1608907 */
2381:

Line 2397: hr_utility.set_message(801, 'PY_51327_TXADJ_SDI_JD');

2393: FETCH csr_sdi_check INTO l_primary_asg_state;
2394:
2395: IF csr_sdi_check%NOTFOUND THEN
2396: CLOSE csr_sdi_check;
2397: hr_utility.set_message(801, 'PY_51327_TXADJ_SDI_JD');
2398: hr_utility.raise_error;
2399: END IF;
2400:
2401: CLOSE csr_sdi_check;

Line 2398: hr_utility.raise_error;

2394:
2395: IF csr_sdi_check%NOTFOUND THEN
2396: CLOSE csr_sdi_check;
2397: hr_utility.set_message(801, 'PY_51327_TXADJ_SDI_JD');
2398: hr_utility.raise_error;
2399: END IF;
2400:
2401: CLOSE csr_sdi_check;
2402:

Line 2408: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');

2404:
2405: IF ( l_sdi_ee <> 0) THEN
2406: --IF (p_state_abbrev NOT IN ('CA', 'HI', 'NJ', 'NY', 'RI')) THEN
2407: IF (tax_exists(l_jd_entered, 'SDI_EE', p_adjustment_date) = 'N') THEN
2408: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
2409: hr_utility.raise_error;
2410: END IF;
2411:
2412: END IF;

Line 2409: hr_utility.raise_error;

2405: IF ( l_sdi_ee <> 0) THEN
2406: --IF (p_state_abbrev NOT IN ('CA', 'HI', 'NJ', 'NY', 'RI')) THEN
2407: IF (tax_exists(l_jd_entered, 'SDI_EE', p_adjustment_date) = 'N') THEN
2408: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
2409: hr_utility.raise_error;
2410: END IF;
2411:
2412: END IF;
2413:

Line 2417: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');

2413:
2414: IF ( l_sdi_er <> 0) THEN
2415: --IF (p_state_abbrev NOT IN ('NJ', 'NY')) THEN
2416: IF (tax_exists(l_jd_entered, 'SDI_ER', p_adjustment_date) = 'N') THEN
2417: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
2418: hr_utility.raise_error;
2419: END IF;
2420:
2421: END IF;

Line 2418: hr_utility.raise_error;

2414: IF ( l_sdi_er <> 0) THEN
2415: --IF (p_state_abbrev NOT IN ('NJ', 'NY')) THEN
2416: IF (tax_exists(l_jd_entered, 'SDI_ER', p_adjustment_date) = 'N') THEN
2417: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
2418: hr_utility.raise_error;
2419: END IF;
2420:
2421: END IF;
2422:

Line 2477: hr_utility.set_message(801, 'PY_51328_TXADJ_SUI_EXEMPT');

2473: ** assignment (NJ) then SUI_EE does not apply
2474: */
2475: IF (tax_exists(l_jd_entered, 'SUI_EE', p_adjustment_date) = 'N') OR
2476: (g_sui_state_code <> p_state_abbrev) THEN
2477: hr_utility.set_message(801, 'PY_51328_TXADJ_SUI_EXEMPT');
2478: hr_utility.raise_error;
2479: END IF;
2480:
2481: END IF;

Line 2478: hr_utility.raise_error;

2474: */
2475: IF (tax_exists(l_jd_entered, 'SUI_EE', p_adjustment_date) = 'N') OR
2476: (g_sui_state_code <> p_state_abbrev) THEN
2477: hr_utility.set_message(801, 'PY_51328_TXADJ_SUI_EXEMPT');
2478: hr_utility.raise_error;
2479: END IF;
2480:
2481: END IF;
2482:

Line 2484: hr_utility.set_location(c_proc, 10);

2480:
2481: END IF;
2482:
2483: BEGIN
2484: hr_utility.set_location(c_proc, 10);
2485: SELECT consolidation_set_id
2486: INTO l_consolidation_set_id
2487: FROM PAY_CONSOLIDATION_SETS
2488: WHERE consolidation_set_name = p_consolidation_set

Line 2493: hr_utility.set_message(801, 'PY_51136_TXADJ_CONSET_NOT_FND');

2489: and business_group_id = l_bg_id
2490: ;
2491: EXCEPTION
2492: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
2493: hr_utility.set_message(801, 'PY_51136_TXADJ_CONSET_NOT_FND');
2494: hr_utility.raise_error;
2495: END;
2496:
2497: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,

Line 2494: hr_utility.raise_error;

2490: ;
2491: EXCEPTION
2492: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
2493: hr_utility.set_message(801, 'PY_51136_TXADJ_CONSET_NOT_FND');
2494: hr_utility.raise_error;
2495: END;
2496:
2497: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,
2498: p_state_abbrev => p_state_abbrev,

Line 2554: hr_utility.set_location(c_proc, 15);

2550: -- more error checking
2551:
2552: -- check the level of l_jd_entered to see if all taxes entered
2553: -- are applicable for the jurisdiction entered
2554: hr_utility.set_location(c_proc, 15);
2555:
2556: IF (l_city <> 0) THEN -- jd level needed is for a city --Bug3697701 --Removed the condition
2557: l_jd_level_needed := 4; --OR l_gross_amount <> 0 from IF stmt.
2558:

Line 2588: hr_utility.set_location(c_proc, 20);

2584:
2585:
2586: -- now compare the level of jd entered against the level required
2587: IF (l_jd_level_needed > l_jd_level_entered) THEN
2588: hr_utility.set_location(c_proc, 20);
2589: hr_utility.set_message(801, 'PY_50015_TXADJ_JD_INSUFF');
2590: hr_utility.raise_error;
2591: END IF;
2592:

Line 2589: hr_utility.set_message(801, 'PY_50015_TXADJ_JD_INSUFF');

2585:
2586: -- now compare the level of jd entered against the level required
2587: IF (l_jd_level_needed > l_jd_level_entered) THEN
2588: hr_utility.set_location(c_proc, 20);
2589: hr_utility.set_message(801, 'PY_50015_TXADJ_JD_INSUFF');
2590: hr_utility.raise_error;
2591: END IF;
2592:
2593:

Line 2590: hr_utility.raise_error;

2586: -- now compare the level of jd entered against the level required
2587: IF (l_jd_level_needed > l_jd_level_entered) THEN
2588: hr_utility.set_location(c_proc, 20);
2589: hr_utility.set_message(801, 'PY_50015_TXADJ_JD_INSUFF');
2590: hr_utility.raise_error;
2591: END IF;
2592:
2593:
2594: -- main processing

Line 2595: hr_utility.set_location(c_proc, 30);

2591: END IF;
2592:
2593:
2594: -- main processing
2595: hr_utility.set_location(c_proc, 30);
2596:
2597: -- first call routine to create payroll_action_id, we will only need
2598: -- one for entire tax balance adjustment process
2599: l_payroll_action_id := pay_bal_adjust.init_batch(p_payroll_id => l_payroll_id,

Line 2905: hr_utility.trace('before process_element with SIT_SUBJECT_WK '||TO_CHAR(l_sit));

2901: end if;
2902:
2903:
2904: IF (tax_exists(l_jd_entered, 'SIT', p_adjustment_date) = 'Y') THEN
2905: hr_utility.trace('before process_element with SIT_SUBJECT_WK '||TO_CHAR(l_sit));
2906: process_element(p_assignment_id => l_assignment_id,
2907: p_consolidation_set_id => l_consolidation_set_id,
2908: p_element_type => 'SIT_SUBJECT_WK',
2909: p_abbrev_element_type => 'SITSubK',

Line 3211: IF hr_utility.check_warning THEN

3207:
3208: -- set some of the return out parameters
3209: p_payroll_action_id := l_payroll_action_id;
3210:
3211: IF hr_utility.check_warning THEN
3212: l_create_warning := TRUE;
3213: hr_utility.clear_warning;
3214: END IF;
3215:

Line 3213: hr_utility.clear_warning;

3209: p_payroll_action_id := l_payroll_action_id;
3210:
3211: IF hr_utility.check_warning THEN
3212: l_create_warning := TRUE;
3213: hr_utility.clear_warning;
3214: END IF;
3215:
3216: IF(p_validate) THEN
3217: RAISE hr_api.validate_enabled;

Line 3220: hr_utility.trace('Finished Routine, all adjustments commited');

3216: IF(p_validate) THEN
3217: RAISE hr_api.validate_enabled;
3218: END IF;
3219:
3220: hr_utility.trace('Finished Routine, all adjustments commited');
3221: hr_utility.trace('Payroll_action_id = '||TO_CHAR(l_payroll_action_id));
3222:
3223: pay_bal_adjust.process_batch(p_payroll_action_id);
3224:

Line 3221: hr_utility.trace('Payroll_action_id = '||TO_CHAR(l_payroll_action_id));

3217: RAISE hr_api.validate_enabled;
3218: END IF;
3219:
3220: hr_utility.trace('Finished Routine, all adjustments commited');
3221: hr_utility.trace('Payroll_action_id = '||TO_CHAR(l_payroll_action_id));
3222:
3223: pay_bal_adjust.process_batch(p_payroll_action_id);
3224:
3225:

Line 3240: hr_utility.trace('Validate Enabled, no commits are made');

3236: -- when validation only mode is being used.)
3237: --
3238: p_payroll_action_id := NULL;
3239: p_create_warning := l_create_warning;
3240: hr_utility.trace('Validate Enabled, no commits are made');
3241:
3242: WHEN OTHERS THEN
3243: -- Unexpected error detected.
3244: ROLLBACK TO create_tax_bal_adjustment;