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.6 2006/03/02 21:56:10 mmaduska 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.6 2006/03/02 21:56:10 mmaduska 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 508: '==================== Exiting EAM_MeterReading_PUB.create_meter_reading ====================');

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

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

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

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

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

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

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

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

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 ,
623: p_api_version ,

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

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

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

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

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

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

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

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

Line 771: END EAM_METERREADING_PUB;

767: END IF;
768:
769: END disable_meter_reading;
770:
771: END EAM_METERREADING_PUB;