[Home] [Help]
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: Close cur_old_ref_values;
39: App_Exception.Raise_Exception;
40:
41: Return;
42: END IF;
43: Close cur_old_ref_values;
70: new_references.course_cd
71: )THEN
72: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75:
76: END IF;
77:
78: END IF;
91: new_references.spo_sequence_number
92: )THEN
93: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96:
97: END IF;
98:
99: END IF;
149: IF (cur_rowid%FOUND) THEN
150: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPC_CRS_FK');
151: IGS_GE_MSG_STACK.ADD;
152: Close cur_rowid;
153: App_Exception.Raise_Exception;
154:
155: Return;
156: END IF;
157: Close cur_rowid;
179: IF (cur_rowid%FOUND) THEN
180: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SPC_SPO_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;
226: new_references.spo_sequence_number,
227: new_references.course_cd)THEN
228: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: END IF;
232: CHECK_CONSTRAINTS;
233:
234: ELSIF (p_action = 'UPDATE') THEN
242: new_references.spo_sequence_number,
243: new_references.course_cd)THEN
244: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: END IF;
248: CHECK_CONSTRAINTS;
249:
250: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
286: end if;
287: else
288: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
289: IGS_GE_MSG_STACK.ADD;
290: app_exception.raise_exception;
291: end if;
292: Before_DML (
293: p_action => 'INSERT',
294: x_rowid => x_rowid ,
344: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
345: fnd_message.set_token ('ERR_CD', SQLCODE);
346: igs_ge_msg_stack.add;
347: igs_sc_gen_001.unset_ctx('R');
348: app_exception.raise_exception;
349: ELSE
350: igs_sc_gen_001.unset_ctx('R');
351: RAISE;
352: END IF;
376: if (c1%notfound) then
377: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
378: IGS_GE_MSG_STACK.ADD;
379: close c1;
380: app_exception.raise_exception;
381:
382: return;
383: end if;
384: close c1;
394: null;
395: else
396: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
397: IGS_GE_MSG_STACK.ADD;
398: app_exception.raise_exception;
399: end if;
400: return;
401:
402: end LOCK_ROW;
421: if (sql%notfound) then
422: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: end if;
427: IF (x_mode = 'S') THEN
428: igs_sc_gen_001.unset_ctx('R');
429: END IF;
449: IF upper(Column_name) = 'SPO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
450: IF new_references.SPO_SEQUENCE_NUMBER < 1 or new_references.SPO_SEQUENCE_NUMBER > 999999 then
451: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception ;
454: END IF;
455: END IF ;
456:
457: IF upper(Column_name) = 'SPO_COURSE_CD' OR COLUMN_NAME IS NULL THEN
457: IF upper(Column_name) = 'SPO_COURSE_CD' OR COLUMN_NAME IS NULL THEN
458: IF new_references.SPO_COURSE_CD<> upper(new_references.SPO_COURSE_CD) then
459: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
460: IGS_GE_MSG_STACK.ADD;
461: App_Exception.Raise_Exception ;
462: END IF;
463: END IF;
464: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
465: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
464: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
465: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
466: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
467: IGS_GE_MSG_STACK.ADD;
468: App_Exception.Raise_Exception ;
469: END IF;
470:
471: END IF ;
472: