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

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

11:
12: PROCEDURE Insert_Row
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: p_return_status OUT NOCOPY VARCHAR2,
19: p_msg_count OUT NOCOPY NUMBER,

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

12: PROCEDURE Insert_Row
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: p_return_status OUT NOCOPY VARCHAR2,
19: p_msg_count OUT NOCOPY NUMBER,
20: p_msg_data OUT NOCOPY VARCHAR2,

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

13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: p_return_status OUT NOCOPY VARCHAR2,
19: p_msg_count OUT NOCOPY NUMBER,
20: p_msg_data OUT NOCOPY VARCHAR2,
21: --

Line 120: IF NOT FND_API.Compatible_API_Call ( l_api_version,

116: BEGIN
117: --
118: SAVEPOINT Insert_Row_Pvt ;
119: --
120: IF NOT FND_API.Compatible_API_Call ( l_api_version,
121: p_api_version,
122: l_api_name,
123: G_PKG_NAME )
124: THEN

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

121: p_api_version,
122: l_api_name,
123: G_PKG_NAME )
124: THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
126: END IF;
127: --
128:
129: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 129: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
126: END IF;
127: --
128:
129: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
130: FND_MSG_PUB.initialize ;
131: END IF;
132: --
133: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 133: p_return_status := FND_API.G_RET_STS_SUCCESS ;

129: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
130: FND_MSG_PUB.initialize ;
131: END IF;
132: --
133: p_return_status := FND_API.G_RET_STS_SUCCESS ;
134: --
135: IF (p_Line_Sequence_Id is NULL) THEN
136: OPEN C2;
137: FETCH C2 INTO p_Line_Sequence_Id;

Line 315: RAISE FND_API.G_EXC_ERROR ;

311: OPEN C;
312: FETCH C INTO p_Row_Id;
313: IF (C%NOTFOUND) then
314: CLOSE C;
315: RAISE FND_API.G_EXC_ERROR ;
316: -- Raise NO_DATA_FOUND;
317: END IF;
318: CLOSE C;
319: --

Line 320: IF FND_API.To_Boolean ( p_commit ) THEN

316: -- Raise NO_DATA_FOUND;
317: END IF;
318: CLOSE C;
319: --
320: IF FND_API.To_Boolean ( p_commit ) THEN
321: COMMIT WORK;
322: END iF;
323: --
324: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 329: WHEN FND_API.G_EXC_ERROR THEN

325: p_data => p_msg_data );
326: --
327: EXCEPTION
328: --
329: WHEN FND_API.G_EXC_ERROR THEN
330: --
331: ROLLBACK TO Insert_Row_Pvt ;
332: p_return_status := FND_API.G_RET_STS_ERROR;
333: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 332: p_return_status := FND_API.G_RET_STS_ERROR;

328: --
329: WHEN FND_API.G_EXC_ERROR THEN
330: --
331: ROLLBACK TO Insert_Row_Pvt ;
332: p_return_status := FND_API.G_RET_STS_ERROR;
333: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
334: p_data => p_msg_data );
335: --
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

332: p_return_status := FND_API.G_RET_STS_ERROR;
333: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
334: p_data => p_msg_data );
335: --
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337: --
338: ROLLBACK TO Insert_Row_Pvt ;
339: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 339: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

335: --
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337: --
338: ROLLBACK TO Insert_Row_Pvt ;
339: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
341: p_data => p_msg_data );
342: --
343: WHEN OTHERS THEN

Line 346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: --
343: WHEN OTHERS THEN
344: --
345: ROLLBACK TO Insert_Row_Pvt ;
346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: --
348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
349: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
350: l_api_name);

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

