46: when FND_API.G_EXC_UNEXPECTED_ERROR then
47: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
48: when others then
49: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
50: BIS_UTILITIES_PVT.Add_Error_Message
51: ( p_error_msg_id => SQLCODE
52: , p_error_description => SQLERRM
53: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Business_Plans'
54: , p_error_table => x_error_tbl
76: , x_error_Tbl => x_error_tbl
77: );
78:
79: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
80: BIS_UTILITIES_PVT.Add_Error_Message
81: ( p_error_msg_name => 'BIS_INVALID_PLAN_ID'
82: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
83: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Business_Plan'
84: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
103: when FND_API.G_EXC_UNEXPECTED_ERROR then
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105: when others then
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
107: BIS_UTILITIES_PVT.Add_Error_Message
108: ( p_error_msg_id => SQLCODE
109: , p_error_description => SQLERRM
110: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Business_Plan'
111: , p_error_table => x_error_tbl
135: , x_error_Tbl => x_error_tbl
136: );
137:
138: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
139: BIS_UTILITIES_PVT.Add_Error_Message
140: ( p_error_msg_name => 'BIS_INVALID_PLAN_ID'
141: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
142: , p_error_proc_name => G_PKG_NAME||'.Translate_Business_Plan'
143: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
163: when FND_API.G_EXC_UNEXPECTED_ERROR then
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
165: when others then
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
167: BIS_UTILITIES_PVT.Add_Error_Message
168: ( p_error_msg_id => SQLCODE
169: , p_error_description => SQLERRM
170: , p_error_proc_name => G_PKG_NAME||'.Translate_Business_Plan'
171: , p_error_table => x_error_tbl
199: , x_error_Tbl => x_error_tbl
200: );
201:
202: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
203: BIS_UTILITIES_PVT.Add_Error_Message
204: ( p_error_msg_name => 'BIS_INVALID_PLAN_ID'
205: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
206: , p_error_proc_name => G_PKG_NAME||'.Load_Business_Plan'
207: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
233: );
234:
235: WHEN OTHERS THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: BIS_UTILITIES_PVT.Add_Error_Message
238: ( p_error_msg_id => SQLCODE
239: , p_error_description => SQLERRM
240: , p_error_proc_name => G_PKG_NAME||'.Update_Business_Plan'
241: );
249: when FND_API.G_EXC_UNEXPECTED_ERROR then
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: when others then
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253: BIS_UTILITIES_PVT.Add_Error_Message
254: ( p_error_msg_id => SQLCODE
255: , p_error_description => SQLERRM
256: , p_error_proc_name => G_PKG_NAME||'.Load_Business_Plan'
257: , p_error_table => x_error_tbl