DBA Data[Home] [Help]

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 624: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

620: '==================== Entered EAM_METER_PUB.update_meter ====================');
621: END IF;
622:
623: -- Standard call to check for call compatibility.
624: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
625: p_api_version ,
626: l_api_name ,
627: G_PKG_NAME )
628: THEN

Line 629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

625: p_api_version ,
626: l_api_name ,
627: G_PKG_NAME )
628: THEN
629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631:
632: l_commit := p_commit;
633: l_init_msg_list := p_init_msg_list;

Line 637: l_commit := FND_API.G_TRUE;

633: l_init_msg_list := p_init_msg_list;
634: l_validation_level := p_validation_level;
635:
636: IF l_commit IS NULL THEN
637: l_commit := FND_API.G_TRUE;
638: END IF;
639:
640: IF l_init_msg_list IS NULL THEN
641: l_init_msg_list := FND_API.G_TRUE;

Line 641: l_init_msg_list := FND_API.G_TRUE;

637: l_commit := FND_API.G_TRUE;
638: END IF;
639:
640: IF l_init_msg_list IS NULL THEN
641: l_init_msg_list := FND_API.G_TRUE;
642: END IF;
643:
644: IF l_validation_level IS NULL THEN
645: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

Line 645: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

641: l_init_msg_list := FND_API.G_TRUE;
642: END IF;
643:
644: IF l_validation_level IS NULL THEN
645: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
646: END IF;
647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 649: IF FND_API.to_Boolean( l_init_msg_list ) THEN

645: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
646: END IF;
647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( l_init_msg_list ) THEN
650: FND_MSG_PUB.initialize;
651: END IF;
652:
653: -- Initialize API return status to success

Line 654: x_return_status := FND_API.G_RET_STS_SUCCESS;

650: FND_MSG_PUB.initialize;
651: END IF;
652:
653: -- Initialize API return status to success
654: x_return_status := FND_API.G_RET_STS_SUCCESS;
655:
656: -- API body
657:
658: l_source_meter_id := p_source_meter_id;

Line 702: RAISE FND_API.G_EXC_ERROR;

698:
699: if nvl(l_primary_flag, 'N') = 'Y' then
700: FND_MESSAGE.SET_NAME('EAM', 'EAM_PRIMARY_FLAG_EXISTS');
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_ERROR;
703: end if;
704:
705: exception when no_data_found then
706: -- this is not an error condition.

Line 768: l_source_meter_id := FND_API.G_MISS_NUM;

764:
765: if nvl(p_from_eam, 'N') = 'Y' then
766:
767: if l_source_meter_id is null and l_prev_source_counter_id is not null then
768: l_source_meter_id := FND_API.G_MISS_NUM;
769: end if;
770:
771: end if;
772:

Line 776: IF l_source_meter_id = FND_API.G_MISS_NUM THEN

772:
773:
774:
775: IF l_source_meter_id IS NOT NULL THEN
776: IF l_source_meter_id = FND_API.G_MISS_NUM THEN
777: l_counter_relationships_tbl(1).object_version_number := l_object_version_number;
778: l_counter_relationships_tbl(1).RELATIONSHIP_ID := l_prev_relationship_id;
779: l_counter_relationships_tbl(1).ACTIVE_END_DATE := SYSDATE;
780: ELSIF l_prev_source_counter_id <> l_source_meter_id THEN

Line 947: IF FND_API.To_Boolean( l_commit ) THEN

943:
944:
945: -- End of API body.
946: -- Standard check of l_commit.
947: IF FND_API.To_Boolean( l_commit ) THEN
948: COMMIT WORK;
949: IF (l_plog) THEN
950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');
951: END IF;

Line 972: WHEN FND_API.G_EXC_ERROR THEN

968: '==================== Exiting EAM_METER_PUB.update_meter ====================');
969: END IF;
970: x_msg_data := substr(x_msg_data,1,4000);
971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973: ROLLBACK TO update_meter_pub;
974: x_return_status := FND_API.G_RET_STS_ERROR ;
975: IF (l_plog) THEN
976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');

Line 974: x_return_status := FND_API.G_RET_STS_ERROR ;

970: x_msg_data := substr(x_msg_data,1,4000);
971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973: ROLLBACK TO update_meter_pub;
974: x_return_status := FND_API.G_RET_STS_ERROR ;
975: IF (l_plog) THEN
976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');
977: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
978: '===================EAM_METER_PUB.update_meter: EXPECTED ERROR======='||

Line 991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

987: '==================== Returned from FND_MSG_PUB.get ====================');
988: END IF;
989:
990: x_msg_data := substr(x_msg_data,1,4000);
991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
992: ROLLBACK TO update_meter_pub;
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994: IF (l_plog) THEN
995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');

Line 993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

989:
990: x_msg_data := substr(x_msg_data,1,4000);
991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
992: ROLLBACK TO update_meter_pub;
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994: IF (l_plog) THEN
995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');
996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
997: '===================EAM_METER_PUB.update_meter: UNEXPECTED ERROR======='||

Line 1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1007: END IF;
1008: x_msg_data := substr(x_msg_data,1,4000);
1009: WHEN OTHERS THEN
1010: ROLLBACK TO update_meter_pub;
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1012: IF (l_plog) THEN
1013: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO update_meter_pub');
1014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1015: '===================EAM_METER_PUB.update_meter: OTHERS ERROR=======');