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.PSP_PAYTRN dependencies on FND_FILE

Line 604: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');

600: BEGIN
601:
602: FND_MSG_PUB.Initialize;
603: ---hr_utility.trace_on('Y','IMPORT-1');
604: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');
605: hr_utility.trace(' Entering IMPORT_PAYTRANS');
606:
607:
608: /*******************************************************************************************

Line 637: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_TGL_REVB_ACC_DATE, l_TGL_DATE_USED='||l_TGL_REVB_ACC_DATE ||','|| l_TGL_DATE_USED);

633: l_TGL_REVB_ACC_DATE := 'P';
634: end if;
635: close get_tgl_revb_acc_date;
636:
637: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_TGL_REVB_ACC_DATE, l_TGL_DATE_USED='||l_TGL_REVB_ACC_DATE ||','|| l_TGL_DATE_USED);
638:
639: -- open get_payroll_dates_csr;
640: -- fetch get_payroll_dates_csr into l_set_of_books_id, l_start_date, l_end_date, l_payroll_id;
641:

Line 655: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_start_date, l_end_date, l_payroll_id='||l_start_date ||','|| l_end_date ||','|| l_payroll_id);

651: end if;
652:
653: close get_payroll_id_csr ;
654:
655: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_start_date, l_end_date, l_payroll_id='||l_start_date ||','|| l_end_date ||','|| l_payroll_id);
656:
657: /***** Commented the following for bug fix 3098050
658: Following portion had been commented as henceforth from this bug fix onwards, BG/SOB values would
659: be passed as parameters to the corresponding concurrenct request.

Line 703: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_sob_currency_code, g_uom ='||g_sob_currency_code ||','|| g_uom );

699: OPEN emphours_config_cur;
700: FETCH emphours_config_cur INTO g_uom;
701: CLOSE emphours_config_cur;
702:
703: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_sob_currency_code, g_uom ='||g_sob_currency_code ||','|| g_uom );
704:
705: OPEN ee_ci_mapping_cur;
706: FETCH ee_ci_mapping_cur INTO l_gl_column, l_pt_column, l_tk_column, l_aw_column, l_eo_column, l_et_column;
707: CLOSE ee_ci_mapping_cur;

Line 714: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_ignore_date_earned = '||g_ignore_date_earned);

710: OPEN ignore_date_earned_cur;
711: FETCH ignore_date_earned_cur INTO g_ignore_date_earned;
712: CLOSE ignore_date_earned_cur;
713:
714: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_ignore_date_earned = '||g_ignore_date_earned);
715:
716: l_column_count := 0;
717: IF (l_pt_column IS NOT NULL) THEN
718: l_column_count := l_column_count + 1;

Line 733: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_column_count ='||l_column_count );

729: IF (l_et_column IS NOT NULL) THEN
730: l_column_count := l_column_count + 1;
731: END IF;
732:
733: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_column_count ='||l_column_count );
734:
735: IF (l_column_count > 1) AND (l_column_count < 4) THEN
736: fnd_message.set_name('PSP', 'PSP_EE_INCOMPLETE_CI');
737: fnd_msg_pub.add;

Line 774: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_clearing_account ='||l_clearing_account );

770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: end if;
772: close get_clearing_account_csr;
773:
774: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_clearing_account ='||l_clearing_account );
775:
776: /* Following code is added for bug 2056877 ,Added validation for generic suspense account */
777: l_return_value := psp_general.find_global_suspense(l_end_date,
778: l_resp_business_group_id,

Line 829: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' **************************************************************');

825: close get_payroll_assig_actions_csr;
826:
827: open get_payroll_assig_actions_csr;
828:
829: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' **************************************************************');
830:
831: LOOP
832:
833: fetch get_payroll_assig_actions_csr into g_payroll_asg_rec;

Line 855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_assigment_id, l_assignment_action_id, p_time_period_id = '||l_assignment_id||','||

851: -- Get all transactions from pay_costs table based on
852: -- assignment_action_id we got from assignment actions
853:
854:
855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_assigment_id, l_assignment_action_id, p_time_period_id = '||l_assignment_id||','||
856: l_assignment_action_id||','||p_time_period_id);
857:
858: OPEN get_pay_costs_csr;
859: FETCH get_pay_costs_csr into g_pay_costs_rec;

Line 1798: psp_message_s.print_error(p_mode=>FND_FILE.log,

1794: rollback;
1795: retcode := 2;
1796:
1797:
1798: psp_message_s.print_error(p_mode=>FND_FILE.log,
1799: p_print_header=>FND_API.G_TRUE
1800: );
1801:
1802: return;

Line 1827: psp_message_s.print_error(p_mode=>FND_FILE.log,

1823: rollback;
1824:
1825: hr_utility.trace(' Process failed here');
1826:
1827: psp_message_s.print_error(p_mode=>FND_FILE.log,
1828: p_print_header=>FND_API.G_TRUE
1829: );
1830:
1831:

Line 1902: fnd_file.put_line(fnd_file.log,'********************************************************');

1898: END IF;
1899:
1900: /* added by subha to always print the success message when the program terminates successfully */
1901:
1902: fnd_file.put_line(fnd_file.log,'********************************************************');
1903:
1904: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1905: fnd_msg_pub.add;
1906: retcode:= FND_API.G_RET_STS_SUCCESS;

Line 1910: psp_message_s.print_error(p_mode=>FND_FILE.log,

1906: retcode:= FND_API.G_RET_STS_SUCCESS;
1907:
1908: COMMIT;
1909:
1910: psp_message_s.print_error(p_mode=>FND_FILE.log,
1911: p_print_header=>FND_API.G_FALSE);
1912:
1913: fnd_file.put_line(fnd_file.log,'********************************************************');
1914: fnd_file.put_line(fnd_file.log, '');

Line 1913: fnd_file.put_line(fnd_file.log,'********************************************************');

1909:
1910: psp_message_s.print_error(p_mode=>FND_FILE.log,
1911: p_print_header=>FND_API.G_FALSE);
1912:
1913: fnd_file.put_line(fnd_file.log,'********************************************************');
1914: fnd_file.put_line(fnd_file.log, '');
1915:
1916: l_count := 0;
1917: l_heading := null;

Line 1914: fnd_file.put_line(fnd_file.log, '');

1910: psp_message_s.print_error(p_mode=>FND_FILE.log,
1911: p_print_header=>FND_API.G_FALSE);
1912:
1913: fnd_file.put_line(fnd_file.log,'********************************************************');
1914: fnd_file.put_line(fnd_file.log, '');
1915:
1916: l_count := 0;
1917: l_heading := null;
1918: hr_utility.trace(' before get_import_summary_heading');

Line 1919: fnd_file.put_line(fnd_file.log, ' ');

1915:
1916: l_count := 0;
1917: l_heading := null;
1918: hr_utility.trace(' before get_import_summary_heading');
1919: fnd_file.put_line(fnd_file.log, ' ');
1920: fnd_file.put_line(fnd_file.log, ' ');
1921: fnd_file.put_line(fnd_file.log, ' ');
1922: open get_import_summary_heading;
1923: loop

Line 1920: fnd_file.put_line(fnd_file.log, ' ');

1916: l_count := 0;
1917: l_heading := null;
1918: hr_utility.trace(' before get_import_summary_heading');
1919: fnd_file.put_line(fnd_file.log, ' ');
1920: fnd_file.put_line(fnd_file.log, ' ');
1921: fnd_file.put_line(fnd_file.log, ' ');
1922: open get_import_summary_heading;
1923: loop
1924: fetch get_import_summary_heading into l_temp_heading;

Line 1921: fnd_file.put_line(fnd_file.log, ' ');

1917: l_heading := null;
1918: hr_utility.trace(' before get_import_summary_heading');
1919: fnd_file.put_line(fnd_file.log, ' ');
1920: fnd_file.put_line(fnd_file.log, ' ');
1921: fnd_file.put_line(fnd_file.log, ' ');
1922: open get_import_summary_heading;
1923: loop
1924: fetch get_import_summary_heading into l_temp_heading;
1925: if get_import_summary_heading%notfound then

Line 1930: fnd_file.put_line(fnd_file.log, l_temp_heading||':');

1926: close get_import_summary_heading;
1927: exit;
1928: end if;
1929: if l_count = 0 then
1930: fnd_file.put_line(fnd_file.log, l_temp_heading||':');
1931: fnd_file.put_line(fnd_file.log, ' ');
1932: l_count := l_count + 1;
1933: else
1934: if l_count = 1 then

Line 1931: fnd_file.put_line(fnd_file.log, ' ');

1927: exit;
1928: end if;
1929: if l_count = 0 then
1930: fnd_file.put_line(fnd_file.log, l_temp_heading||':');
1931: fnd_file.put_line(fnd_file.log, ' ');
1932: l_count := l_count + 1;
1933: else
1934: if l_count = 1 then
1935: l_heading := l_heading || rpad(l_temp_heading,38)||' ';

Line 1947: fnd_file.put_line(fnd_file.log, l_master_period_message);

1943: end loop;
1944: open get_master_rec_mesg;
1945: fetch get_master_rec_mesg into l_master_period_message;
1946: close get_master_rec_mesg;
1947: fnd_file.put_line(fnd_file.log, l_master_period_message);
1948: fnd_file.put_line(fnd_file.log, l_heading);
1949: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
1950:
1951: open get_import_summary;

Line 1948: fnd_file.put_line(fnd_file.log, l_heading);

1944: open get_master_rec_mesg;
1945: fetch get_master_rec_mesg into l_master_period_message;
1946: close get_master_rec_mesg;
1947: fnd_file.put_line(fnd_file.log, l_master_period_message);
1948: fnd_file.put_line(fnd_file.log, l_heading);
1949: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
1950:
1951: open get_import_summary;
1952: loop

Line 1949: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');

1945: fetch get_master_rec_mesg into l_master_period_message;
1946: close get_master_rec_mesg;
1947: fnd_file.put_line(fnd_file.log, l_master_period_message);
1948: fnd_file.put_line(fnd_file.log, l_heading);
1949: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
1950:
1951: open get_import_summary;
1952: loop
1953: fetch get_import_summary into l_asg_count, l_action_type, l_period_name, l_parent_control_id;

Line 1959: fnd_file.put_line(fnd_file.log, rpad(l_period_name,38) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));

1955: close get_import_summary;
1956: exit;
1957: end if;
1958: if l_parent_control_id is null then
1959: fnd_file.put_line(fnd_file.log, rpad(l_period_name,38) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));
1960: else
1961: fnd_file.put_line(fnd_file.log,' '|| rpad(l_period_name,34) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));
1962: end if;
1963: end loop;

Line 1961: fnd_file.put_line(fnd_file.log,' '|| rpad(l_period_name,34) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));

1957: end if;
1958: if l_parent_control_id is null then
1959: fnd_file.put_line(fnd_file.log, rpad(l_period_name,38) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));
1960: else
1961: fnd_file.put_line(fnd_file.log,' '|| rpad(l_period_name,34) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));
1962: end if;
1963: end loop;
1964:
1965:

Line 1966: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');

1962: end if;
1963: end loop;
1964:
1965:
1966: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
1967: fnd_file.put_line(fnd_file.log, '');
1968: fnd_file.put_line(fnd_file.log, '');
1969: fnd_file.put_line(fnd_file.log, '');
1970: hr_utility.trace(' Leaving IMPORT_PAYTRANS');

Line 1967: fnd_file.put_line(fnd_file.log, '');

1963: end loop;
1964:
1965:
1966: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
1967: fnd_file.put_line(fnd_file.log, '');
1968: fnd_file.put_line(fnd_file.log, '');
1969: fnd_file.put_line(fnd_file.log, '');
1970: hr_utility.trace(' Leaving IMPORT_PAYTRANS');
1971:

Line 1968: fnd_file.put_line(fnd_file.log, '');

1964:
1965:
1966: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
1967: fnd_file.put_line(fnd_file.log, '');
1968: fnd_file.put_line(fnd_file.log, '');
1969: fnd_file.put_line(fnd_file.log, '');
1970: hr_utility.trace(' Leaving IMPORT_PAYTRANS');
1971:
1972: EXCEPTION

Line 1969: fnd_file.put_line(fnd_file.log, '');

1965:
1966: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
1967: fnd_file.put_line(fnd_file.log, '');
1968: fnd_file.put_line(fnd_file.log, '');
1969: fnd_file.put_line(fnd_file.log, '');
1970: hr_utility.trace(' Leaving IMPORT_PAYTRANS');
1971:
1972: EXCEPTION
1973: WHEN NO_DATA_FOUND then

Line 1982: psp_message_s.print_error(p_mode=>FND_FILE.log,

1978: fnd_msg_pub.add;
1979: retcode:= FND_API.G_RET_STS_SUCCESS;
1980:
1981:
1982: psp_message_s.print_error(p_mode=>FND_FILE.log,
1983: p_print_header=>FND_API.G_FALSE);
1984: return;
1985:
1986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1991: psp_message_s.print_error(p_mode=>FND_FILE.log,

1987: retcode := 2;
1988: rollback;
1989:
1990:
1991: psp_message_s.print_error(p_mode=>FND_FILE.log,
1992: p_print_header=>FND_API.G_TRUE
1993: );
1994:
1995: return;

Line 2000: psp_message_s.print_error(p_mode=>FND_FILE.log,

1996: /* Added Exceptions for bug 2056877 */
1997: WHEN NO_PROFILE_EXISTS THEN
1998: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
1999: fnd_msg_pub.add;
2000: psp_message_s.print_error(p_mode=>FND_FILE.log,
2001: p_print_header=>FND_API.G_TRUE);
2002: retcode := 2;
2003:
2004:

Line 2009: psp_message_s.print_error(p_mode=>FND_FILE.log,

2005: WHEN NO_VAL_DATE_MATCHES THEN
2006: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');
2007: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2008: fnd_msg_pub.add;
2009: psp_message_s.print_error(p_mode=>FND_FILE.log,
2010: p_print_header=>FND_API.G_TRUE);
2011: retcode := 2;
2012:
2013: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 2021: psp_message_s.print_error(p_mode=>FND_FILE.log,

2017: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10);
2018: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');
2019: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2020: fnd_msg_pub.add;
2021: psp_message_s.print_error(p_mode=>FND_FILE.log,
2022: p_print_header=>FND_API.G_TRUE);
2023: retcode := 2; --End of Modification for Bug 2056877.
2024:
2025: WHEN OTHERS then

Line 2031: psp_message_s.print_error(p_mode=>FND_FILE.log,

2027: rollback;
2028: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','IMPORT_PAY_TRNS');
2029:
2030:
2031: psp_message_s.print_error(p_mode=>FND_FILE.log,
2032: p_print_header=>FND_API.G_TRUE
2033: );
2034:
2035: return;