APPS.IGS_TR_ITEM_NOTE_PKG dependencies on IGS_GE_MSG_STACK

Line 37: igs_ge_msg_stack.add;

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;
41: CLOSE cur_old_ref_values;

Line 91: igs_ge_msg_stack.add;

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 ;
95:

Line 107: igs_ge_msg_stack.add;

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;
111:

Line 118: igs_ge_msg_stack.add;

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;
122:

Line 129: igs_ge_msg_stack.add;

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;
133:

Line 182: igs_ge_msg_stack.add;

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;
186: CLOSE cur_rowid;

Line 208: igs_ge_msg_stack.add;

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;
212: CLOSE cur_rowid;

Line 234: igs_ge_msg_stack.add;

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;
238: CLOSE cur_rowid;

Line 276: igs_ge_msg_stack.add;

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;
280: check_parent_existance;

Line 293: igs_ge_msg_stack.add;

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;
297: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 351: igs_ge_msg_stack.add;

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:
355: before_dml(

Line 425: igs_ge_msg_stack.add;

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;
429: CLOSE c1;

Line 435: igs_ge_msg_stack.add;

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;
439:

Line 472: igs_ge_msg_stack.add;

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:
476: before_dml(