APPS.IGS_PS_UNIT_INT_LVL_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

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: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;

Line 147: IGS_GE_MSG_STACK.ADD;

143:
144: IF Upper(Column_Name)='WEFTSU_FACTOR' OR Column_Name IS NULL Then
145: IF New_References.weftsu_factor < 0 AND New_References.weftsu_factor > 1.80 Then
146: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151:

Line 155: IGS_GE_MSG_STACK.ADD;

151:
152: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then
153: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
159:

Line 164: IGS_GE_MSG_STACK.ADD;

160:
161: IF Upper(Column_Name)='UNIT_INT_COURSE_LEVEL_CD' OR Column_Name IS NULL Then
162: IF New_References.Unit_Int_Course_Level_Cd <> UPPER(New_References.Unit_Int_Course_Level_Cd) Then
163: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: END IF;
167: END IF;
168:

Line 244: IGS_GE_MSG_STACK.ADD;

240: -- Call all the procedures related to Before Insert.
241: BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE );
242: IF Get_PK_For_Validation (New_References.unit_int_course_level_cd) THEN
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: Check_Constraints;
248: ELSIF (p_action = 'UPDATE') THEN

Line 259: IGS_GE_MSG_STACK.ADD;

255: Check_Child_Existance;
256: ELSIF (p_action = 'VALIDATE_INSERT') THEN
257: IF Get_PK_For_Validation (New_References.unit_int_course_level_cd) THEN
258: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262: Check_Constraints;
263: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 311: IGS_GE_MSG_STACK.ADD;

307: X_LAST_UPDATE_LOGIN := -1;
308: end if;
309: else
310: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
311: IGS_GE_MSG_STACK.ADD;
312: app_exception.raise_exception;
313: end if;
314:
315: Before_DML(

Line 387: IGS_GE_MSG_STACK.ADD;

383: fetch c1 into tlinfo;
384: if (c1%notfound) then
385: close c1;
386: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
387: IGS_GE_MSG_STACK.ADD;
388: app_exception.raise_exception;
389: return;
390: end if;
391: close c1;

Line 400: IGS_GE_MSG_STACK.ADD;

396: ) then
397: null;
398: else
399: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
400: IGS_GE_MSG_STACK.ADD;
401: app_exception.raise_exception;
402: end if;
403: return;
404: end LOCK_ROW;

Line 433: IGS_GE_MSG_STACK.ADD;

429: X_LAST_UPDATE_LOGIN := -1;
430: end if;
431: else
432: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
433: IGS_GE_MSG_STACK.ADD;
434: app_exception.raise_exception;
435: end if;
436:
437: Before_DML(