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_METR_PROCESSOR dependencies on WIP_CONSTANTS

Line 22: and process_phase = WIP_CONSTANTS.ML_VALIDATION

18: cursor allmeters is
19: select distinct meter_id
20: from eam_meter_readings_interface
21: where group_id = p_group_id
22: and process_phase = WIP_CONSTANTS.ML_VALIDATION
23: and process_status = WIP_CONSTANTS.RUNNING;
24:
25: x_meter_id number;
26: x_retcode varchar2(1);

Line 23: and process_status = WIP_CONSTANTS.RUNNING;

19: select distinct meter_id
20: from eam_meter_readings_interface
21: where group_id = p_group_id
22: and process_phase = WIP_CONSTANTS.ML_VALIDATION
23: and process_status = WIP_CONSTANTS.RUNNING;
24:
25: x_meter_id number;
26: x_retcode varchar2(1);
27: x_has_error boolean := false;

Line 77: and process_phase = WIP_CONSTANTS.ML_VALIDATION

73: cursor allrows is
74: select rowid, interface_id
75: from eam_meter_readings_interface
76: where group_id = p_group_id
77: and process_phase = WIP_CONSTANTS.ML_VALIDATION
78: and process_status = WIP_CONSTANTS.RUNNING;
79:
80: x_current_rowid rowid;
81: x_interface_id number;

Line 78: and process_status = WIP_CONSTANTS.RUNNING;

74: select rowid, interface_id
75: from eam_meter_readings_interface
76: where group_id = p_group_id
77: and process_phase = WIP_CONSTANTS.ML_VALIDATION
78: and process_status = WIP_CONSTANTS.RUNNING;
79:
80: x_current_rowid rowid;
81: x_interface_id number;
82: x_retcode varchar2(1);

Line 90: process_status = WIP_CONSTANTS.RUNNING

86: p_retcode := '0';
87: -- generates the interface id and lock the rows
88: update eam_meter_readings_interface
89: set interface_id = wip_interface_s.nextval,
90: process_status = WIP_CONSTANTS.RUNNING
91: where group_id = p_group_id
92: and process_phase = WIP_CONSTANTS.ML_VALIDATION
93: and process_status = WIP_CONSTANTS.PENDING;
94:

Line 92: and process_phase = WIP_CONSTANTS.ML_VALIDATION

88: update eam_meter_readings_interface
89: set interface_id = wip_interface_s.nextval,
90: process_status = WIP_CONSTANTS.RUNNING
91: where group_id = p_group_id
92: and process_phase = WIP_CONSTANTS.ML_VALIDATION
93: and process_status = WIP_CONSTANTS.PENDING;
94:
95: -- validate meter name and meter id field for all rows.
96: open allrows;

Line 93: and process_status = WIP_CONSTANTS.PENDING;

89: set interface_id = wip_interface_s.nextval,
90: process_status = WIP_CONSTANTS.RUNNING
91: where group_id = p_group_id
92: and process_phase = WIP_CONSTANTS.ML_VALIDATION
93: and process_status = WIP_CONSTANTS.PENDING;
94:
95: -- validate meter name and meter id field for all rows.
96: open allrows;
97: LOOP

Line 133: and process_phase = WIP_CONSTANTS.ML_VALIDATION

129: select rowid, interface_id, disable_flag, meter_id, reading_date
130: from eam_meter_readings_interface
131: where group_id = p_group_id
132: and meter_id = p_meter_id
133: and process_phase = WIP_CONSTANTS.ML_VALIDATION
134: and process_status = WIP_CONSTANTS.RUNNING
135: order by reading_date;
136:
137: x_rowid rowid;

Line 134: and process_status = WIP_CONSTANTS.RUNNING

130: from eam_meter_readings_interface
131: where group_id = p_group_id
132: and meter_id = p_meter_id
133: and process_phase = WIP_CONSTANTS.ML_VALIDATION
134: and process_status = WIP_CONSTANTS.RUNNING
135: order by reading_date;
136:
137: x_rowid rowid;
138: x_interface_id number;

Line 163: set process_status = WIP_CONSTANTS.ERROR

159: -- rollback the default, etc.
160: rollback to savepoint eam_meter_reading_start;
161: -- set the error status for the current record
162: update eam_meter_readings_interface
163: set process_status = WIP_CONSTANTS.ERROR
164: where rowid = x_rowid;
165: -- set the return code
166: p_retcode := '2';
167: else

Line 171: set process_phase = WIP_CONSTANTS.ML_INSERTION

167: else
168: -- if the row passed validation, then we set the process phase
169: -- and then do the insertion
170: update eam_meter_readings_interface
171: set process_phase = WIP_CONSTANTS.ML_INSERTION
172: where rowid = x_rowid;
173:
174: if (l_disable_flag is not null and l_disable_flag='Y') then
175: eam_meterreading_pub.disable_meter_reading

Line 189: set process_phase = WIP_CONSTANTS.ML_VALIDATION,

185: fnd_message.set_name('EAM', 'EAM_METINT_DISABLE_ERROR'); eam_int_utils.record_error(x_interface_id,
186: fnd_message.get,
187: FALSE);
188: update eam_meter_readings_interface
189: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
190: process_status = WIP_CONSTANTS.ERROR
191: where rowid = x_rowid;
192: else
193: update eam_meter_readings_interface

Line 190: process_status = WIP_CONSTANTS.ERROR

186: fnd_message.get,
187: FALSE);
188: update eam_meter_readings_interface
189: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
190: process_status = WIP_CONSTANTS.ERROR
191: where rowid = x_rowid;
192: else
193: update eam_meter_readings_interface
194: set process_phase = WIP_CONSTANTS.ML_COMPLETE,

Line 194: set process_phase = WIP_CONSTANTS.ML_COMPLETE,

190: process_status = WIP_CONSTANTS.ERROR
191: where rowid = x_rowid;
192: else
193: update eam_meter_readings_interface
194: set process_phase = WIP_CONSTANTS.ML_COMPLETE,
195: process_status = WIP_CONSTANTS.COMPLETED
196: where rowid = x_rowid;
197: end if;
198: else

Line 195: process_status = WIP_CONSTANTS.COMPLETED

191: where rowid = x_rowid;
192: else
193: update eam_meter_readings_interface
194: set process_phase = WIP_CONSTANTS.ML_COMPLETE,
195: process_status = WIP_CONSTANTS.COMPLETED
196: where rowid = x_rowid;
197: end if;
198: else
199: insert_one_row(x_rowid);

Line 202: set process_phase = WIP_CONSTANTS.ML_COMPLETE,

198: else
199: insert_one_row(x_rowid);
200:
201: update eam_meter_readings_interface
202: set process_phase = WIP_CONSTANTS.ML_COMPLETE,
203: process_status = WIP_CONSTANTS.COMPLETED
204: where rowid = x_rowid;
205: end if;
206: end if;

Line 203: process_status = WIP_CONSTANTS.COMPLETED

199: insert_one_row(x_rowid);
200:
201: update eam_meter_readings_interface
202: set process_phase = WIP_CONSTANTS.ML_COMPLETE,
203: process_status = WIP_CONSTANTS.COMPLETED
204: where rowid = x_rowid;
205: end if;
206: end if;
207:

Line 296: where process_phase = WIP_CONSTANTS.ML_COMPLETE

292: delete from wip_interface_errors
293: where interface_id in
294: (select interface_id
295: from eam_meter_readings_interface
296: where process_phase = WIP_CONSTANTS.ML_COMPLETE
297: and group_id = p_group_id
298: and process_status = WIP_CONSTANTS.COMPLETED);
299:
300: delete from eam_meter_readings_interface

Line 298: and process_status = WIP_CONSTANTS.COMPLETED);

294: (select interface_id
295: from eam_meter_readings_interface
296: where process_phase = WIP_CONSTANTS.ML_COMPLETE
297: and group_id = p_group_id
298: and process_status = WIP_CONSTANTS.COMPLETED);
299:
300: delete from eam_meter_readings_interface
301: where process_phase = WIP_CONSTANTS.ML_COMPLETE
302: and group_id = p_group_id

Line 301: where process_phase = WIP_CONSTANTS.ML_COMPLETE

297: and group_id = p_group_id
298: and process_status = WIP_CONSTANTS.COMPLETED);
299:
300: delete from eam_meter_readings_interface
301: where process_phase = WIP_CONSTANTS.ML_COMPLETE
302: and group_id = p_group_id
303: and process_status = WIP_CONSTANTS.COMPLETED;
304:
305: end end_processing;

Line 303: and process_status = WIP_CONSTANTS.COMPLETED;

299:
300: delete from eam_meter_readings_interface
301: where process_phase = WIP_CONSTANTS.ML_COMPLETE
302: and group_id = p_group_id
303: and process_status = WIP_CONSTANTS.COMPLETED;
304:
305: end end_processing;
306:
307: END eam_metr_processor;