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_METERREADING_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 27: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

23: PROCEDURE Perform_Writes
24: (
25: p_eam_request_rec IN EAM_PROCESS_WO_PUB.eam_meter_reading_rec_type
26: , x_return_status OUT NOCOPY VARCHAR2
27: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
28: ) IS
29: BEGIN
30: null;
31: END Perform_Writes;

Line 40: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

36: , p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
37: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
38: , x_eam_counter_prop_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
39: , x_return_status OUT NOCOPY VARCHAR2
40: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
41: ) IS
42: l_meter_reading_rec EAM_MeterReading_PUB.Meter_Reading_Rec_Type;
43: l_counter_properties_tbl EAM_MeterReading_PUB.Ctr_Property_readings_Tbl;
44: l_count NUMBER;

Line 50: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(2000);
48: l_return_status VARCHAR2(1);
49: l_meter_reading_id NUMBER;
50: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
51: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
52: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
53:
54:

Line 51: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

47: l_msg_data VARCHAR2(2000);
48: l_return_status VARCHAR2(1);
49: l_meter_reading_id NUMBER;
50: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
51: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
52: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
53:
54:
55: BEGIN

Line 52: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

48: l_return_status VARCHAR2(1);
49: l_meter_reading_id NUMBER;
50: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
51: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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

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 163: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METERREADING_PUB.create_meter_reading() with return_status : ' || l_return_status);

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
167: x_eam_meter_reading_tbl(MM).return_status := l_return_status;

Line 182: EAM_ERROR_MESSAGE_PVT.Write_Debug('Error returned from EAM_METERREADING_PUB.create_meter_reading()..: ' || l_msg_data);

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
186: ( p_message_name => NULL

Line 185: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
186: ( p_message_name => NULL
187: , p_message_text => l_msg_data
188: , x_mesg_token_Tbl => x_mesg_token_tbl
189: );

Line 191: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

187: , p_message_text => l_msg_data
188: , x_mesg_token_Tbl => x_mesg_token_tbl
189: );
190:
191: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
192: return;
193: END IF;
194: END LOOP; -- Meter Loop
195: END IF; -- End of Meter Reading Count > 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 206: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

202: (
203: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
204: , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
205: , x_return_status OUT NOCOPY VARCHAR2
206: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
207: )IS
208: l_return_status VARCHAR2(1);
209: l_msg_count NUMBER;
210: l_msg_data VARCHAR2(2000);

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 237: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METER_PUB.update_meter() with 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:
241: IF l_return_status <> 'S' THEN

Line 244: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METER_PUB.update_meter().. : ' || l_msg_data);

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
248: , p_message_text => l_msg_data

Line 246: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
248: , p_message_text => l_msg_data
249: , x_mesg_token_Tbl => x_mesg_token_tbl
250: );

Line 252: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

248: , p_message_text => l_msg_data
249: , x_mesg_token_Tbl => x_mesg_token_tbl
250: );
251:
252: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
253: return;
254: END IF;
255: END LOOP;
256: END IF;

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

266: , p_subinventory_id IN VARCHAR2
267: , p_wip_entity_id IN NUMBER := NULL
268: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
269: , x_return_status OUT NOCOPY VARCHAR2
270: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
271: )IS
272: l_return_status VARCHAR2(1);
273: l_msg_count NUMBER;
274: l_msg_data VARCHAR2(2000);

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 348: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METER_PUB.update_meter() with 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;
352:

Line 356: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METER_PUB.update_meter()..: ' || l_msg_data);

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
360: , p_message_text => l_msg_data

Line 358: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
360: , p_message_text => l_msg_data
361: , x_mesg_token_Tbl => x_mesg_token_tbl
362: );

Line 364: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

360: , p_message_text => l_msg_data
361: , x_mesg_token_Tbl => x_mesg_token_tbl
362: );
363:
364: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
365: return;
366: END IF;
367: END LOOP;
368: END IF;

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 383: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from csi_eam_interface_grp.rebuildable_return() with return_status : ' || l_msg_data);

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

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

399: (
400: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
401: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
402: , x_return_status OUT NOCOPY VARCHAR2
403: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
404: )IS
405:
406: l_return_status VARCHAR2(1);
407: l_msg_count NUMBER;

