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 121: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

297: END IF;
298: END IF; -- EAM Logging Check
299: --
300: IF p_txn_tbl(p_ctr_rdg_tbl(j).parent_tbl_index).transaction_type_id = 92 THEN
301: csi_ctr_gen_utility_pvt.put_line('Calling Update_Last_Service_Reading_Wo...');
302: Eam_Meters_Util.Update_Last_Service_Reading_Wo
303: (
304: p_wip_entity_id => p_txn_tbl(p_ctr_rdg_tbl(j).parent_tbl_index).source_header_ref_id,
305: p_meter_id => p_ctr_rdg_tbl(j).counter_id,

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

309: X_msg_count => x_msg_count,
310: X_msg_data => x_msg_data
311: );
312: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
313: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Last_Service_Reading_Wo API ');
314: l_msg_index := 1;
315: l_msg_count := x_msg_count;
316: WHILE l_msg_count > 0 LOOP
317: x_msg_data := FND_MSG_PUB.GET

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

317: x_msg_data := FND_MSG_PUB.GET
318: ( l_msg_index,
319: FND_API.G_FALSE
320: );
321: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
322: l_msg_index := l_msg_index + 1;
323: l_msg_count := l_msg_count - 1;
324: END LOOP;
325: RAISE FND_API.G_EXC_ERROR;

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

325: RAISE FND_API.G_EXC_ERROR;
326: END IF;
327: END IF; -- Call Update_Last_Service_Reading_WO check
328: --
329: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Counter_Reading_pvt...');
330: Csi_Counter_Readings_Pvt.Capture_Counter_Reading
331: (
332: p_api_version => 1.0
333: ,p_commit => p_commit

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

339: ,x_msg_count => x_msg_count
340: ,x_msg_data => x_msg_data
341: );
342: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
343: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Counter_Reading_pvt API ');
344: l_msg_index := 1;
345: l_msg_count := x_msg_count;
346: WHILE l_msg_count > 0 LOOP
347: x_msg_data := FND_MSG_PUB.GET

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

347: x_msg_data := FND_MSG_PUB.GET
348: ( l_msg_index,
349: FND_API.G_FALSE
350: );
351: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
352: l_msg_index := l_msg_index + 1;
353: l_msg_count := l_msg_count - 1;
354: END LOOP;
355: RAISE FND_API.G_EXC_ERROR;

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

361: IF p_ctr_prop_rdg_tbl(k).parent_tbl_index = j THEN
362: p_ctr_prop_rdg_tbl(k).counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
363: p_ctr_prop_rdg_tbl(k).value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
364: -- Call Property reading PVT;
365: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(p_ctr_prop_rdg_tbl(k));
366: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading...');
367: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
368: (
369: p_api_version => 1.0

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

362: p_ctr_prop_rdg_tbl(k).counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
363: p_ctr_prop_rdg_tbl(k).value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
364: -- Call Property reading PVT;
365: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(p_ctr_prop_rdg_tbl(k));
366: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading...');
367: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
368: (
369: p_api_version => 1.0
370: ,p_commit => p_commit

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

375: ,x_msg_count => x_msg_count
376: ,x_msg_data => x_msg_data
377: );
378: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
379: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Ctr_Property_Reading API ');
380: l_msg_index := 1;
381: l_msg_count := x_msg_count;
382: WHILE l_msg_count > 0 LOOP
383: x_msg_data := FND_MSG_PUB.GET

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

383: x_msg_data := FND_MSG_PUB.GET
384: ( l_msg_index,
385: FND_API.G_FALSE
386: );
387: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
388: l_msg_index := l_msg_index + 1;
389: l_msg_count := l_msg_count - 1;
390: END LOOP;
391: RAISE FND_API.G_EXC_ERROR;

Line 408: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(l_dflt_ctr_prop_rec);

404: l_dflt_ctr_prop_rec.property_value := dflt_rec.default_value;
405: l_dflt_ctr_prop_rec.value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
406: l_dflt_ctr_prop_rec.counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
407: --
408: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(l_dflt_ctr_prop_rec);
409: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading for Dflt Property');
410: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
411: (
412: p_api_version => 1.0

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

405: l_dflt_ctr_prop_rec.value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
406: l_dflt_ctr_prop_rec.counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
407: --
408: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(l_dflt_ctr_prop_rec);
409: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading for Dflt Property');
410: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
411: (
412: p_api_version => 1.0
413: ,p_commit => p_commit

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

418: ,x_msg_count => x_msg_count
419: ,x_msg_data => x_msg_data
420: );
421: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
422: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Ctr_Property_Reading API ');
423: l_msg_index := 1;
424: l_msg_count := x_msg_count;
425: WHILE l_msg_count > 0 LOOP
426: x_msg_data := FND_MSG_PUB.GET

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

426: x_msg_data := FND_MSG_PUB.GET
427: ( l_msg_index,
428: FND_API.G_FALSE
429: );
430: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
431: l_msg_index := l_msg_index + 1;
432: l_msg_count := l_msg_count - 1;
433: END LOOP;
434: RAISE FND_API.G_EXC_ERROR;

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

446: l_derive_ctr_rec.source_code := p_ctr_rdg_tbl(j).source_code;
447: l_derive_ctr_rec.source_line_id := p_ctr_rdg_tbl(j).source_line_id;
448: --
449: -- Call Compute Derive Counters
450: csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters...');
451: Csi_Counter_Readings_Pvt.Compute_Derive_Counters
452: (
453: p_api_version => 1.0
454: ,p_commit => p_commit

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

461: ,x_msg_count => x_msg_count
462: ,x_msg_data => x_msg_data
463: );
464: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
465: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');
466: l_msg_index := 1;
467: l_msg_count := x_msg_count;
468: WHILE l_msg_count > 0 LOOP
469: x_msg_data := FND_MSG_PUB.GET

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

469: x_msg_data := FND_MSG_PUB.GET
470: ( l_msg_index,
471: FND_API.G_FALSE
472: );
473: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
474: l_msg_index := l_msg_index + 1;
475: l_msg_count := l_msg_count - 1;
476: END LOOP;
477: RAISE FND_API.G_EXC_ERROR;

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

488: l_derive_ctr_rec.counter_value_id := later_rdg.counter_value_id;
489: l_derive_ctr_rec.counter_id := p_ctr_rdg_tbl(j).counter_id;
490: l_derive_ctr_rec.value_timestamp := later_rdg.value_timestamp;
491: --
492: csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters for Update...');
493: Csi_Counter_Readings_Pvt.Compute_Derive_Counters
494: (
495: p_api_version => 1.0
496: ,p_commit => p_commit

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

503: ,x_msg_count => x_msg_count
504: ,x_msg_data => x_msg_data
505: );
506: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
507: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');
508: l_msg_index := 1;
509: l_msg_count := x_msg_count;
510: WHILE l_msg_count > 0 LOOP
511: x_msg_data := FND_MSG_PUB.GET

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

511: x_msg_data := FND_MSG_PUB.GET
512: ( l_msg_index,
513: FND_API.G_FALSE
514: );
515: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
516: l_msg_index := l_msg_index + 1;
517: l_msg_count := l_msg_count - 1;
518: END LOOP;
519: RAISE FND_API.G_EXC_ERROR;

Line 538: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Formula_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_Formula_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 557: csi_ctr_gen_utility_pvt.put_line('End of Private API Calls...');

553: END IF; -- Rdg rec exists
554: END LOOP; -- Ctr Reading Tbl Loop
555: END IF;
556: --
557: csi_ctr_gen_utility_pvt.put_line('End of Private API Calls...');
558: -- Calling Customer Post-processing Hook
559: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'C' ) ) then
560: CSI_COUNTER_READINGS_CUHK.CAPTURE_COUNTER_READING_POST
561: (

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

570: ,x_msg_count => x_msg_count
571: ,x_msg_data => x_msg_data
572: );
573: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
574: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Post API ');
575: l_msg_index := 1;
576: l_msg_count := x_msg_count;
577: WHILE l_msg_count > 0 LOOP
578: x_msg_data := FND_MSG_PUB.GET

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

578: x_msg_data := FND_MSG_PUB.GET
579: ( l_msg_index,
580: FND_API.G_FALSE
581: );
582: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
583: l_msg_index := l_msg_index + 1;
584: l_msg_count := l_msg_count - 1;
585: END LOOP;
586: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

658: p_counter_id => p_ctr_rdg_tbl(J).counter_id
659: );
660:
661: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
662: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
663: l_msg_index := 1;
664: l_msg_count := x_msg_count;
665: WHILE l_msg_count > 0 LOOP
666: x_msg_data := FND_MSG_PUB.GET

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

