eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PGT_BUS dependencies on PER_GEN_HIER_NODE_TYPES

Line 30: , per_gen_hier_node_types pgt

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_gen_hier_node_types pgt
31: where pgt.hier_node_type_id = p_hier_node_type_id
32: and pbg.business_group_id = pgt.business_group_id;
33: --
34: -- Declare local variables

Line 94: , per_gen_hier_node_types pgt

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_gen_hier_node_types pgt
95: where pgt.hier_node_type_id = p_hier_node_type_id
96: and pbg.business_group_id (+) = pgt.business_group_id;
97: --
98: -- Declare local variables

Line 272: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.HIERARCHY_TYPE') then

268: when app_exception.application_exception then
269: -- hierarchy_type requires independent validation,
270: -- catch any app exception raised above and place on stack or re-raise
271: If hr_multi_message.exception_add
272: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.HIERARCHY_TYPE') then
273: raise;
274: End If;
275: --
276: hr_utility.set_location('Leaving:'||l_proc, 50);

Line 312: FROM per_gen_hier_node_types

308: --
309: CURSOR csr_node(l_node_type varchar2
310: ,l_hierarchy_type varchar2) IS
311: SELECT 'X'
312: FROM per_gen_hier_node_types
313: WHERE child_node_type = l_node_type
314: AND hierarchy_type = l_hierarchy_type;
315: --
316: --

Line 321: FROM per_gen_hier_node_types

317: -- CSR to test if top node exists in hierarchy
318: --
319: CURSOR csr_top_node (l_hierarchy_type varchar2) IS
320: SELECT 'X'
321: FROM per_gen_hier_node_types
322: WHERE parent_node_type is null
323: AND hierarchy_type = l_hierarchy_type;
324: --
325: --

Line 348: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');

344: If p_child_node_type IS NULL then
345: -- child node type requires independent validation here
346: fnd_message.set_name('PER', 'HR_289904_PGT_CNODE_TYPE_NULL');
347: hr_multi_message.add
348: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');
349: Else
350: --
351: -- Validate child_node_type on insert only (non-updateable) lookup code
352: --

Line 364: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');

360: l_err_flag := true;
361: fnd_message.set_name('PER', 'HR_289906_PGT_CNODE_TYPE_INV');
362: -- independently validated
363: hr_multi_message.add
364: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');
365: End If;
366: --
367: hr_utility.set_location(l_proc, 10);
368: --

Line 370: hr_multi_message.no_exclusive_error('PER_GEN_HIER_NODE_TYPES.HIERARCHY_TYPE') then

366: --
367: hr_utility.set_location(l_proc, 10);
368: --
369: If not(l_err_flag) and
370: hr_multi_message.no_exclusive_error('PER_GEN_HIER_NODE_TYPES.HIERARCHY_TYPE') then
371: --
372: -- only proceed with validation if err not raised already on child_node
373: -- nor on hierarchy_type fields
374: --

Line 386: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');

382: l_err_flag := TRUE;
383: fnd_message.set_name('PER', 'HR_289905_PGT_CNODE_NOT_UNQ');
384: -- conditionally independently validated
385: hr_multi_message.add
386: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');
387: Else
388: Close csr_node;
389: End if;
390: --

Line 400: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');

396: fnd_message.set_name('PER', 'HR_289907_PGT_CNODE_IS_PNODE');
397: -- conditionally independently validated
398: l_err_flag := TRUE;
399: hr_multi_message.add
400: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');
401: End If;
402:
403: End If;
404: End If;

Line 428: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');

424: l_err_parent_flag := TRUE;
425: fnd_message.set_name('PER', 'HR_289908_PGT_PNODE_TYPE_INV');
426: -- independently validated
427: hr_multi_message.add
428: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');
429: --
430: End If;
431: --
432: hr_utility.set_location(l_proc, 30);

Line 435: hr_multi_message.no_exclusive_error('PER_GEN_HIER_NODE_TYPES.HIERARCHY_TYPE') then

431: --
432: hr_utility.set_location(l_proc, 30);
433: --
434: If not(l_err_parent_flag) and
435: hr_multi_message.no_exclusive_error('PER_GEN_HIER_NODE_TYPES.HIERARCHY_TYPE') then
436: --
437: -- only proceed with validation if err not raised already on parent_node
438: -- nor on hierarchy_type fields
439: --

Line 448: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');

444: If csr_node%notfound then
445: Close csr_node;
446: fnd_message.set_name('PER', 'HR_289909_PGT_PNODE_NOT_CNODE');
447: hr_multi_message.add
448: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');
449: Else
450: Close csr_node;
451: End If;
452: hr_utility.set_location(l_proc, 35);

Line 462: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');

458: per_pgt_shd.g_old_rec.child_node_type = p_parent_node_type)
459: then
460: fnd_message.set_name('PER', 'HR_289907_PGT_CNODE_IS_PNODE');
461: hr_multi_message.add
462: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');
463: End If;
464: End If;
465: End If;
466: Else

Line 468: If (hr_multi_message.no_exclusive_error('PER_GEN_HIER_NODE_TYPES.HIERARCHY_TYPE')

464: End If;
465: End If;
466: Else
467: hr_utility.set_location(l_proc, 40);
468: If (hr_multi_message.no_exclusive_error('PER_GEN_HIER_NODE_TYPES.HIERARCHY_TYPE')
469: and p_hier_node_type_id is null or (p_hier_node_type_id is not null
470: and per_pgt_shd.g_old_rec.parent_node_type IS NOT NULL )) then
471: -- parent node is null so if ins or upd and this isnt already top node
472: -- confirm that we can set this node as the top node

Line 480: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');

476: If csr_top_node%found then
477: Close csr_top_node;
478: fnd_message.set_name('PER', 'HR_289910_PGT_TOP_NODE_DUP');
479: hr_multi_message.add
480: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');
481: Else
482: Close csr_top_node;
483: End If;
484: End If;

Line 569: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_VALUE_SET') then

565: --
566: Exception
567: when app_exception.application_exception then
568: If hr_multi_message.exception_add
569: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_VALUE_SET') then
570: hr_utility.set_location('Leaving:'||l_proc, 40);
571: raise;
572: End If;
573: --