DBA Data[Home] [Help]

APPS.EAM_METERREADING_VALIDATE_PVT dependencies on EAM_PROCESS_WO_PVT

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

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

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

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

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

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

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

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

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

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

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

125: x_return_status := FND_API.G_RET_STS_ERROR;
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;

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

157:
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: /*

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

189:
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 ,

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

198: p_meter_id => 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;

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

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

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

219: from CSI_COUNTER_READINGS
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

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

232: SELECT SOURCE_COUNTER_ID INTO L_SOURCE_METER_ID FROM CSI_COUNTER_RELATIONSHIPS WHERE OBJECT_COUNTER_ID = MANDATORY_COUNTER_ID_TBL(J)
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)

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

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

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

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);
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;

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

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

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

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

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

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

Line 284: 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
285: EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_VALIDATE_PVT.MANDATORY_ENTERED()..');
286: END IF;
287: END MANDATORY_ENTERED;
288: