eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_COST_DETAILS_PUB dependencies on FND_API

Line 13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

9:
10: PROCEDURE Create_cost_details
11: (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,

Line 14: p_commit IN VARCHAR2 := FND_API.G_FALSE,

10: PROCEDURE Create_cost_details
11: (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_object_version_number OUT NOCOPY NUMBER,

Line 15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

11: (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_object_version_number OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,

Line 25: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

21: p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
22: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
23: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
24: p_login_id IN NUMBER := NULL,
25: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
26: p_Cost_Rec IN Cost_Rec_Type :=G_MISS_COST_REC
27:
28: ) IS
29:

Line 47: IF FND_API.To_Boolean(p_transaction_control) THEN

43: BEGIN
44:
45: -- Standard Start of API Savepoint
46:
47: IF FND_API.To_Boolean(p_transaction_control) THEN
48: SAVEPOINT Create_Cost_Details_PUB ;
49: END IF ;
50:
51: -- Standard Call to check API compatibility

Line 52: IF NOT FND_API.Compatible_API_Call( l_api_version,

48: SAVEPOINT Create_Cost_Details_PUB ;
49: END IF ;
50:
51: -- Standard Call to check API compatibility
52: IF NOT FND_API.Compatible_API_Call( l_api_version,
53: p_api_version,
54: l_api_name,
55: G_PKG_NAME) THEN
56:

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

53: p_api_version,
54: l_api_name,
55: G_PKG_NAME) THEN
56:
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
58: END IF ;
59:
60: -- Initialize the message list if p_msg_list is set to TRUE
61:

Line 62: IF FND_API.To_Boolean(p_init_msg_list) THEN

58: END IF ;
59:
60: -- Initialize the message list if p_msg_list is set to TRUE
61:
62: IF FND_API.To_Boolean(p_init_msg_list) THEN
63: FND_MSG_PUB.initialize ;
64: END IF ;
65:
66: -- Initialize the API Return Success to True

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS ;

63: FND_MSG_PUB.initialize ;
64: END IF ;
65:
66: -- Initialize the API Return Success to True
67: x_return_status := FND_API.G_RET_STS_SUCCESS ;
68:
69:
70:
71: ----------------------- FND Logging -----------------------------------

Line 123: --Convert the IN Parameters from FND_API.G_MISS_XXXX to NULL

119:
120:
121: END IF;
122:
123: --Convert the IN Parameters from FND_API.G_MISS_XXXX to NULL
124: --if no calue is passed then return NULL otherwise return the value passed
125:
126: -- TO_NULL (p_cost_Rec, l_cost_Rec) ; --do this in the cost pvt api
127:

Line 144: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

140: (
141: p_api_version =>1.0,
142: p_init_msg_list => p_init_msg_list ,
143: p_commit => p_commit ,
144: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
145: x_return_status => l_return_status,
146: x_msg_count => x_msg_count,
147: x_object_version_number => x_object_version_number,
148: x_msg_data => x_msg_data,

Line 171: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

167: END IF;
168:
169:
170:
171: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;

Line 172: RAISE FND_API.G_EXC_ERROR;

168:
169:
170:
171: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:

Line 173: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

169:
170:
171: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177:

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170:
171: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177:
178: --standard Check of p_commit bharahti

Line 179: IF FND_API.To_Boolean( p_commit ) THEN

175: END IF;
176:
177:
178: --standard Check of p_commit bharahti
179: IF FND_API.To_Boolean( p_commit ) THEN
180: COMMIT WORK ;
181: END IF ;
182:
183: --Standard call to get message count and if count is 1 , get message info

Line 186: p_encoded => FND_API.G_FALSE) ;

182:
183: --Standard call to get message count and if count is 1 , get message info
184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
185: p_data => x_msg_data,
186: p_encoded => FND_API.G_FALSE) ;
187:
188:
189: --Begin Exception Handling
190:

Line 193: WHEN FND_API.G_EXC_ERROR THEN

189: --Begin Exception Handling
190:
191: EXCEPTION
192:
193: WHEN FND_API.G_EXC_ERROR THEN
194:
195:
196: IF FND_API.To_Boolean( p_transaction_control ) THEN
197: ROLLBACK TO Create_Cost_Details_PUB;

Line 196: IF FND_API.To_Boolean( p_transaction_control ) THEN

192:
193: WHEN FND_API.G_EXC_ERROR THEN
194:
195:
196: IF FND_API.To_Boolean( p_transaction_control ) THEN
197: ROLLBACK TO Create_Cost_Details_PUB;
198: END IF ;
199:
200: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 200: x_return_status := FND_API.G_RET_STS_ERROR ;

196: IF FND_API.To_Boolean( p_transaction_control ) THEN
197: ROLLBACK TO Create_Cost_Details_PUB;
198: END IF ;
199:
200: x_return_status := FND_API.G_RET_STS_ERROR ;
201:
202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
203: p_data => x_msg_data,
204: p_encoded => FND_API.G_FALSE) ;

Line 204: p_encoded => FND_API.G_FALSE) ;

200: x_return_status := FND_API.G_RET_STS_ERROR ;
201:
202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
203: p_data => x_msg_data,
204: p_encoded => FND_API.G_FALSE) ;
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207:
208:

Line 206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
203: p_data => x_msg_data,
204: p_encoded => FND_API.G_FALSE) ;
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207:
208:
209: IF FND_API.To_Boolean( p_transaction_control ) THEN
210: ROLLBACK TO Create_Cost_Details_PUB;

Line 209: IF FND_API.To_Boolean( p_transaction_control ) THEN

205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207:
208:
209: IF FND_API.To_Boolean( p_transaction_control ) THEN
210: ROLLBACK TO Create_Cost_Details_PUB;
211: END IF ;
212:
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

209: IF FND_API.To_Boolean( p_transaction_control ) THEN
210: ROLLBACK TO Create_Cost_Details_PUB;
211: END IF ;
212:
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214:
215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
216: p_data => x_msg_data,
217: p_encoded => FND_API.G_FALSE) ;

Line 217: p_encoded => FND_API.G_FALSE) ;

213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214:
215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
216: p_data => x_msg_data,
217: p_encoded => FND_API.G_FALSE) ;
218: WHEN OTHERS THEN
219:
220:
221: IF FND_API.To_Boolean( p_transaction_control ) THEN

Line 221: IF FND_API.To_Boolean( p_transaction_control ) THEN

217: p_encoded => FND_API.G_FALSE) ;
218: WHEN OTHERS THEN
219:
220:
221: IF FND_API.To_Boolean( p_transaction_control ) THEN
222: ROLLBACK TO Create_Cost_Details_PUB ;
223: END IF ;
224:
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

221: IF FND_API.To_Boolean( p_transaction_control ) THEN
222: ROLLBACK TO Create_Cost_Details_PUB ;
223: END IF ;
224:
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226:
227: IF FND_MSG_PUB.Check_Msg_Level
228: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
229: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 234: p_encoded => FND_API.G_FALSE) ;

230: END IF ;
231:
232: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
233: p_data => x_msg_data,
234: p_encoded => FND_API.G_FALSE) ;
235:
236: END Create_cost_details;
237:
238: /**************************************************

Line 246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

242:
243: PROCEDURE Update_Cost_Details
244: (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,

Line 247: p_commit IN VARCHAR2 := FND_API.G_FALSE,

243: PROCEDURE Update_Cost_Details
244: (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_object_version_number OUT NOCOPY NUMBER,

Line 248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

244: (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_object_version_number OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,

Line 257: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

253: p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
254: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
255: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
256: p_login_id IN NUMBER := NULL,
257: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
258: p_Cost_Rec IN Cost_Rec_Type :=G_MISS_COST_REC
259:
260: ) IS
261:

Line 281: IF FND_API.To_Boolean( p_transaction_control ) THEN

277:
278:
279: BEGIN
280:
281: IF FND_API.To_Boolean( p_transaction_control ) THEN
282: SAVEPOINT update_cost_details_pub ;
283: END IF ;
284:
285: --Standard Call to check API compatibility

Line 286: IF NOT FND_API.Compatible_API_Call(l_api_version,

282: SAVEPOINT update_cost_details_pub ;
283: END IF ;
284:
285: --Standard Call to check API compatibility
286: IF NOT FND_API.Compatible_API_Call(l_api_version,
287: p_api_version,
288: l_api_name,
289: G_PKG_NAME )THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

286: IF NOT FND_API.Compatible_API_Call(l_api_version,
287: p_api_version,
288: l_api_name,
289: G_PKG_NAME )THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
291: END IF ;
292:
293: -- Initialize the message list if p_msg_list is set to TRUE
294: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 294: IF FND_API.To_Boolean(p_init_msg_list) THEN

290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
291: END IF ;
292:
293: -- Initialize the message list if p_msg_list is set to TRUE
294: IF FND_API.To_Boolean(p_init_msg_list) THEN
295: FND_MSG_PUB.initialize ;
296: END IF ;
297:
298:

Line 300: x_return_status := FND_API.G_RET_STS_SUCCESS ;

296: END IF ;
297:
298:
299: --Initialize the API Return Success to True
300: x_return_status := FND_API.G_RET_STS_SUCCESS ;
301:
302:
303: ----------------------- FND Logging -----------------------------------
304: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

Line 369: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

365: (
366: p_api_version =>1.0,
367: p_init_msg_list => p_init_msg_list,
368: p_commit => p_commit ,
369: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
370: x_return_status => l_return_status,
371: x_msg_count => x_msg_count,
372: x_object_version_number=> x_object_version_number,
373: x_msg_data => x_msg_data,

Line 383: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

379: p_Cost_Rec => p_cost_rec
380: );
381:
382:
383: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;

Line 384: RAISE FND_API.G_EXC_ERROR;

380: );
381:
382:
383: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388:

Line 385: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

381:
382:
383: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388:
389:

Line 386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

382:
383: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388:
389:
390:

Line 401: IF FND_API.To_Boolean( p_commit ) THEN

397: END IF;
398:
399:
400: --standard Check of p_commit
401: IF FND_API.To_Boolean( p_commit ) THEN
402: COMMIT WORK ;
403: END IF ;
404:
405: --Standard call to get message count and if count is 1 , get message info

Line 408: p_encoded => FND_API.G_FALSE) ;

404:
405: --Standard call to get message count and if count is 1 , get message info
406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
407: p_data => x_msg_data,
408: p_encoded => FND_API.G_FALSE) ;
409:
410: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
411: FND_LOG.String
412: ( FND_LOG.level_procedure , L_LOG_MODULE ||'',

Line 420: WHEN FND_API.G_EXC_ERROR THEN

416: --Begin Exception Handling
417:
418: EXCEPTION
419:
420: WHEN FND_API.G_EXC_ERROR THEN
421:
422: IF FND_API.To_Boolean( p_transaction_control ) THEN
423: ROLLBACK TO update_cost_details_pub;
424: END IF ;

Line 422: IF FND_API.To_Boolean( p_transaction_control ) THEN

418: EXCEPTION
419:
420: WHEN FND_API.G_EXC_ERROR THEN
421:
422: IF FND_API.To_Boolean( p_transaction_control ) THEN
423: ROLLBACK TO update_cost_details_pub;
424: END IF ;
425:
426: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 426: x_return_status := FND_API.G_RET_STS_ERROR ;

422: IF FND_API.To_Boolean( p_transaction_control ) THEN
423: ROLLBACK TO update_cost_details_pub;
424: END IF ;
425:
426: x_return_status := FND_API.G_RET_STS_ERROR ;
427:
428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
429: p_data => x_msg_data,
430: p_encoded => FND_API.G_FALSE) ;

Line 430: p_encoded => FND_API.G_FALSE) ;

426: x_return_status := FND_API.G_RET_STS_ERROR ;
427:
428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
429: p_data => x_msg_data,
430: p_encoded => FND_API.G_FALSE) ;
431:
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433:
434: IF FND_API.To_Boolean( p_transaction_control ) THEN

Line 432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
429: p_data => x_msg_data,
430: p_encoded => FND_API.G_FALSE) ;
431:
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433:
434: IF FND_API.To_Boolean( p_transaction_control ) THEN
435: ROLLBACK TO update_cost_details_pub;
436: END IF ;

Line 434: IF FND_API.To_Boolean( p_transaction_control ) THEN

430: p_encoded => FND_API.G_FALSE) ;
431:
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433:
434: IF FND_API.To_Boolean( p_transaction_control ) THEN
435: ROLLBACK TO update_cost_details_pub;
436: END IF ;
437:
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

434: IF FND_API.To_Boolean( p_transaction_control ) THEN
435: ROLLBACK TO update_cost_details_pub;
436: END IF ;
437:
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
439:
440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
441: p_data => x_msg_data,
442: p_encoded => FND_API.G_FALSE) ;

Line 442: p_encoded => FND_API.G_FALSE) ;

438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
439:
440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
441: p_data => x_msg_data,
442: p_encoded => FND_API.G_FALSE) ;
443: WHEN OTHERS THEN
444:
445: IF FND_API.To_Boolean( p_transaction_control ) THEN
446: ROLLBACK TO update_cost_details_pub;

Line 445: IF FND_API.To_Boolean( p_transaction_control ) THEN

441: p_data => x_msg_data,
442: p_encoded => FND_API.G_FALSE) ;
443: WHEN OTHERS THEN
444:
445: IF FND_API.To_Boolean( p_transaction_control ) THEN
446: ROLLBACK TO update_cost_details_pub;
447: END IF ;
448:
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

445: IF FND_API.To_Boolean( p_transaction_control ) THEN
446: ROLLBACK TO update_cost_details_pub;
447: END IF ;
448:
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
450:
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
453: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 458: p_encoded => FND_API.G_FALSE) ;

454: END IF ;
455:
456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
457: p_data => x_msg_data,
458: p_encoded => FND_API.G_FALSE) ;
459:
460: END Update_Cost_Details;
461:
462:

Line 469: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

465: **************************************************/
466: PROCEDURE Delete_Cost_details
467: (
468: p_api_version IN NUMBER,
469: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
470: p_commit IN VARCHAR2 := FND_API.G_FALSE,
471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472: x_return_status OUT NOCOPY VARCHAR2,
473: x_msg_count OUT NOCOPY NUMBER,

Line 470: p_commit IN VARCHAR2 := FND_API.G_FALSE,

466: PROCEDURE Delete_Cost_details
467: (
468: p_api_version IN NUMBER,
469: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
470: p_commit IN VARCHAR2 := FND_API.G_FALSE,
471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472: x_return_status OUT NOCOPY VARCHAR2,
473: x_msg_count OUT NOCOPY NUMBER,
474: x_msg_data OUT NOCOPY VARCHAR2,

Line 471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

467: (
468: p_api_version IN NUMBER,
469: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
470: p_commit IN VARCHAR2 := FND_API.G_FALSE,
471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472: x_return_status OUT NOCOPY VARCHAR2,
473: x_msg_count OUT NOCOPY NUMBER,
474: x_msg_data OUT NOCOPY VARCHAR2,
475: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

Line 475: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472: x_return_status OUT NOCOPY VARCHAR2,
473: x_msg_count OUT NOCOPY NUMBER,
474: x_msg_data OUT NOCOPY VARCHAR2,
475: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
476: p_cost_id IN NUMBER := NULL
477: ) IS
478:
479: l_api_name CONSTANT VARCHAR2(30) :='Delete_Cost_Details Public API' ;

Line 494: IF FND_API.To_Boolean( p_transaction_control ) THEN

490:
491:
492: BEGIN
493: -- Standard Start of API Savepoint
494: IF FND_API.To_Boolean( p_transaction_control ) THEN
495: SAVEPOINT Delete_Cost_Details_PUB ;
496: END IF ;
497:
498: -- Standard Call to check API compatibility

Line 499: IF NOT FND_API.Compatible_API_Call(l_api_version,

495: SAVEPOINT Delete_Cost_Details_PUB ;
496: END IF ;
497:
498: -- Standard Call to check API compatibility
499: IF NOT FND_API.Compatible_API_Call(l_api_version,
500: p_api_version,
501: l_api_name,
502: G_PKG_NAME ) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

499: IF NOT FND_API.Compatible_API_Call(l_api_version,
500: p_api_version,
501: l_api_name,
502: G_PKG_NAME ) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
504: END IF ;
505:
506: -- Initialize the message list if p_msg_list is set to TRUE
507: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 507: IF FND_API.To_Boolean(p_init_msg_list) THEN

503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
504: END IF ;
505:
506: -- Initialize the message list if p_msg_list is set to TRUE
507: IF FND_API.To_Boolean(p_init_msg_list) THEN
508: FND_MSG_PUB.initialize ;
509: END IF ;
510:
511:

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS ;

509: END IF ;
510:
511:
512: -- Initialize the API Return Success to True
513: x_return_status := FND_API.G_RET_STS_SUCCESS ;
514:
515: ----------------------- FND Logging -----------------------------------
516: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
517: FND_LOG.String

Line 561: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

557: (
558: p_api_version =>1.0,
559: p_init_msg_list => p_init_msg_list,
560: p_commit => p_commit,
561: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
562: x_return_status => l_return_status,
563: x_msg_count => x_msg_count,
564: x_msg_data => x_msg_data,
565: p_transaction_control => p_transaction_control,

Line 577: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

573: 'After calling the costing Private API '||l_return_status
574: );
575: END IF;
576:
577: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
578:
579: RAISE FND_API.G_EXC_ERROR;
580: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 579: RAISE FND_API.G_EXC_ERROR;

575: END IF;
576:
577: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
578:
579: RAISE FND_API.G_EXC_ERROR;
580: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:

Line 580: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

576:
577: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
578:
579: RAISE FND_API.G_EXC_ERROR;
580: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:
584:

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
578:
579: RAISE FND_API.G_EXC_ERROR;
580: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:
584:
585: --standard Check of p_commit

Line 586: IF FND_API.To_Boolean( p_commit ) THEN

582: END IF;
583:
584:
585: --standard Check of p_commit
586: IF FND_API.To_Boolean( p_commit ) THEN
587: COMMIT ;
588: END IF ;
589:
590: --Standard call to get message count and if count is 1 , get message info

Line 593: p_encoded => FND_API.G_FALSE) ;

589:
590: --Standard call to get message count and if count is 1 , get message info
591: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
592: p_data => x_msg_data,
593: p_encoded => FND_API.G_FALSE) ;
594:
595: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
596: FND_LOG.String
597: ( FND_LOG.level_procedure , L_LOG_MODULE ||'',

Line 608: WHEN FND_API.G_EXC_ERROR THEN

604: --Begin Exception Handling
605:
606: EXCEPTION
607:
608: WHEN FND_API.G_EXC_ERROR THEN
609:
610: IF FND_API.To_Boolean( p_transaction_control ) THEN
611: ROLLBACK TO Delete_Cost_Details_PUB;
612: END IF ;

Line 610: IF FND_API.To_Boolean( p_transaction_control ) THEN

606: EXCEPTION
607:
608: WHEN FND_API.G_EXC_ERROR THEN
609:
610: IF FND_API.To_Boolean( p_transaction_control ) THEN
611: ROLLBACK TO Delete_Cost_Details_PUB;
612: END IF ;
613:
614: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 614: x_return_status := FND_API.G_RET_STS_ERROR ;

610: IF FND_API.To_Boolean( p_transaction_control ) THEN
611: ROLLBACK TO Delete_Cost_Details_PUB;
612: END IF ;
613:
614: x_return_status := FND_API.G_RET_STS_ERROR ;
615:
616: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
617: p_data => x_msg_data,
618: p_encoded => FND_API.G_FALSE) ;

Line 618: p_encoded => FND_API.G_FALSE) ;

614: x_return_status := FND_API.G_RET_STS_ERROR ;
615:
616: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
617: p_data => x_msg_data,
618: p_encoded => FND_API.G_FALSE) ;
619:
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621:
622: IF FND_API.To_Boolean( p_transaction_control ) THEN

Line 620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

616: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
617: p_data => x_msg_data,
618: p_encoded => FND_API.G_FALSE) ;
619:
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621:
622: IF FND_API.To_Boolean( p_transaction_control ) THEN
623: ROLLBACK TO Delete_Cost_Details_PUB;
624: END IF ;

Line 622: IF FND_API.To_Boolean( p_transaction_control ) THEN

618: p_encoded => FND_API.G_FALSE) ;
619:
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621:
622: IF FND_API.To_Boolean( p_transaction_control ) THEN
623: ROLLBACK TO Delete_Cost_Details_PUB;
624: END IF ;
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

622: IF FND_API.To_Boolean( p_transaction_control ) THEN
623: ROLLBACK TO Delete_Cost_Details_PUB;
624: END IF ;
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627:
628: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
629: p_data => x_msg_data,
630: p_encoded => FND_API.G_FALSE) ;

Line 630: p_encoded => FND_API.G_FALSE) ;

626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627:
628: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
629: p_data => x_msg_data,
630: p_encoded => FND_API.G_FALSE) ;
631: WHEN OTHERS THEN
632:
633: IF FND_API.To_Boolean( p_transaction_control ) THEN
634: ROLLBACK TO Delete_Cost_Details_PUB;

Line 633: IF FND_API.To_Boolean( p_transaction_control ) THEN

629: p_data => x_msg_data,
630: p_encoded => FND_API.G_FALSE) ;
631: WHEN OTHERS THEN
632:
633: IF FND_API.To_Boolean( p_transaction_control ) THEN
634: ROLLBACK TO Delete_Cost_Details_PUB;
635: END IF ;
636:
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

633: IF FND_API.To_Boolean( p_transaction_control ) THEN
634: ROLLBACK TO Delete_Cost_Details_PUB;
635: END IF ;
636:
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
638:
639: IF FND_MSG_PUB.Check_Msg_Level
640: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
641: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 646: p_encoded => FND_API.G_FALSE) ;

642: END IF ;
643:
644: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
645: p_data => x_msg_data,
646: p_encoded => FND_API.G_FALSE) ;
647:
648:
649: END Delete_Cost_details;
650: