DBA Data[Home] [Help]

APPS.CSD_ANALYSIS_UTIL dependencies on FND_API

Line 68: IF NOT FND_API.Compatible_API_Call (l_api_version,

64: -- Standard Start of API savepoint
65: SAVEPOINT Convert_CurrencyAmount_Utl;
66:
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.Compatible_API_Call (l_api_version,
69: p_api_version,
70: l_api_name,
71: G_PKG_NAME)
72: THEN

Line 73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

69: p_api_version,
70: l_api_name,
71: G_PKG_NAME)
72: THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 77: IF FND_API.to_Boolean(p_init_msg_list) THEN

73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 82: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
83:
84: --
85: -- Begin API Body
86: --

Line 93: IF FND_API.To_Boolean( p_commit ) THEN

89: -- End API Body
90: --
91:
92: -- Standard check of p_commit.
93: IF FND_API.To_Boolean( p_commit ) THEN
94: COMMIT WORK;
95: END IF;
96:
97: -- Standard call to get message count and IF count is get message info.

Line 101: WHEN FND_API.G_EXC_ERROR THEN

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;
103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: FND_MSG_PUB.Count_And_Get
105: (p_count => x_msg_count,

Line 103: x_return_status := FND_API.G_RET_STS_ERROR ;

99: p_data => x_msg_data );
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: );

Line 108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 );

Line 110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

106: p_data => x_msg_data
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;

Line 115: 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 ;
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 );

Line 163: IF NOT FND_API.Compatible_API_Call (l_api_version,

159: -- Standard Start of API savepoint
160: SAVEPOINT Get_TotalActCosts_Utl;
161:
162: -- Standard call to check for call compatibility.
163: IF NOT FND_API.Compatible_API_Call (l_api_version,
164: p_api_version,
165: l_api_name,
166: G_PKG_NAME)
167: THEN

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: p_api_version,
165: l_api_name,
166: G_PKG_NAME)
167: THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 172: IF FND_API.to_Boolean(p_init_msg_list) THEN

168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 177: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
178:
179: --
180: -- Begin API Body
181: --

Line 188: IF FND_API.To_Boolean( p_commit ) THEN

184: -- End API Body
185: --
186:
187: -- Standard check of p_commit.
188: IF FND_API.To_Boolean( p_commit ) THEN
189: COMMIT WORK;
190: END IF;
191:
192: -- Standard call to get message count and IF count is get message info.

Line 196: WHEN FND_API.G_EXC_ERROR THEN

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;
198: x_return_status := FND_API.G_RET_STS_ERROR ;
199: FND_MSG_PUB.Count_And_Get
200: (p_count => x_msg_count,

Line 198: x_return_status := FND_API.G_RET_STS_ERROR ;

194: p_data => x_msg_data );
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: );

Line 203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 );

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

201: p_data => x_msg_data
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;

Line 210: 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 ;
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 );

Line 257: IF NOT FND_API.Compatible_API_Call (l_api_version,

253: -- Standard Start of API savepoint
254: SAVEPOINT Get_TotalEstCosts_Utl;
255:
256: -- Standard call to check for call compatibility.
257: IF NOT FND_API.Compatible_API_Call (l_api_version,
258: p_api_version,
259: l_api_name,
260: G_PKG_NAME)
261: THEN

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: p_api_version,
259: l_api_name,
260: G_PKG_NAME)
261: THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 266: IF FND_API.to_Boolean(p_init_msg_list) THEN

262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 271: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
272:
273: --
274: -- Begin API Body
275: --

Line 282: IF FND_API.To_Boolean( p_commit ) THEN

278: -- End API Body
279: --
280:
281: -- Standard check of p_commit.
282: IF FND_API.To_Boolean( p_commit ) THEN
283: COMMIT WORK;
284: END IF;
285:
286: -- Standard call to get message count and IF count is get message info.

Line 290: WHEN FND_API.G_EXC_ERROR THEN

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;
292: x_return_status := FND_API.G_RET_STS_ERROR ;
293: FND_MSG_PUB.Count_And_Get
294: (p_count => x_msg_count,

Line 292: x_return_status := FND_API.G_RET_STS_ERROR ;

288: p_data => x_msg_data );
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: );

Line 297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 );

Line 299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

295: p_data => x_msg_data
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;

Line 304: 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 ;
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 );

Line 357: IF NOT FND_API.Compatible_API_Call (l_api_version,

353: -- Standard Start of API savepoint
354: SAVEPOINT Compare_MLETotals_Utl;
355:
356: -- Standard call to check for call compatibility.
357: IF NOT FND_API.Compatible_API_Call (l_api_version,
358: p_api_version,
359: l_api_name,
360: G_PKG_NAME)
361: THEN

Line 362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

358: p_api_version,
359: l_api_name,
360: G_PKG_NAME)
361: THEN
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 366: IF FND_API.to_Boolean(p_init_msg_list) THEN

362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
372:
373: --
374: -- Begin API Body
375: --

Line 382: IF FND_API.To_Boolean( p_commit ) THEN

378: -- End API Body
379: --
380:
381: -- Standard check of p_commit.
382: IF FND_API.To_Boolean( p_commit ) THEN
383: COMMIT WORK;
384: END IF;
385:
386: -- Standard call to get message count and IF count is get message info.

Line 390: WHEN FND_API.G_EXC_ERROR THEN

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;
392: x_return_status := FND_API.G_RET_STS_ERROR ;
393: FND_MSG_PUB.Count_And_Get
394: (p_count => x_msg_count,

Line 392: x_return_status := FND_API.G_RET_STS_ERROR ;

388: p_data => x_msg_data );
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: );

Line 397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 );

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

395: p_data => x_msg_data
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;

Line 404: 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 ;
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 );