DBA Data[Home] [Help]

APPS.HR_OTT_BUS dependencies on HR_UTILITY

Line 114: hr_utility.set_location('Entering:'||l_proc,10);

110:
111: l_check varchar2(1);
112:
113: Begin
114: hr_utility.set_location('Entering:'||l_proc,10);
115: --
116: -- Check value has been passed
117: --
118: hr_api.mandatory_arg_error

Line 123: hr_utility.set_location('Checking:'||l_proc,20);

119: (p_api_name => l_proc
120: ,p_argument => 'OPTION_NAME'
121: ,p_argument_value => p_option_name
122: );
123: hr_utility.set_location('Checking:'||l_proc,20);
124:
125: -- check if the record already exists
126:
127: open csr_name;

Line 129: hr_utility.set_location('After fetching:'||l_proc,30);

125: -- check if the record already exists
126:
127: open csr_name;
128: fetch csr_name into l_name;
129: hr_utility.set_location('After fetching:'||l_proc,30);
130: if (csr_name%found)
131: then
132: close csr_name;
133: fnd_message.set_name('PER','PER_449951_OTT_NAME_DUPLICATE');

Line 138: hr_utility.set_location(' Leaving:'||l_proc,40);

134: fnd_message.raise_error;
135: end if;
136: close csr_name;
137:
138: hr_utility.set_location(' Leaving:'||l_proc,40);
139:
140: exception
141: when app_exception.application_exception then
142: if hr_multi_message.exception_add

Line 145: hr_utility.set_location(' Leaving:'||l_proc, 50);

141: when app_exception.application_exception then
142: if hr_multi_message.exception_add
143: (p_associated_column1 => 'HR_KI_OPTION_TYPES_TL.OPTION_NAME'
144: )then
145: hr_utility.set_location(' Leaving:'||l_proc, 50);
146: raise;
147: end if;
148: hr_utility.set_location(' Leaving:'||l_proc,60);
149:

Line 148: hr_utility.set_location(' Leaving:'||l_proc,60);

144: )then
145: hr_utility.set_location(' Leaving:'||l_proc, 50);
146: raise;
147: end if;
148: hr_utility.set_location(' Leaving:'||l_proc,60);
149:
150:
151: End chk_option_name;
152: --

Line 201: hr_utility.set_location(' Entering:' || l_proc,10);

197:
198: Begin
199:
200:
201: hr_utility.set_location(' Entering:' || l_proc,10);
202:
203: open csr_id;
204: fetch csr_id into l_name;
205:

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

209: end if;
210:
211: close csr_id;
212:
213: hr_utility.set_location(' Leaving:' || l_proc,20);
214:
215: Exception
216: when app_exception.application_exception then
217: IF hr_multi_message.exception_add

Line 220: hr_utility.set_location(' Leaving:'|| l_proc,30);

216: when app_exception.application_exception then
217: IF hr_multi_message.exception_add
218: (p_associated_column1 => 'HR_KI_OPTION_TYPES_TL.OPTION_TYPE_ID'
219: ) THEN
220: hr_utility.set_location(' Leaving:'|| l_proc,30);
221: raise;
222: END IF;
223:
224: hr_utility.set_location(' Leaving:'|| l_proc,40);

Line 224: hr_utility.set_location(' Leaving:'|| l_proc,40);

220: hr_utility.set_location(' Leaving:'|| l_proc,30);
221: raise;
222: END IF;
223:
224: hr_utility.set_location(' Leaving:'|| l_proc,40);
225: --
226: End chk_option_type_id;
227:
228:

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

237: --
238: l_proc varchar2(72) := g_package||'insert_validate';
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- Call all supporting business operations
244: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
245: -- "-- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."

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

262: ,p_language => p_rec.language
263: );
264:
265:
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: End insert_validate;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |---------------------------< update_validate >----------------------------|

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

276: --
277: l_proc varchar2(72) := g_package||'update_validate';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- Call all supporting business operations
283: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
284: -- "-- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."

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

297: );
298:
299: --
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 10);
302: End update_validate;
303: --
304: -- ----------------------------------------------------------------------------
305: -- |---------------------------< delete_validate >----------------------------|

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

310: --
311: l_proc varchar2(72) := g_package||'delete_validate';
312: --
313: Begin
314: hr_utility.set_location('Entering:'||l_proc, 5);
315: --
316: -- Call all supporting business operations
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

314: hr_utility.set_location('Entering:'||l_proc, 5);
315: --
316: -- Call all supporting business operations
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: End delete_validate;
320: --
321: end hr_ott_bus;