DBA Data[Home] [Help]

APPS.IGS_EN_SPI_LGCY_PUB dependencies on FND_MESSAGE

Line 44: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');

40: BEGIN
41:
42: -- Check whether the person number is null or not.
43: IF p_intermiss_rec.person_number IS NULL THEN
44: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');
45: FND_MSG_PUB.ADD;
46: l_valid_params := FALSE;
47: END IF;
48:

Line 51: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');

47: END IF;
48:
49: -- Check whether the program code is null or not.
50: IF p_intermiss_rec.program_cd IS NULL THEN
51: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');
52: FND_MSG_PUB.ADD;
53: l_valid_params := FALSE;
54: ELSE
55: BEGIN

Line 66: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_UCASE');

62: -- Delete the message 'IGS_GE_INVALID_VALUE'
63: FND_MSG_PUB.DELETE_MSG (l_msg_count);
64:
65: -- set the customized message
66: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_UCASE');
67: FND_MSG_PUB.ADD;
68: l_valid_params := FALSE;
69: END;
70: END IF;

Line 74: FND_MESSAGE.SET_NAME('IGS','IGS_PS_STARDT_NOT_NULL');

70: END IF;
71:
72: -- Check whether start date is null or not
73: IF p_intermiss_rec.start_dt IS NULL THEN
74: FND_MESSAGE.SET_NAME('IGS','IGS_PS_STARDT_NOT_NULL');
75: FND_MSG_PUB.ADD;
76: l_valid_params := FALSE;
77: END IF;
78:

Line 81: FND_MESSAGE.SET_NAME('IGS','IGS_EN_END_DT_CANT_NULL');

77: END IF;
78:
79: -- Check whether end date is null or not
80: IF p_intermiss_rec.end_dt IS NULL THEN
81: FND_MESSAGE.SET_NAME('IGS','IGS_EN_END_DT_CANT_NULL');
82: FND_MSG_PUB.ADD;
83: l_valid_params := FALSE;
84: END IF;
85:

Line 96: FND_MESSAGE.SET_NAME('IGS','IGS_EN_VOL_IND_INVALID');

92: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
93: p_data => l_msg_data);
94:
95: FND_MSG_PUB.DELETE_MSG (l_msg_count);
96: FND_MESSAGE.SET_NAME('IGS','IGS_EN_VOL_IND_INVALID');
97: FND_MSG_PUB.ADD;
98: l_valid_params := FALSE;
99: END;
100: END IF;

Line 105: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_TYPE_UCASE');

101:
102: -- Check whether Intermission type is upper case or not.
103: IF p_intermiss_rec.intermission_type IS NOT NULL THEN
104: IF p_intermiss_rec.intermission_type <> UPPER(p_intermiss_rec.intermission_type) then
105: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_TYPE_UCASE');
106: FND_MSG_PUB.ADD;
107: l_valid_params := FALSE;
108: END IF;
109: END IF;

Line 121: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROVED_INVALID');

117: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
118: p_data => l_msg_data);
119:
120: FND_MSG_PUB.DELETE_MSG (l_msg_count);
121: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROVED_INVALID');
122: FND_MSG_PUB.ADD;
123: l_valid_params := FALSE;
124: END;
125: END IF;

Line 131: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INSTIT_NAME_UCASE');

127:
128: -- Check whether institution name is upper case or not.
129: IF p_intermiss_rec.institution_name IS NOT NULL THEN
130: IF p_intermiss_rec.institution_name <> UPPER(p_intermiss_rec.institution_name) then
131: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INSTIT_NAME_UCASE');
132: FND_MSG_PUB.ADD;
133: l_valid_params := FALSE;
134: END IF;
135: END IF;

Line 139: FND_MESSAGE.SET_NAME('IGS','IGS_EN_RCOND_INV');

135: END IF;
136:
137: IF p_intermiss_rec.COND_RETURN_FLAG IS NOT NULL THEN
138: IF p_intermiss_rec.COND_RETURN_FLAG NOT IN ('Y','N') THEN
139: FND_MESSAGE.SET_NAME('IGS','IGS_EN_RCOND_INV');
140: FND_MSG_PUB.ADD;
141: l_valid_params := FALSE;
142: END IF;
143: END IF;

Line 181: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_DESC_FLEX');

177: p_attribute19 => p_intermiss_rec.attribute19,
178: p_attribute20 => p_intermiss_rec.attribute20,
179: p_desc_flex_name => l_desc_flex_name ) THEN
180:
181: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_DESC_FLEX');
182: FND_MSG_PUB.ADD;
183: l_valid_params := FALSE;
184: END IF;
185: END IF;

Line 216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STU_INTM_EXISTS');

212: -- Check for primary Key validation. If validation fails, stop the processing and return back
213: -- to the calling procedure.
214: l_logical_delete_date := to_date('31-12-4712','DD-MM-YYYY');
215: IF igs_en_stdnt_ps_intm_pkg.get_pk_for_validation ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,l_logical_delete_date) THEN
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STU_INTM_EXISTS');
217: FND_MSG_PUB.ADD;
218: RETURN 'W';
219: END IF;
220:

Line 224: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_ATT_NOT_EXIST');

220:
221:
222: -- Check for Student Program Attempt existance
223: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation ( p_person_id, p_intermiss_rec.program_cd ) THEN
224: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_ATT_NOT_EXIST');
225: FND_MSG_PUB.ADD;
226: l_valid_db_constr := FALSE;
227: END IF;
228:

Line 232: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_TYP_NOT_EXIST');

228:
229: -- Check for intermission type existance
230: IF p_intermiss_rec.intermission_type IS NOT NULL THEN
231: IF NOT igs_en_intm_types_pkg.get_uk_for_validation ( p_intermiss_rec.intermission_type ) THEN
232: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_TYP_NOT_EXIST');
233: FND_MSG_PUB.ADD;
234: l_valid_db_constr := FALSE;
235: END IF;
236: END IF;

Line 241: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INST_NOT_EXIST');

237:
238: -- Check for institution existance
239: IF p_intermiss_rec.institution_name IS NOT NULL THEN
240: IF NOT igs_en_gen_legacy.check_institution ( p_intermiss_rec.institution_name ) THEN
241: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INST_NOT_EXIST');
242: FND_MSG_PUB.ADD;
243: l_valid_db_constr := FALSE;
244: END IF;
245: END IF;

Line 281: FND_MESSAGE.SET_NAME('IGS',p_message_name);

277:
278: -- Check whether the Start Date is less than or equal to End Date.
279: IF (p_intermiss_rec.start_dt IS NOT NULL) AND (p_intermiss_rec.end_dt IS NOT NULL) THEN
280: IF NOT igs_ad_val_edtl.genp_val_strt_end_dt ( p_intermiss_rec.start_dt, p_intermiss_rec.end_dt, p_message_name ) THEN
281: FND_MESSAGE.SET_NAME('IGS',p_message_name);
282: FND_MSG_PUB.ADD;
283: l_validation_success := FALSE;
284: END IF;
285: END IF;

Line 290: FND_MESSAGE.SET_NAME('IGS',p_message_name);

286:
287: -- Validate the overlap of student course intermission records
288: IF NOT igs_en_val_sci.enrp_val_sci_ovrlp ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,
289: p_intermiss_rec.end_dt, p_message_name ) THEN
290: FND_MESSAGE.SET_NAME('IGS',p_message_name);
291: FND_MSG_PUB.ADD;
292: l_validation_success := FALSE;
293: END IF;
294:

Line 299: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_CANT_OVRLP_UA');

295: -- Validate whether Period of intermission overlaps enrolled/completed
296: -- unit attempt teaching period census dates.
297: IF NOT igs_en_gen_legacy.validate_intm_ua_ovrlp ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,
298: p_intermiss_rec.end_dt ) THEN
299: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_CANT_OVRLP_UA');
300: FND_MSG_PUB.ADD;
301: l_validation_success := FALSE;
302: END IF;
303:

Line 310: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NOT_SET_APPROV_DET');

306:
307: l_result := igs_en_gen_legacy.check_approv_reqd (p_intermiss_rec.intermission_type);
308:
309: IF (l_result = FALSE) AND (p_intermiss_rec.approver_person_number IS NOT NULL) THEN
310: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NOT_SET_APPROV_DET');
311: FND_MSG_PUB.ADD;
312: l_validation_success := FALSE;
313: END IF;
314:

Line 321: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROV_PERS_STAFF');

317: -- Check whether Approving person is a staff member or not.
318: IF p_intermiss_rec.approver_person_number IS NOT NULL THEN
319:
320: IF NOT igs_ad_val_acai.genp_val_staff_prsn (p_approver_id, p_message_name) THEN
321: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROV_PERS_STAFF');
322: FND_MSG_PUB.ADD;
323: l_validation_success := FALSE;
324: END IF;
325:

Line 328: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROV_CANT_STU');

324: END IF;
325:
326: -- Check whether Approving person is same as the student being approved.
327: IF p_intermiss_rec.approver_person_number = p_intermiss_rec.person_number THEN
328: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROV_CANT_STU');
329: FND_MSG_PUB.ADD;
330: l_validation_success := FALSE;
331: END IF;
332:

Line 342: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_SET_INSTI_DET');

338:
339: IF p_intermiss_rec.intermission_type IS NOT NULL THEN
340:
341: IF NOT igs_en_gen_legacy.check_study_antr_instu ( p_intermiss_rec.intermission_type ) THEN
342: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_SET_INSTI_DET');
343: FND_MSG_PUB.ADD;
344: l_validation_success := FALSE;
345: END IF;
346:

Line 433: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');

429: -- Derive the values for further processing.
430: -- Get the person id for the passed person number.
431: l_person_id := Igs_Ge_Gen_003.get_person_id (p_intermiss_rec.person_number);
432: IF l_person_id IS NULL THEN
433: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');
434: FND_MSG_PUB.ADD;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: l_insert_flag := FALSE;
437: END IF;

Line 446: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_APPROV_PERSON');

442: -- Get the approver person id for the approver.
443: IF p_intermiss_rec.approver_person_number IS NOT NULL THEN
444: l_approver_person_id := Igs_Ge_Gen_003.get_person_id (p_intermiss_rec.approver_person_number);
445: IF l_approver_person_id IS NULL THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_APPROV_PERSON');
447: FND_MSG_PUB.ADD;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: l_insert_flag := FALSE;
450: END IF;