365:
366: PROCEDURE Lock_Row
367: (
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_return_status OUT NOCOPY VARCHAR2,
373: p_msg_count OUT NOCOPY NUMBER,

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

366: PROCEDURE Lock_Row
367: (
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_return_status OUT NOCOPY VARCHAR2,
373: p_msg_count OUT NOCOPY NUMBER,
374: p_msg_data OUT NOCOPY VARCHAR2,

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

367: (
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_return_status OUT NOCOPY VARCHAR2,
373: p_msg_count OUT NOCOPY NUMBER,
374: p_msg_data OUT NOCOPY VARCHAR2,
375: --

Line 473: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 482: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 486: p_return_status := FND_API.G_RET_STS_SUCCESS ;

482: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
483: FND_MSG_PUB.initialize ;
484: END IF;
485: --
486: p_return_status := FND_API.G_RET_STS_SUCCESS ;
487: p_row_locked := FND_API.G_TRUE ;
488: --
489: OPEN C;
490: FETCH C INTO Recinfo;

Line 487: p_row_locked := FND_API.G_TRUE ;

483: FND_MSG_PUB.initialize ;
484: END IF;
485: --
486: p_return_status := FND_API.G_RET_STS_SUCCESS ;
487: p_row_locked := FND_API.G_TRUE ;
488: --
489: OPEN C;
490: FETCH C INTO Recinfo;
491: IF (C%NOTFOUND) THEN

Line 495: RAISE FND_API.G_EXC_ERROR ;

491: IF (C%NOTFOUND) THEN
492: CLOSE C;
493: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
494: FND_MSG_PUB.Add;
495: RAISE FND_API.G_EXC_ERROR ;
496: END IF;
497: CLOSE C;
498:
499: IF

Line 736: RAISE FND_API.G_EXC_ERROR ;

732: Null;
733: ELSE
734: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
735: FND_MSG_PUB.Add;
736: RAISE FND_API.G_EXC_ERROR ;
737: END IF;
738:
739: --
740: IF FND_API.To_Boolean ( p_commit ) THEN

Line 740: IF FND_API.To_Boolean ( p_commit ) THEN

736: RAISE FND_API.G_EXC_ERROR ;
737: END IF;
738:
739: --
740: IF FND_API.To_Boolean ( p_commit ) THEN
741: COMMIT WORK;
742: END iF;
743: --
744: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 752: p_row_locked := FND_API.G_FALSE;

748: --
749: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
750: --
751: ROLLBACK TO Lock_Row_Pvt ;
752: p_row_locked := FND_API.G_FALSE;
753: p_return_status := FND_API.G_RET_STS_ERROR;
754: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
755: p_data => p_msg_data );
756: --

Line 753: p_return_status := FND_API.G_RET_STS_ERROR;

749: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
750: --
751: ROLLBACK TO Lock_Row_Pvt ;
752: p_row_locked := FND_API.G_FALSE;
753: p_return_status := FND_API.G_RET_STS_ERROR;
754: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
755: p_data => p_msg_data );
756: --
757: WHEN FND_API.G_EXC_ERROR THEN

Line 757: WHEN FND_API.G_EXC_ERROR THEN

753: p_return_status := FND_API.G_RET_STS_ERROR;
754: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
755: p_data => p_msg_data );
756: --
757: WHEN FND_API.G_EXC_ERROR THEN
758: --
759: ROLLBACK TO Lock_Row_Pvt ;
760: p_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 760: p_return_status := FND_API.G_RET_STS_ERROR;

756: --
757: WHEN FND_API.G_EXC_ERROR THEN
758: --
759: ROLLBACK TO Lock_Row_Pvt ;
760: p_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
762: p_data => p_msg_data );
763: --
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

760: p_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
762: p_data => p_msg_data );
763: --
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO Lock_Row_Pvt ;
766: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
768: p_data => p_msg_data );

Line 766: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

762: p_data => p_msg_data );
763: --
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO Lock_Row_Pvt ;
766: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
768: p_data => p_msg_data );
769: --
770: WHEN OTHERS THEN

Line 773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

769: --
770: WHEN OTHERS THEN
771: --
772: ROLLBACK TO Lock_Row_Pvt ;
773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: --
775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
776: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
777: l_api_name);

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

