DBA Data[Home] [Help]

APPS.IGS_FI_LB_FCIS_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 106: app_exception.raise_exception;

102: CLOSE cur_fci_desc;
103: fnd_message.set_name ('IGS', 'IGS_FI_LB_FCI_EXISTS');
104: fnd_message.set_token( 'FCI_DESC', l_v_cal_desc );
105: igs_ge_msg_stack.add;
106: app_exception.raise_exception;
107: END IF;
108:
109: END check_uniqueness;
110:

Line 132: app_exception.raise_exception;

128: new_references.lockbox_name
129: ) THEN
130: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: END IF;
134:
135: IF (((old_references.fee_cal_type = new_references.fee_cal_type) AND
136: (old_references.fee_ci_sequence_number = new_references.fee_ci_sequence_number)) OR

Line 146: app_exception.raise_exception;

142: new_references.fee_ci_sequence_number
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: END IF;
148:
149: END check_parent_existance;
150:

Line 258: app_exception.raise_exception;

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

Line 315: app_exception.raise_exception;

311: ) THEN
312: fnd_message.set_name('IGS','IGS_FI_LB_FCI_BANK_CD_EXISTS');
313: fnd_message.set_token('BANK_CD', new_references.bank_cd);
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: END IF;
317: check_uniqueness;
318: check_parent_existance;
319: ELSIF (p_action = 'UPDATE') THEN

Line 333: app_exception.raise_exception;

329: ) THEN
330: fnd_message.set_name('IGS','IGS_FI_LB_FCI_BANK_CD_EXISTS');
331: fnd_message.set_token('BANK_CD', new_references.bank_cd);
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335: check_uniqueness;
336: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
337: check_uniqueness;

Line 386: app_exception.raise_exception;

382: ELSE
383: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
384: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_FCIS_PKG.INSERT_ROW');
385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388:
389: before_dml(
390: p_action => 'INSERT',

Line 462: app_exception.raise_exception;

458: IF (c1%notfound) THEN
459: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
460: igs_ge_msg_stack.add;
461: CLOSE c1;
462: app_exception.raise_exception;
463: RETURN;
464: END IF;
465: CLOSE c1;
466:

Line 475: app_exception.raise_exception;

471: NULL;
472: ELSE
473: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: END IF;
477:
478: RETURN;
479:

Line 523: app_exception.raise_exception;

519: ELSE
520: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
521: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_FCIS_PKG.UPDATE_ROW');
522: igs_ge_msg_stack.add;
523: app_exception.raise_exception;
524: END IF;
525:
526: before_dml(
527: p_action => 'UPDATE',