APPS.AMS_AGENDAS_PVT dependencies on FND_API

Line 47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

43: /*****************************************************************************************/
44:
45: PROCEDURE Create_Agenda
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_agenda_rec IN agenda_rec_type,
51: x_return_status OUT NOCOPY VARCHAR2,

Line 48: p_commit IN VARCHAR2 := FND_API.G_FALSE,

44:
45: PROCEDURE Create_Agenda
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_agenda_rec IN agenda_rec_type,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,

Line 49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

45: PROCEDURE Create_Agenda
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_agenda_rec IN agenda_rec_type,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,

Line 117: IF NOT FND_API.Compatible_API_Call ( l_api_version,

113: -- Standard Start of API savepoint
114: SAVEPOINT Create_Agenda_PVT;
115:
116: -- Standard call to check for call compatibility.
117: IF NOT FND_API.Compatible_API_Call ( l_api_version,
118: p_api_version,
119: l_api_name,
120: G_PACKAGE_NAME)
121: THEN

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

118: p_api_version,
119: l_api_name,
120: G_PACKAGE_NAME)
121: THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: -- Initialize message list IF p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )

Line 126: IF FND_API.to_Boolean( p_init_msg_list )

122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: -- Initialize message list IF p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )
127: THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130:

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128: FND_MSG_PUB.initialize;
129: END IF;
130:
131: -- Initialize API return status to success
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: ----------------------- validate -----------------------
135: IF (AMS_DEBUG_HIGH_ON) THEN
136:

Line 149: IF l_return_status = FND_API.G_RET_STS_ERROR

145: ,x_msg_data => x_msg_data
146: ,p_agenda_rec => l_agenda_rec
147: );
148: -- If any errors happen abort API.
149: IF l_return_status = FND_API.G_RET_STS_ERROR
150: THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
153: THEN

Line 151: RAISE FND_API.G_EXC_ERROR;

147: );
148: -- If any errors happen abort API.
149: IF l_return_status = FND_API.G_RET_STS_ERROR
150: THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;

Line 152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

148: -- If any errors happen abort API.
149: IF l_return_status = FND_API.G_RET_STS_ERROR
150: THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157:
158: ------Generating the seq num for agenda id------------------

Line 203: p_init_msg_list => FND_API.G_FALSE,

199:
200:
201: Create_Agenda
202: ( p_api_version => l_api_version,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: p_agenda_rec => l_track_rec,
207: x_return_status => l_return_status,

Line 204: p_commit => FND_API.G_FALSE,

200:
201: Create_Agenda
202: ( p_api_version => l_api_version,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: p_agenda_rec => l_track_rec,
207: x_return_status => l_return_status,
208: x_msg_count => x_msg_count,

Line 205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

201: Create_Agenda
202: ( p_api_version => l_api_version,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: p_agenda_rec => l_track_rec,
207: x_return_status => l_return_status,
208: x_msg_count => x_msg_count,
209: x_msg_data => x_msg_data,

Line 213: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

209: x_msg_data => x_msg_data,
210: x_agenda_id => x_agenda_id
211: );
212:
213: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
214: THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
217: THEN

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: );
212:
213: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
214: THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
217: THEN
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;

Line 216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

212:
213: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
214: THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
217: THEN
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220:

Line 218: RAISE FND_API.G_EXC_ERROR;

214: THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
217: THEN
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220:
221: /* Replacing the parent_id and parent_type for Session */
222: l_agenda_rec.parent_type := 'TRACK';

Line 422: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

418: p_agenda_rec => l_agenda_rec,
419: x_return_status => x_return_status
420: );
421:
422: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
423: RAISE Fnd_Api.g_exc_unexpected_error;
424: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
425: RAISE Fnd_Api.g_exc_error;
426: END IF; */

Line 423: RAISE Fnd_Api.g_exc_unexpected_error;

419: x_return_status => x_return_status
420: );
421:
422: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
423: RAISE Fnd_Api.g_exc_unexpected_error;
424: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
425: RAISE Fnd_Api.g_exc_error;
426: END IF; */
427:

Line 424: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN

420: );
421:
422: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
423: RAISE Fnd_Api.g_exc_unexpected_error;
424: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
425: RAISE Fnd_Api.g_exc_error;
426: END IF; */
427:
428: -- Standard check of p_commit.

Line 425: RAISE Fnd_Api.g_exc_error;

421:
422: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
423: RAISE Fnd_Api.g_exc_unexpected_error;
424: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
425: RAISE Fnd_Api.g_exc_error;
426: END IF; */
427:
428: -- Standard check of p_commit.
429: IF FND_API.To_Boolean ( p_commit )

Line 429: IF FND_API.To_Boolean ( p_commit )

425: RAISE Fnd_Api.g_exc_error;
426: END IF; */
427:
428: -- Standard check of p_commit.
429: IF FND_API.To_Boolean ( p_commit )
430: THEN
431: COMMIT WORK;
432: END IF;
433:

Line 438: p_encoded => FND_API.G_FALSE

434: -- Standard call to get message count AND IF count is 1, get message info.
435: FND_MSG_PUB.Count_AND_Get
436: ( p_count => x_msg_count,
437: p_data => x_msg_data,
438: p_encoded => FND_API.G_FALSE
439: );
440:
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN

Line 442: WHEN FND_API.G_EXC_ERROR THEN

438: p_encoded => FND_API.G_FALSE
439: );
440:
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN
443: ROLLBACK TO Create_Agenda_PVT;
444: x_return_status := FND_API.G_RET_STS_ERROR ;
445:
446: FND_MSG_PUB.Count_AND_Get

Line 444: x_return_status := FND_API.G_RET_STS_ERROR ;

440:
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN
443: ROLLBACK TO Create_Agenda_PVT;
444: x_return_status := FND_API.G_RET_STS_ERROR ;
445:
446: FND_MSG_PUB.Count_AND_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data,

Line 449: p_encoded => FND_API.G_FALSE

445:
446: FND_MSG_PUB.Count_AND_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data,
449: p_encoded => FND_API.G_FALSE
450: );
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: ROLLBACK TO Create_Agenda_PVT;

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

448: p_data => x_msg_data,
449: p_encoded => FND_API.G_FALSE
450: );
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: ROLLBACK TO Create_Agenda_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455:
456: FND_MSG_PUB.Count_AND_Get

Line 454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

450: );
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: ROLLBACK TO Create_Agenda_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455:
456: FND_MSG_PUB.Count_AND_Get
457: ( p_count => x_msg_count,
458: p_data => x_msg_data,

Line 459: p_encoded => FND_API.G_FALSE

455:
456: FND_MSG_PUB.Count_AND_Get
457: ( p_count => x_msg_count,
458: p_data => x_msg_data,
459: p_encoded => FND_API.G_FALSE
460: );
461:
462: WHEN OTHERS THEN
463: ROLLBACK TO Create_Agenda_PVT;

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

460: );
461:
462: WHEN OTHERS THEN
463: ROLLBACK TO Create_Agenda_PVT;
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
465:
466: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
467: THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

Line 474: p_encoded => FND_API.G_FALSE

470:
471: FND_MSG_PUB.Count_AND_Get
472: ( p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE
475: );
476:
477: END Create_Agenda;
478:

Line 495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

491: /*****************************************************************************************/
492:
493: PROCEDURE Update_Agenda
494: ( p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: p_agenda_rec IN agenda_rec_type,
499: x_return_status OUT NOCOPY VARCHAR2,

Line 496: p_commit IN VARCHAR2 := FND_API.G_FALSE,

492:
493: PROCEDURE Update_Agenda
494: ( p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: p_agenda_rec IN agenda_rec_type,
499: x_return_status OUT NOCOPY VARCHAR2,
500: x_msg_count OUT NOCOPY NUMBER,

Line 497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

493: PROCEDURE Update_Agenda
494: ( p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: p_agenda_rec IN agenda_rec_type,
499: x_return_status OUT NOCOPY VARCHAR2,
500: x_msg_count OUT NOCOPY NUMBER,
501: x_msg_data OUT NOCOPY VARCHAR2

Line 536: IF NOT FND_API.Compatible_API_Call ( l_api_version,

532: -- Standard Start of API savepoint
533: SAVEPOINT Update_Agenda_PVT;
534:
535: -- Standard call to check for call compatibility.
536: IF NOT FND_API.Compatible_API_Call ( l_api_version,
537: p_api_version,
538: l_api_name,
539: G_PACKAGE_NAME)
540: THEN

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537: p_api_version,
538: l_api_name,
539: G_PACKAGE_NAME)
540: THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543:
544: -- Initialize message list IF p_init_msg_list is set to TRUE.
545: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 545: IF FND_API.to_Boolean( p_init_msg_list ) THEN

541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543:
544: -- Initialize message list IF p_init_msg_list is set to TRUE.
545: IF FND_API.to_Boolean( p_init_msg_list ) THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:
549: -- Initialize API return status to success

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: FND_MSG_PUB.initialize;
547: END IF;
548:
549: -- Initialize API return status to success
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: complete_agenda_rec
553: (
554: p_agenda_rec,

Line 577: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

573: p_validation_mode => JTF_PLSQL_API.g_update,
574: x_return_status => l_return_status
575: );
576:
577: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
578: THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
581: THEN

Line 579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

575: );
576:
577: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
578: THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
581: THEN
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;

Line 580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

576:
577: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
578: THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
581: THEN
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
584: END IF;

Line 582: RAISE FND_API.G_EXC_ERROR;

578: THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
581: THEN
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
584: END IF;
585:
586: IF (AMS_DEBUG_HIGH_ON) THEN

Line 602: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

598: p_complete_rec => l_agenda_rec,
599: x_return_status => l_return_status
600: );
601:
602: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
603: RAISE FND_API.g_exc_unexpected_error;
604: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
605: RAISE FND_API.g_exc_error;
606: END IF;

Line 603: RAISE FND_API.g_exc_unexpected_error;

599: x_return_status => l_return_status
600: );
601:
602: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
603: RAISE FND_API.g_exc_unexpected_error;
604: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
605: RAISE FND_API.g_exc_error;
606: END IF;
607: END IF;

Line 604: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

600: );
601:
602: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
603: RAISE FND_API.g_exc_unexpected_error;
604: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
605: RAISE FND_API.g_exc_error;
606: END IF;
607: END IF;
608:

Line 605: RAISE FND_API.g_exc_error;

601:
602: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
603: RAISE FND_API.g_exc_unexpected_error;
604: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
605: RAISE FND_API.g_exc_error;
606: END IF;
607: END IF;
608:
609: /* If we are updating the Coordinator for Session, check whether that

Line 636: p_init_msg_list => FND_API.G_FALSE,

632: WHILE c_resources%FOUND LOOP
633:
634: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
635: ( p_api_version => l_api_version,
636: p_init_msg_list => FND_API.G_FALSE,
637: p_commit => FND_API.G_FALSE,
638: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
639: x_return_status => l_return_status,
640: x_msg_count => x_msg_count,

Line 637: p_commit => FND_API.G_FALSE,

633:
634: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
635: ( p_api_version => l_api_version,
636: p_init_msg_list => FND_API.G_FALSE,
637: p_commit => FND_API.G_FALSE,
638: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
639: x_return_status => l_return_status,
640: x_msg_count => x_msg_count,
641: x_msg_data => x_msg_data,

Line 638: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

634: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
635: ( p_api_version => l_api_version,
636: p_init_msg_list => FND_API.G_FALSE,
637: p_commit => FND_API.G_FALSE,
638: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
639: x_return_status => l_return_status,
640: x_msg_count => x_msg_count,
641: x_msg_data => x_msg_data,
642: p_act_Resource_id => l_act_res_id,

Line 646: IF l_return_status = FND_API.g_ret_sts_error THEN

642: p_act_Resource_id => l_act_res_id,
643: p_object_version => l_obj_ver_num
644: );
645:
646: IF l_return_status = FND_API.g_ret_sts_error THEN
647: RAISE FND_API.g_exc_error;
648: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
649: RAISE FND_API.g_exc_unexpected_error;
650: END IF; -- IF l_return_status = FND_API.g_ret_sts_error THEN

Line 647: RAISE FND_API.g_exc_error;

643: p_object_version => l_obj_ver_num
644: );
645:
646: IF l_return_status = FND_API.g_ret_sts_error THEN
647: RAISE FND_API.g_exc_error;
648: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
649: RAISE FND_API.g_exc_unexpected_error;
650: END IF; -- IF l_return_status = FND_API.g_ret_sts_error THEN
651:

Line 648: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

644: );
645:
646: IF l_return_status = FND_API.g_ret_sts_error THEN
647: RAISE FND_API.g_exc_error;
648: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
649: RAISE FND_API.g_exc_unexpected_error;
650: END IF; -- IF l_return_status = FND_API.g_ret_sts_error THEN
651:
652: FETCH c_resources INTO l_act_res_id, l_obj_ver_num;

Line 649: RAISE FND_API.g_exc_unexpected_error;

645:
646: IF l_return_status = FND_API.g_ret_sts_error THEN
647: RAISE FND_API.g_exc_error;
648: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
649: RAISE FND_API.g_exc_unexpected_error;
650: END IF; -- IF l_return_status = FND_API.g_ret_sts_error THEN
651:
652: FETCH c_resources INTO l_act_res_id, l_obj_ver_num;
653:

Line 650: END IF; -- IF l_return_status = FND_API.g_ret_sts_error THEN

646: IF l_return_status = FND_API.g_ret_sts_error THEN
647: RAISE FND_API.g_exc_error;
648: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
649: RAISE FND_API.g_exc_unexpected_error;
650: END IF; -- IF l_return_status = FND_API.g_ret_sts_error THEN
651:
652: FETCH c_resources INTO l_act_res_id, l_obj_ver_num;
653:
654: END LOOP; -- WHILE(c_resources%FOUND)

Line 860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

856: THEN -- MMSG
857: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
858: FND_MSG_PUB.Add;
859: END IF;
860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
861: END IF;
862:
863: UPDATE ams_agendas_tl SET
864: agenda_name = l_agenda_rec.agenda_name,

Line 878: RAISE FND_API.g_exc_error;

874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
875: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
876: FND_MSG_PUB.add;
877: END IF;
878: RAISE FND_API.g_exc_error;
879: END IF;
880:
881:
882: /* Roll up the times to Track and then to Event Level */

Line 888: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

884: p_agenda_rec => l_agenda_rec,
885: x_return_status => x_return_status
886: ); */
887:
888: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
889: RAISE Fnd_Api.g_exc_unexpected_error;
890: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
891: RAISE Fnd_Api.g_exc_error;
892: END IF;

Line 889: RAISE Fnd_Api.g_exc_unexpected_error;

885: x_return_status => x_return_status
886: ); */
887:
888: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
889: RAISE Fnd_Api.g_exc_unexpected_error;
890: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
891: RAISE Fnd_Api.g_exc_error;
892: END IF;
893:

Line 890: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN

886: ); */
887:
888: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
889: RAISE Fnd_Api.g_exc_unexpected_error;
890: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
891: RAISE Fnd_Api.g_exc_error;
892: END IF;
893:
894: -- Standard check of p_commit.

Line 891: RAISE Fnd_Api.g_exc_error;

887:
888: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
889: RAISE Fnd_Api.g_exc_unexpected_error;
890: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
891: RAISE Fnd_Api.g_exc_error;
892: END IF;
893:
894: -- Standard check of p_commit.
895: IF FND_API.To_Boolean ( p_commit )

Line 895: IF FND_API.To_Boolean ( p_commit )

891: RAISE Fnd_Api.g_exc_error;
892: END IF;
893:
894: -- Standard check of p_commit.
895: IF FND_API.To_Boolean ( p_commit )
896: THEN
897: COMMIT WORK;
898: END IF;
899:

Line 904: p_encoded => FND_API.G_FALSE

900: -- Standard call to get message count AND IF count is 1, get message info.
901: FND_MSG_PUB.Count_AND_Get
902: ( p_count => x_msg_count,
903: p_data => x_msg_data,
904: p_encoded => FND_API.G_FALSE
905: );
906:
907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN

Line 908: WHEN FND_API.G_EXC_ERROR THEN

904: p_encoded => FND_API.G_FALSE
905: );
906:
907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN
909: ROLLBACK TO Update_Agenda_PVT;
910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: FND_MSG_PUB.Count_AND_Get
912: ( p_count => x_msg_count,

Line 910: x_return_status := FND_API.G_RET_STS_ERROR ;

906:
907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN
909: ROLLBACK TO Update_Agenda_PVT;
910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: FND_MSG_PUB.Count_AND_Get
912: ( p_count => x_msg_count,
913: p_data => x_msg_data,
914: p_encoded => FND_API.G_FALSE

Line 914: p_encoded => FND_API.G_FALSE

910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: FND_MSG_PUB.Count_AND_Get
912: ( p_count => x_msg_count,
913: p_data => x_msg_data,
914: p_encoded => FND_API.G_FALSE
915: );
916:
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: ROLLBACK TO Update_Agenda_PVT;

Line 917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

913: p_data => x_msg_data,
914: p_encoded => FND_API.G_FALSE
915: );
916:
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: ROLLBACK TO Update_Agenda_PVT;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_AND_Get
921: ( p_count => x_msg_count,

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

915: );
916:
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: ROLLBACK TO Update_Agenda_PVT;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_AND_Get
921: ( p_count => x_msg_count,
922: p_data => x_msg_data,
923: p_encoded => FND_API.G_FALSE

Line 923: p_encoded => FND_API.G_FALSE

919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_AND_Get
921: ( p_count => x_msg_count,
922: p_data => x_msg_data,
923: p_encoded => FND_API.G_FALSE
924: );
925:
926: WHEN OTHERS THEN
927: ROLLBACK TO Update_Agenda_PVT;

Line 928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

924: );
925:
926: WHEN OTHERS THEN
927: ROLLBACK TO Update_Agenda_PVT;
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
929:
930: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
931: THEN
932: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

Line 938: p_encoded => FND_API.G_FALSE

934:
935: FND_MSG_PUB.Count_AND_Get
936: ( p_count => x_msg_count,
937: p_data => x_msg_data,
938: p_encoded => FND_API.G_FALSE
939: );
940:
941: END Update_Agenda;
942:

Line 959: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

955: /*****************************************************************************************/
956:
957: PROCEDURE Delete_Agenda
958: ( p_api_version IN NUMBER,
959: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
960: p_commit IN VARCHAR2 := FND_API.G_FALSE,
961:
962: p_agenda_id IN NUMBER,
963: p_object_version IN NUMBER,

Line 960: p_commit IN VARCHAR2 := FND_API.G_FALSE,

956:
957: PROCEDURE Delete_Agenda
958: ( p_api_version IN NUMBER,
959: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
960: p_commit IN VARCHAR2 := FND_API.G_FALSE,
961:
962: p_agenda_id IN NUMBER,
963: p_object_version IN NUMBER,
964:

Line 1013: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1009: -- Standard Start of API savepoint
1010: SAVEPOINT Delete_Agenda_PVT;
1011:
1012: -- Standard call to check for call compatibility.
1013: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1014: p_api_version,
1015: l_api_name,
1016: G_PACKAGE_NAME)
1017: THEN

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1014: p_api_version,
1015: l_api_name,
1016: G_PACKAGE_NAME)
1017: THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:
1021: -- Initialize message list IF p_init_msg_list is set to TRUE.
1022: IF FND_API.to_Boolean( p_init_msg_list )

Line 1022: IF FND_API.to_Boolean( p_init_msg_list )

1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:
1021: -- Initialize message list IF p_init_msg_list is set to TRUE.
1022: IF FND_API.to_Boolean( p_init_msg_list )
1023: THEN
1024: FND_MSG_PUB.initialize;
1025: END IF;
1026:

Line 1028: x_return_status := FND_API.G_RET_STS_SUCCESS;

1024: FND_MSG_PUB.initialize;
1025: END IF;
1026:
1027: -- Initialize API return status to success
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: ------------------------ delete ------------------------
1031: IF (AMS_DEBUG_HIGH_ON) THEN
1032:

Line 1047: RAISE FND_API.g_exc_error;

1043: THEN
1044: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
1045: Fnd_Msg_Pub.ADD;
1046: END IF;
1047: RAISE FND_API.g_exc_error;
1048: END IF;
1049:
1050:
1051: OPEN c_agenda;

Line 1065: p_init_msg_list => FND_API.G_FALSE,

1061: WHILE c_resources%FOUND LOOP
1062:
1063: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
1064: ( p_api_version => l_api_version,
1065: p_init_msg_list => FND_API.G_FALSE,
1066: p_commit => FND_API.G_FALSE,
1067: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1068: x_return_status => l_return_status,
1069: x_msg_count => x_msg_count,

Line 1066: p_commit => FND_API.G_FALSE,

1062:
1063: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
1064: ( p_api_version => l_api_version,
1065: p_init_msg_list => FND_API.G_FALSE,
1066: p_commit => FND_API.G_FALSE,
1067: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1068: x_return_status => l_return_status,
1069: x_msg_count => x_msg_count,
1070: x_msg_data => x_msg_data,

Line 1067: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1063: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
1064: ( p_api_version => l_api_version,
1065: p_init_msg_list => FND_API.G_FALSE,
1066: p_commit => FND_API.G_FALSE,
1067: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1068: x_return_status => l_return_status,
1069: x_msg_count => x_msg_count,
1070: x_msg_data => x_msg_data,
1071: p_act_Resource_id => l_act_res_id,

Line 1075: IF l_return_status = FND_API.g_ret_sts_error THEN

1071: p_act_Resource_id => l_act_res_id,
1072: p_object_version => l_obj_ver_num
1073: );
1074:
1075: IF l_return_status = FND_API.g_ret_sts_error THEN
1076: RAISE FND_API.g_exc_error;
1077: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1078: RAISE FND_API.g_exc_unexpected_error;
1079: END IF;

Line 1076: RAISE FND_API.g_exc_error;

1072: p_object_version => l_obj_ver_num
1073: );
1074:
1075: IF l_return_status = FND_API.g_ret_sts_error THEN
1076: RAISE FND_API.g_exc_error;
1077: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1078: RAISE FND_API.g_exc_unexpected_error;
1079: END IF;
1080:

Line 1077: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1073: );
1074:
1075: IF l_return_status = FND_API.g_ret_sts_error THEN
1076: RAISE FND_API.g_exc_error;
1077: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1078: RAISE FND_API.g_exc_unexpected_error;
1079: END IF;
1080:
1081: FETCH c_resources INTO l_act_res_id, l_obj_ver_num ;

Line 1078: RAISE FND_API.g_exc_unexpected_error;

1074:
1075: IF l_return_status = FND_API.g_ret_sts_error THEN
1076: RAISE FND_API.g_exc_error;
1077: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1078: RAISE FND_API.g_exc_unexpected_error;
1079: END IF;
1080:
1081: FETCH c_resources INTO l_act_res_id, l_obj_ver_num ;
1082:

Line 1107: p_init_msg_list => FND_API.G_FALSE,

1103: WHILE c_resources%FOUND LOOP
1104:
1105: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
1106: ( p_api_version => l_api_version,
1107: p_init_msg_list => FND_API.G_FALSE,
1108: p_commit => FND_API.G_FALSE,
1109: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1110: x_return_status => l_return_status,
1111: x_msg_count => x_msg_count,

Line 1108: p_commit => FND_API.G_FALSE,

1104:
1105: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
1106: ( p_api_version => l_api_version,
1107: p_init_msg_list => FND_API.G_FALSE,
1108: p_commit => FND_API.G_FALSE,
1109: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1110: x_return_status => l_return_status,
1111: x_msg_count => x_msg_count,
1112: x_msg_data => x_msg_data,

Line 1109: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1105: AMS_ACTRESOURCE_PVT.DELETE_ACT_RESOURCE
1106: ( p_api_version => l_api_version,
1107: p_init_msg_list => FND_API.G_FALSE,
1108: p_commit => FND_API.G_FALSE,
1109: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1110: x_return_status => l_return_status,
1111: x_msg_count => x_msg_count,
1112: x_msg_data => x_msg_data,
1113: p_act_Resource_id => l_act_res_id,

Line 1117: IF l_return_status = FND_API.g_ret_sts_error THEN

1113: p_act_Resource_id => l_act_res_id,
1114: p_object_version => l_obj_ver_num
1115: );
1116:
1117: IF l_return_status = FND_API.g_ret_sts_error THEN
1118: RAISE FND_API.g_exc_error;
1119: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1120: RAISE FND_API.g_exc_unexpected_error;
1121: END IF;

Line 1118: RAISE FND_API.g_exc_error;

1114: p_object_version => l_obj_ver_num
1115: );
1116:
1117: IF l_return_status = FND_API.g_ret_sts_error THEN
1118: RAISE FND_API.g_exc_error;
1119: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1120: RAISE FND_API.g_exc_unexpected_error;
1121: END IF;
1122:

Line 1119: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1115: );
1116:
1117: IF l_return_status = FND_API.g_ret_sts_error THEN
1118: RAISE FND_API.g_exc_error;
1119: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1120: RAISE FND_API.g_exc_unexpected_error;
1121: END IF;
1122:
1123: FETCH c_resources INTO l_act_res_id, l_obj_ver_num ;

Line 1120: RAISE FND_API.g_exc_unexpected_error;

1116:
1117: IF l_return_status = FND_API.g_ret_sts_error THEN
1118: RAISE FND_API.g_exc_error;
1119: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1120: RAISE FND_API.g_exc_unexpected_error;
1121: END IF;
1122:
1123: FETCH c_resources INTO l_act_res_id, l_obj_ver_num ;
1124:

Line 1148: RAISE FND_API.g_exc_error;

1144: THEN
1145: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1146: FND_MSG_PUB.add;
1147: END IF;
1148: RAISE FND_API.g_exc_error;
1149: END IF;
1150:
1151:
1152: ---Roll up the times to Track and then to Event Level---

Line 1162: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1158: p_agenda_rec => l_agenda_rec,
1159: x_return_status => x_return_status
1160: ); */
1161:
1162: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1163: RAISE Fnd_Api.g_exc_unexpected_error;
1164: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
1165: RAISE Fnd_Api.g_exc_error;
1166: END IF;

Line 1163: RAISE Fnd_Api.g_exc_unexpected_error;

1159: x_return_status => x_return_status
1160: ); */
1161:
1162: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1163: RAISE Fnd_Api.g_exc_unexpected_error;
1164: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
1165: RAISE Fnd_Api.g_exc_error;
1166: END IF;
1167:

Line 1164: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN

1160: ); */
1161:
1162: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1163: RAISE Fnd_Api.g_exc_unexpected_error;
1164: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
1165: RAISE Fnd_Api.g_exc_error;
1166: END IF;
1167:
1168: -------------------- finish --------------------------

Line 1165: RAISE Fnd_Api.g_exc_error;

1161:
1162: IF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1163: RAISE Fnd_Api.g_exc_unexpected_error;
1164: ELSIF x_return_status = Fnd_Api.g_ret_sts_error THEN
1165: RAISE Fnd_Api.g_exc_error;
1166: END IF;
1167:
1168: -------------------- finish --------------------------
1169:

Line 1171: IF FND_API.To_Boolean ( p_commit )

1167:
1168: -------------------- finish --------------------------
1169:
1170: -- Standard check of p_commit.
1171: IF FND_API.To_Boolean ( p_commit )
1172: THEN
1173: COMMIT WORK;
1174: END IF;
1175:

Line 1180: p_encoded => FND_API.G_FALSE

1176: -- Standard call to get message count AND IF count is 1, get message info.
1177: FND_MSG_PUB.Count_AND_Get
1178: ( p_count => x_msg_count,
1179: p_data => x_msg_data,
1180: p_encoded => FND_API.G_FALSE
1181: );
1182:
1183: EXCEPTION
1184:

Line 1185: WHEN FND_API.G_EXC_ERROR THEN

1181: );
1182:
1183: EXCEPTION
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: ROLLBACK TO Delete_Agenda_PVT;
1187: x_return_status := FND_API.G_RET_STS_ERROR ;
1188:
1189: FND_MSG_PUB.Count_AND_Get

Line 1187: x_return_status := FND_API.G_RET_STS_ERROR ;

1183: EXCEPTION
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: ROLLBACK TO Delete_Agenda_PVT;
1187: x_return_status := FND_API.G_RET_STS_ERROR ;
1188:
1189: FND_MSG_PUB.Count_AND_Get
1190: ( p_count => x_msg_count,
1191: p_data => x_msg_data,

Line 1192: p_encoded => FND_API.G_FALSE

1188:
1189: FND_MSG_PUB.Count_AND_Get
1190: ( p_count => x_msg_count,
1191: p_data => x_msg_data,
1192: p_encoded => FND_API.G_FALSE
1193: );
1194:
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: ROLLBACK TO Delete_Agenda_PVT;

Line 1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1191: p_data => x_msg_data,
1192: p_encoded => FND_API.G_FALSE
1193: );
1194:
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: ROLLBACK TO Delete_Agenda_PVT;
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1198:
1199: FND_MSG_PUB.Count_AND_Get

Line 1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1193: );
1194:
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: ROLLBACK TO Delete_Agenda_PVT;
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1198:
1199: FND_MSG_PUB.Count_AND_Get
1200: ( p_count => x_msg_count,
1201: p_data => x_msg_data,

Line 1202: p_encoded => FND_API.G_FALSE

1198:
1199: FND_MSG_PUB.Count_AND_Get
1200: ( p_count => x_msg_count,
1201: p_data => x_msg_data,
1202: p_encoded => FND_API.G_FALSE
1203: );
1204:
1205: WHEN OTHERS THEN
1206: ROLLBACK TO Delete_Agenda_PVT;

Line 1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1203: );
1204:
1205: WHEN OTHERS THEN
1206: ROLLBACK TO Delete_Agenda_PVT;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208:
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

Line 1217: p_encoded => FND_API.G_FALSE

1213:
1214: FND_MSG_PUB.Count_AND_Get
1215: ( p_count => x_msg_count,
1216: p_data => x_msg_data,
1217: p_encoded => FND_API.G_FALSE
1218: );
1219:
1220: END Delete_Agenda;
1221:

Line 1238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1234: /*****************************************************************************************/
1235:
1236: PROCEDURE Lock_Agenda
1237: ( p_api_version IN NUMBER,
1238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1239: p_agenda_id IN NUMBER,
1240: p_object_version IN NUMBER,
1241: x_return_status OUT NOCOPY VARCHAR2,
1242: x_msg_count OUT NOCOPY NUMBER,

Line 1261: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1257: FOR UPDATE of agenda_id NOWAIT;
1258:
1259: BEGIN
1260: -- Standard call to check for call compatibility.
1261: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1262: p_api_version,
1263: l_api_name,
1264: G_PACKAGE_NAME)
1265: THEN

Line 1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1262: p_api_version,
1263: l_api_name,
1264: G_PACKAGE_NAME)
1265: THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: END IF;
1268:
1269: -- Initialize message list if p_init_msg_list is set to TRUE.
1270: IF FND_API.to_Boolean( p_init_msg_list )

Line 1270: IF FND_API.to_Boolean( p_init_msg_list )

1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: END IF;
1268:
1269: -- Initialize message list if p_init_msg_list is set to TRUE.
1270: IF FND_API.to_Boolean( p_init_msg_list )
1271: THEN
1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:

Line 1276: x_return_status := FND_API.G_RET_STS_SUCCESS;

1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:
1275: -- Initialize API return status to success
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:
1278: -- Perform the database operation
1279: OPEN c_agenda;
1280: FETCH c_agenda INTO l_agenda_id;

Line 1292: RAISE FND_API.G_EXC_ERROR;

1288: THEN -- MMSG
1289: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1290: FND_MSG_PUB.Add;
1291: END IF;
1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;
1294: CLOSE c_agenda;
1295:
1296: -- Standard call to get message count AND IF count is 1, get message info.

Line 1300: p_encoded => FND_API.G_FALSE

1296: -- Standard call to get message count AND IF count is 1, get message info.
1297: FND_MSG_PUB.Count_AND_Get
1298: ( p_count => x_msg_count,
1299: p_data => x_msg_data,
1300: p_encoded => FND_API.G_FALSE
1301: );
1302: EXCEPTION
1303: WHEN FND_API.G_EXC_ERROR THEN
1304: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1303: WHEN FND_API.G_EXC_ERROR THEN

1299: p_data => x_msg_data,
1300: p_encoded => FND_API.G_FALSE
1301: );
1302: EXCEPTION
1303: WHEN FND_API.G_EXC_ERROR THEN
1304: x_return_status := FND_API.G_RET_STS_ERROR ;
1305: FND_MSG_PUB.Count_AND_Get
1306: ( p_count => x_msg_count,
1307: p_data => x_msg_data,

Line 1304: x_return_status := FND_API.G_RET_STS_ERROR ;

1300: p_encoded => FND_API.G_FALSE
1301: );
1302: EXCEPTION
1303: WHEN FND_API.G_EXC_ERROR THEN
1304: x_return_status := FND_API.G_RET_STS_ERROR ;
1305: FND_MSG_PUB.Count_AND_Get
1306: ( p_count => x_msg_count,
1307: p_data => x_msg_data,
1308: p_encoded => FND_API.G_FALSE

Line 1308: p_encoded => FND_API.G_FALSE

1304: x_return_status := FND_API.G_RET_STS_ERROR ;
1305: FND_MSG_PUB.Count_AND_Get
1306: ( p_count => x_msg_count,
1307: p_data => x_msg_data,
1308: p_encoded => FND_API.G_FALSE
1309: );
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1307: p_data => x_msg_data,
1308: p_encoded => FND_API.G_FALSE
1309: );
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1313: FND_MSG_PUB.Count_AND_Get
1314: ( p_count => x_msg_count,
1315: p_data => x_msg_data,

Line 1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1308: p_encoded => FND_API.G_FALSE
1309: );
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1313: FND_MSG_PUB.Count_AND_Get
1314: ( p_count => x_msg_count,
1315: p_data => x_msg_data,
1316: p_encoded => FND_API.G_FALSE

Line 1316: p_encoded => FND_API.G_FALSE

1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1313: FND_MSG_PUB.Count_AND_Get
1314: ( p_count => x_msg_count,
1315: p_data => x_msg_data,
1316: p_encoded => FND_API.G_FALSE
1317: );
1318:
1319: /* WHEN AMS_Utility_PVT.agenda_locked THEN
1320: x_return_status := FND_API.g_ret_sts_error;

Line 1320: x_return_status := FND_API.g_ret_sts_error;

1316: p_encoded => FND_API.G_FALSE
1317: );
1318:
1319: /* WHEN AMS_Utility_PVT.agenda_locked THEN
1320: x_return_status := FND_API.g_ret_sts_error;
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1322: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1323: FND_MSG_PUB.add;
1324: END IF; */

Line 1329: p_encoded => FND_API.G_FALSE

1325:
1326: FND_MSG_PUB.Count_AND_Get
1327: ( p_count => x_msg_count,
1328: p_data => x_msg_data,
1329: p_encoded => FND_API.G_FALSE
1330: );
1331:
1332: WHEN OTHERS THEN
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1329: p_encoded => FND_API.G_FALSE
1330: );
1331:
1332: WHEN OTHERS THEN
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1334: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1335: THEN
1336: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1337: END IF;

Line 1342: p_encoded => FND_API.G_FALSE

1338:
1339: FND_MSG_PUB.Count_AND_Get
1340: ( p_count => x_msg_count,
1341: p_data => x_msg_data,
1342: p_encoded => FND_API.G_FALSE
1343: );
1344:
1345: END Lock_Agenda;
1346:

