eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1618: add_body_line(' fnd_file.put_line (fnd_file.log');

1614: add_body_line(' ,l_security_group_id');
1615: add_body_line(' ,''Y'');');
1616: add_body_line('EXCEPTION');
1617: add_body_line(' WHEN OTHERS THEN');
1618: add_body_line(' fnd_file.put_line (fnd_file.log');
1619: add_body_line(' ,''Cannot map Security Group for this enterprise '');');
1620: add_body_line('END;');
1621: add_body_line(' ELSE');
1622: add_body_line(' fnd_file.put_line (fnd_file.log');

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

1618: add_body_line(' fnd_file.put_line (fnd_file.log');
1619: add_body_line(' ,''Cannot map Security Group for this enterprise '');');
1620: add_body_line('END;');
1621: add_body_line(' ELSE');
1622: add_body_line(' fnd_file.put_line (fnd_file.log');
1623: add_body_line(' ,''Security Group Not enabled: '');');
1624: add_body_line(' ');
1625: add_body_line(' END IF;');
1626: add_body_line('END create_sec_group_for_ent;');

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

1712: add_body_line(' WHERE enterprise_id = p_enterprise_id;');
1713: add_body_line('');
1714: add_body_line(' l_enterprise_name := substr(l_company_label, 1, 30);');
1715: add_body_line('');
1716: add_body_line(' fnd_file.put_line (fnd_file.log');
1717: add_body_line(' ,''Creating Security Group : '' || l_enterprise_name);');
1718: add_body_line(' fnd_file.put_line (fnd_file.output');
1719: add_body_line(' ,''Creating Security Group : '' || l_enterprise_name);');
1720: add_body_line('');

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

1714: add_body_line(' l_enterprise_name := substr(l_company_label, 1, 30);');
1715: add_body_line('');
1716: add_body_line(' fnd_file.put_line (fnd_file.log');
1717: add_body_line(' ,''Creating Security Group : '' || l_enterprise_name);');
1718: add_body_line(' fnd_file.put_line (fnd_file.output');
1719: add_body_line(' ,''Creating Security Group : '' || l_enterprise_name);');
1720: add_body_line('');
1721: add_body_line('--');
1722: add_body_line('-- In Model 2 (PEO) create a security group for this enterprise.');

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

1728: add_body_line('');
1729: add_body_line(' l_enterprise_name := ''C::'' || l_enterprise_name;');
1730: add_body_line('');
1731: add_body_line(' IF NOT l_is_business_group THEN');
1732: add_body_line(' fnd_file.put_line(fnd_file.log');
1733: add_body_line(' ,''Initializing Control :Person Sequence'');');
1734: add_body_line(' ');
1735: add_body_line('--');
1736: add_body_line('-- In model 2 make seperate entries in the PER_NUMBER_GENERATION_CONTROLS');

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

1776: add_body_line(' ,:2))''');
1777: add_body_line(' USING l_business_group_id');
1778: add_body_line(' ,l_enterprise_name;');
1779: add_body_line('');
1780: add_body_line(' fnd_file.put_line (fnd_file.log');
1781: add_body_line(' ,''Completed Control: Person Sequence'');');
1782: add_body_line(' ELSE');
1783: add_body_line(' init_master_tables(1) := ''PER_PERSON_TYPES'';');
1784: add_body_line(' init_master_tables(2) := ''PER_NUMBER_GENERATION_CONTROLS'';');

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

1802: add_body_line(' USING l_enterprise_name');
1803: add_body_line(' ,l_business_group_id;');
1804: add_body_line(' EXCEPTION');
1805: add_body_line(' WHEN OTHERS THEN');
1806: add_body_line(' fnd_file.put_line(fnd_file.log');
1807: add_body_line(' ,''Error in updating:''||init_table_name);');
1808: add_body_line(' END;');
1809: add_body_line(' END LOOP;');
1810: add_body_line('');

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

1849: add_body_line(' USING l_enterprise_name');
1850: add_body_line(' ,l_business_group_id;');
1851: add_body_line(' EXCEPTION ');
1852: add_body_line(' WHEN OTHERS THEN');
1853: add_body_line(' fnd_file.put_line(fnd_file.log');
1854: add_body_line(' ,''Error in updating:''||init_child_tables(t_index).table_name);');
1855: add_body_line(' END;');
1856: add_body_line(' END LOOP;');
1857: add_body_line('');

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

1855: add_body_line(' END;');
1856: add_body_line(' END LOOP;');
1857: add_body_line('');
1858: add_body_line(' END IF;');
1859: add_body_line(' fnd_file.put_line(fnd_file.log');
1860: add_body_line(' ,''Initializing Control: Enterprise Context'');');
1861: add_body_line('--');
1862: add_body_line('-- In model 1 update entries in the hr_all_organization_units for this enterprise');
1863: add_body_line('--');

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

1891: add_body_line(' USING l_enterprise_name');
1892: add_body_line(' ,p_organization_id;');
1893: add_body_line('END IF;');
1894: add_body_line('');
1895: add_body_line(' fnd_file.put_line(fnd_file.log');
1896: add_body_line(' ,''Completed Control: Enterprise Context'');');
1897: add_body_line('');
1898: add_body_line(' EXCEPTION');
1899: add_body_line(' WHEN others THEN');

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

1896: add_body_line(' ,''Completed Control: Enterprise Context'');');
1897: add_body_line('');
1898: add_body_line(' EXCEPTION');
1899: add_body_line(' WHEN others THEN');
1900: add_body_line(' fnd_file.put_line(fnd_file.output');
1901: add_body_line(' ,''Errored OUT :'' || sqlerrm);');
1902: add_body_line(' fnd_file.put_line(fnd_file.log');
1903: add_body_line(' ,''Errored OUT : '' || sqlerrm);');
1904: add_body_line('');

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

1898: add_body_line(' EXCEPTION');
1899: add_body_line(' WHEN others THEN');
1900: add_body_line(' fnd_file.put_line(fnd_file.output');
1901: add_body_line(' ,''Errored OUT :'' || sqlerrm);');
1902: add_body_line(' fnd_file.put_line(fnd_file.log');
1903: add_body_line(' ,''Errored OUT : '' || sqlerrm);');
1904: add_body_line('');
1905: add_body_line(' END;');
1906: add_body_line(' ELSE');

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

1903: add_body_line(' ,''Errored OUT : '' || sqlerrm);');
1904: add_body_line('');
1905: add_body_line(' END;');
1906: add_body_line(' ELSE');
1907: add_body_line(' fnd_file.put_line(fnd_file.output');
1908: add_body_line(' ,''No organization selected :'');');
1909: add_body_line(' fnd_file.put_line(fnd_file.log');
1910: add_body_line(' ,''No organization selected : '');');
1911: add_body_line('');

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

1905: add_body_line(' END;');
1906: add_body_line(' ELSE');
1907: add_body_line(' fnd_file.put_line(fnd_file.output');
1908: add_body_line(' ,''No organization selected :'');');
1909: add_body_line(' fnd_file.put_line(fnd_file.log');
1910: add_body_line(' ,''No organization selected : '');');
1911: add_body_line('');
1912: add_body_line(' END IF;');
1913: add_body_line(' fnd_file.put_line(fnd_file.log');

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

1909: add_body_line(' fnd_file.put_line(fnd_file.log');
1910: add_body_line(' ,''No organization selected : '');');
1911: add_body_line('');
1912: add_body_line(' END IF;');
1913: add_body_line(' fnd_file.put_line(fnd_file.log');
1914: add_body_line(' ,''Completed Organization Initialization'');');
1915: add_body_line(' fnd_file.put_line(fnd_file.output');
1916: add_body_line(' ,''Completed Organization Initialization'');');
1917: add_body_line('END initialize_orgs;');

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

1911: add_body_line('');
1912: add_body_line(' END IF;');
1913: add_body_line(' fnd_file.put_line(fnd_file.log');
1914: add_body_line(' ,''Completed Organization Initialization'');');
1915: add_body_line(' fnd_file.put_line(fnd_file.output');
1916: add_body_line(' ,''Completed Organization Initialization'');');
1917: add_body_line('END initialize_orgs;');
1918: add_body_line('--');
1919: add_body_line('--------------------------------------------------------------------');

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

1998: add_body_line(' FROM pay_user_tables');
1999: add_body_line(' WHERE user_table_name = ''HR_OLS_TABLE_LIST'');');
2000: add_body_line(' end if;');
2001: add_body_line('');
2002: add_body_line(' fnd_file.put_line(fnd_file.log, ''Total Tables : '' || l_table_count);');
2003: add_body_line('');
2004: add_body_line(' l_range := 0;');
2005: add_body_line(' loop');
2006: add_body_line('--');

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

2009: add_body_line(' if l_range + population_size > l_table_count then');
2010: add_body_line(' l_start := l_range + 1;');
2011: add_body_line(' l_end := l_table_count;');
2012: add_body_line('');
2013: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitting for range : '' || ');
2014: add_body_line(' to_char(l_start) || '' to '' || to_char(l_end));');
2015: add_body_line('');
2016: add_body_line(' l_child_req_id := fnd_request.submit_request');
2017: add_body_line(' (application => ''PER''');

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

2024: add_body_line('');
2025: add_body_line(' commit;');
2026: add_body_line('');
2027: add_body_line(' if l_child_req_id = 0 then');
2028: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');
2029: add_body_line(' else ');
2030: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');
2031: add_body_line(' end if;');
2032: add_body_line('');

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

2026: add_body_line('');
2027: add_body_line(' if l_child_req_id = 0 then');
2028: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');
2029: add_body_line(' else ');
2030: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');
2031: add_body_line(' end if;');
2032: add_body_line('');
2033: add_body_line(' exit;');
2034: add_body_line(' else');

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

2034: add_body_line(' else');
2035: add_body_line(' l_start := l_range + 1;');
2036: add_body_line(' l_end := l_range + population_size;');
2037: add_body_line('');
2038: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitting for range : '' || ');
2039: add_body_line(' to_char(l_start) || '' to '' || to_char(l_end));');
2040: add_body_line('');
2041: add_body_line(' l_child_req_id := fnd_request.submit_request');
2042: add_body_line(' (application => ''PER''');

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

2049: add_body_line('');
2050: add_body_line(' commit;');
2051: add_body_line('');
2052: add_body_line(' if l_child_req_id = 0 then');
2053: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');
2054: add_body_line(' else ');
2055: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');
2056: add_body_line(' end if;');
2057: add_body_line('');

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

2051: add_body_line('');
2052: add_body_line(' if l_child_req_id = 0 then');
2053: add_body_line(' fnd_file.put_line(fnd_file.log, ''Error in submitting child request'');');
2054: add_body_line(' else ');
2055: add_body_line(' fnd_file.put_line(fnd_file.log, ''Submitted child request: '' || l_child_req_id);');
2056: add_body_line(' end if;');
2057: add_body_line('');
2058: add_body_line(' end if;');
2059: add_body_line('');

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

2066: add_body_line(' ,Interval => 20');
2067: add_body_line(' ,Max_Wait => 3600);');
2068: add_body_line('');
2069: add_body_line(' if l_child_request_status then');
2070: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children completed successfully'');');
2071: add_body_line(' else');
2072: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children failed.'');');
2073: add_body_line(' end if;');
2074: add_body_line('');

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

2068: add_body_line('');
2069: add_body_line(' if l_child_request_status then');
2070: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children completed successfully'');');
2071: add_body_line(' else');
2072: add_body_line(' fnd_file.put_line(fnd_file.log, ''Children failed.'');');
2073: add_body_line(' end if;');
2074: add_body_line('');
2075: add_body_line(' end master_process;');
2076: add_body_line('');

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

2091: add_body_line(' begin');
2092: add_body_line(' EXECUTE IMMEDIATE sqlStatement1;');
2093: add_body_line(' exception ');
2094: add_body_line(' when others then');
2095: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 1'' ||table_name );');
2096: add_body_line(' end; ');
2097: add_body_line(' begin');
2098: add_body_line(' EXECUTE IMMEDIATE sqlStatement2;');
2099: add_body_line(' exception ');

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

2097: add_body_line(' begin');
2098: add_body_line(' EXECUTE IMMEDIATE sqlStatement2;');
2099: add_body_line(' exception ');
2100: add_body_line(' when others then');
2101: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 2'' ||table_name );');
2102: add_body_line(' end; ');
2103: add_body_line(' begin');
2104: add_body_line(' EXECUTE IMMEDIATE sqlStatement3;');
2105: add_body_line(' exception ');

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

2103: add_body_line(' begin');
2104: add_body_line(' EXECUTE IMMEDIATE sqlStatement3;');
2105: add_body_line(' exception ');
2106: add_body_line(' when others then');
2107: add_body_line(' fnd_file.put_line(fnd_file.log, ''Exception in 3'' ||table_name );');
2108: add_body_line(' end; ');
2109: add_body_line('');
2110: add_body_line('end execute_statement;');
2111: add_body_line('--');

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

2282: add_body_line(' for i in 1 .. all_hr_tables.count loop');
2283: add_body_line(' l_table_name := all_hr_tables(i);');
2284: add_body_line(' l_schema_name := all_hr_table_owners(i);');
2285: add_body_line(' ');
2286: add_body_line(' fnd_file.put_line(fnd_file.log, ''Current Table '' || l_schema_name || ''.'' || l_table_name);');
2287: add_body_line('--');
2288: add_body_line('-- Check if Policy is already applied on this table ');
2289: add_body_line('--');
2290: add_body_line(' begin');

Line 2319: add_body_line(' fnd_file.put_line(fnd_file.log, ''Enabling OLS for '' || l_schema_name || ''.'' || l_table_name);');

2315: add_body_line(' end if;');
2316: add_body_line(' end loop;');
2317: add_body_line('');
2318: add_body_line(' if not l_np_tab then');
2319: add_body_line(' fnd_file.put_line(fnd_file.log, ''Enabling OLS for '' || l_schema_name || ''.'' || l_table_name);');
2320: add_body_line('');
2321: add_body_line(' l_predicate :=''OR hr_enterprise IS NULL OR hr_enterprise = char_to_label(''''HR_ENTERPRISE_POLICY'''',''''C::ENT'''')'';');
2322: add_body_line(' --');
2323: add_body_line(' -- Apply to table now using default predicate');

Line 2334: add_body_line(' fnd_file.put_line(fnd_file.log, ''Special OLS for '' || l_schema_name || ''.'' || l_table_name);');

2330: add_body_line('');
2331: add_body_line(' -- Check if table requires special predicate');
2332: add_body_line(' for k in 1..predicate_table.count loop');
2333: add_body_line(' if l_table_name = predicate_table(k) then');
2334: add_body_line(' fnd_file.put_line(fnd_file.log, ''Special OLS for '' || l_schema_name || ''.'' || l_table_name);');
2335: add_body_line(' l_predicate := ''AND HR_ENTERPRISE = '' ||');
2336: add_body_line(' ''char_to_label(''''HR_ENTERPRISE_POLICY'''', SA_SESSION.ROW_LABEL(''''HR_ENTERPRISE_POLICY''''))''; ');
2337: add_body_line(' -- ');
2338: add_body_line(' -- Update null to C::ENT');

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

2575: add_body_line(' END LOOP;');
2576: add_body_line(' end if;');
2577: add_body_line(' exception');
2578: add_body_line(' when others then');
2579: add_body_line(' fnd_file.put_line(fnd_file.log,''Exception caught on: '' || fnd_global.conc_request_id);');
2580: add_body_line(' fnd_file.put_line(fnd_file.log,''l_table_name: '' || l_table_name); ');
2581: add_body_line(' fnd_file.put_line(fnd_file.log,''sqerrmessage: '' || sqlerrm);');
2582: add_body_line(' end child_process;');
2583: add_body_line('');

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

2576: add_body_line(' end if;');
2577: add_body_line(' exception');
2578: add_body_line(' when others then');
2579: add_body_line(' fnd_file.put_line(fnd_file.log,''Exception caught on: '' || fnd_global.conc_request_id);');
2580: add_body_line(' fnd_file.put_line(fnd_file.log,''l_table_name: '' || l_table_name); ');
2581: add_body_line(' fnd_file.put_line(fnd_file.log,''sqerrmessage: '' || sqlerrm);');
2582: add_body_line(' end child_process;');
2583: add_body_line('');
2584: add_body_line('');

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

2577: add_body_line(' exception');
2578: add_body_line(' when others then');
2579: add_body_line(' fnd_file.put_line(fnd_file.log,''Exception caught on: '' || fnd_global.conc_request_id);');
2580: add_body_line(' fnd_file.put_line(fnd_file.log,''l_table_name: '' || l_table_name); ');
2581: add_body_line(' fnd_file.put_line(fnd_file.log,''sqerrmessage: '' || sqlerrm);');
2582: add_body_line(' end child_process;');
2583: add_body_line('');
2584: add_body_line('');
2585: add_body_line('END '||l_package_name ||';');

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

2596: dbms_sql.close_cursor( l_csr_sql );
2597:
2598: EXCEPTION
2599: WHEN OTHERS THEN
2600: fnd_file.put_line(fnd_file.output,'Error occured in installation of HR Multi tenancy '|| sqlerrm);
2601: END install_hr_multi_tenant;
2602: END hr_multi_tenant_installer;