DBA Data[Home] [Help]

APPS.IGS_EN_TRANSFER_APIS dependencies on FND_NEW_MESSAGES

Line 485: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

481: l_enr_seq_num IGS_AS_SC_ATMPT_ENR.CI_SEQUENCE_NUMBER%TYPE;
482: l_enr_category IGS_AS_SC_ATMPT_ENR.ENROLMENT_CAT%TYPE;
483: l_sub_ci_seq_num IGS_CA_INST_REL.SUB_CI_SEQUENCE_NUMBER%TYPE;
484: l_return_value BOOLEAN;
485: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
486:
487: CURSOR c_get_enrolment_cal_type IS
488: SELECT scae.cal_type, scae.ci_sequence_number, scae.enrolment_cat
489: FROM IGS_AS_SC_ATMPT_ENR scae, IGS_CA_INST ci

Line 572: l_message_name FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

568: WHERE person_id = c_person_id AND
569: course_cd = c_program_cd;
570: l_val_sca_confrm_status BOOLEAN;
571: l_val_sca_elgbl_status BOOLEAN;
572: l_message_name FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
573: l_message_name1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
574: l_dest_sca_rec c_get_dest_prg_dtls%ROWTYPE;
575:
576: BEGIN

Line 573: l_message_name1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

569: course_cd = c_program_cd;
570: l_val_sca_confrm_status BOOLEAN;
571: l_val_sca_elgbl_status BOOLEAN;
572: l_message_name FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
573: l_message_name1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
574: l_dest_sca_rec c_get_dest_prg_dtls%ROWTYPE;
575:
576: BEGIN
577:

Line 726: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

722: -- activity as a part of bug# 4083552
723:
724: -------------------------------------------------------------------------------------------
725: l_deny_warn VARCHAR2(100);
726: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
727: l_hold_status BOOLEAN;
728:
729: v_message_name varchar2(30);
730: v_message_name2 varchar2(30);

Line 1284: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1280: --------------------------------------------------------------------------------------------
1281:
1282: l_candidacy_tran_status BOOLEAN;
1283: l_res_elgbl_status BOOLEAN;
1284: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1285: l_elgbl_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1286:
1287: BEGIN
1288:

