DBA Data[Home] [Help]

APPS.IGS_FI_ANC_INT_PKG dependencies on APP_EXCEPTION

Line 93: app_exception.raise_exception;

89: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
90: CLOSE cur_old_ref_values;
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: RETURN;
95: END IF;
96: CLOSE cur_old_ref_values;
97:

Line 190: app_exception.raise_exception;

186: new_references.fee_ci_sequence_number
187: ) THEN
188: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
189: igs_ge_msg_stack.add;
190: app_exception.raise_exception;
191: ELSIF NOT Igs_lookups_view_Pkg.Get_PK_For_Validation (
192: 'STATUS',
193: new_references.status
194: ) THEN

Line 197: App_Exception.Raise_Exception;

193: new_references.status
194: ) THEN
195: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199:
200: END check_parent_existance;
201:

Line 268: app_exception.raise_exception;

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

Line 295: App_Exception.Raise_Exception;

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

Line 440: app_exception.raise_exception;

436: )
437: ) THEN
438: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442: check_parent_existance;
443: ELSIF (p_action = 'UPDATE') THEN
444: -- Call all the procedures related to Before Update.

Line 454: app_exception.raise_exception;

450: )
451: ) THEN
452: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
453: igs_ge_msg_stack.add;
454: app_exception.raise_exception;
455: END IF;
456: END IF;
457:
458: END before_dml;

Line 566: app_exception.raise_exception;

562: END IF;
563: ELSE
564: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
565: igs_ge_msg_stack.add;
566: app_exception.raise_exception;
567: END IF;
568:
569: SELECT IGS_FI_ANC_INT_S.NEXTVAL INTO x_ANCILLARY_INT_ID FROM DUAL;
570: new_references.org_id := IGS_GE_GEN_003.Get_Org_Id;

Line 882: app_exception.raise_exception;

878: IF (c1%notfound) THEN
879: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
880: igs_ge_msg_stack.add;
881: CLOSE c1;
882: app_exception.raise_exception;
883: RETURN;
884: END IF;
885: CLOSE c1;
886:

Line 939: app_exception.raise_exception;

935: NULL;
936: ELSE
937: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
938: igs_ge_msg_stack.add;
939: app_exception.raise_exception;
940: END IF;
941:
942: l_rowid := NULL;
943: RETURN;

Line 1036: app_exception.raise_exception;

1032: END IF;
1033: ELSE
1034: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1035: igs_ge_msg_stack.add;
1036: app_exception.raise_exception;
1037: END IF;
1038:
1039: before_dml(
1040: p_action => 'UPDATE',