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.FEM_DIM_UTILS_PVT dependencies on FND_API

Line 196: when FND_API.G_EXC_ERROR then

192: end if;
193:
194: EXCEPTION
195:
196: when FND_API.G_EXC_ERROR then
197: return l_read_only_flag;
198:
199: when FND_API.G_EXC_UNEXPECTED_ERROR then
200: return l_read_only_flag;

Line 199: when FND_API.G_EXC_UNEXPECTED_ERROR then

195:
196: when FND_API.G_EXC_ERROR then
197: return l_read_only_flag;
198:
199: when FND_API.G_EXC_UNEXPECTED_ERROR then
200: return l_read_only_flag;
201:
202: when OTHERS then
203: return l_read_only_flag;

Line 430: when FND_API.G_EXC_ERROR then

426: end if;
427:
428: EXCEPTION
429:
430: when FND_API.G_EXC_ERROR then
431: return l_read_only_flag;
432:
433: when FND_API.G_EXC_UNEXPECTED_ERROR then
434: return l_read_only_flag;

Line 433: when FND_API.G_EXC_UNEXPECTED_ERROR then

429:
430: when FND_API.G_EXC_ERROR then
431: return l_read_only_flag;
432:
433: when FND_API.G_EXC_UNEXPECTED_ERROR then
434: return l_read_only_flag;
435:
436: when OTHERS then
437: return l_read_only_flag;

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

777: -- that have display code col and member col as the same.
778: PROCEDURE Check_Unique_Member
779: (
780: p_api_version IN NUMBER,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
784: p_return_status OUT NOCOPY VARCHAR2,
785: p_msg_count OUT NOCOPY NUMBER,

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

778: PROCEDURE Check_Unique_Member
779: (
780: p_api_version IN NUMBER,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
784: p_return_status OUT NOCOPY VARCHAR2,
785: p_msg_count OUT NOCOPY NUMBER,
786: p_msg_data OUT NOCOPY VARCHAR2,

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

779: (
780: p_api_version IN NUMBER,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
784: p_return_status OUT NOCOPY VARCHAR2,
785: p_msg_count OUT NOCOPY NUMBER,
786: p_msg_data OUT NOCOPY VARCHAR2,
787: --

Line 829: IF NOT FND_API.Compatible_API_Call ( l_api_version,

825: FROM fem_xdim_dimensions_vl
826: WHERE dimension_varchar_label = p_dimension_varchar_label;
827:
828: BEGIN
829: IF NOT FND_API.Compatible_API_Call ( l_api_version,
830: p_api_version,
831: l_api_name,
832: G_PKG_NAME )
833: THEN

Line 834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

830: p_api_version,
831: l_api_name,
832: G_PKG_NAME )
833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
835: END IF;
836:
837: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
838: FND_MSG_PUB.initialize ;

Line 837: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
835: END IF;
836:
837: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
838: FND_MSG_PUB.initialize ;
839: END IF;
840:
841: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 841: p_return_status := FND_API.G_RET_STS_SUCCESS ;

837: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
838: FND_MSG_PUB.initialize ;
839: END IF;
840:
841: p_return_status := FND_API.G_RET_STS_SUCCESS ;
842:
843: OPEN c_dim_details_csr;
844:
845: FETCH c_dim_details_csr

Line 961: raise FND_API.G_EXC_ERROR;

957:
958: --End of Bug # 4456818
959:
960: IF l_dummy <> 0 THEN
961: raise FND_API.G_EXC_ERROR;
962: END IF;
963:
964: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
965: p_data => p_msg_data );

Line 969: WHEN FND_API.G_EXC_ERROR THEN

965: p_data => p_msg_data );
966:
967: EXCEPTION
968:
969: WHEN FND_API.G_EXC_ERROR THEN
970:
971: p_return_status := FND_API.G_RET_STS_ERROR;
972: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
973: p_data => p_msg_data );

Line 971: p_return_status := FND_API.G_RET_STS_ERROR;

967: EXCEPTION
968:
969: WHEN FND_API.G_EXC_ERROR THEN
970:
971: p_return_status := FND_API.G_RET_STS_ERROR;
972: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
973: p_data => p_msg_data );
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

971: p_return_status := FND_API.G_RET_STS_ERROR;
972: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
973: p_data => p_msg_data );
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976:
977: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
979: p_data => p_msg_data );

