APPS.IGS_AS_ITM_EXAM_MTRL_PKG dependencies on APP_EXCEPTION

Line 34: APP_EXCEPTION.RAISE_EXCEPTION;

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;
37: Close cur_old_ref_values;
38: -- Populate New Values.

Line 76: APP_EXCEPTION.RAISE_EXCEPTION;

72: new_references.exam_material_type,
73: v_message_name) = FALSE THEN
74: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
75: IGS_GE_MSG_STACK.ADD;
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: END IF;
78: --
79: -- Can only create against IGS_AS_ASSESSMNT_ITM records which are
80: -- examinations

Line 86: APP_EXCEPTION.RAISE_EXCEPTION;

82: new_references.ass_id,
83: v_message_name) = FALSE THEN
84: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
85: IGS_GE_MSG_STACK.ADD;
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: END IF;
88: END IF;
89: IF p_inserting OR p_updating THEN
90: --

Line 98: APP_EXCEPTION.RAISE_EXCEPTION;

94: new_references.quantity_per_student,
95: v_message_name) = FALSE THEN
96: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
97: IGS_GE_MSG_STACK.ADD;
98: APP_EXCEPTION.RAISE_EXCEPTION;
99: END IF;
100: END IF;
101: END BeforeRowInsertUpdate1;
102:

Line 113: APP_EXCEPTION.RAISE_EXCEPTION;

109: new_references.ass_id
110: )THEN
111: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
112: IGS_GE_MSG_STACK.ADD;
113: APP_EXCEPTION.RAISE_EXCEPTION;
114:
115: END IF;
116: IF (((old_references.exam_material_type = new_references.exam_material_type)) OR
117: ((new_references.exam_material_type IS NULL))) THEN

Line 124: APP_EXCEPTION.RAISE_EXCEPTION;

120: new_references.exam_material_type
121: )THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: APP_EXCEPTION.RAISE_EXCEPTION;
125:
126: END IF;
127: END Check_Parent_Existance;
128: FUNCTION Get_PK_For_Validation ( x_ass_id IN NUMBER,

Line 163: APP_EXCEPTION.RAISE_EXCEPTION;

159: IF (cur_rowid%FOUND) THEN
160: Fnd_Message.Set_Name ('IGS', 'IGS_AS_AIEM_AI_FK');
161: IGS_GE_MSG_STACK.ADD;
162: Close cur_rowid;
163: APP_EXCEPTION.RAISE_EXCEPTION;
164: Return;
165: END IF;
166: Close cur_rowid;
167:

Line 184: APP_EXCEPTION.RAISE_EXCEPTION;

180: IF (cur_rowid%FOUND) THEN
181: Fnd_Message.Set_Name ('IGS', 'IGS_AS_AIEM_EXMT_FK');
182: IGS_GE_MSG_STACK.ADD;
183: Close cur_rowid;
184: APP_EXCEPTION.RAISE_EXCEPTION;
185: Return;
186: END IF;
187: Close cur_rowid;
188: END GET_FK_IGS_AS_EXM_MTRL_TYPE;

Line 227: APP_EXCEPTION.RAISE_EXCEPTION;

223: new_references.ass_id ,
224: new_references.exam_material_type ) THEN
225: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
229: Check_Constraints;
230: Check_Parent_Existance;
231: ELSIF (p_action = 'UPDATE') THEN

Line 242: APP_EXCEPTION.RAISE_EXCEPTION;

238: new_references.ass_id ,
239: new_references.exam_material_type ) THEN
240: Fnd_Message.Set_Name ('IGS', 'IGS_AS_MATERIAL_ALREADY_EXISTS');
241: IGS_GE_MSG_STACK.ADD;
242: APP_EXCEPTION.RAISE_EXCEPTION;
243: END IF;
244: Check_Constraints;
245: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
246: Check_Constraints;

Line 289: APP_EXCEPTION.RAISE_EXCEPTION;

285: end if;
286: else
287: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
288: IGS_GE_MSG_STACK.ADD;
289: APP_EXCEPTION.RAISE_EXCEPTION;
290: end if;
291: Before_DML(
292: p_action=>'INSERT',
293: x_rowid=>X_ROWID,

Line 358: APP_EXCEPTION.RAISE_EXCEPTION;

354: fetch c1 into tlinfo;
355: if (c1%notfound) then
356: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
357: IGS_GE_MSG_STACK.ADD;
358: APP_EXCEPTION.RAISE_EXCEPTION;
359: close c1;
360: return;
361: end if;
362: close c1;

Line 375: APP_EXCEPTION.RAISE_EXCEPTION;

371: null;
372: else
373: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
374: IGS_GE_MSG_STACK.ADD;
375: APP_EXCEPTION.RAISE_EXCEPTION;
376: end if;
377: return;
378: end LOCK_ROW;
379: procedure UPDATE_ROW (

Line 408: APP_EXCEPTION.RAISE_EXCEPTION;

404: end if;
405: else
406: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
407: IGS_GE_MSG_STACK.ADD;
408: APP_EXCEPTION.RAISE_EXCEPTION;
409: end if;
410: Before_DML(
411: p_action=>'UPDATE',
412: x_rowid=>X_ROWID,

Line 508: APP_EXCEPTION.RAISE_EXCEPTION;

504: column_name is null Then
505: IF new_references.EXAM_MATERIAL_TYPE <> UPPER(new_references.EXAM_MATERIAL_TYPE) Then
506: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
507: IGS_GE_MSG_STACK.ADD;
508: APP_EXCEPTION.RAISE_EXCEPTION;
509: END IF;
510: END IF;
511:
512: IF upper(column_name) = 'S_MATERIAL_CAT' OR

Line 517: APP_EXCEPTION.RAISE_EXCEPTION;

513: column_name is null Then
514: IF new_references.S_MATERIAL_CAT NOT IN ( 'ALLOWABLE' , 'NON-ALLOW' , 'SUPPLIED' ) then
515: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
516: IGS_GE_MSG_STACK.ADD;
517: APP_EXCEPTION.RAISE_EXCEPTION;
518: END IF;
519: END IF;
520:
521: