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 FND_MESSAGE

Line 42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

38: Open cur_old_ref_values;
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;

Line 84: Fnd_Message.Set_Name ('IGS', v_message_name);

80: new_references.person_id,
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;

Line 101: Fnd_Message.Set_Name ('IGS', v_message_name);

97: IF IGS_RE_VAL_CAH.resp_val_ca_childupd (
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;

Line 128: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

124: END IF;
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;

Line 135: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

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

Line 142: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

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

Line 162: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

158: IF NOT IGS_RE_CANDIDATURE_PKG.Get_PK_For_Validation (
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;

Line 175: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

171: ELSE
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;

Line 230: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CSC_CA_FK');

226: Open cur_rowid;
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;

Line 256: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CSC_SCC_FK');

252: Open cur_rowid;
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;

Line 302: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

298: new_references.person_id,
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;

Line 322: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

318: new_references.person_id,
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;

Line 363: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

359: if X_LAST_UPDATE_LOGIN is NULL then
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:

Line 421: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

417: close c;
418: EXCEPTION
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;

Line 422: fnd_message.set_token ('ERR_CD', SQLCODE);

418: EXCEPTION
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

Line 452: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

448: open c1;
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;

Line 462: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

458: if ( (tlinfo.PERCENTAGE = X_PERCENTAGE)
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;

Line 494: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

490: if X_LAST_UPDATE_LOGIN is NULL then
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:

Line 524: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

520: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
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;

Line 537: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

533:
534: EXCEPTION
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;

Line 538: fnd_message.set_token ('ERR_CD', SQLCODE);

534: EXCEPTION
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

Line 602: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

598: END IF;
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;