DBA Data[Home] [Help]

APPS.IRC_RAV_BUS dependencies on HR_UTILITY

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

48: from per_gen_hierarchy_versions
49: where hierarchy_version_id = p_hierarchy_version_id;
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc,10);
53: --
54: hr_api.mandatory_arg_error
55: (p_api_name => l_proc
56: ,p_argument => 'hierarchy_version_id'

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

59: --
60: open csr_chk_hierarchy_version_id;
61: fetch csr_chk_hierarchy_version_id into l_hierarchy_version_id;
62: --
63: hr_utility.set_location(l_proc,15);
64: if (csr_chk_hierarchy_version_id%notfound) then
65: close csr_chk_hierarchy_version_id;
66: fnd_message.set_name('PER','IRC_412659_INV_HIERARCHY_ID');
67: fnd_message.raise_error;

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

68: end if;
69: --
70: close csr_chk_hierarchy_version_id;
71: --
72: hr_utility.set_location(' Leaving:'||l_proc,20);
73: exception
74: when app_exception.application_exception then
75: if hr_multi_message.exception_add
76: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.HIERARCHY_VERSION_ID'

Line 78: hr_utility.set_location(' Leaving:'|| l_proc, 25);

74: when app_exception.application_exception then
75: if hr_multi_message.exception_add
76: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.HIERARCHY_VERSION_ID'
77: ) then
78: hr_utility.set_location(' Leaving:'|| l_proc, 25);
79: raise;
80: end if;
81: hr_utility.set_location(' Leaving:'|| l_proc, 30);
82: End chk_hierarchy_version_id;

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

77: ) then
78: hr_utility.set_location(' Leaving:'|| l_proc, 25);
79: raise;
80: end if;
81: hr_utility.set_location(' Leaving:'|| l_proc, 30);
82: End chk_hierarchy_version_id;
83: --
84: -- ----------------------------------------------------------------------------
85: -- |-------------------------< chk_duplicate_vac_rec_area >-------------------|

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

120: where vacancy_id = p_vacancy_id
121: and hierarchy_version_id = p_hierarchy_version_id;
122: --
123: Begin
124: hr_utility.set_location('Entering:'||l_proc,10);
125: --
126: open csr_chk_duplicate_rec_area;
127: fetch csr_chk_duplicate_rec_area into l_count;
128: --

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

125: --
126: open csr_chk_duplicate_rec_area;
127: fetch csr_chk_duplicate_rec_area into l_count;
128: --
129: hr_utility.set_location(l_proc,15);
130: if (csr_chk_duplicate_rec_area%found) then
131: close csr_chk_duplicate_rec_area;
132: fnd_message.set_name('PER','IRC_412660_DUP_REC_AREAS');
133: fnd_message.raise_error;

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

134: end if;
135: --
136: close csr_chk_duplicate_rec_area;
137: --
138: hr_utility.set_location(' Leaving:'||l_proc,20);
139: exception
140: when app_exception.application_exception then
141: if hr_multi_message.exception_add
142: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.VACANCY_ID'

Line 145: hr_utility.set_location(' Leaving:'|| l_proc, 25);

141: if hr_multi_message.exception_add
142: (p_associated_column1 => 'IRC_VAC_REC_AREA_VALUES.VACANCY_ID'
143: ,p_associated_column2 => 'IRC_VAC_REC_AREA_VALUES.HIERARCHY_VERSION_ID'
144: ) then
145: hr_utility.set_location(' Leaving:'|| l_proc, 25);
146: raise;
147: end if;
148: hr_utility.set_location(' Leaving:'|| l_proc, 30);
149: End chk_duplicate_vac_rec_area;

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

144: ) then
145: hr_utility.set_location(' Leaving:'|| l_proc, 25);
146: raise;
147: end if;
148: hr_utility.set_location(' Leaving:'|| l_proc, 30);
149: End chk_duplicate_vac_rec_area;
150: --
151: -- ----------------------------------------------------------------------------
152: -- |-----------------------< chk_non_updateable_args >------------------------|

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

212: --
213: l_proc varchar2(72) := g_package||'insert_validate';
214: --
215: Begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: -- Call all supporting business operations
219: --
220: --

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

227: --
228: -- Validate Dependent Attributes
229: --
230: --
231: hr_utility.set_location(l_proc, 10);
232: --
233: irc_rav_bus.chk_hierarchy_version_id
234: (p_hierarchy_version_id => p_rec.hierarchy_version_id
235: );

Line 241: hr_utility.set_location(' Leaving:'||l_proc, 15);

237: /* irc_rav_bus.chk_duplicate_vac_rec_area
238: ( p_vacancy_id => p_rec.vacancy_id
239: ,p_hierarchy_version_id => p_rec.hierarchy_version_id
240: ); */
241: hr_utility.set_location(' Leaving:'||l_proc, 15);
242: End insert_validate;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |---------------------------< update_validate >----------------------------|

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

251: --
252: l_proc varchar2(72) := g_package||'update_validate';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: -- Call all supporting business operations
258: --
259: --

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

271: ,p_rec => p_rec
272: );
273: --
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 10);
276: End update_validate;
277: --
278: -- ----------------------------------------------------------------------------
279: -- |---------------------------< delete_validate >----------------------------|

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

284: --
285: l_proc varchar2(72) := g_package||'delete_validate';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Call all supporting business operations
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Call all supporting business operations
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: End delete_validate;
294: --
295: end irc_rav_bus;