APPS.IGS_PS_USEC_PRV_GRAD_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

45: Fetch cur_old_ref_values INTO old_references;
46: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
47: Close cur_old_ref_values;
48: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
49: IGS_GE_MSG_STACK.ADD;
50: App_Exception.Raise_Exception;
51: Return;
52: END IF;
53: Close cur_old_ref_values;

Line 120: IGS_GE_MSG_STACK.ADD;

116: ,new_references.uoo_id
117: ,new_references.grading_schema_code
118: ) THEN
119: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
120: IGS_GE_MSG_STACK.ADD;
121: app_exception.raise_exception;
122: END IF;
123: END Check_Uniqueness ;
124: PROCEDURE Check_Parent_Existance AS

Line 145: IGS_GE_MSG_STACK.ADD;

141: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
142: new_references.uoo_id
143: ) THEN
144: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148:
149: IF (((old_references.grading_schema_code = new_references.grading_schema_code) AND

Line 162: IGS_GE_MSG_STACK.ADD;

158: new_references.grading_schema_version_number,
159: new_references.grading_schema_value
160: ) THEN
161: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165:
166: END Check_Parent_Existance;

Line 274: IGS_GE_MSG_STACK.ADD;

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

Line 315: IGS_GE_MSG_STACK.ADD;

311: Fetch cur_rowid INTO lv_rowid;
312: IF (cur_rowid%FOUND) THEN
313: Close cur_rowid;
314: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USPG_GSG_FK');
315: IGS_GE_MSG_STACK.ADD;
316: App_Exception.Raise_Exception;
317: Return;
318: END IF;
319: Close cur_rowid;

Line 371: IGS_GE_MSG_STACK.ADD;

367: Null;
368: IF Get_Pk_For_Validation(
369: new_references.unit_section_prev_grade_id) THEN
370: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373: END IF;
374: Check_Uniqueness;
375: Check_Constraints;

Line 391: IGS_GE_MSG_STACK.ADD;

387: -- Call all the procedures related to Before Insert.
388: IF Get_PK_For_Validation (
389: new_references.unit_section_prev_grade_id) THEN
390: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
391: IGS_GE_MSG_STACK.ADD;
392: App_Exception.Raise_Exception;
393: END IF;
394: Check_Uniqueness;
395: Check_Constraints;

Line 479: IGS_GE_MSG_STACK.ADD;

475: X_LAST_UPDATE_LOGIN := -1;
476: end if;
477: else
478: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
479: IGS_GE_MSG_STACK.ADD;
480: app_exception.raise_exception;
481: end if;
482: select igs_ps_usec_prv_grad_s.nextval into x_unit_section_prev_grade_id from dual;
483: Before_DML(

Line 562: IGS_GE_MSG_STACK.ADD;

558: open c1;
559: fetch c1 into tlinfo;
560: if (c1%notfound) then
561: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
562: IGS_GE_MSG_STACK.ADD;
563: close c1;
564: app_exception.raise_exception;
565: return;
566: end if;

Line 576: IGS_GE_MSG_STACK.ADD;

572: ) then
573: null;
574: else
575: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: end if;
579: return;
580: end LOCK_ROW;

Line 620: IGS_GE_MSG_STACK.ADD;

616: X_LAST_UPDATE_LOGIN := -1;
617: end if;
618: else
619: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
620: IGS_GE_MSG_STACK.ADD;
621: app_exception.raise_exception;
622: end if;
623: Before_DML(
624: p_action=>'UPDATE',