APPS.IGS_PS_ANL_LOAD_PKG dependencies on APP_EXCEPTION

Line 42: App_Exception.Raise_Exception;

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

Line 170: App_Exception.Raise_Exception;

166: v_version_number,
167: v_message_name) = FALSE THEN
168: Fnd_Message.Set_Name('IGS',v_message_name);
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172: -- Validate effective start date and effective end date.
173: IF p_inserting OR p_updating THEN
174: -- Because start date is part of the key it will be set and

Line 185: App_Exception.Raise_Exception;

181: new_references.effective_end_dt,
182: v_message_name) = FALSE THEN
183: Fnd_Message.Set_Name('IGS',v_message_name);
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: END IF;
188: END IF;
189:

Line 218: App_Exception.Raise_Exception;

214: NEW_REFERENCES.effective_start_dt,
215: v_message_name) = FALSE THEN
216: Fnd_Message.Set_Name('IGS',v_message_name);
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: END IF;
220: END IF;
221:
222:

Line 247: App_Exception.Raise_Exception;

243: column_name is null Then
244: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
245: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: END IF;
249: END IF;
250:
251: IF upper(column_name) = 'YR_NUM' OR

Line 256: App_Exception.Raise_Exception;

252: column_name is null Then
253: IF ( new_references.yr_num < 0 OR new_references.yr_num > 999 ) Then
254: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: END IF;
258: END IF;
259:
260: IF upper(column_name) = 'ANNUAL_LOAD_VAL' OR

Line 265: App_Exception.Raise_Exception;

261: column_name is null Then
262: IF ( new_references.annual_load_val < 0 OR new_references.annual_load_val > 9999.999 ) Then
263: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
264: IGS_GE_MSG_STACK.ADD;
265: App_Exception.Raise_Exception;
266: END IF;
267: END IF;
268: END Check_Constraints;
269:

Line 285: App_Exception.Raise_Exception;

281: new_references.version_number
282: ) THEN
283: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: END IF;
287: END IF;
288:
289: END Check_Parent_Existance;

Line 357: App_Exception.Raise_Exception;

353: IF (cur_rowid%FOUND) THEN
354: Close cur_rowid;
355: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CAL_CRV_FK');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: Return;
359: END IF;
360: Close cur_rowid;
361:

Line 403: app_exception.raise_exception;

399: IF NOT validate_overlapping(x_course_cd , x_version_number,x_yr_num ,
400: x_effective_start_dt , x_effective_end_dt,x_rowid ) THEN
401: fnd_message.set_name('IGS','IGS_PS_OVERLAP_PERIODS');
402: igs_ge_msg_stack.add;
403: app_exception.raise_exception;
404: END IF;
405: END IF;
406:
407:

Line 418: App_Exception.Raise_Exception;

414: new_references.yr_num,
415: new_references.effective_start_dt) THEN
416: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Constraints;
421: Check_Parent_Existance;
422: ELSIF (p_action = 'UPDATE') THEN

Line 439: App_Exception.Raise_Exception;

435: new_references.yr_num,
436: new_references.effective_start_dt) THEN
437: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
438: IGS_GE_MSG_STACK.ADD;
439: App_Exception.Raise_Exception;
440: END IF;
441: Check_Constraints;
442: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
443: Check_Constraints;

Line 495: app_exception.raise_exception;

491: end if;
492: else
493: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497:
498: Before_DML (
499: p_action => 'INSERT',

Line 579: app_exception.raise_exception;

575: if (c1%notfound) then
576: close c1;
577: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
578: IGS_GE_MSG_STACK.ADD;
579: app_exception.raise_exception;
580: return;
581: end if;
582: close c1;
583:

Line 593: app_exception.raise_exception;

589: null;
590: else
591: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
592: IGS_GE_MSG_STACK.ADD;
593: app_exception.raise_exception;
594: end if;
595: return;
596: end LOCK_ROW;
597:

Line 628: app_exception.raise_exception;

624: end if;
625: else
626: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
627: IGS_GE_MSG_STACK.ADD;
628: app_exception.raise_exception;
629: end if;
630:
631: Before_DML (
632: p_action => 'UPDATE',