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

Line 43: IGS_GE_MSG_STACK.ADD;

39: Fetch cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
41: Close cur_old_ref_values;
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Return;
46: END IF;
47: Close cur_old_ref_values;

Line 85: IGS_GE_MSG_STACK.ADD;

81: new_references.ca_sequence_number,
82: new_references.FIELD_OF_STUDY,
83: v_message_name) = FALSE THEN
84: Fnd_Message.Set_Name ('IGS', v_message_name);
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89: IF p_inserting OR

Line 102: IGS_GE_MSG_STACK.ADD;

98: new_references.person_id,
99: new_references.ca_sequence_number,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name ('IGS', v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106: END IF;

Line 128: IGS_GE_MSG_STACK.ADD;

124:
125: IF upper(column_name) = 'FIELD_OF_STUDY' OR COLUMN_NAME IS NULL THEN
126: IF new_references.FIELD_OF_STUDY <> upper(new_references.FIELD_OF_STUDY) then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131: END IF;
132:

Line 136: IGS_GE_MSG_STACK.ADD;

132:
133: IF upper(column_name) = 'PERCENTAGE' OR COLUMN_NAME IS NULL THEN
134: IF new_references.PERCENTAGE < 1 OR new_references.PERCENTAGE > 100 THEN
135: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception ;
138: END IF;
139: END IF;
140:

Line 144: IGS_GE_MSG_STACK.ADD;

140:
141: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
142: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
143: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception ;
146: END IF;
147: END IF;
148:

Line 166: IGS_GE_MSG_STACK.ADD;

162: new_references.person_id,
163: new_references.ca_sequence_number
164: ) THEN
165: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: END IF;
170:

Line 179: IGS_GE_MSG_STACK.ADD;

175: IF NOT IGS_PS_FLD_OF_STUDY_PKG.Get_PK_For_Validation (
176: new_references.field_of_study
177: ) THEN
178: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:

Line 237: IGS_GE_MSG_STACK.ADD;

233: Fetch cur_rowid INTO lv_rowid;
234: IF (cur_rowid%FOUND) THEN
235: Close cur_rowid;
236: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CAFOS_CA_FK');
237: IGS_GE_MSG_STACK.ADD;
238: App_Exception.Raise_Exception;
239: Return;
240: END IF;
241: Close cur_rowid;

Line 285: IGS_GE_MSG_STACK.ADD;

281: new_references.field_of_study
282: ) THEN
283:
284: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
285: IGS_GE_MSG_STACK.ADD;
286: App_Exception.Raise_Exception;
287: END IF;
288: Check_Constraints;
289: Check_Parent_Existance;

Line 306: IGS_GE_MSG_STACK.ADD;

302: new_references.field_of_study
303: ) THEN
304:
305: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: END IF;
309: Check_Constraints;
310: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 346: IGS_GE_MSG_STACK.ADD;

342: X_LAST_UPDATE_LOGIN := -1;
343: end if;
344: else
345: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
346: IGS_GE_MSG_STACK.ADD;
347: app_exception.raise_exception;
348: end if;
349:
350: Before_DML (

Line 406: igs_ge_msg_stack.add;

402: WHEN OTHERS THEN
403: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
404: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
405: fnd_message.set_token ('ERR_CD', SQLCODE);
406: igs_ge_msg_stack.add;
407: igs_sc_gen_001.unset_ctx('R');
408: app_exception.raise_exception;
409: ELSE
410: igs_sc_gen_001.unset_ctx('R');

Line 478: IGS_GE_MSG_STACK.ADD;

474: X_LAST_UPDATE_LOGIN := -1;
475: end if;
476: else
477: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
478: IGS_GE_MSG_STACK.ADD;
479: app_exception.raise_exception;
480: end if;
481:
482: Before_DML (

Line 508: igs_ge_msg_stack.add;

504: where ROWID = X_ROWID;
505:
506: if (sql%notfound) then
507: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
508: igs_ge_msg_stack.add;
509: igs_sc_gen_001.unset_ctx('R');
510: app_exception.raise_exception;
511: end if;
512: IF (x_mode = 'S') THEN

Line 522: igs_ge_msg_stack.add;

518: WHEN OTHERS THEN
519: IF (SQLCODE = (-28115)) THEN
520: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
521: fnd_message.set_token ('ERR_CD', SQLCODE);
522: igs_ge_msg_stack.add;
523: igs_sc_gen_001.unset_ctx('R');
524: app_exception.raise_exception;
525: ELSE
526: igs_sc_gen_001.unset_ctx('R');

Line 588: igs_ge_msg_stack.add;

584: where ROWID = X_ROWID;
585:
586: if (sql%notfound) then
587: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
588: igs_ge_msg_stack.add;
589: igs_sc_gen_001.unset_ctx('R');
590: app_exception.raise_exception;
591: end if;
592: IF (x_mode = 'S') THEN