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

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

333: --
334: EXCEPTION
335: WHEN OTHERS THEN
336: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
337: hr_utility.set_location(sqlerrm(sqlcode),110);
338: --
339: END write_to_clob;
340: --
341: --

Line 356: hr_utility.trace('+====write_file============================================+');

352: FROM v$parameter
353: WHERE lower (name) = 'utl_file_dir';
354:
355: BEGIN
356: hr_utility.trace('+====write_file============================================+');
357: fnd_file.put_line(fnd_file.log, 'p_file_name '||p_file_name);
358: OPEN cur_get_directory_path;
359: FETCH cur_get_directory_path INTO l_directory_path;
360: CLOSE cur_get_directory_path;

Line 379: hr_utility.set_location(l_xml_element,30);

375: IF g_xml_element_table(table_counter).tagvalue = '_START_' THEN
376: IF g_xml_element_table(table_counter).tagattrb IS NOT NULL THEN
377: l_xml_element := '<' || g_xml_element_table(table_counter).tagname || ' '
378: || g_xml_element_table(table_counter).tagattrb ||'>';
379: hr_utility.set_location(l_xml_element,30);
380: ELSE
381: l_xml_element := '<' || g_xml_element_table(table_counter).tagname || '>';
382: END IF;
383:

Line 415: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);

411: END LOOP;
412: --
413: END IF;
414: utl_file.fclose(l_file);
415: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);
416: hr_utility.trace('x====write_file============================================x');
417: EXCEPTION
418: WHEN others THEN
419: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);

Line 416: hr_utility.trace('x====write_file============================================x');

412: --
413: END IF;
414: utl_file.fclose(l_file);
415: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);
416: hr_utility.trace('x====write_file============================================x');
417: EXCEPTION
418: WHEN others THEN
419: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);
420: hr_utility.raise_error;

Line 419: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);

415: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);
416: hr_utility.trace('x====write_file============================================x');
417: EXCEPTION
418: WHEN others THEN
419: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);
420: hr_utility.raise_error;
421: END write_file;
422: -- -----------------------------------------------------------------------------
423: -- Parse out parameters from string.

Line 420: hr_utility.raise_error;

416: hr_utility.trace('x====write_file============================================x');
417: EXCEPTION
418: WHEN others THEN
419: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);
420: hr_utility.raise_error;
421: END write_file;
422: -- -----------------------------------------------------------------------------
423: -- Parse out parameters from string.
424: -- -----------------------------------------------------------------------------

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

1355: l_pp_name csr_pp_name%ROWTYPE; -- Bug#9579261 fix
1356: -- End Changes 2007/2008
1357: --
1358: BEGIN
1359: hr_utility.set_location('Entering ' || l_proc_name, 10);
1360: --
1361: --
1362: -- Setup legislative parameters as global values for future use.
1363: --

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

1778: WHERE ppa.payroll_action_id = :payroll_action_id
1779: AND per.business_group_id = ppa.business_group_id
1780: ORDER BY per.person_id';
1781: --
1782: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
1783: END range_code;
1784: --
1785: --
1786: -- -----------------------------------------------------------------------------

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

1885: l_employment_start_date DATE;
1886: l_employment_end_date DATE;
1887: --
1888: BEGIN
1889: hr_utility.set_location('Entering ' || l_proc_name, 10);
1890: --
1891: --
1892: -- Setup legislative parameters as global values for future use.
1893: --

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

2019: ,p_action_information8 => l_asg_rec.municipality_code
2020: );
2021: END LOOP;
2022: --
2023: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2024: END assignment_action_code;
2025: --
2026: --
2027: -- -----------------------------------------------------------------------------

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

2449: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;
2450: r_retro_rec csr_retro%rowtype;
2451: --
2452: BEGIN
2453: hr_utility.set_location('Entering ' || l_proc_name, 10);
2454: --
2455: /* Select Payroll_action_id
2456: into l_payroll_action_id
2457: from pay_assignment_actions paa

Line 2462: hr_utility.set_location('After setting globals ' || l_proc_name, 30); */

2458: where paa.assignment_action_id = p_assignment_action_id;
2459:
2460: set_parameters(l_payroll_action_id);
2461:
2462: hr_utility.set_location('After setting globals ' || l_proc_name, 30); */
2463:
2464: OPEN csr_Seaman;
2465: FETCH csr_Seaman INTO l_classification_id;
2466: CLOSE csr_Seaman;

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

