DBA Data[Home] [Help]

APPS.IGS_AD_APPL_EVAL_PKG dependencies on IGS_GE_MSG_STACK

Line 59: IGS_GE_MSG_STACK.ADD;

55: Fetch cur_old_ref_values INTO old_references;
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;

Line 124: IGS_GE_MSG_STACK.ADD;

120: IF Upper(Column_Name) = 'ASSIGN_TYPE' OR
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:

Line 153: IGS_GE_MSG_STACK.ADD;

149: ELSIF NOT Igs_Ad_Rs_Values_Pkg.Get_PK_For_Validation (
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

Line 165: IGS_GE_MSG_STACK.ADD;

161: new_references.rating_type_id,
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

Line 185: IGS_GE_MSG_STACK.ADD;

181: new_references.nominated_course_cd,
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

Line 196: IGS_GE_MSG_STACK.ADD;

192: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
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;

Line 269: IGS_GE_MSG_STACK.ADD;

265: Fetch cur_rowid INTO lv_rowid;
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;

Line 306: IGS_GE_MSG_STACK.ADD;

302: Fetch cur_rowid INTO lv_rowid;
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;

Line 349: IGS_GE_MSG_STACK.ADD;

345: Fetch cur_rowid INTO lv_rowid;
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;

Line 386: IGS_GE_MSG_STACK.ADD;

382: Fetch cur_rowid INTO lv_rowid;
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;

Line 423: IGS_GE_MSG_STACK.ADD;

419: Fetch cur_rowid INTO lv_rowid;
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;

Line 476: IGS_GE_MSG_STACK.ADD;

472: x_sequence_number );
473: FETCH c_get_outcome_status INTO c_get_outcome_status_rec;
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');

Line 481: 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;
483: App_Exception.Raise_Exception;
484: END IF;
485: CLOSE c_get_outcome_status;

Line 565: IGS_GE_MSG_STACK.ADD;

561: Null;
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;

Line 593: IGS_GE_MSG_STACK.ADD;

589: -- Call all the procedures related to Before Insert.
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 (

Line 819: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

815: END IF; /* c_appl_revprof */
816:
817: EXCEPTION
818: WHEN OTHERS THEN
819: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
820:
821: IF c_appl_revprof%ISOPEN THEN
822: CLOSE c_appl_revprof;
823: END IF;

Line 900: IGS_GE_MSG_STACK.ADD;

896: X_PROGRAM_UPDATE_DATE := SYSDATE;
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;

Line 1009: IGS_GE_MSG_STACK.ADD;

1005: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;

Line 1071: igs_ge_msg_stack.add;

1067: OPEN c1;
1068: FETCH c1 INTO tlinfo;
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;

Line 1097: igs_ge_msg_stack.add;

1093: ) THEN
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;

Line 1159: IGS_GE_MSG_STACK.ADD;

1155: X_LAST_UPDATE_LOGIN := -1;
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',

Line 1228: igs_ge_msg_stack.add;

1224: closed_ind = x_closed_ind
1225: WHERE rowid = x_rowid;
1226: IF (sql%NOTFOUND) THEN
1227: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
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;

Line 1271: IGS_GE_MSG_STACK.ADD;

1267: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;

Line 1523: igs_ge_msg_stack.add;

1519: DELETE FROM igs_ad_appl_eval
1520: WHERE rowid = x_rowid;
1521: IF (sql%NOTFOUND) THEN
1522: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
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;

Line 1559: IGS_GE_MSG_STACK.ADD;

1555: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;