DBA Data[Home] [Help]

APPS.IGS_PR_CLASS_RANK dependencies on FND_FILE

Line 138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cal_period_old : ' || p_cal_period);

134: retcode:=0;
135:
136: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
137:
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cal_period_old : ' || p_cal_period);
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cohort_name_old : ' || p_cohort_name);
140: l_student_count := 1;
141:
142: -- Determining the Calander Type from the Calender Period Passed

Line 139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cohort_name_old : ' || p_cohort_name);

135:
136: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
137:
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cal_period_old : ' || p_cal_period);
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cohort_name_old : ' || p_cohort_name);
140: l_student_count := 1;
141:
142: -- Determining the Calander Type from the Calender Period Passed
143: p_cal_type := RTRIM(LTRIM(SUBSTR(p_cal_period,1,10))) ;

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

330:
331: IF l_count = 0 THEN
332:
333: FND_MESSAGE.SET_NAME('IGS','IGS_PR_RNK_NO_POP');
334: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
335:
336: END IF;
337:
338:

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

349: END IF;
350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_PR_RNK_COMP');
352: FND_MESSAGE.SET_TOKEN('RANKCOUNT',l_student_count);
353: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
354: EXCEPTION
355: WHEN invalid_parameter_combination THEN
356: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :' || SQLERRM);
357: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 356: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :' || SQLERRM);

352: FND_MESSAGE.SET_TOKEN('RANKCOUNT',l_student_count);
353: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
354: EXCEPTION
355: WHEN invalid_parameter_combination THEN
356: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :' || SQLERRM);
357: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
358: retcode := 2;
359: errbuf := fnd_message.get_string('IGS','IGS_PR_RNK_INV_PRM');
360: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

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

353: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
354: EXCEPTION
355: WHEN invalid_parameter_combination THEN
356: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :' || SQLERRM);
357: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
358: retcode := 2;
359: errbuf := fnd_message.get_string('IGS','IGS_PR_RNK_INV_PRM');
360: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
361: WHEN OTHERS THEN

Line 362: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :' || SQLERRM);

358: retcode := 2;
359: errbuf := fnd_message.get_string('IGS','IGS_PR_RNK_INV_PRM');
360: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
361: WHEN OTHERS THEN
362: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :' || SQLERRM);
363: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
364: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_CLASS_RANK.RUN_RANKING_PROCESS');
365: retcode := 2;
366: errbuf := fnd_message.get;

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

597: --
598: -- If the Rank Status is FINAL then no ranking is done and message 'IGS_PR_RNK_FINAL' should be displayed on the log file
599: --
600: FND_MESSAGE.SET_NAME('IGS','IGS_PR_RNK_FINAL');
601: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
602:
603: -- If the ranking status is not FINAL ie it is WORKING then the following needa to be done
604:
605: ELSE --1

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

988:
989: IF l_new_count = 0 THEN
990:
991: FND_MESSAGE.SET_NAME('IGS','IGS_PR_RNK_NO_POP');
992: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
993:
994: END IF;
995:
996: -- Deleting Records which from the Cohort Instance Rank table, which do not fit the rule criterian any more.

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

1167:
1168: IF l_new_count = 0 THEN
1169:
1170: FND_MESSAGE.SET_NAME('IGS','IGS_PR_RNK_NO_POP');
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1172:
1173: END IF;
1174:
1175: -- Deleting Records which from the Cohort Instance Rank table, which do not fit the rule criterian any more.