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;
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:
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, '');
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
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;
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:
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
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
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;