APPS.IGS_AD_GOV_BAS_FR_TY_PKG dependencies on IGS_GE_MSG_STACK

Line 36: IGS_GE_MSG_STACK.ADD;

32: Fetch cur_old_ref_values INTO old_references;
33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
34: Close cur_old_ref_values;
35: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
36: IGS_GE_MSG_STACK.ADD;
37: App_Exception.Raise_Exception;
38: Return;
39: END IF;
40: Close cur_old_ref_values;

Line 74: IGS_GE_MSG_STACK.ADD;

70: new_references.GOVT_BASIS_FOR_ADM_TYPE,
71: new_references.closed_ind,
72: v_message_name) = FALSE THEN
73: Fnd_Message.Set_Name('IGS',v_message_name);
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76: END IF;
77: END IF;
78:

Line 100: IGS_GE_MSG_STACK.ADD;

96:
97: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
98: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
99: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception ;
102: END IF;
103:
104: IF new_references.CLOSED_IND not in ('Y','N') then

Line 106: IGS_GE_MSG_STACK.ADD;

102: END IF;
103:
104: IF new_references.CLOSED_IND not 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:
110: END IF ;

Line 115: IGS_GE_MSG_STACK.ADD;

111:
112: IF upper(Column_name) = 'GOVT_BASIS_FOR_ADM_TYPE' OR COLUMN_NAME IS NULL THEN
113: IF new_references.GOVT_BASIS_FOR_ADM_TYPE<> upper(new_references.GOVT_BASIS_FOR_ADM_TYPE) then
114: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception ;
117: END IF;
118:
119: END IF ;

Line 194: IGS_GE_MSG_STACK.ADD;

190: Null;
191: IF Get_PK_For_Validation (
192: new_references.govt_basis_for_adm_type ) THEN
193: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: Check_Constraints;
198: ELSIF (p_action = 'UPDATE') THEN

Line 210: IGS_GE_MSG_STACK.ADD;

206: IF Get_PK_For_Validation (
207: new_references.govt_basis_for_adm_type
208: ) THEN
209: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213: Check_Constraints;
214: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 262: IGS_GE_MSG_STACK.ADD;

258: X_LAST_UPDATE_LOGIN := -1;
259: end if;
260: else
261: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
262: IGS_GE_MSG_STACK.ADD;
263: app_exception.raise_exception;
264: end if;
265:
266: Before_DML (

Line 333: IGS_GE_MSG_STACK.ADD;

329: fetch c1 into tlinfo;
330: if (c1%notfound) then
331: close c1;
332: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
333: IGS_GE_MSG_STACK.ADD;
334: app_exception.raise_exception;
335: return;
336: end if;
337: close c1;

Line 345: IGS_GE_MSG_STACK.ADD;

341: ) then
342: null;
343: else
344: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: end if;
348: return;
349: end LOCK_ROW;

Line 377: IGS_GE_MSG_STACK.ADD;

373: X_LAST_UPDATE_LOGIN := -1;
374: end if;
375: else
376: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
377: IGS_GE_MSG_STACK.ADD;
378: app_exception.raise_exception;
379: end if;
380:
381: Before_DML (