DBA Data[Home] [Help]

APPS.IGS_EN_ENROLL_WLST dependencies on IGS_EN_ENROLL_WLST

Line 1: PACKAGE BODY Igs_En_Enroll_Wlst AS

1: PACKAGE BODY Igs_En_Enroll_Wlst AS
2: /* $Header: IGSEN73B.pls 120.9 2005/12/12 03:32:10 appldev ship $ */
3:
4: /*** Enrolling Persons - Called in loop for Validated filtered student PL/SQL tables **/
5: PROCEDURE Enroll_Persons(p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

Line 852: igs_en_enroll_wlst.ss_eval_min_or_max_cp(

848: validation were commented out NOCOPY in the eval_program_steps, explicitly calling the
849: same from here
850: ****************************************************************************/
851: lv_return_status := NULL;
852: igs_en_enroll_wlst.ss_eval_min_or_max_cp(
853: p_person_id => p_person_id,
854: p_load_cal_type => p_cal_type,
855: p_load_ci_sequence_number => p_ci_sequence_number,
856: p_uoo_id => p_uoo_id,

Line 882: igs_en_enroll_wlst.ss_eval_min_or_max_cp(

878:
879: IF lb_validate_prog THEN
880: lv_validate_prog_message := NULL;
881: lv_return_status := NULL;
882: igs_en_enroll_wlst.ss_eval_min_or_max_cp(
883: p_person_id => p_person_id,
884: p_load_cal_type => p_cal_type,
885: p_load_ci_sequence_number => p_ci_sequence_number,
886: p_uoo_id => p_uoo_id,

Line 938: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_prog_message);

934: DECLARE
935: v_temp_message_Str VARCHAR2(2000);
936: BEGIN
937: v_temp_message_Str := NULL;
938: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_prog_message);
939: IF ln_message_count > 0 THEN
940: FOR I IN 1..ln_message_count LOOP
941: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_prog_message,I);
942: IF lv_dummy_message IS NOT NULL THEN

Line 941: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_prog_message,I);

937: v_temp_message_Str := NULL;
938: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_prog_message);
939: IF ln_message_count > 0 THEN
940: FOR I IN 1..ln_message_count LOOP
941: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_prog_message,I);
942: IF lv_dummy_message IS NOT NULL THEN
943: IF INSTR(lv_dummy_message,'*') > 0 THEN
944: lv_dummy_message := SUBSTR(lv_dummy_message,1,INSTR(lv_dummy_message,'*')-1) || '_NO_TOKEN' ;
945: END IF;

Line 976: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_prog_message);

972:
973: lv_validate_prog_message := p_message_name;
974: IF lv_validate_prog_message IS NOT NULL THEN
975:
976: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_prog_message);
977: IF ln_message_count > 0 THEN
978: FOR I IN 1..ln_message_count LOOP
979: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_prog_message,I);
980: IF lv_dummy_message IS NOT NULL THEN

Line 979: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_prog_message,I);

975:
976: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_prog_message);
977: IF ln_message_count > 0 THEN
978: FOR I IN 1..ln_message_count LOOP
979: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_prog_message,I);
980: IF lv_dummy_message IS NOT NULL THEN
981: fnd_message.set_name('IGS',lv_dummy_message);
982: fnd_file.put_line (fnd_file.LOG, ' '|| p_unit_cd || ' ' || v_person_number || ' ' ||fnd_message.get);
983: ELSE

Line 1021: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_unit_message);

1017: END IF;
1018:
1019: END IF;
1020:
1021: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_unit_message);
1022: IF ln_message_count > 0 THEN
1023: FOR I IN 1..ln_message_count LOOP
1024: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_unit_message,I);
1025: IF lv_dummy_message IS NOT NULL THEN

Line 1024: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_unit_message,I);

1020:
1021: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_unit_message);
1022: IF ln_message_count > 0 THEN
1023: FOR I IN 1..ln_message_count LOOP
1024: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_unit_message,I);
1025: IF lv_dummy_message IS NOT NULL THEN
1026: fnd_message.set_name('IGS',lv_dummy_message);
1027: fnd_file.put_line (fnd_file.LOG, ' '|| p_unit_cd || ' ' || v_person_number || ' ' ||fnd_message.get);
1028: ELSE

Line 1073: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_unit_steps_message);

1069: v_temp_message_Str VARCHAR2(2000);
1070: BEGIN
1071:
1072: v_temp_message_Str := NULL;
1073: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_unit_steps_message);
1074: IF ln_message_count > 0 THEN
1075: FOR I IN 1..ln_message_count LOOP
1076: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_unit_steps_message,I);
1077: IF lv_dummy_message IS NOT NULL THEN

Line 1076: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_unit_steps_message,I);

1072: v_temp_message_Str := NULL;
1073: ln_message_count := Igs_En_Enroll_Wlst.get_message_count(lv_validate_unit_steps_message);
1074: IF ln_message_count > 0 THEN
1075: FOR I IN 1..ln_message_count LOOP
1076: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_unit_steps_message,I);
1077: IF lv_dummy_message IS NOT NULL THEN
1078: IF INSTR(lv_dummy_message,'*') > 0 THEN
1079: lv_dummy_message := SUBSTR(lv_dummy_message,1,INSTR(lv_dummy_message,'*')-1) || '_NO_TOKEN' ;
1080: END IF;

Line 1659: p_tab_fail_mail(ln_tab_fail_mail_ind).message_name := Igs_En_Enroll_Wlst.get_message(lv_finalize_unit_message,ln_message_count);

1655: ELSE
1656: ln_tab_fail_mail_ind := NVL(ln_tab_fail_mail_ind,0) + 1; -- Increment by failure records by 1
1657: p_tab_fail_mail(ln_tab_fail_mail_ind).person_id := v_adm_prf_cur.person_id;
1658: p_tab_fail_mail(ln_tab_fail_mail_ind).course_cd := v_adm_prf_cur.course_cd;
1659: p_tab_fail_mail(ln_tab_fail_mail_ind).message_name := Igs_En_Enroll_Wlst.get_message(lv_finalize_unit_message,ln_message_count);
1660:
1661: -- Any unit validation failed then rollback. pmarada, bug 2526021
1662: ROLLBACK TO failed_unit_validation;
1663:

Line 1837: FND_MESSAGE.SET_TOKEN('NAME','Igs_En_Enroll_Wlst.Enroll_From_WaitList');

1833:
1834: retcode:=2;
1835: fnd_file.put_line(fnd_file.LOG,SQLERRM);
1836: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1837: FND_MESSAGE.SET_TOKEN('NAME','Igs_En_Enroll_Wlst.Enroll_From_WaitList');
1838: IGS_GE_MSG_STACK.ADD;
1839: igs_ge_msg_stack.conc_exception_hndl;
1840:
1841: END Enroll_From_WaitList; -- End of main procedure

Line 2150: END Igs_En_Enroll_Wlst; -- End of package body

2146: RETURN ;
2147:
2148: END ss_eval_min_or_max_cp;
2149:
2150: END Igs_En_Enroll_Wlst; -- End of package body