[Home] [Help]
38: Open cur_old_ref_values;
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;
88: old_references.closed_ind <> new_references.closed_ind)) THEN
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;
122: IF upper(column_name) = 'LOWER_ENR_LOAD_RANGE' OR
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;
132: IF upper(column_name) = 'RESEARCH_PERCENTAGE' OR
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:
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;
151: IF upper(column_name) = 'UPPER_ENR_LOAD_RANGE' OR
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:
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:
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;
187: ELSE
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;
314: Open cur_rowid;
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;
366: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
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;
385: ELSIF (p_action = 'VALIDATE_INSERT') then
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;
451: if X_LAST_UPDATE_LOGIN is NULL then
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:
547: open c1;
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;
565: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
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;
601: if X_LAST_UPDATE_LOGIN is NULL then
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:
732: --Who When What
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: