DBA Data[Home] [Help]

APPS.IGS_PE_CREDENTIALS_PKG dependencies on FND_MESSAGE

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

48: OPEN cur_old_ref_values;
49: FETCH cur_old_ref_values INTO old_references;
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;

Line 104: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

100: ELSIF NOT igs_lookups_view_pkg.Get_PK_For_Validation (
101: 'PE_CRE_RATING',
102: new_references.rating_code
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;

Line 105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_RATING'));

101: 'PE_CRE_RATING',
102: new_references.rating_code
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:

Line 118: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

114: ELSIF NOT igs_ad_cred_types_pkg.get_pk_for_validation (
115: new_references.credential_type_id,
116: 'N'
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;

Line 119: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CREDENTIAL_TYPE'));

115: new_references.credential_type_id,
116: 'N'
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;

Line 186: fnd_message.set_name ('IGS', 'IGS_PE_PEC_CT_FK');

182: OPEN cur_rowid;
183: FETCH cur_rowid INTO lv_rowid;
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;

Line 220: fnd_message.set_name ('IGS', 'IGS_PE_PEC_ACC_FK');

216: OPEN cur_rowid;
217: FETCH cur_rowid INTO lv_rowid;
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;

Line 254: fnd_message.set_name ('IGS', 'IGS_PE_PEC_HZ_FK');

250: OPEN cur_rowid;
251: FETCH cur_rowid INTO lv_rowid;
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;

Line 330: FND_MESSAGE.SET_NAME('IGS','IGS_PE_REVR_PRSN_SAME');

326: -- reviewer should have an active person type of EVALUATOR, STAFF or FACULTY.
327: -- ssawhney BUG 2893294, reviewer can BE NULL.
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

Line 339: FND_MESSAGE.SET_NAME('IGS','IGS_PE_INVALID_REVR');

335: OPEN is_reviewer_evaluator;
336: FETCH is_reviewer_evaluator INTO l_reviewer;
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;

Line 354: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

350: IF ( get_pk_for_validation(
351: new_references.credential_id
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;

Line 368: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

364: IF ( get_pk_for_validation (
365: new_references.credential_id
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;

Line 425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

421: IF (x_last_update_login IS NULL) THEN
422: x_last_update_login := -1;
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:

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

503:
504: EXCEPTION
505: WHEN OTHERS THEN
506: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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;

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

504: EXCEPTION
505: WHEN OTHERS THEN
506: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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

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

559:
560: OPEN c1;
561: FETCH c1 INTO tlinfo;
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;

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

580: AND ((tlinfo.rating_code = x_rating_code) OR ((tlinfo.rating_code IS NULL) AND (X_rating_code IS NULL)))
581: ) THEN
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:

Line 637: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

633: IF (x_last_update_login IS NULL) THEN
634: x_last_update_login := -1;
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:

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

678: rating_code = new_references.rating_code
679: WHERE rowid = x_rowid;
680:
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;

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

692:
693: EXCEPTION
694: WHEN OTHERS THEN
695: IF (SQLCODE = (-28115)) THEN
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;

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

693: EXCEPTION
694: WHEN OTHERS THEN
695: IF (SQLCODE = (-28115)) THEN
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

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

802: DELETE FROM igs_pe_credentials
803: WHERE rowid = x_rowid;
804:
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;