DBA Data[Home] [Help]

APPS.IGS_AD_TERM_UNITDTLS_PKG dependencies on IGS_GE_MSG_STACK

Line 43: IGS_GE_MSG_STACK.ADD;

39:
40: IF l_temp IS NOT NULL THEN
41:
42: Fnd_message.Set_Name('IGS', 'IGS_AD_INACTIVE_ACAD_HIST');
43: IGS_GE_MSG_STACK.ADD;
44: app_exception.Raise_Exception;
45:
46: END IF;
47:

Line 98: IGS_GE_MSG_STACK.ADD;

94: Fetch cur_old_ref_values INTO old_references;
95: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
96: Close cur_old_ref_values;
97: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: Return;
101: END IF;
102: Close cur_old_ref_values;

Line 165: IGS_GE_MSG_STACK.ADD;

161: Column_Name IS NULL THEN
162: IF NOT (new_references.cp_attempted >= 0) THEN
163: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CP_ATTEMPTED'));
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169:

Line 176: IGS_GE_MSG_STACK.ADD;

172: Column_Name IS NULL THEN
173: IF NOT (new_references.cp_earned >= 0) THEN
174: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CP_EARNED'));
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179: END IF;
180:

Line 187: IGS_GE_MSG_STACK.ADD;

183: Column_Name IS NULL THEN
184: IF NOT (new_references.unit_grade_points >= 0) THEN
185: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRADE_POINT'));
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;
191: END Check_Constraints;

Line 212: IGS_GE_MSG_STACK.ADD;

208: new_references.term_details_id,
209: new_references.unit
210: ) THEN
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
212: IGS_GE_MSG_STACK.ADD;
213: app_exception.raise_exception;
214: END IF;
215:
216: END Check_Uniqueness ;

Line 242: IGS_GE_MSG_STACK.ADD;

238: 'N'
239: ) THEN
240: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_UNIT_DIFFICULTY'));
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245:
246: IF (((old_references.term_details_id = new_references.term_details_id)) OR

Line 254: IGS_GE_MSG_STACK.ADD;

250: new_references.term_details_id
251: ) THEN
252: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_DETAILS'));
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257:
258: END Check_Parent_Existance;

Line 363: IGS_GE_MSG_STACK.ADD;

359: Fetch cur_rowid INTO lv_rowid;
360: IF (cur_rowid%FOUND) THEN
361: Close cur_rowid;
362: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATUD_ACDC_FK');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: Return;
366: END IF;
367: Close cur_rowid;

Line 400: IGS_GE_MSG_STACK.ADD;

396: Fetch cur_rowid INTO lv_rowid;
397: IF (cur_rowid%FOUND) THEN
398: Close cur_rowid;
399: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATUD_ATD_FK');
400: IGS_GE_MSG_STACK.ADD;
401: App_Exception.Raise_Exception;
402: Return;
403: END IF;
404: Close cur_rowid;

Line 480: IGS_GE_MSG_STACK.ADD;

476: Null;
477: IF Get_Pk_For_Validation(
478: new_references.unit_details_id) THEN
479: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
480: IGS_GE_MSG_STACK.ADD;
481: App_Exception.Raise_Exception;
482: END IF;
483: Check_Constraints;
484: Check_Uniqueness;

Line 504: IGS_GE_MSG_STACK.ADD;

500: -- Call all the procedures related to Before Insert.
501: IF Get_PK_For_Validation (
502: new_references.unit_details_id) THEN
503: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
504: IGS_GE_MSG_STACK.ADD;
505: App_Exception.Raise_Exception;
506: END IF;
507: Check_Constraints;
508: Check_Uniqueness;

Line 614: IGS_GE_MSG_STACK.ADD;

610: X_PROGRAM_UPDATE_DATE := SYSDATE;
611: end if;
612: else
613: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
614: IGS_GE_MSG_STACK.ADD;
615: app_exception.raise_exception;
616: end if;
617:
618: X_UNIT_DETAILS_ID := -1;

Line 701: igs_ge_msg_stack.add;

697: WHEN OTHERS THEN
698: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
699: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
700: fnd_message.set_token ('ERR_CD', SQLCODE);
701: igs_ge_msg_stack.add;
702: igs_sc_gen_001.unset_ctx('R');
703: app_exception.raise_exception;
704: ELSE
705: igs_sc_gen_001.unset_ctx('R');

Line 752: IGS_GE_MSG_STACK.ADD;

748: open c1;
749: fetch c1 into tlinfo;
750: if (c1%notfound) then
751: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
752: IGS_GE_MSG_STACK.ADD;
753: close c1;
754: app_exception.raise_exception;
755: return;
756: end if;

Line 781: IGS_GE_MSG_STACK.ADD;

777: ) then
778: null;
779: else
780: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
781: IGS_GE_MSG_STACK.ADD;
782: app_exception.raise_exception;
783: end if;
784: return;
785: end LOCK_ROW;

Line 834: IGS_GE_MSG_STACK.ADD;

830: X_LAST_UPDATE_LOGIN := -1;
831: end if;
832: else
833: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
834: IGS_GE_MSG_STACK.ADD;
835: app_exception.raise_exception;
836: end if;
837: Before_DML(
838: p_action=>'UPDATE',

Line 893: igs_ge_msg_stack.add;

889: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
890: where ROWID = X_ROWID;
891: if (sql%notfound) then
892: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
893: igs_ge_msg_stack.add;
894: igs_sc_gen_001.unset_ctx('R');
895: app_exception.raise_exception;
896: end if;
897: IF (x_mode = 'S') THEN

Line 910: igs_ge_msg_stack.add;

906: WHEN OTHERS THEN
907: IF (SQLCODE = (-28115)) THEN
908: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
909: fnd_message.set_token ('ERR_CD', SQLCODE);
910: igs_ge_msg_stack.add;
911: igs_sc_gen_001.unset_ctx('R');
912: app_exception.raise_exception;
913: ELSE
914: igs_sc_gen_001.unset_ctx('R');

Line 1009: igs_ge_msg_stack.add;

1005: delete from IGS_AD_TERM_UNITDTLS
1006: where ROWID = X_ROWID;
1007: if (sql%notfound) then
1008: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1009: igs_ge_msg_stack.add;
1010: igs_sc_gen_001.unset_ctx('R');
1011: app_exception.raise_exception;
1012: end if;
1013: IF (x_mode = 'S') THEN