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_PE_CREDENTIALS_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
58:

Line 107: App_Exception.Raise_Exception;

103: ) THEN
104: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_RATING'));
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109:
110:
111: IF (((old_references.credential_type_id = new_references.credential_type_id)) OR

Line 121: App_Exception.Raise_Exception;

117: ) THEN
118: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
119: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CREDENTIAL_TYPE'));
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123: END check_parent_existance;
124:
125:

Line 188: app_exception.raise_exception;

184: IF (cur_rowid%FOUND) THEN
185: CLOSE cur_rowid;
186: fnd_message.set_name ('IGS', 'IGS_PE_PEC_CT_FK');
187: igs_ge_msg_stack.add;
188: app_exception.raise_exception;
189: RETURN;
190: END IF;
191: CLOSE cur_rowid;
192:

Line 222: app_exception.raise_exception;

218: IF (cur_rowid%FOUND) THEN
219: CLOSE cur_rowid;
220: fnd_message.set_name ('IGS', 'IGS_PE_PEC_ACC_FK');
221: igs_ge_msg_stack.add;
222: app_exception.raise_exception;
223: RETURN;
224: END IF;
225: CLOSE cur_rowid;
226:

Line 256: app_exception.raise_exception;

252: IF (cur_rowid%FOUND) THEN
253: CLOSE cur_rowid;
254: fnd_message.set_name ('IGS', 'IGS_PE_PEC_HZ_FK');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: RETURN;
258: END IF;
259: CLOSE cur_rowid;
260:

Line 332: APP_EXCEPTION.RAISE_EXCEPTION;

328: IF (p_action IN ('INSERT','UPDATE')) THEN
329: IF(x_reviewer_id = x_person_id) THEN
330: FND_MESSAGE.SET_NAME('IGS','IGS_PE_REVR_PRSN_SAME');
331: IGS_GE_MSG_STACK.ADD;
332: APP_EXCEPTION.RAISE_EXCEPTION;
333: ELSE
334: IF x_reviewer_id IS NOT NULL THEN
335: OPEN is_reviewer_evaluator;
336: FETCH is_reviewer_evaluator INTO l_reviewer;

Line 341: APP_EXCEPTION.RAISE_EXCEPTION;

337: IF is_reviewer_evaluator%NOTFOUND THEN
338: CLOSE is_reviewer_evaluator;
339: FND_MESSAGE.SET_NAME('IGS','IGS_PE_INVALID_REVR');
340: IGS_GE_MSG_STACK.ADD;
341: APP_EXCEPTION.RAISE_EXCEPTION;
342: ELSE
343: CLOSE is_reviewer_evaluator;
344: END IF;
345: END IF;

Line 356: app_exception.raise_exception;

352: )
353: ) THEN
354: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
355: igs_ge_msg_stack.add;
356: app_exception.raise_exception;
357: END IF;
358: check_parent_existance;
359: ELSIF (p_action = 'UPDATE') THEN
360: -- Call all the procedures related to Before Update.

Line 370: app_exception.raise_exception;

366: )
367: ) THEN
368: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: END IF;
372: END IF;
373:
374: END before_dml;

Line 427: app_exception.raise_exception;

423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429:
430: SELECT igs_pe_credentials_s.NEXTVAL
431: INTO x_credential_id

Line 511: app_exception.raise_exception;

507: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
508: fnd_message.set_token ('ERR_CD', SQLCODE);
509: igs_ge_msg_stack.add;
510: igs_sc_gen_001.unset_ctx('R');
511: app_exception.raise_exception;
512: ELSE
513: igs_sc_gen_001.unset_ctx('R');
514: RAISE;
515: END IF;

Line 566: app_exception.raise_exception;

562: IF (c1%notfound) THEN
563: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
564: igs_ge_msg_stack.add;
565: CLOSE c1;
566: app_exception.raise_exception;
567: RETURN;
568: END IF;
569: CLOSE c1;
570:

Line 586: app_exception.raise_exception;

582: NULL;
583: ELSE
584: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
585: igs_ge_msg_stack.add;
586: app_exception.raise_exception;
587: END IF;
588:
589: RETURN;
590:

Line 639: app_exception.raise_exception;

635: END IF;
636: ELSE
637: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
638: igs_ge_msg_stack.add;
639: app_exception.raise_exception;
640: END IF;
641:
642: before_dml(
643: p_action => 'UPDATE',

Line 685: app_exception.raise_exception;

681: IF (SQL%NOTFOUND) THEN
682: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
683: igs_ge_msg_stack.add;
684: igs_sc_gen_001.unset_ctx('R');
685: app_exception.raise_exception;
686: END IF;
687: IF (x_mode = 'S') THEN
688: igs_sc_gen_001.unset_ctx('R');
689: END IF;

Line 700: app_exception.raise_exception;

696: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
697: fnd_message.set_token ('ERR_CD', SQLCODE);
698: igs_ge_msg_stack.add;
699: igs_sc_gen_001.unset_ctx('R');
700: app_exception.raise_exception;
701: ELSE
702: igs_sc_gen_001.unset_ctx('R');
703: RAISE;
704: END IF;

Line 809: app_exception.raise_exception;

805: IF (SQL%NOTFOUND) THEN
806: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
807: igs_ge_msg_stack.add;
808: igs_sc_gen_001.unset_ctx('R');
809: app_exception.raise_exception;
810: END IF;
811: IF (x_mode = 'S') THEN
812: igs_sc_gen_001.unset_ctx('R');
813: END IF;