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

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

15:
16: PROCEDURE Copy_Attributes
17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_return_status OUT NOCOPY VARCHAR2,
23: p_msg_count OUT NOCOPY NUMBER,

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

16: PROCEDURE Copy_Attributes
17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_return_status OUT NOCOPY VARCHAR2,
23: p_msg_count OUT NOCOPY NUMBER,
24: p_msg_data OUT NOCOPY VARCHAR2,

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

17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_return_status OUT NOCOPY VARCHAR2,
23: p_msg_count OUT NOCOPY NUMBER,
24: p_msg_data OUT NOCOPY VARCHAR2,
25: p_source_entity_set_id IN NUMBER,

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

31: /* ------------------ End of Private Procedures ----------------------*/
32:
33: procedure INSERT_ROW (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_return_status OUT NOCOPY VARCHAR2,
39: p_msg_count OUT NOCOPY NUMBER,

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

32:
33: procedure INSERT_ROW (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_return_status OUT NOCOPY VARCHAR2,
39: p_msg_count OUT NOCOPY NUMBER,
40: p_msg_data OUT NOCOPY VARCHAR2,

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

33: procedure INSERT_ROW (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_return_status OUT NOCOPY VARCHAR2,
39: p_msg_count OUT NOCOPY NUMBER,
40: p_msg_data OUT NOCOPY VARCHAR2,
41: --

Line 84: IF NOT FND_API.Compatible_API_Call ( l_api_version,

80: BEGIN
81: --
82: SAVEPOINT Insert_Row_Pvt ;
83: --
84: IF NOT FND_API.Compatible_API_Call ( l_api_version,
85: p_api_version,
86: l_api_name,
87: G_PKG_NAME )
88: THEN

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

85: p_api_version,
86: l_api_name,
87: G_PKG_NAME )
88: THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
90: END IF;
91: --
92:
93: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 93: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
90: END IF;
91: --
92:
93: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
94: FND_MSG_PUB.initialize ;
95: END IF;
96: --
97: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 97: p_return_status := FND_API.G_RET_STS_SUCCESS ;

93: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
94: FND_MSG_PUB.initialize ;
95: END IF;
96: --
97: p_return_status := FND_API.G_RET_STS_SUCCESS ;
98: --
99: insert into PSB_ENTITY_SET (
100: ENTITY_SET_ID,
101: ENTITY_TYPE,

Line 172: IF FND_API.To_Boolean ( p_commit ) THEN

168: close c;
169: --
170:
171: --
172: IF FND_API.To_Boolean ( p_commit ) THEN
173: COMMIT WORK;
174: END iF;
175: --
176: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 181: WHEN FND_API.G_EXC_ERROR THEN

177: p_data => p_msg_data );
178: --
179: EXCEPTION
180: --
181: WHEN FND_API.G_EXC_ERROR THEN
182: --
183: ROLLBACK TO Insert_Row_Pvt ;
184: p_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 184: p_return_status := FND_API.G_RET_STS_ERROR;

180: --
181: WHEN FND_API.G_EXC_ERROR THEN
182: --
183: ROLLBACK TO Insert_Row_Pvt ;
184: p_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
186: p_data => p_msg_data );
187: --
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

184: p_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
186: p_data => p_msg_data );
187: --
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: --
190: ROLLBACK TO Insert_Row_Pvt ;
191: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 191: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: --
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: --
190: ROLLBACK TO Insert_Row_Pvt ;
191: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
193: p_data => p_msg_data );
194: --
195: WHEN OTHERS THEN

Line 198: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

194: --
195: WHEN OTHERS THEN
196: --
197: ROLLBACK TO Insert_Row_Pvt ;
198: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: --
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
201: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
202: l_api_name);

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

