DBA Data[Home] [Help]

APPS.IGS_ST_GVT_STDNTLOAD_PKG dependencies on APP_EXCEPTION

Line 52: App_Exception.Raise_Exception;

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

Line 122: APP_EXCEPTION.RAISE_EXCEPTION;

118: v_message_name) = FALSE THEN
119: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
120: FND_MESSAGE.SET_NAME('IGS',v_message_name);
121: IGS_GE_MSG_STACK.ADD;
122: APP_EXCEPTION.RAISE_EXCEPTION;
123: END IF;
124:
125: END BeforeRowInsertUpdateDelete1;
126:

Line 145: APP_EXCEPTION.RAISE_EXCEPTION;

141: new_references.govt_semester
142: )THEN
143: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: APP_EXCEPTION.RAISE_EXCEPTION;
146: END IF;
147: END IF;
148:
149: END Check_Parent_Existance;

Line 222: App_Exception.Raise_Exception;

218: IF (cur_rowid%FOUND) THEN
219: Close cur_rowid;
220: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSLO_GSEM_FK');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: Return;
224: END IF;
225: Close cur_rowid;
226:

Line 251: APP_EXCEPTION.RAISE_EXCEPTION;

247: IF upper(column_name) = 'INDUSTRIAL_IND' OR column_name IS NULL THEN
248: IF new_references.industrial_ind NOT IN ('Y','N') THEN
249: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: APP_EXCEPTION.RAISE_EXCEPTION;
252: END IF;
253: END IF;
254: IF upper(column_name) = 'SUBMISSION_YR' OR column_name IS NULL THEN
255: IF new_references.submission_yr < 0000 OR new_references.submission_yr > 9999 THEN

Line 258: APP_EXCEPTION.RAISE_EXCEPTION;

254: IF upper(column_name) = 'SUBMISSION_YR' OR column_name IS NULL THEN
255: IF new_references.submission_yr < 0000 OR new_references.submission_yr > 9999 THEN
256: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
257: IGS_GE_MSG_STACK.ADD;
258: APP_EXCEPTION.RAISE_EXCEPTION;
259: END IF;
260: END IF;
261: IF upper(column_name) = 'EFTSU' OR column_name IS NULL THEN
262: IF new_references.eftsu < 0000.000 OR new_references.eftsu > 9999.999 THEN

Line 265: APP_EXCEPTION.RAISE_EXCEPTION;

261: IF upper(column_name) = 'EFTSU' OR column_name IS NULL THEN
262: IF new_references.eftsu < 0000.000 OR new_references.eftsu > 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: IF upper(column_name) = 'UNIT_COMPLETION_STATUS' OR column_name IS NULL THEN
269: IF new_references.unit_completion_status NOT IN (1,2,3,4) THEN

Line 273: APP_EXCEPTION.RAISE_EXCEPTION;

269: IF new_references.unit_completion_status NOT IN (1,2,3,4) THEN
270: IGS_GE_MSG_STACK.ADD;
271: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
272: IGS_GE_MSG_STACK.ADD;
273: APP_EXCEPTION.RAISE_EXCEPTION;
274: END IF;
275: END IF;
276:
277: END CHECK_CONSTRAINTS;

Line 358: APP_EXCEPTION.RAISE_EXCEPTION;

354: new_references.govt_discipline_group_cd
355: )THEN
356: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
357: IGS_GE_MSG_STACK.ADD;
358: APP_EXCEPTION.RAISE_EXCEPTION;
359: END IF;
360: Check_Constraints;
361: Check_Parent_Existance;
362: ELSIF (p_action = 'UPDATE') THEN

Line 388: APP_EXCEPTION.RAISE_EXCEPTION;

384: new_references.govt_discipline_group_cd
385: )THEN
386: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
387: IGS_GE_MSG_STACK.ADD;
388: APP_EXCEPTION.RAISE_EXCEPTION;
389: END IF;
390: Check_Constraints;
391: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
392: -- Call all the procedures related to Before Delete.

Line 482: app_exception.raise_exception;

478: end if;
479: else
480: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
481: IGS_GE_MSG_STACK.ADD;
482: app_exception.raise_exception;
483: end if;
484:
485: Before_DML (
486: p_action =>'INSERT',

Line 629: app_exception.raise_exception;

625: fetch c1 into tlinfo;
626: if (c1%notfound) then
627: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
628: IGS_GE_MSG_STACK.ADD;
629: app_exception.raise_exception;
630: close c1;
631: return;
632: end if;
633: close c1;

Line 645: app_exception.raise_exception;

641: null;
642: else
643: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
644: IGS_GE_MSG_STACK.ADD;
645: app_exception.raise_exception;
646: end if;
647: return;
648: end LOCK_ROW;
649:

Line 697: app_exception.raise_exception;

693: end if;
694: else
695: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
696: IGS_GE_MSG_STACK.ADD;
697: app_exception.raise_exception;
698: end if;
699:
700: Before_DML (
701: p_action =>'UPDATE',