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_ADI_CAMP_SCHED_PVT dependencies on AMS_UTILITY_PVT

Line 158: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start with batch id : '||p_upload_batch_id||' ui instance id : '||p_ui_instance_id);

154: FND_MSG_PUB.initialize;
155:
156: -- Debug Message
157: IF (AMS_DEBUG_HIGH_ON) THEN
158: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start with batch id : '||p_upload_batch_id||' ui instance id : '||p_ui_instance_id);
159: END IF;
160:
161:
162: -- Initialize API return status to SUCCESS

Line 176: AMS_UTILITY_PVT.debug_message('Start to read feom ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);

172: AMS_ADI_COMMON_PVT.init();
173:
174: -- Debug Message
175: IF (AMS_DEBUG_HIGH_ON) THEN
176: AMS_UTILITY_PVT.debug_message('Start to read feom ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);
177: END IF;
178:
179: open c(p_upload_batch_id);
180:

Line 196: AMS_UTILITY_PVT.debug_message('done with fetch');

192:
193:
194: -- Debug Message
195: IF (AMS_DEBUG_HIGH_ON) THEN
196: AMS_UTILITY_PVT.debug_message('done with fetch');
197: END IF;
198:
199: -- Debug Message
200: IF (AMS_DEBUG_HIGH_ON) THEN

Line 201: AMS_UTILITY_PVT.debug_message('calling init_for_batch');

197: END IF;
198:
199: -- Debug Message
200: IF (AMS_DEBUG_HIGH_ON) THEN
201: AMS_UTILITY_PVT.debug_message('calling init_for_batch');
202: END IF;
203:
204: AMS_ADI_COMMON_PVT.init_for_batch(l_error_recs); --initialize batch operation
205:

Line 208: AMS_UTILITY_PVT.debug_message('Done init_for_batch with loopsize '||l_objectIds.COUNT);

204: AMS_ADI_COMMON_PVT.init_for_batch(l_error_recs); --initialize batch operation
205:
206: -- Debug Message
207: IF (AMS_DEBUG_HIGH_ON) THEN
208: AMS_UTILITY_PVT.debug_message('Done init_for_batch with loopsize '||l_objectIds.COUNT);
209: END IF;
210:
211: FOR i in l_objectIds.FIRST .. l_objectIds.LAST LOOP
212:

Line 216: AMS_UTILITY_PVT.debug_message('inside loop');

212:
213: SAVEPOINT EXPORT_SCHEDULE;
214:
215: IF (AMS_DEBUG_HIGH_ON) THEN
216: AMS_UTILITY_PVT.debug_message('inside loop');
217: END IF;
218:
219: --create a Schedule record object for calling Scheule Public API
220:

Line 257: AMS_UTILITY_PVT.debug_message('next status id : '||TO_CHAR(l_schedule_rec.user_status_id));

253: IF(l_nextStatusIds(i) IS NOT NULL) THEN
254: l_schedule_rec.user_status_id := l_nextStatusIds(i);
255: l_schedule_rec.status_code := l_nextStatusCodes(i);
256: IF (AMS_DEBUG_HIGH_ON) THEN
257: AMS_UTILITY_PVT.debug_message('next status id : '||TO_CHAR(l_schedule_rec.user_status_id));
258: AMS_UTILITY_PVT.debug_message('next status code : '||l_schedule_rec.status_code);
259: END IF;
260: END IF;
261:

Line 258: AMS_UTILITY_PVT.debug_message('next status code : '||l_schedule_rec.status_code);

254: l_schedule_rec.user_status_id := l_nextStatusIds(i);
255: l_schedule_rec.status_code := l_nextStatusCodes(i);
256: IF (AMS_DEBUG_HIGH_ON) THEN
257: AMS_UTILITY_PVT.debug_message('next status id : '||TO_CHAR(l_schedule_rec.user_status_id));
258: AMS_UTILITY_PVT.debug_message('next status code : '||l_schedule_rec.status_code);
259: END IF;
260: END IF;
261:
262: l_schedule_rec.object_version_number := l_objVersionNos (i);

Line 302: AMS_UTILITY_PVT.debug_message('Calling AMS_Camp_Schedule_PUB.Update_Camp_Schedule');

298: l_schedule_rec.activity_attribute15 := l_actAttribute15s(i);
299:
300: -- Debug Message
301: IF (AMS_DEBUG_HIGH_ON) THEN
302: AMS_UTILITY_PVT.debug_message('Calling AMS_Camp_Schedule_PUB.Update_Camp_Schedule');
303: END IF;
304:
305: AMS_Camp_Schedule_PUB.Update_Camp_Schedule(
306: 1.0,

Line 319: AMS_UTILITY_PVT.debug_message('Return Status from Update_Camp_Schedule '||l_return_status);

315: );
316:
317: -- Debug Message
318: IF (AMS_DEBUG_HIGH_ON) THEN
319: AMS_UTILITY_PVT.debug_message('Return Status from Update_Camp_Schedule '||l_return_status);
320: END IF;
321:
322: -- Approvals Integration Starts here
323: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 326: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Schedule Update before Approval was successful '||TO_CHAR(l_objectIds(i)));

322: -- Approvals Integration Starts here
323: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
324: IF (l_apprActionCodes(i) = 'COMPLETE') THEN
325: IF (AMS_DEBUG_HIGH_ON) THEN
326: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Schedule Update before Approval was successful '||TO_CHAR(l_objectIds(i)));
327: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now proceeding with Approval');
328: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now calling AMS_ScheduleRules_PVT.Update_Schedule_Status');
329: END IF;
330:

Line 327: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now proceeding with Approval');

323: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
324: IF (l_apprActionCodes(i) = 'COMPLETE') THEN
325: IF (AMS_DEBUG_HIGH_ON) THEN
326: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Schedule Update before Approval was successful '||TO_CHAR(l_objectIds(i)));
327: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now proceeding with Approval');
328: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now calling AMS_ScheduleRules_PVT.Update_Schedule_Status');
329: END IF;
330:
331: BEGIN

Line 328: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now calling AMS_ScheduleRules_PVT.Update_Schedule_Status');

324: IF (l_apprActionCodes(i) = 'COMPLETE') THEN
325: IF (AMS_DEBUG_HIGH_ON) THEN
326: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Schedule Update before Approval was successful '||TO_CHAR(l_objectIds(i)));
327: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now proceeding with Approval');
328: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now calling AMS_ScheduleRules_PVT.Update_Schedule_Status');
329: END IF;
330:
331: BEGIN
332: AMS_ScheduleRules_PVT.Update_Schedule_Status( p_schedule_id => l_objectIds(i),

Line 334: p_user_status_id => AMS_UTILITY_PVT.get_default_user_status

330:
331: BEGIN
332: AMS_ScheduleRules_PVT.Update_Schedule_Status( p_schedule_id => l_objectIds(i),
333: p_campaign_id => l_parentIds(i),
334: p_user_status_id => AMS_UTILITY_PVT.get_default_user_status
335: (p_status_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS',
336: p_status_code => 'AVAILABLE'),
337: p_budget_amount => null
338: );

Line 345: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

341: l_return_status := FND_API.G_RET_STS_ERROR;
342: END;
343:
344: IF (AMS_DEBUG_HIGH_ON) THEN
345: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
346: ' Return Status from AMS_ScheduleRules_PVT.Update_Schedule_Status API '||l_return_status);
347: END IF;
348: END IF;
349: END IF;

Line 377: AMS_UTILITY_PVT.debug_message('Calling Complete batch');

373: FND_MSG_PUB.initialize; --initializes message table
374:
375: -- Debug Message
376: IF (AMS_DEBUG_HIGH_ON) THEN
377: AMS_UTILITY_PVT.debug_message('Calling Complete batch');
378: END IF;
379:
380: AMS_ADI_COMMON_PVT.complete_batch(
381: 'AMS_ADI_CAMPAIGNS_INTERFACE',

Line 396: AMS_UTILITY_PVT.debug_message('Calling Complete all');

392: close c;
393:
394: -- Debug Message
395: IF (AMS_DEBUG_HIGH_ON) THEN
396: AMS_UTILITY_PVT.debug_message('Calling Complete all');
397: END IF;
398:
399: AMS_ADI_COMMON_PVT.complete_all(FND_API.G_TRUE,FND_API.G_TRUE,p_upload_batch_id); --commit everything here only!
400:

Line 403: AMS_UTILITY_PVT.debug_message('Done with all');

399: AMS_ADI_COMMON_PVT.complete_all(FND_API.G_TRUE,FND_API.G_TRUE,p_upload_batch_id); --commit everything here only!
400:
401: -- Debug Message
402: IF (AMS_DEBUG_HIGH_ON) THEN
403: AMS_UTILITY_PVT.debug_message('Done with all');
404: END IF;
405:
406: EXCEPTION
407:

Line 726: AMS_UTILITY_PVT.Write_Conc_Log('Private API: '|| pkg_name || '.' || l_api_name || 'start with batch id : '||p_upload_batch_id||' ui instance id : '||p_ui_instance_id);

722: BEGIN
723:
724:
725: IF (AMS_DEBUG_HIGH_ON) THEN
726: AMS_UTILITY_PVT.Write_Conc_Log('Private API: '|| pkg_name || '.' || l_api_name || 'start with batch id : '||p_upload_batch_id||' ui instance id : '||p_ui_instance_id);
727: END IF;
728:
729:
730: -- Initialize API return status to SUCCESS

Line 737: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start to read from ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);

733: AMS_ADI_COMMON_PVT.init();
734:
735: -- Debug Message
736: IF (AMS_DEBUG_HIGH_ON) THEN
737: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start to read from ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);
738: END IF;
739:
740: OPEN C_IMPORT_BATCH(p_upload_batch_id);
741: LOOP -- C_IMPORT_BATCH loop

Line 766: AMS_UTILITY_PVT.Write_Conc_Log('Private API: '|| pkg_name || '.' || l_api_name ||'done with fetch');

762: LIMIT AMS_ADI_COMMON_PVT.g_batch_size;
763:
764: -- Debug Message
765: IF (AMS_DEBUG_HIGH_ON) THEN
766: AMS_UTILITY_PVT.Write_Conc_Log('Private API: '|| pkg_name || '.' || l_api_name ||'done with fetch');
767: END IF;
768:
769: -- Debug Message
770: IF (AMS_DEBUG_HIGH_ON) THEN

Line 771: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'calling init_for_batch');

767: END IF;
768:
769: -- Debug Message
770: IF (AMS_DEBUG_HIGH_ON) THEN
771: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'calling init_for_batch');
772: END IF;
773:
774: --initialize batch operation
775: AMS_ADI_COMMON_PVT.init_for_batch(l_error_recs);

Line 779: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Done init_for_batch with loopsize'||l_objectNames.COUNT);

775: AMS_ADI_COMMON_PVT.init_for_batch(l_error_recs);
776:
777: -- Debug Message
778: IF (AMS_DEBUG_HIGH_ON) THEN
779: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Done init_for_batch with loopsize'||l_objectNames.COUNT);
780: END IF;
781:
782:
783: -- start looping the arrays to call the Schedule Public API

Line 809: AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');

805: parent_object_id = l_campIds(i) and
806: object_name = l_objectNames(i);
807: EXCEPTION
808: WHEN TOO_MANY_ROWS THEN
809: AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
810: l_return_status := FND_API.G_RET_STS_ERROR;
811: Handle_Ret_Status_For_Import (
812: p_return_status => l_return_status,
813: p_object_name => l_objectNames(i),

Line 831: -- get the defult user status from AMS_UTILITY_PVT

827: l_schedule_rec.object_version_number := 1;
828:
829: l_schedule_rec.campaign_id := l_campIds(i);
830:
831: -- get the defult user status from AMS_UTILITY_PVT
832: l_schedule_rec.user_status_id := AMS_UTILITY_PVT.get_default_user_status(p_status_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS',
833: p_status_code => 'NEW');
834:
835: l_schedule_rec.status_code := 'NEW';

Line 832: l_schedule_rec.user_status_id := AMS_UTILITY_PVT.get_default_user_status(p_status_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS',

828:
829: l_schedule_rec.campaign_id := l_campIds(i);
830:
831: -- get the defult user status from AMS_UTILITY_PVT
832: l_schedule_rec.user_status_id := AMS_UTILITY_PVT.get_default_user_status(p_status_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS',
833: p_status_code => 'NEW');
834:
835: l_schedule_rec.status_code := 'NEW';
836: l_schedule_rec.status_date := sysdate;

Line 853: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'l_endDates '|| to_char(l_endDates(i), ADI_DATE_FORMAT || ' ' || ADI_TIME_FORMAT));

849:
850: l_schedule_rec.start_date_time := l_start_date_time;
851:
852: IF (AMS_DEBUG_HIGH_ON) THEN
853: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'l_endDates '|| to_char(l_endDates(i), ADI_DATE_FORMAT || ' ' || ADI_TIME_FORMAT));
854: END IF;
855:
856: IF (l_endDates(i) is not NULL)
857: THEN

Line 871: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start Date Time'|| to_char(l_schedule_rec.start_date_time, ADI_DATE_FORMAT || ' ' || ADI_TIME_FORMAT));

867: l_schedule_rec.end_date_time := null;
868: END IF;
869:
870: IF (AMS_DEBUG_HIGH_ON) THEN
871: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start Date Time'|| to_char(l_schedule_rec.start_date_time, ADI_DATE_FORMAT || ' ' || ADI_TIME_FORMAT));
872: END IF;
873:
874: IF (AMS_DEBUG_HIGH_ON) THEN
875: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'End Date Time'|| to_char(l_schedule_rec.end_date_time, ADI_DATE_FORMAT || ' ' || ADI_TIME_FORMAT));

Line 875: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'End Date Time'|| to_char(l_schedule_rec.end_date_time, ADI_DATE_FORMAT || ' ' || ADI_TIME_FORMAT));

871: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start Date Time'|| to_char(l_schedule_rec.start_date_time, ADI_DATE_FORMAT || ' ' || ADI_TIME_FORMAT));
872: END IF;
873:
874: IF (AMS_DEBUG_HIGH_ON) THEN
875: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'End Date Time'|| to_char(l_schedule_rec.end_date_time, ADI_DATE_FORMAT || ' ' || ADI_TIME_FORMAT));
876: END IF;
877:
878: l_schedule_rec.timezone_id := l_timezoneIds(i);
879:

Line 1006: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Calling Campaign Schedule Public API');

1002: --populate the schedule record end
1003:
1004: -- Debug Message
1005: IF (AMS_DEBUG_HIGH_ON) THEN
1006: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Calling Campaign Schedule Public API');
1007: END IF;
1008:
1009: AMS_Camp_Schedule_PUB.Create_Camp_Schedule(
1010: 1.0,

Line 1022: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Return Status from Schedule API'||l_return_status);

1018: l_schedule_id
1019: );
1020: -- Debug Message
1021: IF (AMS_DEBUG_HIGH_ON) THEN
1022: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Return Status from Schedule API'||l_return_status);
1023: END IF;
1024:
1025: Handle_Ret_Status_For_Import (
1026: p_return_status => l_return_status,

Line 1037: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1033: -- Metrics Integration starts here
1034: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1035: THEN
1036: IF (AMS_DEBUG_HIGH_ON) THEN
1037: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1038: ' Association before Metrics association was successful '||TO_CHAR(l_schedule_id));
1039: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1040: ' Now proceeding with Metrics association');
1041: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

Line 1039: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1035: THEN
1036: IF (AMS_DEBUG_HIGH_ON) THEN
1037: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1038: ' Association before Metrics association was successful '||TO_CHAR(l_schedule_id));
1039: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1040: ' Now proceeding with Metrics association');
1041: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1042: ' Now calling AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS API');
1043: END IF;

Line 1041: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1037: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1038: ' Association before Metrics association was successful '||TO_CHAR(l_schedule_id));
1039: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1040: ' Now proceeding with Metrics association');
1041: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1042: ' Now calling AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS API');
1043: END IF;
1044:
1045: AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS(

Line 1061: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1057: p_object_id => l_schedule_id
1058: );
1059:
1060: IF (AMS_DEBUG_HIGH_ON) THEN
1061: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1062: ' Return Status from AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS API '||l_return_status);
1063: END IF;
1064:
1065: Handle_Ret_Status_For_Import (

Line 1086: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation successful '||TO_CHAR(l_schedule_id));

1082: (l_schedule_rec.activity_type_code <> 'INTERNET')
1083: )
1084: THEN
1085: IF (AMS_DEBUG_HIGH_ON) THEN
1086: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation successful '||TO_CHAR(l_schedule_id));
1087: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with repeating schedule association ');
1088: END IF;
1089:
1090: AMS_SCHEDULER_PVT.Create_Scheduler(

Line 1087: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with repeating schedule association ');

1083: )
1084: THEN
1085: IF (AMS_DEBUG_HIGH_ON) THEN
1086: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation successful '||TO_CHAR(l_schedule_id));
1087: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with repeating schedule association ');
1088: END IF;
1089:
1090: AMS_SCHEDULER_PVT.Create_Scheduler(
1091: p_obj_type => 'CSCH',

Line 1102: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Return Status from AMS_SCHEDULER_PVT.Create_Scheduler API '||l_return_status || ' ' || to_char(l_temp_num));

1098: x_scheduler_id => l_temp_num
1099: );
1100:
1101: IF (AMS_DEBUG_HIGH_ON) THEN
1102: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Return Status from AMS_SCHEDULER_PVT.Create_Scheduler API '||l_return_status || ' ' || to_char(l_temp_num));
1103: END IF;
1104:
1105: Handle_Ret_Status_For_Import (
1106: p_return_status => l_return_status,

Line 1120: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation successful '||TO_CHAR(l_schedule_id));

1116: -- Cover Letter Integration start
1117: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1118: THEN
1119: IF (AMS_DEBUG_HIGH_ON) THEN
1120: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation successful '||TO_CHAR(l_schedule_id));
1121: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with cover letter association for cover letter '||TO_CHAR(l_covLettIds (i)));
1122: END IF;
1123:
1124: IF (l_covLettIds (i) is not null)

Line 1121: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with cover letter association for cover letter '||TO_CHAR(l_covLettIds (i)));

1117: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1118: THEN
1119: IF (AMS_DEBUG_HIGH_ON) THEN
1120: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation successful '||TO_CHAR(l_schedule_id));
1121: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with cover letter association for cover letter '||TO_CHAR(l_covLettIds (i)));
1122: END IF;
1123:
1124: IF (l_covLettIds (i) is not null)
1125: THEN

Line 1134: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now calling IBC_CITEM_ADMIN_GRP.insert_associations API');

1130: l_assoc_type_codes(1) := 'AMS_CSCH';
1131: l_assoc_objects1(1) := to_char(l_schedule_id); --where 123456 is the schedule id
1132:
1133: IF (AMS_DEBUG_HIGH_ON) THEN
1134: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now calling IBC_CITEM_ADMIN_GRP.insert_associations API');
1135: END IF;
1136: IBC_CITEM_ADMIN_GRP.insert_associations(
1137: p_content_item_id => l_covLettIds(i)
1138: ,p_assoc_type_codes => l_assoc_type_codes

Line 1147: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Return Status from IBC Association API for Cover Letter '||l_return_status);

1143: ,x_msg_data => l_msg_data
1144: );
1145:
1146: IF (AMS_DEBUG_HIGH_ON) THEN
1147: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Return Status from IBC Association API for Cover Letter '||l_return_status);
1148: END IF;
1149:
1150: Handle_Ret_Status_For_Import (
1151: p_return_status => l_return_status,

Line 1165: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Cover letter associaiton successful '||TO_CHAR(l_schedule_id));

1161: -- Product Integration starts here
1162: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1163: THEN
1164: IF (AMS_DEBUG_HIGH_ON) THEN
1165: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Cover letter associaiton successful '||TO_CHAR(l_schedule_id));
1166: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with product/category association ');
1167: END IF;
1168:
1169:

Line 1166: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with product/category association ');

1162: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1163: THEN
1164: IF (AMS_DEBUG_HIGH_ON) THEN
1165: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Cover letter associaiton successful '||TO_CHAR(l_schedule_id));
1166: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with product/category association ');
1167: END IF;
1168:
1169:
1170: IF ((l_prodIds1(i) is not null) OR (l_catIds1(i) is not null) )

Line 1173: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' At least one product/category is present to be associated'||TO_CHAR(l_schedule_id));

1169:
1170: IF ((l_prodIds1(i) is not null) OR (l_catIds1(i) is not null) )
1171: THEN
1172: IF (AMS_DEBUG_HIGH_ON) THEN
1173: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' At least one product/category is present to be associated'||TO_CHAR(l_schedule_id));
1174: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_prodIds1(i) '||TO_CHAR(l_prodIds1(i)));
1175: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_catIds1(i) '||TO_CHAR(l_catIds1(i)));
1176: END IF;
1177:

