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.IGC_CC_MC_DET_PF_HST_PKG dependencies on FND_API

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

9: ===============================================================================*/
10:
11: PROCEDURE Insert_Row(
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:
11: PROCEDURE Insert_Row(
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_msg_data OUT NOCOPY VARCHAR2,

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

11: PROCEDURE Insert_Row(
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_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 49: IF NOT FND_API.Compatible_API_Call ( l_api_version,

45: -- -----------------------------------------------------------------
46: -- Ensure that the version requested to be used is correct for
47: -- this API.
48: -- -----------------------------------------------------------------
49: IF NOT FND_API.Compatible_API_Call ( l_api_version,
50: p_api_version,
51: l_api_name,
52: G_PKG_NAME )
53: THEN

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

50: p_api_version,
51: l_api_name,
52: G_PKG_NAME )
53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
55: END IF;
56:
57:
58: IF FND_API.to_Boolean (p_init_msg_list ) THEN

Line 58: IF FND_API.to_Boolean (p_init_msg_list ) THEN

54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
55: END IF;
56:
57:
58: IF FND_API.to_Boolean (p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize ;
60: END IF;
61:
62: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 62: X_return_status := FND_API.G_RET_STS_SUCCESS ;

58: IF FND_API.to_Boolean (p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize ;
60: END IF;
61:
62: X_return_status := FND_API.G_RET_STS_SUCCESS ;
63: -- -----------------------------------------------------------------
64: -- Insert the MRC DET PF line History record as requested.
65: -- -----------------------------------------------------------------
66: INSERT INTO IGC_CC_MC_DET_PF_HISTORY (

Line 97: RAISE FND_API.G_EXC_ERROR ;

93: INTO p_Rowid;
94:
95: if (c_det_pf_mrc_hst_rowid%NOTFOUND) then
96: CLOSE c_det_pf_mrc_hst_rowid;
97: RAISE FND_API.G_EXC_ERROR ;
98: end if;
99: CLOSE c_det_pf_mrc_hst_rowid;
100: -- -----------------------------------------------------------------
101: -- If the records are to be commited in this procedure then

Line 104: IF FND_API.To_Boolean ( p_commit ) THEN

100: -- -----------------------------------------------------------------
101: -- If the records are to be commited in this procedure then
102: -- commit the work now otherwise wait for the caller to do COMMIT.
103: -- -----------------------------------------------------------------
104: IF FND_API.To_Boolean ( p_commit ) THEN
105: COMMIT WORK;
106: END iF;
107:
108: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 114: WHEN FND_API.G_EXC_ERROR THEN

110: RETURN;
111:
112: EXCEPTION
113:
114: WHEN FND_API.G_EXC_ERROR THEN
115:
116: ROLLBACK TO Insert_Row_Pvt ;
117: X_return_status := FND_API.G_RET_STS_ERROR;
118: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN

Line 117: X_return_status := FND_API.G_RET_STS_ERROR;

113:
114: WHEN FND_API.G_EXC_ERROR THEN
115:
116: ROLLBACK TO Insert_Row_Pvt ;
117: X_return_status := FND_API.G_RET_STS_ERROR;
118: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN
119: CLOSE c_det_pf_mrc_hst_rowid;
120: END IF;
121:

Line 125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

121:
122: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
123: p_data => X_msg_data );
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126:
127: ROLLBACK TO Insert_Row_Pvt ;
128: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN

Line 128: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126:
127: ROLLBACK TO Insert_Row_Pvt ;
128: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN
130: CLOSE c_det_pf_mrc_hst_rowid;
131: END IF;
132:

Line 139: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

135:
136: WHEN OTHERS THEN
137:
138: ROLLBACK TO Insert_Row_Pvt ;
139: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN
141: CLOSE c_det_pf_mrc_hst_rowid;
142: END IF;
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

155: ===============================================================================*/
156:
157: PROCEDURE Lock_Row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162: X_return_status OUT NOCOPY VARCHAR2,
163: X_msg_count OUT NOCOPY NUMBER,

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

156:
157: PROCEDURE Lock_Row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162: X_return_status OUT NOCOPY VARCHAR2,
163: X_msg_count OUT NOCOPY NUMBER,
164: X_msg_data OUT NOCOPY VARCHAR2,

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

157: PROCEDURE Lock_Row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162: X_return_status OUT NOCOPY VARCHAR2,
163: X_msg_count OUT NOCOPY NUMBER,
164: X_msg_data OUT NOCOPY VARCHAR2,
165: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 191: IF NOT FND_API.Compatible_API_Call ( l_api_version,

187: BEGIN
188:
189: SAVEPOINT Lock_Row_Pvt ;
190:
191: IF NOT FND_API.Compatible_API_Call ( l_api_version,
192: p_api_version,
193: l_api_name,
194: G_PKG_NAME )
195: THEN

Line 196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

192: p_api_version,
193: l_api_name,
194: G_PKG_NAME )
195: THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
197: END IF;
198:
199:
200: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 200: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
197: END IF;
198:
199:
200: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
201: FND_MSG_PUB.initialize ;
202: END IF;
203:
204: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 204: X_return_status := FND_API.G_RET_STS_SUCCESS ;

200: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
201: FND_MSG_PUB.initialize ;
202: END IF;
203:
204: X_return_status := FND_API.G_RET_STS_SUCCESS ;
205: X_row_locked := FND_API.G_TRUE ;
206:
207: OPEN C;
208:

Line 205: X_row_locked := FND_API.G_TRUE ;

201: FND_MSG_PUB.initialize ;
202: END IF;
203:
204: X_return_status := FND_API.G_RET_STS_SUCCESS ;
205: X_row_locked := FND_API.G_TRUE ;
206:
207: OPEN C;
208:
209: FETCH C INTO Recinfo;

Line 214: RAISE FND_API.G_EXC_ERROR;

210: if (C%NOTFOUND) then
211: CLOSE C;
212: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
213: FND_MSG_PUB.Add;
214: RAISE FND_API.G_EXC_ERROR;
215: end if;
216: CLOSE C;
217: if (
218: (Recinfo.CC_DET_PF_Line_Id = p_CC_DET_PF_Line_Id)

Line 249: RAISE FND_API.G_EXC_ERROR ;

245: null;
246: else
247: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
248: FND_MSG_PUB.Add;
249: RAISE FND_API.G_EXC_ERROR ;
250: end if;
251:
252: IF FND_API.To_Boolean ( p_commit ) THEN
253: COMMIT WORK;

Line 252: IF FND_API.To_Boolean ( p_commit ) THEN

248: FND_MSG_PUB.Add;
249: RAISE FND_API.G_EXC_ERROR ;
250: end if;
251:
252: IF FND_API.To_Boolean ( p_commit ) THEN
253: COMMIT WORK;
254: END iF;
255:
256: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 264: X_row_locked := FND_API.G_FALSE;

260:
261: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
262:
263: ROLLBACK TO Lock_Row_Pvt ;
264: X_row_locked := FND_API.G_FALSE;
265: X_return_status := FND_API.G_RET_STS_ERROR;
266: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
267: p_data => X_msg_data );
268:

Line 265: X_return_status := FND_API.G_RET_STS_ERROR;

261: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
262:
263: ROLLBACK TO Lock_Row_Pvt ;
264: X_row_locked := FND_API.G_FALSE;
265: X_return_status := FND_API.G_RET_STS_ERROR;
266: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
267: p_data => X_msg_data );
268:
269: WHEN FND_API.G_EXC_ERROR THEN

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265: X_return_status := FND_API.G_RET_STS_ERROR;
266: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
267: p_data => X_msg_data );
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270:
271: ROLLBACK TO Lock_Row_Pvt ;
272: X_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 272: X_return_status := FND_API.G_RET_STS_ERROR;

268:
269: WHEN FND_API.G_EXC_ERROR THEN
270:
271: ROLLBACK TO Lock_Row_Pvt ;
272: X_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
274: p_data => X_msg_data );
275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

272: X_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
274: p_data => X_msg_data );
275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277:
278: ROLLBACK TO Lock_Row_Pvt ;
279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277:
278: ROLLBACK TO Lock_Row_Pvt ;
279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
281: p_data => X_msg_data );
282:
283: WHEN OTHERS THEN

Line 286: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

282:
283: WHEN OTHERS THEN
284:
285: ROLLBACK TO Lock_Row_Pvt ;
286: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287:
288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
289: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
290: l_api_name);

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

299: ===============================================================================*/
300:
301: PROCEDURE Update_Row(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: X_return_status OUT NOCOPY VARCHAR2,
307: X_msg_count OUT NOCOPY NUMBER,

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

300:
301: PROCEDURE Update_Row(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: X_return_status OUT NOCOPY VARCHAR2,
307: X_msg_count OUT NOCOPY NUMBER,
308: X_msg_data OUT NOCOPY VARCHAR2,

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

301: PROCEDURE Update_Row(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: X_return_status OUT NOCOPY VARCHAR2,
307: X_msg_count OUT NOCOPY NUMBER,
308: X_msg_data OUT NOCOPY VARCHAR2,
309: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 329: IF NOT FND_API.Compatible_API_Call ( l_api_version,

325: BEGIN
326:
327: SAVEPOINT Update_Row_Pvt ;
328:
329: IF NOT FND_API.Compatible_API_Call ( l_api_version,
330: p_api_version,
331: l_api_name,
332: G_PKG_NAME )
333: THEN

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

330: p_api_version,
331: l_api_name,
332: G_PKG_NAME )
333: THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
335: END IF;
336:
337:
338: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 338: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
335: END IF;
336:
337:
338: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
339: FND_MSG_PUB.initialize ;
340: END IF;
341:
342: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 342: X_return_status := FND_API.G_RET_STS_SUCCESS ;

338: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
339: FND_MSG_PUB.initialize ;
340: END IF;
341:
342: X_return_status := FND_API.G_RET_STS_SUCCESS ;
343:
344: UPDATE IGC_CC_MC_DET_PF_HISTORY
345: SET
346: CC_DET_PF_Line_Id = p_CC_DET_PF_Line_Id,

Line 360: IF FND_API.To_Boolean ( p_commit ) THEN

356: if (SQL%NOTFOUND) then
357: Raise NO_DATA_FOUND;
358: end if;
359:
360: IF FND_API.To_Boolean ( p_commit ) THEN
361: COMMIT WORK;
362: END iF;
363:
364: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 369: WHEN FND_API.G_EXC_ERROR THEN

365: p_data => X_msg_data );
366:
367: EXCEPTION
368:
369: WHEN FND_API.G_EXC_ERROR THEN
370:
371: ROLLBACK TO Update_Row_Pvt ;
372: X_return_status := FND_API.G_RET_STS_ERROR;
373: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 372: X_return_status := FND_API.G_RET_STS_ERROR;

368:
369: WHEN FND_API.G_EXC_ERROR THEN
370:
371: ROLLBACK TO Update_Row_Pvt ;
372: X_return_status := FND_API.G_RET_STS_ERROR;
373: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
374: p_data => X_msg_data );
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

372: X_return_status := FND_API.G_RET_STS_ERROR;
373: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
374: p_data => X_msg_data );
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377:
378: ROLLBACK TO Update_Row_Pvt ;
379: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 379: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377:
378: ROLLBACK TO Update_Row_Pvt ;
379: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
381: p_data => X_msg_data );
382:
383: WHEN OTHERS THEN

Line 386: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382:
383: WHEN OTHERS THEN
384:
385: ROLLBACK TO Update_Row_Pvt ;
386: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
389: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
390: l_api_name);

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

400: ===============================================================================*/
401:
402: PROCEDURE Delete_Row(
403: p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405: p_commit IN VARCHAR2 := FND_API.G_FALSE,
406: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
407: X_return_status OUT NOCOPY VARCHAR2,
408: X_msg_count OUT NOCOPY NUMBER,

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

401:
402: PROCEDURE Delete_Row(
403: p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405: p_commit IN VARCHAR2 := FND_API.G_FALSE,
406: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
407: X_return_status OUT NOCOPY VARCHAR2,
408: X_msg_count OUT NOCOPY NUMBER,
409: X_msg_data OUT NOCOPY VARCHAR2,

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

402: PROCEDURE Delete_Row(
403: p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405: p_commit IN VARCHAR2 := FND_API.G_FALSE,
406: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
407: X_return_status OUT NOCOPY VARCHAR2,
408: X_msg_count OUT NOCOPY NUMBER,
409: X_msg_data OUT NOCOPY VARCHAR2,
410: p_Rowid IN OUT NOCOPY VARCHAR2

Line 424: IF NOT FND_API.Compatible_API_Call ( l_api_version,

420: BEGIN
421:
422: SAVEPOINT Delete_Row_Pvt ;
423:
424: IF NOT FND_API.Compatible_API_Call ( l_api_version,
425: p_api_version,
426: l_api_name,
427: G_PKG_NAME )
428: THEN

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

425: p_api_version,
426: l_api_name,
427: G_PKG_NAME )
428: THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
430: END IF;
431:
432:
433: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 433: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
430: END IF;
431:
432:
433: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
434: FND_MSG_PUB.initialize ;
435: END IF ;
436:
437: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 437: X_return_status := FND_API.G_RET_STS_SUCCESS ;

433: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
434: FND_MSG_PUB.initialize ;
435: END IF ;
436:
437: X_return_status := FND_API.G_RET_STS_SUCCESS ;
438:
439: DELETE FROM IGC_CC_MC_DET_PF_HISTORY
440: WHERE rowid = p_Rowid;
441:

Line 446: IF FND_API.To_Boolean ( p_commit ) THEN

442: if (SQL%NOTFOUND) then
443: Raise NO_DATA_FOUND;
444: end if;
445:
446: IF FND_API.To_Boolean ( p_commit ) THEN
447: COMMIT WORK;
448: END iF;
449:
450: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 455: WHEN FND_API.G_EXC_ERROR THEN

451: p_data => X_msg_data );
452:
453: EXCEPTION
454:
455: WHEN FND_API.G_EXC_ERROR THEN
456:
457: ROLLBACK TO Delete_Row_Pvt ;
458: X_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 458: X_return_status := FND_API.G_RET_STS_ERROR;

454:
455: WHEN FND_API.G_EXC_ERROR THEN
456:
457: ROLLBACK TO Delete_Row_Pvt ;
458: X_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
460: p_data => X_msg_data );
461:
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

458: X_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
460: p_data => X_msg_data );
461:
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463:
464: ROLLBACK TO Delete_Row_Pvt ;
465: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 465: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

461:
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463:
464: ROLLBACK TO Delete_Row_Pvt ;
465: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
467: p_data => X_msg_data );
468:
469: WHEN OTHERS THEN

Line 472: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

468:
469: WHEN OTHERS THEN
470:
471: ROLLBACK TO Delete_Row_Pvt ;
472: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473:
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
475: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
476: l_api_name);