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_CHARGE_DETAILS_PUB dependencies on FND_API

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

21: **************************************************/
22:
23: PROCEDURE Create_Charge_Details(
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,

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

22:
23: PROCEDURE Create_Charge_Details(
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_object_version_number OUT NOCOPY NUMBER,

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

23: PROCEDURE Create_Charge_Details(
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_object_version_number OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,

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

34: p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
35: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
36: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
37: p_login_id IN NUMBER := NULL,
38: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
39: p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC
40: ) IS
41:
42: x_cost_id NUMBER;

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

68:
69:
70: PROCEDURE Create_Charge_Details(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,

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

69:
70: PROCEDURE Create_Charge_Details(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_object_version_number OUT NOCOPY NUMBER,

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

70: PROCEDURE Create_Charge_Details(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_object_version_number OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,

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

81: p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
82: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
83: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
84: p_login_id IN NUMBER := NULL,
85: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
86: p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC,
87: p_create_cost_detail IN VARCHAR2 ,--Costing
88: x_cost_id OUT NOCOPY NUMBER --Costing
89: ) IS

Line 108: IF FND_API.To_Boolean( p_transaction_control ) THEN

104:
105: BEGIN
106:
107: -- Standard Start of API Savepoint
108: IF FND_API.To_Boolean( p_transaction_control ) THEN
109: SAVEPOINT Create_Charge_Details_PUB ;
110: END IF ;
111:
112: -- Standard Call to check API compatibility

Line 113: IF NOT FND_API.Compatible_API_Call( l_api_version,

109: SAVEPOINT Create_Charge_Details_PUB ;
110: END IF ;
111:
112: -- Standard Call to check API compatibility
113: IF NOT FND_API.Compatible_API_Call( l_api_version,
114: p_api_version,
115: l_api_name,
116: G_PKG_NAME) THEN
117:

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

114: p_api_version,
115: l_api_name,
116: G_PKG_NAME) THEN
117:
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
119: END IF ;
120:
121: -- Initialize the message list if p_msg_list is set to TRUE
122: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 122: IF FND_API.To_Boolean(p_init_msg_list) THEN

118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
119: END IF ;
120:
121: -- Initialize the message list if p_msg_list is set to TRUE
122: IF FND_API.To_Boolean(p_init_msg_list) THEN
123: FND_MSG_PUB.initialize ;
124: END IF ;
125:
126: -- Initialize the API Return Success to True

Line 127: x_return_status := FND_API.G_RET_STS_SUCCESS ;

123: FND_MSG_PUB.initialize ;
124: END IF ;
125:
126: -- Initialize the API Return Success to True
127: x_return_status := FND_API.G_RET_STS_SUCCESS ;
128:
129: ----------------------- FND Logging -----------------------------------
130: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
131: THEN

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

182: );
183:
184: END IF;
185:
186: --Convert the IN Parameters from FND_API.G_MISS_XXXX to NULL
187: TO_NULL (p_Charges_Rec, l_Charges_Rec) ;
188:
189: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
190: THEN

Line 206: p_init_msg_list => FND_API.G_FALSE ,

202: --Call the private API Create_Charge_Details
203: CS_Charge_Details_PVT.Create_Charge_Details
204: (
205: p_api_version => 1.0 ,
206: p_init_msg_list => FND_API.G_FALSE ,
207: p_commit => p_commit ,
208: p_validation_level => p_validation_level,
209: x_return_status => l_return_status,
210: x_msg_count => x_msg_count,

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

220: p_est_detail_rec => l_charges_rec
221: ) ;
222:
223:
224: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;

Line 225: RAISE FND_API.G_EXC_ERROR;

221: ) ;
222:
223:
224: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;
229:

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

222:
223:
224: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;
229:
230: --End of API Body

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223:
224: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;
229:
230: --End of API Body
231: --standard Check of p_commit

Line 232: IF FND_API.To_Boolean( p_commit ) THEN

228: END IF;
229:
230: --End of API Body
231: --standard Check of p_commit
232: IF FND_API.To_Boolean( p_commit ) THEN
233: COMMIT WORK ;
234: END IF ;
235:
236: --Standard call to get message count and if count is 1 , get message info

Line 239: p_encoded => FND_API.G_FALSE) ;

235:
236: --Standard call to get message count and if count is 1 , get message info
237: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
238: p_data => x_msg_data,
239: p_encoded => FND_API.G_FALSE) ;
240: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
241: THEN
242:
243: FND_LOG.String

Line 255: WHEN FND_API.G_EXC_ERROR THEN

251: --Begin Exception Handling
252:
253: EXCEPTION
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256: IF FND_API.To_Boolean( p_transaction_control ) THEN
257: ROLLBACK TO Create_Charge_Details_PUB;
258: END IF ;
259:

Line 256: IF FND_API.To_Boolean( p_transaction_control ) THEN

252:
253: EXCEPTION
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256: IF FND_API.To_Boolean( p_transaction_control ) THEN
257: ROLLBACK TO Create_Charge_Details_PUB;
258: END IF ;
259:
260: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 260: x_return_status := FND_API.G_RET_STS_ERROR ;

256: IF FND_API.To_Boolean( p_transaction_control ) THEN
257: ROLLBACK TO Create_Charge_Details_PUB;
258: END IF ;
259:
260: x_return_status := FND_API.G_RET_STS_ERROR ;
261:
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
263: p_data => x_msg_data,
264: p_encoded => FND_API.G_FALSE) ;

Line 264: p_encoded => FND_API.G_FALSE) ;

260: x_return_status := FND_API.G_RET_STS_ERROR ;
261:
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
263: p_data => x_msg_data,
264: p_encoded => FND_API.G_FALSE) ;
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: IF FND_API.To_Boolean( p_transaction_control ) THEN
268: ROLLBACK TO Create_Charge_Details_PUB;

Line 266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
263: p_data => x_msg_data,
264: p_encoded => FND_API.G_FALSE) ;
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: IF FND_API.To_Boolean( p_transaction_control ) THEN
268: ROLLBACK TO Create_Charge_Details_PUB;
269: END IF ;
270:

Line 267: IF FND_API.To_Boolean( p_transaction_control ) THEN

263: p_data => x_msg_data,
264: p_encoded => FND_API.G_FALSE) ;
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: IF FND_API.To_Boolean( p_transaction_control ) THEN
268: ROLLBACK TO Create_Charge_Details_PUB;
269: END IF ;
270:
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

267: IF FND_API.To_Boolean( p_transaction_control ) THEN
268: ROLLBACK TO Create_Charge_Details_PUB;
269: END IF ;
270:
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272:
273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
274: p_data => x_msg_data,
275: p_encoded => FND_API.G_FALSE) ;

Line 275: p_encoded => FND_API.G_FALSE) ;

271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272:
273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
274: p_data => x_msg_data,
275: p_encoded => FND_API.G_FALSE) ;
276: WHEN OTHERS THEN
277: IF FND_API.To_Boolean( p_transaction_control ) THEN
278: ROLLBACK TO Create_Charge_Details_PUB ;
279: END IF ;

Line 277: IF FND_API.To_Boolean( p_transaction_control ) THEN

273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
274: p_data => x_msg_data,
275: p_encoded => FND_API.G_FALSE) ;
276: WHEN OTHERS THEN
277: IF FND_API.To_Boolean( p_transaction_control ) THEN
278: ROLLBACK TO Create_Charge_Details_PUB ;
279: END IF ;
280:
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

277: IF FND_API.To_Boolean( p_transaction_control ) THEN
278: ROLLBACK TO Create_Charge_Details_PUB ;
279: END IF ;
280:
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282:
283: IF FND_MSG_PUB.Check_Msg_Level
284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
285: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 290: p_encoded => FND_API.G_FALSE) ;

286: END IF ;
287:
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
289: p_data => x_msg_data,
290: p_encoded => FND_API.G_FALSE) ;
291:
292:
293: END;
294:

Line 310: IF l_return_status = FND_API.G_RET_STS_SUCCESS

306: --Create Cost record only if charge line has been successfully created.
307:
308: BEGIN
309:
310: IF l_return_status = FND_API.G_RET_STS_SUCCESS
311: and p_create_cost_detail ='Y'
312: and x_estimate_detail_id IS NOT NULL
313: THEN
314:

Line 315: IF FND_API.To_Boolean( p_transaction_control ) THEN

311: and p_create_cost_detail ='Y'
312: and x_estimate_detail_id IS NOT NULL
313: THEN
314:
315: IF FND_API.To_Boolean( p_transaction_control ) THEN
316: --iF there are any errors in the costing api then rollback will happen to this point
317: SAVEPOINT Create_Charge_Cost_Details_PUB ;
318:
319: END IF ;

Line 332: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

328: (
329: p_api_version => 1.0 ,
330: p_init_msg_list => p_init_msg_list,
331: p_commit => p_commit ,
332: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
333: x_return_status => l_return_status,
334: x_msg_count => x_msg_count,
335: x_object_version_number => x_object_version_number,
336: x_msg_data => x_msg_data,

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

343: p_Cost_Rec => l_cost_rec
344: );
345:
346:
347: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
348: RAISE FND_API.G_EXC_ERROR;
349: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;

Line 348: RAISE FND_API.G_EXC_ERROR;

344: );
345:
346:
347: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
348: RAISE FND_API.G_EXC_ERROR;
349: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:

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

345:
346:
347: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
348: RAISE FND_API.G_EXC_ERROR;
349: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:
353: --End of API Body

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

346:
347: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
348: RAISE FND_API.G_EXC_ERROR;
349: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:
353: --End of API Body
354: --standard Check of p_commit

Line 355: IF FND_API.To_Boolean( p_commit ) THEN

351: END IF;
352:
353: --End of API Body
354: --standard Check of p_commit
355: IF FND_API.To_Boolean( p_commit ) THEN
356: COMMIT WORK ;
357: END IF ;
358:
359: --Standard call to get message count and if count is 1 , get message info

Line 362: p_encoded => FND_API.G_FALSE) ;

358:
359: --Standard call to get message count and if count is 1 , get message info
360: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
361: p_data => x_msg_data,
362: p_encoded => FND_API.G_FALSE) ;
363:
364: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
365: THEN
366:

Line 381: WHEN FND_API.G_EXC_ERROR THEN

377:
378:
379: EXCEPTION
380:
381: WHEN FND_API.G_EXC_ERROR THEN
382: IF FND_API.To_Boolean( p_transaction_control ) THEN
383: ROLLBACK TO Create_Charge_cost_Details_PUB;
384: END IF ;
385:

Line 382: IF FND_API.To_Boolean( p_transaction_control ) THEN

378:
379: EXCEPTION
380:
381: WHEN FND_API.G_EXC_ERROR THEN
382: IF FND_API.To_Boolean( p_transaction_control ) THEN
383: ROLLBACK TO Create_Charge_cost_Details_PUB;
384: END IF ;
385:
386: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 386: x_return_status := FND_API.G_RET_STS_ERROR ;

382: IF FND_API.To_Boolean( p_transaction_control ) THEN
383: ROLLBACK TO Create_Charge_cost_Details_PUB;
384: END IF ;
385:
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387:
388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => FND_API.G_FALSE) ;

Line 390: p_encoded => FND_API.G_FALSE) ;

386: x_return_status := FND_API.G_RET_STS_ERROR ;
387:
388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => FND_API.G_FALSE) ;
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: IF FND_API.To_Boolean( p_transaction_control ) THEN
394: ROLLBACK TO Create_Charge_cost_Details_PUB;

Line 392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => FND_API.G_FALSE) ;
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: IF FND_API.To_Boolean( p_transaction_control ) THEN
394: ROLLBACK TO Create_Charge_cost_Details_PUB;
395: END IF ;
396:

Line 393: IF FND_API.To_Boolean( p_transaction_control ) THEN

389: p_data => x_msg_data,
390: p_encoded => FND_API.G_FALSE) ;
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: IF FND_API.To_Boolean( p_transaction_control ) THEN
394: ROLLBACK TO Create_Charge_cost_Details_PUB;
395: END IF ;
396:
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

393: IF FND_API.To_Boolean( p_transaction_control ) THEN
394: ROLLBACK TO Create_Charge_cost_Details_PUB;
395: END IF ;
396:
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398:
399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => FND_API.G_FALSE) ;

Line 401: p_encoded => FND_API.G_FALSE) ;

397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398:
399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => FND_API.G_FALSE) ;
402: WHEN OTHERS THEN
403: IF FND_API.To_Boolean( p_transaction_control ) THEN
404: ROLLBACK TO Create_Charge_cost_Details_PUB;
405: END IF ;

Line 403: IF FND_API.To_Boolean( p_transaction_control ) THEN

399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => FND_API.G_FALSE) ;
402: WHEN OTHERS THEN
403: IF FND_API.To_Boolean( p_transaction_control ) THEN
404: ROLLBACK TO Create_Charge_cost_Details_PUB;
405: END IF ;
406:
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

