APPS.PSP_SUM_TRANS dependencies on GL_JE_SOURCES

Line 1323: get_gl_je_sources(l_user_je_source_name,

1319: l_table VARCHAR2(100);
1320: BEGIN
1321:
1322: -- get the source name
1323: get_gl_je_sources(l_user_je_source_name,
1324: l_return_status);
1325: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: END IF;

Line 1615: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

1611: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1612: p_return_status := fnd_api.g_ret_sts_unexp_error;
1613: END;
1614:
1615: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1616: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
1617: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1618: l_error VARCHAR2(100);
1619: l_product VARCHAR2(3);

Line 1616: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,

1612: p_return_status := fnd_api.g_ret_sts_unexp_error;
1613: END;
1614:
1615: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1616: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
1617: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1618: l_error VARCHAR2(100);
1619: l_product VARCHAR2(3);
1620: BEGIN

Line 1623: FROM gl_je_sources

1619: l_product VARCHAR2(3);
1620: BEGIN
1621: SELECT user_je_source_name
1622: INTO p_user_je_source_name
1623: FROM gl_je_sources
1624: WHERE je_source_name = 'OLD';
1625: EXCEPTION
1626: WHEN NO_DATA_FOUND THEN
1627: l_error := 'JE SOURCES = OLD';

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

1631: fnd_message.set_token('PRODUCT',l_product);
1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN
1635: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1636: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1637: p_return_status := fnd_api.g_ret_sts_unexp_error;
1638: END;
1639:

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

1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN
1635: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1636: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1637: p_return_status := fnd_api.g_ret_sts_unexp_error;
1638: END;
1639:
1640: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 1941: get_gl_je_sources(l_user_je_source_name,

1937:
1938: --- bug 4328598 -- fix begin
1939:
1940: -- get the source name
1941: get_gl_je_sources(l_user_je_source_name,
1942: l_return_status);
1943: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;

Line 2247: get_gl_je_sources(l_user_je_source_name,

2243:
2244: END LOOP;
2245: END LOOP;
2246: ---2445196: cleanup gl interface b'cos rejection is available in rejected summary lines
2247: get_gl_je_sources(l_user_je_source_name,
2248: l_return_status);
2249: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;