DBA Data[Home] [Help]

APPS.IGS_PS_USEC_AS_PKG dependencies on IGS_GE_MSG_STACK

Line 52: IGS_GE_MSG_STACK.ADD;

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

Line 127: IGS_GE_MSG_STACK.ADD;

123: ,new_references.room_code
124: ,new_references.uoo_id
125: ) THEN
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
127: IGS_GE_MSG_STACK.ADD;
128: app_exception.raise_exception;
129: END IF;
130: END Check_Uniqueness ;
131: PROCEDURE Check_Parent_Existance AS

Line 152: IGS_GE_MSG_STACK.ADD;

148: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
149: new_references.uoo_id
150: ) THEN
151: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155:
156: END Check_Parent_Existance;

Line 266: IGS_GE_MSG_STACK.ADD;

262: Fetch cur_rowid INTO lv_rowid;
263: IF (cur_rowid%FOUND) THEN
264: Close cur_rowid;
265: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USAS_UOO_UFK');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: Return;
269: END IF;
270: Close cur_rowid;

Line 328: IGS_GE_MSG_STACK.ADD;

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

Line 348: IGS_GE_MSG_STACK.ADD;

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

Line 440: IGS_GE_MSG_STACK.ADD;

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

Line 540: IGS_GE_MSG_STACK.ADD;

536: open c1;
537: fetch c1 into tlinfo;
538: if (c1%notfound) then
539: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
540: IGS_GE_MSG_STACK.ADD;
541: close c1;
542: app_exception.raise_exception;
543: return;
544: end if;

Line 565: IGS_GE_MSG_STACK.ADD;

561: ) then
562: null;
563: else
564: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
565: IGS_GE_MSG_STACK.ADD;
566: app_exception.raise_exception;
567: end if;
568: return;
569: end LOCK_ROW;

Line 612: IGS_GE_MSG_STACK.ADD;

608: X_LAST_UPDATE_LOGIN := -1;
609: end if;
610: else
611: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
612: IGS_GE_MSG_STACK.ADD;
613: app_exception.raise_exception;
614: end if;
615: Before_DML(
616: p_action=>'UPDATE',