APPS.IGS_AS_SASSESS_TYPE_PKG dependencies on IGS_GE_MSG_STACK

Line 32: Igs_Ge_Msg_Stack.Add;

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

Line 66: Igs_Ge_Msg_Stack.Add;

62: new_references.non_cntrl_exam_loc_cd,
63: 'N'
64: ))THEN
65: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
66: Igs_Ge_Msg_Stack.Add;
67: App_Exception.Raise_Exception;
68: END IF;
69: END IF;
70: END Check_Parent_Existance;

Line 91: Igs_Ge_Msg_Stack.Add;

87: IF upper(column_name) = 'CLOSED_IND' OR
88: column_name is null Then
89: IF new_references.closed_ind <> UPPER(new_references.closed_ind) or new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
90: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
91: Igs_Ge_Msg_Stack.Add;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95:

Line 100: Igs_Ge_Msg_Stack.Add;

96: IF upper(column_name) = 'DESCRIPTION' OR
97: column_name is null Then
98: IF new_references.description <> UPPER(new_references.description) 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) = 'S_ASSESSMENT_TYPE' OR

Line 108: Igs_Ge_Msg_Stack.Add;

104: IF upper(column_name) = 'S_ASSESSMENT_TYPE' OR
105: column_name is null Then
106: IF new_references.s_assessment_type <> UPPER(new_references.s_assessment_type) Then
107: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
108: Igs_Ge_Msg_Stack.Add;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112:

Line 155: Igs_Ge_Msg_Stack.Add;

151: Open cur_rowid;
152: Fetch cur_rowid INTO lv_rowid;
153: IF (cur_rowid%FOUND) THEN
154: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SAT_LOC_FK');
155: Igs_Ge_Msg_Stack.Add;
156: Close cur_rowid;
157: App_Exception.Raise_Exception;
158: Return;
159: END IF;

Line 196: Igs_Ge_Msg_Stack.Add;

192: IF Get_PK_For_Validation (
193: new_references.s_assessment_type
194: ) THEN
195: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
196: Igs_Ge_Msg_Stack.Add;
197: App_Exception.Raise_Exception;
198: END IF;
199:
200: Check_Constraints;

Line 216: Igs_Ge_Msg_Stack.Add;

212: IF Get_PK_For_Validation (
213: new_references.s_assessment_type
214: ) THEN
215: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
216: Igs_Ge_Msg_Stack.Add;
217: App_Exception.Raise_Exception;
218: END IF;
219: Check_Constraints;
220: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 255: Igs_Ge_Msg_Stack.Add;

251: X_LAST_UPDATE_LOGIN := -1;
252: end if;
253: else
254: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
255: Igs_Ge_Msg_Stack.Add;
256: app_exception.raise_exception;
257: end if;
258: Before_DML(
259: p_action=>'INSERT',

Line 319: Igs_Ge_Msg_Stack.Add;

315: open c1;
316: fetch c1 into tlinfo;
317: if (c1%notfound) then
318: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
319: Igs_Ge_Msg_Stack.Add;
320: close c1;
321: app_exception.raise_exception;
322: return;
323: 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 368: Igs_Ge_Msg_Stack.Add;

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