DBA Data[Home] [Help]

APPS.IGS_AD_ACAD_INTEREST_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

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

Line 116: app_exception.raise_exception;

112: ,new_references.person_id
113: ) THEN
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
115: IGS_GE_MSG_STACK.ADD;
116: app_exception.raise_exception;
117: END IF;
118: END Check_Uniqueness ;
119: PROCEDURE Check_Parent_Existance AS
120: /*************************************************************

Line 142: App_Exception.Raise_Exception;

138: ) THEN
139: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIELD_OF_STUDY'));
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144:
145: IF (((old_references.person_id = new_references.person_id) AND
146: (old_references.admission_appl_number = new_references.admission_appl_number)) OR

Line 157: App_Exception.Raise_Exception;

153: ) THEN
154: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
155: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159:
160: END Check_Parent_Existance;
161:

Line 267: App_Exception.Raise_Exception;

263: IF (cur_rowid%FOUND) THEN
264: Close cur_rowid;
265: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAINT_FOS_FK');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: Return;
269: END IF;
270: Close cur_rowid;
271:

Line 307: App_Exception.Raise_Exception;

303: IF (cur_rowid%FOUND) THEN
304: Close cur_rowid;
305: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAIT_ACAI_FK');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: Return;
309: END IF;
310: Close cur_rowid;
311:

Line 369: App_Exception.Raise_Exception;

365: IF Get_Pk_For_Validation(
366: new_references.acad_interest_id) THEN
367: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
368: IGS_GE_MSG_STACK.ADD;
369: App_Exception.Raise_Exception;
370: END IF;
371: Check_Uniqueness;
372: Check_Constraints;
373: Check_Parent_Existance;

Line 389: App_Exception.Raise_Exception;

385: IF Get_PK_For_Validation (
386: new_references.acad_interest_id) THEN
387: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
388: IGS_GE_MSG_STACK.ADD;
389: App_Exception.Raise_Exception;
390: END IF;
391: Check_Uniqueness;
392: Check_Constraints;
393: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 493: app_exception.raise_exception;

489: end if;
490: else
491: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495:
496: X_ACAD_INTEREST_ID := -1;
497: Before_DML(

Line 569: app_exception.raise_exception;

565: -- that the ownerof policy function does not have privilege to access.
566: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
567: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
568: IGS_GE_MSG_STACK.ADD;
569: app_exception.raise_exception;
570: ELSE
571: RAISE;
572: END IF;
573:

Line 607: app_exception.raise_exception;

603: if (c1%notfound) then
604: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
605: IGS_GE_MSG_STACK.ADD;
606: close c1;
607: app_exception.raise_exception;
608: return;
609: end if;
610: close c1;
611: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 619: app_exception.raise_exception;

615: null;
616: else
617: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
618: IGS_GE_MSG_STACK.ADD;
619: app_exception.raise_exception;
620: end if;
621: return;
622: end LOCK_ROW;
623: Procedure UPDATE_ROW (

Line 667: app_exception.raise_exception;

663: end if;
664: else
665: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
666: IGS_GE_MSG_STACK.ADD;
667: app_exception.raise_exception;
668: end if;
669: Before_DML(
670: p_action=>'UPDATE',
671: x_rowid=>X_ROWID,

Line 717: app_exception.raise_exception;

713: igs_ge_msg_stack.add;
714: IF (x_mode = 'S') THEN
715: igs_sc_gen_001.set_ctx('R');
716: END IF;
717: app_exception.raise_exception;
718: END IF;
719: IF (x_mode = 'S') THEN
720: igs_sc_gen_001.unset_ctx('R');
721: END IF;

Line 742: app_exception.raise_exception;

738: -- that the ownerof policy function does not have privilege to access.
739: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
740: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
741: IGS_GE_MSG_STACK.ADD;
742: app_exception.raise_exception;
743: ELSE
744: RAISE;
745: END IF;
746: END UPDATE_ROW;

Line 824: app_exception.raise_exception;

820: igs_ge_msg_stack.add;
821: IF (x_mode = 'S') THEN
822: igs_sc_gen_001.set_ctx('R');
823: END IF;
824: app_exception.raise_exception;
825: END IF;
826: IF (x_mode = 'S') THEN
827: igs_sc_gen_001.unset_ctx('R');
828: END IF;

Line 848: app_exception.raise_exception;

844: -- that the ownerof policy function does not have privilege to access.
845: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
846: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
847: IGS_GE_MSG_STACK.ADD;
848: app_exception.raise_exception;
849: ELSE
850: RAISE;
851: END IF;
852: end DELETE_ROW;