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_ACCT_LINE_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 Account line history record as requested.
65: -- -----------------------------------------------------------------
66: INSERT INTO IGC_CC_MC_ACCT_LINE_HISTORY (

Line 101: RAISE FND_API.G_EXC_ERROR ;

97: -- If no ROWID can be obtained then exit the procedure with a failure
98: -- -------------------------------------------------------------------
99: if (C_Acct_mrc_hst_rowid %NOTFOUND) then
100: CLOSE C_Acct_mrc_hst_rowid ;
101: RAISE FND_API.G_EXC_ERROR ;
102: end if;
103: CLOSE C_Acct_mrc_hst_rowid ;
104: -- -----------------------------------------------------------------
105: -- If the records are to be commited in this procedure then

Line 109: IF FND_API.To_Boolean ( p_commit ) THEN

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

Line 119: WHEN FND_API.G_EXC_ERROR THEN

115: RETURN;
116:
117: EXCEPTION
118:
119: WHEN FND_API.G_EXC_ERROR THEN
120:
121: ROLLBACK TO Insert_Row_Pvt ;
122: X_return_status := FND_API.G_RET_STS_ERROR;
123: IF (C_Acct_mrc_hst_rowid %ISOPEN) THEN

Line 122: X_return_status := FND_API.G_RET_STS_ERROR;

118:
119: WHEN FND_API.G_EXC_ERROR THEN
120:
121: ROLLBACK TO Insert_Row_Pvt ;
122: X_return_status := FND_API.G_RET_STS_ERROR;
123: IF (C_Acct_mrc_hst_rowid %ISOPEN) THEN
124: CLOSE C_Acct_mrc_hst_rowid ;
125: END IF;
126:

Line 130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

126:
127: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
128: p_data => X_msg_data );
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131:
132: ROLLBACK TO Insert_Row_Pvt ;
133: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF (C_Acct_mrc_hst_rowid %ISOPEN) THEN

Line 133: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131:
132: ROLLBACK TO Insert_Row_Pvt ;
133: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF (C_Acct_mrc_hst_rowid %ISOPEN) THEN
135: CLOSE C_Acct_mrc_hst_rowid ;
136: END IF;
137: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 143: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

139:
140: WHEN OTHERS THEN
141:
142: ROLLBACK TO Insert_Row_Pvt ;
143: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF (C_Acct_mrc_hst_rowid %ISOPEN) THEN
145: CLOSE C_Acct_mrc_hst_rowid ;
146: END IF;
147: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

159: ===============================================================================*/
160:
161: PROCEDURE Lock_Row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: X_return_status OUT NOCOPY VARCHAR2,
167: X_msg_count OUT NOCOPY NUMBER,

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

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

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

161: PROCEDURE Lock_Row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: X_return_status OUT NOCOPY VARCHAR2,
167: X_msg_count OUT NOCOPY NUMBER,
168: X_msg_data OUT NOCOPY VARCHAR2,
169: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 196: IF NOT FND_API.Compatible_API_Call ( l_api_version,

192: BEGIN
193:
194: SAVEPOINT Lock_Row_Pvt ;
195:
196: IF NOT FND_API.Compatible_API_Call ( l_api_version,
197: p_api_version,
198: l_api_name,
199: G_PKG_NAME )
200: THEN

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

197: p_api_version,
198: l_api_name,
199: G_PKG_NAME )
200: THEN
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
202: END IF;
203:
204:
205: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 205: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
202: END IF;
203:
204:
205: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
206: FND_MSG_PUB.initialize ;
207: END IF;
208:
209: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 209: X_return_status := FND_API.G_RET_STS_SUCCESS ;

205: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
206: FND_MSG_PUB.initialize ;
207: END IF;
208:
209: X_return_status := FND_API.G_RET_STS_SUCCESS ;
210: X_row_locked := FND_API.G_TRUE ;
211:
212: OPEN C;
213:

Line 210: X_row_locked := FND_API.G_TRUE ;

206: FND_MSG_PUB.initialize ;
207: END IF;
208:
209: X_return_status := FND_API.G_RET_STS_SUCCESS ;
210: X_row_locked := FND_API.G_TRUE ;
211:
212: OPEN C;
213:
214: FETCH C INTO Recinfo;

Line 219: RAISE FND_API.G_EXC_ERROR;

215: if (C%NOTFOUND) then
216: CLOSE C;
217: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
218: FND_MSG_PUB.Add;
219: RAISE FND_API.G_EXC_ERROR;
220: end if;
221: CLOSE C;
222: if (
223: (Recinfo.CC_Acct_Line_Id = p_CC_Acct_Line_Id)

Line 257: RAISE FND_API.G_EXC_ERROR ;

253: null;
254: else
255: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
256: FND_MSG_PUB.Add;
257: RAISE FND_API.G_EXC_ERROR ;
258: end if;
259:
260: IF FND_API.To_Boolean ( p_commit ) THEN
261: COMMIT WORK;

Line 260: IF FND_API.To_Boolean ( p_commit ) THEN

256: FND_MSG_PUB.Add;
257: RAISE FND_API.G_EXC_ERROR ;
258: end if;
259:
260: IF FND_API.To_Boolean ( p_commit ) THEN
261: COMMIT WORK;
262: END iF;
263:
264: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 272: X_row_locked := FND_API.G_FALSE;

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

Line 273: X_return_status := FND_API.G_RET_STS_ERROR;

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

Line 277: WHEN FND_API.G_EXC_ERROR THEN

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

Line 280: X_return_status := FND_API.G_RET_STS_ERROR;

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

Line 284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

280: X_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
282: p_data => X_msg_data );
283:
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285:
286: ROLLBACK TO Lock_Row_Pvt ;
287: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 287: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283:
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285:
286: ROLLBACK TO Lock_Row_Pvt ;
287: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
289: p_data => X_msg_data );
290:
291: WHEN OTHERS THEN

Line 294: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290:
291: WHEN OTHERS THEN
292:
293: ROLLBACK TO Lock_Row_Pvt ;
294: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295:
296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
297: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
298: l_api_name);

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

307: ===============================================================================*/
308:
309: PROCEDURE Update_Row(
310: p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
312: p_commit IN VARCHAR2 := FND_API.G_FALSE,
313: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314: X_return_status OUT NOCOPY VARCHAR2,
315: X_msg_count OUT NOCOPY NUMBER,

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

308:
309: PROCEDURE Update_Row(
310: p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
312: p_commit IN VARCHAR2 := FND_API.G_FALSE,
313: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314: X_return_status OUT NOCOPY VARCHAR2,
315: X_msg_count OUT NOCOPY NUMBER,
316: X_msg_data OUT NOCOPY VARCHAR2,

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

309: PROCEDURE Update_Row(
310: p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
312: p_commit IN VARCHAR2 := FND_API.G_FALSE,
313: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314: X_return_status OUT NOCOPY VARCHAR2,
315: X_msg_count OUT NOCOPY NUMBER,
316: X_msg_data OUT NOCOPY VARCHAR2,
317: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 337: IF NOT FND_API.Compatible_API_Call ( l_api_version,

333: BEGIN
334:
335: SAVEPOINT Update_Row_Pvt ;
336:
337: IF NOT FND_API.Compatible_API_Call ( l_api_version,
338: p_api_version,
339: l_api_name,
340: G_PKG_NAME )
341: THEN

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

338: p_api_version,
339: l_api_name,
340: G_PKG_NAME )
341: THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
343: END IF;
344:
345:
346: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 346: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
343: END IF;
344:
345:
346: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
347: FND_MSG_PUB.initialize ;
348: END IF;
349:
350: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 350: X_return_status := FND_API.G_RET_STS_SUCCESS ;

346: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
347: FND_MSG_PUB.initialize ;
348: END IF;
349:
350: X_return_status := FND_API.G_RET_STS_SUCCESS ;
351:
352: UPDATE IGC_CC_MC_ACCT_LINE_HISTORY
353: SET
354: CC_Acct_Line_Id = p_CC_Acct_Line_Id,

Line 369: IF FND_API.To_Boolean ( p_commit ) THEN

365: if (SQL%NOTFOUND) then
366: Raise NO_DATA_FOUND;
367: end if;
368:
369: IF FND_API.To_Boolean ( p_commit ) THEN
370: COMMIT WORK;
371: END iF;
372:
373: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 378: WHEN FND_API.G_EXC_ERROR THEN

374: p_data => X_msg_data );
375:
376: EXCEPTION
377:
378: WHEN FND_API.G_EXC_ERROR THEN
379:
380: ROLLBACK TO Update_Row_Pvt ;
381: X_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 381: X_return_status := FND_API.G_RET_STS_ERROR;

377:
378: WHEN FND_API.G_EXC_ERROR THEN
379:
380: ROLLBACK TO Update_Row_Pvt ;
381: X_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
383: p_data => X_msg_data );
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

381: X_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
383: p_data => X_msg_data );
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386:
387: ROLLBACK TO Update_Row_Pvt ;
388: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 388: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386:
387: ROLLBACK TO Update_Row_Pvt ;
388: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
390: p_data => X_msg_data );
391:
392: WHEN OTHERS THEN

Line 395: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

391:
392: WHEN OTHERS THEN
393:
394: ROLLBACK TO Update_Row_Pvt ;
395: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396:
397: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
398: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
399: l_api_name);

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

409: ===============================================================================*/
410:
411: PROCEDURE Delete_Row(
412: p_api_version IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE,
415: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: X_return_status OUT NOCOPY VARCHAR2,
417: X_msg_count OUT NOCOPY NUMBER,

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

410:
411: PROCEDURE Delete_Row(
412: p_api_version IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE,
415: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: X_return_status OUT NOCOPY VARCHAR2,
417: X_msg_count OUT NOCOPY NUMBER,
418: X_msg_data OUT NOCOPY VARCHAR2,

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

411: PROCEDURE Delete_Row(
412: p_api_version IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE,
415: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: X_return_status OUT NOCOPY VARCHAR2,
417: X_msg_count OUT NOCOPY NUMBER,
418: X_msg_data OUT NOCOPY VARCHAR2,
419: p_Rowid IN OUT NOCOPY VARCHAR2

Line 433: IF NOT FND_API.Compatible_API_Call ( l_api_version,

429: BEGIN
430:
431: SAVEPOINT Delete_Row_Pvt ;
432:
433: IF NOT FND_API.Compatible_API_Call ( l_api_version,
434: p_api_version,
435: l_api_name,
436: G_PKG_NAME )
437: THEN

Line 438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

434: p_api_version,
435: l_api_name,
436: G_PKG_NAME )
437: THEN
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
439: END IF;
440:
441:
442: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 442: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
439: END IF;
440:
441:
442: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
443: FND_MSG_PUB.initialize ;
444: END IF ;
445:
446: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 446: X_return_status := FND_API.G_RET_STS_SUCCESS ;

442: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
443: FND_MSG_PUB.initialize ;
444: END IF ;
445:
446: X_return_status := FND_API.G_RET_STS_SUCCESS ;
447:
448: DELETE FROM IGC_CC_MC_ACCT_LINE_HISTORY
449: WHERE rowid = p_Rowid;
450:

Line 455: IF FND_API.To_Boolean ( p_commit ) THEN

451: if (SQL%NOTFOUND) then
452: Raise NO_DATA_FOUND;
453: end if;
454:
455: IF FND_API.To_Boolean ( p_commit ) THEN
456: COMMIT WORK;
457: END iF;
458:
459: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 464: WHEN FND_API.G_EXC_ERROR THEN

460: p_data => X_msg_data );
461:
462: EXCEPTION
463:
464: WHEN FND_API.G_EXC_ERROR THEN
465:
466: ROLLBACK TO Delete_Row_Pvt ;
467: X_return_status := FND_API.G_RET_STS_ERROR;
468: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 467: X_return_status := FND_API.G_RET_STS_ERROR;

463:
464: WHEN FND_API.G_EXC_ERROR THEN
465:
466: ROLLBACK TO Delete_Row_Pvt ;
467: X_return_status := FND_API.G_RET_STS_ERROR;
468: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
469: p_data => X_msg_data );
470:
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

467: X_return_status := FND_API.G_RET_STS_ERROR;
468: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
469: p_data => X_msg_data );
470:
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472:
473: ROLLBACK TO Delete_Row_Pvt ;
474: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 474: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

470:
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472:
473: ROLLBACK TO Delete_Row_Pvt ;
474: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
476: p_data => X_msg_data );
477:
478: WHEN OTHERS THEN

Line 481: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

477:
478: WHEN OTHERS THEN
479:
480: ROLLBACK TO Delete_Row_Pvt ;
481: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482:
483: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
484: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
485: l_api_name);