[Home] [Help]
55: /*****************************************************************************************/
56:
57: PROCEDURE Create_Act_Resource
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
56:
57: PROCEDURE Create_Act_Resource
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
57: PROCEDURE Create_Act_Resource
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_act_Resource_rec IN act_Resource_rec_type,
94: -- Standard Start of API savepoint
95: SAVEPOINT Create_Act_Resource_PVT;
96:
97: -- Standard call to check for call compatibility.
98: IF NOT FND_API.Compatible_API_Call ( l_api_version,
99: p_api_version,
100: l_api_name,
101: G_PACKAGE_NAME)
102: THEN
99: p_api_version,
100: l_api_name,
101: G_PACKAGE_NAME)
102: THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: -- Initialize message list IF p_init_msg_list is set to TRUE.
107: IF FND_API.to_Boolean( p_init_msg_list )
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: -- Initialize message list IF p_init_msg_list is set to TRUE.
107: IF FND_API.to_Boolean( p_init_msg_list )
108: THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111:
109: FND_MSG_PUB.initialize;
110: END IF;
111:
112: -- Initialize API return status to success
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: ----------------------- validate -----------------------
116: IF (AMS_DEBUG_HIGH_ON) THEN
117:
171: ,x_msg_data => x_msg_data
172: ,p_act_Resource_rec => l_act_Resource_rec
173: );
174:
175: IF l_return_status = FND_API.G_RET_STS_ERROR
176: THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
179: THEN
173: );
174:
175: IF l_return_status = FND_API.G_RET_STS_ERROR
176: THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
179: THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
174:
175: IF l_return_status = FND_API.G_RET_STS_ERROR
176: THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
179: THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182:
176: THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
179: THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182:
183: ----------------------------create----------------------------
184: -- Get ID for activity delivery method FROM sequence.
265: -- set OUT value
266: x_act_resource_id := l_act_Resource_rec.activity_resource_id;
267:
268: -- Standard check of p_commit.
269: IF FND_API.To_Boolean ( p_commit )
270: THEN
271: COMMIT WORK;
272: END IF;
273: -- Standard call to get message count AND IF count is 1, get message info.
273: -- Standard call to get message count AND IF count is 1, get message info.
274: FND_MSG_PUB.Count_AND_Get
275: ( p_count => x_msg_count,
276: p_data => x_msg_data,
277: p_encoded => FND_API.G_FALSE
278: );
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO Create_Act_Resource_PVT;
276: p_data => x_msg_data,
277: p_encoded => FND_API.G_FALSE
278: );
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO Create_Act_Resource_PVT;
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_AND_Get
284: ( p_count => x_msg_count,
278: );
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO Create_Act_Resource_PVT;
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_AND_Get
284: ( p_count => x_msg_count,
285: p_data => x_msg_data,
286: p_encoded => FND_API.G_FALSE
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_AND_Get
284: ( p_count => x_msg_count,
285: p_data => x_msg_data,
286: p_encoded => FND_API.G_FALSE
287: );
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: -- ROLLBACK TO Create_Act_Resource_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284: ( p_count => x_msg_count,
285: p_data => x_msg_data,
286: p_encoded => FND_API.G_FALSE
287: );
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: -- ROLLBACK TO Create_Act_Resource_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
291: FND_MSG_PUB.Count_AND_Get
292: ( p_count => x_msg_count,
286: p_encoded => FND_API.G_FALSE
287: );
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: -- ROLLBACK TO Create_Act_Resource_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
291: FND_MSG_PUB.Count_AND_Get
292: ( p_count => x_msg_count,
293: p_data => x_msg_data,
294: p_encoded => FND_API.G_FALSE
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
291: FND_MSG_PUB.Count_AND_Get
292: ( p_count => x_msg_count,
293: p_data => x_msg_data,
294: p_encoded => FND_API.G_FALSE
295: );
296: WHEN OTHERS THEN
297: ROLLBACK TO Create_Act_Resource_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
294: p_encoded => FND_API.G_FALSE
295: );
296: WHEN OTHERS THEN
297: ROLLBACK TO Create_Act_Resource_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
302: END IF;
303:
304: FND_MSG_PUB.Count_AND_Get
305: ( p_count => x_msg_count,
306: p_data => x_msg_data,
307: p_encoded => FND_API.G_FALSE
308: );
309:
310: END Create_Act_Resource;
311:
324: /*****************************************************************************************/
325:
326: PROCEDURE Update_Act_Resource
327: ( p_api_version IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_commit IN VARCHAR2 := FND_API.G_FALSE,
330: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
325:
326: PROCEDURE Update_Act_Resource
327: ( p_api_version IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_commit IN VARCHAR2 := FND_API.G_FALSE,
330: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
333: x_msg_data OUT NOCOPY VARCHAR2,
326: PROCEDURE Update_Act_Resource
327: ( p_api_version IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_commit IN VARCHAR2 := FND_API.G_FALSE,
330: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
333: x_msg_data OUT NOCOPY VARCHAR2,
334: p_act_Resource_rec IN act_Resource_rec_type
356: BEGIN
357: -- Standard Start of API savepoint
358: SAVEPOINT Update_Act_Resource_PVT;
359: -- Standard call to check for call compatibility.
360: IF NOT FND_API.Compatible_API_Call ( l_api_version,
361: p_api_version,
362: l_api_name,
363: G_PACKAGE_NAME)
364: THEN
361: p_api_version,
362: l_api_name,
363: G_PACKAGE_NAME)
364: THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367:
368: -- Initialize message list IF p_init_msg_list is set to TRUE.
369: IF FND_API.to_Boolean( p_init_msg_list ) THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367:
368: -- Initialize message list IF p_init_msg_list is set to TRUE.
369: IF FND_API.to_Boolean( p_init_msg_list ) THEN
370: FND_MSG_PUB.initialize;
371: END IF;
372:
373: -- Initialize API return status to success
370: FND_MSG_PUB.initialize;
371: END IF;
372:
373: -- Initialize API return status to success
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: complete_act_Resource_rec(
377: p_act_Resource_rec,
378: l_act_Resource_rec
442: p_validation_mode => JTF_PLSQL_API.g_update,
443: x_return_status => l_return_status
444: );
445: -- If any errors happen abort API.
446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
450: THEN
444: );
445: -- If any errors happen abort API.
446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
450: THEN
451: RAISE FND_API.G_EXC_ERROR;
452: END IF;
445: -- If any errors happen abort API.
446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
450: THEN
451: RAISE FND_API.G_EXC_ERROR;
452: END IF;
453: END IF;
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
450: THEN
451: RAISE FND_API.G_EXC_ERROR;
452: END IF;
453: END IF;
454:
455: -- If any errors happen abort API.
452: END IF;
453: END IF;
454:
455: -- If any errors happen abort API.
456: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
457: THEN
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
460: THEN
454:
455: -- If any errors happen abort API.
456: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
457: THEN
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
460: THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
455: -- If any errors happen abort API.
456: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
457: THEN
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
460: THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463:
457: THEN
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
460: THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463:
464: -------------- Perform the database operation UPDATE----------------------
465:
505: THEN -- MMSG
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.Add;
508: END IF;
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: -- Standard check of p_commit.
513: IF FND_API.To_Boolean ( p_commit )
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: -- Standard check of p_commit.
513: IF FND_API.To_Boolean ( p_commit )
514: THEN
515: COMMIT WORK;
516: END IF;
517: -- Standard call to get message count AND IF count is 1, get message info.
517: -- Standard call to get message count AND IF count is 1, get message info.
518: FND_MSG_PUB.Count_AND_Get
519: ( p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => FND_API.G_FALSE
522: );
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO Update_Act_Resource_PVT;
520: p_data => x_msg_data,
521: p_encoded => FND_API.G_FALSE
522: );
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO Update_Act_Resource_PVT;
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: FND_MSG_PUB.Count_AND_Get
528: ( p_count => x_msg_count,
522: );
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO Update_Act_Resource_PVT;
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: FND_MSG_PUB.Count_AND_Get
528: ( p_count => x_msg_count,
529: p_data => x_msg_data,
530: p_encoded => FND_API.G_FALSE
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: FND_MSG_PUB.Count_AND_Get
528: ( p_count => x_msg_count,
529: p_data => x_msg_data,
530: p_encoded => FND_API.G_FALSE
531: );
532:
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO Update_Act_Resource_PVT;
529: p_data => x_msg_data,
530: p_encoded => FND_API.G_FALSE
531: );
532:
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO Update_Act_Resource_PVT;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
536: FND_MSG_PUB.Count_AND_Get
537: ( p_count => x_msg_count,
531: );
532:
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO Update_Act_Resource_PVT;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
536: FND_MSG_PUB.Count_AND_Get
537: ( p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => FND_API.G_FALSE
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
536: FND_MSG_PUB.Count_AND_Get
537: ( p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => FND_API.G_FALSE
540: );
541:
542: WHEN OTHERS THEN
543: ROLLBACK TO Update_Act_Resource_PVT;
540: );
541:
542: WHEN OTHERS THEN
543: ROLLBACK TO Update_Act_Resource_PVT;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
548: END IF;
549:
550: FND_MSG_PUB.Count_AND_Get
551: ( p_count => x_msg_count,
552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE
554: );
555:
556: END Update_Act_Resource;
557:
570: /*****************************************************************************************/
571:
572: PROCEDURE Delete_Act_Resource
573: ( p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE,
576: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_msg_count OUT NOCOPY NUMBER,
571:
572: PROCEDURE Delete_Act_Resource
573: ( p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE,
576: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_msg_count OUT NOCOPY NUMBER,
579: x_msg_data OUT NOCOPY VARCHAR2,
572: PROCEDURE Delete_Act_Resource
573: ( p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE,
576: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_msg_count OUT NOCOPY NUMBER,
579: x_msg_data OUT NOCOPY VARCHAR2,
580: p_act_Resource_id IN NUMBER,
592: -- Standard Start of API savepoint
593: SAVEPOINT Delete_Act_Resource_PVT;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT FND_API.Compatible_API_Call ( l_api_version,
597: p_api_version,
598: l_api_name,
599: G_PACKAGE_NAME)
600: THEN
597: p_api_version,
598: l_api_name,
599: G_PACKAGE_NAME)
600: THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: -- Initialize message list IF p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list )
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: -- Initialize message list IF p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list )
606: THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:
607: FND_MSG_PUB.initialize;
608: END IF;
609:
610: -- Initialize API return status to success
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612:
613: ------------------------------- Perform the database operation---------------
614:
615: DELETE FROM ams_act_resources
620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
621: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
622: FND_MSG_PUB.add;
623: END IF;
624: RAISE FND_API.g_exc_error;
625: END IF;
626:
627:
628: -- Standard check of p_commit.
625: END IF;
626:
627:
628: -- Standard check of p_commit.
629: IF FND_API.To_Boolean ( p_commit )
630: THEN
631: COMMIT WORK;
632: END IF;
633:
634: -- Standard call to get message count AND IF count is 1, get message info.
635: FND_MSG_PUB.Count_AND_Get
636: ( p_count => x_msg_count,
637: p_data => x_msg_data,
638: p_encoded => FND_API.G_FALSE
639: );
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: ROLLBACK TO Delete_Act_Resource_PVT;
637: p_data => x_msg_data,
638: p_encoded => FND_API.G_FALSE
639: );
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: ROLLBACK TO Delete_Act_Resource_PVT;
643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: FND_MSG_PUB.Count_AND_Get
645: ( p_count => x_msg_count,
639: );
640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: ROLLBACK TO Delete_Act_Resource_PVT;
643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: FND_MSG_PUB.Count_AND_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => FND_API.G_FALSE
643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: FND_MSG_PUB.Count_AND_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => FND_API.G_FALSE
648: );
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Delete_Act_Resource_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
645: ( p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => FND_API.G_FALSE
648: );
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Delete_Act_Resource_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: FND_MSG_PUB.Count_AND_Get
653: ( p_count => x_msg_count,
647: p_encoded => FND_API.G_FALSE
648: );
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Delete_Act_Resource_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: FND_MSG_PUB.Count_AND_Get
653: ( p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => FND_API.G_FALSE
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: FND_MSG_PUB.Count_AND_Get
653: ( p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => FND_API.G_FALSE
656: );
657:
658: WHEN OTHERS THEN
659: ROLLBACK TO Delete_Act_Resource_PVT;
656: );
657:
658: WHEN OTHERS THEN
659: ROLLBACK TO Delete_Act_Resource_PVT;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
666:
667: FND_MSG_PUB.Count_AND_Get
668: ( p_count => x_msg_count,
669: p_data => x_msg_data,
670: p_encoded => FND_API.G_FALSE
671: );
672:
673: END Delete_Act_Resource;
674:
687: /*****************************************************************************************/
688:
689: PROCEDURE Lock_Act_Resource
690: ( p_api_version IN NUMBER,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
692: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
693: x_return_status OUT NOCOPY VARCHAR2,
694: x_msg_count OUT NOCOPY NUMBER,
695: x_msg_data OUT NOCOPY VARCHAR2,
688:
689: PROCEDURE Lock_Act_Resource
690: ( p_api_version IN NUMBER,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
692: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
693: x_return_status OUT NOCOPY VARCHAR2,
694: x_msg_count OUT NOCOPY NUMBER,
695: x_msg_data OUT NOCOPY VARCHAR2,
696: p_act_resource_id IN NUMBER,
709: FOR UPDATE of activity_resource_id NOWAIT;
710:
711: BEGIN
712: -- Standard call to check for call compatibility.
713: IF NOT FND_API.Compatible_API_Call ( l_api_version,
714: p_api_version,
715: l_api_name,
716: G_PACKAGE_NAME)
717: THEN
714: p_api_version,
715: l_api_name,
716: G_PACKAGE_NAME)
717: THEN
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;
720:
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722: IF FND_API.to_Boolean( p_init_msg_list )
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;
720:
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722: IF FND_API.to_Boolean( p_init_msg_list )
723: THEN
724: FND_MSG_PUB.initialize;
725: END IF;
726:
724: FND_MSG_PUB.initialize;
725: END IF;
726:
727: -- Initialize API return status to success
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730: OPEN c_act_resource;
731: FETCH c_act_resource INTO l_act_resource_id;
732:
739: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
740: FND_MSG_PUB.Add;
741: END IF;
742:
743: RAISE FND_API.G_EXC_ERROR;
744: END IF;
745: CLOSE c_act_resource;
746: --
747: -- END of API body.
749: -- Standard call to get message count AND IF count is 1, get message info.
750: FND_MSG_PUB.Count_AND_Get
751: ( p_count => x_msg_count,
752: p_data => x_msg_data,
753: p_encoded => FND_API.G_FALSE
754: );
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_ERROR ;
752: p_data => x_msg_data,
753: p_encoded => FND_API.G_FALSE
754: );
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_ERROR ;
758: FND_MSG_PUB.Count_AND_Get
759: ( p_count => x_msg_count,
760: p_data => x_msg_data,
753: p_encoded => FND_API.G_FALSE
754: );
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_ERROR ;
758: FND_MSG_PUB.Count_AND_Get
759: ( p_count => x_msg_count,
760: p_data => x_msg_data,
761: p_encoded => FND_API.G_FALSE
757: x_return_status := FND_API.G_RET_STS_ERROR ;
758: FND_MSG_PUB.Count_AND_Get
759: ( p_count => x_msg_count,
760: p_data => x_msg_data,
761: p_encoded => FND_API.G_FALSE
762: );
763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_AND_Get
759: ( p_count => x_msg_count,
760: p_data => x_msg_data,
761: p_encoded => FND_API.G_FALSE
762: );
763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_AND_Get
766: ( p_count => x_msg_count,
767: p_data => x_msg_data,
760: p_data => x_msg_data,
761: p_encoded => FND_API.G_FALSE
762: );
763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_AND_Get
766: ( p_count => x_msg_count,
767: p_data => x_msg_data,
768: p_encoded => FND_API.G_FALSE
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_AND_Get
766: ( p_count => x_msg_count,
767: p_data => x_msg_data,
768: p_encoded => FND_API.G_FALSE
769: );
770: WHEN AMS_Utility_PVT.resource_locked THEN
771: x_return_status := FND_API.g_ret_sts_error;
772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
767: p_data => x_msg_data,
768: p_encoded => FND_API.G_FALSE
769: );
770: WHEN AMS_Utility_PVT.resource_locked THEN
771: x_return_status := FND_API.g_ret_sts_error;
772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
774: FND_MSG_PUB.add;
775: END IF;
776:
777: FND_MSG_PUB.Count_AND_Get
778: ( p_count => x_msg_count,
779: p_data => x_msg_data,
780: p_encoded => FND_API.G_FALSE
781: );
782: WHEN OTHERS THEN
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
779: p_data => x_msg_data,
780: p_encoded => FND_API.G_FALSE
781: );
782: WHEN OTHERS THEN
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
785: THEN
786: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
787: END IF;
788:
789: FND_MSG_PUB.Count_AND_Get
790: ( p_count => x_msg_count,
791: p_data => x_msg_data,
792: p_encoded => FND_API.G_FALSE
793: );
794: END Lock_Act_Resource;
795:
796: /*****************************************************************************************/
808: /*****************************************************************************************/
809:
810: PROCEDURE Validate_Act_Resource
811: ( p_api_version IN NUMBER,
812: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
813: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
814: x_return_status OUT NOCOPY VARCHAR2,
815: x_msg_count OUT NOCOPY NUMBER,
816: x_msg_data OUT NOCOPY VARCHAR2,
809:
810: PROCEDURE Validate_Act_Resource
811: ( p_api_version IN NUMBER,
812: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
813: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
814: x_return_status OUT NOCOPY VARCHAR2,
815: x_msg_count OUT NOCOPY NUMBER,
816: x_msg_data OUT NOCOPY VARCHAR2,
817: p_act_Resource_rec IN act_Resource_rec_type
827:
828:
829: BEGIN
830: -- Standard call to check for call compatibility.
831: IF NOT FND_API.Compatible_API_Call ( l_api_version,
832: p_api_version,
833: l_api_name,
834: G_PACKAGE_NAME)
835: THEN
832: p_api_version,
833: l_api_name,
834: G_PACKAGE_NAME)
835: THEN
836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837: END IF;
838:
839: -- Initialize message list if p_init_msg_list is set to TRUE.
840: IF FND_API.to_Boolean( p_init_msg_list ) THEN
836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837: END IF;
838:
839: -- Initialize message list if p_init_msg_list is set to TRUE.
840: IF FND_API.to_Boolean( p_init_msg_list ) THEN
841: FND_MSG_PUB.initialize;
842: END IF;
843:
844: -- Initialize API return status to success
841: FND_MSG_PUB.initialize;
842: END IF;
843:
844: -- Initialize API return status to success
845: x_return_status := FND_API.G_RET_STS_SUCCESS;
846:
847: IF (AMS_DEBUG_HIGH_ON) THEN
848:
849:
858: p_validation_mode => JTF_PLSQL_API.g_create,
859: x_return_status => l_return_status
860: );
861:
862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
863: THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
866: THEN
860: );
861:
862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
863: THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
866: THEN
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;
861:
862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
863: THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
866: THEN
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;
869: END IF;
863: THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
866: THEN
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;
869: END IF;
870:
871: -- Perform cross attribute validation AND missing attribute checks. Record
880: p_act_Resource_rec => l_act_Resource_rec,
881: x_return_status => l_return_status
882: );
883:
884: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
885: RAISE FND_API.G_EXC_ERROR;
886: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;
881: x_return_status => l_return_status
882: );
883:
884: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
885: RAISE FND_API.G_EXC_ERROR;
886: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;
889:
882: );
883:
884: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
885: RAISE FND_API.G_EXC_ERROR;
886: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;
889:
890: END IF;
883:
884: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
885: RAISE FND_API.G_EXC_ERROR;
886: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;
889:
890: END IF;
891:
890: END IF;
891:
892: -------------------- finish --------------------------
893: FND_MSG_PUB.count_and_get(
894: p_encoded => FND_API.g_false,
895: p_count => x_msg_count,
896: p_data => x_msg_data
897: );
898: EXCEPTION
895: p_count => x_msg_count,
896: p_data => x_msg_data
897: );
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR ;
901: FND_MSG_PUB.Count_AND_Get
902: ( p_count => x_msg_count,
903: p_data => x_msg_data,
896: p_data => x_msg_data
897: );
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR ;
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
900: x_return_status := FND_API.G_RET_STS_ERROR ;
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: 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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: FND_MSG_PUB.Count_AND_Get
909: ( p_count => x_msg_count,
910: p_data => x_msg_data,
903: p_data => x_msg_data,
904: p_encoded => FND_API.G_FALSE
905: );
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: FND_MSG_PUB.Count_AND_Get
909: ( p_count => x_msg_count,
910: p_data => x_msg_data,
911: p_encoded => FND_API.G_FALSE
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: FND_MSG_PUB.Count_AND_Get
909: ( p_count => x_msg_count,
910: p_data => x_msg_data,
911: p_encoded => FND_API.G_FALSE
912: );
913: WHEN OTHERS THEN
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
910: p_data => x_msg_data,
911: p_encoded => FND_API.G_FALSE
912: );
913: WHEN OTHERS THEN
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
916: THEN
917: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
918: END IF;
919:
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: END Validate_Act_Resource;
926:
927: /*****************************************************************************************/
940: l_valid_flag VARCHAR2(1);
941: l_dummy NUMBER;
942:
943: BEGIN
944: x_return_status := FND_API.g_ret_sts_success;
945:
946: -- For create_act_resource, when activity_resource_id is passed in, we need to
947: -- check if this activity_resource_id is unique.
948:
951: THEN
952: IF AMS_Utility_PVT.check_uniqueness(
953: 'ams_act_resources_v',
954: 'activity_resource_id = ' || p_act_Resource_rec.activity_resource_id
955: ) = FND_API.g_false
956: THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_RES_DUPLICATE_ID');
959: FND_MSG_PUB.add;
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_RES_DUPLICATE_ID');
959: FND_MSG_PUB.add;
960: END IF;
961: x_return_status := FND_API.g_ret_sts_error;
962: RETURN;
963: END IF;
964: END IF;
965:
989: WHERE agenda_id = l_session_id;
990:
991: BEGIN
992:
993: x_return_status := FND_API.g_ret_sts_success;
994:
995:
996: ------------------------ user_status_id --------------------------
997: IF (p_act_Resource_rec.user_status_id IS NULL OR
994:
995:
996: ------------------------ user_status_id --------------------------
997: IF (p_act_Resource_rec.user_status_id IS NULL OR
998: p_act_Resource_rec.user_status_id = FND_API.g_miss_num)
999: THEN
1000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1001: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_USER_STATUS_ID');
1002: FND_MSG_PUB.add;
1000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1001: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_USER_STATUS_ID');
1002: FND_MSG_PUB.add;
1003: END IF;
1004: x_return_status := FND_API.g_ret_sts_error;
1005: END IF;
1006:
1007: ------------------------ application_id --------------------------
1008: /* IF (p_act_Resource_rec.application_id IS NULL OR
1005: END IF;
1006:
1007: ------------------------ application_id --------------------------
1008: /* IF (p_act_Resource_rec.application_id IS NULL OR
1009: p_act_Resource_rec.application_id = FND_API.g_miss_num)
1010: THEN
1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1012: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1013: FND_MSG_PUB.add;
1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1012: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1013: FND_MSG_PUB.add;
1014: END IF;
1015: x_return_status := FND_API.g_ret_sts_error;
1016: RETURN;
1017: END IF; */
1018:
1019: ------------------------ resource_id--------------------------
1017: END IF; */
1018:
1019: ------------------------ resource_id--------------------------
1020: IF (p_act_Resource_rec.resource_id IS NULL OR
1021: p_act_Resource_rec.resource_id = FND_API.g_miss_num)
1022: THEN
1023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1024: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_RESOURCE_ID');
1025: FND_MSG_PUB.add;
1023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1024: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_RESOURCE_ID');
1025: FND_MSG_PUB.add;
1026: END IF;
1027: x_return_status := FND_API.g_ret_sts_error;
1028: RETURN;
1029: ELSE
1030: /* The Session coordinator cannot be booked again at Resource level as
1031: coordinator.
1039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1040: FND_MESSAGE.set_name('AMS', 'AMS_SAME_COORDINATOR_PRESENT');
1041: FND_MSG_PUB.add;
1042: END IF;
1043: x_return_status := FND_API.g_ret_sts_error;
1044: RETURN;
1045: END IF;
1046: END IF;
1047:
1046: END IF;
1047:
1048: ------------------------ role_cd--------------------------
1049: IF (p_act_Resource_rec.role_cd IS NULL OR
1050: p_act_Resource_rec.role_cd = FND_API.g_miss_char)
1051: THEN
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1053: FND_MESSAGE.set_name('AMS', 'AMS_NO_ROLE_CD');
1054: FND_MSG_PUB.add;
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1053: FND_MESSAGE.set_name('AMS', 'AMS_NO_ROLE_CD');
1054: FND_MSG_PUB.add;
1055: END IF;
1056: x_return_status := FND_API.g_ret_sts_error;
1057: RETURN;
1058: END IF;
1059:
1060: ------------ ACT_RESOURCE_USED_BY_ID -------------------------------------
1057: RETURN;
1058: END IF;
1059:
1060: ------------ ACT_RESOURCE_USED_BY_ID -------------------------------------
1061: IF (p_act_Resource_rec.act_resource_used_by_id = FND_API.G_MISS_NUM OR
1062: p_act_Resource_rec.act_resource_used_by_id IS NULL)
1063: THEN
1064: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1065: THEN
1065: THEN
1066: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBYID');
1067: FND_MSG_PUB.add;
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RETURN;
1071: END IF;
1072:
1073: ------------ ACT_RESOURCE_USED_BY_ -------------------------------------
1070: RETURN;
1071: END IF;
1072:
1073: ------------ ACT_RESOURCE_USED_BY_ -------------------------------------
1074: IF (p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY = FND_API.G_MISS_CHAR OR
1075: p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY IS NULL)
1076: THEN
1077: -- missing required fields
1078: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1079: THEN -- MMSG
1080: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBY');
1081: FND_MSG_PUB.add;
1082: END IF;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: -- If any error happens abort API.
1085: RETURN;
1086: END IF;
1087:
1108: l_additional_where_clause VARCHAR2(4000);
1109: l_where_clause VARCHAR2(80) := NULL;
1110:
1111: BEGIN
1112: x_return_status := FND_API.g_ret_sts_success;
1113:
1114:
1115: /*--------------------- application_id ------------------------
1116: IF p_act_Resource_rec.application_id <> FND_API.g_miss_num AND
1112: x_return_status := FND_API.g_ret_sts_success;
1113:
1114:
1115: /*--------------------- application_id ------------------------
1116: IF p_act_Resource_rec.application_id <> FND_API.g_miss_num AND
1117: p_act_Resource_rec.application_id is NOT NULL
1118: THEN
1119: IF AMS_Utility_PVT.check_fk_exists(
1120: 'fnd_application',
1119: IF AMS_Utility_PVT.check_fk_exists(
1120: 'fnd_application',
1121: 'application_id',
1122: p_act_Resource_rec.application_id
1123: ) = FND_API.g_false
1124: THEN
1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1126: THEN
1127: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1126: THEN
1127: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1128: FND_MSG_PUB.add;
1129: END IF;
1130: x_return_status := FND_API.g_ret_sts_error;
1131: RETURN;
1132: END IF;
1133: END IF; */
1134:
1132: END IF;
1133: END IF; */
1134:
1135: ----------------------- user_status_id ------------------------
1136: IF p_act_Resource_rec.user_status_id <> FND_API.g_miss_num
1137: AND p_act_Resource_rec.user_status_id IS NOT NULL THEN
1138: IF AMS_Utility_PVT.check_fk_exists(
1139: 'ams_user_statuses_b',
1140: 'user_status_id',
1138: IF AMS_Utility_PVT.check_fk_exists(
1139: 'ams_user_statuses_b',
1140: 'user_status_id',
1141: p_act_Resource_rec.user_status_id
1142: ) = FND_API.g_false
1143: THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1145: THEN
1146: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_USER_ST_ID');
1146: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_USER_ST_ID');
1147: FND_MSG_PUB.add;
1148: END IF;
1149:
1150: x_return_status := FND_API.g_ret_sts_error;
1151: RETURN;
1152: END IF;
1153: END IF;
1154:
1152: END IF;
1153: END IF;
1154:
1155: --------------- RESOURCE_ID -------------------------
1156: IF p_act_Resource_rec.resource_id <> FND_API.g_miss_num
1157: THEN
1158: l_table_name := 'HZ_PARTIES';
1159: l_pk_name := 'PARTY_ID';
1160: l_pk_value := p_act_Resource_rec.resource_id;
1161: IF AMS_Utility_PVT.Check_FK_Exists (
1162: p_table_name => l_table_name
1163: ,p_pk_name => l_pk_name
1164: ,p_pk_value => l_pk_value
1165: ) = FND_API.G_FALSE
1166: THEN
1167: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1168: THEN
1169: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1168: THEN
1169: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1170: FND_MSG_PUB.add;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: -- If any errors happen abort API/Procedure.
1174: RETURN;
1175: END IF; -- check_fk_exists
1176: END IF;
1175: END IF; -- check_fk_exists
1176: END IF;
1177:
1178: ---------- ACT_RESOURCE_USED_BY_ID-----------------------------
1179: IF p_act_resource_rec.ACT_RESOURCE_USED_BY_ID <> FND_API.g_miss_num
1180: THEN
1181: IF p_act_Resource_rec.arc_act_resource_used_by ='SESSION'
1182: THEN
1183: l_table_name := 'AMS_AGENDAS_B';
1192: IF AMS_Utility_PVT.Check_FK_Exists (
1193: p_table_name => l_table_name
1194: ,p_pk_name => l_pk_name
1195: ,p_pk_value => l_pk_value
1196: ) = FND_API.G_FALSE
1197: THEN
1198: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1199: THEN
1200: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_INVALID_REFERENCE');
1199: THEN
1200: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_INVALID_REFERENCE');
1201: FND_MSG_PUB.add;
1202: END IF;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: -- If any errors happen abort API/Procedure.
1205: RETURN;
1206: END IF; -- check_fk_exists
1207: END IF;
1221: )
1222: IS
1223: BEGIN
1224:
1225: x_return_status := FND_API.g_ret_sts_success;
1226:
1227: ----------------------- role_code ------------------------
1228: IF p_act_Resource_rec.role_cd <> FND_API.g_miss_char
1229: AND p_act_Resource_rec.role_cd IS NOT NULL
1224:
1225: x_return_status := FND_API.g_ret_sts_success;
1226:
1227: ----------------------- role_code ------------------------
1228: IF p_act_Resource_rec.role_cd <> FND_API.g_miss_char
1229: AND p_act_Resource_rec.role_cd IS NOT NULL
1230: THEN
1231: IF AMS_Utility_PVT.check_lookup_exists(
1232: p_lookup_type => 'AMS_EVENT_ROLE',
1230: THEN
1231: IF AMS_Utility_PVT.check_lookup_exists(
1232: p_lookup_type => 'AMS_EVENT_ROLE',
1233: p_lookup_code => p_act_Resource_rec.role_cd
1234: ) = FND_API.g_false
1235: THEN
1236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1237: THEN
1238: FND_MESSAGE.set_name('AMS', 'AMS_BAD_ROLE_TYPE');
1237: THEN
1238: FND_MESSAGE.set_name('AMS', 'AMS_BAD_ROLE_TYPE');
1239: FND_MSG_PUB.add;
1240: END IF;
1241: x_return_status := FND_API.g_ret_sts_error;
1242: RETURN;
1243: END IF;
1244: END IF;
1245:
1243: END IF;
1244: END IF;
1245:
1246: ----------------------- status ------------------------
1247: IF p_act_Resource_rec.system_status_code <> FND_API.g_miss_char
1248: AND p_act_Resource_rec.system_status_code IS NOT NULL
1249: THEN
1250: IF AMS_Utility_PVT.check_lookup_exists(
1251: p_lookup_type => 'AMS_EVENT_AGENDA_STATUS',
1249: THEN
1250: IF AMS_Utility_PVT.check_lookup_exists(
1251: p_lookup_type => 'AMS_EVENT_AGENDA_STATUS',
1252: p_lookup_code => p_act_Resource_rec.system_status_code
1253: ) = FND_API.g_false
1254: THEN
1255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1256: THEN
1257: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BAD_USER_STATUS');
1256: THEN
1257: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BAD_USER_STATUS');
1258: FND_MSG_PUB.add;
1259: END IF;
1260: x_return_status := FND_API.g_ret_sts_error;
1261: RETURN;
1262: END IF;
1263: END IF;
1264:
1262: END IF;
1263: END IF;
1264:
1265: ---------------- ARC_ACT_RESOURCE_USED_BY ------------
1266: IF p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY <> FND_API.g_miss_char THEN
1267: IF AMS_Utility_PVT.check_lookup_exists(
1268: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1269: p_lookup_code => p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY
1270: ) = FND_API.g_false
1266: IF p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY <> FND_API.g_miss_char THEN
1267: IF AMS_Utility_PVT.check_lookup_exists(
1268: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1269: p_lookup_code => p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY
1270: ) = FND_API.g_false
1271: THEN
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1273: THEN
1274: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_SYS_ARC');
1273: THEN
1274: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_SYS_ARC');
1275: FND_MSG_PUB.add;
1276: END IF;
1277: x_return_status := FND_API.g_ret_sts_error;
1278: RETURN;
1279: END IF;
1280: END IF;
1281:
1297: )
1298: IS
1299: BEGIN
1300:
1301: x_return_status := FND_API.g_ret_sts_success;
1302:
1303:
1304: ----------------------- primary_flag ------------------------
1305: /* IF p_act_Resource_rec.primary_flag <> FND_API.g_miss_char
1301: x_return_status := FND_API.g_ret_sts_success;
1302:
1303:
1304: ----------------------- primary_flag ------------------------
1305: /* IF p_act_Resource_rec.primary_flag <> FND_API.g_miss_char
1306: AND p_act_Resource_rec.primary_flag IS NOT NULL
1307: THEN
1308: IF AMS_Utility_PVT.is_Y_or_N(p_act_Resource_rec.primary_flag) = FND_API.g_false
1309: THEN
1304: ----------------------- primary_flag ------------------------
1305: /* IF p_act_Resource_rec.primary_flag <> FND_API.g_miss_char
1306: AND p_act_Resource_rec.primary_flag IS NOT NULL
1307: THEN
1308: IF AMS_Utility_PVT.is_Y_or_N(p_act_Resource_rec.primary_flag) = FND_API.g_false
1309: THEN
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');
1311: THEN
1312: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');
1313: FND_MSG_PUB.add;
1314: END IF;
1315: x_return_status := FND_API.g_ret_sts_error;
1316: RETURN;
1317: END IF;
1318: END IF; */
1319:
1388:
1389:
1390: BEGIN
1391: -- Initialize API/Procedure return status to success
1392: x_return_status := FND_API.G_RET_STS_SUCCESS;
1393:
1394: IF(p_act_Resource_rec.arc_act_resource_used_by = 'SESSION')
1395: THEN
1396: OPEN get_session_date(p_act_Resource_rec.act_resource_used_by_id,p_act_Resource_rec.arc_act_resource_used_by);
1407: THEN
1408: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');
1409: Fnd_Msg_Pub.ADD;
1410: END IF;
1411: RAISE FND_API.g_exc_error;
1412: END IF;
1413:
1414: IF p_act_Resource_rec.start_date_time < l_parent_start_date
1415: THEN
1414: IF p_act_Resource_rec.start_date_time < l_parent_start_date
1415: THEN
1416: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_SES_STTIME');
1417: FND_MSG_PUB.add;
1418: RAISE FND_API.g_exc_error;
1419: ELSIF p_act_Resource_rec.end_date_time > l_parent_end_date
1420: THEN
1421: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_SES_EDTIME');
1422: FND_MSG_PUB.add;
1419: ELSIF p_act_Resource_rec.end_date_time > l_parent_end_date
1420: THEN
1421: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_SES_EDTIME');
1422: FND_MSG_PUB.add;
1423: RAISE FND_API.g_exc_error;
1424: END IF;
1425:
1426: ELSIF(p_act_Resource_rec.arc_act_resource_used_by = 'EVEO'
1427: OR p_act_Resource_rec.arc_act_resource_used_by = 'EONE')
1440: THEN
1441: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');
1442: Fnd_Msg_Pub.ADD;
1443: END IF;
1444: RAISE FND_API.g_exc_error;
1445: END IF;
1446:
1447: l_res_start_date := TO_DATE(TO_CHAR(p_act_Resource_rec.start_date_time,'DD:MM:YYYY'),'DD:MM:YYYY');
1448: l_res_end_date := TO_DATE(TO_CHAR(p_act_Resource_rec.end_date_time,'DD:MM:YYYY'),'DD:MM:YYYY');
1455: THEN
1456: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_GT_PRNT_SD');
1457: FND_MSG_PUB.add;
1458: END IF;
1459: x_return_status := FND_API.g_ret_sts_error;
1460: RETURN;
1461: ELSIF l_res_start_date > l_end_date
1462: THEN
1463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1464: THEN
1465: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_ST_PRNT_ED');
1466: FND_MSG_PUB.add;
1467: END IF;
1468: x_return_status := FND_API.g_ret_sts_error;
1469: RETURN;
1470: ELSIF l_res_start_date = l_start_date
1471: THEN
1472: IF ( TO_CHAR(p_act_Resource_rec.start_date_time,'HH24:MI') <> '00:00'
1478: THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_EVN_STTIME');
1480: FND_MSG_PUB.add;
1481: END IF;
1482: x_return_status := FND_API.g_ret_sts_error;
1483: RETURN;
1484: END IF;
1485: END IF;
1486:
1490: THEN
1491: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_GT_PRNT_SD');
1492: FND_MSG_PUB.add;
1493: END IF;
1494: x_return_status := FND_API.g_ret_sts_error;
1495: RETURN;
1496: ELSIF l_res_end_date > l_end_date
1497: THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_LT_PRNT_ED');
1500: FND_MSG_PUB.add;
1501: END IF;
1502: x_return_status := FND_API.g_ret_sts_error;
1503: RETURN;
1504: ELSIF l_res_end_date = l_end_date
1505: THEN
1506: IF (TO_CHAR(p_act_Resource_rec.end_date_time,'HH24:MI') <> '00:00'
1512: THEN
1513: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_EVN_EDTIME');
1514: FND_MSG_PUB.add;
1515: END IF;
1516: x_return_status := FND_API.g_ret_sts_error;
1517: RETURN;
1518: END IF;
1519: END IF;
1520:
1565: p_act_Resource_rec => p_act_Resource_rec,
1566: x_return_status => x_return_status
1567: );
1568:
1569: IF x_return_status <> FND_API.g_ret_sts_success THEN
1570: RETURN;
1571: END IF;
1572:
1573: IF (AMS_DEBUG_HIGH_ON) THEN
1580: check_Act_Rsc_fk_items(
1581: p_act_Resource_rec => p_act_Resource_rec,
1582: x_return_status => x_return_status
1583: );
1584: IF x_return_status <> FND_API.g_ret_sts_success THEN
1585: RETURN;
1586: END IF;
1587:
1588: IF (AMS_DEBUG_HIGH_ON) THEN
1595: check_Act_Rsc_lookup_items(
1596: p_act_Resource_rec => p_act_Resource_rec,
1597: x_return_status => x_return_status
1598: );
1599: IF x_return_status <> FND_API.g_ret_sts_success THEN
1600: RETURN;
1601: END IF;
1602:
1603: IF (AMS_DEBUG_HIGH_ON) THEN
1610: check_Act_Rsc_flag_items(
1611: p_act_Resource_rec => p_act_Resource_rec,
1612: x_return_status => x_return_status
1613: );
1614: IF x_return_status <> FND_API.g_ret_sts_success THEN
1615: RETURN;
1616: END IF;
1617:
1618:
1623: THEN
1624: FND_MESSAGE.set_name('AMS', 'AMS_EDTIME_LS_STTIME');
1625: FND_MSG_PUB.add;
1626: END IF;
1627: x_return_status := FND_API.g_ret_sts_error;
1628: RETURN;
1629: END IF;
1630:
1631: IF (AMS_DEBUG_HIGH_ON) THEN
1639: p_act_Resource_rec => p_act_Resource_rec,
1640: p_validation_mode => p_validation_mode,
1641: x_return_status => x_return_status
1642: );
1643: IF x_return_status <> FND_API.g_ret_sts_success THEN
1644: RETURN;
1645: END IF;
1646:
1647:
1672: l_count NUMBER := 0;
1673:
1674: BEGIN
1675: -- Standard call to check for call compatibility.
1676: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1677: l_api_version,
1678: l_api_name,
1679: G_PACKAGE_NAME)
1680: THEN
1677: l_api_version,
1678: l_api_name,
1679: G_PACKAGE_NAME)
1680: THEN
1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1682: END IF;
1683:
1684: /* dbiswas commented out the following section of if then else code for bug 2924115 on 28-Apr-2003
1685: IF (p_act_Resource_rec.role_cd = 'COORDINATOR' AND
1713: THEN
1714: FND_MESSAGE.set_name ('AMS', 'AMS_SAME_COORDINATOR_PRESENT');
1715: FND_MSG_PUB.add;
1716: END IF;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718:
1719: ELSE
1720: x_return_status := FND_API.G_RET_STS_SUCCESS;
1721: END IF;
1716: END IF;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718:
1719: ELSE
1720: x_return_status := FND_API.G_RET_STS_SUCCESS;
1721: END IF;
1722:
1723: END IF;
1724: end update by dbiswas on Apr 28, 2003
1722:
1723: END IF;
1724: end update by dbiswas on Apr 28, 2003
1725: */
1726: x_return_status := FND_API.G_RET_STS_SUCCESS;
1727:
1728:
1729: END Validate_Act_Rsc_Record;
1730:
1740: )
1741: IS
1742: BEGIN
1743:
1744: x_act_Resource_rec.act_resource_used_by_id := FND_API.g_miss_num;
1745: x_act_Resource_rec.arc_act_resource_used_by := FND_API.g_miss_char;
1746: x_act_Resource_rec.resource_id := FND_API.g_miss_num;
1747: x_act_Resource_rec.role_cd := FND_API.g_miss_char;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1741: IS
1742: BEGIN
1743:
1744: x_act_Resource_rec.act_resource_used_by_id := FND_API.g_miss_num;
1745: x_act_Resource_rec.arc_act_resource_used_by := FND_API.g_miss_char;
1746: x_act_Resource_rec.resource_id := FND_API.g_miss_num;
1747: x_act_Resource_rec.role_cd := FND_API.g_miss_char;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1742: BEGIN
1743:
1744: x_act_Resource_rec.act_resource_used_by_id := FND_API.g_miss_num;
1745: x_act_Resource_rec.arc_act_resource_used_by := FND_API.g_miss_char;
1746: x_act_Resource_rec.resource_id := FND_API.g_miss_num;
1747: x_act_Resource_rec.role_cd := FND_API.g_miss_char;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1743:
1744: x_act_Resource_rec.act_resource_used_by_id := FND_API.g_miss_num;
1745: x_act_Resource_rec.arc_act_resource_used_by := FND_API.g_miss_char;
1746: x_act_Resource_rec.resource_id := FND_API.g_miss_num;
1747: x_act_Resource_rec.role_cd := FND_API.g_miss_char;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1744: x_act_Resource_rec.act_resource_used_by_id := FND_API.g_miss_num;
1745: x_act_Resource_rec.arc_act_resource_used_by := FND_API.g_miss_char;
1746: x_act_Resource_rec.resource_id := FND_API.g_miss_num;
1747: x_act_Resource_rec.role_cd := FND_API.g_miss_char;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1745: x_act_Resource_rec.arc_act_resource_used_by := FND_API.g_miss_char;
1746: x_act_Resource_rec.resource_id := FND_API.g_miss_num;
1747: x_act_Resource_rec.role_cd := FND_API.g_miss_char;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1746: x_act_Resource_rec.resource_id := FND_API.g_miss_num;
1747: x_act_Resource_rec.role_cd := FND_API.g_miss_char;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1747: x_act_Resource_rec.role_cd := FND_API.g_miss_char;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1748: x_act_Resource_rec.user_status_id := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1749: x_act_Resource_rec.system_status_code := FND_API.g_miss_char;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1750: x_act_Resource_rec.start_date_time := FND_API.g_miss_date;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1751: x_act_Resource_rec.end_date_time := FND_API.g_miss_date;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1752: x_act_Resource_rec.last_update_date := FND_API.g_miss_date;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1753: x_act_Resource_rec.last_updated_by := FND_API.g_miss_num;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1754: x_act_Resource_rec.creation_date := FND_API.g_miss_date;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1755: x_act_Resource_rec.created_by := FND_API.g_miss_num;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1756: x_act_Resource_rec.last_update_login := FND_API.g_miss_num;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1757: x_act_Resource_rec.object_version_number := FND_API.g_miss_num;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1758: --p_act_Resource_rec.application_id := FND_API.g_miss_num;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1759: x_act_Resource_rec.description := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1760: --x_act_Resource_rec.top_level_parten_id := FND_API.g_miss_num;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1761: --x_act_Resource_rec.top_level_parent_type := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1762: x_act_Resource_rec.attribute_category := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1763: x_act_Resource_rec.attribute1 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1764: x_act_Resource_rec.attribute2 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1765: x_act_Resource_rec.attribute3 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1766: x_act_Resource_rec.attribute4 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1774: x_act_Resource_rec.attribute12 := FND_API.g_miss_char;
1767: x_act_Resource_rec.attribute5 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1774: x_act_Resource_rec.attribute12 := FND_API.g_miss_char;
1775: x_act_Resource_rec.attribute13 := FND_API.g_miss_char;
1768: x_act_Resource_rec.attribute6 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1774: x_act_Resource_rec.attribute12 := FND_API.g_miss_char;
1775: x_act_Resource_rec.attribute13 := FND_API.g_miss_char;
1776: x_act_Resource_rec.attribute14 := FND_API.g_miss_char;
1769: x_act_Resource_rec.attribute7 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1774: x_act_Resource_rec.attribute12 := FND_API.g_miss_char;
1775: x_act_Resource_rec.attribute13 := FND_API.g_miss_char;
1776: x_act_Resource_rec.attribute14 := FND_API.g_miss_char;
1777: x_act_Resource_rec.attribute15 := FND_API.g_miss_char;
1770: x_act_Resource_rec.attribute8 := FND_API.g_miss_char;
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1774: x_act_Resource_rec.attribute12 := FND_API.g_miss_char;
1775: x_act_Resource_rec.attribute13 := FND_API.g_miss_char;
1776: x_act_Resource_rec.attribute14 := FND_API.g_miss_char;
1777: x_act_Resource_rec.attribute15 := FND_API.g_miss_char;
1778:
1771: x_act_Resource_rec.attribute9 := FND_API.g_miss_char;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1774: x_act_Resource_rec.attribute12 := FND_API.g_miss_char;
1775: x_act_Resource_rec.attribute13 := FND_API.g_miss_char;
1776: x_act_Resource_rec.attribute14 := FND_API.g_miss_char;
1777: x_act_Resource_rec.attribute15 := FND_API.g_miss_char;
1778:
1779: END init_Act_Rsc_Record;
1772: x_act_Resource_rec.attribute10 := FND_API.g_miss_char;
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1774: x_act_Resource_rec.attribute12 := FND_API.g_miss_char;
1775: x_act_Resource_rec.attribute13 := FND_API.g_miss_char;
1776: x_act_Resource_rec.attribute14 := FND_API.g_miss_char;
1777: x_act_Resource_rec.attribute15 := FND_API.g_miss_char;
1778:
1779: END init_Act_Rsc_Record;
1780:
1773: x_act_Resource_rec.attribute11 := FND_API.g_miss_char;
1774: x_act_Resource_rec.attribute12 := FND_API.g_miss_char;
1775: x_act_Resource_rec.attribute13 := FND_API.g_miss_char;
1776: x_act_Resource_rec.attribute14 := FND_API.g_miss_char;
1777: x_act_Resource_rec.attribute15 := FND_API.g_miss_char;
1778:
1779: END init_Act_Rsc_Record;
1780:
1781:
1799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1800: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1801: FND_MSG_PUB.add;
1802: END IF;
1803: RAISE FND_API.g_exc_error;
1804: END IF;
1805: CLOSE c_resource;
1806:
1807: /* IF p_act_Resource_rec.application_id = FND_API.g_miss_num THEN
1803: RAISE FND_API.g_exc_error;
1804: END IF;
1805: CLOSE c_resource;
1806:
1807: /* IF p_act_Resource_rec.application_id = FND_API.g_miss_num THEN
1808: x_act_Resource_rec.application_id := l_act_Resource_rec.application_id;
1809: END IF; */
1810:
1811: IF p_act_Resource_rec.created_by = FND_API.g_miss_num THEN
1807: /* IF p_act_Resource_rec.application_id = FND_API.g_miss_num THEN
1808: x_act_Resource_rec.application_id := l_act_Resource_rec.application_id;
1809: END IF; */
1810:
1811: IF p_act_Resource_rec.created_by = FND_API.g_miss_num THEN
1812: x_act_Resource_rec.created_by := l_act_Resource_rec.created_by;
1813: END IF;
1814:
1815: IF p_act_Resource_rec.creation_date = FND_API.g_miss_date THEN
1811: IF p_act_Resource_rec.created_by = FND_API.g_miss_num THEN
1812: x_act_Resource_rec.created_by := l_act_Resource_rec.created_by;
1813: END IF;
1814:
1815: IF p_act_Resource_rec.creation_date = FND_API.g_miss_date THEN
1816: x_act_Resource_rec.creation_date := l_act_Resource_rec.creation_date;
1817: END IF;
1818:
1819: IF p_act_Resource_rec.last_updated_by = FND_API.g_miss_num THEN
1815: IF p_act_Resource_rec.creation_date = FND_API.g_miss_date THEN
1816: x_act_Resource_rec.creation_date := l_act_Resource_rec.creation_date;
1817: END IF;
1818:
1819: IF p_act_Resource_rec.last_updated_by = FND_API.g_miss_num THEN
1820: x_act_Resource_rec.last_updated_by := l_act_Resource_rec.last_updated_by;
1821: END IF;
1822:
1823: IF p_act_Resource_rec.last_update_date = FND_API.g_miss_date THEN
1819: IF p_act_Resource_rec.last_updated_by = FND_API.g_miss_num THEN
1820: x_act_Resource_rec.last_updated_by := l_act_Resource_rec.last_updated_by;
1821: END IF;
1822:
1823: IF p_act_Resource_rec.last_update_date = FND_API.g_miss_date THEN
1824: x_act_Resource_rec.last_update_date := l_act_Resource_rec.last_update_date;
1825: END IF;
1826:
1827:
1824: x_act_Resource_rec.last_update_date := l_act_Resource_rec.last_update_date;
1825: END IF;
1826:
1827:
1828: IF p_act_Resource_rec.act_resource_used_by_id = FND_API.g_miss_num THEN
1829: x_act_Resource_rec.act_resource_used_by_id :=l_act_Resource_rec.act_resource_used_by_id;
1830: END IF;
1831:
1832: IF p_act_Resource_rec.arc_act_resource_used_by = FND_API.g_miss_char THEN
1828: IF p_act_Resource_rec.act_resource_used_by_id = FND_API.g_miss_num THEN
1829: x_act_Resource_rec.act_resource_used_by_id :=l_act_Resource_rec.act_resource_used_by_id;
1830: END IF;
1831:
1832: IF p_act_Resource_rec.arc_act_resource_used_by = FND_API.g_miss_char THEN
1833: x_act_Resource_rec.arc_act_resource_used_by := l_act_Resource_rec.arc_act_resource_used_by;
1834: END IF;
1835:
1836: IF p_act_Resource_rec.resource_id = FND_API.g_miss_num THEN
1832: IF p_act_Resource_rec.arc_act_resource_used_by = FND_API.g_miss_char THEN
1833: x_act_Resource_rec.arc_act_resource_used_by := l_act_Resource_rec.arc_act_resource_used_by;
1834: END IF;
1835:
1836: IF p_act_Resource_rec.resource_id = FND_API.g_miss_num THEN
1837: x_act_Resource_rec.resource_id := l_act_Resource_rec.resource_id;
1838: END IF;
1839:
1840: IF p_act_Resource_rec.role_cd = FND_API.g_miss_char THEN
1836: IF p_act_Resource_rec.resource_id = FND_API.g_miss_num THEN
1837: x_act_Resource_rec.resource_id := l_act_Resource_rec.resource_id;
1838: END IF;
1839:
1840: IF p_act_Resource_rec.role_cd = FND_API.g_miss_char THEN
1841: x_act_Resource_rec.role_cd := l_act_Resource_rec.role_cd;
1842: END IF;
1843:
1844:
1841: x_act_Resource_rec.role_cd := l_act_Resource_rec.role_cd;
1842: END IF;
1843:
1844:
1845: IF p_act_Resource_rec.user_status_id = FND_API.g_miss_num THEN
1846: x_act_Resource_rec.user_status_id := l_act_Resource_rec.user_status_id;
1847: END IF;
1848:
1849: IF p_act_Resource_rec.system_status_code = FND_API.g_miss_char THEN
1845: IF p_act_Resource_rec.user_status_id = FND_API.g_miss_num THEN
1846: x_act_Resource_rec.user_status_id := l_act_Resource_rec.user_status_id;
1847: END IF;
1848:
1849: IF p_act_Resource_rec.system_status_code = FND_API.g_miss_char THEN
1850: x_act_Resource_rec.system_status_code := l_act_Resource_rec.system_status_code;
1851: END IF;
1852:
1853: IF p_act_Resource_rec.start_date_time = FND_API.g_miss_date THEN
1849: IF p_act_Resource_rec.system_status_code = FND_API.g_miss_char THEN
1850: x_act_Resource_rec.system_status_code := l_act_Resource_rec.system_status_code;
1851: END IF;
1852:
1853: IF p_act_Resource_rec.start_date_time = FND_API.g_miss_date THEN
1854: x_act_Resource_rec.start_date_time := l_act_Resource_rec.start_date_time;
1855: END IF;
1856:
1857: IF p_act_Resource_rec.end_date_time = FND_API.g_miss_date THEN
1853: IF p_act_Resource_rec.start_date_time = FND_API.g_miss_date THEN
1854: x_act_Resource_rec.start_date_time := l_act_Resource_rec.start_date_time;
1855: END IF;
1856:
1857: IF p_act_Resource_rec.end_date_time = FND_API.g_miss_date THEN
1858: x_act_Resource_rec.end_date_time := l_act_Resource_rec.end_date_time;
1859: END IF;
1860:
1861:
1858: x_act_Resource_rec.end_date_time := l_act_Resource_rec.end_date_time;
1859: END IF;
1860:
1861:
1862: IF p_act_Resource_rec.description = FND_API.g_miss_char THEN
1863: x_act_Resource_rec.description := l_act_Resource_rec.description;
1864: END IF;
1865:
1866: /* IF p_act_Resource_rec.top_level_parten_id = FND_API.g_miss_num THEN
1862: IF p_act_Resource_rec.description = FND_API.g_miss_char THEN
1863: x_act_Resource_rec.description := l_act_Resource_rec.description;
1864: END IF;
1865:
1866: /* IF p_act_Resource_rec.top_level_parten_id = FND_API.g_miss_num THEN
1867: x_act_Resource_rec.top_level_parten_id := l_act_Resource_rec.top_level_parten_id;
1868: END IF;
1869:
1870: IF p_act_Resource_rec.top_level_parten_type = FND_API.g_miss_char THEN
1866: /* IF p_act_Resource_rec.top_level_parten_id = FND_API.g_miss_num THEN
1867: x_act_Resource_rec.top_level_parten_id := l_act_Resource_rec.top_level_parten_id;
1868: END IF;
1869:
1870: IF p_act_Resource_rec.top_level_parten_type = FND_API.g_miss_char THEN
1871: x_act_Resource_rec.top_level_parten_type := l_act_Resource_rec.top_level_parten_type;
1872: END IF;
1873: */
1874: IF p_act_Resource_rec.attribute_category = FND_API.g_miss_char THEN
1870: IF p_act_Resource_rec.top_level_parten_type = FND_API.g_miss_char THEN
1871: x_act_Resource_rec.top_level_parten_type := l_act_Resource_rec.top_level_parten_type;
1872: END IF;
1873: */
1874: IF p_act_Resource_rec.attribute_category = FND_API.g_miss_char THEN
1875: x_act_Resource_rec.attribute_category := l_act_Resource_rec.attribute_CATEGORY;
1876: END IF;
1877:
1878: IF p_act_Resource_rec.attribute1 = FND_API.g_miss_char THEN
1874: IF p_act_Resource_rec.attribute_category = FND_API.g_miss_char THEN
1875: x_act_Resource_rec.attribute_category := l_act_Resource_rec.attribute_CATEGORY;
1876: END IF;
1877:
1878: IF p_act_Resource_rec.attribute1 = FND_API.g_miss_char THEN
1879: x_act_Resource_rec.attribute1 := l_act_Resource_rec.attribute1;
1880: END IF;
1881:
1882: IF p_act_Resource_rec.attribute2 = FND_API.g_miss_char THEN
1878: IF p_act_Resource_rec.attribute1 = FND_API.g_miss_char THEN
1879: x_act_Resource_rec.attribute1 := l_act_Resource_rec.attribute1;
1880: END IF;
1881:
1882: IF p_act_Resource_rec.attribute2 = FND_API.g_miss_char THEN
1883: x_act_Resource_rec.attribute2 := l_act_Resource_rec.attribute2;
1884: END IF;
1885:
1886: IF p_act_Resource_rec.attribute3 = FND_API.g_miss_char THEN
1882: IF p_act_Resource_rec.attribute2 = FND_API.g_miss_char THEN
1883: x_act_Resource_rec.attribute2 := l_act_Resource_rec.attribute2;
1884: END IF;
1885:
1886: IF p_act_Resource_rec.attribute3 = FND_API.g_miss_char THEN
1887: x_act_Resource_rec.attribute3 := l_act_Resource_rec.attribute3;
1888: END IF;
1889:
1890: IF p_act_Resource_rec.attribute4 = FND_API.g_miss_char THEN
1886: IF p_act_Resource_rec.attribute3 = FND_API.g_miss_char THEN
1887: x_act_Resource_rec.attribute3 := l_act_Resource_rec.attribute3;
1888: END IF;
1889:
1890: IF p_act_Resource_rec.attribute4 = FND_API.g_miss_char THEN
1891: x_act_Resource_rec.attribute4 := l_act_Resource_rec.attribute4;
1892: END IF;
1893:
1894: IF p_act_Resource_rec.attribute5 = FND_API.g_miss_char THEN
1890: IF p_act_Resource_rec.attribute4 = FND_API.g_miss_char THEN
1891: x_act_Resource_rec.attribute4 := l_act_Resource_rec.attribute4;
1892: END IF;
1893:
1894: IF p_act_Resource_rec.attribute5 = FND_API.g_miss_char THEN
1895: x_act_Resource_rec.attribute5 := l_act_Resource_rec.attribute5;
1896: END IF;
1897:
1898: IF p_act_Resource_rec.attribute6 = FND_API.g_miss_char THEN
1894: IF p_act_Resource_rec.attribute5 = FND_API.g_miss_char THEN
1895: x_act_Resource_rec.attribute5 := l_act_Resource_rec.attribute5;
1896: END IF;
1897:
1898: IF p_act_Resource_rec.attribute6 = FND_API.g_miss_char THEN
1899: x_act_Resource_rec.attribute6 := l_act_Resource_rec.attribute6;
1900: END IF;
1901:
1902: IF p_act_Resource_rec.attribute7 = FND_API.g_miss_char THEN
1898: IF p_act_Resource_rec.attribute6 = FND_API.g_miss_char THEN
1899: x_act_Resource_rec.attribute6 := l_act_Resource_rec.attribute6;
1900: END IF;
1901:
1902: IF p_act_Resource_rec.attribute7 = FND_API.g_miss_char THEN
1903: x_act_Resource_rec.attribute7 := l_act_Resource_rec.attribute7;
1904: END IF;
1905:
1906: IF p_act_Resource_rec.attribute8 = FND_API.g_miss_char THEN
1902: IF p_act_Resource_rec.attribute7 = FND_API.g_miss_char THEN
1903: x_act_Resource_rec.attribute7 := l_act_Resource_rec.attribute7;
1904: END IF;
1905:
1906: IF p_act_Resource_rec.attribute8 = FND_API.g_miss_char THEN
1907: x_act_Resource_rec.attribute8 := l_act_Resource_rec.attribute8;
1908: END IF;
1909:
1910: IF p_act_Resource_rec.attribute9 = FND_API.g_miss_char THEN
1906: IF p_act_Resource_rec.attribute8 = FND_API.g_miss_char THEN
1907: x_act_Resource_rec.attribute8 := l_act_Resource_rec.attribute8;
1908: END IF;
1909:
1910: IF p_act_Resource_rec.attribute9 = FND_API.g_miss_char THEN
1911: x_act_Resource_rec.attribute9 := l_act_Resource_rec.attribute9;
1912: END IF;
1913:
1914: IF p_act_Resource_rec.attribute10 = FND_API.g_miss_char THEN
1910: IF p_act_Resource_rec.attribute9 = FND_API.g_miss_char THEN
1911: x_act_Resource_rec.attribute9 := l_act_Resource_rec.attribute9;
1912: END IF;
1913:
1914: IF p_act_Resource_rec.attribute10 = FND_API.g_miss_char THEN
1915: x_act_Resource_rec.attribute10 := l_act_Resource_rec.attribute10;
1916: END IF;
1917:
1918: IF p_act_Resource_rec.attribute11 = FND_API.g_miss_char THEN
1914: IF p_act_Resource_rec.attribute10 = FND_API.g_miss_char THEN
1915: x_act_Resource_rec.attribute10 := l_act_Resource_rec.attribute10;
1916: END IF;
1917:
1918: IF p_act_Resource_rec.attribute11 = FND_API.g_miss_char THEN
1919: x_act_Resource_rec.attribute11 := l_act_Resource_rec.attribute11;
1920: END IF;
1921:
1922: IF p_act_Resource_rec.attribute11 = FND_API.g_miss_char THEN
1918: IF p_act_Resource_rec.attribute11 = FND_API.g_miss_char THEN
1919: x_act_Resource_rec.attribute11 := l_act_Resource_rec.attribute11;
1920: END IF;
1921:
1922: IF p_act_Resource_rec.attribute11 = FND_API.g_miss_char THEN
1923: x_act_Resource_rec.attribute11 := l_act_Resource_rec.attribute11;
1924: END IF;
1925:
1926: IF p_act_Resource_rec.attribute12 = FND_API.g_miss_char THEN
1922: IF p_act_Resource_rec.attribute11 = FND_API.g_miss_char THEN
1923: x_act_Resource_rec.attribute11 := l_act_Resource_rec.attribute11;
1924: END IF;
1925:
1926: IF p_act_Resource_rec.attribute12 = FND_API.g_miss_char THEN
1927: x_act_Resource_rec.attribute12 := l_act_Resource_rec.attribute12;
1928: END IF;
1929:
1930: IF p_act_Resource_rec.attribute13 = FND_API.g_miss_char THEN
1926: IF p_act_Resource_rec.attribute12 = FND_API.g_miss_char THEN
1927: x_act_Resource_rec.attribute12 := l_act_Resource_rec.attribute12;
1928: END IF;
1929:
1930: IF p_act_Resource_rec.attribute13 = FND_API.g_miss_char THEN
1931: x_act_Resource_rec.attribute13 := l_act_Resource_rec.attribute13;
1932: END IF;
1933:
1934: IF p_act_Resource_rec.attribute14 = FND_API.g_miss_char THEN
1930: IF p_act_Resource_rec.attribute13 = FND_API.g_miss_char THEN
1931: x_act_Resource_rec.attribute13 := l_act_Resource_rec.attribute13;
1932: END IF;
1933:
1934: IF p_act_Resource_rec.attribute14 = FND_API.g_miss_char THEN
1935: x_act_Resource_rec.attribute14 := l_act_Resource_rec.attribute14;
1936: END IF;
1937:
1938: IF p_act_Resource_rec.attribute15 = FND_API.g_miss_char THEN
1934: IF p_act_Resource_rec.attribute14 = FND_API.g_miss_char THEN
1935: x_act_Resource_rec.attribute14 := l_act_Resource_rec.attribute14;
1936: END IF;
1937:
1938: IF p_act_Resource_rec.attribute15 = FND_API.g_miss_char THEN
1939: x_act_Resource_rec.attribute15 := l_act_Resource_rec.attribute15;
1940: END IF;
1941:
1942: END complete_act_Resource_rec;
2057:
2058: BEGIN
2059:
2060: --Initialize API return status to success
2061: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2062:
2063: /* If we are adding Corinator, we donot check for availability */
2064:
2065: IF (p_act_Resource_rec.role_cd <> 'COORDINATOR' )
2095: So Error out.
2096: */
2097: IF (l_count > 0)
2098: THEN
2099: x_return_status := Fnd_Api.g_ret_sts_error;
2100: GOTO ERROR;
2101: END IF;
2102:
2103: /* If there are no sessions with date overlap, then check all
2118: So Error out.
2119: */
2120: IF (l_count > 0)
2121: THEN
2122: x_return_status := Fnd_Api.g_ret_sts_error;
2123: GOTO ERROR;
2124: END IF;
2125:
2126: ELSIF(p_act_Resource_rec.arc_act_resource_used_by = 'EVEO' OR
2151: So Error out.
2152: */
2153: IF (l_count > 0)
2154: THEN
2155: x_return_status := Fnd_Api.g_ret_sts_error;
2156: GOTO ERROR;
2157: END IF;
2158:
2159: /* If there are no events with date overlap, then check all
2175: So Error out.
2176: */
2177: IF (l_count > 0)
2178: THEN
2179: x_return_status := Fnd_Api.g_ret_sts_error;
2180: GOTO ERROR;
2181: END IF;
2182:
2183: END IF; --IF(p_act_Resource_rec.arc_act_resource_used_by = 'SESSION')
2184:
2185: <
2186: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
2187: THEN
2188: IF( x_return_status = Fnd_Api.g_ret_sts_error) -- to avoid flow though
2189: THEN
2190: IF (p_act_Resource_rec.arc_act_resource_used_by = 'SESSION')
2191: THEN
2192: Fnd_Message.set_name('AMS', 'AMS_SESSION_RESOURCE_BOOKED');