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

Line 56: IGS_GE_MSG_STACK.ADD;

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

Line 145: IGS_GE_MSG_STACK.ADD;

141: NVL(old_references.comments,' ') <> NVL(new_references.comments,' ') THEN
142: IF IGS_RE_VAL_THE.resp_val_the_upd(new_references.logical_delete_dt,
143: v_message_name) = FALSE THEN
144: Fnd_Message.Set_Name ('IGS', v_message_name);
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149: END IF;

Line 160: IGS_GE_MSG_STACK.ADD;

156: new_references.final_title_ind,
157: v_thesis_status,
158: v_message_name) = FALSE THEN
159: Fnd_Message.Set_Name ('IGS', v_message_name);
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: END IF;
164: -- Validate the IGS_RE_THESIS IGS_PE_TITLE

Line 171: IGS_GE_MSG_STACK.ADD;

167: new_references.title,
168: old_references.thesis_result_cd,
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: END IF;
174: END IF;
175: END IF;

Line 189: IGS_GE_MSG_STACK.ADD;

185: v_thesis_status,
186: 'N', --p_legacy parameter
187: v_message_name) = FALSE THEN
188: Fnd_Message.Set_Name ('IGS', v_message_name);
189: IGS_GE_MSG_STACK.ADD;
190: App_Exception.Raise_Exception;
191: END IF;
192: END IF;
193: IF p_inserting OR

Line 201: IGS_GE_MSG_STACK.ADD;

197: IF IGS_RE_VAL_THE.resp_val_the_ctn( v_thesis_status,
198: new_references.citation,
199: v_message_name) = FALSE THEN
200: Fnd_Message.Set_Name ('IGS', v_message_name);
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: END IF;
204: END IF;
205: IF p_inserting OR

Line 220: IGS_GE_MSG_STACK.ADD;

216: new_references.library_lodgement_dt,
217: v_thesis_status,
218: v_message_name) = FALSE THEN
219: Fnd_Message.Set_Name ('IGS', v_message_name);
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: END IF;
223: END IF;
224: IF p_inserting OR

Line 236: IGS_GE_MSG_STACK.ADD;

232: v_thesis_status,
233: 'N', --p_legacy parameter
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: END IF;
240: IF p_updating THEN

Line 249: IGS_GE_MSG_STACK.ADD;

245: new_references.logical_delete_dt,
246: v_thesis_status,
247: v_message_name) = 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;

Line 261: IGS_GE_MSG_STACK.ADD;

257: IF IGS_RE_VAL_THE.resp_val_the_del_dt( old_references.logical_delete_dt,
258: new_references.logical_delete_dt,
259: v_message_name) = FALSE THEN
260: Fnd_Message.Set_Name ('IGS', v_message_name);
261: IGS_GE_MSG_STACK.ADD;
262: App_Exception.Raise_Exception;
263: END IF;
264: END IF;
265: IF p_inserting OR

Line 276: IGS_GE_MSG_STACK.ADD;

272: new_references.expected_submission_dt,
273: 'N', --p_legacy
274: v_message_name) = FALSE THEN
275: Fnd_Message.Set_Name ('IGS', v_message_name);
276: IGS_GE_MSG_STACK.ADD;
277: App_Exception.Raise_Exception;
278: END IF;
279: END IF;
280: END IF;

Line 388: IGS_GE_MSG_STACK.ADD;

384: END IF;
385: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
386: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
387: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
388: IGS_GE_MSG_STACK.ADD;
389: App_Exception.Raise_Exception ;
390: END IF;
391: END IF;
392: IF upper(column_name) = 'FINAL_TITLE_IND' OR COLUMN_NAME IS NULL THEN

Line 396: IGS_GE_MSG_STACK.ADD;

392: IF upper(column_name) = 'FINAL_TITLE_IND' OR COLUMN_NAME IS NULL THEN
393: IF new_references.FINAL_TITLE_IND <> upper(NEW_REFERENCES.FINAL_TITLE_IND) OR
394: new_references.FINAL_TITLE_IND NOT IN ('Y', 'N') then
395: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception ;
398: END IF;
399: END IF;
400: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 403: IGS_GE_MSG_STACK.ADD;

399: END IF;
400: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
401: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then
402: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
403: IGS_GE_MSG_STACK.ADD;
404: App_Exception.Raise_Exception ;
405: END IF;
406: END IF;
407: IF upper(column_name) = 'LIBRARY_CATALOGUE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 410: IGS_GE_MSG_STACK.ADD;

406: END IF;
407: IF upper(column_name) = 'LIBRARY_CATALOGUE_NUMBER' OR COLUMN_NAME IS NULL THEN
408: IF new_references.LIBRARY_CATALOGUE_NUMBER <> NEW_REFERENCES.LIBRARY_CATALOGUE_NUMBER then
409: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception ;
412: END IF;
413: END IF;
414: IF upper(column_name) = 'THESIS_FORMAT' OR COLUMN_NAME IS NULL THEN

Line 417: IGS_GE_MSG_STACK.ADD;

413: END IF;
414: IF upper(column_name) = 'THESIS_FORMAT' OR COLUMN_NAME IS NULL THEN
415: IF new_references.THESIS_FORMAT <> NEW_REFERENCES.THESIS_FORMAT then
416: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception ;
419: END IF;
420: END IF;
421: IF upper(column_name) = 'THESIS_RESULT_CD' OR COLUMN_NAME IS NULL THEN

Line 441: IGS_GE_MSG_STACK.ADD;

437: new_references.person_id,
438: new_references.ca_sequence_number
439: ) THEN
440: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
441: IGS_GE_MSG_STACK.ADD;
442: App_Exception.Raise_Exception;
443: END IF;
444: END IF;
445: IF (((old_references.thesis_result_cd = new_references.thesis_result_cd)) OR

Line 453: IGS_GE_MSG_STACK.ADD;

449: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (
450: new_references.thesis_result_cd
451: ) THEN
452: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
453: IGS_GE_MSG_STACK.ADD;
454: App_Exception.Raise_Exception;
455: END IF;
456: END IF;
457: END Check_Parent_Existance;

Line 506: IGS_GE_MSG_STACK.ADD;

502: Fetch cur_rowid INTO lv_rowid;
503: IF (cur_rowid%FOUND) THEN
504: Close cur_rowid;
505: Fnd_Message.Set_Name ('IGS', 'IGS_RE_THE_CA_FK');
506: IGS_GE_MSG_STACK.ADD;
507: App_Exception.Raise_Exception;
508: Return;
509: END IF;
510: Close cur_rowid;

Line 526: IGS_GE_MSG_STACK.ADD;

522: Fetch cur_rowid INTO lv_rowid;
523: IF (cur_rowid%FOUND) THEN
524: Close cur_rowid;
525: Fnd_Message.Set_Name ('IGS', 'IGS_RE_THE_THR_FK');
526: IGS_GE_MSG_STACK.ADD;
527: App_Exception.Raise_Exception;
528: Return;
529: END IF;
530: Close cur_rowid;

Line 600: IGS_GE_MSG_STACK.ADD;

596: new_references.ca_sequence_number,
597: new_references.sequence_number
598: ) THEN
599: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
600: IGS_GE_MSG_STACK.ADD;
601: App_Exception.Raise_Exception;
602: END IF;
603: Check_Constraints;
604: Check_Parent_Existance;

Line 622: IGS_GE_MSG_STACK.ADD;

618: new_references.ca_sequence_number,
619: new_references.sequence_number
620: ) THEN
621: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
622: IGS_GE_MSG_STACK.ADD;
623: App_Exception.Raise_Exception;
624: END IF;
625: Check_Constraints;
626: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 702: IGS_GE_MSG_STACK.ADD;

698: X_LAST_UPDATE_LOGIN := -1;
699: end if;
700: else
701: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
702: IGS_GE_MSG_STACK.ADD;
703: app_exception.raise_exception;
704: end if;
705: Before_DML (
706: p_action => 'INSERT',

Line 810: igs_ge_msg_stack.add;

806: WHEN OTHERS THEN
807: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
808: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
809: fnd_message.set_token ('ERR_CD', SQLCODE);
810: igs_ge_msg_stack.add;
811: igs_sc_gen_001.unset_ctx('R');
812: app_exception.raise_exception;
813: ELSE
814: igs_sc_gen_001.unset_ctx('R');

Line 961: IGS_GE_MSG_STACK.ADD;

957: X_LAST_UPDATE_LOGIN := -1;
958: end if;
959: else
960: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
961: IGS_GE_MSG_STACK.ADD;
962: app_exception.raise_exception;
963: end if;
964: Before_DML (
965: p_action => 'UPDATE',

Line 1017: igs_ge_msg_stack.add;

1013: where ROWID = X_ROWID
1014: ;
1015: if (sql%notfound) then
1016: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1017: igs_ge_msg_stack.add;
1018: igs_sc_gen_001.unset_ctx('R');
1019: app_exception.raise_exception;
1020: end if;
1021: IF (x_mode = 'S') THEN

Line 1034: igs_ge_msg_stack.add;

1030: WHEN OTHERS THEN
1031: IF (SQLCODE = (-28115)) THEN
1032: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1033: fnd_message.set_token ('ERR_CD', SQLCODE);
1034: igs_ge_msg_stack.add;
1035: igs_sc_gen_001.unset_ctx('R');
1036: app_exception.raise_exception;
1037: ELSE
1038: igs_sc_gen_001.unset_ctx('R');

Line 1139: igs_ge_msg_stack.add;

1135: delete from IGS_RE_THESIS_ALL
1136: where ROWID = X_ROWID;
1137: if (sql%notfound) then
1138: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1139: igs_ge_msg_stack.add;
1140: igs_sc_gen_001.unset_ctx('R');
1141: app_exception.raise_exception;
1142: end if;
1143: IF (x_mode = 'S') THEN