DBA Data[Home] [Help]

APPS.IRC_INO_BUS dependencies on HR_UTILITY

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

29: l_legislation_code varchar2(150);
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Ensure that all the mandatory parameter are not null
36: --
37: hr_api.mandatory_arg_error

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

40: ,p_argument_value => p_note_id
41: );
42: --
43: --
44: hr_utility.set_location(' Leaving:'|| l_proc, 20);
45: --
46: end set_security_group_id;
47: --
48: -- ---------------------------------------------------------------------------

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

60: l_proc varchar2(72) := g_package||'return_legislation_code';
61: --
62: Begin
63: --
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Ensure that all the mandatory parameter are not null
67: --
68: hr_api.mandatory_arg_error

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

70: ,p_argument => 'note_id'
71: ,p_argument_value => p_note_id
72: );
73: --
74: hr_utility.set_location(' Leaving:'|| l_proc, 40);
75: return l_legislation_code;
76: end return_legislation_code;
77: --
78: -- ----------------------------------------------------------------------------

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

183: where offer_status_history_id = p_offer_status_history_id;
184: --
185: Begin
186: --
187: hr_utility.set_location(' Entering:'||l_proc,10);
188: --
189: -- Check if the offer status history id is valid.
190: --
191: open csr_offer_status_history_id;

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

189: -- Check if the offer status history id is valid.
190: --
191: open csr_offer_status_history_id;
192: fetch csr_offer_status_history_id into l_num;
193: hr_utility.set_location(l_proc,20);
194: if csr_offer_status_history_id%notfound then
195: close csr_offer_status_history_id;
196: hr_utility.set_message(800,'IRC_412325_INV_OFFER_HISTORYID');
197: hr_utility.raise_error;

Line 196: hr_utility.set_message(800,'IRC_412325_INV_OFFER_HISTORYID');

192: fetch csr_offer_status_history_id into l_num;
193: hr_utility.set_location(l_proc,20);
194: if csr_offer_status_history_id%notfound then
195: close csr_offer_status_history_id;
196: hr_utility.set_message(800,'IRC_412325_INV_OFFER_HISTORYID');
197: hr_utility.raise_error;
198: end if;
199: close csr_offer_status_history_id;
200: hr_utility.set_location(l_proc,30);

Line 197: hr_utility.raise_error;

193: hr_utility.set_location(l_proc,20);
194: if csr_offer_status_history_id%notfound then
195: close csr_offer_status_history_id;
196: hr_utility.set_message(800,'IRC_412325_INV_OFFER_HISTORYID');
197: hr_utility.raise_error;
198: end if;
199: close csr_offer_status_history_id;
200: hr_utility.set_location(l_proc,30);
201: --

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

196: hr_utility.set_message(800,'IRC_412325_INV_OFFER_HISTORYID');
197: hr_utility.raise_error;
198: end if;
199: close csr_offer_status_history_id;
200: hr_utility.set_location(l_proc,30);
201: --
202: exception
203: when app_exception.application_exception then
204: if hr_multi_message.exception_add

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

204: if hr_multi_message.exception_add
205: (p_associated_column1 =>
206: 'irc_notes.offer_status_history_id'
207: ) then
208: hr_utility.set_location(' Leaving:'||l_proc,50);
209: raise;
210: end if;
211: --
212: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 212: hr_utility.set_location(' Leaving:'||l_proc,60);

208: hr_utility.set_location(' Leaving:'||l_proc,50);
209: raise;
210: end if;
211: --
212: hr_utility.set_location(' Leaving:'||l_proc,60);
213: End chk_offer_status_history_id;
214: --
215: -- ----------------------------------------------------------------------------
216: -- |---------------------------< insert_validate >----------------------------|

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

221: --
222: l_proc varchar2(72) := g_package||'insert_validate';
223: --
224: Begin
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: -- Call all supporting business operations
228: -- Validate Dependent Attributes
229: --

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

236: chk_offer_status_history_id
237: (p_offer_status_history_id => p_rec.offer_status_history_id
238: );
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: End insert_validate;
242: --
243: -- ----------------------------------------------------------------------------
244: -- |---------------------------< update_validate >----------------------------|

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

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

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

260: (p_rec => p_rec
261: );
262: --
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End update_validate;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |---------------------------< delete_validate >----------------------------|

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

273: --
274: l_proc varchar2(72) := g_package||'delete_validate';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- Call all supporting business operations
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- Call all supporting business operations
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 10);
282: End delete_validate;
283: --
284: end irc_ino_bus;