[Home] [Help]
32: OPEN cur_old_ref_values;
33: FETCH cur_old_ref_values INTO old_references;
34: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
35: CLOSE cur_old_ref_values;
36: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
37: igs_ge_msg_stack.add;
38: app_exception.raise_exception;
39: RETURN;
40: END IF;
86: END IF ;
87:
88: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
89: IF new_references.trk_note_type <> UPPER(new_references.trk_note_type) THEN
90: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception ;
93: END IF;
94: END IF ;
102: ((new_references.reference_number IS NULL))) THEN
103: NULL;
104: ELSE
105: IF NOT igs_ge_note_pkg.get_pk_for_validation (new_references.reference_number) THEN
106: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: END IF;
110: END IF;
113: ((new_references.trk_note_type IS NULL))) THEN
114: NULL;
115: ELSE
116: IF NOT igs_tr_note_type_pkg.get_pk_for_validation (new_references.trk_note_type) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121: END IF;
124: ((new_references.tracking_id IS NULL))) THEN
125: NULL;
126: ELSE
127: IF NOT igs_tr_item_pkg.get_pk_for_validation ( new_references.tracking_id ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132: END IF;
177: OPEN cur_rowid;
178: FETCH cur_rowid INTO lv_rowid;
179: IF (cur_rowid%FOUND) THEN
180: CLOSE cur_rowid;
181: fnd_message.set_name ('IGS', 'IGS_TR_TIN_NOTE_FK');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: RETURN;
185: END IF;
203: OPEN cur_rowid;
204: FETCH cur_rowid INTO lv_rowid;
205: IF (cur_rowid%FOUND) THEN
206: CLOSE cur_rowid;
207: fnd_message.set_name ('IGS', 'IGS_TR_TIN_TNT_FK');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: RETURN;
211: END IF;
229: OPEN cur_rowid;
230: FETCH cur_rowid INTO lv_rowid;
231: IF (cur_rowid%FOUND) THEN
232: CLOSE cur_rowid;
233: fnd_message.set_name ('IGS', 'IGS_TR_TIN_TRI_FK');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: RETURN;
237: END IF;
271: IF get_pk_for_validation (
272: new_references.tracking_id,
273: new_references.reference_number
274: ) THEN
275: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: END IF;
279: check_constraints;
288: IF get_pk_for_validation (
289: new_references.tracking_id,
290: new_references.reference_number
291: ) THEN
292: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: check_constraints;
346: IF x_last_update_login IS NULL THEN
347: x_last_update_login := -1;
348: END IF;
349: ELSE
350: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354:
420: OPEN c1;
421: FETCH c1 INTO tlinfo;
422: IF (c1%NOTFOUND) THEN
423: CLOSE c1;
424: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
425: igs_ge_msg_stack.add;
426: app_exception.raise_exception;
427: RETURN;
428: END IF;
430:
431: IF ( (tlinfo.trk_note_type = x_trk_note_type)) THEN
432: NULL;
433: ELSE
434: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438: RETURN;
467: IF x_last_update_login IS NULL THEN
468: x_last_update_login := -1;
469: END IF;
470: ELSE
471: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
472: igs_ge_msg_stack.add;
473: app_exception.raise_exception;
474: END IF;
475: