DBA Data[Home] [Help]

APPS.IGS_EN_ATD_TYPE_PKG dependencies on IGS_GE_MSG_STACK

Line 43: IGS_GE_MSG_STACK.ADD;

39: Fetch cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: Close cur_old_ref_values;
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Return;
46: END IF;
47: Close cur_old_ref_values;

Line 93: IGS_GE_MSG_STACK.ADD;

89: IF IGS_PS_VAL_ATT.crsp_val_att_govt(
90: new_references.govt_attendance_type,
91: v_message_name) = FALSE THEN
92: Fnd_Message.Set_Name('IGS', v_message_name);
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:

Line 127: IGS_GE_MSG_STACK.ADD;

123: Column_name is null THEN
124: IF new_references.lower_enr_load_range < 0 OR
125: new_references.lower_enr_load_range > 9999.999THEN
126: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131:

Line 137: IGS_GE_MSG_STACK.ADD;

133: Column_name is null THEN
134: IF new_references.research_percentage < 0 OR
135: new_references.research_percentage > 100 THEN
136: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
141:

Line 146: IGS_GE_MSG_STACK.ADD;

142: IF upper(column_name) = 'CLOSED_IND' OR
143: Column_name is null THEN
144: IF new_references.closed_ind NOT IN ('Y','N') THEN
145: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149: END IF;
150:

Line 156: IGS_GE_MSG_STACK.ADD;

152: Column_name is null THEN
153: IF new_references.upper_enr_load_range < 0 OR
154: new_references.upper_enr_load_range > 9999.999 THEN
155: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
160:

Line 165: IGS_GE_MSG_STACK.ADD;

161: IF upper(column_name) = 'ATTENDANCE_TYPE' OR
162: Column_name is null THEN
163: IF new_references.attendance_type <> UPPER(new_references.attendance_type) THEN
164: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169:

Line 174: IGS_GE_MSG_STACK.ADD;

170: IF upper(column_name) = 'GOVT_ATTENDANCE_TYPE' OR
171: Column_name is null THEN
172: IF new_references.govt_attendance_type <> UPPER(new_references.govt_attendance_type) THEN
173: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: END IF;
178:

Line 192: IGS_GE_MSG_STACK.ADD;

188: IF NOT IGS_PS_GOVT_ATD_TYPE_PKG.Get_PK_For_Validation (
189: new_references.govt_attendance_type
190: ) THEN
191: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;
196:

Line 319: IGS_GE_MSG_STACK.ADD;

315: Fetch cur_rowid INTO lv_rowid;
316: IF (cur_rowid%FOUND) THEN
317: Close cur_rowid;
318: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ATT_GAT_FK');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: Return;
322: END IF;
323: Close cur_rowid;

Line 371: IGS_GE_MSG_STACK.ADD;

367: IF Get_PK_For_Validation (
368: new_references.attendance_type
369: ) THEN
370: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373: END IF;
374: Check_constraints;
375: Check_Parent_Existance;

Line 390: IGS_GE_MSG_STACK.ADD;

386: IF Get_PK_For_Validation (
387: new_references.attendance_type
388: ) THEN
389: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
390: IGS_GE_MSG_STACK.ADD;
391: App_Exception.Raise_Exception;
392: END IF;
393: Check_constraints;
394: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 456: IGS_GE_MSG_STACK.ADD;

452: X_LAST_UPDATE_LOGIN := -1;
453: end if;
454: else
455: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
456: IGS_GE_MSG_STACK.ADD;
457: app_exception.raise_exception;
458: end if;
459:
460: Before_DML(

Line 552: IGS_GE_MSG_STACK.ADD;

548: fetch c1 into tlinfo;
549: if (c1%notfound) then
550: close c1;
551: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
552: IGS_GE_MSG_STACK.ADD;
553: app_exception.raise_exception;
554: return;
555: end if;
556: close c1;

Line 570: IGS_GE_MSG_STACK.ADD;

566: ) then
567: null;
568: else
569: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570: IGS_GE_MSG_STACK.ADD;
571: app_exception.raise_exception;
572: end if;
573: return;
574: end LOCK_ROW;

Line 606: IGS_GE_MSG_STACK.ADD;

602: X_LAST_UPDATE_LOGIN := -1;
603: end if;
604: else
605: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
606: IGS_GE_MSG_STACK.ADD;
607: app_exception.raise_exception;
608: end if;
609:
610: Before_DML(

Line 737: IGS_GE_MSG_STACK.ADD;

733: -------------------------------------------------------------------
734: BEGIN
735: -- Preventing deletion of the Attendance Type records. As a part of Bug # 2729917
736: FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');
737: IGS_GE_MSG_STACK.ADD;
738: APP_EXCEPTION.RAISE_EXCEPTION;
739: END beforerowdelete;
740:
741: end IGS_EN_ATD_TYPE_PKG;