DBA Data[Home] [Help]

APPS.IGS_PS_ANL_LOAD_PKG dependencies on IGS_GE_MSG_STACK

Line 41: IGS_GE_MSG_STACK.ADD;

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;
45: Close cur_old_ref_values;

Line 169: IGS_GE_MSG_STACK.ADD;

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.
173: IF p_inserting OR p_updating THEN

Line 184: IGS_GE_MSG_STACK.ADD;

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;
188: END IF;

Line 217: IGS_GE_MSG_STACK.ADD;

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;
221:

Line 246: IGS_GE_MSG_STACK.ADD;

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;
250:

Line 255: IGS_GE_MSG_STACK.ADD;

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;
259:

Line 264: IGS_GE_MSG_STACK.ADD;

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;
268: END Check_Constraints;

Line 284: IGS_GE_MSG_STACK.ADD;

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;
288:

Line 356: IGS_GE_MSG_STACK.ADD;

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;
360: Close cur_rowid;

Line 402: igs_ge_msg_stack.add;

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;
406:

Line 417: IGS_GE_MSG_STACK.ADD;

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;
421: Check_Parent_Existance;

Line 438: IGS_GE_MSG_STACK.ADD;

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;
442: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 494: IGS_GE_MSG_STACK.ADD;

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:
498: Before_DML (

Line 578: IGS_GE_MSG_STACK.ADD;

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;
582: close c1;

Line 592: IGS_GE_MSG_STACK.ADD;

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;
596: end LOCK_ROW;

Line 627: IGS_GE_MSG_STACK.ADD;

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:
631: Before_DML (