Line 1174: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_prodIds1(i) '||TO_CHAR(l_prodIds1(i)));

1170: IF ((l_prodIds1(i) is not null) OR (l_catIds1(i) is not null) )
1171: THEN
1172: IF (AMS_DEBUG_HIGH_ON) THEN
1173: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' At least one product/category is present to be associated'||TO_CHAR(l_schedule_id));
1174: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_prodIds1(i) '||TO_CHAR(l_prodIds1(i)));
1175: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_catIds1(i) '||TO_CHAR(l_catIds1(i)));
1176: END IF;
1177:
1178: Associate_Product_Category(

Line 1175: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_catIds1(i) '||TO_CHAR(l_catIds1(i)));

1171: THEN
1172: IF (AMS_DEBUG_HIGH_ON) THEN
1173: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' At least one product/category is present to be associated'||TO_CHAR(l_schedule_id));
1174: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_prodIds1(i) '||TO_CHAR(l_prodIds1(i)));
1175: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_catIds1(i) '||TO_CHAR(l_catIds1(i)));
1176: END IF;
1177:
1178: Associate_Product_Category(
1179: p_product_id => l_prodIds1(i),

Line 1190: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_ctd_act_product_id '||TO_CHAR(l_ctd_act_product_id));

1186: x_msg_data => l_msg_data
1187: );
1188:
1189: IF (AMS_DEBUG_HIGH_ON) THEN
1190: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_ctd_act_product_id '||TO_CHAR(l_ctd_act_product_id));
1191: END IF;
1192:
1193: Handle_Ret_Status_For_Import (
1194: p_return_status => l_return_status,

Line 1207: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 1 association successful '||TO_CHAR(l_schedule_id));

1203:
1204: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1205: THEN
1206: IF (AMS_DEBUG_HIGH_ON) THEN
1207: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 1 association successful '||TO_CHAR(l_schedule_id));
1208: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with product/category association ');
1209: END IF;
1210:
1211: IF ((l_prodIds2(i) is not null) OR (l_catIds2(i) is not null) )

Line 1208: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with product/category association ');

1204: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1205: THEN
1206: IF (AMS_DEBUG_HIGH_ON) THEN
1207: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 1 association successful '||TO_CHAR(l_schedule_id));
1208: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with product/category association ');
1209: END IF;
1210:
1211: IF ((l_prodIds2(i) is not null) OR (l_catIds2(i) is not null) )
1212: THEN

Line 1214: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' At least one product/category is present to be associated'||TO_CHAR(l_schedule_id));

1210:
1211: IF ((l_prodIds2(i) is not null) OR (l_catIds2(i) is not null) )
1212: THEN
1213: IF (AMS_DEBUG_HIGH_ON) THEN
1214: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' At least one product/category is present to be associated'||TO_CHAR(l_schedule_id));
1215: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_prodIds2(i) '||TO_CHAR(l_prodIds2(i)));
1216: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_catIds2(i) '||TO_CHAR(l_catIds2(i)));
1217: END IF;
1218:

Line 1215: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_prodIds2(i) '||TO_CHAR(l_prodIds2(i)));

1211: IF ((l_prodIds2(i) is not null) OR (l_catIds2(i) is not null) )
1212: THEN
1213: IF (AMS_DEBUG_HIGH_ON) THEN
1214: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' At least one product/category is present to be associated'||TO_CHAR(l_schedule_id));
1215: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_prodIds2(i) '||TO_CHAR(l_prodIds2(i)));
1216: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_catIds2(i) '||TO_CHAR(l_catIds2(i)));
1217: END IF;
1218:
1219: -- 31-Aug-2005 mayjain Support for Primary Flag

Line 1216: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_catIds2(i) '||TO_CHAR(l_catIds2(i)));

1212: THEN
1213: IF (AMS_DEBUG_HIGH_ON) THEN
1214: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' At least one product/category is present to be associated'||TO_CHAR(l_schedule_id));
1215: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_prodIds2(i) '||TO_CHAR(l_prodIds2(i)));
1216: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_catIds2(i) '||TO_CHAR(l_catIds2(i)));
1217: END IF;
1218:
1219: -- 31-Aug-2005 mayjain Support for Primary Flag
1220: l_primary_flag := 'N';

Line 1243: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_ctd_act_product_id '||TO_CHAR(l_ctd_act_product_id));

1239: IF ((l_prodIds1(i) is null) AND (l_catIds1(i) is null) )
1240: THEN
1241: l_ctd_act_product_id := l_temp_num;
1242: IF (AMS_DEBUG_HIGH_ON) THEN
1243: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_ctd_act_product_id '||TO_CHAR(l_ctd_act_product_id));
1244: END IF;
1245: END IF;
1246:
1247: Handle_Ret_Status_For_Import (

Line 1266: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 1 association successful '||TO_CHAR(l_schedule_id));

1262: -- Content Item 1
1263: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1264: THEN
1265: IF (AMS_DEBUG_HIGH_ON) THEN
1266: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 1 association successful '||TO_CHAR(l_schedule_id));
1267: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 1 association ');
1268: END IF;
1269:
1270: IF (l_collabCitemIds1(i) is not null)

Line 1267: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 1 association ');

1263: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1264: THEN
1265: IF (AMS_DEBUG_HIGH_ON) THEN
1266: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 1 association successful '||TO_CHAR(l_schedule_id));
1267: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 1 association ');
1268: END IF;
1269:
1270: IF (l_collabCitemIds1(i) is not null)
1271: THEN

Line 1273: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 1 is present to be associated to '||TO_CHAR(l_schedule_id));

1269:
1270: IF (l_collabCitemIds1(i) is not null)
1271: THEN
1272: IF (AMS_DEBUG_HIGH_ON) THEN
1273: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 1 is present to be associated to '||TO_CHAR(l_schedule_id));
1274: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds1(i) '||TO_CHAR(l_collabCitemIds1(i)));
1275: END IF;
1276:
1277: Associate_Collaboration_Item(

Line 1274: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds1(i) '||TO_CHAR(l_collabCitemIds1(i)));

1270: IF (l_collabCitemIds1(i) is not null)
1271: THEN
1272: IF (AMS_DEBUG_HIGH_ON) THEN
1273: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 1 is present to be associated to '||TO_CHAR(l_schedule_id));
1274: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds1(i) '||TO_CHAR(l_collabCitemIds1(i)));
1275: END IF;
1276:
1277: Associate_Collaboration_Item(
1278: p_collab_type => 'AMS_CONTENT',

Line 1302: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 2 association successful '||TO_CHAR(l_schedule_id));

1298: -- Content Item 2
1299: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1300: THEN
1301: IF (AMS_DEBUG_HIGH_ON) THEN
1302: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 2 association successful '||TO_CHAR(l_schedule_id));
1303: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 2 association ');
1304: END IF;
1305:
1306: IF (l_collabCitemIds2(i) is not null)

Line 1303: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 2 association ');

1299: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1300: THEN
1301: IF (AMS_DEBUG_HIGH_ON) THEN
1302: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 2 association successful '||TO_CHAR(l_schedule_id));
1303: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 2 association ');
1304: END IF;
1305:
1306: IF (l_collabCitemIds2(i) is not null)
1307: THEN

Line 1309: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 2 is present to be associated to '||TO_CHAR(l_schedule_id));

1305:
1306: IF (l_collabCitemIds2(i) is not null)
1307: THEN
1308: IF (AMS_DEBUG_HIGH_ON) THEN
1309: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 2 is present to be associated to '||TO_CHAR(l_schedule_id));
1310: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds2(i) '||TO_CHAR(l_collabCitemIds2(i)));
1311: END IF;
1312:
1313: Associate_Collaboration_Item(

Line 1310: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds2(i) '||TO_CHAR(l_collabCitemIds2(i)));

1306: IF (l_collabCitemIds2(i) is not null)
1307: THEN
1308: IF (AMS_DEBUG_HIGH_ON) THEN
1309: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 2 is present to be associated to '||TO_CHAR(l_schedule_id));
1310: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds2(i) '||TO_CHAR(l_collabCitemIds2(i)));
1311: END IF;
1312:
1313: Associate_Collaboration_Item(
1314: p_collab_type => 'AMS_CONTENT',

Line 1338: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 3 association successful '||TO_CHAR(l_schedule_id));

1334: -- Content Item 3
1335: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1336: THEN
1337: IF (AMS_DEBUG_HIGH_ON) THEN
1338: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 3 association successful '||TO_CHAR(l_schedule_id));
1339: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 3 association ');
1340: END IF;
1341:
1342: IF (l_collabCitemIds3(i) is not null)

Line 1339: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 3 association ');

1335: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1336: THEN
1337: IF (AMS_DEBUG_HIGH_ON) THEN
1338: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 3 association successful '||TO_CHAR(l_schedule_id));
1339: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 3 association ');
1340: END IF;
1341:
1342: IF (l_collabCitemIds3(i) is not null)
1343: THEN

Line 1345: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 3 is present to be associated to '||TO_CHAR(l_schedule_id));

1341:
1342: IF (l_collabCitemIds3(i) is not null)
1343: THEN
1344: IF (AMS_DEBUG_HIGH_ON) THEN
1345: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 3 is present to be associated to '||TO_CHAR(l_schedule_id));
1346: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds3(i) '||TO_CHAR(l_collabCitemIds3(i)));
1347: END IF;
1348:
1349: Associate_Collaboration_Item(

Line 1346: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds3(i) '||TO_CHAR(l_collabCitemIds3(i)));

1342: IF (l_collabCitemIds3(i) is not null)
1343: THEN
1344: IF (AMS_DEBUG_HIGH_ON) THEN
1345: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 3 is present to be associated to '||TO_CHAR(l_schedule_id));
1346: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabCitemIds3(i) '||TO_CHAR(l_collabCitemIds3(i)));
1347: END IF;
1348:
1349: Associate_Collaboration_Item(
1350: p_collab_type => 'AMS_CONTENT',

Line 1374: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Content Item 3 association successful '||TO_CHAR(l_schedule_id));

1370: -- Script
1371: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1372: THEN
1373: IF (AMS_DEBUG_HIGH_ON) THEN
1374: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Content Item 3 association successful '||TO_CHAR(l_schedule_id));
1375: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 3 association ');
1376: END IF;
1377:
1378: IF (l_collabScrIds(i) is not null)

Line 1375: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 3 association ');

1371: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1372: THEN
1373: IF (AMS_DEBUG_HIGH_ON) THEN
1374: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Content Item 3 association successful '||TO_CHAR(l_schedule_id));
1375: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 3 association ');
1376: END IF;
1377:
1378: IF (l_collabScrIds(i) is not null)
1379: THEN

Line 1381: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 3 is present to be associated to '||TO_CHAR(l_schedule_id));

1377:
1378: IF (l_collabScrIds(i) is not null)
1379: THEN
1380: IF (AMS_DEBUG_HIGH_ON) THEN
1381: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 3 is present to be associated to '||TO_CHAR(l_schedule_id));
1382: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabScrIds(i) '||TO_CHAR(l_collabScrIds(i)));
1383: END IF;
1384:
1385: Associate_Collaboration_Item(

Line 1382: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabScrIds(i) '||TO_CHAR(l_collabScrIds(i)));

1378: IF (l_collabScrIds(i) is not null)
1379: THEN
1380: IF (AMS_DEBUG_HIGH_ON) THEN
1381: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Collaboration CItem 3 is present to be associated to '||TO_CHAR(l_schedule_id));
1382: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' l_collabScrIds(i) '||TO_CHAR(l_collabScrIds(i)));
1383: END IF;
1384:
1385: Associate_Collaboration_Item(
1386: p_collab_type => 'INBOUND_SCRIPT',

Line 1413: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1409: -- Web Planner Integration Starts here
1410: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1411: THEN
1412: IF (AMS_DEBUG_HIGH_ON) THEN
1413: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1414: ' Association before Web Planner association was successful '||TO_CHAR(l_schedule_id));
1415: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1416: ' Now proceeding with Web Planner association');
1417: END IF;

Line 1415: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1411: THEN
1412: IF (AMS_DEBUG_HIGH_ON) THEN
1413: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1414: ' Association before Web Planner association was successful '||TO_CHAR(l_schedule_id));
1415: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1416: ' Now proceeding with Web Planner association');
1417: END IF;
1418:
1419: IF ( l_schedule_rec.activity_type_code = 'INTERNET')

Line 1422: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1418:
1419: IF ( l_schedule_rec.activity_type_code = 'INTERNET')
1420: THEN
1421: IF (AMS_DEBUG_HIGH_ON) THEN
1422: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1423: ' It is a Web Schedule. No checking if WP Details are present');
1424: END IF;
1425:
1426: IF ((l_wpAppIds(i) is not null) AND

Line 1431: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1427: (l_wpPlceIds(i) is not null) AND
1428: (l_wpCitemIds(i) is not null))
1429: THEN
1430: IF (AMS_DEBUG_HIGH_ON) THEN
1431: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1432: ' Now calling Associate_Web_Planner API');
1433: END IF;
1434:
1435: l_placement_citem_id_tbl := JTF_NUMBER_TABLE();

Line 1452: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1448: x_return_status => l_return_status
1449: );
1450:
1451: IF (AMS_DEBUG_HIGH_ON) THEN
1452: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1453: ' Return Status from Associate_Web_Planner API '||l_return_status);
1454: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1455: ' Placement Citem ID Table count '||TO_CHAR(l_placement_citem_id_tbl.count));
1456: END IF;