Line 1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1359: /*****************************************************************************************/
1360:
1361: PROCEDURE Validate_Agenda
1362: ( p_api_version IN NUMBER,
1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1364: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1365: p_agenda_rec IN agenda_rec_type,
1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_count OUT NOCOPY NUMBER,

Line 1364: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1360:
1361: PROCEDURE Validate_Agenda
1362: ( p_api_version IN NUMBER,
1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1364: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1365: p_agenda_rec IN agenda_rec_type,
1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_count OUT NOCOPY NUMBER,
1368: x_msg_data OUT NOCOPY VARCHAR2

Line 1380: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1376:
1377: -- l_default_act_resource_rec act_Resource_rec_type;
1378: BEGIN
1379: -- Standard call to check for call compatibility.
1380: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1381: p_api_version,
1382: l_api_name,
1383: G_PACKAGE_NAME)
1384: THEN

Line 1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1381: p_api_version,
1382: l_api_name,
1383: G_PACKAGE_NAME)
1384: THEN
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: END IF;
1387:
1388: -- Initialize message list if p_init_msg_list is set to TRUE.
1389: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1389: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: END IF;
1387:
1388: -- Initialize message list if p_init_msg_list is set to TRUE.
1389: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1390: FND_MSG_PUB.initialize;
1391: END IF;
1392:
1393: -- Initialize API return status to success

Line 1394: x_return_status := FND_API.G_RET_STS_SUCCESS;

1390: FND_MSG_PUB.initialize;
1391: END IF;
1392:
1393: -- Initialize API return status to success
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;
1395:
1396: IF (AMS_DEBUG_HIGH_ON) THEN
1397:
1398:

Line 1412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1408: x_return_status => l_return_status
1409: );
1410:
1411: -- If any errors happen abort API.
1412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1413: THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1416: THEN

Line 1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1410:
1411: -- If any errors happen abort API.
1412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1413: THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1416: THEN
1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;

Line 1415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1411: -- If any errors happen abort API.
1412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1413: THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1416: THEN
1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;
1419:

Line 1417: RAISE FND_API.G_EXC_ERROR;

1413: THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1416: THEN
1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;
1419:
1420: END IF;
1421:

Line 1436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1432: x_return_status => l_return_status
1433: );
1434:
1435: -- If any errors happen abort API.
1436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: END IF;

Line 1437: RAISE FND_API.G_EXC_ERROR;

1433: );
1434:
1435: -- If any errors happen abort API.
1436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: END IF;
1441:

Line 1438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1434:
1435: -- If any errors happen abort API.
1436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: END IF;
1441:
1442: END IF;

Line 1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1435: -- If any errors happen abort API.
1436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: END IF;
1441:
1442: END IF;
1443:

Line 1446: p_encoded => FND_API.g_false,

1442: END IF;
1443:
1444: -------------------- finish --------------------------
1445: FND_MSG_PUB.count_and_get(
1446: p_encoded => FND_API.g_false,
1447: p_count => x_msg_count,
1448: p_data => x_msg_data
1449: );
1450:

Line 1452: WHEN FND_API.G_EXC_ERROR THEN

1448: p_data => x_msg_data
1449: );
1450:
1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: x_return_status := FND_API.G_RET_STS_ERROR ;
1454: FND_MSG_PUB.Count_AND_Get
1455: ( p_count => x_msg_count,
1456: p_data => x_msg_data,

Line 1453: x_return_status := FND_API.G_RET_STS_ERROR ;

1449: );
1450:
1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: x_return_status := FND_API.G_RET_STS_ERROR ;
1454: FND_MSG_PUB.Count_AND_Get
1455: ( p_count => x_msg_count,
1456: p_data => x_msg_data,
1457: p_encoded => FND_API.G_FALSE

Line 1457: p_encoded => FND_API.G_FALSE

1453: x_return_status := FND_API.G_RET_STS_ERROR ;
1454: FND_MSG_PUB.Count_AND_Get
1455: ( p_count => x_msg_count,
1456: p_data => x_msg_data,
1457: p_encoded => FND_API.G_FALSE
1458: );
1459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1461: FND_MSG_PUB.Count_AND_Get

Line 1459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1455: ( p_count => x_msg_count,
1456: p_data => x_msg_data,
1457: p_encoded => FND_API.G_FALSE
1458: );
1459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1461: FND_MSG_PUB.Count_AND_Get
1462: ( p_count => x_msg_count,
1463: p_data => x_msg_data,

Line 1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1456: p_data => x_msg_data,
1457: p_encoded => FND_API.G_FALSE
1458: );
1459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1461: FND_MSG_PUB.Count_AND_Get
1462: ( p_count => x_msg_count,
1463: p_data => x_msg_data,
1464: p_encoded => FND_API.G_FALSE

Line 1464: p_encoded => FND_API.G_FALSE

1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1461: FND_MSG_PUB.Count_AND_Get
1462: ( p_count => x_msg_count,
1463: p_data => x_msg_data,
1464: p_encoded => FND_API.G_FALSE
1465: );
1466: WHEN OTHERS THEN
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1468: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1463: p_data => x_msg_data,
1464: p_encoded => FND_API.G_FALSE
1465: );
1466: WHEN OTHERS THEN
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1468: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1469: THEN
1470: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1471: END IF;

Line 1475: p_encoded => FND_API.G_FALSE

1471: END IF;
1472: FND_MSG_PUB.Count_AND_Get
1473: ( p_count => x_msg_count,
1474: p_data => x_msg_data,
1475: p_encoded => FND_API.G_FALSE
1476: );
1477:
1478: END Validate_Agenda;
1479:

Line 1494: x_return_status := FND_API.g_ret_sts_success;

1490: )
1491: IS
1492: BEGIN
1493:
1494: x_return_status := FND_API.g_ret_sts_success;
1495:
1496: ------------------------ application_id --------------------------
1497: IF (p_agenda_rec.application_id IS NULL OR p_agenda_rec.application_id = FND_API.g_miss_num) THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1497: IF (p_agenda_rec.application_id IS NULL OR p_agenda_rec.application_id = FND_API.g_miss_num) THEN

1493:
1494: x_return_status := FND_API.g_ret_sts_success;
1495:
1496: ------------------------ application_id --------------------------
1497: IF (p_agenda_rec.application_id IS NULL OR p_agenda_rec.application_id = FND_API.g_miss_num) THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1500: FND_MSG_PUB.add;
1501: END IF;

Line 1502: x_return_status := FND_API.g_ret_sts_error;

1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1500: FND_MSG_PUB.add;
1501: END IF;
1502: x_return_status := FND_API.g_ret_sts_error;
1503: RETURN;
1504: END IF;
1505: ------------------------ parent_id--------------------------
1506: IF (p_agenda_rec.parent_id IS NULL OR p_agenda_rec.parent_id = FND_API.g_miss_num) THEN

Line 1506: IF (p_agenda_rec.parent_id IS NULL OR p_agenda_rec.parent_id = FND_API.g_miss_num) THEN

1502: x_return_status := FND_API.g_ret_sts_error;
1503: RETURN;
1504: END IF;
1505: ------------------------ parent_id--------------------------
1506: IF (p_agenda_rec.parent_id IS NULL OR p_agenda_rec.parent_id = FND_API.g_miss_num) THEN
1507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1508: IF (p_agenda_rec.agenda_type = 'TRACK')
1509: THEN
1510: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_ID');

Line 1516: x_return_status := FND_API.g_ret_sts_error;

1512: -- FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_ID');
1513: END IF;
1514: FND_MSG_PUB.add;
1515: END IF;
1516: x_return_status := FND_API.g_ret_sts_error;
1517: RETURN;
1518: END IF;
1519:
1520: ------------------------ parent_type--------------------------

Line 1521: IF (p_agenda_rec.parent_type IS NULL OR p_agenda_rec.parent_type = FND_API.g_miss_char) THEN

1517: RETURN;
1518: END IF;
1519:
1520: ------------------------ parent_type--------------------------
1521: IF (p_agenda_rec.parent_type IS NULL OR p_agenda_rec.parent_type = FND_API.g_miss_char) THEN
1522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1523: IF (p_agenda_rec.agenda_type = 'TRACK')
1524: THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_TYPE');

Line 1531: x_return_status := FND_API.g_ret_sts_error;

1527: FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_TYPE');
1528: END IF;
1529: FND_MSG_PUB.add;
1530: END IF;
1531: x_return_status := FND_API.g_ret_sts_error;
1532: RETURN;
1533: END IF;
1534:
1535: ------------------------ agenda_type--------------------------

Line 1536: IF (p_agenda_rec.agenda_type IS NULL OR p_agenda_rec.agenda_type = FND_API.g_miss_char) THEN

1532: RETURN;
1533: END IF;
1534:
1535: ------------------------ agenda_type--------------------------
1536: IF (p_agenda_rec.agenda_type IS NULL OR p_agenda_rec.agenda_type = FND_API.g_miss_char) THEN
1537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1538: FND_MESSAGE.set_name('AMS', 'AMS_NO_AGENDA_TYPE');
1539: FND_MSG_PUB.add;
1540: END IF;

Line 1541: x_return_status := FND_API.g_ret_sts_error;

1537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1538: FND_MESSAGE.set_name('AMS', 'AMS_NO_AGENDA_TYPE');
1539: FND_MSG_PUB.add;
1540: END IF;
1541: x_return_status := FND_API.g_ret_sts_error;
1542: RETURN;
1543: END IF;
1544:
1545:

Line 1572: x_return_status := FND_API.g_ret_sts_success;

1568: AND parent_id = p_agenda_rec.parent_id);
1569:
1570:
1571: BEGIN
1572: x_return_status := FND_API.g_ret_sts_success;
1573:
1574: -- For create_agenda, when agenda_id is passed in, we need to
1575: -- check if this agenda_id is unique.
1576:

Line 1583: ) = FND_API.g_false

1579: THEN
1580: IF AMS_Utility_PVT.check_uniqueness(
1581: 'ams_agendas_v',
1582: 'agenda_id = ' || p_agenda_rec.agenda_id
1583: ) = FND_API.g_false
1584: THEN
1585: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1586: FND_MESSAGE.set_name('AMS', 'AMS_EVO_DUPLICATE_ID');
1587: FND_MSG_PUB.add;

Line 1589: x_return_status := FND_API.g_ret_sts_error;

1585: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1586: FND_MESSAGE.set_name('AMS', 'AMS_EVO_DUPLICATE_ID');
1587: FND_MSG_PUB.add;
1588: END IF;
1589: x_return_status := FND_API.g_ret_sts_error;
1590: RETURN;
1591: END IF;
1592: END IF;
1593:

Line 1608: x_return_status := FND_API.g_ret_sts_error;

1604: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1605: FND_MESSAGE.set_name ('AMS', 'AMS_DUP_NAME');
1606: FND_MSG_PUB.add;
1607: END IF;
1608: x_return_status := FND_API.g_ret_sts_error;
1609: RETURN;
1610: END IF;
1611: END IF;
1612:

Line 1634: x_return_status := FND_API.g_ret_sts_success;

1630: l_pk_data_type NUMBER;
1631: l_additional_where_clause VARCHAR2(4000);
1632: l_where_clause VARCHAR2(80) := null;
1633: BEGIN
1634: x_return_status := FND_API.g_ret_sts_success;
1635:
1636: --------------------- application_id ------------------------
1637: IF p_agenda_rec.application_id <> FND_API.g_miss_num AND
1638: p_agenda_rec.application_id is NOT NULL

Line 1637: IF p_agenda_rec.application_id <> FND_API.g_miss_num AND

1633: BEGIN
1634: x_return_status := FND_API.g_ret_sts_success;
1635:
1636: --------------------- application_id ------------------------
1637: IF p_agenda_rec.application_id <> FND_API.g_miss_num AND
1638: p_agenda_rec.application_id is NOT NULL
1639: THEN
1640: IF AMS_Utility_PVT.check_fk_exists(
1641: 'fnd_application',

Line 1644: ) = FND_API.g_false

1640: IF AMS_Utility_PVT.check_fk_exists(
1641: 'fnd_application',
1642: 'application_id',
1643: p_agenda_rec.application_id
1644: ) = FND_API.g_false
1645: THEN
1646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1647: THEN
1648: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');

Line 1651: x_return_status := FND_API.g_ret_sts_error;

1647: THEN
1648: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1649: FND_MSG_PUB.add;
1650: END IF;
1651: x_return_status := FND_API.g_ret_sts_error;
1652: RETURN;
1653: END IF;
1654: END IF;
1655:

Line 1660: IF p_agenda_rec.parent_id <> FND_API.g_miss_num

1656:
1657: ----------------------- parent_id/parent_type ------------------------
1658: IF (p_agenda_rec.parent_type = 'EVEO' OR p_agenda_rec.parent_type = 'EONE')
1659: THEN
1660: IF p_agenda_rec.parent_id <> FND_API.g_miss_num
1661: AND p_agenda_rec.parent_id IS NOT NULL THEN
1662: IF AMS_Utility_PVT.check_fk_exists(
1663: 'ams_event_offers_vl',
1664: 'event_offer_id',

Line 1666: ) = FND_API.g_false

1662: IF AMS_Utility_PVT.check_fk_exists(
1663: 'ams_event_offers_vl',
1664: 'event_offer_id',
1665: p_agenda_rec.parent_id
1666: ) = FND_API.g_false
1667: THEN
1668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1669: THEN
1670: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');

Line 1673: x_return_status := FND_API.g_ret_sts_error;

1669: THEN
1670: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
1671: FND_MSG_PUB.add;
1672: END IF;
1673: x_return_status := FND_API.g_ret_sts_error;
1674: RETURN;
1675: END IF;
1676: END IF;
1677: ELSIF p_agenda_rec.parent_type = 'TRACK'

Line 1679: IF p_agenda_rec.parent_id <> FND_API.g_miss_num

1675: END IF;
1676: END IF;
1677: ELSIF p_agenda_rec.parent_type = 'TRACK'
1678: THEN
1679: IF p_agenda_rec.parent_id <> FND_API.g_miss_num
1680: AND p_agenda_rec.parent_id IS NOT NULL THEN
1681: IF AMS_Utility_PVT.check_fk_exists(
1682: 'ams_agendas_v',
1683: 'agenda_id',

Line 1685: ) = FND_API.g_false

1681: IF AMS_Utility_PVT.check_fk_exists(
1682: 'ams_agendas_v',
1683: 'agenda_id',
1684: p_agenda_rec.parent_id
1685: ) = FND_API.g_false
1686: THEN
1687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1688: THEN
1689: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');

Line 1692: x_return_status := FND_API.g_ret_sts_error;

1688: THEN
1689: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
1690: FND_MSG_PUB.add;
1691: END IF;
1692: x_return_status := FND_API.g_ret_sts_error;
1693: RETURN;
1694: END IF;
1695: END IF;
1696: END IF;

Line 1700: IF p_agenda_rec.timezone_id <> FND_API.g_miss_num

1696: END IF;
1697:
1698:
1699: ----------------------- TIMEZONE_ID ------------------------
1700: IF p_agenda_rec.timezone_id <> FND_API.g_miss_num
1701: AND p_agenda_rec.timezone_id IS NOT NULL THEN
1702: IF AMS_Utility_PVT.check_fk_exists(
1703: 'fnd_timezones_b',
1704: 'upgrade_tz_id',

Line 1706: ) = FND_API.g_false

1702: IF AMS_Utility_PVT.check_fk_exists(
1703: 'fnd_timezones_b',
1704: 'upgrade_tz_id',
1705: p_agenda_rec.timezone_id
1706: ) = FND_API.g_false
1707: THEN
1708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1709: THEN
1710: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TIMEZONE_ID');

Line 1713: x_return_status := FND_API.g_ret_sts_error;

1709: THEN
1710: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TIMEZONE_ID');
1711: FND_MSG_PUB.add;
1712: END IF;
1713: x_return_status := FND_API.g_ret_sts_error;
1714: RETURN;
1715: END IF;
1716: END IF;
1717:

Line 1719: IF p_agenda_rec.room_id <> FND_API.g_miss_num

1715: END IF;
1716: END IF;
1717:
1718: ----------------------- room_id ------------------------
1719: IF p_agenda_rec.room_id <> FND_API.g_miss_num
1720: AND p_agenda_rec.room_id IS NOT NULL THEN
1721: IF AMS_Utility_PVT.check_fk_exists(
1722: 'ams_venues_vl',
1723: 'venue_id',

Line 1725: ) = FND_API.g_false

1721: IF AMS_Utility_PVT.check_fk_exists(
1722: 'ams_venues_vl',
1723: 'venue_id',
1724: p_agenda_rec.room_id
1725: ) = FND_API.g_false
1726: THEN
1727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1728: THEN
1729: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_VENUE_ID');

Line 1732: x_return_status := FND_API.g_ret_sts_error;

1728: THEN
1729: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_VENUE_ID');
1730: FND_MSG_PUB.add;
1731: END IF;
1732: x_return_status := FND_API.g_ret_sts_error;
1733: RETURN;
1734: END IF;
1735: END IF;
1736:

Line 1738: IF p_agenda_rec.COORDINATOR_ID <> FND_API.g_miss_num

1734: END IF;
1735: END IF;
1736:
1737: --------------- COORDINATOR_ID -------------------------
1738: IF p_agenda_rec.COORDINATOR_ID <> FND_API.g_miss_num
1739: THEN
1740: l_table_name := 'HZ_PARTIES';
1741: l_pk_name := 'PARTY_ID';
1742: l_pk_value := p_agenda_rec.COORDINATOR_ID;

Line 1747: ) = FND_API.G_FALSE

1743: IF AMS_Utility_PVT.Check_FK_Exists (
1744: p_table_name => l_table_name
1745: ,p_pk_name => l_pk_name
1746: ,p_pk_value => l_pk_value
1747: ) = FND_API.G_FALSE
1748: THEN
1749: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1750: THEN
1751: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');

Line 1754: x_return_status := FND_API.G_RET_STS_ERROR;

1750: THEN
1751: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1752: FND_MSG_PUB.add;
1753: END IF;
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: -- If any errors happen abort API/Procedure.
1756: RETURN;
1757: END IF; -- check_fk_exists
1758: END IF;

Line 1777: x_return_status := FND_API.g_ret_sts_success;

1773: )
1774: IS
1775: BEGIN
1776:
1777: x_return_status := FND_API.g_ret_sts_success;
1778:
1779: ----------------------- agenda_type ------------------------
1780: /*IF p_agenda_rec.agenda_type <> FND_API.g_miss_char
1781: AND p_agenda_rec.agenda_type IS NOT NULL

Line 1780: /*IF p_agenda_rec.agenda_type <> FND_API.g_miss_char

1776:
1777: x_return_status := FND_API.g_ret_sts_success;
1778:
1779: ----------------------- agenda_type ------------------------
1780: /*IF p_agenda_rec.agenda_type <> FND_API.g_miss_char
1781: AND p_agenda_rec.agenda_type IS NOT NULL
1782: THEN
1783: IF AMS_Utility_PVT.check_lookup_exists(
1784: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',

Line 1786: ) = FND_API.g_false

1782: THEN
1783: IF AMS_Utility_PVT.check_lookup_exists(
1784: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1785: p_lookup_code => p_agenda_rec.agenda_type
1786: ) = FND_API.g_false
1787: THEN
1788: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1789: THEN
1790: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TYPE');

Line 1793: x_return_status := FND_API.g_ret_sts_error;

1789: THEN
1790: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TYPE');
1791: FND_MSG_PUB.add;
1792: END IF;
1793: x_return_status := FND_API.g_ret_sts_error;
1794: RETURN;
1795: END IF;
1796: END IF;*/
1797:

Line 1815: x_return_status := FND_API.g_ret_sts_success;

1811: )
1812: IS
1813: BEGIN
1814:
1815: x_return_status := FND_API.g_ret_sts_success;
1816:
1817:
1818: ----------------------- active_flag ------------------------
1819: IF p_agenda_rec.active_flag <> FND_API.g_miss_char

Line 1819: IF p_agenda_rec.active_flag <> FND_API.g_miss_char

1815: x_return_status := FND_API.g_ret_sts_success;
1816:
1817:
1818: ----------------------- active_flag ------------------------
1819: IF p_agenda_rec.active_flag <> FND_API.g_miss_char
1820: AND p_agenda_rec.active_flag IS NOT NULL
1821: THEN
1822: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.active_flag) = FND_API.g_false
1823: THEN

Line 1822: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.active_flag) = FND_API.g_false

1818: ----------------------- active_flag ------------------------
1819: IF p_agenda_rec.active_flag <> FND_API.g_miss_char
1820: AND p_agenda_rec.active_flag IS NOT NULL
1821: THEN
1822: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.active_flag) = FND_API.g_false
1823: THEN
1824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1825: THEN
1826: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_ACTIVE_FLAG');

Line 1829: x_return_status := FND_API.g_ret_sts_error;

1825: THEN
1826: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_ACTIVE_FLAG');
1827: FND_MSG_PUB.add;
1828: END IF;
1829: x_return_status := FND_API.g_ret_sts_error;
1830: RETURN;
1831: END IF;
1832: END IF;
1833:

Line 1835: IF p_agenda_rec.default_track_flag <> FND_API.g_miss_char

1831: END IF;
1832: END IF;
1833:
1834: ----------------------- DEFAULT_TRACK_FLAG ------------------------
1835: IF p_agenda_rec.default_track_flag <> FND_API.g_miss_char
1836: AND p_agenda_rec.default_track_flag IS NOT NULL
1837: THEN
1838: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.default_track_flag) = FND_API.g_false
1839: THEN

Line 1838: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.default_track_flag) = FND_API.g_false

1834: ----------------------- DEFAULT_TRACK_FLAG ------------------------
1835: IF p_agenda_rec.default_track_flag <> FND_API.g_miss_char
1836: AND p_agenda_rec.default_track_flag IS NOT NULL
1837: THEN
1838: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.default_track_flag) = FND_API.g_false
1839: THEN
1840: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1841: THEN
1842: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TRACK_FLAG');

Line 1845: x_return_status := FND_API.g_ret_sts_error;

1841: THEN
1842: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TRACK_FLAG');
1843: FND_MSG_PUB.add;
1844: END IF;
1845: x_return_status := FND_API.g_ret_sts_error;
1846: RETURN;
1847: END IF;
1848: END IF;
1849:

Line 1926: x_return_status := FND_API.G_RET_STS_SUCCESS;

1922:
1923: BEGIN
1924:
1925: -- Initialize API/Procedure return status to success
1926: x_return_status := FND_API.G_RET_STS_SUCCESS;
1927:
1928: -------------------------- Update Mode ----------------------------
1929: -- check if the p_agenda_rec has any columns that should not be updated at this
1930: -- stage as per the business logic.

Line 1942: IF x_return_status <> FND_API.g_ret_sts_success THEN

1938: p_agenda_rec => p_agenda_rec,
1939: x_return_status => x_return_status
1940: );
1941:
1942: IF x_return_status <> FND_API.g_ret_sts_success THEN
1943: RETURN;
1944: END IF;
1945: END IF; */
1946:

Line 1959: RAISE FND_API.g_exc_error;

1955: THEN
1956: Fnd_Message.set_name('AMS', 'AMS_EVT_RES_DATE_NOT_FIT_IN');
1957: Fnd_Msg_Pub.ADD;
1958: END IF;
1959: RAISE FND_API.g_exc_error;
1960: END IF;
1961: END IF; */
1962:
1963:

Line 1985: IF x_return_status <> FND_API.g_ret_sts_success THEN

1981: p_agenda_rec => p_agenda_rec,
1982: x_return_status => x_return_status
1983: );
1984:
1985: IF x_return_status <> FND_API.g_ret_sts_success THEN
1986: RETURN;
1987: END IF;
1988:
1989: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2000: IF x_return_status <> FND_API.g_ret_sts_success THEN

1996: check_agenda_fk_items(
1997: p_agenda_rec => p_agenda_rec,
1998: x_return_status => x_return_status
1999: );
2000: IF x_return_status <> FND_API.g_ret_sts_success THEN
2001: RETURN;
2002: END IF;
2003:
2004: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2015: IF x_return_status <> FND_API.g_ret_sts_success THEN

2011: check_agenda_lookup_items(
2012: p_agenda_rec => p_agenda_rec,
2013: x_return_status => x_return_status
2014: );
2015: IF x_return_status <> FND_API.g_ret_sts_success THEN
2016: RETURN;
2017: END IF;
2018:
2019: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2030: IF x_return_status <> FND_API.g_ret_sts_success THEN

2026: check_agenda_flag_items(
2027: p_agenda_rec => p_agenda_rec,
2028: x_return_status => x_return_status
2029: );
2030: IF x_return_status <> FND_API.g_ret_sts_success THEN
2031: RETURN;
2032: END IF;
2033:
2034: /* If the Event Schedule is CANCELLED/COMPLETED/ARCHIVED /ON_HOLD/CLOSED

Line 2061: RAISE FND_API.g_exc_error;

2057: Fnd_Message.set_name('AMS', 'AMS_NO_TRACK');
2058: Fnd_Msg_Pub.ADD;
2059: END IF;
2060: END IF;
2061: RAISE FND_API.g_exc_error;
2062: END IF;
2063: ELSIF(p_agenda_rec.parent_type = 'TRACK')
2064: THEN
2065: OPEN c_event_status;

Line 2076: RAISE FND_API.g_exc_error;

2072: THEN
2073: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
2074: Fnd_Msg_Pub.ADD;
2075: END IF;
2076: RAISE FND_API.g_exc_error;
2077: END IF;
2078: END IF;
2079:
2080:

Line 2091: RAISE FND_API.g_exc_error;

2087: THEN
2088: Fnd_Message.set_name('AMS', 'AMS_EDTIME_LS_STTIME');
2089: Fnd_Msg_Pub.ADD;
2090: END IF;
2091: RAISE FND_API.g_exc_error;
2092: END IF; -- (p_agenda_rec.start_date_time > p_agenda_rec.end_date_time)
2093:
2094:
2095: /* If we are creating Session, check whether the date of Session is within

Line 2209: RAISE FND_API.g_exc_error;

2205: THEN
2206: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_DATE');
2207: Fnd_Msg_Pub.ADD;
2208: END IF;
2209: RAISE FND_API.g_exc_error;
2210: END IF; -- end of start_date_time < l_event_start_date_time
2211:
2212: IF(to_date(to_char(p_agenda_rec.start_date_time,'DD-MM-YYYY'),'DD-MM-YYYY') = to_date(to_char(l_event_stdate,'DD-MM-YYYY'),'DD-MM-YYYY'))
2213: THEN

Line 2225: RAISE FND_API.g_exc_error;

2221: THEN
2222: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_TIME');
2223: Fnd_Msg_Pub.ADD;
2224: END IF;
2225: RAISE FND_API.g_exc_error;
2226: END IF; --IF( to_date(to_char(p_agenda_rec.start_date_time,'HH24:MI'))
2227: END IF;
2228:
2229: IF(to_date(to_char(p_agenda_rec.end_date_time,'DD-MM-YYYY'),'DD-MM-YYYY') = to_date(to_char(l_event_eddate,'DD-MM-YYYY'),'DD-MM-YYYY'))

Line 2242: RAISE FND_API.g_exc_error;

2238: THEN
2239: Fnd_Message.set_name('AMS', 'AMS_SESSION_GT_EVENT_TIME');
2240: Fnd_Msg_Pub.ADD;
2241: END IF;
2242: RAISE FND_API.g_exc_error;
2243: END IF; --IF( to_date(to_char(p_agenda_rec.start_date_time,'HH24:MI'))
2244: END IF;
2245:
2246: END IF; -- end of if SESSION

Line 2276: IF NOT FND_API.Compatible_API_Call (

2272: l_return_status VARCHAR2(1);
2273:
2274: BEGIN
2275: -- Standard call to check for call compatibility.
2276: IF NOT FND_API.Compatible_API_Call (
2277: l_api_version,
2278: l_api_version,
2279: l_api_name,
2280: G_PACKAGE_NAME)

Line 2282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2278: l_api_version,
2279: l_api_name,
2280: G_PACKAGE_NAME)
2281: THEN
2282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2283: END IF;
2284:
2285: -- Initialize API return status to success
2286: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2286: x_return_status := FND_API.G_RET_STS_SUCCESS;

2282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2283: END IF;
2284:
2285: -- Initialize API return status to success
2286: x_return_status := FND_API.G_RET_STS_SUCCESS;
2287:
2288: END Validate_Agenda_Record;
2289:
2290: /*****************************************************************************************/

Line 2304: x_agenda_rec.agenda_id := FND_API.g_miss_num;

2300: )
2301: IS
2302: BEGIN
2303:
2304: x_agenda_rec.agenda_id := FND_API.g_miss_num;
2305: x_agenda_rec.last_update_date := FND_API.g_miss_date;
2306: x_agenda_rec.last_updated_by := FND_API.g_miss_num;
2307: x_agenda_rec.creation_date := FND_API.g_miss_date;
2308: x_agenda_rec.created_by := FND_API.g_miss_num;

Line 2305: x_agenda_rec.last_update_date := FND_API.g_miss_date;

2301: IS
2302: BEGIN
2303:
2304: x_agenda_rec.agenda_id := FND_API.g_miss_num;
2305: x_agenda_rec.last_update_date := FND_API.g_miss_date;
2306: x_agenda_rec.last_updated_by := FND_API.g_miss_num;
2307: x_agenda_rec.creation_date := FND_API.g_miss_date;
2308: x_agenda_rec.created_by := FND_API.g_miss_num;
2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;

Line 2306: x_agenda_rec.last_updated_by := FND_API.g_miss_num;

2302: BEGIN
2303:
2304: x_agenda_rec.agenda_id := FND_API.g_miss_num;
2305: x_agenda_rec.last_update_date := FND_API.g_miss_date;
2306: x_agenda_rec.last_updated_by := FND_API.g_miss_num;
2307: x_agenda_rec.creation_date := FND_API.g_miss_date;
2308: x_agenda_rec.created_by := FND_API.g_miss_num;
2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;
2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;

Line 2307: x_agenda_rec.creation_date := FND_API.g_miss_date;

2303:
2304: x_agenda_rec.agenda_id := FND_API.g_miss_num;
2305: x_agenda_rec.last_update_date := FND_API.g_miss_date;
2306: x_agenda_rec.last_updated_by := FND_API.g_miss_num;
2307: x_agenda_rec.creation_date := FND_API.g_miss_date;
2308: x_agenda_rec.created_by := FND_API.g_miss_num;
2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;
2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;
2311: x_agenda_rec.application_id := FND_API.g_miss_num;

Line 2308: x_agenda_rec.created_by := FND_API.g_miss_num;

2304: x_agenda_rec.agenda_id := FND_API.g_miss_num;
2305: x_agenda_rec.last_update_date := FND_API.g_miss_date;
2306: x_agenda_rec.last_updated_by := FND_API.g_miss_num;
2307: x_agenda_rec.creation_date := FND_API.g_miss_date;
2308: x_agenda_rec.created_by := FND_API.g_miss_num;
2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;
2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;
2311: x_agenda_rec.application_id := FND_API.g_miss_num;
2312: x_agenda_rec.active_flag := FND_API.g_miss_char;

Line 2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;

2305: x_agenda_rec.last_update_date := FND_API.g_miss_date;
2306: x_agenda_rec.last_updated_by := FND_API.g_miss_num;
2307: x_agenda_rec.creation_date := FND_API.g_miss_date;
2308: x_agenda_rec.created_by := FND_API.g_miss_num;
2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;
2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;
2311: x_agenda_rec.application_id := FND_API.g_miss_num;
2312: x_agenda_rec.active_flag := FND_API.g_miss_char;
2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;

Line 2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;

2306: x_agenda_rec.last_updated_by := FND_API.g_miss_num;
2307: x_agenda_rec.creation_date := FND_API.g_miss_date;
2308: x_agenda_rec.created_by := FND_API.g_miss_num;
2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;
2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;
2311: x_agenda_rec.application_id := FND_API.g_miss_num;
2312: x_agenda_rec.active_flag := FND_API.g_miss_char;
2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;
2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;

Line 2311: x_agenda_rec.application_id := FND_API.g_miss_num;

2307: x_agenda_rec.creation_date := FND_API.g_miss_date;
2308: x_agenda_rec.created_by := FND_API.g_miss_num;
2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;
2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;
2311: x_agenda_rec.application_id := FND_API.g_miss_num;
2312: x_agenda_rec.active_flag := FND_API.g_miss_char;
2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;
2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;
2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;

Line 2312: x_agenda_rec.active_flag := FND_API.g_miss_char;

2308: x_agenda_rec.created_by := FND_API.g_miss_num;
2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;
2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;
2311: x_agenda_rec.application_id := FND_API.g_miss_num;
2312: x_agenda_rec.active_flag := FND_API.g_miss_char;
2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;
2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;
2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;
2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;

Line 2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;

2309: x_agenda_rec.last_update_login := FND_API.g_miss_num;
2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;
2311: x_agenda_rec.application_id := FND_API.g_miss_num;
2312: x_agenda_rec.active_flag := FND_API.g_miss_char;
2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;
2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;
2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;
2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;
2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;

Line 2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;

2310: x_agenda_rec.object_version_number := FND_API.g_miss_num;
2311: x_agenda_rec.application_id := FND_API.g_miss_num;
2312: x_agenda_rec.active_flag := FND_API.g_miss_char;
2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;
2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;
2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;
2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;
2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;
2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;

Line 2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;

2311: x_agenda_rec.application_id := FND_API.g_miss_num;
2312: x_agenda_rec.active_flag := FND_API.g_miss_char;
2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;
2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;
2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;
2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;
2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;
2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;
2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;

Line 2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;

2312: x_agenda_rec.active_flag := FND_API.g_miss_char;
2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;
2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;
2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;
2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;
2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;
2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;
2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;
2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;

Line 2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;

2313: x_agenda_rec.default_track_flag := FND_API.g_miss_char;
2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;
2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;
2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;
2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;
2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;
2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;
2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;
2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;

Line 2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;

2314: x_agenda_rec.coordinator_id := FND_API.g_miss_num;
2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;
2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;
2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;
2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;
2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;
2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;
2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;
2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;

Line 2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;

2315: x_agenda_rec.timezone_id := FND_API.g_miss_num;
2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;
2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;
2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;
2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;
2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;
2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;
2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;
2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;

Line 2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;

2316: x_agenda_rec.attribute_category := FND_API.g_miss_char;
2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;
2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;
2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;
2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;
2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;
2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;
2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;
2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;

Line 2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;

2317: x_agenda_rec.attribute1 := FND_API.g_miss_char;
2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;
2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;
2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;
2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;
2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;
2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;
2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;
2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;

Line 2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;

2318: x_agenda_rec.attribute2 := FND_API.g_miss_char;
2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;
2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;
2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;
2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;
2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;
2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;
2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;
2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;

Line 2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;

2319: x_agenda_rec.attribute3 := FND_API.g_miss_char;
2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;
2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;
2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;
2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;
2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;
2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;
2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;
2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;

Line 2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;

2320: x_agenda_rec.attribute4 := FND_API.g_miss_char;
2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;
2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;
2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;
2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;
2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;
2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;
2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;
2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;

Line 2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;

2321: x_agenda_rec.attribute5 := FND_API.g_miss_char;
2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;
2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;
2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;
2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;
2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;
2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;
2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;
2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;

Line 2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;

2322: x_agenda_rec.attribute6 := FND_API.g_miss_char;
2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;
2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;
2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;
2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;
2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;
2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;
2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;
2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;

Line 2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;

2323: x_agenda_rec.attribute7 := FND_API.g_miss_char;
2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;
2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;
2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;
2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;
2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;
2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;
2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;
2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;

Line 2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;

2324: x_agenda_rec.attribute8 := FND_API.g_miss_char;
2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;
2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;
2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;
2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;
2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;
2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;
2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;
2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;

Line 2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;

2325: x_agenda_rec.attribute9 := FND_API.g_miss_char;
2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;
2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;
2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;
2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;
2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;
2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;
2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;
2333:

Line 2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;

2326: x_agenda_rec.attribute10 := FND_API.g_miss_char;
2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;
2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;
2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;
2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;
2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;
2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;
2333:
2334: x_agenda_rec.description := FND_API.g_miss_char;

Line 2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;

2327: x_agenda_rec.attribute11 := FND_API.g_miss_char;
2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;
2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;
2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;
2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;
2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;
2333:
2334: x_agenda_rec.description := FND_API.g_miss_char;
2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;

Line 2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;

2328: x_agenda_rec.attribute12 := FND_API.g_miss_char;
2329: x_agenda_rec.attribute13 := FND_API.g_miss_char;
2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;
2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;
2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;
2333:
2334: x_agenda_rec.description := FND_API.g_miss_char;
2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;
2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;

Line 2334: x_agenda_rec.description := FND_API.g_miss_char;

2330: x_agenda_rec.attribute14 := FND_API.g_miss_char;
2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;
2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;
2333:
2334: x_agenda_rec.description := FND_API.g_miss_char;
2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;
2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;
2337: x_agenda_rec.parent_id := FND_API.g_miss_num;
2338: x_agenda_rec.parent_type := FND_API.g_miss_char;

Line 2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;

2331: x_agenda_rec.attribute15 := FND_API.g_miss_char;
2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;
2333:
2334: x_agenda_rec.description := FND_API.g_miss_char;
2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;
2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;
2337: x_agenda_rec.parent_id := FND_API.g_miss_num;
2338: x_agenda_rec.parent_type := FND_API.g_miss_char;
2339: x_agenda_rec.agenda_type := FND_API.g_miss_char;

Line 2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;

2332: x_agenda_rec.agenda_name := FND_API.g_miss_char;
2333:
2334: x_agenda_rec.description := FND_API.g_miss_char;
2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;
2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;
2337: x_agenda_rec.parent_id := FND_API.g_miss_num;
2338: x_agenda_rec.parent_type := FND_API.g_miss_char;
2339: x_agenda_rec.agenda_type := FND_API.g_miss_char;
2340: x_agenda_rec.ROOM_ID := FND_API.g_miss_num;

Line 2337: x_agenda_rec.parent_id := FND_API.g_miss_num;

2333:
2334: x_agenda_rec.description := FND_API.g_miss_char;
2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;
2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;
2337: x_agenda_rec.parent_id := FND_API.g_miss_num;
2338: x_agenda_rec.parent_type := FND_API.g_miss_char;
2339: x_agenda_rec.agenda_type := FND_API.g_miss_char;
2340: x_agenda_rec.ROOM_ID := FND_API.g_miss_num;
2341:

Line 2338: x_agenda_rec.parent_type := FND_API.g_miss_char;

2334: x_agenda_rec.description := FND_API.g_miss_char;
2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;
2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;
2337: x_agenda_rec.parent_id := FND_API.g_miss_num;
2338: x_agenda_rec.parent_type := FND_API.g_miss_char;
2339: x_agenda_rec.agenda_type := FND_API.g_miss_char;
2340: x_agenda_rec.ROOM_ID := FND_API.g_miss_num;
2341:
2342: END init_agenda_rec;

Line 2339: x_agenda_rec.agenda_type := FND_API.g_miss_char;

2335: x_agenda_rec.START_DATE_TIME := FND_API.g_miss_date;
2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;
2337: x_agenda_rec.parent_id := FND_API.g_miss_num;
2338: x_agenda_rec.parent_type := FND_API.g_miss_char;
2339: x_agenda_rec.agenda_type := FND_API.g_miss_char;
2340: x_agenda_rec.ROOM_ID := FND_API.g_miss_num;
2341:
2342: END init_agenda_rec;
2343:

Line 2340: x_agenda_rec.ROOM_ID := FND_API.g_miss_num;

2336: x_agenda_rec.END_DATE_TIME := FND_API.g_miss_date;
2337: x_agenda_rec.parent_id := FND_API.g_miss_num;
2338: x_agenda_rec.parent_type := FND_API.g_miss_char;
2339: x_agenda_rec.agenda_type := FND_API.g_miss_char;
2340: x_agenda_rec.ROOM_ID := FND_API.g_miss_num;
2341:
2342: END init_agenda_rec;
2343:
2344:

Line 2380: RAISE FND_API.g_exc_error;

2376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2377: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2378: FND_MSG_PUB.add;
2379: END IF;
2380: RAISE FND_API.g_exc_error;
2381: END IF;
2382:
2383: CLOSE c_agenda;
2384:

Line 2386: IF p_agenda_rec.ACTIVE_FLAG = FND_API.g_miss_char THEN

2382:
2383: CLOSE c_agenda;
2384:
2385:
2386: IF p_agenda_rec.ACTIVE_FLAG = FND_API.g_miss_char THEN
2387: x_agenda_rec.ACTIVE_FLAG := l_agenda_rec.ACTIVE_FLAG;
2388: END IF;
2389:
2390: IF p_agenda_rec.DEFAULT_TRACK_FLAG = FND_API.g_miss_char THEN

Line 2390: IF p_agenda_rec.DEFAULT_TRACK_FLAG = FND_API.g_miss_char THEN

2386: IF p_agenda_rec.ACTIVE_FLAG = FND_API.g_miss_char THEN
2387: x_agenda_rec.ACTIVE_FLAG := l_agenda_rec.ACTIVE_FLAG;
2388: END IF;
2389:
2390: IF p_agenda_rec.DEFAULT_TRACK_FLAG = FND_API.g_miss_char THEN
2391: x_agenda_rec.DEFAULT_TRACK_FLAG := l_agenda_rec.DEFAULT_TRACK_FLAG;
2392: END IF;
2393:
2394: IF p_agenda_rec.room_id = FND_API.g_miss_num THEN

Line 2394: IF p_agenda_rec.room_id = FND_API.g_miss_num THEN

2390: IF p_agenda_rec.DEFAULT_TRACK_FLAG = FND_API.g_miss_char THEN
2391: x_agenda_rec.DEFAULT_TRACK_FLAG := l_agenda_rec.DEFAULT_TRACK_FLAG;
2392: END IF;
2393:
2394: IF p_agenda_rec.room_id = FND_API.g_miss_num THEN
2395: x_agenda_rec.room_id := l_agenda_rec.room_id;
2396: END IF;
2397:
2398: IF p_agenda_rec.SETUP_TYPE_ID = FND_API.g_miss_num THEN

Line 2398: IF p_agenda_rec.SETUP_TYPE_ID = FND_API.g_miss_num THEN

2394: IF p_agenda_rec.room_id = FND_API.g_miss_num THEN
2395: x_agenda_rec.room_id := l_agenda_rec.room_id;
2396: END IF;
2397:
2398: IF p_agenda_rec.SETUP_TYPE_ID = FND_API.g_miss_num THEN
2399: x_agenda_rec.SETUP_TYPE_ID := l_agenda_rec.SETUP_TYPE_ID;
2400: END IF;
2401:
2402:

Line 2403: IF p_agenda_rec.TIMEZONE_ID = FND_API.g_miss_num THEN

2399: x_agenda_rec.SETUP_TYPE_ID := l_agenda_rec.SETUP_TYPE_ID;
2400: END IF;
2401:
2402:
2403: IF p_agenda_rec.TIMEZONE_ID = FND_API.g_miss_num THEN
2404: x_agenda_rec.TIMEZONE_ID := l_agenda_rec.TIMEZONE_ID;
2405: END IF;
2406:
2407: IF p_agenda_rec.PARENT_ID = FND_API.g_miss_num THEN

Line 2407: IF p_agenda_rec.PARENT_ID = FND_API.g_miss_num THEN

2403: IF p_agenda_rec.TIMEZONE_ID = FND_API.g_miss_num THEN
2404: x_agenda_rec.TIMEZONE_ID := l_agenda_rec.TIMEZONE_ID;
2405: END IF;
2406:
2407: IF p_agenda_rec.PARENT_ID = FND_API.g_miss_num THEN
2408: x_agenda_rec.PARENT_ID := l_agenda_rec.PARENT_ID;
2409: END IF;
2410:
2411: IF p_agenda_rec.PARENT_TYPE = FND_API.g_miss_char THEN

Line 2411: IF p_agenda_rec.PARENT_TYPE = FND_API.g_miss_char THEN

2407: IF p_agenda_rec.PARENT_ID = FND_API.g_miss_num THEN
2408: x_agenda_rec.PARENT_ID := l_agenda_rec.PARENT_ID;
2409: END IF;
2410:
2411: IF p_agenda_rec.PARENT_TYPE = FND_API.g_miss_char THEN
2412: x_agenda_rec.PARENT_TYPE := l_agenda_rec.PARENT_TYPE;
2413: END IF;
2414:
2415: IF p_agenda_rec.agenda_type = FND_API.g_miss_char THEN

Line 2415: IF p_agenda_rec.agenda_type = FND_API.g_miss_char THEN

2411: IF p_agenda_rec.PARENT_TYPE = FND_API.g_miss_char THEN
2412: x_agenda_rec.PARENT_TYPE := l_agenda_rec.PARENT_TYPE;
2413: END IF;
2414:
2415: IF p_agenda_rec.agenda_type = FND_API.g_miss_char THEN
2416: x_agenda_rec.agenda_type := l_agenda_rec.agenda_type;
2417: END IF;
2418:
2419: IF p_agenda_rec.application_id = FND_API.g_miss_num THEN

Line 2419: IF p_agenda_rec.application_id = FND_API.g_miss_num THEN

2415: IF p_agenda_rec.agenda_type = FND_API.g_miss_char THEN
2416: x_agenda_rec.agenda_type := l_agenda_rec.agenda_type;
2417: END IF;
2418:
2419: IF p_agenda_rec.application_id = FND_API.g_miss_num THEN
2420: x_agenda_rec.application_id := l_agenda_rec.application_id;
2421: END IF;
2422:
2423: IF p_agenda_rec.created_by = FND_API.g_miss_num THEN

Line 2423: IF p_agenda_rec.created_by = FND_API.g_miss_num THEN

2419: IF p_agenda_rec.application_id = FND_API.g_miss_num THEN
2420: x_agenda_rec.application_id := l_agenda_rec.application_id;
2421: END IF;
2422:
2423: IF p_agenda_rec.created_by = FND_API.g_miss_num THEN
2424: x_agenda_rec.created_by := l_agenda_rec.created_by;
2425: END IF;
2426:
2427: IF p_agenda_rec.last_updated_by = FND_API.g_miss_num THEN

Line 2427: IF p_agenda_rec.last_updated_by = FND_API.g_miss_num THEN

2423: IF p_agenda_rec.created_by = FND_API.g_miss_num THEN
2424: x_agenda_rec.created_by := l_agenda_rec.created_by;
2425: END IF;
2426:
2427: IF p_agenda_rec.last_updated_by = FND_API.g_miss_num THEN
2428: x_agenda_rec.last_updated_by := l_agenda_rec.last_updated_by;
2429: END IF;
2430:
2431: IF p_agenda_rec.START_DATE_TIME = FND_API.g_miss_date THEN

Line 2431: IF p_agenda_rec.START_DATE_TIME = FND_API.g_miss_date THEN

2427: IF p_agenda_rec.last_updated_by = FND_API.g_miss_num THEN
2428: x_agenda_rec.last_updated_by := l_agenda_rec.last_updated_by;
2429: END IF;
2430:
2431: IF p_agenda_rec.START_DATE_TIME = FND_API.g_miss_date THEN
2432: x_agenda_rec.START_DATE_TIME := l_agenda_rec.START_DATE_TIME;
2433: END IF;
2434:
2435: IF p_agenda_rec.END_DATE_TIME = FND_API.g_miss_date THEN

Line 2435: IF p_agenda_rec.END_DATE_TIME = FND_API.g_miss_date THEN

2431: IF p_agenda_rec.START_DATE_TIME = FND_API.g_miss_date THEN
2432: x_agenda_rec.START_DATE_TIME := l_agenda_rec.START_DATE_TIME;
2433: END IF;
2434:
2435: IF p_agenda_rec.END_DATE_TIME = FND_API.g_miss_date THEN
2436: x_agenda_rec.END_DATE_TIME := l_agenda_rec.END_DATE_TIME;
2437: END IF;
2438:
2439:

Line 2441: IF p_agenda_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char THEN

2437: END IF;
2438:
2439:
2440:
2441: IF p_agenda_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char THEN
2442: x_agenda_rec.ATTRIBUTE_CATEGORY := l_agenda_rec.ATTRIBUTE_CATEGORY;
2443: END IF;
2444:
2445: IF p_agenda_rec.ATTRIBUTE1 = FND_API.g_miss_char THEN

Line 2445: IF p_agenda_rec.ATTRIBUTE1 = FND_API.g_miss_char THEN

2441: IF p_agenda_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char THEN
2442: x_agenda_rec.ATTRIBUTE_CATEGORY := l_agenda_rec.ATTRIBUTE_CATEGORY;
2443: END IF;
2444:
2445: IF p_agenda_rec.ATTRIBUTE1 = FND_API.g_miss_char THEN
2446: x_agenda_rec.ATTRIBUTE1 := l_agenda_rec.ATTRIBUTE1;
2447: END IF;
2448:
2449: IF p_agenda_rec.ATTRIBUTE2 = FND_API.g_miss_char THEN

Line 2449: IF p_agenda_rec.ATTRIBUTE2 = FND_API.g_miss_char THEN

2445: IF p_agenda_rec.ATTRIBUTE1 = FND_API.g_miss_char THEN
2446: x_agenda_rec.ATTRIBUTE1 := l_agenda_rec.ATTRIBUTE1;
2447: END IF;
2448:
2449: IF p_agenda_rec.ATTRIBUTE2 = FND_API.g_miss_char THEN
2450: x_agenda_rec.ATTRIBUTE2 := l_agenda_rec.ATTRIBUTE2;
2451: END IF;
2452:
2453: IF p_agenda_rec.ATTRIBUTE3 = FND_API.g_miss_char THEN

Line 2453: IF p_agenda_rec.ATTRIBUTE3 = FND_API.g_miss_char THEN

2449: IF p_agenda_rec.ATTRIBUTE2 = FND_API.g_miss_char THEN
2450: x_agenda_rec.ATTRIBUTE2 := l_agenda_rec.ATTRIBUTE2;
2451: END IF;
2452:
2453: IF p_agenda_rec.ATTRIBUTE3 = FND_API.g_miss_char THEN
2454: x_agenda_rec.ATTRIBUTE3 := l_agenda_rec.ATTRIBUTE3;
2455: END IF;
2456:
2457: IF p_agenda_rec.ATTRIBUTE4 = FND_API.g_miss_char THEN

Line 2457: IF p_agenda_rec.ATTRIBUTE4 = FND_API.g_miss_char THEN

2453: IF p_agenda_rec.ATTRIBUTE3 = FND_API.g_miss_char THEN
2454: x_agenda_rec.ATTRIBUTE3 := l_agenda_rec.ATTRIBUTE3;
2455: END IF;
2456:
2457: IF p_agenda_rec.ATTRIBUTE4 = FND_API.g_miss_char THEN
2458: x_agenda_rec.ATTRIBUTE4 := l_agenda_rec.ATTRIBUTE4;
2459: END IF;
2460:
2461: IF p_agenda_rec.ATTRIBUTE5 = FND_API.g_miss_char THEN

Line 2461: IF p_agenda_rec.ATTRIBUTE5 = FND_API.g_miss_char THEN

2457: IF p_agenda_rec.ATTRIBUTE4 = FND_API.g_miss_char THEN
2458: x_agenda_rec.ATTRIBUTE4 := l_agenda_rec.ATTRIBUTE4;
2459: END IF;
2460:
2461: IF p_agenda_rec.ATTRIBUTE5 = FND_API.g_miss_char THEN
2462: x_agenda_rec.ATTRIBUTE5 := l_agenda_rec.ATTRIBUTE5;
2463: END IF;
2464:
2465: IF p_agenda_rec.ATTRIBUTE6 = FND_API.g_miss_char THEN

Line 2465: IF p_agenda_rec.ATTRIBUTE6 = FND_API.g_miss_char THEN

2461: IF p_agenda_rec.ATTRIBUTE5 = FND_API.g_miss_char THEN
2462: x_agenda_rec.ATTRIBUTE5 := l_agenda_rec.ATTRIBUTE5;
2463: END IF;
2464:
2465: IF p_agenda_rec.ATTRIBUTE6 = FND_API.g_miss_char THEN
2466: x_agenda_rec.ATTRIBUTE6 := l_agenda_rec.ATTRIBUTE6;
2467: END IF;
2468: IF p_agenda_rec.ATTRIBUTE7 = FND_API.g_miss_char THEN
2469: x_agenda_rec.ATTRIBUTE7 := l_agenda_rec.ATTRIBUTE7;

Line 2468: IF p_agenda_rec.ATTRIBUTE7 = FND_API.g_miss_char THEN

2464:
2465: IF p_agenda_rec.ATTRIBUTE6 = FND_API.g_miss_char THEN
2466: x_agenda_rec.ATTRIBUTE6 := l_agenda_rec.ATTRIBUTE6;
2467: END IF;
2468: IF p_agenda_rec.ATTRIBUTE7 = FND_API.g_miss_char THEN
2469: x_agenda_rec.ATTRIBUTE7 := l_agenda_rec.ATTRIBUTE7;
2470: END IF;
2471: IF p_agenda_rec.ATTRIBUTE8 = FND_API.g_miss_char THEN
2472: x_agenda_rec.ATTRIBUTE8 := l_agenda_rec.ATTRIBUTE8;

Line 2471: IF p_agenda_rec.ATTRIBUTE8 = FND_API.g_miss_char THEN

2467: END IF;
2468: IF p_agenda_rec.ATTRIBUTE7 = FND_API.g_miss_char THEN
2469: x_agenda_rec.ATTRIBUTE7 := l_agenda_rec.ATTRIBUTE7;
2470: END IF;
2471: IF p_agenda_rec.ATTRIBUTE8 = FND_API.g_miss_char THEN
2472: x_agenda_rec.ATTRIBUTE8 := l_agenda_rec.ATTRIBUTE8;
2473: END IF;
2474:
2475: IF p_agenda_rec.ATTRIBUTE9 = FND_API.g_miss_char THEN

Line 2475: IF p_agenda_rec.ATTRIBUTE9 = FND_API.g_miss_char THEN

2471: IF p_agenda_rec.ATTRIBUTE8 = FND_API.g_miss_char THEN
2472: x_agenda_rec.ATTRIBUTE8 := l_agenda_rec.ATTRIBUTE8;
2473: END IF;
2474:
2475: IF p_agenda_rec.ATTRIBUTE9 = FND_API.g_miss_char THEN
2476: x_agenda_rec.ATTRIBUTE9 := l_agenda_rec.ATTRIBUTE9;
2477: END IF;
2478:
2479: IF p_agenda_rec.ATTRIBUTE10 = FND_API.g_miss_char THEN

Line 2479: IF p_agenda_rec.ATTRIBUTE10 = FND_API.g_miss_char THEN

2475: IF p_agenda_rec.ATTRIBUTE9 = FND_API.g_miss_char THEN
2476: x_agenda_rec.ATTRIBUTE9 := l_agenda_rec.ATTRIBUTE9;
2477: END IF;
2478:
2479: IF p_agenda_rec.ATTRIBUTE10 = FND_API.g_miss_char THEN
2480: x_agenda_rec.ATTRIBUTE10 := l_agenda_rec.ATTRIBUTE10;
2481: END IF;
2482:
2483: IF p_agenda_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN

Line 2483: IF p_agenda_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN

2479: IF p_agenda_rec.ATTRIBUTE10 = FND_API.g_miss_char THEN
2480: x_agenda_rec.ATTRIBUTE10 := l_agenda_rec.ATTRIBUTE10;
2481: END IF;
2482:
2483: IF p_agenda_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
2484: x_agenda_rec.ATTRIBUTE11 := l_agenda_rec.ATTRIBUTE11;
2485: END IF;
2486:
2487: IF p_agenda_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN

Line 2487: IF p_agenda_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN

2483: IF p_agenda_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
2484: x_agenda_rec.ATTRIBUTE11 := l_agenda_rec.ATTRIBUTE11;
2485: END IF;
2486:
2487: IF p_agenda_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
2488: x_agenda_rec.ATTRIBUTE11 := l_agenda_rec.ATTRIBUTE11;
2489: END IF;
2490:
2491: IF p_agenda_rec.ATTRIBUTE12 = FND_API.g_miss_char THEN

Line 2491: IF p_agenda_rec.ATTRIBUTE12 = FND_API.g_miss_char THEN

2487: IF p_agenda_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
2488: x_agenda_rec.ATTRIBUTE11 := l_agenda_rec.ATTRIBUTE11;
2489: END IF;
2490:
2491: IF p_agenda_rec.ATTRIBUTE12 = FND_API.g_miss_char THEN
2492: x_agenda_rec.ATTRIBUTE12 := l_agenda_rec.ATTRIBUTE12;
2493: END IF;
2494:
2495: IF p_agenda_rec.ATTRIBUTE13 = FND_API.g_miss_char THEN

Line 2495: IF p_agenda_rec.ATTRIBUTE13 = FND_API.g_miss_char THEN

2491: IF p_agenda_rec.ATTRIBUTE12 = FND_API.g_miss_char THEN
2492: x_agenda_rec.ATTRIBUTE12 := l_agenda_rec.ATTRIBUTE12;
2493: END IF;
2494:
2495: IF p_agenda_rec.ATTRIBUTE13 = FND_API.g_miss_char THEN
2496: x_agenda_rec.ATTRIBUTE13 := l_agenda_rec.ATTRIBUTE13;
2497: END IF;
2498:
2499: IF p_agenda_rec.ATTRIBUTE14 = FND_API.g_miss_char THEN

Line 2499: IF p_agenda_rec.ATTRIBUTE14 = FND_API.g_miss_char THEN

2495: IF p_agenda_rec.ATTRIBUTE13 = FND_API.g_miss_char THEN
2496: x_agenda_rec.ATTRIBUTE13 := l_agenda_rec.ATTRIBUTE13;
2497: END IF;
2498:
2499: IF p_agenda_rec.ATTRIBUTE14 = FND_API.g_miss_char THEN
2500: x_agenda_rec.ATTRIBUTE14 := l_agenda_rec.ATTRIBUTE14;
2501: END IF;
2502:
2503: IF p_agenda_rec.ATTRIBUTE15 = FND_API.g_miss_char THEN

Line 2503: IF p_agenda_rec.ATTRIBUTE15 = FND_API.g_miss_char THEN

2499: IF p_agenda_rec.ATTRIBUTE14 = FND_API.g_miss_char THEN
2500: x_agenda_rec.ATTRIBUTE14 := l_agenda_rec.ATTRIBUTE14;
2501: END IF;
2502:
2503: IF p_agenda_rec.ATTRIBUTE15 = FND_API.g_miss_char THEN
2504: x_agenda_rec.ATTRIBUTE15 := l_agenda_rec.ATTRIBUTE15;
2505: END IF;
2506:
2507: END complete_agenda_rec;

Line 2546: x_return_status := FND_API.g_ret_sts_success;

2542: and active_flag = 'Y';
2543:
2544: BEGIN
2545:
2546: x_return_status := FND_API.g_ret_sts_success;
2547:
2548: IF(p_agenda_rec.agenda_type = 'SESSION')
2549: THEN
2550: