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.

[Home] [Help]

APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_UTILITY

Line 324: hr_utility.set_location(sqlerrm(sqlcode),110);

320: --
321: EXCEPTION
322: WHEN OTHERS THEN
323: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
324: hr_utility.set_location(sqlerrm(sqlcode),110);
325: --
326: END write_to_clob;
327: --
328: --

Line 1206: hr_utility.set_location('Entering ' || l_proc_name, 10);

1202: l_Legal_Emp_EA csr_Legal_Emp_EA%ROWTYPE;
1203: -- End Changes 2007/2008
1204: --
1205: BEGIN
1206: hr_utility.set_location('Entering ' || l_proc_name, 10);
1207: --
1208: --
1209: -- Setup legislative parameters as global values for future use.
1210: --

Line 1601: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

1597: WHERE ppa.payroll_action_id = :payroll_action_id
1598: AND per.business_group_id = ppa.business_group_id
1599: ORDER BY per.person_id';
1600: --
1601: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
1602: END range_code;
1603: --
1604: --
1605: -- -----------------------------------------------------------------------------

Line 1707: hr_utility.set_location('Entering ' || l_proc_name, 10);

1703: l_employment_start_date DATE;
1704: l_employment_end_date DATE;
1705: --
1706: BEGIN
1707: hr_utility.set_location('Entering ' || l_proc_name, 10);
1708: --
1709: --
1710: -- Setup legislative parameters as global values for future use.
1711: --

Line 1841: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

1837: ,p_action_information8 => l_asg_rec.municipality_code
1838: );
1839: END LOOP;
1840: --
1841: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
1842: END assignment_action_code;
1843: --
1844: --
1845: -- -----------------------------------------------------------------------------

Line 2192: hr_utility.set_location('Entering ' || l_proc_name, 10);

2188: l_index_616 NUMBER;
2189: l_code_616 code_616;
2190: --
2191: BEGIN
2192: hr_utility.set_location('Entering ' || l_proc_name, 10);
2193: --
2194: OPEN csr_Seaman;
2195: FETCH csr_Seaman INTO l_classification_id;
2196: CLOSE csr_Seaman;

Line 2733: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

2729: ,l_proc_name_rec.reporting_code
2730: ,g_report_date;
2731: END LOOP;
2732: --
2733: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2734: END archive_code;
2735: --
2736: --
2737: -- -----------------------------------------------------------------------------

Line 2911: hr_utility.set_location('Entering ' || l_proc_name, 10);

2907: l_balance_tested BOOLEAN := FALSE;
2908: l_tax_defbal_id NUMBER := get_defined_balance(g_business_group_id, 'Tax', '_PER_TU_YTD');
2909: --
2910: BEGIN
2911: hr_utility.set_location('Entering ' || l_proc_name, 10);
2912: --
2913: set_parameters(p_payroll_action_id);
2914: --
2915: --

Line 3053: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

3049: ,l_proc_name_rec.legal_employer_id
3050: ,l_proc_name_rec.reporting_code;
3051: END LOOP;
3052: --
3053: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
3054: --
3055: EXCEPTION
3056: WHEN OTHERS THEN
3057: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));

Line 3058: hr_utility.set_location(sqlerrm(sqlcode),120);

3054: --
3055: EXCEPTION
3056: WHEN OTHERS THEN
3057: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
3058: hr_utility.set_location(sqlerrm(sqlcode),120);
3059: --
3060: END deinitialization_code;
3061: --
3062: --

Line 3162: hr_utility.set_location('Entering ' || l_proc_name, 10);

3158: l_desc_count NUMBER := 0;
3159: l_seaman_status VARCHAR2(1);
3160: --
3161: BEGIN
3162: hr_utility.set_location('Entering ' || l_proc_name, 10);
3163: g_xml_element_table.DELETE;
3164: g_fixed_code.DELETE;
3165: --
3166: IF p_payroll_action_id is null then

Line 3477: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

3473: END LOOP;
3474: --
3475: write_to_clob(p_xml);
3476: --
3477: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
3478: END get_audit_data;
3479: --
3480: --
3481: ------------------------------------------------------------------------------------

Line 3772: hr_utility.set_location('Entering ' || l_proc_name, 10);

3768: l_gross_emp_contr_bse NUMBER := 0;
3769: l_spcl_net_base NUMBER := 0;
3770: --
3771: BEGIN
3772: hr_utility.set_location('Entering ' || l_proc_name, 10);
3773: g_xml_element_table.DELETE;
3774: --
3775: IF p_payroll_action_id is null then
3776: BEGIN

Line 4307: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

4303: l_xml_element_count := l_xml_element_count + 1;
4304: --
4305: write_to_clob(p_xml);
4306: --
4307: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
4308: END get_employer_contribution_data;
4309: --
4310: --
4311: --

Line 4602: hr_utility.set_location('Entering ' || l_proc_name, 10);

4598: l_net_emp_contr_bse NUMBER := 0;
4599: l_gross_emp_contr_bse NUMBER := 0;
4600: --
4601: BEGIN
4602: hr_utility.set_location('Entering ' || l_proc_name, 10);
4603: g_xml_element_table.DELETE;
4604: --
4605: IF p_payroll_action_id is null then
4606: BEGIN

Line 5025: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

5021: l_xml_element_count := l_xml_element_count + 1;
5022: --
5023: write_to_clob(p_xml);
5024: --
5025: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
5026: END get_employer_contribution_xml;
5027: --
5028: --
5029: -- -----------------------------------------------------------------------------

Line 5230: hr_utility.set_location('Entering ' || l_proc_name, 10);

5226: rec_per_fix_code csr_PER_FIX_CODE%ROWTYPE;
5227: addl_info VARCHAR2(30);
5228: --
5229: BEGIN
5230: hr_utility.set_location('Entering ' || l_proc_name, 10);
5231: g_xml_element_table.DELETE;
5232: --
5233: IF p_payroll_action_id is null then
5234: BEGIN

Line 5678: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

5674: l_xml_element_count := l_xml_element_count + 1;
5675: --
5676: write_to_clob(p_xml);
5677: --
5678: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
5679: END get_employee_cerificate_data;
5680: --
5681: -------------------------------------------------------------------------------------
5682: -- Generates XML for the Norwegian End of Year Report called Certificate of Pay

Line 5887: hr_utility.set_location('Entering ' || l_proc_name, 10);

5883: rec_per_fix_code csr_PER_FIX_CODE%ROWTYPE;
5884: addl_info VARCHAR2(30);
5885: --
5886: BEGIN
5887: hr_utility.set_location('Entering ' || l_proc_name, 10);
5888: g_xml_element_table.DELETE;
5889: --
5890: IF p_payroll_action_id is null then
5891: BEGIN

Line 6739: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

6735:
6736: --
6737: write_to_clob(p_xml);
6738: --
6739: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
6740: END get_employee_certificate_xml;
6741: --
6742: --
6743: --