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.

[Home] [Help]

APPS.PQP_NL_PENSION_TEMPLATE dependencies on HR_UTILITY

Line 41: hr_utility.set_location('Entering: '||l_proc_name, 10);

37: l_request_id number;
38: l_er_request_id number;
39: l_proc_name Varchar2(80) := g_proc_name || 'compile_formula';
40: begin
41: hr_utility.set_location('Entering: '||l_proc_name, 10);
42: -- ------------------------------------------------------------
43: -- Query formula info (ie. the formula attached to this
44: -- element's Standard status proc rule.
45: -- ------------------------------------------------------------

Line 48: hr_utility.set_location('..FF Name :'||fra_rec.formula_name,15);

44: -- element's Standard status proc rule.
45: -- ------------------------------------------------------------
46: for fra_rec in csr_fra (c_element_type_id => p_element_type_id)
47: loop
48: hr_utility.set_location('..FF Name :'||fra_rec.formula_name,15);
49: hr_utility.set_location('..FF Type Name :'||fra_rec.formula_type_name,20);
50: -- ----------------------------------------------
51: -- Submit the request to compile the formula
52: -- ----------------------------------------------

Line 49: hr_utility.set_location('..FF Type Name :'||fra_rec.formula_type_name,20);

45: -- ------------------------------------------------------------
46: for fra_rec in csr_fra (c_element_type_id => p_element_type_id)
47: loop
48: hr_utility.set_location('..FF Name :'||fra_rec.formula_name,15);
49: hr_utility.set_location('..FF Type Name :'||fra_rec.formula_type_name,20);
50: -- ----------------------------------------------
51: -- Submit the request to compile the formula
52: -- ----------------------------------------------
53: l_request_id := fnd_request.submit_request

Line 59: hr_utility.set_location('..Request Id :'||p_request_id, 25);

55: ,program => 'SINGLECOMPILE'
56: ,argument1 => fra_rec.formula_type_name --Oracle Payroll
57: ,argument2 => fra_rec.formula_name); --formula name
58: p_request_id := l_request_id;
59: hr_utility.set_location('..Request Id :'||p_request_id, 25);
60: end loop;
61: hr_utility.set_location('Leaving: '||l_proc_name, 30);
62: exception
63: when others then

Line 61: hr_utility.set_location('Leaving: '||l_proc_name, 30);

57: ,argument2 => fra_rec.formula_name); --formula name
58: p_request_id := l_request_id;
59: hr_utility.set_location('..Request Id :'||p_request_id, 25);
60: end loop;
61: hr_utility.set_location('Leaving: '||l_proc_name, 30);
62: exception
63: when others then
64: hr_utility.set_location('..Entering exception when others ', 80);
65: hr_utility.set_location('Leaving: '||l_proc_name, 90);

Line 64: hr_utility.set_location('..Entering exception when others ', 80);

60: end loop;
61: hr_utility.set_location('Leaving: '||l_proc_name, 30);
62: exception
63: when others then
64: hr_utility.set_location('..Entering exception when others ', 80);
65: hr_utility.set_location('Leaving: '||l_proc_name, 90);
66: p_request_id := null; raise;
67: end Compile_Formula;
68:

Line 65: hr_utility.set_location('Leaving: '||l_proc_name, 90);

61: hr_utility.set_location('Leaving: '||l_proc_name, 30);
62: exception
63: when others then
64: hr_utility.set_location('..Entering exception when others ', 80);
65: hr_utility.set_location('Leaving: '||l_proc_name, 90);
66: p_request_id := null; raise;
67: end Compile_Formula;
68:
69: -- ----------------------------------------------------------------------------

Line 130: hr_utility.set_location('Entering: '||l_proc_name, 10);

126: and ptco.template_id = psbt.template_id
127: and ptco.shadow_object_id = psbt.balance_type_id;
128: --
129: begin
130: hr_utility.set_location('Entering: '||l_proc_name, 10);
131: --
132: if p_object_type = 'ELE' then
133: for c2_rec in c2 (p_object_name) loop
134: l_object_id := c2_rec.element_type_id; -- element id

Line 142: hr_utility.set_location('Leaving: '||l_proc_name, 20);

138: l_object_id := c3_rec.core_object_id; -- balance id
139: end loop;
140: end if;
141: --
142: hr_utility.set_location('Leaving: '||l_proc_name, 20);
143: --
144: return l_object_id;
145: end Get_Object_ID;
146:

Line 165: hr_utility.set_location ('Entering '||l_proc_name, 10);

161: l_proc_name Varchar2(72) := g_proc_name || 'get_formula_id';
162: l_formula_id Number;
163: begin
164: --
165: hr_utility.set_location ('Entering '||l_proc_name, 10);
166: --
167: open csr_get_formula_id;
168: fetch csr_get_formula_id into l_formula_id;
169: close csr_get_formula_id;

Line 171: hr_utility.set_location ('Leaving '||l_proc_name, 20);

167: open csr_get_formula_id;
168: fetch csr_get_formula_id into l_formula_id;
169: close csr_get_formula_id;
170: --
171: hr_utility.set_location ('Leaving '||l_proc_name, 20);
172: --
173: return l_formula_id;
174: end Get_Formula_ID;
175:

Line 217: hr_utility.set_location ('Entering '||l_proc_name, 10);

213: 'update_ipval_defval';
214: --
215: begin
216: --
217: hr_utility.set_location ('Entering '||l_proc_name, 10);
218: --
219: open csr_getinput(p_ele_name ,p_ip_name);
220: loop
221: fetch csr_getinput into csr_getinput_rec;

Line 224: hr_utility.set_location (l_proc_name, 20);

220: loop
221: fetch csr_getinput into csr_getinput_rec;
222: exit when csr_getinput%notfound;
223: --
224: hr_utility.set_location (l_proc_name, 20);
225: --
226: open csr_updinput(csr_getinput_rec.input_value_id
227: ,csr_getinput_rec.element_type_id);
228: loop

Line 232: hr_utility.set_location (l_proc_name, 30);

228: loop
229: fetch csr_updinput into csr_updinput_rec;
230: exit when csr_updinput%notfound;
231: --
232: hr_utility.set_location (l_proc_name, 30);
233: --
234: update pay_input_values_f
235: set default_value = p_def_value
236: where rowid = csr_updinput_rec.rowid;

Line 242: hr_utility.set_location ('Leaving '||l_proc_name, 40);

238: close csr_updinput;
239: end loop;
240: close csr_getinput;
241: --
242: hr_utility.set_location ('Leaving '||l_proc_name, 40);
243: --
244: end Update_Ipval_Defval;
245:
246: -- ---------------------------------------------------------------------

Line 519: hr_utility.set_location('Entering: '||l_proc_name, 10);

515: and business_group_id is null;
516: --
517: begin
518: --
519: hr_utility.set_location('Entering: '||l_proc_name, 10);
520: --
521: l_template_name := 'Dutch Pension Deduction';
522: --
523: hr_utility.set_location(l_proc_name, 20);

Line 523: hr_utility.set_location(l_proc_name, 20);

519: hr_utility.set_location('Entering: '||l_proc_name, 10);
520: --
521: l_template_name := 'Dutch Pension Deduction';
522: --
523: hr_utility.set_location(l_proc_name, 20);
524: --
525: for csr_get_temp_id_rec in csr_get_temp_id loop
526: l_template_id := csr_get_temp_id_rec.template_id;
527: end loop;

Line 529: hr_utility.set_location('Leaving: '||l_proc_name, 30);

525: for csr_get_temp_id_rec in csr_get_temp_id loop
526: l_template_id := csr_get_temp_id_rec.template_id;
527: end loop;
528: --
529: hr_utility.set_location('Leaving: '||l_proc_name, 30);
530: --
531: return l_template_id;
532: --
533: end Get_Template_ID;

Line 575: hr_utility.set_location('Entering: '||l_proc_name, 10);

571: from pay_balance_types
572: where business_group_id = p_business_group_id
573: and balance_name in (p_scheme_prefix||' Pension Salary');
574: begin
575: hr_utility.set_location('Entering: '||l_proc_name, 10);
576: for c1_rec in c1_get_reg_earn_feeds loop
577: for c2_rec in c2_balance_type loop
578: Pay_Balance_Feeds_f_pkg.Insert_Row
579: (X_Rowid => l_row_id,

Line 595: hr_utility.set_location('Leaving: '||l_proc_name, 70);

591: l_Balance_Feed_Id := Null;
592: l_row_id := Null;
593: end loop;
594: end loop;
595: hr_utility.set_location('Leaving: '||l_proc_name, 70);
596: end Create_Pen_Sal_Bal_Feeds ;
597:
598: begin
599: -- ---------------------------------------------------------------------

Line 602: hr_utility.set_location('Entering : '||l_proc_name, 10);

598: begin
599: -- ---------------------------------------------------------------------
600: -- |-------------< Main Function : Create_User_Template Body >----------|
601: -- ---------------------------------------------------------------------
602: hr_utility.set_location('Entering : '||l_proc_name, 10);
603:
604: chk_scheme_prefix(p_scheme_prefix);
605:
606: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);

Line 606: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);

602: hr_utility.set_location('Entering : '||l_proc_name, 10);
603:
604: chk_scheme_prefix(p_scheme_prefix);
605:
606: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);
607: OPEN chk_pension_scheme_name_cur;
608: FETCH chk_pension_scheme_name_cur INTO l_scheme_dummy;
609: IF chk_pension_scheme_name_cur%FOUND THEN
610: CLOSE chk_pension_scheme_name_cur;

Line 622: hr_utility.set_location('..Setting the Session Date', 15);

618: -- Set session date
619: -- ---------------------------------------------------------------------
620: pay_db_pay_setup.set_session_date(nvl(p_effective_start_date, sysdate));
621: --
622: hr_utility.set_location('..Setting the Session Date', 15);
623: -- ---------------------------------------------------------------------
624: -- Get Source Template ID
625: -- ---------------------------------------------------------------------
626: l_source_template_id := get_template_id

Line 631: hr_utility.set_location('..Checking all the Exclusion Rules', 20);

627: (p_legislation_code => g_template_leg_code);
628: -- ---------------------------------------------------------------------
629: -- Exclusion rules
630: -- ---------------------------------------------------------------------
631: hr_utility.set_location('..Checking all the Exclusion Rules', 20);
632:
633: -- Define the exclusion_rule based on the salary calculation method.
634:
635: OPEN csr_pty1 (c_pension_type_id => p_pension_type_id

Line 732: hr_utility.set_location('..Creating template User structure', 25);

728:
729: -- ---------------------------------------------------------------------
730: -- Create user structure from the template
731: -- ---------------------------------------------------------------------
732: hr_utility.set_location('..Creating template User structure', 25);
733: pay_element_template_api.create_user_structure
734: (p_validate => false
735: ,p_effective_date => p_effective_start_date
736: ,p_business_group_id => p_business_group_id

Line 917: hr_utility.set_location('..Updating the scheme shadow elements', 30);

913: := 'Element for '||p_scheme_prefix||' Tax SI Adjustment';
914: END LOOP;
915:
916:
917: hr_utility.set_location('..Updating the scheme shadow elements', 30);
918: for i in 1..l_count
919: loop
920: -- Set the standard link flag only for EE and ER elements
921: -- if the standard link is Y

Line 946: hr_utility.set_location('..After Updating the scheme shadow elements', 50);

942: -- Reset the value for standard link flag.
943: l_std_link_flag := 'N';
944:
945: end loop;
946: hr_utility.set_location('..After Updating the scheme shadow elements', 50);
947:
948: -- Replace the spaces in the prefix with underscores. The formula name
949: -- has underscores if the prefix name has spaces in it .
950: l_scheme_prefix := upper(replace(l_scheme_prefix,' ','_'));

Line 1375: hr_utility.set_location('..After Generating Core objects : Part - 1', 50);

1371: ,p_hr_only => false
1372: ,p_hr_to_payroll => false
1373: ,p_template_id => l_template_id);
1374: --
1375: hr_utility.set_location('..After Generating Core objects : Part - 1', 50);
1376: --
1377: pay_element_template_api.generate_part2
1378: (p_validate => false
1379: ,p_effective_date => p_effective_start_date

Line 1382: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);

1378: (p_validate => false
1379: ,p_effective_date => p_effective_start_date
1380: ,p_template_id => l_template_id);
1381: --
1382: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);
1383:
1384: -- Update some of the input values on the main element
1385:
1386: Update_Ipval_Defval( p_scheme_prefix||' Pension Deduction'

Line 1485: hr_utility.set_location('..After Creating element extra information', 50);

1481: ,p_eei_information20 => null
1482: ,p_element_type_extra_info_id => l_eei_info_id
1483: ,p_object_version_number => l_ovn_eei);
1484:
1485: hr_utility.set_location('..After Creating element extra information', 50);
1486:
1487: -- ---------------------------------------------------------------------
1488: -- The base element's Pay Value should feed the EE Contribution balance
1489: -- for the pension scheme created.

Line 1526: hr_utility.set_location('..After creating the balance feed for the base, Pay Value', 50);

1522: l_row_id := null;
1523:
1524: end loop;
1525:
1526: hr_utility.set_location('..After creating the balance feed for the base, Pay Value', 50);
1527:
1528: -- ---------------------------------------------------------------------
1529: -- The ER base element's Pay Value should feed the ER Contribution balance
1530: -- for the pension scheme created.

Line 1569: hr_utility.set_location('..After creating the balance feed for the ER base, Pay Value', 51);

1565: end loop;
1566:
1567: END IF;
1568:
1569: hr_utility.set_location('..After creating the balance feed for the ER base, Pay Value', 51);
1570:
1571: -- ---------------------------------------------------------------------
1572: -- Create the Balance feeds for the eligible comp balance
1573: -- ---------------------------------------------------------------------

Line 1601: hr_utility.set_location('Leaving :'||l_proc_name, 190);

1597:
1598: END IF;
1599:
1600:
1601: hr_utility.set_location('Leaving :'||l_proc_name, 190);
1602:
1603: return l_base_element_type_id;
1604:
1605: end Create_User_Template;

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

1640: -- Other variables
1641: l_return_status varchar2(1);
1642: l_proc varchar2(72) := 'Create_User_Template_Swi';
1643: Begin
1644: hr_utility.set_location(' Entering:' || l_proc,10);
1645: l_element_type_id := -1;
1646: --
1647: -- Issue a savepoint
1648: --

Line 1702: hr_utility.set_location(' Leaving:' || l_proc,20);

1698: -- messages of any type exist in the Multiple Message List.
1699: -- Also disable Multiple Message Detection.
1700: --
1701: l_return_status := hr_multi_message.get_return_status_disable;
1702: hr_utility.set_location(' Leaving:' || l_proc,20);
1703: return l_element_type_id;
1704:
1705: --
1706: exception

Line 1718: hr_utility.set_location(' Leaving:' || l_proc, 30);

1714: --
1715: -- Reset IN OUT parameters and set OUT parameters
1716: --
1717: return l_element_type_id;
1718: hr_utility.set_location(' Leaving:' || l_proc, 30);
1719:
1720: when others then
1721: --
1722: -- When Multiple Message Detection is enabled catch

Line 1730: hr_utility.set_location(' Leaving:' || l_proc,40);

1726: -- error.
1727: --
1728: rollback to Create_User_Template_Swi;
1729: if hr_multi_message.unexpected_error_add(l_proc) then
1730: hr_utility.set_location(' Leaving:' || l_proc,40);
1731: raise;
1732: end if;
1733: --
1734: -- Reset IN OUT and set OUT parameters

Line 1738: hr_utility.set_location(' Leaving:' || l_proc,50);

1734: -- Reset IN OUT and set OUT parameters
1735: --
1736: l_return_status := hr_multi_message.get_return_status_disable;
1737: return l_element_type_id;
1738: hr_utility.set_location(' Leaving:' || l_proc,50);
1739:
1740:
1741: END create_user_template_swi;
1742:

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

1771: l_template_id Number(9);
1772: l_proc Varchar2(60) := g_proc_name||'Delete_User_Template';
1773:
1774: begin
1775: hr_utility.set_location('Entering :'||l_proc, 10);
1776: --
1777: for c1_rec in c1 loop
1778: l_template_id := c1_rec.template_id;
1779: end loop;

Line 1798: hr_utility.set_location('Leaving :'||l_proc, 50);

1794: (p_element_type_extra_info_id => temp_rec.element_type_extra_info_id
1795: ,p_object_version_number => temp_rec.object_version_number);
1796: END LOOP;
1797:
1798: hr_utility.set_location('Leaving :'||l_proc, 50);
1799:
1800: end Delete_User_Template;
1801: --
1802:

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

1822: -- Other variables
1823: l_return_status varchar2(1);
1824: l_proc varchar2(72) := 'Delete_User_Template_Swi';
1825: Begin
1826: hr_utility.set_location(' Entering:' || l_proc,10);
1827: --
1828: -- Issue a savepoint
1829: --
1830: savepoint Delete_User_Template_Swi;

Line 1871: hr_utility.set_location(' Leaving:' || l_proc,20);

1867: -- messages of any type exist in the Multiple Message List.
1868: -- Also disable Multiple Message Detection.
1869: --
1870: l_return_status := hr_multi_message.get_return_status_disable;
1871: hr_utility.set_location(' Leaving:' || l_proc,20);
1872:
1873: --
1874: exception
1875: when hr_multi_message.error_message_exist then

Line 1885: hr_utility.set_location(' Leaving:' || l_proc, 30);

1881: rollback to Delete_User_Template_Swi;
1882: --
1883: -- Reset IN OUT parameters and set OUT parameters
1884: --
1885: hr_utility.set_location(' Leaving:' || l_proc, 30);
1886:
1887: when others then
1888: --
1889: -- When Multiple Message Detection is enabled catch

Line 1897: hr_utility.set_location(' Leaving:' || l_proc,40);

1893: -- error.
1894: --
1895: rollback to Delete_User_Template_Swi;
1896: if hr_multi_message.unexpected_error_add(l_proc) then
1897: hr_utility.set_location(' Leaving:' || l_proc,40);
1898: raise;
1899: end if;
1900: --
1901: -- Reset IN OUT and set OUT parameters

Line 1904: hr_utility.set_location(' Leaving:' || l_proc,50);

1900: --
1901: -- Reset IN OUT and set OUT parameters
1902: --
1903: l_return_status := hr_multi_message.get_return_status_disable;
1904: hr_utility.set_location(' Leaving:' || l_proc,50);
1905:
1906: END delete_user_template_swi;
1907:
1908: --