208: END Insert_Row;
209:
210: procedure LOCK_ROW (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_msg_count OUT NOCOPY NUMBER,

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

209:
210: procedure LOCK_ROW (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_msg_count OUT NOCOPY NUMBER,
217: p_msg_data OUT NOCOPY VARCHAR2,

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

210: procedure LOCK_ROW (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_msg_count OUT NOCOPY NUMBER,
217: p_msg_data OUT NOCOPY VARCHAR2,
218: p_lock_row OUT NOCOPY VARCHAR2,

Line 284: IF NOT FND_API.Compatible_API_Call ( l_api_version,

280: BEGIN
281: --
282: SAVEPOINT Lock_Row_Pvt ;
283: --
284: IF NOT FND_API.Compatible_API_Call ( l_api_version,
285: p_api_version,
286: l_api_name,
287: G_PKG_NAME )
288: THEN

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

285: p_api_version,
286: l_api_name,
287: G_PKG_NAME )
288: THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
290: END IF;
291: --
292:
293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
290: END IF;
291: --
292:
293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
294: FND_MSG_PUB.initialize ;
295: END IF;
296: --
297: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 297: p_return_status := FND_API.G_RET_STS_SUCCESS ;

293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
294: FND_MSG_PUB.initialize ;
295: END IF;
296: --
297: p_return_status := FND_API.G_RET_STS_SUCCESS ;
298: --
299: open c1;
300: fetch c1 into tlinfo;
301: if (c1%notfound) then

Line 371: p_lock_row := FND_API.G_TRUE;

367: AND ((tlinfo.CONTEXT = P_CONTEXT)
368: OR ((tlinfo.CONTEXT is null)
369: AND (P_CONTEXT is null)))
370: ) then
371: p_lock_row := FND_API.G_TRUE;
372: ELSE
373: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
374: FND_MSG_PUB.Add;
375: RAISE FND_API.G_EXC_ERROR ;

Line 375: RAISE FND_API.G_EXC_ERROR ;

371: p_lock_row := FND_API.G_TRUE;
372: ELSE
373: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
374: FND_MSG_PUB.Add;
375: RAISE FND_API.G_EXC_ERROR ;
376: END IF;
377:
378: --
379: IF FND_API.To_Boolean ( p_commit ) THEN

Line 379: IF FND_API.To_Boolean ( p_commit ) THEN

375: RAISE FND_API.G_EXC_ERROR ;
376: END IF;
377:
378: --
379: IF FND_API.To_Boolean ( p_commit ) THEN
380: COMMIT WORK;
381: END iF;
382: --
383: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 391: p_lock_row := FND_API.G_FALSE;

387: --
388: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
389: --
390: ROLLBACK TO Lock_Row_Pvt ;
391: p_lock_row := FND_API.G_FALSE;
392: p_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
394: p_data => p_msg_data );
395: --

Line 392: p_return_status := FND_API.G_RET_STS_ERROR;

388: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
389: --
390: ROLLBACK TO Lock_Row_Pvt ;
391: p_lock_row := FND_API.G_FALSE;
392: p_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
394: p_data => p_msg_data );
395: --
396: WHEN FND_API.G_EXC_ERROR THEN

Line 396: WHEN FND_API.G_EXC_ERROR THEN

392: p_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
394: p_data => p_msg_data );
395: --
396: WHEN FND_API.G_EXC_ERROR THEN
397: --
398: ROLLBACK TO Lock_Row_Pvt ;
399: p_lock_row := FND_API.G_FALSE;
400: p_return_status := FND_API.G_RET_STS_ERROR;

Line 399: p_lock_row := FND_API.G_FALSE;

395: --
396: WHEN FND_API.G_EXC_ERROR THEN
397: --
398: ROLLBACK TO Lock_Row_Pvt ;
399: p_lock_row := FND_API.G_FALSE;
400: p_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
402: p_data => p_msg_data );
403: --

Line 400: p_return_status := FND_API.G_RET_STS_ERROR;

396: WHEN FND_API.G_EXC_ERROR THEN
397: --
398: ROLLBACK TO Lock_Row_Pvt ;
399: p_lock_row := FND_API.G_FALSE;
400: p_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
402: p_data => p_msg_data );
403: --
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

400: p_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
402: p_data => p_msg_data );
403: --
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: --
406: ROLLBACK TO Lock_Row_Pvt ;
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

403: --
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: --
406: ROLLBACK TO Lock_Row_Pvt ;
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
409: p_data => p_msg_data );
410: --
411: WHEN OTHERS THEN

Line 414: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

410: --
411: WHEN OTHERS THEN
412: --
413: ROLLBACK TO Lock_Row_Pvt ;
414: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: --
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
417: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
418: l_api_name);

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

424: END Lock_Row;
425:
426: procedure UPDATE_ROW (
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
429: p_commit IN VARCHAR2 := FND_API.G_FALSE,
430: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
431: p_return_status OUT NOCOPY VARCHAR2,
432: p_msg_count OUT NOCOPY NUMBER,

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

425:
426: procedure UPDATE_ROW (
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
429: p_commit IN VARCHAR2 := FND_API.G_FALSE,
430: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
431: p_return_status OUT NOCOPY VARCHAR2,
432: p_msg_count OUT NOCOPY NUMBER,
433: p_msg_data OUT NOCOPY VARCHAR2,

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

426: procedure UPDATE_ROW (
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
429: p_commit IN VARCHAR2 := FND_API.G_FALSE,
430: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
431: p_return_status OUT NOCOPY VARCHAR2,
432: p_msg_count OUT NOCOPY NUMBER,
433: p_msg_data OUT NOCOPY VARCHAR2,
434: --

Line 472: IF NOT FND_API.Compatible_API_Call ( l_api_version,

468: BEGIN
469: --
470: SAVEPOINT Update_Row_Pvt ;
471: --
472: IF NOT FND_API.Compatible_API_Call ( l_api_version,
473: p_api_version,
474: l_api_name,
475: G_PKG_NAME )
476: THEN

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

473: p_api_version,
474: l_api_name,
475: G_PKG_NAME )
476: THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
478: END IF;
479: --
480:
481: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 481: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
478: END IF;
479: --
480:
481: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
482: FND_MSG_PUB.initialize ;
483: END IF;
484: --
485: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 485: p_return_status := FND_API.G_RET_STS_SUCCESS ;

481: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
482: FND_MSG_PUB.initialize ;
483: END IF;
484: --
485: p_return_status := FND_API.G_RET_STS_SUCCESS ;
486: --
487: update PSB_ENTITY_SET set
488: ENTITY_TYPE = P_ENTITY_TYPE,
489: NAME = P_NAME,

Line 523: IF FND_API.To_Boolean ( p_commit ) THEN

519: RAISE NO_DATA_FOUND ;
520: END IF;
521:
522: --
523: IF FND_API.To_Boolean ( p_commit ) THEN
524: COMMIT WORK;
525: END iF;
526: --
527: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528: p_data => p_msg_data );
529: --
530: EXCEPTION
531: --
532: WHEN FND_API.G_EXC_ERROR THEN
533: --
534: ROLLBACK TO Update_Row_Pvt ;
535: p_return_status := FND_API.G_RET_STS_ERROR;
536: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 535: p_return_status := FND_API.G_RET_STS_ERROR;

531: --
532: WHEN FND_API.G_EXC_ERROR THEN
533: --
534: ROLLBACK TO Update_Row_Pvt ;
535: p_return_status := FND_API.G_RET_STS_ERROR;
536: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
537: p_data => p_msg_data );
538: --
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

535: p_return_status := FND_API.G_RET_STS_ERROR;
536: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
537: p_data => p_msg_data );
538: --
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: --
541: ROLLBACK TO Update_Row_Pvt ;
542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: --
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: --
541: ROLLBACK TO Update_Row_Pvt ;
542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
544: p_data => p_msg_data );
545: --
546: WHEN OTHERS THEN

Line 549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: --
546: WHEN OTHERS THEN
547: --
548: ROLLBACK TO Update_Row_Pvt ;
549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: --
551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
553: l_api_name);

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

559: END Update_Row;
560:
561: procedure DELETE_ROW (
562: p_api_version IN NUMBER,
563: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
564: p_commit IN VARCHAR2 := FND_API.G_FALSE,
565: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
566: p_return_status OUT NOCOPY VARCHAR2,
567: p_msg_count OUT NOCOPY NUMBER,

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

560:
561: procedure DELETE_ROW (
562: p_api_version IN NUMBER,
563: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
564: p_commit IN VARCHAR2 := FND_API.G_FALSE,
565: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
566: p_return_status OUT NOCOPY VARCHAR2,
567: p_msg_count OUT NOCOPY NUMBER,
568: p_msg_data OUT NOCOPY VARCHAR2,

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

561: procedure DELETE_ROW (
562: p_api_version IN NUMBER,
563: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
564: p_commit IN VARCHAR2 := FND_API.G_FALSE,
565: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
566: p_return_status OUT NOCOPY VARCHAR2,
567: p_msg_count OUT NOCOPY NUMBER,
568: p_msg_data OUT NOCOPY VARCHAR2,
569: --

Line 580: IF NOT FND_API.Compatible_API_Call ( l_api_version,

576: BEGIN
577: --
578: SAVEPOINT Delete_Row_Pvt ;
579: --
580: IF NOT FND_API.Compatible_API_Call ( l_api_version,
581: p_api_version,
582: l_api_name,
583: G_PKG_NAME )
584: THEN

Line 585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

581: p_api_version,
582: l_api_name,
583: G_PKG_NAME )
584: THEN
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
586: END IF;
587: --
588:
589: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 589: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
586: END IF;
587: --
588:
589: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
590: FND_MSG_PUB.initialize ;
591: END IF;
592: --
593: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 593: p_return_status := FND_API.G_RET_STS_SUCCESS ;

589: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
590: FND_MSG_PUB.initialize ;
591: END IF;
592: --
593: p_return_status := FND_API.G_RET_STS_SUCCESS ;
594: --
595: delete from PSB_ENTITY_SET
596: where ENTITY_SET_ID = P_ENTITY_SET_ID;
597:

Line 603: IF FND_API.To_Boolean ( p_commit ) THEN

599: RAISE NO_DATA_FOUND ;
600: END IF;
601:
602: --
603: IF FND_API.To_Boolean ( p_commit ) THEN
604: COMMIT WORK;
605: END iF;
606: --
607: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 612: WHEN FND_API.G_EXC_ERROR THEN

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

Line 615: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

615: p_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
617: p_data => p_msg_data );
618: --
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: --
621: ROLLBACK TO Delete_Row_Pvt ;
622: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 622: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

618: --
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: --
621: ROLLBACK TO Delete_Row_Pvt ;
622: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
624: p_data => p_msg_data );
625: --
626: WHEN OTHERS THEN

Line 629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

625: --
626: WHEN OTHERS THEN
627: --
628: ROLLBACK TO Delete_Row_Pvt ;
629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: --
631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
632: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
633: l_api_name);

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

639: END Delete_Row;
640:
641: PROCEDURE Copy_Entity_Set
642: ( p_api_version IN NUMBER,
643: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
644: p_commit IN VARCHAR2 := FND_API.G_FALSE,
645: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
646: p_return_status OUT NOCOPY VARCHAR2,
647: p_msg_count OUT NOCOPY NUMBER,

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

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

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

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

Line 789: IF NOT FND_API.Compatible_API_Call ( l_api_version,

785:
786: -- Standard call to check for call compatibility.
787:
788: --
789: IF NOT FND_API.Compatible_API_Call ( l_api_version,
790: p_api_version,
791: l_api_name,
792: G_PKG_NAME )
793: THEN

Line 794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

790: p_api_version,
791: l_api_name,
792: G_PKG_NAME )
793: THEN
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
795: END IF;
796: --
797:
798: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 800: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

796: --
797:
798: -- Initialize message list if p_init_msg_list is set to TRUE.
799:
800: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
801: FND_MSG_PUB.initialize ;
802: END IF;
803:
804: -- Initialize API return status to success

Line 806: p_return_status := FND_API.G_RET_STS_SUCCESS;

802: END IF;
803:
804: -- Initialize API return status to success
805:
806: p_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: -- API body
809: l_last_update_date := SYSDATE;
810: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 815: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

811: l_last_update_login := FND_GLOBAL.LOGIN_ID;
812: l_creation_date := SYSDATE;
813: l_created_by := FND_GLOBAL.USER_ID;
814:
815: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:
819: -- Validate the input parameters.

Line 816: RAISE FND_API.G_EXC_ERROR;

812: l_creation_date := SYSDATE;
813: l_created_by := FND_GLOBAL.USER_ID;
814:
815: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:
819: -- Validate the input parameters.
820: OPEN l_source_data_extract_csr ;

Line 829: RAISE FND_API.G_EXC_ERROR ;

825:
826: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_DATA_EXTRACT') ;
827: Fnd_Message.Set_Token('DATA_EXTRACT_ID', l_source_data_extract_id ) ;
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR ;
830:
831: ELSE
832:
833: SELECT business_group_id INTO l_business_group_id

Line 859: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

855: p_target_data_extract_id => p_target_data_extract_id,
856: p_entity_type => p_entity_type
857: );
858:
859: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
860: debug( 'Copy Attributes Process Failed');
861:
862: RAISE FND_API.G_EXC_ERROR ;
863:

Line 862: RAISE FND_API.G_EXC_ERROR ;

858:
859: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
860: debug( 'Copy Attributes Process Failed');
861:
862: RAISE FND_API.G_EXC_ERROR ;
863:
864: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
865: debug( 'Copy Attributes Process Failed');
866:

Line 864: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

860: debug( 'Copy Attributes Process Failed');
861:
862: RAISE FND_API.G_EXC_ERROR ;
863:
864: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
865: debug( 'Copy Attributes Process Failed');
866:
867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
868:

Line 867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

863:
864: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
865: debug( 'Copy Attributes Process Failed');
866:
867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
868:
869: END IF;
870:
871: -- Code to copy all the desired position sets onto the target data extract

Line 977: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

973: p_created_by => l_created_by,
974: p_creation_date => l_creation_date
975: );
976:
977: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
978: debug( 'Entity not Copied for Entity id : ' ||
979: l_entity_rec.entity_id);
980: RAISE FND_API.G_EXC_ERROR ;
981: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 980: RAISE FND_API.G_EXC_ERROR ;

976:
977: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
978: debug( 'Entity not Copied for Entity id : ' ||
979: l_entity_rec.entity_id);
980: RAISE FND_API.G_EXC_ERROR ;
981: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
982: debug( 'Entity not Copied for Entity id:' ||
983: l_entity_rec.entity_id);
984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 981: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

977: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
978: debug( 'Entity not Copied for Entity id : ' ||
979: l_entity_rec.entity_id);
980: RAISE FND_API.G_EXC_ERROR ;
981: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
982: debug( 'Entity not Copied for Entity id:' ||
983: l_entity_rec.entity_id);
984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
985: END IF;

Line 984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

980: RAISE FND_API.G_EXC_ERROR ;
981: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
982: debug( 'Entity not Copied for Entity id:' ||
983: l_entity_rec.entity_id);
984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
985: END IF;
986:
987:
988: -- creating assignment between the copied parameter set and the

Line 1014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1010: p_created_by => l_created_by,
1011: p_creation_date => l_creation_date
1012: );
1013:
1014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1015: debug( 'Assignment not created for Source and New
1016: Entity Id:'||l_entity_rec.entity_id||','||l_entity_id);
1017:
1018: RAISE FND_API.G_EXC_ERROR ;

Line 1018: RAISE FND_API.G_EXC_ERROR ;

1014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1015: debug( 'Assignment not created for Source and New
1016: Entity Id:'||l_entity_rec.entity_id||','||l_entity_id);
1017:
1018: RAISE FND_API.G_EXC_ERROR ;
1019:
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: debug( 'Assignment not created for Source and New
1022: Entity Id:'||l_entity_rec.entity_id||','||l_entity_id);

Line 1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1016: Entity Id:'||l_entity_rec.entity_id||','||l_entity_id);
1017:
1018: RAISE FND_API.G_EXC_ERROR ;
1019:
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: debug( 'Assignment not created for Source and New
1022: Entity Id:'||l_entity_rec.entity_id||','||l_entity_id);
1023:
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: debug( 'Assignment not created for Source and New
1022: Entity Id:'||l_entity_rec.entity_id||','||l_entity_id);
1023:
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1025:
1026: END IF;
1027:
1028: -- Code to copy sets associated with the parameter.

Line 1084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1080: );
1081:
1082: debug( 'New Position Set Id : ' || l_account_position_set_id);
1083:
1084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1085: debug( 'Position Set not Copied for Source'||
1086: l_sets_rec.account_position_set_id);
1087:
1088: RAISE FND_API.G_EXC_ERROR ;

Line 1088: RAISE FND_API.G_EXC_ERROR ;

1084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1085: debug( 'Position Set not Copied for Source'||
1086: l_sets_rec.account_position_set_id);
1087:
1088: RAISE FND_API.G_EXC_ERROR ;
1089:
1090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: debug( 'Position Set not Copied for Source'||
1092: l_sets_rec.account_position_set_id);

Line 1090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1086: l_sets_rec.account_position_set_id);
1087:
1088: RAISE FND_API.G_EXC_ERROR ;
1089:
1090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: debug( 'Position Set not Copied for Source'||
1092: l_sets_rec.account_position_set_id);
1093:
1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: debug( 'Position Set not Copied for Source'||
1092: l_sets_rec.account_position_set_id);
1093:
1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1095:
1096: END IF;
1097:
1098: END IF; -- End checking whether to create a new position set or not.

Line 1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1153: p_created_by => l_created_by,
1154: p_creation_date => l_creation_date
1155: );
1156:
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158: debug( 'Set Relation not created for:'||l_sets_rec.set_relation_id);
1159: RAISE FND_API.G_EXC_ERROR ;
1160: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1161: debug( 'Set Relation not created for:'||l_sets_rec.set_relation_id);

Line 1159: RAISE FND_API.G_EXC_ERROR ;

1155: );
1156:
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158: debug( 'Set Relation not created for:'||l_sets_rec.set_relation_id);
1159: RAISE FND_API.G_EXC_ERROR ;
1160: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1161: debug( 'Set Relation not created for:'||l_sets_rec.set_relation_id);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1163: END IF;

Line 1160: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1156:
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158: debug( 'Set Relation not created for:'||l_sets_rec.set_relation_id);
1159: RAISE FND_API.G_EXC_ERROR ;
1160: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1161: debug( 'Set Relation not created for:'||l_sets_rec.set_relation_id);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1163: END IF;
1164:

Line 1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1158: debug( 'Set Relation not created for:'||l_sets_rec.set_relation_id);
1159: RAISE FND_API.G_EXC_ERROR ;
1160: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1161: debug( 'Set Relation not created for:'||l_sets_rec.set_relation_id);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1163: END IF;
1164:
1165: END IF;
1166:

Line 1261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1257: p_source_data_extract_id => l_source_data_extract_rec.data_extract_id,
1258: p_target_data_extract_id => p_target_data_extract_id
1259: );
1260:
1261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1262: debug( 'Copy Entity Element Process Failed');
1263: RAISE FND_API.G_EXC_ERROR ;
1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: debug( 'Copy Entity Element Process Failed');

Line 1263: RAISE FND_API.G_EXC_ERROR ;

1259: );
1260:
1261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1262: debug( 'Copy Entity Element Process Failed');
1263: RAISE FND_API.G_EXC_ERROR ;
1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: debug( 'Copy Entity Element Process Failed');
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1267: END IF;

Line 1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1260:
1261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1262: debug( 'Copy Entity Element Process Failed');
1263: RAISE FND_API.G_EXC_ERROR ;
1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: debug( 'Copy Entity Element Process Failed');
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1267: END IF;
1268:

Line 1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1262: debug( 'Copy Entity Element Process Failed');
1263: RAISE FND_API.G_EXC_ERROR ;
1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: debug( 'Copy Entity Element Process Failed');
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1267: END IF;
1268:
1269: END IF;
1270:

