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

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

13:
14:
15: PROCEDURE Insert_Row(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: X_return_status OUT NOCOPY VARCHAR2,
21: X_msg_count OUT NOCOPY NUMBER,

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

14:
15: PROCEDURE Insert_Row(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: X_return_status OUT NOCOPY VARCHAR2,
21: X_msg_count OUT NOCOPY NUMBER,
22: X_msg_data OUT NOCOPY VARCHAR2,

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

15: PROCEDURE Insert_Row(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: X_return_status OUT NOCOPY VARCHAR2,
21: X_msg_count OUT NOCOPY NUMBER,
22: X_msg_data OUT NOCOPY VARCHAR2,
23: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 62: IF NOT FND_API.Compatible_API_Call ( l_api_version,

58: END IF;
59: CLOSE C1;
60:
61:
62: IF NOT FND_API.Compatible_API_Call ( l_api_version,
63: p_api_version,
64: l_api_name,
65: G_PKG_NAME )
66: THEN

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

63: p_api_version,
64: l_api_name,
65: G_PKG_NAME )
66: THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
68: END IF;
69:
70:
71: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 71: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
68: END IF;
69:
70:
71: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
72: FND_MSG_PUB.initialize ;
73: END IF;
74:
75: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 75: X_return_status := FND_API.G_RET_STS_SUCCESS ;

71: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
72: FND_MSG_PUB.initialize ;
73: END IF;
74:
75: X_return_status := FND_API.G_RET_STS_SUCCESS ;
76:
77:
78: INSERT INTO IGC_CC_ACTIONS(
79: CC_Header_Id,

Line 118: IF FND_API.To_Boolean ( p_commit ) THEN

114: Raise NO_DATA_FOUND;
115: end if;
116: CLOSE C;
117:
118: IF FND_API.To_Boolean ( p_commit ) THEN
119: COMMIT WORK;
120: END iF;
121:
122: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 127: WHEN FND_API.G_EXC_ERROR THEN

123: p_data => X_msg_data );
124:
125: EXCEPTION
126:
127: WHEN FND_API.G_EXC_ERROR THEN
128:
129: ROLLBACK TO Insert_Row_Pvt ;
130: X_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 130: X_return_status := FND_API.G_RET_STS_ERROR;

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

Line 134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

130: X_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
132: p_data => X_msg_data );
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135:
136: ROLLBACK TO Insert_Row_Pvt ;
137: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 137: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135:
136: ROLLBACK TO Insert_Row_Pvt ;
137: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
139: p_data => X_msg_data );
140:
141: WHEN OTHERS THEN

Line 144: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

140:
141: WHEN OTHERS THEN
142:
143: ROLLBACK TO Insert_Row_Pvt ;
144: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145:
146: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
147: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
148: l_api_name);

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

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

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

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

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

164:
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: X_return_status OUT NOCOPY VARCHAR2,
170: X_msg_count OUT NOCOPY NUMBER,
171: X_msg_data OUT NOCOPY VARCHAR2,
172: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 204: IF NOT FND_API.Compatible_API_Call ( l_api_version,

200: BEGIN
201:
202: SAVEPOINT Lock_Row_Pvt ;
203:
204: IF NOT FND_API.Compatible_API_Call ( l_api_version,
205: p_api_version,
206: l_api_name,
207: G_PKG_NAME )
208: THEN

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

205: p_api_version,
206: l_api_name,
207: G_PKG_NAME )
208: THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
210: END IF;
211:
212:
213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
210: END IF;
211:
212:
213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
214: FND_MSG_PUB.initialize ;
215: END IF;
216:
217: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 217: X_return_status := FND_API.G_RET_STS_SUCCESS ;

213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
214: FND_MSG_PUB.initialize ;
215: END IF;
216:
217: X_return_status := FND_API.G_RET_STS_SUCCESS ;
218: X_row_locked := FND_API.G_TRUE ;
219:
220:
221: OPEN C;

Line 218: X_row_locked := FND_API.G_TRUE ;

214: FND_MSG_PUB.initialize ;
215: END IF;
216:
217: X_return_status := FND_API.G_RET_STS_SUCCESS ;
218: X_row_locked := FND_API.G_TRUE ;
219:
220:
221: OPEN C;
222:

Line 228: RAISE FND_API.G_EXC_ERROR ;

224: if (C%NOTFOUND) then
225: CLOSE C;
226: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
227: FND_MSG_PUB.Add;
228: RAISE FND_API.G_EXC_ERROR ;
229: end if;
230:
231: CLOSE C;
232:

Line 276: RAISE FND_API.G_EXC_ERROR ;

272: null;
273: else
274: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_ERROR ;
277:
278: end if;
279:
280: IF FND_API.To_Boolean ( p_commit ) THEN

Line 280: IF FND_API.To_Boolean ( p_commit ) THEN

276: RAISE FND_API.G_EXC_ERROR ;
277:
278: end if;
279:
280: IF FND_API.To_Boolean ( p_commit ) THEN
281: COMMIT WORK;
282: END iF;
283:
284: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 292: X_row_locked := FND_API.G_FALSE;

288:
289: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
290:
291: ROLLBACK TO Lock_Row_Pvt ;
292: X_row_locked := FND_API.G_FALSE;
293: X_return_status := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
295: p_data => X_msg_data );
296:

Line 293: X_return_status := FND_API.G_RET_STS_ERROR;

289: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
290:
291: ROLLBACK TO Lock_Row_Pvt ;
292: X_row_locked := FND_API.G_FALSE;
293: X_return_status := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
295: p_data => X_msg_data );
296:
297: WHEN FND_API.G_EXC_ERROR THEN

Line 297: WHEN FND_API.G_EXC_ERROR THEN

293: X_return_status := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
295: p_data => X_msg_data );
296:
297: WHEN FND_API.G_EXC_ERROR THEN
298:
299: ROLLBACK TO Lock_Row_Pvt ;
300: X_return_status := FND_API.G_RET_STS_ERROR;
301: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 300: X_return_status := FND_API.G_RET_STS_ERROR;

296:
297: WHEN FND_API.G_EXC_ERROR THEN
298:
299: ROLLBACK TO Lock_Row_Pvt ;
300: X_return_status := FND_API.G_RET_STS_ERROR;
301: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
302: p_data => X_msg_data );
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

300: X_return_status := FND_API.G_RET_STS_ERROR;
301: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
302: p_data => X_msg_data );
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305:
306: ROLLBACK TO Lock_Row_Pvt ;
307: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 307: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305:
306: ROLLBACK TO Lock_Row_Pvt ;
307: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
309: p_data => X_msg_data );
310:
311: WHEN OTHERS THEN

Line 314: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

310:
311: WHEN OTHERS THEN
312:
313: ROLLBACK TO Lock_Row_Pvt ;
314: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315:
316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
317: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
318: l_api_name);

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

330:
331:
332: PROCEDURE Update_Row(
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
337: X_return_status OUT NOCOPY VARCHAR2,
338: X_msg_count OUT NOCOPY NUMBER,

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

331:
332: PROCEDURE Update_Row(
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
337: X_return_status OUT NOCOPY VARCHAR2,
338: X_msg_count OUT NOCOPY NUMBER,
339: X_msg_data OUT NOCOPY VARCHAR2,

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

332: PROCEDURE Update_Row(
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
337: X_return_status OUT NOCOPY VARCHAR2,
338: X_msg_count OUT NOCOPY NUMBER,
339: X_msg_data OUT NOCOPY VARCHAR2,
340: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 363: IF NOT FND_API.Compatible_API_Call ( l_api_version,

359: BEGIN
360:
361: SAVEPOINT Update_Row_Pvt ;
362:
363: IF NOT FND_API.Compatible_API_Call ( l_api_version,
364: p_api_version,
365: l_api_name,
366: G_PKG_NAME )
367: THEN

Line 368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

364: p_api_version,
365: l_api_name,
366: G_PKG_NAME )
367: THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
369: END IF;
370:
371:
372: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 372: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
369: END IF;
370:
371:
372: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
373: FND_MSG_PUB.initialize ;
374: END IF;
375:
376: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 376: X_return_status := FND_API.G_RET_STS_SUCCESS ;

372: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
373: FND_MSG_PUB.initialize ;
374: END IF;
375:
376: X_return_status := FND_API.G_RET_STS_SUCCESS ;
377:
378: UPDATE IGC_CC_ACTIONS
379: SET
380:

Line 399: IF FND_API.To_Boolean ( p_commit ) THEN

395: if (SQL%NOTFOUND) then
396: Raise NO_DATA_FOUND;
397: end if;
398:
399: IF FND_API.To_Boolean ( p_commit ) THEN
400: COMMIT WORK;
401: END iF;
402:
403: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: p_data => X_msg_data );
405:
406: EXCEPTION
407:
408: WHEN FND_API.G_EXC_ERROR THEN
409:
410: ROLLBACK TO Update_Row_Pvt ;
411: X_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 411: X_return_status := FND_API.G_RET_STS_ERROR;

407:
408: WHEN FND_API.G_EXC_ERROR THEN
409:
410: ROLLBACK TO Update_Row_Pvt ;
411: X_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
413: p_data => X_msg_data );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: X_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
413: p_data => X_msg_data );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416:
417: ROLLBACK TO Update_Row_Pvt ;
418: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 418: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416:
417: ROLLBACK TO Update_Row_Pvt ;
418: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
420: p_data => X_msg_data );
421:
422: WHEN OTHERS THEN

Line 425: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

421:
422: WHEN OTHERS THEN
423:
424: ROLLBACK TO Update_Row_Pvt ;
425: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426:
427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
428: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
429: l_api_name);

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

440: ===============================================================================*/
441:
442: PROCEDURE Delete_Row(
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
447: X_return_status OUT NOCOPY VARCHAR2,
448: X_msg_count OUT NOCOPY NUMBER,

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

441:
442: PROCEDURE Delete_Row(
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
447: X_return_status OUT NOCOPY VARCHAR2,
448: X_msg_count OUT NOCOPY NUMBER,
449: X_msg_data OUT NOCOPY VARCHAR2,

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

442: PROCEDURE Delete_Row(
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
447: X_return_status OUT NOCOPY VARCHAR2,
448: X_msg_count OUT NOCOPY NUMBER,
449: X_msg_data OUT NOCOPY VARCHAR2,
450: p_Rowid VARCHAR2

Line 464: IF NOT FND_API.Compatible_API_Call ( l_api_version,

460: BEGIN
461:
462: SAVEPOINT Delete_Row_Pvt ;
463:
464: IF NOT FND_API.Compatible_API_Call ( l_api_version,
465: p_api_version,
466: l_api_name,
467: G_PKG_NAME )
468: THEN

Line 469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

465: p_api_version,
466: l_api_name,
467: G_PKG_NAME )
468: THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
470: END IF;
471:
472:
473: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 473: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
470: END IF;
471:
472:
473: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
474: FND_MSG_PUB.initialize ;
475: END IF ;
476:
477: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 477: X_return_status := FND_API.G_RET_STS_SUCCESS ;

473: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
474: FND_MSG_PUB.initialize ;
475: END IF ;
476:
477: X_return_status := FND_API.G_RET_STS_SUCCESS ;
478:
479: DELETE FROM IGC_CC_ACTIONS
480: WHERE rowid = p_Rowid;
481: if (SQL%NOTFOUND) then

Line 485: IF FND_API.To_Boolean ( p_commit ) THEN

481: if (SQL%NOTFOUND) then
482: Raise NO_DATA_FOUND;
483: end if;
484:
485: IF FND_API.To_Boolean ( p_commit ) THEN
486: COMMIT WORK;
487: END iF;
488:
489: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 494: WHEN FND_API.G_EXC_ERROR THEN

490: p_data => X_msg_data );
491:
492: EXCEPTION
493:
494: WHEN FND_API.G_EXC_ERROR THEN
495:
496: ROLLBACK TO Delete_Row_Pvt ;
497: X_return_status := FND_API.G_RET_STS_ERROR;
498: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 497: X_return_status := FND_API.G_RET_STS_ERROR;

493:
494: WHEN FND_API.G_EXC_ERROR THEN
495:
496: ROLLBACK TO Delete_Row_Pvt ;
497: X_return_status := FND_API.G_RET_STS_ERROR;
498: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
499: p_data => X_msg_data );
500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

497: X_return_status := FND_API.G_RET_STS_ERROR;
498: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
499: p_data => X_msg_data );
500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502:
503: ROLLBACK TO Delete_Row_Pvt ;
504: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 504: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502:
503: ROLLBACK TO Delete_Row_Pvt ;
504: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
506: p_data => X_msg_data );
507:
508: WHEN OTHERS THEN

Line 511: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

507:
508: WHEN OTHERS THEN
509:
510: ROLLBACK TO Delete_Row_Pvt ;
511: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512:
513: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
514: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
515: l_api_name);