APPS.BIS_COMPUTED_TARGET_PVT dependencies on BIS_UTILITIES_PUB

Line 11: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

7: PROCEDURE Retrieve_Computed_Targets
8: ( p_api_version IN number
9: , x_Computed_Target_Tbl out NOCOPY Computed_Target_Tbl_Type
10: , x_return_status OUT NOCOPY VARCHAR2
11: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
12: )
13: IS
14:
15: i NUMBER := 0;

Line 64: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

60: ( p_api_version IN NUMBER
61: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
62: , p_Computed_Target_ID IN NUMBER
63: , x_return_status OUT NOCOPY VARCHAR2
64: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
65: )
66: IS
67:
68: CURSOR val_cur is

Line 75: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

71: where function_id = p_Computed_Target_ID
72: and parameters like G_BISTAR_CLAUSE ;
73: --and TYPE = 'BISTAR';
74: l_dummy number;
75: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
76:
77: BEGIN
78: --added status
79: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 80: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_Computed_Target_ID)

76:
77: BEGIN
78: --added status
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_Computed_Target_ID)
81: =FND_API.G_TRUE
82: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Computed_Target_ID)
83: =FND_API.G_TRUE ) then
84: open val_cur;

Line 82: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Computed_Target_ID)

78: --added status
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_Computed_Target_ID)
81: =FND_API.G_TRUE
82: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Computed_Target_ID)
83: =FND_API.G_TRUE ) then
84: open val_cur;
85: fetch val_cur into l_dummy;
86: if (val_cur%NOTFOUND) then

Line 96: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

92: BIS_UTILITIES_PVT.Add_Error_Message
93: ( p_error_msg_name => 'BIS_INVALID_COMP_FUNCTION'
94: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
95: , p_error_proc_name => G_PKG_NAME||'.Validate_Computed_Target_Id'
96: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
97: , p_error_table => l_error_Tbl
98: , x_error_table => x_error_tbl
99: );
100: RAISE FND_API.G_EXC_ERROR;

Line 130: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

126: , p_Computed_Target_Short_Name IN VARCHAR2
127: , p_Computed_Target_Name IN VARCHAR2
128: , x_Computed_Target_ID OUT NOCOPY NUMBER
129: , x_return_status OUT NOCOPY VARCHAR2
130: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
131: )
132: IS
133:
134: BEGIN

Line 138: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Computed_Target_Short_Name)

134: BEGIN
135:
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:
138: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Computed_Target_Short_Name)
139: = FND_API.G_TRUE) then
140:
141: select function_id into x_Computed_Target_ID
142: from fnd_form_functions_vl

Line 147: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Computed_Target_Name)

143: where function_name = p_Computed_Target_Short_Name
144: and parameters like G_BISTAR_CLAUSE;
145: --and TYPE = 'BISTAR';
146:
147: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Computed_Target_Name)
148: = FND_API.G_TRUE) then
149:
150: select function_id into x_Computed_Target_ID
151: from fnd_form_functions_vl

Line 162: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

158: BIS_UTILITIES_PVT.Add_Error_Message
159: ( p_error_msg_name => 'BIS_INVALID_COMP_FUNC_VALUE'
160: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
161: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
162: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
163: );
164: RAISE FND_API.G_EXC_ERROR;
165: end if;
166: