DBA Data[Home] [Help]

APPS.IGS_AS_DOC_DLVY_FEE_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 92: app_exception.raise_exception;

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

Line 118: app_exception.raise_exception;

114: new_references.delivery_method_type
115: ) THEN
116: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception;
119: END IF;
120:
121: IF (((old_references.fee_type = new_references.fee_type)) OR
122: ((new_references.fee_type IS NULL))) THEN

Line 129: app_exception.raise_exception;

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

Line 232: app_exception.raise_exception;

228: IF (cur_rowid%FOUND) THEN
229: CLOSE cur_rowid;
230: fnd_message.set_name ('IGS', 'IGS_AS_DFEE_TDELY_FK');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: RETURN;
234: END IF;
235: CLOSE cur_rowid;
236:

Line 287: app_exception.raise_exception;

283: )
284: ) THEN
285: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
286: igs_ge_msg_stack.add;
287: app_exception.raise_exception;
288: END IF;
289: check_uniqueness;
290: check_parent_existance;
291: ELSIF (p_action = 'UPDATE') THEN

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: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
307: check_uniqueness;

Line 357: app_exception.raise_exception;

353: END IF;
354: ELSE
355: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: SELECT igs_as_doc_dlvy_fee_s.NEXTVAL
361: INTO x_dfee_id

Line 446: app_exception.raise_exception;

442: IF (c1%notfound) THEN
443: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
444: igs_ge_msg_stack.add;
445: CLOSE c1;
446: app_exception.raise_exception;
447: RETURN;
448: END IF;
449: CLOSE c1;
450:

Line 460: app_exception.raise_exception;

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

Line 507: app_exception.raise_exception;

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