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

Line 27: fnd_file.put_line(fnd_file.log, 'Inside Increment_Reading...');

23: --
24: BEGIN
25: SAVEPOINT Increment_Reading;
26: --
27: fnd_file.put_line(fnd_file.log, 'Inside Increment_Reading...');
28: fnd_file.put_line(fnd_file.log, 'p_ctr_id :'||p_ctr_id);
29: fnd_file.put_line(fnd_file.log, 'p_ctr_rdg :'||p_ctr_rdg);
30: fnd_file.put_line(fnd_file.log, 'p_capture_date :'||to_char(p_capture_date,'DD-MON-YYYY HH24:MI:SS'));
31: --

Line 28: fnd_file.put_line(fnd_file.log, 'p_ctr_id :'||p_ctr_id);

24: BEGIN
25: SAVEPOINT Increment_Reading;
26: --
27: fnd_file.put_line(fnd_file.log, 'Inside Increment_Reading...');
28: fnd_file.put_line(fnd_file.log, 'p_ctr_id :'||p_ctr_id);
29: fnd_file.put_line(fnd_file.log, 'p_ctr_rdg :'||p_ctr_rdg);
30: fnd_file.put_line(fnd_file.log, 'p_capture_date :'||to_char(p_capture_date,'DD-MON-YYYY HH24:MI:SS'));
31: --
32: l_txn_rec.source_transaction_date := sysdate;

Line 29: fnd_file.put_line(fnd_file.log, 'p_ctr_rdg :'||p_ctr_rdg);

25: SAVEPOINT Increment_Reading;
26: --
27: fnd_file.put_line(fnd_file.log, 'Inside Increment_Reading...');
28: fnd_file.put_line(fnd_file.log, 'p_ctr_id :'||p_ctr_id);
29: fnd_file.put_line(fnd_file.log, 'p_ctr_rdg :'||p_ctr_rdg);
30: fnd_file.put_line(fnd_file.log, 'p_capture_date :'||to_char(p_capture_date,'DD-MON-YYYY HH24:MI:SS'));
31: --
32: l_txn_rec.source_transaction_date := sysdate;
33: l_txn_rec.transaction_type_id := 89;

Line 30: fnd_file.put_line(fnd_file.log, 'p_capture_date :'||to_char(p_capture_date,'DD-MON-YYYY HH24:MI:SS'));

26: --
27: fnd_file.put_line(fnd_file.log, 'Inside Increment_Reading...');
28: fnd_file.put_line(fnd_file.log, 'p_ctr_id :'||p_ctr_id);
29: fnd_file.put_line(fnd_file.log, 'p_ctr_rdg :'||p_ctr_rdg);
30: fnd_file.put_line(fnd_file.log, 'p_capture_date :'||to_char(p_capture_date,'DD-MON-YYYY HH24:MI:SS'));
31: --
32: l_txn_rec.source_transaction_date := sysdate;
33: l_txn_rec.transaction_type_id := 89;
34: l_txn_rec.source_header_ref_id := 0;

Line 51: fnd_file.put_line(fnd_file.log,'Error from Create_Reading_Transaction...');

47: ,x_msg_count => x_msg_count
48: ,x_msg_data => x_msg_data
49: );
50: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
51: fnd_file.put_line(fnd_file.log,'Error from Create_Reading_Transaction...');
52: l_msg_index := 1;
53: FND_MSG_PUB.Count_And_Get
54: (p_count => x_msg_count,
55: p_data => x_msg_data

Line 62: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);

58: WHILE l_msg_count > 0 LOOP
59: x_msg_data := FND_MSG_PUB.GET
60: ( l_msg_index,
61: FND_API.G_FALSE );
62: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
63: l_msg_index := l_msg_index + 1;
64: l_msg_count := l_msg_count - 1;
65: END LOOP;
66: RAISE FND_API.G_EXC_ERROR;

Line 68: fnd_file.put_line(fnd_file.log, 'Inserting Counter Reading...');

64: l_msg_count := l_msg_count - 1;
65: END LOOP;
66: RAISE FND_API.G_EXC_ERROR;
67: END IF;
68: fnd_file.put_line(fnd_file.log, 'Inserting Counter Reading...');
69: select CSI_COUNTER_READINGS_S.nextval
70: into l_ctr_rdg_rec.counter_value_id from dual;
71: --
72: CSI_COUNTER_READINGS_PKG.Insert_Row(

Line 161: fnd_file.put_line(fnd_file.log, 'Calling OKC Assembler Event...');

157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159: -- End add for FP Tracking bug 7390758 (base bug 7374316)
160: --
161: fnd_file.put_line(fnd_file.log, 'Calling OKC Assembler Event...');
162: OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble
163: ( p_api_version => 1.0,
164: x_return_status => x_return_status,
165: x_msg_count => x_msg_count,

Line 170: fnd_file.put_line(fnd_file.log,'ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');

166: x_msg_data => x_msg_data,
167: p_counter_id => l_ctr_rdg_rec.counter_id
168: );
169: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
170: fnd_file.put_line(fnd_file.log,'ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
171: l_msg_index := 1;
172: l_msg_count := x_msg_count;
173: WHILE l_msg_count > 0 LOOP
174: x_msg_data := FND_MSG_PUB.GET

Line 178: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);

174: x_msg_data := FND_MSG_PUB.GET
175: ( l_msg_index,
176: FND_API.G_FALSE
177: );
178: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
179: l_msg_index := l_msg_index + 1;
180: l_msg_count := l_msg_count - 1;
181: END LOOP;
182: RAISE FND_API.G_EXC_ERROR;

Line 191: fnd_file.put_line(fnd_file.log,'Into when others error in Increment_Reading...');

187: Rollback To Increment_Reading;
188: WHEN OTHERS THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: Rollback To Increment_Reading;
191: fnd_file.put_line(fnd_file.log,'Into when others error in Increment_Reading...');
192: fnd_file.put_line(fnd_file.log,sqlerrm);
193: END Increment_Reading;
194: --
195: /*******************************

Line 192: fnd_file.put_line(fnd_file.log,sqlerrm);

188: WHEN OTHERS THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: Rollback To Increment_Reading;
191: fnd_file.put_line(fnd_file.log,'Into when others error in Increment_Reading...');
192: fnd_file.put_line(fnd_file.log,sqlerrm);
193: END Increment_Reading;
194: --
195: /*******************************
196: * Public program units *

Line 237: fnd_file.put_line(fnd_file.log, 'Start Execution : '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

233: AND nvl(disabled_flag,'N') = 'N'
234: ORDER BY value_timestamp desc;
235: BEGIN
236: l_run_time := sysdate;
237: fnd_file.put_line(fnd_file.log, 'Start Execution : '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
238: --
239: l_day_uom_code := FND_PROFILE.VALUE('DAY_UNIT_OF_MEASURE');
240: --
241: IF l_day_uom_code IS NULL THEN

Line 242: fnd_file.put_line(fnd_file.log,'DAY_UNIT_OF_MEASURE Profile Not Set..');

238: --
239: l_day_uom_code := FND_PROFILE.VALUE('DAY_UNIT_OF_MEASURE');
240: --
241: IF l_day_uom_code IS NULL THEN
242: fnd_file.put_line(fnd_file.log,'DAY_UNIT_OF_MEASURE Profile Not Set..');
243: errbuf := 'DAY_UNIT_OF_MEASURE Profile Not Set';
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246: --

Line 248: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');

244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246: --
247: FOR c_ctrs_rec IN CTR_CUR LOOP
248: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');
249: fnd_file.put_line(fnd_file.log, 'Fetched ctr-id '|| to_char(c_ctrs_rec.counter_id));
250: --
251: l_ctr_value_id := NULL;
252: l_ctr_rdg := NULL;

Line 249: fnd_file.put_line(fnd_file.log, 'Fetched ctr-id '|| to_char(c_ctrs_rec.counter_id));

245: END IF;
246: --
247: FOR c_ctrs_rec IN CTR_CUR LOOP
248: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');
249: fnd_file.put_line(fnd_file.log, 'Fetched ctr-id '|| to_char(c_ctrs_rec.counter_id));
250: --
251: l_ctr_value_id := NULL;
252: l_ctr_rdg := NULL;
253: l_timestamp := NULL;

Line 302: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');

298: END LOOP;
299: --
300: commit;
301: --
302: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');
303: fnd_file.put_line(fnd_file.log, 'Finished Execution : '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
304: --
305: -- Return 0 for successful completion, 1 for warnings, 2 for error
306: errbuf := '';

Line 303: fnd_file.put_line(fnd_file.log, 'Finished Execution : '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

299: --
300: commit;
301: --
302: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');
303: fnd_file.put_line(fnd_file.log, 'Finished Execution : '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
304: --
305: -- Return 0 for successful completion, 1 for warnings, 2 for error
306: errbuf := '';
307: retcode := 0;

Line 312: fnd_file.put_line(fnd_file.log,'Program Aborting....');

308: --
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: retcode := 2;
312: fnd_file.put_line(fnd_file.log,'Program Aborting....');
313: WHEN OTHERS THEN
314: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');
315: fnd_file.put_line(fnd_file.log,sqlerrm);
316: fnd_file.put_line(fnd_file.log,'Program Aborting....');

Line 314: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');

310: WHEN FND_API.G_EXC_ERROR THEN
311: retcode := 2;
312: fnd_file.put_line(fnd_file.log,'Program Aborting....');
313: WHEN OTHERS THEN
314: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');
315: fnd_file.put_line(fnd_file.log,sqlerrm);
316: fnd_file.put_line(fnd_file.log,'Program Aborting....');
317: errbuf := sqlerrm;
318: retcode := 2;

Line 315: fnd_file.put_line(fnd_file.log,sqlerrm);

311: retcode := 2;
312: fnd_file.put_line(fnd_file.log,'Program Aborting....');
313: WHEN OTHERS THEN
314: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');
315: fnd_file.put_line(fnd_file.log,sqlerrm);
316: fnd_file.put_line(fnd_file.log,'Program Aborting....');
317: errbuf := sqlerrm;
318: retcode := 2;
319: END Capture_Readings;

Line 316: fnd_file.put_line(fnd_file.log,'Program Aborting....');

312: fnd_file.put_line(fnd_file.log,'Program Aborting....');
313: WHEN OTHERS THEN
314: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');
315: fnd_file.put_line(fnd_file.log,sqlerrm);
316: fnd_file.put_line(fnd_file.log,'Program Aborting....');
317: errbuf := sqlerrm;
318: retcode := 2;
319: END Capture_Readings;
320: --