DBA Data[Home] [Help]

APPS.IGS_AD_EDUGOAL_PKG dependencies on IGS_GE_MSG_STACK

Line 50: IGS_GE_MSG_STACK.ADD;

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

Line 123: IGS_GE_MSG_STACK.ADD;

119: ,new_references.person_id
120: ,new_references.sequence_number
121: ) THEN
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
123: IGS_GE_MSG_STACK.ADD;
124: app_exception.raise_exception;
125: END IF;
126: END Check_Uniqueness ;
127: PROCEDURE Check_Parent_Existance AS

Line 158: IGS_GE_MSG_STACK.ADD;

154: new_references.sequence_number
155: ) THEN
156: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161:
162: IF (((old_references.edu_goal_id = new_references.edu_goal_id)) OR

Line 172: IGS_GE_MSG_STACK.ADD;

168: 'N'
169: ) THEN
170: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EDUCATION_GOAL'));
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175:
176: END Check_Parent_Existance;

Line 292: IGS_GE_MSG_STACK.ADD;

288: Fetch cur_rowid INTO lv_rowid;
289: IF (cur_rowid%FOUND) THEN
290: Close cur_rowid;
291: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AEG_ACAI_FK');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: Return;
295: END IF;
296: Close cur_rowid;

Line 329: IGS_GE_MSG_STACK.ADD;

325: Fetch cur_rowid INTO lv_rowid;
326: IF (cur_rowid%FOUND) THEN
327: Close cur_rowid;
328: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AEG_ACDC_FK');
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: Return;
332: END IF;
333: Close cur_rowid;

Line 396: IGS_GE_MSG_STACK.ADD;

392: Null;
393: IF Get_Pk_For_Validation(
394: new_references.post_edugoal_id) THEN
395: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception;
398: END IF;
399: Check_Uniqueness;
400: Check_Constraints;

Line 416: IGS_GE_MSG_STACK.ADD;

412: -- Call all the procedures related to Before Insert.
413: IF Get_PK_For_Validation (
414: new_references.post_edugoal_id) THEN
415: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: END IF;
419: Check_Uniqueness;
420: Check_Constraints;

Line 506: IGS_GE_MSG_STACK.ADD;

502: X_LAST_UPDATE_LOGIN := -1;
503: end if;
504: else
505: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
506: IGS_GE_MSG_STACK.ADD;
507: app_exception.raise_exception;
508: end if;
509:
510: X_POST_EDUGOAL_ID := -1;

Line 580: IGS_GE_MSG_STACK.ADD;

576: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
577: -- that the ownerof policy function does not have privilege to access.
578: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
579: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
580: IGS_GE_MSG_STACK.ADD;
581: app_exception.raise_exception;
582: ELSE
583: RAISE;
584: END IF;

Line 620: IGS_GE_MSG_STACK.ADD;

616: open c1;
617: fetch c1 into tlinfo;
618: if (c1%notfound) then
619: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
620: IGS_GE_MSG_STACK.ADD;
621: close c1;
622: app_exception.raise_exception;
623: return;
624: end if;

Line 635: IGS_GE_MSG_STACK.ADD;

631: ) then
632: null;
633: else
634: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
635: IGS_GE_MSG_STACK.ADD;
636: app_exception.raise_exception;
637: end if;
638: return;
639: end LOCK_ROW;

Line 680: IGS_GE_MSG_STACK.ADD;

676: X_LAST_UPDATE_LOGIN := -1;
677: end if;
678: else
679: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
680: IGS_GE_MSG_STACK.ADD;
681: app_exception.raise_exception;
682: end if;
683: Before_DML(
684: p_action=>'UPDATE',

Line 712: igs_ge_msg_stack.add;

708: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
709: where ROWID = X_ROWID;
710: if (sql%notfound) then
711: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
712: igs_ge_msg_stack.add;
713: IF (x_mode = 'S') THEN
714: igs_sc_gen_001.unset_ctx('R');
715: END IF;
716: app_exception.raise_exception;

Line 740: IGS_GE_MSG_STACK.ADD;

736: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
737: -- that the ownerof policy function does not have privilege to access.
738: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
739: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
740: IGS_GE_MSG_STACK.ADD;
741: app_exception.raise_exception;
742: ELSE
743: RAISE;
744: END IF;

Line 824: igs_ge_msg_stack.add;

820: DELETE FROM IGS_AD_EDUGOAL
821: WHERE ROWID = X_ROWID;
822: if (sql%notfound) then
823: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
824: igs_ge_msg_stack.add;
825: IF (x_mode = 'S') THEN
826: igs_sc_gen_001.unset_ctx('R');
827: END IF;
828: app_exception.raise_exception;

Line 851: IGS_GE_MSG_STACK.ADD;

847: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
848: -- that the ownerof policy function does not have privilege to access.
849: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
850: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
851: IGS_GE_MSG_STACK.ADD;
852: app_exception.raise_exception;
853: ELSE
854: RAISE;
855: END IF;