eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_CALENDAR_PVT dependencies on BSC_CALENDAR_PVT

Line 1: PACKAGE BODY BSC_CALENDAR_PVT AS

1: PACKAGE BODY BSC_CALENDAR_PVT AS
2: /* $Header: BSCVCALB.pls 120.2 2005/11/30 02:47:25 kyadamak noship $ */
3: /*
4: REM +==================================================================================+
5: REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_CALENDAR_PVT';

16: REM | 29-NOV-2005 kyadamak Added API Update_PeriodNames_In_Calendar for Enh#4711274 |
17: REM +==================================================================================+
18: */
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_CALENDAR_PVT';
21:
22: PROCEDURE Create_Calendar
23: ( p_Api_Version IN NUMBER
24: , p_Commit IN VARCHAR2

Line 115: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Create_Calendar ';

111: WHEN NO_DATA_FOUND THEN
112: ROLLBACK TO CreateCalendarSP;
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: IF (x_msg_data IS NOT NULL) THEN
115: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Create_Calendar ';
116: ELSE
117: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Create_Calendar ';
118: END IF;
119: WHEN OTHERS THEN

Line 117: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Create_Calendar ';

113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: IF (x_msg_data IS NOT NULL) THEN
115: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Create_Calendar ';
116: ELSE
117: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Create_Calendar ';
118: END IF;
119: WHEN OTHERS THEN
120: ROLLBACK TO CreateCalendarSP;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 123: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Create_Calendar ';

119: WHEN OTHERS THEN
120: ROLLBACK TO CreateCalendarSP;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122: IF (x_msg_data IS NOT NULL) THEN
123: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Create_Calendar ';
124: ELSE
125: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Create_Calendar ';
126: END IF;
127: END Create_Calendar;

Line 125: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Create_Calendar ';

121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122: IF (x_msg_data IS NOT NULL) THEN
123: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Create_Calendar ';
124: ELSE
125: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Create_Calendar ';
126: END IF;
127: END Create_Calendar;
128:
129: /****************************************************************************************/

Line 184: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Calendar ';

180: WHEN NO_DATA_FOUND THEN
181: ROLLBACK TO UpdateCalendarSP;
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: IF (x_msg_data IS NOT NULL) THEN
184: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Calendar ';
185: ELSE
186: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';
187: END IF;
188: WHEN OTHERS THEN

Line 186: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';

182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: IF (x_msg_data IS NOT NULL) THEN
184: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Calendar ';
185: ELSE
186: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';
187: END IF;
188: WHEN OTHERS THEN
189: ROLLBACK TO UpdateCalendarSP;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 192: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Calendar ';

188: WHEN OTHERS THEN
189: ROLLBACK TO UpdateCalendarSP;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: IF (x_msg_data IS NOT NULL) THEN
192: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Calendar ';
193: ELSE
194: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';
195: END IF;
196: END Update_Calendar;

Line 194: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';

190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: IF (x_msg_data IS NOT NULL) THEN
192: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Calendar ';
193: ELSE
194: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';
195: END IF;
196: END Update_Calendar;
197:
198: PROCEDURE Delete_Calendar

Line 261: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Delete_Calendar ';

257: WHEN NO_DATA_FOUND THEN
258: ROLLBACK TO DeleteCalendarSP;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: IF (x_msg_data IS NOT NULL) THEN
261: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Delete_Calendar ';
262: ELSE
263: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';
264: END IF;
265: WHEN OTHERS THEN

Line 263: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';

259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: IF (x_msg_data IS NOT NULL) THEN
261: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Delete_Calendar ';
262: ELSE
263: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';
264: END IF;
265: WHEN OTHERS THEN
266: ROLLBACK TO DeleteCalendarSP;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 269: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Delete_Calendar ';

265: WHEN OTHERS THEN
266: ROLLBACK TO DeleteCalendarSP;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: IF (x_msg_data IS NOT NULL) THEN
269: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Delete_Calendar ';
270: ELSE
271: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';
272: END IF;
273: END Delete_Calendar;

Line 271: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';

267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: IF (x_msg_data IS NOT NULL) THEN
269: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Delete_Calendar ';
270: ELSE
271: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';
272: END IF;
273: END Delete_Calendar;
274:
275: PROCEDURE Update_Fiscal_Change

Line 301: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Fiscal_Change ';

297: WHEN NO_DATA_FOUND THEN
298: ROLLBACK TO DeleteCalendarSP;
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: IF (x_msg_data IS NOT NULL) THEN
301: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Fiscal_Change ';
302: ELSE
303: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';
304: END IF;
305: WHEN OTHERS THEN

Line 303: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';

299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: IF (x_msg_data IS NOT NULL) THEN
301: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Fiscal_Change ';
302: ELSE
303: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';
304: END IF;
305: WHEN OTHERS THEN
306: ROLLBACK TO DeleteCalendarSP;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 309: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Fiscal_Change ';

305: WHEN OTHERS THEN
306: ROLLBACK TO DeleteCalendarSP;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: IF (x_msg_data IS NOT NULL) THEN
309: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Fiscal_Change ';
310: ELSE
311: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';
312: END IF;
313: END Update_Fiscal_Change;

Line 311: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';

307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: IF (x_msg_data IS NOT NULL) THEN
309: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Fiscal_Change ';
310: ELSE
311: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';
312: END IF;
313: END Update_Fiscal_Change;
314:
315: PROCEDURE Update_PeriodNames_In_Calendar

Line 363: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';

359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: IF (x_msg_data IS NOT NULL) THEN
363: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
364: ELSE
365: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
366: END IF;
367: WHEN OTHERS THEN

Line 365: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';

361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: IF (x_msg_data IS NOT NULL) THEN
363: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
364: ELSE
365: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
366: END IF;
367: WHEN OTHERS THEN
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: IF (x_msg_data IS NOT NULL) THEN

Line 370: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';

366: END IF;
367: WHEN OTHERS THEN
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: IF (x_msg_data IS NOT NULL) THEN
370: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
371: ELSE
372: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
373: END IF;
374:

Line 372: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';

368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: IF (x_msg_data IS NOT NULL) THEN
370: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
371: ELSE
372: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
373: END IF;
374:
375: END Update_PeriodNames_In_Calendar;
376:

Line 378: END BSC_CALENDAR_PVT;

374:
375: END Update_PeriodNames_In_Calendar;
376:
377:
378: END BSC_CALENDAR_PVT;