APPS.PER_RI_CREATE_HIER_ELEMENT dependencies on HR_UTILITY

Line 82: hr_utility.set_location('Entering per_ri_create_hier_element.insert_batch_lines', 10);

78:
79:
80: begin
81:
82: hr_utility.set_location('Entering per_ri_create_hier_element.insert_batch_lines', 10);
83:
84: If p_data_pump_batch_line_id Is Not Null Then
85:
86: --get batch line ids

Line 87: hr_utility.set_location('Correct Errors Scenario', 20);

83:
84: If p_data_pump_batch_line_id Is Not Null Then
85:
86: --get batch line ids
87: hr_utility.set_location('Correct Errors Scenario', 20);
88: Open csr_get_org_str_user_key(p_data_pump_batch_line_id);
89: Fetch csr_get_org_str_user_key Into l_org_structure_user_key;
90: Close csr_get_org_str_user_key;
91:

Line 95: hr_utility.set_location('Normal Scenario', 20);

91:
92:
93: Else
94:
95: hr_utility.set_location('Normal Scenario', 20);
96:
97: l_org_structure_user_key := p_org_str_version_user_key;
98:
99: End If;

Line 112: hr_utility.set_location('Business Group id ' || to_char(l_bg_id), 30);

108: When Others Then
109: l_bg_id := Null;
110: End;
111:
112: hr_utility.set_location('Business Group id ' || to_char(l_bg_id), 30);
113:
114: Open csr_get_org_str_version_id(l_bg_id);
115: Fetch csr_get_org_str_version_id Into l_org_structure_version_id;
116: Close csr_get_org_str_version_id;

Line 118: hr_utility.set_location('Org Structure Version id ' || to_char(l_org_structure_version_id) || ' Org Structure Version User Key = ' ||l_org_structure_user_key , 40);

114: Open csr_get_org_str_version_id(l_bg_id);
115: Fetch csr_get_org_str_version_id Into l_org_structure_version_id;
116: Close csr_get_org_str_version_id;
117:
118: hr_utility.set_location('Org Structure Version id ' || to_char(l_org_structure_version_id) || ' Org Structure Version User Key = ' ||l_org_structure_user_key , 40);
119:
120:
121: Open csr_org_str_user_key(l_org_structure_user_key);
122: Fetch csr_org_str_user_key Into l_temp_id;

Line 124: hr_utility.set_location('Inserted the User Key '||l_org_structure_user_key , 50);

120:
121: Open csr_org_str_user_key(l_org_structure_user_key);
122: Fetch csr_org_str_user_key Into l_temp_id;
123: IF csr_org_str_user_key%NOTFOUND then
124: hr_utility.set_location('Inserted the User Key '||l_org_structure_user_key , 50);
125: hr_pump_utils.add_user_key(l_org_structure_user_key,l_org_structure_version_id);
126: end if;
127: close csr_org_str_user_key;
128: