APPS.EAM_METR_VALIDATOR dependencies on EAM_MRI_UTILS

Line 159: eam_mri_utils.error_if(

155:
156: procedure last_updated_by(p_current_rowid in rowid,
157: p_interface_id in number) is
158: begin
159: eam_mri_utils.error_if(
160: p_current_rowid,
161: p_interface_id,
162: '((LAST_UPDATED_BY IS NULL AND LAST_UPDATED_BY_NAME IS NULL)
163: OR NOT EXISTS

Line 193: eam_mri_utils.error_if(

189:
190: procedure created_by(p_current_rowid in rowid,
191: p_interface_id in number) is
192: begin
193: eam_mri_utils.error_if(
194: p_current_rowid,
195: p_interface_id,
196: '((CREATED_BY IS NULL AND CREATED_BY_NAME IS NULL)
197: OR NOT EXISTS

Line 280: eam_mri_utils.error_if(

276: FALSE);
277: end if;
278:
279:
280: eam_mri_utils.error_if(
281: p_current_rowid,
282: p_interface_id,
283: '(NOT EXISTS (SELECT 1
284: FROM ORG_ORGANIZATION_DEFINITIONS

Line 431: eam_mri_utils.error_if(

427: p_retcode := '#';
428: return;
429: end if;
430:
431: eam_mri_utils.error_if(
432: p_current_rowid,
433: p_interface_id,
434: '(NOT EXISTS
435: (SELECT METER_ID

Line 459: eam_mri_utils.error_if(

455:
456: procedure reading_date(p_current_rowid in rowid,
457: p_interface_id in number) is
458: begin
459: eam_mri_utils.error_if(
460: p_current_rowid,
461: p_interface_id,
462: '(MRI.READING_DATE > SYSDATE
463: OR NOT EXISTS

Line 473: eam_mri_utils.error_if(

469: AND NVL(EM.TO_EFFECTIVE_DATE, MRI.READING_DATE+1)))',
470: 'EAM',
471: 'EAM_MR_INVALID_READING_DATE'
472: );
473: eam_mri_utils.error_if(
474: p_current_rowid,
475: p_interface_id,
476: '(EXISTS (SELECT 1
477: FROM EAM_METER_READINGS EM

Line 496: eam_mri_utils.error_if(

492: x_reset_flag varchar2(1);
493: begin
494: -- if it is reset and there is any meter reading data in the history table
495: -- that are after the reset, then we error out.
496: eam_mri_utils.error_if(
497: p_current_rowid,
498: p_interface_id,
499: '((RESET_FLAG = ''Y''
500: AND EXISTS