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_ACCR_DTLS_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

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

Line 125: App_Exception.Raise_Exception;

121: new_references.org_accr_status
122: ) THEN
123: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127:
128: IF (((old_references.org_agency_id = new_references.org_agency_id)) OR
129: ((new_references.org_agency_id IS NULL))) THEN

Line 136: App_Exception.Raise_Exception;

132: new_references.org_agency_id
133: ) THEN
134: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',
139: new_references.org_structure_type) THEN
140: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 142: APP_EXCEPTION.RAISE_EXCEPTION;

138: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',
139: new_references.org_structure_type) THEN
140: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
141: IGS_GE_MSG_STACK.ADD;
142: APP_EXCEPTION.RAISE_EXCEPTION;
143:
144: END IF;
145: IF new_references.org_structure_type = 'INSTITUTE' THEN
146: IF NOT Igs_Or_Institution_Pkg.Get_Pk_For_Validation(new_references.org_structure_id) THEN

Line 149: APP_EXCEPTION.RAISE_EXCEPTION;

145: IF new_references.org_structure_type = 'INSTITUTE' THEN
146: IF NOT Igs_Or_Institution_Pkg.Get_Pk_For_Validation(new_references.org_structure_id) THEN
147: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: APP_EXCEPTION.RAISE_EXCEPTION;
150: END IF;
151: ELSIF new_references.org_structure_type = 'LOCATION' THEN
152: IF NOT Igs_Ad_Location_Pkg.Get_Pk_For_Validation(new_references.org_structure_id,
153: 'N') THEN

Line 156: APP_EXCEPTION.RAISE_EXCEPTION;

152: IF NOT Igs_Ad_Location_Pkg.Get_Pk_For_Validation(new_references.org_structure_id,
153: 'N') THEN
154: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
155: IGS_GE_MSG_STACK.ADD;
156: APP_EXCEPTION.RAISE_EXCEPTION;
157: END IF;
158: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN
159: IF NOT Igs_Or_Unit_Pkg.Get_Pk_For_Str_Validation(new_references.org_structure_id) THEN
160: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 162: APP_EXCEPTION.RAISE_EXCEPTION;

158: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN
159: IF NOT Igs_Or_Unit_Pkg.Get_Pk_For_Str_Validation(new_references.org_structure_id) THEN
160: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
161: IGS_GE_MSG_STACK.ADD;
162: APP_EXCEPTION.RAISE_EXCEPTION;
163: END IF;
164: END IF;
165:
166:

Line 243: App_Exception.Raise_Exception;

239: IF (cur_rowid%FOUND) THEN
240: Close cur_rowid;
241: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_OAS_FK');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: Return;
245: END IF;
246: Close cur_rowid;
247:

Line 280: App_Exception.Raise_Exception;

276: IF (cur_rowid%FOUND) THEN
277: Close cur_rowid;
278: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_OI_FK');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: Return;
282: END IF;
283: Close cur_rowid;
284:

Line 303: App_Exception.Raise_Exception;

299: IF (cur_rowid%FOUND) THEN
300: CLOSE cur_rowid;
301: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_LOC_FK');
302: IGS_GE_MSG_STACK.ADD;
303: App_Exception.Raise_Exception;
304: RETURN;
305: END IF;
306: CLOSE cur_rowid;
307: END Get_Fk_Igs_Or_Unit;

Line 365: App_Exception.Raise_Exception;

361: new_references.org_structure_type,
362: new_references.start_date) THEN
363: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
364: IGS_GE_MSG_STACK.ADD;
365: App_Exception.Raise_Exception;
366: END IF;
367: Check_Constraints;
368: Check_Parent_Existance;
369: ELSIF (p_action = 'UPDATE') THEN

Line 387: App_Exception.Raise_Exception;

383: new_references.org_structure_type,
384: new_references.start_date) THEN
385: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388: END IF;
389: Check_Constraints;
390: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
391: Check_Constraints;

Line 478: app_exception.raise_exception;

474: end if;
475: else
476: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: end if;
480: Before_DML(
481: p_action=>'INSERT',
482: x_rowid=>X_ROWID,

Line 563: app_exception.raise_exception;

559: if (c1%notfound) then
560: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
561: IGS_GE_MSG_STACK.ADD;
562: close c1;
563: app_exception.raise_exception;
564: return;
565: end if;
566: close c1;
567: if ( ( (tlinfo.END_DATE = X_END_DATE)

Line 575: app_exception.raise_exception;

571: null;
572: else
573: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
574: IGS_GE_MSG_STACK.ADD;
575: app_exception.raise_exception;
576: end if;
577: return;
578: end LOCK_ROW;
579: Procedure UPDATE_ROW (

Line 620: app_exception.raise_exception;

616: end if;
617: else
618: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
619: IGS_GE_MSG_STACK.ADD;
620: app_exception.raise_exception;
621: end if;
622: Before_DML(
623: p_action=>'UPDATE',
624: x_rowid=>X_ROWID,