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

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

5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_ATTRIBUTE_VALUES_PVT';
6:
7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,

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

6:
7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
14: p_msg_data OUT NOCOPY VARCHAR2,

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

7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
14: p_msg_data OUT NOCOPY VARCHAR2,
15: --

Line 72: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 81: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 85: p_return_status := FND_API.G_RET_STS_SUCCESS ;

81: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
82: FND_MSG_PUB.initialize ;
83: END IF;
84: --
85: p_return_status := FND_API.G_RET_STS_SUCCESS ;
86: --
87:
88: insert into PSB_ATTRIBUTE_VALUES (
89: ATTRIBUTE_VALUE_ID ,

Line 185: IF FND_API.To_Boolean ( p_commit ) THEN

181: end if;
182: close c;
183:
184: --
185: IF FND_API.To_Boolean ( p_commit ) THEN
186: COMMIT WORK;
187: END iF;
188: --
189: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 194: WHEN FND_API.G_EXC_ERROR THEN

190: p_data => p_msg_data );
191: --
192: EXCEPTION
193: --
194: WHEN FND_API.G_EXC_ERROR THEN
195: --
196: ROLLBACK TO Insert_Row_Pvt ;
197: p_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 197: p_return_status := FND_API.G_RET_STS_ERROR;

193: --
194: WHEN FND_API.G_EXC_ERROR THEN
195: --
196: ROLLBACK TO Insert_Row_Pvt ;
197: p_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
199: p_data => p_msg_data );
200: --
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

197: p_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
199: p_data => p_msg_data );
200: --
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: --
203: ROLLBACK TO Insert_Row_Pvt ;
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: --
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: --
203: ROLLBACK TO Insert_Row_Pvt ;
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
206: p_data => p_msg_data );
207: --
208: WHEN OTHERS THEN

Line 211: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

207: --
208: WHEN OTHERS THEN
209: --
210: ROLLBACK TO Insert_Row_Pvt ;
211: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: --
213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
214: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
215: l_api_name);

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

221: END INSERT_ROW;
222:
223: procedure LOCK_ROW (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_msg_count OUT NOCOPY NUMBER,

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

222:
223: procedure LOCK_ROW (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_msg_count OUT NOCOPY NUMBER,
230: p_msg_data OUT NOCOPY VARCHAR2,

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

223: procedure LOCK_ROW (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_msg_count OUT NOCOPY NUMBER,
230: p_msg_data OUT NOCOPY VARCHAR2,
231: --

Line 325: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 334: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 338: p_return_status := FND_API.G_RET_STS_SUCCESS ;

334: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
335: FND_MSG_PUB.initialize ;
336: END IF;
337: --
338: p_return_status := FND_API.G_RET_STS_SUCCESS ;
339: --
340: open c1;
341: fetch c1 into tlinfo;
342: if (c1%notfound) then

Line 462: p_lock_row := FND_API.G_TRUE;

458: AND (P_ATTRIBUTE30 is null)))
459:
460:
461: ) then
462: p_lock_row := FND_API.G_TRUE;
463: ELSE
464: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
465: FND_MSG_PUB.Add;
466: RAISE FND_API.G_EXC_ERROR ;

Line 466: RAISE FND_API.G_EXC_ERROR ;

462: p_lock_row := FND_API.G_TRUE;
463: ELSE
464: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
465: FND_MSG_PUB.Add;
466: RAISE FND_API.G_EXC_ERROR ;
467: END IF;
468:
469: --
470: IF FND_API.To_Boolean ( p_commit ) THEN

Line 470: IF FND_API.To_Boolean ( p_commit ) THEN

466: RAISE FND_API.G_EXC_ERROR ;
467: END IF;
468:
469: --
470: IF FND_API.To_Boolean ( p_commit ) THEN
471: COMMIT WORK;
472: END iF;
473: --
474: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 482: p_lock_row := FND_API.G_FALSE;

478: --
479: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
480: --
481: ROLLBACK TO Lock_Row_Pvt ;
482: p_lock_row := FND_API.G_FALSE;
483: p_return_status := FND_API.G_RET_STS_ERROR;
484: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
485: p_data => p_msg_data );
486: --

Line 483: p_return_status := FND_API.G_RET_STS_ERROR;

479: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
480: --
481: ROLLBACK TO Lock_Row_Pvt ;
482: p_lock_row := FND_API.G_FALSE;
483: p_return_status := FND_API.G_RET_STS_ERROR;
484: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
485: p_data => p_msg_data );
486: --
487: WHEN FND_API.G_EXC_ERROR THEN

Line 487: WHEN FND_API.G_EXC_ERROR THEN

483: p_return_status := FND_API.G_RET_STS_ERROR;
484: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
485: p_data => p_msg_data );
486: --
487: WHEN FND_API.G_EXC_ERROR THEN
488: --
489: ROLLBACK TO Lock_Row_Pvt ;
490: p_lock_row := FND_API.G_FALSE;
491: p_return_status := FND_API.G_RET_STS_ERROR;

Line 490: p_lock_row := FND_API.G_FALSE;

486: --
487: WHEN FND_API.G_EXC_ERROR THEN
488: --
489: ROLLBACK TO Lock_Row_Pvt ;
490: p_lock_row := FND_API.G_FALSE;
491: p_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
493: p_data => p_msg_data );
494: --

Line 491: p_return_status := FND_API.G_RET_STS_ERROR;

487: WHEN FND_API.G_EXC_ERROR THEN
488: --
489: ROLLBACK TO Lock_Row_Pvt ;
490: p_lock_row := FND_API.G_FALSE;
491: p_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
493: p_data => p_msg_data );
494: --
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

491: p_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
493: p_data => p_msg_data );
494: --
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: --
497: ROLLBACK TO Lock_Row_Pvt ;
498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

494: --
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: --
497: ROLLBACK TO Lock_Row_Pvt ;
498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
500: p_data => p_msg_data );
501: --
502: WHEN OTHERS THEN

Line 505: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

501: --
502: WHEN OTHERS THEN
503: --
504: ROLLBACK TO Lock_Row_Pvt ;
505: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: --
507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
508: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
509: l_api_name);

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

515: END LOCK_ROW;
516:
517: procedure UPDATE_ROW (
518: p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
520: p_commit IN VARCHAR2 := FND_API.G_FALSE,
521: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: p_return_status OUT NOCOPY VARCHAR2,
523: p_msg_count OUT NOCOPY NUMBER,

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

516:
517: procedure UPDATE_ROW (
518: p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
520: p_commit IN VARCHAR2 := FND_API.G_FALSE,
521: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: p_return_status OUT NOCOPY VARCHAR2,
523: p_msg_count OUT NOCOPY NUMBER,
524: p_msg_data OUT NOCOPY VARCHAR2,

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

517: procedure UPDATE_ROW (
518: p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
520: p_commit IN VARCHAR2 := FND_API.G_FALSE,
521: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: p_return_status OUT NOCOPY VARCHAR2,
523: p_msg_count OUT NOCOPY NUMBER,
524: p_msg_data OUT NOCOPY VARCHAR2,
525: --

Line 575: IF NOT FND_API.Compatible_API_Call ( l_api_version,

571: BEGIN
572: --
573: SAVEPOINT Update_Row_Pvt ;
574: --
575: IF NOT FND_API.Compatible_API_Call ( l_api_version,
576: p_api_version,
577: l_api_name,
578: G_PKG_NAME )
579: THEN

Line 580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

576: p_api_version,
577: l_api_name,
578: G_PKG_NAME )
579: THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
581: END IF;
582: --
583:
584: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 584: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
581: END IF;
582: --
583:
584: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
585: FND_MSG_PUB.initialize ;
586: END IF;
587: --
588: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 588: p_return_status := FND_API.G_RET_STS_SUCCESS ;

584: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
585: FND_MSG_PUB.initialize ;
586: END IF;
587: --
588: p_return_status := FND_API.G_RET_STS_SUCCESS ;
589: --
590: update PSB_ATTRIBUTE_VALUES set
591: ATTRIBUTE_VALUE_ID = P_ATTRIBUTE_VALUE_ID,
592: ATTRIBUTE_ID = P_ATTRIBUTE_ID,

Line 637: IF FND_API.To_Boolean ( p_commit ) THEN

633: if (sql%notfound) then
634: raise no_data_found;
635: end if;
636: --
637: IF FND_API.To_Boolean ( p_commit ) THEN
638: COMMIT WORK;
639: END iF;
640: --
641: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 646: WHEN FND_API.G_EXC_ERROR THEN

642: p_data => p_msg_data );
643: --
644: EXCEPTION
645: --
646: WHEN FND_API.G_EXC_ERROR THEN
647: --
648: ROLLBACK TO Update_Row_Pvt ;
649: p_return_status := FND_API.G_RET_STS_ERROR;
650: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 649: p_return_status := FND_API.G_RET_STS_ERROR;

645: --
646: WHEN FND_API.G_EXC_ERROR THEN
647: --
648: ROLLBACK TO Update_Row_Pvt ;
649: p_return_status := FND_API.G_RET_STS_ERROR;
650: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
651: p_data => p_msg_data );
652: --
653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

649: p_return_status := FND_API.G_RET_STS_ERROR;
650: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
651: p_data => p_msg_data );
652: --
653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
654: --
655: ROLLBACK TO Update_Row_Pvt ;
656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

652: --
653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
654: --
655: ROLLBACK TO Update_Row_Pvt ;
656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
658: p_data => p_msg_data );
659: --
660: WHEN OTHERS THEN

Line 663: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

659: --
660: WHEN OTHERS THEN
661: --
662: ROLLBACK TO Update_Row_Pvt ;
663: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: --
665: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
666: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
667: l_api_name);

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

673: END UPDATE_ROW;
674:
675: procedure DELETE_ROW (
676: p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
678: p_commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: p_return_status OUT NOCOPY VARCHAR2,
681: p_msg_count OUT NOCOPY NUMBER,

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

674:
675: procedure DELETE_ROW (
676: p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
678: p_commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: p_return_status OUT NOCOPY VARCHAR2,
681: p_msg_count OUT NOCOPY NUMBER,
682: p_msg_data OUT NOCOPY VARCHAR2,

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

675: procedure DELETE_ROW (
676: p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
678: p_commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: p_return_status OUT NOCOPY VARCHAR2,
681: p_msg_count OUT NOCOPY NUMBER,
682: p_msg_data OUT NOCOPY VARCHAR2,
683: --

Line 693: IF NOT FND_API.Compatible_API_Call ( l_api_version,

689: BEGIN
690: --
691: SAVEPOINT Delete_Row_Pvt ;
692: --
693: IF NOT FND_API.Compatible_API_Call ( l_api_version,
694: p_api_version,
695: l_api_name,
696: G_PKG_NAME )
697: THEN

Line 698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

694: p_api_version,
695: l_api_name,
696: G_PKG_NAME )
697: THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
699: END IF;
700: --
701:
702: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 702: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
699: END IF;
700: --
701:
702: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
703: FND_MSG_PUB.initialize ;
704: END IF;
705: --
706: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 706: p_return_status := FND_API.G_RET_STS_SUCCESS ;

702: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
703: FND_MSG_PUB.initialize ;
704: END IF;
705: --
706: p_return_status := FND_API.G_RET_STS_SUCCESS ;
707: --
708: delete from PSB_ATTRIBUTE_VALUES
709: where ATTRIBUTE_VALUE_ID = P_ATTRIBUTE_VALUE_ID;
710: if (sql%notfound) then

Line 714: IF FND_API.To_Boolean ( p_commit ) THEN

710: if (sql%notfound) then
711: raise no_data_found;
712: end if;
713: --
714: IF FND_API.To_Boolean ( p_commit ) THEN
715: COMMIT WORK;
716: END iF;
717: --
718: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 723: WHEN FND_API.G_EXC_ERROR THEN

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

Line 726: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

726: p_return_status := FND_API.G_RET_STS_ERROR;
727: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
728: p_data => p_msg_data );
729: --
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: --
732: ROLLBACK TO Delete_Row_Pvt ;
733: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 733: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

729: --
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: --
732: ROLLBACK TO Delete_Row_Pvt ;
733: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
735: p_data => p_msg_data );
736: --
737: WHEN OTHERS THEN

Line 740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

736: --
737: WHEN OTHERS THEN
738: --
739: ROLLBACK TO Delete_Row_Pvt ;
740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: --
742: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
743: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
744: l_api_name);

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

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

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

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

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

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

Line 784: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 793: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 797: p_return_status := FND_API.G_RET_STS_SUCCESS ;

793: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
794: FND_MSG_PUB.initialize ;
795: END IF;
796: --
797: p_return_status := FND_API.G_RET_STS_SUCCESS ;
798: --
799:
800: -- Checking the Psb_set_relations table for references.
801: OPEN c;

Line 813: IF FND_API.To_Boolean ( p_commit ) THEN

809: END IF;
810:
811: CLOSE c;
812: --
813: IF FND_API.To_Boolean ( p_commit ) THEN
814: COMMIT WORK;
815: END iF;
816: --
817: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 822: WHEN FND_API.G_EXC_ERROR THEN

818: p_data => p_msg_data );
819:
820: EXCEPTION
821: --
822: WHEN FND_API.G_EXC_ERROR THEN
823: --
824: ROLLBACK TO Check_References_Pvt ;
825: p_return_status := FND_API.G_RET_STS_ERROR;
826: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 825: p_return_status := FND_API.G_RET_STS_ERROR;

821: --
822: WHEN FND_API.G_EXC_ERROR THEN
823: --
824: ROLLBACK TO Check_References_Pvt ;
825: p_return_status := FND_API.G_RET_STS_ERROR;
826: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
827: p_data => p_msg_data );
828: --
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

825: p_return_status := FND_API.G_RET_STS_ERROR;
826: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
827: p_data => p_msg_data );
828: --
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: --
831: ROLLBACK TO Check_References_Pvt ;
832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

828: --
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: --
831: ROLLBACK TO Check_References_Pvt ;
832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
834: p_data => p_msg_data );
835: --
836: WHEN OTHERS THEN

Line 839: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

835: --
836: WHEN OTHERS THEN
837: --
838: ROLLBACK TO Check_References_Pvt ;
839: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840: --
841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
842: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
843: l_api_name);