DBA Data[Home] [Help]

APPS.IEX_METRIC_CONCUR_PVT dependencies on IEX_DEBUG_PUB

Line 132: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: Refresh started');

128:
129: RETCODE := 0;
130:
131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
132: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: Refresh started');
133: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
134: END IF;
135:
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Metric Calculation Method=' || G_METRIC_BATCH);

Line 133: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

129: RETCODE := 0;
130:
131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
132: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: Refresh started');
133: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
134: END IF;
135:
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Metric Calculation Method=' || G_METRIC_BATCH);
137: l_batch_size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));

Line 212: IEX_DEBUG_PUB.logMessage('IEX Schema:'||l_out_oracle_schema);

208: --End adding for bug 16575665 gnramasa 3rd Apr 2013
209:
210: Else --start adding for bug 16516837
211: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_out_oracle_schema);
212: IEX_DEBUG_PUB.logMessage('IEX Schema:'||l_out_oracle_schema);
213: IEX_DEBUG_PUB.LogMessage('Truncating IEX_METRIC_SUMMARIES_ALL');
214:
215: ad_ddl.do_ddl(l_out_oracle_schema,
216: 'IEX',

Line 213: IEX_DEBUG_PUB.LogMessage('Truncating IEX_METRIC_SUMMARIES_ALL');

209:
210: Else --start adding for bug 16516837
211: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_out_oracle_schema);
212: IEX_DEBUG_PUB.logMessage('IEX Schema:'||l_out_oracle_schema);
213: IEX_DEBUG_PUB.LogMessage('Truncating IEX_METRIC_SUMMARIES_ALL');
214:
215: ad_ddl.do_ddl(l_out_oracle_schema,
216: 'IEX',
217: AD_DDL.TRUNCATE_TABLE,

Line 221: IEX_DEBUG_PUB.LogMessage('Truncated IEX_METRIC_SUMMARIES_ALL');

217: AD_DDL.TRUNCATE_TABLE,
218: 'TRUNCATE TABLE IEX_METRIC_SUMMARIES_ALL',
219: 'IEX_METRIC_SUMMARIES_ALL');
220:
221: IEX_DEBUG_PUB.LogMessage('Truncated IEX_METRIC_SUMMARIES_ALL');
222: IEX_DEBUG_PUB.logMessage('Done');
223:
224: END IF;
225: --end adding for bug 16516837

Line 222: IEX_DEBUG_PUB.logMessage('Done');

218: 'TRUNCATE TABLE IEX_METRIC_SUMMARIES_ALL',
219: 'IEX_METRIC_SUMMARIES_ALL');
220:
221: IEX_DEBUG_PUB.LogMessage('Truncated IEX_METRIC_SUMMARIES_ALL');
222: IEX_DEBUG_PUB.logMessage('Done');
223:
224: END IF;
225: --end adding for bug 16516837
226:

Line 498: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

494:
495: END IF;
496:
497: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
498: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
499: END IF;
500: /*
501: Exception
502: WHEN FND_API.G_EXC_ERROR THEN

Line 506: IEX_DEBUG_PUB.logMessage('IEX_METRIC: metricConcur: Expected Error ' || sqlerrm);

502: WHEN FND_API.G_EXC_ERROR THEN
503: RETCODE := -1;
504: ERRBUF := l_msg_data;
505: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
506: IEX_DEBUG_PUB.logMessage('IEX_METRIC: metricConcur: Expected Error ' || sqlerrm);
507: END IF;
508: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
509:
510: WHEN OTHERS THEN

Line 514: IEX_DEBUG_PUB.logMessage('IEX_METRIC: metricConcur: Unexpected Error ' || sqlerrm);

510: WHEN OTHERS THEN
511: RETCODE := -1;
512: ERRBUF := l_msg_data;
513: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
514: IEX_DEBUG_PUB.logMessage('IEX_METRIC: metricConcur: Unexpected Error ' || sqlerrm);
515: END IF;
516: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
517: */
518: Exception