APPS.BIS_BUCKET_PUB dependencies on FND_API

Line 25: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

21: );
22:
23: EXCEPTION
24: WHEN OTHERS THEN
25: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
26:
27: l_error_tbl := x_error_tbl;
28: BIS_UTILITIES_PVT.Add_Error_Message(
29: p_error_msg_id => SQLCODE

Line 60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

56: );
57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
61:
62: l_error_tbl := x_error_tbl;
63: BIS_UTILITIES_PVT.Add_Error_Message(
64: p_error_msg_id => SQLCODE

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

93: );
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98:
99: l_error_tbl := x_error_tbl;
100: BIS_UTILITIES_PVT.Add_Error_Message(
101: p_error_msg_id => SQLCODE

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

130: );
131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
135:
136: l_error_tbl := x_error_tbl;
137: BIS_UTILITIES_PVT.Add_Error_Message(
138: p_error_msg_id => SQLCODE

Line 163: x_return_status := FND_API.G_RET_STS_SUCCESS;

159: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
160: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
161: BEGIN
162:
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164: l_bis_bucket_rec := p_bis_bucket_rec;
165:
166: IF (c_bkt_set%ISOPEN) THEN
167: CLOSE c_bkt_set;

Line 189: WHEN FND_API.G_EXC_ERROR THEN

185: );
186: END IF;
187:
188: EXCEPTION
189: WHEN FND_API.G_EXC_ERROR THEN
190: IF (c_bkt_set%ISOPEN) THEN
191: CLOSE c_bkt_set;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 193: x_return_status := FND_API.G_RET_STS_ERROR ;

189: WHEN FND_API.G_EXC_ERROR THEN
190: IF (c_bkt_set%ISOPEN) THEN
191: CLOSE c_bkt_set;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: RAISE FND_API.G_EXC_ERROR;
195:
196: WHEN OTHERS THEN
197: IF (c_bkt_set%ISOPEN) THEN

Line 194: RAISE FND_API.G_EXC_ERROR;

190: IF (c_bkt_set%ISOPEN) THEN
191: CLOSE c_bkt_set;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: RAISE FND_API.G_EXC_ERROR;
195:
196: WHEN OTHERS THEN
197: IF (c_bkt_set%ISOPEN) THEN
198: CLOSE c_bkt_set;

Line 200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

196: WHEN OTHERS THEN
197: IF (c_bkt_set%ISOPEN) THEN
198: CLOSE c_bkt_set;
199: END IF;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201: l_error_tbl := x_error_tbl;
202: BIS_UTILITIES_PVT.Add_Error_Message(
203: p_error_msg_id => SQLCODE
204: ,p_error_description => SQLERRM

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

205: ,p_error_proc_name => G_PKG_NAME||'.LOAD_BIS_BUCKET'
206: ,p_error_table => l_error_tbl
207: ,x_error_table => x_error_tbl
208: );
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END LOAD_BIS_BUCKET;
211: --=============================================================================
212:
213: