DBA Data[Home] [Help]

APPS.IGS_AD_CODE_CLASSES_PKG dependencies on APP_EXCEPTION

Line 55: App_Exception.Raise_Exception;

51: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
52: Close cur_old_ref_values;
53: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
54: IGS_GE_MSG_STACK.ADD;
55: App_Exception.Raise_Exception;
56: Return;
57: END IF;
58: Close cur_old_ref_values;
59:

Line 110: App_Exception.Raise_Exception;

106: Column_Name IS NULL THEN
107: IF NOT (new_references.closed_ind IN ('Y','N')) THEN
108: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113: END Check_Constraints;
114:

Line 141: App_Exception.Raise_Exception;

137: Igs_Lookups_view_pkg.Get_PK_For_Validation ('IGS_AD_QUAL_TYPE',new_references.class) OR
138: Igs_Lookups_view_pkg.Get_PK_For_Validation (new_references.class_type_code,new_references.class)) THEN
139: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143:
144: IF (old_references.system_status = new_references.system_status OR
145: new_references.system_status IS NULL) THEN

Line 150: App_Exception.Raise_Exception;

146: NULL;
147: ELSIF NOT (Igs_Lookups_view_pkg.Get_PK_For_Validation (new_references.class,new_references.system_status)) THEN
148: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END Check_Parent_Existance;
153:
154: PROCEDURE Check_Uniqueness AS

Line 174: app_exception.raise_exception;

170: ,new_references.class_type_code
171: ) THEN
172: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
173: IGS_GE_MSG_STACK.ADD;
174: app_exception.raise_exception;
175: END IF;
176: END Check_Uniqueness ;
177:
178: PROCEDURE Check_Child_Existance IS

Line 488: App_Exception.Raise_Exception;

484: IF Get_Pk_For_Validation(
485: new_references.code_id) THEN
486: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
487: IGS_GE_MSG_STACK.ADD;
488: App_Exception.Raise_Exception;
489: END IF;
490: Check_Uniqueness;
491: Check_Parent_Existance;
492: Check_Constraints;

Line 509: App_Exception.Raise_Exception;

505: IF Get_PK_For_Validation (
506: new_references.code_id) THEN
507: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
508: IGS_GE_MSG_STACK.ADD;
509: App_Exception.Raise_Exception;
510: END IF;
511: Check_Uniqueness;
512: Check_Constraints;
513: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 602: app_exception.raise_exception;

598: end if;
599: else
600: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
601: IGS_GE_MSG_STACK.ADD;
602: app_exception.raise_exception;
603: end if;
604:
605: X_CODE_ID := -1;
606: Before_DML(

Line 703: app_exception.raise_exception;

699: if (c1%notfound) then
700: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
701: IGS_GE_MSG_STACK.ADD;
702: close c1;
703: app_exception.raise_exception;
704: return;
705: end if;
706: close c1;
707: if ( ( tlinfo.NAME = X_NAME)

Line 725: app_exception.raise_exception;

721: null;
722: else
723: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
724: IGS_GE_MSG_STACK.ADD;
725: app_exception.raise_exception;
726: end if;
727: return;
728: end LOCK_ROW;
729: Procedure UPDATE_ROW (

Line 772: app_exception.raise_exception;

768: end if;
769: else
770: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
771: IGS_GE_MSG_STACK.ADD;
772: app_exception.raise_exception;
773: end if;
774: Before_DML(
775: p_action=>'UPDATE',
776: x_rowid=>X_ROWID,