49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
53: BIS_UTILITIES_PVT.Add_Error_Message
54: ( p_error_msg_id => SQLCODE
55: , p_error_description => SQLERRM
56: , p_error_proc_name => G_PKG_NAME||'.Create_Parameter_set'
57: , p_error_table => x_error_tbl
90: when FND_API.G_EXC_UNEXPECTED_ERROR then
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: when others then
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
94: BIS_UTILITIES_PVT.Add_Error_Message
95: ( p_error_msg_id => SQLCODE
96: , p_error_description => SQLERRM
97: , p_error_proc_name => G_PKG_NAME||'.Delete_Parameter_set'
98: , p_error_table => x_error_tbl
131: when FND_API.G_EXC_UNEXPECTED_ERROR then
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: when others then
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
135: BIS_UTILITIES_PVT.Add_Error_Message
136: ( p_error_msg_id => SQLCODE
137: , p_error_description => SQLERRM
138: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Parameter_set'
139: , p_error_table => x_error_tbl
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: BIS_UTILITIES_PVT.Add_Error_Message
175: ( p_error_msg_id => SQLCODE
176: , p_error_description => SQLERRM
177: , p_error_proc_name => G_PKG_NAME||'.Manage_Alert_Registrations'
178: , p_error_table => x_error_tbl
202: when FND_API.G_EXC_UNEXPECTED_ERROR then
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: when others then
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: BIS_UTILITIES_PVT.Add_Error_Message
207: ( p_error_msg_id => SQLCODE
208: , p_error_description => SQLERRM
209: , p_error_proc_name => G_PKG_NAME||'.Manage_Alert_Registrations'
210: , p_error_table => x_error_tbl
245: when FND_API.G_EXC_UNEXPECTED_ERROR then
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: when others then
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249: BIS_UTILITIES_PVT.Add_Error_Message
250: ( p_error_msg_id => SQLCODE
251: , p_error_description => SQLERRM
252: , p_error_proc_name => G_PKG_NAME||'.Parameter_set_exist'
253: , p_error_table => x_error_tbl