[Home] [Help]
231: IF (fnd_profile.value('IGS_RECRUITING_ENABLED') IS NULL OR fnd_profile.value('IGS_RECRUITING_ENABLED') = 'N') THEN
232:
233: IF igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INSTANCE') = TRUE THEN
234: --Log error "Inquiry Instance related information is not Processed as Oracle Student Recruiting functionality is not enabled for the user".
235: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET_STRING('IGS','IGS_AD_INQ_NOT_PRCSD'));
236: ELSE
237: OPEN c_system_source_type;
238: FETCH c_system_source_type INTO l_system_source_type;
239: CLOSE c_system_source_type;
239: CLOSE c_system_source_type;
240:
241: IF l_system_source_type = 'PROSPECT_SS_WEB_INQUIRY' OR l_system_source_type IS NULL THEN
242: --Log error "Inquiry Instance related information is not Processed as Oracle Student Recruiting functionality is not enabled for the user".
243: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET_STRING('IGS','IGS_AD_INQ_NOT_PRCSD'));
244: END IF;
245:
246: END IF;
247: ELSIF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
252: END; ';
253: EXECUTE IMMEDIATE l_stmt USING p_source_type_id, p_interface_run_id, p_enable_log, l_schema;
254: EXCEPTION
255: WHEN OTHERS THEN
256: fnd_file.put_line(fnd_file.log,'Error occurred while calling IGR_IMP_002.PRC_AD_CATEGORY() : '||SQLERRM);
257: END;
258:
259: END IF;
260:
1143: END; ';
1144: EXECUTE IMMEDIATE l_stmt USING p_source_type_id,p_interface_run_id;
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: fnd_file.put_line(fnd_file.log,'Error occurred while calling IGR_IMP_002.DEL_CMPLD_RCT_RECORDS() : '||SQLERRM);
1148: END;
1149: END IF;
1150:
1151: IF g_person_recruit_dtls_inc THEN