eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RE_CANDIDATURE_PKG dependencies on APP_EXCEPTION

Line 48: App_Exception.Raise_Exception;

44: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
45: Close cur_old_ref_values;
46: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
47: IGS_GE_MSG_STACK.ADD;
48: App_Exception.Raise_Exception;
49: Return;
50: END IF;
51: Close cur_old_ref_values;
52: -- Populate New Values.

Line 148: App_Exception.Raise_Exception;

144: new_references.acai_sequence_number,
145: v_message_name) = FALSE THEN
146: Fnd_Message.Set_Name ('IGS', v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151: IF p_updating AND
152: new_references.sca_course_cd IS NOT NULL THEN

Line 160: App_Exception.Raise_Exception;

156: new_references.sca_course_cd,
157: v_message_name) = FALSE THEN
158: Fnd_Message.Set_Name ('IGS', v_message_name);
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: END IF;
163: -- Validation of submission dates can only be done in before row trigger
164: -- if p_inserting, or

Line 194: App_Exception.Raise_Exception;

190: v_message_name,
191: 'N') = FALSE THEN
192: Fnd_Message.Set_Name ('IGS', v_message_name);
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197: -- Validate maximum submission date
198: IF (p_inserting AND

Line 217: App_Exception.Raise_Exception;

213: v_message_name,
214: 'N') = FALSE THEN
215: Fnd_Message.Set_Name ('IGS', v_message_name);
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: END IF;
219: END IF;
220: END IF;
221: -- Validate govt type of activity code

Line 232: App_Exception.Raise_Exception;

228: new_references.govt_type_of_activity_cd,
229: v_message_name) = FALSE THEN
230: Fnd_Message.Set_Name ('IGS', v_message_name);
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: END IF;
234: END IF;
235: -- Validate research topic
236: IF p_inserting OR

Line 250: App_Exception.Raise_Exception;

246: v_message_name,
247: 'N') = FALSE THEN
248: Fnd_Message.Set_Name ('IGS', v_message_name);
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252: END IF;
253: END IF;
254:

Line 263: App_Exception.Raise_Exception;

259: old_references.sca_course_cd,
260: v_message_name) = FALSE THEN
261: Fnd_Message.Set_Name ('IGS', v_message_name);
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: -- Validate ACAI link.
266: IF IGS_RE_VAL_CA.resp_val_ca_acai_del (
267: old_references.person_id,

Line 274: App_Exception.Raise_Exception;

270: old_references.acai_sequence_number,
271: v_message_name) = FALSE THEN
272: Fnd_Message.Set_Name ('IGS', v_message_name);
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: END IF;
277: END BeforeRowInsertUpdateDelete2;
278:

Line 408: App_Exception.Raise_Exception;

404: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
405: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,'igs.plsql.igs_re_candidature_pkg.AfterStmtInsertUpdate5.ERR',FALSE);
406: END IF;
407: IGS_GE_MSG_STACK.ADD;
408: App_Exception.Raise_Exception;
409: END IF;
410: IF p_updating THEN
411: IF New_References.min_submission_dt IS NULL THEN
412: -- Validate derived minimum submission date

Line 427: App_Exception.Raise_Exception;

423: v_message_name,
424: 'N') = FALSE THEN
425: Fnd_Message.Set_Name ('IGS', v_message_name);
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: END IF;
430: IF New_References.max_submission_dt IS NULL THEN
431: -- Validate derived maximum submission date

Line 446: App_Exception.Raise_Exception;

442: v_message_name,
443: 'N') = FALSE THEN
444: Fnd_Message.Set_Name ('IGS', v_message_name);
445: IGS_GE_MSG_STACK.ADD;
446: App_Exception.Raise_Exception;
447: END IF;
448: END IF;
449: END IF;
450: -- Validate SCA and ACAI links

Line 470: App_Exception.Raise_Exception;

466: New_References.acai_sequence_number,
467: v_message_name) = FALSE THEN
468: Fnd_Message.Set_Name ('IGS', v_message_name);
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471: END IF;
472: END IF;
473: -- Validate ACAI link
474: IF p_inserting OR

Line 495: App_Exception.Raise_Exception;

491: New_References.acai_sequence_number,
492: v_message_name) = FALSE THEN
493: Fnd_Message.Set_Name ('IGS', v_message_name);
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception;
496: END IF;
497: END IF;
498: END IF;
499: END AfterStmtInsertUpdate5;

Line 526: App_Exception.Raise_Exception ;

