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 564: l_return_val := FND_API.G_RET_STS_SUCCESS;

560: l_status VARCHAR2(1);
561: l_industry VARCHAR2(1);
562: BEGIN
563:
564: l_return_val := FND_API.G_RET_STS_SUCCESS;
565:
566: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_init.begin', 'begin');
568: END IF;

Line 571: IF g_debug = FND_API.G_TRUE THEN

567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_init.begin', 'begin');
568: END IF;
569: -- Retrieve the actual FUN schema name from the current installation
570: l_boolean := FND_INSTALLATION.GET_APP_INFO('FUN', l_status, l_industry, g_fun_schema);
571: IF g_debug = FND_API.G_TRUE THEN
572: -- Delete data stored in temporary tables
573: truncate_tables;
574: END IF;
575:

Line 669: l_return_val := FND_API.G_RET_STS_SUCCESS;

665: SELECT * FROM fun_bal_results_gt;
666: CURSOR l_errors_cursor IS
667: SELECT * FROM fun_bal_errors_gt;
668: BEGIN
669: l_return_val := FND_API.G_RET_STS_SUCCESS;
670:
671: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
672: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_finalize.begin', 'begin');
673: END IF;

Line 696: IF g_debug = FND_API.G_TRUE THEN

692: accounted_amt_cr = DECODE(accounted_amt_cr, NULL, DECODE(entered_amt_cr, NULL, accounted_amt_cr, 0), accounted_amt_cr),
693: exchange_rate = DECODE(EXCHANGE_RATE, NULL, NULL,
694: DECODE (NVL(ACCOUNTED_AMT_CR, 0), 0, DECODE(NVL(ENTERED_AMT_DR, 0), 0, 1, ACCOUNTED_AMT_DR / ENTERED_AMT_DR)
695: , DECODE(NVL(ENTERED_AMT_CR, 0), 0, 1, ACCOUNTED_AMT_CR / ENTERED_AMT_CR)));
696: IF g_debug = FND_API.G_TRUE THEN
697: OPEN l_headers_cursor;
698: FETCH l_headers_cursor BULK COLLECT INTO l_headers_tab;
699: l_headers_count := l_headers_cursor%ROWCOUNT;
700: CLOSE l_headers_cursor;

Line 722: l_return_val := FND_API.G_RET_STS_ERROR;

718: FROM fun_bal_errors_gt;
719: END IF;
720:
721: IF l_errors_count > 0 THEN
722: l_return_val := FND_API.G_RET_STS_ERROR;
723: END IF;
724:
725: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_finalize.end', 'end');

Line 909: IF g_debug = FND_API.G_TRUE THEN

905: AND le_bsv_map.le_id = -99;
906:
907: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LE_BSV_MAP_GT');
908:
909: IF g_debug = FND_API.G_TRUE THEN
910: OPEN l_le_bsv_map_cursor;
911: FETCH l_le_bsv_map_cursor BULK COLLECT INTO l_le_bsv_map_tab;
912: l_le_bsv_map_count := l_le_bsv_map_cursor%ROWCOUNT;
913: CLOSE l_le_bsv_map_cursor;

Line 2395: IF g_debug = FND_API.G_TRUE THEN

2391: NULL) = accts.to_le_id
2392: OR
2393: accts.to_le_id = -99));
2394:
2395: IF g_debug = FND_API.G_TRUE THEN
2396: OPEN l_inter_int_cursor;
2397: FETCH l_inter_int_cursor BULK COLLECT INTO l_inter_int_tab;
2398: l_inter_int_count := l_inter_int_cursor%ROWCOUNT;
2399: CLOSE l_inter_int_cursor;

Line 2900: RETURN FND_API.G_RET_STS_SUCCESS;

2896: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
2897: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_inter_bal.end', 'end');
2898: END IF;
2899:
2900: RETURN FND_API.G_RET_STS_SUCCESS;
2901: END do_inter_bal;
2902:
2903: FUNCTION do_intra_bal RETURN VARCHAR2 IS
2904: l_le_bsv_map_tab intra_le_bsv_map_tab_type;

Line 3416: IF g_debug = FND_API.G_TRUE THEN

3412: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
3413: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_intra_bal.get_ccid.end', 'end');
3414: END IF;
3415:
3416: IF g_debug = FND_API.G_TRUE THEN
3417: OPEN l_le_bsv_map_cursor;
3418: FETCH l_le_bsv_map_cursor BULK COLLECT INTO l_le_bsv_map_tab;
3419: l_le_bsv_map_count := l_le_bsv_map_cursor%ROWCOUNT;
3420: CLOSE l_le_bsv_map_cursor;

Line 3516: IF g_debug = FND_API.G_TRUE THEN

3512: SUM(DECODE(lines.exchange_rate, NULL, NVL(lines.entered_amt_dr, 0), 0))));
3513:
3514: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_INTRA_INT_GT');
3515:
3516: IF g_debug = FND_API.G_TRUE THEN
3517: OPEN l_intra_int_cursor;
3518: FETCH l_intra_int_cursor BULK COLLECT INTO l_intra_int_tab;
3519: l_intra_int_count := l_intra_int_cursor%ROWCOUNT;
3520: CLOSE l_intra_int_cursor;

Line 3771: RETURN FND_API.G_RET_STS_SUCCESS;

3767: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
3768: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_intra_bal.end', 'end');
3769: END IF;
3770:
3771: RETURN FND_API.G_RET_STS_SUCCESS;
3772: END do_intra_bal;
3773:
3774: PROCEDURE unexpected_error
3775: ( ERR_MESSAGE IN VARCHAR2)

Line 3809: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.journal_balancing.begin', 'begin');
3806: END IF;
3807:
3808: -- Standard call to check for call compatibility.
3809: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3810: p_api_version,
3811: l_api_name,
3812: G_PKG_NAME )
3813: THEN

Line 3814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3810: p_api_version,
3811: l_api_name,
3812: G_PKG_NAME )
3813: THEN
3814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3815: END IF;
3816:
3817: -- Initialize message list if p_init_msg_list is set to TRUE.
3818: IF FND_API.to_Boolean( nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

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

3814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3815: END IF;
3816:
3817: -- Initialize message list if p_init_msg_list is set to TRUE.
3818: IF FND_API.to_Boolean( nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3819: FND_MSG_PUB.initialize;
3820: END IF;
3821:
3822: -- Initialize API return status to success

Line 3823: x_return_status := FND_API.G_RET_STS_SUCCESS;

3819: FND_MSG_PUB.initialize;
3820: END IF;
3821:
3822: -- Initialize API return status to success
3823: x_return_status := FND_API.G_RET_STS_SUCCESS;
3824: -- API body
3825: g_product_code := p_product_code;
3826: g_debug := nvl(p_debug,FND_API.G_FALSE);
3827: l_return_status := do_init;

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

3822: -- Initialize API return status to success
3823: x_return_status := FND_API.G_RET_STS_SUCCESS;
3824: -- API body
3825: g_product_code := p_product_code;
3826: g_debug := nvl(p_debug,FND_API.G_FALSE);
3827: l_return_status := do_init;
3828:
3829: l_return_status := do_inter_bal;
3830:

Line 3838: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3834:
3835:
3836: --Begin Bug: 16266089.
3837:
3838: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3839:
3840: fnd_profile.get('FUN_ENABLE_BALANCING_CUSTOM_API', l_balancing_custom_api);
3841:
3842: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

Line 3865: x_return_status := FND_API.G_RET_STS_ERROR;

3861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.journal_balancing', 'l_errors_count : '|| l_errors_count);
3862: END IF;
3863:
3864: IF l_errors_count > 0 THEN
3865: x_return_status := FND_API.G_RET_STS_ERROR;
3866: END IF;
3867:
3868: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
3869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.journal_balancing', 'x_return_status : '|| x_return_status);

Line 3886: WHEN FND_API.G_EXC_ERROR THEN

3882: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.journal_balancing.end', 'end');
3883: END IF;
3884:
3885: EXCEPTION
3886: WHEN FND_API.G_EXC_ERROR THEN
3887: IF g_debug = FND_API.G_TRUE THEN
3888: unexpected_error(SQLERRM);
3889: -- Delete and save data in temporary tables
3890: do_save_in_error;

Line 3887: IF g_debug = FND_API.G_TRUE THEN

3883: END IF;
3884:
3885: EXCEPTION
3886: WHEN FND_API.G_EXC_ERROR THEN
3887: IF g_debug = FND_API.G_TRUE THEN
3888: unexpected_error(SQLERRM);
3889: -- Delete and save data in temporary tables
3890: do_save_in_error;
3891: END IF;

Line 3895: x_return_status := FND_API.G_RET_STS_ERROR ;

3891: END IF;
3892: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN
3893: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'fun.plsql.fun_bal_pkg.journal_balancing.error', SUBSTR(SQLERRM,1, 4000));
3894: END IF;
3895: x_return_status := FND_API.G_RET_STS_ERROR ;
3896: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3897: p_data => x_msg_data);
3898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3899: unexpected_error(SQLERRM);

Line 3898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3894: END IF;
3895: x_return_status := FND_API.G_RET_STS_ERROR ;
3896: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3897: p_data => x_msg_data);
3898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3899: unexpected_error(SQLERRM);
3900: IF g_debug = FND_API.G_TRUE THEN
3901: -- Delete and save data in temporary tables
3902: do_save_in_error;

Line 3900: IF g_debug = FND_API.G_TRUE THEN

3896: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3897: p_data => x_msg_data);
3898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3899: unexpected_error(SQLERRM);
3900: IF g_debug = FND_API.G_TRUE THEN
3901: -- Delete and save data in temporary tables
3902: do_save_in_error;
3903: END IF;
3904: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN

Line 3908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3904: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN
3905: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'fun.plsql.fun_bal_pkg.journal_balancing.unexpected_error_norm', SUBSTR(SQLCODE ||
3906: ' : ' || SQLERRM,1, 4000));
3907: END IF;
3908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3910: p_data => x_msg_data);
3911: WHEN OTHERS THEN
3912: unexpected_error(SQLERRM);

Line 3913: IF g_debug = FND_API.G_TRUE THEN

3909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3910: p_data => x_msg_data);
3911: WHEN OTHERS THEN
3912: unexpected_error(SQLERRM);
3913: IF g_debug = FND_API.G_TRUE THEN
3914: -- Delete and save data in temporary tables
3915: do_save_in_error;
3916: END IF;
3917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3913: IF g_debug = FND_API.G_TRUE THEN
3914: -- Delete and save data in temporary tables
3915: do_save_in_error;
3916: END IF;
3917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3918: IF (FND_LOG.LEVEL_ERROR>= g_debug_level) THEN
3919: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'fun.plsql.fun_bal_pkg.journal_balancing.unexpected_error_others', SUBSTR(SQLCODE ||
3920: ' : ' || SQLERRM,1, 4000));
3921: END IF;