APPS.IGS_AS_EXM_MTRL_TYPE_PKG dependencies on IGS_GE_MSG_STACK

Line 38: Igs_Ge_Msg_Stack.Add;

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

Line 117: Igs_Ge_Msg_Stack.Add;

113: IF upper(column_name) = 'EXAM_MATERIAL_TYPE' OR
114: column_name is null Then
115: IF new_references.exam_material_type <> UPPER(new_references.exam_material_type) Then
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
117: Igs_Ge_Msg_Stack.Add;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121:

Line 126: Igs_Ge_Msg_Stack.Add;

122: IF upper(column_name) = 'CLOSED_IND' OR
123: column_name is null Then
124: IF new_references.closed_ind <> UPPER(new_references.closed_ind) OR new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
125: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
126: Igs_Ge_Msg_Stack.Add;
127: App_Exception.Raise_Exception;
128: END IF;
129: END IF;
130:

Line 171: Igs_Ge_Msg_Stack.Add;

167: IF Get_PK_For_Validation (
168: new_references.exam_material_type
169: ) THEN
170: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
171: Igs_Ge_Msg_Stack.Add;
172: App_Exception.Raise_Exception;
173: END IF;
174:
175: Check_Constraints;

Line 189: Igs_Ge_Msg_Stack.Add;

185: IF Get_PK_For_Validation (
186: new_references.exam_material_type
187: ) THEN
188: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
189: Igs_Ge_Msg_Stack.Add;
190: App_Exception.Raise_Exception;
191: END IF;
192:
193: Check_Constraints;

Line 242: Igs_Ge_Msg_Stack.Add;

238: X_LAST_UPDATE_LOGIN := -1;
239: end if;
240: else
241: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
242: Igs_Ge_Msg_Stack.Add;
243: app_exception.raise_exception;
244: end if;
245: Before_DML(
246: p_action=>'INSERT',

Line 310: Igs_Ge_Msg_Stack.Add;

306: open c1;
307: fetch c1 into tlinfo;
308: if (c1%notfound) then
309: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
310: Igs_Ge_Msg_Stack.Add;
311: close c1;
312: app_exception.raise_exception;
313: return;
314: end if;

Line 326: Igs_Ge_Msg_Stack.Add;

322: ) then
323: null;
324: else
325: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
326: Igs_Ge_Msg_Stack.Add;
327: app_exception.raise_exception;
328: end if;
329: return;
330: 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',