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

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

12: +=======================================================================*/
13: PROCEDURE Insert_Row
14: (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,

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

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

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

14: (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,
22:

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: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 63: x_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: x_return_status := FND_API.G_RET_STS_SUCCESS ;
64:
65: INSERT INTO igc_cc_access(
66: CC_HEADER_ID,
67: USER_ID,

Line 97: RAISE FND_API.G_EXC_ERROR ;

93: OPEN C;
94: FETCH C INTO p_row_id;
95: IF (C%NOTFOUND) THEN
96: CLOSE C;
97: RAISE FND_API.G_EXC_ERROR ;
98: END IF;
99: CLOSE C;
100:
101:

Line 102: IF FND_API.To_Boolean ( p_commit ) THEN

98: END IF;
99: CLOSE C;
100:
101:
102: IF FND_API.To_Boolean ( p_commit ) THEN
103: COMMIT WORK;
104: END iF;
105:
106: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 111: WHEN FND_API.G_EXC_ERROR THEN

107: p_data => x_msg_data );
108:
109: EXCEPTION
110:
111: WHEN FND_API.G_EXC_ERROR THEN
112:
113: ROLLBACK TO Insert_Row_Pvt ;
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110:
111: WHEN FND_API.G_EXC_ERROR THEN
112:
113: ROLLBACK TO Insert_Row_Pvt ;
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
116: p_data => x_msg_data );
117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
116: p_data => x_msg_data );
117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
119:
120: ROLLBACK TO Insert_Row_Pvt ;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
119:
120: ROLLBACK TO Insert_Row_Pvt ;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
123: p_data => x_msg_data );
124:
125: WHEN OTHERS THEN

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

124:
125: WHEN OTHERS THEN
126:
127: ROLLBACK TO Insert_Row_Pvt ;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129:
130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
131: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
132: l_api_name);

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

145: +==========================================================================*/
146: PROCEDURE Lock_Row
147: (
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,

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

146: PROCEDURE Lock_Row
147: (
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,

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

147: (
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155:

Line 183: IF NOT FND_API.Compatible_API_Call ( l_api_version,

179: BEGIN
180:
181: SAVEPOINT Lock_Row_Pvt ;
182:
183: IF NOT FND_API.Compatible_API_Call ( l_api_version,
184: p_api_version,
185: l_api_name,
186: G_PKG_NAME )
187: THEN

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

184: p_api_version,
185: l_api_name,
186: G_PKG_NAME )
187: THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
189: END IF;
190:
191:
192: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 192: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
189: END IF;
190:
191:
192: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
193: FND_MSG_PUB.initialize ;
194: END IF;
195:
196: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 196: x_return_status := FND_API.G_RET_STS_SUCCESS ;

192: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
193: FND_MSG_PUB.initialize ;
194: END IF;
195:
196: x_return_status := FND_API.G_RET_STS_SUCCESS ;
197: p_row_locked := FND_API.G_TRUE ;
198:
199: OPEN C;
200:

Line 197: p_row_locked := FND_API.G_TRUE ;

193: FND_MSG_PUB.initialize ;
194: END IF;
195:
196: x_return_status := FND_API.G_RET_STS_SUCCESS ;
197: p_row_locked := FND_API.G_TRUE ;
198:
199: OPEN C;
200:
201: FETCH C INTO Recinfo;

Line 206: RAISE FND_API.G_EXC_ERROR ;

202: IF (C%NOTFOUND) then
203: CLOSE C;
204: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
205: FND_MSG_PUB.Add;
206: RAISE FND_API.G_EXC_ERROR ;
207: END IF;
208: CLOSE C;
209:
210: IF (

Line 232: RAISE FND_API.G_EXC_ERROR ;

228: Null;
229: ELSE
230: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
231: FND_MSG_PUB.Add;
232: RAISE FND_API.G_EXC_ERROR ;
233: END IF;
234:
235:
236: IF FND_API.To_Boolean ( p_commit ) THEN

Line 236: IF FND_API.To_Boolean ( p_commit ) THEN

232: RAISE FND_API.G_EXC_ERROR ;
233: END IF;
234:
235:
236: IF FND_API.To_Boolean ( p_commit ) THEN
237: COMMIT WORK;
238: END iF;
239:
240: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 248: p_row_locked := FND_API.G_FALSE;

244:
245: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
246:
247: ROLLBACK TO Lock_Row_Pvt ;
248: p_row_locked := FND_API.G_FALSE;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
251: p_data => x_msg_data );
252:

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
246:
247: ROLLBACK TO Lock_Row_Pvt ;
248: p_row_locked := FND_API.G_FALSE;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
251: p_data => x_msg_data );
252:
253: WHEN FND_API.G_EXC_ERROR THEN

Line 253: WHEN FND_API.G_EXC_ERROR THEN

249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
251: p_data => x_msg_data );
252:
253: WHEN FND_API.G_EXC_ERROR THEN
254:
255: ROLLBACK TO Lock_Row_Pvt ;
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 256: x_return_status := FND_API.G_RET_STS_ERROR;

252:
253: WHEN FND_API.G_EXC_ERROR THEN
254:
255: ROLLBACK TO Lock_Row_Pvt ;
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
258: p_data => x_msg_data );
259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