Line 1454: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1450:
1451: IF (AMS_DEBUG_HIGH_ON) THEN
1452: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1453: ' Return Status from Associate_Web_Planner API '||l_return_status);
1454: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1455: ' Placement Citem ID Table count '||TO_CHAR(l_placement_citem_id_tbl.count));
1456: END IF;
1457:
1458: Handle_Ret_Status_For_Import (

Line 1473: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1469: THEN
1470: IF (l_ctdActions(i) is not null)
1471: THEN
1472: IF (AMS_DEBUG_HIGH_ON) THEN
1473: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1474: ' Association before CTD association was successful '||TO_CHAR(l_schedule_id));
1475: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1476: ' Now proceeding with CTD association');
1477: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

Line 1475: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1471: THEN
1472: IF (AMS_DEBUG_HIGH_ON) THEN
1473: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1474: ' Association before CTD association was successful '||TO_CHAR(l_schedule_id));
1475: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1476: ' Now proceeding with CTD association');
1477: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1478: ' Now calling AMS_ADI_CTD_PVT.CREATE_CTDS API');
1479: END IF;

Line 1477: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1473: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1474: ' Association before CTD association was successful '||TO_CHAR(l_schedule_id));
1475: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1476: ' Now proceeding with CTD association');
1477: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1478: ' Now calling AMS_ADI_CTD_PVT.CREATE_CTDS API');
1479: END IF;
1480:
1481: AMS_ADI_CTD_PVT.CREATE_CTDS(

Line 1509: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1505: p_activity_product_id => l_ctd_act_product_id
1506: );
1507:
1508: IF (AMS_DEBUG_HIGH_ON) THEN
1509: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1510: ' Return Status from AMS_ADI_CTD_PVT.CREATE_CTDS API '||l_return_status);
1511: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1512: ' CTD ID Table count '||TO_CHAR(l_ctd_id_tbl.count));
1513: END IF;

Line 1511: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1507:
1508: IF (AMS_DEBUG_HIGH_ON) THEN
1509: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1510: ' Return Status from AMS_ADI_CTD_PVT.CREATE_CTDS API '||l_return_status);
1511: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1512: ' CTD ID Table count '||TO_CHAR(l_ctd_id_tbl.count));
1513: END IF;
1514:
1515: Handle_Ret_Status_For_Import (

Line 1537: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1533: THEN
1534: IF (l_puWebsites(i) is not null)
1535: THEN
1536: IF (AMS_DEBUG_HIGH_ON) THEN
1537: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1538: ' Pretty URL detail is present. Now checking for Activity Type ' || l_schedule_rec.activity_type_code);
1539: END IF;
1540:
1541: IF ((l_schedule_rec.activity_type_code = 'BROADCAST') OR

Line 1553: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1549:
1550: IF (l_ctdActions(i) is not null)
1551: THEN
1552: IF (AMS_DEBUG_HIGH_ON) THEN
1553: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1554: ' Association before Pretty URL CTD association was successful '||TO_CHAR(l_schedule_id));
1555: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1556: ' Now proceeding with Pretty URL CTD association');
1557: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

