APPS.IGS_EN_ORUN_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 119: IGS_GE_MSG_STACK.ADD;

115: ELSIF NOT Igs_En_Or_Unit_Wlst_Pkg.Get_PK_For_Validation (
116: new_references.org_unit_wlst_id
117: ) THEN
118: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122:
123: IF (((old_references.priority_value = new_references.priority_value)) OR

Line 129: IGS_GE_MSG_STACK.ADD;

125: NULL;
126: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation ('UNIT_WAITLIST',new_references.priority_value)
127: THEN
128: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132:
133: END Check_Parent_Existance;

Line 220: IGS_GE_MSG_STACK.ADD;

216: Fetch cur_rowid INTO lv_rowid;
217: IF (cur_rowid%FOUND) THEN
218: Close cur_rowid;
219: Fnd_Message.Set_Name ('IGS', 'IGS_EN_OUWP_OUW_FK');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: Return;
223: END IF;
224: Close cur_rowid;

Line 241: IGS_GE_MSG_STACK.ADD;

237: OPEN cur_rowid;
238: FETCH cur_rowid INTO lv_rowid;
239: IF (cur_rowid%FOUND) THEN
240: Fnd_Message.Set_Name ('IGS','IGS_EN_EWPI_LKUPV_FK');
241: IGS_GE_MSG_STACK.ADD;
242: CLOSE cur_rowid;
243: APP_EXCEPTION.RAISE_EXCEPTION;
244: RETURN;
245: END IF;

Line 295: IGS_GE_MSG_STACK.ADD;

291: Null;
292: IF Get_Pk_For_Validation(
293: new_references.org_unit_wlst_pri_id) THEN
294: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298: Check_Constraints;
299: Check_Parent_Existance;

Line 314: IGS_GE_MSG_STACK.ADD;

310: -- Call all the procedures related to Before Insert.
311: IF Get_PK_For_Validation (
312: new_references.org_unit_wlst_pri_id) THEN
313: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
314: IGS_GE_MSG_STACK.ADD;
315: App_Exception.Raise_Exception;
316: END IF;
317: Check_Constraints;
318: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 399: IGS_GE_MSG_STACK.ADD;

395: X_LAST_UPDATE_LOGIN := -1;
396: end if;
397: else
398: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
399: IGS_GE_MSG_STACK.ADD;
400: app_exception.raise_exception;
401: end if;
402: SELECT IGS_EN_OR_UNIT_WLST_PRI_S.NEXTVAL
403: INTO x_org_unit_wlst_pri_id

Line 479: IGS_GE_MSG_STACK.ADD;

475: open c1;
476: fetch c1 into tlinfo;
477: if (c1%notfound) then
478: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
479: IGS_GE_MSG_STACK.ADD;
480: close c1;
481: app_exception.raise_exception;
482: return;
483: end if;

Line 492: IGS_GE_MSG_STACK.ADD;

488: ) then
489: null;
490: else
491: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495: return;
496: end LOCK_ROW;

Line 535: IGS_GE_MSG_STACK.ADD;

531: X_LAST_UPDATE_LOGIN := -1;
532: end if;
533: else
534: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
535: IGS_GE_MSG_STACK.ADD;
536: app_exception.raise_exception;
537: end if;
538: Before_DML(
539: p_action=>'UPDATE',