104: OPEN c_s_encmb_effect_type(v_etde_rec.s_encmb_effect_type);
105: FETCH c_s_encmb_effect_type INTO v_closed_ind;
106: IF (v_closed_ind = 'Y') THEN
107: fnd_message.set_name('IGS' , 'IGS_EN_CLOSE_NOT_CREATED');
108: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
109: v_etde_rec.encmb_meaning || ' ' ||
110: fnd_message.get;
111: -- ' - closed, not created ';
112: CLOSE c_s_encmb_effect_type;
124: -- The code modified by Nishikant - 13Jun2002 - as per bug#2413811
125: -- Below the code got modified to set the out NOCOPY parameter p_message of the above function call
126: -- instead of 'IGS_EN_NOT_CUR_ENROL'
127: fnd_message.set_name('IGS' , p_message_name);
128: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
129: v_etde_rec.encmb_meaning ||' ' ||
130: fnd_message.get;
131: -- 'RVK_SRVC - not created ' ||
132: -- 'due to current enrolment';
166: ELSIF (c_student_course_attempt%ROWCOUNT > 1) THEN
167: -- IGS_PE_PERSON is enrolled in more than one IGS_PS_COURSE
168: v_error_ind := v_error_ind + 1;
169: fnd_message.set_name('IGS' , 'IGS_EN_NC_MULTI_CUR_ENR');
170: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
171: v_etde_rec.encmb_meaning || ' ' ||
172: -- v_etde_rec.s_encmb_effect_type || ' ' ||
173: fnd_message.get;
174: -- 'not created due to multiple current enrolments';
177: ELSE
178: -- IGS_PE_PERSON is not enrolled
179: v_error_ind := v_error_ind + 1;
180: fnd_message.set_name('IGS' , 'IGS_EN_NC_NO_CUR_ENR');
181: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
182: -- v_etde_rec.s_encmb_effect_type || ' ' ||
183: v_etde_rec.encmb_meaning || ' ' ||
184: fnd_message.get;
185: -- 'not created due to no current enrolment';
198: v_course_cd,
199: p_message_name) = FALSE THEN
200: v_error_ind := v_error_ind + 1;
201: fnd_message.set_name('IGS' , 'IGS_EN_NC_EXIST_REC_CONFLICT');
202: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
203: -- v_etde_rec.s_encmb_effect_type || ' ' ||
204: v_etde_rec.encmb_meaning || ' ' ||
205: fnd_message.get;
206: -- 'not created due to existing record conflict';
218: v_course_cd,
219: p_message_name) = FALSE THEN
220: v_error_ind := v_error_ind + 1;
221: fnd_message.set_name('IGS' , 'IGS_EN_NC_EXIST_REC_CONFLICT');
222: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
223: -- v_etde_rec.s_encmb_effect_type || ' ' ||
224: v_etde_rec.encmb_meaning || ' ' ||
225: fnd_message.get;
226: -- 'not created due to existing record conflict';
252: -- End of TBH
253: IF v_etde_rec.s_encmb_effect_type IN (
254: 'RSTR_GE_CP','RSTR_LE_CP','RSTR_AT_TY') THEN
255: fnd_message.set_name('IGS' , 'IGS_EN_CR_EXTRA_DTL_REQ');
256: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
257: v_etde_rec.encmb_meaning || ' ' ||
258: -- v_etde_rec.s_encmb_effect_type || ' ' ||
259: fnd_message.get;
260: -- 'created, extra detail required';
260: -- 'created, extra detail required';
261: ELSIF v_etde_rec.s_encmb_effect_type IN (
262: 'EXC_CRS_GP','EXC_CRS_U','RQRD_CRS_U') THEN
263: fnd_message.set_name('IGS' , 'IGS_EN_CR_EXTRA_DTL_REQ');
264: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
265: -- v_etde_rec.s_encmb_effect_type || ' ' ||
266: v_etde_rec.encmb_meaning || ' ' ||
267: fnd_message.get;
268: -- 'created, extra detail required';
268: -- 'created, extra detail required';
269: ELSIF v_etde_rec.s_encmb_effect_type NOT IN (
270: 'EXC_COURSE','SUS_COURSE') THEN
271: fnd_message.set_name('IGS' , 'IGS_EN_CR_SUCCESS');
272: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
273: -- v_etde_rec.s_encmb_effect_type || ' ' ||
274: v_etde_rec.encmb_meaning || ' ' ||
275: fnd_message.get;
276: -- 'created successfully';
288: v_return_type) = FALSE) THEN
289: -- This IGS_PE_PERSON is currently enrolled in the IGS_PS_COURSE,
290: -- effect type can not be created
291: fnd_message.set_name('IGS' , 'IGS_EN_CR_EXTRA_DTL_REQ');
292: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
293: v_etde_rec.encmb_meaning ||
294: fnd_message.get ;
295: -- 'EXC_COURSE - created, ' ||
296: -- 'extra detail required';
313: x_mode => 'R'
314: );
315: END;
316: fnd_message.set_name('IGS' , 'IGS_EN_CR_SUCCESS');
317: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
318: -- v_etde_rec.s_encmb_effect_type || ' ' ||
319: v_etde_rec.encmb_meaning || ' ' ||
320: fnd_message.get ;
321: -- 'created successfully';
332: v_return_type) = FALSE) THEN
333: -- This IGS_PE_PERSON is currently enrolled in the IGS_PS_COURSE,
334: -- effect type can not be created
335: fnd_message.set_name('IGS' , 'IGS_EN_CR_EXTRA_DTL_REQ');
336: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
337: -- v_etde_rec.encmb_meaning ||
338: v_etde_rec.encmb_meaning || ' ' ||
339: fnd_message.get ;
340: -- 'SUS_COURSE - created, ' ||
359: );
360: END;
361: IF p_expiry_dt IS NULL THEN
362: fnd_message.set_name('IGS' , 'IGS_EN_CR_EXP_DT_REQ');
363: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
364: -- v_etde_rec.s_encmb_effect_type || ' ' ||
365: v_etde_rec.encmb_meaning || ' ' ||
366: fnd_message.get;
367: -- 'created, expiry date required';
366: fnd_message.get;
367: -- 'created, expiry date required';
368: ELSE
369: fnd_message.set_name('IGS' , 'IGS_EN_CR_SUCCESS');
370: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
371: -- v_etde_rec.s_encmb_effect_type || ' ' ||
372: v_etde_rec.encmb_meaning || ' ' ||
373: fnd_message.get;
374: -- 'created successfully';
377: ELSE
378: IF (v_etde_rec.s_encmb_effect_type IN ('EXC_COURSE', 'SUS_COURSE') AND
379: p_course_cd IS NULL) THEN
380: fnd_message.set_name('IGS' , 'IGS_EN_CR_EXP_DT_REQ');
381: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
382: -- v_etde_rec.s_encmb_effect_type || ' ' ||
383: v_etde_rec.encmb_meaning || ' ' ||
384: fnd_message.get;
385: -- 'created, extra detail required';
386: ELSE
387: IF v_etde_rec.s_encmb_effect_type = 'SUS_COURSE' THEN
388: IF p_expiry_dt IS NULL THEN
389: fnd_message.set_name('IGS' , 'IGS_EN_CR_EXP_DT_REQ');
390: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
391: -- v_etde_rec.s_encmb_effect_type || ' ' ||
392: v_etde_rec.encmb_meaning || ' ' ||
393: fnd_message.get;
394: -- 'created, expiry date required';
393: fnd_message.get;
394: -- 'created, expiry date required';
395: ELSE
396: fnd_message.set_name('IGS' , 'IGS_EN_CR_SUCCESS');
397: v_message_string := v_message_string || FND_GLOBAL.LOCAL_CHR(10) ||
398: -- v_etde_rec.s_encmb_effect_type || ' ' ||
399: v_etde_rec.encmb_meaning || ' ' ||
400: fnd_message.get;
401: -- 'created successfully';