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

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

10:
11: PROCEDURE Insert_Row
12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,

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

11: PROCEDURE Insert_Row
12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,

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

12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,
20: --

Line 50: IF NOT FND_API.Compatible_API_Call ( l_api_version,

46: BEGIN
47: --
48: SAVEPOINT Insert_Row_Pvt ;
49: --
50: IF NOT FND_API.Compatible_API_Call ( l_api_version,
51: p_api_version,
52: l_api_name,
53: G_PKG_NAME )
54: THEN

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 59: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 63: p_return_status := FND_API.G_RET_STS_SUCCESS ;

59: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
60: FND_MSG_PUB.initialize ;
61: END IF;
62: --
63: p_return_status := FND_API.G_RET_STS_SUCCESS ;
64: --
65:
66: IF ( p_distribution_id is NULL ) THEN
67: OPEN C2;

Line 103: RAISE FND_API.G_EXC_ERROR ;

99: OPEN C;
100: FETCH C INTO p_Row_Id;
101: IF (C%NOTFOUND) THEN
102: CLOSE C;
103: RAISE FND_API.G_EXC_ERROR ;
104: END IF;
105: CLOSE C;
106: --
107:

Line 109: IF FND_API.To_Boolean ( p_commit ) THEN

105: CLOSE C;
106: --
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 => p_msg_count,

Line 118: WHEN FND_API.G_EXC_ERROR THEN

114: p_data => p_msg_data );
115: --
116: EXCEPTION
117: --
118: WHEN FND_API.G_EXC_ERROR THEN
119: --
120: ROLLBACK TO Insert_Row_Pvt ;
121: p_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 121: p_return_status := FND_API.G_RET_STS_ERROR;

117: --
118: WHEN FND_API.G_EXC_ERROR THEN
119: --
120: ROLLBACK TO Insert_Row_Pvt ;
121: p_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
123: p_data => p_msg_data );
124: --
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

121: p_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
123: p_data => p_msg_data );
124: --
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: --
127: ROLLBACK TO Insert_Row_Pvt ;
128: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 128: p_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: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
130: p_data => p_msg_data );
131: --
132: WHEN OTHERS THEN

Line 135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

131: --
132: WHEN OTHERS THEN
133: --
134: ROLLBACK TO Insert_Row_Pvt ;
135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: --
137: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
138: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
139: l_api_name);

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

153:
154: PROCEDURE Lock_Row
155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: p_return_status OUT NOCOPY VARCHAR2,
161: p_msg_count OUT NOCOPY NUMBER,

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

154: PROCEDURE Lock_Row
155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: p_return_status OUT NOCOPY VARCHAR2,
161: p_msg_count OUT NOCOPY NUMBER,
162: p_msg_data OUT NOCOPY VARCHAR2,

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

155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: p_return_status OUT NOCOPY VARCHAR2,
161: p_msg_count OUT NOCOPY NUMBER,
162: p_msg_data OUT NOCOPY VARCHAR2,
163: --

Line 194: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 203: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
200: END IF;
201: --
202:
203: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
204: FND_MSG_PUB.initialize ;
205: END IF;
206: --
207: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 207: p_return_status := FND_API.G_RET_STS_SUCCESS ;

203: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
204: FND_MSG_PUB.initialize ;
205: END IF;
206: --
207: p_return_status := FND_API.G_RET_STS_SUCCESS ;
208: p_row_locked := FND_API.G_TRUE ;
209: --
210: OPEN C;
211: --

Line 208: p_row_locked := FND_API.G_TRUE ;

204: FND_MSG_PUB.initialize ;
205: END IF;
206: --
207: p_return_status := FND_API.G_RET_STS_SUCCESS ;
208: p_row_locked := FND_API.G_TRUE ;
209: --
210: OPEN C;
211: --
212: FETCH C INTO Recinfo;

Line 217: RAISE FND_API.G_EXC_ERROR ;

213: IF (C%NOTFOUND) then
214: CLOSE C;
215: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
216: FND_MSG_PUB.Add;
217: RAISE FND_API.G_EXC_ERROR ;
218: END IF;
219: CLOSE C;
220: IF
221: (

Line 241: RAISE FND_API.G_EXC_ERROR ;

237: NULL ;
238: ELSE
239: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED') ;
240: FND_MSG_PUB.Add ;
241: RAISE FND_API.G_EXC_ERROR ;
242: END IF;
243:
244: --
245: IF FND_API.To_Boolean ( p_commit ) THEN

Line 245: IF FND_API.To_Boolean ( p_commit ) THEN

241: RAISE FND_API.G_EXC_ERROR ;
242: END IF;
243:
244: --
245: IF FND_API.To_Boolean ( p_commit ) THEN
246: COMMIT WORK;
247: END iF;
248: --
249: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 257: p_row_locked := FND_API.G_FALSE ;

253: --
254: WHEN App_Exception.Record_Lock_Exception THEN
255: --
256: ROLLBACK TO Lock_Row_Pvt ;
257: p_row_locked := FND_API.G_FALSE ;
258: p_return_status := FND_API.G_RET_STS_ERROR ;
259: --
260: WHEN FND_API.G_EXC_ERROR THEN
261: --

Line 258: p_return_status := FND_API.G_RET_STS_ERROR ;

254: WHEN App_Exception.Record_Lock_Exception THEN
255: --
256: ROLLBACK TO Lock_Row_Pvt ;
257: p_row_locked := FND_API.G_FALSE ;
258: p_return_status := FND_API.G_RET_STS_ERROR ;
259: --
260: WHEN FND_API.G_EXC_ERROR THEN
261: --
262: ROLLBACK TO Lock_Row_Pvt ;

Line 260: WHEN FND_API.G_EXC_ERROR THEN

256: ROLLBACK TO Lock_Row_Pvt ;
257: p_row_locked := FND_API.G_FALSE ;
258: p_return_status := FND_API.G_RET_STS_ERROR ;
259: --
260: WHEN FND_API.G_EXC_ERROR THEN
261: --
262: ROLLBACK TO Lock_Row_Pvt ;
263: p_return_status := FND_API.G_RET_STS_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 263: p_return_status := FND_API.G_RET_STS_ERROR;

259: --
260: WHEN FND_API.G_EXC_ERROR THEN
261: --
262: ROLLBACK TO Lock_Row_Pvt ;
263: p_return_status := FND_API.G_RET_STS_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
265: p_data => p_msg_data );
266: --
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263: p_return_status := FND_API.G_RET_STS_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
265: p_data => p_msg_data );
266: --
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: --
269: ROLLBACK TO Lock_Row_Pvt ;
270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

266: --
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: --
269: ROLLBACK TO Lock_Row_Pvt ;
270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
272: p_data => p_msg_data );
273: --
274: WHEN OTHERS THEN

Line 277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

273: --
274: WHEN OTHERS THEN
275: --
276: ROLLBACK TO Lock_Row_Pvt ;
277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: --
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
280: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
281: l_api_name);

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

296:
297: PROCEDURE Update_Row
298: (
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
301: p_commit IN VARCHAR2 := FND_API.G_FALSE,
302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
303: p_return_status OUT NOCOPY VARCHAR2,
304: p_msg_count OUT NOCOPY NUMBER,

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

297: PROCEDURE Update_Row
298: (
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
301: p_commit IN VARCHAR2 := FND_API.G_FALSE,
302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
303: p_return_status OUT NOCOPY VARCHAR2,
304: p_msg_count OUT NOCOPY NUMBER,
305: p_msg_data OUT NOCOPY VARCHAR2,

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

298: (
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
301: p_commit IN VARCHAR2 := FND_API.G_FALSE,
302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
303: p_return_status OUT NOCOPY VARCHAR2,
304: p_msg_count OUT NOCOPY NUMBER,
305: p_msg_data OUT NOCOPY VARCHAR2,
306: --

Line 326: IF NOT FND_API.Compatible_API_Call ( l_api_version,

322: BEGIN
323: --
324: SAVEPOINT Update_Row_Pvt ;
325: --
326: IF NOT FND_API.Compatible_API_Call ( l_api_version,
327: p_api_version,
328: l_api_name,
329: G_PKG_NAME )
330: THEN

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

327: p_api_version,
328: l_api_name,
329: G_PKG_NAME )
330: THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
332: END IF;
333: --
334:
335: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 335: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
332: END IF;
333: --
334:
335: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
336: FND_MSG_PUB.initialize ;
337: END IF;
338: --
339: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 339: p_return_status := FND_API.G_RET_STS_SUCCESS ;

335: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
336: FND_MSG_PUB.initialize ;
337: END IF;
338: --
339: p_return_status := FND_API.G_RET_STS_SUCCESS ;
340: --
341:
342: UPDATE psb_ws_distributions
343: SET

Line 359: IF FND_API.To_Boolean ( p_commit ) THEN

355: RAISE NO_DATA_FOUND ;
356: END IF;
357:
358: --
359: IF FND_API.To_Boolean ( p_commit ) THEN
360: COMMIT WORK;
361: END iF;
362: --
363: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 368: WHEN FND_API.G_EXC_ERROR THEN

364: p_data => p_msg_data );
365: --
366: EXCEPTION
367: --
368: WHEN FND_API.G_EXC_ERROR THEN
369: --
370: ROLLBACK TO Update_Row_Pvt ;
371: p_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 371: p_return_status := FND_API.G_RET_STS_ERROR;

367: --
368: WHEN FND_API.G_EXC_ERROR THEN
369: --
370: ROLLBACK TO Update_Row_Pvt ;
371: p_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
373: p_data => p_msg_data );
374: --
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

371: p_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
373: p_data => p_msg_data );
374: --
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: --
377: ROLLBACK TO Update_Row_Pvt ;
378: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 378: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

374: --
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: --
377: ROLLBACK TO Update_Row_Pvt ;
378: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
380: p_data => p_msg_data );
381: --
382: WHEN OTHERS THEN

Line 385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

404:
405: PROCEDURE Delete_Row
406: (
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
411: p_return_status OUT NOCOPY VARCHAR2,
412: p_msg_count OUT NOCOPY NUMBER,

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

405: PROCEDURE Delete_Row
406: (
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
411: p_return_status OUT NOCOPY VARCHAR2,
412: p_msg_count OUT NOCOPY NUMBER,
413: p_msg_data OUT NOCOPY VARCHAR2,

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

406: (
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
411: p_return_status OUT NOCOPY VARCHAR2,
412: p_msg_count OUT NOCOPY NUMBER,
413: p_msg_data OUT NOCOPY VARCHAR2,
414: --

Line 429: IF NOT FND_API.Compatible_API_Call ( l_api_version,

425: BEGIN
426: --
427: SAVEPOINT Delete_Row_Pvt ;
428: --
429: IF NOT FND_API.Compatible_API_Call ( l_api_version,
430: p_api_version,
431: l_api_name,
432: G_PKG_NAME )
433: THEN

Line 434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

430: p_api_version,
431: l_api_name,
432: G_PKG_NAME )
433: THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
435: END IF;
436: --
437:
438: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 438: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
435: END IF;
436: --
437:
438: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
439: FND_MSG_PUB.initialize ;
440: END IF;
441: --
442: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 442: p_return_status := FND_API.G_RET_STS_SUCCESS ;

438: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
439: FND_MSG_PUB.initialize ;
440: END IF;
441: --
442: p_return_status := FND_API.G_RET_STS_SUCCESS ;
443: --
444:
445: --
446: -- Deleting the record in psb_ws_distributions.

Line 456: IF FND_API.To_Boolean ( p_commit ) THEN

452: RAISE NO_DATA_FOUND ;
453: END IF;
454:
455: --
456: IF FND_API.To_Boolean ( p_commit ) THEN
457: COMMIT WORK;
458: END iF;
459: --
460: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 465: WHEN FND_API.G_EXC_ERROR THEN

461: p_data => p_msg_data );
462:
463: EXCEPTION
464: --
465: WHEN FND_API.G_EXC_ERROR THEN
466: --
467: ROLLBACK TO Delete_Row_Pvt ;
468: p_return_status := FND_API.G_RET_STS_ERROR;
469: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 468: p_return_status := FND_API.G_RET_STS_ERROR;

464: --
465: WHEN FND_API.G_EXC_ERROR THEN
466: --
467: ROLLBACK TO Delete_Row_Pvt ;
468: p_return_status := FND_API.G_RET_STS_ERROR;
469: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
470: p_data => p_msg_data );
471: --
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

468: p_return_status := FND_API.G_RET_STS_ERROR;
469: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
470: p_data => p_msg_data );
471: --
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: --
474: ROLLBACK TO Delete_Row_Pvt ;
475: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 475: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: --
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: --
474: ROLLBACK TO Delete_Row_Pvt ;
475: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
477: p_data => p_msg_data );
478: --
479: WHEN OTHERS THEN

Line 482: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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