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.IGS_AD_IMP_NEAR_MTCH_PKG dependencies on APP_EXCEPTION

Line 56: App_Exception.Raise_Exception;

52: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
53: Close cur_old_ref_values;
54: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
55: IGS_GE_MSG_STACK.ADD;
56: App_Exception.Raise_Exception;
57: Return;
58: END IF;
59: Close cur_old_ref_values;
60:

Line 118: App_Exception.Raise_Exception;

114: Column_Name IS NULL THEN
115: IF NOT (new_references.action IN ('I','D')) THEN
116: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121:
122:

Line 147: App_Exception.Raise_Exception;

143: new_references.interface_id
144: ) THEN
145: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:
150: IF (((old_references.person_id_type = new_references.person_id_type)) OR
151: ((new_references.person_id_type IS NULL))) THEN

Line 158: App_Exception.Raise_Exception;

154: new_references.person_id_type
155: ) THEN
156: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160:
161: /* IF (((old_references.addr_type = new_references.addr_type)) OR
162: ((new_references.addr_type IS NULL))) THEN

Line 169: App_Exception.Raise_Exception;

165: new_references.addr_type
166: ) THEN
167: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: */
172: IF (((old_references.match_set_id = new_references.match_set_id)) OR
173: ((new_references.match_set_id IS NULL))) THEN

Line 180: App_Exception.Raise_Exception;

176: new_references.match_set_id
177: ) THEN
178: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182:
183: IF (((old_references.person_id = new_references.person_id)) OR
184: ((new_references.person_id IS NULL))) THEN

Line 191: App_Exception.Raise_Exception;

187: new_references.person_id
188: ) THEN
189: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193:
194: END Check_Parent_Existance;
195:

Line 262: App_Exception.Raise_Exception;

258: IF (cur_rowid%FOUND) THEN
259: Close cur_rowid;
260: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_AINT_FK');
261: IGS_GE_MSG_STACK.ADD;
262: App_Exception.Raise_Exception;
263: Return;
264: END IF;
265: Close cur_rowid;
266:

Line 299: App_Exception.Raise_Exception;

295: IF (cur_rowid%FOUND) THEN
296: Close cur_rowid;
297: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_ADT_FK');
298: IGS_GE_MSG_STACK.ADD;
299: App_Exception.Raise_Exception;
300: Return;
301: END IF;
302: Close cur_rowid;
303:

Line 336: App_Exception.Raise_Exception;

332: IF (cur_rowid%FOUND) THEN
333: Close cur_rowid;
334: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_PMS_FK');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: Return;
338: END IF;
339: Close cur_rowid;
340:

Line 373: App_Exception.Raise_Exception;

369: IF (cur_rowid%FOUND) THEN
370: Close cur_rowid;
371: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_PE_FK');
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: Return;
375: END IF;
376: Close cur_rowid;
377:

Line 440: App_Exception.Raise_Exception;

436: -- Call all the procedures related to Before Insert.
437: IF Get_Pk_For_Validation(new_references.near_mtch_id) THEN
438: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
439: IGS_GE_MSG_STACK.ADD;
440: App_Exception.Raise_Exception;
441: END IF;
442: Check_Constraints;
443: Check_Parent_Existance;
444: ELSIF (p_action = 'UPDATE') THEN

Line 458: App_Exception.Raise_Exception;

454: IF Get_PK_For_Validation (
455: new_references.near_mtch_id) THEN
456: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
457: IGS_GE_MSG_STACK.ADD;
458: App_Exception.Raise_Exception;
459: END IF;
460: Check_Constraints;
461: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
462: Check_Constraints;

Line 567: app_exception.raise_exception;

563: end if;
564: else
565: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
566: IGS_GE_MSG_STACK.ADD;
567: app_exception.raise_exception;
568: end if;
569:
570: X_NEAR_MTCH_ID := -1;
571: Before_DML(

Line 695: app_exception.raise_exception;

691: if (c1%notfound) then
692: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
693: IGS_GE_MSG_STACK.ADD;
694: close c1;
695: app_exception.raise_exception;
696: return;
697: end if;
698: close c1;
699: if ( ( tlinfo.INTERFACE_ID = X_INTERFACE_ID)

Line 717: app_exception.raise_exception;

713: NULL;
714: else
715: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
716: IGS_GE_MSG_STACK.ADD;
717: app_exception.raise_exception;
718: end if;
719: return;
720:
721: end LOCK_ROW;

Line 771: app_exception.raise_exception;

767: end if;
768: else
769: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
770: IGS_GE_MSG_STACK.ADD;
771: app_exception.raise_exception;
772: end if;
773:
774: Before_DML(
775: p_action=>'UPDATE',