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

Line 110: hr_utility.trace ('Entering number splitting function');

106: ln_pos_dec NUMBER;
107: ln_integer_part NUMBER;
108:
109: BEGIN
110: hr_utility.trace ('Entering number splitting function');
111:
112: ln_pos_dec := INSTR(P_NUMBER,substr(ltrim(to_char(.3,'0D0')),2,1));
113:
114: IF ln_pos_dec > 0 THEN

Line 135: hr_utility.trace ('Leaving number splitting function');

131: IF length(P_DECIMAL_PART) = 1 THEN
132: P_DECIMAL_PART := rpad(P_DECIMAL_PART,2,'0');
133: END IF;
134:
135: hr_utility.trace ('Leaving number splitting function');
136: RETURN (0);
137:
138: END SPLIT_NUMBER_INTO_INT_DECIMAL; -- Bug 9357061: Function end.
139:

Line 893: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||

889: /* Bug 9357061: Splitting of Integer part and Decimal part end */
890:
891: ln_taxable_ss_wage := NVL(ln_ss_er_taxable,0) * 0.124; --0.124; #11831970 Modified rate to .104. Bug#16211747 Modified rate to 0.124
892: IF ln_taxable_ss_wage < 0 THEN
893: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||
894: ' has negative B5A Total Taxable SS Wages. Please check.');
895: END IF;
896:
897: /* Bug 9357061: Splitting of Integer part and Decimal part begin */

Line 913: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||

909: /* Bug 9357061: Splitting of Integer part and Decimal part end */
910:
911: ln_941_box5b := NVL(ln_ss_tips,0) * 0.124; --0.124; #11831970 Modified rate to .104 Bug#16211747. Bug#16211747 Modified rate to 0.124
912: IF ln_941_box5b < 0 THEN
913: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||
914: ' has negative B5B Total Taxable SS Wages. Please check.');
915: END IF;
916:
917: /* Bug 9357061: Splitting of Integer part and Decimal part begin */

Line 933: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||

929: /* Bug 9357061: Splitting of Integer part and Decimal part end */
930:
931: ln_taxable_medicare := NVL(ln_medicare_er_taxable,0) * 0.029;
932: IF ln_taxable_medicare < 0 THEN
933: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||
934: ' has negative B5C Taxable Medicare Wages. Please check.');
935: END IF;
936:
937: /* Bug 9357061: Splitting of Integer part and Decimal part begin */

Line 952: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||

948:
949: /* Added for Bug#16211747 - Starts */
950: ln_tax_med_er_ovr_lmt := NVL(ln_med_er_tax_ovr_lmt, 0) * 0.009;
951: IF ln_tax_med_er_ovr_lmt < 0 THEN
952: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||
953: ' has negative B5D Taxable Medicare Wages. Please check.');
954: END IF;
955:
956: IF ln_tax_med_er_ovr_lmt <> 0 THEN

Line 974: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||

970: NVL(ln_taxable_medicare,0) +
971: NVL(ln_941_box5b,0) +
972: NVL(ln_tax_med_er_ovr_lmt, 0); /* Added for Bug#16211747 */
973: IF ln_tot_ss_medicare_tax < 0 THEN
974: hr_utility.trace('001.'||'Tax Unit ID: '||TO_CHAR(p_tax_unit_id)||
975: ' has negative B5E Total SS Medicare Taxes. Please check.');
976: END IF;
977:
978: /* Bug 9357061: Splitting of Integer part and Decimal part begin */

Line 1477: hr_utility.set_location('Entered Procedure Write to clob ',100);

1473: PROCEDURE WritetoCLOB (p_XML OUT NOCOPY CLOB)
1474: IS
1475: l_xfdf_string CLOB;
1476: BEGIN
1477: hr_utility.set_location('Entered Procedure Write to clob ',100);
1478: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1479: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1480: -- if vXMLTable.count > 0 then
1481: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST

Line 1490: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

1486: END LOOP;
1487: p_XML := l_xfdf_string;
1488: EXCEPTION
1489: WHEN OTHERS THEN
1490: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1491: HR_UTILITY.RAISE_ERROR;
1492: END WritetoCLOB;
1493:
1494:

Line 1491: HR_UTILITY.RAISE_ERROR;

1487: p_XML := l_xfdf_string;
1488: EXCEPTION
1489: WHEN OTHERS THEN
1490: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1491: HR_UTILITY.RAISE_ERROR;
1492: END WritetoCLOB;
1493:
1494:
1495: PROCEDURE gen_941_report(p_business_group_id IN NUMBER,

Line 1553: hr_utility.set_location('Entering '|| g_package || l_procedure_name, 10);

1549:
1550: BEGIN
1551:
1552: l_procedure_name := '.pay_us_941_report_wrapper';
1553: hr_utility.set_location('Entering '|| g_package || l_procedure_name, 10);
1554:
1555: --Bug 8267963
1556: OPEN csr_release;
1557: FETCH csr_release INTO l_release;

Line 1595: hr_utility.trace ('Leaving 12'|| l_procedure_name);

1591: argument6 => 'N',
1592: argument7 => 'PDF',
1593: argument8 => 'PDF' );
1594:
1595: hr_utility.trace ('Leaving 12'|| l_procedure_name);
1596:
1597: else
1598:
1599: l_req_id2 := fnd_request.submit_request(

Line 1612: hr_utility.trace ('Leaving 11i'|| l_procedure_name);

1608: argument7 => 'PDF' );
1609:
1610:
1611:
1612: hr_utility.trace ('Leaving 11i'|| l_procedure_name);
1613:
1614: end if;
1615:
1616: ELSE

Line 1634: hr_utility.raise_error;

1630: END IF;
1631:
1632: EXCEPTION
1633: WHEN others THEN
1634: hr_utility.raise_error;
1635:
1636: hr_utility.set_location('Leaving '|| g_package || l_procedure_name, 20);
1637:
1638: End pay_us_941_report_wrapper ;

Line 1636: hr_utility.set_location('Leaving '|| g_package || l_procedure_name, 20);

1632: EXCEPTION
1633: WHEN others THEN
1634: hr_utility.raise_error;
1635:
1636: hr_utility.set_location('Leaving '|| g_package || l_procedure_name, 20);
1637:
1638: End pay_us_941_report_wrapper ;
1639:
1640: END pay_us_941_report;