403: IF FND_API.To_Boolean( p_transaction_control ) THEN
404: ROLLBACK TO Create_Charge_cost_Details_PUB;
405: END IF ;
406:
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
408:
409: IF FND_MSG_PUB.Check_Msg_Level
410: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
411: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 416: p_encoded => FND_API.G_FALSE) ;

412: END IF ;
413:
414: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
415: p_data => x_msg_data,
416: p_encoded => FND_API.G_FALSE) ;
417:
418: END ;
419:
420:

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

423: --This is added for backward compatibility
424:
425: PROCEDURE Update_Charge_Details(
426: p_api_version IN NUMBER,
427: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
428: p_commit IN VARCHAR2 := FND_API.G_FALSE,
429: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,

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

424:
425: PROCEDURE Update_Charge_Details(
426: p_api_version IN NUMBER,
427: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
428: p_commit IN VARCHAR2 := FND_API.G_FALSE,
429: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,
432: x_object_version_number OUT NOCOPY NUMBER,

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

425: PROCEDURE Update_Charge_Details(
426: p_api_version IN NUMBER,
427: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
428: p_commit IN VARCHAR2 := FND_API.G_FALSE,
429: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,
432: x_object_version_number OUT NOCOPY NUMBER,
433: x_msg_data OUT NOCOPY VARCHAR2,

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

434: p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
435: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
436: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
437: p_login_id IN NUMBER := NULL,
438: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
439: p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC
440:
441: ) AS
442: BEGIN

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

470: **************************************************/
471:
472: PROCEDURE Update_Charge_Details(
473: p_api_version IN NUMBER,
474: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
475: p_commit IN VARCHAR2 := FND_API.G_FALSE,
476: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
477: x_return_status OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,

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

471:
472: PROCEDURE Update_Charge_Details(
473: p_api_version IN NUMBER,
474: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
475: p_commit IN VARCHAR2 := FND_API.G_FALSE,
476: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
477: x_return_status OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,
479: x_object_version_number OUT NOCOPY NUMBER,

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

472: PROCEDURE Update_Charge_Details(
473: p_api_version IN NUMBER,
474: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
475: p_commit IN VARCHAR2 := FND_API.G_FALSE,
476: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
477: x_return_status OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,
479: x_object_version_number OUT NOCOPY NUMBER,
480: x_msg_data OUT NOCOPY VARCHAR2,

Line 486: --p_login_id IN NUMBER := FND_API.G_MISS_NUM,

482: --x_line_number OUT NOCOPY NUMBER,
483: p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
484: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
485: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
486: --p_login_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_login_id IN NUMBER := NULL,
488: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
489: p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC,
490: p_update_cost_detail IN VARCHAR2 --service costing

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

484: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
485: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
486: --p_login_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_login_id IN NUMBER := NULL,
488: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
489: p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC,
490: p_update_cost_detail IN VARCHAR2 --service costing
491:
492: ) AS

Line 510: IF FND_API.To_Boolean( p_transaction_control ) THEN

506:
507: BEGIN
508:
509: -- Standard Start of API Savepoint
510: IF FND_API.To_Boolean( p_transaction_control ) THEN
511: SAVEPOINT Update_Charge_Details_PUB ;
512: END IF ;
513:
514: --Standard Call to check API compatibility

Line 515: IF NOT FND_API.Compatible_API_Call(l_api_version,

511: SAVEPOINT Update_Charge_Details_PUB ;
512: END IF ;
513:
514: --Standard Call to check API compatibility
515: IF NOT FND_API.Compatible_API_Call(l_api_version,
516: p_api_version,
517: l_api_name,
518: G_PKG_NAME )THEN
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

515: IF NOT FND_API.Compatible_API_Call(l_api_version,
516: p_api_version,
517: l_api_name,
518: G_PKG_NAME )THEN
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
520: END IF ;
521:
522: -- Initialize the message list if p_msg_list is set to TRUE
523: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 523: IF FND_API.To_Boolean(p_init_msg_list) THEN

519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
520: END IF ;
521:
522: -- Initialize the message list if p_msg_list is set to TRUE
523: IF FND_API.To_Boolean(p_init_msg_list) THEN
524: FND_MSG_PUB.initialize ;
525: END IF ;
526:
527:

Line 529: x_return_status := FND_API.G_RET_STS_SUCCESS ;

525: END IF ;
526:
527:
528: --Initialize the API Return Success to True
529: x_return_status := FND_API.G_RET_STS_SUCCESS ;
530:
531: ----------------------- FND Logging -----------------------------------
532: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
533: THEN

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

586: END IF;
587:
588: --Resolve Bug # 3078244
589:
590: --Convert the IN Parameters from FND_API.G_MISS_XXXX to NULL
591: --TO_NULL (p_Charges_Rec, l_Charges_Rec) ;
592:
593:
594: BEGIN

Line 599: p_init_msg_list => FND_API.G_FALSE ,

595: -- Call the PVT API for the update
596: CS_Charge_Details_PVT.Update_Charge_Details
597: (
598: p_api_version => 1.0 ,
599: p_init_msg_list => FND_API.G_FALSE ,
600: p_commit => p_commit ,
601: p_validation_level => p_validation_level,
602: x_return_status => l_return_status ,
603: x_msg_count => x_msg_count ,

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

610: p_transaction_control => p_transaction_control ,
611: p_EST_DETAIL_rec => p_Charges_Rec
612: ) ;
613:
614: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
615: RAISE FND_API.G_EXC_ERROR;
616: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;

Line 615: RAISE FND_API.G_EXC_ERROR;

611: p_EST_DETAIL_rec => p_Charges_Rec
612: ) ;
613:
614: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
615: RAISE FND_API.G_EXC_ERROR;
616: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:

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

612: ) ;
613:
614: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
615: RAISE FND_API.G_EXC_ERROR;
616: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: --End of API Body

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613:
614: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
615: RAISE FND_API.G_EXC_ERROR;
616: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: --End of API Body
621: --Standard Check of p_commit

Line 622: IF FND_API.To_Boolean( p_commit ) THEN

618: END IF;
619:
620: --End of API Body
621: --Standard Check of p_commit
622: IF FND_API.To_Boolean( p_commit ) THEN
623: COMMIT WORK ;
624: END IF ;
625:
626: --Standard call to get message count and if count is 1 , get message info

Line 634: WHEN FND_API.G_EXC_ERROR THEN

630: --Begin Exception Handling
631:
632: EXCEPTION
633:
634: WHEN FND_API.G_EXC_ERROR THEN
635: IF FND_API.To_Boolean( p_transaction_control ) THEN
636: ROLLBACK TO Update_Charge_Details_PUB;
637: END IF ;
638:

Line 635: IF FND_API.To_Boolean( p_transaction_control ) THEN

631:
632: EXCEPTION
633:
634: WHEN FND_API.G_EXC_ERROR THEN
635: IF FND_API.To_Boolean( p_transaction_control ) THEN
636: ROLLBACK TO Update_Charge_Details_PUB;
637: END IF ;
638:
639: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 639: x_return_status := FND_API.G_RET_STS_ERROR ;

635: IF FND_API.To_Boolean( p_transaction_control ) THEN
636: ROLLBACK TO Update_Charge_Details_PUB;
637: END IF ;
638:
639: x_return_status := FND_API.G_RET_STS_ERROR ;
640:
641: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
642: p_data => x_msg_data,
643: p_encoded => FND_API.G_FALSE) ;

Line 643: p_encoded => FND_API.G_FALSE) ;

639: x_return_status := FND_API.G_RET_STS_ERROR ;
640:
641: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
642: p_data => x_msg_data,
643: p_encoded => FND_API.G_FALSE) ;
644:
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: IF FND_API.To_Boolean( p_transaction_control ) THEN

