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 606: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');

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

Line 639: 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);

635: l_TGL_REVB_ACC_DATE := 'P';
636: end if;
637: close get_tgl_revb_acc_date;
638:
639: 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);
640:
641: -- open get_payroll_dates_csr;
642: -- fetch get_payroll_dates_csr into l_set_of_books_id, l_start_date, l_end_date, l_payroll_id;
643:

Line 657: 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);

653: end if;
654:
655: close get_payroll_id_csr ;
656:
657: 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);
658:
659: /***** Commented the following for bug fix 3098050
660: Following portion had been commented as henceforth from this bug fix onwards, BG/SOB values would
661: be passed as parameters to the corresponding concurrenct request.

Line 705: 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 );

701: OPEN emphours_config_cur;
702: FETCH emphours_config_cur INTO g_uom;
703: CLOSE emphours_config_cur;
704:
705: 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 );
706:
707: OPEN ee_ci_mapping_cur;
708: FETCH ee_ci_mapping_cur INTO l_gl_column, l_pt_column, l_tk_column, l_aw_column, l_eo_column, l_et_column;
709: CLOSE ee_ci_mapping_cur;

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

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

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

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

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

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

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

827: close get_payroll_assig_actions_csr;
828:
829: open get_payroll_assig_actions_csr;
830:
831: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' **************************************************************');
832: hr_utility.trace(' **************************************************************');
833:
834: LOOP
835:

Line 858: 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||','||

854: -- Get all transactions from pay_costs table based on
855: -- assignment_action_id we got from assignment actions
856:
857:
858: 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||','||
859: l_assignment_action_id||','||p_time_period_id);
860:
861: hr_utility.trace('l_assignment_id = '||l_assignment_id);
862: hr_utility.trace('l_assignment_action_id = '||l_assignment_action_id);

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

1856: rollback;
1857: retcode := 2;
1858:
1859:
1860: psp_message_s.print_error(p_mode=>FND_FILE.log,
1861: p_print_header=>FND_API.G_TRUE
1862: );
1863:
1864: return;

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

1897:
1898: hr_utility.trace(' Process failed here');
1899: hr_utility.trace('-exception 20- sqlerrm = '||sqlerrm);
1900:
1901: psp_message_s.print_error(p_mode=>FND_FILE.log,
1902: p_print_header=>FND_API.G_TRUE
1903: );
1904:
1905:

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

1972: END IF;
1973:
1974: /* added by subha to always print the success message when the program terminates successfully */
1975:
1976: fnd_file.put_line(fnd_file.log,'********************************************************');
1977:
1978: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1979: fnd_msg_pub.add;
1980: retcode:= FND_API.G_RET_STS_SUCCESS;

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

1980: retcode:= FND_API.G_RET_STS_SUCCESS;
1981:
1982: COMMIT;
1983:
1984: psp_message_s.print_error(p_mode=>FND_FILE.log,
1985: p_print_header=>FND_API.G_FALSE);
1986:
1987: fnd_file.put_line(fnd_file.log,'********************************************************');
1988: fnd_file.put_line(fnd_file.log, '');

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

1983:
1984: psp_message_s.print_error(p_mode=>FND_FILE.log,
1985: p_print_header=>FND_API.G_FALSE);
1986:
1987: fnd_file.put_line(fnd_file.log,'********************************************************');
1988: fnd_file.put_line(fnd_file.log, '');
1989:
1990: l_count := 0;
1991: l_heading := null;

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

1984: psp_message_s.print_error(p_mode=>FND_FILE.log,
1985: p_print_header=>FND_API.G_FALSE);
1986:
1987: fnd_file.put_line(fnd_file.log,'********************************************************');
1988: fnd_file.put_line(fnd_file.log, '');
1989:
1990: l_count := 0;
1991: l_heading := null;
1992: hr_utility.trace(' before get_import_summary_heading');

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

1989:
1990: l_count := 0;
1991: l_heading := null;
1992: hr_utility.trace(' before get_import_summary_heading');
1993: fnd_file.put_line(fnd_file.log, ' ');
1994: fnd_file.put_line(fnd_file.log, ' ');
1995: fnd_file.put_line(fnd_file.log, ' ');
1996: open get_import_summary_heading;
1997: loop

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

1990: l_count := 0;
1991: l_heading := null;
1992: hr_utility.trace(' before get_import_summary_heading');
1993: fnd_file.put_line(fnd_file.log, ' ');
1994: fnd_file.put_line(fnd_file.log, ' ');
1995: fnd_file.put_line(fnd_file.log, ' ');
1996: open get_import_summary_heading;
1997: loop
1998: fetch get_import_summary_heading into l_temp_heading;

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

1991: l_heading := null;
1992: hr_utility.trace(' before get_import_summary_heading');
1993: fnd_file.put_line(fnd_file.log, ' ');
1994: fnd_file.put_line(fnd_file.log, ' ');
1995: fnd_file.put_line(fnd_file.log, ' ');
1996: open get_import_summary_heading;
1997: loop
1998: fetch get_import_summary_heading into l_temp_heading;
1999: if get_import_summary_heading%notfound then

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

2000: close get_import_summary_heading;
2001: exit;
2002: end if;
2003: if l_count = 0 then
2004: fnd_file.put_line(fnd_file.log, l_temp_heading||':');
2005: fnd_file.put_line(fnd_file.log, ' ');
2006: l_count := l_count + 1;
2007: else
2008: if l_count = 1 then

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

2001: exit;
2002: end if;
2003: if l_count = 0 then
2004: fnd_file.put_line(fnd_file.log, l_temp_heading||':');
2005: fnd_file.put_line(fnd_file.log, ' ');
2006: l_count := l_count + 1;
2007: else
2008: if l_count = 1 then
2009: l_heading := l_heading || rpad(l_temp_heading,38)||' ';

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

2017: end loop;
2018: open get_master_rec_mesg;
2019: fetch get_master_rec_mesg into l_master_period_message;
2020: close get_master_rec_mesg;
2021: fnd_file.put_line(fnd_file.log, l_master_period_message);
2022: fnd_file.put_line(fnd_file.log, l_heading);
2023: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
2024:
2025: open get_import_summary;

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

2018: open get_master_rec_mesg;
2019: fetch get_master_rec_mesg into l_master_period_message;
2020: close get_master_rec_mesg;
2021: fnd_file.put_line(fnd_file.log, l_master_period_message);
2022: fnd_file.put_line(fnd_file.log, l_heading);
2023: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
2024:
2025: open get_import_summary;
2026: loop

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

2019: fetch get_master_rec_mesg into l_master_period_message;
2020: close get_master_rec_mesg;
2021: fnd_file.put_line(fnd_file.log, l_master_period_message);
2022: fnd_file.put_line(fnd_file.log, l_heading);
2023: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
2024:
2025: open get_import_summary;
2026: loop
2027: fetch get_import_summary into l_asg_count, l_action_type, l_period_name, l_parent_control_id;

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

2029: close get_import_summary;
2030: exit;
2031: end if;
2032: if l_parent_control_id is null then
2033: fnd_file.put_line(fnd_file.log, rpad(l_period_name,38) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));
2034: else
2035: fnd_file.put_line(fnd_file.log,' '|| rpad(l_period_name,34) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));
2036: end if;
2037: end loop;

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

2031: end if;
2032: if l_parent_control_id is null then
2033: fnd_file.put_line(fnd_file.log, rpad(l_period_name,38) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));
2034: else
2035: fnd_file.put_line(fnd_file.log,' '|| rpad(l_period_name,34) ||' '|| rpad(l_action_type,22)||' '|| lpad(l_asg_count, 10));
2036: end if;
2037: end loop;
2038:
2039:

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

2036: end if;
2037: end loop;
2038:
2039:
2040: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
2041: fnd_file.put_line(fnd_file.log, '');
2042: fnd_file.put_line(fnd_file.log, '');
2043: fnd_file.put_line(fnd_file.log, '');
2044: hr_utility.trace(' Leaving IMPORT_PAYTRANS');

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

2037: end loop;
2038:
2039:
2040: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
2041: fnd_file.put_line(fnd_file.log, '');
2042: fnd_file.put_line(fnd_file.log, '');
2043: fnd_file.put_line(fnd_file.log, '');
2044: hr_utility.trace(' Leaving IMPORT_PAYTRANS');
2045:

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

2038:
2039:
2040: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
2041: fnd_file.put_line(fnd_file.log, '');
2042: fnd_file.put_line(fnd_file.log, '');
2043: fnd_file.put_line(fnd_file.log, '');
2044: hr_utility.trace(' Leaving IMPORT_PAYTRANS');
2045:
2046: EXCEPTION

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

2039:
2040: fnd_file.put_line(fnd_file.log, '------------------------------------------------------------------------------');
2041: fnd_file.put_line(fnd_file.log, '');
2042: fnd_file.put_line(fnd_file.log, '');
2043: fnd_file.put_line(fnd_file.log, '');
2044: hr_utility.trace(' Leaving IMPORT_PAYTRANS');
2045:
2046: EXCEPTION
2047: WHEN NO_DATA_FOUND then

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

2052: fnd_msg_pub.add;
2053: retcode:= FND_API.G_RET_STS_SUCCESS;
2054:
2055:
2056: psp_message_s.print_error(p_mode=>FND_FILE.log,
2057: p_print_header=>FND_API.G_FALSE);
2058: return;
2059:
2060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

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

2061: retcode := 2;
2062: rollback;
2063:
2064:
2065: psp_message_s.print_error(p_mode=>FND_FILE.log,
2066: p_print_header=>FND_API.G_TRUE
2067: );
2068:
2069: return;

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

2070: /* Added Exceptions for bug 2056877 */
2071: WHEN NO_PROFILE_EXISTS THEN
2072: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2073: fnd_msg_pub.add;
2074: psp_message_s.print_error(p_mode=>FND_FILE.log,
2075: p_print_header=>FND_API.G_TRUE);
2076: retcode := 2;
2077:
2078:

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

2079: WHEN NO_VAL_DATE_MATCHES THEN
2080: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');
2081: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2082: fnd_msg_pub.add;
2083: psp_message_s.print_error(p_mode=>FND_FILE.log,
2084: p_print_header=>FND_API.G_TRUE);
2085: retcode := 2;
2086:
2087: WHEN NO_GLOBAL_ACCT_EXISTS THEN

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

2091: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10);
2092: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');
2093: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2094: fnd_msg_pub.add;
2095: psp_message_s.print_error(p_mode=>FND_FILE.log,
2096: p_print_header=>FND_API.G_TRUE);
2097: retcode := 2; --End of Modification for Bug 2056877.
2098:
2099: WHEN OTHERS then

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

2101: rollback;
2102: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','IMPORT_PAY_TRNS');
2103:
2104:
2105: psp_message_s.print_error(p_mode=>FND_FILE.log,
2106: p_print_header=>FND_API.G_TRUE
2107: );
2108:
2109: return;