DBA Data[Home] [Help]

APPS.HR_MAINTAIN_PROPOSAL_API dependencies on HR_API

Line 907: when hr_api.cannot_find_prog_unit then

903: p_approved => p_approved,
904: p_element_entry_id => p_element_entry_id
905: );
906: exception
907: when hr_api.cannot_find_prog_unit then
908: hr_api.cannot_find_prog_unit_error
909: (p_module_name => 'INSERT_SALARY_PROPOSAL'
910: ,p_hook_type => 'BP'
911: );

Line 908: hr_api.cannot_find_prog_unit_error

904: p_element_entry_id => p_element_entry_id
905: );
906: exception
907: when hr_api.cannot_find_prog_unit then
908: hr_api.cannot_find_prog_unit_error
909: (p_module_name => 'INSERT_SALARY_PROPOSAL'
910: ,p_hook_type => 'BP'
911: );
912: --

Line 1071: when hr_api.cannot_find_prog_unit then

1067: p_approved_warning => l_approved_warning,
1068: p_payroll_warning => l_payroll_warning
1069: );
1070: exception
1071: when hr_api.cannot_find_prog_unit then
1072: hr_api.cannot_find_prog_unit_error
1073: (p_module_name => 'INSERT_SALARY_PROPOSAL'
1074: ,p_hook_type => 'AP'
1075: );

Line 1072: hr_api.cannot_find_prog_unit_error

1068: p_payroll_warning => l_payroll_warning
1069: );
1070: exception
1071: when hr_api.cannot_find_prog_unit then
1072: hr_api.cannot_find_prog_unit_error
1073: (p_module_name => 'INSERT_SALARY_PROPOSAL'
1074: ,p_hook_type => 'AP'
1075: );
1076: --

Line 1084: Raise HR_Api.Validate_Enabled;

1080: --
1081: -- If we are validating then raise the Validate_Enabled exception
1082: --
1083: If p_validate then
1084: Raise HR_Api.Validate_Enabled;
1085: End If;
1086: --
1087: -- Set OUT parameters
1088: --

Line 1100: When HR_Api.Validate_Enabled Then

1096: --
1097: hr_utility.set_location('Leaving: '||l_proc,50);
1098: --
1099: Exception
1100: When HR_Api.Validate_Enabled Then
1101: --
1102: -- As the Validate_Enabled exception has been raised
1103: -- we must rollback to the savepoint
1104: --

Line 1344: if p_change_date = hr_api.g_date then

1340: per_pyp_shd.lck
1341: (p_pay_proposal_id => p_pay_proposal_id
1342: ,p_object_version_number => p_object_version_number);
1343: --
1344: if p_change_date = hr_api.g_date then
1345: l_change_date:=per_pyp_shd.g_old_rec.change_date;
1346: else
1347: l_change_date := trunc(p_change_date);
1348: end if;

Line 1419: when hr_api.cannot_find_prog_unit then

1415: p_multiple_components => p_multiple_components,
1416: p_approved => p_approved
1417: );
1418: exception
1419: when hr_api.cannot_find_prog_unit then
1420: hr_api.cannot_find_prog_unit_error
1421: (p_module_name => 'UPDATE_SALARY_PROPOSAL'
1422: ,p_hook_type => 'BP'
1423: );

Line 1420: hr_api.cannot_find_prog_unit_error

1416: p_approved => p_approved
1417: );
1418: exception
1419: when hr_api.cannot_find_prog_unit then
1420: hr_api.cannot_find_prog_unit_error
1421: (p_module_name => 'UPDATE_SALARY_PROPOSAL'
1422: ,p_hook_type => 'BP'
1423: );
1424: --

Line 1502: if p_proposed_salary_n = hr_api.g_number then

1498: if get_element%found then
1499: close get_element;
1500: hr_utility.set_location(l_proc,20);
1501: --
1502: if p_proposed_salary_n = hr_api.g_number then
1503: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1504: else
1505: l_proposed_salary_n:=p_proposed_salary_n;
1506: end if;

Line 1520: if p_proposed_salary_n = hr_api.g_number then

1516: select pyp.assignment_id
1517: into l_assignment_id
1518: from per_pay_proposals pyp
1519: where pyp.pay_proposal_id=p_pay_proposal_id;
1520: if p_proposed_salary_n = hr_api.g_number then
1521: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1522: else
1523: l_proposed_salary_n:=p_proposed_salary_n;
1524: end if;

Line 1580: when hr_api.cannot_find_prog_unit then

1576: p_approved_warning => l_approved_warning,
1577: p_payroll_warning => l_payroll_warning
1578: );
1579: exception
1580: when hr_api.cannot_find_prog_unit then
1581: hr_api.cannot_find_prog_unit_error
1582: (p_module_name => 'UPDATE_SALARY_PROPOSAL'
1583: ,p_hook_type => 'AP'
1584: );

Line 1581: hr_api.cannot_find_prog_unit_error

1577: p_payroll_warning => l_payroll_warning
1578: );
1579: exception
1580: when hr_api.cannot_find_prog_unit then
1581: hr_api.cannot_find_prog_unit_error
1582: (p_module_name => 'UPDATE_SALARY_PROPOSAL'
1583: ,p_hook_type => 'AP'
1584: );
1585: --

Line 1593: Raise HR_Api.Validate_Enabled;

1589: --
1590: -- If we are validating then raise the Validate_Enabled exception
1591: --
1592: If p_validate then
1593: Raise HR_Api.Validate_Enabled;
1594: End If;
1595: --
1596: -- Set OUT parameters
1597: --

Line 1607: When HR_Api.Validate_Enabled Then

1603: --
1604: hr_utility.set_location('Leaving: '||l_proc,20);
1605: --
1606: Exception
1607: When HR_Api.Validate_Enabled Then
1608: --
1609: -- As the Validate_Enabled exception has been raised
1610: -- we must rollback to the savepoint
1611: --

Line 1820: if p_change_date = hr_api.g_date then

1816: per_pyp_shd.lck
1817: (p_pay_proposal_id => p_pay_proposal_id
1818: ,p_object_version_number => p_object_version_number);
1819: --
1820: if p_change_date = hr_api.g_date then
1821: l_change_date:=per_pyp_shd.g_old_rec.change_date;
1822: else
1823: l_change_date := trunc(p_change_date);
1824: end if;

Line 1837: when hr_api.cannot_find_prog_unit then

1833: p_proposed_salary_n => p_proposed_salary_n,
1834: p_object_version_number => p_object_version_number
1835: );
1836: exception
1837: when hr_api.cannot_find_prog_unit then
1838: hr_api.cannot_find_prog_unit_error
1839: (p_module_name => 'APPROVE_SALARY_PROPOSAL'
1840: ,p_hook_type => 'BP'
1841: );

Line 1838: hr_api.cannot_find_prog_unit_error

1834: p_object_version_number => p_object_version_number
1835: );
1836: exception
1837: when hr_api.cannot_find_prog_unit then
1838: hr_api.cannot_find_prog_unit_error
1839: (p_module_name => 'APPROVE_SALARY_PROPOSAL'
1840: ,p_hook_type => 'BP'
1841: );
1842: --

Line 1889: if p_proposed_salary_n = hr_api.g_number then

1885: fetch get_element into l_element_entry_id; -- ,l_assignment_id;
1886: close get_element;
1887: --
1888: --
1889: if p_proposed_salary_n = hr_api.g_number then
1890: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1891: else
1892: l_proposed_salary_n:=p_proposed_salary_n;
1893: end if;

Line 1923: when hr_api.cannot_find_prog_unit then

1919: p_payroll_warning => l_payroll_warning,
1920: p_error_text => l_error_text
1921: );
1922: exception
1923: when hr_api.cannot_find_prog_unit then
1924: hr_api.cannot_find_prog_unit_error
1925: (p_module_name => 'APPROVE_SALARY_PROPOSAL'
1926: ,p_hook_type => 'AP'
1927: );

Line 1924: hr_api.cannot_find_prog_unit_error

1920: p_error_text => l_error_text
1921: );
1922: exception
1923: when hr_api.cannot_find_prog_unit then
1924: hr_api.cannot_find_prog_unit_error
1925: (p_module_name => 'APPROVE_SALARY_PROPOSAL'
1926: ,p_hook_type => 'AP'
1927: );
1928: --

Line 1935: Raise HR_Api.Validate_Enabled;

1931: end;
1932: --
1933: -- If we are validating then raise the Validate_Enabled exception
1934: If p_validate then
1935: Raise HR_Api.Validate_Enabled;
1936: End If;
1937: --
1938: --
1939: -- Set OUT parameters

Line 1951: When HR_Api.Validate_Enabled Then

1947: --
1948: hr_utility.set_location('Leaving: '||l_proc,15);
1949: --
1950: Exception
1951: When HR_Api.Validate_Enabled Then
1952: --
1953: -- As the Validate_Enabled exception has been raised
1954: -- we must rollback to the savepoint
1955: --

Line 2065: when hr_api.cannot_find_prog_unit then

2061: ,p_business_group_id => p_business_group_id
2062: ,p_object_version_number => p_object_version_number
2063: );
2064: exception
2065: when hr_api.cannot_find_prog_unit then
2066: hr_api.cannot_find_prog_unit_error
2067: (p_module_name => 'DELETE_SALARY_PROPOSAL'
2068: ,p_hook_type => 'BP'
2069: );

Line 2066: hr_api.cannot_find_prog_unit_error

2062: ,p_object_version_number => p_object_version_number
2063: );
2064: exception
2065: when hr_api.cannot_find_prog_unit then
2066: hr_api.cannot_find_prog_unit_error
2067: (p_module_name => 'DELETE_SALARY_PROPOSAL'
2068: ,p_hook_type => 'BP'
2069: );
2070: --

Line 2194: when hr_api.cannot_find_prog_unit then

2190: ,p_object_version_number => p_object_version_number
2191: ,p_salary_warning => l_salary_warning
2192: );
2193: exception
2194: when hr_api.cannot_find_prog_unit then
2195: hr_api.cannot_find_prog_unit_error
2196: (p_module_name => 'DELETE_SALARY_PROPOSAL'
2197: ,p_hook_type => 'AP'
2198: );

Line 2195: hr_api.cannot_find_prog_unit_error

2191: ,p_salary_warning => l_salary_warning
2192: );
2193: exception
2194: when hr_api.cannot_find_prog_unit then
2195: hr_api.cannot_find_prog_unit_error
2196: (p_module_name => 'DELETE_SALARY_PROPOSAL'
2197: ,p_hook_type => 'AP'
2198: );
2199: --

Line 2213: Raise HR_Api.Validate_Enabled;

2209: --
2210: -- If we are validating then raise the Validate_Enabled exception
2211: --
2212: If p_validate then
2213: Raise HR_Api.Validate_Enabled;
2214: End If;
2215: --
2216: -- Set OUT parameters
2217: --

Line 2223: When HR_Api.Validate_Enabled Then

2219: --
2220: hr_utility.set_location('Leaving: '||l_proc,40);
2221: --
2222: Exception
2223: When HR_Api.Validate_Enabled Then
2224: --
2225: -- As the Validate_Enabled exception has been raised
2226: -- we must rollback to the savepoint
2227: --

Line 2336: when hr_api.cannot_find_prog_unit then

2332: p_attribute20 => p_attribute20,
2333: p_validation_strength => p_validation_strength
2334: );
2335: exception
2336: when hr_api.cannot_find_prog_unit then
2337: hr_api.cannot_find_prog_unit_error
2338: (p_module_name => 'INSERT_PROPOSAL_COMPONENTS'
2339: ,p_hook_type => 'BP'
2340: );

Line 2337: hr_api.cannot_find_prog_unit_error

2333: p_validation_strength => p_validation_strength
2334: );
2335: exception
2336: when hr_api.cannot_find_prog_unit then
2337: hr_api.cannot_find_prog_unit_error
2338: (p_module_name => 'INSERT_PROPOSAL_COMPONENTS'
2339: ,p_hook_type => 'BP'
2340: );
2341: --

Line 2420: when hr_api.cannot_find_prog_unit then

2416: p_validation_strength => p_validation_strength,
2417: p_object_version_number => l_object_version_number
2418: );
2419: exception
2420: when hr_api.cannot_find_prog_unit then
2421: hr_api.cannot_find_prog_unit_error
2422: (p_module_name => 'INSERT_PROPOSAL_COMPONENTS'
2423: ,p_hook_type => 'AP'
2424: );

Line 2421: hr_api.cannot_find_prog_unit_error

2417: p_object_version_number => l_object_version_number
2418: );
2419: exception
2420: when hr_api.cannot_find_prog_unit then
2421: hr_api.cannot_find_prog_unit_error
2422: (p_module_name => 'INSERT_PROPOSAL_COMPONENTS'
2423: ,p_hook_type => 'AP'
2424: );
2425: --

Line 2433: Raise HR_Api.Validate_Enabled;

2429: --
2430: -- If we are validating then raise the Validate_Enabled exception
2431: --
2432: If p_validate then
2433: Raise HR_Api.Validate_Enabled;
2434: End If;
2435: --
2436: -- Set OUT parameters
2437: --

Line 2444: When HR_Api.Validate_Enabled Then

2440: --
2441: hr_utility.set_location('Leaving: '||l_proc,10);
2442: --
2443: Exception
2444: When HR_Api.Validate_Enabled Then
2445: --
2446: -- As the Validate_Enabled exception has been raised
2447: -- we must rollback to the savepoint
2448: --

Line 2559: when hr_api.cannot_find_prog_unit then

2555: p_validation_strength => p_validation_strength,
2556: p_object_version_number => p_object_version_number
2557: );
2558: exception
2559: when hr_api.cannot_find_prog_unit then
2560: hr_api.cannot_find_prog_unit_error
2561: (p_module_name => 'UPDATE_PROPOSAL_COMPONENTS'
2562: ,p_hook_type => 'BP'
2563: );

Line 2560: hr_api.cannot_find_prog_unit_error

2556: p_object_version_number => p_object_version_number
2557: );
2558: exception
2559: when hr_api.cannot_find_prog_unit then
2560: hr_api.cannot_find_prog_unit_error
2561: (p_module_name => 'UPDATE_PROPOSAL_COMPONENTS'
2562: ,p_hook_type => 'BP'
2563: );
2564: --

Line 2639: when hr_api.cannot_find_prog_unit then

2635: p_validation_strength => p_validation_strength,
2636: p_object_version_number => l_object_version_number
2637: );
2638: exception
2639: when hr_api.cannot_find_prog_unit then
2640: hr_api.cannot_find_prog_unit_error
2641: (p_module_name => 'UPDATE_PROPOSAL_COMPONENTS'
2642: ,p_hook_type => 'AP'
2643: );

Line 2640: hr_api.cannot_find_prog_unit_error

2636: p_object_version_number => l_object_version_number
2637: );
2638: exception
2639: when hr_api.cannot_find_prog_unit then
2640: hr_api.cannot_find_prog_unit_error
2641: (p_module_name => 'UPDATE_PROPOSAL_COMPONENTS'
2642: ,p_hook_type => 'AP'
2643: );
2644: --

Line 2652: Raise HR_Api.Validate_Enabled;

2648: --
2649: -- If we are validating then raise the Validate_Enabled exception
2650: --
2651: If p_validate then
2652: Raise HR_Api.Validate_Enabled;
2653: End If;
2654: --
2655: -- Set OUT parameters
2656: --

Line 2662: When HR_Api.Validate_Enabled Then

2658: --
2659: hr_utility.set_location('Leaving: '||l_proc,20);
2660: --
2661: Exception
2662: When HR_Api.Validate_Enabled Then
2663: --
2664: -- As the Validate_Enabled exception has been raised
2665: -- we must rollback to the savepoint
2666: --

Line 2712: when hr_api.cannot_find_prog_unit then

2708: p_validation_strength => p_validation_strength,
2709: p_object_version_number => p_object_version_number
2710: );
2711: exception
2712: when hr_api.cannot_find_prog_unit then
2713: hr_api.cannot_find_prog_unit_error
2714: (p_module_name => 'DELETE_PROPOSAL_COMPONENTS'
2715: ,p_hook_type => 'BP'
2716: );

Line 2713: hr_api.cannot_find_prog_unit_error

2709: p_object_version_number => p_object_version_number
2710: );
2711: exception
2712: when hr_api.cannot_find_prog_unit then
2713: hr_api.cannot_find_prog_unit_error
2714: (p_module_name => 'DELETE_PROPOSAL_COMPONENTS'
2715: ,p_hook_type => 'BP'
2716: );
2717: --

Line 2740: when hr_api.cannot_find_prog_unit then

2736: p_validation_strength => p_validation_strength,
2737: p_object_version_number => p_object_version_number
2738: );
2739: exception
2740: when hr_api.cannot_find_prog_unit then
2741: hr_api.cannot_find_prog_unit_error
2742: (p_module_name => 'DELETE_PROPOSAL_COMPONENTS'
2743: ,p_hook_type => 'AP'
2744: );

Line 2741: hr_api.cannot_find_prog_unit_error

2737: p_object_version_number => p_object_version_number
2738: );
2739: exception
2740: when hr_api.cannot_find_prog_unit then
2741: hr_api.cannot_find_prog_unit_error
2742: (p_module_name => 'DELETE_PROPOSAL_COMPONENTS'
2743: ,p_hook_type => 'AP'
2744: );
2745: --

Line 2753: Raise HR_Api.Validate_Enabled;

2749: --
2750: -- If we are validating then raise the Validate_Enabled exception
2751: --
2752: If p_validate then
2753: Raise HR_Api.Validate_Enabled;
2754: End If;
2755: --
2756: hr_utility.set_location('Leaving: '||l_proc,10);
2757: --

Line 2759: When HR_Api.Validate_Enabled Then

2755: --
2756: hr_utility.set_location('Leaving: '||l_proc,10);
2757: --
2758: Exception
2759: When HR_Api.Validate_Enabled Then
2760: --
2761: -- As the Validate_Enabled exception has been raised
2762: -- we must rollback to the savepoint
2763: --

Line 2867: if (l_api_updating and l_date_to = hr_api.g_date) then

2863: (p_pay_proposal_id => p_pay_proposal_id
2864: ,p_object_version_number => p_object_version_number);
2865: hr_utility.set_location(l_proc, 20);
2866:
2867: if (l_api_updating and l_date_to = hr_api.g_date) then
2868: l_date_to := hr_general.end_of_time;
2869: end if;
2870:
2871: --

Line 3062: raise hr_api.validate_enabled;

3058: --
3059: end if;
3060: --
3061: if p_validate then
3062: raise hr_api.validate_enabled;
3063: end if;
3064: --
3065: hr_utility.set_location(l_proc, 110);
3066: --

Line 3077: when hr_api.validate_enabled then

3073: --
3074: hr_utility.set_location('Leaving:'||l_proc, 120);
3075: --
3076: exception
3077: when hr_api.validate_enabled then
3078: rollback to cre_or_upd_salary_proposal;
3079: p_pay_proposal_id := null;
3080: p_object_version_number := null;
3081: p_inv_next_sal_date_warning := l_inv_next_sal_date_warning;