APPS.IGS_FI_IMP_CHGS_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 100: app_exception.raise_exception;

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

Line 132: app_exception.raise_exception;

128: new_references.fee_ci_sequence_number
129: ) THEN
130: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
134: new_references.person_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 138: app_exception.raise_exception;

134: new_references.person_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: ELSIF NOT Igs_lookups_view_Pkg.Get_PK_For_Validation (
140: 'TRANSACTION_TYPE',
141: new_references.transaction_type
142: ) THEN

Line 145: App_Exception.Raise_Exception;

141: new_references.transaction_type
142: ) THEN
143: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147:
148: END check_parent_existance;
149:

Line 267: App_Exception.Raise_Exception;

263: IF (cur_rowid%FOUND) THEN
264: Close cur_rowid;
265: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FIMP_LKUPV_FK');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: Return;
269: END IF;
270: Close cur_rowid;
271:

Line 293: App_Exception.Raise_Exception;

289: IF (cur_rowid%FOUND) THEN
290: Close cur_rowid;
291: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FIMP_PE_FK');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: Return;
295: END IF;
296: Close cur_rowid;
297:

Line 352: app_exception.raise_exception;

348: )
349: ) THEN
350: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354: check_uniqueness;
355: check_parent_existance;
356: ELSIF (p_action = 'UPDATE') THEN

Line 371: app_exception.raise_exception;

367: )
368: ) THEN
369: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: check_uniqueness;
374: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
375: check_uniqueness;

Line 445: app_exception.raise_exception;

441: END IF;
442: ELSE
443: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447:
448: SELECT IGS_FI_IMP_CHGS_S.NEXTVAL INTO x_import_charges_id FROM DUAL;
449: new_references.org_id := IGS_GE_GEN_003.Get_Org_Id;

Line 555: app_exception.raise_exception;

551: IF (c1%notfound) THEN
552: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
553: igs_ge_msg_stack.add;
554: CLOSE c1;
555: app_exception.raise_exception;
556: RETURN;
557: END IF;
558: CLOSE c1;
559:

Line 571: app_exception.raise_exception;

567: NULL;
568: ELSE
569: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:
574: l_rowid := NULL;
575: RETURN;

Line 625: app_exception.raise_exception;

621: END IF;
622: ELSE
623: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
624: igs_ge_msg_stack.add;
625: app_exception.raise_exception;
626: END IF;
627:
628: before_dml(
629: p_action => 'UPDATE',