DBA Data[Home] [Help]

APPS.EAM_METERREADING_PUB dependencies on EAM_METERREADING_PUB

Line 1: PACKAGE BODY EAM_METERREADING_PUB as

1: PACKAGE BODY EAM_METERREADING_PUB as
2: /* $Header: EAMPMTRB.pls 120.7 2011/08/11 15:01:14 srkotika ship $ */
3:
4: -- Start of comments
5: -- API name: EAM_MeterReading_PUB

Line 5: -- API name: EAM_MeterReading_PUB

1: PACKAGE BODY EAM_METERREADING_PUB as
2: /* $Header: EAMPMTRB.pls 120.7 2011/08/11 15:01:14 srkotika ship $ */
3:
4: -- Start of comments
5: -- API name: EAM_MeterReading_PUB
6: -- Type : Public
7: -- Function: Create new meter reading; disable existing meter reading
8: -- Pre-reqs: None.
9: -- Version : Current version 1.0

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_MeterReading_PUB';

8: -- Pre-reqs: None.
9: -- Version : Current version 1.0
10: -- End of comments
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_MeterReading_PUB';
13:
14:
15: -- Procedure for raising errors
16: PROCEDURE RAISE_ERROR (ERROR VARCHAR2)

Line 44: '==================== Entered EAM_MeterReading_PUB.check_wip_entity_id ====================');

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
48: FROM wip_discrete_jobs

Line 75: '==================== Exiting from EAM_MeterReading_PUB.check_wip_entity_id ====================');

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
79: --Invalid work order

Line 95: p_meter_reading_rec IN Eam_MeterReading_PUB.Meter_Reading_Rec_Type,

91: p_commit IN varchar2:=FND_API.G_FALSE,
92: x_msg_count OUT NOCOPY number,
93: x_msg_data OUT NOCOPY varchar2,
94: x_return_status OUT NOCOPY varchar2,
95: p_meter_reading_rec IN Eam_MeterReading_PUB.Meter_Reading_Rec_Type,
96: p_ctr_property_readings_tbl IN EAM_MeterReading_PUB.Ctr_Property_readings_Tbl,
97: p_value_before_reset IN number:=NULL,
98: p_ignore_warnings IN varchar2 := 'Y',
99: x_meter_reading_id OUT NOCOPY number

Line 96: p_ctr_property_readings_tbl IN EAM_MeterReading_PUB.Ctr_Property_readings_Tbl,

92: x_msg_count OUT NOCOPY number,
93: x_msg_data OUT NOCOPY varchar2,
94: x_return_status OUT NOCOPY varchar2,
95: p_meter_reading_rec IN Eam_MeterReading_PUB.Meter_Reading_Rec_Type,
96: p_ctr_property_readings_tbl IN EAM_MeterReading_PUB.Ctr_Property_readings_Tbl,
97: p_value_before_reset IN number:=NULL,
98: p_ignore_warnings IN varchar2 := 'Y',
99: x_meter_reading_id OUT NOCOPY number
100: )

Line 130: '==================== Entered EAM_MeterReading_PUB.create_meter_reading ====================');

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:
134:

Line 331: '==================== Exiting from EAM_MeterReading_PUB.create_meter_reading ====================');

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:
335: EXCEPTION

Line 342: '===================EAM_MeterReading_PUB.create_meter_readingr: EXPECTED ERROR======='||

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
346: ( p_count => x_msg_count ,

Line 359: '===================EAM_MeterReading_PUB.create_meter_readingr: UNEXPECTED ERROR======='||

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
363: ( p_count => x_msg_count ,

Line 376: '=================== EAM_MeterReading_PUB.create_meter_reading: OTHERS ERROR=======');

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)
380: THEN

Line 416: p_meter_reading_rec IN EAM_MeterReading_PUB.Meter_Reading_Rec_Type,

412: p_commit IN varchar2 := FND_API.G_FALSE,
413: x_msg_count OUT NOCOPY number,
414: x_msg_data OUT NOCOPY varchar2,
415: x_return_status OUT NOCOPY varchar2,
416: p_meter_reading_rec IN EAM_MeterReading_PUB.Meter_Reading_Rec_Type,
417: p_value_before_reset IN number := NULL,
418: p_ignore_warnings IN varchar2 := 'Y',
419: x_meter_reading_id OUT NOCOPY number
420: )

Line 425: l_ctr_property_readings_tbl EAM_MeterReading_PUB.Ctr_Property_readings_Tbl;

