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 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_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');
130: IGS_GE_MSG_STACK.ADD;

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

Line 138: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 145: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 151: APP_EXCEPTION.RAISE_EXCEPTION;

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:
155:

Line 236: App_Exception.Raise_Exception;

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

Line 273: App_Exception.Raise_Exception;

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;
277: END Get_Fk_Igs_Or_Institution;

Line 310: App_Exception.Raise_Exception;

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;
314: END Get_Fk_Igs_Or_Unit;

Line 375: App_Exception.Raise_Exception;

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

Line 397: App_Exception.Raise_Exception;

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

Line 493: app_exception.raise_exception;

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

Line 578: app_exception.raise_exception;

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;
581: close c1;
582: if ( ( (tlinfo.END_DATE = X_END_DATE)

Line 590: app_exception.raise_exception;

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

Line 638: app_exception.raise_exception;

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