APPS.PSP_SUM_TRANS dependencies on GL_JE_SOURCES

Line 1409: get_gl_je_sources(l_user_je_source_name,

1405: BEGIN
1406:
1407: -- get the source name
1408: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered transfer_to_gl_interface');
1409: get_gl_je_sources(l_user_je_source_name,
1410: l_return_status);
1411: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1413: END IF;

Line 1719: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

1715: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1716: p_return_status := fnd_api.g_ret_sts_unexp_error;
1717: END;
1718:
1719: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1720: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
1721: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1722: l_error VARCHAR2(100);
1723: l_product VARCHAR2(3);

Line 1720: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,

1716: p_return_status := fnd_api.g_ret_sts_unexp_error;
1717: END;
1718:
1719: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1720: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
1721: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1722: l_error VARCHAR2(100);
1723: l_product VARCHAR2(3);
1724: BEGIN

Line 1727: FROM gl_je_sources

1723: l_product VARCHAR2(3);
1724: BEGIN
1725: SELECT user_je_source_name
1726: INTO p_user_je_source_name
1727: FROM gl_je_sources
1728: WHERE je_source_name = 'OLD';
1729: EXCEPTION
1730: WHEN NO_DATA_FOUND THEN
1731: l_error := 'JE SOURCES = OLD';

Line 1741: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;

1737: p_return_status := fnd_api.g_ret_sts_unexp_error;
1738: WHEN OTHERS THEN
1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1740:
1741: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1743: p_return_status := fnd_api.g_ret_sts_unexp_error;
1744: END;
1745:

Line 1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');

1738: WHEN OTHERS THEN
1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1740:
1741: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1743: p_return_status := fnd_api.g_ret_sts_unexp_error;
1744: END;
1745:
1746: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 2060: get_gl_je_sources(l_user_je_source_name,

2056:
2057: -- get the source name
2058: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling get_gl_je_source');
2059:
2060: get_gl_je_sources(l_user_je_source_name,
2061: l_return_status);
2062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: END IF;

Line 2380: get_gl_je_sources(l_user_je_source_name,

2376:
2377: END LOOP;
2378: END LOOP;
2379: ---2445196: cleanup gl interface b'cos rejection is available in rejected summary lines
2380: get_gl_je_sources(l_user_je_source_name,
2381: l_return_status);
2382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2384: END IF;