DBA Data[Home] [Help]

APPS.PER_ENV_BUS dependencies on HR_UTILITY

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

40: l_proc varchar2(72) := g_package||'set_security_group_id';
41: --
42: begin
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error

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

75: (p_security_group_id => l_security_group_id
76: );
77: end if;
78: --
79: hr_utility.set_location(' Leaving:'|| l_proc, 20);
80: --
81: end set_security_group_id;
82: --
83: -- ---------------------------------------------------------------------------

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

106: l_proc varchar2(72) := g_package||'return_legislation_code';
107: --
108: Begin
109: --
110: hr_utility.set_location('Entering:'|| l_proc, 10);
111: --
112: -- Ensure that all the mandatory parameter are not null
113: --
114: hr_api.mandatory_arg_error

Line 128: hr_utility.set_location(l_proc, 20);

124: -- call to this function. Just return the value in the global
125: -- variable.
126: --
127: l_legislation_code := per_env_bus.g_legislation_code;
128: hr_utility.set_location(l_proc, 20);
129: else
130: --
131: -- The ID is different to the last call to this function
132: -- or this is the first call to this function.

Line 145: hr_utility.set_location(l_proc,30);

141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --
147: -- Set the global variables so the values are
148: -- available for the next call to this function.
149: --

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

150: close csr_leg_code;
151: per_env_bus.g_cal_entry_value_id := p_cal_entry_value_id;
152: per_env_bus.g_legislation_code := l_legislation_code;
153: end if;
154: hr_utility.set_location(' Leaving:'|| l_proc, 40);
155: return l_legislation_code;
156: end return_legislation_code;
157: --
158: -- ----------------------------------------------------------------------------

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

244: WHERE ent.calendar_entry_id = p_calendar_entry_id;
245: --
246: Begin
247: --
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: If p_calendar_entry_id IS NULL then
251: -- raise as serious error, no point doing other checks
252: fnd_message.set_name('PER', 'PER_289976_CAL_ENT_NULL');

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

265: end if;
266: End if;
267: --
268: --
269: hr_utility.set_location('Leaving:'||l_proc, 50);
270: --
271: End chk_calendar_entry_id;
272: --
273: --

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

326: AND env.calendar_entry_id = p_calendar_entry_id;
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: hr_api.mandatory_arg_error
333: (p_api_name => l_proc
334: ,p_argument => 'calendar_entry_id'

Line 348: hr_utility.set_location(l_proc, 15);

344: close CSR_ENTRY;
345: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');
346: fnd_message.raise_error;
347: else
348: hr_utility.set_location(l_proc, 15);
349: close CSR_ENTRY;
350: if l_id IS NULL then
351: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');
352: fnd_message.raise_error;

Line 354: hr_utility.set_location(l_proc, 25);

350: if l_id IS NULL then
351: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');
352: fnd_message.raise_error;
353: else
354: hr_utility.set_location(l_proc, 25);
355: open CSR_GEN_HIER(l_id);
356: fetch CSR_GEN_HIER into l_dummy;
357: if CSR_GEN_HIER%notfound then
358: close CSR_GEN_HIER;

Line 366: hr_utility.set_location(l_proc, 35);

362: else
363: close CSR_GEN_HIER;
364: end if;
365:
366: hr_utility.set_location(l_proc, 35);
367: open CSR_ENT_VAL;
368: fetch CSR_ENT_VAL into l_dummy;
369: if CSR_ENT_VAL%found then
370: close CSR_ENT_VAL;

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

379: end if;
380: END IF;
381: --
382: --
383: hr_utility.set_location('Leaving:'||l_proc, 50);
384: --
385: End chk_hierarchy_node_id;
386: --
387: --

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

417: AND ent.hierarchy_id is NULL;
418: --
419: Begin
420: --
421: hr_utility.set_location('Entering:'||l_proc, 5);
422: --
423: hr_api.mandatory_arg_error
424: (p_api_name => l_proc
425: ,p_argument => 'calendar_entry_id'

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

442:
443: end if;
444: END IF;
445: --
446: hr_utility.set_location('Leaving:'||l_proc, 50);
447: --
448: End chk_value;
449:
450: --

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

472: l_proc varchar2(72) := g_package||'chk_comb_fks_valid';
473: --
474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: IF (p_hierarchy_node_id is null and p_value is null
479: and p_org_structure_element_id is null)
480: OR (p_hierarchy_node_id is not null and p_value is not null)

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

485: fnd_message.raise_error;
486: END IF;
487: --
488: --
489: hr_utility.set_location('Leaving:'||l_proc, 50);
490: --
491: End chk_comb_fks_valid;
492: --
493: --

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

533: l_name per_cal_entry_values.override_name%type;
534: --
535: Begin
536: --
537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: IF (p_cal_entry_value_id is NULL
540: or (p_usage_flag <> per_env_shd.g_old_rec.usage_flag)
541: or (nvl(p_override_name,hr_api.g_varchar2)

Line 559: hr_utility.set_location(l_proc, 10);

555: fnd_message.set_name('PER', 'HR_289993_CAL_OVERN_SET');
556: fnd_message.raise_error;
557: End if;
558: --
559: hr_utility.set_location(l_proc, 10);
560: IF p_override_type is not null then
561: IF p_usage_flag = 'Y' then
562: -- exceptions must not have an override type - convert to MM
563: fnd_message.set_name('PER', 'HR_289994_CAL_OVERT_SET');

Line 579: hr_utility.set_location(l_proc, 20);

575: end if;
576: END IF;
577: End if;
578:
579: hr_utility.set_location(l_proc, 20);
580:
581: IF p_override_type is not null or p_override_name is not null then
582: -- validate that the override values differ from the parent...
583: open CSR_OVR;

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

594: End if;
595: --
596: END IF;
597: --
598: hr_utility.set_location('Leaving:'||l_proc, 30);
599: --
600: End chk_override_name_type;
601: --
602: --

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

641: l_proc varchar2(80) := g_package||'chk_comb_usage_parentev_id';
642: --
643: Begin
644: --
645: hr_utility.set_location('Entering:'||l_proc, 5);
646: --
647: --
648: IF (p_cal_entry_value_id is NULL
649: or (nvl(p_parent_entry_value_id,hr_api.g_number)

Line 677: hr_utility.set_location(l_proc, 10);

673: fnd_message.set_name('PER', 'HR_289999_CAL_PARENT_NULL');
674: fnd_message.raise_error;
675: End if;
676:
677: hr_utility.set_location(l_proc, 10);
678:
679: If p_parent_entry_value_id is not NULL then
680: -- if we get here, we can proceed with validating the parent coverage id
681:

Line 692: hr_utility.set_location(l_proc, 20);

688: fnd_message.raise_error;
689: Else
690: close CSR_EV;
691:
692: hr_utility.set_location(l_proc, 20);
693: If p_calendar_entry_id <> l_parent_entry_id then
694: -- parent EV exists for a different calendar entry
695: fnd_message.set_name('PER', 'PER_289985_CAL_PARENT_INV2');
696: fnd_message.raise_error;

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

705: End if;
706: --
707: End if;
708: --
709: hr_utility.set_location('Leaving:'||l_proc, 30);
710: --
711: End CHK_COMB_USAGE_PARENTEV_ID;
712:
713: -- ----------------------------------------------------------------------------

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

737: l_value varchar2(240):= null;
738: --
739: Begin
740: --
741: hr_utility.set_location('Entering:'||l_proc, 5);
742: --
743: IF p_identifier_key IS NOT NULL THEN
744: open c_unique;
745: fetch c_unique into l_value;

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

754: END IF;
755: --
756: END IF;
757: --
758: hr_utility.set_location('Leaving:'||l_proc, 40);
759: --
760: End chk_identifier_key;
761:
762: --

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

771: --
772: l_proc varchar2(72) := g_package||'insert_validate';
773: --
774: Begin
775: hr_utility.set_location('Entering:'||l_proc, 5);
776: --
777: -- Call all supporting business operations
778: --
779: --

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

812: -- chk_identifier_key(p_rec.identifier_key);
813: --
814: --
815: --
816: hr_utility.set_location(' Leaving:'||l_proc, 10);
817: End insert_validate;
818: --
819: -- ----------------------------------------------------------------------------
820: -- |---------------------------< update_validate >----------------------------|

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

826: --
827: l_proc varchar2(72) := g_package||'update_validate';
828: --
829: Begin
830: hr_utility.set_location('Entering:'||l_proc, 5);
831: --
832: -- Call all supporting business operations
833: --
834: -- Validate Dependent Attributes

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

853: ,p_rec.override_type
854: ,p_effective_date);
855: --
856: --
857: hr_utility.set_location(' Leaving:'||l_proc, 10);
858: End update_validate;
859: --
860: -- ----------------------------------------------------------------------------
861: -- |---------------------------< delete_validate >----------------------------|

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

866: --
867: l_proc varchar2(72) := g_package||'delete_validate';
868: --
869: Begin
870: hr_utility.set_location('Entering:'||l_proc, 5);
871: --
872: -- Call all supporting business operations
873: --
874: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

870: hr_utility.set_location('Entering:'||l_proc, 5);
871: --
872: -- Call all supporting business operations
873: --
874: hr_utility.set_location(' Leaving:'||l_proc, 10);
875: End delete_validate;
876: --
877: end per_env_bus;