DBA Data[Home] [Help]

APPS.PER_ENT_BUS dependencies on HR_UTILITY

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

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

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

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

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := per_ent_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

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

145: close csr_leg_code;
146: per_ent_bus.g_calendar_entry_id := p_calendar_entry_id;
147: per_ent_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

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

247: l_proc varchar2(72) := g_package||'chk_name';
248: --
249: Begin
250: --
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: IF p_name IS NULL THEN
254: -- Add to MM list as non-fatal
255: fnd_message.set_name('PER','PER_289958_CAL_NAME_NULL');

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

257: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.NAME');
258: --
259: END IF;
260: --
261: hr_utility.set_location('Leaving:'||l_proc, 40);
262: --
263: End chk_name;
264: --
265: --

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

285: l_proc varchar2(72) := g_package||'chk_type';
286: --
287: Begin
288: --
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: --
292: -- Only proceed with validation if :
293: -- a) Inserting or

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

316: --
317: end if;
318: END IF;
319: --
320: hr_utility.set_location('Leaving:'||l_proc, 40);
321: --
322: End chk_type;
323:
324:

Line 382: hr_utility.set_location('Entering:'||l_proc, 1);

378: from PER_GEN_HIERARCHY_VERSIONS
379: where hierarchy_id = p_hierarchy_id;
380: --
381: begin
382: hr_utility.set_location('Entering:'||l_proc, 1);
383: --
384: -- Check mandatory incident_date is set
385: --
386: if p_start_date is null then

Line 467: hr_utility.set_location(' Leaving:'||l_proc, 5);

463: end if;
464:
465:
466:
467: hr_utility.set_location(' Leaving:'||l_proc, 5);
468: --
469: end chk_start_date_end_date;
470: --
471: --

Line 510: hr_utility.set_location('Entering:'||l_proc, 1);

506: l_proc varchar2(72) := g_package||'chk_no_entry_values_exist';
507: l_dummy varchar2(1);
508: --
509: Begin
510: hr_utility.set_location('Entering:'||l_proc, 1);
511: --
512: if p_calendar_entry_id is not null then
513: open csr_ev;
514: fetch csr_ev into l_dummy;

Line 524: hr_utility.set_location(' Leaving:'||l_proc, 5);

520: close csr_ev;
521: end if;
522: end if;
523: --
524: hr_utility.set_location(' Leaving:'||l_proc, 5);
525: --
526: End chk_no_entry_values_exist;
527:
528: --

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

601: l_proc varchar2(72) := g_package||'chk_valueset_or_hierarchy';
602: --
603: Begin
604: --
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607:
608: IF (p_value_set_id is not null and p_hierarchy_id is not null)
609: OR (p_value_set_id is not null and (p_organization_structure_id is not null or p_org_structure_version_id is not null))

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

625: AND ( (p_value_set_id is not null and per_ent_shd.g_old_rec.value_set_id is null)
626: OR (p_value_set_id is null and per_ent_shd.g_old_rec.value_set_id is not null)
627: OR (p_value_set_id is not null and p_value_set_id <> per_ent_shd.g_old_rec.value_set_id))) ) THEN
628:
629: hr_utility.set_location(l_proc, 10);
630:
631: if p_value_set_id is not NULL then
632: open csr_VS;
633: fetch csr_VS into l_dummy;

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

656: AND ( (p_hierarchy_id is not null and per_ent_shd.g_old_rec.hierarchy_id is null)
657: OR (p_hierarchy_id is null and per_ent_shd.g_old_rec.hierarchy_id is not null)
658: OR (p_hierarchy_id is not null and p_hierarchy_id <> per_ent_shd.g_old_rec.hierarchy_id))) ) THEN
659:
660: hr_utility.set_location(l_proc, 20);
661:
662: if p_hierarchy_id is not null then
663: open csr_HIER;
664: fetch csr_HIER into l_dummy;

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

698: and p_org_structure_version_id <> per_ent_shd.g_old_rec.org_structure_version_id)
699: OR (per_ent_shd.g_old_rec.organization_structure_id is not null
700: and p_organization_structure_id <> per_ent_shd.g_old_rec.organization_structure_id)) ) ) THEN
701:
702: hr_utility.set_location(l_proc, 30);
703:
704: open csr_ORG_HIER;
705: fetch csr_ORG_HIER into l_dummy;
706: if csr_ORG_HIER%notfound then

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

729: IF l_chk_evs THEN
730: -- validate that no child EV's exist
731: -- for this entry, otherwise prevent update
732:
733: hr_utility.set_location(l_proc, 30);
734: open csr_EV;
735: fetch csr_EV into l_dummy; -- coverage type 'V' or 'H' or 'O'
736: if csr_EV%found then
737: close csr_EV;

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

773:
774: --
775: END IF;
776: --
777: hr_utility.set_location('Leaving:'||l_proc, 40);
778: --
779: End chk_valueset_or_hierarchy;
780:
781: --

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

801: l_value varchar2(240) := 'DUMMY';
802: --
803: Begin
804: --
805: hr_utility.set_location('Entering:'||l_proc, 5);
806: --
807: IF p_legislation_code IS NOT NULL THEN
808: l_value := hr_general.DECODE_TERRITORY(P_TERRITORY_CODE => p_legislation_code);
809:

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

815: END IF;
816: --
817: END IF;
818: --
819: hr_utility.set_location('Leaving:'||l_proc, 40);
820: --
821: End chk_legislation_code;
822: --
823: -- ----------------------------------------------------------------------------

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

847: l_value varchar2(240):= null;
848: --
849: Begin
850: --
851: hr_utility.set_location('Entering:'||l_proc, 5);
852: --
853: IF p_identifier_key IS NOT NULL THEN
854: open c_unique;
855: fetch c_unique into l_value;

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

864: END IF;
865: --
866: END IF;
867: --
868: hr_utility.set_location('Leaving:'||l_proc, 40);
869: --
870: End chk_identifier_key;
871:
872: --

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

893: l_value varchar2(240) := 'DUMMY';
894: --
895: Begin
896: --
897: hr_utility.set_location('Entering:'||l_proc, 5);
898: --
899: IF (p_legislation_code IS NOT NULL AND p_identifier_key IS NULL)
900: OR (p_legislation_code IS NULL AND p_identifier_key IS NOT NULL) THEN
901:

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

905: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.LEGISLATION_CODE'
906: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.IDENTIFIER_KEY');
907: END IF;
908: --
909: hr_utility.set_location('Leaving:'||l_proc, 40);
910: --
911: End chk_id_leg_comb;
912:
913: --

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

921: --
922: l_proc varchar2(72) := g_package||'insert_validate';
923: --
924: Begin
925: hr_utility.set_location('Entering:'||l_proc, 5);
926: --
927: -- Call all supporting business operations
928: --
929: If p_rec.business_group_id is not null then

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

987: --
988: -- Validate Dependent Attributes
989: --
990: --
991: hr_utility.set_location(' Leaving:'||l_proc, 10);
992: End insert_validate;
993: --
994: -- ----------------------------------------------------------------------------
995: -- |---------------------------< update_validate >----------------------------|

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

1001: --
1002: l_proc varchar2(72) := g_package||'update_validate';
1003: --
1004: Begin
1005: hr_utility.set_location('Entering:'||l_proc, 5);
1006: --
1007: -- Call all supporting business operations
1008: --
1009: If p_rec.business_group_id is not null then

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

1061: ,p_org_structure_version_id => p_rec.org_structure_version_id);
1062:
1063: --
1064: --
1065: hr_utility.set_location(' Leaving:'||l_proc, 10);
1066: End update_validate;
1067: --
1068: -- ----------------------------------------------------------------------------
1069: -- |---------------------------< delete_validate >----------------------------|

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

1074: --
1075: l_proc varchar2(72) := g_package||'delete_validate';
1076: --
1077: Begin
1078: hr_utility.set_location('Entering:'||l_proc, 5);
1079: --
1080: -- Call all supporting business operations
1081: --
1082: -- NOTE: API deletes any child entry values before this call is made.

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

1084: -- delete the entry itself.
1085: chk_no_entry_values_exist(p_calendar_entry_id => p_rec.calendar_entry_id);
1086: --
1087: --
1088: hr_utility.set_location(' Leaving:'||l_proc, 10);
1089: End delete_validate;
1090: --
1091: end per_ent_bus;