Line 646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

642: p_data => x_msg_data,
643: p_encoded => FND_API.G_FALSE) ;
644:
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: IF FND_API.To_Boolean( p_transaction_control ) THEN
648: ROLLBACK TO Update_Charge_Details_PUB;
649: END IF ;
650:

Line 647: IF FND_API.To_Boolean( p_transaction_control ) THEN

643: p_encoded => FND_API.G_FALSE) ;
644:
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: IF FND_API.To_Boolean( p_transaction_control ) THEN
648: ROLLBACK TO Update_Charge_Details_PUB;
649: END IF ;
650:
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

647: IF FND_API.To_Boolean( p_transaction_control ) THEN
648: ROLLBACK TO Update_Charge_Details_PUB;
649: END IF ;
650:
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652:
653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => FND_API.G_FALSE) ;

Line 655: p_encoded => FND_API.G_FALSE) ;

651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652:
653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => FND_API.G_FALSE) ;
656: WHEN OTHERS THEN
657: IF FND_API.To_Boolean( p_transaction_control ) THEN
658: ROLLBACK TO Update_Charge_Details_PUB;
659: END IF ;

Line 657: IF FND_API.To_Boolean( p_transaction_control ) THEN

653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => FND_API.G_FALSE) ;
656: WHEN OTHERS THEN
657: IF FND_API.To_Boolean( p_transaction_control ) THEN
658: ROLLBACK TO Update_Charge_Details_PUB;
659: END IF ;
660:
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

657: IF FND_API.To_Boolean( p_transaction_control ) THEN
658: ROLLBACK TO Update_Charge_Details_PUB;
659: END IF ;
660:
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
662:
663: IF FND_MSG_PUB.Check_Msg_Level
664: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
665: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 670: p_encoded => FND_API.G_FALSE) ;

666: END IF ;
667:
668: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
669: p_data => x_msg_data,
670: p_encoded => FND_API.G_FALSE) ;
671: END ;
672:
673: --added by bkanimoz on 15-dec-2007 for service costing
674: --start

Line 689: IF l_return_status =FND_API.G_RET_STS_SUCCESS

685:
686: BEGIN
687: --Update Cost record only if charge line has been successfully updated
688:
689: IF l_return_status =FND_API.G_RET_STS_SUCCESS
690: and p_update_cost_detail ='Y'
691: and p_Charges_Rec.estimate_Detail_id IS NOT NULL then
692:
693: -- Standard Start of API Savepoint

Line 694: IF FND_API.To_Boolean( p_transaction_control ) THEN

690: and p_update_cost_detail ='Y'
691: and p_Charges_Rec.estimate_Detail_id IS NOT NULL then
692:
693: -- Standard Start of API Savepoint
694: IF FND_API.To_Boolean( p_transaction_control ) THEN
695: SAVEPOINT Update_Charge_Cost_Details_PUB ;
696: END IF ;
697:
698:

Line 713: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

709: (
710: p_api_version => 1.0 ,
711: p_init_msg_list => p_init_msg_list ,
712: p_commit => p_commit ,
713: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
714: x_return_status => l_return_status,
715: x_msg_count => x_msg_count,
716: x_object_version_number => x_object_version_number,
717: x_msg_data => x_msg_data,

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

723: p_Cost_Rec => l_cost_rec
724: );
725:
726:
727: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
728: RAISE FND_API.G_EXC_ERROR;
729: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;

Line 728: RAISE FND_API.G_EXC_ERROR;

724: );
725:
726:
727: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
728: RAISE FND_API.G_EXC_ERROR;
729: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:

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

725:
726:
727: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
728: RAISE FND_API.G_EXC_ERROR;
729: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: --End of API Body

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

726:
727: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
728: RAISE FND_API.G_EXC_ERROR;
729: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: --End of API Body
734: --standard Check of p_commit

Line 735: IF FND_API.To_Boolean( p_commit ) THEN

731: END IF;
732:
733: --End of API Body
734: --standard Check of p_commit
735: IF FND_API.To_Boolean( p_commit ) THEN
736: COMMIT WORK ;
737: END IF ;
738:
739: --Standard call to get message count and if count is 1 , get message info

Line 742: p_encoded => FND_API.G_FALSE) ;

738:
739: --Standard call to get message count and if count is 1 , get message info
740: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
741: p_data => x_msg_data,
742: p_encoded => FND_API.G_FALSE) ;
743: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
744: THEN
745: FND_LOG.String
746: ( FND_LOG.level_procedure ,

Line 757: WHEN FND_API.G_EXC_ERROR THEN

753: END IF;
754:
755: EXCEPTION
756:
757: WHEN FND_API.G_EXC_ERROR THEN
758: IF FND_API.To_Boolean( p_transaction_control ) THEN
759: ROLLBACK TO Update_Charge_Cost_Details_PUB;
760: END IF ;
761:

Line 758: IF FND_API.To_Boolean( p_transaction_control ) THEN

754:
755: EXCEPTION
756:
757: WHEN FND_API.G_EXC_ERROR THEN
758: IF FND_API.To_Boolean( p_transaction_control ) THEN
759: ROLLBACK TO Update_Charge_Cost_Details_PUB;
760: END IF ;
761:
762: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 762: x_return_status := FND_API.G_RET_STS_ERROR ;

758: IF FND_API.To_Boolean( p_transaction_control ) THEN
759: ROLLBACK TO Update_Charge_Cost_Details_PUB;
760: END IF ;
761:
762: x_return_status := FND_API.G_RET_STS_ERROR ;
763:
764: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
765: p_data => x_msg_data,
766: p_encoded => FND_API.G_FALSE) ;

Line 766: p_encoded => FND_API.G_FALSE) ;

762: x_return_status := FND_API.G_RET_STS_ERROR ;
763:
764: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
765: p_data => x_msg_data,
766: p_encoded => FND_API.G_FALSE) ;
767:
768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: IF FND_API.To_Boolean( p_transaction_control ) THEN

Line 769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

765: p_data => x_msg_data,
766: p_encoded => FND_API.G_FALSE) ;
767:
768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: IF FND_API.To_Boolean( p_transaction_control ) THEN
771: ROLLBACK TO Update_Charge_Cost_Details_PUB;
772: END IF ;
773:

Line 770: IF FND_API.To_Boolean( p_transaction_control ) THEN

766: p_encoded => FND_API.G_FALSE) ;
767:
768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: IF FND_API.To_Boolean( p_transaction_control ) THEN
771: ROLLBACK TO Update_Charge_Cost_Details_PUB;
772: END IF ;
773:
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

770: IF FND_API.To_Boolean( p_transaction_control ) THEN
771: ROLLBACK TO Update_Charge_Cost_Details_PUB;
772: END IF ;
773:
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
775:
776: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
777: p_data => x_msg_data,
778: p_encoded => FND_API.G_FALSE) ;

Line 778: p_encoded => FND_API.G_FALSE) ;

774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
775:
776: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
777: p_data => x_msg_data,
778: p_encoded => FND_API.G_FALSE) ;
779: WHEN OTHERS THEN
780: IF FND_API.To_Boolean( p_transaction_control ) THEN
781: ROLLBACK TO Update_Charge_Cost_Details_PUB;
782: END IF ;

Line 780: IF FND_API.To_Boolean( p_transaction_control ) THEN

776: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
777: p_data => x_msg_data,
778: p_encoded => FND_API.G_FALSE) ;
779: WHEN OTHERS THEN
780: IF FND_API.To_Boolean( p_transaction_control ) THEN
781: ROLLBACK TO Update_Charge_Cost_Details_PUB;
782: END IF ;
783:
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

780: IF FND_API.To_Boolean( p_transaction_control ) THEN
781: ROLLBACK TO Update_Charge_Cost_Details_PUB;
782: END IF ;
783:
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785:
786: IF FND_MSG_PUB.Check_Msg_Level
787: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
788: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 793: p_encoded => FND_API.G_FALSE) ;

789: END IF ;
790:
791: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
792: p_data => x_msg_data,
793: p_encoded => FND_API.G_FALSE) ;
794:
795:
796:
797:

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

806:
807: Procedure Delete_Charge_Details
808: (
809: p_api_version IN NUMBER,
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,

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

807: Procedure Delete_Charge_Details
808: (
809: p_api_version IN NUMBER,
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,

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

808: (
809: p_api_version IN NUMBER,
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

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

812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
817: p_estimate_detail_id IN NUMBER := NULL
818: )
819: AS
820:

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

844:
845: Procedure Delete_Charge_Details
846: (
847: p_api_version IN NUMBER,
848: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
849: p_commit IN VARCHAR2 := FND_API.G_FALSE,
850: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,

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

845: Procedure Delete_Charge_Details
846: (
847: p_api_version IN NUMBER,
848: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
849: p_commit IN VARCHAR2 := FND_API.G_FALSE,
850: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,
853: x_msg_data OUT NOCOPY VARCHAR2,

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

846: (
847: p_api_version IN NUMBER,
848: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
849: p_commit IN VARCHAR2 := FND_API.G_FALSE,
850: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,
853: x_msg_data OUT NOCOPY VARCHAR2,
854: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,

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

850: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,
853: x_msg_data OUT NOCOPY VARCHAR2,
854: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
855: p_estimate_detail_id IN NUMBER := NULL,
856: p_delete_cost_detail IN VARCHAR2--new parameter for service costing
857: ) AS
858:

Line 876: IF FND_API.To_Boolean( p_transaction_control ) THEN

872:
873: BEGIN
874:
875: -- Standard Start of API Savepoint
876: IF FND_API.To_Boolean( p_transaction_control ) THEN
877: SAVEPOINT Delete_Charge_Details_PUB ;
878: END IF ;
879:
880: -- Standard Call to check API compatibility

Line 881: IF NOT FND_API.Compatible_API_Call(l_api_version,

877: SAVEPOINT Delete_Charge_Details_PUB ;
878: END IF ;
879:
880: -- Standard Call to check API compatibility
881: IF NOT FND_API.Compatible_API_Call(l_api_version,
882: p_api_version,
883: l_api_name,
884: G_PKG_NAME ) THEN
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

881: IF NOT FND_API.Compatible_API_Call(l_api_version,
882: p_api_version,
883: l_api_name,
884: G_PKG_NAME ) THEN
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
886: END IF ;
887:
888: -- Initialize the message list if p_msg_list is set to TRUE
889: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 889: IF FND_API.To_Boolean(p_init_msg_list) THEN

885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
886: END IF ;
887:
888: -- Initialize the message list if p_msg_list is set to TRUE
889: IF FND_API.To_Boolean(p_init_msg_list) THEN
890: FND_MSG_PUB.initialize ;
891: END IF ;
892:
893:

Line 895: x_return_status := FND_API.G_RET_STS_SUCCESS ;

891: END IF ;
892:
893:
894: -- Initialize the API Return Success to True
895: x_return_status := FND_API.G_RET_STS_SUCCESS ;
896:
897: ----------------------- FND Logging -----------------------------------
898: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
899: THEN

Line 947: p_init_msg_list => FND_API.G_FALSE,

943:
944: CS_CHARGE_DETAILS_PVT.DELETE_CHARGE_DETAILS
945: (
946: p_api_version => 1.0 ,
947: p_init_msg_list => FND_API.G_FALSE,
948: p_commit => p_commit,
949: p_validation_level => p_validation_level,
950: x_return_status => l_return_status,
951: x_msg_count => x_msg_count,

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

953: p_transaction_control => p_transaction_control,
954: p_estimate_detail_id => p_estimate_detail_id
955: ) ;
956:
957: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;

Line 958: RAISE FND_API.G_EXC_ERROR;

954: p_estimate_detail_id => p_estimate_detail_id
955: ) ;
956:
957: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962:

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

955: ) ;
956:
957: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962:
963: -- End of API Body

Line 960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

956:
957: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962:
963: -- End of API Body
964: -- Standard Check of p_commit

Line 965: IF FND_API.To_Boolean( p_commit ) THEN

961: END IF;
962:
963: -- End of API Body
964: -- Standard Check of p_commit
965: IF FND_API.To_Boolean( p_commit ) THEN
966: COMMIT WORK ;
967: END IF ;
968:
969: --Standard call to get message count and if count is 1 , get message info

Line 982: WHEN FND_API.G_EXC_ERROR THEN

978: );
979: END IF ;
980: EXCEPTION
981:
982: WHEN FND_API.G_EXC_ERROR THEN
983: IF FND_API.To_Boolean( p_transaction_control ) THEN
984: ROLLBACK TO Delete_Charge_Details_PUB;
985: END IF ;
986:

Line 983: IF FND_API.To_Boolean( p_transaction_control ) THEN

979: END IF ;
980: EXCEPTION
981:
982: WHEN FND_API.G_EXC_ERROR THEN
983: IF FND_API.To_Boolean( p_transaction_control ) THEN
984: ROLLBACK TO Delete_Charge_Details_PUB;
985: END IF ;
986:
987: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 987: x_return_status := FND_API.G_RET_STS_ERROR ;

983: IF FND_API.To_Boolean( p_transaction_control ) THEN
984: ROLLBACK TO Delete_Charge_Details_PUB;
985: END IF ;
986:
987: x_return_status := FND_API.G_RET_STS_ERROR ;
988:
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
990: p_data => x_msg_data,
991: p_encoded => FND_API.G_FALSE) ;

Line 991: p_encoded => FND_API.G_FALSE) ;

987: x_return_status := FND_API.G_RET_STS_ERROR ;
988:
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
990: p_data => x_msg_data,
991: p_encoded => FND_API.G_FALSE) ;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: IF FND_API.To_Boolean( p_transaction_control ) THEN
995: ROLLBACK TO Delete_Charge_Details_PUB;

Line 993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
990: p_data => x_msg_data,
991: p_encoded => FND_API.G_FALSE) ;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: IF FND_API.To_Boolean( p_transaction_control ) THEN
995: ROLLBACK TO Delete_Charge_Details_PUB;
996: END IF ;
997:

Line 994: IF FND_API.To_Boolean( p_transaction_control ) THEN

990: p_data => x_msg_data,
991: p_encoded => FND_API.G_FALSE) ;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: IF FND_API.To_Boolean( p_transaction_control ) THEN
995: ROLLBACK TO Delete_Charge_Details_PUB;
996: END IF ;
997:
998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

994: IF FND_API.To_Boolean( p_transaction_control ) THEN
995: ROLLBACK TO Delete_Charge_Details_PUB;
996: END IF ;
997:
998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
999:
1000: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1001: p_data => x_msg_data,
1002: p_encoded => FND_API.G_FALSE) ;

Line 1002: p_encoded => FND_API.G_FALSE) ;

998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
999:
1000: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1001: p_data => x_msg_data,
1002: p_encoded => FND_API.G_FALSE) ;
1003:
1004: WHEN OTHERS THEN
1005: IF FND_API.To_Boolean( p_transaction_control ) THEN
1006: ROLLBACK TO Delete_Charge_Details_PUB;

Line 1005: IF FND_API.To_Boolean( p_transaction_control ) THEN

1001: p_data => x_msg_data,
1002: p_encoded => FND_API.G_FALSE) ;
1003:
1004: WHEN OTHERS THEN
1005: IF FND_API.To_Boolean( p_transaction_control ) THEN
1006: ROLLBACK TO Delete_Charge_Details_PUB;
1007: END IF ;
1008:
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1005: IF FND_API.To_Boolean( p_transaction_control ) THEN
1006: ROLLBACK TO Delete_Charge_Details_PUB;
1007: END IF ;
1008:
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1010:
1011: IF FND_MSG_PUB.Check_Msg_Level
1012: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1013: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 1018: p_encoded => FND_API.G_FALSE) ;

1014: END IF ;
1015:
1016: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1017: p_data => x_msg_data,
1018: p_encoded => FND_API.G_FALSE) ;
1019: END;
1020: --added by bkanimoz on 15-dec-2007 for service costing
1021: --start
1022:

Line 1030: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1026: --If charge line has been deleted successfully then call the costing api to delete the cost record
1027:
1028:
1029:
1030: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1031: -- Standard Start of API Savepoint
1032: IF FND_API.To_Boolean( p_transaction_control ) THEN
1033: SAVEPOINT Delete_Charge_Cost_Details_PUB ;
1034: END IF ;

Line 1032: IF FND_API.To_Boolean( p_transaction_control ) THEN

1028:
1029:
1030: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1031: -- Standard Start of API Savepoint
1032: IF FND_API.To_Boolean( p_transaction_control ) THEN
1033: SAVEPOINT Delete_Charge_Cost_Details_PUB ;
1034: END IF ;
1035:
1036: begin

Line 1066: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1062: (
1063: p_api_version => 1.0 ,
1064: p_init_msg_list => p_init_msg_list,
1065: p_commit => p_commit,
1066: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1067: x_return_status => l_return_status,
1068: x_msg_count => x_msg_count,
1069: x_msg_data => x_msg_data,
1070: p_transaction_control => p_transaction_control,

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

1070: p_transaction_control => p_transaction_control,
1071: p_cost_id => l_cost_id
1072: );
1073:
1074: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1075: RAISE FND_API.G_EXC_ERROR;
1076: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;

Line 1075: RAISE FND_API.G_EXC_ERROR;

1071: p_cost_id => l_cost_id
1072: );
1073:
1074: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1075: RAISE FND_API.G_EXC_ERROR;
1076: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;
1079:

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

1072: );
1073:
1074: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1075: RAISE FND_API.G_EXC_ERROR;
1076: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;
1079:
1080:

Line 1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1073:
1074: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1075: RAISE FND_API.G_EXC_ERROR;
1076: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;
1079:
1080:
1081: end if;

Line 1097: WHEN FND_API.G_EXC_ERROR THEN

1093: --Begin Exception Handling
1094:
1095: EXCEPTION
1096:
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: IF FND_API.To_Boolean( p_transaction_control ) THEN
1099: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;
1100: END IF ;
1101:

Line 1098: IF FND_API.To_Boolean( p_transaction_control ) THEN

1094:
1095: EXCEPTION
1096:
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: IF FND_API.To_Boolean( p_transaction_control ) THEN
1099: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;
1100: END IF ;
1101:
1102: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1102: x_return_status := FND_API.G_RET_STS_ERROR ;

1098: IF FND_API.To_Boolean( p_transaction_control ) THEN
1099: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;
1100: END IF ;
1101:
1102: x_return_status := FND_API.G_RET_STS_ERROR ;
1103:
1104: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1105: p_data => x_msg_data,
1106: p_encoded => FND_API.G_FALSE) ;

Line 1106: p_encoded => FND_API.G_FALSE) ;

1102: x_return_status := FND_API.G_RET_STS_ERROR ;
1103:
1104: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1105: p_data => x_msg_data,
1106: p_encoded => FND_API.G_FALSE) ;
1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109: IF FND_API.To_Boolean( p_transaction_control ) THEN
1110: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;

Line 1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1104: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1105: p_data => x_msg_data,
1106: p_encoded => FND_API.G_FALSE) ;
1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109: IF FND_API.To_Boolean( p_transaction_control ) THEN
1110: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;
1111: END IF ;
1112:

Line 1109: IF FND_API.To_Boolean( p_transaction_control ) THEN

1105: p_data => x_msg_data,
1106: p_encoded => FND_API.G_FALSE) ;
1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109: IF FND_API.To_Boolean( p_transaction_control ) THEN
1110: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;
1111: END IF ;
1112:
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1109: IF FND_API.To_Boolean( p_transaction_control ) THEN
1110: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;
1111: END IF ;
1112:
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1114:
1115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1116: p_data => x_msg_data,
1117: p_encoded => FND_API.G_FALSE) ;

Line 1117: p_encoded => FND_API.G_FALSE) ;

1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1114:
1115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1116: p_data => x_msg_data,
1117: p_encoded => FND_API.G_FALSE) ;
1118:
1119: WHEN OTHERS THEN
1120: IF FND_API.To_Boolean( p_transaction_control ) THEN
1121: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;

Line 1120: IF FND_API.To_Boolean( p_transaction_control ) THEN

1116: p_data => x_msg_data,
1117: p_encoded => FND_API.G_FALSE) ;
1118:
1119: WHEN OTHERS THEN
1120: IF FND_API.To_Boolean( p_transaction_control ) THEN
1121: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;
1122: END IF ;
1123:
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1120: IF FND_API.To_Boolean( p_transaction_control ) THEN
1121: ROLLBACK TO Delete_Charge_Cost_Details_PUB ;
1122: END IF ;
1123:
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1125:
1126: IF FND_MSG_PUB.Check_Msg_Level
1127: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1128: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 1133: p_encoded => FND_API.G_FALSE) ;

1129: END IF ;
1130:
1131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1132: p_data => x_msg_data,
1133: p_encoded => FND_API.G_FALSE) ;
1134: END;
1135:
1136: END Delete_Charge_Details; -- End of Procedure Delete Charge Details
1137:

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

1141: **************************************************/
1142:
1143: Procedure Copy_Estimate(
1144: p_api_version IN NUMBER,
1145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1147: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
1148: p_estimate_detail_id IN NUMBER := NULL,
1149: x_estimate_detail_id OUT NOCOPY NUMBER,

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

1142:
1143: Procedure Copy_Estimate(
1144: p_api_version IN NUMBER,
1145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1147: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
1148: p_estimate_detail_id IN NUMBER := NULL,
1149: x_estimate_detail_id OUT NOCOPY NUMBER,
1150: x_return_status OUT NOCOPY VARCHAR2,

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

1143: Procedure Copy_Estimate(
1144: p_api_version IN NUMBER,
1145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1147: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
1148: p_estimate_detail_id IN NUMBER := NULL,
1149: x_estimate_detail_id OUT NOCOPY NUMBER,
1150: x_return_status OUT NOCOPY VARCHAR2,
1151: x_msg_count OUT NOCOPY NUMBER,

Line 1166: IF FND_API.To_Boolean( p_transaction_control ) THEN

1162:
1163: --DBMS_OUTPUT.PUT_LINE('in Public API');
1164:
1165: -- Standard Start of API Savepoint
1166: IF FND_API.To_Boolean( p_transaction_control ) THEN
1167: SAVEPOINT Copy_Estimates_PUB ;
1168: END IF ;
1169:
1170: -- Standard Call to check API compatibility

Line 1171: IF NOT FND_API.Compatible_API_Call(l_api_version,

1167: SAVEPOINT Copy_Estimates_PUB ;
1168: END IF ;
1169:
1170: -- Standard Call to check API compatibility
1171: IF NOT FND_API.Compatible_API_Call(l_api_version,
1172: p_api_version,
1173: l_api_name,
1174: G_PKG_NAME ) THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1171: IF NOT FND_API.Compatible_API_Call(l_api_version,
1172: p_api_version,
1173: l_api_name,
1174: G_PKG_NAME ) THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1176: END IF ;
1177:
1178: -- Initialize the message list if p_msg_list is set to TRUE
1179: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1179: IF FND_API.To_Boolean(p_init_msg_list) THEN

1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1176: END IF ;
1177:
1178: -- Initialize the message list if p_msg_list is set to TRUE
1179: IF FND_API.To_Boolean(p_init_msg_list) THEN
1180: FND_MSG_PUB.initialize ;
1181: END IF ;
1182:
1183:

Line 1185: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1181: END IF ;
1182:
1183:
1184: -- Initialize the API Return Success to True
1185: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1186:
1187: ----------------------- FND Logging -----------------------------------
1188: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1189: THEN

Line 1222: p_init_msg_list => FND_API.G_FALSE,

1218: --DBMS_OUTPUT.PUT_LINE('Call Private API');
1219:
1220: CS_Charge_Details_PVT.Copy_Estimate(
1221: p_api_version => l_api_version,
1222: p_init_msg_list => FND_API.G_FALSE,
1223: p_commit => FND_API.G_FALSE,
1224: p_transaction_control => FND_API.G_FALSE,
1225: p_estimate_detail_id => p_estimate_detail_id,
1226: x_estimate_detail_id => x_estimate_detail_id,

Line 1223: p_commit => FND_API.G_FALSE,

1219:
1220: CS_Charge_Details_PVT.Copy_Estimate(
1221: p_api_version => l_api_version,
1222: p_init_msg_list => FND_API.G_FALSE,
1223: p_commit => FND_API.G_FALSE,
1224: p_transaction_control => FND_API.G_FALSE,
1225: p_estimate_detail_id => p_estimate_detail_id,
1226: x_estimate_detail_id => x_estimate_detail_id,
1227: x_return_status => l_return_status,

Line 1224: p_transaction_control => FND_API.G_FALSE,

1220: CS_Charge_Details_PVT.Copy_Estimate(
1221: p_api_version => l_api_version,
1222: p_init_msg_list => FND_API.G_FALSE,
1223: p_commit => FND_API.G_FALSE,
1224: p_transaction_control => FND_API.G_FALSE,
1225: p_estimate_detail_id => p_estimate_detail_id,
1226: x_estimate_detail_id => x_estimate_detail_id,
1227: x_return_status => l_return_status,
1228: x_msg_count => x_msg_count,

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

1230:
1231:
1232: --DBMS_OUTPUT.PUT_LINE('return status is '||l_return_status);
1233:
1234: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: END IF;

Line 1235: RAISE FND_API.G_EXC_ERROR;

1231:
1232: --DBMS_OUTPUT.PUT_LINE('return status is '||l_return_status);
1233:
1234: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: END IF;
1239:

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

1232: --DBMS_OUTPUT.PUT_LINE('return status is '||l_return_status);
1233:
1234: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: END IF;
1239:
1240:

Line 1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1233:
1234: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1235: RAISE FND_API.G_EXC_ERROR;
1236: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: END IF;
1239:
1240:
1241: -- End of API Body

Line 1243: IF FND_API.To_Boolean( p_commit ) THEN

1239:
1240:
1241: -- End of API Body
1242: -- Standard Check of p_commit
1243: IF FND_API.To_Boolean( p_commit ) THEN
1244: COMMIT WORK ;
1245: END IF ;
1246:
1247: --Standard call to get message count and if count is 1 , get message info

Line 1255: WHEN FND_API.G_EXC_ERROR THEN

1251: --Begin Exception Handling
1252:
1253: EXCEPTION
1254:
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: IF FND_API.To_Boolean( p_transaction_control ) THEN
1257: ROLLBACK TO Copy_Estimates_PUB;
1258: END IF ;
1259:

Line 1256: IF FND_API.To_Boolean( p_transaction_control ) THEN

1252:
1253: EXCEPTION
1254:
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: IF FND_API.To_Boolean( p_transaction_control ) THEN
1257: ROLLBACK TO Copy_Estimates_PUB;
1258: END IF ;
1259:
1260: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1260: x_return_status := FND_API.G_RET_STS_ERROR ;

1256: IF FND_API.To_Boolean( p_transaction_control ) THEN
1257: ROLLBACK TO Copy_Estimates_PUB;
1258: END IF ;
1259:
1260: x_return_status := FND_API.G_RET_STS_ERROR ;
1261:
1262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1263: p_data => x_msg_data,
1264: p_encoded => FND_API.G_FALSE) ;

Line 1264: p_encoded => FND_API.G_FALSE) ;

1260: x_return_status := FND_API.G_RET_STS_ERROR ;
1261:
1262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1263: p_data => x_msg_data,
1264: p_encoded => FND_API.G_FALSE) ;
1265:
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: IF FND_API.To_Boolean( p_transaction_control ) THEN
1268: ROLLBACK TO Copy_Estimates_PUB;

Line 1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1263: p_data => x_msg_data,
1264: p_encoded => FND_API.G_FALSE) ;
1265:
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: IF FND_API.To_Boolean( p_transaction_control ) THEN
1268: ROLLBACK TO Copy_Estimates_PUB;
1269: END IF ;
1270:

Line 1267: IF FND_API.To_Boolean( p_transaction_control ) THEN

1263: p_data => x_msg_data,
1264: p_encoded => FND_API.G_FALSE) ;
1265:
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: IF FND_API.To_Boolean( p_transaction_control ) THEN
1268: ROLLBACK TO Copy_Estimates_PUB;
1269: END IF ;
1270:
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1267: IF FND_API.To_Boolean( p_transaction_control ) THEN
1268: ROLLBACK TO Copy_Estimates_PUB;
1269: END IF ;
1270:
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1272:
1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1274: p_data => x_msg_data,
1275: p_encoded => FND_API.G_FALSE) ;

Line 1275: p_encoded => FND_API.G_FALSE) ;

1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1272:
1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1274: p_data => x_msg_data,
1275: p_encoded => FND_API.G_FALSE) ;
1276:
1277: WHEN OTHERS THEN
1278: IF FND_API.To_Boolean( p_transaction_control ) THEN
1279: ROLLBACK TO Copy_Estimates_PUB;

Line 1278: IF FND_API.To_Boolean( p_transaction_control ) THEN

1274: p_data => x_msg_data,
1275: p_encoded => FND_API.G_FALSE) ;
1276:
1277: WHEN OTHERS THEN
1278: IF FND_API.To_Boolean( p_transaction_control ) THEN
1279: ROLLBACK TO Copy_Estimates_PUB;
1280: END IF ;
1281:
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1278: IF FND_API.To_Boolean( p_transaction_control ) THEN
1279: ROLLBACK TO Copy_Estimates_PUB;
1280: END IF ;
1281:
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1283:
1284: IF FND_MSG_PUB.Check_Msg_Level
1285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1286: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 1291: p_encoded => FND_API.G_FALSE) ;

1287: END IF ;
1288:
1289: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1290: p_data => x_msg_data,
1291: p_encoded => FND_API.G_FALSE) ;
1292:
1293: END Copy_Estimate; -- End of Procedure Copy_Estimate
1294:
1295: /**************************************************

Line 2306: IF p_param = FND_API.G_MISS_NUM THEN

2302: Function Implementations
2303: **************************************************/
2304: FUNCTION Check_For_Miss ( p_param IN NUMBER ) RETURN NUMBER IS
2305: BEGIN
2306: IF p_param = FND_API.G_MISS_NUM THEN
2307: RETURN NULL ;
2308: ELSE
2309: RETURN p_param ;
2310: END IF ;

Line 2316: IF p_param = FND_API.G_MISS_CHAR THEN

2312:
2313:
2314: FUNCTION Check_For_Miss ( p_param IN VARCHAR2 ) RETURN VARCHAR2 IS
2315: BEGIN
2316: IF p_param = FND_API.G_MISS_CHAR THEN
2317: RETURN NULL ;
2318: ELSE
2319: RETURN p_param ;
2320: END IF ;

Line 2326: IF p_param = FND_API.G_MISS_DATE THEN

2322:
2323:
2324: FUNCTION Check_For_Miss ( p_param IN DATE ) RETURN DATE IS
2325: BEGIN
2326: IF p_param = FND_API.G_MISS_DATE THEN
2327: RETURN NULL ;
2328: ELSE
2329: RETURN p_param ;
2330: END IF ;