Line 977: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

973: p_data => p_msg_data );
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976:
977: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
979: p_data => p_msg_data );
980:
981: WHEN OTHERS THEN

Line 983: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

979: p_data => p_msg_data );
980:
981: WHEN OTHERS THEN
982:
983: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984:
985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
986: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
987: l_api_name);

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

999: +===========================================================================*/
1000: PROCEDURE Member_Insert_Row
1001: (
1002: p_api_version IN NUMBER ,
1003: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1004: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1005: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1006: p_return_status OUT NOCOPY VARCHAR2 ,
1007: p_msg_count OUT NOCOPY NUMBER ,

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

1000: PROCEDURE Member_Insert_Row
1001: (
1002: p_api_version IN NUMBER ,
1003: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1004: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1005: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1006: p_return_status OUT NOCOPY VARCHAR2 ,
1007: p_msg_count OUT NOCOPY NUMBER ,
1008: p_msg_data OUT NOCOPY VARCHAR2 ,

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

1001: (
1002: p_api_version IN NUMBER ,
1003: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1004: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1005: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1006: p_return_status OUT NOCOPY VARCHAR2 ,
1007: p_msg_count OUT NOCOPY NUMBER ,
1008: p_msg_data OUT NOCOPY VARCHAR2 ,
1009: --

Line 1053: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1049: SAVEPOINT Insert_Row_Pvt ;
1050:
1051: l_member_id := p_member_id;
1052:
1053: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1054: FND_MSG_PUB.initialize ;
1055: END IF;
1056: --
1057: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1057: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1053: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1054: FND_MSG_PUB.initialize ;
1055: END IF;
1056: --
1057: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1058:
1059: -- Set Global fields.
1060: l_creation_date := SYSDATE ;
1061: l_last_update_date := l_creation_date ;

Line 5003: IF FND_API.To_Boolean ( p_commit ) THEN

4999:
5000:
5001: END IF;
5002: --
5003: IF FND_API.To_Boolean ( p_commit ) THEN
5004: COMMIT WORK;
5005: END iF;
5006: --
5007: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 5013: WHEN FND_API.G_EXC_ERROR THEN

5009: --
5010: EXCEPTION
5011: --
5012: -- Start of bug 3901421: Add the proper error handling message
5013: WHEN FND_API.G_EXC_ERROR THEN
5014: --
5015: ROLLBACK TO Insert_Row_Pvt ;
5016: p_return_status := FND_API.G_RET_STS_ERROR;
5017: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 5016: p_return_status := FND_API.G_RET_STS_ERROR;

5012: -- Start of bug 3901421: Add the proper error handling message
5013: WHEN FND_API.G_EXC_ERROR THEN
5014: --
5015: ROLLBACK TO Insert_Row_Pvt ;
5016: p_return_status := FND_API.G_RET_STS_ERROR;
5017: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5018: p_data => p_msg_data );
5019: --
5020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5016: p_return_status := FND_API.G_RET_STS_ERROR;
5017: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5018: p_data => p_msg_data );
5019: --
5020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5021: --
5022: ROLLBACK TO Insert_Row_Pvt ;
5023: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5024: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 5023: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5019: --
5020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5021: --
5022: ROLLBACK TO Insert_Row_Pvt ;
5023: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5024: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
5025: p_data => p_msg_data );
5026: --
5027: WHEN OTHERS THEN

Line 5030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5026: --
5027: WHEN OTHERS THEN
5028:
5029: ROLLBACK TO Insert_Row_Pvt ;
5030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5031: --
5032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5033: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5034: l_api_name);

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

5044:
5045: /*---------------------------------------------------------------------------*/
5046: PROCEDURE Member_Update_Row (
5047: p_api_version IN NUMBER ,
5048: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
5049: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5051: p_return_status OUT NOCOPY VARCHAR2 ,
5052: p_msg_count OUT NOCOPY NUMBER ,

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

5045: /*---------------------------------------------------------------------------*/
5046: PROCEDURE Member_Update_Row (
5047: p_api_version IN NUMBER ,
5048: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
5049: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5051: p_return_status OUT NOCOPY VARCHAR2 ,
5052: p_msg_count OUT NOCOPY NUMBER ,
5053: p_msg_data OUT NOCOPY VARCHAR2 ,

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

5046: PROCEDURE Member_Update_Row (
5047: p_api_version IN NUMBER ,
5048: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
5049: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5051: p_return_status OUT NOCOPY VARCHAR2 ,
5052: p_msg_count OUT NOCOPY NUMBER ,
5053: p_msg_data OUT NOCOPY VARCHAR2 ,
5054: --

Line 5085: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

5081: --
5082: SAVEPOINT Update_Row_Pvt ;
5083: --
5084:
5085: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
5086: FND_MSG_PUB.initialize ;
5087: END IF;
5088: --
5089: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 5089: p_return_status := FND_API.G_RET_STS_SUCCESS ;

5085: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
5086: FND_MSG_PUB.initialize ;
5087: END IF;
5088: --
5089: p_return_status := FND_API.G_RET_STS_SUCCESS ;
5090:
5091: --
5092: -- Set Global fields.
5093: --

Line 8935: IF FND_API.To_Boolean ( p_commit ) THEN

8931:
8932: END LOOP;
8933: END IF;
8934: --
8935: IF FND_API.To_Boolean ( p_commit ) THEN
8936: COMMIT WORK;
8937: END iF;
8938: --
8939: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 8944: WHEN FND_API.G_EXC_ERROR THEN

8940: p_data => p_msg_data );
8941: --
8942: EXCEPTION
8943: --
8944: WHEN FND_API.G_EXC_ERROR THEN
8945: --
8946: ROLLBACK TO Update_Row_Pvt ;
8947: p_return_status := FND_API.G_RET_STS_ERROR;
8948: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 8947: p_return_status := FND_API.G_RET_STS_ERROR;

8943: --
8944: WHEN FND_API.G_EXC_ERROR THEN
8945: --
8946: ROLLBACK TO Update_Row_Pvt ;
8947: p_return_status := FND_API.G_RET_STS_ERROR;
8948: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
8949: p_data => p_msg_data );
8950: --
8951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8947: p_return_status := FND_API.G_RET_STS_ERROR;
8948: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
8949: p_data => p_msg_data );
8950: --
8951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8952: --
8953: ROLLBACK TO Update_Row_Pvt ;
8954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8955: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 8954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8950: --
8951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8952: --
8953: ROLLBACK TO Update_Row_Pvt ;
8954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8955: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
8956: p_data => p_msg_data );
8957: --
8958: WHEN OTHERS THEN

Line 8961: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8957: --
8958: WHEN OTHERS THEN
8959: --
8960: ROLLBACK TO Update_Row_Pvt ;
8961: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8962: -- Bug 39014213901421: Add Message
8963: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8964: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
8965: l_api_name);

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

