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

Line 21: -- DEFAULT = FND_API.G_FALSE

17: This procedure inserts a record in the eam_asset_meters table
18: -- Parameters :
19: -- IN : P_API_VERSION IN NUMBER REQUIRED
20: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
21: -- DEFAULT = FND_API.G_FALSE
22: -- P_COMMIT IN VARCHAR2 OPTIONAL
23: -- DEFAULT = FND_API.G_FALSE
24: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
25: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

Line 23: -- DEFAULT = FND_API.G_FALSE

19: -- IN : P_API_VERSION IN NUMBER REQUIRED
20: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
21: -- DEFAULT = FND_API.G_FALSE
22: -- P_COMMIT IN VARCHAR2 OPTIONAL
23: -- DEFAULT = FND_API.G_FALSE
24: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
25: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
26: -- p_meter_id in not null number ,
27: -- p_organization_id in not null number ,

Line 25: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

21: -- DEFAULT = FND_API.G_FALSE
22: -- P_COMMIT IN VARCHAR2 OPTIONAL
23: -- DEFAULT = FND_API.G_FALSE
24: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
25: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
26: -- p_meter_id in not null number ,
27: -- p_organization_id in not null number ,
28: -- p_asset_group_id in not null number ,
29: -- p_asset_number in varchar2 default null,

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

40:
41: PROCEDURE Insert_AssetMeterAssoc
42: (
43: p_api_version IN Number,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY Number,

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

41: PROCEDURE Insert_AssetMeterAssoc
42: (
43: p_api_version IN Number,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY Number,
49: x_msg_data OUT NOCOPY VARCHAR2,

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

42: (
43: p_api_version IN Number,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY Number,
49: x_msg_data OUT NOCOPY VARCHAR2,
50: p_meter_id IN Number,

Line 113: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

109: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
110: '==================== Entered EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');
111: END IF;
112: /* Standard call to check for call compatibility. */
113: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
114: p_api_version ,
115: l_api_name ,
116: G_PKG_NAME
117: )

Line 119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

115: l_api_name ,
116: G_PKG_NAME
117: )
118: THEN
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121:
122: /* Initialize message list if p_init_msg_list is set to TRUE. */
123: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 123: IF FND_API.to_Boolean( p_init_msg_list ) THEN

119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121:
122: /* Initialize message list if p_init_msg_list is set to TRUE. */
123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
124: FND_MSG_PUB.initialize;
125: END IF;
126:
127: /* Initialize API return status to success */

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: FND_MSG_PUB.initialize;
125: END IF;
126:
127: /* Initialize API return status to success */
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: /* API body */
131:
132: IF (l_plog) THEN

Line 159: RAISE FND_API.G_EXC_ERROR;

155:
156: if l_exists_primary_flag = 'Y' then
157: FND_MESSAGE.SET_NAME('EAM', 'EAM_PRIMARY_FLAG_EXISTS');
158: FND_MSG_PUB.ADD;
159: RAISE FND_API.G_EXC_ERROR;
160: end if;
161:
162: end if;
163: exception when no_data_found then

Line 253: RAISE FND_API.G_EXC_ERROR;

249:
250: if l_exists_primary_flag = 'Y' then
251: FND_MESSAGE.SET_NAME('EAM', 'EAM_PRIMARY_FLAG_EXISTS');
252: FND_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254: end if;
255:
256: end if;
257: exception when no_data_found then

Line 312: l_counter_associations_tbl(1).end_date_active := FND_API.G_MISS_DATE;

308: WHERE source_object_id=l_maintenance_object_id and counter_id=p_meter_id;
309:
310: l_counter_associations_tbl(1).instance_association_id := l_association_id;
311: l_counter_associations_tbl(1).object_version_number := l_object_version_number;
312: l_counter_associations_tbl(1).end_date_active := FND_API.G_MISS_DATE;
313:
314: csi_counter_pub.update_ctr_associations(p_api_version,
315: p_commit,
316: p_init_msg_list,

Line 348: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN

344: END IF;
345:
346:
347: /* Standard check of p_commit. */
348: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
349:
350: COMMIT WORK;
351: IF (l_plog) THEN
352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');

Line 376: WHEN FND_API.G_EXC_ERROR THEN

372: '==================== Exiting EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');
373: END IF;
374:
375: EXCEPTION
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: IF (l_plog) THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');

Line 378: x_return_status := FND_API.G_RET_STS_ERROR ;

374:
375: EXCEPTION
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: IF (l_plog) THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');
381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
382: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||

Line 394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
391: '==================== Returned from FND_MSG_PUB.get ====================');
392: END IF;
393:
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: IF (l_plog) THEN
398: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

392: END IF;
393:
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: IF (l_plog) THEN
398: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');
399: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
400: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||

Line 414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

410: END IF;
411:
412: WHEN OTHERS THEN
413: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
415: IF (l_plog) THEN
416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
418: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');

Line 461: -- DEFAULT = FND_API.G_FALSE

457: This procedure updates a record in the eam_asset_meters table
458: -- Parameters :
459: -- IN : p_api_version IN NUMBER REQUIRED
460: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
461: -- DEFAULT = FND_API.G_FALSE
462: -- P_COMMIT IN VARCHAR2 OPTIONAL
463: -- DEFAULT = FND_API.G_FALSE
464: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
465: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

Line 463: -- DEFAULT = FND_API.G_FALSE

459: -- IN : p_api_version IN NUMBER REQUIRED
460: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
461: -- DEFAULT = FND_API.G_FALSE
462: -- P_COMMIT IN VARCHAR2 OPTIONAL
463: -- DEFAULT = FND_API.G_FALSE
464: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
465: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
466: -- p_meter_id in not null number ,
467: -- p_organization_id in not null number

Line 465: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

461: -- DEFAULT = FND_API.G_FALSE
462: -- P_COMMIT IN VARCHAR2 OPTIONAL
463: -- DEFAULT = FND_API.G_FALSE
464: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
465: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
466: -- p_meter_id in not null number ,
467: -- p_organization_id in not null number
468: --
469: --

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

476: */
477: PROCEDURE Update_AssetMeterAssoc
478: (
479: p_api_version IN Number,
480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
481: p_commit IN VARCHAR2 := FND_API.G_FALSE,
482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY Number,

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

477: PROCEDURE Update_AssetMeterAssoc
478: (
479: p_api_version IN Number,
480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
481: p_commit IN VARCHAR2 := FND_API.G_FALSE,
482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY Number,
485: x_msg_data OUT NOCOPY VARCHAR2,

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

478: (
479: p_api_version IN Number,
480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
481: p_commit IN VARCHAR2 := FND_API.G_FALSE,
482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY Number,
485: x_msg_data OUT NOCOPY VARCHAR2,
486: p_association_id IN Number,

Line 538: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

534: '==================== Entered EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');
535: END IF;
536:
537: /* Standard call to check for call compatibility. */
538: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
539: p_api_version ,
540: l_api_name ,
541: G_PKG_NAME
542: )

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540: l_api_name ,
541: G_PKG_NAME
542: )
543: THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546:
547: /* Initialize message list if p_init_msg_list is set to TRUE. */
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 548: IF FND_API.to_Boolean( p_init_msg_list ) THEN

544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546:
547: /* Initialize message list if p_init_msg_list is set to TRUE. */
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551:
552: /* Initialize API return status to success */

Line 553: x_return_status := FND_API.G_RET_STS_SUCCESS;

549: FND_MSG_PUB.initialize;
550: END IF;
551:
552: /* Initialize API return status to success */
553: x_return_status := FND_API.G_RET_STS_SUCCESS;
554: IF (l_plog) THEN
555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
556: 'x_return_status:'||x_return_status);
557: END IF;

Line 590: RAISE FND_API.G_EXC_ERROR;

586:
587: if l_exists_primary_flag = 'Y' then
588: FND_MESSAGE.SET_NAME('EAM', 'EAM_PRIMARY_FLAG_EXISTS');
589: FND_MSG_PUB.ADD;
590: RAISE FND_API.G_EXC_ERROR;
591: end if;
592:
593: end if;
594: exception when no_data_found then

Line 673: RAISE FND_API.G_EXC_ERROR;

669:
670: if l_exists_primary_flag = 'Y' then
671: FND_MESSAGE.SET_NAME('EAM', 'EAM_PRIMARY_FLAG_EXISTS');
672: FND_MSG_PUB.ADD;
673: RAISE FND_API.G_EXC_ERROR;
674: end if;
675:
676: end if;
677: exception when no_data_found then

Line 728: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN

724:
725: END IF;
726:
727: /* Standard check of p_commit. */
728: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
729: COMMIT WORK;
730: IF (l_plog) THEN
731: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');
732: END IF;

Line 753: WHEN FND_API.G_EXC_ERROR THEN

749: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
750: '==================== Exiting EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');
751: END IF;
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO Update_AssetMeterAssoc_PUB;
755:
756: x_return_status := FND_API.G_RET_STS_ERROR ;
757:

Line 756: x_return_status := FND_API.G_RET_STS_ERROR ;

752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO Update_AssetMeterAssoc_PUB;
755:
756: x_return_status := FND_API.G_RET_STS_ERROR ;
757:
758: IF (l_plog) THEN
759: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

771: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
772: '==================== Returned from FND_MSG_PUB.get ====================');
773: END IF;
774:
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776:
777: ROLLBACK TO Update_AssetMeterAssoc_PUB;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779: IF (l_plog) THEN

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

774:
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776:
777: ROLLBACK TO Update_AssetMeterAssoc_PUB;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779: IF (l_plog) THEN
780: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
782: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||

Line 796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

792: END IF;
793:
794: WHEN OTHERS THEN
795: ROLLBACK TO Update_AssetMeterAssoc_PUB;
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
797:
798: IF (l_plog) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 864: RAISE FND_API.G_EXC_ERROR;

860: IF (l_plog) THEN
861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
862: '==================== Exiting EAM_MeterAssoc_PUB.RAISE_ERROR ====================');
863: END IF;
864: RAISE FND_API.G_EXC_ERROR;
865:
866: END;
867:
868: