DBA Data[Home] [Help]

APPS.IEX_CURRENCY_PVT dependencies on GL_CURRENCY_API

Line 122: WHEN GL_CURRENCY_API.NO_RATE THEN

118: x_precision := g_precision_tab(i);
119: x_mau := g_mau_tab(i);
120:
121: EXCEPTION
122: WHEN GL_CURRENCY_API.NO_RATE THEN
123: ROLLBACK TO Get_Currency_Details_PVT;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
126: FND_MSG_PUB.ADD;

Line 131: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

127: FND_MSG_PUB.Count_And_Get(
128: p_encoded => FND_API.G_FALSE,
129: p_count => x_msg_count,
130: p_data => x_msg_data);
131: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
132: ROLLBACK TO Get_Currency_Details_PVT;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
135: FND_MSG_PUB.ADD;

Line 242: WHEN GL_CURRENCY_API.NO_RATE THEN

238: ELSE
239: x_rounded_amount := ROUND( l_amount, l_precision);
240: END IF;
241: EXCEPTION
242: WHEN GL_CURRENCY_API.NO_RATE THEN
243: ROLLBACK TO Curr_Round_Amount_PVT;
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
246: FND_MSG_PUB.ADD;

Line 251: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

247: FND_MSG_PUB.Count_And_Get(
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
252: ROLLBACK TO Curr_Round_Amount_PVT;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
255: FND_MSG_PUB.ADD;

Line 489: WHEN GL_CURRENCY_API.NO_RATE THEN

485: l_curr_rec.minimum_accountable_unit;
486: END IF;
487:
488: EXCEPTION
489: WHEN GL_CURRENCY_API.NO_RATE THEN
490: ROLLBACK TO Functional_Amount_PVT;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
493: FND_MSG_PUB.ADD;

Line 498: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_msg_count,
497: p_data => x_msg_data);
498: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
499: ROLLBACK TO Functional_Amount_PVT;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
502: FND_MSG_PUB.ADD;

Line 656: WHEN GL_CURRENCY_API.NO_RATE THEN

652: END IF;
653:
654:
655: EXCEPTION
656: WHEN GL_CURRENCY_API.NO_RATE THEN
657: ROLLBACK TO Func_Amt_Rate_PVT;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
660: FND_MSG_PUB.ADD;

Line 665: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

661: FND_MSG_PUB.Count_And_Get(
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data);
665: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
666: ROLLBACK TO Func_Amt_Rate_PVT;
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
669: FND_MSG_PUB.ADD;

Line 852: WHEN GL_CURRENCY_API.NO_RATE THEN

848: END IF;
849:
850:
851: EXCEPTION
852: WHEN GL_CURRENCY_API.NO_RATE THEN
853: ROLLBACK TO Func_Amt_Curr_Pvt;
854: x_return_status := FND_API.G_RET_STS_ERROR;
855: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
856: FND_MSG_PUB.ADD;

Line 861: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
862: ROLLBACK TO Func_Amt_Curr_Pvt;
863: x_return_status := FND_API.G_RET_STS_ERROR;
864: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
865: FND_MSG_PUB.ADD;

Line 966: x_amount_converted := gl_currency_api.convert_amount(x_from_currency => l_from_currency,

962: -- Initialize API return status to success
963: x_return_status := FND_API.G_RET_STS_SUCCESS;
964:
965:
966: x_amount_converted := gl_currency_api.convert_amount(x_from_currency => l_from_currency,
967: x_to_currency => l_to_currency,
968: x_conversion_date => l_conversion_date,
969: x_conversion_type => l_conversion_type,
970: x_amount => l_amount_original);

Line 973: WHEN GL_CURRENCY_API.NO_RATE THEN

969: x_conversion_type => l_conversion_type,
970: x_amount => l_amount_original);
971:
972: EXCEPTION
973: WHEN GL_CURRENCY_API.NO_RATE THEN
974: ROLLBACK TO Convert_Amount_Curr_PVT;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
977: FND_MSG_PUB.ADD;

Line 982: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

978: FND_MSG_PUB.Count_And_Get(
979: p_encoded => FND_API.G_FALSE,
980: p_count => x_msg_count,
981: p_data => x_msg_data);
982: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
983: ROLLBACK TO Convert_Amount_Curr_PVT;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
986: FND_MSG_PUB.ADD;

Line 1089: x_amount_converted := gl_currency_api.convert_amount(x_set_of_books_id => p_set_of_books_id,

1085: -- Initialize API return status to success
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;
1087:
1088:
1089: x_amount_converted := gl_currency_api.convert_amount(x_set_of_books_id => p_set_of_books_id,
1090: x_from_currency => p_from_currency,
1091: x_conversion_date => p_conversion_date,
1092: x_conversion_type => p_conversion_type,
1093: x_amount => p_amount_original);

Line 1096: WHEN GL_CURRENCY_API.NO_RATE THEN

1092: x_conversion_type => p_conversion_type,
1093: x_amount => p_amount_original);
1094:
1095: EXCEPTION
1096: WHEN GL_CURRENCY_API.NO_RATE THEN
1097: ROLLBACK TO Convert_Amount_Sob_PVT;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1100: FND_MSG_PUB.ADD;

Line 1105: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

1101: FND_MSG_PUB.Count_And_Get(
1102: p_encoded => FND_API.G_FALSE,
1103: p_count => x_msg_count,
1104: p_data => x_msg_data);
1105: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1106: ROLLBACK TO Convert_Amount_Sob_PVT;
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
1109: FND_MSG_PUB.ADD;

Line 1209: -- WHEN GL_CURRENCY_API.NO_RATE THEN

1205:
1206: x_functional_currency := g_functional_currency;
1207:
1208: EXCEPTION
1209: -- WHEN GL_CURRENCY_API.NO_RATE THEN
1210: -- ROLLBACK TO Funct_Curr_PVT;
1211: -- x_return_status := FND_API.G_RET_STS_ERROR;
1212: -- FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1213: -- FND_MSG_PUB.ADD;

Line 1218: -- WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

1214: -- FND_MSG_PUB.Count_And_Get(
1215: -- p_encoded => FND_API.G_FALSE,
1216: -- p_count => x_msg_count,
1217: -- p_data => x_msg_data);
1218: -- WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1219: -- ROLLBACK TO Funct_Curr_PVT;
1220: -- x_return_status := FND_API.G_RET_STS_ERROR;
1221: -- FND_MESSAGE.SET_NAME('SQLGL', 'GL INVALID CURRENCY CODE');
1222: -- FND_MSG_PUB.ADD;

Line 1315: WHEN GL_CURRENCY_API.NO_RATE THEN

1311:
1312: x_format_mask := FND_CURRENCY.Get_Format_Mask(l_currency_code, l_field_length);
1313:
1314: EXCEPTION
1315: WHEN GL_CURRENCY_API.NO_RATE THEN
1316: ROLLBACK TO Get_Format_Mask_PVT;
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: FND_MESSAGE.SET_NAME('SQLGL', 'GL_JE_INVALID_CONVERSION_INFO');
1319: FND_MSG_PUB.ADD;