DBA Data[Home] [Help]

APPS.IGR_I_E_ORGUNITS_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 93: app_exception.raise_exception;

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

Line 139: app_exception.raise_exception;

135: new_references.party_id
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
142: IF (((old_references.inquiry_type_id = new_references.inquiry_type_id)) OR
143: ((new_references.inquiry_type_id IS NULL))) THEN

Line 150: app_exception.raise_exception;

146: new_references.inquiry_type_id
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: END check_parent_existance;
154:

Line 259: app_exception.raise_exception;

255: IF (cur_rowid%FOUND) THEN
256: CLOSE cur_rowid;
257: fnd_message.set_name ('IGS', 'IGS_AD_AIEOU_AIEST_FK');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: RETURN;
261: END IF;
262: CLOSE cur_rowid;
263:

Line 314: app_exception.raise_exception;

310: )
311: ) THEN
312: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
313: igs_ge_msg_stack.add;
314: app_exception.raise_exception;
315: END IF;
316: check_uniqueness;
317: check_parent_existance;
318: ELSIF (p_action = 'UPDATE') THEN

Line 330: app_exception.raise_exception;

326: )
327: ) THEN
328: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: END IF;
332: check_uniqueness;
333: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
334: check_uniqueness;

Line 384: app_exception.raise_exception;

380: END IF;
381: ELSE
382: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386:
387: X_ENT_ORG_UNIT_ID := -1;
388: before_dml(

Line 470: app_exception.raise_exception;

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

Line 484: app_exception.raise_exception;

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

Line 531: app_exception.raise_exception;

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