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_PENSION_TYPES_API dependencies on HR_API

Line 931: ,p_effective_end_date => hr_api.g_eot

927: ,p_standard_link_flag => 'N'
928: ,p_business_group_name => l_business_group_name
929: ,p_legislation_code => p_legislation_code
930: ,p_effective_start_date => p_effective_date
931: ,p_effective_end_date => hr_api.g_eot
932: );
933:
934: hr_utility.set_location(' Creating input value EE Contribution', 20);
935: l_ipv_ee_contr := pay_db_pay_setup.create_input_value

Line 944: ,p_effective_end_date => hr_api.g_eot

940: ,p_mandatory_flag => 'N'
941: ,p_display_sequence => 1
942: ,p_business_group_name => l_business_group_name
943: ,p_effective_start_date => p_effective_date
944: ,p_effective_end_date => hr_api.g_eot
945: ,p_legislation_code => p_legislation_code
946: );
947: hr_utility.set_location(' Creating input value ER Contribution', 25);
948: l_ipv_er_contr := pay_db_pay_setup.create_input_value

Line 957: ,p_effective_end_date => hr_api.g_eot

953: ,p_mandatory_flag => 'N'
954: ,p_display_sequence => 2
955: ,p_business_group_name => l_business_group_name
956: ,p_effective_start_date => p_effective_date
957: ,p_effective_end_date => hr_api.g_eot
958: ,p_legislation_code => p_legislation_code
959: );
960:
961: If p_pension_sub_cat IS NOT NULL THEN

Line 1046: X_Effective_End_Date => hr_api.g_eot,

1042: Pay_Balance_Feeds_f_pkg.Insert_Row(
1043: X_Rowid => l_row_id,
1044: X_Balance_Feed_Id => l_Balance_Feed_Id,
1045: X_Effective_Start_Date => p_effective_date,
1046: X_Effective_End_Date => hr_api.g_eot,
1047: X_Business_Group_Id => p_business_group_id,
1048: X_Legislation_Code => p_legislation_code,
1049: X_Balance_Type_Id => l_balfeeds_tab(i).balance_type_id,
1050: X_Input_Value_Id => l_balfeeds_tab(i).input_value_id,

Line 1551: when hr_api.cannot_find_prog_unit then

1547: ,p_er_age_contribution => p_er_age_contribution -- added for ABP TAR fixes
1548: );
1549: hr_utility.set_location('After Calling User Hook Create_PensionType_b',20);
1550: exception
1551: when hr_api.cannot_find_prog_unit then
1552: hr_utility.set_location('Exception in User Hook Create_PensionType_b',25);
1553: hr_api.cannot_find_prog_unit_error
1554: (p_module_name => 'Create_Pension_Type'
1555: ,p_hook_type => 'BP'

Line 1553: hr_api.cannot_find_prog_unit_error

1549: hr_utility.set_location('After Calling User Hook Create_PensionType_b',20);
1550: exception
1551: when hr_api.cannot_find_prog_unit then
1552: hr_utility.set_location('Exception in User Hook Create_PensionType_b',25);
1553: hr_api.cannot_find_prog_unit_error
1554: (p_module_name => 'Create_Pension_Type'
1555: ,p_hook_type => 'BP'
1556: );
1557: end;

Line 1773: when hr_api.cannot_find_prog_unit then

1769: ,p_api_warning => l_api_warning
1770:
1771: );
1772: exception
1773: when hr_api.cannot_find_prog_unit then
1774: hr_api.cannot_find_prog_unit_error
1775: (p_module_name => 'Create_Pension_Type'
1776: ,p_hook_type => 'AP'
1777: );

Line 1774: hr_api.cannot_find_prog_unit_error

1770:
1771: );
1772: exception
1773: when hr_api.cannot_find_prog_unit then
1774: hr_api.cannot_find_prog_unit_error
1775: (p_module_name => 'Create_Pension_Type'
1776: ,p_hook_type => 'AP'
1777: );
1778: end;

