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_PGGM_TEMPLATE dependencies on HR_UTILITY

Line 5: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PQP_NL_PGGM_TEMPLATE AS
2: /* $Header: pqpggped.pkb 120.2.12010000.3 2008/08/05 14:18:52 ubhat ship $ */
3:
4: g_proc_name VARCHAR2(80) := ' pqp_nl_pggm_template.';
5: g_debug BOOLEAN := hr_utility.debug_enabled;
6:
7: -- ---------------------------------------------------------------------
8: -- |--------------------< Create_Element_Link >------------------------|
9: -- ---------------------------------------------------------------------

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

23:
24: l_proc_name := g_proc_name||'Create_Element_Link';
25:
26: IF g_debug THEN
27: hr_utility.set_location('Entering: '||l_proc_name, 10);
28: END IF;
29:
30: IF p_element_type_id IS NOT NULL THEN
31:

Line 86: hr_utility.set_location('Leaving : '||l_proc_name, 10);

82:
83: END IF;
84:
85: IF g_debug THEN
86: hr_utility.set_location('Leaving : '||l_proc_name, 10);
87: END IF;
88:
89: END Create_Element_Link;
90:

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

394: BEGIN
395: l_proc_name := g_proc_name||'Create_Retro_Usages';
396:
397: IF g_debug THEN
398: hr_utility.set_location('Entering: '||l_proc_name, 10);
399: END IF;
400: --
401: IF g_creator.name = p_creator_name AND
402: g_creator.type = p_creator_type

Line 471: hr_utility.set_location('Insert Retro Comp Usgs '||l_proc_name, 20);

467: INTO l_rc_usage_id
468: FROM dual;
469: --
470: IF g_debug THEN
471: hr_utility.set_location('Insert Retro Comp Usgs '||l_proc_name, 20);
472: END IF;
473:
474: INSERT INTO pay_retro_component_usages(
475: RETRO_COMPONENT_USAGE_ID,

Line 555: hr_utility.set_location('Insert Element Span Usgs '||l_proc_name, 30);

551: INTO l_es_usage_id
552: FROM dual;
553:
554: IF g_debug THEN
555: hr_utility.set_location('Insert Element Span Usgs '||l_proc_name, 30);
556: END IF;
557:
558: INSERT INTO pay_element_span_usages(
559: ELEMENT_SPAN_USAGE_ID,

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

585: END;
586: END IF;
587:
588: IF g_debug THEN
589: hr_utility.set_location('Leaving '||l_proc_name, 40);
590: END IF;
591: --
592: EXCEPTION WHEN no_data_found THEN
593: NULL;

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

616: BEGIN
617: l_proc_name := g_proc_name||'Update_Event_Group';
618:
619: IF g_debug THEN
620: hr_utility.set_location('Entering: '||l_proc_name, 10);
621: END IF;
622:
623: --Query up the retro event group id
624: OPEN c_get_retro_evg_id;

Line 627: hr_utility.set_location('Retro EVG id found: '||l_retro_evg_id,20);

623: --Query up the retro event group id
624: OPEN c_get_retro_evg_id;
625: FETCH c_get_retro_evg_id INTO l_retro_evg_id;
626: IF c_get_retro_evg_id%FOUND THEN
627: hr_utility.set_location('Retro EVG id found: '||l_retro_evg_id,20);
628: CLOSE c_get_retro_evg_id;
629:
630: --now update the elements with this recalc event grp id
631: UPDATE pay_element_types_f

Line 637: hr_utility.set_location('Retro EVG id not found',30);

633: WHERE element_name = p_element_name
634: AND business_group_id = p_business_group_id;
635: ELSE
636: --evg id was not found
637: hr_utility.set_location('Retro EVG id not found',30);
638: CLOSE c_get_retro_evg_id;
639: END IF;
640:
641: IF g_debug THEN

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

638: CLOSE c_get_retro_evg_id;
639: END IF;
640:
641: IF g_debug THEN
642: hr_utility.set_location('Leaving: '||l_proc_name, 40);
643: END IF;
644:
645: EXCEPTION WHEN OTHERS THEN
646: NULL;

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

666: --
667: BEGIN
668: --
669: IF g_debug THEN
670: hr_utility.set_location('Entering: '||l_proc_name, 10);
671: END IF;
672: --
673: l_template_name := 'PGGM Pension Deduction';
674: --

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

672: --
673: l_template_name := 'PGGM Pension Deduction';
674: --
675: IF g_debug THEN
676: hr_utility.set_location(l_proc_name, 20);
677: END IF;
678: --
679: FOR csr_get_temp_id_rec IN csr_get_temp_id LOOP
680: l_template_id := csr_get_temp_id_rec.template_id;

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

680: l_template_id := csr_get_temp_id_rec.template_id;
681: END LOOP;
682: --
683: IF g_debug THEN
684: hr_utility.set_location('Leaving: '||l_proc_name, 30);
685: END IF;
686: --
687: RETURN l_template_id;
688: --

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

692: -- ---------------------------------------------------------------------
693: -- |-------------< Main Function : Create_User_Template Body >----------|
694: -- ---------------------------------------------------------------------
695: IF g_debug THEN
696: hr_utility.set_location('Entering : '||l_proc_name, 10);
697: END IF;
698:
699: --
700: -- Check the format of the prefix name entered.

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

701: --
702: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);
703:
704: IF g_debug THEN
705: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 11);
706: END IF;
707:
708: --
709: -- Check if the scheme being created is already in use.

Line 725: hr_utility.set_location('Fetching PT Details : '||l_proc_name, 12);

721: --
722: -- Fetch all pension type details
723: --
724: IF g_debug THEN
725: hr_utility.set_location('Fetching PT Details : '||l_proc_name, 12);
726: END IF;
727:
728: OPEN csr_pty1 (c_pension_type_id => p_pension_type_id
729: ,c_effective_date => p_effective_start_date);

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

746: -- ---------------------------------------------------------------------
747: pay_db_pay_setup.set_session_date(NVL(p_effective_start_date, SYSDATE));
748: --
749: IF g_debug THEN
750: hr_utility.set_location('..Setting the Session Date', 15);
751: END IF;
752: -- ---------------------------------------------------------------------
753: -- Get Source Template Id for the PGGM template
754: -- ---------------------------------------------------------------------

Line 758: hr_utility.set_location('Derived the Src Template id', 15);

754: -- ---------------------------------------------------------------------
755: l_source_template_id := get_template_id
756: (p_legislation_code => g_template_leg_code);
757: IF g_debug THEN
758: hr_utility.set_location('Derived the Src Template id', 15);
759: END IF;
760: -- ---------------------------------------------------------------------
761: -- Exclusion rules
762: -- ---------------------------------------------------------------------

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

760: -- ---------------------------------------------------------------------
761: -- Exclusion rules
762: -- ---------------------------------------------------------------------
763: IF g_debug THEN
764: hr_utility.set_location('..Checking all the Exclusion Rules', 20);
765: END IF;
766:
767: -- Define the exclusion rules
768:

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

801: -- ---------------------------------------------------------------------
802: -- Create user structure from the template
803: -- ---------------------------------------------------------------------
804: IF g_debug THEN
805: hr_utility.set_location('..Creating template User structure', 25);
806: END IF;
807:
808: pay_element_template_api.create_user_structure
809: (p_validate => FALSE

Line 828: hr_utility.set_location('Done Creating User structure', 26);

824: ,p_object_version_number => l_object_version_number
825: );
826:
827: IF g_debug THEN
828: hr_utility.set_location('Done Creating User structure', 26);
829: hr_utility.set_location('Deriving element typ ids', 27);
830: END IF;
831:
832: -- ---------------------------------------------------------------------

Line 829: hr_utility.set_location('Deriving element typ ids', 27);

825: );
826:
827: IF g_debug THEN
828: hr_utility.set_location('Done Creating User structure', 26);
829: hr_utility.set_location('Deriving element typ ids', 27);
830: END IF;
831:
832: -- ---------------------------------------------------------------------
833: -- |-------------------< Update Shadow Structure >----------------------|

Line 1150: hr_utility.set_location('Finished deriving element typ ids', 28);

1146: ||' Retro PGGM Disability Pension Contribution';
1147: END LOOP;
1148:
1149: IF g_debug THEN
1150: hr_utility.set_location('Finished deriving element typ ids', 28);
1151: hr_utility.set_location('..Updating the scheme shadow elements', 30);
1152: END IF;
1153:
1154: FOR i IN 1..l_count

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

1147: END LOOP;
1148:
1149: IF g_debug THEN
1150: hr_utility.set_location('Finished deriving element typ ids', 28);
1151: hr_utility.set_location('..Updating the scheme shadow elements', 30);
1152: END IF;
1153:
1154: FOR i IN 1..l_count
1155: LOOP

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

1164: );
1165: END LOOP;
1166:
1167: IF g_debug THEN
1168: hr_utility.set_location('..After Updating the scheme shadow elements', 50);
1169: END IF;
1170: --
1171: -- Replace the spaces in the prefix with underscores. The formula name
1172: -- has underscores if the prefix name has spaces in it .

Line 1184: hr_utility.set_location('Replacing Balance Name in the formula', 51);

1180: (l_scheme_prefix||'_PGGM_PENSION_DEDUCTION'
1181: ,p_business_group_id);
1182:
1183: IF g_debug THEN
1184: hr_utility.set_location('Replacing Balance Name in the formula', 51);
1185: END IF;
1186:
1187: IF r_pty_rec.ee_contribution_bal_type_id IS NOT NULL THEN
1188:

Line 1215: hr_utility.set_location('Replacing Tax SI string in the formula', 51);

1211: -- Replace the taxation and social insurance
1212: -- balance reduction text in the formula
1213: --
1214: IF g_debug THEN
1215: hr_utility.set_location('Replacing Tax SI string in the formula', 51);
1216: END IF;
1217:
1218: pqp_pension_functions.gen_dynamic_formula
1219: (p_pension_type_id => p_pension_type_id

Line 1242: hr_utility.set_location('Done replacing Tax SI string in the formula', 51);

1238: '_PGGM_EMPLOYER_PENSION_CONTRIBUTION'
1239: ,p_business_group_id);
1240:
1241: IF g_debug THEN
1242: hr_utility.set_location('Done replacing Tax SI string in the formula', 51);
1243: hr_utility.set_location('Generating Core objects : Part - 1', 50);
1244: END IF;
1245: -- ---------------------------------------------------------------------
1246: -- |-------------------< Generate Core Objects >------------------------|

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

1239: ,p_business_group_id);
1240:
1241: IF g_debug THEN
1242: hr_utility.set_location('Done replacing Tax SI string in the formula', 51);
1243: hr_utility.set_location('Generating Core objects : Part - 1', 50);
1244: END IF;
1245: -- ---------------------------------------------------------------------
1246: -- |-------------------< Generate Core Objects >------------------------|
1247: -- ---------------------------------------------------------------------

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

1252: ,p_hr_to_payroll => FALSE
1253: ,p_template_id => l_template_id);
1254: --
1255: IF g_debug THEN
1256: hr_utility.set_location('..After Generating Core objects : Part - 1', 50);
1257: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);
1258: END IF;
1259:
1260: pay_element_template_api.generate_part2

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

1253: ,p_template_id => l_template_id);
1254: --
1255: IF g_debug THEN
1256: hr_utility.set_location('..After Generating Core objects : Part - 1', 50);
1257: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);
1258: END IF;
1259:
1260: pay_element_template_api.generate_part2
1261: (p_validate => FALSE

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

1262: ,p_effective_date => p_effective_start_date
1263: ,p_template_id => l_template_id);
1264: --
1265: IF g_debug THEN
1266: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);
1267: hr_utility.set_location('Updating Input Values..', 50);
1268: END IF;
1269:
1270: --

Line 1267: hr_utility.set_location('Updating Input Values..', 50);

1263: ,p_template_id => l_template_id);
1264: --
1265: IF g_debug THEN
1266: hr_utility.set_location('..After Generating Core objects : Part - 2', 50);
1267: hr_utility.set_location('Updating Input Values..', 50);
1268: END IF;
1269:
1270: --
1271: -- Update some the input values for default values

Line 1310: hr_utility.set_location('Done Updating Input Values..', 50);

1306: ,p_contrib_rounding
1307: ,p_business_group_id);
1308:
1309: IF g_debug THEN
1310: hr_utility.set_location('Done Updating Input Values..', 50);
1311: hr_utility.set_location('Deriving Element Type Ids..', 50);
1312: END IF;
1313:
1314: -- ------------------------------------------------------------------------

