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_PUB dependencies on BSC_CALENDAR_PUB

Line 1: PACKAGE BODY BSC_CALENDAR_PUB AS

1: PACKAGE BODY BSC_CALENDAR_PUB AS
2: /* $Header: BSCPCALB.pls 120.4 2007/12/18 06:49:19 lbodired ship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |

Line 21: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_CALENDAR_PUB';

17: REM | 06-JUL-07 psomesul Bug#6168487 - CHANGING CALENDAR DEF WHICH IS IN PRODUCTION IS NOT TRIGGERING TO USER |
18: REM +=======================================================================+
19: */
20:
21: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_CALENDAR_PUB';
22:
23: FISCAL_YEAR_CHANGE NUMBER := 0;
24: --The following three APIs are used to call BIA populate canlednars
25: --in different phases

Line 30: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

26: --For every calendar we create we create dimension also
27: PROCEDURE Create_Calendar_Dimension
28: ( p_Api_Version IN NUMBER
29: , p_Commit IN VARCHAR2
30: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
31: , x_Return_Status OUT NOCOPY VARCHAR2
32: , x_Msg_Count OUT NOCOPY NUMBER
33: , x_Msg_Data OUT NOCOPY VARCHAR2
34: );

Line 39: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

35:
36: PROCEDURE Update_Calendar_Dimension
37: ( p_Api_Version IN NUMBER
38: , p_Commit IN VARCHAR2
39: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
40: , x_Return_Status OUT NOCOPY VARCHAR2
41: , x_Msg_Count OUT NOCOPY NUMBER
42: , x_Msg_Data OUT NOCOPY VARCHAR2
43: );

Line 60: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

56:
57: PROCEDURE Create_Calendar
58: ( p_Api_Version IN NUMBER
59: , p_Commit IN VARCHAR2
60: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
61: , x_Return_Status OUT NOCOPY VARCHAR2
62: , x_Msg_Count OUT NOCOPY NUMBER
63: , x_Msg_Data OUT NOCOPY VARCHAR2
64: )IS

Line 65: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;

61: , x_Return_Status OUT NOCOPY VARCHAR2
62: , x_Msg_Count OUT NOCOPY NUMBER
63: , x_Msg_Data OUT NOCOPY VARCHAR2
64: )IS
65: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;
66: BEGIN
67: SAVEPOINT CreateCalendarPubSP;
68: FND_MSG_PUB.Initialize;
69: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 71: BSC_CALENDAR_PUB.Validate_Calendar_Action

67: SAVEPOINT CreateCalendarPubSP;
68: FND_MSG_PUB.Initialize;
69: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
70:
71: BSC_CALENDAR_PUB.Validate_Calendar_Action
72: ( p_Api_Version => p_Api_Version
73: , p_Commit => p_Commit
74: , p_Calendar_Record => p_Calendar_Record
75: , p_Action => BSC_PERIODS_UTILITY_PKG.C_CREATE

Line 84: BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal

80: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84: BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal
85: ( p_Api_Version => p_Api_Version
86: , p_Commit => p_Commit
87: , p_Calendar_Record => p_Calendar_Record
88: , x_Calendar_Record => l_Calendar_Record

Line 109: BSC_CALENDAR_PUB.Create_Calendar_Dimension

105: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: BSC_CALENDAR_PUB.Create_Calendar_Dimension
110: ( p_Api_Version => p_Api_Version
111: , p_Commit => p_Commit
112: , p_Calendar_Record => l_Calendar_Record
113: , x_Return_Status => x_Return_Status

Line 121: BSC_CALENDAR_PUB.Create_Calendar_Post_Action

117: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: BSC_CALENDAR_PUB.Create_Calendar_Post_Action
122: ( p_Api_Version => p_Api_Version
123: , p_Commit => p_Commit
124: , p_Calendar_Record => l_Calendar_Record
125: , x_Return_Status => x_Return_Status

Line 162: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar ';

158: WHEN NO_DATA_FOUND THEN
159: ROLLBACK TO CreateCalendarPubSP;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF (x_msg_data IS NOT NULL) THEN
162: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar ';
163: ELSE
164: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar ';
165: END IF;
166: WHEN OTHERS THEN

Line 164: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar ';

160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF (x_msg_data IS NOT NULL) THEN
162: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar ';
163: ELSE
164: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar ';
165: END IF;
166: WHEN OTHERS THEN
167: ROLLBACK TO CreateCalendarPubSP;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 170: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar ';

166: WHEN OTHERS THEN
167: ROLLBACK TO CreateCalendarPubSP;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: IF (x_msg_data IS NOT NULL) THEN
170: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar ';
171: ELSE
172: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar ';
173: END IF;
174: END Create_Calendar;

Line 172: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar ';

168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: IF (x_msg_data IS NOT NULL) THEN
170: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar ';
171: ELSE
172: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar ';
173: END IF;
174: END Create_Calendar;
175:
176: /*****************************************************************************************/

Line 181: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

177:
178: PROCEDURE Update_Calendar
179: ( p_Api_Version IN NUMBER
180: , p_Commit IN VARCHAR2
181: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
182: , x_Return_Status OUT NOCOPY VARCHAR2
183: , x_Msg_Count OUT NOCOPY NUMBER
184: , x_Msg_Data OUT NOCOPY VARCHAR2
185: )IS

Line 186: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;

182: , x_Return_Status OUT NOCOPY VARCHAR2
183: , x_Msg_Count OUT NOCOPY NUMBER
184: , x_Msg_Data OUT NOCOPY VARCHAR2
185: )IS
186: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;
187: l_Fiscal_Year BSC_SYS_CALENDARS_B.FISCAL_YEAR%TYPE;
188: l_Start_Month BSC_SYS_CALENDARS_B.START_MONTH%TYPE;
189: l_Start_Day BSC_SYS_CALENDARS_B.START_DAY%TYPE;
190: l_Calendar_Old_Name BSC_SYS_CALENDARS_TL.NAME%TYPE;

Line 214: BSC_CALENDAR_PUB.Validate_Calendar_Action

210: OR (l_Start_Day <> p_Calendar_Record.Start_Day)) THEN
211: Change_Fiscal_Year();
212: END IF;
213:
214: BSC_CALENDAR_PUB.Validate_Calendar_Action
215: ( p_Api_Version => p_Api_Version
216: , p_Commit => p_Commit
217: , p_Calendar_Record => p_Calendar_Record
218: , p_Action => BSC_PERIODS_UTILITY_PKG.C_UPDATE

Line 227: BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec

223: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec
228: ( p_Api_Version => p_Api_Version
229: , p_Commit => p_Commit
230: , p_Calendar_Record => p_Calendar_Record
231: , x_Calendar_Record => l_Calendar_Record

Line 252: BSC_CALENDAR_PUB.Update_Calendar_Dimension

248: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252: BSC_CALENDAR_PUB.Update_Calendar_Dimension
253: ( p_Api_Version => p_Api_Version
254: , p_Commit => p_Commit
255: , p_Calendar_Record => l_Calendar_Record
256: , x_Return_Status => x_Return_Status

Line 276: BSC_CALENDAR_PUB.Update_Calendar_Post_Action

272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: END IF;
275:
276: BSC_CALENDAR_PUB.Update_Calendar_Post_Action
277: ( p_Api_Version => p_Api_Version
278: , p_Commit => p_Commit
279: , p_Calendar_Record => l_Calendar_Record
280: , x_Return_Status => x_Return_Status

Line 317: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar ';

313: WHEN NO_DATA_FOUND THEN
314: ROLLBACK TO UpdateCalendarPubSP;
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: IF (x_msg_data IS NOT NULL) THEN
317: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar ';
318: ELSE
319: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar ';
320: END IF;
321: WHEN OTHERS THEN

Line 319: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar ';

315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: IF (x_msg_data IS NOT NULL) THEN
317: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar ';
318: ELSE
319: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar ';
320: END IF;
321: WHEN OTHERS THEN
322: ROLLBACK TO UpdateCalendarPubSP;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 325: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar ';

321: WHEN OTHERS THEN
322: ROLLBACK TO UpdateCalendarPubSP;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: IF (x_msg_data IS NOT NULL) THEN
325: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar ';
326: ELSE
327: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar ';
328: END IF;
329: END Update_Calendar;

Line 327: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar ';

323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: IF (x_msg_data IS NOT NULL) THEN
325: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar ';
326: ELSE
327: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar ';
328: END IF;
329: END Update_Calendar;
330:
331:

Line 337: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

333: /****************************************************************************************/
334: PROCEDURE Delete_Calendar
335: ( p_Api_Version IN NUMBER
336: , p_Commit IN VARCHAR2
337: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
338: , x_Return_Status OUT NOCOPY VARCHAR2
339: , x_Msg_Count OUT NOCOPY NUMBER
340: , x_Msg_Data OUT NOCOPY VARCHAR2
341: )IS

Line 371: BSC_CALENDAR_PUB.Validate_Calendar_Action

367: SAVEPOINT DeleteCalendarPubSP;
368: FND_MSG_PUB.Initialize;
369: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
370:
371: BSC_CALENDAR_PUB.Validate_Calendar_Action
372: ( p_Api_Version => p_Api_Version
373: , p_Commit => p_Commit
374: , p_Calendar_Record => p_Calendar_Record
375: , p_Action => BSC_PERIODS_UTILITY_PKG.C_DELETE

Line 496: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar ';

492: WHEN NO_DATA_FOUND THEN
493: ROLLBACK TO DeleteCalendarPubSP;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF (x_msg_data IS NOT NULL) THEN
496: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar ';
497: ELSE
498: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar ';
499: END IF;
500: WHEN OTHERS THEN

Line 498: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar ';

494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF (x_msg_data IS NOT NULL) THEN
496: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar ';
497: ELSE
498: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar ';
499: END IF;
500: WHEN OTHERS THEN
501: ROLLBACK TO DeleteCalendarPubSP;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 504: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar ';

500: WHEN OTHERS THEN
501: ROLLBACK TO DeleteCalendarPubSP;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: IF (x_msg_data IS NOT NULL) THEN
504: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar ';
505: ELSE
506: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar ';
507: END IF;
508: END Delete_Calendar;

Line 506: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar ';

502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: IF (x_msg_data IS NOT NULL) THEN
504: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar ';
505: ELSE
506: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar ';
507: END IF;
508: END Delete_Calendar;
509:
510: /***********************************************************************************/

Line 515: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

511:
512: PROCEDURE Validate_Calendar_Action
513: ( p_Api_Version IN NUMBER
514: , p_Commit IN VARCHAR2
515: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
516: , p_Action IN VARCHAR2
517: , x_Return_Status OUT NOCOPY VARCHAR2
518: , x_Msg_Count OUT NOCOPY NUMBER
519: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 667: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Validate_Calendar_Action ';

663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: WHEN NO_DATA_FOUND THEN
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: IF (x_msg_data IS NOT NULL) THEN
667: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Validate_Calendar_Action ';
668: ELSE
669: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Validate_Calendar_Action ';
670: END IF;
671: WHEN OTHERS THEN

Line 669: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Validate_Calendar_Action ';

665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: IF (x_msg_data IS NOT NULL) THEN
667: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Validate_Calendar_Action ';
668: ELSE
669: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Validate_Calendar_Action ';
670: END IF;
671: WHEN OTHERS THEN
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: IF (x_msg_data IS NOT NULL) THEN

Line 674: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Validate_Calendar_Action ';

670: END IF;
671: WHEN OTHERS THEN
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: IF (x_msg_data IS NOT NULL) THEN
674: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Validate_Calendar_Action ';
675: ELSE
676: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Validate_Calendar_Action ';
677: END IF;
678: END Validate_Calendar_Action;

Line 676: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Validate_Calendar_Action ';

672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: IF (x_msg_data IS NOT NULL) THEN
674: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Validate_Calendar_Action ';
675: ELSE
676: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Validate_Calendar_Action ';
677: END IF;
678: END Validate_Calendar_Action;
679:
680: /*******************************************************************************************/

Line 685: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

681:
682: PROCEDURE Retrieve_And_Populate_Cal_Rec
683: ( p_Api_Version IN NUMBER
684: , p_Commit IN VARCHAR2
685: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
686: , x_Calendar_Record OUT NOCOPY BSC_CALENDAR_PUB.Calendar_Type_Record
687: , x_Return_Status OUT NOCOPY VARCHAR2
688: , x_Msg_Count OUT NOCOPY NUMBER
689: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 686: , x_Calendar_Record OUT NOCOPY BSC_CALENDAR_PUB.Calendar_Type_Record

682: PROCEDURE Retrieve_And_Populate_Cal_Rec
683: ( p_Api_Version IN NUMBER
684: , p_Commit IN VARCHAR2
685: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
686: , x_Calendar_Record OUT NOCOPY BSC_CALENDAR_PUB.Calendar_Type_Record
687: , x_Return_Status OUT NOCOPY VARCHAR2
688: , x_Msg_Count OUT NOCOPY NUMBER
689: , x_Msg_Data OUT NOCOPY VARCHAR2
690: )IS

Line 785: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec';

781: EXCEPTION
782: WHEN NO_DATA_FOUND THEN
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF (x_msg_data IS NOT NULL) THEN
785: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec';
786: ELSE
787: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';
788: END IF;
789: WHEN OTHERS THEN

Line 787: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';

783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF (x_msg_data IS NOT NULL) THEN
785: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec';
786: ELSE
787: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';
788: END IF;
789: WHEN OTHERS THEN
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF (x_msg_data IS NOT NULL) THEN

Line 792: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';

788: END IF;
789: WHEN OTHERS THEN
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF (x_msg_data IS NOT NULL) THEN
792: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';
793: ELSE
794: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';
795: END IF;
796: END Retrieve_And_Populate_Cal_Rec;

Line 794: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';

790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF (x_msg_data IS NOT NULL) THEN
792: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';
793: ELSE
794: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Retrieve_And_Populate_Cal_Rec ';
795: END IF;
796: END Retrieve_And_Populate_Cal_Rec;
797: /*************************************************************************************/
798:

Line 802: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

798:
799: PROCEDURE Create_Calendar_Post_Action
800: ( p_Api_Version IN NUMBER
801: , p_Commit IN VARCHAR2
802: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
803: , x_Return_Status OUT NOCOPY VARCHAR2
804: , x_Msg_Count OUT NOCOPY NUMBER
805: , x_Msg_Data OUT NOCOPY VARCHAR2
806: )IS

Line 813: BSC_CALENDAR_PUB.Create_Periodicities_Calendar

809: SAVEPOINT CreateCalendarPostActionSP;
810: FND_MSG_PUB.Initialize;
811: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
812:
813: BSC_CALENDAR_PUB.Create_Periodicities_Calendar
814: ( p_Api_Version => p_Api_Version
815: , p_Commit => p_Commit
816: , p_Calendar_Record => p_Calendar_Record
817: , x_Return_Status => x_Return_Status

Line 861: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Post_Action';

857: WHEN NO_DATA_FOUND THEN
858: ROLLBACK TO CreateCalendarPostActionSP;
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
860: IF (x_msg_data IS NOT NULL) THEN
861: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Post_Action';
862: ELSE
863: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';
864: END IF;
865: WHEN OTHERS THEN

Line 863: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';

859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
860: IF (x_msg_data IS NOT NULL) THEN
861: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Post_Action';
862: ELSE
863: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';
864: END IF;
865: WHEN OTHERS THEN
866: ROLLBACK TO CreateCalendarPostActionSP;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 869: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';

865: WHEN OTHERS THEN
866: ROLLBACK TO CreateCalendarPostActionSP;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868: IF (x_msg_data IS NOT NULL) THEN
869: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';
870: ELSE
871: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';
872: END IF;
873:

Line 871: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';

867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868: IF (x_msg_data IS NOT NULL) THEN
869: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';
870: ELSE
871: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Post_Action ';
872: END IF;
873:
874: END Create_Calendar_Post_Action;
875:

Line 881: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

877:
878: PROCEDURE Fill_Default_Values_Create_Cal
879: ( p_Api_Version IN NUMBER
880: , p_Commit IN VARCHAR2
881: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
882: , x_Calendar_Record OUT NOCOPY BSC_CALENDAR_PUB.Calendar_Type_Record
883: , x_Return_Status OUT NOCOPY VARCHAR2
884: , x_Msg_Count OUT NOCOPY NUMBER
885: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 882: , x_Calendar_Record OUT NOCOPY BSC_CALENDAR_PUB.Calendar_Type_Record

878: PROCEDURE Fill_Default_Values_Create_Cal
879: ( p_Api_Version IN NUMBER
880: , p_Commit IN VARCHAR2
881: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
882: , x_Calendar_Record OUT NOCOPY BSC_CALENDAR_PUB.Calendar_Type_Record
883: , x_Return_Status OUT NOCOPY VARCHAR2
884: , x_Msg_Count OUT NOCOPY NUMBER
885: , x_Msg_Data OUT NOCOPY VARCHAR2
886: )IS

Line 991: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal';

987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: WHEN NO_DATA_FOUND THEN
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF (x_msg_data IS NOT NULL) THEN
991: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal';
992: ELSE
993: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal ';
994: END IF;
995: WHEN OTHERS THEN

Line 993: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal ';

989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF (x_msg_data IS NOT NULL) THEN
991: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal';
992: ELSE
993: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal ';
994: END IF;
995: WHEN OTHERS THEN
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF (x_msg_data IS NOT NULL) THEN

Line 998: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal ';

994: END IF;
995: WHEN OTHERS THEN
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF (x_msg_data IS NOT NULL) THEN
998: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal ';
999: ELSE
1000: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal';
1001: END IF;
1002: END Fill_Default_Values_Create_Cal;

Line 1000: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal';

996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF (x_msg_data IS NOT NULL) THEN
998: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal ';
999: ELSE
1000: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Fill_Default_Values_Create_Cal';
1001: END IF;
1002: END Fill_Default_Values_Create_Cal;
1003:
1004: /*****************************************************************************************/

Line 1009: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

1005:
1006: PROCEDURE Update_Calendar_Post_Action
1007: ( p_Api_Version IN NUMBER
1008: , p_Commit IN VARCHAR2
1009: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
1010: , x_Return_Status OUT NOCOPY VARCHAR2
1011: , x_Msg_Count OUT NOCOPY NUMBER
1012: , x_Msg_Data OUT NOCOPY VARCHAR2
1013: )IS

Line 1039: BSC_CALENDAR_PUB.Flag_Changes_For_Objectives

1035: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: END IF;
1038:
1039: BSC_CALENDAR_PUB.Flag_Changes_For_Objectives
1040: ( p_Api_Version => p_Api_Version
1041: , p_Commit => p_Commit
1042: , p_Calendar_Id => p_Calendar_Record.Calendar_Id
1043: , x_Return_Status => x_Return_Status

Line 1090: x_msg_data := x_msg_data ||'BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';

1086: WHEN NO_DATA_FOUND THEN
1087: ROLLBACK TO UpdateCalendarPostActionSP;
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1089: IF (x_msg_data IS NOT NULL) THEN
1090: x_msg_data := x_msg_data ||'BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';
1091: ELSE
1092: x_msg_data := SQLERRM || 'at BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';
1093: END IF;
1094: WHEN OTHERS THEN

Line 1092: x_msg_data := SQLERRM || 'at BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';

1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1089: IF (x_msg_data IS NOT NULL) THEN
1090: x_msg_data := x_msg_data ||'BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';
1091: ELSE
1092: x_msg_data := SQLERRM || 'at BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';
1093: END IF;
1094: WHEN OTHERS THEN
1095: ROLLBACK TO UpdateCalendarPostActionSP;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1098: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';

1094: WHEN OTHERS THEN
1095: ROLLBACK TO UpdateCalendarPostActionSP;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: IF (x_msg_data IS NOT NULL) THEN
1098: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';
1099: ELSE
1100: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';
1101: END IF;
1102: END Update_Calendar_Post_Action;

Line 1100: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';

1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: IF (x_msg_data IS NOT NULL) THEN
1098: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';
1099: ELSE
1100: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Post_Action ';
1101: END IF;
1102: END Update_Calendar_Post_Action;
1103:
1104: /*****************************************************************************************/

Line 1160: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';

1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: WHEN NO_DATA_FOUND THEN
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: IF (x_msg_data IS NOT NULL) THEN
1160: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';
1161: ELSE
1162: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';
1163: END IF;
1164: WHEN OTHERS THEN

Line 1162: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';

1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: IF (x_msg_data IS NOT NULL) THEN
1160: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';
1161: ELSE
1162: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';
1163: END IF;
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: IF (x_msg_data IS NOT NULL) THEN

Line 1167: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';

1163: END IF;
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: IF (x_msg_data IS NOT NULL) THEN
1167: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';
1168: ELSE
1169: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';
1170: END IF;
1171: END Flag_Changes_For_Objectives;

Line 1169: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';

1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: IF (x_msg_data IS NOT NULL) THEN
1167: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';
1168: ELSE
1169: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Flag_Changes_For_Objectives ';
1170: END IF;
1171: END Flag_Changes_For_Objectives;
1172: /*****************************************************************************************/
1173:

Line 1177: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

1173:
1174: PROCEDURE Create_Periodicities_Calendar
1175: ( p_Api_Version IN NUMBER
1176: , p_Commit IN VARCHAR2
1177: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
1178: , x_Return_Status OUT NOCOPY VARCHAR2
1179: , x_Msg_Count OUT NOCOPY NUMBER
1180: , x_Msg_Data OUT NOCOPY VARCHAR2
1181: )IS

Line 1182: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;

1178: , x_Return_Status OUT NOCOPY VARCHAR2
1179: , x_Msg_Count OUT NOCOPY NUMBER
1180: , x_Msg_Data OUT NOCOPY VARCHAR2
1181: )IS
1182: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;
1183: h_tmp_array BSC_UPDATE_UTIL.t_array_of_number;
1184: h_count NUMBER;
1185: h_new_per_id NUMBER;
1186: h_periodicity_type NUMBER;

Line 1329: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';

1325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1326: WHEN NO_DATA_FOUND THEN
1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328: IF (x_msg_data IS NOT NULL) THEN
1329: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';
1330: ELSE
1331: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';
1332: END IF;
1333: WHEN OTHERS THEN

Line 1331: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';

1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328: IF (x_msg_data IS NOT NULL) THEN
1329: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';
1330: ELSE
1331: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';
1332: END IF;
1333: WHEN OTHERS THEN
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF (x_msg_data IS NOT NULL) THEN

Line 1336: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';

1332: END IF;
1333: WHEN OTHERS THEN
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF (x_msg_data IS NOT NULL) THEN
1336: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';
1337: ELSE
1338: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';
1339: END IF;
1340: END Create_Periodicities_Calendar;

Line 1338: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';

1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF (x_msg_data IS NOT NULL) THEN
1336: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';
1337: ELSE
1338: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Periodicities_Calendar ';
1339: END IF;
1340: END Create_Periodicities_Calendar;
1341: /*********************************************************************************/
1342: PROCEDURE Create_Calendar_Dimension

Line 1345: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

1341: /*********************************************************************************/
1342: PROCEDURE Create_Calendar_Dimension
1343: ( p_Api_Version IN NUMBER
1344: , p_Commit IN VARCHAR2
1345: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
1346: , x_Return_Status OUT NOCOPY VARCHAR2
1347: , x_Msg_Count OUT NOCOPY NUMBER
1348: , x_Msg_Data OUT NOCOPY VARCHAR2
1349: )IS

Line 1404: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Dimension ';

1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: WHEN NO_DATA_FOUND THEN
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: IF (x_msg_data IS NOT NULL) THEN
1404: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Dimension ';
1405: ELSE
1406: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Dimension ';
1407: END IF;
1408: WHEN OTHERS THEN

Line 1406: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Dimension ';

1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: IF (x_msg_data IS NOT NULL) THEN
1404: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Dimension ';
1405: ELSE
1406: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Dimension ';
1407: END IF;
1408: WHEN OTHERS THEN
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: IF (x_msg_data IS NOT NULL) THEN

Line 1411: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Dimension ';

1407: END IF;
1408: WHEN OTHERS THEN
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: IF (x_msg_data IS NOT NULL) THEN
1411: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Dimension ';
1412: ELSE
1413: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Dimension ';
1414: END IF;
1415: END Create_Calendar_Dimension;

Line 1413: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Dimension ';

1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: IF (x_msg_data IS NOT NULL) THEN
1411: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Create_Calendar_Dimension ';
1412: ELSE
1413: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Create_Calendar_Dimension ';
1414: END IF;
1415: END Create_Calendar_Dimension;
1416: /*******************************************************************************/
1417: PROCEDURE Update_Calendar_Dimension

Line 1420: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record

1416: /*******************************************************************************/
1417: PROCEDURE Update_Calendar_Dimension
1418: ( p_Api_Version IN NUMBER
1419: , p_Commit IN VARCHAR2
1420: , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
1421: , x_Return_Status OUT NOCOPY VARCHAR2
1422: , x_Msg_Count OUT NOCOPY NUMBER
1423: , x_Msg_Data OUT NOCOPY VARCHAR2
1424: )IS

Line 1486: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Dimension ';

1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1483: WHEN NO_DATA_FOUND THEN
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: IF (x_msg_data IS NOT NULL) THEN
1486: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Dimension ';
1487: ELSE
1488: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Dimension ';
1489: END IF;
1490: WHEN OTHERS THEN

Line 1488: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Dimension ';

1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: IF (x_msg_data IS NOT NULL) THEN
1486: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Dimension ';
1487: ELSE
1488: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Dimension ';
1489: END IF;
1490: WHEN OTHERS THEN
1491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1492: IF (x_msg_data IS NOT NULL) THEN

Line 1493: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Dimension ';

1489: END IF;
1490: WHEN OTHERS THEN
1491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1492: IF (x_msg_data IS NOT NULL) THEN
1493: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Dimension ';
1494: ELSE
1495: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Dimension ';
1496: END IF;
1497: END Update_Calendar_Dimension;

Line 1495: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Dimension ';

1491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1492: IF (x_msg_data IS NOT NULL) THEN
1493: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Update_Calendar_Dimension ';
1494: ELSE
1495: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Update_Calendar_Dimension ';
1496: END IF;
1497: END Update_Calendar_Dimension;
1498:
1499:

Line 1566: END BSC_CALENDAR_PUB;

1562: x_result := -1;
1563: END comp_leapyear_prioryear;
1564:
1565:
1566: END BSC_CALENDAR_PUB;