DBA Data[Home] [Help]

APPS.PQH_RBC_LOAD_OBJECTS dependencies on HR_UTILITY

Line 1734: hr_utility.set_location('Entering:'|| l_proc, 10);

1730: l_request_id number;
1731: l_validate varchar2(2000) ;
1732: begin
1733: --
1734: hr_utility.set_location('Entering:'|| l_proc, 10);
1735: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1736: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;

Line 1735: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;

1731: l_validate varchar2(2000) ;
1732: begin
1733: --
1734: hr_utility.set_location('Entering:'|| l_proc, 10);
1735: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1736: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1739: hr_utility.set_location('p_effective_date'||p_effective_date ,10) ;

Line 1736: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;

1732: begin
1733: --
1734: hr_utility.set_location('Entering:'|| l_proc, 10);
1735: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1736: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1739: hr_utility.set_location('p_effective_date'||p_effective_date ,10) ;
1740: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;

Line 1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;

1733: --
1734: hr_utility.set_location('Entering:'|| l_proc, 10);
1735: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1736: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1739: hr_utility.set_location('p_effective_date'||p_effective_date ,10) ;
1740: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
1741: hr_utility.set_location('p_validate '|| p_validate ,10) ;

Line 1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;

1734: hr_utility.set_location('Entering:'|| l_proc, 10);
1735: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1736: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1739: hr_utility.set_location('p_effective_date'||p_effective_date ,10) ;
1740: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
1741: hr_utility.set_location('p_validate '|| p_validate ,10) ;
1742: --

Line 1739: hr_utility.set_location('p_effective_date'||p_effective_date ,10) ;

1735: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1736: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1739: hr_utility.set_location('p_effective_date'||p_effective_date ,10) ;
1740: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
1741: hr_utility.set_location('p_validate '|| p_validate ,10) ;
1742: --
1743: --

Line 1740: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;

1736: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1739: hr_utility.set_location('p_effective_date'||p_effective_date ,10) ;
1740: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
1741: hr_utility.set_location('p_validate '|| p_validate ,10) ;
1742: --
1743: --
1744:

Line 1741: hr_utility.set_location('p_validate '|| p_validate ,10) ;

1737: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1738: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1739: hr_utility.set_location('p_effective_date'||p_effective_date ,10) ;
1740: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
1741: hr_utility.set_location('p_validate '|| p_validate ,10) ;
1742: --
1743: --
1744:
1745: savepoint SUBMIT_RBC_DOWNLOAD;

Line 1747: hr_utility.set_location(l_proc, 20);

1743: --
1744:
1745: savepoint SUBMIT_RBC_DOWNLOAD;
1746: --
1747: hr_utility.set_location(l_proc, 20);
1748:
1749: --
1750:
1751: If p_crit_rate_defn_code is not null then

Line 1763: hr_utility.set_location('Download ',20) ;

1759: l_effective_date := 'EFFECTIVE_DATE='|| p_effective_date ;
1760: l_business_group_name := 'BG_ID='|| to_char(p_business_group_id) ;
1761:
1762:
1763: hr_utility.set_location('Download ',20) ;
1764: l_request_id := fnd_request.submit_request
1765: (application => 'PQH'
1766: ,program => 'PQHRBCLD'
1767: ,description => NULL

Line 1780: hr_utility.set_location(' Request id:'||to_char(l_request_id), 70);

1776: ,argument8 => l_business_group_name
1777:
1778: );
1779: --
1780: hr_utility.set_location(' Request id:'||to_char(l_request_id), 70);
1781: hr_utility.set_location(' Leaving:'||l_proc, 70);
1782: --
1783: exception
1784: --

Line 1781: hr_utility.set_location(' Leaving:'||l_proc, 70);

1777:
1778: );
1779: --
1780: hr_utility.set_location(' Request id:'||to_char(l_request_id), 70);
1781: hr_utility.set_location(' Leaving:'||l_proc, 70);
1782: --
1783: exception
1784: --
1785: when others then

Line 1815: hr_utility.set_location('Entering:'|| l_proc, 10);

1811: l_request_id number;
1812: l_validate varchar2(2000) ;
1813: begin
1814: --
1815: hr_utility.set_location('Entering:'|| l_proc, 10);
1816: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1817: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1818: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1819: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;

Line 1816: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;

1812: l_validate varchar2(2000) ;
1813: begin
1814: --
1815: hr_utility.set_location('Entering:'|| l_proc, 10);
1816: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1817: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1818: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1819: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1820: hr_utility.set_location('p_validate '|| p_validate ,10) ;

Line 1817: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;

1813: begin
1814: --
1815: hr_utility.set_location('Entering:'|| l_proc, 10);
1816: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1817: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1818: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1819: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1820: hr_utility.set_location('p_validate '|| p_validate ,10) ;
1821: --

Line 1818: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;

1814: --
1815: hr_utility.set_location('Entering:'|| l_proc, 10);
1816: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1817: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1818: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1819: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1820: hr_utility.set_location('p_validate '|| p_validate ,10) ;
1821: --
1822: -- Setting g_data_migrator_mode = 'Y' , so that database triggers do not

Line 1819: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;

1815: hr_utility.set_location('Entering:'|| l_proc, 10);
1816: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1817: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1818: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1819: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1820: hr_utility.set_location('p_validate '|| p_validate ,10) ;
1821: --
1822: -- Setting g_data_migrator_mode = 'Y' , so that database triggers do not
1823: -- fire.

Line 1820: hr_utility.set_location('p_validate '|| p_validate ,10) ;

1816: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
1817: hr_utility.set_location('p_data_file '|| p_data_file ,10) ;
1818: hr_utility.set_location('p_crit_rate_defn_code '|| p_crit_rate_defn_code,10) ;
1819: hr_utility.set_location('p_rate_matrix_code'||p_rate_matrix_code ,10) ;
1820: hr_utility.set_location('p_validate '|| p_validate ,10) ;
1821: --
1822: -- Setting g_data_migrator_mode = 'Y' , so that database triggers do not
1823: -- fire.
1824: --

Line 1830: hr_utility.set_location(l_proc, 20);

1826: --hr_general.g_data_migrator_mode := 'Y';
1827: --
1828: savepoint SUBMIT_RBC_UPLOAD;
1829: --
1830: hr_utility.set_location(l_proc, 20);
1831: --
1832:
1833: If p_crit_rate_defn_code is not null then
1834: l_crit_defn_short_code := 'CRIT_RT_DEFN_SHORT_NAME='||p_crit_rate_defn_code;

Line 1841: hr_utility.set_location('Upload ',20) ;

1837: If p_rate_matrix_code is not null then
1838: l_rate_matrix_short_code := 'PL_SHORT_CODE='||p_rate_matrix_code;
1839: End if;
1840:
1841: hr_utility.set_location('Upload ',20) ;
1842: l_request_id := fnd_request.submit_request
1843: (application => 'PQH'
1844: ,program => 'PQHRBCLD'
1845: ,description => NULL

Line 1860: hr_utility.set_location(' Request id:'||to_char(l_request_id), 70);

1856: -- Re-setting g_data_migrator_mode to its previous value
1857: --
1858: --hr_general.g_data_migrator_mode := l_data_migrator_mode;
1859: --
1860: hr_utility.set_location(' Request id:'||to_char(l_request_id), 70);
1861: hr_utility.set_location(' Leaving:'||l_proc, 70);
1862: --
1863: exception
1864: --

Line 1861: hr_utility.set_location(' Leaving:'||l_proc, 70);

1857: --
1858: --hr_general.g_data_migrator_mode := l_data_migrator_mode;
1859: --
1860: hr_utility.set_location(' Request id:'||to_char(l_request_id), 70);
1861: hr_utility.set_location(' Leaving:'||l_proc, 70);
1862: --
1863: exception
1864: --
1865: when others then