APPS.IGS_PE_ACAD_HONORS_PKG dependencies on APP_EXCEPTION

Line 52: App_Exception.Raise_Exception;

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

Line 154: app_exception.raise_exception;

150: new_references.person_id
151: ) THEN
152: Fnd_Message.Set_Name ('IGS', 'IGS_PE_ACAD_HNRS_DUP_EXISTS');
153: IGS_GE_MSG_STACK.ADD;
154: app_exception.raise_exception;
155: END IF;
156: END Check_Uniqueness ;
157:
158: PROCEDURE Check_Parent_Existance AS

Line 182: App_Exception.Raise_Exception;

178: 'PE_ACAD_HONORS', new_references.acad_honor_type
179: ) THEN
180: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184:
185:
186:

Line 274: App_Exception.Raise_Exception;

270: IF Get_Pk_For_Validation(
271: new_references.acad_honor_id) THEN
272: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: Check_Uniqueness;
277: Check_Constraints;
278: Check_Parent_Existance;

Line 293: App_Exception.Raise_Exception;

289: IF Get_PK_For_Validation (
290: new_references.acad_honor_id) THEN
291: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: END IF;
295: Check_Uniqueness;
296: Check_Constraints;
297: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 398: app_exception.raise_exception;

394: end if;
395: else
396: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
397: IGS_GE_MSG_STACK.ADD;
398: app_exception.raise_exception;
399: end if;
400:
401:
402:

Line 479: app_exception.raise_exception;

475: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
476: fnd_message.set_token ('ERR_CD', SQLCODE);
477: igs_ge_msg_stack.add;
478: igs_sc_gen_001.unset_ctx('R');
479: app_exception.raise_exception;
480: ELSE
481: igs_sc_gen_001.unset_ctx('R');
482: RAISE;
483: END IF;

Line 522: app_exception.raise_exception;

518: if (c1%notfound) then
519: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
520: IGS_GE_MSG_STACK.ADD;
521: close c1;
522: app_exception.raise_exception;
523: return;
524: end if;
525: close c1;
526: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 539: app_exception.raise_exception;

535: null;
536: else
537: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
538: IGS_GE_MSG_STACK.ADD;
539: app_exception.raise_exception;
540: end if;
541: return;
542: end LOCK_ROW;
543: Procedure UPDATE_ROW (

Line 587: app_exception.raise_exception;

583: end if;
584: else
585: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
586: IGS_GE_MSG_STACK.ADD;
587: app_exception.raise_exception;
588: end if;
589: Before_DML(
590: p_action=>'UPDATE',
591: x_rowid=>X_ROWID,

Line 637: app_exception.raise_exception;

633: if (sql%notfound) then
634: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
635: igs_ge_msg_stack.add;
636: igs_sc_gen_001.unset_ctx('R');
637: app_exception.raise_exception;
638: end if;
639: IF (x_mode = 'S') THEN
640: igs_sc_gen_001.unset_ctx('R');
641: END IF;

Line 655: app_exception.raise_exception;

651: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
652: fnd_message.set_token ('ERR_CD', SQLCODE);
653: igs_ge_msg_stack.add;
654: igs_sc_gen_001.unset_ctx('R');
655: app_exception.raise_exception;
656: ELSE
657: igs_sc_gen_001.unset_ctx('R');
658: RAISE;
659: END IF;

Line 739: app_exception.raise_exception;

735: if (sql%notfound) then
736: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
737: igs_ge_msg_stack.add;
738: igs_sc_gen_001.unset_ctx('R');
739: app_exception.raise_exception;
740: end if;
741: IF (x_mode = 'S') THEN
742: igs_sc_gen_001.unset_ctx('R');
743: END IF;