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

Line 41: App_Exception.Raise_Exception;

37: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: Igs_Ge_Msg_Stack.Add;
40: Close cur_old_ref_values;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
44: Close cur_old_ref_values;
45:

Line 86: App_Exception.Raise_Exception;

82: IF IGS_AS_VAL_ATYP.ASSP_VAL_SAT_CLOSED(new_references.assessment_type
83: ,v_message_name) = FALSE THEN
84: Fnd_Message.Set_Name('IGS', v_message_name);
85: Igs_Ge_Msg_Stack.Add;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89: -- Validate that updates are allowed
90: IF p_updating THEN

Line 97: App_Exception.Raise_Exception;

93: new_references.assessment_type
94: ,v_message_name) = FALSE THEN
95: Fnd_Message.Set_Name('IGS', v_message_name);
96: Igs_Ge_Msg_Stack.Add;
97: App_Exception.Raise_Exception;
98: END IF;
99: END IF;
100: END IF;
101: -- Validate that updates are allowed

Line 110: App_Exception.Raise_Exception;

106: new_references.assessment_type
107: ,v_message_name) = FALSE THEN
108: Fnd_Message.Set_Name('IGS', 'IGS_AS_SYS_ASSTYPE_NOTCHG');
109: Igs_Ge_Msg_Stack.Add;
110: App_Exception.Raise_Exception;
111:
112: END IF;
113: END IF;
114: END IF;

Line 132: App_Exception.Raise_Exception;

128: new_references.s_assessment_type
129: ))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: END IF;
135:
136: END Check_Parent_Existance;

Line 159: App_Exception.Raise_Exception;

155: column_name is null Then
156: IF new_references.assessment_type <> UPPER(new_references.assessment_type) Then
157: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
158: Igs_Ge_Msg_Stack.Add;
159: App_Exception.Raise_Exception;
160: END IF;
161: END IF;
162:
163: IF upper(column_name) = 'CLOSED_IND' OR

Line 168: App_Exception.Raise_Exception;

164: column_name is null Then
165: IF new_references.closed_ind <> UPPER(new_references.closed_ind) OR new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
166: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
167: Igs_Ge_Msg_Stack.Add;
168: App_Exception.Raise_Exception;
169: END IF;
170: END IF;
171: IF upper(column_name) = 'EXAMINABLE_IND' OR
172: column_name is null Then

Line 176: App_Exception.Raise_Exception;

172: column_name is null Then
173: IF new_references.examinable_ind <> UPPER(new_references.examinable_ind) OR new_references.examinable_ind NOT IN ( 'Y' , 'N' ) Then
174: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
175: Igs_Ge_Msg_Stack.Add;
176: App_Exception.Raise_Exception;
177: END IF;
178: END IF;
179: IF upper(column_name) = 'S_ASSESSMENT_TYPE' OR
180: column_name is null Then

Line 184: App_Exception.Raise_Exception;

180: column_name is null Then
181: IF new_references.s_assessment_type <> UPPER(new_references.s_assessment_type) Then
182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
183: Igs_Ge_Msg_Stack.Add;
184: App_Exception.Raise_Exception;
185: END IF;
186: END IF;
187:
188: IF upper(column_name) = 'ANON_GRADING_IND' OR

Line 193: App_Exception.Raise_Exception;

189: column_name is null Then
190: IF new_references.anon_grading_ind <> UPPER(new_references.anon_grading_ind) OR new_references.anon_grading_ind NOT IN ( 'Y' , 'N' ) Then
191: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
192: Igs_Ge_Msg_Stack.Add;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;
196:
197: END Check_Constraints;

Line 254: App_Exception.Raise_Exception;

250: IF (cur_rowid%FOUND) THEN
251: Fnd_Message.Set_Name ('IGS', 'IGS_AS_ATYP_SAT_FK');
252: Igs_Ge_Msg_Stack.Add;
253: Close cur_rowid;
254: App_Exception.Raise_Exception;
255: Return;
256: END IF;
257: Close cur_rowid;
258:

Line 302: App_Exception.Raise_Exception;

298: new_references.assessment_type
299: ) THEN
300: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
301: Igs_Ge_Msg_Stack.Add;
302: App_Exception.Raise_Exception;
303: END IF;
304:
305: Check_Constraints;
306: Check_Parent_Existance;

Line 322: App_Exception.Raise_Exception;

318: new_references.assessment_type
319: ) THEN
320: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
321: Igs_Ge_Msg_Stack.Add;
322: App_Exception.Raise_Exception;
323: END IF;
324: Check_Constraints;
325: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
326: Check_Constraints;

Line 372: app_exception.raise_exception;

368: end if;
369: else
370: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
371: Igs_Ge_Msg_Stack.Add;
372: app_exception.raise_exception;
373: end if;
374: Before_DML(
375: p_action=>'INSERT',
376: x_rowid=>X_ROWID,

Line 451: app_exception.raise_exception;

447: if (c1%notfound) then
448: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
449: Igs_Ge_Msg_Stack.Add;
450: close c1;
451: app_exception.raise_exception;
452: return;
453: end if;
454: close c1;
455:

Line 466: app_exception.raise_exception;

462: null;
463: else
464: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
465: Igs_Ge_Msg_Stack.Add;
466: app_exception.raise_exception;
467: end if;
468: return;
469: end LOCK_ROW;
470:

Line 501: app_exception.raise_exception;

497: end if;
498: else
499: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
500: Igs_Ge_Msg_Stack.Add;
501: app_exception.raise_exception;
502: end if;
503: Before_DML(
504: p_action=>'UPDATE',
505: x_rowid=>X_ROWID,