DBA Data[Home] [Help]

APPS.IGS_EN_INST_WLST_OPT_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 118: IGS_GE_MSG_STACK.ADD;

114: new_references.cal_type
115:
116: ) THEN
117: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
118: IGS_GE_MSG_STACK.ADD;
119: app_exception.raise_exception;
120: END IF;
121: END Check_Uniqueness ;
122: PROCEDURE Check_Parent_Existance AS

Line 146: IGS_GE_MSG_STACK.ADD;

142: new_references.cal_type
143:
144: ) THEN
145: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:
150: END Check_Parent_Existance;

Line 256: IGS_GE_MSG_STACK.ADD;

252: Fetch cur_rowid INTO lv_rowid;
253: IF (cur_rowid%FOUND) THEN
254: Close cur_rowid;
255: Fnd_Message.Set_Name ('IGS', 'IGS_EN_OUW_OU_FK');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: Return;
259: END IF;
260: Close cur_rowid;

Line 299: IGS_GE_MSG_STACK.ADD;

295: Fetch cur_rowid INTO lv_rowid;
296: IF (cur_rowid%FOUND) THEN
297: Close cur_rowid;
298: Fnd_Message.Set_Name ('IGS', 'IGS_EN_OUW_OU_FK');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: Return;
302: END IF;
303: Close cur_rowid; */

Line 357: IGS_GE_MSG_STACK.ADD;

353: Null;
354: IF Get_Pk_For_Validation(
355: new_references.inst_waitlist_id) THEN
356: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359: END IF;
360: Check_Uniqueness;
361: Check_Constraints;

Line 377: IGS_GE_MSG_STACK.ADD;

373: -- Call all the procedures related to Before Insert.
374: IF Get_PK_For_Validation (
375: new_references.inst_waitlist_id) THEN
376: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception;
379: END IF;
380: Check_Uniqueness;
381: Check_Constraints;

Line 465: IGS_GE_MSG_STACK.ADD;

461: X_LAST_UPDATE_LOGIN := -1;
462: end if;
463: else
464: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: end if;
468: select IGS_EN_INST_WLST_OPT_S.nextval into x_inst_waitlist_id from dual;
469: Before_DML(

Line 548: IGS_GE_MSG_STACK.ADD;

544: open c1;
545: fetch c1 into tlinfo;
546: if (c1%notfound) then
547: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
548: IGS_GE_MSG_STACK.ADD;
549: close c1;
550: app_exception.raise_exception;
551: return;
552: end if;

Line 562: IGS_GE_MSG_STACK.ADD;

558: ) then
559: null;
560: else
561: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
562: IGS_GE_MSG_STACK.ADD;
563: app_exception.raise_exception;
564: end if;
565: return;
566: end LOCK_ROW;

Line 605: IGS_GE_MSG_STACK.ADD;

601: X_LAST_UPDATE_LOGIN := -1;
602: end if;
603: else
604: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
605: IGS_GE_MSG_STACK.ADD;
606: app_exception.raise_exception;
607: end if;
608: Before_DML(
609: p_action=>'UPDATE',