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 APP_EXCEPTION

Line 52: App_Exception.Raise_Exception;

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;
56:

Line 126: App_Exception.Raise_Exception;

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
130: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 132: APP_EXCEPTION.RAISE_EXCEPTION;

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
136: IF NOT Igs_Or_Institution_Pkg.Get_Pk_For_Validation(new_references.org_structure_id) THEN

Line 139: APP_EXCEPTION.RAISE_EXCEPTION;

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,
143: 'N') THEN

Line 146: APP_EXCEPTION.RAISE_EXCEPTION;

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
150: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 152: APP_EXCEPTION.RAISE_EXCEPTION;

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:
156: END Check_Parent_Existance;

Line 230: App_Exception.Raise_Exception;

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;
234:

Line 254: App_Exception.Raise_Exception;

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;
258: END GET_FK_IGS_OR_INSTITUTION;

Line 277: App_Exception.Raise_Exception;

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;
281: END GET_FK_IGS_AD_LOCATION;

Line 300: App_Exception.Raise_Exception;

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;
304: END GET_FK_IGS_OR_UNIT;

Line 364: App_Exception.Raise_Exception;

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;
368: ELSIF (p_action = 'UPDATE') THEN

Line 385: App_Exception.Raise_Exception;

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
389: Check_Constraints;

Line 476: app_exception.raise_exception;

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
480: INTO

Line 573: app_exception.raise_exception;

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;
576: close c1;
577: if ( ( tlinfo.START_DATE = X_START_DATE)

Line 589: app_exception.raise_exception;

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;
593: Procedure UPDATE_ROW (

Line 635: app_exception.raise_exception;

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',
639: x_rowid=>X_ROWID,