DBA Data[Home] [Help]

APPS.HR_HK_PERSON_ADDRESS_API dependencies on HR_UTILITY

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

56: --
57: l_proc VARCHAR2(72) := g_package||'create_hk_person_address';
58: --
59: BEGIN
60: hr_utility.set_location('Entering:'|| l_proc, 5);
61: --
62: -- Create Person Address details.
63: --
64: hr_person_address_api.create_person_address

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

106: ,p_address_id => p_address_id
107: ,p_object_version_number => p_object_version_number
108: );
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: END create_hk_person_address;
112: -- ----------------------------------------------------------------------------
113: -- |-----------------------< update_hk_person_address >-----------------------|
114: -- ----------------------------------------------------------------------------

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

165: FROM per_addresses
166: WHERE address_id = p_address_id;
167: --
168: BEGIN
169: hr_utility.set_location('Entering:'|| l_proc, 5);
170: --
171: -- Check that the address is HK style.
172: --
173: OPEN csr_add_style;

Line 179: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

175: INTO l_style;
176: IF csr_add_style%notfound THEN
177: CLOSE csr_add_style;
178: --
179: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
180: hr_utility.raise_error;
181: ELSE
182: hr_utility.set_location(l_proc, 10);
183: --

Line 180: hr_utility.raise_error;

176: IF csr_add_style%notfound THEN
177: CLOSE csr_add_style;
178: --
179: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
180: hr_utility.raise_error;
181: ELSE
182: hr_utility.set_location(l_proc, 10);
183: --
184: CLOSE csr_add_style;

Line 182: hr_utility.set_location(l_proc, 10);

178: --
179: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
180: hr_utility.raise_error;
181: ELSE
182: hr_utility.set_location(l_proc, 10);
183: --
184: CLOSE csr_add_style;
185: --
186: IF l_style <> 'HK' THEN

Line 187: hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');

183: --
184: CLOSE csr_add_style;
185: --
186: IF l_style <> 'HK' THEN
187: hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');
188: hr_utility.raise_error;
189: END IF;
190: END IF;
191: --

Line 188: hr_utility.raise_error;

184: CLOSE csr_add_style;
185: --
186: IF l_style <> 'HK' THEN
187: hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');
188: hr_utility.raise_error;
189: END IF;
190: END IF;
191: --
192: hr_utility.set_location(l_proc, 15);

Line 192: hr_utility.set_location(l_proc, 15);

188: hr_utility.raise_error;
189: END IF;
190: END IF;
191: --
192: hr_utility.set_location(l_proc, 15);
193: --
194: -- Update Person Address details.
195: --
196: hr_person_address_api.update_person_address

Line 238: hr_utility.set_location(' Leaving:'||l_proc, 20);

234: ,p_addr_attribute19 => p_addr_attribute19
235: ,p_addr_attribute20 => p_addr_attribute20
236: );
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 20);
239: END update_hk_person_address;
240:
241: END hr_hk_person_address_api;