74: END IF;
75:
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF FND_API.to_Boolean(p_init_msg_list) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API return status to success
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
94: COMMIT WORK;
95: END IF;
96:
97: -- Standard call to get message count and IF count is get message info.
98: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
99: p_data => x_msg_data );
100: EXCEPTION
101: WHEN FND_API.G_EXC_ERROR THEN
102: ROLLBACK TO Convert_CurrencyAmount_Utl;
100: EXCEPTION
101: WHEN FND_API.G_EXC_ERROR THEN
102: ROLLBACK TO Convert_CurrencyAmount_Utl;
103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: FND_MSG_PUB.Count_And_Get
105: (p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: );
108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
109: ROLLBACK TO Convert_CurrencyAmount_Utl;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
111: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
112: p_data => x_msg_data );
113: WHEN OTHERS THEN
114: ROLLBACK TO Convert_CurrencyAmount_Utl;
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: p_data => x_msg_data );
113: WHEN OTHERS THEN
114: ROLLBACK TO Convert_CurrencyAmount_Utl;
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
116: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
117: THEN
118: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
119: l_api_name );
120: END IF;
114: ROLLBACK TO Convert_CurrencyAmount_Utl;
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
116: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
117: THEN
118: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
119: l_api_name );
120: END IF;
121: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
122: p_data => x_msg_data );
117: THEN
118: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
119: l_api_name );
120: END IF;
121: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
122: p_data => x_msg_data );
123: END Convert_CurrencyAmount;
124:
125: /*----------------------------------------------------------------*/
169: END IF;
170:
171: -- Initialize message list if p_init_msg_list is set to TRUE.
172: IF FND_API.to_Boolean(p_init_msg_list) THEN
173: FND_MSG_PUB.initialize;
174: END IF;
175:
176: -- Initialize API return status to success
177: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: COMMIT WORK;
190: END IF;
191:
192: -- Standard call to get message count and IF count is get message info.
193: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
194: p_data => x_msg_data );
195: EXCEPTION
196: WHEN FND_API.G_EXC_ERROR THEN
197: ROLLBACK TO Get_TotalActCosts_Utl;
195: EXCEPTION
196: WHEN FND_API.G_EXC_ERROR THEN
197: ROLLBACK TO Get_TotalActCosts_Utl;
198: x_return_status := FND_API.G_RET_STS_ERROR ;
199: FND_MSG_PUB.Count_And_Get
200: (p_count => x_msg_count,
201: p_data => x_msg_data
202: );
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: );
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: ROLLBACK TO Get_TotalActCosts_Utl;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
207: p_data => x_msg_data );
208: WHEN OTHERS THEN
209: ROLLBACK TO Get_TotalActCosts_Utl;
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
207: p_data => x_msg_data );
208: WHEN OTHERS THEN
209: ROLLBACK TO Get_TotalActCosts_Utl;
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
212: THEN
213: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
214: l_api_name );
215: END IF;
209: ROLLBACK TO Get_TotalActCosts_Utl;
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
212: THEN
213: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
214: l_api_name );
215: END IF;
216: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
217: p_data => x_msg_data );
212: THEN
213: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
214: l_api_name );
215: END IF;
216: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
217: p_data => x_msg_data );
218: END Get_TotalActCosts;
219:
220:
263: END IF;
264:
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean(p_init_msg_list) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:
270: -- Initialize API return status to success
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
283: COMMIT WORK;
284: END IF;
285:
286: -- Standard call to get message count and IF count is get message info.
287: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
288: p_data => x_msg_data );
289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: ROLLBACK TO Get_TotalEstCosts_Utl;
289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: ROLLBACK TO Get_TotalEstCosts_Utl;
292: x_return_status := FND_API.G_RET_STS_ERROR ;
293: FND_MSG_PUB.Count_And_Get
294: (p_count => x_msg_count,
295: p_data => x_msg_data
296: );
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: );
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO Get_TotalEstCosts_Utl;
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
300: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
301: p_data => x_msg_data );
302: WHEN OTHERS THEN
303: ROLLBACK TO Get_TotalEstCosts_Utl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301: p_data => x_msg_data );
302: WHEN OTHERS THEN
303: ROLLBACK TO Get_TotalEstCosts_Utl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
308: l_api_name );
309: END IF;
303: ROLLBACK TO Get_TotalEstCosts_Utl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
308: l_api_name );
309: END IF;
310: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
311: p_data => x_msg_data );
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
308: l_api_name );
309: END IF;
310: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
311: p_data => x_msg_data );
312: END Get_TotalEstCosts;
313:
314: /*----------------------------------------------------------------*/
363: END IF;
364:
365: -- Initialize message list if p_init_msg_list is set to TRUE.
366: IF FND_API.to_Boolean(p_init_msg_list) THEN
367: FND_MSG_PUB.initialize;
368: END IF;
369:
370: -- Initialize API return status to success
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
383: COMMIT WORK;
384: END IF;
385:
386: -- Standard call to get message count and IF count is get message info.
387: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
388: p_data => x_msg_data );
389: EXCEPTION
390: WHEN FND_API.G_EXC_ERROR THEN
391: ROLLBACK TO Compare_MLETotals_Utl;
389: EXCEPTION
390: WHEN FND_API.G_EXC_ERROR THEN
391: ROLLBACK TO Compare_MLETotals_Utl;
392: x_return_status := FND_API.G_RET_STS_ERROR ;
393: FND_MSG_PUB.Count_And_Get
394: (p_count => x_msg_count,
395: p_data => x_msg_data
396: );
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: );
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: ROLLBACK TO Compare_MLETotals_Utl;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
401: p_data => x_msg_data );
402: WHEN OTHERS THEN
403: ROLLBACK TO Compare_MLETotals_Utl;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401: p_data => x_msg_data );
402: WHEN OTHERS THEN
403: ROLLBACK TO Compare_MLETotals_Utl;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
406: THEN
407: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
408: l_api_name );
409: END IF;
403: ROLLBACK TO Compare_MLETotals_Utl;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
406: THEN
407: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
408: l_api_name );
409: END IF;
410: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
411: p_data => x_msg_data );
406: THEN
407: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
408: l_api_name );
409: END IF;
410: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
411: p_data => x_msg_data );
412: END Compare_MLETotals;
413:
414: END CSD_ANALYSIS_UTIL ;