APPS.IGS_PR_ORG_STAT_REF_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;
52:

Line 97: app_exception.raise_exception;

93: new_references.stat_type
94: ) THEN
95: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
96: igs_ge_msg_stack.add;
97: app_exception.raise_exception;
98: END IF;
99:
100: END check_parent_existance;
101:

Line 171: app_exception.raise_exception;

167: IF (cur_rowid%FOUND) THEN
168: CLOSE cur_rowid;
169: fnd_message.set_name ('IGS', 'IGS_PR_ORSTR_ORST_FK');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: RETURN;
173: END IF;
174: CLOSE cur_rowid;
175:

Line 228: app_exception.raise_exception;

224: )
225: ) THEN
226: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: END IF;
230: check_parent_existance;
231: ELSIF (p_action = 'UPDATE') THEN
232: -- Call all the procedures related to Before Update.

Line 244: app_exception.raise_exception;

240: )
241: ) THEN
242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: END IF;
246: END IF;
247:
248: END before_dml;

Line 303: app_exception.raise_exception;

299: END IF;
300: ELSE
301: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:
306: before_dml(
307: p_action => 'INSERT',

Line 331: app_exception.raise_exception;

327: fnd_message.set_name ('IGS', 'IGS_PR_INCLUDE_OR_EXCLUDE');
328: fnd_message.set_token('Include_or_Exclude1',x_include_or_exclude);
329: fnd_message.set_token('Include_or_Exclude2',l_include_or_exclude);
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: END LOOP;
334: INSERT INTO igs_pr_org_stat_ref (
335: stat_type,

Line 400: app_exception.raise_exception;

396: IF (c1%notfound) THEN
397: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
398: igs_ge_msg_stack.add;
399: CLOSE c1;
400: app_exception.raise_exception;
401: RETURN;
402: END IF;
403: CLOSE c1;
404:

Line 412: app_exception.raise_exception;

408: NULL;
409: ELSE
410: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414:
415: RETURN;
416:

Line 459: app_exception.raise_exception;

455: END IF;
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:
462: before_dml(
463: p_action => 'UPDATE',