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_EVENTSCHEDULE_COPY_PVT dependencies on AMS_CPYUTILITY_PVT

Line 177: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

173: p_errnum := 1;
174: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
175: ' , ' || '): ' || l_counter ||
176: ' OF ' || x_msg_count, 1, 4000);
177: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
178: p_src_act_id,
179: p_errmsg,
180: 'ERROR'
181: );

Line 201: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

197: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
198: l_mesg_text := fnd_message.get;
199: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
200: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
201: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
202: p_src_act_id,
203: p_errmsg,
204: 'ERROR'
205: );

Line 384: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

380: );
381: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
382: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
383: l_mesg_text := fnd_message.get;
384: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
385: p_src_act_id,
386: l_mesg_text,
387: 'GENERAL'
388: );

Line 458: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

454: p_errnum := 1;
455: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
456: ' , ' || '): ' || l_counter ||
457: ' OF ' || x_msg_count, 1, 4000);
458: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
459: p_src_act_id,
460: p_errmsg,
461: 'ERROR'
462: );

Line 472: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

468: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
469: AMS_EventSchedule_Copy_PVT.get_agenda_name (
470: agenda_rec.parent_event_offer_id
471: ), 1, 4000);
472: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
473: p_src_act_id,
474: p_errmsg,
475: 'ERROR'
476: );

Line 497: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

493: p_errmsg := SUBSTR ( l_mesg_text ||
494: AMS_EventSchedule_Copy_PVT.get_agenda_name (
495: agenda_rec.parent_event_offer_id
496: ) || p_errmsg, 1, 4000);
497: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
498: p_src_act_id,
499: p_errmsg,
500: 'ERROR'
501: );

Line 517: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

513: l_mesg_text := fnd_message.get;
514: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
515: ',' || '): ' || p_errcode || SQLERRM,
516: 1, 4000);
517: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
518: p_src_act_id,
519: p_errmsg,
520: 'ERROR'
521: );

Line 597: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

593: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
594: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
595:
596: l_mesg_text := fnd_message.get;
597: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
598: p_src_act_id,
599: l_mesg_text,
600: 'GENERAL'
601: );

Line 672: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

668: p_errnum := 1;
669: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
670: ' , ' || '): ' || l_counter ||
671: ' OF ' || x_msg_count, 1, 4000);
672: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
673: p_src_act_id,
674: p_errmsg,
675: 'ERROR'
676: );

Line 687: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

683: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
684: AMS_EventSchedule_Copy_PVT.get_agenda_name (
685: l_track_cur.agenda_id
686: ), 1, 4000);
687: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
688: p_src_act_id,
689: p_errmsg,
690: 'ERROR'
691: );

Line 755: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

751: p_errnum := 1;
752: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
753: ' , ' || '): ' || l_counter ||
754: ' OF ' || x_msg_count, 1, 4000);
755: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
756: p_src_act_id,
757: p_errmsg,
758: 'ERROR'
759: );

Line 770: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

766: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
767: AMS_EventSchedule_Copy_PVT.get_agenda_name (
768: l_session_cur.agenda_id
769: ), 1, 4000);
770: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
771: p_src_act_id,
772: p_errmsg,
773: 'ERROR'
774: );

Line 799: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

795: p_errmsg := SUBSTR ( l_mesg_text ||
796: AMS_EventSchedule_Copy_PVT.get_agenda_name (
797: l_new_track_cur.agenda_id
798: ) || p_errmsg, 1, 4000);
799: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
800: p_src_act_id,
801: p_errmsg,
802: 'ERROR'
803: );

Line 819: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

815: l_mesg_text := fnd_message.get;
816: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
817: ',' || '): ' || p_errcode || SQLERRM,
818: 1, 4000);
819: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
820: p_src_act_id,
821: p_errmsg,
822: 'ERROR'
823: );

Line 839: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2,
837:
838: p_source_object_id IN NUMBER,
839: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
840: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
841:
842: x_new_object_id OUT NOCOPY NUMBER,
843: x_custom_setup_id OUT NOCOPY NUMBER

Line 840: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

836: x_msg_data OUT NOCOPY VARCHAR2,
837:
838: p_source_object_id IN NUMBER,
839: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
840: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
841:
842: x_new_object_id OUT NOCOPY NUMBER,
843: x_custom_setup_id OUT NOCOPY NUMBER
844: )

Line 970: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_event_offer_rec.EVENT_START_DATE);

966: FETCH c_event_times INTO l_start_date, l_end_date;
967: CLOSE c_event_times;
968:
969:
970: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_event_offer_rec.EVENT_START_DATE);
971: l_event_offer_rec.EVENT_START_DATE:= NVL (l_event_offer_rec.EVENT_START_DATE,l_reference_rec.EVENT_START_DATE);
972: AMS_CpyUtility_PVT.get_column_value ('endDate', p_copy_columns_table, l_event_offer_rec.EVENT_END_DATE);
973: l_event_offer_rec.EVENT_END_DATE:= NVL ( l_event_offer_rec.EVENT_END_DATE, l_reference_rec.EVENT_END_DATE);
974:

Line 972: AMS_CpyUtility_PVT.get_column_value ('endDate', p_copy_columns_table, l_event_offer_rec.EVENT_END_DATE);

968:
969:
970: AMS_CpyUtility_PVT.get_column_value ('startDate', p_copy_columns_table, l_event_offer_rec.EVENT_START_DATE);
971: l_event_offer_rec.EVENT_START_DATE:= NVL (l_event_offer_rec.EVENT_START_DATE,l_reference_rec.EVENT_START_DATE);
972: AMS_CpyUtility_PVT.get_column_value ('endDate', p_copy_columns_table, l_event_offer_rec.EVENT_END_DATE);
973: l_event_offer_rec.EVENT_END_DATE:= NVL ( l_event_offer_rec.EVENT_END_DATE, l_reference_rec.EVENT_END_DATE);
974:
975: IF(l_start_date = l_event_offer_rec.EVENT_START_DATE)
976: THEN

Line 977: AMS_CpyUtility_PVT.get_column_value ('startTime', p_copy_columns_table, l_event_offer_rec.EVENT_START_DATE_TIME);

973: l_event_offer_rec.EVENT_END_DATE:= NVL ( l_event_offer_rec.EVENT_END_DATE, l_reference_rec.EVENT_END_DATE);
974:
975: IF(l_start_date = l_event_offer_rec.EVENT_START_DATE)
976: THEN
977: AMS_CpyUtility_PVT.get_column_value ('startTime', p_copy_columns_table, l_event_offer_rec.EVENT_START_DATE_TIME);
978: l_event_offer_rec.EVENT_START_DATE_TIME:= NVL (l_event_offer_rec.EVENT_START_DATE_TIME,l_reference_rec.EVENT_START_DATE_TIME);
979: ELSE
980: l_event_offer_rec.EVENT_START_DATE_TIME:=NULL;
981: END IF;

Line 985: AMS_CpyUtility_PVT.get_column_value ('endTime', p_copy_columns_table, l_event_offer_rec.EVENT_END_DATE_TIME);

981: END IF;
982:
983: IF(l_end_date = l_event_offer_rec.EVENT_END_DATE)
984: THEN
985: AMS_CpyUtility_PVT.get_column_value ('endTime', p_copy_columns_table, l_event_offer_rec.EVENT_END_DATE_TIME);
986: l_event_offer_rec.EVENT_END_DATE_TIME:= NVL ( l_event_offer_rec.EVENT_END_DATE_TIME, l_reference_rec.EVENT_END_DATE_TIME);
987: ELSE
988: l_event_offer_rec.EVENT_END_DATE_TIME:=NULL;
989: END IF;

Line 991: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_event_offer_rec.event_offer_name);

987: ELSE
988: l_event_offer_rec.EVENT_END_DATE_TIME:=NULL;
989: END IF;
990:
991: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_event_offer_rec.event_offer_name);
992: l_event_offer_rec.event_offer_name:= NVL ( l_event_offer_rec.event_offer_name, l_reference_rec.event_offer_name);
993: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_event_offer_rec.owner_user_id);
994: l_event_offer_rec.owner_user_id:= NVL (l_event_offer_rec.owner_user_id, l_reference_rec.owner_user_id);
995: AMS_CpyUtility_PVT.get_column_value ('newSrcCode', p_copy_columns_table, l_event_offer_rec.source_code);

Line 993: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_event_offer_rec.owner_user_id);

989: END IF;
990:
991: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_event_offer_rec.event_offer_name);
992: l_event_offer_rec.event_offer_name:= NVL ( l_event_offer_rec.event_offer_name, l_reference_rec.event_offer_name);
993: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_event_offer_rec.owner_user_id);
994: l_event_offer_rec.owner_user_id:= NVL (l_event_offer_rec.owner_user_id, l_reference_rec.owner_user_id);
995: AMS_CpyUtility_PVT.get_column_value ('newSrcCode', p_copy_columns_table, l_event_offer_rec.source_code);
996: l_event_offer_rec.source_code:= NVL (l_event_offer_rec.source_code, NULL);
997: AMS_CpyUtility_PVT.get_column_value ('countryId', p_copy_columns_table, l_event_offer_rec.country_code);

Line 995: AMS_CpyUtility_PVT.get_column_value ('newSrcCode', p_copy_columns_table, l_event_offer_rec.source_code);

991: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_event_offer_rec.event_offer_name);
992: l_event_offer_rec.event_offer_name:= NVL ( l_event_offer_rec.event_offer_name, l_reference_rec.event_offer_name);
993: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_event_offer_rec.owner_user_id);
994: l_event_offer_rec.owner_user_id:= NVL (l_event_offer_rec.owner_user_id, l_reference_rec.owner_user_id);
995: AMS_CpyUtility_PVT.get_column_value ('newSrcCode', p_copy_columns_table, l_event_offer_rec.source_code);
996: l_event_offer_rec.source_code:= NVL (l_event_offer_rec.source_code, NULL);
997: AMS_CpyUtility_PVT.get_column_value ('countryId', p_copy_columns_table, l_event_offer_rec.country_code);
998: l_event_offer_rec.country_code:= NVL (l_event_offer_rec.country_code, l_reference_rec.country_code);
999: AMS_CpyUtility_PVT.get_column_value ('langCode', p_copy_columns_table, l_reference_rec.event_language_code);

Line 997: AMS_CpyUtility_PVT.get_column_value ('countryId', p_copy_columns_table, l_event_offer_rec.country_code);

993: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_event_offer_rec.owner_user_id);
994: l_event_offer_rec.owner_user_id:= NVL (l_event_offer_rec.owner_user_id, l_reference_rec.owner_user_id);
995: AMS_CpyUtility_PVT.get_column_value ('newSrcCode', p_copy_columns_table, l_event_offer_rec.source_code);
996: l_event_offer_rec.source_code:= NVL (l_event_offer_rec.source_code, NULL);
997: AMS_CpyUtility_PVT.get_column_value ('countryId', p_copy_columns_table, l_event_offer_rec.country_code);
998: l_event_offer_rec.country_code:= NVL (l_event_offer_rec.country_code, l_reference_rec.country_code);
999: AMS_CpyUtility_PVT.get_column_value ('langCode', p_copy_columns_table, l_reference_rec.event_language_code);
1000: l_event_offer_rec.event_language_code:= NVL (l_event_offer_rec.event_language_code, l_reference_rec.event_language_code);
1001: AMS_CpyUtility_PVT.get_column_value ('currency', p_copy_columns_table, l_reference_rec.currency_code_tc);

Line 999: AMS_CpyUtility_PVT.get_column_value ('langCode', p_copy_columns_table, l_reference_rec.event_language_code);

995: AMS_CpyUtility_PVT.get_column_value ('newSrcCode', p_copy_columns_table, l_event_offer_rec.source_code);
996: l_event_offer_rec.source_code:= NVL (l_event_offer_rec.source_code, NULL);
997: AMS_CpyUtility_PVT.get_column_value ('countryId', p_copy_columns_table, l_event_offer_rec.country_code);
998: l_event_offer_rec.country_code:= NVL (l_event_offer_rec.country_code, l_reference_rec.country_code);
999: AMS_CpyUtility_PVT.get_column_value ('langCode', p_copy_columns_table, l_reference_rec.event_language_code);
1000: l_event_offer_rec.event_language_code:= NVL (l_event_offer_rec.event_language_code, l_reference_rec.event_language_code);
1001: AMS_CpyUtility_PVT.get_column_value ('currency', p_copy_columns_table, l_reference_rec.currency_code_tc);
1002: l_event_offer_rec.currency_code_tc:= NVL (l_event_offer_rec.currency_code_tc, l_reference_rec.currency_code_tc);
1003:

Line 1001: AMS_CpyUtility_PVT.get_column_value ('currency', p_copy_columns_table, l_reference_rec.currency_code_tc);

997: AMS_CpyUtility_PVT.get_column_value ('countryId', p_copy_columns_table, l_event_offer_rec.country_code);
998: l_event_offer_rec.country_code:= NVL (l_event_offer_rec.country_code, l_reference_rec.country_code);
999: AMS_CpyUtility_PVT.get_column_value ('langCode', p_copy_columns_table, l_reference_rec.event_language_code);
1000: l_event_offer_rec.event_language_code:= NVL (l_event_offer_rec.event_language_code, l_reference_rec.event_language_code);
1001: AMS_CpyUtility_PVT.get_column_value ('currency', p_copy_columns_table, l_reference_rec.currency_code_tc);
1002: l_event_offer_rec.currency_code_tc:= NVL (l_event_offer_rec.currency_code_tc, l_reference_rec.currency_code_tc);
1003:
1004: -- -------------------------------------------
1005: -- fields not to be copied

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 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 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 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 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 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 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,