DBA Data[Home] [Help]

APPS.IGS_AD_TERM_UNITDTLS_PKG dependencies on FND_MESSAGE

Line 42: Fnd_message.Set_Name('IGS', 'IGS_AD_INACTIVE_ACAD_HIST');

38: CLOSE check_status;
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;

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

93: Open cur_old_ref_values;
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;

Line 163: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

159: -- Bug: 2623180. changed >0 to >=0 in the following credit point comparison checks
160: IF Upper(Column_Name) = 'CP_ATTEMPTED' OR
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;

Line 164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CP_ATTEMPTED'));

160: IF Upper(Column_Name) = 'CP_ATTEMPTED' OR
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;

Line 174: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

170: -- The following code checks for check constraints on the Columns.
171: IF Upper(Column_Name) = 'CP_EARNED' OR
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;

Line 175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CP_EARNED'));

171: IF Upper(Column_Name) = 'CP_EARNED' OR
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;

Line 185: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

181: -- The following code checks for check constraints on the Columns.
182: IF Upper(Column_Name) = 'UNIT_GRADE_POINTS' OR
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;

Line 186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_GRADE_POINT'));

182: IF Upper(Column_Name) = 'UNIT_GRADE_POINTS' OR
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;

Line 211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

207: IF Get_Uk_for_Validation(
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:

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

236: new_references.unit_difficulty ,
237: 'UNIT_DIFFICULTY',
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;

Line 241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_UNIT_DIFFICULTY'));

237: 'UNIT_DIFFICULTY',
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:

Line 252: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

248: NULL;
249: ELSIF NOT Igs_Ad_Term_Details_Pkg.Get_PK_For_Validation (
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;

Line 253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_DETAILS'));

249: ELSIF NOT Igs_Ad_Term_Details_Pkg.Get_PK_For_Validation (
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:

Line 362: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATUD_ACDC_FK');

358: Open cur_rowid;
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;

Line 399: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATUD_ATD_FK');

395: Open cur_rowid;
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;

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

475: -- Call all the procedures related to Before Insert.
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;

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

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

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

609: else
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:

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

695: x_rowid => X_ROWID );
696: EXCEPTION
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;

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

696: EXCEPTION
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

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

747: begin
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;

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

776: AND (X_DEG_AUD_DETAIL_ID is null)))
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;

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

829: if X_LAST_UPDATE_LOGIN is NULL then
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(

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

888: PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
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;

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

904: );
905: EXCEPTION
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;

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

905: EXCEPTION
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

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

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