DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_GE_GEN_003

Line 706: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

702: p_acad_sequence_number,
703: p_dflt_confirmed_course_ind,
704: v_message_name) THEN
705: IF p_log_creation_dt IS NOT NULL THEN
706: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
707: cst_pre_enrol,
708: p_log_creation_dt,
709: cst_minor || ',' ||
710: TO_CHAR(p_person_id) || ',' ||

Line 750: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

746: FETCH c_acaiv INTO v_acaiv_rec;
747: IF c_acaiv%NOTFOUND THEN
748: CLOSE c_acaiv;
749: IF p_log_creation_dt IS NOT NULL THEN
750: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
751: cst_pre_enrol,
752: p_log_creation_dt,
753: cst_error || ',' ||
754: TO_CHAR(p_person_id) || ',' ||

Line 771: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

767: IF c_acaiv1%NOTFOUND THEN
768: CLOSE c_acaiv1;
769: -- Application not found - pre - enrolment not possible.
770: IF p_log_creation_dt IS NOT NULL THEN
771: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
772: cst_pre_enrol,
773: p_log_creation_dt,
774: cst_error || ',' ||
775: TO_CHAR(p_person_id) || ',' ||

Line 868: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

864: -- Cannot determine which IGS_RE_CANDIDATURE should be used.
865: -- Rollback to start of routine
866: ROLLBACK TO sp_pre_enrol_student;
867: IF p_log_creation_dt IS NOT NULL THEN
868: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
869: cst_pre_enrol,
870: p_log_creation_dt,
871: cst_error || ',' ||
872: TO_CHAR(p_person_id) || ',' ||

Line 1220: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

1216: END IF;
1217:
1218: DECLARE
1219: l_rowid VARCHAR2(25);
1220: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
1221: BEGIN
1222:
1223: --set the catalog details only if SPA is confirmed.
1224: IF nvl(v_confirmed_ind,'N') = 'Y' THEN

Line 1702: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

1698: END;
1699: ELSE
1700: -- IGS_PE_PERSON does not have a current admission offer.
1701: IF p_log_creation_dt IS NOT NULL THEN
1702: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1703: cst_pre_enrol,
1704: p_log_creation_dt,
1705: cst_error || ',' ||
1706: TO_CHAR(p_person_id) || ',' ||

Line 1963: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

1959: v_enr_cal_type,
1960: v_enr_sequence_number) THEN
1961: IF p_log_creation_dt IS NOT NULL THEN
1962: ROLLBACK TO sp_pre_enrol_student;
1963: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1964: cst_pre_enrol,
1965: p_log_creation_dt,
1966: cst_error || ',' ||
1967: TO_CHAR(p_person_id) || ',' ||

Line 1990: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

1986: IF v_enrolment_cat IS NULL THEN
1987: -- Cannot continue without an enrolment category
1988: IF p_log_creation_dt IS NOT NULL THEN
1989: ROLLBACK TO sp_pre_enrol_student;
1990: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1991: cst_pre_enrol,
1992: p_log_creation_dt,
1993: cst_error || ',' ||
1994: TO_CHAR(p_person_id) || ',' ||

Line 2225: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

2221: p_message_name) = FALSE THEN
2222:
2223: p_warn_level := cst_error;
2224: IF p_log_creation_dt IS NOT NULL THEN
2225: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2226: cst_pre_enrol,
2227: p_log_creation_dt,
2228: cst_error || ',' ||
2229: TO_CHAR(p_person_id) || ',' ||

Line 2536: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

2532: v_message_name) THEN
2533: IF p_log_creation_dt IS NOT NULL THEN
2534: -- If the log creation date is set then log the HECS error
2535: -- This is if the pre-enrolment is being performed in batch.
2536: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2537: cst_pre_enrol,
2538: p_log_creation_dt,
2539: v_warn_level || ',' ||
2540: TO_CHAR(p_person_id) || ',' ||

Line 2916: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

2912: v_message_name) THEN
2913: IF p_log_creation_dt IS NOT NULL THEN
2914: -- If the log creation date is set then log the HECS error
2915: -- This is if the pre-enrolment is being performed in batch.
2916: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2917: cst_pre_enrol,
2918: p_log_creation_dt,
2919: cst_minor || ',' ||
2920: TO_CHAR(p_person_id) || ',' ||

Line 2970: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

2966: v_attendance_mode,
2967: v_acaiv_rec.location_cd,
2968: v_uoo_id) THEN
2969: IF p_log_creation_dt IS NOT NULL THEN
2970: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2971: cst_pre_enrol,
2972: p_log_creation_dt,
2973: cst_minor || ',' ||
2974: TO_CHAR(p_person_id) || ',' ||

Line 3303: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

3299: 'Y');
3300: END IF;
3301: IF v_commencement_dt2 IS NULL THEN
3302: IF p_log_creation_dt IS NOT NULL THEN
3303: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
3304: cst_pre_enrol,
3305: p_log_creation_dt,
3306: cst_minor || ',' ||
3307: TO_CHAR(p_person_id) || ',' ||

Line 3331: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

3327: v_acaiv_rec.location_cd);
3328:
3329: IF v_completion_dt IS NULL THEN
3330: IF p_log_creation_dt IS NOT NULL THEN
3331: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
3332: cst_pre_enrol,
3333: p_log_creation_dt,
3334: cst_minor || ',' ||
3335: TO_CHAR(p_person_id) || ',' ||

Line 3352: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

3348: v_commencement_dt2, -- (Start Date)
3349: v_completion_dt, -- (End Date)
3350: v_message_name) THEN
3351: IF p_log_creation_dt IS NOT NULL THEN
3352: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
3353: cst_pre_enrol,
3354: p_log_creation_dt,
3355: cst_minor || ',' ||
3356: TO_CHAR(p_person_id) || ',' ||

Line 3402: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

3398: CLOSE c_load_cal;
3399: p_warn_level := cst_error;
3400: p_message_name := 'IGS_EN_CN_FIND_TERM_CAL';
3401: IF p_log_creation_dt IS NOT NULL THEN
3402: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
3403: cst_pre_enrol,
3404: p_log_creation_dt,
3405: cst_error || ',' ||
3406: TO_CHAR(p_person_id) || ',' ||

Line 3428: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

3424: IF l_return_status='FALSE' THEN
3425: p_warn_level := cst_error;
3426: p_message_name := 'IGS_SS_EN_NOENR_METHOD';
3427: IF p_log_creation_dt IS NOT NULL THEN
3428: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
3429: cst_pre_enrol,
3430: p_log_creation_dt,
3431: cst_error || ',' ||
3432: TO_CHAR(p_person_id) || ',' ||

Line 3535: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

3531: p_message_name) = FALSE THEN
3532:
3533: p_warn_level := cst_error;
3534: IF p_log_creation_dt IS NOT NULL THEN
3535: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
3536: cst_pre_enrol,
3537: p_log_creation_dt,
3538: cst_error || ',' ||
3539: TO_CHAR(p_person_id) || ',' ||

Line 3718: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

3714: p_message_name) = FALSE THEN
3715:
3716: p_warn_level := cst_error;
3717: IF p_log_creation_dt IS NOT NULL THEN
3718: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
3719: cst_pre_enrol,
3720: p_log_creation_dt,
3721: cst_error || ',' ||
3722: TO_CHAR(p_person_id) || ',' ||

Line 3969: igs_ge_gen_003.genp_ins_log_entry(p_s_log_type => cst_pre_enrol,

3965: ELSE
3966: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3967: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_snew_prenrl');
3968: l_mesg_txt := fnd_message.get;
3969: igs_ge_gen_003.genp_ins_log_entry(p_s_log_type => cst_pre_enrol,
3970: p_creation_dt => p_log_creation_dt,
3971: p_key => p_warn_level||','||TO_CHAR(p_person_id)||','||p_course_cd,
3972: p_s_message_name => 'IGS_GE_UNHANDLED_EXP',
3973: p_text => l_mesg_txt);

Line 4574: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

4570: v_message_name) THEN
4571: IF p_log_creation_dt IS NOT NULL THEN
4572: -- If the log creation date is set then log the HECS error
4573: -- This is if the pre-enrolment is being performed in batch.
4574: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
4575: cst_pre_enrol,
4576: p_log_creation_dt,
4577: cst_minor || ',' ||
4578: TO_CHAR(p_person_id) || ',' ||

Line 4628: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

4624: v_sca_rec.attendance_mode,
4625: v_sca_rec.location_cd,
4626: v_uoo_id) THEN
4627: IF p_log_creation_dt IS NOT NULL THEN
4628: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
4629: cst_pre_enrol,
4630: p_log_creation_dt,
4631: cst_minor || ',' ||
4632: TO_CHAR(p_person_id) || ',' ||

Line 4858: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

4854: FETCH c_load_cal INTO l_load_cal_type, l_load_seq_num;
4855: IF c_load_cal%NOTFOUND THEN
4856: CLOSE c_load_cal;
4857: IF p_log_creation_dt IS NOT NULL THEN
4858: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
4859: p_s_log_type => cst_pre_enrol,
4860: p_creation_dt => p_log_creation_dt,
4861: p_key => cst_error || ',' ||TO_CHAR(p_person_id) || ',' || p_course_cd,
4862: p_s_message_name =>'IGS_EN_CN_FIND_TERM_CAL',

Line 4883: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

4879: p_error_message => l_dummy_mesg,
4880: p_ret_status => l_return_status);
4881: IF l_return_status='FALSE' THEN
4882: IF p_log_creation_dt IS NOT NULL THEN
4883: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
4884: p_s_log_type => cst_pre_enrol,
4885: p_creation_dt => p_log_creation_dt,
4886: p_key => cst_error || ',' ||TO_CHAR(p_person_id) || ',' || p_course_cd,
4887: p_s_message_name =>'IGS_SS_EN_NOENR_METHOD',

Line 4906: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

4902: 'Y', -- confirmed IGS_PS_COURSE attempt
4903: v_message_name) THEN
4904:
4905: IF p_log_creation_dt IS NOT NULL THEN
4906: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
4907: cst_pre_enrol,
4908: p_log_creation_dt,
4909: cst_error || ',' ||
4910: TO_CHAR(p_person_id) || ',' ||

Line 4928: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

4924: FETCH c_sca_details INTO v_sca_rec;
4925: IF c_sca_details%NOTFOUND THEN
4926: CLOSE c_sca_details;
4927: IF p_log_creation_dt IS NOT NULL THEN
4928: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
4929: cst_pre_enrol,
4930: p_log_creation_dt,
4931: cst_error || ',' ||
4932: TO_CHAR(p_person_id) || ',' ||

Line 5004: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

5000: FETCH c_prev_enr_cat INTO v_enr_cat;
5001: IF c_prev_enr_cat%NOTFOUND THEN
5002: CLOSE c_prev_enr_cat;
5003: IF p_log_creation_dt IS NOT NULL THEN
5004: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
5005: cst_pre_enrol,
5006: p_log_creation_dt,
5007: cst_error || ',' ||
5008: TO_CHAR(p_person_id) || ',' ||

Line 5059: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

5055: IF c_crv%NOTFOUND THEN
5056: CLOSE c_crv;
5057: -- * Warn that the IGS_PS_COURSE if not being offered
5058: IF p_log_creation_dt IS NOT NULL THEN
5059: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
5060: cst_pre_enrol,
5061: p_log_creation_dt,
5062: cst_minor || ',' ||
5063: TO_CHAR(p_person_id) || ',' ||

Line 5171: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

5167: p_message_name) = FALSE THEN
5168:
5169: p_warn_level := cst_error;
5170: IF p_log_creation_dt IS NOT NULL THEN
5171: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
5172: cst_pre_enrol,
5173: p_log_creation_dt,
5174: cst_error || ',' ||
5175: TO_CHAR(p_person_id) || ',' ||

Line 5549: igs_ge_gen_003.genp_ins_log_entry(p_s_log_type => cst_pre_enrol,

5545: ELSE -- unhandled exception
5546: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5547: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrp_ins_snew_prenrl');
5548: l_mesg_txt := fnd_message.get;
5549: igs_ge_gen_003.genp_ins_log_entry(p_s_log_type => cst_pre_enrol,
5550: p_creation_dt => p_log_creation_dt,
5551: p_key => p_warn_level||','||TO_CHAR(p_person_id)||','||p_course_cd,
5552: p_s_message_name => 'IGS_GE_UNHANDLED_EXP',
5553: p_text => l_mesg_txt);

Line 5659: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

5655: CLOSE c_suao_details;
5656:
5657: DECLARE
5658: l_rowid VARCHAR2(25);
5659: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
5660: BEGIN
5661: IGS_AS_SU_STMPTOUT_PKG.INSERT_ROW(
5662: x_rowid => l_rowid,
5663: x_person_id => p_person_id,

Line 5946: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

5942: END IF;
5943:
5944: DECLARE
5945: l_rowid VARCHAR2(25);
5946: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
5947: BEGIN
5948:
5949: IGS_EN_SU_ATTEMPT_H_PKG.INSERT_ROW (
5950: x_rowid => l_rowid,

Line 6473: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

6469:
6470: -- Transfer the student IGS_PS_UNIT attempt record
6471: DECLARE
6472: l_rowid VARCHAR2(25);
6473: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
6474: BEGIN
6475:
6476: IF NVL(FND_PROFILE.VALUE('IGS_EN_CORE_VAL'),'N') = 'Y' THEN
6477: v_sua_rec.core_indicator_code := NVL(p_core_ind, v_sua_rec.core_indicator_code);

Line 6764: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

6760:
6761:
6762: DECLARE
6763: l_rowid VARCHAR2(25);
6764: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
6765: BEGIN
6766: IGS_AS_SU_SETATMPT_H_PKG.INSERT_ROW (
6767: x_rowid => l_rowid,
6768: x_person_id => v_susa_rec.person_id,

Line 7128: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

7124: -------------------------------------------------------------------------------------------------
7125: --
7126: -- To get Org ID.
7127: --
7128: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
7129: --
7130: -- Cursor to get Exemption_Institution_Cd of the parent Program.
7131: --
7132: CURSOR cur_adv_stnd (cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_version_number NUMBER) IS

Line 8027: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

8023: p_message_name) = FALSE THEN
8024:
8025: p_warn_level := cst_error;
8026: IF p_log_creation_dt IS NOT NULL THEN
8027: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
8028: cst_pre_enrol,
8029: p_log_creation_dt,
8030: cst_error || ',' ||
8031: TO_CHAR(p_person_id) || ',' ||

Line 8117: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

8113: p_message_name) = FALSE THEN
8114:
8115: p_warn_level := cst_error;
8116: IF p_log_creation_dt IS NOT NULL THEN
8117: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
8118: cst_pre_enrol,
8119: p_log_creation_dt,
8120: cst_error || ',' ||
8121: TO_CHAR(p_person_id) || ',' ||

Line 8278: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

8274: p_message_name) = FALSE THEN
8275:
8276: p_warn_level := cst_error;
8277: IF p_log_creation_dt IS NOT NULL THEN
8278: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
8279: cst_pre_enrol,
8280: p_log_creation_dt,
8281: cst_error || ',' ||
8282: TO_CHAR(p_person_id) || ',' ||

Line 8363: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

8359: p_message_name) = FALSE THEN
8360:
8361: p_warn_level := cst_error;
8362: IF p_log_creation_dt IS NOT NULL THEN
8363: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
8364: cst_pre_enrol,
8365: p_log_creation_dt,
8366: cst_error || ',' ||
8367: TO_CHAR(p_person_id) || ',' ||

Line 8532: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

8528: p_message_name) = FALSE THEN
8529:
8530: p_warn_level := cst_error;
8531: IF p_log_creation_dt IS NOT NULL THEN
8532: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
8533: cst_pre_enrol,
8534: p_log_creation_dt,
8535: cst_error || ',' ||
8536: TO_CHAR(p_person_id) || ',' ||

Line 8828: igs_ge_gen_003.genp_ins_log_entry(p_s_log_type => p_s_log_type,

8824: ELSE
8825: fnd_message.set_name('IGS',l_mesg_name);
8826: END IF;
8827: l_mesg_txt := fnd_message.get;
8828: igs_ge_gen_003.genp_ins_log_entry(p_s_log_type => p_s_log_type,
8829: p_creation_dt => p_creation_dt,
8830: p_key => p_sle_key,
8831: p_s_message_name => l_mesg_name,
8832: p_text => l_mesg_txt);