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

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

23: +=======================================================================*/
24: PROCEDURE Insert_Row
25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_return_status OUT NOCOPY VARCHAR2,
31: p_msg_count OUT NOCOPY NUMBER,

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

24: PROCEDURE Insert_Row
25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_return_status OUT NOCOPY VARCHAR2,
31: p_msg_count OUT NOCOPY NUMBER,
32: p_msg_data OUT NOCOPY VARCHAR2,

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

25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_return_status OUT NOCOPY VARCHAR2,
31: p_msg_count OUT NOCOPY NUMBER,
32: p_msg_data OUT NOCOPY VARCHAR2,
33: --

Line 73: IF NOT FND_API.Compatible_API_Call ( l_api_version,

69: BEGIN
70: --
71: SAVEPOINT Insert_Row_Pvt ;
72: --
73: IF NOT FND_API.Compatible_API_Call ( l_api_version,
74: p_api_version,
75: l_api_name,
76: G_PKG_NAME )
77: THEN

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

74: p_api_version,
75: l_api_name,
76: G_PKG_NAME )
77: THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
79: END IF;
80: --
81:
82: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 82: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
79: END IF;
80: --
81:
82: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize ;
84: END IF;
85: --
86: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 86: p_return_status := FND_API.G_RET_STS_SUCCESS ;

82: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize ;
84: END IF;
85: --
86: p_return_status := FND_API.G_RET_STS_SUCCESS ;
87: --
88:
89: IF ( p_gl_budget_set_id IS NULL ) THEN
90: OPEN C2;

Line 143: RAISE FND_API.G_EXC_ERROR ;

139: OPEN C;
140: FETCH C INTO p_row_id;
141: IF (C%NOTFOUND) THEN
142: CLOSE C;
143: RAISE FND_API.G_EXC_ERROR ;
144: END IF;
145: CLOSE C;
146: --
147:

Line 149: IF FND_API.To_Boolean ( p_commit ) THEN

145: CLOSE C;
146: --
147:
148: --
149: IF FND_API.To_Boolean ( p_commit ) THEN
150: COMMIT WORK;
151: END iF;
152: --
153: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 158: WHEN FND_API.G_EXC_ERROR THEN

154: p_data => p_msg_data );
155: --
156: EXCEPTION
157: --
158: WHEN FND_API.G_EXC_ERROR THEN
159: --
160: ROLLBACK TO Insert_Row_Pvt ;
161: p_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 161: p_return_status := FND_API.G_RET_STS_ERROR;

157: --
158: WHEN FND_API.G_EXC_ERROR THEN
159: --
160: ROLLBACK TO Insert_Row_Pvt ;
161: p_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
163: p_data => p_msg_data );
164: --
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

161: p_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
163: p_data => p_msg_data );
164: --
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: --
167: ROLLBACK TO Insert_Row_Pvt ;
168: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 168: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

164: --
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: --
167: ROLLBACK TO Insert_Row_Pvt ;
168: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
170: p_data => p_msg_data );
171: --
172: WHEN OTHERS THEN

Line 175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: --
172: WHEN OTHERS THEN
173: --
174: ROLLBACK TO Insert_Row_Pvt ;
175: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: --
177: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
179: l_api_name);

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

