APPS.IGS_ST_GVTSEMLOAD_CA_PKG dependencies on IGS_GE_MSG_STACK

Line 39: IGS_GE_MSG_STACK.ADD;

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

Line 91: IGS_GE_MSG_STACK.ADD;

87: v_submission_number,
88: v_message_name) = FALSE THEN
89: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(2029));
90: Fnd_Message.Set_Name('IGS','IGS_EN_PRSN_NOTHAVE_APP_GOVT');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: -- Validate the calendar.
95: IF p_inserting OR

Line 104: IGS_GE_MSG_STACK.ADD;

100: new_references.cal_type,
101: new_references.ci_sequence_number,
102: v_message_name) = FALSE THEN
103: Fnd_Message.Set_Name('IGS',v_message_name);
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108:

Line 134: IGS_GE_MSG_STACK.ADD;

130:
131: IF upper(Column_name) = 'CAL_TYPE' OR COLUMN_NAME IS NULL THEN
132: IF new_references.CAL_TYPE<> upper(new_references.CAL_TYPE) then
133: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception ;
136: END IF;
137:
138: END IF ;

Line 143: IGS_GE_MSG_STACK.ADD;

139:
140: IF upper(Column_name) = 'CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
141: IF new_references.CI_SEQUENCE_NUMBER < 1 or new_references.CI_SEQUENCE_NUMBER > 999999 then
142: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception ;
145: END IF;
146:
147: END IF ;

Line 152: IGS_GE_MSG_STACK.ADD;

148:
149: IF upper(Column_name) = 'SUBMISSION_YR' OR COLUMN_NAME IS NULL THEN
150: IF new_references.SUBMISSION_YR < 0 or new_references.SUBMISSION_YR > 9999 then
151: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception ;
154: END IF;
155:
156: END IF ;

Line 177: IGS_GE_MSG_STACK.ADD;

173: new_references.cal_type,
174: new_references.ci_sequence_number
175: ) THEN
176: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180:
181: IF (((old_references.submission_yr = new_references.submission_yr) AND

Line 195: IGS_GE_MSG_STACK.ADD;

191: new_references.submission_number,
192: new_references.govt_semester
193: ) THEN
194: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: END IF;
199: END IF;

Line 212: IGS_GE_MSG_STACK.ADD;

208: new_references.cal_type ,
209: new_references.ci_sequence_number
210: ) THEN
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215: End CHECK_UNIQUENESS ;
216:

Line 273: IGS_GE_MSG_STACK.ADD;

269: Fetch cur_rowid INTO lv_rowid;
270: IF (cur_rowid%FOUND) THEN
271: Close cur_rowid;
272: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSLC_CI_FK');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: Return;
276: END IF;
277: Close cur_rowid;

Line 303: IGS_GE_MSG_STACK.ADD;

299: Fetch cur_rowid INTO lv_rowid;
300: IF (cur_rowid%FOUND) THEN
301: Close cur_rowid;
302: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSLC_GSEM_FK');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: Return;
306: END IF;
307: Close cur_rowid;

Line 386: IGS_GE_MSG_STACK.ADD;

382: new_references.cal_type ,
383: new_references.ci_sequence_number
384: ) THEN
385: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388: END IF;
389: Check_Uniqueness;
390: Check_Constraints;

Line 410: IGS_GE_MSG_STACK.ADD;

406: new_references.cal_type ,
407: new_references.ci_sequence_number
408: ) THEN
409: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: END IF;
413: Check_Uniqueness;
414: Check_Constraints;

Line 468: IGS_GE_MSG_STACK.ADD;

464: X_LAST_UPDATE_LOGIN := -1;
465: end if;
466: else
467: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
468: IGS_GE_MSG_STACK.ADD;
469: app_exception.raise_exception;
470: end if;
471: Before_DML (
472: p_action => 'INSERT',

Line 543: IGS_GE_MSG_STACK.ADD;

539: fetch c1 into tlinfo;
540: if (c1%notfound) then
541: close c1;
542: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
543: IGS_GE_MSG_STACK.ADD;
544: app_exception.raise_exception;
545: return;
546: end if;
547: close c1;