DBA Data[Home] [Help]

APPS.IGS_PS_UNT_REPT_FMLY_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

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

Line 120: IGS_GE_MSG_STACK.ADD;

116: ,new_references.unit_code
117: ,new_references.unit_version_number
118: ) THEN
119: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
120: IGS_GE_MSG_STACK.ADD;
121: app_exception.raise_exception;
122: END IF;
123: END Check_Uniqueness ;
124: PROCEDURE Check_Parent_Existance AS

Line 148: IGS_GE_MSG_STACK.ADD;

144: new_references.unit_code,
145: new_references.unit_version_number
146: ) THEN
147: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151:
152: IF (((old_references.repeat_fmly_unit_code = new_references.repeat_fmly_unit_code) AND

Line 162: IGS_GE_MSG_STACK.ADD;

158: new_references.repeat_fmly_unit_code,
159: new_references.repeat_fmly_unit_version_num
160: ) THEN
161: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165:
166: END Check_Parent_Existance;

Line 278: IGS_GE_MSG_STACK.ADD;

274: Fetch cur_rowid INTO lv_rowid;
275: IF (cur_rowid%FOUND) THEN
276: Close cur_rowid;
277: Fnd_Message.Set_Name ('IGS', 'IGS_PS_URV_UV_FK');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: Return;
281: END IF;
282: Close cur_rowid;

Line 334: IGS_GE_MSG_STACK.ADD;

330: Null;
331: IF Get_Pk_For_Validation(
332: new_references.unit_repeat_family_id) THEN
333: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337: Check_Uniqueness;
338: Check_Constraints;

Line 354: IGS_GE_MSG_STACK.ADD;

350: -- Call all the procedures related to Before Insert.
351: IF Get_PK_For_Validation (
352: new_references.unit_repeat_family_id) THEN
353: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356: END IF;
357: Check_Uniqueness;
358: Check_Constraints;

Line 442: IGS_GE_MSG_STACK.ADD;

438: X_LAST_UPDATE_LOGIN := -1;
439: end if;
440: else
441: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: end if;
445: SELECT IGS_PS_UNT_REPT_FMLY_S.NEXTVAL
446: INTO X_UNIT_REPEAT_FAMILY_ID

Line 527: IGS_GE_MSG_STACK.ADD;

523: open c1;
524: fetch c1 into tlinfo;
525: if (c1%notfound) then
526: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
527: IGS_GE_MSG_STACK.ADD;
528: close c1;
529: app_exception.raise_exception;
530: return;
531: end if;

Line 541: IGS_GE_MSG_STACK.ADD;

537: ) then
538: null;
539: else
540: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
541: IGS_GE_MSG_STACK.ADD;
542: app_exception.raise_exception;
543: end if;
544: return;
545: end LOCK_ROW;

Line 585: IGS_GE_MSG_STACK.ADD;

581: X_LAST_UPDATE_LOGIN := -1;
582: end if;
583: else
584: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
585: IGS_GE_MSG_STACK.ADD;
586: app_exception.raise_exception;
587: end if;
588: Before_DML(
589: p_action=>'UPDATE',