DBA Data[Home] [Help]

APPS.EAM_METERREADING_UTILITY_PVT dependencies on EAM_METERREADING_UTILITY_PVT

Line 1: PACKAGE BODY EAM_METERREADING_UTILITY_PVT AS

1: PACKAGE BODY EAM_METERREADING_UTILITY_PVT AS
2: /* $Header: EAMVMTUB.pls 120.9 2006/06/16 13:31:30 sshahid noship $ */
3: /***************************************************************************
4: --
5: -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA

Line 14: -- Body of package EAM_METERREADING_UTILITY_PVT

10: -- EAMVMTUB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package EAM_METERREADING_UTILITY_PVT
15: --
16: -- NOTES
17: --
18: -- HISTORY

Line 57: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.INSERT_ROW()..');

53:
54:
55: BEGIN
56: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
57: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.INSERT_ROW()..');
58: END IF;
59:
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61: x_eam_meter_reading_tbl := p_eam_meter_reading_tbl;

Line 148: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METERREADING_PUB.create_meter_reading().. from EAM_METERREADING_UTILITY_PVT.INSERT_ROW()');

144: END LOOP;
145: END IF;
146:
147: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
148: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METERREADING_PUB.create_meter_reading().. from EAM_METERREADING_UTILITY_PVT.INSERT_ROW()');
149: END IF;
150: EAM_METERREADING_PUB.create_meter_reading(
151:
152: p_api_version => 1.0,

Line 197: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.INSERT_ROW()..Successfully');

193: END IF;
194: END LOOP; -- Meter Loop
195: END IF; -- End of Meter Reading Count > 0
196: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
197: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.INSERT_ROW()..Successfully');
198: END IF;
199: END INSERT_ROW;
200:
201: PROCEDURE ENABLE_SOURCE_METER

Line 213: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.ENABLE_SOURCE_METER()..');

209: l_msg_count NUMBER;
210: l_msg_data VARCHAR2(2000);
211: BEGIN
212: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
213: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.ENABLE_SOURCE_METER()..');
214: END IF;
215:
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217: x_eam_wo_comp_mr_read_tbl := p_eam_wo_comp_mr_read_tbl;

Line 223: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METER_PUB.update_meter().. from EAM_METERREADING_UTILITY_PVT.ENABLE_SOURCE_METER()');

219: IF p_eam_wo_comp_mr_read_tbl.COUNT > 0 THEN
220: FOR ii in p_eam_wo_comp_mr_read_tbl.FIRST..p_eam_wo_comp_mr_read_tbl.LAST LOOP
221:
222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
223: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METER_PUB.update_meter().. from EAM_METERREADING_UTILITY_PVT.ENABLE_SOURCE_METER()');
224: END IF;
225:
226: EAM_METER_PUB.update_meter
227: (

Line 258: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.ENABLE_SOURCE_METER()..Successfully');

254: END IF;
255: END LOOP;
256: END IF;
257: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
258: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.ENABLE_SOURCE_METER()..Successfully');
259: END IF;
260:
261: END ENABLE_SOURCE_METER;
262:

Line 290: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()..');

286: AND wdj.parent_wip_entity_id = p_wip_entity_id;
287:
288: BEGIN
289: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
290: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()..');
291: END IF;
292:
293: x_return_status := FND_API.G_RET_STS_SUCCESS;
294: x_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;

Line 335: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METER_PUB.update_meter().. from EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()');

331: IF l_counter_tbl.COUNT > 0 THEN
332: FOR K IN l_counter_tbl.FIRST..l_counter_tbl.LAST LOOP
333:
334: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
335: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METER_PUB.update_meter().. from EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()');
336: END IF;
337: EAM_METER_PUB.update_meter
338: (
339: p_api_version => 1.0,

Line 372: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling csi_eam_interface_grp.rebuildable_return().. from EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()');

368: END IF;
369: IF p_subinventory_id IS NULL AND l_eam_wo_comp_rebuild_tbl(ii).organization_id <> -1 THEN
370:
371: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
372: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling csi_eam_interface_grp.rebuildable_return().. from EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()');
373: END IF;
374: csi_eam_interface_grp.rebuildable_return
375: (
376: p_wip_entity_id => l_eam_wo_comp_rebuild_tbl(ii).wip_entity_id ,

Line 393: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()..Successfully');

389: END LOOP;
390: END IF;
391:
392: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
393: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()..Successfully');
394: END IF;
395:
396: END DISABLE_COUNTER_HIERARCHY;
397:

Line 419: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()..');

415:
416: BEGIN
417:
418: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
419: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()..');
420: END IF;
421:
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423: x_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;

Line 438: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY().. from EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()');

434:
435: IF l_primary_item_id IS NULL THEN
436:
437: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
438: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY().. from EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()');
439: END IF;
440:
441: EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY
442: (

Line 494: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()..Successfully');

490: END IF;
491: END LOOP;
492: END IF;
493: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
494: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()..Successfully');
495: END IF;
496:
497: END UPDATE_ACTIVITY;
498:

Line 515: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()..');

511: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
512: BEGIN
513:
514: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
515: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()..');
516: END IF;
517:
518: x_return_status := FND_API.G_RET_STS_SUCCESS;
519: x_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;

Line 527: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling wip_eam_genealogy_pvt.update_eam_genealogy().. from EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()');

523:
524: IF p_eam_wo_comp_rebuild_tbl(ii).uninst_serial_removed IS NOT NULL THEN
525:
526: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
527: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling wip_eam_genealogy_pvt.update_eam_genealogy().. from EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()');
528: END IF;
529:
530: wip_eam_genealogy_pvt.update_eam_genealogy
531: (

Line 568: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()..Successfully');

564: END LOOP;
565: END IF;
566:
567: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
568: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()..Successfully');
569: END IF;
570:
571: END UPDATE_GENEALOGY;
572:

Line 590: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()..');

586: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
587: BEGIN
588:
589: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
590: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()..');
591: END IF;
592:
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594: x_eam_meter_reading_tbl := p_eam_meter_reading_tbl;

Line 599: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METERS_UTIL.update_last_service_reading_wo().. from EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()');

595:
596: FOR I IN p_eam_meter_reading_tbl.FIRST..p_eam_meter_reading_tbl.LAST LOOP
597:
598: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
599: EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METERS_UTIL.update_last_service_reading_wo().. from EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()');
600: END IF;
601:
602: EAM_METERS_UTIL.update_last_service_reading_wo(
603: p_wip_entity_id => p_eam_meter_reading_tbl(i).wip_entity_id ,

Line 632: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()..Successfully');

628: return;
629: END IF;
630: END LOOP;
631: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
632: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()..Successfully');
633: END IF;
634: END UPDATE_LAST_SERVICE_READING;
635:
636: PROCEDURE UPDATE_REBUILD_WORK_ORDER

Line 646: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()..');

642: )IS
643: BEGIN
644:
645: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
646: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()..');
647: END IF;
648:
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650: x_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;

Line 668: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Exception in EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()');

664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
668: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Exception in EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()');
669: END IF;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: return;
672:

Line 674: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()..Successfully');

670: x_return_status := FND_API.G_RET_STS_ERROR;
671: return;
672:
673: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
674: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()..Successfully');
675: END IF;
676:
677: END UPDATE_REBUILD_WORK_ORDER;
678:

Line 679: END EAM_METERREADING_UTILITY_PVT;

675: END IF;
676:
677: END UPDATE_REBUILD_WORK_ORDER;
678:
679: END EAM_METERREADING_UTILITY_PVT;