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_METER_PUB dependencies on FND_API

Line 23: -- Default = FND_API.G_FALSE

19: -- Pre-reqs : None.
20: -- Parameters :
21: -- IN : p_api_version IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- p_commit IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 25: -- Default = FND_API.G_FALSE

21: -- IN : p_api_version IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- p_commit IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL
28: -- parameter1
29: -- parameter2

Line 27: -- Default = FND_API.G_VALID_LEVEL_FULL

23: -- Default = FND_API.G_FALSE
24: -- p_commit IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL
28: -- parameter1
29: -- parameter2
30:
31: -- OUT : x_return_status OUT VARCHAR2(1)

Line 41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

37:
38: procedure create_meter
39: (
40: p_api_version IN Number ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT nocopy VARCHAR2,
45: x_msg_count OUT nocopy NUMBER,

Line 42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

38: procedure create_meter
39: (
40: p_api_version IN Number ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT nocopy VARCHAR2,
45: x_msg_count OUT nocopy NUMBER,
46: x_msg_data OUT nocopy VARCHAR2,

Line 43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

39: (
40: p_api_version IN Number ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT nocopy VARCHAR2,
45: x_msg_count OUT nocopy NUMBER,
46: x_msg_data OUT nocopy VARCHAR2,
47: p_meter_name IN VARCHAR2,

Line 146: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

142: '==================== Entered EAM_METER_PUB.create_meter ====================');
143: END IF;
144:
145: -- Standard call to check for call compatibility.
146: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
147: p_api_version ,
148: l_api_name ,
149: G_PKG_NAME )
150: THEN

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: p_api_version ,
148: l_api_name ,
149: G_PKG_NAME )
150: THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153:
154: l_commit := p_commit;
155: l_init_msg_list := p_init_msg_list;

Line 159: l_commit := FND_API.G_TRUE;

155: l_init_msg_list := p_init_msg_list;
156: l_validation_level := p_validation_level;
157:
158: IF l_commit IS NULL THEN
159: l_commit := FND_API.G_TRUE;
160: END IF;
161:
162: IF l_init_msg_list IS NULL THEN
163: l_init_msg_list := FND_API.G_TRUE;

Line 163: l_init_msg_list := FND_API.G_TRUE;

159: l_commit := FND_API.G_TRUE;
160: END IF;
161:
162: IF l_init_msg_list IS NULL THEN
163: l_init_msg_list := FND_API.G_TRUE;
164: END IF;
165:
166: IF l_validation_level IS NULL THEN
167: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

Line 167: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

163: l_init_msg_list := FND_API.G_TRUE;
164: END IF;
165:
166: IF l_validation_level IS NULL THEN
167: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
168: END IF;
169:
170: -- Initialize message list if p_init_msg_list is set to TRUE.
171: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 171: IF FND_API.to_Boolean( l_init_msg_list ) THEN

167: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
168: END IF;
169:
170: -- Initialize message list if p_init_msg_list is set to TRUE.
171: IF FND_API.to_Boolean( l_init_msg_list ) THEN
172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: -- Initialize API return status to success

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: -- Initialize API return status to success
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: -- API body
179:
180: l_ctr_properties_tbl.DELETE;

Line 422: IF FND_API.To_Boolean( l_commit ) THEN

418:
419:
420: -- End of API body.
421: -- Standard check of l_commit.
422: IF FND_API.To_Boolean( l_commit ) THEN
423:
424: COMMIT WORK;
425: IF (l_plog) THEN
426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');

Line 441: WHEN FND_API.G_EXC_ERROR THEN

437: '==================== Exiting from EAM_METER_PUB.create_meter ====================');
438: END IF;
439:
440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO create_meter_pub;
443: x_return_status := FND_API.G_RET_STS_ERROR ;
444: IF (l_plog) THEN
445: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_pub');

Line 443: x_return_status := FND_API.G_RET_STS_ERROR ;

439:
440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO create_meter_pub;
443: x_return_status := FND_API.G_RET_STS_ERROR ;
444: IF (l_plog) THEN
445: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_pub');
446: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
447: '===================EAM_METER_PUB.create_meter: EXPECTED ERROR======='||

Line 459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
456: '==================== Returned from FND_MSG_PUB.get ====================');
457: END IF;
458: x_msg_data := substr(x_msg_data,1,4000);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK TO create_meter_pub;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
462: IF (l_plog) THEN
463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_pub');

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

457: END IF;
458: x_msg_data := substr(x_msg_data,1,4000);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK TO create_meter_pub;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
462: IF (l_plog) THEN
463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_pub');
464: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
465: '===================EAM_METER_PUB.create_meter: UNEXPECTED ERROR======='||

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

475: END IF;
476: x_msg_data := substr(x_msg_data,1,4000);
477: WHEN OTHERS THEN
478: ROLLBACK TO create_meter_pub;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: IF (l_plog) THEN
481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO create_meter_pub');
482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
483: '===================EAM_METER_PUB.create_meter: OTHERS ERROR=======');

Line 521: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

517:
518: procedure update_meter
519: (
520: p_api_version IN Number,
521: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
524: x_return_status OUT nocopy VARCHAR2,
525: x_msg_count OUT nocopy NUMBER,

Line 522: p_commit IN VARCHAR2 := FND_API.G_FALSE,

518: procedure update_meter
519: (
520: p_api_version IN Number,
521: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
524: x_return_status OUT nocopy VARCHAR2,
525: x_msg_count OUT nocopy NUMBER,
526: x_msg_data OUT nocopy VARCHAR2,

Line 523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

519: (
520: p_api_version IN Number,
521: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
524: x_return_status OUT nocopy VARCHAR2,
525: x_msg_count OUT nocopy NUMBER,
526: x_msg_data OUT nocopy VARCHAR2,
527: p_meter_id IN number,

Line 632: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

628: 'it is now' || sysdate);
629: END IF;
630:
631: -- Standard call to check for call compatibility.
632: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
633: p_api_version ,
634: l_api_name ,
635: G_PKG_NAME )
636: THEN

Line 637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

633: p_api_version ,
634: l_api_name ,
635: G_PKG_NAME )
636: THEN
637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;
639:
640: l_commit := p_commit;
641: l_init_msg_list := p_init_msg_list;

Line 645: l_commit := FND_API.G_TRUE;

641: l_init_msg_list := p_init_msg_list;
642: l_validation_level := p_validation_level;
643:
644: IF l_commit IS NULL THEN
645: l_commit := FND_API.G_TRUE;
646: END IF;
647:
648: IF l_init_msg_list IS NULL THEN
649: l_init_msg_list := FND_API.G_TRUE;

Line 649: l_init_msg_list := FND_API.G_TRUE;

645: l_commit := FND_API.G_TRUE;
646: END IF;
647:
648: IF l_init_msg_list IS NULL THEN
649: l_init_msg_list := FND_API.G_TRUE;
650: END IF;
651:
652: IF l_validation_level IS NULL THEN
653: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

Line 653: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

649: l_init_msg_list := FND_API.G_TRUE;
650: END IF;
651:
652: IF l_validation_level IS NULL THEN
653: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
654: END IF;
655:
656: -- Initialize message list if p_init_msg_list is set to TRUE.
657: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 657: IF FND_API.to_Boolean( l_init_msg_list ) THEN

653: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
654: END IF;
655:
656: -- Initialize message list if p_init_msg_list is set to TRUE.
657: IF FND_API.to_Boolean( l_init_msg_list ) THEN
658: FND_MSG_PUB.initialize;
659: END IF;
660:
661: -- Initialize API return status to success

Line 662: x_return_status := FND_API.G_RET_STS_SUCCESS;

658: FND_MSG_PUB.initialize;
659: END IF;
660:
661: -- Initialize API return status to success
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663:
664: -- API body
665:
666: l_source_meter_id := p_source_meter_id;

Line 711: RAISE FND_API.G_EXC_ERROR;

707: LOOP
708: IF nvl(l_primary_failure_flag_csr.primary_failure_flag, 'N') = 'Y' THEN
709: FND_MESSAGE.SET_NAME('EAM', 'EAM_PRIMARY_FLAG_EXISTS');
710: FND_MSG_PUB.ADD;
711: RAISE FND_API.G_EXC_ERROR;
712: EXIT;
713: END IF;
714: FETCH primary_failure_flag_csr into l_primary_failure_flag_csr;
715: END LOOP;

Line 738: l_counter_instance_rec.attribute1 := Nvl(p_attribute1, FND_API.G_MISS_CHAR); --bug # 16329758 start

734: l_counter_instance_rec.description := p_description;
735: l_counter_instance_rec.time_based_manual_entry := 'Y';
736: l_counter_instance_rec.eam_required_flag := p_eam_required_flag;
737: l_counter_instance_rec.attribute_category := p_attribute_category;
738: l_counter_instance_rec.attribute1 := Nvl(p_attribute1, FND_API.G_MISS_CHAR); --bug # 16329758 start
739: l_counter_instance_rec.attribute2 := Nvl(p_attribute2, FND_API.G_MISS_CHAR);
740: l_counter_instance_rec.attribute3 := Nvl(p_attribute3, FND_API.G_MISS_CHAR);
741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);
742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);

Line 739: l_counter_instance_rec.attribute2 := Nvl(p_attribute2, FND_API.G_MISS_CHAR);

735: l_counter_instance_rec.time_based_manual_entry := 'Y';
736: l_counter_instance_rec.eam_required_flag := p_eam_required_flag;
737: l_counter_instance_rec.attribute_category := p_attribute_category;
738: l_counter_instance_rec.attribute1 := Nvl(p_attribute1, FND_API.G_MISS_CHAR); --bug # 16329758 start
739: l_counter_instance_rec.attribute2 := Nvl(p_attribute2, FND_API.G_MISS_CHAR);
740: l_counter_instance_rec.attribute3 := Nvl(p_attribute3, FND_API.G_MISS_CHAR);
741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);
742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);
743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);

Line 740: l_counter_instance_rec.attribute3 := Nvl(p_attribute3, FND_API.G_MISS_CHAR);

736: l_counter_instance_rec.eam_required_flag := p_eam_required_flag;
737: l_counter_instance_rec.attribute_category := p_attribute_category;
738: l_counter_instance_rec.attribute1 := Nvl(p_attribute1, FND_API.G_MISS_CHAR); --bug # 16329758 start
739: l_counter_instance_rec.attribute2 := Nvl(p_attribute2, FND_API.G_MISS_CHAR);
740: l_counter_instance_rec.attribute3 := Nvl(p_attribute3, FND_API.G_MISS_CHAR);
741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);
742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);
743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);
744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);

Line 741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);

737: l_counter_instance_rec.attribute_category := p_attribute_category;
738: l_counter_instance_rec.attribute1 := Nvl(p_attribute1, FND_API.G_MISS_CHAR); --bug # 16329758 start
739: l_counter_instance_rec.attribute2 := Nvl(p_attribute2, FND_API.G_MISS_CHAR);
740: l_counter_instance_rec.attribute3 := Nvl(p_attribute3, FND_API.G_MISS_CHAR);
741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);
742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);
743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);
744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);
745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);

Line 742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);

738: l_counter_instance_rec.attribute1 := Nvl(p_attribute1, FND_API.G_MISS_CHAR); --bug # 16329758 start
739: l_counter_instance_rec.attribute2 := Nvl(p_attribute2, FND_API.G_MISS_CHAR);
740: l_counter_instance_rec.attribute3 := Nvl(p_attribute3, FND_API.G_MISS_CHAR);
741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);
742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);
743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);
744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);
745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);
746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);

Line 743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);

739: l_counter_instance_rec.attribute2 := Nvl(p_attribute2, FND_API.G_MISS_CHAR);
740: l_counter_instance_rec.attribute3 := Nvl(p_attribute3, FND_API.G_MISS_CHAR);
741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);
742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);
743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);
744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);
745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);
746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);
747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);

Line 744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);

740: l_counter_instance_rec.attribute3 := Nvl(p_attribute3, FND_API.G_MISS_CHAR);
741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);
742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);
743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);
744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);
745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);
746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);
747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);
748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);

Line 745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);

741: l_counter_instance_rec.attribute4 := Nvl(p_attribute4, FND_API.G_MISS_CHAR);
742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);
743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);
744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);
745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);
746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);
747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);
748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);
749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);

Line 746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);

742: l_counter_instance_rec.attribute5 := Nvl(p_attribute5, FND_API.G_MISS_CHAR);
743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);
744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);
745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);
746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);
747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);
748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);
749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);
750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);

Line 747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);

743: l_counter_instance_rec.attribute6 := Nvl(p_attribute6, FND_API.G_MISS_CHAR);
744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);
745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);
746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);
747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);
748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);
749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);
750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);
751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);

Line 748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);

744: l_counter_instance_rec.attribute7 := Nvl(p_attribute7, FND_API.G_MISS_CHAR);
745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);
746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);
747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);
748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);
749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);
750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);
751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);
752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);

Line 749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);

745: l_counter_instance_rec.attribute8 := Nvl(p_attribute8, FND_API.G_MISS_CHAR);
746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);
747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);
748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);
749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);
750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);
751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);
752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);
753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);

Line 750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);

746: l_counter_instance_rec.attribute9 := Nvl(p_attribute9, FND_API.G_MISS_CHAR);
747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);
748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);
749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);
750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);
751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);
752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);
753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);
754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);

Line 751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);

747: l_counter_instance_rec.attribute10 := Nvl(p_attribute10, FND_API.G_MISS_CHAR);
748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);
749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);
750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);
751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);
752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);
753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);
754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);
755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);

Line 752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);

748: l_counter_instance_rec.attribute11 := Nvl(p_attribute11, FND_API.G_MISS_CHAR);
749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);
750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);
751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);
752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);
753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);
754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);
755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);
756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);

Line 753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);

749: l_counter_instance_rec.attribute12 := Nvl(p_attribute12, FND_API.G_MISS_CHAR);
750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);
751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);
752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);
753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);
754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);
755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);
756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);
757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);

Line 754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);

750: l_counter_instance_rec.attribute13 := Nvl(p_attribute13, FND_API.G_MISS_CHAR);
751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);
752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);
753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);
754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);
755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);
756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);
757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);
758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);

Line 755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);

751: l_counter_instance_rec.attribute14 := Nvl(p_attribute14, FND_API.G_MISS_CHAR);
752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);
753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);
754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);
755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);
756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);
757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);
758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);
759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);

Line 756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);

752: l_counter_instance_rec.attribute15 := Nvl(p_attribute15, FND_API.G_MISS_CHAR);
753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);
754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);
755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);
756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);
757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);
758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);
759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);
760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);

Line 757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);

753: l_counter_instance_rec.attribute16 := Nvl(p_attribute16, FND_API.G_MISS_CHAR);
754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);
755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);
756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);
757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);
758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);
759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);
760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);
761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);

Line 758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);

754: l_counter_instance_rec.attribute17 := Nvl(p_attribute17, FND_API.G_MISS_CHAR);
755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);
756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);
757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);
758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);
759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);
760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);
761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);
762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);

Line 759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);

755: l_counter_instance_rec.attribute18 := Nvl(p_attribute18, FND_API.G_MISS_CHAR);
756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);
757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);
758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);
759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);
760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);
761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);
762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);
763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);

Line 760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);

756: l_counter_instance_rec.attribute19 := Nvl(p_attribute19, FND_API.G_MISS_CHAR);
757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);
758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);
759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);
760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);
761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);
762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);
763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);
764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);

Line 761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);

757: l_counter_instance_rec.attribute20 := Nvl(p_attribute20, FND_API.G_MISS_CHAR);
758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);
759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);
760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);
761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);
762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);
763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);
764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);
765: l_counter_instance_rec.attribute28 := Nvl(p_attribute28, FND_API.G_MISS_CHAR);

Line 762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);

758: l_counter_instance_rec.attribute21 := Nvl(p_attribute21, FND_API.G_MISS_CHAR);
759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);
760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);
761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);
762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);
763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);
764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);
765: l_counter_instance_rec.attribute28 := Nvl(p_attribute28, FND_API.G_MISS_CHAR);
766: l_counter_instance_rec.attribute29 := Nvl(p_attribute29, FND_API.G_MISS_CHAR);

Line 763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);

759: l_counter_instance_rec.attribute22 := Nvl(p_attribute22, FND_API.G_MISS_CHAR);
760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);
761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);
762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);
763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);
764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);
765: l_counter_instance_rec.attribute28 := Nvl(p_attribute28, FND_API.G_MISS_CHAR);
766: l_counter_instance_rec.attribute29 := Nvl(p_attribute29, FND_API.G_MISS_CHAR);
767: l_counter_instance_rec.attribute30 := Nvl(p_attribute30, FND_API.G_MISS_CHAR); --bug # 16329758 end

Line 764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);

760: l_counter_instance_rec.attribute23 := Nvl(p_attribute23, FND_API.G_MISS_CHAR);
761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);
762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);
763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);
764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);
765: l_counter_instance_rec.attribute28 := Nvl(p_attribute28, FND_API.G_MISS_CHAR);
766: l_counter_instance_rec.attribute29 := Nvl(p_attribute29, FND_API.G_MISS_CHAR);
767: l_counter_instance_rec.attribute30 := Nvl(p_attribute30, FND_API.G_MISS_CHAR); --bug # 16329758 end
768:

Line 765: l_counter_instance_rec.attribute28 := Nvl(p_attribute28, FND_API.G_MISS_CHAR);

761: l_counter_instance_rec.attribute24 := Nvl(p_attribute24, FND_API.G_MISS_CHAR);
762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);
763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);
764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);
765: l_counter_instance_rec.attribute28 := Nvl(p_attribute28, FND_API.G_MISS_CHAR);
766: l_counter_instance_rec.attribute29 := Nvl(p_attribute29, FND_API.G_MISS_CHAR);
767: l_counter_instance_rec.attribute30 := Nvl(p_attribute30, FND_API.G_MISS_CHAR); --bug # 16329758 end
768:
769: BEGIN

Line 766: l_counter_instance_rec.attribute29 := Nvl(p_attribute29, FND_API.G_MISS_CHAR);

762: l_counter_instance_rec.attribute25 := Nvl(p_attribute25, FND_API.G_MISS_CHAR);
763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);
764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);
765: l_counter_instance_rec.attribute28 := Nvl(p_attribute28, FND_API.G_MISS_CHAR);
766: l_counter_instance_rec.attribute29 := Nvl(p_attribute29, FND_API.G_MISS_CHAR);
767: l_counter_instance_rec.attribute30 := Nvl(p_attribute30, FND_API.G_MISS_CHAR); --bug # 16329758 end
768:
769: BEGIN
770: select source_counter_id,relationship_id,factor,object_version_number

Line 767: l_counter_instance_rec.attribute30 := Nvl(p_attribute30, FND_API.G_MISS_CHAR); --bug # 16329758 end

763: l_counter_instance_rec.attribute26 := Nvl(p_attribute26, FND_API.G_MISS_CHAR);
764: l_counter_instance_rec.attribute27 := Nvl(p_attribute27, FND_API.G_MISS_CHAR);
765: l_counter_instance_rec.attribute28 := Nvl(p_attribute28, FND_API.G_MISS_CHAR);
766: l_counter_instance_rec.attribute29 := Nvl(p_attribute29, FND_API.G_MISS_CHAR);
767: l_counter_instance_rec.attribute30 := Nvl(p_attribute30, FND_API.G_MISS_CHAR); --bug # 16329758 end
768:
769: BEGIN
770: select source_counter_id,relationship_id,factor,object_version_number
771: into l_prev_source_counter_id,l_prev_relationship_id,l_previous_factor,l_object_version_number

Line 778: l_source_meter_id := FND_API.G_MISS_NUM;

774:
775: if nvl(p_from_eam, 'N') = 'Y' then
776:
777: if l_source_meter_id is null and l_prev_source_counter_id is not null then
778: l_source_meter_id := FND_API.G_MISS_NUM;
779: end if;
780:
781: end if;
782:

Line 786: IF l_source_meter_id = FND_API.G_MISS_NUM THEN

782:
783:
784:
785: IF l_source_meter_id IS NOT NULL THEN
786: IF l_source_meter_id = FND_API.G_MISS_NUM THEN
787: l_counter_relationships_tbl(1).object_version_number := l_object_version_number;
788: l_counter_relationships_tbl(1).RELATIONSHIP_ID := l_prev_relationship_id;
789: l_counter_relationships_tbl(1).ACTIVE_END_DATE := SYSDATE;
790: ELSIF l_prev_source_counter_id <> l_source_meter_id THEN

Line 955: IF FND_API.To_Boolean( l_commit ) THEN

951:
952:
953: -- End of API body.
954: -- Standard check of l_commit.
955: IF FND_API.To_Boolean( l_commit ) THEN
956: COMMIT WORK;
957: IF (l_plog) THEN
958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');
959: END IF;

Line 980: WHEN FND_API.G_EXC_ERROR THEN

976: '==================== Exiting EAM_METER_PUB.update_meter ====================');
977: END IF;
978: x_msg_data := substr(x_msg_data,1,4000);
979: EXCEPTION
980: WHEN FND_API.G_EXC_ERROR THEN
981: ROLLBACK TO update_meter_pub;
982: x_return_status := FND_API.G_RET_STS_ERROR ;
983: IF (l_plog) THEN
984: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');

Line 982: x_return_status := FND_API.G_RET_STS_ERROR ;

978: x_msg_data := substr(x_msg_data,1,4000);
979: EXCEPTION
980: WHEN FND_API.G_EXC_ERROR THEN
981: ROLLBACK TO update_meter_pub;
982: x_return_status := FND_API.G_RET_STS_ERROR ;
983: IF (l_plog) THEN
984: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');
985: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
986: '===================EAM_METER_PUB.update_meter: EXPECTED ERROR======='||

Line 999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

995: '==================== Returned from FND_MSG_PUB.get ====================');
996: END IF;
997:
998: x_msg_data := substr(x_msg_data,1,4000);
999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1000: ROLLBACK TO update_meter_pub;
1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1002: IF (l_plog) THEN
1003: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');

Line 1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

997:
998: x_msg_data := substr(x_msg_data,1,4000);
999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1000: ROLLBACK TO update_meter_pub;
1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1002: IF (l_plog) THEN
1003: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');
1004: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1005: '===================EAM_METER_PUB.update_meter: UNEXPECTED ERROR======='||

Line 1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1015: END IF;
1016: x_msg_data := substr(x_msg_data,1,4000);
1017: WHEN OTHERS THEN
1018: ROLLBACK TO update_meter_pub;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: IF (l_plog) THEN
1021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');
1022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1023: '===================EAM_METER_PUB.update_meter: OTHERS ERROR=======');