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_NOTES_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_Note_Type_Pkg.Get_PK_For_Validation (
122: new_references.org_note_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',
129: new_references.org_structure_type) THEN

Line 131: IGS_GE_MSG_STACK.ADD;

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

Line 138: IGS_GE_MSG_STACK.ADD;

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

Line 145: IGS_GE_MSG_STACK.ADD;

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

Line 151: IGS_GE_MSG_STACK.ADD;

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

Line 229: IGS_GE_MSG_STACK.ADD;

225: Fetch cur_rowid INTO lv_rowid;
226: IF (cur_rowid%FOUND) THEN
227: Close cur_rowid;
228: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_ONT_FK');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: Return;
232: END IF;
233: Close cur_rowid;

Line 253: IGS_GE_MSG_STACK.ADD;

249: FETCH cur_rowid INTO lv_rowid;
250: IF (cur_rowid%FOUND) THEN
251: CLOSE cur_rowid;
252: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_INS_FK');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: RETURN;
256: END IF;
257: CLOSE cur_rowid;

Line 276: IGS_GE_MSG_STACK.ADD;

272: FETCH cur_rowid INTO lv_rowid;
273: IF (cur_rowid%FOUND) THEN
274: CLOSE cur_rowid;
275: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_LOC_FK');
276: IGS_GE_MSG_STACK.ADD;
277: App_Exception.Raise_Exception;
278: RETURN;
279: END IF;
280: CLOSE cur_rowid;

Line 299: IGS_GE_MSG_STACK.ADD;

295: FETCH cur_rowid INTO lv_rowid;
296: IF (cur_rowid%FOUND) THEN
297: CLOSE cur_rowid;
298: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_OU_FK');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: RETURN;
302: END IF;
303: CLOSE cur_rowid;

Line 363: IGS_GE_MSG_STACK.ADD;

359: new_references.org_note_sequence,
360: new_references.org_note_type,
361: new_references.org_structure_id) THEN
362: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: Check_Constraints;
367: Check_Parent_Existance;

Line 384: IGS_GE_MSG_STACK.ADD;

380: new_references.org_note_sequence,
381: new_references.org_note_type,
382: new_references.org_structure_id) THEN
383: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: END IF;
387: Check_Constraints;
388: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 475: IGS_GE_MSG_STACK.ADD;

471: X_LAST_UPDATE_LOGIN := -1;
472: end if;
473: else
474: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: end if;
478: SELECT
479: IGS_OR_ORG_NOTE_SEQUENCE_S.NEXTVAL

Line 571: IGS_GE_MSG_STACK.ADD;

567: open c1;
568: fetch c1 into tlinfo;
569: if (c1%notfound) then
570: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
571: IGS_GE_MSG_STACK.ADD;
572: close c1;
573: app_exception.raise_exception;
574: return;
575: end if;

Line 588: IGS_GE_MSG_STACK.ADD;

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

Line 634: IGS_GE_MSG_STACK.ADD;

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