[Home] [Help]
681: -- If it's not an PRIMARY program in career mode then log message and stop processing
682: -- for the current unit by assigning l_abort_loop to TRUE and proceed for the unit for
683: -- the corresponding load cal type and sequence number.
684: -- added by ckasu as a part of bug # 4095479
685: IF NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND
686: igs_en_spa_terms_api.get_spat_primary_prg(l_person_id,
687: l_bulk_programs.program_cd,
688: l_bulk_load.cal_type,
689: l_bulk_load.seq_num) <> cst_primary THEN
846: FETCH c_sua_exists INTO l_sua_exists;
847: CLOSE c_sua_exists;
848: IF l_sua_exists='Y' THEN
849: IF l_bulk_suas.update_core_flag='Y' THEN
850: IF NVL(FND_PROFILE.VALUE('IGS_EN_CORE_VAL'),'N') = 'Y' THEN
851: --If profile is set then Derive core indicator from POS and log warning if it is being overriden
852: l_core_indicator_code:=Igs_En_Gen_009.enrp_check_usec_core (p_person_id =>l_person_id,
853: p_program_cd =>l_bulk_programs.program_cd,
854: p_uoo_id =>l_uoo_id);
970: END IF; --l_abort_loop
971:
972: IF l_abort_loop=FALSE THEN --Subtitile validation was passed or not applicable
973: --populate core indicator from POS if profile is set
974: IF NVL(FND_PROFILE.VALUE('IGS_EN_CORE_VAL'),'N') = 'Y' THEN
975: l_core_indicator_code:=Igs_En_Gen_009.enrp_check_usec_core (p_person_id =>l_person_id,
976: p_program_cd =>l_bulk_programs.program_cd,
977: p_uoo_id =>l_uoo_id);
978: END IF;
977: p_uoo_id =>l_uoo_id);
978: END IF;
979: --override from interface table if flag is set
980: IF l_bulk_suas.update_core_flag='Y' THEN
981: IF l_core_indicator_code <> l_bulk_suas.core_indicator_code AND NVL(FND_PROFILE.VALUE('IGS_EN_CORE_VAL'),'N') = 'Y' THEN
982: enrpl_unit_msg('W',l_bulk_suas.upload_id,'IGS_EN_POS_MATCH');
983: END IF;
984: l_core_indicator_code:=l_bulk_suas.core_indicator_code;
985: END IF;