DBA Data[Home] [Help]

APPS.IGS_EN_ATD_TYPE_LOAD_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

34: Fetch cur_old_ref_values INTO old_references;
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
36: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;

Line 76: IGS_GE_MSG_STACK.ADD;

72: IF p_inserting OR p_updating THEN
73: IF IGS_AD_VAL_APCOO.CRSP_VAL_ATT_CLOSED(new_references.attendance_type
74: ,v_message_name) = FALSE THEN
75: fnd_message.set_name('IGS',v_message_name);
76: IGS_GE_MSG_STACK.ADD;
77: app_exception.raise_exception;
78: END IF;
79: IF IGS_PS_VAL_ATL.CRSP_VAL_ATL_CAT(new_references.cal_type
80: ,v_message_name) = FALSE THEN

Line 82: IGS_GE_MSG_STACK.ADD;

78: END IF;
79: IF IGS_PS_VAL_ATL.CRSP_VAL_ATL_CAT(new_references.cal_type
80: ,v_message_name) = FALSE THEN
81: fnd_message.set_name('IGS',v_message_name);
82: IGS_GE_MSG_STACK.ADD;
83: app_exception.raise_exception;
84: END IF;
85: END IF;
86:

Line 108: IGS_GE_MSG_STACK.ADD;

104: new_references.lower_enr_load_range,
105: new_references.upper_enr_load_range,
106: v_message_name) = FALSE THEN
107: fnd_message.set_name('IGS',v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: app_exception.raise_exception;
110: END IF;
111: v_rowid_saved := TRUE;
112: END AfterRowInsertUpdate2;

Line 136: IGS_GE_MSG_STACK.ADD;

132: column_name is null then
133: if new_references.upper_enr_load_range <0 OR
134: new_references.upper_enr_load_range > 999.999 then
135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: end if;
139: end if;
140: IF upper(column_name) = 'LOWER_ENR_LOAD_RANGE' OR

Line 145: IGS_GE_MSG_STACK.ADD;

141: column_name is null then
142: if new_references.lower_enr_load_range<0 OR
143: new_references.lower_enr_load_range >999.999 then
144: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: end if;
148: end if;
149: IF upper(column_name) = 'ATTENDANCE_TYPE' OR

Line 153: IGS_GE_MSG_STACK.ADD;

149: IF upper(column_name) = 'ATTENDANCE_TYPE' OR
150: column_name is null then
151: if new_references.attendance_type <> upper(new_references.attendance_type) then
152: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: end if;
156: end if;
157: IF upper(column_name) = 'CAL_TYPE' OR

Line 161: IGS_GE_MSG_STACK.ADD;

157: IF upper(column_name) = 'CAL_TYPE' OR
158: column_name is null then
159: if new_references.cal_type <> upper(new_references.cal_type) then
160: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: end if;
164: end if;
165: END check_constraints;

Line 178: IGS_GE_MSG_STACK.ADD;

174: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
175: new_references.attendance_type
176: ) THEN
177: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: end if;
181: END IF;
182:

Line 191: IGS_GE_MSG_STACK.ADD;

187: IF NOT IGS_CA_TYPE_PKG.Get_PK_For_Validation (
188: new_references.cal_type
189: ) THEN
190: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: end if;
194: END IF;
195:

Line 244: IGS_GE_MSG_STACK.ADD;

240: Fetch cur_rowid INTO lv_rowid;
241: IF (cur_rowid%FOUND) THEN
242: Close cur_rowid;
243: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ATL_ATT_FK');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: Return;
247: END IF;
248: Close cur_rowid;

Line 270: IGS_GE_MSG_STACK.ADD;

266: Fetch cur_rowid INTO lv_rowid;
267: IF (cur_rowid%FOUND) THEN
268: Close cur_rowid;
269: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ATL_CAT_FK');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: Return;
273: END IF;
274: Close cur_rowid;

Line 318: IGS_GE_MSG_STACK.ADD;

314: new_references.cal_type ,
315: new_references.attendance_type
316: ) THEN
317: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: Check_constraints;
322: Check_Parent_Existance;

Line 337: IGS_GE_MSG_STACK.ADD;

333: new_references.cal_type ,
334: new_references.attendance_type
335: ) THEN
336: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
337: IGS_GE_MSG_STACK.ADD;
338: App_Exception.Raise_Exception;
339: END IF;
340: Check_constraints;
341: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 401: IGS_GE_MSG_STACK.ADD;

397: X_LAST_UPDATE_LOGIN := -1;
398: end if;
399: else
400: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
401: IGS_GE_MSG_STACK.ADD;
402: app_exception.raise_exception;
403: end if;
404: Before_DML (
405: p_action => 'INSERT',

Line 482: IGS_GE_MSG_STACK.ADD;

478: fetch c1 into tlinfo;
479: if (c1%notfound) then
480: close c1;
481: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
482: IGS_GE_MSG_STACK.ADD;
483: app_exception.raise_exception;
484: return;
485: end if;
486: close c1;

Line 497: IGS_GE_MSG_STACK.ADD;

493: ) then
494: null;
495: else
496: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
497: IGS_GE_MSG_STACK.ADD;
498: app_exception.raise_exception;
499: end if;
500: return;
501: end LOCK_ROW;

Line 531: IGS_GE_MSG_STACK.ADD;

527: X_LAST_UPDATE_LOGIN := -1;
528: end if;
529: else
530: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
531: IGS_GE_MSG_STACK.ADD;
532: app_exception.raise_exception;
533: end if;
534: Before_DML (
535: p_action => 'UPDATE',