APPS.IGS_AD_CAT_PS_TYPE_PKG dependencies on APP_EXCEPTION

Line 36: App_Exception.Raise_Exception;

32: Fetch cur_old_ref_values INTO old_references;
33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: Close cur_old_ref_values;
38: Return;
39: END IF;
40: Close cur_old_ref_values;

Line 71: App_Exception.Raise_Exception;

67: new_references.admission_cat,
68: v_message_name) = FALSE THEN
69: Fnd_Message.Set_Name('IGS',v_message_name);
70: IGS_GE_MSG_STACK.ADD;
71: App_Exception.Raise_Exception;
72: END IF;
73: -- Validate the course type closed indicator.
74: IF IGS_AS_VAL_ACOT.crsp_val_cty_closed (
75: new_references.course_type,

Line 79: App_Exception.Raise_Exception;

75: new_references.course_type,
76: v_message_name) = FALSE THEN
77: Fnd_Message.Set_Name('IGS',v_message_name);
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END BeforeRowInsert1;
82:
83: PROCEDURE Check_Constraints (

Line 99: App_Exception.Raise_Exception;

95: IF upper(column_name) = 'ADMISSION_CAT' OR column_name is null Then
96: IF new_references.admission_cat <> UPPER(new_references.admission_cat) Then
97: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
102: IF upper(column_name) = 'COURSE_TYPE' OR column_name is null Then
103: IF new_references.course_type <> UPPER(new_references.course_type ) Then

Line 106: App_Exception.Raise_Exception;

102: IF upper(column_name) = 'COURSE_TYPE' OR column_name is null Then
103: IF new_references.course_type <> UPPER(new_references.course_type ) Then
104: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109: END Check_Constraints;
110:

Line 123: App_Exception.Raise_Exception;

119: IF NOT IGS_AD_CAT_PKG.Get_PK_For_Validation (
120: new_references.admission_cat , 'N' ) THEN
121: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125: END IF;
126:
127: IF (((old_references.course_type = new_references.course_type)) OR

Line 135: App_Exception.Raise_Exception;

131: IF NOT IGS_PS_TYPE_PKG.Get_PK_For_Validation (
132: new_references.course_type ) THEN
133: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138:
139: END Check_Parent_Existance;

Line 183: App_Exception.Raise_Exception;

179: IF (cur_rowid%FOUND) THEN
180: Close cur_rowid;
181: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACCT_AC_FK');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: Return;
185: END IF;
186: Close cur_rowid;
187:

Line 222: App_Exception.Raise_Exception;

218: new_references.admission_cat,
219: new_references.course_type ) THEN
220: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: Check_Constraints;
225: Check_Parent_Existance;
226: ELSIF (p_action = 'UPDATE') THEN

Line 236: App_Exception.Raise_Exception;

232: new_references.admission_cat,
233: new_references.course_type ) THEN
234: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: Check_Constraints;
239: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
240: Check_Constraints;

Line 283: app_exception.raise_exception;

279: end if;
280: else
281: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
282: IGS_GE_MSG_STACK.ADD;
283: app_exception.raise_exception;
284: end if;
285:
286: Before_DML(
287: p_action=>'INSERT',

Line 346: app_exception.raise_exception;

342: fetch c1 into tlinfo;
343: if (c1%notfound) then
344: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: close c1;
348: return;
349: end if;
350: close c1;