DBA Data[Home] [Help]

APPS.IGS_PS_AWARD_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: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:

Line 92: App_Exception.Raise_Exception;

88: v_version_number,
89: v_message_name) = FALSE THEN
90: Fnd_Message.Set_Name('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: -- Validate the insert.
95: IF p_inserting THEN
96: IF IGS_PS_VAL_CAW.crsp_val_caw_insert (

Line 102: App_Exception.Raise_Exception;

98: new_references.version_number,
99: v_message_name) = FALSE THEN
100: Fnd_Message.Set_Name('IGS',v_message_name);
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception;
103: END IF;
104: -- Validate IGS_PS_AWD code. IGS_PS_AWD code is not updateable.
105: IF IGS_PS_VAL_CAW.crsp_val_caw_award (
106: new_references.award_cd,

Line 110: App_Exception.Raise_Exception;

106: new_references.award_cd,
107: v_message_name) = FALSE THEN
108: Fnd_Message.Set_Name('IGS',v_message_name);
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113:
114: END BeforeRowInsertUpdate;

Line 138: App_Exception.Raise_Exception;

134: column_name is null Then
135: IF ( new_references.award_cd <> UPPER(new_references.award_cd) ) Then
136: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
141:
142:

Line 148: App_Exception.Raise_Exception;

144: column_name is null Then
145: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
146: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151:
152: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then

Line 156: app_exception.raise_exception;

152: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
153: IF new_references.closed_ind NOT IN ('Y', 'N') Then
154: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: END IF;
158: END IF;
159:
160: END Check_Constraints;

Line 174: App_Exception.Raise_Exception;

170: new_references.award_cd
171: ) THEN
172: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
177:
178: IF (((old_references.course_cd = new_references.course_cd) AND

Line 190: App_Exception.Raise_Exception;

186: new_references.version_number
187: ) THEN
188: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
189: IGS_GE_MSG_STACK.ADD;
190: App_Exception.Raise_Exception;
191: END IF;
192: END IF;
193:
194: END Check_Parent_Existance;

Line 248: App_Exception.Raise_Exception;

244: IF (cur_rowid%FOUND) THEN
245: Close cur_rowid;
246: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CAW_CRV_FK');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: Return;
250: END IF;
251: Close cur_rowid;
252:

Line 295: App_Exception.Raise_Exception;

291: new_references.version_number,
292: new_references.award_cd ) THEN
293: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297: Check_Constraints;
298: Check_Parent_Existance;
299: ELSIF (p_action = 'UPDATE') THEN

Line 311: App_Exception.Raise_Exception;

307: new_references.version_number,
308: new_references.award_cd ) THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: Check_Constraints;
314: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
315: Check_Constraints;

Line 361: app_exception.raise_exception;

357: end if;
358: else
359: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
360: IGS_GE_MSG_STACK.ADD;
361: app_exception.raise_exception;
362: end if;
363:
364: Before_DML (
365: p_action => 'INSERT',

Line 441: app_exception.raise_exception;

437: if (c1%notfound) then
438: close c1;
439: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
440: IGS_GE_MSG_STACK.ADD;
441: app_exception.raise_exception;
442: return;
443: end if;
444: close c1;
445:

Line 454: app_exception.raise_exception;

450: null;
451: else
452: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
453: IGS_GE_MSG_STACK.ADD;
454: app_exception.raise_exception;
455: end if;
456: return;
457: end LOCK_ROW;
458:

Line 488: app_exception.raise_exception;

484: end if;
485: else
486: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
487: IGS_GE_MSG_STACK.ADD;
488: app_exception.raise_exception;
489: end if;
490:
491: Before_DML (
492: p_action => 'UPDATE',