DBA Data[Home] [Help]

APPS.CAC_VIEW_AVAIL_PVT dependencies on FND_API

Line 25: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

21: RETURN CEIL(((p_EndDate - p_StartDate)*24*60)/p_SlotSize);
22: EXCEPTION
23: WHEN OTHERS
24: THEN
25: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
26:
27: END NumberOfSlots;
28:
29: PROCEDURE InitializeList

Line 75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

71:
72: EXCEPTION
73: WHEN OTHERS
74: THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76:
77: END InitializeList;
78:
79: PROCEDURE Slots

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123:
124: EXCEPTION
125: WHEN OTHERS
126: THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END Slots;
129:
130: PROCEDURE UpdateList
131: ( p_List IN OUT NOCOPY AvlblTb -- List Name

Line 158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

154:
155: EXCEPTION
156: WHEN OTHERS
157: THEN
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: END UpdateList;
160:
161: PROCEDURE UpdateList
162: ( p_List IN OUT NOCOPY AvlblTb -- List Name

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176: );
177: EXCEPTION
178: WHEN OTHERS
179: THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END UpdateList;
182:
183: PROCEDURE Availability
184: ( p_api_version IN NUMBER

Line 249: IF NOT FND_API.Compatible_API_Call( l_api_version

245: BEGIN
246: /*****************************************************************************
247: ** Standard call to check for call compatibility
248: *****************************************************************************/
249: IF NOT FND_API.Compatible_API_Call( l_api_version
250: , p_api_version
251: , l_api_name
252: , G_PKG_NAME
253: )

Line 255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

251: , l_api_name
252: , G_PKG_NAME
253: )
254: THEN
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:
258: /*****************************************************************************
259: ** Initialize message list if p_init_msg_list is set to TRUE

Line 261: IF FND_API.To_Boolean(p_init_msg_list)

257:
258: /*****************************************************************************
259: ** Initialize message list if p_init_msg_list is set to TRUE
260: *****************************************************************************/
261: IF FND_API.To_Boolean(p_init_msg_list)
262: THEN
263: FND_MSG_PUB.Initialize;
264: END IF;
265:

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265:
266: /*****************************************************************************
267: ** Initialize API return status to success
268: *****************************************************************************/
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: /*****************************************************************************
272: ** Get the Timezone of the first user (this is the Query user)
273: *****************************************************************************/

Line 420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

416: , p_data => x_msg_data
417: );
418:
419: EXCEPTION
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
421: THEN
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
424: , p_data => x_msg_data

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418:
419: EXCEPTION
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
421: THEN
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
424: , p_data => x_msg_data
425: );
426: WHEN OTHERS

Line 428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

424: , p_data => x_msg_data
425: );
426: WHEN OTHERS
427: THEN
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
432: , l_api_name

Line 508: IF NOT FND_API.Compatible_API_Call( l_api_version

504: BEGIN
505: /*****************************************************************************
506: ** Standard call to check for call compatibility
507: *****************************************************************************/
508: IF NOT FND_API.Compatible_API_Call( l_api_version
509: , p_api_version
510: , l_api_name
511: , G_PKG_NAME
512: )

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510: , l_api_name
511: , G_PKG_NAME
512: )
513: THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517: /*****************************************************************************
518: ** Initialize message list if p_init_msg_list is set to TRUE

Line 520: IF FND_API.To_Boolean(p_init_msg_list)

516:
517: /*****************************************************************************
518: ** Initialize message list if p_init_msg_list is set to TRUE
519: *****************************************************************************/
520: IF FND_API.To_Boolean(p_init_msg_list)
521: THEN
522: FND_MSG_PUB.Initialize;
523: END IF;
524:

Line 528: x_return_status := FND_API.G_RET_STS_SUCCESS;

524:
525: /*****************************************************************************
526: ** Initialize API return status to success
527: *****************************************************************************/
528: x_return_status := FND_API.G_RET_STS_SUCCESS;
529:
530: /*****************************************************************************
531: ** Get the Timezone of the first user (this is the Query user)
532: *****************************************************************************/

Line 686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

682: , p_data => x_msg_data
683: );
684:
685: EXCEPTION
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
687: THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
690: , p_data => x_msg_data

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684:
685: EXCEPTION
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
687: THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
690: , p_data => x_msg_data
691: );
692: WHEN OTHERS

Line 694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

690: , p_data => x_msg_data
691: );
692: WHEN OTHERS
693: THEN
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
696: THEN
697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
698: , l_api_name

Line 743: IF NOT FND_API.Compatible_API_Call( l_api_version

739: BEGIN
740: /*****************************************************************************
741: ** Standard call to check for call compatibility
742: *****************************************************************************/
743: IF NOT FND_API.Compatible_API_Call( l_api_version
744: , p_api_version
745: , l_api_name
746: , g_pkg_name
747: )

Line 749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

745: , l_api_name
746: , g_pkg_name
747: )
748: THEN
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750: END IF;
751:
752: /*****************************************************************************
753: ** Initialize message list if p_init_msg_list is set to TRUE

Line 755: IF FND_API.To_Boolean(p_init_msg_list)

751:
752: /*****************************************************************************
753: ** Initialize message list if p_init_msg_list is set to TRUE
754: *****************************************************************************/
755: IF FND_API.To_Boolean(p_init_msg_list)
756: THEN
757: FND_MSG_PUB.Initialize;
758: END IF;
759:

Line 763: x_return_status := FND_API.G_RET_STS_SUCCESS;

759:
760: /*****************************************************************************
761: ** Initialize API return status to success
762: *****************************************************************************/
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: FOR rec IN c_resources (p_task_id)
766: LOOP
767: i := i + 1;

Line 796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

792: , p_data => x_msg_data
793: );
794:
795: EXCEPTION
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
797: THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
800: , p_data => x_msg_data

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794:
795: EXCEPTION
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
797: THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
800: , p_data => x_msg_data
801: );
802: WHEN OTHERS

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800: , p_data => x_msg_data
801: );
802: WHEN OTHERS
803: THEN
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
808: , l_api_name