164: raise e_deactivate;
165: end if;
166: v_industry_id := to_number(p_industry_id);
167: --Now set the profile to the new value for the desired industry
168: if fnd_profile.save('FND_INDUSTRY_ID', v_industry_id,'SITE') then
169: section_title(FND_FILE.LOG, 'Activating industry '||v_industry_id);
170: commit;
171: else
172: raise e_bad_profile;
215: il.language_code = lv.language and
216: lv.last_updated_by = 8;
217:
218: BEGIN
219: v_industry_id := to_number(fnd_profile.value('FND_INDUSTRY_ID'));
220: -- if the profile returns a null value then industries were never activated
221: if v_industry_id is NULL then
222:
223: return;
264: update fnd_lookup_values_il
265: set orig_meaning = null,
266: orig_description = null;
267: commit;
268: if fnd_profile.save('FND_INDUSTRY_ID', NULL,'SITE') then
269: errbuf := ('Industry deactivation complete.');
270: retcode := 0 ;
271: else
272: errbuf := ('Industry deactivation failed');