DBA Data[Home] [Help]

APPS.IGS_PS_STDNT_TRN_PKG dependencies on APP_EXCEPTION

Line 54: App_Exception.Raise_Exception;

50: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
51: CLOSE cur_old_ref_values;
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
58:

Line 107: App_Exception.Raise_Exception;

103: v_message_name) = FALSE THEN
104:
105: Fnd_Message.Set_Name('IGS', v_message_name);
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110: END BeforeRowInsertUpdateDelete1;
111:

Line 133: App_Exception.Raise_Exception;

129: column_name IS NULL THEN
130: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
131: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137: IF UPPER(column_name) = 'TRANSFER_COURSE_CD' OR

Line 142: App_Exception.Raise_Exception;

138: column_name IS NULL THEN
139: IF new_references.transfer_course_cd <> UPPER(new_references.transfer_course_cd) THEN
140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144: END IF;
145: END check_constraints;
146:

Line 163: App_Exception.Raise_Exception;

159: ) THEN
160: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
161: IGS_GE_MSG_STACK.ADD;
162: --Uncommented This
163: App_Exception.Raise_Exception;
164:
165: END IF;
166:
167: END IF;

Line 181: App_Exception.Raise_Exception;

177: new_references.transfer_course_cd
178: ) THEN
179: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184:
185: IF (((old_references.effective_term_cal_type = new_references.effective_term_cal_type) AND

Line 197: App_Exception.Raise_Exception;

193: new_references.effective_term_sequence_num) THEN
194:
195: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198:
199: END IF;
200:
201: END IF;

Line 270: App_Exception.Raise_Exception;

266: IF (cur_rowid%FOUND) THEN
267: CLOSE cur_rowid;
268: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SCT_SCA_FK');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: RETURN;
272: END IF;
273: CLOSE cur_rowid;
274:

Line 337: App_Exception.Raise_Exception;

333: new_references.transfer_dt
334: ) THEN
335: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;
339: Check_Constraints;
340: Check_Parent_Existance;
341: ELSIF (p_action = 'UPDATE') THEN

Line 359: App_Exception.Raise_Exception;

355: new_references.transfer_dt
356: ) THEN
357: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
358: IGS_GE_MSG_STACK.ADD;
359: App_Exception.Raise_Exception;
360: END IF;
361: Check_Constraints;
362: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
363: Check_Constraints;

Line 476: app_exception.raise_exception;

472: END IF;
473: ELSE
474: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: END IF;
478: Before_DML( p_action => 'INSERT',
479: x_rowid => X_ROWID,
480: x_person_id => X_PERSON_ID,

Line 588: app_exception.raise_exception;

584: IF (c1%NOTFOUND) THEN
585: CLOSE c1;
586: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
587: IGS_GE_MSG_STACK.ADD;
588: app_exception.raise_exception;
589: RETURN;
590: END IF;
591: CLOSE c1;
592:

Line 639: app_exception.raise_exception;

635: NULL;
636: ELSE
637: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
638: IGS_GE_MSG_STACK.ADD;
639: app_exception.raise_exception;
640: END IF;
641: RETURN;
642: END LOCK_ROW;
643:

Line 683: app_exception.raise_exception;

679: END IF;
680: ELSE
681: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
682: IGS_GE_MSG_STACK.ADD;
683: app_exception.raise_exception;
684: END IF;
685: Before_DML( p_action => 'UPDATE',
686: x_rowid => X_ROWID,
687: x_person_id => X_PERSON_ID,