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 FND_FILE

Line 336: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));

332: p_clob := l_clob;
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: --

Line 357: fnd_file.put_line(fnd_file.log, 'p_file_name '||p_file_name);

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;
361:

Line 675: fnd_file.put_line(fnd_file.log, 'p_person_id'||p_person_id);

671: BEGIN
672: --
673: l_first_flag := 0;
674:
675: fnd_file.put_line(fnd_file.log, 'p_person_id'||p_person_id);
676: --
677: OPEN csr_asg_contribution;
678: LOOP
679: --

Line 716: fnd_file.put_line(fnd_file.log,'Pos 4');

712: --
713: IF rec_asg_contribution.start_date > (l_asg_end_date + 1) THEN
714: --
715: CLOSE csr_asg_contribution;
716: fnd_file.put_line(fnd_file.log,'Pos 4');
717: RETURN ('N');
718: --
719: END IF;
720: --

Line 726: fnd_file.put_line(fnd_file.log,'Pos 5');

722: --
723: IF l_asg_end_date >= p_effective_date THEN
724: --
725: CLOSE csr_asg_contribution;
726: fnd_file.put_line(fnd_file.log,'Pos 5');
727: RETURN ('Y');
728: --
729: END IF;
730: --

Line 1366: Fnd_file.put_line(FND_FILE.LOG,'Inside Archive');

1362: -- Setup legislative parameters as global values for future use.
1363: --
1364: set_parameters(p_payroll_action_id);
1365: --
1366: Fnd_file.put_line(FND_FILE.LOG,'Inside Archive');
1367:
1368: -- Archive: EMEA REPORT DETAILS -> PYNOEOYA
1369: --
1370: pay_action_information_api.create_action_information

Line 1383: -- Fnd_file.put_line(FND_FILE.LOG,'csr_LEGEMP g_business_group_id'||g_business_group_id);

1379: --
1380: -- Loop through all legal employers.
1381: --
1382: --
1383: -- Fnd_file.put_line(FND_FILE.LOG,'csr_LEGEMP g_business_group_id'||g_business_group_id);
1384: -- Fnd_file.put_line(FND_FILE.LOG,'csr_LEGEMP g_legal_employer_id'||g_legal_employer_id);
1385: FOR l_rec1 IN csr_LEGEMP(g_business_group_id, g_legal_employer_id) LOOP
1386: --
1387: l_Legal_Emp_PP := null; -- Bug#9579261 fix

Line 1384: -- Fnd_file.put_line(FND_FILE.LOG,'csr_LEGEMP g_legal_employer_id'||g_legal_employer_id);

1380: -- Loop through all legal employers.
1381: --
1382: --
1383: -- Fnd_file.put_line(FND_FILE.LOG,'csr_LEGEMP g_business_group_id'||g_business_group_id);
1384: -- Fnd_file.put_line(FND_FILE.LOG,'csr_LEGEMP g_legal_employer_id'||g_legal_employer_id);
1385: FOR l_rec1 IN csr_LEGEMP(g_business_group_id, g_legal_employer_id) LOOP
1386: --
1387: l_Legal_Emp_PP := null; -- Bug#9579261 fix
1388: l_pp_name := null; -- Bug#9579261 fix

Line 1700: --Fnd_file.put_line(FND_FILE.LOG,'$$ l_rec3.asg_info_dfn'||l_rec3.asg_info_dfn);

1696: --
1697: --
1698: -- Extract IDs where appropriate i.e. element type ID or defined balance ID.
1699: --
1700: --Fnd_file.put_line(FND_FILE.LOG,'$$ l_rec3.asg_info_dfn'||l_rec3.asg_info_dfn);
1701: IF l_rec3.asg_info_meth = 'BAL' THEN
1702: l_asg_info_dfn := TO_CHAR(get_defined_balance(g_business_group_id, l_rec3.asg_info_dfn, '_ASG_TU_MC_LU_YTD'));
1703: ELSIF l_rec3.asg_info_meth = 'BAL_CODE_CTX' THEN
1704: l_asg_info_dfn := TO_CHAR(get_defined_balance(g_business_group_id, l_rec3.asg_info_dfn, '_ASG_ELE_CODE_TU_MC_LU_YTD'));

Line 1710: --Fnd_file.put_line(FND_FILE.LOG,'$$ l_asg_info_dfn'||l_asg_info_dfn);

1706: l_asg_info_dfn := TO_CHAR(get_element(g_business_group_id, l_rec3.asg_info_dfn));
1707: ELSE
1708: l_asg_info_dfn := l_rec3.asg_info_dfn;
1709: END IF;
1710: --Fnd_file.put_line(FND_FILE.LOG,'$$ l_asg_info_dfn'||l_asg_info_dfn);
1711: --
1712: -- Archive: EMEA REPORT INFORMATION | REP_CODE_DTLS
1713: --
1714: pay_action_information_api.create_action_information

Line 1939: fnd_file.put_line(fnd_file.log,'l_employed_throughout_year:'||l_employed_throughout_year);

1935: --
1936: --
1937: l_employed_throughout_year := employed_throughout_year(l_asg_rec.person_id
1938: , l_asg_rec.legal_employer_id, g_report_date);
1939: fnd_file.put_line(fnd_file.log,'l_employed_throughout_year:'||l_employed_throughout_year);
1940: l_non_cont_dates_days := NULL;
1941: --
1942: IF l_employed_throughout_year = 'N' THEN
1943: --

Line 2471: -- fnd_file.put_line(fnd_file.log,'csr_ASGACT p_assignment_action_id'||p_assignment_action_id);

2467: --
2468: --
2469: -- Get information for the assignment action being processed.
2470: --
2471: -- fnd_file.put_line(fnd_file.log,'csr_ASGACT p_assignment_action_id'||p_assignment_action_id);
2472: OPEN csr_ASGACT(p_assignment_action_id);
2473: FETCH csr_ASGACT INTO l_asg_act_rec;
2474: CLOSE csr_ASGACT;
2475: --

Line 2488: -- fnd_file.put_line(fnd_file.log,'csr_BAL g_payroll_action_id'||g_payroll_action_id);

2484: --
2485: --
2486: -- Loop through all balance based reporting codes.
2487: --
2488: -- fnd_file.put_line(fnd_file.log,'csr_BAL g_payroll_action_id'||g_payroll_action_id);
2489: -- fnd_file.put_line(fnd_file.log,'csr_BAL legal_employer_id'||l_asg_act_rec.legal_employer_id);
2490: FOR l_bal_rec IN csr_BAL
2491: (g_payroll_action_id
2492: ,l_asg_act_rec.legal_employer_id)

Line 2489: -- fnd_file.put_line(fnd_file.log,'csr_BAL legal_employer_id'||l_asg_act_rec.legal_employer_id);

2485: --
2486: -- Loop through all balance based reporting codes.
2487: --
2488: -- fnd_file.put_line(fnd_file.log,'csr_BAL g_payroll_action_id'||g_payroll_action_id);
2489: -- fnd_file.put_line(fnd_file.log,'csr_BAL legal_employer_id'||l_asg_act_rec.legal_employer_id);
2490: FOR l_bal_rec IN csr_BAL
2491: (g_payroll_action_id
2492: ,l_asg_act_rec.legal_employer_id)
2493: LOOP

Line 2500: --fnd_file.put_line(fnd_file.log,'$$$ reporting_code: '||l_bal_rec.reporting_code);

2496: --
2497: -- Setup balance contexts NB. This is used for reporting codes using BAL_CODE_CTX.
2498: --
2499: pay_balance_pkg.set_context('SOURCE_TEXT', l_bal_rec.reporting_code);
2500: --fnd_file.put_line(fnd_file.log,'$$$ reporting_code: '||l_bal_rec.reporting_code);
2501: --
2502: --
2503: -- Get balance value.
2504: --

Line 2505: --fnd_file.put_line(fnd_file.log,'$$$ l_bal_rec.defined_balance_id: '||l_bal_rec.defined_balance_id);

2501: --
2502: --
2503: -- Get balance value.
2504: --
2505: --fnd_file.put_line(fnd_file.log,'$$$ l_bal_rec.defined_balance_id: '||l_bal_rec.defined_balance_id);
2506: --fnd_file.put_line(fnd_file.log,'$$$ l_asg_act_rec.assignment_id: '||l_asg_act_rec.assignment_id);
2507: --fnd_file.put_line(fnd_file.log,'$$$ g_report_date: '||g_report_date);
2508: IF l_bal_rec.defined_balance_id IS NOT NULL THEN
2509: l_amount := pay_balance_pkg.get_value

Line 2506: --fnd_file.put_line(fnd_file.log,'$$$ l_asg_act_rec.assignment_id: '||l_asg_act_rec.assignment_id);

2502: --
2503: -- Get balance value.
2504: --
2505: --fnd_file.put_line(fnd_file.log,'$$$ l_bal_rec.defined_balance_id: '||l_bal_rec.defined_balance_id);
2506: --fnd_file.put_line(fnd_file.log,'$$$ l_asg_act_rec.assignment_id: '||l_asg_act_rec.assignment_id);
2507: --fnd_file.put_line(fnd_file.log,'$$$ g_report_date: '||g_report_date);
2508: IF l_bal_rec.defined_balance_id IS NOT NULL THEN
2509: l_amount := pay_balance_pkg.get_value
2510: (p_defined_balance_id => l_bal_rec.defined_balance_id

Line 2507: --fnd_file.put_line(fnd_file.log,'$$$ g_report_date: '||g_report_date);

2503: -- Get balance value.
2504: --
2505: --fnd_file.put_line(fnd_file.log,'$$$ l_bal_rec.defined_balance_id: '||l_bal_rec.defined_balance_id);
2506: --fnd_file.put_line(fnd_file.log,'$$$ l_asg_act_rec.assignment_id: '||l_asg_act_rec.assignment_id);
2507: --fnd_file.put_line(fnd_file.log,'$$$ g_report_date: '||g_report_date);
2508: IF l_bal_rec.defined_balance_id IS NOT NULL THEN
2509: l_amount := pay_balance_pkg.get_value
2510: (p_defined_balance_id => l_bal_rec.defined_balance_id
2511: ,p_assignment_id => l_asg_act_rec.assignment_id

Line 2516: --fnd_file.put_line(fnd_file.log,'$$$ l_amount: '||l_amount);

2512: ,p_virtual_date => g_report_date);
2513: ELSE
2514: l_amount := 0;
2515: END IF;
2516: --fnd_file.put_line(fnd_file.log,'$$$ l_amount: '||l_amount);
2517: --
2518: IF l_amount <> 0 THEN
2519: l_rep_code_rec.reporting_code := l_bal_rec.reporting_code;
2520: l_rep_code_rec.amount := fnd_number.number_to_canonical(l_amount);

Line 3661: Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));

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));
3662: hr_utility.set_location(sqlerrm(sqlcode),120);
3663: --
3664: END deinitialization_code;
3665: --

Line 3813: -- fnd_file.put_line(fnd_file.log,'csr_LEGEMP l_payroll_action_id'||l_payroll_action_id);

3809: --9538493
3810: --
3811: -- Loop for each legal employer.
3812: --
3813: -- fnd_file.put_line(fnd_file.log,'csr_LEGEMP l_payroll_action_id'||l_payroll_action_id);
3814: FOR l_legemp_rec IN csr_LEGEMP
3815: (l_payroll_action_id)
3816: LOOP
3817: --

Line 7658: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_fixed_code(rec_fixed_code).Amount_Value '||g_fixed_code(rec_fixed_code).Amount_Value);

7654: l_xml_element_count := l_xml_element_count + 1;
7655: --
7656: IF g_fixed_code(rec_fixed_code).fixed_code = '211' and g_fixed_code(rec_fixed_code).Amount_Value <> '0' THEN
7657: --
7658: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_fixed_code(rec_fixed_code).Amount_Value '||g_fixed_code(rec_fixed_code).Amount_Value);
7659: g_xml_element_table(l_xml_element_count).tagname := 'LonnoppgavekodeKodenummer-datadef-25435';
7660: g_xml_element_table(l_xml_element_count).tagvalue := g_fixed_code(rec_fixed_code).fixed_code;
7661: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25435"';
7662: g_xml_element_table(l_xml_element_count).tagtype := 'A';

Line 8092: fnd_file.put_line(fnd_file.log, 'l_end'||l_end);

8088:
8089: --
8090: -- write_to_clob(p_xml);
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;