Line 1311: hr_utility.set_location('Deriving Element Type Ids..', 50);

1307: ,p_business_group_id);
1308:
1309: IF g_debug THEN
1310: hr_utility.set_location('Done Updating Input Values..', 50);
1311: hr_utility.set_location('Deriving Element Type Ids..', 50);
1312: END IF;
1313:
1314: -- ------------------------------------------------------------------------
1315: -- Derive Element Type Ids for all elements created.

Line 1363: hr_utility.set_location('Completed Deriving Element Type Ids..', 50);

1359: ||' Retro PGGM Employer Pension Contribution Previous Year',
1360: p_business_group_id,
1361: l_template_id);
1362: IF g_debug THEN
1363: hr_utility.set_location('Completed Deriving Element Type Ids..', 50);
1364: END IF;
1365: --
1366: -- Get the ids of all the retro elements
1367: -- This is required to create links if the user has

Line 1374: hr_utility.set_location('Deriving Retro Element Type Ids..', 50);

1370:
1371: IF NVL(p_link_retro_elements,'N') = 'Y' THEN
1372:
1373: IF g_debug THEN
1374: hr_utility.set_location('Deriving Retro Element Type Ids..', 50);
1375: END IF;
1376:
1377: l_retr_1 := pqp_nl_pension_template.get_object_id
1378: ('ELE',

Line 1485: hr_utility.set_location('Completed Deriving Retro Element Type Ids..', 50);

1481: l_retro_element_lst(l_retro_count) := l_retr_22;
1482: END IF;
1483:
1484: IF g_debug THEN
1485: hr_utility.set_location('Completed Deriving Retro Element Type Ids..', 50);
1486: hr_utility.set_location('Creating Retro Ele Links..', 50);
1487: END IF;
1488:
1489: --

Line 1486: hr_utility.set_location('Creating Retro Ele Links..', 50);

1482: END IF;
1483:
1484: IF g_debug THEN
1485: hr_utility.set_location('Completed Deriving Retro Element Type Ids..', 50);
1486: hr_utility.set_location('Creating Retro Ele Links..', 50);
1487: END IF;
1488:
1489: --
1490: -- Create Links for the retro elements if the user has chosen to do so.

Line 1502: hr_utility.set_location('Completed Creating Retro Ele Links..', 50);

1498: ,p_effective_end_date => p_effective_end_date );
1499: END LOOP;
1500:
1501: IF g_debug THEN
1502: hr_utility.set_location('Completed Creating Retro Ele Links..', 50);
1503: END IF;
1504:
1505: END IF; -- Check if retro element links need to be created
1506:

Line 1513: hr_utility.set_location('Creating Ele Links..', 50);

1509: --
1510: IF NVL(p_link_dedn_elements,'N') = 'Y' THEN
1511:
1512: IF g_debug THEN
1513: hr_utility.set_location('Creating Ele Links..', 50);
1514: END IF;
1515:
1516: -- Main Deduction Element
1517: Create_Element_Link

Line 1538: hr_utility.set_location('Completed Creating Ele Links..', 50);

1534: ,p_effective_start_date => p_effective_start_date
1535: ,p_effective_end_date => p_effective_end_date );
1536:
1537: IF g_debug THEN
1538: hr_utility.set_location('Completed Creating Ele Links..', 50);
1539: END IF;
1540:
1541: END IF;
1542:

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

1544: -- ------------------------------------------------------------------------
1545: -- Create a row in pay_element_extra_info with all the element information
1546: -- ------------------------------------------------------------------------
1547: IF g_debug THEN
1548: hr_utility.set_location('..Creating element extra information', 50);
1549: END IF;
1550:
1551: pay_element_extra_info_api.create_element_extra_info
1552: (p_element_type_id => l_base_element_type_id

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

1569: ,p_element_type_extra_info_id => l_eei_info_id
1570: ,p_object_version_number => l_ovn_eei);
1571:
1572: IF g_debug THEN
1573: hr_utility.set_location('..After Creating element extra information', 50);
1574:
1575: -- ---------------------------------------------------------------------
1576: -- Create the Retro Component usage associations between the retro and
1577: -- pension deduction elements

Line 1579: hr_utility.set_location('Creating Retro Comp Usgs', 50);

1575: -- ---------------------------------------------------------------------
1576: -- Create the Retro Component usage associations between the retro and
1577: -- pension deduction elements
1578: -- ---------------------------------------------------------------------
1579: hr_utility.set_location('Creating Retro Comp Usgs', 50);
1580: END IF;
1581:
1582: -- EE Correction
1583: Create_Retro_Usages

Line 1793: hr_utility.set_location('Done Creating Retro Comp Usgs', 50);

1789: ,p_end_time_def_name => 'End of Previous Year'
1790: ,p_business_group_id => p_business_group_id);
1791:
1792: IF g_debug THEN
1793: hr_utility.set_location('Done Creating Retro Comp Usgs', 50);
1794: END IF;
1795:
1796: IF g_debug THEN
1797: hr_utility.set_location('Adding Event Group',60);

Line 1797: hr_utility.set_location('Adding Event Group',60);

1793: hr_utility.set_location('Done Creating Retro Comp Usgs', 50);
1794: END IF;
1795:
1796: IF g_debug THEN
1797: hr_utility.set_location('Adding Event Group',60);
1798: END IF;
1799:
1800: Update_Event_Group
1801: (p_element_name => p_scheme_prefix||' PGGM Pension Deduction'

Line 1813: hr_utility.set_location('Done Adding the Event Group', 60);

1809: (p_element_name => p_scheme_prefix||' PGGM Extra Pensions'
1810: ,p_business_group_id => p_business_group_id);
1811:
1812: IF g_debug THEN
1813: hr_utility.set_location('Done Adding the Event Group', 60);
1814: END IF;
1815:
1816: -- ---------------------------------------------------------------------
1817: -- Compile the base element's standard formula

Line 1819: hr_utility.set_location('Compile EE Formula', 50);

1815:
1816: -- ---------------------------------------------------------------------
1817: -- Compile the base element's standard formula
1818: -- ---------------------------------------------------------------------
1819: hr_utility.set_location('Compile EE Formula', 50);
1820:
1821: pqp_nl_pension_template.Compile_Formula
1822: (p_element_type_id => l_base_element_type_id
1823: ,p_effective_start_date => p_effective_start_date

Line 1830: hr_utility.set_location('Done Compile EE Formula', 50);

1826: ,p_request_id => l_request_id
1827: );
1828:
1829: IF g_debug THEN
1830: hr_utility.set_location('Done Compile EE Formula', 50);
1831: hr_utility.set_location('Compile ER Formula', 50);
1832: END IF;
1833:
1834: pqp_nl_pension_template.Compile_Formula

Line 1831: hr_utility.set_location('Compile ER Formula', 50);

1827: );
1828:
1829: IF g_debug THEN
1830: hr_utility.set_location('Done Compile EE Formula', 50);
1831: hr_utility.set_location('Compile ER Formula', 50);
1832: END IF;
1833:
1834: pqp_nl_pension_template.Compile_Formula
1835: (p_element_type_id => l_er_base_element_type_id

Line 1843: hr_utility.set_location('Done Compile ER Formula', 50);

1839: ,p_request_id => l_er_request_id
1840: );
1841:
1842: IF g_debug THEN
1843: hr_utility.set_location('Done Compile ER Formula', 50);
1844: hr_utility.set_location('Leaving :'||l_proc_name, 190);
1845: END IF;
1846:
1847: RETURN l_base_element_type_id;

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

1840: );
1841:
1842: IF g_debug THEN
1843: hr_utility.set_location('Done Compile ER Formula', 50);
1844: hr_utility.set_location('Leaving :'||l_proc_name, 190);
1845: END IF;
1846:
1847: RETURN l_base_element_type_id;
1848:

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

1883: l_proc VARCHAR2(72) := 'Create_User_Template_Swi';
1884: BEGIN
1885:
1886: IF g_debug THEN
1887: hr_utility.set_location(' Entering:' || l_proc,10);
1888: END IF;
1889:
1890: l_element_type_id := -1;
1891: --

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

1944: --
1945: l_return_status := hr_multi_message.get_return_status_disable;
1946:
1947: IF g_debug THEN
1948: hr_utility.set_location(' Leaving:' || l_proc,20);
1949: END IF;
1950:
1951: RETURN l_element_type_id;
1952:

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

1964: --
1965: RETURN l_element_type_id;
1966:
1967: IF g_debug THEN
1968: hr_utility.set_location(' Leaving:' || l_proc, 30);
1969: END IF;
1970:
1971: WHEN others THEN
1972: --

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

1978: --
1979: ROLLBACK TO Create_User_Template_Swi;
1980: IF hr_multi_message.unexpected_error_add(l_proc) THEN
1981: IF g_debug THEN
1982: hr_utility.set_location(' Leaving:' || l_proc,40);
1983: END IF;
1984: RAISE;
1985: END IF;
1986: --

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

1989: l_return_status := hr_multi_message.get_return_status_disable;
1990: RETURN l_element_type_id;
1991:
1992: IF g_debug THEN
1993: hr_utility.set_location(' Leaving:' || l_proc,50);
1994: END IF;
1995:
1996: END Create_User_Template_Swi;
1997:

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

2069: l_base_name VARCHAR2(100);
2070:
2071: BEGIN
2072: IF g_debug THEN
2073: hr_utility.set_location('Entering :'||l_proc, 10);
2074: END IF;
2075: --
2076: -- Check if Run Results exist for the EE Deduction Element
2077: -- If Run Results exist, the pension scheme and related

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

2129: ,p_object_version_number => temp_rec.ovn);
2130: END LOOP;
2131:
2132: IF g_debug THEN
2133: hr_utility.set_location('Leaving :'||l_proc, 50);
2134: END IF;
2135:
2136: ELSE -- run results exist
2137: hr_utility.set_message(8303,'PQP_230214_PGGM_SCHM_DEL_ERR');

Line 2137: hr_utility.set_message(8303,'PQP_230214_PGGM_SCHM_DEL_ERR');

2133: hr_utility.set_location('Leaving :'||l_proc, 50);
2134: END IF;
2135:
2136: ELSE -- run results exist
2137: hr_utility.set_message(8303,'PQP_230214_PGGM_SCHM_DEL_ERR');
2138: hr_utility.raise_error;
2139: END IF;
2140:
2141: END Delete_User_Template;

Line 2138: hr_utility.raise_error;

2134: END IF;
2135:
2136: ELSE -- run results exist
2137: hr_utility.set_message(8303,'PQP_230214_PGGM_SCHM_DEL_ERR');
2138: hr_utility.raise_error;
2139: END IF;
2140:
2141: END Delete_User_Template;
2142: --

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

2163: l_return_status VARCHAR2(1);
2164: l_proc VARCHAR2(72) := 'Delete_User_Template_Swi';
2165: BEGIN
2166: IF g_debug THEN
2167: hr_utility.set_location(' Entering:' || l_proc,10);
2168: END IF;
2169: --
2170: -- Issue a savepoint
2171: --

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

2209: -- Also disable Multiple Message Detection.
2210: --
2211: l_return_status := hr_multi_message.get_return_status_disable;
2212: IF g_debug THEN
2213: hr_utility.set_location(' Leaving:' || l_proc,20);
2214: END IF;
2215:
2216: --
2217: EXCEPTION

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

2225: --
2226: -- Reset IN OUT parameters and set OUT parameters
2227: --
2228: IF g_debug THEN
2229: hr_utility.set_location(' Leaving:' || l_proc, 30);
2230: END IF;
2231:
2232: WHEN others THEN
2233: --

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

2239: --
2240: ROLLBACK TO Delete_User_Template_Swi;
2241: IF hr_multi_message.unexpected_error_add(l_proc) THEN
2242: IF g_debug THEN
2243: hr_utility.set_location(' Leaving:' || l_proc,40);
2244: END IF;
2245: RAISE;
2246: END IF;
2247: --

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

2248: -- Reset IN OUT and set OUT parameters
2249: --
2250: l_return_status := hr_multi_message.get_return_status_disable;
2251: IF g_debug THEN
2252: hr_utility.set_location(' Leaving:' || l_proc,50);
2253: END IF;
2254:
2255: END delete_user_template_swi;
2256: --