APPS.IGS_PS_AWARD_PKG dependencies on IGS_GE_MSG_STACK

Line 39: IGS_GE_MSG_STACK.ADD;

35: Fetch cur_old_ref_values INTO old_references;
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;

Line 91: IGS_GE_MSG_STACK.ADD;

87: v_course_cd,
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

Line 101: IGS_GE_MSG_STACK.ADD;

97: new_references.course_cd,
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 (

Line 109: IGS_GE_MSG_STACK.ADD;

105: IF IGS_PS_VAL_CAW.crsp_val_caw_award (
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:

Line 137: IGS_GE_MSG_STACK.ADD;

133: IF upper(column_name) = 'AWARD_CD' OR
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:

Line 147: IGS_GE_MSG_STACK.ADD;

143: IF upper(column_name) = 'COURSE_CD' OR
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:

Line 155: igs_ge_msg_stack.add;

151:
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:

Line 173: IGS_GE_MSG_STACK.ADD;

169: IF NOT IGS_PS_AWD_PKG.Get_PK_For_Validation (
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:

Line 189: IGS_GE_MSG_STACK.ADD;

185: new_references.course_cd,
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:

Line 247: IGS_GE_MSG_STACK.ADD;

243: Fetch cur_rowid INTO lv_rowid;
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;

Line 294: IGS_GE_MSG_STACK.ADD;

290: new_references.course_cd ,
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;

Line 310: IGS_GE_MSG_STACK.ADD;

306: new_references.course_cd ,
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

Line 360: IGS_GE_MSG_STACK.ADD;

356: X_LAST_UPDATE_LOGIN := -1;
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 (

Line 440: IGS_GE_MSG_STACK.ADD;

436: fetch c1 into tlinfo;
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;

Line 453: IGS_GE_MSG_STACK.ADD;

449: ) then
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;

Line 487: IGS_GE_MSG_STACK.ADD;

483: X_LAST_UPDATE_LOGIN := -1;
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 (