APPS.IGS_PS_USEC_WLST_PRI_PKG dependencies on IGS_GE_MSG_STACK

Line 48: IGS_GE_MSG_STACK.ADD;

44: FETCH cur_old_ref_values INTO old_references;
45: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
46: Close cur_old_ref_values;
47: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
48: IGS_GE_MSG_STACK.ADD;
49: App_Exception.Raise_Exception;
50: Return;
51: END IF;
52: Close cur_old_ref_values;

Line 112: IGS_GE_MSG_STACK.ADD;

108: new_references.priority_value
109: ,new_references.uoo_id
110: ) THEN
111: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
112: IGS_GE_MSG_STACK.ADD;
113: app_exception.raise_exception;
114: END IF;
115: END Check_Uniqueness;
116:

Line 137: IGS_GE_MSG_STACK.ADD;

133: NULL;
134: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation('UNIT_WAITLIST',
135: new_references.priority_value) THEN
136: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140:
141: IF (((old_references.uoo_id = new_references.uoo_id)) OR

Line 148: igs_ge_msg_stack.add;

144: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation(
145: new_references.uoo_id
146: ) THEN
147: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151:
152: END Check_Parent_Existance;

Line 276: igs_ge_msg_stack.add;

272: FETCH cur_rowid INTO lv_rowid;
273: IF (cur_rowid%FOUND) THEN
274: CLOSE cur_rowid;
275: fnd_message.set_name('IGS', 'IGS_PS_USP_UOO_FK');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: RETURN;
279: END IF;
280: CLOSE cur_rowid;

Line 330: IGS_GE_MSG_STACK.ADD;

326: Null;
327: IF Get_Pk_For_Validation(
328: new_references.unit_sec_waitlist_priority_id) THEN
329: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333: Check_Uniqueness;
334: Check_Constraints;

Line 351: IGS_GE_MSG_STACK.ADD;

347: -- Call all the procedures related to Before Insert.
348: IF Get_PK_For_Validation (
349: new_references.unit_sec_waitlist_priority_id) THEN
350: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
351: IGS_GE_MSG_STACK.ADD;
352: App_Exception.Raise_Exception;
353: END IF;
354: Check_Uniqueness;
355: Check_Constraints;

Line 441: IGS_GE_MSG_STACK.ADD;

437: X_LAST_UPDATE_LOGIN := -1;
438: end if;
439: else
440: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
441: IGS_GE_MSG_STACK.ADD;
442: app_exception.raise_exception;
443: end if;
444: SELECT
445: igs_ps_usec_wlst_pri_s.nextval

Line 523: igs_ge_msg_stack.add;

519: OPEN c1;
520: FETCH c1 INTO tlinfo;
521: if (c1%NOTFOUND) then
522: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
523: igs_ge_msg_stack.add;
524: CLOSE c1;
525: app_exception.raise_exception;
526: RETURN;
527: END IF;

Line 536: IGS_GE_MSG_STACK.ADD;

532: ) THEN
533: null;
534: else
535: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
536: IGS_GE_MSG_STACK.ADD;
537: app_exception.raise_exception;
538: end if;
539: return;
540: END lock_row;

Line 580: IGS_GE_MSG_STACK.ADD;

576: X_LAST_UPDATE_LOGIN := -1;
577: end if;
578: else
579: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
580: IGS_GE_MSG_STACK.ADD;
581: app_exception.raise_exception;
582: end if;
583: before_dml(
584: p_action=>'UPDATE',