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 862: ,p_effective_end_date => hr_api.g_eot

858: ,p_standard_link_flag => 'N'
859: ,p_business_group_name => l_business_group_name
860: ,p_legislation_code => p_legislation_code
861: ,p_effective_start_date => p_effective_date
862: ,p_effective_end_date => hr_api.g_eot
863: );
864:
865: hr_utility.set_location(' Creating input value EE Contribution', 20);
866: l_ipv_ee_contr := pay_db_pay_setup.create_input_value

Line 875: ,p_effective_end_date => hr_api.g_eot

871: ,p_mandatory_flag => 'N'
872: ,p_display_sequence => 1
873: ,p_business_group_name => l_business_group_name
874: ,p_effective_start_date => p_effective_date
875: ,p_effective_end_date => hr_api.g_eot
876: ,p_legislation_code => p_legislation_code
877: );
878: hr_utility.set_location(' Creating input value ER Contribution', 25);
879: l_ipv_er_contr := pay_db_pay_setup.create_input_value

Line 888: ,p_effective_end_date => hr_api.g_eot

884: ,p_mandatory_flag => 'N'
885: ,p_display_sequence => 2
886: ,p_business_group_name => l_business_group_name
887: ,p_effective_start_date => p_effective_date
888: ,p_effective_end_date => hr_api.g_eot
889: ,p_legislation_code => p_legislation_code
890: );
891:
892: If p_pension_sub_cat IS NOT NULL THEN

Line 977: X_Effective_End_Date => hr_api.g_eot,

973: Pay_Balance_Feeds_f_pkg.Insert_Row(
974: X_Rowid => l_row_id,
975: X_Balance_Feed_Id => l_Balance_Feed_Id,
976: X_Effective_Start_Date => p_effective_date,
977: X_Effective_End_Date => hr_api.g_eot,
978: X_Business_Group_Id => p_business_group_id,
979: X_Legislation_Code => p_legislation_code,
980: X_Balance_Type_Id => l_balfeeds_tab(i).balance_type_id,
981: X_Input_Value_Id => l_balfeeds_tab(i).input_value_id,

Line 1478: when hr_api.cannot_find_prog_unit then

1474: ,p_er_age_contribution => p_er_age_contribution -- added for ABP TAR fixes
1475: );
1476: hr_utility.set_location('After Calling User Hook Create_PensionType_b',20);
1477: exception
1478: when hr_api.cannot_find_prog_unit then
1479: hr_utility.set_location('Exception in User Hook Create_PensionType_b',25);
1480: hr_api.cannot_find_prog_unit_error
1481: (p_module_name => 'Create_Pension_Type'
1482: ,p_hook_type => 'BP'

Line 1480: hr_api.cannot_find_prog_unit_error

1476: hr_utility.set_location('After Calling User Hook Create_PensionType_b',20);
1477: exception
1478: when hr_api.cannot_find_prog_unit then
1479: hr_utility.set_location('Exception in User Hook Create_PensionType_b',25);
1480: hr_api.cannot_find_prog_unit_error
1481: (p_module_name => 'Create_Pension_Type'
1482: ,p_hook_type => 'BP'
1483: );
1484: end;

Line 1700: when hr_api.cannot_find_prog_unit then

1696: ,p_api_warning => l_api_warning
1697:
1698: );
1699: exception
1700: when hr_api.cannot_find_prog_unit then
1701: hr_api.cannot_find_prog_unit_error
1702: (p_module_name => 'Create_Pension_Type'
1703: ,p_hook_type => 'AP'
1704: );

Line 1701: hr_api.cannot_find_prog_unit_error

1697:
1698: );
1699: exception
1700: when hr_api.cannot_find_prog_unit then
1701: hr_api.cannot_find_prog_unit_error
1702: (p_module_name => 'Create_Pension_Type'
1703: ,p_hook_type => 'AP'
1704: );
1705: end;

Line 1711: raise hr_api.validate_enabled;

1707: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1708: -- When in validation only mode raise the Validate_Enabled exception
1709: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1710: If p_validate Then
1711: raise hr_api.validate_enabled;
1712: End If;
1713: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1714: -- Set all output arguments
1715: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 1725: When hr_api.validate_enabled Then

1721:
1722: --
1723: hr_utility.set_location(' Leaving:'||l_proc, 70);
1724: Exception
1725: When hr_api.validate_enabled Then
1726: --
1727: -- As the Validate_Enabled exception has been raised
1728: -- we must rollback to the savepoint
1729: --

Line 1867: l_api_warning number := hr_api.g_number;

1863: l_er_annual_salary_threshold number;
1864: l_ee_annual_salary_threshold number;
1865: l_category varchar2(30);
1866: l_schm_exists number;
1867: l_api_warning number := hr_api.g_number;
1868:
1869: CURSOR c_chk_scheme IS
1870: SELECT 1
1871: FROM pay_element_type_extra_info

Line 1884: p_api_warning := hr_api.g_varchar2;

1880: AND p_effective_date BETWEEN effective_start_date
1881: AND effective_end_date;
1882:
1883: Begin
1884: p_api_warning := hr_api.g_varchar2;
1885: hr_utility.set_location('Entering:'|| l_proc, 10);
1886: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1887: -- Issue a savepoint
1888: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 2073: when hr_api.cannot_find_prog_unit then

2069: ,p_er_age_contribution => p_er_age_contribution -- added for ABP TAR fixes
2070: );
2071: hr_utility.set_location('After Calling User Hook Update_Pension_Type_b',20);
2072: exception
2073: when hr_api.cannot_find_prog_unit then
2074: hr_utility.set_location('Exception in User Hook Update_Pension_Type_b',25);
2075: hr_api.cannot_find_prog_unit_error
2076: (p_module_name => 'Update_Pension_Type'
2077: ,p_hook_type => 'BP'

Line 2075: hr_api.cannot_find_prog_unit_error

2071: hr_utility.set_location('After Calling User Hook Update_Pension_Type_b',20);
2072: exception
2073: when hr_api.cannot_find_prog_unit then
2074: hr_utility.set_location('Exception in User Hook Update_Pension_Type_b',25);
2075: hr_api.cannot_find_prog_unit_error
2076: (p_module_name => 'Update_Pension_Type'
2077: ,p_hook_type => 'BP'
2078: );
2079: end;

Line 2293: When hr_api.cannot_find_prog_unit Then

2289: ,p_effective_end_date => l_effective_end_date
2290: );
2291: hr_utility.set_location(' After Calling User Hook : Update_Pension_Type_a',20);
2292: Exception
2293: When hr_api.cannot_find_prog_unit Then
2294: hr_utility.set_location('Exception in User Hook : Update_Pension_Type_a',25);
2295: hr_api.cannot_find_prog_unit_error
2296: (p_module_name => 'Update_Pension_Type'
2297: ,p_hook_type => 'AP'

Line 2295: hr_api.cannot_find_prog_unit_error

2291: hr_utility.set_location(' After Calling User Hook : Update_Pension_Type_a',20);
2292: Exception
2293: When hr_api.cannot_find_prog_unit Then
2294: hr_utility.set_location('Exception in User Hook : Update_Pension_Type_a',25);
2295: hr_api.cannot_find_prog_unit_error
2296: (p_module_name => 'Update_Pension_Type'
2297: ,p_hook_type => 'AP'
2298: );
2299: End;

Line 2304: raise hr_api.validate_enabled;

2300: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2301: -- When in validation only mode raise the Validate_Enabled exception
2302: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2303: If p_validate Then
2304: raise hr_api.validate_enabled;
2305: End If;
2306:
2307: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2308: -- Set all output arguments

Line 2318: When hr_api.validate_enabled Then

2314:
2315: --
2316: hr_utility.set_location(' Leaving:'||l_proc, 70);
2317: Exception
2318: When hr_api.validate_enabled Then
2319: --
2320: -- As the Validate_Enabled exception has been raised
2321: -- we must rollback to the savepoint
2322: --

Line 2711: p_api_warning := hr_api.g_varchar2;

2707: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2708: -- Call Before Process User Hook
2709: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2710: Begin
2711: p_api_warning := hr_api.g_varchar2;
2712: hr_utility.set_location('Before Calling User Hook Delete_Pension_Type_b',20);
2713: PQP_Pension_Types_BK3.Delete_Pension_Type_b
2714: (p_validate => p_validate
2715: ,p_effective_date => p_effective_date

Line 2722: When hr_api.cannot_find_prog_unit Then

2718: ,p_object_version_number => l_object_version_number
2719: );
2720: hr_utility.set_location('After Calling User Hook Delete_Pension_Type_b',20);
2721: Exception
2722: When hr_api.cannot_find_prog_unit Then
2723: hr_utility.set_location('Exception in User Hook Delete_Pension_Type_b',25);
2724: hr_api.cannot_find_prog_unit_error
2725: (p_module_name => 'Delete_Pension_Type'
2726: ,p_hook_type => 'BP'

Line 2724: hr_api.cannot_find_prog_unit_error

2720: hr_utility.set_location('After Calling User Hook Delete_Pension_Type_b',20);
2721: Exception
2722: When hr_api.cannot_find_prog_unit Then
2723: hr_utility.set_location('Exception in User Hook Delete_Pension_Type_b',25);
2724: hr_api.cannot_find_prog_unit_error
2725: (p_module_name => 'Delete_Pension_Type'
2726: ,p_hook_type => 'BP'
2727: );
2728: End;

Line 2781: IF p_datetrack_mode = hr_api.g_zap THEN

2777:
2778: -- Delete balance only if date track mode is ZAP
2779: hr_utility.set_location (l_proc, 36);
2780:
2781: IF p_datetrack_mode = hr_api.g_zap THEN
2782: --only if the PT is not a ABP PT, delete the EE/ER balances
2783: IF l_chk_abp_pt = 0 THEN
2784: delete_ee_er_balances
2785: (p_ee_contribution_bal_type_id => l_ee_contribution_bal_type_id

Line 2810: When hr_api.cannot_find_prog_unit Then

2806: ,p_effective_end_date => l_effective_end_date
2807: );
2808: hr_utility.set_location('After Calling User Hook Delete_Pension_Type_a',20);
2809: Exception
2810: When hr_api.cannot_find_prog_unit Then
2811: hr_utility.set_location('Exception in User Hook Delete_Pension_Type_a',25);
2812: hr_api.cannot_find_prog_unit_error
2813: (p_module_name => 'Delete_Pension_Type'
2814: ,p_hook_type => 'AP'

Line 2812: hr_api.cannot_find_prog_unit_error

2808: hr_utility.set_location('After Calling User Hook Delete_Pension_Type_a',20);
2809: Exception
2810: When hr_api.cannot_find_prog_unit Then
2811: hr_utility.set_location('Exception in User Hook Delete_Pension_Type_a',25);
2812: hr_api.cannot_find_prog_unit_error
2813: (p_module_name => 'Delete_Pension_Type'
2814: ,p_hook_type => 'AP'
2815: );
2816: End;

Line 2822: raise hr_api.validate_enabled;

2818: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2819: -- When in validation only mode raise the Validate_Enabled exception
2820: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2821: If p_validate Then
2822: raise hr_api.validate_enabled;
2823: End If;
2824: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2825: -- Set all output arguments
2826: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 2834: When hr_api.validate_enabled Then

2830: --
2831: hr_utility.set_location(' Leaving:'||l_proc, 70);
2832: -- hr_utility.trace_off;
2833: Exception
2834: When hr_api.validate_enabled Then
2835: --
2836: -- As the Validate_Enabled exception has been raised
2837: -- we must rollback to the savepoint
2838: --