APPS.IGS_FI_EXT_INT_PKG dependencies on APP_EXCEPTION

Line 90: app_exception.raise_exception;

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

Line 188: App_Exception.Raise_Exception;

184: 'SUCCESS',
185: 'ERROR') THEN
186: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;
191:
192: IF upper(Column_name)= 'EXCHANGE_RATE' or Column_name is null Then

Line 196: App_Exception.Raise_Exception;

192: IF upper(Column_name)= 'EXCHANGE_RATE' or Column_name is null Then
193: If new_references.EXCHANGE_RATE <= 0 then
194: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: End if;
198: End if;
199:
200: END Check_Constraints;

Line 223: || app_exception.raise_exception;

219: || ,new_references.fee_type
220: || ) THEN
221: || fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
222: || igs_ge_msg_stack.add;
223: || app_exception.raise_exception;
224: || END IF;
225: */ ----Commented whole code as not needed anymore as indicated in Ancillary and External Charges by nshee
226: null;
227: END check_uniqueness ;

Line 322: App_Exception.Raise_Exception;

318: new_references.override_cr_rev_account_cd
319: ) THEN
320: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception;
323: END IF;
324: END IF;
325: IF ((old_references.override_dr_rec_account_cd = new_references.override_dr_rec_account_cd) OR
326: (new_references.override_dr_rec_account_cd IS NULL)) THEN

Line 334: App_Exception.Raise_Exception;

330: new_references.override_dr_rec_account_cd
331: ) THEN
332: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
333: IGS_GE_MSG_STACK.ADD;
334: App_Exception.Raise_Exception;
335: END IF;
336: END IF;
337:
338:

Line 348: App_Exception.Raise_Exception;

344: new_references.status
345: )THEN
346: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
347: IGS_GE_MSG_STACK.ADD;
348: App_Exception.Raise_Exception;
349: END IF;
350: END Check_Parent_Existance;
351:
352: PROCEDURE before_dml (

Line 478: app_exception.raise_exception;

474: IF get_pk_for_validation(
475: new_references.external_fee_id) THEN
476: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
477: igs_ge_msg_stack.add;
478: app_exception.raise_exception;
479: END IF;
480: -- check_uniqueness;
481: check_constraints;
482: Check_Parent_Existance;

Line 498: app_exception.raise_exception;

494: IF get_pk_for_validation (
495: new_references.external_fee_id) THEN
496: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
497: igs_ge_msg_stack.add;
498: app_exception.raise_exception;
499: END IF;
500: -- check_uniqueness;
501: check_constraints;
502: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 640: app_exception.raise_exception;

636: END IF;
637: ELSE
638: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
639: igs_ge_msg_stack.add;
640: app_exception.raise_exception;
641: end if;
642: SELECT igs_fi_ext_int_s.NEXTVAL
643: INTO x_external_fee_id
644: FROM DUAL;

Line 923: app_exception.raise_exception;

919: IF (c1%notfound) THEN
920: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
921: igs_ge_msg_stack.add;
922: CLOSE c1;
923: app_exception.raise_exception;
924: RETURN;
925: END IF;
926: CLOSE c1;
927: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 982: app_exception.raise_exception;

978: NULL;
979: ELSE
980: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
981: igs_ge_msg_stack.add;
982: app_exception.raise_exception;
983: END IF;
984: RETURN;
985: END lock_row;
986:

Line 1070: app_exception.raise_exception;

1066: END IF;
1067: ELSE
1068: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1069: igs_ge_msg_stack.add;
1070: app_exception.raise_exception;
1071: END IF;
1072: before_dml(
1073: p_action=>'UPDATE',
1074: x_rowid=>X_ROWID,