Line 1555: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1551: THEN
1552: IF (AMS_DEBUG_HIGH_ON) THEN
1553: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1554: ' Association before Pretty URL CTD association was successful '||TO_CHAR(l_schedule_id));
1555: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1556: ' Now proceeding with Pretty URL CTD association');
1557: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1558: ' Now calling AMS_ADI_CTD_PVT.CREATE_CTDS API');
1559: END IF;

Line 1557: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1553: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1554: ' Association before Pretty URL CTD association was successful '||TO_CHAR(l_schedule_id));
1555: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1556: ' Now proceeding with Pretty URL CTD association');
1557: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1558: ' Now calling AMS_ADI_CTD_PVT.CREATE_CTDS API');
1559: END IF;
1560:
1561: l_tmp_tbl := JTF_NUMBER_TABLE();

Line 1593: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1589: p_activity_product_id => l_ctd_act_product_id
1590: );
1591:
1592: IF (AMS_DEBUG_HIGH_ON) THEN
1593: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1594: ' Return Status from AMS_ADI_CTD_PVT.CREATE_CTDS API '||l_return_status);
1595: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1596: ' CTD ID Table count '||TO_CHAR(l_ctd_id_tbl.count));
1597: END IF;

Line 1595: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1591:
1592: IF (AMS_DEBUG_HIGH_ON) THEN
1593: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1594: ' Return Status from AMS_ADI_CTD_PVT.CREATE_CTDS API '||l_return_status);
1595: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1596: ' CTD ID Table count '||TO_CHAR(l_ctd_id_tbl.count));
1597: END IF;
1598:
1599: Handle_Ret_Status_For_Import (

Line 1614: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1610: -- Now call Pretty URL API
1611: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1612: THEN
1613: IF (AMS_DEBUG_HIGH_ON) THEN
1614: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1615: ' Pretty URL CTD association was successful '||TO_CHAR(l_schedule_id));
1616: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1617: ' Now proceeding with Pretty URL association');
1618: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

Line 1616: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1612: THEN
1613: IF (AMS_DEBUG_HIGH_ON) THEN
1614: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1615: ' Pretty URL CTD association was successful '||TO_CHAR(l_schedule_id));
1616: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1617: ' Now proceeding with Pretty URL association');
1618: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1619: ' Now calling AMS_ADI_PRETTY_URL_PVT.CREATE_PRETTY_URL API');
1620: END IF;

Line 1618: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1614: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1615: ' Pretty URL CTD association was successful '||TO_CHAR(l_schedule_id));
1616: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1617: ' Now proceeding with Pretty URL association');
1618: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1619: ' Now calling AMS_ADI_PRETTY_URL_PVT.CREATE_PRETTY_URL API');
1620: END IF;
1621:
1622: AMS_ADI_PRETTY_URL_PVT.CREATE_PRETTY_URL(

Line 1635: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1631: x_return_status => l_return_status
1632: ) ;
1633:
1634: IF (AMS_DEBUG_HIGH_ON) THEN
1635: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1636: ' Return Status from AMS_ADI_PRETTY_URL_PVT.CREATE_PRETTY_URL API '||l_return_status);
1637: END IF;
1638:
1639: Handle_Ret_Status_For_Import (

Line 1659: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1655: THEN
1656: IF (l_notes(i) is not null)
1657: THEN
1658: IF (AMS_DEBUG_HIGH_ON) THEN
1659: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1660: ' Association before Notes association was successful '||TO_CHAR(l_schedule_id));
1661: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1662: ' Now proceeding with Notes association');
1663: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

Line 1661: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1657: THEN
1658: IF (AMS_DEBUG_HIGH_ON) THEN
1659: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1660: ' Association before Notes association was successful '||TO_CHAR(l_schedule_id));
1661: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1662: ' Now proceeding with Notes association');
1663: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1664: ' Now calling Jtf_Notes_Pub.Create_note API');
1665: END IF;

Line 1663: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1659: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1660: ' Association before Notes association was successful '||TO_CHAR(l_schedule_id));
1661: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1662: ' Now proceeding with Notes association');
1663: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1664: ' Now calling Jtf_Notes_Pub.Create_note API');
1665: END IF;
1666:
1667: Jtf_Notes_Pub.Create_note(

Line 1686: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1682: p_last_update_date => sysdate ,
1683: p_creation_date => sysdate ) ;
1684:
1685: IF (AMS_DEBUG_HIGH_ON) THEN
1686: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1687: ' Return Status from Jtf_Notes_Pub.Create_note API '||l_return_status);
1688: END IF;
1689:
1690: Handle_Ret_Status_For_Import (

Line 1707: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1703: THEN
1704: IF (l_apprActionCodes(i) = 'COMPLETE')
1705: THEN
1706: IF (AMS_DEBUG_HIGH_ON) THEN
1707: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1708: ' Association before Approval was successful '||TO_CHAR(l_schedule_id));
1709: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1710: ' Now proceeding with Approval');
1711: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

Line 1709: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1705: THEN
1706: IF (AMS_DEBUG_HIGH_ON) THEN
1707: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1708: ' Association before Approval was successful '||TO_CHAR(l_schedule_id));
1709: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1710: ' Now proceeding with Approval');
1711: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1712: ' Now calling AMS_ScheduleRules_PVT.Update_Schedule_Status');
1713: END IF;

Line 1711: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1707: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1708: ' Association before Approval was successful '||TO_CHAR(l_schedule_id));
1709: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1710: ' Now proceeding with Approval');
1711: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1712: ' Now calling AMS_ScheduleRules_PVT.Update_Schedule_Status');
1713: END IF;
1714:
1715: BEGIN

Line 1720: p_user_status_id => AMS_UTILITY_PVT.get_default_user_status

1716:
1717: AMS_ScheduleRules_PVT.Update_Schedule_Status(
1718: p_schedule_id => l_schedule_id,
1719: p_campaign_id => l_campIds(i),
1720: p_user_status_id => AMS_UTILITY_PVT.get_default_user_status
1721: (p_status_type => 'AMS_CAMPAIGN_SCHEDULE_STATUS',
1722: p_status_code => 'AVAILABLE'),
1723: p_budget_amount => null
1724: );