8980:
8981: PROCEDURE Member_Delete_Row
8982: (
8983: p_api_version IN NUMBER ,
8984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8985: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
8987: p_return_status OUT NOCOPY VARCHAR2 ,
8988: p_msg_count OUT NOCOPY NUMBER ,

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

8981: PROCEDURE Member_Delete_Row
8982: (
8983: p_api_version IN NUMBER ,
8984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8985: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
8987: p_return_status OUT NOCOPY VARCHAR2 ,
8988: p_msg_count OUT NOCOPY NUMBER ,
8989: p_msg_data OUT NOCOPY VARCHAR2 ,

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

8982: (
8983: p_api_version IN NUMBER ,
8984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8985: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8986: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
8987: p_return_status OUT NOCOPY VARCHAR2 ,
8988: p_msg_count OUT NOCOPY NUMBER ,
8989: p_msg_data OUT NOCOPY VARCHAR2 ,
8990: --

Line 9002: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

8998: BEGIN
8999: --
9000: SAVEPOINT Delete_Row_Pvt ;
9001:
9002: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9003: FND_MSG_PUB.initialize ;
9004: END IF;
9005: --
9006: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 9006: p_return_status := FND_API.G_RET_STS_SUCCESS ;

9002: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9003: FND_MSG_PUB.initialize ;
9004: END IF;
9005: --
9006: p_return_status := FND_API.G_RET_STS_SUCCESS ;
9007:
9008: --
9009: IF (p_dimension_varchar_label = 'CAL_PERIOD') THEN
9010: FEM_CAL_PERIODS_PKG.DELETE_ROW (

Line 9256: IF FND_API.To_Boolean ( p_commit ) THEN

9252:
9253: -- Added for Bug: 4006800 - ... end
9254:
9255: --
9256: IF FND_API.To_Boolean ( p_commit ) THEN
9257: COMMIT WORK;
9258: END IF;
9259: --
9260: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9265: WHEN FND_API.G_EXC_ERROR THEN

9261: p_data => p_msg_data );
9262: --
9263: EXCEPTION
9264: --
9265: WHEN FND_API.G_EXC_ERROR THEN
9266: --
9267: ROLLBACK TO Delete_Row_Pvt ;
9268: p_return_status := FND_API.G_RET_STS_ERROR;
9269: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9268: p_return_status := FND_API.G_RET_STS_ERROR;

9264: --
9265: WHEN FND_API.G_EXC_ERROR THEN
9266: --
9267: ROLLBACK TO Delete_Row_Pvt ;
9268: p_return_status := FND_API.G_RET_STS_ERROR;
9269: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9270: p_data => p_msg_data );
9271: --
9272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9268: p_return_status := FND_API.G_RET_STS_ERROR;
9269: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9270: p_data => p_msg_data );
9271: --
9272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9273: --
9274: ROLLBACK TO Delete_Row_Pvt ;
9275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9276: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9271: --
9272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9273: --
9274: ROLLBACK TO Delete_Row_Pvt ;
9275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9276: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9277: p_data => p_msg_data );
9278: --
9279: WHEN OTHERS THEN

Line 9282: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9278: --
9279: WHEN OTHERS THEN
9280: --
9281: ROLLBACK TO Delete_Row_Pvt ;
9282: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9283: --
9284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9285: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9286: 'Member_Delete_Row') ;

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

9549: /*---------------------------------------------------------------------------*/
9550: PROCEDURE Attribute_Insert_Row
9551: (
9552: p_api_version IN NUMBER ,
9553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9554: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
9556: p_return_status OUT NOCOPY VARCHAR2 ,
9557: p_msg_count OUT NOCOPY NUMBER ,

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

9550: PROCEDURE Attribute_Insert_Row
9551: (
9552: p_api_version IN NUMBER ,
9553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9554: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
9556: p_return_status OUT NOCOPY VARCHAR2 ,
9557: p_msg_count OUT NOCOPY NUMBER ,
9558: p_msg_data OUT NOCOPY VARCHAR2 ,

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

9551: (
9552: p_api_version IN NUMBER ,
9553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9554: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
9556: p_return_status OUT NOCOPY VARCHAR2 ,
9557: p_msg_count OUT NOCOPY NUMBER ,
9558: p_msg_data OUT NOCOPY VARCHAR2 ,
9559: --

Line 9614: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

9610: --
9611: SAVEPOINT Insert_Row_Pvt ;
9612: --
9613:
9614: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9615: FND_MSG_PUB.initialize ;
9616: END IF;
9617: --
9618: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 9618: p_return_status := FND_API.G_RET_STS_SUCCESS ;

9614: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9615: FND_MSG_PUB.initialize ;
9616: END IF;
9617: --
9618: p_return_status := FND_API.G_RET_STS_SUCCESS ;
9619:
9620: --
9621: -- Set Global fields.
9622: --

Line 9678: RAISE FND_API.G_EXC_ERROR;

9674: EXECUTE IMMEDIATE l_query INTO l_result;
9675:
9676: IF(l_result <> 0) THEN
9677: l_multi_assgn_error := 'Y';
9678: RAISE FND_API.G_EXC_ERROR;
9679: END IF;
9680:
9681: END IF;
9682:

Line 9767: IF FND_API.To_Boolean ( p_commit ) THEN

9763: IF (sql%notfound) then
9764: RAISE no_data_found;
9765: END IF;
9766:
9767: IF FND_API.To_Boolean ( p_commit ) THEN
9768: COMMIT WORK;
9769: END iF;
9770: --
9771: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9776: WHEN FND_API.G_EXC_ERROR THEN

9772: p_data => p_msg_data );
9773: --
9774: EXCEPTION
9775: --
9776: WHEN FND_API.G_EXC_ERROR THEN
9777: --
9778: ROLLBACK TO Insert_Row_Pvt ;
9779: p_return_status := FND_API.G_RET_STS_ERROR;
9780:

Line 9779: p_return_status := FND_API.G_RET_STS_ERROR;

9775: --
9776: WHEN FND_API.G_EXC_ERROR THEN
9777: --
9778: ROLLBACK TO Insert_Row_Pvt ;
9779: p_return_status := FND_API.G_RET_STS_ERROR;
9780:
9781: -- Start Bug#3848813: For cases where multiple assignment
9782: -- is not allowed
9783: IF(l_multi_assgn_error = 'Y') THEN

Line 9793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9789:
9790: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9791: p_data => p_msg_data );
9792: --
9793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9794: --
9795: ROLLBACK TO Insert_Row_Pvt ;
9796: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9797: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9796: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9792: --
9793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9794: --
9795: ROLLBACK TO Insert_Row_Pvt ;
9796: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9797: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9798: p_data => p_msg_data );
9799: --
9800:

