1: PACKAGE BODY BSC_CALENDAR_WRAPPER AS
2: /* $Header: BSCWCALB.pls 120.1 2005/11/07 03:37:14 appldev noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
17: REM | 07-JUL-2005 Aditya Rao added Locking APIs |
18: REM +=======================================================================+
19: */
20:
21: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_CALENDAR_WRAPPER';
22:
23: PROCEDURE Create_Calendar_UI
24: ( p_Api_Version IN NUMBER
25: , p_Commit IN VARCHAR2
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: WHEN NO_DATA_FOUND THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: IF (x_msg_data IS NOT NULL) THEN
109: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Create_Calendar_UI ';
110: ELSE
111: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Create_Calendar_UI ';
112: END IF;
113: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: IF (x_msg_data IS NOT NULL) THEN
109: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Create_Calendar_UI ';
110: ELSE
111: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Create_Calendar_UI ';
112: END IF;
113: WHEN OTHERS THEN
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: IF (x_msg_data IS NOT NULL) THEN
112: END IF;
113: WHEN OTHERS THEN
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: IF (x_msg_data IS NOT NULL) THEN
116: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Create_Calendar_UI ';
117: ELSE
118: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Create_Calendar_UI ';
119: END IF;
120:
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: IF (x_msg_data IS NOT NULL) THEN
116: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Create_Calendar_UI ';
117: ELSE
118: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Create_Calendar_UI ';
119: END IF;
120:
121: END Create_Calendar_UI;
122: /*******************************************************************************/
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: WHEN NO_DATA_FOUND THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF (x_msg_data IS NOT NULL) THEN
224: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';
225: ELSE
226: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';
227: END IF;
228: WHEN OTHERS THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF (x_msg_data IS NOT NULL) THEN
224: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';
225: ELSE
226: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';
227: END IF;
228: WHEN OTHERS THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: IF (x_msg_data IS NOT NULL) THEN
227: END IF;
228: WHEN OTHERS THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: IF (x_msg_data IS NOT NULL) THEN
231: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';
232: ELSE
233: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';
234: END IF;
235:
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: IF (x_msg_data IS NOT NULL) THEN
231: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';
232: ELSE
233: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';
234: END IF;
235:
236: END Update_Calendar_UI;
237:
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: WHEN NO_DATA_FOUND THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: IF (x_msg_data IS NOT NULL) THEN
299: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';
300: ELSE
301: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';
302: END IF;
303: WHEN OTHERS THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: IF (x_msg_data IS NOT NULL) THEN
299: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';
300: ELSE
301: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';
302: END IF;
303: WHEN OTHERS THEN
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: IF (x_msg_data IS NOT NULL) THEN
302: END IF;
303: WHEN OTHERS THEN
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: IF (x_msg_data IS NOT NULL) THEN
306: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';
307: ELSE
308: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';
309: END IF;
310:
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: IF (x_msg_data IS NOT NULL) THEN
306: x_msg_data := x_msg_data||' -> BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';
307: ELSE
308: x_msg_data := SQLERRM||' at BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';
309: END IF;
310:
311: END Delete_Calendar_UI;
312:
329: RETURN FND_API.G_FALSE;
330: END Is_Dbi_Calendar_Enabled;
331:
332:
333: END BSC_CALENDAR_WRAPPER;