3137: ,l_proc_name_rec.reporting_code
3138: ,g_report_date;
3139: END LOOP;
3140: --
3141: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
3142: END archive_code;
3143: --
3144: --
3145: -- -----------------------------------------------------------------------------

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

3431: l_balance_tested BOOLEAN := FALSE;
3432: l_tax_defbal_id NUMBER := get_defined_balance(g_business_group_id, 'Tax', '_PER_TU_YTD');
3433: --
3434: BEGIN
3435: hr_utility.set_location('Entering ' || l_proc_name, 10);
3436: --
3437: set_parameters(p_payroll_action_id);
3438: --
3439: --

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

3653: ,l_proc_name_rec.legal_employer_id
3654: ,l_proc_name_rec.reporting_code;
3655: END LOOP;
3656: --
3657: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
3658: --
3659: EXCEPTION
3660: WHEN OTHERS THEN
3661: Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));

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

3658: --
3659: EXCEPTION
3660: WHEN OTHERS THEN
3661: Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
3662: hr_utility.set_location(sqlerrm(sqlcode),120);
3663: --
3664: END deinitialization_code;
3665: --
3666: --

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

3774: l_desc_count NUMBER := 0;
3775: l_seaman_status VARCHAR2(1);
3776: --
3777: BEGIN
3778: hr_utility.set_location('Entering ' || l_proc_name, 10);
3779: g_xml_element_table.DELETE;
3780: g_fixed_code.DELETE;
3781: --
3782: IF p_payroll_action_id is null then

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

4202: --9538493
4203:
4204: write_to_clob(p_xml);
4205: --
4206: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
4207: END get_audit_data;
4208: --
4209: --
4210: ------------------------------------------------------------------------------------

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

4516: l_specs_count NUMBER :=0; --Bug 14671801
4517: l_page_ended BOOLEAN := FALSE; --Bug 14671801
4518: --
4519: BEGIN
4520: hr_utility.set_location('Entering ' || l_proc_name, 10);
4521: g_xml_element_table.DELETE;
4522: --
4523: IF p_payroll_action_id is null then
4524: BEGIN

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

5220: l_xml_element_count := l_xml_element_count + 1;
5221: --
5222: write_to_clob(p_xml);
5223: --
5224: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
5225: END get_employer_contribution_data;
5226: --
5227: --
5228: --

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

5517: l_net_emp_contr_bse NUMBER := 0;
5518: l_gross_emp_contr_bse NUMBER := 0;
5519: --
5520: BEGIN
5521: hr_utility.set_location('Entering ' || l_proc_name, 10);
5522: g_xml_element_table.DELETE;
5523: --
5524: /*
5525: IF p_payroll_action_id is null then

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

5989: l_xml_element_count := l_xml_element_count + 1;
5990:
5991: write_to_clob(p_xml);
5992: --
5993: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
5994: END get_employer_contribution_xml;
5995: --
5996: --
5997: -- -----------------------------------------------------------------------------

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

6210: rec_per_fix_code csr_PER_FIX_CODE%ROWTYPE;
6211: addl_info VARCHAR2(30);
6212: --
6213: BEGIN
6214: hr_utility.set_location('Entering ' || l_proc_name, 10);
6215:
6216: g_xml_element_table.DELETE;
6217: --
6218: IF p_payroll_action_id is null then

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

6758: l_xml_element_count := l_xml_element_count + 1;
6759: --
6760: write_to_clob(p_xml);
6761: --
6762: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
6763: END get_employee_cerificate_data;
6764: --
6765: -------------------------------------------------------------------------------------
6766: -- Generates XML for the Norwegian End of Year Report called Certificate of Pay

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

7000: l_start varchar2(25) := '' ;
7001: l_end varchar2(25) := '' ;
7002: --
7003: BEGIN
7004: hr_utility.set_location('Entering ' || l_proc_name, 10);
7005: g_xml_element_table.DELETE;
7006: --
7007: IF p_payroll_action_id is null then
7008: BEGIN

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

8091: dbms_lob.writeappend(g_clob, LENGTH(l_end), l_end);
8092: fnd_file.put_line(fnd_file.log, 'l_end'||l_end);
8093: p_xml := g_clob;
8094: --
8095: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
8096: END get_employee_certificate_xml;
8097: --
8098: --
8099: --