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_METERS_UTIL dependencies on EAM_METERS_UTIL

Line 1: PACKAGE BODY EAM_METERS_UTIL AS

1: PACKAGE BODY EAM_METERS_UTIL AS
2: /* $Header: EAMETERB.pls 120.25 2006/05/15 05:58:26 sshahid ship $ */
3:
4: -- Standard who
5: g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_METERS_UTIL';

8: g_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
9: g_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
10: g_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_METERS_UTIL';
13:
14:
15: /**
16: * This is a private helper function that retrieves the activity association id

Line 411: SAVEPOINT EAM_METERS_UTIL;

407: l_api_name CONSTANT VARCHAR2(30) := 'Meter_Utils';
408: l_api_version CONSTANT NUMBER := 1.0;
409: l_last_service_end_date date;
410: begin
411: SAVEPOINT EAM_METERS_UTIL;
412: x_assoc_id := get_activity_assoc_id(p_wip_entity_id);
413:
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: --bug 3762560: if x_assoc_id is null, then don't process anything, just return

Line 434: ROLLBACK TO EAM_METERS_UTIL;

430: p_data => x_msg_data
431: );
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: ROLLBACK TO EAM_METERS_UTIL;
435: x_return_status := FND_API.G_RET_STS_ERROR ;
436: FND_MSG_PUB.Count_And_Get
437: ( p_count => x_msg_count ,
438: p_data => x_msg_data

Line 441: ROLLBACK TO EAM_METERS_UTIL;

437: ( p_count => x_msg_count ,
438: p_data => x_msg_data
439: );
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO EAM_METERS_UTIL;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
443: FND_MSG_PUB.Count_And_Get
444: ( p_count => x_msg_count ,
445: p_data => x_msg_data

Line 448: ROLLBACK TO EAM_METERS_UTIL;

444: ( p_count => x_msg_count ,
445: p_data => x_msg_data
446: );
447: WHEN OTHERS THEN
448: ROLLBACK TO EAM_METERS_UTIL;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
450: IF FND_MSG_PUB.Check_Msg_Level
451: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
452: THEN

Line 490: SAVEPOINT EAM_METERS_UTIL;

486: l_pm_seq_id NUMBER;
487: l_pm_seq number;
488: l_wo_seq number;
489: begin
490: SAVEPOINT EAM_METERS_UTIL;
491:
492: x_assoc_id := get_activity_assoc_id(p_wip_entity_id);
493:
494: if x_assoc_id is not null then

Line 561: ROLLBACK TO EAM_METERS_UTIL;

557: p_data => x_msg_data
558: );
559: EXCEPTION
560: WHEN FND_API.G_EXC_ERROR THEN
561: ROLLBACK TO EAM_METERS_UTIL;
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count ,
565: p_data => x_msg_data

Line 568: ROLLBACK TO EAM_METERS_UTIL;

564: ( p_count => x_msg_count ,
565: p_data => x_msg_data
566: );
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568: ROLLBACK TO EAM_METERS_UTIL;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: FND_MSG_PUB.Count_And_Get
571: ( p_count => x_msg_count ,
572: p_data => x_msg_data

Line 575: ROLLBACK TO EAM_METERS_UTIL;

571: ( p_count => x_msg_count ,
572: p_data => x_msg_data
573: );
574: WHEN OTHERS THEN
575: ROLLBACK TO EAM_METERS_UTIL;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: IF FND_MSG_PUB.Check_Msg_Level
578: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN

Line 611: SAVEPOINT EAM_METERS_UTIL_NEW;

607: l_pm_schedule_id NUMBER;
608: l_cycle_id NUMBER;
609: l_seq_id NUMBER;
610: begin
611: SAVEPOINT EAM_METERS_UTIL_NEW;
612: x_assoc_id := get_activity_assoc_id(p_wip_entity_id);
613:
614: if x_assoc_id is not null then
615: update_last_service_dates(p_wip_entity_id, x_assoc_id, p_start_date, p_end_date);

Line 659: ROLLBACK TO EAM_METERS_UTIL_NEW;

655:
656: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
657: COMMIT;
658: ELSE
659: ROLLBACK TO EAM_METERS_UTIL_NEW;
660: END IF;
661: END IF;
662:
663: -- Standard call to get message count and if count is 1, get message info.

Line 670: ROLLBACK TO EAM_METERS_UTIL_NEW;

666: p_data => x_msg_data
667: );
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: ROLLBACK TO EAM_METERS_UTIL_NEW;
671: x_return_status := FND_API.G_RET_STS_ERROR ;
672: FND_MSG_PUB.Count_And_Get
673: ( p_count => x_msg_count ,
674: p_data => x_msg_data

Line 677: ROLLBACK TO EAM_METERS_UTIL_NEW;

673: ( p_count => x_msg_count ,
674: p_data => x_msg_data
675: );
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: ROLLBACK TO EAM_METERS_UTIL_NEW;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: FND_MSG_PUB.Count_And_Get
680: ( p_count => x_msg_count ,
681: p_data => x_msg_data

Line 684: ROLLBACK TO EAM_METERS_UTIL_NEW;

680: ( p_count => x_msg_count ,
681: p_data => x_msg_data
682: );
683: WHEN OTHERS THEN
684: ROLLBACK TO EAM_METERS_UTIL_NEW;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686: IF FND_MSG_PUB.Check_Msg_Level
687: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
688: THEN

Line 1087: if (eam_meters_util.reset_reading_exists(p_meter_id,p_reading_date) = true

1083: and NVL(disabled_flag,'N')<>'Y';
1084:
1085:
1086:
1087: if (eam_meters_util.reset_reading_exists(p_meter_id,p_reading_date) = true
1088: and prev_ceiling_reading_date is not null) then
1089: return_val := true;
1090: end if;
1091: return return_val;

Line 1545: END eam_meters_util;

1541: );
1542: END VALIDATE_USED_IN_SCHEDULING;
1543:
1544:
1545: END eam_meters_util;
1546:
1547: