DBA Data[Home] [Help]

APPS.IGS_AD_SCHL_APLY_TO_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 95: app_exception.raise_exception;

91: )
92: ) THEN
93: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: END check_uniqueness;
99:

Line 121: app_exception.raise_exception;

117: new_references.org_unit_cd
118: ) 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:
124: END check_parent_existance;
125:

Line 245: app_exception.raise_exception;

241: IF (cur_rowid%FOUND) THEN
242: CLOSE cur_rowid;
243: fnd_message.set_name ('IGS', 'IGS_AD_ASAT_OR_FK');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: RETURN;
247: END IF;
248: CLOSE cur_rowid;
249:

Line 303: app_exception.raise_exception;

299: )
300: ) THEN
301: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305: check_uniqueness;
306: check_parent_existance;
307: ELSIF (p_action = 'UPDATE') THEN

Line 322: app_exception.raise_exception;

318: )
319: ) THEN
320: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324: check_uniqueness;
325: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
326: check_uniqueness;

Line 380: app_exception.raise_exception;

376: END IF;
377: ELSE
378: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
379: igs_ge_msg_stack.add;
380: app_exception.raise_exception;
381: END IF;
382:
383: x_sch_apl_to_id := -1;
384: before_dml(

Line 471: app_exception.raise_exception;

467: IF (c1%notfound) THEN
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: igs_ge_msg_stack.add;
470: CLOSE c1;
471: app_exception.raise_exception;
472: RETURN;
473: END IF;
474: CLOSE c1;
475:

Line 486: app_exception.raise_exception;

482: NULL;
483: ELSE
484: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
485: igs_ge_msg_stack.add;
486: app_exception.raise_exception;
487: END IF;
488:
489: RETURN;
490:

Line 534: app_exception.raise_exception;

530: END IF;
531: ELSE
532: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
533: igs_ge_msg_stack.add;
534: app_exception.raise_exception;
535: END IF;
536:
537: before_dml(
538: p_action => 'UPDATE',