DBA Data[Home] [Help]

APPS.IGS_FI_OTC_CHARGES_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 91: app_exception.raise_exception;

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

Line 117: app_exception.raise_exception;

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

Line 128: app_exception.raise_exception;

124: new_references.invoice_id
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 233: app_exception.raise_exception;

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

Line 268: app_exception.raise_exception;

264: IF (cur_rowid%FOUND) THEN
265: CLOSE cur_rowid;
266: fnd_message.set_name ('IGS', 'IGS_FI_OTCH_INVI_FK');
267: igs_ge_msg_stack.add;
268: app_exception.raise_exception;
269: RETURN;
270: END IF;
271: CLOSE cur_rowid;
272:

Line 321: app_exception.raise_exception;

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

Line 337: app_exception.raise_exception;

333: )
334: ) THEN
335: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339: check_uniqueness;
340: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
341: check_uniqueness;

Line 390: app_exception.raise_exception;

386: END IF;
387: ELSE
388: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392:
393: SELECT igs_fi_otc_charges_s.NEXTVAL
394: INTO x_otc_charge_id

Line 474: app_exception.raise_exception;

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

Line 487: app_exception.raise_exception;

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

Line 533: app_exception.raise_exception;

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