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.PQP_NL_ABP_TEMPLATE dependencies on HR_UTILITY

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

486: AND business_group_id IS NULL;
487: --
488: BEGIN
489: --
490: hr_utility.set_location('Entering: '||l_proc_name, 10);
491: --
492: l_template_name := 'ABP Pension Deduction';
493: --
494: hr_utility.set_location(l_proc_name, 20);

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

490: hr_utility.set_location('Entering: '||l_proc_name, 10);
491: --
492: l_template_name := 'ABP Pension Deduction';
493: --
494: hr_utility.set_location(l_proc_name, 20);
495: --
496: FOR csr_get_temp_id_rec IN csr_get_temp_id LOOP
497: l_template_id := csr_get_temp_id_rec.template_id;
498: END LOOP;

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

496: FOR csr_get_temp_id_rec IN csr_get_temp_id LOOP
497: l_template_id := csr_get_temp_id_rec.template_id;
498: END LOOP;
499: --
500: hr_utility.set_location('Leaving: '||l_proc_name, 30);
501: --
502: RETURN l_template_id;
503: --
504: END Get_Template_ID;

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

541: FROM pay_balance_types
542: WHERE business_group_id = p_business_group_id
543: AND balance_name IN (p_scheme_prefix||' Pension Salary');
544: BEGIN
545: hr_utility.set_location('Entering: '||l_proc_name, 10);
546: FOR c1_rec IN c1_get_reg_earn_feeds LOOP
547: FOR c2_rec IN c2_balance_type LOOP
548: Pay_Balance_Feeds_f_pkg.Insert_Row
549: (X_Rowid => l_row_id,

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

561: l_Balance_Feed_Id := NULL;
562: l_row_id := NULL;
563: END LOOP;
564: END LOOP;
565: hr_utility.set_location('Leaving: '||l_proc_name, 70);
566: END Create_Pen_Sal_Bal_Feeds ;
567:
568: -- ---------------------------------------------------------------------
569: -- |-----------------------< chk_scheme_validity >----------------------|

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

602: -- sub category, users will have to delete the existing
603: -- schemes and then create a new one.
604: --
605:
606: hr_utility.set_location('Entering: '||l_proc_name, 10);
607:
608: FOR temp_rec IN c_abp_schemes
609: LOOP
610: IF (trunc(p_scheme_start_date) >=

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

627: fnd_message.raise_error;
628: END IF;
629: END LOOP;
630:
631: hr_utility.set_location('Leaving: '||l_proc_name, 20);
632:
633: END chk_scheme_validity ;
634:
635: -- ---------------------------------------------------------------------

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

864: BEGIN
865: -- ---------------------------------------------------------------------
866: -- |-------------< Main Function : Create_User_Template Body >----------|
867: -- ---------------------------------------------------------------------
868: hr_utility.set_location('Entering : '||l_proc_name, 10);
869:
870: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);
871:
872: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);

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

868: hr_utility.set_location('Entering : '||l_proc_name, 10);
869:
870: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);
871:
872: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);
873:
874: OPEN chk_pension_scheme_name_cur;
875: FETCH chk_pension_scheme_name_cur INTO l_scheme_dummy;
876: IF chk_pension_scheme_name_cur%FOUND THEN

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

910: -- Set session date
911: -- ---------------------------------------------------------------------
912: pay_db_pay_setup.set_session_date(NVL(p_effective_start_date, SYSDATE));
913: --
914: hr_utility.set_location('..Setting the Session Date', 15);
915: -- ---------------------------------------------------------------------
916: -- Get Source Template ID
917: -- ---------------------------------------------------------------------
918: l_source_template_id := get_template_id

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

919: (p_legislation_code => g_template_leg_code);
920: -- ---------------------------------------------------------------------
921: -- Exclusion rules
922: -- ---------------------------------------------------------------------
923: hr_utility.set_location('..Checking all the Exclusion Rules', 20);
924:
925: -- Define the exclusion rules
926: -- Employer component XRule
927: IF p_employer_component = 'Y' THEN

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

968:
969: -- ---------------------------------------------------------------------
970: -- Create user structure from the template
971: -- ---------------------------------------------------------------------
972: hr_utility.set_location('..Creating template User structure', 25);
973:
974: pay_element_template_api.create_user_structure
975: (p_validate => FALSE
976: ,p_effective_date => p_effective_start_date

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

1257: l_shadow_element(l_count).description
1258: := 'Element for '||p_scheme_prefix||' Retro ABP Employer Pension Contribution Previous Year';
1259: End LOOP;
1260:
1261: hr_utility.set_location('..Updating the scheme shadow elements', 30);
1262:
1263: FOR i IN 1..l_count
1264: LOOP
1265: pay_shadow_element_api.update_shadow_element

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

1273: );
1274:
1275: END LOOP;
1276:
1277: hr_utility.set_location('..After Updating the scheme shadow elements', 50);
1278:
1279: -- Replace the spaces in the prefix with underscores. The formula name
1280: -- has underscores if the prefix name has spaces in it .
1281:

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

1420: ,p_hr_only => FALSE
1421: ,p_hr_to_payroll => FALSE
1422: ,p_template_id => l_template_id);
1423: --
1424: hr_utility.set_location('..After Generating Core objects : Part - 1', 50);
1425: --
1426: pay_element_template_api.generate_part2
1427: (p_validate => FALSE
1428: ,p_effective_date => p_effective_start_date

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

1427: (p_validate => FALSE
1428: ,p_effective_date => p_effective_start_date
1429: ,p_template_id => l_template_id);
1430: --
1431: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);
1432:
1433: -- Update some of the input values on the main element
1434:
1435: pqp_nl_pension_template.Update_Ipval_Defval(

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

1526: ,p_eei_information21 => TO_CHAR(l_py_er_retro_element_type_id)
1527: ,p_element_type_extra_info_id => l_eei_info_id
1528: ,p_object_version_NUMBER => l_ovn_eei);
1529:
1530: hr_utility.set_location('..After Creating element extra information', 50);
1531:
1532: -- ---------------------------------------------------------------------
1533: -- The base element's Pay Value should feed the EE Contribution balance
1534: -- for the pension scheme created.

Line 1565: hr_utility.set_location('..After creating the balance feed for

1561: ELSIF l_ee_contribution_bal_type_id IS NULL THEN
1562: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1563: fnd_message.raise_error;
1564: END IF;
1565: hr_utility.set_location('..After creating the balance feed for
1566: the base, Pay Value', 50);
1567: END LOOP;
1568:
1569: /*OPEN c_get_subcat(l_pension_sub_category);

Line 1616: hr_utility.set_location('..After creating the balance feed for

1612: ELSIF l_ee_retro_bal_id IS NULL THEN
1613: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1614: fnd_message.raise_error;
1615: END IF;
1616: hr_utility.set_location('..After creating the balance feed for
1617: the ee retro element, Pay Value', 54);
1618: END LOOP;
1619:
1620: FOR ipv_rec IN csr_ipv

Line 1649: hr_utility.set_location('..After creating the balance feed for

1645: ELSIF l_ee_retro_bal_id IS NULL THEN
1646: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1647: fnd_message.raise_error;
1648: END IF;
1649: hr_utility.set_location('..After creating the balance feed for
1650: the ee retro element, Pay Value', 55);
1651: END LOOP;*/
1652:
1653: IF p_employer_component = 'Y' THEN

Line 1687: hr_utility.set_location('..After creating the balance feed for

1683: ELSIF l_er_contribution_bal_type_id IS NULL THEN
1684: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1685: fnd_message.raise_error;
1686: END IF;
1687: hr_utility.set_location('..After creating the balance feed for
1688: the er base, Pay Value', 50);
1689: END LOOP;
1690:
1691: /*-- ---------------------------------------------------------------------

Line 1720: hr_utility.set_location('..After creating the balance feed for the ER retro element,

1716: ELSIF l_er_retro_bal_id IS NULL THEN
1717: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1718: fnd_message.raise_error;
1719: END IF;
1720: hr_utility.set_location('..After creating the balance feed for the ER retro element,
1721: Pay Value', 57);
1722: END LOOP;
1723:
1724: FOR ipv_rec IN csr_ipv

Line 1749: hr_utility.set_location('..After creating the balance feed for the ER retro element,

1745: ELSIF l_er_retro_bal_id IS NULL THEN
1746: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1747: fnd_message.raise_error;
1748: END IF;
1749: hr_utility.set_location('..After creating the balance feed for the ER retro element,
1750: Pay Value', 58);
1751: END LOOP;*/
1752:
1753: END IF;

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

1862: ,p_employer_component => 'Y'
1863: );
1864: END IF;
1865:
1866: hr_utility.set_location('Leaving :'||l_proc_name, 190);
1867:
1868: RETURN l_base_element_type_id;
1869:
1870: END Create_User_Template;

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

1905: -- Other variables
1906: l_return_status VARCHAR2(1);
1907: l_proc VARCHAR2(72) := 'Create_User_Template_Swi';
1908: BEGIN
1909: hr_utility.set_location(' Entering:' || l_proc,10);
1910: l_element_type_id := -1;
1911: --
1912: -- Issue a savepoint
1913: --

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

1963: -- messages of any type exist in the Multiple Message List.
1964: -- Also disable Multiple Message Detection.
1965: --
1966: l_return_status := hr_multi_message.get_return_status_disable;
1967: hr_utility.set_location(' Leaving:' || l_proc,20);
1968: RETURN l_element_type_id;
1969:
1970: --
1971: EXCEPTION

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

1979: --
1980: -- Reset IN OUT parameters and set OUT parameters
1981: --
1982: RETURN l_element_type_id;
1983: hr_utility.set_location(' Leaving:' || l_proc, 30);
1984:
1985: WHEN others THEN
1986: --
1987: -- When Multiple Message Detection is enabled catch

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

1991: -- error.
1992: --
1993: ROLLBACK TO Create_User_Template_Swi;
1994: IF hr_multi_message.unexpected_error_add(l_proc) THEN
1995: hr_utility.set_location(' Leaving:' || l_proc,40);
1996: RAISE;
1997: END IF;
1998: --
1999: -- Reset IN OUT and set OUT parameters

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

1999: -- Reset IN OUT and set OUT parameters
2000: --
2001: l_return_status := hr_multi_message.get_return_status_disable;
2002: RETURN l_element_type_id;
2003: hr_utility.set_location(' Leaving:' || l_proc,50);
2004:
2005:
2006: END create_user_template_Swi;
2007:

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

2106: effective_end_date ;
2107:
2108:
2109: BEGIN
2110: hr_utility.set_location('Entering :'||l_proc, 10);
2111: --
2112:
2113: -- Check if Run Results exist for the EE Deduction Element
2114: -- If Run Results exist, the pension scheme and related

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

2237: (p_element_type_extra_info_id => temp_rec.element_type_extra_info_id
2238: ,p_object_version_number => temp_rec.ovn);
2239: END LOOP;
2240:
2241: hr_utility.set_location('Leaving :'||l_proc, 50);
2242:
2243: ELSIF l_rr_exist THEN
2244: --
2245: -- Payroll has been processed . Attempt to end date the formula

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

2331: -- Other variables
2332: l_return_status VARCHAR2(1);
2333: l_proc VARCHAR2(72) := 'Delete_User_Template_Swi';
2334: BEGIN
2335: hr_utility.set_location(' Entering:' || l_proc,10);
2336: --
2337: -- Issue a savepoint
2338: --
2339: SAVEPOINT Delete_User_Template_Swi;

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

2375: -- messages of any type exist in the Multiple Message List.
2376: -- Also disable Multiple Message Detection.
2377: --
2378: l_return_status := hr_multi_message.get_return_status_disable;
2379: hr_utility.set_location(' Leaving:' || l_proc,20);
2380:
2381: --
2382: EXCEPTION
2383: WHEN hr_multi_message.error_message_exist THEN

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

2389: ROLLBACK TO Delete_User_Template_Swi;
2390: --
2391: -- Reset IN OUT parameters and set OUT parameters
2392: --
2393: hr_utility.set_location(' Leaving:' || l_proc, 30);
2394:
2395: WHEN others THEN
2396: --
2397: -- When Multiple Message Detection is enabled catch

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

2401: -- error.
2402: --
2403: ROLLBACK TO Delete_User_Template_Swi;
2404: IF hr_multi_message.unexpected_error_add(l_proc) THEN
2405: hr_utility.set_location(' Leaving:' || l_proc,40);
2406: RAISE;
2407: END IF;
2408: --
2409: -- Reset IN OUT and set OUT parameters

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

2408: --
2409: -- Reset IN OUT and set OUT parameters
2410: --
2411: l_return_status := hr_multi_message.get_return_status_disable;
2412: hr_utility.set_location(' Leaving:' || l_proc,50);
2413:
2414: END delete_user_template_swi;
2415:
2416: --