82: RETURN CEIL(((p_EndDate - p_StartDate)*24*60)/p_SlotSize);
83: EXCEPTION
84: WHEN OTHERS
85: THEN
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87:
88: END NumberOfSlots;
89:
90: PROCEDURE InitializeList
137:
138: EXCEPTION
139: WHEN OTHERS
140: THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142:
143: END InitializeList;
144:
145: PROCEDURE Slots
189:
190: EXCEPTION
191: WHEN OTHERS
192: THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END Slots;
195:
196: PROCEDURE UpdateList
197: ( p_List IN OUT NOCOPY AvlblTb -- List Name
209:
210: EXCEPTION
211: WHEN OTHERS
212: THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END UpdateList;
215:
216: BEGIN
217: /*****************************************************************************
216: BEGIN
217: /*****************************************************************************
218: ** Standard call to check for call compatibility
219: *****************************************************************************/
220: IF NOT FND_API.Compatible_API_Call( l_api_version
221: , p_api_version
222: , l_api_name
223: , G_PKG_NAME
224: )
222: , l_api_name
223: , G_PKG_NAME
224: )
225: THEN
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228:
229: /*****************************************************************************
230: ** Initialize message list if p_init_msg_list is set to TRUE
228:
229: /*****************************************************************************
230: ** Initialize message list if p_init_msg_list is set to TRUE
231: *****************************************************************************/
232: IF FND_API.To_Boolean(p_init_msg_list)
233: THEN
234: FND_MSG_PUB.Initialize;
235: END IF;
236:
236:
237: /*****************************************************************************
238: ** Initialize API return status to success
239: *****************************************************************************/
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: /*****************************************************************************
243: ** Get the Timezone of the first user (this is the Query user)
244: *****************************************************************************/
386: , p_data => x_msg_data
387: );
388:
389: EXCEPTION
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
391: THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
394: , p_data => x_msg_data
388:
389: EXCEPTION
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
391: THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
394: , p_data => x_msg_data
395: );
396: WHEN OTHERS
394: , p_data => x_msg_data
395: );
396: WHEN OTHERS
397: THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
402: , l_api_name