Line 1731: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

1727: l_return_status := FND_API.G_RET_STS_ERROR;
1728: END;
1729:
1730: IF (AMS_DEBUG_HIGH_ON) THEN
1731: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1732: ' Return Status from AMS_ScheduleRules_PVT.Update_Schedule_Status API '||l_return_status);
1733: END IF;
1734:
1735: END IF;

Line 1793: AMS_UTILITY_PVT.debug_message('Calling Complete batch');

1789:
1790: FND_MSG_PUB.initialize; --initializes message table for next loop
1791:
1792: IF (AMS_DEBUG_HIGH_ON) THEN
1793: AMS_UTILITY_PVT.debug_message('Calling Complete batch');
1794: END IF;
1795:
1796:
1797: AMS_ADI_COMMON_PVT.complete_batch(

Line 1812: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Calling Complete all');

1808: CLOSE C_IMPORT_BATCH;
1809:
1810: -- Debug Message
1811: IF (AMS_DEBUG_HIGH_ON) THEN
1812: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Calling Complete all');
1813: END IF;
1814:
1815: AMS_ADI_COMMON_PVT.complete_all();
1816:

Line 1819: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Done with all');

1815: AMS_ADI_COMMON_PVT.complete_all();
1816:
1817: -- Debug Message
1818: IF (AMS_DEBUG_HIGH_ON) THEN
1819: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Done with all');
1820: END IF;
1821:
1822: x_retcode := 0;
1823: EXCEPTION

Line 1976: AMS_UTILITY_PVT.Write_Conc_Log('Calling AMS_ActProduct_PVT API');

1972: -- mayjain 31-Aug-2005 Support for Primary Flag
1973: l_act_Product_rec.PRIMARY_PRODUCT_FLAG := p_primary_flag;
1974:
1975: IF (AMS_DEBUG_HIGH_ON) THEN
1976: AMS_UTILITY_PVT.Write_Conc_Log('Calling AMS_ActProduct_PVT API');
1977: END IF;
1978:
1979: AMS_ActProduct_PVT.Create_Act_Product
1980: ( p_api_version => 1.0,

Line 1992: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_ActProduct_PVT API ' || x_return_status);

1988: x_act_product_id => l_act_product_id
1989: );
1990:
1991: IF (AMS_DEBUG_HIGH_ON) THEN
1992: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_ActProduct_PVT API ' || x_return_status);
1993: AMS_UTILITY_PVT.Write_Conc_Log('x_act_product_id ' || to_char(l_act_product_id));
1994: END IF;
1995:
1996: x_act_product_id := l_act_product_id;

Line 1993: AMS_UTILITY_PVT.Write_Conc_Log('x_act_product_id ' || to_char(l_act_product_id));

1989: );
1990:
1991: IF (AMS_DEBUG_HIGH_ON) THEN
1992: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_ActProduct_PVT API ' || x_return_status);
1993: AMS_UTILITY_PVT.Write_Conc_Log('x_act_product_id ' || to_char(l_act_product_id));
1994: END IF;
1995:
1996: x_act_product_id := l_act_product_id;
1997: END Associate_Product_Category;

Line 2026: AMS_UTILITY_PVT.Write_Conc_Log('Calling AMS_Collab_assoc_PVT.Create_collab_Assoc API');

2022: l_collab_assoc_rec_type.obj_type := 'CSCH';
2023: l_collab_assoc_rec_type.obj_id := p_schedule_id;
2024:
2025: IF (AMS_DEBUG_HIGH_ON) THEN
2026: AMS_UTILITY_PVT.Write_Conc_Log('Calling AMS_Collab_assoc_PVT.Create_collab_Assoc API');
2027: END IF;
2028:
2029: AMS_Collab_assoc_PVT.Create_collab_Assoc(
2030: p_api_version_number => 1.0,

Line 2042: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_ActProduct_PVT API ' || x_return_status);

2038: x_collab_item_id => l_collab_item_id
2039: );
2040:
2041: IF (AMS_DEBUG_HIGH_ON) THEN
2042: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_ActProduct_PVT API ' || x_return_status);
2043: AMS_UTILITY_PVT.Write_Conc_Log('l_collab_item_id ' || to_char(l_collab_item_id));
2044: END IF;
2045:
2046: END Associate_Collaboration_Item;

Line 2043: AMS_UTILITY_PVT.Write_Conc_Log('l_collab_item_id ' || to_char(l_collab_item_id));

2039: );
2040:
2041: IF (AMS_DEBUG_HIGH_ON) THEN
2042: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_ActProduct_PVT API ' || x_return_status);
2043: AMS_UTILITY_PVT.Write_Conc_Log('l_collab_item_id ' || to_char(l_collab_item_id));
2044: END IF;
2045:
2046: END Associate_Collaboration_Item;
2047:

Line 2086: AMS_UTILITY_PVT.Write_Conc_Log('Calling AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC API');

2082: l_web_mp_rec.max_recommendations := 1;
2083: l_web_mp_rec.display_priority := null;
2084:
2085: IF (AMS_DEBUG_HIGH_ON) THEN
2086: AMS_UTILITY_PVT.Write_Conc_Log('Calling AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC API');
2087: END IF;
2088:
2089: AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC(
2090: p_api_version_number => 1.0,

Line 2103: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC API ' || x_return_status);

2099: x_return_status => x_return_status
2100: );
2101:
2102: IF (AMS_DEBUG_HIGH_ON) THEN
2103: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC API ' || x_return_status);
2104: AMS_UTILITY_PVT.Write_Conc_Log('x_placement_mp_id ' || to_char(x_placement_mp_id));
2105: END IF;
2106:
2107: END Associate_Web_Planner;

Line 2104: AMS_UTILITY_PVT.Write_Conc_Log('x_placement_mp_id ' || to_char(x_placement_mp_id));

2100: );
2101:
2102: IF (AMS_DEBUG_HIGH_ON) THEN
2103: AMS_UTILITY_PVT.Write_Conc_Log('Return Status from AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC API ' || x_return_status);
2104: AMS_UTILITY_PVT.Write_Conc_Log('x_placement_mp_id ' || to_char(x_placement_mp_id));
2105: END IF;
2106:
2107: END Associate_Web_Planner;
2108: