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_CAND_SEO_CLS_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.seo_class_cd,
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 129: IGS_GE_MSG_STACK.ADD;

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

Line 136: IGS_GE_MSG_STACK.ADD;

132: END IF;
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: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 143: IGS_GE_MSG_STACK.ADD;

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

Line 163: IGS_GE_MSG_STACK.ADD;

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

Line 176: IGS_GE_MSG_STACK.ADD;

172: IF NOT IGS_RE_SEO_CLASS_CD_PKG.Get_PK_For_Validation (
173: new_references.seo_class_cd
174: ) THEN
175: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179: END IF;
180: END Check_Parent_Existance;

Line 231: IGS_GE_MSG_STACK.ADD;

227: Fetch cur_rowid INTO lv_rowid;
228: IF (cur_rowid%FOUND) THEN
229: Close cur_rowid;
230: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CSC_CA_FK');
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: Return;
234: END IF;
235: Close cur_rowid;

Line 257: IGS_GE_MSG_STACK.ADD;

253: Fetch cur_rowid INTO lv_rowid;
254: IF (cur_rowid%FOUND) THEN
255: Close cur_rowid;
256: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CSC_SCC_FK');
257: IGS_GE_MSG_STACK.ADD;
258: App_Exception.Raise_Exception;
259: Return;
260: END IF;
261: Close cur_rowid;

Line 303: IGS_GE_MSG_STACK.ADD;

299: new_references.ca_sequence_number,
300: new_references.seo_class_cd
301: ) THEN
302: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: Check_Constraints;
307: Check_Parent_Existance;

Line 323: IGS_GE_MSG_STACK.ADD;

319: new_references.ca_sequence_number,
320: new_references.seo_class_cd
321: ) THEN
322: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
323: IGS_GE_MSG_STACK.ADD;
324: App_Exception.Raise_Exception;
325: END IF;
326: Check_Constraints;
327: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 364: IGS_GE_MSG_STACK.ADD;

360: X_LAST_UPDATE_LOGIN := -1;
361: end if;
362: else
363: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
364: IGS_GE_MSG_STACK.ADD;
365: app_exception.raise_exception;
366: end if;
367:
368: Before_DML (

Line 423: igs_ge_msg_stack.add;

419: WHEN OTHERS THEN
420: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
421: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
422: fnd_message.set_token ('ERR_CD', SQLCODE);
423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: ELSE
427: igs_sc_gen_001.unset_ctx('R');

Line 495: IGS_GE_MSG_STACK.ADD;

491: X_LAST_UPDATE_LOGIN := -1;
492: end if;
493: else
494: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
495: IGS_GE_MSG_STACK.ADD;
496: app_exception.raise_exception;
497: end if;
498:
499: Before_DML (

Line 525: igs_ge_msg_stack.add;

521: where ROWID = X_ROWID;
522:
523: if (sql%notfound) then
524: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
525: igs_ge_msg_stack.add;
526: igs_sc_gen_001.unset_ctx('R');
527: app_exception.raise_exception;
528: end if;
529: IF (x_mode = 'S') THEN

Line 539: igs_ge_msg_stack.add;

535: WHEN OTHERS THEN
536: IF (SQLCODE = (-28115)) THEN
537: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
538: fnd_message.set_token ('ERR_CD', SQLCODE);
539: igs_ge_msg_stack.add;
540: igs_sc_gen_001.unset_ctx('R');
541: app_exception.raise_exception;
542: ELSE
543: igs_sc_gen_001.unset_ctx('R');

Line 603: igs_ge_msg_stack.add;

599: delete from IGS_RE_CAND_SEO_CLS
600: where ROWID = X_ROWID;
601: if (sql%notfound) then
602: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
603: igs_ge_msg_stack.add;
604: igs_sc_gen_001.unset_ctx('R');
605: app_exception.raise_exception;
606: end if;
607: IF (x_mode = 'S') THEN