DBA Data[Home] [Help]

APPS.HR_ITF_BUS dependencies on HR_KI_USER_INTERFACES

Line 137: (p_associated_column1 => 'HR_KI_USER_INTERFACES.TYPE'

133:
134: Exception
135: when app_exception.application_exception then
136: IF hr_multi_message.exception_add
137: (p_associated_column1 => 'HR_KI_USER_INTERFACES.TYPE'
138: )
139: THEN
140: hr_utility.set_location(' Leaving:'|| l_proc,40);
141: raise;

Line 194: hr_ki_user_interfaces itf

190: CURSOR csr_form_unique is
191: select
192: 'found'
193: From
194: hr_ki_user_interfaces itf
195: Where
196: itf.type = p_type
197: and itf.form_name = p_form_name
198: and (p_user_interface_id is null or

Line 228: 'HR_KI_USER_INTERFACES.TYPE'

224: close csr_form;
225:
226: if hr_multi_message.no_exclusive_error
227: (p_check_column1 =>
228: 'HR_KI_USER_INTERFACES.TYPE'
229: )
230: then
231:
232: -- checking for a duplicate record

Line 252: (p_associated_column1 => 'HR_KI_USER_INTERFACES.FORM_NAME'

248:
249: Exception
250: when app_exception.application_exception then
251: IF hr_multi_message.exception_add
252: (p_associated_column1 => 'HR_KI_USER_INTERFACES.FORM_NAME'
253: )
254: THEN
255: hr_utility.set_location(' Leaving:'|| l_proc,30);
256: raise;

Line 309: from hr_ki_user_interfaces itf

305: cur_page_region_code varchar2,
306: cur_region_code varchar2,
307: cur_user_interface_id number) is
308: select 'found'
309: from hr_ki_user_interfaces itf
310: where
311: itf.type = cur_type
312: and itf.page_region_code = cur_page_region_code
313: and (cur_region_code is null or itf.region_code = cur_region_code)

Line 340: 'HR_KI_USER_INTERFACES.TYPE'

336: close csr_form_functions;
337:
338: if hr_multi_message.no_exclusive_error
339: (p_check_column1 =>
340: 'HR_KI_USER_INTERFACES.TYPE'
341: )
342: then
343: open csr_reg_unique_check(p_type,
344: p_page_region_code,

Line 363: (p_associated_column1 => 'HR_KI_USER_INTERFACES.PAGE_REGION_CODE',

359:
360: Exception
361: when app_exception.application_exception then
362: IF hr_multi_message.exception_add
363: (p_associated_column1 => 'HR_KI_USER_INTERFACES.PAGE_REGION_CODE',
364: p_associated_column2 => 'HR_KI_USER_INTERFACES.REGION_CODE'
365: )
366: THEN
367: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 364: p_associated_column2 => 'HR_KI_USER_INTERFACES.REGION_CODE'

360: Exception
361: when app_exception.application_exception then
362: IF hr_multi_message.exception_add
363: (p_associated_column1 => 'HR_KI_USER_INTERFACES.PAGE_REGION_CODE',
364: p_associated_column2 => 'HR_KI_USER_INTERFACES.REGION_CODE'
365: )
366: THEN
367: hr_utility.set_location(' Leaving:'|| l_proc,30);
368: raise;

Line 420: 'HR_KI_USER_INTERFACES.TYPE'

416: hr_utility.set_location(' Entering:' || l_proc,10);
417:
418: if hr_multi_message.no_exclusive_error
419: (p_check_column1 =>
420: 'HR_KI_USER_INTERFACES.TYPE'
421: )
422: then
423:
424: if(p_type = g_form_const and

Line 450: (p_associated_column1 => 'HR_KI_USER_INTERFACES.TYPE',

446:
447: Exception
448: when app_exception.application_exception then
449: IF hr_multi_message.exception_add
450: (p_associated_column1 => 'HR_KI_USER_INTERFACES.TYPE',
451: p_associated_column2 => 'HR_KI_USER_INTERFACES.FORM_NAME',
452: p_associated_column3 => 'HR_KI_USER_INTERFACES.PAGE_REGION_CODE'
453: )
454: THEN

Line 451: p_associated_column2 => 'HR_KI_USER_INTERFACES.FORM_NAME',

447: Exception
448: when app_exception.application_exception then
449: IF hr_multi_message.exception_add
450: (p_associated_column1 => 'HR_KI_USER_INTERFACES.TYPE',
451: p_associated_column2 => 'HR_KI_USER_INTERFACES.FORM_NAME',
452: p_associated_column3 => 'HR_KI_USER_INTERFACES.PAGE_REGION_CODE'
453: )
454: THEN
455: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 452: p_associated_column3 => 'HR_KI_USER_INTERFACES.PAGE_REGION_CODE'

448: when app_exception.application_exception then
449: IF hr_multi_message.exception_add
450: (p_associated_column1 => 'HR_KI_USER_INTERFACES.TYPE',
451: p_associated_column2 => 'HR_KI_USER_INTERFACES.FORM_NAME',
452: p_associated_column3 => 'HR_KI_USER_INTERFACES.PAGE_REGION_CODE'
453: )
454: THEN
455: hr_utility.set_location(' Leaving:'|| l_proc,30);
456: raise;

Line 470: -- rows for a record in hr_ki_user_interfaces. The tables that contain child

466: -- {Start Of Comments}
467: --
468: -- Description:
469: -- This procedure ensures that a delete occurs only if there are no child
470: -- rows for a record in hr_ki_user_interfaces. The tables that contain child
471: -- rows are hr_ki_hierarchy_node_maps.
472:
473: -- Pre Conditions:
474: -- g_rec has been populated with details of the values

Line 525: 'HR_KI_USER_INTERFACES.USER_INTERFACE_ID'

521: Exception
522: when app_exception.application_exception then
523: IF hr_multi_message.exception_add
524: (p_associated_column1 =>
525: 'HR_KI_USER_INTERFACES.USER_INTERFACE_ID'
526: )THEN
527: hr_utility.set_location(' Leaving:'|| l_proc,30);
528: raise;
529: END IF;