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 386: hr_utility.set_location(c_proc, 10);

382: l_jurisdiction_code VARCHAR2(11);
383: l_county_sch_dsts VARCHAR2(10) := 'N';
384:
385: BEGIN
386: hr_utility.set_location(c_proc, 10);
387:
388: OPEN csr_inputs (p_element_type_id, p_input_name);
389: FETCH csr_inputs INTO l_input_value_id;
390: CLOSE csr_inputs;

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

389: FETCH csr_inputs INTO l_input_value_id;
390: CLOSE csr_inputs;
391:
392: IF (l_input_value_id IS NULL) THEN
393: hr_utility.set_location(c_proc, 20);
394: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
395: hr_utility.raise_error;
396: END IF;
397:

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

390: CLOSE csr_inputs;
391:
392: IF (l_input_value_id IS NULL) THEN
393: hr_utility.set_location(c_proc, 20);
394: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
395: hr_utility.raise_error;
396: END IF;
397:
398: -- check taxability of the tax balance element

Line 395: hr_utility.raise_error;

391:
392: IF (l_input_value_id IS NULL) THEN
393: hr_utility.set_location(c_proc, 20);
394: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
395: hr_utility.raise_error;
396: END IF;
397:
398: -- check taxability of the tax balance element
399: hr_utility.set_location(c_proc, 30);

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

395: hr_utility.raise_error;
396: END IF;
397:
398: -- check taxability of the tax balance element
399: hr_utility.set_location(c_proc, 30);
400:
401: IF (g_classification IN ('Imputed Earnings', 'Supplemental Earnings')) THEN
402:
403: /** sbilling **/

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

410: ** causing the taxable amount to appear in Excess,
411: */
412: IF (p_input_name = 'Subj Whable' OR upper(p_input_name) = 'TAXABLE') THEN
413:
414: hr_utility.set_location(c_proc, 40);
415:
416: IF (p_element_type IN ('SUI_EE', 'SUI_SUBJECT_EE',
417: 'SUI_ER', 'SUI_SUBJECT_ER')) THEN
418: hr_utility.set_location(c_proc, 41);

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

414: hr_utility.set_location(c_proc, 40);
415:
416: IF (p_element_type IN ('SUI_EE', 'SUI_SUBJECT_EE',
417: 'SUI_ER', 'SUI_SUBJECT_ER')) THEN
418: hr_utility.set_location(c_proc, 41);
419: OPEN csr_chk_taxability ('SUI', g_state_jd );
420: FETCH csr_chk_taxability INTO l_taxable;
421: CLOSE csr_chk_taxability;
422: /*Bug#9872952 Added MEDICARE_SUBJECT_EE and MEDICARE_SUBJECT_ER */

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

420: FETCH csr_chk_taxability INTO l_taxable;
421: CLOSE csr_chk_taxability;
422: /*Bug#9872952 Added MEDICARE_SUBJECT_EE and MEDICARE_SUBJECT_ER */
423: ELSIF (p_element_type IN ('Medicare_EE', 'Medicare_ER' ,'MEDICARE_SUBJECT_EE','MEDICARE_SUBJECT_ER')) THEN
424: hr_utility.set_location(c_proc, 42);
425: OPEN csr_chk_fed_taxability ('MEDICARE');
426: FETCH csr_chk_fed_taxability INTO l_taxable;
427: CLOSE csr_chk_fed_taxability;
428: /*Bug#9872952 Added SS_SUBJECT_ER and SS_SUBJECT_EE */

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

426: FETCH csr_chk_fed_taxability INTO l_taxable;
427: CLOSE csr_chk_fed_taxability;
428: /*Bug#9872952 Added SS_SUBJECT_ER and SS_SUBJECT_EE */
429: ELSIF (p_element_type IN ('SS_EE', 'SS_ER','SS_SUBJECT_ER','SS_SUBJECT_EE', 'SS_ER_W11')) THEN
430: hr_utility.set_location(c_proc, 43);
431: OPEN csr_chk_fed_taxability ('SS');
432: FETCH csr_chk_fed_taxability INTO l_taxable;
433: CLOSE csr_chk_fed_taxability;
434: /*Bug#9872952 Added FUTA_SUBJECT*/

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

432: FETCH csr_chk_fed_taxability INTO l_taxable;
433: CLOSE csr_chk_fed_taxability;
434: /*Bug#9872952 Added FUTA_SUBJECT*/
435: ELSIF (p_element_type IN ('FUTA','FUTA_SUBJECT')) THEN
436: hr_utility.set_location(c_proc, 43);
437: OPEN csr_chk_fed_taxability ('FUTA');
438: FETCH csr_chk_fed_taxability INTO l_taxable;
439: CLOSE csr_chk_fed_taxability;
440:

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

440:
441: ELSIF (p_element_type IN ('SDI_EE', 'SDI_SUBJECT_EE',
442: 'SDI_ER', 'SDI_SUBJECT_ER',
443: 'SDI1_EE' )) THEN
444: hr_utility.set_location(c_proc, 42);
445: OPEN csr_chk_taxability ('SDI', g_state_jd );
446: FETCH csr_chk_taxability INTO l_taxable;
447: CLOSE csr_chk_taxability;
448:

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

446: FETCH csr_chk_taxability INTO l_taxable;
447: CLOSE csr_chk_taxability;
448:
449: ELSIF (p_element_type = ('SIT_SUBJECT_WK') ) THEN
450: hr_utility.set_location(c_proc, 43);
451: OPEN csr_chk_taxability ('SIT', g_state_jd );
452: FETCH csr_chk_taxability INTO l_taxable;
453: CLOSE csr_chk_taxability;
454:

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

452: FETCH csr_chk_taxability INTO l_taxable;
453: CLOSE csr_chk_taxability;
454:
455: ELSIF (p_element_type IN ('City_SUBJECT_WK', 'City_PSD_SUBJECT_WK', 'City_PSD_SUBJECT_RS') ) THEN
456: hr_utility.set_location(c_proc, 44);
457: l_jurisdiction_code := substr(g_city_jd,1,3) || '000' || substr(g_city_jd,7,5);
458: OPEN csr_chk_taxability ('CITY', l_jurisdiction_code);
459: FETCH csr_chk_taxability INTO l_taxable;
460: -- If the above query returns no rows then check the state level taxablility rule

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

586:
587: /* End of code for school district taxes. */
588:
589: ELSIF (p_element_type IN ('County_SUBJECT_WK')) THEN
590: hr_utility.set_location(c_proc, 45);
591: OPEN csr_chk_taxability ('COUNTY', g_county_jd);
592: FETCH csr_chk_taxability INTO l_taxable;
593: -- If the above query returns no rows then check the state level taxablility rule
594: -- as we are checking for SUBJ whable here. If we don't find a row for locality

Line 635: hr_utility.set_location(c_proc, 46);

631: saved for FIT_SUBJECT and EIC_SUBJECT and this resulted in
632: Bug#11652231*/
633:
634: ELSIF (p_element_type IN ('FIT_SUBJECT')) THEN
635: hr_utility.set_location(c_proc, 46);
636: OPEN csr_chk_fed_taxability ('FIT');
637: FETCH csr_chk_fed_taxability INTO l_taxable;
638: CLOSE csr_chk_fed_taxability;
639:

Line 641: hr_utility.set_location(c_proc, 47);

637: FETCH csr_chk_fed_taxability INTO l_taxable;
638: CLOSE csr_chk_fed_taxability;
639:
640: ELSIF (p_element_type IN ('EIC_SUBJECT')) THEN
641: hr_utility.set_location(c_proc, 47);
642: OPEN csr_chk_fed_taxability ('EIC');
643: FETCH csr_chk_fed_taxability INTO l_taxable;
644: CLOSE csr_chk_fed_taxability;
645: /*Changes for Bug 11652231 Ends*/

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

