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_PS_REF_CD_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 99: app_exception.raise_exception;

95: v_version_number,
96: v_message_name) = FALSE THEN
97: fnd_message.set_name('IGS',v_message_name);
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101: -- Validate reference code type.
102: IF p_inserting OR
103: (p_updating AND

Line 110: app_exception.raise_exception;

106: new_references.reference_cd_type,
107: v_message_name) = FALSE THEN
108: fnd_message.set_name('IGS',v_message_name);
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112: END IF;
113: IF p_updating THEN
114: IF NVL(old_references.description,'NULL') <>

Line 137: app_exception.raise_exception;

133: IF p_deleting THEN
134: IF igs_ps_val_atl.chk_mandatory_ref_cd(old_references.reference_cd_type) THEN
135: fnd_message.set_name ('IGS', 'IGS_PS_REF_CD_MANDATORY');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139: -- Create history record for deletion
140: igs_ps_gen_007.crsp_ins_crc_hist(
141: old_references.course_cd,

Line 187: app_exception.raise_exception;

183: new_references.reference_cd_type
184: )THEN
185: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189: END check_uniqueness;
190:
191:

Line 211: app_exception.raise_exception;

207: column_name IS NULL THEN
208: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
209: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: END IF;
213: END IF;
214:
215: IF UPPER(column_name)= 'REFERENCE_CD' OR

Line 220: app_exception.raise_exception;

216: column_name IS NULL THEN
217: IF new_references.reference_cd <> UPPER(new_references.reference_cd) THEN
218: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
219: igs_ge_msg_stack.add;
220: app_exception.raise_exception;
221: END IF;
222: END IF;
223:
224: IF UPPER(column_name)= 'REFERENCE_CD_TYPE' OR

Line 229: app_exception.raise_exception;

225: column_name IS NULL THEN
226: IF new_references.reference_cd_type <> UPPER(new_references.reference_cd_type) THEN
227: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: END IF;
231: END IF;
232:
233: END check_constraints;

Line 250: app_exception.raise_exception;

246: new_references.version_number
247: )THEN
248: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: END IF;
252: END IF;
253: IF (((old_references.reference_cd_type = new_references.reference_cd_type)) OR
254:

Line 262: app_exception.raise_exception;

258: IF NOT igs_ge_ref_cd_type_pkg.get_pk_for_validation (
259: new_references.reference_cd_type )THEN
260: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: END IF;
265: END check_parent_existance;
266:

Line 351: app_exception.raise_exception;

347: IF (cur_rowid%FOUND) THEN
348: CLOSE cur_rowid;
349: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_CRV_FK');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: RETURN;
353: END IF;
354: CLOSE cur_rowid;
355:

Line 377: app_exception.raise_exception;

373: IF (cur_rowid%FOUND) THEN
374: CLOSE cur_rowid;
375: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_RCT_FK');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: RETURN;
379: END IF;
380: CLOSE cur_rowid;
381:

Line 416: app_exception.raise_exception;

412: IF (cur_rowid%FOUND) THEN
413: CLOSE cur_rowid;
414: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_RC_FK');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: RETURN;
418: END IF;
419: CLOSE cur_rowid;
420:

Line 466: app_exception.raise_exception;

462: new_references.reference_cd
463: ) THEN
464: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: check_uniqueness;
469: check_constraints;
470: check_parent_existance;

Line 488: app_exception.raise_exception;

484: new_references.reference_cd_type ,
485: new_references.reference_cd ) THEN
486: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: check_uniqueness;
491: check_constraints;
492: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 555: app_exception.raise_exception;

551: END IF;
552: ELSE
553: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
554: igs_ge_msg_stack.add;
555: app_exception.raise_exception;
556: END IF;
557: before_dml (
558: p_action => 'INSERT',
559: x_rowid => x_rowid,

Line 630: app_exception.raise_exception;

626: IF (c1%NOTFOUND) THEN
627: CLOSE c1;
628: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: RETURN;
632: END IF;
633: CLOSE c1;
634:

Line 643: app_exception.raise_exception;

639: NULL;
640: ELSE
641: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
642: igs_ge_msg_stack.add;
643: app_exception.raise_exception;
644: END IF;
645: RETURN;
646: END lock_row;
647:

Line 677: app_exception.raise_exception;

673: END IF;
674: ELSE
675: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
676: igs_ge_msg_stack.add;
677: app_exception.raise_exception;
678: END IF;
679: before_dml (
680: p_action => 'UPDATE',
681: x_rowid => x_rowid,