Line 9804: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9800:
9801: WHEN OTHERS THEN
9802: --
9803: ROLLBACK TO Insert_Row_Pvt ;
9804: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9805:
9806: -- Start Bug#3848813: For cases where unique constraint
9807: -- is violated
9808:

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

9825: /*---------------------------------------------------------------------------*/
9826: PROCEDURE Attribute_Update_Row
9827: (
9828: p_api_version IN NUMBER ,
9829: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9830: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9831: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
9832: p_return_status OUT NOCOPY VARCHAR2 ,
9833: p_msg_count OUT NOCOPY NUMBER ,

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

9826: PROCEDURE Attribute_Update_Row
9827: (
9828: p_api_version IN NUMBER ,
9829: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9830: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9831: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
9832: p_return_status OUT NOCOPY VARCHAR2 ,
9833: p_msg_count OUT NOCOPY NUMBER ,
9834: p_msg_data OUT NOCOPY VARCHAR2 ,

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

9827: (
9828: p_api_version IN NUMBER ,
9829: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9830: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
9831: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
9832: p_return_status OUT NOCOPY VARCHAR2 ,
9833: p_msg_count OUT NOCOPY NUMBER ,
9834: p_msg_data OUT NOCOPY VARCHAR2 ,
9835: --

Line 9867: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

9863: --
9864: SAVEPOINT Update_Row_Pvt ;
9865: --
9866:
9867: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9868: FND_MSG_PUB.initialize ;
9869: END IF;
9870: --
9871: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 9871: p_return_status := FND_API.G_RET_STS_SUCCESS ;

9867: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
9868: FND_MSG_PUB.initialize ;
9869: END IF;
9870: --
9871: p_return_status := FND_API.G_RET_STS_SUCCESS ;
9872:
9873: --
9874: -- Set Global fields.
9875: --

Line 9957: IF FND_API.To_Boolean ( p_commit ) THEN

9953: IF (sql%notfound) then
9954: RAISE no_data_found;
9955: END IF;
9956:
9957: IF FND_API.To_Boolean ( p_commit ) THEN
9958: COMMIT WORK;
9959: END iF;
9960: --
9961: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9966: WHEN FND_API.G_EXC_ERROR THEN

9962: p_data => p_msg_data );
9963: --
9964: EXCEPTION
9965: --
9966: WHEN FND_API.G_EXC_ERROR THEN
9967: --
9968: ROLLBACK TO Update_Row_Pvt ;
9969: p_return_status := FND_API.G_RET_STS_ERROR;
9970: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9969: p_return_status := FND_API.G_RET_STS_ERROR;

9965: --
9966: WHEN FND_API.G_EXC_ERROR THEN
9967: --
9968: ROLLBACK TO Update_Row_Pvt ;
9969: p_return_status := FND_API.G_RET_STS_ERROR;
9970: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9971: p_data => p_msg_data );
9972: --
9973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9969: p_return_status := FND_API.G_RET_STS_ERROR;
9970: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9971: p_data => p_msg_data );
9972: --
9973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9974: --
9975: ROLLBACK TO Update_Row_Pvt ;
9976: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9977: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 9976: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9972: --
9973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9974: --
9975: ROLLBACK TO Update_Row_Pvt ;
9976: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9977: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
9978: p_data => p_msg_data );
9979: --
9980:

