eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GR_GEN_002 dependencies on FND_FILE

Line 63: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');

59: --
60: --Log the Parameters value in the log file. This is to fix Bug# 2690151
61: --
62: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
63: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
64: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);

Line 64: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);

60: --Log the Parameters value in the log file. This is to fix Bug# 2690151
61: --
62: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
63: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
64: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);

Line 65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);

61: --
62: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
63: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
64: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);

Line 66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);

62: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
63: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
64: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);

Line 67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);

63: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
64: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);

Line 68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);

64: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);

Line 69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);

65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);

Line 70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);

66: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_course_cd = '||p_course_cd);
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);

Line 71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);

67: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_crs_location_cd = '||p_crs_location_cd);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);

Line 72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);

68: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_award_cd = '||p_award_cd);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_approval_status = '||p_approval_status);

Line 73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);

69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_nominated_completion = '||p_nominated_completion);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_approval_status = '||p_approval_status);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);

70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_derived_completion = '||p_derived_completion);
71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_approval_status = '||p_approval_status);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
78:

Line 75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);

71: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_restrict_rqrmnt_complete = '||p_restrict_rqrmnt_complete);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_approval_status = '||p_approval_status);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
78:
79:

Line 76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_approval_status = '||p_approval_status);

72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_potential_graduand_status = '||p_potential_graduand_status);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_approval_status = '||p_approval_status);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
78:
79:
80: IF NOT IGS_GR_VAL_AWC.grdp_val_award_type(p_award_cd, 'COURSE', v_message) THEN

Line 77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_eligible_graduand_status = '||p_eligible_graduand_status);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_appr_status = '||p_graduand_appr_status);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_approval_status = '||p_approval_status);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
78:
79:
80: IF NOT IGS_GR_VAL_AWC.grdp_val_award_type(p_award_cd, 'COURSE', v_message) THEN
81: ERRBUF:=FND_MESSAGE.GET_STRING('IGS', v_message);

Line 252: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151

248: IF c_gst%NOTFOUND THEN
249: CLOSE c_gst;
250: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
251: --App_Exception.Raise_Exception;
252: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
253: RETURN;
254: END IF;
255: CLOSE c_gst;
256: IF v_gst_rec.closed_ind = 'Y' THEN

Line 259: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151

255: CLOSE c_gst;
256: IF v_gst_rec.closed_ind = 'Y' THEN
257: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_STATUS_CLOSED');
258: --App_Exception.Raise_Exception;
259: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
260: RETURN;
261: END IF;
262: -- Validate the eligible IGS_GR_GRADUAND status value
263: OPEN c_gst(

Line 271: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151

267: IF c_gst%NOTFOUND THEN
268: CLOSE c_gst;
269: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
270: --App_Exception.Raise_Exception;
271: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
272: RETURN;
273: END IF;
274: CLOSE c_gst;
275: IF v_gst_rec.closed_ind = 'Y' THEN

Line 278: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151

274: CLOSE c_gst;
275: IF v_gst_rec.closed_ind = 'Y' THEN
276: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_STATUS_CLOSED');
277: --App_Exception.Raise_Exception;
278: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
279: RETURN;
280: END IF;
281: -- Validate the IGS_GR_GRADUAND approval status value
282: OPEN c_gas;

Line 288: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151

284: IF c_gas%NOTFOUND THEN
285: CLOSE c_gas;
286: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
287: --App_Exception.Raise_Exception;
288: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
289: RETURN;
290: END IF;
291: CLOSE c_gas;
292: IF v_gas_rec.closed_ind = 'Y' THEN

Line 295: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151

291: CLOSE c_gas;
292: IF v_gas_rec.closed_ind = 'Y' THEN
293: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_APPR_STATUS_CLOSE');
294: --App_Exception.Raise_Exception;
295: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
296: RETURN;
297: END IF;
298: EXCEPTION
299: WHEN OTHERS THEN

Line 536: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET);

532: IF NVL(l_message_name,'NULL') = 'IGS_GR_CANNOT_BE_APPROVED' THEN
533: l_hold := 'Y';
534: FND_MESSAGE.SET_NAME('IGS', 'IGS_GR_GRD_HOLD');
535: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
536: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET);
537: EXIT; --If hold is there then don't process any other award...
538: ELSIF l_message_name IS NOT NULL THEN
539: FND_MESSAGE.SET_NAME('IGS',l_message_name);
540: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());

Line 540: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());

