DBA Data[Home] [Help]

APPS.AMS_ADI_MEDIA_PLANNER_PVT dependencies on AMS_UTILITY_PVT

Line 142: AMS_UTILITY_PVT.Write_Conc_Log('Public API: ' || l_api_name ||

138: RETURN;
139: END;
140:
141: IF (AMS_DEBUG_HIGH_ON) THEN
142: AMS_UTILITY_PVT.Write_Conc_Log('Public API: ' || l_api_name ||
143: ': upload batch id : '||p_upload_batch_id||
144: ', p_object_id : '||p_object_id);
145: END IF;
146:

Line 163: AMS_UTILITY_PVT.Write_Conc_Log('Public API: ' || l_api_name ||

159: COMMIT;
160: END IF;
161:
162: IF (AMS_DEBUG_HIGH_ON) THEN
163: AMS_UTILITY_PVT.Write_Conc_Log('Public API: ' || l_api_name ||
164: ': upload batch id : '||p_upload_batch_id||'. Done load');
165: END IF;
166:
167: EXCEPTION

Line 264: AMS_UTILITY_PVT.Write_Conc_Log('Private API : load_metrics object_name:'||

260:
261: x_return_status := FND_API.g_ret_sts_success;
262:
263: IF (AMS_DEBUG_HIGH_ON) THEN
264: AMS_UTILITY_PVT.Write_Conc_Log('Private API : load_metrics object_name:'||
265: p_media_planner_rec.object_name||
266: ' operation_type : '||p_media_planner_rec.operation_type);
267: END IF;
268:

Line 275: AMS_UTILITY_PVT.Write_Conc_Log('Private API : load_metrics '||

271: x_actmetric_table => l_table_of_metrics
272: );
273:
274: IF (AMS_DEBUG_HIGH_ON) THEN
275: AMS_UTILITY_PVT.Write_Conc_Log('Private API : load_metrics '||
276: 'after resolve_metrics_from_rec table count '||l_table_of_metrics.COUNT);
277: END IF;
278:
279: SAVEPOINT LOAD_METRICS_SP;

Line 371: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||

367: p_act_metric_rec => l_act_metric_rec,
368: x_activity_metric_id => x_activity_metric_id);
369:
370: IF (AMS_DEBUG_HIGH_ON) THEN
371: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
372: 'Return Status Create_ActMetric: '||l_return_status);
373: END IF;
374:
375: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 412: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||

408: x_msg_data => l_msg_data);
409:
410: -- Debug Message
411: IF (AMS_DEBUG_HIGH_ON) THEN
412: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
413: ': Return Status update_actmetric '||l_return_status);
414: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
415: ': activity_metric_id='||l_table_of_metrics(i).activity_metric_id);
416: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||

Line 414: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||

410: -- Debug Message
411: IF (AMS_DEBUG_HIGH_ON) THEN
412: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
413: ': Return Status update_actmetric '||l_return_status);
414: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
415: ': activity_metric_id='||l_table_of_metrics(i).activity_metric_id);
416: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
417: ': metric_id='||l_table_of_metrics(i).metric_id);
418: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||

Line 416: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||

412: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
413: ': Return Status update_actmetric '||l_return_status);
414: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
415: ': activity_metric_id='||l_table_of_metrics(i).activity_metric_id);
416: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
417: ': metric_id='||l_table_of_metrics(i).metric_id);
418: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
419: ': OVN='||l_table_of_metrics(i).object_version_number);
420: END IF;

Line 418: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||

414: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
415: ': activity_metric_id='||l_table_of_metrics(i).activity_metric_id);
416: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
417: ': metric_id='||l_table_of_metrics(i).metric_id);
418: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
419: ': OVN='||l_table_of_metrics(i).object_version_number);
420: END IF;
421:
422: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 447: AMS_UTILITY_PVT.Write_Conc_Log('Private API :AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS. x_return_status = '||x_return_status);

443: ROLLBACK TO LOAD_METRICS_SP;
444: END IF;
445:
446: IF (AMS_DEBUG_HIGH_ON) THEN
447: AMS_UTILITY_PVT.Write_Conc_Log('Private API :AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS. x_return_status = '||x_return_status);
448: END IF;
449:
450: EXCEPTION
451: WHEN fnd_api.G_EXC_ERROR THEN

Line 539: AMS_Utility_PVT.write_conc_log;

535: IF l_return_status <> FND_API.g_ret_sts_success THEN
536: -- Return error code should be success for the web adi to show the
537: -- messages on the Sheet.
538: -- retcode := 2; -- error code is 2
539: AMS_Utility_PVT.write_conc_log;
540: -- reset message buffer after contents
541: -- have been dumped into the log file
542: FND_MSG_PUB.initialize;
543: END IF;

Line 547: AMS_UTILITY_PVT.Write_Conc_Log('Public API: load_request upload '||

543: END IF;
544: END LOOP;
545:
546: IF (AMS_DEBUG_HIGH_ON) THEN
547: AMS_UTILITY_PVT.Write_Conc_Log('Public API: load_request upload '||
548: 'batch id : '||p_upload_batch_id||'. Done load');
549: END IF;
550:
551: AMS_ADI_COMMON_PVT.complete_batch(

Line 562: AMS_UTILITY_PVT.Write_Conc_Log('Public API: load_request retcode : '||x_retcode||' Done load');

558:
559: AMS_ADI_COMMON_PVT.complete_all(FND_API.G_TRUE,FND_API.G_TRUE,p_upload_batch_id);
560:
561: IF (AMS_DEBUG_HIGH_ON) THEN
562: AMS_UTILITY_PVT.Write_Conc_Log('Public API: load_request retcode : '||x_retcode||' Done load');
563: END IF;
564:
565: EXCEPTION
566: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 574: AMS_UTILITY_PVT.Write_Conc_Log(l_API_NAME||'SQLERROR: '||x_errbuf);

570: x_retcode := 1;
571: RAISE;
572: WHEN OTHERS THEN
573: x_errbuf := SQLERRM;
574: AMS_UTILITY_PVT.Write_Conc_Log(l_API_NAME||'SQLERROR: '||x_errbuf);
575: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
576: FND_MSG_PUB.Add_EXC_MSG(G_PKG_NAME, L_API_NAME);
577: END IF;
578: x_retcode := 1;

Line 994: AMS_UTILITY_PVT.Write_Conc_Log('Public API: purge_import_metrics' ||

990: IS
991: BEGIN
992:
993: IF (AMS_DEBUG_HIGH_ON) THEN
994: AMS_UTILITY_PVT.Write_Conc_Log('Public API: purge_import_metrics' ||
995: p_object_type|| '::'|| p_object_name|| '::' ||
996: p_parent_type ||'::'|| p_parent_id);
997: END IF;
998: