DBA Data[Home] [Help]

APPS.AMS_EVENT_OBJECTS_COPY_PVT dependencies on AMS_UTILITY_PVT

Line 144: AMS_UTILITY_PVT.debug_message('CG: the new_event_dates = ' || l_event_new_start_date || ' ' || l_event_new_end_date);

140: FETCH new_event_dates INTO l_event_new_start_date, l_event_new_end_date;
141: CLOSE new_event_dates;
142:
143: IF (AMS_DEBUG_HIGH_ON) THEN
144: AMS_UTILITY_PVT.debug_message('CG: the new_event_dates = ' || l_event_new_start_date || ' ' || l_event_new_end_date);
145: END IF;
146:
147:
148: l_copy_columns_table(1).column_name := 'EVENT_HEADER_ID';

Line 158: ams_utility_pvt.get_lookup_meaning ('AMS_SYS_ARC_QUALIFIER',

154:
155: p_errcode := NULL;
156: p_errnum := 0;
157: p_errmsg := NULL;
158: ams_utility_pvt.get_lookup_meaning ('AMS_SYS_ARC_QUALIFIER',
159: 'EVEO',
160: l_return_status,
161: l_lookup_meaning
162: );

Line 304: AMS_UTILITY_PVT.debug_message('the deliverable copying: ');

300: l_stmt_num := 1;
301: IF p_src_act_id IS NOT NULL THEN
302: IF (AMS_DEBUG_HIGH_ON) THEN
303:
304: AMS_UTILITY_PVT.debug_message('the deliverable copying: ');
305: END IF;
306: IF (AMS_DEBUG_HIGH_ON) THEN
307:
308: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');

Line 308: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');

304: AMS_UTILITY_PVT.debug_message('the deliverable copying: ');
305: END IF;
306: IF (AMS_DEBUG_HIGH_ON) THEN
307:
308: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
309: END IF;
310: IF (AMS_DEBUG_HIGH_ON) THEN
311:
312: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

Line 312: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

308: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
309: END IF;
310: IF (AMS_DEBUG_HIGH_ON) THEN
311:
312: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');
313: END IF;
314: END IF;
315: FOR deliverable_rec IN deliverable_cur
316: LOOP

Line 515: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

511: BEGIN
512: p_errcode := NULL;
513: p_errnum := 0;
514: p_errmsg := NULL;
515: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
516: 'AGEN',
517: l_return_status,
518: l_lookup_meaning
519: );

Line 533: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');

529: -- copy agenda
530: IF p_src_act_id IS NOT NULL THEN
531: IF (AMS_DEBUG_HIGH_ON) THEN
532:
533: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
534: END IF;
535: IF (AMS_DEBUG_HIGH_ON) THEN
536:
537: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

Line 537: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

533: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
534: END IF;
535: IF (AMS_DEBUG_HIGH_ON) THEN
536:
537: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');
538: END IF;
539: END IF;
540: FOR agenda_rec IN agenda_cur
541: LOOP

Line 579: AMS_UTILITY_PVT.debug_message('the p_act_agenda_id: ' || l_act_agenda_id||'\n');

575: IF (AMS_DEBUG_HIGH_ON) THEN
576:
577:
578:
579: AMS_UTILITY_PVT.debug_message('the p_act_agenda_id: ' || l_act_agenda_id||'\n');
580:
581: END IF;
582:
583:

Line 734: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

730:
731: -- Debug Message
732: IF (AMS_DEBUG_HIGH_ON) THEN
733:
734: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
735: END IF;
736: IF (AMS_DEBUG_HIGH_ON) THEN
737:
738: AMS_UTILITY_PVT.debug_message('the source object id: ' || p_source_object_id||'\n');

Line 738: AMS_UTILITY_PVT.debug_message('the source object id: ' || p_source_object_id||'\n');

734: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
735: END IF;
736: IF (AMS_DEBUG_HIGH_ON) THEN
737:
738: AMS_UTILITY_PVT.debug_message('the source object id: ' || p_source_object_id||'\n');
739: END IF;
740: IF (AMS_DEBUG_HIGH_ON) THEN
741:
742: AMS_UTILITY_PVT.debug_message('the new source object id: ' || x_new_object_id||'\n');

Line 742: AMS_UTILITY_PVT.debug_message('the new source object id: ' || x_new_object_id||'\n');

738: AMS_UTILITY_PVT.debug_message('the source object id: ' || p_source_object_id||'\n');
739: END IF;
740: IF (AMS_DEBUG_HIGH_ON) THEN
741:
742: AMS_UTILITY_PVT.debug_message('the new source object id: ' || x_new_object_id||'\n');
743: END IF;
744: IF (AMS_DEBUG_HIGH_ON) THEN
745:
746: AMS_UTILITY_PVT.debug_message('the source custom setup id: ' || x_custom_setup_id||'\n');

Line 746: AMS_UTILITY_PVT.debug_message('the source custom setup id: ' || x_custom_setup_id||'\n');

742: AMS_UTILITY_PVT.debug_message('the new source object id: ' || x_new_object_id||'\n');
743: END IF;
744: IF (AMS_DEBUG_HIGH_ON) THEN
745:
746: AMS_UTILITY_PVT.debug_message('the source custom setup id: ' || x_custom_setup_id||'\n');
747: END IF;
748: FOR i IN 1..p_copy_columns_table.COUNT LOOP
749: IF (AMS_DEBUG_HIGH_ON) THEN
750:

Line 751: AMS_UTILITY_PVT.debug_message('the'||i||'copy column name: '|| p_copy_columns_table(i).column_name||'\n');

747: END IF;
748: FOR i IN 1..p_copy_columns_table.COUNT LOOP
749: IF (AMS_DEBUG_HIGH_ON) THEN
750:
751: AMS_UTILITY_PVT.debug_message('the'||i||'copy column name: '|| p_copy_columns_table(i).column_name||'\n');
752: END IF;
753: IF (AMS_DEBUG_HIGH_ON) THEN
754:
755: AMS_UTILITY_PVT.debug_message('the'||i||'copy column value: '|| p_copy_columns_table(i).column_value||'\n');

Line 755: AMS_UTILITY_PVT.debug_message('the'||i||'copy column value: '|| p_copy_columns_table(i).column_value||'\n');

751: AMS_UTILITY_PVT.debug_message('the'||i||'copy column name: '|| p_copy_columns_table(i).column_name||'\n');
752: END IF;
753: IF (AMS_DEBUG_HIGH_ON) THEN
754:
755: AMS_UTILITY_PVT.debug_message('the'||i||'copy column value: '|| p_copy_columns_table(i).column_value||'\n');
756: END IF;
757:
758: END LOOP;
759:

Line 763: AMS_UTILITY_PVT.debug_message('the'||i||'attibute: '||p_attributes_table(i));

759:
760: FOR i IN 1..p_attributes_table.COUNT LOOP
761: IF (AMS_DEBUG_HIGH_ON) THEN
762:
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;

Line 808: AMS_UTILITY_PVT.debug_message('the l_event_header_rec.source_code: '||l_event_header_rec.source_code);

804: AMS_CpyUtility_PVT.get_column_value('newSrcCode', p_copy_columns_table, l_event_header_rec.source_code);
805: l_event_header_rec.source_code:= NVL(l_event_header_rec.source_code, NULL);
806: IF (AMS_DEBUG_HIGH_ON) THEN
807:
808: AMS_UTILITY_PVT.debug_message('the l_event_header_rec.source_code: '||l_event_header_rec.source_code);
809: END IF;
810: AMS_CpyUtility_PVT.get_column_value('countryId', p_copy_columns_table, l_event_header_rec.country_code);
811: l_event_header_rec.country_code:= NVL( l_event_header_rec.country_code, l_reference_rec.country_code);
812: AMS_CpyUtility_PVT.get_column_value('programId', p_copy_columns_table, l_event_header_rec.program_id);

Line 856: AMS_UTILITY_PVT.debug_message('HeaderId: ' || l_event_header_rec.event_header_id || 'start\n');

852: -- ----------------------------
853: -- call create api
854: IF (AMS_DEBUG_HIGH_ON) THEN
855:
856: AMS_UTILITY_PVT.debug_message('HeaderId: ' || l_event_header_rec.event_header_id || 'start\n');
857: END IF;
858:
859: AMS_EventHeader_PVT.create_event_header (
860: p_api_version => 1.0,

Line 881: AMS_UTILITY_PVT.debug_message('the l_event_header_id: ' || l_event_header_id||'\n');

877: IF (AMS_DEBUG_HIGH_ON) THEN
878:
879:
880:
881: AMS_UTILITY_PVT.debug_message('the l_event_header_id: ' || l_event_header_id||'\n');
882:
883: END IF;
884:
885: IF (AMS_DEBUG_HIGH_ON) THEN

Line 887: AMS_UTILITY_PVT.debug_message('the l_new_event_header_id: ' || l_new_event_header_id||'\n');

883: END IF;
884:
885: IF (AMS_DEBUG_HIGH_ON) THEN
886:
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

Line 1035: AMS_UTILITY_PVT.debug_message('Getting scheduleid values');

1031:
1032: -- Get the Schedule Ids as comma separated variables.
1033: IF (AMS_DEBUG_HIGH_ON) THEN
1034:
1035: AMS_UTILITY_PVT.debug_message('Getting scheduleid values');
1036: END IF;
1037:
1038: AMS_CpyUtility_PVT.get_column_value ('eventScheduleIdRec', p_copy_columns_table, x_event_schedule_ids);
1039: l_event_schedule_ids := NVL (x_event_schedule_ids, '');

Line 1042: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The Initial Vlues:' || p_copy_columns_table(i).column_name); END IF;

1038: AMS_CpyUtility_PVT.get_column_value ('eventScheduleIdRec', p_copy_columns_table, x_event_schedule_ids);
1039: l_event_schedule_ids := NVL (x_event_schedule_ids, '');
1040:
1041: FOR i IN 1..p_copy_columns_table.COUNT LOOP
1042: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The Initial Vlues:' || p_copy_columns_table(i).column_name); END IF;
1043: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The Initial Vlues:' || p_copy_columns_table(i).column_value); END IF;
1044: IF (p_copy_columns_table(i).column_name = 'eventScheduleIdRec'
1045: AND p_copy_columns_table(i).column_value = 'undefined' )THEN
1046: l_copy_sched_cont_flag := 'N';

Line 1043: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The Initial Vlues:' || p_copy_columns_table(i).column_value); END IF;

1039: l_event_schedule_ids := NVL (x_event_schedule_ids, '');
1040:
1041: FOR i IN 1..p_copy_columns_table.COUNT LOOP
1042: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The Initial Vlues:' || p_copy_columns_table(i).column_name); END IF;
1043: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The Initial Vlues:' || p_copy_columns_table(i).column_value); END IF;
1044: IF (p_copy_columns_table(i).column_name = 'eventScheduleIdRec'
1045: AND p_copy_columns_table(i).column_value = 'undefined' )THEN
1046: l_copy_sched_cont_flag := 'N';
1047: END IF;

Line 1055: AMS_UTILITY_PVT.debug_message('eventScheduleId Rec:' || l_event_schedule_ids);

1051: IF (AMS_DEBUG_HIGH_ON) THEN
1052:
1053:
1054:
1055: AMS_UTILITY_PVT.debug_message('eventScheduleId Rec:' || l_event_schedule_ids);
1056:
1057: END IF;
1058:
1059: WHILE (l_copy_sched_cont_flag <> 'N') LOOP

Line 1077: AMS_UTILITY_PVT.debug_message('calling event schedule copy for event_schedule id:' || l_tmp_event_schedule_id);

1073:
1074: IF l_tmp_event_schedule_id IS NOT NULL THEN
1075: IF (AMS_DEBUG_HIGH_ON) THEN
1076:
1077: AMS_UTILITY_PVT.debug_message('calling event schedule copy for event_schedule id:' || l_tmp_event_schedule_id);
1078: END IF;
1079:
1080: copy_act_offers(
1081: p_src_act_type => G_OBJECT_TYPE_MODEL,

Line 1115: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1111:
1112: -- Debug Message
1113: IF (AMS_DEBUG_HIGH_ON) THEN
1114:
1115: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1116: END IF;
1117:
1118: -- Standard call to get message count and if count is 1, get message info.
1119: FND_MSG_PUB.Count_And_Get