APPS.AMS_EVENTSCHEDULE_COPY_PVT dependencies on FND_API

Line 156: p_init_msg_list => fnd_api.g_true,

152: x_msg_count := 0;
153: l_msg_data := NULL;
154: ams_associations_pvt.create_association(
155: p_api_version => l_api_version,
156: p_init_msg_list => fnd_api.g_true,
157: p_commit=>fnd_api.g_true,
158: p_validation_level=> FND_API.g_valid_level_full,
159: x_return_status => l_return_status,
160: x_msg_count => x_msg_count,

Line 157: p_commit=>fnd_api.g_true,

153: l_msg_data := NULL;
154: ams_associations_pvt.create_association(
155: p_api_version => l_api_version,
156: p_init_msg_list => fnd_api.g_true,
157: p_commit=>fnd_api.g_true,
158: p_validation_level=> FND_API.g_valid_level_full,
159: x_return_status => l_return_status,
160: x_msg_count => x_msg_count,
161: x_msg_data => l_msg_data,

Line 158: p_validation_level=> FND_API.g_valid_level_full,

154: ams_associations_pvt.create_association(
155: p_api_version => l_api_version,
156: p_init_msg_list => fnd_api.g_true,
157: p_commit=>fnd_api.g_true,
158: p_validation_level=> FND_API.g_valid_level_full,
159: x_return_status => l_return_status,
160: x_msg_count => x_msg_count,
161: x_msg_data => l_msg_data,
162: p_association_rec => l_deliverables_rec,

Line 167: IF l_return_status = fnd_api.g_ret_sts_error

163: x_object_association_id => l_act_deliverable_id
164: );
165:
166:
167: IF l_return_status = fnd_api.g_ret_sts_error
168: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
169: FOR l_counter IN 1 .. x_msg_count
170: LOOP
171: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

Line 168: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN

164: );
165:
166:
167: IF l_return_status = fnd_api.g_ret_sts_error
168: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
169: FOR l_counter IN 1 .. x_msg_count
170: LOOP
171: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
172: l_stmt_num := 2;

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

167: IF l_return_status = fnd_api.g_ret_sts_error
168: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
169: FOR l_counter IN 1 .. x_msg_count
170: LOOP
171: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
172: l_stmt_num := 2;
173: p_errnum := 1;
174: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
175: ' , ' || '): ' || l_counter ||

Line 427: p_init_msg_list => FND_API.G_FALSE,

423: l_agenda_rec.user_status_id:=agenda_rec.user_status_id;
424:
425: AMS_EventOffer_PVT.create_event_offer (
426: p_api_version => 1.0,
427: p_init_msg_list => FND_API.G_FALSE,
428: p_commit => FND_API.G_FALSE,
429: p_validation_level => FND_API.g_valid_level_full,
430: p_evo_rec => l_agenda_rec,
431: x_return_status => l_return_status,

Line 428: p_commit => FND_API.G_FALSE,

424:
425: AMS_EventOffer_PVT.create_event_offer (
426: p_api_version => 1.0,
427: p_init_msg_list => FND_API.G_FALSE,
428: p_commit => FND_API.G_FALSE,
429: p_validation_level => FND_API.g_valid_level_full,
430: p_evo_rec => l_agenda_rec,
431: x_return_status => l_return_status,
432: x_msg_count => x_msg_count,

Line 429: p_validation_level => FND_API.g_valid_level_full,

425: AMS_EventOffer_PVT.create_event_offer (
426: p_api_version => 1.0,
427: p_init_msg_list => FND_API.G_FALSE,
428: p_commit => FND_API.G_FALSE,
429: p_validation_level => FND_API.g_valid_level_full,
430: p_evo_rec => l_agenda_rec,
431: x_return_status => l_return_status,
432: x_msg_count => x_msg_count,
433: x_msg_data => l_msg_data,

Line 448: IF l_return_status = fnd_api.g_ret_sts_error

444:
445:
446:
447:
448: IF l_return_status = fnd_api.g_ret_sts_error
449: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
450: FOR l_counter IN 1 .. x_msg_count
451: LOOP
452: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

Line 449: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN

445:
446:
447:
448: IF l_return_status = fnd_api.g_ret_sts_error
449: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
450: FOR l_counter IN 1 .. x_msg_count
451: LOOP
452: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
453: l_stmt_num := 2;

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

448: IF l_return_status = fnd_api.g_ret_sts_error
449: OR l_return_status = fnd_api.g_ret_sts_unexp_error THEN
450: FOR l_counter IN 1 .. x_msg_count
451: LOOP
452: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
453: l_stmt_num := 2;
454: p_errnum := 1;
455: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
456: ' , ' || '): ' || l_counter ||

Line 648: p_init_msg_list => FND_API.G_FALSE,

644: l_new_track_cur.parent_id := p_new_act_id;
645:
646: AMS_AGENDAS_PVT.create_agenda (
647: p_api_version => 1.0,
648: p_init_msg_list => FND_API.G_FALSE,
649: p_commit => FND_API.G_FALSE,
650: p_validation_level => FND_API.g_valid_level_full,
651: p_agenda_rec => l_new_track_cur,
652: x_return_status => l_return_status,

Line 649: p_commit => FND_API.G_FALSE,

645:
646: AMS_AGENDAS_PVT.create_agenda (
647: p_api_version => 1.0,
648: p_init_msg_list => FND_API.G_FALSE,
649: p_commit => FND_API.G_FALSE,
650: p_validation_level => FND_API.g_valid_level_full,
651: p_agenda_rec => l_new_track_cur,
652: x_return_status => l_return_status,
653: x_msg_count => x_msg_count,

Line 650: p_validation_level => FND_API.g_valid_level_full,

646: AMS_AGENDAS_PVT.create_agenda (
647: p_api_version => 1.0,
648: p_init_msg_list => FND_API.G_FALSE,
649: p_commit => FND_API.G_FALSE,
650: p_validation_level => FND_API.g_valid_level_full,
651: p_agenda_rec => l_new_track_cur,
652: x_return_status => l_return_status,
653: x_msg_count => x_msg_count,
654: x_msg_data => l_msg_data,

Line 661: IF l_return_status = fnd_api.g_ret_sts_error

657:
658: IF (AMS_DEBUG_HIGH_ON) THEN
659: AMS_UTILITY_PVT.debug_message('the p_act_agenda_id: ' || l_act_track_id||'\n');
660: END IF;
661: IF l_return_status = fnd_api.g_ret_sts_error
662: OR l_return_status = fnd_api.g_ret_sts_unexp_error
663: THEN
664: FOR l_counter IN 1 .. x_msg_count
665: LOOP

Line 662: OR l_return_status = fnd_api.g_ret_sts_unexp_error

658: IF (AMS_DEBUG_HIGH_ON) THEN
659: AMS_UTILITY_PVT.debug_message('the p_act_agenda_id: ' || l_act_track_id||'\n');
660: END IF;
661: IF l_return_status = fnd_api.g_ret_sts_error
662: OR l_return_status = fnd_api.g_ret_sts_unexp_error
663: THEN
664: FOR l_counter IN 1 .. x_msg_count
665: LOOP
666: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

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

662: OR l_return_status = fnd_api.g_ret_sts_unexp_error
663: THEN
664: FOR l_counter IN 1 .. x_msg_count
665: LOOP
666: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
667: l_stmt_num := 2;
668: p_errnum := 1;
669: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
670: ' , ' || '): ' || l_counter ||

Line 733: p_init_msg_list => FND_API.G_FALSE,

729: END IF;
730:
731: AMS_AGENDAS_PVT.create_agenda (
732: p_api_version => 1.0,
733: p_init_msg_list => FND_API.G_FALSE,
734: p_commit => FND_API.G_FALSE,
735: p_validation_level => FND_API.g_valid_level_full,
736: p_agenda_rec => l_new_session_cur,
737: x_return_status => l_return_status,

Line 734: p_commit => FND_API.G_FALSE,

730:
731: AMS_AGENDAS_PVT.create_agenda (
732: p_api_version => 1.0,
733: p_init_msg_list => FND_API.G_FALSE,
734: p_commit => FND_API.G_FALSE,
735: p_validation_level => FND_API.g_valid_level_full,
736: p_agenda_rec => l_new_session_cur,
737: x_return_status => l_return_status,
738: x_msg_count => x_msg_count,

Line 735: p_validation_level => FND_API.g_valid_level_full,

731: AMS_AGENDAS_PVT.create_agenda (
732: p_api_version => 1.0,
733: p_init_msg_list => FND_API.G_FALSE,
734: p_commit => FND_API.G_FALSE,
735: p_validation_level => FND_API.g_valid_level_full,
736: p_agenda_rec => l_new_session_cur,
737: x_return_status => l_return_status,
738: x_msg_count => x_msg_count,
739: x_msg_data => l_msg_data,

Line 743: IF l_return_status = fnd_api.g_ret_sts_error

739: x_msg_data => l_msg_data,
740: x_agenda_id => l_act_session_id
741: );
742:
743: IF l_return_status = fnd_api.g_ret_sts_error
744: OR l_return_status = fnd_api.g_ret_sts_unexp_error
745: THEN
746:
747: FOR l_counter IN 1 .. x_msg_count

Line 744: OR l_return_status = fnd_api.g_ret_sts_unexp_error

740: x_agenda_id => l_act_session_id
741: );
742:
743: IF l_return_status = fnd_api.g_ret_sts_error
744: OR l_return_status = fnd_api.g_ret_sts_unexp_error
745: THEN
746:
747: FOR l_counter IN 1 .. x_msg_count
748: LOOP

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

745: THEN
746:
747: FOR l_counter IN 1 .. x_msg_count
748: LOOP
749: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
750: l_stmt_num := 2;
751: p_errnum := 1;
752: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
753: ' , ' || '): ' || l_counter ||

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

826:
827:
828: PROCEDURE copy_event_schedule(
829: p_api_version IN NUMBER,
830: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
831: p_commit IN VARCHAR2 := FND_API.G_FALSE,
832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
833:
834: x_return_status OUT NOCOPY VARCHAR2,

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

827:
828: PROCEDURE copy_event_schedule(
829: p_api_version IN NUMBER,
830: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
831: p_commit IN VARCHAR2 := FND_API.G_FALSE,
832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
833:
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,

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

828: PROCEDURE copy_event_schedule(
829: p_api_version IN NUMBER,
830: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
831: p_commit IN VARCHAR2 := FND_API.G_FALSE,
832: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
833:
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2,

Line 851: l_org_id NUMBER := FND_API.G_MISS_NUM;

847: L_API_NAME CONSTANT VARCHAR2(30) := 'create_event_offer';
848: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
849: l_return_status_full VARCHAR2(1);
850: l_object_version_number NUMBER := 2;
851: l_org_id NUMBER := FND_API.G_MISS_NUM;
852: l_event_offer_id NUMBER :=p_source_object_id;
853: l_new_event_offer_id NUMBER;
854: l_dummy NUMBER;
855: p_event_offer_rec AMS_EVENTOFFER_PVT.evo_rec_type;

Line 891: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

887: -- Standard Start of API savepoint
888: SAVEPOINT copy_event_schedule;
889:
890: -- Standard call to check for call compatibility.
891: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
892: p_api_version,
893: l_api_name,
894: G_PKG_NAME)
895: THEN

Line 896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

892: p_api_version,
893: l_api_name,
894: G_PKG_NAME)
895: THEN
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END IF;
898:
899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: IF FND_API.to_Boolean( p_init_msg_list )

Line 900: IF FND_API.to_Boolean( p_init_msg_list )

896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END IF;
898:
899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: IF FND_API.to_Boolean( p_init_msg_list )
901: THEN
902: FND_MSG_PUB.initialize;
903: END IF;
904:

Line 939: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

935: AMS_UTILITY_PVT.debug_message('the'||i||'attibute: '||p_attributes_table(i));
936: END IF;
937: END LOOP;
938: -- Initialize API return status to SUCCESS
939: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
940:
941:
942: --
943: -- Start of API body

Line 1063: p_init_msg_list => FND_API.G_FALSE,

1059: l_event_offer_rec.object_version_number := 2;
1060: -- DBMS_OUTPUT.put_line('calling create with ');
1061: AMS_EventOffer_PVT.create_event_offer (
1062: p_api_version => 1.0,
1063: p_init_msg_list => FND_API.G_FALSE,
1064: p_commit => FND_API.G_FALSE,
1065: p_validation_level => FND_API.g_valid_level_full,
1066: p_evo_rec => l_event_offer_rec,
1067: x_return_status => x_return_status,

Line 1064: p_commit => FND_API.G_FALSE,

1060: -- DBMS_OUTPUT.put_line('calling create with ');
1061: AMS_EventOffer_PVT.create_event_offer (
1062: p_api_version => 1.0,
1063: p_init_msg_list => FND_API.G_FALSE,
1064: p_commit => FND_API.G_FALSE,
1065: p_validation_level => FND_API.g_valid_level_full,
1066: p_evo_rec => l_event_offer_rec,
1067: x_return_status => x_return_status,
1068: x_msg_count => x_msg_count,

Line 1065: p_validation_level => FND_API.g_valid_level_full,

1061: AMS_EventOffer_PVT.create_event_offer (
1062: p_api_version => 1.0,
1063: p_init_msg_list => FND_API.G_FALSE,
1064: p_commit => FND_API.G_FALSE,
1065: p_validation_level => FND_API.g_valid_level_full,
1066: p_evo_rec => l_event_offer_rec,
1067: x_return_status => x_return_status,
1068: x_msg_count => x_msg_count,
1069: x_msg_data => x_msg_data,

Line 1074: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1070:
1071: x_evo_id => l_new_event_offer_id
1072: );
1073:
1074: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077: IF (AMS_DEBUG_HIGH_ON) THEN
1078:

Line 1075: RAISE FND_API.G_EXC_ERROR;

1071: x_evo_id => l_new_event_offer_id
1072: );
1073:
1074: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077: IF (AMS_DEBUG_HIGH_ON) THEN
1078:
1079: AMS_UTILITY_PVT.debug_message('the l_event_header_id: ' || l_event_offer_id||'\n');

Line 1088: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_AGEN , p_attributes_table) = FND_API.G_TRUE THEN

1084: END IF;
1085: -- copy agenda
1086:
1087: -- soagrawa 12-may-2003 uncommented for bug# 2949268 for 11.5.10
1088: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_AGEN , p_attributes_table) = FND_API.G_TRUE THEN
1089: copy_event_schedule_agenda (
1090: p_src_act_type => l_event_object_type,
1091: p_new_act_type => l_event_object_type,
1092: p_src_act_id => l_event_offer_id,

Line 1098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1094: p_errnum => l_errnum,
1095: p_errcode => l_errcode,
1096: p_errmsg => l_errmsg
1097: );
1098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;
1101: END IF;
1102:

Line 1099: RAISE FND_API.G_EXC_ERROR;

1095: p_errcode => l_errcode,
1096: p_errmsg => l_errmsg
1097: );
1098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;
1101: END IF;
1102:
1103: -- copy resources

Line 1105: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_RESC, p_attributes_table) = FND_API.G_TRUE THEN

1101: END IF;
1102:
1103: -- copy resources
1104: /*Commented by mukemar on may14 2002 we are not supporting the resource copy
1105: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_RESC, p_attributes_table) = FND_API.G_TRUE THEN
1106: AMS_CopyElements_PVT.copy_act_resources (
1107: p_src_act_type => l_event_object_type,
1108: p_new_act_type => l_event_object_type,
1109: p_src_act_id => l_event_offer_id,

Line 1118: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_CATG, p_attributes_table) = FND_API.G_TRUE THEN

1114: );
1115: END IF;
1116: */
1117: -- copy categories
1118: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_CATG, p_attributes_table) = FND_API.G_TRUE THEN
1119: -- batoleti Ref bug# 5213664
1120: -- get the object type from act_actegories based on the original evet_offer_id..
1121:
1122: l_ARC_ACT_CATEGORY_USED_BY := NULL;

Line 1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1143: p_errnum => l_errnum,
1144: p_errcode => l_errcode,
1145: p_errmsg => l_errmsg
1146: );
1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150: END IF;
1151: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144: p_errcode => l_errcode,
1145: p_errmsg => l_errmsg
1146: );
1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150: END IF;
1151: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN
1152: AMS_CopyElements_PVT.copy_act_prod (

Line 1151: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN

1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150: END IF;
1151: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_PROD, p_attributes_table) = FND_API.G_TRUE THEN
1152: AMS_CopyElements_PVT.copy_act_prod (
1153: p_src_act_type => l_event_object_type,
1154: p_new_act_type => l_event_object_type,
1155: p_src_act_id => l_event_offer_id,

Line 1161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1157: p_errnum => l_errnum,
1158: p_errcode => l_errcode,
1159: p_errmsg => l_errmsg
1160: );
1161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164: END IF;
1165: IF AMS_CpyUtility_PVT.is_copy_attribute (G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN

Line 1162: RAISE FND_API.G_EXC_ERROR;

1158: p_errcode => l_errcode,
1159: p_errmsg => l_errmsg
1160: );
1161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164: END IF;
1165: IF AMS_CpyUtility_PVT.is_copy_attribute (G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN
1166: AMS_CopyElements_PVT.copy_act_geo_areas (

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

1161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164: END IF;
1165: IF AMS_CpyUtility_PVT.is_copy_attribute (G_ATTRIBUTE_GEOS, p_attributes_table) = FND_API.G_TRUE THEN
1166: AMS_CopyElements_PVT.copy_act_geo_areas (
1167: p_src_act_type => l_event_object_type,
1168: p_new_act_type => l_event_object_type,
1169: p_src_act_id => l_event_offer_id,

Line 1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1171: p_errnum => l_errnum,
1172: p_errcode => l_errcode,
1173: p_errmsg => l_errmsg
1174: );
1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: END IF;
1179: IF AMS_CpyUtility_PVT.is_copy_attribute (G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN

Line 1176: RAISE FND_API.G_EXC_ERROR;

1172: p_errcode => l_errcode,
1173: p_errmsg => l_errmsg
1174: );
1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: END IF;
1179: IF AMS_CpyUtility_PVT.is_copy_attribute (G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN
1180: AMS_CopyElements_PVT.copy_act_market_segments (

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

1175: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: END IF;
1179: IF AMS_CpyUtility_PVT.is_copy_attribute (G_ATTRIBUTE_CELL, p_attributes_table) = FND_API.G_TRUE THEN
1180: AMS_CopyElements_PVT.copy_act_market_segments (
1181: p_src_act_type => l_event_object_type,
1182: p_new_act_type => l_event_object_type,
1183: p_src_act_id => l_event_offer_id,

Line 1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1185: p_errnum => l_errnum,
1186: p_errcode => l_errcode,
1187: p_errmsg => l_errmsg
1188: );
1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;
1192: END IF;
1193:

Line 1190: RAISE FND_API.G_EXC_ERROR;

1186: p_errcode => l_errcode,
1187: p_errmsg => l_errmsg
1188: );
1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;
1192: END IF;
1193:
1194: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_MESG, p_attributes_table) = FND_API.G_TRUE THEN

Line 1194: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_MESG, p_attributes_table) = FND_API.G_TRUE THEN

1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;
1192: END IF;
1193:
1194: IF AMS_CpyUtility_PVT.is_copy_attribute (AMS_EventSchedule_Copy_PVT.G_ATTRIBUTE_MESG, p_attributes_table) = FND_API.G_TRUE THEN
1195: AMS_CopyElements_PVT.copy_act_messages(
1196: p_src_act_type => l_event_object_type,
1197: p_new_act_type => l_event_object_type,
1198: p_src_act_id => l_event_offer_id,

Line 1204: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1200: p_errnum => l_errnum,
1201: p_errcode => l_errcode,
1202: p_errmsg => l_errmsg
1203: );
1204: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207: END IF;
1208: IF AMS_CpyUtility_PVT.is_copy_attribute(AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_DELV, p_attributes_table) = FND_API.G_TRUE THEN

Line 1205: RAISE FND_API.G_EXC_ERROR;

1201: p_errcode => l_errcode,
1202: p_errmsg => l_errmsg
1203: );
1204: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207: END IF;
1208: IF AMS_CpyUtility_PVT.is_copy_attribute(AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_DELV, p_attributes_table) = FND_API.G_TRUE THEN
1209: copy_act_delivery_method(

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

1204: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207: END IF;
1208: IF AMS_CpyUtility_PVT.is_copy_attribute(AMS_Event_Objects_Copy_PVT.G_ATTRIBUTE_DELV, p_attributes_table) = FND_API.G_TRUE THEN
1209: copy_act_delivery_method(
1210: p_src_act_type => l_event_object_type,
1211: p_new_act_type => l_event_object_type,
1212: p_src_act_id => l_event_offer_id,

Line 1222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1218:
1219:
1220:
1221:
1222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225: END IF;
1226: p_event_offer_rec.event_offer_id:=l_new_event_offer_id;

Line 1223: RAISE FND_API.G_EXC_ERROR;

1219:
1220:
1221:
1222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225: END IF;
1226: p_event_offer_rec.event_offer_id:=l_new_event_offer_id;
1227: AMS_EVENTOFFER_PVT.complete_evo_rec(p_event_offer_rec,l_new_reference_rec);

Line 1233: IF FND_API.to_Boolean( p_commit )

1229: x_new_object_id:= l_new_event_offer_id;
1230: x_custom_setup_id:= l_new_reference_rec.custom_setup_id;
1231:
1232:
1233: IF FND_API.to_Boolean( p_commit )
1234: THEN
1235: COMMIT WORK;
1236: END IF;
1237:

Line 1252: WHEN FND_API.G_EXC_ERROR THEN

1248: );
1249:
1250:
1251: EXCEPTION
1252: WHEN FND_API.G_EXC_ERROR THEN
1253: ROLLBACK TO copy_event_schedule;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: -- Standard call to get message count and if count=1, get the message
1256: FND_MSG_PUB.Count_And_Get (

Line 1254: x_return_status := FND_API.G_RET_STS_ERROR;

1250:
1251: EXCEPTION
1252: WHEN FND_API.G_EXC_ERROR THEN
1253: ROLLBACK TO copy_event_schedule;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: -- Standard call to get message count and if count=1, get the message
1256: FND_MSG_PUB.Count_And_Get (
1257: p_encoded => FND_API.G_FALSE,
1258: p_count => x_msg_count,

Line 1257: p_encoded => FND_API.G_FALSE,

1253: ROLLBACK TO copy_event_schedule;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: -- Standard call to get message count and if count=1, get the message
1256: FND_MSG_PUB.Count_And_Get (
1257: p_encoded => FND_API.G_FALSE,
1258: p_count => x_msg_count,
1259: p_data => x_msg_data
1260: );
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1257: p_encoded => FND_API.G_FALSE,
1258: p_count => x_msg_count,
1259: p_data => x_msg_data
1260: );
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: ROLLBACK TO copy_event_schedule;
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (

Line 1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1259: p_data => x_msg_data
1260: );
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: ROLLBACK TO copy_event_schedule;
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,

Line 1266: p_encoded => FND_API.G_FALSE,

1262: ROLLBACK TO copy_event_schedule;
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,
1268: p_data => x_msg_data
1269: );
1270: WHEN OTHERS THEN

Line 1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1268: p_data => x_msg_data
1269: );
1270: WHEN OTHERS THEN
1271: ROLLBACK TO copy_event_schedule;
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1275: END IF;
1276: -- Standard call to get message count and if count=1, get the message

Line 1278: p_encoded => FND_API.G_FALSE,

1274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1275: END IF;
1276: -- Standard call to get message count and if count=1, get the message
1277: FND_MSG_PUB.Count_And_Get (
1278: p_encoded => FND_API.G_FALSE,
1279: p_count => x_msg_count,
1280: p_data => x_msg_data
1281: );
1282: