1: PACKAGE BODY BIS_CUSTOMIZATION_PVT AS
2: /* $Header: BISVCTMB.pls 120.1 2006/02/14 13:21:04 hengliu noship $ */
3: --
4: /*
5: REM +=======================================================================+
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
83: WHEN NO_DATA_FOUND THEN
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85: IF (x_msg_data IS NOT NULL) THEN
86: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items ';
87: ELSE
88: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items ';
89: END IF;
90: WHEN OTHERS THEN
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85: IF (x_msg_data IS NOT NULL) THEN
86: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items ';
87: ELSE
88: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items ';
89: END IF;
90: WHEN OTHERS THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: IF (x_msg_data IS NOT NULL) THEN
89: END IF;
90: WHEN OTHERS THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: IF (x_msg_data IS NOT NULL) THEN
93: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items ';
94: ELSE
95: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items ';
96: END IF;
97:
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: IF (x_msg_data IS NOT NULL) THEN
93: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items ';
94: ELSE
95: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items ';
96: END IF;
97:
98:
99: END Create_Custom_Region_Items;
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: WHEN NO_DATA_FOUND THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: IF (x_msg_data IS NOT NULL) THEN
160: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Update_Custom_Region_items ';
161: ELSE
162: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Update_Custom_Region_items ';
163: END IF;
164: WHEN OTHERS THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: IF (x_msg_data IS NOT NULL) THEN
160: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Update_Custom_Region_items ';
161: ELSE
162: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Update_Custom_Region_items ';
163: END IF;
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: IF (x_msg_data IS NOT NULL) THEN
163: END IF;
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: IF (x_msg_data IS NOT NULL) THEN
167: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Update_Custom_Region_items ';
168: ELSE
169: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Update_Custom_Region_items ';
170: END IF;
171:
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: IF (x_msg_data IS NOT NULL) THEN
167: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Update_Custom_Region_items ';
168: ELSE
169: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Update_Custom_Region_items ';
170: END IF;
171:
172:
173: END Update_Custom_Region_Items;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: WHEN NO_DATA_FOUND THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF (x_msg_data IS NOT NULL) THEN
223: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_items ';
224: ELSE
225: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_items ';
226: END IF;
227: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF (x_msg_data IS NOT NULL) THEN
223: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_items ';
224: ELSE
225: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_items ';
226: END IF;
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF (x_msg_data IS NOT NULL) THEN
226: END IF;
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF (x_msg_data IS NOT NULL) THEN
230: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_items ';
231: ELSE
232: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_items ';
233: END IF;
234:
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF (x_msg_data IS NOT NULL) THEN
230: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_items ';
231: ELSE
232: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_items ';
233: END IF;
234:
235: END Delete_Custom_Region_Items;
236:
473: END IF;
474:
475: END Update_Customizations;
476:
477: END BIS_CUSTOMIZATION_PVT;