DBA Data[Home] [Help]

APPS.HR_MULTI_TENANT_INSTALLER dependencies on FND_FILE

Line 178: fnd_file.put_line(fnd_file.output

174:
175: IF fnd_profile.value('HR_ENABLE_MULTI_TENANCY') IS NULL
176: OR fnd_profile.value('HR_ENABLE_MULTI_TENANCY') = 'N' THEN
177:
178: fnd_file.put_line(fnd_file.output
179: ,'Set HR Enable Multi Tenancy System profile and submit the request');
180:
181: fnd_file.put_line(fnd_file.log
182: ,'Set HR Enable Multi Tenancy System profile and submit the request');

Line 181: fnd_file.put_line(fnd_file.log

177:
178: fnd_file.put_line(fnd_file.output
179: ,'Set HR Enable Multi Tenancy System profile and submit the request');
180:
181: fnd_file.put_line(fnd_file.log
182: ,'Set HR Enable Multi Tenancy System profile and submit the request');
183:
184: RETURN;
185: END IF;

Line 1830: add_body_line(' fnd_file.put_line (fnd_file.log');

1826: add_body_line(' ,l_security_group_id');
1827: add_body_line(' ,''C::'' || p_security_label;');
1828: add_body_line('EXCEPTION');
1829: add_body_line(' WHEN OTHERS THEN');
1830: add_body_line(' fnd_file.put_line (fnd_file.log');
1831: add_body_line(' ,''Cannot map Security Group for this enterprise '');');
1832: add_body_line('END;');
1833: add_body_line(' ELSE');
1834: add_body_line(' fnd_file.put_line (fnd_file.log');

Line 1834: add_body_line(' fnd_file.put_line (fnd_file.log');

1830: add_body_line(' fnd_file.put_line (fnd_file.log');
1831: add_body_line(' ,''Cannot map Security Group for this enterprise '');');
1832: add_body_line('END;');
1833: add_body_line(' ELSE');
1834: add_body_line(' fnd_file.put_line (fnd_file.log');
1835: add_body_line(' ,''Security Group Not enabled: '');');
1836: add_body_line(' ');
1837: add_body_line(' END IF;');
1838: add_body_line('END create_sec_group_for_ent;');

Line 1928: add_body_line(' fnd_file.put_line (fnd_file.log');

1924: add_body_line(' WHERE enterprise_id = p_enterprise_id;');
1925: add_body_line('');
1926: add_body_line(' l_enterprise_name := substr(l_company_label, 1, 30);');
1927: add_body_line('');
1928: add_body_line(' fnd_file.put_line (fnd_file.log');
1929: add_body_line(' ,''Creating Security Group : '' || l_enterprise_name);');
1930: add_body_line(' fnd_file.put_line (fnd_file.output');
1931: add_body_line(' ,''Creating Security Group : '' || l_enterprise_name);');
1932: add_body_line('');

Line 1930: add_body_line(' fnd_file.put_line (fnd_file.output');

1926: add_body_line(' l_enterprise_name := substr(l_company_label, 1, 30);');
1927: add_body_line('');
1928: add_body_line(' fnd_file.put_line (fnd_file.log');
1929: add_body_line(' ,''Creating Security Group : '' || l_enterprise_name);');
1930: add_body_line(' fnd_file.put_line (fnd_file.output');
1931: add_body_line(' ,''Creating Security Group : '' || l_enterprise_name);');
1932: add_body_line('');
1933: add_body_line('--');
1934: add_body_line('-- In Model 2 (PEO) create a security group for this enterprise.');

Line 1944: add_body_line(' fnd_file.put_line(fnd_file.log');

1940: add_body_line('');
1941: add_body_line(' l_enterprise_name := ''C::'' || l_enterprise_name;');
1942: add_body_line('');
1943: add_body_line(' IF NOT l_is_business_group THEN');
1944: add_body_line(' fnd_file.put_line(fnd_file.log');
1945: add_body_line(' ,''Initializing Control :Person Sequence'');');
1946: add_body_line(' ');
1947: add_body_line('--');
1948: add_body_line('-- In model 2 make seperate entries in the PER_NUMBER_GENERATION_CONTROLS');

Line 1992: add_body_line(' fnd_file.put_line (fnd_file.log');

1988: add_body_line(' ,:2))''');
1989: add_body_line(' USING l_business_group_id');
1990: add_body_line(' ,l_enterprise_name;');
1991: add_body_line('');
1992: add_body_line(' fnd_file.put_line (fnd_file.log');
1993: add_body_line(' ,''Completed Control: Person Sequence'');');
1994: add_body_line(' ELSE');
1995: add_body_line(' init_master_tables(1) := ''PER_PERSON_TYPES'';');
1996: add_body_line(' init_master_tables(2) := ''PER_NUMBER_GENERATION_CONTROLS'';');

Line 2018: add_body_line(' fnd_file.put_line(fnd_file.log');

2014: add_body_line(' USING l_enterprise_name');
2015: add_body_line(' ,l_business_group_id;');
2016: add_body_line(' EXCEPTION');
2017: add_body_line(' WHEN OTHERS THEN');
2018: add_body_line(' fnd_file.put_line(fnd_file.log');
2019: add_body_line(' ,''Error in updating:''||init_table_name);');
2020: add_body_line(' END;');
2021: add_body_line(' END LOOP;');
2022: add_body_line('');

Line 2065: add_body_line(' fnd_file.put_line(fnd_file.log');

2061: add_body_line(' USING l_enterprise_name');
2062: add_body_line(' ,l_business_group_id;');
2063: add_body_line(' EXCEPTION ');
2064: add_body_line(' WHEN OTHERS THEN');
2065: add_body_line(' fnd_file.put_line(fnd_file.log');
2066: add_body_line(' ,''Error in updating:''||init_child_tables(t_index).table_name);');
2067: add_body_line(' END;');
2068: add_body_line(' END LOOP;');
2069: add_body_line('');

Line 2071: add_body_line(' fnd_file.put_line(fnd_file.log');

2067: add_body_line(' END;');
2068: add_body_line(' END LOOP;');
2069: add_body_line('');
2070: add_body_line(' END IF;');
2071: add_body_line(' fnd_file.put_line(fnd_file.log');
2072: add_body_line(' ,''Initializing Control: Enterprise Context'');');
2073: add_body_line('--');
2074: add_body_line('-- In model 1 update entries in the hr_all_organization_units for this enterprise');
2075: add_body_line('--');

Line 2107: add_body_line(' fnd_file.put_line(fnd_file.log');

2103: add_body_line(' USING l_enterprise_name');
2104: add_body_line(' ,p_organization_id;');
2105: add_body_line('END IF;');
2106: add_body_line('');
2107: add_body_line(' fnd_file.put_line(fnd_file.log');
2108: add_body_line(' ,''Completed Control: Enterprise Context'');');
2109: add_body_line('');
2110: add_body_line(' EXCEPTION');
2111: add_body_line(' WHEN others THEN');

Line 2112: add_body_line(' fnd_file.put_line(fnd_file.output');

2108: add_body_line(' ,''Completed Control: Enterprise Context'');');
2109: add_body_line('');
2110: add_body_line(' EXCEPTION');
2111: add_body_line(' WHEN others THEN');
2112: add_body_line(' fnd_file.put_line(fnd_file.output');
2113: add_body_line(' ,''Errored OUT :'' || sqlerrm);');
2114: add_body_line(' fnd_file.put_line(fnd_file.log');
2115: add_body_line(' ,''Errored OUT : '' || sqlerrm);');
2116: add_body_line('');

Line 2114: add_body_line(' fnd_file.put_line(fnd_file.log');

2110: add_body_line(' EXCEPTION');
2111: add_body_line(' WHEN others THEN');
2112: add_body_line(' fnd_file.put_line(fnd_file.output');
2113: add_body_line(' ,''Errored OUT :'' || sqlerrm);');
2114: add_body_line(' fnd_file.put_line(fnd_file.log');
2115: add_body_line(' ,''Errored OUT : '' || sqlerrm);');
2116: add_body_line('');
2117: add_body_line(' END;');
2118: add_body_line(' ELSE');

Line 2119: add_body_line(' fnd_file.put_line(fnd_file.output');

2115: add_body_line(' ,''Errored OUT : '' || sqlerrm);');
2116: add_body_line('');
2117: add_body_line(' END;');
2118: add_body_line(' ELSE');
2119: add_body_line(' fnd_file.put_line(fnd_file.output');
2120: add_body_line(' ,''No organization selected :'');');
2121: add_body_line(' fnd_file.put_line(fnd_file.log');
2122: add_body_line(' ,''No organization selected : '');');
2123: add_body_line('');

Line 2121: add_body_line(' fnd_file.put_line(fnd_file.log');

2117: add_body_line(' END;');
2118: add_body_line(' ELSE');
2119: add_body_line(' fnd_file.put_line(fnd_file.output');
2120: add_body_line(' ,''No organization selected :'');');
2121: add_body_line(' fnd_file.put_line(fnd_file.log');
2122: add_body_line(' ,''No organization selected : '');');
2123: add_body_line('');
2124: add_body_line(' END IF;');
2125: add_body_line(' fnd_file.put_line(fnd_file.log');

Line 2125: add_body_line(' fnd_file.put_line(fnd_file.log');

2121: add_body_line(' fnd_file.put_line(fnd_file.log');
2122: add_body_line(' ,''No organization selected : '');');
2123: add_body_line('');
2124: add_body_line(' END IF;');
2125: add_body_line(' fnd_file.put_line(fnd_file.log');
2126: add_body_line(' ,''Completed Organization Initialization'');');
2127: add_body_line(' fnd_file.put_line(fnd_file.output');
2128: add_body_line(' ,''Completed Organization Initialization'');');
2129: add_body_line('END initialize_orgs;');

Line 2127: add_body_line(' fnd_file.put_line(fnd_file.output');

2123: add_body_line('');
2124: add_body_line(' END IF;');
2125: add_body_line(' fnd_file.put_line(fnd_file.log');
2126: add_body_line(' ,''Completed Organization Initialization'');');
2127: add_body_line(' fnd_file.put_line(fnd_file.output');
2128: add_body_line(' ,''Completed Organization Initialization'');');
2129: add_body_line('END initialize_orgs;');
2130: add_body_line('--');
2131: add_body_line('--------------------------------------------------------------------');

Line 2213: add_body_line(' fnd_file.put_line(fnd_file.log, ''The policy is already applied on the schema '' || l_hr_name);');

2209: add_body_line(' ,schema_name => l_hr_name');
2210: add_body_line(' ,default_options => ''READ_CONTROL, LABEL_DEFAULT, HIDE'');');
2211: add_body_line(' EXCEPTION');
2212: add_body_line(' WHEN OTHERS THEN');
2213: add_body_line(' fnd_file.put_line(fnd_file.log, ''The policy is already applied on the schema '' || l_hr_name);');
2214: add_body_line(' END;');
2215: add_body_line('');
2216: add_body_line(' BEGIN');
2217: add_body_line(' sa_policy_admin.apply_schema_policy(');

Line 2223: add_body_line(' fnd_file.put_line(fnd_file.log, ''The policy is already applied on the schema '' || l_ota_name);');

2219: add_body_line(' ,schema_name => l_ota_name');
2220: add_body_line(' ,default_options => ''READ_CONTROL, LABEL_DEFAULT, HIDE'');');
2221: add_body_line(' EXCEPTION');
2222: add_body_line(' WHEN OTHERS THEN');
2223: add_body_line(' fnd_file.put_line(fnd_file.log, ''The policy is already applied on the schema '' || l_ota_name);');
2224: add_body_line(' END;');
2225: add_body_line('');
2226: add_body_line(' BEGIN');
2227: add_body_line(' sa_policy_admin.apply_schema_policy(');

Line 2233: add_body_line(' fnd_file.put_line(fnd_file.log, ''The policy is already applied on the schema '' || l_ben_name);');

2229: add_body_line(' ,schema_name => l_ben_name');
2230: add_body_line(' ,default_options => ''READ_CONTROL, LABEL_DEFAULT, HIDE'');');
2231: add_body_line(' EXCEPTION');
2232: add_body_line(' WHEN OTHERS THEN');
2233: add_body_line(' fnd_file.put_line(fnd_file.log, ''The policy is already applied on the schema '' || l_ben_name);');
2234: add_body_line(' END;');
2235: add_body_line(' elsif install_mode = ''USERTABLE'' then');
2236: add_body_line(' SELECT count(*) ');
2237: add_body_line(' into l_table_count');

Line 2244: add_body_line(' fnd_file.put_line(fnd_file.log, ''Total Tables : '' || l_table_count);');

2240: add_body_line(' FROM pay_user_tables');
2241: add_body_line(' WHERE user_table_name = ''HR_OLS_TABLE_LIST'');');
2242: add_body_line(' end if;');
2243: add_body_line('');
2244: add_body_line(' fnd_file.put_line(fnd_file.log, ''Total Tables : '' || l_table_count);');
2245: add_body_line('');
2246: add_body_line(' l_range := 0;');
2247: add_body_line(' loop');
2248: add_body_line('--');

Line 2255: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitting for range : '' || ');

2251: add_body_line(' if l_range + population_size > l_table_count then');
2252: add_body_line(' l_start := l_range + 1;');
2253: add_body_line(' l_end := l_table_count;');
2254: add_body_line('');
2255: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitting for range : '' || ');
2256: add_body_line(' to_char(l_start) || '' to '' || to_char(l_end));');
2257: add_body_line('');
2258: add_body_line(' l_child_req_id := fnd_request.submit_request');
2259: add_body_line(' (application => ''PER''');

Line 2270: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');

2266: add_body_line('');
2267: add_body_line(' commit;');
2268: add_body_line('');
2269: add_body_line(' if l_child_req_id = 0 then');
2270: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');
2271: add_body_line(' else ');
2272: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');
2273: add_body_line(' end if;');
2274: add_body_line('');

Line 2272: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');

2268: add_body_line('');
2269: add_body_line(' if l_child_req_id = 0 then');
2270: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');
2271: add_body_line(' else ');
2272: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');
2273: add_body_line(' end if;');
2274: add_body_line('');
2275: add_body_line(' exit;');
2276: add_body_line(' else');

Line 2280: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitting for range : '' || ');

2276: add_body_line(' else');
2277: add_body_line(' l_start := l_range + 1;');
2278: add_body_line(' l_end := l_range + population_size;');
2279: add_body_line('');
2280: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitting for range : '' || ');
2281: add_body_line(' to_char(l_start) || '' to '' || to_char(l_end));');
2282: add_body_line('');
2283: add_body_line(' l_child_req_id := fnd_request.submit_request');
2284: add_body_line(' (application => ''PER''');

Line 2295: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');

2291: add_body_line('');
2292: add_body_line(' commit;');
2293: add_body_line('');
2294: add_body_line(' if l_child_req_id = 0 then');
2295: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');
2296: add_body_line(' else ');
2297: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');
2298: add_body_line(' end if;');
2299: add_body_line('');

Line 2297: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');

2293: add_body_line('');
2294: add_body_line(' if l_child_req_id = 0 then');
2295: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');
2296: add_body_line(' else ');
2297: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');
2298: add_body_line(' end if;');
2299: add_body_line('');
2300: add_body_line(' end if;');
2301: add_body_line('');

Line 2312: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children completed successfully'');');

2308: add_body_line(' ,Interval => 20');
2309: add_body_line(' ,Max_Wait => 3600);');
2310: add_body_line('');
2311: add_body_line(' if l_child_request_status then');
2312: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children completed successfully'');');
2313: add_body_line(' else');
2314: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children failed.'');');
2315: add_body_line(' end if;');
2316: add_body_line('');

Line 2314: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children failed.'');');

2310: add_body_line('');
2311: add_body_line(' if l_child_request_status then');
2312: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children completed successfully'');');
2313: add_body_line(' else');
2314: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children failed.'');');
2315: add_body_line(' end if;');
2316: add_body_line('');
2317: add_body_line(' end master_process;');
2318: add_body_line('');

Line 2337: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 1'' ||table_name );');

2333: add_body_line(' begin');
2334: add_body_line(' EXECUTE IMMEDIATE sqlStatement1;');
2335: add_body_line(' exception ');
2336: add_body_line(' when others then');
2337: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 1'' ||table_name );');
2338: add_body_line(' end; ');
2339: add_body_line(' begin');
2340: add_body_line(' EXECUTE IMMEDIATE sqlStatement2;');
2341: add_body_line(' exception ');

Line 2343: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 2'' ||table_name );');

2339: add_body_line(' begin');
2340: add_body_line(' EXECUTE IMMEDIATE sqlStatement2;');
2341: add_body_line(' exception ');
2342: add_body_line(' when others then');
2343: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 2'' ||table_name );');
2344: add_body_line(' end; ');
2345: add_body_line(' begin');
2346: add_body_line(' EXECUTE IMMEDIATE sqlStatement3;');
2347: add_body_line(' exception ');

Line 2349: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 3'' ||table_name );');

2345: add_body_line(' begin');
2346: add_body_line(' EXECUTE IMMEDIATE sqlStatement3;');
2347: add_body_line(' exception ');
2348: add_body_line(' when others then');
2349: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 3'' ||table_name );');
2350: add_body_line(' end; ');
2351: add_body_line('');
2352: add_body_line('end execute_statement;');
2353: add_body_line('--');

Line 2984: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table '' || l_schema_name || ''.'' || l_table_name);');

2980: add_body_line(' for i in 1 .. all_hr_tables.count loop');
2981: add_body_line(' l_table_name := all_hr_tables(i);');
2982: add_body_line(' l_schema_name := all_hr_table_owners(i);');
2983: add_body_line(' ');
2984: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table '' || l_schema_name || ''.'' || l_table_name);');
2985: add_body_line(' l_np_tab := false;');
2986: add_body_line(' l_upd_tab := false;');
2987: add_body_line(' l_upd_policy := false;');
2988: add_body_line('');

Line 3000: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table is in the no policy table list.'');');

2996: add_body_line(' end if;');
2997: add_body_line(' end loop;');
2998: add_body_line('');
2999: add_body_line(' if l_np_tab then');
3000: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table is in the no policy table list.'');');
3001: add_body_line(' sa_policy_admin.remove_table_policy');
3002: add_body_line(' (policy_name => ''HR_ENTERPRISE_POLICY''');
3003: add_body_line(' ,schema_name => l_schema_name');
3004: add_body_line(' ,table_name => l_table_name');

Line 3010: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table is in the seed data table list.'');');

3006: add_body_line(' else');
3007: add_body_line(' l_table_options := ''READ_CONTROL, LABEL_DEFAULT, HIDE'';');
3008: add_body_line(' for m in 1..seeddata_table.count loop');
3009: add_body_line(' if l_table_name = seeddata_table(m) then');
3010: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table is in the seed data table list.'');');
3011: add_body_line(' l_table_options := ''READ_CONTROL, UPDATE_CONTROL, DELETE_CONTROL, LABEL_DEFAULT, HIDE'';');
3012: add_body_line(' l_upd_policy := true;');
3013: add_body_line(' exit;');
3014: add_body_line(' end if;');

Line 3020: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table is in the predicate table list.'');');

3016: add_body_line('');
3017: add_body_line(' l_predicate := null;');
3018: add_body_line(' for k in 1..predicate_table.count loop ');
3019: add_body_line(' if l_table_name = predicate_table(k) then');
3020: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table is in the predicate table list.'');');
3021: add_body_line(' l_predicate := ''AND HR_ENTERPRISE = '' ||');
3022: add_body_line(' ''char_to_label(''''HR_ENTERPRISE_POLICY'''', SA_SESSION.ROW_LABEL(''''HR_ENTERPRISE_POLICY''''))'';');
3023: add_body_line(' l_upd_tab := true;');
3024: add_body_line(' l_upd_policy := true;');

Line 3264: add_body_line(' fnd_file.put_line(fnd_file.log,''Exception caught on: '' || fnd_global.conc_request_id);');

3260: add_body_line(' END LOOP;');
3261: add_body_line(' end if;');
3262: add_body_line(' exception');
3263: add_body_line(' when others then');
3264: add_body_line(' fnd_file.put_line(fnd_file.log,''Exception caught on: '' || fnd_global.conc_request_id);');
3265: add_body_line(' fnd_file.put_line(fnd_file.log,''l_table_name: '' || l_table_name); ');
3266: add_body_line(' fnd_file.put_line(fnd_file.log,''sqerrmessage: '' || sqlerrm);');
3267: add_body_line(' end child_process;');
3268: add_body_line('');

Line 3265: add_body_line(' fnd_file.put_line(fnd_file.log,''l_table_name: '' || l_table_name); ');

3261: add_body_line(' end if;');
3262: add_body_line(' exception');
3263: add_body_line(' when others then');
3264: add_body_line(' fnd_file.put_line(fnd_file.log,''Exception caught on: '' || fnd_global.conc_request_id);');
3265: add_body_line(' fnd_file.put_line(fnd_file.log,''l_table_name: '' || l_table_name); ');
3266: add_body_line(' fnd_file.put_line(fnd_file.log,''sqerrmessage: '' || sqlerrm);');
3267: add_body_line(' end child_process;');
3268: add_body_line('');
3269: add_body_line('');

Line 3266: add_body_line(' fnd_file.put_line(fnd_file.log,''sqerrmessage: '' || sqlerrm);');

3262: add_body_line(' exception');
3263: add_body_line(' when others then');
3264: add_body_line(' fnd_file.put_line(fnd_file.log,''Exception caught on: '' || fnd_global.conc_request_id);');
3265: add_body_line(' fnd_file.put_line(fnd_file.log,''l_table_name: '' || l_table_name); ');
3266: add_body_line(' fnd_file.put_line(fnd_file.log,''sqerrmessage: '' || sqlerrm);');
3267: add_body_line(' end child_process;');
3268: add_body_line('');
3269: add_body_line('');
3270: add_body_line('END '||l_package_name ||';');

Line 3285: fnd_file.put_line(fnd_file.output,'Error occured in installation of HR Multi tenancy '|| sqlerrm);

3281: dbms_sql.close_cursor( l_csr_sql );
3282:
3283: EXCEPTION
3284: WHEN OTHERS THEN
3285: fnd_file.put_line(fnd_file.output,'Error occured in installation of HR Multi tenancy '|| sqlerrm);
3286: END install_hr_multi_tenant;
3287: END hr_multi_tenant_installer;