APPS.IGS_FI_GOVT_HEC_CNTB_PKG dependencies on IGS_GE_MSG_STACK

Line 31: IGS_GE_MSG_STACK.ADD;

27: Fetch cur_old_ref_values INTO old_references;
28: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
29: Close cur_old_ref_values;
30: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
31: IGS_GE_MSG_STACK.ADD;
32: App_Exception.Raise_Exception;
33: Return;
34: END IF;
35: Close cur_old_ref_values;

Line 66: IGS_GE_MSG_STACK.ADD;

62: END IF;
63: IF ((UPPER (column_name) = 'GOVT_HECS_CNTRBTN_BAND') OR (column_name IS NULL)) THEN
64: IF ((new_references.govt_hecs_cntrbtn_band < 1) OR (new_references.govt_hecs_cntrbtn_band > 99)) THEN
65: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
66: IGS_GE_MSG_STACK.ADD;
67: App_Exception.Raise_Exception;
68: END IF;
69: END IF;
70: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN

Line 73: IGS_GE_MSG_STACK.ADD;

69: END IF;
70: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN
71: IF (new_references.closed_ind NOT IN ('Y', 'N')) THEN
72: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75: END IF;
76: END IF;
77: END Check_Constraints;

Line 138: IGS_GE_MSG_STACK.ADD;

134: IF (Get_PK_For_Validation (
135: new_references.govt_hecs_cntrbtn_band
136: )) THEN
137: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: Check_Constraints;
142: ELSIF (p_action = 'UPDATE') THEN

Line 153: IGS_GE_MSG_STACK.ADD;

149: IF (Get_PK_For_Validation (
150: new_references.govt_hecs_cntrbtn_band
151: )) THEN
152: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: END IF;
156: Check_Constraints;
157: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 191: IGS_GE_MSG_STACK.ADD;

187: X_LAST_UPDATE_LOGIN := -1;
188: end if;
189: else
190: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
191: IGS_GE_MSG_STACK.ADD;
192: app_exception.raise_exception;
193: end if;
194: Before_DML(
195: p_action=>'INSERT',

Line 252: IGS_GE_MSG_STACK.ADD;

248: fetch c1 into tlinfo;
249: if (c1%notfound) then
250: close c1;
251: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
252: IGS_GE_MSG_STACK.ADD;
253: app_exception.raise_exception;
254: return;
255: end if;
256: close c1;

Line 263: IGS_GE_MSG_STACK.ADD;

259: ) then
260: null;
261: else
262: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
263: IGS_GE_MSG_STACK.ADD;
264: app_exception.raise_exception;
265: end if;
266: return;
267: end LOCK_ROW;

Line 294: IGS_GE_MSG_STACK.ADD;

290: X_LAST_UPDATE_LOGIN := -1;
291: end if;
292: else
293: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
294: IGS_GE_MSG_STACK.ADD;
295: app_exception.raise_exception;
296: end if;
297: Before_DML(
298: p_action=>'UPDATE',