DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on GL_JE_SOURCES

Line 1230: get_gl_je_sources(l_user_je_source_name,

1226:
1227: BEGIN
1228:
1229: -- get the source name
1230: get_gl_je_sources(l_user_je_source_name,
1231: l_return_status);
1232: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234: END IF;

Line 1457: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

1453: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1454: p_return_status := fnd_api.g_ret_sts_unexp_error;
1455: END;
1456:
1457: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1458: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
1459: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1460: -- Included the following cursor for bug fix 1765678
1461: CURSOR user_je_source_name IS

Line 1458: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,

1454: p_return_status := fnd_api.g_ret_sts_unexp_error;
1455: END;
1456:
1457: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1458: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
1459: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1460: -- Included the following cursor for bug fix 1765678
1461: CURSOR user_je_source_name IS
1462: SELECT user_je_source_name

Line 1463: FROM gl_je_sources

1459: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1460: -- Included the following cursor for bug fix 1765678
1461: CURSOR user_je_source_name IS
1462: SELECT user_je_source_name
1463: FROM gl_je_sources
1464: WHERE je_source_name = 'OLD';
1465: l_error VARCHAR2(100);
1466: l_product VARCHAR2(3);
1467: BEGIN

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

1489: -- fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1490: -- fnd_message.set_token('ERROR',l_error);
1491: -- fnd_message.set_token('PRODUCT',l_product);
1492: -- fnd_msg_pub.add;
1493: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1494: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1495: p_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS THEN
1497: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;

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

1490: -- fnd_message.set_token('ERROR',l_error);
1491: -- fnd_message.set_token('PRODUCT',l_product);
1492: -- fnd_msg_pub.add;
1493: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1494: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1495: p_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS THEN
1497: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1498: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');

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

1493: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1494: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1495: p_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS THEN
1497: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1498: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1499: p_return_status := fnd_api.g_ret_sts_unexp_error;
1500: END;
1501:

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

1494: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1495: p_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS THEN
1497: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1498: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1499: p_return_status := fnd_api.g_ret_sts_unexp_error;
1500: END;
1501:
1502: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 4155: get_gl_je_sources(l_user_je_source_name,

4151: end if;
4152:
4153: if (l_gl_phase = 'GL_Tie_Back') then
4154: -- get the source name -- Added for 2133056
4155: get_gl_je_sources(l_user_je_source_name,
4156: l_return_status);
4157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4159: END IF;