Line 412: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

408: l_msg_data VARCHAR2(2000);
409: l_scheduled_start_date DATE;
410: l_scheduled_completion_date DATE;
411: l_primary_item_id NUMBER;
412: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
413: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
414: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
415:
416: BEGIN

Line 413: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

409: l_scheduled_start_date DATE;
410: l_scheduled_completion_date DATE;
411: l_primary_item_id NUMBER;
412: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
413: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
414: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
415:
416: BEGIN
417:

Line 414: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

410: l_scheduled_completion_date DATE;
411: l_primary_item_id NUMBER;
412: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
413: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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

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 453: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY() with 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;
457:

Line 460: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY()..: ' || l_msg_data);

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
464: , p_message_text => l_msg_data

Line 462: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
464: , p_message_text => l_msg_data
465: , x_mesg_token_Tbl => x_mesg_token_tbl
466: );

Line 468: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

464: , p_message_text => l_msg_data
465: , x_mesg_token_Tbl => x_mesg_token_tbl
466: );
467:
468: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
469: return;
470: END IF;
471: ELSE
472:

Line 478: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

474: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
475: l_token_tbl(1).token_value := p_eam_wo_comp_rebuild_tbl(ii).WIP_ENTITY_ID;
476:
477: l_out_mesg_token_tbl := l_mesg_token_tbl;
478: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
479: ( p_message_name => 'EAM_WCMP_ACT_EXISTS'
480: , p_token_tbl => l_Token_tbl
481: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
482: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

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

500: (
501: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
502: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
503: , x_return_status OUT NOCOPY VARCHAR2
504: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
505: )IS
506: l_return_status VARCHAR2(1);
507: l_msg_count NUMBER;
508: l_msg_data VARCHAR2(2000);

Line 509: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

505: )IS
506: l_return_status VARCHAR2(1);
507: l_msg_count NUMBER;
508: l_msg_data VARCHAR2(2000);
509: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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:

Line 510: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

506: l_return_status VARCHAR2(1);
507: l_msg_count NUMBER;
508: l_msg_data VARCHAR2(2000);
509: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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

Line 511: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

507: l_msg_count NUMBER;
508: l_msg_data VARCHAR2(2000);
509: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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()..');

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 544: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from wip_eam_genealogy_pvt.update_eam_genealogy() with 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;
548:

Line 552: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM wip_eam_genealogy_pvt.update_eam_genealogy()..: ' || l_msg_data);

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
556: , p_message_text => l_msg_data

Line 554: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
556: , p_message_text => l_msg_data
557: , x_mesg_token_Tbl => x_mesg_token_tbl
558: );

Line 560: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

556: , p_message_text => l_msg_data
557: , x_mesg_token_Tbl => x_mesg_token_tbl
558: );
559:
560: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
561: return;
562: END IF;
563: END IF;
564: END LOOP;

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

575: (
576: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
577: , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
578: , x_return_status OUT NOCOPY VARCHAR2
579: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
580: )IS
581: l_return_status VARCHAR2(1);
582: l_msg_count NUMBER;
583: l_msg_data VARCHAR2(2000);

Line 584: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

580: )IS
581: l_return_status VARCHAR2(1);
582: l_msg_count NUMBER;
583: l_msg_data VARCHAR2(2000);
584: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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:

Line 585: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

581: l_return_status VARCHAR2(1);
582: l_msg_count NUMBER;
583: l_msg_data VARCHAR2(2000);
584: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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

Line 586: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

582: l_msg_count NUMBER;
583: l_msg_data VARCHAR2(2000);
584: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
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()..');

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 612: EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METERS_UTIL.update_last_service_reading_wo() with 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;
616:

Line 619: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METERS_UTIL.update_last_service_reading_wo()..: ' || l_msg_data);

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
623: , p_message_text => l_msg_data

Line 621: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

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
623: , p_message_text => l_msg_data
624: , x_mesg_token_Tbl => x_mesg_token_tbl
625: );

Line 627: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

623: , p_message_text => l_msg_data
624: , x_mesg_token_Tbl => x_mesg_token_tbl
625: );
626:
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

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

637: (
638: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
639: , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
640: , x_return_status OUT NOCOPY VARCHAR2
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

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: