APPS.IGS_EN_ATD_MODE_PKG dependencies on APP_EXCEPTION

Line 41: App_Exception.Raise_Exception;

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;
44: Close cur_old_ref_values;
45:

Line 91: App_Exception.Raise_Exception;

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;
94:
95:

Line 118: App_Exception.Raise_Exception;

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

Line 127: App_Exception.Raise_Exception;

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

Line 136: App_Exception.Raise_Exception;

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;
139:
140: END check_constraints;

Line 155: App_Exception.Raise_Exception;

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;
158:
159: END Check_Parent_Existance;

Line 255: App_Exception.Raise_Exception;

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;
258: Close cur_rowid;
259:

Line 301: App_Exception.Raise_Exception;

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;
304: Check_Parent_Existance;
305: ELSIF (p_action = 'UPDATE') THEN

Line 320: App_Exception.Raise_Exception;

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;
323: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
324: Check_constraints;

Line 384: app_exception.raise_exception;

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:
387: Before_DML(
388: p_action => 'INSERT',

Line 466: app_exception.raise_exception;

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;
469: close c1;
470:

Line 479: app_exception.raise_exception;

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;
482: end LOCK_ROW;
483:

Line 512: app_exception.raise_exception;

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:
515: Before_DML(
516: p_action => 'UPDATE',

Line 630: APP_EXCEPTION.RAISE_EXCEPTION;

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:
633: end IGS_EN_ATD_MODE_PKG;