536: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET);
537: EXIT; --If hold is there then don't process any other award...
538: ELSIF l_message_name IS NOT NULL THEN
539: FND_MESSAGE.SET_NAME('IGS',l_message_name);
540: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());
541: EXIT; --Dont EXIT; Let the system process another SPAAA record for the student.
542: ELSE
543: --IGS_UC_ERROR_PROC_DATA - Unexpected error encountered while processing VIEW data
544: FND_MESSAGE.SET_NAME('IGS','IGS_UC_ERROR_PROC_DATA');

Line 546: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());

542: ELSE
543: --IGS_UC_ERROR_PROC_DATA - Unexpected error encountered while processing VIEW data
544: FND_MESSAGE.SET_NAME('IGS','IGS_UC_ERROR_PROC_DATA');
545: FND_MESSAGE.SET_TOKEN('VIEW',l_person_number);
546: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());
547: EXIT;
548: --RAISE; --Dont raise any error... log it in log file and proceed with next student...
549: END IF;
550: END;

Line 555: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());

551: FND_MESSAGE.SET_NAME('IGS','IGS_GR_GRD_REC_CRTED');
552: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
553: FND_MESSAGE.SET_TOKEN('COURSE',p_course_cd);
554: FND_MESSAGE.SET_TOKEN('AWARD',v_spaaa_rec.award_cd);
555: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());
556: -- End of new code added as per the bug# 2690151
557: v_records_update := v_records_update + 1;
558: END IF;
559: END LOOP;

Line 581: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());

577: FND_MESSAGE.SET_NAME('IGS','IGS_PR_PRG');
578: l_person_number := l_person_number||' '||FND_MESSAGE.GET()||': '||p_course_cd||' - '||p_award_cd;
579: FND_MESSAGE.SET_NAME('IGS','IGS_GR_AWD_AIM_SETUP');
580: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
581: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());
582: END IF;
583: RETURN;
584: END IF;
585: CLOSE c_spaaa_chk;

Line 615: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());

611: FETCH cur_spaa_gr_dif INTO rec_spaa_gr_dif;
612: IF cur_spaa_gr_dif%NOTFOUND THEN
613: FND_MESSAGE.SET_NAME('IGS','IGS_GR_NO_REC_CRETD');
614: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
615: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());
616: ELSIF cur_spaa_gr_dif%FOUND THEN
617: FND_MESSAGE.SET_NAME('IGS','IGS_GR_GRD_REC_EXT');
618: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
619: FND_MESSAGE.SET_TOKEN('COURSE',p_course_cd);

Line 620: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());

616: ELSIF cur_spaa_gr_dif%FOUND THEN
617: FND_MESSAGE.SET_NAME('IGS','IGS_GR_GRD_REC_EXT');
618: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
619: FND_MESSAGE.SET_TOKEN('COURSE',p_course_cd);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());
621: END IF;
622: CLOSE cur_spaa_gr_dif;
623: END IF;
624: END;

Line 655: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151

651: p_eligible_graduand_status IS NULL OR
652: p_graduand_appr_status IS NULL THEN
653: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
654: --App_Exception.Raise_Exception;
655: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
656: RETURN;
657: END IF;
658: -- Validate completion criterion
659: IF p_nominated_completion = 'N' AND

Line 663: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151

659: IF p_nominated_completion = 'N' AND
660: p_derived_completion = 'N' THEN
661: Fnd_Message.Set_Name('IGS', 'IGS_GR_NOMIN_DERV_COMPL_SET');
662: --App_Exception.Raise_Exception;
663: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2690151
664: RETURN;
665: END IF;
666: --
667: -- Validate the status values provided

Line 741: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

737:
738: --Log this message only once for a person.
739: IF l_log_person_id = 'NULL' OR
740: l_log_person_id <> v_crd_sca_rec.person_id||'-'||v_crd_sca_rec.course_cd THEN
741: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
742: FND_MESSAGE.SET_NAME('IGS','IGS_GR_PROCESSING');
743: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
744: FND_MESSAGE.SET_TOKEN('COURSE',v_crd_sca_rec.course_cd);
745: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

Line 745: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

741: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
742: FND_MESSAGE.SET_NAME('IGS','IGS_GR_PROCESSING');
743: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
744: FND_MESSAGE.SET_TOKEN('COURSE',v_crd_sca_rec.course_cd);
745: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
746: l_log_person_id := v_crd_sca_rec.person_id||'-'||v_crd_sca_rec.course_cd;
747: END IF;
748:
749: OPEN c_gr(

Line 768: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET);

764: p_encmb_effect_type => 'GRAD_BLK',
765: p_message_name => v_message_name) = TRUE THEN
766: FND_MESSAGE.SET_NAME('IGS', 'IGS_GR_GRD_HOLD');
767: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
768: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET);
769: l_chk_hold := v_crd_sca_rec.person_id||'-'||v_crd_sca_rec.course_cd;
770: END IF;
771: END IF;
772: END IF;

Line 789: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());

785: ELSE
786: FND_MESSAGE.SET_NAME('IGS','IGS_GR_GRD_REC_EXT');
787: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
788: FND_MESSAGE.SET_TOKEN('COURSE',v_crd_sca_rec.course_cd);
789: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());
790: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
791: CLOSE c_gr;
792: END IF;
793: END LOOP; -- crd_sca

Line 790: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

786: FND_MESSAGE.SET_NAME('IGS','IGS_GR_GRD_REC_EXT');
787: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
788: FND_MESSAGE.SET_TOKEN('COURSE',v_crd_sca_rec.course_cd);
789: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||FND_MESSAGE.GET());
790: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
791: CLOSE c_gr;
792: END IF;
793: END LOOP; -- crd_sca
794: EXCEPTION

Line 1124: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');

1120: --
1121: --Log the Parameters value in the log file. This is to fix Bug# 2690151
1122: --
1123: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);

Line 1125: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);

1121: --Log the Parameters value in the log file. This is to fix Bug# 2690151
1122: --
1123: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_resolve_stalemate_type = '||p_resolve_stalemate_type);

Line 1126: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);

1122: --
1123: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_resolve_stalemate_type = '||p_resolve_stalemate_type);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);

Line 1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);

1123: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_resolve_stalemate_type = '||p_resolve_stalemate_type);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);

1124: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_resolve_stalemate_type = '||p_resolve_stalemate_type);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1132:

Line 1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_resolve_stalemate_type = '||p_resolve_stalemate_type);

1125: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_resolve_stalemate_type = '||p_resolve_stalemate_type);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1132:
1133: -- 1. Check parameters :

Line 1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);

1126: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_resolve_stalemate_type = '||p_resolve_stalemate_type);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1132:
1133: -- 1. Check parameters :
1134: IF p_grd_cal_type IS NULL OR

Line 1131: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1127: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_location_cd = '||p_location_cd);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_graduand_status = '||p_graduand_status);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_resolve_stalemate_type = '||p_resolve_stalemate_type);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1132:
1133: -- 1. Check parameters :
1134: IF p_grd_cal_type IS NULL OR
1135: p_grd_ci_sequence_number IS NULL OR

Line 1426: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

1422:
1423: -- Next check has been added as per the 'Progression Completion' TD Bug# 2636792
1424: IF p_graduand_status IS NULL OR p_approval_status IS NULL THEN
1425: FND_MESSAGE.SET_NAME('IGS', 'IGS_GR_GRAD_APPR_REQ');
1426: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1427: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1428: RETURN;
1429: END IF;
1430: -- Check paramenters

Line 1427: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1423: -- Next check has been added as per the 'Progression Completion' TD Bug# 2636792
1424: IF p_graduand_status IS NULL OR p_approval_status IS NULL THEN
1425: FND_MESSAGE.SET_NAME('IGS', 'IGS_GR_GRAD_APPR_REQ');
1426: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1427: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1428: RETURN;
1429: END IF;
1430: -- Check paramenters
1431: IF p_eligible_graduand_status IS NULL OR

Line 1434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

1430: -- Check paramenters
1431: IF p_eligible_graduand_status IS NULL OR
1432: p_potential_graduand_status IS NULL THEN
1433: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
1434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1436: RETURN;
1437: END IF;
1438: -- Validate the status values provided

