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_EVENT_OBJECTS_COPY_PVT dependencies on FND_API

Line 175: p_init_msg_list => FND_API.G_FALSE,

171: l_stmt_num := 1;
172:
173: AMS_EventSchedule_Copy_PVT.copy_event_schedule(
174: p_api_version => 1.0,
175: p_init_msg_list => FND_API.G_FALSE,
176: p_commit => FND_API.G_FALSE,
177: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
178:
179: x_return_status => l_return_status,

Line 176: p_commit => FND_API.G_FALSE,

172:
173: AMS_EventSchedule_Copy_PVT.copy_event_schedule(
174: p_api_version => 1.0,
175: p_init_msg_list => FND_API.G_FALSE,
176: p_commit => FND_API.G_FALSE,
177: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
178:
179: x_return_status => l_return_status,
180: x_msg_count => x_msg_count,

Line 177: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

173: AMS_EventSchedule_Copy_PVT.copy_event_schedule(
174: p_api_version => 1.0,
175: p_init_msg_list => FND_API.G_FALSE,
176: p_commit => FND_API.G_FALSE,
177: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
178:
179: x_return_status => l_return_status,
180: x_msg_count => x_msg_count,
181: x_msg_data => l_msg_data,

Line 196: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

192: This way we are attaching the offers to a particular
193: event header .
194: */
195:
196: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
197: RAISE Fnd_Api.G_EXC_ERROR;
198: END IF;
199:
200: -- IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 197: RAISE Fnd_Api.G_EXC_ERROR;

193: event header .
194: */
195:
196: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
197: RAISE Fnd_Api.G_EXC_ERROR;
198: END IF;
199:
200: -- IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
201: UPDATE ams_event_offers_all_b

Line 200: -- IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

196: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
197: RAISE Fnd_Api.G_EXC_ERROR;
198: END IF;
199:
200: -- IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
201: UPDATE ams_event_offers_all_b
202: SET event_header_id = p_new_act_id
203: WHERE event_offer_id = l_new_object_id;
204: -- END IF;

Line 209: IF l_return_status = fnd_api.g_ret_sts_error

205:
206: -- dbms_output.put_line('the new rec with new header/offer ids are '|| p_src_act_id ||'/'|| l_new_object_id);
207:
208:
209: IF l_return_status = fnd_api.g_ret_sts_error
210: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
211: FOR l_counter IN 1 .. x_msg_count
212: LOOP
213: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

Line 210: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN

206: -- dbms_output.put_line('the new rec with new header/offer ids are '|| p_src_act_id ||'/'|| l_new_object_id);
207:
208:
209: IF l_return_status = fnd_api.g_ret_sts_error
210: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
211: FOR l_counter IN 1 .. x_msg_count
212: LOOP
213: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
214: l_stmt_num := 2;

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

209: IF l_return_status = fnd_api.g_ret_sts_error
210: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
211: FOR l_counter IN 1 .. x_msg_count
212: LOOP
213: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
214: l_stmt_num := 2;
215: p_errnum := 1;
216: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
217: ' , ' || '): ' || l_counter ||

Line 344: p_init_msg_list => fnd_api.g_true,

340: END IF;
341: --End Added for the bug fix : 5213670
342: ams_associations_pvt.create_association(
343: p_api_version => l_api_version,
344: p_init_msg_list => fnd_api.g_true,
345: p_commit=>g_commit,
346: p_validation_level=> FND_API.g_valid_level_full,
347: x_return_status => l_return_status,
348: x_msg_count => x_msg_count,

Line 346: p_validation_level=> FND_API.g_valid_level_full,

342: ams_associations_pvt.create_association(
343: p_api_version => l_api_version,
344: p_init_msg_list => fnd_api.g_true,
345: p_commit=>g_commit,
346: p_validation_level=> FND_API.g_valid_level_full,
347: x_return_status => l_return_status,
348: x_msg_count => x_msg_count,
349: x_msg_data => l_msg_data,
350: p_association_rec => l_deliverables_rec,

Line 355: IF l_return_status = fnd_api.g_ret_sts_error

351: x_object_association_id => l_act_deliverable_id
352: );
353: --Added for the bug fix : 5213670
354: g_commit:='T';
355: IF l_return_status = fnd_api.g_ret_sts_error
356: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
357: FOR l_counter IN 1 .. x_msg_count
358: LOOP
359: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

Line 356: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN

352: );
353: --Added for the bug fix : 5213670
354: g_commit:='T';
355: IF l_return_status = fnd_api.g_ret_sts_error
356: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
357: FOR l_counter IN 1 .. x_msg_count
358: LOOP
359: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
360: l_stmt_num := 2;

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

355: IF l_return_status = fnd_api.g_ret_sts_error
356: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
357: FOR l_counter IN 1 .. x_msg_count
358: LOOP
359: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
360: l_stmt_num := 2;
361: p_errnum := 1;
362: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
363: ' , ' || '): ' || l_counter ||

Line 565: p_init_msg_list => FND_API.G_FALSE,

561: l_agenda_rec.event_level:='SUB';
562: l_agenda_rec.user_status_id:=agenda_rec.user_status_id;
563: AMS_EventHeader_PVT.create_event_header (
564: p_api_version => 1.0,
565: p_init_msg_list => FND_API.G_FALSE,
566: p_commit => FND_API.G_FALSE,
567: p_validation_level => FND_API.g_valid_level_full,
568: x_return_status => l_return_status,
569: x_msg_count => x_msg_count,

Line 566: p_commit => FND_API.G_FALSE,

562: l_agenda_rec.user_status_id:=agenda_rec.user_status_id;
563: AMS_EventHeader_PVT.create_event_header (
564: p_api_version => 1.0,
565: p_init_msg_list => FND_API.G_FALSE,
566: p_commit => FND_API.G_FALSE,
567: p_validation_level => FND_API.g_valid_level_full,
568: x_return_status => l_return_status,
569: x_msg_count => x_msg_count,
570: x_msg_data => l_msg_data,

Line 567: p_validation_level => FND_API.g_valid_level_full,

563: AMS_EventHeader_PVT.create_event_header (
564: p_api_version => 1.0,
565: p_init_msg_list => FND_API.G_FALSE,
566: p_commit => FND_API.G_FALSE,
567: p_validation_level => FND_API.g_valid_level_full,
568: x_return_status => l_return_status,
569: x_msg_count => x_msg_count,
570: x_msg_data => l_msg_data,
571: p_evh_rec => l_agenda_rec,

Line 584: IF l_return_status = fnd_api.g_ret_sts_error

580:
581: END IF;
582:
583:
584: IF l_return_status = fnd_api.g_ret_sts_error
585: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
586: FOR l_counter IN 1 .. x_msg_count
587: LOOP
588: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

Line 585: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN

581: END IF;
582:
583:
584: IF l_return_status = fnd_api.g_ret_sts_error
585: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
586: FOR l_counter IN 1 .. x_msg_count
587: LOOP
588: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
589: l_stmt_num := 2;

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

584: IF l_return_status = fnd_api.g_ret_sts_error
585: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
586: FOR l_counter IN 1 .. x_msg_count
587: LOOP
588: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
589: l_stmt_num := 2;
590: p_errnum := 1;
591: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
592: ' , ' || '): ' || l_counter ||

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

659:
660:
661: PROCEDURE copy_event_header(
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
664: p_commit IN VARCHAR2 := FND_API.G_FALSE,
665: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
666:
667: x_return_status OUT NOCOPY VARCHAR2,

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

660:
661: PROCEDURE copy_event_header(
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
664: p_commit IN VARCHAR2 := FND_API.G_FALSE,
665: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
666:
667: x_return_status OUT NOCOPY VARCHAR2,
668: x_msg_count OUT NOCOPY NUMBER,

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

661: PROCEDURE copy_event_header(
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
664: p_commit IN VARCHAR2 := FND_API.G_FALSE,
665: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
666:
667: x_return_status OUT NOCOPY VARCHAR2,
668: x_msg_count OUT NOCOPY NUMBER,
669: x_msg_data OUT NOCOPY VARCHAR2,

Line 684: l_org_id NUMBER := FND_API.G_MISS_NUM;

680: L_API_NAME CONSTANT VARCHAR2(30) := 'create_event_header';
681: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
682: l_return_status_full VARCHAR2(1);
683: l_object_version_number NUMBER(9) := 2;-- Copy 5171873
684: l_org_id NUMBER := FND_API.G_MISS_NUM;
685: l_event_header_id NUMBER:=p_source_object_id;
686: l_new_event_header_id NUMBER;
687: l_dummy NUMBER;
688: p_event_header_rec AMS_EventHeader_PVT.evh_rec_type;

Line 717: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

713: -- Standard Start of API savepoint
714: SAVEPOINT copy_event_header;
715:
716: -- Standard call to check for call compatibility.
717: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
718: p_api_version,
719: l_api_name,
720: G_PKG_NAME)
721: THEN

Line 722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

718: p_api_version,
719: l_api_name,
720: G_PKG_NAME)
721: THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END IF;
724:
725: -- Initialize message list if p_init_msg_list is set to TRUE.
726: IF FND_API.to_Boolean( p_init_msg_list )

Line 726: IF FND_API.to_Boolean( p_init_msg_list )

722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END IF;
724:
725: -- Initialize message list if p_init_msg_list is set to TRUE.
726: IF FND_API.to_Boolean( p_init_msg_list )
727: THEN
728: FND_MSG_PUB.initialize;
729: END IF;
730:

Line 767: x_return_status := FND_API.G_RET_STS_SUCCESS;

763: AMS_UTILITY_PVT.debug_message('the'||i||'attibute: '||p_attributes_table(i));
764: END IF;
765: END LOOP;
766: -- Initialize API return status to SUCCESS
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768:
769:
770: --
771: -- Start of API body

Line 861: p_init_msg_list => FND_API.G_FALSE,

857: END IF;
858:
859: AMS_EventHeader_PVT.create_event_header (
860: p_api_version => 1.0,
861: p_init_msg_list => FND_API.G_FALSE,
862: p_commit => FND_API.G_FALSE,
863: p_validation_level => FND_API.g_valid_level_full,
864: x_return_status => x_return_status,
865: x_msg_count => x_msg_count,

Line 862: p_commit => FND_API.G_FALSE,

858:
859: AMS_EventHeader_PVT.create_event_header (
860: p_api_version => 1.0,
861: p_init_msg_list => FND_API.G_FALSE,
862: p_commit => FND_API.G_FALSE,
863: p_validation_level => FND_API.g_valid_level_full,
864: x_return_status => x_return_status,
865: x_msg_count => x_msg_count,
866: x_msg_data => x_msg_data,

Line 863: p_validation_level => FND_API.g_valid_level_full,

859: AMS_EventHeader_PVT.create_event_header (
860: p_api_version => 1.0,
861: p_init_msg_list => FND_API.G_FALSE,
862: p_commit => FND_API.G_FALSE,
863: p_validation_level => FND_API.g_valid_level_full,
864: x_return_status => x_return_status,
865: x_msg_count => x_msg_count,
866: x_msg_data => x_msg_data,
867: p_evh_rec => l_event_header_rec,

Line 871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

867: p_evh_rec => l_event_header_rec,
868: x_evh_id => l_new_event_header_id
869: );
870:
871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END IF;
874: -- copy agenda
875: IF l_event_header_id IS NOT NULL THEN

Line 872: RAISE FND_API.G_EXC_ERROR;

868: x_evh_id => l_new_event_header_id
869: );
870:
871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END IF;
874: -- copy agenda
875: IF l_event_header_id IS NOT NULL THEN
876:

Line 891: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_AGEN , p_attributes_table) = FND_API.G_TRUE THEN

887: AMS_UTILITY_PVT.debug_message('the l_new_event_header_id: ' || l_new_event_header_id||'\n');
888: END IF;
889:
890: END IF;
891: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_AGEN , p_attributes_table) = FND_API.G_TRUE THEN
892: copy_event_header_agenda (
893: p_src_act_type => G_OBJECT_TYPE_MODEL,
894: p_new_act_type => G_OBJECT_TYPE_MODEL,
895: p_src_act_id => l_event_header_id,

Line 901: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

897: p_errnum => l_errnum,
898: p_errcode => l_errcode,
899: p_errmsg => l_errmsg
900: );
901: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904: END IF;
905:

Line 902: RAISE FND_API.G_EXC_ERROR;

898: p_errcode => l_errcode,
899: p_errmsg => l_errmsg
900: );
901: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904: END IF;
905:
906: -- copy resources

Line 908: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_RESC, p_attributes_table) = FND_API.G_TRUE THEN

904: END IF;
905:
906: -- copy resources
907: /* Commented by mukemar on may14 2002 we are not supporting the resource copy
908: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_RESC, p_attributes_table) = FND_API.G_TRUE THEN
909: AMS_CopyElements_PVT.copy_act_resources (
910: p_src_act_type => G_OBJECT_TYPE_MODEL,
911: p_new_act_type => G_OBJECT_TYPE_MODEL,
912: p_src_act_id => l_event_header_id,

Line 918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

914: p_errnum => l_errnum,
915: p_errcode => l_errcode,
916: p_errmsg => l_errmsg
917: );
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922: */

Line 919: RAISE FND_API.G_EXC_ERROR;

915: p_errcode => l_errcode,
916: p_errmsg => l_errmsg
917: );
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922: */
923: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN

Line 923: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN

919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922: */
923: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN
924: AMS_CopyElements_PVT.copy_act_prod (
925: p_src_act_type => G_OBJECT_TYPE_MODEL,
926: p_new_act_type => G_OBJECT_TYPE_MODEL,
927: p_src_act_id => l_event_header_id,

Line 933: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

929: p_errnum => l_errnum,
930: p_errcode => l_errcode,
931: p_errmsg => l_errmsg
932: );
933: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: END IF;
937: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN

Line 934: RAISE FND_API.G_EXC_ERROR;

930: p_errcode => l_errcode,
931: p_errmsg => l_errmsg
932: );
933: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: END IF;
937: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN
938: AMS_CopyElements_PVT.copy_act_geo_areas (

Line 937: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN

933: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: END IF;
937: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN
938: AMS_CopyElements_PVT.copy_act_geo_areas (
939: p_src_act_type => G_OBJECT_TYPE_MODEL,
940: p_new_act_type => G_OBJECT_TYPE_MODEL,
941: p_src_act_id => l_event_header_id,

Line 947: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

943: p_errnum => l_errnum,
944: p_errcode => l_errcode,
945: p_errmsg => l_errmsg
946: );
947: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN

Line 948: RAISE FND_API.G_EXC_ERROR;

944: p_errcode => l_errcode,
945: p_errmsg => l_errmsg
946: );
947: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN
952: AMS_CopyElements_PVT.copy_act_market_segments (

Line 951: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN

947: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN
952: AMS_CopyElements_PVT.copy_act_market_segments (
953: p_src_act_type => G_OBJECT_TYPE_MODEL,
954: p_new_act_type => G_OBJECT_TYPE_MODEL,
955: p_src_act_id => l_event_header_id,

Line 961: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

957: p_errnum => l_errnum,
958: p_errcode => l_errcode,
959: p_errmsg => l_errmsg
960: );
961: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: END IF;
965:

Line 962: RAISE FND_API.G_EXC_ERROR;

958: p_errcode => l_errcode,
959: p_errmsg => l_errmsg
960: );
961: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: END IF;
965:
966: -- copy categories

Line 967: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CATG, p_attributes_table) = FND_API.G_TRUE THEN

963: END IF;
964: END IF;
965:
966: -- copy categories
967: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_CATG, p_attributes_table) = FND_API.G_TRUE THEN
968: AMS_CopyElements_PVT.copy_act_categories (
969: p_src_act_type => G_OBJECT_TYPE_MODEL,
970: p_new_act_type => G_OBJECT_TYPE_MODEL,
971: p_src_act_id => l_event_header_id,

Line 977: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

973: p_errnum => l_errnum,
974: p_errcode => l_errcode,
975: p_errmsg => l_errmsg
976: );
977: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: END IF;
981: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_ATCH, p_attributes_table) = FND_API.G_TRUE THEN

Line 978: RAISE FND_API.G_EXC_ERROR;

974: p_errcode => l_errcode,
975: p_errmsg => l_errmsg
976: );
977: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: END IF;
981: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_ATCH, p_attributes_table) = FND_API.G_TRUE THEN
982: AMS_CopyElements_PVT.copy_act_attachments (

Line 981: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_ATCH, p_attributes_table) = FND_API.G_TRUE THEN

977: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: END IF;
981: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_ATCH, p_attributes_table) = FND_API.G_TRUE THEN
982: AMS_CopyElements_PVT.copy_act_attachments (
983: p_src_act_type => G_OBJECT_TYPE_MODEL,
984: p_new_act_type => G_OBJECT_TYPE_MODEL,
985: p_src_act_id => l_event_header_id,

Line 991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

987: p_errnum => l_errnum,
988: p_errcode => l_errcode,
989: p_errmsg => l_errmsg
990: );
991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994: END IF;
995:

Line 992: RAISE FND_API.G_EXC_ERROR;

988: p_errcode => l_errcode,
989: p_errmsg => l_errmsg
990: );
991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994: END IF;
995:
996: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_MESG, p_attributes_table) = FND_API.G_TRUE THEN

Line 996: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_MESG, p_attributes_table) = FND_API.G_TRUE THEN

992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994: END IF;
995:
996: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_MESG, p_attributes_table) = FND_API.G_TRUE THEN
997: AMS_CopyElements_PVT.copy_act_messages(
998: p_src_act_type => G_OBJECT_TYPE_MODEL,
999: p_new_act_type => G_OBJECT_TYPE_MODEL,
1000: p_src_act_id => l_event_header_id,

Line 1006: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1002: p_errnum => l_errnum,
1003: p_errcode => l_errcode,
1004: p_errmsg => l_errmsg
1005: );
1006: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: END IF;
1010:

Line 1007: RAISE FND_API.G_EXC_ERROR;

1003: p_errcode => l_errcode,
1004: p_errmsg => l_errmsg
1005: );
1006: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: END IF;
1010:
1011: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_DELV, p_attributes_table) = FND_API.G_TRUE THEN

Line 1011: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_DELV, p_attributes_table) = FND_API.G_TRUE THEN

1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: END IF;
1010:
1011: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_DELV, p_attributes_table) = FND_API.G_TRUE THEN
1012: --Added for the bug fix : 5213670
1013: g_commit:='F';
1014: copy_act_delivery_method(
1015: p_src_act_type => G_OBJECT_TYPE_MODEL,

Line 1024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1020: p_errcode => l_errcode,
1021: p_errmsg => l_errmsg
1022: );
1023:
1024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;
1027: END IF;
1028:

Line 1025: RAISE FND_API.G_EXC_ERROR;

1021: p_errmsg => l_errmsg
1022: );
1023:
1024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;
1027: END IF;
1028:
1029:

Line 1030: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_EVEO, p_attributes_table) = FND_API.G_TRUE THEN

1026: END IF;
1027: END IF;
1028:
1029:
1030: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_EVEO, p_attributes_table) = FND_API.G_TRUE THEN
1031:
1032: -- Get the Schedule Ids as comma separated variables.
1033: IF (AMS_DEBUG_HIGH_ON) THEN
1034:

Line 1091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1087: p_errmsg => l_errmsg
1088: );
1089:
1090:
1091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;
1094: END IF;
1095:

Line 1092: RAISE FND_API.G_EXC_ERROR;

1088: );
1089:
1090:
1091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;
1094: END IF;
1095:
1096: END LOOP; -- WHILE (l_copy_sched_cont_flag <> 'N')

Line 1107: IF FND_API.to_Boolean( p_commit )

1103: x_custom_setup_id:= l_new_reference_rec.custom_setup_id;
1104:
1105:
1106:
1107: IF FND_API.to_Boolean( p_commit )
1108: THEN
1109: COMMIT WORK;
1110: END IF;
1111:

Line 1126: WHEN FND_API.G_EXC_ERROR THEN

1122: );
1123:
1124:
1125: EXCEPTION
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: ROLLBACK TO copy_event_header;
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: -- Standard call to get message count and if count=1, get the message
1130: FND_MSG_PUB.Count_And_Get (

Line 1128: x_return_status := FND_API.G_RET_STS_ERROR;

1124:
1125: EXCEPTION
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: ROLLBACK TO copy_event_header;
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: -- Standard call to get message count and if count=1, get the message
1130: FND_MSG_PUB.Count_And_Get (
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,

Line 1131: p_encoded => FND_API.G_FALSE,

1127: ROLLBACK TO copy_event_header;
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: -- Standard call to get message count and if count=1, get the message
1130: FND_MSG_PUB.Count_And_Get (
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: ROLLBACK TO copy_event_header;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (

Line 1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1133: p_data => x_msg_data
1134: );
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136: ROLLBACK TO copy_event_header;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (
1140: p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,

Line 1140: p_encoded => FND_API.G_FALSE,

1136: ROLLBACK TO copy_event_header;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (
1140: p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144:

Line 1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1143: );
1144:
1145: WHEN OTHERS THEN
1146: ROLLBACK TO copy_event_header;
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1150: END IF;
1151: -- Standard call to get message count and if count=1, get the message

Line 1153: p_encoded => FND_API.G_FALSE,

1149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1150: END IF;
1151: -- Standard call to get message count and if count=1, get the message
1152: FND_MSG_PUB.Count_And_Get (
1153: p_encoded => FND_API.G_FALSE,
1154: p_count => x_msg_count,
1155: p_data => x_msg_data
1156: );
1157: