eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_COPYACTIVITIES_PVT dependencies on FND_API

Line 61: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

57: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
58:
59: PROCEDURE copy_event_header(
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: x_eveh_id OUT NOCOPY NUMBER,

Line 96: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

92: END;
93:
94: PROCEDURE copy_event_offer(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: x_eveo_id OUT NOCOPY NUMBER,

Line 131: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

127: AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);
128: END;
129: PROCEDURE copy_deliverables(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: x_deliverable_id OUT NOCOPY NUMBER,

Line 163: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

159: END;
160:
161: PROCEDURE copy_campaign(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: x_campaign_id OUT NOCOPY NUMBER,

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

206: -- 13-aug-2002 soagrawa Fixed bug# 2511347
207: ---------------------------------------------------------------------
208: PROCEDURE copy_campaign_new(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213:
214: x_return_status OUT NOCOPY VARCHAR2,

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

207: ---------------------------------------------------------------------
208: PROCEDURE copy_campaign_new(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213:
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,

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

208: PROCEDURE copy_campaign_new(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213:
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,

Line 231: l_org_id NUMBER := FND_API.G_MISS_NUM;

227: l_api_name CONSTANT VARCHAR2(30) := 'copy_campaign_new';
228: l_api_version_number CONSTANT NUMBER := 1.0;
229: l_return_status_full VARCHAR2(1);
230: l_object_version_number NUMBER := 1;
231: l_org_id NUMBER := FND_API.G_MISS_NUM;
232: l_campaign_id NUMBER;
233: l_new_campaign_id NUMBER;
234: l_dummy NUMBER;
235:

Line 276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

272: -- Standard Start of API savepoint
273: SAVEPOINT COPY_Camp_Common_PVT;
274:
275: -- Standard call to check for call compatibility.
276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
277: p_api_version,
278: l_api_name,
279: G_PKG_NAME)
280: THEN

Line 281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

277: p_api_version,
278: l_api_name,
279: G_PKG_NAME)
280: THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: END IF;
283:
284: -- Initialize message list if p_init_msg_list is set to TRUE.
285: IF FND_API.to_Boolean( p_init_msg_list )

Line 285: IF FND_API.to_Boolean( p_init_msg_list )

281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: END IF;
283:
284: -- Initialize message list if p_init_msg_list is set to TRUE.
285: IF FND_API.to_Boolean( p_init_msg_list )
286: THEN
287: FND_MSG_PUB.initialize;
288: END IF;
289:

Line 300: x_return_status := FND_API.G_RET_STS_SUCCESS;

296: -- Writing to PL/SQL table
297: --WRITE_TO_ACT_LOG('start new copy function','CAMP',1111);
298:
299: -- Initialize API return status to SUCCESS
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301:
302: --
303: -- Start of API body
304: --

Line 403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

399: l_date_number := ams_cpyutility_pvt.get_dates('CAMP',
400: p_source_object_id,
401: l_return_status);
402:
403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
404: RAISE FND_API.G_EXC_ERROR ;
405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
407: END IF;

Line 404: RAISE FND_API.G_EXC_ERROR ;

400: p_source_object_id,
401: l_return_status);
402:
403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
404: RAISE FND_API.G_EXC_ERROR ;
405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
407: END IF;
408:

Line 405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

401: l_return_status);
402:
403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
404: RAISE FND_API.G_EXC_ERROR ;
405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
407: END IF;
408:
409: -- Following code is added by ptendulk on 18Aug2001

Line 406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

402:
403: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
404: RAISE FND_API.G_EXC_ERROR ;
405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
407: END IF;
408:
409: -- Following code is added by ptendulk on 18Aug2001
410: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_camp_rec.campaign_name);

Line 502: FND_API.G_FALSE,

498: ams_campaign_pub.create_campaign( p_api_version,
499: p_init_msg_list,
500: -- Bug fix: 2081684
501: -- p_commit,
502: FND_API.G_FALSE,
503: -- End Bug fix: 2081684
504: p_validation_level,
505: x_return_status,
506: x_msg_count,

Line 513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

509: l_new_campaign_id );
510:
511: --WRITE_TO_ACT_LOG('new campaign created successfully','CAMP',1111);
512:
513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516:
517: -- Attributes:

Line 514: RAISE FND_API.G_EXC_ERROR;

510:
511: --WRITE_TO_ACT_LOG('new campaign created successfully','CAMP',1111);
512:
513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516:
517: -- Attributes:
518: -- Access???

Line 532: IF AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table) = FND_API.G_TRUE

528: -- Subcamp
529:
530: --WRITE_TO_ACT_LOG('Copy Sched Attrib'|| AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table), 'CAMP',1111);
531:
532: IF AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table) = FND_API.G_TRUE
533: THEN
534: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CSCH') = FND_API.G_TRUE -- Bug fix: 2081684
535: THEN
536: --Following code is modified by rrajesh on 08/31/01.

Line 534: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CSCH') = FND_API.G_TRUE -- Bug fix: 2081684