Line 1439: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1435: p_created_by => l_created_by,
1436: p_creation_date => l_creation_date
1437: );
1438:
1439: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1440: debug( 'Formula not created for:' ||
1441: l_para_formula_rec.parameter_formula_id);
1442: RAISE FND_API.G_EXC_ERROR ;
1443: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1442: RAISE FND_API.G_EXC_ERROR ;

1438:
1439: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1440: debug( 'Formula not created for:' ||
1441: l_para_formula_rec.parameter_formula_id);
1442: RAISE FND_API.G_EXC_ERROR ;
1443: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1444: debug( 'Formula not created for:' ||
1445: l_para_formula_rec.parameter_formula_id);
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1443: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1439: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1440: debug( 'Formula not created for:' ||
1441: l_para_formula_rec.parameter_formula_id);
1442: RAISE FND_API.G_EXC_ERROR ;
1443: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1444: debug( 'Formula not created for:' ||
1445: l_para_formula_rec.parameter_formula_id);
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1447: END IF;

Line 1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1442: RAISE FND_API.G_EXC_ERROR ;
1443: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1444: debug( 'Formula not created for:' ||
1445: l_para_formula_rec.parameter_formula_id);
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1447: END IF;
1448:
1449: END IF; -- Checking position sub type while processing
1450: -- a formula within a parameter.

Line 1510: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1506: p_source_data_extract_id => l_source_data_extract_rec.data_extract_id,
1507: p_target_data_extract_id => p_target_data_extract_id
1508: );
1509:
1510: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: debug( 'Copy Entity Element Process Failed');
1512: RAISE FND_API.G_EXC_ERROR ;
1513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: debug( 'Copy Entity Element Process Failed');

Line 1512: RAISE FND_API.G_EXC_ERROR ;

1508: );
1509:
1510: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: debug( 'Copy Entity Element Process Failed');
1512: RAISE FND_API.G_EXC_ERROR ;
1513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: debug( 'Copy Entity Element Process Failed');
1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1516: END IF;

Line 1513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1509:
1510: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: debug( 'Copy Entity Element Process Failed');
1512: RAISE FND_API.G_EXC_ERROR ;
1513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: debug( 'Copy Entity Element Process Failed');
1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1516: END IF;
1517:

Line 1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1511: debug( 'Copy Entity Element Process Failed');
1512: RAISE FND_API.G_EXC_ERROR ;
1513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: debug( 'Copy Entity Element Process Failed');
1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1516: END IF;
1517:
1518: END IF;
1519:

Line 1673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1669: p_created_by => l_created_by,
1670: p_creation_date => l_creation_date
1671: );
1672:
1673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1674: debug( 'Constraint not created for:' ||
1675: l_const_formula_rec.constraint_formula_id);
1676: RAISE FND_API.G_EXC_ERROR ;
1677: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1676: RAISE FND_API.G_EXC_ERROR ;

1672:
1673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1674: debug( 'Constraint not created for:' ||
1675: l_const_formula_rec.constraint_formula_id);
1676: RAISE FND_API.G_EXC_ERROR ;
1677: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1678: debug( 'Constraint not created for:' ||
1679: l_const_formula_rec.constraint_formula_id);
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1677: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1674: debug( 'Constraint not created for:' ||
1675: l_const_formula_rec.constraint_formula_id);
1676: RAISE FND_API.G_EXC_ERROR ;
1677: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1678: debug( 'Constraint not created for:' ||
1679: l_const_formula_rec.constraint_formula_id);
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1681: END IF;

Line 1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1676: RAISE FND_API.G_EXC_ERROR ;
1677: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1678: debug( 'Constraint not created for:' ||
1679: l_const_formula_rec.constraint_formula_id);
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1681: END IF;
1682:
1683: END IF; -- Checking account or position sub type while processing
1684: -- a constraint within a parameter.

Line 1694: IF FND_API.to_Boolean (p_commit) THEN

1690: END LOOP; -- Processing parameters.
1691:
1692:
1693: -- Standard check of p_commit.
1694: IF FND_API.to_Boolean (p_commit) THEN
1695: COMMIT WORK;
1696: END IF;
1697:
1698: -- Standard call to get message count and if count is 1, get message info.

Line 1705: WHEN FND_API.G_EXC_ERROR THEN

1701: p_data => p_msg_data);
1702:
1703: EXCEPTION
1704:
1705: WHEN FND_API.G_EXC_ERROR THEN
1706:
1707: ROLLBACK TO Copy_Parameter_Set_Pvt;
1708:
1709: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1709: p_return_status := FND_API.G_RET_STS_ERROR;

1705: WHEN FND_API.G_EXC_ERROR THEN
1706:
1707: ROLLBACK TO Copy_Parameter_Set_Pvt;
1708:
1709: p_return_status := FND_API.G_RET_STS_ERROR;
1710:
1711: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1712: p_data => p_msg_data);
1713:

Line 1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1711: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1712: p_data => p_msg_data);
1713:
1714:
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716:
1717: ROLLBACK TO Copy_Parameter_Set_Pvt;
1718:
1719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716:
1717: ROLLBACK TO Copy_Parameter_Set_Pvt;
1718:
1719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720:
1721: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1722: p_data => p_msg_data);
1723:

Line 1728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1724: WHEN OTHERS THEN
1725:
1726: ROLLBACK TO Copy_Parameter_Set_Pvt;
1727:
1728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1729:
1730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1731:
1732: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

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

1746: -- and formulas for parameters and constraints
1747:
1748: PROCEDURE Copy_Attributes
1749: ( p_api_version IN NUMBER,
1750: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1751: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1752: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1753: p_return_status OUT NOCOPY VARCHAR2,
1754: p_msg_count OUT NOCOPY NUMBER,

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

1747:
1748: PROCEDURE Copy_Attributes
1749: ( p_api_version IN NUMBER,
1750: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1751: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1752: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1753: p_return_status OUT NOCOPY VARCHAR2,
1754: p_msg_count OUT NOCOPY NUMBER,
1755: p_msg_data OUT NOCOPY VARCHAR2,

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

1748: PROCEDURE Copy_Attributes
1749: ( p_api_version IN NUMBER,
1750: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1751: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1752: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1753: p_return_status OUT NOCOPY VARCHAR2,
1754: p_msg_count OUT NOCOPY NUMBER,
1755: p_msg_data OUT NOCOPY VARCHAR2,
1756: p_source_entity_set_id IN NUMBER,

Line 1845: IF not FND_API.Compatible_API_Call (l_api_version,

1841: SAVEPOINT Copy_Attributes_Pvt;
1842:
1843: -- Standard call to check for call compatibility.
1844:
1845: IF not FND_API.Compatible_API_Call (l_api_version,
1846: p_api_version,
1847: l_api_name,
1848: G_PKG_NAME)
1849: THEN

Line 1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1846: p_api_version,
1847: l_api_name,
1848: G_PKG_NAME)
1849: THEN
1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1851: END IF;
1852:
1853: -- Initialize message list if p_init_msg_list is set to TRUE.
1854:

Line 1855: IF FND_API.to_Boolean (p_init_msg_list) THEN

1851: END IF;
1852:
1853: -- Initialize message list if p_init_msg_list is set to TRUE.
1854:
1855: IF FND_API.to_Boolean (p_init_msg_list) THEN
1856: FND_MSG_PUB.initialize;
1857: END IF;
1858:
1859: -- Initialize API return status to success

Line 1861: p_return_status := FND_API.G_RET_STS_SUCCESS;

1857: END IF;
1858:
1859: -- Initialize API return status to success
1860:
1861: p_return_status := FND_API.G_RET_STS_SUCCESS;
1862:
1863: -- API body
1864: l_last_update_date := SYSDATE;
1865: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 1870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1866: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1867: l_creation_date := SYSDATE;
1868: l_created_by := FND_GLOBAL.USER_ID;
1869:
1870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1871: RAISE FND_API.G_EXC_ERROR;
1872: END IF;
1873:
1874: FOR l_attr_value_rec IN l_attr_value_csr

Line 1871: RAISE FND_API.G_EXC_ERROR;

1867: l_creation_date := SYSDATE;
1868: l_created_by := FND_GLOBAL.USER_ID;
1869:
1870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1871: RAISE FND_API.G_EXC_ERROR;
1872: END IF;
1873:
1874: FOR l_attr_value_rec IN l_attr_value_csr
1875: LOOP

Line 1952: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1948: );
1949:
1950: debug( 'Attribute created for attribute value id'||l_attribute_value_id);
1951:
1952: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1953: debug( 'Attribute not created for attribute value id'||
1954: l_attribute_value_rec.attribute_value_id);
1955:
1956: RAISE FND_API.G_EXC_ERROR ;

Line 1956: RAISE FND_API.G_EXC_ERROR ;

1952: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1953: debug( 'Attribute not created for attribute value id'||
1954: l_attribute_value_rec.attribute_value_id);
1955:
1956: RAISE FND_API.G_EXC_ERROR ;
1957:
1958: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1959: debug( 'Attribute not created for attribute value id'||
1960: l_attribute_value_rec.attribute_value_id);

Line 1958: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1954: l_attribute_value_rec.attribute_value_id);
1955:
1956: RAISE FND_API.G_EXC_ERROR ;
1957:
1958: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1959: debug( 'Attribute not created for attribute value id'||
1960: l_attribute_value_rec.attribute_value_id);
1961:
1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1958: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1959: debug( 'Attribute not created for attribute value id'||
1960: l_attribute_value_rec.attribute_value_id);
1961:
1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1963:
1964: END IF;
1965:
1966: END IF;

Line 1975: IF FND_API.to_Boolean (p_commit) THEN

1971: -- End of API body.
1972:
1973: -- Standard check of p_commit.
1974:
1975: IF FND_API.to_Boolean (p_commit) THEN
1976: COMMIT WORK;
1977: END IF;
1978:
1979: -- Standard call to get message count and if count is 1, get message info.

Line 1986: WHEN FND_API.G_EXC_ERROR THEN

1982: p_data => p_msg_data);
1983:
1984: EXCEPTION
1985:
1986: WHEN FND_API.G_EXC_ERROR THEN
1987:
1988: ROLLBACK TO Copy_Attributes_Pvt;
1989:
1990: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1990: p_return_status := FND_API.G_RET_STS_ERROR;

1986: WHEN FND_API.G_EXC_ERROR THEN
1987:
1988: ROLLBACK TO Copy_Attributes_Pvt;
1989:
1990: p_return_status := FND_API.G_RET_STS_ERROR;
1991:
1992: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1993: p_data => p_msg_data);
1994:

Line 1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1992: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1993: p_data => p_msg_data);
1994:
1995:
1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1997:
1998: ROLLBACK TO Copy_Attributes_Pvt;
1999:
2000: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2000: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1997:
1998: ROLLBACK TO Copy_Attributes_Pvt;
1999:
2000: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001:
2002: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2003: p_data => p_msg_data);
2004:

Line 2009: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2005: WHEN OTHERS THEN
2006:
2007: ROLLBACK TO Copy_Attributes_Pvt;
2008:
2009: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010:
2011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2012:
2013: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

Line 2071: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2067: BEGIN
2068:
2069: SAVEPOINT Check_References_Pvt ;
2070: --
2071: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2072: p_api_version,
2073: l_api_name,
2074: G_PKG_NAME )
2075: THEN

Line 2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2072: p_api_version,
2073: l_api_name,
2074: G_PKG_NAME )
2075: THEN
2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2077: END IF;
2078: --
2079:
2080: IF ( FND_API.To_Boolean(p_init_msg_list)) THEN

Line 2080: IF ( FND_API.To_Boolean(p_init_msg_list)) THEN

2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2077: END IF;
2078: --
2079:
2080: IF ( FND_API.To_Boolean(p_init_msg_list)) THEN
2081: FND_MSG_PUB.initialize ;
2082: END IF;
2083:
2084: FOR c_check_references_ws_rec IN c_check_references_ws LOOP

Line 2096: IF ( FND_API.To_Boolean(p_commit)) THEN

2092: END LOOP;
2093:
2094: END IF;
2095:
2096: IF ( FND_API.To_Boolean(p_commit)) THEN
2097: COMMIT WORK;
2098: END IF;
2099: --
2100: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 2104: p_return_status := FND_API.G_RET_STS_SUCCESS;

2100: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2101: p_data => p_msg_data );
2102:
2103: p_return_value := l_return_value;
2104: p_return_status := FND_API.G_RET_STS_SUCCESS;
2105:
2106: EXCEPTION
2107: --
2108: WHEN FND_API.G_EXC_ERROR THEN

Line 2108: WHEN FND_API.G_EXC_ERROR THEN

2104: p_return_status := FND_API.G_RET_STS_SUCCESS;
2105:
2106: EXCEPTION
2107: --
2108: WHEN FND_API.G_EXC_ERROR THEN
2109: --
2110: ROLLBACK TO Check_References_Pvt ;
2111: p_return_status := FND_API.G_RET_STS_ERROR;
2112: p_return_value := l_return_value;

Line 2111: p_return_status := FND_API.G_RET_STS_ERROR;

2107: --
2108: WHEN FND_API.G_EXC_ERROR THEN
2109: --
2110: ROLLBACK TO Check_References_Pvt ;
2111: p_return_status := FND_API.G_RET_STS_ERROR;
2112: p_return_value := l_return_value;
2113: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2114: p_data => p_msg_data );
2115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2111: p_return_status := FND_API.G_RET_STS_ERROR;
2112: p_return_value := l_return_value;
2113: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2114: p_data => p_msg_data );
2115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2116: --
2117: ROLLBACK TO Check_References_Pvt ;
2118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: p_return_value := l_return_value;

Line 2118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2114: p_data => p_msg_data );
2115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2116: --
2117: ROLLBACK TO Check_References_Pvt ;
2118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: p_return_value := l_return_value;
2120: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
2121: p_data => p_msg_data );
2122: WHEN OTHERS THEN

Line 2125: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2121: p_data => p_msg_data );
2122: WHEN OTHERS THEN
2123: --
2124: ROLLBACK TO Check_References_Pvt ;
2125: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126: p_return_value := l_return_value;
2127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2128: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2129: l_api_name);