256: x_return_status := FND_API.G_RET_STS_ERROR;
257: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
258: p_data => x_msg_data );
259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261:
262: ROLLBACK TO Lock_Row_Pvt ;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261:
262: ROLLBACK TO Lock_Row_Pvt ;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
265: p_data => x_msg_data );
266:
267: WHEN OTHERS THEN

Line 270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

266:
267: WHEN OTHERS THEN
268:
269: ROLLBACK TO Lock_Row_Pvt ;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271:
272: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
273: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
274: l_api_name);

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

288: +==========================================================================*/
289: PROCEDURE Update_Row
290: (
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,

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

289: PROCEDURE Update_Row
290: (
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,

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

290: (
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298:

Line 319: IF NOT FND_API.Compatible_API_Call ( l_api_version,

315: BEGIN
316:
317: SAVEPOINT Update_Row_Pvt ;
318:
319: IF NOT FND_API.Compatible_API_Call ( l_api_version,
320: p_api_version,
321: l_api_name,
322: G_PKG_NAME )
323: THEN

Line 324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

320: p_api_version,
321: l_api_name,
322: G_PKG_NAME )
323: THEN
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
325: END IF;
326:
327:
328: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 328: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
325: END IF;
326:
327:
328: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
329: FND_MSG_PUB.initialize ;
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS ;

328: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
329: FND_MSG_PUB.initialize ;
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS ;
333:
334:
335: UPDATE igc_cc_access
336: SET

Line 353: IF FND_API.To_Boolean ( p_commit ) THEN

349: RAISE NO_DATA_FOUND ;
350: END IF;
351:
352:
353: IF FND_API.To_Boolean ( p_commit ) THEN
354: COMMIT WORK;
355: END iF;
356:
357: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 362: WHEN FND_API.G_EXC_ERROR THEN

358: p_data => x_msg_data );
359:
360: EXCEPTION
361:
362: WHEN FND_API.G_EXC_ERROR THEN
363:
364: ROLLBACK TO Update_Row_Pvt ;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 365: x_return_status := FND_API.G_RET_STS_ERROR;

361:
362: WHEN FND_API.G_EXC_ERROR THEN
363:
364: ROLLBACK TO Update_Row_Pvt ;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
367: p_data => x_msg_data );
368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

365: x_return_status := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
367: p_data => x_msg_data );
368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370:
371: ROLLBACK TO Update_Row_Pvt ;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370:
371: ROLLBACK TO Update_Row_Pvt ;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
374: p_data => x_msg_data );
375:
376: WHEN OTHERS THEN

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375:
376: WHEN OTHERS THEN
377:
378: ROLLBACK TO Update_Row_Pvt ;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380:
381: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
382: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
383: l_api_name);

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

