23: ( p_api_version IN NUMBER
24: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
26: , x_return_status OUT NOCOPY VARCHAR2
27: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
28: )
29: IS
30: BEGIN
31:
30: BEGIN
31:
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: if( BIS_UTILITIES_PUB.Value_Missing
35: (p_Dimension_Level_Rec.dimension_short_name)
36: = FND_API.G_TRUE
37: OR BIS_UTILITIES_PUB.Value_NULL(p_Dimension_Level_Rec.dimension_short_name)
38: = FND_API.G_TRUE)
33:
34: if( BIS_UTILITIES_PUB.Value_Missing
35: (p_Dimension_Level_Rec.dimension_short_name)
36: = FND_API.G_TRUE
37: OR BIS_UTILITIES_PUB.Value_NULL(p_Dimension_Level_Rec.dimension_short_name)
38: = FND_API.G_TRUE)
39: OR( BIS_UTILITIES_PUB.Value_Missing
40: (p_Dimension_Level_Rec.dimension_level_short_name)
41: = FND_API.G_TRUE
35: (p_Dimension_Level_Rec.dimension_short_name)
36: = FND_API.G_TRUE
37: OR BIS_UTILITIES_PUB.Value_NULL(p_Dimension_Level_Rec.dimension_short_name)
38: = FND_API.G_TRUE)
39: OR( BIS_UTILITIES_PUB.Value_Missing
40: (p_Dimension_Level_Rec.dimension_level_short_name)
41: = FND_API.G_TRUE
42: OR BIS_UTILITIES_PUB.Value_NULL
43: (p_Dimension_Level_Rec.dimension_level_short_name)
38: = FND_API.G_TRUE)
39: OR( BIS_UTILITIES_PUB.Value_Missing
40: (p_Dimension_Level_Rec.dimension_level_short_name)
41: = FND_API.G_TRUE
42: OR BIS_UTILITIES_PUB.Value_NULL
43: (p_Dimension_Level_Rec.dimension_level_short_name)
44: = FND_API.G_TRUE) then
45:
46: --POPULATE THE ERROR TABLE
48: BIS_UTILITIES_PVT.Add_Error_Message
49: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_LEVEL_ID'
50: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
51: , p_error_proc_name => G_PKG_NAME||'.Validate_Record'
52: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
53: , p_error_table => x_error_tbl
54: , x_error_table => x_error_tbl
55:
56: );