DBA Data[Home] [Help]

APPS.IGS_PE_TEACH_PERIODS_PKG dependencies on FND_MESSAGE

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

54: Open cur_old_ref_values;
55: Fetch cur_old_ref_values INTO old_references;
56: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
57: Close cur_old_ref_values;
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: App_Exception.Raise_Exception;
61: Return;
62: END IF;

Line 116: Fnd_Message.Set_Name ('IGS', 'IGS_PE_HOU_STAT_DUP_EXISTS');

112: new_references.cal_type,
113: new_references.sequence_number,
114: new_references.person_id)
115: THEN
116: Fnd_Message.Set_Name ('IGS', 'IGS_PE_HOU_STAT_DUP_EXISTS');
117: IGS_GE_MSG_STACK.ADD;
118: app_exception.raise_exception;
119: END IF;
120: END Check_Uniqueness ;

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

162: NULL;
163: ELSIF NOT Igs_Lookups_View_Pkg.Get_PK_For_Validation (
164: 'PE_TEA_PER_RES',new_references.teach_period_resid_stat_cd
165: ) THEN
166: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170:

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

173: NULL;
174: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
175: new_references.person_id
176: ) THEN
177: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181:

Line 291: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PPT_PP_FK');

287: Open cur_rowid;
288: Fetch cur_rowid INTO lv_rowid;
289: IF (cur_rowid%FOUND) THEN
290: Close cur_rowid;
291: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PPT_PP_FK');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: Return;
295: END IF;

Line 347: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

343:
344: IF (p_action = 'INSERT') THEN
345: -- Call all the procedures related to Before Insert.
346: IF Get_Pk_For_Validation(new_references.teaching_period_id) THEN
347: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
348: IGS_GE_MSG_STACK.ADD;
349: App_Exception.Raise_Exception;
350: END IF;
351: Check_Constraints;

Line 365: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

361: Null;
362: ELSIF (p_action = 'VALIDATE_INSERT') THEN
363: -- Call all the procedures related to Before Insert.
364: IF Get_PK_For_Validation (new_references.teaching_period_id) THEN
365: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
366: IGS_GE_MSG_STACK.ADD;
367: App_Exception.Raise_Exception;
368: END IF;
369: Check_Constraints;

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

484: if X_LAST_UPDATE_LOGIN is NULL then
485: X_LAST_UPDATE_LOGIN := -1;
486: end if;
487: else
488: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
489: IGS_GE_MSG_STACK.ADD;
490: app_exception.raise_exception;
491: end if;
492: select igs_pe_teach_periods_s.nextval into x_teaching_period_id from dual;

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

551: x_rowid => X_ROWID );
552: EXCEPTION
553: WHEN OTHERS THEN
554: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
555: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
556: fnd_message.set_token ('ERR_CD', SQLCODE);
557: igs_ge_msg_stack.add;
558: igs_sc_gen_001.unset_ctx('R');
559: app_exception.raise_exception;

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

552: EXCEPTION
553: WHEN OTHERS THEN
554: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
555: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
556: fnd_message.set_token ('ERR_CD', SQLCODE);
557: igs_ge_msg_stack.add;
558: igs_sc_gen_001.unset_ctx('R');
559: app_exception.raise_exception;
560: ELSE

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

597: BEGIN
598: OPEN c1;
599: FETCH c1 INTO tlinfo;
600: IF (c1%NOTFOUND) THEN
601: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
602: IGS_GE_MSG_STACK.ADD;
603: CLOSE c1;
604: app_exception.raise_exception;
605: RETURN;

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

618: AND (X_SEQUENCE_NUMBER is null)))
619: ) THEN
620: NULL;
621: ELSE
622: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
623: IGS_GE_MSG_STACK.ADD;
624: app_exception.raise_exception;
625: END IF;
626: RETURN;

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

663: IF X_LAST_UPDATE_LOGIN IS NULL THEN
664: X_LAST_UPDATE_LOGIN := -1;
665: END IF;
666: ELSE
667: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
668: IGS_GE_MSG_STACK.ADD;
669: app_exception.raise_exception;
670: END IF;
671: Before_DML(

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

695: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
696: WHERE ROWID = X_ROWID;
697:
698: IF (SQL%NOTFOUND) THEN
699: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
700: igs_ge_msg_stack.add;
701: igs_sc_gen_001.unset_ctx('R');
702: app_exception.raise_exception;
703: END IF;

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

712: );
713: EXCEPTION
714: WHEN OTHERS THEN
715: IF (SQLCODE = (-28115)) THEN
716: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
717: fnd_message.set_token ('ERR_CD', SQLCODE);
718: igs_ge_msg_stack.add;
719: igs_sc_gen_001.unset_ctx('R');
720: app_exception.raise_exception;

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

713: EXCEPTION
714: WHEN OTHERS THEN
715: IF (SQLCODE = (-28115)) THEN
716: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
717: fnd_message.set_token ('ERR_CD', SQLCODE);
718: igs_ge_msg_stack.add;
719: igs_sc_gen_001.unset_ctx('R');
720: app_exception.raise_exception;
721: ELSE

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

802: END IF;
803: delete from igs_pe_teach_periods_all
804: where ROWID = X_ROWID;
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;