DBA Data[Home] [Help]

APPS.IGS_PE_CREDENTIALS_PKG dependencies on IGS_GE_MSG_STACK

Line 53: igs_ge_msg_stack.add;

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;
57: CLOSE cur_old_ref_values;

Line 106: IGS_GE_MSG_STACK.ADD;

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:
110:

Line 120: IGS_GE_MSG_STACK.ADD;

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

Line 187: igs_ge_msg_stack.add;

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;
191: CLOSE cur_rowid;

Line 221: igs_ge_msg_stack.add;

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;
225: CLOSE cur_rowid;

Line 255: igs_ge_msg_stack.add;

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;
259: CLOSE cur_rowid;

Line 331: IGS_GE_MSG_STACK.ADD;

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
335: OPEN is_reviewer_evaluator;

Line 340: IGS_GE_MSG_STACK.ADD;

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

Line 355: igs_ge_msg_stack.add;

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

Line 369: igs_ge_msg_stack.add;

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

Line 426: igs_ge_msg_stack.add;

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:
430: SELECT igs_pe_credentials_s.NEXTVAL

Line 509: igs_ge_msg_stack.add;

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
513: igs_sc_gen_001.unset_ctx('R');

Line 564: igs_ge_msg_stack.add;

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

Line 585: igs_ge_msg_stack.add;

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:
589: RETURN;

Line 638: igs_ge_msg_stack.add;

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:
642: before_dml(

Line 683: igs_ge_msg_stack.add;

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;
687: IF (x_mode = 'S') THEN

Line 698: igs_ge_msg_stack.add;

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
702: igs_sc_gen_001.unset_ctx('R');

Line 807: igs_ge_msg_stack.add;

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;
811: IF (x_mode = 'S') THEN