DBA Data[Home] [Help]

APPS.IGS_AD_APP_INTENT_PKG dependencies on APP_EXCEPTION

Line 71: App_Exception.Raise_Exception;

67: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
68: Close cur_old_ref_values;
69: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
70: IGS_GE_MSG_STACK.ADD;
71: App_Exception.Raise_Exception;
72: Return;
73: END IF;
74: Close cur_old_ref_values;
75:

Line 158: app_exception.raise_exception;

154: ,new_references.person_id
155: ) THEN
156: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
157: IGS_GE_MSG_STACK.ADD;
158: app_exception.raise_exception;
159: END IF;
160: END Check_Uniqueness ;
161: PROCEDURE Check_Parent_Existance AS
162: /*************************************************************

Line 186: App_Exception.Raise_Exception;

182: ) THEN
183: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTENT_TYPE'));
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;
188:
189: IF (((old_references.person_id = new_references.person_id) AND
190: (old_references.admission_appl_number = new_references.admission_appl_number) ) OR

Line 201: App_Exception.Raise_Exception;

197: ) THEN
198: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203:
204: END Check_Parent_Existance;
205:

Line 310: App_Exception.Raise_Exception;

306: IF (cur_rowid%FOUND) THEN
307: Close cur_rowid;
308: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAINT_ACDC_FK');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: Return;
312: END IF;
313: Close cur_rowid;
314:

Line 349: App_Exception.Raise_Exception;

345: IF (cur_rowid%FOUND) THEN
346: Close cur_rowid;
347: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAINT_ACAI_FK');
348: IGS_GE_MSG_STACK.ADD;
349: App_Exception.Raise_Exception;
350: Return;
351: END IF;
352: Close cur_rowid;
353:

Line 453: App_Exception.Raise_Exception;

449: IF Get_Pk_For_Validation(
450: new_references.app_intent_id) THEN
451: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception;
454: END IF;
455: Check_Uniqueness;
456: Check_Constraints;
457: Check_Parent_Existance;

Line 473: App_Exception.Raise_Exception;

469: IF Get_PK_For_Validation (
470: new_references.app_intent_id) THEN
471: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
472: IGS_GE_MSG_STACK.ADD;
473: App_Exception.Raise_Exception;
474: END IF;
475: Check_Uniqueness;
476: Check_Constraints;
477: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 598: app_exception.raise_exception;

594: end if;
595: else
596: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: end if;
600:
601: X_APP_INTENT_ID := -1;
602: Before_DML(

Line 737: app_exception.raise_exception;

733: -- that the ownerof policy function does not have privilege to access.
734: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
735: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
736: IGS_GE_MSG_STACK.ADD;
737: app_exception.raise_exception;
738: ELSE
739: RAISE;
740: END IF;
741: END INSERT_ROW;

Line 816: app_exception.raise_exception;

812: if (c1%notfound) then
813: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
814: IGS_GE_MSG_STACK.ADD;
815: close c1;
816: app_exception.raise_exception;
817: return;
818: end if;
819: close c1;
820: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 891: app_exception.raise_exception;

887: null;
888: else
889: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
890: IGS_GE_MSG_STACK.ADD;
891: app_exception.raise_exception;
892: end if;
893: return;
894: end LOCK_ROW;
895: Procedure UPDATE_ROW (

Line 959: app_exception.raise_exception;

955: end if;
956: else
957: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
958: IGS_GE_MSG_STACK.ADD;
959: app_exception.raise_exception;
960: end if;
961: Before_DML(
962: p_action=>'UPDATE',
963: x_rowid=>X_ROWID,

Line 1051: app_exception.raise_exception;

1047: igs_ge_msg_stack.add;
1048: IF (x_mode = 'S') THEN
1049: igs_sc_gen_001.unset_ctx('R');
1050: END IF;
1051: app_exception.raise_exception;
1052: END IF;
1053: IF (x_mode = 'S') THEN
1054: igs_sc_gen_001.unset_ctx('R');
1055: END IF;

Line 1076: app_exception.raise_exception;

1072: -- that the ownerof policy function does not have privilege to access.
1073: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1074: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1075: IGS_GE_MSG_STACK.ADD;
1076: app_exception.raise_exception;
1077: ELSE
1078: RAISE;
1079: END IF;
1080: END UPDATE_ROW;

Line 1220: app_exception.raise_exception;

1216: igs_ge_msg_stack.add;
1217: IF (x_mode = 'S') THEN
1218: igs_sc_gen_001.unset_ctx('R');
1219: END IF;
1220: app_exception.raise_exception;
1221: end if;
1222: IF (x_mode = 'S') THEN
1223: igs_sc_gen_001.unset_ctx('R');
1224: END IF;

Line 1244: app_exception.raise_exception;

1240: -- that the ownerof policy function does not have privilege to access.
1241: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1242: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1243: IGS_GE_MSG_STACK.ADD;
1244: app_exception.raise_exception;
1245: ELSE
1246: RAISE;
1247: END IF;
1248: end DELETE_ROW;