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_COUNTER_READINGS_PUB dependencies on CSI_CTR_GEN_UTILITY_PVT

Line 122: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

118: -- Initialize API return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120:
121: -- Read the debug profiles values in to global variable 7197402
122: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
123:
124: --
125: -- Check the profile option debug_level for debug message reporting
126: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

Line 128: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

124: --
125: -- Check the profile option debug_level for debug message reporting
126: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
127: --
128: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
129: csi_ctr_gen_utility_pvt.put_line( 'capture_counter_reading_pub' ||'-'||
130: p_api_version ||'-'||
131: nvl(p_commit,FND_API.G_FALSE) ||'-'||
132: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||

Line 129: csi_ctr_gen_utility_pvt.put_line( 'capture_counter_reading_pub' ||'-'||

125: -- Check the profile option debug_level for debug message reporting
126: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
127: --
128: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
129: csi_ctr_gen_utility_pvt.put_line( 'capture_counter_reading_pub' ||'-'||
130: p_api_version ||'-'||
131: nvl(p_commit,FND_API.G_FALSE) ||'-'||
132: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
133: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );

Line 137: csi_ctr_gen_utility_pvt.put_line('Transaction Information is empty. Cannot Proceed...');

133: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
134: END IF;
135: --
136: IF p_txn_tbl.count = 0 THEN
137: csi_ctr_gen_utility_pvt.put_line('Transaction Information is empty. Cannot Proceed...');
138: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_NO_TXN_TYPE_ID');
139: END IF;
140: --
141: FOR j in p_txn_tbl.FIRST .. p_txn_tbl.LAST LOOP

Line 138: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_NO_TXN_TYPE_ID');

134: END IF;
135: --
136: IF p_txn_tbl.count = 0 THEN
137: csi_ctr_gen_utility_pvt.put_line('Transaction Information is empty. Cannot Proceed...');
138: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_NO_TXN_TYPE_ID');
139: END IF;
140: --
141: FOR j in p_txn_tbl.FIRST .. p_txn_tbl.LAST LOOP
142: IF p_txn_tbl.EXISTS(j) THEN

Line 143: csi_ctr_gen_utility_pvt.put_line('Dumping Transaction Record # '||to_char(j));

139: END IF;
140: --
141: FOR j in p_txn_tbl.FIRST .. p_txn_tbl.LAST LOOP
142: IF p_txn_tbl.EXISTS(j) THEN
143: csi_ctr_gen_utility_pvt.put_line('Dumping Transaction Record # '||to_char(j));
144: csi_ctr_gen_utility_pvt.dump_txn_rec(p_txn_rec => p_txn_tbl(j));
145: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');
146: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
147: ( p_api_version => 1.0

Line 144: csi_ctr_gen_utility_pvt.dump_txn_rec(p_txn_rec => p_txn_tbl(j));

140: --
141: FOR j in p_txn_tbl.FIRST .. p_txn_tbl.LAST LOOP
142: IF p_txn_tbl.EXISTS(j) THEN
143: csi_ctr_gen_utility_pvt.put_line('Dumping Transaction Record # '||to_char(j));
144: csi_ctr_gen_utility_pvt.dump_txn_rec(p_txn_rec => p_txn_tbl(j));
145: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');
146: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
147: ( p_api_version => 1.0
148: ,p_commit => fnd_api.g_false

Line 145: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');

141: FOR j in p_txn_tbl.FIRST .. p_txn_tbl.LAST LOOP
142: IF p_txn_tbl.EXISTS(j) THEN
143: csi_ctr_gen_utility_pvt.put_line('Dumping Transaction Record # '||to_char(j));
144: csi_ctr_gen_utility_pvt.dump_txn_rec(p_txn_rec => p_txn_tbl(j));
145: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');
146: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
147: ( p_api_version => 1.0
148: ,p_commit => fnd_api.g_false
149: ,p_init_msg_list => fnd_api.g_true

Line 157: csi_ctr_gen_utility_pvt.put_line('Error from Create_Reading_Transaction...');

153: ,x_msg_count => x_msg_count
154: ,x_msg_data => x_msg_data
155: );
156: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
157: csi_ctr_gen_utility_pvt.put_line('Error from Create_Reading_Transaction...');
158: l_msg_index := 1;
159: FND_MSG_PUB.Count_And_Get
160: (p_count => x_msg_count,
161: p_data => x_msg_data

Line 168: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

164: WHILE l_msg_count > 0 LOOP
165: x_msg_data := FND_MSG_PUB.GET
166: ( l_msg_index,
167: FND_API.G_FALSE );
168: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
169: l_msg_index := l_msg_index + 1;
170: l_msg_count := l_msg_count - 1;
171: END LOOP;
172: RAISE FND_API.G_EXC_ERROR;

Line 193: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Pre API ');

189: ,x_msg_count => x_msg_count
190: ,x_msg_data => x_msg_data
191: );
192: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
193: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Pre API ');
194: l_msg_index := 1;
195: l_msg_count := x_msg_count;
196: WHILE l_msg_count > 0 LOOP
197: x_msg_data := FND_MSG_PUB.GET

Line 201: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

197: x_msg_data := FND_MSG_PUB.GET
198: ( l_msg_index,
199: FND_API.G_FALSE
200: );
201: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
202: l_msg_index := l_msg_index + 1;
203: l_msg_count := l_msg_count - 1;
204: END LOOP;
205: RAISE FND_API.G_EXC_ERROR;

Line 225: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Pre API ');

221: ,x_msg_count => x_msg_count
222: ,x_msg_data => x_msg_data
223: );
224: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
225: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Pre API ');
226: l_msg_index := 1;
227: l_msg_count := x_msg_count;
228: WHILE l_msg_count > 0 LOOP
229: x_msg_data := FND_MSG_PUB.GET

Line 233: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

229: x_msg_data := FND_MSG_PUB.GET
230: ( l_msg_index,
231: FND_API.G_FALSE
232: );
233: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
234: l_msg_index := l_msg_index + 1;
235: l_msg_count := l_msg_count - 1;
236: END LOOP;
237: RAISE FND_API.G_EXC_ERROR;

Line 245: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));

241: IF p_ctr_rdg_tbl.count > 0 THEN
242: FOR j IN p_ctr_rdg_tbl.FIRST .. p_ctr_rdg_tbl.LAST LOOP
243: IF p_ctr_rdg_tbl.EXISTS(j) THEN
244: -- Call Capture Counter reading PVT;
245: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));
246: IF NOT p_txn_tbl.EXISTS(p_ctr_rdg_tbl(j).parent_tbl_index) THEN
247: csi_ctr_gen_utility_pvt.put_line('Counter Reading record does not have a Transaction...');
248: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_RDG_NO_TXN');
249: END IF;

Line 247: csi_ctr_gen_utility_pvt.put_line('Counter Reading record does not have a Transaction...');

243: IF p_ctr_rdg_tbl.EXISTS(j) THEN
244: -- Call Capture Counter reading PVT;
245: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));
246: IF NOT p_txn_tbl.EXISTS(p_ctr_rdg_tbl(j).parent_tbl_index) THEN
247: csi_ctr_gen_utility_pvt.put_line('Counter Reading record does not have a Transaction...');
248: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_RDG_NO_TXN');
249: END IF;
250: --
251: -- Check whether this is Reset only reading.

Line 248: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_RDG_NO_TXN');

244: -- Call Capture Counter reading PVT;
245: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));
246: IF NOT p_txn_tbl.EXISTS(p_ctr_rdg_tbl(j).parent_tbl_index) THEN
247: csi_ctr_gen_utility_pvt.put_line('Counter Reading record does not have a Transaction...');
248: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_RDG_NO_TXN');
249: END IF;
250: --
251: -- Check whether this is Reset only reading.
252: -- This will decide whether to compute Derive counters or not

Line 267: csi_ctr_gen_utility_pvt.put_line('Calling Insert Meter Log...');

263: l_instance_id := p_txn_tbl(p_ctr_rdg_tbl(j).parent_tbl_index).source_header_ref_id;
264: ELSE
265: l_instance_id := null;
266: END IF;
267: csi_ctr_gen_utility_pvt.put_line('Calling Insert Meter Log...');
268: Eam_Asset_Log_Pvt.Insert_Meter_Log
269: (
270: P_api_version => 1.0,
271: P_init_msg_list => fnd_api.g_false,

Line 285: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Insert_Meter_Log API ');

281: -- Since this is only for logging we are ignoring the x_return_status.
282: -- Just report the API error and proceed.
283: --
284: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
285: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Insert_Meter_Log API ');
286: l_msg_index := 1;
287: l_msg_count := x_msg_count;
288: WHILE l_msg_count > 0 LOOP
289: x_msg_data := FND_MSG_PUB.GET

Line 293: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

289: x_msg_data := FND_MSG_PUB.GET
290: ( l_msg_index,
291: FND_API.G_FALSE
292: );
293: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
294: l_msg_index := l_msg_index + 1;
295: l_msg_count := l_msg_count - 1;
296: END LOOP;
297: -- DO NOT RAISE ERROR

Line 304: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Counter_Reading_pvt...');

300: --
301: --For bug 12536426 - Moved the code to call Update_Last_Service_Reading_Wo to
302: -- below Csi_Counter_Readings_Pvt.Capture_Counter_Reading
303: --
304: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Counter_Reading_pvt...');
305: Csi_Counter_Readings_Pvt.Capture_Counter_Reading
306: (
307: p_api_version => 1.0
308: ,p_commit => p_commit

Line 318: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Counter_Reading_pvt API ');

314: ,x_msg_count => x_msg_count
315: ,x_msg_data => x_msg_data
316: );
317: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
318: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Counter_Reading_pvt API ');
319: l_msg_index := 1;
320: l_msg_count := x_msg_count;
321: WHILE l_msg_count > 0 LOOP
322: x_msg_data := FND_MSG_PUB.GET

Line 326: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

322: x_msg_data := FND_MSG_PUB.GET
323: ( l_msg_index,
324: FND_API.G_FALSE
325: );
326: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
327: l_msg_index := l_msg_index + 1;
328: l_msg_count := l_msg_count - 1;
329: END LOOP;
330: RAISE FND_API.G_EXC_ERROR;

Line 335: csi_ctr_gen_utility_pvt.put_line('Calling Update_Last_Service_Reading_Wo...');

331: END IF;
332: --For bug 12536426, moved the code here as LifeToDate reading has to be paased
333: --to Update_Last_Service_Reading_Wo for change counters
334: IF p_txn_tbl(p_ctr_rdg_tbl(j).parent_tbl_index).transaction_type_id = 92 THEN
335: csi_ctr_gen_utility_pvt.put_line('Calling Update_Last_Service_Reading_Wo...');
336: BEGIN
337: SELECT reading_type
338: INTO l_reading_type
339: FROM csi_counters_b

Line 345: csi_ctr_gen_utility_pvt.put_line('l_reading_type'|| l_reading_type);

341: EXCEPTION
342: WHEN OTHERS THEN
343: NULL;
344: END;
345: csi_ctr_gen_utility_pvt.put_line('l_reading_type'|| l_reading_type);
346: csi_ctr_gen_utility_pvt.put_line('p_ctr_rdg_tbl(j).life_to_date_reading'|| p_ctr_rdg_tbl(j).life_to_date_reading);
347:
348: IF l_reading_type = 2 THEN
349: Eam_Meters_Util.Update_Last_Service_Reading_Wo

Line 346: csi_ctr_gen_utility_pvt.put_line('p_ctr_rdg_tbl(j).life_to_date_reading'|| p_ctr_rdg_tbl(j).life_to_date_reading);

342: WHEN OTHERS THEN
343: NULL;
344: END;
345: csi_ctr_gen_utility_pvt.put_line('l_reading_type'|| l_reading_type);
346: csi_ctr_gen_utility_pvt.put_line('p_ctr_rdg_tbl(j).life_to_date_reading'|| p_ctr_rdg_tbl(j).life_to_date_reading);
347:
348: IF l_reading_type = 2 THEN
349: Eam_Meters_Util.Update_Last_Service_Reading_Wo
350: (

Line 373: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Last_Service_Reading_Wo API ');

369: );
370: END IF;
371:
372: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
373: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Last_Service_Reading_Wo API ');
374: l_msg_index := 1;
375: l_msg_count := x_msg_count;
376: WHILE l_msg_count > 0 LOOP
377: x_msg_data := FND_MSG_PUB.GET

Line 381: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

377: x_msg_data := FND_MSG_PUB.GET
378: ( l_msg_index,
379: FND_API.G_FALSE
380: );
381: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
382: l_msg_index := l_msg_index + 1;
383: l_msg_count := l_msg_count - 1;
384: END LOOP;
385: RAISE FND_API.G_EXC_ERROR;

Line 396: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(p_ctr_prop_rdg_tbl(k));

392: IF p_ctr_prop_rdg_tbl(k).parent_tbl_index = j THEN
393: p_ctr_prop_rdg_tbl(k).counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
394: p_ctr_prop_rdg_tbl(k).value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
395: -- Call Property reading PVT;
396: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(p_ctr_prop_rdg_tbl(k));
397: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading...');
398: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
399: (
400: p_api_version => 1.0

Line 397: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading...');

393: p_ctr_prop_rdg_tbl(k).counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
394: p_ctr_prop_rdg_tbl(k).value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
395: -- Call Property reading PVT;
396: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(p_ctr_prop_rdg_tbl(k));
397: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading...');
398: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
399: (
400: p_api_version => 1.0
401: ,p_commit => p_commit

Line 410: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Ctr_Property_Reading API ');

406: ,x_msg_count => x_msg_count
407: ,x_msg_data => x_msg_data
408: );
409: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
410: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Ctr_Property_Reading API ');
411: l_msg_index := 1;
412: l_msg_count := x_msg_count;
413: WHILE l_msg_count > 0 LOOP
414: x_msg_data := FND_MSG_PUB.GET

Line 418: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

414: x_msg_data := FND_MSG_PUB.GET
415: ( l_msg_index,
416: FND_API.G_FALSE
417: );
418: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
419: l_msg_index := l_msg_index + 1;
420: l_msg_count := l_msg_count - 1;
421: END LOOP;
422: RAISE FND_API.G_EXC_ERROR;

Line 439: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(l_dflt_ctr_prop_rec);

435: l_dflt_ctr_prop_rec.property_value := dflt_rec.default_value;
436: l_dflt_ctr_prop_rec.value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
437: l_dflt_ctr_prop_rec.counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
438: --
439: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(l_dflt_ctr_prop_rec);
440: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading for Dflt Property');
441: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
442: (
443: p_api_version => 1.0

Line 440: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading for Dflt Property');

436: l_dflt_ctr_prop_rec.value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
437: l_dflt_ctr_prop_rec.counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
438: --
439: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(l_dflt_ctr_prop_rec);
440: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading for Dflt Property');
441: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
442: (
443: p_api_version => 1.0
444: ,p_commit => p_commit

Line 453: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Ctr_Property_Reading API ');

449: ,x_msg_count => x_msg_count
450: ,x_msg_data => x_msg_data
451: );
452: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
453: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Ctr_Property_Reading API ');
454: l_msg_index := 1;
455: l_msg_count := x_msg_count;
456: WHILE l_msg_count > 0 LOOP
457: x_msg_data := FND_MSG_PUB.GET

Line 461: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

457: x_msg_data := FND_MSG_PUB.GET
458: ( l_msg_index,
459: FND_API.G_FALSE
460: );
461: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
462: l_msg_index := l_msg_index + 1;
463: l_msg_count := l_msg_count - 1;
464: END LOOP;
465: RAISE FND_API.G_EXC_ERROR;

Line 481: csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters...');

477: l_derive_ctr_rec.source_code := p_ctr_rdg_tbl(j).source_code;
478: l_derive_ctr_rec.source_line_id := p_ctr_rdg_tbl(j).source_line_id;
479: --
480: -- Call Compute Derive Counters
481: csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters...');
482: Csi_Counter_Readings_Pvt.Compute_Derive_Counters
483: (
484: p_api_version => 1.0
485: ,p_commit => p_commit

Line 496: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');

492: ,x_msg_count => x_msg_count
493: ,x_msg_data => x_msg_data
494: );
495: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
496: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');
497: l_msg_index := 1;
498: l_msg_count := x_msg_count;
499: WHILE l_msg_count > 0 LOOP
500: x_msg_data := FND_MSG_PUB.GET

Line 504: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

500: x_msg_data := FND_MSG_PUB.GET
501: ( l_msg_index,
502: FND_API.G_FALSE
503: );
504: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
505: l_msg_index := l_msg_index + 1;
506: l_msg_count := l_msg_count - 1;
507: END LOOP;
508: RAISE FND_API.G_EXC_ERROR;

Line 523: csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters for Update...');

519: l_derive_ctr_rec.counter_value_id := later_rdg.counter_value_id;
520: l_derive_ctr_rec.counter_id := p_ctr_rdg_tbl(j).counter_id;
521: l_derive_ctr_rec.value_timestamp := later_rdg.value_timestamp;
522: --
523: csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters for Update...');
524: Csi_Counter_Readings_Pvt.Compute_Derive_Counters
525: (
526: p_api_version => 1.0
527: ,p_commit => p_commit

Line 538: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');

534: ,x_msg_count => x_msg_count
535: ,x_msg_data => x_msg_data
536: );
537: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
538: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');
539: l_msg_index := 1;
540: l_msg_count := x_msg_count;
541: WHILE l_msg_count > 0 LOOP
542: x_msg_data := FND_MSG_PUB.GET

Line 546: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

542: x_msg_data := FND_MSG_PUB.GET
543: ( l_msg_index,
544: FND_API.G_FALSE
545: );
546: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
547: l_msg_index := l_msg_index + 1;
548: l_msg_count := l_msg_count - 1;
549: END LOOP;
550: RAISE FND_API.G_EXC_ERROR;

Line 569: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Formula_Counters API ');

565: ,x_msg_count => x_msg_count
566: ,x_msg_data => x_msg_data
567: );
568: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
569: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Formula_Counters API ');
570: l_msg_index := 1;
571: l_msg_count := x_msg_count;
572: WHILE l_msg_count > 0 LOOP
573: x_msg_data := FND_MSG_PUB.GET

Line 577: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

573: x_msg_data := FND_MSG_PUB.GET
574: ( l_msg_index,
575: FND_API.G_FALSE
576: );
577: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
578: l_msg_index := l_msg_index + 1;
579: l_msg_count := l_msg_count - 1;
580: END LOOP;
581: RAISE FND_API.G_EXC_ERROR;

Line 588: csi_ctr_gen_utility_pvt.put_line('End of Private API Calls...');

584: END IF; -- Rdg rec exists
585: END LOOP; -- Ctr Reading Tbl Loop
586: END IF;
587: --
588: csi_ctr_gen_utility_pvt.put_line('End of Private API Calls...');
589: -- Calling Customer Post-processing Hook
590: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'C' ) ) then
591: CSI_COUNTER_READINGS_CUHK.CAPTURE_COUNTER_READING_POST
592: (

Line 605: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Post API ');

601: ,x_msg_count => x_msg_count
602: ,x_msg_data => x_msg_data
603: );
604: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
605: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Post API ');
606: l_msg_index := 1;
607: l_msg_count := x_msg_count;
608: WHILE l_msg_count > 0 LOOP
609: x_msg_data := FND_MSG_PUB.GET

Line 613: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

609: x_msg_data := FND_MSG_PUB.GET
610: ( l_msg_index,
611: FND_API.G_FALSE
612: );
613: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
614: l_msg_index := l_msg_index + 1;
615: l_msg_count := l_msg_count - 1;
616: END LOOP;
617: RAISE FND_API.G_EXC_ERROR;

Line 637: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Post API ');

633: ,x_msg_count => x_msg_count
634: ,x_msg_data => x_msg_data
635: );
636: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
637: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Post API ');
638: l_msg_index := 1;
639: l_msg_count := x_msg_count;
640: WHILE l_msg_count > 0 LOOP
641: x_msg_data := FND_MSG_PUB.GET

Line 645: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

641: x_msg_data := FND_MSG_PUB.GET
642: ( l_msg_index,
643: FND_API.G_FALSE
644: );
645: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
646: l_msg_index := l_msg_index + 1;
647: l_msg_count := l_msg_count - 1;
648: END LOOP;
649: RAISE FND_API.G_EXC_ERROR;

Line 693: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');

689: p_counter_id => p_ctr_rdg_tbl(J).counter_id
690: );
691:
692: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
693: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
694: l_msg_index := 1;
695: l_msg_count := x_msg_count;
696: WHILE l_msg_count > 0 LOOP
697: x_msg_data := FND_MSG_PUB.GET

Line 701: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

697: x_msg_data := FND_MSG_PUB.GET
698: ( l_msg_index,
699: FND_API.G_FALSE
700: );
701: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
702: l_msg_index := l_msg_index + 1;
703: l_msg_count := l_msg_count - 1;
704: END LOOP;
705: RAISE FND_API.G_EXC_ERROR;

Line 723: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');

719: x_msg_data => x_msg_data,
720: p_counter_id => l_assembler_tbl(J)
721: );
722: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
723: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
724: l_msg_index := 1;
725: l_msg_count := x_msg_count;
726: WHILE l_msg_count > 0 LOOP
727: x_msg_data := FND_MSG_PUB.GET

Line 731: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

727: x_msg_data := FND_MSG_PUB.GET
728: ( l_msg_index,
729: FND_API.G_FALSE
730: );
731: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
732: l_msg_index := l_msg_index + 1;
733: l_msg_count := l_msg_count - 1;
734: END LOOP;
735: RAISE FND_API.G_EXC_ERROR;

Line 746: csi_ctr_gen_utility_pvt.put_line('Capture Counter Reading Public API Successfully Completed...');

742: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
743: COMMIT WORK;
744: END IF;
745: --
746: csi_ctr_gen_utility_pvt.put_line('Capture Counter Reading Public API Successfully Completed...');
747: csi_ctr_gen_utility_pvt.put_line('*******************************************************************');
748: -- Standard call to get message count and IF count is get message info.
749: FND_MSG_PUB.Count_And_Get
750: ( p_count => x_msg_count,

Line 747: csi_ctr_gen_utility_pvt.put_line('*******************************************************************');

743: COMMIT WORK;
744: END IF;
745: --
746: csi_ctr_gen_utility_pvt.put_line('Capture Counter Reading Public API Successfully Completed...');
747: csi_ctr_gen_utility_pvt.put_line('*******************************************************************');
748: -- Standard call to get message count and IF count is get message info.
749: FND_MSG_PUB.Count_And_Get
750: ( p_count => x_msg_count,
751: p_data => x_msg_data

Line 867: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

863: -- Initialize API return status to success
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: -- Read the debug profiles values in to global variable 7197402
867: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
868:
869: --
870: -- Check the profile option debug_level for debug message reporting
871: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

Line 873: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

869: --
870: -- Check the profile option debug_level for debug message reporting
871: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
872: --
873: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
874: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');
875: END IF;
876: --
877: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 874: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');

870: -- Check the profile option debug_level for debug message reporting
871: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
872: --
873: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
874: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');
875: END IF;
876: --
877: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
878: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||

Line 877: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

873: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
874: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');
875: END IF;
876: --
877: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
878: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||
879: p_api_version ||'-'||
880: nvl(p_commit,FND_API.G_FALSE) ||'-'||
881: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||

Line 878: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||

874: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');
875: END IF;
876: --
877: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
878: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||
879: p_api_version ||'-'||
880: nvl(p_commit,FND_API.G_FALSE) ||'-'||
881: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
882: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );

Line 898: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Pre API ');

894: ,x_msg_count => x_msg_count
895: ,x_msg_data => x_msg_data
896: );
897: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
898: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Pre API ');
899: l_msg_index := 1;
900: l_msg_count := x_msg_count;
901: WHILE l_msg_count > 0 LOOP
902: x_msg_data := FND_MSG_PUB.GET

