DBA Data[Home] [Help]

APPS.IGS_TR_GROUP_MEMBER_PKG dependencies on APP_EXCEPTION

Line 37: app_exception.raise_exception;

33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
34: CLOSE cur_old_ref_values;
35: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
36: igs_ge_msg_stack.add;
37: app_exception.raise_exception;
38: RETURN;
39: END IF;
40: CLOSE cur_old_ref_values;
41:

Line 71: app_exception.raise_exception;

67: ELSE
68: IF NOT igs_tr_group_pkg.get_pk_for_validation ( new_references.tracking_group_id ) THEN
69: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
70: igs_ge_msg_stack.add;
71: app_exception.raise_exception;
72: END IF;
73: END IF;
74:
75: IF (((old_references.tracking_id = new_references.tracking_id)) OR

Line 83: app_exception.raise_exception;

79:
80: IF NOT igs_tr_item_pkg.get_pk_for_validation ( new_references.tracking_id ) THEN
81: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
82: igs_ge_msg_stack.add;
83: app_exception.raise_exception;
84: END IF;
85: END IF;
86:
87: END check_parent_existance;

Line 137: app_exception.raise_exception;

133: IF (cur_rowid%FOUND) THEN
134: CLOSE cur_rowid;
135: fnd_message.set_name ('IGS', 'IGS_TR_TGM_TG_FK');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: RETURN;
139: END IF;
140: CLOSE cur_rowid;
141:

Line 163: app_exception.raise_exception;

159: IF (cur_rowid%FOUND) THEN
160: CLOSE cur_rowid;
161: fnd_message.set_name ('IGS', 'IGS_TR_TGM_TRI_FK');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: RETURN;
165: END IF;
166: CLOSE cur_rowid;
167:

Line 202: app_exception.raise_exception;

198: new_references.tracking_id
199: ) THEN
200: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: END IF;
204: check_parent_existance;
205:
206: ELSIF (p_action = 'UPDATE') THEN

Line 216: app_exception.raise_exception;

212: new_references.tracking_id
213: ) THEN
214: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218: END IF;
219:
220: END before_dml;

Line 271: app_exception.raise_exception;

267:
268: ELSE
269: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
270: igs_ge_msg_stack.add;
271: app_exception.raise_exception;
272: END IF;
273:
274: before_dml(p_action =>'INSERT',
275: x_rowid =>x_rowid,

Line 340: app_exception.raise_exception;

336: IF (c1%NOTFOUND) THEN
337: CLOSE c1;
338: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
339: igs_ge_msg_stack.add;
340: app_exception.raise_exception;
341: RETURN;
342: END IF;
343: CLOSE c1;
344: