DBA Data[Home] [Help]

APPS.PER_CA_PERSON_ADDRESS_API dependencies on HR_UTILITY

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

62: --
63: l_proc varchar2(72) := g_package||'create_ca_person_address';
64: --
65: begin
66: hr_utility.set_location('Entering:'|| l_proc, 5);
67: --
68: -- Create Person Address details.
69: --
70: hr_person_address_api.create_person_address

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

116: ,p_address_id => p_address_id
117: ,p_object_version_number => p_object_version_number
118: );
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: end create_ca_person_address;
122: --
123: -- ----------------------------------------------------------------------------
124: -- |-----------------------< update_ca_person_address >-----------------------|

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

180: from per_addresses addr
181: where addr.address_id = p_address_id;
182: --
183: begin
184: hr_utility.set_location('Entering:'|| l_proc, 5);
185: --
186: -- Check that the Address identified is CA style.
187: --
188: open csr_add_style;

Line 195: hr_utility.set_location(l_proc, 7);

191: if csr_add_style%notfound then
192: --
193: close csr_add_style;
194: --
195: hr_utility.set_location(l_proc, 7);
196: --
197: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
198: hr_utility.raise_error;
199: --

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

193: close csr_add_style;
194: --
195: hr_utility.set_location(l_proc, 7);
196: --
197: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
198: hr_utility.raise_error;
199: --
200: else
201: --

Line 198: hr_utility.raise_error;

194: --
195: hr_utility.set_location(l_proc, 7);
196: --
197: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
198: hr_utility.raise_error;
199: --
200: else
201: --
202: close csr_add_style;

Line 206: hr_utility.set_location(l_proc, 8);

202: close csr_add_style;
203: --
204: if l_style <> 'CA' then
205: --
206: hr_utility.set_location(l_proc, 8);
207: --
208: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
209: hr_utility.raise_error;
210: --

Line 208: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');

204: if l_style <> 'CA' then
205: --
206: hr_utility.set_location(l_proc, 8);
207: --
208: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
209: hr_utility.raise_error;
210: --
211: end if;
212: end if;

Line 209: hr_utility.raise_error;

205: --
206: hr_utility.set_location(l_proc, 8);
207: --
208: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
209: hr_utility.raise_error;
210: --
211: end if;
212: end if;
213: --

Line 214: hr_utility.set_location(l_proc, 9);

210: --
211: end if;
212: end if;
213: --
214: hr_utility.set_location(l_proc, 9);
215: --
216: -- Update Person Address details.
217: --
218: hr_person_address_api.update_person_address

Line 264: hr_utility.set_location(' Leaving:'||l_proc, 11);

260: ,p_add_information19 => p_add_information19
261: ,p_add_information20 => p_add_information20
262: );
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 11);
265: end update_ca_person_address;
266: --
267: end per_ca_person_address_api;