eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_BAL_PKG dependencies on FND_API

Line 512: l_return_val := FND_API.G_RET_STS_SUCCESS;

508: l_status VARCHAR2(1);
509: l_industry VARCHAR2(1);
510: BEGIN
511:
512: l_return_val := FND_API.G_RET_STS_SUCCESS;
513:
514: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
515: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_init.begin', 'begin');
516: END IF;

Line 519: IF g_debug = FND_API.G_TRUE THEN

515: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_init.begin', 'begin');
516: END IF;
517: -- Retrieve the actual FUN schema name from the current installation
518: l_boolean := FND_INSTALLATION.GET_APP_INFO('FUN', l_status, l_industry, g_fun_schema);
519: IF g_debug = FND_API.G_TRUE THEN
520: -- Delete data stored in temporary tables
521: truncate_tables;
522: END IF;
523:

Line 603: l_return_val := FND_API.G_RET_STS_SUCCESS;

599: SELECT * FROM fun_bal_results_gt;
600: CURSOR l_errors_cursor IS
601: SELECT * FROM fun_bal_errors_gt;
602: BEGIN
603: l_return_val := FND_API.G_RET_STS_SUCCESS;
604:
605: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
606: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_finalize.begin', 'begin');
607: END IF;

Line 627: IF g_debug = FND_API.G_TRUE THEN

623: entered_amt_cr = DECODE(entered_amt_cr, NULL, DECODE(accounted_amt_cr, NULL, entered_amt_cr, 0), entered_amt_cr),
624: accounted_amt_dr = DECODE(accounted_amt_dr, NULL, DECODE(entered_amt_dr, NULL, accounted_amt_dr, 0), accounted_amt_dr),
625: accounted_amt_cr = DECODE(accounted_amt_cr, NULL, DECODE(entered_amt_cr, NULL, accounted_amt_cr, 0), accounted_amt_cr);
626:
627: IF g_debug = FND_API.G_TRUE THEN
628: OPEN l_headers_cursor;
629: FETCH l_headers_cursor BULK COLLECT INTO l_headers_tab;
630: l_headers_count := l_headers_cursor%ROWCOUNT;
631: CLOSE l_headers_cursor;

Line 653: l_return_val := FND_API.G_RET_STS_ERROR;

649: FROM fun_bal_errors_gt;
650: END IF;
651:
652: IF l_errors_count > 0 THEN
653: l_return_val := FND_API.G_RET_STS_ERROR;
654: END IF;
655:
656: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_finalize.end', 'end');

Line 836: IF g_debug = FND_API.G_TRUE THEN

832: AND le_bsv_map.le_id = -99;
833:
834: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LE_BSV_MAP_GT');
835:
836: IF g_debug = FND_API.G_TRUE THEN
837: OPEN l_le_bsv_map_cursor;
838: FETCH l_le_bsv_map_cursor BULK COLLECT INTO l_le_bsv_map_tab;
839: l_le_bsv_map_count := l_le_bsv_map_cursor%ROWCOUNT;
840: CLOSE l_le_bsv_map_cursor;

Line 1439: IF g_debug = FND_API.G_TRUE THEN

1435: NULL) = accts.to_le_id
1436: OR
1437: accts.to_le_id = -99));
1438:
1439: IF g_debug = FND_API.G_TRUE THEN
1440: OPEN l_inter_int_cursor;
1441: FETCH l_inter_int_cursor BULK COLLECT INTO l_inter_int_tab;
1442: l_inter_int_count := l_inter_int_cursor%ROWCOUNT;
1443: CLOSE l_inter_int_cursor;

Line 1940: RETURN FND_API.G_RET_STS_SUCCESS;

1936: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1937: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_inter_bal.end', 'end');
1938: END IF;
1939:
1940: RETURN FND_API.G_RET_STS_SUCCESS;
1941: END do_inter_bal;
1942:
1943: FUNCTION do_intra_bal RETURN VARCHAR2 IS
1944: l_le_bsv_map_tab intra_le_bsv_map_tab_type;

Line 2449: IF g_debug = FND_API.G_TRUE THEN

2445: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
2446: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_intra_bal.get_ccid.end', 'end');
2447: END IF;
2448:
2449: IF g_debug = FND_API.G_TRUE THEN
2450: OPEN l_le_bsv_map_cursor;
2451: FETCH l_le_bsv_map_cursor BULK COLLECT INTO l_le_bsv_map_tab;
2452: l_le_bsv_map_count := l_le_bsv_map_cursor%ROWCOUNT;
2453: CLOSE l_le_bsv_map_cursor;

Line 2546: IF g_debug = FND_API.G_TRUE THEN

2542: SUM(DECODE(lines.exchange_rate, NULL, NVL(lines.entered_amt_dr, 0), 0))));
2543:
2544: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_INTRA_INT_GT');
2545:
2546: IF g_debug = FND_API.G_TRUE THEN
2547: OPEN l_intra_int_cursor;
2548: FETCH l_intra_int_cursor BULK COLLECT INTO l_intra_int_tab;
2549: l_intra_int_count := l_intra_int_cursor%ROWCOUNT;
2550: CLOSE l_intra_int_cursor;

Line 2800: RETURN FND_API.G_RET_STS_SUCCESS;

2796: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
2797: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_intra_bal.end', 'end');
2798: END IF;
2799:
2800: RETURN FND_API.G_RET_STS_SUCCESS;
2801: END do_intra_bal;
2802:
2803:
2804: PROCEDURE journal_balancing

Line 2829: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2825: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.journal_balancing.begin', 'begin');
2826: END IF;
2827:
2828: -- Standard call to check for call compatibility.
2829: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2830: p_api_version,
2831: l_api_name,
2832: G_PKG_NAME )
2833: THEN

Line 2834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2830: p_api_version,
2831: l_api_name,
2832: G_PKG_NAME )
2833: THEN
2834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2835: END IF;
2836:
2837: -- Initialize message list if p_init_msg_list is set to TRUE.
2838: IF FND_API.to_Boolean( nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 2838: IF FND_API.to_Boolean( nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

2834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2835: END IF;
2836:
2837: -- Initialize message list if p_init_msg_list is set to TRUE.
2838: IF FND_API.to_Boolean( nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2839: FND_MSG_PUB.initialize;
2840: END IF;
2841:
2842: -- Initialize API return status to success

Line 2843: x_return_status := FND_API.G_RET_STS_SUCCESS;

2839: FND_MSG_PUB.initialize;
2840: END IF;
2841:
2842: -- Initialize API return status to success
2843: x_return_status := FND_API.G_RET_STS_SUCCESS;
2844: -- API body
2845: g_product_code := p_product_code;
2846: g_debug := nvl(p_debug,FND_API.G_FALSE);
2847: l_return_status := do_init;

Line 2846: g_debug := nvl(p_debug,FND_API.G_FALSE);

2842: -- Initialize API return status to success
2843: x_return_status := FND_API.G_RET_STS_SUCCESS;
2844: -- API body
2845: g_product_code := p_product_code;
2846: g_debug := nvl(p_debug,FND_API.G_FALSE);
2847: l_return_status := do_init;
2848:
2849: l_return_status := do_inter_bal;
2850:

Line 2865: WHEN FND_API.G_EXC_ERROR THEN

2861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.journal_balancing.end', 'end');
2862: END IF;
2863:
2864: EXCEPTION
2865: WHEN FND_API.G_EXC_ERROR THEN
2866: do_save_in_error;
2867: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN
2868: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'fun.plsql.fun_bal_pkg.journal_balancing.error', SUBSTR(SQLERRM,1, 4000));
2869: END IF;

Line 2870: x_return_status := FND_API.G_RET_STS_ERROR ;

2866: do_save_in_error;
2867: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN
2868: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'fun.plsql.fun_bal_pkg.journal_balancing.error', SUBSTR(SQLERRM,1, 4000));
2869: END IF;
2870: x_return_status := FND_API.G_RET_STS_ERROR ;
2871: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2872: p_data => x_msg_data);
2873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2874: do_save_in_error;

Line 2873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2869: END IF;
2870: x_return_status := FND_API.G_RET_STS_ERROR ;
2871: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2872: p_data => x_msg_data);
2873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2874: do_save_in_error;
2875: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN
2876: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'fun.plsql.fun_bal_pkg.journal_balancing.unexpected_error_norm', SUBSTR(SQLCODE ||
2877: ' : ' || SQLERRM,1, 4000));

Line 2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2875: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN
2876: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'fun.plsql.fun_bal_pkg.journal_balancing.unexpected_error_norm', SUBSTR(SQLCODE ||
2877: ' : ' || SQLERRM,1, 4000));
2878: END IF;
2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2880: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2881: p_data => x_msg_data);
2882: WHEN OTHERS THEN
2883: do_save_in_error;

Line 2884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2880: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2881: p_data => x_msg_data);
2882: WHEN OTHERS THEN
2883: do_save_in_error;
2884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2885: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN
2886: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'fun.plsql.fun_bal_pkg.journal_balancing.unexpected_error_others', SUBSTR(SQLCODE ||
2887: ' : ' || SQLERRM,1, 4000));
2888: END IF;