DBA Data[Home] [Help]

APPS.IGS_PS_USEC_X_UNITS_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 117: IGS_GE_MSG_STACK.ADD;

113: ,new_references.cross_listed_unit_cd
114: ,new_references.uoo_id
115: ) THEN
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
117: IGS_GE_MSG_STACK.ADD;
118: app_exception.raise_exception;
119: END IF;
120: END Check_Uniqueness ;
121: PROCEDURE Check_Parent_Existance AS

Line 142: IGS_GE_MSG_STACK.ADD;

138: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
139: new_references.uoo_id
140: ) THEN
141: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145:
146: END Check_Parent_Existance;

Line 252: IGS_GE_MSG_STACK.ADD;

248: Fetch cur_rowid INTO lv_rowid;
249: IF (cur_rowid%FOUND) THEN
250: Close cur_rowid;
251: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USXU_UOO_UFK');
252: IGS_GE_MSG_STACK.ADD;
253: App_Exception.Raise_Exception;
254: Return;
255: END IF;
256: Close cur_rowid;

Line 306: IGS_GE_MSG_STACK.ADD;

302: Null;
303: IF Get_Pk_For_Validation(
304: new_references.unit_sec_cross_units_id) THEN
305: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: END IF;
309: Check_Uniqueness;
310: Check_Constraints;

Line 326: IGS_GE_MSG_STACK.ADD;

322: -- Call all the procedures related to Before Insert.
323: IF Get_PK_For_Validation (
324: new_references.unit_sec_cross_units_id) THEN
325: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END IF;
329: Check_Uniqueness;
330: Check_Constraints;

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: SELECT
417: IGS_PS_USEC_X_UNITS_S.NextVal

Line 496: IGS_GE_MSG_STACK.ADD;

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

Line 509: IGS_GE_MSG_STACK.ADD;

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

Line 552: IGS_GE_MSG_STACK.ADD;

548: X_LAST_UPDATE_LOGIN := -1;
549: end if;
550: else
551: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
552: IGS_GE_MSG_STACK.ADD;
553: app_exception.raise_exception;
554: end if;
555: Before_DML(
556: p_action=>'UPDATE',