APPS.IGS_PS_USEC_X_USEC_PKG dependencies on IGS_GE_MSG_STACK

Line 47: IGS_GE_MSG_STACK.ADD;

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

Line 114: IGS_GE_MSG_STACK.ADD;

110: new_references.child_uoo_id
111: ,new_references.parent_uoo_id
112: ) THEN
113: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: IGS_GE_MSG_STACK.ADD;
115: app_exception.raise_exception;
116: END IF;
117: END Check_Uniqueness ;
118: PROCEDURE Check_Parent_Existance AS

Line 139: IGS_GE_MSG_STACK.ADD;

135: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
136: new_references.child_uoo_id
137: ) THEN
138: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;
141: END IF;
142:
143: IF (((old_references.parent_uoo_id = new_references.parent_uoo_id)) OR

Line 150: IGS_GE_MSG_STACK.ADD;

146: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
147: new_references.parent_uoo_id
148: ) THEN
149: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153:
154: 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_USXUS_UNOO_UFK');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: Return;
269: END IF;
270: Close cur_rowid;

Line 318: IGS_GE_MSG_STACK.ADD;

314: Null;
315: IF Get_Pk_For_Validation(
316: new_references.unit_sec_cross_unit_sec_id) THEN
317: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: Check_Uniqueness;
322: Check_Constraints;

Line 338: IGS_GE_MSG_STACK.ADD;

334: -- Call all the procedures related to Before Insert.
335: IF Get_PK_For_Validation (
336: new_references.unit_sec_cross_unit_sec_id) THEN
337: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
338: IGS_GE_MSG_STACK.ADD;
339: App_Exception.Raise_Exception;
340: END IF;
341: Check_Uniqueness;
342: Check_Constraints;

Line 425: IGS_GE_MSG_STACK.ADD;

421: X_LAST_UPDATE_LOGIN := -1;
422: end if;
423: else
424: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
425: IGS_GE_MSG_STACK.ADD;
426: app_exception.raise_exception;
427: end if;
428:
429:

Line 506: IGS_GE_MSG_STACK.ADD;

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

Line 518: IGS_GE_MSG_STACK.ADD;

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

Line 560: IGS_GE_MSG_STACK.ADD;

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