DBA Data[Home] [Help]

APPS.HR_OTY_BUS dependencies on HR_UTILITY

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

106: from hr_ki_option_types
107: where option_type_key = p_option_type_key;
108: --
109: Begin
110: hr_utility.set_location('Entering:'||l_proc,10);
111: --
112: -- Check value has been passed
113: --
114: hr_api.mandatory_arg_error

Line 120: hr_utility.set_location('Opening cursor:'||l_proc,20);

116: ,p_argument => 'OPTION_TYPE_KEY'
117: ,p_argument_value => p_option_type_key
118: );
119:
120: hr_utility.set_location('Opening cursor:'||l_proc,20);
121: open csr_key;
122: fetch csr_key into l_key;
123: if (csr_key%found)
124: then

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

127: fnd_message.raise_error;
128: end if;
129: close csr_key;
130:
131: hr_utility.set_location(' Leaving:'||l_proc,30);
132: exception
133: when app_exception.application_exception then
134: if hr_multi_message.exception_add
135: (p_associated_column1 => 'HR_KI_OPTION_TYPES.OPTION_TYPE_KEY'

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

133: when app_exception.application_exception then
134: if hr_multi_message.exception_add
135: (p_associated_column1 => 'HR_KI_OPTION_TYPES.OPTION_TYPE_KEY'
136: )then
137: hr_utility.set_location(' Leaving:'||l_proc, 40);
138: raise;
139: end if;
140: hr_utility.set_location(' Leaving:'||l_proc,50);
141: End chk_option_type_key;

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

136: )then
137: hr_utility.set_location(' Leaving:'||l_proc, 40);
138: raise;
139: end if;
140: hr_utility.set_location(' Leaving:'||l_proc,50);
141: End chk_option_type_key;
142:
143:
144:

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

180: l_view_name varchar2(100):='';
181:
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc,10);
185:
186: --
187: -- Check value has been passed
188: --

Line 195: hr_utility.set_location('Display type is not null'||l_proc,20);

191: ,p_argument => 'DISPLAY_TYPE'
192: ,p_argument_value => p_display_type
193: );
194:
195: hr_utility.set_location('Display type is not null'||l_proc,20);
196:
197: IF upper(p_display_type) =l_text THEN
198: --display type is textfield no validations are required
199: null;

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

214: --Please specify display type as either textfield or lookup:
215: fnd_message.raise_error;
216: END IF;
217:
218: hr_utility.set_location(' Leaving:'||l_proc,30);
219: exception
220: when app_exception.application_exception then
221: if hr_multi_message.exception_add
222: (p_associated_column1 => 'HR_KI_OPTION_TYPES.DISPLAY_TYPE'

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

220: when app_exception.application_exception then
221: if hr_multi_message.exception_add
222: (p_associated_column1 => 'HR_KI_OPTION_TYPES.DISPLAY_TYPE'
223: )then
224: hr_utility.set_location(' Leaving:'||l_proc, 40);
225: raise;
226: end if;
227: hr_utility.set_location(' Leaving:'||l_proc,50);
228: End CHK_DISPLAY_TYPE;

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

223: )then
224: hr_utility.set_location(' Leaving:'||l_proc, 40);
225: raise;
226: end if;
227: hr_utility.set_location(' Leaving:'||l_proc,50);
228: End CHK_DISPLAY_TYPE;
229:
230: -- ----------------------------------------------------------------------------
231: -- -------------------------------< CHK_DELETE>--------------------------------

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

277: where option_type_id = p_option_type_id ;
278:
279: --
280: begin
281: hr_utility.set_location('Entering:'|| l_proc, 10);
282: --
283: -- Can always execute the cursor as chk_delete
284: -- will only be called for delete validation
285: -- from within the row handler.

Line 296: hr_utility.set_location('Checking for TL:'|| l_proc, 20);

292: fnd_message.raise_error;
293: end if;
294: close csr_maintenance_option;
295:
296: hr_utility.set_location('Checking for TL:'|| l_proc, 20);
297: open csr_maintenance_tl;
298: fetch csr_maintenance_tl into l_exists_tl;
299: if csr_maintenance_tl%found then
300: close csr_maintenance_tl;

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

302: fnd_message.raise_error;
303: end if;
304: close csr_maintenance_tl;
305:
306: hr_utility.set_location(' Leaving:'|| l_proc, 30);
307: exception
308: when app_exception.application_exception then
309: if hr_multi_message.exception_add
310: (p_associated_column1 => 'HR_KI_OPTION_TYPES.option_type_id'

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

308: when app_exception.application_exception then
309: if hr_multi_message.exception_add
310: (p_associated_column1 => 'HR_KI_OPTION_TYPES.option_type_id'
311: ) then
312: hr_utility.set_location(' Leaving:'|| l_proc, 40);
313: raise;
314: end if;
315: hr_utility.set_location(' Leaving:'|| l_proc, 50);
316: end chk_delete;

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

311: ) then
312: hr_utility.set_location(' Leaving:'|| l_proc, 40);
313: raise;
314: end if;
315: hr_utility.set_location(' Leaving:'|| l_proc, 50);
316: end chk_delete;
317:
318: --
319: -- ----------------------------------------------------------------------------

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

325: --
326: l_proc varchar2(72) := g_package||'insert_validate';
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: -- Call all supporting business operations
332: --
333: --

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

350: );
351:
352: --end call for attribute validations
353:
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355:
356: End insert_validate;
357: --
358: -- ----------------------------------------------------------------------------

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

364: --
365: l_proc varchar2(72) := g_package||'update_validate';
366: --
367: Begin
368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: -- Call all supporting business operations
371: --
372: --

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

385: );
386:
387: --
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: End update_validate;
391: --
392: -- ----------------------------------------------------------------------------
393: -- |---------------------------< delete_validate >----------------------------|

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

398: --
399: l_proc varchar2(72) := g_package||'delete_validate';
400: --
401: Begin
402: hr_utility.set_location('Entering:'||l_proc, 5);
403: --
404: -- Call all supporting business operations
405: --
406: HR_OTY_BUS.chk_delete

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

406: HR_OTY_BUS.chk_delete
407: (p_option_type_id => p_rec.option_type_id
408: );
409:
410: hr_utility.set_location(' Leaving:'||l_proc, 10);
411: End delete_validate;
412: --
413: end hr_oty_bus;