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

Line 770: hr_utility.trace('~~ppay_periods_per_year'||ppay_periods_per_year);

766: l_payroll_end NUMBER;
767: l_proration_factor NUMBER;
768: --
769: BEGIN
770: hr_utility.trace('~~ppay_periods_per_year'||ppay_periods_per_year);
771: hr_utility.trace('~~ppay_proc_period_number'||ppay_proc_period_number);
772: hr_utility.trace('~~pchk_new_emp'||pchk_new_emp);
773: IF pchk_new_emp <> 'Y' and to_char(ptermination_date,'YYYY') <> to_char(peffective_date,'YYYY') THEN
774: IF p_run_type = 'TAX_WITHHOLDING_RATE' THEN

Line 771: hr_utility.trace('~~ppay_proc_period_number'||ppay_proc_period_number);

767: l_proration_factor NUMBER;
768: --
769: BEGIN
770: hr_utility.trace('~~ppay_periods_per_year'||ppay_periods_per_year);
771: hr_utility.trace('~~ppay_proc_period_number'||ppay_proc_period_number);
772: hr_utility.trace('~~pchk_new_emp'||pchk_new_emp);
773: IF pchk_new_emp <> 'Y' and to_char(ptermination_date,'YYYY') <> to_char(peffective_date,'YYYY') THEN
774: IF p_run_type = 'TAX_WITHHOLDING_RATE' THEN
775: l_proration_factor := (ppay_periods_per_year - ppay_proc_period_number + 1)/ppay_periods_per_year;

Line 772: hr_utility.trace('~~pchk_new_emp'||pchk_new_emp);

768: --
769: BEGIN
770: hr_utility.trace('~~ppay_periods_per_year'||ppay_periods_per_year);
771: hr_utility.trace('~~ppay_proc_period_number'||ppay_proc_period_number);
772: hr_utility.trace('~~pchk_new_emp'||pchk_new_emp);
773: IF pchk_new_emp <> 'Y' and to_char(ptermination_date,'YYYY') <> to_char(peffective_date,'YYYY') THEN
774: IF p_run_type = 'TAX_WITHHOLDING_RATE' THEN
775: l_proration_factor := (ppay_periods_per_year - ppay_proc_period_number + 1)/ppay_periods_per_year;
776: ELSE

Line 1315: hr_utility.trace(' Entering procedure pay_es_twr_calc_pkg.populate_plsql_table ');

1311: --
1312: BEGIN
1313: vXMLTable.DELETE;
1314: vCtr := 1;
1315: hr_utility.trace(' Entering procedure pay_es_twr_calc_pkg.populate_plsql_table ');
1316: l_no := 0;
1317: l_header := /*rpad(hr_general.decode_lookup('ES_FORM_LABELS','ERR_MSG'),4)||' '||*/
1318: rpad(hr_general.decode_lookup('ES_FORM_LABELS','ANO'),10)||' '||
1319: rpad(hr_general.decode_lookup('ES_FORM_LABELS','ENAME'),30)||' '||

Line 1329: hr_utility.trace(' Assignment id :' || i.assignment_id);

1325: rpad('-',200,'-')||' ';
1326:
1327:
1328: FOR i IN csr_get_assignment_ids LOOP
1329: hr_utility.trace(' Assignment id :' || i.assignment_id);
1330: hr_utility.trace(' i.effective_date:' || i.effective_date);
1331:
1332: l_msg_rec.Msg := ' ';
1333:

Line 1330: hr_utility.trace(' i.effective_date:' || i.effective_date);

1326:
1327:
1328: FOR i IN csr_get_assignment_ids LOOP
1329: hr_utility.trace(' Assignment id :' || i.assignment_id);
1330: hr_utility.trace(' i.effective_date:' || i.effective_date);
1331:
1332: l_msg_rec.Msg := ' ';
1333:
1334: OPEN csr_chk_emp_err(i.assignment_action_id, i.effective_date);

Line 1341: hr_utility.trace(' l_chk_emp_err :' || l_chk_emp_err);

