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 IGS_GE_MSG_STACK

Line 55: IGS_GE_MSG_STACK.ADD;

51: Fetch cur_old_ref_values INTO old_references;
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;

Line 117: IGS_GE_MSG_STACK.ADD;

113: IF Upper(Column_Name) = 'ACTION' OR
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:

Line 146: IGS_GE_MSG_STACK.ADD;

142: ELSIF NOT Igs_Ad_Interface_Pkg.Get_PK_For_Validation (
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

Line 157: IGS_GE_MSG_STACK.ADD;

153: ELSIF NOT Igs_Pe_Person_Id_Typ_Pkg.Get_PK_For_Validation (
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

Line 168: IGS_GE_MSG_STACK.ADD;

164: ELSIF NOT Igs_Co_Addr_Type_Pkg.Get_PK_For_Validation (
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

Line 179: IGS_GE_MSG_STACK.ADD;

175: ELSIF NOT Igs_Pe_Match_Sets_Pkg.Get_PK_For_Validation (
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

Line 190: IGS_GE_MSG_STACK.ADD;

186: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
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;

Line 261: IGS_GE_MSG_STACK.ADD;

257: Fetch cur_rowid INTO lv_rowid;
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;

Line 298: IGS_GE_MSG_STACK.ADD;

294: Fetch cur_rowid INTO lv_rowid;
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;

Line 335: IGS_GE_MSG_STACK.ADD;

331: Fetch cur_rowid INTO lv_rowid;
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;

Line 372: IGS_GE_MSG_STACK.ADD;

368: Fetch cur_rowid INTO lv_rowid;
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;

Line 439: IGS_GE_MSG_STACK.ADD;

435: IF (p_action = 'INSERT') THEN
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;

Line 457: IGS_GE_MSG_STACK.ADD;

453: -- Call all the procedures related to Before Insert.
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

Line 566: IGS_GE_MSG_STACK.ADD;

562: X_PROGRAM_UPDATE_DATE := SYSDATE;
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;

Line 693: IGS_GE_MSG_STACK.ADD;

689: open c1;
690: fetch c1 into tlinfo;
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;

Line 716: IGS_GE_MSG_STACK.ADD;

712: ) then
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:

Line 770: IGS_GE_MSG_STACK.ADD;

766: X_LAST_UPDATE_LOGIN := -1;
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(