397: +==========================================================================*/
398: PROCEDURE Delete_Row
399: (
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
402: p_commit IN VARCHAR2 := FND_API.G_FALSE,
403: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,

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

398: PROCEDURE Delete_Row
399: (
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
402: p_commit IN VARCHAR2 := FND_API.G_FALSE,
403: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,
406: x_msg_data OUT NOCOPY VARCHAR2,

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

399: (
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
402: p_commit IN VARCHAR2 := FND_API.G_FALSE,
403: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,
406: x_msg_data OUT NOCOPY VARCHAR2,
407:

Line 423: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 432: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS ;

432: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
433: FND_MSG_PUB.initialize ;
434: END IF ;
435:
436: x_return_status := FND_API.G_RET_STS_SUCCESS ;
437:
438: -- Deleting the record in psb_dss_fdi_filters.
439:
440: DELETE FROM igc_cc_access

Line 449: IF FND_API.To_Boolean ( p_commit ) THEN

445: RAISE NO_DATA_FOUND ;
446: END IF;
447:
448:
449: IF FND_API.To_Boolean ( p_commit ) THEN
450: COMMIT WORK;
451: END iF;
452:
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 458: WHEN FND_API.G_EXC_ERROR THEN

454: p_data => x_msg_data );
455:
456: EXCEPTION
457:
458: WHEN FND_API.G_EXC_ERROR THEN
459:
460: ROLLBACK TO Delete_Row_Pvt ;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457:
458: WHEN FND_API.G_EXC_ERROR THEN
459:
460: ROLLBACK TO Delete_Row_Pvt ;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
463: p_data => x_msg_data );
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

461: x_return_status := FND_API.G_RET_STS_ERROR;
462: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
463: p_data => x_msg_data );
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466:
467: ROLLBACK TO Delete_Row_Pvt ;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466:
467: ROLLBACK TO Delete_Row_Pvt ;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
470: p_data => x_msg_data );
471:
472: WHEN OTHERS THEN

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471:
472: WHEN OTHERS THEN
473:
474: ROLLBACK TO Delete_Row_Pvt ;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476:
477: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
478: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
479: l_api_name);

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

491: +==========================================================================*/
492: PROCEDURE Check_Unique
493: (
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,

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

492: PROCEDURE Check_Unique
493: (
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,

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

493: (
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,
501: --

Line 527: IF NOT FND_API.Compatible_API_Call ( l_api_version,

523: BEGIN
524:
525: SAVEPOINT Check_Unique_Pvt ;
526:
527: IF NOT FND_API.Compatible_API_Call ( l_api_version,
528: p_api_version,
529: l_api_name,
530: G_PKG_NAME )
531: THEN

Line 532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

528: p_api_version,
529: l_api_name,
530: G_PKG_NAME )
531: THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
533: END IF;
534:
535:
536: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 536: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
533: END IF;
534:
535:
536: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
537: FND_MSG_PUB.initialize ;
538: END IF;
539:
540: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 540: x_return_status := FND_API.G_RET_STS_SUCCESS ;

536: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
537: FND_MSG_PUB.initialize ;
538: END IF;
539:
540: x_return_status := FND_API.G_RET_STS_SUCCESS ;
541:
542: -- Checking the Psb_dss_fni_data_items table for references.
543: OPEN c;
544: FETCH c INTO l_tmp;

Line 555: IF FND_API.To_Boolean ( p_commit ) THEN

551: END IF;
552:
553: CLOSE c;
554:
555: IF FND_API.To_Boolean ( p_commit ) THEN
556: COMMIT WORK;
557: END iF;
558:
559: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 564: WHEN FND_API.G_EXC_ERROR THEN

560: p_data => x_msg_data );
561:
562: EXCEPTION
563:
564: WHEN FND_API.G_EXC_ERROR THEN
565:
566: ROLLBACK TO Check_Unique_Pvt ;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 567: x_return_status := FND_API.G_RET_STS_ERROR;

563:
564: WHEN FND_API.G_EXC_ERROR THEN
565:
566: ROLLBACK TO Check_Unique_Pvt ;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
569: p_data => x_msg_data );
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

567: x_return_status := FND_API.G_RET_STS_ERROR;
568: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
569: p_data => x_msg_data );
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572:
573: ROLLBACK TO Check_Unique_Pvt ;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572:
573: ROLLBACK TO Check_Unique_Pvt ;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
576: p_data => x_msg_data );
577:
578: WHEN OTHERS THEN

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

577:
578: WHEN OTHERS THEN
579:
580: ROLLBACK TO Check_Unique_Pvt ;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582:
583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
584: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
585: l_api_name);