421: IS
422:
423: l_api_name CONSTANT varchar2(30) := 'create_meter_reading';
424: l_api_version CONSTANT number := 1.0;
425: l_ctr_property_readings_tbl EAM_MeterReading_PUB.Ctr_Property_readings_Tbl;
426: l_msg_count NUMBER;
427: l_msg_data VARCHAR2(5000);
428: l_return_status VARCHAR2(1);
429: l_meter_reading_id NUMBER;

Line 447: '==================== Entered EAM_MeterReading_PUB.create_meter_reading ====================');

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:
451:

Line 473: '==================== Calling EAM_MeterReading_PUB.create_meter_reading ===================='

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);
477: END IF;

Line 478: EAM_MeterReading_PUB.create_meter_reading(p_api_version => p_api_version,

474: ||'l_return_status:'||l_return_status
475: ||' l_msg_count:'||l_msg_count
476: ||'l_msg_data:'||l_msg_data);
477: END IF;
478: EAM_MeterReading_PUB.create_meter_reading(p_api_version => p_api_version,
479: p_init_msg_list => p_init_msg_list,
480: p_commit => p_commit,
481: x_msg_count => l_msg_count,
482: x_msg_data => l_msg_data,

Line 491: '==================== Returned from EAM_MeterReading_PUB.create_meter_reading ===================='

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);
495: END IF;

Line 515: '==================== Exiting EAM_MeterReading_PUB.create_meter_reading ====================');

511: END IF;
512: END IF;
513: IF (l_plog) THEN
514: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
515: '==================== Exiting EAM_MeterReading_PUB.create_meter_reading ====================');
516: END IF;
517:
518:
519: EXCEPTION

Line 526: '===================EAM_MeterReading_PUB.create_meter_reading: EXPECTED ERROR======='||

522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: IF (l_plog) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
525: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
526: '===================EAM_MeterReading_PUB.create_meter_reading: EXPECTED ERROR======='||
527: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
528: END IF;
529: FND_MSG_PUB.Count_And_Get
530: ( p_count => x_msg_count ,

Line 543: '===================EAM_MeterReading_PUB.create_meter_reading: UNEXPECTED ERROR======='||

539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
540: IF (l_plog) THEN
541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
543: '===================EAM_MeterReading_PUB.create_meter_reading: UNEXPECTED ERROR======='||
544: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
545: END IF;
546: FND_MSG_PUB.Count_And_Get
547: ( p_count => x_msg_count ,

Line 560: '===================EAM_MeterReading_PUB.create_meter_reading: OTHERS ERROR=======');

556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: IF (l_plog) THEN
558: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_reading_Pub');
559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
560: '===================EAM_MeterReading_PUB.create_meter_reading: OTHERS ERROR=======');
561: END IF;
562: IF FND_MSG_PUB.Check_Msg_Level
563: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
564: THEN

Line 626: '==================== Entered EAM_MeterReading_PUB.disable_meter_reading_pub ====================');

622: END IF;
623:
624: IF (l_plog) THEN
625: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
626: '==================== Entered EAM_MeterReading_PUB.disable_meter_reading_pub ====================');
627: END IF;
628: -- Standard call to check for call compatibility.
629: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
630: p_api_version ,

Line 699: '==================== Exiting EAM_MeterReading_PUB.disable_meter_reading_pub ====================');

695: END IF;
696: END IF;
697: IF (l_plog) THEN
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
699: '==================== Exiting EAM_MeterReading_PUB.disable_meter_reading_pub ====================');
700: END IF;
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703:

Line 709: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: EXPECTED ERROR======='||

705: x_return_status := FND_API.G_RET_STS_ERROR ;
706: IF (l_plog) THEN
707: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
709: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: EXPECTED ERROR======='||
710: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
711: END IF;
712: FND_MSG_PUB.Count_And_Get
713: ( p_count => x_msg_count ,

Line 727: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: UNEXPECTED ERROR======='||

723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
724: IF (l_plog) THEN
725: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
727: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: UNEXPECTED ERROR======='||
728: '==================== Calling FND_MSG_PUB.Count_And_Get ====================');
729: END IF;
730: FND_MSG_PUB.Count_And_Get
731: ( p_count => x_msg_count ,

Line 745: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: OTHERS ERROR=======');

741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: IF (l_plog) THEN
743: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO disable_meter_reading_pub');
744: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
745: '===================EAM_MeterReading_PUB.disable_meter_reading_pub: OTHERS ERROR=======');
746: END IF;
747: IF FND_MSG_PUB.Check_Msg_Level
748: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
749: THEN

Line 778: END EAM_METERREADING_PUB;

774: END IF;
775:
776: END disable_meter_reading;
777:
778: END EAM_METERREADING_PUB;