[Home] [Help]
33: OPEN cur_old_ref_values;
34: FETCH cur_old_ref_values INTO old_references;
35:
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;
72: NULL;
73: ELSE
74:
75: IF NOT igs_ge_note_pkg.get_pk_for_validation ( new_references.reference_number )THEN
76: fnd_message.set_name('FND','FORM_RECORD_DELETED');
77: igs_ge_msg_stack.add;
78: app_exception.raise_exception;
79: END IF;
80: END IF;
86:
87: IF NOT igs_tr_note_type_pkg.get_pk_for_validation (
88: new_references.trk_note_type
89: )THEN
90: fnd_message.set_name('FND','FORM_RECORD_DELETED');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94: END IF;
102: IF NOT igs_tr_step_pkg.get_pk_for_validation (
103: new_references.tracking_id,
104: new_references.tracking_step_id
105: )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;
158: OPEN cur_rowid;
159: FETCH cur_rowid INTO lv_rowid;
160: IF (cur_rowid%FOUND) THEN
161: CLOSE cur_rowid;
162: fnd_message.set_name ('IGS', 'IGS_TR_TSN_NOTE_FK');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: RETURN;
166: END IF;
185: FETCH cur_rowid INTO lv_rowid;
186:
187: IF (cur_rowid%FOUND) THEN
188: CLOSE cur_rowid;
189: fnd_message.set_name ('IGS', 'IGS_TR_TSN_TNT_FK');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: RETURN;
193: END IF;
213: OPEN cur_rowid;
214: FETCH cur_rowid INTO lv_rowid;
215: IF (cur_rowid%FOUND) THEN
216: CLOSE cur_rowid;
217: fnd_message.set_name ('IGS', 'IGS_TR_TSN_TRST_FK');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: RETURN;
221: END IF;
237: END IF;
238:
239: IF UPPER(column_name) = 'TRK_NOTE_TYPE' OR column_name IS NULL THEN
240: IF new_references.trk_note_type <> UPPER(new_references.trk_note_type) THEN
241: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: END IF;
245: END IF;
283: new_references.tracking_id,
284: new_references.tracking_step_id,
285: new_references.reference_number
286: )THEN
287: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: END IF;
291: check_constraints;
307: new_references.tracking_id,
308: new_references.tracking_step_id,
309: new_references.reference_number
310: )THEN
311: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
315: check_constraints;
373: IF x_last_update_login IS NULL THEN
374: x_last_update_login := -1;
375: END IF;
376: ELSE
377: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
378: igs_ge_msg_stack.add;
379: app_exception.raise_exception;
380: END IF;
381:
449:
450: OPEN c1;
451: FETCH c1 INTO tlinfo;
452: IF (c1%NOTFOUND) THEN
453: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: CLOSE c1;
457: RETURN;
460:
461: IF ((tlinfo.trk_note_type = x_trk_note_type)) THEN
462: NULL;
463: ELSE
464: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: RETURN;
498: x_last_update_login := -1;
499: END IF;
500:
501: ELSE
502: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506: