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 APP_EXCEPTION

Line 44: App_Exception.Raise_Exception;

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;
48:

Line 86: App_Exception.Raise_Exception;

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
90: p_updating OR

Line 103: App_Exception.Raise_Exception;

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;
107:

Line 130: App_Exception.Raise_Exception ;

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
134: IF new_references.PERCENTAGE < 1 OR new_references.PERCENTAGE > 100 then

Line 137: App_Exception.Raise_Exception ;

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
141: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 9999999 then

Line 144: App_Exception.Raise_Exception ;

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 ;
148:

Line 164: App_Exception.Raise_Exception;

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:
168: IF (((old_references.SEO_CLASS_CD = new_references.seo_class_cd)) OR

Line 177: App_Exception.Raise_Exception;

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;
181:

Line 232: App_Exception.Raise_Exception;

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;
236:

Line 258: App_Exception.Raise_Exception;

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;
262:

Line 304: App_Exception.Raise_Exception;

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;
308: ELSIF (p_action = 'UPDATE') THEN

Line 324: App_Exception.Raise_Exception;

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
328: Check_Constraints;

Line 365: app_exception.raise_exception;

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 (
369: p_action => 'INSERT',

Line 425: app_exception.raise_exception;

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');
428: RAISE;
429: END IF;

Line 453: app_exception.raise_exception;

449: fetch c1 into tlinfo;
450: if (c1%notfound) then
451: close c1;
452: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
453: app_exception.raise_exception;
454: return;
455: end if;
456: close c1;
457:

Line 463: app_exception.raise_exception;

459: ) then
460: null;
461: else
462: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
463: app_exception.raise_exception;
464: end if;
465: return;
466: end LOCK_ROW;
467:

Line 496: app_exception.raise_exception;

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 (
500: p_action => 'UPDATE',

Line 527: app_exception.raise_exception;

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
530: igs_sc_gen_001.unset_ctx('R');
531: END IF;

Line 541: app_exception.raise_exception;

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');
544: RAISE;
545: END IF;

Line 605: app_exception.raise_exception;

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
608: igs_sc_gen_001.unset_ctx('R');
609: END IF;