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_SPRVSR_PKG dependencies on APP_EXCEPTION

Line 55: App_Exception.Raise_Exception;

51: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
52: Close cur_old_ref_values;
53: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
54: IGS_GE_MSG_STACK.ADD;
55: App_Exception.Raise_Exception;
56: Return;
57: END IF;
58: Close cur_old_ref_values;
59:

Line 128: App_Exception.Raise_Exception;

124: new_references.ca_sequence_number,
125: v_message_name) = FALSE THEN
126: Fnd_Message.Set_Name ('IGS', v_message_name);
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131: IF p_inserting THEN
132: -- Validate IGS_PE_PERSON

Line 140: App_Exception.Raise_Exception;

136: p_legacy,
137: v_message_name) = FALSE THEN
138: Fnd_Message.Set_Name ('IGS', v_message_name);
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;
141: END IF;
142: END IF;
143: IF p_inserting OR
144: p_updating THEN

Line 154: App_Exception.Raise_Exception;

150: new_references.research_supervisor_type,
151: v_message_name) = FALSE THEN
152: Fnd_Message.Set_Name ('IGS', v_message_name);
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: END IF;
156: END IF;
157: -- Validate funding percentage
158: IF p_inserting OR

Line 172: App_Exception.Raise_Exception;

168: NULL, -- staff member indicator
169: v_message_name) = FALSE THEN
170: Fnd_Message.Set_Name ('IGS', v_message_name);
171: IGS_GE_MSG_STACK.ADD;
172: App_Exception.Raise_Exception;
173:
174: END IF;
175: */
176: -- This code has been commented because the validation has

Line 199: App_Exception.Raise_Exception;

195: p_legacy,
196: v_message_name) = FALSE THEN
197: Fnd_Message.Set_Name ('IGS', v_message_name);
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202: END IF;
203: END IF;

Line 217: App_Exception.Raise_Exception;

213: old_references.ca_sequence_number,
214: v_message_name) = 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:
221:

Line 258: App_Exception.Raise_Exception;

254: p_legacy,
255: v_message_name) = FALSE THEN
256: Fnd_Message.Set_Name ('IGS', v_message_name);
257: IGS_GE_MSG_STACK.ADD;
258: App_Exception.Raise_Exception;
259: END IF;
260: END IF;
261:
262: -- Validate research supervisor overlapping periods

Line 280: App_Exception.Raise_Exception;

276: p_legacy,
277: v_message_name) = FALSE THEN
278: Fnd_Message.Set_Name ('IGS', v_message_name);
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: END IF;
283:
284: -- Validate replaced supervisor

Line 304: App_Exception.Raise_Exception;

300: p_legacy,
301: v_message_name) = FALSE THEN
302: Fnd_Message.Set_Name ('IGS', v_message_name);
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: END IF;
307: END IF;
308:

Line 337: App_Exception.Raise_Exception;

333: V_supervision_start_dt,
334: v_message_name) = FALSE THEN
335: Fnd_Message.Set_Name ('IGS', v_message_name);
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;
339: */
340: NULL;
341: -- This code has been commented out NOCOPY because the validations have

Line 368: App_Exception.Raise_Exception;

364: v_supervision_start_dt,
365: v_message_name) = FALSE THEN
366: Fnd_Message.Set_Name ('IGS', v_message_name);
367: IGS_GE_MSG_STACK.ADD;
368: App_Exception.Raise_Exception;
369: END IF;*/
370: -- This code has been commented out NOCOPY because this
371: -- validation is done at the library .
372: NULL;

Line 443: App_Exception.Raise_Exception ;

439: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
440: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
441: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
442: IGS_GE_MSG_STACK.ADD;
443: App_Exception.Raise_Exception ;
444: END IF;
445: END IF;
446: IF upper(column_name) = 'SUPERVISION_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
447: IF new_references.SUPERVISION_PERCENTAGE < 0 OR new_references.SUPERVISION_PERCENTAGE > 100 then

Line 450: App_Exception.Raise_Exception ;

446: IF upper(column_name) = 'SUPERVISION_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
447: IF new_references.SUPERVISION_PERCENTAGE < 0 OR new_references.SUPERVISION_PERCENTAGE > 100 then
448: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
449: IGS_GE_MSG_STACK.ADD;
450: App_Exception.Raise_Exception ;
451: END IF;
452: END IF;
453: IF upper(column_name) = 'REPLACED_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
454: IF new_references.REPLACED_SEQUENCE_NUMBER < 1 OR new_references.REPLACED_SEQUENCE_NUMBER > 999999 then

Line 457: App_Exception.Raise_Exception ;

453: IF upper(column_name) = 'REPLACED_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
454: IF new_references.REPLACED_SEQUENCE_NUMBER < 1 OR new_references.REPLACED_SEQUENCE_NUMBER > 999999 then
455: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
456: IGS_GE_MSG_STACK.ADD;
457: App_Exception.Raise_Exception ;
458: END IF;
459: END IF;
460: IF upper(column_name) = 'FUNDING_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
461: IF new_references.FUNDING_PERCENTAGE < 0 OR new_references.FUNDING_PERCENTAGE > 100 then

Line 464: App_Exception.Raise_Exception ;

460: IF upper(column_name) = 'FUNDING_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
461: IF new_references.FUNDING_PERCENTAGE < 0 OR new_references.FUNDING_PERCENTAGE > 100 then
462: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
463: IGS_GE_MSG_STACK.ADD;
464: App_Exception.Raise_Exception ;
465: END IF;
466: END IF;
467: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
468: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then

Line 471: App_Exception.Raise_Exception ;

467: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
468: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then
469: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
470: IGS_GE_MSG_STACK.ADD;
471: App_Exception.Raise_Exception ;
472: END IF;
473: END IF;
474:
475: IF upper(column_name) = 'RESEARCH_SUPERVISOR_TYPE' OR COLUMN_NAME IS NULL THEN

Line 479: App_Exception.Raise_Exception ;

475: IF upper(column_name) = 'RESEARCH_SUPERVISOR_TYPE' OR COLUMN_NAME IS NULL THEN
476: IF new_references.RESEARCH_SUPERVISOR_TYPE <> upper(NEW_REFERENCES.RESEARCH_SUPERVISOR_TYPE) then
477: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
478: IGS_GE_MSG_STACK.ADD;
479: App_Exception.Raise_Exception ;
480: END IF;
481: END IF;
482: IF upper(column_name) = 'SUPERVISOR_PROFESSION' OR COLUMN_NAME IS NULL THEN
483: IF new_references.SUPERVISOR_PROFESSION <> upper(NEW_REFERENCES.SUPERVISOR_PROFESSION) then

Line 486: App_Exception.Raise_Exception ;

482: IF upper(column_name) = 'SUPERVISOR_PROFESSION' OR COLUMN_NAME IS NULL THEN
483: IF new_references.SUPERVISOR_PROFESSION <> upper(NEW_REFERENCES.SUPERVISOR_PROFESSION) then
484: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception ;
487: END IF;
488: END IF;
489: END Check_Constraints ;
490:

Line 501: App_Exception.Raise_Exception;

497: new_references.start_dt
498: ) THEN
499: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
500: IGS_GE_MSG_STACK.ADD;
501: App_Exception.Raise_Exception;
502: END IF;
503:
504: END Check_Uniqueness;
505:

Line 521: App_Exception.Raise_Exception;

517: new_references.ca_sequence_number
518: ) THEN
519: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
520: IGS_GE_MSG_STACK.ADD;
521: App_Exception.Raise_Exception;
522: END IF;
523: END IF;
524:
525: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND

Line 537: App_Exception.Raise_Exception;

533: new_references.ou_start_dt
534: ) THEN
535: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
536: IGS_GE_MSG_STACK.ADD;
537: App_Exception.Raise_Exception;
538: END IF;
539: END IF;
540:
541: IF (((old_references.person_id = new_references.person_id)) OR

Line 550: App_Exception.Raise_Exception;

546: new_references.person_id
547: ) THEN
548: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
549: IGS_GE_MSG_STACK.ADD;
550: App_Exception.Raise_Exception;
551: END IF;
552: END IF;
553:
554: IF (((old_references.research_supervisor_type = new_references.research_supervisor_type)) OR

Line 563: App_Exception.Raise_Exception;

559: new_references.research_supervisor_type
560: ) THEN
561: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
562: IGS_GE_MSG_STACK.ADD;
563: App_Exception.Raise_Exception;
564: END IF;
565: END IF;
566:
567: IF (((old_references.ca_person_id = new_references.ca_person_id) AND

Line 585: App_Exception.Raise_Exception;

581: new_references.replaced_sequence_number
582: ) THEN
583: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
584: IGS_GE_MSG_STACK.ADD;
585: App_Exception.Raise_Exception;
586: END IF;
587: END IF;
588:
589: END Check_Parent_Existance;

Line 691: App_Exception.Raise_Exception;

687: IF (cur_rowid%FOUND) THEN
688: Close cur_rowid;
689: Fnd_Message.Set_Name ('IGS', 'IGS_RE_RSUP_CA_FK');
690: IGS_GE_MSG_STACK.ADD;
691: App_Exception.Raise_Exception;
692: Return;
693: END IF;
694: Close cur_rowid;
695:

Line 719: App_Exception.Raise_Exception;

715: IF (cur_rowid%FOUND) THEN
716: Close cur_rowid;
717: Fnd_Message.Set_Name ('IGS', 'IGS_RE_RSUP_OU_FK');
718: IGS_GE_MSG_STACK.ADD;
719: App_Exception.Raise_Exception;
720: Return;
721: END IF;
722: Close cur_rowid;
723:

Line 745: App_Exception.Raise_Exception;

741: IF (cur_rowid%FOUND) THEN
742: Close cur_rowid;
743: Fnd_Message.Set_Name ('IGS', 'IGS_RE_RSUP_PE_FK');
744: IGS_GE_MSG_STACK.ADD;
745: App_Exception.Raise_Exception;
746: Return;
747: END IF;
748: Close cur_rowid;
749:

Line 771: App_Exception.Raise_Exception;

767: IF (cur_rowid%FOUND) THEN
768: Close cur_rowid;
769: Fnd_Message.Set_Name ('IGS', 'IGS_RE_RSUP_RST_FK');
770: IGS_GE_MSG_STACK.ADD;
771: App_Exception.Raise_Exception;
772: Return;
773: END IF;
774: Close cur_rowid;
775:

Line 803: App_Exception.Raise_Exception;

799: IF (cur_rowid%FOUND) THEN
800: Close cur_rowid;
801: Fnd_Message.Set_Name ('IGS', 'IGS_RE_RSUP_RSUP_FK');
802: IGS_GE_MSG_STACK.ADD;
803: App_Exception.Raise_Exception;
804: Return;
805: END IF;
806: Close cur_rowid;
807:

Line 875: App_Exception.Raise_Exception;

871: new_references.sequence_number
872: ) THEN
873: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
874: IGS_GE_MSG_STACK.ADD;
875: App_Exception.Raise_Exception;
876: END IF;
877: Check_Uniqueness;
878: Check_Constraints;
879: Check_Parent_Existance;

Line 905: App_Exception.Raise_Exception;

901: new_references.sequence_number
902: ) THEN
903: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
904: IGS_GE_MSG_STACK.ADD;
905: App_Exception.Raise_Exception;
906: END IF;
907: Check_Uniqueness;
908: Check_Constraints;
909: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 984: app_exception.raise_exception;

980: end if;
981: else
982: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
983: IGS_GE_MSG_STACK.ADD;
984: app_exception.raise_exception;
985: end if;
986:
987: Before_DML (
988: p_action => 'INSERT',

Line 1083: app_exception.raise_exception;

1079: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1080: fnd_message.set_token ('ERR_CD', SQLCODE);
1081: igs_ge_msg_stack.add;
1082: igs_sc_gen_001.unset_ctx('R');
1083: app_exception.raise_exception;
1084: ELSE
1085: igs_sc_gen_001.unset_ctx('R');
1086: RAISE;
1087: END IF;

Line 1131: app_exception.raise_exception;

1127: open c1;
1128: fetch c1 into tlinfo;
1129: if (c1%notfound) then
1130: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1131: app_exception.raise_exception;
1132: close c1;
1133: return;
1134: end if;
1135: close c1;

Line 1170: app_exception.raise_exception;

1166: ) then
1167: null;
1168: else
1169: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1170: app_exception.raise_exception;
1171: end if;
1172: return;
1173: end LOCK_ROW;
1174:

Line 1214: app_exception.raise_exception;

1210: end if;
1211: else
1212: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1213: IGS_GE_MSG_STACK.ADD;
1214: app_exception.raise_exception;
1215: end if;
1216:
1217: Before_DML (
1218: p_action => 'UPDATE',

Line 1266: app_exception.raise_exception;

1262: if (sql%notfound) then
1263: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1264: igs_ge_msg_stack.add;
1265: igs_sc_gen_001.unset_ctx('R');
1266: app_exception.raise_exception;
1267: end if;
1268: IF (x_mode = 'S') THEN
1269: igs_sc_gen_001.unset_ctx('R');
1270: END IF;

Line 1285: app_exception.raise_exception;

1281: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1282: fnd_message.set_token ('ERR_CD', SQLCODE);
1283: igs_ge_msg_stack.add;
1284: igs_sc_gen_001.unset_ctx('R');
1285: app_exception.raise_exception;
1286: ELSE
1287: igs_sc_gen_001.unset_ctx('R');
1288: RAISE;
1289: END IF;

Line 1385: app_exception.raise_exception;

1381: if (sql%notfound) then
1382: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1383: igs_ge_msg_stack.add;
1384: igs_sc_gen_001.unset_ctx('R');
1385: app_exception.raise_exception;
1386: end if;
1387: IF (x_mode = 'S') THEN
1388: igs_sc_gen_001.unset_ctx('R');
1389: END IF;