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 95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Metric Calculation Method=' || G_METRIC_BATCH);

91: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: Refresh started');
92: IEX_DEBUG_PUB.logMessage('Metric_Concur: ' || 'IEX_METRIC: metricConcur: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
93: END IF;
94:
95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Metric Calculation Method=' || G_METRIC_BATCH);
96: l_batch_size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
97: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size=' || l_batch_size);
98:
99: --Moac Changes. Commented the profile value. Start.

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

93: END IF;
94:
95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Metric Calculation Method=' || G_METRIC_BATCH);
96: l_batch_size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
97: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size=' || l_batch_size);
98:
99: --Moac Changes. Commented the profile value. Start.
100: --l_org_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('ORG_ID'), -1));
101: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || l_org_id);

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

97: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size=' || l_batch_size);
98:
99: --Moac Changes. Commented the profile value. Start.
100: --l_org_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('ORG_ID'), -1));
101: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || l_org_id);
102: --Moac Changes. Commented the profile value. End.
103:
104: --Moac Changes. Initilize set the Policy. Start
105:

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

105:
106: MO_GLOBAL.INIT('IEX');
107: IF P_ORG_ID IS NOT NULL THEN
108: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
110: ELSE
111: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
113: END IF;

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

108: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
110: ELSE
111: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
113: END IF;
114:
115: --Moac Changes. Initilize,set the Policy. End.
116:

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

128: OPEN c_total_cnt;
129: FETCH c_total_cnt INTO l_total_cnt;
130: CLOSE c_total_cnt;
131:
132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging old metric records(' || l_total_cnt || ')');
133: i := 0;
134:
135: LOOP
136: EXECUTE IMMEDIATE l_del_sql;

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

142:
143: EXECUTE IMMEDIATE l_del_sql;
144: COMMIT;
145:
146: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purge complete>>>>>');
147: -- End fix bug #5009901-JYPARK-delete records by batch size for performance
148:
149: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
150: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.

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

147: -- End fix bug #5009901-JYPARK-delete records by batch size for performance
148:
149: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
150: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
151: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);
152:
153: i := 0;
154: FOR r_party IN c_party LOOP
155: i := i + 1;

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

155: i := i + 1;
156: l_party_id_tbl(i) := r_party.party_id;
157: END LOOP;
158:
159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Party Count=' || i);
160:
161: FOR idx1 IN l_party_id_tbl.FIRST..l_party_id_tbl.LAST LOOP
162:
163: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

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

198:
199: --Moac Changes. Re-Initialize after the Party Loop is complete. Start.
200: IF P_ORG_ID IS NOT NULL THEN
201: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || p_org_id);
203: ELSE
204: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || 'All');
206: END IF;

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

201: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || p_org_id);
203: ELSE
204: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || 'All');
206: END IF;
207: --Moac Changes. Re-Initialize after the Party Loop is complete. Start.
208:
209: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.

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

207: --Moac Changes. Re-Initialize after the Party Loop is complete. Start.
208:
209: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
210: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
211: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Account Loop, Operating Unit Set =' ||I_ORG.organization_id);
212: i := 0;
213: l_party_id_tbl.DELETE;
214:
215: FOR r_account IN c_account LOOP

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

216: i := i + 1;
217: l_cust_account_id_tbl(i) := r_account.cust_account_id;
218: l_party_id_tbl(i) := r_account.party_id;
219: END LOOP;
220: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Account Count=' || i);
221:
222: FOR idx1 IN l_cust_account_id_tbl.FIRST..l_cust_account_id_tbl.LAST LOOP
223:
224: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

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

260:
261: --Moac Changes. Re-Initilize,set the Policy. Start
262: IF P_ORG_ID IS NOT NULL THEN
263: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after Account loop, Operating Unit=' || p_org_id);
265: ELSE
266: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
267: END IF;
268: --Moac Changes. Initilize, set the Policy. End.

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

281: l_cust_account_id_tbl(i) := r_billto.cust_account_id;
282: l_party_id_tbl(i) := r_billto.party_id;
283: -- End bug#7304169 snuthala 04-Aug-2008
284: END LOOP;
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total BillTo Count=' || i);
286:
287: FOR idx1 IN l_site_use_id_tbl.FIRST..l_site_use_id_tbl.LAST LOOP
288:
289: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

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

332: l_party_id_tbl(i) := r_del.party_cust_id;
333: l_org_id_tbl(i) := r_del.org_id;
334:
335: END LOOP;
336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Delinquency Count=' || i);
337:
338: FOR idx1 IN l_delinquency_id_tbl.FIRST..l_delinquency_id_tbl.LAST LOOP
339:
340: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

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

385: ERRBUF := l_msg_data;
386: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
387: IEX_DEBUG_PUB.logMessage('IEX_METRIC: metricConcur: Expected Error ' || sqlerrm);
388: END IF;
389: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
390:
391: WHEN OTHERS THEN
392: RETCODE := -1;
393: ERRBUF := l_msg_data;

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

393: ERRBUF := l_msg_data;
394: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
395: IEX_DEBUG_PUB.logMessage('IEX_METRIC: metricConcur: Unexpected Error ' || sqlerrm);
396: END IF;
397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
398: */
399: Exception
400: WHEN OTHERS THEN
401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR : ' || sqlerrm);

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

397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
398: */
399: Exception
400: WHEN OTHERS THEN
401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR : ' || sqlerrm);
402: END Refresh_All;
403: BEGIN
404: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
405: G_USER_ID := FND_GLOBAL.User_Id;