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_OR_ORG_ALT_IDS_PKG dependencies on IGS_GE_MSG_STACK

Line 51: IGS_GE_MSG_STACK.ADD;

47: Fetch cur_old_ref_values INTO old_references;
48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: App_Exception.Raise_Exception;
53: Return;
54: END IF;
55: Close cur_old_ref_values;

Line 125: IGS_GE_MSG_STACK.ADD;

121: ELSIF NOT Igs_Or_Org_Alt_Idtyp_Pkg.Get_PK_For_Validation (
122: new_references.org_alternate_id_type
123: ) THEN
124: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',new_references.org_structure_type) THEN
129: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 130: IGS_GE_MSG_STACK.ADD;

126: App_Exception.Raise_Exception;
127: END IF;
128: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',new_references.org_structure_type) THEN
129: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
130: IGS_GE_MSG_STACK.ADD;
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END IF;
133:
134: IF new_references.org_structure_type = 'INSTITUTE' THEN

Line 137: IGS_GE_MSG_STACK.ADD;

133:
134: IF new_references.org_structure_type = 'INSTITUTE' THEN
135: IF NOT Igs_Or_Institution_Pkg.Get_Pk_For_Validation(new_references.org_structure_id) THEN
136: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
137: IGS_GE_MSG_STACK.ADD;
138: APP_EXCEPTION.RAISE_EXCEPTION;
139: END IF;
140: ELSIF new_references.org_structure_type = 'LOCATION' THEN
141: IF NOT Igs_Ad_Location_Pkg.Get_Pk_For_Validation(new_references.org_structure_id,

Line 144: IGS_GE_MSG_STACK.ADD;

140: ELSIF new_references.org_structure_type = 'LOCATION' THEN
141: IF NOT Igs_Ad_Location_Pkg.Get_Pk_For_Validation(new_references.org_structure_id,
142: 'N') THEN
143: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: APP_EXCEPTION.RAISE_EXCEPTION;
146: END IF;
147: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN
148: IF NOT Igs_Or_Unit_Pkg.Get_Pk_For_Str_Validation(new_references.org_structure_id) THEN

Line 150: IGS_GE_MSG_STACK.ADD;

146: END IF;
147: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN
148: IF NOT Igs_Or_Unit_Pkg.Get_Pk_For_Str_Validation(new_references.org_structure_id) THEN
149: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END IF;
153: END IF;
154:

Line 235: IGS_GE_MSG_STACK.ADD;

231: Fetch cur_rowid INTO lv_rowid;
232: IF (cur_rowid%FOUND) THEN
233: Close cur_rowid;
234: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_OAIT_FK');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: Return;
238: END IF;
239: Close cur_rowid;

Line 272: IGS_GE_MSG_STACK.ADD;

268: FETCH cur_rowid INTO lv_rowid;
269: IF (cur_rowid%FOUND) THEN
270: CLOSE cur_rowid;
271: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_INS_FK');
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: RETURN;
275: END IF;
276: CLOSE cur_rowid;

Line 309: IGS_GE_MSG_STACK.ADD;

305: FETCH cur_rowid INTO lv_rowid;
306: IF (cur_rowid%FOUND) THEN
307: CLOSE cur_rowid;
308: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_OU_FK');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: RETURN;
312: END IF;
313: CLOSE cur_rowid;

Line 374: IGS_GE_MSG_STACK.ADD;

370: new_references.org_structure_id,
371: new_references.org_structure_type,
372: new_references.start_date) THEN
373: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Constraints;
378: Check_Parent_Existance;

Line 396: IGS_GE_MSG_STACK.ADD;

392: new_references.org_structure_id,
393: new_references.org_structure_type,
394: new_references.start_date) THEN
395: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception;
398: END IF;
399: Check_Constraints;
400: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 492: IGS_GE_MSG_STACK.ADD;

488: X_LAST_UPDATE_LOGIN := -1;
489: end if;
490: else
491: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495: Before_DML(
496: p_action=>'INSERT',

Line 576: IGS_GE_MSG_STACK.ADD;

572: open c1;
573: fetch c1 into tlinfo;
574: if (c1%notfound) then
575: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
576: IGS_GE_MSG_STACK.ADD;
577: close c1;
578: app_exception.raise_exception;
579: return;
580: end if;

Line 589: IGS_GE_MSG_STACK.ADD;

585: ) then
586: null;
587: else
588: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
589: IGS_GE_MSG_STACK.ADD;
590: app_exception.raise_exception;
591: end if;
592: return;
593: end LOCK_ROW;

Line 637: IGS_GE_MSG_STACK.ADD;

633: X_LAST_UPDATE_LOGIN := -1;
634: end if;
635: else
636: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
637: IGS_GE_MSG_STACK.ADD;
638: app_exception.raise_exception;
639: end if;
640: Before_DML(
641: p_action=>'UPDATE',