792:
793: PROCEDURE Update_Row
794: (
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
797: p_commit IN VARCHAR2 := FND_API.G_FALSE,
798: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
799: p_return_status OUT NOCOPY VARCHAR2,
800: p_msg_count OUT NOCOPY NUMBER,

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

793: PROCEDURE Update_Row
794: (
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
797: p_commit IN VARCHAR2 := FND_API.G_FALSE,
798: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
799: p_return_status OUT NOCOPY VARCHAR2,
800: p_msg_count OUT NOCOPY NUMBER,
801: p_msg_data OUT NOCOPY VARCHAR2,

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

794: (
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
797: p_commit IN VARCHAR2 := FND_API.G_FALSE,
798: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
799: p_return_status OUT NOCOPY VARCHAR2,
800: p_msg_count OUT NOCOPY NUMBER,
801: p_msg_data OUT NOCOPY VARCHAR2,
802: --

Line 894: IF NOT FND_API.Compatible_API_Call ( l_api_version,

890: BEGIN
891: --
892: SAVEPOINT Update_Row_Pvt ;
893: --
894: IF NOT FND_API.Compatible_API_Call ( l_api_version,
895: p_api_version,
896: l_api_name,
897: G_PKG_NAME )
898: THEN

Line 899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

895: p_api_version,
896: l_api_name,
897: G_PKG_NAME )
898: THEN
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
900: END IF;
901: --
902:
903: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 903: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
900: END IF;
901: --
902:
903: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
904: FND_MSG_PUB.initialize ;
905: END IF;
906: --
907: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 907: p_return_status := FND_API.G_RET_STS_SUCCESS ;

903: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
904: FND_MSG_PUB.initialize ;
905: END IF;
906: --
907: p_return_status := FND_API.G_RET_STS_SUCCESS ;
908: --
909:
910: UPDATE psb_account_position_set_lines
911: SET

Line 998: IF FND_API.To_Boolean ( p_commit ) THEN

994: IF (SQL%NOTFOUND) THEN
995: RAISE NO_DATA_FOUND ;
996: END IF;
997: --
998: IF FND_API.To_Boolean ( p_commit ) THEN
999: COMMIT WORK;
1000: END iF;
1001: --
1002: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1007: WHEN FND_API.G_EXC_ERROR THEN

1003: p_data => p_msg_data );
1004: --
1005: EXCEPTION
1006: --
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: --
1009: ROLLBACK TO Update_Row_Pvt ;
1010: p_return_status := FND_API.G_RET_STS_ERROR;
1011: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1010: p_return_status := FND_API.G_RET_STS_ERROR;

1006: --
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: --
1009: ROLLBACK TO Update_Row_Pvt ;
1010: p_return_status := FND_API.G_RET_STS_ERROR;
1011: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1012: p_data => p_msg_data );
1013: --
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1010: p_return_status := FND_API.G_RET_STS_ERROR;
1011: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1012: p_data => p_msg_data );
1013: --
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015: --
1016: ROLLBACK TO Update_Row_Pvt ;
1017: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1017: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1013: --
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015: --
1016: ROLLBACK TO Update_Row_Pvt ;
1017: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1019: p_data => p_msg_data );
1020: --
1021: WHEN OTHERS THEN

Line 1024: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1020: --
1021: WHEN OTHERS THEN
1022: --
1023: ROLLBACK TO Update_Row_Pvt ;
1024: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: --
1026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1027: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1028: l_api_name);

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

1043:
1044: PROCEDURE Delete_Row
1045: (
1046: p_api_version IN NUMBER,
1047: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1048: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1049: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1050: p_return_status OUT NOCOPY VARCHAR2,
1051: p_msg_count OUT NOCOPY NUMBER,

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

1044: PROCEDURE Delete_Row
1045: (
1046: p_api_version IN NUMBER,
1047: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1048: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1049: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1050: p_return_status OUT NOCOPY VARCHAR2,
1051: p_msg_count OUT NOCOPY NUMBER,
1052: p_msg_data OUT NOCOPY VARCHAR2,

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

1045: (
1046: p_api_version IN NUMBER,
1047: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1048: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1049: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1050: p_return_status OUT NOCOPY VARCHAR2,
1051: p_msg_count OUT NOCOPY NUMBER,
1052: p_msg_data OUT NOCOPY VARCHAR2,
1053: --

Line 1067: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1063: BEGIN
1064: --
1065: SAVEPOINT Delete_Row_Pvt ;
1066: --
1067: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1068: p_api_version,
1069: l_api_name,
1070: G_PKG_NAME )
1071: THEN

Line 1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1068: p_api_version,
1069: l_api_name,
1070: G_PKG_NAME )
1071: THEN
1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1073: END IF;
1074: --
1075:
1076: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 1076: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1073: END IF;
1074: --
1075:
1076: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1077: FND_MSG_PUB.initialize ;
1078: END IF;
1079: --
1080: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1080: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1076: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1077: FND_MSG_PUB.initialize ;
1078: END IF;
1079: --
1080: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1081: --
1082:
1083: --
1084: -- Deleting dependent detail records from psb_position_set_line_values.

Line 1105: IF FND_API.To_Boolean ( p_commit ) THEN

1101: IF (SQL%NOTFOUND) THEN
1102: RAISE NO_DATA_FOUND ;
1103: END IF;
1104: --
1105: IF FND_API.To_Boolean ( p_commit ) THEN
1106: COMMIT WORK;
1107: END iF;
1108: --
1109: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1114: WHEN FND_API.G_EXC_ERROR THEN

1110: p_data => p_msg_data );
1111:
1112: EXCEPTION
1113: --
1114: WHEN FND_API.G_EXC_ERROR THEN
1115: --
1116: ROLLBACK TO Delete_Row_Pvt ;
1117: p_return_status := FND_API.G_RET_STS_ERROR;
1118: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1117: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1124: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1127: --
1128: WHEN OTHERS THEN
1129: --
1130: ROLLBACK TO Delete_Row_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);