APPS.IGS_AD_CODE_CLASSES_PKG dependencies on IGS_GE_MSG_STACK

Line 54: IGS_GE_MSG_STACK.ADD;

50: Fetch cur_old_ref_values INTO old_references;
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;

Line 109: IGS_GE_MSG_STACK.ADD;

105: IF Upper(Column_Name) = 'CLOSED_IND' OR
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;

Line 140: IGS_GE_MSG_STACK.ADD;

136: ELSIF NOT (Igs_Lookups_view_pkg.Get_PK_For_Validation ('ADM_CODE_CLASSES',new_references.class)OR
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

Line 149: IGS_GE_MSG_STACK.ADD;

145: new_references.system_status IS NULL) THEN
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:

Line 173: IGS_GE_MSG_STACK.ADD;

169: ,new_references.class
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:

Line 487: IGS_GE_MSG_STACK.ADD;

483: Null;
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;

Line 508: IGS_GE_MSG_STACK.ADD;

504: -- Call all the procedures related to Before Insert.
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;

Line 601: IGS_GE_MSG_STACK.ADD;

597: X_LAST_UPDATE_LOGIN := -1;
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;

Line 701: IGS_GE_MSG_STACK.ADD;

697: open c1;
698: fetch c1 into tlinfo;
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;

Line 724: IGS_GE_MSG_STACK.ADD;

720: ) then
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;

Line 771: IGS_GE_MSG_STACK.ADD;

767: X_LAST_UPDATE_LOGIN := -1;
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',