[Home] [Help]
35: Open cur_old_ref_values;
36: Fetch cur_old_ref_values INTO old_references;
37: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
38: Close cur_old_ref_values;
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: IGS_GE_MSG_STACK.ADD;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
85: old_references.closed_ind <> new_references.closed_ind)) THEN
86: IF IGS_PS_VAL_AM.crsp_val_am_govt(
87: new_references.govt_attendance_mode,
88: v_message_name) = FALSE THEN
89: Fnd_Message.Set_Name('IGS', v_message_name);
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: END IF;
112:
113: IF upper(column_name) = 'CLOSED_IND' OR
114: Column_name is null THEN
115: IF new_references.closed_ind NOT IN ('Y','N') THEN
116: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121:
122: IF upper(column_name) = 'ATTENDANCE_MODE' OR
123: Column_name is null THEN
124: IF new_references.attendance_mode <> UPPER(new_references.attendance_mode) THEN
125: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
126: IGS_GE_MSG_STACK.ADD;
127: App_Exception.Raise_Exception;
128: END IF;
129: END IF;
130:
131: IF upper(column_name) = 'GOVT_ATTENDANCE_MODE' OR
132: Column_name is null THEN
133: IF new_references.govt_attendance_mode <> UPPER(new_references.govt_attendance_mode) THEN
134: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: END IF;
149: ELSE
150: IF NOT IGS_PS_GOVT_ATD_MODE_PKG.Get_PK_For_Validation (
151: new_references.govt_attendance_mode
152: ) THEN
153: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
249: Open cur_rowid;
250: Fetch cur_rowid INTO lv_rowid;
251: IF (cur_rowid%FOUND) THEN
252: Close cur_rowid;
253: Fnd_Message.Set_Name ('IGS', 'IGS_EN_AM_GAM_FK');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: Return;
257: END IF;
295: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
296: IF Get_PK_For_Validation (
297: new_references.attendance_mode
298: ) Then
299: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: END IF;
303: Check_constraints;
314: ELSIF (p_action = 'VALIDATE_INSERT') then
315: IF Get_PK_For_Validation (
316: new_references.attendance_mode
317: ) Then
318: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: END IF;
322: Check_constraints;
378: if X_LAST_UPDATE_LOGIN is NULL then
379: X_LAST_UPDATE_LOGIN := -1;
380: end if;
381: else
382: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
383: IGS_GE_MSG_STACK.ADD;
384: app_exception.raise_exception;
385: end if;
386:
460: open c1;
461: fetch c1 into tlinfo;
462: if (c1%notfound) then
463: close c1;
464: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: return;
468: end if;
473: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
474: ) then
475: null;
476: else
477: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
478: IGS_GE_MSG_STACK.ADD;
479: app_exception.raise_exception;
480: end if;
481: return;
506: if X_LAST_UPDATE_LOGIN is NULL then
507: X_LAST_UPDATE_LOGIN := -1;
508: end if;
509: else
510: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
511: IGS_GE_MSG_STACK.ADD;
512: app_exception.raise_exception;
513: end if;
514:
624: --Who When What
625: -------------------------------------------------------------------
626: BEGIN
627: -- Preventing deletion of the Attendance Mode records. As a part of Bug # 2729917
628: FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');
629: IGS_GE_MSG_STACK.ADD;
630: APP_EXCEPTION.RAISE_EXCEPTION;
631: END beforerowdelete;
632: