APPS.IGS_PS_UOFR_WLST_PRF_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

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

Line 119: IGS_GE_MSG_STACK.ADD;

115: ,new_references.preference_version
116: ,new_references.unit_ofr_waitlist_priority_id
117: ) THEN
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
119: IGS_GE_MSG_STACK.ADD;
120: app_exception.raise_exception;
121: END IF;
122: END Check_Uniqueness ;
123: PROCEDURE Check_Parent_Existance AS

Line 144: IGS_GE_MSG_STACK.ADD;

140: ELSIF NOT Igs_Ps_Uofr_Wlst_Pri_Pkg.Get_PK_For_Validation (
141: new_references.unit_ofr_waitlist_priority_id
142: ) THEN
143: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147:
148: END Check_Parent_Existance;

Line 255: IGS_GE_MSG_STACK.ADD;

251: Fetch cur_rowid INTO lv_rowid;
252: IF (cur_rowid%FOUND) THEN
253: Close cur_rowid;
254: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USPF_USPR_FK');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: Return;
258: END IF;
259: Close cur_rowid;

Line 311: IGS_GE_MSG_STACK.ADD;

307: Null;
308: IF Get_Pk_For_Validation(
309: new_references.unit_ofr_waitlist_pref_id) THEN
310: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: IGS_GE_MSG_STACK.ADD;
312: App_Exception.Raise_Exception;
313: END IF;
314: Check_Uniqueness;
315: Check_Constraints;

Line 331: IGS_GE_MSG_STACK.ADD;

327: -- Call all the procedures related to Before Insert.
328: IF Get_PK_For_Validation (
329: new_references.unit_ofr_waitlist_pref_id) THEN
330: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
331: IGS_GE_MSG_STACK.ADD;
332: App_Exception.Raise_Exception;
333: END IF;
334: Check_Uniqueness;
335: Check_Constraints;

Line 419: IGS_GE_MSG_STACK.ADD;

415: X_LAST_UPDATE_LOGIN := -1;
416: end if;
417: else
418: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422: SELECT IGS_PS_UOFR_WLST_PRF_S.NEXTVAL
423: INTO X_UNIT_OFR_WL_PREF_ID

Line 504: IGS_GE_MSG_STACK.ADD;

500: open c1;
501: fetch c1 into tlinfo;
502: if (c1%notfound) then
503: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
504: IGS_GE_MSG_STACK.ADD;
505: close c1;
506: app_exception.raise_exception;
507: return;
508: end if;

Line 520: IGS_GE_MSG_STACK.ADD;

516: ) then
517: null;
518: else
519: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
520: IGS_GE_MSG_STACK.ADD;
521: app_exception.raise_exception;
522: end if;
523: return;
524: end LOCK_ROW;

Line 564: IGS_GE_MSG_STACK.ADD;

560: X_LAST_UPDATE_LOGIN := -1;
561: end if;
562: else
563: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
564: IGS_GE_MSG_STACK.ADD;
565: app_exception.raise_exception;
566: end if;
567: Before_DML(
568: p_action=>'UPDATE',