666: x_msg_data := FND_MSG_PUB.GET
667: ( l_msg_index,
668: FND_API.G_FALSE
669: );
670: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
671: l_msg_index := l_msg_index + 1;
672: l_msg_count := l_msg_count - 1;
673: END LOOP;
674: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

711: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
712: COMMIT WORK;
713: END IF;
714: --
715: csi_ctr_gen_utility_pvt.put_line('Capture Counter Reading Public API Successfully Completed...');
716: csi_ctr_gen_utility_pvt.put_line('*******************************************************************');
717: -- Standard call to get message count and IF count is get message info.
718: FND_MSG_PUB.Count_And_Get
719: ( p_count => x_msg_count,

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

712: COMMIT WORK;
713: END IF;
714: --
715: csi_ctr_gen_utility_pvt.put_line('Capture Counter Reading Public API Successfully Completed...');
716: csi_ctr_gen_utility_pvt.put_line('*******************************************************************');
717: -- Standard call to get message count and IF count is get message info.
718: FND_MSG_PUB.Count_And_Get
719: ( p_count => x_msg_count,
720: p_data => x_msg_data

Line 836: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

832: -- Initialize API return status to success
833: x_return_status := FND_API.G_RET_STS_SUCCESS;
834:
835: -- Read the debug profiles values in to global variable 7197402
836: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
837:
838: --
839: -- Check the profile option debug_level for debug message reporting
840: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

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

838: --
839: -- Check the profile option debug_level for debug message reporting
840: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
841: --
842: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
843: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');
844: END IF;
845: --
846: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

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

839: -- Check the profile option debug_level for debug message reporting
840: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
841: --
842: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
843: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');
844: END IF;
845: --
846: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
847: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||

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

842: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
843: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');
844: END IF;
845: --
846: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
847: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||
848: p_api_version ||'-'||
849: nvl(p_commit,FND_API.G_FALSE) ||'-'||
850: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||

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

843: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');
844: END IF;
845: --
846: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
847: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||
848: p_api_version ||'-'||
849: nvl(p_commit,FND_API.G_FALSE) ||'-'||
850: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
851: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );

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

863: ,x_msg_count => x_msg_count
864: ,x_msg_data => x_msg_data
865: );
866: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
867: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Pre API ');
868: l_msg_index := 1;
869: l_msg_count := x_msg_count;
870: WHILE l_msg_count > 0 LOOP
871: x_msg_data := FND_MSG_PUB.GET

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

871: x_msg_data := FND_MSG_PUB.GET
872: ( l_msg_index,
873: FND_API.G_FALSE
874: );
875: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
876: l_msg_index := l_msg_index + 1;
877: l_msg_count := l_msg_count - 1;
878: END LOOP;
879: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

913: IF p_ctr_rdg_tbl.count > 0 THEN
914: FOR j IN p_ctr_rdg_tbl.FIRST .. p_ctr_rdg_tbl.LAST LOOP
915: IF p_ctr_rdg_tbl.EXISTS(j) THEN
916: -- Call Update Counter reading PVT;
917: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));
918: csi_ctr_gen_utility_pvt.put_line('Calling Update_Counter_Reading_pvt...');
919: Csi_Counter_Readings_Pvt.Update_Counter_Reading
920: (
921: p_api_version => 1.0

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

914: FOR j IN p_ctr_rdg_tbl.FIRST .. p_ctr_rdg_tbl.LAST LOOP
915: IF p_ctr_rdg_tbl.EXISTS(j) THEN
916: -- Call Update Counter reading PVT;
917: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));
918: csi_ctr_gen_utility_pvt.put_line('Calling Update_Counter_Reading_pvt...');
919: Csi_Counter_Readings_Pvt.Update_Counter_Reading
920: (
921: p_api_version => 1.0
922: ,p_commit => p_commit

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

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

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

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

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

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

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

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

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

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

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

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

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

1043: x_msg_data => x_msg_data,
1044: p_counter_id => p_ctr_rdg_tbl(J).counter_id
1045: );
1046: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1047: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
1048: l_msg_index := 1;
1049: l_msg_count := x_msg_count;
1050: WHILE l_msg_count > 0 LOOP
1051: x_msg_data := FND_MSG_PUB.GET

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

1051: x_msg_data := FND_MSG_PUB.GET
1052: ( l_msg_index,
1053: FND_API.G_FALSE
1054: );
1055: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1056: l_msg_index := l_msg_index + 1;
1057: l_msg_count := l_msg_count - 1;
1058: END LOOP;
1059: 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 => l_assembler_tbl(J)
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;