1337: l_chk_emp_err := 'Y';
1338: END IF;
1339: CLOSE csr_chk_emp_err;
1340:
1341: hr_utility.trace(' l_chk_emp_err :' || l_chk_emp_err);
1342: IF l_chk_emp_err = 'Y' THEN
1343: IF l_no = 0 THEN
1344: Fnd_File.New_Line(FND_FILE.LOG,1);
1345: Fnd_file.put_line(FND_FILE.LOG,hr_general.decode_lookup('ES_FORM_LABELS','EXCEPTION_LIST'));

Line 1647: hr_utility.trace(' Leaving procedure pay_es_twr_calc_pkg.populate_plsql_table ');

1643: vCtr := vCtr + 1;
1644: END IF;
1645: --
1646: END LOOP;
1647: hr_utility.trace(' Leaving procedure pay_es_twr_calc_pkg.populate_plsql_table ');
1648: END populate_plsql_table ;
1649: --
1650: -------------------------------------------------------------------------------
1651: -- WRITETOCLOB

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

1702: clob_to_blob(p_xfdf_string,p_xfdf_blob);
1703: --return p_xfdf_blob;
1704: EXCEPTION
1705: WHEN OTHERS then
1706: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1707: HR_UTILITY.RAISE_ERROR;
1708: END WritetoCLOB;
1709: --------------------------------------------------------------------------------
1710: -- CLOB_TO_BLOB

Line 1707: HR_UTILITY.RAISE_ERROR;

1703: --return p_xfdf_blob;
1704: EXCEPTION
1705: WHEN OTHERS then
1706: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1707: HR_UTILITY.RAISE_ERROR;
1708: END WritetoCLOB;
1709: --------------------------------------------------------------------------------
1710: -- CLOB_TO_BLOB
1711: --------------------------------------------------------------------------------

Line 1729: hr_utility.set_location('Entered Procedure clob to blob',120);

1725: l_blob_offset pls_integer := 1;
1726: --
1727: BEGIN
1728: --
1729: hr_utility.set_location('Entered Procedure clob to blob',120);
1730: --
1731: SELECT userenv('LANGUAGE') INTO g_nls_db_char FROM dual;
1732: --
1733: l_buffer_len := 20000;

Line 1756: hr_utility.set_location('Finished Procedure clob to blob ',130);

1752: l_offset := l_offset + l_chunk_len;
1753: l_length_clob := l_length_clob - l_chunk_len;
1754: --
1755: END LOOP;
1756: hr_utility.set_location('Finished Procedure clob to blob ',130);
1757: END;
1758: --
1759: --------------------------------------------------------------------------------
1760: -- GET_CONTRACTUAL_EARNINGS

Line 1816: hr_utility.trace(' Work Center ID : '||i.work_center);

1812: l_tot_salary := 0;
1813: l_salary := 0;
1814: --
1815: FOR i in csr_get_work_centers(l_work_center) LOOP
1816: hr_utility.trace(' Work Center ID : '||i.work_center);
1817:
1818: FOR l_rec IN csr_get_assignment_id(l_person_id,p_calculation_date,i.work_center) LOOP
1819: --
1820: hr_utility.trace(' Assignment ID : '||l_rec.assignment_id);

Line 1820: hr_utility.trace(' Assignment ID : '||l_rec.assignment_id);

1816: hr_utility.trace(' Work Center ID : '||i.work_center);
1817:
1818: FOR l_rec IN csr_get_assignment_id(l_person_id,p_calculation_date,i.work_center) LOOP
1819: --
1820: hr_utility.trace(' Assignment ID : '||l_rec.assignment_id);
1821:
1822: l_salary := pqp_rates_history_calc.get_historic_rate(
1823: p_assignment_id => l_rec.assignment_id
1824: ,p_rate_name => p_name

Line 2019: hr_utility.trace(' Work Center ID : '||l_rec.work_center);

2015: p_spouse_alimony_amt := 0;
2016: l_end_year := TO_DATE('3112'||TO_CHAR(p_calculation_date,'YYYY'),'ddmmyyyy');
2017: --
2018: FOR l_rec in csr_get_work_centers(l_work_center) LOOP
2019: hr_utility.trace(' Work Center ID : '||l_rec.work_center);
2020: FOR i IN csr_get_assignment_id(l_person_id,p_calculation_date,l_rec.work_center) LOOP
2021: --
2022: l_co_start_date := fnd_date.canonical_to_date(i.start_date);
2023: l_co_end_date := fnd_date.canonical_to_date(i.end_date);