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_THESIS_EXAM_PKG dependencies on IGS_GE_MSG_STACK

Line 50: IGS_GE_MSG_STACK.ADD;

46: Fetch cur_old_ref_values INTO old_references;
47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
48: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;

Line 97: IGS_GE_MSG_STACK.ADD;

93: -- Validate the IGS_RE_THESIS panel type
94: IF IGS_RE_VAL_TEX.resp_val_tex_tpt( new_references.thesis_panel_type,
95: v_message_name) = FALSE THEN
96: Fnd_Message.Set_Name ('IGS', v_message_name);
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
101: IF p_inserting OR

Line 108: IGS_GE_MSG_STACK.ADD;

104: -- Validate the IGS_RE_THESIS examination type
105: IF IGS_RE_VAL_TEX.resp_val_tex_tet( new_references.thesis_exam_type,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name ('IGS', v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112: END IF;

Line 236: IGS_GE_MSG_STACK.ADD;

232: v_transaction_type,
233: new_references.submission_dt,
234: v_message_name) = FALSE THEN
235: Fnd_Message.Set_Name ('IGS', v_message_name);
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: END IF;
239: IF NVL(NEW_REFERENCES.submission_dt,
240: igs_ge_date.igsdate('1900/01/01')) <>

Line 256: IGS_GE_MSG_STACK.ADD;

252: 'N', --p_legacy parameter
253: NULL, --final title indicator parameter
254: v_message_name) = FALSE THEN
255: Fnd_Message.Set_Name ('IGS', v_message_name);
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259: END IF;
260: -- Validate the IGS_RE_THESIS result code

Line 270: IGS_GE_MSG_STACK.ADD;

266: new_references.thesis_result_cd,
267: new_references.thesis_panel_type,
268: v_message_name) = FALSE THEN
269: Fnd_Message.Set_Name ('IGS', v_message_name);
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: ELSE -- Deleting!
274: -- Validate for deletion of IGS_RE_THESIS examination details.

Line 282: IGS_GE_MSG_STACK.ADD;

278: 'DELETE',
279: old_references.submission_dt,
280: v_message_name) = FALSE THEN
281: Fnd_Message.Set_Name ('IGS', v_message_name);
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: END IF;
286: END IF;

Line 314: IGS_GE_MSG_STACK.ADD;

310:
311: IF upper(column_name) = 'THE_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
312: IF new_references.THE_SEQUENCE_NUMBER < 1 OR new_references.THE_SEQUENCE_NUMBER > 999999 then
313: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
314: IGS_GE_MSG_STACK.ADD;
315: App_Exception.Raise_Exception ;
316: END IF;
317: END IF;
318: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 321: IGS_GE_MSG_STACK.ADD;

317: END IF;
318: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
319: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
320: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception ;
323: END IF;
324: END IF;
325: IF upper(column_name) = 'THESIS_EXAM_TYPE' OR COLUMN_NAME IS NULL THEN

Line 328: IGS_GE_MSG_STACK.ADD;

324: END IF;
325: IF upper(column_name) = 'THESIS_EXAM_TYPE' OR COLUMN_NAME IS NULL THEN
326: IF new_references.THESIS_EXAM_TYPE <> upper(NEW_REFERENCES.THESIS_EXAM_TYPE) then
327: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception ;
330: END IF;
331: END IF;
332: IF upper(column_name) = 'THESIS_PANEL_TYPE' OR COLUMN_NAME IS NULL THEN

Line 335: IGS_GE_MSG_STACK.ADD;

331: END IF;
332: IF upper(column_name) = 'THESIS_PANEL_TYPE' OR COLUMN_NAME IS NULL THEN
333: IF new_references.THESIS_PANEL_TYPE <> upper(NEW_REFERENCES.THESIS_PANEL_TYPE) then
334: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception ;
337: END IF;
338: END IF;
339: IF upper(column_name) = 'THESIS_RESULT_CD' OR COLUMN_NAME IS NULL THEN

Line 342: IGS_GE_MSG_STACK.ADD;

338: END IF;
339: IF upper(column_name) = 'THESIS_RESULT_CD' OR COLUMN_NAME IS NULL THEN
340: IF new_references.THESIS_RESULT_CD <> upper(NEW_REFERENCES.THESIS_RESULT_CD) then
341: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
342: IGS_GE_MSG_STACK.ADD;
343: App_Exception.Raise_Exception ;
344: END IF;
345: END IF;
346: END Check_Constraints ;

Line 360: IGS_GE_MSG_STACK.ADD;

356: IF NOT IGS_RE_THS_EXAM_TYPE_PKG.Get_PK_For_Validation (
357: new_references.thesis_exam_type
358: ) THEN
359: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
360: IGS_GE_MSG_STACK.ADD;
361: App_Exception.Raise_Exception;
362: END IF;
363: END IF;
364:

Line 379: IGS_GE_MSG_STACK.ADD;

375: new_references.ca_sequence_number,
376: new_references.the_sequence_number
377: ) THEN
378: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
379: IGS_GE_MSG_STACK.ADD;
380: App_Exception.Raise_Exception;
381: END IF;
382: END IF;
383:

Line 392: IGS_GE_MSG_STACK.ADD;

388: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (
389: new_references.thesis_result_cd
390: ) THEN
391: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
392: IGS_GE_MSG_STACK.ADD;
393: App_Exception.Raise_Exception;
394: END IF;
395: END IF;
396:

Line 405: IGS_GE_MSG_STACK.ADD;

401: IF NOT IGS_RE_THS_PNL_TYPE_PKG.Get_PK_For_Validation (
402: new_references.thesis_panel_type
403: ) THEN
404: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
405: IGS_GE_MSG_STACK.ADD;
406: App_Exception.Raise_Exception;
407: END IF;
408: END IF;
409:

Line 418: IGS_GE_MSG_STACK.ADD;

414: IF NOT IGS_TR_ITEM_PKG.Get_PK_For_Validation (
415: new_references.tracking_id
416: ) THEN
417: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
418: IGS_GE_MSG_STACK.ADD;
419: App_Exception.Raise_Exception;
420: END IF;
421: END IF;
422:

Line 488: IGS_GE_MSG_STACK.ADD;

484: Fetch cur_rowid INTO lv_rowid;
485: IF (cur_rowid%FOUND) THEN
486: Close cur_rowid;
487: Fnd_Message.Set_Name ('IGS', 'IGS_RE_TEX_TET_FK');
488: IGS_GE_MSG_STACK.ADD;
489: App_Exception.Raise_Exception;
490: Return;
491: END IF;
492: Close cur_rowid;

Line 518: IGS_GE_MSG_STACK.ADD;

514: Fetch cur_rowid INTO lv_rowid;
515: IF (cur_rowid%FOUND) THEN
516: Close cur_rowid;
517: Fnd_Message.Set_Name ('IGS', 'IGS_RE_TEX_THE_FK');
518: IGS_GE_MSG_STACK.ADD;
519: App_Exception.Raise_Exception;
520: Return;
521: END IF;
522: Close cur_rowid;

Line 544: IGS_GE_MSG_STACK.ADD;

540: Fetch cur_rowid INTO lv_rowid;
541: IF (cur_rowid%FOUND) THEN
542: Close cur_rowid;
543: Fnd_Message.Set_Name ('IGS', 'IGS_RE_TEX_THR_FK');
544: IGS_GE_MSG_STACK.ADD;
545: App_Exception.Raise_Exception;
546: Return;
547: END IF;
548: Close cur_rowid;

Line 570: IGS_GE_MSG_STACK.ADD;

566: Fetch cur_rowid INTO lv_rowid;
567: IF (cur_rowid%FOUND) THEN
568: Close cur_rowid;
569: Fnd_Message.Set_Name ('IGS', 'IGS_RE_TEX_TPT_FK');
570: IGS_GE_MSG_STACK.ADD;
571: App_Exception.Raise_Exception;
572: Return;
573: END IF;
574: Close cur_rowid;

Line 596: IGS_GE_MSG_STACK.ADD;

592: Fetch cur_rowid INTO lv_rowid;
593: IF (cur_rowid%FOUND) THEN
594: Close cur_rowid;
595: Fnd_Message.Set_Name ('IGS', 'IGS_RE_TEX_TRI_FK');
596: IGS_GE_MSG_STACK.ADD;
597: App_Exception.Raise_Exception;
598: Return;
599: END IF;
600: Close cur_rowid;

Line 657: IGS_GE_MSG_STACK.ADD;

653: new_references.creation_dt
654: ) THEN
655:
656: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
657: IGS_GE_MSG_STACK.ADD;
658: App_Exception.Raise_Exception;
659: END IF;
660: Check_Constraints;
661: Check_Parent_Existance;

Line 760: IGS_GE_MSG_STACK.ADD;

756: X_LAST_UPDATE_LOGIN := -1;
757: end if;
758: else
759: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
760: IGS_GE_MSG_STACK.ADD;
761: app_exception.raise_exception;
762: end if;
763:
764: Before_DML (

Line 841: igs_ge_msg_stack.add;

837: WHEN OTHERS THEN
838: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
839: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
840: fnd_message.set_token ('ERR_CD', SQLCODE);
841: igs_ge_msg_stack.add;
842: igs_sc_gen_001.unset_ctx('R');
843: app_exception.raise_exception;
844: ELSE
845: igs_sc_gen_001.unset_ctx('R');

Line 937: IGS_GE_MSG_STACK.ADD;

933: X_LAST_UPDATE_LOGIN := -1;
934: end if;
935: else
936: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
937: IGS_GE_MSG_STACK.ADD;
938: app_exception.raise_exception;
939: end if;
940:
941: Before_DML (

Line 976: igs_ge_msg_stack.add;

972: where ROWID = X_ROWID
973: ;
974: if (sql%notfound) then
975: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
976: igs_ge_msg_stack.add;
977: igs_sc_gen_001.unset_ctx('R');
978: app_exception.raise_exception;
979: end if;
980: IF (x_mode = 'S') THEN

Line 995: igs_ge_msg_stack.add;

991: WHEN OTHERS THEN
992: IF (SQLCODE = (-28115)) THEN
993: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
994: fnd_message.set_token ('ERR_CD', SQLCODE);
995: igs_ge_msg_stack.add;
996: igs_sc_gen_001.unset_ctx('R');
997: app_exception.raise_exception;
998: ELSE
999: igs_sc_gen_001.unset_ctx('R');

Line 1076: igs_ge_msg_stack.add;

1072: delete from IGS_RE_THESIS_EXAM
1073: where ROWID = X_ROWID;
1074: if (sql%notfound) then
1075: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1076: igs_ge_msg_stack.add;
1077: igs_sc_gen_001.unset_ctx('R');
1078: app_exception.raise_exception;
1079: end if;
1080: IF (x_mode = 'S') THEN