DBA Data[Home] [Help]

APPS.IGS_PE_ACAD_HONORS_PKG dependencies on IGS_GE_MSG_STACK

Line 51: IGS_GE_MSG_STACK.ADD;

47: Fetch cur_old_ref_values INTO old_references;
48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: App_Exception.Raise_Exception;
53: Return;
54: END IF;
55: Close cur_old_ref_values;

Line 153: IGS_GE_MSG_STACK.ADD;

149: new_references.honor_date,
150: new_references.person_id
151: ) THEN
152: Fnd_Message.Set_Name ('IGS', 'IGS_PE_ACAD_HNRS_DUP_EXISTS');
153: IGS_GE_MSG_STACK.ADD;
154: app_exception.raise_exception;
155: END IF;
156: END Check_Uniqueness ;
157:

Line 181: IGS_GE_MSG_STACK.ADD;

177: ELSIF NOT Igs_lookups_view_Pkg.Get_PK_For_Validation (
178: 'PE_ACAD_HONORS', new_references.acad_honor_type
179: ) THEN
180: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184:
185:

Line 273: IGS_GE_MSG_STACK.ADD;

269: -- Call all the procedures related to Before Insert.
270: IF Get_Pk_For_Validation(
271: new_references.acad_honor_id) THEN
272: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: Check_Uniqueness;
277: Check_Constraints;

Line 292: IGS_GE_MSG_STACK.ADD;

288: -- Call all the procedures related to Before Insert.
289: IF Get_PK_For_Validation (
290: new_references.acad_honor_id) THEN
291: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: END IF;
295: Check_Uniqueness;
296: Check_Constraints;

Line 397: IGS_GE_MSG_STACK.ADD;

393: X_PROGRAM_UPDATE_DATE := SYSDATE;
394: end if;
395: else
396: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
397: IGS_GE_MSG_STACK.ADD;
398: app_exception.raise_exception;
399: end if;
400:
401:

Line 477: igs_ge_msg_stack.add;

473: WHEN OTHERS THEN
474: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
475: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
476: fnd_message.set_token ('ERR_CD', SQLCODE);
477: igs_ge_msg_stack.add;
478: igs_sc_gen_001.unset_ctx('R');
479: app_exception.raise_exception;
480: ELSE
481: igs_sc_gen_001.unset_ctx('R');

Line 520: IGS_GE_MSG_STACK.ADD;

516: open c1;
517: fetch c1 into tlinfo;
518: if (c1%notfound) then
519: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
520: IGS_GE_MSG_STACK.ADD;
521: close c1;
522: app_exception.raise_exception;
523: return;
524: end if;

Line 538: IGS_GE_MSG_STACK.ADD;

534: ) then
535: null;
536: else
537: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
538: IGS_GE_MSG_STACK.ADD;
539: app_exception.raise_exception;
540: end if;
541: return;
542: end LOCK_ROW;

Line 586: IGS_GE_MSG_STACK.ADD;

582: X_LAST_UPDATE_LOGIN := -1;
583: end if;
584: else
585: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
586: IGS_GE_MSG_STACK.ADD;
587: app_exception.raise_exception;
588: end if;
589: Before_DML(
590: p_action=>'UPDATE',

Line 635: igs_ge_msg_stack.add;

631: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
632: where ROWID = X_ROWID;
633: if (sql%notfound) then
634: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
635: igs_ge_msg_stack.add;
636: igs_sc_gen_001.unset_ctx('R');
637: app_exception.raise_exception;
638: end if;
639: IF (x_mode = 'S') THEN

Line 653: igs_ge_msg_stack.add;

649: WHEN OTHERS THEN
650: IF (SQLCODE = (-28115)) THEN
651: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
652: fnd_message.set_token ('ERR_CD', SQLCODE);
653: igs_ge_msg_stack.add;
654: igs_sc_gen_001.unset_ctx('R');
655: app_exception.raise_exception;
656: ELSE
657: igs_sc_gen_001.unset_ctx('R');

Line 737: igs_ge_msg_stack.add;

733: delete from igs_pe_acad_honors
734: where ROWID = X_ROWID;
735: if (sql%notfound) then
736: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
737: igs_ge_msg_stack.add;
738: igs_sc_gen_001.unset_ctx('R');
739: app_exception.raise_exception;
740: end if;
741: IF (x_mode = 'S') THEN