645: /*Changes for Bug 11652231 Ends*/
646: END IF;
647:
648: ELSIF (p_input_name = 'Subj NWhable') THEN
649: hr_utility.set_location(c_proc, 50);
650:
651: IF (p_element_type = ('SIT_SUBJECT_WK') ) THEN
652: hr_utility.set_location(c_proc, 51);
653: OPEN csr_chk_taxability ('NW_SIT', g_state_jd);

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

648: ELSIF (p_input_name = 'Subj NWhable') THEN
649: hr_utility.set_location(c_proc, 50);
650:
651: IF (p_element_type = ('SIT_SUBJECT_WK') ) THEN
652: hr_utility.set_location(c_proc, 51);
653: OPEN csr_chk_taxability ('NW_SIT', g_state_jd);
654: FETCH csr_chk_taxability INTO l_taxable;
655: CLOSE csr_chk_taxability;
656:

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

654: FETCH csr_chk_taxability INTO l_taxable;
655: CLOSE csr_chk_taxability;
656:
657: ELSIF (p_element_type = ('City_SUBJECT_WK') ) THEN
658: hr_utility.set_location(c_proc, 52);
659: l_jurisdiction_code := substr(g_city_jd,1,3) || '000' || substr(g_city_jd,7,5);
660: OPEN csr_chk_taxability ('NW_CITY', l_jurisdiction_code);
661: FETCH csr_chk_taxability INTO l_taxable;
662: -- If the above query returns no rows then check the state level taxablility rule

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

692: CLOSE csr_chk_taxability;
693: END IF;
694:
695: ELSIF (p_element_type IN ('County_SUBJECT_WK')) THEN
696: hr_utility.set_location(c_proc, 53);
697: OPEN csr_chk_taxability ('NW_COUNTY', g_county_jd);
698: FETCH csr_chk_taxability INTO l_taxable;
699: -- If the above query returns no rows then check the state level taxablility rule
700: -- as we are checking for SUBJ Nwhable here. If we don't find a row for locality

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

828:
829: END IF;
830:
831: ELSE
832: hr_utility.set_location(c_proc, 60);
833: -- otherwise we do not need to check taxability_rules
834: -- in order to set the value of the input value,
835: -- NB. that this step gets executed for tax elements like FIT, Medicare
836: -- as well as Tax balance elements like SUI_SUBJECT_EE

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

838: END IF;
839:
840: ELSE
841: -- an Earnings Element so no taxability rules
842: hr_utility.set_location(c_proc, 70);
843:
844: l_taxable := 'Y';
845:
846: END IF;

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

846: END IF;
847:
848:
849: IF (l_taxable = 'Y') THEN
850: hr_utility.set_location (c_proc, 200);
851:
852: p_iv_tbl(p_row) := l_input_value_id;
853: p_iv_names_tbl(p_row) := p_input_name;
854: p_ev_tbl(p_row) := p_entry_value;

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

946: /** stub - find an apppriate error message **/
947: IF (l_futa_wage_limit IS NULL OR
948: l_ss_ee_wage_limit IS NULL OR
949: l_ss_er_wage_limit IS NULL) THEN
950: hr_utility.set_location(c_proc, 10);
951: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
952: hr_utility.raise_error;
953: END IF;
954:

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

947: IF (l_futa_wage_limit IS NULL OR
948: l_ss_ee_wage_limit IS NULL OR
949: l_ss_er_wage_limit IS NULL) THEN
950: hr_utility.set_location(c_proc, 10);
951: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
952: hr_utility.raise_error;
953: END IF;
954:
955:

Line 952: hr_utility.raise_error;

948: l_ss_ee_wage_limit IS NULL OR
949: l_ss_er_wage_limit IS NULL) THEN
950: hr_utility.set_location(c_proc, 10);
951: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
952: hr_utility.raise_error;
953: END IF;
954:
955:
956: /*

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

1228: p_assignment_id => p_assignment_id,
1229: p_virtual_date => l_virtual_adjustment_date); --Bug3697701
1230: ELSE
1231: /** stub - find appropriate message **/
1232: hr_utility.set_location(c_proc, 10);
1233: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
1234: hr_utility.raise_error;
1235:
1236: END IF;

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

1229: p_virtual_date => l_virtual_adjustment_date); --Bug3697701
1230: ELSE
1231: /** stub - find appropriate message **/
1232: hr_utility.set_location(c_proc, 10);
1233: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
1234: hr_utility.raise_error;
1235:
1236: END IF;
1237:

Line 1234: hr_utility.raise_error;

1230: ELSE
1231: /** stub - find appropriate message **/
1232: hr_utility.set_location(c_proc, 10);
1233: hr_utility.set_message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
1234: hr_utility.raise_error;
1235:
1236: END IF;
1237:
1238:

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

1240: ** generic block, applies to all limit processing
1241: ** Excess is never passed or adjusted as it is a derived balance
1242: */
1243:
1244: hr_utility.trace('P_earn_amount='||to_char(p_earn_amount));
1245: hr_utility.trace('subject balance = ' || to_char(l_limit_subject_bal));
1246:
1247: IF ((l_old_taxable_bal + p_earn_amount) <= l_limit) THEN
1248:

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

1241: ** Excess is never passed or adjusted as it is a derived balance
1242: */
1243:
1244: hr_utility.trace('P_earn_amount='||to_char(p_earn_amount));
1245: hr_utility.trace('subject balance = ' || to_char(l_limit_subject_bal));
1246:
1247: IF ((l_old_taxable_bal + p_earn_amount) <= l_limit) THEN
1248:
1249: /*

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

1354: ** EV amount of TAXABLE IV will cause limit to be exceeded,
1355: ** set EV amount up to limit
1356: */
1357:
1358: hr_utility.trace('in the elsif l_old_tax_amount + p_earn_amount > 0');
1359:
1360: l_adj_amt := l_limit - l_old_taxable_bal;
1361: hr_utility.trace('l_adj_amt = '||to_char(l_adj_amt));
1362:

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

1357:
1358: hr_utility.trace('in the elsif l_old_tax_amount + p_earn_amount > 0');
1359:
1360: l_adj_amt := l_limit - l_old_taxable_bal;
1361: hr_utility.trace('l_adj_amt = '||to_char(l_adj_amt));
1362:
1363: l_excess := (p_earn_amount + l_old_taxable_bal) - l_limit;
1364: hr_utility.trace('l_excess ='|| to_char(l_excess));
1365: /*

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

1360: l_adj_amt := l_limit - l_old_taxable_bal;
1361: hr_utility.trace('l_adj_amt = '||to_char(l_adj_amt));
1362:
1363: l_excess := (p_earn_amount + l_old_taxable_bal) - l_limit;
1364: hr_utility.trace('l_excess ='|| to_char(l_excess));
1365: /*
1366: ** modify EV amount of TAXABLE IV before BA processing,
1367: ** set EV amount up to limit, remainder goes INTO excess
1368: */

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

1467: /* Bug#9796821 - Ends */
1468:
1469: BEGIN
1470:
1471: hr_utility.trace('IN Process_element Element_type ='||p_element_type);
1472: HR_Utility.trace('Abbrev Element Type ='||p_abbrev_element_type);
1473:
1474: hr_utility.set_location(c_proc, 10);
1475: OPEN csr_element;

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

1468:
1469: BEGIN
1470:
1471: hr_utility.trace('IN Process_element Element_type ='||p_element_type);
1472: HR_Utility.trace('Abbrev Element Type ='||p_abbrev_element_type);
1473:
1474: hr_utility.set_location(c_proc, 10);
1475: OPEN csr_element;
1476: FETCH csr_element INTO l_element;

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

1470:
1471: hr_utility.trace('IN Process_element Element_type ='||p_element_type);
1472: HR_Utility.trace('Abbrev Element Type ='||p_abbrev_element_type);
1473:
1474: hr_utility.set_location(c_proc, 10);
1475: OPEN csr_element;
1476: FETCH csr_element INTO l_element;
1477: CLOSE csr_element;
1478:

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

1476: FETCH csr_element INTO l_element;
1477: CLOSE csr_element;
1478:
1479: IF (l_element.element_type_id IS NULL) THEN
1480: hr_utility.set_location(c_proc, 20);
1481: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
1482: hr_utility.raise_error;
1483: END IF;
1484:

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

1477: CLOSE csr_element;
1478:
1479: IF (l_element.element_type_id IS NULL) THEN
1480: hr_utility.set_location(c_proc, 20);
1481: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
1482: hr_utility.raise_error;
1483: END IF;
1484:
1485: hr_utility.set_location(c_proc, 30);

Line 1482: hr_utility.raise_error;

1478:
1479: IF (l_element.element_type_id IS NULL) THEN
1480: hr_utility.set_location(c_proc, 20);
1481: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
1482: hr_utility.raise_error;
1483: END IF;
1484:
1485: hr_utility.set_location(c_proc, 30);
1486: l_ele_link_id := hr_entry_api.get_link(

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

1481: hr_utility.set_message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
1482: hr_utility.raise_error;
1483: END IF;
1484:
1485: hr_utility.set_location(c_proc, 30);
1486: l_ele_link_id := hr_entry_api.get_link(
1487: p_assignment_id => p_assignment_id,
1488: p_element_type_id => l_element.element_type_id,
1489: p_session_date => p_adjustment_date);

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

1488: p_element_type_id => l_element.element_type_id,
1489: p_session_date => p_adjustment_date);
1490:
1491: IF (l_ele_link_id IS NULL) THEN
1492: hr_utility.set_location(c_proc, 40);
1493: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1494: hr_utility.set_message_token ('ELEMENT', p_element_type);
1495: hr_utility.raise_error;
1496: END IF;

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

1489: p_session_date => p_adjustment_date);
1490:
1491: IF (l_ele_link_id IS NULL) THEN
1492: hr_utility.set_location(c_proc, 40);
1493: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1494: hr_utility.set_message_token ('ELEMENT', p_element_type);
1495: hr_utility.raise_error;
1496: END IF;
1497:

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

1490:
1491: IF (l_ele_link_id IS NULL) THEN
1492: hr_utility.set_location(c_proc, 40);
1493: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1494: hr_utility.set_message_token ('ELEMENT', p_element_type);
1495: hr_utility.raise_error;
1496: END IF;
1497:
1498: -- initialize tables

Line 1495: hr_utility.raise_error;

1491: IF (l_ele_link_id IS NULL) THEN
1492: hr_utility.set_location(c_proc, 40);
1493: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1494: hr_utility.set_message_token ('ELEMENT', p_element_type);
1495: hr_utility.raise_error;
1496: END IF;
1497:
1498: -- initialize tables
1499: l_iv_names_tbl := g_dummy_varchar_tbl;

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

1503:
1504: -- explicitly set the various input values,
1505: -- this clearly identifies which input values are expected and will cause failure
1506: -- if the input value has been deleted somehow
1507: hr_utility.set_location(c_proc, 50);
1508:
1509: IF (l_element.classification_name IN ('Earnings', 'Imputed Earnings',
1510: 'Supplemental Earnings')) THEN
1511: -- element is an Earnings element,

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

1520: p_bg_id, p_adjustment_date,
1521: 'Pay Value', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1522:
1523: ELSIF (p_element_type IN ('FIT')) THEN
1524: hr_utility.set_location (c_proc, 60);
1525: process_input(p_element_type, l_element.element_type_id,
1526: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1527: p_bg_id, p_adjustment_date,
1528: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);

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

1534: 'Supp Tax', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1535: END IF;
1536: -- 4188782
1537: ELSIF (p_element_type IN ('FSP_SUBJECT')) THEN
1538: hr_utility.set_location (c_proc, 62);
1539: process_input(p_element_type, l_element.element_type_id,
1540: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1541: p_bg_id, p_adjustment_date,
1542: 'Reduced Subj Whable',

Line 1547: hr_utility.set_location (c_proc, 63);

1543: fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1544: /*Added for Bug#9872952*/
1545: ELSIF (p_element_type IN ('FIT_SUBJECT','EIC_SUBJECT','SS_SUBJECT_EE','SS_SUBJECT_ER',
1546: 'MEDICARE_SUBJECT_EE','MEDICARE_SUBJECT_ER','FUTA_SUBJECT')) THEN
1547: hr_utility.set_location (c_proc, 63);
1548: process_input(p_element_type, l_element.element_type_id,
1549: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1550: p_bg_id, p_adjustment_date,
1551: 'Gross',

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

1557: 'Subj Whable',
1558: fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1559: /*End Bug#9872952*/
1560: ELSIF (p_element_type IN ('FIT 3rd Party')) THEN
1561: hr_utility.set_location (c_proc, 65);
1562: process_input(p_element_type, l_element.element_type_id,
1563: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1564: p_bg_id, p_adjustment_date,
1565: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);

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

1564: p_bg_id, p_adjustment_date,
1565: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1566:
1567: ELSIF (p_element_type IN ('SS_EE', 'Medicare_EE')) THEN
1568: hr_utility.set_location(c_proc, 71);
1569: IF (p_adj_amount <> 0) THEN
1570: process_input(p_element_type, l_element.element_type_id,
1571: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1572: p_bg_id, p_adjustment_date,

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

1572: p_bg_id, p_adjustment_date,
1573: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1574: END IF;
1575:
1576: hr_utility.set_location(c_proc, 72);
1577: process_input(p_element_type, l_element.element_type_id,
1578: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1579: p_bg_id, p_adjustment_date,
1580: 'TAXABLE', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);

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

1621: p_jurisdiction,p_tax_unit_id,p_adjustment_date);
1622: END IF;
1623:
1624: ELSIF (p_element_type IN ('SIT_WK')) THEN
1625: hr_utility.set_location(c_proc, 81);
1626:
1627: process_input(p_element_type, l_element.element_type_id,
1628: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1629: p_bg_id, p_adjustment_date,

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

1627: process_input(p_element_type, l_element.element_type_id,
1628: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1629: p_bg_id, p_adjustment_date,
1630: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1631: hr_utility.set_location(c_proc, 82);
1632:
1633: process_input(p_element_type, l_element.element_type_id,
1634: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1635: p_bg_id, p_adjustment_date,

Line 1646: hr_utility.set_location (c_proc, 84);

1642: 'Supp Tax', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1643: END IF;
1644:
1645: ELSIF (p_element_type IN ('SIT_WK_NON_AGGREGATE_RED_SUBJ_WHABLE')) THEN
1646: hr_utility.set_location (c_proc, 84);
1647: process_input(p_element_type, l_element.element_type_id,
1648: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1649: p_bg_id, p_adjustment_date,
1650: 'SuppGross',

Line 1659: hr_utility.set_location (c_proc, 84);

1655: p_bg_id, p_adjustment_date,
1656: 'Jurisdiction', p_jurisdiction, l_num_ev);
1657:
1658: ELSIF (p_element_type IN ('FIT_NON_AGGREGATE_RED_SUBJ_WHABLE')) THEN
1659: hr_utility.set_location (c_proc, 84);
1660: process_input(p_element_type, l_element.element_type_id,
1661: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1662: p_bg_id, p_adjustment_date,
1663: 'SuppGross',

Line 1671: hr_utility.set_location(c_proc, 86);

1667: /*
1668: ** new tax element to be processed, use SIT_WK as a template
1669: */
1670: ELSIF (p_element_type IN ('County_SC_WK', 'City_PSD_SC_RS')) THEN
1671: hr_utility.set_location(c_proc, 86);
1672:
1673: process_input(p_element_type, l_element.element_type_id,
1674: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1675: p_bg_id, p_adjustment_date,

Line 1677: hr_utility.set_location(c_proc, 87);

1673: process_input(p_element_type, l_element.element_type_id,
1674: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1675: p_bg_id, p_adjustment_date,
1676: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1677: hr_utility.set_location(c_proc, 87);
1678:
1679:
1680: /*
1681: ** can't put the Gross for the BA INTO the Gross for the school district tax,

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

1686: p_bg_id, p_adjustment_date,
1687: 'Jurisdiction', p_jurisdiction, l_num_ev);
1688:
1689: ELSIF (p_element_type IN ('SUI_EE', 'SDI_EE', 'SDI1_EE')) THEN
1690: hr_utility.set_location(c_proc, 91);
1691:
1692: IF (p_adj_amount <> 0) THEN
1693: process_input(p_element_type, l_element.element_type_id,
1694: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,

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

1693: process_input(p_element_type, l_element.element_type_id,
1694: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1695: p_bg_id, p_adjustment_date,
1696: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1697: hr_utility.set_location(c_proc, 915);
1698: END IF;
1699:
1700: hr_utility.set_location(c_proc, 92);
1701:

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

1696: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1697: hr_utility.set_location(c_proc, 915);
1698: END IF;
1699:
1700: hr_utility.set_location(c_proc, 92);
1701:
1702: if p_element_type = 'SDI1_EE' then
1703: process_input(p_element_type, l_element.element_type_id,
1704: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,

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

1713: fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1714: end if;
1715:
1716:
1717: hr_utility.set_location(c_proc, 93);
1718:
1719: process_input(p_element_type, l_element.element_type_id,
1720: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1721: p_bg_id, p_adjustment_date,

Line 1734: hr_utility.set_location (c_proc, 94);

1730:
1731: /* Bug 12694875 starts */
1732: -- Extract the value of SUI EE Taxable amount from Pl/sql table
1733: IF (p_element_type = 'SUI_EE') THEN
1734: hr_utility.set_location (c_proc, 94);
1735: FOR i IN 1..(l_num_ev - 1) LOOP
1736: IF l_iv_names_tbl(i) = 'TAXABLE' THEN
1737: g_sui_ee_tax_adj_amt := l_ev_tbl(i);
1738: END IF;

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

1740: END IF;
1741: /* Bug 12694875 ends */
1742:
1743: ELSIF (p_element_type IN ('City_WK', 'County_WK', 'City_PSD_WK', 'City_PSD_RS')) THEN
1744: hr_utility.set_location(c_proc, 101);
1745:
1746: process_input(p_element_type, l_element.element_type_id,
1747: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1748: p_bg_id, p_adjustment_date,

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

1746: process_input(p_element_type, l_element.element_type_id,
1747: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1748: p_bg_id, p_adjustment_date,
1749: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1750: hr_utility.set_location(c_proc, 102);
1751:
1752: process_input(p_element_type, l_element.element_type_id,
1753: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1754: p_bg_id, p_adjustment_date,

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

1756:
1757: ELSIF (p_element_type IN ('SIT_SUBJECT_WK', 'City_SUBJECT_WK',
1758: 'County_SUBJECT_WK', 'School_SUBJECT_WK',
1759: 'City_PSD_SUBJECT_WK', 'City_PSD_SUBJECT_RS')) THEN
1760: hr_utility.set_location(c_proc, 111);
1761:
1762: process_input(p_element_type, l_element.element_type_id,
1763: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1764: p_bg_id, p_adjustment_date,

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

1762: process_input(p_element_type, l_element.element_type_id,
1763: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1764: p_bg_id, p_adjustment_date,
1765: 'Jurisdiction', p_jurisdiction, l_num_ev);
1766: hr_utility.set_location(c_proc, 112);
1767:
1768: IF (p_element_type not in ( 'City_PSD_SUBJECT_WK', 'City_PSD_SUBJECT_RS' )) THEN
1769:
1770: process_input(p_element_type, l_element.element_type_id,

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

1770: process_input(p_element_type, l_element.element_type_id,
1771: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1772: p_bg_id, p_adjustment_date,
1773: 'Gross', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1774: hr_utility.set_location(c_proc, 113);
1775: END IF;
1776:
1777: process_input(p_element_type, l_element.element_type_id,
1778: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,

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

1777: process_input(p_element_type, l_element.element_type_id,
1778: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1779: p_bg_id, p_adjustment_date,
1780: 'Subj Whable', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1781: hr_utility.set_location(c_proc, 114);
1782:
1783: IF (g_classification IN ('Imputed Earnings',
1784: 'Supplemental Earnings')
1785: AND p_element_type NOT IN ('City_PSD_SUBJECT_WK', 'City_PSD_SUBJECT_RS' )) THEN

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

1782:
1783: IF (g_classification IN ('Imputed Earnings',
1784: 'Supplemental Earnings')
1785: AND p_element_type NOT IN ('City_PSD_SUBJECT_WK', 'City_PSD_SUBJECT_RS' )) THEN
1786: hr_utility.set_location(c_proc, 115);
1787:
1788: process_input (p_element_type, l_element.element_type_id,
1789: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1790: p_bg_id, p_adjustment_date,

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

1792: END IF;
1793:
1794: ELSIF (p_element_type IN ('SDI_SUBJECT_EE', 'SDI_SUBJECT_ER',
1795: 'SUI_SUBJECT_EE', 'SUI_SUBJECT_ER')) THEN
1796: hr_utility.set_location(c_proc, 121);
1797:
1798: process_input(p_element_type, l_element.element_type_id,
1799: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1800: p_bg_id, p_adjustment_date,

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

1798: process_input(p_element_type, l_element.element_type_id,
1799: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1800: p_bg_id, p_adjustment_date,
1801: 'Jurisdiction', p_jurisdiction, l_num_ev);
1802: hr_utility.set_location(c_proc, 122);
1803:
1804: process_input(p_element_type, l_element.element_type_id,
1805: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1806: p_bg_id, p_adjustment_date,

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

1804: process_input(p_element_type, l_element.element_type_id,
1805: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1806: p_bg_id, p_adjustment_date,
1807: 'Gross', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1808: hr_utility.set_location(c_proc, 123);
1809:
1810: process_input(p_element_type, l_element.element_type_id,
1811: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1812: p_bg_id, p_adjustment_date,

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

1812: p_bg_id, p_adjustment_date,
1813: 'Subj Whable', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1814:
1815: ELSIF (p_element_type IN ('SUI_ER', 'SDI_ER')) THEN
1816: hr_utility.set_location (c_proc, 124);
1817:
1818:
1819: /** sbilling **/
1820: /*

Line 1851: hr_utility.set_location (c_proc, 125);

1847:
1848: /* Bug 12694875 starts */
1849: -- Extract the value of SUI ER Taxable amount from Pl/sql table
1850: IF (p_element_type = 'SUI_ER') THEN
1851: hr_utility.set_location (c_proc, 125);
1852: FOR i IN 1..(l_num_ev - 1) LOOP
1853: IF l_iv_names_tbl(i) = 'TAXABLE' THEN
1854: g_sui_er_tax_adj_amt := l_ev_tbl(i);
1855: END IF;

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

1864:
1865:
1866: -- set mandatory input values,
1867: -- cannot set these to NULL, core package expects mandatory values to be entered
1868: hr_utility.set_location(c_proc, 130);
1869:
1870: FOR l_req_input IN csr_set_mandatory_inputs (l_element.element_type_id) LOOP
1871: -- first, check if the mandatory input value was explicitly
1872: -- set above, do nothing in this case

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

1869:
1870: FOR l_req_input IN csr_set_mandatory_inputs (l_element.element_type_id) LOOP
1871: -- first, check if the mandatory input value was explicitly
1872: -- set above, do nothing in this case
1873: hr_utility.set_location(c_proc, 140);
1874:
1875: FOR l_counter IN 1..l_num_ev LOOP
1876:
1877: IF (l_req_input.input_name = l_iv_names_tbl(l_counter)) THEN

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

1878: NULL;
1879: ELSE
1880: -- then the input value was not previously set by one of the
1881: -- process_inputs called in process_elements
1882: hr_utility.set_location(c_proc, 150);
1883: l_num_ev := l_num_ev + 1;
1884:
1885: l_iv_tbl(l_num_ev) := l_req_input.input_value_id;
1886: l_iv_names_tbl(l_num_ev) := l_req_input.input_name;

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

1889:
1890: END LOOP;
1891: END LOOP;
1892:
1893: hr_utility.set_location(c_proc, 160);
1894:
1895: pay_bal_adjust.adjust_balance(p_batch_id => p_payroll_action_id,
1896: p_assignment_id => p_assignment_id,
1897: p_element_link_id => l_ele_link_id,

Line 1921: hr_utility.trace('Error while getting Medicare Taxability rule');

1917: EXCEPTION
1918: WHEN NO_DATA_FOUND THEN
1919: l_medicare_taxability := 'N';
1920: WHEN OTHERS THEN
1921: hr_utility.trace('Error while getting Medicare Taxability rule');
1922: hr_utility.set_location(c_proc, 210);
1923: hr_utility.raise_error;
1924: END;
1925: END IF;

Line 1922: hr_utility.set_location(c_proc, 210);

1918: WHEN NO_DATA_FOUND THEN
1919: l_medicare_taxability := 'N';
1920: WHEN OTHERS THEN
1921: hr_utility.trace('Error while getting Medicare Taxability rule');
1922: hr_utility.set_location(c_proc, 210);
1923: hr_utility.raise_error;
1924: END;
1925: END IF;
1926: END IF;

Line 1923: hr_utility.raise_error;

1919: l_medicare_taxability := 'N';
1920: WHEN OTHERS THEN
1921: hr_utility.trace('Error while getting Medicare Taxability rule');
1922: hr_utility.set_location(c_proc, 210);
1923: hr_utility.raise_error;
1924: END;
1925: END IF;
1926: END IF;
1927:

Line 1943: hr_utility.trace('Error while getting Medicare Limit');

1939: WHERE pft.fed_information_category = '401K LIMITS'
1940: AND p_adjustment_date BETWEEN pft.effective_start_date AND pft.effective_end_date;
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: hr_utility.trace('Error while getting Medicare Limit');
1944: hr_utility.set_location(c_proc, 220);
1945: hr_utility.raise_error;
1946: END;
1947:

Line 1944: hr_utility.set_location(c_proc, 220);

1940: AND p_adjustment_date BETWEEN pft.effective_start_date AND pft.effective_end_date;
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: hr_utility.trace('Error while getting Medicare Limit');
1944: hr_utility.set_location(c_proc, 220);
1945: hr_utility.raise_error;
1946: END;
1947:
1948: /* If Medicare EE Taxable YTD wages is already greater than the Medi EE limit or

Line 1945: hr_utility.raise_error;

1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: hr_utility.trace('Error while getting Medicare Limit');
1944: hr_utility.set_location(c_proc, 220);
1945: hr_utility.raise_error;
1946: END;
1947:
1948: /* If Medicare EE Taxable YTD wages is already greater than the Medi EE limit or
1949: if it crosses the limit with this Balance Adjustment */

Line 1950: hr_utility.trace('g_medicare_ee_taxable: ' || g_medicare_ee_taxable);

1946: END;
1947:
1948: /* If Medicare EE Taxable YTD wages is already greater than the Medi EE limit or
1949: if it crosses the limit with this Balance Adjustment */
1950: hr_utility.trace('g_medicare_ee_taxable: ' || g_medicare_ee_taxable);
1951: hr_utility.trace('l_medi_ee_limit1: ' || l_medi_ee_limit1);
1952: hr_utility.trace('p_earn_amount: ' || p_earn_amount);
1953:
1954: IF (g_medicare_ee_taxable > l_medi_ee_limit1 OR

Line 1951: hr_utility.trace('l_medi_ee_limit1: ' || l_medi_ee_limit1);

1947:
1948: /* If Medicare EE Taxable YTD wages is already greater than the Medi EE limit or
1949: if it crosses the limit with this Balance Adjustment */
1950: hr_utility.trace('g_medicare_ee_taxable: ' || g_medicare_ee_taxable);
1951: hr_utility.trace('l_medi_ee_limit1: ' || l_medi_ee_limit1);
1952: hr_utility.trace('p_earn_amount: ' || p_earn_amount);
1953:
1954: IF (g_medicare_ee_taxable > l_medi_ee_limit1 OR
1955: g_medicare_ee_taxable + p_earn_amount > l_medi_ee_limit1) THEN

Line 1952: hr_utility.trace('p_earn_amount: ' || p_earn_amount);

1948: /* If Medicare EE Taxable YTD wages is already greater than the Medi EE limit or
1949: if it crosses the limit with this Balance Adjustment */
1950: hr_utility.trace('g_medicare_ee_taxable: ' || g_medicare_ee_taxable);
1951: hr_utility.trace('l_medi_ee_limit1: ' || l_medi_ee_limit1);
1952: hr_utility.trace('p_earn_amount: ' || p_earn_amount);
1953:
1954: IF (g_medicare_ee_taxable > l_medi_ee_limit1 OR
1955: g_medicare_ee_taxable + p_earn_amount > l_medi_ee_limit1) THEN
1956: /* Get the Element ID and TAXABLE Input Value ID of Medicare_EE_Over_Limit */

Line 1973: hr_utility.trace('Error While Getting Element details for Medicare_EE_Over_Limit');

1969: AND piv.legislation_code = 'US'
1970: AND p_adjustment_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
1971: EXCEPTION
1972: WHEN OTHERS THEN
1973: hr_utility.trace('Error While Getting Element details for Medicare_EE_Over_Limit');
1974: hr_utility.set_location(c_proc, 230);
1975: hr_utility.raise_error;
1976: END;
1977:

Line 1974: hr_utility.set_location(c_proc, 230);

1970: AND p_adjustment_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
1971: EXCEPTION
1972: WHEN OTHERS THEN
1973: hr_utility.trace('Error While Getting Element details for Medicare_EE_Over_Limit');
1974: hr_utility.set_location(c_proc, 230);
1975: hr_utility.raise_error;
1976: END;
1977:
1978: /* Get Element Link ID */

Line 1975: hr_utility.raise_error;

1971: EXCEPTION
1972: WHEN OTHERS THEN
1973: hr_utility.trace('Error While Getting Element details for Medicare_EE_Over_Limit');
1974: hr_utility.set_location(c_proc, 230);
1975: hr_utility.raise_error;
1976: END;
1977:
1978: /* Get Element Link ID */
1979: l_ele_link_id := hr_entry_api.get_link(

Line 1985: hr_utility.trace('Error While Getting Element Link details for Medicare_EE_Over_Limit');

1981: p_element_type_id => l_element_type_id,
1982: p_session_date => p_adjustment_date);
1983:
1984: IF (l_ele_link_id IS NULL) THEN
1985: hr_utility.trace('Error While Getting Element Link details for Medicare_EE_Over_Limit');
1986: hr_utility.set_location(c_proc, 240);
1987: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1988: hr_utility.set_message_token ('ELEMENT', 'Medicare_EE_Over_Limit');
1989: hr_utility.raise_error;

Line 1986: hr_utility.set_location(c_proc, 240);

1982: p_session_date => p_adjustment_date);
1983:
1984: IF (l_ele_link_id IS NULL) THEN
1985: hr_utility.trace('Error While Getting Element Link details for Medicare_EE_Over_Limit');
1986: hr_utility.set_location(c_proc, 240);
1987: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1988: hr_utility.set_message_token ('ELEMENT', 'Medicare_EE_Over_Limit');
1989: hr_utility.raise_error;
1990: END IF;

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

1983:
1984: IF (l_ele_link_id IS NULL) THEN
1985: hr_utility.trace('Error While Getting Element Link details for Medicare_EE_Over_Limit');
1986: hr_utility.set_location(c_proc, 240);
1987: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1988: hr_utility.set_message_token ('ELEMENT', 'Medicare_EE_Over_Limit');
1989: hr_utility.raise_error;
1990: END IF;
1991:

Line 1988: hr_utility.set_message_token ('ELEMENT', 'Medicare_EE_Over_Limit');

1984: IF (l_ele_link_id IS NULL) THEN
1985: hr_utility.trace('Error While Getting Element Link details for Medicare_EE_Over_Limit');
1986: hr_utility.set_location(c_proc, 240);
1987: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1988: hr_utility.set_message_token ('ELEMENT', 'Medicare_EE_Over_Limit');
1989: hr_utility.raise_error;
1990: END IF;
1991:
1992: /* If Medicare EE Taxable YTD wages is already greater than the Medi EE limit */

Line 1989: hr_utility.raise_error;

1985: hr_utility.trace('Error While Getting Element Link details for Medicare_EE_Over_Limit');
1986: hr_utility.set_location(c_proc, 240);
1987: hr_utility.set_message(801, 'PY_51132_TXADJ_LINK_MISSING');
1988: hr_utility.set_message_token ('ELEMENT', 'Medicare_EE_Over_Limit');
1989: hr_utility.raise_error;
1990: END IF;
1991:
1992: /* If Medicare EE Taxable YTD wages is already greater than the Medi EE limit */
1993: IF g_medicare_ee_taxable > l_medi_ee_limit1 THEN

Line 2015: hr_utility.trace('Element_link_id: ' || l_ele_link_id);

2011: l_iv_tbl(l_num_ev) := l_input_value_id;
2012: l_iv_names_tbl(l_num_ev) := 'TAXABLE';
2013: l_ev_tbl(l_num_ev) := l_value;
2014:
2015: hr_utility.trace('Element_link_id: ' || l_ele_link_id);
2016: hr_utility.trace('l_iv_tbl(l_num_ev): ' || l_iv_tbl(l_num_ev));
2017: hr_utility.trace('l_iv_names_tbl(l_num_ev): ' || l_iv_names_tbl(l_num_ev));
2018: hr_utility.trace('l_ev_tbl(l_num_ev): ' || l_ev_tbl(l_num_ev));
2019:

Line 2016: hr_utility.trace('l_iv_tbl(l_num_ev): ' || l_iv_tbl(l_num_ev));

2012: l_iv_names_tbl(l_num_ev) := 'TAXABLE';
2013: l_ev_tbl(l_num_ev) := l_value;
2014:
2015: hr_utility.trace('Element_link_id: ' || l_ele_link_id);
2016: hr_utility.trace('l_iv_tbl(l_num_ev): ' || l_iv_tbl(l_num_ev));
2017: hr_utility.trace('l_iv_names_tbl(l_num_ev): ' || l_iv_names_tbl(l_num_ev));
2018: hr_utility.trace('l_ev_tbl(l_num_ev): ' || l_ev_tbl(l_num_ev));
2019:
2020: /* Call the Balance Routine to create Element Entry Values and Run Results */

Line 2017: hr_utility.trace('l_iv_names_tbl(l_num_ev): ' || l_iv_names_tbl(l_num_ev));

2013: l_ev_tbl(l_num_ev) := l_value;
2014:
2015: hr_utility.trace('Element_link_id: ' || l_ele_link_id);
2016: hr_utility.trace('l_iv_tbl(l_num_ev): ' || l_iv_tbl(l_num_ev));
2017: hr_utility.trace('l_iv_names_tbl(l_num_ev): ' || l_iv_names_tbl(l_num_ev));
2018: hr_utility.trace('l_ev_tbl(l_num_ev): ' || l_ev_tbl(l_num_ev));
2019:
2020: /* Call the Balance Routine to create Element Entry Values and Run Results */
2021: pay_bal_adjust.adjust_balance(p_batch_id => p_payroll_action_id,

Line 2018: hr_utility.trace('l_ev_tbl(l_num_ev): ' || l_ev_tbl(l_num_ev));

2014:
2015: hr_utility.trace('Element_link_id: ' || l_ele_link_id);
2016: hr_utility.trace('l_iv_tbl(l_num_ev): ' || l_iv_tbl(l_num_ev));
2017: hr_utility.trace('l_iv_names_tbl(l_num_ev): ' || l_iv_names_tbl(l_num_ev));
2018: hr_utility.trace('l_ev_tbl(l_num_ev): ' || l_ev_tbl(l_num_ev));
2019:
2020: /* Call the Balance Routine to create Element Entry Values and Run Results */
2021: pay_bal_adjust.adjust_balance(p_batch_id => p_payroll_action_id,
2022: p_assignment_id => p_assignment_id,

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

2090:
2091: BEGIN
2092:
2093: IF (p_city_name IS NOT NULL AND p_zip_code IS NOT NULL) THEN
2094: hr_utility.set_location(c_proc, 10);
2095: l_geocode := hr_us_ff_udfs.addr_val(
2096: p_state_abbrev => p_state_abbrev,
2097: p_county_name => p_county_name,
2098: p_city_name => p_city_name,

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

2102: FETCH csr_chk_local INTO l_valid_for_asg;
2103: CLOSE csr_chk_local;
2104:
2105: IF (l_valid_for_asg = 'FAIL') THEN
2106: hr_utility.set_location(c_proc, 15);
2107: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2108: hr_utility.raise_error;
2109: END IF;
2110:

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

2103: CLOSE csr_chk_local;
2104:
2105: IF (l_valid_for_asg = 'FAIL') THEN
2106: hr_utility.set_location(c_proc, 15);
2107: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2108: hr_utility.raise_error;
2109: END IF;
2110:
2111: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN

Line 2108: hr_utility.raise_error;

2104:
2105: IF (l_valid_for_asg = 'FAIL') THEN
2106: hr_utility.set_location(c_proc, 15);
2107: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2108: hr_utility.raise_error;
2109: END IF;
2110:
2111: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN
2112: hr_utility.set_location(c_proc, 20);

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

2108: hr_utility.raise_error;
2109: END IF;
2110:
2111: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN
2112: hr_utility.set_location(c_proc, 20);
2113: OPEN csr_county_code;
2114: FETCH csr_county_code INTO l_state_code, l_county_code;
2115: CLOSE csr_county_code;
2116: l_geocode := l_state_code||'-'||l_county_code||'-0000';

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

2119: FETCH csr_chk_local INTO l_valid_for_asg;
2120: CLOSE csr_chk_local;
2121:
2122: IF (l_valid_for_asg = 'FAIL') THEN
2123: hr_utility.set_location(c_proc, 25);
2124: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2125: hr_utility.raise_error;
2126: END IF;
2127:

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

2120: CLOSE csr_chk_local;
2121:
2122: IF (l_valid_for_asg = 'FAIL') THEN
2123: hr_utility.set_location(c_proc, 25);
2124: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2125: hr_utility.raise_error;
2126: END IF;
2127:
2128: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN

Line 2125: hr_utility.raise_error;

2121:
2122: IF (l_valid_for_asg = 'FAIL') THEN
2123: hr_utility.set_location(c_proc, 25);
2124: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2125: hr_utility.raise_error;
2126: END IF;
2127:
2128: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN
2129: hr_utility.set_location(c_proc, 30);

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

2125: hr_utility.raise_error;
2126: END IF;
2127:
2128: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN
2129: hr_utility.set_location(c_proc, 30);
2130: OPEN csr_state_code;
2131: FETCH csr_state_code INTO l_state_code;
2132: CLOSE csr_state_code;
2133: l_geocode := l_state_code||'-000-0000';

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

2136: FETCH csr_chk_state INTO l_valid_for_asg;
2137: CLOSE csr_chk_state;
2138:
2139: IF (l_valid_for_asg = 'FAIL') THEN
2140: hr_utility.set_location(c_proc, 25);
2141: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2142: hr_utility.raise_error;
2143: END IF;
2144:

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

2137: CLOSE csr_chk_state;
2138:
2139: IF (l_valid_for_asg = 'FAIL') THEN
2140: hr_utility.set_location(c_proc, 25);
2141: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2142: hr_utility.raise_error;
2143: END IF;
2144:
2145: ELSE

Line 2142: hr_utility.raise_error;

2138:
2139: IF (l_valid_for_asg = 'FAIL') THEN
2140: hr_utility.set_location(c_proc, 25);
2141: hr_utility.set_message(801, 'PY_51133_TXADJ_INVALID_CITY');
2142: hr_utility.raise_error;
2143: END IF;
2144:
2145: ELSE
2146: l_geocode := '00-000-0000';

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

2877: BEGIN
2878:
2879: /* Bug 9545789 Added check for the correct tax_unit_id in the below query */
2880:
2881: hr_utility.set_location(c_proc, 5);
2882: SELECT a.assignment_id,
2883: a.business_group_id,
2884: a.payroll_id
2885: INTO l_assignment_id,

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

2902: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
2903: /* THIS ERROR is stating that the assignment does not exist
2904: AS OF the p_adjustment_date IN p_business_group_name AND IN p_tax_unit_id
2905: */
2906: hr_utility.set_message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');
2907: hr_utility.raise_error;
2908: END;
2909:
2910: -- get assignment derived jurisdiction geocode for state,county,city,zip code

Line 2907: hr_utility.raise_error;

2903: /* THIS ERROR is stating that the assignment does not exist
2904: AS OF the p_adjustment_date IN p_business_group_name AND IN p_tax_unit_id
2905: */
2906: hr_utility.set_message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');
2907: hr_utility.raise_error;
2908: END;
2909:
2910: -- get assignment derived jurisdiction geocode for state,county,city,zip code
2911: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,

Line 3104: hr_utility.set_location(c_proc, 7);

3100: SS ER Liability and SS ER Taxable.
3101: */
3102:
3103: BEGIN
3104: hr_utility.set_location(c_proc, 7);
3105: select defined_balance_id
3106: into l_ss_er_w11_def_bal_id
3107: from pay_balance_types bt,
3108: pay_balance_dimensions bd,

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

3130: l_sui_ee + l_sdi_ee + l_sdi1_ee + l_county + l_city +
3131: l_sch_dist_wh_ee;
3132:
3133: IF (l_gross_amount <> l_net_amount + l_total_taxes_withheld) THEN
3134: hr_utility.set_message(801, 'PY_51134_TXADJ_TAX_NET_TOT');
3135: hr_utility.raise_error;
3136: END IF;
3137:
3138: END IF;

Line 3135: hr_utility.raise_error;

3131: l_sch_dist_wh_ee;
3132:
3133: IF (l_gross_amount <> l_net_amount + l_total_taxes_withheld) THEN
3134: hr_utility.set_message(801, 'PY_51134_TXADJ_TAX_NET_TOT');
3135: hr_utility.raise_error;
3136: END IF;
3137:
3138: END IF;
3139:

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

3140:
3141: -- 2. check that if an earnings element is provided if Gross is non-zero
3142:
3143: IF (l_gross_amount <> 0 AND p_earning_element_type IS NULL) THEN
3144: hr_utility.set_message(801, 'PY_51140_TXADJ_EARN_ELE_REQ');
3145: hr_utility.raise_error;
3146: END IF;
3147:
3148:

Line 3145: hr_utility.raise_error;

3141: -- 2. check that if an earnings element is provided if Gross is non-zero
3142:
3143: IF (l_gross_amount <> 0 AND p_earning_element_type IS NULL) THEN
3144: hr_utility.set_message(801, 'PY_51140_TXADJ_EARN_ELE_REQ');
3145: hr_utility.raise_error;
3146: END IF;
3147:
3148:
3149: -- 3. check that SIT = 0 for Alaska, Florida, Nevada, New Hampshire, South Dakota,

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

3150: -- Tennessee, Texas, Washington, Wyoming, and the Virgin Islands
3151:
3152: IF ((l_sit <> 0) AND
3153: (tax_exists(l_jd_entered, 'SIT', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N')) THEN
3154: hr_utility.set_message(801, 'PY_51141_TXADJ_SIT_EXEMPT');
3155: hr_utility.raise_error;
3156: END IF;
3157:
3158: /* bug 1608907 */

Line 3155: hr_utility.raise_error;

3151:
3152: IF ((l_sit <> 0) AND
3153: (tax_exists(l_jd_entered, 'SIT', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N')) THEN
3154: hr_utility.set_message(801, 'PY_51141_TXADJ_SIT_EXEMPT');
3155: hr_utility.raise_error;
3156: END IF;
3157:
3158: /* bug 1608907 */
3159: IF ((l_county <> 0) AND

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

3157:
3158: /* bug 1608907 */
3159: IF ((l_county <> 0) AND
3160: (tax_exists(l_jd_entered, 'COUNTY', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N')) THEN
3161: hr_utility.set_message(801, 'PY_50980_TXADJ_COUNTY_EXEMPT');
3162: hr_utility.raise_error;
3163: END IF;
3164:
3165: IF ((l_city <> 0) AND

Line 3162: hr_utility.raise_error;

3158: /* bug 1608907 */
3159: IF ((l_county <> 0) AND
3160: (tax_exists(l_jd_entered, 'COUNTY', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N')) THEN
3161: hr_utility.set_message(801, 'PY_50980_TXADJ_COUNTY_EXEMPT');
3162: hr_utility.raise_error;
3163: END IF;
3164:
3165: IF ((l_city <> 0) AND
3166: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N')) THEN

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

3163: END IF;
3164:
3165: IF ((l_city <> 0) AND
3166: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N')) THEN
3167: hr_utility.set_message(801, 'PY_50981_TAXADJ_CITY_EXEMPT');
3168: hr_utility.raise_error;
3169: END IF;
3170:
3171: /* bug 1608907 */

Line 3168: hr_utility.raise_error;

3164:
3165: IF ((l_city <> 0) AND
3166: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N')) THEN
3167: hr_utility.set_message(801, 'PY_50981_TAXADJ_CITY_EXEMPT');
3168: hr_utility.raise_error;
3169: END IF;
3170:
3171: /* bug 1608907 */
3172:

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

3184: FETCH csr_sdi_check INTO l_primary_asg_state;
3185:
3186: IF csr_sdi_check%NOTFOUND THEN
3187: CLOSE csr_sdi_check;
3188: hr_utility.set_message(801, 'PY_51327_TXADJ_SDI_JD');
3189: hr_utility.raise_error;
3190: END IF;
3191:
3192: CLOSE csr_sdi_check;

Line 3189: hr_utility.raise_error;

3185:
3186: IF csr_sdi_check%NOTFOUND THEN
3187: CLOSE csr_sdi_check;
3188: hr_utility.set_message(801, 'PY_51327_TXADJ_SDI_JD');
3189: hr_utility.raise_error;
3190: END IF;
3191:
3192: CLOSE csr_sdi_check;
3193:

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

3195:
3196: IF ( l_sdi_ee <> 0) THEN
3197: --IF (p_state_abbrev NOT IN ('CA', 'HI', 'NJ', 'NY', 'RI')) THEN
3198: IF (tax_exists(l_jd_entered, 'SDI_EE', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N') THEN
3199: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
3200: hr_utility.raise_error;
3201: END IF;
3202:
3203: END IF;

Line 3200: hr_utility.raise_error;

3196: IF ( l_sdi_ee <> 0) THEN
3197: --IF (p_state_abbrev NOT IN ('CA', 'HI', 'NJ', 'NY', 'RI')) THEN
3198: IF (tax_exists(l_jd_entered, 'SDI_EE', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N') THEN
3199: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
3200: hr_utility.raise_error;
3201: END IF;
3202:
3203: END IF;
3204:

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

3204:
3205: IF ( l_sdi1_ee <> 0) THEN
3206: --IF (p_state_abbrev NOT IN ('CA', 'HI', 'NJ', 'NY', 'RI')) THEN
3207: IF (tax_exists(l_jd_entered, 'SDI1_EE', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N') THEN
3208: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
3209: hr_utility.raise_error;
3210: END IF;
3211:
3212: END IF;

Line 3209: hr_utility.raise_error;

3205: IF ( l_sdi1_ee <> 0) THEN
3206: --IF (p_state_abbrev NOT IN ('CA', 'HI', 'NJ', 'NY', 'RI')) THEN
3207: IF (tax_exists(l_jd_entered, 'SDI1_EE', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N') THEN
3208: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
3209: hr_utility.raise_error;
3210: END IF;
3211:
3212: END IF;
3213:

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

3213:
3214: IF ( l_sdi_er <> 0) THEN
3215: --IF (p_state_abbrev NOT IN ('NJ', 'NY')) THEN
3216: IF (tax_exists(l_jd_entered, 'SDI_ER', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N') THEN
3217: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
3218: hr_utility.raise_error;
3219: END IF;
3220:
3221: END IF;

Line 3218: hr_utility.raise_error;

3214: IF ( l_sdi_er <> 0) THEN
3215: --IF (p_state_abbrev NOT IN ('NJ', 'NY')) THEN
3216: IF (tax_exists(l_jd_entered, 'SDI_ER', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N') THEN
3217: hr_utility.set_message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
3218: hr_utility.raise_error;
3219: END IF;
3220:
3221: END IF;
3222:

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

3276: ** assignment (NJ) then SUI_EE does not apply
3277: */
3278: IF (tax_exists(l_jd_entered, 'SUI_EE', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N') OR
3279: (g_sui_state_code <> p_state_abbrev) THEN
3280: hr_utility.set_message(801, 'PY_51328_TXADJ_SUI_EXEMPT');
3281: hr_utility.raise_error;
3282: END IF;
3283:
3284: END IF;

Line 3281: hr_utility.raise_error;

3277: */
3278: IF (tax_exists(l_jd_entered, 'SUI_EE', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'N') OR
3279: (g_sui_state_code <> p_state_abbrev) THEN
3280: hr_utility.set_message(801, 'PY_51328_TXADJ_SUI_EXEMPT');
3281: hr_utility.raise_error;
3282: END IF;
3283:
3284: END IF;
3285:

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

3283:
3284: END IF;
3285:
3286: BEGIN
3287: hr_utility.set_location(c_proc, 10);
3288: SELECT consolidation_set_id
3289: INTO l_consolidation_set_id
3290: FROM PAY_CONSOLIDATION_SETS
3291: WHERE consolidation_set_name = p_consolidation_set

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

3292: and business_group_id = l_bg_id
3293: ;
3294: EXCEPTION
3295: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
3296: hr_utility.set_message(801, 'PY_51136_TXADJ_CONSET_NOT_FND');
3297: hr_utility.raise_error;
3298: END;
3299:
3300: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,

Line 3297: hr_utility.raise_error;

3293: ;
3294: EXCEPTION
3295: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
3296: hr_utility.set_message(801, 'PY_51136_TXADJ_CONSET_NOT_FND');
3297: hr_utility.raise_error;
3298: END;
3299:
3300: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,
3301: p_state_abbrev => p_state_abbrev,

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

3468: -- more error checking
3469:
3470: -- check the level of l_jd_entered to see if all taxes entered
3471: -- are applicable for the jurisdiction entered
3472: hr_utility.set_location(c_proc, 15);
3473:
3474: IF (l_city <> 0) THEN -- jd level needed is for a city --Bug3697701 --Removed the condition
3475: l_jd_level_needed := 4; --OR l_gross_amount <> 0 from IF stmt.
3476:

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

3502:
3503:
3504: -- now compare the level of jd entered against the level required
3505: IF (l_jd_level_needed > l_jd_level_entered) THEN
3506: hr_utility.set_location(c_proc, 20);
3507: hr_utility.set_message(801, 'PY_50015_TXADJ_JD_INSUFF');
3508: hr_utility.raise_error;
3509: END IF;
3510:

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

3503:
3504: -- now compare the level of jd entered against the level required
3505: IF (l_jd_level_needed > l_jd_level_entered) THEN
3506: hr_utility.set_location(c_proc, 20);
3507: hr_utility.set_message(801, 'PY_50015_TXADJ_JD_INSUFF');
3508: hr_utility.raise_error;
3509: END IF;
3510:
3511:

Line 3508: hr_utility.raise_error;

3504: -- now compare the level of jd entered against the level required
3505: IF (l_jd_level_needed > l_jd_level_entered) THEN
3506: hr_utility.set_location(c_proc, 20);
3507: hr_utility.set_message(801, 'PY_50015_TXADJ_JD_INSUFF');
3508: hr_utility.raise_error;
3509: END IF;
3510:
3511:
3512: -- main processing

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

3509: END IF;
3510:
3511:
3512: -- main processing
3513: hr_utility.set_location(c_proc, 30);
3514:
3515: -- first call routine to create payroll_action_id, we will only need
3516: -- one for entire tax balance adjustment process
3517: l_payroll_action_id := pay_bal_adjust.init_batch(p_payroll_id => l_payroll_id,

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

4238:
4239: IF (tax_exists(l_jd_entered, 'SIT', p_adjustment_date, l_per_adr_geocode, l_loc_adr_geocode) = 'Y') THEN
4240: IF l_sit_exempt <> 'Y' THEN /* Bug#13634961 added condition to check l_sit_exempt */
4241:
4242: hr_utility.trace('before process_element with SIT_SUBJECT_WK '||TO_CHAR(l_sit));
4243: process_element(p_assignment_id => l_assignment_id,
4244: p_consolidation_set_id => l_consolidation_set_id,
4245: p_element_type => 'SIT_SUBJECT_WK',
4246: p_abbrev_element_type => 'SITSubK',

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

4457: AND g_sui_ee_taxable < g_sui_ee_wage_limit
4458: AND (g_sui_ee_taxable + g_sui_ee_tax_adj_amt = g_sui_ee_wage_limit)
4459: AND g_sui_ee_taxable > l_sui_ee_jd_taxable
4460: ) THEN
4461: hr_utility.set_location(c_proc, 50);
4462: l_sui_ee_warning := TRUE;
4463: END IF;
4464: /* Bug 12694875 ends */
4465:

Line 4533: hr_utility.set_location(c_proc, 55);

4529: AND g_sui_er_taxable < g_sui_er_wage_limit
4530: AND (g_sui_er_taxable + g_sui_er_tax_adj_amt = g_sui_er_wage_limit)
4531: AND g_sui_er_taxable > l_sui_er_jd_taxable
4532: ) THEN
4533: hr_utility.set_location(c_proc, 55);
4534: l_sui_er_warning := TRUE;
4535: END IF;
4536: /* Bug 12694875 ends */
4537:

Line 4728: IF hr_utility.check_warning THEN

4724: p_payroll_action_id := l_payroll_action_id;
4725: p_sui_ee_warning := l_sui_ee_warning;
4726: p_sui_er_warning := l_sui_er_warning;
4727:
4728: IF hr_utility.check_warning THEN
4729: l_create_warning := TRUE;
4730: hr_utility.clear_warning;
4731: END IF;
4732:

Line 4730: hr_utility.clear_warning;

4726: p_sui_er_warning := l_sui_er_warning;
4727:
4728: IF hr_utility.check_warning THEN
4729: l_create_warning := TRUE;
4730: hr_utility.clear_warning;
4731: END IF;
4732:
4733: IF(p_validate) THEN
4734: RAISE hr_api.validate_enabled;

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

4733: IF(p_validate) THEN
4734: RAISE hr_api.validate_enabled;
4735: END IF;
4736:
4737: hr_utility.trace('Finished Routine, all adjustments commited');
4738: hr_utility.trace('Payroll_action_id = '||TO_CHAR(l_payroll_action_id));
4739:
4740: pay_bal_adjust.process_batch(p_payroll_action_id);
4741:

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

4734: RAISE hr_api.validate_enabled;
4735: END IF;
4736:
4737: hr_utility.trace('Finished Routine, all adjustments commited');
4738: hr_utility.trace('Payroll_action_id = '||TO_CHAR(l_payroll_action_id));
4739:
4740: pay_bal_adjust.process_batch(p_payroll_action_id);
4741:
4742:

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

4753: -- when validation only mode is being used.)
4754: --
4755: p_payroll_action_id := NULL;
4756: p_create_warning := l_create_warning;
4757: hr_utility.trace('Validate Enabled, no commits are made');
4758:
4759: WHEN OTHERS THEN
4760: -- Unexpected error detected.
4761: ROLLBACK TO create_tax_bal_adjustment;