DBA Data[Home] [Help]

APPS.IGS_PR_STU_OU_HIST_PKG dependencies on APP_EXCEPTION

Line 82: App_Exception.Raise_Exception;

78: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
79: Close cur_old_ref_values;
80: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83: Return;
84: END IF;
85: Close cur_old_ref_values;
86:

Line 188: App_Exception.Raise_Exception;

184: Column_Name IS NULL THEN
185: IF new_references.COURSE_CD <> UPPER(new_references.course_cd) THEN
186: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;
191:
192: IF UPPER(Column_Name) = 'APPEAL_OUTCOME_TYPE' OR

Line 197: App_Exception.Raise_Exception;

193: Column_Name IS NULL THEN
194: IF new_references.APPEAL_OUTCOME_TYPE <> UPPER(new_references.appeal_outcome_type) THEN
195: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199: END IF;
200:
201:

Line 207: App_Exception.Raise_Exception;

203: Column_Name IS NULL THEN
204: IF new_references.DECISION_STATUS <> UPPER(new_references.decision_status) THEN
205: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: END IF;
209: END IF;
210:
211: IF UPPER(Column_Name) = 'DURATION_TYPE' OR

Line 216: App_Exception.Raise_Exception;

212: Column_Name IS NULL THEN
213: IF new_references.DURATION_TYPE <> UPPER(new_references.duration_type) THEN
214: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: END IF;
219:
220: IF UPPER(Column_Name) = 'ENCMB_COURSE_GROUP_CD' OR

Line 225: App_Exception.Raise_Exception;

221: Column_Name IS NULL THEN
222: IF new_references.ENCMB_COURSE_GROUP_CD <> UPPER(new_references.encmb_course_group_cd) THEN
223: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227: END IF;
228:
229: IF UPPER(Column_Name) = 'HIST_WHO' OR

Line 234: App_Exception.Raise_Exception;

230: Column_Name IS NULL THEN
231: IF new_references.HIST_WHO <> UPPER(new_references.hist_who) THEN
232: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: END IF;
236: END IF;
237:
238: IF UPPER(Column_Name) = 'PRG_CAL_TYPE' OR

Line 243: App_Exception.Raise_Exception;

239: Column_Name IS NULL THEN
240: IF new_references.PRG_CAL_TYPE <> UPPER(new_references.prg_cal_type) THEN
241: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
246:
247: IF UPPER(Column_Name) = 'PROGRESSION_OUTCOME_TYPE' OR

Line 252: App_Exception.Raise_Exception;

248: Column_Name IS NULL THEN
249: IF new_references.PROGRESSION_OUTCOME_TYPE <> UPPER(new_references.progression_outcome_type) THEN
250: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: END IF;
255:
256: IF UPPER(Column_Name) = 'PROGRESSION_RULE_CAT' OR

Line 261: App_Exception.Raise_Exception;

257: Column_Name IS NULL THEN
258: IF new_references.PROGRESSION_RULE_CAT <> UPPER(new_references.progression_rule_cat) THEN
259: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
264:
265: IF UPPER(Column_Name) = 'RESTRICTED_ATTENDANCE_TYPE' OR

Line 270: App_Exception.Raise_Exception;

266: Column_Name IS NULL THEN
267: IF new_references.RESTRICTED_ATTENDANCE_TYPE <> UPPER(new_references.restricted_attendance_type) THEN
268: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: END IF;
273:
274:

Line 305: App_Exception.Raise_Exception;

301: new_references.sequence_number
302: ) THEN
303: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307:
308: END Check_Parent_Existance;
309:

Line 386: App_Exception.Raise_Exception;

382: IF (cur_rowid%FOUND) THEN
383: Close cur_rowid;
384: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
385: IGS_GE_MSG_STACK.ADD;
386: App_Exception.Raise_Exception;
387: Return;
388: END IF;
389: Close cur_rowid;
390:

Line 509: App_Exception.Raise_Exception;

505: new_references.sequence_number,
506: new_references.hist_start_dt) THEN
507: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
508: IGS_GE_MSG_STACK.ADD;
509: App_Exception.Raise_Exception;
510: END IF;
511: Check_Constraints;
512: Check_Parent_Existance;
513: ELSIF (p_action = 'UPDATE') THEN

Line 530: App_Exception.Raise_Exception;

526: new_references.sequence_number,
527: new_references.hist_start_dt) THEN
528: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
529: IGS_GE_MSG_STACK.ADD;
530: App_Exception.Raise_Exception;
531: END IF;
532: Check_Constraints;
533: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
534: Check_Constraints;

Line 651: app_exception.raise_exception;

647: end if;
648: else
649: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
650: IGS_GE_MSG_STACK.ADD;
651: app_exception.raise_exception;
652: end if;
653: Before_DML(
654: p_action=>'INSERT',
655: x_rowid=>X_ROWID,

Line 890: app_exception.raise_exception;

886: if (c1%notfound) then
887: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
888: IGS_GE_MSG_STACK.ADD;
889: close c1;
890: app_exception.raise_exception;
891: return;
892: end if;
893: close c1;
894: if ( ( (tlinfo.APPEAL_COMMENTS = X_APPEAL_COMMENTS)

Line 991: app_exception.raise_exception;

987: null;
988: else
989: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
990: IGS_GE_MSG_STACK.ADD;
991: app_exception.raise_exception;
992: end if;
993: return;
994: end LOCK_ROW;
995: Procedure UPDATE_ROW (

Line 1066: app_exception.raise_exception;

1062: end if;
1063: else
1064: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1065: IGS_GE_MSG_STACK.ADD;
1066: app_exception.raise_exception;
1067: end if;
1068: Before_DML(
1069: p_action=>'UPDATE',
1070: x_rowid=>X_ROWID,