99: -- Initialize message list if p_init_msg_list is set to TRUE.
100:
101: IF FND_API.to_Boolean(p_init_msg_list)
102: THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: -- Initialize API return status to success
107:
130: THEN
131: FND_LOG.MESSAGE(Fnd_Log.Level_Error, l_mod_name, FALSE);
132: END IF;
133: -- ELSE
134: FND_MSG_PUB.ADD;
135: --END IF;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
184: END IF;
185:
186: -- Standard call to get message count and IF count is get message info.
187:
188: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
189: EXCEPTION
190: WHEN FND_API.G_EXC_ERROR THEN
191:
192: --ROLLBACK TO Convert_CurrencyAmount_Utl;
192: --ROLLBACK TO Convert_CurrencyAmount_Utl;
193:
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: x_conv_amount := NULL;
196: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
197: p_data => x_msg_data,
198: p_encoded => 'F');
199: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
200: THEN
210: -- ROLLBACK TO Convert_CurrencyAmount_Utl;
211:
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: x_conv_amount := NULL;
214: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
215: p_data => x_msg_data,
216: p_encoded => 'F');
217: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
218: THEN
227: -- ROLLBACK TO Convert_CurrencyAmount_Utl;
228:
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: x_conv_amount := NULL;
231: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
234: END IF;
235: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: x_conv_amount := NULL;
231: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
234: END IF;
235: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
236: p_data => x_msg_data,
237: p_encoded => 'F');
231: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
234: END IF;
235: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
236: p_data => x_msg_data,
237: p_encoded => 'F');
238: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
239: THEN
334: -- Initialize message list if p_init_msg_list is set to TRUE.
335:
336: IF FND_API.to_Boolean(p_init_msg_list)
337: THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340:
341: -- Initialize API return status to success
342:
367: THEN
368: FND_LOG.MESSAGE(Fnd_Log.Level_Error, l_mod_name, FALSE);
369: END IF;
370: -- ELSE
371: FND_MSG_PUB.ADD;
372: --END IF;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375:
440: END IF;
441:
442: -- Standard call to get message count and IF count is get message info.
443:
444: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
445: EXCEPTION
446: WHEN FND_API.G_EXC_ERROR THEN
447: ROLLBACK TO Compare_MLETotals_Utl;
448: x_return_status := FND_API.G_RET_STS_ERROR;
445: EXCEPTION
446: WHEN FND_API.G_EXC_ERROR THEN
447: ROLLBACK TO Compare_MLETotals_Utl;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
450: p_data => x_msg_data);
451: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
452: THEN
453: FND_LOG.STRING(Fnd_Log.Level_Exception,
458: END IF;
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK TO Compare_MLETotals_Utl;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
463: p_data => x_msg_data);
464: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
465: THEN
466: FND_LOG.STRING(Fnd_Log.Level_Exception,
471: END IF;
472: WHEN OTHERS THEN
473: ROLLBACK TO Compare_MLETotals_Utl;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
476: THEN
477: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
478: END IF;
479: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
473: ROLLBACK TO Compare_MLETotals_Utl;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
476: THEN
477: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
478: END IF;
479: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
480: p_data => x_msg_data);
481: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
476: THEN
477: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
478: END IF;
479: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
480: p_data => x_msg_data);
481: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
482: THEN
483: FND_LOG.STRING(Fnd_Log.Level_Exception,
520: EXCEPTION
521: WHEN TOO_MANY_ROWS THEN
522: l_currency_code := NULL;
523: FND_MESSAGE.SET_NAME('CSD', 'CSD_CST_TOO_MANY_ROWS_CURR');
524: FND_MSG_PUB.ADD;
525: /*
526: FND_MSG_PUB.Count_And_Get
527: (p_count => x_msg_count,
528: p_data => x_msg_data
522: l_currency_code := NULL;
523: FND_MESSAGE.SET_NAME('CSD', 'CSD_CST_TOO_MANY_ROWS_CURR');
524: FND_MSG_PUB.ADD;
525: /*
526: FND_MSG_PUB.Count_And_Get
527: (p_count => x_msg_count,
528: p_data => x_msg_data
529: );*/
530:
531: RETURN l_currency_code;
532: WHEN NO_DATA_FOUND THEN
533: l_currency_code := NULL;
534: FND_MESSAGE.SET_NAME('CSD', 'CSD_CST_NO_DATA_CURR');
535: FND_MSG_PUB.ADD;
536: /*
537: FND_MSG_PUB.Count_And_Get
538: (p_count => x_msg_count,
539: p_data => x_msg_data
533: l_currency_code := NULL;
534: FND_MESSAGE.SET_NAME('CSD', 'CSD_CST_NO_DATA_CURR');
535: FND_MSG_PUB.ADD;
536: /*
537: FND_MSG_PUB.Count_And_Get
538: (p_count => x_msg_count,
539: p_data => x_msg_data
540: );*/
541: