DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on GL_CURRENCY_API

Line 566: gl_currency_api.convert_amount(l_min_curr_code,

562: IF l_min_amt = 0 OR l_min_amt IS NULL THEN
563: RETURN;
564: END IF;
565: IF ABS(NVL(p_trx_amount_cr, p_trx_amount_dr)) <
566: gl_currency_api.convert_amount(l_min_curr_code,
567: p_currency_code,
568: p_trx_date,
569: l_conv_type,
570: l_min_amt)

Line 585: WHEN gl_currency_api.NO_RATE THEN

581: EXCEPTION
582: WHEN FND_API.G_EXC_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_ERROR ;
584:
585: WHEN gl_currency_api.NO_RATE THEN
586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
587: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');
588: FND_MSG_PUB.ADD;
589: END IF;

Line 594: WHEN gl_currency_api.INVALID_CURRENCY THEN

590: Set_Return_Status(x_orig_status => x_return_status,
591: p_new_status => FND_API.G_RET_STS_ERROR);
592: x_return_status := FND_API.G_RET_STS_ERROR ;
593:
594: WHEN gl_currency_api.INVALID_CURRENCY THEN
595: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
596: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CURRENCY');
597: FND_MSG_PUB.ADD;
598: END IF;

Line 1160: /* Not used, replaced by GL currency API

1156: END IF;
1157: Set_Return_Status(x_orig_status => x_return_status,
1158: p_new_status => FND_API.G_RET_STS_ERROR);
1159: END IF;
1160: /* Not used, replaced by GL currency API
1161: OPEN currency_rate_csr;
1162: FETCH currency_rate_csr INTO l_count;
1163: CLOSE currency_rate_csr;
1164: IF l_count < 1 THEN

Line 1173: l_rate := GL_CURRENCY_API.Get_Rate_Sql(p_ledger_id, p_curr_code, p_trx_date, l_conv_type);

1169: Set_Return_Status(x_orig_status => x_return_status,
1170: p_new_status => FND_API.G_RET_STS_ERROR);
1171: END IF;
1172: */
1173: l_rate := GL_CURRENCY_API.Get_Rate_Sql(p_ledger_id, p_curr_code, p_trx_date, l_conv_type);
1174:
1175: IF l_rate = -1 THEN
1176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1177: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');