530: --WRITE_TO_ACT_LOG('Copy Sched Attrib'|| AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table), 'CAMP',1111);
531:
532: IF AMS_CpyUtility_PVT.is_copy_attribute ('CSCH', p_attributes_table) = FND_API.G_TRUE
533: THEN
534: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CSCH') = FND_API.G_TRUE -- Bug fix: 2081684
535: THEN
536: --Following code is modified by rrajesh on 08/31/01.
537: --To copy selected schedules
538: /*ams_copyelements_pvt.copy_act_schedules

Line 625: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE

621: END IF; -- Bug fix: 2081684
622:
623: END IF;
624: --WRITE_TO_ACT_LOG('schedules copied succesfully','CAMP',1111);
625: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
626: THEN
627: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'MESG') = FND_API.G_TRUE -- Bug fix: 2081684
628: THEN
629: ams_copyelements_pvt.copy_act_messages

Line 627: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'MESG') = FND_API.G_TRUE -- Bug fix: 2081684

623: END IF;
624: --WRITE_TO_ACT_LOG('schedules copied succesfully','CAMP',1111);
625: IF AMS_CpyUtility_PVT.is_copy_attribute ('MESG', p_attributes_table) = FND_API.G_TRUE
626: THEN
627: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'MESG') = FND_API.G_TRUE -- Bug fix: 2081684
628: THEN
629: ams_copyelements_pvt.copy_act_messages
630: ( p_src_act_type =>'CAMP',
631: p_src_act_id =>p_source_object_id,

Line 638: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE

634: p_errcode =>l_errcode,
635: p_errmsg =>l_errmsg);
636: END IF;
637: END IF;
638: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
639: THEN
640: -- modified by soagrawa on 31-jan-2002 bug# 2207969
641: IF ams_cpyutility_pvt.check_attrib_exists('AMS_CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
642: -- IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684

Line 641: IF ams_cpyutility_pvt.check_attrib_exists('AMS_CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684

637: END IF;
638: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
639: THEN
640: -- modified by soagrawa on 31-jan-2002 bug# 2207969
641: IF ams_cpyutility_pvt.check_attrib_exists('AMS_CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
642: -- IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
643: THEN
644: -- Modified by rrajesh on 10/18/01
645: /*ams_copyelements_pvt.copy_act_attachments

Line 642: -- IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684

638: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE
639: THEN
640: -- modified by soagrawa on 31-jan-2002 bug# 2207969
641: IF ams_cpyutility_pvt.check_attrib_exists('AMS_CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
642: -- IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'ATCH') = FND_API.G_TRUE -- Bug fix: 2081684
643: THEN
644: -- Modified by rrajesh on 10/18/01
645: /*ams_copyelements_pvt.copy_act_attachments
646: ( p_src_act_type =>'CAMP',

Line 663: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOS', p_attributes_table) = FND_API.G_TRUE

659: -- end change 10/18/01
660: END IF;
661: END IF;
662: -- Added by rrajesh on 10/18/01
663: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOS', p_attributes_table) = FND_API.G_TRUE
664: THEN
665: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'GEOS') = FND_API.G_TRUE -- Bug fix: 2081684
666: THEN
667: ams_copyelements_pvt.copy_act_geo_areas

Line 665: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'GEOS') = FND_API.G_TRUE -- Bug fix: 2081684

661: END IF;
662: -- Added by rrajesh on 10/18/01
663: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOS', p_attributes_table) = FND_API.G_TRUE
664: THEN
665: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'GEOS') = FND_API.G_TRUE -- Bug fix: 2081684
666: THEN
667: ams_copyelements_pvt.copy_act_geo_areas
668: ( p_src_act_type => 'CAMP',
669: p_src_act_id => p_source_object_id,

Line 676: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE

672: p_errcode => l_errcode,
673: p_errmsg => l_errmsg);
674: END IF;
675: END IF;
676: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
677: THEN
678: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'DELV') = FND_API.G_TRUE -- Bug fix: 2081684
679: THEN
680: ams_copyelements_pvt.copy_object_associations

Line 678: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'DELV') = FND_API.G_TRUE -- Bug fix: 2081684

674: END IF;
675: END IF;
676: IF AMS_CpyUtility_PVT.is_copy_attribute ('DELV', p_attributes_table) = FND_API.G_TRUE
677: THEN
678: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'DELV') = FND_API.G_TRUE -- Bug fix: 2081684
679: THEN
680: ams_copyelements_pvt.copy_object_associations
681: ( p_src_act_type => 'CAMP',
682: p_src_act_id =>p_source_object_id,

Line 691: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE

687: END IF;
688: END IF;
689:
690: -- end change 10/18/01
691: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
692: THEN
693: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PROD') = FND_API.G_TRUE -- Bug fix: 2081684
694: THEN
695: ams_copyelements_pvt.copy_act_prod

Line 693: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PROD') = FND_API.G_TRUE -- Bug fix: 2081684

689:
690: -- end change 10/18/01
691: IF AMS_CpyUtility_PVT.is_copy_attribute ('PROD', p_attributes_table) = FND_API.G_TRUE
692: THEN
693: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PROD') = FND_API.G_TRUE -- Bug fix: 2081684
694: THEN
695: ams_copyelements_pvt.copy_act_prod
696: ( p_src_act_type => 'CAMP',
697: p_src_act_id =>p_source_object_id,

Line 704: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE

700: p_errcode => l_errcode,
701: p_errmsg => l_errmsg);
702: END IF;
703: END IF;
704: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
705: THEN
706: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CELL') = FND_API.G_TRUE -- Bug fix: 2081684
707: THEN
708: ams_copyelements_pvt.copy_act_market_segments

Line 706: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CELL') = FND_API.G_TRUE -- Bug fix: 2081684

702: END IF;
703: END IF;
704: IF AMS_CpyUtility_PVT.is_copy_attribute ('CELL', p_attributes_table) = FND_API.G_TRUE
705: THEN
706: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'CELL') = FND_API.G_TRUE -- Bug fix: 2081684
707: THEN
708: ams_copyelements_pvt.copy_act_market_segments
709: ( p_src_act_type =>'CAMP',
710: p_src_act_id =>p_source_object_id,

Line 717: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE

713: p_errcode =>l_errcode,
714: p_errmsg =>l_errmsg);
715: END IF;
716: END IF;
717: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
718: THEN
719: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PTNR') = FND_API.G_TRUE -- Bug fix: 2081684
720: THEN
721: -- Bug fix:2072789

Line 719: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PTNR') = FND_API.G_TRUE -- Bug fix: 2081684

715: END IF;
716: END IF;
717: IF AMS_CpyUtility_PVT.is_copy_attribute ('PTNR', p_attributes_table) = FND_API.G_TRUE
718: THEN
719: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PTNR') = FND_API.G_TRUE -- Bug fix: 2081684
720: THEN
721: -- Bug fix:2072789
722: /*ams_copyelements_pvt.copy_partners
723: (p_init_msg_list => fnd_api.g_true,

Line 723: (p_init_msg_list => fnd_api.g_true,

719: IF ams_cpyutility_pvt.check_attrib_exists('CAMP', p_source_object_id ,'PTNR') = FND_API.G_TRUE -- Bug fix: 2081684
720: THEN
721: -- Bug fix:2072789
722: /*ams_copyelements_pvt.copy_partners
723: (p_init_msg_list => fnd_api.g_true,
724: p_api_version => l_api_version_number,
725: x_return_status => l_return_status,
726: x_msg_count => l_msg_count,
727: x_msg_data => l_msg_data,

Line 732: p_init_msg_list => fnd_api.g_true,

728: p_old_camp_id =>p_source_object_id,
729: p_new_camp_id =>l_new_campaign_id); */
730: ams_copyelements_pvt.copy_partners
731: (p_api_version => l_api_version_number,
732: p_init_msg_list => fnd_api.g_true,
733: x_return_status => l_return_status,
734: x_msg_count => l_msg_count,
735: x_msg_data => l_msg_data,
736: p_old_camp_id =>p_source_object_id,

Line 750: IF FND_API.to_Boolean( p_commit )

746: x_new_object_id := l_new_campaign_id;
747: x_custom_setup_id := l_new_reference_rec.custom_setup_id;
748:
749:
750: IF FND_API.to_Boolean( p_commit )
751: THEN
752: COMMIT WORK;
753: END IF;
754:

Line 768: WHEN FND_API.G_EXC_ERROR THEN

764: p_data => x_msg_data
765: );
766: --WRITE_TO_ACT_LOG('All attributes copied succesfully','CAMP',1111);
767: EXCEPTION
768: WHEN FND_API.G_EXC_ERROR THEN
769: ROLLBACK TO COPY_Camp_Common_PVT;
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: -- Standard call to get message count and if count=1, get the message
772: FND_MSG_PUB.Count_And_Get (

Line 770: x_return_status := FND_API.G_RET_STS_ERROR;

766: --WRITE_TO_ACT_LOG('All attributes copied succesfully','CAMP',1111);
767: EXCEPTION
768: WHEN FND_API.G_EXC_ERROR THEN
769: ROLLBACK TO COPY_Camp_Common_PVT;
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: -- Standard call to get message count and if count=1, get the message
772: FND_MSG_PUB.Count_And_Get (
773: p_encoded => FND_API.G_FALSE,
774: p_count => x_msg_count,

Line 773: p_encoded => FND_API.G_FALSE,

769: ROLLBACK TO COPY_Camp_Common_PVT;
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: -- Standard call to get message count and if count=1, get the message
772: FND_MSG_PUB.Count_And_Get (
773: p_encoded => FND_API.G_FALSE,
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

773: p_encoded => FND_API.G_FALSE,
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO COPY_Camp_Common_PVT;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (

Line 779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

775: p_data => x_msg_data
776: );
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO COPY_Camp_Common_PVT;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_msg_count,

Line 782: p_encoded => FND_API.G_FALSE,

778: ROLLBACK TO COPY_Camp_Common_PVT;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_msg_count,
784: p_data => x_msg_data
785: );
786: WHEN OTHERS THEN

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

784: p_data => x_msg_data
785: );
786: WHEN OTHERS THEN
787: ROLLBACK TO COPY_Camp_Common_PVT;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
791: END IF;
792: -- Standard call to get message count and if count=1, get the message

Line 794: p_encoded => FND_API.G_FALSE,

790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
791: END IF;
792: -- Standard call to get message count and if count=1, get the message
793: FND_MSG_PUB.Count_And_Get (
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798:

Line 803: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

799: END;
800: -----------------------------------------------------------------------
801: PROCEDURE copy_deliverables(
802: p_api_version IN NUMBER,
803: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
804: x_return_status OUT NOCOPY VARCHAR2,
805: x_msg_count OUT NOCOPY NUMBER,
806: x_msg_data OUT NOCOPY VARCHAR2,
807: x_deliverable_id OUT NOCOPY NUMBER,

Line 847: IF fnd_api.to_boolean(p_init_msg_list)

843:
844: ams_utility_pvt.debug_message(l_full_name || ': start');
845: END IF;
846:
847: IF fnd_api.to_boolean(p_init_msg_list)
848: THEN
849: fnd_msg_pub.initialize;
850: END IF;
851:

Line 852: IF NOT fnd_api.compatible_api_call(

848: THEN
849: fnd_msg_pub.initialize;
850: END IF;
851:
852: IF NOT fnd_api.compatible_api_call(
853: l_api_version,
854: p_api_version,
855: l_api_name,
856: g_pkg_name)

Line 858: RAISE fnd_api.g_exc_unexpected_error;

854: p_api_version,
855: l_api_name,
856: g_pkg_name)
857: THEN
858: RAISE fnd_api.g_exc_unexpected_error;
859: END IF;
860:
861: x_return_status := fnd_api.g_ret_sts_success;
862: ----------------------- insert -----------------------

Line 861: x_return_status := fnd_api.g_ret_sts_success;

857: THEN
858: RAISE fnd_api.g_exc_unexpected_error;
859: END IF;
860:
861: x_return_status := fnd_api.g_ret_sts_success;
862: ----------------------- insert -----------------------
863: IF (AMS_DEBUG_HIGH_ON) THEN
864:
865: ams_utility_pvt.debug_message(l_full_name || ': copy');

Line 983: IF l_return_status = fnd_api.g_ret_sts_error

979: x_deliv_id => l_new_deliv_id,
980: p_deliv_rec => l_deli_rec);
981: x_deliverable_id := l_new_deliv_id;
982:
983: IF l_return_status = fnd_api.g_ret_sts_error
984: OR l_return_status = fnd_api.g_ret_sts_unexp_error
985: THEN
986: FOR l_counter IN 1 .. l_msg_count
987: LOOP

Line 984: OR l_return_status = fnd_api.g_ret_sts_unexp_error

980: p_deliv_rec => l_deli_rec);
981: x_deliverable_id := l_new_deliv_id;
982:
983: IF l_return_status = fnd_api.g_ret_sts_error
984: OR l_return_status = fnd_api.g_ret_sts_unexp_error
985: THEN
986: FOR l_counter IN 1 .. l_msg_count
987: LOOP
988: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

Line 988: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

984: OR l_return_status = fnd_api.g_ret_sts_unexp_error
985: THEN
986: FOR l_counter IN 1 .. l_msg_count
987: LOOP
988: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
989: p_errmsg := SUBSTR( l_mesg_text || ',): ' || l_counter ||
990: ' OF ' || l_msg_count, 1, 3000);
991: ams_cpyutility_pvt.write_log_mesg( 'DELV',
992: p_src_deliv_id,

Line 1005: IF l_return_status = fnd_api.g_ret_sts_error then

1001: l_deli_rec.deliverable_id),
1002: 1, 4000);
1003: ams_cpyutility_pvt.write_log_mesg('DELV',
1004: p_src_deliv_id, p_errmsg, 'ERROR');
1005: IF l_return_status = fnd_api.g_ret_sts_error then
1006: RAISE fnd_api.g_exc_error;
1007: ELSE
1008: RAISE fnd_api.g_exc_unexpected_error;
1009: END IF;

Line 1006: RAISE fnd_api.g_exc_error;

1002: 1, 4000);
1003: ams_cpyutility_pvt.write_log_mesg('DELV',
1004: p_src_deliv_id, p_errmsg, 'ERROR');
1005: IF l_return_status = fnd_api.g_ret_sts_error then
1006: RAISE fnd_api.g_exc_error;
1007: ELSE
1008: RAISE fnd_api.g_exc_unexpected_error;
1009: END IF;
1010: END IF;

Line 1008: RAISE fnd_api.g_exc_unexpected_error;

1004: p_src_deliv_id, p_errmsg, 'ERROR');
1005: IF l_return_status = fnd_api.g_ret_sts_error then
1006: RAISE fnd_api.g_exc_error;
1007: ELSE
1008: RAISE fnd_api.g_exc_unexpected_error;
1009: END IF;
1010: END IF;
1011: END;
1012:

Line 1013: IF x_return_status = fnd_api.g_ret_sts_success

1009: END IF;
1010: END IF;
1011: END;
1012:
1013: IF x_return_status = fnd_api.g_ret_sts_success
1014: THEN
1015: IF p_deli_elements_rec.p_attachments = 'Y'
1016: THEN
1017: l_errcode := NULL;

Line 1103: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1099: p_errmsg => l_errmsg);
1100: END IF;
1101: END IF;
1102:
1103: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1104: COMMIT ;
1105: END IF ;
1106:
1107: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1115: WHEN fnd_api.g_exc_error

1111: ams_utility_pvt.debug_message(l_full_name || ': end');
1112:
1113: END IF;
1114: EXCEPTION
1115: WHEN fnd_api.g_exc_error
1116: THEN
1117: ROLLBACK TO copy_deliverables;
1118: x_return_status := fnd_api.g_ret_sts_error;
1119: fnd_msg_pub.count_and_get(

Line 1118: x_return_status := fnd_api.g_ret_sts_error;

1114: EXCEPTION
1115: WHEN fnd_api.g_exc_error
1116: THEN
1117: ROLLBACK TO copy_deliverables;
1118: x_return_status := fnd_api.g_ret_sts_error;
1119: fnd_msg_pub.count_and_get(
1120: p_encoded => fnd_api.g_false,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data);

Line 1120: p_encoded => fnd_api.g_false,

1116: THEN
1117: ROLLBACK TO copy_deliverables;
1118: x_return_status := fnd_api.g_ret_sts_error;
1119: fnd_msg_pub.count_and_get(
1120: p_encoded => fnd_api.g_false,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data);
1123: WHEN fnd_api.g_exc_unexpected_error
1124: THEN

Line 1123: WHEN fnd_api.g_exc_unexpected_error

1119: fnd_msg_pub.count_and_get(
1120: p_encoded => fnd_api.g_false,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data);
1123: WHEN fnd_api.g_exc_unexpected_error
1124: THEN
1125: ROLLBACK TO copy_deliverables;
1126: x_return_status := fnd_api.g_ret_sts_unexp_error;
1127: fnd_msg_pub.count_and_get(

Line 1126: x_return_status := fnd_api.g_ret_sts_unexp_error;

1122: p_data => x_msg_data);
1123: WHEN fnd_api.g_exc_unexpected_error
1124: THEN
1125: ROLLBACK TO copy_deliverables;
1126: x_return_status := fnd_api.g_ret_sts_unexp_error;
1127: fnd_msg_pub.count_and_get(
1128: p_encoded => fnd_api.g_false,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data);

Line 1128: p_encoded => fnd_api.g_false,

1124: THEN
1125: ROLLBACK TO copy_deliverables;
1126: x_return_status := fnd_api.g_ret_sts_unexp_error;
1127: fnd_msg_pub.count_and_get(
1128: p_encoded => fnd_api.g_false,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data);
1131: WHEN OTHERS
1132: THEN

Line 1134: x_return_status := fnd_api.g_ret_sts_unexp_error;

1130: p_data => x_msg_data);
1131: WHEN OTHERS
1132: THEN
1133: ROLLBACK TO copy_deliverables;
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135:
1136: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1137: THEN
1138: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1142: p_encoded => fnd_api.g_false,

1138: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1139: END IF;
1140:
1141: fnd_msg_pub.count_and_get(
1142: p_encoded => fnd_api.g_false,
1143: p_count => x_msg_count,
1144: p_data => x_msg_data);
1145: END copy_deliverables;
1146:

