DBA Data[Home] [Help]

APPS.EAM_METERREADING_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 56: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

52: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
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;

Line 147: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

143: END IF;
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:

Line 162: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

158: p_value_before_reset => p_eam_meter_reading_tbl(ii).VALUE_BEFORE_RESET,
159: p_ignore_warnings => p_eam_meter_reading_tbl(ii).IGNORE_METER_WARNINGS,
160: p_ctr_property_readings_tbl => l_counter_properties_tbl
161: );
162: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
163: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METERREADING_PUB.create_meter_reading() with return_status : ' || l_return_status);
164: END IF;
165: FOR MM IN x_eam_meter_reading_tbl.FIRST..x_eam_meter_reading_tbl.LAST LOOP
166: IF x_eam_meter_reading_tbl(MM).meter_id = l_meter_reading_rec.meter_id THEN

Line 181: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

177: END IF;
178:
179: IF l_return_status <> 'S' THEN
180:
181: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
182: EAM_ERROR_MESSAGE_PVT.Write_Debug('Error returned from EAM_METERREADING_PUB.create_meter_reading()..: ' || l_msg_data);
183: END IF;
184:
185: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 196: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

192: return;
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:

Line 212: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

208: l_return_status VARCHAR2(1);
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;

Line 222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

218:
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

Line 236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

232: x_return_status => l_return_status,
233: x_msg_count => l_msg_count,
234: x_msg_data => l_msg_data
235: );
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
237: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METER_PUB.update_meter() with return_status : ' || l_return_status);
238: END IF;
239: x_eam_wo_comp_mr_read_tbl(ii).return_status := l_return_status;
240:

Line 243: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN

239: x_eam_wo_comp_mr_read_tbl(ii).return_status := l_return_status;
240:
241: IF l_return_status <> 'S' THEN
242:
243: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
244: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METER_PUB.update_meter().. : ' || l_msg_data);
245: END IF;
246: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
247: ( p_message_name => NULL

Line 257: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

253: return;
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;

Line 289: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

285: WHERE wdj.maintenance_object_type = 3 AND wdj.manual_rebuild_flag = 'N'
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;

Line 334: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

330:
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: (

Line 347: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

343: x_return_status => l_return_status,
344: x_msg_count => l_msg_count,
345: x_msg_data => l_msg_data
346: );
347: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
348: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METER_PUB.update_meter() with return_status : ' || l_return_status);
349: END IF;
350:
351: x_eam_wo_comp_rebuild_tbl(ii).return_status := l_return_status;

Line 355: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN

351: x_eam_wo_comp_rebuild_tbl(ii).return_status := l_return_status;
352:
353: IF l_return_status <> 'S' THEN
354:
355: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
356: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METER_PUB.update_meter()..: ' || l_msg_data);
357: END IF;
358: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
359: ( p_message_name => NULL

Line 371: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

367: END LOOP;
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: (

Line 382: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

378: p_instance_id => l_eam_wo_comp_rebuild_tbl(ii).instance_id_removed ,
379: x_return_status => l_msg_data ,
380: x_error_message => l_msg_count
381: );
382: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
383: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from csi_eam_interface_grp.rebuildable_return() with return_status : ' || l_msg_data);
384: END IF;
385:
386: END IF;

Line 392: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

388:
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;

Line 418: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

414: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
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;

Line 437: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

433: AND organization_id = p_eam_wo_comp_rebuild_tbl(ii).organization_id;
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

Line 452: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

448: , x_return_status => l_return_status
449: , x_msg_count => l_msg_count
450: , x_msg_data => l_msg_data
451: );
452: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
453: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY() with return_status : ' || l_return_status);
454: END IF;
455:
456: x_eam_wo_comp_rebuild_tbl(ii).return_status := l_return_status;

Line 459: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN

455:
456: x_eam_wo_comp_rebuild_tbl(ii).return_status := l_return_status;
457:
458: IF l_return_status <> 'S' THEN
459: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
460: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY()..: ' || l_msg_data);
461: END IF;
462: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
463: ( p_message_name => NULL

Line 493: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

489:
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;

Line 514: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

510: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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;

Line 526: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

522: FOR ii in p_eam_wo_comp_rebuild_tbl.FIRST..p_eam_wo_comp_rebuild_tbl.LAST LOOP
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

Line 543: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

539: x_return_status => l_return_status,
540: x_msg_count => l_msg_count,
541: x_msg_data => l_msg_data
542: );
543: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
544: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from wip_eam_genealogy_pvt.update_eam_genealogy() with return_status : ' || l_return_status);
545: END IF;
546:
547: x_eam_wo_comp_rebuild_tbl(ii).return_status := l_return_status;

Line 551: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN

547: x_eam_wo_comp_rebuild_tbl(ii).return_status := l_return_status;
548:
549: IF l_return_status <> 'S' THEN
550:
551: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
552: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM wip_eam_genealogy_pvt.update_eam_genealogy()..: ' || l_msg_data);
553: END IF;
554: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
555: ( p_message_name => NULL

Line 567: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

563: END IF;
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;

Line 589: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

585: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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;

Line 598: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

594: x_eam_meter_reading_tbl := p_eam_meter_reading_tbl;
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(

Line 611: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

607: x_return_status => l_return_status,
608: x_msg_count => l_msg_count,
609: x_msg_data => l_msg_data
610: );
611: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
612: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METERS_UTIL.update_last_service_reading_wo() with return_status : ' || l_return_status);
613: END IF;
614:
615: x_eam_meter_reading_tbl(i).return_status := l_return_status;

Line 618: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN

614:
615: x_eam_meter_reading_tbl(i).return_status := l_return_status;
616:
617: IF l_return_status <> 'S' THEN
618: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
619: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METERS_UTIL.update_last_service_reading_wo()..: ' || l_msg_data);
620: END IF;
621: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
622: ( p_message_name => NULL

Line 631: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

627: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
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:

Line 645: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

641: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
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;

Line 667: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN

663: END LOOP;
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;

Line 673: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

669: END IF;
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;