DBA Data[Home] [Help]

APPS.IGS_AD_APPL_EVAL_PKG dependencies on APP_EXCEPTION

Line 60: App_Exception.Raise_Exception;

56: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
57: Close cur_old_ref_values;
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: App_Exception.Raise_Exception;
61: Return;
62: END IF;
63: Close cur_old_ref_values;
64:

Line 125: App_Exception.Raise_Exception;

121: Column_Name IS NULL THEN
122: IF NOT (new_references.assign_type IN ('M','A')) THEN
123: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:
129:

Line 154: App_Exception.Raise_Exception;

150: new_references.rating_values_id ,
151: 'N' ) THEN
152: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: END IF;
156:
157: IF (((old_references.rating_type_id = new_references.rating_type_id)) OR
158: ((new_references.rating_type_id IS NULL))) THEN

Line 166: App_Exception.Raise_Exception;

162: 'RATING_TYPE',
163: 'N' ) THEN
164: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168:
169: IF (((old_references.person_id = new_references.person_id) AND
170: (old_references.admission_appl_number = new_references.admission_appl_number) AND

Line 186: App_Exception.Raise_Exception;

182: new_references.sequence_number
183: ) THEN
184: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;
188:
189: IF (((old_references.evaluator_id = new_references.evaluator_id)) OR
190: ((new_references.evaluator_id IS NULL))) THEN

Line 197: App_Exception.Raise_Exception;

193: new_references.evaluator_id
194: ) THEN
195: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199:
200: END Check_Parent_Existance;
201:

Line 270: App_Exception.Raise_Exception;

266: IF (cur_rowid%FOUND) THEN
267: Close cur_rowid;
268: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAE_ARV_FK');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: Return;
272: END IF;
273: Close cur_rowid;
274:

Line 307: App_Exception.Raise_Exception;

303: IF (cur_rowid%FOUND) THEN
304: Close cur_rowid;
305: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAE_ACDC_FK');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: Return;
309: END IF;
310: Close cur_rowid;
311:

Line 350: App_Exception.Raise_Exception;

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

Line 387: App_Exception.Raise_Exception;

383: IF (cur_rowid%FOUND) THEN
384: Close cur_rowid;
385: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAE_PE_FK');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388: Return;
389: END IF;
390: Close cur_rowid;
391:

Line 424: App_Exception.Raise_Exception;

420: IF (cur_rowid%FOUND) THEN
421: Close cur_rowid;
422: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAE_ARS_FK');
423: IGS_GE_MSG_STACK.ADD;
424: App_Exception.Raise_Exception;
425: Return;
426: END IF;
427: Close cur_rowid;
428:

Line 478: App_Exception.Raise_Exception;

474: IF IGS_AD_GEN_008.ADMP_GET_SAOS(c_get_outcome_status_rec.adm_outcome_status) IN ('VOIDED','WITHDRAWN','NO-QUOTA','OFFER','OFFER-FUTURE-TERM') THEN
475: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INS_UPD_EVAL_OUT');
476: IGS_GE_MSG_STACK.ADD;
477: CLOSE c_get_outcome_status;
478: App_Exception.Raise_Exception;
479: ELSIF IGS_AD_GEN_008.ADMP_GET_SAOS(c_get_outcome_status_rec.adm_outcome_status) = 'REJECTED' AND c_get_outcome_status_rec.req_for_reconsideration_ind = 'N' THEN
480: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INS_UPD_EVAL_REQ');
481: IGS_GE_MSG_STACK.ADD;
482: CLOSE c_get_outcome_status;

Line 483: App_Exception.Raise_Exception;

479: ELSIF IGS_AD_GEN_008.ADMP_GET_SAOS(c_get_outcome_status_rec.adm_outcome_status) = 'REJECTED' AND c_get_outcome_status_rec.req_for_reconsideration_ind = 'N' THEN
480: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INS_UPD_EVAL_REQ');
481: IGS_GE_MSG_STACK.ADD;
482: CLOSE c_get_outcome_status;
483: App_Exception.Raise_Exception;
484: END IF;
485: CLOSE c_get_outcome_status;
486:
487: END Check_Outcome_Status;

Line 566: App_Exception.Raise_Exception;

562: IF Get_Pk_For_Validation(
563: new_references.appl_eval_id) THEN
564: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
565: IGS_GE_MSG_STACK.ADD;
566: App_Exception.Raise_Exception;
567: END IF;
568: Check_Constraints;
569: Check_Parent_Existance;
570: Check_Outcome_Status (

Line 594: App_Exception.Raise_Exception;

590: IF Get_PK_For_Validation (
591: new_references.appl_eval_id) THEN
592: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
593: IGS_GE_MSG_STACK.ADD;
594: App_Exception.Raise_Exception;
595: END IF;
596: Check_Constraints;
597: Check_Outcome_Status (
598: new_references.person_id,

Line 901: app_exception.raise_exception;

897: end if;
898: else
899: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
900: IGS_GE_MSG_STACK.ADD;
901: app_exception.raise_exception;
902: end if;
903:
904: X_APPL_EVAL_ID := -1;
905: Before_DML(

Line 1010: app_exception.raise_exception;

1006: -- that the ownerof policy function does not have privilege to access.
1007: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1008: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1009: IGS_GE_MSG_STACK.ADD;
1010: app_exception.raise_exception;
1011: ELSE
1012: RAISE;
1013: END IF;
1014: END insert_row;

Line 1073: app_exception.raise_exception;

1069: IF (c1%notfound) THEN
1070: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1071: igs_ge_msg_stack.add;
1072: CLOSE c1;
1073: app_exception.raise_exception;
1074: RETURN;
1075: END IF;
1076: CLOSE c1;
1077:

Line 1098: app_exception.raise_exception;

1094: NULL;
1095: ELSE
1096: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1097: igs_ge_msg_stack.add;
1098: app_exception.raise_exception;
1099: END IF;
1100:
1101: RETURN;
1102:

Line 1160: app_exception.raise_exception;

1156: end if;
1157: else
1158: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1159: IGS_GE_MSG_STACK.ADD;
1160: app_exception.raise_exception;
1161: end if;
1162: Before_DML(
1163: p_action=>'UPDATE',
1164: x_rowid=>X_ROWID,

Line 1232: app_exception.raise_exception;

1228: igs_ge_msg_stack.add;
1229: IF (x_mode = 'S') THEN
1230: igs_sc_gen_001.unset_ctx('R');
1231: END IF;
1232: app_exception.raise_exception;
1233: END IF;
1234: IF (x_mode = 'S') THEN
1235: igs_sc_gen_001.unset_ctx('R');
1236: END IF;

Line 1272: app_exception.raise_exception;

1268: -- that the ownerof policy function does not have privilege to access.
1269: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1270: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1271: IGS_GE_MSG_STACK.ADD;
1272: app_exception.raise_exception;
1273: ELSE
1274: RAISE;
1275: END IF;
1276: END update_row;

Line 1527: app_exception.raise_exception;

1523: igs_ge_msg_stack.add;
1524: IF (x_mode = 'S') THEN
1525: igs_sc_gen_001.unset_ctx('R');
1526: END IF;
1527: app_exception.raise_exception;
1528: END IF;
1529: IF (x_mode = 'S') THEN
1530: igs_sc_gen_001.unset_ctx('R');
1531: END IF;

Line 1560: app_exception.raise_exception;

1556: -- that the ownerof policy function does not have privilege to access.
1557: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1558: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1559: IGS_GE_MSG_STACK.ADD;
1560: app_exception.raise_exception;
1561: ELSE
1562: RAISE;
1563: END IF;
1564: END delete_row;