192: +==========================================================================*/
193: PROCEDURE Lock_Row
194: (
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_return_status OUT NOCOPY VARCHAR2,
200: p_msg_count OUT NOCOPY NUMBER,

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

193: PROCEDURE Lock_Row
194: (
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_return_status OUT NOCOPY VARCHAR2,
200: p_msg_count OUT NOCOPY NUMBER,
201: p_msg_data OUT NOCOPY VARCHAR2,

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

194: (
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_return_status OUT NOCOPY VARCHAR2,
200: p_msg_count OUT NOCOPY NUMBER,
201: p_msg_data OUT NOCOPY VARCHAR2,
202: --

Line 238: IF NOT FND_API.Compatible_API_Call ( l_api_version,

234: BEGIN
235: --
236: SAVEPOINT Lock_Row_Pvt ;
237: --
238: IF NOT FND_API.Compatible_API_Call ( l_api_version,
239: p_api_version,
240: l_api_name,
241: G_PKG_NAME )
242: THEN

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

239: p_api_version,
240: l_api_name,
241: G_PKG_NAME )
242: THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
244: END IF;
245: --
246:
247: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 247: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
244: END IF;
245: --
246:
247: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
248: FND_MSG_PUB.initialize ;
249: END IF;
250: --
251: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 251: p_return_status := FND_API.G_RET_STS_SUCCESS ;

247: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
248: FND_MSG_PUB.initialize ;
249: END IF;
250: --
251: p_return_status := FND_API.G_RET_STS_SUCCESS ;
252: p_row_locked := FND_API.G_TRUE ;
253: --
254: OPEN C;
255: --

Line 252: p_row_locked := FND_API.G_TRUE ;

248: FND_MSG_PUB.initialize ;
249: END IF;
250: --
251: p_return_status := FND_API.G_RET_STS_SUCCESS ;
252: p_row_locked := FND_API.G_TRUE ;
253: --
254: OPEN C;
255: --
256: FETCH C INTO Recinfo;

Line 261: RAISE FND_API.G_EXC_ERROR ;

257: IF (C%NOTFOUND) then
258: CLOSE C;
259: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
260: FND_MSG_PUB.Add;
261: RAISE FND_API.G_EXC_ERROR ;
262: END IF;
263: CLOSE C;
264: IF
265: (

Line 325: RAISE FND_API.G_EXC_ERROR ;

321: Null;
322: ELSE
323: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
324: FND_MSG_PUB.Add;
325: RAISE FND_API.G_EXC_ERROR ;
326: END IF;
327:
328: --
329: IF FND_API.To_Boolean ( p_commit ) THEN

Line 329: IF FND_API.To_Boolean ( p_commit ) THEN

325: RAISE FND_API.G_EXC_ERROR ;
326: END IF;
327:
328: --
329: IF FND_API.To_Boolean ( p_commit ) THEN
330: COMMIT WORK;
331: END iF;
332: --
333: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 341: p_row_locked := FND_API.G_FALSE;

337: --
338: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
339: --
340: ROLLBACK TO Lock_Row_Pvt ;
341: p_row_locked := FND_API.G_FALSE;
342: p_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
344: p_data => p_msg_data );
345: --

Line 342: p_return_status := FND_API.G_RET_STS_ERROR;

338: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
339: --
340: ROLLBACK TO Lock_Row_Pvt ;
341: p_row_locked := FND_API.G_FALSE;
342: p_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
344: p_data => p_msg_data );
345: --
346: WHEN FND_API.G_EXC_ERROR THEN

Line 346: WHEN FND_API.G_EXC_ERROR THEN

342: p_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
344: p_data => p_msg_data );
345: --
346: WHEN FND_API.G_EXC_ERROR THEN
347: --
348: ROLLBACK TO Lock_Row_Pvt ;
349: p_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 349: p_return_status := FND_API.G_RET_STS_ERROR;

345: --
346: WHEN FND_API.G_EXC_ERROR THEN
347: --
348: ROLLBACK TO Lock_Row_Pvt ;
349: p_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
351: p_data => p_msg_data );
352: --
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

349: p_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
351: p_data => p_msg_data );
352: --
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: --
355: ROLLBACK TO Lock_Row_Pvt ;
356: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 356: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: --
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: --
355: ROLLBACK TO Lock_Row_Pvt ;
356: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
358: p_data => p_msg_data );
359: --
360: WHEN OTHERS THEN

Line 363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

359: --
360: WHEN OTHERS THEN
361: --
362: ROLLBACK TO Lock_Row_Pvt ;
363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364: --
365: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
366: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
367: l_api_name);

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

380: +==========================================================================*/
381: PROCEDURE Update_Row
382: (
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
385: p_commit IN VARCHAR2 := FND_API.G_FALSE,
386: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
387: p_return_status OUT NOCOPY VARCHAR2,
388: p_msg_count OUT NOCOPY NUMBER,

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

381: PROCEDURE Update_Row
382: (
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
385: p_commit IN VARCHAR2 := FND_API.G_FALSE,
386: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
387: p_return_status OUT NOCOPY VARCHAR2,
388: p_msg_count OUT NOCOPY NUMBER,
389: p_msg_data OUT NOCOPY VARCHAR2,

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

382: (
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
385: p_commit IN VARCHAR2 := FND_API.G_FALSE,
386: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
387: p_return_status OUT NOCOPY VARCHAR2,
388: p_msg_count OUT NOCOPY NUMBER,
389: p_msg_data OUT NOCOPY VARCHAR2,
390: --

Line 418: IF NOT FND_API.Compatible_API_Call ( l_api_version,

414: BEGIN
415: --
416: SAVEPOINT Update_Row_Pvt ;
417: --
418: IF NOT FND_API.Compatible_API_Call ( l_api_version,
419: p_api_version,
420: l_api_name,
421: G_PKG_NAME )
422: THEN

Line 423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

419: p_api_version,
420: l_api_name,
421: G_PKG_NAME )
422: THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
424: END IF;
425: --
426:
427: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 427: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
424: END IF;
425: --
426:
427: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize ;
429: END IF;
430: --
431: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 431: p_return_status := FND_API.G_RET_STS_SUCCESS ;

427: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize ;
429: END IF;
430: --
431: p_return_status := FND_API.G_RET_STS_SUCCESS ;
432: --
433:
434: UPDATE psb_gl_budget_sets
435: SET gl_budget_set_name = p_gl_budget_set_name ,

Line 458: IF FND_API.To_Boolean ( p_commit ) THEN

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

Line 467: WHEN FND_API.G_EXC_ERROR THEN

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

Line 470: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 477: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 484: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

501: +==========================================================================*/
502: PROCEDURE Delete_Row
503: (
504: p_api_version IN NUMBER,
505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
506: p_commit IN VARCHAR2 := FND_API.G_FALSE,
507: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
508: p_return_status OUT NOCOPY VARCHAR2,
509: p_msg_count OUT NOCOPY NUMBER,

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

502: PROCEDURE Delete_Row
503: (
504: p_api_version IN NUMBER,
505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
506: p_commit IN VARCHAR2 := FND_API.G_FALSE,
507: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
508: p_return_status OUT NOCOPY VARCHAR2,
509: p_msg_count OUT NOCOPY NUMBER,
510: p_msg_data OUT NOCOPY VARCHAR2,

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

503: (
504: p_api_version IN NUMBER,
505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
506: p_commit IN VARCHAR2 := FND_API.G_FALSE,
507: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
508: p_return_status OUT NOCOPY VARCHAR2,
509: p_msg_count OUT NOCOPY NUMBER,
510: p_msg_data OUT NOCOPY VARCHAR2,
511: --

Line 529: IF NOT FND_API.Compatible_API_Call ( l_api_version,

525: BEGIN
526: --
527: SAVEPOINT Delete_Row_Pvt ;
528: --
529: IF NOT FND_API.Compatible_API_Call ( l_api_version,
530: p_api_version,
531: l_api_name,
532: G_PKG_NAME )
533: THEN

Line 534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 538: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
535: END IF;
536: --
537:
538: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
539: FND_MSG_PUB.initialize ;
540: END IF ;
541: --
542: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 542: p_return_status := FND_API.G_RET_STS_SUCCESS ;

538: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
539: FND_MSG_PUB.initialize ;
540: END IF ;
541: --
542: p_return_status := FND_API.G_RET_STS_SUCCESS ;
543: --
544:
545: --
546: -- Deleting dependent detail records from psb_gl_budgets.

Line 568: p_init_msg_list => FND_API.G_FALSE,

564: --
565: PSB_GL_Budget_Pvt.Delete_Row
566: (
567: p_api_version => 1.0 ,
568: p_init_msg_list => FND_API.G_FALSE,
569: p_commit => FND_API.G_FALSE,
570: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
571: p_return_status => l_return_status,
572: p_msg_count => l_msg_count,

Line 569: p_commit => FND_API.G_FALSE,

565: PSB_GL_Budget_Pvt.Delete_Row
566: (
567: p_api_version => 1.0 ,
568: p_init_msg_list => FND_API.G_FALSE,
569: p_commit => FND_API.G_FALSE,
570: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
571: p_return_status => l_return_status,
572: p_msg_count => l_msg_count,
573: p_msg_data => l_msg_data,

Line 570: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

566: (
567: p_api_version => 1.0 ,
568: p_init_msg_list => FND_API.G_FALSE,
569: p_commit => FND_API.G_FALSE,
570: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
571: p_return_status => l_return_status,
572: p_msg_count => l_msg_count,
573: p_msg_data => l_msg_data,
574: --

Line 578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

574: --
575: p_row_id => l_budget_rec.rowid
576: );
577: --
578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
580: END IF ;
581: --
582: END LOOP ;

Line 579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

575: p_row_id => l_budget_rec.rowid
576: );
577: --
578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
580: END IF ;
581: --
582: END LOOP ;
583: --

Line 597: IF FND_API.To_Boolean ( p_commit ) THEN

593: RAISE NO_DATA_FOUND ;
594: END IF;
595:
596: --
597: IF FND_API.To_Boolean ( p_commit ) THEN
598: COMMIT WORK;
599: END iF;
600: --
601: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 606: WHEN FND_API.G_EXC_ERROR THEN

602: p_data => p_msg_data );
603:
604: EXCEPTION
605: --
606: WHEN FND_API.G_EXC_ERROR THEN
607: --
608: ROLLBACK TO Delete_Row_Pvt ;
609: p_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 609: p_return_status := FND_API.G_RET_STS_ERROR;

605: --
606: WHEN FND_API.G_EXC_ERROR THEN
607: --
608: ROLLBACK TO Delete_Row_Pvt ;
609: p_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
611: p_data => p_msg_data );
612: --
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

609: p_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
611: p_data => p_msg_data );
612: --
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: --
615: ROLLBACK TO Delete_Row_Pvt ;
616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

612: --
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: --
615: ROLLBACK TO Delete_Row_Pvt ;
616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
618: p_data => p_msg_data );
619: --
620: WHEN OTHERS THEN

Line 623: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

619: --
620: WHEN OTHERS THEN
621: --
622: ROLLBACK TO Delete_Row_Pvt ;
623: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: --
625: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
627: l_api_name);

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

640: +==========================================================================*/
641: PROCEDURE Check_Unique
642: (
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: p_return_status OUT NOCOPY VARCHAR2,
648: p_msg_count OUT NOCOPY NUMBER,

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

641: PROCEDURE Check_Unique
642: (
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: p_return_status OUT NOCOPY VARCHAR2,
648: p_msg_count OUT NOCOPY NUMBER,
649: p_msg_data OUT NOCOPY VARCHAR2,

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

642: (
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: p_return_status OUT NOCOPY VARCHAR2,
648: p_msg_count OUT NOCOPY NUMBER,
649: p_msg_data OUT NOCOPY VARCHAR2,
650: --

Line 678: IF NOT FND_API.Compatible_API_Call ( l_api_version,

674: BEGIN
675: --
676: SAVEPOINT Check_Unique_Pvt ;
677: --
678: IF NOT FND_API.Compatible_API_Call ( l_api_version,
679: p_api_version,
680: l_api_name,
681: G_PKG_NAME )
682: THEN

Line 683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

679: p_api_version,
680: l_api_name,
681: G_PKG_NAME )
682: THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
684: END IF;
685: --
686:
687: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 687: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
684: END IF;
685: --
686:
687: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
688: FND_MSG_PUB.initialize ;
689: END IF;
690: --
691: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 691: p_return_status := FND_API.G_RET_STS_SUCCESS ;

687: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
688: FND_MSG_PUB.initialize ;
689: END IF;
690: --
691: p_return_status := FND_API.G_RET_STS_SUCCESS ;
692: --
693:
694: -- Checking the Psb_set_relations table for references.
695: OPEN c;

Line 707: IF FND_API.To_Boolean ( p_commit ) THEN

703: END IF;
704:
705: CLOSE c;
706: --
707: IF FND_API.To_Boolean ( p_commit ) THEN
708: COMMIT WORK;
709: END iF;
710: --
711: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 716: WHEN FND_API.G_EXC_ERROR THEN

712: p_data => p_msg_data );
713: --
714: EXCEPTION
715: --
716: WHEN FND_API.G_EXC_ERROR THEN
717: --
718: ROLLBACK TO Check_Unique_Pvt ;
719: p_return_status := FND_API.G_RET_STS_ERROR;
720: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 719: p_return_status := FND_API.G_RET_STS_ERROR;

715: --
716: WHEN FND_API.G_EXC_ERROR THEN
717: --
718: ROLLBACK TO Check_Unique_Pvt ;
719: p_return_status := FND_API.G_RET_STS_ERROR;
720: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
721: p_data => p_msg_data );
722: --
723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

719: p_return_status := FND_API.G_RET_STS_ERROR;
720: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
721: p_data => p_msg_data );
722: --
723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
724: --
725: ROLLBACK TO Check_Unique_Pvt ;
726: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
727: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 726: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

722: --
723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
724: --
725: ROLLBACK TO Check_Unique_Pvt ;
726: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
727: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
728: p_data => p_msg_data );
729: --
730: WHEN OTHERS THEN

Line 733: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

729: --
730: WHEN OTHERS THEN
731: --
732: ROLLBACK TO Check_Unique_Pvt ;
733: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: --
735: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
736: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
737: l_api_name);

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

750: +==========================================================================*/
751: PROCEDURE Validate_Account_Overlap
752: (
753: p_api_version IN NUMBER,
754: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
755: p_commit IN VARCHAR2 := FND_API.G_FALSE,
756: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
757: p_return_status OUT NOCOPY VARCHAR2,
758: p_msg_count OUT NOCOPY NUMBER,

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

751: PROCEDURE Validate_Account_Overlap
752: (
753: p_api_version IN NUMBER,
754: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
755: p_commit IN VARCHAR2 := FND_API.G_FALSE,
756: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
757: p_return_status OUT NOCOPY VARCHAR2,
758: p_msg_count OUT NOCOPY NUMBER,
759: p_msg_data OUT NOCOPY VARCHAR2,

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

752: (
753: p_api_version IN NUMBER,
754: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
755: p_commit IN VARCHAR2 := FND_API.G_FALSE,
756: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
757: p_return_status OUT NOCOPY VARCHAR2,
758: p_msg_count OUT NOCOPY NUMBER,
759: p_msg_data OUT NOCOPY VARCHAR2,
760: --

Line 782: IF NOT FND_API.Compatible_API_Call ( l_api_version,

778: BEGIN
779: --
780: SAVEPOINT Validate_Account_Overlap_Pvt ;
781: --
782: IF NOT FND_API.Compatible_API_Call ( l_api_version,
783: p_api_version,
784: l_api_name,
785: G_PKG_NAME )
786: THEN

Line 787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

783: p_api_version,
784: l_api_name,
785: G_PKG_NAME )
786: THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
788: END IF;
789: --
790:
791: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 791: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
788: END IF;
789: --
790:
791: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
792: FND_MSG_PUB.initialize ;
793: END IF ;
794: --
795: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 795: p_return_status := FND_API.G_RET_STS_SUCCESS ;

791: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
792: FND_MSG_PUB.initialize ;
793: END IF ;
794: --
795: p_return_status := FND_API.G_RET_STS_SUCCESS ;
796: --
797: p_validation_status := FND_API.G_RET_STS_SUCCESS ;
798: --
799: -- Scan all the GL budgets to check for the overlap one at a time.

Line 797: p_validation_status := FND_API.G_RET_STS_SUCCESS ;

793: END IF ;
794: --
795: p_return_status := FND_API.G_RET_STS_SUCCESS ;
796: --
797: p_validation_status := FND_API.G_RET_STS_SUCCESS ;
798: --
799: -- Scan all the GL budgets to check for the overlap one at a time.
800: --
801: FOR l_gl_budget_rec IN

Line 866: p_validation_status := FND_API.G_RET_STS_ERROR;

862: NVL( gb.dual_posting_type, 'P' )
863: )
864: LOOP
865:
866: p_validation_status := FND_API.G_RET_STS_ERROR;
867:
868: -- Set the budget name being validated on the stack. To be done
869: -- only one.
870: IF l_first_time_flag = 'Y' THEN

Line 901: IF FND_API.To_Boolean ( p_commit ) THEN

897: --
898: END LOOP ; -- End processing GL budgets related to p_gl_budget_set_id.
899:
900: --
901: IF FND_API.To_Boolean ( p_commit ) THEN
902: COMMIT WORK;
903: END iF;
904: --
905: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 910: WHEN FND_API.G_EXC_ERROR THEN

906: p_data => p_msg_data );
907:
908: EXCEPTION
909: --
910: WHEN FND_API.G_EXC_ERROR THEN
911: --
912: ROLLBACK TO Validate_Account_Overlap_Pvt ;
913: p_return_status := FND_API.G_RET_STS_ERROR;
914: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 913: p_return_status := FND_API.G_RET_STS_ERROR;

909: --
910: WHEN FND_API.G_EXC_ERROR THEN
911: --
912: ROLLBACK TO Validate_Account_Overlap_Pvt ;
913: p_return_status := FND_API.G_RET_STS_ERROR;
914: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
915: p_data => p_msg_data );
916: --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

913: p_return_status := FND_API.G_RET_STS_ERROR;
914: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
915: p_data => p_msg_data );
916: --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: --
919: ROLLBACK TO Validate_Account_Overlap_Pvt ;
920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

916: --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: --
919: ROLLBACK TO Validate_Account_Overlap_Pvt ;
920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
922: p_data => p_msg_data );
923: --
924: --

Line 928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

924: --
925: WHEN OTHERS THEN
926: --
927: ROLLBACK TO Validate_Account_Overlap_Pvt ;
928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: --
930: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
931: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
932: l_api_name);

Line 973: p_init_msg_list => FND_API.G_TRUE,

969: --
970: PSB_GL_Budget_Set_Pvt.Validate_Account_Overlap
971: (
972: p_api_version => 1.0 ,
973: p_init_msg_list => FND_API.G_TRUE,
974: p_commit => FND_API.G_FALSE,
975: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
976: p_return_status => l_return_status,
977: p_msg_count => l_msg_count,

Line 974: p_commit => FND_API.G_FALSE,

970: PSB_GL_Budget_Set_Pvt.Validate_Account_Overlap
971: (
972: p_api_version => 1.0 ,
973: p_init_msg_list => FND_API.G_TRUE,
974: p_commit => FND_API.G_FALSE,
975: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
976: p_return_status => l_return_status,
977: p_msg_count => l_msg_count,
978: p_msg_data => l_msg_data,

Line 975: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

971: (
972: p_api_version => 1.0 ,
973: p_init_msg_list => FND_API.G_TRUE,
974: p_commit => FND_API.G_FALSE,
975: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
976: p_return_status => l_return_status,
977: p_msg_count => l_msg_count,
978: p_msg_data => l_msg_data,
979: --

Line 984: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

980: p_gl_budget_set_id => p_gl_budget_set_id,
981: p_validation_status => l_validation_status
982: );
983: --
984: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
985: RAISE FND_API.G_EXC_ERROR;
986: END IF;
987: --
988:

Line 985: RAISE FND_API.G_EXC_ERROR;

981: p_validation_status => l_validation_status
982: );
983: --
984: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
985: RAISE FND_API.G_EXC_ERROR;
986: END IF;
987: --
988:
989: --

Line 993: IF l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN

989: --
990: -- Check whether the API performed the overlap successfully or not. If not
991: -- we will fail the concurrent program so that the user can fix it.
992: --
993: IF l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN
994:
995: -- Print error on the OUTPUT file.
996: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.OUTPUT ,
997: p_print_header => FND_API.G_TRUE ) ;

Line 997: p_print_header => FND_API.G_TRUE ) ;

993: IF l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN
994:
995: -- Print error on the OUTPUT file.
996: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.OUTPUT ,
997: p_print_header => FND_API.G_TRUE ) ;
998: --
999: retcode := 2 ;
1000: --
1001: ELSE

Line 1011: WHEN FND_API.G_EXC_ERROR THEN

1007: COMMIT WORK;
1008: --
1009: EXCEPTION
1010: --
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: --
1013: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1014: p_print_header => FND_API.G_TRUE ) ;
1015: retcode := 2 ;

Line 1014: p_print_header => FND_API.G_TRUE ) ;

1010: --
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: --
1013: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1014: p_print_header => FND_API.G_TRUE ) ;
1015: retcode := 2 ;
1016: --
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: --

Line 1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1013: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1014: p_print_header => FND_API.G_TRUE ) ;
1015: retcode := 2 ;
1016: --
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: --
1019: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1020: p_print_header => FND_API.G_TRUE ) ;
1021: retcode := 2 ;

Line 1020: p_print_header => FND_API.G_TRUE ) ;

1016: --
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: --
1019: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1020: p_print_header => FND_API.G_TRUE ) ;
1021: retcode := 2 ;
1022: --
1023: WHEN OTHERS THEN
1024: --

Line 1032: p_print_header => FND_API.G_TRUE ) ;

1028: l_api_name ) ;
1029: END IF ;
1030: --
1031: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1032: p_print_header => FND_API.G_TRUE ) ;
1033: retcode := 2 ;
1034: --
1035: END Validate_Account_Overlap_CP ;
1036: /*---------------------------------------------------------------------------*/

Line 1074: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1070: BEGIN
1071:
1072: SAVEPOINT Check_References_Pvt ;
1073: --
1074: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1075: p_api_version,
1076: l_api_name,
1077: G_PKG_NAME )
1078: THEN

Line 1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1075: p_api_version,
1076: l_api_name,
1077: G_PKG_NAME )
1078: THEN
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1080: END IF;
1081: --
1082:
1083: IF ( p_init_msg_list='T') THEN

Line 1087: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1083: IF ( p_init_msg_list='T') THEN
1084: FND_MSG_PUB.initialize ;
1085: END IF;
1086: --
1087: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1088: --
1089:
1090: -- Start Checking References
1091:

Line 1113: WHEN FND_API.G_EXC_ERROR THEN

1109: p_return_status:=l_return_status;
1110: --
1111: EXCEPTION
1112: --
1113: WHEN FND_API.G_EXC_ERROR THEN
1114: --
1115: ROLLBACK TO Check_References_Pvt ;
1116: p_return_status := FND_API.G_RET_STS_ERROR;
1117: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1116: p_return_status := FND_API.G_RET_STS_ERROR;

1112: --
1113: WHEN FND_API.G_EXC_ERROR THEN
1114: --
1115: ROLLBACK TO Check_References_Pvt ;
1116: p_return_status := FND_API.G_RET_STS_ERROR;
1117: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1118: p_data => p_msg_data );
1119: --
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1116: p_return_status := FND_API.G_RET_STS_ERROR;
1117: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1118: p_data => p_msg_data );
1119: --
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: --
1122: ROLLBACK TO Check_References_Pvt ;
1123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1119: --
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: --
1122: ROLLBACK TO Check_References_Pvt ;
1123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1125: p_data => p_msg_data );
1126: --
1127: --

Line 1131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1127: --
1128: WHEN OTHERS THEN
1129: --
1130: ROLLBACK TO Check_References_Pvt ;
1131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1132: --
1133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1134: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1135: l_api_name);