DBA Data[Home] [Help]

APPS.IGS_ST_GVT_SPSHT_CHG_PKG dependencies on FND_MESSAGE

Line 61: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

57: -- Populate Old Values.
58: Open cur_old_ref_values;
59: Fetch cur_old_ref_values INTO old_references;
60: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
61: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
62: IGS_GE_MSG_STACK.ADD;
63: App_Exception.Raise_Exception;
64: Close cur_old_ref_values;
65: Return;

Line 126: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

122: IF NOT IGS_ST_GVT_SPSHT_CTL_PKG.Get_PK_For_Validation (
123: new_references.submission_yr,
124: new_references.submission_number
125: )THEN
126: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
127: IGS_GE_MSG_STACK.ADD;
128: APP_EXCEPTION.RAISE_EXCEPTION;
129: END IF;
130: END IF;

Line 187: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSCH_GSC_FK');

183: Open cur_rowid;
184: Fetch cur_rowid INTO lv_rowid;
185: IF (cur_rowid%FOUND) THEN
186: Close cur_rowid;
187: Fnd_Message.Set_Name ('IGS', 'IGS_ST_GSCH_GSC_FK');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: Return;
191: END IF;

Line 243: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

239: END IF;
240:
241: IF upper(column_name) = 'CHANGED_UPDATE_WHO' OR column_name IS NULL THEN
242: IF new_references.changed_update_who <> UPPER(new_references.changed_update_who) 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;

Line 250: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

246: END IF;
247: END IF;
248: IF upper(column_name) = 'CITIZENSHIP_CD' OR column_name IS NULL THEN
249: IF new_references.citizenship_cd <> UPPER(new_references.citizenship_cd) THEN
250: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
251: IGS_GE_MSG_STACK.ADD;
252: APP_EXCEPTION.RAISE_EXCEPTION;
253: END IF;
254: END IF;

Line 257: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

253: END IF;
254: END IF;
255: IF upper(column_name) = 'COURSE_CD' OR column_name IS NULL THEN
256: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
257: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
258: IGS_GE_MSG_STACK.ADD;
259: APP_EXCEPTION.RAISE_EXCEPTION;
260: END IF;
261: END IF;

Line 264: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

260: END IF;
261: END IF;
262: IF upper(column_name) = 'DIFFERENTIAL_HECS_IND' OR column_name IS NULL THEN
263: IF new_references.differential_hecs_ind <> UPPER(new_references.differential_hecs_ind) THEN
264: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
265: IGS_GE_MSG_STACK.ADD;
266: APP_EXCEPTION.RAISE_EXCEPTION;
267: END IF;
268: END IF;

Line 271: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

267: END IF;
268: END IF;
269: IF upper(column_name) = 'HECS_PAYMENT_OPTION' OR column_name IS NULL THEN
270: IF new_references.hecs_payment_option <> UPPER(new_references.hecs_payment_option) THEN
271: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
272: IGS_GE_MSG_STACK.ADD;
273: APP_EXCEPTION.RAISE_EXCEPTION;
274: END IF;
275: END IF;

Line 278: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

274: END IF;
275: END IF;
276: IF upper(column_name) = 'OLD_CITIZENSHIP_CD' OR column_name IS NULL THEN
277: IF new_references.old_citizenship_cd <> UPPER(new_references.old_citizenship_cd) THEN
278: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
279: IGS_GE_MSG_STACK.ADD;
280: APP_EXCEPTION.RAISE_EXCEPTION;
281: END IF;
282: END IF;

Line 285: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

281: END IF;
282: END IF;
283: IF upper(column_name) = 'OLD_DIFFERENTIAL_HECS_IND' OR column_name IS NULL THEN
284: IF new_references.old_differential_hecs_ind <> UPPER(new_references.old_differential_hecs_ind) THEN
285: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
286: IGS_GE_MSG_STACK.ADD;
287: APP_EXCEPTION.RAISE_EXCEPTION;
288: END IF;
289: END IF;

Line 292: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

288: END IF;
289: END IF;
290: IF upper(column_name) = 'OLD_HECS_PAYMENT_OPTION' OR column_name IS NULL THEN
291: IF new_references.old_hecs_payment_option <> UPPER(new_references.old_hecs_payment_option) THEN
292: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
293: IGS_GE_MSG_STACK.ADD;
294: APP_EXCEPTION.RAISE_EXCEPTION;
295: END IF;
296: END IF;

Line 299: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

295: END IF;
296: END IF;
297: IF upper(column_name) = 'OLD_PERM_RESIDENT_CD' OR column_name IS NULL THEN
298: IF new_references.old_perm_resident_cd <> UPPER(new_references.old_perm_resident_cd) THEN
299: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
300: IGS_GE_MSG_STACK.ADD;
301: APP_EXCEPTION.RAISE_EXCEPTION;
302: END IF;
303: END IF;

Line 306: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

