DBA Data[Home] [Help]

APPS.IGS_AD_EDUGOAL_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

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

Line 124: app_exception.raise_exception;

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
128: /*************************************************************

Line 159: App_Exception.Raise_Exception;

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
163: ((new_references.edu_goal_id IS NULL))) THEN

Line 173: App_Exception.Raise_Exception;

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

Line 293: App_Exception.Raise_Exception;

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

Line 330: App_Exception.Raise_Exception;

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

Line 397: App_Exception.Raise_Exception;

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

Line 417: App_Exception.Raise_Exception;

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

Line 507: app_exception.raise_exception;

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;
511: Before_DML(

Line 581: app_exception.raise_exception;

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;
585: END INSERT_ROW;

Line 622: app_exception.raise_exception;

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;
625: close c1;
626: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 636: app_exception.raise_exception;

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;
640: Procedure UPDATE_ROW (

Line 681: app_exception.raise_exception;

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',
685: x_rowid=>X_ROWID,

Line 716: app_exception.raise_exception;

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;
717: end if;
718: IF (x_mode = 'S') THEN
719: igs_sc_gen_001.unset_ctx('R');
720: END IF;

Line 741: app_exception.raise_exception;

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;
745: END UPDATE_ROW;

Line 828: app_exception.raise_exception;

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;
829: END IF;
830: IF (x_mode = 'S') THEN
831: igs_sc_gen_001.unset_ctx('R');
832: END IF;

Line 852: app_exception.raise_exception;

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;
856: end DELETE_ROW;