DBA Data[Home] [Help]

APPS.IGS_EN_TIMESLOTS dependencies on FND_FILE

Line 1503: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||cur_prty_pref_rec_2.priority_value

1499: cur_prty_pref_rec_2.sequence_number,
1500: p_pointer,
1501: p_ts_stup_id);
1502: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_PR_PF_PV');
1503: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||cur_prty_pref_rec_2.priority_value
1504: ||':'||cur_prty_pref_rec_2.preference_code||':'||cur_prty_pref_rec_2.preference_version
1505: ||':'||cur_prty_pref_rec_2.sequence_number);
1506: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_SAT_PR');
1507: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_3.COUNT);

Line 1507: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_3.COUNT);

1503: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||cur_prty_pref_rec_2.priority_value
1504: ||':'||cur_prty_pref_rec_2.preference_code||':'||cur_prty_pref_rec_2.preference_version
1505: ||':'||cur_prty_pref_rec_2.sequence_number);
1506: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_SAT_PR');
1507: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_3.COUNT);
1508:
1509: IF p_pointer = nvl(max_prty_ord,0) THEN
1510: enrp_sort_mngt(plsql_3,p_surname_alpha,p_pointer);
1511: plsql_3 := plsql_empty;

Line 1728: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_1.COUNT);

1724:
1725: plsql_1 := enrp_total_students(p_prg_type_gr_cd ,p_stud_type ,p_cal_type ,p_seq_num);
1726:
1727: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_SAT_CRI');
1728: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_1.COUNT);
1729: OPEN cur_assign_ran_alpha;
1730: FETCH cur_assign_ran_alpha INTO assign_random, surname_alpha; -- Assigned here to surname_alpha also by Nishikant - 23JUL2002 - bug#2443771
1731: CLOSE cur_assign_ran_alpha;
1732:

Line 1736: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);

1732:
1733: -- If assigning the timeslots randomly/if time is unlimited then no need to sort
1734: IF p_length_of_time = 0 OR assign_random = 'Y' THEN
1735: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_ASSGN_RAN');
1736: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
1737: FOR i IN 1 .. plsql_1.COUNT LOOP
1738: cnt4 := cnt4 + 1; -- cnt4 variable is declared in package spec.
1739: plsql_4(cnt4).person_id := plsql_1(i).person_id;
1740: plsql_4(cnt4).last_name := plsql_1(i).last_name;

Line 1769: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||cur_prty_pref_rec_1.priority_value

1765: cur_prty_pref_rec_1.sequence_number,
1766: i,
1767: l_ts_stup_id);
1768: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_PR_PF_PV');
1769: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||cur_prty_pref_rec_1.priority_value
1770: ||':'||cur_prty_pref_rec_1.preference_code||':'||cur_prty_pref_rec_1.preference_version
1771: ||':'||cur_prty_pref_rec_1.sequence_number);
1772: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_SAT_PR');
1773: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_2.COUNT);

Line 1773: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_2.COUNT);

1769: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||cur_prty_pref_rec_1.priority_value
1770: ||':'||cur_prty_pref_rec_1.preference_code||':'||cur_prty_pref_rec_1.preference_version
1771: ||':'||cur_prty_pref_rec_1.sequence_number);
1772: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_SAT_PR');
1773: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_2.COUNT);
1774: IF i < max_prty_ord THEN
1775: -- call to recursive function to sort according to priority And preferences
1776: enrp_recur_sort(plsql_2,surname_alpha,l_ts_stup_id,i+1);
1777: ELSE

Line 1784: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_1.COUNT);

1780: END IF;
1781: END LOOP; -- cur_prty_pref_rec_1
1782: END LOOP; -- max_prty_ord
1783: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_NOT_SAT');
1784: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_1.COUNT);
1785: -- sort the remaining students in plsql_1 and insert them into plsql_4
1786: plsql_2 := enrp_alpha_sort(plsql_1,surname_alpha);
1787: FOR i IN 1 .. plsql_2.COUNT LOOP
1788: cnt4 := cnt4 + 1; -- cnt4 variable is declared in package spec.

Line 1801: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_5.COUNT );

1797: p_start_date,
1798: p_end_date,
1799: p_length_of_time);
1800: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_TOT_TS_SES');
1801: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||plsql_5.COUNT );
1802:
1803: -- If the same Criteria has run in Trial Mode, then delete the existing records and insert the new set of data
1804: OPEN cur_mode_check;
1805: FETCH cur_mode_check INTO l_rowid ,l_ts_para_id , l_ts_mode;

Line 1840: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);

1836: -- inserting results of timeslot assignment into results Table
1837: enrp_rslt_ins_timeslot(plsql_4,plsql_5,p_max_headcount,l_igs_en_timeslot_para_id,p_length_of_time);
1838:
1839: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_COMP_SUSS');
1840: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
1841: plsql_4 := plsql_empty_4;
1842: cnt4:=0;
1843:
1844: EXCEPTION

Line 1847: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error due to :'||sqlerrm);

1843:
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: retcode:=2;
1847: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error due to :'||sqlerrm);
1848: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1849: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1850: END enrp_assign_timeslot;
1851: