DBA Data[Home] [Help]

APPS.IRC_JBI_BUS dependencies on HR_UTILITY

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

63: and effective_end_date;
64: --
65: Begin
66: --
67: hr_utility.set_location(' Entering:'||l_proc,10);
68: --
69: --
70: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
71: --

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

70: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
71: --
72: open csr_person_id;
73: fetch csr_person_id into l_party_id;
74: hr_utility.set_location(l_proc, 30);
75: if csr_person_id%notfound then
76: close csr_person_id;
77: fnd_message.set_name('PER','IRC_412157_PARTY_PERS_MISMTCH');
78: fnd_message.raise_error;

Line 90: hr_utility.set_location(' Leaving:'||l_proc,70);

86: else
87: p_party_id:=l_party_id;
88: end if;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc,70);
91: exception
92: when app_exception.application_exception then
93: if hr_multi_message.exception_add
94: (p_associated_column1 => 'IRC_JOB_BASKET_ITEMS.PARTY_ID'

Line 96: hr_utility.set_location(' Leaving:'|| l_proc, 80);

92: when app_exception.application_exception then
93: if hr_multi_message.exception_add
94: (p_associated_column1 => 'IRC_JOB_BASKET_ITEMS.PARTY_ID'
95: ) then
96: hr_utility.set_location(' Leaving:'|| l_proc, 80);
97: raise;
98: end if;
99: hr_utility.set_location(' Leaving:'|| l_proc, 90);
100: --

Line 99: hr_utility.set_location(' Leaving:'|| l_proc, 90);

95: ) then
96: hr_utility.set_location(' Leaving:'|| l_proc, 80);
97: raise;
98: end if;
99: hr_utility.set_location(' Leaving:'|| l_proc, 90);
100: --
101: End chk_person_id;
102: --
103: -- ----------------------------------------------------------------------------

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

112: where recruitment_activity_id = p_recruitment_activity_id;
113: l_proc varchar2(72) := g_package||'chk_recruitment_activity_id';
114: begin
115: --
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: open csr_recruitment_activity_id(p_recruitment_activity_id);
119: if csr_recruitment_activity_id%notfound then
120: close csr_recruitment_activity_id;

Line 121: hr_utility.set_message(800,'IRC_412044_JBI_INV_REC_ACT_ID');

117: --
118: open csr_recruitment_activity_id(p_recruitment_activity_id);
119: if csr_recruitment_activity_id%notfound then
120: close csr_recruitment_activity_id;
121: hr_utility.set_message(800,'IRC_412044_JBI_INV_REC_ACT_ID');
122: hr_utility.raise_error;
123: end if;
124: close csr_recruitment_activity_id;
125: --

Line 122: hr_utility.raise_error;

118: open csr_recruitment_activity_id(p_recruitment_activity_id);
119: if csr_recruitment_activity_id%notfound then
120: close csr_recruitment_activity_id;
121: hr_utility.set_message(800,'IRC_412044_JBI_INV_REC_ACT_ID');
122: hr_utility.raise_error;
123: end if;
124: close csr_recruitment_activity_id;
125: --
126: hr_utility.set_location('Leaving:'|| l_proc, 20);

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

122: hr_utility.raise_error;
123: end if;
124: close csr_recruitment_activity_id;
125: --
126: hr_utility.set_location('Leaving:'|| l_proc, 20);
127: end;
128: --
129: -- ----------------------------------------------------------------------------
130: -- |---------------------------< chk_unique_item >----------------------------|

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

140:
141: l_proc varchar2(72) := g_package||'chk_unique_item';
142: begin
143: --
144: hr_utility.set_location('Entering:'|| l_proc, 10);
145: --
146: open csr_unique_prim_key(p_job_basket_item_id);
147: if csr_unique_prim_key%found then
148: close csr_unique_prim_key;

Line 149: hr_utility.set_message(800,'IRC_412043_JBI_INV_COMP_PK');

145: --
146: open csr_unique_prim_key(p_job_basket_item_id);
147: if csr_unique_prim_key%found then
148: close csr_unique_prim_key;
149: hr_utility.set_message(800,'IRC_412043_JBI_INV_COMP_PK');
150: hr_utility.raise_error;
151: end if;
152: close csr_unique_prim_key;
153: --

Line 150: hr_utility.raise_error;

146: open csr_unique_prim_key(p_job_basket_item_id);
147: if csr_unique_prim_key%found then
148: close csr_unique_prim_key;
149: hr_utility.set_message(800,'IRC_412043_JBI_INV_COMP_PK');
150: hr_utility.raise_error;
151: end if;
152: close csr_unique_prim_key;
153: --
154: hr_utility.set_location('Leaving:'|| l_proc, 20);

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

150: hr_utility.raise_error;
151: end if;
152: close csr_unique_prim_key;
153: --
154: hr_utility.set_location('Leaving:'|| l_proc, 20);
155: end;
156: --
157: -- ---------------------------------------------------------------------------
158: -- |----------------------< set_security_group_id >--------------------------|

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

179: l_proc varchar2(72) := g_package||'set_security_group_id';
180: --
181: begin
182: --
183: hr_utility.set_location('Entering:'|| l_proc, 10);
184: --
185: -- Ensure that all the mandatory parameter are not null
186: --
187: hr_api.mandatory_arg_error

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

215: hr_api.set_security_group_id
216: (p_security_group_id => l_security_group_id
217: );
218: --
219: hr_utility.set_location(' Leaving:'|| l_proc, 20);
220: --
221: end set_security_group_id;
222: --
223: -- ---------------------------------------------------------------------------

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

237: l_proc varchar2(72) := g_package||'return_legislation_code';
238: --
239: Begin
240: --
241: hr_utility.set_location('Entering:'|| l_proc, 10);
242: --
243: -- Ensure that all the mandatory parameter are not null
244: --
245: hr_api.mandatory_arg_error

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

248: ,p_argument_value => p_job_basket_item_id
249: );
250: --
251:
252: hr_utility.set_location(' Leaving:'|| l_proc, 40);
253: return l_legislation_code;
254: end return_legislation_code;
255:
256: --

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

323: --
324: l_proc varchar2(72) := g_package||'insert_validate';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Call all supporting business operations
330: --
331: chk_person_id

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

341: --
342: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."
343: --
344: --
345: hr_utility.set_location(' Leaving:'||l_proc, 10);
346: End insert_validate;
347: --
348: -- ----------------------------------------------------------------------------
349: -- |---------------------------< update_validate >----------------------------|

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

355: --
356: l_proc varchar2(72) := g_package||'update_validate';
357: --
358: Begin
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: -- Call all supporting business operations
362: --
363: --

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

360: --
361: -- Call all supporting business operations
362: --
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: End update_validate;
366: --
367: -- ----------------------------------------------------------------------------
368: -- |---------------------------< delete_validate >----------------------------|

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

373: --
374: l_proc varchar2(72) := g_package||'delete_validate';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call all supporting business operations
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call all supporting business operations
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: End delete_validate;
383: --
384: end irc_jbi_bus;