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_VALIDATOR dependencies on EAM_INT_UTILS

Line 46: eam_int_utils.record_error(p_interface_id, FND_Message.get, FALSE);

42: p_interface_id => p_interface_id,
43: p_retcode => l_retcode);
44: if (l_retcode='2') then
45: FND_Message.set_name('EAM', 'EAM_METINT_MISSING_MT_INFO');
46: eam_int_utils.record_error(p_interface_id, FND_Message.get, FALSE);
47: end if;
48:
49: select reading_value, reading_change, meter_id, reading_date
50: into l_current_reading, l_reading_change, l_meter_id, l_reading_date

Line 57: eam_int_utils.record_error(p_interface_id, FND_Message.get, FALSE);

53:
54: if (l_current_reading is null) then
55: if (l_reading_change is null) then
56: FND_Message.set_name('EAM', 'EAM_METINT_MISSING_READING');
57: eam_int_utils.record_error(p_interface_id, FND_Message.get, FALSE);
58: else
59: select max(current_reading_date) into l_last_reading_date
60: from eam_meter_readings
61: where meter_id=l_meter_id

Line 85: eam_int_utils.record_error(p_interface_id, FND_Message.get, FALSE);

81: end if;
82: exception
83: when no_data_found then
84: FND_Message.set_name('EAM', 'EAM_METINT_MISSING_READING');
85: eam_int_utils.record_error(p_interface_id, FND_Message.get, FALSE);
86: end populate_reading;
87:
88: procedure populate_who(p_current_rowid in rowid,
89: p_interface_id in number) is

Line 143: eam_int_utils.derive_id_from_code(

139:
140: procedure last_updated_by_name(p_current_rowid in rowid,
141: p_interface_id in number) is
142: begin
143: eam_int_utils.derive_id_from_code(
144: p_current_rowid,
145: p_interface_id,
146: 'eam_meter_readings_interface mri',
147: 'LAST_UPDATED_BY',

Line 177: eam_int_utils.derive_id_from_code(

173:
174: procedure created_by_name(p_current_rowid in rowid,
175: p_interface_id in number) is
176: begin
177: eam_int_utils.derive_id_from_code(
178: p_current_rowid,
179: p_interface_id,
180: 'eam_meter_readings_interface mri',
181: 'CREATED_BY',

Line 229: eam_int_utils.record_error(p_interface_id,

225: where organization_code = x_org_code;
226:
227: if (nvl(x_eam_enabled, 'N') = 'N') then
228: fnd_message.set_name('EAM', 'EAM_ORG_EAM_ENABLED');
229: eam_int_utils.record_error(p_interface_id,
230: fnd_message.get,
231: FALSE);
232: end if;
233:

Line 234: eam_int_utils.derive_id_from_code(

230: fnd_message.get,
231: FALSE);
232: end if;
233:
234: eam_int_utils.derive_id_from_code(
235: p_current_rowid,
236: p_interface_id,
237: 'eam_meter_readings_interface mri',
238: 'ORGANIZATION_ID',

Line 248: eam_int_utils.record_error(p_interface_id,

244: );
245: exception
246: when others then
247: fnd_message.set_name('EAM', 'EAM_MR_ORG_INFO_MISSING');
248: eam_int_utils.record_error(p_interface_id,
249: fnd_message.get,
250: FALSE);
251: end organization_code;
252:

Line 274: eam_int_utils.record_error(p_interface_id,

270: where organization_id = x_org_id;
271:
272: if (nvl(x_eam_enabled, 'N') = 'N') then
273: fnd_message.set_name('EAM', 'EAM_ORG_EAM_ENABLED');
274: eam_int_utils.record_error(p_interface_id,
275: fnd_message.get,
276: FALSE);
277: end if;
278:

Line 295: eam_int_utils.record_error(p_interface_id,

291: 'WIP_ML_ORGANIZATION_ID');
292: exception
293: when others then
294: fnd_message.set_name('EAM', 'EAM_MR_ORG_INFO_MISSING');
295: eam_int_utils.record_error(p_interface_id,
296: fnd_message.get,
297: FALSE);
298: end organization_id;
299:

Line 320: eam_int_utils.record_error(p_interface_id,

316: if ( x_work_order_name is not null AND
317: x_wip_entity_id is null AND
318: x_org_id is null ) then
319: fnd_message.set_name('EAM', 'EAM_MR_ORG_INFO_MISSING');
320: eam_int_utils.record_error(p_interface_id,
321: fnd_message.get,
322: FALSE);
323: end if;
324:

Line 325: eam_int_utils.derive_id_from_code(

321: fnd_message.get,
322: FALSE);
323: end if;
324:
325: eam_int_utils.derive_id_from_code(
326: p_current_rowid,
327: p_interface_id,
328: 'eam_meter_readings_interface mri',
329: 'WIP_ENTITY_ID',

Line 348: if ( NOT eam_int_utils.request_matches_condition(

344: if ( x_wip_entity_id is null ) then
345: return;
346: end if;
347:
348: if ( NOT eam_int_utils.request_matches_condition(
349: p_current_rowid,
350: p_interface_id,
351: 'eam_meter_readings_interface mri',
352: 'exists (select 1

Line 362: eam_int_utils.record_invalid_column_error(

358: and eam.asset_number = wdj.asset_number
359: and eam.asset_group_id = wdj.asset_group_id
360: and eam.meter_id = mri.meter_id
361: and we.wip_entity_id = wdj.wip_entity_id)') ) then
362: eam_int_utils.record_invalid_column_error(
363: p_interface_id,
364: 'WIP_ENTITY_ID');
365: end if;
366:

Line 375: eam_int_utils.derive_id_from_code(

371: p_interface_id in number,
372: p_retcode out NOCOPY varchar2) is
373: begin
374: p_retcode := '0';
375: eam_int_utils.derive_id_from_code(
376: p_current_rowid,
377: p_interface_id,
378: 'eam_meter_readings_interface mri',
379: 'METER_ID',

Line 389: eam_int_utils.derive_code_from_id(

385: NVL(FROM_EFFECTIVE_DATE, MRI.READING_DATE-1)
386: AND NVL(TO_EFFECTIVE_DATE, MRI.READING_DATE+1))'
387: );
388:
389: eam_int_utils.derive_code_from_id(
390: p_current_rowid,
391: p_interface_id,
392: 'eam_meter_readings_interface mri',
393: 'METER_ID',

Line 403: if ( eam_int_utils.has_errors ) then

399: NVL(FROM_EFFECTIVE_DATE, MRI.READING_DATE-1)
400: AND NVL(TO_EFFECTIVE_DATE, MRI.READING_DATE+1))'
401: );
402:
403: if ( eam_int_utils.has_errors ) then
404: eam_int_utils.load_errors('eam_meter_readings_interface');
405: update eam_meter_readings_interface
406: set process_status = WIP_CONSTANTS.ERROR,
407: process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 404: eam_int_utils.load_errors('eam_meter_readings_interface');

400: AND NVL(TO_EFFECTIVE_DATE, MRI.READING_DATE+1))'
401: );
402:
403: if ( eam_int_utils.has_errors ) then
404: eam_int_utils.load_errors('eam_meter_readings_interface');
405: update eam_meter_readings_interface
406: set process_status = WIP_CONSTANTS.ERROR,
407: process_phase = WIP_CONSTANTS.ML_VALIDATION
408: where rowid = p_current_rowid;

Line 444: if ( eam_int_utils.has_errors ) then

440: AND NVL(TO_EFFECTIVE_DATE, MRI.READING_DATE+1)))',
441: 'EAM',
442: 'EAM_MR_INVALID_METER');
443:
444: if ( eam_int_utils.has_errors ) then
445: eam_int_utils.load_errors('eam_meter_readings_interface');
446: update eam_meter_readings_interface
447: set process_status = WIP_CONSTANTS.ERROR,
448: process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 445: eam_int_utils.load_errors('eam_meter_readings_interface');

441: 'EAM',
442: 'EAM_MR_INVALID_METER');
443:
444: if ( eam_int_utils.has_errors ) then
445: eam_int_utils.load_errors('eam_meter_readings_interface');
446: update eam_meter_readings_interface
447: set process_status = WIP_CONSTANTS.ERROR,
448: process_phase = WIP_CONSTANTS.ML_VALIDATION
449: where rowid = p_current_rowid;

Line 510: eam_int_utils.warn_irrelevant_column(

506: 'EAM',
507: 'EAM_MR_RESET_NOT_ALLOWED'
508: );
509:
510: eam_int_utils.warn_irrelevant_column(
511: p_current_rowid,
512: p_interface_id,
513: 'eam_meter_readings_interface mri',
514: 'LIFE_TO_DATE_READING',

Line 549: eam_int_utils.record_error(p_interface_id,

545: end;
546:
547: if ( x_ltd is null ) then
548: fnd_message.set_name('EAM', 'EAM_NO_PREV_READING_LTD');
549: eam_int_utils.record_error(p_interface_id,
550: fnd_message.get,
551: FALSE);
552: else
553: update eam_meter_readings_interface

Line 584: eam_int_utils.warn_redundant_column(

580: begin
581: -- if both life to date reading and reading value are provided even if
582: -- it is not resetting, we ignore the reading value field. Normally, this
583: -- would rarely happen.
584: eam_int_utils.warn_redundant_column(
585: p_current_rowid,
586: p_interface_id,
587: 'eam_meter_readings_interface',
588: 'life_to_date_reading',

Line 728: eam_int_utils.record_error(p_interface_id,

724: end if;
725:
726: if ( x_rule_broken ) then
727: fnd_message.set_name('EAM', 'EAM_MR_VALUE_BREAK_PATTERN');
728: eam_int_utils.record_error(p_interface_id,
729: fnd_message.get,
730: true);
731:
732: /*

Line 733: eam_int_utils.record_error(p_interface_id,

729: fnd_message.get,
730: true);
731:
732: /*
733: eam_int_utils.record_error(p_interface_id,
734: fnd_message.get,
735: false);
736: */
737: end if;

Line 856: eam_int_utils.record_error(p_interface_id,

852: end if;
853:
854: if ( x_rule_broken ) then
855: fnd_message.set_name('EAM', 'EAM_MR_LTD_BREAK_PATTERN');
856: eam_int_utils.record_error(p_interface_id,
857: fnd_message.get,
858: true);
859: end if;
860: