DBA Data[Home] [Help]

APPS.EAM_METERASSOC_PUB dependencies on EAM_METERASSOC_PUB

Line 1: PACKAGE BODY EAM_MeterAssoc_PUB AS

1: PACKAGE BODY EAM_MeterAssoc_PUB AS
2: /* $Header: EAMPAMAB.pls 120.12 2006/04/12 23:31:46 sshahid noship $ */
3: /*
4: -- API name : EAM_MeterAssoc_PUB
5: -- Type : Public

Line 4: -- API name : EAM_MeterAssoc_PUB

1: PACKAGE BODY EAM_MeterAssoc_PUB AS
2: /* $Header: EAMPAMAB.pls 120.12 2006/04/12 23:31:46 sshahid noship $ */
3: /*
4: -- API name : EAM_MeterAssoc_PUB
5: -- Type : Public
6: -- Function : Insert, update and validation of the asset meter association
7: -- Pre-reqs : None.
8: */

Line 13: --G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_MeterAssoc_PUB';

9:
10: /* for de-bugging */
11: /* g_sr_no number ; */
12: g_object_type VARCHAR2(30) := EAM_CONSTANTS.G_OBJECT_TYPE;
13: --G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_MeterAssoc_PUB';
14:
15:
16: /*
17: This procedure inserts a record in the eam_asset_meters table

Line 110: '==================== Entered EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');

106: END IF;
107:
108: IF (l_plog) THEN
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 ,

Line 372: '==================== Exiting EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');

368: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
369: '==================== Returned from FND_MSG_PUB.get ====================');
370:
371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
372: '==================== Exiting EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');
373: END IF;
374:
375: EXCEPTION
376: WHEN FND_API.G_EXC_ERROR THEN

Line 382: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||

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======='||
383: '==================== Calling FND_MSG_PUB.get ====================');
384: END IF;
385: FND_MSG_PUB.get
386: ( p_msg_index_out => x_msg_count ,

Line 400: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||

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======='||
401: '==================== Calling FND_MSG_PUB.get ====================');
402: END IF;
403: FND_MSG_PUB.get
404: ( p_msg_index_out => x_msg_count ,

Line 418: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');

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=======');
419: END IF;
420:
421: IF FND_MSG_PUB.Check_Msg_Level
422: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 534: '==================== Entered EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');

530: END IF;
531:
532: IF (l_plog) THEN
533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
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 ,

Line 750: '==================== Exiting EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');

746: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
747: '==================== Returned from FND_MSG_PUB.get ====================');
748:
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;

Line 761: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED 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,
761: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||
762: '==================== Calling FND_MSG_PUB.get ====================');
763: END IF;
764:
765: FND_MSG_PUB.get

Line 782: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||

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======='||
783: '==================== Calling FND_MSG_PUB.get ====================');
784: END IF;
785: FND_MSG_PUB.get
786: ( p_msg_index_out => x_msg_count ,

Line 801: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS 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,
801: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');
802: END IF;
803:
804: IF FND_MSG_PUB.Check_Msg_Level
805: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 855: '==================== Entered EAM_MeterAssoc_PUB.RAISE_ERROR ====================');

851: END IF;
852:
853: IF (l_plog) THEN
854: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
855: '==================== Entered EAM_MeterAssoc_PUB.RAISE_ERROR ====================');
856: END IF;
857: FND_MESSAGE.SET_NAME ('EAM', ERROR);
858: FND_MSG_PUB.ADD;
859:

Line 862: '==================== Exiting EAM_MeterAssoc_PUB.RAISE_ERROR ====================');

858: FND_MSG_PUB.ADD;
859:
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;

Line 869: END EAM_MeterAssoc_PUB;

865:
866: END;
867:
868:
869: END EAM_MeterAssoc_PUB;