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.EAM_METERREADING_PUB dependencies on FND_LOG

Line 33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

29:
30: l_api_name CONSTANT VARCHAR2(30) :='check_wip_entity_id';
31: l_module varchar2(200) ;
32:
33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37: BEGIN

Line 34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

30: l_api_name CONSTANT VARCHAR2(30) :='check_wip_entity_id';
31: l_module varchar2(200) ;
32:
33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37: BEGIN
38: IF (l_ulog) THEN

Line 35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

31: l_module varchar2(200) ;
32:
33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37: BEGIN
38: IF (l_ulog) THEN
39: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;

Line 36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

32:
33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37: BEGIN
38: IF (l_ulog) THEN
39: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
40: END IF;

Line 43: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

39: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
40: END IF;
41:
42: IF (l_plog) THEN
43: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
44: '==================== Entered EAM_MeterReading_PUB.check_wip_entity_id ====================');
45: END IF;
46:
47: SELECT maintenance_object_id into x_maintenance_object_id

Line 52: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

48: FROM wip_discrete_jobs
49: WHERE wip_entity_id = p_wip_entity_id
50: AND maintenance_object_type = 3;
51: IF (l_plog) THEN
52: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
53: 'x_maintenance_object_id:'||x_maintenance_object_id);
54: END IF;
55:
56:

Line 66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

62: AND nvl(ccr.source_counter_id (+),csa.counter_id) = p_meter_id
63: and CCR.ACTIVE_END_DATE (+) >= sysdate ;
64:
65: IF (l_plog) THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
67: 'l_count:'||l_count);
68: END IF;
69: IF l_count = 0 then
70: raise_error ('EAM_MTR_WO_INVALID'); -- Specified meter is invalid for this work order.

Line 74: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

70: raise_error ('EAM_MTR_WO_INVALID'); -- Specified meter is invalid for this work order.
71: END IF;
72:
73: IF (l_plog) THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
75: '==================== Exiting from EAM_MeterReading_PUB.check_wip_entity_id ====================');
76: END IF;
77: EXCEPTION
78: WHEN no_data_found THEN

Line 116: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

112: l_csi_txn_tbl Csi_Datastructures_PUB.transaction_tbl;
113:
114: l_module varchar2(200);
115:
116: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
117: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
118: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
119: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
120:

Line 117: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

113:
114: l_module varchar2(200);
115:
116: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
117: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
118: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
119: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
120:
121: BEGIN

Line 118: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

114: l_module varchar2(200);
115:
116: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
117: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
118: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
119: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
120:
121: BEGIN
122: -- Standard Start of API savepoint

Line 119: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

115:
116: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
117: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
118: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
119: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
120:
121: BEGIN
122: -- Standard Start of API savepoint
123: SAVEPOINT create_meter_reading_Pub;

Line 129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

125: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
126: END IF;
127:
128: IF (l_plog) THEN
129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
130: '==================== Entered EAM_MeterReading_PUB.create_meter_reading ====================');
131: END IF;
132: -- Standard call to check for call compatibility.
133:

Line 164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

160:
161: -- Check if the asset for which the current work order is raised has the current counter associated to it.
162: IF l_wip_entity_id IS NOT NULL THEN
163: IF (l_plog) THEN
164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
165: '==================== Calling check_wip_entity_id ====================');
166: END IF;
167: check_wip_entity_id (l_wip_entity_id , p_meter_reading_rec.meter_id);
168: IF (l_plog) THEN

Line 169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

165: '==================== Calling check_wip_entity_id ====================');
166: END IF;
167: check_wip_entity_id (l_wip_entity_id , p_meter_reading_rec.meter_id);
168: IF (l_plog) THEN
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
170: '==================== Returning from check_wip_entity_id ====================');
171: END IF;
172: END IF;
173:

Line 294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

290: END IF;
291:
292: -- Call to CSI API to create counter reading.
293: IF (l_plog) THEN
294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
295: '==================== Calling Csi_Counter_Readings_PUB.Capture_Counter_reading ===================='
296: ||'x_return_status:'||x_return_status
297: ||' x_msg_count:'||x_msg_count
298: ||'x_msg_data:'||x_msg_data);

Line 311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

307: x_return_status => x_return_status,
308: x_msg_count => x_msg_count,
309: x_msg_data => x_msg_data);
310: IF (l_plog) THEN
311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
312: '==================== Returning from Csi_Counter_Readings_PUB.Capture_Counter_reading ===================='
313: ||'x_return_status:'||x_return_status
314: ||' x_msg_count:'||x_msg_count
315: ||'x_msg_data:'||x_msg_data);

Line 326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Committed Work');

322: -- Standard check of p_commit.
323: IF FND_API.To_Boolean( p_commit ) THEN
324: COMMIT WORK;
325: IF (l_plog) THEN
326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Committed Work');
327: END IF;
328: END IF;
329: IF (l_plog) THEN
330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Committed Work');
327: END IF;
328: END IF;
329: IF (l_plog) THEN
330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
331: '==================== Exiting from EAM_MeterReading_PUB.create_meter_reading ====================');
332: END IF;
333:
334:

Line 340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');

336: WHEN FND_API.G_EXC_ERROR THEN
337: ROLLBACK TO create_meter_reading_Pub;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: IF (l_plog) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
342: '===================EAM_MeterReading_PUB.create_meter_readingr: EXPECTED ERROR======='||
343: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
344: END IF;

Line 341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

337: ROLLBACK TO create_meter_reading_Pub;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: IF (l_plog) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
342: '===================EAM_MeterReading_PUB.create_meter_readingr: EXPECTED ERROR======='||
343: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
344: END IF;
345: FND_MSG_PUB.Count_And_Get

Line 350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

346: ( p_count => x_msg_count ,
347: p_data => x_msg_data
348: );
349: IF (l_plog) THEN
350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
351: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
352: END IF;
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO create_meter_reading_Pub;

Line 357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');

353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO create_meter_reading_Pub;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356: IF (l_plog) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
359: '===================EAM_MeterReading_PUB.create_meter_readingr: UNEXPECTED ERROR======='||
360: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
361: END IF;

Line 358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

354: ROLLBACK TO create_meter_reading_Pub;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356: IF (l_plog) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
359: '===================EAM_MeterReading_PUB.create_meter_readingr: UNEXPECTED ERROR======='||
360: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
361: END IF;
362: FND_MSG_PUB.Count_And_Get

Line 367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

363: ( p_count => x_msg_count ,
364: p_data => x_msg_data
365: );
366: IF (l_plog) THEN
367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
368: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
369: END IF;
370: WHEN OTHERS THEN
371: ROLLBACK TO create_meter_reading_Pub;

Line 374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');

370: WHEN OTHERS THEN
371: ROLLBACK TO create_meter_reading_Pub;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: IF (l_plog) THEN
374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
376: '=================== EAM_MeterReading_PUB.create_meter_reading: OTHERS ERROR=======');
377: END IF;
378: IF FND_MSG_PUB.Check_Msg_Level

Line 375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

371: ROLLBACK TO create_meter_reading_Pub;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: IF (l_plog) THEN
374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
376: '=================== EAM_MeterReading_PUB.create_meter_reading: OTHERS ERROR=======');
377: END IF;
378: IF FND_MSG_PUB.Check_Msg_Level
379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

378: IF FND_MSG_PUB.Check_Msg_Level
379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: IF (l_plog) THEN
382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
383: '==================== Calling FND_MSG_PUB.Add_Exc_Msg ====================');
384: END IF;
385: FND_MSG_PUB.Add_Exc_Msg
386: ( G_PKG_NAME ,

Line 390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

386: ( G_PKG_NAME ,
387: l_api_name
388: );
389: IF (l_plog) THEN
390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
391: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
392: END IF;
393: END IF;
394: IF (l_plog) THEN

Line 395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

391: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
392: END IF;
393: END IF;
394: IF (l_plog) THEN
395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
396: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
397: END IF;
398: FND_MSG_PUB.Count_And_Get
399: ( p_count => x_msg_count ,

Line 403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

399: ( p_count => x_msg_count ,
400: p_data => x_msg_data
401: );
402: IF (l_plog) THEN
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
404: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
405: END IF;
406: END create_meter_reading;
407:

Line 432: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

428: l_return_status VARCHAR2(1);
429: l_meter_reading_id NUMBER;
430:
431: l_module varchar2(200) ;
432: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
433: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
434: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
435: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
436:

Line 433: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

429: l_meter_reading_id NUMBER;
430:
431: l_module varchar2(200) ;
432: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
433: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
434: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
435: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
436:
437:

Line 434: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

430:
431: l_module varchar2(200) ;
432: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
433: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
434: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
435: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
436:
437:
438: BEGIN

Line 435: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

431: l_module varchar2(200) ;
432: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
433: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
434: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
435: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
436:
437:
438: BEGIN
439: -- Standard Start of API savepoint

Line 446: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

442: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
443: END IF;
444:
445: IF (l_plog) THEN
446: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
447: '==================== Entered EAM_MeterReading_PUB.create_meter_reading ====================');
448: END IF;
449: -- Standard call to check for call compatibility.
450:

Line 472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

468:
469: -- API body
470: l_ctr_property_readings_tbl.DELETE;
471: IF (l_plog) THEN
472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
473: '==================== Calling EAM_MeterReading_PUB.create_meter_reading ===================='
474: ||'l_return_status:'||l_return_status
475: ||' l_msg_count:'||l_msg_count
476: ||'l_msg_data:'||l_msg_data);

Line 490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

486: p_value_before_reset => p_value_before_reset,
487: p_ignore_warnings => p_ignore_warnings,
488: x_meter_reading_id => l_meter_reading_id);
489: IF (l_plog) THEN
490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
491: '==================== Returned from EAM_MeterReading_PUB.create_meter_reading ===================='
492: ||'l_return_status:'||l_return_status
493: ||' l_msg_count:'||l_msg_count
494: ||'l_msg_data:'||l_msg_data);

Line 503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');

499: IF FND_API.To_Boolean( p_commit ) THEN
500:
501: COMMIT WORK;
502: IF (l_plog) THEN
503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');
504: END IF;
505: END IF;
506: IF (l_plog) THEN
507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');
504: END IF;
505: END IF;
506: IF (l_plog) THEN
507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
508: '==================== Exiting EAM_MeterReading_PUB.create_meter_reading ====================');
509: END IF;
510:
511:

Line 517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');

513: WHEN FND_API.G_EXC_ERROR THEN
514: ROLLBACK TO create_meter_reading_Pub;
515: x_return_status := FND_API.G_RET_STS_ERROR ;
516: IF (l_plog) THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
519: '===================EAM_MeterReading_PUB.create_meter_reading: EXPECTED ERROR======='||
520: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
521: END IF;

Line 518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

514: ROLLBACK TO create_meter_reading_Pub;
515: x_return_status := FND_API.G_RET_STS_ERROR ;
516: IF (l_plog) THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
519: '===================EAM_MeterReading_PUB.create_meter_reading: EXPECTED ERROR======='||
520: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
521: END IF;
522: FND_MSG_PUB.Count_And_Get

Line 527: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

523: ( p_count => x_msg_count ,
524: p_data => x_msg_data
525: );
526: IF (l_plog) THEN
527: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
528: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
529: END IF;
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: ROLLBACK TO create_meter_reading_Pub;

Line 534: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');

530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: ROLLBACK TO create_meter_reading_Pub;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: IF (l_plog) THEN
534: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
535: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
536: '===================EAM_MeterReading_PUB.create_meter_reading: UNEXPECTED ERROR======='||
537: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
538: END IF;

Line 535: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

531: ROLLBACK TO create_meter_reading_Pub;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: IF (l_plog) THEN
534: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
535: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
536: '===================EAM_MeterReading_PUB.create_meter_reading: UNEXPECTED ERROR======='||
537: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
538: END IF;
539: FND_MSG_PUB.Count_And_Get

Line 544: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

540: ( p_count => x_msg_count ,
541: p_data => x_msg_data
542: );
543: IF (l_plog) THEN
544: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
545: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
546: END IF;
547: WHEN OTHERS THEN
548: ROLLBACK TO create_meter_reading_Pub;

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');

547: WHEN OTHERS THEN
548: ROLLBACK TO create_meter_reading_Pub;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
550: IF (l_plog) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
553: '===================EAM_MeterReading_PUB.create_meter_reading: OTHERS ERROR=======');
554: END IF;
555: IF FND_MSG_PUB.Check_Msg_Level

Line 552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

548: ROLLBACK TO create_meter_reading_Pub;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
550: IF (l_plog) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
553: '===================EAM_MeterReading_PUB.create_meter_reading: OTHERS ERROR=======');
554: END IF;
555: IF FND_MSG_PUB.Check_Msg_Level
556: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

555: IF FND_MSG_PUB.Check_Msg_Level
556: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: IF (l_plog) THEN
559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
560: '==================== Calling FND_MSG_PUB.Add_Exc_Msg ====================');
561: END IF;
562: FND_MSG_PUB.Add_Exc_Msg
563: ( G_PKG_NAME ,

Line 567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

563: ( G_PKG_NAME ,
564: l_api_name
565: );
566: IF (l_plog) THEN
567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
568: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
569: END IF;
570: END IF;
571: IF (l_plog) THEN

Line 572: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

568: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
569: END IF;
570: END IF;
571: IF (l_plog) THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
573: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
574: END IF;
575: FND_MSG_PUB.Count_And_Get
576: ( p_count => x_msg_count ,

Line 580: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

576: ( p_count => x_msg_count ,
577: p_data => x_msg_data
578: );
579: IF (l_plog) THEN
580: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
581: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
582: END IF;
583: END create_meter_reading;
584:

Line 605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

601: l_object_version_number Number;
602: l_ctr_rdg_tbl Csi_Ctr_Datastructures_PUB.Counter_Readings_Tbl;
603:
604: l_module varchar2(200);
605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
609:

Line 606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;

602: l_ctr_rdg_tbl Csi_Ctr_Datastructures_PUB.Counter_Readings_Tbl;
603:
604: l_module varchar2(200);
605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
609:
610: BEGIN

Line 607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

603:
604: l_module varchar2(200);
605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
609:
610: BEGIN
611:

Line 608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

604: l_module varchar2(200);
605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
609:
610: BEGIN
611:
612: SAVEPOINT disable_meter_reading_pub;

Line 618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

614: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
615: END IF;
616:
617: IF (l_plog) THEN
618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
619: '==================== Entered EAM_MeterReading_PUB.disable_meter_reading_pub ====================');
620: END IF;
621: -- Standard call to check for call compatibility.
622: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 647: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

643: INTO l_object_version_number
644: FROM csi_counter_readings
645: WHERE counter_value_id = p_meter_reading_id;
646: IF (l_plog) THEN
647: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
648: 'l_object_version_number: '||l_object_version_number);
649: END IF;
650:
651: -- Assigning values for the Counter readings record

Line 660: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

656: l_ctr_rdg_tbl(1).disabled_flag := 'Y';
657:
658: -- Call to CSI API to disable counter reading.
659: IF (l_plog) THEN
660: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
661: '==================== Calling Csi_Counter_Readings_PUB.Update_Counter_Reading ===================='
662: ||'x_return_status:'||x_return_status
663: ||' x_msg_count:'||x_msg_count
664: ||'x_msg_data:'||x_msg_data);

Line 675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

671: x_return_status => x_return_status,
672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data);
674: IF (l_plog) THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
676: '==================== Exiting from Csi_Counter_Readings_PUB.Update_Counter_Reading ===================='
677: ||'x_return_status:'||x_return_status
678: ||' x_msg_count:'||x_msg_count
679: ||'x_msg_data:'||x_msg_data);

Line 687: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Committed Work');

683: -- Standard check of p_commit.
684: IF FND_API.To_Boolean( p_commit ) THEN
685: COMMIT WORK;
686: IF (l_plog) THEN
687: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Committed Work');
688: END IF;
689: END IF;
690: IF (l_plog) THEN
691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

687: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Committed Work');
688: END IF;
689: END IF;
690: IF (l_plog) THEN
691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
692: '==================== Exiting EAM_MeterReading_PUB.disable_meter_reading_pub ====================');
693: END IF;
694: EXCEPTION
695: WHEN FND_API.G_EXC_ERROR THEN

Line 700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');

696:
697: ROLLBACK TO disable_meter_reading_pub;
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: IF (l_plog) THEN
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
702: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: EXPECTED ERROR======='||
703: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
704: END IF;

Line 701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

697: ROLLBACK TO disable_meter_reading_pub;
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: IF (l_plog) THEN
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
702: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: EXPECTED ERROR======='||
703: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
704: END IF;
705: FND_MSG_PUB.Count_And_Get

Line 710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

706: ( p_count => x_msg_count ,
707: p_data => x_msg_data
708: );
709: IF (l_plog) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
711: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
712: END IF;
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
714:

Line 718: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');

714:
715: ROLLBACK TO disable_meter_reading_pub;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
717: IF (l_plog) THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
720: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: UNEXPECTED ERROR======='||
721: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
722: END IF;

Line 719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

715: ROLLBACK TO disable_meter_reading_pub;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
717: IF (l_plog) THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
720: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: UNEXPECTED ERROR======='||
721: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
722: END IF;
723: FND_MSG_PUB.Count_And_Get

Line 728: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

724: ( p_count => x_msg_count ,
725: p_data => x_msg_data
726: );
727: IF (l_plog) THEN
728: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
729: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
730: END IF;
731: WHEN OTHERS THEN
732:

Line 736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');

732:
733: ROLLBACK TO disable_meter_reading_pub;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: IF (l_plog) THEN
736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
738: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: OTHERS ERROR=======');
739: END IF;
740: IF FND_MSG_PUB.Check_Msg_Level

Line 737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

733: ROLLBACK TO disable_meter_reading_pub;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: IF (l_plog) THEN
736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
738: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: OTHERS ERROR=======');
739: END IF;
740: IF FND_MSG_PUB.Check_Msg_Level
741: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 744: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

740: IF FND_MSG_PUB.Check_Msg_Level
741: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
742: THEN
743: IF (l_plog) THEN
744: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
745: '==================== Calling FND_MSG_PUB.Add_Exc_Msg ====================');
746: END IF;
747: FND_MSG_PUB.Add_Exc_Msg
748: ( G_PKG_NAME ,

Line 752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

748: ( G_PKG_NAME ,
749: l_api_name
750: );
751: IF (l_plog) THEN
752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
753: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
754: END IF;
755: END IF;
756: IF (l_plog) THEN

Line 757: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

753: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
754: END IF;
755: END IF;
756: IF (l_plog) THEN
757: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
758: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
759: END IF;
760: FND_MSG_PUB.Count_And_Get
761: ( p_count => x_msg_count ,

Line 765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

761: ( p_count => x_msg_count ,
762: p_data => x_msg_data
763: );
764: IF (l_plog) THEN
765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
766: '==================== Returned from FND_MSG_PUB.Count_And_Get ====================');
767: END IF;
768:
769: END disable_meter_reading;