APPS.IGS_AD_INTERFACE_PKG dependencies on APP_EXCEPTION

Line 100: app_exception.raise_exception;

96: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
97: CLOSE cur_old_ref_values;
98: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: RETURN;
102: END IF;
103: CLOSE cur_old_ref_values;
104:

Line 212: App_Exception.Raise_Exception;

208: Column_Name IS NULL THEN
209: IF NOT (new_references.status IN ('1','2','3','4')) THEN
210: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: END IF;
214: END IF;
215:
216: -- The following code checks for check constraints on the Columns.

Line 223: App_Exception.Raise_Exception;

219: IF new_references.sex IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code
220: ('HZ_GENDER', UPPER(new_references.sex),222)) THEN
221: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
222: IGS_GE_MSG_STACK.ADD;
223: App_Exception.Raise_Exception;
224: END IF;
225: END IF;
226:
227: -- The following code checks for check constraints on the Columns.

Line 233: App_Exception.Raise_Exception;

229: Column_Name IS NULL THEN
230: IF NOT (new_references.record_status IN ('1', '2', '3')) THEN
231: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
232: IGS_GE_MSG_STACK.ADD;
233: App_Exception.Raise_Exception;
234: END IF;
235: END IF;
236:
237:

Line 446: App_Exception.Raise_Exception;

442: IF Get_Pk_For_Validation(
443: new_references.interface_id) THEN
444: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
445: IGS_GE_MSG_STACK.ADD;
446: App_Exception.Raise_Exception;
447: END IF;
448: Check_Constraints;
449: ELSIF (p_action = 'UPDATE') THEN
450: -- Call all the procedures related to Before Update.

Line 461: App_Exception.Raise_Exception;

457: IF Get_PK_For_Validation (
458: new_references.interface_id) THEN
459: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
460: IGS_GE_MSG_STACK.ADD;
461: App_Exception.Raise_Exception;
462: END IF;
463: Check_Constraints;
464: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
465: Check_Constraints;

Line 586: app_exception.raise_exception;

582: END IF;
583: ELSE
584: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
585: igs_ge_msg_stack.add;
586: app_exception.raise_exception;
587: END IF;
588:
589: before_dml(
590: p_action => 'INSERT',

Line 940: app_exception.raise_exception;

936: IF (c1%notfound) THEN
937: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
938: igs_ge_msg_stack.add;
939: CLOSE c1;
940: app_exception.raise_exception;
941: RETURN;
942: END IF;
943: CLOSE c1;
944:

Line 1006: app_exception.raise_exception;

1002: NULL;
1003: ELSE
1004: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1005: igs_ge_msg_stack.add;
1006: app_exception.raise_exception;
1007: END IF;
1008:
1009: RETURN;
1010:

Line 1111: app_exception.raise_exception;

1107: END IF;
1108: ELSE
1109: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1110: igs_ge_msg_stack.add;
1111: app_exception.raise_exception;
1112: END IF;
1113:
1114: before_dml(
1115: p_action => 'UPDATE',