DBA Data[Home] [Help]

APPS.IGS_PS_ANL_LOAD_PKG dependencies on FND_MESSAGE

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

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

Line 168: Fnd_Message.Set_Name('IGS',v_message_name);

164: IF IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl (
165: v_course_cd,
166: v_version_number,
167: v_message_name) = FALSE THEN
168: Fnd_Message.Set_Name('IGS',v_message_name);
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172: -- Validate effective start date and effective end date.

Line 183: Fnd_Message.Set_Name('IGS',v_message_name);

179: IF igs_ad_val_edtl.genp_val_strt_end_dt (
180: new_references.effective_start_dt,
181: new_references.effective_end_dt,
182: v_message_name) = FALSE THEN
183: Fnd_Message.Set_Name('IGS',v_message_name);
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: END IF;

Line 216: Fnd_Message.Set_Name('IGS',v_message_name);

212: NEW_REFERENCES.version_number,
213: NEW_REFERENCES.yr_num,
214: NEW_REFERENCES.effective_start_dt,
215: v_message_name) = FALSE THEN
216: Fnd_Message.Set_Name('IGS',v_message_name);
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: END IF;
220: END IF;

Line 245: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

241:
242: IF upper(column_name) = 'COURSE_CD' OR
243: column_name is null Then
244: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
245: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: END IF;
249: END IF;

Line 254: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

250:
251: IF upper(column_name) = 'YR_NUM' OR
252: column_name is null Then
253: IF ( new_references.yr_num < 0 OR new_references.yr_num > 999 ) Then
254: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: END IF;
258: END IF;

Line 263: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

259:
260: IF upper(column_name) = 'ANNUAL_LOAD_VAL' OR
261: column_name is null Then
262: IF ( new_references.annual_load_val < 0 OR new_references.annual_load_val > 9999.999 ) Then
263: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
264: IGS_GE_MSG_STACK.ADD;
265: App_Exception.Raise_Exception;
266: END IF;
267: END IF;

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

279: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
280: new_references.course_cd,
281: new_references.version_number
282: ) THEN
283: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: END IF;
287: END IF;

Line 355: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CAL_CRV_FK');

351: Open cur_rowid;
352: Fetch cur_rowid INTO lv_rowid;
353: IF (cur_rowid%FOUND) THEN
354: Close cur_rowid;
355: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CAL_CRV_FK');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: Return;
359: END IF;

Line 401: fnd_message.set_name('IGS','IGS_PS_OVERLAP_PERIODS');

397: --Added by sarakshi bug#2473015, to validate the logic of dates overlap
398: IF p_action IN ( 'INSERT', 'VALIDATE_INSERT','UPDATE','VALIDATE_UPDATE') THEN
399: IF NOT validate_overlapping(x_course_cd , x_version_number,x_yr_num ,
400: x_effective_start_dt , x_effective_end_dt,x_rowid ) THEN
401: fnd_message.set_name('IGS','IGS_PS_OVERLAP_PERIODS');
402: igs_ge_msg_stack.add;
403: app_exception.raise_exception;
404: END IF;
405: END IF;

Line 416: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

412: new_references.course_cd,
413: new_references.version_number,
414: new_references.yr_num,
415: new_references.effective_start_dt) THEN
416: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Constraints;

Line 437: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

433: new_references.course_cd,
434: new_references.version_number,
435: new_references.yr_num,
436: new_references.effective_start_dt) THEN
437: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
438: IGS_GE_MSG_STACK.ADD;
439: App_Exception.Raise_Exception;
440: END IF;
441: Check_Constraints;

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

489: if X_LAST_UPDATE_LOGIN is NULL then
490: X_LAST_UPDATE_LOGIN := -1;
491: end if;
492: else
493: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497:

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

573: open c1;
574: fetch c1 into tlinfo;
575: if (c1%notfound) then
576: close c1;
577: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
578: IGS_GE_MSG_STACK.ADD;
579: app_exception.raise_exception;
580: return;
581: end if;

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

587: AND (tlinfo.ANNUAL_LOAD_VAL = X_ANNUAL_LOAD_VAL)
588: ) then
589: null;
590: else
591: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
592: IGS_GE_MSG_STACK.ADD;
593: app_exception.raise_exception;
594: end if;
595: return;

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

622: if X_LAST_UPDATE_LOGIN is NULL then
623: X_LAST_UPDATE_LOGIN := -1;
624: end if;
625: else
626: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
627: IGS_GE_MSG_STACK.ADD;
628: app_exception.raise_exception;
629: end if;
630: