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

Line 28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

24: PROCEDURE CHECK_REQUIRED
25: (
26: p_eam_meter_reading_rec IN EAM_PROCESS_WO_PUB.eam_meter_reading_rec_type
27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29: )IS
30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

Line 30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

26: p_eam_meter_reading_rec IN EAM_PROCESS_WO_PUB.eam_meter_reading_rec_type
27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29: )IS
30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: l_status_type number;
34:

Line 31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29: )IS
30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: l_status_type number;
34:
35: BEGIN

Line 32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29: )IS
30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: l_status_type number;
34:
35: BEGIN
36: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 39: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()..');

35: BEGIN
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
39: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()..');
40: END IF;
41:
42: IF p_eam_meter_reading_rec.meter_id IS NULL
43: THEN

Line 45: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Error as p_eam_meter_reading_rec.meter_id is null in EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()');

41:
42: IF p_eam_meter_reading_rec.meter_id IS NULL
43: THEN
44: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
45: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Error as p_eam_meter_reading_rec.meter_id is null in EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()');
46: END IF;
47: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
48: l_token_tbl(1).token_value := p_eam_meter_reading_rec.WIP_ENTITY_ID;
49:

Line 51: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

47: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
48: l_token_tbl(1).token_value := p_eam_meter_reading_rec.WIP_ENTITY_ID;
49:
50: l_out_mesg_token_tbl := l_mesg_token_tbl;
51: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
52: ( p_message_name => 'EAM_WCMP_METERID_REQ'
53: , p_token_tbl => l_Token_tbl
54: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
55: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 66: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Error as p_eam_meter_reading_rec.current_reading is null in EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()');

62:
63: IF p_eam_meter_reading_rec.current_reading IS NULL
64: THEN
65: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
66: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Error as p_eam_meter_reading_rec.current_reading is null in EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()');
67: END IF;
68:
69: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
70: l_token_tbl(1).token_value := p_eam_meter_reading_rec.WIP_ENTITY_ID;

Line 73: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

69: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
70: l_token_tbl(1).token_value := p_eam_meter_reading_rec.WIP_ENTITY_ID;
71:
72: l_out_mesg_token_tbl := l_mesg_token_tbl;
73: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
74: ( p_message_name => 'EAM_WCMP_CURRENTREAD_REQ'
75: , p_token_tbl => l_Token_tbl
76: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
77: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 88: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Error as p_eam_meter_reading_rec.wo_end_date is null in EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()');

84:
85: IF p_eam_meter_reading_rec.wo_end_date IS NULL
86: THEN
87: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
88: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Error as p_eam_meter_reading_rec.wo_end_date is null in EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()');
89: END IF;
90:
91: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
92: l_token_tbl(1).token_value := p_eam_meter_reading_rec.WIP_ENTITY_ID;

Line 95: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

91: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
92: l_token_tbl(1).token_value := p_eam_meter_reading_rec.WIP_ENTITY_ID;
93:
94: l_out_mesg_token_tbl := l_mesg_token_tbl;
95: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
96: ( p_message_name => 'EAM_WCMP_ENDDATE_REQ'
97: , p_token_tbl => l_Token_tbl
98: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
99: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 110: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Last Condition failed in EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()');

106:
107: IF p_eam_meter_reading_rec.reset_flag IS NOT NULL AND p_eam_meter_reading_rec.value_before_reset IS NULL
108: THEN
109: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
110: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Last Condition failed in EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()');
111: END IF;
112:
113: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
114: l_token_tbl(1).token_value := p_eam_meter_reading_rec.WIP_ENTITY_ID;

Line 117: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

113: l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
114: l_token_tbl(1).token_value := p_eam_meter_reading_rec.WIP_ENTITY_ID;
115:
116: l_out_mesg_token_tbl := l_mesg_token_tbl;
117: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
118: ( p_message_name => 'EAM_WCMP_VALBRESET_REQ'
119: , p_token_tbl => l_Token_tbl
120: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
121: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 130: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()..Successfully');

126: return;
127: END IF;
128:
129: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
130: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_VALIDATE_PVT.CHECK_REQUIRED()..Successfully');
131: END IF;
132:
133: END CHECK_REQUIRED;
134:

Line 162: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_VALIDATE_PVT.MANDATORY_ENTERED()..');

158: x_man_reading_enter :=TRUE;
159: x_return_status := FND_API.G_RET_STS_SUCCESS;
160:
161: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
162: EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_VALIDATE_PVT.MANDATORY_ENTERED()..');
163: END IF;
164:
165: /*
166: Before processing the meter readings we will query eam_asset_meters table to get list of

Line 194: EAM_ERROR_MESSAGE_PVT.Write_Debug('Id of Meters' || I || 'associated: ' || counter_id_tbl(I));

190: IF counter_id_tbl.COUNT > 0 THEN
191:
192: FOR I IN counter_id_tbl.FIRST..counter_id_tbl.LAST LOOP
193: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
194: EAM_ERROR_MESSAGE_PVT.Write_Debug('Id of Meters' || I || 'associated: ' || counter_id_tbl(I));
195: END IF;
196: is_meter_mandatory := Eam_Meters_Util.is_meter_reading_mandatory(
197: p_wip_entity_id => p_wip_entity_id ,
198: p_meter_id => counter_id_tbl(I)

Line 203: EAM_ERROR_MESSAGE_PVT.Write_Debug('This meter is mandatory! : ' || counter_id_tbl(I));

199: );
200:
201: IF is_meter_mandatory = TRUE THEN
202: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
203: EAM_ERROR_MESSAGE_PVT.Write_Debug('This meter is mandatory! : ' || counter_id_tbl(I));
204: END IF;
205: mandatory_counter_id_tbl(loop_var) := counter_id_tbl(I);
206: loop_var := loop_var + 1;
207: END IF ;

Line 214: EAM_ERROR_MESSAGE_PVT.Write_Debug('MANDATORY_COUNTER_ID_TBL(J)'||to_char(MANDATORY_COUNTER_ID_TBL(J)));

210:
211: IF mandatory_counter_id_tbl.COUNT > 0 THEN
212: FOR J IN mandatory_counter_id_tbl.FIRST..mandatory_counter_id_tbl.LAST LOOP
213: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
214: EAM_ERROR_MESSAGE_PVT.Write_Debug('MANDATORY_COUNTER_ID_TBL(J)'||to_char(MANDATORY_COUNTER_ID_TBL(J)));
215: END IF;
216: flag :=FALSE;
217:
218: select count(*) into l_no_of_reading

Line 224: EAM_ERROR_MESSAGE_PVT.Write_Debug('p_work_order_cmpl_date'||to_char(p_work_order_cmpl_date,'DD-MON-YYYY HH24:MI:SS'));

220: where counter_id = mandatory_counter_id_tbl(J)
221: and value_timestamp = p_work_order_cmpl_date
222: and DISABLED_FLAG = 'N'; -- BUG 12536849
223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
224: EAM_ERROR_MESSAGE_PVT.Write_Debug('p_work_order_cmpl_date'||to_char(p_work_order_cmpl_date,'DD-MON-YYYY HH24:MI:SS'));
225: EAM_ERROR_MESSAGE_PVT.Write_Debug('L_NO_OF_READING'||to_char(L_NO_OF_READING) );
226: END IF;
227: IF L_NO_OF_READING = 0 THEN
228: /* WHEN COMING FROM WIRELESS,P_EAM_METER_READING_TBL HAS ALL THE SOURCE COUNTER ID'S

Line 225: EAM_ERROR_MESSAGE_PVT.Write_Debug('L_NO_OF_READING'||to_char(L_NO_OF_READING) );

221: and value_timestamp = p_work_order_cmpl_date
222: and DISABLED_FLAG = 'N'; -- BUG 12536849
223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
224: EAM_ERROR_MESSAGE_PVT.Write_Debug('p_work_order_cmpl_date'||to_char(p_work_order_cmpl_date,'DD-MON-YYYY HH24:MI:SS'));
225: EAM_ERROR_MESSAGE_PVT.Write_Debug('L_NO_OF_READING'||to_char(L_NO_OF_READING) );
226: END IF;
227: IF L_NO_OF_READING = 0 THEN
228: /* WHEN COMING FROM WIRELESS,P_EAM_METER_READING_TBL HAS ALL THE SOURCE COUNTER ID'S
229: Added for Issue # 4 of Bug # 4932595*/

Line 237: EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking meter ids'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );

233: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE(+), SYSDATE-1) AND NVL(ACTIVE_END_DATE(+), SYSDATE+1);
234: -- LOOP THROUGH P_EAM_METER_READING_TBL TO CHECK WHETHER READINGS ARE ENTERED OR NOT
235: FOR K IN P_EAM_METER_READING_TBL.FIRST..P_EAM_METER_READING_TBL.LAST LOOP
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
237: EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking meter ids'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );
238: EAM_ERROR_MESSAGE_PVT.Write_Debug('Current Reading'||to_char(P_EAM_METER_READING_TBL(K).CURRENT_READING ) );
239: End IF;
240: -- IF SOURCE METER ID IS NULL THEN COMPARE P_EAM_METER_READING_TBL(K)
241: IF NVL(L_SOURCE_METER_ID,P_EAM_METER_READING_TBL(K).METER_ID) <> MANDATORY_COUNTER_ID_TBL(J) THEN

Line 238: EAM_ERROR_MESSAGE_PVT.Write_Debug('Current Reading'||to_char(P_EAM_METER_READING_TBL(K).CURRENT_READING ) );

234: -- LOOP THROUGH P_EAM_METER_READING_TBL TO CHECK WHETHER READINGS ARE ENTERED OR NOT
235: FOR K IN P_EAM_METER_READING_TBL.FIRST..P_EAM_METER_READING_TBL.LAST LOOP
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
237: EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking meter ids'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );
238: EAM_ERROR_MESSAGE_PVT.Write_Debug('Current Reading'||to_char(P_EAM_METER_READING_TBL(K).CURRENT_READING ) );
239: End IF;
240: -- IF SOURCE METER ID IS NULL THEN COMPARE P_EAM_METER_READING_TBL(K)
241: IF NVL(L_SOURCE_METER_ID,P_EAM_METER_READING_TBL(K).METER_ID) <> MANDATORY_COUNTER_ID_TBL(J) THEN
242: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

Line 243: EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside If 1 - meter id'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );

239: End IF;
240: -- IF SOURCE METER ID IS NULL THEN COMPARE P_EAM_METER_READING_TBL(K)
241: IF NVL(L_SOURCE_METER_ID,P_EAM_METER_READING_TBL(K).METER_ID) <> MANDATORY_COUNTER_ID_TBL(J) THEN
242: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
243: EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside If 1 - meter id'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );
244: END IF;
245: -- IF P_EAM_METER_READING_TBL HAS AN NON MANDATORY READING
246: SELECT SOURCE_COUNTER_ID INTO L_SOURCE_METER_ID_P FROM CSI_COUNTER_RELATIONSHIPS WHERE OBJECT_COUNTER_ID = P_EAM_METER_READING_TBL(K).METER_ID
247: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE(+), SYSDATE-1) AND NVL(ACTIVE_END_DATE(+), SYSDATE+1);

Line 250: EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside If 2 - meter id'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );

246: SELECT SOURCE_COUNTER_ID INTO L_SOURCE_METER_ID_P FROM CSI_COUNTER_RELATIONSHIPS WHERE OBJECT_COUNTER_ID = P_EAM_METER_READING_TBL(K).METER_ID
247: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE(+), SYSDATE-1) AND NVL(ACTIVE_END_DATE(+), SYSDATE+1);
248: IF L_SOURCE_METER_ID_P IS NOT NULL THEN
249: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
250: EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside If 2 - meter id'||to_char(P_EAM_METER_READING_TBL(K).METER_ID) );
251: END IF;
252: FLAG := TRUE;
253: END IF;
254: END IF;

Line 259: EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Con 1');

255: END LOOP;
256: ELSE
257: X_MAN_READING_ENTER := FALSE;
258: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
259: EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Con 1');
260: END IF;
261: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
262: RETURN;
263: END IF;

Line 268: EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Con 2');

264:
265: IF FLAG THEN
266: X_MAN_READING_ENTER := FALSE;
267: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
268: EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Con 2');
269: END IF;
270: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
271: RETURN;
272: END IF;

Line 280: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Exception FROM EAM_METERREADING_VALIDATE_PVT.MANDATORY_ENTERED()');

276: END IF;
277: EXCEPTION
278: WHEN OTHERS THEN
279: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
280: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Exception FROM EAM_METERREADING_VALIDATE_PVT.MANDATORY_ENTERED()');
281: END IF;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283:
284: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

Line 285: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_VALIDATE_PVT.MANDATORY_ENTERED()..');

281: END IF;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283:
284: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
285: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_VALIDATE_PVT.MANDATORY_ENTERED()..');
286: END IF;
287: END MANDATORY_ENTERED;
288:
289: END EAM_METERREADING_VALIDATE_PVT;