APPS.BIS_MEASURE_SEC_VALIDATE_PVT dependencies on BIS_UTILITIES_PUB

Line 28: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

24: ( p_api_version IN NUMBER
25: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
26: , p_MEASURE_SEC_Rec IN BIS_MEASURE_SECURITY_PUB.MEASURE_Security_Rec_Type
27: , x_return_status OUT VARCHAR2
28: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
29: )
30: IS
31:
32: l_dummy number;

Line 42: if(BIS_UTILITIES_PUB.Value_Not_Missing(p_MEASURE_SEC_Rec.Target_Level_Id)

38:
39: begin
40:
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: if(BIS_UTILITIES_PUB.Value_Not_Missing(p_MEASURE_SEC_Rec.Target_Level_Id)
43: = FND_API.G_TRUE
44: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_MEASURE_SEC_Rec.Target_Level_Id)
45: = FND_API.G_TRUE) then
46: open chk_target_level;

Line 44: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_MEASURE_SEC_Rec.Target_Level_Id)

40:
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: if(BIS_UTILITIES_PUB.Value_Not_Missing(p_MEASURE_SEC_Rec.Target_Level_Id)
43: = FND_API.G_TRUE
44: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_MEASURE_SEC_Rec.Target_Level_Id)
45: = FND_API.G_TRUE) then
46: open chk_target_level;
47: fetch chk_target_level into l_dummy;
48: if (chk_target_level%NOTFOUND) then

Line 54: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

50: BIS_UTILITIES_PVT.Add_Error_Message
51: ( p_error_msg_name => 'BIS_INVALID_MSR_SECURITY_VALUE'
52: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
53: , p_error_proc_name => G_PKG_NAME||'.Validate_Target_Level_ID'
54: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
55: );
56: RAISE FND_API.G_EXC_ERROR;
57: end if;
58: close chk_target_level;

Line 87: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

83: ( p_api_version IN NUMBER
84: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
85: , p_MEASURE_SEC_Rec IN BIS_MEASURE_SECURITY_PUB.MEASURE_Security_Rec_Type
86: , x_return_status OUT VARCHAR2
87: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
88: )
89: IS
90: BEGIN
91: -- needs to be filled in

Line 121: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

117: ( p_api_version IN NUMBER
118: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
119: , p_MEASURE_SEC_Rec IN BIS_MEASURE_SECURITY_PUB.MEASURE_Security_Rec_Type
120: , x_return_status OUT VARCHAR2
121: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
122: )
123: IS
124: BEGIN
125: -- Do not need to do anything