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.IEX_METRIC_CONCUR_PVT dependencies on FND_FILE

Line 136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Metric Calculation Method=' || G_METRIC_BATCH);

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'));
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size=' || l_batch_size);
139:
140: --Moac Changes. Commented the profile value. Start.

Line 138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size=' || l_batch_size);

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'));
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size=' || l_batch_size);
139:
140: --Moac Changes. Commented the profile value. Start.
141: --l_org_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('ORG_ID'), -1));
142: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || l_org_id);

Line 142: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || l_org_id);

138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size=' || l_batch_size);
139:
140: --Moac Changes. Commented the profile value. Start.
141: --l_org_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('ORG_ID'), -1));
142: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || l_org_id);
143: --Moac Changes. Commented the profile value. End.
144:
145: --Moac Changes. Initilize set the Policy. Start
146:

Line 150: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);

146:
147: MO_GLOBAL.INIT('IEX');
148: IF P_ORG_ID IS NOT NULL THEN
149: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
150: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
151: ELSE
152: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
153: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
154: END IF;

Line 153: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

149: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
150: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
151: ELSE
152: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
153: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
154: END IF;
155:
156: --Moac Changes. Initilize,set the Policy. End.
157:

Line 174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging old metric records(' || l_total_cnt || ')');

170: OPEN c_total_cnt;
171: FETCH c_total_cnt INTO l_total_cnt;
172: CLOSE c_total_cnt;
173:
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging old metric records(' || l_total_cnt || ')');
175: i := 0;
176:
177: LOOP
178: EXECUTE IMMEDIATE l_del_sql;

Line 195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging old metric records for party and accounts(' || l_cust_acct_cnt || ')');

191: OPEN c_cust_acct_cnt;
192: FETCH c_cust_acct_cnt INTO l_cust_acct_cnt;
193: CLOSE c_cust_acct_cnt;
194:
195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging old metric records for party and accounts(' || l_cust_acct_cnt || ')');
196: i := 0;
197:
198: LOOP
199: EXECUTE IMMEDIATE l_del_cust_acct;

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purge complete>>>>>');

223:
224: END IF;
225: --end adding for bug 16516837
226:
227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purge complete>>>>>');
228: -- End fix bug #5009901-JYPARK-delete records by batch size for performance
229:
230:
231: --Begin Bug 7477844 24-Dec-2008 barathsr

Line 241: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);

237:
238: --start adding comment for bug 16516837 SNUTHALA 22/mar/2013
239: --FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
240: --MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
241: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);
242: --end adding comment for bug 16516837 SNUTHALA 22/mar/2013
243: i := 0;
244: FOR r_party IN c_party LOOP
245: i := i + 1;

Line 249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Party Count=' || i);

245: i := i + 1;
246: l_party_id_tbl(i) := r_party.party_id;
247: END LOOP;
248:
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Party Count=' || i);
250:
251: FOR idx1 IN l_party_id_tbl.FIRST..l_party_id_tbl.LAST LOOP
252:
253: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

Line 297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || p_org_id);

293:
294: --Moac Changes. Re-Initialize after the Party Loop is complete. Start.
295: IF P_ORG_ID IS NOT NULL THEN
296: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || p_org_id);
298: ELSE
299: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || 'All');
301: END IF;

Line 300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || 'All');

296: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || p_org_id);
298: ELSE
299: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || 'All');
301: END IF;
302: --Moac Changes. Re-Initialize after the Party Loop is complete. Start.
303:
304: --Begin Bug 7477844 24-Dec-2008 barathsr

Line 313: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Account Loop, Operating Unit Set =' ||I_ORG.organization_id);

309: --End Bug 7477844 24-Dec-2008 barathsr
310: --start adding comment for bug 16516837 SNUTHALA 22/mar/2013
311: -- FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
312: -- MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
313: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Account Loop, Operating Unit Set =' ||I_ORG.organization_id);
314: --end adding comment for bug 16516837 SNUTHALA 22/mar/2013 SNUTHALA 22/mar/2013
315:
316: i := 0;
317: l_party_id_tbl.DELETE;

Line 324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Account Count=' || i);

320: i := i + 1;
321: l_cust_account_id_tbl(i) := r_account.cust_account_id;
322: l_party_id_tbl(i) := r_account.party_id;
323: END LOOP;
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Account Count=' || i);
325:
326: FOR idx1 IN l_cust_account_id_tbl.FIRST..l_cust_account_id_tbl.LAST LOOP
327:
328: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

Line 371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after Account loop, Operating Unit=' || p_org_id);

367:
368: --Moac Changes. Re-Initilize,set the Policy. Start
369: IF P_ORG_ID IS NOT NULL THEN
370: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after Account loop, Operating Unit=' || p_org_id);
372: ELSE
373: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
374: END IF;
375: --Moac Changes. Initilize, set the Policy. End.

Line 396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total BillTo Count=' || i);

392: l_cust_account_id_tbl(i) := r_billto.cust_account_id;
393: l_party_id_tbl(i) := r_billto.party_id;
394: -- End bug#7304169 snuthala 04-Aug-2008
395: END LOOP;
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total BillTo Count=' || i);
397:
398: FOR idx1 IN l_site_use_id_tbl.FIRST..l_site_use_id_tbl.LAST LOOP
399:
400: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

Line 454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Delinquency Count=' || i);

450: l_party_id_tbl(i) := r_del.party_cust_id;
451: l_org_id_tbl(i) := r_del.org_id;
452:
453: END LOOP;
454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Delinquency Count=' || i);
455:
456: FOR idx1 IN l_delinquency_id_tbl.FIRST..l_delinquency_id_tbl.LAST LOOP
457:
458: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

Line 508: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);

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
511: RETCODE := -1;
512: ERRBUF := l_msg_data;

Line 516: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);

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
519: WHEN OTHERS THEN
520: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR : ' || sqlerrm);

Line 520: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR : ' || sqlerrm);

516: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
517: */
518: Exception
519: WHEN OTHERS THEN
520: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR : ' || sqlerrm);
521: END Refresh_All;
522: BEGIN
523: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
524: G_USER_ID := FND_GLOBAL.User_Id;