[Home] [Help]
92:
93:
94: PROCEDURE Create_Camp_Schedule(
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
93:
94: PROCEDURE Create_Camp_Schedule(
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
94: PROCEDURE Create_Camp_Schedule(
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
109: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Camp_Schedule';
110: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
111: l_return_status_full VARCHAR2(1);
112: l_object_version_number NUMBER := 1;
113: l_org_id NUMBER := FND_API.G_MISS_NUM;
114: l_schedule_id NUMBER;
115: l_dummy NUMBER;
116:
117: l_schedule_rec schedule_rec_type := p_schedule_rec ;
146: -- Standard Start of API savepoint
147: SAVEPOINT CREATE_Camp_Schedule_PVT;
148:
149: -- Standard call to check for call compatibility.
150: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
151: p_api_version_number,
152: l_api_name,
153: G_PKG_NAME)
154: THEN
151: p_api_version_number,
152: l_api_name,
153: G_PKG_NAME)
154: THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: -- Initialize message list if p_init_msg_list is set to TRUE.
159: IF FND_API.to_Boolean( p_init_msg_list )
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: -- Initialize message list if p_init_msg_list is set to TRUE.
159: IF FND_API.to_Boolean( p_init_msg_list )
160: THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163:
168: END IF;
169:
170:
171: -- Initialize API return status to SUCCESS
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: IF (AMS_DEBUG_HIGH_ON) THEN
175:
176:
184: 'AMS_CAMPAIGN_SCHEDULE_STATUS',
185: l_schedule_rec.status_code,
186: x_return_status
187: );
188: IF x_return_status = FND_API.g_ret_sts_error THEN
189: RAISE FND_API.g_exc_error;
190: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
191: RAISE FND_API.g_exc_unexpected_error;
192: END IF;
185: l_schedule_rec.status_code,
186: x_return_status
187: );
188: IF x_return_status = FND_API.g_ret_sts_error THEN
189: RAISE FND_API.g_exc_error;
190: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
191: RAISE FND_API.g_exc_unexpected_error;
192: END IF;
193: --
186: x_return_status
187: );
188: IF x_return_status = FND_API.g_ret_sts_error THEN
189: RAISE FND_API.g_exc_error;
190: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
191: RAISE FND_API.g_exc_unexpected_error;
192: END IF;
193: --
194: IF (AMS_DEBUG_HIGH_ON) THEN
187: );
188: IF x_return_status = FND_API.g_ret_sts_error THEN
189: RAISE FND_API.g_exc_error;
190: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
191: RAISE FND_API.g_exc_unexpected_error;
192: END IF;
193: --
194: IF (AMS_DEBUG_HIGH_ON) THEN
195:
217: p_setup_id => p_schedule_rec.custom_setup_id,
218: p_cascade_flag => p_schedule_rec.use_parent_code_flag,
219: x_source_code => l_schedule_rec.source_code,
220: x_return_status => x_return_status ) ;
221: IF x_return_status = FND_API.g_ret_sts_error THEN
222: RAISE FND_API.g_exc_error;
223: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
224: RAISE FND_API.g_exc_unexpected_error;
225: END IF;
218: p_cascade_flag => p_schedule_rec.use_parent_code_flag,
219: x_source_code => l_schedule_rec.source_code,
220: x_return_status => x_return_status ) ;
221: IF x_return_status = FND_API.g_ret_sts_error THEN
222: RAISE FND_API.g_exc_error;
223: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
224: RAISE FND_API.g_exc_unexpected_error;
225: END IF;
226: IF (AMS_DEBUG_HIGH_ON) THEN
219: x_source_code => l_schedule_rec.source_code,
220: x_return_status => x_return_status ) ;
221: IF x_return_status = FND_API.g_ret_sts_error THEN
222: RAISE FND_API.g_exc_error;
223: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
224: RAISE FND_API.g_exc_unexpected_error;
225: END IF;
226: IF (AMS_DEBUG_HIGH_ON) THEN
227:
220: x_return_status => x_return_status ) ;
221: IF x_return_status = FND_API.g_ret_sts_error THEN
222: RAISE FND_API.g_exc_error;
223: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
224: RAISE FND_API.g_exc_unexpected_error;
225: END IF;
226: IF (AMS_DEBUG_HIGH_ON) THEN
227:
228: AMS_UTILITY_PVT.debug_message('After handle_shced_source_code');
244: --
245: --
246: -- -- Local variable initialization
247: --
248: IF p_schedule_rec.schedule_id IS NULL OR p_schedule_rec.schedule_id = FND_API.g_miss_num THEN
249: LOOP
250: l_dummy := NULL;
251: OPEN c_id;
252: FETCH c_id INTO l_schedule_id;
267: -- =========================================================================
268: IF FND_GLOBAL.User_Id IS NULL
269: THEN
270: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_USER_PROFILE_MISSING' );
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: -- If activity type code = 'EVENTS' create the underlying event for R12
275: -- dbiswas added extra logic for related_source_id, related_source_code and related_source_object
339: END IF;
340:
341: AMS_EventOffer_PUB.create_EventOffer(
342: p_api_version => 1.0,
343: p_init_msg_list => FND_API.G_FALSE,
344: p_commit => FND_API.G_FALSE,
345: p_validation_level => FND_API.g_valid_level_full,
346: p_evo_rec => l_event_offer_rec,
347: x_return_status => x_return_status,
340:
341: AMS_EventOffer_PUB.create_EventOffer(
342: p_api_version => 1.0,
343: p_init_msg_list => FND_API.G_FALSE,
344: p_commit => FND_API.G_FALSE,
345: p_validation_level => FND_API.g_valid_level_full,
346: p_evo_rec => l_event_offer_rec,
347: x_return_status => x_return_status,
348: x_msg_count => x_msg_count,
341: AMS_EventOffer_PUB.create_EventOffer(
342: p_api_version => 1.0,
343: p_init_msg_list => FND_API.G_FALSE,
344: p_commit => FND_API.G_FALSE,
345: p_validation_level => FND_API.g_valid_level_full,
346: p_evo_rec => l_event_offer_rec,
347: x_return_status => x_return_status,
348: x_msg_count => x_msg_count,
349: x_msg_data => x_msg_data,
355: IF (AMS_DEBUG_HIGH_ON) THEN
356: AMS_UTILITY_PVT.debug_message('after calling create event offer '||l_new_event_offer_id);
357: END IF;
358:
359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363:
356: AMS_UTILITY_PVT.debug_message('after calling create event offer '||l_new_event_offer_id);
357: END IF;
358:
359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363:
364: -- update new schedule with this id
366: l_schedule_rec.related_event_id := l_new_event_offer_id;
367: l_schedule_rec.custom_setup_id :=3000;
368: END IF;
369:
370: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
371: THEN
372: -- Debug message
373: IF (AMS_DEBUG_HIGH_ON) THEN
374:
377:
378: -- Invoke validation procedures
379: Validate_camp_schedule(
380: p_api_version_number => 1.0,
381: p_init_msg_list => FND_API.G_FALSE,
382: p_validation_level => p_validation_level,
383: p_schedule_rec => l_schedule_rec,
384: p_validation_mode => JTF_PLSQL_API.g_create,
385: x_return_status => x_return_status,
386: x_msg_count => x_msg_count,
387: x_msg_data => x_msg_data);
388: END IF;
389:
390: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- Get the functional Currency code
387: x_msg_data => x_msg_data);
388: END IF;
389:
390: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- Get the functional Currency code
395: IF p_schedule_rec.budget_amount_tc IS NOT NULL AND
392: END IF;
393:
394: -- Get the functional Currency code
395: IF p_schedule_rec.budget_amount_tc IS NOT NULL AND
396: p_schedule_rec.budget_amount_tc <> FND_API.G_MISS_NUM
397: THEN
398:
399: AMS_CampaignRules_PVT.Convert_Camp_Currency(
400: p_tc_curr => p_schedule_rec.transaction_currency_code,
528: p_delivery_mode => p_schedule_rec.delivery_mode
529:
530: );
531:
532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535:
536:
529:
530: );
531:
532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535:
536:
537: IF (AMS_DEBUG_HIGH_ON) THEN
587: -- does not have any other schedule associated to it.
588:
589:
590: /* IF p_schedule_rec.trigger_id IS NOT NULL AND
591: p_schedule_rec.trigger_id <> FND_API.G_MISS_NUM AND
592: p_schedule_rec.triggerable_flag IS NOT NULL AND
593: p_schedule_rec.triggerable_flag = 'Y'
594: THEN
595: -- Following code is commented by ptendulk on 16-Jul-2001
615: -- l_camp_rec.channel_id,
616: -- l_camp_rec.arc_channel_from,
617: -- l_return_status
618: -- );
619: -- IF l_return_status = FND_API.g_ret_sts_error THEN
620: -- RAISE FND_API.g_exc_error;
621: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
622: -- RAISE FND_API.g_exc_unexpected_error;
623: -- END IF;
616: -- l_camp_rec.arc_channel_from,
617: -- l_return_status
618: -- );
619: -- IF l_return_status = FND_API.g_ret_sts_error THEN
620: -- RAISE FND_API.g_exc_error;
621: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
622: -- RAISE FND_API.g_exc_unexpected_error;
623: -- END IF;
624: -- END IF;
617: -- l_return_status
618: -- );
619: -- IF l_return_status = FND_API.g_ret_sts_error THEN
620: -- RAISE FND_API.g_exc_error;
621: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
622: -- RAISE FND_API.g_exc_unexpected_error;
623: -- END IF;
624: -- END IF;
625:
618: -- );
619: -- IF l_return_status = FND_API.g_ret_sts_error THEN
620: -- RAISE FND_API.g_exc_error;
621: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
622: -- RAISE FND_API.g_exc_unexpected_error;
623: -- END IF;
624: -- END IF;
625:
626: -- attach seeded metrics to created schedules
636: IF (AMS_DEBUG_HIGH_ON) THEN
637:
638: AMS_Utility_PVT.debug_message('Metrics Copied Status '||x_return_status);
639: END IF;
640: IF x_return_status = FND_API.g_ret_sts_error THEN
641: RAISE FND_API.g_exc_error;
642: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
643: IF (AMS_DEBUG_HIGH_ON) THEN
644:
637:
638: AMS_Utility_PVT.debug_message('Metrics Copied Status '||x_return_status);
639: END IF;
640: IF x_return_status = FND_API.g_ret_sts_error THEN
641: RAISE FND_API.g_exc_error;
642: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
643: IF (AMS_DEBUG_HIGH_ON) THEN
644:
645: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);
638: AMS_Utility_PVT.debug_message('Metrics Copied Status '||x_return_status);
639: END IF;
640: IF x_return_status = FND_API.g_ret_sts_error THEN
641: RAISE FND_API.g_exc_error;
642: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
643: IF (AMS_DEBUG_HIGH_ON) THEN
644:
645: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);
646: END IF;
643: IF (AMS_DEBUG_HIGH_ON) THEN
644:
645: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);
646: END IF;
647: RAISE FND_API.g_exc_unexpected_error;
648: END IF;
649:
650: IF (AMS_DEBUG_HIGH_ON) THEN
651:
658: AMS_ScheduleRules_PVT.Create_list(
659: p_schedule_id => l_schedule_id,
660: p_schedule_name => p_schedule_rec.schedule_name,
661: p_owner_id => p_schedule_rec.owner_user_id) ;
662: IF x_return_status = FND_API.g_ret_sts_error THEN
663: RAISE FND_API.g_exc_error;
664: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
665: IF (AMS_DEBUG_HIGH_ON) THEN
666:
659: p_schedule_id => l_schedule_id,
660: p_schedule_name => p_schedule_rec.schedule_name,
661: p_owner_id => p_schedule_rec.owner_user_id) ;
662: IF x_return_status = FND_API.g_ret_sts_error THEN
663: RAISE FND_API.g_exc_error;
664: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
665: IF (AMS_DEBUG_HIGH_ON) THEN
666:
667: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);
660: p_schedule_name => p_schedule_rec.schedule_name,
661: p_owner_id => p_schedule_rec.owner_user_id) ;
662: IF x_return_status = FND_API.g_ret_sts_error THEN
663: RAISE FND_API.g_exc_error;
664: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
665: IF (AMS_DEBUG_HIGH_ON) THEN
666:
667: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);
668: END IF;
665: IF (AMS_DEBUG_HIGH_ON) THEN
666:
667: AMS_Utility_PVT.debug_message('Errr '||sqlerrm);
668: END IF;
669: RAISE FND_API.g_exc_unexpected_error;
670: END IF;
671: END IF ;
672:
673: x_schedule_id := l_schedule_id ;
675: -- End of API body
676: --
677:
678: -- Standard check for p_commit
679: IF FND_API.to_Boolean( p_commit )
680: THEN
681: COMMIT WORK;
682: END IF;
683:
694: );
695: EXCEPTION
696:
697: WHEN AMS_Utility_PVT.resource_locked THEN
698: x_return_status := FND_API.g_ret_sts_error;
699: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
700:
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO CREATE_Camp_Schedule_PVT;
697: WHEN AMS_Utility_PVT.resource_locked THEN
698: x_return_status := FND_API.g_ret_sts_error;
699: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
700:
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO CREATE_Camp_Schedule_PVT;
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
699: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
700:
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO CREATE_Camp_Schedule_PVT;
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
702: ROLLBACK TO CREATE_Camp_Schedule_PVT;
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data
709: );
710:
707: p_count => x_msg_count,
708: p_data => x_msg_data
709: );
710:
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: ROLLBACK TO CREATE_Camp_Schedule_PVT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: -- Standard call to get message count and if count=1, get the message
715: FND_MSG_PUB.Count_And_Get (
709: );
710:
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: ROLLBACK TO CREATE_Camp_Schedule_PVT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: -- Standard call to get message count and if count=1, get the message
715: FND_MSG_PUB.Count_And_Get (
716: p_encoded => FND_API.G_FALSE,
717: p_count => x_msg_count,
712: ROLLBACK TO CREATE_Camp_Schedule_PVT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: -- Standard call to get message count and if count=1, get the message
715: FND_MSG_PUB.Count_And_Get (
716: p_encoded => FND_API.G_FALSE,
717: p_count => x_msg_count,
718: p_data => x_msg_data
719: );
720:
719: );
720:
721: WHEN OTHERS THEN
722: ROLLBACK TO CREATE_Camp_Schedule_PVT;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
725: THEN
726: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
727: END IF;
726: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
727: END IF;
728: -- Standard call to get message count and if count=1, get the message
729: FND_MSG_PUB.Count_And_Get (
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data
733: );
734: End Create_Camp_Schedule;
756: -- 29-May-2006 srivikri added column delivery_mode
757: --===================================================================
758: PROCEDURE Update_Camp_Schedule(
759: p_api_version_number IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763:
764: x_return_status OUT NOCOPY VARCHAR2,
757: --===================================================================
758: PROCEDURE Update_Camp_Schedule(
759: p_api_version_number IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763:
764: x_return_status OUT NOCOPY VARCHAR2,
765: x_msg_count OUT NOCOPY NUMBER,
758: PROCEDURE Update_Camp_Schedule(
759: p_api_version_number IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763:
764: x_return_status OUT NOCOPY VARCHAR2,
765: x_msg_count OUT NOCOPY NUMBER,
766: x_msg_data OUT NOCOPY VARCHAR2,
811: -- Standard Start of API savepoint
812: SAVEPOINT UPDATE_Camp_Schedule_PVT;
813:
814: -- Standard call to check for call compatibility.
815: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
816: p_api_version_number,
817: l_api_name,
818: G_PKG_NAME)
819: THEN
816: p_api_version_number,
817: l_api_name,
818: G_PKG_NAME)
819: THEN
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822:
823: -- Initialize message list if p_init_msg_list is set to TRUE.
824: IF FND_API.to_Boolean( p_init_msg_list )
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822:
823: -- Initialize message list if p_init_msg_list is set to TRUE.
824: IF FND_API.to_Boolean( p_init_msg_list )
825: THEN
826: FND_MSG_PUB.initialize;
827: END IF;
828:
833: END IF;
834:
835:
836: -- Initialize API return status to SUCCESS
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838:
839: -- Debug Message
840: IF (AMS_DEBUG_HIGH_ON) THEN
841:
852: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
853: FND_MESSAGE.Set_Token ('INFO', 'Camp_Schedule', FALSE);
854: FND_MSG_PUB.Add;
855: END IF;
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858: -- Debug Message
859: IF (AMS_DEBUG_HIGH_ON) THEN
860:
863: CLOSE c_get_Camp_Schedule;
864:
865:
866: IF (l_tar_schedule_rec.object_version_number IS NULL OR
867: l_tar_schedule_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
868: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
869: THEN
870: FND_MESSAGE.Set_Name('AMS', 'API_VERSION_MISSING');
871: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
870: FND_MESSAGE.Set_Name('AMS', 'API_VERSION_MISSING');
871: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
872: FND_MSG_PUB.ADD;
873: END IF;
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876:
877: -- Check Whether record has been changed by someone else
878: IF (l_tar_schedule_rec.object_version_number <> l_ref_schedule_rec.object_version_number) Then
881: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
882: FND_MESSAGE.Set_Token('INFO', 'Camp_Schedule', FALSE);
883: FND_MSG_PUB.ADD;
884: END IF;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;
887:
888: Complete_schedule_Rec(P_schedule_rec => p_schedule_rec ,
889: x_complete_rec => l_complete_rec);
903: OR l_complete_rec.trig_repeat_flag <> l_trig_repeat_flag
904: OR l_complete_rec.tgrp_exclude_prev_flag <> l_tgrp_exclude_prev_flag)
905: THEN
906: AMS_Utility_PVT.Error_Message('AMS_TRIG_DETAILS_NO_UPDATE');
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910: END IF;
911: -- End: added by anchaudh for trigger related validation on 28-May-2003.
904: OR l_complete_rec.tgrp_exclude_prev_flag <> l_tgrp_exclude_prev_flag)
905: THEN
906: AMS_Utility_PVT.Error_Message('AMS_TRIG_DETAILS_NO_UPDATE');
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910: END IF;
911: -- End: added by anchaudh for trigger related validation on 28-May-2003.
912:
1058: , l_field_ak_name_array
1059: , l_change_indicator_array
1060: , x_return_status);
1061:
1062: IF x_return_status = FND_API.g_ret_sts_error THEN
1063: RAISE FND_API.g_exc_error;
1064: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1065: RAISE FND_API.g_exc_unexpected_error;
1066: END IF;
1059: , l_change_indicator_array
1060: , x_return_status);
1061:
1062: IF x_return_status = FND_API.g_ret_sts_error THEN
1063: RAISE FND_API.g_exc_error;
1064: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1065: RAISE FND_API.g_exc_unexpected_error;
1066: END IF;
1067:
1060: , x_return_status);
1061:
1062: IF x_return_status = FND_API.g_ret_sts_error THEN
1063: RAISE FND_API.g_exc_error;
1064: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1065: RAISE FND_API.g_exc_unexpected_error;
1066: END IF;
1067:
1068: -- End Locking Rule API Validation
1061:
1062: IF x_return_status = FND_API.g_ret_sts_error THEN
1063: RAISE FND_API.g_exc_error;
1064: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1065: RAISE FND_API.g_exc_unexpected_error;
1066: END IF;
1067:
1068: -- End Locking Rule API Validation
1069:
1077: ELSE
1078: l_tar_schedule_rec.campaign_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
1079: END IF;
1080:
1081: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
1082: THEN
1083: -- Debug message
1084: IF (AMS_DEBUG_HIGH_ON) THEN
1085:
1088:
1089: -- Invoke validation procedures
1090: Validate_camp_schedule(
1091: p_api_version_number => 1.0,
1092: p_init_msg_list => FND_API.G_FALSE,
1093: p_validation_level => p_validation_level,
1094: p_schedule_rec => p_schedule_rec,
1095: p_validation_mode => JTF_PLSQL_API.g_update,
1096: x_return_status => x_return_status,
1097: x_msg_count => x_msg_count,
1098: x_msg_data => x_msg_data);
1099: END IF;
1100:
1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105: -- Check Schedule Update
1098: x_msg_data => x_msg_data);
1099: END IF;
1100:
1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105: -- Check Schedule Update
1106: AMS_ScheduleRules_PVT.Check_Schedule_Update(
1106: AMS_ScheduleRules_PVT.Check_Schedule_Update(
1107: p_schedule_rec => l_complete_rec,
1108: x_return_status => x_return_status);
1109:
1110: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113: -- Handle Source Code update
1114:
1107: p_schedule_rec => l_complete_rec,
1108: x_return_status => x_return_status);
1109:
1110: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113: -- Handle Source Code update
1114:
1115: if p_schedule_rec.source_code IS NULL THEN
1117:
1118: AMS_Utility_PVT.debug_message(l_api_name ||': update source code');
1119: END IF;
1120: end if ;
1121: IF p_schedule_rec.use_parent_code_flag = FND_API.g_miss_char
1122: AND p_schedule_rec.source_code = FND_API.g_miss_char
1123: THEN
1124: -- following line added by soagrawa on 20-mar-2002
1125: l_source_code := l_ref_schedule_rec.source_code;
1118: AMS_Utility_PVT.debug_message(l_api_name ||': update source code');
1119: END IF;
1120: end if ;
1121: IF p_schedule_rec.use_parent_code_flag = FND_API.g_miss_char
1122: AND p_schedule_rec.source_code = FND_API.g_miss_char
1123: THEN
1124: -- following line added by soagrawa on 20-mar-2002
1125: l_source_code := l_ref_schedule_rec.source_code;
1126: -- NULL ;
1138: IF (AMS_DEBUG_HIGH_ON) THEN
1139:
1140: AMS_Utility_PVT.debug_message(l_api_name ||': updated source code '||l_source_code);
1141: END IF;
1142: IF x_return_status = FND_API.g_ret_sts_error THEN
1143: RAISE FND_API.g_exc_error;
1144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1145: RAISE FND_API.g_exc_unexpected_error;
1146: END IF;
1139:
1140: AMS_Utility_PVT.debug_message(l_api_name ||': updated source code '||l_source_code);
1141: END IF;
1142: IF x_return_status = FND_API.g_ret_sts_error THEN
1143: RAISE FND_API.g_exc_error;
1144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1145: RAISE FND_API.g_exc_unexpected_error;
1146: END IF;
1147:
1140: AMS_Utility_PVT.debug_message(l_api_name ||': updated source code '||l_source_code);
1141: END IF;
1142: IF x_return_status = FND_API.g_ret_sts_error THEN
1143: RAISE FND_API.g_exc_error;
1144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1145: RAISE FND_API.g_exc_unexpected_error;
1146: END IF;
1147:
1148:
1141: END IF;
1142: IF x_return_status = FND_API.g_ret_sts_error THEN
1143: RAISE FND_API.g_exc_error;
1144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1145: RAISE FND_API.g_exc_unexpected_error;
1146: END IF;
1147:
1148:
1149:
1150: END IF ;
1151:
1152: -- Get the functional Currency code
1153: IF p_schedule_rec.budget_amount_tc IS NOT NULL AND
1154: p_schedule_rec.budget_amount_tc <> FND_API.G_MISS_NUM THEN
1155: IF (AMS_DEBUG_HIGH_ON) THEN
1156:
1157: AMS_Utility_pvt.debug_message('Transaction curr : '||p_schedule_rec.transaction_currency_code);
1158: END IF;
1169: --refer to bug# 2406677
1170:
1171: -- Change the owner in Access table if the owner is changed.
1172:
1173: IF p_schedule_rec.owner_user_id <> FND_API.g_miss_num
1174: THEN
1175: AMS_ScheduleRules_PVT.Update_Schedule_Owner(
1176: p_api_version => p_api_version_number,
1177: p_init_msg_list => p_init_msg_list,
1183: p_object_type => 'CSCH' ,
1184: p_schedule_id => p_schedule_rec.schedule_id,
1185: p_owner_id => p_schedule_rec.owner_user_id
1186: );
1187: IF x_return_status = FND_API.g_ret_sts_error THEN
1188: RAISE FND_API.g_exc_error;
1189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1190: RAISE FND_API.g_exc_unexpected_error;
1191: END IF;
1184: p_schedule_id => p_schedule_rec.schedule_id,
1185: p_owner_id => p_schedule_rec.owner_user_id
1186: );
1187: IF x_return_status = FND_API.g_ret_sts_error THEN
1188: RAISE FND_API.g_exc_error;
1189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1190: RAISE FND_API.g_exc_unexpected_error;
1191: END IF;
1192: END IF ;
1185: p_owner_id => p_schedule_rec.owner_user_id
1186: );
1187: IF x_return_status = FND_API.g_ret_sts_error THEN
1188: RAISE FND_API.g_exc_error;
1189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1190: RAISE FND_API.g_exc_unexpected_error;
1191: END IF;
1192: END IF ;
1193:
1186: );
1187: IF x_return_status = FND_API.g_ret_sts_error THEN
1188: RAISE FND_API.g_exc_error;
1189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1190: RAISE FND_API.g_exc_unexpected_error;
1191: END IF;
1192: END IF ;
1193:
1194:
1208: p_created_by => G_USER_ID,
1209: p_last_update_login => G_LOGIN_ID,
1210: p_object_version_number => p_schedule_rec.object_version_number ,
1211: p_campaign_id => p_schedule_rec.campaign_id,
1212: p_user_status_id => FND_API.G_MISS_NUM,
1213: p_status_code => FND_API.G_MISS_CHAR,
1214: p_status_date => FND_API.G_MISS_DATE,
1215: -- modified on 12-dec-2001 by soagrawa, bug# 2133264
1216: -- p_source_code => p_schedule_rec.source_code,
1209: p_last_update_login => G_LOGIN_ID,
1210: p_object_version_number => p_schedule_rec.object_version_number ,
1211: p_campaign_id => p_schedule_rec.campaign_id,
1212: p_user_status_id => FND_API.G_MISS_NUM,
1213: p_status_code => FND_API.G_MISS_CHAR,
1214: p_status_date => FND_API.G_MISS_DATE,
1215: -- modified on 12-dec-2001 by soagrawa, bug# 2133264
1216: -- p_source_code => p_schedule_rec.source_code,
1217: p_source_code => l_source_code,
1210: p_object_version_number => p_schedule_rec.object_version_number ,
1211: p_campaign_id => p_schedule_rec.campaign_id,
1212: p_user_status_id => FND_API.G_MISS_NUM,
1213: p_status_code => FND_API.G_MISS_CHAR,
1214: p_status_date => FND_API.G_MISS_DATE,
1215: -- modified on 12-dec-2001 by soagrawa, bug# 2133264
1216: -- p_source_code => p_schedule_rec.source_code,
1217: p_source_code => l_source_code,
1218: p_use_parent_code_flag => p_schedule_rec.use_parent_code_flag,
1323: -- l_camp_rec.channel_id,
1324: -- l_camp_rec.arc_channel_from,
1325: -- l_return_status
1326: -- );
1327: -- IF l_return_status = FND_API.g_ret_sts_error THEN
1328: -- RAISE FND_API.g_exc_error;
1329: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1330: -- RAISE FND_API.g_exc_unexpected_error;
1331: -- END IF;
1324: -- l_camp_rec.arc_channel_from,
1325: -- l_return_status
1326: -- );
1327: -- IF l_return_status = FND_API.g_ret_sts_error THEN
1328: -- RAISE FND_API.g_exc_error;
1329: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1330: -- RAISE FND_API.g_exc_unexpected_error;
1331: -- END IF;
1332: -- END IF;
1325: -- l_return_status
1326: -- );
1327: -- IF l_return_status = FND_API.g_ret_sts_error THEN
1328: -- RAISE FND_API.g_exc_error;
1329: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1330: -- RAISE FND_API.g_exc_unexpected_error;
1331: -- END IF;
1332: -- END IF;
1333:
1326: -- );
1327: -- IF l_return_status = FND_API.g_ret_sts_error THEN
1328: -- RAISE FND_API.g_exc_error;
1329: -- ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1330: -- RAISE FND_API.g_exc_unexpected_error;
1331: -- END IF;
1332: -- END IF;
1333:
1334: -- update campaign status through workflow
1343: -- Start the trigger if the schedule is using trigger and the trigger
1344: -- does not have any other schedule associated to it.
1345:
1346: /* IF p_schedule_rec.trigger_id IS NOT NULL AND
1347: p_schedule_rec.trigger_id <> FND_API.G_MISS_NUM AND
1348: l_complete_rec.triggerable_flag = 'Y'
1349: THEN
1350: AMS_ScheduleRules_PVT.Start_Trigger_Process(p_schedule_id => p_schedule_rec.schedule_id,
1351: p_trigger_id => l_complete_rec.trigger_id) ;
1367: p_user_status_id => l_complete_rec.user_status_id,
1368: p_budget_amount => l_complete_rec.budget_amount_tc,
1369: p_asn_group_id => p_schedule_rec.asn_group_id ); -- anchaudh added for leads bug.
1370:
1371: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1372: x_object_version_number := p_schedule_rec.object_version_number + 1 ;
1373: ELSE
1374: x_object_version_number := p_schedule_rec.object_version_number ;
1375: END IF;
1378: --
1379:
1380:
1381: -- Standard check for p_commit
1382: IF FND_API.to_Boolean( p_commit )
1383: THEN
1384: COMMIT WORK;
1385: END IF;
1386:
1398: );
1399: EXCEPTION
1400:
1401: WHEN AMS_Utility_PVT.resource_locked THEN
1402: x_return_status := FND_API.g_ret_sts_error;
1403: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
1404:
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1401: WHEN AMS_Utility_PVT.resource_locked THEN
1402: x_return_status := FND_API.g_ret_sts_error;
1403: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
1404:
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: -- Standard call to get message count and if count=1, get the message
1409: FND_MSG_PUB.Count_And_Get (
1403: AMS_Utility_Pvt.Error_Message('AMS_API_RESOURCE_LOCKED');
1404:
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: -- Standard call to get message count and if count=1, get the message
1409: FND_MSG_PUB.Count_And_Get (
1410: p_encoded => FND_API.G_FALSE,
1411: p_count => x_msg_count,
1406: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: -- Standard call to get message count and if count=1, get the message
1409: FND_MSG_PUB.Count_And_Get (
1410: p_encoded => FND_API.G_FALSE,
1411: p_count => x_msg_count,
1412: p_data => x_msg_data
1413: );
1414:
1411: p_count => x_msg_count,
1412: p_data => x_msg_data
1413: );
1414:
1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1413: );
1414:
1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1416: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1423: );
1424:
1423: );
1424:
1425: WHEN OTHERS THEN
1426: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1429: THEN
1430: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1431: END IF;
1430: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1431: END IF;
1432: -- Standard call to get message count and if count=1, get the message
1433: FND_MSG_PUB.Count_And_Get (
1434: p_encoded => FND_API.G_FALSE,
1435: p_count => x_msg_count,
1436: p_data => x_msg_data
1437: );
1438: End Update_Camp_Schedule;
1454: -- 22-Jan-2001 PTENDULK Created
1455: --===================================================================
1456: PROCEDURE Delete_Camp_Schedule(
1457: p_api_version_number IN NUMBER,
1458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1461: x_return_status OUT NOCOPY VARCHAR2,
1462: x_msg_count OUT NOCOPY NUMBER,
1455: --===================================================================
1456: PROCEDURE Delete_Camp_Schedule(
1457: p_api_version_number IN NUMBER,
1458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1461: x_return_status OUT NOCOPY VARCHAR2,
1462: x_msg_count OUT NOCOPY NUMBER,
1463: x_msg_data OUT NOCOPY VARCHAR2,
1456: PROCEDURE Delete_Camp_Schedule(
1457: p_api_version_number IN NUMBER,
1458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1461: x_return_status OUT NOCOPY VARCHAR2,
1462: x_msg_count OUT NOCOPY NUMBER,
1463: x_msg_data OUT NOCOPY VARCHAR2,
1464: p_schedule_id IN NUMBER,
1494: -- Standard Start of API savepoint
1495: SAVEPOINT DELETE_Camp_Schedule_PVT;
1496:
1497: -- Standard call to check for call compatibility.
1498: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1499: p_api_version_number,
1500: l_api_name,
1501: G_PKG_NAME)
1502: THEN
1499: p_api_version_number,
1500: l_api_name,
1501: G_PKG_NAME)
1502: THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END IF;
1505:
1506: -- Initialize message list if p_init_msg_list is set to TRUE.
1507: IF FND_API.to_Boolean( p_init_msg_list )
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END IF;
1505:
1506: -- Initialize message list if p_init_msg_list is set to TRUE.
1507: IF FND_API.to_Boolean( p_init_msg_list )
1508: THEN
1509: FND_MSG_PUB.initialize;
1510: END IF;
1511:
1515: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1516: END IF;
1517:
1518: -- Initialize API return status to SUCCESS
1519: x_return_status := FND_API.G_RET_STS_SUCCESS;
1520:
1521: OPEN c_camp_schedule;
1522: FETCH c_camp_schedule INTO l_campaign_id, l_schedule_id, l_status_code, l_cascade_flag, l_source_code;
1523: IF (c_camp_schedule%NOTFOUND) THEN
1522: FETCH c_camp_schedule INTO l_campaign_id, l_schedule_id, l_status_code, l_cascade_flag, l_source_code;
1523: IF (c_camp_schedule%NOTFOUND) THEN
1524: CLOSE c_camp_schedule;
1525: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
1526: RAISE FND_API.g_exc_error;
1527: END IF;
1528: CLOSE c_camp_schedule;
1529:
1530: --
1556: -- Revoke the source code
1557: IF l_cascade_flag = 'N' THEN
1558: AMS_SourceCode_PVT.revoke_sourcecode(
1559: p_api_version => 1.0,
1560: p_init_msg_list => FND_API.g_false,
1561: p_commit => FND_API.g_false,
1562: p_validation_level => FND_API.g_valid_level_full,
1563:
1564: x_return_status => x_return_status,
1557: IF l_cascade_flag = 'N' THEN
1558: AMS_SourceCode_PVT.revoke_sourcecode(
1559: p_api_version => 1.0,
1560: p_init_msg_list => FND_API.g_false,
1561: p_commit => FND_API.g_false,
1562: p_validation_level => FND_API.g_valid_level_full,
1563:
1564: x_return_status => x_return_status,
1565: x_msg_count => x_msg_count,
1558: AMS_SourceCode_PVT.revoke_sourcecode(
1559: p_api_version => 1.0,
1560: p_init_msg_list => FND_API.g_false,
1561: p_commit => FND_API.g_false,
1562: p_validation_level => FND_API.g_valid_level_full,
1563:
1564: x_return_status => x_return_status,
1565: x_msg_count => x_msg_count,
1566: x_msg_data => x_msg_data,
1573: -- End of API body
1574: --
1575:
1576: -- Standard check for p_commit
1577: IF FND_API.to_Boolean(p_commit)
1578: THEN
1579: COMMIT WORK;
1580: END IF;
1581:
1593: );
1594: EXCEPTION
1595:
1596: WHEN AMS_Utility_PVT.resource_locked THEN
1597: x_return_status := FND_API.g_ret_sts_error;
1598: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1599:
1600: WHEN FND_API.G_EXC_ERROR THEN
1601: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1596: WHEN AMS_Utility_PVT.resource_locked THEN
1597: x_return_status := FND_API.g_ret_sts_error;
1598: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1599:
1600: WHEN FND_API.G_EXC_ERROR THEN
1601: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: -- Standard call to get message count and if count=1, get the message
1604: FND_MSG_PUB.Count_And_Get (
1598: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1599:
1600: WHEN FND_API.G_EXC_ERROR THEN
1601: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: -- Standard call to get message count and if count=1, get the message
1604: FND_MSG_PUB.Count_And_Get (
1605: p_encoded => FND_API.G_FALSE,
1606: p_count => x_msg_count,
1601: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: -- Standard call to get message count and if count=1, get the message
1604: FND_MSG_PUB.Count_And_Get (
1605: p_encoded => FND_API.G_FALSE,
1606: p_count => x_msg_count,
1607: p_data => x_msg_data
1608: );
1609:
1606: p_count => x_msg_count,
1607: p_data => x_msg_data
1608: );
1609:
1610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1611: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1613: -- Standard call to get message count and if count=1, get the message
1614: FND_MSG_PUB.Count_And_Get (
1608: );
1609:
1610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1611: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1613: -- Standard call to get message count and if count=1, get the message
1614: FND_MSG_PUB.Count_And_Get (
1615: p_encoded => FND_API.G_FALSE,
1616: p_count => x_msg_count,
1611: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1613: -- Standard call to get message count and if count=1, get the message
1614: FND_MSG_PUB.Count_And_Get (
1615: p_encoded => FND_API.G_FALSE,
1616: p_count => x_msg_count,
1617: p_data => x_msg_data
1618: );
1619:
1618: );
1619:
1620: WHEN OTHERS THEN
1621: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1624: THEN
1625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1626: END IF;
1625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1626: END IF;
1627: -- Standard call to get message count and if count=1, get the message
1628: FND_MSG_PUB.Count_And_Get (
1629: p_encoded => FND_API.G_FALSE,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data
1632: );
1633: End Delete_Camp_Schedule;
1646: -- 22-Jan-2001 PTENDULK Created
1647: --===================================================================
1648: PROCEDURE Lock_Camp_Schedule(
1649: p_api_version_number IN NUMBER,
1650: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1651:
1652: x_return_status OUT NOCOPY VARCHAR2,
1653: x_msg_count OUT NOCOPY NUMBER,
1654: x_msg_data OUT NOCOPY VARCHAR2,
1677: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1678: END IF;
1679:
1680: -- Initialize message list if p_init_msg_list is set to TRUE.
1681: IF FND_API.to_Boolean( p_init_msg_list )
1682: THEN
1683: FND_MSG_PUB.initialize;
1684: END IF;
1685:
1683: FND_MSG_PUB.initialize;
1684: END IF;
1685:
1686: -- Standard call to check for call compatibility.
1687: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1688: p_api_version_number,
1689: l_api_name,
1690: G_PKG_NAME)
1691: THEN
1688: p_api_version_number,
1689: l_api_name,
1690: G_PKG_NAME)
1691: THEN
1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1693: END IF;
1694:
1695:
1696: -- Initialize API return status to SUCCESS
1693: END IF;
1694:
1695:
1696: -- Initialize API return status to SUCCESS
1697: x_return_status := FND_API.G_RET_STS_SUCCESS;
1698:
1699:
1700: ------------------------ lock -------------------------
1701:
1711:
1712: IF (c_Camp_Schedule%NOTFOUND) THEN
1713: CLOSE c_Camp_Schedule;
1714: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
1715: RAISE FND_API.g_exc_error;
1716: END IF;
1717: CLOSE c_Camp_Schedule;
1718:
1719: -------------------- finish --------------------------
1717: CLOSE c_Camp_Schedule;
1718:
1719: -------------------- finish --------------------------
1720: FND_MSG_PUB.count_and_get(
1721: p_encoded => FND_API.g_false,
1722: p_count => x_msg_count,
1723: p_data => x_msg_data);
1724: IF (AMS_DEBUG_HIGH_ON) THEN
1725:
1727: END IF;
1728: EXCEPTION
1729:
1730: WHEN AMS_Utility_PVT.resource_locked THEN
1731: x_return_status := FND_API.g_ret_sts_error;
1732: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1733:
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1730: WHEN AMS_Utility_PVT.resource_locked THEN
1731: x_return_status := FND_API.g_ret_sts_error;
1732: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1733:
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1736: x_return_status := FND_API.G_RET_STS_ERROR;
1737: -- Standard call to get message count and if count=1, get the message
1738: FND_MSG_PUB.Count_And_Get (
1732: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
1733:
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1736: x_return_status := FND_API.G_RET_STS_ERROR;
1737: -- Standard call to get message count and if count=1, get the message
1738: FND_MSG_PUB.Count_And_Get (
1739: p_encoded => FND_API.G_FALSE,
1740: p_count => x_msg_count,
1735: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1736: x_return_status := FND_API.G_RET_STS_ERROR;
1737: -- Standard call to get message count and if count=1, get the message
1738: FND_MSG_PUB.Count_And_Get (
1739: p_encoded => FND_API.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data
1742: );
1743:
1740: p_count => x_msg_count,
1741: p_data => x_msg_data
1742: );
1743:
1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1745: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: -- Standard call to get message count and if count=1, get the message
1748: FND_MSG_PUB.Count_And_Get (
1742: );
1743:
1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1745: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: -- Standard call to get message count and if count=1, get the message
1748: FND_MSG_PUB.Count_And_Get (
1749: p_encoded => FND_API.G_FALSE,
1750: p_count => x_msg_count,
1745: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: -- Standard call to get message count and if count=1, get the message
1748: FND_MSG_PUB.Count_And_Get (
1749: p_encoded => FND_API.G_FALSE,
1750: p_count => x_msg_count,
1751: p_data => x_msg_data
1752: );
1753:
1752: );
1753:
1754: WHEN OTHERS THEN
1755: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1758: THEN
1759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1760: END IF;
1759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1760: END IF;
1761: -- Standard call to get message count and if count=1, get the message
1762: FND_MSG_PUB.Count_And_Get (
1763: p_encoded => FND_API.G_FALSE,
1764: p_count => x_msg_count,
1765: p_data => x_msg_data
1766: );
1767: End Lock_Camp_Schedule;
1785: IS
1786: l_valid_flag VARCHAR2(1);
1787:
1788: BEGIN
1789: x_return_status := FND_API.g_ret_sts_success;
1790:
1791: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1792: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1793: 'ams_campaign_schedules_b',
1792: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1793: 'ams_campaign_schedules_b',
1794: 'schedule_id = ' || p_schedule_rec.schedule_id
1795: );
1796: IF l_valid_flag = FND_API.g_false THEN
1797: AMS_Utility_PVT.Error_Message('AMS_CSCH_ID_DUPLICATE');
1798: x_return_status := FND_API.g_ret_sts_error;
1799: RETURN;
1800: END IF;
1794: 'schedule_id = ' || p_schedule_rec.schedule_id
1795: );
1796: IF l_valid_flag = FND_API.g_false THEN
1797: AMS_Utility_PVT.Error_Message('AMS_CSCH_ID_DUPLICATE');
1798: x_return_status := FND_API.g_ret_sts_error;
1799: RETURN;
1800: END IF;
1801: END IF;
1802:
1805: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1806: 'ams_campaign_schedules_b',
1807: 'related_event_id = ' || p_schedule_rec.related_event_id
1808: );
1809: IF l_valid_flag = FND_API.g_false THEN
1810: AMS_Utility_PVT.Error_Message('AMS_EVO_DUPLICATE_ID');
1811: x_return_status := FND_API.g_ret_sts_error;
1812: RETURN;
1813: END IF;
1807: 'related_event_id = ' || p_schedule_rec.related_event_id
1808: );
1809: IF l_valid_flag = FND_API.g_false THEN
1810: AMS_Utility_PVT.Error_Message('AMS_EVO_DUPLICATE_ID');
1811: x_return_status := FND_API.g_ret_sts_error;
1812: RETURN;
1813: END IF;
1814: END IF;
1815:
1833: x_return_status OUT NOCOPY VARCHAR2
1834: )
1835: IS
1836: BEGIN
1837: x_return_status := FND_API.g_ret_sts_success;
1838:
1839: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1840:
1841: IF p_schedule_rec.campaign_id = FND_API.g_miss_num OR p_schedule_rec.campaign_id IS NULL THEN
1837: x_return_status := FND_API.g_ret_sts_success;
1838:
1839: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1840:
1841: IF p_schedule_rec.campaign_id = FND_API.g_miss_num OR p_schedule_rec.campaign_id IS NULL THEN
1842: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CAMP_ID') ;
1843: x_return_status := FND_API.g_ret_sts_error;
1844: RETURN;
1845: END IF;
1839: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1840:
1841: IF p_schedule_rec.campaign_id = FND_API.g_miss_num OR p_schedule_rec.campaign_id IS NULL THEN
1842: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CAMP_ID') ;
1843: x_return_status := FND_API.g_ret_sts_error;
1844: RETURN;
1845: END IF;
1846:
1847:
1844: RETURN;
1845: END IF;
1846:
1847:
1848: IF p_schedule_rec.user_status_id = FND_API.g_miss_num OR p_schedule_rec.user_status_id IS NULL THEN
1849: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_STATUS_ID') ;
1850: x_return_status := FND_API.g_ret_sts_error;
1851: RETURN;
1852: END IF;
1846:
1847:
1848: IF p_schedule_rec.user_status_id = FND_API.g_miss_num OR p_schedule_rec.user_status_id IS NULL THEN
1849: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_STATUS_ID') ;
1850: x_return_status := FND_API.g_ret_sts_error;
1851: RETURN;
1852: END IF;
1853:
1854:
1851: RETURN;
1852: END IF;
1853:
1854:
1855: IF p_schedule_rec.activity_type_code = FND_API.g_miss_char OR p_schedule_rec.activity_type_code IS NULL THEN
1856: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_MEDIA_TYPE') ;
1857: x_return_status := FND_API.g_ret_sts_error;
1858: RETURN;
1859: END IF;
1853:
1854:
1855: IF p_schedule_rec.activity_type_code = FND_API.g_miss_char OR p_schedule_rec.activity_type_code IS NULL THEN
1856: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_MEDIA_TYPE') ;
1857: x_return_status := FND_API.g_ret_sts_error;
1858: RETURN;
1859: END IF;
1860:
1861: IF p_schedule_rec.custom_setup_id = FND_API.g_miss_num OR p_schedule_rec.custom_setup_id IS NULL THEN
1857: x_return_status := FND_API.g_ret_sts_error;
1858: RETURN;
1859: END IF;
1860:
1861: IF p_schedule_rec.custom_setup_id = FND_API.g_miss_num OR p_schedule_rec.custom_setup_id IS NULL THEN
1862: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CUS_SETUP') ;
1863: x_return_status := FND_API.g_ret_sts_error;
1864: RETURN;
1865: END IF;
1859: END IF;
1860:
1861: IF p_schedule_rec.custom_setup_id = FND_API.g_miss_num OR p_schedule_rec.custom_setup_id IS NULL THEN
1862: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CUS_SETUP') ;
1863: x_return_status := FND_API.g_ret_sts_error;
1864: RETURN;
1865: END IF;
1866:
1867: IF p_schedule_rec.triggerable_flag = FND_API.g_miss_char OR p_schedule_rec.triggerable_flag IS NULL THEN
1863: x_return_status := FND_API.g_ret_sts_error;
1864: RETURN;
1865: END IF;
1866:
1867: IF p_schedule_rec.triggerable_flag = FND_API.g_miss_char OR p_schedule_rec.triggerable_flag IS NULL THEN
1868: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_TRIG_FLAG') ;
1869: x_return_status := FND_API.g_ret_sts_error;
1870: RETURN;
1871: END IF;
1865: END IF;
1866:
1867: IF p_schedule_rec.triggerable_flag = FND_API.g_miss_char OR p_schedule_rec.triggerable_flag IS NULL THEN
1868: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_TRIG_FLAG') ;
1869: x_return_status := FND_API.g_ret_sts_error;
1870: RETURN;
1871: END IF;
1872:
1873: IF p_schedule_rec.owner_user_id = FND_API.g_miss_num OR p_schedule_rec.owner_user_id IS NULL THEN
1869: x_return_status := FND_API.g_ret_sts_error;
1870: RETURN;
1871: END IF;
1872:
1873: IF p_schedule_rec.owner_user_id = FND_API.g_miss_num OR p_schedule_rec.owner_user_id IS NULL THEN
1874: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_OWNER') ;
1875: x_return_status := FND_API.g_ret_sts_error;
1876: RETURN;
1877: END IF;
1871: END IF;
1872:
1873: IF p_schedule_rec.owner_user_id = FND_API.g_miss_num OR p_schedule_rec.owner_user_id IS NULL THEN
1874: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_OWNER') ;
1875: x_return_status := FND_API.g_ret_sts_error;
1876: RETURN;
1877: END IF;
1878:
1879:
1876: RETURN;
1877: END IF;
1878:
1879:
1880: IF p_schedule_rec.active_flag = FND_API.g_miss_char OR p_schedule_rec.active_flag IS NULL THEN
1881: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_ACTIVE_FLAG') ;
1882: x_return_status := FND_API.g_ret_sts_error;
1883: RETURN;
1884: END IF;
1878:
1879:
1880: IF p_schedule_rec.active_flag = FND_API.g_miss_char OR p_schedule_rec.active_flag IS NULL THEN
1881: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_ACTIVE_FLAG') ;
1882: x_return_status := FND_API.g_ret_sts_error;
1883: RETURN;
1884: END IF;
1885:
1886: IF p_schedule_rec.country_id = FND_API.g_miss_num OR p_schedule_rec.country_id IS NULL THEN
1882: x_return_status := FND_API.g_ret_sts_error;
1883: RETURN;
1884: END IF;
1885:
1886: IF p_schedule_rec.country_id = FND_API.g_miss_num OR p_schedule_rec.country_id IS NULL THEN
1887: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_COUNTRY') ;
1888: x_return_status := FND_API.g_ret_sts_error;
1889: RETURN;
1890: END IF;
1884: END IF;
1885:
1886: IF p_schedule_rec.country_id = FND_API.g_miss_num OR p_schedule_rec.country_id IS NULL THEN
1887: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_COUNTRY') ;
1888: x_return_status := FND_API.g_ret_sts_error;
1889: RETURN;
1890: END IF;
1891:
1892: IF p_schedule_rec.schedule_name = FND_API.g_miss_char OR p_schedule_rec.schedule_name IS NULL THEN
1888: x_return_status := FND_API.g_ret_sts_error;
1889: RETURN;
1890: END IF;
1891:
1892: IF p_schedule_rec.schedule_name = FND_API.g_miss_char OR p_schedule_rec.schedule_name IS NULL THEN
1893: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_NAME') ;
1894: x_return_status := FND_API.g_ret_sts_error;
1895: RETURN;
1896: END IF;
1890: END IF;
1891:
1892: IF p_schedule_rec.schedule_name = FND_API.g_miss_char OR p_schedule_rec.schedule_name IS NULL THEN
1893: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_NAME') ;
1894: x_return_status := FND_API.g_ret_sts_error;
1895: RETURN;
1896: END IF;
1897: ELSE
1898: IF p_schedule_rec.campaign_id IS NULL THEN
1896: END IF;
1897: ELSE
1898: IF p_schedule_rec.campaign_id IS NULL THEN
1899: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CAMP_ID') ;
1900: x_return_status := FND_API.g_ret_sts_error;
1901: RETURN;
1902: END IF;
1903:
1904: IF p_schedule_rec.user_status_id IS NULL THEN
1902: END IF;
1903:
1904: IF p_schedule_rec.user_status_id IS NULL THEN
1905: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_STATUS_ID') ;
1906: x_return_status := FND_API.g_ret_sts_error;
1907: RETURN;
1908: END IF;
1909:
1910: IF p_schedule_rec.activity_type_code IS NULL THEN
1908: END IF;
1909:
1910: IF p_schedule_rec.activity_type_code IS NULL THEN
1911: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_MEDIA_TYPE') ;
1912: x_return_status := FND_API.g_ret_sts_error;
1913: RETURN;
1914: END IF;
1915:
1916: IF p_schedule_rec.custom_setup_id IS NULL THEN
1914: END IF;
1915:
1916: IF p_schedule_rec.custom_setup_id IS NULL THEN
1917: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_CUS_SETUP') ;
1918: x_return_status := FND_API.g_ret_sts_error;
1919: RETURN;
1920: END IF;
1921:
1922: IF p_schedule_rec.triggerable_flag IS NULL THEN
1920: END IF;
1921:
1922: IF p_schedule_rec.triggerable_flag IS NULL THEN
1923: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_TRIG_FLAG') ;
1924: x_return_status := FND_API.g_ret_sts_error;
1925: RETURN;
1926: END IF;
1927:
1928: IF p_schedule_rec.owner_user_id IS NULL THEN
1926: END IF;
1927:
1928: IF p_schedule_rec.owner_user_id IS NULL THEN
1929: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_OWNER') ;
1930: x_return_status := FND_API.g_ret_sts_error;
1931: RETURN;
1932: END IF;
1933:
1934: IF p_schedule_rec.active_flag IS NULL THEN
1932: END IF;
1933:
1934: IF p_schedule_rec.active_flag IS NULL THEN
1935: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_ACTIVE_FLAG') ;
1936: x_return_status := FND_API.g_ret_sts_error;
1937: RETURN;
1938: END IF;
1939:
1940: IF p_schedule_rec.country_id IS NULL THEN
1938: END IF;
1939:
1940: IF p_schedule_rec.country_id IS NULL THEN
1941: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_COUNTRY') ;
1942: x_return_status := FND_API.g_ret_sts_error;
1943: RETURN;
1944: END IF;
1945:
1946: IF p_schedule_rec.schedule_name IS NULL THEN
1944: END IF;
1945:
1946: IF p_schedule_rec.schedule_name IS NULL THEN
1947: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_NO_NAME') ;
1948: x_return_status := FND_API.g_ret_sts_error;
1949: RETURN;
1950: END IF;
1951: END IF;
1952:
1974: l_pk_value VARCHAR2(30);
1975: l_pk_data_type NUMBER;
1976: l_additional_where_clause VARCHAR2(4000); -- Used by Check_FK_Exists.
1977: BEGIN
1978: x_return_status := FND_API.g_ret_sts_success;
1979:
1980: -- Check Campaign Id
1981: IF p_schedule_rec.campaign_id <> FND_API.g_miss_num THEN
1982: l_table_name := 'ams_campaigns_all_b' ;
1977: BEGIN
1978: x_return_status := FND_API.g_ret_sts_success;
1979:
1980: -- Check Campaign Id
1981: IF p_schedule_rec.campaign_id <> FND_API.g_miss_num THEN
1982: l_table_name := 'ams_campaigns_all_b' ;
1983: l_pk_name := 'campaign_id' ;
1984: l_pk_value := p_schedule_rec.campaign_id ;
1985: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
1990: p_pk_name => l_pk_name,
1991: p_pk_value => l_pk_value,
1992: p_pk_data_type => l_pk_data_type,
1993: p_additional_where_clause => l_additional_where_clause
1994: ) = FND_API.g_false
1995: THEN
1996: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_CAMP_ID') ;
1997: x_return_status := FND_API.g_ret_sts_error;
1998: RETURN;
1993: p_additional_where_clause => l_additional_where_clause
1994: ) = FND_API.g_false
1995: THEN
1996: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_CAMP_ID') ;
1997: x_return_status := FND_API.g_ret_sts_error;
1998: RETURN;
1999: END IF;
2000: END IF;
2001:
1999: END IF;
2000: END IF;
2001:
2002: -- Check User Status Id
2003: IF p_schedule_rec.user_status_id <> FND_API.g_miss_num THEN
2004: l_table_name := 'ams_user_statuses_b' ;
2005: l_pk_name := 'user_status_id' ;
2006: l_pk_value := p_schedule_rec.user_status_id ;
2007: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2013: p_pk_name => l_pk_name,
2014: p_pk_value => l_pk_value,
2015: p_pk_data_type => l_pk_data_type,
2016: p_additional_where_clause => l_additional_where_clause
2017: ) = FND_API.g_false
2018: THEN
2019: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_USER_STATUS') ;
2020: x_return_status := FND_API.g_ret_sts_error;
2021: RETURN;
2016: p_additional_where_clause => l_additional_where_clause
2017: ) = FND_API.g_false
2018: THEN
2019: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_USER_STATUS') ;
2020: x_return_status := FND_API.g_ret_sts_error;
2021: RETURN;
2022: END IF;
2023: END IF;
2024:
2022: END IF;
2023: END IF;
2024:
2025: -- Check Timezone Id
2026: IF p_schedule_rec.timezone_id <> FND_API.g_miss_num
2027: AND p_schedule_rec.timezone_id IS NOT NULL THEN
2028: l_table_name := 'fnd_timezones_b';
2029: l_pk_name := 'upgrade_tz_id' ;
2030: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2036: p_pk_name => l_pk_name,
2037: p_pk_value => l_pk_value,
2038: p_pk_data_type => l_pk_data_type,
2039: p_additional_where_clause => l_additional_where_clause
2040: ) = FND_API.g_false
2041: THEN
2042: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_CAMP_ID') ;
2043: x_return_status := FND_API.g_ret_sts_error;
2044: RETURN;
2039: p_additional_where_clause => l_additional_where_clause
2040: ) = FND_API.g_false
2041: THEN
2042: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_CAMP_ID') ;
2043: x_return_status := FND_API.g_ret_sts_error;
2044: RETURN;
2045: END IF;
2046: END IF;
2047:
2045: END IF;
2046: END IF;
2047:
2048: -- Check Custom Setup Id
2049: IF p_schedule_rec.custom_setup_id <> FND_API.g_miss_num THEN
2050: l_table_name := 'ams_custom_setups_b';
2051: l_pk_name := 'custom_setup_id' ;
2052: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2053: l_pk_value := p_schedule_rec.custom_setup_id ;
2058: p_pk_name => l_pk_name,
2059: p_pk_value => l_pk_value,
2060: p_pk_data_type => l_pk_data_type,
2061: p_additional_where_clause => l_additional_where_clause
2062: ) = FND_API.g_false
2063: THEN
2064: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_SETUP') ;
2065: x_return_status := FND_API.g_ret_sts_error;
2066: RETURN;
2061: p_additional_where_clause => l_additional_where_clause
2062: ) = FND_API.g_false
2063: THEN
2064: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_SETUP') ;
2065: x_return_status := FND_API.g_ret_sts_error;
2066: RETURN;
2067: END IF;
2068: END IF;
2069:
2068: END IF;
2069:
2070:
2071: -- Check Trigger Id
2072: IF p_schedule_rec.trigger_id <> FND_API.g_miss_num AND
2073: p_schedule_rec.trigger_id IS NOT NULL THEN
2074: l_table_name := 'ams_triggers';
2075: l_pk_name := 'trigger_id' ;
2076: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2082: p_pk_name => l_pk_name,
2083: p_pk_value => l_pk_value,
2084: p_pk_data_type => l_pk_data_type,
2085: p_additional_where_clause => l_additional_where_clause
2086: ) = FND_API.g_false
2087: THEN
2088: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_TRIGGER') ;
2089: x_return_status := FND_API.g_ret_sts_error;
2090: RETURN;
2085: p_additional_where_clause => l_additional_where_clause
2086: ) = FND_API.g_false
2087: THEN
2088: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_TRIGGER') ;
2089: x_return_status := FND_API.g_ret_sts_error;
2090: RETURN;
2091: END IF;
2092: END IF;
2093:
2091: END IF;
2092: END IF;
2093:
2094: -- Check Notify User Id
2095: IF p_schedule_rec.notify_user_id <> FND_API.g_miss_num AND
2096: p_schedule_rec.notify_user_id IS NOT NULL THEN
2097: l_table_name := 'ams_jtf_rs_emp_v';
2098: l_pk_name := 'resource_id' ;
2099: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2105: p_pk_name => l_pk_name,
2106: p_pk_value => l_pk_value,
2107: p_pk_data_type => l_pk_data_type,
2108: p_additional_where_clause => l_additional_where_clause
2109: ) = FND_API.g_false
2110: THEN
2111: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_NOTIFY_TO') ;
2112: x_return_status := FND_API.g_ret_sts_error;
2113: RETURN;
2108: p_additional_where_clause => l_additional_where_clause
2109: ) = FND_API.g_false
2110: THEN
2111: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_NOTIFY_TO') ;
2112: x_return_status := FND_API.g_ret_sts_error;
2113: RETURN;
2114: END IF;
2115: END IF;
2116:
2114: END IF;
2115: END IF;
2116:
2117: -- Check Approver User Id
2118: IF p_schedule_rec.approver_user_id <> FND_API.g_miss_num AND
2119: p_schedule_rec.approver_user_id IS NOT NULL THEN
2120: l_table_name := 'ams_jtf_rs_emp_v';
2121: l_pk_name := 'resource_id' ;
2122: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2128: p_pk_name => l_pk_name,
2129: p_pk_value => l_pk_value,
2130: p_pk_data_type => l_pk_data_type,
2131: p_additional_where_clause => l_additional_where_clause
2132: ) = FND_API.g_false
2133: THEN
2134: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_APPROVER') ;
2135: x_return_status := FND_API.g_ret_sts_error;
2136: RETURN;
2131: p_additional_where_clause => l_additional_where_clause
2132: ) = FND_API.g_false
2133: THEN
2134: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_APPROVER') ;
2135: x_return_status := FND_API.g_ret_sts_error;
2136: RETURN;
2137: END IF;
2138: END IF;
2139:
2142: -- as we will no longer be using JTF cover letters
2143: -- This is for new schedule eblast, wherein a cover letter is an IBC content item
2144:
2145: /*
2146: IF p_schedule_rec.cover_letter_id <> FND_API.g_miss_num AND
2147: p_schedule_rec.cover_letter_id IS NOT NULL THEN
2148: l_table_name := 'jtf_amv_items_b';
2149: l_pk_name := 'item_id' ;
2150: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2156: p_pk_name => l_pk_name,
2157: p_pk_value => l_pk_value,
2158: p_pk_data_type => l_pk_data_type,
2159: p_additional_where_clause => l_additional_where_clause
2160: ) = FND_API.g_false
2161: THEN
2162: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COVER_LETTER') ;
2163: x_return_status := FND_API.g_ret_sts_error;
2164: RETURN;
2159: p_additional_where_clause => l_additional_where_clause
2160: ) = FND_API.g_false
2161: THEN
2162: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COVER_LETTER') ;
2163: x_return_status := FND_API.g_ret_sts_error;
2164: RETURN;
2165: END IF;
2166: END IF;
2167: */
2165: END IF;
2166: END IF;
2167: */
2168:
2169: IF p_schedule_rec.cover_letter_id <> FND_API.g_miss_num AND
2170: p_schedule_rec.cover_letter_id IS NOT NULL THEN
2171: l_table_name := 'ibc_content_items';
2172: l_pk_name := 'content_item_id' ;
2173: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2181: p_pk_name => l_pk_name,
2182: p_pk_value => l_pk_value,
2183: p_pk_data_type => l_pk_data_type,
2184: p_additional_where_clause => l_additional_where_clause
2185: ) = FND_API.g_false
2186: THEN
2187: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COVER_LETTER') ;
2188: x_return_status := FND_API.g_ret_sts_error;
2189: RETURN;
2184: p_additional_where_clause => l_additional_where_clause
2185: ) = FND_API.g_false
2186: THEN
2187: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COVER_LETTER') ;
2188: x_return_status := FND_API.g_ret_sts_error;
2189: RETURN;
2190: END IF;
2191: END IF;
2192:
2192:
2193:
2194:
2195: -- Check country
2196: IF p_schedule_rec.country_id <> FND_API.g_miss_num AND
2197: p_schedule_rec.country_id IS NOT NULL THEN
2198: l_table_name := 'jtf_loc_hierarchies_b';
2199: l_pk_name := 'location_hierarchy_id' ;
2200: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2206: p_pk_name => l_pk_name,
2207: p_pk_value => l_pk_value,
2208: p_pk_data_type => l_pk_data_type,
2209: p_additional_where_clause => l_additional_where_clause
2210: ) = FND_API.g_false
2211: THEN
2212: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COUNTRY') ;
2213: x_return_status := FND_API.g_ret_sts_error;
2214: RETURN;
2209: p_additional_where_clause => l_additional_where_clause
2210: ) = FND_API.g_false
2211: THEN
2212: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_COUNTRY') ;
2213: x_return_status := FND_API.g_ret_sts_error;
2214: RETURN;
2215: END IF;
2216: END IF;
2217:
2215: END IF;
2216: END IF;
2217:
2218: -- Check Language Code
2219: IF p_schedule_rec.language_code <> FND_API.g_miss_char AND
2220: p_schedule_rec.language_code IS NOT NULL THEN
2221: l_table_name := 'fnd_languages';
2222: l_pk_name := 'language_code' ;
2223: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2 ;
2229: p_pk_name => l_pk_name,
2230: p_pk_value => l_pk_value,
2231: p_pk_data_type => l_pk_data_type,
2232: p_additional_where_clause => l_additional_where_clause
2233: ) = FND_API.g_false
2234: THEN
2235: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_LANG') ;
2236: x_return_status := FND_API.g_ret_sts_error;
2237: RETURN;
2232: p_additional_where_clause => l_additional_where_clause
2233: ) = FND_API.g_false
2234: THEN
2235: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_LANG') ;
2236: x_return_status := FND_API.g_ret_sts_error;
2237: RETURN;
2238: END IF;
2239: END IF;
2240:
2238: END IF;
2239: END IF;
2240:
2241: -- Check Task Id
2242: IF p_schedule_rec.task_id <> FND_API.g_miss_num AND
2243: p_schedule_rec.task_id IS NOT NULL THEN
2244: l_table_name := 'jtf_tasks_b';
2245: l_pk_name := 'task_id' ;
2246: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
2252: p_pk_name => l_pk_name,
2253: p_pk_value => l_pk_value,
2254: p_pk_data_type => l_pk_data_type,
2255: p_additional_where_clause => l_additional_where_clause
2256: ) = FND_API.g_false
2257: THEN
2258: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_TASK') ;
2259: x_return_status := FND_API.g_ret_sts_error;
2260: RETURN;
2255: p_additional_where_clause => l_additional_where_clause
2256: ) = FND_API.g_false
2257: THEN
2258: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CAMP_BAD_TASK') ;
2259: x_return_status := FND_API.g_ret_sts_error;
2260: RETURN;
2261: END IF;
2262: END IF;
2263:
2281: x_return_status OUT NOCOPY VARCHAR2
2282: )
2283: IS
2284: BEGIN
2285: x_return_status := FND_API.g_ret_sts_success;
2286:
2287: -- Check status code
2288: IF p_schedule_rec.status_code <> FND_API.G_MISS_CHAR
2289: THEN
2284: BEGIN
2285: x_return_status := FND_API.g_ret_sts_success;
2286:
2287: -- Check status code
2288: IF p_schedule_rec.status_code <> FND_API.G_MISS_CHAR
2289: THEN
2290: IF AMS_Utility_PVT.Check_Lookup_Exists
2291: ( p_lookup_table_name => 'AMS_LOOKUPS'
2292: ,p_lookup_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS'
2289: THEN
2290: IF AMS_Utility_PVT.Check_Lookup_Exists
2291: ( p_lookup_table_name => 'AMS_LOOKUPS'
2292: ,p_lookup_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS'
2293: ,p_lookup_code => p_schedule_rec.status_code ) = FND_API.G_FALSE
2294: THEN
2295: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_STATUS') ;
2296: x_return_status := FND_API.g_ret_sts_error;
2297: RETURN;
2292: ,p_lookup_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS'
2293: ,p_lookup_code => p_schedule_rec.status_code ) = FND_API.G_FALSE
2294: THEN
2295: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_STATUS') ;
2296: x_return_status := FND_API.g_ret_sts_error;
2297: RETURN;
2298:
2299: END IF;
2300: END IF;
2299: END IF;
2300: END IF;
2301:
2302: -- Check Activity type code
2303: IF p_schedule_rec.activity_type_code <> FND_API.G_MISS_CHAR
2304: THEN
2305: IF AMS_Utility_PVT.Check_Lookup_Exists
2306: ( p_lookup_table_name => 'AMS_LOOKUPS'
2307: ,p_lookup_type => 'AMS_MEDIA_TYPE'
2304: THEN
2305: IF AMS_Utility_PVT.Check_Lookup_Exists
2306: ( p_lookup_table_name => 'AMS_LOOKUPS'
2307: ,p_lookup_type => 'AMS_MEDIA_TYPE'
2308: ,p_lookup_code => p_schedule_rec.activity_type_code ) = FND_API.G_FALSE
2309: THEN
2310: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_ACTIVITY_TYPE') ;
2311: x_return_status := FND_API.g_ret_sts_error;
2312: RETURN;
2307: ,p_lookup_type => 'AMS_MEDIA_TYPE'
2308: ,p_lookup_code => p_schedule_rec.activity_type_code ) = FND_API.G_FALSE
2309: THEN
2310: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_ACTIVITY_TYPE') ;
2311: x_return_status := FND_API.g_ret_sts_error;
2312: RETURN;
2313: END IF;
2314: END IF;
2315:
2313: END IF;
2314: END IF;
2315:
2316: -- Check Objective
2317: IF p_schedule_rec.objective_code <> FND_API.G_MISS_CHAR
2318: THEN
2319: IF AMS_Utility_PVT.Check_Lookup_Exists
2320: ( p_lookup_table_name => 'AMS_LOOKUPS'
2321: ,p_lookup_type => 'AMS_SCHEDULE_OBJECTIVE'
2318: THEN
2319: IF AMS_Utility_PVT.Check_Lookup_Exists
2320: ( p_lookup_table_name => 'AMS_LOOKUPS'
2321: ,p_lookup_type => 'AMS_SCHEDULE_OBJECTIVE'
2322: ,p_lookup_code => p_schedule_rec.objective_code ) = FND_API.G_FALSE
2323: THEN
2324: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_OBJECTIVE') ;
2325: x_return_status := FND_API.g_ret_sts_error;
2326: RETURN;
2321: ,p_lookup_type => 'AMS_SCHEDULE_OBJECTIVE'
2322: ,p_lookup_code => p_schedule_rec.objective_code ) = FND_API.G_FALSE
2323: THEN
2324: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_OBJECTIVE') ;
2325: x_return_status := FND_API.g_ret_sts_error;
2326: RETURN;
2327: END IF;
2328: END IF;
2329:
2327: END IF;
2328: END IF;
2329:
2330: -- Check Priority
2331: IF p_schedule_rec.priority <> FND_API.G_MISS_CHAR
2332: THEN
2333: IF AMS_Utility_PVT.Check_Lookup_Exists
2334: ( p_lookup_table_name => 'AMS_LOOKUPS'
2335: ,p_lookup_type => 'AMS_PRIORITY'
2332: THEN
2333: IF AMS_Utility_PVT.Check_Lookup_Exists
2334: ( p_lookup_table_name => 'AMS_LOOKUPS'
2335: ,p_lookup_type => 'AMS_PRIORITY'
2336: ,p_lookup_code => p_schedule_rec.priority ) = FND_API.G_FALSE
2337: THEN
2338: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_PRIORITY') ;
2339: x_return_status := FND_API.g_ret_sts_error;
2340: RETURN;
2335: ,p_lookup_type => 'AMS_PRIORITY'
2336: ,p_lookup_code => p_schedule_rec.priority ) = FND_API.G_FALSE
2337: THEN
2338: AMS_Utility_Pvt.Error_Message(p_message_name => 'AMS_CSCH_BAD_PRIORITY') ;
2339: x_return_status := FND_API.g_ret_sts_error;
2340: RETURN;
2341: END IF;
2342: END IF;
2343:
2360: x_return_status OUT NOCOPY VARCHAR2
2361: )
2362: IS
2363: BEGIN
2364: x_return_status := FND_API.g_ret_sts_success;
2365:
2366: -- Check Use parent code flag
2367: IF p_schedule_rec.use_parent_code_flag <> FND_API.g_miss_char
2368: AND p_schedule_rec.use_parent_code_flag IS NOT NULL
2363: BEGIN
2364: x_return_status := FND_API.g_ret_sts_success;
2365:
2366: -- Check Use parent code flag
2367: IF p_schedule_rec.use_parent_code_flag <> FND_API.g_miss_char
2368: AND p_schedule_rec.use_parent_code_flag IS NOT NULL
2369: THEN
2370: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.use_parent_code_flag) = FND_API.g_false
2371: THEN
2366: -- Check Use parent code flag
2367: IF p_schedule_rec.use_parent_code_flag <> FND_API.g_miss_char
2368: AND p_schedule_rec.use_parent_code_flag IS NOT NULL
2369: THEN
2370: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.use_parent_code_flag) = FND_API.g_false
2371: THEN
2372: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_PARENT_FLAG');
2373: x_return_status := FND_API.g_ret_sts_error;
2374: RETURN;
2369: THEN
2370: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.use_parent_code_flag) = FND_API.g_false
2371: THEN
2372: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_PARENT_FLAG');
2373: x_return_status := FND_API.g_ret_sts_error;
2374: RETURN;
2375: END IF;
2376: END IF;
2377:
2375: END IF;
2376: END IF;
2377:
2378: -- Check Use parent code flag
2379: IF p_schedule_rec.triggerable_flag <> FND_API.g_miss_char
2380: AND p_schedule_rec.triggerable_flag IS NOT NULL
2381: THEN
2382: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.triggerable_flag) = FND_API.g_false
2383: THEN
2378: -- Check Use parent code flag
2379: IF p_schedule_rec.triggerable_flag <> FND_API.g_miss_char
2380: AND p_schedule_rec.triggerable_flag IS NOT NULL
2381: THEN
2382: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.triggerable_flag) = FND_API.g_false
2383: THEN
2384: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TRIG_FLAG');
2385: x_return_status := FND_API.g_ret_sts_error;
2386: RETURN;
2381: THEN
2382: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.triggerable_flag) = FND_API.g_false
2383: THEN
2384: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_TRIG_FLAG');
2385: x_return_status := FND_API.g_ret_sts_error;
2386: RETURN;
2387: END IF;
2388: END IF;
2389:
2387: END IF;
2388: END IF;
2389:
2390: -- Check Active flag
2391: IF p_schedule_rec.active_flag <> FND_API.g_miss_char
2392: AND p_schedule_rec.active_flag IS NOT NULL
2393: THEN
2394: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.active_flag) = FND_API.g_false
2395: THEN
2390: -- Check Active flag
2391: IF p_schedule_rec.active_flag <> FND_API.g_miss_char
2392: AND p_schedule_rec.active_flag IS NOT NULL
2393: THEN
2394: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.active_flag) = FND_API.g_false
2395: THEN
2396: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_ACTIVE_FLAG');
2397: x_return_status := FND_API.g_ret_sts_error;
2398: RETURN;
2393: THEN
2394: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.active_flag) = FND_API.g_false
2395: THEN
2396: AMS_Utility_PVT.Error_Message('AMS_CSCH_NO_ACTIVE_FLAG');
2397: x_return_status := FND_API.g_ret_sts_error;
2398: RETURN;
2399: END IF;
2400: END IF;
2401:
2399: END IF;
2400: END IF;
2401:
2402: -- Check accounts_closed_flag
2403: IF p_schedule_rec.accounts_closed_flag <> FND_API.g_miss_char
2404: AND p_schedule_rec.accounts_closed_flag IS NOT NULL
2405: THEN
2406: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.accounts_closed_flag) = FND_API.g_false
2407: THEN
2402: -- Check accounts_closed_flag
2403: IF p_schedule_rec.accounts_closed_flag <> FND_API.g_miss_char
2404: AND p_schedule_rec.accounts_closed_flag IS NOT NULL
2405: THEN
2406: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.accounts_closed_flag) = FND_API.g_false
2407: THEN
2408: AMS_Utility_PVT.Error_Message('AMS_CSCH_ACC_CLOSED_FLAG');
2409: x_return_status := FND_API.g_ret_sts_error;
2410: RETURN;
2405: THEN
2406: IF AMS_Utility_PVT.is_Y_or_N(p_schedule_rec.accounts_closed_flag) = FND_API.g_false
2407: THEN
2408: AMS_Utility_PVT.Error_Message('AMS_CSCH_ACC_CLOSED_FLAG');
2409: x_return_status := FND_API.g_ret_sts_error;
2410: RETURN;
2411: END IF;
2412: END IF;
2413:
2439: check_schedule_uk_items(
2440: p_schedule_rec => p_schedule_rec,
2441: p_validation_mode => p_validation_mode,
2442: x_return_status => x_return_status);
2443: IF x_return_status <> FND_API.g_ret_sts_success THEN
2444: RETURN;
2445: END IF;
2446:
2447: -- Check Items Required/NOT NULL API calls
2449: check_schedule_req_items(
2450: p_schedule_rec => p_schedule_rec,
2451: p_validation_mode => p_validation_mode,
2452: x_return_status => x_return_status);
2453: IF x_return_status <> FND_API.g_ret_sts_success THEN
2454: RETURN;
2455: END IF;
2456: -- Check Items Foreign Keys API calls
2457:
2457:
2458: check_schedule_FK_items(
2459: p_schedule_rec => p_schedule_rec,
2460: x_return_status => x_return_status);
2461: IF x_return_status <> FND_API.g_ret_sts_success THEN
2462: RETURN;
2463: END IF;
2464:
2465: -- Check Items Lookups
2465: -- Check Items Lookups
2466: check_schedule_Lookup_items(
2467: p_schedule_rec => p_schedule_rec,
2468: x_return_status => x_return_status);
2469: IF x_return_status <> FND_API.g_ret_sts_success THEN
2470: RETURN;
2471: END IF;
2472:
2473: -- Check Items Flags
2473: -- Check Items Flags
2474: Check_Schedule_Flag_Items(
2475: p_schedule_rec => p_schedule_rec,
2476: x_return_status => x_return_status);
2477: IF x_return_status <> FND_API.g_ret_sts_success THEN
2478: RETURN;
2479: END IF;
2480:
2481: END Check_schedule_Items;
2513: FETCH c_schedule INTO l_schedule_rec;
2514: IF c_schedule%NOTFOUND THEN
2515: CLOSE c_schedule;
2516: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
2517: RAISE FND_API.g_exc_error;
2518: END IF;
2519: CLOSE c_schedule;
2520:
2521: IF p_schedule_rec.campaign_id = FND_API.g_miss_num THEN
2517: RAISE FND_API.g_exc_error;
2518: END IF;
2519: CLOSE c_schedule;
2520:
2521: IF p_schedule_rec.campaign_id = FND_API.g_miss_num THEN
2522: x_complete_rec.campaign_id := l_schedule_rec.campaign_id ;
2523: END IF;
2524:
2525: IF p_schedule_rec.user_status_id = FND_API.g_miss_num THEN
2521: IF p_schedule_rec.campaign_id = FND_API.g_miss_num THEN
2522: x_complete_rec.campaign_id := l_schedule_rec.campaign_id ;
2523: END IF;
2524:
2525: IF p_schedule_rec.user_status_id = FND_API.g_miss_num THEN
2526: x_complete_rec.user_status_id := l_schedule_rec.user_status_id;
2527: END IF;
2528:
2529: -- status_code will go with user_status_id
2530: x_complete_rec.status_code := AMS_Utility_PVT.get_system_status_code(
2531: x_complete_rec.user_status_id
2532: );
2533:
2534: IF p_schedule_rec.status_date = FND_API.g_miss_date
2535: OR p_schedule_rec.status_date IS NULL
2536: THEN
2537: IF p_schedule_rec.user_status_id = l_schedule_rec.user_status_id THEN
2538: -- no status change, set it to be the original value
2542: x_complete_rec.status_date := SYSDATE;
2543: END IF;
2544: END IF;
2545:
2546: IF p_schedule_rec.source_code = FND_API.g_miss_char THEN
2547: x_complete_rec.source_code := l_schedule_rec.source_code;
2548: END IF;
2549:
2550: IF p_schedule_rec.use_parent_code_flag = FND_API.g_miss_char THEN
2546: IF p_schedule_rec.source_code = FND_API.g_miss_char THEN
2547: x_complete_rec.source_code := l_schedule_rec.source_code;
2548: END IF;
2549:
2550: IF p_schedule_rec.use_parent_code_flag = FND_API.g_miss_char THEN
2551: x_complete_rec.use_parent_code_flag := l_schedule_rec.use_parent_code_flag;
2552: END IF;
2553:
2554: IF p_schedule_rec.start_date_time = FND_API.g_miss_date THEN
2550: IF p_schedule_rec.use_parent_code_flag = FND_API.g_miss_char THEN
2551: x_complete_rec.use_parent_code_flag := l_schedule_rec.use_parent_code_flag;
2552: END IF;
2553:
2554: IF p_schedule_rec.start_date_time = FND_API.g_miss_date THEN
2555: x_complete_rec.start_date_time := l_schedule_rec.start_date_time;
2556: END IF;
2557:
2558: IF p_schedule_rec.end_date_time = FND_API.g_miss_date THEN
2554: IF p_schedule_rec.start_date_time = FND_API.g_miss_date THEN
2555: x_complete_rec.start_date_time := l_schedule_rec.start_date_time;
2556: END IF;
2557:
2558: IF p_schedule_rec.end_date_time = FND_API.g_miss_date THEN
2559: x_complete_rec.end_date_time := l_schedule_rec.end_date_time;
2560: END IF;
2561:
2562: IF p_schedule_rec.timezone_id = FND_API.g_miss_num THEN
2558: IF p_schedule_rec.end_date_time = FND_API.g_miss_date THEN
2559: x_complete_rec.end_date_time := l_schedule_rec.end_date_time;
2560: END IF;
2561:
2562: IF p_schedule_rec.timezone_id = FND_API.g_miss_num THEN
2563: x_complete_rec.timezone_id := l_schedule_rec.timezone_id;
2564: END IF;
2565:
2566: IF p_schedule_rec.activity_type_code = FND_API.g_miss_char THEN
2562: IF p_schedule_rec.timezone_id = FND_API.g_miss_num THEN
2563: x_complete_rec.timezone_id := l_schedule_rec.timezone_id;
2564: END IF;
2565:
2566: IF p_schedule_rec.activity_type_code = FND_API.g_miss_char THEN
2567: x_complete_rec.activity_type_code := l_schedule_rec.activity_type_code;
2568: END IF;
2569:
2570: IF p_schedule_rec.activity_id = FND_API.g_miss_num THEN
2566: IF p_schedule_rec.activity_type_code = FND_API.g_miss_char THEN
2567: x_complete_rec.activity_type_code := l_schedule_rec.activity_type_code;
2568: END IF;
2569:
2570: IF p_schedule_rec.activity_id = FND_API.g_miss_num THEN
2571: x_complete_rec.activity_id := l_schedule_rec.activity_id;
2572: END IF;
2573:
2574: IF p_schedule_rec.arc_marketing_medium_from = FND_API.g_miss_char THEN
2570: IF p_schedule_rec.activity_id = FND_API.g_miss_num THEN
2571: x_complete_rec.activity_id := l_schedule_rec.activity_id;
2572: END IF;
2573:
2574: IF p_schedule_rec.arc_marketing_medium_from = FND_API.g_miss_char THEN
2575: x_complete_rec.arc_marketing_medium_from := l_schedule_rec.arc_marketing_medium_from;
2576: END IF;
2577:
2578: IF p_schedule_rec.marketing_medium_id = FND_API.g_miss_num THEN
2574: IF p_schedule_rec.arc_marketing_medium_from = FND_API.g_miss_char THEN
2575: x_complete_rec.arc_marketing_medium_from := l_schedule_rec.arc_marketing_medium_from;
2576: END IF;
2577:
2578: IF p_schedule_rec.marketing_medium_id = FND_API.g_miss_num THEN
2579: x_complete_rec.marketing_medium_id := l_schedule_rec.marketing_medium_id;
2580: END IF;
2581:
2582: IF p_schedule_rec.custom_setup_id = FND_API.g_miss_num THEN
2578: IF p_schedule_rec.marketing_medium_id = FND_API.g_miss_num THEN
2579: x_complete_rec.marketing_medium_id := l_schedule_rec.marketing_medium_id;
2580: END IF;
2581:
2582: IF p_schedule_rec.custom_setup_id = FND_API.g_miss_num THEN
2583: x_complete_rec.custom_setup_id := l_schedule_rec.custom_setup_id;
2584: END IF;
2585:
2586: IF p_schedule_rec.triggerable_flag = FND_API.g_miss_char THEN
2582: IF p_schedule_rec.custom_setup_id = FND_API.g_miss_num THEN
2583: x_complete_rec.custom_setup_id := l_schedule_rec.custom_setup_id;
2584: END IF;
2585:
2586: IF p_schedule_rec.triggerable_flag = FND_API.g_miss_char THEN
2587: x_complete_rec.triggerable_flag := l_schedule_rec.triggerable_flag;
2588: END IF;
2589:
2590: IF p_schedule_rec.trigger_id = FND_API.g_miss_num THEN
2586: IF p_schedule_rec.triggerable_flag = FND_API.g_miss_char THEN
2587: x_complete_rec.triggerable_flag := l_schedule_rec.triggerable_flag;
2588: END IF;
2589:
2590: IF p_schedule_rec.trigger_id = FND_API.g_miss_num THEN
2591: x_complete_rec.trigger_id := l_schedule_rec.trigger_id;
2592: END IF;
2593:
2594: IF p_schedule_rec.notify_user_id = FND_API.g_miss_num THEN
2590: IF p_schedule_rec.trigger_id = FND_API.g_miss_num THEN
2591: x_complete_rec.trigger_id := l_schedule_rec.trigger_id;
2592: END IF;
2593:
2594: IF p_schedule_rec.notify_user_id = FND_API.g_miss_num THEN
2595: x_complete_rec.notify_user_id := l_schedule_rec.notify_user_id;
2596: END IF;
2597:
2598: IF p_schedule_rec.approver_user_id = FND_API.g_miss_num THEN
2594: IF p_schedule_rec.notify_user_id = FND_API.g_miss_num THEN
2595: x_complete_rec.notify_user_id := l_schedule_rec.notify_user_id;
2596: END IF;
2597:
2598: IF p_schedule_rec.approver_user_id = FND_API.g_miss_num THEN
2599: x_complete_rec.approver_user_id := l_schedule_rec.approver_user_id;
2600: END IF;
2601:
2602: IF p_schedule_rec.owner_user_id = FND_API.g_miss_num THEN
2598: IF p_schedule_rec.approver_user_id = FND_API.g_miss_num THEN
2599: x_complete_rec.approver_user_id := l_schedule_rec.approver_user_id;
2600: END IF;
2601:
2602: IF p_schedule_rec.owner_user_id = FND_API.g_miss_num THEN
2603: x_complete_rec.owner_user_id := l_schedule_rec.owner_user_id;
2604: END IF;
2605:
2606: IF p_schedule_rec.active_flag = FND_API.g_miss_char THEN
2602: IF p_schedule_rec.owner_user_id = FND_API.g_miss_num THEN
2603: x_complete_rec.owner_user_id := l_schedule_rec.owner_user_id;
2604: END IF;
2605:
2606: IF p_schedule_rec.active_flag = FND_API.g_miss_char THEN
2607: x_complete_rec.active_flag := l_schedule_rec.active_flag;
2608: END IF;
2609:
2610: IF p_schedule_rec.cover_letter_id = FND_API.g_miss_num THEN
2606: IF p_schedule_rec.active_flag = FND_API.g_miss_char THEN
2607: x_complete_rec.active_flag := l_schedule_rec.active_flag;
2608: END IF;
2609:
2610: IF p_schedule_rec.cover_letter_id = FND_API.g_miss_num THEN
2611: x_complete_rec.cover_letter_id := l_schedule_rec.cover_letter_id;
2612: END IF;
2613:
2614: IF p_schedule_rec.reply_to_mail = FND_API.g_miss_char THEN
2610: IF p_schedule_rec.cover_letter_id = FND_API.g_miss_num THEN
2611: x_complete_rec.cover_letter_id := l_schedule_rec.cover_letter_id;
2612: END IF;
2613:
2614: IF p_schedule_rec.reply_to_mail = FND_API.g_miss_char THEN
2615: x_complete_rec.reply_to_mail := l_schedule_rec.reply_to_mail;
2616: END IF;
2617:
2618: IF p_schedule_rec.mail_sender_name = FND_API.g_miss_char THEN
2614: IF p_schedule_rec.reply_to_mail = FND_API.g_miss_char THEN
2615: x_complete_rec.reply_to_mail := l_schedule_rec.reply_to_mail;
2616: END IF;
2617:
2618: IF p_schedule_rec.mail_sender_name = FND_API.g_miss_char THEN
2619: x_complete_rec.mail_sender_name := l_schedule_rec.mail_sender_name;
2620: END IF;
2621:
2622: IF p_schedule_rec.mail_subject = FND_API.g_miss_char THEN
2618: IF p_schedule_rec.mail_sender_name = FND_API.g_miss_char THEN
2619: x_complete_rec.mail_sender_name := l_schedule_rec.mail_sender_name;
2620: END IF;
2621:
2622: IF p_schedule_rec.mail_subject = FND_API.g_miss_char THEN
2623: x_complete_rec.mail_subject := l_schedule_rec.mail_subject;
2624: END IF;
2625:
2626: IF p_schedule_rec.from_fax_no = FND_API.g_miss_char THEN
2622: IF p_schedule_rec.mail_subject = FND_API.g_miss_char THEN
2623: x_complete_rec.mail_subject := l_schedule_rec.mail_subject;
2624: END IF;
2625:
2626: IF p_schedule_rec.from_fax_no = FND_API.g_miss_char THEN
2627: x_complete_rec.from_fax_no := l_schedule_rec.from_fax_no;
2628: END IF;
2629:
2630: IF p_schedule_rec.accounts_closed_flag = FND_API.g_miss_char THEN
2626: IF p_schedule_rec.from_fax_no = FND_API.g_miss_char THEN
2627: x_complete_rec.from_fax_no := l_schedule_rec.from_fax_no;
2628: END IF;
2629:
2630: IF p_schedule_rec.accounts_closed_flag = FND_API.g_miss_char THEN
2631: x_complete_rec.accounts_closed_flag := l_schedule_rec.accounts_closed_flag;
2632: END IF;
2633:
2634: IF p_schedule_rec.org_id = FND_API.g_miss_num THEN
2630: IF p_schedule_rec.accounts_closed_flag = FND_API.g_miss_char THEN
2631: x_complete_rec.accounts_closed_flag := l_schedule_rec.accounts_closed_flag;
2632: END IF;
2633:
2634: IF p_schedule_rec.org_id = FND_API.g_miss_num THEN
2635: x_complete_rec.org_id := l_schedule_rec.org_id;
2636: END IF;
2637:
2638: IF p_schedule_rec.objective_code = FND_API.g_miss_char THEN
2634: IF p_schedule_rec.org_id = FND_API.g_miss_num THEN
2635: x_complete_rec.org_id := l_schedule_rec.org_id;
2636: END IF;
2637:
2638: IF p_schedule_rec.objective_code = FND_API.g_miss_char THEN
2639: x_complete_rec.objective_code := l_schedule_rec.objective_code;
2640: END IF;
2641:
2642: IF p_schedule_rec.country_id = FND_API.g_miss_num THEN
2638: IF p_schedule_rec.objective_code = FND_API.g_miss_char THEN
2639: x_complete_rec.objective_code := l_schedule_rec.objective_code;
2640: END IF;
2641:
2642: IF p_schedule_rec.country_id = FND_API.g_miss_num THEN
2643: x_complete_rec.country_id := l_schedule_rec.country_id;
2644: END IF;
2645:
2646: IF p_schedule_rec.campaign_calendar = FND_API.g_miss_char THEN
2642: IF p_schedule_rec.country_id = FND_API.g_miss_num THEN
2643: x_complete_rec.country_id := l_schedule_rec.country_id;
2644: END IF;
2645:
2646: IF p_schedule_rec.campaign_calendar = FND_API.g_miss_char THEN
2647: x_complete_rec.campaign_calendar:= l_schedule_rec.campaign_calendar ;
2648: END IF;
2649:
2650: IF p_schedule_rec.start_period_name = FND_API.g_miss_char THEN
2646: IF p_schedule_rec.campaign_calendar = FND_API.g_miss_char THEN
2647: x_complete_rec.campaign_calendar:= l_schedule_rec.campaign_calendar ;
2648: END IF;
2649:
2650: IF p_schedule_rec.start_period_name = FND_API.g_miss_char THEN
2651: x_complete_rec.start_period_name := l_schedule_rec.start_period_name;
2652: END IF;
2653:
2654: IF p_schedule_rec.end_period_name = FND_API.g_miss_char THEN
2650: IF p_schedule_rec.start_period_name = FND_API.g_miss_char THEN
2651: x_complete_rec.start_period_name := l_schedule_rec.start_period_name;
2652: END IF;
2653:
2654: IF p_schedule_rec.end_period_name = FND_API.g_miss_char THEN
2655: x_complete_rec.end_period_name := l_schedule_rec.end_period_name;
2656: END IF;
2657:
2658: IF p_schedule_rec.priority = FND_API.g_miss_char THEN
2654: IF p_schedule_rec.end_period_name = FND_API.g_miss_char THEN
2655: x_complete_rec.end_period_name := l_schedule_rec.end_period_name;
2656: END IF;
2657:
2658: IF p_schedule_rec.priority = FND_API.g_miss_char THEN
2659: x_complete_rec.priority := l_schedule_rec.priority;
2660: END IF;
2661:
2662: IF p_schedule_rec.workflow_item_key = FND_API.g_miss_char THEN
2658: IF p_schedule_rec.priority = FND_API.g_miss_char THEN
2659: x_complete_rec.priority := l_schedule_rec.priority;
2660: END IF;
2661:
2662: IF p_schedule_rec.workflow_item_key = FND_API.g_miss_char THEN
2663: x_complete_rec.workflow_item_key := l_schedule_rec.workflow_item_key;
2664: END IF;
2665:
2666: IF p_schedule_rec.transaction_currency_code = FND_API.g_miss_char THEN
2662: IF p_schedule_rec.workflow_item_key = FND_API.g_miss_char THEN
2663: x_complete_rec.workflow_item_key := l_schedule_rec.workflow_item_key;
2664: END IF;
2665:
2666: IF p_schedule_rec.transaction_currency_code = FND_API.g_miss_char THEN
2667: x_complete_rec.transaction_currency_code := l_schedule_rec.transaction_currency_code ;
2668: END IF;
2669:
2670: IF p_schedule_rec.functional_currency_code = FND_API.g_miss_char THEN
2666: IF p_schedule_rec.transaction_currency_code = FND_API.g_miss_char THEN
2667: x_complete_rec.transaction_currency_code := l_schedule_rec.transaction_currency_code ;
2668: END IF;
2669:
2670: IF p_schedule_rec.functional_currency_code = FND_API.g_miss_char THEN
2671: x_complete_rec.functional_currency_code := l_schedule_rec.functional_currency_code ;
2672: END IF;
2673:
2674: IF p_schedule_rec.budget_amount_tc = FND_API.g_miss_num THEN
2670: IF p_schedule_rec.functional_currency_code = FND_API.g_miss_char THEN
2671: x_complete_rec.functional_currency_code := l_schedule_rec.functional_currency_code ;
2672: END IF;
2673:
2674: IF p_schedule_rec.budget_amount_tc = FND_API.g_miss_num THEN
2675: x_complete_rec.budget_amount_tc := l_schedule_rec.budget_amount_tc;
2676: END IF;
2677:
2678: IF p_schedule_rec.budget_amount_fc = FND_API.g_miss_num THEN
2674: IF p_schedule_rec.budget_amount_tc = FND_API.g_miss_num THEN
2675: x_complete_rec.budget_amount_tc := l_schedule_rec.budget_amount_tc;
2676: END IF;
2677:
2678: IF p_schedule_rec.budget_amount_fc = FND_API.g_miss_num THEN
2679: x_complete_rec.budget_amount_fc := l_schedule_rec.budget_amount_fc;
2680: END IF;
2681:
2682: IF p_schedule_rec.language_code = FND_API.g_miss_char THEN
2678: IF p_schedule_rec.budget_amount_fc = FND_API.g_miss_num THEN
2679: x_complete_rec.budget_amount_fc := l_schedule_rec.budget_amount_fc;
2680: END IF;
2681:
2682: IF p_schedule_rec.language_code = FND_API.g_miss_char THEN
2683: x_complete_rec.language_code := l_schedule_rec.language_code ;
2684: END IF;
2685:
2686: IF p_schedule_rec.task_id = FND_API.g_miss_num THEN
2682: IF p_schedule_rec.language_code = FND_API.g_miss_char THEN
2683: x_complete_rec.language_code := l_schedule_rec.language_code ;
2684: END IF;
2685:
2686: IF p_schedule_rec.task_id = FND_API.g_miss_num THEN
2687: x_complete_rec.task_id := l_schedule_rec.task_id;
2688: END IF;
2689:
2690: IF p_schedule_rec.related_event_from = FND_API.g_miss_char THEN
2686: IF p_schedule_rec.task_id = FND_API.g_miss_num THEN
2687: x_complete_rec.task_id := l_schedule_rec.task_id;
2688: END IF;
2689:
2690: IF p_schedule_rec.related_event_from = FND_API.g_miss_char THEN
2691: x_complete_rec.related_event_from := l_schedule_rec.related_event_from ;
2692: END IF;
2693:
2694: IF p_schedule_rec.related_event_id = FND_API.g_miss_num THEN
2690: IF p_schedule_rec.related_event_from = FND_API.g_miss_char THEN
2691: x_complete_rec.related_event_from := l_schedule_rec.related_event_from ;
2692: END IF;
2693:
2694: IF p_schedule_rec.related_event_id = FND_API.g_miss_num THEN
2695: x_complete_rec.related_event_id := l_schedule_rec.related_event_id;
2696: END IF;
2697:
2698:
2695: x_complete_rec.related_event_id := l_schedule_rec.related_event_id;
2696: END IF;
2697:
2698:
2699: IF p_schedule_rec.attribute_category = FND_API.g_miss_char THEN
2700: x_complete_rec.attribute_category := l_schedule_rec.attribute_category;
2701: END IF;
2702:
2703: IF p_schedule_rec.attribute1 = FND_API.g_miss_char THEN
2699: IF p_schedule_rec.attribute_category = FND_API.g_miss_char THEN
2700: x_complete_rec.attribute_category := l_schedule_rec.attribute_category;
2701: END IF;
2702:
2703: IF p_schedule_rec.attribute1 = FND_API.g_miss_char THEN
2704: x_complete_rec.attribute1 := l_schedule_rec.attribute1;
2705: END IF;
2706:
2707: IF p_schedule_rec.attribute2 = FND_API.g_miss_char THEN
2703: IF p_schedule_rec.attribute1 = FND_API.g_miss_char THEN
2704: x_complete_rec.attribute1 := l_schedule_rec.attribute1;
2705: END IF;
2706:
2707: IF p_schedule_rec.attribute2 = FND_API.g_miss_char THEN
2708: x_complete_rec.attribute2 := l_schedule_rec.attribute2;
2709: END IF;
2710:
2711: IF p_schedule_rec.attribute3 = FND_API.g_miss_char THEN
2707: IF p_schedule_rec.attribute2 = FND_API.g_miss_char THEN
2708: x_complete_rec.attribute2 := l_schedule_rec.attribute2;
2709: END IF;
2710:
2711: IF p_schedule_rec.attribute3 = FND_API.g_miss_char THEN
2712: x_complete_rec.attribute3 := l_schedule_rec.attribute3;
2713: END IF;
2714:
2715: IF p_schedule_rec.attribute4 = FND_API.g_miss_char THEN
2711: IF p_schedule_rec.attribute3 = FND_API.g_miss_char THEN
2712: x_complete_rec.attribute3 := l_schedule_rec.attribute3;
2713: END IF;
2714:
2715: IF p_schedule_rec.attribute4 = FND_API.g_miss_char THEN
2716: x_complete_rec.attribute4 := l_schedule_rec.attribute4;
2717: END IF;
2718:
2719: IF p_schedule_rec.attribute5 = FND_API.g_miss_char THEN
2715: IF p_schedule_rec.attribute4 = FND_API.g_miss_char THEN
2716: x_complete_rec.attribute4 := l_schedule_rec.attribute4;
2717: END IF;
2718:
2719: IF p_schedule_rec.attribute5 = FND_API.g_miss_char THEN
2720: x_complete_rec.attribute5 := l_schedule_rec.attribute5;
2721: END IF;
2722:
2723: IF p_schedule_rec.attribute6 = FND_API.g_miss_char THEN
2719: IF p_schedule_rec.attribute5 = FND_API.g_miss_char THEN
2720: x_complete_rec.attribute5 := l_schedule_rec.attribute5;
2721: END IF;
2722:
2723: IF p_schedule_rec.attribute6 = FND_API.g_miss_char THEN
2724: x_complete_rec.attribute6 := l_schedule_rec.attribute6;
2725: END IF;
2726:
2727: IF p_schedule_rec.attribute7 = FND_API.g_miss_char THEN
2723: IF p_schedule_rec.attribute6 = FND_API.g_miss_char THEN
2724: x_complete_rec.attribute6 := l_schedule_rec.attribute6;
2725: END IF;
2726:
2727: IF p_schedule_rec.attribute7 = FND_API.g_miss_char THEN
2728: x_complete_rec.attribute7 := l_schedule_rec.attribute7;
2729: END IF;
2730:
2731: IF p_schedule_rec.attribute8 = FND_API.g_miss_char THEN
2727: IF p_schedule_rec.attribute7 = FND_API.g_miss_char THEN
2728: x_complete_rec.attribute7 := l_schedule_rec.attribute7;
2729: END IF;
2730:
2731: IF p_schedule_rec.attribute8 = FND_API.g_miss_char THEN
2732: x_complete_rec.attribute8 := l_schedule_rec.attribute8;
2733: END IF;
2734:
2735: IF p_schedule_rec.attribute9 = FND_API.g_miss_char THEN
2731: IF p_schedule_rec.attribute8 = FND_API.g_miss_char THEN
2732: x_complete_rec.attribute8 := l_schedule_rec.attribute8;
2733: END IF;
2734:
2735: IF p_schedule_rec.attribute9 = FND_API.g_miss_char THEN
2736: x_complete_rec.attribute9 := l_schedule_rec.attribute9;
2737: END IF;
2738:
2739: IF p_schedule_rec.attribute10 = FND_API.g_miss_char THEN
2735: IF p_schedule_rec.attribute9 = FND_API.g_miss_char THEN
2736: x_complete_rec.attribute9 := l_schedule_rec.attribute9;
2737: END IF;
2738:
2739: IF p_schedule_rec.attribute10 = FND_API.g_miss_char THEN
2740: x_complete_rec.attribute10 := l_schedule_rec.attribute10;
2741: END IF;
2742:
2743: IF p_schedule_rec.attribute11 = FND_API.g_miss_char THEN
2739: IF p_schedule_rec.attribute10 = FND_API.g_miss_char THEN
2740: x_complete_rec.attribute10 := l_schedule_rec.attribute10;
2741: END IF;
2742:
2743: IF p_schedule_rec.attribute11 = FND_API.g_miss_char THEN
2744: x_complete_rec.attribute11 := l_schedule_rec.attribute11;
2745: END IF;
2746:
2747: IF p_schedule_rec.attribute12 = FND_API.g_miss_char THEN
2743: IF p_schedule_rec.attribute11 = FND_API.g_miss_char THEN
2744: x_complete_rec.attribute11 := l_schedule_rec.attribute11;
2745: END IF;
2746:
2747: IF p_schedule_rec.attribute12 = FND_API.g_miss_char THEN
2748: x_complete_rec.attribute12 := l_schedule_rec.attribute12;
2749: END IF;
2750:
2751: IF p_schedule_rec.attribute13 = FND_API.g_miss_char THEN
2747: IF p_schedule_rec.attribute12 = FND_API.g_miss_char THEN
2748: x_complete_rec.attribute12 := l_schedule_rec.attribute12;
2749: END IF;
2750:
2751: IF p_schedule_rec.attribute13 = FND_API.g_miss_char THEN
2752: x_complete_rec.attribute13 := l_schedule_rec.attribute13;
2753: END IF;
2754:
2755: IF p_schedule_rec.attribute14 = FND_API.g_miss_char THEN
2751: IF p_schedule_rec.attribute13 = FND_API.g_miss_char THEN
2752: x_complete_rec.attribute13 := l_schedule_rec.attribute13;
2753: END IF;
2754:
2755: IF p_schedule_rec.attribute14 = FND_API.g_miss_char THEN
2756: x_complete_rec.attribute14 := l_schedule_rec.attribute14;
2757: END IF;
2758:
2759: IF p_schedule_rec.attribute15 = FND_API.g_miss_char THEN
2755: IF p_schedule_rec.attribute14 = FND_API.g_miss_char THEN
2756: x_complete_rec.attribute14 := l_schedule_rec.attribute14;
2757: END IF;
2758:
2759: IF p_schedule_rec.attribute15 = FND_API.g_miss_char THEN
2760: x_complete_rec.attribute15 := l_schedule_rec.attribute15;
2761: END IF;
2762:
2763: IF p_schedule_rec.attribute_category = FND_API.g_miss_char THEN
2759: IF p_schedule_rec.attribute15 = FND_API.g_miss_char THEN
2760: x_complete_rec.attribute15 := l_schedule_rec.attribute15;
2761: END IF;
2762:
2763: IF p_schedule_rec.attribute_category = FND_API.g_miss_char THEN
2764: x_complete_rec.attribute_category := l_schedule_rec.attribute_category;
2765: END IF;
2766:
2767: IF p_schedule_rec.activity_attribute1 = FND_API.g_miss_char THEN
2763: IF p_schedule_rec.attribute_category = FND_API.g_miss_char THEN
2764: x_complete_rec.attribute_category := l_schedule_rec.attribute_category;
2765: END IF;
2766:
2767: IF p_schedule_rec.activity_attribute1 = FND_API.g_miss_char THEN
2768: x_complete_rec.activity_attribute1 := l_schedule_rec.activity_attribute1;
2769: END IF;
2770:
2771: IF p_schedule_rec.activity_attribute2 = FND_API.g_miss_char THEN
2767: IF p_schedule_rec.activity_attribute1 = FND_API.g_miss_char THEN
2768: x_complete_rec.activity_attribute1 := l_schedule_rec.activity_attribute1;
2769: END IF;
2770:
2771: IF p_schedule_rec.activity_attribute2 = FND_API.g_miss_char THEN
2772: x_complete_rec.activity_attribute2 := l_schedule_rec.activity_attribute2;
2773: END IF;
2774:
2775: IF p_schedule_rec.activity_attribute3 = FND_API.g_miss_char THEN
2771: IF p_schedule_rec.activity_attribute2 = FND_API.g_miss_char THEN
2772: x_complete_rec.activity_attribute2 := l_schedule_rec.activity_attribute2;
2773: END IF;
2774:
2775: IF p_schedule_rec.activity_attribute3 = FND_API.g_miss_char THEN
2776: x_complete_rec.activity_attribute3 := l_schedule_rec.activity_attribute3;
2777: END IF;
2778:
2779: IF p_schedule_rec.activity_attribute4 = FND_API.g_miss_char THEN
2775: IF p_schedule_rec.activity_attribute3 = FND_API.g_miss_char THEN
2776: x_complete_rec.activity_attribute3 := l_schedule_rec.activity_attribute3;
2777: END IF;
2778:
2779: IF p_schedule_rec.activity_attribute4 = FND_API.g_miss_char THEN
2780: x_complete_rec.activity_attribute4 := l_schedule_rec.activity_attribute4;
2781: END IF;
2782:
2783: IF p_schedule_rec.activity_attribute5 = FND_API.g_miss_char THEN
2779: IF p_schedule_rec.activity_attribute4 = FND_API.g_miss_char THEN
2780: x_complete_rec.activity_attribute4 := l_schedule_rec.activity_attribute4;
2781: END IF;
2782:
2783: IF p_schedule_rec.activity_attribute5 = FND_API.g_miss_char THEN
2784: x_complete_rec.activity_attribute5 := l_schedule_rec.activity_attribute5;
2785: END IF;
2786:
2787: IF p_schedule_rec.activity_attribute6 = FND_API.g_miss_char THEN
2783: IF p_schedule_rec.activity_attribute5 = FND_API.g_miss_char THEN
2784: x_complete_rec.activity_attribute5 := l_schedule_rec.activity_attribute5;
2785: END IF;
2786:
2787: IF p_schedule_rec.activity_attribute6 = FND_API.g_miss_char THEN
2788: x_complete_rec.activity_attribute6 := l_schedule_rec.activity_attribute6;
2789: END IF;
2790:
2791: IF p_schedule_rec.activity_attribute7 = FND_API.g_miss_char THEN
2787: IF p_schedule_rec.activity_attribute6 = FND_API.g_miss_char THEN
2788: x_complete_rec.activity_attribute6 := l_schedule_rec.activity_attribute6;
2789: END IF;
2790:
2791: IF p_schedule_rec.activity_attribute7 = FND_API.g_miss_char THEN
2792: x_complete_rec.activity_attribute7 := l_schedule_rec.activity_attribute7;
2793: END IF;
2794:
2795: IF p_schedule_rec.activity_attribute8 = FND_API.g_miss_char THEN
2791: IF p_schedule_rec.activity_attribute7 = FND_API.g_miss_char THEN
2792: x_complete_rec.activity_attribute7 := l_schedule_rec.activity_attribute7;
2793: END IF;
2794:
2795: IF p_schedule_rec.activity_attribute8 = FND_API.g_miss_char THEN
2796: x_complete_rec.activity_attribute8 := l_schedule_rec.activity_attribute8;
2797: END IF;
2798:
2799: IF p_schedule_rec.activity_attribute9 = FND_API.g_miss_char THEN
2795: IF p_schedule_rec.activity_attribute8 = FND_API.g_miss_char THEN
2796: x_complete_rec.activity_attribute8 := l_schedule_rec.activity_attribute8;
2797: END IF;
2798:
2799: IF p_schedule_rec.activity_attribute9 = FND_API.g_miss_char THEN
2800: x_complete_rec.activity_attribute9 := l_schedule_rec.activity_attribute9;
2801: END IF;
2802:
2803: IF p_schedule_rec.activity_attribute10 = FND_API.g_miss_char THEN
2799: IF p_schedule_rec.activity_attribute9 = FND_API.g_miss_char THEN
2800: x_complete_rec.activity_attribute9 := l_schedule_rec.activity_attribute9;
2801: END IF;
2802:
2803: IF p_schedule_rec.activity_attribute10 = FND_API.g_miss_char THEN
2804: x_complete_rec.activity_attribute10 := l_schedule_rec.activity_attribute10;
2805: END IF;
2806:
2807: IF p_schedule_rec.activity_attribute11 = FND_API.g_miss_char THEN
2803: IF p_schedule_rec.activity_attribute10 = FND_API.g_miss_char THEN
2804: x_complete_rec.activity_attribute10 := l_schedule_rec.activity_attribute10;
2805: END IF;
2806:
2807: IF p_schedule_rec.activity_attribute11 = FND_API.g_miss_char THEN
2808: x_complete_rec.activity_attribute11 := l_schedule_rec.activity_attribute11;
2809: END IF;
2810:
2811: IF p_schedule_rec.activity_attribute12 = FND_API.g_miss_char THEN
2807: IF p_schedule_rec.activity_attribute11 = FND_API.g_miss_char THEN
2808: x_complete_rec.activity_attribute11 := l_schedule_rec.activity_attribute11;
2809: END IF;
2810:
2811: IF p_schedule_rec.activity_attribute12 = FND_API.g_miss_char THEN
2812: x_complete_rec.activity_attribute12 := l_schedule_rec.activity_attribute12;
2813: END IF;
2814:
2815: IF p_schedule_rec.activity_attribute13 = FND_API.g_miss_char THEN
2811: IF p_schedule_rec.activity_attribute12 = FND_API.g_miss_char THEN
2812: x_complete_rec.activity_attribute12 := l_schedule_rec.activity_attribute12;
2813: END IF;
2814:
2815: IF p_schedule_rec.activity_attribute13 = FND_API.g_miss_char THEN
2816: x_complete_rec.activity_attribute13 := l_schedule_rec.activity_attribute13;
2817: END IF;
2818:
2819: IF p_schedule_rec.activity_attribute14 = FND_API.g_miss_char THEN
2815: IF p_schedule_rec.activity_attribute13 = FND_API.g_miss_char THEN
2816: x_complete_rec.activity_attribute13 := l_schedule_rec.activity_attribute13;
2817: END IF;
2818:
2819: IF p_schedule_rec.activity_attribute14 = FND_API.g_miss_char THEN
2820: x_complete_rec.activity_attribute14 := l_schedule_rec.activity_attribute14;
2821: END IF;
2822:
2823: IF p_schedule_rec.activity_attribute15 = FND_API.g_miss_char THEN
2819: IF p_schedule_rec.activity_attribute14 = FND_API.g_miss_char THEN
2820: x_complete_rec.activity_attribute14 := l_schedule_rec.activity_attribute14;
2821: END IF;
2822:
2823: IF p_schedule_rec.activity_attribute15 = FND_API.g_miss_char THEN
2824: x_complete_rec.activity_attribute15 := l_schedule_rec.activity_attribute15;
2825: END IF;
2826:
2827: IF p_schedule_rec.schedule_name = FND_API.g_miss_char THEN
2823: IF p_schedule_rec.activity_attribute15 = FND_API.g_miss_char THEN
2824: x_complete_rec.activity_attribute15 := l_schedule_rec.activity_attribute15;
2825: END IF;
2826:
2827: IF p_schedule_rec.schedule_name = FND_API.g_miss_char THEN
2828: x_complete_rec.schedule_name := l_schedule_rec.schedule_name;
2829: END IF;
2830:
2831: IF p_schedule_rec.description = FND_API.g_miss_char THEN
2827: IF p_schedule_rec.schedule_name = FND_API.g_miss_char THEN
2828: x_complete_rec.schedule_name := l_schedule_rec.schedule_name;
2829: END IF;
2830:
2831: IF p_schedule_rec.description = FND_API.g_miss_char THEN
2832: x_complete_rec.description := l_schedule_rec.description;
2833: END IF;
2834:
2835: -- removed by soagrawa on 24-sep-2001
2832: x_complete_rec.description := l_schedule_rec.description;
2833: END IF;
2834:
2835: -- removed by soagrawa on 24-sep-2001
2836: -- IF p_schedule_rec.security_group_id = FND_API.g_miss_num THEN
2837: -- x_complete_rec.security_group_id := l_schedule_rec.security_group_id;
2838: -- END IF;
2839:
2840: --following are added by anchaudh on 27-jun-2003
2837: -- x_complete_rec.security_group_id := l_schedule_rec.security_group_id;
2838: -- END IF;
2839:
2840: --following are added by anchaudh on 27-jun-2003
2841: IF p_schedule_rec.trig_repeat_flag = FND_API.g_miss_char THEN
2842: x_complete_rec.trig_repeat_flag := l_schedule_rec.trig_repeat_flag;
2843: END IF;
2844:
2845: IF p_schedule_rec.tgrp_exclude_prev_flag = FND_API.g_miss_char THEN
2841: IF p_schedule_rec.trig_repeat_flag = FND_API.g_miss_char THEN
2842: x_complete_rec.trig_repeat_flag := l_schedule_rec.trig_repeat_flag;
2843: END IF;
2844:
2845: IF p_schedule_rec.tgrp_exclude_prev_flag = FND_API.g_miss_char THEN
2846: x_complete_rec.tgrp_exclude_prev_flag := l_schedule_rec.tgrp_exclude_prev_flag;
2847: END IF;
2848:
2849: IF p_schedule_rec.orig_csch_id = FND_API.g_miss_num THEN
2845: IF p_schedule_rec.tgrp_exclude_prev_flag = FND_API.g_miss_char THEN
2846: x_complete_rec.tgrp_exclude_prev_flag := l_schedule_rec.tgrp_exclude_prev_flag;
2847: END IF;
2848:
2849: IF p_schedule_rec.orig_csch_id = FND_API.g_miss_num THEN
2850: x_complete_rec.orig_csch_id := l_schedule_rec.orig_csch_id;
2851: END IF;
2852:
2853: IF p_schedule_rec.cover_letter_version = FND_API.g_miss_num THEN
2849: IF p_schedule_rec.orig_csch_id = FND_API.g_miss_num THEN
2850: x_complete_rec.orig_csch_id := l_schedule_rec.orig_csch_id;
2851: END IF;
2852:
2853: IF p_schedule_rec.cover_letter_version = FND_API.g_miss_num THEN
2854: x_complete_rec.cover_letter_version := l_schedule_rec.cover_letter_version;
2855: END IF;
2856:
2857: IF p_schedule_rec.usage = FND_API.g_miss_char THEN
2853: IF p_schedule_rec.cover_letter_version = FND_API.g_miss_num THEN
2854: x_complete_rec.cover_letter_version := l_schedule_rec.cover_letter_version;
2855: END IF;
2856:
2857: IF p_schedule_rec.usage = FND_API.g_miss_char THEN
2858: x_complete_rec.usage := l_schedule_rec.usage;
2859: END IF;
2860:
2861: IF p_schedule_rec.purpose = FND_API.g_miss_char THEN
2857: IF p_schedule_rec.usage = FND_API.g_miss_char THEN
2858: x_complete_rec.usage := l_schedule_rec.usage;
2859: END IF;
2860:
2861: IF p_schedule_rec.purpose = FND_API.g_miss_char THEN
2862: x_complete_rec.purpose := l_schedule_rec.purpose;
2863: END IF;
2864:
2865: IF p_schedule_rec.last_activation_date = FND_API.g_miss_date THEN
2861: IF p_schedule_rec.purpose = FND_API.g_miss_char THEN
2862: x_complete_rec.purpose := l_schedule_rec.purpose;
2863: END IF;
2864:
2865: IF p_schedule_rec.last_activation_date = FND_API.g_miss_date THEN
2866: x_complete_rec.last_activation_date := l_schedule_rec.last_activation_date;
2867: END IF;
2868:
2869: IF p_schedule_rec.sales_methodology_id = FND_API.g_miss_num THEN
2865: IF p_schedule_rec.last_activation_date = FND_API.g_miss_date THEN
2866: x_complete_rec.last_activation_date := l_schedule_rec.last_activation_date;
2867: END IF;
2868:
2869: IF p_schedule_rec.sales_methodology_id = FND_API.g_miss_num THEN
2870: x_complete_rec.sales_methodology_id := l_schedule_rec.sales_methodology_id;
2871: END IF;
2872:
2873: IF p_schedule_rec.printer_address = FND_API.g_miss_char THEN
2869: IF p_schedule_rec.sales_methodology_id = FND_API.g_miss_num THEN
2870: x_complete_rec.sales_methodology_id := l_schedule_rec.sales_methodology_id;
2871: END IF;
2872:
2873: IF p_schedule_rec.printer_address = FND_API.g_miss_char THEN
2874: x_complete_rec.printer_address := l_schedule_rec.printer_address;
2875: END IF;
2876:
2877: IF p_schedule_rec.notify_on_activation_flag = FND_API.g_miss_char THEN
2873: IF p_schedule_rec.printer_address = FND_API.g_miss_char THEN
2874: x_complete_rec.printer_address := l_schedule_rec.printer_address;
2875: END IF;
2876:
2877: IF p_schedule_rec.notify_on_activation_flag = FND_API.g_miss_char THEN
2878: x_complete_rec.notify_on_activation_flag := l_schedule_rec.notify_on_activation_flag;
2879: END IF;
2880:
2881: IF p_schedule_rec.sender_display_name = FND_API.g_miss_char THEN
2877: IF p_schedule_rec.notify_on_activation_flag = FND_API.g_miss_char THEN
2878: x_complete_rec.notify_on_activation_flag := l_schedule_rec.notify_on_activation_flag;
2879: END IF;
2880:
2881: IF p_schedule_rec.sender_display_name = FND_API.g_miss_char THEN
2882: x_complete_rec.sender_display_name := l_schedule_rec.sender_display_name;
2883: END IF;
2884:
2885: IF p_schedule_rec.delivery_mode = FND_API.g_miss_char THEN
2881: IF p_schedule_rec.sender_display_name = FND_API.g_miss_char THEN
2882: x_complete_rec.sender_display_name := l_schedule_rec.sender_display_name;
2883: END IF;
2884:
2885: IF p_schedule_rec.delivery_mode = FND_API.g_miss_char THEN
2886: x_complete_rec.delivery_mode := l_schedule_rec.delivery_mode;
2887: END IF;
2888:
2889: END Complete_schedule_Rec;
2901: -- 22-Jan-2001 PTENDULK Created
2902: --===================================================================
2903: PROCEDURE Validate_camp_schedule(
2904: p_api_version_number IN NUMBER,
2905: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2906: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2907: p_schedule_rec IN schedule_rec_type,
2908: p_validation_mode IN VARCHAR2,
2909: x_return_status OUT NOCOPY VARCHAR2,
2902: --===================================================================
2903: PROCEDURE Validate_camp_schedule(
2904: p_api_version_number IN NUMBER,
2905: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2906: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2907: p_schedule_rec IN schedule_rec_type,
2908: p_validation_mode IN VARCHAR2,
2909: x_return_status OUT NOCOPY VARCHAR2,
2910: x_msg_count OUT NOCOPY NUMBER,
2920: -- Standard Start of API savepoint
2921: SAVEPOINT VALIDATE_Camp_Schedule_;
2922:
2923: -- Standard call to check for call compatibility.
2924: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2925: p_api_version_number,
2926: l_api_name,
2927: G_PKG_NAME)
2928: THEN
2925: p_api_version_number,
2926: l_api_name,
2927: G_PKG_NAME)
2928: THEN
2929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: END IF;
2931:
2932: -- Initialize message list if p_init_msg_list is set to TRUE.
2933: IF FND_API.to_Boolean( p_init_msg_list )
2929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: END IF;
2931:
2932: -- Initialize message list if p_init_msg_list is set to TRUE.
2933: IF FND_API.to_Boolean( p_init_msg_list )
2934: THEN
2935: FND_MSG_PUB.initialize;
2936: END IF;
2937:
2941: p_validation_mode => JTF_PLSQL_API.g_update,
2942: x_return_status => x_return_status
2943: );
2944:
2945: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2949: END IF;
2942: x_return_status => x_return_status
2943: );
2944:
2945: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2949: END IF;
2950: END IF;
2943: );
2944:
2945: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2949: END IF;
2950: END IF;
2951:
2944:
2945: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2949: END IF;
2950: END IF;
2951:
2952: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2969: END IF;
2970: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2971: Validate_schedule_Rec(
2972: p_api_version_number => 1.0,
2973: p_init_msg_list => FND_API.G_FALSE,
2974: x_return_status => x_return_status,
2975: x_msg_count => x_msg_count,
2976: x_msg_data => x_msg_data,
2977: p_schedule_rec => l_schedule_rec);
2975: x_msg_count => x_msg_count,
2976: x_msg_data => x_msg_data,
2977: p_schedule_rec => l_schedule_rec);
2978:
2979: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2980: RAISE FND_API.G_EXC_ERROR;
2981: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: END IF;
2976: x_msg_data => x_msg_data,
2977: p_schedule_rec => l_schedule_rec);
2978:
2979: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2980: RAISE FND_API.G_EXC_ERROR;
2981: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: END IF;
2984: END IF;
2977: p_schedule_rec => l_schedule_rec);
2978:
2979: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2980: RAISE FND_API.G_EXC_ERROR;
2981: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: END IF;
2984: END IF;
2985:
2978:
2979: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2980: RAISE FND_API.G_EXC_ERROR;
2981: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: END IF;
2984: END IF;
2985:
2986: IF (AMS_DEBUG_HIGH_ON) THEN
2996: p_complete_rec => l_schedule_rec,
2997: p_validation_mode => p_validation_mode,
2998: x_return_status => x_return_status
2999: ) ;
3000: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
2997: p_validation_mode => p_validation_mode,
2998: x_return_status => x_return_status
2999: ) ;
3000: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
3005: END IF ;
2998: x_return_status => x_return_status
2999: ) ;
3000: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
3005: END IF ;
3006:
2999: ) ;
3000: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR;
3002: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
3005: END IF ;
3006:
3007: -- Debug Message
3010: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3011: END IF;
3012:
3013: -- Initialize API return status to SUCCESS
3014: x_return_status := FND_API.G_RET_STS_SUCCESS;
3015:
3016: -- Debug Message
3017: IF (AMS_DEBUG_HIGH_ON) THEN
3018:
3026: );
3027: EXCEPTION
3028:
3029: WHEN AMS_Utility_PVT.resource_locked THEN
3030: x_return_status := FND_API.g_ret_sts_error;
3031: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
3032:
3033: WHEN FND_API.G_EXC_ERROR THEN
3034: ROLLBACK TO VALIDATE_Camp_Schedule_;
3029: WHEN AMS_Utility_PVT.resource_locked THEN
3030: x_return_status := FND_API.g_ret_sts_error;
3031: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
3032:
3033: WHEN FND_API.G_EXC_ERROR THEN
3034: ROLLBACK TO VALIDATE_Camp_Schedule_;
3035: x_return_status := FND_API.G_RET_STS_ERROR;
3036: -- Standard call to get message count and if count=1, get the message
3037: FND_MSG_PUB.Count_And_Get (
3031: AMS_Utility_PVT.Error_Message('AMS_API_RESOURCE_LOCKED');
3032:
3033: WHEN FND_API.G_EXC_ERROR THEN
3034: ROLLBACK TO VALIDATE_Camp_Schedule_;
3035: x_return_status := FND_API.G_RET_STS_ERROR;
3036: -- Standard call to get message count and if count=1, get the message
3037: FND_MSG_PUB.Count_And_Get (
3038: p_encoded => FND_API.G_FALSE,
3039: p_count => x_msg_count,
3034: ROLLBACK TO VALIDATE_Camp_Schedule_;
3035: x_return_status := FND_API.G_RET_STS_ERROR;
3036: -- Standard call to get message count and if count=1, get the message
3037: FND_MSG_PUB.Count_And_Get (
3038: p_encoded => FND_API.G_FALSE,
3039: p_count => x_msg_count,
3040: p_data => x_msg_data
3041: );
3042:
3039: p_count => x_msg_count,
3040: p_data => x_msg_data
3041: );
3042:
3043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3044: ROLLBACK TO VALIDATE_Camp_Schedule_;
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3046: -- Standard call to get message count and if count=1, get the message
3047: FND_MSG_PUB.Count_And_Get (
3041: );
3042:
3043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3044: ROLLBACK TO VALIDATE_Camp_Schedule_;
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3046: -- Standard call to get message count and if count=1, get the message
3047: FND_MSG_PUB.Count_And_Get (
3048: p_encoded => FND_API.G_FALSE,
3049: p_count => x_msg_count,
3044: ROLLBACK TO VALIDATE_Camp_Schedule_;
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3046: -- Standard call to get message count and if count=1, get the message
3047: FND_MSG_PUB.Count_And_Get (
3048: p_encoded => FND_API.G_FALSE,
3049: p_count => x_msg_count,
3050: p_data => x_msg_data
3051: );
3052:
3051: );
3052:
3053: WHEN OTHERS THEN
3054: ROLLBACK TO VALIDATE_Camp_Schedule_;
3055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3056: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3057: THEN
3058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3059: END IF;
3058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3059: END IF;
3060: -- Standard call to get message count and if count=1, get the message
3061: FND_MSG_PUB.Count_And_Get (
3062: p_encoded => FND_API.G_FALSE,
3063: p_count => x_msg_count,
3064: p_data => x_msg_data
3065: );
3066: End Validate_Camp_Schedule;
3085: -- keeping repeating schedules in consideration
3086: --===================================================================
3087: PROCEDURE Validate_schedule_rec(
3088: p_api_version_number IN NUMBER,
3089: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3090: x_return_status OUT NOCOPY VARCHAR2,
3091: x_msg_count OUT NOCOPY NUMBER,
3092: x_msg_data OUT NOCOPY VARCHAR2,
3093: p_schedule_rec IN schedule_rec_type
3094: )
3095: IS
3096: BEGIN
3097: -- Initialize message list if p_init_msg_list is set to TRUE.
3098: IF FND_API.to_Boolean( p_init_msg_list )
3099: THEN
3100: FND_MSG_PUB.initialize;
3101: END IF;
3102:
3100: FND_MSG_PUB.initialize;
3101: END IF;
3102:
3103: -- Initialize API return status to SUCCESS
3104: x_return_status := FND_API.G_RET_STS_SUCCESS;
3105:
3106: -- Debug Message
3107: IF (AMS_DEBUG_HIGH_ON) THEN
3108:
3113: IF p_schedule_rec.transaction_currency_code IS NULL
3114: AND p_schedule_rec.budget_amount_tc IS NOT NULL
3115: THEN
3116: AMS_Utility_PVT.Error_Message('AMS_CAMP_BUDGET_NO_CURRENCY');
3117: x_return_status := FND_API.g_ret_sts_error;
3118: END IF;
3119:
3120: IF p_schedule_rec.end_date_time IS NOT NULL THEN
3121: IF p_schedule_rec.start_date_time > p_schedule_rec.end_date_time THEN
3119:
3120: IF p_schedule_rec.end_date_time IS NOT NULL THEN
3121: IF p_schedule_rec.start_date_time > p_schedule_rec.end_date_time THEN
3122: AMS_Utility_PVT.Error_Message('AMS_CAMP_START_AFTER_END');
3123: x_return_status := FND_API.g_ret_sts_error;
3124: END IF ;
3125: END IF ;
3126:
3127: -- added by soagrawa on 03-dec-2001 : end date mandatory for schedules of type events
3128: -- bug# 2131521
3129: IF p_schedule_rec.activity_type_code = 'EVENTS' THEN
3130: IF p_schedule_rec.end_date_time IS NULL THEN
3131: AMS_Utility_PVT.Error_Message('AMS_CSCH_END_DATE_MAND');
3132: x_return_status := FND_API.G_RET_STS_ERROR;
3133: RETURN;
3134: END IF;
3135: END IF ;
3136: --end soagrawa 03-dec-2001
3139: -- following validations modified by soagrawa on 22-nov-2003 for 11.5.10 repeating schedules' addition
3140:
3141: IF (p_schedule_rec.triggerable_flag = 'Y' AND p_schedule_rec.trigger_id IS NULL) THEN
3142: AMS_Utility_PVT.Error_Message('AMS_SELECT_TRIGGER');
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: RETURN;
3145: END IF;
3146:
3147: /* IF (p_schedule_rec.triggerable_flag = 'N' AND p_schedule_rec.tgrp_exclude_prev_flag = 'Y') THEN
3145: END IF;
3146:
3147: /* IF (p_schedule_rec.triggerable_flag = 'N' AND p_schedule_rec.tgrp_exclude_prev_flag = 'Y') THEN
3148: AMS_Utility_PVT.Error_Message('AMS_DONOT_TRIG_TGRP');
3149: x_return_status := FND_API.G_RET_STS_ERROR;
3150: RETURN;
3151: END IF;
3152: */
3153:
3154: -- soagrawa added clause p_schedule_rec.triggerable_flag = 'Y'
3155: -- on 23-mar-2004
3156: IF (p_schedule_rec.trig_repeat_flag = 'N' AND p_schedule_rec.triggerable_flag = 'Y' AND p_schedule_rec.tgrp_exclude_prev_flag = 'Y') THEN
3157: AMS_Utility_PVT.Error_Message('AMS_TRIG_EXCLUDE_TGRP');
3158: x_return_status := FND_API.G_RET_STS_ERROR;
3159: RETURN;
3160: END IF;
3161:
3162: /*
3161:
3162: /*
3163: IF (p_schedule_rec.triggerable_flag = 'N' AND p_schedule_rec.trig_repeat_flag = 'Y') THEN
3164: AMS_Utility_PVT.Error_Message('AMS_DONOT_TRIG_REPEAT');
3165: x_return_status := FND_API.G_RET_STS_ERROR;
3166: RETURN;
3167: END IF;
3168: */
3169:
3235: l_dummy NUMBER ;
3236:
3237: BEGIN
3238:
3239: x_return_status := FND_API.g_ret_sts_success;
3240:
3241: ------------------- check media type ----------------------
3242: -- IF p_camp_rec.parent_campaign_id <> FND_API.g_miss_num
3243: -- OR p_camp_rec.rollup_type <> FND_API.g_miss_char
3238:
3239: x_return_status := FND_API.g_ret_sts_success;
3240:
3241: ------------------- check media type ----------------------
3242: -- IF p_camp_rec.parent_campaign_id <> FND_API.g_miss_num
3243: -- OR p_camp_rec.rollup_type <> FND_API.g_miss_char
3244: -- OR p_camp_rec.media_type_code <> FND_API.g_miss_char
3245: -- OR p_camp_rec.media_id <> FND_API.g_miss_num
3246: -- OR p_camp_rec.channel_id <> FND_API.g_miss_num
3239: x_return_status := FND_API.g_ret_sts_success;
3240:
3241: ------------------- check media type ----------------------
3242: -- IF p_camp_rec.parent_campaign_id <> FND_API.g_miss_num
3243: -- OR p_camp_rec.rollup_type <> FND_API.g_miss_char
3244: -- OR p_camp_rec.media_type_code <> FND_API.g_miss_char
3245: -- OR p_camp_rec.media_id <> FND_API.g_miss_num
3246: -- OR p_camp_rec.channel_id <> FND_API.g_miss_num
3247: -- OR p_camp_rec.event_type <> FND_API.g_miss_char
3240:
3241: ------------------- check media type ----------------------
3242: -- IF p_camp_rec.parent_campaign_id <> FND_API.g_miss_num
3243: -- OR p_camp_rec.rollup_type <> FND_API.g_miss_char
3244: -- OR p_camp_rec.media_type_code <> FND_API.g_miss_char
3245: -- OR p_camp_rec.media_id <> FND_API.g_miss_num
3246: -- OR p_camp_rec.channel_id <> FND_API.g_miss_num
3247: -- OR p_camp_rec.event_type <> FND_API.g_miss_char
3248: -- OR p_camp_rec.arc_channel_from <> FND_API.g_miss_char
3241: ------------------- check media type ----------------------
3242: -- IF p_camp_rec.parent_campaign_id <> FND_API.g_miss_num
3243: -- OR p_camp_rec.rollup_type <> FND_API.g_miss_char
3244: -- OR p_camp_rec.media_type_code <> FND_API.g_miss_char
3245: -- OR p_camp_rec.media_id <> FND_API.g_miss_num
3246: -- OR p_camp_rec.channel_id <> FND_API.g_miss_num
3247: -- OR p_camp_rec.event_type <> FND_API.g_miss_char
3248: -- OR p_camp_rec.arc_channel_from <> FND_API.g_miss_char
3249: -- THEN
3242: -- IF p_camp_rec.parent_campaign_id <> FND_API.g_miss_num
3243: -- OR p_camp_rec.rollup_type <> FND_API.g_miss_char
3244: -- OR p_camp_rec.media_type_code <> FND_API.g_miss_char
3245: -- OR p_camp_rec.media_id <> FND_API.g_miss_num
3246: -- OR p_camp_rec.channel_id <> FND_API.g_miss_num
3247: -- OR p_camp_rec.event_type <> FND_API.g_miss_char
3248: -- OR p_camp_rec.arc_channel_from <> FND_API.g_miss_char
3249: -- THEN
3250: -- AMS_CampaignRules_PVT.check_camp_media_type(
3243: -- OR p_camp_rec.rollup_type <> FND_API.g_miss_char
3244: -- OR p_camp_rec.media_type_code <> FND_API.g_miss_char
3245: -- OR p_camp_rec.media_id <> FND_API.g_miss_num
3246: -- OR p_camp_rec.channel_id <> FND_API.g_miss_num
3247: -- OR p_camp_rec.event_type <> FND_API.g_miss_char
3248: -- OR p_camp_rec.arc_channel_from <> FND_API.g_miss_char
3249: -- THEN
3250: -- AMS_CampaignRules_PVT.check_camp_media_type(
3251: -- p_camp_rec.campaign_id,
3244: -- OR p_camp_rec.media_type_code <> FND_API.g_miss_char
3245: -- OR p_camp_rec.media_id <> FND_API.g_miss_num
3246: -- OR p_camp_rec.channel_id <> FND_API.g_miss_num
3247: -- OR p_camp_rec.event_type <> FND_API.g_miss_char
3248: -- OR p_camp_rec.arc_channel_from <> FND_API.g_miss_char
3249: -- THEN
3250: -- AMS_CampaignRules_PVT.check_camp_media_type(
3251: -- p_camp_rec.campaign_id,
3252: -- p_complete_rec.parent_campaign_id,
3257: -- p_complete_rec.event_type,
3258: -- p_complete_rec.arc_channel_from,
3259: -- l_return_status
3260: -- );
3261: -- l_return_status := FND_API.g_ret_sts_success ;
3262: -- IF l_return_status <> FND_API.g_ret_sts_success THEN
3263: -- x_return_status := l_return_status;
3264: -- END IF;
3265: -- END IF;
3258: -- p_complete_rec.arc_channel_from,
3259: -- l_return_status
3260: -- );
3261: -- l_return_status := FND_API.g_ret_sts_success ;
3262: -- IF l_return_status <> FND_API.g_ret_sts_success THEN
3263: -- x_return_status := l_return_status;
3264: -- END IF;
3265: -- END IF;
3266:
3278: OR l_status_code = 'COMPLETED'
3279: OR l_status_code = 'ON_HOLD'
3280: THEN
3281: AMS_Utility_PVT.Error_Message('AMS_CSCH_INVALID_CAMP_STAT');
3282: x_return_status := FND_API.G_RET_STS_ERROR;
3283: RETURN;
3284: END IF ;
3285:
3286: -- Following validation is added by ptendulk on 24-May-2001 to
3286: -- Following validation is added by ptendulk on 24-May-2001 to
3287: -- ensure that event type schedules can not be created for event type campaigns.
3288: IF l_rollup_type = 'EVCAM' AND p_complete_rec.activity_type_code = 'EVENTS' THEN
3289: AMS_Utility_PVT.Error_Message('AMS_CSCH_INVALID_EVENT_SCH');
3290: x_return_status := FND_API.G_RET_STS_ERROR;
3291: RETURN;
3292: END IF ;
3293:
3294: END IF ;
3298:
3299:
3300: /* - commented by Nari. Will have to add validation for related events
3301: -- Check Related Event from
3302: IF (p_schedule_rec.related_event_id IS NOT NULL AND p_schedule_rec.related_event_id <> FND_API.g_miss_num)
3303: OR (p_schedule_rec.related_event_from IS NOT NULL AND p_schedule_rec.related_event_from <> FND_API.g_miss_char)
3304: THEN
3305: -- Get table_name and pk_name for the ARC qualifier.
3306: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (
3299:
3300: /* - commented by Nari. Will have to add validation for related events
3301: -- Check Related Event from
3302: IF (p_schedule_rec.related_event_id IS NOT NULL AND p_schedule_rec.related_event_id <> FND_API.g_miss_num)
3303: OR (p_schedule_rec.related_event_from IS NOT NULL AND p_schedule_rec.related_event_from <> FND_API.g_miss_char)
3304: THEN
3305: -- Get table_name and pk_name for the ARC qualifier.
3306: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (
3307: p_sys_qual => p_complete_rec.related_event_from,
3319: ,p_pk_name => l_pk_name
3320: ,p_pk_value => l_pk_value
3321: ,p_pk_data_type => l_pk_data_type
3322: ,p_additional_where_clause => l_where_clause
3323: ) = FND_API.G_FALSE
3324: THEN
3325: AMS_UTILITY_PVT.Error_Message('AMS_CAMP_INVALID_EVENT');
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: RETURN;
3322: ,p_additional_where_clause => l_where_clause
3323: ) = FND_API.G_FALSE
3324: THEN
3325: AMS_UTILITY_PVT.Error_Message('AMS_CAMP_INVALID_EVENT');
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: RETURN;
3328: END IF;
3329: END IF ;*/
3330:
3332: -- checking calendar (i.e. periods) : commented out by soagrawa on 03-dec-2001
3333: --refer to bug# 2132456
3334: ------------------- check calendar ----------------------
3335: /*
3336: IF (p_schedule_rec.campaign_calendar <> FND_API.g_miss_char AND
3337: p_schedule_rec.campaign_calendar IS NOT NULL ) OR
3338: (p_schedule_rec.start_period_name <> FND_API.g_miss_char AND
3339: p_schedule_rec.start_period_name IS NOT NULL ) OR
3340: (p_schedule_rec.end_period_name <> FND_API.g_miss_char AND
3334: ------------------- check calendar ----------------------
3335: /*
3336: IF (p_schedule_rec.campaign_calendar <> FND_API.g_miss_char AND
3337: p_schedule_rec.campaign_calendar IS NOT NULL ) OR
3338: (p_schedule_rec.start_period_name <> FND_API.g_miss_char AND
3339: p_schedule_rec.start_period_name IS NOT NULL ) OR
3340: (p_schedule_rec.end_period_name <> FND_API.g_miss_char AND
3341: p_schedule_rec.end_period_name IS NOT NULL) OR
3342: (p_schedule_rec.start_date_time <> FND_API.g_miss_date AND
3336: IF (p_schedule_rec.campaign_calendar <> FND_API.g_miss_char AND
3337: p_schedule_rec.campaign_calendar IS NOT NULL ) OR
3338: (p_schedule_rec.start_period_name <> FND_API.g_miss_char AND
3339: p_schedule_rec.start_period_name IS NOT NULL ) OR
3340: (p_schedule_rec.end_period_name <> FND_API.g_miss_char AND
3341: p_schedule_rec.end_period_name IS NOT NULL) OR
3342: (p_schedule_rec.start_date_time <> FND_API.g_miss_date AND
3343: p_schedule_rec.start_date_time IS NOT NULL) OR
3344: (p_schedule_rec.end_date_time <> FND_API.g_miss_date AND
3338: (p_schedule_rec.start_period_name <> FND_API.g_miss_char AND
3339: p_schedule_rec.start_period_name IS NOT NULL ) OR
3340: (p_schedule_rec.end_period_name <> FND_API.g_miss_char AND
3341: p_schedule_rec.end_period_name IS NOT NULL) OR
3342: (p_schedule_rec.start_date_time <> FND_API.g_miss_date AND
3343: p_schedule_rec.start_date_time IS NOT NULL) OR
3344: (p_schedule_rec.end_date_time <> FND_API.g_miss_date AND
3345: p_schedule_rec.end_date_time IS NOT NULL )
3346: THEN
3340: (p_schedule_rec.end_period_name <> FND_API.g_miss_char AND
3341: p_schedule_rec.end_period_name IS NOT NULL) OR
3342: (p_schedule_rec.start_date_time <> FND_API.g_miss_date AND
3343: p_schedule_rec.start_date_time IS NOT NULL) OR
3344: (p_schedule_rec.end_date_time <> FND_API.g_miss_date AND
3345: p_schedule_rec.end_date_time IS NOT NULL )
3346: THEN
3347: AMS_CampaignRules_PVT.check_camp_calendar(
3348: p_complete_rec.campaign_calendar,
3351: p_complete_rec.start_date_time,
3352: p_complete_rec.end_date_time,
3353: l_return_status
3354: );
3355: IF l_return_status <> FND_API.g_ret_sts_success THEN
3356: x_return_status := l_return_status;
3357: RETURN ;
3358: END IF;
3359: END IF;
3360: */
3361: -- end soagrawa 03-dec-2001
3362:
3363: ------------------- check dates ------------------------------
3364: IF (p_schedule_rec.start_date_time <> FND_API.g_miss_date AND
3365: p_schedule_rec.start_date_time IS NOT NULL) OR
3366: (p_schedule_rec.end_date_time <> FND_API.g_miss_date AND
3367: p_schedule_rec.end_date_time IS NOT NULL)
3368: THEN
3362:
3363: ------------------- check dates ------------------------------
3364: IF (p_schedule_rec.start_date_time <> FND_API.g_miss_date AND
3365: p_schedule_rec.start_date_time IS NOT NULL) OR
3366: (p_schedule_rec.end_date_time <> FND_API.g_miss_date AND
3367: p_schedule_rec.end_date_time IS NOT NULL)
3368: THEN
3369: AMS_ScheduleRules_PVT.Check_Sched_Dates_Vs_Camp(
3370: p_complete_rec.campaign_id,
3371: p_complete_rec.start_date_time,
3372: p_complete_rec.end_date_time,
3373: l_return_status
3374: );
3375: IF l_return_status <> FND_API.g_ret_sts_success THEN
3376: x_return_status := l_return_status;
3377: RETURN ;
3378: END IF;
3379: END IF;
3378: END IF;
3379: END IF;
3380:
3381: -- Check Schedule_Name
3382: IF p_schedule_rec.campaign_id <> FND_API.g_miss_num OR
3383: p_schedule_rec.schedule_name <> FND_API.g_miss_char
3384: THEN
3385: --l_table_name := 'ams_campaign_schedules_vl' ;
3386: --l_where_clause := 'campaign_id = '||p_complete_rec.campaign_id ;
3379: END IF;
3380:
3381: -- Check Schedule_Name
3382: IF p_schedule_rec.campaign_id <> FND_API.g_miss_num OR
3383: p_schedule_rec.schedule_name <> FND_API.g_miss_char
3384: THEN
3385: --l_table_name := 'ams_campaign_schedules_vl' ;
3386: --l_where_clause := 'campaign_id = '||p_complete_rec.campaign_id ;
3387: --l_where_clause := l_where_clause || ' AND UPPER(schedule_name) = '''||UPPER(p_complete_rec.schedule_name)||'''' ;
3391: --END IF ;
3392:
3393: --l_valid_flag := AMS_Utility_PVT.check_uniqueness( p_table_name => l_table_name,
3394: -- p_where_clause => l_where_clause) ;
3395: --IF l_valid_flag = FND_API.g_false THEN
3396: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
3397: -- x_return_status := FND_API.g_ret_sts_error;
3398: -- RETURN;
3399: --END IF;
3393: --l_valid_flag := AMS_Utility_PVT.check_uniqueness( p_table_name => l_table_name,
3394: -- p_where_clause => l_where_clause) ;
3395: --IF l_valid_flag = FND_API.g_false THEN
3396: -- AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
3397: -- x_return_status := FND_API.g_ret_sts_error;
3398: -- RETURN;
3399: --END IF;
3400: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
3401: OPEN c_sch_name_updt;
3409:
3410: IF l_dummy IS NOT NULL THEN
3411: -- Duplicate Schedule
3412: AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
3413: x_return_status := FND_API.g_ret_sts_error;
3414: RETURN;
3415: END IF ;
3416:
3417: END IF;
3417: END IF;
3418:
3419:
3420: -- Check the Activity type , Activity and Marketing medium associated to the schedule.
3421: IF p_schedule_rec.activity_type_code <> FND_API.g_miss_char
3422: OR p_schedule_rec.activity_id <> FND_API.g_miss_num
3423: OR p_schedule_rec.marketing_medium_id <> FND_API.g_miss_num
3424: OR p_schedule_rec.arc_marketing_medium_from <> FND_API.g_miss_char
3425: THEN
3418:
3419:
3420: -- Check the Activity type , Activity and Marketing medium associated to the schedule.
3421: IF p_schedule_rec.activity_type_code <> FND_API.g_miss_char
3422: OR p_schedule_rec.activity_id <> FND_API.g_miss_num
3423: OR p_schedule_rec.marketing_medium_id <> FND_API.g_miss_num
3424: OR p_schedule_rec.arc_marketing_medium_from <> FND_API.g_miss_char
3425: THEN
3426: AMS_ScheduleRules_PVT.Check_Schedule_Activity(
3419:
3420: -- Check the Activity type , Activity and Marketing medium associated to the schedule.
3421: IF p_schedule_rec.activity_type_code <> FND_API.g_miss_char
3422: OR p_schedule_rec.activity_id <> FND_API.g_miss_num
3423: OR p_schedule_rec.marketing_medium_id <> FND_API.g_miss_num
3424: OR p_schedule_rec.arc_marketing_medium_from <> FND_API.g_miss_char
3425: THEN
3426: AMS_ScheduleRules_PVT.Check_Schedule_Activity(
3427: p_schedule_id => p_schedule_rec.schedule_id,
3420: -- Check the Activity type , Activity and Marketing medium associated to the schedule.
3421: IF p_schedule_rec.activity_type_code <> FND_API.g_miss_char
3422: OR p_schedule_rec.activity_id <> FND_API.g_miss_num
3423: OR p_schedule_rec.marketing_medium_id <> FND_API.g_miss_num
3424: OR p_schedule_rec.arc_marketing_medium_from <> FND_API.g_miss_char
3425: THEN
3426: AMS_ScheduleRules_PVT.Check_Schedule_Activity(
3427: p_schedule_id => p_schedule_rec.schedule_id,
3428: p_activity_type => p_schedule_rec.activity_type_code,
3437: IF p_schedule_rec.activity_type_code = 'EVENTS' AND
3438: p_schedule_rec.use_parent_code_flag = 'Y'
3439: THEN
3440: AMS_Utility_PVT.Error_Message('AMS_CSCH_BAD_PARENT_CODE_FLAG');
3441: x_return_status := FND_API.g_ret_sts_error;
3442: END IF;
3443:
3444: END Check_Schedule_Inter_Entity;
3445:
3459: --===================================================================
3460: PROCEDURE Init_Schedule_Rec(x_schedule_rec OUT NOCOPY schedule_rec_type)
3461: IS
3462: BEGIN
3463: x_schedule_rec.schedule_id := FND_API.G_MISS_NUM ;
3464: x_schedule_rec.last_update_date := FND_API.G_MISS_DATE ;
3465: x_schedule_rec.last_updated_by := FND_API.G_MISS_NUM ;
3466: x_schedule_rec.creation_date := FND_API.G_MISS_DATE ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3460: PROCEDURE Init_Schedule_Rec(x_schedule_rec OUT NOCOPY schedule_rec_type)
3461: IS
3462: BEGIN
3463: x_schedule_rec.schedule_id := FND_API.G_MISS_NUM ;
3464: x_schedule_rec.last_update_date := FND_API.G_MISS_DATE ;
3465: x_schedule_rec.last_updated_by := FND_API.G_MISS_NUM ;
3466: x_schedule_rec.creation_date := FND_API.G_MISS_DATE ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3461: IS
3462: BEGIN
3463: x_schedule_rec.schedule_id := FND_API.G_MISS_NUM ;
3464: x_schedule_rec.last_update_date := FND_API.G_MISS_DATE ;
3465: x_schedule_rec.last_updated_by := FND_API.G_MISS_NUM ;
3466: x_schedule_rec.creation_date := FND_API.G_MISS_DATE ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3462: BEGIN
3463: x_schedule_rec.schedule_id := FND_API.G_MISS_NUM ;
3464: x_schedule_rec.last_update_date := FND_API.G_MISS_DATE ;
3465: x_schedule_rec.last_updated_by := FND_API.G_MISS_NUM ;
3466: x_schedule_rec.creation_date := FND_API.G_MISS_DATE ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3463: x_schedule_rec.schedule_id := FND_API.G_MISS_NUM ;
3464: x_schedule_rec.last_update_date := FND_API.G_MISS_DATE ;
3465: x_schedule_rec.last_updated_by := FND_API.G_MISS_NUM ;
3466: x_schedule_rec.creation_date := FND_API.G_MISS_DATE ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3464: x_schedule_rec.last_update_date := FND_API.G_MISS_DATE ;
3465: x_schedule_rec.last_updated_by := FND_API.G_MISS_NUM ;
3466: x_schedule_rec.creation_date := FND_API.G_MISS_DATE ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3465: x_schedule_rec.last_updated_by := FND_API.G_MISS_NUM ;
3466: x_schedule_rec.creation_date := FND_API.G_MISS_DATE ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3466: x_schedule_rec.creation_date := FND_API.G_MISS_DATE ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3467: x_schedule_rec.created_by := FND_API.G_MISS_NUM ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3468: x_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3469: x_schedule_rec.object_version_number := FND_API.G_MISS_NUM ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3470: x_schedule_rec.campaign_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3471: x_schedule_rec.user_status_id := FND_API.G_MISS_NUM ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3472: x_schedule_rec.status_code := FND_API.G_MISS_CHAR ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3473: x_schedule_rec.status_date := FND_API.G_MISS_DATE ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3474: x_schedule_rec.source_code := FND_API.G_MISS_CHAR ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3475: x_schedule_rec.use_parent_code_flag := FND_API.G_MISS_CHAR ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3476: x_schedule_rec.start_date_time := FND_API.G_MISS_DATE ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3477: x_schedule_rec.end_date_time := FND_API.G_MISS_DATE ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3478: x_schedule_rec.timezone_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3479: x_schedule_rec.activity_type_code := FND_API.G_MISS_CHAR ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3480: x_schedule_rec.activity_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3481: x_schedule_rec.arc_marketing_medium_from := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3482: x_schedule_rec.marketing_medium_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3483: x_schedule_rec.custom_setup_id := FND_API.G_MISS_NUM ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3484: x_schedule_rec.triggerable_flag := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3485: x_schedule_rec.trigger_id := FND_API.G_MISS_NUM ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3486: x_schedule_rec.notify_user_id := FND_API.G_MISS_NUM ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3487: x_schedule_rec.approver_user_id := FND_API.G_MISS_NUM ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3488: x_schedule_rec.owner_user_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3489: x_schedule_rec.active_flag := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3490: x_schedule_rec.cover_letter_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3491: x_schedule_rec.reply_to_mail := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3492: x_schedule_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3493: x_schedule_rec.mail_subject := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3494: x_schedule_rec.from_fax_no := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3495: x_schedule_rec.accounts_closed_flag := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3496: x_schedule_rec.org_id := FND_API.G_MISS_NUM ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3497: x_schedule_rec.objective_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3498: x_schedule_rec.country_id := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3499: x_schedule_rec.campaign_calendar := FND_API.G_MISS_CHAR ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3500: x_schedule_rec.start_period_name := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3501: x_schedule_rec.end_period_name := FND_API.G_MISS_CHAR ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3502: x_schedule_rec.priority := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3503: x_schedule_rec.workflow_item_key := FND_API.G_MISS_CHAR ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3504: x_schedule_rec.transaction_currency_code := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3505: x_schedule_rec.functional_currency_code := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3506: x_schedule_rec.budget_amount_tc := FND_API.G_MISS_NUM ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3507: x_schedule_rec.budget_amount_fc := FND_API.G_MISS_NUM ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3508: x_schedule_rec.language_code := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3509: x_schedule_rec.task_id := FND_API.G_MISS_NUM ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3510: x_schedule_rec.related_event_from := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3511: x_schedule_rec.related_event_id := FND_API.G_MISS_NUM ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3512: x_schedule_rec.attribute_category := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3513: x_schedule_rec.attribute1 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3514: x_schedule_rec.attribute2 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3515: x_schedule_rec.attribute3 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3516: x_schedule_rec.attribute4 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3517: x_schedule_rec.attribute5 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3518: x_schedule_rec.attribute6 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3519: x_schedule_rec.attribute7 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3520: x_schedule_rec.attribute8 := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3521: x_schedule_rec.attribute9 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3522: x_schedule_rec.attribute10 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3523: x_schedule_rec.attribute11 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3524: x_schedule_rec.attribute12 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3525: x_schedule_rec.attribute13 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3526: x_schedule_rec.attribute14 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3527: x_schedule_rec.attribute15 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3528: x_schedule_rec.activity_attribute_category := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3529: x_schedule_rec.activity_attribute1 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3530: x_schedule_rec.activity_attribute2 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3531: x_schedule_rec.activity_attribute3 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3532: x_schedule_rec.activity_attribute4 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3540: x_schedule_rec.activity_attribute12 := FND_API.G_MISS_CHAR ;
3533: x_schedule_rec.activity_attribute5 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3540: x_schedule_rec.activity_attribute12 := FND_API.G_MISS_CHAR ;
3541: x_schedule_rec.activity_attribute13 := FND_API.G_MISS_CHAR ;
3534: x_schedule_rec.activity_attribute6 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3540: x_schedule_rec.activity_attribute12 := FND_API.G_MISS_CHAR ;
3541: x_schedule_rec.activity_attribute13 := FND_API.G_MISS_CHAR ;
3542: x_schedule_rec.activity_attribute14 := FND_API.G_MISS_CHAR ;
3535: x_schedule_rec.activity_attribute7 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3540: x_schedule_rec.activity_attribute12 := FND_API.G_MISS_CHAR ;
3541: x_schedule_rec.activity_attribute13 := FND_API.G_MISS_CHAR ;
3542: x_schedule_rec.activity_attribute14 := FND_API.G_MISS_CHAR ;
3543: x_schedule_rec.activity_attribute15 := FND_API.G_MISS_CHAR ;
3536: x_schedule_rec.activity_attribute8 := FND_API.G_MISS_CHAR ;
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3540: x_schedule_rec.activity_attribute12 := FND_API.G_MISS_CHAR ;
3541: x_schedule_rec.activity_attribute13 := FND_API.G_MISS_CHAR ;
3542: x_schedule_rec.activity_attribute14 := FND_API.G_MISS_CHAR ;
3543: x_schedule_rec.activity_attribute15 := FND_API.G_MISS_CHAR ;
3544: -- removed by soagrawa on 24-sep-2001
3537: x_schedule_rec.activity_attribute9 := FND_API.G_MISS_CHAR ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3540: x_schedule_rec.activity_attribute12 := FND_API.G_MISS_CHAR ;
3541: x_schedule_rec.activity_attribute13 := FND_API.G_MISS_CHAR ;
3542: x_schedule_rec.activity_attribute14 := FND_API.G_MISS_CHAR ;
3543: x_schedule_rec.activity_attribute15 := FND_API.G_MISS_CHAR ;
3544: -- removed by soagrawa on 24-sep-2001
3545: -- x_schedule_rec.security_group_id := FND_API.G_MISS_NUM ;
3538: x_schedule_rec.activity_attribute10 := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3540: x_schedule_rec.activity_attribute12 := FND_API.G_MISS_CHAR ;
3541: x_schedule_rec.activity_attribute13 := FND_API.G_MISS_CHAR ;
3542: x_schedule_rec.activity_attribute14 := FND_API.G_MISS_CHAR ;
3543: x_schedule_rec.activity_attribute15 := FND_API.G_MISS_CHAR ;
3544: -- removed by soagrawa on 24-sep-2001
3545: -- x_schedule_rec.security_group_id := FND_API.G_MISS_NUM ;
3546: x_schedule_rec.schedule_name := FND_API.G_MISS_CHAR ;
3539: x_schedule_rec.activity_attribute11 := FND_API.G_MISS_CHAR ;
3540: x_schedule_rec.activity_attribute12 := FND_API.G_MISS_CHAR ;
3541: x_schedule_rec.activity_attribute13 := FND_API.G_MISS_CHAR ;
3542: x_schedule_rec.activity_attribute14 := FND_API.G_MISS_CHAR ;
3543: x_schedule_rec.activity_attribute15 := FND_API.G_MISS_CHAR ;
3544: -- removed by soagrawa on 24-sep-2001
3545: -- x_schedule_rec.security_group_id := FND_API.G_MISS_NUM ;
3546: x_schedule_rec.schedule_name := FND_API.G_MISS_CHAR ;
3547: x_schedule_rec.description := FND_API.G_MISS_CHAR ;
3541: x_schedule_rec.activity_attribute13 := FND_API.G_MISS_CHAR ;
3542: x_schedule_rec.activity_attribute14 := FND_API.G_MISS_CHAR ;
3543: x_schedule_rec.activity_attribute15 := FND_API.G_MISS_CHAR ;
3544: -- removed by soagrawa on 24-sep-2001
3545: -- x_schedule_rec.security_group_id := FND_API.G_MISS_NUM ;
3546: x_schedule_rec.schedule_name := FND_API.G_MISS_CHAR ;
3547: x_schedule_rec.description := FND_API.G_MISS_CHAR ;
3548: x_schedule_rec.related_source_id := FND_API.G_MISS_NUM ;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3542: x_schedule_rec.activity_attribute14 := FND_API.G_MISS_CHAR ;
3543: x_schedule_rec.activity_attribute15 := FND_API.G_MISS_CHAR ;
3544: -- removed by soagrawa on 24-sep-2001
3545: -- x_schedule_rec.security_group_id := FND_API.G_MISS_NUM ;
3546: x_schedule_rec.schedule_name := FND_API.G_MISS_CHAR ;
3547: x_schedule_rec.description := FND_API.G_MISS_CHAR ;
3548: x_schedule_rec.related_source_id := FND_API.G_MISS_NUM ;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3543: x_schedule_rec.activity_attribute15 := FND_API.G_MISS_CHAR ;
3544: -- removed by soagrawa on 24-sep-2001
3545: -- x_schedule_rec.security_group_id := FND_API.G_MISS_NUM ;
3546: x_schedule_rec.schedule_name := FND_API.G_MISS_CHAR ;
3547: x_schedule_rec.description := FND_API.G_MISS_CHAR ;
3548: x_schedule_rec.related_source_id := FND_API.G_MISS_NUM ;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3544: -- removed by soagrawa on 24-sep-2001
3545: -- x_schedule_rec.security_group_id := FND_API.G_MISS_NUM ;
3546: x_schedule_rec.schedule_name := FND_API.G_MISS_CHAR ;
3547: x_schedule_rec.description := FND_API.G_MISS_CHAR ;
3548: x_schedule_rec.related_source_id := FND_API.G_MISS_NUM ;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3545: -- x_schedule_rec.security_group_id := FND_API.G_MISS_NUM ;
3546: x_schedule_rec.schedule_name := FND_API.G_MISS_CHAR ;
3547: x_schedule_rec.description := FND_API.G_MISS_CHAR ;
3548: x_schedule_rec.related_source_id := FND_API.G_MISS_NUM ;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3553: x_schedule_rec.content_type := FND_API.G_MISS_CHAR;
3546: x_schedule_rec.schedule_name := FND_API.G_MISS_CHAR ;
3547: x_schedule_rec.description := FND_API.G_MISS_CHAR ;
3548: x_schedule_rec.related_source_id := FND_API.G_MISS_NUM ;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3553: x_schedule_rec.content_type := FND_API.G_MISS_CHAR;
3554: x_schedule_rec.test_email_address := FND_API.G_MISS_CHAR;
3547: x_schedule_rec.description := FND_API.G_MISS_CHAR ;
3548: x_schedule_rec.related_source_id := FND_API.G_MISS_NUM ;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3553: x_schedule_rec.content_type := FND_API.G_MISS_CHAR;
3554: x_schedule_rec.test_email_address := FND_API.G_MISS_CHAR;
3555: x_schedule_rec.greeting_text := FND_API.G_MISS_CHAR;
3548: x_schedule_rec.related_source_id := FND_API.G_MISS_NUM ;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3553: x_schedule_rec.content_type := FND_API.G_MISS_CHAR;
3554: x_schedule_rec.test_email_address := FND_API.G_MISS_CHAR;
3555: x_schedule_rec.greeting_text := FND_API.G_MISS_CHAR;
3556: x_schedule_rec.footer_text := FND_API.G_MISS_CHAR;
3549: x_schedule_rec.related_source_code := FND_API.G_MISS_CHAR ;
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3553: x_schedule_rec.content_type := FND_API.G_MISS_CHAR;
3554: x_schedule_rec.test_email_address := FND_API.G_MISS_CHAR;
3555: x_schedule_rec.greeting_text := FND_API.G_MISS_CHAR;
3556: x_schedule_rec.footer_text := FND_API.G_MISS_CHAR;
3557: -- following are added by anchaudh on 27-jun-2003
3550: x_schedule_rec.related_source_object := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3553: x_schedule_rec.content_type := FND_API.G_MISS_CHAR;
3554: x_schedule_rec.test_email_address := FND_API.G_MISS_CHAR;
3555: x_schedule_rec.greeting_text := FND_API.G_MISS_CHAR;
3556: x_schedule_rec.footer_text := FND_API.G_MISS_CHAR;
3557: -- following are added by anchaudh on 27-jun-2003
3558: x_schedule_rec.trig_repeat_flag := FND_API.G_MISS_CHAR ;
3551: x_schedule_rec.query_id := FND_API.G_MISS_NUM ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3553: x_schedule_rec.content_type := FND_API.G_MISS_CHAR;
3554: x_schedule_rec.test_email_address := FND_API.G_MISS_CHAR;
3555: x_schedule_rec.greeting_text := FND_API.G_MISS_CHAR;
3556: x_schedule_rec.footer_text := FND_API.G_MISS_CHAR;
3557: -- following are added by anchaudh on 27-jun-2003
3558: x_schedule_rec.trig_repeat_flag := FND_API.G_MISS_CHAR ;
3559: x_schedule_rec.tgrp_exclude_prev_flag := FND_API.G_MISS_CHAR ;
3552: x_schedule_rec.include_content_flag := FND_API.G_MISS_CHAR;
3553: x_schedule_rec.content_type := FND_API.G_MISS_CHAR;
3554: x_schedule_rec.test_email_address := FND_API.G_MISS_CHAR;
3555: x_schedule_rec.greeting_text := FND_API.G_MISS_CHAR;
3556: x_schedule_rec.footer_text := FND_API.G_MISS_CHAR;
3557: -- following are added by anchaudh on 27-jun-2003
3558: x_schedule_rec.trig_repeat_flag := FND_API.G_MISS_CHAR ;
3559: x_schedule_rec.tgrp_exclude_prev_flag := FND_API.G_MISS_CHAR ;
3560: x_schedule_rec.orig_csch_id := FND_API.G_MISS_NUM ;
3554: x_schedule_rec.test_email_address := FND_API.G_MISS_CHAR;
3555: x_schedule_rec.greeting_text := FND_API.G_MISS_CHAR;
3556: x_schedule_rec.footer_text := FND_API.G_MISS_CHAR;
3557: -- following are added by anchaudh on 27-jun-2003
3558: x_schedule_rec.trig_repeat_flag := FND_API.G_MISS_CHAR ;
3559: x_schedule_rec.tgrp_exclude_prev_flag := FND_API.G_MISS_CHAR ;
3560: x_schedule_rec.orig_csch_id := FND_API.G_MISS_NUM ;
3561: x_schedule_rec.cover_letter_version := FND_API.G_MISS_NUM ;
3562: -- following are added by dbiswas on 12-aug-2003
3555: x_schedule_rec.greeting_text := FND_API.G_MISS_CHAR;
3556: x_schedule_rec.footer_text := FND_API.G_MISS_CHAR;
3557: -- following are added by anchaudh on 27-jun-2003
3558: x_schedule_rec.trig_repeat_flag := FND_API.G_MISS_CHAR ;
3559: x_schedule_rec.tgrp_exclude_prev_flag := FND_API.G_MISS_CHAR ;
3560: x_schedule_rec.orig_csch_id := FND_API.G_MISS_NUM ;
3561: x_schedule_rec.cover_letter_version := FND_API.G_MISS_NUM ;
3562: -- following are added by dbiswas on 12-aug-2003
3563: x_schedule_rec.usage := FND_API.G_MISS_CHAR ;
3556: x_schedule_rec.footer_text := FND_API.G_MISS_CHAR;
3557: -- following are added by anchaudh on 27-jun-2003
3558: x_schedule_rec.trig_repeat_flag := FND_API.G_MISS_CHAR ;
3559: x_schedule_rec.tgrp_exclude_prev_flag := FND_API.G_MISS_CHAR ;
3560: x_schedule_rec.orig_csch_id := FND_API.G_MISS_NUM ;
3561: x_schedule_rec.cover_letter_version := FND_API.G_MISS_NUM ;
3562: -- following are added by dbiswas on 12-aug-2003
3563: x_schedule_rec.usage := FND_API.G_MISS_CHAR ;
3564: x_schedule_rec.purpose := FND_API.G_MISS_CHAR ;
3557: -- following are added by anchaudh on 27-jun-2003
3558: x_schedule_rec.trig_repeat_flag := FND_API.G_MISS_CHAR ;
3559: x_schedule_rec.tgrp_exclude_prev_flag := FND_API.G_MISS_CHAR ;
3560: x_schedule_rec.orig_csch_id := FND_API.G_MISS_NUM ;
3561: x_schedule_rec.cover_letter_version := FND_API.G_MISS_NUM ;
3562: -- following are added by dbiswas on 12-aug-2003
3563: x_schedule_rec.usage := FND_API.G_MISS_CHAR ;
3564: x_schedule_rec.purpose := FND_API.G_MISS_CHAR ;
3565: x_schedule_rec.last_activation_date := FND_API.G_MISS_DATE ;
3559: x_schedule_rec.tgrp_exclude_prev_flag := FND_API.G_MISS_CHAR ;
3560: x_schedule_rec.orig_csch_id := FND_API.G_MISS_NUM ;
3561: x_schedule_rec.cover_letter_version := FND_API.G_MISS_NUM ;
3562: -- following are added by dbiswas on 12-aug-2003
3563: x_schedule_rec.usage := FND_API.G_MISS_CHAR ;
3564: x_schedule_rec.purpose := FND_API.G_MISS_CHAR ;
3565: x_schedule_rec.last_activation_date := FND_API.G_MISS_DATE ;
3566: x_schedule_rec.sales_methodology_id := FND_API.G_MISS_NUM ;
3567: x_schedule_rec.printer_address := FND_API.G_MISS_CHAR ;
3560: x_schedule_rec.orig_csch_id := FND_API.G_MISS_NUM ;
3561: x_schedule_rec.cover_letter_version := FND_API.G_MISS_NUM ;
3562: -- following are added by dbiswas on 12-aug-2003
3563: x_schedule_rec.usage := FND_API.G_MISS_CHAR ;
3564: x_schedule_rec.purpose := FND_API.G_MISS_CHAR ;
3565: x_schedule_rec.last_activation_date := FND_API.G_MISS_DATE ;
3566: x_schedule_rec.sales_methodology_id := FND_API.G_MISS_NUM ;
3567: x_schedule_rec.printer_address := FND_API.G_MISS_CHAR ;
3568: -- following is added by dbiswas on 27-jul-2005
3561: x_schedule_rec.cover_letter_version := FND_API.G_MISS_NUM ;
3562: -- following are added by dbiswas on 12-aug-2003
3563: x_schedule_rec.usage := FND_API.G_MISS_CHAR ;
3564: x_schedule_rec.purpose := FND_API.G_MISS_CHAR ;
3565: x_schedule_rec.last_activation_date := FND_API.G_MISS_DATE ;
3566: x_schedule_rec.sales_methodology_id := FND_API.G_MISS_NUM ;
3567: x_schedule_rec.printer_address := FND_API.G_MISS_CHAR ;
3568: -- following is added by dbiswas on 27-jul-2005
3569: x_schedule_rec.notify_on_activation_flag := FND_API.G_MISS_CHAR ;
3562: -- following are added by dbiswas on 12-aug-2003
3563: x_schedule_rec.usage := FND_API.G_MISS_CHAR ;
3564: x_schedule_rec.purpose := FND_API.G_MISS_CHAR ;
3565: x_schedule_rec.last_activation_date := FND_API.G_MISS_DATE ;
3566: x_schedule_rec.sales_methodology_id := FND_API.G_MISS_NUM ;
3567: x_schedule_rec.printer_address := FND_API.G_MISS_CHAR ;
3568: -- following is added by dbiswas on 27-jul-2005
3569: x_schedule_rec.notify_on_activation_flag := FND_API.G_MISS_CHAR ;
3570: -- following is added by anchaudh on 01-Feb-2006
3563: x_schedule_rec.usage := FND_API.G_MISS_CHAR ;
3564: x_schedule_rec.purpose := FND_API.G_MISS_CHAR ;
3565: x_schedule_rec.last_activation_date := FND_API.G_MISS_DATE ;
3566: x_schedule_rec.sales_methodology_id := FND_API.G_MISS_NUM ;
3567: x_schedule_rec.printer_address := FND_API.G_MISS_CHAR ;
3568: -- following is added by dbiswas on 27-jul-2005
3569: x_schedule_rec.notify_on_activation_flag := FND_API.G_MISS_CHAR ;
3570: -- following is added by anchaudh on 01-Feb-2006
3571: x_schedule_rec.sender_display_name := FND_API.G_MISS_CHAR ;
3565: x_schedule_rec.last_activation_date := FND_API.G_MISS_DATE ;
3566: x_schedule_rec.sales_methodology_id := FND_API.G_MISS_NUM ;
3567: x_schedule_rec.printer_address := FND_API.G_MISS_CHAR ;
3568: -- following is added by dbiswas on 27-jul-2005
3569: x_schedule_rec.notify_on_activation_flag := FND_API.G_MISS_CHAR ;
3570: -- following is added by anchaudh on 01-Feb-2006
3571: x_schedule_rec.sender_display_name := FND_API.G_MISS_CHAR ;
3572: x_schedule_rec.delivery_mode := FND_API.G_MISS_CHAR ;
3573:
3567: x_schedule_rec.printer_address := FND_API.G_MISS_CHAR ;
3568: -- following is added by dbiswas on 27-jul-2005
3569: x_schedule_rec.notify_on_activation_flag := FND_API.G_MISS_CHAR ;
3570: -- following is added by anchaudh on 01-Feb-2006
3571: x_schedule_rec.sender_display_name := FND_API.G_MISS_CHAR ;
3572: x_schedule_rec.delivery_mode := FND_API.G_MISS_CHAR ;
3573:
3574:
3575: END Init_Schedule_Rec ;
3568: -- following is added by dbiswas on 27-jul-2005
3569: x_schedule_rec.notify_on_activation_flag := FND_API.G_MISS_CHAR ;
3570: -- following is added by anchaudh on 01-Feb-2006
3571: x_schedule_rec.sender_display_name := FND_API.G_MISS_CHAR ;
3572: x_schedule_rec.delivery_mode := FND_API.G_MISS_CHAR ;
3573:
3574:
3575: END Init_Schedule_Rec ;
3576:
3600: --
3601:
3602: PROCEDURE Copy_Camp_Schedule(
3603: p_api_version IN NUMBER,
3604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3607:
3608: x_return_status OUT NOCOPY VARCHAR2,
3601:
3602: PROCEDURE Copy_Camp_Schedule(
3603: p_api_version IN NUMBER,
3604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3607:
3608: x_return_status OUT NOCOPY VARCHAR2,
3609: x_msg_count OUT NOCOPY NUMBER,
3602: PROCEDURE Copy_Camp_Schedule(
3603: p_api_version IN NUMBER,
3604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3607:
3608: x_return_status OUT NOCOPY VARCHAR2,
3609: x_msg_count OUT NOCOPY NUMBER,
3610: x_msg_data OUT NOCOPY VARCHAR2,
3621: L_API_NAME CONSTANT VARCHAR2(30) := 'Copy_Camp_Schedule';
3622: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
3623: l_return_status_full VARCHAR2(1);
3624: l_object_version_number NUMBER := 1;
3625: l_org_id NUMBER := FND_API.G_MISS_NUM;
3626: l_schedule_id NUMBER;
3627: l_new_schedule_id NUMBER;
3628: l_dummy NUMBER;
3629:
3786: -- Standard Start of API savepoint
3787: SAVEPOINT COPY_Camp_Schedule_PVT;
3788:
3789: -- Standard call to check for call compatibility.
3790: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3791: p_api_version,
3792: l_api_name,
3793: G_PKG_NAME)
3794: THEN
3791: p_api_version,
3792: l_api_name,
3793: G_PKG_NAME)
3794: THEN
3795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3796: END IF;
3797:
3798: -- Initialize message list if p_init_msg_list is set to TRUE.
3799: IF FND_API.to_Boolean( p_init_msg_list )
3795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3796: END IF;
3797:
3798: -- Initialize message list if p_init_msg_list is set to TRUE.
3799: IF FND_API.to_Boolean( p_init_msg_list )
3800: THEN
3801: FND_MSG_PUB.initialize;
3802: END IF;
3803:
3808: END IF;
3809:
3810:
3811: -- Initialize API return status to SUCCESS
3812: x_return_status := FND_API.G_RET_STS_SUCCESS;
3813:
3814:
3815: --
3816: -- Start of API body
3824: FETCH fetch_sch_details INTO l_reference_rec;
3825: CLOSE fetch_sch_details;
3826:
3827: -- Copy GENERAL info from source schedule
3828: -- IF AMS_CpyUtility_PVT.is_copy_attribute ('DETL', p_attributes_table) = FND_API.G_TRUE THEN
3829: -- OPEN fetch_sch_details(p_source_object_id);
3830: -- FETCH fetch_sch_details INTO l_schedule_rec;
3831: -- CLOSE fetch_sch_details;
3832: -- END IF;
4208: -- dhsingh, 28.07.2004, Bug# 3798545.
4209: /*
4210: AMS_EventOffer_PVT.create_event_offer (
4211: p_api_version => 1.0,
4212: p_init_msg_list => FND_API.G_FALSE,
4213: p_commit => FND_API.G_FALSE,
4214: p_validation_level => FND_API.g_valid_level_full,
4215: p_evo_rec => l_event_offer_rec,
4216: x_return_status => x_return_status,
4209: /*
4210: AMS_EventOffer_PVT.create_event_offer (
4211: p_api_version => 1.0,
4212: p_init_msg_list => FND_API.G_FALSE,
4213: p_commit => FND_API.G_FALSE,
4214: p_validation_level => FND_API.g_valid_level_full,
4215: p_evo_rec => l_event_offer_rec,
4216: x_return_status => x_return_status,
4217: x_msg_count => x_msg_count,
4210: AMS_EventOffer_PVT.create_event_offer (
4211: p_api_version => 1.0,
4212: p_init_msg_list => FND_API.G_FALSE,
4213: p_commit => FND_API.G_FALSE,
4214: p_validation_level => FND_API.g_valid_level_full,
4215: p_evo_rec => l_event_offer_rec,
4216: x_return_status => x_return_status,
4217: x_msg_count => x_msg_count,
4218: x_msg_data => x_msg_data,
4220: );
4221: */
4222: AMS_EventOffer_PUB.create_EventOffer(
4223: p_api_version => 1.0,
4224: p_init_msg_list => FND_API.G_FALSE,
4225: p_commit => FND_API.G_FALSE,
4226: p_validation_level => FND_API.g_valid_level_full,
4227: p_evo_rec => l_event_offer_rec,
4228: x_return_status => x_return_status,
4221: */
4222: AMS_EventOffer_PUB.create_EventOffer(
4223: p_api_version => 1.0,
4224: p_init_msg_list => FND_API.G_FALSE,
4225: p_commit => FND_API.G_FALSE,
4226: p_validation_level => FND_API.g_valid_level_full,
4227: p_evo_rec => l_event_offer_rec,
4228: x_return_status => x_return_status,
4229: x_msg_count => x_msg_count,
4222: AMS_EventOffer_PUB.create_EventOffer(
4223: p_api_version => 1.0,
4224: p_init_msg_list => FND_API.G_FALSE,
4225: p_commit => FND_API.G_FALSE,
4226: p_validation_level => FND_API.g_valid_level_full,
4227: p_evo_rec => l_event_offer_rec,
4228: x_return_status => x_return_status,
4229: x_msg_count => x_msg_count,
4230: x_msg_data => x_msg_data,
4234: -- END dhsingh
4235:
4236: AMS_UTILITY_PVT.debug_message('after calling create event offer '||l_new_event_offer_id);
4237:
4238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4239: RAISE FND_API.G_EXC_ERROR;
4240: END IF;
4241:
4242:
4235:
4236: AMS_UTILITY_PVT.debug_message('after calling create event offer '||l_new_event_offer_id);
4237:
4238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4239: RAISE FND_API.G_EXC_ERROR;
4240: END IF;
4241:
4242:
4243:
4252: p_errmsg => l_errmsg
4253: );
4254:
4255: IF l_errnum > 0 THEN
4256: RAISE FND_API.G_EXC_ERROR;
4257: END IF;
4258: */
4259:
4260:
4303:
4304: l_schedule_rec,
4305: l_new_schedule_id ) ;
4306: -- END dhsingh
4307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4308: RAISE FND_API.G_EXC_ERROR;
4309: END IF;
4310:
4311: -- Attributes:
4304: l_schedule_rec,
4305: l_new_schedule_id ) ;
4306: -- END dhsingh
4307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4308: RAISE FND_API.G_EXC_ERROR;
4309: END IF;
4310:
4311: -- Attributes:
4312: -- Event Agenda AGEN // Leave for later
4320: -- Registration REGS // Leave for later
4321: -- Task TASK
4322:
4323:
4324: IF AMS_CpyUtility_PVT.is_copy_attribute ('AGEN', p_attributes_table) = FND_API.G_TRUE
4325: THEN l_attr_list.p_AGEN := 'Y';
4326: END IF;
4327:
4328: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
4324: IF AMS_CpyUtility_PVT.is_copy_attribute ('AGEN', p_attributes_table) = FND_API.G_TRUE
4325: THEN l_attr_list.p_AGEN := 'Y';
4326: END IF;
4327:
4328: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
4329: THEN l_attr_list.p_ATCH := 'Y';
4330: END IF;
4331:
4332: IF AMS_CpyUtility_PVT.is_copy_attribute ('CATG', p_attributes_table) = FND_API.G_TRUE
4328: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
4329: THEN l_attr_list.p_ATCH := 'Y';
4330: END IF;
4331:
4332: IF AMS_CpyUtility_PVT.is_copy_attribute ('CATG', p_attributes_table) = FND_API.G_TRUE
4333: THEN l_attr_list.p_CATG := 'Y';
4334: END IF;
4335:
4336: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
4332: IF AMS_CpyUtility_PVT.is_copy_attribute ('CATG', p_attributes_table) = FND_API.G_TRUE
4333: THEN l_attr_list.p_CATG := 'Y';
4334: END IF;
4335:
4336: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
4337: THEN l_attr_list.p_CELL := 'Y';
4338: END IF;
4339:
4340: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
4336: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
4337: THEN l_attr_list.p_CELL := 'Y';
4338: END IF;
4339:
4340: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
4341: THEN l_attr_list.p_DELV := 'Y';
4342: END IF;
4343:
4344: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
4340: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
4341: THEN l_attr_list.p_DELV := 'Y';
4342: END IF;
4343:
4344: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
4345: THEN l_attr_list.p_MESG := 'Y';
4346: END IF;
4347:
4348: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
4344: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
4345: THEN l_attr_list.p_MESG := 'Y';
4346: END IF;
4347:
4348: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
4349: THEN l_attr_list.p_PROD := 'Y';
4350: END IF;
4351:
4352: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
4348: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
4349: THEN l_attr_list.p_PROD := 'Y';
4350: END IF;
4351:
4352: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
4353: THEN l_attr_list.p_PTNR := 'Y';
4354: END IF;
4355:
4356: IF AMS_CpyUtility_PVT.is_copy_attribute ('REGS', p_attributes_table) = FND_API.G_TRUE
4352: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
4353: THEN l_attr_list.p_PTNR := 'Y';
4354: END IF;
4355:
4356: IF AMS_CpyUtility_PVT.is_copy_attribute ('REGS', p_attributes_table) = FND_API.G_TRUE
4357: THEN l_attr_list.p_REGS := 'Y';
4358: END IF;
4359:
4360: -- added by soagrawa on 25-jan-2002 bug# 2175580
4357: THEN l_attr_list.p_REGS := 'Y';
4358: END IF;
4359:
4360: -- added by soagrawa on 25-jan-2002 bug# 2175580
4361: IF AMS_CpyUtility_PVT.is_copy_attribute ('CONTENT', p_attributes_table) = FND_API.G_TRUE
4362: THEN l_attr_list.p_CONTENT := 'Y';
4363: END IF;
4364:
4365: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for both LITE schedules only.
4362: THEN l_attr_list.p_CONTENT := 'Y';
4363: END IF;
4364:
4365: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for both LITE schedules only.
4366: IF AMS_CpyUtility_PVT.is_copy_attribute ('TGRP', p_attributes_table) = FND_API.G_TRUE
4367: THEN l_attr_list.p_TGRP := 'Y';
4368: END IF;
4369:
4370: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for both LITE and CLASSIC schedules
4369:
4370: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for both LITE and CLASSIC schedules
4371: -- For Classic schedules, copy of COLT will always to true - to be in sync with 11.5.9 cover letter copy
4372: IF l_schedule_rec.usage = 'LITE' then
4373: IF AMS_CpyUtility_PVT.is_copy_attribute ('COLT', p_attributes_table) = FND_API.G_TRUE
4374: THEN
4375: l_attr_list.p_COLT := 'Y';
4376: -- Debug Message
4377: IF (AMS_DEBUG_HIGH_ON) THEN
4390: AMS_UTILITY_PVT.debug_message('Copy Attributes, usage is PHAT thus setting copy COLT to true' );
4391: END IF;
4392: END IF;
4393:
4394: IF AMS_CpyUtility_PVT.is_copy_attribute ('COLT', p_attributes_table) = FND_API.G_TRUE
4395: THEN l_attr_list.p_COLT := 'Y';
4396: END IF;
4397:
4398: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for LITE schedules.'OFFERING' does not exist for Classic schedules
4395: THEN l_attr_list.p_COLT := 'Y';
4396: END IF;
4397:
4398: -- added by sodixit on 04-oct-2003 for 11.5.10. Applicable for LITE schedules.'OFFERING' does not exist for Classic schedules
4399: IF AMS_CpyUtility_PVT.is_copy_attribute ('OFFERING', p_attributes_table) = FND_API.G_TRUE
4400: THEN l_attr_list.p_PROD := 'Y';
4401: END IF;
4402:
4403: -- added by spragupa on 23-nov-2007 for ER 6467510 - For extending COPY functionality for TASKS
4400: THEN l_attr_list.p_PROD := 'Y';
4401: END IF;
4402:
4403: -- added by spragupa on 23-nov-2007 for ER 6467510 - For extending COPY functionality for TASKS
4404: IF AMS_CpyUtility_PVT.is_copy_attribute ('TASK', p_attributes_table) = FND_API.G_TRUE
4405: THEN l_attr_list.p_TASK := 'Y';
4406: END IF;
4407:
4408: Ams_CopyActivities_PVT.copy_schedule_attributes (
4406: END IF;
4407:
4408: Ams_CopyActivities_PVT.copy_schedule_attributes (
4409: p_api_version => 1.0,
4410: p_init_msg_list => FND_API.G_FALSE,
4411: p_commit => FND_API.G_FALSE,
4412: x_return_status => x_return_status,
4413: x_msg_count => x_msg_count,
4414: x_msg_data => x_msg_data,
4407:
4408: Ams_CopyActivities_PVT.copy_schedule_attributes (
4409: p_api_version => 1.0,
4410: p_init_msg_list => FND_API.G_FALSE,
4411: p_commit => FND_API.G_FALSE,
4412: x_return_status => x_return_status,
4413: x_msg_count => x_msg_count,
4414: x_msg_data => x_msg_data,
4415: p_object_type => 'CSCH',
4418: p_attr_list => l_attr_list
4419: );
4420:
4421:
4422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4423: RAISE FND_API.G_EXC_ERROR;
4424: END IF;
4425:
4426:
4419: );
4420:
4421:
4422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4423: RAISE FND_API.G_EXC_ERROR;
4424: END IF;
4425:
4426:
4427: OPEN fetch_sch_details(l_new_schedule_id);
4431: x_new_object_id := l_new_schedule_id;
4432: x_custom_setup_id := l_new_reference_rec.custom_setup_id;
4433:
4434:
4435: IF FND_API.to_Boolean( p_commit )
4436: THEN
4437: COMMIT WORK;
4438: END IF;
4439:
4450: );
4451:
4452:
4453: EXCEPTION
4454: WHEN FND_API.G_EXC_ERROR THEN
4455: ROLLBACK TO COPY_Camp_Schedule_PVT;
4456: x_return_status := FND_API.G_RET_STS_ERROR;
4457: -- Standard call to get message count and if count=1, get the message
4458: FND_MSG_PUB.Count_And_Get (
4452:
4453: EXCEPTION
4454: WHEN FND_API.G_EXC_ERROR THEN
4455: ROLLBACK TO COPY_Camp_Schedule_PVT;
4456: x_return_status := FND_API.G_RET_STS_ERROR;
4457: -- Standard call to get message count and if count=1, get the message
4458: FND_MSG_PUB.Count_And_Get (
4459: p_encoded => FND_API.G_FALSE,
4460: p_count => x_msg_count,
4455: ROLLBACK TO COPY_Camp_Schedule_PVT;
4456: x_return_status := FND_API.G_RET_STS_ERROR;
4457: -- Standard call to get message count and if count=1, get the message
4458: FND_MSG_PUB.Count_And_Get (
4459: p_encoded => FND_API.G_FALSE,
4460: p_count => x_msg_count,
4461: p_data => x_msg_data
4462: );
4463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4459: p_encoded => FND_API.G_FALSE,
4460: p_count => x_msg_count,
4461: p_data => x_msg_data
4462: );
4463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4464: ROLLBACK TO COPY_Camp_Schedule_PVT;
4465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4466: -- Standard call to get message count and if count=1, get the message
4467: FND_MSG_PUB.Count_And_Get (
4461: p_data => x_msg_data
4462: );
4463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4464: ROLLBACK TO COPY_Camp_Schedule_PVT;
4465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4466: -- Standard call to get message count and if count=1, get the message
4467: FND_MSG_PUB.Count_And_Get (
4468: p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,
4464: ROLLBACK TO COPY_Camp_Schedule_PVT;
4465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4466: -- Standard call to get message count and if count=1, get the message
4467: FND_MSG_PUB.Count_And_Get (
4468: p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,
4470: p_data => x_msg_data
4471: );
4472: WHEN OTHERS THEN
4470: p_data => x_msg_data
4471: );
4472: WHEN OTHERS THEN
4473: ROLLBACK TO COPY_Camp_Schedule_PVT;
4474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4475: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4477: END IF;
4478: -- Standard call to get message count and if count=1, get the message
4476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4477: END IF;
4478: -- Standard call to get message count and if count=1, get the message
4479: FND_MSG_PUB.Count_And_Get (
4480: p_encoded => FND_API.G_FALSE,
4481: p_count => x_msg_count,
4482: p_data => x_msg_data
4483: );
4484: