APPS.IGS_AS_SPCL_CONS_CAT_PKG dependencies on IGS_GE_MSG_STACK

Line 37: Igs_Ge_Msg_Stack.Add;

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

Line 115: Igs_Ge_Msg_Stack.Add;

111: IF upper(column_name) = 'CLOSED_IND' OR
112: column_name is null Then
113: IF new_references.closed_ind <> UPPER(new_references.closed_ind) or new_references.closed_ind NOT IN ( 'Y' , 'N' )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: END IF;
119: IF upper(column_name) = 'SPCL_CONSIDERATION_CAT' OR

Line 123: Igs_Ge_Msg_Stack.Add;

119: IF upper(column_name) = 'SPCL_CONSIDERATION_CAT' OR
120: column_name is null Then
121: IF new_references.spcl_consideration_cat <> UPPER(new_references.spcl_consideration_cat) Then
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
123: Igs_Ge_Msg_Stack.Add;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
127:

Line 166: Igs_Ge_Msg_Stack.Add;

162: IF Get_PK_For_Validation (
163: new_references.spcl_consideration_cat
164: ) THEN
165: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
166: Igs_Ge_Msg_Stack.Add;
167: App_Exception.Raise_Exception;
168: END IF;
169:
170: Check_Constraints;

Line 184: Igs_Ge_Msg_Stack.Add;

180: IF Get_PK_For_Validation (
181: new_references.spcl_consideration_cat
182: ) THEN
183: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
184: Igs_Ge_Msg_Stack.Add;
185: App_Exception.Raise_Exception;
186: END IF;
187: Check_Constraints;
188: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 232: Igs_Ge_Msg_Stack.Add;

228: X_LAST_UPDATE_LOGIN := -1;
229: end if;
230: else
231: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
232: Igs_Ge_Msg_Stack.Add;
233: app_exception.raise_exception;
234: end if;
235: Before_DML(
236: p_action=>'INSERT',

Line 300: Igs_Ge_Msg_Stack.Add;

296: open c1;
297: fetch c1 into tlinfo;
298: if (c1%notfound) then
299: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
300: Igs_Ge_Msg_Stack.Add;
301: close c1;
302: app_exception.raise_exception;
303: return;
304: end if;

Line 314: Igs_Ge_Msg_Stack.Add;

310: ) then
311: null;
312: else
313: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
314: Igs_Ge_Msg_Stack.Add;
315: app_exception.raise_exception;
316: end if;
317: return;
318: end LOCK_ROW;

Line 347: Igs_Ge_Msg_Stack.Add;

343: X_LAST_UPDATE_LOGIN := -1;
344: end if;
345: else
346: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
347: Igs_Ge_Msg_Stack.Add;
348: app_exception.raise_exception;
349: end if;
350: Before_DML(
351: p_action=>'UPDATE',