APPS.IGS_TR_GROUP_NOTE_PKG dependencies on IGS_GE_MSG_STACK

Line 38: igs_ge_msg_stack.add;

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

Line 80: igs_ge_msg_stack.add;

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

Line 97: igs_ge_msg_stack.add;

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

Line 109: igs_ge_msg_stack.add;

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

Line 120: igs_ge_msg_stack.add;

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

Line 175: igs_ge_msg_stack.add;

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

Line 201: igs_ge_msg_stack.add;

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

Line 227: igs_ge_msg_stack.add;

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

Line 265: igs_ge_msg_stack.add;

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

Line 278: igs_ge_msg_stack.add;

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

Line 336: igs_ge_msg_stack.add;

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:
340: before_dml(p_action =>'INSERT',

Line 409: igs_ge_msg_stack.add;

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

Line 419: igs_ge_msg_stack.add;

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

Line 458: igs_ge_msg_stack.add;

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',
462: x_rowid =>x_rowid,