Line 1435: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1431: IF p_eligible_graduand_status IS NULL OR
1432: p_potential_graduand_status IS NULL THEN
1433: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
1434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1436: RETURN;
1437: END IF;
1438: -- Validate the status values provided
1439: OPEN c_gst(

Line 1446: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

1442: FETCH c_gst INTO v_closed_ind;
1443: IF c_gst%NOTFOUND THEN
1444: CLOSE c_gst;
1445: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1447: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1448: RETURN;
1449: ELSE
1450: CLOSE c_gst;

Line 1447: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1443: IF c_gst%NOTFOUND THEN
1444: CLOSE c_gst;
1445: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1447: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1448: RETURN;
1449: ELSE
1450: CLOSE c_gst;
1451: IF v_closed_ind = 'Y' THEN

Line 1453: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

1449: ELSE
1450: CLOSE c_gst;
1451: IF v_closed_ind = 'Y' THEN
1452: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_STATUS_CLOSED');
1453: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1454: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1455: RETURN;
1456: END IF;
1457: END IF;

Line 1454: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1450: CLOSE c_gst;
1451: IF v_closed_ind = 'Y' THEN
1452: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_STATUS_CLOSED');
1453: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1454: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1455: RETURN;
1456: END IF;
1457: END IF;
1458: OPEN c_gst(

Line 1465: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

1461: FETCH c_gst INTO v_closed_ind;
1462: IF c_gst%NOTFOUND THEN
1463: CLOSE c_gst;
1464: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
1465: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1467: RETURN;
1468: ELSE
1469: CLOSE c_gst;

Line 1466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1462: IF c_gst%NOTFOUND THEN
1463: CLOSE c_gst;
1464: Fnd_Message.Set_Name('IGS', 'IGS_GE_INVALID_VALUE');
1465: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1467: RETURN;
1468: ELSE
1469: CLOSE c_gst;
1470: IF v_closed_ind = 'Y' THEN

Line 1472: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

1468: ELSE
1469: CLOSE c_gst;
1470: IF v_closed_ind = 'Y' THEN
1471: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_STATUS_CLOSED');
1472: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1473: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1474: RETURN;
1475: END IF;
1476: END IF;

Line 1473: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1469: CLOSE c_gst;
1470: IF v_closed_ind = 'Y' THEN
1471: Fnd_Message.Set_Name('IGS', 'IGS_GR_GRAD_STATUS_CLOSED');
1472: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
1473: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1474: RETURN;
1475: END IF;
1476: END IF;
1477: -- Find potential and eligible graduands

Line 1572: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log);

1568: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_PRG');
1569: l_log := l_log||' '||FND_MESSAGE.GET()||': '''||v_gr_gst_rec.course_cd||' '||v_gr_gst_rec.award_crs_version_number||'''';
1570: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_PROGRAM_AWARDS');
1571: l_log := l_log||' '||FND_MESSAGE.GET()||': '''||v_gr_gst_rec.award_cd||'''';
1572: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log);
1573: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||l_message_text);
1574: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1575: END;
1576: END;

Line 1573: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||l_message_text);

1569: l_log := l_log||' '||FND_MESSAGE.GET()||': '''||v_gr_gst_rec.course_cd||' '||v_gr_gst_rec.award_crs_version_number||'''';
1570: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_PROGRAM_AWARDS');
1571: l_log := l_log||' '||FND_MESSAGE.GET()||': '''||v_gr_gst_rec.award_cd||'''';
1572: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log);
1573: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||l_message_text);
1574: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1575: END;
1576: END;
1577: END IF;

Line 1574: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1570: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_PROGRAM_AWARDS');
1571: l_log := l_log||' '||FND_MESSAGE.GET()||': '''||v_gr_gst_rec.award_cd||'''';
1572: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log);
1573: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||l_message_text);
1574: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1575: END;
1576: END;
1577: END IF;
1578: CLOSE c_sp_exists;

Line 1785: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');

1781: --
1782: --Log the Parameters value in the log file. This is to fix Bug# 2690151
1783: --
1784: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
1785: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);

Line 1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);

1782: --Log the Parameters value in the log file. This is to fix Bug# 2690151
1783: --
1784: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
1785: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);

Line 1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);

1783: --
1784: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
1785: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1791: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_group_multi_award_ind = '||p_group_multi_award_ind);

Line 1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);

1784: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_ANC_LOG_PARM');
1785: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1791: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_group_multi_award_ind = '||p_group_multi_award_ind);
1792: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode = '||p_mode);

Line 1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);

1785: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET()||':');
1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1791: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_group_multi_award_ind = '||p_group_multi_award_ind);
1792: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode = '||p_mode);
1793:

Line 1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);

1786: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_cal_type = '||p_grd_cal_type);
1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1791: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_group_multi_award_ind = '||p_group_multi_award_ind);
1792: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode = '||p_mode);
1793:
1794: --1. Check parameters :

Line 1791: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_group_multi_award_ind = '||p_group_multi_award_ind);

1787: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_grd_ci_sequence_number = '||p_grd_ci_sequence_number);
1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1791: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_group_multi_award_ind = '||p_group_multi_award_ind);
1792: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode = '||p_mode);
1793:
1794: --1. Check parameters :
1795: IF p_grd_cal_type IS NULL OR

Line 1792: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode = '||p_mode);

1788: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ceremony_number = '||p_ceremony_number);
1789: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_order_by = '||p_order_by);
1790: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_ignore_unit_sets_ind = '||p_ignore_unit_sets_ind);
1791: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_group_multi_award_ind = '||p_group_multi_award_ind);
1792: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode = '||p_mode);
1793:
1794: --1. Check parameters :
1795: IF p_grd_cal_type IS NULL OR
1796: p_grd_ci_sequence_number IS NULL OR

Line 1803: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809

1799: p_ignore_unit_sets_ind IS NULL OR
1800: p_group_multi_award_ind IS NULL THEN
1801: Fnd_Message.Set_Name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
1802: --App_Exception.Raise_Exception;
1803: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1804: RETURN;
1805: END IF;
1806: --2. Loop through all of the IGS_GR_CRMN records
1807: -- which match the specifed parameters.

Line 1818: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809

1814: --4. If any records are found raise an error.
1815: CLOSE c_awc;
1816: Fnd_Message.Set_Name('IGS', 'IGS_GR_AWD_CERM_REC_CLOSED');
1817: --App_Exception.Raise_Exception;
1818: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1819: RETURN;
1820: END IF;
1821: CLOSE c_awc;
1822: --5. Check if the IGS_GR_CRMN has any related graduand_award_cermony

Line 1832: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809

1828: --6. If any records are found raise an error.
1829: CLOSE c_acusg;
1830: Fnd_Message.Set_Name('IGS', 'IGS_GR_AWD_CERM_UNIT_SET_CLOS');
1831: --App_Exception.Raise_Exception;
1832: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1833: RETURN;
1834: END IF;
1835: CLOSE c_acusg;
1836: --7. Clear the order_in_presentation for all of the IGS_GR_AWD_CRMN

Line 1891: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809

1887: END IF;
1888: ROLLBACK TO sp_gac_del;
1889: Fnd_Message.Set_Name('IGS', 'IGS_GR_AWD_CERM_CANNOT_UPDATE');
1890: --App_Exception.Raise_Exception;
1891: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1892: WHEN OTHERS THEN
1893: ROLLBACK TO sp_gac_del;
1894: l_msg_text := fnd_message.get;
1895: IGS_GE_MSG_STACK.GET(1,'T',l_msg_text, l_index );

Line 1899: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809

1895: IGS_GE_MSG_STACK.GET(1,'T',l_msg_text, l_index );
1896: FND_MESSAGE.PARSE_ENCODED (l_msg_text, l_app_name, l_message_name);
1897: IF l_message_name IN ('IGS_GR_INVALID_PROC_PERIOD','IGS_GR_INV_DT_GRAD_CERM', 'IGS_GR_CLOSING_DT_REACHED') THEN
1898: Fnd_Message.Set_Name('IGS', l_message_name);
1899: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1900: RETURN;
1901: END IF;
1902: RAISE;
1903: END;

Line 2096: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

2092: igs_ge_msg_stack.get(1,'T',l_msg_text, l_index );
2093: fnd_message.parse_encoded (l_msg_text, l_app_name, l_message_name);
2094: IF l_message_name IN ('IGS_GR_INVALID_PROC_PERIOD','IGS_GR_INV_DT_GRAD_CERM', 'IGS_GR_CLOSING_DT_REACHED') THEN
2095: Fnd_Message.Set_Name('IGS', l_message_name);
2096: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
2097: RETURN;
2098: END IF;
2099: END;
2100: end loop;

Line 2156: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

2152: igs_ge_msg_stack.get(1,'T',l_msg_text, l_index );
2153: fnd_message.parse_encoded (l_msg_text, l_app_name, l_message_name);
2154: IF l_message_name IN ('IGS_GR_INVALID_PROC_PERIOD','IGS_GR_INV_DT_GRAD_CERM', 'IGS_GR_CLOSING_DT_REACHED') THEN
2155: Fnd_Message.Set_Name('IGS', l_message_name);
2156: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
2157: RETURN;
2158: END IF;
2159: END;
2160: END LOOP;

Line 2223: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809

2219: DBMS_SQL.CLOSE_CURSOR(v_gac_upd_c_handle);
2220: ROLLBACK TO sp_gac_upd;
2221: FND_MESSAGE.SET_NAME('IGS', 'IGS_GR_AWD_CERM_CANNOT_UPDATE');
2222: --App_Exception.Raise_Exception;
2223: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
2224: RETURN;
2225: WHEN OTHERS THEN
2226: ROLLBACK TO sp_gac_upd;
2227: RAISE;