APPS.IGS_AD_BUILDING_PKG dependencies on IGS_GE_MSG_STACK

Line 50: IGS_GE_MSG_STACK.ADD;

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

Line 106: IGS_GE_MSG_STACK.ADD;

102: IF Upper(Column_Name) = 'CLOSED_IND' OR
103: Column_Name IS NULL THEN
104: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
105: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:

Line 132: IGS_GE_MSG_STACK.ADD;

128: new_references.building_cd
129: ,new_references.location_cd
130: ) THEN
131: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
132: IGS_GE_MSG_STACK.ADD;
133: app_exception.raise_exception;
134: END IF;
135: END Check_Uniqueness ;
136: PROCEDURE Check_Parent_Existance AS

Line 157: IGS_GE_MSG_STACK.ADD;

153: ELSIF NOT Igs_Ad_Location_Pkg.Get_PK_For_Validation (
154: new_references.location_cd,
155: 'N') THEN
156: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160:
161: END Check_Parent_Existance;

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_AD_BLDG_LOC_FK');
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: Return;
308: END IF;
309: Close cur_rowid;

Line 363: IGS_GE_MSG_STACK.ADD;

359: Null;
360: IF Get_Pk_For_Validation(
361: new_references.building_id) THEN
362: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: Check_Uniqueness;
367: Check_Constraints;

Line 384: IGS_GE_MSG_STACK.ADD;

380: -- Call all the procedures related to Before Insert.
381: IF Get_PK_For_Validation (
382: new_references.building_id) THEN
383: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: END IF;
387: Check_Uniqueness;
388: Check_Constraints;

Line 474: IGS_GE_MSG_STACK.ADD;

470: X_LAST_UPDATE_LOGIN := -1;
471: end if;
472: else
473: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
474: IGS_GE_MSG_STACK.ADD;
475: app_exception.raise_exception;
476: end if;
477:
478: x_BUILDING_ID := -1;

Line 561: IGS_GE_MSG_STACK.ADD;

557: open c1;
558: fetch c1 into tlinfo;
559: if (c1%notfound) then
560: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
561: IGS_GE_MSG_STACK.ADD;
562: close c1;
563: app_exception.raise_exception;
564: return;
565: end if;

Line 575: IGS_GE_MSG_STACK.ADD;

571: ) then
572: null;
573: else
574: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
575: IGS_GE_MSG_STACK.ADD;
576: app_exception.raise_exception;
577: end if;
578: return;
579: end LOCK_ROW;

Line 619: IGS_GE_MSG_STACK.ADD;

615: X_LAST_UPDATE_LOGIN := -1;
616: end if;
617: else
618: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
619: IGS_GE_MSG_STACK.ADD;
620: app_exception.raise_exception;
621: end if;
622: Before_DML(
623: p_action=>'UPDATE',