DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_ATT dependencies on HR_UTILITY

Line 385: hr_utility.set_location('Entering:'|| l_proc, 5);

381: )
382: return boolean is
383: l_proc varchar2(72) := g_package||'process_row';
384: begin
385: hr_utility.set_location('Entering:'|| l_proc, 5);
386: -- get the parameter values to pass to the API
387:
388: -- if (l_effective_date_row) then
389:

Line 918: hr_utility.set_location(' Leaving:'|| l_proc, 10);

914: end if;
915: if l_other_manager_warning and not l_api_other_manager_warning then
916: l_api_other_manager_warning := l_other_manager_warning;
917: end if;
918: hr_utility.set_location(' Leaving:'|| l_proc, 10);
919: -- we need to process the next row so return true
920: return(true);
921: else
922: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 922: hr_utility.set_location(' Leaving:'|| l_proc, 15);

918: hr_utility.set_location(' Leaving:'|| l_proc, 10);
919: -- we need to process the next row so return true
920: return(true);
921: else
922: hr_utility.set_location(' Leaving:'|| l_proc, 15);
923: -- processing has finished return false
924: return(false);
925: end if;
926: end process_row;

Line 929: hr_utility.set_location('Entering:'|| l_proc, 5);

925: end if;
926: end process_row;
927: -------------------------------------begin---------------------------------------------
928: begin
929: hr_utility.set_location('Entering:'|| l_proc, 5);
930: --
931: -- issue a savepoint if operating in validation only mode.
932: --
933: if p_validate then

Line 986: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

982: -- we can only perform a correction
983: l_datetrack_update_mode := hr_api.g_correction;
984: else
985: -- we cannot perform an update due to a restriction within the APIs
986: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
987: hr_utility.set_message_token('PROCEDURE', l_proc);
988: hr_utility.set_message_token('STEP','10');
989: hr_utility.raise_error;
990: end if;

Line 987: hr_utility.set_message_token('PROCEDURE', l_proc);

983: l_datetrack_update_mode := hr_api.g_correction;
984: else
985: -- we cannot perform an update due to a restriction within the APIs
986: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
987: hr_utility.set_message_token('PROCEDURE', l_proc);
988: hr_utility.set_message_token('STEP','10');
989: hr_utility.raise_error;
990: end if;
991: -- set lock start date to the effective date

Line 988: hr_utility.set_message_token('STEP','10');

984: else
985: -- we cannot perform an update due to a restriction within the APIs
986: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
987: hr_utility.set_message_token('PROCEDURE', l_proc);
988: hr_utility.set_message_token('STEP','10');
989: hr_utility.raise_error;
990: end if;
991: -- set lock start date to the effective date
992: l_lck_start_date := l_constant_effective_date;

Line 989: hr_utility.raise_error;

985: -- we cannot perform an update due to a restriction within the APIs
986: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
987: hr_utility.set_message_token('PROCEDURE', l_proc);
988: hr_utility.set_message_token('STEP','10');
989: hr_utility.raise_error;
990: end if;
991: -- set lock start date to the effective date
992: l_lck_start_date := l_constant_effective_date;
993: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then

Line 1001: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');

997: l_datetrack_update_mode := hr_api.g_correction;
998: else
999: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1000: -- so raise DT invalid mode error
1001: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1002: hr_utility.raise_error;
1003: end if;
1004: -- lock all assignment rows to ensure integrity. note: this will never fail.
1005: -- if the assignment doesn't exist (i.e. the assignment_id is invalid) then the

Line 1002: hr_utility.raise_error;

998: else
999: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1000: -- so raise DT invalid mode error
1001: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1002: hr_utility.raise_error;
1003: end if;
1004: -- lock all assignment rows to ensure integrity. note: this will never fail.
1005: -- if the assignment doesn't exist (i.e. the assignment_id is invalid) then the
1006: -- business process will error with the correct error

Line 1163: hr_utility.set_location(' Leaving:'||l_proc, 10);

1159: -- set the warning OUT parameters
1160: p_no_managers_warning := l_api_no_managers_warning;
1161: p_other_manager_warning := l_api_other_manager_warning;
1162: --
1163: hr_utility.set_location(' Leaving:'||l_proc, 10);
1164: exception
1165: when hr_api.validate_enabled then
1166: --
1167: -- As the Validate_Enabled exception has been raised

Line 1377: hr_utility.set_location('Entering:'|| l_proc, 5);

1373: )
1374: return boolean is
1375: l_proc varchar2(72) := g_package||'process_row';
1376: begin
1377: hr_utility.set_location('Entering:'|| l_proc, 5);
1378: -- get the parameter values to pass to the API
1379: l_asg_rec.grade_id:= hr_dt_attribute_support.get_parameter_number
1380: (p_effective_date_row => l_effective_date_row
1381: ,p_parameter_name => 'P_GRADE_ID'

Line 1526: hr_utility.set_location(' Leaving:'|| l_proc, 10);

1522: end if;
1523: if l_tax_district_changed_warning and not l_api_tax_district_changed then
1524: l_api_tax_district_changed:=l_tax_district_changed_warning;
1525: end if;
1526: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1527: -- we need to process the next row so return true
1528: return(true);
1529: else
1530: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 1530: hr_utility.set_location(' Leaving:'|| l_proc, 15);

1526: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1527: -- we need to process the next row so return true
1528: return(true);
1529: else
1530: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1531: -- processing has finished return false
1532: return(false);
1533: end if;
1534: end process_row;

Line 1537: hr_utility.set_location('Entering:'|| l_proc, 5);

1533: end if;
1534: end process_row;
1535: -------------------------------------begin---------------------------------------------
1536: begin
1537: hr_utility.set_location('Entering:'|| l_proc, 5);
1538: --
1539: -- issue a savepoint if operating in validation only mode.
1540: --
1541: if p_validate then

Line 1594: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1590: -- we can only perform a correction
1591: l_datetrack_update_mode := hr_api.g_correction;
1592: else
1593: -- we cannot perform an update due to a restriction within the APIs
1594: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1595: hr_utility.set_message_token('PROCEDURE', l_proc);
1596: hr_utility.set_message_token('STEP','10');
1597: hr_utility.raise_error;
1598: end if;

Line 1595: hr_utility.set_message_token('PROCEDURE', l_proc);

1591: l_datetrack_update_mode := hr_api.g_correction;
1592: else
1593: -- we cannot perform an update due to a restriction within the APIs
1594: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1595: hr_utility.set_message_token('PROCEDURE', l_proc);
1596: hr_utility.set_message_token('STEP','10');
1597: hr_utility.raise_error;
1598: end if;
1599: -- set lock start date to the effective date

Line 1596: hr_utility.set_message_token('STEP','10');

1592: else
1593: -- we cannot perform an update due to a restriction within the APIs
1594: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1595: hr_utility.set_message_token('PROCEDURE', l_proc);
1596: hr_utility.set_message_token('STEP','10');
1597: hr_utility.raise_error;
1598: end if;
1599: -- set lock start date to the effective date
1600: l_lck_start_date := l_constant_effective_date;

Line 1597: hr_utility.raise_error;

1593: -- we cannot perform an update due to a restriction within the APIs
1594: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1595: hr_utility.set_message_token('PROCEDURE', l_proc);
1596: hr_utility.set_message_token('STEP','10');
1597: hr_utility.raise_error;
1598: end if;
1599: -- set lock start date to the effective date
1600: l_lck_start_date := l_constant_effective_date;
1601: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then

Line 1609: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');

1605: l_datetrack_update_mode := hr_api.g_correction;
1606: else
1607: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1608: -- so raise DT invalid mode error
1609: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1610: hr_utility.raise_error;
1611: end if;
1612: -- lock all assignment rows to ensure integrity. note: this will never fail.
1613: -- if the assignment doesn't exist (i.e. the assignment_id is invalid) then the

Line 1610: hr_utility.raise_error;

1606: else
1607: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1608: -- so raise DT invalid mode error
1609: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1610: hr_utility.raise_error;
1611: end if;
1612: -- lock all assignment rows to ensure integrity. note: this will never fail.
1613: -- if the assignment doesn't exist (i.e. the assignment_id is invalid) then the
1614: -- business process will error with the correct error

Line 1673: hr_utility.set_location(' Leaving:'||l_proc, 10);

1669: p_spp_delete_warning := l_api_spp_delete_warning;
1670: p_entries_changed_warning := l_api_entries_changed_warning;
1671: p_tax_district_changed_warning := l_api_tax_district_changed;
1672: --
1673: hr_utility.set_location(' Leaving:'||l_proc, 10);
1674: exception
1675: when hr_api.validate_enabled then
1676: --
1677: -- As the Validate_Enabled exception has been raised