DBA Data[Home] [Help]

APPS.IGS_AD_TAC_AD_CD_PKG dependencies on IGS_GE_MSG_STACK

Line 37: IGS_GE_MSG_STACK.ADD;

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

Line 75: IGS_GE_MSG_STACK.ADD;

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

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 NOT IN ('Y','N') 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: END IF;
104: IF upper(Column_Name) = 'TAC_ADMISSION_CD' OR Column_Name IS NULL THEN

Line 107: IGS_GE_MSG_STACK.ADD;

103: END IF;
104: IF upper(Column_Name) = 'TAC_ADMISSION_CD' OR Column_Name IS NULL THEN
105: IF new_references.tac_admission_cd <> UPPER(new_references.tac_admission_cd) THEN
106: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
111: END Check_Constraints;

Line 182: IGS_GE_MSG_STACK.ADD;

178: IF Get_PK_For_Validation (
179: new_references.tac_admission_cd
180: ) THEN
181: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185: Check_Constraints;
186: ELSIF (p_action = 'UPDATE') THEN

Line 197: IGS_GE_MSG_STACK.ADD;

193: IF Get_PK_For_Validation (
194: new_references.tac_admission_cd
195: ) THEN
196: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: Check_Constraints;
201: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 245: IGS_GE_MSG_STACK.ADD;

241: X_LAST_UPDATE_LOGIN := -1;
242: end if;
243: else
244: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
245: IGS_GE_MSG_STACK.ADD;
246: app_exception.raise_exception;
247: end if;
248:
249: Before_DML (

Line 315: IGS_GE_MSG_STACK.ADD;

311: fetch c1 into tlinfo;
312: if (c1%notfound) then
313: close c1;
314: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
315: IGS_GE_MSG_STACK.ADD;
316: app_exception.raise_exception;
317: return;
318: end if;
319: close c1;

Line 327: IGS_GE_MSG_STACK.ADD;

323: ) then
324: null;
325: else
326: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330: return;
331: end LOCK_ROW;

Line 359: IGS_GE_MSG_STACK.ADD;

355: X_LAST_UPDATE_LOGIN := -1;
356: end if;
357: else
358: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
359: IGS_GE_MSG_STACK.ADD;
360: app_exception.raise_exception;
361: end if;
362: Before_DML (
363: p_action => 'UPDATE',