APPS.IGS_PR_SDT_PR_UNT_ST_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 82: App_Exception.Raise_Exception;

78: new_references.spo_sequence_number
79: )THEN
80: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83:
84: END IF;
85:
86: END IF;

Line 100: App_Exception.Raise_Exception;

96: new_references.version_number
97: )THEN
98: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101:
102: END IF;
103:
104: END IF;

Line 165: App_Exception.Raise_Exception;

161: IF (cur_rowid%FOUND) THEN
162: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPUS_SPO_FK');
163: IGS_GE_MSG_STACK.ADD;
164: Close cur_rowid;
165: App_Exception.Raise_Exception;
166:
167: Return;
168: END IF;
169: Close cur_rowid;

Line 194: App_Exception.Raise_Exception;

190: IF (cur_rowid%FOUND) THEN
191: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPUS_US_FK');
192: IGS_GE_MSG_STACK.ADD;
193: Close cur_rowid;
194: App_Exception.Raise_Exception;
195:
196: Return;
197: END IF;
198: Close cur_rowid;

Line 244: App_Exception.Raise_Exception;

240: new_references.unit_set_cd,
241: new_references.version_number) THEN
242: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: END IF;
246: CHECK_CONSTRAINTS;
247:
248:

Line 263: App_Exception.Raise_Exception;

259: new_references.unit_set_cd,
260: new_references.version_number) THEN
261: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: CHECK_CONSTRAINTS;
266:
267:

Line 309: app_exception.raise_exception;

305: end if;
306: else
307: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
308: IGS_GE_MSG_STACK.ADD;
309: app_exception.raise_exception;
310: end if;
311:
312: Before_DML (
313: p_action => 'INSERT',

Line 373: app_exception.raise_exception;

369: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
370: fnd_message.set_token ('ERR_CD', SQLCODE);
371: igs_ge_msg_stack.add;
372: igs_sc_gen_001.unset_ctx('R');
373: app_exception.raise_exception;
374: ELSE
375: igs_sc_gen_001.unset_ctx('R');
376: RAISE;
377: END IF;

Line 406: app_exception.raise_exception;

402: if (c1%notfound) then
403: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
404: IGS_GE_MSG_STACK.ADD;
405: close c1;
406: app_exception.raise_exception;
407:
408: return;
409: end if;
410: close c1;

Line 424: app_exception.raise_exception;

420: null;
421: else
422: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
423: IGS_GE_MSG_STACK.ADD;
424: app_exception.raise_exception;
425: end if;
426: return;
427: return;
428: end LOCK_ROW;

Line 449: app_exception.raise_exception;

445: if (sql%notfound) then
446: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
447: igs_ge_msg_stack.add;
448: igs_sc_gen_001.unset_ctx('R');
449: app_exception.raise_exception;
450: end if;
451: IF (x_mode = 'S') THEN
452: igs_sc_gen_001.unset_ctx('R');
453: END IF;

Line 477: App_Exception.Raise_Exception ;

473: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
474: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
475: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
476: IGS_GE_MSG_STACK.ADD;
477: App_Exception.Raise_Exception ;
478: END IF;
479:
480: END IF ;
481:

Line 486: App_Exception.Raise_Exception ;

482: IF upper(Column_name) = 'UNIT_SET_CD' OR COLUMN_NAME IS NULL THEN
483: IF new_references.UNIT_SET_CD<> upper(new_references.UNIT_SET_CD) then
484: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception ;
487: END IF;
488:
489: END IF ;
490: