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.HR_ASSIGNMENT_ATT dependencies on HR_UTILITY

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

392: )
393: return boolean is
394: l_proc varchar2(72) := g_package||'process_row';
395: begin
396: hr_utility.set_location('Entering:'|| l_proc, 5);
397: -- get the parameter values to pass to the API
398:
399: -- if (l_effective_date_row) then
400:

Line 749: hr_utility.set_location(' c_soft_coding_keyflex_id '||c_soft_coding_keyflex_id, 10);

745: ,p_parameter_name => 'p_vendor_id'
746: ,p_new_value => p_vendor_id
747: ,p_current_value => c_vendor_id);
748:
749: hr_utility.set_location(' c_soft_coding_keyflex_id '||c_soft_coding_keyflex_id, 10);
750: if ( c_soft_coding_keyflex_id is not null)
751: then
752: l_asg_rec.SOFT_CODING_KEYFLEX_ID := c_soft_coding_keyflex_id;
753: end if;

Line 754: hr_utility.set_location(' l_asg_rec.SOFT_CODING_KEYFLEX_ID '||l_asg_rec.SOFT_CODING_KEYFLEX_ID, 10);

750: if ( c_soft_coding_keyflex_id is not null)
751: then
752: l_asg_rec.SOFT_CODING_KEYFLEX_ID := c_soft_coding_keyflex_id;
753: end if;
754: hr_utility.set_location(' l_asg_rec.SOFT_CODING_KEYFLEX_ID '||l_asg_rec.SOFT_CODING_KEYFLEX_ID, 10);
755: -- end if;
756:
757: --
758: -- call the API if at least one attribute can be changed

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

931: end if;
932: if l_other_manager_warning and not l_api_other_manager_warning then
933: l_api_other_manager_warning := l_other_manager_warning;
934: end if;
935: hr_utility.set_location(' Leaving:'|| l_proc, 10);
936: -- we need to process the next row so return true
937: return(true);
938: else
939: hr_utility.set_location(' Leaving:'|| l_proc, 15);

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

935: hr_utility.set_location(' Leaving:'|| l_proc, 10);
936: -- we need to process the next row so return true
937: return(true);
938: else
939: hr_utility.set_location(' Leaving:'|| l_proc, 15);
940: -- processing has finished return false
941: return(false);
942: end if;
943: end process_row;

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

942: end if;
943: end process_row;
944: -------------------------------------begin---------------------------------------------
945: begin
946: hr_utility.set_location('Entering:'|| l_proc, 5);
947: --
948: -- issue a savepoint if operating in validation only mode.
949: --
950: if p_validate then

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

1010: -- we can only perform a correction
1011: l_datetrack_update_mode := hr_api.g_correction;
1012: else
1013: -- we cannot perform an update due to a restriction within the APIs
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE', l_proc);
1016: hr_utility.set_message_token('STEP','10');
1017: hr_utility.raise_error;
1018: end if;

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

1011: l_datetrack_update_mode := hr_api.g_correction;
1012: else
1013: -- we cannot perform an update due to a restriction within the APIs
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE', l_proc);
1016: hr_utility.set_message_token('STEP','10');
1017: hr_utility.raise_error;
1018: end if;
1019: -- set lock start date to the effective date

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

1012: else
1013: -- we cannot perform an update due to a restriction within the APIs
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE', l_proc);
1016: hr_utility.set_message_token('STEP','10');
1017: hr_utility.raise_error;
1018: end if;
1019: -- set lock start date to the effective date
1020: l_lck_start_date := l_constant_effective_date;

Line 1017: hr_utility.raise_error;

1013: -- we cannot perform an update due to a restriction within the APIs
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE', l_proc);
1016: hr_utility.set_message_token('STEP','10');
1017: hr_utility.raise_error;
1018: end if;
1019: -- set lock start date to the effective date
1020: l_lck_start_date := l_constant_effective_date;
1021: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then

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

1025: l_datetrack_update_mode := hr_api.g_correction;
1026: else
1027: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1028: -- so raise DT invalid mode error
1029: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1030: hr_utility.raise_error;
1031: end if;
1032: -- lock all assignment rows to ensure integrity. note: this will never fail.
1033: -- if the assignment doesn't exist (i.e. the assignment_id is invalid) then the

Line 1030: hr_utility.raise_error;

1026: else
1027: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1028: -- so raise DT invalid mode error
1029: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1030: hr_utility.raise_error;
1031: end if;
1032: -- lock all assignment rows to ensure integrity. note: this will never fail.
1033: -- if the assignment doesn't exist (i.e. the assignment_id is invalid) then the
1034: -- business process will error with the correct error

Line 1106: hr_utility.trace(' all the attributes have been processed'||

1102: ,c_vendor_id => I.vendor_id
1103: ,c_soft_coding_keyflex_id => I.soft_coding_keyflex_id
1104: ) then
1105: -- all the attributes have been processed, exit the loop
1106: hr_utility.trace(' all the attributes have been processed'||
1107: 'before exit');
1108: exit;
1109: end if;
1110: end loop;

Line 1113: hr_utility.trace(' before if condition'||

1109: end if;
1110: end loop;
1111: -- ------------------------------------------------------------------------
1112: -- process any past row(s)
1113: hr_utility.trace(' before if condition'||
1114: 'p_attribute_update_mode = ATTRIBUTE_CORRECTION');
1115: if p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1116: -- reset the parameter statuses
1117: hr_utility.trace(' after if condition'||

Line 1117: hr_utility.trace(' after if condition'||

1113: hr_utility.trace(' before if condition'||
1114: 'p_attribute_update_mode = ATTRIBUTE_CORRECTION');
1115: if p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1116: -- reset the parameter statuses
1117: hr_utility.trace(' after if condition'||
1118: 'p_attribute_update_mode = ATTRIBUTE_CORRECTION');
1119: hr_dt_attribute_support.reset_parameter_statuses;
1120: for I in csr_asg2 loop
1121: if not process_row

Line 1185: hr_utility.trace(' all the attributes have been processed'||

1181: ,c_vendor_id => I.vendor_id,
1182: c_soft_coding_keyflex_id => I.soft_coding_keyflex_id
1183: ) then
1184: -- all the attributes have been processed, exit the loop
1185: hr_utility.trace(' all the attributes have been processed'||
1186: ' if not process_row -csr_asg2- before exit');
1187: exit;
1188: end if;
1189: end loop;

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

1197: -- set the warning OUT parameters
1198: p_no_managers_warning := l_api_no_managers_warning;
1199: p_other_manager_warning := l_api_other_manager_warning;
1200: --
1201: hr_utility.set_location(' Leaving:'||l_proc, 10);
1202: exception
1203: when hr_api.validate_enabled then
1204: --
1205: -- As the Validate_Enabled exception has been raised

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

1411: )
1412: return boolean is
1413: l_proc varchar2(72) := g_package||'process_row';
1414: begin
1415: hr_utility.set_location('Entering:'|| l_proc, 5);
1416: -- get the parameter values to pass to the API
1417: l_asg_rec.grade_id:= hr_dt_attribute_support.get_parameter_number
1418: (p_effective_date_row => l_effective_date_row
1419: ,p_parameter_name => 'P_GRADE_ID'

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

1560: end if;
1561: if l_tax_district_changed_warning and not l_api_tax_district_changed then
1562: l_api_tax_district_changed:=l_tax_district_changed_warning;
1563: end if;
1564: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1565: -- we need to process the next row so return true
1566: return(true);
1567: else
1568: hr_utility.set_location(' Leaving:'|| l_proc, 15);

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

1564: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1565: -- we need to process the next row so return true
1566: return(true);
1567: else
1568: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1569: -- processing has finished return false
1570: return(false);
1571: end if;
1572: end process_row;

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

1571: end if;
1572: end process_row;
1573: -------------------------------------begin---------------------------------------------
1574: begin
1575: hr_utility.set_location('Entering:'|| l_proc, 5);
1576: --
1577: -- issue a savepoint if operating in validation only mode.
1578: --
1579: if p_validate then

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

1628: -- we can only perform a correction
1629: l_datetrack_update_mode := hr_api.g_correction;
1630: else
1631: -- we cannot perform an update due to a restriction within the APIs
1632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1633: hr_utility.set_message_token('PROCEDURE', l_proc);
1634: hr_utility.set_message_token('STEP','10');
1635: hr_utility.raise_error;
1636: end if;

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

1629: l_datetrack_update_mode := hr_api.g_correction;
1630: else
1631: -- we cannot perform an update due to a restriction within the APIs
1632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1633: hr_utility.set_message_token('PROCEDURE', l_proc);
1634: hr_utility.set_message_token('STEP','10');
1635: hr_utility.raise_error;
1636: end if;
1637: -- set lock start date to the effective date

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

1630: else
1631: -- we cannot perform an update due to a restriction within the APIs
1632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1633: hr_utility.set_message_token('PROCEDURE', l_proc);
1634: hr_utility.set_message_token('STEP','10');
1635: hr_utility.raise_error;
1636: end if;
1637: -- set lock start date to the effective date
1638: l_lck_start_date := l_constant_effective_date;

Line 1635: hr_utility.raise_error;

1631: -- we cannot perform an update due to a restriction within the APIs
1632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1633: hr_utility.set_message_token('PROCEDURE', l_proc);
1634: hr_utility.set_message_token('STEP','10');
1635: hr_utility.raise_error;
1636: end if;
1637: -- set lock start date to the effective date
1638: l_lck_start_date := l_constant_effective_date;
1639: elsif p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then

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

1643: l_datetrack_update_mode := hr_api.g_correction;
1644: else
1645: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1646: -- so raise DT invalid mode error
1647: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1648: hr_utility.raise_error;
1649: end if;
1650: -- lock all assignment rows to ensure integrity. note: this will never fail.
1651: -- if the assignment doesn't exist (i.e. the assignment_id is invalid) then the

Line 1648: hr_utility.raise_error;

1644: else
1645: -- the datetrack mode is not an ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION
1646: -- so raise DT invalid mode error
1647: hr_utility.set_message(801, 'HR_7203_DT_UPD_MODE_INVALID');
1648: hr_utility.raise_error;
1649: end if;
1650: -- lock all assignment rows to ensure integrity. note: this will never fail.
1651: -- if the assignment doesn't exist (i.e. the assignment_id is invalid) then the
1652: -- business process will error with the correct error

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

1707: p_spp_delete_warning := l_api_spp_delete_warning;
1708: p_entries_changed_warning := l_api_entries_changed_warning;
1709: p_tax_district_changed_warning := l_api_tax_district_changed;
1710: --
1711: hr_utility.set_location(' Leaving:'||l_proc, 10);
1712: exception
1713: when hr_api.validate_enabled then
1714: --
1715: -- As the Validate_Enabled exception has been raised