48: , x_Msg_Data OUT NOCOPY VARCHAR2
49: )IS
50: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;
51: BEGIN
52: FND_MSG_PUB.Initialize;
53: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
54: --Here Just populate the calendar record with the values passed from UI and call public API
55: l_Calendar_Record.Calendar_Id := p_Calendar_Id;
56: l_Calendar_Record.Edw_Flag := p_Edw_Flag;
86:
87: EXCEPTION
88: WHEN FND_API.G_EXC_ERROR THEN
89: IF (x_msg_data IS NULL) THEN
90: FND_MSG_PUB.Count_And_Get
91: ( p_encoded => FND_API.G_FALSE
92: , p_count => x_msg_count
93: , p_data => x_msg_data
94: );
95: END IF;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
98: IF (x_msg_data IS NULL) THEN
99: FND_MSG_PUB.Count_And_Get
100: ( p_encoded => FND_API.G_FALSE
101: , p_count => x_msg_count
102: , p_data => x_msg_data
103: );
149: )IS
150: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;
151: BEGIN
152: --dbms_output.put_line('i came here');
153: FND_MSG_PUB.Initialize;
154: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
155: --Here Just populate the calendar record with the values passed from UI and call public API
156: l_Calendar_Record.Calendar_Id := p_Calendar_Id;
157: --dbms_output.put_line('not able to assign the value');
201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN
204: IF (x_msg_data IS NULL) THEN
205: FND_MSG_PUB.Count_And_Get
206: ( p_encoded => FND_API.G_FALSE
207: , p_count => x_msg_count
208: , p_data => x_msg_data
209: );
210: END IF;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: IF (x_msg_data IS NULL) THEN
214: FND_MSG_PUB.Count_And_Get
215: ( p_encoded => FND_API.G_FALSE
216: , p_count => x_msg_count
217: , p_data => x_msg_data
218: );
245: , x_Msg_Data OUT NOCOPY VARCHAR2
246: )IS
247: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;
248: BEGIN
249: FND_MSG_PUB.Initialize;
250: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
251: --Here Just populate the calendar record with the values passed from UI and call public API
252: l_Calendar_Record.Calendar_Id := p_Calendar_Id;
253:
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: IF (x_msg_data IS NULL) THEN
280: FND_MSG_PUB.Count_And_Get
281: ( p_encoded => FND_API.G_FALSE
282: , p_count => x_msg_count
283: , p_data => x_msg_data
284: );
285: END IF;
286: x_return_status := FND_API.G_RET_STS_ERROR;
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: IF (x_msg_data IS NULL) THEN
289: FND_MSG_PUB.Count_And_Get
290: ( p_encoded => FND_API.G_FALSE
291: , p_count => x_msg_count
292: , p_data => x_msg_data
293: );