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 28: fnd_file.put_line(fnd_file.log, 'Inside Increment_Reading...');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: Rollback To Increment_Reading;
194: fnd_file.put_line(fnd_file.log,'Into when others error in Increment_Reading...');
195: fnd_file.put_line(fnd_file.log,sqlerrm);
196: END Increment_Reading;
197: --
198:
199: FUNCTION DOES_FORMULA_COUNTER_EXISTS

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

282:
283: BEGIN
284: l_run_time := sysdate;
285: l_conc_start_time := l_run_time;
286: fnd_file.put_line(fnd_file.log, 'Start Execution : '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
287: --
288: l_day_uom_code := FND_PROFILE.VALUE('DAY_UNIT_OF_MEASURE');
289: l_hour_uom_code := FND_PROFILE.VALUE('HOUR_UNIT_OF_MEASURE');
290: l_ignore_time_component := FND_PROFILE.VALUE('CSI_IGNORE_TIME_COMPONENT');

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

289: l_hour_uom_code := FND_PROFILE.VALUE('HOUR_UNIT_OF_MEASURE');
290: l_ignore_time_component := FND_PROFILE.VALUE('CSI_IGNORE_TIME_COMPONENT');
291: --
292: IF l_day_uom_code IS NULL THEN
293: fnd_file.put_line(fnd_file.log,'DAY_UNIT_OF_MEASURE Profile Not Set..');
294: errbuf := 'DAY_UNIT_OF_MEASURE Profile Not Set';
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: --

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

319:
320: --FOR i IN time_ctr_array.first..time_ctr_array.last --bug 16041167
321: FOR i IN 1..time_ctr_array.COUNT
322: loop
323: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');
324: -- fnd_file.put_line(fnd_file.log, 'Fetched ctr-id '|| to_char(time_ctr_array(i).counter_id));
325:
326: -- Bug 9210555
327: --

Line 324: -- fnd_file.put_line(fnd_file.log, 'Fetched ctr-id '|| to_char(time_ctr_array(i).counter_id));

320: --FOR i IN time_ctr_array.first..time_ctr_array.last --bug 16041167
321: FOR i IN 1..time_ctr_array.COUNT
322: loop
323: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');
324: -- fnd_file.put_line(fnd_file.log, 'Fetched ctr-id '|| to_char(time_ctr_array(i).counter_id));
325:
326: -- Bug 9210555
327: --
328: -- If "CSI: Ignore Counter time component" profile is set to 'Y'

Line 341: fnd_file.put_line(fnd_file.log, 'Truncating time component from concurrent program start time');

337: -- In case of Hour Based Counter Minutes/Seconds will be truncated
338:
339: IF (UPPER(time_ctr_array(i).uom_code) = l_day_uom_code)
340: AND ( NVL(l_ignore_time_component,'N') = 'Y') THEN
341: fnd_file.put_line(fnd_file.log, 'Truncating time component from concurrent program start time');
342: l_run_time := trunc(to_date(sysdate), 'DDD');
343: l_ctr_creation_date := trunc(to_date(time_ctr_array(i).creation_date), 'DDD');
344: ELSIF (UPPER(time_ctr_array(i).uom_code) = l_hour_uom_code)
345: AND ( NVL(l_ignore_time_component,'N') = 'Y') THEN

Line 347: fnd_file.put_line(fnd_file.log, 'Truncating minutes/seconds component from concurrent program start time');

343: l_ctr_creation_date := trunc(to_date(time_ctr_array(i).creation_date), 'DDD');
344: ELSIF (UPPER(time_ctr_array(i).uom_code) = l_hour_uom_code)
345: AND ( NVL(l_ignore_time_component,'N') = 'Y') THEN
346: -- ER 9285073
347: fnd_file.put_line(fnd_file.log, 'Truncating minutes/seconds component from concurrent program start time');
348: l_run_time := trunc(l_conc_start_time, 'HH');
349: l_ctr_creation_date := trunc(time_ctr_array(i).creation_date, 'HH');
350: ELSE
351: fnd_file.put_line(fnd_file.log, 'Retaining concurrent program start time');

Line 351: fnd_file.put_line(fnd_file.log, 'Retaining concurrent program start time');

347: fnd_file.put_line(fnd_file.log, 'Truncating minutes/seconds component from concurrent program start time');
348: l_run_time := trunc(l_conc_start_time, 'HH');
349: l_ctr_creation_date := trunc(time_ctr_array(i).creation_date, 'HH');
350: ELSE
351: fnd_file.put_line(fnd_file.log, 'Retaining concurrent program start time');
352: l_run_time := l_conc_start_time;
353: l_ctr_creation_date := time_ctr_array(i).creation_date;
354: END IF;
355:

Line 370: fnd_file.put_line(fnd_file.log, 'l_days '|| l_days);

366: CLOSE RDG_CUR;
367:
368: --
369: l_days := l_run_time - nvl(l_timestamp,l_ctr_creation_date);
370: fnd_file.put_line(fnd_file.log, 'l_days '|| l_days);
371: fnd_file.put_line(fnd_file.log, 'l_run_time'|| to_char(l_run_time, 'DD-MON-YYYY HH24:MI:SS'));
372: fnd_file.put_line(fnd_file.log, 'l_timestamp'|| to_char(l_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
373: fnd_file.put_line(fnd_file.log, 'l_day_uom_code'|| to_char(l_day_uom_code));
374: fnd_file.put_line(fnd_file.log, 'l_hour_uom_code'|| to_char(l_hour_uom_code));

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

367:
368: --
369: l_days := l_run_time - nvl(l_timestamp,l_ctr_creation_date);
370: fnd_file.put_line(fnd_file.log, 'l_days '|| l_days);
371: fnd_file.put_line(fnd_file.log, 'l_run_time'|| to_char(l_run_time, 'DD-MON-YYYY HH24:MI:SS'));
372: fnd_file.put_line(fnd_file.log, 'l_timestamp'|| to_char(l_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
373: fnd_file.put_line(fnd_file.log, 'l_day_uom_code'|| to_char(l_day_uom_code));
374: fnd_file.put_line(fnd_file.log, 'l_hour_uom_code'|| to_char(l_hour_uom_code));
375: fnd_file.put_line(fnd_file.log, 'time_ctr_array(i).uom_code'|| to_char(time_ctr_array(i).uom_code));

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

368: --
369: l_days := l_run_time - nvl(l_timestamp,l_ctr_creation_date);
370: fnd_file.put_line(fnd_file.log, 'l_days '|| l_days);
371: fnd_file.put_line(fnd_file.log, 'l_run_time'|| to_char(l_run_time, 'DD-MON-YYYY HH24:MI:SS'));
372: fnd_file.put_line(fnd_file.log, 'l_timestamp'|| to_char(l_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
373: fnd_file.put_line(fnd_file.log, 'l_day_uom_code'|| to_char(l_day_uom_code));
374: fnd_file.put_line(fnd_file.log, 'l_hour_uom_code'|| to_char(l_hour_uom_code));
375: fnd_file.put_line(fnd_file.log, 'time_ctr_array(i).uom_code'|| to_char(time_ctr_array(i).uom_code));
376: IF l_days = 0 THEN

Line 373: fnd_file.put_line(fnd_file.log, 'l_day_uom_code'|| to_char(l_day_uom_code));

369: l_days := l_run_time - nvl(l_timestamp,l_ctr_creation_date);
370: fnd_file.put_line(fnd_file.log, 'l_days '|| l_days);
371: fnd_file.put_line(fnd_file.log, 'l_run_time'|| to_char(l_run_time, 'DD-MON-YYYY HH24:MI:SS'));
372: fnd_file.put_line(fnd_file.log, 'l_timestamp'|| to_char(l_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
373: fnd_file.put_line(fnd_file.log, 'l_day_uom_code'|| to_char(l_day_uom_code));
374: fnd_file.put_line(fnd_file.log, 'l_hour_uom_code'|| to_char(l_hour_uom_code));
375: fnd_file.put_line(fnd_file.log, 'time_ctr_array(i).uom_code'|| to_char(time_ctr_array(i).uom_code));
376: IF l_days = 0 THEN
377: l_incr_rdg := 0;

Line 374: fnd_file.put_line(fnd_file.log, 'l_hour_uom_code'|| to_char(l_hour_uom_code));

370: fnd_file.put_line(fnd_file.log, 'l_days '|| l_days);
371: fnd_file.put_line(fnd_file.log, 'l_run_time'|| to_char(l_run_time, 'DD-MON-YYYY HH24:MI:SS'));
372: fnd_file.put_line(fnd_file.log, 'l_timestamp'|| to_char(l_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
373: fnd_file.put_line(fnd_file.log, 'l_day_uom_code'|| to_char(l_day_uom_code));
374: fnd_file.put_line(fnd_file.log, 'l_hour_uom_code'|| to_char(l_hour_uom_code));
375: fnd_file.put_line(fnd_file.log, 'time_ctr_array(i).uom_code'|| to_char(time_ctr_array(i).uom_code));
376: IF l_days = 0 THEN
377: l_incr_rdg := 0;
378: ELSE

Line 375: fnd_file.put_line(fnd_file.log, 'time_ctr_array(i).uom_code'|| to_char(time_ctr_array(i).uom_code));

371: fnd_file.put_line(fnd_file.log, 'l_run_time'|| to_char(l_run_time, 'DD-MON-YYYY HH24:MI:SS'));
372: fnd_file.put_line(fnd_file.log, 'l_timestamp'|| to_char(l_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
373: fnd_file.put_line(fnd_file.log, 'l_day_uom_code'|| to_char(l_day_uom_code));
374: fnd_file.put_line(fnd_file.log, 'l_hour_uom_code'|| to_char(l_hour_uom_code));
375: fnd_file.put_line(fnd_file.log, 'time_ctr_array(i).uom_code'|| to_char(time_ctr_array(i).uom_code));
376: IF l_days = 0 THEN
377: l_incr_rdg := 0;
378: ELSE
379: l_incr_rdg := oks_time_measures_pub.get_target_qty

Line 388: fnd_file.put_line(fnd_file.log, 'l_incr_rdg'|| to_char(l_incr_rdg));

384: p_round_dec => 1
385: );
386: END IF;
387: --
388: fnd_file.put_line(fnd_file.log, 'l_incr_rdg'|| to_char(l_incr_rdg));
389: IF l_incr_rdg >= 1 THEN
390: IF l_ctr_value_id IS NULL THEN
391: -- This is the first rdg being captured
392: l_new_rdg := l_incr_rdg;

Line 418: fnd_file.put_line(fnd_file.log, 'Formual Counter Updating');

414: -- Bug 9283089
415: -- Verify if formula counter exists for source counter id or not
416: IF (DOES_FORMULA_COUNTER_EXISTS(time_ctr_array(i).counter_id)) THEN
417:
418: fnd_file.put_line(fnd_file.log, 'Formual Counter Updating');
419:
420: --
421: -- Bug 9386676
422: /* bug 15972103

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

435: ,x_msg_count => x_msg_count
436: ,x_msg_data => x_msg_data
437: );*/
438: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
439: fnd_file.put_line(fnd_file.log,'Error from Create_Reading_Transaction...');
440: l_msg_index := 1;
441: FND_MSG_PUB.Count_And_Get
442: (p_count => x_msg_count,
443: p_data => x_msg_data

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

446: WHILE l_msg_count > 0 LOOP
447: x_msg_data := FND_MSG_PUB.GET
448: ( l_msg_index,
449: FND_API.G_FALSE );
450: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
451: l_msg_index := l_msg_index + 1;
452: l_msg_count := l_msg_count - 1;
453: END LOOP;
454: RAISE FND_API.G_EXC_ERROR;

Line 466: fnd_file.put_line(fnd_file.log, 'l_txn_rec.transaction_id - '|| l_txn_rec.transaction_id);

462: -- the same run time is used for formula counter as well
463: l_formula_ctr_rec.value_timestamp := l_run_time;
464:
465: --l_formula_ctr_rec.disabled_flag := 'Y';
466: fnd_file.put_line(fnd_file.log, 'l_txn_rec.transaction_id - '|| l_txn_rec.transaction_id);
467: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.value_timestamp - '||to_char(l_formula_ctr_rec.value_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
468: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.counter_id - '||l_formula_ctr_rec.counter_id);
469: fnd_file.put_line(fnd_file.log, 'Calling Compute_Formula_Counters');
470:

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

463: l_formula_ctr_rec.value_timestamp := l_run_time;
464:
465: --l_formula_ctr_rec.disabled_flag := 'Y';
466: fnd_file.put_line(fnd_file.log, 'l_txn_rec.transaction_id - '|| l_txn_rec.transaction_id);
467: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.value_timestamp - '||to_char(l_formula_ctr_rec.value_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
468: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.counter_id - '||l_formula_ctr_rec.counter_id);
469: fnd_file.put_line(fnd_file.log, 'Calling Compute_Formula_Counters');
470:
471: CSI_COUNTER_READINGS_PVT.Compute_Formula_Counters

Line 468: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.counter_id - '||l_formula_ctr_rec.counter_id);

464:
465: --l_formula_ctr_rec.disabled_flag := 'Y';
466: fnd_file.put_line(fnd_file.log, 'l_txn_rec.transaction_id - '|| l_txn_rec.transaction_id);
467: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.value_timestamp - '||to_char(l_formula_ctr_rec.value_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
468: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.counter_id - '||l_formula_ctr_rec.counter_id);
469: fnd_file.put_line(fnd_file.log, 'Calling Compute_Formula_Counters');
470:
471: CSI_COUNTER_READINGS_PVT.Compute_Formula_Counters
472: (

Line 469: fnd_file.put_line(fnd_file.log, 'Calling Compute_Formula_Counters');

465: --l_formula_ctr_rec.disabled_flag := 'Y';
466: fnd_file.put_line(fnd_file.log, 'l_txn_rec.transaction_id - '|| l_txn_rec.transaction_id);
467: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.value_timestamp - '||to_char(l_formula_ctr_rec.value_timestamp, 'DD-MON-YYYY HH24:MI:SS'));
468: fnd_file.put_line(fnd_file.log, 'l_formula_ctr_rec.counter_id - '||l_formula_ctr_rec.counter_id);
469: fnd_file.put_line(fnd_file.log, 'Calling Compute_Formula_Counters');
470:
471: CSI_COUNTER_READINGS_PVT.Compute_Formula_Counters
472: (
473: p_api_version => 1.0

Line 484: fnd_file.put_line(fnd_file.log, 'Error from Compute_Formula_Counters API');

480: ,x_msg_count => x_msg_count
481: ,x_msg_data => x_msg_data
482: );
483: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
484: fnd_file.put_line(fnd_file.log, 'Error from Compute_Formula_Counters API');
485: l_msg_index := 1;
486: l_msg_count := x_msg_count;
487: WHILE l_msg_count > 0 LOOP
488: x_msg_data := FND_MSG_PUB.GET

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

488: x_msg_data := FND_MSG_PUB.GET
489: ( l_msg_index,
490: FND_API.G_FALSE
491: );
492: fnd_file.put_line(fnd_file.log, 'MESSAGE DATA = '||x_msg_data);
493: l_msg_index := l_msg_index + 1;
494: l_msg_count := l_msg_count - 1;
495: END LOOP;
496: RAISE FND_API.G_EXC_ERROR;

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

510: end loop;
511: EXIT WHEN ctr_cur%NOTFOUND;
512: END LOOP;
513:
514: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');
515: fnd_file.put_line(fnd_file.log, 'Finished Execution : '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
516: --
517: -- Return 0 for successful completion, 1 for warnings, 2 for error
518: errbuf := '';

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

511: EXIT WHEN ctr_cur%NOTFOUND;
512: END LOOP;
513:
514: fnd_file.put_line(fnd_file.log, '------------------------------------------------------');
515: fnd_file.put_line(fnd_file.log, 'Finished Execution : '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
516: --
517: -- Return 0 for successful completion, 1 for warnings, 2 for error
518: errbuf := '';
519: retcode := 0;

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

520: --
521: EXCEPTION
522: WHEN FND_API.G_EXC_ERROR THEN
523: retcode := 2;
524: fnd_file.put_line(fnd_file.log,'Program Aborting....');
525: WHEN OTHERS THEN
526: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');
527: fnd_file.put_line(fnd_file.log,sqlerrm);
528: fnd_file.put_line(fnd_file.log,'Program Aborting....');

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

522: WHEN FND_API.G_EXC_ERROR THEN
523: retcode := 2;
524: fnd_file.put_line(fnd_file.log,'Program Aborting....');
525: WHEN OTHERS THEN
526: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');
527: fnd_file.put_line(fnd_file.log,sqlerrm);
528: fnd_file.put_line(fnd_file.log,'Program Aborting....');
529: errbuf := sqlerrm;
530: retcode := 2;

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

523: retcode := 2;
524: fnd_file.put_line(fnd_file.log,'Program Aborting....');
525: WHEN OTHERS THEN
526: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');
527: fnd_file.put_line(fnd_file.log,sqlerrm);
528: fnd_file.put_line(fnd_file.log,'Program Aborting....');
529: errbuf := sqlerrm;
530: retcode := 2;
531: END Capture_Readings;

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

524: fnd_file.put_line(fnd_file.log,'Program Aborting....');
525: WHEN OTHERS THEN
526: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');
527: fnd_file.put_line(fnd_file.log,sqlerrm);
528: fnd_file.put_line(fnd_file.log,'Program Aborting....');
529: errbuf := sqlerrm;
530: retcode := 2;
531: END Capture_Readings;
532: --