302: END IF;
303: END IF;
304: IF upper(column_name) = 'OLD_PRIOR_DEGREE' OR column_name IS NULL THEN
305: IF new_references.old_prior_degree <> UPPER(new_references.old_prior_degree) THEN
306: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
307: IGS_GE_MSG_STACK.ADD;
308: APP_EXCEPTION.RAISE_EXCEPTION;
309: END IF;
310: END IF;

Line 313: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

309: END IF;
310: END IF;
311: IF upper(column_name) = 'OLD_PRIOR_POST_GRAD' OR column_name IS NULL THEN
312: IF new_references.old_prior_post_grad <> UPPER(new_references.old_prior_post_grad) THEN
313: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
314: IGS_GE_MSG_STACK.ADD;
315: APP_EXCEPTION.RAISE_EXCEPTION;
316: END IF;
317: END IF;

Line 320: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

316: END IF;
317: END IF;
318: IF upper(column_name) = 'OLD_UNIT_CD' OR column_name IS NULL THEN
319: IF new_references.old_unit_cd <> UPPER(new_references.old_unit_cd) THEN
320: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
321: IGS_GE_MSG_STACK.ADD;
322: APP_EXCEPTION.RAISE_EXCEPTION;
323: END IF;
324: END IF;

Line 327: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

323: END IF;
324: END IF;
325: IF upper(column_name) = 'PERM_RESIDENT_CD' OR column_name IS NULL THEN
326: IF new_references.perm_resident_cd <> UPPER(new_references.perm_resident_cd) THEN
327: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
328: IGS_GE_MSG_STACK.ADD;
329: APP_EXCEPTION.RAISE_EXCEPTION;
330: END IF;
331: END IF;

Line 334: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

330: END IF;
331: END IF;
332: IF upper(column_name) = 'PRIOR_DEGREE' OR column_name IS NULL THEN
333: IF new_references.prior_degree <> UPPER(new_references.prior_degree) THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
335: IGS_GE_MSG_STACK.ADD;
336: APP_EXCEPTION.RAISE_EXCEPTION;
337: END IF;
338: END IF;

Line 341: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

337: END IF;
338: END IF;
339: IF upper(column_name) = 'PRIOR_POST_GRAD' OR column_name IS NULL THEN
340: IF new_references.prior_post_grad <> UPPER(new_references.prior_post_grad) THEN
341: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
342: IGS_GE_MSG_STACK.ADD;
343: APP_EXCEPTION.RAISE_EXCEPTION;
344: END IF;
345: END IF;

Line 348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

344: END IF;
345: END IF;
346: IF upper(column_name) = 'REPORTED_IND' OR column_name IS NULL THEN
347: IF new_references.reported_ind <> UPPER(new_references.reported_ind) THEN
348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
349: IGS_GE_MSG_STACK.ADD;
350: APP_EXCEPTION.RAISE_EXCEPTION;
351: END IF;
352: END IF;

Line 355: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

351: END IF;
352: END IF;
353: IF upper(column_name) = 'UNIT_CD' OR column_name IS NULL THEN
354: IF new_references.unit_cd <> UPPER(new_references.unit_cd) THEN
355: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
356: IGS_GE_MSG_STACK.ADD;
357: APP_EXCEPTION.RAISE_EXCEPTION;
358: END IF;
359: END IF;

Line 455: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

451: new_references.person_id,
452: new_references.course_cd,
453: new_references.sequence_number
454: )THEN
455: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
456: IGS_GE_MSG_STACK.ADD;
457: APP_EXCEPTION.RAISE_EXCEPTION;
458: END IF;
459: Check_Constraints;

Line 478: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

474: new_references.person_id,
475: new_references.course_cd,
476: new_references.sequence_number
477: )THEN
478: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
479: IGS_GE_MSG_STACK.ADD;
480: APP_EXCEPTION.RAISE_EXCEPTION;
481: END IF;
482: Check_Constraints;

Line 578: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

574: else
575: X_PROGRAM_UPDATE_DATE := SYSDATE;
576: end if;
577: else
578: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
579: IGS_GE_MSG_STACK.ADD;
580: app_exception.raise_exception;
581: end if;
582:

Line 785: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

781: begin
782: open c1;
783: fetch c1 into tlinfo;
784: if (c1%notfound) then
785: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
786: IGS_GE_MSG_STACK.ADD;
787: app_exception.raise_exception;
788: close c1;
789: return;

Line 867: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

863: AND (tlinfo.REPORTED_IND = X_REPORTED_IND)
864: ) then
865: null;
866: else
867: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
868: IGS_GE_MSG_STACK.ADD;
869: app_exception.raise_exception;
870: end if;
871: return;

Line 930: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

926: if X_LAST_UPDATE_LOGIN is NULL then
927: X_LAST_UPDATE_LOGIN := -1;
928: end if;
929: else
930: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
931: IGS_GE_MSG_STACK.ADD;
932: app_exception.raise_exception;
933: end if;
934: Before_DML (