[Home] [Help]
33: -- Populate Old Values.
34: OPEN cur_old_ref_values;
35: FETCH cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
37: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
38: igs_ge_msg_stack.add;
39: app_exception.raise_exception;
40: CLOSE cur_old_ref_values;
41: RETURN;
70: ELSE
71: IF NOT igs_ge_note_pkg.get_pk_for_validation (
72: new_references.reference_number
73: )THEN
74: fnd_message.set_name('FND','FORM_RECORD_DELETED');
75: igs_ge_msg_stack.add;
76: app_exception.raise_exception;
77: END IF;
78: END IF;
83: ELSE
84: IF NOT igs_tr_note_type_pkg.get_pk_for_validation (
85: new_references.trk_note_type
86: )THEN
87: fnd_message.set_name('FND','FORM_RECORD_DELETED');
88: igs_ge_msg_stack.add;
89: app_exception.raise_exception;
90: END IF;
91: END IF;
99: IF NOT igs_tr_type_step_pkg.get_pk_for_validation (
100: new_references.tracking_type,
101: new_references.tracking_type_step_id
102: )THEN
103: fnd_message.set_name('FND','FORM_RECORD_DELETED');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107: END IF;
159: OPEN cur_rowid;
160: FETCH cur_rowid INTO lv_rowid;
161: IF (cur_rowid%FOUND) THEN
162: CLOSE cur_rowid;
163: fnd_message.set_name ('IGS', 'IGS_TR_TTSN_NOTE_FK');
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: RETURN;
167: END IF;
185: OPEN cur_rowid;
186: FETCH cur_rowid INTO lv_rowid;
187: IF (cur_rowid%FOUND) THEN
188: CLOSE cur_rowid;
189: fnd_message.set_name ('IGS', 'IGS_TR_TTSN_TNT_FK');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: RETURN;
193: END IF;
217: OPEN cur_rowid;
218: FETCH cur_rowid INTO lv_rowid;
219: IF (cur_rowid%FOUND) THEN
220: CLOSE cur_rowid;
221: fnd_message.set_name ('IGS', 'IGS_TR_TTSN_TTS_FK');
222: igs_ge_msg_stack.add;
223: app_exception.raise_exception;
224: RETURN;
225: END IF;
242: END IF;
243:
244: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN
245: IF new_references.tracking_type <> UPPER(new_references.tracking_type) THEN
246: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
250: END IF;
250: END IF;
251:
252: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
253: IF new_references.trk_note_type <> UPPER(new_references.trk_note_type) THEN
254: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258: END IF;
300: new_references.tracking_type_step_id,
301: new_references.reference_number ,
302: new_references.org_id
303: )THEN
304: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308:
325: new_references.tracking_type_step_id,
326: new_references.reference_number,
327: new_references.org_id
328: )THEN
329: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: check_constraints;
387: IF x_last_update_login IS NULL THEN
388: x_last_update_login := -1;
389: END IF;
390: ELSE
391: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395:
465: BEGIN
466: OPEN c1;
467: FETCH c1 INTO tlinfo;
468: IF (c1%NOTFOUND) THEN
469: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: CLOSE c1;
473: RETURN;
476:
477: IF ( (tlinfo.trk_note_type = x_trk_note_type)) THEN
478: NULL;
479: ELSE
480: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
481: igs_ge_msg_stack.add;
482: app_exception.raise_exception;
483: END IF;
484: RETURN;
516: x_last_update_login := -1;
517: END IF;
518:
519: ELSE
520: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
521: igs_ge_msg_stack.add;
522: app_exception.raise_exception;
523: END IF;
524: