DBA Data[Home] [Help]

APPS.IGS_FI_BILL_TRNSCTNS_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 103: app_exception.raise_exception;

99: )
100: ) THEN
101: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: END IF;
105:
106: END check_uniqueness;
107:

Line 130: app_exception.raise_exception;

126: new_references.invoice_creditact_id
127: ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132: END IF;
133: IF (((old_references.bill_id = new_references.bill_id)) OR
134: ((new_references.bill_id IS NULL))) THEN

Line 141: app_exception.raise_exception;

137: new_references.bill_id
138: ) THEN
139: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
140: igs_ge_msg_stack.add;
141: app_exception.raise_exception;
142: END IF;
143:
144: IF (new_references.transaction_type = 'C') THEN
145: IF (((old_references.invoice_creditact_id = new_references.invoice_creditact_id)) OR

Line 153: app_exception.raise_exception;

149: new_references.invoice_creditact_id
150: ) THEN
151: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
152: igs_ge_msg_stack.add;
153: app_exception.raise_exception;
154: END IF;
155: END IF;
156:
157: END check_parent_existance;

Line 259: app_exception.raise_exception;

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

Line 294: app_exception.raise_exception;

290: IF (cur_rowid%FOUND) THEN
291: CLOSE cur_rowid;
292: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TRANS_BILL_FK');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: RETURN;
296: END IF;
297: CLOSE cur_rowid;
298:

Line 329: app_exception.raise_exception;

325: IF (cur_rowid%FOUND) THEN
326: CLOSE cur_rowid;
327: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TRANS_CR_ACT_FK');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: RETURN;
331: END IF;
332: CLOSE cur_rowid;
333:

Line 394: app_exception.raise_exception;

390: )
391: ) THEN
392: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395: END IF;
396: check_uniqueness;
397: check_parent_existance;
398: ELSIF (p_action = 'UPDATE') THEN

Line 410: app_exception.raise_exception;

406: )
407: ) THEN
408: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412: check_uniqueness;
413: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
414: check_uniqueness;

Line 485: app_exception.raise_exception;

481: END IF;
482: ELSE
483: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;
487:
488: SELECT igs_fi_bill_trnsctns_s.NEXTVAL
489: INTO x_transaction_id

Line 607: app_exception.raise_exception;

603: IF (c1%notfound) THEN
604: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
605: igs_ge_msg_stack.add;
606: CLOSE c1;
607: app_exception.raise_exception;
608: RETURN;
609: END IF;
610: CLOSE c1;
611:

Line 626: app_exception.raise_exception;

622: NULL;
623: ELSE
624: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
625: igs_ge_msg_stack.add;
626: app_exception.raise_exception;
627: END IF;
628:
629: RETURN;
630:

Line 682: app_exception.raise_exception;

678: END IF;
679: ELSE
680: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
681: igs_ge_msg_stack.add;
682: app_exception.raise_exception;
683: END IF;
684:
685: before_dml(
686: p_action => 'UPDATE',