DBA Data[Home] [Help]

APPS.IGS_EN_TIMESLOTS dependencies on FND_MESSAGE

Line 144: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

140: END IF;
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
145: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_para_calculation');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END enrp_para_calculation;

Line 145: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_para_calculation');

141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
145: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_para_calculation');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END enrp_para_calculation;
149:

Line 215: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

211: RETURN plsql_5;
212:
213: EXCEPTION
214: WHEN OTHERS THEN
215: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
216: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_calc_slots');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: END enrp_calc_slots;

Line 216: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_calc_slots');

212:
213: EXCEPTION
214: WHEN OTHERS THEN
215: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
216: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_calc_slots');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: END enrp_calc_slots;
220:

Line 691: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

687: NULL;
688: END IF;
689: EXCEPTION
690: WHEN OTHERS THEN
691: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
692: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_cur_criteria');
693: IGS_GE_MSG_STACK.ADD;
694: App_Exception.Raise_Exception;
695: END enrp_cur_criteria;

Line 692: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_cur_criteria');

688: END IF;
689: EXCEPTION
690: WHEN OTHERS THEN
691: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
692: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_cur_criteria');
693: IGS_GE_MSG_STACK.ADD;
694: App_Exception.Raise_Exception;
695: END enrp_cur_criteria;
696:

Line 1429: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1425: END LOOP;
1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1430: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_sort_mngt');
1431: IGS_GE_MSG_STACK.ADD;
1432: App_Exception.Raise_Exception;
1433: END enrp_sort_mngt;

Line 1430: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_sort_mngt');

1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1430: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_sort_mngt');
1431: IGS_GE_MSG_STACK.ADD;
1432: App_Exception.Raise_Exception;
1433: END enrp_sort_mngt;
1434:

Line 1502: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_PR_PF_PV');

1498: cur_prty_pref_rec_2.preference_version,
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');

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 1506: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_SAT_PR');

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);
1508:
1509: IF p_pointer = nvl(max_prty_ord,0) THEN
1510: enrp_sort_mngt(plsql_3,p_surname_alpha,p_pointer);

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 1609: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1605: END IF;--p_length_of_time = 0
1606:
1607: EXCEPTION
1608: WHEN OTHERS THEN
1609: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1610: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_rslt_ins_timeslot');
1611: IGS_GE_MSG_STACK.ADD;
1612: App_Exception.Raise_Exception;
1613: END enrp_rslt_ins_timeslot;

Line 1610: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_rslt_ins_timeslot');

1606:
1607: EXCEPTION
1608: WHEN OTHERS THEN
1609: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1610: FND_MESSAGE.SET_TOKEN('NAME','Igs_en_timeslots.enrp_rslt_ins_timeslot');
1611: IGS_GE_MSG_STACK.ADD;
1612: App_Exception.Raise_Exception;
1613: END enrp_rslt_ins_timeslot;
1614:

Line 1727: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_SAT_CRI');

1723: CLOSE cur_ts_stup_id ;
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;

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 1735: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_ASSGN_RAN');

1731: CLOSE cur_assign_ran_alpha;
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;

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 1768: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_PR_PF_PV');

1764: cur_prty_pref_rec_1.preference_version,
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');

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 1772: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_SAT_PR');

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);
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);

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 1783: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_STD_NOT_SAT');

1779: enrp_sort_mngt(plsql_2,surname_alpha,i);
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

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 1800: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_TOT_TS_SES');

1796: p_end_time,
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;

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 1813: fnd_message.set_name('IGS','IGS_EN_TS_CRI_FINAL_AL');

1809: Igs_En_Timeslot_Rslt_Pkg.delete_row(x_rowid => cur_rslt_rec.row_id);
1810: END LOOP;
1811: Igs_En_Timeslot_Para_Pkg.delete_row(x_rowid => l_rowid);
1812: ELSIF l_ts_mode = 'F' THEN
1813: fnd_message.set_name('IGS','IGS_EN_TS_CRI_FINAL_AL');
1814: IGS_GE_MSG_STACK.ADD;
1815: App_Exception.Raise_Exception;
1816: END IF;
1817: END IF;

Line 1839: Fnd_Message.SET_NAME ('IGS','IGS_EN_TS_COMP_SUSS');

1835:
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:

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 1848: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

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:
1852: --------------------------------------------------------------------------