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_EN_GEN_011 dependencies on IGS_GE_S_LOG

Line 298: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE ;

294:
295: v_rollback_occurred BOOLEAN := FALSE;
296: v_processing_occurred BOOLEAN :=FALSE;
297: v_course_key VARCHAR2(255) ;
298: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE ;
299: v_total_sca_count NUMBER := 0;
300: v_total_sca_error_count NUMBER := 0;
301: v_total_sca_warn_count NUMBER := 0;
302: v_total_sca_trnsfr_count NUMBER := 0;

Line 1194: -- It will write any IGS_GE_EXCEPTIONS and log information to the IGS_GE_S_LOG_ENTRY

1190: -- for a specified group of students.
1191: -- The module will process each student course attempt for the given
1192: -- student course attempt selection parameters and then apply the IGS_PS_UNIT
1193: -- alterations (enrol/discontinue) to the student's course.
1194: -- It will write any IGS_GE_EXCEPTIONS and log information to the IGS_GE_S_LOG_ENTRY
1195: -- table which will be used in an exception report.
1196: -- After enrolling or discontinuing, a validation check is performed
1197: -- for the student's course attempt to determine if any IGS_GE_EXCEPTIONS
1198: -- exists for the students course enrolment.

Line 1251: cst_enr_blk_ua CONSTANT igs_ge_s_log.s_log_type%TYPE := 'ENR-BLK-UA';

1247: cst_unconfirm CONSTANT VARCHAR2 (35) := 'UNCONFIRM';
1248: cst_drop CONSTANT VARCHAR2 (35) := 'DROPPED';
1249: cst_waitlist CONSTANT VARCHAR2 (35) := 'WAITLISTED';
1250: cst_invalid CONSTANT VARCHAR2 (35) := 'INVALID';
1251: cst_enr_blk_ua CONSTANT igs_ge_s_log.s_log_type%TYPE := 'ENR-BLK-UA';
1252: cst_blk_ua CONSTANT VARCHAR2 (35) := 'BULK UNIT ENROLMENT/DISCONTINUATION';
1253: cst_inactive CONSTANT VARCHAR2 (35) := 'INACTIVE';
1254: cst_enrolled CONSTANT VARCHAR2 (35) := 'ENROLLED';
1255: cst_intermit CONSTANT VARCHAR2 (35) := 'INTERMIT';

Line 1257: cst_summary CONSTANT igs_ge_s_log_entry.key%TYPE := 'SUMMARY';

1253: cst_inactive CONSTANT VARCHAR2 (35) := 'INACTIVE';
1254: cst_enrolled CONSTANT VARCHAR2 (35) := 'ENROLLED';
1255: cst_intermit CONSTANT VARCHAR2 (35) := 'INTERMIT';
1256: cst_complete CONSTANT VARCHAR2 (35) := 'COMPLETED';
1257: cst_summary CONSTANT igs_ge_s_log_entry.key%TYPE := 'SUMMARY';
1258:
1259:
1260:
1261: t_sua_enroll t_sua_typ;

Line 1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;

1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;
1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;
1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;
1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;

Line 1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;

1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;
1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;
1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;
1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;
1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;

Line 1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;

1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;
1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;
1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;
1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;
1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;

Line 1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;

1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;
1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;
1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;
1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;
1315: l_total_credit_points IGS_EN_SU_ATTEMPT.override_enrolled_cp%TYPE ;

Line 1484: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;

1480: cst_information CONSTANT VARCHAR2(12) := 'INFORMATION|';
1481: l_messages VARCHAR2(2000);
1482: l_mesg_name VARCHAR2(2000);
1483: l_mesg_txt VARCHAR2(2000);
1484: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1485: l_err_type VARCHAR2(30);
1486: l_msg_len NUMBER ;
1487: l_msg_token VARCHAR2(100);
1488: l_str_place NUMBER(3);

Line 1590: -- Clear pl/sql table for writing IGS_GE_S_LOG_ENTRY records

1586: igs_ge_msg_stack.add;
1587: app_exception.raise_exception;
1588: END IF;
1589: CLOSE cur_cal_rel;
1590: -- Clear pl/sql table for writing IGS_GE_S_LOG_ENTRY records
1591: IGS_GE_INS_SLE.genp_set_log_cntr;
1592: -- Determine the (first) academic period of the teaching period.
1593: l_message_name := NULL;
1594: l_alternate_code := igs_en_gen_002.enrp_get_acad_alt_cd(p_cal_type =>p_teach_cal_type,

Line 2839: FROM IGS_GE_S_LOG_ENTRY sle

2835: cp_rule_creation_dt DATE) IS
2836: SELECT sle.key,
2837: sle.message_name,
2838: sle.text
2839: FROM IGS_GE_S_LOG_ENTRY sle
2840: WHERE sle.s_log_type = cst_enr_blk_uo AND
2841: sle.creation_dt = cp_rule_creation_dt
2842: ORDER BY sle.sequence_number;
2843: CURSOR c_sle_del (

Line 2846: FROM IGS_GE_S_LOG_ENTRY

2842: ORDER BY sle.sequence_number;
2843: CURSOR c_sle_del (
2844: cp_rule_creation_dt DATE) IS
2845: SELECT rowid,'x'
2846: FROM IGS_GE_S_LOG_ENTRY
2847: WHERE s_log_type = cst_enr_blk_uo AND
2848: creation_dt = cp_rule_creation_dt
2849: FOR UPDATE OF LAST_UPDATED_BY NOWAIT;
2850: v_sle_del_exists VARCHAR2(1) ;

Line 2854: FROM IGS_GE_S_LOG

2850: v_sle_del_exists VARCHAR2(1) ;
2851: CURSOR c_sl_del (
2852: cp_rule_creation_dt DATE) IS
2853: SELECT rowid,'x'
2854: FROM IGS_GE_S_LOG
2855: WHERE s_log_type = cst_enr_blk_uo AND
2856: creation_dt = cp_rule_creation_dt
2857: FOR UPDATE OF LAST_UPDATED_BY NOWAIT;
2858:

Line 2907: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE ;

2903: v_text VARCHAR2(255) ;
2904: v_fail_type VARCHAR2(10) ;
2905: v_alt_cd VARCHAR2(255) ; -- return parameter, useless
2906: v_rule_creation_dt DATE ;
2907: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE ;
2908:
2909: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
2910: l_commencement_type VARCHAR2(20) DEFAULT NULL;
2911: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

Line 5281: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(

5277: END IF; -- end of rules failed
5278: -- Remove the temporary log entries.
5279: FOR v_sle_del_exists IN c_sle_del(
5280: v_rule_creation_dt) LOOP
5281: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(
5282: v_sle_del_exists.rowid);
5283:
5284: END LOOP;
5285: -- Remove the temporary log entries.

Line 5288: IGS_GE_S_LOG_PKG.DELETE_ROW(

5284: END LOOP;
5285: -- Remove the temporary log entries.
5286: FOR v_sl_del_exists IN c_sl_del(
5287: v_rule_creation_dt) LOOP
5288: IGS_GE_S_LOG_PKG.DELETE_ROW(
5289: v_sl_del_exists.rowid);
5290:
5291: END LOOP;
5292: -- Log errors and continue.