APPS.IGS_AS_SPCL_CONS_OUT_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 121: Igs_Ge_Msg_Stack.Add;

117: IF upper(column_name) = 'CLOSED_IND' OR
118: column_name is null Then
119: IF new_references.closed_ind <> UPPER(new_references.closed_ind) or new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
120: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
121: Igs_Ge_Msg_Stack.Add;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125:

Line 130: Igs_Ge_Msg_Stack.Add;

126: IF upper(column_name) = 'SPCL_CONSIDERATION_OUTCOME' OR
127: column_name is null Then
128: IF new_references.spcl_consideration_outcome <> UPPER(new_references.spcl_consideration_outcome) Then
129: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
130: Igs_Ge_Msg_Stack.Add;
131: App_Exception.Raise_Exception;
132: END IF;
133: END IF;
134: IF upper(column_name) = 'SOUGHT_OUTCOME_IND' OR

Line 138: Igs_Ge_Msg_Stack.Add;

134: IF upper(column_name) = 'SOUGHT_OUTCOME_IND' OR
135: column_name is null Then
136: IF new_references.sought_outcome_ind NOT IN ( 'Y' , 'N' ) Then
137: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
138: Igs_Ge_Msg_Stack.Add;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF;
142:

Line 184: Igs_Ge_Msg_Stack.Add;

180: IF Get_PK_For_Validation (
181: new_references.spcl_consideration_outcome
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:
188: Check_Constraints;

Line 202: Igs_Ge_Msg_Stack.Add;

198: IF Get_PK_For_Validation (
199: new_references.spcl_consideration_outcome
200: ) THEN
201: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
202: Igs_Ge_Msg_Stack.Add;
203: App_Exception.Raise_Exception;
204: END IF;
205: Check_Constraints;
206: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 247: Igs_Ge_Msg_Stack.Add;

243: X_LAST_UPDATE_LOGIN := -1;
244: end if;
245: else
246: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
247: Igs_Ge_Msg_Stack.Add;
248: app_exception.raise_exception;
249: end if;
250: Before_DML(
251: p_action=>'INSERT',

Line 321: Igs_Ge_Msg_Stack.Add;

317: open c1;
318: fetch c1 into tlinfo;
319: if (c1%notfound) then
320: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
321: Igs_Ge_Msg_Stack.Add;
322: close c1;
323: app_exception.raise_exception;
324: return;
325: end if;

Line 336: Igs_Ge_Msg_Stack.Add;

332: ) then
333: null;
334: else
335: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
336: Igs_Ge_Msg_Stack.Add;
337: app_exception.raise_exception;
338: end if;
339: return;
340: end LOCK_ROW;

Line 370: Igs_Ge_Msg_Stack.Add;

366: X_LAST_UPDATE_LOGIN := -1;
367: end if;
368: else
369: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
370: Igs_Ge_Msg_Stack.Add;
371: app_exception.raise_exception;
372: end if;
373: Before_DML(
374: p_action=>'UPDATE',