522: IF upper(column_name) = 'ACAI_NOMINATED_COURSE_CD' OR COLUMN_NAME IS NULL THEN
523: IF new_references.ACAI_NOMINATED_COURSE_CD <> upper(NEW_REFERENCES.ACAI_NOMINATED_COURSE_CD) then
524: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
525: IGS_GE_MSG_STACK.ADD;
526: App_Exception.Raise_Exception ;
527: END IF;
528: END IF;
529: IF upper(column_name) = 'GOVT_TYPE_OF_ACTIVITY_CD' OR COLUMN_NAME IS NULL THEN
530: IF new_references.GOVT_TYPE_OF_ACTIVITY_CD <> upper(NEW_REFERENCES.GOVT_TYPE_OF_ACTIVITY_CD) then

Line 533: App_Exception.Raise_Exception ;

529: IF upper(column_name) = 'GOVT_TYPE_OF_ACTIVITY_CD' OR COLUMN_NAME IS NULL THEN
530: IF new_references.GOVT_TYPE_OF_ACTIVITY_CD <> upper(NEW_REFERENCES.GOVT_TYPE_OF_ACTIVITY_CD) then
531: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
532: IGS_GE_MSG_STACK.ADD;
533: App_Exception.Raise_Exception ;
534: END IF;
535: END IF;
536: IF upper(column_name) = 'SCA_COURSE_CD' OR COLUMN_NAME IS NULL THEN
537: IF new_references.SCA_COURSE_CD <> upper(NEW_REFERENCES.SCA_COURSE_CD) then

Line 540: App_Exception.Raise_Exception ;

536: IF upper(column_name) = 'SCA_COURSE_CD' OR COLUMN_NAME IS NULL THEN
537: IF new_references.SCA_COURSE_CD <> upper(NEW_REFERENCES.SCA_COURSE_CD) then
538: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
539: IGS_GE_MSG_STACK.ADD;
540: App_Exception.Raise_Exception ;
541: END IF;
542: END IF;
543: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
544: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then

Line 547: App_Exception.Raise_Exception ;

543: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
544: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then
545: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
546: IGS_GE_MSG_STACK.ADD;
547: App_Exception.Raise_Exception ;
548: END IF;
549: END IF;
550: IF upper(column_name) = 'ACAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
551: IF new_references.ACAI_SEQUENCE_NUMBER < 1 OR new_references.ACAI_SEQUENCE_NUMBER > 999999 then

Line 554: App_Exception.Raise_Exception ;

550: IF upper(column_name) = 'ACAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
551: IF new_references.ACAI_SEQUENCE_NUMBER < 1 OR new_references.ACAI_SEQUENCE_NUMBER > 999999 then
552: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
553: IGS_GE_MSG_STACK.ADD;
554: App_Exception.Raise_Exception ;
555: END IF;
556: END IF;
557: IF upper(column_name) = 'ATTENDANCE_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
558: IF new_references.ATTENDANCE_PERCENTAGE < 1 OR new_references.ATTENDANCE_PERCENTAGE > 100 then

Line 561: App_Exception.Raise_Exception ;

557: IF upper(column_name) = 'ATTENDANCE_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
558: IF new_references.ATTENDANCE_PERCENTAGE < 1 OR new_references.ATTENDANCE_PERCENTAGE > 100 then
559: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
560: IGS_GE_MSG_STACK.ADD;
561: App_Exception.Raise_Exception ;
562: END IF;
563: END IF;
564: END Check_Constraints ;
565:

Line 587: App_Exception.Raise_Exception;

583: new_references.acai_sequence_number
584: ) THEN
585: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
586: IGS_GE_MSG_STACK.ADD;
587: App_Exception.Raise_Exception;
588: END IF;
589: END IF;
590:
591: IF (((old_references.govt_type_of_activity_cd = new_references.govt_type_of_activity_cd)) OR

Line 600: App_Exception.Raise_Exception;

596: new_references.govt_type_of_activity_cd
597: ) THEN
598: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
599: IGS_GE_MSG_STACK.ADD;
600: App_Exception.Raise_Exception;
601: END IF;
602: END IF;
603: IF (((old_references.person_id = new_references.person_id)) OR
604: ((new_references.person_id IS NULL))) THEN

Line 612: App_Exception.Raise_Exception;

608: new_references.person_id
609: ) THEN
610: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
611: IGS_GE_MSG_STACK.ADD;
612: App_Exception.Raise_Exception;
613: END IF;
614: END IF;
615: IF (((old_references.person_id = new_references.person_id) AND
616: (old_references.sca_course_cd = new_references.sca_course_cd)) OR

Line 627: App_Exception.Raise_Exception;

623: new_references.sca_course_cd
624: ) THEN
625: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
626: IGS_GE_MSG_STACK.ADD;
627: App_Exception.Raise_Exception;
628: END IF;
629: END IF;
630: END Check_Parent_Existance;
631:

Line 710: App_Exception.Raise_Exception;

706: IF (cur_rowid%FOUND) THEN
707: Close cur_rowid;
708: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CA_ACAI_FK');
709: IGS_GE_MSG_STACK.ADD;
710: App_Exception.Raise_Exception;
711: Return;
712: END IF;
713: Close cur_rowid;
714: END GET_FK_IGS_AD_PS_APPL_INST;

Line 731: App_Exception.Raise_Exception;

727: IF (cur_rowid%FOUND) THEN
728: Close cur_rowid;
729: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CA_GTCC_FK');
730: IGS_GE_MSG_STACK.ADD;
731: App_Exception.Raise_Exception;
732: Return;
733: END IF;
734: Close cur_rowid;
735: END GET_FK_IGS_RE_GV_TOA_CLS_CD;

Line 751: App_Exception.Raise_Exception;

747: IF (cur_rowid%FOUND) THEN
748: Close cur_rowid;
749: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CA_PE_FK');
750: IGS_GE_MSG_STACK.ADD;
751: App_Exception.Raise_Exception;
752: Return;
753: END IF;
754: Close cur_rowid;
755: END GET_FK_IGS_PE_PERSON;

Line 774: App_Exception.Raise_Exception;

770: IF (cur_rowid%FOUND) THEN
771: Close cur_rowid;
772: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CA_SCA_FK');
773: IGS_GE_MSG_STACK.ADD;
774: App_Exception.Raise_Exception;
775: Return;
776: END IF;
777: Close cur_rowid;
778: END GET_FK_IGS_EN_STDNT_PS_ATT;

Line 841: App_Exception.Raise_Exception;

837: ) THEN
838:
839: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
840: IGS_GE_MSG_STACK.ADD;
841: App_Exception.Raise_Exception;
842: END IF;
843: Check_Constraints;
844: Check_Parent_Existance;
845:

Line 870: App_Exception.Raise_Exception;

866: ) THEN
867:
868: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
869: IGS_GE_MSG_STACK.ADD;
870: App_Exception.Raise_Exception;
871: END IF;
872: Check_Constraints;
873: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
874: Check_Constraints;

Line 967: app_exception.raise_exception;

963: end if;
964: else
965: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
966: IGS_GE_MSG_STACK.ADD;
967: app_exception.raise_exception;
968: end if;
969: Before_DML (
970: p_action => 'INSERT',
971: x_rowid => X_ROWID,

Line 1063: app_exception.raise_exception;

1059: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1060: fnd_message.set_token ('ERR_CD', SQLCODE);
1061: igs_ge_msg_stack.add;
1062: igs_sc_gen_001.unset_ctx('R');
1063: app_exception.raise_exception;
1064: ELSE
1065: igs_sc_gen_001.unset_ctx('R');
1066: RAISE;
1067: END IF;

Line 1106: app_exception.raise_exception;

1102: fetch c1 into tlinfo;
1103: if (c1%notfound) then
1104: close c1;
1105: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1106: app_exception.raise_exception;
1107: return;
1108: end if;
1109: close c1;
1110: if ( ((tlinfo.SCA_COURSE_CD = X_SCA_COURSE_CD)

Line 1144: app_exception.raise_exception;

1140: ) then
1141: null;
1142: else
1143: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1144: app_exception.raise_exception;
1145: end if;
1146: return;
1147: end LOCK_ROW;
1148: procedure UPDATE_ROW (

Line 1188: app_exception.raise_exception;

1184: end if;
1185: else
1186: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1187: IGS_GE_MSG_STACK.ADD;
1188: app_exception.raise_exception;
1189: end if;
1190: Before_DML (
1191: p_action => 'UPDATE',
1192: x_rowid => X_ROWID,

Line 1250: app_exception.raise_exception;

1246: if (sql%notfound) then
1247: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1248: igs_ge_msg_stack.add;
1249: igs_sc_gen_001.unset_ctx('R');
1250: app_exception.raise_exception;
1251: end if;
1252: IF (x_mode = 'S') THEN
1253: igs_sc_gen_001.unset_ctx('R');
1254: END IF;

Line 1267: app_exception.raise_exception;

1263: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1264: fnd_message.set_token ('ERR_CD', SQLCODE);
1265: igs_ge_msg_stack.add;
1266: igs_sc_gen_001.unset_ctx('R');
1267: app_exception.raise_exception;
1268: ELSE
1269: igs_sc_gen_001.unset_ctx('R');
1270: RAISE;
1271: END IF;

Line 1353: app_exception.raise_exception;

1349: if (sql%notfound) then
1350: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1351: igs_ge_msg_stack.add;
1352: igs_sc_gen_001.unset_ctx('R');
1353: app_exception.raise_exception;
1354: end if;
1355: IF (x_mode = 'S') THEN
1356: igs_sc_gen_001.unset_ctx('R');
1357: END IF;