DBA Data[Home] [Help]

APPS.IGS_PS_VER_HIST_PKG dependencies on IGS_GE_MSG_STACK

Line 94: IGS_GE_MSG_STACK.ADD;

90: Fetch cur_old_ref_values INTO old_references;
91: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
92: Close cur_old_ref_values;
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: Return;
97: END IF;
98: Close cur_old_ref_values;

Line 205: IGS_GE_MSG_STACK.ADD;

201: column_name is null THEN
202: IF new_references.generic_course_ind NOT IN ( 'Y' , 'N' )
203: THEN
204: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: END IF;
208: END IF;
209: IF upper(column_name)= 'COUNT_INTRMSN_IN_TIME_IND' OR

Line 214: IGS_GE_MSG_STACK.ADD;

210: column_name is null THEN
211: IF new_references.count_intrmsn_in_time_ind NOT IN ( 'Y' , 'N' )
212: THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: END IF;
217: END IF;
218: IF upper(column_name)= 'EXTERNAL_ADV_STND_LIMIT' OR

Line 224: IGS_GE_MSG_STACK.ADD;

220: IF new_references.external_adv_stnd_limit < 0 OR
221: new_references.external_adv_stnd_limit > 9999.999
222: THEN
223: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227: END IF;
228: IF upper(column_name)= 'STD_ANNUAL_LOAD' OR

Line 234: IGS_GE_MSG_STACK.ADD;

230: IF new_references.std_annual_load < 0 OR
231: new_references.std_annual_load > 9999.999
232: THEN
233: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
238: IF upper(column_name)= 'INTERNAL_ADV_STND_LIMIT' OR

Line 244: IGS_GE_MSG_STACK.ADD;

240: IF new_references.internal_adv_stnd_limit < 0 OR
241: new_references.internal_adv_stnd_limit > 9999.999
242: THEN
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
248: IF upper(column_name)= 'INTRMSN_ALLOWED_IND' OR

Line 253: IGS_GE_MSG_STACK.ADD;

249: column_name is null THEN
250: IF new_references.intrmsn_allowed_ind NOT IN ( 'Y' , 'N' )
251: THEN
252: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
257: IF upper(column_name)= 'GRADUATE_STUDENTS_IND' OR

Line 262: IGS_GE_MSG_STACK.ADD;

258: column_name is null THEN
259: IF new_references.graduate_students_ind NOT IN ( 'Y' , 'N' )
260: THEN
261: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: END IF;
266: IF upper(column_name)= 'ABBREVIATION' OR

Line 271: IGS_GE_MSG_STACK.ADD;

267: column_name is null THEN
268: IF new_references.abbreviation<> UPPER(new_references.abbreviation)
269: THEN
270: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: END IF;
275:

Line 281: IGS_GE_MSG_STACK.ADD;

277: column_name is null THEN
278: IF new_references.course_cd <> UPPER(new_references.course_cd )
279: THEN
280: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END IF;
284: END IF;
285:

Line 291: IGS_GE_MSG_STACK.ADD;

287: column_name is null THEN
288: IF new_references.course_status <> UPPER(new_references.course_status)
289: THEN
290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: END IF;
295:

Line 301: IGS_GE_MSG_STACK.ADD;

297: column_name is null THEN
298: IF new_references.course_type <> UPPER(new_references.course_type)
299: THEN
300: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: END IF;
305: IF upper(column_name)= 'GOVT_SPECIAL_COURSE_TYPE' OR

Line 310: IGS_GE_MSG_STACK.ADD;

306: column_name is null THEN
307: IF new_references.govt_special_course_type <> UPPER(new_references.govt_special_course_type )
308: THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: END IF;
314:

Line 320: IGS_GE_MSG_STACK.ADD;

316: column_name is null THEN
317: IF new_references.supp_exam_permitted_ind <> UPPER(new_references.supp_exam_permitted_ind )
318: THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: END IF;
324:

Line 329: IGS_GE_MSG_STACK.ADD;

325: IF upper(column_name)= 'MAX_WLST_PER_STUD' OR column_name is null THEN
326: IF new_references.max_wlst_per_stud < 0 OR
327: new_references.max_wlst_per_stud > 9999 THEN
328: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: END IF;
332: END IF;
333:

Line 338: IGS_GE_MSG_STACK.ADD;

334: IF upper(column_name)= 'ANNUAL_INSTRUCTION_TIME' OR column_name is null THEN
335: IF new_references.annual_instruction_time < 1 OR
336: new_references.annual_instruction_time > 99.99 THEN
337: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
338: IGS_GE_MSG_STACK.ADD;
339: App_Exception.Raise_Exception;
340: END IF;
341: END IF;
342:

Line 514: IGS_GE_MSG_STACK.ADD;

510: new_references.version_number,
511: new_references.hist_start_dt
512: ) THEN
513: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
514: IGS_GE_MSG_STACK.ADD;
515: App_Exception.Raise_Exception;
516: END IF;
517: Check_Constraints;
518: ELSIF (p_action = 'UPDATE') THEN

Line 530: IGS_GE_MSG_STACK.ADD;

526: new_references.version_number,
527: new_references.hist_start_dt
528: ) THEN
529: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
530: IGS_GE_MSG_STACK.ADD;
531: App_Exception.Raise_Exception;
532: END IF;
533: Check_Constraints;
534: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 638: IGS_GE_MSG_STACK.ADD;

634: X_LAST_UPDATE_LOGIN := -1;
635: end if;
636: else
637: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
638: IGS_GE_MSG_STACK.ADD;
639: app_exception.raise_exception;
640: end if;
641: before_dml( p_action => 'INSERT',
642: x_rowid => X_ROWID,

Line 939: IGS_GE_MSG_STACK.ADD;

935: FETCH c1 INTO tlinfo;
936: IF (c1%notfound) THEN
937: CLOSE c1;
938: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
939: IGS_GE_MSG_STACK.ADD;
940: app_exception.raise_exception;
941: RETURN;
942: END IF;
943: CLOSE c1;

Line 1076: IGS_GE_MSG_STACK.ADD;

1072: ) THEN
1073: NULL;
1074: ELSE
1075: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1076: IGS_GE_MSG_STACK.ADD;
1077: app_exception.raise_exception;
1078: END IF;
1079: RETURN;
1080: END lock_row;

Line 1164: IGS_GE_MSG_STACK.ADD;

1160: X_LAST_UPDATE_LOGIN := -1;
1161: END IF;
1162: ELSE
1163: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1164: IGS_GE_MSG_STACK.ADD;
1165: app_exception.raise_exception;
1166: END IF;
1167: before_dml( p_action => 'UPDATE',
1168: x_rowid => X_ROWID,