DBA Data[Home] [Help]

APPS.IGS_PR_UL_MARK_CNFG_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100: END check_uniqueness;
101:
102: PROCEDURE check_parent_existance AS

Line 122: app_exception.raise_exception;

118: new_references.unit_level
119: ) THEN
120: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
121: igs_ge_msg_stack.add;
122: app_exception.raise_exception;
123: END IF;
124:
125: IF (((old_references.course_cd = new_references.course_cd) AND
126: (old_references.version_number = new_references.version_number)) OR

Line 136: app_exception.raise_exception;

132: new_references.version_number
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_parent_existance;
140:

Line 260: app_exception.raise_exception;

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

Line 297: app_exception.raise_exception;

293: IF (cur_rowid%FOUND) THEN
294: CLOSE cur_rowid;
295: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: RETURN;
299: END IF;
300: CLOSE cur_rowid;
301:

Line 356: app_exception.raise_exception;

352: )
353: ) THEN
354: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
355: igs_ge_msg_stack.add;
356: app_exception.raise_exception;
357: END IF;
358: check_uniqueness;
359: check_parent_existance;
360: ELSIF (p_action = 'UPDATE') THEN

Line 375: app_exception.raise_exception;

371: )
372: ) THEN
373: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377: check_uniqueness;
378: ELSIF (p_action = 'VALIDATE_DELETE') THEN
379: check_child_existance;

Line 428: app_exception.raise_exception;

424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_CNFG_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:
431: x_mark_config_id := NULL;
432:

Line 517: app_exception.raise_exception;

513: IF (c1%notfound) THEN
514: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
515: igs_ge_msg_stack.add;
516: CLOSE c1;
517: app_exception.raise_exception;
518: RETURN;
519: END IF;
520: CLOSE c1;
521:

Line 533: app_exception.raise_exception;

529: NULL;
530: ELSE
531: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
532: igs_ge_msg_stack.add;
533: app_exception.raise_exception;
534: END IF;
535:
536: RETURN;
537:

Line 583: app_exception.raise_exception;

579: ELSE
580: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
581: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_CNFG_PKG.UPDATE_ROW');
582: igs_ge_msg_stack.add;
583: app_exception.raise_exception;
584: END IF;
585:
586: before_dml(
587: p_action => 'UPDATE',