Line 9984: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9980:
9981: WHEN OTHERS THEN
9982: --
9983: ROLLBACK TO Update_Row_Pvt ;
9984: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9985: --
9986:
9987: --
9988: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

9996: /*---------------------------------------------------------------------------*/
9997: PROCEDURE Attribute_Delete_Row
9998: (
9999: p_api_version IN NUMBER ,
10000: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10001: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10002: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
10003: p_return_status OUT NOCOPY VARCHAR2 ,
10004: p_msg_count OUT NOCOPY NUMBER ,

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

9997: PROCEDURE Attribute_Delete_Row
9998: (
9999: p_api_version IN NUMBER ,
10000: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10001: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10002: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
10003: p_return_status OUT NOCOPY VARCHAR2 ,
10004: p_msg_count OUT NOCOPY NUMBER ,
10005: p_msg_data OUT NOCOPY VARCHAR2 ,

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

9998: (
9999: p_api_version IN NUMBER ,
10000: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10001: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10002: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
10003: p_return_status OUT NOCOPY VARCHAR2 ,
10004: p_msg_count OUT NOCOPY NUMBER ,
10005: p_msg_data OUT NOCOPY VARCHAR2 ,
10006: --

Line 10024: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

10020: begin
10021: --
10022: SAVEPOINT Delete_Row_Pvt ;
10023:
10024: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
10025: FND_MSG_PUB.initialize ;
10026: END IF;
10027: --
10028: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 10028: p_return_status := FND_API.G_RET_STS_SUCCESS ;

10024: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
10025: FND_MSG_PUB.initialize ;
10026: END IF;
10027: --
10028: p_return_status := FND_API.G_RET_STS_SUCCESS ;
10029:
10030: if (p_member_value_set_id <= 0) then
10031: -- The control comes here for Value set Not required dimensions
10032: if( p_dim_attr_varchar_member is null ) then

Line 10120: IF FND_API.To_Boolean ( p_commit ) THEN

10116: IF (sql%notfound) then
10117: RAISE no_data_found;
10118: END IF;
10119:
10120: IF FND_API.To_Boolean ( p_commit ) THEN
10121: COMMIT WORK;
10122: END iF;
10123: --
10124: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 10129: WHEN FND_API.G_EXC_ERROR THEN

10125: p_data => p_msg_data );
10126: --
10127: EXCEPTION
10128: --
10129: WHEN FND_API.G_EXC_ERROR THEN
10130: --
10131: ROLLBACK TO Delete_Row_Pvt ;
10132: p_return_status := FND_API.G_RET_STS_ERROR;
10133: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 10132: p_return_status := FND_API.G_RET_STS_ERROR;

10128: --
10129: WHEN FND_API.G_EXC_ERROR THEN
10130: --
10131: ROLLBACK TO Delete_Row_Pvt ;
10132: p_return_status := FND_API.G_RET_STS_ERROR;
10133: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10134: p_data => p_msg_data );
10135: --
10136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 10136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10132: p_return_status := FND_API.G_RET_STS_ERROR;
10133: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10134: p_data => p_msg_data );
10135: --
10136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10137: --
10138: ROLLBACK TO Delete_Row_Pvt ;
10139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10140: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 10139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10135: --
10136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10137: --
10138: ROLLBACK TO Delete_Row_Pvt ;
10139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10140: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10141: p_data => p_msg_data );
10142: --
10143:

Line 10147: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10143:
10144: WHEN OTHERS THEN
10145: --
10146: ROLLBACK TO Delete_Row_Pvt ;
10147: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10148: --
10149:
10150: --
10151: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 10401: RAISE FND_API.G_EXC_ERROR;

10397:
10398: IF l_uom_code IS NULL THEN
10399: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_COST_OBJ_UOM_ERROR');
10400: FND_MSG_PUB.ADD;
10401: RAISE FND_API.G_EXC_ERROR;
10402: END IF;
10403:
10404: END IF;
10405:

Line 10416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10412: EXCEPTION
10413:
10414: WHEN OTHERS THEN
10415:
10416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10417:
10418: END Get_UOM_Code;
10419:
10420: /*---------------------------------------------------------------------------*/

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

10426: +===========================================================================*/
10427: -- Procedure to create new Composite Dimension Members.
10428: PROCEDURE Create_Comp_Dim_Member (
10429: p_api_version IN NUMBER ,
10430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10431: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
10433: p_return_status OUT NOCOPY VARCHAR2 ,
10434: p_msg_count OUT NOCOPY NUMBER ,

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

10427: -- Procedure to create new Composite Dimension Members.
10428: PROCEDURE Create_Comp_Dim_Member (
10429: p_api_version IN NUMBER ,
10430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10431: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
10433: p_return_status OUT NOCOPY VARCHAR2 ,
10434: p_msg_count OUT NOCOPY NUMBER ,
10435: p_msg_data OUT NOCOPY VARCHAR2 ,

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

10428: PROCEDURE Create_Comp_Dim_Member (
10429: p_api_version IN NUMBER ,
10430: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10431: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
10433: p_return_status OUT NOCOPY VARCHAR2 ,
10434: p_msg_count OUT NOCOPY NUMBER ,
10435: p_msg_data OUT NOCOPY VARCHAR2 ,
10436: --

Line 10507: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

10503: BEGIN
10504:
10505: SAVEPOINT Create_Comp_Dim_Mem_Pvt;
10506:
10507: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
10508: FND_MSG_PUB.initialize;
10509: END IF;
10510:
10511: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10511: p_return_status := FND_API.G_RET_STS_SUCCESS;

10507: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
10508: FND_MSG_PUB.initialize;
10509: END IF;
10510:
10511: p_return_status := FND_API.G_RET_STS_SUCCESS;
10512:
10513:
10514: IF p_dim_varchar_label = 'COST_OBJECT' THEN
10515:

Line 10530: RAISE FND_API.G_EXC_ERROR;

10526: x_return_status => l_return_status,
10527: x_msg_count => l_msg_count,
10528: x_msg_data => l_msg_data);*/
10529: if l_msg_count <> 0 then
10530: RAISE FND_API.G_EXC_ERROR;
10531: end if;
10532:
10533:
10534: --Bug#4370513

Line 10576: RAISE FND_API.G_EXC_ERROR;

10572:
10573: IF l_uom_code IS NULL THEN
10574: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_COST_OBJ_UOM_ERROR');
10575: FND_MSG_PUB.ADD;
10576: RAISE FND_API.G_EXC_ERROR;
10577: END IF;
10578:
10579: END IF;
10580:

Line 10834: RAISE FND_API.G_EXC_ERROR;

10830: x_return_status => l_return_status,
10831: x_msg_count => l_msg_count,
10832: x_msg_data => l_msg_data);*/
10833: if l_msg_count <> 0 then
10834: RAISE FND_API.G_EXC_ERROR;
10835: end if;
10836:
10837: --Bug#4370513
10838: --Pass global_vs_combo_id to check_unique_member_api()

Line 11090: IF FND_API.To_Boolean ( p_commit ) THEN

11086:
11087: END IF;
11088:
11089: --Bug#5395770: Add the standard commit block.
11090: IF FND_API.To_Boolean ( p_commit ) THEN
11091: COMMIT WORK;
11092: END IF;
11093:
11094:

Line 11097: WHEN FND_API.G_EXC_ERROR THEN

11093:
11094:
11095: EXCEPTION
11096:
11097: WHEN FND_API.G_EXC_ERROR THEN
11098:
11099: ROLLBACK TO Create_Comp_Dim_Mem_Pvt ;
11100: p_return_status := FND_API.G_RET_STS_ERROR;
11101: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 11100: p_return_status := FND_API.G_RET_STS_ERROR;

11096:
11097: WHEN FND_API.G_EXC_ERROR THEN
11098:
11099: ROLLBACK TO Create_Comp_Dim_Mem_Pvt ;
11100: p_return_status := FND_API.G_RET_STS_ERROR;
11101: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
11102: p_data => p_msg_data );
11103:
11104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 11104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11100: p_return_status := FND_API.G_RET_STS_ERROR;
11101: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
11102: p_data => p_msg_data );
11103:
11104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11105:
11106: ROLLBACK TO Create_Comp_Dim_Mem_Pvt ;
11107: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11108: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 11107: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11103:
11104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11105:
11106: ROLLBACK TO Create_Comp_Dim_Mem_Pvt ;
11107: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11108: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
11109: p_data => p_msg_data );
11110:
11111: WHEN OTHERS THEN

Line 11114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11110:
11111: WHEN OTHERS THEN
11112:
11113: ROLLBACK TO Create_Comp_Dim_Mem_Pvt ;
11114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11115: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
11116: p_data => p_msg_data );
11117:
11118: END Create_Comp_Dim_Member;

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

11126: | PROCEDURE Validate_Cal_Period_Member |
11127: +===========================================================================*/
11128: PROCEDURE Validate_Cal_Period_Member (
11129: p_api_version IN NUMBER,
11130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11131: x_return_status OUT NOCOPY VARCHAR2,
11132: x_msg_count OUT NOCOPY NUMBER,
11133: x_msg_data OUT NOCOPY VARCHAR2,
11134: --

Line 11205: IF NOT FND_API.Compatible_API_Call ( l_api_version,

11201:
11202:
11203: BEGIN
11204:
11205: IF NOT FND_API.Compatible_API_Call ( l_api_version,
11206: p_api_version,
11207: l_api_name,
11208: G_PKG_NAME )
11209: THEN

Line 11210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

11206: p_api_version,
11207: l_api_name,
11208: G_PKG_NAME )
11209: THEN
11210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
11211: END IF;
11212:
11213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
11214: FND_MSG_PUB.initialize ;

Line 11213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

11209: THEN
11210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
11211: END IF;
11212:
11213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
11214: FND_MSG_PUB.initialize ;
11215: END IF;
11216:
11217: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11217: x_return_status := FND_API.G_RET_STS_SUCCESS;

11213: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
11214: FND_MSG_PUB.initialize ;
11215: END IF;
11216:
11217: x_return_status := FND_API.G_RET_STS_SUCCESS;
11218:
11219: --
11220: -- Find out the time_group_type_code used for start and end date validation
11221: --

Line 11241: RAISE FND_API.G_EXC_ERROR;

11237:
11238: IF (p_start_date > p_end_date)
11239: THEN
11240: l_exception_type := l_expt_dates_check;
11241: RAISE FND_API.G_EXC_ERROR;
11242: END IF;
11243:
11244: ELSE
11245:

Line 11249: RAISE FND_API.G_EXC_ERROR;

11245:
11246: IF (p_start_date >= p_end_date)
11247: THEN
11248: l_exception_type := l_expt_dates_check;
11249: RAISE FND_API.G_EXC_ERROR;
11250: END IF;
11251:
11252: END IF;
11253:

Line 11270: RAISE FND_API.G_EXC_ERROR;

11266: THEN
11267: l_cal_period_name := NULL;
11268: ELSE
11269: l_exception_type := l_expt_ovrlp_check ;
11270: RAISE FND_API.G_EXC_ERROR;
11271: END IF;
11272:
11273: END IF;
11274:

Line 11292: RAISE FND_API.G_EXC_ERROR;

11288:
11289: IF (l_cur_period_csr%FOUND)
11290: THEN
11291: l_exception_type := l_expt_cur_prd_check;
11292: RAISE FND_API.G_EXC_ERROR;
11293: END IF;
11294:
11295: CLOSE l_cur_period_csr;
11296:

Line 11308: WHEN FND_API.G_EXC_ERROR THEN

11304:
11305:
11306: EXCEPTION
11307:
11308: WHEN FND_API.G_EXC_ERROR THEN
11309:
11310: x_return_status := FND_API.G_RET_STS_ERROR;
11311:
11312: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR))

Line 11310: x_return_status := FND_API.G_RET_STS_ERROR;

11306: EXCEPTION
11307:
11308: WHEN FND_API.G_EXC_ERROR THEN
11309:
11310: x_return_status := FND_API.G_RET_STS_ERROR;
11311:
11312: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR))
11313: THEN
11314:

Line 11342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11338:
11339: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
11340: p_data => x_msg_data );
11341:
11342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11343:
11344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11345:
11346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 11344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11340: p_data => x_msg_data );
11341:
11342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11343:
11344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11345:
11346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
11347: p_data => x_msg_data );
11348:

Line 11351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11347: p_data => x_msg_data );
11348:
11349: WHEN OTHERS THEN
11350:
11351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11352:
11353: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11354: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
11355: l_api_name);