Line 906: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

902: x_msg_data := FND_MSG_PUB.GET
903: ( l_msg_index,
904: FND_API.G_FALSE
905: );
906: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
907: l_msg_index := l_msg_index + 1;
908: l_msg_count := l_msg_count - 1;
909: END LOOP;
910: RAISE FND_API.G_EXC_ERROR;

Line 928: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Pre API ');

924: ,x_msg_count => x_msg_count
925: ,x_msg_data => x_msg_data
926: );
927: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
928: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Pre API ');
929: l_msg_index := 1;
930: l_msg_count := x_msg_count;
931: WHILE l_msg_count > 0 LOOP
932: x_msg_data := FND_MSG_PUB.GET

Line 936: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

932: x_msg_data := FND_MSG_PUB.GET
933: ( l_msg_index,
934: FND_API.G_FALSE
935: );
936: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
937: l_msg_index := l_msg_index + 1;
938: l_msg_count := l_msg_count - 1;
939: END LOOP;
940: RAISE FND_API.G_EXC_ERROR;

Line 948: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));

944: IF p_ctr_rdg_tbl.count > 0 THEN
945: FOR j IN p_ctr_rdg_tbl.FIRST .. p_ctr_rdg_tbl.LAST LOOP
946: IF p_ctr_rdg_tbl.EXISTS(j) THEN
947: -- Call Update Counter reading PVT;
948: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));
949: csi_ctr_gen_utility_pvt.put_line('Calling Update_Counter_Reading_pvt...');
950: Csi_Counter_Readings_Pvt.Update_Counter_Reading
951: (
952: p_api_version => 1.0

Line 949: csi_ctr_gen_utility_pvt.put_line('Calling Update_Counter_Reading_pvt...');

945: FOR j IN p_ctr_rdg_tbl.FIRST .. p_ctr_rdg_tbl.LAST LOOP
946: IF p_ctr_rdg_tbl.EXISTS(j) THEN
947: -- Call Update Counter reading PVT;
948: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));
949: csi_ctr_gen_utility_pvt.put_line('Calling Update_Counter_Reading_pvt...');
950: Csi_Counter_Readings_Pvt.Update_Counter_Reading
951: (
952: p_api_version => 1.0
953: ,p_commit => p_commit

Line 962: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading_pvt API ');

958: ,x_msg_count => x_msg_count
959: ,x_msg_data => x_msg_data
960: );
961: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
962: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading_pvt API ');
963: l_msg_index := 1;
964: l_msg_count := x_msg_count;
965: WHILE l_msg_count > 0 LOOP
966: x_msg_data := FND_MSG_PUB.GET

Line 970: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

966: x_msg_data := FND_MSG_PUB.GET
967: ( l_msg_index,
968: FND_API.G_FALSE
969: );
970: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
971: l_msg_index := l_msg_index + 1;
972: l_msg_count := l_msg_count - 1;
973: END LOOP;
974: RAISE FND_API.G_EXC_ERROR;

Line 994: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Post API ');

990: ,x_msg_count => x_msg_count
991: ,x_msg_data => x_msg_data
992: );
993: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
994: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Post API ');
995: l_msg_index := 1;
996: l_msg_count := x_msg_count;
997: WHILE l_msg_count > 0 LOOP
998: x_msg_data := FND_MSG_PUB.GET

Line 1002: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

998: x_msg_data := FND_MSG_PUB.GET
999: ( l_msg_index,
1000: FND_API.G_FALSE
1001: );
1002: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1003: l_msg_index := l_msg_index + 1;
1004: l_msg_count := l_msg_count - 1;
1005: END LOOP;
1006: RAISE FND_API.G_EXC_ERROR;

Line 1024: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Post API ');

1020: ,x_msg_count => x_msg_count
1021: ,x_msg_data => x_msg_data
1022: );
1023: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1024: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Post API ');
1025: l_msg_index := 1;
1026: l_msg_count := x_msg_count;
1027: WHILE l_msg_count > 0 LOOP
1028: x_msg_data := FND_MSG_PUB.GET

Line 1032: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1028: x_msg_data := FND_MSG_PUB.GET
1029: ( l_msg_index,
1030: FND_API.G_FALSE
1031: );
1032: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1033: l_msg_index := l_msg_index + 1;
1034: l_msg_count := l_msg_count - 1;
1035: END LOOP;
1036: RAISE FND_API.G_EXC_ERROR;

Line 1078: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');

1074: x_msg_data => x_msg_data,
1075: p_counter_id => p_ctr_rdg_tbl(J).counter_id
1076: );
1077: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1078: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
1079: l_msg_index := 1;
1080: l_msg_count := x_msg_count;
1081: WHILE l_msg_count > 0 LOOP
1082: x_msg_data := FND_MSG_PUB.GET

Line 1086: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1082: x_msg_data := FND_MSG_PUB.GET
1083: ( l_msg_index,
1084: FND_API.G_FALSE
1085: );
1086: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1087: l_msg_index := l_msg_index + 1;
1088: l_msg_count := l_msg_count - 1;
1089: END LOOP;
1090: RAISE FND_API.G_EXC_ERROR;

Line 1109: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');

1105: x_msg_data => x_msg_data,
1106: p_counter_id => l_assembler_tbl(J)
1107: );
1108: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1109: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
1110: l_msg_index := 1;
1111: l_msg_count := x_msg_count;
1112: WHILE l_msg_count > 0 LOOP
1113: x_msg_data := FND_MSG_PUB.GET

Line 1117: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1113: x_msg_data := FND_MSG_PUB.GET
1114: ( l_msg_index,
1115: FND_API.G_FALSE
1116: );
1117: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1118: l_msg_index := l_msg_index + 1;
1119: l_msg_count := l_msg_count - 1;
1120: END LOOP;
1121: RAISE FND_API.G_EXC_ERROR;