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 1503: if p_proposed_salary_n = hr_api.g_number then

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

Line 1521: if p_proposed_salary_n = hr_api.g_number then

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

Line 1581: when hr_api.cannot_find_prog_unit then

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

Line 1582: hr_api.cannot_find_prog_unit_error

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

Line 1594: Raise HR_Api.Validate_Enabled;

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

Line 1608: When HR_Api.Validate_Enabled Then

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

Line 1821: if p_change_date = hr_api.g_date then

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

Line 1838: when hr_api.cannot_find_prog_unit then

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

Line 1839: hr_api.cannot_find_prog_unit_error

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

Line 1890: if p_proposed_salary_n = hr_api.g_number then

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

Line 1924: when hr_api.cannot_find_prog_unit then

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

Line 1925: hr_api.cannot_find_prog_unit_error

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

Line 1936: Raise HR_Api.Validate_Enabled;

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

Line 1952: When HR_Api.Validate_Enabled Then

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

Line 2067: when hr_api.cannot_find_prog_unit then

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

Line 2068: hr_api.cannot_find_prog_unit_error

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

Line 2196: when hr_api.cannot_find_prog_unit then

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

Line 2197: hr_api.cannot_find_prog_unit_error

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

Line 2215: Raise HR_Api.Validate_Enabled;

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

Line 2225: When HR_Api.Validate_Enabled Then

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

Line 2338: when hr_api.cannot_find_prog_unit then

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

Line 2339: hr_api.cannot_find_prog_unit_error

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

Line 2422: when hr_api.cannot_find_prog_unit then

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

Line 2423: hr_api.cannot_find_prog_unit_error

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

Line 2435: Raise HR_Api.Validate_Enabled;

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

Line 2446: When HR_Api.Validate_Enabled Then

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

Line 2561: when hr_api.cannot_find_prog_unit then

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

Line 2562: hr_api.cannot_find_prog_unit_error

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

Line 2641: when hr_api.cannot_find_prog_unit then

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

Line 2642: hr_api.cannot_find_prog_unit_error

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

Line 2654: Raise HR_Api.Validate_Enabled;

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

Line 2664: When HR_Api.Validate_Enabled Then

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

Line 2714: when hr_api.cannot_find_prog_unit then

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

Line 2715: hr_api.cannot_find_prog_unit_error

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

Line 2742: when hr_api.cannot_find_prog_unit then

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

Line 2743: hr_api.cannot_find_prog_unit_error

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

Line 2755: Raise HR_Api.Validate_Enabled;

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

Line 2761: When HR_Api.Validate_Enabled Then

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

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

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

Line 3064: raise hr_api.validate_enabled;

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

Line 3079: when hr_api.validate_enabled then

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