APPS.IGS_PS_USEC_RPT_FMLY_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.repeat_family_version_number
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: IF (((old_references.repeat_family_unit_cd = new_references.repeat_family_unit_cd) AND

Line 156: IGS_GE_MSG_STACK.ADD;

152: new_references.repeat_family_unit_cd,
153: new_references.repeat_family_version_number
154: ) THEN
155: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159:
160: 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_USRF_UOO_FK');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: Return;
269: END IF;
270: Close cur_rowid;

Line 305: IGS_GE_MSG_STACK.ADD;

301: Fetch cur_rowid INTO lv_rowid;
302: IF (cur_rowid%FOUND) THEN
303: Close cur_rowid;
304: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USRF_UV_FK');
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: Return;
308: END IF;
309: Close cur_rowid;

Line 359: IGS_GE_MSG_STACK.ADD;

355: Null;
356: IF Get_Pk_For_Validation(
357: new_references.unit_section_repeat_family_id) THEN
358: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
359: IGS_GE_MSG_STACK.ADD;
360: App_Exception.Raise_Exception;
361: END IF;
362: Check_Uniqueness;
363: Check_Constraints;

Line 379: IGS_GE_MSG_STACK.ADD;

375: -- Call all the procedures related to Before Insert.
376: IF Get_PK_For_Validation (
377: new_references.unit_section_repeat_family_id) THEN
378: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
379: IGS_GE_MSG_STACK.ADD;
380: App_Exception.Raise_Exception;
381: END IF;
382: Check_Uniqueness;
383: Check_Constraints;

Line 466: IGS_GE_MSG_STACK.ADD;

462: X_LAST_UPDATE_LOGIN := -1;
463: end if;
464: else
465: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
466: IGS_GE_MSG_STACK.ADD;
467: app_exception.raise_exception;
468: end if;
469: select igs_ps_usec_rpt_fmly_s.nextval into x_unit_section_rpt_family_id from dual;
470: Before_DML(

Line 544: IGS_GE_MSG_STACK.ADD;

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

Line 557: IGS_GE_MSG_STACK.ADD;

553: ) then
554: null;
555: else
556: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
557: IGS_GE_MSG_STACK.ADD;
558: app_exception.raise_exception;
559: end if;
560: return;
561: end LOCK_ROW;

Line 600: IGS_GE_MSG_STACK.ADD;

596: X_LAST_UPDATE_LOGIN := -1;
597: end if;
598: else
599: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
600: IGS_GE_MSG_STACK.ADD;
601: app_exception.raise_exception;
602: end if;
603: Before_DML(
604: p_action=>'UPDATE',