Line 1151: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1147:
1148:
1149: PROCEDURE copy_event_offer(
1150: p_api_version IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1152: x_return_status OUT NOCOPY VARCHAR2,
1153: x_msg_count OUT NOCOPY NUMBER,
1154: x_msg_data OUT NOCOPY VARCHAR2,
1155: x_eveo_id OUT NOCOPY NUMBER,

Line 1220: IF fnd_api.to_boolean(p_init_msg_list)

1216:
1217: ams_utility_pvt.debug_message(l_full_name || ': start');
1218: END IF;
1219:
1220: IF fnd_api.to_boolean(p_init_msg_list)
1221: THEN
1222: fnd_msg_pub.initialize;
1223: END IF;
1224:

Line 1225: IF NOT fnd_api.compatible_api_call(

1221: THEN
1222: fnd_msg_pub.initialize;
1223: END IF;
1224:
1225: IF NOT fnd_api.compatible_api_call(
1226: l_api_version,
1227: p_api_version,
1228: l_api_name,
1229: g_pkg_name)

Line 1231: RAISE fnd_api.g_exc_unexpected_error;

1227: p_api_version,
1228: l_api_name,
1229: g_pkg_name)
1230: THEN
1231: RAISE fnd_api.g_exc_unexpected_error;
1232: END IF;
1233:
1234: x_return_status := fnd_api.g_ret_sts_success;
1235: ----------------------- insert -----------------------

Line 1234: x_return_status := fnd_api.g_ret_sts_success;

1230: THEN
1231: RAISE fnd_api.g_exc_unexpected_error;
1232: END IF;
1233:
1234: x_return_status := fnd_api.g_ret_sts_success;
1235: ----------------------- insert -----------------------
1236: IF (AMS_DEBUG_HIGH_ON) THEN
1237:
1238: ams_utility_pvt.debug_message(l_full_name || ': start');

Line 1424: p_init_msg_list => fnd_api.g_true,

1420: END IF;*/
1421:
1422: ams_eventoffer_pvt.create_event_offer(
1423: p_api_version => l_api_version,
1424: p_init_msg_list => fnd_api.g_true,
1425: p_commit => FND_API.g_true,
1426: x_return_status => l_return_status,
1427: x_msg_count => l_msg_count,
1428: x_msg_data => l_msg_data,

Line 1425: p_commit => FND_API.g_true,

1421:
1422: ams_eventoffer_pvt.create_event_offer(
1423: p_api_version => l_api_version,
1424: p_init_msg_list => fnd_api.g_true,
1425: p_commit => FND_API.g_true,
1426: x_return_status => l_return_status,
1427: x_msg_count => l_msg_count,
1428: x_msg_data => l_msg_data,
1429: x_evo_id => x_eveo_id,

Line 1432: IF l_return_status = fnd_api.g_ret_sts_error

1428: x_msg_data => l_msg_data,
1429: x_evo_id => x_eveo_id,
1430: p_evo_rec => l_eveo_rec);
1431:
1432: IF l_return_status = fnd_api.g_ret_sts_error
1433: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1434: THEN
1435: FOR l_counter IN 1 .. l_msg_count LOOP
1436: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

Line 1433: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1429: x_evo_id => x_eveo_id,
1430: p_evo_rec => l_eveo_rec);
1431:
1432: IF l_return_status = fnd_api.g_ret_sts_error
1433: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1434: THEN
1435: FOR l_counter IN 1 .. l_msg_count LOOP
1436: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1437: p_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter || ' OF ' ||

Line 1436: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1432: IF l_return_status = fnd_api.g_ret_sts_error
1433: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1434: THEN
1435: FOR l_counter IN 1 .. l_msg_count LOOP
1436: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1437: p_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter || ' OF ' ||
1438: l_msg_count, 1, 3000);
1439: ams_cpyutility_pvt.write_log_mesg( 'EVEO',
1440: p_src_eveo_id,

Line 1456: IF l_return_status = fnd_api.g_ret_sts_error then

1452: p_src_eveo_id,
1453: p_errmsg,
1454: 'ERROR');
1455: -- Is failed write a copy failed message in the log table
1456: IF l_return_status = fnd_api.g_ret_sts_error then
1457: RAISE fnd_api.g_exc_error;
1458: ELSE
1459: RAISE fnd_api.g_exc_unexpected_error;
1460: END IF;

Line 1457: RAISE fnd_api.g_exc_error;

1453: p_errmsg,
1454: 'ERROR');
1455: -- Is failed write a copy failed message in the log table
1456: IF l_return_status = fnd_api.g_ret_sts_error then
1457: RAISE fnd_api.g_exc_error;
1458: ELSE
1459: RAISE fnd_api.g_exc_unexpected_error;
1460: END IF;
1461: END IF;

Line 1459: RAISE fnd_api.g_exc_unexpected_error;

1455: -- Is failed write a copy failed message in the log table
1456: IF l_return_status = fnd_api.g_ret_sts_error then
1457: RAISE fnd_api.g_exc_error;
1458: ELSE
1459: RAISE fnd_api.g_exc_unexpected_error;
1460: END IF;
1461: END IF;
1462: END;
1463: -- If the user wants to copy objectives then the objectives

Line 1465: IF x_return_status = fnd_api.g_ret_sts_success

1461: END IF;
1462: END;
1463: -- If the user wants to copy objectives then the objectives
1464: -- flag should be 'Y' (Yes)
1465: IF x_return_status = fnd_api.g_ret_sts_success
1466: THEN
1467: IF p_eveo_elements_rec.p_messages = 'Y'
1468: THEN
1469: l_errcode := NULL;

Line 1596: p_init_msg_list => fnd_api.g_true,

1592: l_msg_count := 0;
1593: l_msg_data := NULL;
1594: copy_event_offer(
1595: p_api_version => 1,
1596: p_init_msg_list => fnd_api.g_true,
1597: x_return_status => l_return_status,
1598: x_msg_data => l_msg_data,
1599: x_msg_count => l_msg_count,
1600: p_src_eveo_id => sub_eveo_rec.event_offer_id,

Line 1612: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1608: END LOOP;
1609: END IF;
1610: END IF;
1611:
1612: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1613: COMMIT ;
1614: END IF ;
1615:
1616: EXCEPTION

Line 1617: WHEN fnd_api.g_exc_error

1613: COMMIT ;
1614: END IF ;
1615:
1616: EXCEPTION
1617: WHEN fnd_api.g_exc_error
1618: THEN
1619: ROLLBACK TO copy_event_offer;
1620: x_return_status := fnd_api.g_ret_sts_error;
1621: fnd_msg_pub.count_and_get(

Line 1620: x_return_status := fnd_api.g_ret_sts_error;

1616: EXCEPTION
1617: WHEN fnd_api.g_exc_error
1618: THEN
1619: ROLLBACK TO copy_event_offer;
1620: x_return_status := fnd_api.g_ret_sts_error;
1621: fnd_msg_pub.count_and_get(
1622: p_encoded => fnd_api.g_false,
1623: p_count => x_msg_count,
1624: p_data => x_msg_data);

Line 1622: p_encoded => fnd_api.g_false,

1618: THEN
1619: ROLLBACK TO copy_event_offer;
1620: x_return_status := fnd_api.g_ret_sts_error;
1621: fnd_msg_pub.count_and_get(
1622: p_encoded => fnd_api.g_false,
1623: p_count => x_msg_count,
1624: p_data => x_msg_data);
1625: WHEN fnd_api.g_exc_unexpected_error
1626: THEN

Line 1625: WHEN fnd_api.g_exc_unexpected_error

1621: fnd_msg_pub.count_and_get(
1622: p_encoded => fnd_api.g_false,
1623: p_count => x_msg_count,
1624: p_data => x_msg_data);
1625: WHEN fnd_api.g_exc_unexpected_error
1626: THEN
1627: ROLLBACK TO copy_event_offer;
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1628: x_return_status := fnd_api.g_ret_sts_unexp_error;

1624: p_data => x_msg_data);
1625: WHEN fnd_api.g_exc_unexpected_error
1626: THEN
1627: ROLLBACK TO copy_event_offer;
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: IF (AMS_DEBUG_HIGH_ON) THEN
1630:
1631: ams_utility_pvt.debug_message(l_full_name || ': debug');
1632: END IF;

Line 1634: p_encoded => fnd_api.g_false,

1630:
1631: ams_utility_pvt.debug_message(l_full_name || ': debug');
1632: END IF;
1633: fnd_msg_pub.count_and_get(
1634: p_encoded => fnd_api.g_false,
1635: p_count => x_msg_count,
1636: p_data => x_msg_data);
1637: WHEN OTHERS
1638: THEN

Line 1640: x_return_status := fnd_api.g_ret_sts_unexp_error;

1636: p_data => x_msg_data);
1637: WHEN OTHERS
1638: THEN
1639: ROLLBACK TO copy_event_offer;
1640: x_return_status := fnd_api.g_ret_sts_unexp_error;
1641:
1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1643: THEN
1644: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1648: p_encoded => fnd_api.g_false,

1644: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1645: END IF;
1646:
1647: fnd_msg_pub.count_and_get(
1648: p_encoded => fnd_api.g_false,
1649: p_count => x_msg_count,
1650: p_data => x_msg_data);
1651: END copy_event_offer;
1652:

Line 1656: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1652:
1653:
1654: PROCEDURE copy_event_header(
1655: p_api_version IN NUMBER,
1656: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1657: x_return_status OUT NOCOPY VARCHAR2,
1658: x_msg_count OUT NOCOPY NUMBER,
1659: x_msg_data OUT NOCOPY VARCHAR2,
1660: x_eveh_id OUT NOCOPY NUMBER,

Line 1728: IF fnd_api.to_boolean(p_init_msg_list)

1724:
1725: ams_utility_pvt.debug_message(l_full_name || ': start');
1726: END IF;
1727:
1728: IF fnd_api.to_boolean(p_init_msg_list)
1729: THEN
1730: fnd_msg_pub.initialize;
1731: END IF;
1732:

Line 1733: IF NOT fnd_api.compatible_api_call(

1729: THEN
1730: fnd_msg_pub.initialize;
1731: END IF;
1732:
1733: IF NOT fnd_api.compatible_api_call(
1734: l_api_version,
1735: p_api_version,
1736: l_api_name,
1737: g_pkg_name)

Line 1739: RAISE fnd_api.g_exc_unexpected_error;

1735: p_api_version,
1736: l_api_name,
1737: g_pkg_name)
1738: THEN
1739: RAISE fnd_api.g_exc_unexpected_error;
1740: END IF;
1741:
1742: x_return_status := fnd_api.g_ret_sts_success;
1743: ----------------------- insert -----------------------

Line 1742: x_return_status := fnd_api.g_ret_sts_success;

1738: THEN
1739: RAISE fnd_api.g_exc_unexpected_error;
1740: END IF;
1741:
1742: x_return_status := fnd_api.g_ret_sts_success;
1743: ----------------------- insert -----------------------
1744: IF (AMS_DEBUG_HIGH_ON) THEN
1745:
1746: ams_utility_pvt.debug_message(l_full_name || ': start');

Line 1892: p_init_msg_list => fnd_api.g_true,

1888: END IF;*/
1889:
1890: ams_eventheader_pvt.create_event_header(
1891: p_api_version => l_api_version,
1892: p_init_msg_list => fnd_api.g_true,
1893: p_commit => FND_API.g_true,
1894: x_return_status => l_return_status,
1895: x_msg_count => l_msg_count,
1896: x_msg_data => l_msg_data,

Line 1893: p_commit => FND_API.g_true,

1889:
1890: ams_eventheader_pvt.create_event_header(
1891: p_api_version => l_api_version,
1892: p_init_msg_list => fnd_api.g_true,
1893: p_commit => FND_API.g_true,
1894: x_return_status => l_return_status,
1895: x_msg_count => l_msg_count,
1896: x_msg_data => l_msg_data,
1897: x_evh_id => x_eveh_id,

Line 1900: IF l_return_status = fnd_api.g_ret_sts_error

1896: x_msg_data => l_msg_data,
1897: x_evh_id => x_eveh_id,
1898: p_evh_rec => l_eveh_rec);
1899:
1900: IF l_return_status = fnd_api.g_ret_sts_error
1901: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1902: THEN
1903: FOR l_counter IN 1 .. l_msg_count LOOP
1904: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

Line 1901: OR l_return_status = fnd_api.g_ret_sts_unexp_error

1897: x_evh_id => x_eveh_id,
1898: p_evh_rec => l_eveh_rec);
1899:
1900: IF l_return_status = fnd_api.g_ret_sts_error
1901: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1902: THEN
1903: FOR l_counter IN 1 .. l_msg_count LOOP
1904: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1905: p_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter ||

Line 1904: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1900: IF l_return_status = fnd_api.g_ret_sts_error
1901: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1902: THEN
1903: FOR l_counter IN 1 .. l_msg_count LOOP
1904: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1905: p_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter ||
1906: ' OF ' || l_msg_count, 1, 3000);
1907: ams_cpyutility_pvt.write_log_mesg( 'EVEH',
1908: p_src_eveh_id,

Line 1923: IF l_return_status = fnd_api.g_ret_sts_error then

1919: p_src_eveh_id,
1920: p_errmsg,
1921: 'ERROR');
1922: -- Is failed write a copy failed message in the log table
1923: IF l_return_status = fnd_api.g_ret_sts_error then
1924: RAISE fnd_api.g_exc_error;
1925: ELSE
1926: RAISE fnd_api.g_exc_unexpected_error;
1927: END IF;

Line 1924: RAISE fnd_api.g_exc_error;

1920: p_errmsg,
1921: 'ERROR');
1922: -- Is failed write a copy failed message in the log table
1923: IF l_return_status = fnd_api.g_ret_sts_error then
1924: RAISE fnd_api.g_exc_error;
1925: ELSE
1926: RAISE fnd_api.g_exc_unexpected_error;
1927: END IF;
1928: END IF;

Line 1926: RAISE fnd_api.g_exc_unexpected_error;

1922: -- Is failed write a copy failed message in the log table
1923: IF l_return_status = fnd_api.g_ret_sts_error then
1924: RAISE fnd_api.g_exc_error;
1925: ELSE
1926: RAISE fnd_api.g_exc_unexpected_error;
1927: END IF;
1928: END IF;
1929: END;
1930: -- If the user wants to copy objectives then the

Line 1932: IF x_return_status = fnd_api.g_ret_sts_success

1928: END IF;
1929: END;
1930: -- If the user wants to copy objectives then the
1931: -- objectives flag should be 'Y' (Yes)
1932: IF x_return_status = fnd_api.g_ret_sts_success
1933: THEN
1934: IF p_eveh_elements_rec.p_messages = 'Y'
1935: THEN
1936: l_errcode := NULL;

Line 2063: p_init_msg_list => fnd_api.g_true,

2059: l_msg_count := 0;
2060: l_msg_data := NULL;
2061: copy_event_header(
2062: p_api_version => 1,
2063: p_init_msg_list => fnd_api.g_true,
2064: x_return_status => l_return_status,
2065: x_msg_data => l_msg_data,
2066: x_msg_count => l_msg_count,
2067: p_src_eveh_id => sub_eveh_rec.event_header_id,

Line 2088: p_init_msg_list => fnd_api.g_true,

2084: l_msg_data := NULL;
2085: copy_event_offer(
2086: p_api_version => 1,
2087: x_return_status => l_return_status,
2088: p_init_msg_list => fnd_api.g_true,
2089: x_msg_count => l_msg_data,
2090: x_msg_data => l_msg_count,
2091: x_eveo_id => x_eventoffer_id,
2092: p_src_eveo_id => sub_eveo_rec.event_offer_id,

Line 2100: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2096: END;
2097: END LOOP;
2098: END IF;
2099: END IF;
2100: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2101: COMMIT ;
2102: END IF ;
2103: EXCEPTION
2104: WHEN fnd_api.g_exc_error

Line 2104: WHEN fnd_api.g_exc_error

2100: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2101: COMMIT ;
2102: END IF ;
2103: EXCEPTION
2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO copy_event_header;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get(

Line 2107: x_return_status := fnd_api.g_ret_sts_error;

2103: EXCEPTION
2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO copy_event_header;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get(
2109: p_encoded => fnd_api.g_false,
2110: p_count => x_msg_count,
2111: p_data => x_msg_data);

Line 2109: p_encoded => fnd_api.g_false,

2105: THEN
2106: ROLLBACK TO copy_event_header;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get(
2109: p_encoded => fnd_api.g_false,
2110: p_count => x_msg_count,
2111: p_data => x_msg_data);
2112: WHEN fnd_api.g_exc_unexpected_error
2113: THEN

Line 2112: WHEN fnd_api.g_exc_unexpected_error

2108: fnd_msg_pub.count_and_get(
2109: p_encoded => fnd_api.g_false,
2110: p_count => x_msg_count,
2111: p_data => x_msg_data);
2112: WHEN fnd_api.g_exc_unexpected_error
2113: THEN
2114: ROLLBACK TO copy_event_header;
2115: x_return_status := fnd_api.g_ret_sts_unexp_error;
2116: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2115: x_return_status := fnd_api.g_ret_sts_unexp_error;

2111: p_data => x_msg_data);
2112: WHEN fnd_api.g_exc_unexpected_error
2113: THEN
2114: ROLLBACK TO copy_event_header;
2115: x_return_status := fnd_api.g_ret_sts_unexp_error;
2116: IF (AMS_DEBUG_HIGH_ON) THEN
2117:
2118: ams_utility_pvt.debug_message(l_full_name || ': debug');
2119: END IF;

Line 2121: p_encoded => fnd_api.g_false,

2117:
2118: ams_utility_pvt.debug_message(l_full_name || ': debug');
2119: END IF;
2120: fnd_msg_pub.count_and_get(
2121: p_encoded => fnd_api.g_false,
2122: p_count => x_msg_count,
2123: p_data => x_msg_data);
2124: WHEN OTHERS
2125: THEN

Line 2127: x_return_status := fnd_api.g_ret_sts_unexp_error;

2123: p_data => x_msg_data);
2124: WHEN OTHERS
2125: THEN
2126: ROLLBACK TO copy_event_header;
2127: x_return_status := fnd_api.g_ret_sts_unexp_error;
2128:
2129: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2130: THEN
2131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 2135: p_encoded => fnd_api.g_false,

2131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2132: END IF;
2133:
2134: fnd_msg_pub.count_and_get(
2135: p_encoded => fnd_api.g_false,
2136: p_count => x_msg_count,
2137: p_data => x_msg_data);
2138: END copy_event_header;
2139:

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

2138: END copy_event_header;
2139:
2140: PROCEDURE Copy_Campaign (
2141: p_api_version IN NUMBER,
2142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2143: -- Not being added since it involves changes in signature and class
2144: -- generated by rosseta To be implemented at later stage
2145: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
2146: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 2145: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,

2141: p_api_version IN NUMBER,
2142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2143: -- Not being added since it involves changes in signature and class
2144: -- generated by rosseta To be implemented at later stage
2145: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
2146: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2147: x_return_status OUT NOCOPY VARCHAR2,
2148: x_msg_count OUT NOCOPY NUMBER,
2149: x_msg_data OUT NOCOPY VARCHAR2,

Line 2146: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2143: -- Not being added since it involves changes in signature and class
2144: -- generated by rosseta To be implemented at later stage
2145: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
2146: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2147: x_return_status OUT NOCOPY VARCHAR2,
2148: x_msg_count OUT NOCOPY NUMBER,
2149: x_msg_data OUT NOCOPY VARCHAR2,
2150: x_campaign_id OUT NOCOPY NUMBER,

Line 2156: p_end_date IN DATE := FND_API.G_MISS_DATE,

2152: p_new_camp_name IN VARCHAR2,
2153: p_par_camp_id IN NUMBER,
2154: p_source_code IN VARCHAR2 := NULL,
2155: p_camp_elements_rec IN camp_elements_rec_type,
2156: p_end_date IN DATE := FND_API.G_MISS_DATE,
2157: p_start_date IN DATE := FND_API.G_MISS_DATE)
2158: IS
2159: l_api_version CONSTANT NUMBER := 1.0;
2160: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Campaign';

Line 2157: p_start_date IN DATE := FND_API.G_MISS_DATE)

2153: p_par_camp_id IN NUMBER,
2154: p_source_code IN VARCHAR2 := NULL,
2155: p_camp_elements_rec IN camp_elements_rec_type,
2156: p_end_date IN DATE := FND_API.G_MISS_DATE,
2157: p_start_date IN DATE := FND_API.G_MISS_DATE)
2158: IS
2159: l_api_version CONSTANT NUMBER := 1.0;
2160: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Campaign';
2161: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'||l_api_name;

Line 2162: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2158: IS
2159: l_api_version CONSTANT NUMBER := 1.0;
2160: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Campaign';
2161: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'||l_api_name;
2162: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2163: l_lookup_meaning VARCHAR2(80);
2164: -- Stores the resource Id
2165: l_owner_user_id NUMBER := FND_API.G_MISS_NUM;
2166: l_mesg_text VARCHAR2(2000);

Line 2165: l_owner_user_id NUMBER := FND_API.G_MISS_NUM;

2161: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'||l_api_name;
2162: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2163: l_lookup_meaning VARCHAR2(80);
2164: -- Stores the resource Id
2165: l_owner_user_id NUMBER := FND_API.G_MISS_NUM;
2166: l_mesg_text VARCHAR2(2000);
2167:
2168: l_campaign_rec ams_campaigns_vl%ROWTYPE;
2169: l_user_status_id number;

Line 2221: x_return_status := fnd_api.g_ret_sts_success;

2217: FROM ams_campaigns_vl
2218: WHERE parent_campaign_id = p_src_camp_id;
2219:
2220: BEGIN
2221: x_return_status := fnd_api.g_ret_sts_success;
2222: --Standard Start API savePoint
2223: SAVEPOINT Copy_Campaign_PVT;
2224: IF NOT FND_API.Compatible_API_CALL (l_api_version,
2225: p_api_version,

Line 2224: IF NOT FND_API.Compatible_API_CALL (l_api_version,

2220: BEGIN
2221: x_return_status := fnd_api.g_ret_sts_success;
2222: --Standard Start API savePoint
2223: SAVEPOINT Copy_Campaign_PVT;
2224: IF NOT FND_API.Compatible_API_CALL (l_api_version,
2225: p_api_version,
2226: l_api_name,
2227: G_PKG_NAME
2228: )

Line 2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2226: l_api_name,
2227: G_PKG_NAME
2228: )
2229: THEN
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2231: END IF;
2232: -- Initialize the message List
2233: IF FND_API.to_Boolean( p_init_msg_list )
2234: THEN

Line 2233: IF FND_API.to_Boolean( p_init_msg_list )

2229: THEN
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2231: END IF;
2232: -- Initialize the message List
2233: IF FND_API.to_Boolean( p_init_msg_list )
2234: THEN
2235: FND_MSG_PUB.initialize ;
2236: END IF;
2237: -- Lookup Meaning from ams_lookup for CAMP

Line 2246: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2242: ams_utility_pvt.get_lookup_meaning( 'AMS_SYS_ARC_QUALIFIER',
2243: 'CAMP',
2244: l_return_status,
2245: l_lookup_meaning);
2246: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2247: RAISE FND_API.G_EXC_ERROR ;
2248: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2250: END IF;

Line 2247: RAISE FND_API.G_EXC_ERROR ;

2243: 'CAMP',
2244: l_return_status,
2245: l_lookup_meaning);
2246: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2247: RAISE FND_API.G_EXC_ERROR ;
2248: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2250: END IF;
2251:

Line 2248: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2244: l_return_status,
2245: l_lookup_meaning);
2246: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2247: RAISE FND_API.G_EXC_ERROR ;
2248: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2250: END IF;
2251:
2252: -- Start of Log

Line 2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2245: l_lookup_meaning);
2246: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2247: RAISE FND_API.G_EXC_ERROR ;
2248: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2250: END IF;
2251:
2252: -- Start of Log
2253: -- General Message saying copying has started

Line 2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2268: -- Call get_resource_id to get the resource id from jtf tables
2269: -- Returns -1 if the setup of resource was not done properly
2270: l_owner_user_id := ams_utility_pvt.get_resource_id(FND_GLOBAL.USER_ID);
2271: IF l_owner_user_id = -1 THEN
2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2273: END IF;
2274:
2275:
2276: -- Id for campaigns status = 'NEW'

Line 2280: IF l_user_status_id = FND_API.G_MISS_NUM then

2276: -- Id for campaigns status = 'NEW'
2277: OPEN cur_get_default_status;
2278: FETCH cur_get_default_status into l_user_status_id;
2279: CLOSE cur_get_default_status;
2280: IF l_user_status_id = FND_API.G_MISS_NUM then
2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2282: END IF;
2283:
2284: -- get the max version number of campaign if campaign name is same

Line 2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2277: OPEN cur_get_default_status;
2278: FETCH cur_get_default_status into l_user_status_id;
2279: CLOSE cur_get_default_status;
2280: IF l_user_status_id = FND_API.G_MISS_NUM then
2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2282: END IF;
2283:
2284: -- get the max version number of campaign if campaign name is same
2285: OPEN c_camp_name(p_new_camp_name);

Line 2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2393: l_date_number := ams_cpyutility_pvt.get_dates('CAMP',
2394: p_src_camp_id,
2395: l_return_status);
2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2398: RAISE FND_API.G_EXC_ERROR ;
2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2401: END IF;

Line 2398: RAISE FND_API.G_EXC_ERROR ;

2394: p_src_camp_id,
2395: l_return_status);
2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2398: RAISE FND_API.G_EXC_ERROR ;
2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2401: END IF;
2402:

Line 2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2395: l_return_status);
2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2398: RAISE FND_API.G_EXC_ERROR ;
2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2401: END IF;
2402:
2403: -- p_start_date is the user input date

Line 2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2398: RAISE FND_API.G_EXC_ERROR ;
2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2401: END IF;
2402:
2403: -- p_start_date is the user input date
2404: IF p_start_date IS NOT NULL THEN

Line 2440: p_init_msg_list => fnd_api.g_true,

2436: */
2437: -- Calling create campaign API l_camp_rec (Campaign details)
2438: -- returns campaign Id of the new campaign
2439: ams_campaign_pvt.create_campaign( p_api_version => l_api_version,
2440: p_init_msg_list => fnd_api.g_true,
2441: p_commit => FND_API.g_true,
2442: x_return_status => l_return_status,
2443: x_msg_count => l_msg_count,
2444: x_msg_data => l_msg_data,

Line 2441: p_commit => FND_API.g_true,

2437: -- Calling create campaign API l_camp_rec (Campaign details)
2438: -- returns campaign Id of the new campaign
2439: ams_campaign_pvt.create_campaign( p_api_version => l_api_version,
2440: p_init_msg_list => fnd_api.g_true,
2441: p_commit => FND_API.g_true,
2442: x_return_status => l_return_status,
2443: x_msg_count => l_msg_count,
2444: x_msg_data => l_msg_data,
2445: x_camp_id => x_campaign_id,

Line 2448: IF ( l_return_status = fnd_api.g_ret_sts_error ) OR

2444: x_msg_data => l_msg_data,
2445: x_camp_id => x_campaign_id,
2446: p_camp_rec => l_camp_rec);
2447:
2448: IF ( l_return_status = fnd_api.g_ret_sts_error ) OR
2449: ( l_return_status = fnd_api.g_ret_sts_error ) then
2450: FOR l_counter IN 1 .. l_msg_count
2451: LOOP
2452: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

Line 2449: ( l_return_status = fnd_api.g_ret_sts_error ) then

2445: x_camp_id => x_campaign_id,
2446: p_camp_rec => l_camp_rec);
2447:
2448: IF ( l_return_status = fnd_api.g_ret_sts_error ) OR
2449: ( l_return_status = fnd_api.g_ret_sts_error ) then
2450: FOR l_counter IN 1 .. l_msg_count
2451: LOOP
2452: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2453: l_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter ||

Line 2452: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2448: IF ( l_return_status = fnd_api.g_ret_sts_error ) OR
2449: ( l_return_status = fnd_api.g_ret_sts_error ) then
2450: FOR l_counter IN 1 .. l_msg_count
2451: LOOP
2452: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2453: l_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter ||
2454: ' OF ' || l_msg_count, 1, 3000);
2455: ams_cpyutility_pvt.write_log_mesg( 'CAMP',
2456: p_src_camp_id,

Line 2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2470: l_errmsg ,
2471: 'ERROR');
2472: END IF ;
2473:
2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2475: RAISE FND_API.G_EXC_ERROR ;
2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2478: END IF;

Line 2475: RAISE FND_API.G_EXC_ERROR ;

2471: 'ERROR');
2472: END IF ;
2473:
2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2475: RAISE FND_API.G_EXC_ERROR ;
2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2478: END IF;
2479: -- Schedules are not copied

Line 2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2472: END IF ;
2473:
2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2475: RAISE FND_API.G_EXC_ERROR ;
2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2478: END IF;
2479: -- Schedules are not copied
2480: -- Copy the schedule

Line 2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2473:
2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2475: RAISE FND_API.G_EXC_ERROR ;
2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2478: END IF;
2479: -- Schedules are not copied
2480: -- Copy the schedule
2481: -- IF p_camp_elements_rec.p_camp_sch = 'Y' THEN

Line 2487: -- ( p_init_msg_list => fnd_api.g_true,

2483: -- LOOP
2484: -- FETCH c_camp_sche INTO l_src_campaign_schedule_id;
2485: -- EXIT WHEN c_camp_sche%NOTFOUND;
2486: -- ams_copyelements_pvt.copy_campaign_schedules
2487: -- ( p_init_msg_list => fnd_api.g_true,
2488: -- p_api_version => l_api_version,
2489: -- x_return_status => l_return_status,
2490: -- x_msg_count => l_msg_count,
2491: -- x_msg_data => l_msg_data,

Line 2612: (p_init_msg_list => fnd_api.g_true,

2608:
2609: IF p_camp_elements_rec.p_tasks = 'Y' THEN
2610: FOR tasks_rec in cur_get_tasks(p_src_camp_id) LOOP
2611: ams_copyelements_pvt.copy_tasks
2612: (p_init_msg_list => fnd_api.g_true,
2613: p_api_version => l_api_version,
2614: x_return_status => l_return_status,
2615: x_msg_count => l_msg_count,
2616: x_msg_data => l_msg_data,

Line 2629: (p_init_msg_list => fnd_api.g_true,

2625:
2626: IF p_camp_elements_rec.p_partners = 'Y' THEN
2627:
2628: ams_copyelements_pvt.copy_partners
2629: (p_init_msg_list => fnd_api.g_true,
2630: p_api_version => l_api_version,
2631: x_return_status => l_return_status,
2632: x_msg_count => l_msg_count,
2633: x_msg_data => l_msg_data,

Line 2643: p_init_msg_list => fnd_api.g_true,

2639: IF p_camp_elements_rec.p_sub_camp = 'Y' THEN
2640: FOR sub_camp_rec IN sub_camp_cur LOOP
2641: commit;
2642: copy_campaign( p_api_version => 1,
2643: p_init_msg_list => fnd_api.g_true,
2644: x_return_status => l_return_status,
2645: x_msg_data => l_msg_data,
2646: x_msg_count => l_msg_count,
2647: p_src_camp_id => sub_camp_rec.campaign_id,

Line 2669: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2665: p_src_camp_id,
2666: l_mesg_text,
2667: 'GENERAL');
2668:
2669: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2670: COMMIT ;
2671: END IF ;
2672: EXCEPTION
2673: WHEN FND_API.G_EXC_ERROR THEN

Line 2673: WHEN FND_API.G_EXC_ERROR THEN

2669: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2670: COMMIT ;
2671: END IF ;
2672: EXCEPTION
2673: WHEN FND_API.G_EXC_ERROR THEN
2674: ROLLBACK TO Copy_Campaign_PVT;
2675: x_return_status := FND_API.G_RET_STS_ERROR ;
2676: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,
2677: p_data => x_msg_data

Line 2675: x_return_status := FND_API.G_RET_STS_ERROR ;

2671: END IF ;
2672: EXCEPTION
2673: WHEN FND_API.G_EXC_ERROR THEN
2674: ROLLBACK TO Copy_Campaign_PVT;
2675: x_return_status := FND_API.G_RET_STS_ERROR ;
2676: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,
2677: p_data => x_msg_data
2678: );
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2675: x_return_status := FND_API.G_RET_STS_ERROR ;
2676: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,
2677: p_data => x_msg_data
2678: );
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO Copy_Campaign_PVT;
2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2682: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,
2683: p_data => x_msg_data

Line 2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2677: p_data => x_msg_data
2678: );
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO Copy_Campaign_PVT;
2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2682: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,
2683: p_data => x_msg_data
2684: );
2685: WHEN OTHERS THEN

Line 2687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2683: p_data => x_msg_data
2684: );
2685: WHEN OTHERS THEN
2686: ROLLBACK TO Copy_Campaign_PVT;
2687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2688: IF FND_MSG_PUB.Check_Msg_Level
2689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2690: THEN
2691: FND_MSG_PUB.Add_Exc_MSG ( G_FILE_NAME,

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

2705:
2706:
2707: PROCEDURE copy_schedule_attributes (
2708: p_api_version IN NUMBER,
2709: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2710: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2711: x_return_status OUT NOCOPY VARCHAR2,
2712: x_msg_count OUT NOCOPY NUMBER,
2713: x_msg_data OUT NOCOPY VARCHAR2,

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

2706:
2707: PROCEDURE copy_schedule_attributes (
2708: p_api_version IN NUMBER,
2709: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2710: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2711: x_return_status OUT NOCOPY VARCHAR2,
2712: x_msg_count OUT NOCOPY NUMBER,
2713: x_msg_data OUT NOCOPY VARCHAR2,
2714: p_object_type IN VARCHAR2,

Line 2744: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2740: -- Standard Start of API savepoint
2741: SAVEPOINT copy_schedule_savepoint;
2742:
2743: -- Standard call to check for call compatibility.
2744: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2745: p_api_version,
2746: l_api_name,
2747: G_PKG_NAME)
2748: THEN

Line 2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2745: p_api_version,
2746: l_api_name,
2747: G_PKG_NAME)
2748: THEN
2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751:
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean( p_init_msg_list )THEN

Line 2753: IF FND_API.to_Boolean( p_init_msg_list )THEN

2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751:
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean( p_init_msg_list )THEN
2754: FND_MSG_PUB.initialize;
2755: END IF;
2756:
2757: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2766: x_return_status := FND_API.G_RET_STS_SUCCESS;

2762:
2763: END IF;
2764:
2765: -- Initialize API return status to SUCCESS
2766: x_return_status := FND_API.G_RET_STS_SUCCESS;
2767:
2768: --
2769: -- Start of API body.
2770: --

Line 2878: p_init_msg_list => fnd_api.g_false,

2874: IF p_attr_list.p_PTNR = 'Y'
2875: THEN
2876: ams_copyelements_pvt.copy_partners_generic(
2877: p_api_version => l_api_version,
2878: p_init_msg_list => fnd_api.g_false,
2879: x_return_status => l_return_status,
2880: x_msg_count => l_msg_count,
2881: x_msg_data => l_msg_data,
2882: p_old_id => p_src_object_id,

Line 2992: IF FND_API.to_Boolean( p_commit ) THEN

2988: -- End of API body.
2989: --
2990:
2991: -- Standard check for p_commit
2992: IF FND_API.to_Boolean( p_commit ) THEN
2993: COMMIT WORK;
2994: END IF;
2995:
2996:

Line 3009: WHEN FND_API.G_EXC_ERROR THEN

3005: p_count => x_msg_count,
3006: p_data => x_msg_data
3007: );
3008: EXCEPTION
3009: WHEN FND_API.G_EXC_ERROR THEN
3010: ROLLBACK TO copy_schedule_savepoint;
3011: x_return_status := FND_API.G_RET_STS_ERROR;
3012: -- Standard call to get message count and if count=1, get the message
3013: FND_MSG_PUB.Count_And_Get (

Line 3011: x_return_status := FND_API.G_RET_STS_ERROR;

3007: );
3008: EXCEPTION
3009: WHEN FND_API.G_EXC_ERROR THEN
3010: ROLLBACK TO copy_schedule_savepoint;
3011: x_return_status := FND_API.G_RET_STS_ERROR;
3012: -- Standard call to get message count and if count=1, get the message
3013: FND_MSG_PUB.Count_And_Get (
3014: p_encoded => FND_API.G_FALSE,
3015: p_count => x_msg_count,

Line 3014: p_encoded => FND_API.G_FALSE,

3010: ROLLBACK TO copy_schedule_savepoint;
3011: x_return_status := FND_API.G_RET_STS_ERROR;
3012: -- Standard call to get message count and if count=1, get the message
3013: FND_MSG_PUB.Count_And_Get (
3014: p_encoded => FND_API.G_FALSE,
3015: p_count => x_msg_count,
3016: p_data => x_msg_data
3017: );
3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3014: p_encoded => FND_API.G_FALSE,
3015: p_count => x_msg_count,
3016: p_data => x_msg_data
3017: );
3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3019: ROLLBACK TO copy_schedule_savepoint;
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3021: -- Standard call to get message count and if count=1, get the message
3022: FND_MSG_PUB.Count_And_Get (

Line 3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3016: p_data => x_msg_data
3017: );
3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3019: ROLLBACK TO copy_schedule_savepoint;
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3021: -- Standard call to get message count and if count=1, get the message
3022: FND_MSG_PUB.Count_And_Get (
3023: p_encoded => FND_API.G_FALSE,
3024: p_count => x_msg_count,

Line 3023: p_encoded => FND_API.G_FALSE,

3019: ROLLBACK TO copy_schedule_savepoint;
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3021: -- Standard call to get message count and if count=1, get the message
3022: FND_MSG_PUB.Count_And_Get (
3023: p_encoded => FND_API.G_FALSE,
3024: p_count => x_msg_count,
3025: p_data => x_msg_data
3026: );
3027: WHEN OTHERS THEN

Line 3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3025: p_data => x_msg_data
3026: );
3027: WHEN OTHERS THEN
3028: ROLLBACK TO copy_schedule_savepoint;
3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3031: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3032: END IF;
3033: -- Standard call to get message count and if count=1, get the message

Line 3035: p_encoded => FND_API.G_FALSE,

3031: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3032: END IF;
3033: -- Standard call to get message count and if count=1, get the message
3034: FND_MSG_PUB.Count_And_Get (
3035: p_encoded => FND_API.G_FALSE,
3036: p_count => x_msg_count,
3037: p_data => x_msg_data
3038: );
3039: END copy_schedule_attributes;