APPS.IGS_AS_COURSE_TYPE_PKG dependencies on APP_EXCEPTION

Line 32: APP_EXCEPTION.RAISE_EXCEPTION;

28: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
29: fnd_message.Set_Name ('FND', 'FORM_RECORD_DELETED');
30: IGS_GE_MSG_STACK.ADD;
31: Close cur_old_ref_values;
32: APP_EXCEPTION.RAISE_EXCEPTION;
33:
34: Return;
35: END IF;
36: Close cur_old_ref_values;

Line 71: APP_EXCEPTION.RAISE_EXCEPTION;

67: IF IGS_AS_VAL_ACOT.crsp_val_cty_closed(new_references.course_type,
68: v_message_name) = FALSE THEN
69: FND_MESSAGE.SET_NAME('IGS',v_message_name);
70: IGS_GE_MSG_STACK.ADD;
71: APP_EXCEPTION.RAISE_EXCEPTION;
72: END IF;
73: END IF;
74: END BeforeRowInsert1;
75: -- Trigger description :-

Line 100: APP_EXCEPTION.RAISE_EXCEPTION;

96: v_ass_id,
97: v_message_name) = FALSE THEN
98: FND_MESSAGE.SET_NAME('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;
100: APP_EXCEPTION.RAISE_EXCEPTION;
101: END IF;
102: END IF;
103: END BeforeRowInsertDelete2;
104: PROCEDURE Check_Constraints (

Line 119: APP_EXCEPTION.RAISE_EXCEPTION;

115: column_name is null Then
116: IF new_references.COURSE_TYPE <> UPPER(new_references.COURSE_TYPE) Then
117: fnd_message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
118: IGS_GE_MSG_STACK.ADD;
119: APP_EXCEPTION.RAISE_EXCEPTION;
120: END IF;
121: END IF;
122:
123: END Check_Constraints;

Line 133: APP_EXCEPTION.RAISE_EXCEPTION;

129: ELSIF NOT IGS_AS_ASSESSMNT_ITM_PKG.Get_PK_For_Validation (
130: new_references.ass_id ) THEN
131: FND_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
132: IGS_GE_MSG_STACK.ADD;
133: APP_EXCEPTION.RAISE_EXCEPTION;
134: END IF;
135: IF (((old_references.course_type = new_references.course_type)) OR
136: ((new_references.course_type IS NULL))) THEN
137: NULL;

Line 143: APP_EXCEPTION.RAISE_EXCEPTION;

139: new_references.course_type
140: )THEN
141: FND_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
142: IGS_GE_MSG_STACK.ADD;
143: APP_EXCEPTION.RAISE_EXCEPTION;
144: END IF;
145: END Check_Parent_Existance;
146: FUNCTION Get_PK_For_Validation (
147: x_ass_id IN NUMBER,

Line 183: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 224: APP_EXCEPTION.RAISE_EXCEPTION;

220: NEW_REFERENCES.course_type
221: ) THEN
222: fnd_message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
223: IGS_GE_MSG_STACK.ADD;
224: APP_EXCEPTION.RAISE_EXCEPTION;
225: END IF;
226: Check_Constraints;
227: Check_Parent_Existance;
228: ELSIF (p_action = 'UPDATE') THEN

Line 242: APP_EXCEPTION.RAISE_EXCEPTION;

238: new_references.ass_id ,
239: new_references.course_type) THEN
240: fnd_message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
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:

Line 282: APP_EXCEPTION.RAISE_EXCEPTION;

278: end if;
279: else
280: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
281: IGS_GE_MSG_STACK.ADD;
282: APP_EXCEPTION.RAISE_EXCEPTION;
283: end if;
284: Before_DML(
285: p_action=>'INSERT',
286: x_rowid=>X_ROWID,

Line 340: APP_EXCEPTION.RAISE_EXCEPTION;

336: fetch c1 into tlinfo;
337: if (c1%notfound) then
338: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
339: IGS_GE_MSG_STACK.ADD;
340: APP_EXCEPTION.RAISE_EXCEPTION;
341: close c1;
342: return;
343: end if;
344: close c1;