APPS.IGS_AS_SASSESS_TYPE_PKG dependencies on APP_EXCEPTION

Line 34: App_Exception.Raise_Exception;

30: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
31: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
32: Igs_Ge_Msg_Stack.Add;
33: Close cur_old_ref_values;
34: App_Exception.Raise_Exception;
35: Return;
36: END IF;
37: Close cur_old_ref_values;
38: -- Populate New Values.

Line 67: App_Exception.Raise_Exception;

63: 'N'
64: ))THEN
65: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
66: Igs_Ge_Msg_Stack.Add;
67: App_Exception.Raise_Exception;
68: END IF;
69: END IF;
70: END Check_Parent_Existance;
71:

Line 92: App_Exception.Raise_Exception;

88: column_name is null Then
89: IF new_references.closed_ind <> UPPER(new_references.closed_ind) or new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
90: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
91: Igs_Ge_Msg_Stack.Add;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95:
96: IF upper(column_name) = 'DESCRIPTION' OR

Line 101: App_Exception.Raise_Exception;

97: column_name is null Then
98: IF new_references.description <> UPPER(new_references.description) Then
99: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
100: Igs_Ge_Msg_Stack.Add;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104: IF upper(column_name) = 'S_ASSESSMENT_TYPE' OR
105: column_name is null Then

Line 109: App_Exception.Raise_Exception;

105: column_name is null Then
106: IF new_references.s_assessment_type <> UPPER(new_references.s_assessment_type) Then
107: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
108: Igs_Ge_Msg_Stack.Add;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112:
113: END Check_Constraints;

Line 157: App_Exception.Raise_Exception;

153: IF (cur_rowid%FOUND) THEN
154: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SAT_LOC_FK');
155: Igs_Ge_Msg_Stack.Add;
156: Close cur_rowid;
157: App_Exception.Raise_Exception;
158: Return;
159: END IF;
160: Close cur_rowid;
161: END GET_FK_IGS_AD_LOCATION;

Line 197: App_Exception.Raise_Exception;

193: new_references.s_assessment_type
194: ) THEN
195: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
196: Igs_Ge_Msg_Stack.Add;
197: App_Exception.Raise_Exception;
198: END IF;
199:
200: Check_Constraints;
201: Check_Parent_Existance;

Line 217: App_Exception.Raise_Exception;

213: new_references.s_assessment_type
214: ) THEN
215: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
216: Igs_Ge_Msg_Stack.Add;
217: App_Exception.Raise_Exception;
218: END IF;
219: Check_Constraints;
220: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
221: Check_Constraints;

Line 256: app_exception.raise_exception;

252: end if;
253: else
254: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
255: Igs_Ge_Msg_Stack.Add;
256: app_exception.raise_exception;
257: end if;
258: Before_DML(
259: p_action=>'INSERT',
260: x_rowid=>X_ROWID,

Line 321: app_exception.raise_exception;

317: if (c1%notfound) then
318: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
319: Igs_Ge_Msg_Stack.Add;
320: close c1;
321: app_exception.raise_exception;
322: return;
323: end if;
324: close c1;
325: if ( (tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 337: app_exception.raise_exception;

333: null;
334: else
335: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
336: Igs_Ge_Msg_Stack.Add;
337: app_exception.raise_exception;
338: end if;
339: return;
340: end LOCK_ROW;
341: procedure UPDATE_ROW (

Line 369: app_exception.raise_exception;

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