DBA Data[Home] [Help]

APPS.IGS_CO_LTR_PARM_TYPE_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 101: app_exception.raise_exception;

97: IF (UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL) THEN
98: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
99: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103: END IF;
104:
105: END check_constraints;

Line 128: app_exception.raise_exception;

124: new_references.s_letter_parameter_type
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: END check_parent_existance;
132:

Line 219: app_exception.raise_exception;

215: IF (cur_rowid%FOUND) THEN
216: CLOSE cur_rowid;
217: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: RETURN;
221: END IF;
222: CLOSE cur_rowid;
223:

Line 276: app_exception.raise_exception;

272: )
273: ) THEN
274: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
275: igs_ge_msg_stack.add;
276: app_exception.raise_exception;
277: END IF;
278: check_constraints;
279: check_parent_existance;
280: ELSIF (p_action = 'UPDATE') THEN

Line 295: app_exception.raise_exception;

291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: check_constraints;
298: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
299: check_constraints;

Line 352: app_exception.raise_exception;

348: END IF;
349: ELSE
350: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354:
355: before_dml(
356: p_action => 'INSERT',

Line 442: app_exception.raise_exception;

438: IF (c1%notfound) THEN
439: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
440: igs_ge_msg_stack.add;
441: CLOSE c1;
442: app_exception.raise_exception;
443: RETURN;
444: END IF;
445: CLOSE c1;
446:

Line 457: app_exception.raise_exception;

453: NULL;
454: ELSE
455: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
456: igs_ge_msg_stack.add;
457: app_exception.raise_exception;
458: END IF;
459:
460: RETURN;
461:

Line 505: app_exception.raise_exception;

501: END IF;
502: ELSE
503: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
504: igs_ge_msg_stack.add;
505: app_exception.raise_exception;
506: END IF;
507:
508: before_dml(
509: p_action => 'UPDATE',