Line 1784: raise hr_api.validate_enabled;

1780: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1781: -- When in validation only mode raise the Validate_Enabled exception
1782: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1783: If p_validate Then
1784: raise hr_api.validate_enabled;
1785: End If;
1786: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1787: -- Set all output arguments
1788: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 1798: When hr_api.validate_enabled Then

1794:
1795: --
1796: hr_utility.set_location(' Leaving:'||l_proc, 70);
1797: Exception
1798: When hr_api.validate_enabled Then
1799: --
1800: -- As the Validate_Enabled exception has been raised
1801: -- we must rollback to the savepoint
1802: --

Line 1940: l_api_warning number := hr_api.g_number;

1936: l_er_annual_salary_threshold number;
1937: l_ee_annual_salary_threshold number;
1938: l_category varchar2(30);
1939: l_schm_exists number;
1940: l_api_warning number := hr_api.g_number;
1941:
1942: CURSOR c_chk_scheme IS
1943: SELECT 1
1944: FROM pay_element_type_extra_info

Line 1957: p_api_warning := hr_api.g_varchar2;

1953: AND p_effective_date BETWEEN effective_start_date
1954: AND effective_end_date;
1955:
1956: Begin
1957: p_api_warning := hr_api.g_varchar2;
1958: hr_utility.set_location('Entering:'|| l_proc, 10);
1959: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1960: -- Issue a savepoint
1961: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 2146: when hr_api.cannot_find_prog_unit then

2142: ,p_er_age_contribution => p_er_age_contribution -- added for ABP TAR fixes
2143: );
2144: hr_utility.set_location('After Calling User Hook Update_Pension_Type_b',20);
2145: exception
2146: when hr_api.cannot_find_prog_unit then
2147: hr_utility.set_location('Exception in User Hook Update_Pension_Type_b',25);
2148: hr_api.cannot_find_prog_unit_error
2149: (p_module_name => 'Update_Pension_Type'
2150: ,p_hook_type => 'BP'

Line 2148: hr_api.cannot_find_prog_unit_error

2144: hr_utility.set_location('After Calling User Hook Update_Pension_Type_b',20);
2145: exception
2146: when hr_api.cannot_find_prog_unit then
2147: hr_utility.set_location('Exception in User Hook Update_Pension_Type_b',25);
2148: hr_api.cannot_find_prog_unit_error
2149: (p_module_name => 'Update_Pension_Type'
2150: ,p_hook_type => 'BP'
2151: );
2152: end;

Line 2366: When hr_api.cannot_find_prog_unit Then

2362: ,p_effective_end_date => l_effective_end_date
2363: );
2364: hr_utility.set_location(' After Calling User Hook : Update_Pension_Type_a',20);
2365: Exception
2366: When hr_api.cannot_find_prog_unit Then
2367: hr_utility.set_location('Exception in User Hook : Update_Pension_Type_a',25);
2368: hr_api.cannot_find_prog_unit_error
2369: (p_module_name => 'Update_Pension_Type'
2370: ,p_hook_type => 'AP'

Line 2368: hr_api.cannot_find_prog_unit_error

2364: hr_utility.set_location(' After Calling User Hook : Update_Pension_Type_a',20);
2365: Exception
2366: When hr_api.cannot_find_prog_unit Then
2367: hr_utility.set_location('Exception in User Hook : Update_Pension_Type_a',25);
2368: hr_api.cannot_find_prog_unit_error
2369: (p_module_name => 'Update_Pension_Type'
2370: ,p_hook_type => 'AP'
2371: );
2372: End;

Line 2377: raise hr_api.validate_enabled;

2373: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2374: -- When in validation only mode raise the Validate_Enabled exception
2375: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2376: If p_validate Then
2377: raise hr_api.validate_enabled;
2378: End If;
2379:
2380: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2381: -- Set all output arguments

Line 2391: When hr_api.validate_enabled Then

2387:
2388: --
2389: hr_utility.set_location(' Leaving:'||l_proc, 70);
2390: Exception
2391: When hr_api.validate_enabled Then
2392: --
2393: -- As the Validate_Enabled exception has been raised
2394: -- we must rollback to the savepoint
2395: --

Line 2784: p_api_warning := hr_api.g_varchar2;

2780: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2781: -- Call Before Process User Hook
2782: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2783: Begin
2784: p_api_warning := hr_api.g_varchar2;
2785: hr_utility.set_location('Before Calling User Hook Delete_Pension_Type_b',20);
2786: PQP_Pension_Types_BK3.Delete_Pension_Type_b
2787: (p_validate => p_validate
2788: ,p_effective_date => p_effective_date

Line 2795: When hr_api.cannot_find_prog_unit Then

2791: ,p_object_version_number => l_object_version_number
2792: );
2793: hr_utility.set_location('After Calling User Hook Delete_Pension_Type_b',20);
2794: Exception
2795: When hr_api.cannot_find_prog_unit Then
2796: hr_utility.set_location('Exception in User Hook Delete_Pension_Type_b',25);
2797: hr_api.cannot_find_prog_unit_error
2798: (p_module_name => 'Delete_Pension_Type'
2799: ,p_hook_type => 'BP'

Line 2797: hr_api.cannot_find_prog_unit_error

2793: hr_utility.set_location('After Calling User Hook Delete_Pension_Type_b',20);
2794: Exception
2795: When hr_api.cannot_find_prog_unit Then
2796: hr_utility.set_location('Exception in User Hook Delete_Pension_Type_b',25);
2797: hr_api.cannot_find_prog_unit_error
2798: (p_module_name => 'Delete_Pension_Type'
2799: ,p_hook_type => 'BP'
2800: );
2801: End;

Line 2854: IF p_datetrack_mode = hr_api.g_zap THEN

2850:
2851: -- Delete balance only if date track mode is ZAP
2852: hr_utility.set_location (l_proc, 36);
2853:
2854: IF p_datetrack_mode = hr_api.g_zap THEN
2855: --only if the PT is not a ABP PT, delete the EE/ER balances
2856: IF l_chk_abp_pt = 0 THEN
2857: delete_ee_er_balances
2858: (p_ee_contribution_bal_type_id => l_ee_contribution_bal_type_id

Line 2883: When hr_api.cannot_find_prog_unit Then

2879: ,p_effective_end_date => l_effective_end_date
2880: );
2881: hr_utility.set_location('After Calling User Hook Delete_Pension_Type_a',20);
2882: Exception
2883: When hr_api.cannot_find_prog_unit Then
2884: hr_utility.set_location('Exception in User Hook Delete_Pension_Type_a',25);
2885: hr_api.cannot_find_prog_unit_error
2886: (p_module_name => 'Delete_Pension_Type'
2887: ,p_hook_type => 'AP'

Line 2885: hr_api.cannot_find_prog_unit_error

2881: hr_utility.set_location('After Calling User Hook Delete_Pension_Type_a',20);
2882: Exception
2883: When hr_api.cannot_find_prog_unit Then
2884: hr_utility.set_location('Exception in User Hook Delete_Pension_Type_a',25);
2885: hr_api.cannot_find_prog_unit_error
2886: (p_module_name => 'Delete_Pension_Type'
2887: ,p_hook_type => 'AP'
2888: );
2889: End;

Line 2895: raise hr_api.validate_enabled;

2891: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2892: -- When in validation only mode raise the Validate_Enabled exception
2893: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2894: If p_validate Then
2895: raise hr_api.validate_enabled;
2896: End If;
2897: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2898: -- Set all output arguments
2899: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 2907: When hr_api.validate_enabled Then

2903: --
2904: hr_utility.set_location(' Leaving:'||l_proc, 70);
2905: -- hr_utility.trace_off;
2906: Exception
2907: When hr_api.validate_enabled Then
2908: --
2909: -- As the Validate_Enabled exception has been raised
2910: -- we must rollback to the savepoint
2911: --