DBA Data[Home] [Help]

APPS.IGS_EN_ENROLL_WLST dependencies on FND_NEW_MESSAGES

Line 15: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE

11: p_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE,
12: p_enrolled_yn OUT NOCOPY VARCHAR2 ,
13: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
14: p_version_number igs_en_su_attempt.version_number%TYPE,
15: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
16: ) AS
17:
18:
19: /******************************************************************

Line 242: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,

238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
239: p_person_id IN igs_en_su_attempt.person_id%TYPE,
240: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
241: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
242: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,
243: p_deny_warn OUT NOCOPY VARCHAR2,
244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE)
245: RETURN BOOLEAN AS
246: /******************************************************************

Line 730: lv_validate_unit_message fnd_new_messages.message_name%TYPE;

726: kkillams 24-04-2003 Passing NULL/0 depending on the IGS_EN_INCL_WLST_CP profile w.r.t. bug 2889975
727: ptandon 26-06-2003 Modified to display Person Number and Unit Code instead of Person Id and Uoo Id in the log.
728: Modified to display Max CP failure Error Message once if the student fails the same. Bug# 2841584
729: ******************************************************************/
730: lv_validate_unit_message fnd_new_messages.message_name%TYPE;
731: lv_validate_unit_steps_message VARCHAR2(2000);
732: lv_validate_prog_message VARCHAR2(2000);
733: lv_dummy_message fnd_new_messages.message_name%TYPE;
734:

Line 733: lv_dummy_message fnd_new_messages.message_name%TYPE;

729: ******************************************************************/
730: lv_validate_unit_message fnd_new_messages.message_name%TYPE;
731: lv_validate_unit_steps_message VARCHAR2(2000);
732: lv_validate_prog_message VARCHAR2(2000);
733: lv_dummy_message fnd_new_messages.message_name%TYPE;
734:
735: lv_unit_deny_warn VARCHAR2(100);
736: lv_unit_steps_deny_warn VARCHAR2(100);
737: lv_prog_deny_warn VARCHAR2(100);

Line 1324: lv_validate_unit_message fnd_new_messages.message_name%TYPE;

1320: RETURN BOOLEAN AS
1321:
1322: lv_validate_unit_steps_message VARCHAR2(2000);
1323: lv_unit_steps_deny_warn VARCHAR2(100);
1324: lv_validate_unit_message fnd_new_messages.message_name%TYPE;
1325: lv_unit_deny_warn VARCHAR2(100);
1326:
1327: CURSOR c_teach_cal (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1328: SELECT cal_type, ci_sequence_number

Line 1503: lv_enroll_message_name fnd_new_messages.message_name%TYPE;

1499: ln_tab_fail_mail_ind NUMBER;
1500: val_success_nadm_persons_tab tab_succ_mail;
1501: ln_nadm_val_success NUMBER;
1502: lv_finalize_unit_message VARCHAR2(2000);
1503: lv_enroll_message_name fnd_new_messages.message_name%TYPE;
1504: filtered_sorted_tab tab_succ_mail;
1505: ln_message_count NUMBER(4);
1506: lv_dummy_message fnd_new_messages.message_name%TYPE;
1507:

Line 1506: lv_dummy_message fnd_new_messages.message_name%TYPE;

1502: lv_finalize_unit_message VARCHAR2(2000);
1503: lv_enroll_message_name fnd_new_messages.message_name%TYPE;
1504: filtered_sorted_tab tab_succ_mail;
1505: ln_message_count NUMBER(4);
1506: lv_dummy_message fnd_new_messages.message_name%TYPE;
1507:
1508: -- cursor to fetch the First Load Calendar for the Teaching Calendar
1509: CURSOR cur_teach_to_load(p_cal_type IGS_CA_INST.cal_type%TYPE,
1510: p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS