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

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

5:
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 101: IF NOT FND_API.Compatible_API_Call ( l_api_version,

97: BEGIN
98:
99: SAVEPOINT Insert_Row_Pvt ;
100:
101: IF NOT FND_API.Compatible_API_Call ( l_api_version,
102: p_api_version,
103: l_api_name,
104: G_PKG_NAME )
105: THEN

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

102: p_api_version,
103: l_api_name,
104: G_PKG_NAME )
105: THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
107: END IF;
108:
109:
110: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 110: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
107: END IF;
108:
109:
110: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
111: FND_MSG_PUB.initialize ;
112: END IF;
113:
114: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 114: p_return_status := FND_API.G_RET_STS_SUCCESS ;

110: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
111: FND_MSG_PUB.initialize ;
112: END IF;
113:
114: p_return_status := FND_API.G_RET_STS_SUCCESS ;
115:
116: insert into PSB_PARAMETER_FORMULAS (
117: PARAMETER_ID,
118: PARAMETER_FORMULA_ID,

Line 275: IF FND_API.To_Boolean ( p_commit ) THEN

271: end if;
272: close c;
273:
274:
275: IF FND_API.To_Boolean ( p_commit ) THEN
276: COMMIT WORK;
277: END iF;
278:
279: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 284: WHEN FND_API.G_EXC_ERROR THEN

280: p_data => p_msg_data );
281:
282: EXCEPTION
283:
284: WHEN FND_API.G_EXC_ERROR THEN
285:
286: ROLLBACK TO Insert_Row_Pvt ;
287: p_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 287: p_return_status := FND_API.G_RET_STS_ERROR;

283:
284: WHEN FND_API.G_EXC_ERROR THEN
285:
286: ROLLBACK TO Insert_Row_Pvt ;
287: p_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
289: p_data => p_msg_data );
290:
291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

287: p_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
289: p_data => p_msg_data );
290:
291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
292:
293: ROLLBACK TO Insert_Row_Pvt ;
294: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 294: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290:
291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
292:
293: ROLLBACK TO Insert_Row_Pvt ;
294: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
296: p_data => p_msg_data );
297:
298: WHEN OTHERS THEN

Line 301: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297:
298: WHEN OTHERS THEN
299:
300: ROLLBACK TO Insert_Row_Pvt ;
301: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302:
303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
304: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
305: l_api_name);

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

311: END Insert_Row;
312:
313: procedure LOCK_ROW (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_return_status OUT NOCOPY VARCHAR2,
319: p_msg_count OUT NOCOPY NUMBER,

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

312:
313: procedure LOCK_ROW (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_return_status OUT NOCOPY VARCHAR2,
319: p_msg_count OUT NOCOPY NUMBER,
320: p_msg_data OUT NOCOPY VARCHAR2,

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

313: procedure LOCK_ROW (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_return_status OUT NOCOPY VARCHAR2,
319: p_msg_count OUT NOCOPY NUMBER,
320: p_msg_data OUT NOCOPY VARCHAR2,
321: p_lock_row OUT NOCOPY VARCHAR2,

Line 410: IF NOT FND_API.Compatible_API_Call ( l_api_version,

406: BEGIN
407:
408: SAVEPOINT Lock_Row_Pvt ;
409:
410: IF NOT FND_API.Compatible_API_Call ( l_api_version,
411: p_api_version,
412: l_api_name,
413: G_PKG_NAME )
414: THEN

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

411: p_api_version,
412: l_api_name,
413: G_PKG_NAME )
414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
416: END IF;
417:
418:
419: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 419: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
416: END IF;
417:
418:
419: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
420: FND_MSG_PUB.initialize ;
421: END IF;
422:
423: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 423: p_return_status := FND_API.G_RET_STS_SUCCESS ;

419: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
420: FND_MSG_PUB.initialize ;
421: END IF;
422:
423: p_return_status := FND_API.G_RET_STS_SUCCESS ;
424: p_lock_row := FND_API.G_TRUE;
425:
426: open c;
427: fetch c into recinfo;

Line 424: p_lock_row := FND_API.G_TRUE;

420: FND_MSG_PUB.initialize ;
421: END IF;
422:
423: p_return_status := FND_API.G_RET_STS_SUCCESS ;
424: p_lock_row := FND_API.G_TRUE;
425:
426: open c;
427: fetch c into recinfo;
428: if (c%notfound) then

Line 432: raise FND_API.G_EXC_ERROR;

428: if (c%notfound) then
429: close c;
430: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
431: FND_MSG_PUB.ADD;
432: raise FND_API.G_EXC_ERROR;
433: end if;
434: close c;
435:
436: if (

Line 711: RAISE FND_API.G_EXC_ERROR ;

707: null;
708: ELSE
709: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR ;
712: END IF;
713:
714: IF FND_API.To_Boolean ( p_commit ) THEN
715: COMMIT WORK;

Line 714: IF FND_API.To_Boolean ( p_commit ) THEN

710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR ;
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 726: p_lock_row := FND_API.G_FALSE;

722:
723: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
724:
725: ROLLBACK TO Lock_Row_Pvt ;
726: p_lock_row := FND_API.G_FALSE;
727: p_return_status := FND_API.G_RET_STS_ERROR;
728: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
729: p_data => p_msg_data );
730:

Line 727: p_return_status := FND_API.G_RET_STS_ERROR;

723: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
724:
725: ROLLBACK TO Lock_Row_Pvt ;
726: p_lock_row := FND_API.G_FALSE;
727: p_return_status := FND_API.G_RET_STS_ERROR;
728: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
729: p_data => p_msg_data );
730:
731: WHEN FND_API.G_EXC_ERROR THEN

Line 731: WHEN FND_API.G_EXC_ERROR THEN

727: p_return_status := FND_API.G_RET_STS_ERROR;
728: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
729: p_data => p_msg_data );
730:
731: WHEN FND_API.G_EXC_ERROR THEN
732:
733: ROLLBACK TO Lock_Row_Pvt ;
734: p_lock_row := FND_API.G_FALSE;
735: p_return_status := FND_API.G_RET_STS_ERROR;

Line 734: p_lock_row := FND_API.G_FALSE;

730:
731: WHEN FND_API.G_EXC_ERROR THEN
732:
733: ROLLBACK TO Lock_Row_Pvt ;
734: p_lock_row := FND_API.G_FALSE;
735: p_return_status := FND_API.G_RET_STS_ERROR;
736: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
737: p_data => p_msg_data );
738:

Line 735: p_return_status := FND_API.G_RET_STS_ERROR;

731: WHEN FND_API.G_EXC_ERROR THEN
732:
733: ROLLBACK TO Lock_Row_Pvt ;
734: p_lock_row := FND_API.G_FALSE;
735: p_return_status := FND_API.G_RET_STS_ERROR;
736: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
737: p_data => p_msg_data );
738:
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

735: p_return_status := FND_API.G_RET_STS_ERROR;
736: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
737: p_data => p_msg_data );
738:
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740:
741: ROLLBACK TO Lock_Row_Pvt ;
742: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 742: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

738:
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740:
741: ROLLBACK TO Lock_Row_Pvt ;
742: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
744: p_data => p_msg_data );
745:
746: WHEN OTHERS THEN

Line 749: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

745:
746: WHEN OTHERS THEN
747:
748: ROLLBACK TO Lock_Row_Pvt ;
749: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750:
751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
752: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
753: l_api_name);

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

759: END Lock_Row;
760:
761: procedure UPDATE_ROW (
762: p_api_version IN NUMBER,
763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
764: p_commit IN VARCHAR2 := FND_API.G_FALSE,
765: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
766: p_return_status OUT NOCOPY VARCHAR2,
767: p_msg_count OUT NOCOPY NUMBER,

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

760:
761: procedure UPDATE_ROW (
762: p_api_version IN NUMBER,
763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
764: p_commit IN VARCHAR2 := FND_API.G_FALSE,
765: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
766: p_return_status OUT NOCOPY VARCHAR2,
767: p_msg_count OUT NOCOPY NUMBER,
768: p_msg_data OUT NOCOPY VARCHAR2,

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

761: procedure UPDATE_ROW (
762: p_api_version IN NUMBER,
763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
764: p_commit IN VARCHAR2 := FND_API.G_FALSE,
765: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
766: p_return_status OUT NOCOPY VARCHAR2,
767: p_msg_count OUT NOCOPY NUMBER,
768: p_msg_data OUT NOCOPY VARCHAR2,
769:

Line 851: IF NOT FND_API.Compatible_API_Call ( l_api_version,

847: BEGIN
848:
849: SAVEPOINT Update_Row_Pvt ;
850:
851: IF NOT FND_API.Compatible_API_Call ( l_api_version,
852: p_api_version,
853: l_api_name,
854: G_PKG_NAME )
855: THEN

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

852: p_api_version,
853: l_api_name,
854: G_PKG_NAME )
855: THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
857: END IF;
858:
859:
860: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 860: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
857: END IF;
858:
859:
860: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
861: FND_MSG_PUB.initialize ;
862: END IF;
863:
864: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 864: p_return_status := FND_API.G_RET_STS_SUCCESS ;

860: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
861: FND_MSG_PUB.initialize ;
862: END IF;
863:
864: p_return_status := FND_API.G_RET_STS_SUCCESS ;
865:
866: update PSB_PARAMETER_FORMULAS set
867: PARAMETER_ID = P_PARAMETER_ID,
868: PARAMETER_FORMULA_ID = P_PARAMETER_FORMULA_ID,

Line 945: IF FND_API.To_Boolean ( p_commit ) THEN

941: IF (SQL%NOTFOUND) THEN
942: RAISE NO_DATA_FOUND ;
943: END IF;
944:
945: IF FND_API.To_Boolean ( p_commit ) THEN
946: COMMIT WORK;
947: END iF;
948:
949: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 954: WHEN FND_API.G_EXC_ERROR THEN

950: p_data => p_msg_data );
951:
952: EXCEPTION
953:
954: WHEN FND_API.G_EXC_ERROR THEN
955:
956: ROLLBACK TO Update_Row_Pvt ;
957: p_return_status := FND_API.G_RET_STS_ERROR;
958: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 957: p_return_status := FND_API.G_RET_STS_ERROR;

953:
954: WHEN FND_API.G_EXC_ERROR THEN
955:
956: ROLLBACK TO Update_Row_Pvt ;
957: p_return_status := FND_API.G_RET_STS_ERROR;
958: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
959: p_data => p_msg_data );
960:
961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

957: p_return_status := FND_API.G_RET_STS_ERROR;
958: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
959: p_data => p_msg_data );
960:
961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
962:
963: ROLLBACK TO Update_Row_Pvt ;
964: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 964: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

960:
961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
962:
963: ROLLBACK TO Update_Row_Pvt ;
964: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
966: p_data => p_msg_data );
967:
968: WHEN OTHERS THEN

Line 971: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

967:
968: WHEN OTHERS THEN
969:
970: ROLLBACK TO Update_Row_Pvt ;
971: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972:
973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
974: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
975: l_api_name);

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

981: END Update_Row;
982:
983: procedure DELETE_ROW (
984: p_api_version IN NUMBER,
985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
986: p_commit IN VARCHAR2 := FND_API.G_FALSE,
987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
988: p_return_status OUT NOCOPY VARCHAR2,
989: p_msg_count OUT NOCOPY NUMBER,

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

982:
983: procedure DELETE_ROW (
984: p_api_version IN NUMBER,
985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
986: p_commit IN VARCHAR2 := FND_API.G_FALSE,
987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
988: p_return_status OUT NOCOPY VARCHAR2,
989: p_msg_count OUT NOCOPY NUMBER,
990: p_msg_data OUT NOCOPY VARCHAR2,

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

983: procedure DELETE_ROW (
984: p_api_version IN NUMBER,
985: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
986: p_commit IN VARCHAR2 := FND_API.G_FALSE,
987: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
988: p_return_status OUT NOCOPY VARCHAR2,
989: p_msg_count OUT NOCOPY NUMBER,
990: p_msg_data OUT NOCOPY VARCHAR2,
991:

Line 1002: IF NOT FND_API.Compatible_API_Call ( l_api_version,

998: BEGIN
999:
1000: SAVEPOINT Delete_Row_Pvt ;
1001:
1002: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1003: p_api_version,
1004: l_api_name,
1005: G_PKG_NAME )
1006: THEN

Line 1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1003: p_api_version,
1004: l_api_name,
1005: G_PKG_NAME )
1006: THEN
1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1008: END IF;
1009:
1010:
1011: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 1011: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1008: END IF;
1009:
1010:
1011: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1012: FND_MSG_PUB.initialize ;
1013: END IF;
1014:
1015: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1015: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1011: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1012: FND_MSG_PUB.initialize ;
1013: END IF;
1014:
1015: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1016:
1017: delete from PSB_PARAMETER_FORMULAS
1018: where PARAMETER_FORMULA_ID = P_PARAMETER_FORMULA_ID;
1019: IF (SQL%NOTFOUND) THEN

Line 1023: IF FND_API.To_Boolean ( p_commit ) THEN

1019: IF (SQL%NOTFOUND) THEN
1020: RAISE NO_DATA_FOUND ;
1021: END IF;
1022:
1023: IF FND_API.To_Boolean ( p_commit ) THEN
1024: COMMIT WORK;
1025: END iF;
1026:
1027: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1032: WHEN FND_API.G_EXC_ERROR THEN

1028: p_data => p_msg_data );
1029:
1030: EXCEPTION
1031:
1032: WHEN FND_API.G_EXC_ERROR THEN
1033:
1034: ROLLBACK TO Delete_Row_Pvt ;
1035: p_return_status := FND_API.G_RET_STS_ERROR;
1036: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1035: p_return_status := FND_API.G_RET_STS_ERROR;

1031:
1032: WHEN FND_API.G_EXC_ERROR THEN
1033:
1034: ROLLBACK TO Delete_Row_Pvt ;
1035: p_return_status := FND_API.G_RET_STS_ERROR;
1036: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1037: p_data => p_msg_data );
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1035: p_return_status := FND_API.G_RET_STS_ERROR;
1036: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1037: p_data => p_msg_data );
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040:
1041: ROLLBACK TO Delete_Row_Pvt ;
1042: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1042: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040:
1041: ROLLBACK TO Delete_Row_Pvt ;
1042: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1044: p_data => p_msg_data );
1045:
1046: WHEN OTHERS THEN

Line 1049: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1045:
1046: WHEN OTHERS THEN
1047:
1048: ROLLBACK TO Delete_Row_Pvt ;
1049: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050:
1051: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1052: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1053: l_api_name);