Line 1285: l_elgbl_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1281:
1282: l_candidacy_tran_status BOOLEAN;
1283: l_res_elgbl_status BOOLEAN;
1284: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1285: l_elgbl_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1286:
1287: BEGIN
1288:
1289: l_candidacy_tran_status := IGS_RE_VAL_CA.resp_val_ca_sca(p_person_id,

Line 1390: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1386: -- is a warning message and should be added to the stack only when p_show_warning is passed as 'Y'
1387: -------------------------------------------------------------------------------------------
1388:
1389: l_val VARCHAR2(1);
1390: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1391:
1392: CURSOR c_is_adv_st_exists(c_person_id IGS_AV_ADV_STANDING.PERSON_ID%TYPE,
1393: c_source_program_cd IGS_AV_ADV_STANDING.COURSE_CD%TYPE,
1394: c_source_prog_ver IGS_AV_ADV_STANDING.VERSION_NUMBER%TYPE )IS

Line 1581: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1577: l_coreind VARCHAR2(30);
1578: l_uooid NUMBER;
1579: l_uoo_ids_to_transfer VARCHAR2(3000);
1580: l_enrp_sua_trans_status BOOLEAN;
1581: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1582: l_unit_outcome IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1583: l_is_val_sua_trans BOOLEAN;
1584: l_temp VARCHAR2(1);
1585: l_unt_att_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;

Line 1592: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1588: l_sua_trans_status BOOLEAN;
1589: l_return_type VARCHAR2(200);
1590: l_sua_confrm_status BOOLEAN;
1591: l_fail_type VARCHAR2(100);
1592: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1593: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1594: l_return_message FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1595: l_del_sua_tran_status BOOLEAN;
1596: l_del_all_sua_status BOOLEAN;

Line 1593: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1589: l_return_type VARCHAR2(200);
1590: l_sua_confrm_status BOOLEAN;
1591: l_fail_type VARCHAR2(100);
1592: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1593: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1594: l_return_message FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1595: l_del_sua_tran_status BOOLEAN;
1596: l_del_all_sua_status BOOLEAN;
1597: l_teach_cal_desc IGS_CA_INST.description%TYPE;

Line 1594: l_return_message FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1590: l_sua_confrm_status BOOLEAN;
1591: l_fail_type VARCHAR2(100);
1592: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1593: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1594: l_return_message FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1595: l_del_sua_tran_status BOOLEAN;
1596: l_del_all_sua_status BOOLEAN;
1597: l_teach_cal_desc IGS_CA_INST.description%TYPE;
1598: l_uooids_str VARCHAR2(1000);

Line 1599: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1595: l_del_sua_tran_status BOOLEAN;
1596: l_del_all_sua_status BOOLEAN;
1597: l_teach_cal_desc IGS_CA_INST.description%TYPE;
1598: l_uooids_str VARCHAR2(1000);
1599: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1600: l_error_occured BOOLEAN;
1601:
1602:
1603: CURSOR c_get_unit_dtls(c_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) Is

Line 2388: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

2384: l_unitset_append_count NUMBER;
2385:
2386: l_unitset_att_exists BOOLEAN;
2387: l_val_susa_status BOOLEAN;
2388: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2389: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2390: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2391: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2392: l_message_name4 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

Line 2389: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

2385:
2386: l_unitset_att_exists BOOLEAN;
2387: l_val_susa_status BOOLEAN;
2388: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2389: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2390: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2391: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2392: l_message_name4 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2393: l_message_text VARCHAR2(1000);

Line 2390: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

2386: l_unitset_att_exists BOOLEAN;
2387: l_val_susa_status BOOLEAN;
2388: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2389: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2390: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2391: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2392: l_message_name4 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2393: l_message_text VARCHAR2(1000);
2394: l_val_susa_tran BOOLEAN;

Line 2391: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

2387: l_val_susa_status BOOLEAN;
2388: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2389: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2390: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2391: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2392: l_message_name4 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2393: l_message_text VARCHAR2(1000);
2394: l_val_susa_tran BOOLEAN;
2395: l_susa_cousr_status BOOLEAN;

Line 2392: l_message_name4 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

2388: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2389: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2390: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2391: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2392: l_message_name4 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2393: l_message_text VARCHAR2(1000);
2394: l_val_susa_tran BOOLEAN;
2395: l_susa_cousr_status BOOLEAN;
2396: l_status BOOLEAN;

Line 2780: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

2776: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2777: l_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2778: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
2779: l_status BOOLEAN;
2780: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2781: CURSOR c_course_type IS
2782: SELECT course_type
2783: FROM IGS_PS_VER
2784: WHERE COURSE_CD = p_source_program_cd

Line 3058: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

3054: l_tran_across_careers BOOLEAN;
3055: l_drop BOOLEAN;
3056: l_sct_tran_status BOOLEAN;
3057: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;
3058: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3059: l_debt_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3060: l_hold_status BOOLEAN;
3061:
3062: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;

Line 3059: l_debt_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

3055: l_drop BOOLEAN;
3056: l_sct_tran_status BOOLEAN;
3057: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;
3058: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3059: l_debt_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3060: l_hold_status BOOLEAN;
3061:
3062: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
3063: l_src_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;

Line 3645: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

3641: l_msg_count NUMBER(4);
3642: l_msg_data VARCHAR2(4000);
3643: l_enc_msg VARCHAR2(2000);
3644: l_msg_index NUMBER(4);
3645: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
3646: l_warn_and_err_msg VARCHAR2(5000);
3647:
3648: BEGIN
3649: