APPS.IGS_PS_AWD_OWN_PKG dependencies on IGS_GE_MSG_STACK

Line 41: IGS_GE_MSG_STACK.ADD;

37: Fetch cur_old_ref_values INTO old_references;
38: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
39: Close cur_old_ref_values;
40: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
41: IGS_GE_MSG_STACK.ADD;
42: App_Exception.Raise_Exception;
43: Return;
44: END IF;
45: Close cur_old_ref_values;

Line 99: IGS_GE_MSG_STACK.ADD;

95: v_course_cd,
96: v_version_number,
97: v_message_name) = FALSE THEN
98: Fnd_Message.Set_Name('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: -- Validate the org IGS_PS_UNIT. Org IGS_PS_UNIT is not updateable.
103: IF p_inserting THEN

Line 110: IGS_GE_MSG_STACK.ADD;

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

Line 136: igs_ge_msg_stack.add;

132: FETCH c_closed_ind INTO l_c_closed_ind;
133: CLOSE c_closed_ind;
134: IF l_c_closed_ind = 'Y' THEN
135: fnd_message.set_name('IGS','IGS_PS_AWD_CD_CLOSED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139: END IF;
140: END before_insert_update;

Line 163: IGS_GE_MSG_STACK.ADD;

159: IF upper(column_name) = 'PERCENTAGE' OR
160: column_name is null Then
161: IF ( new_references.percentage < 0 OR new_references.percentage > 100 ) Then
162: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: END IF;
167:

Line 172: IGS_GE_MSG_STACK.ADD;

168: IF upper(column_name) = 'AWARD_CD' OR
169: column_name is null Then
170: IF ( new_references.award_cd <> UPPER(new_references.award_cd) ) Then
171: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176:

Line 181: IGS_GE_MSG_STACK.ADD;

177: IF upper(column_name) = 'COURSE_CD' OR
178: column_name is null Then
179: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
180: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184: END IF;
185:

Line 205: IGS_GE_MSG_STACK.ADD;

201: new_references.version_number,
202: new_references.award_cd
203: ) THEN
204: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208: END IF;
209:

Line 221: IGS_GE_MSG_STACK.ADD;

217: new_references.org_unit_cd,
218: new_references.ou_start_dt
219: ) THEN
220: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: END IF;
225:

Line 283: IGS_GE_MSG_STACK.ADD;

279: Fetch cur_rowid INTO lv_rowid;
280: IF (cur_rowid%FOUND) THEN
281: Close cur_rowid;
282: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CAO_OU_FK');
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: Return;
286: END IF;
287: Close cur_rowid;

Line 335: IGS_GE_MSG_STACK.ADD;

331: new_references.award_cd ,
332: new_references.org_unit_cd ,
333: new_references.ou_start_dt) THEN
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: Check_Constraints;
339: Check_Parent_Existance;

Line 357: IGS_GE_MSG_STACK.ADD;

353: new_references.award_cd ,
354: new_references.org_unit_cd ,
355: new_references.ou_start_dt) 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: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 413: IGS_GE_MSG_STACK.ADD;

409: X_LAST_UPDATE_LOGIN := -1;
410: end if;
411: else
412: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
413: IGS_GE_MSG_STACK.ADD;
414: app_exception.raise_exception;
415: end if;
416:
417: Before_DML (

Line 496: IGS_GE_MSG_STACK.ADD;

492: fetch c1 into tlinfo;
493: if (c1%notfound) then
494: close c1;
495: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
496: IGS_GE_MSG_STACK.ADD;
497: app_exception.raise_exception;
498: return;
499: end if;
500: close c1;

Line 507: IGS_GE_MSG_STACK.ADD;

503: ) then
504: null;
505: else
506: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
507: IGS_GE_MSG_STACK.ADD;
508: app_exception.raise_exception;
509: end if;
510: return;
511: end LOCK_ROW;

Line 542: IGS_GE_MSG_STACK.ADD;

538: X_LAST_UPDATE_LOGIN := -1;
539: end if;
540: else
541: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
542: IGS_GE_MSG_STACK.ADD;
543: app_exception.raise_exception;
544: end if;
545:
546: Before_DML (