[Home] [Help]
33: FETCH cur_old_ref_values INTO old_references;
34:
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
36: CLOSE cur_old_ref_values;
37: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
38: igs_ge_msg_stack.add;
39: app_exception.raise_exception;
40: RETURN;
41: END IF;
75: END IF ;
76:
77: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
78: IF new_references.trk_note_type<> UPPER(new_references.trk_note_type) THEN
79: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
80: igs_ge_msg_stack.add;
81: app_exception.raise_exception ;
82: END IF;
83: END IF ;
92: NULL;
93:
94: ELSE
95: IF NOT igs_ge_note_pkg.get_pk_for_validation ( new_references.reference_number ) THEN
96: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100: END IF;
104: NULL;
105:
106: ELSE
107: IF NOT igs_tr_group_pkg.get_pk_for_validation ( new_references.tracking_group_id ) THEN
108: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112: END IF;
115: ((new_references.trk_note_type IS NULL))) THEN
116: NULL;
117: ELSE
118: IF NOT igs_tr_note_type_pkg.get_pk_for_validation ( new_references.trk_note_type ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123: END IF;
170: OPEN cur_rowid;
171: FETCH cur_rowid INTO lv_rowid;
172: IF (cur_rowid%FOUND) THEN
173: CLOSE cur_rowid;
174: fnd_message.set_name ('IGS', 'IGS_TR_TGN_NOTE_FK');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: RETURN;
178: END IF;
196: OPEN cur_rowid;
197: FETCH cur_rowid INTO lv_rowid;
198: IF (cur_rowid%FOUND) THEN
199: CLOSE cur_rowid;
200: fnd_message.set_name ('IGS', 'IGS_TR_TGN_TG_FK');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: RETURN;
204: END IF;
222: OPEN cur_rowid;
223: FETCH cur_rowid INTO lv_rowid;
224: IF (cur_rowid%FOUND) THEN
225: CLOSE cur_rowid;
226: fnd_message.set_name ('IGS', 'IGS_TR_TGN_TNT_FK');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: RETURN;
230: END IF;
260: );
261:
262: IF (p_action = 'INSERT') THEN
263: IF get_pk_for_validation ( new_references.tracking_group_id, new_references.reference_number) THEN
264: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268: check_constraints;
273: check_parent_existance;
274:
275: ELSIF (p_action = 'VALIDATE_INSERT') THEN
276: IF get_pk_for_validation ( new_references.tracking_group_id, new_references.reference_number) THEN
277: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: END IF;
281: check_constraints;
331: IF x_last_update_login IS NULL THEN
332: x_last_update_login := -1;
333: END IF;
334: ELSE
335: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339:
404: OPEN c1;
405: FETCH c1 INTO tlinfo;
406: IF (c1%NOTFOUND) THEN
407: CLOSE c1;
408: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: RETURN;
412: END IF;
414:
415: IF ( (tlinfo.trk_note_type = x_trk_note_type)) THEN
416: NULL;
417: ELSE
418: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
419: igs_ge_msg_stack.add;
420: app_exception.raise_exception;
421: END IF;
422: RETURN;
453: x_last_update_login := -1;
454: END IF;
455:
456: ELSE
457: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception;
460: END IF;
461: before_dml(p_action =>'UPDATE',