DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on GL_JE_SOURCES

Line 1324: get_gl_je_sources(l_user_je_source_name,

1320: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Entering transfer_to_gl_interface ');
1321:
1322:
1323: -- get the source name
1324: get_gl_je_sources(l_user_je_source_name,
1325: l_return_status);
1326: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;

Line 1564: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

1560: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GL_INTERFACE');
1561: p_return_status := fnd_api.g_ret_sts_unexp_error;
1562: END;
1563:
1564: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1565: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
1566: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1567: -- Included the following cursor for bug fix 1765678
1568: CURSOR user_je_source_name IS

Line 1565: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,

1561: p_return_status := fnd_api.g_ret_sts_unexp_error;
1562: END;
1563:
1564: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1565: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,
1566: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1567: -- Included the following cursor for bug fix 1765678
1568: CURSOR user_je_source_name IS
1569: SELECT user_je_source_name

Line 1570: FROM gl_je_sources

1566: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1567: -- Included the following cursor for bug fix 1765678
1568: CURSOR user_je_source_name IS
1569: SELECT user_je_source_name
1570: FROM gl_je_sources
1571: WHERE je_source_name = 'OLD';
1572: l_error VARCHAR2(100);
1573: l_product VARCHAR2(3);
1574: BEGIN

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

1596: -- fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1597: -- fnd_message.set_token('ERROR',l_error);
1598: -- fnd_message.set_token('PRODUCT',l_product);
1599: -- fnd_msg_pub.add;
1600: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1601: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1602: p_return_status := fnd_api.g_ret_sts_unexp_error;
1603: WHEN OTHERS THEN
1604: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;

Line 1601: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');

1597: -- fnd_message.set_token('ERROR',l_error);
1598: -- fnd_message.set_token('PRODUCT',l_product);
1599: -- fnd_msg_pub.add;
1600: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1601: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1602: p_return_status := fnd_api.g_ret_sts_unexp_error;
1603: WHEN OTHERS THEN
1604: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1605: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');

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

1600: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1601: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1602: p_return_status := fnd_api.g_ret_sts_unexp_error;
1603: WHEN OTHERS THEN
1604: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1605: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1606: p_return_status := fnd_api.g_ret_sts_unexp_error;
1607: END;
1608:

Line 1605: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');

1601: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1602: p_return_status := fnd_api.g_ret_sts_unexp_error;
1603: WHEN OTHERS THEN
1604: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1605: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1606: p_return_status := fnd_api.g_ret_sts_unexp_error;
1607: END;
1608:
1609: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 4586: get_gl_je_sources(l_user_je_source_name,

4582: end if;
4583:
4584: if (l_gl_phase = 'GL_Tie_Back') then
4585: -- get the source name -- Added for 2133056
4586: get_gl_je_sources(l_user_je_source_name,
4587: l_return_status);
4588: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: END IF;